BAS Tracker for Trades

What Is a BAS Tracker for Trades?

A BAS Tracker for Trades is a specialised record-keeping tool designed to help Australian tradies organise their financial data for Business Activity Statement (BAS) lodgment. Unlike a standard spreadsheet, this tracker is structured to align with the specific labels and requirements used by the Australian Taxation Office (ATO). It acts as a pre-accounting ledger where you record daily income and expenses, ensuring you have the correct figures for GST, PAYG withholding, and other tax obligations when the time comes to lodge.

For many tradespeople, the transition from the "shoebox" method of storing receipts to a more formal system can be challenging. Industry data from the Council of Small Business Organisations Australia (COSBOA) shows that while 62% of small businesses have moved to digital software for cash flow, many still rely on manual spreadsheets for their final review before sending data to their accountant. A BAS Tracker bridges this gap. It provides a clear, manual format to capture transactions without the complexity or cost of full accounting software.

This tool is particularly useful for sole traders and subcontractors who need to separate private use from business use. It helps you calculate exactly how much GST you have collected and how much you can claim back. By keeping everything in one place, you reduce the risk of missing deductions or making errors that could trigger an ATO audit. You can use this tracker alongside standard invoicing templates to ensure your paperwork is consistent from start to finish.

When to Use This Document

You should use a BAS Tracker for Trades if you are registered for GST and your business turnover is below the threshold requiring complex accounting software. The ATO mandates that businesses keeping records electronically must ensure those records are accessible and readable for a minimum of five years. Using this tracker consistently throughout the financial year ensures you meet that legal obligation under the Taxation Administration Act 1953.

This document is essential during specific key periods:

• Quarterly Reporting: Most tradies lodge their BAS quarterly. Use the tracker to collate all data from the past three months. This makes the process of completing the actual ATO form much faster.
• Monthly Reporting: If your business turnover exceeds $20 million, or if you voluntarily choose to report monthly, the tracker helps you stay on top of your cash flow obligations more frequently.
• Tax Time: Even if you use a registered tax agent, they will need a summary of your income and expenses. Providing a well-maintained tracker can lower your accounting fees because your bookkeeper spends less time sorting through messy receipts.
• Buying Assets: When purchasing significant tools or vehicles, use the tracker to record these separately. This helps you apply the correct instant asset write-off rules or depreciation schedules at the end of the year.

This tracker is also vital if you hire subcontractors. Under the Taxable Payments Annual Report Act 2012, businesses in the building and construction industry must report payments made to contractors. Using a tracker that captures ABNs and payment amounts ensures you have this data ready for your annual report.

Key Sections and Required Elements

A robust BAS Tracker must include several specific components to be legally compliant and practically useful. These sections mirror the layout of the official BAS form to reduce cognitive load when transferring figures.

Disclaimer and Usage Guide

The document must start with a clear disclaimer. It should state that the tracker is a record-keeping aid designed to assist with Section 262A of the Taxation Administration Act 1953. It must explicitly declare that it is not an ATO form and does not constitute financial advice. This limitation of liability is crucial under Australian Consumer Law to prevent misleading conduct regarding professional financial guidance.

Business Details

You need a dedicated section to record static business information. This includes your Australian Business Number (ABN), the date you registered for GST, and your chosen accounting method (Cash vs. Accrual). Most micro-businesses in the trades sector use the Cash method, recording income only when money hits the bank. Specifying this here prevents confusion later.

Income (GST Sales)

This section tracks your revenue. It requires columns for the date, client name, description of work, total amount, and the GST amount. It must allow you to flag GST-free sales. The ATO requires records to verify that you are correctly calculating tax obligations, so distinguishing between taxable sales and GST-free income (like some basic food items or exports, though less common for trades) is necessary for accurate reporting.

Expenses (GST Purchases)

This is where you record outgoings. Essential columns include date, supplier, description, total amount, and GST paid. Crucially, this section must include a column for "Business Use Percentage". This is where you account for the split between business and private use. For example, if you buy a mobile phone and use it 50% for work, you can only claim 50% of the GST credit. Failing to record this is a common error.

Capital vs. Non-Capital Acquisitions

The ATO distinguishes between purchasing business assets (Capital) and running expenses (Non-capital). Your tracker needs a way to flag capital purchases over $1,000. This helps you and your accountant identify items that may be subject to depreciation or instant asset write-off rules rather than immediate expense deductions.

