Diagram: Xero, Stripe and a CRM feed a private Croft server. One AI question returns a table of fictional customers with amount, days overdue and last payment status, plus a synced 12 minutes ago note.

Blog · November 22, 2026 · Rich Chetwynd

Which customers owe us money? How to get AI to answer from Xero, Stripe and your CRM

Ask AI which customers owe us money across Xero, Stripe and your CRM, without exporting aged receivables. Croft keeps a current copy on your private server. Claude or ChatGPT answers with how fresh the data is, then can email the list.

Quick answer

To ask AI which customers owe us money across Xero, Stripe and your CRM, connect those tools on Croft. Croft keeps a tidy, current copy on your own private server. Xero is ready-made: Sales invoices, plus a summary of who owes you most. Stripe and the CRM are not marked Kept in sync, so you ask your AI to set those copies up through the connector. Then connect Claude or ChatGPT and ask one question: who owes money, how overdue, whether a Stripe payment failed, and who owns the account in HubSpot, Pipedrive or Attio. Answers say how fresh the data is. The same connection is where that AI builds a Monday overdue-invoice email. You do not export aged receivables into chat, and keys never reach the AI.

That is the pitch in one job: your business data, ready for your AI, with the small apps and automations built on it given equal weight.

Why does asking AI who owes us money usually fail?

The overdue list already lives in Xero. Failed charges live in Stripe. The person who owns the account lives in the CRM. Getting Claude or ChatGPT to answer across those tools by hand does not hold:

  • You export aged receivables to a spreadsheet, then paste it into ChatGPT. The file is already old. Stripe and the CRM are not in it. Next week you do it again.
  • You export three files (Xero, Stripe, HubSpot) and hope the names join. Follow-ups depend on whoever downloaded last, and nobody can say how fresh any of the numbers were.
  • You drop a Xero, Stripe or CRM login into a prompt so the model can “just fetch it.” The AI is now holding credentials it should never see.

Xero-only chat, a CRM-only pipeline question, and a Monday Xero email are each a different job. This one is the cross-tool receivables answer: one question, three sources, then the automation on top.

Related: how to ask Claude about your Xero data if you only need the books, how to ask AI about your CRM if you only need the pipeline, how to connect ChatGPT to Stripe if you only need payments, and how to give AI access to your business data for the broader pattern.

Exporting aged receivables vs asking AI over synced data on Croft

Need Export aged receivables to a spreadsheet / ChatGPT Check Xero, Stripe and the CRM yourself One question on Croft
Who owes money, how overdue Stale the moment you export Live, if you click through three products Tidy copy on your private server
Failed Stripe payment next to the invoice A second export, then a manual join You switch tabs Ask across Xero charges and Sales invoices
Who owns the account in the CRM A third export Whoever has that CRM seat Ask across HubSpot, Pipedrive or Attio
Says how fresh the numbers are No Whatever each product shows right then Yes, for example “Synced 12 minutes ago”
Keys stay off the AI The files still left the tools You are logged into each tool Croft holds the connection
Who on the team can ask Whoever has the files Whoever has each login Admins decide per source
Same answer in Claude, ChatGPT, Cursor or Grok Paste the files again Another set of logins One copy, many assistants
Then email the overdue list every Monday Manual Manual Your AI builds a small app on Croft

Croft is not “point Claude straight at Xero.” Claude reads the copy on your server. Setup: Xero, Stripe, connectors, your data.

How do I get AI to answer who owes us money from Xero, Stripe and the CRM?

  1. Start a free trial to get a croft, your private server. 14 days free.
  2. Connect Xero. Connecting starts the sync. There is nothing else to install. Croft keeps invoices, bills, contacts, payments and accounts as named datasets you can browse on your data: Sales invoices, Bills, Contacts, Payments, plus ready-made summaries such as who owes you most. Xero is marked Kept in sync on connectors. Freshness is noted on the copy. New sources are visible to admins until you open them to the team or to named people. You choose how much history to keep.
  3. Connect Stripe. Stripe is not marked Kept in sync (only Xero and Google Search Console are). Ask your AI to set up the Stripe sync through that connector. The copy you then ask about matches your data: customers, subscriptions, charges, refunds. The Stripe key stays with Croft, encrypted, and never shown to apps or to the AI.
  4. Connect HubSpot, Pipedrive or Attio. These CRMs are not marked Kept in sync either, so ask your AI to set that copy up through the connector. HubSpot comes through as contacts, companies, deals and pipeline stages; Pipedrive as deals, people, organisations and activities; Attio as records, lists and deal stages.
  5. Connect Claude or ChatGPT. ChatGPT needs Plus or better. Cursor and Grok use the same kind of link. You bring your own AI account. It costs nothing extra on Croft.
  6. Ask in plain words. The assistant lists the sources you are allowed to see, reads them, and tells you when they were last synced, for example “Synced 12 minutes ago.” Use Sync now on the Data page for a fresh pull before a receivables meeting.

The connection is MCP, so any assistant that speaks it can use the same croft. The AI does not log into Xero, Stripe or the CRM. Company login sits in front of the croft, so teammates open the data and any related app without a separate login for each tool.

What questions can I ask Claude or ChatGPT?

