Doc Number | Str 21 | MANDATORY FIELD - Expense reference number, duplicate DocNumbers are accepted in QuickBooks, see also Auto Numbering |
Txn Date | date | The date of the expense, If you leave TxnDate 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. Maps to memo field on expense |
Payment Method Ref | Str | The payment method used for the expense |
Department Ref | Str | The name of the department or location, must match the full name location list held in QuickBooks Online |
Currency Ref | Currency type | The name of the currency used on the expense, ie USD, CAD, EUR, AUD, GBP - default is the home currency, only if Multicurrency is on. More here |
Exchange Rate | Decimal | The number of home currency units equal to one unit of the Currency specified. More here |
Line Description | Str 4000 | Description for the item purchased |
Line Amount | Num 10.5 | MANDATORY FIELD (if Item purchase) - The Amount of the line item ie Qty x Unit Price |
Line Item Ref | Str | MANDATORY FIELD (if Item purchase) Full Name of the item purchased |
Line Class Ref | Str | Full Class Name associated with the item purchased |
Line Item Qty | Decimal | Number of items purchased |
Line Item Unit Price | Decimal | Price of the item purchased |
Line Item Tax Code | Str | Tax code associated with the item purchased |
Line Customer Ref | Str | Customer associated with the item purchased |
Line Billable Status | Enum | Billable status of the item purchased values Billable, NotBillable, HasBeenBilled |
Line Account Description | Str 4000 | Description for the Expense Account |
Line Account Amount | Num 10.5 | MANDATORY FIELD (if Account purchase) - The Amount of the expense purchase |
Line Account Customer | Str | Customer associated with the expense |
Line Account Class | Str | Class for the expense |
Line Account Ref | Str | MANDATORY FIELD (if Account purchase) Expense account (should be the full name not including the number and should match what is in QuickBooks Online) |
Line Account Billable Status | Enum | Billable status of the expense values Billable, NotBillable, HasBeenBilled |
Line Account Tax Code Ref | Str | Tax Code associated with the purchase |
Account Ref | | The bank account the expense purchase is made from |
Entity Type | Enum | MANDATORY FIELD - Type of Payee (values Customer, Vendor or Employee) |
Entity Ref | Str | MANDATORY FIELD - Full name of the payee (Vendor, Employee etc..) |
Print Status | Enum | Whether you need to print or not (value NeedToPrint) |
Global Tax Calculation | | Method to which tax is applied - TaxExcluded, TaxInclusive or NotApplicable only applicable for Non-US company files |