This discussion is archived
3 Replies Latest reply: Jan 31, 2013 10:48 PM by Sadanand Shenoy RSS

FA & GL Reconcilication

986189 Newbie
Currently Being Moderated
Hi Experts,

Could you please tell me the process of Reconciling Oracle FA with GL?

Thanks in advance..

  • 1. Re: FA & GL Reconcilication
    895882 Newbie
    Currently Being Moderated
    Take the standard report to do the reconciliation of the FA Accounts with

    - Oracle Assets Report: Journal Entry Reserve Ledger Report
    - Oracle GL Report: Account Analysis Report or Trial Balance - Detail

    Once you have the report for the respective accounts, you would have to convert that into excel and create sub-totals.


  • 2. Re: FA & GL Reconcilication
    986189 Newbie
    Currently Being Moderated
    Thanks Vikas
  • 3. Re: FA & GL Reconcilication
    Sadanand Shenoy Newbie
    Currently Being Moderated
    Hi Bharat,

    As Vikas has informed you can perform the same. Else for a detailed, fool proof reconciliation

    Reconciling Accounts
    Steps to reconcile accounts:
    1. In Oracle General Ledger, match the ending balances in the Detail Trial Balance report with the ending balances in the ledger Subledger Accounting Account Analysis report.
    2. Match the general ledger ending balances with those of the Cost Summary / CIP Summary / Reserve Summary Report.
    3. Match the ending balances of the Summary Reports with those of the Detail Reports.

    For Eg:

    Match the individual source amounts of the Cost Detail Report to the detail reports :-
    A. Match additions to cost in the Asset Additions report.
    B. Match adjustments to net change in the Cost Adjustment Report.
    C. Match retirements to cost retired in the Asset Retirements Report.
    D. Match reclasses to cost in the Asset Reclassification Reconciliation Report.
    E. Match transfers to cost in the Asset Transfer Reconciliation Report.

    Similarly for other reports as well.


    Edited by: Sadanand Shenoy on Feb 1, 2013 12:18 PM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points