Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI am trying to see if it is possible to import payroll hours to Quickbooks Online, and see what the template for that looks like. I have the ability to export payroll hours from a 3rd party system, but I am not sure how to match up the columns/formatting. Is there a template file that I should use? And from the help menu, it seems like I have to have Quickbooks Advanced Payroll in order for that import feature to be enabled?
Thanks for posting your concern here in the Community, @srosselle. We'd be glad to provide some information about your concern when importing payroll hours to QuickBooks Online (QBO).
Currently, there's no feature for importing hours from third-party providers to QuickBooks Online. However, we can look for a third-party application where you can import hours from a third-party app into QuickBooks Online (QBO). If you need to use one, we suggest a third-party application and navigate for an app in the QuickBooks Online App Center.
Here's how:
QuickBooks also provides integration with several applications, allowing users to efficiently manage their data. If your tracking app is supported, you can directly connect it to QuickBooks, enabling automatic syncing of your employees' hours.
I've included this guide to help you learn more about managing employees' records in the program: Manage workers and employees. It contains everything you need to ensure accuracy in your payroll records.
I've added some resources with more insights for future reference in importing data in QuickBooks Online:
If you have any other questions or anything else besides importing hours to QBO, feel free to add them to your reply below. We're always here to assist you and ensure your business runs smoothly. Have a great day!
You can prepare your Time Activities data with the following template
TxnDate | Name | Time | StartTime | EndTime | Description | BillableStatus | Customer | ServiceItem | HourlyRate | Taxable | Class | Location |
01/10/2020 | Mike's Traders | 5 | Sample Time Activity using hours and decimal | Janice Johnson | Hours | |||||||
01/10/2020 | Eagle Outfitters | 4.5 | Sample Time Activity using hours only | Janice Johnson | Hours | |||||||
01/10/2020 | Mary Smith | 0.5 | Sample Time Activity using hours and minutes | Billable | Janice Johnson | ENG Svs:120 | 75 | FALSE |
then use an importer tool to proceed
https://get.transactionpro.com/qbo
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