Customer Ledger
Track invoices, payments and running balance for every customer. Free ledger PDF.
In short
A customer ledger is the account of one customer with your business: every invoice, receipt, credit note and debit note in date order, with a running balance showing how much they owe. VyaparKit's Customer Ledger builds it from the documents you have already created, for any date range with an opening balance, and downloads as a PDF you can share when a customer asks for their khata.
Create a Customer Ledger in under a minute
Sign in once with Google or email. Your business name, GSTIN, logo, bank details and saved customers fill in automatically. Download a PDF or share a link on WhatsApp. 3 reports a month are free, forever.
- ✓Beautiful PDF with your logo and details
- ✓GST calculated automatically where applicable
- ✓Saved customers, vendors and items, so no retyping
- ✓Share link with WhatsApp button and UPI QR
- ✓Converts to related documents in one click
About the customer ledger tool
A customer ledger (the khata, or party account) answers the question every business owner gets asked: how much do I owe you, and how did you arrive at that. It lists each transaction with a customer in date order, debits for invoices and debit notes, credits for receipts and credit notes, and a running balance after each line. Wholesalers, distributors, agencies and anyone who sells on credit lives by it; even a shop that gives udhaar to regulars needs a clean version when the customer disputes a figure or a CA asks for confirmation of balances at year end.
A ledger kept in a notebook or Excel has three recurring problems. Invoices get missed because they were made in a different file, payments are entered against the wrong invoice, and the opening balance at the start of the year is a number nobody can trace. When the customer's own accounts show a different figure, the argument takes an afternoon. VyaparKit posts every invoice, payment receipt, credit note and debit note to the customer's account as you create it, so the ledger is a report, not a data-entry job, and every line links to its document.
The ledger works together with the other receivables tools. The Outstanding Statement shows only the unpaid invoices with ageing, the Payment Due Slip gives the customer a UPI QR for the balance, and the Payment Reminder drafts the WhatsApp message. Ledger and outstanding reports are limited to 3 a month on Free and unlimited on Pro.
How to get a customer ledger in VyaparKit
- 1
Create documents against saved customers
Add a customer once with name, GSTIN and address, then make invoices, receipts and credit notes for that customer. Each one posts to their account automatically.
- 2
Open Customer Ledger and pick the customer
Go to Ledger, then Customer Ledger. Choose the customer and the date range, for example 1 April to today for the current financial year.
- 3
Check the opening balance
The balance as on the day before your range is shown as Opening balance. If you moved to VyaparKit mid-way, record the earlier balance so the ledger starts from the right number.
- 4
Read the running balance
Each line shows the document number, date, debit or credit and the balance after it. Click any line to open the invoice or receipt behind it when a customer asks about a specific entry.
- 5
Download and share
Click Download PDF to send the statement on WhatsApp or email, or use it as the year-end balance confirmation your CA asks the customer to sign.
What a customer ledger should contain
- Customer name, address and GSTIN, and your business details from the profile, so the statement is identifiable on both sides.
- The period covered and the opening balance as on the first day of that period.
- One line per transaction with date, document type and number (INV/26-27/0042, RCT/26-27/0017), a short narration and the debit or credit amount.
- Invoices and debit notes as debits (customer owes more); payment receipts and credit notes as credits (customer owes less).
- A running balance after every line, and a clear closing balance, marked Dr if the customer owes you.
- Totals of debits and credits for the period, which should reconcile: opening + debits - credits = closing.
- Cheque or UPI reference on receipt lines, so the customer can match them to their bank statement.
- Date of generation and a note that the balance is subject to reconciliation, if you are sending it for confirmation.
Who uses the customer ledger
Distributors and wholesalers
A FMCG distributor in Patna with 80 retailers pulls a ledger before the salesman's weekly visit, so collections happen against the exact invoices that are open and disputes are settled with the document in hand.
Kirana stores running udhaar
A general store gives credit to two dozen households. Instead of a bahi-khata that only the owner can read, each family gets a monthly ledger PDF on WhatsApp showing their purchases and payments.
Agencies and freelancers with retainers
A digital marketing agency in Pune bills monthly and gets paid in irregular lumps. The ledger shows the client exactly which months are paid and what the balance is, ending the monthly email thread.
CA firms at year end
A CA asks the client for ledgers of the top 20 customers to send balance confirmation letters. The client downloads them in minutes rather than reconstructing them from invoices.
Customer Ledger: frequently asked questions
- What is the difference between a customer ledger and an outstanding statement?
- The ledger shows every transaction with the customer in a period, paid or not, with a running balance. The outstanding statement lists only invoices that are still unpaid, with how many days each is overdue. Use the ledger to reconcile and settle disputes; use the outstanding statement to chase collections.
- What is opening balance in a customer ledger?
- It is the amount the customer owed you (or you owed them) at the start of the period shown. For the financial year that is the balance on 1 April, which is the previous year's closing balance. If you started using VyaparKit after that date, record the balance carried over from your old books so the running balance is correct from the first line.
- Which documents change a customer's balance in VyaparKit?
- Invoices and debit notes increase what the customer owes. Payment receipts and credit notes reduce it. Quotations, estimates, sales orders and delivery challans do not touch the balance because no money is due on them; the balance moves only when the challan or order is converted into an invoice.
- How do I handle a customer who says their books show a different balance?
- Send them your ledger PDF for the period and ask for theirs. Differences are almost always a payment they made that you recorded against another customer, an invoice they never received, or a credit note for returns that one side did not book. Match line by line from the last agreed balance; the ledger's document numbers make this quick.
- Can I keep a customer ledger for cash sales too?
- You can, but it is rarely useful. A cash sale is invoiced and paid at the same moment, so the ledger would show a debit and a credit of the same amount on every line. Save customers and run ledgers for credit customers, and bill walk-in cash sales to a generic cash customer.
- Is a customer ledger valid proof of debt if I need to go to court or MSME Samadhaan?
- The ledger itself is your own record; what carries weight is the trail behind it: signed invoices, delivery proof, the customer's acknowledgements and a balance confirmation they signed. A clean ledger with document numbers helps you assemble that trail quickly. For any recovery action, consult a lawyer or your CA.
Guides from the blog
Financial year-end closing checklist for small businesses: what to do by 31 March
A March 31 checklist covering stock count, debtor and creditor confirmations, TDS matching with 26AS and AIS, GST reconciliation with GSTR-1, 3B and 2B.
Read the guide →
MSME Udyam registration: 2025 limits, free steps and the benefits you get
The revised micro, small and medium limits, free Udyam portal registration, the 45-day payment rule, collateral-free loans, tender preference and subsidies.
Read the guide →
Bank reconciliation guide: match your books with the bank statement every month
Why your cash book and bank balance differ, a step-by-step monthly bank reconciliation, uncleared cheques, bank charges, UPI settlement timing and a ready template.
Read the guide →