Prompts that hold up in finance work, for the close, cash, VAT prep and board updates
Twelve prompts a finance lead can use this month, for the close, cash, VAT preparation and the board update, each with what to check before you trust the answer.
David van Duijn6 min read
Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.
On this page
A good finance prompt gives the assistant the data, the context and the format you need, and asks it to show its working and flag what it is unsure about. A bad one asks a question and trusts the answer. The prompts below are written for finance leads and controllers in growing companies, and each comes with what to check before you use the result.
They work in any capable assistant. Use a business plan with training switched off and a data processing agreement in place, and remove personal data you do not need. Replace the parts in square brackets with your own details.
What makes a finance prompt work?
Before the prompts, five habits that make every one of them better.
- Give the data, never ask it to remember. Paste or upload the trial balance, the export or the list. An assistant has no idea what your revenue was unless you tell it.
- State the frame. Entity, period, currency, reporting standard (Dutch GAAP, IFRS or FRS 102) and whether amounts include VAT.
- Ask for its working. "Show the calculation" turns an answer you have to trust into one you can check.
- Ask what it is guessing. "Mark every assumption" is the single most useful line in finance prompting.
- Name the output. A list of five items, a 150-word paragraph, an email in Dutch. Vague requests get padded answers.
Prompts for the month-end close
1. Variance commentary.
Attached is the P&L by account for [Company] B.V. for [month] and the same month last year, in EUR excluding VAT. List the eight largest movements in euros. For each, give the change, the percentage and one plausible explanation. Mark each explanation as "from the data" or "assumption". Do not explain movements under €2,000.
Check before you use it. Recalculate two of the movements yourself. Every "assumption" is a question for the account owner, not a sentence for the report.
2. Accrual candidates.
Here are two lists. List A is every supplier we booked an invoice from in each of the last three months. List B is the suppliers with an invoice booked this month. Show suppliers in A who appear in all three prior months but are missing from B, with their average monthly amount. These are candidates for an accrual.
Check before you use it. The assistant only sees invoices. A supplier on an annual contract, or one you stopped using, is not an accrual. You decide which candidates are real.
3. Explaining a reconciliation difference.
Our bank balance on [date] is €[x]. The ledger bank account shows €[y]. Attached are the unmatched bank lines and the unmatched ledger entries. Find combinations that explain the difference of €[x − y], such as one bank line that matches several entries. Show each proposed match with amounts so I can verify it.
Check before you use it. Hold every proposed match against the source documents. An assistant will sometimes find numbers that add up but do not belong together.
Prompts for cash
4. A short-term cash view.
Attached are our aged debtors and aged creditors as of [date] and our bank balance of €[x]. Build a week-by-week cash view for the next eight weeks. Assume customers pay [n] days after due date on average and we pay suppliers on due date. Add fixed outflows of €[salaries] on the 25th and €[rent] on the 1st. Show the closing balance per week and the lowest week.
Check before you use it. The payment assumption drives everything. Run it twice with a pessimistic and an optimistic number of days, and make sure VAT payments are in.
5. Collections priority.
From this aged debtors list, rank the customers we should call this week. Weigh amount overdue, days overdue and whether they have paid late before (column "late history"). Give the top ten with a one-line reason each.
Check before you use it. The ranking is a suggestion. You know which customer is in a dispute and which is a strategic account.
6. A reminder that keeps the relationship.
Write a second payment reminder in Dutch for invoice [number] of €[amount] including BTW, due [date], now 21 days overdue. Keep the tone friendly but clear. Ask them to pay within seven days or tell us if something is wrong with the invoice. Maximum 120 words. Add an English translation for me.
Check before you use it. Compare invoice number, amount and dates with the ledger, and run any statutory interest or collection-cost wording past your accountant before you add it.
Prompts for VAT preparation
The assistant does not file anything and does not decide treatments. These prompts help you find lines to look at before your accountant or your VAT process takes over.
7. Code consistency.
Attached are this quarter's purchase invoice lines with supplier name, supplier country, amount and VAT code. Flag lines where the same supplier has been booked with different VAT codes, and lines where the VAT code looks inconsistent with the supplier's country. Do not correct anything, only list them with the reason.
Check before you use it. Hold each flagged line against the invoice itself. A Dutch supplier can legitimately charge 9% on one line and 21% on another.
8. EU sales review.
Attached are this quarter's sales invoices to customers in other EU countries, with customer country, customer VAT number, amount and VAT charged. List invoices where we charged Dutch VAT to a business customer with a VAT number, and invoices with zero VAT but no customer VAT number. Explain why each might need a second look.
Check before you use it. Confirm the customer VAT numbers are valid in the EU's VIES service, and the treatment with your accountant. Rules differ for goods and services and for sales to consumers, so treat the output as a list of questions.
9. The quarter compared with the last.
Here are the totals per box of our Dutch VAT returns for the last four quarters and the draft totals for this quarter. Point out any box that moved more than 25% and suggest what in the business could explain it.
Check before you use it. Ask whether the movement is real business, such as a large purchase or a new market, or a booking error. The numbers in the draft must come from your ledger, not from the assistant.
Prompts for the board update
10. The first draft.
Write the finance section of our monthly board update for [Company]. Use only the figures attached (P&L, cash balance, debtors over 60 days, headcount). Use three sentences on the month, three numbers that matter with a comparison, two risks, one decision we need from the board. Maximum 250 words. Do not add figures that are not in the attachment.
Check before you use it. Hold every number against the source, and confirm that "do not add figures" was respected.
11. The questions they will ask.
Read this draft board update as a sceptical non-executive director with a finance background. List the five questions you would ask, ranked by how uncomfortable they are for management.
Nothing to verify here. This is preparation. The uncomfortable questions are usually the right ones to answer in the update itself.
12. Plain-language version.
Rewrite this update for a shareholder who is not a finance person. Keep every number, remove the jargon, and explain gross margin and runway in one sentence each.
Check before you use it. Make sure no number changed in the rewrite.
What should you never prompt for?
Some requests look efficient and create risk.
- "What was our revenue last quarter?" without data. You will get a guess or a refusal.
- "Book these entries." Suggested journals are fine. Posting them without review is not.
- "Is this transaction VAT exempt?" as a final answer. Ask for the general rule, then confirm with your accountant.
- Anything with full payroll files or customer bank details on a personal plan.
Where Thred fits
Notice the pattern in every prompt above: you export, you upload, you check the result against the ledger. The prompts work, but you are still the bridge between the books and the assistant.
Thred removes that step. With Thred Layer on top of your existing accounting software, you ask the same questions in Thred's chat, or in Claude, ChatGPT or Slack, and the answers come from the live books with each number traceable to its entry. The recurring parts, such as matching bank lines, chasing missing receipts and preparing the VAT return from the live position, run as agents under your rules. For controllers who want the close itself to change, our businesses page shows how the work is split between agents and your team.
Keep these prompts close, and if you would rather ask your books directly, book a demo.
Frequently asked questions
How do I write a good prompt for financial analysis?
Attach the data instead of asking the assistant to recall it, state the entity, period, currency and reporting standard, and say exactly what output you want. Ask it to show calculations and label anything it assumed, so you can check the answer quickly.
Can AI write variance commentary for management accounts?
It can draft a first version from the P&L you provide, listing the largest movements with possible explanations. Treat every explanation it cannot derive from the data as a question for the budget owner before it goes into the report.
Can I use AI to check my VAT return before filing?
You can use it to flag inconsistent VAT codes, EU sales that look wrongly treated or boxes that moved sharply between quarters. It should not decide the treatment, so confirm flagged items with your accountant and check EU VAT numbers in VIES.
What should I never ask an AI assistant to do in finance?
Do not ask it for figures without giving it the data, do not let it post entries unreviewed, and do not treat its answer on a specific tax position as final. Keep full payroll files and customer bank details off personal plans.
Sources
Read next
- Reading an invoice is the easy part. Checking it is the work
- Choosing an AI assistant for finance work, and what neither ChatGPT nor Claude should do with your books
- AI agents for finance teams: the recurring work they take over
Where Thred comes in
Finance agents running on top of your existing ledger. You set the rules, approve the work and handle the exceptions. No migration.



