Use VAT reports in QuickBooks to check what you owe

Learn how to use VAT reports in QuickBooks Online to track how much VAT you owe. This helps ensure your VAT return is accurate before submitting it to HMRC.

There are two reports you can use: the VAT Liability report for a detailed view of taxes owed, and the VAT 100 report (also called the VAT Agency or Summary report) for a breakdown by return boxes.

The VAT Liability report shows your taxable and non-taxable sales, and how much VAT you’ve collected from customers. You can customise this report to see details by tax agency and drill down into individual transactions.

To run the report:

1. Go to Reports (Take me there).
2. In the search field, type and select VAT Liability report.
3. Select the Report period dropdown and choose the date range based on your VAT filing schedule.

If your report has opened in:

The VAT 100 report shows the summary figures for each box of your VAT return. This is the report most commonly used when preparing to submit your return to HMRC.

You can access the VAT 100 report in two ways:

Things to note:

• The report is generated based on your VAT settings.
• The values shown depend on the date range selected.
• Any backdated transactions or changes made after submitting a return (exceptions) won’t appear. To view those, check the VAT Exception Report or return to the Submit return screen.
• You can adjust the report dates to see VAT liability for earlier periods or get a breakdown of total sales and purchases over a different timeframe.

What's next?

• Need to adjust how much you owe? Here's how to add a tax adjustment for things like tax credits, discounts, or corrections.
• QuickBooks tracks your tax payment due dates in one place so you can avoid late returns and extra fees. Learn how to file your VAT return and record your tax payment.