Finance
Verified by Toolspoke

Receivables aging report

By Toolspoke

Buckets open QuickBooks invoices by age every Monday and posts one summary to Teams, naming the largest overdue customers.

Needs a Toolspoke account. You choose which project it installs into.

An illustration with made-up examples. It is not a recording.
QuickBooks Online + Microsoft Teams
Required integrations
Runs on a schedule
Mondays at 9am by default
Post one message
What its last step does
Some actions can delete
3 of 21 actions in its tools
On this page
  1. The short version
  2. What it will never do
  3. What Receivables aging report does
  4. How it works
  5. What a Monday summary looks like
  6. Who uses Receivables aging report
  7. What it connects to
  8. When it runs
  9. How to set it up
  10. Make Receivables aging report fit your team
  11. Compared with other options
  12. Questions
  13. Related agents

The short version

What it is
A ready-made Toolspoke agent that turns your open QuickBooks invoices into a weekly aged receivables summary in Teams.
What it reads
Every invoice with a balance still due, and the customer each one is for.
Where it posts
One Microsoft Teams channel, chosen when you set it up.
How it sorts
Current, 1 to 30, 31 to 60, 61 to 90 and over 90 days past due, with totals per currency.
How often
Every Monday at 9am once you switch it on.
What it never does
Change an invoice, a payment or a customer, or contact a customer.
What you need
A Toolspoke account, a QuickBooks Online sign-in and a Microsoft Teams account.

What Receivables aging report will never do

Receivables aging report cannot change anything in QuickBooks, and it is told never to contact a customer or post anywhere but your chosen channel. It reports, and a person decides who to chase.

Receivables aging report will never

  • Create, change, void or delete an invoice, a payment or a customer.
  • Email, message or otherwise contact a customer.
  • Reply to a thread, start a chat or post to any channel other than the one chosen at install.
  • Post a customer's email address, phone number or billing address.
  • Mark the post as urgent.

Why it does not chase

Who to chase, and how firmly, depends on things the ledger does not show: a dispute, a promise made on the phone, a customer worth keeping. The summary gives a person what they need to decide.

What it keeps out of Teams

A finance channel is often read by more people than QuickBooks is. The post names the customer and the invoice number, and nothing more.

A post that oversharesHarbour Freight Co owes 10,200. Accounts: [email protected], 555 0142, 12 Dock Road.
What this agent writes insteadHarbour Freight Co, 10,200 USD. Oldest INV-2148, 104 days late.

Why posting is already locked down

Teams posts are destructive actions in the connector, so the agent can only post if you allow post_channel_message by name. Leave reply and chat off, and it has one way to speak.

These are written into Receivables aging report's instructions. They guide the agent, but they are not a permission. What it is allowed to touch is set by the access you grant.

Receivables aging report reads QuickBooks and posts one summary. Every reminder to a customer is a person's call.

What Receivables aging report does

Receivables aging report is an AI agent that reads every open invoice in QuickBooks each Monday, buckets what is owed by how late it is, and posts one summary to a Microsoft Teams channel.

An aged receivables report is the first thing a finance lead wants on a Monday and the last thing anyone has time to pull. It means running the report in QuickBooks, sorting it, and writing a summary the rest of the team will read.

Receivables aging report does all three. It reads every invoice with a balance still due, sorts the balances into five age buckets, ranks the customers holding the most overdue money and says how the total moved since last week.

It only reads and reports. The QuickBooks connection has no action that can change an invoice, and the agent is told never to contact a customer. Who gets chased, and how, stays with a person.

In practice, every Monday morning your finance channel gets:

  • The total overdue, and whether it went up or down since last week
  • Five age buckets with totals and invoice counts, per currency
  • The largest overdue customers, each with their oldest invoice
  • One post, under 25 lines, in the channel you chose

How it works

Receivables aging report works in four steps each Monday: it reads the open invoices, buckets them by age, names the largest overdue customers and posts one message. All of it comes from the agent's written instructions, which you can read and edit after you install it.

  1. Step 1: Read open invoices

    It queries every invoice with a balance still due.

  2. Step 2: Bucket by age

    Current, 1 to 30, 31 to 60, 61 to 90 and over 90 days.

  3. Step 3: Name the largest

    It ranks customers by total overdue and keeps the top five.

  4. Step 4: Post one summary

    It posts to your channel with the change from last week.

Drawn from this agent's own tools and instructions. It is not a recording of a run.

It reads every open invoice, not the first 100

QuickBooks has no listing route, and list_invoices returns only the first 100. The agent uses run_query with a statement for invoices whose balance is above zero, and pages until it has them all.

It never mixes currencies

Each bucket is totalled per currency. A company that invoices in USD and CAD sees two totals, not one number that means neither.

