Customer Ledger Format With Example

A customer ledger is a running account for one customer. Every invoice you raise is a debit, every payment and credit note is a credit, and the last figure in the balance column tells you exactly what they owe today. If a client disputes an amount, the ledger is how you show where the number came from. This guide gives you a clear customer ledger format, a worked example you can check line by line, and the steps to keep it reconciled.

What a customer ledger contains

In bookkeeping terms, each customer ledger is a subsidiary account. The total of all customer ledgers forms the debtors or receivables ledger, and that total should equal the accounts receivable control account in the general ledger. The customer ledger is where detail lives: which invoice, which payment, which credit note.

Entries come from three places:

• Sales invoices, recorded first in your sales register and then posted to the customer's account.
• Payments received, from the cash book or bank statement.
• Credit notes and adjustments, such as returns, discounts or write-offs.

Customer ledger format: columns

Column	What to record
Date	Date of the invoice, payment or credit note
Type	Invoice, Payment, Credit note, Adjustment, Opening balance
Reference	Invoice number, receipt number, credit note number
Description	Short narration, e.g. "Bank transfer, ref BRT-6612"
Debit	Amounts that increase what the customer owes
Credit	Amounts that reduce it
Balance	Previous balance + debit - credit
Dr/Cr	Whether the balance is owed to you (Dr) or by you (Cr)

At the top of each ledger, record the customer's master details: legal name, account code, billing address, contact for accounts payable, tax ID, credit limit and payment terms. Keeping the credit limit visible helps you apply a consistent credit policy before a customer's balance gets out of hand.

Customer ledger example

Customer: Brightwell Cafe, account code C-0107, terms 30 days, credit limit 2,000.00. Period: November 2026.

Date	Type	Reference	Description	Debit	Credit	Balance
01-11	Opening		Balance brought forward (INV-1029)			600.00 Dr
01-11	Invoice	INV-1041	Coffee beans and syrups	540.00		1,140.00 Dr
06-11	Payment	RCPT-221	Bank transfer, settles INV-1029		600.00	540.00 Dr
08-11	Invoice	INV-1044	Paper cups and lids	384.00		924.00 Dr
15-11	Credit note	CN-0013	Damaged carton, against INV-1044		48.00	876.00 Dr
20-11	Payment	RCPT-230	Bank transfer, settles INV-1041		540.00	336.00 Dr
Totals for November				924.00	1,188.00	336.00 Dr

Check: opening 600.00 + debits 924.00 - credits 1,188.00 = 336.00. That closing balance is exactly what is left of INV-1044 after the credit note: 384.00 - 48.00 = 336.00. When the ledger is clean like this, every balance can be traced to specific open documents, which is what a customer will ask for if they query it.

How to post entries step by step

1. Open the account with the customer's details and any opening balance, listing which invoices make it up.
2. Post each invoice as a debit on its invoice date, using the gross amount the customer must pay (including tax).
3. Post each payment as a credit on the date it reaches your bank. Note which invoices it settles. Matching payments to invoices is the core of cash application.
4. Post credit notes as credits, referencing the invoice they reduce.
5. Post bank charges or short payments carefully. If a customer pays 535.00 for a 540.00 invoice because their bank took a fee, either chase the 5.00 or post a separate adjustment so the reason is recorded.
6. Recalculate the running balance after every line.

Customer ledger in Excel

For a customer ledger format in Excel, put headings in row 1 and the opening balance in G2. From row 3 down, use =G2+E3-F3 in the balance column, where E is debit and F is credit, then fill down. Add a column with =IF(G3>=0,"Dr","Cr") to label the balance side.

If you prefer one sheet for all customers, keep a transaction table with a Customer column, then use SUMIFS to calculate each customer's balance and a filter or pivot table to view one account. Either way, never overwrite old rows; correct mistakes with a new adjusting line so the history stays intact.

Reconciling customer ledgers

Do two checks every month:

• Control check. Add all customer closing balances. The total must equal the receivables figure in your general ledger and the unpaid total in your sales register. A difference usually means a payment posted to the bank but not to the customer, or an invoice entered twice.
• Customer check. For larger accounts, send a statement and ask the customer to confirm the balance. The account statement email templates in our companion guide cover routine, overdue and balance-confirmation versions.

Customer ledgers also feed your accounts receivable aging report, which groups each open invoice by how many days it is past due. In the example above, INV-1044 is dated 8 November with 30-day terms, so on 12 December it would sit in the 1 to 30 days overdue bucket.

Handling tricky entries in the ledger

Part payments

If Brightwell Cafe pays 200.00 towards the 336.00 balance, post a 200.00 credit and note "part payment, INV-1044". The ledger balance becomes 136.00 Dr, and the narration tells anyone reading the account which invoice is still partly open. Do not mark the invoice as paid in the sales register until the full amount arrives.

Payments on account

Some customers send a round amount, such as 1,000.00, without saying which invoices it covers. Post it as a credit with the narration "payment on account, unallocated" and ask the customer for a remittance advice. Until it is allocated, apply it to the oldest invoices first, which is the usual default, and tell the customer you have done so.

Deposits and advances

A deposit received before any invoice is a credit on the ledger, leaving the account in credit until the invoice is raised. Give the customer an advance payment receipt and refer to it on the final invoice so the deduction is clear.

Write-offs

If an invoice will never be paid, post a credit with the narration "bad debt written off, INV-xxxx", approved by the owner or finance manager. The balance is cleared from the customer ledger, and the expense goes to a bad debts account. The steps and tax treatment are covered in our guide to a bad debt write-off.

Interest and late fees

Only post late payment charges if your terms allow them and you actually invoice them. Raise a separate invoice or debit note for the fee so it has its own reference, rather than quietly increasing the balance.

Customer ledger vs sales register

New bookkeepers often wonder why they need both. The sales register is organised by date and answers "what did we sell this month?". The customer ledger is organised by customer and answers "what does this customer owe, and why?". The same invoice appears in both: once as a line in the register, once as a debit in the customer's account. Payments appear only in the ledger (and the cash book), never in the sales register, because a payment is not a sale. Keeping the two separate is what lets you reconcile them: total register sales on credit, less payments and credit notes, should explain the movement in total customer balances for the month.

Variations you may see

Debtors ledger or party ledger

In the UK it is often called the sales ledger or debtors ledger. In India and Pakistan, accountants commonly call it a party ledger, and the same format is used for suppliers (creditors) with the debit and credit sides reversed.

Ledger with invoice-level matching

Some businesses add an "Applied to" column for payments and credit notes, so each one is linked to the invoice it settles. This makes the ledger longer but disputes much shorter.

Multi-currency customers

If you invoice a customer in USD but keep books in another currency, record both the foreign amount and the local amount at the exchange rate used. Differences when payment arrives are exchange gains or losses, not customer short payments.

Common mistakes

• Posting payments to the wrong customer with a similar name. Always use the account code.
• Leaving unapplied credits that make one invoice look overdue while a credit sits unused.
• Deleting lines instead of reversing them.
• Ignoring credit balances. A customer who overpaid is owed money; refund it or agree to apply it.
• Not recording opening balances by invoice, which makes old balances impossible to explain later.

A tidy ledger starts with tidy invoices: clear numbers, dates, terms and totals. You can produce those free in our invoice generator, without creating an account, and download each one as a PDF ready to post to the customer's ledger.