Contractor Payments (TPAR Data)

If you engage other tradies or subcontractors, you need a specific tab for this. It must capture the contractor’s ABN, name, address, gross amount paid, and the GST amount. This directly supports your Taxable Payments Annual Report (TPAR) obligations.

Wages and PAYG Withholding

If you have employees, this section aligns with Single Touch Payroll (STP) requirements. It should summarise total wages (W1) and amounts withheld (W2) so you can reconcile these figures against the STP report you submit to the ATO.

How to Write a BAS Tracker for Trades (Step by Step)

Setting up your tracker correctly from day one saves hours of work later. Whether you are building this in Excel or using a pre-formatted template, follow these steps to ensure it meets Australian standards.

Step 1: Define Your Accounting Method

Before you enter a single number, decide if you are reporting on a Cash or Accrual basis. If you are a small business with a turnover under $10 million, you can choose. Most tradies prefer Cash because it aligns with actual bank flow. Write this method clearly at the top of your spreadsheet. Do not switch methods without consulting the ATO or a tax professional, as it changes when you must pay tax.

Step 2: Set Up the Income Sheet

Create columns for Date, Client, Invoice Number, Description, Total Income (G1), and GST on Sales (1A). If you deal with international clients or have other input-taxed income, add a column for "GST-Free Sales". Ensure every entry has a corresponding source document, such as a tax invoice. The A New Tax System (Goods and Services Tax) Act 1999 requires records to be sufficient to verify your tax calculations, so vague descriptions like "labour" are insufficient. Be specific, such as "Install guttering - 42 Smith St".

Step 3: Configure the Expenses Sheet

Structure your expenses sheet to match the BAS purchase labels. Create columns for Date, Supplier, Description, Total Purchases (G11), and GST on Purchases (1B). The most important step here is adding the "Business Use %" column. For every expense that could have personal use (vehicles, home office, tools), enter the percentage. If you claim 100% business use on a work ute but occasionally use it for a weekend trip, you must keep a logbook to justify that percentage. Link this percentage to a formula that adjusts the claimable GST amount automatically.

Step 4: Create the Contractor Tab

Set up a separate table for subcontractors. The Taxable Payments Annual Report Act 2012 requires you to report payments to contractors. Create columns for Contractor Name, ABN, Address, Gross Payment, and GST. Whenever you pay a subcontractor, record it here immediately. Do not wait until the end of the year to chase ABNs, as you cannot claim a tax deduction if you do not provide a valid ABN to the supplier.

Step 5: Incorporate Digital Receipt Links

Best practice for digital record keeping involves storing the actual receipt. The ATO confirms that paper records can be digitised. If you are using a cloud-based system, add a column in your tracker for "Receipt Link". When you photograph a receipt with your phone, upload it to your cloud storage and paste the hyperlink into your tracker. This ensures your records are "true and correct" and makes an audit much less stressful.

Step 6: Add a Summary Sheet

Create a dashboard that pulls totals from your other sheets. This summary should show your Total Sales, Total GST on Sales, Total Purchases, and Total GST on Purchases. This dashboard is what you (or your bookkeeper) will use to fill in the official BAS form. By having these figures calculate automatically, you reduce the risk of manual data entry errors.

Common Mistakes to Avoid

Even with a tracker, errors can occur if you are not diligent. Understanding these common pitfalls will help you stay compliant and avoid penalties.

Failing to Separate Private and Business Expenses

One of the biggest mistakes tradies make is claiming 100% of the GST credit on items used for both personal and business purposes. The Income Tax Assessment Act 1997 only allows deductions for expenses incurred in gaining or producing assessable income. If you use your work van for family trips, or your home internet for personal streaming, you must adjust the claimable percentage. A good tracker prompts you to enter this split every time. If you do not, you risk underpaying tax and incurring fines and interest charges.

Ignoring the Taxable Payments Annual Report (TPAR)

Many tradies forget that paying a subcontractor "cash in hand" does not exempt them from reporting requirements. If you are in the building and construction industry, you must report these payments to the ATO. Failing to keep a record of contractor ABNs and payment amounts throughout the year leads to a scramble at tax time. This often results in missing data and potential penalties for non-lodgment.

