The upload requires that data is presented in a standard csv file. Please note the following points carefully and take care to ensure that your file is properly formatted.
When using MS Excel to generate csv files you are advised to select the full area of the dataset and format the cells as "Text" before saving as a csv file. This will help to ensure that the file is consistently formatted.
Liberty Accounts reserves the right to charge for any support required following a failure to adhere to the guidelines in this specification.
The first line of the file should contain valid field names from the list below. Note the underscore character in place of spaces. It is not necessary to include every field in your upload file, just include those for which you have data. Note that where field data exceeds the maximum permitted size it will be truncated. Required fields are indicated with .
Right click link to save CSV starter file containing all headings for customer uploads
Right click link to save CSV starter file containing all headings for supplier uploads
This field should contain the name of the business.
This field should contain a valid title from the list below. If the title supplied is not valid it will be set to null on the record.
The first name of a contact in the business.
The last name of a contact in the business.
First line of business address.
Second line of business address.
Third line of business address.
Town of business address.
County of business address.
Postcode of business address.
This field should contain a valid ISO country code. This field is important because it is used in Liberty Accounts to assist in handling of VAT transactions. If the field is not defined the record will default to GB. If an invalid ISO code is presented the country will be set to "Not Specified".
Country | Country Code | Currency Code |
---|---|---|
UK | GB | GBP |
USA | US | USD |
Belgium | BE | EUR |
China | CN | CNY |
France | FR | EUR/td> |
Germany | DE | EUR/td> |
Netherlands | NL | EUR |
A full list of country codes is available from www.nationsonline.org/oneworld/countrycodes.htm
This field is only relevant for customers where they are invoiced in a non-sterling currency. If present this field should contain a valid ISO currency code. If the field is not defined in the upload or if an invalid ISO code is presented the value will default to GBP. Suppliers are always set to GBP.
A full list of country currency codes is available from www.nationsonline.org/oneworld/currencies.htm
An email address.
A phone number.
A fax number.
A VAT number.
This field will set default trading terms specific to the business. If a value is presented it should be one of the following 3 character codes where the numeric value indicates the terms in days. If an invalid code is presented the default terms will be set to null
A unique code that may be used to refer to the business within your organisation. Where you are importing sales documents via Bill or Invoice Upload this is code is used in your import to associate documents with the counterparty.
The code is normally issued by an external system that will later provide transactions relating to the customer or supplier for upload with the code being used to identify the customer or supplier in Liberty during the upload.
In some circumstances you may want Liberty to generate a code during the upload of a new customer or supplier. This can be achieved by entering a "+" in this field and Liberty will present the record ID as the code.
Should only contain the numeric sort code characters. If the uploaded data is more than 6 characters it will be truncated. Typically used sort code separators ("/","\","-") will be removed.
Should only contain numeric characters. BACS files require 8 characters, so account numbers with less than 8 characters should have leading zeros e.g. 00123456. For accounts with more than 8 characters surplus characters should be removed from the left of the account number. If the uploaded data is more than 8 characters it will be truncated. If the uploaded data is less than 8 characters it will be left-padded with zeros. Typically used separators ("/","\","-") will be removed.
If the uploaded data is more than 18 characters it will be truncated.
If a non-zero balance is presented an opening balance transaction will be created for the business. If a non-zero balance is presented and the business is a cash vat business the opening balance transaction amount will be split into net/vat amounts based on the standard VAT rate. The date of any opening balance transaction can be controlled using the "balance_date" field - see below. Numeric values must not include comma formatting. Negative values are indicated with a "-" prefix.
If a non-zero balance value is presented this field will control the date of the opening balance transaction. If no balance_date is presented, or the value is invalid, the date of the upload will be used. The default format for the date is: d/M/yyyy e.g. 25/1/2007 If an alternative date format is used the date_format pattern should be included in every line of the import file - see below.
Should only contain either 'True','False','T','F','yes','no', 'y', 'n'.
Used to indicate a status of membership where relevant for Gift Aid purposes. Defaults to false if not provided.
A date from which current membership or subscription starts
The default format for the date is: d/M/yyyy e.g. 25/1/2007
If an alternative date format is used the date_format pattern should be
included in every line of the import file - see below.
A date from which current membership or subscription is valid to
The default format for the date is: d/M/yyyy e.g. 25/1/2007
If an alternative date format is used the date_format pattern should be
included in every line of the import file - see below.
Notes relating to membership or subscription as required.
If using date formats different from the expected default a pattern must
be supplied using the date format patterns as specified for Java
SimpleDateFormat class.
d - day
M - month - N.B. Capital M for month (small m for minutes)
y - year
e.g.
ddMMyyyy - 25022007
d/M/yyyy e.g. 25/1/2007