city and county of san francisco - office of the controller · 2020-01-03 · presentation title...

City and County of San FranciscoOracle PeopleSoft & Accounting Concepts – Lesson 1June 10th, 2019

Copyright © 2019 Deloitte Development LLC. All rights reserved.

2

Oracle | E-Business Suite Training

https://www.liveslides.com/download

https://www.polleverywhere.com/multiple_choice_polls/wEK7UzkUckn5BnfJ6racY


3

Oracle | E-Business Suite Training Oracle | PeopleSoft Training Executive Summary

Training Objectives

Articulate the general accounting concepts and terms applicable to governmental accounting

Define commonly used terms and processes in PeopleSoft

Describe the general concepts, PeopleSoft application, andapplication of modules for the following processes in scope:

• Procure to Pay• Bills to Receive• Acquire to Retire• Record to Report• Grants Management• Reporting


4

Oracle | E-Business Suite Training Oracle | PeopleSoft Training Oracle PeopleSoft AOSD Training Lesson 1 - Training Agenda

# Topics Component Duration 1 General Accounting Concepts • Basics of Governmental Accounting

• Governmental Accounting Basis• Financial Statements• CCSF Ledgers

45 Mins

2 PeopleSoft Basics • Introduction• Key Terms and Modules• Application of Modules to Business Processes

45 Mins

3 Process Overview: Procure to Pay • General Concepts and Application• Application of Modules to Business Processes

15 Mins

4 Process Overview: Bill to Receive • General Concepts and Application• Application of Modules to Business Processes

15 Mins

5 Process Overview: Acquire to Retire

• General Concepts and Application• Application of Modules to Business Processes

15 Mins

6 Process Overview: Record to Report


15 Mins

7 Process Overview: Grants Management


15 Mins

8 Reporting • Introduction to PeopleSoft Reporting• Types of Reporting Tools

10 Mins

Presentation title[To edit, click View > Slide Master > Slide master1]

5

Topic 1: General Accounting Concepts• Basics of Governmental Accounting• Governmental Accounting Basis• Financial Statements• CCSF Ledgers


6

Oracle | E-Business Suite Training Oracle | PeopleSoft Training Basics of Governmental Accounting

Governmental accounting (also known as Fund or Budgetary Accounting) deals with the allocation and use of resourcesin accordance with the budget constraint of a public sector organization, especially government; and show how efficiently and effectively these resources are used to maintain or improve the well-being of their citizens


7


Governmental accounting includes activities such as • Analyzing• Summarizing• Recording and• Interpreting the financial

transactions of the Governmental entities, Departments and Spending Agencies


8



https://www.polleverywhere.com/multiple_choice_polls/qGJwlTJBXEPHForEIGpj8


9


Source: Accounting Policies & Procedures, June 2019

Applicable pronouncements established by the Governmental Accounting Standards Board (GASB)

0201

03

Generally Accepted Accounting Principles (GAAP) and Standards (GAAS)

Internal Policy & Procedures including Control Policies

The City is responsible for ensuring compliance with the following


10


Internal Users

External UsersInternal External

There are two types of users of Governmental Accounting information

Ascertain regulatory complianceand whether the actual expenditure is in

accordance with the budget

Ascertain the financial viability, efficiency, and effective management of Governmental

organizations

Taxpayers

State Government

Local Government

Heads of Government Departments

State Auditors

International Financial

Institutions

Local Creditors

International Creditors

Political Parties Trade UnionsRating

Agencies

Examples Examples


11



https://www.polleverywhere.com/multiple_choice_polls/XZkacZkOfg1Hw4t3dhOoQ


12



https://www.polleverywhere.com/multiple_choice_polls/uLvdwgcCFw0uCmkudnflL


13

Oracle | E-Business Suite Training Oracle | PeopleSoft Training Governmental Accounting Basis

Internal Users

External UsersCash Accrual

Governmental accounting (GASB 34) is based on the following traditional and modern thinking trends

Revenue is recognized only when cash is received

Modified Accrual

Expenditure is recognized only when cash is paid

Note: • The above applies irrespective of

whether the transaction occurred in the previous accounting period

Revenue is recognized when cash is earned rather than when it is

received

Expenditure is recognized when a liability is incurred

Note: • Balance sheet is affected at the

