PLATE P.6.3 — AUTOMATED REPORTING

Automated reporting: scheduled reports that arrive already reconciled

Automated reporting is the weekly sales sheet, the month-end debtors list or the job-cost report produced by the system instead of a person. The figures are pulled from your sales, job and accounts software, reconciled and checked, then sent to each reader at the time you set. Ozwebnet writes it from scratch in Adelaide, South Australia, for businesses across Australia — one fixed quote staged against milestones, and the source code handed over with the IP assigned to you.

DETAIL OF SHEET 06 — DATA PLATFORMS →

FIG. P.6.3 — THE PLOTTER: THE STACK BESIDE IT IS THE WEEKLY REPORT, DRAWN AND SENT WITHOUT ANYONE ASKING · HOVER TO POUR
GENERAL NOTES 02 / 07

What is automated reporting?

The weekly or month-end report that someone assembles by hand — export from Xero, export from simPRO, paste into a spreadsheet, fix the totals, email it — is produced instead by a system on a schedule. The system reads the period's figures from each source, applies the same matching rules every time, checks that the totals agree with the systems they came from, and delivers the finished report as a PDF or spreadsheet to its readers. If a check fails, the report is held and someone is told, rather than a wrong report going out.

SECTION A–A 03 / 07

Who should have their reports automated?

BUILT FOR
Businesses where one person loses a morning every week or month rebuilding the same report; owners whose figures arrive late when that person is away; multi-branch firms that send one report to many readers.
REPLACES
The Monday-morning spreadsheet pasted together from three exports; the month-end pack that waits on whoever knows the formulas; the report that is a week old by the time it is read.
NOT FOR
A business that wants to open a screen and see today's figures as they stand (that is dashboards and reporting), or whose single system already sends the report it needs on a schedule — we will say so.
SCHEDULE OF WORKS 04 / 07

What is included in an automated reporting build?

01

The report you build by hand today, written down column by column

We take the spreadsheet as it is built now — every column, total, exception and footnote — and record where each figure comes from and who receives it, so the automated report matches the one people already read.

02

Figures pulled from each source on the schedule you set

At the start of the week, on the first of the month or the day after period close, the system reads the period's figures from Xero, MYOB, simPRO, ServiceM8, Cin7 or your own database — or from your data warehouse where one exists. No one exports anything.

03

Reconciliation before anything is sent

The figures are matched by the rules set at specification — invoice to job, job to sale, payment to invoice — and the totals compared with the systems they came from. A report does not leave until its numbers agree.

04

Checks that hold a wrong report instead of sending it

A source that did not answer, a period with missing entries, a total far from last period's: the report is held, the person responsible is told exactly what to fix, and a report that failed its checks does not go out under your name.

05

Delivered to each reader in the form they read

The owner's one-page summary, the branch manager's page, the accountant's spreadsheet — each reader receives the version for their role, by email, into a shared folder or to a portal, as a PDF, a spreadsheet or both.

06

A record of every report sent, and any period re-run on demand

Each report that went out is kept with its date, its figures and its readers, so last March's numbers can be found and re-sent, and any past period can be run again from the same screen when a question comes up.

07

Changes made once, in one place

When a column is added, a branch opens or a matching rule changes, it is changed once in the report definition and every future run and every reader gets it. Nobody hunts through spreadsheet formulas.

TYPICAL SCOPE FOR THIS KIND OF SYSTEM — YOUR EXACT SCOPE IS FIXED IN WRITING AT THE SPECIFICATION STAGE.

Not sure which? Ten minutes on 1300 699 321 tells you — Mon–Fri 9–5 ACST.

STAGES 05 / 07

How is automated reporting built and priced?

One fixed quote, set in writing at the specification stage (02 Blueprint) and staged against the five milestones below. Each milestone ends with a working system; stop at any milestone and keep what has been built.

SEE THE FIVE STAGES ANIMATED 
  1. 01 SURVEY

    Discovery

    We watch the report being built by hand once, and note every source, formula, exception and reader along the way.

  2. 02 BLUEPRINT

    Specification

    The report layout, its sources, its matching rules, its checks and its schedule are specified in writing; the fixed quote is set here, staged against milestones.

  3. 03 FORGE

    Build

    Built one report at a time; each milestone ends with a report that runs and arrives on its own.

  4. 04 TEMPER

    Testing

    The automated report is run beside the hand-built one for the same period until the two agree, then tested before launch.

  5. 05 DEPLOY

    Launch

    The reports go live on their schedule, and you receive the source code with the IP assigned to you.

REQUESTS FOR INFORMATION 06 / 07

Questions before you call

RFI-01Can the report we build by hand each week be automated?

Yes. We take the spreadsheet as it is built now — every column, total and exception — record where each figure comes from, and the system produces the same report on the schedule you set, pulling from Xero, MYOB, simPRO, ServiceM8, Cin7 or your own database.

RFI-02What happens if the figures are wrong on the day the report is due?

The report is held. The totals are checked against the systems they came from and against the last period; if a check fails, the person responsible is told what to fix and the report stays held until it is fixed.

RFI-03How much does automated reporting cost?

One fixed quote, set in writing before the build and staged against milestones.

RFI-04Do we own the reporting system?

Yes — source code delivered, IP assigned to you.

RFI-05Do you build automated reporting for businesses outside Adelaide?

Yes — Adelaide first, Australia-wide. The reports are written in Adelaide and run against your systems wherever your office is.

RFQ — REQUEST FOR QUOTE 07 / 07

Get a fixed quote for automated reporting.

Call, or answer a few short questions — what you run, what breaks, when you need it working — and we reply within one business day. The quote is fixed in writing before any build starts.

CALL 1300 699 321 Mon–Fri 9–5 ACST · REPLY WITHIN ONE BUSINESS DAY