Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

VAT Return Adjustments

Sage 50 general help forum - Free help and support for all general issues
Post Reply
LoopyLoo
User
User
Posts: 6
Joined: 20 Aug 2015, 08:49
Sage Version: v2014 20 UK/Europe/Africa

VAT Return Adjustments

Post by LoopyLoo » 19 Oct 2015, 13:33

Hi

I have a VAT return to complete which includes
T6 EU Services
T7 EU Products
T8 EU Standard rated purchases from suppliers in EC

Previously this has been completed in Sage and manually changed when entering on HMRC website.

How do I get the "make adjustments" set up in Sage so I can change this so Sage matches entry onto HMRC website?

I have this as a template
Image

T6 is currently set up in Sage to automatically calculate the right figures into the right boxes on the VAT return

Is there a way to do this for T7 and T8s?

LoopyLoo
User
User
Posts: 6
Joined: 20 Aug 2015, 08:49
Sage Version: v2014 20 UK/Europe/Africa

Re: VAT Return Adjustments

Post by LoopyLoo » 19 Oct 2015, 13:35

Sorry, I am using Sage 50 Accounts Professional 2014

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: VAT Return Adjustments

Post by brucedenney » 19 Oct 2015, 15:05

The standard codes for EU got extended to include T22 - T24

If an item appears on the VAT return and if it is an EC Sales or Purchase is governed by how the tax code is set up in Settings>Configuration>Tax Codes

You have set things up differently to Standard, what we need is to see those settings.

Here are the "standard" settings, perhaps you will work it out from just this.

If not post a screen shot of your config.
EU-VATCodes.png
You shouldn't need to make adjustments, everything should be in it's correct place.
Login to access the files attached to this post.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

LoopyLoo
User
User
Posts: 6
Joined: 20 Aug 2015, 08:49
Sage Version: v2014 20 UK/Europe/Africa

Re: VAT Return Adjustments

Post by LoopyLoo » 20 Oct 2015, 15:27

I haven't set this up... I've come in from June to find this but I would like to correct it for my next vat return

So if I edit the invoices/transactions I have using T20-T26 this should automatically work and calculate correctly on the VAT return, is that what you are saying?

Mine currently
Image

I do have this also if I scroll down
Image

Could you help me get this right please?

I'm fairly new to VAT anyway, so why are they splitting products and services?

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: VAT Return Adjustments

Post by brucedenney » 21 Oct 2015, 10:09

What someone has done is to attempt to set up T6 to be used "Standard Rated Purchases of Services form EU Suppliers" most people just use T24.

there are 2 ways you can approach this.

1/ You can adopt the standard. Delete T6 description and use T24 instead.
2/ You can fix the set up of T6 and continue to use T6
3/ You can fix T6 for now and use the T24 standard going forward
4/ you can do both and mix things up.

To fix the T6 configuration

Settings>Configuration>TaxCodes
select T6
Edit
Tick Box "Enable EC Code"
Select "EC Purchases"
Select "Services"
OK
Apply

I have not tested to check if this will fix things retrospectively, I suspect it will, rerun the vat return and check things are okay.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

LoopyLoo
User
User
Posts: 6
Joined: 20 Aug 2015, 08:49
Sage Version: v2014 20 UK/Europe/Africa

Re: VAT Return Adjustments

Post by LoopyLoo » 21 Oct 2015, 15:16

Thank you for the reply!

I thought the problem I had was with T7 and T8, not T6, as this is coming in on vat return on both sales and purchases (so net off), is this not correct?

As per my spreadsheet and how the codes have been set up, is it correct that on my T7 entries I should be adding this figure to box totals 2 and 4?

Why would have products and services been split with 2 different tax codes?

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: VAT Return Adjustments

Post by brucedenney » 22 Oct 2015, 09:11

The behaviour you describe is "normal" I do not understand VAT law nor am I qualified to give tax advice so I really can't explain why, all I can say is, that is what happens "normally" in Sage.

I can see your point, it looks strange to me, it ignores the amount of VAT you are charged and automatically applies 20% which seems strange.

I am assuming Sage know what they are doing and are handling the transaction correctly.


As for the separation of Services and Products this is needed for the EC Sales List.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

LoopyLoo
User
User
Posts: 6
Joined: 20 Aug 2015, 08:49
Sage Version: v2014 20 UK/Europe/Africa

Re: VAT Return Adjustments

Post by LoopyLoo » 22 Oct 2015, 12:11

Thanks Bruce!

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests