Skip to main content
F
farmerbookkeeper
October 6, 2020
Solved

Expenses by Vendor Detail or Summary missing data

  • October 6, 2020
  • 1 reply
  • 0 views

Ran a report of Expenses by Vendor Summary for the period 10/1/2019-10/1/2019 and filtered on Vendor Type = Subcontractor.  We have a framing subcontractor that we have paid over $90K this year however the report (detail or summary or running for 1/1/2020-10/1/2020) has a total of $18.3K.  Get the same results when the filter is removed and run it for all vendor types.

 

The correct amount is shown for the subcontractor in the Job Costs by Vendor and Job Summary report for the period 10/1/2019-10/1/2020.  However if I filter on Vendor Type = Subcontractor no values are in the report, i.e. it is empty.

 

Every time I exit I back-up and verify data.  Ran the utility to Rebuild Data and there were no issues

 

What am I doing wrong?

Best answer by Adrian_A

I appreciate you for getting back to us, farmerbookkeeper.

 

The Job Costs by Vendor and Job Summary report depends as well on the type of reporting method. 

 

If the Report Basis were correct, yet it still showing a difference, I recommend reaching out to our Phone Support team. We have agents that can take a look at your file and verify the same amount of difference.

 

Here's how you can contact us:

 

  1. From the Help menu, select QuickBooks Desktop Help.
  2. Scroll down and click Contact Us.
  3. Enter, The reports were showing an amount difference.
  4. Click Continue.
  5. Select either Message an Agent or Talk to a specialist.

 

You can also take a look at this article for more information about Accrual and Cash basis in a report: Differentiate Cash and Accrual Basis.

 

Feel free to get back to me if you needed help. Take care!

1 reply

LieraMarie_A
LieraMarie_A
October 6, 2020

I'm here to make sure you can get the same amounts on both reports, @farmerbookkeeper.

 

Can you clarify the reporting period you tried running for the Expenses by Vendor Summary report? Let's make sure that we run the same date period for both reports to get the same data. Also, we'll have to ensure running the same report basis (see the screenshot below). 

 

I'm also adding this article to learn the different reports available in QuickBooks Desktop: Understand reports.

 

Visit me here again in the Community and keep me posted on your progress with this reporting issue. I'm determined to help you succeed.

F
farmerbookkeeperAuthor
October 7, 2020

Thank you for the reply!  There was a typo in my note and I'm sorry about that.  All reports were run for the period 10/1/2019-10/1/2020.  After my initial submission, I spot checked amounts for several vendors in Vendor Center, adding amounts on the screen, and found errors in the Job Costs by Vendor and Job Summary report too.

 

There is an approximately $1,500,000 difference between the reports (Expenses by Vendor Summary and Job Costs by Vendor and Job Summary) for subcontractors (vendor type) for the same period of 10/1/2019-10/1/2020

Adrian_A
Adrian_AAnswer
October 7, 2020

I appreciate you for getting back to us, farmerbookkeeper.

 

The Job Costs by Vendor and Job Summary report depends as well on the type of reporting method. 

 

If the Report Basis were correct, yet it still showing a difference, I recommend reaching out to our Phone Support team. We have agents that can take a look at your file and verify the same amount of difference.

 

Here's how you can contact us:

 

  1. From the Help menu, select QuickBooks Desktop Help.
  2. Scroll down and click Contact Us.
  3. Enter, The reports were showing an amount difference.
  4. Click Continue.
  5. Select either Message an Agent or Talk to a specialist.

 

You can also take a look at this article for more information about Accrual and Cash basis in a report: Differentiate Cash and Accrual Basis.

 

Feel free to get back to me if you needed help. Take care!

Terms & ConditionsAccessibility statement