• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Bank reconcilation help.

Shabbo

Member
Dear Sir,
Attached is my bank ledger and bank statement.
I wanted to reconcile like matching from Bank Ledger Yellow Column with Bank Statement Yellow Column and Bank Ledger Orang Column with Bank Statement Orange Column and find matched and unmatched entries basis on reference numbers.
 

Attachments

AliGW

Active Member
I know I am meant to use the report button, but it usually takes an age for anything to happen here if I do, so I've taken to posting to the thread so people don't waste their time.
 

shili12

Member
See worksheets called ResultDebit and ResultCredit, as as result of Add-In, i usually use this at work, however you didnt indicated closing balances of your cash book (Bank ledger) for me to arrive at bank statement balance.
It can be used for Creditors reconciliation with statement.
 

Attachments

Top