Forecasting Cash Flow in QuickBooks Online

cash flow forecasting in QBO main image

The average small business owner might not be as familiar with cash flow as they should. However, if you’ve got an awesome accountant and/or bookkeeper on your side, they can wax poetic on the virtues of a good cash flow projection.

Once a business starts forecasting cash flow, they’re quickly inspired and empowered by the insights it provides. This is why PayPie has included both monthly and daily cash flow forecasting within its analytics dashboard.

Accountants and bookkeepers who use QuickBooks Online (QBO) know that the Cash Flow Projector tool is only available within QuickBooks Desktop. But hope is not lost! In this article, you’ll learn how to use PayPie to project cash flow by simply connecting a business’ QBO account.

Creating a cash flow forecast in QBO

Put down the pen and paper. Forget about opening Google Sheets or Excel. Simply sign up for PayPie, then connect the business’ account. Forecasting cash flow is really that easy.

The app will then do a deep dive on the business’ financial data, looking at hundreds of variables. (And we’re just getting started…) The assessment of these variables is then presented in a unique analytics dashboard, with all of the cash flow metrics detailed in the cash flow tab.

main dashboard cash flow tab

Learn more about the PayPie QBO integration

Forecasting cash flow — monthly projections

The data for the monthly cash flow forecast pulls from the company’s income statement, balance sheet and cash flow statement. The graph shows three months of actual cash flow and another six months of forecasted cash flow. The forward-looking projections are based on the numbers from the previous three months.

Cash flow is broken into the three main categories:

  • Operating cash flow — inflows and outflows related to the sale of goods and services.
  • Investing cash flow — inflows and outflows that stem from the sale or purchase of capital investments.
  • Financing cash flow — inflows and outflows from borrowing activities or external investors.

Monthly changes in cash flow also helps identify patterns in order to leverage peaks and overcome the valleys.

cash flow forecasting monthly projections

Forecasting cash flow — daily projections

The daily cash flow projection shows the beginning and ending cash balance for each day — based on current and previous data in the business’ main financial reports.

Daily projections help you get more granular in your cash flow analysis. For example, a pattern of negative cash flow days can help pinpoint if a business is giving their vendors more time to pay than their debtors are giving them.

cash flow forecasting daily projections

5 reasons to use PayPie for cash flow forecasting.

Analyzing cash flow — accounts receivable

Receivables and payables are key components of cash flow. With PayPie you can generate an assessment of each one. Assessing accounts receivable helps identify overly generous credit terms and outstanding invoices that negatively impact cash flow and a business’ overall financial health.

In the accounts receivable analysis, you’ll be able to quickly access:

  • Total invoices raised — for a period of 12 months, regardless of whether the invoices are open or closed.
  • Monthly invoices, payments and open AR — laid out in a convenient bar graph. (Open AR = (previous month’s open AR + current month’s invoices) – payments.)
  • Top five exposures — showing which customers represent the highest amounts of outstanding invoices.

accounts receivable

Analyzing cash flow — accounts payable

Just as accounts receivable shows inflows, accounts payable details outflows. Crucially, if there are late payments which affect the business’ short- and long-term credit profile, as lenders base their conditions on previous payment histories.

The accounts payable analysis features:

  • Total bills received — for a period of 12 months, regardless of whether the bills are paid or unpaid.
  • Monthly bills, payments and open AP — laid out in a convenient bar graph. (Open AP = (previous month’s open AP + current month’s bills) – payments.)
  • Top 5 exposures — showing which vendors represent the highest amounts of outstanding bills.

accounts payable

Comparing income to expenses

In order to provide a historical and top-level perspective, PayPie also graphs total income and expenses for a period of 12 months. This yet another way to highlight trends, such as when expenses either exceed or come close to surpassing income.

income and expenses

Generating a breakdown of expenses

Delving further into examining cash outflows, PayPie’s cash flow analysis also breaks down expenses on a monthly basis, displaying 12 consecutive months. It’s a quick way to provide a snapshot of a business’ main expenses throughout the year.

expense breakdown

Handy reference — basic cash flow terms and concepts.

Creating a cash flow statement in QBO

If all you want to do is create a cash flow statement, simply go to the QBO reports tab and select “statement of cash flows.” However, why have just a cash flow statement when you can have a comprehensive cash flow forecast? Plus, our dashboard includes a cash flow statement as well.

cash flow statement in dashboard

Assessing credit risk

