Calculator guide
Follow cash received and paid through the period
Choose a period and an opening cash balance. Enter cash sales collected in that period separately from collections of earlier receivables so that receipts are not counted twice. Unpaid invoices do not belong in either cash-receipt input, even if they are recorded as revenue.
Operating cash flow subtracts supplier payments, payroll, overhead, taxes and other operating outflows from customer cash receipts. Enter payments as positive amounts in their labeled outflow fields; the formula subtracts them. Depreciation is not a cash payment and should not be added to these expenses.
Investing flow is asset-sale proceeds less asset purchases. Financing flow adds new borrowing and owner investment, then subtracts loan principal repayments and owner withdrawals. Keep borrowing separate from sales, and avoid putting an asset purchase in supplier payments as well as asset purchases.
Net cash flow is the sum of the three sections, while ending cash includes the opening balance. Reconcile the result with the same set of bank accounts after excluding internal transfers. This is a planning schedule, not a complete statutory cash-flow statement: foreign-exchange effects, cash equivalents and classification choices are not modeled.