BAS Preparation Worksheet

What Is a BAS Preparation Worksheet?

A Business Activity Statement (BAS) Preparation Worksheet is an internal document used by business owners, bookkeepers, and tax agents to gather and calculate data before lodging the official form with the Australian Taxation Office (ATO). It is not a statutory form that you send to the government. Instead, it serves as a working paper or a "pre-accounting" tool. It helps you organise your figures so that what you enter into the ATO portal is accurate and supported by evidence.

For many Australian small businesses, particularly tradies and sole traders, the BAS process can be confusing. There are numerous labels, codes, and deadlines. A worksheet bridges the gap between your raw records, like bank feeds and invoices, and the final lodgement. Under the Taxation Administration Act 1953, you are required to keep records that explain all transactions relevant to your tax affairs. This worksheet acts as a primary part of that record-keeping system, serving as the evidentiary trail if the ATO ever asks questions about your figures.

Using this tool helps you separate your Goods and Services Tax (GST) calculations from your Pay As You Go (PAYG) withholding obligations. It ensures that you have calculated the net amounts correctly before you commit to them. You can use a physical paper version or a digital spreadsheet. Regardless of the format, the goal is to reconcile your accounts against the official BAS labels to prevent errors that could lead to penalties or audits.

When to Use This Document

You should use a BAS Preparation Worksheet at the end of every tax reporting period. For most businesses, this is quarterly, though some large businesses lodge monthly. It is best used as soon as your period ends, well before the due date.

The worksheet is particularly useful in specific scenarios. If you are a business owner using accounting software like Xero or MYOB, you might think the software does it all for you. However, software is only as good as the data entered. You should use this worksheet to manually check the software figures. It helps catch data entry errors, such as miscoded expenses or duplicated invoices.

Tax agents and bookkeepers often send these worksheets to their clients as a data collection tool. If you work with an agent, you might receive one via email. It acts as a formal request for any outstanding information. For example, your agent might need to know if you used a business vehicle for private purposes during the quarter. The worksheet prompts you to answer these questions so the agent does not lodge incorrect information under the Tax Agent Services Act 2009.

You should also use this worksheet if you are approaching the GST registration threshold. The current threshold for businesses is $75,000 turnover (or $150,000 for non-profits). If you are not yet registered but are getting close to this figure, a worksheet helps you monitor your proximity to the limit. Even if you do not need to lodge a full BAS, tracking these figures prepares you for when you cross the threshold.

Key Sections and Required Elements

To be effective, a BAS Preparation Worksheet must be structured in a way that aligns with the official ATO BAS form. This alignment minimises the risk of transposition errors when you eventually transfer the figures. Below are the essential sections you need to include in your document.

Section 1: Business Identity and Reporting Period

You must clearly identify the business entity and the timeframe you are reporting on. This seems obvious, but it is a critical first step to avoid mixing up quarters. Include the following fields:

• Australian Business Number (ABN): This is the unique identifier the ATO uses to track your business.
• Business Name: The registered name of your enterprise.
• ASIC Number (if applicable): If you are a company, include your Australian Securities and Investments Commission (ACN) or ARBN number.
• BAS Period: Clearly state the start and end dates of the month or quarter.
• Accounting Method: You must select either "Cash" (accounting for income and expenses when money changes hands) or "Accrual" (accounting for them when invoices are issued or received). You cannot mix these methods, so this selection is vital for legal compliance.

Section 2: GST Reconciliation (Labels G1–G10)

This is usually the most detailed section of the worksheet. It focuses on calculating your net GST obligation. You need to separate your sales and purchases to find the difference.

