Ask

finance

Aged debt by client, in a workbook from Xero.

Ask for the aged debt and Centrus reads every open invoice in Xero, sorts them by client into current, 30, 60 and 90 days, and answers with the Excel workbook. For a field service finance team, credit control starts with the sheet built.

who asks
Finance
works with
ExcelXero
how it runs
Asked in chat, on WhatsApp or in Teams.

how it runs

Behind the aged debt.

Kate built the sheet at 08:40 on Mon 26/10, before the 09:30 credit control meeting. This is what came next.

01

Who's replied

Kate asks if any of the three have replied. Centrus searches the accounts inbox and finds Paul Grant's answer.

Replies checked before the chase

01 / 03

before and after

The same aged debt, two ways.

Kate's sheet for the 09:30 credit control meeting on Mon 26/10, with £6,520 over 30 days.

  1. The figures

    Without Centrus: Exported from Xero and pasted into last week's sheet

    With Centrus: Read live from Xero into a new workbook

  2. By age

    Without Centrus: Sorted into 30, 60 and 90 days by formula

    With Centrus: Bucketed by client and age in the reply

  3. Who replied

    Without Centrus: Found by searching the inbox client by client

    With Centrus: Paul Grant's reply found in the accounts inbox

  4. In the meeting

    Without Centrus: Dan's question waits until someone checks Xero

    With Centrus: Answered on Teams with the invoices behind it

Centrus AI

in the 30 minutes

  1. 01We start with how your operation actually runs, on the desk and in the field.
  2. 02We show "Aged debt by client from Xero in a workbook" on a setup that matches yours.
  3. 03We pick out the admin that should run itself first.

Book 30 minutes. Bring a real question.

Ask this every week, or need something that isn't on the list? Bring the question the way your team would put it, and we will show it on a setup like yours. You leave with a plan.

30 minutes / UK team / No lock-inOr see pricing