The main question that PayPie’s financial analysis answers is, “How does my business look in front of lenders?” We provide insights into cash flow as it’s closely tied to determining the business’ ability to manage its finances and credit.

However, our algorithm also examines a range of variables related to risk in order to create a proprietary risk score. Unlike traditional credit scores, it’s based on a business’ own real-time accounting data, instead of third-party sources. It doesn’t replace a traditional credit score. Instead, it serves as an internal benchmark of how the business is currently performing.

If a business is planning grown and knows that it’ll need funding in the future, it can use the risk score and the insights from the assessment to be better prepared when applying for financing.

risk score

Taking action through insights

If you’re taking the time to forecast cash flow and evaluate risk, you’re already interested in troubleshooting. But you’re also interested in solutions as well. This is why PayPie also includes a list of targeted insights, that pinpoint problem areas which need to be addressed.

These insights into financial health and borrowing capacity include:

  • Cash flow coverage ratio — the ability to pay interest and principal amounts on borrowed funds.
  • Creditor days — the average amount of time needed to settle debts with trade suppliers.
  • Current ratio — the ability to meet short-term debt obligations within the next 12 months.
  • Debt-to-equity ratio — shows how much debt is used to run the business as well as the value of the assets compared to the debt.
  • Debtor days — how long it’s taking to collect payment from debtors.
  • Interest coverage ratio — determines how easily a business can pay interest expenses on outstanding debt.
  • Leverage ratio — how much operating and financing leverage a business has in order to manage debt or acquire additional funds.
  • Net worth — the total value of the assets after all debts are paid.
  • Return on capital employed — how well a business’ capital investments are paying off.
  • Revenue growth — compared year over year.

insights (2)

Start forecasting cash flow today. Sign up for PayPie and connect your business.

PayPie’s cash flow forecasting is currently free. In the future, each user will be limited to two businesses. Volume pricing for accountants and bookkeepers will also be introduced.

In the meantime, try it out and let us know what you think. We mean it, we value your feedback.

QuickBooks and QuickBooks Online are registered trademarks of Intuit Inc. PayPie integrates with QuickBooks Online. It does not integrate with QuickBooks Desktop. 

The information in this article is not financial advice. It does not replace the expertise that comes from working with an accountant, bookkeeper or financial professional. 

Stock image via Pexels. App images via a PayPie demo account. 

PayPie’s QuickBooks Integration – What You Need to Know

PayPie QuickBooks Online Integration

They’re not media darlings or mythical unicorns, they’re the hard-working people giving everything they’ve got to make their businesses a success. In fact, 99% of all the businesses in the world are small businesses.

In spite of their diligent efforts, 60% of small to medium-sized enterprises (SMEs) that fail point to cash flow. There’s also lack of funding to bolster cash flow with 1 in 5 SMEs being turned down by banks and traditional lenders. What’s worse, is that many SMEs don’t know the reasons why or even how to improve their chances.

The power of a one-click risk assessment  

There’s no question that QuickBooks Online is a smarter business tool for the world’s hardest workers — small business owners. That’s why PayPie is excited to integrate with QuickBooks Online to offer these businesses powerful, intuitive, one-click risk assessment — based on a business’ own first-hand accounting data.

While expense tracking, payments and other day-to-day business functions can be easily automated, if an SME wants to know their business credit rating, they have to rely on an outdated system based on second-hand information. That is, until now.

With PayPie all you have to do is create a PayPie account, then connect your QuickBooks Online account. It’s that simple and your near-real-time credit score will be generated in seconds.

main dashboard

Hundreds of variables, one concise indicator

PayPie analyzes the financial data in the business’ QuickBooks Online account. Our application sorts the data into key variables and indicators, which are then further divided into two main categories — risk assessment and cash flow analysis.

The risk score, the focal point of the dashboard, is a capstone or synthesis of all the risk assessment variables. Like a car odometer, the risk score shows if the business is accelerating, resting at a comfortable cruising speed or losing momentum.

The table below breaks down some of the variables and indicators that PayPie uses to assess risk — factors that small business lenders often use their own assessments:

elements of risk assessmen

The added value of cash flow forecasting 

Risk assessment is to cash flow as a chicken is to an egg. You can’t have one without the other. Businesses need cash flow to survive. As such, they need to be aware of exactly how and when the cash flows in and out of their business. Cash flow forecasting also helps businesses predict when they’ll need funding — letting them plan and prepare to apply for these funds more effectively.

