Nonprofit Restricted Funds Tracker and Donation Count Sheet
$12.99
Restricted gifts and cash counts are the first places an auditor looks. This nonprofit bookkeeping spreadsheet covers dual-custody cash and donation counts, donor-restricted and board-designated funds, and the monthly bank reconciliation, plus a sample nonprofit chart of accounts. Excel and Google Sheets.
Share
What's inside
- Nonprofit_Cash_Donation_Count_Pack.xlsx + EXAMPLE: printable two-counter count sheet (denominations, checks list, independent tallies), cash and checks by fund, deposit match, weekly log that grades every count, monthly summary by fund, counter rotation, and bank match
- Nonprofit_Funds_Tracker.xlsx + EXAMPLE: donor-restricted, board-designated and unrestricted funds; fund ledger with a status on every line; transfers and releases; monthly balances; net assets with and without donor restrictions; cash tie-out
- Nonprofit_Bank_Reconciliation_Workbook.xlsx + EXAMPLE: 12-month bank reconciliation with outstanding items that carry forward, book adjustments, ready-to-post journal entries, fund tie-out, control checks and reviewer sign-off
- Nonprofit_Sample_Chart_of_Accounts.xlsx: 107 numbered nonprofit accounts (assets, liabilities, net assets, revenue, and expenses by group) plus the fund list, with EDUCATIONAL ONLY notes where your CPA should confirm treatment
Who it's for
- Part-time treasurers and bookkeepers at small nonprofits and charitable organizations (roughly 1 to 25 staff) who count cash and checks with two people, track restricted gifts, and reconcile the bank for a board or finance committee
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 funds-equal-cash check is a cash-basis simplification. Confirm with a qualified CPA or attorney 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.
