| Doc Number | Str 21 | MANDATORY FIELD - Bill reference number, duplicate Doc Numbers are accepted in QuickBooks, see also Auto Numbering |
| Txn Date | date | The date of the bill, If you leave Txn Date out the mapping, the current date in QuickBooks Online will be used. |
| Private Note | Str 4000 | User entered, organization-private note about the transaction. This note will not appear on the transaction records by default. |
| Department Ref | | The department of Location used to classify the Bill |
| Currency Ref | Currency Code | The currency that is being used on the bill (only required if not Home Currency) ie USD, EUR, AUD, GBP more |
| Exchange Rate | Decimal | The number of home currency units equal to one of the currency being imported (ie Currency Ref) more |
| Line Description | | Description for the expense line |
| Line Amount | | Amount of the expense |
| Line Customer Ref | | Customer name associated with the expense |
| Line Account Class | | Class associated with the expense |
| Line Account Ref | | Name of the expense account |
| Line Billable Status | | Billable status of the expense values Billable, NotBillable, HasBeenBilled |
| Line Account Tax Code | | Tax code associated with the expense line |
| Vendor Ref | | MANDATORY FIELD - Full name of the vendor |
| AP Account | | The Accounts Payable account the purchase is credited |
| Sales Term | | Reference to the terms for the purchase |
| Due Date | | Date payment is due if not provided defaults to Sales Terms date |
| Global Tax Calculation | | Method to which tax is applied - TaxExcluded, TaxInclusive or NotApplicable |
| Line Item Description | Str 4000 | A descriptive text field for the Item |
| Line Item Amount | Num 10.5 | MANDATORY FIELD - The Amount of the line item ie Qty x Unit Price |
| Line Item Ref | | MANDATORY FIELD - The name of the item purchased |
| Line Item Class | | Class for the line item |
| Line Item Qty | Decimal | Number of items ordered |
| Line Item Unit Price | Decimal | Unit price of the item |
| Line Item Tax Code | | Tax code used for the item |
| Line Item Customer | | Customer associated with the item purchase |
| Line Item Billable Status | | Billable status of the Item line values Billable, NotBillable, HasBeenBilled |