Ohio State University Extension Bulletin

Computerized Farm Record Keeping

Bulletin 890-01


Budgets


Using Quicken to keep your farm records makes record keeping easier. It also allows you to make more use of your record data than you might with a hand-kept set of records. Using the budgeting feature in Quicken to create and monitor projected income and expenses allows you to use your computer records for more than just tax purposes. By creating budget projections and examining projected versus actual income and expenses on a monthly or quarterly basis, you will know how your business is doing financially and can quickly take needed corrective action. It is too late to take action if you wait until the end of the year to find out that your farm business did not do as well financially as you had planned.

Budgets can be based on the previous year's income and expense records, but need to be adjusted for any changes in the operations and for price changes for products bought or sold.

Creating Budgets

To create a budget for ACTUAL expenditures Click Banking from the menu bar (Click Planning if you are using Quicken 2001 Home & Business), Click Budgeting to open the BUDGET window.

**Note** The first time you enter the BUDGET window the FIRST TIME IN BUDGETS window appears, when this happens Click OK.

At the top of the BUDGET window, the buttons on the toolbar are:

Categories - select categories to include/exclude in your budget

Edit - edit the current budget

Alerts - set up alerts for monthly expenses

Report - create a budget report or graph

Options - change settings for this window

How Do I - help on tasks

X - close the budget window.

Click the Options button on the toolbar, Click Show Category Groups to remove the checkmark, (skip this step if the checkmark is not present), Click the Options button, Click Other Budgets, Click Create, Type name of budget (i.e., 20XX Actual Farm Budget), Type description (i.e. Year 20XX), Click Autocreate Budget, Click OK, set date range, Click Use Monthly Detail, Click Categories, Click Mark All, Click OK, Click OK.

**Note** This budget has been created using data you have previously entered.

To create a PROJECTED budget Click Banking from the menu bar (Click Planning if you are using Quicken 2001 Home & Business), Click Budgeting to open the BUDGET window. Click the Options button on the toolbar, Click Show Category Groups to remove checkmark, (skip this step if the checkmark is not present), Click the Options button, Click Other Budgets, Click Create, Type name of budget (i.e. 20XX Projected Farm Budget), Type description (i.e. Year 20XX), Click Autocreate Budget, Click OK, set date range, Click Use Monthly Detail, Click Categories, Click Mark All, Click OK, Click OK.

**Note** You may now begin entering your projected budget information. Click Edit and use the fill commands to quickly enter data. Once your projected budget is finished, Click the Categories button on the toolbar, Click Clear 0 Amounts. This will remove all categories with a $0.00 projected amount.

Examples of an Actual budget and a Projected budget created using the directions outlined above are on the following pages.

Budget Names: 20XX Actual Budget

Category Name Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals
INCOME
Grain Sold 3,500 0 0 0 0 0 9,700 0 0 0 0 0 13,200
Milk Sold 0 0 0 0 0 0 0 0 0 2,650 2,650 2,650 7,950
Total Income 3,500 0 0 0 0 0 9,700 0 0 2,650 2,650 2,650 21,150
EXPENSES
Chemicals 0 0 0 -900 0 0 0 0 0 0 0 0 -900
Dues 0 0 0 0 0 0 0 0 0 -24 -24 -24 -72
Fertilizers -4,590 0 0 0 0 0 0 0 0 0 -2,400 0 -6,990
Fuel & Lube -1,357 0 0 0 0 0 0 0 0 0 0 -1,357
Mach Hire, Truck 0 0 0 0 0 -640 0 0 -69 -69 -69 -847
Repairs
Mchy 0 0 0 -450 0 0 0 0 0 -28 0 0 -478
Repairs - Other 0 0 0 0 0 0 0 0 0 0 0 0 0
Seed & Plants 0 0 0 1,200 0 0 0 0 0 0 0 0 -1,200
Total Expenses -5,947 0 0 -2,550 0 0 -640 0 0 -121 -2,493 -93 -11,844
Total Income 3,500 0 0 0 0 0 0 9,700 0 2,650 2,650 2,650 21,150
Total Expenses -5,947 0 0 -2,550 0 0 -640 0 0 -121 -2,493 -93 -11,844
Difference -2,447 0 0 -2,550 0 0 9,060 0 0 2,529 157 2,557 9,306

Budget Names: 20XX Actual Budget

Category Name Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Totals
INCOME
Grain Sold 5,000 0 5,000 0 0 0 0 0 0 0 2,500 5,000 17,500
Milk Sold 0 0 0 0 0 0 0 0 0 2,500 2,500 2,500 7,500
Total Income 5,000 0 5,000 0 0 0 0 0 0 2,500 5,000 7,500 25,000
EXPENSES
Chemicals 0 0 0 0 -1,000 0 0 0 0 0 0 -2,000 -3,000
Dues 0 0 0 0 0 0 0 0 0 -25 -25 -25 -75
Fertilizers 0 0 0 -5,000 0 0 0 0 0 0 -2,500 0 -7,500
Fuel & Lube -1,357 0 -1,200 0 0 0 0 0 0 0 0 0 -2,557
Mach Hire, Truck -250 0 -250 0 0 0 -640 0 0 -100 -225 -350 -1,815
Repairs
Mchy -250 0 0 -450 -250 0 0 0 0 -50 0 0 -1,000
Repairs - Other 0 0 0 0 0 0 0 0 0 0 0 0 0
Seed & Plants 0 0 0 0 0 0 0 0 0 0 0 -1,500 -1,500
Total Expenses -1,857 0 -1,450 -5,450 -1,250 0 -640 0 0 -175 -2,750 -3,875 -17,447
Total Income 5,000 0 5,000 0 0 0 0 0 0 2,500 5,000 7,500 25,000
Total Expenses -1,857 0 -1,450 -5,450 -1,250 0 -640 0 0 -175 -2,7750 -3,875 -17,447
Difference 3,143 0 3,550 -5,450 -1,250 0 -640 0 0 2,325 2,250 2,557 7,553

Budget Report

This report compares actual to budgeted income and expenses by category. You need to establish a budget before you can use this report. The budget report prorates amounts in the Budget column according to the report period. To compare actual spending with what you have budgeted for the entire month, make sure to specify whole month report periods in the CREATE REPORT window.

Creating a Budget Report

From the menu bar, Click Reports, Click Reports and Graphs Center, Click How am I spending my money, Click Budget Report, set report date, Click Create Now.

**Note** This report can be customized to display budget comparison by the Month, Quarter, etc.

Budget Report

1/1/XX Through 12/31/XX

Category Description 1/1/XX Actual Budget 12//31/XX Difference
INCOME
Grain Sold 13,200.00 17,500.00 -4,300.00
Milk Sold 7,950.00 7,500.00 450.00
Total Income 21,150.00 25,000.00 -3,850.00
EXPENSES
Chemicals 900.00 3,000.00 2,100.00
Dues 70.50 75.00 4.50
Fertilizers 6,990.00 7,500.00 510.00
Fuel & Lube 1,357.00 2,557.00 1,200.00
Mach Hire, Truck 847.00 1,815.00 968.00
Repairs
Mchy 478.43 1,000.00 521.57
Total Repairs 478.43 1,000.00 521.57
Seed and Plants 1,200.00

1,500.00

300.00
Total Expense 11,842.93 17,447.00 5,604.07
Total Income-Expenses 9,307.07 7,553.00 1,754.07

Back | Forward | Table of Contents