Bills

Field Descriptions

QuickBooks Field Label QuickBooks Field Description
Bill # RefNumber * Reference number for the transaction. By default, this value is used only for internal processing by Transaction Pro Importer and QBO auto-generates a new value. This can be changed in the import options
Account APAccount Specifies to which AP account the transaction is credited. Many/most small businesses have a single AP account, so the account is implied. When specified, the account must be a Liability account, and further, the sub-type must be of type Payables.
Vendor Vendor * Specifies the vendor reference for this transaction
Vendor Name PrintOnCheckName Name of the vendor as printed on the check.
Bill Date TxnDate Date of the transaction.
Due Date DueDate Due date of the transaction.
Terms SalesTerm Sales term of the transaction.
Location Location Department associated with the transaction.
Mailing Address Line 1 AddressLine1 Remit to address line 1
Mailing Address Line 2 AddressLine2 Remit to address line 2
Mailing Address Line 3 AddressLine3 Remit to address line 3
Mailing Address Line 4 AddressLine4 Remit to address line 4
Mailing Address City AddressCity Remit to address line city.
Mailing Address State AddressState Remit to address line state
Mailing Address PostalCode AddressPostalCode Remit to address postal code.
Mailing Address Country AddressCountry Remit to address country.
Memo PrivateNote Organization-private note(memo) about the transaction
Currency Currency Currency associated with the transaction.
Exchange Rate ExchangeRate The number of home currency units it takes to equal one unit of currency specified by "Currency"
Amounts Are AmountsInclTax Method in which tax is applied.
To inlcude tax use any of the following values: 1, t, true, y, yes, taxinclusive.
To exclude tax use any of the following values: 0, f, false, n, no, taxexcluded.
To not apply tax use any of the following values: 2, notapplicable.
Field default is not applicable.
Expense Line Account ExpenseAccount Account associated with account based expense line item. Include only the account name or account number in this field and not both. If using Account Names in QuickBooks Online specify the entire account name, including any sub-account names and separate with account and sub-account with a colon in between (eg. Account:SubAccount). If using an account number include only the lowest sub-account number and enable the Transaction Pro Importer option, Enable Account Numbers.
Expense Line Amount ExpenseAmount Amount of account based expense line item.
Expense Line Description ExpenseDesc Description of account based expense line item.
Expense Line Class ExpenseClass Class of account based expense line item.
Expense Line Billable ExpenseBillableStatus The billable status of the expense.
To make it billable use any of the following values: 1, t, true, y, yes, billable.
To make it non billable use any of the following values: f, false, n, no, notbillable.
To make it already billed use any of the following values: 2, hasbeenbilled.
Field default is not billable.
Expense Line Customer ExpenseBillableEntity Customer associated with the account based expense line item.
Expense Line Tax ExpenseTaxCode Tax code associated with the expense line item.
Product/Service LineItem Reference to the item. Required field for product/service based line item.
Item Line Description LineDesc Description of the line item.
Item Line Qty LineQty Number of items for the line.
Item Line Rate LineUnitPrice Unit price of the item in the line.
Item Line Amount LineAmount Amount of the line.
Item Line Class LineClass Class of item based expense line.
Item Line Billable LineBillableStatus The billable status of the expense.
To make it billable use any of the following values: 1, t, true, y, yes, billable.
To make it non billable use any of the following values: f, false, n, no, notbillable.
To make it already billed use any of the following values: 2, hasbeenbilled.
Field default is not billable.
Item Line Customer LineBillableEntity Customer associated with the account based expense line item.
Item Line Tax LineTaxCode Tax code associated with the item based expense line item.