Free Excel Customer Deposit & Balance Tracker
Download a free Excel worksheet that separates the deposit requested, payments received and the full remaining balance. Enter confirmed cumulative receipts; the shaded columns calculate what is still unpaid.
Download free templateSign in, review and save a reusable form. No customer records or completed spreadsheet rows are imported.
What’s included
- Order reference
- Customer
- Order total
- Requested deposit
- Deposit due
- Received so far
- Unpaid deposit
- Remaining balance
- Balance due
Includes 100 working rows, one clearly labelled example, and shaded calculation columns. Open in Excel or import the workbook into Google Sheets.
How to use it
- Enter the order reference, customer and final agreed total. Keep one currency per workbook.
- Enter the requested deposit and due date. The requested amount is not a payment.
- Update Received so far with the cumulative confirmed payments for that order. Do not add the requested deposit to it.
- Review the shaded calculation columns. Negative balances indicate overpayments that need review; they are not hidden.
Example: a requested deposit is not money received
Illustrative order total: 200.00. Requested deposit: 80.00. Keep one currency per workbook. These are successive updates to one order, not separate charges.
| Stage | Received so far | Unpaid deposit | Remaining balance |
|---|---|---|---|
| Before payment | 0.00 | 80.00 | 200.00 |
| Partial deposit received | 30.00 | 50.00 | 170.00 |
| Deposit received in full | 80.00 | 0.00 | 120.00 |
| Order paid in full | 200.00 | 0.00 | 0.00 |
After receiving 30.00 and then another 50.00, enter 80.00 in Received so far. The unpaid deposit is now zero, while 120.00 remains on the full order. Recording a requested deposit as received would make the remaining balance misleading.
Before you rely on the record
- Agree on the deposit amount and due date with the customer.
- Check the actual payment receipt before updating the file.
- Use the cumulative amount received for that order.
- Review overpayments and corrections instead of hiding a negative balance.
Does this collect a payment or send a reminder?
No. It records payments handled elsewhere and calculates balances. Use your payment provider to charge customers and confirm receipts before updating this file.
Can I use it for my own business?
Yes. Download, edit and use these templates for your own business. Keep files containing customer information somewhere private. No account or email address is required to download.
What is the difference between unpaid deposit and remaining balance?
Unpaid deposit is the part of the requested deposit still missing. Remaining balance is the full order total minus confirmed receipts. An order can have no unpaid deposit and still have a remaining balance.
Does this template take payments or send reminders?
No. It is a separate record-keeping file. Your payment provider handles the charge, and you arrange any customer follow-up.
Can I record more than one payment?
Yes. Update Received so far with the cumulative confirmed amount. Keep the individual transaction references in your payment records so you can reconcile the total.