cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
RAG1
Level 1

Trouble importing IIF file from Paycom

I'm receiving an issue when trying to import an IIF file to post our payroll journal entry that is saying:

 "Something's Not Right"

"We weren't able to import right now. Try again later."

 We use Quickbooks Enterprise 19.0

1 REPLY 1
ShiellaGraceA
QuickBooks Team

Trouble importing IIF file from Paycom

Welcome to Community, @RAG1.

 

There are factors that we need to consider when importing IIF files. Below are the lists of import and export limitations.

 

  • You can import transactions but you can't export them from QuickBooks.
  • You can only import a certain number of list items. See maximum number of list entries for more info.
  • IIF files you import don't create links between transactions. When you import an invoice and its payment, they aren't linked after you import. Link your transactions using the Receive Payments or Pay Bills windows. You can find third-party app solutions that link transactions from the Intuit Marketplace.
  • When you import assembly items, you can't import data in the item's custom fields.
  • You can't export or import price levels that are set up on a per-item or percentage basis.
  • You can't use IIFs to export payroll data from QuickBooks Desktop to other products. You can use them to export payroll data from Intuit Online Payroll and Intuit Full Service Payroll to QuickBooks Desktop.
  • You can't import IIFs from one country's version of QuickBooks to a different country's version. For example, from the US version of QuickBooks to the Canadian version.
  • Avoid enter numbers with leading zeros in Microsoft Excel when you create an IIF file. As a workaround, format the column cells as Custom.

In your case, you'll want to consider configuring your firewall first by following these steps.

 

  1. Go to the Windows Start menu. Then, search and open Windows Firewall.
  2. Select Advanced Settings. Right-click Inbound Rules and then New Rule.
  3. Choose Port, then Next. Make sure TCP is selected.
  4. In the Specific local ports field, enter the specific ports needed for your QuickBooks year version (QuickBooks Desktop 2019: 8019, XXXXX). Then, Next.
  5. Tick Allow the Connection and then Next.
  6. If prompted, make sure all profiles are marked. Then, Next.
  7. Create a rule and name it like "QBPorts (year)."
  8. Click Finish.

Once done, try importing your IIF files again. I've also added this article about improved IIF Import in QuickBooks 2019 and later for your reference.

 

Let me know if you need further assistance, I'm just a comment away. Thanks for coming in today and I wish you have a wonderful day ahead.

Need to get in touch?

Contact us