Keep each question to the fields those sources actually bring in. These cover which customers owe us money AI, ask AI who owes us money, accounts receivable AI Xero, ask Claude which invoices are overdue, and overdue invoices across Xero and Stripe ChatGPT:

  1. Which customers owe us money?
  2. Which customers owe us the most, and how overdue are they?
  3. Which invoices are overdue?
  4. Which of those overdue invoices belong to a customer with a failed Stripe payment?
  5. Which Stripe charges failed this month, and which customers do we need to chase?
  6. Which HubSpot companies have open deals and overdue Xero invoices?
  7. Who owns that account in HubSpot? (or Pipedrive people and organisations, or Attio records)
  8. Which Pipedrive people have an open deal and an overdue Xero invoice?

Ask follow-ups in the same chat. The assistant stays on the copy, so you are not attaching another spreadsheet. Answers say when the data was last synced.

Xero already suggests the “who owes you most” question on your data. Stripe and CRM questions only apply once those copies are set up.

Can the same AI email the overdue list every Monday?

Asking is half of it. The other half is building on that same connection: a small app or scheduled automation, with the keys still held by Croft.

Ask your AI for jobs that match your data and automations:

  • Every Monday, email me the list of overdue invoices. That is the Xero job in full: how to get AI to email overdue invoices every Monday.
  • Every Monday, email me overdue Xero invoices next to any failed Stripe payments for those customers. Same pattern, two sources.
  • Draft an invoice for an overdue retainer, from Xero.
  • A weekly email of failed payments, from Stripe, or a refund approval app. Details: connect ChatGPT to Stripe.
  • A weekly pipeline review of closed and at-risk HubSpot deals, so sales sees who still owes money before standup. Details: ask AI about your CRM data.

The app uses your connectors without seeing the keys, can run on a schedule, and offers actions anyone’s connected assistant can run from then on. Actions that delete or cannot be undone ask first. Every run is logged with who asked and which AI did it. You can open the app, read it and change it. It sits on your private server. There is no per-automation fee. AI-powered steps use your own Claude or OpenAI account.

Everyone’s AI also shares team memory. Tell Claude “remember for the team: overdue invoices over $5,000 need Sam on the Monday email” and ChatGPT knows it too. See shared AI memory for your team.

That is the equal half: a current copy Claude, ChatGPT, Cursor or Grok can query across Xero, Stripe and the CRM, and a place those assistants can build the Monday email and the draft invoice on top of it.

Who sees the receivables data, and do keys reach the AI?

New sources start visible to admins only. An admin can open each source to everyone or to named people. Your AI follows the same rule, so finance data can stay with finance.

Croft holds the connection. The AI never sees a password or API key, and it does not log into Xero, Stripe or the CRM directly. Apps call tools through Croft’s gateway, which checks permissions and adds the key on the way out. Calls are audited. Browse the copy on the Data page: search, sort, filter, export to CSV. Choose history per source: 90 days, a year, or everything. The copy lives on a private server that is yours, backed up automatically.

Company login sits in front of the croft, so teammates open the overdue list without a separate Xero, Stripe or CRM login.

See pricing. 14-day free trial.

FAQ

Which customers owe us money, using AI?

Connect Xero so Sales invoices stay in sync. Connect Stripe and your CRM, and ask your AI to set those syncs up through the connectors. Connect Claude or ChatGPT, then ask. Answers say how fresh the data is. Start from your data.

How do I ask AI who owes us money?

You do not paste aged receivables into chat. Connect the tools, connect your AI, then ask in plain words. The AI reads the copy on your private server. Keys never reach the AI.

Can I ask Claude which invoices are overdue?

Yes. Ask Claude which invoices are overdue, or which customers owe the most and how overdue they are. Xero already has a ready-made summary of who owes you most, from Sales invoices.

Can ChatGPT see overdue invoices across Xero and Stripe?

Yes. Connect those tools, then connect ChatGPT. Ask across the sources you can see, for example which overdue invoices belong to a customer with a failed Stripe payment. Plus or better is required.

What is accounts receivable AI with Xero?

An assistant connected to a current Sales invoices copy, not last week’s export. On Croft that copy sits on your private server. The same connection can power the Monday overdue-invoice email.

Why not export aged receivables into ChatGPT?

Exports go stale and multiply as files. A Croft copy stays current, sits on your server, and the AI says how fresh it is. See stop exporting spreadsheets to ChatGPT.

Who can see our receivables, and does the AI get our keys?

Admins first. An admin can open each source to everyone or to named people. Your AI follows the same rule. Croft holds the connection. The AI never sees a password or API key.

Can the AI email the overdue list every Monday?

Ask it to build that job as a small app on Croft. Details: AI weekly overdue invoice email and automations.

How much does Croft cost?

Starter from $24/month billed annually, Growth $59 and Scale $99/month billed annually, Enterprise custom. 14-day free trial. See pricing.

Start free trial →  ·  Xero connector →  ·  Stripe connector →  ·  HubSpot →  ·  Connect Claude →  ·  Connect ChatGPT →  ·  Your data →  ·  Automations →  ·  Pricing →

More from the blog

CRM Quotes z z

Your team’s first app could be live tonight.

Free for a day, and a week once your first app is live. No card needed.