If you are a small business owner this cash flow form is ideal for you to keep an eye on the availability of cash that you have for paying your bills on a day to day basis.
This form is perfect for small businesses that have a tight budget and need to keep a close watch on the money coming in every day and to check whether there will be enough to cover expenses.
It helps you forecast if your cash is going to run critically low in the next few weeks, so that you can take action to improve the situation before that happens.
This form should be updated every day with:
Once you have a good cash flow that doesn't require intense daily monitoring, you can move away from this cash flow form to a general monthly cash flow forecast, or you can keep going with this form if you like it and want to keep doing the daily checks.
Go here if you want to know more about what cash flow is, and how it relates to a budget.
Here is an example of the form that has been completed with sample information so you can see how and where to enter your data.
Save the form to your computer filing system.
Give it a simple name you can find easily again such as Cash Flow 11 Nov 2019 – this date being the cash at today’s date.
Note: There are formulas in this cash flow form, mostly in Column F.
If you type information into Column F, you will mess up the formulas and the totals, and your forecast balance will be all wrong.
Column F is in blue, all cells in blue mean you don’t enter data here. All white cells are where you can type data.
You can customize the whole form to suit how you want it to look, rename headings and change the shading.
You are monitoring the funds you have right now, so you need to enter today’s date.
Balance in bank at end of day yesterday
If you have internet banking you can quickly view what the bank balance was at the end of the day yesterday, in other words, the closing balance – which should actually be the same as the opening balance this morning depending how your bank operates.
If the bank has already cleared payments received or paid out this morning, then enter the balance at today’s date.
If you have more than one bank account you can add the balance of all accounts together and enter the total.
If you don't do internet banking then this cash flow form will begin from the closing balance at the date of your last bank statement.
Add checks or cash received today, still to deposit to bank
If your customers have paid you by check or cash and you are holding those in your cash box, or somewhere in the deep, dark depths of your hand-bag, add them up and enter the total here.
Then make sure you go to your bank today and deposit them.
If you are not using internet banking you will keep adding a list of all checks or cash received from the date of your last known balance up to today.
This is where you list the checks you have issued to other businesses and suppliers, who for some reason have not deposited your payments yet.
Maybe they have lost the checks in the deep dark depths of their hand-bags, (or maybe you only just paid them).
There is no need to put detailed information on this form because you can get that from your cash book or check summary/copy, or the invoice.
Simply enter the check numbers and amounts.
List out a summary of all the payments you know you have to make in the weeks ahead.
Enter the dates they are due for payment. Remember to include an estimate of bank fees.
When you see any balance in Column F turn red with brackets – this means the bank will go into overdraft at that date.
Of course, there is a strong possibility that you may receive payments from customers before that balance turns red so if you know you have a payment coming before the cash balance goes into the red – don’t panic!
However, below are some things you can do if you need more cash.
You could do all of these, or a combination of some or just one thing– something that you know will help your situation.