AI For Finance - Prompt Library
Ready to use AI prompts for finance and accounting teams • ChatGPT, Claude, Gemini, Copilot
AI For Finance
✍️ Prompt Formula – How to Write Effective AI Prompts for Finance
Master the art of writing clear, professional prompts for finance and accounting work. This guide gives you a proven formula to get the best results from approved AI tools: ChatGPT, Claude, Google Gemini, and Microsoft Copilot.
ROLE + CONTEXT + TASK + FORMAT + CONSTRAINTS + OUTPUT QUALITY = Powerful Finance Prompt
🎯 The 6-Part Prompt Formula
Every strong finance prompt follows this 6-part structure. Each part tells the AI exactly what you need, so you get accurate, usable finance work instead of vague answers.
Step-by-Step Breakdown
1. ROLE – Tell the AI who it is
✓ “You are a finance manager preparing a monthly report for company management.”
✓ “Act as an accountant who structures financial statements clearly.”
2. CONTEXT – Give the numbers and background
Include company type, period, currency, available data, and business situation.
3. TASK – Explain exactly what you want
Ask for a report, analysis, formula, checklist, action plan, or template.
4. FORMAT – Tell the AI how to organize the answer
Example: table, numbered checklist, executive summary, sections, or ready-to-send message.
5. CONSTRAINTS – Set the rules
Example: USD only, simple English, do not invent numbers, ask questions if data is missing.
6. OUTPUT QUALITY – Define what good looks like
Example: ready to paste into Excel, management-ready, specific to my numbers, no filler.
1. Excel Automation
Use AI to build, fix, and speed up Excel work for finance and accounting teams. These prompts help you create formulas, clean messy data, build reusable templates, and automate repeat tasks without coding.
1Build an Excel Formula From Plain English
When you know what you want a cell to do but cannot write the formula yourself.
Role: You are an Excel expert who supports finance and accounting teams. You write clear, correct formulas and explain them in simple words. Context: I work in the finance team of [Company Name] in Phnom Penh. I am using [Excel / Google Sheets]. My data is laid out as follows: [describe columns, for example Column A = Date, Column B = Customer, Column C = Amount in USD]. The data starts in row [2] and ends around row [500]. Task: I want a formula that does this: [explain in plain words what you want, for example: add all sales for one customer in one month, or flag invoices over 30 days old]. Give me the exact formula I can paste in. Format: Give your answer in three parts: 1. The exact formula, ready to copy. 2. Which cell to put it in and how to drag it down. 3. A one line explanation of how it works. Constraints: Use USD for any money values. Keep the explanation simple and short. Avoid advanced macros unless I ask. If my data layout is unclear, ask me one question before writing the formula. Output Quality: The formula must be correct and ready to use with no editing. No placeholder formulas.
2Clean and Fix Messy Finance Data
When you receive a spreadsheet with mixed formats, blank rows, and inconsistent text that needs to be standardized.
Role: You are a finance data specialist who cleans messy spreadsheets so they are ready for reporting. Context: I have a finance spreadsheet from [source, for example bank export, POS system, or manual entry] for [Company Name]. The problems are: [list the problems, for example dates in different formats, amounts mixed with text, duplicate rows, blank cells, customer names spelled differently]. Task: Give me a clear step by step plan to clean this data in [Excel / Google Sheets] so it is consistent and ready for a report. Format: Present as a numbered cleaning checklist. For each step give: the problem, the exact action (formula, Find and Replace, Text to Columns, or filter), and the result I should see. Constraints: All money in USD. Do not delete original data, work on a copy. Keep steps simple enough for a non technical user. Output Quality: A practical checklist I can follow start to finish without help. No vague advice.
3Create a Reusable Monthly Tracker Template
When you want one clean Excel template you can reuse every month for sales, expenses, or collections.
Role: You are a finance template designer who builds clean, reusable Excel templates for small and medium businesses. Context: [Company Name] needs a monthly [sales / expense / collection] tracker. The fields we track are: [list fields, for example date, category, description, amount USD, paid or unpaid]. Around [number] entries per month. Task: Design the full structure of a reusable monthly tracker, including the column layout, any summary section, and the formulas needed for totals and subtotals. Format: Give me: 1. The exact column headers in order. 2. A short note on what goes in each column. 3. The summary table layout (totals by category, monthly total). 4. The formulas for the summary, ready to paste. Constraints: USD only. Keep it simple, one sheet if possible. Design so I can copy the tab each month. Output Quality: A complete template I can rebuild in Excel in 10 minutes. Real formulas, no placeholders.
4Automate a Repeat Finance Task
When you do the same manual spreadsheet task every week or month and want to speed it up.
Role: You are an automation advisor for finance teams who finds faster ways to do repeat spreadsheet work. Context: Every [week / month] I do this task by hand: [describe the task in detail, for example copy bank data, match it to invoices, and mark them paid]. It takes me about [time] each time. I use [Excel / Google Sheets]. Task: Show me how to do this task faster using built in spreadsheet tools (formulas, lookups, filters, pivot tables, or conditional formatting). No coding. Format: Give a before and after comparison, then a step by step setup guide for the faster method, then how I run it each period. Constraints: No macros or scripts unless I ask. USD only. Tools must be standard Excel or Google Sheets features. Output Quality: A method that clearly saves time and that I can set up once and reuse. Practical and tested logic.
5Explain and Audit an Existing Formula
When you inherited a spreadsheet with complex formulas and need to understand or check them.
Role: You are an Excel auditor who reviews formulas for finance teams and explains them clearly. Context: I have this formula in my finance spreadsheet for [Company Name]: [paste the formula]. It is used for [purpose]. My data layout is: [describe]. Task: Explain what this formula does in plain words, check whether it is correct for the purpose, and point out any risk of error. Format: 1. Plain English explanation, step by step. 2. Is it correct: yes or no, with reasons. 3. Any risks (for example wrong range, missing rows, will break if data grows). 4. A safer or simpler version if one exists. Constraints: USD for money. Keep the explanation simple. Do not assume data I did not give you, ask if unclear. Output Quality: A clear audit that tells me whether I can trust this formula. Specific, not generic.
2. Finance Report Writing
Turn raw numbers into clear written finance reports for management, owners, and partners. These prompts help you write the narrative around the numbers so non finance readers understand what is happening.
1Monthly Finance Report Narrative
When you have the monthly numbers and need to write the management report that explains them.
Role: You are a finance manager who writes clear monthly reports for company management in Cambodia. Context: [Company Name], month of [month/year]. Key numbers (USD): Revenue [amount], last month [amount], target [amount]. Total expenses [amount]. Net profit [amount]. Cash balance [amount]. Notable items this month: [list anything important, for example a big client paid late, a new cost, a one time expense]. Task: Write the written narrative for the monthly finance report that explains these numbers to management. Format: Use these sections: 1) One paragraph summary, 2) Revenue review, 3) Expense review, 4) Profit and margin, 5) Cash position, 6) Key issues and recommended actions. Constraints: USD only. Simple, clear business English. No heavy accounting jargon. Honest about both good and bad news. Output Quality: A report management can read in 5 minutes and understand exactly how the month went. Specific to my numbers, no filler.
2Quarterly Report for Owners or Board
When you need a higher level finance report for owners, the board, or partners every quarter.
Role: You are a finance lead preparing a quarterly report for company owners and the board. Context: [Company Name], quarter [Q/year]. Quarter results (USD): Revenue [amount] vs target [amount], net profit [amount], net margin [percent]. Trend over the three months: [describe]. Major events: [list]. Outlook for next quarter: [describe]. Task: Write a quarterly finance report suitable for owners and board members. Format: 1) Executive summary (5 lines), 2) Financial results table, 3) What drove the results, 4) Risks and concerns, 5) Outlook and recommended decisions for the board. Constraints: USD only. Professional but plain language. Be direct about risks. Keep to about [one to two] pages. Output Quality: Board ready. Clear enough that a non finance owner understands the story behind the numbers.
3Explain a Number That Changed Sharply
When one figure moved a lot and management wants a written explanation.
Role: You are a finance analyst who explains changes in the numbers to management. Context: At [Company Name], [name the figure, for example marketing expense / gross margin / cash balance] changed from [amount/percent] to [amount/percent] in [period]. Possible reasons I know of: [list what you know]. Task: Write a short, clear explanation of why this number changed and what it means for the business. Format: 1) What changed (one line with the numbers), 2) Why it changed (main reasons, ranked), 3) Is this good, bad, or neutral, 4) What we should do about it. Constraints: USD only. Do not invent reasons. If you need more data to be sure, say what data and give the most likely explanation clearly marked as likely. Output Quality: An honest, useful explanation, not a guess dressed up as fact.
4Write an Expense Summary Report
When management asks for a clear write up of where the money went.
Role: You are an accountant writing an expense summary for management. Context: [Company Name], period [period]. Total expenses [amount USD]. Breakdown by category (USD): [list categories and amounts, for example salaries, rent, marketing, fuel, utilities, other]. Task: Write an expense summary report that shows where money was spent and flags anything worth attention. Format: 1) Total and one line summary, 2) Expense table by category with percent of total, 3) Top 3 cost categories explained, 4) Any unusual or rising costs, 5) Suggested areas to review. Constraints: USD only. Plain language. Do not recommend cuts without noting the trade off. Output Quality: A clear picture of spending that helps management decide where to look closer. Specific to my categories.
5Turn Notes Into a Polished Finance Report
When you have rough notes or bullet points and need them turned into a proper report.
Role: You are a finance writer who turns rough notes into clean, professional reports. Context: Here are my rough notes for the [period] finance report of [Company Name]: [paste your notes and figures in USD]. Task: Turn these notes into a clear, well organized finance report for management. Format: Organize into logical sections with headings. Keep all my numbers exactly as given. Add a short summary at the top. Constraints: USD only. Do not add numbers I did not provide. Do not change my figures. Keep the language simple and professional. Output Quality: A finished report I can send with light review. Faithful to my notes, just clearer and better structured.
3. Startup Cost Planning and Analysis
Plan and analyze the cost of starting a new business, branch, product, or project. These prompts help estimate one time and ongoing costs, build a startup budget, and check if the plan makes financial sense.
1Full Startup Cost Estimate
When planning a new business or branch and you need a complete list of what it will cost to start.
Role: You are a startup finance advisor who helps new businesses in Cambodia plan their startup costs. Context: I am planning to start [type of business, for example a coffee shop / delivery service / retail shop] in [location]. Size and scale: [describe, for example number of staff, size of space, expected daily customers]. I have [amount USD] available to start. Task: Build a complete startup cost estimate listing every one time cost and the first 3 months of operating costs. Format: Two tables in USD. Table 1: One time startup costs (item, estimated cost, notes). Table 2: Monthly operating costs for first 3 months. Then a total funding needed line and whether my available amount is enough. Constraints: USD only. Use realistic ranges for Cambodia where you can, and clearly mark any number as an estimate I must confirm. Do not present estimates as exact quotes. Output Quality: A realistic, complete cost picture I can use to plan funding. Flag the biggest cost risks.
2Startup Funding Gap Analysis
When you want to know if your available money is enough to start and survive until the business earns enough.
Role: You are a finance advisor who checks whether a startup is funded well enough to survive its early months. Context: [Business / project name]. Available capital: [amount USD]. Estimated startup cost: [amount USD]. Expected monthly operating cost: [amount USD]. Expected monthly revenue ramp: Month 1 [amount], Month 2 [amount], Month 3 [amount], and so on. Task: Work out the funding gap and how many months my money will last before the business breaks even. Format: 1) Capital vs startup cost, 2) Monthly cash burn until break even (table), 3) The month I run out of cash if revenue follows the plan, 4) Funding gap amount, 5) Recommendation. Constraints: USD only. Show the math clearly. State assumptions. Do not assume extra funding I did not mention. Output Quality: A clear answer on whether I have enough money, with the numbers to back it. Honest about risk.
3New Product or Project Cost Analysis
When adding a new product line or project inside an existing business and you need to cost it.
Role: You are a finance analyst who costs new products and projects for existing businesses. Context: [Company Name] wants to launch [new product / project]. What it involves: [describe]. Expected selling price or revenue: [amount USD]. Known costs so far: [list]. Task: Build a cost analysis for this new product or project, including setup costs, unit or running costs, and the margin or return. Format: 1) One time setup costs (USD table), 2) Ongoing or per unit costs (USD), 3) Revenue and margin per unit or per month, 4) Months to recover setup cost, 5) Go or review recommendation. Constraints: USD only. Mark estimates clearly. Do not invent prices, ask if a key number is missing. Output Quality: A clear costing that shows if this product or project is worth doing. Specific numbers, not generic.
4Compare Two Startup Options
When choosing between two ways to start, for example renting vs buying, or small launch vs big launch.
Role: You are a finance advisor who compares startup options to find the better financial choice. Context: I am deciding between two options for [business / project]. Option A: [describe, with costs in USD]. Option B: [describe, with costs in USD]. My priorities are: [for example lowest risk, fastest start, lowest cost]. Task: Compare the two options on cost, risk, and return, and recommend the better one for my priorities. Format: 1) Side by side cost table (USD), 2) Pros and cons of each, 3) Risk comparison, 4) Clear recommendation with the reason. Constraints: USD only. Be decisive but explain the trade off. Do not add hidden costs without flagging them as estimates. Output Quality: A clear recommendation I can act on, backed by the numbers and my stated priorities.
5First Year Startup Budget
When you need a month by month budget for the first year of a new venture.
Role: You are a finance planner who builds first year budgets for new businesses. Context: [Business name], starting [month/year]. Startup cost [amount USD]. Expected monthly revenue plan: [describe the ramp]. Expected monthly costs: [list main cost categories and amounts USD]. Task: Build a month by month budget for the first 12 months showing revenue, costs, profit or loss, and cash position. Format: A 12 month table in USD with rows for revenue, each main cost category, total cost, monthly profit or loss, and running cash balance. Add a short note on the break even month and the lowest cash point. Constraints: USD only. Be realistic about the slow early months. State key assumptions at the top. Output Quality: A usable first year budget that shows when the business turns profitable and when cash is tightest.
4. Daily, Weekly, Monthly, and Annual Management Reports
Build the recurring reports management needs to run the business. These prompts help you design and write daily, weekly, monthly, and annual reports in a consistent, fast, repeatable format.
1Design a Daily Finance Snapshot
When management wants a quick daily view of money in, money out, and cash.
Role: You are a finance manager who designs short daily reports for busy management. Context: [Company Name]. Management wants a daily snapshot they can read in under a minute. Data we have each day: [list, for example sales, cash collected, expenses paid, bank balance]. Task: Design a daily finance snapshot template and show one filled in example. Format: 1) The template layout (what fields, in what order), 2) A filled example in USD with sample numbers, 3) A one line note on where each number comes from. Constraints: USD only. Keep it to one short page or one message. Only the few numbers that matter daily. Output Quality: A snapshot management will actually read every day. Short, clear, repeatable.
2Weekly Performance Report
When you need a consistent weekly report covering sales, costs, collections, and issues.
Role: You are a finance lead who writes weekly performance reports for management. Context: [Company Name], week of [dates]. This week (USD): Sales [amount], target [amount], expenses [amount], cash collected [amount], outstanding receivables [amount]. Issues this week: [list]. Task: Write the weekly performance report. Format: 1) Week summary (3 lines), 2) Key numbers table (this week vs target vs last week), 3) Wins, 4) Concerns, 5) Focus for next week. Constraints: USD only. Plain language. Honest about misses. Output Quality: A weekly report that keeps management informed and points to next actions. Specific to my numbers.
3Monthly Management Report Template
When you want one standard monthly template the team reuses every month.
Role: You are a finance manager who builds standard monthly report templates. Context: [Company Name]. We report monthly to [owners / management]. We track: revenue, expenses by category, profit, margin, cash, receivables, payables, and KPIs [list KPIs]. Task: Design a complete monthly management report template that the team fills in each month. Format: A full template with section headings, the tables needed (in USD), and a short instruction under each section on what to write. Include a one page summary at the top. Constraints: USD only. Make it repeatable, so each month only the numbers and notes change. No follow up review section. Output Quality: A reusable template that creates a consistent report every month with little effort. Clear and complete.
4Annual Finance Report
When the year ends and you need a full year report for owners and planning.
Role: You are a finance lead preparing the annual finance report. Context: [Company Name], year [year]. Full year (USD): Revenue [amount] vs prior year [amount], total expenses [amount], net profit [amount], net margin [percent]. Quarter by quarter trend: [describe]. Big events this year: [list]. Task: Write the annual finance report for owners and for next year planning. Format: 1) Year in review summary, 2) Full year results table with prior year comparison, 3) What drove the results, 4) Strengths and weaknesses revealed by the numbers, 5) Recommendations for next year. Constraints: USD only. Professional, plain language. Be honest about weak areas. Output Quality: A complete year end report that owners understand and that supports next year planning. Specific to my numbers.
5Convert Data Into a Report Fast
When you have a table of numbers and need it turned into a written report quickly.
Role: You are a finance writer who turns raw tables into clear written reports quickly. Context: Here is my data for [period] at [Company Name]: [paste your table of numbers in USD]. Task: Turn this data into a clear written management report with the key points and a short summary. Format: 1) Summary (3 to 4 lines), 2) Key figures highlighted, 3) Notable changes or patterns, 4) One or two recommended actions. Constraints: USD only. Use only the numbers I gave. Do not invent data. Keep it short and useful. Output Quality: A fast, accurate report that matches my data exactly. No added or changed numbers.
5. Budget Planning
Build clear, realistic budgets for the company, a department, or a project. These prompts help you set revenue and cost targets, structure the budget, and prepare it for approval.
1Annual Company Budget
When you need to build the full year budget for the whole business.
Role: You are a finance manager who builds annual budgets for businesses in Cambodia. Context: [Company Name], budget for year [year]. Last year actuals (USD): revenue [amount], total expenses [amount], net profit [amount]. Growth target for next year: [percent or amount]. Known changes coming: [list, for example new hires, rent increase, new product]. Task: Build a full year company budget with monthly figures. Format: A 12 month budget table in USD with revenue, each main cost category, total cost, and monthly net profit. Add a summary row for the full year and a short list of the assumptions used. Constraints: USD only. Base it on last year actuals plus the stated changes. Mark assumptions clearly. Be realistic, do not just apply a flat growth percent without thought. Output Quality: A realistic, approval ready annual budget grounded in last year and the known changes.
2Department Budget
When a department head needs to plan their own yearly or quarterly budget.
Role: You are a finance partner helping a department head plan their budget. Context: The [department name] at [Company Name]. Budget period: [year or quarter]. Last period spend (USD): [amount or breakdown]. Planned activities and goals this period: [list]. Any new costs expected: [list]. Task: Build a budget for this department tied to its activities and goals. Format: A cost table in USD by category, linked to the activity it supports. Include a total, a comparison to last period, and notes on any big changes. Constraints: USD only. Tie costs to real activities. Flag any cost that is rising and why. Output Quality: A department budget the head can defend in a review, with costs linked to clear purposes.
3Project Budget
When you need a budget for a specific project or event with a clear start and end.
Role: You are a finance advisor who builds project budgets. Context: [Project name] at [Company Name], running from [start] to [end]. Goal of the project: [describe]. Known cost items so far: [list with amounts USD]. Expected revenue or benefit if any: [describe]. Task: Build a complete project budget covering all costs from start to finish. Format: A cost table in USD grouped by phase or category, a total project cost, a small contingency line, and if relevant the expected return or benefit. Constraints: USD only. Include a contingency and explain it. Mark estimates clearly. Ask if a major cost is missing. Output Quality: A complete project budget with nothing major missing, ready to submit for approval.
4Build a Budget From Zero (Zero Based)
When you want to justify every cost from scratch instead of copying last year.
Role: You are a finance advisor who builds zero based budgets where every cost must be justified. Context: [Company Name or department], period [period]. Instead of copying last year, I want to justify each cost from zero. Our goals this period: [list]. The activities we must fund: [list]. Task: Build a zero based budget where each cost is tied to a goal or activity and justified. Format: A table in USD with columns: cost item, amount, the goal or activity it supports, and why it is needed. Group into must have, should have, and nice to have. Constraints: USD only. Every line must have a justification. Flag any cost that cannot be justified. Output Quality: A lean, justified budget where management can see exactly why each cost exists.
5Budget Assumptions and Risk Check
When you have a draft budget and want to test the assumptions behind it.
Role: You are a finance reviewer who stress tests budget assumptions before approval. Context: Here is my draft budget and its assumptions for [Company Name], period [period]: [paste budget summary and assumptions in USD, for example revenue growth assumed at X percent, costs assumed flat]. Task: Review the assumptions, point out which are risky or too optimistic, and show how the budget changes if key assumptions are wrong. Format: 1) List of assumptions with a risk rating (low, medium, high), 2) The two or three assumptions that matter most, 3) A simple what if: budget result if those assumptions miss by [percent]. Constraints: USD only. Be honest about optimistic assumptions. Do not change my numbers, test them. Output Quality: A clear view of where the budget is fragile, so I can fix it before it goes for approval.
6. Budget vs Actual Analysis
Compare what you planned to what actually happened, and explain the gaps. These prompts help you build the variance report and turn the differences into clear actions.
1Monthly Budget vs Actual Report
When you need to show how the month compared to budget and explain the differences.
Role: You are a finance analyst who prepares budget vs actual reports for management. Context: [Company Name], month [month]. Budget vs actual (USD): Revenue budget [amount], actual [amount]. Expenses budget [amount], actual [amount], with category detail: [list categories with budget and actual]. Net profit budget [amount], actual [amount]. Task: Build the budget vs actual report and explain the main differences. Format: A variance table in USD with columns: line item, budget, actual, variance amount, variance percent, and whether it is favorable or unfavorable. Then a short explanation of the three biggest variances and what to do about them. Constraints: USD only. Mark each variance clearly as favorable or unfavorable. Do not guess reasons, ask if a variance is unexplained. Output Quality: A clear variance report management can act on, with the big gaps explained and tied to actions.
2Explain a Cost Overrun
When a cost went over budget and you need to explain why and what to do.
Role: You are a finance analyst who investigates cost overruns. Context: At [Company Name], [cost category] was budgeted at [amount USD] but actual was [amount USD], an overrun of [amount / percent]. What I know about the cause: [list]. Task: Explain the overrun, separate the reasons by how much each contributed, and recommend how to control this cost going forward. Format: 1) Size of overrun (USD and percent), 2) Reasons ranked by impact, 3) Is this one time or ongoing, 4) Actions to control it, 5) Whether the budget line needs to be reset. Constraints: USD only. Do not invent causes. If the cause is unclear, say what to check. Output Quality: An honest explanation and a realistic control plan, not blame and not vague advice.
3Revenue Shortfall Analysis
When revenue came in below budget and management wants to understand the gap.
Role: You are a finance analyst who breaks down why revenue missed budget. Context: [Company Name], period [period]. Revenue budget [amount USD], actual [amount USD], shortfall [amount / percent]. Drivers I can see: [for example fewer customers, lower price, lost client, slow season]. Task: Break down the revenue shortfall into its main causes (volume, price, mix, lost clients) and explain each. Format: 1) Total shortfall, 2) Cause breakdown with estimated USD impact of each, 3) Which causes are temporary vs ongoing, 4) Recommended response. Constraints: USD only. Be clear about which figures are estimates. Do not overstate certainty. Output Quality: A clear, honest breakdown that tells management where the revenue gap really came from.
4Quarterly Variance Summary for Management
When you need a higher level variance summary across the quarter, not line by line.
Role: You are a finance lead summarizing budget performance for the quarter. Context: [Company Name], quarter [Q]. Budget vs actual for the quarter (USD): revenue, total cost, net profit, plus the main categories that moved. Detail: [paste key budget vs actual figures]. Task: Write a quarterly variance summary that gives management the big picture, not every line. Format: 1) Overall: are we ahead or behind budget and by how much, 2) The few variances that matter, 3) What they mean for the full year, 4) Recommended adjustments. Constraints: USD only. Focus on what matters, skip tiny variances. Plain language. Output Quality: A focused summary that tells management whether the year is on track and what to change.
5Turn Variances Into an Action Plan
When you have the variance numbers and need to convert them into clear actions and owners.
Role: You are a finance partner who turns variance findings into an action plan. Context: [Company Name], period [period]. Key variances (USD): [list the main favorable and unfavorable variances and any known reasons]. Task: Turn these variances into a clear action plan to fix the unfavorable ones and keep the favorable ones. Format: A table with columns: variance, action, owner, target date, and expected USD impact. Group into this month and this quarter. Constraints: USD only. Actions must be specific and realistic. Do not assign owners I did not mention, use role names if unsure. Output Quality: A practical action plan that connects each variance to a fix. No vague actions.
7. Cash Flow Planning and Control
Plan cash in and cash out, spot shortfalls early, and keep the business able to pay its bills. These prompts help you build cash forecasts and control cash week by week.
113 Week Cash Flow Forecast
When you need a rolling short term cash forecast to make sure you can pay bills and payroll.
Role: You are a cash flow specialist who builds short term forecasts for businesses. Context: [Company Name]. Starting cash balance [amount USD]. Expected cash in by week: [describe, for example customer payments, sales]. Expected cash out by week: [describe, for example payroll, rent, suppliers, loan payments]. Any known big items: [list]. Task: Build a 13 week cash flow forecast showing weekly cash in, cash out, and ending balance. Format: A 13 week table in USD with rows for opening balance, cash in (by source), cash out (by category), net for the week, and closing balance. Highlight any week the balance goes low or negative. Constraints: USD only. Use my figures and timing. Flag the lowest cash point clearly. State assumptions. Output Quality: A forecast that tells me exactly which weeks are tight and whether I can cover payroll and bills.
2Cash Shortfall Early Warning
When you want to know in advance if and when you will run short of cash.
Role: You are a finance advisor who spots cash shortfalls before they happen. Context: [Company Name]. Current cash [amount USD]. Monthly cash in [amount], monthly cash out [amount]. Upcoming large payments: [list with dates and amounts]. Expected large receipts: [list with dates and amounts]. Task: Tell me if and when I will face a cash shortfall, and how big it will be. Format: 1) Month by month cash position (USD), 2) The first month cash goes negative if any, 3) Size of the gap, 4) Options to close the gap (collect faster, delay a payment, arrange financing), ranked. Constraints: USD only. Be direct about the risk. Do not assume new funding unless I mention it. Output Quality: A clear early warning with the timing and size of any shortfall, plus realistic options.
3Improve Cash Position Plan
When cash is tight and you need a plan to free up cash quickly.
Role: You are a finance advisor who helps businesses improve cash quickly without harming operations. Context: [Company Name]. Cash is tight. Current situation (USD): cash [amount], receivables [amount], payables [amount], inventory [amount if relevant]. Constraints: [for example cannot delay payroll, cannot lose key suppliers]. Task: Build a plan to improve cash within [30 / 60 / 90] days. Format: Actions grouped into: collect cash faster, slow cash out safely, reduce tied up cash, and last resort financing. For each action: expected USD impact, how fast, and the risk or trade off. Constraints: USD only. Respect my constraints. Do not suggest anything that damages key relationships without flagging it. Output Quality: A realistic cash improvement plan with the biggest, fastest, safest wins first.
4Cash Flow vs Profit Explanation
When the business shows profit but has no cash, and you need to explain why.
Role: You are a finance educator who explains the difference between profit and cash in simple terms. Context: [Company Name] shows a profit of [amount USD] for [period] but cash is [low / negative / lower than expected]. What I know: [for example big unpaid invoices, inventory bought, loan repaid, owner drawings]. Task: Explain in simple terms why the business is profitable on paper but short on cash, using my situation. Format: 1) Short plain explanation of profit vs cash, 2) The specific reasons in my case with USD amounts, 3) What to do to bring cash in line with profit. Constraints: USD only. Keep it simple enough for a non finance owner. Use my actual reasons, do not generalize. Output Quality: A clear explanation that an owner understands, ending with practical steps.
5Monthly Cash Control Routine
When you want a simple repeatable monthly routine to stay on top of cash.
Role: You are a finance advisor who sets up simple cash control routines for small teams. Context: [Company Name], finance handled by [number] person or team. We want a simple monthly routine to control cash and avoid surprises. Tools we use: [Excel / Google Sheets / accounting software]. Task: Design a simple monthly cash control routine, step by step. Format: A checklist with: what to do at the start of the month, during the month (weekly check), and at month end. Include which numbers to track and a simple cash tracker layout in USD. Constraints: USD only. Keep it light enough for a small team to actually follow. No complex tools. Output Quality: A practical routine the team will keep using, that catches cash problems early.
8. Accounts Receivable and Accounts Payable Monitoring
Track who owes you money and who you owe, and keep both under control. These prompts help you monitor receivables, chase overdue payments, and manage payables without damaging supplier relationships.
1Receivables Aging Analysis
When you need to see which customer payments are overdue and by how long.
Role: You are an accounts receivable analyst. Context: [Company Name]. Here is my list of unpaid customer invoices: [paste list with customer, invoice date, due date, amount USD]. Today is [date]. Task: Build a receivables aging analysis grouping overdue amounts into current, 1 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days. Format: 1) Aging table in USD by bucket with totals, 2) Total receivables and total overdue, 3) The customers with the largest overdue amounts, 4) Which accounts need urgent action. Constraints: USD only. Use my dates and amounts exactly. Do not invent invoices. Output Quality: A clear aging picture that shows exactly where collection effort should go.
2Collection Plan for Overdue Accounts
When you have overdue customers and need a plan to collect without losing them.
Role: You are a credit and collections advisor who recovers overdue payments while keeping customer relationships. Context: [Company Name]. Overdue accounts: [list customers, amounts USD, days overdue, and relationship notes, for example good long term client vs repeat late payer]. Task: Build a collection plan tailored to each account based on how overdue it is and the relationship. Format: A table with: customer, amount, days overdue, recommended action (reminder, call, payment plan, hold service, escalate), tone (gentle vs firm), and timing. Constraints: USD only. Match the firmness to the situation. Do not recommend harsh action on good clients without flagging the risk. Output Quality: A practical, relationship aware collection plan that recovers cash and keeps good customers.
3Payables Schedule and Priority
When cash is limited and you must decide which suppliers to pay first.
Role: You are a finance advisor who schedules supplier payments when cash is limited. Context: [Company Name]. Cash available this period [amount USD]. Bills due: [list suppliers, amounts USD, due dates, and importance, for example critical supplier, can be delayed, charges late fee]. Task: Build a payment schedule that prioritizes which bills to pay now and which can wait, given my available cash. Format: A table with: supplier, amount, due date, priority (pay now, partial, delay), reason, and the running cash balance after each payment. Flag any bill that cannot be paid this period. Constraints: USD only. Protect critical suppliers and avoid late fees where possible. Do not exceed my available cash. Output Quality: A realistic payment plan that uses limited cash wisely and protects key supplier relationships.
4AR and AP Health Check
When you want a quick view of whether your receivables and payables are healthy.
Role: You are a finance analyst who checks the health of receivables and payables. Context: [Company Name], as of [date]. Total receivables [amount USD], of which overdue [amount]. Total payables [amount USD], of which overdue [amount]. Average collection days [number], average payment days [number]. Task: Assess whether my receivables and payables are healthy and where the risk is. Format: 1) Receivables health (are we collecting fast enough), 2) Payables health (are we paying on time, using terms well), 3) The balance between the two and its effect on cash, 4) Top two or three things to fix. Constraints: USD only. Be direct. Compare collection days and payment days and explain what the gap means for cash. Output Quality: A clear health check that tells me if money is stuck and what to fix first.
5Payment Reminder Messages
When you need polite but effective reminder messages for overdue customers.
Role: You are a finance communications writer who drafts payment reminders that get paid without offending customers. Context: [Company Name]. I need reminder messages for overdue customers. Situations: [list, for example 5 days overdue good client, 30 days overdue, 60 plus days overdue repeat late payer]. Channel: [email / Telegram / phone script]. Task: Write reminder messages matched to each situation. Format: For each situation give a ready to send message with the right tone (friendly, firm, final notice). Leave fill in fields for customer name, invoice number, and amount in USD. Constraints: USD only. Professional and respectful even when firm. No threats. Keep messages short. Output Quality: Ready to send reminders that recover payment and protect the relationship. Tone matched to each case.
9. Financial Scenario Analysis: Best Case, Base Case, and Worst Case
Test how the business performs under good, expected, and bad conditions. These prompts help you build three scenarios so decisions are made with eyes open to the range of outcomes.
1Three Scenario Revenue and Profit Model
When you want to see best, base, and worst case results for the year.
Role: You are a finance modeler who builds best, base, and worst case scenarios. Context: [Company Name], period [period]. Base assumptions (USD): revenue [amount], main costs [list], net profit [amount]. The key uncertain factors are: [list, for example sales volume, price, a major client, a key cost]. Task: Build three scenarios (best, base, worst) showing revenue, costs, and profit for each. Format: A side by side table in USD for best, base, worst, with rows for revenue, main cost lines, and net profit. Under the table, list the assumptions changed for best and worst, and the resulting profit range. Constraints: USD only. Keep base case as my realistic plan. Make best and worst realistic, not extreme. State every changed assumption. Output Quality: A clear three scenario model that shows the realistic range of outcomes, with honest assumptions.
2Worst Case Survival Test
When you want to know if the business survives a bad scenario and what to do if it happens.
Role: You are a finance advisor who stress tests businesses against bad scenarios. Context: [Company Name]. Current position (USD): revenue [amount], costs [amount], cash [amount]. Worst case triggers I worry about: [list, for example sales drop 30 percent, lose biggest client, cost spike]. Task: Model the worst case and test whether the business survives, then build a response plan. Format: 1) Worst case numbers (revenue, costs, profit or loss, cash) in USD, 2) Does the business survive and for how long, 3) The point of danger, 4) A response plan to protect cash and survive. Constraints: USD only. Be honest, do not soften the worst case. Show how long cash lasts. Output Quality: A realistic survival test that tells me the true downside risk and a clear plan if it hits.
3Scenario Comparison for a Decision
When a decision could go several ways and you want to model each outcome.
Role: You are a finance advisor who models scenarios to support a specific decision. Context: [Company Name] is deciding whether to [describe decision, for example open a second branch / raise prices / hire more staff]. Base numbers (USD): [provide]. Possible outcomes: best [describe], expected [describe], worst [describe]. Task: Model the financial outcome of this decision under best, base, and worst conditions. Format: A three scenario table in USD showing the financial result of the decision in each case, plus a one line read on each, and a recommendation on whether the decision is worth the risk. Constraints: USD only. Tie scenarios to this specific decision. State assumptions. Give a clear recommendation. Output Quality: A decision focused scenario analysis that shows the upside, the likely case, and the downside clearly.
4Sensitivity Check on Key Drivers
When you want to know which factor has the biggest effect on profit.
Role: You are a finance analyst who runs sensitivity checks to find what matters most. Context: [Company Name], period [period]. Base case (USD): revenue [amount], costs [breakdown], net profit [amount]. Key drivers: [list, for example price, volume, main cost, exchange exposure if any]. Task: Show how profit changes when each key driver moves by [for example plus or minus 10 percent], one at a time, to find which driver matters most. Format: A table in USD: driver, profit if it improves 10 percent, profit if it worsens 10 percent, and the size of the swing. Rank drivers by impact. Constraints: USD only. Change one driver at a time. State the base case clearly. Output Quality: A clear ranking of which factors most affect profit, so I know where to focus attention.
5Scenario Plan With Triggers and Actions
When you want each scenario linked to early warning signs and ready actions.
Role: You are a finance planner who links scenarios to early warning signs and prepared actions. Context: [Company Name]. My best, base, and worst case scenarios (USD): [paste or describe]. I want to know what signs tell me which scenario is happening, and what to do in each. Task: For each scenario, define the early warning signs and the actions to take. Format: A table with: scenario, early warning signs to watch, the action plan if it is happening, and who acts. Include the numbers (USD) that would confirm each scenario. Constraints: USD only. Signs must be specific and measurable. Actions must be realistic. Output Quality: A practical scenario plan that turns into action the moment the signs appear. Not just numbers, but a response system.
10. Financial Statement Preparation Support
Get help preparing the income statement, balance sheet, and cash flow statement. These prompts support preparation and organization of the statements, while final figures stay with your accountant.
1Structure an Income Statement
When you have the totals and need them organized into a proper income statement.
Role: You are an accountant who helps structure income statements clearly. Context: [Company Name], period [period]. My figures (USD): revenue [amount], cost of goods sold or cost of services [amount], operating expenses by type [list], other income or expense [amount], tax if known [amount]. Task: Organize these figures into a properly structured income statement. Format: A standard income statement in USD: Revenue, Cost of Sales, Gross Profit, Operating Expenses (listed), Operating Profit, Other Items, Profit Before Tax, Tax, Net Profit. Show subtotals and the gross and net margins. Constraints: USD only. Use only the figures I provide. Do not invent numbers. If a needed figure is missing, list it as required. Output Quality: A clean, correctly structured income statement using my exact figures. Note that final figures should be confirmed by my accountant.
2Organize a Balance Sheet
When you need your assets, liabilities, and equity arranged into a balance sheet.
Role: You are an accountant who structures balance sheets. Context: [Company Name], as of [date]. My figures (USD): cash [amount], receivables [amount], inventory [amount], equipment [amount], other assets [list], payables [amount], loans [amount], other liabilities [list], owner capital [amount], retained earnings [amount]. Task: Organize these into a properly structured balance sheet. Format: A standard balance sheet in USD with Current Assets, Non Current Assets, Total Assets, Current Liabilities, Non Current Liabilities, Total Liabilities, Equity, and Total Liabilities plus Equity. Check that assets equal liabilities plus equity and flag if they do not. Constraints: USD only. Use only my figures. If the sheet does not balance, tell me the difference, do not force it. Output Quality: A correctly structured balance sheet that flags any imbalance honestly. Final figures to be confirmed by my accountant.
3Build a Cash Flow Statement (Indirect)
When you need a cash flow statement built from net profit and balance sheet changes.
Role: You are an accountant who prepares cash flow statements using the indirect method. Context: [Company Name], period [period]. Net profit [amount USD]. Non cash items: depreciation [amount]. Changes in working capital (USD): receivables changed by [amount], inventory by [amount], payables by [amount]. Investing items: [list]. Financing items: loans or owner movements [list]. Task: Build a cash flow statement using the indirect method. Format: Standard layout in USD: Operating Activities (start from net profit, adjust non cash items and working capital changes), Investing Activities, Financing Activities, Net Change in Cash, and reconcile to opening and closing cash. Constraints: USD only. Use my figures. If a figure is missing to complete it, list what is needed. Output Quality: A correctly built cash flow statement that ties to my cash movement. Final figures to be confirmed by my accountant.
4Prepare Statement Notes and Disclosures
When the statements need short explanatory notes to go with them.
Role: You are an accountant who drafts clear notes to accompany financial statements. Context: [Company Name], period [period]. Items that need a note: [list, for example a large one time expense, a new loan, a change in accounting basis, a big receivable]. Statements attached or described: [describe]. Task: Draft short, clear notes that explain these items to a reader of the statements. Format: Numbered notes, each tied to the line it explains, in plain language with USD amounts. Constraints: USD only. Keep notes factual and simple. Do not invent details, use only what I provide. Output Quality: Clear notes that help a reader understand the statements. Factual and tied to my figures.
5Pre Submission Statement Checklist
When you want to check the statements are complete before sending to your accountant or bank.
Role: You are a finance reviewer who checks financial statements for completeness before they are submitted. Context: [Company Name], period [period]. I am about to submit my [income statement / balance sheet / cash flow] to [accountant / bank / management]. Here is a summary: [paste key figures in USD]. Task: Give me a checklist to confirm the statements are complete and internally consistent before I submit. Format: A checklist covering: do subtotals add up, does the balance sheet balance, does net profit match across statements, are all periods labeled, are large items explained, and common errors to look for. Constraints: USD only. Point out anything in my summary that looks inconsistent. Do not change my figures. Output Quality: A practical pre submission check that catches errors before they reach my accountant or bank.
11. Financial Statement Explanation
Explain what the financial statements actually mean, in plain language. These prompts help you read the numbers, explain them to non finance people, and pull out the real story.
1Explain My Income Statement in Plain Words
When you or your management need to understand what the income statement is really saying.
Role: You are a finance educator who explains financial statements to business people in simple words. Context: [Company Name], period [period]. Here is my income statement: [paste the figures in USD]. Task: Explain what this income statement tells me about the business, in plain language. Format: 1) What the business earned and kept (in simple terms), 2) Where the money went, 3) The margins and what they mean, 4) Is this a healthy result, 5) Two or three things worth attention. Constraints: USD only. Simple language for a non finance reader. Use my actual numbers. No jargon without a short explanation. Output Quality: An explanation an owner with no finance background fully understands, tied to my real numbers.
2Explain My Balance Sheet in Plain Words
When you need to understand what your balance sheet says about the financial health of the business.
Role: You are a finance educator who explains balance sheets simply. Context: [Company Name], as of [date]. Here is my balance sheet: [paste figures in USD]. Task: Explain what this balance sheet says about the financial health of the business. Format: 1) What the business owns and owes (simple terms), 2) Is it able to pay short term bills, 3) How much debt vs owner money, 4) Overall financial health, 5) Any warning signs. Constraints: USD only. Plain language. Use my numbers. Explain any ratio you mention in one line. Output Quality: A clear read of financial health that a non finance owner understands, based on my real figures.
3Key Ratios Explained
When you want the important financial ratios calculated and explained for your business.
Role: You are a finance analyst who calculates and explains key ratios in simple terms. Context: [Company Name], period [period]. From my statements (USD): revenue [amount], gross profit [amount], net profit [amount], current assets [amount], current liabilities [amount], total debt [amount], equity [amount], inventory [amount if relevant], receivables [amount]. Task: Calculate the key financial ratios for my business and explain what each one means. Format: A table: ratio name, my value, what it means in one line, and whether it looks healthy. Cover profitability, liquidity, and debt ratios at minimum. Constraints: USD only. Use my figures. Explain each ratio plainly. Note that healthy ranges vary by industry. Output Quality: A clear ratio summary that turns my statements into simple health signals. Specific to my numbers.
4What Story Do My Statements Tell
When you want the overall story across all three statements, not just one.
Role: You are a senior finance advisor who reads across all the statements to find the real story. Context: [Company Name], period [period]. Summary of my statements (USD): income statement [key figures], balance sheet [key figures], cash flow [key figures]. Task: Tell me the overall story these statements tell about my business: how it is really doing. Format: 1) The headline (one paragraph), 2) Strengths the numbers show, 3) Weaknesses or risks the numbers show, 4) The one thing I should pay most attention to. Constraints: USD only. Connect the three statements, do not read them in isolation. Be honest about weaknesses. Output Quality: An insightful, honest read of the business across all statements, not just a restatement of the numbers.
5Explain Statements to a Non Finance Audience
When you must present the financials to staff, partners, or owners who do not read finance.
Role: You are a finance presenter who makes statements easy for any audience to understand. Context: [Company Name], period [period]. I must present the financial results to [audience, for example non finance partners / staff / family owners]. Key figures (USD): [paste]. Task: Turn my financial results into a simple explanation I can present, with plain words and simple comparisons. Format: 1) A simple opening line on how the business did, 2) Three or four key points in everyday language, 3) Simple comparisons or examples to make numbers relatable, 4) A clear closing message. Constraints: USD only. No jargon. Make it relatable. Use my real numbers. Output Quality: A presentation friendly explanation anyone can follow, true to my numbers.
12. Financial Report Review
Check finance reports for errors, gaps, and clarity before they go to management, owners, or the bank. These prompts act as a second pair of eyes on your work.
1Review a Finance Report for Errors
When you finished a report and want it checked before sending.
Role: You are a finance quality reviewer who checks reports before they go out. Context: [Company Name], [report type], period [period]. Here is my draft report: [paste the report and figures in USD]. Task: Review this report for errors and problems before I send it. Format: 1) Math check (do totals and subtotals add up), 2) Consistency check (do numbers match across sections), 3) Clarity check (anything confusing or missing), 4) A list of specific fixes with where they are. Constraints: USD only. Point to exact items. Do not change my numbers without flagging. If something cannot be checked from what I gave, say so. Output Quality: A precise review that catches real errors, not vague comments. Ready to act on.
2Check Numbers Add Up and Match
When you want a focused check that all the figures are consistent and correct.
Role: You are a finance checker focused on number accuracy. Context: [Company Name], period [period]. Here are the figures from my report (USD): [paste all the key numbers, totals, and subtotals]. Task: Check that all the numbers add up correctly and are consistent with each other. Format: 1) Each total checked against its parts (pass or fail with the math), 2) Any number that appears in more than one place checked for a match, 3) A clear list of any mismatch with the correct figure if it can be worked out. Constraints: USD only. Show the math for any error you find. Do not assume figures I did not give. Output Quality: A reliable math and consistency check that I can trust before sending the report.
3Review Report for a Bank or Investor
When the report is going to a bank or investor and must meet a higher standard.
Role: You are a finance reviewer who prepares reports to the standard banks and investors expect. Context: [Company Name], [report type], going to [bank / investor] for [purpose, for example a loan / investment]. Here is my draft: [paste in USD]. Task: Review the report to the standard a bank or investor expects, and tell me what to strengthen. Format: 1) Is it complete for this audience (what is missing), 2) Does it present the business credibly, 3) Any number or claim that will raise questions, 4) Specific improvements to make it stronger. Constraints: USD only. Think like a cautious lender or investor. Flag anything that would reduce trust. Output Quality: A review that lifts the report to a fundable standard and removes red flags before submission.
4Improve Clarity and Presentation
When the numbers are right but the report is hard to read.
Role: You are a finance editor who makes reports clearer without changing the numbers. Context: [Company Name], [report type]. Here is my report: [paste in USD]. Readers find it [hard to follow / too long / too detailed]. Task: Improve the clarity, structure, and presentation while keeping all numbers exactly the same. Format: 1) A short list of what makes it hard to read, 2) A clearer structure, 3) A rewritten summary section, 4) Suggestions for what to cut or move. Constraints: USD only. Do not change any figure. Keep it professional. Focus only on clarity and structure. Output Quality: A clearer, easier to read report that says the same thing better. Numbers untouched.
5Final Sign Off Checklist
When you want a last checklist before approving and sending any finance report.
Role: You are a finance reviewer who runs the final sign off before reports are released. Context: [Company Name], [report type], period [period]. About to send to [audience]. Task: Give me a final sign off checklist to run before I approve and send this report. Format: A checklist covering: numbers verified, totals balance, figures match across sections, period and dates correct, company name and titles correct, currency shown as USD, big changes explained, no broken or repeated text, and clear summary present. Constraints: USD only. Make the checklist quick to run. Cover the most common mistakes. Output Quality: A practical final check that prevents an error from reaching the reader. Quick and complete.
13. Payroll Management
Manage payroll accurately and on time, with Cambodian rules in mind. These prompts support payroll calculation, payslips, and tracking, while final compliance is confirmed with the proper authority.
1Monthly Payroll Calculation Sheet
When you need to set up a clear monthly payroll calculation for your staff.
Role: You are a payroll specialist familiar with payroll practice for businesses in Cambodia. Context: [Company Name], [number] staff. Pay elements we use (USD): base salary, allowances [list], overtime, deductions [list, for example advances, NSSF employee contribution]. Pay period: monthly. Task: Design a monthly payroll calculation sheet that works out gross pay, deductions, and net pay for each employee. Format: A payroll table layout in USD with columns: employee, base salary, allowances, overtime, gross pay, deductions (each type), net pay. Add total rows. Note where employer costs like NSSF sit separately. Constraints: USD only. Keep employee deductions and employer costs separate and clear. Note that NSSF and tax on salary rules should be confirmed with the relevant Cambodian authority (NSSF, GDT). Do not state exact rates as final, mark them to confirm. Output Quality: A clear, reusable payroll sheet structure. Compliance figures flagged for confirmation with the authority.
2Payroll Cost Summary for Management
When management wants to see the total cost of payroll, not just net pay.
Role: You are a finance analyst who reports the full cost of payroll to management. Context: [Company Name], period [period]. Payroll figures (USD): total gross salaries [amount], allowances [amount], overtime [amount], employer contributions such as NSSF [amount], other staff costs [list]. Task: Build a payroll cost summary that shows management the full cost of employing staff. Format: 1) Total payroll cost in USD (gross plus employer costs), 2) Breakdown by element, 3) Payroll cost as a percent of revenue if I give revenue, 4) Any trend or concern. Constraints: USD only. Separate what staff receive from what the company pays on top. Use my figures only. Output Quality: A clear view of true payroll cost that helps management plan headcount and budget.
3Payslip Template
When you need a clean payslip layout to give each employee.
Role: You are a payroll specialist who designs clear payslips. Context: [Company Name]. We pay staff monthly in USD. Pay elements: [list, for example base, allowances, overtime, deductions, NSSF]. Task: Design a clear payslip template for one employee. Format: A payslip layout showing: company name, employee name and ID, pay period, earnings (each line in USD), deductions (each line), gross pay, total deductions, and net pay. Include space for employer NSSF as information. Constraints: USD only. Keep it simple and clear for staff to read. Mark any statutory figure as to be confirmed with the relevant authority. Output Quality: A clean, professional payslip employees easily understand. Reusable each month.
4Payroll Accuracy Check
When you want to verify payroll before it is paid out.
Role: You are a payroll reviewer who checks payroll before payment. Context: [Company Name], pay period [period]. Here is my payroll summary: [paste totals and a few sample lines in USD]. Task: Check the payroll for errors before I release payment. Format: 1) Do the per employee totals add up (gross minus deductions equals net), 2) Do the column totals match the sum of lines, 3) Any figure that looks unusual (very high or low), 4) A list of items to verify. Constraints: USD only. Show the math for any issue. Flag unusual amounts but do not assume they are wrong. Do not change figures. Output Quality: A reliable pre payment check that catches payroll errors before money goes out.
5Payroll Compliance Awareness Note
When you want a reminder of the main Cambodian payroll obligations to keep in mind.
Role: You are an HR and payroll advisor aware of Cambodian Labor Law and payroll obligations. Context: [Company Name], [number] staff, based in Cambodia. I want a plain language reminder of the main payroll related obligations to keep in mind. Task: List the main payroll related obligations a Cambodian employer should be aware of, in plain language, so I know what to confirm and track. Format: A list covering areas such as: salary payment timing, NSSF registration and contributions, tax on salary handling, overtime, leave, and seniority or severance items. For each, a one line plain explanation and the authority responsible (for example NSSF, GDT, MLVT). Constraints: USD for any money. Plain language. Make clear this is general awareness only and exact rates, thresholds, and rules must be confirmed with the relevant Cambodian authority. Do not state figures as final legal advice. Output Quality: A useful awareness checklist that tells me what to confirm and with whom. Clearly marked as guidance, not legal advice.
14. Financial Risk Management
Find, measure, and reduce the financial risks that could hurt the business. These prompts help you build a risk register, assess the biggest threats, and put controls in place.
1Financial Risk Register
When you want a full list of the financial risks facing the business, rated and ranked.
Role: You are a financial risk advisor who builds risk registers for businesses in Cambodia. Context: [Company Name], [industry], [size]. Known concerns (USD where relevant): [list, for example one big client, tight cash, high fixed costs, customer credit, currency, single supplier]. Task: Build a financial risk register listing the main financial risks, rated and ranked. Format: A table with: risk, description, likelihood (low, medium, high), financial impact in USD if it happens, risk level (combine likelihood and impact), and a first idea for control. Rank from highest to lowest risk. Constraints: USD only. Focus on financial risks. Use my situation, not generic risks only. Estimate impact in ranges and mark as estimates. Output Quality: A practical risk register that shows the real financial threats ranked by seriousness. Specific to my business.
2Assess the Top Financial Risk
When one risk worries you most and you want it fully assessed with a plan.
Role: You are a financial risk analyst who assesses single risks in depth. Context: [Company Name]. The risk I am most worried about is [describe, for example losing the biggest client, which is [percent] of revenue]. Relevant numbers (USD): [provide]. Task: Assess this risk fully and build a plan to reduce it. Format: 1) What exactly is at risk in USD, 2) How likely it is, 3) The full impact if it happens (on revenue, profit, cash), 4) Early warning signs, 5) Actions to reduce the risk now, 6) A plan if it happens anyway. Constraints: USD only. Be honest about the size of the risk. Actions must be realistic for my business. Output Quality: A deep, honest assessment of the risk with a practical reduction plan and a backup plan.
3Customer Credit Risk Policy
When you sell on credit and want to control the risk of not being paid.
Role: You are a credit risk advisor who sets credit policies for businesses that sell on terms. Context: [Company Name]. We sell to customers on credit. Current situation (USD): total receivables [amount], overdue [amount], bad debt last year [amount]. Customer types: [describe]. Task: Design a simple customer credit policy to reduce the risk of unpaid invoices. Format: 1) How to decide credit limits, 2) Payment terms to set, 3) Checks before giving credit, 4) Rules for when to stop supply, 5) How to monitor credit risk monthly. Constraints: USD only. Keep it practical for my size. Balance protecting cash against not losing good customers. Output Quality: A workable credit policy that reduces bad debt without blocking good sales.
4Cash and Liquidity Risk Plan
When you want to protect the business from running out of cash.
Role: You are a finance advisor who manages liquidity risk for businesses. Context: [Company Name]. Cash situation (USD): current cash [amount], monthly cash out [amount], cash buffer I keep [amount]. Things that threaten cash: [list]. Task: Build a plan to manage liquidity risk so the business can always pay its essential bills. Format: 1) Minimum cash buffer I should hold and why, 2) Early warning signs of a cash problem, 3) Sources of backup cash ranked by speed and cost, 4) Rules to follow when cash gets low, 5) How often to review. Constraints: USD only. Realistic for my size. Backup options should suit a Cambodian SME. Output Quality: A clear liquidity plan that keeps the business safe from cash surprises. Practical and specific.
5Risk Monitoring Dashboard Plan
When you want a simple set of indicators to watch financial risk over time.
Role: You are a risk monitoring specialist who designs simple risk dashboards. Context: [Company Name]. Key financial risks I want to watch: [list, for example cash level, overdue receivables, client concentration, margin, debt level]. Task: Design a simple risk monitoring dashboard with a few key indicators and warning levels. Format: A table: indicator, how it is measured (USD or ratio), green level, yellow warning level, red danger level, and how often to check. Keep it to the few indicators that matter most. Constraints: USD only. Keep it simple enough to update monthly. Set realistic warning levels. Output Quality: A simple, usable risk dashboard plan that gives early warning on the risks that matter. Not overloaded.
15. Business Performance Analysis
Measure how the business is really performing and find what to improve. These prompts help you analyze profitability, efficiency, growth, and the drivers behind the numbers.
1Overall Business Performance Review
When you want a full picture of how the business is performing and where to improve.
Role: You are a business performance analyst who reviews companies and finds what to improve. Context: [Company Name], period [period]. Performance figures (USD): revenue [amount] vs prior [amount], gross margin [percent], net profit [amount], net margin [percent]. Other data: [customers, average sale, staff cost, any KPIs]. Task: Review overall business performance and identify the main areas to improve. Format: 1) Performance summary (how the business is doing), 2) Strengths in the numbers, 3) Weak areas, 4) The root drivers behind the results, 5) Top three improvement actions with expected effect. Constraints: USD only. Be honest about weak areas. Tie conclusions to the numbers. No generic advice. Output Quality: An insightful review that explains performance and gives clear, prioritized improvements. Specific to my numbers.
2Profitability Analysis by Product or Service
When you want to know which products or services actually make money.
Role: You are a profitability analyst who finds which products or services earn and which lose. Context: [Company Name]. My products or services with their revenue and direct costs (USD): [list each with revenue and cost, or sales volume and unit margin]. Task: Analyze profitability by product or service and show me where the real profit comes from. Format: A table in USD: product or service, revenue, direct cost, gross profit, margin percent, and share of total profit. Rank by profit. Flag any that lose money or barely break even. Constraints: USD only. Use my figures. Be clear which items to push and which to review or drop. Output Quality: A clear profit ranking that shows where to focus and what is dragging profit down.
3KPI Tracking and Interpretation
When you want to choose the right KPIs and understand what they say.
Role: You are a performance advisor who selects and interprets KPIs for businesses. Context: [Company Name], [industry]. My goals this period: [list]. Data I can track: [list, for example sales, margin, customers, repeat rate, cost ratios]. Task: Recommend the most useful KPIs for my goals, then interpret my current values. Format: 1) A short list of the right KPIs for my goals (why each), 2) A table with KPI, my current value, a sensible target, and what it tells me, 3) Which KPIs need attention now. Constraints: USD where relevant. Keep the KPI list focused, not long. Targets realistic for my situation. Output Quality: A focused KPI set tied to my goals, with a clear read of where I stand. Not a generic list.
4Compare This Period to Last
When you want a clear period over period comparison with the reasons behind the change.
Role: You are a finance analyst who compares performance across periods. Context: [Company Name]. This period vs last period (USD): revenue [now] vs [then], costs [now] vs [then], net profit [now] vs [then], plus [other metrics]. Known changes: [list]. Task: Compare the two periods, show what changed, and explain why. Format: A comparison table in USD with change amount and percent, then an explanation of the main changes and whether the trend is good or bad, ending with what to watch. Constraints: USD only. Use my figures. Do not invent reasons, use my known changes and mark anything uncertain. Output Quality: A clear period comparison that explains the movement, not just lists it. Honest on the trend.
5Find the Hidden Profit Leaks
When profit feels low and you want to find where money is leaking.
Role: You are a finance investigator who finds hidden profit leaks in businesses. Context: [Company Name], period [period]. Revenue [amount USD], net profit [amount USD], margin [percent], which feels [low / lower than it should be]. Cost detail: [paste expense breakdown in USD]. Any areas I suspect: [list]. Task: Investigate where profit may be leaking and rank the likely leaks by size. Format: 1) The likely profit leaks ranked by estimated USD impact, 2) Why each is suspected, 3) What to check to confirm, 4) The fix and expected gain for the top leaks. Constraints: USD only. Base it on my cost data. Mark estimates clearly. Do not blame without evidence. Output Quality: A focused hunt for profit leaks that points me to the biggest, most fixable losses. Specific and evidence based.
16. Financial Dashboard Planning
Plan what a finance dashboard should show and how to lay it out. These prompts help you choose the right metrics, structure the dashboard, and brief whoever builds it.
1Plan a Management Finance Dashboard
When you want to design a finance dashboard for management before building it.
Role: You are a finance dashboard designer who plans clear dashboards for management. Context: [Company Name]. Audience: [for example owner / management team]. They want to see: [describe what matters, for example sales, profit, cash, collections]. Data updated [daily / weekly / monthly]. Built in [Excel / Google Sheets / HTML]. Task: Plan a management finance dashboard: which metrics, which charts, and the layout. Format: 1) The KPIs to show at the top (the few that matter), 2) The charts and what each shows (chart type and data), 3) Any tables, 4) A described layout (what goes top, middle, bottom), 5) Where each number comes from. Constraints: USD only. Keep it focused on decisions, not every number. Match detail to the audience. Output Quality: A clear dashboard plan ready to hand to whoever builds it. Focused on what management needs to decide.
2Choose the Right Finance Metrics
When you are not sure which numbers belong on the dashboard.
Role: You are a finance advisor who picks the right metrics for a dashboard. Context: [Company Name], [industry]. The dashboard is for [audience]. Their main concerns or goals: [list]. Data available: [list]. Task: Recommend the right finance metrics for this dashboard and explain why each earns its place. Format: 1) Top tier metrics (must show, the 4 to 6 that matter most), 2) Second tier (useful supporting metrics), 3) What to leave off and why, 4) For each top metric, what good vs bad looks like. Constraints: USD where relevant. Do not overload the dashboard. Tie metrics to the audience concerns. Output Quality: A focused, justified metric list that keeps the dashboard meaningful, not cluttered.
3Dashboard Layout and Chart Brief
When you know the metrics and need a clear layout and chart brief to build from.
Role: You are a dashboard layout planner who briefs builders clearly. Context: [Company Name]. Metrics to show: [list]. Audience: [audience]. Tool: [Excel / Google Sheets / HTML]. Brand note: clean light background with green and orange. Task: Write a layout and chart brief for building this dashboard. Format: 1) Section by section layout (top KPI strip, then charts, then tables), 2) For each chart: type (bar, line, donut), what data, and why that type, 3) Color and labeling notes, 4) What a builder needs from me to start. Constraints: USD only. Charts must fit the data (do not force a chart type). Keep it clean and readable. Output Quality: A build ready brief that lets someone create the dashboard without guessing. Clear and complete.
4Dashboard for Owners vs for Operations
When different audiences need different dashboards and you want to plan each.
Role: You are a finance advisor who tailors dashboards to different audiences. Context: [Company Name]. I need [two] versions: one for [owners, who care about profit and cash] and one for [operations or department heads, who care about daily drivers]. Data available: [list]. Task: Plan the difference between the two dashboards: what each audience sees and why. Format: A side by side plan: for each audience, the metrics, the level of detail, the update frequency, and what to leave out. Explain the reasoning for the differences. Constraints: USD where relevant. Owners get the big picture, operations get the drivers. Do not just copy one into the other. Output Quality: A clear two audience plan so each group sees what helps them decide, nothing extra.
5Review and Improve an Existing Dashboard
When you have a dashboard already and want it to be clearer and more useful.
Role: You are a dashboard reviewer who improves finance dashboards. Context: [Company Name]. My current finance dashboard shows: [describe the metrics, charts, and layout]. Problems users mention: [list, for example too cluttered, hard to find cash, charts unclear]. Task: Review my current dashboard and recommend improvements. Format: 1) What works, 2) What is cluttered or confusing, 3) Metrics to add or remove, 4) Better chart choices, 5) A cleaner layout suggestion. Constraints: USD where relevant. Keep recommendations practical. Focus on decisions the dashboard should support. Output Quality: A practical improvement plan that makes the dashboard cleaner and more useful. Specific to my setup.
17. Strategic Financial Decision Support
Use financial thinking to support big business decisions: pricing, investment, cost, growth, and funding. These prompts give structured analysis and a clear recommendation, not just numbers.
1Investment Decision Analysis
When deciding whether to invest in equipment, space, technology, or a new line.
Role: You are a finance advisor who analyzes investment decisions for business owners. Context: [Company Name] is considering investing in [describe, for example equipment / a branch / technology]. Cost [amount USD]. Expected benefit: [describe, for example extra revenue / cost saving per month in USD]. Funding source: [describe]. Task: Analyze whether this investment is worth making. Format: 1) Total cost and how it is funded (USD), 2) Expected return (extra profit or saving per period), 3) Payback period (months to recover the cost), 4) Risks, 5) Clear recommendation: invest, wait, or do not invest, with the reason. Constraints: USD only. Show the payback math. Be honest about risk. Do not assume benefits I did not state. Output Quality: A clear invest or not decision backed by the payback math and an honest risk view.
2Pricing Decision Support
When deciding whether and how much to change your prices.
Role: You are a pricing advisor who supports pricing decisions with financial analysis. Context: [Company Name]. Product or service [name]. Current price [amount USD], current cost [amount USD], current volume [number]. Competitor prices: [list]. I am thinking of [raising / lowering] the price to [amount]. Task: Analyze the financial effect of this price change and advise. Format: 1) Current margin and total profit, 2) New margin and profit at the new price, assuming volume holds, 3) How much volume could drop before the change stops being worth it (break even on volume), 4) Competitive read, 5) Recommendation. Constraints: USD only. Show the math. Be clear about the volume risk of a price rise. Use my figures. Output Quality: A clear pricing recommendation backed by margin and break even math, with the volume risk spelled out.
3Cost Reduction Decision
When you need to cut costs and want to decide where, without harming the business.
Role: You are a finance advisor who helps cut costs without damaging the business. Context: [Company Name], period [period]. Total cost [amount USD]. Cost breakdown by category (USD): [list]. Target: reduce cost by [amount or percent]. Things I must protect: [list]. Task: Recommend where to cut to hit the target with the least harm. Format: A table: cost category, current amount, possible cut (USD), ease, and the risk or trade off. Rank cuts from safest to riskiest. Show whether the safe cuts reach the target. Constraints: USD only. Protect what I listed. Be honest where a cut will hurt quality or growth. Output Quality: A clear cost cut plan that hits the target with the least damage, with trade offs named.
4Growth and Expansion Financial Case
When deciding whether the business can afford to grow or expand.
Role: You are a finance advisor who builds the financial case for growth decisions. Context: [Company Name] wants to [describe growth, for example open a new branch / add staff / expand a service]. Estimated cost [amount USD]. Expected extra revenue [amount USD] and timing. Current financial position (USD): revenue, profit, cash [provide]. Task: Build the financial case and advise whether the business can afford this growth now. Format: 1) Cost of the growth and how to fund it, 2) Expected extra profit and when it arrives, 3) Effect on cash during the ramp up, 4) Can the current business support it, 5) Recommendation: go now, go later, or do not go, with conditions. Constraints: USD only. Be honest about the cash strain of growing. Do not assume funding I did not mention. Output Quality: An honest financial case that tells me if I can afford to grow now, and under what conditions.
5Compare Options and Recommend the Best
When you face several financial choices and want a clear best option, not just a list.
Role: You are a senior finance advisor who compares options and recommends the best one, not just lists them. Context: [Company Name] must choose between these options: [list each option with its costs, benefits, and risks in USD]. My priorities: [list, for example protect cash, grow fastest, lowest risk]. Task: Compare the options on the numbers and my priorities, then recommend the single best option. Format: 1) Comparison table (USD): option, cost, expected return, payback, risk, 2) How each fits my priorities, 3) A clear recommendation with the reason, 4) What would change the recommendation. Constraints: USD only. Be decisive, give one recommendation. Explain the trade off you are accepting. Use my figures. Output Quality: A clear best option recommendation backed by the numbers and my priorities. Decisive, not a shrug of choices.