Turning Your Journal into Machine-Readable “Single-Line Entries” – a Copy-and-Paste AI Prompt

COLUMN | Cash Flow & AI (a 3-part series) — Part 2

Turning Your Journal into Machine-Readable “Single-Line Entries” — a Copy-and-Paste AI Prompt

August 26, 2026 — Suzuki Tax Accounting Firm (Okayama, Japan)

In Part 1 we said: put a label of meaning on each journal entry, and a cash flow statement
becomes nothing but addition and subtraction. The first step is reshaping your journal into a
form a machine can read — single-line entries (one debit, one credit, one fact per line).
Copy the box below into an AI assistant (ChatGPT, Claude, Gemini, etc.), then paste in the
journal data exported from your accounting software (CSV, or a copied table).

Before you paste: journal data may contain customer names, employee pay,
bank details and other personal or confidential information. Check the data settings of the AI
service you use (whether a plan uses your input for training) before trying this. If in doubt,
anonymize the data first — we are happy to advise on how.
THE PROMPT (copy from here down)

You are a converter of accounting data. Rebuild the journal data I am about to give you
into “single-line entries” under the following rules.

■ Output format (one line = one fact)
Each line has 8 columns: voucher number (grouping ID) / date / debit account / debit sub-account /
credit account / credit sub-account / amount / description. Output as a table or CSV.

■ Conversion rules
1. Every line must be exactly one debit × one credit. Never output a one-sided line.
2. Keep gross amounts. No netting. Discounts and returns stay as reversing lines.
3. Eliminate pass-through bridge accounts (“sundry”, “clearing”, compound-transfer accounts
with no real-world substance). Do not confuse these with a suspense account used to hold
unidentified items inside the books — that practice is fine, and is covered in Part 1. Within the same date, treat a group of lines whose bridge debits and
bridge credits balance as one transaction, and connect the real accounts directly, without the
bridge. If one side is a single line, use its account as the counterpart and expand the other
side line by line. If both sides have multiple lines, output them as several lines (each one
debit × one credit) sharing one voucher number.
4. Give all lines of one transaction the same voucher number (the number is the only
thing that expresses the grouping).
5. Split batch payments to the same granularity as the originating lines. When a payment
is bundled (e.g. “accrued payables X / bank X” for a card settlement), split it by the same
breakdown — but only if the originating lines (the individual charges) exist in the data.
Always verify the split sums exactly to the original amount. If no originating lines are found,
do not split: keep the line and flag it “NEEDS REVIEW”.
6. Never invent an amount. Never rewrite a description. If a line is unclear, do not
guess — put a flag and the reason in a “NEEDS REVIEW” column.

■ Self-check (always report at the end)
• Total debits and total credits, before vs. after conversion — identical to the last cent/yen?
• Per-account totals (debit and credit separately), before vs. after — identical?
(Bridge accounts alone disappear; show that their debit total equalled their credit total before conversion.)
• If anything fails to reconcile, do not output the result — report which lines broke instead.

■ Conversion log (always append)
• lines read, lines produced
• number of transactions where a bridge account was eliminated
• number of batch payments split
• number of lines flagged NEEDS REVIEW, with the list of reasons

Always read the AI’s self-check report before using the output. Deciding the flagged lines,
and posting anything back into the books, remains a job for people — you and your accountant.

The two things that matter: never let the AI fill in what it doesn’t know, and always make it
prove that the totals have not moved by a single cent. Conversion is convenient;
conversion without verification must never be used.

Share freely — you are welcome to share, quote, repost and adapt
this series and its prompts: on social media, inside your company, with your clients.
A link back to this page as the source is appreciated.
Suzuki Tax Accounting Firm — a licensed Japanese tax accountant corporation (zeirishi hōjin), Okayama, Japan