time of the revenues by either an increase in Cash (e.g. cash sale), an increase in Accounts Receivable (e.g. credit sale), or decrease in Unearned Revenues (if service was performed after customer prepaid service)

Revenue is recognized when cash is both earned and received

Expenditure is recognized when a liability is incurred

Note: • Earned — the cash flow from the

revenue can be reasonably estimated

• Received — the revenue is available to finance current expenditures to be paid within 60 days

CCSF Focus


14


Accrual*

Revenue (recognized

when earned)

Expenditure (recognized

when liability is incurred)

Title passes Services rendered For property taxes, revenues are earned when the

government establishes a legal claim by placing a lien on the property

Goods or services have been received Payment on claims has been received Services have been provided Judgments have been rendered by a court

Examples

* Note: CCSF Focus

Below are examples of how revenue and expenditure are recognized for Accrual


15


Modified*

Revenues (recognized when cash is earned and received)

Expenditure (recognized

when liability is incurred)

Accrue revenue (susceptible to accrual): Property taxes and other local taxes Grants and subventions Licenses Charges for services Rents and concessions Interest associated with the current fiscal period

All other revenue items are earned and received only when the City receives cash

Revenue earned but not received is deferred

Goods or services have been received Payment on claims has been received Services have been provided Judgments have been rendered by a court

Examples

* Note: CCSF Focus

Below are examples of how revenue and expenditure are recognized for Modified Accrual


16

Oracle | E-Business Suite Training Oracle | PeopleSoft Training Financial Statements

City-Wide Financial Statements include a Statement of Net Position (balance sheet) and Statement of Activities (income statement) which provide a broad overview of the City’s operations and finances


17


The accounting equation is calculated below

What is owned

• Cash• Receivables• Property &

Equipment

Assets + Deferred Outflow – Liabilities – Deferred Inflow = Net Position

Future consumption of

net assets

• Deferred Loss from Debt Refund

What is owed

• Accounts Payable• Payroll• Tax Liabilities

Future acquisition of net

assets

• Deferred Gain from Debt Refund

What is left after fund assets have been used to meet

liabilities

• Restricted Fund Balance• Assigned Fund Balance

Source: GASB and SF Employee Portal


18


Fund is a fiscal and accounting entity with aself-balancing set of accounts to carry on specific activities in accordance with special regulations, restrictions, or limitations

Source: SF Employee Portal


19


Sources: CCSF CAFR ‘18

Accrual Basis Modified Accrual Basis

The following hierarchy represents the roll-up to the financial statements filed according to CCSF’s Comprehensive Annual Financial Report (CAFR) Structure


City-Wide Financial

Statements

Governmental Funds

Proprietary Funds

Enterprise Funds

Fiduciary Funds


20


Financial Report Structure Governmental Funds• Funds that account for general and specific governmental

activities

• Most of City’s basic services are reported in governmental

funds


City-Wide Financial

Statements

Governmental Funds

Proprietary Funds

Enterprise Funds

Fiduciary Funds


• Examples:

10000 GF Annual Account Ctrl

10190 SR BIF Operating Project

16520 CPPLI 2000 PUB LIB S2005G


21


Financial Report Structure Proprietary Funds• Funds that account for services for which the City charges

customers, including internal units and external customers

• Enterprise Funds are a subset Proprietary Funds

• Used to account for business-type activities

City-Wide Financial

Statements

Governmental Funds

Proprietary Funds

Enterprise Funds

Fiduciary Funds


• Examples of Proprietary Funds:

• Examples of Enterprise Funds:

27500 ISCSF CENTRAL SHOPS FUND

28070 ISTIF Annual Authority Ctrl

28310 ISOIS REPRODUCTION FUND

17960 AIR Op Annual Account Ctrl

23680 PRT-OP Annual Account Ctrl

25940 WTR Op Annual Account Ctrl



22


Financial Report Structure Fiduciary Funds• Funds that account for resources held for the benefit of

parties outside the CityCity-Wide Financial

Statements

Governmental Funds

Proprietary Funds

Enterprise Funds

Fiduciary Funds


• Examples:

28550 Adm Svc -Consumer Assurance

31330 Employees Retirement Trust

31090 Investment Earning Fund



23



https://www.polleverywhere.com/multiple_choice_polls/vBIpmIB66IcF420Eou7sH


24



