Default date format is dd-MM-yyyy, for example: 10-09-2015. You can change this format on Import Setting while uploading your file.
The time format is HH:MM where HH means hours & MM means Minutes
Fields that require a true/false value accept the following case-insensitive formats.
|TRUE||true, 1, y, yes|
|FALSE||false, 0, n, no|
If your value is different from listed above, the final value will be FALSE.
Restricted Values / Enumerations
|Field Name||Allowed Values||Default Value|
|Transaction Status||Accepted, Closed, Pending, Rejected||Pending|
|Global Tax Calculation||TaxExcluded, TaxInclusive, NotApplicable ||TaxInclusive|
|Currency Code||AED, AFA, ALL, ANG, AOA, AOK, ARP, ARS, AMD, ATS, AUD, AWF, AWG, AZM, BAM, BBD, BDT, BEF, BGL, BHD, BIF, BMD, BND, BOB, BRC, BRL, BSD, BTN, BUK, BWP, BYR, BYB, BZD, CAD, CDF, CHF, CLP, CNY, COP, CRC, CZK, CUP, CVE, DDM, DEM, DJF, DKK, DOP, DZD, ECS, EEK, EGP, ERN, ESP, ETB, EUR, FIM, FJD, FKP, FRF, GBP, GEL, GHC, GIP, GMD, GNF, GRD, GTQ, GWP, GYD, HKD, HNL, HRK, HTG, HUF, IDR, IEP, ILS, INR, IQD, IRR, ISK, ITL, JMD, JOD, KES, KGS, KHR, KMF, KPW, KRW, KWD, KYD, KZT, LAK, LBP, LKR, LRD, LSL, LTL, LUF, LVL, LYD, MAD, MDL, MGF, MKD, MMK, MNT, MOP, MRO, MUR, MVR, MWK, MXN, MXP, MYR, MZM, NAD, NGN, NIC, NIO, NLG, NOK, NPR, NZD, OMR, PAB, PEN, PES, PGK, PHP, PKR, PLN, PLZ, PTE, PYG, QAR, ROL, RUR, RWF, SAR, SBD, SCR, SDD, SDP, SEK, SGD, SHP, SIT, SKK, SLL, SM, SOS, SRG, STD, SUR, SVC, SYP, SZL, THB, TMM, TND, TOP, TRL, TTD, TWD, TZS, UAH, UGS, UGX, USD, UYP, UYU, UZS, VND, VUV, VAL, WST, XAF, XCD, XOF, XPF, YER, YUD, ZAR, ZMK, ZRZ, ZWD|| |
|Gender||Male, Female|| |
|Type||Service, Inventory, NonInventory||NonInventory|
|Preferred Delivery Method||Print, Email, None||None|
|Order Status||Open, Closed||Open|
US Sales Tax Code Reference
The Sales Tax Code's can be found in QuickBooks US by navigating to Sales Tax (left navigation bar) > Add/edit tax rates and agencies
California, Tucson, AZ State tax and Tucson City are Sales Tax Code's in the below screenshot.
Global Tax Code Reference
Tax code's can be found in QuickBooks Global by navigating to Sales Tax [OR] VAT [OR] GST (left navigation bar) > Rates & settings