Bank Reconciliation Fields

Here is a description of the standard fields that make up a bank reconciliationClosed 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.

Filter Transactions

Field Description
From Due Date 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.
Bank Account Currency R The ISO code of the accounting currencyClosed The currency in which your company does business. A company can have more than one accounting currency. used by this bank account.
Bank Account Number R 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.

Note:

You must manually add this field to your Lightning page layout.

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 BalanceCleared 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. This field supports corporate and local GLAs.
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.
Deprecated: Commit This button is obsolete. To commit the reconciliation from a Lightning page, you must add the Commit button to the page.
Deprecated: Reopen This button is obsolete. To reopen the reconciliation from a Lightning page, you must add the Reopen button to the page.
Edit Edit the "In Progress" reconciliation.
Reopen Resets the status of a "Complete" reconciliation back to "In Progress" so that you can edit it.
Save Saves the reconciliation without committing.

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.