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.

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) 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) window.
2. In the Cash account field, select the bank account for which you want to import the statement.
3. In the Statement date field, either leave the current business date or select another date.
4. In the Start balance date field, select the earliest date among the dates of the unreconciled documents.
5. In the End balance date field, select the latest date among the dates of the documents listed on the bank statement.
6. In the Beginning balance field, specify the balance of the account on the start date.
7. In the Ending balance field, specify the balance of the account on the end date.

8. 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) window.

9. In the table toolbar, click Load records from file. The File upload dialog box is displayed.
10. 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.
11. 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.
    2. In the Culture field, select the locale in which the data is presented in the source file.
       Click OK in the dialog box.
    3. 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) window.
       Click OK to close the dialog box and complete the import.
12. 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) window.