The due date from which you want to filter transactions.
To Due Date
The due date to which you want to filter transactions.
Account
The bank account name you want to filter transactions by. 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.
Bank Account Value
The value you want to filter transactions by.
Button
Description
Retrieve
Retrieves transaction line data that meets your filter criteria.
Cancel
Abandons the search. This button is only available when it is possible to abandon the current search. For example, if the search results are not displayed promptly because a large amount of data is being retrieved.
Bank Reconciliation Detail
Key: R – Read-only; * – Mandatory field
Field
Description
Bank Account
*
Name of the bank account to which the bank statement relates.
Number of the bank account shown on the bank statement.
Bank Reconciliation Reference
*
Reference to identify this reconciliation later, normally this would be the bank statement reference.
Company
R
Company that owns this record.
Error Message
R
Displays the error message generated by the reconciliation process.
Previous Reconciliation
R
For the second and subsequent reconciliations for this bank account, this displays a reference to the previous reconciliation.
Reconciliation Status
R
Status of this bank reconciliation. Reconciliations can have one of the following statuses:
Committing
Complete
Error
In Progress
Reconciling
Statement Date
*
Date of the bank statement.
Total Running Processes
R
Displays the total number of reconciliation processes that are currently running for the reconciliation.
Bank Charges and Interest
Field
Description
Bank Charges
R
Calculated total of bank charges.
Interest Paid
R
Calculated total of interest charges paid.
Interest Received
R
Calculated total of interest charges received.
Balances
Field
Description
Bank Charges and Interest
R
Calculated total of all bank charges and interest values.
Cleared Balance
R
Opening Balance + Total Reconciled.
Closing Balance
*
Closing balance in bank account currency, as shown on the bank statement.
Difference
R
Closing Balance – Cleared Balance. This must be 0.00 when you commit the reconciliation.
Opening Balance
R
Opening balance taken from the previous reconciliation's closing balance.
Reconciled Items
R
Calculated total of all reconciled items.
Total Reconciled
R
Bank Charges and Interest + Reconciled Items.
Bank Reconciliation Charges
Column
Description
Deposit
Amount as a credit value in bank account currency.
General Ledger Account
General ledger account to which the value of this bank reconciliation charges line will be posted.
Line ID
Unique numeric identifier for this reconciliation charges line item.
Type
Type of this charges line item: "Bank Charges", "Interest Paid" or "Interest Received".
Withdrawal
Amount as a debit value in bank account currency.
Bank Reconciliation Line Items
Column
Description
Deposit
Amount as a credit value in bank account currency.
Document Date
Date of the originating document, such as the invoice or cash entry date.
Document Description
Description on the originating document.
Document Reference
Reference on the originating document.
Line ID
Unique numeric identifier for this bank reconciliation line item.
Transaction Line Item
Unique numeric identifier for the originating transaction line item.
Withdrawal
Amount as a debit value in bank account currency.
Buttons
The following buttons may display. The availability or validity of these buttons varies according to many factors, including org configuration.
Button
Description
Cancel
Cancels the current session without saving.
Commit
Commits the reconciliation, and sets its status to "Complete".
Delete
Delete the "In Progress" reconciliation.
Edit
Edit the "In Progress" reconciliation.
Save
Saves the reconciliation without committing.
Reopen
Resets the status of a "Complete" reconciliation back to "In Progress" so that you can edit it.
The following buttons are available in the Bank Reconciliation Charges section.
Button
Description
New Bank Reconciliation Charge
Create a new bank reconciliation charge line item.
The following buttons are available in the Bank Reconciliation Line Items section while the reconciliation is "In Progress". If the reconciliation is "Complete", you must reopen it before adding or removing lines.
Button
Description
Add Line Items
Displays a list view page where you can add new line items.
Remove Line Items
Displays a list view page where you can remove unwanted line items.
The process of comparing and matching transaction values against those shown on a bank statement in order to uncover any possible discrepancies. and its associated line items.