Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
Peggy - Power Driven
Level 2

IIF files and classes

-Has anyone imported IIF Files to Enterprise 2023? How does it work with Classes? 

9 Comments 9
BigRedConsulting
Community Champion

IIF files and classes

Classes generally work fine with 2023, just like older QB versions.

Peggy - Power Driven
Level 2

IIF files and classes

I’m not familiar with iif files. Are you saying classes are part of these files?

BigRedConsulting
Community Champion

IIF files and classes

Yes, IIF files do support the class field on transactions.

4Gal
Level 11

IIF files and classes

@Peggy - Power Driven 

What transaction type do you need to import with Class? Invoices, Bills, Sales Receipts, or else?

You can use a 3rd party solution to do so.

Petra72
Level 2

IIF files and classes

Could someone explain how it works? 

Thank you

 

Kurt_M
Moderator

IIF files and classes

The IFF files allow for the import and export of data, while Classes are functionalities that enable you to monitor various segments of your business in QuickBooks Desktop (QBDT). I will provide additional information below and guide you through the process to help you integrate it into your business operations.

 

Intuit Interchange Format (.IIF) files are ASCII text files that utilize a Tab-Separated Value (TSV) format. These are files that you can use to import or export lists or transactions in or out of your company. To import this in QBDT, these are the steps:

 

  1. Go to the File menu, select Utilities then Import then IIF Files.
  2. Select Import IIF.
  3. Locate the file, then select OK. A reminder,  we don't recommend the option Import it for me. I'll fix it later. Since this option bypasses data review, some of the info may not be correct or complete for your books. It also requires that you switch to a single user.
     

You'll need to follow the on-screen instructions, and once the import is successful, you'll see the numbers of lists and transactions imported, and you can press Done. Feel free to review the image below for seamless navigation.

 

 

 

 

To export the files out of your company, you can visit this page for more details: IIF Overview: import kit, sample files, and headers.

 

On the other hand, you'll need to turn on the Class feature from your company file and set it up before using it. To enable this option, these are the steps:

 

  1. Go to the Edit menu, then select Preferences.
  2. Select Accounting, then go to the Company Preferences tab.
  3. Click the Use class tracking for transactions checkbox.
  4. If you want a reminder when you haven't assigned a class, select the Prompt to assign classes checkbox.
  5. Select OK.

 

I've added a screenshot for visual reference.

 

 

For more information and further guidelines on how to use it, please see this article: Set up and use class tracking in QuickBooks Desktop.

 

In addition, here's an article to give you insights on what data can be exported or imported: Export, import, and edit IIF files.


Are you looking for assistance monitoring various aspects of your business through reports, or do you have additional inquiries related to QuickBooks? I'll be here to lend you a hand anytime. Feel free to click the Reply button below, and I will respond to your questions as soon as possible. Take care.

Chrea
Level 8

IIF files and classes

@Petra72 

If you don't familiar with IIF, you should consider using an importer tool instead. It's a $199 one time license + you can get $200 cashback to purchase it from a partner.

https://get.transactionpro.com/qbd

 

Petra72
Level 2

IIF files and classes

Could you explain that?

Thank you

Chrea
Level 8

IIF files and classes

@Petra72 

If you are interested in getting a free TP Importer license, you can contact @Fiat Lux - ASIA for details.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us