When you need to get ready to use Acubiz reconcilliation function, the following tasks has to be done before. The tasks has to be done the same day due to the constant arrival of credit card transactions into AcubizEMS which can skew the reconcilliation.

The following accounts are used in this example:

VIGTIGT: All needs to be done on the same day:

The 3 important things before reconcilliation

1. The area FINANCE --> Not matched has to be empty 
2. All relevant exports (prereg, costs and invoice) must be exported from Acubiz
3. All exported files from Acubiz must be imported and posted in the ERP system.

Once the above tasks are carried out, there can be reconciled in the areas you want:

Provision for operating (costs) 10001

Go to: FINANCE --> RECONCILIATION --> COST PROVISION

Balance must be as Acubiz shows:

Provision for vendor (payment) 10002

Go to: FINANCE --> RECONCILIATION --> COST PROVISION

Balance must be as Acubiz shows:

Work with data in Excel:

If you want to work with data in Excel, you can receive the reconcilliation summary on an email:

Click on E-MAIL CONTENT

An information box appears - Press OK

You will now receive an email with the reconcilliation summary attached as a CSV file to open directly in Excel.

Example on file content opened in Excel: