Reports for Employee Funding June 27, 2018 Presenters Jackie - - PowerPoint PPT Presentation

▶
reports for employee funding
SMART_READER_LITE
LIVE PREVIEW

Reports for Employee Funding June 27, 2018 Presenters Jackie - - PowerPoint PPT Presentation

Oct 23, 2022 126 likes •625 views

Reports for Employee Funding June 27, 2018 Presenters Jackie Treschl, ConnectCarolina Change Management Chris Minter , ConnectCarolina Change Management Robin Burke, Business Systems Manager Chris Lawless , Business Systems Analyst

slide-1
SLIDE 1

Reports for Employee Funding

June 27, 2018

slide-2
SLIDE 2

Presenters

  • Jackie Treschl, ConnectCarolina Change Management
  • Chris Minter, ConnectCarolina Change Management
  • Robin Burke, Business Systems Manager
  • Chris Lawless, Business Systems Analyst
  • Crystal Jackson, Sr. Business Systems Analyst
slide-3
SLIDE 3

Webinar Format

Use the chat window to ask a

  • question. We’ll keep track of

them and stop at the end of each section to answer them. The webinar recording will be posted on https://ccinfo.unc.edu We’ll use polling questions to check for understanding

slide-4
SLIDE 4

Today’s Topics

How the payroll funding process works Where in the process reports pull information

from

When it’s helpful to use each report

1 2 3

slide-5
SLIDE 5

Helpful Information

How

  • w t

the Payrol

  • ll F

Funding P Process W Works

slide-6
SLIDE 6

Before We Get Started….

How much do you already know about the payroll funding process and the reports associated with them?

  • A. I don’t know very much at all.
  • B. I only know a little bit – but the report names are confusing.
  • C. I know enough to get the information I need.
  • D. I am a master but want to see if there are additional reports I

may not know about.

slide-7
SLIDE 7

How the payroll funding process works

slide-8
SLIDE 8

The Payroll Funding Process

Check End Dates

slide-9
SLIDE 9

The Payroll Funding Process

Submit ePAR to Change Salary Check End Dates

slide-10
SLIDE 10

The Payroll Funding Process

Submit ePAR to Change Salary Store Funding Information Store Salary Amounts Check End Dates

slide-11
SLIDE 11

The Payroll Funding Process

Submit ePAR to Change Salary Store Funding Information Store Salary Amounts Add Special Pay to Paychecks Check End Dates

slide-12
SLIDE 12

The Payroll Funding Process

Submit ePAR to Change Salary Store Funding Information Store Salary Amounts Generate Paychecks Add Special Pay to Paychecks Check End Dates

slide-13
SLIDE 13

The Payroll Funding Process

Submit ePAR to Change Salary Store Funding Information Store Salary Amounts Generate Paychecks Add Special Pay to Paychecks Check End Dates Recalculate Projections

slide-14
SLIDE 14

The Payroll Funding Process

Submit ePAR to Change Salary Store Funding Information Store Salary Amounts Generate Paychecks Add Special Pay to Paychecks Check End Dates Recalculate Projections Distribute to Chartfield Strings

slide-15
SLIDE 15

The Payroll Funding Process

Submit ePAR to Change Salary Store Funding Information Store Salary Amounts Generate Paychecks Add Special Pay to Paychecks Post to Suspense, if necessary Check End Dates Recalculate Projections Distribute to Chartfield Strings

slide-16
SLIDE 16

The Payroll Funding Process

Submit ePAR to Change Salary Store Funding Information Store Salary Amounts Generate Paychecks Add Special Pay to Paychecks Record Payroll Expenses in GL Actuals Ledger Post to Suspense, if necessary Check End Dates Recalculate Projections Distribute to Chartfield Strings

slide-17
SLIDE 17

The Payroll Funding Process

Submit ePAR to Change Salary Store Funding Information Store Salary Amounts Generate Paychecks Add Special Pay to Paychecks PAAT Transactions Make Changes Record Payroll Expenses in GL Actuals Ledger Post to Suspense, if necessary Check End Dates Recalculate Projections Distribute to Chartfield Strings

slide-18
SLIDE 18

Check Your Understanding

True or False? ConnectCarolina stores the chartfield strings and the percent to charge for base and supplemental salary separately from the base and supplemental salary amounts.

slide-19
SLIDE 19

Check Your Understanding

When are the charges in paychecks distributed to chartfield strings?

  • A. After posting in the General Ledger
  • B. Before paychecks are generated
  • C. After paychecks are generated
  • D. When the ePAR is submitted
slide-20
SLIDE 20

Where in the process reports pull

information from

slide-21
SLIDE 21

The Payroll Process

Submit ePAR to Change Salary Store Funding Information Store Salary Amounts Generate Paychecks Add Special Pay to Paychecks PAAT Transactions Make Changes Record Payroll Expenses in GL Actuals Ledger Post to Suspense, if necessary Check End Dates Recalculate Projections Distribute to Chartfield Strings

