To reconcile income with a bank statement, put your invoice list on one side and the bank credits on the other, match each invoice to a credit, and write down why any difference exists. Most gaps come from three things: part payments, bank fees and tax deducted by the client. Whatever stays unmatched goes on a short list for your CA.
What are we comparing?
Two independent records. Your tracker says what you billed and expect. The bank statement says what actually arrived. Neither is wrong; they simply measure different things. Reconciling is the act of explaining every difference between them, so that nothing is left as a vague feeling that the numbers should be higher.
The twelve-row example
All figures here are hypothetical. Say a freelance designer raised twelve invoices in a quarter and is now lining them up with credits in one bank account.
| Invoice | Billed (₹) | Credit in bank (₹) | Gap (₹) | Reason |
|---|---|---|---|---|
| 101 | 20,000 | 20,000 | 0 | Matches |
| 102 | 35,000 | 35,000 | 0 | Matches |
| 103 | 50,000 | 25,000 | 25,000 | Part payment, balance pending |
| 104 | 18,000 | 18,000 | 0 | Matches |
| 105 | 60,000 | 54,000 | 6,000 | Tax deducted by client |
| 106 | 12,000 | 12,000 | 0 | Matches |
| 107 | 45,000 | 44,941 | 59 | Bank charge on incoming transfer |
| 108 | 22,000 | 22,000 | 0 | Matches |
| 109 | 30,000 | 0 | 30,000 | Unpaid |
| 110 | 16,000 | 16,000 | 0 | Matches |
| 111 | 80,000 | 72,000 | 8,000 | Tax deducted by client |
| 112 | 28,000 | 28,000 | 0 | Matches |
Add the billed column: 20,000 + 35,000 + 50,000 + 18,000 + 60,000 + 12,000 + 45,000 + 22,000 + 30,000 + 16,000 + 80,000 + 28,000 = ₹4,16,000. Add the credits: 20,000 + 35,000 + 25,000 + 18,000 + 54,000 + 12,000 + 44,941 + 22,000 + 0 + 16,000 + 72,000 + 28,000 = ₹3,46,941. The total gap is 4,16,000 minus 3,46,941 = ₹69,059.
Now explain it: 25,000 (part payment) + 6,000 + 8,000 (tax deducted) + 59 (bank charge) + 30,000 (unpaid) = ₹69,059. The gap is fully explained, which is the whole point.
What are the three common gaps?
- Part payments. The client pays in two instalments. Keep one invoice row and note each credit against it, rather than inventing a second invoice.
- Bank fees. A small deduction on an incoming transfer makes the credit slightly lower than billed. Note it, do not round it away.
- Tax deducted at source. The client pays you the amount minus tax they have deducted and deposited. Ask the client for the certificate that proves it, and keep it with the invoice.
For deducted tax, the received amount in your tracker is the cash that arrived, while the deducted amount sits in its own column. Do not treat the deducted portion as money you never earned. How it is handled in your return is a matter for your CA.
What about credits that match no invoice?
Go through the statement once more and tick every credit you have explained. What remains is an unexplained list: a relative returning a loan, a refund from a shop, a transfer between your own accounts, an advance from a new client. Make a small table with date, amount, narration as it appears in the statement and your best factual guess, marked as a guess if you are not sure.
Can SpendixAI help with the bank side?
If you upload the statement as PDF, CSV or Excel, rows are shown for review before saving, so you can see credits in one list per account instead of scrolling a document. Matching to invoices is still your job, and the sheet above does it well.
Timing is the other thing to watch. A credit can land in a different month from its invoice, and a cheque or transfer started on the last working day may show in the next period. When a credit looks missing, widen the statement window by a few days either side before concluding that it never came. Write the date you actually found it in the sheet, so next quarter's reconciliation starts from a clean position.
A year-end reconciliation checklist
- Download the statement for every account you receive money in.
- Mark each credit as matched to an invoice, a deduction, or unexplained.
- Compute billed minus received and confirm the reasons add up to the gap.
- Chase unpaid invoices and part payments before the year closes.
- Send the unexplained list and the deduction certificates to your CA together.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


