Write clear variance commentary for monthly results Starter · Any AI assistant
Plain-language commentary on the main variances against budget and last year, with gaps flagged.
You are a financial controller writing variance commentary for management. The readers are department heads with little finance background.
Below is our [month] income statement summary with actual, budget and prior year columns in RM, plus my notes on known causes.
[paste table]
[paste notes]
Materiality threshold: [for example, variances over RM 50,000 or 10%]
Write:
1. A three-sentence headline summary of the month.
2. A table of every line, with the variance in RM and % against budget and prior year, calculated by you.
3. Commentary for each line above the threshold: the variance, the cause from my notes and whether it is timing, one-off or ongoing.
4. A list of variances above the threshold that my notes do not explain, written as questions for the budget owner.
Rules: take causes from my notes only and write "Cause to confirm" where none is given; label each variance favourable or unfavourable; use plain words and explain any finance term you need. Tip: Check the calculated variances against your own workings before you rely on the commentary. Remove any employee-level salary detail, and use only your company's approved AI tool for unpublished results.
Build a month-end close checklist Starter · Any AI assistant
A day-by-day close checklist with tasks, owners, dependencies, evidence and review points.
You are a finance operations lead helping a Malaysian company tighten its month-end close.
Company: [industry, number of entities, accounting system]
Current close: [number] working days; target: [number] working days
Team: [roles]
Key areas: [for example, bank reconciliations, receivables, payables, accruals, payroll, fixed assets, inventory, intercompany]
Create a close checklist:
- Organised by working day, from Day -2 to the target day.
- For each task: description, owner role, dependency, evidence of completion and reviewer.
- Payroll-related reconciliations (EPF, SOCSO, EIS, PCB and HRD Corp levy payables), SST accounts where relevant and a monthly e-invoice check: sales and purchase e-invoices in MyInvois against the ledger, including consolidated, self-billed and cancelled e-invoices.
- The critical path tasks, clearly marked.
- Five controls that reduce errors, such as review of journals above a set amount.
Then suggest three tasks that could move before month end to shorten the close.
Format: a table I can paste into Excel. Tip: Paste your current checklist if you have one and ask the AI to improve it. A qualified accountant should confirm the statutory items match current rules.
Build a 13-week cash flow forecast Advanced · ChatGPT, Claude, Copilot
A weekly cash forecast from your receivables, payables and payment data, with low-cash weeks flagged.
You are a treasury analyst. I have attached [AR ageing, AP ageing, bank balances, payroll dates and recurring payments] as Excel files.
Opening cash balance: [RM amount and date]
Customer payment behaviour: [for example, government clients pay in 60 to 90 days, SMEs in 30 to 45]
Known one-off items: [capex, loan repayments, CP204 tax instalments, SST payments, bonuses]
Minimum cash buffer: [RM amount]
Build a 13-week cash flow forecast:
1. Weekly receipts from receivables by customer, using the ageing and the payment behaviour I gave, with stated assumptions for new sales.
2. Weekly payments: payables by due date, payroll and statutory contributions on their usual dates, rent, loans and the one-off items.
3. Opening balance, net flow and closing balance for each week, with a chart.
4. Weeks where cash falls below the buffer, highlighted.
5. Three actions to improve the low points, with their effect in RM.
6. A list of every assumption, so I can change them.
Give me the model as a downloadable spreadsheet. Then review your own model: check that closing balances roll forward correctly and name the assumption that moves the result most. Tip: Use your company's approved AI tool, since the files hold customer and bank data, and check the roll-forward and payroll dates yourself. Treat the forecast as a planning tool that finance updates every week.
Write a board finance summary on one page Starter · Claude, ChatGPT, Copilot
A one-page board summary of results, cash, outlook, risks and resolutions, checked against your figures.
You are a CFO preparing the finance section of a board paper. Directors read many papers and need the key points quickly.
Inputs:
- Results for [quarter or year to date]: [paste revenue, profit, margin, cash and debt, against budget and prior year, in RM]
- Full-year forecast: [paste]
- Key risks and issues: [list]
- Decisions needed from the board: [list]
Write a one-page board summary:
1. Three key messages at the top, one sentence each.
2. Performance against budget and prior year, in a small table with variances.
3. Cash and funding position.
4. Full-year outlook with its main assumption.
5. Risks, each with its potential impact and our response.
6. Decisions or approvals requested, worded as draft resolutions.
Use formal, neutral language. Then check your summary: list every figure you used with the input it came from, recheck each variance and flag anything that reads as a forecast stated as fact. Tip: Check the figure list against the board pack line by line. The CFO or finance director signs off the paper and the company secretary checks the resolution wording. Unpublished results of a listed company are price-sensitive, so use only your company's approved AI tool.
Reconcile two data exports and list the differences Advanced · ChatGPT, Claude, Copilot
A matched reconciliation of two files, such as bank and ledger, with every unmatched item listed.
You are a finance analyst. I have attached two files for [period]: [file A, for example, the bank statement as CSV] and [file B, for example, the cash book export from our accounting system].
Matching rules:
- Match on amount and on dates within [number] days, then on reference or description where available.
- Treat many-to-one matches, such as several receipts banked together, as matched if the totals agree.
Do the following:
1. Clean both files: standardise dates, amounts and signs. Report any rows you could not read.
2. Match transactions using the rules and show how many matched.
3. List unmatched items from each file in separate tables, each with a suggested reason such as timing, bank charges, a missing entry or a possible error.
4. Reconcile the closing balances: file A balance, adjustments, file B balance and any unexplained difference in RM.
5. Give me the matched and unmatched lists as a downloadable Excel file.
Leave doubtful items unmatched with a note; do not force a match. Tip: Use the data analysis feature so matching runs in code, then check five matched pairs by hand. Remove customer account numbers and names if your policy requires it.
Find what is driving a cost overrun (Advanced · ChatGPT, Claude, Copilot) Write the narrative for next year's budget (Starter · Copilot, ChatGPT, Claude) Check a batch of supplier invoices before payment (Advanced · ChatGPT, Claude, Copilot) Prepare a tracker for the year-end audit (Starter · Any AI assistant) Find the cash tied up in working capital (Advanced · ChatGPT, Claude, Copilot) Explain SST in plain language for colleagues (Starter · Any AI assistant) Check your e-invoicing setup with a guided interview (Advanced · Claude, ChatGPT, Gemini) Review an accounting treatment against MFRS or MPERS (Advanced · Claude, ChatGPT, NotebookLM) Chase overdue invoices in English and Bahasa Malaysia (Starter · Any AI assistant) Track progress billing on a property development (Advanced · ChatGPT, Claude, Copilot) Explain insurance results under MFRS 17 to managers (Starter · Claude, ChatGPT, Copilot) Work out food cost and margin per menu item (Starter · ChatGPT, Claude, Copilot) Write a budget justification for a funding request (Starter · Claude, ChatGPT, Copilot)