The easiest way for a UK freelancer to see true outflow is to treat client costs as a float: money you lend to the client for a while. Record it in its own place, and your own spending stays clean. When the client repays, the float returns to zero.
What is a float, in practice?
It is a running total of client costs you have paid and not yet recovered. Imagine you pay £48 for train tickets and £120 for materials for a client. Your float is £168. You invoice it, and when £168 arrives it clears.
How do I set it up in a sheet?
Make columns for Date, Description, Amount, Type and Client. Type holds one of: Personal, Float-out, Float-in. A float-out is the cost you paid; a float-in is the repayment.
| Date | Description | Amount | Type |
|---|---|---|---|
| 4 Mar | Train tickets | 48 | Float-out |
| 6 Mar | Materials | 120 | Float-out |
| 9 Mar | Supermarket | 62.50 | Personal |
| 22 Mar | Client repayment | 168 | Float-in |
To total what is outstanding, assume amounts are in C2:C500 and types in D2:D500. In Excel or Google Sheets:
- Float paid out: =SUMIFS($C$2:$C$500, $D$2:$D$500, "Float-out")
- Float repaid: =SUMIFS($C$2:$C$500, $D$2:$D$500, "Float-in")
- Outstanding: the first cell minus the second.
- Personal spend: =SUMIFS($C$2:$C$500, $D$2:$D$500, "Personal")
With the rows above, paid out is 168, repaid is 168 and outstanding is 0. Personal spend is £62.50, which is the figure your budget should see.
Should I use a separate card for client costs?
If you can, yes. A second card or account used only for client costs means the statement itself is the float record, and your main account never shows them. If that is not possible, tags do the same job with more discipline.
What if a client pays late or in part?
Record each part payment as its own float-in row with the date. If a client pays £100 of £168, outstanding is £68. The sheet shows it, and you chase just that.
When does a sheet stop being enough?
When you have many clients and hundreds of lines, filtering by hand gets slow. SpendixAI, built around India and INR and not offered here as a promise for the UK, tags business versus personal, keeps receipts with transactions, and exports filtered lists. Look for those features in whatever you choose.
How do I keep the float honest over several months?
The danger of a float is forgetting that it exists. Once a month, list the outstanding total and compare it with your invoices. If the outstanding figure is £168 and the invoices you sent total £168, the float and the paperwork agree. If they do not, a cost has not been billed, or an invoice has not been paid.
It also helps to give yourself a ceiling. Decide the most you would be comfortable having tied up in client costs, say £400, and pause fronting for a client who keeps pushing past it. Ask for a deposit, or have them pay the supplier directly.
What should I do about small cash costs?
Cash is where floats leak. A £6 parking ticket paid in coins leaves no line on any statement. Make a rule that every cash cost for a client gets a row in the sheet the same day, with a photo of the ticket or receipt. If there is no receipt, write a short note saying what it was, who it was for and the date. Small gaps in a record are what clients question first.
If you find yourself using cash often for client costs, move those costs to a card instead. The statement then does the recording for you.
Your monthly close
- Total float paid out and float repaid.
- Chase anything outstanding for longer than usual.
- Check personal spend against your budget.
- Archive the receipts.
Tax and other rules are outside this article. For what you may record and keep, ask your accountant or the official source.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


