How to track freelance income and expenses in a spreadsheet

You don’t need accounting software to keep good freelance books. A well-set-up spreadsheet with two logs and a summary will tell you everything you need for budgeting and gives your accountant clean numbers at year end.

What to track

Income log: one row per invoice

• Invoice date, client, project and invoice number
• Amount
• Status: unpaid, paid, overdue or cancelled
• Paid date, which is the date the money arrived

The paid date matters most. It tells you when cash actually arrived (for budgeting, that’s what counts) and how long each client takes to pay.

Expense log: one row per cost

• Date, vendor, description and amount
• Category, such as software, equipment or travel
• Whether it’s tax-deductible

Keep categories short and consistent. Ten to fifteen is plenty. Use the same names every time, or the totals won’t add up correctly.

The monthly summary

A summary tab pulls the logs together by month. In Excel or Google Sheets, SUMIFS does the work. For example, paid income for March:

=SUMIFS(Amount, Status, "Paid", PaidMonth, 3)

From there, each month gets:

1. Profit: paid income minus expenses
2. Tax set-aside: profit × your tax rate (zero in a loss month)
3. Savings: profit × your savings rate
4. Safe to pay yourself: what’s left

A five-minute weekly routine

1. Add invoices you sent this week as unpaid.
2. Mark anything that’s been paid, with the date.
3. Add receipts and bills.
4. Check the summary and move your tax set-aside into its own account.

Weekly beats monthly: there are fewer receipts to find and you spot late payers sooner.

Useful extras

• Overdue highlighting. Conditional formatting that turns unpaid invoices red after 30 days.
• Average days to pay. Paid date minus invoice date, averaged. Useful when deciding which clients to keep.
• Expenses by category for the year. Accountants ask for this.
• An income goal per month, with a progress figure.

Build it or buy it?

You can build all of this yourself in an afternoon if you’re comfortable with spreadsheets. If you’d rather skip the setup and the formula debugging, our tracker has it ready to fill in.