Report of total spend across every project

Ask your AI Agent to total your spend across every project and hand you a portfolio breakdown by project, category and vendor.
The Prompt
Copy and Paste this to your AI Assistant
Copy Prompt

Please total my FlipperForce spend across [PROJECT NAMES, or say: my active projects].

For each project, pull the expense line items, then give me:

1. Total spend per project, sorted highest first

2. Total spend by category across all of them combined

3. Total spend by vendor across all of them combined

4. The portfolio total

Note anything that looks unreliable, such as projects with no expenses recorded or large amounts sitting in a generic category, so I know how much to trust the numbers. Change nothing.

There is currently no workspace level expense endpoint, so this automation reads one project at a time. A full portfolio sweep means one request per project, which is fine at a few dozen projects and slow at several hundred. Scope it to what you actually need.

The Problem

Every project shows you its own numbers. Nothing shows you all of them at once.

So the question every investor eventually asks, what am I actually spending across my portfolio and where is it going, becomes a manual export from each project into a spreadsheet you rebuild every quarter and never quite trust.

The Solution

Your assistant pulls the expense line items from each project in scope and adds them up the way you asked, whether that is by category across the whole portfolio, by vendor, by month, or by project.

Because it is reading line item detail rather than project summaries, it can answer questions no single screen shows: what roofing has cost you across eleven flips, or which trade partner you have paid the most this year.

What it will not do: this automation is read only. It reports numbers and changes nothing.

Budget vs Actual
FlipperForce
Every project
Your assistant
Totals and groups
Spend breakdown
Nothing is changed
General Setup

This prompt requires a connection to the FlipperForce Public API. Once your AI agent is connected to your account, you can run any prompt in the library.

Learn how to connect your AI agent to the FlipperForce Public API

Endpoints Used
GET /project/list, GET /project/{uuid}/expense-line-items/list
Considerations Before You Run this Prompt:

Before you run this, check:

  • Your AI is connected to FlipperForce.
  • You have scoped it to what you need. There is no workspace level expense endpoint, so it reads one project at a time. A full sweep is one request per project, fine at a few dozen and slow at several hundred.
  • Your books are attributed. Rolling up spend across projects with large uncategorized balances gives you a confident looking number built on a generic bucket. Run the incomplete expenses audit first if you have never checked.

Other AI Prompts