Customer advance payment tracking means recording a deposit against the right customer, applying it to later bills and keeping any unused amount visible. Record the money once; settling a bill with that advance does not mean receiving the money again. This guide covers a simple register, a worked example and the steps in Yojika.
Customer advance payment tracking starts with a named record
When a deposit reaches your bank but the order stays on a loose slip, it is easy to overlook the payment at collection.
This is useful preparation for festival pre-orders. Incredible India lists Navratri from 11/10/2026, so early October is a sensible time to organise customer deposits before collections become busy.
Keep these details in your advance register:
| Detail | What to record |
|---|---|
| Customer | Name and a contact detail that distinguishes similar names |
| Receipt | Actual date, amount, payment method and receiving account |
| Evidence | Your receipt reference and the payment transaction reference |
| Purpose | Order reference, goods requested and agreed collection details |
| Application | Bill number and amount of advance used against it |
| Remainder | Amount still unused, with a note of the agreed next action |
Confirm payment arrived before recording it. Keep order changes and cancellation terms with the order record; an order note alone does not prove payment.
For money collected after a credit sale, use the separate guide to tracking udhaar digitally. Here, the starting point is money received before the bill.
Separate receipt, bill and allocation
These are three different events:
- Receipt: money comes in. Record the actual amount and date once.
- Bill: record the goods sold at their full billed value.
- Allocation: apply some or all of the existing advance to that bill’s balance.
An advance is a payment towards the bill, not a discount on the goods. Do not reduce item prices merely to make the amount due equal the customer’s final payment.
Use two checks:
Unused advance = original advance − amounts already allocated, assuming no refund or correction.
Amount due on a bill = bill total − advance allocated − other payments against that bill.
Do not change the original receipt amount just because the eventual bill is smaller.
Worked example: a Pune shop’s pre-order
Consider an illustrative household-goods shop in Pune. A customer pays a confirmed UPI advance of ₹3,000 on 03/10/2026. There are no earlier dues or other payments.
The customer later collects goods on two bills. These are assumed final bill totals, including any applicable tax; the example demonstrates payment allocation, not a product’s GST rate.
| Event | Fresh money received | Advance used | Advance remaining | Due on that bill |
|---|---|---|---|---|
| Advance received | ₹3,000 | — | ₹3,000 | No bill yet |
| First bill: ₹2,200 | ₹0 | ₹2,200 | ₹800 | ₹0 |
| Second bill: ₹1,500 | ₹0 | ₹800 | ₹0 | ₹700 |
| Customer pays the second bill’s balance | ₹700 | — | ₹0 | ₹0 |
The bills total ₹2,200 + ₹1,500 = ₹3,700. Actual money received is ₹3,000 + ₹700 = ₹3,700. Allocating ₹2,200 and ₹800 creates no additional collection.
Assume these are ordinary taxable sales by a GST-registered supplier in Maharashtra, with place of supply also in Maharashtra. They use CGST and SGST, consistent with CBIC’s supply FAQ, question 85. Confirm the current rates for the actual items with your CA; the deposit does not determine the tax split.
Record and settle an advance in Yojika
The advances and settling guide describes the current workflow:
- Open the customer’s ledger from Parties, then select On-account.
- Choose Received. Enter the amount, method and actual receipt date, and check the receiving account. Add a reference and useful notes.
- Save with Record. The advance is now held against that customer.
- Create the later sale against the same customer. Do not enter the old advance again as a fresh payment on the bill.
- Find the advance in the party’s advances list and select Settle.
- Review the amounts against the open bills, then confirm the settlement.
The settlement screen lists open bills oldest first and prefills allocations. Check those suggestions, especially if the deposit was intended for a particular order and the customer has older unpaid bills. Adjust the amounts to match the agreed use of the deposit.
The screen shows how much is left to allocate. One advance can cover several bills, and a remainder can stay available for later. Settled bills have their due amounts and payment status updated.
Review unused deposits and cancellations
At closing, check unused advances for goods awaiting collection, bills needing settlement and changed orders.
A customer’s overall balance and their unused advance answer different questions. They may have both unpaid bills and an unallocated receipt. A net balance alone does not tell you which order has been paid for.
If an order is cancelled, keep the original receipt, cancellation agreement and evidence of any actual refund together. Have your accountant confirm the required adjustment and documentation. Do not delete a real receipt just to hide the unused balance, or record a refund before money has actually been returned.
Keep GST documentation separate from payment allocation
For registered persons, Section 31(3)(d) addresses documenting an advance through a receipt voucher or another document containing the prescribed particulars. See CBIC’s CGST Act, Section 31. A payment entry inside billing software is bookkeeping; do not assume that entry alone supplies every required GST document.
GST timing also needs a separate check. CBIC lists Notification 66/2017-Central Tax for relief on advances for goods in its central tax notifications. Services have their own time-of-supply provisions under Section 13. Confirm the current rule on gst.gov.in or with your CA for your registration and supply type, including cancellations; do not assume that goods-advance treatment applies to a service booking.
Frequently asked questions
What is an unallocated customer advance?
It is money received from a customer that has not yet been applied to a bill. Keep it against that customer’s name until you allocate it or resolve it through an agreed refund.
Should I record another receipt when I use an advance?
No. Applying an existing advance to a bill uses money already recorded. Record a new receipt only for fresh money actually received.
Can one advance pay several bills in Yojika?
Yes. Use Settle from the party’s advances list and check the amount assigned to each open bill. You can leave part of the advance unallocated for later.
Is the unused advance the same as the customer’s net balance?
Not always. A customer can have both unpaid bills and an advance that has not been allocated. Check the individual bills, unused advance and overall party balance together.
Try the workflow before the next collection
Yojika’s on-account payments and settlement help you keep customer deposits connected to their bills. Explore the features, or download Yojika to try recording an advance and applying it to a later bill in a test business.