Skip to main content

BLACK FRIDAY SALE 70% OFF QuickBooks for 3 months* Ends 11/29

Buy now
Switch to QuickBooks and 70% off for 3 Months
Jul 29, 2020 9:21 PM UTC
Question

Import report to quickbook

Hi, I want to export a report  from PHP website for my client. They want to import that report to their quickbook account. Have generated .iif file but that one generate error on quickbook import. Please help me to solve this.

4 replies

PatriciaT
Jul 29, 2020 11:31 PM UTC

Hi TKMou,

 

Thanks for joining us! It's great you're using PHP and wanting to integrate your reports in QuickBooks Online. The import tool in the program allows you to bring over various types of information while ensuring your books are accurate. I'll be happy to assist you with this. 

 

With the import tool, you can import data such as.

  • Invoices
  • Customer
  • Bank Data
  • Bills
  • Suppliers 
  • Products and Services
  • Chart of Accounts
  • Journal Entries

The format required for each category is a CSV file. Bank Data can also be QFX, QBO, OFX, or TXT files. An IIF file will hence not be compatible with the system. You can either search online for an IIF to CSV converter or open the IIF file on a blank Excel workbook and save it as a CSV file.

 

To learn more about how to import data in QuickBooks Online, here are some articles.

I hope this helps! You're always welcome to stop by if you have more questions. 

 

 

 

Jul 30, 2020 5:02 PM UTC

Hi PatriciaT

Thank you so much for your reply. I just want to import all invoices from our system to quickbook. We populate a file from all those invoices & try to import to quickbook online. Our client was using .iif file for this. So we try to do so. But it's not working.

I'm sure about CSV. But will try CSV.

Thank you so much.

Fiat Lux - ASIA
Level 14
Jul 30, 2020 5:25 AM UTC

@TKMou 

You can convert IIF to CSV or XLS prior to importing to QBO. But you have to define your data as for which transaction type (e.g Invoice, Sales Receipt, Receive Payments).

Jul 30, 2020 5:03 PM UTC

Hi Fait Lux, thank you