Using the Tracker for Input Taxed Income

Some income sources are "input taxed", meaning you do not charge GST on them, but you also cannot claim GST credits on related purchases. A common example is basic bank interest. If you record bank interest in your main GST sales column, you might inadvertently think you owe GST on that amount. Conversely, if you claim GST credits on expenses related solely to earning that interest, you will be claiming credits you are not entitled to. Your tracker should have a separate row for "Other Income" that is not included in the GST calculation.

Mixing Up Accounting Methods

Another common error is recording a sale when you issue the invoice (Accrual method) but recording an expense when you pay it (Cash method). You must be consistent. If you have chosen the Cash method, do not record the invoice in your tracker until the money lands in your bank account. Mixing methods distorts your figures and can lead to paying GST before you have actually received the payment from your client.

Neglecting Record Retention

The Taxation Administration Act 1953 requires you to keep records for five years. A mistake many digital users make is deleting old spreadsheets to save space. You must archive your trackers at the end of each financial year and keep them accessible. If the ATO audits you and you cannot produce the records from four years ago, you may face substantial penalties.

Legal Considerations (AU)

Using a BAS Tracker involves several legal responsibilities beyond just maths. As a business owner in Australia, you must adhere to specific federal legislation regarding how you handle data and report income.

Taxation Administration Act 1953

This is the primary legislation governing your record-keeping duties. Section 262A requires you to keep records that explain all transactions and enable the ATO to assess your tax liability. Your tracker must contain enough detail—dates, amounts, entities, and the nature of the transaction—to satisfy this requirement. A simple list of numbers is not enough. The records must be in English or easily convertible to English.

Privacy Act 1988

If your tracker contains information about other people—such as client names, addresses, or contractor ABNs—you must consider privacy laws. If your business has an annual turnover of less than $3 million, you may be exempt from the Privacy Act 1988. However, if you turn over more than $3 million, or if you act as a service provider to a larger entity, the Australian Privacy Principles (APPs) apply. This means you must protect the personal information in your tracker from misuse and unauthorised access. If you store your tracker on a laptop or cloud drive, ensure it is password protected.

Tax Agent Services Act 2009

It is important to understand the boundary between bookkeeping and providing tax advice. If you are creating this tracker for your own use, that is fine. However, if you are a professional offering this tool to clients, you must be careful. The Tax Agent Services Act 2009 prohibits unregistered individuals from providing tax advice services. Your tracker should include a disclaimer stating that the data generated should be reviewed by a registered BAS Agent or Accountant prior to lodgment. Do not rely on the tool to interpret complex tax laws for you.

Single Touch Payroll (STP)

While STP reporting is done through payroll software, your BAS tracker must align with it. The Taxation Administration Act 1953 (Schedule 1) mandates STP reporting. If your tracker shows different wage figures than what you report through STP, you have a discrepancy that needs immediate attention. Consistency between your internal records and external reporting is a key legal requirement.

Frequently Asked Questions (preview)

Do I need a registered Tax Agent to set up my BAS Tracker?

No, you do not need a registered agent to set up a record-keeping spreadsheet. However, you should seek advice from a professional if you are unsure about your GST obligations or which accounting method is best for your business. The tracker is a tool to organise data, not a substitute for professional tax strategy.

Can I keep my records on paper instead of a digital tracker?

Yes, the ATO accepts paper records. However, they must be clear and legible. Given the complexity of modern trades businesses, a digital tracker is generally safer because it performs calculations for you and reduces human error. If you do keep paper records, remember that the ATO accepts digital copies, so you can scan your paper receipts and store them electronically.

Is a BAS Tracker legally binding?

The tracker itself is not a legal document sent to the government. It is an internal record. However, the data within it becomes part of your legal tax return. If the information in your tracker is incorrect and leads to a false BAS lodgment, you are legally responsible for any penalties. Therefore, accuracy in the tracker is just as important as accuracy on the official form.

How does the Instant Asset Write-Off affect my tracker?

The Instant Asset Write-Off allows you to immediately deduct the full cost of eligible business assets. In your tracker, you still record this as a "Capital Acquisition". However, you might flag it with a specific code or note for your accountant so they know to apply the write-off rules rather than depreciating the asset over several years. You should link to specific asset register templates to manage these items effectively.