Reconcile GST to BAS with AI: a step-by-step walkthrough
Summit speakers who use AI on BAS work all keep a person between the AI and the lodgement. This walkthrough shows how to export three Xero reports, strip client identifiers, have a general AI assistant compare and flag, and check every flag in Xero yourself.
Part of our AI in accounting coverage. See the full AI for accountants guide →
Reconciling GST to the BAS came up in four sessions at the AI in Practice Summit in November 2026, and nobody on stage claimed a general AI assistant can do it unattended. What the speakers described instead is narrower and more useful: let Claude, ChatGPT or Microsoft Copilot do the first pass of comparing and flagging, keep client identifiers out of it, and have a person check every flag in Xero before anything is lodged. Here are those steps, using only reports Xero already gives you.
What the speakers actually do
- Beau Gaudron (Tech Ninja, Growthwise) said his firm built a GPT on OpenAI’s API, under a zero data retention agreement, that reads Xero data and gives accountants a first-pass review of what looks like it needs correcting. He warned that a paid account is not a no-training agreement.
- Travis Bacon (Founder, TaxDigital) said BAS was the first problem his team tackled, and that his guardrail is de-identification: TFNs, IDs, client names and addresses come out before any data reaches the Claude API.
- Andy Teece (Director and Co-Founder, Atomic Business Advisers) described an AI telling him GST was out, then asking it which period the error happened in. It came back with two dates and two amounts, and he amended those BASs and reallocated the transactions in Xero himself.
- Natalie Lennon (Founder, Two Sides Accounting) said she had tried giving an AI her GST workpaper template and had not found one that does it without a lot of errors.
The BAS piece is a real beast.
Watch: Teach your team how to use AI productively and securely, Where to start with AI and I hired my first AI assistant.
Before you start
Two decisions come first. Use a business or team plan whose terms exclude your data from training, and decide what leaves Xero. Our guide to whether AI is safe for client data sets out what each tier does with what you upload. The rule for this workflow is simple: redact before you upload. A GST export names your client’s customers and suppliers.
Also be clear about the job. Under the ATO’s guidance on completing your BAS (last updated 14 September 2026), the GST amounts land at 1A (GST on sales) and 1B (GST on purchases), and G1 (total sales) is the only label where you choose GST-inclusive or GST-exclusive. Simpler BAS reporters complete G1, 1A and 1B, according to the ATO’s GST reporting methods page. The AI is checking that those figures agree with the ledger. It is not preparing them.
The walkthrough
1. Settle the period in Xero first
Reconcile the bank for the period first. Check the GST basis and period in Financial settings, because Xero’s GST Reconciliation report uses them. If you use the new Activity Statement, Xero’s help centre says to check its settings match Financial settings before you run the reconciliation.
2. Export three reports
- The Activity Statement for the period. Xero’s Activity Statement help page says you can export it to Excel or PDF. Take Excel.
- The GST Reconciliation report, under Reporting, All reports, Taxes and balances. Xero recommends a From date that gives an opening balance of zero. With the new Activity Statement you copy the filed 1A and 1B figures into the Filed column yourself, and Xero notes that manual entries in Filed and Adjustments are not saved.
- The transaction detail. Xero’s Account Transactions report for the GST account (820 on Xero’s default chart) exports to a spreadsheet, and you choose its columns: add the gross, net and tax columns, and a tax rate column if your file offers one (the column options vary, so check before you rely on the tax rate prompt below). The Activity Statement’s Transactions tab shows the period by tax rate or BAS field on screen.
3. Strip identifiers
Delete or replace the contact, description and reference columns, the ABN and the organisation name. Replace contacts with codes (Supplier 01, Customer 07) and keep your key in Xero or your workpapers, not in the chat. Keep dates, account codes, tax rates and amounts.
4. Tell the AI who you are and what it may not do
Kelly Marshall of First Class Accounts Richmond told the AI-Assisted Bookkeeping session to tell the AI who you are and what sort of business you run, and to save your rules where it will keep them. For this job that means: Australian BAS work, the client’s GST basis, and an instruction to flag and never to correct.
5. Ask it to compare and flag
Upload the redacted files and use the prompts below, one at a time.
6. Check every flag in Xero
Open each flagged transaction in the file. Kelly Marshall described her first guardrail as watching the AI work and checking its output the way she checks her team’s. Treat a clean result with suspicion: ask what it did not look at.
7. Record what you checked
Save the AI’s flag list with your decision against each line in the workpaper. Once you have finalised the statement, Xero’s help centre suggests setting a lock date so the period cannot change underneath you.
- “I am a registered BAS agent in Australia checking GST for a client’s quarterly BAS in Xero. The client accounts for GST on an accruals basis. I will upload three redacted exports. You are checking, not preparing. Do not change, estimate or fill in any figure, and say plainly when you are unsure.”
- “Compare 1A and 1B on the Activity Statement export with GST Collected and GST Paid on the GST Reconciliation report for the same period. List every difference, its size, and which file each number came from.”
- “Go through the transaction export line by line. Flag manual journals to the GST account, income or expense lines with a BAS Excluded tax rate, GST-coded lines on asset, liability or equity accounts, GST that is not one eleventh of the gross amount, and the same amount on the same date twice. Give date, account, amount and the rule for each.”
- “The GST account balance does not agree with the reconciliation. Using the monthly totals in these files, tell me which period the difference first appears in and which transactions make it up.”
- “Turn your flags into a review table with columns for the flag, where to look in Xero, and a blank Reviewer decision column. Do not suggest lodgement figures.”
More prompts in the same style are in our ChatGPT prompts for bookkeepers.
What to check by hand
These come from Xero’s own guide to resolving GST report discrepancies and its GST Reconciliation report help, plus the ATO’s rules on corrections.
| Check | Why a person decides |
|---|---|
| GST basis on the BAS matches the basis the reports were run on | Xero says cash versus accruals is a common cause of BAS and ledger differences |
| BAS Excluded on income or expense lines | Excluded from the BAS but still in the profit and loss; only you know if that is right |
| Manual GST journals using BAS Excluded | They move the GST account but not the BAS; Xero says to review them with an advisor |
| Custom tax rates other than 0% or 10% | The worksheet calculates GST as one eleventh, so these will not agree |
| Small unfiled differences | 1A and 1B are lodged in whole dollars, so rounding shows as unfiled and a journal does not clear it |
| Prior period errors | Whether a correction goes on a later BAS or needs an amendment depends on the ATO’s rules for correcting GST errors |
| Payroll and PAYG withholding labels | Outside this method; Natalie Lennon said payroll is why AI only gets her half the BAS |
For the coding judgment underneath all of this, see what bookkeepers still check when AI does the bookkeeping.
What it means for your fees
Redacting exports, running the prompts, reviewing every flag and keeping a written trail. The AI shortens the hunt, not the review.
Scope per entity and per period. Write down that cleaning up prior periods or bad opening balances sits outside the quarterly BAS.
Time the first few runs, including review, before you change anything. Price on the risk you carry as the lodging agent and the value of an earlier answer, not on minutes saved.
“We use AI tools to help check your GST figures. Your details are removed first, and a qualified person reviews every result before we lodge.”
Where we could be wrong
The method rests on an AI comparing spreadsheets accurately, and long exports are where general assistants slip: dropped rows, arithmetic that looks right and is not. Report names and steps are from Xero’s help centre as read on 20 November 2026. Replacing names with codes reduces risk but is not anonymisation, since a distinctive amount or date can still point to a person. The speakers describing more automation, such as Gus McLennan of AI Dojo with a 14-rule GST classification skill, run it on their own connectors and platforms, which we have not tested. If a general assistant reliably reconciles GST end to end, we will update this piece.
Frequently asked questions
Can ChatGPT or Claude lodge a BAS?
No. A general assistant has no access to the ATO’s lodgement channels. You lodge from Xero, through the ATO’s own online services or through your agent software, after a person has approved the figures.
Should I connect the AI straight to Xero instead of uploading exports?
Connectors save the export step, but the AI then sees whatever your Xero permissions allow, including names. Kevin Garber of LogicGlue said in his summit session that his connector reads by default with write access to Xero off until you switch it on, and that connectors are not all the same. Check yours, start read-only, and only once your AI policy covers it.
Does a paid ChatGPT or Claude account keep client data out of training?
Not automatically. Business and team plans exclude training by default, while individual paid plans have settings you must check. Redact anyway, because training is only one of the risks.
How often should I run this check?
Every BAS period, before lodging, and again at year end, when Xero suggests running the GST Reconciliation report to reconcile the GST account on the Balance Sheet.
What if the AI finds an error in a period already lodged?
Confirm it in Xero first. Whether you fix it on a later BAS or amend the earlier one depends on the type of error, its size and time limits, which the ATO sets out in its guidance on correcting GST errors.
AI in AccountingGSTBASXeroBookkeepingPromptsData security
Get the editable BAS preparation checklist Download the BAS preparation checklist
The Word document (.docx), ready to fill in. Your profile unlocks every template on The Firm.
Or build it with AI
Open Claude or ChatGPT with the prompt filled in. It writes the finished document for your firm straight away, then asks a few questions to tailor it. No client data needed.
Works without client data. Don't paste client names, tax file numbers or ledgers into an AI tool your firm hasn't approved for them. AI data safety playbook.