All resources
Free Excel Tool

Your business made a profit. So where did the cash go?

The Vertex Profit vs. Cash Diagnostic helps you bridge the gap between accounting profit and the actual change in your cash balance, so you can see what generated cash, what absorbed it, and what deserves a closer look.

Microsoft Excel • Free download • No signup required

Why it matters

Profit and cash are not the same thing

A business can report a profit while its cash balance declines. It can also lose money while cash temporarily increases.

That's because accounting profit measures financial performance, while cash is also affected by changes in receivables, inventory, supplier balances, capital investments, borrowing, debt repayments, owner distributions and other balance-sheet movements.

Understanding the difference can give business owners a much clearer picture of what's actually happening financially.

The bridge

See what happened between profit and cash

01

Net Profit

The starting point: the profit reported on your income statement for the period.

02

Non-Cash Items

Some accounting expenses affect profit without using cash during the period.

03

Working Capital

Changes in receivables, inventory, payables and other operating balances can absorb or release cash.

04

Investing Activity

Equipment, capital expenditures and other investments can use cash without immediately reducing profit by the same amount.

05

Financing & Owner Activity

Borrowing, debt repayments, owner contributions and distributions affect cash without being operating revenue or expenses.

06

Change in Cash

The resulting movement between your beginning and ending cash balances for the period.

Common cash movements

Where can the cash go?

Accounts Receivable

Revenue can be recorded before customers have actually paid.

Inventory

Purchasing inventory can absorb cash before the related cost appears in profit.

Capital Expenditures

Equipment and other long-term assets can require significant cash even though the full cost isn't immediately reflected in profit.

Debt Repayments

Principal repayments reduce cash but aren't an operating expense.

Owner Distributions

Cash taken out by owners reduces the business's cash balance without reducing accounting profit.

Other Balance-Sheet Movements

Payables, accruals, tax balances and other accounts can also affect cash timing.

Important context

A cash outflow isn't automatically bad

Cash may decline because the business is investing in equipment, paying down debt, building inventory for expected growth or distributing cash to owners.

Likewise, an increase in cash isn't automatically a sign of stronger performance. New borrowing, owner contributions or slower supplier payments can increase cash without improving profitability.

The goal of the diagnostic isn't to label cash movements as good or bad. It's to help you understand what happened.

Reconcile profit to the change in your cash

Enter financial information from your income statement and balance sheet to build a structured bridge between reported profit and the actual movement in cash.

Profit-to-Cash BridgeReconciled based on information entered
Net Profit
Working Capital Impact
Capital Expenditures
Ending Cash
Profit to cash movements
Net Profit
Working CapitalCash absorbed
Capital ExpendituresCash absorbed
Financing & OwnerCash absorbed
Cash From OperationsCash generated
Ending Cash
Largest drivers
Receivables growth
Equipment purchase
Profit earned
Debt repayment
Supplier timing
Reconciliation
Difference identified? Review inputs

Illustrative dashboard layout

What's included

Follow the cash through the business

Financial Inputs

Enter the key income-statement, balance-sheet and cash-movement information for the period.

Working Capital Analysis

See how receivables, inventory, payables and other operating balances generated or absorbed cash.

Profit-to-Cash Bridge

Reconcile reported net profit through operating, investing, financing and owner activity to the change in cash.

Cash Driver Analysis

Identify the largest positive and negative contributors to the profit-to-cash bridge.

Action Plan

Surface management questions based on the financial movements identified by the diagnostic.

Executive Dashboard

See profit, operating cash generation, working-capital impact, capital expenditures, ending cash and reconciliation status in one high-level view.

Reconciliation

Does the explanation actually reconcile?

The diagnostic compares the calculated change in cash from the financial movements you've entered with the actual change between your beginning and ending cash balances.

If the two don't reconcile within the tolerance you set, the workbook flags the difference for review.

An unexplained difference may indicate that a financial movement is missing from the inputs or that an account has been classified differently than expected.

How it works

Step 1

Enter Your Financial Information

Use figures from your income statement and beginning and ending balance sheets.

Step 2

Review Working Capital

See how operating balance-sheet movements affected cash.

Step 3

Build the Profit-to-Cash Bridge

Follow the movements between reported profit and the calculated change in cash.

Step 4

Identify the Biggest Drivers

See which financial movements had the largest positive or negative effect.

Step 5

Review What Deserves Attention

Use the diagnostic questions to investigate the movements that matter most.

Built for owner-led businesses

The Profit vs. Cash Diagnostic is designed for business owners who can see profit on their financial statements but want a clearer explanation of what happened to their cash.

It may be particularly useful for businesses that:

  • Are profitable but regularly feel cash-constrained
  • Have growing accounts receivable
  • Carry inventory
  • Are investing in equipment or other capital assets
  • Have business debt
  • Make regular owner distributions
  • Are growing quickly
  • Want to better understand their balance sheet
  • Want more useful conversations with their accountant or finance partner
The basics

Why can a profitable business run short of cash?

Under accrual accounting, revenue and expenses aren't always recorded at the same time cash is received or paid.

A business might record a profitable sale today but collect the customer months later. It might purchase equipment with cash today but recognize the accounting expense over several years. It might repay debt principal or distribute cash to owners without those payments reducing accounting profit.

That's why understanding both profitability and cash movement matters when assessing the financial performance of a business.

Find out where the cash went

Download the free Vertex Profit vs. Cash Diagnostic and build a clearer bridge between your business's reported profit and actual cash movement.

Free Excel workbook • No signup required

Want better visibility into your cash flow?

Vertex Strategic Finance provides CPA-led accounting, financial reporting and advisory support to help owner-led businesses understand their numbers, improve financial visibility and make more informed business decisions.

Book a Complimentary Conversation

This resource is provided for general informational and planning purposes only and does not constitute accounting, tax, legal, investment, financing or financial advice. Financial statements, accounting classifications and cash-flow presentation can vary by business, accounting framework and circumstances. The diagnostic is based solely on information entered by the user and does not verify the accuracy or completeness of the underlying financial records. Businesses should work with qualified professional advisors where appropriate.