PPMSFMS Interface

1
PPMS/FMS Interface

• PPMS User Group
• May 29, 2009
• Rita Lauzon

2
PPMS Basics

• Based on calendar year for W-2s
• One checking account for payroll checks for
  system that is managed by SBCTC
• When payroll runs, PPMS data posts to FMS
• Interface is one way - PPMS to FMS
• EFTs sent through Payroll
• If want PPMS and FMS to match, any corrections
  should be processed in PPMS

3
Institutional Parameter Table (PS9001)

• Identifies constant values
• Used by various system processes
• If there is a change
• Table updated
• Automatically reflected in applicable processes
• No need to change each employee record
• 1 999 maintained by SBCTC-IT
• 1000 and above maintained by colleges

4
Parameters 302 to 311

• Identify the Transaction Codes
• When payroll processed, sent to FMS for posting
• Must be valid on Transaction Code Table (GA1093)
• 302 Payroll Expense 002
• 303 Payroll Accrued Expense 802
• 304 Payroll Reverse Accrual 804
• 305 Deposit 040

5
Parameters 302 to 311 (Cont)

• 306 Payroll Account
• Clearing Account 790 300 1B99
• 307 Treasure Fund 805
• 308 Deduction Prepaid 801
• 309 Electronic Fund Transfer 800
• 310 Payroll Liability 807
• 311 Staff Months 894

6
Parameters 314 to 318

• Identify the subobjects for employer costs
• 314 Industrial Insurance BC
• 315 OASI BA
• 316 Retirement BB
• 317 Medical Aid BC
• 318 Health BD

7
Parameters 329 to 332

• Identify the FMS Batch IDs
• 329 Payroll Expenditures 06
• 330 Accrued Expenditures 07
• 331 Year End Expenditures 08
• 332 EFT 09

8
Parameter 1014 Benefits Option

• Identifies level of detail for reporting benefits
• S Summary (Funds 001, 08A and 149 only)
• Recorded in one org index per program
• D Detail
• Recorded as expensed in each org index
• C Summary by Campus
• Recorded in one org index per campus

9
Parameter 1016 Prepaid Deduction Account Code

• Identifies account number in fund 790 for prepaid
  deduction
• Prepaid deduction is
• Deduction taken in advance to cover a period when
  someone is not working
• Paid to the vendor each payroll they are not
  working
• Examples are medical, life and LTD insurance

10
Parameter 1031 Employer Cost Default Account

• Identifies account to charge employer cost
• If no accounts are being paid
• If employee does not have active job
• Should monitor this account

11
Parameter 1032 Health Cost Option

• Indicates how system pays health cost when job 01
  is not being paid
• Y Charge Job 01
• N Charge all active jobs

12
Parameters 1250 to 1253

• Identify the months during which payroll
  expenditures should be assigned to sessions
• Used for year/quarter in financial aid
• Used for PTF benefits tracking in PPMS
• 1250 Session 1 Months
• 1251 Session 2 Months
• 1252 Session 3 Months
• 1253 Session 4 Months

13
Parameter 1300 Work Study Subobject

• Subobject used to identify work study
  transactions
• Used for work study split
• Must be valid on the Subobject Table (GA1011)

14
Unemployment Compensation Institution Parameters

• 333 UI Subobject Set to BF
• 1022 UI Option
• Y Yes, expense UI costs into FMS
• N No, do not expense UI costs into FMS
• 1023 UI Program/Organization
• 1104 UI Percentage
• 1107 UI Appropriation Index
• 1108 UI Transaction Code

15
Deduction Table (PS9002)

• Identifies deductions and related elements
• Required to process payroll deductions
• Determines
• Method of calculating deductions
• Making vendor payments
• Recording proper accounting entries
• Identifies EFT Vendor

16
Deduction Table (cont)

• Three types of deductions
• Deductions (after tax)
• Reductions (before tax)
• Contributions (employer costs)
• Three types of payments
• Check
• Journal Voucher
• EFT

17
Work Study Split Table (PS9046)

