Templates

Private Practice 12-Month Cash Flow Template

$20.00

Keep informed about the cash flow in your practice and prepare for upcoming expenses with this 12-month template.

Category:

Product Description

Cash flow statements are important in any business. It shows the flow of cash in and out of your practice and is useful in seeing a realistic and relevant picture of your cash balance for a specific period (usually monthly).

Note that cash flow statements are different to profit and loss statements. For an explanation of the difference, see this Knowledge Base article.

Keeping an up-to-date cash flow statement is helpful in short-term planning for your practice in regards to cash. For example, if you know that a lot of expenses fall in August based on your cash flow projections, you can implement a savings plan in the months leading up to August. You’ll be able to allocate a realistic amount of savings funds as you can see on paper how it can affect next month’s cash balance.

 

How to download this template

Once you check out, click on the “Download” button which will take you to a view-only Google Spreadsheet page. You can download this to your computer by going to File > Download, or sign into your Google account to make a copy of the file to your own Google Drive.

 

How to use this template

This is a Monthly Cash Flow Statement Template in spreadsheet.

To start using the template, follow these steps:

  1. Edit the months. This spreadsheet starts in July. Change it to the current month.
  2. Put in your Opening Balance (Cell C6). This is the cash you’re starting with – i.e. how much is currently in your business.
  3. In the Revenues section, put in your monthly revenue – from sessions and other revenue streams.
  4. In the Operating Expenses section, put in your monthly expenses per category. You can edit the expense names and add your own.
  5. The rest will auto-populate.

Net Profit means the cash you have left in your practice after expenses for this current month – i.e. Revenue minus Expenses.

Closing Balance means the cash balance for the current month plus your opening balance. For each month, this equals the next month’s Opening Balance.

Additional information

File Type

has been added to the cart. View Cart