Prompt Kit

You are my finance copilot. I am a finance student/fresher in India.
- Use Indian context (Ind AS, GST, Companies Act) unless I say otherwise.
- Show amounts in ₹ lakh / crore.
- For any calculation, show step-by-step workings in a table.
- Separate facts from assumptions. Label assumptions clearly.
- If you are unsure or data is missing, say so — never invent numbers.
- End every answer with: "What to verify:" (2–3 checks).

Explain the difference between accrual and cash accounting
using a D2C skincare brand that sells ₹12 lakh of products in March,
collects ₹8 lakh in March and ₹4 lakh in April, and pays ₹3 lakh
of March marketing in April.
1) Show the March and April P&L under both methods in a table.
2) Show the cash position each month.
3) Then quiz me with 3 questions, one at a time, and grade my answers.

Explain [concept, e.g. deferred tax] to me as a finance fresher in India.
1) One-line definition
2) A ₹ example with a small table
3) Where I'll see it in a real annual report
4) One common interview question on it, with a model answer

Review your previous answer as a senior auditor.
List any errors, weak assumptions or missing caveats, then give a corrected version.

Here is an expense ledger pasted from our system (below).
Clean it into a table with columns: Date (DD-MM-YYYY), Vendor
(standardised name), Category, Amount (number, ₹).
Rules:
- Standardise vendor names (e.g., "AMAZON IN", "Amazon.in" -> "Amazon").
- Convert text amounts like "₹1,20,000" to 120000.
- Flag duplicates and rows with missing category — don't delete them.
Then list every change you made in a second table.

[paste ledger here]

Sheet "Ledger": A=Date, B=Vendor, C=Category, D=Amount,
headers in row 1, data from row 2 to 2000.
Sheet "Budget": A=Category (A2:A7), B=March Budget.
In Budget!C2, write a formula for total March 2026 actual spend
for the category in A2, that I can drag down.
Handle: blank rows, and dates outside March.
Give: the formula, a one-line explanation, and one test I can do
by hand to confirm it works. I use Excel 365.

Using the Budget vs Actual table below (₹ lakh, March):
1) Recalculate variance and Var % to confirm my numbers.
2) Rank the top 3 drivers of the EBITDA miss.
3) Write a 120-word commentary for the CFO:
   What happened -> Why (hypotheses, labelled) -> What we do next.
4) List 3 questions I should ask the marketing team.

[paste table here]

Explain this Excel formula to me step by step, as if I inherited the model today.
Then tell me one way it could break and a more robust alternative.
Formula: [paste formula]

I've uploaded [Company]'s FY[year] annual report.
Give me a 1-page overview:
1) What the company does and its main segments (with revenue share)
2) 5 key numbers: revenue, EBITDA, PAT, CFO, net debt — this year
   and last year, in ₹ crore
3) What management says drove performance (3 bullets)
4) Auditor's opinion — any qualification, emphasis of matter or
   key audit matters?
Cite the page number for every number and claim.
If something isn't in the document, say "not found".

From the annual report (use consolidated figures), build a
table for the last 3 years:
Revenue growth %, EBITDA margin %, PAT margin %, ROE %, ROCE %,
Debtor days, Inventory days, Net debt / EBITDA, CFO / PAT.
Show the formula and the inputs (with page numbers) for each ratio.
Then write 3 observations a credit analyst would make.

Scan the annual report for these red flags and give a table
with columns: Flag | What the report shows (with page) |
Severity (Low/Med/High) | Question I should ask management.
1) CFO persistently below PAT
2) Receivables growing faster than revenue
3) Auditor qualification / emphasis of matter / auditor change
4) Related-party transactions (size and trend)
5) Promoter shares pledged
6) Contingent liabilities vs net worth
Do not conclude fraud or wrongdoing. Treat each as a question.

Based on my analysis of [Company], write a 60-second verbal pitch I can give
in an interview: business in one line, 2 strengths, 1 risk, and what I'd watch
next quarter. Use only numbers from the report, with page references.

Here are 6 months of actuals for a D2C brand (table below).
1) Analyse each driver (sessions, conversion %, AOV): trend,
   average, and month-on-month change. What moved revenue most?
2) Build a 6-month forecast (Oct–Mar) with 3 scenarios:
   Base, Bull, Bear. Oct–Nov are festive months in India.
   For each scenario, state driver assumptions per month in a table,
   then compute orders and revenue (₹ lakh). Show formulas.
3) List every assumption in plain English so I can challenge it.

[paste data here]

Using the actuals and the Base scenario, write a CFO note
(max 150 words) in 4 parts:
What happened -> Why -> So what -> Now what.
Rules: every claim has a number; label hypotheses as
"hypothesis"; end with one decision the CFO needs to take
(with a proposed owner).
Then give me a 3-line version for WhatsApp.

Act as a sceptical CFO reviewing my Base forecast.
1) Which 3 assumptions are most likely to be wrong, and why?
2) If conversion stays at the 6-month average and festive
   traffic uplift is half of what we assumed, what is revenue?
3) What is the single metric I should track weekly to know
   early if we are off-plan?

Turn the Base forecast and CFO note into a 5-slide board summary outline:
slide title, 3 bullets, and the one chart each slide should show.

Reconcile the bank statement with our cash-book ledger (below).
Matching rules, in order:
1) Exact: same amount and same reference/cheque no.
2) Near: same amount, dates within ±3 days.
3) Many-to-one: combinations of ledger entries = one bank entry.
Output:
A) Matched table (bank row ↔ ledger row, rule used)
B) Unmatched table, bucketed: Timing / Bank charges & interest /
   Investigate
C) Reconciliation statement: ledger balance -> adjustments ->
   bank balance. Show that it ties. If it doesn't, say so.

[paste bank statement]
[paste ledger]

Extract these fields from the invoice text below into a table:
Vendor name, Vendor GSTIN, Invoice no., Invoice date, Place of supply,
Taxable value, CGST, SGST, IGST, Total, Due date.
Checks:
- GSTIN has 15 characters and its first 2 digits match the state.
- Taxable value + taxes = Total (show the sum).
- Intra-state -> CGST+SGST; inter-state -> IGST. Flag mismatches.
If a field is missing, write "MISSING" — never guess.

[paste invoice text]

Turn the reconciliation and invoice-extraction steps we just did
into Project instructions I can reuse every month.
Include: the matching rules, the output tables, the GST checks,
the "MISSING / say if it doesn't tie" rules, and a final
"Controls checklist" the output must always end with.
Keep it under 250 words.

Before analysing, replace every personal or confidential identifier in the data below
(names, PAN, account numbers, phone, email, GSTIN) with consistent dummy IDs
(e.g. VENDOR_01). Give me the masked data and a separate key table I keep offline.