FLOW-30

Synthetic books · one bottleneck

The finance loop, worked with the tools you already have

Harbourline Supplies is fictional. The invoices, the bank lines and the 30-day result are invented. The founding cohort has not run. The point is the process: find the delay, log it, decide what AI may draft, and keep a person on the amount.

The same instructions work in ChatGPT, Microsoft Copilot and Gemini. The tool does not clear the ledger, release a payment, or send the reminder.

These replies are worked examples written to those instructions. They are not transcripts from ChatGPT, Copilot or Gemini. Paste the prompt into the tool your organisation already allows, and compare.

F Find L Log O Screen W The three tools The person checks 30 The decision

F · Find

The delay is the match and the chase

Harbourline Supplies is a fictional 36-person equipment distributor in Singapore. Customers pay by GIRO, PayNow and transfer. The description on the bank line often leaves out the invoice number. The accounts assistant then hunts for the invoice and, when the books still show it open, writes a collection note from scratch.

On a week like this one, that loop is about six hours. About three hours go to matching. About two hours go to writing notes. About one hour goes to correcting a note that asked for money already received, or for a balance a credit note had already reduced.

L · Log the baseline

The books as at 30 October 2026

Customer legal names are already replaced with codes. There are no bank account numbers. That is the form in which this list may be pasted into a tool.

Download the synthetic books (.csv)

Open documents · net S$15,458.50
CodeDocumentKindDateDueAmount (S$)
C-014INV-1044Invoice12 Aug 202611 Sep 20264,280.00
C-021INV-1061Invoice2 Sep 20262 Oct 20261,860.50
C-044INV-1052Invoice20 Aug 202619 Sep 20263,140.00
C-044CN-019Credit note2 Oct 2026—−140.00
C-033INV-1077Invoice18 Sep 20262 Oct 2026640.00
C-014INV-1088Invoice1 Oct 202631 Oct 2026910.00
C-052INV-1092Invoice8 Oct 20267 Nov 20262,750.00
C-021INV-1099Invoice15 Oct 202614 Nov 2026430.00
C-061INV-1104Invoice22 Oct 202621 Nov 20261,588.00
Bank receipts in October · S$9,190.50 · still unmatched in the books
LineDateDescription as it arrivedAmount (S$)
B-013 Oct 2026GIRO C014 AUG4,280.00
B-029 Oct 2026PAYNOW 1860.50 REF 10611,860.50
B-0314 Oct 2026TRANSFER 640640.00
B-0421 Oct 2026C052 PART 15001,500.00
B-0528 Oct 2026MISC 910.00910.00

What last month already cost

  • 12 collection notes sent.
  • 2 asked for invoices the bank had already received. The description had no invoice number, so the books still showed them open.
  • 1 asked for the invoice total after a credit note.

The control total, before any matching: documents S$15,458.50 minus receipts S$9,190.50 leaves S$6,268.00. A reply that does not land on that difference has dropped a row.

O · Screen the option

AI may draft. It stays away from the release.

May do
  • List candidate matches, marked likely or only possible.
  • Leave a part-payment as a balance.
  • Apply an open credit note before stating a balance.
  • Draft one reminder from the approved template.
Must stay away
  • Marking an invoice paid, or posting to the ledger.
  • Releasing a payment or a credit.
  • Sending the reminder.
  • Chasing a code that is not yet due, or that has a likely match still waiting for a person.

Eligibility is ordinary. The work repeats every week, the saving is staff time and fewer wrong notes, and the material can be reduced to codes. The exposure is a wrong balance sent to a customer. The control is a named reviewer. No new system is required.

W · Write the workflow, then run it

One prompt. Three places to put it.

Use the tenant the company has already approved. A personal ChatGPT, Copilot or Gemini account is the wrong place for a real customer list. This demonstration uses codes only, so the paste itself contains no legal names and no account numbers.

The prompt

You are helping an accounts assistant. Today is 30 October 2026. Do not mark anything paid. Do not send email. Do not change a figure. Suggest only.

Documents (SGD). A credit note reduces the balance for that code.
C-014, INV-1044, invoice, 12 Aug 2026, due 11 Sep 2026, 4280.00
C-021, INV-1061, invoice, 2 Sep 2026, due 2 Oct 2026, 1860.50
C-044, INV-1052, invoice, 20 Aug 2026, due 19 Sep 2026, 3140.00
C-044, CN-019, credit note, 2 Oct 2026, no due date, -140.00
C-033, INV-1077, invoice, 18 Sep 2026, due 2 Oct 2026, 640.00
C-014, INV-1088, invoice, 1 Oct 2026, due 31 Oct 2026, 910.00
C-052, INV-1092, invoice, 8 Oct 2026, due 7 Nov 2026, 2750.00
C-021, INV-1099, invoice, 15 Oct 2026, due 14 Nov 2026, 430.00
C-061, INV-1104, invoice, 22 Oct 2026, due 21 Nov 2026, 1588.00

Bank receipts still unmatched:
B-01, 3 Oct 2026, GIRO C014 AUG, 4280.00
B-02, 9 Oct 2026, PAYNOW 1860.50 REF 1061, 1860.50
B-03, 14 Oct 2026, TRANSFER 640, 640.00
B-04, 21 Oct 2026, C052 PART 1500, 1500.00
B-05, 28 Oct 2026, MISC 910.00, 910.00

