Guides & comparisonsRetail in Morocco

Customer and supplier subsidiary ledgers in Morocco: how to control them

The control account says how much. The subsidiary ledger says who. When the two disagree, something has gone missing.

By BelloCommerce

·

Your customers account shows 480,000 dirhams. That is not the useful question: the useful question is who owes what, and whether the individual accounts add back to that figure. The subsidiary ledger is the detail by party behind the control account, and its first check is that the two agree to the dirham.

Checking customer and supplier accounts party by party
Checking customer and supplier accounts party by party.

The essentials in five points

  • The control account gives a total, the subsidiary ledger the detail. Either one alone supports no action.
  • The first check is that the two are equal. A gap signals an entry posted straight to the control account.
  • A reversed balance is an anomaly: a customer in credit or a supplier in debit always deserves an explanation.
  • Matching is what makes the ledger readable. Without it, a correct balance can hide two errors that cancel out.
  • The check is monthly, not annual: by the close, the explanations have gone.

1. Reconciling the subsidiary ledger to the control account

This is the basic check, and it takes only minutes. It is done both ways, customers and suppliers, at the same date.

  1. Print the customer subsidiary ledger at a given date and total it.
  2. Compare that total to the customers control account in the trial balance.
  3. Do the same for suppliers.
  4. If there is a gap, look for an entry posted straight to the control account with no party code.
  5. Then look for a duplicated party, splitting one balance across two accounts.
  6. Correct at source rather than through an adjusting entry.

A gap between subsidiary ledger and control account almost always has one of two causes: an entry posted to the control account without identifying the party, or a duplicated party. Both are easy to fix in the month they appear, and painful a year later.


2. The six anomalies to hunt

A subsidiary ledger that balances can still be wrong. These six signals deserve an explanation, not an automatic correction.

AnomalyWhat it usually signalsWhat to do
Customer with a credit balanceA deposit received, an unused credit note, or a double paymentIdentify the cause before offsetting
Supplier with a debit balanceA credit note never refunded, or a duplicate paymentClaim it or offset it on the next order
Account with no movement for a yearA residual balance never matched offClear it after justification, never on principle
Two accounts for the same partyA duplicate created at entryMerge and fix the party master data
Balance of a single centimeA rounding difference or a partial paymentMatch and clear the trivial difference
Old invoice still openAn unpaid item, or a payment posted to the wrong partyCheck before treating it as doubtful

The first two lines teach the most. A supplier in debit is money owed to you that nobody is claiming; it is the one line on the ledger where neglect costs cash directly.

3. Matching, without which nothing is readable

Matching means tying each payment to the invoice it settles. It is what separates a balance you understand from one you merely carry.

  • A matched balance explains itself: You know exactly which invoices remain open, and since when. That is what feeds ageing analysis.
  • An unmatched balance lies by omission: An account at zero can hide an unpaid invoice and a payment posted elsewhere that cancel each other out exactly.
  • Partial matching is normal: A deposit payment matches partially. What is not normal is leaving the remainder untracked.
  • Matching is done as you go: Catching up six months of matching at the close takes ten times longer than doing it monthly, for a less reliable result.

A matched subsidiary ledger is what makes possible the ageing analysis set out in receivables and payables control, and then any classification as a doubtful customer.

Never clear a gap with an adjusting entry

The temptation is strong when the subsidiary ledger and the control account do not agree: an adjusting entry makes the gap disappear in thirty seconds. It also makes the information disappear. The gap had a cause — an entry with no party, a duplicate, a misposted payment — and that cause keeps producing errors the following month. Correct at source, always, even when it takes longer.

4. Making it a monthly routine

This check is only worth anything through regularity. Done once a year it records damage; done monthly it prevents it.

  1. Reconcile subsidiary ledger to control account, customers then suppliers.
  2. Print the list of reversed balances and explain each one.
  3. Match the month’s payments while the information is fresh.
  4. Note the accounts with no movement for more than six months.
  5. Clean the party master data: duplicates, inactive parties, stale details.
  6. Keep the list of items already explained, so they are not re-investigated monthly.

That last point saves considerable time. An unusual but explained and documented balance does not need re-investigating at every check; without that note, it goes back into the queue every month.

Mistakes to avoid

  • Never reconciling the subsidiary ledger to the control account.
  • Posting an entry straight to the control account, with no party.
  • Clearing a gap with an adjusting entry.
  • Leaving duplicate parties in the master data.
  • Postponing matching until the annual close.
  • Treating an account at zero as healthy without checking the matching.

Frequently asked questions

What is the difference between the trial balance and the subsidiary ledger?

The trial balance gives the balance of the customers or suppliers control account. The subsidiary ledger breaks that balance down party by party. The total of the second must equal the balance of the first exactly.

Can a customer have a credit balance?

Yes, but it always needs an explanation: a deposit received, a credit note not yet used, or a double payment. It is only an anomaly when nobody knows which of the three it is.

What should be done with a supplier in debit?

Treat it as a receivable: a credit note never refunded or a duplicate payment is money that belongs to you. Claim it or have it offset against a later order, and track it until it clears.

How often should this check be done?

Monthly. That is the frequency at which explanations are still available and corrections still simple. An annual check records gaps nobody can justify any more.

Does BelloPOS keep a subsidiary ledger?

BelloPOS keeps customer records from Lite and customer credit tracking from Go, which gives the detail of customer balances. Supplier accounts belong to the purchases module, also from Go, and accounting journals to Pro. Reconciling to the trial balance is done in the accounts.

What to take away

Controlling the subsidiary ledger comes down to three monthly moves: reconcile the subsidiary ledger to the control account, explain the reversed balances, and match while the information is fresh. It is the least spectacular check in accounting and the one that prevents the most silent errors.

Sources

The figures and rules quoted above come from these pages, read on the date given in the article.

Customer detail, permanently up to date

BelloPOS keeps customer records from Lite and customer credit tracking from Go; supplier purchases and accounting journals follow with Go and Pro.

Read next

Other practical guides on the same subject: