Make ready for reconcilliation

When you need to get ready to use AcubizEMS 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:

1. The area FINANCE --> Not matched has to be empty (As of version 7.20 the transactions in NOT MATCHED is not included in the reconcialliation value)
2. All relevant exports shall be exported from AcubizEMS
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: