How to Track Customer Deposits and Remaining Balances
Keep deposits, instalments and outstanding balances connected to the right order. Includes a worked example and a payment reconciliation checklist.
Product guide from the team behind OrderTracker. Examples are illustrative, not customer results.
Attach every payment to a unique order or invoice number. Record the date, amount, payment method and reference, then subtract verified payments from the agreed total to calculate the balance due.
Watch the short demonstration.
Record a payment received elsewhere and review the updated order balance. Payment recording does not charge a customer.
Video transcript & stepsReal app screens · illustrative records · AI narration · Playing loads YouTube.
Record the agreement before the payment
Before a job begins, confirm what the customer is buying, the agreed total, when payments are due and what happens if the scope changes. A deposit percentage is a business decision; there is no single percentage that suits every job. Make the agreed arrangement visible on the quote or invoice rather than relying on a message you may struggle to find later.
Use the same order reference when you record a bank transfer, cash payment or payment processed elsewhere. A payment note without a matching order is difficult to reconcile once several customers pay similar amounts.
Worked example: three payments on one order
Suppose the agreed invoice total is $480, including any applicable charges already shown on the invoice. The customer pays $120 to begin, $200 at a milestone and $160 at completion.
| Event | Payment recorded | Balance remaining |
|---|---|---|
| Order confirmed | $0 | $480 |
| Initial deposit received | $120 | $360 |
| Milestone payment received | $200 | $160 |
| Final payment received | $160 | $0 |
Record each payment once. Do not enter the $120 deposit again when preparing the final invoice. A processor payout can combine payments and deduct fees, so its net amount is not necessarily the amount the customer paid on a particular invoice.
A useful payment record
- Order or invoice reference.
- Date the payment was actually received or confirmed.
- Amount and currency.
- Method, such as bank transfer, cash or a payment provider.
- Transaction or receipt reference.
- A separate note for any refund, adjustment or unresolved discrepancy.
Keep sensitive card details out of notes. A transaction reference is enough for finding the payment in the system that processed it.
Reconcile before following up
Check your bank or payment-provider record before telling a customer they have not paid. A transfer may have arrived under a different name. A payment might be pending, allocated to another order or already refunded. Resolve the mismatch first, then update the order’s balance.
A neutral follow-up can be brief: “Hello [name], our records show [amount] remaining on order [reference], due [date]. If you have already paid, please send the payment reference so I can match it. Thank you.” Adjust it to the agreement you actually made; do not invent late fees or new terms after the fact.
Use OrderTracker as the operational record
OrderTracker lets you record payments against orders and review outstanding balances in the customer profile. Keep payment status separate from production status: a fully paid job may still need to be made, and a completed job may still have a balance.
Free, Pro and Business Growth do not include customer card-payment connections. This guide describes recording and reconciling payments you receive through your existing methods. OrderTracker’s own Pro subscription checkout is a separate service. Do not treat recording a payment as actually charging a customer.
For the wider workflow, read how to track customer orders. For cost and margin decisions, see the job profitability example. Deposit accounting and tax treatment depend on your circumstances; confirm those with your accountant.
Common questions
Does recording a payment charge the customer?
No. A manually recorded payment documents money received through another method. Check the actual bank or provider transaction before marking it received.
Is a deposit the same as profit?
No. Cash received, revenue and profit are different measures. A deposit can arrive before the work is completed, and profit also depends on the costs of doing the job.