Example: Set Up Award Budget Checks for Total Grant
This example illustrates how to create a virtual parent-child plan structure on top of an existing award plan to implement budget check for the entire grant.
You're an award contract specialist for award AWD-129 at Alma Mater University (USA). The award already has a budget plan
AWD-129:STEM Infrastructure 07/01/2023 (version 0)
with plan lines that:
- Budget for spends in specific ledger accounts/summaries containing these worktags:
- Cost Center: 4280 Natural Sciences
- Fund: 02 Sponsored Program Fund
- Grant: 129 STEM Initiatives
- Program: 111 Science
- Total 1,430,500 USD for all 3 fiscal years.
You want the budget check to:
- Show a status ofWarn (No Budget)when a transaction amount causes the total spend to exceed the budgeted amount for the specific worktag set and budgetary period.
- Show a status ofFail (Insufficient Budget)when a transaction amount causes the total spend on the grant to exceed the total budgeted amount for the entire duration of the grant.
In a virtual parent-child plan structure for an award, the:
- Child plan structure is the plan structure of the plan on the award.
- Parent plan structure is a new plan structure that you create by copying from and linking to the child plan structure.
- Create and approve awardAWD-129: STEM Infrastructure 07/01/2023 (version 0).
- Add theCheck Budgetaction step to the business processes of transaction types that you want to budget check when charging to grants. Example: To budget check accounting journals charged to grants, add theCheck Budgetstep to theAccounting Journal Eventbusiness process.
- Security:Set Up: Budget Generaldomain in Budgets functional area.
- Access thePlantab of awardAWD-129: STEM Infrastructure 07/01/2023 (version 0). If budget check is not enabled, configure and enable it:
- ClickEdit Budget Check Optionsand select these values:Plan StructureAwardCompanyAlma Mater University (USA)Plan NameAWD-129: STEM Infrastructure 07/01/2023 (version 0)
- ClickOKand enter these values:Enable Budget CheckSelectBudget Check OptionWarn, so that budget check displays only a warning when the spend amount exceeds the plan line amount.Evaluation DateBudget DateCumulative Control PeriodsSelect this check box and select theControl by Award Entry Periodoption if you want the unused budget to be added to the current period.
- ClickOKandDone.
- ClickSubmit BudgetandOK.
- Create a parent plan structure by copying the child plan structure:
- On the awardPlantab, locate theAwardplan structure and access the related actions menu to select :Name:Award AWD-129 ParentOn theStructured Dimensionstab, remove the values in theAccount SetandAccount Typefield.In theStructure Dimensiongrid, remove all rows exceptGrantandCompany.
- ClickOK.
- From the related actions menu of theAward AWD-129 Parentplan structure, select .Virtual Child Plan Structure:Award
- ClickOK.
- Create a plan template for the parent plan structure:
- From the related actions menu of theAward AWD-129 Parentplan structure, select and select these values:FieldValuePlan StructureAward AWD-129 ParentCompanyAlma Mater University (USA)Plan NameAward AWD-129 Parent PlanStart Date07/01/2023End Date06/30/2026Linked PlanAWD-129: STEM Infrastructure 07/01/2023 (version 0)
- ClickOK.
- Enable budget check for the total grant on the parent plan structure:
- From the related actions menu of theAward AWD-129 Parentplan structure, select and enter these values:Plan StructureAward AWD-129 ParentPlan NameAward AWD-129 Parent Plan
- ClickOKand select these values:Enable Budget CheckSelectInclude Reserved Journal LinesSelectAllow Credit Transactions to PassSelectBudget Check OptionControl, so that budget check displays aFailstatus when the spend amount exceeds the total grant budget.Evaluation DateBudget DateCumulative Control PeriodsSelect this check box, and select theControl by Award Entry Periodoption.Ledger Types for Budget CheckSelectActuals,Encumbrance, andPre-Encumbrance.
- ClickOKandDone.
When you create a spend transaction that's subject to budget check (with worktags as specified on the plan lines, including Cost Center: 4280 Natural Sciences, Fund: 02 Sponsored Program Fund, Grant: 129 STEM Initiatives, Program: 111 Science), and the transaction amount causes the total spend amount to exceed:
- The plan line budget but not the total grant budget of 1,430,500 USD, theReview Budget Checktask displays a budget check status ofWarn (No Budget)with 1 row on thePlan With Exceptionsgrid for the child plan structure (Award).
- The plan line budget as well as the total grant budget of 1,430,500 USD, theReview Budget Checktask displays a budget check status ofFail (Insufficient Budget)with 2 rows on thePlan With Exceptionsgrid, 1 for the child plan structure (Award) and 1 for the parent plan structure (Award AWD-129 Parent).