Loading data…
GL Lookup
Income and expense of a GL account, by memo
Income
Expense
Fill the Income side, the Expense side, or both; an empty side is left out. A record belongs to the first event whose word appears in its memo or item: “Cricket COI” matches cricket or COI; type “Cricket, COI” to see them apart.
Income
$0
—
Expense
$0
—
Net
$0
—
By Event
Tap a row for transactionsBy GL Account
By Month
Transactions
Member Dues
Minimum annual payments by member
Members
0
Is Member = Y
Paid in full
0
—
Partial / On track
0
—
Unpaid
0
—
Members
Loading…
Filters
Loading…
Revenue
$0
— entries
Expenses
$0
— entries
Net Balance
$0
surplus
Transactions
0
records this period
Financial Health
⚠ Risk DetectedOperating Ratio
--%
Expenses ÷ Income · tap ›
Savings Rate
--%
Net ÷ Income · tap ›
Avg Monthly Income
--
Per active month · tap ›
Avg Monthly Expense
--
Per active month · tap ›
Surplus Months
--
Income > Expenses · tap ›
Best Month
--
--
Highest net surplus · tap ›
Donor Concentration
--%
Top 5 donors · tap ›
Vendor Concentration
--%
Top 5 vendors · tap ›
Top Donor
--
--
of total income · tap ›
Avg Monthly Net
--
Income − Expenses · tap ›
Monthly Trends
Jan – current month
Net by Classification
filteredIncome
--
Expenses
--
Net
--
Loading…
Income GL
Loading…
Expense GL
Loading…
Received From
Loading…
Vendors
Loading…
Income by Class
Tap segment to drill down
Loading…
Expenses by Class
Tap segment to drill down
Loading…
Recent Transactions
Loading...
Bank Balances
Opening + Income − Expense + Transfers In − Transfers Out
Loading…
Loading…
Loading…
Total Contributions
| Date | Receipt # | Purpose/GL | Amount |
|---|---|---|---|
| Total: | |||
System Settings
Application
Google Sheets - Main
Yearly Spreadsheets
Last 10 yearsEnter spreadsheet ID for each year. Dashboard will automatically combine current year + previous year data. All sheets must use the same sheet names.
Write Targets
Dashboard Sheets
Member Dues
Fee schedule for the Dashboard → Member Dues view. Members are Customer Master rows with Is Member = Y (column I). Each fee has a label, match keywords looked for in the receipt Purpose, an amount and times per year (minimum = amount × times). Leave blank for the defaults: Monthly Subscription $150 × 12, Cleaning Fee $150, Diocesan Fee $100, Catholicate $100.
Google Drive
User Management
Change Your PIN
Add User
Current Users
About Settings
Changes are saved to the .env file. A backup is created automatically before each save. Some settings (like Google credentials path) can only be changed by editing the file directly.