Image Alt Text" />Image Alt Text" />
It’s easy to assume that if your business is healthy today, it’ll be healthy tomorrow. But while optimism is important, so is understanding where your business stands financially–both now and in the future.
Monitoring your cash flow and knowing how to run periodic cash flow projections can help prevent future money troubles. If you’re new to cash flow projections, this guide will walk through what you need to know. Keep reading or use these links to jump to a specific part of the guide:
Cash flow projections predict the amount of money entering and leaving your small business. As the name suggests, this method uses cash flow to anticipate future business performance. And cash flow is the net amount of cash and “cash equivalents” that transfers in and out of your business.
This transfer occurs through accounts payable and accounts receivable. Accounts payable is money out, while accounts receivable is money in.
Cash is the lifeblood of a business. Businesses require cash flow to operate, and in the long term, negative cash flow can lead to a variety of issues for a business.
Most businesses face cash flow problems at some point. A survey by QuickBooks found that 60% of small business owners reported that cash flow has been a problem. But if your business experiences negative cash flow, it may be easier to manage if you’ve had time to plan in advance. That’s where cash flow projections can help.
Many business owners mistakenly gauge their business’s health by looking at their business value in assets, intellectual property, and so on. But while these are important for attracting investors or selling your business, they won’t help you predict future business performance. They’re also not factored into cash flow calculations.
Running regular cash flow projections is important because it can help you steer your business toward the future. Rather than making critical plans based on present circumstances, cash flow projections use historical data to help you make a plan for the future, which can be more accurate. The right tools can help you generate accurate cash flow forecasts without requiring manual calculations or spreadsheets to create projections.
Essentially, cash flow projections and cash flow forecasts are the same thing. Both are methods for projecting the business’s financial future. Small business owners can use the terms interchangeably.
Small business owners should take the time to understand their cash flow. Not just to build a solid cash flow projection, but so they can recognize areas of opportunity and potential shortfalls. Follow these steps to perform a month-by-month, year-long cash flow projection. Or use them as a jumping-off point for further talks with your bookkeeper, regarding cash flow projections.
The first step to creating an accurate cash flow projection is to estimate your sales. Start by looking at last year’s numbers using your financial statements. These can help you predict the amount of cash that may come into your business each month next year. You’ll find your business’s credit and cash sales on your monthly income statements. But while the past is the best indicator of the future, you’ll also want to consider some changes.
For instance, if a competitor is moving into your territory, you may want to decrease your sales forecasts. But if you’re adding a new product or service to your offerings, you might expect a slight bump in cash inflow, at least in the short-term.
If you own a new business and don’t yet have a sales history, you will have to use industry research to create a reasonable sales forecast . Be sure to estimate sales for each month, not just the year.
If you operate a business that does mostly cash sales or takes instant payment from customers, you may skip this step.
This step is for business owners who extend credit lines to their customers, send invoices, or take multiple customer payments for a single sale. The idea is to estimate when you will actually receive cash from your sales. To do that, you’ll want to calculate your days sales outstanding (DSO).
The DSO formula first divides your monthly accounts receivable by your total sales. Then it multiplies that number by the number of days in the month. The DSO formula follows:
(Monthly accounts receivable ÷ total sales) x days in the month = DSO
The DSO will tell you the average number of days it takes to receive payment from customers. So if you offer something like 30-day payment terms to your clients, the DSO will tell you how long it actually takes, on average, to receive payment. Then you can incorporate that number into your estimates.
Next, you’ll need to estimate both your fixed and variable expenses monthly. Your fixed expenses (rent, employee salaries, insurance, etc.) don’t change.
Variable expenses tend to fluctuate with your sales. For example, your shipping costs vary because they depend on how many products you sell and ship. Your packaging, raw materials, commissions, and labor costs may also go up and down with your sales volume.
Just as you did for sales, you will need to estimate your fixed and variable expenses for each month of the next year. If you have someone like an accountant in charge of your accounts payable , they’re a great resource here. They can help you go through your sales records and estimate what your next year could look like.
If you don’t have someone who can help you with this process, you can tackle it yourself. Start a spreadsheet with columns for fixed costs and variable costs, and tally them up. Your variable costs will likely be a little trickier since you’ll have to break down many pieces. These pieces include things like material costs, labor costs, product costs, etc. If you’ve calculated your breakeven point , you can pull most of this information from there as well.
Now that you’ve calculated all the numbers you need, it’s time to put them together. Here’s how to run your current month’s projected cash flow.
Begin with the cash balance from last month’s operations, then add this month’s projected receipts, accounting for your DSO. Next, subtract your projected expenses. The formula follows:
(Last month’s cash balance + current month’s projected receipts) – projected expenses = current month’s projected cash flow
Once that’s done, you can calculate your projected cash flow for next month or the next 12 months. To do this, carry the balance from this month’s projected cash flow to the next month, and repeat the steps above. Do this for the next 12 months.
If you find yourself feeling overwhelmed, it may help to use accounting software to automate the process of generating cash flow projections. Some experts also recommend that business owners create a best-case and worst-case scenario to get the most realistic cash flow projection. Your actual cash flow will likely be somewhere in the middle.
You're never too small, and it's never too soon to know you're on track for success.
Start hereOnce you know how to create a cash flow projection, you’ll find plenty of benefits to measure future performance this way.
For many small business owners, cash on hand doesn’t last long. Bills and unexpected emergencies can drain your business’s cash balance and derail your business growth. That’s why it’s critical to know when to pivot and when to stay the course.
A cash flow analysis can help you determine any consistent causes of negative cash flow. And, hopefully, show you when, historically, you have enough cash in your bank account to invest or spend. From there, a cash flow projection can help you understand and predict future cash inflow and cash outflow.
QuickBooks found that nearly three in five small business owners (59%) report that they have made a poor business decision due to concerns about insufficient cash flow. Cash flow projections don’t just increase your understanding. They also help you act with confidence.
Knowing how your business will perform in the coming months, based on actual cash flow data, can enable you to make informed decisions. You can say with confidence if now is a good time to invest in a new opportunity or put money aside. For instance, you may find that, right now, you’re in a period of negative cash flow. But if the coming month looks positive, there’s less need to postpone investments.
Budgets help you stay on course, but cash flow projections show you and others where your business is going. Outsiders—even insiders sometimes—need to know your business’s financial health is sound. Cash flow statements and cash flow forecasts can work together to help them understand your business’s current and future performance.
Accurate financial statements and cash flow forecasts may help you secure a business loan when you’re ready to grow your business. A solid cash flow projection may help you gain future investors or win a new business contract. It could also make your company more attractive to buyers.
While cash flow projections can’t always predict events, they can help you prepare for the worst. For instance, let’s say you know when your business is most cash flow positive. That’s a great time to put aside some extra savings in an emergency fund. Then, if there’s a hiccup, you have a cushion to prevent negative cash flow.
Another example is unpaid invoices. A cash flow projection might tell you there’s a time when those outstanding payments tend to stack up. If you know that problem is likely to occur, you may prevent it with additional communications or early payment incentives.
Cash flow projections are fairly straightforward but incredibly useful. It can be a bit sobering to see your actual cash flow, but this information can only help you make better decisions and grow your business responsibly.
Make cash flow forecasting a part of your business routine, and forecast at least once a year to stay on top of any changes. You can be more in tune with your business and confident in where you’re going.
Recommended for you
Free business budget templates (PDF/Excel) + how to create
What is days sales outstanding? How to calculate and improve DSO
Cash flow guide: Definition, types, how to analyze
We provide third-party links as a convenience and for informational purposes only. Intuit does not endorse or approve these products and services, or the opinions of these corporations or organizations or individuals. Intuit accepts no responsibility for the accuracy, legality, or content on these sites.
**Product information
QuickBooks Live Assisted Bookkeeping: This is a monthly subscription service offering ongoing guidance on how to manage your books that you maintain full ownership and control. When you request a session with a Live Bookkeeper, they can provide guidance on topics including: bookkeeping automation, categorization, financial reports and dashboards, reconciliation, and workflow creation and management. They can also answer specific questions related to your books and your business. Some basic bookkeeping services may not be included and will be determined by your Live Bookkeeper. The Live Bookkeeper will provide help based on the information you provide.
QuickBooks Live Full-Service Bookkeeping: This is a combination service that includes QuickBooks Live Cleanup and QuickBooks Live Monthly Bookkeeping.
1. QuickBooks Online Advanced supports the upload of 1000 transaction lines for invoices at one time. 37% faster based off of internal tests comparing QuickBooks Online regular invoice workflow with QuickBooks Online Advanced multiple invoice workflow.
2. Access to Priority Circle and its benefits are available only to customers located in the 50 United States, including DC, who have an active, paid subscription to QuickBooks Desktop Enterprise or QuickBooks Online Advanced. Eligibility criteria may apply to certain products. When customers no longer have an active, paid subscription, they will not be eligible to receive benefits. Phone and messaging premium support is available 24/7. Support hours exclude occasional downtime due to system and server maintenance, company events, observed U.S. holidays and events beyond our control. Intuit reserves the right to change these hours without notice. Terms, conditions, pricing, service, support options, and support team members are subject to change without notice.
3. For hours of support and how to contact support, click here.
4. With our Tax Penalty Protection: If you receive a tax notice and send it to us within 15-days of the tax notice we will cover the payroll tax penalty, up to $25,000. Additional conditions and restrictions apply. See more information about the guarantee here: https://payroll.intuit.com/disclosure/.
Terms, conditions, pricing, special features, and service and support options subject to change without notice.
QuickBooks Payments: QuickBooks Payments account subject to eligibility criteria, credit, and application approval. Subscription to QuickBooks Online required. Money movement services are provided by Intuit Payments Inc., licensed as a Money Transmitter by the New York State Department of Financial Services. For more information about Intuit Payments' money transmission licenses, please visit https://www.intuit.com/legal/licenses/payment-licenses/.
QuickBooks Money: QuickBooks Money is a standalone Intuit offering that includes QuickBooks Payments and QuickBooks Checking. Intuit accounts are subject to eligibility criteria, credit, and application approval. Banking services provided by and the QuickBooks Visa® Debit Card is issued by Green Dot Bank, Member FDIC, pursuant to license from Visa U.S.A., Inc. Visa is a registered trademark of Visa International Service Association. QuickBooks Money Deposit Account Agreement applies. Banking services and debit card opening are subject to identity verification and approval by Green Dot Bank. Money movement services are provided by Intuit Payments Inc., licensed as a Money Transmitter by the New York State Department of Financial Services.
QuickBooks Commerce Integration: QuickBooks Online and QuickBooks Commerce sold separately. Integration available.
QuickBooks Live Bookkeeping Guided Setup: The QuickBooks Live Bookkeeping Guided Setup is a one-time virtual session with a QuickBooks expert. It’s available to new QuickBooks Online monthly subscribers who are within the first 30 days of their subscription. The QuickBooks Live Bookkeeping Guided Setup service includes: providing the customer with instructions on how to set up chart of accounts; customized invoices and setup reminders; connecting bank accounts and credit cards. The QuickBooks Live Bookkeeping Guided Setup is not available for QuickBooks trial and QuickBooks Self Employed offerings, and does not include desktop migration, Payroll setup or services. Your expert will only guide the process of setting up a QuickBooks Online account. Terms, conditions, pricing, special features, and service and support options subject to change without notice.
