Nonprofit Treasurer Report Template, Budget vs Actual
$12.99
The board meets every month, and the numbers have to tie before you walk in. This nonprofit bookkeeping spreadsheet for the monthly close has income log, expense and bill log, budget vs actual, a two-page board treasurer report, and a functional expense allocation with a Form 990 Part IX worksheet. Excel and Google Sheets.
Share
What's inside
- Nonprofit_Income_Log.xlsx + EXAMPLE: one line per gift or batch by fund and account, online giving clearing (expected payout vs bank deposit), giving by fund and month, by account and by source
- Nonprofit_Expense_Bill_Log.xlsx + EXAMPLE: bills and payments with due dates, approvers, check numbers and restricted-fund confirmation; vendor list; summary by month and by account
- Nonprofit_Budget_vs_Actual.xlsx + EXAMPLE: monthly budget and actuals, variance in dollars and percent with status, a board dashboard with projected year end, a chart, and the lines furthest over or behind
- Nonprofit_Treasurer_Report.xlsx + EXAMPLE: two-page board report with month and year to date vs budget, cash and fund balances by net-asset class (with and without donor restrictions), control checks and notes for the board
- Nonprofit_Functional_Expense_Allocation.xlsx + EXAMPLE: split expenses between programs, management and general and fundraising using allocation bases and cost pools; statement of functional expenses; board summary with program ratio and a Form 990 Part IX worksheet
Who it's for
- Part-time treasurers and bookkeepers at small nonprofits and charitable organizations (roughly 1 to 25 staff) who record gifts and bills, compare spending with the budget, and report to a board or finance committee every month
Before you buy
Organizational tools only for small nonprofits and charitable organizations. Not tax, legal, or accounting advice. Not approved or endorsed by the IRS or any regulator. Does not guarantee compliance or a clean audit. The Form 990 Part IX worksheet is general information; check every line against the current-year form and instructions, and have a qualified CPA confirm your allocation method and how these tools apply to your organization. Built by ReconciledBooksCo, a small shop run by an experienced accountant.
Excel and Google Sheets. No macros. Paid spreadsheet products include a blank file and a filled example, plus a Start Here tab in plain English.
Licensed for one organization per purchase.
