Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
We are using TSheets for our time keeping. I download a report and our payroll is done by an outside company. After I sync TSheets to QuickBooks, no payroll expense is being posted. The TSheets people told me how to set it up. The timesheets are showing up in QB but no expense is posted to the classes. I must have missed something in the set up. Each employee has a service item for their payrate. They bill a customer for their time. Each project is linked to a class. I don't know what is missing. Can someone help me?
Hello there, @SueatRCD.
You’ll have to import the payroll data and assign classes from there. Since timesheet doesn’t post any expense or income. Unless it is being used by payroll or billed to invoices.
To do so, you'll want to download and install the.IIF import kit. Let me show you how:
5. After that, copy your data from the Excel file to the IIF file. Then, import it to QuickBooks.
Here's how:
You can transfer data to or from different platforms by using the IIF method. To know more about importing or exporting data using IIF, refer to this article: https://community.intuit.com/articles/1775251.
If you'd like to learn more about importing and exporting data in QuickBooks Desktop check out these articles as well:
As you may have noticed, there are quite a few options available for importing data into QuickBooks Desktop. I recommend you check through them all before you decide which one you'd like to use.
Please let me know if you need anything else. I’ll be here to help. Take care always.
You may prepare your Time Tracking data with the following template
Name | Transaction Date | Customer | Service Item | Payroll item | Duration | Class | Billable | Notes |
John Marks | 01/09/2020 | Nguyen, Tuan | Labor | Regular Pay | 1:25 | |||
John Smith | 02/09/2020 | Nguyen, Tuan | Labor | Regular Pay | 2:00 | |||
Karen Marks | 02/09/2020 | Links, John | Labor | Regular Pay | 1:25 |
then utilize one of these importer tools
https:// transactionpro.grsm.io/qbd
https:// partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2
What report do you download from TSheets? Is the IIF tool easier or more effective that just using Excel?
Thanks for following up with the Community about this.
You won't have to download anything from TSheets to complete the process provided by MaryAnn_E. However, you'll need to get a copy our IIF Import Tool. Steps for downloading and using it can be found in my colleague's post.
Intuit's IIF tool can be very useful. For example, if it finds any errors while importing data, the number of items that imported/failed will be displayed. Additionally, it provides a new file for your failed transactions, along with details of each error.
More information about our IIF Import Tool can be found in the following resource: Improved IIF Import in QuickBooks 2019 and later
If there's any other questions, I'm just a post away. Enjoy the rest of your day!
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