Features · Cash and margin

Cash, costs and margin, read against the diary that earned them

Xero knows what came in and what went out. It cannot say what an hour of your diary is worth, which clients pay for their time and which do not, or how many weeks the bank balance would last. Joined to Cliniko, it can.

Cash

The balance in the bank against what a week of the practice costs, in weeks of cover. A 13-week forecast that pays each payer on their own usual timing, contracts on their day and costs when they normally fall, so it is lumpy the way a real bank balance is. Below it, the money owed to you and the invoices past their due date, biggest first, each a click from Xero. Draft invoices not yet approved, oldest first, so nothing sits unbilled.

What an hour is worth

Income divided by the billable hours the diary actually booked: the figure break-even is built on, and the one a price rise or a cheaper appointment type moves.

Billable hours booked, a week
122.9h
Income per billable hour
£120
Income, a week
£14,748

Margin by client group

Self-pay patients, insurers, care homes and contracts rarely earn the same per hour, and the busiest are not always the best. Cixler prices each Xero income account by the hours behind it, after average staff cost and the unsold time either side of its bookings: a home visit that owns the empty afternoon around it carries that afternoon.

Where the money went

Total cost each month, split by what it was spent on. Staff, and then everything else, including the owner’s own pay.
  • Staff
  • Directors' pay
  • Pensions
  • Professional fees
  • Premises
  • Marketing
  • Other
£0£10,000£20,000£30,000£40,000MarAprMayJunJul

Also on the Money tab

  • Owner’s pay

    Pay through payroll against money drawn on the director’s loan account, and the balance.

  • Income by account

    A year of the books’ income, month by month, one line per Xero account.

  • Income that comes back

    Invoicing split by whether the customer billed more than once.

  • Credit notes

    Raised this period, and already taken off invoiced revenue.

  • Income without an invoice

    The books against the sales ledger, account by account, so a gap is found rather than guessed.

  • Money in and out

    Invoiced, collected, spent and kept, period by period.

Questions

Does Cixler change anything in Xero?

No. It reads the profit and loss, the chart of accounts, bank balances, invoices and payments, and writes nothing back.

How is the margin on a client group worked out?

Cixler matches each Xero contact to the patient record in Cliniko, so every invoice line reaches the appointments behind it. It then takes off average staff cost and the unsold time next to those appointments, before shared costs such as rent.

Does it read payroll?

No. Staff costs come from the profit and loss. If a month’s payroll has not been posted yet, Cixler uses the usual month’s staff cost rather than showing a month that looks free.

Related: Practice profitability guide · Cliniko and Xero guide