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
Welcome, Guest
Please Login or Register.    Lost Password?
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.
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Bank Reconciliation Reports and Best Practices
#2291
gavrobere (User)
Gold Boarder
Posts: 316
graphgraph
User Offline Click here to see the profile of this user
Re:Bank Reconciliation Reports and Best Practices 12 Years, 6 Months ago  
Sorry, I couldn't attached the two files.

1/ GENERAL LEDGER RECONCILIATION DETAIL REPORT As of 30-OCT-11

Report Date: 12-OCT-11 09:29
Bank Account Number: XXXXX

General Ledger Position:

General Ledger Cash Account: $49,258,287.07

Bank Position:

Bank Statement Closing Balance $0.00
Total Unreconciled Receipts: $300833.09
Total Unreconciled Payments: $0.00
Total Unreconciled Cashflow $0.00
Total Unreconciled Journal Entries $1,246,947.28
Total Lines marked as Errors $0.00
Adjustment Bank Statement Balance: $1,547,780.37
DIFFERENCE (GL Cash Account Balance - Adjusted Bank Statement) $47,710,506.70


2/ BANK STATEMENT SUMMARY REPORT

Statement Date: 01-Apr-11 to 31-Mar-12
Bank Account Number: XXXXX

Opening Balance (03-OCT-11): $56,234,131.10
Closing Balance (03-OCT-11): $49586817.66
Net Movement (03-OCT-11): $-6647314.44
Number of Lines: 379

Reversals 201
Opening Balance (03-OCT-11): $500000.00
Closing Balance (03-OCT-11): $900000.00
Net Movement (03-OCT-11): $400000.00
Number of Lines: 627

Zero Transact
Opening Balance (03-OCT-11): $0.00
Closing Balance (03-OCT-11): $0.00
Net Movement (03-OCT-11): $0.00
Number of Lines: 282


3/ TRANSACTIONS AVAILABLE FOR RECONCILIATION REPORT

Report Date: 12-OCT-11 09:36

Total Available Receipts: $764832.92
Total Reversed Receipts: $1,150.00
Net Journal Entry Lines: $1246947.28
Total Unreconcilied Statement Lines: $1,876,376.96
Net Available $3,887,007.16
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
      Topics Author Date
    thread link
Bank Reconciliation Reports and Best Practices
gavrobere 2011/10/20 21:44
    thread link
thread linkthread link Re:Bank Reconciliation Reports and Best Practices
gavrobere 2011/10/20 21:48
    thread link
thread linkthread linkthread link Re:Bank Reconciliation Reports and Best Practices
gavrobere 2011/10/20 21:51
    thread link
thread linkthread linkthread linkthread link Re:Bank Reconciliation Reports and Best Practices
handsonerp 2011/10/21 00:24
    thread link
thread linkthread linkthread linkthread linkthread link Re:Bank Reconciliation Reports and Best Practices
gavrobere 2011/10/23 17:18
    thread link
thread linkthread linkthread linkthread linkthread linkthread link Re:Bank Reconciliation Reports and Best Practices
handsonerp 2011/10/26 01:42
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop