Net Cash Flow Calculator

What this calculator includes

• Three separate activity subtotals, with receipts and payments shown gross.
• Explicit opening cash, reporting dates and a separate exchange-rate adjustment.
• Optional closing-balance comparison that preserves zero as a real balance.
• Negative operating cash and negative calculated closing cash warnings.
• Values-only CSV snapshot for the period; calculations run in your browser.

Net cash flow formula: three activities, one cash bridge

Net cash flow = operating cash flow + investing cash flow + financing cash flow. Within each activity, subtract cash payments from cash receipts. Calculated closing cash = opening cash + net cash flow + the separately entered exchange-rate effect.

Opening cash is a balance carried into the period. Adding it to receipts would count money you already had as newly generated cash. The result labels keep the three-activity subtotal separate from the total change in cash when an exchange-rate adjustment exists.

The same total can be checked as $24,000 total receipts minus $21,500 total payments = $2,500. Keeping the activity subtotals visible explains where that increase came from. With no exchange-rate effect, $5,000 opening cash plus $2,500 movement equals $7,500 closing cash.

Prepare the cash records before entering totals

1. Choose one completed period and one cash-account scope. For several included bank accounts, use their combined reconciled opening and closing balances.
2. Match bank movements to the ledger and confirm cutoff dates. Enter amounts when cash moved, rather than the invoice, purchase-order or accounting expense date.
3. Group each external receipt and payment once. Remove transfers between accounts inside the selected scope; they do not create cash for that combined group.
4. Enter positive receipt and payment totals in all six activity fields, including an explicit 0 for an inactive category. Do not enter a negative payment to reverse the subtraction.
5. Translate foreign-currency activity consistently before entry. Record any separate exchange-rate effect on held cash in its signed adjustment field.
6. Enter the observed closing balance if available. Investigate any difference before using the calculated closing cash as the next forecast opening balance.

The dates identify the period you summarized. Changing a date does not recalculate your underlying bank records. A September total labeled October is still a September total until you replace the amounts. Keep the source export or reconciliation beside the downloaded snapshot.

Keep cash classification consistent without double counting

Operating cash covers the cash side of ordinary business activity. Investing commonly includes cash paid for long-lived equipment and cash proceeds from its disposal. Financing commonly includes borrowing, principal repayments and owner capital movements. The SEC reference explains these three categories.

This tool does not assign transactions automatically. Follow the classification policy used for your records, especially for interest, dividends, taxes and unusual transactions. A formal reporting framework can require treatments and disclosures beyond this summary.

If you are summarizing only one account rather than the whole business, a transfer crosses that account boundary and requires separate identification in your supporting schedule. Do not silently mix an account-only statement with a business-wide cash total.

Positive total cash can hide negative operating cash

Consider a second fictional month: customer and other operating receipts are $15,000 against $18,000 operating payments. Operations use $3,000. Equipment payments use another $3,000. A $10,000 loan receipt less $500 principal repayment supplies $9,500 financing cash.

Net cash flow is −$3,000 − $3,000 + $9,500 = +$3,500. Starting with $5,000 cash gives $8,500 closing cash. The bank balance increased while operating activity consumed cash. Treating all $25,000 of receipts as customer sales would conceal the funding source.

The next useful question is whether the operating shortfall is temporary or recurring. Trace collections, supplier terms and payroll dates. Then put the confirmed loan proceeds and future repayments into a dated forecast. A cash increase by itself does not show that the business can keep funding operations.

Why net cash flow does not equal net income or free cash flow

Profit and cash answer different questions. The SEC guide explains how non-cash charges and operating balance changes can create a difference. This calculator starts from actual cash totals; it does not convert your income statement into cash automatically.

For an arithmetic illustration only, suppose net income is $6,000. Add $2,000 depreciation, subtract a $4,000 increase in receivables, subtract a $3,000 increase in inventory and add a $1,000 increase in operating payables. Those specified adjustments produce $2,000 operating cash: $6,000 + $2,000 − $4,000 − $3,000 + $1,000. Assume no other reconciling items in this fictional example.

