| Expense # |
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/Credit 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. Valid values are: 1,t,true,y,yes,taxinclusive: taxinclusive; 0,f,false,n,no,taxexcluded: taxexcluded; 2: notapplicable; Default: notapplicable |
| 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. |