cancel
Showing results for 
Search instead for 
Did you mean: 
ASM Graphics LLC
Level 2

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

I upgraded to QB Desktop Pro 2019 earlier in the month and use Intuit Online Payroll (for the last 3+ years).  First payroll with the new QB's I imported the .iif file and got an error.  Have spent HOURS on the phone with both IOP and QB Desktop and I keep getting the same line...Engineers are working on it as we have many customers with this problem and we don't know when it'll be fixed.  Not only do I have to handwrite checks, I have no idea my cash flow which is NOT okay. 

I have now done 4 weeks of payroll and unable to import the file.  Opened QB tonight and it said there was an update available so I thought by some chance it was installing a fix.  Nope, still getting errors...Anyone else here having this problem?  If so, have you figured out a workaround to get it to import?

 

This is the error:  [ERROR] Duplicate Record. The input file contains another record of the same type with the identical name. [101]

 

Doesn't tell you what record and nothing stands out to me.

21 Comments
qbteachmt
Level 15

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

I don't know if this will help you, but BRC investigated the changes to the .iif import function and it is clearly failing on things it used to accept, for no apparent reason.

 

Here is his article:

http://bigredconsulting.com/quickbooks-2019-iif-import/

ASM Graphics LLC
Level 2

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

Thanks, but no unfortunately it doesn't help.  It doesn't give you the option to import even with errors.  Very frustrating that it worked with a very old version of QB's and now it doesn't.  The only import I do is Payroll with Intuit's Online Payroll through my bank.

qbteachmt
Level 15

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

Instead of using the Payroll Import function, can you use the regular "Import" from the File menu > Utilities? That would require you to be able to save the .iif on the computer, but that would allow you to bypass the "payroll import" function and turn that into a regular import.

ASM Graphics LLC
Level 2

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

I'm not using the Payroll Import Function.  While in Intuit Online Payroll you export which creates the iif file.  Then, I go to QB 2019 File, Utilities, Import and choose the iif file I want to import.  It says it will close all windows and import.  A screen comes up where it will show how many records imported correctly or failed.  All the paychecks fail and nothing imports.

VivienJ
QuickBooks Team

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

Hi ASM Graphics LLC,


I want to ensure you can import the paychecks into QuickBooks Desktop.


It’s possible that the error you’ve mentioned above was due to duplicate account names in your Chart of Accounts, or Employee names. We would need to trace them so you’ll know which names you have to delete.


Since the error message didn’t specifically mention their location, you need to manually find them. I’d loved to personally do the process for you, however for security reasons I cannot access personal information in this public forum.


Because of that, you’d need to contact us again. Our phone specialists can use tools like screen sharing and double-check why you’re unable to import your paychecks.


You can also keep the case ticket number on your previous call handy and give it to the next representative. This way, you won’t need to re-explain the situation.


To reach us:

  1. Go to https://help.quickbooks.intuit.com/en_US/contact
  2. Select QuickBooks for Windows.
  3. Select your QuickBooks for Windows version.
  4. Select a topic.
  5. Click on the Get Phone Number button.

Rest assured that we’re with you in making sure that you can get back up and running again.


Please update me as to how things work out for you. I’m only a comment away.

 

ASM Graphics LLC
Level 2

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

If what you're saying is true, then why haven't the 6 previous Representatives and 2 Supervisors able to able me?  I've done screen share with all of them and they tell me it's a problem that the Engineers are working on, but we are just about a month in and there's still no fix.  This is affecting me doing business and knowing where I stand with cash flow and my financials.  I have literally been on the phone for 8-10 hours on 4-5 different occasions.  For a company the size of Intuit a fix should have been completed already.  I've had software bugs with much smaller companies and there's a fix usually within 48 hours.

VivienJ
QuickBooks Team

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

Hello ASM Graphics LLC,


I see you’ve been through a lot trying to get things how they should be. Going back and forth isn’t easy, but rest assured I’m here with you as we look for ways of fixing this.


I’ve created an escalation case and forwarded it to the dedicated team. Also, I requested that a support representative reach out to you via the email address connected to your Community profile.

While waiting, I have a resolution you can try to deal with this error. It has helped other customers who encountered the same issue when importing paychecks via an iif file into QuickBooks Desktop.


Instead of importing the data in one file, you can do it by batch, like 3-5 paychecks in one file. This way, we’re able to distinguish as to which file the error will occur.


From there, you’ll able to double-check the transactions causing the duplicate names, such as Payroll Item list, or Employee details and delete them from QuickBooks Desktop. You’ll want to start by also re-exporting the paychecks (in batch) from Intuit Online Payroll, then proceed with the reimporting process.


Please give this workaround a try when you get the chance to do so. I’ll still be here until you get to successfully move your paychecks.

ASM Graphics LLC
Level 2

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

Someone was supposed to call me today after 12 noon with an update, but of course they did not even though he promised he wouldn't drop the ball like the others and would do what he says he will do.

 

I tried importing before in a small batch, but I'll try and import just one at a time and see what happens.  I won't be able to do it now until tomorrow night.

VivienJ
QuickBooks Team

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

Hi once again, @ASM Graphics LLC.


He might be stuck on a call, which is why he wasn’t able to get back on the scheduled time. However, since I’ve already forwarded the escalation request, our dedicated team can review it and double-check the case tickets created by the previous specialists.


From there, they’ll be able to know which steps they need to take next. I’ll also make sure to be in contact with them to follow-up on this.


Keep me posted with the results once you’ve tried importing the paychecks one-at-a-time. I'll be on standby for your response.

 

