PhinAppbeta

Cash flow

Forecast, Actuals and the comparison of the two - periods, rows, balances, comments and locked forecasts.

The three pages

PageWhat it is made ofThe question it answers
ForecastTitles - payables and receivables -, on their due date while open and on their payment date once settled.How much will come in and go out, and what will the company be left with?
ActualsBank transactions - what the statements and the manual accounts show, each reconciled one under the classification of the title it settled. Nothing in the future.How much actually came in and went out?
Forecast vs ActualsBoth, side by side: Forecast, Actuals, Delta and Difference % for each period.Are we on plan?

Left out are transfers between accounts - the money only changed accounts - and the system account. A credit card purchase counts on the day it posted to the card, like any other transaction, and paying the bill is a transfer.

Periods

The selector at the top changes the grain: Day, Week, Month or Year. The arrows move one period back or forward, and Today returns to the opening window:

  • the Forecast opens with the current period as the first column, followed by the next eleven;
  • the Actuals open with the current period as the last column, after the eleven before it;
  • the comparison shows only the current period and its two neighbours.

Clicking a column heading zooms in: a year opens into its months, a month into its weeks, a week into its days.

In the comparison, the YTD grain shows the current year accumulated up to the last closed month - setting a full-year forecast against eight months of actuals would show a shortfall the size of the rest of the year.

The rows

From top to bottom, each column reads as a statement:

  1. Opening balance in accounts - what the company held when the period began. It expands into one row per account.
  2. The chart-of-accounts groups, money in first: revenue, then costs and expenses, and last the groups that hold both sides. Each group expands into "level 2 - level 3" and then into the classifications.
  3. Classification pending - what has not been classified yet. It is a work list, so it stays in view, outside any group.
  4. Unreconciled receipts and Unreconciled payments - bank movements not yet linked to any title.
  5. Missing entries (Actuals only) - when two balances stated by the bank do not add up with the transactions between them. See each day's balance.
  6. Cash generation / consumption - the period's result.
  7. Closing balance in accounts - what the company held when the period ended.

A period's opening balance is the previous one's closing balance, read straight from the accounts - not worked out as "closing balance minus what moved". That way, a period missing a transaction disagrees with its own close instead of hiding the difference.

Unreconciled movements in the result

In the Actuals, unreconciled movements count towards cash generation: the money did move. In the Forecast, they appear in their own rows but stay out of the result - an open bank transaction is very often an open title seen from the other end, and adding both would count the same money twice.

The Forecast's balance

The Forecast's closing balance in each period is:

  • the real balance of the accounts on that day (or today, if the period has not ended);
  • plus the titles overdue and unpaid by that day - money that has not moved and that no bank knows about yet;
  • plus the forecast of everything due after today, up to the end of the period.

Inside the balance, the accounts appear one by one, and whatever is only a title - not yet in any bank - appears on the Open titles row. Each period is worked out from its own date, so the same month shows the same balance from whichever window it is looked at.

Currencies

Each cash flow is in one currency: the movements of the accounts in that currency, the titles owed in it and those accounts' balances. Amounts in different currencies are never added together - PhinApp converts nothing. The pages open on the organization's main currency and, when there are accounts in other currencies, a selector at the top switches between them.

Comments and forecast changes belong to the cell in the currency they were made in, and a locked forecast's snapshot keeps each currency apart. The partner report has the same selector, and the weekly and monthly summary e-mails are in the main currency.

Seeing a cell's transactions

Right-click a cell (on a phone, touch and hold) and choose View data. The window opens summed by partner: each partner and their total, largest first. Click a partner to see their transactions, with date, description and amount - and, where something has been paid, the payment date.

To see the same money organized by partner across every period at once, use the cash flow by partner.

Comments

Right-click a cell and choose Comment. A cell with comments gets a triangle in its top-right corner; hovering shows how many. Each column of the comparison has its own comments, and the Forecast and Actuals columns share theirs with the Forecast and Actuals pages. In the month view, comments written on that month's weeks appear alongside.

Read-only members can read comments, but not write them.

Locked forecasts

A forecast can only be compared with what happened if it does not change afterwards. That is why PhinApp takes a snapshot of the forecast at the start of each period, and the locked column then shows the snapshot - marked with ๐Ÿ”’ in its heading.

  • Under Settings โ†’ Organization details, Freeze the forecast every month snapshots each month on the 1st, and Freeze the forecast every week, each week at the turn from Sunday to Monday - both in the company's own time zone. Months and weeks are separate snapshots: locking one does not lock the other.
  • To lock or unlock a column by hand, right-click its heading, on the Forecast or on the comparison. Unlocking deletes the snapshot, and the column goes back to being worked out live.
  • A column can only be locked by hand when there are no unreconciled bank transactions in the period: a snapshot is never recalculated, so reconciling afterwards would not fix it.

In a locked column, titles created afterwards do not come in - that is what it is for. A title already in the snapshot that is paid later moves to its payment date.

Changing a locked forecast

Sometimes the locked forecast is simply wrong. Right-click the cell and choose Change forecast: give the new value and, preferably, the reason. The original forecast stays on record; the new value is a correction stated on top of it, with author and date, and the difference is carried into the groups and the column's result. The cell gets a triangle in its top-left corner.

On this page