Cash flow projection (and why you should)

21 Aug 2022 3 min read
Cash flow projection (and why you should)

Creating an actual cash flow projection is time-consuming or difficult. However accountifying make it easier for you by capturing your estimation, income, expenses and payment on one signle platform,

When preparing your cash flow forecast and projection, keep three things in mind:

  • Keep your estimates conservative and realistic. Erring on the side of caution—and leveraging the insights drawn from your historical spend data—can keep you from making potentially costly business decisions. Accountifying.com help you to manage all your estimation and payment in one single source. 
  • Update your forecasts and projections regularly. Monthly projections may not require many updates, but the longer the period forecasted, the more numerous and frequent your updates should be. A lot of things can change over the course of a quarter or year, so be sure to account for changes in revenue and expenses as events unfold.
  • Don’t forget to factor in variable expenses. Seasonal businesses will have a much different outlook for cash inflows and outflows than a year ’round retailer.

Using your cash flow assumptions (i.e., the total projected cash flowing in and out of your business for the time period you’re projecting), you can create a monthly cash flow forecast, and then use that to create a cash flow projection, by following a few basic steps.

1. Bring Total Ending Cash Forward

If this is your first cash flow forecast, use your reconciled cash balance. If you’re working from a cash flow forecast from the previous month, use last month’s ending balance as the starting balance for the cash flow statement you’re creating for the month ahead.

2. Estimate Sales

If you have 2,000,00 in customer invoices due in the coming month, and you estimate 75% will pay in full, then you would record 1,500,00 as income from customer payments.

3. Estimate Additional Revenue

If sales are your only revenue, you can jump ahead to step 4. If not, add any other revenue you expect to receive (e.g., rental income, interest) below sales revenue. Add this value to your revenue to get your Total Incoming Cash.

4. Estimate Your Regular Expenses

Add up all your estimated expenses for the coming month and record each of them as a line item. Examples include rent, wages, insurance, utilities, etc.

5. Estimate Your Seasonal or One-Off Expenses

Any seasonal expenses or one-off costs that occur exclusively in the month being forecast receive their own line item. For example, quarterly fees for Web hosting would only appear in the month they’re paid.

6. Deduct Expenses from Income

After you’ve toted up your cash inflow and cash outflow, subtract your expenses from your income to calculate your cash flow for the month.

7. Add Your Beginning Cash to Your Estimated Cash Flow

Combine your beginning balance with the total monthly cash flow value and record it at the bottom of the cash flow forecast. This is your estimated ending cash balance for the month, and the value you’ll use for the beginning balance on next month’s cash flow statement.

Explore More of FinPilot

Discover all the tools and features that make FinPilot the fastest-growing accounting platform for SMBs.