Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Nancy W2022
Level 1

GJE Enteries

We received refunds from a vendor that were on the behalf of a customer. I did a deposit from the vendor and paid the customer, same $ amount, same account (Reimbursements), so that it would zero out. Problem is that when we run the Customer Income report, it shows the customer as a negative income because of the refunds I sent to them. I did a JE for the same account (Reimbursements) debit to the vendor and credit to the customer. The customer's account now works out fine, but the JE is showing a debit AND credit under the vendor and it's not zero'ing ($) out, like the customer's account is. Why would a JE show twice (+/-) under the vendor and once under the customer accounts when it's only a 2-line entry (a debit for $ and a credit for $)?

 

5 Comments 5
Jen_D
Moderator

GJE Enteries

Hello there, Nancy.

 

I want to help you out with this journal entry issue you're having in QuickBooks Desktop.

 

Can you please let me know which vendor report are you looking at where you found the double entry for the journal entry? I need this information to hep you further.

 

Unless the vendor name is added twice to the JE, then it will most likely to show the lines twice. You'll need to review the entries by clicking the transactions one at a time. You can also delete and recreate the journal entry and see if it gives you the same problem.

 

You can also run the Verify/Rebuild Utility. This will help diagnose and self-fix data issues in QuickBooks Desktop, especially on reports. Here's how to do that in QuickBooks:

 

  1. Go to the File menu then Utilities.
  2. Select Verify Data then wait until the diagnosis is done.
  3. If there are issues, proceed to rebuilding the company file.
  4. Tap File menu and Utilities again.
  5. Use Rebuild Data this time then click OK.
  6. Follow the onscreen steps to save a backup.

 

Post here again with the additional details so I can help you further. Have a good one!

Nancy W2022
Level 1

GJE Enteries

Hi Jen_D!!

 

Thank you for your response. I did the Verify Data and no issues were found. I did not do the Rebuild Data because it required a backup and only IT can do that.

 

I am using the Expenses by Vendor Detail report.

 

I have attached the reports for you to review in one Excel file with 3 tabs.

 

Tab 1 are the JE's I did and you can see they are only 2 lines each. One line hitting the customer and one hitting the vendor.

Tab 2 is the Income by Customer Detail AFTER I posted the JE's. This is $ zero - perfect!

Tab 3 is the Expenses by Vendor Detail AFTER I posted the JE's. This totals the reimbursements. It should be $ zero like the customer.

 

I really appreciate your help with this. Thanks again!

Nancy W2022
Level 1

GJE Enteries

Hi Jen_D!!

 

Thank you for your response. I did the Verify Data and no issues were found. I did not do the Rebuild Data because it required a backup and only IT can do that.

 

I am using the Expenses by Vendor Detail report.

 

I have attached the reports for you to review.

 

JE's I did and you can see they are only 2 lines each. One line hitting the customer and one hitting the vendor.

The Income by Customer Detail AFTER I posted the JE's. This is $ zero - perfect!

The Expenses by Vendor Detail AFTER I posted the JE's. This totals the reimbursements. It should be $ zero like the customer.

 

I really appreciate your help with this. Thanks again!

Nancy W2022
Level 1

GJE Enteries

Hi Jen_D,

I appreciate your response. I did the Verify Data and no issues were found. I did not do the Rebuild Data because it requires a backup and only IT can do that.

 

I attached a report with:

JE that I did to correct the reimbursements. As you can see they are 2 lines each. One to the vendor and one to the customer.

Income by Customer Detail AFTER I did the JE's - this is perfect

Expenses by Vendor Detail AFTER I did the JE's - this totals the reimbursements and shows the JE's twice (+/-). This should be $ zero like the customer report.

 

Thank you for your help with this. I really appreciate it!

Carneil_C
QuickBooks Team

GJE Enteries

Thanks for your reply, @Nancy W2022. I'll point you in the right direction of support to sort this issue with your reports in QuickBooks Desktop. 

 

I appreciate you for following the troubleshooting steps provided by my colleague above. However, since running the Verify/Rebuild data tools didn’t fix it, I recommend reaching out to our QuickBooks Desktop Support Team. They have tools to pull up your account in a secure environment and help you zero out your Expenses by Vendor Detail report.

 

Here’s how to get in touch with them:

 

  1. Go to Help, then select QuickBooks Desktop Help.
  2. Select Contact Us.
  3. Give a brief description of your issue, then select Let's talk, and then choose a way to connect.

 

To ensure that we address your concern on time, you can check our available hours when contacting our support.

 

I've attached an article you can use to learn on how to remove existing filters, as well as some information about Custom Summary and Custom Transaction Detail reports in QuickBooks: Customize reports in QuickBooks Desktop.

 

Get back to me here if you have further questions about managing your reports in QBDT. I'm very eager to help. Take care!

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

Need to get in touch?

Contact us