Solution Properties
Solution ID:
251113164740600
Last Modified Date:
Fri Dec 05 15:19:16 UTC 2025
Taxonomy Path:
Case category//How do I...//governmental/legislative compliance
Author:
[email protected]
How to produce a Return of Trading Details
Description

How to generate an RTD in your software to enter the details on the Revenue Online Service (ROS) form on the ROS website.

If you're using Sage 50 Accounts v32.1 or below, follow our alternative article to produce a Return of Trading Details.

Cause
Resolution

Before you start

Ensure all checks are complete using our Prepare the Return of Trading Details article.

Generate the RTD values

  1. Go to VAT then select RTD.
    RTD icon in the VAT module.

    The Return of Trading Details window shows the following information: 

RTD window.

Supplies of Goods and Services Net of Postponed Accounting & VAT free imports The value of goods and services supplied. These list by VAT rate and the software includes them in the relevant rate box.
Acquisitions from EU Countries Net of VAT, Postponed Accounting & VAT free imported parcels The value of Intra EU acquisitions of goods and imported parcels where VAT doesn't apply. The breakdown by VAT rate into the different boxes is based on the VAT rate applicable in Ireland to the goods acquired.
Stock for Resale (purchases, Intra-EU acquisitions Postponed Accounting & imports)  The value of all stock purchased for resale. The breakdown by VAT rate into the different box values is based on the VAT rate applicable in Ireland to the goods.
Other Deductible Goods & Services (purchases, Intra-EU acquisitions Postponed Accounting & imports)  The value of goods purchased that you won't resell but where you can claim VAT paid as an input credit. The values list by VAT rate the software includes them in the relevant rate box. The breakdown by VAT rate into the different boxes is based on the VAT rate applicable in Ireland to the goods.
  1. In For the period, enter the dates to calculate RTD values from and to. 
  2. Click Calculate.
  3. To see a breakdown of transaction values, calculate your RTD return and click the value in the relevant box.
  4. Click Print if required, then under Report Type choose from the following options:
    • Return - If you want to print the RTD values, select this option
    • Summary - To print a detailed summary of the RTD values broken into tax codes and transaction types 
  5. Select Output as Printer then click Run, select the correct printer, then click OK.
  6. Click Save then to flag the transactions as included in an RTD.
  7. Click Yes then click Close.

You can now use the RTD report to add the relevant values onto the official Revenue RTD form.

▼ Find out how tax codes affect boxes on your RTD

In Sage 50 Accounts, the Return of Trading Details (RTD) form includes all tax rates to conform to current Revenue legislation.

To see which tax codes affect which box, refer to the table below:

  NOTE: T20, T51, and T52 appear in various boxes depending if the transaction is sales or purchases and the configuration of the tax code. Use our Default tax codes article for more information on the configuration of the codes. 

Box Default tax codes
AC5 T3 + T27
AC6 T25 + T26 + T29 + T30 + T43 + T44 + T45 + T46 
AH5 T3 + T25 + T27 + T29 + T43 + T45 
AH6 T13 + T26 +  T28 + T30 + T44 + T46
B5 T35
B6 T37 + T38 + T49 + T50
C5 T31
C6 T33 + T34 + T47 + T48
D1 T0 
D2 T7 + T17 + T19 + T21 + T23 + T41 + T42 
D4 T4 + T14 + T22
E3 T2
E4 T5 + T6 + T15 + T16
E5 T2 + T5 + T6
E6 T12 + T15 + T16
G5 T35 + T37 + T49
G6 T36 + T38 + T50
J1 T0 + T7 + T19 + T23 + T41  NOTE: T23 appears if you select the Resale checkbox when you create or edit the tax code. 
J2 T10 + T17 + T21 + T42
H5 T31 + T33 + T47
H6 T32 + T34 + T48
P1 T1 
P2 T8 + T18 + T24 + T39 + T40
PA2 T39 + T40 + T41 + T42 + T43 + T44 + T45 + T46 + T47 + T48 + T49 + T50
PA3 T39 + T41 + T43 + T45 + T47 + T49
PA4 T40 + T42 + T44 + T46 + T48 + T50
R1 T1 + T8 + T24 + T39   NOTE: T24 appears if the transaction uses T24 and is for Standard CAT Rate of 23%. 
R2 T11 + T18 + T24 + T40
Z2 T39 + T40 + T41 + T42 + T43 + T44 + T45 + T46 + T47 + T48 + T49 + T50
Z3 T39 + T41 + T43 + T45 + T47 + T49
Z5 T40 + T42 + T44 + T46 + T48 + T50
Steps to duplicate
Related Solutions