Tax and GST

Unclear credits in your bank statement: annotating them for your CA

Add source and purpose columns to your bank statement export, mark unclear credits and write short factual notes for your CA, with five samples.

Editorial illustration for Unclear credits in your bank statement: annotating them for your CA

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?

  1. Download the statement as a spreadsheet or CSV, or copy it into a sheet.
  2. Delete nothing. Keep the bank's own columns as they are.
  3. Add four columns to the right: source, purpose, proof and status.
  4. Filter for credits only, so debits do not distract you.
  5. 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 statementSourcePurposeStatus
45,000transfer reference with a client's nameClient APayment for invoice 22Explained, invoice saved
8,000transfer from a person with my surnameMy brotherReturned the amount I paid for the tripExplained, message saved
1,250shop name followed by refundOnline storeRefund for a returned orderExplained, order mail saved
30,000own name, transfer between accountsMyselfMoved from my other accountExplained, matches the debit there
12,500a code with no nameUnknownNot sure yetUnclear, 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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports