To make it easier for you we have created a report to help you calculate the figures you need to add to the VAT Return and RTD.
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. |
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 |
7. PA1
For businesses selling goods to the UK, excluding those using the Northern Ireland protocol, you should now treat this as a sale to a non-EC country.
For this you would normally use the zero rated export of goods to customers outside EC tax code, T14.
When trading goods with Northern Ireland, to avoid a hard border, the Northern Ireland protocol has been introduced.
Under the Northern Ireland protocol, buying goods located in Northern Ireland should continue to be treated like intra-community acquisitions after 1 January 2021.
Under the Northern Ireland protocol, selling goods to Northern Ireland should continue to be treated like intra-community dispatches and distance sales after 1 January 2021.
There is no change in the way you buy and sell services to and from the UK. However, you must change your vat codes to outside the EU
e.g. If you are selling a service currently they should be using T22 Sales of services to VAT registered customers in EC which should now be T14 Zero rated export of goods to customers outside EC. This would be the same for T23 Zero rated export of goods to customers outside EC.
The following two reports show how long it’s taken for an invoice to be paid and calculates the average number of days taken to pay per customer or supplier.
A common request is to add a total to these reports to show the average number of days taken to pay across all invoices. This article takes you through how to add a total for the average days to pay invoices on the Time Taken To Pay Sales Invoices report and also the Time Taken To Pay Purchase Invoices report as the method is the same.
1. Customers or Suppliers > Reports > Credit control reports.
2. Select the required report > Edit.
1. ACCOUNT_REF Footer > right-click the expression Average_Days_To_Pay > Copy > Report Footer > right-click > Paste.
2. Properties pane > Reset Section > check that Report Footer is selected.
1. Report menu > Report Properties > enter a new report name and description > OK.
Report Designer v1.3 and below – Report Explorer pane > select report name at the top > Properties pane > Name > enter a new report name > Enter.
You can check your Report Designer version in Help > About > Application > File Version.
2. File > Save As > select correct folder > File name > enter a new file name > Save.
3. File > Exit.
Sage Report Designer contains many features designed to help you amend and design reports within Sage Accounts.
This article provides quick steps for the most commonly used features, plus links to the more detailed articles available in Ask Sage.
The Sage Report Designer desktop displays the Designer view of the report, showing the sections, text and variables which make up the report. To the left and right of the report design are various panes which provide much of the functionality within Sage Report Designer.
If any of the panes mentioned in this article are not visible, open the View menu and select the required pane. If the pane doesn’t appear, you can reset the Report Designer view to its default.
For information about the additional menu options in Sage Report Designer, please refer to article 27235.
To add bar codes
This feature is available in Sage 50 Accounts 2010 and above and Sage Instant Accounts v16 and above.
To return to the mouse pointer, from the Toolbox menu choose Pointer.
For further information about adding bar codes, please refer to article 24964.
To add boxes
To return to the mouse pointer, from the Toolbox menu choose Pointer.
For further information about adding boxes, please refer to article 12639.
To add conditional properties
For further information about Conditional Formatting, please refer to article 12679.
To add criteria
For further information about setting criteria, please refer to article 25638.
To add email settings
For further information about email settings in Sage Accounts 2013 and above, please refer to article 29207. For further information about email settings in Sage Accounts 2012 and below, please refer to article 12659.
To add expressions
To return to the mouse pointer, from the Toolbox menu choose Pointer.
For further information about creating user defined calculations, please refer to article 12650.
To add filters
For further information about filters, please refer to article 12648.
To add groups
For further information about adding groups, please refer to article 12654.
To add images
Tip: A linked image links back to the original image file, so any subsequent changes to the original file are reflected in your document. An embedded image remains the same on your document, even if the original file is later amended.
To return to the mouse pointer, from the Toolbox menu choose Pointer.
For further information about adding images, please refer to article 12676.
To add lines
To return to the mouse pointer, from the Toolbox menu choose Pointer.
For further information about adding lines, please refer to article 12639.
To add page headers and footers
For further information about adding sections, please refer to article 12661.
To add sorts
For further information about sorts, please refer to article 12641.
To add sub reports
This feature is available in Sage Accounts 2011 and above.
To return to the mouse pointer, from the Toolbox menu choose Pointer.
For further information about adding a sub report, please refer to article 26016.
To add text
To return to the mouse pointer, from the Toolbox menu choose Pointer.
For further information about adding text, please refer to article 12638.
To add variables
For further information about adding variables, please refer to article 12638.
To change group or section properties, including section filters
For further information about changing section properties, please refer to article 12662.
To change page margins
For further information about the page setup window, please refer to article 12585.
To change paper size and orientation
For further information about the page setup window, please refer to article 12585.
To change print adjustments
For further information about Printer Offsets, please refer to article 12586.
To change print setup
For further information about the page setup options, please refer to article 12585.
To change printer
For further information about the page setup options, please refer to article 12585.
To change properties of an object
For further information about object properties, please refer to the following articles:
12646 Report Designer – How to amend date or time object properties
12658 Report Designer – Numeric Formatting
12584 Report Designer – How to create and use styles
To move an object
For further information about moving objects, please refer to article 12647.
To rename a report
For further information about renaming a report, please refer to article 16965.
To save
To save as
The Report Designer v4.0.140 update is available for Sage 50 Accounts v23.2 and v24.0, and Sage 50 Payroll v23.0.101 and above.
This update improves the functionality for sending Sage reports to Excel. Once you install the update, the Report Browser window contains the following three options for sending reports to Excel:
1. On the computer that has Sage 50 Accounts or Sage 50 Payroll installed, click the download link below.
Download Report Designer V4 update
Depending on your Internet browser, the file saves to your Downloads folder or you’re prompted to save the file.
2. If prompted to save the file, browse to where you want to save it, then click Save.
1.Browse to your Downloads folder, or the folder where you saved the download.
2. Double-click the downloaded file, Sage.ReportDesigner.Update.4.0.140.msi