Hello
I'm running into problems with cash basis expense reports not including transactions that should be shown with the selected date range. It only shows cash basis expenses if both the bill and the bill payment are within the date range. The expected behavior is that a cash basis report should show a payment regardless of when the bill was received or whether or not the bill is also in the filtered date range.
The specific report I'm trying to work with is: Reports > Job Costing > Job Costs By Vendor And Job Summary in Quickbooks Desktop Premier Contractor Edition 2020.
Here's an example: Bill entered on 12/1/21 but paid on 1/15/22. I would expect a cash basis report for January 2022 to include this bill payment, but it does not. A cash basis report for December 2021 also does not show this bill payment. Only a cash basis report that includes BOTH December 2021 AND January 2022 shows the expense correctly in January 2022.
See the below example bill, bill payment, and reports. The 3 reports are filtered exactly the same except for date ranges.
Here's why it matters: I need to show expenses per Vendor and per Customer/Job within a specific date range for insurance purposes. If my insurance period is 5/1/21 - 5/1/22, I need to show the exact amounts actually paid within that range to each Vendor AND broken down by Customer/Job. The bill date is irrelevant. What I actually need is to filter by Job Type, but that does not appear to be an option so I'm filtering by Customer/Job as a compromise.
Solved! Go to Solution.
So, on review, by actually testing QuickBooks I figured out the bug in the report. It was not that hard.
The issue is:
If the product of the customer list count and the vendor list count is more than 10,000, then the report breaks and does not include bills from outside of the report period even if they are paid during the report period.
This is why the report works when testing the a tiny sample company, but not in real company files.
Here are the results I found in a test company, set up from scratch (and not corrupted), when adding and deleting Vendors and Customers and checking the report as I went:
All of the "Job costs by..." reports are broken in the same way, probably because they're all based on the same buggy internal report structure.
So, if you're having problems with these reports on a cash basis, use the F2 dialog to determine if your customer list count * vendor list count is > 10,000. If so, then that's why.
Where do you access that report? I'd like to try it, but I can't find it anywhere on my Reports menu. I tried using multiple QB versions, up to 2022...
Using the Reports dropdown menu at the top, it's at Reports > Job Costing > Job Costs By Vendor And Job Summary. Perhaps it's exclusive to contractor edition? It's not a custom report I saved or anything.
However if you know a different report that would serve the purpose I mentioned at the end of my post, I'd gladly use something else.
Thanks for getting back here in the thread, @JABUIL. I'll be pleased to share the steps so you can get through this and show the needed data in your report in QuickBooks Desktop (QBDT).
You can consider running a Profit & Loss by Job report, and filter it to show the data that you need. To begin, here's how:
Additionally, I've got you this article in case you'd like to set up and modify scheduled reports in QBDT: Set up and modify Scheduled Reports.
You may also check this article in case you'd like to export reports as Excel workbooks in QBDT: Export reports as Excel workbooks in QuickBooks Desktop.
If you need assistance performing specific tasks in QuickBooks Desktop, feel free to post here in the Community space. Our dedicated QuickBooks Team is always ready to help you. Take care, and stay hydrated!
How about running a Transaction List by Vendor report? (Reports > Vendors & Payables > Transaction List by Vendor).
You can filter that report by Vendor, Job Type, Customer:Job, and Paid Status over any timeframe. Those are all of the filter criteria you mentioned.
No, that doesn't work correctly. Vendor and Customer:Job are both filtered by "Name", not separately. So for example, if I choose names "Vendor A" and "Customer Z", it does not show me only those payments to Vendor A for Customer Z, it instead shows me ALL Vendor A transactions. Picking a Customer:Job in the Name filter doesn't affect the report at all.
Same for filtering on Job Type. If I pick a Job Type to filter by, no transactions are shown at all.
That doesn't address my needs. This filters by Account and Customer. Account and Vendor are not synonymous.
I need to show payments made to specific Vendors (cash basis) for only specified Customers or Job Type.
The report I was trying to use (Job Costs By Vendor And Job Summary) serves this purpose, I just need it to actually function correctly. Do you have any ideas for fixing the date filtering issue I explained?
Hi there, @JABUIL.
Thank you for getting in touch with us. Allow me to chime in and help you get your desired report.
The closest way to show payments to a specific vendor for a specified job is to run the Job Costs by Job and Vendor Summary report. This report lists the job costs you have incurred for each vendor and subtotaled by each job. You can click on the vendor's total under that job to drill down its transactions.
Please take note that the cash basis only recognizes income and expenses when cash is received or paid. When using this method, you'll have to select the period you paid these transactions. You may also toggle to accrual, add the Paid Status filter and select Closed.
Here' show:
After that, you'll want to save this report for future use. This saves you time as you don't have to perform all the customizations gain.
Keep me updated on how these steps help you. I want to make sure you can get the information you need.
@LieraMarie_A RE: The closest way to show payments to a specific vendor for a specified job is to run the Job Costs by Job and Vendor Summary report.
I don't have that report. I've tried multiple SKU's including Contractor, using multiple version-years including 2022. I don't have any of the "Job costs..." reports. The whole section is missing.
What does it take to make that report/group of reports appear on the Reports menu?
Hi there, @BigRedConsulting.
QuickBooks Premier Contractor and Accountant editions offer a wider range of job costing reports. If you're using the Accountant edition, you can find them using these steps below:
For your reference, check out this article: Track job costs in QuickBooks Desktop.
Thanks LieraMaria_A, but that doesn't solve my issue. As I mentioned in the opening post of the thread, I'm already trying to use that report but the date filtering does not function correctly:
"It only shows cash basis expenses if both the bill and the bill payment are within the date range. The expected behavior is that a cash basis report should show a payment regardless of when the bill was received or whether or not the bill is also in the filtered date range.
Here's an example: Bill entered on 12/1/21 but paid on 1/15/22. I would expect a cash basis report for January 2022 to include this bill payment, but it does not. A cash basis report for December 2021 also does not show this bill payment. Only a cash basis report that includes BOTH December 2021 AND January 2022 shows the expense correctly in January 2022."
If the date filtering worked correctly, the Job Costs By Vendor And Job Summary report would solve my problem entirely.
Can you reproduce the behavior in the example I gave? How can I make the date filtering work correctly?
Thanks for your patience, @JABUIL. I know how it feels when something isn't working as intended. Rest assured, I'll help you get through this.
Since you've already tried all the troubleshooting processes provided by my colleagues. I'd request you to contact our Technical Support team. This way, an agent can do a screen share with you and see what's causing the filter date not to function correctly.
Here's how you contact our Desktop support team:
You may check out our support hours when contacting our support to ensure we address your concern on time.
To give you more insights about filtering reports in QuickBooks Desktop, you can refer to this article: Customize reports in QuickBooks Desktop.
Please let us know if you have additional questions in the comment section. I'll be glad to answer that. Stay safe, and all the best for your business!
I finally found the report. When I try it, it seems to work as expected: When the bill precedes the payment and is before the date range of the report, and the payment is within the date range, the expenses are included as expected.
What type of account is your "UNKNOWN EXPENSE" account, as viewed on your chart of accounts? Perhaps that matters.
It's an "Other Expense" since it's just an example account. However I tried changing the bill to both Expense and Cost of Goods Sold and nothing changed, it's still broken. The actual accounts that I am trying to work with in reality are COGS, and they too don't function correctly.
Update: I used the QB support chat as suggested by GebelAlainaM. They were unable to replicate the problem and directed me to verify data and then try a clean re-install of QB.
The verify data found no issues, so I did the clean re-install. The issue still occurs in my company file after re-install and update.
However, I tried the sample contract company file and the report functions correctly there.
So clearly there's an issue specific to my company file. How can I diagnose and fix that if the verify data utility found nothing wrong?
I'll make sure that you'll get accurate reports, EBFinancials.
Running the Verify and Rebuild utilities scans your company file for potential data issues and fixes them right away. However, there are certain errors and damages that won't be detected and rectified during the process.
When this happens, you can install QuickBooks Tool Hub and then QuickBooks File Doctor to resolve this issue. This program is a collection of tools that can help resolve major issues that a user might face while working in QuickBooks Desktop. For the best experience, we recommend using this on Windows 10, 64-bit.
Here's how to install it:
Once done, run the Quick Fix my File tool:
If there the same thing happens, you'll have to use QuickBooks File Doctor:
Once the scan finishes, open QuickBooks and your company file. Take note that your issue may have been resolved even if the scan says it was unsuccessful.
Lastly, I recommend reading this article to help track your vendor and expenses transactions: Customize vendor reports.
Keep me posted if you need additional assistance in running your other reports. I'll always have your back.
Well, not sure. It works as expected when I try it.
RE: So clearly there's an issue specific to my company file. How can I diagnose and fix that if the verify data utility found nothing wrong?
Are you sure the bill payment is currently applied to the bill? If you open the bill payment, is the bill selected as paid?
Here's a screenshot showing the report - on a cash basis, the bill from before the report period, and the payment in the the report period:
I used QuickBooks 2020 and 2022 and got the same (good) results. What version of QuickBooks are you using?
@BigRedConsulting wrote:Are you sure the bill payment is currently applied to the bill? If you open the bill payment, is the bill selected as paid?
Yes and yes, they both show as linked to each other in transaction history.
I used QuickBooks 2020 and 2022 and got the same (good) results. What version of QuickBooks are you using?
QB Desktop Premier 2020 Contractor Edition. I'm running the file fixing tools KlentB suggested at the moment, we'll see if that does anything.
The tools hub quick fix and QB file doctor did not detect any issues and the problem is still occurring. No change.
Thanks for getting back to this thread, @JABUIL.
Since you're still getting the same result after performing the suggested steps, I'd recommend reaching out again to our QuickBooks Desktop Customer Support Team. That way, they can perform a further investigation and isolate the issue.
You can follow these steps to connect with them:
Please check out our support hours to ensure that we address your concerns on time.
Also, our Help articles might have something that can help you with your other QuickBooks concerns, too. Just make sure that the topic is set as "QuickBooks Desktop" to browse for related posts.
Let me know if you have further questions or concerns. I'll be here to help you every step of the way. You can always reach out to the Community or me anytime you need assistance. Stay safe.
RE: Yes and yes, they both show as linked to each other in transaction history
If you'd like I can look at it for you. We offer a data-fixing service, though I doubt that's needed in your case. There's something else weird going on, and I'm curious to figure it out. I'll probably get farther than support...
If interested, see my website link on my profile and then send a support request to get started. It'll come to me and I'll reply with instructions.
So, on review, by actually testing QuickBooks I figured out the bug in the report. It was not that hard.
The issue is:
If the product of the customer list count and the vendor list count is more than 10,000, then the report breaks and does not include bills from outside of the report period even if they are paid during the report period.
This is why the report works when testing the a tiny sample company, but not in real company files.
Here are the results I found in a test company, set up from scratch (and not corrupted), when adding and deleting Vendors and Customers and checking the report as I went:
All of the "Job costs by..." reports are broken in the same way, probably because they're all based on the same buggy internal report structure.
So, if you're having problems with these reports on a cash basis, use the F2 dialog to determine if your customer list count * vendor list count is > 10,000. If so, then that's why.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here