Header_Blue_Flame_2.png

How to Forecast Cash Flow in QuickBooks

BY Eddy Hood In QuickBooks, Forecast, CashFlow On Aug 15, 2017 With 1 Comment

 

qbo


You may have heard the saying, “cash flow is the lifeblood of the business” and we couldn’t agree more. Closely monitoring your cash flow lets you know how well you can meet upcoming expenses, service debt and reinvest in your company. In addition, creating regular cash flow projections will help you plan for future growth and anticipate potential pitfalls in your cash position that need your attention. Your online bookkeeping provider can take care of these needs on your behalf to ensure that you have access to the most accurate and timely information.

Before taking a look at how to forecast cash flow in QuickBooks, let’s go over some cash flow basics:

 

WHAT IS CASH FLOW

Cash flow refers to the difference between cash coming into your company at the beginning of an accounting period and cash leaving at the end of the period. Cash comes in when customers pay for your services, when you borrow funds or when you sell an asset such as real estate. Cash leaves the business in the form of payments for day-to-expenses, rent and other accounts payable, as well as to service debt or purchase an asset.

As a business owner, it may be tempting to focus your attention solely on boosting your bottom line. However, it is possible (and common) to report a positive net income (i.e. profits) and a negative cash flow due to timing differences in the reporting of income and the receipt of cash. The same concept applies to paying for expenses and settling accounts payable. Therefore, analyzing the Income Statement in isolation will not tell you if you generated enough cash to keep the doors open.

Here are some key components that aren’t included in the calculation of net income but which impact your company’s cash position:

  1. Accounts receivable
  2. Inventory
  3. Accounts payable
  4. Capital expenditures
  5. Debt repayments

 

Here’s a quick example:

Let's say XYZ Company posted a net profit of $30,000 for the quarter ended March 31, 2017.

Sales ---------------------- $100,000

COGS ---------------------$50,000

Gross Profit --------------$50,000

Operating Expenses ----$20,000

Net Profit ----------------$30,000

This may seem like great news for the company because they doubled profits compared to the same period last year. However, a closer look at their cash position reveals that XYZ Company only collected $50,000 in cash from sales during the first quarter. Assuming there were no other cash inflows and that all payables have been taken care of the company actually has a negative cash position at this time.

 

HOW TO CREATE A STATEMENT OF CASH FLOW

The statement of cash flow is separated in three sections to highlight the fact that businesses can generate cash in several ways:

Cash_flow.jpgTHREE TYPES OF CASH FLOW

Operating Cash Flow

Also known as cash from operating activities, this line item measures the amount of cash generated from a company’s core business activities such as providing services or selling merchandise. This is an important measure because it indicates how well a company generates sufficient positive cash flow to maintain and grow its operations.

Investing Cash Flow

As the name suggests, this line item reports changes to the company's cash position resulting from the purchases or sales of assets equipment, property or a subsidiary in addition to any gains (or losses) from investments in financial instruments. Changes in items reflected in the asset section of the balance sheet are recorded here.

This section is important because it highlights the company’s growth trajectory. For example, an increase in capital expenditures means the company is investing in future operations, though it also represents a reduction in cash flow needed to make that happen.

Financing Cash Flow

This line item shows the cash inflows and outflows related to transactions with the owners or lenders of the company AKA the providers of financing. Cash flow from financing activities include:

  1. Issuance of stock (positive cash flow)
  2. Proceeds from borrowing debt (positive cash flow)
  3. Repayment to creditors (negative cash flow)
  4. Payment to owners in the form of dividends (negative cash flow)

This is an important line item because it can highlight important sources of cash when a company is experiencing negative or low cash flow from operating activities.

Putting it all together: To create a cash flow statement, review your income and expenses in each of the these three areas. You can then organize this information in a spreadsheet that can be easily updated as required.

As your business grows, you may need to enlist the help of online bookkeeping professionals who can prepare accurate financial statements on your behalf.

 

HOW TO RUN A STATEMENT OF CASH FLOW IN QUICKBOOKS

quickbooks-logo.jpgIt is important to remember that the statement of cash flow pulls several key numbers from both the Income Statement and the Balance Sheet. Therefore, the following are must-do’s before running your cash flow report in QuickBooks:

  1. Update QuickBooks with all income and expenses.
  2. Ensure all assets and liabilities have been recorded in QuickBooks.
  3. Double check that all information contained in your Income Statement report is accurate.
  4. Reconcile all bank accounts.
  5. Seek guidance from your online bookkeeping provider as needed.

Now that your QuickBooks is up-to-date, it’s time to run your cash flow report:

  1. Launch QuickBooks.
  2. Choose Reports > All Reports.
  3. Click Business Overview.
  4. Locate the Statement of Cash Flows from the drop down menu.
  5. Select the time period you’d like to review.
  6. View the report that QuickBooks generates based on your receivables, payables and bank account information.
  7. Print the report or send a copy to your team members by email.

Review your statement of cash flow each month to ensure that you don’t miss any detail such as an upcoming invoice that could lead to a short-term cash crisis.

 

HOW TO FORECAST CASH FLOW

forecast.jpg

