The Perfect Pro Forma Cash Flow

The perfect pro forma cash flow for business owners who want to be in control of their money.

The Perfect Pro Forma Cash Flow

How much cash does your business need in the next 8 weeks?

Do you have a pro forma cash flow that you use to manage your money?

Imagine not worrying about cash flow? How much freedom would you have if you saw your cash flow in the next eight weeks and could get ahead of any upcoming money problems?

A pro forma cash flow is one of the best tools a business owner can use to plan and manage their income and expenses.

The Perfect Pro Forma Cash Flow

Discover how a pro forma cash flow can help you manage your income and expenses.What is a pro forma cash flow?

  1. What is a pro forma cash flow?
  2. What are the benefits of a pro forma cash flow?
  3. What information does a pro forma cash flow include?
  4. How do I create a pro forma cash flow?
  5. How do I update a pro forma cash flow?
  6. Doesn’t my accounting software do this?

Do you have the perfect pro forma cash flow helping you manage your business?


What is a pro forma cash flow?

The word “pro forma” basically means a projected outcome of financial results. The perfect pro forma cash flow is a projection of inflows and outflows of cash that a business is anticipating. The goal is to make sure the incoming money from marketing and sales activities is enough to pay for expenses as they become due while leaving extra cash in the bank.

Seems simple right?

It’s not and can be very frustrating for the following reasons:

  1. The timing of accounts receivable or money expected from customers never lines up with the timing of accounts payable, or the money is due to vendors and suppliers.
  2. Payroll and taxes need to be paid regularly from excess cash flow, which rarely is available.
  3. There is always a list of outstanding checks or upcoming pre-authorized debits that don’t reflect in the bank account balance.
  4. Every business experiences “one-time” or unbudgeted expenses that are hard to plan.
  5. Running out of cash is always a last-minute and reactive exercise that takes time away from a business owner.

Once you begin to use a pro forma cash flow, you will wonder how you managed your business before having it. Having a clear understanding of your current week and future week cash position will improve how you work your business.


What are the benefits of a pro forma cash flow?

There are many different benefits of having a pro forma cash flow that can change how you manage your business forever.

  • always knowing where your cash is and where it needs to go
  • confidence that you can respond to unexpected expenses
  • actionable insights so you can focus each week on the tasks that matter
  • faster collection of cash
  • easily track pre-authorized subscriptions and payments
  • no more sleepless nights!

Knowing where your cash is and how it is moving through your business is the most important benefit of having a pro forma cash flow.


What information does a pro forma cash flow include?

The perfect pro forma cash flow will account for everything that impacts the inflow and outflow of money every week, including:

  1. Bank balances
  2. Listing of outstanding or uncashed checks
  3. Schedule of monthly pre-authorized payments and debits
  4. Schedule of tax payments
  5. A forecast of accounts receivable
  6. An accounts payable schedule
  7. A payroll schedule
  8. Loan payment schedules
  9. Weekly starting and ending cash balances
  10. Working capital balance

A perfect pro forma cash flow tailored to your business will change how you look at your business and manage it.

Click here for “Common Cash Flow Questions” asked by business owners and entrepreneurs


How do I create a pro forma cash flow?

Your bookkeeper, accountant, controller, or anyone else on your finance team can assemble the information needed to create a practical pro forma cash flow. Most of the information you will need is available through the reports found in your accounting system. Some of the information you will need to create will be based on bank and loan statements.

Microsoft Excel and Google Sheets are the two most popular applications for creating a perfect pro forma cash flow. Individual tabs or sheets get made for each segment of information you have which gets aggregated on a summary tab or sheet.

perfect pro forma cash flow example
Pro forma cash flow template

The best way to compile and present the information is to line up everything with a week number. For example, if you are in week 20 for the year, what financial transactions will occur on week 20? What are the cash inflows and outflows for week 20? Seeing your information every week with a projection for the following weeks is the simplest and easiest way to get a handle on the cash in your business.


How do I update a pro forma cash flow?

It is common practice to update your pro forma cash flow weekly. Many businesses will update a monthly or quarterly cash flow statement; however, this is mainly for reporting purposes, not operational purposes. A company should prepare a pro forma cash flow at the beginning of each working week to provide a projection that should guide the management activities of a business owner. A pro forma cash flow is an active and live resource for business owners to help them get ahead of any anticipated problems while planning for the future.

Having a template that you can update each week should take less than 15 minutes to complete. Make sure you create the template to include the correct calculations and functions. In that case, you should be able to export the information you need from your accounting system and then copy and paste it into your spreadsheet. All of the calculations and functions will automatically update, and you’ll be ready to start the week.


Doesn’t my accounting software do this?

Accounting software is designed to solve common problems and challenges faced by the majority of businesses. Accounting software is not capable and is not designed to be customized to the unique needs of your business. A proper and helpful pro forma cash flow should take into account many different pieces of information from many different sources. Accounting software is meant to record transactions and provide minimal reporting. This is by design because every business is unique. As an entrepreneur or business owner you will want to customize how you view the cash your business has and how it moves around. Accounting software is very limited but can be used to find the information you need to build a pro forma cash flow.


Do you need a Perfect Pro Forma Cash Flow?

Get started now with a private cash flow coaching sessions and a customized template your team can use every week

Do you need the perfect pro forma cash flow for your business? I use a perfect pro forma cash flow for every one of my businesses and I can help you create a template for your business and coach you on how to use it.

Here is what gets included in your template:

  1. 4 personalized 60 minute private coaching sessions to explore and fix your cash flow
  2. A Microsoft Excel or Google Sheets template
  3. Each tab/sheet is set-up so you can copy and paste from your accounting system reports
  4. A tab or sheet summarizing your financial data over eight weeks, including cash inflow and outflows
  5. Individual tabs or sheets that contain specific financial data needed to create the summary
  6. Outstanding checks listing
  7. Accounts receivable detailed listing with expected payment dates
  8. Accounts receivable summary over eight weeks
  9. Accounts payable detailed listing with due dates
  10. Accounts payable summary over eight weeks
  11. A twelve month pre-authorized payment schedule tied to each week payments are due
  12. A twelve month projected payroll schedule detailed by week
  13. A twelve month tax payment schedule detailed by week
  14. A loan schedule for payments detailed by week
  15. 5 hours of dedicated telephone and screen share support within the first 30 days to ensure you and your team can update and use the template properly

Every month I work with 4 business owners to help them create a pro forma cash flow they can use in their business to help them manage their cash. Let’s get started on yours.

Let’s chat.

WHO IS THIS FOR? A business owner that is generating more than $2,000,000 per year in revenue and has an high turnover of cash between accounts receivable and payables

Dylan Gallagher

About me

I own a few businesses and am always looking to help a business owner with theirs.

I know firsthand how important it is to manage cash. I created the Perfect Pro Forma Cash Flow for my businesses, and I guarantee it will help you.

Let’s chat