Overview

Key Limitation:
1. No Common ID Available which is generally lookup to reconcile
2. Amount Difference from one report to another. In my case it PKR 5-10 Rs but could be more and vary scenario to scenario.

Key Challenges
1. Amount has to be matched without repeatation and in contrast to its count coming in report.

I have made a model which overcomes all limitations and addressed the challenges mentioned above and allows you to reconcile data with 100% accuracy.

Reviews Add a review
No reviews yet

More From Rahim Damani

Browse our top rated business templates. See All
Pipeline to Receivable Management - Centralized Model
1,317
104
Centralized Data Model concept where every stakeholder of business could view the information more efficiently. Generally Deal Management, Receivable Management…
Inventory Management - Closing Inventory Breakup as per FIFO Method
1,404
110
Model allows to know the breakup of Closing Inventory at transactional level considering Sales made in the period as per…
Bank Reconciliation Report Generator
2,507
189
Generally, Bank Reconciliation is done to ensure reconciliation between the Balance of Ledger to the Balance of Bank and difference…
Bank Reconciliation Template
2,409
162
Generally, Bank Reconciliation is done to ensure reconciliation between the Balance of Ledger to the Balance of Bank and difference…
Credit Card Reconciliation Model
2,688
114
Generally for any reconciliation, there is a common key which is lookup to reconcile, for e.g. check numbers in Bank…
CAPEX Distribution Model
3,837
253
It distributes Total Project Cost per Project as per Project Duration by comparing to the project starting date, identifying the…
See All