You can download the Universal Connector templates:
Universal Connector Template Aged Payables
Universal Connector Template Aged Receivables
To upload using the Universal Connector you must first map your Aged Receivables and Aged Payables to the Universal Connector excel template.
Download your Aged Receivables and Aged Payables from your accounting package to excel.
Copy and Paste the respective columns of your aged reports into the template.
If your payables and receivables transactions are grouped by debtor they will need to be reformatted. Click here for the formatting guide.
Once you have filled the 2 templates for both the Aged Receivables and Aged Payables please see the link below for a guide on how to upload using the universal connector.
Upload your data using the Universal Connector
The Aged Receivables and Aged Payables template both have 5 columns: Contact, Primary Person, Invoice Date, Total and Invoice Reference.
Note: Row 2 must be in the 'General' format on excel
Mandatory Columns
Contact (Supplier/Customer company)
The 'Contact' column is the debtor or creditors company name.
This column may only contain letters and numbers.
Invoice Date
The 'Invoice Date' column is when the invoice was posted in the accounting package. The format of the 'Invoice Date' column must be Day-Month-Year eg. 27 Feb 2013, 27 February 2013, 27/02/2013.
This column may only contain letters and numbers.
Total
The 'Total' column is the amount of the credit note or invoice in the native accounting package currency. The format of the 'Total' column must be '100' for a positive and '-100' for a negative.
If there is a sum total of all the transactions at the bottom of the report/column it must be deleted
This column may only contain numbers.
Optional Columns
Invoice Reference
The 'Invoice Reference' column is the correlating identification number or code of the invoice.
This column may only contain letters and numbers.
Note: it is recommended that this is always provided when possible
Primary Person
The 'Primary Person' column is the key customer for the respective debtor or creditor. This column is not mandatory as not all debtor or creditor excel downloads provide it.
This column may only contain letters and numbers.