As we mentioned above, putting together cash flow projections on a regular basis is important to ensuring the long-term viability of your business. Looking at past performance is an excellent starting point. However, be sure to account for anticipated changes as your business evolves. Such changes could include the launch of a new product line or the roll out of a special promotion and marketing campaign. You should also incorporate external data such as the impact of your competition to ensure that your estimates are as realistic as possible.

Keep in mind that potential creditors will want to see your cash flow projections and accompanying explanations for how you came up with the numbers. Overall, it’s important to be conservative in your projections: lower your expected income and increase your anticipated expenses. It’s always better to underestimate and over deliver instead of the reverse.You can download our free cash flow forecast tool in Excel to master your cash flow projections.

QuickBooks also offers a simple but powerful tool called the Cash Flow Projector that can help you to forecast your cash flow. This feature essentially allows you to perform scenario analysis and view projections without altering the data in your actual QuickBooks ledger.

Note: The Cash Flow Projector is only available on QuickBooks Desktop and not QuickBooks Online.Here are the steps to forecast cash flow in QuickBooks:

  1. Launch QuickBooks.
  2. Choose Company > Planning & Budgeting.
  3. Click on the Cash Flow Projector option from the drop down menu.
  4. Choose the bank accounts you want to use for your projections.
  5. Projecting Cash Receipts. There are a number of ways to project your cash receipts for the next six weeks. This is particularly useful for businesses that have seasonal cash flow. Using the Cash Projector, you can:
  6. Project cash receipts manually
  7. Use an average of the last 6 weeks
  8. Use a weighted average of the last 6 weeks
  9. Use the same 6 week period last year
  10. Use the average of the same 6 week period last year
  11. Estimating Business Expenses: You can select upcoming business expenses such as salaries along with the frequency of the payments.
  12. Projecting Accounts Payable: This screen will detail out all the open accounts payable figures that exist in your QuickBooks and accompanying due dates.
  13. Print the report or export it to PDF.

 

TIPS FOR IMPROVING CASH FLOW MANAGEMENT

Now that you have a good understanding of how to forecast cash flow in QuickBooks, it’s time to look at a few ways to improve cash flow:

Determine Your Break-Even Point

The break-even point is the amount of sales you need to generate just to produce a profit of zero. Here’s the calculation for the break-even point:

Break-even Point = (Overhead Expenses + Balance Sheet Payments) / Gross MarginAnything above this number is considered profit. Knowing your break-even point provides an excellent benchmark to projecting future cash flow. It provides a target in terms of the amount of business you need to generate in order to be profitable. However, as we know profits alone won’t keep the doors open. Focusing your efforts on managing your cash flow effectively while working toward realizing profits above the break-even point creates a winning strategy when it comes to the financial success of your business.

Related: Be sure to check out our video tutorial for more information on calculating your break-even point.Establish a Rainy Day Fund Building up your cash reserves is important because it can serve as a safety net for your business in the event of cash shortfalls. Some experts recommend having three months of expenses in your cash reserves. Others recommend six months. However, the size of your cash reserves will depend on how much cash your business typically goes through in a given month and also the projected changes to your cash position in the upcoming weeks and months. You can speak to your outsourced provider for more guidance on the right number. Have a Few Other Backup PlansScreen Shot 2017-08-14 at 8.07.10 AM.png

Apply for a line of credit before you actually need it. A line of credit can be more advantageous than a loan because you only have to pay interest on the funds that you access. In addition, you should also identify which of your assets are most liquid (easily convertible to cash) since you may need to offload them if you find yourself in a cash crisis.

Collect Receivables Quicker

Customers tend to respect companies that have strict payment terms and who push hard for collections. It shows that you mean business. In order to improve collections, consider limiting the number of customer that would approve for purchasing on credit. For those you do give credit terms to, offer early payment discounts to incentivize timely payments. The most common is 1% 10/net 30 which means that if the bill is paid within 10 days, there is a 1% discount.

Get Rid of Manual ProcessesAnother great way to speed up collections is to deliver invoices electronically. The quicker the customer receives that invoice the quicker they can settle it. Further, manual processes like printing and mailing invoices generally takes up many hours -- hours that your team could be spending on revenue-generating activities. Extend Payables Window Where PossibleWhile you want customers to settle their invoices as quickly as possible, it is in your best interest to extend your payables to net-60 or net-90, if possible. Maintaining a good relationship and strong lines of communication with your vendors can also come in handy if you find yourself strapped for cash at some point. Make the Switch to the Cloud

Online bookkeeping refers to storing your accounting software in the cloud. This means you can access your to real-time data to make the most informed decisions possible about your business future. The cloud is a lot safer than you may think especially if you leverage the scalability of an online bookkeeping provider who can afford to invest in state-of-the-art infrastructure and cloud security.

Leave it to the ProfessionalsAs you can see, there are a lot of moving parts when it comes to managing your cash flow and creating cash flow projections. Taking advantage of online bookkeeping services to help you manage these processes will allow you to focus on what you do best -- building better client relationships and learning new ways to grow your business.

We hope this tutorial answered your questions on cash flow management and how to forecast cash flow in QuickBooks. Be sure to check out our online bookkeeping services and accounting resources for more information to help you manage your business needs.

New Call-to-action

My name is Eddy Hood. I've coached over 500 businesses on how to become more profitable. I'm the Founder & CEO of Ignite Spot, and I have mad parallel parking skills.

Leave a Comment About This Blog Post