Video: using a CSV file to create a goods record on the TSS

Find out how to import up to 99 goods records to a declaration by uploading a CSV file.

Using a CSV file to create a goods records on the TSS

Transcript

 Welcome to this demonstration of using a CSV file to upload goods records onto various declarations on the Trader Support Service.  

This demonstration will show you the guidance available for using this feature, where to download a CSV template from, an example of a completed CSV file, and how you upload them. 

Once on the TSS homepage, navigate down to Guidance and then View All Topics.   

Navigate to Using Systems and locate the CSV guidance. 

This guide explains how CSV can be used, including what declaration options currently contain this feature. For entry summary declarations, this also includes having the CSV option when using consignment first. 

Note that as the service is still being developed, more declaration types may be added in the future. 

In the How to Use a CSV File section, you can download the CSV template onto your computer. 

Once opened, you will find the various headings for the template that will need completing. To find out what information needs to go into these headings and know the format and character allowance for each column, refer back to the guidance to help you complete it. 

The more information you include in the template, the less you will need to do once the file has been uploaded. This includes adding in document codes and additional information codes. 

If you do not have all the information to complete the template or where certain fields will not apply to your movement, you can leave them empty and the upload will still work. 

This will mean that any fields that are missing can then be completed directly on your declaration rather than having to add the missing details onto the template and re-uploading again. 

A note to remember that only 99 goods records can be added to one declaration. 

You can upload multiple files so long as they do not exceed 99 records. 

To upload, go to your declaration. 

Then, within the consignment, where you need to start a goods record, you'll find the Upload CSV button. In this demonstration, the declaration shown on screen is the combined entry summary declaration and customs information. 

In this case, the goods are not controlled, so the customs information is the entry in customs records, also known as the IDR. 

After selecting Upload CSV, select Upload Multiple Goods Records and then Choose File to then select from the list. 

Note that the file type must always be .CSV.

If it is any other file type, the upload will not work. 

Once the file is selected, click Upload and Continue. 

This will generate your goods records. 

You can then open each record and make any amendments as needed.   

If nothing is required, simply click Confirm Goods Records Are Complete to then add those goods records to your declaration. 

If you need to add more, select Upload Multiple Goods Records and repeat the process. 

In this example, we will upload another CSV file with the goods description missing from one record. 

When the second file is uploaded, the service will then tell you if anything is missing. 

In this example, it's showing that some goods records are missing information. 

You need to scroll down and find where that missing information is. 

In this case, it's missing a description for item eight. 

You'll click on that, find the goods description, enter the missing information. 

Select Continue, Save and Continue, and that then adds the missing information to the goods description. 

If nothing else is missing, you can complete and save and do final checks on your goods records. 

When you're happy, you can press Confirm Goods Records Are Complete. 

These will then add all of these goods records to your declaration. 

You can then proceed to make final checks and then submit your declaration. 

This is the end of the demonstration. Thank you for watching.