How to build a freelance income and expense tracker in a spreadsheet

You don't need accounting software to know whether you're making money. A single sheet with six columns, one dropdown and one formula will do it.

The six columns

One row per payment received or expense paid. Resist the urge to add more columns until you actually miss them.

1. Date: the day the money moved, not the day you invoiced.
2. Type: Income or Expense. Make this a dropdown (Data > Data validation > List) so you can't mistype it.
3. Category: also a dropdown, fed from a short list on a second tab.
4. Description: what it was, in a few words.
5. Client / Vendor: who paid you or who you paid.
6. Amount: always a positive number. The Type column says which direction it went, so you never have to remember a minus sign.

Keep the category list short

Four income categories and eight to ten expense categories is plenty: for example client work, retainers, product sales, other; software, equipment, contractors, marketing, travel, home office, professional fees, other. If you can't decide between two categories, you have too many. You can always split one later because the description column is still there.

The one formula you need

To see income for January 2026 on a summary tab, with the tracker on a sheet called Transactions:

=SUMIFS(Transactions!F:F, Transactions!B:B, "Income",
        Transactions!A:A, ">="&DATE(2026,1,1),
        Transactions!A:A, "<"&DATE(2026,2,1))

Change "Income" to "Expense" for spending, and add a category test (Transactions!C:C, "Software") to get a per-category figure. Put the month starts (1 Jan, 1 Feb, ...) in a header row and reference them instead of typing dates, so you can copy the formula across all twelve months. Net profit for each month is then income minus expenses.

A ten-minute monthly routine

1. Export or open your bank and card statements for the month.
2. Add a row for every deposit that was client money and every payment that was a business cost.
3. Skip transfers between your own accounts; they aren't income or expense.
4. Check that the month's income total roughly matches what your invoices say you were paid.
5. Glance at net profit. If it's lower than you expected, look at the biggest expense category first.

Common mistakes

• Mixing personal and business spending. Use a separate card or account if you can; otherwise only enter the business share.
• Logging invoices as income. An invoice is a promise. Track those on a separate invoice log and only record income when the money arrives.
• Letting it pile up. Twelve small sessions are far easier than one December marathon.

General information about using spreadsheets, not financial, tax or accounting advice. What records you must keep, and for how long, depends on where you live; check with your tax authority or a qualified professional.