• Total Sales (G1): This is the total amount of sales, including GST, for the period.
• GST-free Sales (G2): You must record sales that did not include GST, such as basic food, medical services, or exports. Separating this ensures G1 is not overstated and that you do not pay tax on exempt income.
• Input Taxed Sales (G3): These are sales where you do not charge GST, but you also cannot claim credits for the GST paid on your inputs.
• Capital Purchases (G10): This captures significant business assets, like vehicles or machinery, bought during the period. Identifying these is critical because it helps you determine if the GST credits on these purchases are fully deductible.
• Non-Capital Purchases (G11): This covers your regular running expenses, such as office supplies or materials.
• Estimated GST on Purchases: You need a calculation field to work out the total GST credits you are claiming.

Section 3: PAYG Withholding (Labels W1–W4)

This section deals with the tax amounts you have withheld from payments to others, such as employees or contractors.

• Total Wages (W1): The gross amount of salary and wages paid for the period.
• Total Withholding (W2): The total tax amount you actually withheld from those payments and sent to the ATO.
• Closely Held Payees: If you have payments to individuals who are not standard employees, like family members in a family business, you may need to report these separately under W3 and W4.

Section 4: PAYG Instalments and Fuel Tax Credits

Depending on your business structure, you may need to include sections for other tax types.

• PAYG Instalments (T1/T2): If you pay instalments towards your expected annual income tax liability, include a section to record the instalment income and the amount payable.
• Fuel Tax Credits (FTC): If you are in the transport or trade industry, you likely claim credits for the tax included in the fuel you purchase. This is claimed through the BAS but is separate from GST. A worksheet should include a specific field to calculate FTC based on the fuel types used and the eligible quantity.

Section 5: Disclaimer and Declaration

Finally, the worksheet must include a disclaimer. This protects the creator if the document is provided as a template. It should state that the worksheet is a preparation tool only and does not constitute legal or tax advice. If you are a tax agent using this, a declaration by the preparer confirms that the figures are true and correct to the best of their knowledge. This aligns with the Code of Professional Conduct under the Tax Agent Services Act 2009.

How to Write a BAS Preparation Worksheet (Step by Step)

Creating and filling out this document requires a methodical approach. Follow these steps to ensure your worksheet is accurate and compliant with Australian regulations.

Step 1: Set Up Your Document Layout

Start by creating a document that mirrors the ATO BAS form. Use a spreadsheet program like Excel or Google Sheets, or use a pre-formatted BAS Preparation Worksheet template. Set up columns for the "Label Code," "Description," "Amount," and "Notes."

At the very top, create a header for your Business Details (ABN, Name) and the Reporting Period. Add a drop-down menu or a checkbox to select your Accounting Method (Cash vs Accrual). Ensuring this is set first prevents you from accidentally mixing cash and accrual figures, which is a common error that complicates audits.

Step 2: Reconcile Your Bank Accounts

Before you enter any figures into the worksheet, you must reconcile your bank accounts in your accounting software. This means matching the transactions in your software to your bank statements. If there are discrepancies, resolve them now. Unreconciled items lead to incorrect data entry on your worksheet.

If you do not use accounting software, gather your bank statements and receipts. You will need to manually total your income and expenses. Sort them into piles or categories: Sales, GST-free sales, Purchases, and Wages.

Step 3: Record Sales Figures (GST)

Move to the GST Sales section of your worksheet.

1. Calculate Total Sales (G1): Add up all income for the period.
2. Identify GST-free Sales (G2): Go through your sales invoices. Identify which ones were for GST-free items (e.g., fresh food, exports, certain medical items). Record this total in the G2 field. Ensure the sum of G2 and your taxable sales equals G1.
3. Calculate GST Payable: If you are on a spreadsheet, use a formula to calculate 1/11th of your taxable sales (G1 minus G2). This is your GST liability on sales.

Step 4: Record Purchase Figures (GST Credits)

Next, focus on what you bought for the business.

