Financial analysis

This page assumes the Payments and cash register feature is enabled (Settings › Features, see Features).

The Analysis tab of the Cash register page shows how money flows through the garage: what comes in, what goes out and what is still owed. It answers questions such as “do many customers owe me money?” or “am I collecting far more than I am buying?”.

The tab only appears for people who can view payments, see purchase prices (supplier orders) and manage the garage settings: among the built-in roles, only the Administrator. A custom role with these three permissions sees it too.

Choosing the period

The Week, Month and Year buttons choose the kind of period (the current month by default); the arrows move to the previous or next period, and Back to today returns to the current one. A week runs from Monday to Sunday. All days are in the garage’s time zone.

Indicators

Each indicator is compared with the previous period of the same kind (“+12% vs previous period”):

• Invoiced (incl. VAT, net of credit notes): invoices and deposit invoices issued during the period, minus credit notes issued during the period. A deposit counts once, when its deposit invoice is issued.
• Collected: the same rule as the Collected today indicator of the Cash register page, over the whole period: payments received (refunds deducted), minus cancellations made during the period. Redeeming a gift card is not a collection (its sale was).
• Supplier purchases: the committed purchases whose order was sent during the period, excluding VAT and indicative (value received plus the rest still to receive at the expected price): the supplier’s invoice prevails.
• Period balance: collected minus supplier purchases.

Findings

Below the indicators, simple findings appear when they apply:

• a large share of the amount due is more than 30 days late (over a quarter, and at least €500): consider chasing these customers;
• the amount due exceeds what was collected during the period: your cash is waiting for these payments;
• you are collecting far more than you are buying (by at least a third, and at least €500): a good time to plan investments, to discuss with your accountant;
• your purchases exceed what you collected during the period: keep an eye on your cash.

These findings help you run the garage; they are not tax advice.

Money in and out

The chart shows, slot by slot (a day for a week or a month, a month for a year), the amount collected next to supplier purchases, on a single scale. Hover over a column (or move through them with the keyboard) to read its amounts and what was invoiced in that slot; Show the data as a table gives the same figures as a table, with the total.

What customers owe you

The ring splits the amount due today (all invoices not yet settled, whatever the period chosen): not yet due, then 1 to 30 days late, 31 to 60 days late and more than 60 days late, with the amount and number of invoices in each part. The detailed list is in the To collect tab.

Upcoming cash

What is still to come in and go out, as of today: the amount due by customers, minus purchases ordered but not yet received (excluding VAT, at the expected price), and the expected balance. For the current period, the projected invoicing at the end of the week, month or year extends the current pace: invoiced to date scaled to the days elapsed.

Sales by type and best sellers

The Sales by type ring splits the period’s revenue excluding VAT between labour, parts and flat rates (net of credit notes; a flat rate counts for its price, the parts it includes are not added). The Best sellers table lists the ten items that brought in the most during the period, with their quantity.

Nothing is changed by these views. Invoiced and collected amounts include VAT, purchases and item sales exclude it; they do not replace your accountant’s books.