Matching customer and supplier accounts: why and how

Quick answer. Account matching links each invoice to its payment within a third-party account (411 for customers, 401 for suppliers) by assigning them the same letter code. Whatever stays unmatched flags an unpaid invoice, a forgotten credit note or a posting error. The French accounting records file has formalised it since the decree of 29 July 2013 through two dedicated fields.

Matching is the operation of reconciling, within an auxiliary account, an invoice with the payment that settles it. In practice, you assign the same letter (A, B, C...) to the sales invoice and to the matching receipt. The two lines cancel each other out and drop off the outstanding balance.

Its value goes well beyond accounting tidiness. A matched customer account tells you, in a second, what has been collected and what has not. Everything that remains unmatched becomes a to-do list: chase, post a credit note, correct an allocation. That reading is exactly what turns matching into a cash-flow steering tool rather than a mere bookkeeping chore.

In the French general chart of accounts, customer receivables are tracked in account 411 and supplier payables in account 401. Matching applies to these third-party accounts, line by line, party by party. It complements the work of bank reconciliation, which checks account 512 (the bank): the two are distinct but feed one another.

The confusion is common. Ticking off means visually flagging the lines you believe are settled, with no structured trace in the software. Matching, by contrast, writes a code into the entry: it is traced, auditable and reversible.

This distinction carries a precise tax consequence. The accounting records file (FEC), which every business keeping computerised accounts must be able to hand over to the tax authority, contains 18 fields defined by the decree of 29 July 2013 and article A47 A-1 of the French tax procedures code. Two of these fields relate directly to matching: EcritureLet (the letter code) and DateLet (the matching date). In other words, your matching is not an internal habit: it is readable inside the accounting records file (FEC) submitted during an audit.

The logic is identical for a customer and a supplier: only the direction of the entry changes. Here is the sequence we apply in our files.

1. Open the auxiliary account to match. Display the third party's account (one 411 sub-account per customer, one 401 sub-account per supplier), filtering on unmatched lines only.
2. Link each invoice to its payment. Reconcile by amount and date. Invoice and payment of the same amount get the same letter and leave the outstanding balance.
3. Run automatic matching on concordant amounts. The software processes exact, to-the-cent matches in seconds.
4. Manually match partial reconciliations. Deposits, grouped payments, instalments: group several lines under one letter, after posting any gap.
5. Analyse the entries left unmatched. Every old line tells a story to be clarified.
6. Identify unpaid items and gaps to handle. Turn the unmatched balance into reminders, transfers to doubtful customers or corrections.

Automatic matching excels on standard flows: one invoice, one transfer of the same amount. It runs out of steam as soon as a discount, bank fees withheld by the customer, a single payment covering several invoices or a partial credit note appear. Manual matching then takes over.

Our reading. The right instinct is not to choose one over the other, but to chain them. You first run the automatic pass to absorb 80 to 90% of the lines, then devote human judgement to the remaining 10 to 20%, which are precisely the ones hiding the unpaid invoices and errors. Modern tools such as Pennylane or document capture through Dext smooth this step by reconciling invoice and payment from the moment of entry.

Matching keeps a few situations that deserve an experienced hand.

• The partial payment. You do not match a half-settled invoice. The line stays open until the balance is covered, otherwise you mask a receivable still due.
• The credit note. A credit note must be matched with the invoice it cancels or reduces, never left floating alone in the account.
• The supplier account in debit. A 401 account showing a debit balance (you overpaid or a credit note is missing) often signals a double payment: matching reveals it.
• Exchange differences. For a party invoiced in foreign currency, the difference between the invoicing rate and the collection rate is cleared by a foreign-exchange gain or loss entry before closing the letter.
• Campaign accounts. Structures subject to a specific external review, such as the accountant for campaign accounts, benefit directly from flawless matching, which evidences the fate of every expense and every receipt.

A poorly matched auxiliary account creates very concrete year-end risks.

The underestimated risk. A receivable you believe lost does not turn into a deductible loss by a mere internal decision. The loss on an irrecoverable receivable is posted to account 654, and reclaiming the VAT initially collected requires, under article 272 of the French tax code, proving the definitively irrecoverable nature, notably by sending the debtor a duplicate of the invoice bearing the reference to that article. Clean matching is the starting point of that demonstration: without it, you cannot isolate the receivable concerned.

Two further prudence reflexes:

• Watch the limitation period. Article L110-4 of the French Commercial Code sets a five-year window to act on a receivable between merchants: an unmatched line left dormant too long can become legally irrecoverable.
• Before providing, isolate the doubtful receivable in account 416, then record the depreciation by debiting account 68174 against account 491. That is the sequence any sound debt recovery process assumes.

Recently, the director of a services company sought us out because his cash position never matched his reported turnover. Opening his 411 accounts, the diagnosis was obvious: hundreds of unmatched lines, payments allocated to the wrong customer, credit notes never applied. The customer balance on the balance sheet was overstated by tens of thousands of euros through entries that cancelled out in pairs without ever having been reconciled.

The re-matching work surfaced reality: part of those receivables had already been collected, another part was genuinely unpaid and called for immediate reminders. Simply matching turned an unreadable sub-ledger into a recovery action plan.

That is the whole point. Matching is not a year-end chore, it is the basic hygiene of accounts that mean something. An up-to-date third-party account makes the balance sheet reliable, speeds up the close and, when a statutory auditor steps in, spares them from raising an anomaly on balances you could have justified yourself. The boundary of missions between statutory auditor and chartered accountant changes nothing here: a matched account is an account you can defend. This is a requirement we uphold, as a firm registered with the French Institute of Chartered Accountants, across every bookkeeping and accounts review engagement.

Hayot Expertise tip. Do not let matching pile up until the close. A monthly rhythm, backed by digitalising your finance function and regular reminders, prevents the snowball effect. The sooner you spot an unpaid invoice, the sooner you can automate customer reminders and protect your cash.