Visma.net ERP
Import bank transactions (CA306500)
Den här artikeln ger dig information om elementen du ser i det här fönstret i Visma.net ERP, till exempel fält, fältvärden, knappar och kryssrutor.
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.
Den övre delen
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. |
Tabellen
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 Kundinbetalningar (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 | 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 Bank/likvidhantering 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 Leverantörsreskontra or Kundreskontra 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. |
