Maaz Zindani

Loading the index…

↑↓ move↵ openesc close4072 pages

Help for owners

I build my monthly numbers report by hand and want it sent automatically

Short answer

An automated report pulls figures from your sales, accounting or stock systems on a schedule and emails them. The real risk is not the schedule but the numbers: two systems define revenue differently, a source changes and the report keeps arriving with stale or empty figures. Agree the definitions first, and add a check that the report is complete.

  • Written for business owners
  • Updated
  • By Maaz Zindani, Senior Software Engineer

Does this sound like your situation?

  • Every month I copy figures from three places into one sheet.
  • My report and my accountant's report show different revenue.
  • The automatic report arrived, but the numbers looked old.
  • Nobody knows how a figure in the report is calculated.
  • The report stopped arriving and nobody noticed.

Why does this happen?

  1. Each system defines the figure differently

    Revenue can mean orders placed, orders shipped, invoices raised or money received, with or without tax and refunds. The same word then gives different totals.

  2. Time zones and cut-off dates

    A sale at 11 pm on the last day belongs to different months depending on the time zone and cut-off the report uses.

  3. The data source changed

    A renamed field, a new product category or a changed login in the source system can leave a section empty while the report is still sent.

  4. Data is incomplete when the report runs

    A report that runs at midnight can include orders still being processed or payments still pending, then differ from the final figures.

  5. No one owns the report

    When the person who built the spreadsheet or script leaves, nobody understands the formulas, and nobody notices a silent failure.

What can I do about it today?

  1. List the five to ten figures you really useFor each, write which system it comes from and what counts. Drop the rest, as a short report is read.
  2. Agree the definitions with your accountantRevenue, margin and cash are different things. Write one sentence for each.
  3. Keep your manual report once moreBuild the automatic one beside it for a couple of cycles and compare, before you trust it.
  4. Decide who receives itThe report can show sensitive figures. Send it to named people only, not to a shared mailbox.
  5. Choose the day and timePick a time when the previous period is closed, not midnight on the last day.

When should I bring someone in?

  • Figures from different systems must be combined and do not match.
  • The data is spread across spreadsheets nobody trusts.
  • You want alerts when a figure moves outside a normal range.

How do I handle it?

  1. Write the definitions downEach figure gets a sentence and a source, so the report can be explained in a meeting.
  2. Read the sources through their documented interfacesI use the official APIs or exports of each system, and check their limits and permissions from the vendor documentation.
  3. Compare with your manual reportFor the first cycles I run both and explain every difference before the manual one is retired.
  4. Add a completeness checkIf a source returns nothing, or a figure is zero when it is never zero, the report says so at the top instead of staying silent.
  5. Hand over a plain explanationA short page describes where each number comes from and who to ask, so the report survives a change of person.

The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.

What do owners ask about this?

Can the report include charts?

Yes. A few clear charts or a table are possible. I would start with the figures you use, then add visuals.

Should it be a dashboard instead of an email?

A dashboard suits people who want to explore. An email suits an owner who wants the numbers to arrive. Either can use the same figures.

Can it explain the changes in plain words?

A written summary can be generated, but it should be checked against the figures. I would not send one that nobody reads.

What if a source system has no export?

I check whether it has an API or a scheduled export in its documentation. If not, I tell you what is realistic before building anything.

How was this page made?

I drafted this page with AI assistance. It is general guidance for business owners, not advice for your own system. Found a mistake? Tell me.

Next step

Want this off your desk?

Send me a few lines on where things stand. I reply within 24 hours.