Free tool

Customer credit book free Excel template

Write down every credit sale and every payment. The sheet adds up what each customer still owes your shop.

DateCustomerPhoneWhat they tookCredit givenPayment received
4 MarFlat 30205x xxx xxxxGroceries86.50

Example row only. The file you download is empty and ready to use. A second sheet adds up what each customer still owes and the total owed to the shop.

  • •One row for every credit sale and every payment.
  • •List your credit customers once on the Balances sheet.
  • •See who owes what before you give more credit.
Download free Excel template

Works in Excel, Google Sheets and Numbers. No signup, no email.

Want this done for you every day, without a sheet? Ask for a quick demo for your shop on WhatsApp.

Ask for a demo on WhatsApp

How to keep a customer credit book

Giving credit to regular customers is part of running a neighbourhood shop. The family in the next building pays at the end of the month, the cafeteria takes supplies on account. It keeps customers loyal, and it quietly loses money when the record is a notebook that is hard to add up, or the owner's memory.

This credit book has two sheets. On the first you write one row for every credit sale and one row for every payment: the date, the customer's name, their phone number, what they took and the amount. Always use the same name for the same customer, such as their flat number or shop name, so the amounts are added together correctly.

On the second sheet you list each credit customer once. The sheet then shows their total credit, total payments and what they still owe, plus the total owed to the shop by everyone. That last number is your own money sitting in other people's pockets, and most owners are surprised by it the first time they see it.

Use the balances before you give more credit, and send a polite reminder when a balance has been open for too long. Agree a limit with each customer and keep to it. If you would rather not maintain a sheet, Tallium AI records credit sales at the till, keeps each customer's balance and shows who is overdue.

Frequently asked questions

Stop juggling spreadsheets. Tallium AI runs invoicing, VAT & corporate tax, POS and inventory in one simple app.

More free tools

See all free tools