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

Import Bills into QuickBooks Online

QUESTION

What are some helpful tips to know when importing Bills into QuickBooks Online (QBO) with Transaction Pro Importer?

RESOLUTION

Below are some helpful tips to keep in mind regarding the most common issues that occur when importing Bills into QBO with Importer.

  • When importing a Bill, the following fields are required (at minimum).
    • RefNumber
    • Vendor
  • Each line of the same Bill should have the same Reference number on every line and that column should be mapped to the QBO field REFNUMBER on the Importer mapping screen.
  • Importer supports both Account Numbers and Account Names. However, only use either the lowest Sub-Account Number or the entire Account Name in the import file, not both.
  • If using Account Numbers, on the Preview screen of Importer, click OPTIONS and select the option ENABLE ACCOUNT NUMBERS ON TRANSACTIONS.
  • These fields are required if importing Products or Services on the Item tab: LineItem, LineQuantity, and either LineUnitPrice or LineAmount.
  • These fields are required if using importing Expenses on the Accounts (Category) tab: ExpenseAccount and ExpenseAmount.

The below screenshot shows the entry screen for Bills in QBO with the location indicated into which each Transaction Pro Importer field will import.

  • 242
  • 26-Aug-2020
  • 2875 Views