--- title: "Nonprofit Treasurer's Workbook (Excel) | MCC Solutions" description: "Excel workbook for volunteer treasurers of small nonprofits: a ledger by fund, a donor register that flags gifts missing an acknowledgement, budget vs actual…" url: "https://mcc-solutionsnj.com/toolkits/nonprofit-treasurer-workbook" --- Excel workbook # Nonprofit Treasurer's Workbook: Fund Balances, Donor Acknowledgements, Budget vs Actual and a Board Report in Excel Record income and spending by fund, see what each restricted fund still holds, catch gifts that still need a thank-you letter, and give the board a one-page report. **$39** one time · 14-day full refund · example and blank copies · download link by email Buy now, $39 Try the free starter 🌙 The desk is asleep. The store never is. Every kit and ebook downloads the moment you pay, day or night. Questions get answered after we open in the morning. [Browse the store](/toolkits) Who it is for Volunteer treasurers of small nonprofits, community groups, clubs and youth organizations. Not the right fit if You need Form 990 prepared, an audit, or fund-accounting software for a larger staffed organization. Why it is different - It tracks money by fund, so restricted gifts are never spent by accident. - It flags gifts at or above a threshold you set that have no acknowledgement, so you can check them before year end. - A filled example for an invented youth-sports nonprofit and a blank copy with working formulas. What is inside - **Start Here.** Purpose, which cells to fill in and what the workbook is not. - **Setup.** Fiscal year, your funds, income and expense categories, which expenses are program, management or fundraising, and your approval threshold. - **Ledger.** Every receipt and payment by date, fund and category, with receipt-on-file and approver columns and a running balance by fund. - **Donors.** A donor register without addresses, with gift type, restricted fund and whether an acknowledgement was sent. - **Budget vs Actual.** Annual budget against the ledger by category, with variance and flags. - **Restricted Funds.** Opening balance, income, spending and ending balance by fund, with a warning for any fund that goes negative. - **Treasurer Report.** A printable board report with the statement of activity, fund balances, budget highlights and open items. - **Functional Expenses.** Program, management and fundraising totals and percentages. - **Checks.** Uncategorized rows, negative fund balances, missing receipts and gifts missing an acknowledgement. A look inside ## Example data, real formulas [![Treasurer Report tab of the Nonprofit Treasurer's Workbook, with example data](/img/toolkits/nonprofit-treasurer-workbook/a.png)](/img/toolkits/nonprofit-treasurer-workbook/a.png) Treasurer Report tab with example data. Made-up numbers. [![Budget vs Actual tab of the Nonprofit Treasurer's Workbook, with example data](/img/toolkits/nonprofit-treasurer-workbook/b.png)](/img/toolkits/nonprofit-treasurer-workbook/b.png) Budget vs Actual tab with example data. Made-up numbers. Get it ## Nonprofit Treasurer's Workbook Or pay with PayPal Uses the email and terms box above. You get the same download link by email. ZIP code (for sales tax) Want every toolkit? The [toolkit membership](/membership) includes all of them, with a lower rate if you pay yearly. Get every update for a year, $29: the [Yearly Updates Pass](/updates-pass?kit=nonprofit-treasurer-workbook) gives you each refreshed edition we release of the kits you own. One payment, no automatic renewal. Delivered as a zip with a filled example and a blank copy. Built for Excel, tested in LibreOffice; it should open in Google Sheets but not every feature is tested there. For one business, your own use. General information, not accounting, tax or legal advice. A bookkeeping aid, not legal, tax or accounting advice. State charity registration, Form 990 filing and audit requirements depend on your organization, so ask a professional. The acknowledgement threshold is an input; confirm the current rule on irs.gov. The running balance assumes rows are entered in date order. Payment is handled by Stripe. If a file will not open or something looks wrong, reply to your order email and we will make it right. Ways to get it ## Just this kit, or more This kit **$39 one time** Nonprofit Treasurer's Workbook. Buy this kit The set **$65 one time** 3 kits including this one, $22 less than buying them separately. [See the set](/toolkits/nonprofit-treasurer-bundle) Membership **$29 a month** Every kit and document pack in the store, including new ones. Cancel any time. [See the membership](/membership) Questions ## Common questions **What do I get and how is it delivered?** The Nonprofit Treasurer's Workbook as two Excel files in one zip: a filled-in EXAMPLE so you can see every tab working, and a BLANK copy for your own numbers, plus a README. The download link arrives by email after payment. **Will it open on a Mac, Google Sheets or my phone?** Built for Excel and tested in LibreOffice, which runs on Mac and Windows; it should open in Google Sheets, but not every feature is tested there. Phone spreadsheet apps are not tested. If a file will not open or something looks wrong, reply to your order email and we will make it right. If it is not right for you, email us within 14 days of buying for a full refund. **Is this legal or tax advice?** A bookkeeping aid, not legal, tax or accounting advice. State charity registration, Form 990 filing and audit requirements depend on your organization, so ask a professional. **Is it the right fit for me?** It is made for volunteer treasurers of small nonprofits, community groups, clubs and youth organizations. Skip it if you need Form 990 prepared, an audit, or fund-accounting software for a larger staffed organization. Free starter ### Try a free one-tab version first A small working Excel file with the same kind of math, filled with made-up example numbers you can type over. We send one confirmation email, and no series follows. Rather hand it off? ### We can keep the books for you each month If tracking this yourself is more than you want to take on, we do monthly bookkeeping in QuickBooks, Xero or Excel. Tell us what you use and what is behind, and we reply with a written quote after a short review of your books. No obligation. [Get a bookkeeping quote](/bookkeeping/#interest) [Free books health check](/bookkeeping/health-check) Prefer to keep it yourself but want a hand getting started? [Book a 45 minute setup session](/workbook-setup-session) ($65). Buy it with the others [Bundle ### Nonprofit Treasurer Bundle This product plus 2 more, in one download. $65 instead of $87 separately](/toolkits/nonprofit-treasurer-bundle)[### Month-End Close Workbook A real month-end close in one Excel file. It tells you when a rec does not tie, which variances still need an answer, and when the period is ready to lock. $19](/toolkits/month-end-close-workbook) ## More bookkeeping and business toolkits - [North Carolina Employer Compliance Kit 2027](/toolkits/north-carolina-employer-compliance-kit-2027) $19 - [North Carolina Landlord Compliance Kit](/toolkits/north-carolina-landlord-compliance-kit) $19 - [North Carolina Small Claims Court Kit](/toolkits/north-carolina-small-claims-court-kit) $19 - [North Carolina Unemployment Checklist](/toolkits/north-carolina-unemployment-checklist) $15 - [North Dakota Employer Compliance Kit 2027](/toolkits/north-dakota-employer-compliance-kit-2027) $19 - [North Dakota Landlord Compliance Kit](/toolkits/north-dakota-landlord-compliance-kit) $19 [See every toolkit and document pack](/toolkits/all) ## Rather have someone do the books? [Get a Bookkeeping Quote](/bookkeeping/#interest)[Call (908) 444-6373](tel:+19084446373)