• Maintain work study account and percent
• Maintained by earnings type
• Overrides account distribution on employees job
• Prorates
• Total gross pay
• Staff months
• Time
• Does not prorate benefits

18
Reports to use for Reconciling

• PS0360 Employee Account Distribution Edit
• PS1245 Payroll Expense EFT Summary
• PS1410 FMS Payroll Reconciliation Report
• PS1420, PS1421 or PS1422 - Expense Distribution
  Reports
• PS1425 Vendor Payment Liability Report

19
PS0360 Employee Account Distribution Edit

• Re-edits all active employee accounts against
  current FMS tables
• Reports any errors with diagnostic message
• Stand alone job
• Can be run any time
• On our scheduling calendar before the first
  payroll of the new fiscal year

20

• TUE, FEB 10, 2009, 331 PM
  
  PAGE 1
• 
  NN SAMPLE COMM COL
  REPORT PS0360
• 
  EMPLOYEE ACCOUNT DISTRIBUTION EDIT
  VER008
• EMPLOYEE JOB ACCT
  ACCOUNT
• EMPLOYEE NAME ID NUM NUM
  DISTRIBUTION
  MESSAGE
• __________________ ___________ ___ ____
  _____________________ ____________________________
  __________________________________________
• WADE, ANDREW W 01 1
  1010115203AD00 PS901I0002Combination of
  Program Index/Organization Index is invalid
• WAITE, DAVID R 01 1
  1010112511XX00 PS901I0004Subobject must
  be on the SUBOBJECT TABLE
• WALKER, SCOTT G 01 1
  1491012520AE04 PS901I0001Combination of
  Appr Indx/Prg Indx OR Appr Indx is invalid
• 
  PS901I0002Combination of Program
  Index/Organization Index is invalid
• WILLIAMS, LINDA 01 1
  8880616201AK55 PS901I0001Combination of
  Appr Indx/Prg Indx OR Appr Indx is invalid

21
PS1245 Payroll Expense EFT Summary

• Summarizes and totals gross payroll and employer
  costs by fund to be EFTd to system payroll
  account
• Provides deposit information for colleges local
  bank accounts for vendor liability

22

• WED, FEB 4, 2009, 711 PM
  
  PAGE 1
• NN
  SAMPLE COMM COLL
  REPORT PS1245
• PAYROLL SCHEDULE 01B
  EXPENSE DISTRIBUTION
  VER007
• PAY PERIOD END 01/31/09
  PAYROLL EXPENSE EFT SUMMARY
• CHECK DATE 02/10/09
• PAY CYCLES S1 S2 S3
• 
  --------------------------- EMPLOYER COSTS
  ---------------------------
• GROSS
  MEDICAL
  INDUSTRIAL TOTAL
• FUND TITLE PAYROLL
  OASI RETIREMENT AID
  INSURANCE HEALTH
• ____ ____________________ ______________
  _____________ _____________ ____________
  ____________ ____________ ______________
• 001 STATE GENERAL 527,506.70
  39,166.14 44,672.79 1,873.27
  2,837.44 2,244.00- 613,812.34
• 057 ST BLDG CONSTR ACCT 2,193.00
  164.75 219.30 8.45
  12.80 .00 2,598.30
• TOTAL STATE FUNDS 529,699.70
  39,330.89 44,892.09 1,881.72
  2,850.24 2,244.00- 616,410.64
• 145 GRANTSCONTRACTS 69,064.87
  5,263.52 2,324.63 117.21
  177.49 .00 76,947.72
• 148 DEDICATED LOCAL 25,570.73
  1,929.18 1,808.49 104.12
  157.50 .00 29,570.02

23
PS1410 FMS Payroll Reconciliation

• Summarizes EFT activity
• Identifies funds transferred from/to prepaid
  account
• The job also creates the detail FMS accounting
  entries for
• Recording the EFT generation
• Expensing the payroll to proper budgets
• Recording vendor liability payment entries

24

• WED, FEB 4, 2009, 722 PM
  
  PAGE 1
