How to setup salary employees so we can capture all hours for billing purpose but report only equal or below 40 hours for Job cost?

SUGGESTED

Hello Sage City bloggers,

How can we setup salary employees so we can capture all hours for billing purpose but report only equal to or below 40 hours to process payroll and for JC?

Our Project Managers are all salary employees but several work well over the regular 40 hours every week, we bill our clients by the hour with a hourly billable rate.  

We capture all the hours with hh2 but when we import the file we have to manually separate all hours over 40 so payroll and JC don't get messed up.

I would appreciate any help, input.

Thank you.

  • 0
    SUGGESTED

    If you only want to track the hours in job cost/payroll without adjusting the cost,we use a simple solution.  Each pay period, once our salaried payroll has been processed in payroll, but not posted, we go into "change unposted time entries", and change the number of hours worked each day form the standard 8 to the actual hours worked.  This keeps track of total hours, both in payroll and job cost, without changing the salary earned or costs.  Don't know how many Project Managers you have, which would affect the amount of time and effort needed to do this, but we do run our salaried individuals in a separate payroll group as the first step of preparing our weekly payroll.  Once we have processed those, we immediately make the change to the unposted hours on this group and reprocess, before beginning our entry of regular or non-salary wages.   At the end of the payroll preparation, we reprocess once more, and then post.  All costs and hours then are posted through accurately.

  • I am a consultant and I have done this for other clients. If you would like me to help you automate this you can contact me on [email protected]

  • 0

    Verify your Prorate auto pays settings:

    1. In Payroll, from the File menu, select Company Settings , PR Settings.
    2. Select the Job/Equipment Info check box. Click OK.

    Enter the units for each job in Enter Checks and process.

    1. From the Tasks menu, select Enter Checks.
    2. Click List, select a time entry view that allows you to enter job information, and then click OK.
    3. Enter the Employee ID, Period end date, and press the TAB key twice.
    4. Enter the Job ID and other earnings information on the salary pay line.
    5. Adjust the Units (hours) to reflect the actual number of units the employee worked on this job or cost code. Note: If Units appears before Pay ID, you may need to change the entry order in Tools , Customize Time Entry.
    6. Delete the salary pay amount that prefills in the Amount column and click Accept line.
    7. Repeat Steps d through f until all of the time is entered to the correct jobs, then verify that the total number of units is correct.
    8. Process the check. The salary automatically prorates across all the lines of time according to the number of units on each line. Select the link below for detailed steps on how to process in Enter Checks.
    9. Click Check Info, verify the check amounts are correct, and then click OK.
    10. Click Accept Check.
  • 0 in reply to sparker129

    Look up this knowlege base article

    - How do I split an auto salaried employee's pay between two or more jobs or cost codes on a job? (use Enter Checks to edit details and process the check)

    There are more notes in the article for you to read.

  • 0 in reply to sparker129

    These steps seem to work, but are overly burdensome when many job-site employees are salaried.  We have 50-60 salaried employees who split time between jobs. 

    Is there any way to keep the salaried amount from populating when the time entry is done through Tasks/Enter Time?

    Our process has a person who is not privy to pay rates entering hours/distribution information in a secured view of Enter Time.  When that is done, the total salary amount populates on each line.

    I've done some testing on altering the knowledge base process referenced above.  Essentially instead of using the Enter Checks and processing each employee individually, we use the Change Unposted Time to remove the salaried amount and then use the Process Payroll... to calculate the spread.  This is more efficient than altering individual employees through the Enter Checks when you have a bigger group who split time between jobs, but is still administratively burdensome.  I'd prefer to just not have the total salary amount pre-populate in each line item, so we just have to process.  Any way to get this to work?