AI prompts for Controllers

For controllers. Close the month with one checklist, find odd entries before you close, match the bank to the books and compare the budget to what was spent.

7 tested prompts and 4 guides. Free. Copy them into Claude.

7 tested prompts for Controllers

1 of 7

Match a supplier bill to your order

Whoever pays the bills, when a supplier bill comes in and before you pay it.

Claude

What to paste in

  • Your purchase order, what you got, and the supplier's bill, with bank numbers taken out.
PromptPaste into Claude
I pay the bills for a [type of business]. Check this supplier bill against our order and what we got.

Purchase order (PO): [paste the PO number, each item, quantity and agreed price, and any agreed freight]
What we got: [paste the packing slip or our own count]
Supplier bill: [paste bill number, date, items, quantity billed, price billed, freight, tax and total]
Take out any bank or card numbers before you paste.

1. Make a table with one row per item: ordered, got, billed, PO price, billed price, and Match or Check.
2. For each Check, say what is off and the dollar difference. Flag any charge that is not on the PO.
3. Redo the bill math, including the total.
4. Show the amount that looks right to pay now and the amount to hold, with the math.
5. Write a short, polite email to the supplier about each problem.
6. Give me one line for our records: date, supplier, bill number, total billed, and amount in question.

Show your math. Use only what I pasted. If a number is missing, write [missing]. Do not guess. I make the final call on what to pay.

Built on this O*NET task for Bookkeeping, Accounting, and Auditing Clerks: “Match order forms with invoices, and record the necessary information.” O*NET, U.S. Department of Labor, CC BY 4.0.

See a real example

What went in

Made up business: Suds Corner Car Wash. Made up supplier: Sample Wash Supply. PO 318: foam soap, 10 drums at $95.00. Tire shine, 8 jugs at $22.00. Microfiber towels, 30 packs at $12.00. No freight agreed. What we got: foam soap 10 drums, tire shine 8 jugs, towels 24 packs. Bill SW-7710, Oct 14: foam soap 10 at $95.00 = $950.00. Tire shine 8 at $24.00 = $192.00. Towels 30 at $12.00 = $360.00. Freight $40.00. Total $1,542.00.

What Claude wrote

| Item | Ordered | Got | Billed | PO price | Billed price | Status | |---|---|---|---|---|---|---| | Foam soap | 10 | 10 | 10 | $95.00 | $95.00 | Match | | Tire shine | 8 | 8 | 8 | $22.00 | $24.00 | Check | | Towels | 30 | 24 | 30 | $12.00 | $12.00 | Check | Tire shine: $2.00 over per jug. 8 x $2.00 = $16.00. Towels: 6 packs billed, not received. 6 x $12.00 = $72.00. Freight: $40.00, not on the PO. Bill math is right: $1,542.00. Pay now: $950.00 + $176.00 + $288.00 = $1,414.00. Hold: $128.00. Email: "Hi, about bill SW-7710 for PO 318. Tire shine is billed at $24.00, but our PO says $22.00. We got 24 packs of towels, not 30. Freight was not on our PO. Please send a corrected bill or a $128.00 credit. Thank you." Record: Oct 14, Sample Wash Supply, SW-7710, $1,542.00 billed, $128.00 in question.

Tested on Claude Opus 5.5, October 2026

Check before you use it

  • Check what really arrived and your freight terms before you pay or send the email.

2 of 7

Chase late customer payments

Whoever tracks money customers owe, once a week.

Claude

What to paste in

  • Your list of open invoices with dates, amounts and payments, with no bank or card numbers.
PromptPaste into Claude
I track money customers owe our [type of business]. Today is [date]. Our payment terms: [for example, due 30 days after the invoice date]. Late fees: [paste our terms, or write "none"]. Message type: [email or text].

Open invoices: [paste customer, invoice number, invoice date, due date, amount, amount paid, and notes like a promised pay date]. Take out any bank or card numbers first.

