When i run my VAT detail report in QB desktop, it all looks fine. I can see VAT code entries for all entries. However, when i export this report to Excel the 'VAT code' entries do not appear for Boxes, 1, 2 and 4. They are present for boxes 6, 7 and 9. I also see the 'Item' and 'Rate' entries for 1, 2 and 4. But not for 6,7 and 9. Could someone tell me how to get round this?
If QuickBooks doesn't detect any issues with the Verify utility, then this might be an issue on how the information is reflected when exporting. In this case, run the QuickBooks PDF & Print Tool to fix this.
Thanks for the response. I have tried both proposed fixes and neither has worked. I have tried running QB on a different machine that does not have Excel installed, and the .csv that is exported shows the same problem: no VAT code in exported VAT detail report for boxes 1, 2 and 4. The codes are there on the report in QB. Very odd, if anyone has got any other ideas, please let me know
I appreciate you following the troubleshooting, MickP.
Since the steps provided has the same result, I recommend contacting our QuickBooks Desktop support. They can check your account and provide an alternative on how you can export the VAT Detail report with the data you want.
Within your QuickBooks Company file, select QuickBooks Desktop Help from the Help menu
Alternatively, you can also press F1 on your keyboard to bring up the same Help Panel below:
In order to route you to the correct support expert, we need to know what type of question you have. Give a brief description of your issue and click Continue.
Message an Agent – Allows you to chat directly to a support agent.
Talk to a Specialist – Arranges a callback from a support agent.
You can also go to our contact web page intuit.me/qbdt to message us if you cannot open your product.
Let me know if you need anything else, I'll be right here to help.