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

Anyone know why transactions are duplicating on the VAT transaction screen, same amount of income is showing as an invoice and separate entry for deposit?

This is then duplicating the income received
Solved
Best answer May 05, 2023

Accepted Solutions
ReymondO
Moderator

Anyone know why transactions are duplicating on the VAT transaction screen, same amount of income is showing as an invoice and separate entry for deposit?

Thanks for reaching out in QuickBooks Community, @wyattandwallacee.

 

The way transactions get reported depends on the data you've entered in QuickBooks.

 

It's possible that a bank deposit was created aside from receiving an invoice payment. This is why your transactions show duplicates in the VAT transaction screen.

 

To check, you can run the Transaction List By Customer report. This will show the list transactions that are linked to your customers account in QuickBooks. Here's how:

 

  1. Go to Reports and open the Transaction List By Customer report.
  2. Filter the report according to the data that you need. 
  3. Click Save.

 

From there, review each transactions that might cause duplicates. If needed, you can choose to delete them. However, before making any changes, it's advisable to consult your accountant. That way, we can ensure that your books are accurate.

 

To delete a transaction, simply click the amount on the report to open the Transaction window. From there, click More and select Delete. Then, click Yes to confirm.

 

Let me also share these links for additional reference about managing your VAT returns.

 

 

Please don't hesitate to reach out if you need further help in reviewing your data. The Community is always here to assist you. 

View solution in original post

1 REPLY 1
ReymondO
Moderator

Anyone know why transactions are duplicating on the VAT transaction screen, same amount of income is showing as an invoice and separate entry for deposit?

Thanks for reaching out in QuickBooks Community, @wyattandwallacee.

 

The way transactions get reported depends on the data you've entered in QuickBooks.

 

It's possible that a bank deposit was created aside from receiving an invoice payment. This is why your transactions show duplicates in the VAT transaction screen.

 

To check, you can run the Transaction List By Customer report. This will show the list transactions that are linked to your customers account in QuickBooks. Here's how:

 

  1. Go to Reports and open the Transaction List By Customer report.
  2. Filter the report according to the data that you need. 
  3. Click Save.

 

From there, review each transactions that might cause duplicates. If needed, you can choose to delete them. However, before making any changes, it's advisable to consult your accountant. That way, we can ensure that your books are accurate.

 

To delete a transaction, simply click the amount on the report to open the Transaction window. From there, click More and select Delete. Then, click Yes to confirm.

 

Let me also share these links for additional reference about managing your VAT returns.

 

 

Please don't hesitate to reach out if you need further help in reviewing your data. The Community is always here to assist you. 

Need to get in touch?

Contact us