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, 1, y, yes
||false, 0, n, no
If your value is different from listed above, the final value will be FALSE.
Restricted Values / Enumerations
||Accepted, Closed, Pending, Rejected
|Global Tax Calculation
||TaxExcluded, TaxInclusive, NotApplicable
||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
||Service, Inventory, NonInventory
|Preferred Delivery Method
||Print, Email, None
US Sales Tax Code Reference
The Sales Tax Code's can be found in QBO 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 QBO Global by navigating to Sales Tax [OR] VAT [OR] GST (left navigation bar) > Rates & settings