Data Formats for QuickBooks Import from SaasAnt Transactions (Online)
February 7, 2025
Date Format for QuickBooks Import
The default date format followed by QuickBooks Online is DD-MM-YYYY, for example: 10-09-2015.
You can change this format on Import Settings while uploading your file into QuickBooks online using the SaasAnt Transactions (Online) application.
Time Format for QuickBooks Import
The time format for QuickBooks Online is followed as HH:MM, where HH stands for hours and MM stands for Minutes.
Boolean Fields
QuickBooks 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 the 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 |
QuickBooks Online - US Sales Tax Code Reference
The Sales Tax Codes 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 Codes in the below screenshot.
QuickBooks Online - Global Tax Code Reference
The Tax codes can be found in QuickBooks Global by navigating to Sales Tax [OR] VAT [OR] GST (left navigation bar) > Rates & settings
