VThe Vera Standard

Freelancer year-end records checklist

Who it is for: freelancers, consultants and other one-person service businesses that bill clients by invoice and want their year's records in one place before the new year starts.

It is not the right fit if you need:

  • payroll for staff;
  • stock or inventory tracking;
  • a bookkeeping system shared by several people;
  • someone to tell you what to file or claim.

This is not tax advice; check what applies to you.

The checklist

  1. List every client you billed this year. One name per client, spelled the same way each time.
  2. Gather every invoice you sent. Put them in date order. Mark each one paid, part-paid or unpaid.
  3. Match payments to invoices. For each payment that reached your bank or payment app, note the date, the amount and the invoice it settles. Note any fees the payment service took off.
  4. Chase or note what is still unpaid. Write down each unpaid invoice, its age and the date you last asked.
  5. Gather your business costs. Receipts and statements for what you paid for the work: software, equipment, travel, subscriptions. Keep the receipt with the entry.
  6. Note business miles. Date, trip and miles for each business drive, kept the same way all year.
  7. Keep personal and business apart. If one account holds both, mark each business line clearly so the totals are clean.
  8. Sort costs into a few plain groups. Use the same groups all year (for example: software, equipment, travel, other). Keep it short.
  9. Total the year. Add up invoiced, received, still unpaid, and costs by group. Put the totals on one page.
  10. Check the totals against the bank. The money received should match what reached your accounts, after fees.
  11. Note any forms or statements you received. If a client or platform sent you a year-end statement, file it with the year and note its total next to yours. If they differ, find out why. This is not tax advice; check what applies to you.
  12. Save the year in one folder. Invoices, receipts, statements and the one-page totals, named by year. Keep a second copy somewhere safe.
  13. Start next year's list now. Carry over unpaid invoices and repeat clients so January starts clean.

An example (made-up names and figures)

Amount
Invoiced this year$48,200
Received$45,700
Still unpaid (2 invoices)$2,500
Payment service fees$610
Costs: software$1,140
Costs: equipment$1,890
Costs: travel$720

The two unpaid invoices are the ones to chase now, not in spring.

Keep it in one workbook

The Solo Business Records Workbook keeps clients, invoices, payments and costs in one place and adds up the year for you. It works in Google Sheets and Excel.

See the Solo Business Records Workbook