Add Postponed Accounting Figures to VAT and RTD Returns-when using Sage 50 V27.0 and below
If using Sage 50 V27.0 and below, you will need to calculate the Postponed accounting figures manually and add them to the VAT Return and RTD when you complete them on ROS.
To make it easier for you Sage have created a report to help you calculate the figures you need to add to the VAT Return and RTD. This report can be installed into your sage 50 by downloading and restoring a report only backup. To do this follow the steps below:
Download and restore the Postponed accounting transaction totals by tax code report
1. Click the link here to download this backup
2. If prompted to save the file, browse to where you want to save it, for example, the Windows desktop, then click Save.
3. Open Sage Accounts and take a data only backup.
4. On the menu bar click File, then click Restore.
5. Click Browse, browse to where you saved the file, then double-click the file ACCDL112.001.
6. Below Description of data to be restored, check that it shows the following:
-Report/Layout download
-Backup of:
-Report Templates
7. To install the report, click OK. When a message appears advising you are about to overwrite data held in your company, click Yes. As this backup only contains a single report, no data is overwritten.
8. Click OK then log into Sage Accounts.
9. You will find this report in Suppliers/Reports/My Supplier reports – see below
Calculate the manual figures for your VAT Return and RTD
1. Click Suppliers then click Clear to make sure no records are selected.
2. Click Reports then click My supplier reports and select the Postponed accounting transaction totals by tax code report.
3. Click Preview and select the following criteria:
| Supplier Ref | Leave this as it is. |
| Transaction Date | Enter the dates of the VAT period you are reporting for. |
| Tax code (To to T99) | Enter the Tax code you want to report for. For example T39. |
4. Click OK.
5. VAT RETURN – From the report take the Invoice VAT balance – Credit VAT balance value and manually add it to the following box on you VAT Return before submitting: PA1
6. RTD – From the report take the Invoice NET balance – Credit NET balance value and manually add it to the following boxes for the relevant tax code on you RTD before submitting:
| Tax code | Description | Boxes |
| T39 | Standard rate ROW import (Resale) Postponed VAT | P2 / Z2 / PA2 R1 / Z3 / PA3 |
| T40 | Standard rate ROW import (Non resale) Postponed VAT | P2 / Z2 / PA2 R2 / Z5 / PA4 |
| T41 | Zero rate ROW import (Resale) Postponed VAT | D2 / Z2 / PA2 J1 / Z3 / PA3 |
| T42 | Zero rate ROW import (Non resale) Postponed VAT | D2 / Z2 / PA2 J2 / Z5 / PA4 |
| T43 | Reduced rate ROW import (Resale) Postponed VAT | AC6 / Z2 / PA2 AH5 / Z3 / PA3 |
| T44 | Reduced rate ROW import (Non resale) Postponed VAT | AC6 / Z2 / PA2 AH6 / Z5 / PA4 |
| T45 | Second reduced rate ROW import (Resale) Postponed VAT | AC6 / Z2 / PA2 AH5 / Z3 / PA3 |
| T46 | Second reduced rate ROW import (Non resale) Postponed VAT | AC6 / Z2 / PA2 AH6 / Z5 / PA4 |
| T47 | Livestock rate ROW import (Resale) Postponed VAT | C6 / Z2 / PA2 H5 / Z3 / PA3 |
| T48 | Livestock rate ROW import (Non resale) Postponed VAT | C6 / Z2 / PA2 H6 / Z5 / PA4 |
| T49 | Flat rate compensation ROW import (Resale) Postponed VAT | B6 / Z2 / PA2 G5 / Z3 / PA3 |
| T50 | Flat rate compensation ROW import (Non resale) Postponed VAT | B6 / Z2 / PA2 G6 / Z5 / PA4 |
