You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
Home > How to Import Using Transaction Pro Importer > Online Importer > QuickBooks Online Chart of Accounts Import - Valid Account Type Values
QuickBooks Online Chart of Accounts Import - Valid Account Type Values
print icon

When importing a Chart of Accounts into QuickBooks Online using Transaction Pro Importer, the types listed below are the only valid Account and Sub-Account (Detail) types currently available to be used with Importer.

 

NOTE: There are no spaces between the words for the Account Types or Sub-Account Types.

 

Valid Account Type Values

 

Bank
AccountsReceivable
OtherCurrentAsset
FixedAsset
OtherAsset
AccountsPayable
CreditCard
OtherCurrentLiability
LongTermLiability
Equity
Income
CostofGoodsSold
Expense
OtherIncome
OtherExpense
 

Valid Sub-Account (Detail) Type Values

 

The valid Sub-Account (Detail) type values are listed below for each valid Account Type. There is also a downloadable Excel worksheet attached to this article with this information under the Attachments section, found either on the right-hand side or below the article, depending on the browser.

 

Bank AccountsReceivable
CashOnHand AccountsReceivable
Checking  
MoneyMarket  
RentsHeldInTrust  
Savings  
TrustAccounts  
   
   
OtherCurrentAsset FixedAsset
AllowanceForBadDebts AccumulatedAmortization
DevelopmentCosts AccumulatedDepletion
EmployeeCashAdvances AccumulatedDepreciation
Inventory Buildings
Investment_MortgageRealEstateLoans DepletableAssets
Investment_Other FurnitureAndFixtures
Investment_TaxExemptSecurities IntangibleAssets
Investment_USGovernmentObligations Land
LoansToOfficers LeaseholdImprovements
LoansToOthers MachineryAndEquipment
LoansToStockholders OtherFixedAssets
OtherCurrentAssets Vehicles
PrepaidExpenses  
Retainage  
UndepositedFunds  
   
   
OtherAsset AccountsPayable
AccumulatedAmortizationOfOtherAssets AccountsPayable
Goodwill  
LeaseBuyout  
Licenses  
OrganizationalCosts  
OtherLongTermAssets  
SecurityDeposits  
   
   
CreditCard OtherCurrentLiability
CreditCard DirectDepositPayable
  FederalIncomeTaxPayable
  GlobalTaxPayable
  GlobalTaxSuspense
  InsurancePayable
  LineOfCredit
  LoanPayable
  OtherCurrentLiabilities
  PayrollClearing
  PayrollTaxPayable
  PrepaidExpensesPayable
  RentsInTrustLiability
  SalesTaxPayable
  StateLocalIncomeTaxPayable
  TrustAccountsLiabilities
   
   
LongTermLiability Equity
NotesPayable AccumulatedAdjustment
OtherLongTermLiabilities CommonStock
ShareholderNotesPayable OpeningBalanceEquity
  OwnersEquity
  PaidInCapitalOrSurplus
  PartnerContributions
  PartnerDistributions
  PartnersEquity
  PreferredStock
  RetainedEarnings
  TreasuryStock
   
   
Income CostofGoodsSold
DiscountsRefundsGiven CostOfLaborCos
NonProfitIncome EquipmentRentalCos
OtherPrimaryIncome OtherCostsOfServiceCos
SalesOfProductIncome ShippingFreightDeliveryCos
ServiceFeeIncome SuppliesMaterialsCogs
UnappliedCashPaymentIncome  
   
   
Expense OtherIncome
AdvertisingPromotional DividendIncome
Auto InterestEarned
BadDebts OtherInvestmentIncome
BankCharges OtherMiscellaneousIncome
CharitableContributions TaxExemptInterest
CostOfLabor  
DuesSubscriptions  
Entertainment  
EntertainmentMeals  
EquipmentRental  
FinanceCosts  
GlobalTaxExpense  
Insurance  
InterestPaid  
LegalProfessionalFees  
OfficeGeneralAdministrativeExpenses  
OtherMiscellaneousServiceCost  
PayrollExpenses  
PromotionalMeals  
RentOrLeaseOfBuildings  
RepairMaintenance  
ShippingFreightDelivery  
SuppliesMaterials  
TaxesPaid  
Travel  
TravelMeals  
UnappliedCashBillPaymentExpense  
Utilities  
   
   
OtherExpense  
Amortization  
Depreciation  
ExchangeGainOrLoss  
OtherMiscellaneousExpense  
PenaltiesSettlements  
   

 

 

 

 

 

 

 

Feedback
11 out of 16 found this helpful

Attachments

QBO_Valid_Account_and_Sub-Account_Types.xlsx
scroll to top icon