Menu Close

Checkbook Categories and Sub-Categories (Samples)

Please find below, three different tables of sample checkbook categories and sub-categories that you might use for your bank transaction categorizations. The first list is already provided in the Excel Checkbook for Home (2025 version). If you’d prefer Quicken’s list of categories, see the 3rd table below which you can copy/paste into the categories table in the Excel checkbook.

Sub_CategoryCategoryType
AlcoholFood/drinkExpense
Auto GasTransportationExpense
Auto RepairTransportationExpense
Cable/SatelliteUtilitiesExpense
Car LoanTransportationExpense
Cell PhoneLiving ExpensesExpense
ClothesDiscretionaryExpense
CoffeeFood/drinkExpense
Credit Card InterestLiving ExpensesExpense
Credit Card PaymentLiving ExpensesExpense
DentistHealthExpense
Dining OutFood/drinkExpense
Disability InsuranceHealthExpense
DoctorHealthExpense
DonationCharityExpense
Electric BillUtilitiesExpense
EntertainmentDiscretionaryExpense
Expense ReimbursementReimbursementIncome
FurnishingsDiscretionaryExpense
Gas/Propane CompanyUtilitiesExpense
GiftsCharityExpense
GroceriesFood/drinkExpense
GymDiscretionaryExpense
Gym / Health ClubHealthExpense
Health/Medical InsuranceHealthExpense
Home ImprovementsLiving ExpensesExpense
Home/Rental InsuranceLiving ExpensesExpense
Household ItemsLiving ExpensesExpense
Income-OtherIncome-OtherIncome
Insurance, VehicleTransportationExpense
Interest/DividendsBenefitsIncome
Internet ServiceUtilitiesExpense
Life InsuranceHealthExpense
Magazines/NewspaperDiscretionaryExpense
Maintenance/SuppliesLiving ExpensesExpense
Medical (misc)HealthExpense
MiscLiving ExpensesExpense
MortgageLiving ExpensesExpense
Pet CareLiving ExpensesExpense
Pet FoodFood/drinkExpense
Phone (Landline)UtilitiesExpense
Prescriptions (Rx)HealthExpense
RentLiving ExpensesExpense
SalarySalary/WagesIncome
Side-IncomeSide-IncomeIncome
Social SecurityBenefitsIncome
TaxesTaxesExpense
Taxi/UberTransportationExpense
TipsSalary/WagesIncome
TithesCharityExpense
Transfer fundsTransferTransfer
UnemploymentSalary/WagesIncome
VacationDiscretionaryExpense
Wages & TipsSalary/WagesIncome
Water / Sewer / TrashUtilitiesExpense

This second list contains common categories used by Quicken with the first column as “Category”. See the third list below for pasting into the 2025 Home Version of the Excel Checkbook.

CategorySub_CategoryType
IncomeInterest IncIncome
IncomeIRA ContributionIncome
IncomeNet SalaryIncome
IncomeNet Salary SpouseIncome
IncomeSide-gigIncome
IncomeOther IncIncome
InvestmentsDiv IncomeIncome
Auto & TransportAuto InsuranceExpense
Auto & TransportAuto PaymentExpense
Auto & TransportCar WashExpense
Auto & TransportGas & FuelExpense
Auto & TransportMotorcycleExpense
Auto & TransportParkingExpense
Auto & TransportPublic TransportationExpense
Auto & TransportRegistrationExpense
Auto & TransportService & PartsExpense
Auto & TransportTollsExpense
Bills & UtilitiesHome PhoneExpense
Bills & UtilitiesInternetExpense
Bills & UtilitiesMobile PhoneExpense
Bills & UtilitiesTelevisionExpense
Bills & UtilitiesUtilitiesExpense
Cash & ATMCash & ATMExpense
EducationBooks & SuppliesExpense
EducationStudent LoanExpense
EducationTuitionExpense
EntertainmentAmusementExpense
EntertainmentArtsExpense
EntertainmentMovies & DVDsExpense
EntertainmentMusicExpense
EntertainmentNewspaper & MagazinesExpense
EntertainmentStreaming ServiceExpense
Fees & ChargesATM FeeExpense
Fees & ChargesBank FeeExpense
Fees & ChargesLate FeeExpense
Fees & ChargesService FeeExpense
Fees & ChargesTrade CommissionsExpense
FinancialFinancial AdvisorExpense
FinancialLife InsuranceExpense
FinancialAlimonyExpense
Food & DiningAlcohol & BarsExpense
Food & DiningCoffee ShopsExpense
Food & DiningFast FoodExpense
Food & DiningGroceriesExpense
Food & DiningRestaurantsExpense
Gifts & DonationsCharityExpense
Gifts & DonationsGiftExpense
Health & FitnessDentistExpense
Health & FitnessDoctorExpense
Health & FitnessEyecareExpense
Health & FitnessGymExpense
Health & FitnessHealth InsuranceExpense
Health & FitnessPharmacyExpense
Health & FitnessSportsExpense
HomeFurnishingsExpense
HomeHOA DuesExpense
HomeHome ImprovementExpense
HomeHome InsuranceExpense
HomeHome ServicesExpense
HomeHome SuppliesExpense
HomeLawn & GardenExpense
HomeMortgageExpense
HomeRentExpense
Interest ExpInterest ExpExpense
KidsAllowanceExpense
KidsBaby SuppliesExpense
KidsBabysitter & DaycareExpense
KidsChild SupportExpense
KidsKids ActivitiesExpense
KidsToysExpense
Misc.Misc.Expense
Not SureNot SureExpense
Personal CareHairExpense
Personal CareLaundryExpense
Personal CareSpa & MassageExpense
PetsPet Food & SuppliesExpense
PetsPet GroomingExpense
PetsVetExpense
ShoppingBooks & SuppliesExpense
ShoppingClothingExpense
ShoppingElectronics & SoftwareExpense
ShoppingHobbiesExpense
ShoppingSporting GoodsExpense
TaxesFedExpense
TaxesFICA, Medicare, UIExpense
TaxesProperty TaxExpense
TaxesStateExpense
TravelAir TravelExpense
TravelHotelExpense
TravelRental Car & TaxiExpense
TravelVacationExpense
Deposit to SavingsDeposit to Savings
Business ExpenseOffice expenseExpense

