Download a ready-to-use Excel template with formulas, per-customer statements and automatic reporting. Free, no signup.
.xlsx file · 4 sheets with formulas · Works with Excel and Google Sheets
List your customers with phone, credit limit, auto-calculated current balance and status (OK / at limit / over).
Log each credit sale: date, customer, item, amount, paid yes/no, notes. Formulas update automatically.
Track every partial payment customers give you, with date, method and receipt reference.
Totals for outstanding credit, payments received, net balance and top 10 debtors. All SUMIF formulas ready to go.
Amounts are already formatted as Mexican pesos. You just type the number.
Open the file and you immediately see how it works. Delete the examples whenever you want.
Click the button above. You get an .xlsx file you can open with Excel, Google Sheets or LibreOffice.
Go to the 'Clientes' sheet, delete the examples, and add each customer with their phone and credit limit.
Every time you give credit, log it in 'Ventas a crédito'. Leave 'No' in the Paid column until they pay you.
When they pay, record it in 'Pagos recibidos'. The customer's balance and the report update on their own.
This template is perfect if you have 10–40 credit customers and you handle them yourself. But once you spend hours typing, things slip through, you have more than one cashier, or you want the customer to get an automatic WhatsApp reminder when their balance is high — a real system starts making sense. Genesis Business has POS with credit tracking, accounts receivable, customer reminders and reports, with no spreadsheets.
See Genesis for grocery storesLeave your email and we'll send you info about Genesis — POS with credit tracking, WhatsApp reminders to customers and automatic reports.