https://www.polleverywhere.com/multiple_choice_polls/f822aFretT6c8uui8QixU


25



https://www.polleverywhere.com/multiple_choice_polls/oYP0OuTZjkeKeUpcMUDhg


26

Oracle | E-Business Suite Training Oracle | PeopleSoft Training

The Accounting basis gets altered and Accrual methodis selected instead of Modified Accrual

Example of Accounts Payable Transaction

Reviews payment information and enters value to expense as an Asset

Enters an Enterprise Fund code (instead of Govt Fund code)

Asset gets capitalizedinstead of expensed (the original intention)

Assets on Enterprise Fund Statements are overstated due to capitalization

Expenses on Govt Fund Statements are understatedfor that amount

Janet Williams works in Accounts Payable at the Asian Art Museum and needs to enter a payment for an asset. The graphic below shows the impact caused by an incorrect entry


27

Oracle | E-Business Suite Training Oracle | PeopleSoft Training Example of Accounts Payable Transaction

Reviews payment information and enters value to expense as an Asset

Enters the Govt Fund code

The accountingbasis of Modified Accrual is applied

Asset is expensedaccurately as intended

Assets on Enterprise Fund Statements reflect correct numbers

Expenses on Govt Fund Statements reflect correct numbers

The graphic below shows the correct steps Janet Williams would take to enter a payment for an asset


28


Ledger is the book where all transactions as a debit or a credit are recorded

CCSF maintains three ledger types:

Budget Ledgers

Actual Ledgers

Adjustments Ledgers


29

Oracle | E-Business Suite Training Oracle | PeopleSoft Training CCSF Ledgers and Reports

• Used to make adjustments for transactions using full accrual basis of accounting

• Full accrual basis is used for reportingenterprise funds

Adjustment Ledger 1CAFR_FULL

• Used to account for actual transactions where entries (e.g., expenditures, adjustments) require a balanced entry

• For every transaction, debits equal credits

Actual Ledger

• Used to make adjustments for transactions using a modified accrual basis

• Modified accrual basis is used for governmental funds

Adjustment Ledger 2CAFR_MOD

• Monitors the budget and the budget administrators

• Used by staff to pass budget journals and perform budget check errors between funds

• Refers to the City’s budget types set aside for various purposes

Budget LedgerCommitment Control

The following are CCSF examples of ledgers where debit or credit are recorded

Example:• Processing POs, receipts,

vouchers• Receivable entries

Example:• Capitalizing an asset• Depreciation entries

Example:• Transactions following a

60 day revenue recognition rule

Example: • Budget check on actual

ledgers


30

Topic 2: PeopleSoft Basics• Introduction• Key Terms and Modules• Application of Modules to Business Processes


31

Oracle | E-Business Suite Training Oracle | PeopleSoft Training PeopleSoft Introduction

PeopleSoft Financials is a PeopleSoft Financial Management Solution focusing on financials, procurement, and projects and commonly known as an ERP

It helps companies achieve world-class finance processes, meet financial and statutory requirements, and efficiently deliver greater visibility into business-critical information


32

Oracle | E-Business Suite Training Oracle | PeopleSoft Training PeopleSoft Introduction

PeopleSoft Applications are designed to address the most complex business requirements and enable organizations to

Effectivelyexecute financial

processes in the face of

complexity

Easily adapt to a changingworkforce

Make informeddecisions

Lower costs by doing more

with less

Gain agilitywhile

minimizingdisruptions to

your organization

Oracle’s PeopleSoft is an industry leading, proven, functionally deep, and full suite of integrated applications


33

Oracle | E-Business Suite Training Oracle | PeopleSoft Training Key Terms and Modules

Fund Code/Fund Affiliate –Used for government

accounting, self-balancing set of books

Project ID/Activity –Tracks assets, liabilities, net

position, revenues, expenditures

Department –Tracks revenue/expenditures for department/cost center

TRIO– Tracks transfers in and out between department

Authority – Indicates the Board authorization of costing & execution of

programs/projects

GL Account– Classifies the nature of a transaction

Chartfields are the fields in a Chart of Accounts that a user enters when posting a transaction

Chartfields are identifiable as a Unique numeric ID and use a plain English description

Note: Chartfields do not self populate and need to be manually entered

Agency Use – Currentlyused by Airport, Port and