This third list contains common categories used by Quicken with the first column as “Sub_Category”. This list is ideal for pasting into the Excel Checkbook table (see the worksheet entitled Settings).

Sub_CategoryCategoryType
Interest IncIncomeIncome
IRA ContributionIncomeIncome
Net SalaryIncomeIncome
Net Salary SpouseIncomeIncome
Side-gigIncomeIncome
Other IncIncomeIncome
Div IncomeInvestmentsIncome
Auto InsuranceAuto & TransportExpense
Auto PaymentAuto & TransportExpense
Car WashAuto & TransportExpense
Gas & FuelAuto & TransportExpense
MotorcycleAuto & TransportExpense
ParkingAuto & TransportExpense
Public TransportationAuto & TransportExpense
RegistrationAuto & TransportExpense
Service & PartsAuto & TransportExpense
TollsAuto & TransportExpense
Home PhoneBills & UtilitiesExpense
InternetBills & UtilitiesExpense
Mobile PhoneBills & UtilitiesExpense
TelevisionBills & UtilitiesExpense
UtilitiesBills & UtilitiesExpense
Cash & ATMCash & ATMExpense
Books & SuppliesEducationExpense
Student LoanEducationExpense
TuitionEducationExpense
AmusementEntertainmentExpense
ArtsEntertainmentExpense
Movies & DVDsEntertainmentExpense
MusicEntertainmentExpense
Newspaper & MagazinesEntertainmentExpense
Streaming ServiceEntertainmentExpense
ATM FeeFees & ChargesExpense
Bank FeeFees & ChargesExpense
Late FeeFees & ChargesExpense
Service FeeFees & ChargesExpense
Trade CommissionsFees & ChargesExpense
Financial AdvisorFinancialExpense
Life InsuranceFinancialExpense
AlimonyFinancialExpense
Alcohol & BarsFood & DiningExpense
Coffee ShopsFood & DiningExpense
Fast FoodFood & DiningExpense
GroceriesFood & DiningExpense
RestaurantsFood & DiningExpense
CharityGifts & DonationsExpense
GiftGifts & DonationsExpense
DentistHealth & FitnessExpense
DoctorHealth & FitnessExpense
EyecareHealth & FitnessExpense
GymHealth & FitnessExpense
Health InsuranceHealth & FitnessExpense
PharmacyHealth & FitnessExpense
SportsHealth & FitnessExpense
FurnishingsHomeExpense
HOA DuesHomeExpense
Home ImprovementHomeExpense
Home InsuranceHomeExpense
Home ServicesHomeExpense
Home SuppliesHomeExpense
Lawn & GardenHomeExpense
MortgageHomeExpense
RentHomeExpense
Interest ExpInterest ExpExpense
AllowanceKidsExpense
Baby SuppliesKidsExpense
Babysitter & DaycareKidsExpense
Child SupportKidsExpense
Kids ActivitiesKidsExpense
ToysKidsExpense
Misc.Misc.Expense
Not SureNot SureExpense
HairPersonal CareExpense
LaundryPersonal CareExpense
Spa & MassagePersonal CareExpense
Pet Food & SuppliesPetsExpense
Pet GroomingPetsExpense
VetPetsExpense
Books & SuppliesShoppingExpense
ClothingShoppingExpense
Electronics & SoftwareShoppingExpense
HobbiesShoppingExpense
Sporting GoodsShoppingExpense
FedTaxesExpense
FICA, Medicare, UITaxesExpense
Property TaxTaxesExpense
StateTaxesExpense
Air TravelTravelExpense
HotelTravelExpense
Rental Car & TaxiTravelExpense
VacationTravelExpense
Deposit to SavingsDeposit to Savings
Office expenseBusiness ExpenseExpense

Discover more from Excel Checkbook

Subscribe to get the latest posts sent to your email.

Leave a Reply

Your email address will not be published. Required fields are marked *