To explain unclear credits to your CA, export the statement to a spreadsheet, add two columns called source and purpose, and fill them in for every credit you can explain. Mark the ones you cannot as unclear, and write a short factual note for each. Do not guess or invent a reason; unknown is an acceptable answer.
Why annotate at all?
A statement line often says only a transfer reference or a payer code. Your CA cannot tell whether the credit is a client payment, a refund or money from a relative. Annotating it yourself, while the memory is fresh, saves a conversation. It also protects you: a note written close to the event is more reliable than an explanation reconstructed a year later.
How do you set up the sheet?
- Download the statement as a spreadsheet or CSV, or copy it into a sheet.
- Delete nothing. Keep the bank's own columns as they are.
- Add four columns to the right: source, purpose, proof and status.
- Filter for credits only, so debits do not distract you.
- Work down the list. Mark each as explained or unclear.
The source is who sent the money. The purpose is what it was for. The proof is a file name, such as an invoice or a message. The status is one of explained, unclear or to ask.
What do five sample annotations look like?
| Credit (₹) | Narration in the statement | Source | Purpose | Status |
|---|---|---|---|---|
| 45,000 | transfer reference with a client's name | Client A | Payment for invoice 22 | Explained, invoice saved |
| 8,000 | transfer from a person with my surname | My brother | Returned the amount I paid for the trip | Explained, message saved |
| 1,250 | shop name followed by refund | Online store | Refund for a returned order | Explained, order mail saved |
| 30,000 | own name, transfer between accounts | Myself | Moved from my other account | Explained, matches the debit there |
| 12,500 | a code with no name | Unknown | Not sure yet | Unclear, will check old messages |
Notice how each note says who, what and where the proof is, in one line, without opinion. The unclear credit simply says unclear and what you will do about it.
What makes a good note?
- Facts only: who paid, why and which document supports it.
- Short: one line is usually enough.
- Honest: unclear is better than a guess you might have to withdraw.
- Consistent: use the same words for the same kind of credit.
- Dated: add the date you wrote the note if it was later than the credit.
How do you chase the unclear ones?
Search the amount and date in your email and chat messages. Ask the people most likely to have paid you. Check whether it matches a debit in another of your accounts. If after a reasonable try it is still unclear, send the list of unclear credits to your CA with the dates and amounts, and ask what they would like you to do.
A quick calculation
Say the credits in a month total ₹96,750 and you have explained 45,000 + 8,000 + 1,250 + 30,000 = ₹84,250 of it. Unclear: 96,750 minus 84,250 = ₹12,500. That is 12,500 out of 96,750, which is about 13 percent unexplained, and your CA can see at once where to focus.
Treat transfers between your own accounts with particular care. They show as a credit in one account and a debit in another, and they are easy to mistake for income. Match each one to its other half and mark both as own transfer, so that nothing inflates the credits you describe to your CA.
Can SpendixAI make this easier?
With statements imported, you can filter to credits and give them categories such as client payment, refund or own transfer, and export the list as CSV to add your notes. Writing the factual note is still your job, because only you know what the credit was.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


