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
· as at 31 October 2026 · · Tuesday 17 November 2026

fx=C9+C10+C11-D12
ABCDEF
1DateBank statement lineBank ($)Ledger ($)StatusNote
214 Oct(3,900.00)(3,900.00)MatchedCoded to fees income, which is why October fees are below budget.
320 OctWESTPAC TERM LOAN REPAYMENT(1,500.00)(1,500.00)Matched
421 Oct2,400.002,400.00MatchedDeposit for the braces plan, held as a patient deposit until treatment starts.
528 Oct(25,300.00)(25,300.00)MatchedPaid to Dr Novak’s company account.
629 OctEFT MARCHETTI FAMILY TRUST RENT OCT(8,000.00)(8,000.00)Matched
730 Oct(not on the statement)(27,900.00)Timing
830 Oct(not on the statement)6,240.00TimingCard terminal settlement. Credited Monday 2 Nov.
912 Aug(not on the statement)(1,842.60)Open
1031 Oct307,802.60
116,240.00
12(29,742.60)27,900.00 + 1,842.60
13284,300.00Agrees to the October management report.
140.00
Oct-26Sep-26Open items

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

  1. Reads the statement lines and the ledger entries
  2. Matches items and carries forward timing differences
  3. 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

  1. 1
    The 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.

  2. 2
    A 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.

  3. 3
    A 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.

  4. 4
    Two 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.

  5. 5
    Rent 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.

  6. 6
    The 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.

  7. 7
    A 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.

  8. 8
    The 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.

  9. 9
    The 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.

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 EdgeErmos Dominion
Where the document is processedProvider servers, generally offshore on personal plansYour instance in an Australian data centre; answers generated in AustraliaThe unit in your office
Who can read itProvider staff and systems, under policyYour staff, within the boundaries you set. The named Australian provider processes only permitted excerpts, under contract, and keeps nothingYour staff only
Is it keptOn the provider’s termsKept on your instance; the provider is barred from retaining itStays on the unit
Can it train a modelOn consumer tiers, yesNo, by contractOnly 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?
Everything pasted or uploaded is sent to the AI company's servers and processed there to produce a reply. As at October 2026, whether a conversation on a personal plan (ChatGPT Free, Plus or Pro; Claude Free, Pro or Max) can be used to train the models depends on a setting each user controls. Business plans (ChatGPT Business and Enterprise, Claude Team and Enterprise) and the developer APIs sit under commercial terms, and OpenAI and Anthropic each say they do not train on that content by default (OpenAI, Anthropic). On either product, the thumbs up and thumbs down buttons can send a whole conversation back for training. This reconciliation carries a patient's refund for a second implant, a child's name in a braces deposit and two dentists' invoice amounts.
Is it safe to paste a bank reconciliation into ChatGPT or Claude if we remove the names?
No, because the bank descriptions still identify the people and the practice. The Office of the Australian Information Commissioner (OAIC) recommends in its guidance on commercially available AI products that organisations do not enter personal information, and particularly sensitive information, into publicly available generative AI tools, because of the significant and complex privacy risks. Removing names rarely makes a document anonymous. Information stays personal information while the person is reasonably identifiable, and the OAIC warns that information can be at risk of re-identification even when it has been de-identified or anonymised. A refund for a second implant, a deposit for a braces plan and rent paid to the owners' family trust point to one dental practice. Under the Privacy Act, information about a health service provided to an individual is health information, and health information is sensitive information.
What happens if we upload the reconciliation workbook to ChatGPT or Claude instead of pasting it?
An uploaded file leaves the practice as a whole file. It can carry other sheets, hidden columns, comments, tracked changes and file properties, as well as the visible rows. This workbook has September and open items tabs beside October, and they could hold more patient names, supplier details and the account ending 9038. The OAIC's guidance also tells organisations to review carefully the terms and settings that will apply to their use of any AI product. Someone should open every tab and check what the file contains before it leaves.
How can an accounting practice use AI for a bank reconciliation without sending it to ChatGPT or Claude?
Ermos is built so the document stays under your control. On the Dominion AI unit it is drafted inside your office and none of it is sent to an AI provider. On Ermos Edge your documents and index stay on your own instance in an Australian data centre, and only the question and the excerpts the user is permitted to see go to a named Australian provider that is contractually barred from keeping them or training any model on them. The reconciliation is produced from the client file and the practice's own template, and a qualified person agrees the three lines to the ledger before anyone relies on it.
What financial records does a company have to keep?
Section 286 of the Corporations Act 2001 requires a company to keep written financial records that correctly record and explain its transactions and its financial position and performance, and that would enable true and fair financial statements to be prepared and audited. They must be retained for 7 years after the transactions are completed. A person carrying on a business must also keep records under section 262A of the Income Tax Assessment Act 1936.
Is a patient's name in a bank description health information?
It can be. Section 6FA of the Privacy Act 1988 includes information about a health service provided to an individual where it is also personal information, and health information is sensitive information under section 6(1). A business that provides a health service and holds health information is not a small business operator under section 6D(4)(b), so the $3,000,000 threshold does not take it outside the Act.
Does the TPB say anything about putting client bank data into an AI tool?
TPB(GS) 55/2026, issued on 22 July 2026, applies to registered tax agents and BAS agents. It says a practitioner needs the client's permission before client information goes to a third party, which can include entering it into an AI tool depending on how the tool is configured and used. It recommends telling the client to whom and where the disclosure will be made, where data will be stored and whether AI tools may be used.

See Dominion answering from your own documents.

A demonstration takes 30 minutes, uses no client data, and comes with no obligation.

Book a demo