Microsoft excel

Quickbooks Online Support >

What data can be imported from Excel into QuickBooks Online?

Quickbooks Online can be used to import the following things from Microsoft Excel.

A user can import customer and supplies data from Quickbooks
A user can import their product and service’s data from Excel to Quickbooks Online.
A user can import his or her Charts of Account in Quickbooks Online.
Quickbooks Online can also export reports to Microsoft Excel […]

Details


Open an IIF file with Microsoft Excel to edit list information

After you have exported your lists to your desktop (or other location) as IIF files, you need to open these files in Microsoft Excel. edit the files, and then save them again as IIF files.
Detailed Instructions

Open the IIF file you exported from your company file in Excel.

Open Microsoft Excel.
Choose File > Open (if using Excel […]

Details