Guide
How to automate reports so the figures agree
By Mavrin Labs. Published . Last updated . Reviewed by Mavrin Labs on . How this guide was researched and checked.

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.
| 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.
| 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.
| 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.
- 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.
- Define each figure. Use the definition table above, and agree each definition with whoever reads the report.
- 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.
- Choose the delivery. Decide who receives the report, in what form, and on which day after the period closes.
- 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.
- Run both versions. Keep building the report by hand beside the automated one, and compare every figure until they match for two periods running.
- 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).
- 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.
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.
| 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.
Related guides
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.
