Overview

Generally, Bank Reconciliation is done to ensure reconciliation between the Balance of Ledger to the Balance of Bank and difference arising could be referred as Unpresented, Uncleared and Unrecorded Transactions which are identified, categorized and accounted for accordingly.

 

It requires major human intervention to reconcile the difference to Zero.

 

I have made a model which almost minimized human intervention and whole categorization of it is done automatically. It only requires to copy and paste the Ledger of Unreconciling items to a specified area.

 

It also identifies payments which are "Post Dated" or which are "Staled" and adjust it from the Ledger Balance.

 

And last, it categorized all Unreconciled Payments to its aging so that it could be considered and accounted for accordingly while projecting Cashflow Position.

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
693
70
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
736
81
Model allows to know the breakup of Closing Inventory at transactional level considering Sales made in the period as per…
Reconciliation Model
775
84
Key Limitation: 1. No Common ID Available which is generally lookup to reconcile 2. Amount Difference from one report to…
Bank Reconciliation Template
1,707
136
Generally, Bank Reconciliation is done to ensure reconciliation between the Balance of Ledger to the Balance of Bank and difference…
Credit Card Reconciliation Model
1,904
99
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,081
214
It distributes Total Project Cost per Project as per Project Duration by comparing to the project starting date, identifying the…
See All