Bank Reconciliation Tool
How to use Bank Reconciliation Tool in Banking & Payments: access, working steps, fields, related records and troubleshooting.
Purpose and access
Record receipts, payments and transfers with the correct party, accounts, currency and allocation. Reconcile bank activity with ERP entries. A payment record is not a bank transfer instruction unless a separately configured integration performs that action.
This page is a settings page in Finance & Accounting → Banking & Payments. Use the link above to open the configured destination; permissions are checked by the destination service.
Before you start
Review the current settings or existing records and prepare the information needed for the change.
Confirm the company, party, dates, units and source references that apply. Select existing links carefully and check for an existing record before creating a duplicate.
Working steps
- Open Bank Reconciliation Tool from Finance & Accounting → Banking & Payments, or use ERP Search.
- Review the existing configuration before editing.
- Complete the editable fields described below. Required fields and validation conditions must be satisfied; read-only values are set by the system or their source records.
- Save the record and address validation messages. Reload and verify the saved values and relationships.
- Use any additional workflow actions only when the record and your role provide them. Saving this record does not automatically complete a related transaction or external action.
Field reference
These fields come from the installed ERP definition. Hidden fields and password inputs are omitted. Additional conditions, custom scripts and workflow rules can make a field required or read-only in a particular context.
| Field | Type / behavior | How to use it |
|---|---|---|
Companycompany | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Company |
Bank Accountbank_account | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Bank Account |
From Datebank_statement_from_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
To Datebank_statement_to_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
From Reference Datefrom_reference_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
To Reference Dateto_reference_date | Date Optional | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Filter by Reference Datefilter_by_reference_date | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Account Opening Balanceaccount_opening_balance | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Closing Balancebank_statement_closing_balance | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Troubleshooting
- Not permitted: verify the account, role and source-document permission. Do not share an administrator login.
- Missing record or address: inspect the relevant Link or Dynamic Link fields; a matching title alone does not establish a relationship.
- Cannot save or change status: review required fields, read-only values, document status and the configured approval transition.
- Unexpected report or portal result: review company/date filters, source-document submission and the approved party or Employee link.