Checks

Field Descriptions

QuickBooks Field Label QuickBooks Field Description
Check # RefNumber * Reference number for the transaction. By default, this value is used only for internal processing by Transaction Pro Importer and QuickBooks Online auto-generates a new value. This can be changed in the import options
Bank Account BankAccount * Bank account associated with the transaction.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.
Vendor Vendor * Specifies the vendor reference for this transaction
Vendor Name PrintOnCheckName Name of the vendor as printed on the check.
Payment Date TxnDate Date 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 Line City AddressCity Remit to address line city.
Mailing Address Line State AddressState Remit to address line state
Mailing Address Line PostalCode AddressPostalCode Remit to address postal code.
Mailing Address Line Country AddressCountry Remit to address country.
Memo PrivateNote Organization-private note(memo) about the transaction
Print Later ToBePrinted The print status.
To print use any of the following values: 1, t, true, y, yes, needtoprint.
To not print use one of the following values: 0, f, false, n, no, notset.
For completed print use one of the following values: printcomplete.
Field default is not set.
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.