Accountant Bank Reconciliation Spreadsheets: Use case and AI Confidentiality
A bank reconciliation matches every line on a client’s bank statement to the ledger and explains what is left over. Bookkeepers and accountants paste the sheet into ChatGPT or Claude to find the unreconciled items or to write the explanations. Bank descriptions are free text, so they carry what the payer or the practice typed: a patient’s name and treatment, a child’s first name, a contractor’s invoice, a landlord. This page marks every item in a realistic October reconciliation for a dental practice, shows the rows that are only labels and arithmetic, and shows how the same reconciliation is worked on Ermos inside the practice.
The bank reconciliation spreadsheet
Prepared each month once the bank feed is in, by comparing every statement line with the ledger. Timing items are ticked off against the next statement, and anything still open is chased before the management report goes out.
Bank reconciliation, Macquarie operating account
Marchetti Dental Pty Ltd, trading as Northside Smile Studio (ABN 51 824 753 556), account ending 90381 · as at 31 October 2026 · prepared by Jessie Whitlam, reviewed by Tom Nakamura9 · Tuesday 17 November 2026
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Date | Bank statement line | Bank ($) | Ledger ($) | Status | Note |
| 2 | 14 Oct | REFUND D BANNISTER 2ND IMPLANT2 | (3,900.00) | (3,900.00) | Matched | Coded to fees income, which is why October fees are below budget. |
| 3 | 20 Oct | WESTPAC TERM LOAN REPAYMENT | (1,500.00) | (1,500.00) | Matched | Fourth repayment of the year. Lena and Marco guarantee the loan personally.6 |
| 4 | 21 Oct | DEP S BRAMWELL ORTHO PLAN CLOE3 | 2,400.00 | 2,400.00 | Matched | Deposit for the braces plan, held as a patient deposit until treatment starts. |
| 5 | 28 Oct | EFT A NOVAK INV 04124 | (25,300.00) | (25,300.00) | Matched | Paid to Dr Novak’s company account. |
| 6 | 29 Oct | EFT MARCHETTI FAMILY TRUST RENT OCT | (8,000.00) | (8,000.00) | Matched | Related-party rent. The top-up journal for the two quarters below market is still not posted.5 |
| 7 | 30 Oct | (not on the statement) | (27,900.00) | Timing | Dr S. Ibrahim INV 0388, payment run after the cut-off. Cleared Monday 2 Nov.4 | |
| 8 | 30 Oct | (not on the statement) | 6,240.00 | Timing | Card terminal settlement. Credited Monday 2 Nov. | |
| 9 | 12 Aug | (not on the statement) | (1,842.60) | Open | Cheque 000418 to Allbright Dental Supplies Pty Ltd. Never presented. Allbright says it never arrived. Jessie to ring them, then cancel and reissue.7 | |
| 10 | 31 Oct | Balance per bank statement8 | 307,802.60 | |||
| 11 | Add: deposits in transit8 | 6,240.00 | ||||
| 12 | Less: unpresented payments8 | (29,742.60) | 27,900.00 + 1,842.60 | |||
| 13 | Balance per ledger8 | 284,300.00 | Agrees to the October management report. | |||
| 14 | Difference8 | 0.00 |
An invented reconciliation. The ABN is the ATO’s published example value; the account digits, the cheque number and every person and supplier other than the firm’s own staff are placeholders. Hover or tap any highlighted cell for the analysis; the full list is below.
Bank reconciliation matcher
An Agent+ that prepares the monthly reconciliation from the statement and ledger export you supply. It matches lines, carries timing items to the next statement and builds the workbook in your layout, with open items such as an uncleared cheque set aside for follow-up.
What it does
- Reads the statement lines and the ledger entries
- Matches items and carries forward timing differences
- Lists open items for the bookkeeper to chase
What stays with your people. The bookkeeper or a senior accountant checks the matches, decides how open items are treated and approves the reconciliation.
An Agent+ is built once and anyone in the practice can run it. It works from your own documents and runs on Ermos Dominion, the AI unit in your office, or on Ermos Edge, your own instance in an Australian data centre.
What leaves the firm
- 1The client, its ABN and the account
A named practice, its ABN and the last four digits of its operating account. Confidential information acquired in a professional relationship under APES 110 (R114.2, which AUST R114.3 relaxes only where there is a legal or professional duty or right, or the client or a person with authority authorises the disclosure and the law does not prohibit it). APES 110 binds members of CA ANZ, CPA Australia and the Institute of Public Accountants. For a registered tax agent or BAS agent, Code item 6 in section 30-10 of the Tax Agent Services Act 2009 bars disclosing information relating to a client’s affairs to a third party without the client’s permission unless there is a legal duty, and TPB(GS) 55/2026 says that can include entering client information into an AI tool, depending on how the tool is configured and used. APES 110 confidentiality guide.
Frontier Models (ChatGPT, Claude) Client name, ABN and account digits transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Bank reconciliation matcher. Compares each bank statement line with the ledger, builds the reconciliation workbook and lists unmatched, timing and unusual items for the bookkeeper. See the use case - 2A patient, a treatment and a refund in a bank description
The patient’s name and the implant are typed into the description of a payment. Information about a health service provided to an individual is health information (section 6FA of the Privacy Act 1988), and health information is sensitive information (section 6(1)). A business that provides a health service to another individual and holds health information is not a small business operator (section 6D(4)(b)), so the $3,000,000 small business threshold in section 6D(1) does not take the practice outside the Act. APP 6.1 limits using or disclosing personal information for a different purpose without consent or an exception, and APP 8.1 applies before it goes to an overseas recipient. The patient is the practice’s patient and not the firm’s client, and did not agree to this use. Whether the firm is itself covered by the Act depends on its own turnover and activities. Privacy Act guide.
Frontier Models (ChatGPT, Claude) A patient’s name and treatment transmitted Ermos Edge Only the question and permitted excerpts go to a named Australian provider; who may see health information is still set by you Ermos Dominion Stays on the unit in your office Use case Bank reconciliation matcher. Compares each bank statement line with the ledger, builds the reconciliation workbook and lists unmatched, timing and unusual items for the bookkeeper. See the use case - 3A child, a parent and an orthodontic plan
A parent’s name, a child’s first name and the fact that the child has a braces plan, in a deposit description. Health information as in item 2 about the child’s treatment, and personal information about the parent. Neither is the firm’s client, and one is a child. The note says the money is held as a patient deposit, which is an accounting treatment a person should confirm before a tool repeats it. Privacy Act guide.
Frontier Models (ChatGPT, Claude) A child’s name and treatment plan transmitted Ermos Edge Only the question and permitted excerpts go to a named Australian provider; who may see health information is still set by you Ermos Dominion Stays on the unit in your office Use case Bank reconciliation matcher. Compares each bank statement line with the ledger, builds the reconciliation workbook and lists unmatched, timing and unusual items for the bookkeeper. See the use case - 4Two contractors and what each was paid
Two named dentists and the amounts of their October invoices, $25,300 and $27,900, which match the monthly management report. Their income is personal and commercial information about people who are not the firm’s clients. The 30 October payment that cleared on 2 November is a timing difference and not an error, and a tool asked to find missing payments may flag it as one. Privacy Act guide.
Frontier Models (ChatGPT, Claude) Two contractors’ earnings transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Bank reconciliation matcher. Compares each bank statement line with the ledger, builds the reconciliation workbook and lists unmatched, timing and unusual items for the bookkeeper. See the use case - 5Rent to the owners’ family trust
A monthly payment to a related party and a note that a top-up journal for two quarters of below-market rent has not been posted. Related-party arrangements are what a reviewer looks at first. Whether the rent is at market, and how any top-up is treated, is for a person, and this page states no tax result. APES 110 confidentiality guide.
Frontier Models (ChatGPT, Claude) A related-party lease transmitted Ermos Edge Stays in Australia, but whether the rent is at market is still a judgement Ermos Dominion Stays on the unit, but whether the rent is at market is still a judgement Use case Bank reconciliation matcher. Compares each bank statement line with the ledger, builds the reconciliation workbook and lists unmatched, timing and unusual items for the bookkeeper. See the use case - 6The loan repayment and the personal guarantees
A repayment on a bank loan and the statement that two named individuals guarantee it with their own assets. Personal financial information about Lena and Marco in a document about the company. The loan balance is $120,000 at 30 June less four repayments of $1,500, which is $114,000, and a person should recompute it. Privacy Act guide.
Frontier Models (ChatGPT, Claude) Personal guarantees transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Bank reconciliation matcher. Compares each bank statement line with the ledger, builds the reconciliation workbook and lists unmatched, timing and unusual items for the bookkeeper. See the use case - 7A cheque that never cleared
A cheque number, a supplier, an amount and the instruction to cancel and reissue. The supplier is a third party and the note says it never received the cheque. A tool will propose a cause, such as a lost cheque, and a person will be tempted to write it up as fact. Section 286 of the Corporations Act 2001 requires a company to keep written financial records that correctly record and explain its transactions and financial position and performance, and to retain them for 7 years after the transactions are completed. Section 262A(1) of the Income Tax Assessment Act 1936 requires a person carrying on a business to keep records that record and explain all transactions relevant for any purpose of that Act. A reconciliation file sits with those records, so what a tool adds to it needs a person’s check. Checking AI output guide.
Frontier Models (ChatGPT, Claude) A supplier dispute transmitted, with a cause the tool may invent Ermos Edge Stays in Australia, but the cause of an open item still has to be found by a person Ermos Dominion Stays on the unit, but the cause of an open item still has to be found by a person Use case Bank reconciliation matcher. Compares each bank statement line with the ledger, builds the reconciliation workbook and lists unmatched, timing and unusual items for the bookkeeper. See the use case - 8The standard reconciliation labels
Balance per bank statement, deposits in transit, unpresented payments, balance per ledger, difference. These appear in every reconciliation and hold no client data in the words. The figures beside them are not generic, and a person should add the three lines and agree the result to the ledger.
Frontier Models (ChatGPT, Claude) Standard labels with no client data in the words Ermos Edge Nothing to protect in standard labels Ermos Dominion Nothing to protect in standard labels Use case Bank reconciliation matcher. Compares each bank statement line with the ledger, builds the reconciliation workbook and lists unmatched, timing and unusual items for the bookkeeper. See the use case - 9The preparer and the reviewer
Two named staff and the date. It ties the file to the practitioners who stand behind it and makes any leak traceable to the practice. A registered tax agent also has to take reasonable care in ascertaining the client’s state of affairs (Code item 9), and TPB(GS) 55/2026 says whether reasonable care has been taken in using AI depends on all the circumstances, including whether the practitioner checks or reviews the output of the tool before relying on it. TPB Code guide.
Frontier Models (ChatGPT, Claude) Staff names and roles transmitted, and the leak is traceable to you Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Bank reconciliation matcher. Compares each bank statement line with the ledger, builds the reconciliation workbook and lists unmatched, timing and unusual items for the bookkeeper. See the use case
What happens in Frontier Models (ChatGPT, Claude)
- The whole document is transmitted to the provider’s servers. On personal plans the user cannot choose where it is stored or processed, and for the major providers that has generally meant outside Australia, under that country’s legal process. Some business plans offer storage in Australia, but the provider still receives the content.
- On consumer tiers, prompts can be retained and used to train future models.
- The provider’s staff and systems can reach the content under the provider’s own policies.
- Once sent, the firm no longer controls it. Retention and deletion happen on the provider’s terms.
The same document on Ermos
Ermos Dominion
The document is drafted on a unit in your office, from your own templates and the client file. Every marked item stays on the unit, which keeps working with the internet switched off. Nothing in it is transmitted to an AI provider, so there is no disclosure to analyse: the confidentiality work is the same as for your file server.
Ermos Edge
Your documents, the index and your access boundaries stay on your own instance in an Australian data centre. When a staff member asks for this draft, only their question and the excerpts they are permitted to see go to a named Australian provider, who is contractually barred from keeping the content or training any model on it. Nothing is processed outside Australia.
| Frontier Models (ChatGPT, Claude) | Ermos Edge | Ermos Dominion | |
|---|---|---|---|
| Where the document is processed | Provider servers, generally offshore on personal plans | Your instance in an Australian data centre; answers generated in Australia | The unit in your office |
| Who can read it | Provider staff and systems, under policy | Your staff, within the boundaries you set. The named Australian provider processes only permitted excerpts, under contract, and keeps nothing | Your staff only |
| Is it kept | On the provider’s terms | Kept on your instance; the provider is barred from retaining it | Stays on the unit |
| Can it train a model | On consumer tiers, yes | No, by contract | Only your own unit learns from it, on your hardware |
Part of Use cases in accounting firms. See how this works in practice: Workpaper review on Ermos.
Common questions
Do ChatGPT and Claude use the information in a bank reconciliation spreadsheet?
Is it safe to paste a bank reconciliation into ChatGPT or Claude if we remove the names?
What happens if we upload the reconciliation workbook to ChatGPT or Claude instead of pasting it?
How can an accounting practice use AI for a bank reconciliation without sending it to ChatGPT or Claude?
What financial records does a company have to keep?
Is a patient's name in a bank description health information?
Does the TPB say anything about putting client bank data into an AI tool?
See Dominion answering from your own documents.
A demonstration takes 30 minutes, uses no client data, and comes with no obligation.
Book a demo