Client ledger: meaning, format, example and template
A client ledger is the record of every transaction between your business and one client — what you sold or billed them, what they paid, and the balance left after each entry. Each client has its own ledger (also called a client account, customer ledger or ledger card), and the closing balance tells you at a glance how much that client owes you. Below: what a client ledger looks like, the format to use, a filled-in example, a template you can copy into Excel, and the apps that keep one for every client — including Account Ledger by Ofisx on iPhone.
Short answer
- Meaning: a client ledger is one client's running account — every charge, payment, credit and the balance after each line. The total of all client ledgers equals your accounts receivable.
- Format: Date · Reference · Description · Debit (charges) · Credit (payments and credits) · Balance, under a header with the client's name, account number, terms and credit limit.
- Template: a sheet per client in Excel or Google Sheets with a running-balance formula works for a few clients (layout below).
- Software: QuickBooks, Wave and Zoho Books keep a ledger per customer inside full accounting books; Account Ledger by Ofisx keeps a client and supplier ledger on the iPhone and sends the balance or a PDF statement by WhatsApp.
- Law firms note: in legal trust accounting, a "client ledger" is a sub-ledger of money held in trust for each client. That is a regulated record with its own rules — use trust-accounting software for it, not the tools on this page.
What a client ledger is
Think of it as one page per client in an account book. Every time you sell on credit, the client's balance goes up (a debit to their account); every time they pay, return goods or receive a credit note, it goes down (a credit). The last figure in the balance column is what the client owes you today.
The client ledger answers questions a single invoice cannot: How much does this client owe in total? When did they last pay? Are they paying their old invoices or only the new ones? Should I give them more credit?
Client ledger format
A client ledger has a header that does not change and a body with one line per transaction:
| Part | Field | Why it is there |
|---|---|---|
| Header | Client name, contact, address | Who the account belongs to |
| Header | Account number | Separates two clients with similar names; quoted on payments |
| Header | Payment terms and credit limit | Net 30, credit limit $5,000 — the rules for this client |
| Header | Opening balance and date | Where the ledger starts (for example, carried over from last year) |
| Body | Date | One line per transaction, in date order |
| Body | Reference | Invoice, delivery note, receipt or check number |
| Body | Description | "Invoice — materials", "Payment — ACH", "Return" |
| Body | Debit | Amounts that increase what the client owes (sales, charges) |
| Body | Credit | Amounts that reduce it (payments, credit notes, returns, discounts) |
| Body | Balance | Previous balance + debit − credit, after every line |
Client ledger example
Client: Mason Roofing · Account C-0214 · Terms Net 30 · Credit limit $5,000
| Date | Reference | Description | Debit | Credit | Balance |
|---|---|---|---|---|---|
| Sep 1 | — | Opening balance | $1,800.00 | ||
| Sep 25 | INV-1036 | Invoice — shingles and underlayment | $2,350.00 | $4,150.00 | |
| Oct 6 | PMT-0905 | Payment — check 4471 | $1,800.00 | $2,350.00 | |
| Oct 9 | RET-0019 | Return — 3 bundles unused | $150.00 | $2,200.00 | |
| Oct 20 | INV-1063 | Invoice — flashing and fasteners | $2,400.00 | $4,600.00 | |
| Oct 27 | PMT-0931 | Partial payment — bank transfer | $400.00 | $4,200.00 | |
| Totals · balance owed | $4,750.00 | $2,350.00 | $4,200.00 |
Check: opening $1,800 + debits $4,750 − credits $2,350 = $4,200. Of that, $1,800 is left from INV-1036 (due Oct 25, so 6 days past due on Oct 31 — after the return and the $400 partial payment) and $2,400 is INV-1063 (due Nov 19). The client is $800 under their $5,000 limit, so the next large order on credit is worth a conversation first.
This is the same client that appears in the accounts receivable aging example; a statement of account is simply this ledger for one period, sent to the client.
Client ledger vs. general ledger vs. sales ledger
| Client ledger | Sales ledger / AR subsidiary ledger | General ledger | |
|---|---|---|---|
| Covers | One client | All clients together | All accounts of the business |
| Shows | Each sale, payment and balance for that client | Every client's balance; the total equals accounts receivable | Assets, liabilities, income and expenses; AR appears as one line |
| Used for | Collecting, credit decisions, statements | Checking the AR control account, aging | Financial statements and tax |
| Kept by | Whoever sells and collects | Bookkeeper or accounting software | Bookkeeper or accountant |
The supplier side works the same way: a vendor (supplier) ledger for each supplier, adding up to accounts payable. Small businesses that sell and buy on credit usually keep both.
Client ledger template for Excel or Google Sheets
- Rows 1–4: client name, account number, terms, credit limit.
- Row 6: headers Date | Reference | Description | Debit | Credit | Balance.
- Row 7: the opening balance in F7.
- Row 8 onward: in F8 enter =F7+D8-E8 and fill down; the last filled cell in column F is the balance owed.
- Below the table: totals with =SUM(D8:D500) and =SUM(E8:E500), and a check cell =F7+SUM(D8:D500)-SUM(E8:E500) that must equal the last balance.
- One tab per client, plus a summary tab that pulls each client's last balance — that summary is your accounts receivable list.
Weak points: inserting a row above the formula breaks the running balance, a payment entered on the wrong tab moves money between clients, and with dozens of clients the workbook becomes hard to keep current. Those are the usual reasons to move to software.
Ways to keep client ledgers compared
| Option | Best for | Client ledger kept as | Sharing the ledger with the client | Platforms | US App Store ratings (Oct 21, 2026) |
|---|---|---|---|---|---|
| Account Ledger by Ofisx | Small businesses that sell and buy on credit and record it on the phone | One card per client and supplier: sales and purchases on credit, payments, partial payments, returns, running balance | PDF statement per client; balance and reminders via WhatsApp; export to Excel | iPhone (US App Store); Android on Google Play in Turkey only | New in the US store — no ratings yet |
| Intuit QuickBooks | Businesses whose books are in QuickBooks | Customer register inside full accounting books | Customer statements by email or print | iPhone, Android, web | 273,010 ratings, 4.7 |
| Wave | Very small businesses that invoice every sale | Customer activity built from invoices and payments in Wave | Customer statements by email, print or link | iPhone, Android, web | 6,665 ratings, 4.4 |
| Zoho Books | Small businesses keeping full books in Zoho | Customer transactions inside full accounting books | Customer statements by email or PDF | iPhone, Android, web | 5,264 ratings, 4.8 |
| Excel / Google Sheets template | A handful of clients | One tab per client with a running-balance formula | Print or save as PDF | Any computer | — |
The options in detail
Account Ledger by Ofisx
Account Ledger keeps a client ledger for every customer and a vendor ledger for every supplier, with invoice and tax details on the card. Each sale on credit, collection, partial payment or return goes in as one line and the balance updates itself; due-date alerts flag what is coming up or overdue. You can share a client's ledger as a PDF statement or send the balance and a reminder by WhatsApp, and export everything to Excel for your accountant.
It is a ledger app, not full accounting software — no general ledger, payroll or tax returns — and it is not built for legal trust accounting.
Intuit QuickBooks
In QuickBooks every customer has its own transaction history (invoices, payments, credit memos) inside the books, and the A/R reports add them up. Best when your accountant already uses QuickBooks.
Wave
Wave builds each customer's activity from the invoices and payments you record in it and can send customer statements. Its free starter plan covers invoicing and bookkeeping.
Zoho Books
Zoho Books shows each customer's transactions and balance and produces statements for any period, as part of a full accounting package.
Excel / Google Sheets template
Free if you already have Excel or Google Sheets, and you decide the layout. Use the template steps above and keep the check cell so a broken formula shows up immediately.
How to keep a client ledger
- Open the ledger with a balance and terms — Enter the client's details, payment terms and credit limit, and the opening balance on a clear date. Everything after that is a transaction line.
- One line per transaction, the same day — Sales on credit, payments, returns and credit notes — each with a reference — on the day they happen.
- Debit up, credit down — Charges go in the debit column, payments and credits in the credit column. Never type a negative number in the debit column to record a payment.
- Check the balance against the total — Opening balance + total debits − total credits must equal the last balance. If it does not, a formula or an entry is wrong.
- Share it monthly — Send the client their ledger for the month as a statement of account and ask them to report differences.
- Use it before giving more credit — Before a new order on account, look at the balance, the oldest unpaid line and the date of the last payment.
Limits — what Account Ledger does not do
- Account Ledger is not full accounting software: no general ledger, payroll, bank feeds or tax returns, and it is not designed for law-firm trust (IOLTA) client ledgers.
- Statements are shared as a PDF per account in the app's own layout, not a template with your own columns.
- In the US the app is on the App Store for iPhone; the Android version is on Google Play in Turkey only for now.
- It is a paid subscription after the free trial; the App Store shows current plans and prices.
Frequently asked questions
What is a client ledger?
A client ledger is the record of all transactions with one client — charges, payments, returns and credits — with a running balance that shows how much the client owes at any date.
What does a client ledger look like?
A header with the client's name, account number, terms and credit limit, then a table with Date, Reference, Description, Debit, Credit and Balance columns, one line per transaction and the balance owed at the bottom.
What is the difference between a client ledger and a general ledger?
A client ledger covers one client's account. The general ledger covers every account of the business; all client ledgers together add up to the single accounts receivable line in the general ledger.
Is a client ledger the same as a customer ledger or sales ledger?
Client ledger and customer ledger mean the same thing. "Sales ledger" usually means the set of all customer ledgers (the accounts receivable subsidiary ledger).
How do I make a client ledger in Excel?
Put the client details at the top, headers Date, Reference, Description, Debit, Credit, Balance in row 6, the opening balance in F7, and =F7+D8-E8 in F8 filled down. Add totals and a check cell, and keep one tab per client.
What is a client ledger in a law firm?
In legal trust accounting, a client ledger records money a lawyer holds in trust for a specific client, and it must reconcile with the trust bank account. That is a regulated record; use trust-accounting software for it rather than a business ledger app.
Is there an app for client ledgers on iPhone?
Yes. QuickBooks, Wave and Zoho Books keep customer transaction histories inside accounting software. Account Ledger by Ofisx keeps a ledger per client and supplier with a running balance, PDF statements and WhatsApp reminders, with a free trial and then a subscription.