• NN
  SAMPLE COMM COLLEGE
  REPORT PS1410
• PAYROLL SCHEDULE 01B
  EXPENSE DISTRIBUTION
  VER037
• PAY PERIOD END 01/31/09
  FMS PAYROLL RECONCILIATION
• CHECK DATE 02/10/09
• PAY CYCLES S1 S2 S3
• HOST INSTITUTION PAYROLL ACCOUNT
• STATE FUNDS EFT FROM TREASURER
  616,410.64
• LOCAL FUNDS EFT FROM DISTRICT
  399,467.98
• TOTAL
  1,015,878.62
• LESS TOTAL NET PAY
  589,229.90
• EFT DEPOSIT TO DISTRICT CLEARING ACCOUNT
  426,648.72
• DISTRICT PAYROLL ACCOUNTS
• EXPENDITURES/ACCRUAL SUMMARY
• STATE FUNDS EXPENSED
• GROSS PAY
  529,699.70
• EMPLOYER COSTS
  86,710.94
• TOTAL
  616,410.64
• LOCAL FUNDS EXPENSED

25
PS1420, PS1421 or PS1422 Expense Distribution
Reports

• Provides record of expenses to each budget
• PS1420 runs in payrolls
• PS1421 runs monthly after last payroll and before
  FMS month end
• PS1422 is on-request for a user specified
  timeframe
• Multiple sorts or summaries
• PS1420/1/2D useful in monitoring payroll
  expenditures to program level and staff months by
  employee type
• PS1420/1/2H only prints if parameter 1014 is a
  summary option

26
PS1420 Sequence Codes

• 05 Check Cancellation
• 10 Overpayment Adjustment
• 15 Handdrawn Check
• 20 Current Payment
• 30 Expense Distribution

27

• THU, FEB 5, 2009, 713 PM
  
  PAGE 2
• 
  NN SAMPLE COMM COLL
  REPORT PS1421A
• PAYROLL SCHEDULE
  EXPENSE DISTRIBUTION
  VER009
• PAY PERIOD END
  EXPENSE DISTRIBUTION REPORT
• ACCT. PERIOD 01/09
• EMPLOYEE ACCOUNT
  SEQ STAFF
  MEDICAL INDUST HEALTH
• ID EMPLOYEE NAME DISTRIBUTION
  CODE MONTHS GROSS PAY OASI
  RETIREMENT AID INSUR INSUR
• _________ ___________________ ___________________
  __ ____ ______ ____________ ___________
  ___________ _________ _________ __________
• BECK, KATHY L 101-011-2302-AE-1D-
  20 0.94 3,960.08 293.37
  297.00 16.91 25.60 561.00
• SCHMIDT, JAMES C 101-011-2302-AE-1F-
  20 0.62 3,336.48 245.58
  249.86 11.26 17.04 373.63
• DOLMANS, JERRY C 101-011-2302-AE-22-
  20 0.62 3,081.80 226.53
  230.80 11.25 17.02 373.07
• JOHNSON, DAVD D 101-011-2302-AE-26-
  20 0.62 3,701.46 273.92
  369.60 11.26 17.04 373.63
• SMART, JASON 101-011-2302-AE-2K-
  20 0.62 3,086.44 218.04
  231.48 11.28 17.08 374.19
• ALMAN, KEITH 101-011-2302-AE-59-
  20 0.62 2,641.38 195.67
  198.10 11.28 17.08 374.19
• TOTAL SUBOBJECT 101-011-2302-AE
  4.04 19,807.64 1,453.11
  1,576.84 73.24 110.86 2429.71
• SMART, JASON 101-011-2302-AS-2K-
  20 0.07 431.57 30.65
  0.00 0.00 0.00 0.00

28

• THU, FEB 5, 2009, 713 PM
  
  PAGE 1
• 
  NN SAMPLE COMM COLL
  REPORT PS1421B
• PAYROLL SCHEDULE
  EXPENSE DISTRIBUTION
  VER009
• PAY PERIOD END
  EXPENSE DISTRIBUTION REPORT
