Controlling and forecasting cash flow is essential when you work for yourself. To help you keep an eye on this, we at Zervant, made this free cash flow forecast template. Use it to monitor monthly balances, income, and expenses. It’s ideal for sole traders, freelancers and small businesses in the UK!
Clear invoice overviews help keep track of your cash flow
And if you need any help with getting paid, be sure to check out Zervant’s online invoicing software. It’s free to use, and you can create an unlimited amount of invoices. Staying up-to-date of your invoices has never been easier!
Download Cash Flow Template
If you find it comes in useful, be sure to check out the free tools section on our blog. We have everything you need – invoice templates, a mileage log, a stock take tool and more. They’re all 100% free!!
Instructions for the Cash Flow Template
1. Getting Started
The first thing you need to do is add your company information, including name, the financial year you’re covering, and the months in it. You only need to do this once, at the top of the “Cash Flow Forecast” tab. The template will apply this information everywhere else for you.
We’ve highlighted these areas in red:
You also need to set the opening balance for your financial year. It can be £0, but you may have money from elsewhere you wish to transfer to the start of this year.
2. Adding Your Info in the Cash Flow Forecast tab
The “Cash Flow Forecast” tab is the main dashboard for your cash flow, but we’ve also included four other tabs in the template. We’ve named them “Income”, “Expenses”, “Capital Expenses” and “Other Income”, which should cover all the entries you need for a cash flow template. Use these tabs to track the daily movements of money in and out of your business
These four tabs all have a drop-down menu with options for different entries. You can choose the names of the entries for each drop-down menu by entering them manually in the “Categories” tab. You can put up to 20 entries in each category.
Again, we’ve shown you an example highlighted in red:
3. Making Entries
These options will now appear in the drop-down menu for each of the specific tabs. This makes it easy for you to add daily entries in your cash flow template. All you need to do is add the date (dd/mm/yyyy format), the amount, and choose the relevant item from the drop-down menu (there’s an example in each of the tabs to show you).
And in the picture below we’ve used the example of a bike shop to help explain things better. In the “Categories” tab we added different types of entries that might be used in a bike shop.
So when clicking on, for example, the “Income” tab all the options added in the “Categories” tab can be used to make daily entries. All that is needed is to add the date and the amount.
The same principle applies for all four tabs – “Income”, “Expenses”, “Capital Expenses” and “Other Income”. All this information will automatically be updated on the main dashboard a.k.a. the “Cash Flow Forecast” tab.
What Can I Use the Cash Flow Template For?
The cash flow template will help you keep an accurate record of the day-to-day flow of cash in and out of your business.
The Cash Flow Forecast tab will provide an overall view of how your business is performing. This includes monthly balances, opening and closing balances, and an overview of total income and expenses per month/ for the whole year.
Your monthly balance is the sum of all the transactions in a particular month eg. the “Income” and “Other Income”, minus the “Expenses” and “Capital Expenses” your business has.
The opening balance each month is the amount carried forward from the previous one, and the closing balance is the total of your opening balance and monthly balance in the month.
Stay on top of your cash flow with invoicing software!
Create an account and send invoices for free. Keep track of them on your invoice dashboard, making it easier to forecast your future cash flow!