Miles Free AI Library
← Back to resources
Prompt packMiles FinanceSep 14, 2026

Build a Personal CFO System in Claude

Get reusable prompts for live investment research, portfolio monitoring, spending audits, salary negotiation, subscription reviews, and a finance dashboard grounded in your own files.

Get the full MD

Download the complete Personal CFO tutorial

Free
Download MD

Build a Personal CFO System in Claude

Connect live financial data, analyze your money, automate portfolio reporting, and create a portable finance context folder.

What you will achieve

You will have a reusable set of prompts for investment research, portfolio monitoring, salary negotiation, subscription analysis, a full financial audit, and a personal finance dashboard grounded in your own files.

Who this is for

Investors, professionals, and households that want Claude to analyze financial information and maintain useful context over time.

Difficulty: Intermediate

Short tutorial

Connect live financial data, analyze your money, automate portfolio reporting, and create a portable finance context folder.

Guide: Build a Personal CFO System in Claude

Time: 45 to 60 minutes

What You Will Build

This tutorial turns Claude into a personal finance operating system. You will connect live market data, analyze your portfolio and spending, automate a morning portfolio report, and organize your financial context into files you control.

Use the prompts in the order shown. Replace bracketed fields with your information and attach the requested files. The dashboard requires the context folder described in the final section. If those files do not exist yet, skip the dashboard initially, create the folder, then return to it.

Prepare Your Financial Inputs

Collect the information relevant to the analyses you want to run:

  • Portfolio holdings, including ticker, shares or weighting, and cost basis
  • Bank and card statements covering 6 to 12 months
  • Statements from every card and your Apple account
  • Brokerage performance covering the last few years
  • Current income and desired income
  • Regular expenses, including housing, food, transport, subscriptions, and debt payments
  • Financial goals, constraints, and risk tolerance
  • Investment invalidation conditions, if you want automated portfolio alerts

You can store portfolio holdings in a Google Sheet that Claude can read, keep it updated manually, connect it to brokers through a read only API, upload a CSV, or send a screenshot of your positions.

Deep Financial Research

Connect the FMP data source

In Claude, open Connectors, select Add connector, choose Browse connectors, and search for FMP. Follow the displayed steps to sign in and verify the connection. The free tier covers 250 calls per day.

Run the following prompt for any public company you want to investigate:

TEXT
Use the FMP connector for all data in this research. Confirm you're pulling live data before proceeding.

Company: [ticker or company name]

Give me a complete research brief covering:

Fundamentals - revenue and earnings trend over the last 5 years, margins, debt load, free cash flow, and how each compares to its closest competitors

Filings - anything material from the most recent 10-K/10-Q or equivalent: risk factors that changed, guidance shifts, anything management flagged as new

Insider activity - recent insider buying or selling, and whether it's a pattern or a one-off

