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. |