Which Money Figure Is Which

MechIQ shows money in several places, and they answer different questions. How much work did we sell today? is not the same question as how much money came in today? -- so the figures can disagree on the same day, and that's expected.

Each figure is labelled ex VAT or inc VAT where it appears, and the table below says which. The rule everywhere: a line or unit price (a labour line, a part, a menu or catalogue price) is ex VAT; a quote or job total shows both (€100.00 ex VAT · €123.00 inc VAT); money that changed hands or is owed (payments, takings, balances, a supplier bill's total) is inc VAT.

At a glance

Figure Where you see it What it counts VAT Credit notes
Sales Dashboard Today's money banner, the Sales today card, the Money tab Invoices raised in the period, less the credit notes raised in it -- the same figure as Reports → Financial for the same days Ex VAT Deducted (a credit note is never counted as a sale, and the invoice count does not change)
Gross profit Dashboard banner, Money tab, Reports → Financial Sales, minus the parts cost of the jobs sold (minus technician wage cost if you cost labour) Ex VAT Credit notes on labour and parts come off; the job's costs are never counted twice (see below)
Takings today Accounts board Money received today -- every payment recorded for today, any method, less refunds paid out Inc VAT A refund paid out reduces it
Cash-up Accounts → Cash-up Today's payments by method; the headline is cash + card (what should be in the drawer) Inc VAT Refunds paid out are listed
Billed this month Accounts overview Invoices raised this month, paid or not (not credit notes, not written off) Inc VAT Not deducted
Outstanding / Overdue Accounts board What customers still owe -- invoiced, less what they've paid; overdue is past its due date Inc VAT --
Total sales Reports → Financial (owners) Invoices raised in the period less credit notes raised in it, to match your accounts package Ex VAT Deducted, and shown: €X sales less €Y credit notes
Monthly P&L Reports → P&L (owners) Reports → Financial, month by month Ex VAT Deducted
This week Mobile app → This week Invoiced this week: sales Monday to today, less the week's credit notes. Cash collected this week: money received (the same payments as Takings) Invoiced ex VAT; cash inc VAT Deducted from invoiced, and shown under it (after €X credit notes); refunds reduce cash

Everything follows the garage's own day (your time zone), not midnight UTC. Invoices brought in from your old system keep the date they were raised there, so an import day doesn't show years of history as that day's sales.

In short: sales and gross profit are about work sold (ex VAT), less the credit notes dated in the period -- on every screen, report and email, as your accounts package does it; takings and the cash-up are about money received (inc VAT).

Sales and gross profit (dashboard and Money tab)

Sales are the invoices raised in the period, ex VAT. Two kinds of document are left out:

  • Credit notes. A credit note comes off the sales and the gross profit of the day it is dated, whenever the invoice was raised -- the standard accounting treatment. It is never counted as a sale, so the number of invoices and the jobs sold do not change, and its job's costs are not counted a second time. Wherever a total is net of credit notes they are shown as their own line or tile (Credit notes, or after €X credit notes under a figure), so what a total is made of adds up to it. A day with only a credit note for an older sale reads below zero: that day did give money back.
  • Per technician. Labour figures per technician (team performance, the Money tab's labour by technician, the week, incentive targets) are net of the technician's share of a credit note: its labour is shared between the technicians who have labour on that job, in proportion.
  • Written-off invoices (all charges written off at checkout). Work done for free isn't a sale.

Gross profit is sales minus the parts cost of the jobs sold (the actual cost where the part was received at a different price than quoted), minus the technicians' wage cost only if you've turned on Cost my labour (show net margin) under Settings → Pricing. With that off, gross profit is parts profit plus labour sales. A credit note never brings its job's parts cost back in -- that cost belongs to the day the job was sold.

The Today's money banner and the Money tab's Today use the same arithmetic, so they always agree. The front desk sees them only if Settings → Dashboard has Show front-desk (FOH) staff the Money tab… ticked; with it off they see the smaller Sales today card instead. Owners always see them.

Takings and cash-up (money in)

Takings today on the Accounts board is money received: the payments recorded for today -- cash, card, bank transfer, cheque -- with any refunds paid out taken off. It includes VAT, because the customer paid it. A payment counts on its date received, so a cheque you back-date to last week lands in last week's takings, not today's.

Cash-up is the same payments split by method, built for checking the till: its headline, In the till (cash + card), is the money that should physically be there. Bank transfers and cheques are listed but aren't in that headline.

Why sales and takings differ

On any given day they usually do. A few common reasons:

  • An invoice raised today but paid next week is in today's sales, and in next week's takings.
  • A customer paying today for last month's work is in today's takings only.
  • Sales are ex VAT; takings include VAT.
  • A refund paid today reduces takings; the credit note behind it reduces sales on the day it is dated.

Why the dashboard and Reports → Financial can differ

Reports → Financial deducts credit notes dated in the period -- the card shows €X sales less €Y credit notes when there are any. The dashboard deducts them too: for the same days, the two always show the same sales and the same gross profit.

The monthly P&L is the Financial report month by month: for the current month, the two show the same sales, invoices and costs.

Related: FOH Dashboard · End-of-Day Cash-Up · Accounts overview · Garage reports