Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
nicoleam
Level 1

Why is QuickBooks Duplicating Transactions?

QuickBooks has recently began duplicating transactions, seemingly related to receipts. First, I noticed a receipt was duplicated (resulting in the PO quantity showing more was received against it than the PO total quantity allowed). This morning, I found an invoice that was duplicated (resulting in the total received on the invoice per QB being doubled.

 

The duplication is only shown in Reports --> Transaction History (i.e. the duplicate receipt doesn't appear in the report for the inventory offset account and the duplicate invoice doesn't appear in the Vendor Transactions listing) so this seems to be something going on in the backend of QuickBooks. Also, these were two different customers, different POs, etc. so doesn't seem to be isolated.

 

I'm looking for some support on this issue. Any feedback is appreciated.

13 Comments 13
Kevin_C
Moderator

Why is QuickBooks Duplicating Transactions?

I understand the importance of addressing this issue with urgency, @nicoleam.

 

Currently, we have an ongoing investigation about duplicated inventory quantities on your purchase orders in QuickBooks Desktop (QBDT). Please be assured that our Engineering Team is aware of this issue and is working hard to resolve it.

 

While we're unable to provide exact dates for when this issue will be fixed, I encourage you to contact our Technical Support Team. They will ask for your contact details to include you on the list of affected users. Once you're on the list, we'll keep you updated on the progress via email notifications.

 

Here's how:

 

  1. In QBDT, click Help.
  2. Choose QuickBooks Desktop Help or press F1 on your keyboard.
  3. Click the Contact Us button in the Have a question? window.
  4. Enter your concern in the description box and select Continue.
  5. Choose either Chat with us or Have us call you.

 

Please review our support hours to ensure we can address your concerns promptly.

 

Additionally, you can run and customize sales reports in QBDT to obtain a comprehensive overview of sales, inventory status, and product performance. This way, you can better understand your overall sales for each product and monitor stock levels more effectively.

 

If you have additional questions about managing your inventories in QBDT, feel free to add a reply below. Keep safe!

SJCbeachliving
Level 1

Why is QuickBooks Duplicating Transactions?

I'm having this problem with invoices. Quickbooks is duplicating my invoices and making 2 or 3 of each one. Did you get your problem solved?

JaeAnnC
QuickBooks Team

Why is QuickBooks Duplicating Transactions?

We're glad to have you here today, @SJCbeachliving. Let's work together to perform some troubleshooting steps to resolve your issue about duplicate invoices in QuickBooks Desktop (QBDT).

 

First, let's ensure that there are no memorized invoice transactions created. To do that, go to Lists and select Memorized Transaction List

 

If there's none, let's utilize the Verify and Rebuild tool to scan your company file for possible data damage and repair them. Here's how:

 

  1. Go to Window and select Close All.
  2. Click File, then Utilities.
  3. Select Verify Data. Once done, go back to step 2 and click Rebuild Data.

 

To ensure accurate keeping of your financial records, delete the duplicate entries. To do that, open the invoice and click Delete.

 

Furthermore, you need to enter the payment in QBDT when a customer pays for an invoice. 

 

Let me know in the comments below if you have other questions about duplicate invoices. The Community team is always willing to lend a helping hand. Stay safe, and have a good one.

LeAnn
Level 1

Why is QuickBooks Duplicating Transactions?

QBOnline is duplicating invoices in my inventory throwing everything off.  When I search for duplicate transactions, there are none showing in the sales reports.  What is causing this and how can I fix it?  Thanks.

Anonymous
Not applicable

Why is QuickBooks Duplicating Transactions?

We are glad to have you here today, LeAnn. Let’s work together to ensure the accuracy of your report. However, we need more detailed information to fully understand your concerns.

 

Could you please elaborate on the initial concern regarding QuickBooks Online (QBO) duplicating invoices in my inventory, which seems to be causing significant discrepancies? If possible, including screenshots would enhance our ability to diagnose and address the issue effectively.

 

Please note that in QuickBooks Online (QBO), duplicate invoices do not appear in the inventory list. The inventory list exclusively displays items categorized as inventory type. In contrast, invoices are reflected solely in reports related to customer and sales transactions. Understanding this distinction may help clarify any confusion in your inventory tracking.

 

In the meantime, to locate the duplicate transaction, we can use the Advanced transactions search. Please follow the steps outlined below:

 

  1. Select the Magnifying glass or Search icon at the upper right corner of your screen in QuickBooks.
  2. Click on the Advanced Transactions search.picture 1.png
  3. Enter the necessary details to locate the duplicate transaction.picture2.png

 

For more details on the Advanced transactions search, please refer to the article: Search for transactions in QuickBooks Online.

 

Additionally, I have included a link to an article that explains how to delete invoices and other transactions: How to void or delete an invoice or other transactions.

 

I appreciate any additional information you can provide, and I look forward to your response. The community is always here to help resolve your duplicate invoice issue.

LeAnn
Level 1

Why is QuickBooks Duplicating Transactions?

I'm still not clear on what is happening.  I attached a screenshot of an inventory item showing two identical invoices, yet I can't find anything duplicated using the advanced search tool.  As you can see this entirely messes with the inventory.  Thanks for any help and getting back to me so quickly.  I'm pulling my hair out trying to get items billed without correct inventory amounts.

LeAnn
Level 1

Why is QuickBooks Duplicating Transactions?

Sorry that's a screenshot earlier of yet one more problem.  Shows two different invoice numbers for the same item.  The attached shows the inventory issue.

FateCandylaneT
QuickBooks Team

Why is QuickBooks Duplicating Transactions?

Accurate recording of these entries prevents inventory discrepancies in your account, LeAnn. Let me elaborate this further.
 
In QuickBooks Online, you can check and verify the transaction on your report to make sure the invoices created are correct. Just double-click on the amounts to review the entry.
 
However, if these transactions are incorrect, you can assess your company's audit log to review any unusual activities or changes made to your file, causing these entries. To do these:

 

  1. In your QuickBooks Online account, go to the Gear icon and select Audit Log.
  2. Select the Filter panel to filter User, Date, or Events and narrow the results.
  3. Then, click Apply.
 
You can check out this guide for more inputs: Use the audit log in QuickBooks Online.
 
Additionally, you'll want to seek additional guidance from our Live Expert Assisted team to help you keep track of your overall transactions.
 
Once everything comes in handy, you can enter customer-paid invoices into your account to ensure accuracy of your sales entries.
 
Your inputs and other additional queries are valuable to us. Just leave your replies below, so we can provide further assistance when managing customer invoices in your account. Keep safe.
LeAnn
Level 1

Why is QuickBooks Duplicating Transactions?

There is nothing in the audit log that is helpful.  The duplicate transactions are identical and I have no idea why they are showing in inventory valuation detail twice.  That is what I am hoping to find out.

 

In addition the first screenshot I showed is also an issue.  Two different invoice numbers for an identical transaction.  Not sure why/how that is happening either.

AdonL
QuickBooks Team

Why is QuickBooks Duplicating Transactions?

Thank you for your efforts, LeAnn. I've got some additional details to help you identify the cause of the invoice transactions showing twice on your Inventory Valuation Detail report.

 

QuickBooks Online (QBO) reflects what's entered into the system. You can check the invoice's audit history to see when and who created it. It also provides a complete audit trail of changes made to it to help us know why they are showing twice on your report.

 

Here's how:

 

  1. Run your Inventory Valuation Detail report.
  2. Click on the duplicate invoice to open it.
  3. Hit the More actions button and choose Audit history.
  4. Review any modifications and who created them.

 

image_720.png

image_720.png

If you've confirmed that it's mistakenly added, you may want to delete it to keep your account balances and reports accurate.

 

Additionally, I encourage you to regularly reconcile your accounts in QBO, ideally every month. It will help you stay on top of your income and expenses and quickly identify mistakes. To help you with this, check out this article: Learn the reconcile workflow in QuickBooks.

 

We also offer personalized support through our QuickBooks Live Expert Assisted service. Our team of professionals can provide one-on-one guidance on best bookkeeping practices to boost your efficiency. For more information, please explore our QuickBooks Live Expert-Assisted options.

 

Our team is always willing to lend a helping hand again whenever you need further help managing duplicate transactions or any other concerns in QBO. Notify us in the comments below. Have a great day ahead and stay safe.

LeAnn
Level 1

Why is QuickBooks Duplicating Transactions?

I've done this, but when I go to sales there is no duplicate invoice.  If I delete the one showing in sales, I will lose the data.  This is my second month using QB Online so it isn't a matter of not reconciling regularly.  I need to figure out what/why this is happening to correct my inventory as well as ensure that it doesn't happen again.

 

I have printed packing slips for all the accounts that show duplicates and wonder if somehow that doesn't display twice in inventory?  I'm stumped.

Jeff_S
QuickBooks Team

Why is QuickBooks Duplicating Transactions?

I appreciate your adherence to all the instructions provided by my colleagues, LeAnne. However, printing packing slips should not create duplicate invoices. Allow me to direct you to the appropriate support team for further assistance.

 

Since the issue is still not resolved after following all the troubleshooting steps, I recommend contacting our QuickBooks live support. Our expert team can set up a screen-sharing session to help identify why there are duplicate invoices showing in your inventory report but no duplicate invoices in the sales section. They can also create a ticket for further investigation and offer additional support.

 

Here's how to contact our live support team:
 

  1. Open your QuickBooks account using your web browser.
  2. Head to the Help icon, then the Search tab.
  3. Enter Contact US in the search box.
  4. Click Contact Us.
  5. Pick the Chat or Callback option.
     


For additional information, please visit this page: QuickBooks Online Support.

 

For future reference, if you have received payment from one of your customers, you can record it in QuickBooks. It will mark your invoices as paid, ensuring that your financial records are up-to-date and accurate.

 

We’re always here to help you maintain accurate records of your financial statements, LeAnne. Removing duplicates streamlines invoicing processes and improves overall operational efficiency. Click the reply button below if you have further questions. Take care.

LeAnn
Level 1

Why is QuickBooks Duplicating Transactions?

Pretty sure I finally figured this out.  Online uses FIFO for inventory.  I just moved from the desktop version (not happily either) to the online version.  What I thought were duplicate invoices are really just split invoices in inventory valuation detail.  Apparently there is no way to change this either.  Hope this helps someone else who may be having the same issue.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us