I use TSheets for time tracking and it is integrated with QBO. The weekly timesheets for my employees come over perfectly with each entry by client and billable, etc. When I run payroll through QBO Payroll all the time is lumped into one total and not by client. This is making all my payroll expenses post to an "unspecified" client and the P&L by client is of worthless. I can't see where to make edits when processing payroll to separate hours by client like they are on the QBO Weekly Timesheets. This is really frustrating because I don't always charge time and materials and want to know if I priced my monthly accounting services correctly for a client and now I can't find any report to show me......I am so frustrated. QBO Payroll help chat told me it was a TSheets problem and TSheets help said it's a QBO Payroll problem....About to break up with them all and go back to paper and a ledger since that would be what I have to do to get the reports I need anyway....GAH
"QBO Payroll help chat told me it was a TSheets problem and TSheets help said it's a QBO Payroll problem."
This sounds too familiar. They both should have known this issue by now.
Unfortunately, QuickBooks Online (QBO) doesn't handle payroll by customer/project at this time. Even if you've just QuickBooks Payroll, it will still post directly to general ledger accounts. Currently, there is no option in QBO Payroll to auto-populate the wages by Customer/Project as they have in QB desktop (Payroll Item List/Service code). In other words, there is no way to post hours worked or labor cost by customers/projects in QBO (either through QBO Payroll or TSheets app) at this time.
(Also, I have not heard of any new feature updates coming on this known issue, sorry!)
Just last week, one other QBO user also posted the same question. You can check out this link if interested:
How is it we "upgrade" to online and it has less features than the desktop? Junk in gets you junk out. If we can't get the information into the system by customer than the sales reports are never going to be correct.
Hello there, DiRode,
There are some features and reports in QuickBooks Online that aren't available in the desktop version.
You can refer to the Reports included in your QuickBooks Online subscription page. It will show the list of statements available on your plan.
On the other hand, you can set up and work with class and location tracking to monitor income and expenses. Then, assign them for your payroll transactions by associating a single class to your employees.
Doing this will help ensure you have accurate records on your sales.
Should you have follow-up question, don't hesitate to leave a comment below. I'm always right here to help.
I would be appreciative if someone could help me understand if there Tsheets/QB can be integrated so that P&Ls by customer can be created taking into account employee's hours on projects.
I would like to take the company's total labor expense for a month and then allocate it to each project, so there can be a P&L by project.
Is this possible?
Hi there, @swensen.
When you use TSheets to track your employee's time, you can import time pursued directly into the weekly timesheets in QuickBooks Online. Marking them as billable to the following employees or vendors and invoicing them to your customer.
The Time option will help you record either a single day of work or weekly timesheets. The Project Profitability report lets you see the total money that you can get on a project and see the total expenses. You can also run the Time and cost by employee or vendor report to see the total time and expenses spent on a project.
When you run the P&L by Customer report, make sure to customize the reporting period to a specific month and filter it to a particular customer/project. It's all possible in QuickBooks Online.
For the detailed instructions in integrating TSheets with QuickBooks Online, you can reference this article: Track income, costs, and profitability by project.
I've added an article to find out more answers about the Projects feature in QBO: Projects FAQ.
Let me know if you have other questions. I'll keep my notifications open. Take care, swensen!