Customer Credit Ledger - Track Who Owes You with Printable Statements (Excel & Google Sheets)
Sell on credit without losing track. See who owes you, how much, and how long since they last paid.
What's inside:
- Customers: balance, last payment date and days since payment calculate automatically
- Status for every customer: OK, Overdue, Over limit, No payment yet or Clear
- Credit limits per customer, with over-limit alerts in red
- Ledger: record credit sales and payments in one place
- Printable account statement with running balance for any customer
- Dashboard: total owed, overdue customers and top 10 balances
Details:
- Room for 200 customers and 1,000 entries
- Any currency
- Works in Microsoft Excel and Google Sheets
- Formulas are protected so they can't be broken by accident
Who it's for: shops, wholesalers and traders who give customers credit.
Licence: for use by one business. Please don't share or resell the file.
Questions? Message me through this shop and I'll help.