1. Work out how many days late each invoice is. Check the date math.
2. Sort them into: not due yet, 1 to 30 days late, 31 to 60, 61 to 90, and over 90. Show the amount still owed and the total for each group.
3. For each late customer, write a short, polite reminder. Include the invoice number, amount owed and due date. Ask when they plan to pay. Be friendly when it is new and firmer when it is old.
4. Leave a blank for how to pay. Never ask for card or bank numbers in the message.
5. If it is a text, keep it under 300 characters and end with "Reply STOP to opt out."

No threats, no shame and no legal claims. Do not add late fees I did not list. Use only my facts. If I pick text, or if you suggest a call, put a note to me at the top: check the national Do Not Call list and our own Do Not Call list, and make sure this customer agreed to get texts, before I call or text.

Built on this O*NET task for Bookkeeping, Accounting, and Auditing Clerks: “Monitor status of loans and accounts to ensure that payments are up to date.” O*NET, U.S. Department of Labor, CC BY 4.0.

See a real example

What went in

Made up business: Sample Acres Farm. Made up customers. Today is Oct 19, 2026. Terms: due 30 days after the invoice date. Late fees: none. Message type: email. Hilltop Grocery, INV-118, sent Aug 4, due Sep 3, $1,640, paid $0. Corner Table Bistro, INV-125, sent Sep 2, due Oct 2, $920, paid $400, said they would pay the rest by Oct 10. Maple Street Market, INV-131, sent Sep 29, due Oct 29, $1,150, paid $0.

What Claude wrote

Not due yet: Maple Street Market, INV-131, $1,150, due in 10 days. Total $1,150. 1 to 30 days late: Corner Table Bistro, INV-125, $520 owed ($920 − $400), 17 days late. Total $520. 31 to 60 days late: Hilltop Grocery, INV-118, $1,640, 46 days late. Total $1,640. 61 to 90 and over 90: none. Email to Corner Table Bistro: Hi, invoice INV-125 still has $520 open after your $400 payment. It was due Oct 2, and you mentioned paying by Oct 10. When can we expect it? You can pay by [how to pay]. Thank you. Email to Hilltop Grocery: Hi, invoice INV-118 for $1,640 was due Sep 3 and is now 46 days past due. Please send payment this week, or reply with the date you will pay. You can pay by [how to pay]. Thank you.

Tested on Claude Opus 5.5, October 2026

Check before you use it

  • Make sure no payment came in since your list was made, and check the national Do Not Call list and your own before any call or text.

3 of 7

Match your books to the bank

Bookkeepers and owners, at month end or when the bank balance looks off.

Claude

What to paste in

  • Two lists of transactions, like your books and the bank statement, with only the last 4 digits of any account number.
PromptPaste into Claude
I need to match two lists for our [type of business]. List A is from [source, for example our accounting software]: [paste date, reference, description and amount]. List B is from [source, for example the bank or card statement]: [paste the same way]. I kept only the last 4 digits of any account number.

1. Match items with the same amount and a date within [number] days.
2. Make a table of items only in A, items only in B, and items that match but have a different amount or date.
3. Give a likely cause for each one, like timing, something entered twice, a wrong amount or swapped digits.
4. Show the total of A, the total of B and the difference.
5. Check that the unmatched items explain the whole difference. If they do not, say how much is still not explained.

Do not force a match if you are not sure. Mark it "possible match" and say why. Show your math. Use only my numbers.

Built on this O*NET task for Accountants and Auditors: “Review accounts for discrepancies and reconcile differences.” O*NET, U.S. Department of Labor, CC BY 4.0.

See a real example

What went in

Made up business: Sample Lotus Yoga. October. List A (our books): Oct 1, class pass sales, +3,200.00. Oct 3, studio rent, −1,800.00. Oct 7, mat cleaner, −64.00. Oct 15, class pass sales, +2,750.00. Oct 28, teacher pay, −1,400.00. List B (bank): Oct 1, deposit, +3,200.00. Oct 3, rent, −1,800.00. Oct 8, card charge, −46.00. Oct 16, deposit, +2,750.00. Oct 30, monthly fee, −15.00. Match window: 3 days.

What Claude wrote

