/
/
See unpaid bills from vendors whose insurance has lapsed
For accounts payable teams who want Procore insurance expiry checked against open Intacct bills, just by asking their AI assistant.
On this page
Connector
Connect Sage Intacct, pick your AI tool and paste the prompt.
The problem
Bills get paid to vendors whose insurance has lapsed
Insurance expiry dates sit in Procore while unpaid bills sit in Intacct, and the two are never checked together. Payments go out before anyone notices that a policy has lapsed.
Without PopdockAI
- Filter the Procore insurance list for expired policies
- Note each vendor and the latest expiry
- Search Intacct for that vendor's open bills
- Total the amounts due in a spreadsheet
With PopdockAI
- Lapsed and expiring policies are found in Procore, using the latest per vendor
- Each vendor's unpaid bills are looked up in Intacct
- Lapsed vendors with open bills come first, with totals and due dates
- Facts only: it does not recommend holding payment
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find vendors whose Procore insurance has expired or expires within `{days-ahead}` days (default 30), then show the unpaid Intacct bills from those vendors.
**Servers:** this prompt uses tools from two servers, so both procore-core (Procore) and intacct (Intacct) must be connected. Tools whose names start with procore are on procore-core; tools whose names start with intacct are on intacct.
**Step 1: Find lapsed or expiring insurance in Procore**
Call `procore-get-vendors-insurances` (Procore) with `expiration-date.to` set to today plus `{days-ahead}` days, `company` set to `{company}` if given, and `max-records` 100. Note `vendor-name`, `policy-number`, `status` and `expiration-date`. If a vendor has several policies, keep the one that expires last and treat the vendor as lapsed only if that one is within the window.
**Step 2: Find unpaid bills in Intacct**
For each lapsed vendor call `intacct-get-bill` (Intacct) with `vendor-name` set to the Procore `vendor-name` and `total-due.min` set to 0.01. Note `bill-number`, `bill-date`, `due-date`, `total-due` and `state`. If the vendor name returns nothing, retry with `vendor-name.contains` and the first two words, and mark the match "by partial name".
**Step 3: Report**
Give a table with one row per vendor: vendor, policy number, expiration date, days to expiry (negative if lapsed), number of open bills, total due, earliest due date. Put lapsed vendors with open bills first. Then list lapsed vendors with no Intacct bills and vendors with no Intacct match.
**Rules & Guidelines:**
* This prompt is read-only. Never call any Procore tool that creates, updates or deletes, or `intacct-create-vendor`, `intacct-create-project`, `intacct-update-vendor`, `intacct-update-project` or any other Intacct tool that creates or updates.
* Do not recommend holding a payment; report the facts and let the user decide.
**Validation:**
* If Procore returns no policies in the window, say so and stop.
* If a vendor name matches more than one Intacct vendor, list the candidates and do not add up their bills.
* If either server is not connected, name it and stop.Who it's for
One answer, three teams that use it
Accounts payable
Check before you release payments
See which vendors with lapsed insurance have bills waiting, and the earliest due date.
Which vendors with lapsed Procore insurance have unpaid bills in Intacct?
Risk managers
Track compliance against money owed
See how much is owed to vendors whose policies are expired or about to expire, ahead of renewals.
List vendors whose Procore insurance expires in the next 60 days and total their open Intacct bills.
Controllers
Review exposure at period end
Include a check of insurance status against open payables in your close checklist.
Before we close October, show vendors with expired Procore insurance and what we owe each in Intacct.
How it works
What PopdockAI does when you ask
You choose the window. Your AI assistant reads both systems and reports vendor by vendor, and it changes nothing.
Ask
You say how many days ahead to look for expiring insurance, 30 by default.
Find policies
It finds vendors in Procore whose insurance has lapsed or expires within that window.
Find bills
It looks up each vendor's unpaid bills in Intacct and marks any partial name match.
Report
A table shows expiry, open bills, total due and earliest due date for each vendor.
What PopdockAI provides
The tools behind the answer
Ready made tools for Sage Intacct and one secure connection to your AI tool. No code, no exports.
procore-get-vendors-insurances
sage-intacct-get-bill
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
Know the exposure before the payment run
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
