29K - views

Georgia

FIRST. Financials. - Allocations. Julie Thompson, ITS. What are Allocations?. Allocations are used to distribute monetary or statistical amounts across funds, departments, products, or any other . ChartField.

Georgia

Download Presentation - The PPT/PDF document "Georgia" 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.

Presentation on theme: "Georgia"— Presentation transcript:

Slide1

Georgia

FIRST Financials- Allocations

Julie Thompson, ITS

Slide2

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

Slide3

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

.

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 Revenue

Slide6

What bases do we use?

Grant Allocations – Direct Revenue

Direct copy of expenses, so no basis used

Grant Allocations – Indirect

Revenue

INDIRECT_COST_RT field on Define Values > Project setup

Plant Allocations

Records in PS_LEDGER where ledger = PLANT

BOR_GL_PLANT_ALLOC_BASIS

Slide7

How do you make Allocations work better for you?

Streamline

Remove unnecessary steps from your Groups

Keep your GRANT_ALLOC_TREE cleaned up and updated

Slide8

How do you make Allocations work better for you?

Customize

Add nodes on existing GRANT_ALLOC_TREE or create a new tree

Slide9

How do you make Allocations work better for you?

CustomizeReview Calculation LogsWhen running Allocations, choose Then run report under Allocations > Reports > Allocation Calculation Logs

Slide10

Calculation Log Example

Slide11

Examples

Kennesaw State University

University of North Georgia

N PLANT

S PLANT

Different pool factors, pool, basis, and targets

Slide12

Questions?