Import bank transactions (CA306500)
By using this window, you can import bank statements or enter statement transactions. You can then manually edit transaction details if needed.
If you have processed at least one transaction from the imported statement in the Process bank transactions (CA306000) window, you cannot edit all transactions from this statement. You can clear processing for the transactions in the Process bank transactions (CA306000) window to enable the editing of transaction details on this (Import bank transactions) window.
You can restrict the uploading of bank statements for multiple cash accounts in a file by selecting the Import bank statement to single cash account check box on the Bank statement settings tab of the Cash management preferences (CA101000) window. In this case, the user should specify the particular cash account for which the upload of bank transactions from the file would be performed.
## Search line in list window If you are in the list window, the first line in the table is a search line. Each column has a search field which you can click to search for or filter on specific values and narrow down the displayed table rows. You can search and filter in as many columns as you need to, to only display the results you want to view. There are two types of search fields: + White: here you can type a specific search term to display results in this column containing this exact value. If you search on several (partial) words, you can separate them by a space or **%** and get different results: + space: the result contains the words in any order, + **%**: the result contains the words in the specific order, and the **%** functions as a wildcard as well. + Grey: you can click this to open the column filter pop-up window where you can filter the results for this column.The top part
You can use this area to select an imported statement for a particular cash account and view its data.
| Element | Description |
|---|---|
| Cash account | The cash account specified on the bank statement for which you want to upload bank transactions. |
| Ref. no. | The reference number of the imported bank statement, which the system generates automatically in accordance with the numbering series assigned to statements in the Cash management preferences (CA101000) window. |
| Statement date | The date of the bank statement specified in the file. |
| Start balance date | The start date, as indicated in the bank statement file (if any). |
| End balance date | The end date, as indicated in the bank statement file (if any). |
| Beginning balance | The balance of the cash account at the start of the date range the bank statement spans, if specified in the file. |
| Ending balance | The balance of the cash account at the end of the date range of the bank statement, if specified in the file. |
| Calculated balance | The balance of the uploaded bank statement, which is calculated as the sum of its lines. Verify that the calculated balance for the statement is equal to the ending balance of the account displayed in the Ending balance field. |
The table
This table contains the transactions imported from the bank statement. If you have an Excel file with a single statement, you can import the bank transactions for this particular statement directly to the table, by using the Load records from file standard button on the table toolbar.
If you have an Excel file with multiple statements, you can import these statements by using a scenario based on the built-in data provider for Excel files. To create this scenario, use the Manage import scenarios (SM206025) window.
| Button | Description |
|---|---|
| Unhide transaction | Clears the Processed and Hidden check boxes for the selected transaction. The transaction becomes available for processing in the Process bank transactions (CA306000) window. |
| Unmatch | Does the following for the selected bank transaction: Clears the check boxes in the Clears the following for the matched document: The Cleared check box and the Clear date field on the Financial details tab in the Customer payments (AR302000) window for the document. If a document was created to match the transaction, this document should be handled (for instance, voided or matched) manually. |
| View matched document | Navigates to the respective window where you can view details of the matched document or batch for the selected transaction. The button is available only for the matched transactions (for which a check box is selected in the |
and Processed columns, and removes the link to a matched document. The selected bank transaction becomes available for further processing in the | Column | Description |
|---|---|
| Processed | A check box that indicates to the system (if selected) that either this bank transaction has been matched to a document in the system, or a document was created in the Process bank transactions (CA306000) window to record the transaction in the system. |
| Hidden | A check box that indicates to the system (if selected) that this bank transaction has been hidden from the statement on the Process bank transactions (CA306000) window. To make the transaction available for further processing, click Unhide transaction. |
| Trans. ID | The external identifier of the transaction. |
| Ext. ref. no. | The external reference number of the transaction. |
| Trans. code | The bank transaction codes are used to define which types of transactions are reported in the bank statement. |
| Trans. date | The transaction date. |
| Trans. descr. | The description of the transaction. |
| Receipt | The amount of the receipt. |
| Disbursement | The amount of the disbursement. |
| Applied rule | The rule applied to clear a transaction in the Process bank transactions (CA306000) window. |
| Invoice no. | The reference number of the document (invoice) generated to match a bank transaction in the Process bank transactions (CA306000) window. |
| Account from bank | The bank account or IBAN from which the payment was paid for the customer transactions. In some formats, it contains the IBAN or bank account from which you have paid to the supplier. |
| Archive code | The code of the transaction in the archive. |
| Business account | The supplier or customer associated with the document, by its account identifier. |
| Business account name | The name of the supplier or customer associated with the document. |
| Entry type ID | The ID of an entry type that is used as a template for a new cash transaction to be created to match the selected bank transaction. This field is displayed if you in the Process bank transactions (CA306000) window click Create and then select Cash management in the Module field. |
| Location | The location of the supplier or customer. This field is displayed if you in the Process bank transactions (CA306000) window click Create and then select Supplier ledger or Customer ledger in the Module field. |
| Additional info | Additional information, in free text form, to complement the structured remittance information. |
| Mandate ID | The ID number for the direct debit agreement with a customer and the customer’s bank. |
| Workspace | The workspace the transaction was created in. |
| Name from bank | The name of the bank that processed the transaction. |
| Rejection message | If the import of the transaction is rejected, you can write a message connected with the rejection in this column. |
| Payee name | The payee name, if any, specified for a transaction. |
| Payment method | The payment method that was used for the transaction. |
| Payment ref. no | The reference number of the payment. |
Related pages
Concepts
Tasks
- Import bank transactions
- Import a bank statement in Excel
- Import a bank statement in OFX, QBO, and QFX formats