Freelance income tracker spreadsheet: free layout and formulas
If you freelance, one sheet answering "who owes me what, and what did I earn this month?" saves real money. Here's a layout you can build for free.
Invoices sheet columns
| Col | Field |
|---|---|
| A | Client |
| B | Invoice # |
| C | Date sent |
| D | Due date |
| E | Amount |
| F | Date paid |
| G | Status |
| H | Days to pay |
Formulas (row 2)
D2 =C2+30 (net-30 terms)
G2 =IF(F2<>"","Paid",IF(TODAY()>D2,"Overdue","Open"))
H2 =IF(F2="","",F2-C2)
Summary formulas
Outstanding =SUMIF(G2:G1000,"<>Paid",E2:E1000)
Overdue =SUMIF(G:G,"Overdue",E:E)
Paid this month =SUMIFS(E:E,F:F,">="&EOMONTH(TODAY(),-1)+1,F:F,"<="&EOMONTH(TODAY(),0))
Avg days to pay =AVERAGE(H:H)
Income by client =SUMIFS(E:E,A:A,"Client name",G:G,"Paid")
Add conditional formatting to colour "Overdue" red, and you have an at-a-glance collections list.
Tax set-aside
Add a cell for the percentage you set aside for taxes and multiply it by "Paid this month". The right percentage depends on where you live and your income, so check with a tax professional.
Want it ready to use?
The Freelance Client & Income Tracker ($9) includes client totals (invoiced, paid, owed), invoices that mark themselves Open, Overdue or Paid, a time log that pulls each client's rate, and a dashboard with income by month, expenses, net and a tax set-aside at your percentage. It comes in Excel, Google Sheets and Notion versions. Get it with the trading journal in the Template Bundle ($15).
Record-keeping template, not tax or accounting advice.
