Bank Reconciliation Fields

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