Import bill payments into QuickBooks Online

You can import bill payments directly into QuickBooks Online from text files and Excel files using Zed Axis.
QuickBooks Online Field Format Description
DocNumber Str 21 MANDATORY FIELD - Bill Payment Reference number, duplicate DocNumbers are accepted in QuickBooks, see also Auto Numbering
Txn Date date The date of the bill payment, If you leave TxnDate out the mapping, the current date in QuickBooks Online will be used.
Department Ref   Location of the transaction
Currency Ref Str Reference to the currency used by the transaction
Exchange Rate Str Currency Exchange rate, only if company file is set to use Multi-Currency, recorded in number of home currency units
PrivateNote Str 4000 User entered, organization-private note about the transaction. This note will not appear on the transaction records by default.
Line Discount Amount Decimal The amount of the discount
Line Discount PercentBased Boolean True if discount is a percent, False if based on amount
Line Discount Percent   Percentage by which amount due is discounted for 8.5% use 8.5
Line Discount Account Str Account used to track discounts
Vendor Ref Str Full name of the vendor or payee
AP Account Ref Str Specifies the payables account (must be liability and payables type)
Pay Type Str The payment type (values Check or CreditCard)
Bank Account Ref Str Bank account if Check pay type
Printstatus Enum (values NotSet, NeedToPrint, PrintComplete)
CC Account Ref Str Credit Card account if CreditCard pay type
Totalamt Decimal The total amount of the bill payment
ApplytoBillRef Str The reference number of the bill being paid


By Steve Batten


Add Feedback