Accounts
Columns
Name
Type
ReadOnly
References
Filterable
Sortable
Description
Id [KEY]
String
True
true
true
The Id of the account.
SyncToken
String
True
false
false
Version number of the object. It is used to lock an object for use by one app at a time. As soon as an application modifies an object, its SyncToken is incremented. Attempts to modify an object specifying an older SyncToken fails. Only the latest version of the object is maintained by QuickBooks Online.
MetaData_CreateTime
Datetime
True
true
true
The time the record was created.
MetaData_LastUpdatedTime
Datetime
True
true
true
The time the record was last updated.
Name
String
False
true
true
The name of the account. To create an account, you must provide a unique account name. Default accounts are created for new companies.
SubAccount
Boolean
False
true
true
This value is true if the account is a subaccount, and false or null if it is a top-level account.
ParentRef
String
False
Accounts.Id
true
true
The Id of the parent account.
ParentRef_Name
String
True
Accounts.Name
false
false
The name of the parent account.
FullyQualifiedName
String
True
false
false
The fully qualified name of the account. The fully qualified name consists the topmost parent element followed by each subelement and separated by colons. For example: Parent:Account1:SubAccount1:SubAccount2.
Description
String
False
true
true
The description for the account. This may contain notes on the types of journal entries that should be posted to this account.
Active
Boolean
False
true
false
This field sets whether or not the account is active. Inactive accounts cannot be posted to and are excluded from search results, although references to them are preserved.
Classification
String
False
true
false
The account classification.
The allowed values are Asset, Equity, Expense, Liability, Revenue.
AccountType
String
False
true
false
The account type or subclassification that determines how the account is used. This field is indexed by the account classification.
The allowed values are Bank, Other Current Asset, Fixed Asset, Other Asset, Accounts Receivable, Equity, Expense, Other Expense, Cost of Goods Sold, Accounts Payable, Credit Card, Long Term Liability, Other Current Liability, Income, Other Income.
AccountSubType
String
False
false
false
The account subtype. This field is indexed by the AccountType field.
The allowed values are CashOnHand, Checking, MoneyMarket, RentsHeldInTrust, Savings, TrustAccounts, AllowanceForBadDebts, DevelopmentCosts, EmployeeCashAdvances, OtherCurrentAssets, Inventory, Investment_MortgageRealEstateLoans, Investment_Other, Investment_TaxExemptSecurities, Investment_USGovernmentObligations, LoansToOfficers, LoansToOthers, LoansToStockholders, PrepaidExpenses, Retainage, UndepositedFunds, AccumulatedDepletion, AccumulatedDepreciation, DepletableAssets, FurnitureAndFixtures, Land, NLeaseholdImprovements, OtherFixedAssets, AccumulatedAmortization, Buildings, IntangibleAssets, MachineryAndEquipment, Vehicles, LeaseBuyout, OtherLongTermAssets, SecurityDeposits, AccumulatedAmortizationOfOtherAssets, Goodwill, Licenses, OrganizationalCosts, AccountsReceivable, OpeningBalanceEquity, PartnersEquity, RetainedEarnings, AccumulatedAdjustment, OwnersEquity, PaidInCapitalOrSurplus, PreferredStock, CommonStock, TreasuryStock, AdvertisingPromotional, BadDebts, BankCharges, CharitableContributions, Entertainment, EntertainmentMeals, EquipmentRentalGlobalTaxExpenseInsurance, InterestPaid, LegalProfessionalFees, OfficeGeneralAdministrativeExpenses, OtherMiscellaneousServiceCost, PromotionalMeals, RentOrLeaseOfBuildings, RepairMaintenance, ShippingFreightDelivery, SuppliesMaterials, Travel, TravelMeals, Utilities, Auto, CostOfLabor, DuesSubscriptions, PayrollExpenses, TaxesPaid, Depreciation, ExchangeGainOrLoss, OtherMiscellaneousExpense, PenaltiesSettlements, Amortization, EquipmentRentalCos, OtherCostsOfServiceCos, ShippingFreightDeliveryCos, SuppliesMaterialsCogs, CostOfLaborCos, AccountsPayable, CreditCard, NotesPayable, OtherLongTermLiabilities, ShareholderNotesPayable, LineOfCredit, LoanPayable, GlobalTaxPayable, GlobalTaxSuspense, OtherCurrentLiabilities, PayrollClearing, PayrollTaxPayable, PrepaidExpensesPayable, RentsInTrustLiability, TrustAccountsLiabilities, FederalIncomeTaxPayable, InsurancePayable, SalesTaxPayable, StateLocalIncomeTaxPayable, NonProfitIncome, OtherPrimaryIncome, SalesOfProductIncome, ServiceFeeIncome, DiscountsRefundsGiven, DividendIncome, InterestEarned, OtherInvestmentIncome, OtherMiscellaneousIncome, TaxExemptInterest.
AcctNum
String
False
false
false
A user-defined account number that identifies the account within the chart of accounts and notes the information that should be posted to the account.
CurrentBalance
Decimal
True
true
true
The current balance. This field is available for only balance sheet accounts.
CurrentBalanceWithSubAccounts
Decimal
True
false
false
The cumulative current balance amount for the account and all its subaccounts.
CurrencyRef
String
False
false
false
The Id of the currency used by the account.
CurrencyRef_Name
String
True
false
false
A name that identifies the currency used by the account.
TaxCodeRef
String
False
TaxCodes.Id
false
false
The ID of the associated Tax Code. This ID can be used with the TaxCodes view to find more information about the associated tax. Only available in International versions of QuickBooks Online.
Last updated