In this free credit ledger you list your customers once, then record each transaction as "credit given" or "payment received". Each customer's total credit, total payments, balance due and last transaction date are calculated automatically. Balances older than 30 days turn red, so you know whom to call first.
The biggest problem with a paper credit book is that one customer's entries spread across many pages. Adding up who owes what at month-end takes time, and old balances get missed.
On this page
How to use it
- In the Customers sheet, enter each customer's name and phone once. Do not repeat a name; add an area if needed (e.g. "Rahim, Bazar Road")
- In the Transactions sheet, enter the date, pick the customer from the drop-down and put the amount in the right column
- Go back to the Customers sheet to see balances; collect the red ones first
A few rules that reduce bad debts
- Set a credit limit for each customer and stop new credit once it is reached
- Once a week, call or message everyone on the red list
- Message the customer the amount when you give credit; it avoids arguments later
- Record old balances that will never be collected separately; they are a loss in your profit calculation
For wholesale and distribution businesses
With many customers, or when collections must be matched to invoices, Excel becomes hard. Then you need books with party ledgers and an ageing report. See monthly bookkeeping, or for complete shop accounts the Excel ERP.
Frequently asked questions
Can I track what I owe suppliers too?
Take a copy and put supplier names in place of customers. Record purchases in the credit column and payments in the payments column.
Can the 30-day limit be changed?
Yes. Edit the conditional formatting rule on column E of the Customers sheet and replace 30 with your number.
What if I have more than 200 customers?
Drag the formulas in the last row down to add more rows.
Talk to us about your accounting work
The first conversation is free. You get a written price and timeline before any work starts.
Related pages
Daily shop accounts in Excel: free template
Daily sales, credit, purchases, expenses, cash in hand and monthly profit.
Excel ERPExcel ERP: shop accounting in Excel
Sales, purchases, stock, dues and P&L in one Excel file. For small shops, BDT 2,999.
Free templatesSavings group (samity) accounts in Excel: free template
Member savings, loans, instalments, service charges and a group summary.
Written by the EOMS Hisab accounts team. Last reviewed: . Bangladesh rules change with each Finance Act, SRO and circular. Check rates and thresholds against the latest official source before relying on them.