Small Business Income Expense Tracker, Profit & Loss, Sales Tax Log (Excel)

Income and expense tracker spreadsheet: money in and money out in two simple lists, with profit by month, the sales tax you collected and paid, deductible expenses, a mileage log and a dashboard with charts.

WHAT IT DOES
- Income: date, client or source, description, income category, payment method, amount received, the sales tax you charged and the invoice number
- Expenses: date, vendor, description, category, payment method, total paid and the sales tax on the receipt, plus a receipt column
- Before-tax amounts calculate for every row; each expense category has its own deductible share (for example 50% for meals)
- Mileage log: date, from, to, purpose and distance, valued at your rate per km or mile
- Monthly summary: expenses by category and income by category for every month of the year, total income, profit (income minus expenses) and net sales tax (collected minus paid)
- Dashboard: income, expenses and profit for the year, sales tax collected and paid, net sales tax owing, deductible expenses, biggest expense category, a month-by-month table and two charts
- No monthly copying: one list for income and one for expenses. Change the year on the Settings tab to see another year
- Room for 1,000 income rows, 2,000 expenses and 500 trips. Works in any currency and with any sales tax name (GST, HST, VAT, sales tax)
- Only need expenses? Our Small Business Expense Tracker is the expenses-only version

WHAT YOU GET
- Income-and-Expense-Tracker.xlsx (blank)
- Income-and-Expense-Tracker-with-Sample-Data.xlsx (a filled-in example: 27 income rows, 62 expenses, 18 trips)
- Quick-start guide (PDF)

HOW YOU GET IT
Digital download. Your files are available right after purchase from your Etsy Purchases page. Nothing is shipped.

COMPATIBILITY
- Microsoft Excel 2016 or newer (Windows or Mac) and Excel for the web
- Google Sheets: upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets
- Needs a computer or tablet with a spreadsheet app. This is not an app or a printable planner

GOOD FOR
Freelancers, self-employed people, side hustles and small businesses who want to see what came in, what went out and what is left each month, ready for tax time.

PLEASE NOTE
A record-keeping tool, not accounting or tax software, and not tax advice. Deductible shares, mileage rates and how you report sales tax are your own inputs: check the rules that apply to you with your accountant. For use in your own business; please don't resell or share the files.

DISCLAIMER
This template is a planning tool and does not replace advice from a qualified or licensed professional (such as an accountant, financial advisor or lawyer). Check the results before you rely on them. Sold as is: because this is an instant digital download, all sales are final, with no returns, exchanges or refunds. If a file is damaged or won't open, message us and we'll send you a working copy.

HOW IT WAS MADE
Designed by VARS Digital with AI-assisted tools. Every formula is checked before release, and the sample file shows each tab working.

QUESTIONS
Message us through Etsy and we'll help you get set up.