Here is a description of the standard fields that make up a bank reconciliationThe 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.
Key: R – Read-only in all contexts ; * – 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 currencyThe 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. |
| 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: "In Progress" or "Complete". |
| Statement Date | * | Date of the bank statement. |
| 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. |
| 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. |
| 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. |
| 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. |
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. |
Related Concepts
Related Tasks
Starting a Manual Bank Reconciliation
Recording Bank Charges and Interest
Selecting Transactions to Reconcile
Importing Bank Statement Details
Reconciling your Bank Statement Automatically
Managing Bank Reconciliation Details
Deleting a Bank Reconciliation
Reopening a Bank Reconciliation
Reference