General Inquiries

Sage 300 CRE / 3rd Party Payroll

  • 1.  Sage 300 CRE / 3rd Party Payroll

    Posted 03-28-2016 10:43

    We moved to Sage 300 a year and a half ago and have continued with ADP as our payroll provider.  As we continue to grow we are finding it difficult maintaining two sets of databases for payroll.  Does anyone know of a payroll provider that is more integrated with Sage?



    Bryan Gava


    Anchor Insulation

    Ph: 401-438-6720 x 118

    Mb: 508-922-2396

    Description: Anchor Logo



  • 2.  RE: Sage 300 CRE / 3rd Party Payroll

    Posted 03-28-2016 11:43


    ADP and Paychex both will import and export to Sage 300 CRE.  Both providers have the ability to export time by job and split taxes/fringes as needed.  You have to get to the right person in ADP or Paychex.  They can do it - then you wont have to maintain PR and ADP records unless you do certified jobs.  Hope that helps - if you have any questions feel free to email me. 

    William Kormoski
    President, Sage 300 CRE Consultant
    Kormoski & Associates LLC
    Mount Juliet TN
    (615) 351-4953

  • 3.  RE: Sage 300 CRE / 3rd Party Payroll

    Posted 03-29-2016 09:37
    Hello Bryan,

    We are considering working with ADP as 3rd party payroll provider, and have
    been told that they are easily able to import labor data (hours) from
    Quickbooks (and other accounting softwares) as an Excel file. ADP would
    import this information from your accounting software directly into its "pay
    data batch" to process payroll.

    I am still waiting for confirmation from them regarding this before we sign
    on with them, but we are told by our Quickbooks people that it should not be
    a problem as they working ADP for many of their customers.


    Parag Kapadia
    Assistant Controller

    T: 718.397.9527 x 103 | F: 718.779.6535
    C: 347.256.3782 | E:

    34-21 56th Street | Woodside, NY 11377

    Website | Brochure
    | vCard
    | Email>

    This message contains confidential information and is intended only for the
    recipient(s). If you are not the recipient you should not disseminate,
    distribute or copy this e-mail. Please notify the sender immediately by
    e-mail if you have received this e-mail by mistake and delete this e-mail
    from your system. E-mail transmission cannot be guaranteed to be secure or
    error-free as information could be intercepted, corrupted, lost, destroyed,
    arrive late or incomplete, or contain viruses. The sender therefore does not
    accept liability for any errors or omissions in the contents of this
    message, which arise as a result of e-mail transmission. If verification is
    required please request a hard-copy version.

  • 4.  RE: Sage 300 CRE / 3rd Party Payroll

    Posted 03-30-2016 06:56

    I would look into Paychex. I have used them before at another employer and we were able to enter all of our time in Sage PR and create a TXT file that could be imported into Paychex. This allowed all the information to be coded to jobs while having outside payroll provider take on the reporting requirements.


    John Jankowski | Controller | Sagamore

    Direct: (781) 682-0106

    75 Research Road, Hingham, Massachusetts 02043







    "Committed to Quality Workmanship, Customer Satisfaction as well as  Employee Growth"


  • 5.  RE: Sage 300 CRE / 3rd Party Payroll

    Posted 03-30-2016 08:24

    I agree with John.  We switched from doing payroll in house in September (using Sage 300) to Paychex and now have more flexibility uploading data and functionality with the HR component of how we deliver information to our people.

    Bud LaRosa CCIFP
    Tocci Building Corporation
    Woburn MA
    (781) 218-5640

  • 6.  RE: Sage 300 CRE / 3rd Party Payroll

    Posted 03-30-2016 10:36

    The coded to jobs part... that's the tricky one. We have tried to get all kinds of outsource payrolls to work with Sage 300 CRE for various clients. The closest to being able to get it done is ADP (Workforce Now platform with Time and Attendance add-on and - in OH and other tricky payroll states - Multi Jurisdiction add on)... but not really.  Of course they will tell you that they can "integrate". Trying to make a sale over here! 

    "Integrate" to them is a data dump to you.  You still need to code the time to a job. If you put the time into ADP with a code attached, that code is a custom field that doesn't come with the data dump on export (or it comes out with however many code fields you put in - mess). Its really about expectations.  An expectation that I can enter all my time into an outsource provider and that will populate my JC fields automatically is just not going to happen. There will be a manual intervention step - or many. It is best to consider for users who have mostly salary employees. Not saying it can't be done and other clients aren't doing it, but requires a lot of thought and planning.

    Couple ways it works best (not only):

    1) Continue collecting time in remote time piece, if applicable, to PR so it correlates with JC, and then send the data to ADP and make a GL entry when it comes back. 

    2) Collect the time in ADP. Put all your labor codes into the ADP time and attendance platform on setup. This doesn't require Office Connector, but makes it easier to have it to write that data back to PR. The PR Time Import (so it still makes sense with JC) from a formatted spread sheet. This requires a custom report/routine be written to transform the ADP format to the Sage format. Otherwise, you will need to format yourself. 

    3) Get Sage HRMS (direct CRE Payroll integration) with a consultant who knows what they are doing, a direct remote PR piece, MyAssistant, and tell employees you're going to direct deposit only. This is the long term most cost effective solution v any outsource provider. ROI/TCO.

    Everyone has a different situation and costs jobs differently.  The answer is "it depends". Hope this was helpful insight. Many client trial and errors. If you have other ways this has worked, I would like to hear about them!

    Tim Ryan
    Territory Manager
    Aktion Associates, Inc.
    Maumee OH
    (513) 988-3137

  • 7.  RE: Sage 300 CRE / 3rd Party Payroll

    Posted 11-20-2018 14:24
    Is an easy way to do accomplish payroll imports, 1.  create a JC direct cost import from the payroll provider software, and import into Sage 300 CRE. 2. create a GL import of the rest of the payroll transactions?

    For example, if I do not budget for number of hours on projects, only total labor costs:
    I have a payroll processor portal where employees enter time.  The specify date, hours, job and phase.
    They enter "Joe Harper", 11/15/2018, 4.00 hours, Job - xxx and Cost Code demo, at my rate ($10 per hour, $40 in total - W-2 wage only).  I get paid.
    From the payroll processor software, I create a direct cost entry for the W-2 rates of all projects.
    Joe Harper, $40 to Job xxx, cost code for demo.
    Jane Doe, $100 to Job xyz, cost code temporary electric.
    Sam Doe, $250 to Job zqx, cost code landscaping.

    So far $390 to direct job costs, the other side, from the general ledger perspective is cash.

    My GL entry (or import) from the payroll is:
    Admin payroll (expense) $500.
    Payroll taxes (expense) $90.
    Payroll processing fees $10
    401(k) withheld $20
    Health insurance withheld $10
    Entry is credit cash $570, credit 401(k) $20 liability and credit health insurance expense $10.
    The whole entry will be:
    Job Costs          $390
    Adm Payroll       $500
    Payroll Taxes     $ 90
    Processing Fee  $ 10
    Cash                              $960
    401(k) wh                       $ 20
    Health Insurance            $ 10

     My projects are properly stated with $390 payroll costs.  I use burden rate of 28% to apply additional costs for payroll tax and vacations to the projects.  The offset of that is a contra expense account in the payroll taxes and benefits section.  This is done through a Sage burden, not by payroll entry, and I think we are good.
    Am I missing something?

    Joseph Harper CPA, CCIFP
    Greater Dayton Construction Group
    Beavercreek OH
    (740) 607-1449

  • 8.  RE: Sage 300 CRE / 3rd Party Payroll

    Posted 03-31-2016 23:12

    As a Sage reseller this is a topic that comes up from time to time. We have found a company that creates these interfaces between both Sage 300 CRE (Timberline) and Sage 100 Contractor (MasterBuilder). The company is Resource Navigation and the contact is Scott Eidle. I do not have Scott's email address handy but his phone number is 224-388-6704. We have a number of clients that have created the interface successfully.

    Dominic Pernai
    Cornerstone Solutions
    Chicago IL
    (630) 288-3349