Budgeting & Planning

 

 

Fiscal Year 2023 RESOURCE PAGE

Welcome to the Budget & Planning ALA Fiscal Year 2023 resource and instruction page


 

Below you will find links to the most widely used resource documents that will help you develop your FY23 budgets within Prophix.

Please call with questions,

Brad Geene, Director, Budgeting & Planning


New (August 2022)! Library of Prophix Training Videos and Slides can be viewed at any time on the ALA Share drive at:

S:\Management\UnitManagers\Prophix Budget and Performance Report Training

I. Prophix Basics

II. Managers' Monthly Performance Reports

III. Budgeting Non-salary lines

IV. Budgeting Salary Expense


 

 

 

Below you will find links related to:

>  FY23 Budget Process, Instructions, Timeline & Assumptions (word document)

> Endowment LTI 20 Qtr Rolling Average and up to 5.0% Payout for FY23

> Capital Request Form FY23 (with Depreciation math example)

> FY23 Divisional Overhead Rates by Revenue Account (26.5% full, 13.25% half)

> Chart of Accounts

 

Personnel Expense Budgeting at ALA

Instructions for budgeting your Unit's staff within the Prophix budgeting system.

FY23 Budget Instructions for Unit Managers

Contains FY23 Assumptions, Timelines and Overhead rates by Account as well as Annual Cycle overview.

FY23 Budget Process Timeline & Assumptions

Includes template lock\unlock dates, Prophix refresher training sessions, and Preliminary FY22 Budget presentation dates to BARC and F&A. Assumptions presented to BARC at Midwinter.

Endowment LTI 20 Qtr Rolling Average and up to 5.0% Payout FY23

Used to budget the allowable endowment spending\payout calculated based on 5.0% of the average of the last 20 quarters of performance.  Budget in Fund 12 or 13 in Account 5904 as a negative (e.g. expense reduction in Month = August 2020).  Payout is determined by the Endowment Trustees, revisited annually. For questions regarding your individual endowments please reach out to Keith Brown at x4255.

Capital Asset Request Form FY23

New! Includes mathematical example of how a capital purchase (which ALA will own for many years) is reflected as an operating expense in the budget. The operating portion is a fraction of the total cost of the asset.

Depreciation will be loaded into your FY23 Budget Template. (pending Unit data from Accounting)

FY23 Divisional Overhead Rates by Revenue Account

For FY23 the full rate is 26.5% and half-rate is 13.25% as applicable for type of revenue. See attached for line by line guidance.

 

Chart of Accounts

Fund - Unit - Account - Project definitions (e.g. 11-550-5110-0000)

PROPHIX FAQs

 

Why can't I enter data in the Budget Template and what does "Dimension spread has been disabled in the template" mean?

Click the drop-down menu to the correct Unit_Project combo.  Data can only sit at the 4-digit project level.  Your 3-digit Unit number is the sum of all projects.  This is very easy to forget and especially so for the managers with only one project number.  Just click the drop-down to your desired project (e.g. 0000) and begin to type, then save.

When I am entering data in the Prophix template, a pop-up asks how I want to spread the data.  What is the difference between spread-evenly and spread based on existing data for the current member combination?

Spread evenly will simply place 1/12th of your value in each of the 12 months of the fiscal year, September to August.  Whereas, spread based on existing data for the current member combination will calculate how a previously entered amount is prorated across the months and apply those exact same monthly prorations to the value you are now entering.  This choice is not applicable and will deliver an error message if this is the first time you are entering a value.

Why do I at times have 2 Prophix icons on my desktop - one with a "z" and one with a short-cut arrow?

Use the icon with the "z".  Prophix works best with the Internet Explorer (IE) web browser.  However, not every user has IE as their default browser of choice.  The icon with the "z" is an ITTS Novell network setting that pushes the software to use IE.  The other shortcut is generated by Prophix onto your desktop.