Bookkeeping Spreadsheet, Profit and Loss, Bookkeeping Template, GST Tracker, Google Sheets and Excel

A sole trader bookkeeping spreadsheet for Australia: track income and expenses, with GST, BAS figures and profit and loss that build as you type. Excel + Google Sheets.

WHAT'S INSIDE (10 TABS)
• Dashboard: 6 KPI cards, 3 progress bars, 4 charts
• Start Here: Setup steps, colour key, how to clear
• Setup: Business details, FY start, your categories
• Income: 500 rows, GST and FY check auto-fill
• Expenses: 500 rows, business-use %, receipt kept
• Invoice Tracker: Paid, not yet due, overdue + days late
• Summary: Every category by month
• Tax & BAS Figures: Quarterly G1, 1A, 1B figures you may need
• Profit & Loss: By quarter and full year, % of income
• Accountant Summary: One printable page for your tax agent

THE DASHBOARD
• KPI cards: Income, expenses and net profit for the year; GST on sales (1A) and GST on purchases (1B) figures; Unpaid invoices total
• Progress bars: financial year elapsed, receipts kept, invoices paid
• 4 charts: Income vs expenses by month (column), Expenses by category (bar), GST by quarter (column), Running net profit (line)
• Everything updates as you type, no buttons or macros

KEY FEATURES
• Starts blank: no sample rows to delete
• Amount excl. GST, quarter and FY check fill in for you
• Business-use % column for mixed-use purchases
• Invoice Tracker flags paid, not yet due and overdue, with days late
• Tax & BAS Figures tab: quarterly G1, 1A and 1B labelled as figures you may need (check ato.gov.au)
• Profit & Loss by quarter and full year, with % of income
• Accountant Summary: one printable page
• Your own categories and payment methods on Setup

WORKS WITH
• Google Sheets: click the copy link in the Quick-Start PDF and Google makes your own copy in your Drive. Free Google account, any browser or the app. No unzipping needed.
• Microsoft Excel 2016 or later, or Microsoft 365: unzip the download and open the .xlsx in Excel. Desktop recommended. No macros.
• Charts and formulas work in both. Excel adds data bars to the progress rows; Google Sheets shows them as text bars.
• Summary tabs are protected without a password in Excel so formulas aren't overwritten by accident. Google Sheets doesn't keep this, so take care with shaded cells there.

WHO IT'S FOR
• Australian sole traders, freelancers and side hustles
• Anyone who wants GST and BAS figures in one place
• People who'd rather not pay monthly for software
• Handing a tidy summary to a tax agent

NOT FOR
• Payroll, employees or super
• Lodging a BAS or tax return for you
• Linking to your bank feed
• Companies or trusts with complex accounts

HOW TO USE
1. Make your copy: click the Google Sheets link in the Quick-Start PDF, or unzip the download and open the .xlsx in Excel.
2. On Setup, type your business name and the year your financial year starts. Edit the lists if you like.
3. Add each payment you receive on Income and each business purchase on Expenses.
4. Add invoices on Invoice Tracker and the date paid when the money arrives.
5. Watch the Dashboard, Summary, Tax & BAS Figures and Profit & Loss tabs fill in.

FILES (INSTANT DOWNLOAD)
• SlateAndTally-Sole-Trader-Bookkeeping-Spreadsheet.zip: the .xlsx spreadsheet plus the Quick-Start PDF
• SlateAndTally-Sole-Trader-Bookkeeping-Spreadsheet-Quick-Start.pdf: the same Quick-Start guide on its own, with your Google Sheets copy link
• SlateAndTally-Sole-Trader-Bookkeeping-How-To-Video.mp4: a short how-to video (MP4, no sound) that walks through the Quick-Start steps
• Digital download: nothing physical is shipped. Your files are under Purchases once payment is confirmed.
• Preview images use made-up example numbers. Your file starts blank.

PAIRS WELL WITH
• Receipt + Deduction Tracker (A$8.95)
• 12-Week Car Logbook (A$7.95)
• Work From Home Log (A$7.95)
• Or get all 5 in the Tax Time Bundle for A$19.95 (A$54.75 separately, save A$34.80)

PLEASE NOTE
General info only, not tax, legal or financial advice. Check current rules at ato.gov.au or with a registered tax agent.
This template is a record-keeping tool. It isn't provided by, approved by or endorsed by the ATO, and it doesn't lodge or send anything to the ATO or any bank. Labels such as G1, 1A and 1B are there to help you find figures you may need. Rules change, so check what applies to you.

LICENCE
For your own personal, household or business record-keeping. Please don't share, resell or redistribute the files or the Google Sheets links.

How this was made: designed by our shop. Layout code and written text were drafted with the help of AI-assisted tools, then reviewed and edited by us. No AI image generators were used: every preview image is a render of the actual spreadsheet, filled with made-up example numbers.

REFUNDS
Because this is a digital download, we don't offer returns or exchanges for change of mind. This doesn't affect your rights under the Australian Consumer Law: if a file is faulty, won't open, or isn't as described, send us a message and we'll fix it, replace it or refund you.

Microsoft Excel is a trademark of Microsoft Corporation. Google Sheets is a trademark of Google LLC. SlateAndTally is not affiliated with either.

Part of the Records & Ledgers (AU) collection from SlateAndTally.