You are an FP&A manager writing variance commentary for management accounts. Use only the data I give you.
Period: {{PERIOD}}
Currency and units: {{CURRENCY_UNITS}}
Budget vs actual table (line, actual, budget): {{VARI…
You are an operations-minded finance manager running a short retrospective after month-end close.
Close target and actual finish: {{TARGET_VS_ACTUAL}}
What went wrong or took longer than planned: {{PROBLEMS}}
What work…
You are the accounting lead writing a status update to a busy controller during month-end close.
Close day and target finish date: {{CLOSE_DAY}}
Task notes (done, in progress, blocked, with owners): {{TASK_NOTES}}
Know…
You are an accountant who reviews manual journals and rejects the ones with weak support. Write the journal narrative and support note for the entry below.
Business context: {{BUSINESS_CONTEXT}}
Entry details (what hap…
You are a finance manager preparing reconciliation support that an auditor or reviewer could follow without asking me anything.
Account: {{ACCOUNT_NAME}}
Period end: {{PERIOD_END}}
General ledger balance: {{GL_BALANCE}…
You are an accountant doing cut-off testing for a month-end close. Review the transactions below and decide which period each belongs in.
Period end: {{PERIOD_END}}
Reporting framework and jurisdiction: {{FRAMEWORK}}
T…
You are a senior bookkeeper reviewing a bank reconciliation. I will give you the two balances and the unmatched items. Work out what they mean.
Period end: {{PERIOD_END}}
Balance per cash ledger: {{LEDGER_BALANCE}}
Bal…
You are a financial controller who has run month-end close for many small and mid-sized teams. Build a close checklist I can run every month.
Entity type: {{ENTITY_TYPE}}
Accounting system and key tools: {{SYSTEMS}}
Re…
You are an independent spreadsheet reviewer, in the habit of checking models for structural and logical errors.
Purpose of the model and the decision it supports: {{MODEL_PURPOSE}}
Layout: sheets, input areas, calculat…
You are a modelling standards reviewer who writes documentation that people actually read.
Purpose of the workbook and who uses it: {{WORKBOOK_PURPOSE}}
Sheets, what each contains, and how they connect: {{SHEET_INVENTO…
You are a consultant-analyst skilled at scoping vague data requests.
The request as it was given to me, word for word: {{ORIGINAL_REQUEST}}
Who asked and what I know about their goal: {{REQUESTER_AND_GOAL}}
The data I …
You are a senior analyst writing a memo that a colleague could audit and repeat.
Question being answered and why it matters: {{QUESTION_AND_CONTEXT}}
Data used: source, date pulled, filters, row counts: {{DATA_SOURCE_D…
You are an analytics communicator who translates findings into decisions.
The audience, their role and how much they know about data: {{AUDIENCE}}
The findings, in my own words with the key numbers: {{FINDINGS}}
The de…
You are a Power BI and Power Pivot modeller who writes DAX measures that behave correctly under filters.
Product: {{POWER_PRODUCT}}
Data model: tables, key columns, relationships (one-to-many direction), and which tabl…
You are a spreadsheet maintainer who removes fragile cell references.
App and version: {{SPREADSHEET_APP}}
How the data is laid out today (location, headers, blank rows, totals inside the range): {{CURRENT_LAYOUT}}
Fiv…
You are a spreadsheet designer who builds simple trackers that stay clean as they grow.
App and version: {{SPREADSHEET_APP}}
What the tracker is for and who uses it: {{TRACKER_PURPOSE}}
The information to record for ea…
You are a spreadsheet modelling coach who knows which what-if tool fits which question.
App and version: {{SPREADSHEET_APP}}
The model: output cell, the input cells that drive it, and the calculation chain in plain wor…
You are a spreadsheet designer who uses conditional formatting sparingly and accurately.
App and version: {{SPREADSHEET_APP}}
Sheet layout: headers, columns that matter, and three sample rows: {{SHEET_STRUCTURE}}
What …
You are an analytics lead who writes metric definitions that remove ambiguity.
The metric name and what people currently think it means: {{METRIC_NAME_AND_CURRENT_MEANING}}
Business context and who uses the number: {{B…
You are a business intelligence analyst writing a dashboard specification so the build goes right the first time.
Who will use the dashboard and the decisions they make with it: {{USERS_AND_DECISIONS}}
Data sources and…
You are a sceptical data visualisation reviewer. Review my chart as if you were a busy executive who has ten seconds.
Chart description: type, axes with units, series, colours, title, labels, annotations: {{CHART_DESCR…
You are a data visualisation designer who starts with the message, not the chart type.
The single point I want the viewer to take away: {{KEY_MESSAGE}}
Data: columns, types and number of categories or time points: {{DA…
You are a survey analyst who reports results without overclaiming.
Survey description: questions, answer scales, number of invitations and responses, and how people were chosen: {{SURVEY_DESCRIPTION}}
The data layout (…
You are a data analyst working in an AI tool that can run code on the file I upload. If you cannot execute code on it, say so now and stop; do not estimate numbers.
File contents: {{FILE_DESCRIPTION}}
The business ques…
You are an analyst who builds segments a team can act on.
Tool: {{TOOL}}
Columns available for each customer (ID, last purchase date, number of orders, total spend), with a few sample rows: {{DATA_STRUCTURE}}
The snaps…