• ACCT. PERIOD 01/09
• 
  EMPLOYMENT AND PAYROLL SUMMARY REPORT
• 
  FOR SEQUENCE CODES 05, 15, 20
• 
  UNDUPLICATED
• SUBOBJECT
  HEADCOUNT GROSS
  PAY
• _________
  ____________
  ______________
• AA
  6
  55,600.29
• AB
  19
  120,693.12

29

• THU, FEB 5, 2009, 713 PM
  
  PAGE 1
• 
  NN SAMPLE COMM COLL
  REPORT PS1421C
• PAYROLL SCHEDULE
  EXPENSE DISTRIBUTION
  VER009
• PAY PERIOD END
  EXPENSE DISTRIBUTION REPORT
• ACCT PERIOD 01/09
• 
  FUND/PROGRAM/SUBOBJECT SUMMARY REPORT
• 
  FOR FUNDS 001, 145, 148, 149
• STAFF
  
  MEDICAL INDUST HEALTH
• FUND PROGRAM SUBOBJECT MONTHS
  GROSS PAY OASI RETIREMENT
  AID INSUR INSUR
• ____ _______ _________ __________
  ______________ _____________ _____________
  ___________ __________ ___________
• 001 011 AC 2.30
  12,941.42 982.69 1,166.95
  47.36 71.68 1,290.30
• 001 011 AD 0.29
  836.91 64.03 0.00
  5.48 8.58 0.00
• 001 011 AE 82.25
  446,631.69 32,897.82 40,175.41
  1,417.67 2,146.20 49,377.50
• 001 011 AH 0.00
  0.00 0.00 0.00
  0.00 0.00 1,683.00-
• 001 011 AK 10.34
  33,718.82 2,489.44 2,802.51
  168.89 255.57 6,344.05
• 001 011 AS 1.13
  9,018.80 665.67 0.00
  0.00 0.00 0.00

30

• THU, FEB 5, 2009, 713 PM
  
  PAGE 1
• 
  NN SAMPLE COMM COLL
  REPORT PS1421D
• PAYROLL SCHEDULE
  EXPENSE DISTRIBUTION
  VER009
• PAY PERIOD END
  EXPENSE DISTRIBUTION REPORT
• ACCT. PERIOD 01/09
• 
  PROGRAM/SUBOBJECT SUMMARY REPORT
• 
  FOR FUNDS 001, 145, 148, 149
• STAFF
  
  MEDICAL INDUST HEALTH
• PROGRAM SUBOBJECT MONTHS
  GROSS PAY OASI RETIREMENT
  AID INSUR INSUR
• _______ _________ __________
  ______________ _____________ _____________
  ___________ __________ ___________
• 011 AC 2.30
  12,941.42 982.69 1,166.95
  47.36 71.68 1,290.30
• 011 AD 5.24
  14,113.96 1,075.09 3.42
  98.67 154.04 561.00
• 011 AE 82.25
  446,631.69 32,897.82 40,175.41
  1,417.67 2,146.20 49,377.50
• 011 AH 112.07
  370,513.45 27,849.35 21,093.15
  697.59 1,055.54 30,766.65
• 011 AK 14.36
  38,745.42 2,867.29 3,220.14
  197.13 298.34 7,470.80
• 011 AM 0.92
  1,367.85 0.00 0.00
  17.21 26.94 0.00

31

• WED, FEB 4, 2009, 712 PM
  
  PAGE 1
• 
  NN SAMPLE COMM COLL
  REPORT PS1420E
• PAYROLL SCHEDULE 01B
  EXPENSE DISTRIBUTION PROCESS
  VER009
• PAY PERIOD END 01/31/09
  EXPENSE DISTRIBUTION
• ACCT. PERIOD 01/09
• 
  CAMPUS/FUND/PROGRAM/SUBOBJECT SUMMARY REPORT
  
• STAFF
  
  MEDICAL INDUST HEALTH
