cancel
Showing results for 
Search instead for 
Did you mean: 
ok15
Level 1

Importing Payroll Data in CSV

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?

6 Comments 6
VivienJ
QuickBooks Team

Importing Payroll Data in CSV

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:

 

Export or import IIF files

 

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:

  1. Go to File at the top menu bar, choose Utilities.
  2. Select Import, then IIF files
  3. Browse your converted file and pick Ok.

I've added an article with further details about the process:

 

Improved IIF Import in QuickBooks 2019

 

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! 

ckroot
Level 1

Importing Payroll Data in CSV

Is it possible to import employee specific data into quickbooks such as payroll deductions, 401(k), insurance deductions, salary etc?

PreciousB
Moderator

Importing Payroll Data in CSV

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:

  1. Go to Lists at the top.
  2. Choose Payroll Item List.
  3. Click the arrow beside Payroll Item at the bottom.
  4. Select New.
  5. Tick the radio button for EZ Setup.
  6. Choose Next.
  7. Select a payroll item type.
  8. Click Next.
  9. Choose the earning type.
  10. Select Finish.

image.pngimage.pngimage.png

To add a deduction item:

  1. Follow the first three steps above.
  2. Choose Custom Setup and click Next.
  3. Select Deduction.
  4. Click Next.
  5. Enter a name for the deduction.
  6. Click Next twice.
  7. Choose a Tax tracking type.
  8. Click Next four times.
  9. Select Finish.

image.pngimage.png

In case you want to assign the item to the employee, follow these steps:

  1. Click Employees at the top, choose Employee Center.
  2. Double-click the employee name.
  3. Add the item on the Earnings or Additions, Deduction and Company Contributions table.
  4. Click OK.

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.

Thequestionmaster20
Level 1

Importing Payroll Data in CSV

Hey,

 

I want to follow up on this question,

 

Is it possible to upload a CSV file with the timesheets of my employees to QB?

Or do I have to convert it to IIF file?

 

Thanks

Fiat Lux - ASIA
Level 15

Importing Payroll Data in CSV

@Thequestionmaster20 

Prepare your Time Tracking data with the following template

NameTransaction DateCustomerService ItemPayroll itemDurationClassBillableNotes
John Marks01/09/2020Nguyen, TuanLaborRegular Pay1:25   
John Smith02/09/2020Nguyen, TuanLaborRegular Pay2:00   
Karen Marks02/09/2020Links, JohnLaborRegular Pay1:25   
Kathy Linklater02/09/2020Links, JohnLaborRegular Pay1:25   
Johnny Deep02/09/2020Links, JohnLaborRegular Pay2:00   

 

then utilize one of these importer tools

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

GlinetteC
Moderator

Importing Payroll Data in CSV

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:

 

  1. Go to the File menu, then choose Utilities
  2. Select Import, then pick the appropriate type files. 
  3. Click OK and follow the on-screen instructions. 

 

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.

Need to get in touch?

Contact us