1 / 60

Cours e Title

Cours e Title. Advantage 3.9 HRM Payroll Accounting Management – HRM Configuration for the State of Colorado. Objectives. Session Objectives Understand how PAM works. Understand PAM data . Understand how PAM collects payroll details

milek
Download Presentation

Cours e Title

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CourseTitle Advantage 3.9 HRM Payroll Accounting Management – HRM Configuration for the State of Colorado

  2. Objectives • Session Objectives • Understand howPAMworks. • Understand PAMdata. • Understand how PAM collects payroll details • Understand howPAMretrievestheAccountinginformation for the payroll details. • Understand howPAMgeneratesJournalstoprocessthe payroll and accounting data. • Understand how PAM generates “virtual” Documents to preparethePAMdatatobemigratedtoFinancial.

  3. Session Agenda • PayrollAccounting Management (PAM) Overview • ThissessionprovidesanintroductiontothepurposeandfeaturesoftheAdvantageHRMPayrollAccountingManagement.Wewill: • ReviewtheAdvantageHRMPayroll AccountingManagementcomponentsanddatalifecycle • ReviewflowchartsthatoutlinebasicPayrollAccountingManagementsetup • PayrollAccounting Management (PAM)Overview • PAM Data • AccountingData Setup • PAM 1: PayrollCheck Processor • PAM 2: PayrollAccounting Document Generator

  4. HowPAM Works What is PAM? • PayrollAccountingManagement(PAM)isdesignedtosupportpayrollaccounting in ADVANTAGE Financial. • PAM • collects payroll details from ADVANTAGE HRM • creates “virtual” payroll accounting documents for them, • poststhese“virtual”documentstoADVANTAGEFinancial • ADVANTAGEFinancialthen uses these documents to • Debit and credit the relevantaccounts

  5. How PAM Works How does PAM work? PAMconsistsoftwojobs: PayrollCheckProcessor. This allows PAM to… • Processpaycheckdetailsaseither expense, liability, or fringe. • Create records for these details in journals. Document Generator. This allows PAM to • Process the payroll expense, liability, and fringe journal records. • Create“virtual”payrollaccounting documents for these records.

  6. PAM at State of Colorado

  7. Session Agenda • PayrollAccounting Management (PAM) Overview • Thissessionprovidesan overview of the payroll data that is picked up by Advantage HRM Payroll Accounting Management (PAM) • PayrollAccounting Management (PAM)Overview • PAM Data • AccountingData Setup • PAM 1: PayrollCheck Processor • PAM 2: PayrollAccounting Document Generator

  8. PAM Data PAM Data consists of: Payrolldetails, including… • Gross andNetPay • Deductions and Benefits • Fringe Accountinginformationfor those details, including • Fund • BSA • Etc…

  9. PAM Data • Where does Accounting Information come from? • FINANCIAL (CORE): • ChartofAccounts[COA]aredeterminedinCORE.ThisCOAallows CORE torecordalltransactionsusingindependentcharacteristicsfor themandincludetheminfinancialactivityreporting. • A transaction can relate to fund accounting, organizational concerns, cost accounting, or other accounting classifications. COA also consolidates financial details for reporting and budgeting. • HRM: • HRMretrievesthisCOAinformationfromasharedtableinthedatabase andallowstheusertoassignspecificAccountinginformationtopayroll details to regulate their posting in Financial.

  10. PAM Data • SCENARIO: • Trace accounting for one employee in monthly pay period 04/01/2014– 04/30/2014 (GTN Run Number 125): • Employee – John Doe, Employee ID AAA12345 • For this pay period, John received the following pay:

  11. PAM Data • SCENARIO: • Johnhad the following deductions and benefits:

  12. PAM Data • SCENARIO: • The following State of Colorado employer contributions were made for John:

  13. PAM Data • Pay Details forJohn for GTN Run Number 125:

  14. PAM Data • Deduction and Benefit details forJohn:

  15. PAM Data • State of Colorado Employer contribution forJohn: • Let us now see how PAM processes these details…

  16. Session Agenda • PayrollAccounting Management (PAM) Overview • Thissession provides an overview of the accounting data setup for the payroll data that is picked up by the Advantage HRM Payroll Accounting Management (PAM) module • PayrollAccounting Management (PAM)Overview • PAM Data • AccountingData Setup • PAM 1: PayrollCheck Processor • PAM 2: PayrollAccounting Document Generator

  17. Collecting Payroll Details AfterCPPS payroll data is loaded into Advantage HRM,thepayrolldetailsPAM needstoprocess will be loaded into the following tables: • C_PAY_CHECK • C_PAY_CHECK_EXT • C_PAY_DETL • C_PAY_DETL_EXT • C_DED_DETL • C_DED_DETL_EXT

  18. Collecting Accounting Details The COA details associated with each pay detail, based upon the profile/template defined in CPPS will be loaded onto the following table: • PEND_PAY_ACTG_HIST

  19. AccountingforPay • Accounting Details for John’s Pay:

  20. Collecting Accounting Details The PAM Payroll Check Processorjobwillnextlookforthe accountingdataforthedeductionandbenefitdetails. For Deductions and Benefits, PAM will retrieve accounting data from theDeductionorBenefitPlan. For a standarddeduction,youwouldfindthosedetailsonthe DeductionPlan(DPLN)pageforthededuction For a benefit,youwouldfindthosedetailsontheEmployee FringeBenefitPlan(BENP)pageforthebenefit. Fortheemployersideofabenefit,youwouldfindthose detailsontheEmployerFringeBenefitPlan(EFBP)pageforthebenefit. Note: DPLN, BENP, and EFBP haveanidenticalAccountinglayout

  21. Collecting Accounting Details • DPLN • External Deduction Plan • SOC – to be used for Net Pay only (no vendor payments to be generated from PAM) • Enter BSA and Direct Deposit BSA

  22. Collecting Accounting Details • DPLN • Internal Deduction Plan • Select Generate Payment Voucher flag to process deduction through PAM • Enter seller COA elements in Fund and Detail Accounting sections

  23. Collecting Accounting Details • BENP • Internal Employee Fringe Benefit Plan • Select Generate Payment Voucher flag to process deduction through PAM • Enter seller COA elements in Fund and Detail Accounting sections

  24. Collecting Accounting Details • EFBP Note: Deduction Type for each Plan • Internal Employer Fringe Benefit Plan • Select Generate Payment Voucher flag to process deduction through PAM • Enter seller COA elements in Fund and Detail Accounting sections

  25. Defining Fringe Pay Type for Employer Paid Benefits • EFBT • Internal Employer Fringe Benefit Type • Link pre-defined fringe pay type (EVNT) to Employer Fringe Benefit Type

  26. Collecting Accounting Details • AccountingdetailsontheDPLN/BENP/EFBParesetupinthefollowing sections: • PaymentVoucherInformation • Fund Accounting • Detail Accounting • Thesesectionsdeterminethepurposeandroutingofthededuction.

  27. Collecting Accounting Details Payment Voucher Information Section Thissectionallowsyoutodeterminewhatkindofdeductionthisis. • External (code = 1) • LiabilitiesOnly (code = 5)

  28. Collecting Accounting Details • 1. Payment Voucher Information Section • A. External deductions–Used for Net Pay and deductionsthatarepaidtoexternal vendors(latter not applicable to State of Colorado implementation) • Scenario:

  29. Collecting Accounting Details • 1. Payment Voucher Information Section • B.Internal deductions – these are for deductions that are paid to sources withintheorganization,andcanthereforebereferencedbyaCOA:

  30. Collecting Accounting Details • 1. Payment Voucher Information Section • ThissectionalsoallowsyoutodeterminewhetherornotaPaymentVoucher must be generated for this deduction. This is done by means of theGenerate Payment Voucher flag • Two basic functions: • Indicate whether ornot a Payment Voucheris to be automatically generated for an External deduction. • Indicate whether ornot an Internal deduction is to be processed by PAM. If the Generate Payment Voucher flag is unchecked for an Internaldeduction,the deduction will not be processed by PAM, and no document will be generated. • Note: Internal deductiongenerallyhas the Generate PaymentVoucher flag set to Y.

  31. Collecting Accounting Details • 1. Payment Voucher Information Section • Scenario:

  32. Session Agenda • PayrollAccounting Management (PAM) Overview • Thissession provides an overview of the PAM Check Processor job • PayrollAccounting Management (PAM)Overview • PAM Data • AccountingData Setup • PAM 1: PayrollCheck Processor • PAM 2: PayrollAccounting Document Generator

  33. Payroll Check Processor Payroll Check Processor: Based on the accounting details, processes paycheck details as either expense, liability, or fringe. Summarizesthe details. Creates records for the details in expense, liability, and fringejournals.

  34. Payroll Check Processor • BATRUN • Running the job:

  35. Payroll Check Processor • GTN Run Number associated with current payroll • Summarization Level (will be overriden by PAMSUMM settings) • Historical indicator – always set to ‘N’ for State of Colorado

  36. Payroll Check Processor BasedontheSummarizationlevel specified in the job parameters… 2= Fund+ Sub-Fund+Department …PAM will collect and assemble the payroll details based on this Summarizationlevel.PAMwillgenerateauniqueSummarizationkey forall payroll details that havesame GTN runnumber Pay Cycle PayrollDocumentLineType ID Fiscal Period,FiscalYear,BudgetFiscalYear COAelements [Fund,Sub-Fund,Department] DuringtheDocumentGenerationphaseofPAM,PAMwillgenerateaunique Document for each Summarization key.

  37. Payroll Check Processor • Scenario: ExpenseJournalEntriesfor John (PYRL_EXPS_JRNL)

  38. Payroll Check Processor • Scenario: LiabilityJournalEntriesfor John (PYRL_LIAB_JRNL)

  39. Payroll Check Processor • Scenario: LiabilityJournalEntriesfor John continued

  40. Payroll Check Processor • Scenario: FringeJournalEntriesfor John (PYRL_FRNG_JRNL)

  41. Payroll Check Processor • Scenario: FringeJournalEntriesfor John continued

  42. Payroll Check Processor • Scenario: FringeJournalEntriesfor John continued

  43. Payroll Check Processor AlternativemethodofSummarization… PAMSUMMARIZATIONBYDOCUMENTTYPE(PAMSUMM) PAMSUMM allows you to go beyond the4 levels of Summarizations in the Document Generator job parameters. YoucanspecifyANYcombinationof COA elements by which to summarize your documents. To use PAMSUMM, set the following SPAR to True: PYRL ACTGDOCSUMMARIZATIONLEVEL PAMSUMM also allows you to specify how to summarize the Accounting Lines oneachdocument.

  44. Payroll Check Processor • PAMSUMM

  45. Session Agenda • PayrollAccounting Management (PAM) Overview • Thissession provides an overview of the PAM Document Generator job • PayrollAccounting Management (PAM)Overview • PAM Data • AccountingData Setup • PAM 1: PayrollCheck Processor • PAM 2: PayrollAccounting Document Generator

  46. Payroll Accounting Document Generator Payroll Accounting Document Generator: PAMwillgenerateaunique“virtual”Documentfor eachjournalrecordwithauniqueSummarizationkey..Eachunique“virtual”DocumentwillhaveaseparateAccountingLineforeachrowofpayrolldetailsitsummarizes.DocumentX,with AccountingLines1,2,etc.

  47. Payroll Accounting Document Generator • BATRUN

  48. Payroll Accounting Document Generator

  49. Payroll Accounting Document Generator PAMgeneratesthepayrollaccountingdocumentsintwophases: A.TheExpenditureAccrual/Adjustmentphase.Duringthisphase,PAMaccruesexpendituresassociatedwithcurrentpayrolleventsand encumbersfundsrequiredtofulfilltheobligationsthatremainon employeecontractsafterthecurrentpayroll. Thisphaseproducesthefollowing“virtual”documents: Payroll Expenditure or PREXPdocuments

  50. Payroll Accounting Document Generator B.Duringthesecondphase,PAMmodifiesthe“virtual”documentstoreflectany changes made to documents adjusted during the Expenditure/Liability Processing Phase. This is done so that the documents accurately determine the cash expenditures and liabilities associated with the payroll. This is called the Expenditure/Liability Processing phase. The Expenditure/Liability Processing phaseproducesthefollowing“virtual” documents: Payroll Liabilityor PRLIAdocuments Payroll PaymentorPRLNPdocuments Payroll Internalor PRLIDdocuments

More Related