| Bill # |
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 |
| 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. |