Import a bank statement in Excel
/visma-net-erp/help/cash-management/manage-bank-statements/import-a-bank-statement-in-excel
section
If you have an Excel file with a single statement, in the Import bank transactions (CA306500) window, you can import the bank transactions for this statement by clicking the Load records from file standard button on the table toolbar.
2026-02-19T17:09:06+01:00
# Import a bank statement in Excel
If you have an Excel file with a single statement, in the Import bank transactions (CA306500) window, you can import the bank transactions for this statement by clicking the Load records from file standard button on the table toolbar.
For more information: [Import bank transactions (CA306500)](/visma-net-erp/help/cash-management/cash-management-windows/import-bank-transactions-ca306500/).
This procedure describes how to import a single bank statement from a Microsoft Excel file directly into the table of this window.
If you have an Excel file that holds 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, you use the [Manage import scenarios (SM206025)](/visma-net-erp/help/integration/integration-windows/manage-import-scenarios-sm206025/) window.
You can adjust the sample scenario for importing bank
statements, which is available with the demo data supplied with Visma Net.
1. Go to the [Import bank transactions (CA306500)](/visma-net-erp/help/cash-management/cash-management-windows/import-bank-transactions-ca306500/) window.
1. In the **Cash account** field, select the bank account for which you want to import the statement.
1. In the **Statement date** field, either leave the current business date or select another date.
1. In the **Start balance date** field, select the earliest date among the dates of the unreconciled documents.
1. In the **End balance date** field, select the latest date among the dates of the documents listed on the bank statement.
1. In the **Beginning balance** field, specify the balance of the account on the start date.
1. In the **Ending balance** field, specify the balance of the account on the end date.
1. Click .
The system creates a blank statement and generates a reference number for it in accordance with the number series assigned to bank statements in the [Cash management preferences (CA101000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-management-preferences-ca101000/) window.
1. In the table toolbar, click **Load records from file**. The **File upload dialog box** is displayed.
1. In the dialog box, by using the **File path** field, select the file with the statement. Click **Upload** to upload the file and close the dialog box.
1. In the dialog boxes that the system brings up sequentially, proceed as follows:
1. In the **Common settings dialog box**, in the **Null value** field, type the character that is used as the null value in the source file.
1. In the **Culture** field, select the locale in which the data is presented in the source file. Click **OK** in the dialog box.
1. In the **Columns** dialog box that appears, perform mapping of the columns of the source file (the left column) to the columns available in the [Import bank transactions (CA306500)](/visma-net-erp/help/cash-management/cash-management-windows/import-bank-transactions-ca306500/) window. Click **OK** to close the dialog box and complete the import.
1. Click .
In the table, you can review the list of imported transactions and manually edit
transaction details.
You can then process the imported transactions by using the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window.
Related pages
Concepts
Tasks
Windows