Importing VAT data from Invoice

Hi, I have raised my invoices, checked payment dates etc all looks good but it is not importing the data from my invoice into my VAT return. I go to Reports, Select VAT, select the period, but boxes 1 - 9 are all blank.

Hello @Rob3

As you are on cash accounting the vat return will look at the payment dates of the invoices to assign them to the correct return.

I can see your payment dates are later than the return period you are doing.

image

If this was in error you can amend the payment dates in the bank window.

Hi Steve, thank you for coming back so soon - details are below but it is not importing over
Invoice 00002
Purchase Reference
Invoice Date - Issue date 14 Oct
Due date 16 Oct
Payable within days 2

also detail from invoice 1 |ssue Date|31/08/2022|

|Invoice No.|000001|
|Due Date|14/09/2022|

Hello @Rob3

I have listed the payments you have made in the screenshot above.

Invoice 00002 has a payment date of 07/12/2022.
Invoice 00001 has a payment date of 10/11/2022.

If these are incorrect find the payments in the bank and edit the dates

Hi Steve, I have not made these payments these are supposed to be invoices that I have raised on clients who have paid me, and I am expecting to pay VAT on the invoice…

Your screen shot isn’t matching mine - sorry to be a pain …

Hi Steve - Thanks I have found the Bank function and changed the date. It has now imported it into my VAT Return - Many thanks !

I don’t quite understand how it works I will have to have a play with it…

Hello Rob

Under the vat cash scheme the vat is calculated on a cash basis (the date it is paid/received)

The vat return looks at the payment dates rather than the invoice dates as a result.

Its always worth a search in the forum as this is a really common query.

Nice 1 Steve Many thanks - Yes getting to grips with it now :slight_smile:

This topic was automatically closed after 7 days. New replies are no longer allowed.