Guide

How to automate reports so the figures agree

19 min read

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

A card reading "How to automate reports so the figures agree" beside the Mavrin Labs logo
The card that shows when this guide is shared or linked.

Automating a report means writing one definition for every figure in it, naming the system each figure comes from, and letting software collect those figures on a set schedule. The definitions do the real work. Software only repeats them, so a report that disagrees with itself when built by hand will disagree faster once it runs on its own.

This guide is for owners, office managers and nonprofit leaders who rebuild the same report every month from exports and a spreadsheet. It covers what to write down, where each figure should come from, the steps to automate, and how to check the result. It does not review reporting products, and it is not accounting or tax advice.

If two people would calculate a figure differently, write the definition before you automate anything.

What is an automated report?

An automated report is a report that software builds and delivers on a set schedule from figures each defined once in writing and drawn from one named system, so every run gives the same answer for the same closed period. People still read it and decide.

It differs from a dashboard someone refreshes by hand, and from an export pasted into a spreadsheet each month. The schedule, the definitions and the source of each figure are what make it automatic, and the software only carries them out.

Why it matters: rebuilt reports take paid hours

Rebuilding a report by hand is clerical work, and clerical work is paid by the hour.

The Bureau of Labor Statistics puts the median wage of bookkeeping, accounting and auditing clerks at $24.36 an hour in May 2025, across 1,532,400 jobs in 2025, and projects that employment to fall 6% from 2025 to 2035 (the bureau's outlook for these clerks, checked Wednesday, November 18, 2026).

A report built from written definitions moves those hours from copying to checking. The sections below set out the definitions, the sources, the steps and the checks, in that order.

To put your own number on it, the hour-value tool turns the weekly hours of the rebuild into hours a year at the published office wage.

Can financial reporting be automated?

Financial reporting can be automated once every figure has a written definition and one source system. Software can then collect the figures, apply the same rules each time and deliver a finished report on a schedule you choose. People still decide what the figures mean and what to do about them, so judgment stays with the people reading.

The figures usually sit in software a business already runs. In the Census Bureau's report on its 2023 annual business survey, 58.9% of businesses described specialized software as very important to their processes or methods (Census Bureau report on technology use, checked Monday, November 16, 2026).

What is usually missing is not the data but an agreement about how to read it.

The table below sorts common reports by whether they are ready to run on their own.

Can financial reporting be automated?
Report Ready to automate when Keep it by hand while
Monthly income summary the figures come from accounting software and the month closes on a known day, the period close after which no entry changes entries are still being corrected after the month ends
Enquiries and where they came from every enquiry lands in one CRM (customer relationship management system, the program that holds client records) or shared inbox with its source recorded enquiries arrive by phone and nobody logs them
Staff hours by client or program hours are tracked in one system against a client or program hours are estimated at the end of the month
Board or funder pack the same figures go out each month in the same layout each funder asks for different figures each time
Cash position bank and accounting records are reconciled, matched line by line with every difference explained, on a set day reconciliation happens when somebody finds the time

Why does each figure need a written definition?

Each figure needs a written definition because two systems, or two people, will otherwise count the same thing in different ways. One tool records a sale when the invoice goes out and another when the payment arrives, so two honest reports for one month can disagree. A definition settles which rule wins before anyone builds anything.

Write the definitions in plain language, in one shared document, and keep them short enough that a new staff member could follow them. The table below lists what each definition should hold.

Why does each figure need a written definition?
Part of the definition What to write
Name the one label the figure carries on every report, so nobody invents a second one
Meaning one sentence in plain language saying what the figure counts
Source the system the figure comes from and the field it reads
What counts what is included and what is left out, such as voided invoices, internal transfers or test entries
Which date the date that places an item in a period: when it was booked, invoiced, paid or delivered
When final the day a period closes, after which the figure changes only with a written note
Owner the person who answers questions about the figure and approves any change to its definition
  • Every figure on the report has a written definition.
  • Each definition names one source system and one field.
  • The date rule is stated for every figure that falls in a period.
  • Exclusions, such as voided entries and transfers, are listed.
  • The day each period closes is written down.
  • One person owns each definition and approves changes to it.

Which system should each figure come from?

Each figure should come from its system of record, the one place that holds the truth about it. Income usually belongs to the accounting software, enquiries to the CRM and gifts to the donor database. Pulling the same figure from two systems invites a disagreement that no report can settle.

When a figure needs data from two systems, such as hours from a time sheet and income from the accounting software, decide which system supplies each part and how the two are matched.

A client or program code that both systems share does the matching. Without a shared code, matching falls back on names, and names are spelled differently in each system.

Where the match has to hold every day, a lasting link between the two systems does the work, and the page on what a CRM integration is explains how such a link keeps records in step.

Which system should each figure come from?
Figure Usual system of record Common trap
Income and expenses accounting software exports taken before the month is closed
Enquiries and their source a CRM or a shared enquiry inbox the source field left blank or typed by hand
Staff hours a time sheet or payroll system hours logged against a person but not against a client or program
Gifts and grants a donor database a gift recorded in the donor database but not yet in the books
Sales by product a point-of-sale or online store system returns recorded in a different period from the sale
Stock on hand an inventory system counts adjusted by hand without a note

How do you automate reports step by step?

You automate reports by settling their definitions first, then connecting each source, then running the automated version beside the hand-built one until both agree. The order matters because each step depends on the one before it, and skipping the comparison is how a wrong figure reaches the board unnoticed.

The steps below work whether the finished report comes from a spreadsheet, from the scheduled reports in your accounting software, or from a dashboard.

  1. List the questions. Write down the decisions the report supports, such as which services pay or which programs need funds, and drop any figure that answers none of them.
  2. Define each figure. Use the definition table above, and agree each definition with whoever reads the report.
  3. Name each source. Record the system of record and the field for every figure, and confirm that somebody has the access to export or connect it.
  4. Choose the delivery. Decide who receives the report, in what form, and on which day after the period closes.
  5. Connect and schedule. Use the scheduled reports and exports your existing software offers first, and add a connection or a dashboard only where they fall short.
  6. Run both versions. Keep building the report by hand beside the automated one, and compare every figure until they match for two periods running.
  7. Write the fallback. Note how to produce the report by hand if a connection fails, and who checks that each report arrived.

How do you check that an automated report is correct?

You check an automated report by tracing a sample of its figures back to the source records they came from. Pick a few figures each period, find the invoices, gifts or time sheets behind them, and confirm the totals match. A report that cannot be traced to its records should not reach the board or a funder.

The IRS makes the same point about the records underneath any report. Its record-keeping page says that purchases, sales, payroll and other transactions generate supporting documents, and that good records help you monitor the progress of your business and prepare your financial statements (IRS page on record-keeping, updated Friday, May 1, 2026).

Write the definitionName, meaning, what counts,which date, ownerName the sourceOne system and one fieldThe scheduled reportcollects itOn a set day after the periodclosesA person traces a sampleBack to the invoices, gifts ortime sheetsA figure that does not trace goes backto its definition
A figure's path from its written definition to the sample a person traces. A figure that does not trace goes back to its definition.
  • A sample of figures is traced to source records every period.
  • Totals agree with the source system's own reports for the same period.
  • A figure that changes after its period closes carries a note saying why.
  • Someone other than the builder reviews the first automated reports.
  • The report shows when its data was last collected.

How long should the records behind a report be kept?

Keep the records behind a report for as long as the tax rules require, because a report is only as defensible as the records it summarizes. For most business records the IRS general period is three years, and some situations call for longer. Your accountant can confirm which periods apply to you.

The IRS page on how long to keep records sets three years as the general period (IRS guidance on keeping records, updated Tuesday, June 30, 2026).

It sets six years where income left off a return was more than a quarter of the gross income shown on it, and seven years for a claim for a loss from worthless securities or a bad debt deduction.

The periods follow from a rule rather than a habit. The IRS ties them to the period of limitations, the time in which a return can be amended or more tax assessed, and says to keep supporting records until that period runs out (IRS guidance on keeping records).

Once a report runs on its own, keep the exports or snapshots each one was built from, filed by period. A figure can then be traced long after the source system has changed.

What should a nonprofit's board or funder report include?

A nonprofit's board or funder report should show where money came from, where it went, how it compares with the approved plan and what programs delivered. Form 990 (the IRS return most tax-exempt groups file each year) asks whether every voting board member saw the full return before filing (Form 990 instructions, checked Monday, November 16, 2026).

Keep each restricted gift, a donation the donor has limited to a purpose or a period, apart from money the board controls.

  • Which figures belong in a monthly board pack?

    A monthly board pack should hold the same few figures in the same layout every month, each drawn from a written definition, so the board can compare one month with the last and spot what moved. The table below lists the sections most packs need and the system each one usually comes from.

    Which figures belong in a monthly board pack?
    Section of the pack What it shows Usual source
    Income against plan income for the month and the year so far, beside the approved plan accounting software
    Spending against plan spending by program and on running the organization accounting software
    Restricted gifts gifts limited to a purpose, and what has been spent on each donor database and accounting software
    Cash on hand the reconciled bank balance and how many months of spending it covers accounting software after reconciliation
    Program results the measures each funder or the board asked for program records or the CRM
    Fundraising new gifts, renewals and donors who have lapsed donor database

    The IRS encourages a board, directly or through a committee it authorizes, to make sure funds are properly accounted for by regularly reviewing current financial statements and any auditor's letters or finance and audit committee reports (IRS guidance on charity governance, dated Monday, February 4, 2008).

    A pack built from written definitions lets the board do that without anyone rebuilding the figures. Gifts and their restrictions drift between systems most often, so the guide on how to reconcile donations with the books every month is worth working through before the first automated pack goes out.

  • What does the annual return ask about board review?

    The annual return asks whether every voting board member received a complete copy of the final return before it was filed, and how anyone reviewed it: who, when and how closely. Both questions sit in the governance part of the IRS instructions for the exempt organization return, so the board's review leaves a written trace each year.

    Which return applies depends on size. Among organizations other than private foundations, the smallest file the short Form 990-N, those in the middle Form 990-EZ, and the rest Form 990, by gross receipts, everything received from all sources before any expenses are subtracted, and total assets (IRS table of which form to file, checked Monday, November 16, 2026).

  • How the filing lines took their shape

    Those filing lines took their present shape in steps. The IRS phased in its redesigned return, released on Thursday, December 20, 2007: the full return was required above $1 million of gross receipts or $2.5 million of assets for 2008, and above $500,000 or $1.25 million for 2009 (IRS news release IR-2007-204, checked Wednesday, November 18, 2026).

    From the 2010 tax year the lines settled at $200,000 of gross receipts and $500,000 of assets, and the line for the short e-Postcard rose from $25,000 to $50,000, the figures the IRS table still shows (the same IRS release, checked Wednesday, November 18, 2026).

Who should be able to see each report?

Each report should be visible only to the people who need it for their work, and each connection should read only the fields the report uses. The NIST glossary calls this principle least privilege, meaning people and systems receive only the access their assigned tasks need (NIST glossary entry for least privilege).

In practice, a staff report can show totals by program without salaries, and a board pack can show totals without donor names. Give a reporting connection its own account with read-only access where the software allows it, so the report cannot change the records it reads.

When does a firm like Mavrin Labs help?

A firm like Mavrin Labs helps when the definitions are written but the figures sit in several systems that do not share them, or when nobody has the hours to keep a scheduled report running. If one spreadsheet and one person already produce a report everyone trusts, keep it, and spend the effort elsewhere.

Mavrin Labs builds data and reporting that reads from the tools a business or nonprofit already relies on, without replacing them. Every engagement starts with a workflow assessment, the result is agreed before anything is built, and your organization owns all of its data.

Mavrin Labs gives no accounting or tax advice, and the definitions stay yours to approve. The data and reporting service describes the work, and the page on Mavrin Labs as a nonprofit automation agency covers gift entry, donor records and board reporting for nonprofits with paid staff.

Mistakes that make automated reports wrong

Automating before defining
Software repeats whatever rule it is given. Write the definitions first, or the report will disagree with itself faster.
Pulling one figure from two systems
Two sources for the same figure drift apart. Name one system of record and read only from it.
Skipping the side-by-side run
An automated report can look right and still be wrong. Compare it with the hand-built version until every figure matches.
Keeping figures nobody uses
Each figure takes upkeep. Review the report once a year and drop any figure no decision depends on.

Sources behind this guide

The guide rests on nine pages from four public bodies, each opened on the date shown beside it. The figure on specialized software comes from the Census Bureau's report on its 2023 annual business survey, published Wednesday, September 17, 2025 (Census Bureau report on technology use).

The IRS supplies the rules on records and board review. Its governance guidance for charities is dated Monday, February 4, 2008, its instructions for the exempt organization return set out the questions on board review, and each of its three record pages shows when it was last updated.

Its record-keeping page was updated Friday, May 1, 2026, its page on how long to keep records was updated Tuesday, June 30, 2026, and its table of which annual return an exempt organization files was updated Sunday, June 28, 2026 (IRS page on record-keeping, IRS guidance on keeping records and IRS table of which form to file).

The principle of limiting access comes from the glossary of the National Institute of Standards and Technology, which collects the definition from several of its own publications (NIST glossary entry for least privilege). Where those sources say nothing, the guide relies on the planning rules above.

Each claim and its source

The table below pairs each claim the guide makes from outside evidence with that evidence and its publisher.

Each claim and its source
Claim Evidence Source
The figures usually sit in software a business already runs Most businesses described specialized software as very important to their processes or methods (2023 survey report) Census Bureau
Reports rest on supporting documents Transactions generate supporting documents, and good records help prepare financial statements (record-keeping page) IRS
Records behind a report must be kept Three years is the general period, with six and seven years in named situations (keeping records) IRS
A nonprofit's figures feed its annual return Smaller organizations may file shorter annual returns, with the line set by gross receipts and total assets (which form to file) IRS
A board reviews the figures The IRS encourages boards to review current financial statements regularly (governance guidance), and the return asks whether the board saw it before filing (instructions for the exempt organization return) IRS
Reports and connections should see only what they need People and systems receive only the access their assigned tasks need (least privilege) NIST
The filing lines changed in steps from 2008 to 2010 The IRS phased in the redesigned return and raised the e-Postcard line (news release of December 2007) IRS
Rebuilding reports by hand is paid clerical work The occupational outlook gives the jobs, median wage and projected change for bookkeeping, accounting and auditing clerks (the clerks' outlook) Bureau of Labor Statistics

Changes to dates and facts on this page, newest first:

  • Wednesday, November 18, 2026: the IRS news release on the filing lines was added with the history of those lines, the record periods were tied to the period of limitations, and a diagram of a figure's path was added. The clerks' outlook was read again and its figures still match. No earlier figure changed.
  • Tuesday, November 17, 2026: the sentence saying every source was checked on one date was corrected to match the citations, which carry two dates.
  • Monday, November 16, 2026: the clerks' wage and job figures were added, the moved IRS table of which form to file was relinked in all three places, and the two questions on board review were added.

Key takeaways

  • Write a definition for every figure before automating anything.
  • Take each figure from one system of record.
  • Run the automated report beside the hand-built one until they agree.
  • Trace a sample of figures to their records every period.
  • Show each report only to the people who need it.

If the figures live in systems that need joining first, the integration checklist covers planning that connection. If you are still deciding whether a workflow is ready to automate at all, the readiness checks for a workflow come first.

A nonprofit setting rules for AI tools that touch donor data can start from the nonprofit AI-use policy guide. Every guide in the set is listed in the library of guides.

A report built this way aims to give hours back to the staff who used to assemble it, and to give the people reading it figures they can act on.

Frequently asked questions

Can I automate reports without buying new software?

Many reports can be automated without new software, because accounting software, CRM systems and donor databases usually offer scheduled reports or exports of their own. Start there, with the definitions written down, and add a connection or a dashboard only where those built-in reports cannot combine the figures you need. New software fixes a missing connection, not a missing definition.

How often should an automated report update?

An automated report should update as often as someone makes a decision with it, and no more often than that. A monthly board pack needs the closed month, while an enquiry report that sales staff act on may need daily figures. Updating more often than anyone reads the report adds upkeep and shows figures before they are final.

What is the difference between a dashboard and a report?

A dashboard is a screen of figures that people open when they want to look, while a report is delivered on a schedule as a fixed record of a closed period. Both should read from the same written definitions. A board or a funder usually needs the report, because a report stays the same after it is sent.

Who should own the definitions behind a report?

The definitions behind a report should be owned by the person who answers for the figures, often the owner, the finance lead or the executive director. Anyone can suggest a change, but one person approves it and records the date. Without an owner, definitions drift as each new staff member adds a private reading of them.

What should a small nonprofit send its board each month?

A small nonprofit should send its board income and spending against the approved plan, gifts restricted to a purpose, cash on hand, and the program measures the board asked for. Keep the layout the same each month so changes stand out, and add a short note explaining any figure that moved sharply.

Is there an AI tool that can create reports?

Some accounting, CRM and reporting tools include AI features that draft a summary, a chart or a short narrative from figures already in the system. An AI tool can only report figures as reliably as the definitions and sources behind them, so write those first, and have a person check every AI-drafted report before it goes out.

How do I know an automated report is correct?

You know an automated report is correct when a sample of its figures traces back to the source records and the totals match the source system's own reports for the same period. Run it beside the hand-built version until every figure agrees, then keep tracing a few figures each period after that.

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