Reverse Reconciliation for Clearing Accounts

You can manually reverse previously reconciled clearing account journal lines using the Reverse Reconciliation page or the Reverse Reconciled Journal Lines spreadsheet.

You can get to the page and spreadsheet in two ways:

  • Select the Reverse Reconciliation task in the Journals work area.

  • Click the Reverse Reconciliation tab on the Manual Reconciliation page.

You can reverse reconciled lines that were reconciled manually or automatically. The reversed reconciled journal lines revert to the unreconciled pool of clearing account journals, becoming available for future reconciliation processes.

Tip: Run the Reconciled Transactions report to view reconciled lines and to provide the context for reversing reconciliations.

Here's how you do a reversal:

  1. Provide a data access set, ledger, reconciliation type, and accounting period range.

  2. You can enter more search criteria like reconciliation group and reconciliation reference, to retrieve the reconciled lines.

  3. Review the search results. Depending on the search you do, you can get an expanded view of every reconciliation group.

  4. Select the check box against one or more reconciliation groups to unreconcile the underlying reconciled clearing account journals. You can't select some lines for reverse reconciliation while leaving others in a reconciled state within a single reconciliation group. If you're using the spreadsheet, select at least one journal line to reverse the entire set of journal lines within a single reconciliation group. Reversals affect the entire reconciliation group.

  5. Click Reverse Reconciliation to complete the process. The reconciliation group and the underlying journal lines are removed from the page or spreadsheet.

Note: On both the Reverse Reconciliation page and Reverse Reconciled Journal Lines spreadsheet, you can't reverse a reconciliation group if you have partial access to the underlying journal lines. In addition, you can only view the journal lines that you have access to.