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?
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:
Go to File at the top menu bar, choose Utilities.
Select Import, then IIF files.
Browse your converted file and pick Ok.
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!