Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowUsing QB 2011 , yes i know .....
Lately when i record a sale on the "enter sales receipt" window and i look at my Transaction detail by account report the entry shows up twice. Once with the correct amount and once with the amount of zero. Why would that be happening ?
When i click on the transaction it opens the same window and the total in both transactions is the correct total even though it shows as zero in the report.
I have attached an example of a single transaction showing twice.
Regards
Thanks for joining the Community, @Windsurfer.
I'm here to work with you in fixing this issue.
Data damage on the company file could be the reason there are duplicate transactions. Let’s run the Verify and Rebuild Data Utility tool to resolve this. Here’s how:
Rebuild Data:
1. Go to the File menu.
2. Choose Utilities, then select Rebuild Data.
3. Select OK on the QuickBooks Information window.
4. Follow the prompt to save a backup.
5. When you see Rebuild has completed, click OK.
Verify Data:
1. Go to the File menu.
2. Choose Utilities, then select Verify Data.
3. If you see QuickBooks detected no problem with your data, click OK. You can continue using the company file.
4. If Verify finds an issue with your data, you’ll be prompted to Rebuild Now or View Errors.
5. Select Close.
For more information about resolving data damage, take a look at this article: https://community.intuit.com/articles/1774819.
That should do it. Please let me know how it goes by leaving a comment below. I want to ensure this gets taken care of. Thanks for dropping by, I’ll keep an eye out for your response.
Thank you but that didn't fix the issue either.
I followed your instructions and after a reboot same result.
Hello there, @Windsurfer.
I appreciate you coming back to us for additional support and following the recommendation my colleague provided. I can share some more steps we can try to resolve your duplicate transaction problem.
For more insight, please refer to this article: QuickBooks Install Diagnostic Tool. Just a gentle reminder, these steps might or might not work since your QuickBook's version is no longer supported.
You might want to consider getting a newer version, click here for more details.
Let me know what's the result after running the QuickBooks File Doctor, Windsurfer. Just add a comment below or mention my name.
This is not the Right Report: "and i look at my Transaction detail by account report"
Run, for instance, Sales by Customer summary or detail; sales by item or item Profit reporting. Run the P&L standard or detail.
Transaction reporting is showing the details from that transaction. That's more like a Clerical Review perspective, and not Financial.
You might have a 0 line; you might have Sales Taxes enabled and this customer or this sale item is Not Subject to taxes.
Open that transaction and use Ctl Y. Here you see the underlying data flow.
Your attachment doesn't show enough details. We cannot tell you more.
For instance, if you set up that you sold Inventory Item, and you don't stock and manage inventory, that would result in a COGS activity for something not even on hand.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.