Connectors

/

Procore

/

Check Procore time off against Ramp reimbursements
Report
Cross-Connector

Surface reimbursements filed during planned time off

For finance and operations leaders who want to see Ramp reimbursements dated inside Resource Management time off, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Check Procore time off against Ramp reimbursements
Between 1 and 30 June, which people with planned time off also have Ramp reimbursements dated inside it?
2 of 18 people with planned time off have Ramp reimbursements dated inside it, for review. - Employee 1042: time off 9 to 13 June, vacation, reimbursement 15 June for 84.20 - Employee 2217: time off 16 to 20 June, reimbursement 18 June for 132.50 - Employee 3305: time off 2 to 6 June, no Ramp user found Want me to list every person with no Ramp user?
Procore
Sample figures. Your results come from your own account.
procore-get-workforce-planning-people-time-off
ramp-get-user
ramp-get-reimbursement

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

Spend during time off is hard to see

Planned time off sits in Resource Management and reimbursements sit in Ramp. To spot spend filed during someone's absence you cross-read both systems person by person, which is rarely done.

Without PopdockAI

  • Export planned time off from Resource Management
  • Look each person up in Ramp by employee number
  • Check reimbursement dates against each absence
  • Repeat for every person on the team

With PopdockAI

  • Time off in your date range is read from Resource Management
  • People are matched to Ramp by employee number
  • Reimbursements dated inside the time off are listed
  • Items are for review, not findings, and nothing is changed

The prompt

Use this prompt

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

Prompt
**Objective:** Between `{from-date}` and `{to-date}` (ISO dates, defaulting to the next 30 days from today), find people with planned time off in Resource Management who also have Ramp reimbursements dated inside their time off, up to `{max-people}` records (default 25).

**Step 1: Read the time off (Procore Resource Management server)**

Call `procore-get-workforce-planning-people-time-off` with `max-records` set to `{max-people}`. Keep the entries whose `start-day` to `end-day` overlaps the date range. Take each person's employee number from `people-belonging-to-a-company-employee-number`. Keep `paid` and `reason`.

**Step 2: Find the Ramp user (Ramp server)**

For each employee number call `ramp-get-user` with `employee-id` set to it. Note the Ramp user `id`. If no user is found, list the person as having no Ramp user and continue.

**Step 3: Look for reimbursements (Ramp server)**

Call `ramp-get-reimbursement` with `user-id` set to the Ramp user id, `transaction-date.from` set to the time off start and `transaction-date.to` set to the time off end.

**Step 4: Report**

One row per person with time off and at least one reimbursement: employee number, time off dates and reason, and each reimbursement date and amount. Then list people with time off and no Ramp user. These are items to review, not findings of wrongdoing.

**Rules & Guidelines:**

* Procore Resource Management tools (names starting procore-get) and Ramp tools (names starting ramp-get) live on two different MCP servers; both must be connected. If either set of tools is missing, say which server is not connected and stop.
* This is a read-only review. Never call any write tool on either server, including `ramp-user-add`, `ramp-user-deactivate`, `ramp-user-update`, `ramp-vendor-add`, `ramp-vendor-update`, `ramp-location-add`, or any Procore tool whose name starts procore-create, procore-update or procore-delete.
* If the Procore tools ask for a `company` and more than one is available, ask which company to use before reading.
* Report only data the tools return; never guess a match.

**Validation:**

* If a Procore call returns nothing, report that and stop.
* If a Ramp call returns nothing for a record, report it as present in Procore and absent from Ramp, and continue with the next record.
* If a name or number matches more than one Ramp record, list the candidates and do not pick one.

Who it's for

One answer, three teams that use it

Finance leaders

Review expense timing

See reimbursements dated inside planned time off, as a list to look at rather than a conclusion.

Show reimbursements filed during planned time off between 1 and 30 September.

Operations managers

Check team absence and spend

Find people with time off and a Ramp reimbursement in the same dates, up to a number you choose.

Check the first 40 people with time off in July for Ramp reimbursements inside their dates.

Internal audit

Support a routine review

Get a repeatable list of overlaps by employee number, plus the people who cannot be matched to Ramp.

List people with planned time off next month who have no Ramp user, and any reimbursements in their time off.

How it works

What PopdockAI does when you ask

You pick the dates and the number of people. Your AI assistant reads both systems and reports the overlaps for you to review.

Ask

You give a date range and, optionally, how many people to check.

Your AI tool

Read time off

It reads planned time off in Resource Management that overlaps your dates.

procore-get-workforce-planning-people-time-off
ramp-get-user
ramp-get-reimbursement

Match

It finds each person in Ramp by employee number and looks for reimbursements inside their time off.

No items found.

Report

It lists each person with time off dates, reason and reimbursements, and lists people with no Ramp user.

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-workforce-planning-people-time-off

Returns time off recorded in Procore Resource Management per person, with start and end day, reason, paid flag and repeat.
get-data

ramp-get-user

Returns Ramp users as read from the Ramp connector. Filters include: scheduled invitation date to, status, last name, maximum records, role.
get-data

ramp-get-reimbursement

Returns Ramp reimbursements as read from the Ramp connector. Filters include: direction, transaction date from, id, transaction date to, maximum entity amount.
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

A short review list instead of a two system cross-read

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