To submit your MaM Autoparts data using the Universal Connector, you FIRST need to download the Detailed Aged Receivables and Detailed Aged Payables reports from MaM Autoparts.
Login into your MaM Autoparts account by entering your User ID and Password for MaM Autoparts 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 Reports, and Age of Debt report.
In the Aged Debtors report, set the format to 'Detailed Format' and set the 'Date' to the end of the month you are completing your reconciliation for excluding all future transactions. Once you have set up the report click display.
Once the report has run click 'Export' to get the data into a CSV. Open the CSV and save it as an XLSX file.
Downloading the Purchase Ledger
From the Purchase Ledger, select Reports, and Creditors Listings.
In the Aged Debtors report, set the format to 'Detailed Format' and set the 'Date' to the end of the month you are completing your reconciliation for excluding all future transactions. Once you have set up the report click display.
Once the report has run click 'Export' to get the data into a CSV. Open the CSV file and save it as an XLSX file.
Once you have these 2 files you will be able to upload them to the Barclays LedgerShare Universal Connector. Click here for the guidelines to upload your data using the Universal Connector.
Comments
0 comments
Please sign in to leave a comment.