What does matching payments to invoices mean?
Matching payments to invoices means linking every payment you receive to the open invoice it belongs to. The invoice is then no longer open and the customer's balance is correct again. In accounts receivable this is called cash application; others call it payment matching or payment reconciliation.
You can approach it from two sides. From the bank statement, you go through each credit on your account and find the invoice it pays. From the debtor ledger, you look at each customer's open invoices and the payments against them. The aim is the same: every euro on the right invoice, and anything unmatched visibly set aside.
Why does payment matching matter so much in self-storage?
Self-storage runs on lots of small, recurring invoices. Every tenant gets an invoice every month, often for the same amount, and tenants with several units get several. Open items therefore look alike, and a payment without a reference is hard to place.
A payment that has not been matched does not disappear. The money is in the bank, but the invoice stays open. The tenant gets a reminder despite having paid, and your debtor list shows arrears that do not exist. If access to your facility depends on payment status, they may even find the gate closed.
A wrong match is worse still. The customer who did not pay gets no reminder, and the customer who did pay gets one. Two errors from one booking, and neither shows until someone calls.
Where does matching payments to invoices go wrong?
Almost every problem falls into one of these seven situations, whatever system you use.
| Situation | What goes wrong | How to handle it |
|---|---|---|
| No reference | The description is empty or just says 'rent'. | Only match if exactly one open invoice for that customer has exactly that amount. Otherwise ask, do not guess. |
| Wrong reference | A typo, customer number or old invoice number points to the wrong invoice, or to one already paid. | Check that customer, amount and invoice fit together. If in doubt, send it to review. |
| Partial payment | Less paid than the invoice amount. Mark the invoice as paid and the remainder is lost. | Book the amount against the invoice and leave the remainder open. |
| One payment for several invoices | Two months or two units paid in one go. The amount fits no single invoice. | Split the amount, oldest due date first, or as the customer indicates. |
| Overpayment | More paid than is open. The difference drops out of sight. | Allocate what is open and keep the rest as credit. Then decide: offset or refund. |
| Duplicate payment | The same invoice paid twice, for example by payment link and by bank transfer. | Do not book the second payment against a paid invoice. Treat it as credit and contact the customer. |
| Cash or card at the desk | Does not reach the bank statement as a separate payment with a reference. If it is not recorded, the invoice stays open. | Record the payment straight away with its method and invoice number. |
How do you prevent payment matching problems?
Most matching work is created before anything is paid. The better customers know what to put in the payment reference, the less you search afterwards. These habits help most:
- State on every invoice, reminder and email which payment reference the customer should use: the invoice number.
- Send a payment link wherever you can. A payment made through a link for a specific invoice already belongs to that invoice.
- Use one fixed, unique invoice numbering format with a recognisable prefix, so a number cannot be confused with a unit number, a date or an amount. Never reuse numbers.
- Record desk payments straight away, with the method (cash or card) and the invoice number.
- Do not match a cash deposit or a payout from your payment provider against invoices again. The individual payments in it should already be on the invoices.
- Ask business tenants with several units to pay per invoice, or to tell you which invoices a combined payment covers.
Tip: make the reference impossible to miss
Do not just print the invoice number in the invoice header. Put it in the payment instruction itself: 'Payment reference: INV-2026-0912'. Do the same next to every payment link and in every reminder. The more often customers see the number where they pay, the more often it ends up in the description.
Manual or automatic payment matching: what works best?
Manual matching works as long as volumes are small and one person knows the customers. But the knowledge then lives in someone's head, mistakes surface late, and afterwards nobody knows why a payment sits on a particular invoice.
There are two ways to automate it. One guesses: a name that looks similar, an amount that is roughly right. That produces lots of matches, including matches nobody can explain. The other uses fixed rules: only match when it is unambiguous, and send the rest to a review list. For finance, the second is the better choice. A missed match costs a few minutes; a wrong match costs a reminder to the wrong customer and an invoice closed in error.
An example with illustrative figures: a tenant still has September and October open, both €89.00. A payment of €89.00 arrives without a description. Which month is it for? A system that guesses picks one. A rule that demands certainty puts the payment on the review list.
TheStorageControl deliberately takes the rule-based route. You record a received payment with its method (bank transfer, cash or card) and the description or bank reference. If that contains the invoice number, you get a proposal for that invoice, including for a partial payment. Without the number there is only one other route: that customer has exactly one open invoice at that facility with exactly the same amount, to the cent. A similar name or a nearly right amount is never enough. Every proposal shows its reason.
Unclear cases, such as several invoices that fit, an overpayment, a duplicate reference or an invoice that is no longer open, go under 'Needs review' with the reason and are never booked automatically. You check the clear proposals in a preview and process them in one go. A daily automatic run can be switched on; it is off by default. Payments through a Mollie payment link are booked against the invoice once Mollie confirms the payment.
How do you handle partial payments and overpayments?
With a partial payment, you book the amount received against the invoice and leave the remainder open. The invoice is then partly paid and follow-up on the remainder carries on.
If one payment covers several invoices, you split it, usually oldest due date first. If the customer says which invoices they meant, follow that.
A worked example with illustrative figures: a tenant has INV-2026-0868 (September) and INV-2026-0937 (October) open, both €89.00, and transfers €200.00. Both invoices are then paid and an amount is left over.
That remainder is an overpayment. Do not book it against some other invoice; keep it as customer credit. Then decide deliberately, ideally after talking to the customer: offset it against the next invoice or refund it. If you are unsure about the accounting or tax treatment, check with your accountant.
In TheStorageControl the system allocates a combined payment by due date, oldest first, or you assign it invoice by invoice. Anything you do not allocate stays on the customer as credit. The system never books an overpayment by itself; it appears under 'Needs review' first.
Credit after allocation
Credit = amount received − amount allocated to open invoices
Example: Worked example: €200.00 − (€89.00 + €89.00) = €22.00 credit
How does payment matching keep reminders and the debtor list right?
Reminders, ageing analysis and arrears figures all work from what is open. If payment matching is off, the rest is off too.
Pay particular attention to the order. Reminders are often prepared days in advance, and the customer may pay in the meantime. If you only match after the reminder run, you chase invoices that have already been paid. So match before you start a round.
In TheStorageControl an invoice is paid or partly paid as soon as a match is processed. A reminder that was already queued is checked again just before it goes out, and is not sent if nothing is open any more. Every link is in the audit log, so you can trace afterwards which payment went to which invoice. If someone starts the same run twice by accident, it is booked only once.
If you match consistently, your debtor list only shows what is really open.
How often should you match payments? A simple weekly routine
For a small facility, once a week is often enough. With more volume or several facilities, do it more often, or have the clear cases processed daily. The order stays the same:
- Check that every desk payment from that week has been recorded, with method and invoice number.
- Go through the bank statement and record every tenant payment with its full description or bank reference. Skip cash deposits and payouts from your payment provider.
- Process the clear matches: invoice number in the description, or an exact amount that fits exactly one open invoice.
- Work through the review list. Read the reason for each case, make a decision and note why.
- Contact tenants who paid without a reference and ask them to quote the invoice number from now on.
- Decide on open credit balances: offset or refund.
- Only then look at the debtor list and start any reminders.
