cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
adtaylor22
Level 1

The amount for Input VAT on the VAT 100 Form differs from the balance in the VAT Control Account in the General Ledger. The 2 figures should be the same shouldn't they?

 
Solved
Best answer December 03, 2019

Accepted Solutions
Charies_M
Moderator

The amount for Input VAT on the VAT 100 Form differs from the balance in the VAT Control Account in the General Ledger. The 2 figures should be the same shouldn't they?

It's nice to have you here, adtaylor22.

 

Yes, you're correct. The figures on your VAT 100 should match with amount on your VAT Control. Here are a few reasons why there is a difference with the amounts for the two reports:

 

  • Dates for both reports are not the same. Open both reports and make sure you use the same date range for each.
  • There are backdated transactions or changes made to one you have already filed will not be included on your VAT 100 Report. To see them, you can refer to your VAT Exception Report.

Here's how to run the report:

  1. Go to Reports.
  2. Under Manage VAT section, choose VAT Exception Report.
  3. Filter the necessary information such as the Accounting method or click the Customise button for other options.
  4. Click Run report.

Keep in touch if there's anything I can help you with. I'm always around to provide further assistance.

View solution in original post

2 REPLIES 2
Charies_M
Moderator

The amount for Input VAT on the VAT 100 Form differs from the balance in the VAT Control Account in the General Ledger. The 2 figures should be the same shouldn't they?

It's nice to have you here, adtaylor22.

 

Yes, you're correct. The figures on your VAT 100 should match with amount on your VAT Control. Here are a few reasons why there is a difference with the amounts for the two reports:

 

  • Dates for both reports are not the same. Open both reports and make sure you use the same date range for each.
  • There are backdated transactions or changes made to one you have already filed will not be included on your VAT 100 Report. To see them, you can refer to your VAT Exception Report.

Here's how to run the report:

  1. Go to Reports.
  2. Under Manage VAT section, choose VAT Exception Report.
  3. Filter the necessary information such as the Accounting method or click the Customise button for other options.
  4. Click Run report.

Keep in touch if there's anything I can help you with. I'm always around to provide further assistance.

paul72
Level 8

The amount for Input VAT on the VAT 100 Form differs from the balance in the VAT Control Account in the General Ledger. The 2 figures should be the same shouldn't they?

Hi adtaylor22.

 

Depends.

Are you looking at the same date?

 

The balance in the VAT Control account is at today's date whereas, when you generate VAT100 report, you're probably looking at the end of the previous month/quarter.

 

Did you close down / file the previous quarter (which would have zeroed the VAT Control account)?

Need to get in touch?

Contact us