Upload your data using the Universal Connector

Overview

‘Other Accounting Package’ is a new product that will enable you to upload your Sales & Purchase Ledger information regardless of your source accounting package. For information on supported accounting packages and whether you are eligible to use this new beta product, please message your Relationship Manager.

 

Before attempting to upload your accounts using Universal Connector, please ensure the following:

• You have exported the most recent month for your Sales Ledger and your Purchase Ledger from your accounting package. 
• You can upload these extracts directly to LedgerShare if the exports have these mandatory columns at a minimum

Mandatory Column Name	Description
Contact	The debtor or creditors company name.
Invoice Date	The date the invoice was posted in the accounting package. (This column may only contain letters and number)
Total	The amount of the credit note or invoice in the native accounting package currency. (This column may only contain numbers) If there is a sum total of all transactions at the bottom of the report/column it must be deleted
Invoice Reference	The correlating identification number or code of the invoice.

• If your package is not able to export debtors in a list format you will need to use the Universal Connector Template. 
  For a guide on using the template please click here

Accessing Universal Connector

To begin the upload process using Universal Connector you need to be logged in to the LedgerShare portal.

From within the LedgerShare portal choose the Engagement for which you wish to upload data

.

 

 

 Select your Upload Scope as Month End Reconciliation.

 

Choose the Accounting Package from the drop-down menu.

If your accounting package is not listed, please select Other Accounting Package and click Continue to access Universal Connector.

 

 

Uploading your accounts with Universal Connector

Within Universal Connector, you can select one of the known accounting packages, or select Other Package in the drop-down list and enter the name of your accounting package if prompted.

Then select the base currency of your accounting package.

Click Next.

 

You will only need to select the files to upload. To do so, follow the below steps:

• To upload your Sales Ledger Click "Select file" and browse your computer to select your sales ledger Excel report. 
• To upload your Sale Purchase Ledger Click "Select file" and browse your computer to select your purchase ledger Excel Report.
• Enter the date you are reporting up to
• Check the box to confirm the accuracy of your data
• Click Next

 

Mapping your Excel reports fields to LedgerShare values

After your files were processed you have the opportunity to see how your data was mapped and supplement or correct it.

Complete the Mapping for the Sales Ledger, click Next, and do the same for the Purchase Ledger.

Click here for the definitions of values on LedgerShare.

Note: You can not map a column to 2 different fields, if this is done the upload will fail 

Once you have done this for Sales and Purchase Ledgers, your data is submitted!