Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
We use QuickBooks Online Advanced (QBO) for accounting. We also use a stand-alone QuickBooks Payroll (QBP) account for processing payroll. We connect the two by simply exporting QBP data to QBO.
We also use a non-Intuit system for time tracking and expense tracking. This system is used to track time against grants, compute hours worked during a pay period for part-time employee, and to help show effort levels (full-time and part-time) across our various projects. This is tedious as it requires manual data transfer as well as maintenance of two project lists one for QBO and one for our timesheet system.
It seems like we should be able to use QuickBooks Time to help simplify this latter process, but I have not been able to figure out the way to go about this. As one additional bit of information, we use QBO classifications to identify our projects, for example a project might be known as Program: Project 1.
Given the way we define these projects within QBO, is there a way that we can use QBO (or another product) to collect employee time and expense data against this same list of projects. We do not need to generate time and materials invoices but do need to track hours and expenses in this fashion to produce internal reports.
It seems like this should be a very simple thing to do but it’s unclear whether I should be pursuing it from the QBO, QBP, or QuickBooks Time perspective or some other way.
Thanks for any insight. My main goal is to have a single list of projects/grants that inform the system used by employees to track time, and the classifications used within QBO to track internal budgets.
Given all the bells and whistles within the QBO products, it seems like this should be easy but I just can’t figure it out.
Thank you for the details, slbradio.
I'm here to assist you in understanding how to incorporate expenses and timesheets into a project so you can run a report with all the projects used.
With QuickBooks Online Plus and Advanced, we have the option to add existing timesheets and expenses to a project. I'll guide you through the steps.
Here's how to add expenses to a project:
Then, to add existing timesheets to a project, you can follow the steps below.
If you have the Time menu:
If the Time tab isn't available on your end, you can follow these steps instead:
Once done, you can run the Project Profitability Summary report to show the profit of each project. Here's how:
Moreover, I've added this article as your guide in personalizing the said report: Customize reports in QuickBooks Online.
Keep me posted whenever you have concerns about overseeing your employee's time and project.
Thanks for your reply. We do have QuickBooks Advanced and it's built in QuickBooks Time feature. A few questions:
1. Am I correct in assuming that I can allow employees to enter time directly through this system while not giving them access to other parts of QuickBooks?
2. If they begin to enter their time this way, I'd like this time to be able to inform their paychecks. As noted in my post these paychecks are created using a standalone version of QuickBooks Online Payroll. (The two products are not integrated because our payroll previously was Intuit Online Payroll and I was told full integration was not possible). Do I have to export the timesheet hours into QuickBooks Online Payroll or would this be a manual transfer for these paychecks? I'd like to consolidate this data as simply as possible and, well it seems it must be possible, it's unclear how to do so.
Thx
I'm here to clear out some of your confusion, slbradio.
For your first question, yes. You can invite your employees to allow them to track their working hours in QuickBooks Time without giving them access to the other part of the program.
Here's how to invite them:
After that, I've listed the things that your employees need to do to track their time:
Once done, they can start tracking and submitting their time entries for themselves.
Meanwhile, to ensure that your QuickBooks Time data can be automatically synced to your payroll account, I suggest reaching out to our Payroll Support Team. They will be able to assist you in determining if this feature is available for your specific payroll subscription.
In addition, I've added an article that'll help you to get started, customize your settings, and onboard your team: Set up and Customize QuickBooks Time.
Please keep us posted if you have additional questions about managing your employees and your payroll data. We're always here to help you out.
Unfortunately this still is not working the way it should be. I had another idea today I wanted to share with you to see if it may be causing the problem.
The goal is this: Once I have Projects set up in QBO and employees enter their time in QBO, I want QBO to calculate job costs. However, QBO itself does not even recognize my employees by name (let alone hourly rate) even though they are being paid through QuickBooks Online Payroll with data exported.
Idea: I looked at my payroll export settings and chart of accounts and noticed that, although our account numbers are consistent and accurate for all components of burdened labor expenses, we have used an "expense type" of other "other expenses" rather than "payroll expenses" when setting up these accounts. If we were to change these types to "payroll expenses" , would we find that the information would export more comprehensively from QuickBooks Online Payroll, i.e. would we see names and individual burdened rates?
I also wonder if this problem would go away if I were able to migrate our standalone QuickBooks Online payroll account into QuickBooks Online. Because of the length of time we've been with QuickBooks, or accounting software and payroll software are still treated as if they are separate services. Several support staff have told me it is impossible to do this migration which is disappointing.
This
I appreciate you for sharing ideas and always giving us detailed statements, @slbradio.
In order for QuickBooks Online (QBO) to recognize your employees’ names and rates, make sure QuickBooks Online Payroll (QBOP) data types, especially accounts, are matched and aligned when mapping. This will allow you to generate precise and comprehensive data. Please know that the system's functionality is based solely on your configuration.
Moreover, there are modes that the program offers to track job costs accurately and effectively.
You can read these guides to learn more about them, how the burdened rate is calculated after entering the gross wages and additional items, and get insights into your project performance:
You can cancel your QBOP and avail of a new one within your QBO account to track project costs and profits in one place. Then, you can enter the prior payroll to get everything intact.
Keep us posted if you have other concerns or questions about managing your account and files. I want to ensure all are covered.
"In order for QuickBooks Online (QBO) to recognize your employees’ names and rates, make sure all accounts match with your QuickBooks Online Payroll (QBOP). This way, you can generate comprehensive data. Please know that the system only depends on your setup."
I have checked this carefully and QBO does not recognize employees or costs despite the day coming over properly when exported :(.
"You can cancel your QBOP and avail of a new one within your QBO account to track project costs and profits in one place. Then, you can enter the prior payroll to get everything intact."
If I do this what happens to my years and years of data with the "cancelled" servucd?
Ty.
Let me clear things up about how QuickBooks handles your data, @slbradio.
Since we don’t have control of the data such as tracking time against grants or the timesheet system from your other application, you may need to consult your provider on how they work with QuickBooks or how they send their data to the application.
Concerning the payroll data you have for years, my colleague, MadelynC is correct about about exporting the data you have from your previous subscription and entering them into the new one. To start, make sure to have the data on hand and begin setting it up by following the steps below:
Continue the process by referring to Step 3: Enter how much you paid your employees this year to Step 4: Enter your company totals for each payday in this article: Add pay history to QuickBooks Online Payroll.
Moreover, learn the feature that allows employers to pay their employees with direct deposit. This option paves the way for paying them into their checking, savings, or money market accounts. Here’s an article for your guidelines: Set up direct deposit for employees.
Keep me posted if you have more concerns about managing QuickBooks data. I’m always here to help.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here