Transaction Reconciliation Fields

Here is a description of the elements on the Transaction Reconciliation page.

Transaction Line Lists

The following information is displayed above each list.

Field Description
Search box Search the list for particular transactions by entering search text in this box. The results are filtered so that only lines matching the search text are displayed. The matching text is highlighted on each line. Use the < and > buttons to cycle through selecting each transaction line in turn. Clear the search text to display all the transaction lines retrieved in the list. Note that only data displayed in the grid is matched against the search text.
Show All drop-down list Allows you to switch between displaying selected and deselected transactions lines in the list. By default all transaction lines that match the search text are displayed.
Transactions Retrieved The total number of transaction lines retrieved in this list.
Total Retrieved The total value of the transaction lines in this list.
Unreconciled The total value of all unreconciled transaction lines in this list. This value updates automatically in response to your selections.
Reconciled The total value of all reconciled transaction lines in this list. This value updates automatically in response to your selections.

Transaction Reconciliation Detail

Here are the fields and buttons that display on the Transaction Reconciliation Detail page.

Fields

Key: R – Read-only in all contexts.

Field

 

Description
Reconciliations Name   Name of the transaction reconciliation.
Description   Description of the transaction reconciliation.
Status R Status of this transaction reconciliation: "Error", "In Progress", or "Reconciling".
Outstanding Difference R Difference between the total line in both the grid and the selected lines.

Buttons

Button Description
Back to List Returns you to the Transaction Reconciliations list view.
Commit

Stores reconciliation information, such as reconciliation name and date, back to the transaction line item to show that it has been included in a reconciliation.

DEPRECATED: Commit This button is obsolete. To store reconciliation information back to the transaction line from a Lightning page, you must add the Commit button to the page.
Rerun Batch Reruns the batch after an error has occurred in the unreconciliation process.
Retrieve Retrieves transaction line data based on your filter criteria.
Save Draft

Saves the current reconciliation without committing any changes to the transaction lines. A record of the selections you have made for the current filter criteria is saved for you to refer back to or resume working on in future.

Unreconcile Unreconciles selected transaction line items in a reconciliation transaction record.

Transaction Reconciliation Window

The following fields and buttons display on the Reconcile Transactions window.

Fields

Your System Administrator can customize the columns in this window by editing the Transaction Reconciliation Columns field set on the Transaction Line Item object. The eight fields shown in the table below cannot be removed from the field set.

Field Description
Account The account for this transaction.
Document Value The value for the transaction line item.
Document Currency The document currency taken from the transaction line item.
Transaction Date Date copied from the originating document, such as the invoice or cash entry date.
Line Description The description taken from the transaction line item.
Document Number The document currency taken from the transaction line item.
Intercompany Transfer Link to the related intercompany transfer record.

Buttons

Button Description
Auto Match Settings Displays the Auto Match window, where you can select the fields to use for automatic matching.
Reconcile and Continue

Stores reconciliation information, such as reconciliation name and date, back to the transaction line item to show that it has been included in a reconciliation.

Reconcile and Finish Reconciles the selected transactions and closes the Transaction Reconciliation window.
Cancel Cancels the reconciliation and closes the window.
Close Closes the Transaction Reconciliation window. This button only displays if there are no available transactions to reconcile in one or both of the grids.

Transaction Filtering

When you retrieve transactions for reconciliation, any filters that you apply are used in subsequent transaction retrievals. You can click Clear to remove these filters. If you change the filters while reconciling transactions, the changes are saved for future transaction retrievals when you click Reconcile and Finish.

Fields

The following fields are displayed for each company on the Retrieve Transactions window:

Field Description
Account The account you want to retrieve transactions for. If you have encryption enabled in your org, you must be as specific as possible when typing the account name to ensure that the account is found. See Shield Platform Encryption for more information.
Company

The company you want to retrieve transactions from.

If you subsequently retrieve transactions for the same reconciliation, this field is read only.

GLA The general ledger account that you want to retrieve transactions for. You can select multiple GLAs from a drop-down list, or enter a From/To range.
Period The accounting period you want to retrieve transactions for. It defaults to the current period for the selected company. You can select multiple periods from a drop-down list, or enter a From/To range.

Buttons

The following buttons are displayed on the Retrieve Transactions window.

Button Description
Cancel Cancels the selections and closes the Retrieve Transactions window.
Clear Clears all data from the related company.
Copy Data

Copies the selections from the First Company to the Second Company fields.

Retrieve Retrieves transactions using the selected criteria.

Auto Match

The following fields, links and buttons display on the Auto Match window.

Fields

Field

Description

Save As Default Sets the selected fields as default criteria to use in all transaction reconciliations.
Transaction Fields The fields selected as criteria for automatic matching. You can select up to 5 transaction fields.

Buttons and Links

Button or Link

Description

Delete icon Removes the selected transaction field.
Add More Fields Adds more fields to the Transaction Fields list. You can have a maximum of 5 fields.
Apply Applies the selected criteria to the current transaction selections.