For QuickBooks, Xero and NetSuite

Accounts receivable aging reports, built by Claude or ChatGPT

Ask who owes you money and how late each invoice is. You get an aging report from your own books, customer by customer. Then ask about any customer or invoice.

Schedule a demo
Read-only by architecture
Kipper
Question:

Show me our accounts receivable aging report

Answer:
  • Asking Kipper for every unpaid invoice…
  • Sorting each one by days past due…
  • Adding up each column…

You're owed $286,400. Most of it, $196,300, isn't due yet. $41,800 is more than 30 days late.

Accounts Receivable Aging Open

Accounts Receivable Aging

At August 31 · Xero

Days past due, by customer

Swipe for every column
Customer Not yet due1–3031–6061–90Over 90 Total
Bluepeak Homes $35,800–$7,200$5,200– $48,200
Halden Interiors $36,900–––– $36,900
Ridgeway Dental $19,900–$3,600–$6,200 $29,700
Northgate Clinics $20,600$8,400––– $29,000
Crestline Builders $5,800$11,700$6,300$2,800– $26,600
Fernhill Schools $13,900$4,300––– $18,200
Marlow Physio $3,900$7,500$4,100–– $15,500
16 other customers $59,500$16,400$6,400–– $82,300
Total $196,300$48,300$27,600$8,000$6,200 $286,400
Question:

Which customers are more than 30 days late?

Answer:
  • Kipper is returning invoices past their due date…
  • Keeping the ones over 30 days late…
  • Grouping them by customer…

These four owe the most of it. Ridgeway Dental has the oldest invoice, at over 90 days.

More than 30 days late · top four of $41,800
CustomerOver 30 daysOldest
Bluepeak Homes$12,40061–90 days
Ridgeway Dental$9,800Over 90 days
Crestline Builders$9,10061–90 days
Marlow Physio$4,10031–60 days
Question:

Is Ridgeway Dental behind on any invoices?

Answer:
  • Kipper is returning Ridgeway Dental's unpaid invoices…
  • Checking each due date…
  • Working out days late…

Two invoices are late, $9,800 together. The oldest is 97 days past due.

Ridgeway Dental · unpaid invoices
InvoiceDueOwedDays late
INV-2041May 26$6,20097
INV-2187Jul 22$3,60040
INV-2310Sep 15$19,900Not due
Question:

How has the amount over 30 days late changed?

Answer:
  • Kipper is returning invoices and payments since March…
  • Working out what was unpaid at each month end…
  • Adding up the amounts over 30 days late…

It's fallen every month, from $61,200 in March to $41,800. That's $19,400 less.

Over 30 days late · each month end
MonthAmount
Mar$61,200
Apr$58,900
May$57,400
Jun$55,100
Jul$52,300
Aug$41,800
Question:

Who owes us the most?

Answer:
  • Kipper is returning every unpaid invoice…
  • Grouping them by customer…
  • Sorting by amount owed…

Bluepeak Homes, at $48,200. Most of it isn't due yet.

Owed to you · top three of $286,400
CustomerOwedOver 30 days late
Bluepeak Homes$48,200$12,400
Halden Interiors$36,900$0
Ridgeway Dental$29,700$9,800
Reply to Claude…
Open the live demo

A recorded example. Open the interactive demo to ask your own questions.

AR aging report example

See an accounts receivable aging report built from real books

Every unpaid invoice for a sample business at month end, by customer and by days past due. Ask for the same on your own numbers.

Accounts Receivable Aging Open

Accounts Receivable Aging

At August 31 · Xero

Owed to you

$286,400

Unpaid invoices

Over 30 days late

$41,800

-$10,500 vs July

Not yet due

68.5%

of what's owed

Owed, by days past due

Not yet due

$196,300 68.5%

1–30 days

$48,300 16.9%

31–60 days

$27,600 9.6%

61–90 days

$8,000 2.8%

Over 90 days

$6,200 2.2%

Days past due, by customer

Swipe for every column
Customer Not yet due1–3031–6061–90Over 90 Total
Bluepeak Homes $35,800–$7,200$5,200– $48,200
Halden Interiors $36,900–––– $36,900
Ridgeway Dental $19,900–$3,600–$6,200 $29,700
Northgate Clinics $20,600$8,400––– $29,000
Crestline Builders $5,800$11,700$6,300$2,800– $26,600
Fernhill Schools $13,900$4,300––– $18,200
Marlow Physio $3,900$7,500$4,100–– $15,500
16 other customers $59,500$16,400$6,400–– $82,300
Total $196,300$48,300$27,600$8,000$6,200 $286,400

Ask for your own aging report

Try it on a sample company's books in the interactive demo. Or book a call, and we'll set up your first report with you.

Schedule a demo

Reading the report

How to read an aging report

Each column is a range of days past the due date. The further right an amount sits, the longer that customer has kept you waiting.

Not yet due

Often called current

