Who is this sole trader BAS spreadsheet for?

It is for sole traders who need a simple way to track GST sales, GST credits, BAS codes and payment status before lodging a BAS. If you are doing your own books or handing clean records to a bookkeeper, it gives you the basics in one file.

Does the template work for quarterly BAS lodgements?

Yes. The Transactions sheet and BAS Summary sheet are set up for quarterly tracking, which suits most small businesses that lodge BAS every 3 months rather than monthly.

What GST rate does the spreadsheet assume?

The template is built around the Australian GST rate of 10%. If a sale or purchase is GST-free, you can record that in the relevant fields so it does not flow through as taxable GST.

Can I use this if I am not registered for GST yet?

Yes. You can still use it as a transaction register, then switch on the GST fields once your turnover reaches $75,000 a year or you decide to register earlier.

How long should I keep the records?

The ATO record-keeping rule is 5 years, so keep the spreadsheet and the supporting invoices, receipts and bank statements for that period. That makes it easier if you need to explain a BAS figure later.

When should I move from Excel to accounting software?

Once your transaction volume grows, or you need payroll, super and STP, software like Xero or MYOB is usually the better fit. If you are spending more time fixing spreadsheets than running the business, it has outgrown the file.

Accounting & GST

Sole Trader BAS Excel - Free Template

BAS register for sole traders with GST, GST-free amounts, BAS codes, payment status and quarterly tracking.

2026-06-20

209 Downloads

4.8/5 Average rating

Download template

Screenshot 1: Transactions tab - Excel template sole trader bas excel spreadsheet australia

This Sole Trader BAS Excel spreadsheet is a simple register for tracking GST taxable sales, expenses, BAS codes and payment status in one place. It includes a Transactions sheet, a BAS Summary sheet and an Instructions sheet so you can sort out your quarterly numbers without chasing receipts.

Use it to keep your reconciliation tidy through the quarter, then pull the figures you need for your BAS. The layout is built for a sole trader who wants a clean paper trail and a quick view of what is owing before the ATO deadline hits.

Image 1 shows the transaction register, image 2 shows the BAS summary dashboard, and image 3 gives you the setup notes. If you are lodging yourself through myGov or giving records to a bookkeeper, this keeps the numbers easy to check.

The key benefits of this Excel template

Tracks GST-inclusive, GST and GST-exclusive amounts in separate columns.
Gives you a quarter-by-quarter view for BAS prep across the financial year.
Helps you match receipts, invoices and bank entries during reconciliation.
Records BAS codes, payment method and status for each line item.
Makes it easier to spot missing ABN details or unpaid invoices.
Saves time at quarter end by keeping income and expenses in one register.
Works well for a sole trader who needs a clean audit trail for the ATO.

Step-by-step guide

Open the Transactions sheet and enter each sale or expense on the date it happens. Keep the description short but specific so you can still identify the receipt later.
Fill in the BAS fields for each line item, including the GST rate and BAS code. If a receipt is GST-free or outside the BAS, note that clearly in the status or notes column.
Check the GST-inclusive amount against the GST and GST-exclusive columns. A $110 sale at 10% GST should split into $100 and $10, so any mismatch stands out fast.
Use the BAS Summary sheet near the end of the quarter to review totals. This is the point where you compare your figures with your bank account and invoice file.
Move through the list and mark items as paid, pending or needs review. That makes it easier to chase overdue amounts before they turn into a cash flow problem.
Follow the Instructions sheet when you first set it up, then copy the file each quarter. Keeping the same structure every time makes the next BAS quicker.

Screenshot 2: BAS Summary tab - Excel template sole trader bas excel spreadsheet australia — Figure 2: Worksheet "BAS Summary"

What is included

Transactions register with 16 columns for date, quarter, type, category, amounts and notes.

BAS Summary sheet for quarter-end totals and a fast view of GST positions.

Instructions sheet to help you set up and use the register without guesswork.

Clear GST amount and GST-exclusive amount fields for easy checking.

Separate status and payment method columns for follow-up and reconciliation.

Column widths set for practical use with descriptions, ABNs and receipt numbers.

Built for Australian BAS reporting, not a generic bookkeeping sheet.

How sole traders use this BAS spreadsheet during the quarter

A sole trader usually opens this spreadsheet when the quarter starts and keeps adding income and expenses as they land. That matters because a BAS lodgement is often due quarterly, and waiting until the last week means you end up digging through bank feeds, receipts and emails all at once.

Image 1 is the Transactions sheet, and it is set up for that day-to-day work. You can log a $275.00 invoice, a $16.50 software subscription, or a $48 fuel receipt, then tag each line with the right BAS code and payment status.

Why this suits a one-person business

If you are a chippie, plumber, designer or gardener, you usually do not need a full accounting system on day one. This spreadsheet gives you enough structure to keep the profit and loss trail straight without paying for software you are not yet using properly.

Where the BAS summary helps