Matched: Oct 1 deposit 3,200.00. Oct 3 rent 1,800.00. Class pass sales 2,750.00. | Group | Item | Amount | Likely cause | |---|---|---|---| | Only in A | Oct 28 teacher pay | −1,400.00 | Timing. Not through the bank yet. | | Only in B | Oct 30 monthly fee | −15.00 | Bank fee not in the books yet. | | Date differs | Class pass sales, Oct 15 vs Oct 16 | 0.00 | Timing. Inside the 3 day window. | | Amount differs | Mat cleaner −64.00 (Oct 7) vs card charge −46.00 (Oct 8) | 18.00 | Possible match. Digits look swapped. Check the receipt. | Total A: 2,686.00. Total B: 4,089.00. The bank is 1,403.00 higher. Check: 1,400.00 − 15.00 + 18.00 = 1,403.00. The unmatched items explain the whole difference.

Tested on Claude Opus 5.5, October 2026

Check before you use it

  • Tie the totals to your real books and statement before you post any fix.

4 of 7

Check the day's sales against cash and cards

Owners, managers or bookkeepers, each morning for the day before.

Claude

What to paste in

  • Your sales report totals, the card batch total and the cash count, with no card or bank numbers.
PromptPaste into Claude
I close out yesterday's sales for a [type of business]. Here are the sales report totals by payment type: [paste cash sales, card sales, gift cards, refunds, tips and any voids]. Here is the card batch total: [amount]. Here is the drawer start amount and the cash counted at close: [amounts]. Deposit prepared: [amount, or none]. Do not include any card numbers or bank account numbers.

1. Make a table: payment type, what we should have, what we have, and the difference.
2. Mark each difference over or short, with the dollar amount.
3. List common causes to check, like a missed refund, a wrong drawer start, a tip keyed wrong, a split payment or a cash payout with no slip.
4. Write a 3 line note to the manager about what needs follow up.

Show your math. Do not guess at numbers I did not give you. Do not blame any person. Just list the facts.

Built on this O*NET task for Bookkeeping, Accounting, and Auditing Clerks: “Reconcile or note and report discrepancies found in records.” O*NET, U.S. Department of Labor, CC BY 4.0.

See a real example

What went in

Made up business: Velvet Comb Salon. Oct 18. Sales report: cash sales $540.00, card sales $2,180.00, card tips $395.00, cash refunds $25.00, gift cards redeemed $120.00. Card batch total: $2,575.00. Drawer start: $150.00. Cash counted at close: $655.00. Deposit prepared: $505.00.

What Claude wrote

| Type | Should have | Have | Difference | |---|---|---|---| | Cash | $150.00 + $540.00 − $25.00 = $665.00 | $655.00 | $10.00 short | | Cards and tips | $2,180.00 + $395.00 = $2,575.00 | $2,575.00 | Match | | Gift cards | $120.00 | not given | Not checked | Deposit: $655.00 − $150.00 = $505.00. Right for the cash counted, but $10.00 under the $515.00 we should have. Causes to check for the cash: wrong change given, a cash payout with no slip, a refund not rung in, or a drawer that started below $150.00. Note to manager: Oct 18 cash is $10.00 short. Cards match the batch. Please check the drawer start, cash payouts and refunds. No gift card count was given, so gift cards are not checked.

Tested on Claude Opus 5.5, October 2026

Check before you use it

  • Recount the cash and check the printed reports before anyone is blamed for a shortage.

5 of 7

Sort bills into the right accounts

Bookkeepers, when entering the week's bills or before closing the month.

Claude

What to paste in

  • Your list of account codes and the bills, with vendor, date, what it was for and amount.
PromptPaste into Claude
I do the books for a [type of business]. Help me code these bills before I enter them.
Our account codes: [paste code numbers and names].
Bills: [paste date, vendor, what it was for, and amount. Add the code if one is already used.] Take out any bank or card numbers first.

1. Give each bill a code from my list only. If a bill fits two codes, pick one, say why in a few words and mark it CHECK.
2. If one bill has items for more than one account, split it and show the amounts.
3. Check the math. Do the parts add up to each total?
4. Flag bills that may be entered twice, like the same vendor and amount close together.
5. Give me a table I can copy: date, vendor, what it was for, amount, code, account name, note.
6. Show a total for each code and a grand total.

If you are not sure, say so. Do not make up new codes. I will make the final call.

