← all the work AndreawithAI 02 / 09 IT

A cash flow that updates itself.

A cash flow sheet fed by the sales platforms' data: it updates with a single sentence and stops if the numbers don't add up.

problem
numbers copied by hand from three dashboards
for whom
online shops that sell on several channels
where
the spreadsheet the team already uses
status
in use for a few months

01The problem

An online shop that sells on four channels has its numbers scattered across three dashboards, and every morning someone copied them by hand into a sheet. In the starting case the total row added up only one of the two revenue columns: read on its own, each day looked right; the month-end totals did not. Rebuilt from the raw data, the same period changed sign.

02How it is used

  1. You ask for the update in one sentence, for example “update the cash flow”.
  2. It finds the missing days, up to yesterday, and takes the data directly from the platforms.
  3. It checks before writing. If the numbers don't add up, the update stops and flags the problem instead of filling the cells.
  4. The sheet stays as it was: same columns, same formulas, the same reading the client is used to.

03How it is built

  • Sourcesthe raw data from the sales and advertising platforms: revenue, orders, spend
  • Writingonly the cells for the missing days; it doesn't overwrite what it finds and doesn't touch the formulas
  • Checksthe totals are reconciled before every row; the last day written is always yesterday
  • Assistantinterprets the request and coordinates the work; the numbers are calculated by code

04Results

The rebuild brought to light over a third of the revenue that the sheet had never added up, over eight months checked against the source. Since then no number has been copied by hand.

The sheet fills itself in · blue cells written by the automation, sheet formulas in italics
›update the cash flow
dayrevenueordersadssourcesVATnetmargin
✓the numbers must add up
✓doesn't overwrite what it finds
✓stops at yesterday
before: the period total counted one column only · the second one, over a third of the revenue, was not added up by any formula. Daily values below: an example, the structure is the real one.
1/3+of the revenue the file had never countedrebuilt from the shop's source, month by month
8months rebuilt from the right sourcesame source, same period as the sheet
0numbers copied by hand, since thensince then; client anonymous by choice
1sentence to update everythingthe sheet stayed the one the client already knew how to read

updated on 26 Oct 2026