Preparing an Annual Budget
Tip
Using CDBWin to Set Up, Display and Print Budget
Information
CDBWin makes it easy to generate a budget, with a number of features that
allow you to customize it to your specifications. The budget may be typed
manually, or generated automatically based on the previous calendar or fiscal year's data.
- On the Reports menu, click Daily Book > Department > Budget.
The Annual Budget window appears:
- The above illustration provides a typical view of a budget. The departments
in the left-hand column are those
resident in CDBWin. Setting up your budget can be done one of two ways:
- By clicking Edit and typing it in manually.
- By clicking Generate and letting CDBWin fill the cells with information based
on last year's activity. Once you generate a budget
automatically, you can then edit figures as needed.
- There are three ways you can view budget figures, by Sales, Cost of Goods Sold and Expenses.
Select the view of choice by clicking an option button as shown in the above
illustration.
Typing in a Budget Manually
To set up your budget figures manually:
- With the Annual Budget window displayed, click Edit. The Edit Budget window appears:
-
Use the Edit Budget window as follows:
- (1) Select the option button of the figures you wish to edit.
- (2) Editing is accomplished on a department by department basis. Using the combo boxes, select the department whose figures you wish to edit.
- (3) The money figures for the department budget appear in the main part of the window.
The top text box is the money figure for the month (if one currently exists); directly below it is
a text box with percentage of the annual budget represented by that figure.
You can edit the budget using either of these methods (see next bullet).
- (4) Select the option button in the Modify By group box that corresponds to how you want to edit the budget. When you choose Amount,
the percent boxes are grayed out and you simply type the dollar figure. The Percent figure beneath adjusts to reflect the new amount. When you choose Percent,
the money figure becomes grayed out and you can type into the percent boxes
in xx.xx format. The money figure directly above adjusts accordingly.
- (5) The Auto Adjust Amounts check box becomes enabled when you select the Percent option button. When this check box is selected and you enter a percentage change to a month, the Annual total will not change. Instead, the other months figures will be uniformly adjusted upward or downward to retain the total. When this check box is cleared, the Annual total will reflect the percentage change entered in an individual month (although the change does not take effect until you click OK).
- Click OK when finished.
Generating a Budget Automatically
If you have recorded sales, cost of goods sold (COGS), and expenses in the
previous year (calendar or fiscal), then you can use CDBWin's automatic budget creation feature to provide a start to your current year's projections.
To do this:
- With the Annual Budget window displayed, click Generate. The Budget
Generator window appears:
- Work through the window as follows:
- Base year Select whether you want to generate the budget based on the sales, COGS and expenses for the Previous x months or the Previous Fiscal Year. In the case of Previous x months, fewer months will display if there is not enough CDBWin history to fill up a year. In the case of Previous Fiscal Year, this feature may be disabled if there is not enough history.
- Uplift Defines a predicted change in sales/costs/expenses and adjusts the generated figures accordingly. For example, typing 10% results in a generated budget at 110% of the base value (5000 would become 5500).
- Rounding
Round to 5s Rounds the last digit in each budget cell to the nearest 5 or 0.
Round to 0s Eliminates the 5s.
Do not round Creates a budget to the nearest dollar.
- Click OK when finished.
Printing Budgets
A printed budget includes figures for all views, Sales, COGS and Expenses.
With the Annual Budget window displayed, click Print or View. You
can also use the Comparative report type of the Income and Expense
Statement to compare the current period to your budget for the corresponding
time period.
|
