Reconcile VAT Return

Summary

How to check your figures on your VAT Return in Sage Accounting.

Description

When you first run your VAT Return, we recommend you review the value in each box. You can use our help guide to review where your transactions appear on the VAT Return. Read more on how the VAT return calculates.

To see the transactions that make up the value in each box, use the detailed VAT report.

Resolution

▼Detailed VAT report

Use the Detailed Report to see a transactional breakdown of each box on your VAT return.

  1. From Reports select VAT returns.
  2. Select View for the return you want to reconcile.
  3. Select Detailed Report and select either CSV or PDF.

This report shows you which transactions make up each value on your VAT return. Use it to check that everything looks right. As your review it, make sure each transaction uses the correct VAT rate and appears in the right VAT box.

▼When you find discrepancies

 If you find a discrepancy, check our guide on how the VAT return calculates. You'll see what type of transaction displays in each box based on your VAT scheme.

Discrepancies can occur for many reasons, see a list of common causes below:

  • The transaction has the incorrect VAT rate
  • You added a transaction after you created the VAT return
  • A transaction with the wrong date was entered
  • Another VAT return already includes the transaction
  • The VAT return doesn't include an incorrectly entered journal (Read how journal entries affect the VAT return)
  • Duplicate transactions

See how to fix errors for more guidance.

▼How to fix errors

Once you've identified errors, you need to correct them. Before you make any changes, delete your draft VAT Return. Now that you've deleted your draft VAT Return you can add or amend any transactions.

If you've already submitted your VAT return, read how to correct transactions included on the VAT Return.

▼Use the audit trail for reconciliation

You can also check VAT reconciled transactions by running the audit rail. When you run the report, add the VAT Reconciled column to see which transactions match.

Use this to compare against your detailed report and make sure everything looks right. 

Solution Properties

Solution ID
222001000101225
Last Modified Date
Tue Jun 02 12:02:13 UTC 2026
Views
0