---
name: department-spend-breakdown
description: "Department-level spend rollup with top vendors and outlier flags."
title: "Break down spend by department"
url: https://agents.ramp.com/playbooks/department-spend-breakdown
runtimes: [Claude Desktop, ChatGPT, Claude Code, Codex, Perplexity]
---

# Break down spend by department

Budget owners and finance teams need spend sliced by department, not just company totals. Your agent produces a department rollup with top vendors and flags departments that spiked versus the prior period.

## How to run

Identify which runtime you're operating in (Claude Desktop, ChatGPT, Claude Code, Codex, Perplexity). Use the matching section below; ignore the others.

## Claude Desktop

Copy and run this prompt:

```
## Before you run
- Ramp connector enabled in Claude Desktop ([connector directory](https://claude.ai/directory/61bac03c-3f98-4b3c-affb-1b99533fa82c))
- Finance or admin visibility into company spend

Break down Ramp spend by department.

Time window: [REPLACE — e.g. "last quarter" or "YTD 2026"]

Include:
- Total spend per department, sorted highest first
- Top vendor in each department if available
- Any department with unusual spikes vs. the prior period

Use structured aggregate reporting. Read-only — do not edit transactions or coding.
```

## ChatGPT

Copy and run this prompt:

```
## Before you run
- Ramp connector enabled in ChatGPT ([app](https://chatgpt.com/apps/ramp/asdk_app_69250fb6281c819195b52a1556b0060c))
- Finance or admin visibility into company spend

Break down Ramp spend by department.

Time window: [REPLACE — e.g. "last quarter" or "YTD 2026"]

Include:
- Total spend per department, sorted highest first
- Top vendor in each department if available
- Any department with unusual spikes vs. the prior period

Use structured aggregate reporting. Read-only — do not edit transactions or coding.
```

## Claude Code

Copy and run this prompt:

```
## Before you run
- Ramp CLI installed: `curl -fsSL https://agents.ramp.com/install.sh | bash`
- Logged in: `ramp auth login`
- Finance or admin visibility into company spend

Break down Ramp spend by department.

Time window: [REPLACE — e.g. "last quarter" or "YTD 2026"]

Include:
- Total spend per department, sorted highest first
- Top vendor in each department if available
- Any department with unusual spikes vs. the prior period

Use structured aggregate reporting. Read-only — do not edit transactions or coding.
```

## Codex

Copy and run this prompt:

```
## Before you run
- Ramp CLI installed: `curl -fsSL https://agents.ramp.com/install.sh | bash`
- Logged in: `ramp auth login`
- Finance or admin visibility into company spend

Break down Ramp spend by department.

Time window: [REPLACE — e.g. "last quarter" or "YTD 2026"]

Include:
- Total spend per department, sorted highest first
- Top vendor in each department if available
- Any department with unusual spikes vs. the prior period

Use structured aggregate reporting. Read-only — do not edit transactions or coding.
```

## Perplexity

Copy and run this prompt:

```
## Before you run
- Ramp connector enabled in Perplexity ([connector](https://www.perplexity.ai/computer/connectors?connector=ramp))
- Finance or admin visibility into company spend

Break down Ramp spend by department.

Time window: [REPLACE — e.g. "last quarter" or "YTD 2026"]

Include:
- Total spend per department, sorted highest first
- Top vendor in each department if available
- Any department with unusual spikes vs. the prior period

Use structured aggregate reporting. Read-only — do not edit transactions or coding.
```