Small business outsourcing workflow guide
Build a customer deposit reconciliation sheet for an assistant-run shop
A customer deposit reconciliation sheet that helps an assistant-run shop match each deposit to an order, refund, or credit and keep the balance visible.

Key takeaways
- Write the deposit amount, refund rule, and approver before taking the first payment.
- Link every deposit to one order and record the payment reference at intake.
- Match deposits to final invoices and keep refunds, credits, and forfeits separate.
- Reconcile open deposits with the payment tool and bank statement every week.
Write the deposit rule before the first payment
A deposit reconciliation sheet begins with the written rule the shop uses for deposits. State which products or services require a deposit, how the amount is calculated, and what the deposit is applied to. Record whether the deposit is refundable and under what conditions it is returned. Name the person who may approve an exception and the date the rule took effect. A deposit that exists only in a counter conversation cannot be reconciled later.
Give the assistant one approved sentence for explaining the deposit to a customer. The sentence should cover the amount, the cancellation window, and how the deposit will appear on the final invoice. Do not let staff invent a refund promise that the written rule does not support. If the shop takes deposits for repairs, special orders, and events, name each case and keep the rules apart. A customer should be able to repeat the rule back after one conversation.
Capture each deposit with a link to the order
Record the deposit at the moment it is taken and link it to a specific order or job number. Capture the customer, the amount, the payment method, the date, and the staff member who received it. Note the reference number printed on the receipt or shown in the payment tool. Write the order number on the deposit record before the customer leaves. An unlinked deposit becomes a balance that nobody can explain.
Record the deposit type as refundable, non-refundable, or applied to a future balance. Keep the customer's stated reason for the order in the same entry so a later question has context. If the customer pays in cash, record the drawer or till that received it. If the deposit arrives by transfer, record the reference and the date it cleared. The entry is not complete until the payment can be traced to one order.
Match the deposit to the final invoice
Match each deposit to the final invoice and record the date the match was made. Show the invoice total, the deposit applied, and the remaining balance in one row. Record who performed the match and where the supporting invoice is stored. Do not apply a deposit to a different order without a dated note and an owner approval. A match that cannot be rebuilt from the records is only a guess.
When a deposit exceeds the final invoice, record the refund or the credit and the method used. When the invoice exceeds the deposit, record the balance due and when the customer was told. Note any partial application and the reason the rest was held back. Keep the original deposit amount visible even after it is fully applied. The history should show the whole path from payment to settlement.
Record refunds and credits as separate outcomes
Record a refund, a credit, and a forfeited deposit as three different outcomes with their own dates. State the rule that allowed the outcome and the person who approved it. Record the refund method and the date the money left the business. Keep the customer notice beside the outcome so the reason is documented. Deleting a deposit record hides the decision that was made.
If the customer moves a deposit to a later date, record the new order and the new hold period. Do not carry the old date silently, because a second move may exceed the rule. If the shop keeps a cancellation fee, record the fee and the net amount returned. Tell the customer what remains on account in one short message. The balance should be clear to the customer and to the bookkeeper.
Review open deposits every week
Review open deposits every week for age, missing order links, and deposits that were never applied. Count how many deposits are older than the written policy allows and who owns each one. Look for one payment method or one staff member with repeated mismatches. Record the review date and the decision for each open item. A weekly review keeps an old deposit from becoming a write-off.
Compare the deposit total in the sheet with the payment tool and the bank statement. Record any difference and the date it was resolved. Remove personal payment details that the retention rule no longer requires. Share a short summary with the owner and keep the detail with the records. Change one part of the routine at a time so the next review can tell what helped.
Sources and next steps
- Internal Revenue Service, Publication 583, starting a business and keeping records
- U.S. Small Business Administration, manage your business
- U.S. Government Accountability Office, internal control standards
- Federal Trade Commission, mail, internet, or telephone order merchandise rule
Compare this workflow with the small-business outsourcing service guides and bring a redacted source record to the scoping call.
Related guides
Set a daily cash drawer variance review for an assistant-run shop
A daily cash drawer variance review that helps an assistant-run shop count consistently, record differences, and separate a counting error from a missing payment.
Build a special-order lead time confirmation record for an assistant-run shop
A special-order lead time confirmation record that helps an assistant-run shop quote a realistic date, record the supplier answer, and tell the customer before payment.