cancel
Showing results for 
Search instead for 
Did you mean: 
liruzun
Level 1

General Ledger doesn't show expenses by Customer

In the old WB Desktop version, you could see the General Ledger by the job.

When we switched to Online, our Job Sites ended up being "Customers."

This year we needed the general ledger by Customer, only to find out that the Customer column doesn't show which Customer the expenses/bills/etc. are referred to unless the accounts are registered as assets...

We talked to customer service, and they said it is because of how the accounts are mapped in QB Online that it doesn't happen...

 

Am I the only one experiencing this? I can't believe they couldn't think someone would need the general ledger by Customer...

3 Comments 3
MJoy_D
Moderator

General Ledger doesn't show expenses by Customer

This is not the kind of experience we want you to have, @liruzun.

 

As a workaround, you can run the Transaction List by Customer report. Customize this report to add the Account column. 

 

Here's how:

 

  1. Go to the Reports menu and find Transaction List by Customer
  2. Click the Customize button.
  3. Scroll-down to the Filter section to include the Transaction Type and Account.
  4. Select the Run report button to generate the report. 

 

You can check this article on how to run and customize your report to print, email, and export them: Run reports in QuickBooks Online

 

To get all the information that you need with your reports, see this article for detailed guidance on how to customize reports in QuickBooks Online

 

Let me know if you have further questions with generating your reports. I'm always here to help. Have a great rest of the day!

liruzun
Level 1

General Ledger doesn't show expenses by Customer

Hello,

 

Thank you, I know how to do that. The auditors asked us to provide them with General Ledger by Job site. Even though we tried providing the transaction list, they still wanted the GL... When will this issue be fixed?

DivinaMercy_N
Moderator

General Ledger doesn't show expenses by Customer

Hello there, @liruzun. Thanks for getting back here in the Community.

 

I appreciate you sharing an update about the recommendation provided by my colleague above. While we don't have the exact time frame for when this feature will be implemented, I highly recommend sending feedback to our product developers to request the addition of this feature. Once submitted, rest assured that they review your comments and consider adding them to future updates. Here's how:

 

  1. In your QuickBooks Online (QBO) account, navigate to the Gear icon.
  2. Next, select the Feedback option.
  3. From there, enter the details of your product comments, suggestions, and requests. 
  4. Then, click Next to submit.

 

You can also visit our Customer Feedback for QuickBooks Online website to track the feature request you've submitted.

 

Additionally, you can also export the General Ledger report to Excel and modify the columns to add one for the customers.  

 

For reference in managing reports in QBO, please read this article: Run reports in QuickBooks Online. 

 

I'm just around the corner to help if you have any other concerns about managing customer reports in QBO. Have a good one and stay safe. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us