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.
Export Data	Enables you to export saved transactions to an Adobe PDF document or a Microsoft Excel spreadsheet. Both documents include the reconciliation name, description, and status, the number of transactions, and the totals.
Filters	Collapse or expand your filter criteria. See "Transaction Filtering" below.
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.
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.
Filters	Collapse or expand your filter criteria. See "Transaction Filtering" below.
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.
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. This button is not displayed if you have previously retrieved transactions for the selected reconciliation.
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
	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.