Income and Expense Tracker

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. After checkout you get a download page right away, plus a receipt by email. 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.

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

Email varsdigitals@gmail.com and we'll help you get set up.