Reporting and data automation

Five questions your systems can already answer

Who has gone quiet, who is ordering less, who pays late, where the margin went and which supplier prices have crept up. The answers are in figures you already hold. We get them out as names and pounds, every week.

What it is: Reporting and data automation means the figures already held in your accounts, order and stock systems are read on a schedule, joined together and turned into answers a person can act on, such as which customers have stopped ordering, who always pays late and where the margin has gone. Better Systems Co. also builds the weekly and month-end reports automatically, in the workbook you already use. Reporting only reads. Your systems stay as they are.

Mark's Friday report says what was sold. Not who stopped buying.

Mark is the operations manager at a food manufacturer. Every Friday after lunch he exports the week's sales from Sage, the stock from the warehouse system and the orders from the web shop. He pastes all three into a workbook, mends the columns that moved, and hunts for the number that will not agree. The report reaches the owner at half past five.

It says what was sold this week. It cannot say that a café which ordered every Tuesday for three years has not ordered since September. That answer needs last year's orders set beside this year's, and Mark is out of afternoon.

The workbook fills itself at seven on Friday morning. Same layout, same formulas. The two figures that do not agree, sales in Sage against orders on the web shop, are listed on the first sheet with the records behind them.

On Monday there is a second sheet. Eleven customers who used to order every week and have not for a month, with what each was worth last year. Four whose orders have halved. Six who paid more than thirty days late every time. Somebody rings the café.

The people in this story are made up. The work is not. Your own figures come from the assessment.

What it is worth. Say the report takes Mark three hours a week. That is about 144 hours a year of a manager's time. The lists are worth more, and how much depends on what they find, so we will not guess. The assessment answers the five questions once from your own figures. You see names and pounds before you pay for anything to be built. Try your own numbers in the calculator.

Who it is for

Owners and managers who get their numbers late, suspect that customers or margin are slipping away unnoticed, and have nobody whose job is to look.

What you get

  • Five lists, refreshed on a schedule. Customers who have gone quiet, customers ordering less, late payers, margin by customer and product, and supplier prices that have risen.
  • Names and pounds, not charts. Each list says who, how much and since when.
  • A named person for each list, so somebody rings the customer or queries the supplier.
  • Your weekly and month-end reports built for you, in the Excel workbook you already use.
  • Figures checked against each other. Orders against invoices, stock against sales, bank against ledger.
  • A written definition of every figure, so two managers stop arguing about whose number is right.
  • Nothing is changed in your systems unless you ask. Reporting only reads.

Price

£1,500 to £7,500

One report or one list from one system is at the lower end. Answers that need two systems joined, such as margin by customer where sales and costs live apart, sit higher. See the pricing page for how bands are set.

Ask about reporting and data automation

How it goes

  1. We answer the five questions once

    As part of the assessment, from exports of your own figures. You see what is there before anything is built.

  2. We agree which answers you want every week

    Which lists and reports, how often, and who acts on each one.

  3. We connect the sources

    Read-only access to each system, approved by its owner and your IT provider, tested against a copy first.

  4. It runs itself

    The lists and reports arrive on a schedule. Your team gets the definitions and a named person to ring when a figure looks wrong.

Questions people ask

Sage and Xero have their own assistants now. Why would we need this?

For a question that lives in one system, try the built-in tools first. Sage Copilot and Xero's JAX are improving, and some answers are already there as standard reports. They stop at questions that need two systems, such as margin by customer when sales are in one place and costs in another, or a supplier invoice checked against the price on your order. That is the part we build.

Do we need Power BI or a dashboard?

Usually not to begin with. A list of names and amounts, sent to the person who will act on it, gets used. A chart often does not. If you already have Power BI, we can feed it.

Can we keep using Excel?

Yes. Most clients want the same workbook they have always used, with the figures arriving on their own instead of being pasted in. We keep your layout and formulas and replace the export-and-paste step. A web page showing the same figures is an option, not a requirement.

Does this need a new system or a data warehouse?

No. For a business of 10 to 100 staff, a scheduled job that reads each system and fills a workbook is usually enough. If your volumes need more than that, we will say so and explain why.

What if the systems disagree with each other?

They will, which is one of the reasons to do this. Differences are listed with the records from both sides so a person can decide which is right. Over a few months most of the causes get fixed where they start.

Related reading

Find out what the typing is costing you

A 20-minute call. You tell us about your Sandra, your Dave or your Phil, and how the job gets done today. We tell you honestly whether automating it would pay, and what it would cost.