Built on this O*NET task for Bookkeeping, Accounting, and Auditing Clerks: “Code documents according to company procedures.” O*NET, U.S. Department of Labor, CC BY 4.0.

See a real example

What went in

Made up business and vendors. Business: Sample Paws Grooming. Codes: 5100 Grooming supplies, 6100 Rent, 6200 Utilities, 6300 Repairs, 6400 Advertising, 6500 Office supplies. Bills: 1. Oct 6, Sample Pet Wholesale, shampoo and nail clippers, $186.40. 2. Oct 7, Sample Power Co., electric bill, $238.15. 3. Oct 8, Sample Print Shop, 300 flyers at $0.25, $75.00. 4. Oct 9, Sample Office Mart, printer paper $22.50 and dog towels $48.00, total $70.50. 5. Oct 10, Sample Plumbing, fix tub drain, parts $65 + labor $110, total $185.00. 6. Oct 13, Sample Pet Wholesale, shampoo and nail clippers, $186.40.

What Claude wrote

| Date | Vendor | For | Amount | Code | Account | Note | |---|---|---|---|---|---|---| | Oct 6 | Sample Pet Wholesale | Shampoo, clippers | $186.40 | 5100 | Grooming supplies | CHECK: same as Oct 13 | | Oct 7 | Sample Power Co. | Electric | $238.15 | 6200 | Utilities | | | Oct 8 | Sample Print Shop | 300 flyers | $75.00 | 6400 | Advertising | Math OK | | Oct 9 | Sample Office Mart | Printer paper | $22.50 | 6500 | Office supplies | Split | | Oct 9 | Sample Office Mart | Dog towels | $48.00 | 5100 | Grooming supplies | Split | | Oct 10 | Sample Plumbing | Tub drain fix | $185.00 | 6300 | Repairs | CHECK: $65 + $110 = $175, not $185 | | Oct 13 | Sample Pet Wholesale | Shampoo, clippers | $186.40 | 5100 | Grooming supplies | CHECK: same as Oct 6 | Totals: 5100 $420.80, 6200 $238.15, 6300 $185.00, 6400 $75.00, 6500 $22.50. Grand total $941.45. Not sure: the two pet supply bills may be two real orders. Check the bill numbers. The plumbing bill may have a $10 fee or tax that is not listed.

Tested on Claude Opus 5.5, October 2026

Check before you use it

  • Look at each CHECK line with the real bill, and make sure the grand total matches what you entered.

6 of 7

Check an invoice before you send it

Whoever does billing, before invoices go out to customers.

Claude

What to paste in

  • The work record, your price list and the draft invoice, with no personal ID numbers.
PromptPaste into Claude
Check this invoice before I send it. Today's date: [date].
Work record: [paste the approved timesheet, job notes or delivery list: date, what was done, hours or quantity].
Our price list: [paste each service or item and its price, including any overtime or rush rate].
Draft invoice: [paste each line and the total].
Take out Social Security numbers, birth dates, ID numbers and pay details first.

1. Check each line against the work record. Do the hours or quantities match?
2. Check that the right price from my list was used.
3. Check the math on each line and the total.
4. Flag lines that show up twice, work done but not billed, lines with no date, and dates in the future.
5. Make a table of only the lines with a problem: line, what the invoice says, what it should be, and the difference.
6. Say what to check for each one.

If everything matches, say so. Do the math step by step. Do not guess prices or hours. I will make the fixes in our billing system.

Built on this O*NET task for Billing and Posting Clerks: “Verify accuracy of billing data and revise any errors.” O*NET, U.S. Department of Labor, CC BY 4.0.

See a real example

What went in

Made up business: Bright Path Tutoring. Made up customer: Sample Valley School. Today's date: Oct 19, 2026. Work record, week of Oct 6: Oct 6, math group, 2 hours. Oct 7, reading 1 on 1, 1 hour. Oct 8, math group, 2 hours. Oct 9, test prep group, 1.5 hours. Price list: math or reading group $60 an hour. 1 on 1 $45 an hour. Test prep group $70 an hour. Draft invoice: Oct 6 math group 2 hrs x $60 = $120. Oct 7 reading 1 on 1, 1 hr x $60 = $60. Oct 8 math group 2 hrs x $60 = $120. Oct 8 math group 2 hrs x $60 = $120. Total $420.