• CAMPUS FUND PROGRAM SUBOBJECT MONTHS
  GROSS PAY OASI RETIREMENT
  AID INSUR INSUR
• ______ ____ _______ _________ __________
  ______________ _____________ _____________
  ___________ __________ ___________
• 1 790 300 AH 0.00
  0.00 8.18- 8.18
  0.00 0.00 2,244.00
• TOTAL PROGRAM 0.00
  0.00 8.18- 8.18
  0.00 0.00 2,244.00
• TOTAL FUND 0.00
  0.00 8.18- 8.18
  0.00 0.00 2,244.00
• TOTAL CAMPUS 0.00
  0.00 8.18- 8.18
  0.00 0.00 2,244.00

32

• THU, FEB 5, 2009, 713 PM
  
  PAGE 1
• 
  NN SAMPLE COMM COLL
  REPORT PS1421F
• PAYROLL SCHEDULE
  EXPENSE DISTRIBUTION
  VER009
• PAY PERIOD END
  EXPENSE DISTRIBUTION REPORT
• ACCT. PERIOD 01/09
• 
  FUND/PROGRAM/SUBOBJECT SUMMARY REPORT
• STAFF
  
  MEDICAL INDUST HEALTH
• FUND PROGRAM SUBOBJECT MONTHS
  GROSS PAY OASI RETIREMENT
  AID INSUR INSUR
• ____ _______ _________ __________
  ______________ _____________ _____________
  ___________ __________ ___________
• 001 011 AC 2.30
  12,941.42 982.69 1,166.95
  47.36 71.68 1,290.30
• 001 011 AD 0.29
  836.91 64.03 0.00
  5.48 8.58 0.00
• 001 011 AE 82.25
  446,631.69 32,897.82 40,175.41
  1,417.67 2,146.20 49,377.50
• 001 011 AH 0.00
  0.00 0.00 0.00
  0.00 0.00 1,683.00-
• 001 011 AK 10.34
  33,718.82 2,489.44 2,802.51
  168.89 255.57 6,344.05
• 001 011 AS 1.13
  9,018.80 665.67 0.00
  0.00 0.00 0.00
• TOTAL PROGRAM 96.31
  503,147.64 37,099.65 44,144.87
  1,639.40 2,482.03 55,328.85

33

• WED, FEB 4, 2009, 712 PM
  
  PAGE 1
• 
  NN SAMPLE COMM COLL
  REPORT PS1420G
• PAYROLL SCHEDULE 01B
  EXPENSE DISTRIBUTION
  VER009
• PAY PERIOD END 01/31/09
  EXPENSE DISTRIBUTION REPORT
• ACCT. PERIOD 01/09
• 
  FUND/SUBOBJECT SUMMARY REPORT
• STAFF
  
  MEDICAL INDUST HEALTH
• FUND SUBOBJECT MONTHS
  GROSS PAY OASI RETIREMENT
  AID INSUR INSUR
• ____ _________ __________
  ______________ _____________ _____________
  ___________ __________ ___________
• 001 AA 2.75
  26,109.06 1,975.57 2,610.51
  46.41 70.28 0.00
• 001 AB 7.50
  48,938.39 3,684.23 4,293.34
  126.75 192.00 0.00
• 001 AC 9.92
  46,550.58 3,489.50 3,513.71
  167.60 253.84 561.00-
• 001 AE 43.93
  235,900.52 17,404.08 21,073.90
  746.48 1,130.77 0.00
• 001 AH 0.00
  0.00 0.00 0.00
  0.00 0.00 1,683.00-
• 001 AK 43.47
  145,304.13 10,779.08 12,069.47
  724.65 1,097.60 0.00
• 001 AS 1.56
  11,419.15 844.34 0.00
  0.00 0.00 0.00

34

• WED, FEB 11, 2009, 933 AM
  
  PAGE 2
• 
  NN SAMPLE COMM COLL
  REPORT PS1421H
• PAYROLL SCHEDULE
  EXPENSE DISTRIBUTION
  VER009
• PAY PERIOD END
  EXPENSE DISTRIBUTION SUMMARIZED BENEFITS REPORT
