Hi Robbie

Thanks for using Sage City.

To help me answer your query could you please answer the following:

1. Is it the journal debit (JD) or journal credit (JC) or both that has been posted with the T1 tax code?
2. Which VAT scheme are you using, e.g. Standard VAT, Vat Cash Accounting, etc?
3. What date was the journal posted with?
4. What dates are you running the VAT return for?
5. Do other transactions posted with the T1 tax code appear in the VAT return?

Regards,

Paul

Sage UKI

Hi Paul

Thank you for prompt response

1. Journal debit (JD)

2. Standard VAT

3. 28 Feb 2019, also had same issue with journal dated 31 Jan 2019

4. Dates 01 Jan 2019 to 28 Feb 2019, but will not be reconciled until quarter end 31 March 2019

5. Yes all other transactions appear, it's only journal entries that are missing

Regards

Robbie

That’s great, thanks Robbie.

The JD will appear in boxes 4 or 7 of your VAT return.

If the JD was posted to either of the Sales Tax (2200) or Purchase Tax (2201) nominal codes it’ll appear in box 4.

If the JD was posted to any other nominal code it’ll appear in box 7.

If this has answered your question please click More > Verify Answer.

Regards,

Paul

Sage UKI

Hi Paul

I agree that's where it should appear, but it doesn't, when I reconcile Box 4 to 2201 in the NL the difference that I have is the amount of the journal, which is why I was asking for help.

Any other ideas?

Regards

Robbie

Ok, thanks Robbie.

1. What is the nominal code that you posted this JD to?
2. Also, what is transaction number of this JD? You can find this from either the Activity tab of nominal code that you posted it to, or the Transactions module. 

Regards,

Paul

Sage UKI

1. The nominal code that I have used is 2201 (for the VAT element), the actual expense is 7400, I think the problem may be that I have posted the VAT on a separate line from the expense (i.e. expense on one line and another line for the VAT element). 

2. The transaction number is 42687.

I appreciate your help.

Regards

Robbie

Hi Paul

Is there any update on this?

Thanks

Thanks Robbie.

Has transaction 42687 been posted with T1, or just the actual expense?

If so, if you then open / calculate the relevant VAT return and go into box 4. If there’s a value in the T1 box of the Journal Debits column, click on it and it’ll list the transactions that make up this value. Can you see transaction 42687?

Regards,

Paul

Sage UKI

Hi Paul

Please see below screen shot of VAT return, nothing in the journal debits column

 (unable to paste screen shot)

screen shot of transactions, it appears that I used tax code T9 when I posted the journal, so user error I’m afraid. 

I will reverse and re-post, thank you for your help in identifying my user error.

Much appreciated

Regards

Hi Paul

It appears that I used tax code T9 when I posted the journal, so user error I’m afraid.

I will reverse and re-post, thank you for your help in identifying my user error.

Regards

Robbie