Your Australian Profit and Loss Statement Template for 2026

Trying to get a grip on your business finances without the right tools is like navigating blind. Forget wrestling with confusing, custom-built spreadsheets. Our free profit and loss statement template, designed for both Excel and Google Sheets, is here to give you a clear, immediate snapshot of your financial health.

It’s built specifically for Australian small businesses, helping you track income, categorise expenses, and, most importantly, figure out your net profit.

Download Your Free P&L Template

Think of a Profit and Loss (P&L) statement less as a tedious accounting task and more as your strategic command centre. It tells the financial story of your business over a set period, showing you exactly where your money came from and, just as crucially, where it went.

This isn't just some generic template we found online. We’ve built this from the ground up with the realities of running a business in Australia in mind. It helps you stay compliant with ATO requirements and makes preparing for your Business Activity Statement (BAS) much less painful by getting your finances organised correctly from day one.

Get Your Template Instantly

Ready to get started? Grab the format that works for you. Both versions are fully featured and ready for you to plug in your numbers.

• Download the Excel P&L Template Here
• Access the Google Sheets P&L Template Here

To give you a head start, we've put together a quick summary of the essential terms in our P&L template and what they actually mean for your business.

Key P&L Components and What They Mean

Getting these components right is what gives you a true picture of your financial performance.

Why This P&L Template Is A Game-Changer

A well-structured P&L is essential for navigating market ups and downs. For example, in a single quarter of late 2025, Australia saw corporate profits dip by a seemingly tiny 0.03%. For a small business, a swing like that isn't subtle—it can be the difference between a good month and a bad one. A clear P&L helps you see these trends in your own numbers and react fast.

Your P&L statement is more than just a compliance document; it’s a decision-making tool. It shows you what’s working, what isn’t, and where you can make changes to improve your profitability.

Our template makes this analysis straightforward, simplifying the calculation of your net profit—the "bottom line" that tells you if you're actually making money after everything is paid. While a template is a fantastic starting point, many growing businesses eventually upgrade to dedicated accounting software. If you're nearing that stage, our guide on the best accounting software for small businesses in Australia is the perfect next read.

How to Fill Out Your P&L Template Correctly

Alright, you've got the template. Now comes the important part: filling it with the right numbers. The secret to a P&L that you can actually rely on is to get all your figures organised before you start typing. This is less about being an accounting whiz and more about methodical data entry.

Your business bank statements are the best place to start. Treat them as your single source of truth—they provide a clean, chronological record of every dollar that has come in and gone out, which helps ensure no transaction gets missed.

Gathering Your Revenue Figures

First up is your revenue, or income. This is the lifeblood of your business and the first number you need to lock in. We’re talking about all the money your business earned during the reporting period, before a single expense is taken out.

So, where do you find this figure?

• Invoicing Software: If you’re using platforms like Xero, MYOB, or QuickBooks, simply run a sales report for your chosen period (e.g., 1 July to 30 September).
• Sales Receipts: For cash-based or retail businesses, it’s a matter of totalling your daily or weekly sales dockets.
• Bank Deposits: The final check. Always cross-reference your sales records against the actual deposits hitting your business bank account. It’s the easiest way to catch anything you might have missed.

Once you have that total, plug it into the ‘Revenue’ or ‘Total Income’ line at the top of the P&L template. A critical point: if you're GST-registered, make sure these numbers exclude GST. Your BAS deals with the GST component, so keeping it out of your P&L is essential for an accurate profit figure.

Defining Your Cost of Goods Sold

Next, we look at the Cost of Goods Sold (COGS). This section is specifically for businesses that sell physical products, representing the direct costs of creating or acquiring the items you've sold.

Pro Tip: If you're a service-based business—like a consultant, freelance designer, or tradie who only charges for labour—you probably won't have any COGS. Just leave this section blank or enter zero. Your Gross Profit will simply be the same as your Total Revenue.

For product-based businesses, COGS typically includes:

