To submit your Encore data using the Universal Connector, you FIRST need to download the Detailed Aged Receivables and Detailed Aged Payables reports from Encore.
Login into your Encore account by entering your User ID and Password for Encore then click Login.
When you download the reports you must open and save them as a '.xlsx' file before you upload them to the portal.
Downloading the Sales Ledger
From the Reports dropdown, go to Sales ledger -> Aged debtors list.
In the Aged Debtors list report, set the date to the end of the period you are completing the reconciliation for and match the parameters below, then click Align Printer.
On the setup, set the output to A spreadsheet (Excel) and click OK.
The report will then run.
Once the report has run, click Save As...
Save the report as an Excel Workbook (.xlsx).
Downloading the Purchase Ledger
From the Reports dropdown, go to Purchase ledger -> Aged creditors list.
In the Aged Debtors list report, set the date to the end of the period you are completing the reconciliation for and match the parameters below, then click Align Printer.
On the setup, set the output to A spreadsheet (Excel) and click OK.
The report will then run.
Once the report has run, click Save As...
Save the report as an Excel Workbook (.xlsx).
Once you have these 2 files you will be able to upload them to the Validis Universal Connector. Click here for the guidelines to upload your data using the Universal Connector.