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.
- 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
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.
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.
Step 1: Read open invoices
It queries every invoice with a balance still due.
Step 2: Bucket by age
Current, 1 to 30, 31 to 60, 61 to 90 and over 90 days.
Step 3: Name the largest
It ranks customers by total overdue and keeps the top five.
Step 4: Post one summary
It posts to your channel with the change from last week.
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
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.
- 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.
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.
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.
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.
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
RequiredRead a QuickBooks company: invoices, bills, customers, vendors, the chart of accounts, and the two headline reports.
Authentication: Sign in with Intuit
Microsoft Teams
RequiredRead Teams channels and chats, follow threads, and post messages and replies.
Authentication: Sign in with Microsoft
| Tool | What Receivables aging report does | What it cannot do |
|---|---|---|
| QuickBooks | Reads 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 Teams | Finds 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.
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.
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.
Step 3: Connect QuickBooks
Choose Sign in with Intuit and pick the company. The connection only reads.
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.
Step 5: Allow posting to a channel
In the project's access settings, allow
post_channel_messagefor this agent. Leave reply and chat off.Step 6: Choose the channel
Name the team and channel in the instructions, and the main currency to report in.
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 the ten largest overdue customers, not five.
Do not name a customer whose overdue total is under 500.
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.
Always mention Harbour Freight Co if they have anything over 60 days.
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.
| Compared on | Receivables aging report | QuickBooks' aging report | A Power Automate flow | Pulling it yourself |
|---|---|---|---|---|
| Arrives in Teams without anyone opening it | Yes, every Monday | Scheduled email only | If you build it | No |
| Names the largest overdue customers | Yes | You sort it | If you build it | If you do it |
| Says how it changed since last week | Yes | No | Hard to build | If you keep notes |
| Every invoice line in full | No, a summary | Yes | Depends | Yes |
| Can change the books | No, the connector only reads | It is the books | Depends on the connector | Up to you |
| Setup effort | Connect two accounts | None | Build and test a flow | Half 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.