| Invoice # |
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 |
| Customer |
Customer * |
Specifies the customer reference for this transaction. |
| Invoice Date |
TxnDate |
Date of the transaction. |
| Due Date |
DueDate |
Due date. |
| Shipping Date |
ShipDate |
Date of shippping |
| Ship Via |
ShipMethodName |
Reference to the shipping method. |
| Tracking No. |
TrackingNum |
Tracking number |
| Online Payments |
AllowIPNPayment |
Allow IPN payment.
To allow use any of the following values: 1, t, true, y, yes.
Field default is False(not set). |
| Online Payments(Card) |
AllowOnlineCreditCardPayment |
Allow online credit card payment.
To allow use any of the following values: 1, t, true, y, yes.
Field default is False(not set). |
| Online Payments(Bank Transfer) |
AllowOnlineACHPayment |
Allow online ACH payments.
To allow use any of the following values: 1, t, true, y, yes.
Field default is False(not set). |
| Terms |
SalesTerm |
Reference to sales term. |
| Location |
Location |
Department associated with the transaction. |
| Class |
Class |
Class associated with the transaction. |
| Billing Address Line 1 |
BillAddrLine1 |
Billing address line 1 |
| Billing Address Line 2 |
BillAddrLine2 |
Billing address line 2 |
| Billing Address Line 3 |
BillAddrLine3 |
Billing address line 3 |
| Billing Address Line 4 |
BillAddrLine4 |
Billing address line 4 |
| Billing Address City |
BillAddrCity |
Billing address line city. |
| Billing Address State |
BillAddrState |
Billing address line state |
| Billing Address PostalCode |
BillAddrPostalCode |
Billing address postal code. |
| Billing Address Country |
BillAddrCountry |
Billing address country. |
| Shipping Address Line 1 |
ShipAddrLine1 |
Shipping address line 1 |
| Shipping Address Line 2 |
ShipAddrLine2 |
Shipping address line 2 |
| Shipping Address Line 3 |
ShipAddrLine3 |
Shipping address line 3 |
| Shipping Address Line 4 |
ShipAddrLine4 |
Shipping address line 4 |
| Shipping Address City |
ShipAddrCity |
Shipping address line city. |
| Shipping Address State |
ShipAddrState |
Shipping address line state |
| Shipping Address PostalCode |
ShipAddrPostalCode |
Shipping address postal code. |
| Shipping Address Country |
ShipAddrCountry |
Shipping address country. |
| Statement memo |
PrivateNote |
Organization-private note(memo) about the transaction |
| Message Displayed On Invoice |
Msg |
Message associated with the invoice. |
| Email |
BillEmail |
Email address to which estimate neet to get emailed. |
| Cc Email |
BillEmailCc |
Cc Email address to which estimate neet to get emailed. |
| Bcc Email |
BillEmailBcc |
Bcc Email address to which estimate neet to get emailed. |
| Deposit |
Deposit |
Deposit amount associated with the invoice. |
| 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. |
| Send Later |
ToBeEmailed |
The email status.
To send email use any of the following values: 1, t, true, y, yes, needtosend.
To not send email use one of the following values: 0, f, false, n, no, notset.
For email that is already sent use one of the following values: emailsent.
Field default is notset(do not send email). |
| Shipping Amount |
ShipAmt |
Shipping amount. |
| Shipping Item |
ShipItem |
Reference to item within QuickBooks Online for the shipping expense. |
| Shipping Tax |
ShipTaxCode |
The name of the tax item to be used. |
| Tax Amount |
TaxAmt |
The dollar amount of the sales tax. |
| Tax Rate |
TaxRate |
The name of the tax item to be used. |
| Discount Amount |
DiscountAmt |
Discount amount. |
| Discount Rate |
DiscountRate |
Discount rate. |
| Discount Taxable |
DiscountTaxable |
Flag to highlight if discount amount is taxable or not.
To make it taxable use any of the following values: 1, t, true, y, yes.
To make it non taxable use any of the following values: 0, f, false, n, no.
Field default is false(not taxable). |
| 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: TaxExcluded, TaxInclusive, and NotApplicable. Default Value: NotApplicable. |
| Product/Service |
LineItem * |
Reference to the item. |
| Line Item Qty |
LineQty |
Number of items for the line. |
| Line Item Description |
LineDesc |
Description for the line item |
| Line Item ServiceDate |
LineServiceDate |
Service date of the line item. |
| Line Item Rate |
LineUnitPrice |
Unit price of the item in the line. |
| Line Item Amount |
LineAmount |
Amount of the line. |
| Line Item Taxable |
LineTaxable |
The taxable status of the expense line.
To make it taxable use any of the following values: 1, t, true, y, yes, tax.
Field default is NON(non taxable). |
| Line Item Tax |
LineTaxCode |
Tax code associated with the item based expense line item. |
| LineClass |
LineClass |
Class of item based expense line. |