To track money paid before delivery, record the booking date, the amount, the order reference, the promised delivery date and a follow-up date, and mark the line Pending until the item arrives. A pending list shows how much of your money is sitting with sellers and when to chase.
Why do advance bookings go missing from your records?
You paid, so the money has left your account, but you have nothing in hand. In many trackers it just shows as an expense, and when the balance is paid at delivery the same purchase is counted twice or the advance is forgotten. A small pending record separates what is paid, what is received and what is still owed.
What should the record contain?
| Field | Example, made up |
|---|---|
| Item | Phone, model as booked |
| Booking date | 3 October |
| Advance paid | ₹5,000 by UPI |
| Order reference | As shown on the confirmation message |
| Promised delivery date | 20 October |
| Follow-up date | 22 October |
| Balance due on delivery | ₹40,000 |
| Status | Pending |
Take a screenshot of the confirmation page or message and keep it with the record. Write down any term you were told about cancellation, refund and date changes, and where it was stated.
How do you show it as pending?
Add a Status column with Pending, Delivered or Cancelled. Keep one row per booking, with the advance amount in a column. To see how much is out with sellers right now, add a formula that sums advances for pending rows. If advance amounts are in column D and status is in column F, rows 2 to 100:
- Total pending advances: =SUMIFS($D$2:$D$100, $F$2:$F$100, "Pending")
- Number of pending bookings: =COUNTIF($F$2:$F$100, "Pending")
With three bookings of ₹5,000, ₹2,000 and ₹10,000 pending, the first formula shows ₹17,000. When one is delivered, change the word to Delivered and the figure drops.
What do you do on the follow-up date?
Write the date on the day you book, not later. On that day, message the seller, quote the order reference and ask for the status. Note the reply and the new date. If the date has moved twice, ask in writing what the refund process is, and check the booking terms you saved.
How do you close the entry?
When the item arrives, change the status, add the delivery date and the balance paid, and total the purchase: advance plus balance equals the price. In this example 5,000 + 40,000 = ₹45,000, which should match the invoice. If you use SpendixAI, the advance and the balance can both be recorded as expenses in the same category, and the bill kept with the second.
Which bookings deserve extra care?
Be most careful when the advance is large, the seller is new to you or the delivery date is far away. Ask where the money is held and whether it is refundable. Check that the confirmation names the item, the amount and the date, and that the seller's contact details are real. Prefer a payment method that leaves a trail. If a booking depends on a launch or a stock arrival date, remember the date can change, so decide in advance how long you are willing to wait before you ask for your money back.
- Large advance: ask for a written receipt
- Long wait: set an intermediate check date
- Unknown seller: look for how others have dealt with them, and keep the amount modest
A short routine
- Save the confirmation and write the record on the booking day.
- Set the follow-up date.
- Check the pending total each week.
- On delivery, record the balance and close the row.
Do not put a card or UPI PIN, or any login, into your sheet. The order reference and amounts are enough.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


