Receivables to General Ledger Reconciliation Report
The Receivables to General Ledger Reconciliation Report compares AR transactional and accounted balances to the GL receivables control account, flagging transactions that are unaccounted, fall outside the account range, or were posted to GL from outside Receivables. It requires the Prepare Receivables to General Ledger Reconciliation process to run first.
The question it answers
Does AR tie to the GL receivables account, and which transactions explain any difference?
Run note · BIP run High-volume GL extracts can exceed BI Publisher's online output limit and time out. Run it as a scheduled process (ESS) with output bursted to file or email rather than online preview, and bound it by ledger and period.
Run note · Performance The subledger (XLA) join — especially Projects-to-XLA — is a known BI Publisher performance trap on large ledgers. Pre-join it in the warehouse, or apply tight ledger, period, and source filters before running online.
Sample build of the Receivables to General Ledger Reconciliation Report — reconciled, and rendered tool-neutral so it runs in Power BI, ThoughtSpot, or Tableau.
| Transaction | Customer | Subledger Amount | Accounted Amount | Gl Amount | Difference |
|---|---|---|---|---|---|
| Sample | Acme Industrial | $1,240,500.00 | $1,240,500.00 | $1,240,500.00 | Sample |
| — | Northwind Trading | $842,150.75 | $842,150.75 | $842,150.75 | — |
| Sample | Globex Holdings | $96,400.00 | $96,400.00 | $96,400.00 | Sample |
| — | Initech LLC | $1,005,233.10 | $1,005,233.10 | $1,005,233.10 | — |
| Sample | Umbrella Corp | $58,720.40 | $58,720.40 | $58,720.40 | Sample |
| Sample | Acme Industrial | $1,240,500.00 | $1,240,500.00 | $1,240,500.00 | Sample |
The report aligns AR, Subledger Accounting, and GL into one view so each agrees. The Difference column should be zero once the prepare process has run for the period.
Subledger and GL tie to the penny, but 4 transactions post to an account outside the report's range — they will distort the next period's opening balance if left.
Traced via XLA_AE_HEADERS: the four sit on a misderived distribution account. Correct the AutoAccounting rule or reclass, then re-run the prepare process.
This is the report's BI Publisher data model — the SQL data set BI Publisher runs against Oracle tables to produce the output. The same SQL becomes a dbt model in your warehouse, so one definition drives both the formatted report and the analytics layer.
Data sources
The data-warehouse model — one fact surrounded by conformed dimensions (what you slice by) and measures (what you aggregate), expressed as dbt so it migrates with you. Grain: one row per source transaction.
| Element | Type | Definition |
|---|---|---|
| AR_PAYMENT_SCHEDULES_ALL | dimension | dimension |
| XLA_AE_HEADERS | dimension | dimension |
| GL_BALANCES | dimension | dimension |
| Subledger Amount | measure | measure |
| Accounted Amount | measure | measure |
| Gl Amount | measure | measure |
Every source object behind this report. Each linked table has its own page with full column descriptions, drawn from the Oracle BICC lineage and articulated for practitioners.
| Table | Reporting columns | Subject areas |
|---|---|---|
| RA_CUSTOMER_TRX_ALL | 58 | 16 |
| AR_PAYMENT_SCHEDULES_ALL | 32 | 6 |
| XLA_AE_HEADERS | 16 | 19 |
| GL_BALANCES | Setup / configuration table — joined for reference, not exposed for analytics | |