Allocations Julie Thompson ITS What are Allocations Allocations are used to distribute monetary or statistical amounts across funds departments products or any other ChartField defined in PeopleSoft General Ledger ID: 731589
Download Presentation The PPT/PDF document "Georgia FIRST Financials" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Georgia
FIRST Financials- Allocations
Julie Thompson, ITSSlide2
What are Allocations?
Allocations are used to distribute monetary or statistical amounts across funds, departments, products, or any other ChartField defined in PeopleSoft General LedgerSlide3
Parts of the allocation process
Allocation Type - This is the calculation method for the pool and basis and describes how the basis is used to distribute the pool amounts to the target.Pool - The amount or amounts to be allocated.Basis
– Determines how and in what proportion the pool amounts are distributed to the various targets
.
Target
– This is the destination where the amounts are allocated.
Offset
– Entries that clear or offset the pool amounts as they are transferred to the target.Slide4
Allocation Types
Copy: Copies pool amounts to the target or offset with possible percentage changes. Spread Evenly:
Divides pool amounts equally by the specified basis fields
to derive
the target amounts. For example, this type can be used to divide the
pool
equally in thirds among department IDs 0100, 0200, and 0300.
Allocate on Fixed Basis:
Allocates on a fixed basis and percentage of
pro rata
allocation. It is based on the fixed allocation percentage that you
specify in
the % field in the Value/Node scroll area on the Basis page.
Prorata
with Record Basis:
Divides the pool amount among the
targets based
on amounts that are stored in the basis record.
Arithmetic Operation:
Defines the allocation calculation as a
mathematical operation
between the pool and basis. Slide5
Allocation Types used in model
Copy: Copies pool amounts to the target or offset with possible percentage changes. Grant Allocations – Direct Revenue
Prorata
with Record Basis:
Divides the pool amount among the
targets based
on amounts that are stored in the basis record
.
Plant Allocations
Arithmetic
Operation:
Defines the allocation calculation as a
mathematical operation
between the pool and basis.
Grant Allocations – Indirect RevenueSlide6
What bases do we use?
Grant Allocations – Direct RevenueDirect copy of expenses, so no basis usedGrant Allocations – Indirect RevenueINDIRECT_COST_RT field on Define Values > Project setup Plant Allocations
Records in PS_LEDGER where ledger = PLANT
BOR_GL_PLANT_ALLOC_BASISSlide7
How do you make Allocations work better for you?
StreamlineRemove unnecessary steps from your GroupsKeep your GRANT_ALLOC_TREE cleaned up and updatedSlide8
How do you make Allocations work better for you?
CustomizeAdd custom groupsAdd nodes on existing GRANT_ALLOC_TREE or create a new treeAdd additional criteria to your pool selection to make steps more granularSlide9
How do you make Allocations work better for you?
CustomizeReview Calculation LogsWhen running Allocations, choose Then run report under Allocations > Reports > Allocation Calculation LogsSlide10
Calculation Log ExampleSlide11
Examples
Kennesaw State University University of North GeorgiaN PLANTS PLANTDifferent pool factors, pool, basis, and targetsSlide12
Questions?