Bank Reconciliation
Refresh Data
Import Statement
Run Reconciliation
PP
Priya Patel
Accounts Manager
Total Bank Accounts
8
2 new this quarter
Unreconciled Transactions
142
12.5% vs last week
Reconciliation Due
5
2 completed today
Reconciled This Month
₹42.8M
18.2% vs last month
HDFC Current Account
XXXX-4567
₹18,752,340
Statement Balance
₹18,752,340
System Balance
₹18,525,180
Difference
₹227,160
ICICI Savings Account
XXXX-8923
₹12,450,000
Statement Balance
₹12,450,000
System Balance
₹12,450,000
Difference
₹0
Axis Current Account
XXXX-3478
₹8,250,000
Statement Balance
₹8,250,000
System Balance
₹8,320,000
Difference
₹70,000
Reconciliation Status by Account
Discrepancy Analysis
Reconciliation Filters
Reconciliation Overview
Unreconciled Transactions
Reconciliation History
Discrepancies
| Bank Account | Last Statement Date | Statement Balance | System Balance | Difference | Unreconciled Items | Last Reconciled | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| HDFC Current (XXXX-4567) | 30 Nov 2023 | ₹18,752,340 | ₹18,525,180 | ₹227,160 | 42 | 25 Nov 2023 | Reconciliation Due | |
| ICICI Savings (XXXX-8923) | 30 Nov 2023 | ₹12,450,000 | ₹12,450,000 | ₹0 | 0 | 30 Nov 2023 | Up to Date | |
| Axis Current (XXXX-3478) | 30 Nov 2023 | ₹8,250,000 | ₹8,320,000 | ₹70,000 | 18 | 28 Nov 2023 | Discrepancy Found | |
| SBI Business (XXXX-1289) | 30 Nov 2023 | ₹9,300,000 | ₹9,300,000 | ₹0 | 0 | 30 Nov 2023 | Up to Date | |
| Kotak Current (XXXX-6723) | 30 Nov 2023 | ₹5,820,000 | ₹5,785,000 | ₹35,000 | 12 | 22 Nov 2023 | Reconciliation Due |
| Date | Bank Account | Description | Bank Amount | System Amount | Difference | Type | Status | Actions | |
|---|---|---|---|---|---|---|---|---|---|
| 28 Nov 2023 | HDFC Current (XXXX-4567) | Metro Traders Payment | ₹1,850,000 | ₹1,920,000 | ₹70,000 | Deposit | Unreconciled | ||
| 26 Nov 2023 | ICICI Savings (XXXX-8923) | Utility Bill Payment | ₹82,150 | ₹85,430 | ₹3,280 | Withdrawal | Unreconciled | ||
| 24 Nov 2023 | HDFC Current (XXXX-4567) | Vendor Payment - ABC Suppliers | ₹250,000 | ₹245,000 | ₹5,000 | Withdrawal | Unmatched | ||
| 22 Nov 2023 | SBI Business (XXXX-1289) | Client Refund | ₹0 | ₹75,000 | ₹75,000 | Withdrawal | Missing in Bank | ||
| 20 Nov 2023 | Kotak Current (XXXX-6723) | Bank Charges | ₹1,250 | ₹0 | ₹1,250 | Fee | Missing in System |
| Reconciliation Date | Bank Account | Period | Items Reconciled | Discrepancies Found | Reconciled By | Status | Actions |
|---|---|---|---|---|---|---|---|
| 30 Nov 2023 | ICICI Savings (XXXX-8923) | 1 Nov - 30 Nov 2023 | 28 | 0 | Priya Patel | Completed | |
| 30 Nov 2023 | SBI Business (XXXX-1289) | 1 Nov - 30 Nov 2023 | 19 | 0 | Rajesh Kumar | Completed | |
| 28 Nov 2023 | Axis Current (XXXX-3478) | 1 Nov - 28 Nov 2023 | 35 | 2 | Sunita Reddy | Completed | |
| 25 Nov 2023 | HDFC Current (XXXX-4567) | 1 Nov - 25 Nov 2023 | 42 | 3 | Priya Patel | Completed | |
| 22 Nov 2023 | Kotak Current (XXXX-6723) | 1 Nov - 22 Nov 2023 | 22 | 1 | Amit Verma | Completed |
| Date | Bank Account | Description | Bank Amount | System Amount | Difference | Discrepancy Type | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| 28 Nov 2023 | HDFC Current (XXXX-4567) | Metro Traders Payment | ₹1,850,000 | ₹1,920,000 | ₹70,000 | Payment Amount Mismatch | High Priority | |
| 26 Nov 2023 | ICICI Savings (XXXX-8923) | Utility Bill Payment | ₹82,150 | ₹85,430 | ₹3,280 | Bank Charges Not Recorded | Medium Priority | |
| 24 Nov 2023 | HDFC Current (XXXX-4567) | Vendor Payment - ABC Suppliers | ₹250,000 | ₹245,000 | ₹5,000 | Payment Processing Fee | Medium Priority | |
| 22 Nov 2023 | SBI Business (XXXX-1289) | Client Refund - Modern Enterprises | ₹0 | ₹75,000 | ₹75,000 | Missing Bank Transaction | High Priority |
Import Bank Statement
Reconcile Bank Account