CP-43: Back to Basics with Revenue: Revenue Recognition in ...

[Pages:38]CP-43: Back to Basics with Revenue: Revenue Recognition in Costpoint

Andy Unwin, Deltek

Course Description

Description: If you're new to revenue setup or looking for a refresher, this session is for you. We'll review Orgs, Ceilings, Rates Schedules, Rates and more. At the end of this session you'll: Have a better understanding of what makes up the revenue calculation. Know how to troubleshoot revenue issues

CONFIDENTIAL ? Deltek, Inc. All Rights Reserved.

2

Objectives

By the conclusion of this session, you will be able to :

? Name the key tables used in Revenue Calculations.

? Identify the steps to clean the Project Ledger of erroneous revenue.

? Describe the protocol for properly recalculating revenue.

? Document the "before" and "after" views of the Project Ledger.

CONFIDENTIAL ? Deltek, Inc. All Rights Reserved.

3

Agenda

? Introduction. ? Part 1: Where Do I Begin? ? Part 2: Revenue Roadmap. ? Part 3: The Process.

CONFIDENTIAL ? Deltek, Inc. All Rights Reserved.

4

Part 1

? Introduction

CONFIDENTIAL ? Deltek, Inc. All Rights Reserved.

5

What is "PROJ_SUM"...

PROJ_SUM

? PROJ_SUM: the key table underlying the Project Ledger.

? It stores data by Project, Account, and Organization for Fiscal Year, Period, and Sub-Period.

? It is a compressed view of transaction data from the General Ledger.

? Burden is stored at "Actual" and "Target" by Pool in the companion table known as PROJ_BURD_SUM.

? PROJ_SUM is the basis for the computation of revenue.

? The Project Ledger is always reconciled back to the General Ledger.

CONFIDENTIAL ? Deltek, Inc. All Rights Reserved.

6

What is "LAB_HS"...

LAB_HS

? LAB_HS: the key "hours-based" table underlying the Project Ledger.

? It stores Hours and Cost data by Labor Category [GLC, PLC], Employee/Vendor, Project, Account, and Organization for Fiscal Year, Period, and Sub-Period.

? It is the repository of all Hours based information regardless of the Journal Type. [AJE, LD, APV]

? It is the basis for "Loaded Labor" [T&M] revenue computations.

? It ties back to the detailed transactions in the General Ledger.

CONFIDENTIAL ? Deltek, Inc. All Rights Reserved.

7

Revenue Computations

PROJ_SUM

? For most Revenue Formulas, the calculation originates in PROJ_SUM.

? Revenue can be reviewed on the PSR and Revenue Summary prior to posting.

? Revenue should only be posted to

Post

GL_POST_

the General Ledger when its

SUM

accuracy has been validated.

CONFIDENTIAL ? Deltek, Inc. All Rights Reserved.

8

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download