Return four lists:
1. Likely matches, and why.
2. Possible matches. Say what is missing.
3. Documents not yet due. Do not draft a chase for these.
4. One reminder only, for a code that is overdue, has no likely match waiting, and is stated after open credit notes.

Reminder template, keep this shape:
Subject: Invoice [number] — balance outstanding
Hello,
Our records show invoice [number] dated [date] still has a balance of S$[amount].
Please reply with the payment date, or tell us if a credit note should be applied.
Harbourline Supplies
Accounts

Then add the control total: documents minus receipts. Documents net 15458.50 and receipts are 9190.50. If your remaining balance does not reconcile to the difference, say which row you dropped.
ChatGPT

A blank chat

Paste the prompt. Ask for the four lists. If the thread starts inventing customer names or a payment run, stop and paste the prompt again with the first line repeated: do not mark anything paid.

Copilot

Inside the workbook

The same rows already sit on two sheets. Ask Copilot in Excel to add Days past due with a formula you can see, and to put suggestions on a new sheet. It must not overwrite Amount, and it must not add a Paid column.

The formula to accept or reject is =MAX(0, DATE(2026,10,30)-D2) where D2 is the due date, and a blank due date stays blank.

Gemini

A Sheet, or a blank chat

In a company Google account, point Gemini at the Invoices and Bank tabs and give it the same four lists. In a personal Gemini chat, paste the prompt exactly as for ChatGPT. The place changes. The instruction does not.

Worked reply

What a careful answer looks like

1 · Likely matches · a person still ticks these
ReceiptSuggested documentWhy
B-01 · S$4,280.00INV-1044 · C-014Same amount. The description has the code and “AUG”, which fits the August invoice. It does not contain the invoice number.
B-02 · S$1,860.50INV-1061 · C-021The amount matches, and the description contains 1061.
B-05 · S$910.00INV-1088 · C-014The amount matches the October invoice. C-014’s August invoice is already the likely match for B-01. The description has no code, so this stays likely rather than certain.
2 · Possible only · do not clear
ReceiptCandidateWhat is missing
B-03 · S$640.00INV-1077 · C-033The amount is unique. The description has no code and no invoice number. Amount alone is not a match.
B-04 · S$1,500.00INV-1092 · C-052The description says part payment. The invoice is S$2,750.00, so S$1,250.00 stays open. Due 7 November, so there is no chase on 30 October.

3 · Not yet due

INV-1088 if B-05 is accepted, the INV-1092 balance of S$1,250.00, INV-1099 (S$430.00) and INV-1104 (S$1,588.00). No reminder.

4 · The one reminder

C-044, INV-1052, is overdue and has no bank line. Credit note CN-019 for S$140.00 is still open on the same code. The balance to state is S$3,000.00.

Subject: Invoice INV-1052 — balance outstanding
Hello,
Our records show invoice INV-1052 dated 20 August 2026 still has a balance of S$3,000.00, after credit note CN-019 for S$140.00.
Please reply with the payment date, or tell us if a further credit note should be applied.
Harbourline Supplies
Accounts

Control total: S$15,458.50 − S$9,190.50 = S$6,268.00. If B-01, B-02, B-04 and B-05 are later accepted and B-03 is held, the open items are S$3,000.00, S$640.00, S$1,250.00, S$430.00 and S$1,588.00, which sum to S$6,908.00. The S$640.00 gap is the held line.

The short prompt, and the rework it causes

“Write chase emails for everything unpaid.”

Paste only the invoice numbers and the amounts, and leave out the bank lines, the credit note and the as-at date. The draft then chases INV-1044 and INV-1061, which are the likely matches already in the bank, and it asks C-044 for S$3,140.00. That is the hour spent correcting last month’s notes. The lists, the credit note, the date, and the line “do not mark anything paid” are the controls.

The person, before anyone relies on it

What the assistant accepts, holds and sends

While B-03 and B-05 stay held, S$1,550.00 of receipts are still unexplained and the open balance is S$7,818.00. Accepting both would bring the open balance back to the control difference of S$6,268.00.

Monday’s step, on a real file: export ten open documents and the unmatched receipts, replace legal names with codes, paste into the approved tool, and tick or reject every line. Time the matching. Count how many drafts you change before sending.

30 · Review and decide

After four weeks, the decision is Scale

The figures below are synthetic. They describe this fictional pilot, not a client.

What was counted
MeasureBaselineOver 30 days
Hours on this loopAbout 6 a weekThe messy match fell from about 12 minutes to about 4
Suggested matchesNone. Each line was searched by hand.22 suggested. 18 accepted, 3 rejected, 1 corrected. The correction was a part payment the draft had treated as full.
Reminders12 sent last month, 3 of them wrong9 drafted. 8 sent after the balance was checked. 1 held.
Ledger and mailboxThe assistant posted and sentThe tool posted nothing and sent nothing

Scale the suggestion list and the draft reminder. Keep the named reviewer on the amount, the customer and the send.

The hours that came back are capacity. They are not profit, unless the company actually spends less.

A shorter fictional finance pilot sits in the case gallery. This page is the worked process behind that kind of result. Check a different bottleneck if the delay in your company is not the invoice and the unpaid balance.