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

Job Costing with Customer Expenses

Where can I find a report showing all the expenses I've assigned to a customer in QB Online?

 

I've found that information in the P&L by Customer Report, but it shows every customer and everything in the P&L.  Is there a easier way to find out my COGS for each customer?

1 Comment 1
Rasa-LilaM
QuickBooks Team

Job Costing with Customer Expenses

Glad to see you in the Community, Bstauffer.


I appreciate you for performing the necessary steps to get the report you need. We’ll have to run the Profit and Loss by Customer Report and customized it for each customer.


Here’s how:

 

  1. Tap the Reports menu at the top and enter the Profit and Loss Report in the search field.
  2. Click the Report period drop-down to set the correct date range.
  3. Mark the radio button for Accrual under the Accounting method.
  4. Press the Customize button in the upper right.
  5. Click the Filter link and mark the box for the Customer.
  6. From the list, choose the customer’s name.
  7. Hit Run Report to view the changes.
  8. Perform the same process so you can see each customer’s assigned COGS.plc.pngplc2.png
  9. Click the Export icon and pick Export to Excel.

Open the spreadsheet and manually remove the unnecessary line items and keep the COGS account. From there, filter the information for each customer.

 

If you use the Projects feature to track the job cost, pull up the Project Profitability Report for each customer. Then, export it to Excel.

 

  1. Go to the Projects Report on the left panel to see the complete list of Project/Customer.
  2. From there, click the job cost or project to view more details.
  3. Hit the Project Reports menu to open the list of reports.
  4. Pick Project Profitability and tap the View link to open the report details
  5. Press the Report period drop-down to select the correct date range.
  6. Tick the radio button for Accrual under the Accounting method.
  7. Click the Export icon and choose Export to Excel.
  8. Next, open the spreadsheet and sort the information to only show expenses.
  9. Perform the same procedure for the remaining customers.

For more insights about the Project feature and reports you can use to track income, expenses, and profitability, see the information in the following articles:

 

Additionally, here’s a guide that covers all the steps on how to refine the data on your reports: Customize reports in QuickBooks Online.


Please know that I'm only a few clicks away if you have any other questions or concerns. I'll be here to assist. Have a great rest of the day!

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

Need to get in touch?

Contact us