Reconciliation Center
PP
Priya Patel
Accounts Manager
Total Reconciliation Items
142
8.4% vs last month
Unreconciled Items
38
12.5% vs last week
Pending Reconciliation
₹8.7M
7.1% vs last week
Reconciled This Month
₹32.4M
18.2% vs last month
Bank Statement Balance
₹48,752,340
As of 30 Nov 2023
Accounting System Balance
₹48,525,180
As of 30 Nov 2023
Reconciliation Discrepancy
₹227,160
0.47% variance
Reconciliation Status Trend
Discrepancy Analysis
Reconciliation Filters
Daily Reconciliation
Bank Reconciliation
Discrepancies
Reconciliation History
| Date | Account | Description | System Amount | Statement Amount | Difference | Status | Actions |
|---|---|---|---|---|---|---|---|
| 30 Nov 2023 | HDFC Current (XXXX-4567) | Payment from Reliance Industries | ₹4,250,000 | ₹4,250,000 | ₹0 | Reconciled | |
| 29 Nov 2023 | ICICI Savings (XXXX-8923) | Tech Solutions Ltd Payment | ₹2,180,000 | ₹2,180,000 | ₹0 | Reconciled | |
| 28 Nov 2023 | Axis Current (XXXX-3478) | Metro Traders Payment | ₹1,920,000 | ₹1,850,000 | ₹70,000 | Discrepancy | |
| 27 Nov 2023 | HDFC Current (XXXX-4567) | Office Supplies Payment | ₹125,000 | ₹125,000 | ₹0 | Reconciled | |
| 26 Nov 2023 | ICICI Savings (XXXX-8923) | Utility Bill Payment | ₹85,430 | ₹82,150 | ₹3,280 | Pending Review | |
| 25 Nov 2023 | HDFC Current (XXXX-4567) | Salary Payments | ₹1,850,000 | ₹1,850,000 | ₹0 | Reconciled |
| Bank Account | Statement Date | Statement Balance | System Balance | Difference | Last Reconciled | Status | Actions |
|---|---|---|---|---|---|---|---|
| HDFC Current (XXXX-4567) | 30 Nov 2023 | ₹18,752,340 | ₹18,525,180 | ₹227,160 | 25 Nov 2023 | Reconciliation Due | |
| ICICI Savings (XXXX-8923) | 30 Nov 2023 | ₹12,450,000 | ₹12,450,000 | ₹0 | 30 Nov 2023 | Up to Date | |
| Axis Current (XXXX-3478) | 30 Nov 2023 | ₹8,250,000 | ₹8,320,000 | ₹70,000 | 28 Nov 2023 | Discrepancy Found | |
| SBI Business (XXXX-1289) | 30 Nov 2023 | ₹9,300,000 | ₹9,300,000 | ₹0 | 30 Nov 2023 | Up to Date |
| Date | Account | Description | System Amount | Statement Amount | Difference | Discrepancy Type | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| 28 Nov 2023 | Axis Current (XXXX-3478) | Metro Traders Payment | ₹1,920,000 | ₹1,850,000 | ₹70,000 | Payment Amount Mismatch | High Priority | |
| 26 Nov 2023 | ICICI Savings (XXXX-8923) | Utility Bill Payment | ₹85,430 | ₹82,150 | ₹3,280 | Bank Charges Not Recorded | Medium Priority | |
| 24 Nov 2023 | HDFC Current (XXXX-4567) | Vendor Payment - ABC Suppliers | ₹245,000 | ₹250,000 | ₹5,000 | Payment Processing Fee | Medium Priority | |
| 22 Nov 2023 | SBI Business (XXXX-1289) | Client Refund - Modern Enterprises | ₹75,000 | ₹0 | ₹75,000 | Missing Bank Transaction | High Priority |
| Reconciliation Date | 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 | |
| 24 Nov 2023 | ICICI Savings (XXXX-8923) | 1 Nov - 24 Nov 2023 | 28 | 0 | Rajesh Kumar | Completed | |
| 23 Nov 2023 | Axis Current (XXXX-3478) | 1 Nov - 23 Nov 2023 | 35 | 2 | Sunita Reddy | Completed | |
| 22 Nov 2023 | SBI Business (XXXX-1289) | 1 Nov - 22 Nov 2023 | 19 | 1 | Amit Verma | Completed | |
| 18 Nov 2023 | HDFC Current (XXXX-4567) | 1 Oct - 18 Nov 2023 | 127 | 8 | Priya Patel | Completed |
Reconcile Bank Account