• The cost of raw materials or the stock you purchased.
• Direct labour costs that went into manufacturing the goods.
• Shipping and freight costs to get the goods into your possession.

Subtracting COGS from your revenue gives you your Gross Profit. This is a powerful number that shows just how efficiently you're pricing and producing your goods.

Itemising Your Operating Expenses

Operating Expenses, often called overheads, are all the costs that keep the lights on and the business running day-to-day. These aren't directly tied to making a specific product, but your business couldn't function without them.

Go through your bank and business credit card statements for the period and start categorising each expense. Our template comes with pre-filled common expense lines, but feel free to rename or add new ones that fit your specific business.

Common overheads you'll be looking for include:

• Rent: For your office, storefront, or workshop space.
• Wages and Super: Salaries and superannuation contributions for your staff.
• Marketing and Advertising: Costs for your social media campaigns, Google Ads, or printed flyers.
• Software Subscriptions: All those monthly fees for accounting software, project management apps, and other tools.
• Utilities: Your electricity, internet, and phone bills.
• Professional Fees: Any payments made to your accountant, bookkeeper, or lawyer.

Tracking these expenses meticulously is non-negotiable for both an accurate P&L and for staying on the right side of the ATO. For a closer look at what records you absolutely must keep, you can learn more about ATO record-keeping requirements in our detailed guide.

Once every expense is entered, the template does the final bit of work for you, calculating your Net Profit. This is the bottom line—the true measure of how financially successful your business was over the period.

Real-World P&L Scenarios for Australian Businesses

Theory is one thing, but seeing a profit and loss statement template come to life with real numbers is where the magic happens. Let’s walk through two classic scenarios we see every day with Australian small businesses.

These examples show just how differently a P&L works depending on your business model. Once you see the numbers in action, you’ll have a much clearer idea of how to apply the template to your own unique situation.

Scenario 1: The Sydney-Based Freelance Graphic Designer

First up is Chloe, a freelance graphic designer based in Sydney. Because her business is purely service-based, she has no Cost of Goods Sold (COGS). This is a key detail. It means her Gross Profit is simply her total revenue, which puts all the focus on her Operating Expenses.

For the September quarter, Chloe’s P&L gives her a crystal-clear snapshot:

• Total Revenue: Chloe invoices $22,000 from a handful of client projects she wrapped up during the quarter.
• Operating Expenses: Her main outgoings are for digital tools and getting her name out there. This breaks down to $600 for software (think Adobe Creative Cloud), $1,200 for her co-working space membership, and $500 on online ads.
• Net Profit: After taking away $2,300 in expenses from her $22,000 revenue, Chloe’s net profit is a healthy $19,700.

This simple report tells Chloe exactly what she really earned. It also clearly shows that her software and rent are fixed costs, but her advertising spend is a lever she can pull to manage her bottom line. Nailing this distinction is vital for smart planning and is a common theme we see when helping firms with breaking the accounting firm growth plateau.

Scenario 2: The Brisbane Cafe Owner

Now let's head to Brisbane and look at Ben, who runs a buzzing local cafe. His business is a whole different ball game, with physical products, stock to manage, and staff on the payroll. His P&L is naturally more complex, especially when it comes to COGS.

For that same September quarter, Ben's financial story looks very different:

• Total Revenue: The till rings up $95,000 from coffee, food, and a bit of merchandise.
• Cost of Goods Sold (COGS): This is a huge one for him. Ben spent $30,000 on all the direct inputs—coffee beans, milk, bread, and other ingredients.
• Gross Profit: His Gross Profit comes to $65,000 ($95,000 - $30,000). This figure is critical because it tells him how profitable his core products are before any overheads are factored in.

From that Gross Profit, Ben then subtracts all his operating expenses:

• Wages and Super: $35,000, his biggest expense, covering penalty rates for weekend staff.
• Rent and Utilities: $15,000 for his prime spot and the power needed to keep the lights on and coffee machine running.
• Other Expenses: Another $5,000 on marketing, bank fees, and equipment repairs.
• Net Profit: After subtracting $55,000 in operating expenses from his $65,000 Gross Profit, Ben’s net profit for the quarter is $10,000.

