You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close

File Formats Supported by Transaction Pro Importer for QuickBooks Online

QUESTION

What file formats are supported to be imported with Transaction Pro Importer into QuickBooks Online (QBO)? What other file requirements are there for importing into QBO with Importer?

RESOLUTION

The following file formats can be imported with Importer into QBO:

  • Excel 365 (.xls, .xlsx, .xlsb)

  • Excel 2007-2016 (.xls, .xlsx, .xlsb)

  • Excel 2003 (.xls)

  • Comma Separated Value (.csv)

Other requirements:

  • Maximum Import File Size: 4MB or 5000 rows

  • Column headers must be in the first row

  • Multi-line transactions must have the same reference number (RefNumber) for all rows of the same transaction

Data Formatting Tips:

  • If Accounts are part of the import file, include only the lowest Sub-Account Number OR the entire Account Name with each level separated with a colon and no space before or after the colon (ie. Account:SubAccount)  

  • If using Sub-Customers, Jobs, Sub-Classes, or Sub-Items in the import file, include the parent and the child in the same column with a colon separating the levels with no space before or after the colon (ie. Item:SubItem, Customer:SubCustomer, Customer:Job)

Sample Import Files:

  • Sample Import Files for Importer for QBO may be downloaded HERE.

  • 101
  • 07-Jan-2020
  • 1752 Views