It compares with last week

It reads the previous Monday's post in the same channel with list_channel_messages, and says whether the total overdue and the over 90 bucket rose or fell.

It posts once, in one channel

The summary is a single post_channel_message to the channel chosen at install. It never replies to a thread or starts a chat. The limits are listed under what it will never do.

What a Monday summary looks like

A summary from Receivables aging report is one Teams post: the total overdue, the five buckets, then the customers holding the most.

Finance · General

Receivables aging reportAPP9:00 AM

Aged receivables, Monday 26 October. 48,920 USD overdue across 23 invoices, down 6% on last week.

Over 60 days

  • Over 90 days: 12,400 USD, 4 invoices. Up 1,800 since last week.
  • 61 to 90 days: 9,150 USD, 5 invoices.

Largest overdue customers

  • Harbour Freight Co, 10,200 USD. Oldest INV-2148, 104 days late.
  • Pinewood Clinics, 6,300 USD. Oldest INV-2207, 72 days late.
  • Atlas Joinery, 4,880 USD. Oldest INV-2290, 41 days late.

Under 60 days and current

31 to 60 days: 14,620 USD. 1 to 30 days: 12,750 USD. Current: 71,300 USD not yet due.

One post, on Monday at 9:00 AM. The companies and amounts are made up.
Over 60 days

The buckets that most need a conversation, with the change since last week so a growing problem is visible.

Largest overdue customers

The customers holding the most overdue money, each with their oldest invoice and how late it is. Five by default.

Under 60 days and current

The rest of the ledger, so the post adds up to everything that is owed.

Why it always posts

An aged receivables report is useful even when nothing changed, so Receivables aging report posts every Monday. A week with nothing overdue says so in one line.

If QuickBooks cannot be read, it posts a short message saying so, because a missing Monday report looks the same as a quiet one.

Who uses Receivables aging report

Receivables aging report suits any business that invoices from QuickBooks Online and works in Microsoft Teams. The examples use made-up names.

A finance lead running the Monday meeting

Grace Whitfield used to export the aging report before every Monday meeting. Now the numbers are already in the channel when the meeting starts.

In their postNeeds youOver 90 days: 12,400 USD, 4 invoices. Up 1,800 since last week.

A managing director who wants one number

Daniel Osei does not open QuickBooks. The first line of the post tells him how much is owed and which way it is moving.

In their postWorth knowing48,920 USD overdue across 23 invoices, down 6% on last week.

An account manager with big customers

Priya Nair looks after the largest accounts. When one of hers appears in the top five, she knows to ask before finance chases.

In their postNeeds youHarbour Freight Co, 10,200 USD. Oldest INV-2148, 104 days late.

A bookkeeper for a growing firm

Lucas Moreau keeps the books part time. The weekly post is a record he can scroll back through to see how collections are trending.

In their postWorth knowingCurrent: 71,300 USD not yet due.

What Receivables aging report connects to

Receivables aging report connects to two tools: it reads QuickBooks and posts to Microsoft Teams. You sign in to each one yourself, and Toolspoke stores the connection encrypted, so the agent never sees the credential.

  • QuickBooks Online

    Required

    Read a QuickBooks company: invoices, bills, customers, vendors, the chart of accounts, and the two headline reports.

    Authentication: Sign in with Intuit

    View integration for QuickBooks Online

  • Microsoft Teams

    Required

    Read Teams channels and chats, follow threads, and post messages and replies.

    Authentication: Sign in with Microsoft

    View integration for Microsoft Teams

What Receivables aging report does and cannot do in each connected tool
ToolWhat Receivables aging report doesWhat it cannot do
QuickBooksReads open invoices and customers (run_query, list_invoices, get_invoice, get_customer).Create, change, void or delete an invoice, a payment or a customer: every QuickBooks action on the connector is a read.
Microsoft TeamsFinds the channel (list_joined_teams, list_channels), reads last week's post (list_channel_messages) and posts once with post_channel_message.Post at all until you allow post_channel_message: every Teams post is classified destructive, so a read or write grant does not reach it. It has no action that deletes a message.

The QuickBooks connection only reads, which is a property of the connector. Nothing this agent does can change your books.

A Teams post cannot be recalled, so the connector treats posting as destructive. To let this agent post, allow post_channel_message for it by name and leave reply_to_message and send_chat_message off. That is enforced on every call. The access control guide explains how.

Posting only to the channel you chose, and never contacting a customer, are instructions to the agent, not locks.

The activity log records each call, but QuickBooks reads that name a customer keep only that the call happened, and the text of each post is masked.

When Receivables aging report runs

