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.
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 |
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.
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 Report1/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 |