Return of Trading Details (RTD)

Summary

How to generate the Return of Trading Details (RTD) report in Sage Accounting.

Resolution

If you’re VAT registered, you must submit an annual return of trading details (RTD) form to Revenue. The RTD provides a breakdown of the supply of goods and services, imports and deductible inputs that apply during your financial year. This includes all Irish, Intra-EU and non-EU trade transactions.

The annual period of the RTD is generally based on your company’s accounting period for corporation tax. The due date for RTD submission is the 19th of the month following the month in which your accounting period ends. For example, if your accounting period ends on 31st August, you must submit your return by the 19th September.

In Accounting, you can use the Return of Trading Details (RTD) report to generate the RTD values of your sales and purchases for your financial year. We recommend you only generate the RTD report, once you submit all your VAT Returns to Revenue for your financial year period.

CAUTION: The RTD report only started tracking in January 2017, the earliest report which can be produced is 01/01/16 to 31/12/2016.

You can then copy the information from the RTD report to the official Revenue form. If you’re a registered Revenue Online Service (ROS) customer, you can complete this form online via the ROS website.

To generate the RTD report >

Go to Reporting, then click More then click Return of Trading Details.

TIP: The Return of Trading Details (RTD) reporting period is automatically set to run from January to December for the current year. Use the dates dropdown to change the period.

To save or print the report, click Export then choose either CSV or PDF.

The report automatically downloads.

Once the report downloads, from the menu bar click the relevant report.

Depending on how you chose to export your report, one of the following happens:

CSV – The file automatically downloads to your Downloads folder or you’re prompted to save the file. If prompted, browse to where you want to save the file then click Save
PDF – The PDF opens in a new window or tab. You can then choose to print or save the report from your browser menu

To view details of which transactions make up each of the values on the report, click Detailed Report then click CSV.

The report automatically downloads.

Once the report downloads, from the menu bar click the relevant report.
The file automatically downloads to your Downloads folder or you’re prompted to save the file. If prompted, browse to where you want to save the file then click Save.

TIP: The detailed report shows euro and cents values. However, the summary report only shows euro values and removes the cents values. You only need to enter euros on the RTD form.

Understanding the report >

The information is broken down into boxes by VAT rate over four columns:

Supplies of Goods and Services Net of VAT
Acquisitions from EU countries Net of VAT & VAT free imported parcels
Stock for Resale (purchases, Intra-EU acquisitions & imports)
Other deductible Goods & Services (purchases, Intra-EU acquisitions & imports)

Supplies of Goods and Services Net of VAT

This column breaks down the value of all goods & services supplied broken down by VAT rate.

VAT Rate	Box	Values: All Sales plus some reverse charge purchases
Exempt	E3: Sales	Home Sales of goods and services Sales of Goods & Services to EU (inc NI) B to C Sale of Services to GB B to C
Exempt	Purchases	Purchase of Services from GB/NI/ROW Purchases of Services from EU VAT Reg
0% Exports	D4: Sales	Sale o f Goods & Services to EC VAT Reg Sale of Goods & Services to ROW (inc GB B&C)
0% Home	D1: Sales	Home Sales of goods and services Sales of Goods & Services to EU (inc NI) B to C Sale of Services to GB B to C
0% Home	Purchases	Purchase of Services from GB/NI/ROW Purchases of Services from EU VAT Reg
Not Applicable	C5	Not supported.
Reduced Rate	AC5: Sales	Home Sales of goods and services Sales of Goods & Services to EU (inc NI) B to C Sale of Services to GB B to C
Reduced Rate	Purchases	Purchase of Services from GB/NI/ROW Purchases of Services from EU VAT Reg
Not Applicable	B5	Not supported.
Standard Rate	P1: Sales	Home Sales of goods and services Sales of Goods & Services to EU (inc NI) B to C Sale of Services to GB B to C
Standard Rate	Purchases	Purchase of Services from GB/NI/ROW Purchases of Services from EU VAT Reg GB B to C Sales of Services
Total	Z1	Net value of sales for the period and the sum of all the boxes above.

Acquisitions from EU countries Net of VAT & VAT free imported parcels

This column breaks down the value of Intra EU acquisitions of goods and imported parcels, where VAT has not been charged by VAT rate.