Invoices still inside their payment terms. There's nothing to chase yet.

$196,300 in the sample

1 to 30 days

Just past due

A reminder is the usual next step. Check the customer has the invoice.

$48,300 in the sample

31 to 60 days

Worth a call

Call the customer. Ask if the invoice reached the right person, and if anything's in dispute.

$27,600 in the sample

61 to 90 days

Look closer

Talk to whoever owns the account before you do more work for this customer.

$8,000 in the sample

Over 90 days

The oldest money

The longer an invoice waits, the harder it is to collect. Agree a payment plan, or decide with finance what's next.

$6,200 in the sample

Days past due = the report date − the invoice's due date.

Who asks

Check a customer before you call them

Account managers, sales reps and service teams can check a customer from Claude or ChatGPT. Your finance team gets fewer lookup requests.

Account managers

Is Bluepeak Homes up to date before their renewal?

They owe $48,200. $12,400 of it is more than 30 days late.

Service teams

Is Ridgeway Dental behind on any invoices?

Two invoices, $9,800 together. The oldest is 97 days late.

Sales reps

Does Halden Interiors owe us anything late?

No. They owe $36,900, and all of it is within terms.

Owners

How much is more than 30 days late?

$41,800, down $10,500 on the month before.

How it works

From your books to an aging report in four steps

Connect your accounting system once. After that, ask for your aging report whenever you need it. Kipper pulls your unpaid invoices from your books. Claude or ChatGPT sorts them by days past due.

  1. Read-only
    1

    Connect your accounting system

    One read-only connection to QuickBooks, Xero or NetSuite. Your books stay exactly as they are.

  2. Claude ChatGPT
    2

    Add Kipper to Claude or ChatGPT

    Kipper shows up as a tool inside the assistant you already use. There's no new tool to learn.

  3. Unpaid invoices · today

    Customer Due Owed Ridgeway Dental May 26 $6,200 Bluepeak Homes Jun 14 $5,200 Northgate Clinics Aug 18 $8,400
    3

    Kipper returns your unpaid invoices

    It pulls every open invoice, with its customer, its due date and what's still owed.

  4. Not yet due
    $196,300
    1 to 30 days
    $48,300
    31 to 60 days
    $27,600
    Over 60 days
    $14,200
    4

    Your assistant builds the report

    Claude or ChatGPT sorts each invoice by days past due and adds up each customer. Ask about any row.

We can set it up with you

Book a free onboarding call. We'll connect your accounting system with you. Then you ask for your first aging report.

Schedule free onboarding

Side by side

Compared with the aging report in your accounting system

Your accounting system already has an aging report, and your finance team relies on it. Kipper reads the same records, so everyone else can ask from Claude or ChatGPT.

Who uses it

In your accounting system

Your finance team, inside your accounting system.

Kipper with Claude or ChatGPT

Anyone you give access to, from Claude or ChatGPT.

Checking one customer

In your accounting system

Filter the report, or open the customer's record.

Kipper with Claude or ChatGPT

Ask in a sentence, and get that customer's invoices.

Changing the columns

In your accounting system

Set the report's options, then run it again.

Kipper with Claude or ChatGPT

Ask for different ranges, like 0 to 15 days.

Comparing months

In your accounting system

Run the report for each date you need.

Kipper with Claude or ChatGPT

Ask how the late amount has changed.

The record

In your accounting system

Your accounting system, where invoices live.

Kipper with Claude or ChatGPT

The same records, read-only. Nothing is copied or changed.

See it on your own numbers

Start a free trial, connect QuickBooks, Xero or NetSuite, and ask who owes you money.

Ask your own books See pricing

Follow-up questions

Ask about any customer or invoice

Narrow it to one customer, one invoice or one month. Here's one conversation, in order.

Which customers are more than 30 days late?

Bluepeak Homes, at $12,400. Ridgeway Dental and Crestline Builders come next.

Show me Ridgeway Dental's late invoices.

Two, $9,800 together. INV-2041 is 97 days past due.

Is that better than last month?

Yes. The amount over 30 days late fell by $10,500, from $52,300.

Which invoices are over 90 days late?

Just one: Ridgeway Dental's INV-2041, for $6,200.

Both assistants

Use Claude or ChatGPT: Kipper works with both

Your team can use Claude or ChatGPT to check who owes what and ask follow-up questions. Either way, the figures come straight from your books. Click a card to see it in the demo.

Kipper
Question:

Show me our accounts receivable aging report

Answer:
  • Asking Kipper for every unpaid invoice…
  • Sorting each one by days past due…
  • Adding up each column…

You're owed $286,400. Most of it, $196,300, isn't due yet. $41,800 is more than 30 days late.

Accounts Receivable Aging Open

Accounts Receivable Aging

At August 31 · Xero

Days past due, by customer

