A monthly nonprofit treasurer report template should pull five financial views into a single recurring package: a balance sheet, an income statement, a cash flow statement, a budget-versus-actual comparison, and a short narrative explaining anything unusual. Built once and used every month without exception, that template keeps the numbers consistent across periods, gives the board something it can actually read, and does most of the work of preparing the annual Form 990 before the fiscal year even ends.
The Five Sections Every Template Needs
Whether the report lives in QuickBooks, Xero, or a spreadsheet, the same five components belong in it every month:
- A balance sheet, formally called the statement of financial position, showing assets, liabilities, and net assets as of the last day of the month.
- An income statement, or statement of activities, showing total revenue minus total expenses for the month.
- A cash flow statement tracking the actual movement of cash into and out of bank accounts. An organization can look solvent on the income statement and still run dangerously low on cash if large receivables haven’t come in.
- A budget-versus-actual comparison lining up the board-approved annual budget against what actually happened. This is where problems surface early enough to fix.
- A short notes section covering anything unusual: an unexpected large donation, a delayed grant payment, a one-time equipment purchase that distorts the month’s totals.
Accounting software can generate most of these automatically from synced bank feeds. Smaller organizations working in spreadsheets can build the same five sections by hand. The value is in the consistency, not the tool. Pick one layout, keep the column order the same each month, and the board can compare periods at a glance.
Cash Basis or Accrual: Decide Before You Build
Before filling in anything, decide whether transactions get recorded when cash changes hands (cash basis) or when the obligation arises (accrual basis). Cash basis is simpler: record a grant when the check clears, not when the award letter arrives. Accrual basis captures the fuller picture by recognizing revenue and expenses in the period they occur, regardless of when the money moves. Generally Accepted Accounting Principles require accrual, so any organization that needs GAAP-compliant statements or expects an independent audit should use accrual from the start.
Smaller nonprofits often keep monthly internal reports on cash basis and convert to accrual for the annual Form 990 and audited financials. That works, but the conversion creates extra work at year-end. Whichever method you choose, note it clearly at the top of the template so anyone reading knows what they’re looking at.
Separating Revenue by Donor Restriction
Revenue has to be split into two categories based on whether donors placed conditions on the money. Under the current standard (FASB ASU 2016-14, which replaced the older three-category system), net assets fall into two classes:
- Net assets without donor restrictions, which the organization can spend on any operational need.
- Net assets with donor restrictions, earmarked for a specific program, purpose, or time period. A $10,000 gift restricted to a youth literacy program has to be tracked separately and kept off general overhead.
For each class, the template should show the opening balance, add revenue received during the month, subtract expenses charged against that class, and show the closing balance. When a restriction is satisfied (the youth program actually spends the $10,000), record a “release from restriction” that moves the amount from the restricted column to the unrestricted column. Misclassifying restricted funds, or spending them on the wrong purpose, is the kind of error that draws scrutiny from donors, auditors, and state charity regulators.
Splitting Expenses Into Program, Management, and Fundraising
The IRS requires organizations filing Form 990 to break expenses into three functional categories.1Internal Revenue Service. Instructions for Form 990 Return of Organization Exempt From Income Tax Building those categories into the monthly template turns year-end reporting into a lookup instead of a reconstruction:
- Program services: costs directly tied to the mission. For a food bank, that is the food itself, delivery trucks, and warehouse staff.
- Management and general: administrative overhead like executive salaries, accounting, insurance, legal fees, and board meeting expenses. Investment management costs belong here too.
- Fundraising: everything spent soliciting donations and grants, including event costs, direct mail, and the staff time allocated to those activities.
Some costs cross categories. An executive director’s salary might be split between management and program services if that person spends part of the week directly running programs. The organization’s normal accounting method governs how those allocations get made, but whatever method is used has to be documented and applied consistently.1Internal Revenue Service. Instructions for Form 990 Return of Organization Exempt From Income Tax
The budget-versus-actual column earns its keep here. If fundraising expenses in March already hit 40 percent of the annual budget, the board needs to see that immediately. There is no universal percentage threshold that triggers a mandatory explanation, but many organizations flag any line item deviating more than 10 to 15 percent from the year-to-date budget and ask the treasurer to explain why.
Line Items That Belong on the Template Every Month
A few figures cause real trouble when they’re only reviewed at year-end. Give each one a running total on the template.
Lobbying Expenditures
A 501(c)(3) can lobby, but spending is capped. Organizations that make the 501(h) election get a clear, formula-based limit. For those with total exempt-purpose expenditures of $500,000 or less, the lobbying ceiling is 20 percent of those expenditures. The ceiling gradually drops for larger organizations and maxes out at $1,000,000 regardless of size. Exceeding the limit triggers a 25 percent excise tax on the excess amount.2Internal Revenue Service. Measuring Lobbying Activity: Expenditure Test A year-to-date lobbying line on the template lets the board see how close the organization is to its ceiling before it becomes a problem.
Unrelated Business Taxable Income
Revenue from activities regularly carried on, unrelated to the exempt purpose, and conducted as a trade or business counts as unrelated business taxable income. Common examples include advertising revenue in a newsletter, rental income from debt-financed property, and fees for services unconnected to the mission. If this income reaches $1,000 or more in a tax year, the organization must file Form 990-T and pay tax on it, following the same schedule as the regular Form 990. Tracking it monthly prevents a surprise at tax time when the organization realizes it crossed the threshold months ago and owes tax plus interest.
Payments to Insiders
Under Section 4958 of the Internal Revenue Code, if a disqualified person (typically a board member, officer, or key employee) receives compensation or another economic benefit that exceeds what the services are worth, the IRS can impose an excise tax of 25 percent of the excess benefit on that person.3Office of the Law Revision Counsel. 26 U.S. Code 4958 – Taxes on Excess Benefit Transactions Organization managers who knowingly approve the transaction face a separate 10 percent tax. If the excess benefit isn’t corrected promptly, the tax jumps to 200 percent.4Internal Revenue Service. Intermediate Sanctions The template should flag any payment to a board member, officer, or their family so the board can review whether the transaction is at fair market value and record its reasoning.
Source Documents Behind the Numbers
Every number on the report needs a piece of paper behind it. Before opening the template, gather:
- Bank statements, the foundation for reconciling cash on hand and catching outstanding checks or deposits in transit.
- Credit card statements, which capture purchases that won’t show up in the checking account until the bill is paid.
- Receipts confirming each expense aligns with the organization’s charitable purpose.
- Payroll records documenting gross wages and employer-side taxes, including Social Security and Medicare. The IRS requires employment tax records to be kept at least four years after filing the fourth quarter return for that year.5Internal Revenue Service. Employment Tax Recordkeeping
- Vendor invoices verifying that accounts payable are current and recorded in the right month.
- Donation records. For any single contribution of $250 or more, the organization must give the donor a written acknowledgment stating the amount, describing any non-cash property, and saying whether the organization provided goods or services in return.6Internal Revenue Service. Charitable Contributions: Written Acknowledgments
An exempt organization must keep books and records sufficient to show it complies with the tax rules, including documentation of all receipts and expenditures reported on its annual return.7Internal Revenue Service. EO Operational Requirements: Recordkeeping Requirements for Exempt Organizations There is no single federal rule spelling out retention periods for every category, but a safe minimum is seven years for most financial records, which covers the longest applicable statutes of limitations. Employment tax records specifically must be kept at least four years.8Internal Revenue Service. Topic No. 305, Recordkeeping
Getting the Report to the Board
Distribute the finished report to every board member at least three to five days before the meeting. Board members who receive it the night before rarely read it carefully, and that defeats the purpose of producing it.
During the meeting, walk through the highlights: overall cash position, significant variances from the budget, restricted fund balances, and anything unusual flagged in the notes. The goal is not to read every line aloud. It is to direct attention to items that need discussion or a decision. After the presentation, a board member typically makes a motion to “receive and file” the report. That language matters. It means the board acknowledges the report without certifying that every number is correct, and that distinction protects the board if an error surfaces later.
The minutes should record that the treasurer presented the report, summarize any questions raised, and note the motion. If a board member disclosed a conflict of interest related to a transaction in the report, the minutes should reflect that the conflicted member left the room during discussion and abstained from any related vote. Twelve months of reports built and presented this way leave the organization with almost everything it needs to prepare the annual Form 990, and a clean audit trail for anyone who asks how the numbers were put together.