I am hoping somebody has experience in processing payroll through QBO and allocating salary expense to a customer. I want to process payroll through QBO using time entries by customer. I am wondering how QBO calculates the wage expense to the customer if the employee is paid by salary. Does the system calculate an hourly rate and post that as wage expense to the customer or does the system generate an entry in some other way?
Hi @jessicachangecollaborative, I'll help share details about your payroll expenses.
Allocating payroll expenses to a customer for salaried employees is called billable time entries in QuickBooks Online (QBO). Salaried employees are set with hourly wages or rates to allocate and use this feature. I'll show you how to turn this on.
Here's an article to read and learn more about employees' billable time activity and allocating them to customers via invoices: How to Record Billable Expenses in QuickBooks Online?
I'm also adding this article for an overview about the benefits of time tracking for salaried employees: 4 Reasons Salaried Employees should Track Time.
I've got you covered if you've got questions about time tracking in QBO. You can use the Reply option below and leave a comment for me to get back and assist you. Take care always!
Now that I understand how the cost of a salary employee is billed in billable time, can you help me understand how this expense posts to the general ledger? Will the expense post to the general ledger by customer so we can run a PnL by customer, or do we have to use projects to track the billable time as a customer expense?
Thanks for getting back to us in Community, @jessicachangecollaborative. I'll chime in and help you with your concern about reports in QuickBooks Online Payroll.
Yes, I agree that you’ll have to use projects to track the billable time as a customer expense. That said, you can pull up a Project Profitability report.
You can also print, export, and email the mentioned report for future use. For additional details, check out this article: Run payroll reports in QuickBooks Online
Additionally, visit these articles below to understand more about profitability and how the project works in QBO:
Please feel free to get in touch with me here for any additional questions with reports in QBO. The Community always has your back. Have a great day!
Thank you for the information. I want to clarify that there is no way to get gross profit margin through a Customer PnL Report. You are saying the only way to get actual revenue and expenses, including payroll expenses, is to use Projects. Is that correct?
Hey there again, @jessicachangecollaborative.
Thanks for reaching back out and asking more clarifying questions about your issue. I'll share some insight with you to help put your mind at ease.
Gross profit is the profit after eliminating products or services (Cost of Goods Sold) from the total net sales. With that being said, the best way to get this information is by calculating it from the Profit and Loss report. Here's how:
Gross Profit = Revenue - Cost of Goods Sold
For more details about reports, check out this link.
Come back if you have any other concerns. We're always here to lend a helping hand. Have a wonderful Friday!
Hi there, Jessica.
Yes, you can use the calculation provided by Candice C to get the net profit margin for your customer. When running the Profit and Loss report, you can filter the name to the customer you need.
I'm adding this link for more tips about personalizing your reports: Customize reports in QuickBooks Online.
On the other hand, you can check out this blog to learn more about profit margin analysis: How to run a profit margin analysis for your small business.
If you have any other follow-up questions while running your reports, let me know by adding a comment below. I'll be right here to help you again. Have a good one!