VAT Rate	Box	Values: All goods imported - both Resale and Non Resale
Exempt	E4: Purchases	Purchases from NI VAT Reg Goods Purchases from EU VAT Reg Goods & Services Purchase of Goods from ROW/ GB - Postponed VAT Purchases Import Agent - Postponed VAT
0% Home	D2: Purchases	Purchases from NI VAT Reg Goods Purchases from EU VAT Reg Goods & Services Purchase of Goods from ROW/ GB - Postponed VAT Purchases Import Agent - Postponed VAT
Not Applicable	C6	Not supported.
Reduced Rate	AC6	Purchases from NI VAT Reg Goods Purchases from EU VAT Reg Goods & Services Purchase of Goods from ROW/ GB - Postponed VAT Purchases Import Agent - Postponed VAT
Second Reduced Rate	BC6: Purchases	Purchases from NI VAT Reg Goods Purchases from EU VAT Reg Goods & Services Purchase of Goods from ROW/ GB - Postponed VAT Purchases Import Agent - Postponed VAT
Not Applicable	B5	Not supported.
Standard Rate	P2: Purchases	Purchases from NI VAT Reg Goods Purchases from EU VAT Reg Goods & Services Purchase of Goods from ROW/ GB - Postponed VAT Purchases Import Agent - Postponed VAT
Total	Z2	Net value of all imports and the sum of all the boxes above.

Stock for Resale (purchases, Intra-EU acquisitions & imports)

This column breaks down the value of all stock bought for resale broken down by VAT rate. The breakdown by VAT rate into the different boxes should be based on the VAT rate applicable in Ireland to the goods.

VAT Rate	Box	Values
Exempt	E5	All Home purchases where the VAT rate is resale and exempt Purchase of goods only in the EC, where the VAT rate is resale and exempt Purchase of goods outside the EC, where the VAT rate is resale and exempt
0% Home	J1	All Home purchases where the VAT rate is resale and zero rated Purchase of goods only in the EC, where the VAT rate is resale and zero rated Purchase of goods outside the EC, where the VAT rate is resale and zero rated
Not Applicable	H5	Not supported.
Reduced Rate	AH5	All Home purchases, where the VAT rate is resale and reduced rate 13.5% Purchase of goods only in the EC, where the VAT rate is resale and reduced rate 13.5%
Second Reduced Rate	BH5	All Home purchases where the VAT rate is resale and reduced rate 9% Purchase of goods only in the EC, where the VAT rate is resale and reduced rate 9%
Not Applicable	G5	Not supported.
Standard Rate	R1	All Home purchases where the VAT rate is resale and standard rated Purchase of goods only in the EC where the VAT rate is resale and standard rated
Postponed VAT	PA1: Purchases	Purchase of Goods from GB - Postponed VAT Purchase of Goods from ROW - Postponed VAT Purchases Import Agent - Postponed VAT
Total	Z3	Net value of all purchases for resale and the sum of all the boxes above.

Other deductible Goods & Services (purchases, Intra-EU acquisitions & imports)

This column breaks down the value of goods purchased that will not be resold broken down by VAT rate. The breakdown by VAT rate into the different boxes should be based on the VAT rate applicable in Ireland to the goods.

VAT Rate	Box	Values
Exempt	E6	All Home purchases where the VAT rate is non-resale and exempt Purchase of goods only in the EC, where the VAT rate is non-resale and exempt Purchase of goods outside the EC, where the VAT rate is non-resale and exempt
0% Home	J2	All Home and overseas purchases of goods or services where the VAT rate is non-resale and zero rated.
Not Applicable	H6	Not supported.
Reduced Rate	AH6	Home purchases where the VAT rate is non-resale and reduced rate 13.5% EC purchase of goods only where the VAT rate is non-resale and reduced rate 13.5%
Second Reduced Rate	BH6	Home purchases where the VAT rate is non-resale and reduced rate 9% EC purchases of goods only where the VAT rate is non-resale and reduced rate 9%
Not Applicable	G6	Not supported.
Standard Rate	R2	All Home purchases where the VAT rate is non-resale and standard rated EC purchase of both goods and services where the VAT rate is non-resale and standard rated
Total	Z5	Net value of all purchases for non-resale and the sum of all the boxes above.

Payment on account allocations >

The RTD includes all transactions within the current year, however unlike the VAT Return, it doesn’t include late entries or changes to entries which fall outside the year you are reporting on.

For example, if your VAT scheme is Cash Based, and you created a payment on account in the previous year, that you allocate in the current year, it won’t be picked up on your RTD as the tax point of the receipt is in the prior year.

Manual VAT adjustments and journals >

If you manually adjust your VAT Return, or post a journal that affects your VAT Return, these aren’t included on the RTD report. You must instead account for these manually and include the relevant values when you complete the RTD form or submission to Revenue.

TIP: An example of when you may have to record a VAT adjustment is, if you need to account for VAT that you forgot to record when entering the original transaction.

To identify any adjustments or journals you have posted, you should check the detailed VAT report for each of your six bi-monthly VAT Returns in the relevant financial year period.

You should then include any values you identify to the relevant boxes on the RTD submission to Revenue, as well as the values from the RTD report. You can find further information on the boxes in the Understanding the report section.

To run the Detailed VAT Report

Go to Reporting, then click VAT Returns.
Click the relevant VAT Return, then click Detailed Report. When prompted, click PDF.
Once downloaded, from the menu bar, choose the relevant report.

The PDF opens in a new window or tab. You can then choose to print or save the report from your browser menu.

Repeat for each VAT Return in the relevant financial year period.