General Inquiries

Accounting Software

  • 1.  Accounting Software

    Posted 02-17-2020 09:39
    Good Morning!

    We are a construction company that does striping, painting, grooving, for large INDOT jobs as well as rental of various items to companies for smaller jobs.  (IE orange barrels, road closed signs, etc.)  We currently use quickbooks for accounting and would like to adopt a more extensive software for accounting, rentals, project management, etc.

    I've read the discussions about viewpoint.  Is it really as bad as it seems?  We were super excited when we saw their demo, but the discussion here scares me.

    Has anyone used or is currently using Assignar, PowerTrack, or Foundations?  Anyone have suggestions or systems to steer clear of for both rental and accounting.

    ------------------------------
    Lorri Hommel
    Controller
    Gridlock Traffic Systems, Inc
    Indianapolis IN
    (317) 541-2727
    ------------------------------


  • 2.  RE: Accounting Software

    Posted 02-17-2020 12:41
    We demoed Spectrum (by viewpoint), Foundation, and Sage 300. We ended up settling on Foundation, but we have not begun the implementation process yet. I used viewpoint vista in a previous role, and it is very comprehensive software. I don't have direct experience with their customer service, as we had an in-house VP consultant. I am curious to see what you choose to go with.

    ------------------------------
    Kelsie Keleher Bachelor of Bus. Admin, Acct.
    Controller
    Kings Construction
    Oskaloosa KS
    (785) 863-2534
    ------------------------------



  • 3.  RE: Accounting Software

    Posted 02-18-2020 08:51
    Be sure to look at Procore (extensive but worth it), excellent for project management, customizing QB for your accounting needs is easy, even by division, job,
    if total revenue is below $50m QBis fine, Procore has accounting module but nothing as user friendly as QB

    ------------------------------
    Kenneth Berkman MBA Accounting Finance, Hofstr
    Controller
    EMACo
    East Islip NY
    (516) 380-5473
    ------------------------------



  • 4.  RE: Accounting Software

    Posted 02-19-2020 08:02
    ​Hi Lorri:

    I implemented and used Foundation about 20 years ago for a company that did guardrail, signs and lighting on ODOT jobs.  It was wonderful.  Fantastic for union payroll and for capturing extra work.  I don't know how the software has progressed but I would recommend looking into it.

    ------------------------------
    Susan Milner
    Corporate Controller
    Eldeco Inc.
    Greenville SC
    (864) 312-9896
    ------------------------------



  • 5.  RE: Accounting Software

    Posted 02-18-2020 09:20
    We are on Viewpoint Spectrum and love it!  We went live Jan 2012.  I do not have a problem with their customer service.  I can tell you that I did like the customer service better when Spectrum was owned by Dexter + Chaney, but I have seen improvements.  Chat is much easier than waiting on an email.  I used the chat feature last week and was able to solve two problems in under an hour.

    Let me know if you are interested, I can much you in touch with someone.

    ------------------------------
    Tracy Rasmussen
    Senior Accountant
    Building Controls and Services
    Wichita KS
    (316) 267-5814
    ------------------------------



  • 6.  RE: Accounting Software

    Posted 02-18-2020 12:47
    Hi everyone,

    Many contractors (especially subcontractors) take on too much risk by signing agreements that do not hold software vendors accountable for promises made in the sales process.

    The following tips will help everyone select the right software, improve adoption AND ensure shared risk and accountability in the partnership.

    First:
    The estimated rate of adoption in construction tech is only 66%, making adoption the riskiest part of investment. Subcontractors specifically, have a more difficult time finding best fit tech and succeeding in adoption for 3 reasons:
    1. Contech is often designed around generalist workflows, yet subcontractors work in endless VUCA scenarios (Volatile, Uncertain, Complex & Ambiguous).
    2. Subcontractors often cash flow phases of projects, limiting their ability to invest.
    3. Subcontractors often have tight schedules leaving little time for adoption.

    Tips for finding best fit tech and mitigating risk of ERP adoption:

    • Section 1: Tips to #buildTRUTH in tech selection.
    • Section 2: Tips for due diligence.
    • Section 3: Services to ensure ERP adoption and business continuance.

    Section 1Tips to #buildTRUTH in selection process

    1.a: Discovery and demos with detailed job info (with YOUR data)

    Teaching vendors about your unique traits and workflows is critical, but HOW you teach them has big impact and will #buildTRUTH into the sales process.  

    We strongly recommend having vendors use your data to build a proof of concept. This can eliminate Smoke-stacking, which is when vendors oversell integrations and partnerships with other vendors. (see video for more info)

    Here's a great list of job information to provide vendors:

    1. Drawings and Bid Summary – as much detail as possible. (Copy of the Job Cost summary and Purchasing info from an estimate)
    2. Cost Code List – Code, Description, Division, GL accounts, Expense Type.
    3. Job Documents- Attachments to be included. (Drawings, Certificate of insurance, Billing template etc.)
    4. Contracts/ Change order List /work orders – Contract #, Value, Division break down, sub section. (Budget if possible)
    5. Job Budget Detail – Cost code, Qty, UOM, Unit Cost, budget Date, sub section.
    6. Job Progress Billings – Schedule of values, Invoice copies.    
    7. AR Deposits – Payments received for the Job.
    8. Job Cost Detail - Cost code, Qty, UOM, Unit Cost, Transaction Date, sub section.
    9. PO Detail List – PO #, Delivery date, items , Vendor, QTY, Unit cost and UOM.
    10. Sub Contract Information – Sub contract value, Cost code QTY, UOM.
    11. Sub Contract Billing – Billings attached to the Sub contracts.
    12. Time Card sample/details – Payroll register for Job Employee Code, Hours, Cost codes, Rate, Sub Section, and other job cost payroll items.
    13. Submittals – Details of Submittals and Attachments sent to GC.
    14. RFI Listing – RFI detail listing with attachments.
    15. AP Listing  (List of bills attached to Job) Vendor, Transaction date, Line detail, tax and Total.
    16. Cost Projection Report/spreadsheet– Report displaying all the cost projection details. (Projection #, Cost code, UOM, Unit, UOM, Rate, Completion %)
    17. Certified payroll rate sheet (If Applicable) and Certified payroll report. (If Applicable)
    18. Work Tickets- Sample work ticket received from the work site.
    19. Daily Report – Sample Daily report received from the job site.


    1.b: Eliminate risk of cloud cuffing , which is when software vendors charge you subscription or license fees before they get you live. Recommendation: Ensure vendor is willing to make fees conditional on go-live. (see video for more info)


    1.c: Eliminate risk of overages /handcuffing,  which is when vendors attract you with low prices, then charge 200% - 400%+ in overages when you feel it's too late to quit. Recommendation: Ensure vendor will provide GMP (guaranteed max price) agreements for all services required for Go-Live.

    1.d: Another good recommendation is to ensure annual fees align with value to 'subcontractors', as opposed to GC's.


    Section 2Tips for due diligence

    Tip #1:  2x now saves 4x later

    Double due diligence:  Software adoption often results is overages that are 200% - 400%+ over the cost on contract so we recommend doubling the time you planned in making the decision. Subcontractors have little to no time for software selection but investing 2x time now will help expose risk and shortcomings so you can save 4 x later.


    Tip #2: 
    worthy references

    Finding quality references: Look beyond the references provided and search for subcontractor specific associations for members who do the similar work to you AND who are customers of the prospective provider(s).

    We also recommend speaking to 3-4 people in separate departments.

    1. Speak to people outside accounting is they offer products outside accounting.
    2. Ask about the variance between the original contract price and total cost of ownership.
    3. Ask what promises were made vs. delivered.
    4. Find out about changes in level of support over time.
    5. Ask user about their level of knowledge of the trade.

    Another good way to find worthy references is searching the provider on LinkedIn and find their key sales people. Then look to see which companies those sales people are connected with to get a list of their potential customers who they did NOT provide as references.

    1.  This will help you avoid reference stacking, which is when software vendors stack the deck with references who only provide good reviews.
    2. In addition to calling companies, search employees of the prospective provider(s) on LinkedIn and look for mutual contacts.
    3. Your mutual contacts may be able to provide candid insight into the provider's product, service and integrity.

    Section 3Services to ensure adoption and business continuance 

    Most implementation services include general level data import, process recommendations and training, yet subcontractors need significant additional work for successful adoption.  As subcontractors have next to no time to complete the additional work, services providers need to step in.

    IMPORTANT:  Get a commitment for this....
    To #buildTRUTH in cost and adoption, have service providers include all services below for a GMP (guaranteed max price) while defining go-live and what a successful implementation looks like.

    Recommended Services to include:

    Pre-Live Services

    1.      Collect, import and validate vendor list, customer list and relational data

    2.      Collect, import and validate employee list/safety/experience/HR data

    3.      Build GL account listing

    4.      Open jobs listing and cost code listing for replication in new ERP

    5.      Scoping for custom integrations

    6.      Prepare Payroll account defaults including Union, DB, CPR, fringe benefits where applicable

    7.      Items database development for each branch/company/division of labor - items must include all properties related to bidding, field and purchasing manager's perspectives such as:

    • internal items codes and descriptions
    • each supplier's code and description for POs
    • all related UOMs
    • dimensions
    • properties
    • expense types

    8.      Company logo and all external documents for replication in documentation

    9.      Sample GL Transactions for replication

    10.   Sample Check Stubs (Payroll, AP, Garnishment) for replication in documentation

    11.   Sample Job Cost/Job Budget for replication

    12.   Sample Reports (PO, AR Invoice, PM) for replication

    13.   Sample WIP for replication in new WIP and potential customization

    14.   Complete AR Aging (By Customer/Job) for tie off

    15.   IF you are looking to integrate an estimating system, you need to:

    • create mapping template for each estimator's database
    • map item codes and descriptions, cost codes, expense types
    • map locations/subsections, UOM, price per UOM, unit cost
    • total cost, dimensions
    • You also need to make sure the solution has the ability to map items that were added to any database that were not previously mapped on the fly without software vendor's assistance.

    16.   Outstanding retainage for entry (By Customer/Job)

    17.   Trial Balance (Same date as AR)

    18.   full historical AIA SOV's for manual entry to enable accurate retainage billing

    19.   Invoice & Cash Receipt Register for replication

    20.   AIA billing templates from all customer invoice template for replication in auto-progress billing template

    21.   All vendor invoices for mapping so PO matching tools can work

    22.   Complete change order log for replication

    23.   All sales Tax Rates/Reporting for replication

    24.   Monthly WIP Reports (Fiscal Year)

    25.   Employee YTD and Payroll Information – Pay Stub/Time Sheet

    26.   Payroll Register Reports for replication

    27.   Sample Reports (CPR, Union, etc.) for replication

    28.   Sample Direct Deposit File for replication

    29.   Sample Positive Pay File for replication

    30.   All open subcontracts for replication

    31.   Complete benefit plans/enrollment (ACA) for set up in benefits tracking

    32.   Remote introduction to customer, vendor and employee info

    33.   Remote introduction to inventory/material management

    34.   Remote introduction to vendor pricing, job special pricing and PO creation

    35.   Remote intro to payroll info; pay rates (union/davis bacon, prevail wage, benefits, safety cert etc.)

    36.   Open AR for replication and tie off

    37.   Open AP / Discount Report for replication and tie off

    38.   Confirm Trial Balance

    39.   Employee YTD's (Quarterly) - 940 & 941 for replication

    40.   Open Check Lists/Deposits for replication and tie off

    41.   Open / Pending Change Orders for replication and tie off

    42.   Bank Balance as of Trial Balance (All) for tie off

    43.   Bank Reconciliation (All) for replication in documentation and tie off

    44.   Job Cost to Date for replication and tie off

    45.   Budget's for replication and tie off

    46.   Pre-Live WIP Report for tie off

    Go-live Services

    47.   TRAINING for 3rd party estimating system import

    48.   TRAINING for Payroll/HR

    49.   TRAINING for Accounting/financial management

    50.   TRAINING for pre-construction

    51.   TRAINING for Job start up

    52.   TRAINING for Purchasing & material management

    53.   TRAINING for Job Costing

    54.   TRAINING for Document Control

    55.   TRAINING for Contracts & Subcontracts

    56.   1st month end emergency data repair

    (time sensitive data repair which is needed with new ERP implementations)

    57.   TRAINING for project management

    58.   TRAINING for estimators (if required)

    59.   TRAINING for field (if mobile apps required)

    Post-Live Services

    60.   Continued core function training

    61.   Post-live punch list creation and resolution

    62.   1st quarterly emergency data repair

    (time sensitive data repair which is needed with new ERP implementations)

    63.   CPA checklist and sign off

    64.   Post-live utilization assessment

    65.   1st year end emergency data repair

    (time sensitive data repair which is needed with new ERP implementations)

    66.   Itemize all custom reports and/or custom work, imports/exports, mappings and APIs required so client can negotiate the cost of ensuring all custom work is made compliant with ALL future software updates as updates often break customization, imports/exports, mappings and APIs.


    Cheers everyone - Good luck!!!!


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