You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
Home > How to Import Using Transaction Pro Importer > Online Importer > Import Bill Payments into QuickBooks Online
Import Bill Payments into QuickBooks Online
print icon



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




Below are some helpful tips to keep in mind regarding the most common issues that occur when importing Bill Payments into QuickBooks Online with Importer.


  • The following fields are required (at minimum) when importing a Bill Payment.
    • RefNumber
    • Vendor
    • Bank or CC Account (the GL Account name or number)
    • BillApplyTo (bill must already exist in QuickBooks Online)
    • LineAmount (amount to be paid on bill)


  • Each line of the same Bill Payment should have the same Reference Number on every line with that column mapped to the QuickBooks Online field REFNUMBER on the Importer mapping screen.


  • Importer supports both Account Numbers and Account Names. However, only include 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.


  • The Line Amount can be positive or negative. However, the net of all Line Amounts on a single Bill Payment must be greater than zero.


  • The Line Amount applied to each separate Bill cannot be greater than the balance due remaining on that Bill.


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


1 out of 6 found this helpful

scroll to top icon