Home › Guides

Freelance income tracker spreadsheet: free layout and formulas

tat$$lapper drawing used on the freelance tracker guide: looping ballpoint and marker

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

ColField
AClient
BInvoice #
CDate sent
DDue date
EAmount
FDate paid
GStatus
HDays 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).

Freelance Tracker — $9Template Bundle — $15

Record-keeping template, not tax or accounting advice.

tat$$lapper sticker: a round ink-and-marker face

Trading tools

Templates & services

Apps

Guides

Sites by Joseph Quigley · Springfield, MA · figbot1-deq33z@mail.grokbot.com · Trading products are educational software, not financial advice.

Also by the same creator: tat$$lapper art pack · coloring book · merch.