For solo freelancers

Know who owes you, and what you're working on.

One spreadsheet for your clients, projects and invoices. Type an invoice and the overdue ones light up.

Download the free sample .xlsx · Excel, Numbers, Google Sheets
clientbook-sample.xlsx
InvoiceClientAmountStatus
1001Example: Fern & Co1,200.00Paid
1002Example: Northgate750.00Overdue
1003Example: Fern & Co600.00Sent
Owed1,350.00
DashboardClientsProjectsInvoices

What you get

Four sheets that work together. You type clients, projects and invoices; the rest works itself out.

SheetYou typeIt works out
ClientsName, contact, notesProjects, invoiced, paid and owed per client
ProjectsClient, status, dates, feeWhat is invoiced and what is left to invoice; late due dates turn red
InvoicesNumber, client, project, date, amount, paid-on dateDue date, Sent, Paid or Overdue, and days late
DashboardNothingOwed, overdue, active projects, fees not yet invoiced, and money in per month

Room for 200 clients, projects and invoices. Change your payment terms in one cell and every due date follows.

Try the real file

  • A real spreadsheet, not a picture: open it and type over the example rows
  • Works offline in Excel, Numbers or Google Sheets
  • No account, no subscription

A record-keeping template for your own use. It does not give tax, legal or accounting advice.