Cash Flow Forecast & Balance Sheet
Clockwork's Cash Flow Forecast gives you a forward-looking view of your cash position — automatically built from your Financial Model, your accounting data, and the cash behavior patterns Clockwork learns from your transactions.
It's not just a simple projection. Clockwork factors in your open invoices, outstanding bills, and balance sheet activity to give you a more complete and accurate picture of where your cash is headed.
How the Cash Flow Forecast is built
Your cash flow forecast is driven by two things:
Your Financial Model — including any custom Assumptions you've built — forms the base of the forecast.
Cash timing behavior — Clockwork analyzes 6 months of your transaction data to learn how your revenue and expenses actually translate into cash movements. For example, it learns how quickly your customers typically pay invoices, and how quickly you pay your bills.
The result is an intelligent forecast that goes beyond a simple P&L projection and accounts for the real-world timing of cash in and out of your business.
Refining your cash flow forecast
Your forecast is accurate out of the box, but you can make it even more precise by managing a few key inputs:
Invoices
Clockwork pulls your open invoices directly from your accounting system and factors them into the forecast. If you know a specific invoice will be paid late, or an amount has changed, you can edit it directly:
Click the Invoices button in the top right of the Cash Flow Model.
Find the invoice you want to update and click Edit.
Adjust the open balance or expected payment date and click Save.
Bills
The same applies to outstanding bills. Clockwork uses your open bills to project upcoming cash outflows. To update:
Click the Bills button in the top right of the Cash Flow Model.
Find the bill and click Edit.
Adjust the open balance or expected payment date and click Save.
Other Cash In / Other Cash Out
For balance sheet events — like a new loan, an equity distribution, or a large asset purchase — you can enter those directly into the model:
Expand the Other Cash In or Other Cash Out rows in the Cash Flow Model.
Hover over any forecast cell and click the pencil icon to enter your value.
Other Cash In only accepts positive values; Other Cash Out only accepts negative values.
Example: Taking a $100K loan and purchasing $75K of equipment? Enter 100000 in the Liabilities row under Other Cash In, and -75000 in the Assets row under Other Cash Out.
The Balance Sheet
Your Balance Sheet gives you a snapshot of your business's assets, liabilities, and equity at any point in time. In Clockwork, the Balance Sheet is connected to your Cash Flow Model and updates automatically as your accounting data syncs.
You can view your Balance Sheet alongside your Cash Flow forecast to get a complete picture of your financial position — both where you are today and where you're headed.
Need help? Reach out to our support chat in the bottom right of your screen any time.