When a client cancels and you return part or all of the advance, record three separate things: the advance when it arrived, the value of any work you actually completed, and the refund when it left your account. The net amount you keep is the advance minus the refund, and it should equal the fee for work done. If your records show only the refund as a loose expense, your income for the month will look higher than it really was.
Why the refund should not be a plain expense
A refund is the reversal of money you received, not spending on something. If you log the advance as income and the refund as an ordinary expense, both numbers are technically there, but month-wise reports will show inflated income and inflated spending. Anyone reading your sheet later, including you at ITR time, will wonder why a project that never happened produced two large entries.
The cleaner habit is to keep the refund tied to the advance it reverses. Whichever tool you use, the refund line should carry the client name, the project, and a pointer to the original credit.
How do I log the three entries step by step?
- Find the original credit in your bank statement and note its date, amount and UTR or reference. Label it as advance received, client name and project, not as final income.
- Write down the work done before cancellation: hours, deliverables handed over, and the amount you and the client agreed that work is worth. Keep the message or email where that was agreed.
- Decide the refund amount: advance minus agreed fee for work done. Pay it by UPI, NEFT or IMPS to the same account the advance came from where possible, so the trail is simple.
- Record the refund on the date it left your account, with the reference, client name and a note such as refund of advance, project cancelled.
- Check the net: advance received minus refund paid should equal the agreed fee for work done. If it does not, find the gap before closing the entry.
A worked example with the arithmetic
Say a client pays an advance of ₹30,000 on 5 March for a brand video. On 20 March they cancel. You had finished the script and a first edit, which you both agree is worth ₹8,000. You return ₹22,000.
| Date | Entry | Amount | Treatment |
|---|---|---|---|
| 5 March | Advance received | ₹30,000 | Credit, labelled advance, client and project |
| 20 March | Work done, agreed | ₹8,000 | Note only; this is the part you keep |
| 22 March | Refund paid by UPI | ₹22,000 | Debit linked to the advance, not household spending |
| Net | 30,000 minus 22,000 | ₹8,000 | Matches the agreed fee for work done |
If the income report for March shows ₹30,000 as income and ₹22,000 as a refund, the net of ₹8,000 is the figure that reflects the project. Whether that ₹8,000 counts in a particular year or head is a tax question for your CA; your job is to have the trail ready.
What if the refund is paid in parts or later?
Clients sometimes agree a refund and you pay it in two instalments because cash is tight. Record each instalment on its own date and keep a running line in your notes: refund agreed ₹22,000, paid ₹12,000, balance ₹10,000. A refund still owed is a liability, so do not mix it into your free cash when planning the month.
If you refund in a later month than the advance, the two entries will fall in different months. That is fine, as long as the note on the refund says which advance it reverses.
Doing this in SpendixAI
If you import your bank statement into SpendixAI, the advance credit and the refund debit will both appear, each with the account they belong to, and you review the rows before saving. You can create your own category, say Client advances held, so both rows land in one place and the net is easy to read. Add the agreed fee for work done as a manual entry if you want it visible.
Quick checklist before you close the project
- Advance credit found and labelled with client and project
- Agreed value of work done written down
- Refund paid, with reference, from or to the right account
- Net of advance minus refund equals the fee for work done
- Cancellation message and agreement saved with the entries
Useful ideas start with a clearer picture of your own spending.
Explore your reports