Swipe for every column
Customer Not yet due1–3031–6061–90Over 90 Total
Bluepeak Homes $35,800–$7,200$5,200– $48,200
Halden Interiors $36,900–––– $36,900
Ridgeway Dental $19,900–$3,600–$6,200 $29,700
Northgate Clinics $20,600$8,400––– $29,000
Crestline Builders $5,800$11,700$6,300$2,800– $26,600
Fernhill Schools $13,900$4,300––– $18,200
Marlow Physio $3,900$7,500$4,100–– $15,500
16 other customers $59,500$16,400$6,400–– $82,300
Total $196,300$48,300$27,600$8,000$6,200 $286,400
Question:

Which customers are more than 30 days late?

Answer:
  • Kipper is returning invoices past their due date…
  • Keeping the ones over 30 days late…
  • Grouping them by customer…

These four owe the most of it. Ridgeway Dental has the oldest invoice, at over 90 days.

More than 30 days late · top four of $41,800
CustomerOver 30 daysOldest
Bluepeak Homes$12,40061–90 days
Ridgeway Dental$9,800Over 90 days
Crestline Builders$9,10061–90 days
Marlow Physio$4,10031–60 days
Question:

Is Ridgeway Dental behind on any invoices?

Answer:
  • Kipper is returning Ridgeway Dental's unpaid invoices…
  • Checking each due date…
  • Working out days late…

Two invoices are late, $9,800 together. The oldest is 97 days past due.

Ridgeway Dental · unpaid invoices
InvoiceDueOwedDays late
INV-2041May 26$6,20097
INV-2187Jul 22$3,60040
INV-2310Sep 15$19,900Not due
Question:

How has the amount over 30 days late changed?

Answer:
  • Kipper is returning invoices and payments since March…
  • Working out what was unpaid at each month end…
  • Adding up the amounts over 30 days late…

It's fallen every month, from $61,200 in March to $41,800. That's $19,400 less.

Over 30 days late · each month end
MonthAmount
Mar$61,200
Apr$58,900
May$57,400
Jun$55,100
Jul$52,300
Aug$41,800
Question:

Who owes us the most?

Answer:
  • Kipper is returning every unpaid invoice…
  • Grouping them by customer…
  • Sorting by amount owed…

Bluepeak Homes, at $48,200. Most of it isn't due yet.

Owed to you · top three of $286,400
CustomerOwedOver 30 days late
Bluepeak Homes$48,200$12,400
Halden Interiors$36,900$0
Ridgeway Dental$29,700$9,800
Reply to Claude…
Open the live demo

Connect once, then ask from either one

Read-only access to QuickBooks, Xero or NetSuite, with the same permissions behind each.

Schedule a demo

Good to know

What to know before you connect it

Every figure traces to an invoice

Ask which invoices make up a number, and you'll see each one, straight from your accounting system.

Kipper is read-only by architecture

It returns records and reports. Reminders, payments and write-offs stay in your accounting system, where your team already handles them.

You choose who sees what

Access is scoped by person, team or role. Each person sees what their job needs, and the rest stays with finance.

FAQ

Aging report questions

What people ask before they connect their books.

It lists every unpaid invoice, grouped by customer and by how long it's been unpaid. It shows who owes you money, how much, and how late it is.
How much each customer owes, split into columns by days past due. Most reports use not yet due, 1 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days.
List every unpaid invoice with its due date. Work out how many days past due each one is. Then add up each customer's invoices in each column.
Count the days from the invoice's due date to the date of the report. An invoice due May 26 is 97 days past due on August 31.
They're the columns of the report, each a range of days past due. The usual ones are 1 to 30, 31 to 60, 61 to 90, and over 90 days. You can ask for different ranges, like 0 to 15 days.
Start with the total, then look right. Money in the later columns has waited longest, so check those customers first.
Most of the money sits in the first column, and very little is over 60 days late. In the sample business, 69% isn't due yet, and 15% is more than 30 days late.
An aging report shows who owes what, and how late. Days sales outstanding (DSO) is one number: how long customers take to pay, on average. You'll find it on a financial KPI dashboard.
It's the same report for bills you owe suppliers. It shows who you owe, and how soon each bill is due. You can ask for that too.
Finance teams use it to plan collections. Account managers and sales reps check it before a call, so they know if a customer is behind.
Yes, once it can see your books. Connected through Kipper, it reads your unpaid invoices from QuickBooks, Xero or NetSuite, read-only. Then it sorts them by days past due and adds up each customer.
QuickBooks, Xero and NetSuite. Invoices, customers and payments come from all three.
Reminders stay in your accounting system. Kipper is read-only by architecture: it returns records and reports, so every message to a customer stays with your team.

See who owes you money, from your own books

Connect QuickBooks, Xero or NetSuite once, read-only. Then ask Claude or ChatGPT who owes you money, and how late. We'll help you set it up.

Ask your own books Schedule a demo
QuickBooks Xero NetSuite Read-only Audit-logged