Looking Ahead: The Financial Edge Budget Forecast (and Copy) Tool

Published

Entering budgets for the new fiscal year can be a time consuming and time-sensitive process for an organization, but Budget Management in The Financial Edge can make that job easier by doing some of the work for you. As you have likely seen in our prior blog posts, Budget Management houses a variety of Budget Tools. By using our Copy/Forecast tool, we can reduce the time it takes to enter a budget, decrease the likelihood of any potential manual entry errors and prepare the budget in advance.

What is the Copy/Forecast tool?
By using the Copy/Forecast tool, you can copy an existing budget or copy actual amounts from one fiscal year to another. You may also copy current year actual figures and project actual figures for the remainder of the year which does not currently have activity. Follow the steps below to copy or forecast a budget:

1. In Records, click Budgets.
2. Select Budget, Budget Tools from the menu bar.
3. Select Copy/Forecast budget and click Next.
4. Select the appropriate filters and click Next.
5. In the Select a source scenario frame, select the budget scenario and fiscal year you want to copy. This will be the basis of the forecasted budget.
6. In the Select a destination scenario frame, select the budget scenario and fiscal year to which you want to copy the source budget. This is the budget you are forecasting. 
7. Select the periods you want to copy.
8. Select Budget, Actuals, or Actuals Encumbrance from the copy drop-down list.
9. Select either Amount or Percent to copy, click Next.
10. Verify the information is correct and click Copy/Forecast Now.
11. Click OK once completed.
 
Be sure to watch the brief video below to see the entire process of copying a budget:


Below is an in depth example of how the forecasting portion of the tool uses current actuals to project future budget amounts:


 


The system uses a formula based on current year actual data and its relationship to the current year budget to forecast the remaining periods of the year. Let’s say we have activity through period 9 of the fiscal year (we’ll use 2014 as an example), and we are forecasting for the 2015 budget.
Period 2014 Actual 2014 Budget 2014
Totals for 1-9 $96,300 $112,500
10 0 $10,000
11 0 $12,500
12 0 $15,000
 
 
We use the formula (Year-to-date Actual/Year-to-date Budget) * Period Budget = Period Forecast to calculate the remaining periods of the year.
 
In the above example, the ratio of Actual to Budget for periods 1-9 is $96,300/$112,500=0.856. The system multiplies this ratio by the 2014 budget amounts listed in the 2014 table above to get the 2015 budgeted amounts below:

 
Period 2015 Budget 2015
Copied from Actuals in 2014 periods 1-9 $96,300
10 $8,560
11 $10,700
12 $12,840
 
 
 
News ARCHIVED | Financial Edge® Tips and Tricks 06/19/2015 7:00am EDT

Leave a Comment

2 Comments
Glad it helps, Theresa! :)
This is so helpful! Thank you!

Share: