Skip to content
14-day free trial, no card9 languages176 business types · 50 apps
EN· USD
Try a live demoStart free trial

Cash flow report: how it works

The cash flow report shows the money that actually came in and went out, month by month, with the running bank and cash balance. Unlike the profit & loss it includes VAT, because that is what the bank statement shows.

Lesson 6 of 17 · How it works

  • about 3 min
  • Money → Reports → Cash flow

How it works

  1. Open «Money → Reports → Cash flow Money in and money out by month, with the running bank and cash balance. Amounts include VAT, because this is what the bank statement shows. More words in the glossary» and pick the period. The tiles show «Cash in», «Cash out», «Net cash» and «Closing balance».

  2. Cash in is every payment recorded on an invoice on its payment date, paid shop orders that have no invoice, and till takings on the day of the sale (change given and refunds taken off).

  3. Cash out is every expense with the status Paid, on its «Paid on» date. Recorded but unpaid bills, drafts and Void Canceling an issued invoice. It stays in the records with its number, but no longer counts as a sale or as money owed. More words in the glossary Expenses A bill or cost of the business: rent, materials, fuel, a supplier bill. “Recorded” means it is booked but not yet paid; “Paid” means the money has left. More words in the glossary do not move cash.

  4. The running balance starts from the opening balance. It comes from the opening cash balance in the finance settings; type another amount in the «Opening balance» field and click «Apply» to use it for this view only.

  5. «Monthly detail» lists invoice receipts, shop orders, point of sale, cash in, cash out, net and balance per month. Two charts split cash out by expense category and cash in by payment method.

Where to find it

Settings that change it

Checklist

Before you move on, check that you can:

  • Open Money → Reports → Cash flow
  • Open Money → Reports → Cash flow and pick the period.
  • Cash in is every payment recorded on an invoice on its payment date, paid shop orders that have no invoice,…
  • Cash out is every expense with the status Paid, on its Paid on date.
  • The running balance starts from the opening balance.

Tips and common mistakes

  • The closing balance is an estimate, not a bank reconciliation. Loans, owner's capital, tax payments to the authority and salaries that were not entered as expenses are not in it.
  • The balance does not match the bank? Set the opening balance to the real bank plus cash amount at the start of the period.
  • A bill you paid is missing from cash out when its expense is still Recorded. Set it to Paid with the right paid-on date.