Even Australia's largest institutions follow this fundamental formula. The Big Four banks, for example, posted a combined profit of $29.8 billion AUD in a recent fiscal year—a figure derived from a far more complex version of this same revenue-minus-expenses calculation. For a small business owner like Ben, this P&L is just as essential for managing his BAS and making informed decisions every single day. You can get more insights from the KPMG analysis on major bank results.

These two examples show that no matter your business type, a P&L provides the clarity needed to see what drives your bottom line. It pinpoints exactly where your money is going, empowering you to control costs and maximise your profit.

Common P&L Mistakes to Avoid

Getting your Profit and Loss statement right isn't just a box-ticking exercise for the tax office; it's the difference between flying blind and making smart, informed decisions. A few common slip-ups can easily turn your P&L into a misleading document that costs you money and obscures the real health of your business.

Steering clear of these pitfalls is non-negotiable for ensuring your financial reports are a reliable source of truth for BAS lodgements and tax returns. The single biggest mistake we see, especially with new businesses, is mixing personal and business money.

Using one bank account for everything is a recipe for a bookkeeping nightmare. It makes it almost impossible to cleanly separate business expenses, which often leads to overstating your profit and paying more tax than you need to. The fix is simple but critical: open a separate business bank account immediately. This creates a clear financial boundary and makes your life infinitely easier come tax time.

Misclassifying Expenses and Forgetting Key Items

The next common trap is getting your expense categories wrong or missing crucial items altogether. This often happens with big-ticket purchases or non-cash expenses that aren’t as obvious as a monthly supplier invoice.

Watch out for these classic classification errors:

