EC Sales List Submission
This service pack extends the Debtors Ledger Print EC Sales List Report function in V6.0 to include an option to generate a bulk upload file in the CSV file layout HMCE_VAT_ESL_BULK_SUBMISSION_FILE defined on the HMRC website. |
The option to produce a csv file containing the EC Sales List for a selected month or quarter is available after you print a final copy of the report for that period. |
Instructions for enrolling for the ECSL service and submitting csv files to HMRC are provided on their website at EC Sales List declarations via the Internet. |
Selecting the option to produce a csv file provided by the Print EC Sales List Report function creates file with the default name ecslcoyyyynn.csv in the folder you specify. You submit that file using the browse button in the ECSL Bulk Upload window on the HMRC website shown below to locate the file after logging into the ECSL online service. |
|
If you operate multiple Debtors Ledgers for the same company on the same hard disk, it is strongly recommended that you use a separate holding directory for the files output by each ledger. The name of the file, ecslcoyyyynn.csv, is constructed as follows:
Please Note: If your file for a particular month/quarter exceeds 900KB you will need to contact HMRC for assistance in supplying the information for that period. It is recommended that you retain your copy of this file after submission to HMRC. |
The EC Sales List report function in Debtors Ledger V6.0 has been revised to allow reprinting of lists for EC Sales List months and quarters closed after this service pack has been applied. |
Users of versions of Global 3000 Debtors Ledger earlier than V5.0 who have been supplying their EC Sales List to HMRC on plain paper format schedules are advised that from 31st July 2006 they will need to manually enter the information on the HMRC website or contact their reseller for details of upgrades to more recent versions of Global 3000 Debtors Ledger that offer the bulk upload facility. |
EC Sales List
Sales List Details |
|
Frequency |
(Display only). This is either Monthly or Quarterly depending on how frequently you submit your EC sales lists. |
Please note |
If the frequency has not been established previously, a window is displayed explaining both frequency and end date and asking you to establish their initial values. |
Current end date |
(Display only). This is the end date of the current EC sales list Month or Quarter depending upon the frequency selected above. |
Please note |
Quarter end dates are fixed as 31st March, 30th June, 30th September and 31st December. Month end dates are fixed as the last day in the calendar month. |
Report Selection |
|
For period ending |
(If you have not printed a final EC sales list previously, this is set automatically to the current end date and skipped) This shows the end date of the EC sales list reporting period to be processed. If you have produced final EC sales lists for earlier periods and the transactions for them are all still on record, press the drop down on the field to select from a list showing the end date of the current reporting period and the end dates of all previously finalised reporting periods. |
Please note |
The list contains end dates of all EC reporting periods closed since the EC sales list reprint feature was introduced. |
Type |
(If you have chosen to reprint a previously finalised EC sales list, this is set to "Final" and skipped) Set this to "Draft" if you want to produce an interim sales list for the current EC sales list reporting period. Set this to "Final" to produce the finalised report for the current EC sales list period. |
If you choose to print the final report for the current EC sales list period, the current period is closed on completion of the process and the next reporting period opened automatically. The frequency and end date of the new reporting period are derived from those of the closing period. |
|
If the EC sales list frequency is monthly, the EC sales list quarter is automatically incremented when the third month in the quarter is closed. |
|
Transactions dated on or before the end of a closed period that are added to the ledger after the period is closed are processed in the EC sales list for the newly opened month/quarter. |
|
Bulk Upload |
|
Generate CSV? |
(Only if you are printing a final report.) Set this to generate a CSV file for submission using the HMRC bulk upload facility. |
Suppress print? |
(Only if you are generating a CSV file.) Set this to avoid printing a plain paper submission in addition to generating a CSV bulk upload file. |
Save-as |
(Only if you are generating a CSV file.) If you are operating in a GX environment (indicated by the existence of a browse button to the right of this field), Save-as shows the CSV file to be generated for bulk upload and the folder in which it is to be created. The path is displayed in the standard format "folder\filename.csv". Use the browse button to change the folder in which the file is to be generated or the name of the file itself. |
Please note |
The default folder is the one used last time an EC sales list bulk upload file was generated and the default filename is ecslcoyyyynn.csv where "ecsl" indicates the class of file, "co" is the two character id of the company for which the file is being generated, yyyy is the calendar year in which the sales list reporting period falls and nn is 01 – 04 for quarterly reports and 01 – 12 for monthly reports. |
For V5.0 users |
If you are operating in a non-GX environment, the browse button will not be present. In this environment, the folder in which your CSV will be generated is fixed as .\temp in the GSM folder on your central server and the Save-as field here holds just the name of the CSV file to be generated defaulted as described previously. You can modify the name of the file, but whatever file you specify will be stored in the fixed folder on your server. |
Contact name |
(Only if you are generating a CSV file.) Enter the name up to 35 characters in length that is to be used as the contact name in the header of your CSV file. The default name is the one used last time an EC sales list bulk upload file was generated for this company or the company name if this is the first generation. |
Please note |
Any characters outside the valid character set accepted by the bulk upload facility (e.g. ampersand) will be rejected and you will need to replace them. Smith & Jones Ltd will need to be set to Smith and Jones Ltd. Embedded spaces are removed in the submission file. |