Australian BAS Data to Excel
Step by Step
Two days before your quarterly BAS is due, you’re sitting in front of three piles: supplier invoices in one stack, business receipts in another, and a bank statement open on your second screen. Each pile needs to be turned into specific numbers for labels G1, G10, G11, 1A, and 1B on a form the ATO calls NAT 4189. The deadline is the 28th. The next step is usually a long night of manual data entry into a spreadsheet — but it doesn’t have to be that way.
Key Takeaways
- Two days before your BAS is due, every number you need is already on the invoices, receipts, and bank statements in front of you — the quarterly panic isn't a missing-data problem, it's a document-to-spreadsheet transcription marathon that small business owners have been told is just part of the job.
- Xero and MYOB handle the GST ÷ 11 arithmetic automatically, but only after someone types the numbers in — the extraction step between "I have a supplier's PDF" and "I have a value in cell G11" is the invisible bottleneck that makes BAS lodgement feel like a quarterly scavenger hunt.
- Define your columns once (Supplier Name, Invoice Total, GST Amount, Purchase Type), batch-process all your quarterly documents in under a minute, and the same configuration works for every BAS period going forward — the ATO's labels never change, so your extraction setup doesn't either.
The Anatomy of a BAS: What Those G-Labels Actually Demand
Before you can extract anything, you need to know exactly what the BAS expects. The Business Activity Statement (ATO form NAT 4189) is not a single number. It is a collection of labelled fields, each pulling from a different part of your business records. For a typical GST-registered small business lodging quarterly, the core sections break down like this.
GST section (Option 1 — calculate and report quarterly):
| Label | What It Means | Where the Number Comes From |
|---|---|---|
| G1 | Total sales (GST-inclusive, if using calculation sheet method) | Sum of all sales invoices and income receipts for the quarter |
| G2 | Export sales (GST-free) | Value of exported goods/services (separated from G1) |
| G3 | Other GST-free supplies | Basic food, medical, education — if applicable |
| G10 | Capital purchases (GST-inclusive) | Business assets: vehicles, machinery, equipment over the threshold |
| G11 | Non-capital purchases (GST-inclusive) | Day-to-day expenses: rent, inventory, stationery, software subscriptions |
| 1A | GST on sales (payable to ATO) | G8 ÷ 11 — the GST you collected |
| 1B | GST on purchases (credit claimable) | G19 ÷ 11 — the GST you paid on business expenses |
If you have employees, the BAS also requires PAYG withholding fields: W1 (total gross wages paid) and W2 (total tax withheld from those wages). 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). Most sole traders and micro-businesses with turnover under $10 million can use the Simpler BAS, which reduces the GST section to just three fields: G1, 1A, and 1B. But the underlying data requirement does not disappear — you still need to know your total sales, GST collected, and GST paid, whether you report them across 3 labels or 20.
The GST calculation itself follows a predictable chain: total sales at G1 are subtracted by GST-free and input-taxed portions (G2 + G3 + G4) to arrive at taxable sales (G6). After adjustments (G7), the result (G8) is divided by 11 to produce the GST on sales figure at label 1A. The same logic runs in reverse on the purchases side: G10 + G11 produce G12, minus non-taxable purchase components (G13 + G14 + G15) to get G17, adjusted at G18, then G19 ÷ 11 for 1B. The difference between 1A and 1B is your net GST position for the quarter — either a payment to the ATO or a refund.
Why the Quarterly BAS Sprint Hurts More Than It Should
The ATO sends your activity statement about two weeks before the end of the reporting period. The lodgement deadline for quarterly filers is the 28th of the month after the quarter closes — 28 October for the July–September quarter, 28 February for October–December, and so on. That gives you roughly four weeks to reconcile three months of transactions. If your bookkeeping is done as you go — every invoice coded correctly in Xero or MYOB when it lands — preparing the BAS might take 20 to 30 minutes. But that is not the reality for most small business owners.
One Reddit user on r/AusFinance described the problem with precision: “If BAS turns into a quarterly scavenger hunt, the real problem usually is not Xero, it is messy coding and receipts not being captured as you go.” The scavenger hunt is real. Supplier invoices arrive as PDF attachments in email. Receipts sit in a shoebox or a phone camera roll. Bank statements need to be cross-referenced against manually coded transactions. By the time the BAS deadline looms, you are not preparing a tax return — you are reconstructing three months of financial reality from scattered evidence.
The cost of getting it wrong is not trivial. The ATO applies a failure-to-lodge (FTL) penalty for each 28-day period a BAS is overdue, and the general interest charge (GIC) compounds daily on unpaid amounts. According to ScaleSuite’s analysis, Australian small businesses collectively pay over $300 million annually in BAS-related penalties and interest. Even without penalties, the time cost is the real drain: the Australian Small Business and Family Enterprise Ombudsman reports that 39% of small businesses spend more than six hours each week navigating regulatory compliance — and BAS lodgement sits at the centre of that burden.
Spreadsheets help, but only if the numbers get into them. BASCalc and similar Excel templates can handle the arithmetic once the data is entered. They cannot read an invoice. The gap between “I have a PDF from my supplier” and “I have a number in cell G11” is still entirely manual in most small business workflows.
Step 1: Gather Everything the BAS Requires
Before extraction, you need all source documents in one place. A quarterly BAS typically pulls from three document categories:
Acceptable formats include PDFs, JPGs, PNGs, and screenshots. A photo of a receipt taken on your phone counts. The goal is not to have perfectly organised files — the extraction step handles each file individually — but to make sure nothing is missing. A single omitted supplier invoice with $1,100 including $100 GST means your 1B credit is understated by $100 and your net GST payable is overstated by the same amount.
Step 2: Map BAS Labels to Extraction Fields
This is the step that turns a generic “extract data” workflow into BAS-specific output. Instead of extracting random fields from each document, you define the 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 looks like this:
| Your Column Name | BAS Label(s) It Feeds |
|---|---|
| Supplier Name | (cross-reference) |
| 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 the core mechanism behind custom column extraction: you define what you want, and the AI locates the matching data on each document by understanding what the field means — not where it sits on the page. A supplier invoice from Bunnings and a supplier invoice from a freelance contractor look nothing alike. Traditional template-based OCR would need a separate parsing template for each format. Semantic extraction reads both and finds “Invoice Total” without caring about layout.
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)” so the extraction captures which type each transaction is, feeding the correct BAS label (G2 or G3 vs the main G1→1A chain).
Step 3: Extract — Turn Documents Into Structured Data
With your documents gathered and your column list defined, 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 the values that match your column definitions. Because the 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. If you uploaded 40 supplier invoices with columns for “Supplier Name,” “Invoice Total (GST-inclusive),” and “GST Amount,” you get 40 rows of structured data — ready to sum into G10, G11, and 1B.
For sales invoices, run a separate batch with the sales-side columns (Total Sales, GST on Sales, Export Amount if applicable) and you have the G1 and 1A side populated. Two batches cover the entire BAS data pipeline: one for purchases, one for sales.
Step 4: Verify GST Calculations and Reconcile
This step is where the BAS numbers get stress-tested 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 should equal the total divided by 11. If a supplier invoice shows $2,200 including GST, the GST amount should be $200. If the extraction output shows $2,200 in the “Invoice Total” column and $180 in the “GST Amount” column, something is off — either the invoice itself had a non-standard GST treatment, or the extraction misidentified a field. Flag it and check the original document.
A practical reconciliation workflow for the quarter:
One advantage of having all extraction output in a single spreadsheet is that the reconciliation is visible end-to-end. You can 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 you to keep records for five years; the extraction spreadsheet plus the original files satisfies that requirement.
Step 5: Export to Excel and Prepare for Lodgement
With verified figures, the final step is straightforward. 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 document 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 you 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 page recommends reconciling the BAS figures with your records, checking that purchases and sales are reported in the correct period, and only completing the sections that apply to your business. 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.
Process Multiple BAS Periods in One Pass
Most small businesses do not stop operating between BAS periods. The documents from last quarter look almost identical to the documents from the quarter before — same suppliers, similar invoice formats, same column requirements. The extraction setup you defined for one quarter (the column names, the GST calculation checks) applies to every subsequent quarter with zero reconfiguration.
If you have fallen behind and need to catch up on two or three quarters at once, or if you proactively want to run the current quarter alongside a review of the previous one, batch processing handles it. Separate your documents by BAS period into folders (Q1 Jul–Sep, Q2 Oct–Dec, etc.), run the same column definition on each folder, and you get a separate output spreadsheet per quarter. The extraction logic does not change; only the input files change. What would have been three separate manual data-entry marathons becomes three batch runs using the same configuration.
This is particularly useful at EOFY when a BAS agent or accountant asks for the full-year picture. Four quarterly extraction spreadsheets can be merged into one annual summary in minutes, with every transaction traceable back to its source document.
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 will produce the same structured output as a typed invoice — the GST amount can even be computed automatically if you define a computed column like GST Amount (Total ÷ 11). What matters is that the value is present on the document, not how it was written.
What if a supplier invoice does not separately show the GST amount?
Most Australian tax invoices are required to show the GST amount separately, but if one does not and the total is marked as GST-inclusive, you can use a computed column. Define a column called GST Amount (Invoice Total ÷ 11) and the AI will perform the calculation during extraction, outputting the GST component directly — no post-processing in Excel needed. This is valid for standard 10% GST; if the invoice involves a mixed supply (part GST, part GST-free), you will need to verify and potentially split the transaction manually.
Does the tool lodge BAS directly with the ATO?
No. ImageToTable.ai extracts data from documents into structured spreadsheets — it does not lodge tax forms. You use the output as your 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.
How does this compare to just using Xero’s BAS feature?
Xero’s BAS preparation module works with transactions already entered in Xero. If you receive a PDF invoice from a supplier, someone still has to type the amounts into Xero — either by creating a bill manually or by using Xero’s Hubdoc capture (which uses template-based OCR and often requires correction). AI extraction handles the step before the accounting software: turning a stack of PDFs, photos, and scans into a structured data table that you can then import or 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. For larger mistakes, you can lodge a revision through the ATO Business Portal or your accounting software. The ATO is generally accommodating if errors are corrected proactively. Keeping your extraction spreadsheets as supporting records for five years (as required by the ATO) means you can trace any discrepancy back to its source document quickly.
Can I use this for IAS (Instalment Activity Statement) as well?
Yes. An IAS is a simpler version of the BAS used by businesses not registered for GST but required to report PAYG withholding or PAYG instalments. The extraction workflow is identical — you just define fewer columns since no GST labels apply. The same document types (payroll summaries, income records) feed the same extraction process.