Have a great day!

 

ASM Graphics LLC
Level 2

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

Good morning:

 

Please don't make excuses for the Representatives.  If someone promises to do something they find the time to do it.  He failed just as all the rest of the Representatives have.  It's called CUSTOMER SERVICE...

 

I just tried importing one at a time and I'm still getting the original error: ; [ERROR] Missing mandatory field TRNSTYPE in data. [15103] .  From what I can see there is a trnstype label called CHECK.  Previously, I posted a different error I got so I have no idea what's going on but I need it fixed to know where I stand cash wise.

 

The open ticket # is [removed]

qbteachmt
Level 15

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

For this issue, BRC's article shows you there are Two Different places to click:

"Then, I go to QB 2019 File, Utilities, Import and choose the iif file I want to import."

 

Click in the bottom part: Import it For Me, I'll Fix It Later.

 

Did you use that one?

ASM Graphics LLC
Level 2

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

Hi:

 

I hadn't seen it before you mentioning it, so I've done it that way and was able to import the files.  I don't see anything wrong as they look the same as the files that I imported into my old version of QB before upgrading.  I guess I just need to get used to importing it that way as it's obvious Intuit is going to fix whatever their problem is...Thank you!

qbteachmt
Level 15

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

"I hadn't seen it before you mentioning it, so I've done it that way and was able to import the files."

That's why I first offered it. Glad it helped.

Thanks to BRC.
kellee921
Level 1

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

So glad I read through this whole post! THANK YOU!!! I think you just saved me a few hours on the phone with support! Much appreciated! The secondary link worked for my import as well.

kellee921
Level 1

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

I should also note - I do NOT use Quickbooks payroll. We use an outsource service (ADP/Paychex). They provide an .IIF file to import. This also worked for my outsourced import issues.

BettyJaneB
QuickBooks Team

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

Hello there, kellee921.

 

It's good to hear that the information above helped you in fixing your QuickBooks concern.

 

Please know that you're always welcome to reach out to us if you have questions concerning QuickBooks. We're always here to lend a helping hand.

 

 

Wishing you and your business continued success.

debrah
Level 1

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

Thanks for posting this whole problem.  The import with errors works for me too!!  Only spent and hour instead of DAYS trying to fix QB's 2019's import.

immollyp
Level 1

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

I've spent hours working on a similar problem:  the new QB Desktop pro 2018 assigns check numbers to direct deposits when importing the iif files from Intuit Online Payroll (full service).  It's driving me crazy, because it's messing up my check # sequencing.  QB says it's an online PR problem, and Online PR says it's a QB problem.  THEY ARE BOTH INTUIT!!!  Arrrrrghgh!!

Rasa-LilaM
QuickBooks Team

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

Hello there, immollyp.


Thanks for joining this thread and letting us know the information provided by our Payroll Support Team. 

 

I can see that you’ve been going back and forth with different Payroll Support Teams to solve the issue. This isn't the kind of experience I want for you.

 

Allow me to share some insights about importing transactions form IOP to QuickBooks Desktop.

 

Both IOP and QB Payroll are similar products. However, they have different interfaces. Once you import the direct deposit transactions, the desktop version will assign check numbers even if they are direct deposits.

 

To resolve the issue, you’ll have to open the IFF file and enter DD in the DOCNUM column. For the process, follow these steps:

 

  1. On the Payday Success or Home page, select Export to QuickBooks.
  2. Choose Export to generate the .IIF file.
  3. After modifying the information make sure to save the file to your computer.

To import:

 

  1. Go to File at the top menu bar.
  2. Select Utilities, then choose Import.
  3. Click on IIF files.

You'll find detailed information in this article and proceed directly to the Intuit Full Service Payroll section: Export to QuickBooks for Windows or Mac (IIF).

 

This information should help you moving forward. 

 

Keep me posted if you get the chance to try all the steps and what the results are. I'll be right here with you.

cherylf
Level 1

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

My .iif file imports correctly.  The problem I'm having is the process is assigning duplicate check numbers in the check register even though the employees are all direct deposit.  I have to remember to manually delete each check number afterwards.

HoneyLynn_G
QuickBooks Team

Intuit Online Payroll .iif file import error into QB 2019 Desktop Pro

Hi there, @cherylf.

 

Thanks for reaching out to us and joining this thread. I can help you add the direct deposit transactions of your employees.

 

Currently, the option to import an IIF file of your employees' direct deposit is unavailable. This is the reason why they're added as check and got an issue with duplicate check numbers.

 

You'll have to use the Year-to-date tool to enter historical payroll data. I'll show you how:

  1. From the Help menu, choose About QuickBooks
  2. Press Ctrl + Alt + Y, or Ctrl + Shift + Y to open the Setup YTD Amount Window.
  3. On the Set Up YTD Amounts window, follow the next procedure to complete entry of YTDs and tax payments. Click Next.
  4. When prompted to enter the date you want your YTD entries to affect accounts, enter your estimated first payroll date in both boxes, and select Next.
  5. Enter your estimated first payroll date, and select Next.
  6. This will need to be adjusted to a later date if you have trouble entering current quarter YTDs.
  7. Enter your YTD summaries per employee.
    Capture.PNG
  8. When you have completed all YTD entries, select Next to close the Employee Summary Information window.

If you've already paid taxes outside QuickBooks, refer to the Enter historical tax payments in QuickBooks Desktop Payroll article for the steps.

 

That should do it! Let me know the results or if you have follow-up payroll questions. I'm always here to share my expertise. Have a wonderful day!

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us