Follow a job from booking to final payment
Give each job a reference. Use it on the quote, deposit request and final invoice. If a client pays by instalments, let each payment reduce the same balance. Save the original invoice when you raise a credit or agree a change to the work.
If you freelance alongside a job, keep employment records apart from the freelance invoices. For agency or platform work, download the settlement breakdown as well as the bank entry. It can explain fees, exchange rates and refunds that a statement alone will never show.
Where did the last £40 go?
Imagine you bill £1,200 for a design project. The client pays a £300 deposit. A platform collects the remaining £900, keeps £40 and transfers £860. Record the invoice, deposit and platform statement together. The client has paid in full, and the £40 belongs in your fee records.
Records to gather
- A list of open projects and invoices still due
- One platform payout with its matching invoice
- Employment paperwork if you also have a salaried job
Questions and answers
Do I need a separate spreadsheet for every client?
One list normally works. Give each invoice a client name, job reference, issue date and payment date. Add a column for part payments if clients pay in stages.
Can I give my accountant a platform total?
Include the export behind it. A single total rarely explains which project a late payment belongs to or which fee was deducted.