A freelancer who is paid by UPI can easily record the same client payment three times: once in the payment app's history, once in the bank statement and once in the invoice list. The fix is to let the bank statement define when money arrived, and let the invoice list say what it was for.
Why is income more exposed than spending?
When you overcount a coffee, you are off by a few rupees. When you overcount a client payment, you can overstate a month's income by tens of thousands, which misleads your own planning and any conversation with your CA. Irregular income makes it worse, because one bad month hidden by a double count feels fine until the rent is due.
Three lists, one truth
- Invoice list: what you billed, to whom, and the due date
- Payment app history: who paid and when, in the app's words
- Bank statement: what actually landed in the account
Choose the bank statement as the arrival record. Link each bank credit to an invoice number in a column called Invoice, and use the app history only to identify a payer whose name the bank narration does not make clear.
A worked example with split payments
Say you invoice Client X for ₹30,000, and the client pays in two UPI payments, ₹20,000 on 4 June and ₹10,000 on 9 June. Both appear in the app as received and both appear as credits in the bank.
| Source | Date | Detail | Amount in ₹ |
|---|---|---|---|
| Bank | 04 Jun | UPI credit, Client X | 20,000 |
| App | 04 Jun | Received from Client X | 20,000 |
| Bank | 09 Jun | UPI credit, Client X | 10,000 |
| App | 09 Jun | Received from Client X | 10,000 |
Add all four and you get ₹60,000, double the invoice. Count only the bank rows and you get 20,000 + 10,000 = ₹30,000, which matches the invoice. With bank credits in column D and the invoice number in column E, =SUMIFS($D$2:$D$300,$E$2:$E$300,"INV-014") should equal that invoice's value; if it is less, part of it is still unpaid.
How do I spot an unpaid balance?
Compare the invoice amount with the sum of linked credits. Invoice ₹30,000 less received ₹20,000 leaves ₹10,000 to chase. Keep a column called Balance and sort by it, so the largest outstanding amount sits at the top.
What should my CA see?
A list of invoices, the bank credits linked to each, and a short note on anything unmatched. How any receipt is treated for tax is a question for your CA, because rules and limits change. Your records should make that question easy to answer.
When a sheet is not enough
SpendixAI imports bank statements as PDF, CSV or Excel, lets you review rows before saving, and flags possible duplicate imports, which helps when two statement files overlap. It is one personal workspace, not invoicing software, so your invoice list stays in your own sheet or tool.
Keep a short Not income list as well. Money that arrives from family, a friend repaying you or a refund is real money in your account, but it is not a client receipt. If the line is not tagged, it quietly inflates the month. Tag it the day you see it, with a few words saying what it was, and your income formula can then ignore anything marked Not income. Over a few months the list also teaches you who your regular payers are, which is useful when you decide whom to chase first.
Weekly habit
- Paste new bank rows into the sheet
- Link each credit to an invoice number or mark it Not income
- Update the Balance column
- Message clients with outstanding balances
Useful ideas start with a clearer picture of your own spending.
Explore your reports


