Nonprofit Treasurer Spreadsheet | Church, PTO and Booster Club Bookkeeping for Excel and Google Sheets | Fund Accounting and 990 Helper

Your books aren't a business's books. Restricted money has rules.

A business spreadsheet has one pot of money. You have several, and some of them are not yours to spend. When a donor gives $500 for the food pantry, that money is legally constrained. When your board sets aside $12,000 as a reserve, it is not — because the same board can un-set it at the next meeting. Those two dollars look identical in a bank balance, and they belong in different columns of your financial statements. This workbook is built around that difference.

One ledger. Fifteen connected tabs. Every statement ties.

WHAT THE FILE WORKS OUT — from the sample organisation that ships inside (Cedar Hollow Family Center is sample data, not a real charity and not a customer)
· $117,933 of total net assets that splits into $72,450 with donor restrictions, $17,000 board designated, and $23,723 that is genuinely yours to spend. Your bank balance never told you that.
· $22,670 released from restriction this period across ten entries — because you do not spend restricted money, you release it. Ten purposes met, and a $0 effect on total net assets, which is exactly right: a release is a reclassification, never revenue.
· A hard guard rail: an expense may only be charged to a fund without donor restrictions. Try to spend the roof campaign on general operating and the Transactions tab flags it and Fund Balances names the exposed fund. Restricted funds cannot go negative in this file.
· $113,173 of gross receipts run through the actual IRS three-year averaging test — because "under $50,000" is not last year's number, it is an average — and the file tells you which 990 you file and the exact date it is due.
· 130 donor rows that produce compliant acknowledgments: the $250 written-acknowledgment trigger, the required no-goods-or-services language, the quid pro quo disclosure threshold, and the Form 8283 and 8282 lines.
· A one-page Treasurer's Report that prints clean for the board, and five tie checks that all read zero: assets $132,863 = liabilities $14,930 + net assets $117,933, with the change in net assets agreeing between the Statement of Activities and the fund register in both classes.

WHAT'S INSIDE — 15 connected tabs
Start Here · Org Profile · Funds Setup · Transactions · Fund Balances · Release From Restriction · Statement of Financial Position · Statement of Activities · Functional Expenses · Which 990 Do I File · Donor Receipts · Budget vs Actual · Treasurer Report · Compliance Calendar · Reference

EVERYTHING THAT VARIES BY STATE IS A FIELD YOU FILL IN
Charitable solicitation registration and its deadline and fee, the state audit and review thresholds, paid-fundraiser triggers, raffle and gaming legality, sales and use tax exemption, property tax exemption, state unemployment treatment — all user-entered, each with a place for your source URL and the date you checked. Federal figures are built in and every one carries its year and its source on the Reference tab.

WHAT YOU DOWNLOAD — one zip, eight files
· Nonprofit-Treasurer-Command-Center.xlsx — the main workbook
· Bonus Themes folder — the same workbook in Light, Dark and Editorial
· Quick-Start-Guide.pdf — 15 pages, including a one-page fund accounting primer
· ACCESS-YOUR-TEMPLATE.pdf — one click opens your own copy in Google Sheets
· README - Start Here.txt and LICENSE.txt

FOUR COLOR THEMES INCLUDED — Classic, Light, Dark and Editorial, same engine.

WORKS IN EXCEL AND GOOGLE SHEETS — one file, both engines. Open the xlsx in Microsoft Excel, or use the included one-click access PDF to make your own Google Sheets copy and share it with your board. No add-ons, no subscription, nothing that reaches out to the internet.

HONEST ENGINEERING
4,522 formulas · recalculated clean · 1,523/1,523 independent math checks · every screen in this listing is the real file. No subscription. Free lifetime updates.

Cedar Hollow Family Center is shipped sample data, not a customer — nine funds, 187 ledger rows, books closed through June 2026. Every screen works the moment you open it, and clears in one pass when you are ready for your own.

FOUR THINGS THIS FILE WILL KEEP TELLING YOU
· A board designation is not a donor restriction. The board can undo its own decision; a donor's restriction it cannot.
· Donated services are almost never revenue.
· "We're under fifty thousand" is a three-year average, not last year's total.
· Being tax-exempt is not the same as being exempt from every tax, and it is not the same as being registered to fundraise in your state.

PLEASE READ
This is a bookkeeping and compliance tool, not tax, legal or accounting advice. It does not produce audited financial statements and it does not file anything for you. Confirm your own figures with a CPA who works with exempt organisations, and at IRS.gov.

WATCH THE FULL WALKTHROUGH ON YOUTUBE: https://youtu.be/AMExH6Z67BM

YOU MAY ALSO LIKE
· Retirement Withdrawal Spreadsheet: https://www.etsy.com/mx/listing/4545613455/retirement-withdrawal-spreadsheet-rmd
· Executor Checklist Spreadsheet: https://www.etsy.com/mx/listing/4545616693/executor-checklist-spreadsheet-estate
· 2026 Tax Deduction Spreadsheet: https://www.etsy.com/mx/listing/4545423060/hoja-de-calculo-para-deducciones

Instant download · personal and single-organisation use · by NicheToolkits