• ACCT. PERIOD 04/08
• EMPLOYEE ACCOUNT
  SEQ STAFF TOTAL
• ID EMPLOYEE NAME DISTRIBUTION
  CODE MONTHS GROSS PAY EMPLOYER
  COSTS
• _________ ___________________ ___________________
  __ ____ ______ _____________
  _____________
• BECKER, JILL L 101-011-1850-AH-00-
  20 0.33 976.68
  78.22
• CHILDRES, DONALD J 101-011-1850-AH-00-
  20 0.57 1,709.16
  136.87
• COHN, TRAVIS D 101-011-1850-AH-00-
  20 0.24 732.50
  58.67
• HENDERSON, PETER 101-011-1850-AH-00-
  20 0.57 1,709.16
  136.87
• KELMER, KATHLEEN M 101-011-1850-AH-00-
  20 0.57 1,709.16
  265.06
• LAREBEE, DOUGLAS 101-011-1850-AH-00-
  20 0.47 1,416.16
  117.26
• MOSHBARGER, JANE A 101-011-1850-AH-00-
  20 0.20 585.99
  46.92
• MORTON, JULIE S 101-011-1850-AH-00-
  20 0.23 731.50
  113.38

35
PS1425 Vendor Payment Liability Report

• Creates a report by
• Payment method
• Date
• Vendor
• Generated every payroll
• Sections based on Payment Method
• Transfers to BM3105 - Pending Payment Report
• Excludes individual employee TIAA-CREF negative
  EFTs

36
PS1425 (Cont)

• Normally PS1425 will equal total amount EFTd
  from PS1245
• Exception involves prepaid amounts
• Prepaid amounts go into liability account
• Added to vendor liability when sent to vendor
• Need to add prepaid amounts to total funds
  deposited to district account on PS1245 so it
  will equal the district total on the PS1425

37

• WED, FEB 4, 2009, 722 PM
  
  PAGE 1
• 
  NN SAMPLE COMM COLLEGE
  REPORT PS1425
• PAYROLL SCHEDULE 01B
  EXPENSE DISTRIBUTION
  VER014
• PAY PERIOD END 01/31/09
  VENDOR PAYMENT LIABILITY REPORT
• CHECK DATE 02/10/09
• PAY CYCLES S1 S2 S3
  FMS VENDOR CHECKS
• 
  VNDR DED
• VENDOR DED
  PYMT ACCT PAYMENT
  TRNS
• NUMBER PAYEE CD
  TITLE SCHD METH DATE AMOUNT
  ACCOUNT CODE RVRS
• _________ ___________________________ ___
  ________________ ____ _____ _________
  ____________ ______________________________
  ____
• 10 COLLEGE PARKING 414
  PARKING M 1 02/10/09
  830.28 801-790-300-0094- - - - R
• VENDOR TOTAL
  830.28
• 618 CANCER CARE 076 CANCER
  CARE DED M 1 02/10/09 150.17
  801-790-300-0078- - - - R
• VENDOR TOTAL
  150.17

38

• WED, FEB 4, 2009, 722 PM
  
  PAGE 3
• 
  NN SAMPLE COMM COLLEGE
  REPORT PS1425
• PAYROLL SCHEDULE 01B
  EXPENSE DISTRIBUTION
  VER014
• PAY PERIOD END 01/31/09
  VENDOR PAYMENT LIABILITY REPORT
• CHECK DATE 02/10/09
• PAY CYCLES S1 S2 S3
  FMS JOURNAL ENTRIES
• 
  VNDR DED
• VENDOR DED
  PYMT ACCT PAYMENT
  TRNS
• NUMBER PAYEE CD
  TITLE SCHD METH DATE AMOUNT
  ACCOUNT CODE RVRS
• _________ ___________________________ ___
  ________________ ____ _____ _________
  ____________ ______________________________
  ____
• HNDDRWN PAYBACK 200
  HNDDRWN PAYBACK I 2 02/10/09
  1,574.12 064-790-300-0130- - -0499-