Image 2 shows the BAS Summary sheet, which is where the quarter starts to make sense. Instead of scanning 80 rows one by one, you get the totals in one place so you can see whether your GST collected is running ahead of your GST credits.

For example, if you invoice $18,000 plus GST in a quarter and buy $4,400 of GST-inclusive supplies, you are not looking at the same outcome as a quarter with only $6,000 of sales. The sheet helps you see that difference early, before you lodge and then need to fix it later.

Screenshot 3: Instructions tab - Excel template sole trader bas excel spreadsheet australia — Figure 3: Worksheet "Instructions"

What the ATO expects from your BAS records

The ATO expects you to keep records that explain your BAS figures, and the rule of thumb is to keep those records for 5 years. That means your invoices, receipts, bank statements and working papers should line up with the numbers you report, not just sit in a folder with no structure.

For GST, Australia uses a 10% rate on taxable supplies, and you generally register once your turnover reaches $75,000 a year. If you are a not-for-profit, the registration threshold is $150,000, which is why the BAS trail matters even before you get to scale.

How the fields map to BAS work

The register includes GST-inclusive amount, GST amount, GST-exclusive amount and BAS code so you can sort taxable sales from other items. That is useful when you have a $1,100 invoice, because the GST part is $100 and the base amount is $1,000, and you want that split to stay consistent.

If you issue invoices, the tax-invoice rules also matter. A valid tax invoice needs your identity, your ABN, the words Tax Invoice, the date and a clear description of what was sold, and GST must be shown separately on invoices over $82.50.

Image 3 gives you the setup notes so you can keep the sheet aligned with those rules from the start. That saves time when you are checking the quarter against your bank and preparing your BAS through myGov or business software.

That quarter-end check naturally leads into a GST reconciliation sheet, where the invoices, bank entries and BAS figures can be matched before you lodge.

The errors that create BAS headaches for sole traders

The biggest mistake is mixing GST-inclusive and GST-exclusive amounts in the same line without a clear check. If you enter a $220 receipt as the full expense and then also claim $20 GST again, you have doubled up and your BAS will be wrong by $20 on that one line alone.

Another common problem is ignoring cash flow timing. A sole trader can show a healthy quarter on paper, then hit trouble when $8,800 of invoices are still unpaid and the GST on those sales is sitting in the bank account waiting for the next lodgement.

Small errors that become expensive fast

Miss one invoice for $2,750 including GST and you have left out $250 of GST collected. If that happens across four or five sales, you can be out by more than $1,000 before you even notice, and the fix takes time plus a recheck of the whole quarter.

Receipts without an ABN, no GST shown, or no clear payment status also cause grief at reconciliation. I have seen sole traders spend two hours hunting a $19.95 receipt because the supplier name was missing from the bank export and the note field was blank.

The other trap is using the spreadsheet like a storage box instead of a working register. If you wait until the BAS due date and then try to enter 60 transactions in one sitting, the chance of a typo in the GST rate or quarter code goes way up.

How to turn the spreadsheet into a quarterly habit

The easiest routine is to update the register once a week and tie it to an existing task, like your bank reconciliation or Friday invoicing. If you leave it for the quarter end, the job gets bigger than it needs to be and you lose the clean trail that makes BAS work simple.

Practical habits that keep it alive

Set aside 15 minutes every Friday to enter receipts, invoices and payments.
Copy the finished quarter into a new file before you start the next BAS period.
Use the status column to flag missing receipts, unpaid invoices and items to review.
Keep the spreadsheet with your bank feed export so you can reconcile both together.
Turn on a simple check for odd GST amounts so a $110 line does not accidentally become $11 or $0.

If you are already processing 200 to 300 transactions a month, or you need payroll, super and STP as well, that is usually the point to move into Xero or MYOB. Until then, this spreadsheet is a solid middle ground for a sole trader who wants control without a full accounting stack.

As your transaction volume grows, the next practical step is a tax invoice with GST format for issuing compliant bills alongside your BAS records.

Frequently asked questions about this template

It is for sole traders who need a simple way to track GST sales, GST credits, BAS codes and payment status before lodging a BAS. If you are doing your own books or handing clean records to a bookkeeper, it gives you the basics in one file.
Yes. The Transactions sheet and BAS Summary sheet are set up for quarterly tracking, which suits most small businesses that lodge BAS every 3 months rather than monthly.
The template is built around the Australian GST rate of 10%. If a sale or purchase is GST-free, you can record that in the relevant fields so it does not flow through as taxable GST.
Yes. You can still use it as a transaction register, then switch on the GST fields once your turnover reaches $75,000 a year or you decide to register earlier.
The ATO record-keeping rule is 5 years, so keep the spreadsheet and the supporting invoices, receipts and bank statements for that period. That makes it easier if you need to explain a BAS figure later.
Once your transaction volume grows, or you need payroll, super and STP, software like Xero or MYOB is usually the better fit. If you are spending more time fixing spreadsheets than running the business, it has outgrown the file.