To submit your Exchequer data using the Universal Connector, you FIRST need to download the Detailed Aged Receivables and Detailed Aged Payables reports from Exchequer.
Login into your Exchequer account by entering your User ID and Password for Exchequer 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 Report dropdown, select Credit Control, Aged Debtors and Consolidated.
In the Aged Debtors report, Set the 'Age Report by' to 'months', the Date to the end of the month, and tick Back-Date to Per/Yr to exclude future transactions.
Click Ok when you are ready to run the report.
Open the report and save it as an Excel workbook (.xlsx)
Downloading the Purchase Ledger
From the Report dropdown, select Credit Control, Aged Creditors then Consolidated.
In the Aged Creditors report, Set the 'Age Report by' to 'months', the Date to the end of the month, and tick Back-Date to Per/Yr to exclude future transactions. Click Ok when you are ready to run the report.
Please ensure your report looks like the one below. The universal connector has the ability to ingest the below format in a grouped fashion.
Ensure that the report is saved in an Excel workbook (.xlsx) format before attempting to upload.
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.