Cashflow and P&L are available from Basic. On Free, they stay in the Reports list with a lock.
What each one answers
Cashflow — how much money moved through your accounts. Money in, money out, what is left.
P&L — what the business earned. Revenue, costs, gross profit, margin.
For most businesses these are close but not the same, and the article below is mostly about where they part company.
Which date each report uses, and how this compares with cash and accrual accounting, is explained in How Vault counts.
Why the same period can show different figures
Three things make them differ. None of them is an error.
Categories excluded from P&L. Some money moves without being income or expense — a loan repayment, a transfer to your own company, an owner's draw. You can mark a category or counterparty as excluded, and P&L will leave it out. Cashflow still counts it, because the money genuinely moved.
The actual period. If you have told Vault that a payment belongs to a different period than the day it moved, P&L follows the period and Cashflow follows the day. See below.
Balances. Cashflow also shows opening and closing balances; P&L does not. The balances include movements that are neither money in nor money out — see Other balance changes below.
One more, which is not a design difference but a real cause of confusion: a transfer you have not joined yet is counted as a genuine expense on one account and genuine income on the other, in both reports. Joining the two rows fixes both.
Split transactions are treated the same way in both reports: each part is counted under its own category and counterparty. A payment of 1,000 split into 700 Marketing and 300 Office shows as 700 under Marketing and 300 under Office in both.
Other balance changes
Inside Cashflow, Net cash flow counts only money that came in or went out of the business, while the balance rows include every movement. The difference has its own row, Other balance changes, so for every column:
Opening balance + Net cash flow + Other balance changes = Closing balance
Expand it to see what it is made of:
Exchange rate difference on transfers — when money moves between accounts in different currencies, the difference between what left one account and what arrived on the other, in your workspace currency.
Transfers — one half of a transfer whose other half falls into another period or onto an account you cannot see.
Revaluation of balances — the change in value of balances held in other currencies. Their value moves with the exchange rate even when there are no transactions.
None of these is income or expense, so none of them appears in P&L. How the exchange rate difference and the revaluation are calculated, with worked examples, is explained in How Vault converts currencies.
The actual period
Every transaction has a date. You can also give it an actual period — the stretch of time the money was actually for.
An annual insurance premium of 12,000 paid in January, with an actual period covering the year:
January | Each following month | |
Cashflow | 12,000 out | — |
P&L | about 1,019 | about 986–1,019 |
P&L spreads the amount evenly per day, not per month, so a 31-day month carries slightly more than a 30-day one and February carries least. No month shows exactly 1,000.
Actual periods are never filled in automatically. Bank and wallet imports do not set them. You add them on the transaction, in the Actual Date column, or for many transactions at once from Actions in the bulk bar. Besides a custom range, the picker offers Previous month, Transaction month and Next month — the whole calendar month before, of, or after the transaction's date. To remove a period, open the date picker and choose Clear.
Where a transaction has no actual period, P&L uses its date — the same day Cashflow uses. So until you start annotating transactions, this particular difference will not appear in your reports at all.
Excluding from P&L
On each category and counterparty option there is a P&L display checkbox. Turn it off and that line stops being counted as income or expense.
Use it for money that moves without being business performance: moving funds between your own companies, repaying a loan, an owner's contribution.
It affects P&L only. Cashflow, the dashboard and custom widgets all continue to count it, because the money did move.
If either the category or the counterparty is excluded, the transaction is excluded. For split transactions the decision is made per part.
A sub-category cannot be included when its parent is excluded. Exclude a parent and the children's checkboxes disappear; their own settings are remembered and return if you include the parent again.
Excluded transactions are not hidden. Open a figure's breakdown and they are still listed, each marked Counted: 0.00, with a note at the top saying how many rows were excluded.
Grouping
Both reports group by category, counterparty, or any of your custom attributes.
In table view, income and expense are grouped separately — you can group income by counterparty and expense by category at the same time. In chart view each card has its own grouping.
Where a category has sub-categories, the table shows the parent's total with a chevron. Expanding it lists the children, then a row named {Parent} — No subcategory for amounts recorded against the parent itself.
On pie charts, children are rolled into their parent. Click a parent slice to open it, and Back to return.
Period and columns
The period picker offers this week, this month, this year, the previous ones, all time, or a custom range. The default is this year.
Time interval controls how wide the columns are: automatic, monthly, or quarterly. It only becomes available when the period covers more than four months — on shorter periods the report chooses the granularity itself.
There is no comparison with a previous period and no year-to-date column. The table has one Total column for the selected period.
Nothing you choose is remembered. Period, view, grouping and the planned-data switch all return to their defaults when you reload or leave the page.
Planned transactions
Both reports include planned transactions by default — the Show planned data switch in View settings is on.
That means the first figures you see include forecasts, and gross margin is calculated from totals that include them. Turn it off to see only what has actually happened.
Planned here means not yet approved. With the switch on, overdue planned transactions count too. An approved transaction is always counted as actual, even when its date is in the future.
In table view, clicking a figure shows the split between actual and planned.
Accounts and currency
Both reports cover every account you have access to. There is no way to limit a report to a subset of accounts.
Figures are in your workspace currency. Each transaction was converted when it was saved, at the rate for its own date, and the report adds up those stored amounts.
Cashflow's opening and closing balances work differently: they start from your accounts' current balances, and each balance is converted at the rate of the day it falls on — the first and last day of the column. A foreign-currency balance can therefore change value from one column to the next without any transaction; that change is the Revaluation of balances row.
If an account's balance cannot be used — the bank has not sent a current balance, or its currency has no exchange rate on a period boundary — that account is left out of the opening and closing balances, and a note names it. Its transactions still count in money in and out, and appear in a separate row, Transactions on accounts without a balance, so each column still adds up. If no account has a usable balance, the balance rows show —. P&L is unaffected.
If part of a report fails to load, the rest is still shown: the missing figures show —, and a note at the top offers Retry.
Drilling into the numbers
In table view, click any figure to see the transactions behind it. The breakdown is the full transactions table — you can filter and edit from inside it, and select one row at a time to use its actions.
For a split transaction, the breakdown shows the transaction with the amount of the parts that fall into that figure.
This requires access to transactions. A member who can see reports but not transactions sees the figures and cannot click through.
Charts don't open a breakdown, and in the table gross margin and the balance rows don't either.
Who sees what
A member limited to certain accounts sees the same reports recalculated from their accounts only, including the opening and closing balances. Nothing on screen says the figures are partial — if two people compare numbers and disagree, check their account access first.
Members without report access do not see these reports at all.
What these reports do not do
There is no export, no print view and no shareable link.
There is no account filter and no comparison with a previous period.