PayPie helps SMEs monitor cash flow by:

  • Detailing accounts receivable and payable exposures.
  • Comparing income to expenses.
  • Analyzing categories of expenses.
  • Projecting monthly cash flow.
  • Providing a daily cash position.

AR days overdue

Daily cash flow forecast

Learn 5 reasons why you should use PayPie for cash flow forecasting

Risk assessment that includes solutions

In developing their analytics dashboard, PayPie didn’t want to provide just a series of charts and graphs alone. They also wanted to offer solutions. This is why each assessment also includes a list of insights that show businesses which goals they’re achieving and where they’re reaching their goals and where they can improve.

Our insights that help SMEs improve their financial health and increase their chances of getting the funding they need include:

  • Evaluations of key liquidity ratios.
  • Comparisons to industry benchmarks.
  • Generation and investment of operating cash flow.
  • Debt and repayment indicators.
  • Return on capital employed.

risk assessment with insights

Financial tools for businesses, accountants and bookkeepers

Any business, accountant or bookkeeper using QuickBooks Online can use PayPie’s risk assessment and cash flow forecasting. We want to put these tools into the hands of the people who need them the most — whether it’s the businesses themselves or the financial professionals who consult and advise them.

Unless you’ve been stranded on a desert island or huddled in a safe room, you know that technology is set to transform accounting. This “Fourth Industrial Revolution” will also change the relationship between accountants, bookkeepers and businesses.

When all the basics are covered and simplified by automation, there’s more time to focus on conceptual and insight-based tasks, like cash flow consulting. The more businesses know about their current and future cash flow, the more able they are to make strategic, data-backed decisions.

Learn more about how cash flow consulting benefits businesses and accountants alike. 

Look better in front of lenders.
Improve your cash flow.
Grow your business.

“Every day, small businesses struggle with a lack of accurate and efficient ways to assess risk and accesss funding. We’re leveling the playing field so that SMEs can seize upon further opportunities for growth.”
Nick Chandi, PayPie CEO and Co-Founder

We invite you to try PayPie and we can’t wait to hear what you think

See more reviews and insights via FitSmallBusiness

In addition to our listing in the QuickBooks App Store, you can also learn more about PayPie in our listing within the 2018 Small Business Accounting Software Reviews & Pricing Guide.

QuickBooks, QuickBooks Online, QuickBooks Connect and the Small Business App Showdown are registered trademarks of Intuit Inc. 

The information in this article is not financial advice. It does not replace the expertise that comes from working with an accountant, bookkeeper or financial professional. 

10 Reasons Accountants Should Offer Cash Flow Consulting

ccountant offering cash flow consulting

If you’re an accountant who serves small to medium-sized enterprises (SMEs), why should you consider providing cash flow consulting as part of your value-added services?

If like us, you’re dedicated to giving businesses the tools they need to forecast cash flow and strengthen their long-term financial health, here are 10 reasons why you should offer cash flow consulting:

  1. Most businesses are small businesses

Globally, there are more small businesses than any other kind of business. Consider these numbers: 99.9% of all US businesses, 97.9% of Canadian businesses and 99% of all businesses in the world are small businesses.

Most accounting firms are also small businesses. For example, 90% of all accounting firms in the United States have less than 10 partners or owners.

Case Study: Cash Flow Consulting in the Real World 

  1. Accountants are trusted advisors

Like attracts like. If you’re a small business looking for a professional accountant, are you going to go knocking at the door of a major accounting firm with retainer fees as high as the skyscrapers that house their employees?

Or, are you going to look for a small to medium-sized accounting practice (SMP) that’s more reasonably priced and more likely to understand your needs?

The answer is obvious. It is also why most small businesses consider their accountant their most trusted advisor.

  • A majority (92.2%) of accountants provide basic accounting and bookkeeping services.
  • Only 77.7% offer business consulting services, like cash flow analysis and forecasting.

Offering cash flow consulting will give you an edge on the competition. At the same time, it will also help you forge stronger bonds with your clients.

cash flow consulting opportunity

  1. Cash flow is a small business killer

More than half of small businesses never make it past the first five years. The main culprit is cash flow.

  • Studies of the U.S. market conducted by Wasp Barcode have found that 33% of small businesses said cash flow was a top business challenge and 44% found cash flow a top accounting challenge.
  • A similar SCORE study indicated that 22% of small businesses said that cash flow was their main concern.

It’s not that these businesses don’t understand that they need to have the right amount of money to meet their financial obligations. Instead, they just don’t have the correct tools, technologies and processes in place.