Analyst view - current price targets and rating distribution, and where the range is widest (that's usually where the real disagreement is)

Competitive position - who they're actually competing with, and whether their position is gaining or losing ground based on the data, not narrative

Close with: the single strongest bull argument, the single strongest bear argument, and the one metric you'd watch next quarter to see which one is winning.

The final three points give you a compact decision framework: the strongest upside case, the strongest downside case, and the metric that can distinguish between them.

Live Market Data on Your Portfolio

Attach your portfolio CSV, paste your positions, provide a readable Google Sheet, or upload a screenshot. Include cost basis whenever possible so Claude can calculate performance instead of only current value.

TEXT
Use the FMP connector for every query in this chat, not web search or memory. Confirm you're connected before proceeding.

Here's my current portfolio: [paste your holdings, or attach portfolio.csv if you have one - ticker, shares/weighting, cost basis]

Pull live quotes and current data on every position. Then give me:
- Current value of the portfolio and overall performance since cost basis
- Sector/asset concentration - where I'm overweight without realizing it
- Any position with a notable recent move (price, earnings, analyst estimate changes) I should know about
- How the portfolio compares to a simple benchmark like [the S&P 500 / your relevant index]

Flag clearly which numbers came from FMP live data versus anything you had to estimate or infer.

Before acting on the result, check that Claude confirmed the FMP connection and clearly distinguished live figures from estimates.

Scheduled Morning Portfolio Report

Copy
Create a scheduled task in Claude that runs each morning. The task should use your current portfolio data and any invalidation conditions you have defined.

Paste this as the task instruction:

TEXT
Run this portfolio report every morning using my current portfolio data and the FMP connector. Confirm that you are connected to FMP and use live market data rather than web search or memory.

My portfolio is here: [attach the portfolio file, identify the connected sheet, or paste the holdings]

My position invalidations are: [list the price, fundamental, earnings, guidance, thesis, or risk conditions that would invalidate each relevant position]

Review what changed during the last 24 hours and produce a concise daily market report covering:

1. Any material change in the fundamentals of a company I hold, including earnings, guidance, filings, analyst estimate changes, insider activity, debt, margins, or free cash flow.
2. Any position that reached or moved materially closer to one of my stated invalidation conditions.
3. Significant price or market events affecting my holdings that I need to be aware of.
4. Any suggested rebalancing supported by a real market event, a concentration change, or a change in the underlying fundamentals.

For every item, identify the affected position, explain what changed, and state whether the information comes from FMP live data or requires an estimate or inference.

Keep the report concise. If nothing material changed, say that clearly rather than filling the report with general market commentary.

Use Claude notifications for the default delivery. If you already have an external delivery workflow, the report can optionally be sent through email or Telegram using BotFather.

Personal Finance OS Dashboard

This dashboard uses profile.md, accounts.md, debts.md, spending.csv, and goals.md. It can also enforce rules from strategy.md when that file exists.

If you have not created these files yet, complete the Personal Finance Context Folder section below, then return here.

TEXT
Using the files in my context folder (profile.md, accounts.md, debts.md, spending.csv, goals.md), build me a single-page dashboard I can open and update over time.

Include:
- A net worth summary - total assets vs. total debts, trending over time
- An expense breakdown by category, pulled from spending.csv
- A debt payoff tracker - balances, rates, and progress toward payoff
- A goals section tied to goals.md, showing progress and target dates
- A "this month" summary - spend vs. plan, any rule breaches from strategy.md if I have one

Keep it clean and readable, not cluttered. Use real numbers from my files, not placeholder data. Tell me exactly how to update it going forward, whether that means re-running this prompt or editing the files directly.

The resulting HTML can be shared as a Claude artifact link. It can also be hosted on Vercel with password protection.

Salary Negotiation Prep

Replace the bracketed context with your role and compensation information. During the contribution interview, provide concrete results and let Claude push you for missing numbers.

TEXT
I want to build a case for a salary negotiation. Here's my context: [role, company, location, years in role, current salary].

First, research current market rate for this role, level, and location using the most credible, recent sources you can find. Give me a realistic range, not just one number, and tell me which sources you're drawing from.

Then help me build a contribution log: ask me for specific wins from the last [12/18/24] months, things I shipped, revenue or cost impact, problems I solved that weren't my job, anything with a measurable outcome. Push me for numbers wherever I'm vague.

Once we have both, build the case:
- The market data, stated plainly
- My contributions, tied to specific business outcomes
- A specific target number and a walk-away number
- Anticipated pushback and how I'd respond to each one

Write it so I could actually say it out loud in the room, not so it reads like a formal document.

The most useful final output should sound conversational enough to practice aloud. It should also separate your target number from your walk away number.

Subscription Leak Hunt

Upload statements from every bank card, credit card, and Apple account so recurring charges are not missed. Claude can return the result as a table that you can copy into a spreadsheet.

TEXT
Go through my statements and pull every recurring charge: subscriptions, memberships, app renewals, anything that bills on a schedule.

For each one, give me: the name, the monthly cost, and how often I actually seem to use it based on related transactions or my own estimate if you can't tell from the data alone.

Then calculate cost per actual use for each one, and rank the full list from worst value to best.

Flag anything that:
- Renewed without a matching transaction suggesting I used it
- I'm paying for in more than one place (duplicate coverage)
- Has a cheaper annual option I'm missing by paying monthly

Give me the total monthly and annual cost of everything ranked in the bottom half of the list, so I can see exactly what's on the table before I cancel anything.

When usage cannot be inferred from transactions, provide your own estimate rather than treating missing activity as proof that the service was unused.

Full Financial Audit

For this audit, provide a broader history than the subscription review. Include 6 to 12 months of bank and card statements, brokerage performance from the last few years, income, desired income, constraints, and complete monthly expenditure.

TEXT
I want you to conduct a full financial audit using my real financial data.

I am providing:

- 6 to 12 months of bank and card statements
- Brokerage performance from the last few years
- My current income: [current income]
- The income I would like to reach: [desired income]
- My financial constraints: [constraints]
- My regular monthly expenses, including rent or mortgage, food, transport, debt payments, subscriptions, and other recurring costs
- My current financial goals: [goals]

Start by going through every transaction and categorizing it. Use housing, food, transport, subscriptions, debt payments, discretionary spending, and any additional categories required by the data.

For each category, calculate the real monthly total. If I have not estimated my spending by category, ask me to do that before showing the actual figures so we can compare my perception with reality.

Highlight:

- The three categories where my estimate was furthest from the real amount
- Categories that increased month over month
- Duplicate charges, forgotten subscriptions, or spending that conflicts with a stated goal
- My real monthly surplus or deficit after all expenses
- My current financial positioning based on income, expenditure, debt, assets, and brokerage performance

Then run projections showing how my position could grow if my current income, spending, saving, and investment patterns continue.

Include a compounding section using a 10% annual return assumption. Show what my current monthly investable amount could become after 20 years if invested in an index at that assumed rate. Then show the result if I invested an additional $1,000 per month over the same period. State the assumptions used in both calculations.

End with a specific action plan based on the real numbers and line items in my data. Do not give me generic advice such as “spend less.” Identify the exact categories, transactions, contribution changes, or financial gaps that create the greatest impact.

Treat the 10% annual return as the requested projection assumption, not a guaranteed outcome. The point of the comparison is to show the potential effect of changing monthly contributions.

Personal Finance Context Folder

The context folder makes the system reusable. It stores your profile, accounts, debts, transactions, goals, financial rules, instructions, and an evolving memory in files you own.

A practical local structure is:

TEXT
personal-finance/
  profile.md
  Context/
    accounts.md
    debts.md
    spending.csv
    goals.md
    strategy.md
    instructions.md
    memory.md

The core files serve these roles:

FileContents
profile.mdIncome, dependents, goals, timeline, and risk tolerance
accounts.mdWhat you hold and where each asset or account is located
debts.mdBalances, interest rates, and minimum payments
spending.csvAt least the last three months of transactions
goals.mdWhat you are building toward, including target dates
strategy.mdYour saving rate, spending caps, and conditions that trigger a review
instructions.mdHow Claude should use and update the financial context
memory.mdImportant decisions and context that should persist over time

Use this prompt in Claude Code or Cowork. A voice conversation can make the initial interview faster.

TEXT
Help me build a portable personal finance context folder that I own and can use with Claude Code, Cowork, or another AI system.

Create and maintain this structure:

personal-finance/
  profile.md
  Context/
    accounts.md
    debts.md
    spending.csv
    goals.md
    strategy.md
    instructions.md
    memory.md

Set it up through a back-and-forth interview. Ask me one focused group of questions at a time and use my answers to populate the files.

The files must contain:

- profile.md: my income, dependents, financial goals, timeline, and risk tolerance
- accounts.md: every relevant account, what I hold, and where it is held
- debts.md: each balance, interest rate, and minimum payment
- spending.csv: my transaction history, including at least the last three months when available
- goals.md: what I am building toward, the amount required, and the target date
- strategy.md: my personal money rules, including saving rate, spending caps, and what should trigger a financial review
- instructions.md: instructions for using this folder as the source of truth for future financial analysis
- memory.md: important facts, decisions, preferences, and changes that should carry into future sessions

Use the financial data and outputs from my portfolio analysis, subscription review, full financial audit, and other finance work to update the relevant files.

Before writing information that is missing, ask me for it. Do not invent balances, transactions, goals, dates, rates, or preferences.

When the initial setup is complete, explain:

1. What was written to each file.
2. Which information is still missing.
3. How I should add new statements, transactions, account balances, goals, and decisions.
4. How to update memory.md as my situation changes.
5. How to use this folder with another AI system without losing the context.

Once populated, treat these files as the shared source for future prompts. Rerun the dashboard prompt after updating transactions, balances, debts, goals, or strategy rules.

Continue exploring

What to watch next