What is a monthly cash flow calculator?

A monthly cash flow calculator is a tool that tracks all cash inflows and outflows over a calendar month to show your net cash position. Unlike a P&L statement, it records money only when it physically moves — not when revenue is earned or expenses are accrued.

How do I calculate monthly cash flow?

Add all cash received during the month (customer payments, loan proceeds, investment sales) and subtract all cash paid out (payroll, rent, supplier payments, loan principal). The result is your net cash flow. Add that to your opening bank balance to get the closing cash balance.

Why is cash flow different from profit?

Profit is an accounting concept that records revenue when earned and expenses when incurred, regardless of when cash moves. Cash flow records only actual money received and paid. A profitable business can go bankrupt if customers pay late, creating a gap between profit and liquidity.

Can the calculator handle different cash flow examples?

Yes. The calculator works for any cash flow pattern: operating cash flow from sales and expenses, investing cash flow from equipment purchases or sales, and financing cash flow from loans or capital contributions. Enter each item in the appropriate inflow or outflow category.

What is cash runway and how is it calculated?

Cash runway is the number of months a business can operate before exhausting its cash reserves, assuming no new revenue. It is calculated as: Cash Runway = Current Cash Balance ÷ Average Monthly Net Cash Outflow. A runway of less than three months is generally considered a liquidity warning.

Monthly Cash Flow Calculator: Instant Projection

Methodology

Variable Expenses = Revenue × (% Variable ÷ 100)

Monthly Net Flow = Revenue − Fixed Expenses − Variable Expenses

Accounts Receivable = Revenue × (Collection Days ÷ 30)

Balance[month 1] = Reserve + Net Flow − Accounts Receivable

Balance[month N] = Balance[month N-1] + Net Flow

Runway = Reserve ÷ (Fixed Expenses + Variable Expenses)

Practical example

Your business has $50,000/month in revenue, $20,000 in fixed expenses, 30% variable expenses ($15,000), and a $10,000 reserve.

Monthly net flow: $50,000 − $20,000 − $15,000 = $15,000.

With 30-day collection terms, accounts receivable are $50,000 (one month of revenue).

Month 1: $10,000 + $15,000 − $50,000 = −$25,000 (the collection gap creates tension).

From month 2 onward: the balance grows $15,000/month as collections normalize.

Runway: $10,000 ÷ $35,000 = 0.29 months. With zero revenue, your reserve lasts less than 10 days.

Interpretation

A positive monthly net flow doesn't guarantee liquidity. If your customers pay late, you can have cash problems even though you're profitable.

Runway tells you how many months your company survives without revenue. Less than 3 months is a risk zone; at least 6 is recommended.

If the projection line dips below zero, your business will need external financing at that point.

Review this projection monthly against actuals. The gap between projected and actual measures your cash management.

Assumptions and limitations

Assumes constant monthly revenue and expenses (no seasonality).

Accounts receivable impact only the first month of the projection.

Does not consider credit lines, financing or capital injections.

Does not include taxes, depreciation or financial expenses.

Runway assumes a complete revenue stop; in practice it would be partial.

When to use this calculator

When starting a new business. Before signing leases or hiring staff, project your cash flow to know how many months you can operate before revenue covers expenses. Many profitable businesses fail due to early-months illiquidity.

When your customers pay on credit. If you sell at 30, 60 or 90 days, invoicing doesn't reflect cash on hand. Cash flow shows when you actually receive the money and whether you can meet obligations while waiting.

To decide whether you can take on a major expense. Before buying equipment, hiring an employee or investing in inventory, simulate how it affects your cash balance over the next 6-12 months.

When negotiating payment terms with suppliers. If your flow is positive but tight in certain months, you can negotiate paying at 60 days instead of 30 to smooth expense peaks.

To determine how much working capital you need. Cash flow shows the lowest point of your balance — that's the minimum reserve you need to operate without surprises.

When a bank or investor asks for financial projections. The cash flow statement is one of the three basic financial statements they evaluate to grant credit or investment.

Common mistakes

Confusing profit with cash. You can have positive accounting profit and still run out of cash. If you sold $100,000 but your customers haven't paid yet, you don't have $100,000 in the bank. Cash flow measures real money, not payment promises.

Not accounting for seasonality. Most businesses have strong and weak months. A restaurant in a tourist area may bill twice as much in December as in September. Projecting constant revenue creates a false sense of security.

Underestimating average collection days. Customers rarely pay on agreed terms. If the contract says 30 days, the real average is usually 45-60 days. Use real collection data to project.