HSA

GL Business Unit –Organizational unit with a

balanced set of books

CCSF Chartfields


34


CCSF Chartfield Example

PS Field Length Required Code Description

GL Business Unit 5 Yes SFGOV* The Entire City Business Unit

Fund Code / Fund Affiliate 5 Yes 17960 SFIA Operating Fund

GL Account 6 Yes 425990 Settlement Account

Department 6 Yes 228994 AIR General

Authority 5 Yes 10000 Operating

Project ID / Activity 8 Yes 10001757 AC Airport Support Area

TRIO 6 Yes 100482 AIR_UNA

Agency Use 5 No 14136 GTU Customer Deposit


35


PeopleSoft Trees are hierarchical structures similar to a tree’s structure with that of nodes and details (leaves)

Trees represent the parent-child relationships and establish a rollup between different values of a similar type

Key Benefits

Rules can be used throughout the system after being defined once

Values updated in trees update automatically in reports, ledgers, or security profiles

Summarization rules are presented visually,easily, and in one single place


36


Tree Account Example


37


Tree Fund Codes Example


38


PeopleSoft’s effective-dating enables users to maintain anaccurate history of information in the database and identify when the account was created

Effective Dating Categories

Enter New Value – Enter effective date closest to but not greater than the system date

Predate Information – Enter effective dateearlier than the current date to add historical

data

Postdate Information – Enter effective date later than the system date to enter future data


39


Effective Date Example


40


PeopleSoft’s Budget Checkingenables users to check source transactions from PeopleSoft and third-party applications againstestablished control budgets

Key Benefits

Monitors transactions exceeding budgets by stopping transaction or issuing an error

Provides warning and error exceptionhandling through Commitment

Control ledgers

Allows establishment of expenditure budgets/tolerance levels besides linking

revenue budget to monitor available spending


41


Budget Check Example


42


CCSF currently has 17 of PeopleSoft’s

Financial Modules General Ledger

Accounts Receivable

Asset Management

Accounts Payable

Contracts

Purchasing/eProcurement

Expenses

Billing

Grants Management

Project Costing

Commitment Control

eSettlements eSupplier

Cash Management

Supplier Contract

Mgmt

Inventory Strategic Sourcing


43

Oracle | E-Business Suite Training Oracle | PeopleSoft Training Application of Modules to Business Processes

Asset Management


Strategic Sourcing

Supplier Contract Mgmt

Inventory

eSupplier

Accounts Payable

Asset AdditionsDepreciationRetirement

Journals

Acq

uire

d Ass

ets

Assets Received

Expenditures

Payments

Adj

ustm

ents

Project Costing

Capital Assets

Expenses

Cash Management

Cash Journals

General Ledger

Contracts (Customer)

Project Data

Billing Updates

Travel Journals

Billable Transactions

Billing

Customer Invoice

Accounts Receivables

Deposits

Revenue AR Journal

Unbilled AR

Billing Updates

Journals, Budgets

Grants

CCSF PeopleSoft Financials ERP modules/submodules Financial data/process/output

Modules impacted by Commitment Control

FSP Solution Model*

Commitment Control

eSettlements

AP Accruals

* Does not include external inbound/outbound interfacing systems


44

Topic 3: Process Overview – Procure to Pay• General Concepts and Application• Application of Modules to Business Processes


45

Oracle | E-Business Suite Training Oracle | PeopleSoft Training General Concepts and Application

Procure To Pay is the process of accounting for the requisitioning, purchasing, receiving, and paying for goods and services rendered


46


Receipt* Voucher*Invoice* 4 Way Matching*

1099 Reportable

Items*

Single Payment Voucher*

Purchase Order (PO)*

Written document acknowledging the receipt of money or property in payment

Note: This document needs to be inputted into the purchasing module for matching

Document presented by company to supplier stating the goods or services needed, the price, delivery date, and other terms

Used to collect and organize the necessary documentation and approvals before paying a supplier's invoice

This voucher is prepared by company’s AP department after invoice has been matched with the purchase order and receiving report

Purchase order presented by the company to the supplier

Process of matchingsupplier’s invoice to purchase order, business tax status, and receipt to arrange company’s payment to the supplier

Purchases with contracts require additional matching of documents with contract expiration date

Used in special circumstances for authorizednonrecurring and non-1099 reportable payments to one-time suppliers

