Hi, i have manually submitted all of my sale and purchases and am having some problems:
If i check the dashboard and add up my purchase amounts for April, May and June they are correct. So I don’t know why when i create the VAT return the figures aren’t matching up.
Please can someone help
thank you
Hello @TonyWilliamson
Are you on the cash accounting?
If so the return looks at the payment dates (the tax point) to assign invoice to the returns
For example if an invoice was raised in June but the payment has been logged in July the invoice would not show until the following period.
If the payment date has been entered in error, you can edit the date in the banking screen.
Hi, I’ve logged all payments the same month the invoice was raised so it shouldn’t be that i don’t think? And on the dashboard where the purchases invoicing chart is all the ‘invoiced’ and ‘paid’ figures match each other in each of the months (April, May and June) which suggests to me that it’s not that? From what i understand anyway!
If you click the “export” button on the screen where you prepare a VAT return it will download a CSV which details exactly which items have been included in the totals for each box. Have a look at those lists and see if you can see a pattern to the missing items, or if it has included anything like a credit note dated in the previous quarter that you processed after you had submitted that quarter’s return - “late entries” like this are automatically included in the next available return and can cause the return values to not exactly match the quarter totals.
Great thank you i will try this
hi…It looks like the VAT numbers do not match up because there may have been mistakes in how purchases were grouped or VAT rates were set. Make sure you utilise the right months (April, May, and June) and that you record input VAT correctly. If the problem keeps happening, you could try using vatcalc.dev to help you get the right numbers.