Forgetting irregular expenses. Year-end bonuses, annual insurance, license renewals, equipment maintenance and annual tax payments are expenses that don't appear every month but can empty your cash when they arrive.

Not maintaining an emergency reserve. The minimum rule is 3 months of fixed expenses in reserve. For businesses with corporate customers paying on credit, the recommendation rises to 6 months. Without reserves, any collection delay or unexpected expense creates a crisis.

Projecting growth without considering the cost of growth. If sales rise 50%, you probably need more inventory, more staff and more space. Growth consumes cash before generating it.

Industry use cases

Agencies and B2B services

A marketing agency with $180,000/month revenue, $120,000 fixed expenses and 45-day collection has a theoretical net flow of $60,000/month. But in month one, accounts receivable of $270,000 (1.5 months of revenue) create a $210,000 deficit. Needs a line of credit or equivalent reserve to operate.

Construction and projects

A construction firm bills by work progress every 30 days but pays for materials upfront and payroll every two weeks. With a $500,000 project at 25% margin, it needs to advance $375,000 in costs. Negative cash flow during the job requires working capital or customer advances.

Retail with inventory

A clothing store buys seasonal inventory 3 months before sale. Invests $200,000 in January for the spring collection sold between March and May. Cash flow is negative in January-February and recovers in March-April. Without supplier credit, needs an additional $200,000 in reserves.

Growth-stage startups

A SaaS startup with 50 customers paying $499/month ($24,950) and costs of $60,000/month has a $35,050/month burn rate. With $400,000 of investment, runway is 11.4 months. Needs to grow to 121 customers for break-even before running out of money.

Manufacturing

A furniture factory with $300,000/month revenue, 40% raw materials and $100,000 fixed expenses has a net flow of $80,000/month. But a big $500,000 order requires buying $200,000 in wood upfront. Without reserves, it can't take the most profitable order.

Medical practices

A medical practice with $90,000/month revenue (consultations + procedures), $55,000 fixed expenses and 15-day collection (insurers) has $35,000/month net flow. The risk: insurers can delay payments 60-90 days, turning a profitable business into one with liquidity problems.

Monthly Cash Flow Calculator: Project Your Business Cash Position in Minutes

Cash flow is the lifeblood of every business. More companies fail from running out of cash than from lack of profitability — a company can show an accounting profit while simultaneously running out of money if customers pay slowly or if inventory absorbs capital faster than revenue arrives. A monthly cash flow calculator cuts through that ambiguity by translating your expected inflows and outflows into a concrete, month-by-month picture of your liquidity position.

What Is Monthly Cash Flow and Why Does It Matter?

Cash flow measures the actual movement of money in and out of a business or household during a given period — not accounting entries, not accrued receivables, but real cash. The core equation is straightforward:

Net Cash Flow = Cash Inflows − Cash Outflows

Positive net cash flow means you generated more cash than you spent. Negative cash flow means you consumed reserves or took on debt. Neither number tells the full story without context: a fast-growing startup can sustain negative cash flow for years if it has adequate runway; a mature retailer running negative cash flow for two consecutive months likely has a collections or inventory problem that demands immediate action.

Monthly cadence matters because most financial obligations — payroll, rent, loan installments, supplier invoices — fall on monthly cycles. A quarterly or annual view masks the peaks and troughs that actually threaten solvency.

Key Metrics the Calculator Computes

Operating Cash Flow Margin

Operating cash flow margin = Operating cash flow ÷ Revenue × 100. This ratio tells you how efficiently your core business converts revenue into actual cash. According to NYU Stern's industry averages (2024), medians by sector are:

SaaS / software: 18%–25%
Professional services: 12%–18%
Retail: 4%–8%
Manufacturing: 6%–10%
Food & beverage: 3%–7%

A margin consistently below your sector median signals a structural problem: either margins are too thin, or you are financing customers' working capital with your own cash.

Cash Runway

Runway = Cash on hand ÷ Monthly net burn rate. For businesses with negative cash flow, runway answers the most pressing question: how many months of operating capital remain? The Y Combinator standard for early-stage startups is a minimum 12–18 months of runway at all times. The US Small Business Administration recommends SMBs hold 3–6 months of operating expenses in liquid reserves.

If your runway calculation shows fewer than three months, that is not a planning problem — it is an emergency that requires immediate action on collections, cost reduction, or financing.

DSO, DPO, and DIO — The Working Capital Triangle

