General Inquiries

Cash Flow Forecasting

  • 1.  Cash Flow Forecasting

    Posted 02-04-2019 16:09
    ​I use Sage 300. I currently use a spreadsheet to do a 12 week cash forecast, based on accounts payables, accounts receivable, loan payments, bank balances, etc. I have to develop a weekly 6 month cash forecast taking the backlog, and percentage of completion on the Contract Schedule into the calculations. Does anyone do that out of Sage 300? Do others create an excel template and weekly manually input the data? Is there a software out there that ties to Sage 300 to accomplish this?

    Thanks in advance for any advice you can offer.

    Deborah Congden
    Chief Financial Officer
    Patriot Towers Inc.
    Scottsville NY
    (585) 889-3391

  • 2.  RE: Cash Flow Forecasting

    Posted 02-04-2019 17:13
    Hi Deborah,

    Have you explored the capabilities of Office Connector, and how it could help in that process?

    I have some information on this product from Event One Software, as we are looking at purchasing the Suite.

    thank you,
    Joe Harper

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

  • 3.  RE: Cash Flow Forecasting

    Posted 02-05-2019 02:09

    I've been trying to get our CFO to switch from spreadsheets to Centage Budget Maestro but he just loves his unwieldy and inflexible spreadsheets.  I just looked at their website and they do interface with Sage 300.  You might check out their demo's and see if it's a good fit.


    Timothy Emerick
    Business Analyst
    B&D Industries, Inc.
    Albuquerque NM
    (505) 299-4464

  • 4.  RE: Cash Flow Forecasting

    Posted 02-05-2019 07:21

    I 'like' the idea of finding a way to automate this activity, but I have found that by using WIP, converstions internally about future projects, relative contract value and schedule, there are too many variable that require human interaction and 'feel'. I'm sticking with my spreadsheet! to compound all of that our project schedules typically run for 12 - 24 weeks. CTC exercise by PMs on the 10th and 25th every month help me to tweak our monthly and quarterly financial reporting and future cash flow for the next six months. Again, based on the duration of our projects I won't really 'see' the 4th quarter developing until March or April.

    Good luck!


    Joe Burkett CCIFP
    Cafco Construction Management LLC
    Boston MA
    (617) 426-7600

  • 5.  RE: Cash Flow Forecasting

    Posted 02-05-2019 08:21
    I have been using Office Connector for over 10 years to refresh information on my spreadsheets. You can create a linked spreadsheet that will pull the latest data from the system every time you open and put your credentials. So you could upgrade your existing spreadsheets by adding the link to the database. A license costs a little over $1000 plus annual maintenance. You would still need to tweak your results as far as projections and backlog. Another way of doing this is using ODBC link to the data source but a lot more manipulation is needed that way. And Office Connector uses the same link, just programmed in Visual Basic for better presentation. They also have a new product called Liberty Reports that might have a built in cash flow. I have not researched it. In addition, I had them build a company specific Excel templates back in the days to fit my needs as an additional charge but I am not sure they do that anymore after Sage purchased them.
    Hope this helps.

    Angel Goldman CCIFP, MBA
    Bartlett Brainard Eacott
    Bloomfield CT
    (860) 922-5009

  • 6.  RE: Cash Flow Forecasting

    Posted 02-05-2019 11:51
    Hi Deborah,

    Are you using Sage 300 CRE (formerly Timberline)? My answer is for this product.

    If you are familiar with ODBC, you can pull the data in yourself. But, there is a product called Office Connector by Event1 Sage 300 Construction and Real Estate - Event 1 Software, Inc. that will help you create this report or they may have one already built. Using them will eliminate manual entry of data which you probably want to avoid.

    Hope this helps!

    Sharon Hessong
    It Administrator/Software Trainer
    Embrey Partners Ltd
    San Antonio TX
    (210) 284-3813