Do not paste the $6,000 net income into operating receipts. That would bypass the cash records and could double count amounts already reflected in collections and payments. An indirect cash-flow reconciliation is a separate preparation method.

Free cash flow also needs a stated definition. It often focuses on cash remaining after capital spending, whereas this page includes financing cash in its net total. The loaded example has $2,000 operating cash and $3,000 equipment spending, but its $2,500 net increase also includes borrowing and repayment. Use the displayed activity subtotals rather than relabeling the total as free cash flow, investment return or distributable profit.

Reconcile closing cash without inserting a balancing plug

In the loaded example, calculated closing cash is $7,500. If the comparable bank reconciliation shows $7,300, observed less calculated is −$200. That difference is a prompt to investigate; it is not proof of a particular missing expense.

Check that the opening and closing balances include the same accounts. Then inspect uncleared items, duplicate entries, omitted charges, interaccount transfers and period cutoff. An invoice expense with no payment does not explain a bank outflow until cash actually moves. Correct the source records and the appropriate category, rather than inventing a $200 miscellaneous payment to force agreement.

A zero difference verifies the arithmetic against the entered observed balance. It cannot establish that all records are complete or that every receipt was correctly classified. Leaving the optional observed field blank produces “not checked”; entering 0 performs a real comparison.

If the exchange-rate adjustment is +$100 with all default cash activity unchanged, net cash flow stays $2,500 while total change in cash becomes $2,600 and calculated closing cash becomes $7,600. That exchange effect is not an additional customer collection.

Use monthly or annual totals, then inspect payment timing

The formula works for a week, month or year when all inputs share that period. For an annual calculation, total the actual yearly cash activity by category and use cash immediately before the year starts as opening cash. Do not multiply one month by twelve and describe it as an observed annual result.

A positive period-end balance can still hide a shortage earlier in the period. For example, $1,000 opening cash followed by a $4,000 payroll payment on Monday reaches −$3,000 before a $6,000 Friday collection lifts cash to $3,000. The period totals alone do not display that sequence.

The calculator has no minimum daily balance output because it accepts activity totals, not individual events. Use the 13-week forecast for future dated receipts and payments, and check daily sequencing separately when weekly cash is tight. A negative calculated balance here flags incomplete funding or records; it does not authorize an overdraft.

• Build the dated 13-week cash schedule
• Compare the cash schedule with the sales break-even target

Keep a cash summary, then roll verified actuals into the forecast

Download the CSV after checking the period, currency and closing difference. It preserves the entered category totals and calculated results as values. Editing the file does not update formulas because there are none. The download does not include bank transactions or independently verify your source records.

When the period is closed, carry the reconciled closing cash into the next forecast opening balance on the same account basis. Remove cleared forecast events instead of keeping both the actual payment and its original expectation. Move a genuinely uncollected invoice to its revised expected date; do not invent a second receipt.

Keep uncertain collections, planned financing and reserve assumptions visible in the forward plan. The actual-period summary explains what happened. The forecast tests whether the next payroll, supplier payment or equipment purchase can be funded on its payment date.

Assumptions and limits

This is a simplified direct cash summary, not a statutory statement, audited report, tax calculation or forecast. Amounts are labeled USD without automatic conversion. Use the same account scope and accounting classification policy throughout. The tool accepts nonnegative opening and observed cash; it does not model a negative opening bank overdraft. Track borrowing separately and reconcile any overdraft presentation, restricted cash and cash-equivalent differences with your records before using the result. Receipts and payments are entered as positive amounts; only the exchange-rate adjustment is signed. Blank required fields are incomplete, not zero. Each input is limited to one trillion. Displays round to two decimals while calculations retain greater precision; very small nonzero results use scientific notation.

Frequently asked questions

Method references

• Cash flow activities and the difference from income — U.S. SEC
• Cash-flow statement requirements and scope — IFRS IAS 7