slide-22
SLIDE 22

The Payroll Process

Submit ePAR to Change Salary Store Funding Information Store Salary Amounts Generate Paychecks Add Special Pay to Paychecks PAAT Transactions Make Changes Record Payroll Expenses in GL Actuals Ledger Post to Suspense, if necessary Check End Dates Recalculate Projections Distribute to Chartfield Strings

  • 1. Funding End Date

Notification Report

slide-23
SLIDE 23

The Payroll Process

Submit ePAR to Change Salary Store Funding Information Store Salary Amounts Generate Paychecks Add Special Pay to Paychecks PAAT Transactions Make Changes Record Payroll Expenses in GL Actuals Ledger Post to Suspense, if necessary Check End Dates Recalculate Projections Distribute to Chartfield Strings

  • 1. Funding End Date

Notification Report

  • 2. Salary

Funding Report

slide-24
SLIDE 24

The Payroll Process

Submit ePAR to Change Salary Store Funding Information Store Salary Amounts Generate Paychecks Add Special Pay to Paychecks PAAT Transactions Make Changes Record Payroll Expenses in GL Actuals Ledger Post to Suspense, if necessary Check End Dates Recalculate Projections Distribute to Chartfield Strings

  • 1. Funding End Date

Notification Report

  • 3. Salary Projections

Report

  • 2. Salary

Funding Report

slide-25
SLIDE 25

The Payroll Process

Submit ePAR to Change Salary Store Funding Information Store Salary Amounts Generate Paychecks Add Special Pay to Paychecks PAAT Transactions Make Changes Record Payroll Expenses in GL Actuals Ledger Post to Suspense, if necessary Check End Dates Recalculate Projections Distribute to Chartfield Strings

  • 1. Funding End Date

Notification Report

  • 3. Salary Projections

Report

  • 4. Current Suspense

Charges Report

  • 2. Salary

Funding Report

slide-26
SLIDE 26

The Payroll Process

Submit ePAR to Change Salary Store Funding Information Store Salary Amounts Generate Paychecks Add Special Pay to Paychecks PAAT Transactions Make Changes Record Payroll Expenses in GL Actuals Ledger Post to Suspense, if necessary Check End Dates Recalculate Projections Distribute to Chartfield Strings

  • 1. Funding End Date

Notification Report

  • 3. Salary Projections

Report

  • 4. Current Suspense

Charges Report

  • 5. UNC Suspense

Analysis Report

  • 2. Salary

Funding Report

slide-27
SLIDE 27
  • 6. Labor & Expense

Report

The Payroll Process

Submit ePAR to Change Salary Store Funding Information Store Salary Amounts Generate Paychecks Add Special Pay to Paychecks PAAT Transactions Make Changes Record Payroll Expenses in GL Actuals Ledger Post to Suspense, if necessary Check End Dates Recalculate Projections Distribute to Chartfield Strings

  • 1. Funding End Date

Notification Report

  • 3. Salary Projections

Report

  • 4. Current Suspense

Charges Report

  • 5. UNC Suspense

Analysis Report

  • 2. Salary

Funding Report

slide-28
SLIDE 28
  • 7. Review Pending

Transactions Report

  • 3. Salary Projections

Report

  • 6. Labor & Expense

Report

The Payroll Process

Submit ePAR to Change Salary Store Funding Information Store Salary Amounts Generate Paychecks Add Special Pay to Paychecks PAAT Transactions Make Changes Record Payroll Expenses in GL Actuals Ledger Post to Suspense, if necessary Check End Dates Recalculate Projections Distribute to Chartfield Strings

  • 1. Funding End Date

Notification Report

  • 4. Current Suspense

Charges Report

  • 5. UNC Suspense

Analysis Report

  • 2. Salary

Funding Report

slide-29
SLIDE 29
  • 3. Salary Projections

Report

  • 6. Labor & Expense

Report

  • 7. Review Pending

Transactions Report

  • 8. Payroll

Accounting Report

The Payroll Process

Submit ePAR to Change Salary Store Funding Information Store Salary Amounts Generate Paychecks Add Special Pay to Paychecks PAAT Transactions Make Changes Record Payroll Expenses in GL Actuals Ledger Check End Dates Recalculate Projections Distribute to Chartfield Strings

  • 1. Funding End Date

Notification Report

  • 4. Current Suspense

Charges Report

  • 5. UNC Suspense

Analysis Report

  • 2. Salary

Funding Report

Post to Suspense, if necessary

slide-30
SLIDE 30

Check Your Understanding

When is the best time to run the Funding End Date Notification Report?

  • A. After you notice an error
  • B. At the beginning of each pay period
  • C. When paychecks are generated
  • D. After charges are posted to suspense accounts
slide-31
SLIDE 31

When it’s helpful to use each report

slide-32
SLIDE 32

Access to the Reports

