Guide

Grant reports straight from the books

17 min read

By . Published . Last updated . Reviewed by Mavrin Labs on . How this guide was researched and checked.

A card reading "Grant reports straight from the books" beside the Mavrin Labs logo
The card that shows when this guide is shared or linked.

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.

OnesavedreportRestricted moneykept apartPart one of the booksA tag on everygrant entryPart twoAccounts mapped tofunder linesPart threeShared expensessplit by a writtenmethodPart fourA monthlyreconciliation andclosePart fiveEach funder'sreportOutputThe IRS annualreturnOutputThe state charitystatementOutput
Five parts of the books feed one saved report, and the same figures reach three outputs. Arrows show which way the figures travel.
  • How should restricted money show in the books?

    Restricted money should show in the books as restricted net assets, which the accounting standard calls net assets with donor restrictions, kept apart from the money without them. The Financial Accounting Standards Board (FASB) set these two classes for nonprofit statements in August 2016, in its update ASU 2016-14 (the FASB update, checked Wednesday, November 18, 2026).

    The same update asks nonprofits to disclose board designations, which are limits the board sets for itself rather than donor restrictions.

    The Internal Revenue Service (IRS) uses the same two classes on the balance sheet of Form 990, the annual information return that most tax-exempt organizations file. It describes a donor restriction as a limit on when money may be used, on what it may be used for, or both (the IRS instructions for Form 990, checked Monday, November 16, 2026).

    In the books, the restriction comes off as you spend the money on its purpose or as its time passes, so record that release each month.

  • How do tags mark each grant?

    Tags mark each grant by labeling every entry that belongs to it, from a bill or a card charge to a payroll line or a deposit. The tag also feeds the two classes of net assets, with and without donor restrictions, that FASB's August 2016 update set (FASB ASU 2016-14, checked Wednesday, November 18, 2026).

    Check your accounting system's own documentation for a field that does this, and ask its support team if you cannot find one. Systems that have it name it differently: a class, a location, a project, a fund or a dimension. The name matters less than the habit of filling it in on every entry.

    A grant tag is the label you choose for one grant, or for one funder and program together. Set it up before the first dollar arrives, close it when the grant ends, and make the field required wherever your system allows it.

  • How do accounts map to funder line items?

    Accounts map to funder line items through a short table that the finance lead keeps, not through new accounts for each funder. Your chart of accounts, the list of every account in your books, stays the same for everyone. The map then says which accounts roll up into each funder's lines, such as staff, benefits, travel, supplies or contracted services.

    One chart with many maps keeps your own statements consistent, while each funder still sees its own format. When a funder adds a line item, you change the map, not the books. The table below shows the idea with two made-up funders.

    How do accounts map to funder line items?
    Account in your books Funder A line item Funder B line item
    Salaries Personnel Program staff
    Payroll taxes and benefits Fringe benefits Program staff
    Program supplies Supplies Direct program expenses
    Contract services Contractual Direct program expenses
    Rent and utilities Indirect (overhead) Not allowed in this grant
  • How are shared expenses split across programs?

    Shared expenses split across programs by a written method that the books apply the same way every month. Rent, the finance lead's time and the accounting system itself serve every program, so each grant should carry only its fair share. The split often follows staff time from time sheets, floor space or the number of people served.

    The IRS asks charities to report expenses on their annual return in three columns: program services, management and general, and fundraising. Where an accounting system does not split expenses on its own, the IRS lets an organization use any reasonable method, as long as it documents that method in its records (the IRS instructions on functional expenses).

    The FASB update also asks nonprofits to show expenses by both their nature and their function, and to disclose the method they use to split them.

  • Why do reconciliation and a monthly close matter?

    Reconciliation and a monthly close matter because a report can only be as steady as the month underneath it. Reconciliation means matching the books to the bank, card and payroll statements, line by line, and fixing what differs. A period close then locks the month, so nobody can change an entry after a report has used it.

    Without a close, a late bill can shift last month's figures, and a report you already sent no longer matches the books. With one, any closed month gives the same answer every time, and late items go into the open month with a note.

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.

  1. 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.
  2. Tag and map. Create the grant tag and map your accounts to the funder's lines before the first entry.
  3. Tag at entry. Whoever enters a bill, a charge or a deposit picks the grant tag at that moment, not at report time.
  4. Reconcile and close. Match each account to its statement, and close the month on a set day.
  5. Run the saved report. Pull spending by line item for the period and since the grant began, beside the approved spending plan.
  6. 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.
  7. 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.

What should a funder report pack hold?
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.

Sources behind this guide
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.

The Mavrin Labs mark

Who writes these guides

Client work at Mavrin Labs is delivered by a team in mixed roles, led by our founder. AI tools help with research and drafting, and a person at Mavrin Labs checks each fact against its named source before a guide is published.

Enquiry form

Start with one workflow

Tell Mavrin Labs what is stuck and which systems it touches. A person at the firm reads every enquiry and replies by email.

Start a conversation

Fields marked with an asterisk are the ones a reply needs.

So a reply can address you properly.

The address the reply goes to.

Optional. Give one only if you would rather talk than write; the reply goes by email either way.

Optional, and useful when it says what the work has to fit around.

The result you want, and when you would want it working. Two or three sentences are plenty.

The task as it actually happens, roughly how often it runs, and which systems it touches. Two links at most, please.

Optional.

What you send goes to the Mavrin Labs inbox and is used to answer you, and a phone number, if you give one, is used for the same thing and nothing else.

A person reads it and replies by email.

If the form does not send, write to info@mavrinlabs.com instead; it reaches the same inbox.

Which hours would you take back first?

Name the one workflow that eats the most of your week. Mavrin Labs reads it, and the reply comes from the people who would build the fix.

Start a conversation