What Claude wrote

| Line | Invoice says | Should be | Difference | |---|---|---|---| | Oct 7 reading 1 on 1 | 1 x $60 = $60 | 1 x $45 = $45 | $15 too high | | Oct 8 math group, second line | $120 | Remove it. The work record shows one session. | $120 too high | | Oct 9 test prep | Not billed | 1.5 x $70 = $105 | $105 too low | | Total | $420 | $120 + $45 + $120 + $105 = $390 | $30 too high | What to check: 1. Oct 7: Was this a 1 on 1 session? If yes, use $45. 2. Oct 8: Did a second group meet that day? If not, remove one line. 3. Oct 9: Add the test prep session if it was approved. Oct 6 has no problems.

Tested on Claude Opus 5.5, October 2026

Check before you use it

  • Use only an AI tool your company approves for billing data, and confirm each flag in your billing system before you fix it.

7 of 7

Compare the budget to what you spent

Owners, bookkeepers and managers, when a month, quarter or job closes.

Claude

What to paste in

  • Each budget or estimate line with the planned and actual amount, plus your notes on what changed.
PromptPaste into Claude
Here is our budget (or estimate) and what we really spent for [month, quarter or job] at our [type of business]: [paste each line with budget and actual]. Here is what I know about why things changed: [your notes, or write "none"]. Costs I could not place in a line: [list them, or write "none"].

1. Make a table with each line: budget, actual, dollar difference and percent difference. Show over budget as a positive number.
2. Sort by dollars over budget, most first.
3. Flag any line more than [10]% or [$ amount] over. If the job is still going, also show percent of budget used and flag any line over 90% used.
4. For each flagged line, explain why in one or two plain sentences, using only my notes. If my notes do not explain it, write "Need reason" and list two questions I should ask.
5. Give total budget, total actual and total difference. Check the totals.
6. Write a 3 sentence summary for the owner or managers in plain words.

Show your math. Do not move costs between lines. Do not guess at causes.

Built on this O*NET task for Accountants and Auditors: “Develop, maintain, or analyze budgets, preparing periodic reports that compare budgeted costs to actual costs.” O*NET, U.S. Department of Labor, CC BY 4.0.

See a real example

What went in

Made up business: Sample Valley Youth Soccer Club. Fall season, now over. Fields: budget 6,000, actual 6,000. Referees: budget 4,500, actual 5,400. Uniforms: budget 7,200, actual 8,100. Equipment: budget 2,000, actual 1,650. Trophies: budget 900, actual 1,260. Flag over 10% or $500. Notes: two extra teams joined, so we bought more uniforms. Costs I could not place: none.

What Claude wrote

| Line | Budget | Actual | $ diff | % diff | |---|---|---|---|---| | Referees | 4,500 | 5,400 | +900 | +20.0% FLAG | | Uniforms | 7,200 | 8,100 | +900 | +12.5% FLAG | | Trophies | 900 | 1,260 | +360 | +40.0% FLAG | | Fields | 6,000 | 6,000 | 0 | 0% | | Equipment | 2,000 | 1,650 | −350 | −17.5% | | Total | 20,600 | 22,410 | +1,810 | +8.8% | Uniforms: Two extra teams joined, so we bought more uniforms. Referees: Need reason. Were there more games than planned? Did the referee rate go up? Trophies: Need reason. Did we buy trophies for the two extra teams? Did the price per trophy go up? Summary: The club spent $22,410 this fall, $1,810 (8.8%) over the $20,600 budget. Uniforms were $900 over because two extra teams joined. Referees were $900 over and trophies $360 over, and we still need the reasons.

Tested on Claude Opus 5.5, October 2026

Check before you use it

  • Tie the totals to your books and fill in every "Need reason" before you share the report.

Step by step guides

Tips from Controllers

Share a tip for Controllers

New AI tools for this job

Don't see your work here?

Tell me what you do every day, and I'll make guides and prompts for it.

Got a prompt that works? Add it here.

Want this built for you? Get it built.