This voucher is not used in the CCSF Supplier database

Items payable to unincorporated entities(individuals, sole proprietors, or partnerships) for services, non-employee compensation, rents, royalties, or prizes and awards

The following are common concepts associated with the Procure to Pay process

*Note: Functionalities used by CCSF


47


Asset Management


Strategic Sourcing


Inventory

eSupplier

Accounts Payable


Journals

Acq

uire

d Ass

ets

Assets Received

Expenditures

Payments

Adj

ustm

ents

Project Costing

Capital Assets

Expenses

Cash Management

Cash Journals

General Ledger

Contracts(Customer)

Project Data

Billing Updates

Travel Journals


Billing

Customer Invoice


Revenue AR Journal

Unbilled AR

Billing Updates

Journals, Budgets

Grants

Modules/submodules related to P2P

Financial data/process/output related to P2P


Procure to Pay interaction in PeopleSoft

Not related to P2P

Commitment Control

Deposits

eSettlements

AP Accruals


48



https://www.polleverywhere.com/multiple_choice_polls/HIluWxHWZYAMTgxZvFEYm


49

Topic 4: Process Overview – Bill to Receive• General Concepts and Application• Application of Modules to Business Processes


50


Bill to Receive is the process of adding customers /sponsors, generating bills and creating receivables, completing reconciliations, applying payments, and maintaining different types of customers


51


CustomerBill TypePayment

Worksheet*Payment Predictor

Direct Journal*

A debtor who owes money to the City (e.g., person, business, government entity)

Category of activities that should be grouped together on a particular bill (e.g., grants, rent, property taxes)

Used to manuallyapply payments to AR Open Items with information about customers and items

Used to automaticallyapply payments to AR Open Items and for matching

Payments that do not correspond to AR Open Items, bypass the cash application process, and are posted directly to the General Ledger (e.g., cash receipts, non-AR cash)

Maintenance Worksheet*

Adjustment tool to execute write-offs, offsets, andrefunds

The following are common concepts associated with the Bill to Receive process



52


Asset Management


Strategic Sourcing


Inventory

eSupplier

Accounts Payable

eSettlements


Journals

Acq

uire

d Ass

ets

Assets Received

Expenditures

Payments

Adj

ustm

ents

Project Costing

Capital Assets

Expenses

Cash Management

Cash Journals

General Ledger


Project Data

Billing Updates

Travel Journals


Billing

Customer Invoice


Revenue AR Journal

Unbilled AR

Billing Updates

Journals, Budgets

Grants

AP Accruals

Bill to Receive interaction in PeopleSoft

Modules/submodules related to B2R

Financial data/process/output related to B2R


Not related to B2R

Commitment Control

DepositsAP Accruals


53



https://www.polleverywhere.com/multiple_choice_polls/wi976BICecVACCdLRBoSe


54

Topic 5: Process Overview – Acquire to Retire• General Concepts and Application• Application of Modules to Business Processes


55


Acquire To Retire is the process by which the City’s Asset Management system tracks assets from Acquisition, Depreciation, andService/Maintenancethrough the Disposal of assets


56


The following are common concepts associated with the Acquire to Retire process

Asset Depreciation* Assets*

Construction in Progress*Asset Disposal*

Straight-Line Method*

Resources with present service capacity that the government presently controls

Process of eliminating assets that are fully depreciatedor no longer of use to the City (e.g., assets retirement, transfer, and deletion)

Projects not captured in the Fixed Asset Module until they are substantially complete

Costs pushed over into asset management when the department is ready to capitalize

Allocation of the cost of an asset to Depreciation Expense over the useful life of the asset

Depreciation method that results in the same equal amount of depreciation expense for each full year over the life of the asset

This is the only method used by City for depreciation

Capitalized Cost*

Process of recording the amount of a cost in a balance sheet instead of income statement



57


Asset Management


Strategic Sourcing


Inventory

eSupplier

Accounts Payable


Journals

Acq

uire

d Ass

ets

Assets Received

Expenditures

Payments

Adj

ustm

ents

Project Costing

Capital Assets

Expenses

Cash Management

Cash Journals

General Ledger

Contracts(Customer)

Project Data

Billing Updates

Travel Journals


Billing

Customer Invoice


Revenue AR Journal

