We are inquiring about how to import payroll data exported from our POS system in csv format.
Our POS only exports hours worked in csv, json, and pdf formats. We know that we can import csv into QB for other lists, but is it possible for payroll? If not, how can we convert the csv file to an iif that can be imported to QB?
Hello there, ok15.
I have some details to share about importing data into QuickBooks Desktop.
At this time, you'll only able to import the employee list in the program. The payroll transactions, such as their hours worked, would need to be added manually.
For more details about it, check out the import .IIF files section of the article below:
You can convert a CSV file into an .iif format through a third-party converter. Since every business has unique needs to highlight their brand, I'm unable to suggest specific applications. I'd recommend browsing the web so you can personally select which one fits your company.
To import an IIF file:
I've added an article with further details about the process:
Once done, you can proceed manually entering the payroll transactions.
I can see how the ability to import payroll transactions would empower your business. I'll prepare a feedback statement to send up to our product engineers. It'd be best if you can also send this as a suggestion directly to them so we can let them know the changes we both want to see in the future.
You'll want to submit that by going to the Help menu, then selecting Send Feedback Online.
The Community is always here to help you with any QuickBooks related concerns. If you have other questions in mind, feel free to drop by and I'll be around!
Have a great day!
Thanks for chiming in this thread, ckroot.
We can import employee list into QuickBooks Desktop, however, we're unable to import their earnings and deductions. You'll have to manually enter them into QuickBooks, and I'm here to guide you.
To add a salary item:
To add a deduction item:
In case you want to assign the item to the employee, follow these steps:
Let me share this article too for future reference: Set up a new employee in QuickBooks Desktop Payroll.
That should get you on the right track.
Please let me know how that works for you. I'm to here provide any additional assistance if you need anything else. Have a good one.
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|
|Kathy Linklater||02/09/2020||Links, John||Labor||Regular Pay||1:25|
|Johnny Deep||02/09/2020||Links, John||Labor||Regular Pay||2:00|
then utilize one of these importer tools
You'll have to convert it to an IIF file, Thequestionmaster20.
Whenever you have the file, you can follow these steps on how to import them to QBDT:
You can learn more about other ways to import data to QuickBooks Desktop via this article: Import and export data in QuickBooks Desktop.
The Community is here 24/7 if you have other questions while doing tasks in your account.