• About
    • About Accru
    • The Accru Advantage
    • Testimonials
    • Our People
    • Our Services
    • International Affiliations
    • Corporate Social Responsibility
    • Join the Accru Network
    • Careers
  • Locations
    • Accru Felsers Sydney
    • Accru Melbourne
    • Accru Rawsons Brisbane
    • Accru Perth
    • Accru Harris Orchard Adelaide
    • Accru Hobart
  • News & Tools
    • News
    • Publications
    • Accru Tax Guide 2017/18 App
    • Fact Sheets
    • Online Portfolio Links
    • Useful Business Websites
  • Careers
    • Working with Accru
    • Culture & Values
    • Accru in the Community
    • Current Vacancies
  • Contact Us
Client Login
Accru Logo Skip to content
  • COVID-19
  • Accounting
    • Cloud Accounting
    • Outsourced Accounting
    • CFO Services
    • Corporate Compliance
    • Find an Expert
    • Testimonials
  • Audit
    • External Audit
    • Internal Audits
    • SMSF Audits
    • Due Diligence
    • Data Analytics
    • Payroll Data Analytics
    • Find an Expert
    • Testimonials
  • Business Advisory
    • Business Management
    • M&A and Business Sales
    • Valuations
    • Restructures
    • Succession Planning
    • Business Turnaround
    • Management Consulting
    • Find an Expert
    • Testimonials
  • Taxation
    • Tax Compliance
    • Tax Advisory
    • FBT & Salary Packaging
    • GST & Indirect Tax
    • International Tax
    • Find an Expert
    • Testimonials
  • Wealth Management
    • Wealth Creation
    • Superannuation & Retirement Planning
    • Self Managed Super Funds
    • Estate Planning
    • Find an Expert
    • Testimonials
  • Finance & Insurance
    • Mortgage Broking
    • Commercial Finance
    • Risk Insurance
    • Find an Expert
    • Testimonials
  • International Business
    • Services for German-speaking companies
    • Services for Chinese-speaking companies
    • Starting a business in Australia
    • Expanding overseas
    • Transfer Pricing Australia
    • International Tax
    • Find an Expert
  • Industries
    • Pharmacies
    • Medical Practitioners
    • Not-for-Profit
    • Education
    • Property & Construction
    • Professional Services
    • Manufacturing & Distribution
    • Finance & Investment
    • Retail
    • Digital, Media, Emerging Technologies
Client Login
  • Accru Acccountants | Audit | Tax | Business Advisory
  • Services
  • About
    • About Accru
    • The Accru advantage: quality, innovation and value
    • Testimonials
    • Our People
    • International Affiliations
    • Corporate Social Responsibility
    • Join the Accru Network
    • Careers
  • Locations
    • All Locations
    • Accru Felsers Sydney
    • Accru Melbourne
    • Accru Rawsons Brisbane
    • Accru Perth
    • Accru Harris Orchard Adelaide
    • Accru Hobart
  • News & Tools
    • News
    • Publications
    • Accru Tax Guide 2017/18 App
    • Fact Sheets
    • Online Portfolio Links
    • Useful Business Websites
  • Careers
    • Careers
    • Working with Accru
    • Culture & Values
    • Accru in the Community
    • Current Vacancies
  • Contact Us
Facebook LinkedIn Twitter Youtube
Accru logo

How to create a cash flow forecast for your business

By Will Merdy / June 27, 2018

Forecasting your cash inflows can be highly unpredictable (especially at startup!) but it’s vital to the survival of your business. You don’t want to find yourself short on cash when you need it most and of course you’ll want to know when you can finally draw money from the business! A cash flow forecast is essential for this. So how do you create a cash flow forecast for your business?

Cashflow forecast road to financial future 292069262 SMALL

What is a cash flow forecast?

At its simplest level, a cash flow forecast is a timeline with predicted cash inflows and outflows.

Looking at your accounting software reports can help you forecast cash flow, but these reports only tell one side of the story as they’re typically on an ‘accruals’ basis – they tell you when an expense occurs but not when the cash is paid. Other available reports only track cash flows once they have already happened. However, with Excel, you can put your forecast figures into a spreadsheet and roll it into the next month or year for quick updates so you know if you’re likely to be in the ‘black’ or ‘red’ and by how much.

Steps to create a cash flow forecast

The best approach to cash flow forecasting is to start with some assumptions and break your revenue and expenses into ‘inflows’ and ‘outflows’.

