General Inquiries

Cost to Complete in Foundation

  • 1.  Cost to Complete in Foundation

    Posted 27 days ago

    Hi! Is any one doing their monthly cost to completes in Foundation?  What have you found to be the best way to do these?  We've tried for a few months using the Cost Code Percent Worksheets and building a report from the data genie but we've had multiple issues.  We are considering switching back to our excel reports that we used prior to getting Foundation but thought I would see if anyone has been successful with doing it in the system first.  Any suggestions would be greatly appreciated.

    Thanks!



    ------------------------------
    Stefani Shuey
    Controller
    Siteworks, LLC
    Charlotte NC
    ------------------------------


  • 2.  RE: Cost to Complete in Foundation

    Posted 26 days ago
    For over/under billing entries, we use the Over/Under billing report.  It works great.  We had to play with the parameters to get exactly what we wanted.  We also made some UDF fields to eliminate small jobs from the calculations.

    If you're struggling, call support.  They'll give you tips too on what might work best for your situation.

    ------------------------------
    Jill Morrow
    Vice President / Controller
    IntegriBuilt Roofing
    Irving TX
    (972) 505-2800
    ------------------------------



  • 3.  RE: Cost to Complete in Foundation

    Posted 26 days ago
    I would highly suggest sticking with Foundation for your cost to complete and working through any issues you are having. The over/under report, once you get used to the format, has been highly successful for us. I keep one external Excel file to calculate the month to date over/under billing for the period because the report in Foundation shows the job to date over/under and I like to check the WIP calculation. The only thing that we learned the hard way is to not mess with percentage completion while costs are still accumulating because then you will be forced to manually enter the adjustment monthly for that particular job - the calculation completely stops. I hope this helps!

    ------------------------------
    Nicolle Taylor-Sheafor
    Accounting Manager
    Hardman Construction, Inc.
    Ludington MI
    (231) 316-5326
    ------------------------------



  • 4.  RE: Cost to Complete in Foundation

    Posted 26 days ago
    Hi, Stefani!

    It sounds like you've checked in with FOUNDATION's support while trying some different options, which is good. I recommend continuing to check in with them until you find a solution that you feel comfortable works best for you. At the same time, I'd also encourage you to ask this same question on the FOUNDATION Client Forum as well. That might double the input you get from other users, and it could end up benefiting others as well by hearing how different companies are handling cost-to-completes.

    All best!

    ------------------------------
    Brian Hohmeier
    Senior Writer & Editor
    Foundation Software
    Strongsville, OH
    (330) 220-8383
    ------------------------------



  • 5.  RE: Cost to Complete in Foundation

    Posted 26 days ago
    We actually use the Job Activity report (in Job Cost) and that works really well for us / gives us CTC by cost code / contract value / OCO's - executed and pending / amount billed, etc

    Have you tried that one?

    ------------------------------
    Lynne Pace BS
    Chief Financial Officer
    Kinkaid Civil Construction
    Mesa AZ
    (480) 646-4438
    ------------------------------



  • 6.  RE: Cost to Complete in Foundation

    Posted 26 days ago

    Hi Stefani,

    I have been trying to get accurate Cost to completes from Foundation for 4 years, and have resolved to doing them outside of Foundation using multiple reports to build them. I would be curious if anyone is actually getting them to work as well.

     

    Tori W – Accounting Manager ~Please note my new email address toriw@flemingcomplete.com ~

    (O) 480-237-0765
    1736 S. Nevada Way, Mesa AZ 85204

     

     

    A close up of a sign  Description generated with very high confidence
     

     

     

     

     

     

     

     

     

     

     

     

     

     

     


    Notice To Recipient: This e-mail is meant for only the intended recipient of the transmission, and may be a communication privileged by law. If you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. Please notify us immediately of the error by return e-mail and please delete this message and any and all duplicates of this message from your system. Thank you in advance for your cooperation.

     

     






  • 7.  RE: Cost to Complete in Foundation

    Posted 26 days ago
    We have also struggled with this and have remained with our Excel version.  I was thinking of doing a query to grab at least some of the information automatically from Foundation but haven't been successful finding the right tables yet.


    ------------------------------
    Angela Norpel
    CFO
    KT Fabrication Inc.
    Chandler AZ
    (480) 497-3140
    ------------------------------



  • 8.  RE: Cost to Complete in Foundation

    Posted 24 days ago
    You should attend Scott Kern's class on queries. One of the cool tools he will share with you is a way to search by a term to find the right table. It's pretty amazing. Once you become familiar with queries, downloading and copy and pasting seem so '80's. 😬😜

    ------------------------------
    J. Wickham Zimmerman
    CEO
    OTL
    Anaheim CA
    (714) 637-4747
    wickz@otl-inc.com
    www.otl-inc.com
    ------------------------------



  • 9.  RE: Cost to Complete in Foundation

    Posted 26 days ago
    We enter our cost to completes as an internal owner change order so we can track each change.

    ------------------------------
    Dana Canaday
    Accounting Manager
    Zernco, Inc.
    Wichita KS
    (316) 775-9991
    ------------------------------



  • 10.  RE: Cost to Complete in Foundation

    Posted 24 days ago
    I still do all our over/under calculations via a comprehensive job schedule in Excel. I export the data from Foundation and paste into my spreadsheet.
    It is a tedious process, but I have found that the over/under report in Foundation just doesn't contain the necessary information I need.

    My surety seems to appreciate my Excel spreadsheet vs the Foundation report as well... and a happy surety is a requirement in this industry.

    ------------------------------
    Matthew Radniecki
    CFO/Controller
    Baratto Brothers Construction
    Crosslake MN
    (218) 820-8049
    ------------------------------



  • 11.  RE: Cost to Complete in Foundation

    Posted 24 days ago
      |   view attached
    Matthew,

    Do you have ability to establish a connection directly to your database? If so, you could create a PowerPivot tab on your spreadsheet that pulls all of the data automatically from the database, and use the getpivotdata function to pull that into your data worksheet. It's also possible to combine data from other worksheets to add into the PowerPivot, so you likely could have all of the data you need pulled automatically each month. Attached is an example of a PowerPivot spreadsheet in Excel that is pulling the data directly from a SQL database. With the capabilities of Power Query and Power Pivot in Excel, pulling data into Excel worksheets is a great way to allow the flexibility of Excel but still having a live connection to your data.

    If your software is hosted, you'll have to contact your provider to see if you can establish a direct connection to your data. If your provider doesn't allow direct connections, I'd ask them to add that as a feature request. Some cloud hosted software providers have developed a link to allow access to the database for custom reporting and others restrict access and make you pay them for custom development for any additional access to your data. The days of exporting to Excel should be over.

    Best,

    Kevin Halme
    Constructive Tech Solutions
    Omaha NE
    www.consttech.solutions

    Attachment(s)

    pdf
    Example-PowerPivot.pdf   424K 1 version


  • 12.  RE: Cost to Complete in Foundation

    Posted 23 days ago
    Kevin - it sounds like I need to get with the times! Thank you for the insight into Power Pivot and queries. Seems like it could really streamline jobs reporting.

    Thanks!

    ------------------------------
    Matthew Radniecki
    CFO/Controller
    Baratto Brothers Construction
    Crosslake MN
    (218) 820-8049
    ------------------------------



  • 13.  RE: Cost to Complete in Foundation

    Posted 24 days ago
    Matthew - We have been using Foundation for 11 years. Have you attended Foundation College or Scott Kern's "Top 20 Tables" webinar? I didn't until three years ago, but once I discovered the world of queries, it has made life so much easier. Instead of downloading data from Excel you can query the tables in Foundation and create all kinds of custom reports, Excel spreadsheets, etc. that are linked to your Foundation database and can be updated real-time without exporting a thing. It's awesome!

    ------------------------------
    J. Wickham Zimmerman
    CEO
    OTL
    Anaheim CA
    (714) 637-4747
    wickz@otl-inc.com
    www.otl-inc.com
    ------------------------------