Ohio State University Extension Bulletin

Computerized Farm Record Keeping with Quicken® 2002

Bulletin 897-02


Categories & Classes

Using A Pre-Defined Set Of Categories And Classes

One of the advantages of Quicken is the ability to create your own categories and classes for your farm record system. However, some record keepers prefer to use a pre-defined set of categories and classes rather than creating their own. The following Category & Transfer Lists were created by OSU Farm Management Specialists. The first list, contained in the FARM&HOME.QIF file, is fairly detailed and contains farm, home and personal categories, classes and suggestions for accounts. The second Category & Transfer List is contained in the FARM.QIF file and contains the same farm categories and classes, but fewer family living and personal categories than FARM&HOME.QIF.

Both lists are available from the authors, your local OSU Extension office or can be downloaded from the OSU Extension website at [http://www.ag.ohio-state.edu/~agnatres/software]. These downloaded files are ZIP files and will need to be converted to QIF files using the WinZip program. If you do not have WinZip on your computer, it can be downloaded at [www.winzip.com].

FARM&HOME CATEGORY/TRANSFER LIST - the following categories are in the FARM&HOME.QIF file. Home/personal categories start with an "H", other categories are farm business categories.

CATEGORY TYPE TAX DESCRIPTION
CCC Loan Inc   IF NOT USING LIABILITY ACCOUNT
CCC Loan as Inc Inc Tax CCC Loan Inc or Redeemed
Custom Work Inc Tax  
Gas Tax Refunds Inc Tax  
Gifts Received Inc    
Govt Payments Inc Tax Government Payments
Grain Sold Inc Tax Crop Sales
HDiv&Int Inc Tax Nonfarm Interest & Dividends
HOtherInc Inc Tax
HWages Inc Tax Nonfarm Wage Income
Inc, Int Inc Tax Interest Income
Inc, Invest Inc Tax Investment Income
Inc, Rents Inc Tax  
Loans Receipts Inc   IF NOT USING LIABILITY ACCOUNT
LS Sold Inc Tax Livestock Sales
     PBreedLT Sub Tax Form 4797, Long Term Capital Gains
     PBreedST Sub Tax Form 4797, Short Term Capital Gains
     PFeeder Sub Tax Purchased Feeder Livestock Sold
     RBreedLT Sub Tax Form 4797, Long Term Capital Gains
     RBreedST Sub Tax Form 4797, Short Term Capital Gains
     RMarket Sub Tax Raised Market Livestock Sold
M&E&B Sold Inc Tax Mach & Equip & Other Cap Assets Sold
     LT Sub Tax Form 4797, Long Term Capital Gains
     ST Sub Tax Form 4797, Short Term Capital Gains
Milk Sold Inc Tax  
Other Farm Inc Inc Tax  
Patr Div-C Inc Tax Cash Portion Qualified Patronage Dividend
Patr Div-NC Inc Tax NonCash Portion Qualified Patronage Div
Poultry & Eggs Inc Tax  
Refund, Tax Inc Tax State & Local Tax Refunds
Wool & LS Prod Inc Tax Other Livestock Products
Auto & Truck Exp Tax  
Bank Charge Exp Tax Bank Charges for Farm Account
Capital Purch Exp   IF NOT USING ASSET ACCOUNT
CCCGrCost Exp Tax Expense of Grain with CCC Loan as Income
Chemicals Exp Tax Crop Herbicides, Insecticides, Supplies
Drying&Storage Exp Tax  
Dues Exp Tax  
Feed Purchased Exp Tax  
Feeder LS Exp Tax Feeder Livestock Purchased for Resale
     Cost Sub Tax Purchase Cost Deducted at Time of Sale
     Purch Sub   IF NOT USING ASSET ACCOUNT
Fees Exp Tax  
Fert & Lime Exp Tax Fertilizer & Lime
Fuel & Lube Exp Tax  
HAuto Exp   Personal Auto Expense
HCharity Exp Tax Charitable Contributions
HClothing Exp    
HFamily Draw Exp   IF NOT USING A CASH ACCOUNT
HFood Exp   Groceries & Restaurants
HGifts Exp    
HHouseImpr Exp   Furniture, Appliances, Repairs
HInsurance Exp   Auto, Life, Personal
HInterest Exp   Personal Interest
HIntMort Exp Tax Deductible Home Mortgage Interest
HMedical Exp Tax Health Insurance, Doctors, Prescription
HMisc Exp   Miscellaneous Home & Personal Expenses
Insurance Exp Tax Farm Insurance
Interest Exp Exp Tax Interest Expense
Interest, Mort Exp Tax Mortgage Interest Expense
Lease Exp Tax Lease Payments
Loan Principal Exp   IF NOT USING LIABILITY ACCOUNT
Mach Hire,Truck Exp Tax Machine Hire & Trucking
Marketing Exp Tax Marketing Charges
     Brdg&Cap Sub Tax For Breeding LS & Capital Asset Sales
     Crops Sub Tax For Crop Sales
     Mkt LS Sub Tax For Market Livestock Sales
     Other Sub Tax For Other Farm Related Sales
Misc Exp Tax Miscellaneous Farm Expense
Payroll Exp Tax Payroll Expenses
     Comp FICA Sub Tax Employer Paid FICA
     Comp MCARE Sub Tax Employer Paid Medicare
     Gross Sub Tax Gross Wages Paid
Pre-Tax Exp Tax Pre-tax Deductions
     Dent Ins Sub Tax Pre-tax Dental Insurance
     Life Ins Sub Tax Pre-tax Life Insurance
     Med Ins Sub Tax Pre-tax Medical Insurance
Pre-Tax, Spouse Exp Tax Pre-tax Deductions, Spouse
     Dent Ins Sub Tax Pre-tax Dental Insurance
     Life Ins Sub Tax Pre-tax Life Insurance
     Med Ins Sub Tax Pre-tax Medical Insurance
Prof Services Exp Tax Accounting, Legal, Consultants
Rent Exp Tax Cash Rent Paid
Repairs Exp Tax Repairs & Maintenance
     Building Sub Tax Building & Fence Repairs
     Mchy Sub Tax Machinery Repairs
Resale Items Exp Tax Other Items Purchased For Resale
     Cost Sub Tax Cost of Items Deducted At Time Of Sale
     Purch Sub   IF NOT USING ASSET ACCOUNT
Seeds & Plants Exp Tax Seeds & Plants Purchased
Subscriptions Exp Tax Farm Publications
Supplies Exp Tax General Farm Supplies
Supplies LS Exp Tax Livestock Supplies
Tax Exp Tax Taxes Paid
     Federal Sub    
     FICA Sub   Soc Sec Tax — Farm & Non-Farm Earnings
     Hprop Sub Tax Home Property Tax
     Other Sub Tax  
     Property Sub Tax Farm Property Tax
     State Sub Tax State Tax
Utilities Exp Tax  
     Electric Sub Tax Farm Share
     Heating Sub Tax Farm Share
     Hutilities Sub   Home & Personal Utilities
     Telephone Sub Tax Farm Share
Vet & Med Exp Tax  
Workers Comp Exp Tax Workers Compensation

Classes are another way of classifying (in addition to categories) farm record data by enterprise, landlord, farm, etc. The following classes would be possibilities for a crop/livestock farm and are included in the FARM&HOME.QIF file and the FARM.QIF file.

Beef
Corn
Dairy
Gen Farm
Hogs
Home
Soybeans
Wheat

The following accounts are types of suggested accounts to be set up and used in lieu of several of the categories identified in the above list. These are not part of the FARM&HOME.QIF file or the FARM.QIF file, but would need to be created by each record keeper. See the Accounts chapter for information on creating accounts.

[CASH] Cash Cash account for recording taxable & non-taxable cash transactions
[LOAN] Liability Liability account(s) for recording loan disbursements & loan principal payments
[RESALE INV] Asset Asset account(s) for recording feeder livestock purchased for resale
[CAP PURCH] Asset Asset account(s) for recording capital purchases

The FARM.QIF category & transfer list contains the same farm business categories, classes and accounts as listed above, but significantly fewer home/personal categories.


Back | Forward | Table of Contents