slide-33
SLIDE 33
  • 1. Funding End Date Notification Report
  • Run this report at the beginning of a pay period.
  • See positions or appointments for which a portion of the

paycheck may be charged to suspense.

  • See the reason a portion of the paycheck may be charged to

suspense.

– Project ending – Expired or inactive chartfield string – No funding assigned

ALERT!

ConnectCarolina: HR/Payroll Menu > Payroll Accounting Reports > Funding End Date Notification

slide-34
SLIDE 34
  • 2. Salary Funding Report
  • Run this report to see how base and supplemental was

planned to be charged.

  • Doesn’t include the following:

– Lump sum payments – Overtime – PAAT transactions

PLAN

InfoPorte: HR > Payroll > Salary Funding

  • r

InfoPorte: Finance > Financial Reporting > Salary Funding

slide-35
SLIDE 35
  • 3. Salary Projections Report
  • Run this report to see how the salary is projected to be paid

in the future.

  • Based on the earliest of the job end date, funding end date, or

budget end date.

  • Doesn’t include the following:

– Temporary employees – PAAT transactions

FUTURE

InfoPorte: HR > Payroll > Salary Projections

slide-36
SLIDE 36
  • 4. Current Suspense Charges Report
  • Run this report to see ALL current transactions that have been

posted to departmental suspense accounts due to invalid chartfield strings.

  • Includes all payroll transactions and PAAT transactions

ALERT!

ConnectCarolina: Main Menu > HR/Payroll Menu > Payroll Acct Adj. Tool (PAAT) > Current Suspense Charges

slide-37
SLIDE 37
  • 5. UNC Suspense Analysis Report
  • Run this report to see WHY payroll transactions have been

posted to departmental suspense accounts.

  • Details include:

– The Chartfield string that’s in error – Funding end date – Number of days the charge has been in suspense

  • Includes all payroll transactions.
  • Doesn’t include PAAT transactions.

ALERT!

ConnectCarolina: Main Menu > HR/Payroll Menu > Payroll Accounting Reports > UNC Suspense Analysis

slide-38
SLIDE 38
  • 6. Labor & Expense Report
  • Run this report to review the charges of salary and fringe

benefit expenses from an HR point of view.

  • Shows where a pay period is currently charged, regardless of

where it was originally charged.

  • Doesn’t show history.

CURRENT

InfoPorte: HR > Payroll > PAAT

slide-39
SLIDE 39
  • 7. Review Pending Transactions Report
  • Run this report to check the approval status of all pending

PAAT transactions.

PENDING APPROVAL

ConnectCarolina: Main Menu > HR/Payroll Menu > Payroll Acct Adj. Tool (PAAT) > Review Pending Transactions

slide-40
SLIDE 40
  • 8. Payroll Accounting Report
  • Run this report to see a complete history of payroll

transactions for an employee or chartfield string.

  • Includes accounting information.

InfoPorte: Finance > Financial Reporting > Personnel > Payroll Accounting Report

COMPLETE HISTORY

slide-41
SLIDE 41

Check Your Understanding

Which report shows you how base and supplemental salary was planned to be charged?

  • A. Salary Funding Report
  • B. Payroll Accounting Report
  • C. Labor Expense Report
  • D. Funding End Date Notification Report
slide-42
SLIDE 42

Check Your Understanding

Which report shows you a complete history of payroll transactions, including PAAT transactions?

  • A. Salary Funding Report
  • B. Payroll Accounting Report
  • C. Labor Expense Report
  • D. Review Pending Transactions Report
slide-43
SLIDE 43

Check Your Understanding

Which of the suspense reports includes information about PAAT Transactions?

  • A. UNC Suspense Analysis Report
  • B. Current Suspense Charges Report
slide-44
SLIDE 44

Check Your Understanding

True or False? The Review Pending Transactions Report shows all payroll related transactions that are waiting for approval.

slide-45
SLIDE 45

Today We Covered

How the payroll funding process works Where in the process reports pull information

from

When it’s helpful to use each report

1 2 3

slide-46
SLIDE 46

Want More Information?

  • Check out ccinfo.unc.edu

– Training guides with step-by-step instructions for running the reports – Finance and HR Reporting Guides lists the reports and training materials – Online trainings for PAAT – Register for the InfoPorte Finance and HR classes – Recorded webinars for some reports from when reports were released

slide-47
SLIDE 47

What Questions Do You Have?

slide-48
SLIDE 48

Information | ccinfo.unc.edu Questions| cc_communications@unc.edu Training | connectcarolina_training@unc.edu Subscribe | ConnectCarolina Newsletter Help | help.unc.edu | 962-HELP

slide-49
SLIDE 49

The Payroll Process

Submit ePAR to Change Salary Store Funding Information Store Salary Amounts Generate Paychecks Add Special Pay to Paychecks PAAT Transactions Make Changes Record Payroll Expenses in GL Actuals Ledger Post to Suspense, if necessary Check End Dates Recalculate Projections Distribute to Chartfield Strings