Guide
Grant reports straight from the books
By Mavrin Labs. Published . Last updated . Reviewed by Mavrin Labs on . How this guide was researched and checked.

A grant report from the books is a funder report whose figures come straight out of your accounting system. A saved report pulls each figure by grant and by the funder's line items, so nobody retypes numbers into a new spreadsheet, and the books rather than a side file hold the answer.
The guide is written for the finance lead, executive director or development director of a nonprofit with paid staff and several funders.
It covers what the books need first, how to run a report from them, what changes for federal money and where automation helps. It is not accounting, tax or audit advice, and your accountant and your auditor decide how your books are set up.
Sources last checked Monday, November 16, 2026, or, where a citation says so, a later date. Mavrin Labs reviews this guide every quarter, and each source's own page always wins over it.
Why does nonprofit grant reporting turn into spreadsheet rebuilds?
Nonprofit grant reporting turns into spreadsheet rebuilds when the books record spending but not which grant paid for it, so each exported line is sorted by hand every quarter. Federal grants make it a rule: the Uniform Guidance requires books that identify each one received and spent (Uniform Guidance on financial management).
Each exported copy can then drift away from the books.
Two people can then build the same report and get two different totals, and when an auditor or a funder asks where a figure came from, the answer sits in a spreadsheet rather than in the ledger. A report built from the books avoids both problems, because every figure traces back to entries anyone with access can open.
What is reporting from the books?
Reporting from the books is a way of producing funder reports in which a saved report in your accounting system filters the general ledger, the full record of every entry, to one grant and one period, then groups the results by the funder's line items. You run it rather than rebuild it.
The report sets those line items, such as staff, travel or supplies, beside the spending plan the funder approved. Running it again for the same closed period gives the same figures, so what is left for staff is a review, a few notes on why spending differs from the plan, and the funder's own form.
Why it matters: more grant money, less time to report it
Funder reporting is not shrinking.
Giving USA 2026 puts charitable giving in 2025 at $617.20 billion, up 5.7% on 2024 in current dollars (the Giving USA announcement, checked Monday, November 16, 2026). A restricted gift, a donation the donor has limited to a stated purpose or period, usually ends in a report to the donor or funder who gave it.
The clerical work behind those reports is paid by the hour, so every rebuild takes paid staff time. Ask how many hours of retyping each quarter's rebuild takes. A report that runs from the books replaces that retyping with a run and a review, and leaves time for the notes and checks a funder reads.
What has to be in the books first?
Five things have to be in the books before a report can come straight from them. Restricted money sits apart from unrestricted money, and every grant has its own tag. Accounts map to each funder's line items, and shared expenses split across programs by a written method.
Last, the books reconcile and close each month, so that each part holds from one report to the next.
How do you run a funder report from the books?
You run a funder report from the books by setting up the grant once, then repeating a short monthly routine. Most of the effort sits at the start, when you read the agreement and build the tag and the map, and after that each report is a run, a review and a send.
The seven steps below follow one grant from the signed agreement to the report on file.
- Read the agreement. List the line items, the reporting dates, the spending the funder allows and any approval it needs before you move money between lines.
- Tag and map. Create the grant tag and map your accounts to the funder's lines before the first entry.
- Tag at entry. Whoever enters a bill, a charge or a deposit picks the grant tag at that moment, not at report time.
- Reconcile and close. Match each account to its statement, and close the month on a set day.
- Run the saved report. Pull spending by line item for the period and since the grant began, beside the approved spending plan.
- Explain and check. A person reviews each line, writes a short note on any line far from the plan and attaches the support the funder asks for.
- Send and keep. The person who signs sends the report and files a copy of exactly what went out.
What changes when a grant is federal money?
Federal money brings written rules for the books, through the federal grant rules known as the Uniform Guidance. The same rules apply when federal money reaches you through a state agency or a larger nonprofit, which passes them down to you. Your books then have to meet those rules on top of everything above.
The rule on financial management asks your financial system, among other things, to:
- identify each federal grant you receive and spend;
- keep records of the amount, source and use of the money, backed by source documents;
- compare spending with the approved spending plan for each grant;
- follow written procedures for deciding which spending a grant allows.
Annual financial reports are due no later than ninety calendar days after the reporting period. The final report is due no later than one hundred twenty calendar days after the grant ends, or ninety when the money passed through another organization, unless the funder extends the date (the reporting rule).
You keep the records for three years from the day you submit the final financial report, and longer while an audit or a dispute is open (the records rule).
A nonprofit that spends one million dollars or more in federal grant money in its fiscal year needs a single audit, or in some cases an audit of one program, for that year (the audit rule, each of the three rules read on the earlier of the two dates at the top of the page).
The IRS return asks whether the organization needed such an audit and whether it had one (the IRS instructions). Your auditor confirms which version of each rule applies to your grants and your year.
How did these rules come to stand where they are?
The rules took their present shape in two steps, one for the books and one for federal money. FASB issued its update on nonprofit statements in August 2016 as the first phase of a wider project. It replaced three classes of net assets, which split restrictions into temporary and permanent, with the two in use today (the FASB update).
OMB, the federal office that writes the grant rules, set out the Uniform Guidance in December 2013. Its revision of Monday, April 22, 2024, which took effect on Tuesday, October 1, 2024, raised the single audit threshold from $750,000 to $1,000,000 (OMB's revision in the Federal Register, checked Wednesday, November 18, 2026).
OMB gave its reason as cutting the burden on agencies and recipients, since several dollar thresholds had not changed for many years. That is why this guide gives the audit line as one million dollars, and why a fiscal year that began before the change may fall under the older line, which your auditor confirms.
Which state rules ask for the same figures?
State charity rules can ask for the same figures when a nonprofit registers to raise money from the public. Florida is one example: its charity law asks each registered charity for a yearly financial statement with a balance sheet and a statement of functional expenses, split into program services, management and general, and fundraising.
Above set levels of yearly gifts, the law requires an independent certified public accountant to review or audit the statement, and a charity may file its IRS return instead (Florida's charity law on financial statements).
Other states set their own rules, and your accountant can say which ones reach you. When the books split expenses by function every month, the state form, the IRS return and each funder report all draw on the same figures.
Where does automation help, and where does a person decide?
Automation helps with the steps that repeat every month, and a person decides anything that needs judgment about a grant. Software can fetch, sort, flag and lay out figures without anyone retyping them. It cannot read a grant agreement the way your finance lead does, or answer to a funder for what goes out.
Automation can take on these steps:
- pull bank, card and payroll entries into the books each day;
- suggest a grant tag from the vendor or the memo, for a person to confirm;
- list entries with no tag, and lines that do not match a statement, before the close;
- run each saved report on a set day and fill in the funder's template;
- flag any line that runs far from the approved spending plan;
- draft notes on those lines with an AI tool, for a person to edit.
A person at your organization still decides:
- whether a charge is spending the grant allows;
- how shared expenses split, and when that method changes;
- when restricted money comes off its restriction;
- what the report says, and who signs it before it goes to the funder.
Keep donor and client records out of general AI tools while you do this, as the nonprofit AI-use policy guide explains.
Before choosing what to automate, count the hours the current rebuild takes. The hour-value tool turns the weekly hours into hours a year at the published office wage, which gives a board a baseline to compare against later.
What should a funder report pack hold?
A funder report pack should hold the figures, the proof behind them and the name of the person who signed. Many funders ask for a summary by line item and a comparison with the plan. Keeping the rest on file means that a question from an auditor or a funder already has an answer waiting.
The table below lists what a full pack holds and where each part comes from.
| Part of the pack | What it shows | Where it comes from |
|---|---|---|
| Line-item summary | Spending for the period and since the grant began, beside the plan the funder approved | The saved report, by the funder's lines |
| Restricted balance | How much of the grant is still unspent | Restricted net assets, by grant tag |
| Payroll support | How staff time split across grants | Time sheets and the payroll entries behind them |
| Entry detail | Every entry behind each line | The general ledger, filtered by the grant tag |
| Reconciliations | That the books matched the bank each month | The monthly close file |
| Notes on differences | Why any line ran far from the plan | The finance lead or the program lead |
| Sign-off | Who approved the report, and when | The person who signs for your organization |
How can Mavrin Labs help with funder reports?
Mavrin Labs helps with funder reports through its data and reporting work, which joins the systems that hold your figures so reports build on a schedule. A system Mavrin Labs builds runs on the accounting and grant tools you already use, and it lays out each funder's figures for a person to check.
By default, nothing goes to a funder until a person at your organization approves it.
Mavrin Labs never uses client data to train AI models, and your organization owns all of its data. Every engagement starts with a workflow assessment, and the written design plan for a build names each source and each report, so your finance lead can check it first.
Mavrin Labs gives no accounting, tax, legal or audit advice. The page on client data in a Mavrin Labs build sets out each term in full.
Key takeaways
- Run each funder report from a saved report in your books, not a rebuilt spreadsheet.
- Keep restricted money apart, and tag every entry to its grant.
- Keep one chart of accounts, with a map to each funder's line items.
- Split shared expenses by a written method, the same way every month.
- Reconcile and close each month before any report runs.
- Let automation fetch, flag and lay out figures, and let a person decide and sign.
Sources behind this guide
Every source in this guide was last checked on one of the two dates at the top of the page, and Mavrin Labs reviews the guide quarterly. The table below pairs each outside fact with its publisher.
| Fact | Source |
|---|---|
| Two classes of net assets, board designations and the expense split | FASB update on nonprofit financial statements |
| Net assets on the return, functional expense columns, allocation and the audit question | IRS instructions for the exempt organization return |
| What a financial system must track for federal grants | Federal rule on financial management |
| When federal financial reports are due | Federal rule on financial reporting |
| How long federal grant records are kept | Federal rule on record retention |
| When a single audit is required | Federal rule on audit requirements |
| When and why the audit threshold rose | OMB's 2024 revision of the Uniform Guidance |
| What Florida asks of a registered charity's financial statement | Florida's charity law on financial statements |
| Charitable giving in 2025 and its growth on 2024 | Giving USA announcement |
Corrections and changes, newest first:
- Wednesday, November 18, 2026: the FASB update was read again and both of its citations now give that date. A passage on how the rules developed and a diagram of the books were added, and two sentences now ask questions instead of stating how many systems offer a grant field and how many hours a report saves.
- Tuesday, November 17, 2026: the title changed to name nonprofit grant reporting, the FASB update was added to the paragraph on tags, and the dates at the top were aligned with each citation's own date.
- Monday, November 16, 2026: the federal rules were split into separate paragraphs, each with its own link, and the FASB link was moved to the FASB's own copy of the update.
Where to go next
The page for nonprofits shows the workflows Mavrin Labs looks at first, including board and funder reporting. Data and reporting explains how one page of figures comes together from several systems.
For other workflows that take staff time, the six-question project finder points to a first project from a few questions about where the week goes.
If outside funding is part of the plan, the guide to funding AI and automation lists the programs and their rules. To talk through one funder report and the books behind it, start a conversation.
Frequently asked questions
Can a spreadsheet still be part of the process?
A spreadsheet can still be part of the process, as long as it only lays out figures and never changes them. The figures come from a saved report in your accounting system, and the spreadsheet puts them in the funder's format. If a number needs a hand edit, fix the entry in the books instead.
Who should own the map from accounts to funder line items?
The finance lead should own the map from accounts to funder line items, because the map decides where every dollar lands in a report. Program leads confirm that each line reads the way the funder expects. Your accountant or auditor can look over the map once a year, and each change to it should carry a date and a reason.
What if a funder's reporting period differs from our fiscal year?
A funder's reporting period can differ from your fiscal year without extra work, as long as you close every month. The saved report simply runs for the funder's dates, such as a grant year that starts in July. Closed months mean that the same date range gives the same figures every time anyone runs it.
Is this guide accounting, tax or audit advice?
Nothing in this guide is accounting, tax, legal or audit advice, and Mavrin Labs gives none. The guide explains what a few public sources say and links each one. Your accountant, your auditor and your board decide how your books are set up and how any rule applies to you.
