| Doc Number | Str 21 | MANDATORY FIELD - Sales Receipt Reference number, duplicate Doc Numbers are accepted in QuickBooks, see also Auto Numbering |
| Txn Date | date | The date of the sales receipt, If you leave Txn Date out the mapping, the current date in QuickBooks Online will be used. |
| Department | Str | Name of the department, specifying the location of the transaction
|
| Private Note | Str 4000 | User entered, organization-private note about the transaction. This note will not appear on the transaction records by default. |
| Custom Field Name 1.. | Str | The label or custom field name. More here |
| Custom Field Value 1.. | Str | The custom field value. More here |
| Txn Status | Enum | The status of the transaction. Possible values are Draft, Overdue, Pending, Payable, Paid, Trash, UnPaid |
| Line Description | Str 4000 | A descriptive text field for the Item |
| Line Amount | Num 10.5 | MANDATORY FIELD - The Amount of the line item ie Qty x Unit Price |
| Line Sales Item Ref | | MANDATORY FIELD - The name of the item sold (can be service, inventory, non-inventory or bundle type items) |
| SKU | | The SKU identifier of the item sold, used as an alternative see SKU Lookup |
| Line Sales Item Class | | Class for the line item |
| Line Sales Item Unit Price | Decimal | Unit price of the item |
| Line Sales Item Qty | Decimal | Number of items sold |
| Line Sales Item Tax Code | | Tax code used for the item. More |
| Line Sales Item Service Date | Date | Date that the service was performed |
| Line Discount Amount | | The amount of the discount |
| Line Discount Percent Based | Boolean | True if discount is a percent, False if based on amount |
| Line Discount Percent | | Percentage by which amount due is discounted for 8.5% use 8.5 |
| Line Discount Account | | Account used to track discounts |
| Txn Tax Code Name | | Reference to the transaction tax code. More |
| Total Tax | | Total calculated tax for the transaction. More |
| Tax Line Amount | | Amount |
| Tax Percent Based | | True - sale tax as a percentage, False - sales tax as an amount |
| Tax Percent | | Percentage of the tax line ie 8.5% use 8.5 |
| Customer Fully Qualified Name | | Full name of the customer or job |
| Customer Memo | Chars 1000 | User entered message appears on the printed invoice |
| BillAddr1.. etc | | Billing Address lines 1-5, City, State, Postal Code and Country see importing address into QuickBooks for more information |
| ShipAddr1.. etc | | Shipping Address lines 1-5, City, State, Postal Code and Country see importing address into QuickBooks for more information |
| Class | | Class associated with the entire transaction |
| Ship Method | | Method of shipment used |
| Ship Date | Date | Date the transaction was shipped |
| Tracking Num | Str | Shipping providers tracking number |
| Print Status | Enum | Printing status of the sales receipt - NotSet, NeedToPrint, PrintComplete |
| Email Status | | Email status fo the invoice - NotSet, NeedToSend, EmailSent, SendNow more here on how to send automatically |
| Bill Email | | Email address where the Sales Receipt is sent |
| Shipping | AMT | The amount of shipping to be charged on the sales receipt |
| Payment Ref Number | | Reference number for the payment |
| Payment Method | | Reference to the method of payment |
| Deposit To Account | | Bank account where the payment money is deposited, if not specified defaults to Undeposited Funds |
| Currency Ref | | Reference to the currency used by the transaction, more here |
| Exchange Rate | | Currency Exchange rate, only if company file is set to use Multi-Currency, recorded in number of home currency units more here |
| Global Tax Calculation | | Method to which tax is applied (non US editions only) - TaxExcluded, TaxInclusive or NotApplicable |