Exact Globe

Product Update 415: Log data available for bank statement import process

The bank statement import process can now be logged, allowing you to view the status of the bank statement import process and more information of the transaction.

New setting in Bank settings

The Data log: Bank statement import check box has been introduced in the General section at System ➔ General ➔ Settings, under the Bank settings.

With this check box selected, the logging of the bank statement import process will be enabled.

Log button available

With the Data log: Bank statement import check box selected, the Log button will be available at Cash flow ➔ Entries ➔ Import.

New screen displayed upon clicking Log button

Upon clicking the Log button, the Data log: Bank statement import screen will be displayed. This new screen displays an overview of log information of all the bank statement import processes that have been performed. The overview can be displayed in the simple or advanced mode, as explained in the following:

Simple mode

The following is an example of the overview screen in the simple mode:

The following is an example of the overview in the simple mode and when exported to Microsoft Excel:

Advanced mode

The following is an example of the overview screen in the simple mode:

The following is an example of the overview in the advanced mode and when exported to Microsoft Excel:

Allocation and matching criteria for bank statement import

The following table lists the criteria in the bank statement import that trigger the allocation and matching:

Criteria for allocation

Criteria for matching

Payment reference
Offset bank account
Offset name
Invoice number
Bank creditor
Allocation rules

Run: EREF, ID
Run: PREF, ID
Run: Allocation rules
Run 0: Offset bank account + Invoice amount
Run 1: Debtor, Creditor, Our ref.
Run 2: Debtor, Payment reference
Run 3: Creditor, Payment reference
Run 4: Bank account, Our ref., Amount
Run 5: Bank account, Creditor, Payment reference
Run 6: Debtor, Our ref.
Run 7: Bank account, Amount
Run 8: Our ref., Amount
Run 9: Payment references, Due dates
Run 10: Extra matching (This is applicable only if the Extra matching check box is selected at System ➔ General ➔ Settings, under the Bank settings)

Main Category:	Support Product Know How	Document Type:	Release notes detail
Category:	Release Notes	Security level:	All - 0
Sub category:	Details	Document ID:	28.073.609
Assortment:	Exact Globe	Date:	29-12-2017
Release:	415	Attachment:
Disclaimer