BAS Statement Excel – Free Template (2026)
0
Free download
Accounting & GST
Download template
GST Reconciliation Excel - Free Template
GST reconciliation register with BAS summary and instructions for tracking sales, purchases, GST amounts and payment status.
This GST reconciliation Excel template helps you track taxable sales, GST-free items, purchases, and payment status in one register. It includes three sheets: GST Reconciliation, BAS Summary, and Instructions.
Use it to line up your invoices and receipts before you lodge your BAS, so you can see the GST collected, GST paid, and what still needs checking. The workbook is set up for Australian businesses working through quarterly or monthly reconciliation.
Image 1 shows the GST Reconciliation sheet with a structured transaction table, image 2 shows the BAS Summary sheet, and image 3 is the Instructions tab for setup and use.
The key benefits of this Excel template
- Keeps taxable sales and GST-free transactions in one register, so you can reconcile faster at BAS time.
- Shows GST amount, GST rate, payment status, and reconciled status in separate columns for cleaner review.
- Helps you spot missing invoices or receipts before they flow through to your BAS.
- Makes quarterly or monthly reconciliation simpler by grouping entries by FY quarter.
- Gives you a clear profit and loss support file by separating amounts excl. GST from GST amounts.
- Reduces manual checking by putting sales and purchases into the same workbook.
- Useful for sole traders, bookkeepers, and office managers who need a practical GST working paper.
Step-by-step guide
- Open the GST Reconciliation sheet and enter each sale or purchase on its own line. Use the date, invoice or receipt number, supplier or customer name, and description.
- Choose the GST status that matches the transaction. For a standard taxable sale in Australia, use 10%; for GST-free items, enter 0%.
- Check the amounts excl. GST, GST amount, and amount incl. GST before you save the entry. That helps you catch errors like a missed decimal or wrong tax code.
- Use the Payment Status and Reconciled? fields to mark what has been paid and what has already been matched to the bank statement.
- Review the BAS Summary sheet before you lodge. It is there to help you pull together the totals you need for your quarterly or monthly BAS.
- Read the Instructions tab if you want a quick refresher on how to use the workbook or hand it to someone else in the office.
What is included
Transaction table with columns for date, FY quarter, invoice or receipt number, type, supplier or customer, description, city, ABN, GST status, amounts, payment status, reconciled flag, and notes.
Separate GST rate and GST amount fields so you can check 10% taxable items against GST-free lines.
BAS Summary sheet for rolling up the register into a simpler review view.
Instructions sheet for quick setup and use without needing to build anything from scratch.
Clear colour coding to separate headers, input areas, and status fields.
Works as a practical working paper for ATO record keeping and year-end checking.
Suitable for tracking both sales and purchases across a financial year.
Who uses a GST reconciliation spreadsheet during the year
A GST reconciliation spreadsheet is for the person who has to make the numbers line up before the ATO gets the BAS. In practice that is often a sole trader, a bookkeeper in a small Pty Ltd, or the office manager at a tradie business with 4 employees and a stack of invoices every week.
The need usually bites at the end of each quarter, when you are checking GST collected on sales against GST paid on bills and banked receipts. If you run a chippie business turning over $80,000 a quarter, one missed $2,200 invoice can move your BAS position enough to matter.
Before the BAS deadline
Most small businesses lodge quarterly, so the workbook becomes the last stop before you finalise the numbers. You can sort sales, purchases, GST-free items, and payment status in one place instead of flicking between the bank feed, supplier bills, and your email inbox.
For bookkeepers and owners alike
A bookkeeper uses it to clean up coding before posting to the ledger. A business owner uses it to see whether the quarter is running hot or cold, especially if March has been a busy month and you are staring at 300 orders and a pile of receipts.
Where the register helps in real life
If you sell $15,000 of taxable goods and $4,200 of GST-free exports in the same month, the split matters straight away. The register keeps those lines visible so you do not treat every receipt like it carries GST at 10%.
What the ATO expects when you keep GST records
The ATO expects you to keep records for 5 years, and this template is built around that reality. If you are registered for GST, the register needs to support your BAS figures with enough detail to show what was sold, what was bought, and how the GST treatment was applied.
Your tax invoice paperwork needs the supplier’s identity, the ABN, the date, a description of what was supplied, and the words Tax Invoice when required. For invoices over $82.50, GST must be shown separately if the supply is taxable, and that is exactly why the template separates amount excl. GST from GST amount and amount incl. GST.
GST registration and BAS timing
You must register for GST once turnover hits $75,000 a year, or $150,000 for a not-for-profit. Most small businesses lodge BAS quarterly, while larger entities above $20 million turnover lodge monthly, so the FY quarter column helps you sort the register the same way the ATO expects to see it.
Rates and treatment
The standard GST rate is 10%. So a taxable sale of $9,500 has $950 GST included, while a GST-free export line or some basic food sales sit at 0% and should not be forced through the 10% rate.
Why the split matters
If you are doing PAYG withholding or running payroll with STP, this register is not replacing those reports, but it does help keep the GST side clean. That means fewer adjustments when you reconcile bank deposits, supplier payments, and the BAS before lodgement.
Where GST reconciliation goes wrong and what it costs
The most common failure is leaving transactions unreconciled until the last week of BAS prep, then discovering a bank feed match is missing or coded to the wrong GST status. If you miss a $4,200 purchase invoice with $420 GST, that is not just a bookkeeping tidy-up issue — it is a straight cash flow hit because you have paid GST you may not claim properly.
Wrong tax code, wrong BAS
Mixing taxable, GST-free, and out-of-scope entries is how a tidy spreadsheet turns messy fast. A $2,000 export sale treated as taxable can add $200 of GST that should never have been there, and if you repeat that across 12 lines you are $2,400 out before you notice.
Missing ABN or missing document
If a supplier bill does not carry an ABN or enough detail, you can lose the support for the input tax credit. I have seen a small retail operator lose several hundred dollars in GST claims in one quarter just because receipts were stuffed in a glovebox and never matched back to the register.
Bank feeds without a paper trail
Bank feeds are handy, but they do not tell you whether a receipt was for taxable goods, GST-free stock, or a private expense. If you reconcile only to the bank and not to the source document, you can end up with duplicated invoices, missing credits, and a BAS that needs fixing after it has already been lodged.
The real cost of late checking
Late clean-up usually means 2 or 3 hours of digging for every hour it should have taken. For a small business that is $150 to $300 of labour at bookkeeper rates, plus the stress of trying to sort it out before the due date.
Bank feeds without a paper trail make source documents essential, and the ABN invoice Excel template keeps taxable sales, GST-free items, and invoice details in one clean record before BAS checking begins.
How to make GST reconciliation part of your routine
The trick is to tie the spreadsheet to a job you already do, not to another vague admin task. If you reconcile every Friday after the bank download or on the first business day after payroll, the workbook stays current and does not become a quarter-end rescue mission.
Simple habits that keep it moving
- Copy last quarter’s tab structure and clear only the transaction lines, so you do not rebuild the register each time.
- Use the same GST status codes every week, such as Taxable, GST-free, and Purchase, so the entries stay consistent.
- Review the notes column for anything odd, like a supplier refund, reverse charge, or private component.
- Check the BAS Summary sheet before the due date so you can spot a GST amount that looks too high or too low.
When Excel is enough, and when it is not
If you are handling a few hundred lines a quarter, Excel is usually fine. Once you are closer to thousands of rows, multiple users, or live bank feeds, it is time to move to Xero or MYOB and let the software do more of the heavy lifting.
Use the same checkpoint every time
Pair the review with something fixed, such as the end of the month or the BAS calendar reminder. A 20-minute check every week is easier than a 4-hour scramble at quarter end, and it gives you a cleaner set of figures before you lodge.
Bei der BAS- und GST-Prüfung vor der Abgabe passt die BAS-Statement-Excel-Vorlage für Australien gut zum gleichen Monats- oder Quartals-Checkpoint und hält die Zahlen sauber, bevor du einreichst.
Frequently asked questions about this template
Download
File format
Excel (.xlsx)
Compatible software
Excel, Google Sheets, LibreOffice
Price
Free