Working capital efficiency is captured in three ratios that directly drive cash flow:

DSO (Days Sales Outstanding) = (Accounts Receivable ÷ Revenue) × 365. DSO measures how long customers take to pay. BBVA Research's Working Capital Monitor (2024) found the average DSO for B2B companies in Latin America is 45–75 days. Every day you reduce DSO frees cash from receivables.

DPO (Days Payable Outstanding) = (Accounts Payable ÷ COGS) × 365. DPO measures how long you take to pay suppliers. Extending DPO improves your cash position — within reason. Suppliers who feel they are being stretched may tighten credit terms or deprioritize your orders.

DIO (Days Inventory Outstanding) = (Inventory ÷ COGS) × 365. DIO measures how long inventory sits before being sold. High DIO ties up cash that could fund operations.

The Cash Conversion Cycle (CCC) = DSO + DIO − DPO. A lower CCC means faster cash recovery. Best-in-class operations (Amazon, major grocery chains) operate with negative CCCs — they collect from customers before they pay suppliers.

How to Build an Accurate Monthly Cash Flow Projection

A reliable projection requires three inputs: an inflows schedule, an outflows schedule, and an opening balance.

Inflows include operating revenue (broken down by customer or product line where possible), financing inflows (loans disbursed, capital contributions), and asset sales. The critical discipline is timing: record cash when it is actually expected to arrive in your bank account, not when the invoice is issued.

Outflows include fixed costs (rent, salaries, insurance, debt service), variable costs (COGS, commissions, freight), one-time expenditures (equipment purchases, tax payments), and VAT / IVA settlements. In Mexico and Spain, IVA refund cycles can create significant cash flow timing differences that must be modeled explicitly.

Opening balance connects each month to the previous one: Closing Balance (Month N) = Opening Balance (Month N+1).

Common Cash Flow Mistakes — and How to Avoid Them

Confusing profit with cash. If you bill MXN 500,000 in December but collect in February, your December P&L looks strong but your December cash flow is weak. Track both, separately, always.

Ignoring seasonality. A business that earns 40% of annual revenue in Q4 must plan cash outflows (payroll, rent, inventory build) for Q1–Q3 without assuming Q4 will bail them out. Build your projection from historical seasonal patterns, not a straight-line monthly average.

Under-estimating tax timing. ISR (Impuesto Sobre la Renta) estimated payments in Mexico fall quarterly. IRPF withholding in Spain settles annually. Corporate income tax advances can create large single-month outflows that are invisible in a monthly average.

Forgetting working capital for growth. Every additional peso of revenue requires working capital: more inventory, more receivables. Fast-growing businesses often hit a cash crisis precisely because they are succeeding — revenue is growing faster than they can collect it.

Not stress-testing the model. Run at least two scenarios beyond your base case: a downside where your top three customers delay payment by 30 days, and an upside where revenue accelerates 20% but so do variable costs. The range between scenarios gives you a realistic confidence interval for your liquidity position.

Benchmarks by Business Stage

Stage	Recommended cash reserve	Runway target
Pre-revenue / seed	18+ months burn covered	18+ months
Early-revenue (< MXN 5M annual)	6 months operating expenses	12–18 months
Growth stage (MXN 5M–50M)	3–6 months operating expenses	6–12 months
Established (MXN 50M+)	2–3 months operating expenses	3–6 months

Sources: Y Combinator startup playbook; US SBA Financial Management Guide; IMF SME Finance Working Paper 2024.

Practical Uses for the Monthly Cash Flow Calculator

Freelancers and solopreneurs can use the tool to model feast-and-famine income cycles — projecting when they can afford new equipment, take on a new subcontractor, or move to a larger workspace.

SaaS and subscription businesses use monthly cash flow projections to validate MRR growth targets against actual collections timing. A SaaS company with strong MRR but high annual prepayment agreements must track cash differently from a monthly-billed model.

SMBs applying for a bank loan need to present 12–24 months of projected cash flow. A well-structured projection built with this tool demonstrates financial management competence and improves approval odds.

Retailers and e-commerce operators need the tool to plan for inventory financing cycles — modeling the cash gap between paying suppliers and collecting from customers during peak seasons.

The goal of monthly cash flow analysis is not to predict the future with precision, but to eliminate avoidable surprises. Businesses that run monthly projections consistently are, by definition, not blindsided by the cash shortfalls that force rushed financing decisions at unfavorable terms.

Monthly Cash Flow Calculator