Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Online Payroll IIF File Bug?

Hi,

Currently using Intuit online payroll with QuickBooks Desktop 2021. The iif file downloaded from Intuit online payroll generates an error during import.

 

This is because the TRNSTYPE for "Direct Deposit Payable" is CHECK in the iif file, but QuickBooks expects something else... that is the error message I get when I try to import the file.  Changing the TRNSTYPE to GENERAL JOUNRAL enables the upload into desktop to work. 

 

Can someone at Intuit fix the iif file, so that I do not have to manually edit the journals each payroll?

 

Thanks!

3 Comments
QuickBooks Team

Online Payroll IIF File Bug?

Thanks for sharing the details of your concern, @tango502.

 

When importing transactions, we need to ensure that the format is accurate. You can review the iif file created and ensure that the mapping is correct like the headers of the General Journal entry to avoid any errors during import.

 

You may check out this article to learn more about the correct headers to be used in each transaction: IIF Overview: import kit, sample files, and headers

 

However, if the mapping is correct, I'd recommend contacting our Customer Care support. They can conduct further investigation of what's causing this behavior and help you fix it.

 

I'm adding the steps below on how you can reach them:

 

  1. Click Help, then choose QuickBooks Help.
  2. Click on the Contact us link at the bottom.
  3. Enter a brief description of your issue and click Continue.
  4. Choose Start messaging to connect with an expert.

 

I'm adding these articles to learn more about IIF import and maximum numbers you can make in QuickBooks:

 

 

Please let me know if you have other concerns. I'm just around to help. Take care always.

Level 1

Online Payroll IIF File Bug?

Thanks for your response.

Intuit Customer Care support was not very helpful that's why I posted on this forum, hoping that someone at Intuit who deals with iif files can help fix it. I was initially told that the export of iif file from online payroll was not possible, and then later informed that no customer care support is provided for issues related to iif files.

I guess I will have to continue manually editing the downloaded files until a fix is found.

Community Champion

Online Payroll IIF File Bug?

Importing payments to employees or to Intuit for the overall payroll should work when the type is a Check, as long as the Account used on the TRNS row is a bank account. 

 

I would think that this is the model for the import, since any payments to Intuit or to individual employees will come from your bank account.

 

If the TRNS account is not a Bank type account on your chart of accounts, then that's the issue.

 

What do you mean when you write "the TRNSTYPE for "Direct Deposit Payable" is CHECK in the iif file"?

Need to get in touch?

Contact us