• Forgetting Asset Depreciation: When you buy a major asset like a ute, machinery, or even expensive computer equipment, you can't claim the full cost in one hit. Instead, you claim its depreciation as an expense over several years. Forgetting to record this annual depreciation expense will make your profit look much higher on paper than it actually is. Always check the ATO’s guidelines to claim depreciation correctly.
• Incorrect GST Calculations: Recording expenses inclusive of GST on your P&L will throw all your numbers off. Your P&L needs to show the GST-exclusive cost of your purchases. The GST you pay and collect is accounted for separately on your Business Activity Statement (BAS).
• Mixing Up COGS and Overheads: Putting an operating expense (like your marketing spend or accountant's fees) into your Cost of Goods Sold (COGS) will completely distort your Gross Profit. This hides the true profitability of what you sell, making it much harder to set the right prices.

A clean profit and loss statement template doesn’t just help with tax; it reveals operational efficiencies. Avoiding these mistakes is key to unlocking those insights and making informed decisions that drive real growth.

This focus on operational health is vital. Recent ABS Business Indicators show that company gross operating profits in Australia surged 5.8% in December 2025, a significant rebound from previous dips. This highlights just how much effective expense management—which starts with an accurate P&L—impacts your bottom line. You can find more details in the ABS business indicators report. By avoiding these common errors, you ensure your financial data is a powerful tool for navigating market changes and improving your profitability.

Turning Your P&L Data into ATO Compliance

Once your profit and loss statement is complete, you're not just looking at a report. You're holding the exact data needed to meet your obligations with the Australian Taxation Office (ATO). The numbers you’ve carefully organised don't just sit on a spreadsheet; they feed directly into your mandatory tax filings.

Think of your P&L as the master document for your tax compliance. The ‘Total Revenue’ figure is the starting point for declaring sales on your Business Activity Statement (BAS). In the same way, the ‘Net Profit’ you calculated—your bottom line—is the foundational number for your annual income tax return.

From P&L to BAS and Tax Return

It’s crucial to understand how these figures connect. The data from your profit and loss statement template slots directly into the fields required by the ATO, a process that’s essential for accurate reporting and avoiding costly mistakes.

Here’s how that data flows from your P&L into your filings:

• Total Sales for BAS: The total revenue recorded on your P&L is what you report at label G1 (Total Sales) on your BAS.
• GST Calculation: The GST you’ve collected on sales and paid on expenses (which you should track separately from your P&L figures) is reconciled on your BAS to calculate your final GST payable or refundable amount.
• Income Tax: Your net profit from the P&L becomes the figure you declare as business income on your tax return. All those itemised expenses become your business tax deductions.

This is the critical step that turns your financial data into ATO-ready information. You're moving from simple bookkeeping to active tax compliance.

For Australian businesses, making sure this data handling is meticulous is non-negotiable. Exploring some business process automation examples can show how technology can help streamline getting your P&L data ready for reporting.

When You Need an Expert on Your Team

While a solid template gets you a long way, navigating the finer points of BAS lodgement and tax law can feel overwhelming. What happens if you’ve fallen behind? What if you’re not 100% sure about claiming a specific deduction? This is where professional support makes all the difference.

At Australia Wide Tax Solutions, we specialise in turning your financial data into complete peace of mind. We're here to help you not just comply, but to do it confidently while optimising your tax position. We are experts in:

• BAS Lodgement: We prepare and lodge your BAS for you, ensuring it’s accurate and on time, every single time. You can read more about our approach in our detailed guide to business activity statement lodgement.
• Overdue Returns: If you're behind on your tax, we get you caught up quickly and efficiently. We’ll even liaise with the ATO on your behalf to minimise the stress.
• Personalised Advice: We go beyond just the numbers. Our team provides tailored accounting advice to help you truly understand your financial position and plan for a more profitable future.

Your P&L is the starting point. Let us handle the rest.

Frequently Asked Questions About P&L Statements

Once you start using a profit and loss statement, practical questions always come up. To give you a head start, we’ve put together straight-up answers to the queries we hear most often from our clients, whether they're running a small business or managing a property portfolio.

How Often Should I Update My Profit and Loss Statement?

For almost every Australian small business, our advice is the same: update your P&L monthly. This rhythm does two things perfectly. It keeps your financial data fresh and aligns seamlessly with your quarterly Business Activity Statement (BAS) reporting cycles.

At the absolute bare minimum, you need to prepare one each quarter to hit your ATO deadlines. We see it all the time—business owners leaving everything until the end of the financial year. It’s a costly mistake that almost always leads to errors, missed deductions, and a last-minute scramble at tax time.

Can I Use This P&L Template for My Rental Property?

Yes, absolutely. Our P&L template is built to handle rental properties perfectly. It gives you a clear, structured way to track your investment’s performance, which is exactly what you need for your tax return.

It’s quite simple to set up:

• Your total rental income for the period goes straight into the ‘Revenue’ section.
• Then, you’ll list all your tax-deductible expenses—things like agent fees, council rates, repairs, and loan interest.
• The template automatically calculates your net rental profit or loss.

That final figure is the one you’ll transfer directly to the rental property schedule in your annual tax return. Keeping this updated throughout the year makes tax time a whole lot simpler.

What Is the Difference Between a P&L and a Balance Sheet?

This is a common point of confusion, but the distinction is pretty simple.

A Profit and Loss (P&L) statement is like a movie. It shows you the story of your business’s financial performance over a set period, whether that's a month, a quarter, or a full year. It pits your income against your expenses to show whether you made a profit or a loss.

A Balance Sheet, on the other hand, is just a snapshot. It’s a photo of everything your business owns (assets) and everything it owes (liabilities) on a single, specific day.

While you need both reports for a complete financial overview, your P&L is the day-to-day tool you’ll use to understand profitability and guide your business decisions.

This flowchart shows how your P&L statement is the crucial first step in your compliance journey, feeding directly into your BAS lodgements and annual tax return.

As you can see, keeping an accurate P&L isn’t just for your own records. It’s the very foundation of meeting your tax obligations with the ATO.

Feeling behind on your BAS lodgements or have overdue tax returns? The team at Australia Wide Tax Solutions is here to get you organised and fully compliant, without the stress. Contact us today for personalised accounting support.