VAT Return .csv file: Invoice Number missing

Hello,
I just noticed that the csv files that can be exported after submitting VAT returns do not display invoice numbers in the first column (breakdown of Box 1 and 6 in this case). Nothing major but thought I would flag as a field mapping might be missing in the back end? Having invoice numbers would be useful in case of audit.

thanks for taking a look
J

Hello @BSolutions

If you are on cash accounting, it is the payments that are picked up by the return not the invoices.

As an example, if you open the return and click on the magnifying glass next to box 1 you will see there are no invoice numbers shown, this would be substituted with the word “PAYMENT” and this is a link to the relevant payment.

Hi Steve,
Makes sense, I had a feeling this might be the case. Obviously each payment gets allocated to an invoice but I get the logic.
Thank you for the quick response you may close the case.
JB

This is not as obvious as you might think, the mapping isn’t necessarily one to one. You can have one payment that pays several invoices (e.g. for customers who settle monthly on account) or several part payments towards one invoice (such as deposit and balance).

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