Hi Taylor
Im not really sure what you are getting at here - this appears to just show one line of items on your vat from the sage drill down facility? You can actually click on each of these to drill down further, but maybe it would be easier to suggest you click on the print facility...this opens up a further box with the option to print but better still a 'preview' function - then you can look down it and see if there is anything glaringly wrong. What is it that you think you have done wrong? One thing that stands out - should the journals be T0 or T9? T0 could be correct, but I cannot comment as I dont know what they represent. (Most of mine are T9 type transactions unless Im doing adjustments for imports to get the figures from a C79 document in for eg).

Perhaps you could provide some more information so we can try to help?

Ive never seen a VAT detailed report like this - can you please attach a copy of the VAT100 (return) screen with relevant confidential info deleted?

Any journals that are coded incorrectly will need altering - if they shouldnt be reported on the VAT return at all they will need changing to T9.

@Taylor1

Your assertion that "it should not be claiming VAT on a T0 code" is incorrect.

The settings for the tax codes tell Sage whether or not to include something on the VAT return, and where it appears will be determined by the amounts in the net and VAT fields, along with the transaction types. So you can post a payment as TO (for example) but override the tax amount of 0.00 (assuming T0 is set as 0%, and set to appear on a return) with £10. That £10 will therefore be treated as input tax on a VAT return.

In the case of a journal, if it is given a tax code that puts it on the return (such as T0) where it appears on the return depends on whether it is a journal debit or a credit (this affects the inputs and outputs) and the nominal code it is posted to: If it is posted to the inputs/outputs nominal codes, it is part of the VAT, otherwise part of the net.

If it sounds complicated... that's because it is. For most users, it shouldn't be an issue.

If memory serves, anyway.

I'm going to hazard a really off the cuff guess now, and suggest that the journals we're seeing are the result of the previous quarter's VAT journals (moving the inputs and outputs to the liability code) posted as T0 instead of T9.

(I'm sure I recall from quite a few years back a Sage update that the relevant default tax codes for such journals set to T0 instead of T9 - you may perhaps have been hit by that problem?)

If that's the problem, your best solution is to print the return out, adjust the figures and manually submit the return with the correct ones.

The setting that caused this will be something like Settings -> Company Prefs -> VAT -> Exempt tax code.