What is the BAS Statement Excel template for?

It is for recording GST sales and purchases in one place, then checking the totals before you lodge your BAS. The workbook includes BAS Data, BAS Summary and Instructions sheets.

Can I use this spreadsheet for quarterly BAS lodgements?

Yes. It is set up for quarterly tracking, which suits most small businesses in Australia. You can also use it monthly if you want a tighter GST check.

Does the template work with GST-inclusive and GST-exclusive amounts?

Yes. The register includes separate fields for GST Exclusive Amount, GST Amount and GST Inclusive Amount, so you can see the tax component clearly.

What BAS codes should I use in the sheet?

Use the BAS code that matches the transaction, such as GST on sales or GST on purchases. Keep private spending out of the BAS register so your totals stay clean.

Do I still need to keep invoices and receipts?

Yes. The ATO expects you to keep business records for 5 years, including source documents that support the numbers in your BAS register.

When should I move from Excel to accounting software?

If your register is getting messy, you have lots of bank transactions, or you are spending more than an hour a week on checks, software like Xero or MYOB will usually save time.

Accounting & GST

BAS Statement Excel - Free Template

Track GST sales and purchases, quarter by quarter, with BAS Data, BAS Summary and Instructions sheets.

2026-06-18

131 Downloads

4.8/5 Average rating

Download template

Skärmbild 1: fliken BAS Data - Excelmall bas statement excel spreadsheet australia

This BAS Statement Excel template tracks GST sales and purchases, then rolls the figures into a simple quarterly summary you can use for your BAS. It includes a BAS Data sheet, a BAS Summary sheet and an Instructions sheet.

If you’re doing your own GST work or helping a small business keep the books straight, this gives you a clean place to enter transactions, code them to BAS categories and check the totals before you lodge. The workbook is set up for Australian dates, currency and quarter-by-quarter reporting.

The screenshots show the register layout, the summary view and the setup notes, so you can see the structure before you start typing. It’s built for practical bookkeeping, not fiddly formatting.

The key benefits of this Excel template

Keeps all BAS transactions in one register so you can sort out sales and purchases without hunting through bank feeds.
Separates GST exclusive, GST and GST inclusive amounts, which makes quarter-end checking faster.
Helps you code items to the right BAS line, such as GST on sales or GST on purchases.
Shows payment status and quarter fields, so you can spot unpaid items before you finalise the BAS.
Gives you a summary sheet for a quick review before you lodge with the ATO.
Uses Australian date and currency formatting, so amounts appear as $1,234.56 and dates as DD/MM/YYYY.
Cuts down on manual recalculation by letting the workbook handle the totals for you.

Step-by-step guide

Open the BAS Data sheet and enter each sale or expense on its own line. Use the date, invoice or receipt number, ABN and description so the record is complete.
Pick the correct BAS code for each transaction. For example, sales with GST go to GST on sales, while business purchases with GST go to GST on purchases.
Enter the GST exclusive amount first, then check the GST amount and GST inclusive amount. For a $1,000 sale with GST, the inclusive total should be $1,100.00.
Review the Quarter column and make sure each line sits in the right reporting period. That helps when you’re preparing a quarterly BAS.
Use the BAS Summary sheet to check totals before lodging. Compare the register against your bank reconciliation and any unpaid invoices or bills.
Read the Instructions sheet if you want a quick refresher on how to enter data and keep the sheet tidy. It is handy when someone else needs to use the file.

Skärmbild 2: fliken BAS Summary - Excelmall bas statement excel spreadsheet australia — Figure 2: Worksheet "BAS Summary"

What is included

BAS Data sheet with 15 columns, including Date, Transaction Type, ABN, BAS Code, GST Exclusive Amount and Notes.

BAS Summary sheet to pull the reporting figures together for a quarter-by-quarter review.

Instructions sheet for setup and data entry guidance.

Australian formatting for dates and currency, so the workbook is ready for local bookkeeping.

Colour-coded headings and input areas that make the register easier to scan.

Rows already set up for sales and expense transactions, with sample entries to show the structure.

Built to support reconciliation before you lodge, so you can compare the register with your bank records.

How small businesses use this BAS spreadsheet in Australia

This workbook is built for the person who has to get the BAS sorted without wasting half a day in the accounting file. A sole trader, office manager or bookkeeper can use it to capture sales, purchases and GST as they happen, then check the quarter total before lodging.

Image 1 shows the BAS Data sheet, and that is where the work starts. You enter the date, transaction type, invoice or receipt number, customer or supplier, ABN, city, description, BAS code and amount fields, then use the summary sheet to see what needs attention.

Who actually uses it

A chippie with 4 employees might run $28,000 a month through the register, split between progress claims, tool purchases and fuel. A sole trader doing their own books can use the same layout for a quarterly BAS deadline without opening a full accounting package.

What gets checked before lodgement

The useful bit is not just the total. It is whether the GST on sales, GST on purchases and payment status line up with the bank and the invoices, so you are not guessing at quarter end.

