Tax Savings Tracker, Sole Trader Tax, BAS Savings, Income Tracker, Google Sheets and Excel

Opis sprzedawcy

A tax savings tracker spreadsheet for sole traders: set money aside as you earn, with weekly targets and a dashboard that shows if you're on track. FY 2026-27. Excel + Google Sheets.

WHAT'S INSIDE (7 TABS)
• Dashboard: 6 KPI cards, 3 progress bars, 4 charts
• Start Here: Setup steps, colour key, how to clear
• Setup: Your %, GST choice, opening balance
• Income: 500 rows: amount to set aside fills in
• Transfers: Money in, tax and BAS payments out
• Weekly: 53 weeks: target vs transferred
• Summary: Month by month, balance and gap
• Plus a fillable PDF in A4 and US Letter, 16 pages: how to use, set-aside plan + year overview, 12 monthly logs and a tax + BAS payments page

THE DASHBOARD
• KPI cards: Income received, target to set aside, transferred in; Gap and tax account balance; Paid to the ATO (as you log it)
• Progress bars: set aside vs target, weeks with a transfer, financial year elapsed
• 4 charts: Income, target and transfers by month (column), Tax account balance at month end (line), Running gap by week (line), What the target is for (doughnut)
• Everything updates as you type, no buttons or macros

KEY FEATURES
• Starts blank: no sample rows to delete
• Your own set-aside % (the 25% shown is only an example)
• Optional GST set-aside if you're registered
• Transfers in and payments out (income tax, instalments, BAS)
• Weekly tab: target, transferred and running gap for 53 weeks
• Summary: month by month balance and gap
• Fillable PDF log included (16 pages, A4 + US Letter)
• No macros, no bank connection

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. 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.
• Formula 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.
• The PDF: print at 100% / actual size, or type into the fillable fields in a PDF app that supports forms (for example Adobe Acrobat Reader). Some browser and preview apps don't save form fields.

WHO IT'S FOR
• Sole traders with no tax taken out
• Freelancers paid in uneven amounts
• Anyone caught out by a tax bill
• Keeping a tax savings account on track

NOT FOR
• Calculating the tax you owe
• Lodging returns or BAS
• Choosing your set-aside rate
• Bank feeds or automatic imports

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, choose your set-aside %, GST choice and opening balance.
3. Log each payment you receive on Income.
4. Log each transfer to your tax account, and any tax or BAS payments, on Transfers.
5. Check the Dashboard and Weekly tab to see if you're on track.

FILES (INSTANT DOWNLOAD)
• SlateAndTally-Tax-Set-Aside-Tracker.zip: the .xlsx spreadsheet plus the Quick-Start PDF
• SlateAndTally-Tax-Set-Aside-Tracker.pdf: the fillable PDF, A4
• SlateAndTally-Tax-Set-Aside-Tracker-Letter.pdf: the fillable PDF, US Letter
• SlateAndTally-Tax-Set-Aside-Tracker-Quick-Start.pdf: the Quick-Start guide on its own, with your Google Sheets copy link
• Digital download: nothing physical is shipped. Your files are under Purchases once payment is confirmed.
• Preview images use made-up example entries. Your files start blank.

PAIRS WELL WITH
• BAS + GST Quarterly Tracker (A$9.95)
• Rideshare + Delivery Tracker (A$11.95)
• Sole Trader Bookkeeping (A$14.95)
• Also in the shop: the Tax Time Bundle (A$19.95), Sole Trader, Receipts, Work From Home, Car Logbook and Rental spreadsheets

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. 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 and PDF pages, filled with made-up example entries.

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. Adobe and Acrobat Reader are trademarks of Adobe. SlateAndTally is not affiliated with Adobe.

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