Posting Labor to GL

When we post labor to GL do we have to break it out by every job and time and money?

Posting to direct labor to jobs

  • 0

    Michael,

    Your question is a bit brief and makes it difficult to discern the extent of your question.

    Sage 100 Contractor is a construction industry integrated accounting package, with significant job costing capabilities.  Hopefully that's why your company invested in it.  To properly reap the benefits of the package, one must enter time (and consequently money) to jobs as a part of the payroll process.  The actual posting of payroll to the GL is rather automatic and you should see that the resulting ledger transaction really doesn't break out by job. 

    If you are really referring to Non-Job hours, most users do not charge these hours to a job, but rather let the system charge the cost of non-job time to an Overhead or Administrative GL account.

  • 0 in reply to Walt Mathieson

    You are correct we were somewhat brief. The real question is, that we are using an outside payroll service. We create timecards each day, that way we can see unposted labor on our jobs. The real question is how best to post the labor to the GL, after all when entering time on a daily basis, we would not know the extent of overtime and related issues. We job cost everything, In the past we used in-house payroll. We have changed this due to some issues. I would like best practices on getting cost posted to GL when using a payroll service. Any assistance would be appreciated.

  • 0

    When we had outside payroll prep, we still entered the payroll exactly like we would if we were preparing the checks, using daily payroll entry. This way, our job costing reports were correct, our hours reports were correct and our books were updated with the payroll because we matched it with the outside payroll figures.

  • 0 in reply to Kathi from Santa Rita

    Please understand what I am asking. We enter payroll into Sage, full job cost with phases. We do this daily, so we can see up posted labor. My question is how to get these cost to post to GL. It would normally post when an in-house check is cut. As we are using a payroll service I would like to know the most efficient way to get payroll labor onto GL?

  • 0

    Post your entries AS IF you actually cut the check but instead of crediting Cash/Checking, you will credit A/P - Payroll service

  • 0 in reply to Michael Griggs

    The type of outside payroll service matters.  

    Is it a traditional payroll service bureau like ADP or Paychex, where the are assisting you with the preparation and payment of payroll and payroll taxes? In the traditional arrangement, you are the employer of record, checks are drawn on your account and you are always fully responsible for everything.  We basically do everything that you would do with internal payroll processing to gather all the time and job costing information, usually before you send the gross pay data to your payroll service.  Then, after the payroll service completes their work and sends you checks, direct deposit advices and reports, the real work begins.  You should match each and every item on the services payroll and you aren't finished until the net checks match exactly.  Its a pain, but its important.  With this process you may also be adding Employer Costs that the payroll service doesn't consider to ensure that your labor burden is fully loaded.  Then finish processing with a final compute and posting to the GL.

    Or is it a Professional Employer Organization (we used to call it employee leasing) where all of your employees are actually jointly employed by you and the PEO, payments are drawn on the account of the PEO, and the PEO just bills you for its costs and an administrative fee.  Frank Crum is one such PEO that I've come across.  In the traditional arrangement, you are the employer of record, checks are drawn on your account and you are always fully responsible for everything. With PEOs, I typically set up calculations that are unique to the process, focusing on employer costs for which the PEO will bill you. We also collect all time and job costing data in 5-2-2.  We send the gross pay data to the PEO, they prepare their payrolls and send you reports and an invoice.  Again, we will have to carefully match the results from the PEO before we are finished, and then we final compute and post to the GL.

    In each case, you are in for extra work.  Payroll services don't save time or money in my opinion. They are utterly incompetent at job costing.

    I am aware of only one application that can help with the process - PayDataLynx from Slimmer Software will take data that you've entered in 5-2-2 and send it to PayChex (maybe also ADP, I'm not sure) and then pull the finalized data from the service and poke it back into 5-2-2. 

    I strongly recommend that you consult a certified consultant to help with the setup and training.

  • 0 in reply to Walt Mathieson

    I am using ADP. This is not for any other reason other than liability. I understand the down side. We are totally job costing. How is the best manner in getting the costs to post to GL. This would normally post when we issue the check, but as we are not issuing a check, we input the hours into ADP. My question is the best practices in getting the payroll posted to GL? 

  • 0 in reply to Michael Griggs

    Best practices is to use your Sage Business Partner's Certified Consultant, who will show you how to mimic the service bureau's results in your 5-2-2 payroll records and then post them to the GL.

  • 0 in reply to Walt Mathieson

    Clearly you MISUNDERSTAND what I am asking Mr. Consultant. I already am MIMICKING the right costs. It is the SPECIFIC steps POSTING the cost and in what manner. My new bookkeeper is having difficulty. 

  • 0

    Aloha Michael!  I believe many of the posts are trying to answer your question and help you.  As several of the posts have indicated, you can get the best of BOTH worlds (entering time into Sage 100 Contractor, getting accurate, FULLY burdened job costs in the job history files (unless you final compute a payroll, the costs in various job cost reports you're looking at will be picking up the gross payroll and whatever payroll burden you chose to temporarily add on), AND accurately post to the G/L (payroll won't post to G/L unless you have final computed)  There is a different method to setting up the payroll calculations that can accomplish this without having to "force a match" to net to what the payroll service may calculate for each individual check.  It is quite a different setup and procedures that many Certified Consultants know how to do for you.  I'd check with your local consultant to see if they understand this method.  OR, if you are a member of TUG (The Users Group for Sage 100 Contractor, Sage 300 Construction & Real Estate and Sage Estimating), I wrote an article a couple of years ago on how to do this.  If you do not want to set up payroll in this method, then suggest you enter a Journal Transaction (1-3) to post the payroll costs to the appropriate G/L accounts.