Back to the subscription dictionary

Customer receivables ledger

A customer receivables ledger records customer accounts, master details and associated financial entries. It can include zero-balance accounts, receivables and customer credit balances. An accounts receivable overview is instead a report of selected balances and open items at a particular date.

Prepared with AIContent updated

Master data and transactions

Each customer account has a stable ID and relevant details such as name, address, currency and payment terms. Invoices, credit notes and receipts link to it through traceable references. The exact functions depend on the accounting system.

Three account states in one ledger

Illustrative accounts; different balances need different follow-up.

Customer A
£500 receivable from the customer
Customer B
£0 after full settlement
Customer C
£100 credit in the customer’s favour

A zero or credit balance does not mean the account or history should be deleted.

An account is more than an unpaid invoice

A customer can have paid every invoice and still have an account. An overpayment or credit note can create a credit balance requiring allocation or refund. Do not simply delete an account and its history when the balance reaches zero; relevant retention rules still apply.

Allocation and reconciliation

Allocate receipts to the right invoices. Handle partial payments and credits without creating duplicates. Reconcile relevant customer balances to the general ledger and document corrections rather than hiding history.

Ledger, CRM and subscription system

CRM supports relationships and sales follow-up. The receivables ledger focuses on customer accounting, while the subscription system can supply active contract value and effective termination dates. Integrate using matching customer IDs, while assigning an authoritative source for each field.

Reports with a clear scope

Use open-item and ageing reports for follow-up. DSO is a ratio using defined receivables and credit sales, not necessarily the actual average payment time. Balances can inform cash forecasts, but do not guarantee collection and must not be equated with MRR.

Questions and answers

Does the ledger contain only unpaid invoices?

No. It contains customer accounts and their financial history. A report can filter to open items without being the entire ledger.

How does it differ from CRM?

CRM supports relationships and sales; the receivables ledger supports accounting, balances and allocation. They can be integrated or part of the same product.

Can a customer have a credit balance?

Yes, for example after an overpayment or an unallocated credit note. Investigate the reason and arrange allocation or refund as appropriate.

Sources and documentation

We update our content regularly and do our best to keep it accurate. If you find an error or think something is missing, please tell us. We are always looking for ways to improve the content.

Found an error? Let us know