Overview

Generally for any reconciliation, there is a common key which is lookup to reconcile, for e.g. check numbers in Bank Reconciliation. But where there is no common key, its become a nightmare for any finance personnel to reconcile it. Where the quantum of transactions per day is 10000+, it's become very frustrating to perform the reconciliation.

 

The issues previously were:

 

1. The bank selected while executing transaction and from the bank amount actually received found to be different.

 

2. Any cash transaction found to be received from Bank

 

And there were numerous errors which this model has countered and addressed with 0% human intervention. I have made a reconciliation model for a retail giant in Pakistan, where reconciliation of sales from Credit Card gets reconciled in just less than 2 mins, which is per branch.

 

It has allowed the Company to know the accurate amount of money receivable from bank at any point of time where the transaction is unpaid. It's a combination of processes where transaction first reconciled through unique number, if available or else reconciled through model based unique generation code which ensure 99.99% accuracy of the reconciliation.

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
787
75
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
835
84
Model allows to know the breakup of Closing Inventory at transactional level considering Sales made in the period as per…
Reconciliation Model
881
89
Key Limitation: 1. No Common ID Available which is generally lookup to reconcile 2. Amount Difference from one report to…
Bank Reconciliation Report Generator
1,859
167
Generally, Bank Reconciliation is done to ensure reconciliation between the Balance of Ledger to the Balance of Bank and difference…
Bank Reconciliation Template
1,810
143
Generally, Bank Reconciliation is done to ensure reconciliation between the Balance of Ledger to the Balance of Bank and difference…
CAPEX Distribution Model
3,178
224
It distributes Total Project Cost per Project as per Project Duration by comparing to the project starting date, identifying the…
See All