Unbilled AR

Billing Updates

Journals, Budgets

Grants

Acquire to Retire interaction in PeopleSoft

Modules/submodules related to A2R

Financial data/process/output related to A2R


Not related to A2R

Commitment Control

Deposits

eSettlements

AP Accruals


58



https://www.polleverywhere.com/multiple_choice_polls/0B3A61FLLHbOmC4Ebwpyx


59

Topic 6: Process Overview – Grants Management• General Concepts and Application• Application of Modules to Business Processes


60


The Grants Management system provides functionalityto help the City’s departments manage and track grant activities


61


Appropriation Control

Grants & Customer Contracts and Project Costing Implementation*

Unallocated Fund

Appropriations are controlled at the fund level by policy and procedure (known as Fund and Project at CCSF)

Types of funds associated with grants include:• Federal• State• Local • Gifts or Bequests

For city projects that have many funding sources, this fund is grouped together with the grant funds into a spending pool

Appropriations are controlled at the sum of the amounts available across the individual funds (not at the individual amount available for any single fund)

Collects all expense transactions automatically, creates accounting entries, and tees up billing automatically

This seamlessly ties the revenue recognition, receivables, and application of payments

The following are common concepts associated with the Grants Management process



62


Asset Management


Strategic Sourcing


Inventory

eSupplier

Accounts Payable


Journals

Acq

uire

d Ass

ets

Assets Received

Expenditures

Payments

Adj

ustm

ents

Project Costing

Capital Assets

Expenses

Cash Management

Cash Journals

General Ledger


Project Data

Billing Updates

Travel Journals


Billing

Customer Invoice


Revenue AR Journal

Unbilled AR

Billing Updates

Journals, Budgets

Grants

Grants Management interaction in PeopleSoft

Modules/submodules related to GM

Financial data/process/output related to GM


Not related to GM

Commitment Control

Deposits

eSettlements

AP Accruals


63



https://www.polleverywhere.com/multiple_choice_polls/rR3vhX9R1WGLcrdbu9oxb


64

Topic 7: Process Overview – Record to Report• General Concepts and Application• Application of Modules to Business Processes


65


Record to Report is the process of accumulating the results of transaction processing, budgets creation, financial statements, and financial data for reporting purposes


66


Account* Business Unit* ChartField*Chart of Accounts (COA)*

General Ledger*

Record-keeping system for a company's financial data with debit and credit account records

Provides a record of each financial transaction taking place during the life of an operating company

Listing of all the accounts a company owns

Each of these accounts is identified by a description and/or a reference number

Organization or organizational subset that is independent with regard to one or more accounting or operational functions

Identifies the type of asset, liability fund balance, receipt, expense, transfer or statistical measurement involved in a transaction

Accounts are standardized across the City and formatted as a single coding element

Fields that store Charts of Accounts and provide the basic structure to segregate and categorize transactional and budget data

The following are common concepts associated with the Record to Report process

Tree*

Hierarchical structures similar to a tree’s structure with that of nodes and details (leaves)



67


Asset Management


Strategic Sourcing


Inventory

eSupplier

Accounts Payable


Journals

Acq

uire

d Ass

ets

Assets Received

Expenditures

Payments

Adj

ustm

ents

Project Costing

Capital Assets

Expenses

Cash Management

Cash Journals

General Ledger

Contracts(Customer)

Project Data

Billing Updates

Travel Journals


Billing

Customer Invoice


Revenue AR Journal

Unbilled AR

Billing Updates

Journals, Budgets

Grants

Record to Report interaction in PeopleSoft

Modules/submodules related to R2R

Financial data/process/output related to R2R

Modules impacted by Commitment ControlNot related to R2R

Commitment Control

Deposits

eSettlements

AP Accruals


68

Oracle | E-Business Suite Training Oracle | PeopleSoft Training FY 2019 Year End Closing Timeline

JUN

JUL

AU

G

OC

T

NO

V

SEP

Procure to Pay

Acquire to Retire

Bill to Receive

Record to Report

07/05 Deposit Received

08/31Revenue

Recognition

07/01 G/L Closed

07/26Overhead Allocations

08/16 Closing Actuals

Ledger

Pro

cess

es a

nd

Key

Mile

sto

nes

09/07 DepreciationProject Costing to Asset Management Review

