Commands on Reconciliation and Reverse Reconciliation Spreadsheets

You can use spreadsheets to manually reconcile clearing accounts and to reverse reconciliations.

Each spreadsheet has a ribbon tab with reconciliation-specific commands. The Reconcile Journal Lines spreadsheet has the Manual Reconciliation ribbon tab and the Reverse Reconciled Journal Lines spreadsheet has the Reverse Reconciliation ribbon tab.

Here are the commands that appear in both spreadsheets.

Command	What It Does
Search	Opens a search window where you can enter multiple search criteria and then run an extensive search. Note: You can also search on the various data fields within the worksheets using native Excel features.
Select All	Selects all of the displayed lines at one time for the subsequent action. If needed, you can manually deselect individual lines by clicking the specific lines in the Selection Status field.
Deselect All	Deselects all of the already selected lines at one time. If needed, you can manually select one or more lines manually by clicking the specific lines in the Selection Status field.

Here are the commands that appear only in the Reconcile Journal Lines spreadsheet.

Command	What It Does
Reconcile	Reconciles a set of selected journal lines.
Mark as Reviewed	Sets the reconciliation status for one or more selected journal lines to Reviewed. Assigns a reconciliation group, representing the review group, and a reconciliation date, representing the review date. The action of marking one or more journal lines as reviewed doesn't validate if the net difference of total accounted debits and credits is zero, or within a tolerance, or if the selected lines comply with the account matching rules. Note: Reviewed lines within a set share the same reconciliation group.
Save	Saves the changes you make to the Reconciliation Reference field.

Here's the command that appears only in the Reverse Reconciled Journal Lines spreadsheet.

Command	What It Does
Reverse Reconciliation	Fully reverses the reconciliation of every journal line that has the same reconciliation group as the journal line that was selected.