Bank Reconciliation
48
Total Reconciliations
6 this month
127
Open Items
14% vs last month
94.6%
Matched %
2.3% improvement
₹18.4L
Outstanding Amount
₹3.2L resolved
Reconciliation Records
48 records| Reconciliation ID | Bank Account | Period | Status | Matched | Unmatched | Match Rate | Difference (₹) | Actions |
|---|---|---|---|---|---|---|---|---|
| BRC-2026-0048 |
SBI Corporate
A/c: 38267451920 | IFSC: SBIN0001234
|
Feb 2026 | In Progress | 342 | 28 | 92.4% | -₹3,42,180 |
|
| BRC-2026-0047 |
HDFC Current
A/c: 50100248736914 | IFSC: HDFC0000456
|
Feb 2026 | Draft | 0 | 215 | 0.0% | ₹0 |
|
| BRC-2026-0046 |
SBI Corporate
A/c: 38267451920 | IFSC: SBIN0001234
|
Jan 2026 | Approved | 518 | 0 | 100% | ₹0 |
|
| BRC-2026-0045 |
ICICI Current
A/c: 028705003421 | IFSC: ICIC0000789
|
Jan 2026 | Completed | 287 | 4 | 98.6% | -₹14,520 |
|
| BRC-2026-0044 |
Axis Bank
A/c: 917020043612345 | IFSC: UTIB0002345
|
Jan 2026 | Approved | 156 | 0 | 100% | ₹0 |
|
| BRC-2026-0043 |
HDFC Current
A/c: 50100248736914 | IFSC: HDFC0000456
|
Jan 2026 | Completed | 198 | 7 | 96.6% | -₹87,340 |
|
| BRC-2025-0042 |
SBI Corporate
A/c: 38267451920 | IFSC: SBIN0001234
|
Dec 2025 | Approved | 489 | 0 | 100% | ₹0 |
|
| BRC-2025-0041 |
ICICI Current
A/c: 028705003421 | IFSC: ICIC0000789
|
Dec 2025 | Approved | 264 | 0 | 100% | ₹0 |
|
Showing 1-8 of 48 reconciliations
Recent Reconciliation Activity
Last 7 days| Timestamp | User | Reconciliation | Action | Details |
|---|---|---|---|---|
| 12 Feb 2026, 09:45 AM | Deepa Sharma | BRC-2026-0048 | Auto-matched 42 entries | Auto-matching engine identified 42 new matches for SBI Corporate Feb 2026. Total matched value: ₹34,56,780.00. Remaining unmatched: 28 entries. |
| 11 Feb 2026, 04:30 PM | Suresh Iyer | BRC-2026-0048 | Manual match | Manually matched 6 NEFT transactions with corresponding book entries. Combined value: ₹8,92,340.00. UTR reference verified against bank statement. |
| 11 Feb 2026, 10:15 AM | Deepa Sharma | BRC-2026-0047 | Created Draft | Created new reconciliation for HDFC Current Account. Uploaded bank statement for Feb 2026 (215 entries). Statement period: 01 Feb - 10 Feb 2026. |
| 10 Feb 2026, 05:00 PM | Arjun Mehta | BRC-2026-0046 | Approved | SBI Corporate Jan 2026 reconciliation approved. All 518 entries matched. Zero difference. Signed off for month-end close. Audit trail archived. |
| 09 Feb 2026, 02:20 PM | Priya Nair | BRC-2026-0045 | Completed | ICICI Current Jan 2026 reconciliation marked complete. 287 matched, 4 unmatched items (₹14,520 total). Unmatched items: 2 bank charges not in books, 1 stale cheque, 1 timing difference on NEFT. |
| 08 Feb 2026, 11:30 AM | Kavitha Rao | BRC-2026-0043 | Exception flagged | HDFC Current Jan 2026 - 7 unmatched items flagged for review. Includes 3 vendor payments not in bank statement (possible timing), 2 bank charges, 2 interest credits. Total variance: ₹87,340. |
| 07 Feb 2026, 09:00 AM | System | BRC-2026-0048 | Statement imported | Bank statement auto-imported via SBI corporate banking API. 370 transactions for period 01 Feb - 07 Feb 2026. Statement balance: ₹1,24,56,780.00. Integration: SBI CMP API v3.1. |
Bank Account Summary
| Bank Account | IFSC Code | Book Balance (₹) | Bank Balance (₹) | Difference (₹) | Last Reconciled | Status |
|---|---|---|---|---|---|---|
|
SBI Corporate
A/c: 38267451920
|
SBIN0001234 | 1,27,98,960.00 | 1,24,56,780.00 | -3,42,180.00 | 12 Feb 2026 (In Progress) | Active |
|
HDFC Current
A/c: 50100248736914
|
HDFC0000456 | 86,45,230.00 | 86,45,230.00 | 0.00 | 31 Jan 2026 | Current |
|
ICICI Current
A/c: 028705003421
|
ICIC0000789 | 45,78,120.00 | 45,63,600.00 | -14,520.00 | 31 Jan 2026 | Pending Approval |
|
Axis Bank
A/c: 917020043612345
|
UTIB0002345 | 22,34,560.00 | 22,34,560.00 | 0.00 | 31 Jan 2026 | Reconciled |