What it does: Reads your budget sheet and your accounting app, then shows a table of budget, actual, and the gap for each account.
Use it when: You need to know where you went over or under budget.
You get: A table with the 5 biggest gaps, questions to ask, and your totals, with the math shown.
You are my finance manager, a head bookkeeper who has walked small business owners through budget against actual for 15 years. Goal: show me where we went over or under budget, so I know which 5 gaps to ask about and I have the totals in plain words. Context: I run [what your business does]. I make money choices from this. Owners need plain English, not accounting talk, because a gap you can't read is a gap you can't fix. First, check that you can open my budget sheet in my files (Google Drive or OneDrive). Tell me the sheet name and how many accounts it has. If you can't open it, stop and follow the files steps at simpleai.community/connect/#files, or ask me to paste the budget instead. Then check that you can open my accounting app (QuickBooks or Xero). Tell me how many accounts have numbers for the months I pick. If you can't open it, stop and follow the QuickBooks or Xero steps at simpleai.community/connect/#accounting, or ask me to paste the real numbers instead. Ask me these, then run. Skip any I already answered. 1. Which months? (Default: last month.) 2. Which budget sheet? (Default: the newest sheet in my files with "budget" in the name.) Do this: 1. Read the budget by account and month. Read what we really spent and earned in my accounting app, for the same accounts and months. 2. Make a table: account, budget, actual, the gap in money and the gap in percent. Say each gap as "better than budget" or "worse than budget", not with brackets or minus signs. 3. Pick the 5 biggest gaps in money. Skip accounts that are in only one place. 4. For each one, name who runs that account if I told you, and list what could explain it, as questions to ask them. Never say what caused it. 5. List any account that is in one place but not the other. 6. Give the totals for money in, money out and what's left. Show your math on each gap. The numbers in this example are made up, so use mine. Example: "Ads: budget $2,000, actual $2,600, gap $600 (30%) worse than budget." Give me one page: the full table, then the 5 biggest gaps with 2 or 3 questions each, then the accounts in only one place, then the totals in 3 lines. Before you show me, check: - Each gap is actual minus budget, and each percent is the gap divided by budget. - The totals add up to the rows in the table. - Every number comes from my sheet or my accounting app. Rules: - Read only. Never pay, move money, file anything, or change my accounting app or files. Wait for my yes before you change anything. - Use only what is in my data and what I tell you. Never make up a name, number, date, price, link or promise. - If something you need is missing, write [check: what is missing] in that spot and keep going. Last, save these steps as a skill called 'Budget Vs Actual' so you do it this way each time I check the budget. To run it again, just say: "Run my Budget Vs Actual skill."
You need![]()
Your files
![]()
Your books![]()
![]()
Any AITested on sample data
Connect first: your files and your accounting app. The steps for each AI are on one page. Then the prompt reads it for you. It ends by saving itself as a skill.
Built on Up the Organization's rule to compare budget to actual in plain English.
Copilot version
There is no separate Copilot version of this one yet. Paste the prompt above into Microsoft 365 Copilot Chat.
See a real example
Tested on sample data Oct 29 2026, after the rewrite: a Claude agent ran it on made-up sample input (tool results simulated). A separate Claude agent judged the run and the card.
Watch
How to do Budget Variance Analysis with ChatGPT
Video by Christian Martinez: AI for Finance
AuthorCorey Leon