Field Name | Format | Description |
Invoice No | Text should be Max : 11 Characters | Reference number for the transaction. By default, this value is used only for internal processing by dancing numbers Transactions, and QuickBooks auto-generates a new value. It can be changed in the import settings. |
Customer * | Reference Text Max Length should be 41 Characters | Reference to the customer. Customer reference can be matched through Full Name, First Name, Company Name, Account NO., Resale NO., Custom Field, Look up (configured through (Import Settings) |
Invoice Date | Date | Transactions date |
Due Date | Date | Date on which transactions payment is due |
Terms | Text max length should be: 11 Characters | Payment Terms |
PO No | Reference Text | Purchase Order number |
Ship Date | Date | Date on which the item is shipped. |
Shipping Address Line 1 | Text (Max Length should be : 41 Characters) | First line of the shipping address. |
Shipping Address Line 2 | Text (Max Length needs to be 41 Characters) | Second line of the shipping address. |
Shipping Address Line 3 | Text (Max Length should be: 41 Characters) | Third line of the shipping address. |
Shipping Address City | Text (Max Length needs to be : 31 Characters) | Shipping address – City |
Shipping Address State | Text (Max Length: 21 Characters) | Shipping address – Should be mentioned State or Province |
Shipping Address – Postal Code | Text (Max Length: 13 Characters) | Shipping address with the Postal Code |
Shipping Address – Country | Text (Max Length: 41 Characters) | Shipping address including Country |
FOB | Text ( Max Length : 13 Characters) | The destination of FOB |
Billing Address Line 1 | Text (Max Length: 41 Characters) | Billing address’s first line. |
Billing Address Line 2 | Text (Max Length: 41 Characters) | Second line of billing address. |
Billing Address Line 3 | Text (Max Length: 41 Characters) | billing address third line |
Billing Address City | Text (Max Length: 31 Characters) | Billing address having City |
Billing Address State | Text (Max Length: 21 Characters) | Billing address with State or Province |
Billing Address Postal Code | Text (Max Length: 13 Characters) | Billing address having Postal Code |
Billing Address Country | Text (Max Length: 41 Characters) | Billing address as Country |
Sales Rep | Reference Text | Sales rep associated with the transactions |
Shipping Method | Reference Text | Shipping method associated with the transaction |
Print Later | Boolean (True/False) | Print Status |
Email Later | Boolean (True/False) | Email Status |
Memo | Text(Max Length ; 4095 Characters) | A written message |
Customer Message | Reference Text | A message given to the customer available from the list in QuickBooks |
Class | Reference Text (Max Length: 31 Characters) | The class of transaction |
Product/Service * | Reference Text (Max Length: 31 Characters) | Item with below options such as Item Look up Strategies including Import Settings- Full Name, Look up and Custom Field |
Product/Service Quantity | Decimal | Quantity of the product |
Product/Service Rate | Decimal | Rate of the product |
Unit Of Measure | Reference Text | Measuring Unit in which product is being measured |
Product/Service Description | Text (Max Length: 4095 Characters) | Description of the product or service |
Product/Service Service Date | Date | Date when the service or product is fulfilled |
Product/Service Class | Reference Text (Max Length: 31 Characters) | Class in which product or service lies |
Product/Service Sales Tax | Reference Text | Sales Tax associated with product or service |
Other | Text (Max Length: 29 Characters) | Description |
Other 1 | Text (Max Length: 29 Characters) | Description |
Other 2 | Text (Max Length: 29 Characters) | Description |
Sales Tax | Reference Text | Sales tax code transaction |
Customer Sales Tax Code | Reference Text | Tax Code related to Transaction |
Template | Reference Text | Template related to Invoice |
AR Account | Reference Text | Accounts Receivable account related to this Invoice |
Product/Service Inventory Site | Reference Text | Related to the product site |
Product/Service Inventory BIN | Reference Text | Related to BIN item reference to the site. It need to mentioned on the site BIN format |
Amount Received | Decimal | The amount which is received |
Currency | Text | Reference to the Currency in which amounts with the associated transaction are mentioned |
Exchange Rate | Decimal | Default is 1, it is applicable when multi company option is enabled for company. Number of home currency units leads to equal to one unit of currency mentioned under currency |
Tax Inclusive | Boolean (True/False) | Tax calculation method. |