Is there is any formula in excel 2007 so that bank statement is matched with bank ledgers, as there are 100's of entries are in one day and it become hectic to do it manually,. kindly help me on this issue. Also one bank statement entry is to be matched with only one entry in bank ledger, considering withdrawal side i.e debit side of bank statement to be matched with credit side of bank ledger and receipt side i.e credit side of bank statement to be matched with debit side of bank ledger. Also basis of reconciliation should be amount and reference numbe.r if any.
find the attached file.
There are two bank ledger and one bank statement.
Bookmarks