cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover the updated GST rates in QuickBooks Online Singapore Find out more
JaneJJ
Level 1

How to import more than 100 invoices from excel file to QuickBooks Premier Edition 2013?

Hi,

Kindly advise how to import more than 100 invoices from excel file to QuickBooks Premier Edition 2013? 

Appreciate your prompt reply.

Thank you. 

2 Comments 2
RCV
QuickBooks Team
QuickBooks Team

How to import more than 100 invoices from excel file to QuickBooks Premier Edition 2013?

Great to have you here, JaneJJ.

 

We can import your invoices to QuickBooks Desktop 2013 using an Intuit Interchange Format (.IIF) file. We can convert the Excel file to IIF format to import and export invoices to and from QuickBooks Desktop. I'd suggest visiting the Intuit Marketplace to see applications that you can use in converting the file.IIF. 

 

Once you convert it, follow the steps below to import the invoice transactions:

  1. Log in to your company file as an admin.
  2. Go to File and select Switch to Single-user Mode.
  3. Make a backup of your company file. This way you can restore it if the data doesn't import the way you expected.
  4. Go to the File menu and choose Utilities.
  5. Click Import and hit Import IIF Files.
  6. Browse to your IIF file. Then, select it and tap Open.
  7. Press OK to confirm your data was imported.

For more details about this one, see Export or Import Intuit Interchange Format (.IIF) Files article. Please note since you're using an older version of QuickBooks Desktop, the steps above may or may not work. Feel free to our Bring in your data page for more insights about importing your data to QuickBooks Desktop.

 

I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Just reply to this post and I'll get back to you. You have a good one. 

Fiat Lux - ASIA
Level 15

How to import more than 100 invoices from excel file to QuickBooks Premier Edition 2013?

@JaneJJ 

If you are not familiar with IIF, utilize one of these importer tools

https://transactionpro.grsm.io/qbd

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

 

Prepare the Invoices data with following template

CustomerTransaction DateRefNumberPO NumberTermsClassTemplate NameTo Be PrintedShip DateBillTo Line1BillTo Line2BillTo Line3BillTo Line4BillTo CityBillTo StateBillTo PostalCodeBillTo CountryShipTo Line1ShipTo Line2ShipTo Line3ShipTo Line4ShipTo CityShipTo StateShipTo PostalCodeShipTo CountryPhoneFaxEmailContact NameFirst NameLast NameRepDue DateShip MethodCustomer MessageMemoCust. Tax CodeItemQuantityDescriptionPriceIs PendingItem Line ClassService DateFOBCustomer Acct NoSales Tax ItemTo Be E-MailedOtherOther1Other2Unit of MeasureAR AccountCurrencyExchange RateSales Tax Code
Anne's Bakery01/09/2020100    Y15/09/2020Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonCabinets10Cabinets1000              Non
Anne's Bakery01/09/2020100    Y15/09/2020Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonHardware10Hardware50              Non
John's Barber Shope02/09/2020101    Y15/09/2020John's Barber Shope1 Main Street  AnytownNY12345USAJohn's Barber Shope1 Main Street  AnytownNY12345USA(999) 888-8888          NonBlueprints1Blueprints500              Non