Customer Credit and Debt Ledger (Excel Template)

Stop losing money to goods sold on credit. See who owes you, how much, and who to call today.

This Excel workbook keeps a clean record of every customer's credit and payments. Add the customer once, log each credit and each payment, and the balance works itself out.

What you get:

Customers sheet: total credit, total paid, balance owed, last payment date and days since last payment for every customer.

Automatic status for each account: Current, Follow up, OVERDUE or Settled. You choose the number of days for Follow up and OVERDUE.

Total owed to you, the number of customers owing and the number of overdue accounts, all at the top of the sheet.

Credit Given sheet: log goods or services given on credit, with a customer drop-down.

Payments sheet: log money received, with the payment method (Cash, MoMo or Bank).

Space for 300 customers and 2,000 entries on each sheet.

A filled-in example copy, so you can see how it works before adding your own customers.

A Start Here sheet with step-by-step instructions.

Works in Microsoft Excel 2010 or later, LibreOffice and Google Sheets. Amounts show in Ghana cedis (GHS). Instant download after payment.