What kinds of files can I import to QuickBooks Online

QuickBooks Online > Intuit App Center - Transaction Pro Importer for QuickBooks Online
The following file formats are supported in the Transaction Pro Importer for QuickBooks Online
  • Excel 2007-2010 (.xls, .xlsx, .xlsb)
  • Excel 97-2003 (.xls)
  • CSV Comma Separated Text (.csv, .txt)
  • 2MB or 1,000 rows maximum size
Other requirements:
  • Be sure the column headers are in the first row
  • If these are multi-line transactions make sure each line of the same transaction has the same value and this is mapped to the QB field, RefNumber
Data Formatting Tips:
Sample Import Files:

Add Feedback