One moment please...
 
Exact Globe+   
 

Overview of importing account statements

Introduction

When you have sent the bank file to the bank, you will receive an electronic account statement with the executed payments. A bank file is a data file that contains information about amounts the bank has deposited or withdrawn from the company’s bank account for a specific period. This statement is then imported by selecting Finance ➔ Entries ➔ Bank/Cash and clicking the Bank import button.

The automatic import procedure will only succeed if the statement is located in the correct folder as set up in System ➔ General ➔ Settings ➔ Bank settings.

For example, if you have entered “C:\Bank\Import” in the Import directory and you work with the electronic bank statement of ABN bank from the country The Netherlands, the bank statement must be placed in “C:\Bank\Import\NL\ABN”. The 'NL' and 'ABN' folders will be automatically created.

Description

Previous

Click this to return to the previous page.

Next

Click this to go to the next page.

Rows

Type the number of rows to be displayed in each screen. If you have set the default number of rows to 50, then 50 rows will be displayed. Therefore, if you have more than 50 rows listed, the Previous and Next buttons will be enabled.

Statement date

Type or select the start date, end date or both to display the bank statements that start and end within that period. Alternatively, select All to display all bank statements.

Date import

Type or select the date range to display the bank statements that are within the import date or select All to display for all statements.

Bank Account

Type or select a bank account to display the bank statement(s) by bank account.

Buttons

Refresh

Click this to search for other file(s) from the specified import directory. If there are any, they will be displayed.

Search

If the bank statement(s) is in a different import directory, click Search to find the file through Windows Explorer.

Import

Select a bank and click Import to start the import process. If a bank statement cannot be imported, a message will be displayed at the bottom of the Import screen.

Note: This button is enabled when you select a bank statement.

Analysis

Click this to display detailed information of the file contents such as the bank account number(s), statement number(s), opening balance of the statement, the total debit and credit amount, the number of transactions per statement and more.

Note: The Analysis button is enabled when you have successfully imported a statement, or with Status = Imported.

Delete

Click this to delete the bank statement. You will see a message asking whether you want to delete the selected bank statement. Click Yes to delete the bank statement or No to return to the Import screen.

Note: You can only delete a statement that was not imported successfully, or with Status = New.

Open

Click this to open the selected bank statement file. The file is open in Notepad to allow you to check whether the data entered is correct. This option is useful when the statement is rejected. It enables you to view the statement file and verify that nothing is missing or incorrect.

Close

Click this to exit.

     
 Main Category: Attachments & notes  Document Type: Online help main
 Category:  Security  level: All - 0
 Sub category:  Document ID: 12.337.344
 Assortment:  Date: 26-09-2022
 Release:  Attachment:
 Disclaimer