Price:CA$13.05
Small Business Bookkeeping Tracker, Excel Google Sheets, Income Expense Profit (Instant Download)
You can only make an offer when buying a single item.
Highlights
SMALL BUSINESS BOOKKEEPING & TAX TRACKER — Excel and Google Sheets, with a worked quarter already inside
Most bookkeeping templates have the same hole in them: they treat the money you pay yourself as a business expense. Do that and your profit is wrong, your tax figure is wrong, and a good year looks like a bad one.
This one keeps your own wages on a separate tab, where they belong. It also has a business-use column, so 60% of a phone bill is 60% — not all of it and not nothing.
IT ARRIVES FILLED IN
Nine sales, twelve costs, five journeys and four owner movements across a worked quarter. Nothing is blank, so you can see exactly what every column does before you touch it. Then you type over it.
THE EIGHT TABS
Start Here — what each tab does, the colour rules, and the honest limits.
Setup — six answers: your financial year, the share of profit you set aside for tax, whether you charge sales tax or VAT, and your mileage rate. Underneath them, where you stand today.
Money In — 400 rows. Sales, payouts, wholesale, workshops. Sales tax split out only if you say you charge it.
Money Out — 500 rows, 15 categories, with a Business use column that works out the deductible figure for you.
Mileage — 200 journeys at whatever rate your tax office allows.
Owner Money — money you took out, money you put in. Neither is income and neither is a cost.
Month by Month — 24 months: profit, tax to set aside, what you drew, and what the business actually kept.
Categories — every category totalled, each cost shown as a share of your income.
THE HALF PAGE THAT MATTERS
The bottom of the Setup tab answers the only questions a small business really asks:
Profit before tax. Tax you should have set aside. What you have actually moved. Short by — in red, because it is not your money. Then what you have taken out, what you have put in, and the profit that is genuinely still in the business.
In the worked example that last figure is positive but the tax pot is short by $1,027.59. That is the situation almost every small business is in and almost none of them can see.
ANY COUNTRY, ANY CURRENCY
Your tax percentage, your sales tax rate, your mileage rate. Nothing here assumes where you live, because a file that does is wrong for almost everybody. Say No to sales tax and every figure you type is simply the whole amount — no columns to ignore.
TWO COPIES IN THE DOWNLOAD
One workbook has the worked example filled in, so you can see what every column expects before you touch anything. The second is the same file completely blank — same tabs, same formulas, same charts — ready for your own numbers from the first row. Start on whichever suits you.
WORKS WITH
Microsoft Excel 2016 or newer, Windows or Mac. Google Sheets — upload and open with Sheets; every formula works, the dropdowns look a little different, the print settings do not carry across. LibreOffice. No macros, so nothing to enable and nothing your antivirus will object to.
HONEST LIMITS — please read before buying
- It is not accounting software. No bank feed, no invoicing, no double entry, no VAT return, no filing. It is a clean record you can hand to an accountant, and most of them would rather have this than a shoebox.
- It does not know your tax rules. Every rate is a number you type. Nothing here is tax advice.
- No stock valuation and no depreciation. Equipment is a cost in the month you bought it.
- One currency at a time. There is no exchange rate handling.
- It will not fill itself in. Fifteen minutes on a Friday with the bank statement open. Skip a month and the numbers stop being true.
- Capacity: 400 income rows, 500 cost rows, 200 journeys, 100 owner movements, 24 months.
ABOUT ACCESS — I never ask for shop access. No password, no manager invite, no app permissions. You buy the file, you download it, that is the whole transaction.
Instant download. Two files — the spreadsheet and a written Start Here guide — on the order page as soon as payment clears.
Instant Download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases —
see programme terms
Be the first to review this item
More from this shop
Visit shop-
Digital download
Short-Let Host Tracker | Excel & Google Sheets for Airbnb, Booking.com (Digital Download)
CA$13.05
-
Digital download
Recipe Costing Spreadsheet, Excel Google Sheets, Restaurant Food Cost Calculator, Menu Engineering and Plate Cost Tracker (Digital Download)
CA$13.05
-
Digital download
Reseller Inventory Tracker, eBay Vinted Poshmark Profit Log (Excel Google Sheets)
CA$13.05
-
Digital download
Club and PTA Treasurer Spreadsheet, Excel Google Sheets, Bank Reconciliation and Budget Report (Digital Download)
CA$13.05
Shoppers with similar taste loved these
-
Digital download
Small Business Bookkeeping Spreadsheet Inventory Tracker Order Tracker Product Handmade Pricing Calculator Client Tracker Google Sheet Excel
Sale Price CA$16.50
Original Price CA$33.00
-
Digital download
Small Business Finance Tracker Notion Template, Income and Expense, Bookkeeping, Notion Financial Planner
Sale Price CA$10.60
Original Price CA$15.15
-
Digital download
All-in-One Business Spreadsheet Bundle | Editable Google Sheets & Excel Templates |Complete Sales and Inventory Management System|PLR Rights
Sale Price CA$1.72
Original Price CA$5.54
-
Digital download
Small Business Bundle Bookkeeping Inventory Tracker Order Tracker Product Handmade Pricing Calculator Smart Bill Calendar Google Sheet Excel
Sale Price CA$20.00
Original Price CA$40.00
-
Digital download
PLR Small Business Digital Product Bookkeeping Tracker Task & Invoice Tracker Financial Planner Client Tracker Digital Download
Sale Price CA$10.75
Original Price CA$21.49
-
Digital download
Small Business Planner Budget Spreadsheet: Income, Expense, Inventory Tracker, Sales Tax, Bookkeeping Template Accounting (Google Sheets)
Sale Price CA$6.25
Original Price CA$11.36
-
Digital download
Etsy Seller Bookkeeping Spreadsheet Small Business Planner Income Expense Profit Tracker Google Sheets Excel Accounting Template Tax Tracker
Sale Price CA$11.00
Original Price CA$22.00
-
Digital download
Small Business Bundle: Bookkeeping, CRM, Inventory, Pricing, Bills, Cash Flow (Google Sheets, Excel)
Sale Price CA$9.14
Original Price CA$26.09
-
Digital download
Tax Deduction Tracker Excel Self Employed Tax Spreadsheet Small Business Freelancer Tax Prep Template Itemized Write Offs Tracker
CA$6.51
-
Digital download
Small Business Bookkeeping Tracker Inventory Tracker Order Tracker Handmade Product Task Tracker Pricing Calculator Google Sheets Excel
Sale Price CA$15.00
Original Price CA$30.00
-
Digital download
Invoice Tracker Client Tracker Template Small Business CRM Template Service Business Task Tracker Freelancer Google Sheets Excel Spreadsheet
Sale Price CA$7.50
Original Price CA$15.00
-
Digital download
Small Business Tax Deductions Cheat Sheet for US Taxes (Digital Download)
CA$2.16