08/16 AP Accrual

11/27 CAFR

06/30 PO Roll

06/17 PO Module Pre Open


69

Topic 8: Reporting• Introduction to PeopleSoft Reporting• Types of Reporting Tools


70


PeopleSoft applications offer a wide range of query and reporting possibilities including standard and customizedreports


71

Oracle | E-Business Suite Training Oracle | PeopleSoft Training Types of Reporting Tools– CCSF

Report Type Definition Data Source Examples

Financial Statements

Standard, structured, hierarchical reports run at the end of a period for a specific organizational unit

PeopleSoft (PS) Ledger Balances

Trial Balance, Balance Sheet, Statement of Net Position

Reconciliation

Standard, transactional reports run at the end of a period comparing activity in PS submodules to PS general ledger or PS GL to external accounts activity

PS submodule accounting tables and PS GL tables or external account data

Accounts Payable to GL reconciliationExternal bank reconciliation

OperationalCombination of standard and ad-hoc transactional reports used to support periodic activities

PS submodules Outstanding paymentsOpen PO

ExceptionPrimarily ad-hoc, transactional reports used to facilitate analysis and research reconciling items

PS submodules transaction tables and GL transaction and ledger tables

Departmental queries and online PS inquiries

The most common report types used by CCSF are listed below


72

Oracle | E-Business Suite Training Oracle | PeopleSoft Training Types of Reporting Tools

PS Query PS Reports nVision Oracle BI

• Run directly against the PeopleSoft database

• Multiple database tables can be joined to provide additional transaction details

• Enables the user to select their relevant data setfor the inquiry

• Can include both transactional data and ledger balances

• Standard reports and online inquires available in all modules

• Includes CCSF customized versions of delivered reports

• Report criteria enables user to refine the scope of the data returned

• Supported by SQR and BI Publisher tools

• Reporting tool that retrieves data directlyfrom the PeopleSoft database on request and places it in a CCSF developed excel spreadsheet

• Structures the report using PeopleSoft Chartfield hierarchies (trees)

• Allows user to drill back to source transaction from ledger balance

• Oracle business intelligence platform that uses extracts of PeopleSoft data and provides dashboard and standard reports

• Ad-hoc inquiries against the tool’s database

• Retrieves data from Peoplesoft nightly and places it into its own database

The PeopleSoft system includes various reporting and processing tools


73



https://www.polleverywhere.com/multiple_choice_polls/gy5LjiyBB63lpywVU5r5V


74



https://www.polleverywhere.com/multiple_choice_polls/jAiMhZ2g9oWaXzzce7kE4


75

Closing Recap


76


Course Recap

Articulate the general accounting concepts and terms applicable to governmental accounting

Define commonly used terms and processes in PeopleSoft accounting

Describe the general concepts, PeopleSoft application, andapplication of modules for the Procure to Pay, Bills to Receive, Acquire to Retire, Record to Report, and Grants Management processes

In this lesson, you learned how to:


77

Oracle | E-Business Suite Training Oracle | PeopleSoft Training What’s Next?

The following upcoming deep dive sessions will be available for enrollment*

Material Covered

Note: Session requirements will be specified by your job role

Upcoming Deep Dive Sessions

Procure to Pay Process

Bill to Receive Process

Acquire to Retire Process

Record to Report Process

Grants Management Process

Project Types

Employee Reimbursements andTravel Advances

Refresher on how data in associated modules is organized, recorded, and searched

Applicable policies and procedures for each process

Common inquiries/FAQs

End-to-end process workflow in PeopleSoft

Key accounting entries within each process


78


Questions?

Thank you for your time!

About DeloitteDeloitte refers to one or more of Deloitte Touche Tohmatsu Limited, a UK private company limited by guarantee (“DTTL”), its network of member firms, and their related entities. DTTL and each of its member firms are legally separate and independent entities. DTTL (also referred to as “Deloitte Global”) does not provide services to clients. In the United States, Deloitte refers to one or more of the US member firms of DTTL, their related entities that operate using the “Deloitte” name in the United States and their respective affiliates. Certain services may not be available to attest clients under the rules and regulations of public accounting. Please see www.deloitte.com/about to learn more about our global network of member firms.


http://www.deloitte.com/about

city and county of san francisco - office of the controller · 2020-01-03 · presentation title...

Documents