Date Format

  

Default date format is dd-MM-yyyy, for example: 10-09-2015. You can change this format on Import Setting while uploading your file.


Time Format

 

The time format is HH:MM where HH means hours & MM means Minutes


Boolean

 

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 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