To submit your Merlin data using the Universal Connector, you FIRST need to download the Detailed Aged Receivables and Detailed Aged Payables reports from Merlin.
Login into your Profit Plus account by entering your User ID and Password for Merlin 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 Sales Ledger, select Sales Report, and Aged Debt
In the Aged Debtors report, make sure your setting matches the setting below.
Make sure that 'Report Only' is ticked so you don't re-age the debtors.
The date should be set to the period end of the current reconciliation period.
Summary/Detail should be set to 'Detail'.
Output should be set to '<Screen>'.
Once you have configured the settings, click 'Print' to run the report.
Once the report is generated it will need to be exported to Excel.
Click the export button at the top left of the report.
You will then need to save the file, the file MUST be saved as 'Data-Only'.
Downloading the Purchase Ledger
From the Purchase Ledger, select Purchase Report, and Aged Creditors
In the Aged Credit report, make sure your setting matches the setting below.
Make sure that 'Report Only' is ticked so you don't re-age the creditors.
The date should be set to the period end of the current reconciliation period.
Summary/Detail should be set to 'Detail'.
Output should be set to '<Screen>'.
Once you have configured the settings, click 'Print' to run the report.
Once the report is generated it will need to be exported to Excel.
Click the export button at the top left of the report.
You will then need to save the file, the file MUST be saved as 'Data-Only'.
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.