Payment tracking
How to track client payments online
Most billing problems are memory problems. Here is what to record for every client and every payment so that "who owes me what?" takes five seconds to answer instead of an evening.
If you bill clients directly, you already track payments somehow. It might be a spreadsheet, a notes app, a folder of invoices, or a reasonably confident memory. The question is not whether you track them — it is whether you can answer, right now and without opening your bank statement, exactly how much each client still owes you.
That answer gets harder for a specific reason. Money almost never arrives in the shape the agreement described. A fee agreed as one figure turns up as an advance, a milestone payment, and a final amount weeks later. Each arrival is easy to note at the time and easy to forget a fortnight afterwards.
This guide covers what to record, how to structure it so the balance stays correct on its own, and the handful of habits that make the difference between a record you trust and one you double-check.
Start with the agreed fee, not the invoice
The first number to write down is the total you and the client settled on for the piece of work. Everything else is measured against it, so it needs to be recorded before any money moves — not reconstructed later from whatever you happened to invoice.
Recording the fee up front matters more than it sounds. If you only record invoices, a client who has been invoiced for half the project looks like they owe half the project, when in fact you are carrying the other half unbilled. The agreed fee is what you are owed overall; invoices are how you ask for portions of it.
Record each payment as its own entry
This is the single structural decision that determines whether your tracking survives contact with reality. There are two ways to record money arriving. You can keep a running "paid so far" figure and edit it each time, or you can add a new entry for each payment and let the total be calculated.
The running total is faster to set up and worse in every other respect. It loses the history, so you cannot see how a balance got to where it is. It cannot be audited, so a typo is invisible and permanent. And when a client queries the figure, you have nothing to show them beyond your own assertion.
Separate entries cost you a few extra seconds each and give you a record that explains itself. Three fields are enough:
- The amount — what actually arrived, not what was expected. A short payment is a short payment, and rounding it up in the record means chasing a balance that does not match your bank.
- The date it arrived — the date the money landed, not the date you typed it in. Set it explicitly so that catching up on a week of entries still produces a correct timeline.
- A note — optional but worth it. "Advance on signing", "milestone 2", "settled in cash". In three months this is what tells you whether a $10,000 payment covered what you think it did.
With those three, the paid total and the outstanding balance are derived rather than maintained. There is no figure to keep in sync, which means there is no figure that can quietly drift.
Make the balance something you read, not something you calculate
The outstanding balance is the agreed fee minus everything recorded as paid. That arithmetic is trivial; the value of a tracking system is that you never have to do it. Whatever tool you use, the outstanding figure should be visible at the top of the client record and should be produced from the entries beneath it.
Watch out for a subtle failure here. If the summary number is typed in by hand and the entries are kept separately, the two will eventually disagree, and the one you quote to a client will be the wrong one. A system where the summary is computed from the detail cannot have this problem.
It is also worth deciding in advance what happens when a client overpays. The sensible behaviour is for the balance to stop at zero rather than go negative, and for the surplus to be shown separately as a credit — a negative balance in a list of receivables is confusing every time you see it.
Keep one view that covers every client
Per-client records tell you about one client. The number you actually want most mornings is the total across all of them: how much is out there, and who is behind.
A useful overview has three properties. It totals the agreed, collected and outstanding amounts across every client. It lets you filter down to the clients who are not fully paid, because that is the list you act on. And it is quick enough to open that you actually look at it, rather than reconstructing it when something goes wrong.
The habits that keep it accurate
Record on a fixed rhythm
Once a week is enough for most small businesses. Open your bank statement, find the payments that arrived since last time, and enter them with their real dates. Fifteen minutes, and the record never falls far enough behind to feel like a project.
Enter the fee when you agree it
Not when you invoice, and not when the work starts. The moment a number is settled, it belongs in the record — that is the moment you are least likely to misremember it.
Fix errors by correcting entries
If a payment was recorded twice, remove one. Do not adjust another entry to compensate. The point of a per-entry record is that it can be read back, and a compensating adjustment destroys that.
Check the total against your bank monthly
Not a full reconciliation — just confirm that what you think arrived this month roughly matches what did. Discrepancies found within a month are usually explainable; found within a year, they are usually not.
What tracking does and does not change
It is worth being honest about this, because a lot of billing software is not. Tracking payments does not make clients pay faster. It does not recover anything by itself, and any tool promising a recovery rate is quoting a number it cannot possibly know about your business.
What it changes is narrower and genuinely useful: you find out immediately who is behind rather than eventually, and when you follow up you can state the exact figures instead of approximating. A request that names the work, the agreed fee, the amount received and the precise balance is much harder to set aside than one that says "just checking in on the invoice".
That is the whole proposition. Umikflow is built around it: record the fee, log the payments, read the balance, and follow up with a message that already contains the numbers. If you want to see the shape of it, payment tracking covers how entries and balances work, and how it works walks through the whole sequence.
Do this in Umikflow
Umikflow is a billing workspace for tracking client fees, payments and outstanding balances, with WhatsApp reminders and A4 invoices built in.
