Bank Reconciliation
Bank Reconciliation matches your bank statement with the entries in your books, so you can prove the bank balance in Stockivio is right.
Why and when you use it
Bank charges, missed receipts and wrong entries creep in every month. Reconciliation finds them. You import the bank statement, Stockivio matches most lines automatically, rules handle repeating entries like bank charges, and you deal with the rest. When everything agrees you complete the reconciliation and it is saved in History. The accountant does this weekly or monthly.
Before you start
- Payments and expenses for the period entered
- The bank statement downloaded as a file from your bank
Step by step
- Add your bank accountOn first use the screen says Start by adding your bank account. Press + Add bank account. Use Edit account to change details later and Archive account for closed accounts.
- Import the statementOn the Import statement tab, choose the statement file under 1. Choose the statement file and press Read file. Pick the Bank format if listed.
- Check the columnsUnder 2. Check the columns, set Column titles are on row and Date format, and map the Date, Narration, Withdrawal, Deposit and Balance columns. Press Apply mapping and check again until 3. Transactions found looks right.
- ReconcileOn the Reconcile tab choose the Bank account, From and To dates, and optionally the Closing balance on the statement. Press Refresh.
- Auto-matchPress Auto-match. Bank statement entries are matched with entries In your books by date and amount.
- Match the restFor an unmatched line, use Match bank entry to pick the right book entry. Book entries not found in the bank yet are usually cheques not yet cleared.
- Add rules for repeatsOn the Rules tab, set Narration contains (for example 'CHRG'), Money (in or out) and Then, with an Expense category or Party, and press Save rule.
- CompleteWhen the difference is nil, press Complete reconciliation. It appears in History under Completed reconciliations, with Imported statements listed too.
Worked example
Sharma Traders reconciles its current account for October 2026. The statement has 214 lines and a closing balance of ₹6,42,380.
- Import statement: choose the October file, Read file, set Column titles are on row 1 and Date format DD/MM/YYYY, Apply mapping and check again.
- Reconcile: Bank account current, From 1 Oct 2026, To 31 Oct 2026, Closing balance ₹6,42,380, Refresh.
- Auto-match matches 198 lines.
- 11 lines are 'SMS CHRG' and 'NEFT CHRG'; a rule with Narration contains CHRG, Money out, Then Expense category Bank charges is saved.
- Two UPI receipts from Gupta Kirana Store were not recorded; record them in Payments and match.
- Three cheques issued are under Book entries not found in the bank yet; leave them.
- Press Complete reconciliation.
Result: October is reconciled, bank charges of ₹1,416 are now in expenses, two missing receipts are recorded and the reconciliation is in History.
💡 Tips
- Reconcile at least monthly; weekly is easier for busy accounts.
- Put UTR or cheque numbers in payment references to help matching.
- Rules save the most time on bank charges, interest and fixed monthly debits.
⚠️ Common mistakes
- Forcing a match to the wrong entry just to clear a line. Find or record the real entry.
- Importing the same statement twice. Check Imported statements on History first.
- Not entering the closing balance, so you cannot see a remaining difference.
सवाल
My bank's file looks different. What do I do?
Use 2. Check the columns to map the columns by hand and press Apply mapping and check again.
What about uncleared cheques?
They stay under Book entries not found in the bank yet and will match next month.
🎬 Video walkthrough (script — recording coming soon)
- Scene 1: + Add bank account.
- Scene 2: Import statement, Read file, map columns.
- Scene 3: Reconcile tab with dates and closing balance.
- Scene 4: Auto-match.
- Scene 5: Match bank entry for one line.
- Scene 6: Save a rule for bank charges.
- Scene 7: Complete reconciliation and History.