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.
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:

• Set up and create projects in QuickBooks Online
• Track income, costs, and profitability by project

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!