BI: GL and AP Trail Balance Reconcilation

Business Intelligence Applications 

To reconcile "Closing Amount" in Subject Areas/Reports:

1. General Ledger -> GL Balance/ Trial Balance,
2. Payables -> AP Balance/ Payments Due

Answer

The closing amount in General Ledger subject areas can be reconciled with similar trial balance report in EBS GL module.

The GL balance/Trial balance in BI is just showing closing balance of each account for each fiscal period, which should be easily obtained from EBS as well and compared.

The closing amount in AP Balance subject areas is showing the liability(AP) balance by supplier.

This cannot be directly compared with the AP Balance in GL because GL does not provide this at supplier level.

However, the grand total of AP balance in AP subject area can be compared against the AP Balance in GL.

To derive this metric, you can add up all posted liability distributions (both invoice and payment distributions posted in GL) for a given supplier, and that is the AP Balance for the supplier.