Accounting, Bookkeeping, and QuickBooks Tips for Small Businesses

Posts tagged QuickBooks Cash Flow Forecast

Projecting Cash Flow Using QuickBooks

Cash Flow QuickBooks
The past two weeks we have discussed how to create a cash flow budget and how to effectively use your cash flow projections. If you are list most small businesses, chances are you are using QuickBooks. Today I’m going to teach you the tools QuickBooks has in place to help you manage your small business cash flow.

The most basic way to keep track of your cash flow in QuickBooks is by using the cash flow reports. QuickBooks offers two cash flow reports – the Statement of Cash Flows and the Cash Flow Forecast.

  • The Statement of Cash Flows shows where your money was spent. You can select various time frames to see how you spent your money. Since this report gives you a retrospect view, it’s not ideal for cash flow forecasting. However, it’s a valuable tool to allow you to see where your money went and how it was used.
  • The Cash Flow Forecast Report helps you forecast how much cash you will have by forecasting your receivables (cash inflows), your payables (cash outflows), and your bank accounts. The great thing about this report is that you are able to customize it to fit your needs. For example, you can specify the date range for your report, change the forecasting periods, and make adjustments for late paying customers. Keep in mind the information provided by this report is limited to the information you have previously posted to your QuickBooks file.

To access these reports, click on the Reports menu, then select Company & Financial from the drop down list, and then select Statement of Cash Flows or Cash Flow Forecast from the list.

Another great tool offered by QuickBooks to help small business owners with their cash flow projections is the Cash Flow Projector. Instead of being a report, it’s a tool to help you forecast your cash flows 6 weeks in advance. Keep in mind, the Cash Flow Projector tool creates cash flow forecasts based on the information you have previously posted to your QuickBooks file. The Cash Flow Projector will take you though a step-by-step process to create your forecast. To access, click on the Company menu, select Planning & Budgeting, and then click on Cash Flow Projector.

There are four steps to setting up your personalized Cash Flow Projector.

  • Determine Your Beginning Cash Balances
  • Project Your Cash Inflows (cash receipts)
  • Enter Cash Outflows (business expenses)
  • Review and Adjust Accounts Payable

Want a sneak peak? At any time you can click the “Preview” button to see what your cash flow projection looks like.

A combination of the cash flow reports and the cash flow projector tool offered by QuickBooks will help you manage your small businesses cash flows. These reports and tools will help you see when your business will have positive cash flows and when your expenses will exceed the cash you bring in. Keep in mind QuickBooks only uses the information you have already entered into your QuickBooks file. Even though these automated reports and tools are nice, make sure you are mindful of your business’ cash inflows, cash outflows, and other things that can impact your cash that are not entered into your QuickBooks file. A proactive approach while using these tools will help ensure the reports and information are as accurate and as useful as possible.


Michelle Edwards, CPA - QuickBooks Consultant Written by Michelle Edwards, CPA
Certified QuickBooks ProAdvisor

Michelle is the owner of Trailhead Accounting Solutions CPA, LLC, an Erie, CO based CPA firm focused on providing small and mid-sized businesses with day-to-day accounting, bookkeeping, and business solutions. Michelle is a CFO turned consultant who loves working with small businesses and entrepreneurs. When she’s not crunching numbers, she can be found hiking, remote camping, gardening, quilting, and hanging out with her family.