Author: mtimm

  • 10 most critical factors of SAP payroll

    small__8448095137SAP Payroll can be a complex and unwieldy system when not methodically implemented and maintained. The SAP Payroll business processes can be accurate and efficient when the 10 most critical factors are considered and understood by those implementing, maintaining, and performing business processes. When it comes to configuring, processing, and administering payroll, small details can have big ramifications.

    This 10 blog post series will dive into the most critical business, strategy, and technical topics every payroll professional must weigh carefully in order to avoid unnecessary costs and maximize efficiency. The posts will provide insight into the time, effort, and cost associated with each item, its impact on overall ROI, and where it falls within the overall payroll process.

    1. Data integrity
    2. Integration
    3. Configuration and customization
    4. HRSP and legal changes
    5. Unit and parallel testing
    6. Time management
    7. Tax reporting and auditing
    8. Troubleshooting
    9. Year-end processing
    10. Overpayments and claims

    Here at Integrated Consulting Group, we specialize in the design, development, and customization of SAP Human Capital Management business software for leading edge North American companies with global reach. Have any questions about SAP? Feel free to contact us via the contact page of our site, or on Twitter or LinkedIn.


    photo credit: StockMonkeys.com via photopin cc

  • Optimizing Payroll in SAP: Looking Back on the Philadelphia Seminar

    Optimizing_Payroll_in_SAP_October_07__2014_at_0358PMThe Philadelphia Seminar was a great time with vast amounts of information, detailed how-to’s with examples, and opinions provided by the speakers and attendees. The interaction between speakers and attendees helped to share knowledge and gain insight into how SAP functionality works for different SAP customers.

    As expected, BSI 10.0 was a much discussed topic as many users have struggled to get it installed and have reciprocity calculation issues. From the companies with attendees at the seminar, only one had gone live, and two will go live within the next couple of weeks. We’ve requested updates from these companies to see what things pop up and look forward to hearing about lessons learned.

    Most of the hot topics we typically hear about with SAP revolve around cloud and mobile, but these topics had very little interest in Philadelphia. Many attendees have SuccessFactors in their environment, love the user experience, and are focused on how to streamline in order to make their existing SAP payroll more efficient. After all, payroll is core, and employees don’t care if their payroll department uses a beautiful interface as long as their check is correct.

    It will be interesting to see how the discussion changes at the next seminar in Chicago. Since the Chicago seminar is in November, we’ll be near the deadline for the BSI 10.0 upgrade, so most companies will be live and (hopefully) have the kinks worked out. Year-end preparation will be well underway by most payroll departments and any struggles that come with that will be at the top of the discussion list at the seminar.

    We’d like to extend a big thank-you to Yu Chen, Jennifer Adams, Charolette Christy, Molly Folan, and all of our attendees!

    If you missed the Philadelphia Seminar, check out ICG’s Mike Timm and his recent podcast on SAPinsider regarding FICO integration and payroll year-end.

    On November 5, SAPinsider will host Mike Timm for a live online Q&A to discuss SAP Payroll Year-End. Make sure to join in and get your questions answered.

    Do you have any questions about Philadelphia’s seminar? Please drop us a comment or reach out to us on twitter: @MikeTimmSAP and @SAPinsiderHR. We’d love to hear from you!

  • Optimizing Payroll in SAP: Day 3

    Here’s a view of the sessions Mike Timm will be presenting tomorrow, Day 3 of Optimizing Payroll in SAP.

    Optimizing-Payroll-in-SAP_logo

     

     

     

    Field-tested strategies to avoid or overcome the most common and costly payroll and time-related challenges

    Mike Timm, Integrated Consulting Group

    This session tackles some of the most common payroll challenges and provides essential information every payroll professional can use to overcome them and streamline payroll processes and operations. Attendees will explore common payroll issues and come away with expert tips to more efficiently troubleshoot and resolve payroll errors when they occur, including lessons to:

    • Troubleshoot process models and properly reactivate them after an error, including whether and how to use enabling SAP tools
    • Manage common challenges associated with mergers and acquisitions (M&A) and get tips to accelerate the acceptance of a new payroll system
    • Overcome technical complexities associated with setting up and customizing schemas and rules
    • Leverage CATS and the time schema to more easily process complex time rules and avoid time-related discrepancies
    • Assess potential payroll data issues by running Tax Reporter in simulation mode and analyzing the error log
    • Identify the object master data, configuration, or systemic issue causing the payroll error, and determine the best approach for resolution


    photo credit: Wellesley Information Services, LLC via payrollseminar.wispubs.com

  • Optimizing Payroll in SAP: Day 2

    Here’s a view of the sessions Mike Timm will be presenting tomorrow, Day 2 of Optimizing Payroll in SAP.

    Optimizing-Payroll-in-SAP_logo

     

     

     

    This session provides configuration best practices, process decisions, and technical considerations for integrating SAP payroll with accounting (FI/CO) and benefits applications and processes. By attending this session, you will:

    • Examine the integration points between payroll and key accounting (FI/CO) applications like GL, treasury, cost accounting, and accounts payable, and come away with:
      • The best ways to optimize data flows and troubleshoot common errors
      • Payroll interface design techniques that help drive streamlined integration
      • Tips to reverse postings between payroll and accounting and set up a company transfer clearing account, and post taxes by tax authority
      • Configuration best practices to streamline third-party payment processing
    • Understand what’s required to process benefits in conjunction with payroll in SAP ERP HCM, including insight into:
      • Configuration and integration guidelines, including an overview of benefits wage types
      • Infotype dates and payroll schema for determining deduction start, end, and proration
      • How to handle health plans, insurance plans, and savings plans
      • Where payroll and benefits functionalities overlap in SAP ERP HCM

     

    Mike Timm, Integrated Consulting Group

    This session examines information and key factors essential in avoiding costly tax-related pitfalls, including a thorough review of US tax regulations and associated reporting and auditing requirements. By attending this session, you will:

    • Master tax configuration in SAP ERP HCM, including key tax models, types, and combinations
    • Obtain lessons to avoid potentially costly pitfalls associated with wage types and tax models, such as tweaking the existing model for deferred compensation
    • Get critical guidance to comply with state and federal tax regulations and auditing requirements
    • Explore how to use Tax Reporter to run multi-worksite, SUI, and W2s, including how to reconcile between Tax Reporter and payroll results
    • Get expert recommendations for managing and tracking BSI Tax Update Bulletin (TUBs), including how often you should install them and how to identify TUBs gaps
    • Examine the steps required to update to and properly leverage BSI TaxFactory 10.0, including an overview of new and enhanced functions in the latest version

     

    Mike Timm, Integrated Consulting Group

    Through detailed screenshots and system demos, this session provides critical guidance, based on real-world experience, for ensuring accurate and timely processing of overpayments, garnishments, retroactive calculations, and month-end accruals. By attending, you will:

    • Get guidelines to reconcile claims from a user, functional, and technical perspective, including the impact of IRS regulations related to claim processing and the different taxing rules that apply
    • Learn how to configure wage types to support claims forgiveness, repayment, and deduction recovery, including tips for dealing with claims that continue from one year to another
    • Understand how to manage the impact of overpayment recovery on taxes
    • Avoid common pitfalls associated with posting retroactive calculations and month-end accruals and learn how to automate month-end accruals and cost center overwrites
    • Get lessons to ensure the accuracy of garnishment configuration and administration, including tips to manage effective dates of garnishments and reports to track and monitor their activity

     

    All speakers

    In this no-holds-barred panel discussion, you set the agenda! Bring your most pressing questions around payroll, time, taxes, and more and get candid answers, recommendations, and advice from all three expert speakers based on their own experiences with clients. Don’t miss this unique opportunity to get your most critical questions answered by some of the world’s foremost authorities in SAP payroll.


    photo credit: Wellesley Information Services, LLC via payrollseminar.wispubs.com

  • Optimizing Payroll in SAP: Day 1

    Here’s a view of the session Mike Timm will be presenting tomorrow, Day 1 of Optimizing Payroll in SAP.

    Optimizing-Payroll-in-SAP_logo

     The 10 most critical factors that impact the accuracy and efficiency of SAP payroll

    When it comes to configuring, processing, and administering payroll, small details can have big ramifications. This session delves into the most critical business, strategy, and technical topics every payroll professional must weigh carefully in order to avoid unnecessary costs and maximize efficiency. By attending this session, attendees will:

    • Examine the role and impact of:
      1. Data integrity
      2. Integration
      3. Configuration and customization
      4. HRSP and legal changes
      5. Unit and parallel testing
      6. Time management
      7. Tax reporting and auditing
      8. Troubleshooting
      9. Year-end processing
      10. Overpayments and claims
    • Gain insight into the time, effort, and cost associated with each item, its impact on overall ROI, and where it falls within the overall payroll process


    photo credit: Wellesley Information Services, LLC via payrollseminar.wispubs.com

  • Tip: Put a Stop Sign on a transport

    To help prevent a transport from being released accidentally without your knowledge, start the description with @1D@

    When you look at the transport, you’ll see the following sign preceding the description of the transport.
    Stop Sign

  • SAP HCM Payroll tip: Preventing errors before they occur & using user exits to your advantage

    As part of the audit process, SAP customers develop a number of custom reports for the HR module to look for things like missing infotypes or specific items.

    Let’s look at some tax calculations – especially if you’re a company that has many, many tax jurisdictions. In the US, for example, if you’re a company in Pennsylvania or Ohio where employees move between areas and there are many locals. In these cases, you may not have the configuration set up for the right employer identification numbers. The employee can still enter that tax jurisdiction based on where they’re located, but when you’re running payroll, you’ll error out because the underlying configuration is missing for that tax jurisdication. So it’s great to have audit reports to identify situations where there are tax jurisdictions coming in from CATS (cross‑application timesheets) or in the employee infotypes that are not set in configuration. This gives you some ability to catch that on the front end.

    Then there are work location errors, where an employee – either via infotypes or from data coming in from the cross‑application timesheets or attendances – has a different work location than normal. Without the right setup, you’ll get an error when processing through payroll because configuration is not setup. We want to try to eliminate that, because depending on how your support structure is built, it might be a while before the configuration can be put in place to fix that employee record so you can continue on with your payroll activities.

    This is one error I especially like to find long before doing an audit report. At the infotype level or time entry level, when work location is entered we have a user exit built to check the configuration tables and validate that “Yes, Illinois is a state that we’re set up or generate a message that says Illinois is not a state that we’re set up.”

    There’s a couple different ways to approach that: If an employee is entering time and they select a tax jurisdiction that is not set up, you can give them a hard error. But you can also give them a warning. And while there are pros and cons to both, I like to set up the warning.

    It gives the employee an opportunity to report the warning message to the payroll department and typically provides enough time to add the configuration before running payroll. Also, it can ensure more accurate reporting. Erroring the employee out during time entry or infotypes, the employee is more likely to use shortcuts (“Well, I’ll just use something else to get by…”) and then you don’t get proper tax reporting.

    And these are all user exits. Infotypes like Infotype 207, 208, 209, and 210 can all be set up with user exits to validate that your configuration actually has these tax jurisdictions as available options.

    User exits also give you some flexibility, compared to removing all non-applicable jurisdictions from the dropdowns. If you clear all configuration not used as of today, you may have an issue in the future of having to setup the tax jurisdiction from scratch. User exits are dynamic, so with this approach, you can move into new tax jurisdictions as long as you do the configuration and there’s no change to user exits.

    Consier both audit reports and user exits when determine how best to reduce the number of issues you experience during your payroll processes.

    Read the ILN blog at Insider Learning Network | SAP HCM Payroll tip: Preventing errors before they occur & using user exits to your advantage

  • SAP HCM Payroll tip: Timing your payroll processing to prevent errors & give IT and HR some breathing room

    Typically, companies are running their payrolls on Monday or Tuesday so they can get a payroll out by the end of the week and make direct deposits in a timely manner.

    When dealing with that, typically audits should start at least a day or two prior. If it’s on Monday, by Friday you might want to start looking at some basic things:

    • Do I have all my audit reports?
    • Does everybody have a cost center?
    • Does every employee have an Infotype 9?

    Then, based on your report, you can set it up to find any exceptions that occurred over the weekend. On Monday morning, the report was already processed early in the morning, so when you arrive you can now review it and look for problems: “There’s a couple employees that were added over the weekend by HR, but the cost center is missing, so I need to get those addressed.”

    As part of a bigger audit check, you can actually run Time Evaluation and Payroll over the weekend before you arrive on Monday. Then you can have process models set up to automatically generate some of the documents or you can set up batch jobs that will run subsequent jobs.

    One of the clients I’ve been working with runs payroll on Monday. They started to look at options to get the process started earlier by using the weekend. They were all working until 10:00 or 11:00 on Monday night and that was taking a toll. So we started running time evaluation late Sunday and we set up  a standard SAP batch program to release the payroll and then start payroll. When everyone arrived on Monday, employees had been processed through time evaluation, payroll, payroll journals had been run along with other audit reports.

    They also gave HR a much larger window to go in and make HR master data fixes instead of the usual hour or an hour and a half.  HR now has the better part of the morning to tweak data and put in new hires.

    The best part of the automation was a reduction in the payroll department overtime and a more relaxed atmosphere. Error rates reduced signifantly because of the gained time and employee trust of their paycheck increased.

    Map out your payroll processes and look for areas that could be run earlier to get a head start on audits. The time will be well spent and payoff dividends in the long run.

    Read the ILN blog at Insider Learning Network | SAP HCM Payroll tip: Timing your payroll processing to prevent errors & give IT and HR some breathing room

  • SAP HCM Payroll tips – Audit Checks: Some key Infotypes not to overlook

    Of all the audit checks that you could perform, there are a couple that really are key – and critical to payroll success.

    In fact, I’m actually working with a client that’s recently gone live now. These audit checks were not put in place prior to go‑live, and now there’s a scramble to put them in.

    One of them is checking a report that will go out and check for missing infotypes. If an employee is missing certain infotypes when they get into running the payroll, they’ll bomb out.  For example, if you’ve had any experience with missing Infotype 9, which is the payment method, direct deposit or a check, you know that can cause some problems – especially when you discover this only after going through the entire process.

    For any infotype check, you have to identify which ones are important to your company. Once you verify that everybody has their infotype, you might even want to go in to look for specific fields. If you’ve created any custom infotypes or custom fields on existing infotypes that you need as part of your payroll process, your report can look for those specifics. I like to verify there are no employees missing a cost center using the Flexible Employee Data report, tcode S_AHR_61016362. Key date is set to Today and for Selection I set it to look for blank cost center in Infotype 0001.

    I also always like to check something very basic: Making sure that no employees are locked right before I run payroll. If you run your payroll late at night, you’re probably OK. But run it during the day on Monday or Tuesday, like a lot of companies do, and HR might lock an employee incorrectly, because they forgot that you’re running payroll. There’s a standard SAP report, tcode PC00_M44_UCPL, that you can run to avoid employees being locked.

    There are other reports or audits that you can run. You might want to check and see, for example, do you have Infotype 8s, basic pay, that have numbers or dollar amounts that don’t make any sense?

    If your employees are typically paid less than so many dollars per hour, show me any employees that are set up to have more than that. This way, you’ll be able to avoid the problem of employees who are set up as hourly, but were given  a salary rate – so then you’re paying them $200,000 or $300,000 in a weekly payroll.

    These — “Is everything there that I expect to be there? Is anybody locking the employee records? Do my employees make within a certain salary range?” — are just some of the basic checks that should clear up many errors you might encounter.

    Read the ILN blog at Insider Learning Network | SAP HCM Payroll tips – Audit Checks: Some key Infotypes not to overlook

  • SAP HCM payroll tip: BSI TaxFactory Batch Test Tool

    Since HCM relies on BSI TaxFactory for US payroll tax calculations, how do

    you handle verification and testing of BSI calculations in your payroll
    audits & testing? HCM teams may be unaware that BSI TaxFactory has a Batch
    Tool, which is my preferred method of testing BSI due to the easy of
    copying SAP information, manipulation of that information, and being able
    to save the scenarios for later use.

    When the time comes to apply TUBs, Cyclic, or upgrade to a newer version of BSI TaxFactory, we can reuse the files we’ve already created by changing the Check Date instead of having to locate and create all the data in SAP. This does not replace end user testing, but it does expedite unit testing in development environments where data is typically sparse and out of date.

    Getting started we need to get the information we want to use in the BSI TaxFactory Batch Test Tool. Find the employees you want to use as test scenarios in production or create the scenarios in a test environment. Once you have all the master data setup run your payroll as you would typically do, but make sure to select the Payroll Log check on the Payroll Driver (transaction codes PC00_M10_CALC or
    PC00_M10_CALC_SIMU) parameter screen.

    Once the payroll runs, follow the log path to the BSI Interface node. The BSI interface node detail provides you with the same information that is passed from SAP to BSI.  Tax calculations for the employee are performed on this data

    Gross cumulation and tax processing > ELSE > LPBEG > Run > Calculate Taxes > USTAX > Processing > BSI interface

    Push CTRL + Y to highlight the data and then CTRL + C to copy the data and paste directly in BSI TaxFactory Batch Test Tool. Make sure to get from the first line of ATC to the last line of ETC so BSI knows where the beginning and end are in the data. You should have something that looks similar to this, but with a complete data set.

    With this data you can manipulate the contents and save the different scenarios. Here are a few quick scenarios you can put together and save for current and future use.

    1. Change the CD (check date) to see how taxes calculate on a specific date in time.

    2. Change the tax authority next to the lines that start with ‘ADC TC:’

    3. Test reciprocity by copying lines that start with ‘ADC TC:’ through lines that start with ‘LUD PT:’ and change the tax authority.

    Once you have your scenario created, it is as simple as selecting the Run Test button and  you should receive output very quickly that displays the details you need to validate.

    If you want a method to quickly test BSI, using the Batch Test Tool is a good way to go. Scenarios can be created and reused with as little as changing the check date.

    Read the ILN blog at Insider Learning Network | SAP HCM payroll tip: BSI TaxFactory Batch Test Tool