How to Extract AU BAS Data for
GST & PAYG Reporting (2026 Guide)
Where does the number at label G11 on your BAS actually come from? Not from Xero or MYOB — those tools populate the GST calculation once a purchase total is entered, but they cannot read a supplier's PDF invoice and pull out the number themselves. The value in G11 originates from a document that arrived in your inbox three months ago, sat in a folder labelled "BAS stuff," and now needs to be retyped into a spreadsheet before the 28th. That manual leap from document to data point — repeated across every G-label, every W-label, every quarter — is the bottleneck BAS preparation guides tend to skip.
Key Takeaways
- A free spreadsheet template can handle every GST calculation on a BAS — what it cannot do is read the supplier PDF that tells you what number to divide by 11.
- The $300 million Australian small businesses pay annually in BAS penalties is rarely caused by bad arithmetic — it is caused by three missed invoices that shift a refund position into a payment owed.
- Define your extraction columns once per BAS label, and every quarter reuses the same setup: drop 50 supplier invoices in, get a spreadsheet back, regardless of whose format each supplier uses.
The Anatomy of a BAS: What Those G-Labels Actually Demand
Before extracting anything, you need to know exactly what each label requires. The Business Activity Statement (ATO form NAT 4189) is not a single figure — it collects data from multiple areas of your business and assembles them into a net position. For a typical GST-registered small business lodging quarterly under Option 1 (calculate and report), the GST section alone pulls from seven source fields and runs them through a calculation chain.
GST section (Option 1 — calculation sheet method):
| Label | What It Means | Where the Number Comes From |
|---|---|---|
| G1 | Total sales — GST-inclusive if using the accounts method | Sum of all sales invoices and income receipts for the quarter |
| G2 | Export sales (GST-free) | Value of exported goods and services, separated from G1 |
| G3 | Other GST-free supplies | Basic food, medical, education — if applicable to your business |
| G10 | Capital purchases (GST-inclusive) | Business assets: vehicles, machinery, equipment. If your turnover is under $1 million, capital items costing $1,000 or more go here; items $1,000 or less go to G11. |
| G11 | Non-capital purchases (GST-inclusive) | Day-to-day expenses: rent, inventory, stationery, software subscriptions, contractor invoices |
| 1A | GST on sales (payable to ATO) | G8 ÷ 11 — the GST you collected on taxable sales |
| 1B | GST on purchases (credit claimable) | G19 ÷ 11 — the GST you paid on business purchases, claimed back as a credit |
The GST calculation runs through a predictable chain on both sides. On the sales side: G1 minus GST-free and input-taxed portions (G2 + G3 + G4) produces taxable sales at G6. After adjustments at G7, the result (G8) is divided by 11 to produce the GST on sales figure at 1A. On the purchases side: G10 + G11 produce G12, then non-taxable components (G13 + G14 + G15) are subtracted to get G17, adjusted at G18 to reach G19, then G19 ÷ 11 for 1B. The net difference between 1A and 1B is your GST position — either a payment to the ATO or a refund.
If you have employees, the BAS also requires PAYG withholding fields: W1 (total gross wages paid during the period) and W2 (total tax withheld from those wages). These must match what your Single Touch Payroll (STP) submissions have already reported — a mismatch triggers an ATO data-matching flag that can take months to resolve. If the ATO has you on quarterly income tax pre-payments, you will also see PAYG instalment labels T1 (instalment income) and T2 (instalment rate). For businesses with FBT obligations, label F1 reports the ATO-calculated fringe benefits tax instalment.
Most sole traders and micro-businesses with turnover under $10 million can use the Simpler BAS, which reduces the GST section to just three labels: G1, 1A, and 1B. Behind the simpler form, however, the same source data still needs to exist — you must know total sales, GST collected, and GST paid, whether you report them across 3 labels or 20. The Simpler BAS reduces what the ATO asks you to declare, not what you need to calculate.
Why the Quarterly BAS Sprint Hurts More Than It Should
The ATO sends your activity statement about two weeks before each quarter ends. For quarterly filers, the lodgement deadline is the 28th of the month after the quarter closes — 28 October for July–September, 28 February for October–December, 28 April for January–March, and 28 July for April–June. That gives roughly four weeks to reconcile three months of transactions. When your bookkeeping is done as-you-go — every invoice coded in Xero or MYOB the moment it lands — preparing the BAS may take 20 to 30 minutes. That is not the reality for most small business owners.
According to research from the Australian Small Business and Family Enterprise Ombudsman, 39% of small businesses spend more than six hours each week navigating regulatory compliance — and BAS lodgement sits at the centre of that burden. ScaleSuite estimates that Australian small businesses collectively pay over $300 million annually in BAS-related penalties and interest. The quarterly preparation alone typically consumes 4 to 6 hours per BAS for a business owner doing it themselves, or 16 to 24 hours across a year.
The time cost is not just about hours. A failure-to-lodge (FTL) penalty applies for each 28-day period a BAS is overdue — starting at $313 per period for small entities — and the general interest charge (GIC) compounds daily on unpaid amounts. A Canberra café with $680,000 turnover forgot to lodge their December quarter BAS and received a $313 penalty despite being in a net GST refund position for that quarter. The penalty applies to late lodgement, not just late payment.
Spreadsheets and BAS calculator templates — like BASCalc and various Excel workbooks sold on Etsy and independent sites — handle the arithmetic once data is entered. They cannot read a supplier invoice. The gap between "I have a PDF from my supplier" and "I have a number in cell G11" remains entirely manual in most small business workflows. The same document-to-spreadsheet gap that affects payroll reconciliation — covered in our guide on manual PAYG summary processing costs — applies equally to BAS preparation, with the key difference that it repeats four times a year instead of once.
Step 1: Gather Everything the BAS Requires
Before extraction, all source documents need to be in one place. A quarterly BAS typically pulls from three document categories:
Acceptable formats include PDFs, JPGs, PNGs, and screenshots. A photo of a paper receipt taken on your phone qualifies. The goal is not perfectly organised files — extraction handles each file individually — but completeness. A single omitted supplier invoice with $1,100 (including $100 GST) understates your 1B credit by $100 and overstates your net GST payable by the same amount. Across a quarter, missing even three or four invoices can shift a refund position into a payment — and you will not know until the ATO's data-matching catches it.
Step 2: Map BAS Labels to Extraction Fields
This is the step that turns a generic extraction workflow into BAS-specific output. Instead of pulling random fields from each document, you define columns that correspond directly to what the BAS asks for.
For a business on the Simpler BAS, the column list is short:
| Your Column Name | BAS Label It Feeds | What AI Looks For |
|---|---|---|
| Total Sales (GST-inclusive) | G1 | The total amount on each sales invoice, including GST |
| GST on Purchases | 1B | The GST component on each supplier invoice or receipt |
For the full BAS (Option 1, calculation sheet method), you need more granularity. Each supplier invoice contributes to G10 or G11 depending on whether it is a capital or non-capital purchase, and the GST component contributes to 1B. A practical column set:
| Your Column Name | BAS Label(s) It Feeds |
|---|---|
| Supplier Name | (cross-reference and audit trail) |
| Invoice Date | (period check — must fall within BAS quarter) |
| Invoice Total (GST-inclusive) | G10 or G11 |
| GST Amount | 1B |
| Purchase Type (Capital / Non-Capital) | G10 vs G11 routing |
The column names you type become the headers of your final output table. This is Custom Column Extraction: you define what you want as column headers, and the AI locates the matching data on each document by understanding what each field means semantically — not where it sits on the page. A supplier invoice from Bunnings and an invoice from a freelance contractor look nothing alike. Template-based OCR would need a separate parsing template for each format, and the first time a supplier changes their layout the template breaks. Semantic extraction reads both and finds "Invoice Total" without caring about layout differences.
If your business handles both GST and GST-free sales (common for exporters, health providers, or food businesses), add a column like "GST Status (Taxable / GST-Free / Export)" — the AI can infer the correct classification from the document content, feeding the right BAS label (G2 or G3 vs the main G1→1A chain) without manual sorting.
Step 3: Extract — Turn Documents Into Structured Data
With documents gathered and column definitions set, the extraction step takes minutes.
Upload all source documents for the quarter — sales invoices, purchase receipts, supplier bills — in a single batch. The tool processes each file independently, locating values that match your column definitions. Because processing runs in parallel across all files, 50 invoices do not take 50 times longer than one; a typical batch of 30–50 documents completes in under a minute.
Files are processed securely and not stored.
The output is a single table where each row is one document and each column matches the field you defined. Forty supplier invoices with columns for "Supplier Name," "Invoice Total (GST-inclusive)," and "GST Amount" produce 40 rows of structured data — ready to sum into G10, G11, and 1B.
For sales invoices, run a separate batch with sales-side columns (Total Sales, GST on Sales, Export Amount if applicable) and the G1 and 1A side populates. Two batches cover the entire BAS data pipeline: one for purchases (feeding G10, G11, and 1B), one for sales (feeding G1 and 1A). For the PAYG withholding side — W1 and W2 — you can either pull those figures directly from your payroll system's STP reports (the most reliable method) or extract them from payroll summaries using the same column-mapping approach described in our PAYG payment summary extraction guide.
Step 4: Verify GST Calculations and Reconcile
This step stress-tests the BAS numbers before lodgement. The extraction output gives you raw totals; you now verify that the GST arithmetic holds.
The quickest sanity check: for any GST-inclusive total, the GST component equals the total divided by 11. A supplier invoice showing $2,200 including GST should have $200 in GST. If extraction outputs $2,200 in "Invoice Total" and $180 in "GST Amount," either the invoice had non-standard GST treatment (a mixed supply with both taxable and GST-free components) or the extraction misidentified a field. Flag it and check the original.
A practical reconciliation workflow for the quarter:
With all extraction output in a single spreadsheet, reconciliation is visible end-to-end. Sort by supplier, filter by date range (confirming every document falls within the correct BAS quarter), and spot-check individual rows against the original PDFs. The ATO requires records for five years; the extraction spreadsheet plus the source files satisfies that requirement.
Step 5: Export to Excel and Prepare for Lodgement
With verified figures, export the extraction output as an Excel (.xlsx) file. If your accounting software (Xero, MYOB, QuickBooks Online) supports SBR-enabled lodgement directly to the ATO, use the spreadsheet as your reference while completing the BAS within the software. If you lodge through the ATO Business Portal or via myGov (for sole traders), the spreadsheet becomes your primary working document — each total maps directly to a BAS label.
For a quarterly BAS under Option 1, your export should give a clear line of sight to every label:
- G1 — sum of all sales invoice totals for the quarter
- 1A — sum of GST on those sales (or G8 ÷ 11)
- G10/G11 — sum of capital and non-capital purchase totals respectively
- 1B — sum of GST on those purchases (or G19 ÷ 11)
- W1/W2 — from payroll system (STP-verified)
- T1/T2 — from ATO instalment notice (if applicable)
The ATO's BAS and GST tips recommend reconciling figures against your records, confirming that purchases and sales are reported in the correct period, and only completing the sections that apply. A spreadsheet built from extraction output makes all three checks fast: sort by date to confirm period accuracy, filter by purchase type to confirm G10 vs G11 classification, and use column totals as direct label inputs. The ATO also advises entering whole dollar amounts only — leave cents out and do not round up.
Process Multiple BAS Periods in One Pass
Most small businesses do not stop operating between BAS periods. The documents from last quarter look similar to those from the quarter before — same suppliers, comparable invoice formats, identical column requirements. The extraction setup you defined (column names, GST verification rules) applies to every subsequent quarter with zero reconfiguration.
If you are behind on lodgements and need to catch up on multiple quarters, or if you proactively want to process the current quarter alongside a review of the previous one, batch processing handles it cleanly. Separate documents by BAS period into folders (Q1 Jul–Sep, Q2 Oct–Dec, and so on), run the same column definition on each folder, and get a separate output spreadsheet per quarter. The extraction logic is unchanged; only the input files differ. Three separate manual data-entry marathons become three batch runs using one saved configuration.
This is equally useful at EOFY when a BAS agent or accountant asks for the full-year picture. Four quarterly extraction spreadsheets merge into one annual summary in minutes, with every transaction traceable to its source document. The same batch-consolidation approach — processing multiple periods of structured forms into unified spreadsheets — is covered in detail in our guide on batch UK SA100 tax return processing, where the quarterly-to-annual consolidation pattern follows the same logic under a different tax code.
One setup, every quarter: The ATO's labels do not change between reporting periods. Define your columns once — Supplier Name, Invoice Total, GST Amount, Purchase Type — and reuse them for every BAS indefinitely. What changes each quarter is the input documents, not the extraction logic.
FAQ
Can AI extraction handle handwritten receipts for BAS?
Yes. The underlying vision model reads handwriting and printed text with the same semantic logic. A handwritten receipt from a tradie supplier with "Total $385 (inc GST)" scribbled at the bottom produces the same structured output as a typed invoice. If the GST amount is not separately listed, you can use a computed column — name a column GST Amount (Total ÷ 11) and the AI performs the calculation during extraction, outputting the GST component directly without any follow-up work in Excel.
What if a supplier invoice does not separately show the GST amount?
Australian tax invoices for amounts over $82.50 are legally required to show the GST amount separately. If one does not and the total is marked as GST-inclusive, use a computed column: GST Amount (Invoice Total ÷ 11). This is valid for standard 10% GST. If the invoice involves a mixed supply — part taxable, part GST-free — you will need to verify and potentially split the transaction manually. Mixed-supply invoices from suppliers in health, education, or food industries are the most common source of this issue.
Does the tool lodge BAS directly with the ATO?
No. The tool extracts data from documents into structured spreadsheets — it does not lodge tax forms or interact with ATO systems. You use the output as working data to complete the BAS in your accounting software (Xero, MYOB), the ATO Business Portal, or through your BAS agent. The tool replaces the manual data entry step; it does not replace the lodgement step or the legal declaration that the information is correct.
How does this compare to using Xero's BAS preparation feature?
Xero's BAS module works with transactions already entered in Xero. If you receive a PDF supplier invoice, someone still has to enter the amounts — either by creating a bill manually or by using Xero's Hubdoc capture tool, which relies on template-based OCR and often requires correction for non-standard layouts. AI extraction handles the step before the accounting software: turning a stack of PDFs, photos, and scans into a structured data table you can reference when creating transactions. The two tools address different stages of the workflow: extraction covers document → data; Xero covers data → BAS lodgement.
What if I make a mistake on a lodged BAS?
For small errors within the ATO's adjustment limits, you can correct the figure in your next BAS by reporting the adjustment at label G7 (sales side) or G18 (purchases side). For larger mistakes, lodge a revision through the ATO Business Portal or your accounting software. The ATO is generally accommodating if errors are corrected proactively and before they initiate a review. Keeping your extraction spreadsheets as supporting records means you can trace any discrepancy to its source document — which makes explaining an error to the ATO a matter of minutes, not days of reconstruction.
Is BAS the same thing as an IAS (Instalment Activity Statement)?
No — though the form looks similar. An IAS is used by businesses not registered for GST but required to report PAYG withholding or PAYG instalments. It reports fewer tax types: no GST labels, just PAYG withholding and PAYG instalment figures. An IAS is also filed monthly by businesses whose annual PAYG withholding exceeds $25,000. The extraction workflow is identical — you define fewer columns since no GST labels apply — but the same document types (payroll summaries, income records) feed the same process. For a deeper comparison of how different countries handle payroll tax reporting on equivalent forms, see our guide on UK P60 data extraction for payroll reconciliation.
Does the Simpler BAS reduce my extraction workload?
Partially. Simpler BAS requires only G1, 1A, and 1B — reducing the number of labels you need to calculate. However, to arrive at those three figures correctly, you still need to know your total taxable sales, total GST on sales, and total GST on purchases. That underlying data does not shrink because the form is shorter. Where Simpler BAS helps is that you do not need to separate G10 from G11, or G2 from G3 — all purchases can be totalled together for the 1B calculation, and all sales together for 1A. Fewer label distinctions means fewer columns to define during extraction.