Budget Spread Codes
Budget Spread Code Maintenance
From the menu select General Ledger > Maintenance Functions > Budget Spread Code Maintenance
These codes allow you to establish a pre-defined percentage break down of an annual budget amount across a number of accounting periods. In the normal budget entry process, you can:
- Distribute the budget across a number of accounting periods for a given fiscal year.
- Allow the system to equally spread the budget across all accounting periods, or
- Enter a "budget spread" key, forcing the budget distribution to be according to the percentages given within the spread record.
Spread codes are attached to G/L accounts through chart of accounts maintenance.
For example, suppose the annual budget for your Telephone Expense account is $12,000.00. However, you incur extremely heavy usage during November and July because of sales campaigns in those months. You can set up a Budget Spread code that accounts for the fluctuation in expenses.
Using this table, the system would allocate $2,400.00 (12,000 X 20%) to July (period 7) and November (period 11) and $720.00 to the other ten months.
General Rules The total percentage allocation MUST equal 100% or you will not be allowed to save the code.
- Enter a Budget Spread ID or press F6 to list the file.
- The cursor will move to the right and allow you to enter a Description for this spread code.
- The Accounting Periods grid will display 12 or 13 accounting periods and default each period to 1/12 or 1/13 of 100%. The last period is used for rounding. For users with a calendar year General Ledger with monthly accounting periods, 1 corresponds to January and 12 to December.
- Click in the Percent column to change the allocation percentage for a particular period; enter zero (0) if no allocation is to take place. Percentages entered for each period must be in the range (.01 - 100.00).
- Click the Save button to save the code.