Sub Specialty Contractor

  • 1.  New Software

    Posted 09-27-2021 08:12
    Hello All

    I'm going through the process of vetting a new software company for a specialty contractor.  I'm looking at Spectrum and Coins.  I was wondering if anyone uses the systems and has  points of view on either of the two systems.  Thank you very much
     
    William Edmonds

    ------------------------------
    Bill Edmonds
    Controller
    American Refrigeration Company
    Wilmington MA
    (978) 905-3753
    ------------------------------


  • 2.  RE: New Software

    Posted 09-27-2021 08:14
    Bill,

    I would suggest looking at eSub. They have some fantastic feature specific to specialty contractors.  it is worth a look.  Good luck. 
    Construction Project Management Software for Contractors | eSUB

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



  • 3.  RE: New Software

    Posted 09-28-2021 08:08

    Specialty Contractors usually have trouble getting operations onto ERP software as the software is usually made fits GCs better so other CFMA members have found the following information helpful for successful software selection AND adoption.

    Regardless of the software you choose, adoption IS your biggest risk. 
    You can significantly lower risk with these 2 initiatives.

    • Initiative #1: Build a fair contract 
    • Initiative #2: Secure detailed plan for successful adoption.

     

    Suggestions for Initiative #1 (Build a fair contract)

    1.a.  SAFEGUARD AGAINST RISK of UNFAIR SUBSCRIPTIONS: 

    Unfair subscriptions have an imbalance of rights and obligations and can include lack of transparency of total cost to onboard, misrepresentation of products and service and failing to provide options for cancellation without penalty.

    Include the following into your agreement;

    • Client may cancel agreement at any time (any payments made are non-refundable)
    • Software vendor shall provide detailed plan, including a complete list of tasks, commitments, milestones and skills and hours required for successful onboarding.

     

    1.b.  SAFEGUARDS AGAINST RISK of CLOUD CUFFING: 

    Cloud-cuffing is when software vendors charge license or subscription fees BEFORE the client is LIVE while also keeping client data hostage in order to extort additional payments from client in future, should client decide to change providers.                           

    Include the following into your agreement;

    • Software vendor shall defer subscription fees and/or licensing fees until client is LIVE on related software. LIVE is defined as when the following critical milestones are achieved:
      • AP payments are paid through software
      • Payroll runs (and/or) Payroll service export is completed through software
      • Client is posting to the GL
      • Entry of historical AIA/progress billings details to enable accurate retention billing                                                                                                                                
    • Software vendor shall ensure that lifetime user licenses is granted in the agreement are grandfathered into ANY future agreements or end user license agreements that and updates that accepted by client.

     

     

                   

    1.c.  SAFEGUARD AGAINST SMOKE STACKING:  

    Smoke-stacking is when software vendors oversell the level of integration of products in a tech stack.  This can also result in additional fees to improve integrations as well as fees to maintain the integrations when they break with updates.             

    Include the following into your agreement;

    • Software Vendor shall ensure integrations between estimating, mobile apps, project management and accounting functions are integrated to the level represented in sales demonstrations with no additional set up or support fees outside of contract, as well as no additional fees for keeping integrations compatible with updates to any product outside of contract.

                   

    1.d.  SAFEGUARDS AGAINST R&D REDIRECTION: 

    R&D redirection is when software vendors collect similar fees from all customers in all industries while functions and workflows mostly benefit a core group of customers (common when subcontractors use software primarily made for general contractors)                                                                                                      

    Include the following into your agreement;

    • Software vendor shall ensure annual support fees are aligned with the demonstrated value delivered to client's trade(s) over the previous 3 years of the product's release notes, as it compares to value delivered to other industries.

                                                                                   

    1.e.  SAFEGUARD AGAINST OVERAGES AND OVERRUNS

    Software vendors can undersell the complexity and cost of deployment which can result in overages of 200% to 400% of the cost on contract as well as multiple schedule overruns.

    Include the following into your agreement;

    • Software vendor shall provide a complete deployment plan with GMP (guaranteed maximum price) for all commitments required for a successful GO-LIVE.

     

     

    Suggestions for Initiative #2 (Secure detailed plan for successful 'adoption')  

    Specialty contractors need to complete the following tasks in order to achieve successful adoption on ANY ERP CONVERSION.

    We recommend having software providers indicate which tasks they will complete for you, and at what maximum cost so you don't get charged overages, and which tasks you are required to complete:

    1. Import and verification of vendor list, customer list and related data
    2. Inclusion of company logo into all external documents
    3. Completion of employee list/safety/experience/HR data
    4. Completion of GL account listing, open jobs listing and cost code listing
    5. Scoping for custom integrations
    6. Payroll defaults, union, DB, CPR, fringe
    7. Sample GL Transactions for replication
    8. Sample check stubs (Payroll, AP, Garnishment) for replication
    9. Sample job cost/job budget for replication
    10. Complete items database development for each branch/company/division to customer spec to enable effective item selection for POs (Specialty Contractors require item codes by vendor and descriptions, UOMs, dimensions, properties, expense types to be included in database development)
    11. Sample reports (PO, AR invoice, PM reports) for replication
    12. Sample WIP to align with WIP in go-live
    13. Complete AR aging (By Customer/Job)
    14. Outstanding retainage (By Customer/Job)
    15. Trial balance (Same date as AR)
    16. Historical SOV's to be manually entered to enable accurate retainage billing
    17. Invoice & cash receipt register
    18. Creation of billing templates to customer/GC invoice templates
    19. Creation of vendor PDF invoice template mappings for PO matching
    20. Complete change order log for replication
    21. All sales tax rates/reporting for replication
    22. Monthly WIP reports (Fiscal Year) for validation
    23. Employee YTD &payroll info – pay stub/time sheet for replication
    24. Payroll register reports for replication
    25. Sample reports (CPR, Union, etc.) for replication
    26. Sample direct deposit and positive pay files for replication
    27. All open subcontracts for replication
    28. Complete benefit plans/enrollment for replication (RE: ACA)
    29. Preliminary training/introduction or training materials review and Q&A for customer, vendor and employee info
    30. Preliminary training/introduction or training materials review and Q&A for inventory/material management
    31. Preliminary training/introduction or training materials review and Q&A for vendor pricing, job special pricing and POs
    32. Preliminary training/introduction or training materials review and Q&A for payroll info; pay rates (Union/Davis Bacon, prevail wage, benefits, safety cert etc.)
    33. Open AR for replication and tie off before go-live
    34. Open AP / Discount Report for replication and tie off before go-live
    35. Trial balance for go-live
    36. Employee YTD's (Quarterly) - 940 & 941 for replication
    37. Open check lists/deposits for replication and tie off before go-live
    38. Open/pending change orders for replication and tie off before go-live
    39. Bank balance as of trial balance (All) for tie off before go-live
    40. Bank reconciliation (All) for replication in documentation and tie off before go-live
    41. Job cost to date for replication and tie off before go-live
    42. Budget's for replication and tie off before go-live
    43. WIP Report review and customization if needed
    44. Training for payroll/HR
    45. Training for accounting/financial mgt
    46. Training for pre-construction
    47. Training for job start up
    48. Training for purchasing
    49. Training for job costing
    50. Training for document control
    51. Training for contracts & subcontracts
    52. emergency data repair of 1st month end to ensure future month ends are sound
    53. Training for executives
    54. Training for remote tools
    55. Punch list creation for outstanding gaps and functions for optimization
    56. emergency data repair for 1st quarterly to ensure future QRTLYS are sound
    57. CPA review to ensure integrity of financial reporting
    58. Year-end emergency data repair of 1st year to ensure future year ends are sound


    ------------------------------
    Chad Pearson (dealer of truth in build)
    Plexxis
    Brampton ON
    (416) 574-1677
    ------------------------------



  • 4.  RE: New Software

    Posted 10-01-2021 12:47
    Very helpful!

    ------------------------------
    Mia Garza
    Controller
    BEI Construction Inc.
    Alameda CA
    (510) 502-4488
    ------------------------------



  • 5.  RE: New Software

    Posted 10-01-2021 13:47
    Cheers Mia.  Thank you.

    ------------------------------
    Chad Pearson (dealer of truth in build)
    Plexxis
    Brampton ON
    (416) 574-1677
    ------------------------------



  • 6.  RE: New Software

    Posted 09-28-2021 08:36

    Bill,

     

    We implemented COINS and went live on 1/1/2018.  I would be more than happy to answer any questions you have.

     

    Regards,

     

    George Fernandez
    Controller
    1625 W. Thompson Road, Indianapolis, IN 46217
    317.423.3872 direct | GFernandez@ermco.com

    ERMCO, Inc. --100% employee-owned--
    EMPOWERING PEOPLE | INSPIRING INNOVATION
    INDYSTAR TOP WORKPLACES 2020

    Proud member of the Electric Roundtable
    twitter.com/ERMCOInc |linkedin.com/company/ERMCO-Inc

     






  • 7.  RE: New Software

    Posted 09-28-2021 11:25
    I have used many programs for various specialty trades and I highly recommend ComputerEase/Deltek. Very easy to learn, use, and provides all the bells and whistles in comparison to the other popular programs. I would be more than happy to tell you more and introduce you to the right people that have helped me and my clients.

    Nicholas Pavic, CPA
    Founder/CEO
    Velebit Consulting
    Cell 718-986-3247
    Email nick@velebitconsulting.com
    Fractional CFO Services to Construction Businesses

    ------------------------------
    Nicholas Pavic CPA
    Founder & CEO
    Velebit Consulting Corp. - Fractional CFO Services
    Plainview NY
    (718) 986-3247
    ------------------------------



  • 8.  RE: New Software

    Posted 09-28-2021 13:13
    Bill

    We are currently in the process of switching our ERP to COINs.  It is a very capable system with lots of configurable features.  The flip side is that you should expect to spend a lot of time learning the system and choosing how to configure it to your best advantage.  This is undoubtedly true of any high end ERP system.  Feel free to contact me off line if you have specific questions.  We are a mechanical contractor (union) with approximately 300 employees.  

    David Sietsema

    ------------------------------
    David Sietsema MBA
    David Sietsema, CFO
    The Porter Company/Mechanical Contractors
    Manchaca TX
    (512) 282-9691 x223
    ------------------------------



  • 9.  RE: New Software

    Posted 10-01-2021 13:02

    I am somewhat in the same boat as Bill, our company is currently on Viewpoint ProContractor however our database is too big for the software.

    ProContractor does not have any archiving type of feature for that software.

    Does anyone have any other recommendations besides Coins?

    We are a union company, we provide electrical/solar, low voltage, security and audio visual services.


    ------------------------------
    Mia Garza
    Controller
    BEI Construction Inc.
    Alameda CA
    (510) 502-4488
    ------------------------------