How do I 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.

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: 

 NOTE: If the RTD window BC5, BC6, BH5 and BH6 as 9% with 13.5% on a separate row, upgrade to the latest version.


Return of Trading Details window.

Supplies of Goods and Services Net of VAT The value of goods and services supplied. These list by VAT rate and are included in the relevant rate box.
Acquisitions from EU Countries Net of VAT & 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 & imports) Net of VAT 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 & imports) Net of VAT 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 and are included 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: We're currently investigating an issue where T23 transactions incorrectly appear in box D4

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 + T20
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 + T41
J2 T10 + T17 + T20 + T21 + T23 + T42
H5 T31 + T33 + T47
H6 T32 + T34 + T48
P1 T1 + T24
P2 T8 + T18 + 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 + T39
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



  More support and information is available 

Get the most out of your software, stay ahead with trending topics and get answers from thousands of articles using the Sage Knowledgebase. Visit the Sage Help Centre.


[BCB:85:Support message - accounts chat:ECB]
Steps to duplicate
Related Solutions