Automated reporting: how the weekly report writes itself
By NoWorkr · Published
Automated reporting is when a system, not an employee, collects, calculates and sends your weekly or monthly report. You get there by working through four links: the sources, the collection, the calculation and the delivery. Most Danish SMBs can get halfway with the systems they already pay for.
That is the short version. The long one is about why most companies still build the report by hand, even though every number already exists digitally.
The answer is almost always the same: the numbers sit in three different systems, nobody has decided exactly how they should be added up, and so one person with a spreadsheet ties it all together every Friday. This guide takes the four links one at a time, and it also tells you when to leave a report manual.
What automated reporting is, and what it is not
People mix up three things when they say automated reporting.
The first is a tidier spreadsheet. You still have an employee pulling numbers, but now the formulas are in place. That is not automation, it is housekeeping.
The second is a dashboard. You log in and see the numbers live. It is better, but it depends on someone remembering to log in, and management typically does that for the first month only.
The third is the real thing: a system that collects the numbers itself at a fixed time, calculates them by a rule you have decided, and drops the result in the inbox of the people who need to act on it. The report arrives even when your bookkeeper is on holiday.
Only the third kind frees up time. A dashboard moves the work. It does not remove it.
One last clarification: if you search for automated reporting, you will also run into the Danish Business Authority's initiative Automatisk Erhvervsrapportering (Automatic Business Reporting). That is something else, namely the state's work to automate companies' filings to the authorities. We come back to it further down, because it will matter to you in a couple of years.
The four links in a report that writes itself
Every reporting flow has the same four links. Find the link where your time goes, and start there.
1. The sources: where the numbers live
First, write down which systems the numbers come from. For a typical Danish SMB that is three to five: a CRM, an accounting package, maybe a webshop, a time-tracking tool and a spreadsheet.
The spreadsheet is the key finding. If there is a spreadsheet in the chain that someone maintains by hand, that is where the automation stops. Either its contents have to move into a system with an API, or the spreadsheet has to go.
2. The collection: pulling data without touching anything
Each system has to hand over its numbers without anyone clicking. In practice that happens in one of three ways: an API call, a scheduled export or a direct database connection.
Most Danish tools can do this. e-conomic and Dinero have open APIs, and so do nearly all CRM and webshop systems sold in the last ten years. The problem is rarely the technology. It is that nobody has set up the access.
3. The calculation: the rule nobody has written down
This is where the real work sits. A report is not numbers, it is numbers added up according to a decision.
What counts as a won deal? Is revenue counted when the order is placed or when the invoice is posted? Which customers belong to which salesperson when two of them have touched the deal? These are the questions that normally live in the head of whoever builds the report.
If you can state the rule in one sentence, it can be built. If you can't, automation is not the problem. The rule simply hasn't been decided yet. We see this as the most common single problem at new clients, exactly as in the invoicing chain, where the same applies to what should appear on the invoice.
4. The delivery: who gets it, and what they do
The last link is the easiest one, and the one people spend the most time debating. The report has to land where the recipient actually looks: email, Slack, Teams or a fixed page.
The rule that pays off is that every report has one recipient who is meant to do something. If nobody is meant to do anything, the report should not be sent. Then it is a dashboard you can look things up in, and that is a different job.
Where the numbers live: CRM, accounting and webshop
In practice, a weekly report almost always pulls from the same three sources.
The CRM delivers pipeline: new leads, quotes sent, deals won and lost. The pitfall here is data quality. Automated reporting does not make poor CRM data good. It just makes it visible every Monday, and that is actually one of the best reasons to do it.
The accounting software delivers the money: invoiced revenue, outstanding amounts, overdue items. It is the most reliable source you have, because the figures are posted and therefore reconciled.
The webshop or order system delivers volume: orders, average order value, returns. Be careful here about mixing gross figures from the shop with posted figures from accounting. The two will never match, and a report that shows two different revenue numbers won't be used more than once.
The practical order is therefore: begin with the accounting software, layer the CRM on top, and bring in the webshop only once the first two are running.
Three levels of automated reporting
You don't need all of it at once. The three levels cost and return very different amounts.
| Level | What you get | Time to go live | Fits |
|---|---|---|---|
| Scheduled standard reports | The reports your system already offers, sent on a schedule | A couple of hours | Everyone. Do it today |
| One report across systems | A single weekly report with numbers from CRM, accounting and shop | A few weeks | Most SMBs |
| Report with assessment and commentary | Numbers plus a short written explanation of deviations | A longer project | Companies with a fixed reporting rhythm |
Level one is free and almost always overlooked. Accounting packages, CRM systems and most webshops can email a fixed report on a schedule. Check before you buy anything.
Level two is where a build makes sense, because no single vendor can combine data across systems they don't own.
Level three is the newest. Here an AI model reads the numbers and writes the two paragraphs a controller would otherwise write: what changed, and what deserves a closer look. It requires level two to be running reliably first. For more on where AI actually makes a difference, see our guide to AI automation for SMBs.
What the state is automating: Automatisk Erhvervsrapportering
While you automate your own reports, the Danish Business Authority (Erhvervsstyrelsen) is working to automate the reports you have to send to the authorities. The initiative is called Automatisk Erhvervsrapportering (Automatic Business Reporting), and the government expects burden reductions of at least DKK 3.5 billion a year from digital bookkeeping alone, based on a business case from KPMG, reviewed by PWC.
The next phase automates the handling of receipts and the reconciliation between bookkeeping and bank data. With that phase, the total potential burden reduction rises to DKK 21.5 billion, of which up to DKK 9 billion a year comes from the phase alone, according to the Ministry of Industry, Business and Financial Affairs (Erhvervsministeriet) in February 2026.
What does that mean for you? First of all, that you don't need to build anything yourself to handle filings. It is coming. On the other hand, the whole thing assumes that your data sits in a digital bookkeeping system and not in a spreadsheet next to it. That cleanup is the same one you need to do to automate your own reporting, so it works for you twice.
How to get started with automated reporting
Count first, choose tools later.
- Write the reports down. Every report produced in your company: who makes it, how long it takes, and who reads it. It takes half an hour and decides everything else.
- Delete the reports nobody acts on. There is always at least one. It is the fastest saving there is.
- Look at level one. Check whether your accounting software and CRM can send the remaining reports on a schedule themselves. Set it up right away.
- Pick one report for level two. The one that takes the longest and is read by the most people. Write the calculation rule in one sentence before anyone touches the technology.
- Run it for a month before you take the next one. Reports built at the same time fail at the same time. That is the whole idea behind our process.
If you want to put kroner on the time before you decide anything, you can work it out in our ROI calculator. We typically find 15 hours a week at a client. Reporting is rarely the whole saving on its own, but it is almost always part of the sum, together with invoicing and standard enquiries.
A scoped build starts from $1,500 as a one-time payment. We have built 53 automations for Danish companies, and at Markeity they save DKK 20,000 a month on systems we built once. You can see what that looks like in practice in our client cases.
What you should not put on autopilot
Automated reporting is the wrong call in three cases, and it is worth knowing them up front.
The first is the report nobody reads. If you automate it, you have built a system that produces something unused, and now it also costs maintenance. Delete it instead.
The second is the report where the calculation changes every time. If the definition of a good quarter is negotiated from meeting to meeting, there is no rule to build on. Get the decision made first.
The third is the report produced twice a year. You need volume before automation is the cheapest option. Without it, the honest answer is that you should spend the money somewhere else in your operations.
FAQ
What is automated reporting?
Automated reporting is a system that pulls numbers from your source systems on its own, adds them up by a fixed rule and sends the result to the right recipients at a fixed time. Nobody has to start it, and nobody has to remember it.
It differs from a dashboard, where you have to log in yourself, and from a spreadsheet with formulas, where an employee still has to fetch and paste the numbers.
Can I automate reporting in Excel?
Partly. Excel and Google Sheets can pull data from a range of systems and refresh themselves, and that is a fine way to move from manual work to something half-automatic.
The limit shows up in two places. A spreadsheet can't forward the report with a comment to the right person on its own, and it breaks when a column is moved. If the report has to run for years without supervision, the logic belongs somewhere other than a spreadsheet.
What does it cost to automate reporting?
Level one, where you use the scheduled reports your systems already have, costs nothing beyond the time it takes to set up. It should always be the first step.
A combined report across CRM, accounting and webshop is a build, and with us a scoped build starts from $1,500 as a one-time payment. It is not a subscription, and you own the source code and documentation afterwards, with zero lock-in.
How long until the report runs on its own?
For a single report with two or three sources, it typically takes about 3 weeks from audit to launch, and most of that time goes into getting access sorted and deciding the calculation rule, not into building.
We work to measurable ROI within 90 days, and if it isn't there, we keep working until it is.
Begin by writing down who makes which reports and how long it takes. The answer to that question decides whether automated reporting is your next job or your third.