What is PXACALC?
Contents
1. SUNGARD SUMMIT 2007 sungardsummit com Benefits Made Easy by PXACALC Hector de Zayas Senior Functional Consultant Banner HR Payroll March 22 2007 Course ID 895 bl SUNGARD HIGHER EDUCATION E Session Rules of Etiguette Please turn off your cell phone pager If you must leave the session early please do soas discreetly as possible Please avoid side conversation during the session If you consume any beverages during the session you must have enough for everyone present This includes the presenters Please feel free to share any gambling tips you have with the class If we lose we will find you J a n y Session Ojbectives e Gain a functional understanding of the PXACALC form When Why and How Review examples of how PXACALC has been used to solve real client deduction issues and e Discuss your questions on how you might use PXACALC to solve your benefit deduction calculation issues a What is PXACALC e Tax Rule Form developed for custom tax calculations not delivered or supported by baseline Banner e Although it s a tax rule form its uses are not limited to tax calculations e Supported by other rule forms such as PXATXCD and PTRBDCA Can use current or annualized applicable gross income as the start point for calculations a The When and Why Consider Using PXACALC When Delivered PTRBDCA calc rules won t work for your benefit deduction Y2. Use as few or as many as you need for that step e The R operator moves the running total to the employer contribution Employer contributions are NOT affected by calculation steps Use this to your advantage e Know what result you expect from each calculation step Test steps one at a time and make Sure its correct before you proceed J a SUNGARD SUMMIT 2007 sungardsummit com Client Examples _ SUNGARD HIGHER EDUCATION A Unique Retirement Plan Plan Specifications 1 Only 2 eligible earn codes for applicable gross 2 Contributions based on actual earnings not salary 3 Employee contribution is 5 of applicable gross 4 Employer contribution calculated as follows e 6 of eligible earnings up to an amount equal to half of the Client median salary plus e 11 of eligible earnings exceeding half of the Client median salary 5 No eligible employees with a salary that was below the half of median pay figure 6 Grandfathered plan no new members entering 8 a Pre PXACALC Set Up e Set up tax code in PXATXCD Tax Code GRP Description Granfathered Retirement Plan Tax Type Other State Prov Null Starting Point Current Annualization Method None Supplemental Percent Null 1099 R Indicator None Set up PTRBDCA Amount 2 set up as required entry to accept value for 1 24 of 50 of Client median income A PTRBDCA Values Field Name
3. Value Benefit Deduction Code GRP GRP Grandfathered Retirement Plan 20 or any desired pre tax priority 18 Retirement Tax Code GRP 1099 R Code NULL Calc Rule 60 Taxes amp Can Pens UIC Exclude from Overload Jobs Checked as per client Arrears Method Partial or as desired by client Year to Date Start Month 1 Indicator Continue Employer Checked as per client Contribution While on Leave with Benefits Deduction Contribution Pay periods 1 and 2 checked all others un Frequency checked Course ID 895 More Pre Calc Set Up e Added GRP BDCA code to appropriate benefit categories in PIRBCAT Quick set up option manual with user specified begin and end dates Benefit Deduction begin and end dates as required Set up default for Amount 2 with value for 1 24 of 50 of median income The value for Amount 2 is calculated by the client and updated annually J a PXACALC Solution 1 NULL S 0 NULL Pullincurrentearnings X 2 D 2 NULL Subtract PDADEDN Amount2 3 gt NULL NULL 1 Multiply remainder by 11 a ie ning tit 5 NULL D 2 NULL PullinPDADEDNAmount2 6 gt NULL NULL 06 Multiply by 6 8 R NULL NULL NULL Shift result to employer amount 9 NULL NULL 0 Clearemployee amount 10 NULL S 0 NULL Pullincurrentearnings NOTE All Range High amp Ran
4. ax Code and Description Tax Type other for deductions that are not taxes e State Province if applicable Starting Point this will be the default starting point for your PXACALC running total Annualization Method if starting point Is annualized Supplemental Percent if any e 1099 R indicator if applicable J 0 6 Next define a Deduction in PTRBDCA hia Urale Beveloper Porma Runtime Web Open gt FITRA File Edit Options Block tem Record Query Tools Help QD seh SOR A Zima ei Sif E Ta denga and SHUTS Flees FIRBDOLA oF e Remember to use 60 neroste ces e 7 as your calc rule im even if you are not ee Ge x eee setting upa tax Calculation Information deduction Also be em sure to fill in the Tax Saw es Code you just esi Bibir tetris iw ai nt created in the Tax Deduction or Contribution Frequency Code field _ i Description Calculation Rule 60 Taxes amp Can Pans UIC Exclude from Overload Job Arrearage Method 3 Tu 3 Pay Penrod 5 Deduct inobcator Record 1 J a 7 Now add your deduction to the appropriate benefit categories in PTRBCAT ev clip arm Runbin Web Ope File Edit Qobons Block Item Record Query Tools Help QD 8488 9 BOS ha Bus ieioix Benefit category Fi Category Description Full Time Employees Flex Amount Valid Benefits or Deductions For Benefit Category Ben
5. ed as part of the calculation e Range Low Minimum allowable value resulting from the calculation e Range High Maximum allowable value resulting from the calculation e Comment Brief description of what the step does free form J a The Graduated Tax Table Ble Edit Qpbons Block Item Record Que ery To ols Heip COMET ess CITI i Si wwe Sie iO x axCode ere Granfst ered Retremenet Plan tow Income i lt lt Bp mem This area can be used to take Calculation Step the result of Step Operator Operand Type Amount Range Low Range High Comment Ei D FI I Subtract POADEDN Amount 2 a J ff EBES E Ss the previous PE E oma Ee step find Di i DEE a where that result falls in the table and comp ute a H result based on the values in the table SE e aaa Record ato i 2 SS 5 a Graduated Table Example Graduated Tax Table Over Not Over Amount Plus Percent Over hi 33 975 00 Ani BOBO no 99 975 00 86 752 00 4 085 00 9 150 00 bb 752 00 999 499 999 99 2 476 00 11 160 00 This example from the User Manual shows how a tax table might be used The sample instructs the calculation to take the running total and apply it to the table The result becomes the new running total Some Points To Remember e None of the calculation step fields are mandatory when you start a line
6. efit ar Required Sequence Defaults Deduction Indicate ber Exist a GRP 2 ae j gt ALTUL TA HF BenefivDeducban Cade Press LIST for valid codes Racord 1 1 _ Ustofvalu lt 08 gt Don t forget your quick set up rules and to use defaults whenever possible Make things simple for the data entry team J a The Main Event Once you ve completed all of the pre calc set Up you can now proceed to complete PXACALC But first some basics you Il need to know a Course ID 895 PXACALC Basic Points e The calculation works on the running total concept Each calculation step affects the running total Your start point is step 0 Remember that you defined the start point when you set up PXATXCD e The running total calculates employee contributions Employer contributions are not affected by your calculations More on this later Key Block Fill in the name of E eat Gren Sa ten ear the Tax Code you dealing with a tax that has filing statuses select the filing status Peer your calculating sia EN S ow and Start Point are display only fields Move to the next block Aa Gor www Calculation Step Block track Crevelopri s Runtime Web Gen gt KADALC Fila Edit pbons Block Item Record Query Tools Hep OI RI LITI CEER S121 x 3 Tax Code GRP Filing Status Pe Gran
7. fathered Petremenet Plan Low income Tartimekaint CUP CURRENT This block is the heart of the form and is where your running total will be calculated Step Operator Operand Type Arnout Range Low Range High Comment Fi La ts IG iz Subtract POADEDN Amount 2 bautllnis remainder byat ply rema ndar by 11 Clear running total ear running total ME an T TA 1100 il so 5 PA Jade PDADEDM Amount 0 Multiply by 6 Graduated Tae ade a TT Over Not Over And unt Plus Percent Over O60 MSI BIL NAN il ena Cammeni FK Record AD Tesuseipsos 0 Field Definitions e Operator Code used to define the action to be taken on the running total Adds to running total Subtracts from running total Multiplies running total Divides running total R Moves running total to employer amount e QOperand and Type Used in combination to specify the value on which the operator action will be taken a Course ID 895 16 Operand and Type Definitions A Annualized Tax x Current Tax Aiea A list of Amount 1 2 3 type oo er or 4 from codes will ana PDADEDN appear in ae Hours Worked Applicable help Hours Option Option 1 5 from 1 5 PDADEDN Running total Step Number from step a Course ID 895 Other Field Definitions e Amount Specifies an amount to be us
8. ge Low fields are NULL No Graduated Tax Tables Step 1 was later removed in the final application of the solution Course ID 895 Reguired Client Maintenance e Client updates 50 of median salary figure annually and computes 1 24 Default Benefit Deductions value in PTRBCAT updated with new figure e DEDN record for Amount 2 updated with new figure for all employees with benefit assigned This effective dated record can be input manually in this example the client only had 78 employees with the deduction or can be updated via SQL script e In this case we recommended manual updating of the DEDN record as client has at least 2 effective dates for the median salary change and has a minimal number of employees eligible for this benefit a Thoughts for This Solution e Normal maintenance does not ever require touching PXACALC if the plan parameters remain the same e Maintenance is only required as median salary figure is updated e Since no eligible employees had salaries below the 50 median income figure graduated tables or range low and high figures were not necessary e Grandfathered benefit unlikely to change no new eligible employees J a Points to Go Home With Don t be afraid to use PXACALC It s a powerful tool to have in your toolbox Test your calculations step by step Don t wait until the end and then try and de bug Document everything you do Produce a document tel
9. ling what you did how you did it and how to maintain it e Prove your calculations back to the spec document examples Erra SUNGARD SUMMIT 2007 sungardsummit com _ SUNGARD HIGHER EDUCATION Thank You Hector de Zayas SunGard Higher Education hector de zayas sungardhe com Please complete the online class evaluation form Course ID 895 SunGard the SunGard logo Banner Campus Pipeline Luminis PowerCAMPUS Matrix and Plus are trademarks or registered trademarks of SunGard Data Systems Inc or its subsidiaries in the U S and other countries Third party names and marks referenced herein are trademarks or registered trademarks of their respective owners 2007 SunGard All rights reserved 8 OOOO
10. ou want an alternative to deduction chaining Local or other tax tables calculations are not delivered or maintained in baseline Banner and regulatory releases You need to set up a particularly imaginative benefit deduction a Course ID 895 SUNGARD SUMMIT 2007 sungardsummit com Laying the Groundwork e Work from a written spec document including sample calculations This is especially important if you are not the owner such as IT providing support for the Benefits area e Review your plan with the owner s Use real life calculation examples to test your work e Record what you do It will help you to prepare your documentation e Whenever possible develop in a recent copy of your Production database e Prove your calculations back to the examples fesem O O O 7 Before PXACALC Define a tax code in PXATXCD Rr Chr et fee Diana lee hari Bi nil Wake per m Pa Tp Eie Edit Options Block Item Record Query Tools Help k wi B sj a5 E 5 P amp in E j B j A z ik ri Tax Code pulas PYATSCD F o cool Le Tax Code Description The tax code you will be using must exist here before you start working in PXACALC TM il reff ICICI 4 IL l MI LI aku TU TT i IN l I al A E J aS 6 You will need to define the following in PXATXCD T
Download Pdf Manuals
Related Search