Revised 5/22/2014

FM813: 3-Year Budget & Actuals for Budget Planning

(Note – a 4th & 5th year are now available from the Key Figures Filter)

Description

·  FM813 reports Budget & Actuals in the three fiscal years selected and is for Revenue, Expenses and Transfers In & Out. Data is available for funds normally included in the budget process (A-J funds). P6 (Renewal & Replacement Plant Funds) are also available in this report although they are normally not budgeted funds.

·  By selecting the Fiscal Year on the Variables Entry screen, you are selecting that fiscal year's data plus the previous two years' data.

·  Select the 4th or 5th year from the Navigation Block to add more historical figures to the report.

Default View of Report

Report Usage

FM813 is an excellent analytical tool to use during the budget preparation process.

Default Variables Entry Screen Exclusions

Grant Funds (Fund Types G1 to G9) are reportable but are initially excluded via the Variables Entry Screen.

Tips

·  To only concentrate on Actuals, adjust the Key Figures filter by checking only the actuals columns.

·  To concentrate on one or two particular years' data, adjust the Key Figures filter by checking only the desired fiscal years.

·  Within the Key Figures filter there are 5 columns available with General Funds Permanent Budget. By default, they are not in the initial report but any or all can be added. There is also a column divider available to add to the report if desired.

·  Within the Key Figure filter there is a 4th & 5th year of data available, even though the name of the report is 3-year.

Bookmarks

None

Go To Functions Available

·  Actuals Document Journal Detail (FM865): Use the "Go To" functionality to access BW Report FM865 for a list of the individual original documents that support the Actuals subtotals for the fiscal year.

·  Budget Document Detail (FM866): Use the "Go To" functionality to access BW Report FM866 for a list of the individual Budget entry documents that support the Budget subtotals for the fiscal year. Permanent Budget (Budget Version MY) and Current Budget (Budget Version 0) are both reportable.

FM813 Relationship to Other Reports

·  The budget and actuals amounts are the same data that is reported in the other BW budget to actuals reports for similar time frames.

·  FM813_V2 reports the same budget and actuals as FM813. But, the default view provides all 5 years of data and the column arrangement is different so all columns of data about each fiscal year are together. It also provides a Budget Variance column that FM813 does not provide.

FM813 Relationship to R/3

The prior fiscal years' budget and actuals will tie directly to the year-end amounts through period 16 in R/3. Since BW data is as of the previous day's business, the current year's budget and actuals will not include any activity that has posted today in R/3.