IIF Edit

Holly31 · ‎August 18, 2020

We want to import an IIF file from our vendor's website for faster, more efficient entry of their bills. We downloaded one as a test and I followed these instructions to view it before attempting to import it.

Edit an IIF file

In Microsoft Excel, go to File and select Open.
Browse to your IIF file.
In the File type drop-down, select All Files.
Select the IIF and then select Open.
In the Text Import Wizard, select Next, then Next and Finish.
Make the changes to your IIF file.
Go to the File menu and select Save.
Select Yes.
Close Excel. You'll get a prompt to save the IIF again. Select Don't Save.

However, here's what I see in Excel:

LÀF›

Oˆ`uÖÄð}ˆ`uÖÄð}ˆ`uÖ¤ôPàOÐ

ê:i¢Ø+00:.€9Ž#K˜&]™BŽ_&&ï¾X-{Å ôÕžârˆ`uÖžârˆ`uÖ¤2¤Qñh

HAJOCA~2.IIFˆ ï¾QðhQñh.^é<¾HAJOCA_EASTERN_E121275_20200818090730_0.iifq-p¤ØªC:\Users\Liz\Downloads\HAJOCA_EASTERN_E121275_20200818090730_0.iif8..\Downloads\HAJOCA_EASTERN_E121275_20200818090730_0.iifC:\Users\Liz\Downloads` Xmj03nqa7-terry.PÂÔ¤—E–ïOƒ‚ŒçÜ†úNáê›ØËŠÝY.PÂÔ¤—E–ïOƒ‚ŒçÜ†úNáê›ØËŠÝYE 91SPS±mDpH§H@.¤=xŒhH–™ÿšÈD¤˜‡ËêÞ

What's going on?

BigRedConsulting · ‎August 18, 2020

Not sure what that is, but it's not an IIF file.

It sort of looks like a list of IIF file names, stored in some sort of non-text file type.

Holly31 · ‎August 18, 2020

Thanks for the input. Would you suggest that we try a csv or excel download? Which would you recommend?

Angelyn_T · ‎August 18, 2020

Hello there, @Holly31.

We have to use .IIF files when importing transactions to QuickBooks Desktop (QBDT). That said, you need to use an Excel .IIF file when preparing your vendor bills for import. You don't need to worry since the system makes it easy for you to import or export .IIF files since QBDT prepared file-formats readily available. To get started, you can download and install the .IIF import kit to save time and improve your results.

When trying to import the file, you must review the details from there first. Double-check the account names used, the spelling and any other typographical error, and ensure that the names used exist and are acceptable in QuickBooks. You can find some sample files that give you the correct format and instructions to help import your transactions accordingly from these articles:

Also, check out this link for other ways on how to import and export data in QBDT.

If you have any other questions, just leave a comment below. I'm always here to help. Keep safe always!

Fiat Lux - ASIA · ‎August 18, 2020

@Holly31

You may need a 3rd party tool to import data from CSV/XLS format.

https:// transactionpro.grsm.io/qbd

https:// partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

Holly31 · ‎August 20, 2020

Wow! How complicated. Not sure that I have the time to invest in this. No wonder my client has been manually entering invoices. If there's a simple step by step, I'm all ears. I'm good but not an IT professional!

Fiat Lux - ASIA · ‎August 20, 2020

Which Ecommerce platform do you have? You may consider a connector to automate the process.

Holly31 · ‎August 20, 2020

Not using ecommerce...this is a construction contractor

Fiat Lux - ASIA · ‎August 20, 2020

You mentioned "website" in your first post. Do they use a construction management app? You can prepare the Invoice data in XLS and import them into QBD file in bulk

Customer

Transaction Date

RefNumber

PO Number

Terms

Class

Template Name

To Be Printed

Ship Date

BillTo Line1

BillTo Line2

BillTo Line3

BillTo Line4

BillTo City

BillTo State

BillTo PostalCode

BillTo Country

ShipTo Line1

ShipTo Line2

ShipTo Line3

ShipTo Line4

ShipTo City

ShipTo State

ShipTo PostalCode

ShipTo Country

Phone

Fax

Email

Contact Name

First Name

Last Name

Rep

Due Date

Ship Method

Customer Message

Memo

Cust. Tax Code

Item

Quantity

Description

Price

Is Pending

Item Line Class

Service Date

FOB

Customer Acct No

Sales Tax Item

To Be E-Mailed

Other

Other1

Other2

Unit of Measure

AR Account

Currency

Exchange Rate

Sales Tax Code

Anne's Bakery

01/09/2020

100

Y

15/09/2020

Anne's Bakery

One Harbor Street

Anytown

NY

12345

USA

Anne's Bakery

One Harbor Street

Anytown

NY

12345

USA

(123) 456-7890

Non

Cabinets

10

Cabinets

1000

Non

Anne's Bakery

01/09/2020

100

Y

15/09/2020

Anne's Bakery

One Harbor Street

Anytown

NY

12345

USA

Anne's Bakery

One Harbor Street

Anytown

NY

12345

USA

(123) 456-7890

Non

Hardware

10

Hardware

50

Non

John's Barber Shope

02/09/2020

101

Y

15/09/2020

John's Barber Shope

1 Main Street

Anytown

NY

12345

USA

John's Barber Shope

1 Main Street

Anytown

NY

12345

USA

(999) 888-8888

Non

Blueprints

1

Blueprints

500

Non

Holly31 · ‎August 21, 2020

No. They use QB Enterprise 2020 for Contractors. I'm reaching the conclusion that this platform is not right for the client.

Holly31 · ‎August 21, 2020

Where do I find the template and directions for bulk loading bills using Excel

@Fiat Lux - ASIA wrote:
You mentioned "website" in your first post. Do they use a construction management app? You can prepare the Invoice data in XLS and import them into QBD file in bulk
Customer Transaction Date RefNumber PO Number Terms Class Template Name To Be Printed Ship Date BillTo Line1 BillTo Line2 BillTo Line3 BillTo Line4 BillTo City BillTo State BillTo PostalCode BillTo Country ShipTo Line1 ShipTo Line2 ShipTo Line3 ShipTo Line4 ShipTo City ShipTo State ShipTo PostalCode ShipTo Country Phone Fax Email Contact Name First Name Last Name Rep Due Date Ship Method Customer Message Memo Cust. Tax Code Item Quantity Description Price Is Pending Item Line Class Service Date FOB Customer Acct No Sales Tax Item To Be E-Mailed Other Other1 Other2 Unit of Measure AR Account Currency Exchange Rate Sales Tax Code
Anne's Bakery 01/09/2020 100 Y 15/09/2020 Anne's Bakery One Harbor Street Anytown NY 12345 USA Anne's Bakery One Harbor Street Anytown NY 12345 USA (123) 456-7890 Non Cabinets 10 Cabinets 1000 Non
Anne's Bakery 01/09/2020 100 Y 15/09/2020 Anne's Bakery One Harbor Street Anytown NY 12345 USA Anne's Bakery One Harbor Street Anytown NY 12345 USA (123) 456-7890 Non Hardware 10 Hardware 50 Non
John's Barber Shope 02/09/2020 101 Y 15/09/2020 John's Barber Shope 1 Main Street Anytown NY 12345 USA John's Barber Shope 1 Main Street Anytown NY 12345 USA (999) 888-8888 Non Blueprints 1 Blueprints 500 Non

?

Fiat Lux - ASIA · ‎August 21, 2020

The template for Bills data

Vendor

Transaction Date

RefNumber

Bill Due

Terms

Memo

Address Line1

Address Line2

Address Line3

Address Line4

Address City

Address State

Address PostalCode

Address Country

Vendor Acct No

Expenses Account

Expenses Amount

Expenses Memo

Expenses Class

Expenses Customer

Expenses Billable

Items Item

Items Qty

Items Description

Items Cost

Items Class

Items Customer

Items Billable

Unit of Measure

AP Account

Currency

Exchange Rate

Bell Telephone

01/09/2020

123

#########

Net 30

Office Telephone

Bell Telephone

1 Main Street

Newton

NY

12345

USA

Telephone

1000

Sales Line

Bell Telephone

01/09/2020

123

#########

Net 30

Office Telephone

Bell Telephone

1 Main Street

Newton

NY

12345

USA

Telephone

500

Service Line

Ajax Lumber

01/09/2020

400

#########

Net 30

Repairs

Ajax Lumber

200 Smith Street

Anytown

NY

11111

USA

Repairs

750

Front Door

You will need a 3rd party tool as I mentioned earlier.

Holly31 · ‎August 21, 2020

Well, that's not happening so guess we are just out of luck. Thanks for stepping in with suggestions. I do appreciate it even if it does not make sense for the client. There are simply too many gaps for them to invest more money in QB.

Topics

Training

Community

Resources

IIF Edit

IIF Edit

IIF Edit

IIF Edit

IIF Edit

IIF Edit

IIF Edit

IIF Edit

IIF Edit

IIF Edit

IIF Edit

IIF Edit

IIF Edit

Need to get in touch?