To submit your Sage 50 data using the Universal Connector, you FIRST need to download the Detailed Aged Receivables and Detailed Aged Payables reports from Sage 50.
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
Select the Customers tab and then select Reports.
Select the Aged Debtors tab and then select Aged Debtors Analysis (Detailed).
Make sure to select Data to Excel.
Set the transactions Date to the date to the end of the period you are completing the reconciliation.
(tick Exc Later Payments)
The Debtors report should look like the below example.
We recommend deleting unnecessary columns and only leaving the following.
- CustomerRecord.AccountReference
- CustomerRecord.AccountName
- TransactionOverview.Number
- TransactionOverview.Date
- TransactionOverview.Reference
- TransactionOverview.AgedAmount
Once the columns have been removed, the Debtor report should look like the below example.
Downloading the Purchase Ledger
Select the Suppliers tab and then select Reports.
Select the Aged Creditor tab and then select Aged Creditor Analysis (Detailed).
Make sure to select Data to Excel.
Set the transactions Date to the date to the end of the period you are completing the reconciliation.
(tick Exc Later Payments)
The Creditor report should look like the below example.
We recommend deleting unnecessary columns and only leaving the following.
- SupplierRecord.AccountReference
- SupplierRecord.AccountName
- TransactionOverview.Number
- TransactionOverview.Date
- TransactionOverview.Reference
- TransactionOverview.AgedAmount
Once the columns have been removed, the Creditors report should look like the below example.