Expenses by Vendor Detail or Summary missing data

farmerbookkeeper · ‎October 06, 2020

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?

Adrian_A · ‎October 06, 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:

From the Help menu, select QuickBooks Desktop Help.
Scroll down and click Contact Us.
Enter, The reports were showing an amount difference.
Click Continue.
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!

View solution in original post

LieraMarie_A · ‎October 06, 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.

farmerbookkeeper · ‎October 06, 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 · ‎October 06, 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:

From the Help menu, select QuickBooks Desktop Help.
Scroll down and click Contact Us.
Enter, The reports were showing an amount difference.
Click Continue.
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!

farmerbookkeeper · ‎October 06, 2020

Thank you for the reply. All the reports are on an accrual basis. Phone support is a bit painful and I would like to avoid that

Topics

Training

Community

Resources

Expenses by Vendor Detail or Summary missing data