A sales ledger system records the transactions and balances of individual credit customers. In a modern accounting system, it normally operates as a subsidiary ledger within the wider accounts receivable process. When a sales invoice, customer receipt, credit note or write-off is entered, the customer account and the relevant general-ledger accounts are updated together.
This guide explains the complete sales-ledger process, the accounting entries created at each stage, the controls needed to keep the records reliable and the reports managers use to collect cash and monitor credit risk.
What Is a Sales Ledger?
The sales ledger is the detailed record of amounts owed by credit customers. Each customer has an individual account showing invoices, receipts, credit notes, discounts, adjustments and the closing balance. The combined total of all customer balances should agree with the trade receivables control account in the general ledger.
The sales ledger is therefore different from the revenue account:
- Revenue records the value of sales recognised during the period.
- Trade receivables records the amount still owed by all credit customers.
- The sales ledger explains the trade receivables balance customer by customer.
Main Documents and Data Used by the System
A reliable process begins with accurate source data. Common inputs include:
- approved customer master-file details;
- sales orders and credit approvals;
- delivery notes or evidence that a service was supplied;
- sales invoices;
- customer remittance advice and bank receipts;
- credit notes for returns, allowances or pricing corrections;
- approved bad-debt write-offs; and
- journal entries for authorised corrections.
In an integrated system, the same transaction can update the customer account, the general ledger, inventory records, tax records and management reports automatically. The objective is to capture the transaction once, validate it and use it consistently throughout the system.
Sales Ledger Process: Step by Step
1. Create and approve the customer account
Before credit is granted, the business should create a customer master record. Typical fields include the customer name, billing address, tax information, credit limit, payment terms, contact details and a unique account code.
Good controls separate the authority to create or amend customer records from the authority to approve credit limits. Duplicate customer accounts and unauthorised changes can lead to billing errors, fraud and poor debt collection.
2. Receive and authorise the sales order
The business checks the order against product availability, prices, customer terms and the available credit limit. An order should not proceed automatically when the customer is over the approved limit or has seriously overdue balances unless an authorised person approves the exception.
3. Supply the goods or service
A delivery note, dispatch record, customer acceptance or other evidence confirms that the business has performed the relevant obligation. This step matters because an invoice should not be raised merely because an order exists.
4. Generate the sales invoice
The invoice normally includes the customer code, invoice number, date, description, quantity, price, taxes, payment terms and total amount due. The system should use sequential invoice numbers so that missing or duplicated invoices can be investigated.
For a simple credit sale of $1,000, excluding sales tax, the accounting entry is:
| Account | Debit | Credit |
|---|---|---|
| Trade receivables | $1,000 | — |
| Revenue | — | $1,000 |
The customer’s individual account is debited by the same amount. In most computerised systems, these updates occur automatically when the invoice is posted.
5. Record customer receipts
When cash is received, the receipt should be matched to the correct customer and, where possible, to specific invoices. For a receipt of $1,000:
| Account | Debit | Credit |
|---|---|---|
| Bank | $1,000 | — |
| Trade receivables | — | $1,000 |
The receipt also credits the individual customer account. Unidentified receipts should be investigated promptly rather than left indefinitely in a suspense account.
6. Process credit notes and returns
A credit note reduces the amount owed by the customer. It may arise from returned goods, damaged items, overcharging or an agreed allowance. A credit note of $200 normally creates:
Debit sales returns or the appropriate revenue adjustment $200
Credit trade receivables $200
Credit notes should be independently authorised because they can be used to conceal theft or remove genuine debts from customer accounts.
7. Record discounts and other adjustments
Settlement discounts, bank charges, exchange differences and corrections must be recorded with clear references and approval. The correct accounting depends on the nature of the adjustment and the applicable accounting policy.
8. Review overdue balances and expected credit losses
The ageing report groups unpaid balances by the time outstanding, for example current, 1–30 days overdue, 31–60 days overdue and more than 90 days overdue. Credit-control staff use it to prioritise collection activity and identify disputed or high-risk balances.
Financial reporting may also require an allowance for expected credit losses. The allowance is not the same as deleting a customer invoice. The detailed ledger should continue to show the customer balance until it is paid, credited or formally written off.
9. Reconcile the sales ledger
At each reporting date, the total of the individual customer balances should be reconciled to the trade receivables control account. Differences may arise from:
- transactions posted to the general ledger but not to a customer account;
- transactions posted to the wrong customer;
- duplicate or omitted entries;
- unallocated cash;
- incorrect opening balances; or
- unauthorised manual journals.
The reconciliation should be prepared and reviewed by people who are independent of cash handling and routine invoice processing where staffing permits.
Worked Customer Account Example
Assume that Customer A has an opening balance of $300. During the month the business issues invoices of $1,200, records a credit note of $100 and receives cash of $900.
| Item | Effect on amount owed | Running balance |
|---|---|---|
| Opening balance | $300 | $300 |
| Sales invoices | +$1,200 | $1,500 |
| Credit note | −$100 | $1,400 |
| Cash received | −$900 | $500 |
The customer’s closing balance is $500. That amount should be included in the total sales-ledger balance and the trade receivables control account.
Important Sales Ledger Controls
- unique customer codes and controlled master-file changes;
- credit-limit approval and overdue-account blocks;
- sequential invoices and credit notes;
- three-way agreement between order, delivery evidence and invoice;
- restricted access to credit notes, write-offs and manual journals;
- daily or frequent posting of receipts;
- bank reconciliation and review of unallocated cash;
- monthly customer statements;
- sales-ledger-to-control-account reconciliation; and
- review of aged balances, disputes and unusual adjustments.
Key Reports Produced by the Sales Ledger
Common outputs include customer statements, ageing reports, overdue-account lists, credit-limit exception reports, transaction histories, cash-allocation reports and reconciliation reports. Managers may also monitor days sales outstanding, collection effectiveness, disputed balances and the proportion of debts more than 90 days overdue.
Common Errors to Avoid
- treating the sales ledger as the same thing as the revenue account;
- raising invoices before goods or services are supplied;
- posting a receipt without identifying the customer;
- using credit notes to correct errors without proper authorisation;
- ignoring differences between the subsidiary ledger and control account;
- leaving old customer master records active without review; and
- assuming system automation removes the need for human review.
Frequently Asked Questions
Is the sales ledger a debit or credit ledger?
Individual customer accounts normally carry debit balances because customers owe the business money. Receipts and credit notes reduce those balances.
What is the sales ledger control account?
It is the general-ledger account showing the total amount owed by all credit customers. Its balance should agree with the sum of the individual customer accounts.
What is the difference between brought-forward and carried-forward balances?
The brought-forward balance is the opening amount at the start of the period. The carried-forward balance is the closing amount after the period’s transactions have been recorded.
Does a modern accounting system still need a sales ledger?
Yes. The records may be stored electronically and integrated with the general ledger, but the business still needs customer-level details to manage collections and explain the trade receivables balance.
Related Accounting Guides
- Outputs from a Sales Ledger System
- Source Documents and Books of Prime Entry
- Trial Balance
- Balance Sheet Explained
Conclusion
A well-designed sales ledger system does more than store customer balances. It connects credit approval, order fulfilment, invoicing, cash collection, adjustments, reconciliation and financial reporting. Accurate customer-level records, strong authorisation controls and regular reconciliation help the business collect cash faster and keep trade receivables reliable.
Authoritative references: ACCA — Sales and purchases in a computerised accounting system and ACCA — Computerised accounting systems.
Thanks for the post. I like this because it is very helpful I think. Both receipt book and invoice books In Australia are used for business purposes. These are very important in business because these are the evidence of any kind of business exchange.
ReplyDelete