Controlling cash flow is essential when you work for yourself. So to help you keep an eye on this Zervant has made this free cash flow template. Use it to monitor monthly balances, income, and expenses.
It’s ideal for sole traders, freelancers and micro businesses!
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. 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.
Why Not Invoice the Easy Way?
Use Zervant to create and send an unlimited number of invoices, for free! There’s no catches or hidden fees. Click below to get started.