Receivables aging report runs every Monday at 9am, but only after you switch its schedule on. It arrives switched off, so nothing runs and nothing is charged until you decide.

  • Each run reads every invoice with a balance still due.
  • Balances are bucketed by age and totalled per currency.
  • It posts one summary, even in a quiet week.
  • If QuickBooks cannot be read, it posts that instead.

Each run uses model credit from your workspace balance, so it makes one run a week. The QuickBooks and Teams calls themselves are free.

Your copy is an ordinary agent in your project. You can pause its schedule there, run it once on demand, change the day and time and edit its instructions. The agent's page lists recent runs and their cost.

How to set up Receivables aging report

To get an aged receivables summary every Monday, add Receivables aging report to a Toolspoke project, connect QuickBooks and Teams, allow one Teams action and switch on the schedule. It takes a few minutes, and nothing runs until the last step.

  1. Step 1: Create a Toolspoke account or sign in

    Choose Use this agent. If you are new, you will be asked to sign up first, and you come straight back to this agent afterwards.

  2. Step 2: Add it to a project

    Pick the project it should live in. You get your own editable copy, and you can see the two tools it brings before anything connects.

  3. Step 3: Connect QuickBooks

    Choose Sign in with Intuit and pick the company. The connection only reads.

  4. Step 4: Connect Microsoft Teams

    Choose Sign in with Microsoft with an account that is a member of the team you want to post in.

  5. Step 5: Allow posting to a channel

    In the project's access settings, allow post_channel_message for this agent. Leave reply and chat off.

  6. Step 6: Choose the channel

    Name the team and channel in the instructions, and the main currency to report in.

  7. Step 7: Switch on the schedule

    The schedule arrives switched off. Run it once and read the post, then switch it on.

Make Receivables aging report fit your team

Receivables aging report's instructions are plain English and you can edit them after you install it. Installing copies the agent, so your edits stay with your copy. Open the agent in Toolspoke and tell the builder what to change, and it rewrites the instructions.

Paste any sentence below into the builder chat, or say the same thing in your own words.

Name more customers
Name the ten largest overdue customers, not five.
Leave out small balances
Do not name a customer whose overdue total is under 500.
Run before month end
Also run on the last working day of each month.

This changes when the agent wakes up, so the builder edits its schedule, not the instructions.

Flag one account
Always mention Harbour Freight Co if they have anything over 60 days.
Change the buckets
Use 1 to 45, 46 to 90 and over 90 days instead of the usual buckets.

None of these edits needs more access or touches the Never rules. They change what Receivables aging report is told, not what the connections allow.

How it compares to other options

Receivables aging report beats the alternatives when you want the aging report summarised in the channel where your team already works, and loses to them when you need the full report with every invoice line.

Receivables aging report compared with QuickBooks' aging report, A Power Automate flow, Pulling it yourself
Compared onReceivables aging reportQuickBooks' aging reportA Power Automate flowPulling it yourself
Arrives in Teams without anyone opening itYes, every MondayScheduled email onlyIf you build itNo
Names the largest overdue customersYesYou sort itIf you build itIf you do it
Says how it changed since last weekYesNoHard to buildIf you keep notes
Every invoice line in fullNo, a summaryYesDependsYes
Can change the booksNo, the connector only readsIt is the booksDepends on the connectorUp to you
Setup effortConnect two accountsNoneBuild and test a flowHalf an hour a week

QuickBooks' own A/R aging report is the better choice when you need every invoice line, or an export for an auditor. Receivables aging report is a summary for the people who will not open it.

A Power Automate flow suits a team already building flows in Microsoft 365. You can post a report there, but you write and keep the bucketing and ranking yourself.

Frequently asked questions

Can Receivables aging report change an invoice in QuickBooks?

No. Every QuickBooks action on the connector is a read, so the connection cannot create, change, void or delete anything.

Does it email or chase customers?

No. It is told never to contact a customer, and neither connection can send email. It posts one summary to your Teams channel.

Why does it need permission to post in Teams?

A Teams post cannot be recalled, so the connector treats posting as destructive and no read or write grant reaches it. Allow post_channel_message for this agent in your project (how access works).

Does it handle more than one currency?

Yes. Every bucket is totalled per currency, and it never adds two currencies together.

Does it read more than the first 100 invoices?

Yes. It queries every invoice with a balance due and pages until it has them all.

Can it post to Slack instead?

Not as it comes. It is built for Teams. For Slack, start from an agent in the Finance category that posts there, or ask the builder to rebuild this one with Slack.

Is Receivables aging report free?

It has no price of its own, and every Toolspoke plan includes agents. Tool calls cost nothing, but each run draws on your usage balance. Pricing has the details.

Start each week knowing who owes what

Connect QuickBooks and Teams, allow one Teams action, choose the channel and switch on the schedule. Your first summary lands on Monday at 9am.