Bank Statement Converter for BAS — PDF to Excel for GST in Australia

What the BAS needs from your statements

Once your turnover passes the $75,000 threshold you're required to register for GST, and from then on the ATO wants a BAS — usually quarterly. The core figures are GST on sales (the 1/11th of your GST-inclusive income) and GST on purchases you can claim back. Both trace back to transactions that went through your bank account.

The catch is getting those transactions into a form you can work with. A quarter is three monthly statement PDFs, and BPAY bills, EFTPOS purchases and transfers all sit in a description column you can't filter while it's a PDF. As rows in Excel, you sort the income, sort the expenses, and the GST falls out.

From PDF to a BAS-ready spreadsheet

1. Download each month's statement as a PDF from your bank — CommBank's NetBank, Westpac, NAB and ANZ all keep statements in online banking.
2. Convert each PDF to Excel or CSV. Every transaction returns as a row — date, description, debit, credit and balance — with the closing figure checked.
3. Combine the three months into one sheet for the full quarter.
4. Tag and total. Add a column marking each line as GST-inclusive income, a claimable expense, or out of scope (wages, transfers), then total each for the BAS labels.

Because Australian statements pack the payment type and payee into one description, keeping that detail intact is what lets you tell a supplier payment from a transfer when you're tagging.

What the converter handles that a copy-paste won't

Australian bank statements often wrap a long payee or a BPAY reference onto a second line. Paste the PDF into a spreadsheet and that second line becomes a phantom row, knocking the debit and credit columns out of step — exactly the kind of error that makes a BAS not reconcile. The converter joins each wrapped line back to its transaction, so the columns stay aligned and the quarter totals cleanly.

It also checks the math before you download: opening balance, plus credits, minus debits, has to reach the closing balance. On a quarter's worth of statements, that catches a line dropped between pages before it throws your GST figure out.

More than GST: the BAS labels

A BAS isn't only GST. Depending on your registration it can also carry PAYG withholding for staff, PAYG income-tax instalments, and sometimes other obligations, reported across labels like G1 (total sales), 1A (GST on sales) and 1B (GST on purchases). Wages and PAYG amounts all move through the same bank account as your GST-relevant transactions, so having the whole quarter as rows lets you pull each obligation out separately rather than untangling them on a PDF. If a registered BAS agent lodges for you, handing them a reconciled spreadsheet — or an import file — is what keeps their time (and your fee) down.

Straight into Xero or MYOB

Most Australian businesses reconcile in Xero or MYOB, and both import a bank file. Instead of a spreadsheet you can export an import-ready file and bring the quarter in as bank transactions to code against your GST tax rates — so the BAS is prepared from reconciled data, not a manual tally. If your bookkeeper or BAS agent does the lodging, a clean file is what they'd rather receive than a folder of PDFs.

Common pitfalls to avoid

• Claiming GST on GST-free purchases. Not everything carries GST; tagging each line lets you exclude the GST-free items rather than claiming 1/11th of everything.
• Wages and transfers. These are out of scope for GST — keep them on their own rows so they don't inflate either side.
• Cash sales. If takings are banked as lump sums, the deposit is your record; keep the reference so it reconciles to your point-of-sale totals.
• Leaving it to the due date. Convert each month as it closes and the quarterly BAS is a five-minute check.