Freelance budget spreadsheet: separate invoices from payments

From Sort & Keep, the maker of the linked workbooks. Updated 8 September 2026.

An invoice and a payment answer different questions. An invoice tells you what a client owes. A receipt tells you what has arrived. Keep both dates in your freelance spreadsheet so an overdue invoice cannot disappear inside a monthly total.

Start with one row per invoice: invoice reference, client, issue date, due date and agreed amount. Record payments separately, using the same invoice reference. This lets you record two instalments against one invoice without counting the invoice twice.

Here is a fictional example. It demonstrates record keeping, not a tax calculation or an amount available to spend.

If your invoice amount is in B2 and the total received against it is in C2, =B2-C2 gives the remaining balance. In this example, £2,600 has been invoiced but £1,100 received. Neither figure tells you your profit or your complete cash position.

Now add a dated receipt table. The £300 part-payment belongs against DESIGN-02, with its own payment date. When the remaining £900 arrives, add another receipt rather than overwriting the earlier payment. Keep refunds and adjustments visible too; a negative balance should prompt a check, not be hidden with a formula that always returns zero.

Use a separate cost log for the records you need: date, description, amount and receipt reference. Do not treat a transfer between your own accounts as a new customer payment. If you also keep a personal monthly budget, link to that record without mixing the two sets of totals.

For your weekly check, review overdue balances, add missing receipts and note the next action beside each open invoice. A status such as “part-paid; remaining balance due 12 September” is more useful than “pending”. Update the date only when the actual agreement changes.

You can build this structure in a blank spreadsheet. If you want supplied client, invoice, income and expense records, see the Freelance Command Center. For a separate monthly spending record, start with the Free Budget Tracker. Neither choice replaces your accounting or tax process.