Reconciliation References and Journal Lines

A reconciliation reference is an identifiable reference value that's entered or populated onto related clearing account journal lines. One example is an invoice number, which identifies an invoice accrual clearing journal line and the related offsetting journal line.

The automatic clearing accounts reconciliation process uses reconciliation references, along with other factors, when determining which journal lines to group together.

Note: Clearing accounts reconciliation is based on accounted amounts, not entered amounts.

Entering Reconciliation References

Here are some of the ways that reconciliation references can be entered or populated onto journal lines.

  • When you create a journal in General Ledger, you can specify reconciliation references in the Journal Lines section on the Create Journal page.

  • You can specify reconciliation references when creating journals using spreadsheet-based tools such as, file-based data import and Oracle ADF Desktop Integration.

    Caution: Both the ledger and the reconcilable natural account segment values must be enabled for reconciliation to import the reconciliation references into GL.
  • If you're using secondary ledgers, the journal posting process in the primary ledger automatically populates reconciliation references into the propagated journal in the secondary ledger. This happens regardless of whether the secondary ledger or the natural account segment value in that secondary ledger is enabled for reconciliation.

  • When reconciliation references are included in journal lines that are reversed (manually or automatically), the resulting reversal journal is populated with the same reconciliation references. This happens regardless of whether the contextual ledger (primary or secondary ledger), or the natural account segment value, is enabled for reconciliation.

    Note: Journals aren't reversible if any underlying journal lines have already been reconciled. You must perform a reverse reconciliation to unreconcile such journal lines first. The Reversible Detail column on the Manage Journals page indicates the reason why a journal line can't be reversed.
  • You can set up Subledger Accounting to automatically populate reconciliation references on journal lines. For information about accounting attributes and journal line rules, refer to the Oracle Fusion Cloud Financials Implementing Subledger Accounting Guide. The journal import process imports the references if both the ledger and the reconcilable natural account segment values are enabled for reconciliation.

You can search for journal lines using reconciliation references and other reconciliation attributes, such as reconciliation status on the Inquire on Journal Lines page.

Note: If you opt in to the Allocation Rule Name as Reconciliation Reference feature, the allocation rule name is available as the Reconciliation Reference attribute. You can then reconcile all journal lines generated from an allocation rule as a group.