1. Separate Private Expenses: Review your expenses. Remove any items that are purely private (e.g., personal groceries). For mixed-use items, like a home office or a business vehicle, you need to determine the business use percentage. Only record the business portion in the worksheet.
2. Record Capital vs. Non-Capital: Input your significant asset purchases into the Capital Purchases (G10) section. Input your day-to-day running costs into Non-Capital Purchases (G11).
3. Check for GST-Free Purchases: Some business purchases do not have GST in the price (e.g., bank fees, some imports). Ensure you are not claiming credits on these.
4. Calculate GST Credits: Calculate the total GST you paid on these business purchases. This is the amount you are entitled to claim back as a credit.

Step 5: Calculate Net GST

Subtract your GST Credits from your GST Payable. If the result is positive, that is the amount you owe the ATO. If it is negative, that is your refund. Enter this figure clearly at the bottom of the GST section. This is "Label 1A" (if you owe money) or "Label 1B" (if you are owed money) on your official BAS.

Step 6: Complete PAYG Withholding Sections

Enter your Total Wages (W1) from your payroll records. Next, enter the Total Tax Withheld (W2). Ensure these figures match your payroll software reports exactly. If you have been paying contractors, check if you need to withhold tax from them. Not all contractors require this, so check the ATO guidelines or consult your Tax Agent Appointment if you are unsure.

Step 7: Review and Verify

Once all figures are in, review the worksheet. Check for obvious mistakes, like inverted numbers or missing decimals. Verify that the totals match your source documents. This review process is your last line of defence against an inaccurate lodgement.

Step 8: Save and Store

Save the completed worksheet as a PDF. Store it in your digital records alongside your bank statements and the final lodged BAS confirmation. Under the Income Tax Assessment Act 1936, you are required to keep these records for five years. This worksheet serves as your audit trail, explaining how you arrived at the figures on the official form.

Common Mistakes to Avoid

Even experienced business owners can trip up on their BAS. Being aware of these common pitfalls will help you use your worksheet effectively.

Claiming Credits on Private Expenses

A frequent error for small businesses, especially tradespeople, is claiming GST credits for expenses with significant private use. The most common example is a vehicle used for both work and personal trips. You cannot claim the full GST credit on the fuel and registration for that vehicle. Your worksheet must have a specific step to calculate the "private use proportion." You need to keep a logbook to substantiate this percentage. If you claim 100% of the credits on a dual-purpose asset, you will likely owe money back to the ATO during an audit.

Mixing Accounting Methods

Another major mistake is recording sales on a cash basis but recording purchases on an accrual basis. You must choose one method and stick to it for the entire income year. Your worksheet should force a selection at the very top. If you record a sale when the invoice is sent (accrual) but record an expense only when you pay the bill (cash), your GST calculation will be distorted. This mixing makes it very difficult for the ATO to verify your accounts and can trigger a review.

Ignoring the FBT Reconciliation

Fringe Benefits Tax (FBT) can be tricky. Some businesses forget to integrate their FBT instalments into the BAS. If you provide fringe benefits to employees, like a company car or gym membership, you pay FBT. You pay these instalments through the BAS. If your worksheet does not have a section for FBT, you might miss the payment. This leads to a mismatch between your BAS and your FBT return, resulting in interest charges and penalties.

Missing Fuel Tax Credits

Businesses in transport, agriculture, and mining often forget to calculate Fuel Tax Credits. These credits provide a refund for the tax included in the fuel price used in machinery, vehicles, and heavy equipment. It is important to note that FTC is claimed on the BAS but is entirely separate from GST. A robust worksheet will include a specific estimator for FTC. It should ask for the litres of fuel purchased and the type of activity it was used for. Missing this claim is essentially leaving money on the table.

Incorrectly Rounding Figures

The ATO has specific rules on rounding. You generally round to the nearest whole dollar. Figures ending in 50 cents or more round up, and figures ending in less than 50 cents round down. Some businesses truncate figures or use inconsistent rounding across the document. This causes the totals to be out by a few dollars when compared to the ATO system. Your worksheet should apply consistent rounding rules to every field to avoid these annoying discrepancies.

Legal Considerations (AU)

