Connectors

/

Procore

/

Find Procore billing on inactive projects
Report

Catch billing still landing on closed Procore projects

For finance and operations leaders who want activity on inactive projects reported by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find Procore billing on inactive projects
Find any billing or costs booked since 1 October against inactive or completed projects in Procore.
4 of the 18 inactive or closed projects have activity since 1 October, totalling 312,400. - Riverside Tower Phase 1: 2 requisitions, 188,000, one open billing period - Fabrikam Depot: 3 direct costs, 74,900 - Contoso Warehouse: 1 requisition, 49,500 - Northwind Plaza: direct cost, 0 requisitions, 8,400 Want the full table with latest activity dates and a view on which look wrongly closed?
Procore
Sample figures. Your results come from your own account.
procore-get-projects
procore-get-requisitions
procore-get-direct-costs
procore-get-billing-periods
procore-get-lien-waivers

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Procore

Procore
Run it on your own Procore data.

Connect Procore, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Costs keep landing on projects that are closed

A project is marked inactive or closed while invoices and direct costs keep arriving. Nobody lines the project list up with the financial records, so the leak is found only when month end close starts.

Without PopdockAI

  • Export the project list and filter to inactive
  • Look up requisitions for each project
  • Look up direct costs and billing periods too
  • Total the amounts at month end

With PopdockAI

  • Inactive projects are judged by the active flag only
  • Requisitions, direct costs and open periods are read together
  • Results are ordered by amount, with a total
  • The check is read-only and capped at 25 projects, stated plainly

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Find activity booked since `{billing-date-from}` (default: the last 60 days) against Procore projects that are inactive or in the stage `{stage}` (default: any closed or completed stage).

**Step 1: Find the projects (core server)**

Call `procore-get-projects` and keep only the projects where `active` is false or `stage` matches. Keep `project-name`, `stage`, `active` and `actual-start-date`. If none qualify, say so and stop.

**Step 2: Read the activity (financials server)**

For each qualifying project (the first 25, and say so) call `procore-get-requisitions` with `project-name` and `billing-date.from`, and `procore-get-direct-costs` with `project-name` and `date.from`. Call `procore-get-billing-periods` with `project-name` and keep any period with a status that is still open.

**Step 3: Report**

A table: project, stage, requisitions billed (count and amount), direct costs (count and amount), open billing periods, latest activity date. Order by amount, highest first. End with the total amount booked against inactive projects and a short list of projects that look genuinely finished versus ones that look wrongly closed.

**Rules & Guidelines:**

* Tools named `procore-get-requisitions`, `procore-get-lien-waivers` and the other financial reads live on the Procore construction financials server (procore-construction-financials). Project, vendor, insurance, people and task tools live on the Procore core server (procore-core). Both servers must be connected; if a tool is missing, say which server is not connected and stop.
* Read-only. Do NOT reopen or close projects, and do NOT call `procore-update-billing-period`, `procore-create-billing-period` or any other write tool.

**Validation:**

* Treat a project as inactive only when core says `active` is false; do not infer it from a quiet period.
* If the financials server returns nothing for a project, list it as no activity, not as an error.
* State the exact date used for the default look-back.

Who it's for

One answer, three teams that use it

Finance directors

Protect the close

See what is booked against closed projects before month end rather than during it.

What has been billed or booked in the last 30 days against inactive Procore projects?

Controllers

Find wrongly closed projects

Separate projects that look finished from those that were closed too early and still have live billing.

Show me completed projects with requisitions since 1 November, and which look wrongly closed.

Operations leaders

Keep project status honest

Spot closed projects that still have open billing periods, and decide whether to reopen them.

Which closed Procore projects still have an open billing period or recent direct costs?

How it works

What PopdockAI does when you ask

You ask in plain words what is still posting to closed projects. Your AI assistant reads the project list and the financial records and reports, without reopening or changing anything.

Ask

You say how far back to look and optionally which stage counts as closed.

Your AI tool

Find

It finds the inactive or closed projects, up to the first 25.

procore-get-projects
procore-get-requisitions
procore-get-direct-costs
procore-get-billing-periods
procore-get-lien-waivers

Read

It reads each one's requisitions, direct costs and billing periods that are still open.

No items found.

Report

You get a table by project, ordered by amount, with a total and a view on which look wrongly closed.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Procore and one secure connection to your AI tool. No code, no exports.

get-data

procore-get-projects

Returns the projects in Procore, with project number, name, stage, active flag and dates. Filter by name, number or status.
get-data

procore-get-requisitions

Returns Procore subcontractor requisitions (invoices), with vendor, vendor invoice number, status, total claimed, payment due and billing date. Filter by project name and billing date range.
get-data

procore-get-direct-costs

Returns Procore direct costs, with vendor, date, status and amount. Filter by project or date.
get-data

procore-get-billing-periods

Returns Procore billing periods for a project, with their dates and open or closed status. Filter by project.
get-data

procore-get-lien-waivers

Returns lien waivers from Procore, with their status and the invoice or commitment they cover. Read-only.
Read only.Nothing in Procore Changes

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.

How Popdock AI secures your data

The outcome

Spend on closed projects found in days, not weeks

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation