How Should You Track Customer Advances Against Invoices?

Keep one main row for each receipt, even when a party makes several payments for the same order. Use a separate adjustment log when one receipt covers several invoices. This keeps the original receipt visible while allowing each use of the money to be checked.

• Customer account, receipt identifier, receipt date, amount and bank reference.
• Order, booking or purpose, supported by the customer's instructions.
• Each invoice number and the amount applied against it.
• Each refund amount, payment reference and approval.
• Unused balance, status, next action and person responsible.

Use consistent customer account names. Similar trading names are not enough to justify a match. Keep unidentified bank receipts on a separate list until you can establish who paid and why.

1. Confirm that the receipt exists in the bank record and has been entered only once in the books.
2. Check the customer account, order reference and any instructions about how the payment should be used.
3. Confirm the invoice is valid, belongs to that account and still has an unpaid balance.
4. Choose an adjustment no greater than either the available advance or the invoice balance.
5. Record the receipt-to-invoice link and adjustment amount. Update both balances together.
6. Check the customer statement before requesting any further payment.

Do not automatically apply money to the oldest invoice when the customer has specified another order. If instructions are unclear, leave the balance available and obtain clarification. For an advance covering several invoices, record a separate adjustment for each invoice.

Illustrative example only: a customer pays Rs 60,000 before invoicing. You later apply Rs 35,000 to one invoice and Rs 15,000 to another. The customer then requests a refund of the remaining Rs 10,000, which you approve and pay. The table tracks the receipt; it does not calculate revenue or tax.

Suppose invoice B totals Rs 22,000. Applying Rs 15,000 leaves Rs 7,000 to collect against that invoice. Send a statement showing that calculation. Do not ask for the full invoice amount, and do not record the Rs 15,000 adjustment as fresh cash received.

Keep three questions separate: what money arrived, what invoice balance it settled, and what revenue belongs in the accounts. Your advance schedule answers the first two. It should not decide revenue merely because money arrived or an adjustment was entered.

Have your accountant confirm the revenue policy and ledger treatment under the accounting framework applicable to your business. Once agreed, use that treatment consistently instead of treating both the receipt and the invoice as separate sales.

Where accounting software already maintains customer advances, use the schedule as a supporting record. Check a sample receipt through the bank entry, customer account, invoice adjustment and statement. Avoid entering a second transaction merely to make a spreadsheet agree.

Before approving a refund, check the unused balance, customer request and agreed terms. Reserve the approved amount so it cannot also be applied to an invoice. Keep a pending refund separate from a paid refund until the payment is confirmed.

• For a paid refund, retain the approval and bank reference, then reduce the available advance.
• If money was already applied, review and reverse the relevant adjustment before treating it as available for refund.
• For a known customer with no matching invoice, record the reason, next action and person responsible.
• For an unidentified payer, retain the bank reference and investigate without guessing the customer account.
• For an old balance, review the order history and correspondence. Do not clear it merely because it has remained unused.

Verify refund instructions through a known customer contact, especially when bank details change. Any cancellation charge, disputed balance or proposed write-off needs separate approval and accounting review.

Reconcile the schedule using: opening unused advances plus new advances, less invoice adjustments, less paid refunds, plus or minus documented corrections, equals closing unused advances. Track approved but unpaid refunds within that closing balance as reserved amounts.

• ✓Match new receipts and paid refunds to the bank reconciliation.
• ✓Match every adjustment to a receipt and an invoice.
• ✓Compare the closing schedule with the corresponding balances in the books.
• ✓Investigate negative advances, excess invoice adjustments and unexplained differences.
• ✓Review unmatched receipts, unused balances and pending refunds with a named person responsible.
• ✓Check customer statements show both invoice dues and available advances clearly.

Use this alongside the monthly bank reconciliation guide and the receivables collection routine guide. The Finance Operations guides bring these checks into a broader monthly routine.

• Recording an advance again when it is applied to an invoice, inflating collections.
• Hiding unused advances by netting them against unrelated invoice dues.
• Moving money between customer accounts without documented authority.
• Deleting an incorrect adjustment instead of recording a traceable reversal.
• Treating an approved refund as paid before confirming the bank movement.
• Treating every customer credit as an advance; credit notes and other credits need their own explanation.