Atrieve Finance

Budget Planning System Database Setup

Update current year in Budget Planning System Master Profile to new (future) year

Setup Databases

Specifications

  • The specifications database is for the creation, change, deletion and reporting of the budget specification records. Specifications leverage a calculation number defined in the parameters database. 

Parameters

  • The parameters database is for the creation, change, deletion, inquiry, and reporting or equations using a two character calculation code. This calculation code identifies an arithmetic equation of up to 10 steps. Each step is performed in the order it appears on the record and the calculations are cumulative. 

Budget ID

  • The budget ID database is for the creation, changes, and deletion of information related to budget ID. The budget ID indicates to the system whether or not budget transactions have been generated from budgeted position information and/or benefit costs and interfaced to budget GL accounts. The definition of multiple budget ID's allows the creation of separate instances of budgeting process, either by position and/or budget GL account. This will allow for manipulation and reporting of different budget scenarios at any time.

  • Every year must have at least one budget ID (0) set up.

  • If using the Budget Planning System for budget building, have 'budget generated' set to Y.

  • If using the Budget Planning System for forecasting only, have  'budget generated' to N.

Budget Phase ID

  • The budget phase ID database is for the creation, changes, and deletion of information related to the budget phase ID. The definition of Budget Phases allows the separation of various windows of time when updating positions (FTE's) and budget GL accounts (dollars) and then reporting by these defined phases.

  • One budget phase ID (0) must be defined.  Budget phase ID's  can include extra salary items to positions when creating positions data. 

.Associated Costs

  • This database is for the benefit costing for salary from positions. 

  • To make modifications to the associated costs, use associated cost additions.  The system will take into account what the previous benefit cost was (if any) and recalculate the difference in benefit costs when creating the adjusting entry. 

  • The program will warn that the associated costs already exists and ask to add an adjustment .  Enter Y to adjust the current percentage.

  • Processing the Budget Planning System program Create Transactions From Positions will utilize this database. 

Benefit Payroll / Budget Object Match

  • The benefit payroll/budget object match database is for the creation, change,deletion, inquiry, and reporting of benefit payroll/budget object match records. 

Realloc. Contra Account Replacement

  • The reallocation contra account replacement database is for the creation, change, deletion, inquiry, and reporting of reallocation contra account replacement records.