Create VAT CSV showing with and without VAT

[ewacontrols]

I am trying to create a spreadsheet of my accounts from Jan to April showing all invoices with VAT and reverse charged VAT, i created a VAT return which has the amounts in showing this but when i export it gives me invoices back to 2021 and there is no coloumn showing who has and hasnt been charged VAT.

[QFSteve]

Hello @ewacontrols

I had a look at the account linked to your email.

I can see there is no HMRC account connected

I can see in the Reports > Vat Returns > Settings screen you have the vat start date see to 01/01/2022.

The software will exclude anything prior to this date, if you are running the return for 01/01/2023 - 31/03/2023 you should change this.

Also the account is set to cash accounting meaning the return looks at the payment dates rather than the invoice dates.

If an invoice is dated 01/11/2022 but paid 01/01/2023 it will be included in the Jan-Mar return.

[ewacontrols]

Thanks for your help Steve, much appreciated.