When preparing a BAS in Australia, you are navigating a strict legal framework. Your worksheet is not just a piece of paper; it is a component of your compliance obligations.

Record Keeping Obligations

The Taxation Administration Act 1953 and the Income Tax Assessment Act 1936 (specifically Section 262A) mandate that you keep records that explain all transactions. The ATO requires these records to be kept for five years. This includes your BAS Preparation Worksheet. If the ATO audits your business, they will ask to see how you calculated your figures. A worksheet that clearly links the final BAS label to the underlying invoices and bank statements acts as your best defence. Without it, proving your position is difficult, and you may face penalties.

Privacy and Data Protection

If you create this worksheet using a digital platform or share it with a tax agent, data protection laws apply. The Privacy Act 1988 (Cth) governs how personal information is handled. Your worksheet contains sensitive data, such as ABNs, turnover figures, and employee details. You must ensure that any digital storage is secure. If you are a tax agent sending this to a client, you must ensure the transmission method is secure. You cannot use this information for purposes other than preparing the tax return without consent.

Accuracy and Penalties

The law requires you to take reasonable care in lodging your BAS. Under the Taxation Administration Act, failure to take reasonable care can result in administrative penalties. If your worksheet is sloppy, disorganised, or unchecked, it increases the risk of lodging an incorrect BAS. While the worksheet itself is not lodged, it is the mechanism that ensures accuracy. If you are unsure about a tax law, relying on a worksheet without seeking advice is not considered "taking reasonable care." You should consult the ATO guidelines or a registered tax professional.

The Role of Tax Agents

If you use a registered tax agent, they have their own set of legal obligations under the Tax Agent Services Act 2009. They are bound by a Code of Professional Conduct to act with honesty and integrity. They use the worksheet to verify that the information you provide is accurate. If you provide a worksheet with errors, and the agent lodges based on it without checking, both parties could be in trouble. However, if the agent identifies a discrepancy on the worksheet, they are legally obligated to clarify it with you before lodging.

Disclaimer Limitations

Finally, consider the legal status of the document itself. If you download a template from a website, it must contain a disclaimer. It must state that it is a guide and not legal advice. Australian law prohibits unregistered individuals from providing tax advice for a fee. A worksheet is a tool, but it cannot replace the judgment of a professional. Always include a note that the document is prepared for information purposes only and should be reviewed by a qualified professional.

Frequently Asked Questions

Do I need to lodge the worksheet with the ATO?

No. The BAS Preparation Worksheet is an internal document. You use it to calculate your figures, but you only lodge the official BAS through the ATO portal, via your myGov account, or through a registered tax agent's software.

Can I change my accounting method on the worksheet?

You generally cannot change your accounting method (Cash vs Accrual) from one quarter to the next without notifying the ATO. You must choose a method and stick to it for the income year. If you wish to change, you usually need to apply to the ATO or wait until the start of a new financial year. The worksheet should reflect the method you are currently registered to use.

What if I made a mistake on a worksheet from a previous quarter?

If you discover a mistake in a previous quarter's calculation after you have already lodged, you cannot just fix the worksheet. You need to revise your BAS. You can do this by lodging a revised activity statement through the ATO portal or by asking your tax agent to make an adjustment. The worksheet for the current period should then be used to ensure the new figures are correct.

Is a digital worksheet better than a paper one?

Both are legally valid as long as they are accurate. However, a digital worksheet (spreadsheet or software) offers advantages. It automatically calculates totals, reducing mathematical errors. It is also easier to store and backup, which helps meet the five-year record-keeping requirement. Digital formats also make it easier to send to your bookkeeper or agent securely.

Who is responsible for the accuracy of the figures?

Ultimately, the business owner or director is legally responsible for the accuracy of the BAS lodged, even if an employee or a bookkeeper fills out the worksheet. The worksheet is a tool to help you meet your obligations under the Taxation Administration Act 1953, but it does not shift the legal liability from you to the person preparing the document. You must review the figures before signing or authorising the lodgement.