• VENDOR TOTAL
  1,574.12
• 1000 KEY BANK OF WASHINGTON 023 ADD'L
  FED TAX I 2 02/10/09 4,998.97
  801-790-300-0031- - - -
• 022 FED
  W/H TAX I 2 02/10/09 88,598.29
  801-790-300-0022- - - -

39

• WED, FEB 4, 2009, 722 PM
  
  PAGE 6
• 
  NN SAMPLE COMM COLLEGE
  REPORT PS1425
• PAYROLL SCHEDULE 01B
  EXPENSE DISTRIBUTION
  VER014
• PAY PERIOD END 01/31/09
  VENDOR PAYMENT LIABILITY REPORT
• CHECK DATE 02/10/09
• PAY CYCLES S1 S2 S3
  ELECTRONIC FUND TRANSFERES
• 
  VNDR DED
• VENDOR DED
  PYMT ACCT PAYMENT
  TRNS
• NUMBER PAYEE CD
  TITLE SCHD METH DATE AMOUNT
  ACCOUNT CODE RVRS
• _________ ___________________________ ___
  ________________ ____ _____ _________
  ____________ ______________________________
  ____
• 30010 TIAA/CREF 003
  TIAA/CREF CON S 3 02/11/09
  44,566.33 801-790-300-0005- - - - R
• 30010 TIAA/CREF 001
  TIAA/CREF BAS R S 3 02/11/09
  44,566.33 801-790-300-0004- - - - R
• VENDOR TOTAL
  89,132.66
• 30015 SRA/TIAA/CREF 108 SRA
  TIA/CREF RE S 3 02/11/09 1,126.09
  801-790-300-0009- - - - R
• 101 SRA
  TIAA/CREF S 3 02/11/09 10,333.31
  801-790-300-0009- - - - R

40
Central Payroll Bank Account
030 Colleges Bank Account
020 Colleges Bank Account
010 Colleges Bank Account
3. Total Vendor Payments (Total Gross Payroll
Amount Employer Costs - Total Net Pay) are
deposited back into the colleges bank account
(effective on the check date 1 banking date).
Central Payroll Account (US Bank)
1. Total Local Funds for the payroll are
transferred from the colleges bank account to
the central payroll bank account on the check
date.
030 Colleges Bank Account
020 Colleges Bank Account
010 Colleges Bank Account
2. The total State Funds for the payroll are
manually EFTed from the State Treasurer into the
central payroll account (the person reconciling
the payroll initiates this process). At this
point in time, 100 of the dollars to cover the
payroll are in the central payroll account.
010 thru 357 State Funds (from State Treasurer)
Vendor Checks EFT Vendor Payments
From PS1245 DEPOSIT INFORMATION 1.
TOTAL STATE FUNDS DEPOSITED TO PAYROLL ACCOUNT -
ON CHECK DATE..... 616,410.64 2
2. TOTAL LOCAL FUNDS DEPOSTIED TO PAYROLL
ACCOUNT - ON CHECK DATE..... 399,467.98
1 3. TOTAL ALL FUNDS DEPOSITED TO
PAYROLL ACCOUNT...................................
....... 1,015,878.62 TOTAL NET
PAY............................................
590,804.02 LESS HANDDRAWN
CHECKS.................... 1,574.12
PLUS OVERPAYMENTS............................
.. 0.00 ADJUSTED TOTAL
NET PAY....................... 589,229.90
4. LESS ADJUSTED TOTAL NET PAY
WRITTEN...........................................
.................... 589,229.90 5.
TOTAL FUNDS DEPOSITED TO DISTRICTS ACCOUNT -
CHECK DATE 1 BANK DAY 426,648.72
3 6. DISTRICT CASH NET EFFECT (5 -
2)................................................
............................. 27,180.74
From PS1425 VENDOR TOTAL

2,028.99 DATE TOTAL

153,936.55 PAYMENT TOTAL

182,953.04 DISTRICT TOTAL

426,648.72 3
41
Questions?