Welcome to the Community Space, David.
The VAT 100 report focuses on VAT-related data and does not include additional details, such as expense accounts. You'll want to consider generating other reports to dig into your expenditures.
This report, also known as the VAT Agency Report, provides a summary of information for each box on the VAT return. Its primary purpose is to meet HMRC requirements for documenting VAT-related activity and ensure compliance, which is why it focuses on numbers directly related to VAT reporting (net sales, VAT on sales/purchases, etc.). You can click on the amount in Box 7 under the Total column to see the applicable rate.
Alternatively, you can run a VAT Detail Report or create a custom one to get a breakdown of your Expense accounts. This allows you to analyze the purchases along with their associated expense accounts.
Check out this article to understand VAT codes more and learn how to apply them to your sales and purchase forms.
We're here to ensure that your financial reports are accurate. For further assistance with VAT reports, click the Reply button so we can get back to you.