1. Choose a cash ‘float’ amount
The first step is to build a ‘float’ or set a minimum cash balance for your budget. This helps ensure you keep money aside for unexpected expenses.

2. Predict inflows
Check your debtor balance at the beginning of the month. Estimate the percentage of this balance that you think will arrive in cash for that budget month. Then add in the new sales which will be paid that month. (Using a percentage of past sales can give you an estimate). If you don’t already have sales forecasts, creating these will also help predict cash inflows.

3. Predict outflows
Make a list of your expenses – start with fixed costs like rent and wages. Make sure to include ‘seasonal’ annual fixed costs such as insurances or employee bonuses at Christmas, and expenses like superannuation and PAYG Withholding for employees. Think of this as money you have already ‘spent’ Once you add the fixed costs and payments for a ‘normal’ month, add variable costs. Don’t forget any variable GST or income tax payable to the ATO and try setting GST and income tax amounts aside if you normally end up with a payable. It’s also advisable to plan for prior years’ catch-up income tax that might arise 11 months later for payment!

4. Create your monthly ‘spending budget’
Once you have estimated total fixed and variable costs, add this to your float amount. This is your spending budget for the month. If your forecast looks good… If your inflows cover your ‘spending budget’ with plenty left over, then this will help you know what you can afford to spend on capital equipment, expanding operations, repaying investors and most importantly whether you can ‘cash in’ and draw money out yourself!

What if your ‘spending budget’ is greater than your inflows?

If your ‘spending budget’ looks as if it won’t cover your estimated ‘cash plus cash inflows’ for a particular month, it’s time to look at ways to improve your cash flow, or perhaps set aside larger amounts of cash from the ‘good’ months to help with seasonal expenses. See our article simple strategies for cash flow problems for some suggestions.

Accru can help you with cashflow forecasting as part of our accounting and business management services. Contact your local Accru advisor to find out more.

About the Author

Will Merdy, Accru Felsers Sydney

Will has over a decade of experience in chartered accounting practice with specialised expertise in taxation consulting. Working with both large international clients and small-to-medium businesses across a wide range of industries, including IT consulting, construction and childcare, he is known for his excellent analytical skills and ability to utilise business intelligence software. Read more.

One Response to “How to create a cash flow forecast for your business”

  1. Garrett says:
    November 17, 2018 at 11:59 am

    Just like the weather forecast, the reality may turn out to be different, but it’s still better to work with some view of what lies ahead. Otherwise, yep, you run the risk of not setting aside enough cash for the lean times–or not investing enough in the future looking at from the other side of the spectrum.

    Reply

Leave a Reply

Your email address will not be published

Cancel

News & Tools

  • All News
  • All
    • Business Growth
    • Digital Business
    • Financial Management
    • International Business
    • Audit Risk & Assurance
    • Tax Essentials
    • Wealth & Superannuation
    • Accru News
  • Publications
  • Accru Tax Guide 2017/18 App
  • Fact Sheets
  • Online Portfolio Links
  • Useful Business Websites

Subscribe to our Newsletter

Subscribe to the Accru Newsletter Subscribe

Latest News

An Audit – preparing your business for sale
Read article

Accru Top
Services
  • Accounting
  • Audit
  • Business Advisory
  • Taxation
  • Wealth Management
  • Finance & Insurance
  • International Business
  • Industry Sectors
About Us
  • About Accru
  • The Accru advantage: quality, innovation and value
    • Starting a Business
    • Expanding a Business
    • Reaping the Rewards
  • Testimonials
  • Our People
  • Our Services
  • International Affiliations
  • Corporate Social Responsibility
  • Join the Accru Network
  • Careers
Locations
  • Sydney
  • Melbourne
  • Brisbane
  • Perth
  • Adelaide
  • Hobart
News & Tools
  • News
    • Business Growth
    • Finance & Insurance
    • International Business
    • Risk & Assurance
    • Tax & Accounting
    • Wealth & Superannuation
    • Publications
  • Accru Tax Guide 2017/18 App
  • Fact Sheets
  • Online Portfolio Links
  • Useful Business Websites

Follow Accru Australia

Facebook LinkedIn Twitter Youtube
Subscribe to Accru's e-news

Accru's e-news updates are designed to keep you up to-to-date on essential business topics.

Subscribe

© 2021 Accru

Terms of Use | Privacy Policy

Site by Click2It

×