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

Looking for a Data Dictionary / Interface Spec for IIF Data Import to QB Pro Desktop

I've recently joined a company that uses QB Pro (desktop) for payroll.  As it sits, their process for getting time into the application is very manual (time collected in spreadsheets, e-mailed, then re-entered to QB by the payroll folks).  We are going to implement a simple portal application to gather time from our team and to then present a file or files for upload to QB. 

 

I'm a former data guy - and the IIF structure seems manageable - but beyond the sample files I'm coming up blank in looking for a data dictionary and / or interface specification that clearly defines the protocol / standard for these files and all of the data elements that can be engaged through this process. 

 

Can anyone point me to a comprehensive documented standard for IIF files and the data elements that can be loaded through them?  

3 Comments
Fiat Lux - ASIA
Level 15

Looking for a Data Dictionary / Interface Spec for IIF Data Import to QB Pro Desktop

Why don't you consider to have a time tracker app and integrate it with your QB Desktop? What kind of business do you run? a construction/field service company or else?

ReyJohn_D
Moderator

Looking for a Data Dictionary / Interface Spec for IIF Data Import to QB Pro Desktop

I've got some options to ensure you can handle your IIF files and track your team's time, @nhmiller.

 

Our QuickBooks Import Kit is a basic great resource you can use when creating or handling IIF files. It contains the following components:

 

  • IIF Import Manual: A .pdf document that outlines common .iif pitfalls and best practices.
  • IIF Header Help: The column headings are used to import list data.
  • IIF Example Files: A folder that contains version-specific .iif transaction examples.

 

To learn more about this, please see this article: Import Kit and IIF samples.

 

Also, you can integrate a time tracker app into QuickBooks Desktop. You can browse through our QuickBooks App Center to find apps that suit your need.

 

For application programming interface (API) concerns, it's best to reach out to our Intuit Developers page. From there, you can interact with other developers or experts who can share valuable insights about IIF structures or data specifications.

 

Here are the easy steps how:

 

  1. Open this link: Intuit Developers.
  2. Select API Docs & Tools at the top, and then QuickBooks Desktop.
  3. Choose API Reference, Code Samples, SDKs, or Docs depending on what you need.
    q255.PNG
  4. If you want further help, click the question mark icon at the top instead.
  5. Select QuickBooks Desktop again, and then click Ask a Question.
    q256.PNG
  6. Follow the on-screen prompts to proceed.

 

When you're all up, you can start importing or exporting your IIF files into QuickBooks Desktop. Also, you can perform more tasks with your files, like bulk editing them, etc. Please head to this link for additional details: Tasks you can do with IIF files.

 

You can tap me anytime if you have other concerns about IIF files in QuickBooks. I'd be happy to extend a helping hand.

nhmilleraz
Level 1

Looking for a Data Dictionary / Interface Spec for IIF Data Import to QB Pro Desktop

Thanks ReyJohn_D...   I'd found a lot of what you referenced - am looking at the SDK now... 

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