Income and Expense Tracker

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

• XLSXIncome-and-Expense-Tracker.xlsx (blank)
• XLSXIncome-and-Expense-Tracker-with-Sample-Data.xlsx (a filled-in example: 27 income rows, 62 expenses, 18 trips)
• PDFQuick-start guide (PDF)

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.