By helping your clients master cash flow management, you’ll be teaching them vital survival skills. You’ll also be building mutually respectful long-term relationships.

Forbes Article: How SMEs Can Win the Battle for Positive Cash Flow 

  1. There are intuitive forecasting tools

You don’t have to go and design proprietary systems to create a powerful and meaningful cash flow analysis. Automated tools, like our cash flow forecasting, make it simple to create an informative, intuitive report filled with key ratios, charts and graphs.

All you have to do is connect the business’ QuickBooks Online account with PayPie, then run the report. The forecast is built using near-real-time data from the company’s QBO account. (Integrations with other accounting software and platforms are coming soon.)

PayPie Cash Flow Forecast Example

  1. Technology is changing everything

“CPAs with technology: You have the power to change your customers’ lives.”

Jody Padar, CPA, MST, Accounting Today

With the rise of cloud-based technology, these three trends are changing how small business accountants are interacting with their clients:

  • Digitalization— As more small business data is available digitally, through the use of accounting software and applications, it’s also easier for accountants and bookkeepers to access this information.
  • Virtualization — Because cloud-based technologies can be accessed from any device with an internet connection, it’s no longer necessary for accountants to physically visit clients. Accountants and businesses can work together from virtually anywhere.
  • Transformation — With the greater availability of near-real-time data, accountants are moving from generalized to specialized services.

Read More: How Cash Flow Consulting Helps Businesses 

  1. Cash flow consulting builds value

“The ability to provide business intelligence from a quick analysis of data is a miracle.”

— Geoffrey Moore, technology author and business consultant

Complying with regulations and paying taxes are services that business owners see as have-to-dos. Accountants who take the creation of financial statements one step further by producing cash flow forecasts are transforming routine tasks into recurring, value-added services.

Rather than merely reporting results, cash flow consulting is a key component in business growth. Some advisors even set up monthly consultation calls or video conferences with their clients to discuss goals and objectives — literally becoming voices in the business decision-making process.

Pro Tips: Cash Flow Forecasting — What You Need to Know 

  1. Business financing goes hand-in-hand with cash flow consulting

As you help businesses better understand when, why and how the cash flows in and out of their companies, your clients may also rely on your advice for short-term and alternative lending solutions.

In addition to standard options, like term loans, lines of credit and credit cards, you can also introduce the businesses you serve to innovative financing solutions, like invoice factoring, powered by blockchain technology.

  1. Better cash flow lowers risk

The cash flow forecasts created using PayPie’s insights and analysis also contains a risk score that summarizes and reflects several key variables linked to cash flow. This indicator shows how a business is viewed by lenders, vendors and other third parties wishing to do business with them.

Helping a business improve their cash flow also improves their risk score. With a better risk profile, businesses can access funding more easily and set more favorable terms with vendors.

Cash Flow Basics: How to Read a Cash Flow Statement 

  1. Better cash flow builds confidence

As you work with your clients reviewing cash flow, setting goals, controlling costs and planning for future investments and opportunities —you’re not only improving the business’ financial health, you’re also bolstering the owner’s confidence.

As you go through a cash flow forecast, especially the day-to-day costs involved in operational cash flow, you get a better sense of where the client’s priorities lie, which concepts they understand the most and the areas that need the most improvement.

In a nutshell, you’re able to ask the hard questions and offer informed solutions that truly benefit the bottom line.

5 Reasons to Use PayPie for a Cash Flow Forecast

  1. Cash flow consulting makes you a better advocate

“Running a small business is about the grind, the day-to-day operations and finding a way to keep your head above water. Like the shock of cold water in the ice-bucket challenge, reality can hit you hard and all of those hours picking paint colors for the office suddenly seem wasted. Small businesses inherently overlook the technology platforms that help them manage their day to day — and that’s exactly how cash flow begins to erode.”

— Stacy Gentile, Forbes Communication Council

Managing finances isn’t always the most alluring part of owning a business, but it’s fundamental for success. Cash flow consulting takes the implementation of best practices and better tools to a new level by delivering tangible results in the form of more cash. And no one can dispute the value of money in the bank.

Be a cash flow advocate — try our cash flow forecasting for QBO users today.

PayPie currently integrates with QuickBooks Online. Additional integrations are coming soon.

This article is informational only. It does not replace the expertise that comes from working with an accountant, bookkeeper or financial professional.

Image via Shutterstock