Kerry,
I have developed a worksheet for weekly cashflow forecasting for a 13 week forecast period. I've found this to be a very useful cashflow management tool. It's based on the assumption that it would be updated weekly. I can provide a copy of the worksheet at no charge. Feel free to contact me by email (
mail@consttech.solutions) if you are interested in a weekly template.
The template can be modified to be used monthly and will likely need customized/optimized for your business needs. The current version includes commitments paid to date tracking for those contractors that don't have a full ERP solution.
Best,
------------------------------
Kevin Halme
Constructive Tech Solutions
Omaha, NE
------------------------------
Original Message:
Sent: 10-05-2018 10:52
From: Kerry Sloan
Subject: Cash Flow Projection- Excel Worksheet
if anyone has developed an Excel worksheet for projecting monthly cash flows on a job by job basis that they would be willing to share, please contact me at ksloan@hardaway.net. Thanks.
------------------------------
Kerry Sloan CPA, CCIFP
Executive Vice President, Finance
Hardaway Group, Inc.
Nashville TN
(615) 254-5461
------------------------------