Using the Universal Connector template

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 click 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

The 'Contact' column is the debtor or creditors company name.

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. 

Invoice Reference

The 'Invoice Reference' column is the correlating identification number or code of the invoice.

Optional Columns 

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.