CONGRATULATIONS on deciding to better monitor and forecast your Cash Flow!

If you haven't read my Blog Post about Cash Flow and why it's so important for your Business, please do it here:

Make a copy of this file into your Google Drive so that you can edit it and add your own data

FIRST THING

TO DO!!

Read the instructions carefully to start using the template correctly

Cash Flow chart:

This sheet is just to have a visual representation of your CashFlow, there is no cell that you have to fill or edit.

All the cells here and the chart, are filled automatically with information collected from the Cash Flow sheet.

⭐️ Pro-tip:

Use this chart to quickly see if you're on a negative or positive trend, and to observe any seasonality or peak in your Business

CF_Current Year (CY)

In this sheet you will have your current year Cash Flow data.

This is where you'll register your actual cash-in and cash-out by month for every finished month (actual data).

For the current and following months, you'll type in your best estimation of cash-in and cash-out (forecast).

⭐️ Pro-tip:

Copy this sheet to create different scenarios for the upcoming months, and it will help you to make decisions.

How to insert data on the template: which info to fill where

Things you'll only need to do the first time, to customize your template to your Business

Name your Sales Categories depending on your Business:

↠ If you're a Coach, but you also sell some Health Products, and you have a Digital Course, yours could be:

↠ If you have a product-based business where you sell Handmade Bags and Jewelry, yours could be:

To add new lines, select the two last lines and then click

+Insert 2 rows above

Then select and copy the top two rows and copy them on the new lines created

(this way you keep the format and don't alter the file formulas)

After that, name your Expenses Categories depending on your Business too:

↠ Choose those categories that you want to track and forecast, or that are really relevant (such as Taxes), as they impact your business the most.

↠ Then, have a Other expenses lines for those tiny things that don't need specific track or that happen occasionally.

Here there's an exemple of the kind of categories that you might have.

↠ Advertising & Marketing: if you have a Marketing agency, pay for adds on Social or Traditional media, etc.

↠ Communications & Systems: add here subscriptions to tools and Software, as well as internet connection and cellpone bills

↠ COGS: if you run a product business you'll need this one

↠ Education & Learning: any training or course that you, can be added here

↠ Equipment & tools: any equipment to manufacture products, but also include other purchases such as laptop, camera, vehicle...

↠ Meals & entertaintment: all meals, coffes with customers, team lunch, etc.

↠ Office supplies may include anything from paper, pens, folders, or even water and snacks

↠ Payroll & Employee benefits it's for business with employees to include all salary, healthplan and similar expenses

↠ Rent & Utilites it's for any expense of a physical office, store, etc.

↠ Third Party services: that's for the Bookkeeper, Coach, Lawyer, CPA, Photographer...

↠ Taxes: that's for Taxes payments and returns

↠ Paid with CC: this is important. If part of the above expenses are paid with a CC, this doesn't mean necessarily that there was actually Cash-out from the Business