Re:Bank Reconciliation Reports and Best Practices - HandsonERP

Welcome

Welcome to HandsonERP.com

This site provides video based training of Oracle Financials.
Learn concepts and functionality in a step by step manner.

Login

	HandsonERP - Oracle E-Business Suite Training	Forum Flat View Rules

Welcome, Guest
Please Login or Register. Lost Password?

HandsonERP - Oracle E-Business Suite Training

HandsonERP.com Forum

Questions Related to Lessons Content

Re:Bank Reconciliation Reports and Best Practices (1 viewing) (1) Guest

Please post inquiries related to lessons content here. All questions and inquiries related to the website should be submitted directly using Contact form in the top menu.

Favoured: 0

TOPIC: Re:Bank Reconciliation Reports and Best Practices

Forum Tools

#2290

gavrobere (User)

Gold Boarder

Posts: 316

Re:Bank Reconciliation Reports and Best Practices 12 Years, 6 Months ago

Reconciliation for the period: Oct-11 as at 07/10/2011
Bank Statement no. - Date: XXXXX - 04/10/11

Bank statement
Opening Bal 30.00
Closing Bal 51,135,132.49
Net Movement 51,135,102.49

LESS
GL Cash Account Balance 50,278,925.05

Variance between Bank and GL 856,177.44

Representing:

Items in Bank not yet in GL
Unreconciled Satement Lines 2,044,399.12
(Transactions available)
Fees 0.00
Part Reconciled Lines 0.00
Timing issues between the Bank and GL 0.00
Sub Total Item in Bank not in GL 2,044,399.12

LESS:

Items in GL not on Bank Statement
Unreconciled Receipts 300.00
Unreconciled Payment 0.00
Unreconciled Journal Lines 1,184,493.40
Incomplete Reversed Receipts 0.00
Reversal Receipts Reconciled against a Bank Statement -1,000.00

Net Explained Variance between Bank and GL 1,183,793.40

LESS
Unexplained Account Variance 327,615.96

Total Variance between Bank and GL 856,177.44

Report to moderator Logged