Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have an Expense account (License and permits) that on the P&L shows a balance of $379.75 BUT when I change the "Display Columns by:" from Total Only to Customer Job that same expense line changes to 241.00. There is a Check issued using this expense account for the difference that it is dropping for some reason. I have already done the Rebuild Data and Verify Data and restarted my QB's but it is still doing this. Also checked my settings that are set to Acrual basis. Any help is appreciated.
Solved! Go to Solution.
I'll help with your question about running reports in QuickBooks, JackieMGMZ.
Can you tell us if a customer or job is attached to the expense transaction? The report will only include transactions that has data in the Customer:Job column when they were recorded. If not, QuickBooks will remove them when sorting out by Customer:Job.
Let's open the Check and make sure the customer is attached to it. Check out the screenshot below for additional reference.
Once done, go back to the Profit and Loss report and sort it again by Customer:Job. I'd also like to share this article for additional reference: Customize Reports In QuickBooks Desktop.
Let me know if you have follow-up questions. I'll jump right back to help you again.
I'll help with your question about running reports in QuickBooks, JackieMGMZ.
Can you tell us if a customer or job is attached to the expense transaction? The report will only include transactions that has data in the Customer:Job column when they were recorded. If not, QuickBooks will remove them when sorting out by Customer:Job.
Let's open the Check and make sure the customer is attached to it. Check out the screenshot below for additional reference.
Once done, go back to the Profit and Loss report and sort it again by Customer:Job. I'd also like to share this article for additional reference: Customize Reports In QuickBooks Desktop.
Let me know if you have follow-up questions. I'll jump right back to help you again.
It does not but there are other transactions (Bank fees) that are not tied to a job either but they DO show under a "no name" column.
Let's re-sort the odd behavior of your data, @JackieMGMZ.
There are instances that this kind of behavior on your file can be resolved by resorting to its list. I'll show you how:
Afterward, let's run the Cost to Complete by Job Summary for All Customers/Jobs report again. Then, check to see if the report shows the correct data.
If the same thing happens, let's run the verify rebuild. This can help fix data-related issues on a company file. Here's how:
Also, you can check these articles to learn more about managing customer reports in QBDT:
Don't hesitate to get back to me if there's anything that I can help you with. Keep safe!
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