Payroll Recon

1
Payroll Recon
14 Feb 2003
2
Objectives
Without reference, define the term Personnel
Payroll Reconciliation. With reference, list
and describe payroll reconciliation research
tools.
3
What is a reconciliation?
Matching data on the DCPDS and DCPS system.
Essential to ensure accuracy of employee pay and
benefit participation. Identifies system
shortfalls in both systems.
4
Reconciliation Process
Reconciliation must be Processed 3 times a Year
mandated by the Chief Financial Officer. Hot
and Benefits issues must be reconciled monthly.
5
Research Tools

• Previous Recons Lessons Learned
• Check to see if the org code is in DCPS
• Personnel/Payroll Advisory Letter (PAL) issues
  (see Job Aids Page)
• Check for Pay reject or IVRS reject in ART
• Check to see if the action flowed on the PAY500

6
Payroll Reconciliation Extract
7
RECONalysis v2.0 NAVIGATION
RECON
8
(No Transcript)
9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
Position
13
Person
14
Hot
15
All Types
16
ANDREWS CHARLES E
123-45-6789
17
(No Transcript)
18
Reports
19
(No Transcript)
20
Close the RECONalysis Tool
21
(No Transcript)
22
(No Transcript)
23
(No Transcript)
24
(No Transcript)
25
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
RESOLVING THE MISMATCH
30
STEPS IN RESOLVING THE MISMATCH

• MUST FIND THE FIRST PERSONNEL ACTION WHICH
  CHANGED THE VALUE IN QUESTION
• CHECK BOTH MDCPDS AND DCPS TO SEE WHERE THE VALUE
  CHANGED
• DETERMINE HOW MANY ACTIONS THE MISMATCH HAS
  OCCURRED ON - HOW FAR BACK?

31
TOOLS TO USE TO DETERMINE THE CAUSE OF THE
PROBLEM

• Check both DCPS and MDCPDS
• Lessons Learned from Previous Reconciliations
• Org Code Newly Established?--Check DCPS
• Check the Personnel/Payroll Advisory Letter (PAL)
  http//cpol.army.mil/modern/docs/pal
• Check for a pay reject or IVRS reject in ART
• Check the PAY500

32
Cause of the Mismatch Action Taken
33
(No Transcript)
34
(No Transcript)
35
REPORTS in RECONalysis
36
Reports
37
OPEN ACTIONS COUNT OF EMPLOYEE RECORDS BY CPO ID
1
2
38
Open Actions - Count of Employee Records by CPO ID
39
Open Actions - Count of Employee Records by CPO
ID (Hot/Benefits Only)
1
2
40
OPEN ACTIONS COUNT OF EMPLOYEE RECORDS BY CPO ID
Hot and Benefits only
41
Open Actions - Count of Data Elements by CPO ID
and Data Element Mismatched
1
2
42
Open Actions - Count of Data Elements by CPO ID
and Data Element Mismatched
43
Open Actions - Count of Unresolved Data Elements
by CPO ID and Type of Information
1
2
44
Open Actions - Count of Unresolved Data Elements
by CPO ID and Type of Information
45
Reconciliation Comparison
1
2
3
4
46
Recon Comparison
47
DCPDS/DCPS Reconciliation Report for CPOCMA
1
2
48
DCPDS/DCPS Reconciliation Report for CPOCMA
49
Data Element Employee List
1
2
3
4
50
DATA ELEMENT EMPLOYEE LIST
51
Open Actions by Error Type
1
5
2
4
3
52
OPEN ACTIONS BY ERROR TYPE
53
RESOLVED ACTIONS BY CAUSE/ACTION TAKEN
1
3
2
4
54
RESOLVED ACTIONS BY CAUSE/ACTION TAKEN
55
RESOLVED ACTIONS BY CAUSE (SUMMARY)
1
2
3
4
56
RESOLVED ACTIONS BY CAUSE (SUMMARY)
57
Statistical Report by Data Element and NOA Code
1
2
58
STATISTICAL REPORT BY DATA ELEMENT INCLUDING NOA
CODE
59
ADDITIONAL RECON REPORTS FROM MODERN

• On Personnel Not on Pay
• On Payroll Not in Personnel

60
ADDITIONAL RECON REPORTS FROM MODERN (CONTINUED)

• ORGANIZATION DATA MISMATCH REPORT
• TA DATA MISMATCH REPORT
• TA STATISTICAL RECAP REPORT

61
Goals
You should now be able to define the term
Personnel Payroll Reconciliation. List and
describe the payroll reconciliation research
tools.