Expense disappears when I change to "Display Columns by: Customer Job"

JackieMGMZ · ‎February 03, 2021

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.

JenoP · ‎February 03, 2021

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.

View solution in original post

JenoP · ‎February 03, 2021

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.

JackieMGMZ · ‎February 03, 2021

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.

MaryAnn_E · ‎February 03, 2021

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:

Click the Lists menu.
Select Items, and then select All Names.
Click Edit.
Select Re-sort List, and then OK.

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:

Go to the File menu.
Select Utilities.
Click Verify Data then select OK to close all windows.
Then, go back to the File menu.
Select Rebuild Data under Utilities.
QuickBooks will ask to make a backup before rebuilding your company file, select OK.
Once the rebuild is done, click OK.

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!

Topics

Training

Community

Resources

Expense disappears when I change to "Display Columns by: Customer Job"