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

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 Comments 4
PatriciaT
QuickBooks Team

Import report to quickbook

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. 

 

 

 

Fiat Lux - ASIA
Level 15

Import report to quickbook

@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).

moutushi82
Level 1

Import report to quickbook

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.

moutushi82
Level 1

Import report to quickbook

Hi Fait Lux, thank you

Need to get in touch?

Contact us