Ultimate Freelancer Finance Tracker Spreadsheet Template for Google Sheets & Excel

A log of money coming in, each row with the date, the client, the project, the amount, how it was paid, whether it has landed, an invoice number and a note. Beneath, the total and three figures split by status - paid, pending and overdue. Splitting pending from overdue is the part worth having. Both are money you are owed, but one is a normal wait and the other is a conversation, and a single outstanding figure hides which is which. The invoice number is what makes a row traceable back to the document a client will ask about.

A log of money going out, each row with a date, a description, a category, the amount, a note - and a marker for whether you are treating it as deductible. That marker is a record of your own judgement rather than a ruling. What qualifies depends on your circumstances and where you file, and the column exists so the decision is written down beside the expense while you still remember the context - which is a better position to be in at year end than reconstructing it from a bank statement.

Eight client rows ranked by revenue (five filled in the sample), each with an expense share, the profit that leaves, the margin, how many projects each represents and the average per project. Revenue reads from the Income Log, so the ranking follows the work rather than an impression of it. The average per project is the column that changes minds. A client at the top of the revenue list who got there across nine small jobs is a different proposition from one who got there with two, and the ranking alone will not tell you which you are looking at.

Revenue, expenses and net profit set out by quarter, then a self-employment tax calculation, a reference table of income tax brackets, and the quarterly payment the two together imply. The quarterly figures read the Annual P&L grid, which reads the two logs - so a payment entered on the Income Log moves the quarter it falls in and everything below it. Above the tax lines sits a block of assumption cells holding the rates and the earnings ceiling the estimate uses, so a new tax year is a typing job rather than a formula edit. The self-employment figure splits into two lines, one of which stops once earnings pass that ceiling. The brackets shown are single-filer figures for reference, so the income tax line is an estimate for planning rather than a filing figure. What it is genuinely useful for is the size of the figure. Self-employment tax plus income tax on the same money is not a number most payslips prepare anyone for, and having it at the foot of a sheet is a different experience from meeting it at a deadline.

Six figures and two charts. Total revenue, total expenses and the net profit between them; then the profit margin, the quarterly tax estimate and your largest client by revenue. The top-client figure is a concentration check as much as a compliment. A freelancer earning most of their revenue from one source has a different risk profile from one spread across six, and it is the kind of thing that is obvious in hindsight and invisible day to day. Beneath, a table ranks clients by revenue, profit, margin and share of the total.