Why the summary matters

Image 2 shows the BAS Summary sheet, which is the quick-check page when you want to compare the register against the numbers you are about to lodge. For a business with 300 invoices a month, that saves you from scrolling through every line when only the quarter totals matter.

Skärmbild 3: fliken Instructions - Excelmall bas statement excel spreadsheet australia — Figure 3: Worksheet "Instructions"

GST and BAS rules that apply to this register

In Australia, GST is 10%, and you must register once turnover hits $75,000 a year, or $150,000 for a not-for-profit. That is why this spreadsheet matters: it gives you a clean way to separate GST on sales from GST on purchases before your BAS goes in.

For most small businesses, BAS lodgement is quarterly. If your turnover goes above $20 million, the ATO expects monthly lodgement, so a register like this becomes more of a live control sheet than a once-a-quarter tidy-up.

What a tax invoice must show

The ATO expects a tax invoice to show the supplier’s identity, the ABN, the words Tax Invoice, the date, and a clear description of what was sold. If the invoice is over $82.50 including GST, GST must be shown separately.

How the numbers flow through the BAS

If you sell a service for $1,100 including GST, the GST-exclusive amount is $1,000 and the GST is $100. If you buy laptop software for $440 including GST, the GST component is $40, which may be claimable as an input tax credit if it relates to your business.

Records the ATO expects you to keep

You need to keep business records for 5 years. That includes invoices, receipts and working papers, so a register like this is handy when you are asked to explain a figure months later.

Where BAS records usually go wrong

The most common mess is simple: the GST is entered twice, or not at all. On a quarter with $80,000 in GST-inclusive sales, a 10% mistake is $8,000 in the wrong bucket, and that can turn into a painful correction once you notice it.

Another regular problem is mixing up cash and accruals. If you record the sale when the invoice is issued but only pay GST when the customer pays, your BAS can drift off by thousands, especially in a business with $40,000 in unpaid debtors at quarter end.

Wrong BAS codes

GST on sales and GST on purchases are not interchangeable, and private expenses should not be in the BAS at all. I have seen people dump every bank transaction into one line, then spend 3 hours untangling fuel, subscriptions and owner drawings.

Missing or weak source documents

If the invoice has no ABN or no clear GST detail, you can lose the input tax credit. On a stack of 50 bills a month, even 5 missing receipts at $220 each means $100 in GST you may not be able to claim.

Not matching the register to the bank

Without reconciliation, you do not know whether a payment was duplicated, reversed or simply not allocated. That is how a $1,320 supplier bill turns into a double payment that only gets found when cash flow is already tight.

Fehlende Belege und die Abstimmung des Registers mit der Bank gehören zusammen: Die GST reconciliation Excel template Australia sorgt dafür, dass doppelte Zahlungen, fehlende Quittungen und nicht zugeordnete Buchungen schneller auffallen.

How to make BAS tracking part of your month

The spreadsheet works best when you tie it to a routine you already do. Most small businesses will get more out of it if they update it weekly, then do a proper check at the end of the month or before the quarterly BAS deadline.

Simple habits that keep it current

Enter receipts the same day you get them, before they disappear in the ute or the glovebox.
Copy the previous quarter’s workflow so you are not rebuilding the file every time.
Use one consistent BAS code list, so you do not rename categories halfway through the year.
Check the summary after each reconciliation, not only at lodgement time.

When the spreadsheet has done its job

If you are handling 10,000+ lines a year, the file will still work, but the manual checking starts to bite. At that point, Xero or MYOB is usually the better move because bank feeds, rules and audit trails do more of the heavy lifting for you.

For a smaller business with one or two staff and modest GST volume, this template is often enough to keep the BAS under control. Once the register is taking you more than an hour a week, it is time to look at a proper system rather than stretching Excel past its comfort zone.

Bei einer kleinen Firma mit ein oder zwei Mitarbeitenden gehört die ABN-Rechnungsvorlage für Excel in Australien oft zum nächsten sauberen Schritt, weil sie Rechnungsstellung und BAS-Abgleich in einem einfachen Format zusammenhält.

Frequently asked questions about this template

It is for recording GST sales and purchases in one place, then checking the totals before you lodge your BAS. The workbook includes BAS Data, BAS Summary and Instructions sheets.
Yes. It is set up for quarterly tracking, which suits most small businesses in Australia. You can also use it monthly if you want a tighter GST check.
Yes. The register includes separate fields for GST Exclusive Amount, GST Amount and GST Inclusive Amount, so you can see the tax component clearly.
Use the BAS code that matches the transaction, such as GST on sales or GST on purchases. Keep private spending out of the BAS register so your totals stay clean.
Yes. The ATO expects you to keep business records for 5 years, including source documents that support the numbers in your BAS register.
If your register is getting messy, you have lots of bank transactions, or you are spending more than an hour a week on checks, software like Xero or MYOB will usually save time.