Grok finds overdue QuickBooks Online invoices through DeepLedger's MCP server: ask it for accounts receivable aging detail as of a date, have it rule out unapplied payments and credits, then have it draft follow-ups only for invoices that are really late. Grok reads and drafts; you decide who to contact and you send. This guide is for bookkeepers and owners who manage receivables and want a chase list they can trust.
An aging report tells you what the books show as outstanding. It does not tell you whether a customer disputed an invoice, promised payment or paid yesterday by a method that has not reached QuickBooks. That gap is why the workflow checks before it drafts.
The example uses a fictional company, Pinebridge Studio, not customer records. The report and transaction capabilities were checked against DeepLedger's tools on October 1, 2026, and the facts were reviewed in November 2026.
Before you start
- Connect Grok. Follow the guide to connect Grok to QuickBooks Online. In Grok chat, the connector address is:
https://mcp.deepledger.ai/mcp
- Confirm the company. In a new conversation, ask:
Using DeepLedger, which company am I in? Do not change anything.
- Choose an as-of date. For a September close, use September 30. For messages you plan to send today, use today's date and check for recent payments immediately before sending.
Intuit provides both accounts receivable aging summary and detail reports. The summary shows customer balances; the detail shows the documents behind them.
What does Grok do, and what stays with you?
| Step | Grok through DeepLedger | You |
|---|---|---|
| Pull aging | Retrieves A/R aging summary and detail as of your date | Choose the date and company |
| Find late invoices | Lists invoices past their due date with open balances | Agree the list |
| Check payments and credits | Finds linked or unapplied payments and credit memos | Decide how each one is applied |
| Draft follow-ups | Writes short, specific drafts | Edit, approve and send |
| Track open questions | Creates tasks in DeepLedger Tasks when you ask | Answer and close them |
DeepLedger works when you ask. Nothing runs on its own, so no customer is chased on a schedule: a follow-up or reminder happens only when you request it.
Step 1: How do I pull overdue invoices from QuickBooks with Grok?
Use DeepLedger for [company]. Confirm the company name and currency,
then retrieve accounts receivable aging summary and detail as of
[YYYY-MM-DD]. Get every page of detail needed for the review.
List overdue invoices with customer, invoice number, invoice date,
due date, open balance and days overdue. Use the report's dates and
aging settings. Separate invoices from credits and unapplied payments.
Show current amounts separately from overdue amounts, and tie the
detail back to the report totals. Do not change records or send messages.
Use the due date, not the invoice date, to decide whether an invoice is late. A September 20 invoice with payment due October 20 is still current on September 30.
For DeepLedger's aging tools, the report's end date is the as-of date. Cash and accrual switches used for a Profit and Loss report do not control these aging reports. When you check the result in QuickBooks, compare the same date, customers and aging settings.
Step 2: Has the customer already paid? Check payments and credits
Suppose the review for Pinebridge Studio shows these fictional balances:
| Customer and invoice | Due date | Open invoice amount | Review finding |
|---|---|---|---|
| Cedar Lane, INV-1042 | September 15 | $1,500 | No matching payment or credit found in the records reviewed |
| North Pier, INV-1048 | September 20 | $800 | An $800 unapplied payment needs investigation |
| Valley Works, INV-1055 | October 20 | $2,000 | Not overdue on September 30 |
The invoice amounts add to $4,300. The two past-due invoices add to $2,300, but that is not the amount to chase. North Pier's payment must be checked first. If it settles that invoice, the unresolved overdue amount is $1,500. Keep the unapplied payment visible when tying back to the report's net total.
Ask Grok to investigate without applying anything:
For [company], inspect each overdue invoice in the review list.
Look for linked payments, credit memos and unapplied customer payments.
Check partial payments and retrieve the current invoice balance.
Separate: ready for follow-up, possible payment or credit to review,
and missing information. Cite the QuickBooks transaction references.
Do not apply credits, record payments, write off balances or change
due dates. Flag anything that needs my decision.
Intuit documents cases where open customer items remain even with a zero net balance. That is why the invoice list and the customer balance both matter.
A possible payment is not enough to mark an invoice paid. Confirm the customer, amount and application. The QuickBooks connection does not give Grok your inbox, customer calls or bank website; supply that evidence separately.
Step 3: How do I draft an overdue invoice follow-up with Grok?
If your firm records a collections procedure in the client's AI Brain (for example, "no reminder before 7 days overdue; disputed invoices go to the account manager"), tell Grok to read it first. Grok reads the AI Brain when you ask, not on its own.
For [company], read the AI Brain operating procedures for collections.
Then draft a follow-up for each invoice I marked ready. Use the
verified customer name, invoice number, original due date and
remaining balance. Ask for the expected payment date, or payment
details if it has already been paid. Keep the tone courteous and brief.
Do not invent payment links, late fees, disputed terms or earlier
conversations. If those details are needed, ask me. Return drafts only;
do not send email or modify QuickBooks.
For Cedar Lane, a draft could read:
Hi [name], invoice INV-1042 for $1,500 was due September 15 and still shows an open balance in our records. Could you let us know when payment is expected? If you have already paid, please send the payment date and reference so we can check. Thank you.
Before sending, refresh the invoice balance and confirm the contact address. A September 30 review is a historical snapshot; a payment on October 1 can make yesterday's draft unnecessary.
These prompts produce text for review. Sending a custom message through an email service you connect to Grok is a separate request. Resending the invoice itself through QuickBooks uses DeepLedger's invoice email tool, explained in create QuickBooks invoices with Grok.
Step 4: Track what is unresolved in Tasks
Keep one row per invoice with its QuickBooks reference, open amount, latest check date, unresolved question and next action. Separate bookkeeping corrections from customer contact.
To keep the open questions in DeepLedger, ask Grok to create tasks. They appear on the company's Tasks tab, where your team can comment and complete them:
For [company], create a DeepLedger task for each unresolved invoice
in this list. Include the invoice reference, the finding, the evidence
needed and the decision for me. Check for an existing task first.
Leave QuickBooks records unchanged and do not contact customers.
A payment-application question belongs with the person reviewing the books. A customer follow-up belongs with whoever manages that relationship. Do not convert every overdue invoice into a bad-debt write-off.
Late receipts also move your cash position. Carry the expected collection dates into a 13-week cash flow forecast rather than assuming every invoice is paid on its due date.
Troubleshooting
Grok's overdue total does not match QuickBooks. The as-of date or aging settings differ. Ask Grok to show the date and settings it used, run Accounts receivable aging detail in QuickBooks with the same values, and compare customer by customer.
Grok lists an invoice that was paid last week. The payment is recorded but not applied, or it is not in QuickBooks yet. Ask Grok to look for unapplied payments for that customer, and check your bank deposits before sending anything.
Grok says it cannot see the aging report. The DeepLedger connector is off in this conversation, or the company is not connected. Start a new conversation, confirm the connector, and ask "which company am I in?". If QuickBooks needs a reconnect, an admin reconnects it from the company's Connections tab in DeepLedger.
The list is long and Grok stops partway. Large detail reports come back in pages. Ask Grok to retrieve every page and state the count of invoices it reviewed, then compare that count with QuickBooks.
Frequently asked questions
Can Grok find overdue invoices in QuickBooks Online?
Yes. Connected through DeepLedger's MCP server, Grok retrieves accounts receivable aging summary and detail as of a date you choose, lists invoices past their due date and checks them for payments and credits. Ask Grok to tie the detail back to the report totals before it prepares any follow-up.
Does an open invoice mean the customer has not paid?
Not necessarily. A payment or credit may be recorded in QuickBooks but not applied to the invoice, or a recent payment may not be in QuickBooks yet. Check the invoice and its supporting records before asking the customer to pay.
Will Grok email customers automatically?
No. DeepLedger works when you ask, and nothing runs on its own. The prompts in this guide ask Grok for drafts only. Sending a reminder is a separate request you make after checking the balance and the contact address.
Can Grok chase overdue invoices every week on its own?
No. DeepLedger has no scheduled or unattended runs, so Grok reviews overdue invoices only when you ask. Run the same prompts with a new as-of date whenever you want a fresh list.
Should Grok apply an unapplied payment to an overdue invoice?
Not during the review. The prompts in this guide tell Grok not to apply credits or record payments, so the review changes nothing in QuickBooks. A person confirms the customer, amount and invoice, then records the application and checks it in QuickBooks.
What as-of date should I use for an overdue invoice review?
Use the date that matches the purpose. For a month-end review, use the last day of the month, such as September 30. For follow-ups you will send today, use today's date and recheck each balance immediately before sending.
Related guides
- Connect Grok to QuickBooks Online
- Create QuickBooks invoices with Grok
- Five Grok bookkeeping prompts for QuickBooks
- Build a 13-week cash flow forecast from QuickBooks
- QuickBooks MCP server guide
Find every AI app DeepLedger works with on AI Platforms & Integrations.