Financial Professionals
Close faster, report clearer, and run treasury like a pro.
Month-End Close
Bank Reconciliation Narrator
Act as a senior accountant reviewing a bank reconciliation. The book balance is $[BOOK], the bank balance is $[BANK]. Outstanding items: [LIST EACH WITH AMOUNT AND DATE]. Write a clear reconciliation narrative for the reviewer file: 1) the math tying book to bank, 2) a one-line explanation of each outstanding item and why it is legitimate, 3) any item older than 30 days flagged for follow-up with a suggested action, 4) your conclusion on whether the account reconciles cleanly. Professional tone, suitable for an audit workpaper.
Recurring Journal Entry Drafter
Act as a staff accountant preparing month-end entries. I need to record: [DESCRIBE THE ACCRUAL OR DEFERRAL, e.g. $12,000 annual insurance paid Jan 1]. Draft the journal entry in proper format (date, accounts, debit, credit, amounts), then explain the logic in two sentences so a reviewer can follow it. Also give me the reversing entry if one is needed next month, and tell me exactly which supporting document to attach. If my description is missing anything needed for a correct entry, ask for it instead of guessing.
Variance Analysis Narrator
Act as a financial analyst explaining budget variances. Account: [ACCOUNT NAME]. Budget: $[BUDGET], Actual: $[ACTUAL], Variance: $[VARIANCE] ([FAVORABLE/UNFAVORABLE]). Known context: [WHAT HAPPENED THIS MONTH]. Write a 4-sentence variance commentary for the management report: sentence 1 states the variance in dollars and percent, sentence 2 gives the primary driver, sentence 3 adds the secondary driver or offset, sentence 4 states the outlook or action. No jargon, no hedging – write it the way a CFO would say it aloud.
Intercompany Reconciliation Memo
Act as a consolidation accountant. Entity A shows a receivable from Entity B of $[AMOUNT]; Entity B shows a payable to Entity A of $[AMOUNT]. The difference is $[DIFFERENCE]. Known transactions in transit: [LIST]. Prepare a reconciliation memo: 1) a table of each side’s balance, 2) the reconciling items with explanations, 3) the proposed eliminating entry, 4) a statement of whether the difference is timing or a real error, and 5) who needs to book what before close. Clear enough for both entity controllers to act on.
Prepaid Amortization Scheduler
Act as an accountant building an amortization schedule. Prepaid item: [DESCRIPTION], total amount $[AMOUNT], service period [START] to [END]. Build me a month-by-month schedule table (Month, Beginning Balance, Monthly Amortization, Ending Balance) and give me the standard monthly journal entry. Then tell me: 1) the exact entry for a stub first or last month if the period does not align to month-ends, 2) what to do if the contract renews mid-schedule, 3) the balance-sheet account and expense account to use. Show all math.
Flux Analysis for Auditors
Act as an audit-ready accountant documenting fluctuations. Account: [ACCOUNT], prior period $[PRIOR], current period $[CURRENT], change [X]% ($[AMOUNT]). My explanation of the change: [EXPLAIN]. Turn this into a workpaper-quality flux memo: expectation vs actual, the quantified drivers of the change (each driver with its dollar impact, summing to the total), corroborating evidence I should attach, and a conclusion on whether the fluctuation is reasonable. Write it so an external auditor can rely on it without follow-up questions.
Close Checklist Builder
Act as an accounting manager designing a month-end close checklist. Company profile: [ENTITY TYPE, e.g. SaaS startup, 40 employees, QuickBooks, one entity]. Build a close checklist organized by workstream (revenue, expenses/payroll, balance sheet, reporting), with each task assigned to a role (staff, manager, controller), a target day (Day 1-5), and the deliverable that proves it is done. Include the 3 tasks most commonly forgotten at companies this size. Format as a checklist I can paste into a tracker.
Open Items Chase Email
Act as a controller nudging a busy department head. I am waiting on [WHAT YOU NEED, e.g. the March Amex receipts] from [NAME, TITLE] to close the books, originally due [DATE]. Draft a short, firm-but-friendly chase email: subject line, one sentence of context, exactly what I need and in what format, the deadline and why it matters (close calendar impact), and an offer to help if something is blocking them. Under 120 words – this person gets 200 emails a day.
Accrual Reversal Reviewer
Act as an accounting manager reviewing month-end accruals for reversal risk. Accruals booked this month: [LIST EACH WITH ACCOUNT, AMOUNT, AND SUPPORT]. For each accrual: 1) state whether it should reverse next month or stand, with the rule you applied, 2) give the exact reversing entry if one is needed, 3) name the support document the preparer must attach, 4) pose the one question a skeptical reviewer would ask. End with a summary table (accrual | reverse Y/N | risk level) and flag the single accrual most likely to be wrong. Tone: reviewer, not preparer – challenge the entries, do not rubber-stamp them.
Fixed Asset Rollforward Builder
Act as a fixed asset accountant. This period: additions [LIST WITH COST AND PLACED-IN-SERVICE DATE], disposals [LIST WITH NET BOOK VALUE], depreciation expense $[X]. Build the rollforward table (Beginning NBV | Additions | Disposals | Depreciation | Ending NBV) and tie it to the GL balance. Then: 1) the journal entries for one disposal (remove cost and accumulated depreciation, book the gain or loss), 2) how to handle an asset retired but not yet disposed, 3) the CIP-to-asset transfer check. Show all math and flag anything that would not tie to the subledger.
Corporate Card Reconciliation Pack
Act as a staff accountant reconciling the corporate card program. Statement total $[X] for [PERIOD]; GL balance $[X]; [N] cardholders. Lay out the reconciliation method: 1) how to match transactions to expense reports (by cardholder, then by date), 2) the three most common breaks (personal charges, missing receipts, timing) with the correcting entry for each, 3) the aging rule for unsubmitted reports and the escalation email to send. Finish with the controller summary memo format: reconciled total, open items, and the owner of each.
Payroll Accrual Calculator
Act as a payroll accountant. Pay period [START] to [END]; month-end falls on [DATE]; gross payroll per period $[X]; employer tax and benefits load [X]%. Compute the month-end payroll accrual: days accrued versus days paid, the gross wages portion, the employer burden portion (show the load math), and the exact journal entry. Then: 1) how to true it up when the actual payroll posts, 2) what changes if a bonus or commission accrual sits on top, 3) the support to attach. Use my inputs for rates – do not guess tax rates.
Revenue Cut-Off Tester
Act as an auditor testing revenue cut-off at [PERIOD END]. Shipments and invoices for the last 5 days of the period and first 5 days after: [LIST WITH DATES AND AMOUNTS]. Shipping terms: [FOB SHIPPING POINT / DESTINATION]. For each item determine the correct period: 1) a table (item | recorded period | correct period | adjustment), 2) the correcting entries for misstatements, 3) whether the net error is material against $[MATERIALITY]. Then name the two shipping documents that best evidence each side of cut-off. Workpaper-ready format.
Warranty Reserve Memo
Act as a controller documenting a warranty reserve. Product: [DESCRIPTION]; sales this period $[X]; historical claim rate [X]%; current reserve $[X]; known quality issue: [DESCRIBE OR NONE]. Compute the required reserve: expected claims on current-period sales plus any specific reserve for the known issue, compare to the existing balance, and give the true-up entry. Write the memo: methodology, inputs with sources, the math, sensitivity (what a 1-point rate change does to the reserve), and why the result is reasonable. Audit-ready tone.
Close Status Update Email
Act as a controller updating the CFO on close progress. Today is Day [X] of a [N]-day close. Done: [COMPLETED ITEMS]. In progress: [ITEMS]. Blocked: [ITEMS WITH OWNERS]. Draft the update email: subject line, a two-line overall status (on track, at risk, or delayed), the blocked items with exactly what I need from whom, and the revised ETA for the reporting pack. Under 150 words. No excuses, no jargon – facts and asks only. Include one line on what I am doing about the biggest blocker.
Suspense Account Sweeper
Act as a senior accountant clearing suspense. Balance $[X]; items: [LIST EACH WITH AMOUNT, DATE, DESCRIPTION]. For each item: 1) the most likely correct account with your reasoning, 2) the reclass entry, 3) the one question to ask the originator if it is unclear. Then the control section: who may post to suspense, the maximum item age rule, and the monthly owner attestation format. End with the three items you would escalate to the controller immediately and why. Practical – this account should be near zero every month.
Subsidiary Close Coordinator
Act as a group controller coordinating close across [N] subsidiaries in [TIME ZONES]. Parent close is Day [X]; intercompany must balance by Day [Y]; each sub has [STAFFING]. Design the close calendar: day-by-day milestones, the intercompany confirmation process (who confirms what, by when, in what format), the escalation path when a sub runs late, and the two standing meetings that keep it on track. Include the sub-package template each entity submits (trial balance, flux, open items). Practical – this must survive real people and real delays.
Financial Reporting
MD&A Drafting Assistant
Act as a financial reporting specialist drafting MD&A. Company: [NAME], period: [Q1 2026 vs Q1 2025]. Key figures: revenue $[X] vs $[Y], gross margin [X]% vs [Y]%, operating expenses $[X] vs $[Y], net income $[X] vs $[Y]. Known drivers: [LIST]. Draft the Results of Operations section: one paragraph per line item (revenue, cost of sales, opex, other), each quantifying the change and attributing it to drivers. Plain, factual tone – no marketing language, no forward-looking promises. Flag anywhere I am missing a required disclosure.
Footnote Disclosure Writer
Act as a technical accountant writing footnotes. Topic: [e.g. revenue recognition, leases, debt]. Facts: [KEY FACTS – policy, amounts, terms]. Draft a GAAP-style footnote disclosure: the accounting policy paragraph, the quantitative table or amounts for the period, and any required qualitative discussion (judgments, estimates, risks). Then list 2-3 things auditors typically ask to add to this specific disclosure so I can get ahead of comments. Formal disclosure tone.
Board Summary Translator
Act as a CFO translating financials for non-accountants. This period: revenue $[X] ([+/-X]% vs plan), gross margin [X]%, EBITDA $[X], cash $[X], runway [X] months. The story behind the numbers: [2-3 SENTENCES]. Write a one-page board summary: headline (the single most important takeaway), what went well (3 bullets with numbers), what needs attention (3 bullets with numbers and the action for each), and the cash outlook. No accounting jargon – a smart non-finance director should understand every word.
KPI Commentary Writer
Act as a finance business partner writing dashboard commentary. KPI: [NAME, e.g. CAC payback]. This month: [VALUE], last month: [VALUE], target: [VALUE]. Context: [WHAT DROVE IT]. Write 3 sentences for the dashboard: what the number is and how it moved, why it moved (the driver, quantified if possible), and what we are doing about it. Then give me a red/yellow/green status with a one-line justification. Crisp, no filler.
Ratio Analysis Interpreter
Act as a credit analyst. Company financials (in $000s): current assets [X], current liabilities [X], total debt [X], equity [X], revenue [X], net income [X], operating cash flow [X]. Calculate: current ratio, quick ratio, debt-to-equity, interest coverage (assume interest $[X]), gross margin, net margin, and operating cash flow to net income. Present as a table with the ratio, the value, and a one-line read (healthy, watch, concern) with the benchmark you are comparing against. End with the 2 ratios you would investigate first and why.
Segment Performance Narrator
Act as a divisional controller. Segments: [LIST EACH WITH REVENUE, MARGIN, GROWTH, e.g. Product A: $2.1M, 68% margin, +12%]. Write a segment performance narrative for the reporting pack: rank the segments by contribution, call out the strongest and weakest with quantified drivers, note any segment below its hurdle rate and what management’s response is, and flag inter-segment items a reader might misread. Structured with a short intro, one paragraph per segment, and a closing takeaway.
Audit Committee Brief
Act as a controller briefing the audit committee. Topics this quarter: [LIST, e.g. new revenue system, control deficiency in AP, pending litigation]. Draft a one-page brief: for each topic, a 3-sentence status (what it is, where it stands, what remains), color-coded risk, and the specific decision or acknowledgment needed from the committee. Close with the overall control environment assessment in one sentence. Formal, precise, no surprises buried.
Management Letter Response Drafter
Act as a controller responding to the auditor’s management letter. Finding: [DESCRIBE THE FINDING, e.g. lack of segregation in wire approvals]. Draft the formal response: acknowledge the finding without admitting fault beyond the facts, describe the corrective action (what, who owns it, deadline), and state how we will evidence it next year. Tone: cooperative and professional, suitable for inclusion in the audit file.
Cash Flow Statement Builder
Act as a financial reporting specialist building the indirect-method cash flow statement. Inputs: net income $[X], depreciation $[X], changes in AR/AP/inventory/other [LIST], capex $[X], debt activity $[X], dividends $[X]. Build the statement (operating, investing, financing) and prove the tie-out: beginning cash plus net change equals ending cash. Then: 1) the two adjustments people most often misclassify, 2) how to present a non-cash item like a new lease, 3) the supplemental cash flow disclosure. Show every line’s math.
Non-GAAP Reconciliation Writer
Act as a reporting specialist preparing a non-GAAP reconciliation. GAAP net income $[X]; adjustments: [LIST EACH WITH AMOUNT AND DESCRIPTION, e.g. stock comp $200k]. Build the reconciliation table (GAAP measure | adjustments | non-GAAP measure), draft the two-sentence explanation of why management uses the non-GAAP measure, and write the cautionary language about its limitations. Then flag which of my adjustments would draw SEC scrutiny and why, and what to rename or remove. Precise, compliance-aware tone.
Earnings Call Talking Points
Act as a CFO preparing for the earnings call. Results: revenue $[X] ([+/-X]% YoY), EPS $[X] versus $[Y] expected, guidance [RAISED/MAINTAINED/LOWERED] to $[X]. Known investor concerns: [LIST]. Draft: 1) the three opening talking points, each with its number, 2) prepared answers for the three toughest likely questions (the concern, then the factual rebuttal with data), 3) the one topic to deflect and the bridge phrase to use. Confident and factual – no spin, because analysts punish spin.
Investor Update One-Pager
Act as a CFO writing the monthly investor update. Metrics: MRR/ARR $[X] ([+/-X]%), burn $[X]/mo, runway [X] months, headcount [X], plus [2-3 KPIs]. Wins: [LIST]. Challenges: [LIST]. Draft a one-page update: the headline number, three wins with metrics, two challenges with the plan for each, the ask (hiring, intros, advice – be specific), and cash/runway status. Honest and concise – investors fund founders who tell the truth early.
Quarter Executive Summary
Act as an FP&A lead summarizing the quarter. Revenue $[X] vs budget $[Y] ([X]%); opex $[X] vs $[Y]; EBITDA $[X] vs $[Y]; cash $[X]. Draft the executive summary: a one-paragraph story of the quarter (what happened and why), the three largest variances with quantified drivers, the full-year forecast impact (raising, holding, or cutting guidance), and the two decisions leadership must make this month. One page, numbers in every paragraph, no filler.
Subsequent Events Memo
Act as a technical accountant. Period end: [DATE]; expected report issuance: [DATE]. Events since period end: [LIST EACH WITH DATE AND DESCRIPTION]. For each: 1) Type I (recognized) or Type II (disclosed), with reasoning, 2) the exact accounting or disclosure treatment, 3) the footnote language if disclosure is needed. Then the completeness checklist: what to ask, whom to ask, and what to document to prove the subsequent-events review was thorough. Audit-file quality.
Going Concern Assessment
Act as a controller performing the going concern assessment. Facts: cash $[X], burn $[X]/mo, debt maturities [LIST], [ANY COVENANT OR FUNDING RISK]. Evaluate: 1) the runway math over the assessment period (one year from report issuance), 2) conditions raising substantial doubt, if any – be direct, 3) management’s mitigation plans, with evidence each plan is probable, 4) the resulting conclusion and disclosure (none, emphasis of matter, or going-concern paragraph). Write the memo section an auditor expects, with the conclusion stated plainly.
Impairment Indicator Memo
Act as a technical accountant assessing impairment indicators for [ASSET OR CASH-GENERATING UNIT]. Carrying value $[X]; recent performance [DESCRIBE]; market changes [DESCRIBE]; framework [GAAP/IFRS]. List the impairment indicators present, assess each against the facts, and conclude whether a full impairment test is triggered. If triggered, outline the test steps (recoverable amount approach, key assumptions to document, sensitivity analysis). If not, write the documentation paragraph proving we considered it. Follow the indicators – no conclusion-shopping.
Related Party Disclosure Drafter
Act as a reporting specialist. Related party transactions this period: [LIST EACH WITH PARTY, RELATIONSHIP, AMOUNT, TERMS]. Draft the disclosure: the nature of each relationship, transaction amounts, outstanding balances and terms, and whether terms are at arm’s length. Then the auditor’s lens: the three questions they will ask about these transactions and the evidence I should have ready. Formal disclosure tone.
Pivot Tables & Data Analysis
Pivot Table Blueprint
Act as a data analyst designing a pivot table. My question: [THE BUSINESS QUESTION, e.g. which customers drove the revenue miss?]. My data: [DESCRIBE COLUMNS, e.g. a sales export with Date, Customer, Product, Rep, Amount]. Tell me exactly how to build the pivot: which field goes to Rows, Columns, Values (and which aggregation – sum, count, average), and which Filters to apply. Then tell me the 2 follow-up pivots that would deepen the answer, and the 1 common mistake people make with this specific analysis. Tool-agnostic – works in Excel or Google Sheets.
GL Anomaly Hunter
Act as a forensic accountant with a general ledger export. Columns: [Date, Account, Description, Debit, Credit, JE#]. I want to find: round-dollar entries, weekend postings, entries just under approval thresholds ($[THRESHOLD]), and accounts with unusual spikes. Give me a step-by-step pivot-and-filter plan: which pivots to build (rows/values/filters for each), what sorting and conditional checks to apply, and what each finding might indicate. Prioritize the checks by fraud risk, highest first.
Revenue Pivot Plan
Act as a revenue analyst. I have 12 months of invoice data: [COLUMNS, e.g. Invoice Date, Customer, Product Line, Region, Amount]. I need to answer: where did growth come from and where did we lose ground? Give me a 3-pivot sequence: pivot 1 (revenue by product line by quarter – find the mix shift), pivot 2 (top 10 customers, this year vs last – find concentration and churn), pivot 3 (new vs lost vs retained revenue waterfall logic). For each: exact rows/columns/values setup and what the resulting pattern tells me.
Expense Creep Finder
Act as a cost analyst. I have 12 months of expense transactions: [COLUMNS, e.g. Date, Vendor, GL Account, Department, Amount]. Something is creeping upward but the totals look fine. Give me a pivot plan to find it: which cuts to run (by vendor, by account, by department – month over month), how to compute the run-rate change per cut, and how to distinguish real creep (price/volume growth) from noise (timing, one-offs). End with how to present the top 3 findings to the department heads who own them.
AR Aging Action Plan
Act as a credit manager with an AR aging export: [COLUMNS, e.g. Customer, Invoice, Due Date, Amount, Days Outstanding]. Build me a collections action plan from pivots: 1) pivot by aging bucket to size the problem, 2) pivot by customer to find the 5 accounts worth 80% of the overdue balance, 3) the exact filter that isolates invoices 1-15 days overdue (the highest-recovery window). Then draft the 3-tier outreach sequence (email, call, escalation) with timing. Cash-focused and practical.
Vendor Spend Concentration
Act as a procurement analyst. I have 12 months of AP data: [COLUMNS, e.g. Vendor, Category, Date, Amount]. I want leverage for renegotiation. Give me the pivot sequence: 1) spend by vendor ranked (find the top 10 and their share of total), 2) spend by category with vendor count (find fragmented categories to consolidate), 3) year-over-year by top vendors (find price increases to challenge). Then tell me how to turn the output into a one-page brief for each negotiation: current spend, trend, and the ask.
Payroll Cost Breakdown
Act as an FP&A analyst. Payroll register columns: [Employee ID, Department, Role, Salary, Bonus, Benefits Cost, Month]. I need the full cost picture for budgeting. Give me the pivot plan: 1) fully-loaded cost by department (salary + bonus + benefits), 2) average cost per head by role level (spot outliers), 3) month-over-month headcount and cost trend (find hiring spikes). Include the formula logic for annualizing partial-year hires and how to treat open positions in the forecast version.
Inventory Movement Analysis
Act as an inventory accountant. Data: [SKU, Category, Beginning Qty, Purchases, Sales, Ending Qty, Unit Cost]. I need to find slow-moving and potentially obsolete stock. Give me the pivot and calculation plan: 1) months-on-hand per SKU (ending qty / average monthly sales), 2) pivot by category to find the worst pockets, 3) the filter logic that flags SKUs with zero sales in 90+ days. Then the reserve logic: how to tier the obsolescence reserve by months-on-hand bands, with the journal entry to book it.
Multi-Entity Consolidation Plan
Act as a consolidation accountant. I have trial balances for [N] entities in [CURRENCY/IES], with intercompany balances. Give me the spreadsheet architecture for consolidation: the tab structure (TB inputs, FX rates, eliminations, consolidated), the exact elimination entries to build (intercompany AR/AP, revenue/cost, investment vs equity, dividends), how to handle the FX translation (which rate for P&L vs balance sheet, where the CTA goes), and the 3 tie-out checks that prove the consolidation balances before I start writing the statements.
Duplicate Payment Hunter
Act as an AP analyst hunting duplicate payments. Data columns: [Vendor, Invoice #, Invoice Date, Amount, Check #]. Give me the detection plan: 1) the pivot grouping by vendor and amount to surface same-amount repeats, 2) the logic to flag the same invoice number paid twice, 3) how to catch near-duplicates (same vendor, amount off by a penny, dates within 30 days), 4) the recovery email template to the vendor. Rank findings by dollar amount and end with the preventive control to propose afterward.
Sales Commission Accrual Pivot
Act as a sales-comp analyst. Data: [Rep, Deal, Amount, Close Date, Commission Rate, Paid Y/N]. I need the month-end commission accrual. Pivot plan: 1) commissions earned but unpaid by rep (the accrual), 2) by close date to catch deals closed but not yet in payroll, 3) the filter for clawback-eligible deals (canceled within [X] days). Include how to handle accelerators and tiered rates, and the accrued-versus-paid reconciliation that proves completeness.
Lease Schedule Validator (ASC 842)
Act as a lease accountant. Data: [Lease ID, Commencement, Term, Payment, Discount Rate, ROU Asset, Liability]. I need to validate the amortization schedules. Analysis plan: 1) recompute the present value of payments versus the recorded liability (flag variances over $[X]), 2) group by commencement month to catch leases never set up, 3) flag leases expiring within 90 days for renewal decisions. Include the three most common ASC 842 schedule errors and how each one shows up in the data.
Headcount Plan vs Actual
Act as an FP&A analyst. Data: [Employee, Department, Start Date, End Date, Annual Salary, Status]. Plan called for [X] heads at $[Y] cost. Pivot plan: 1) actual versus plan heads by department by month, 2) cost variance split into headcount variance versus timing variance (hires that slipped), 3) open requisitions aged over 60 days. Show the math that separates ‘we hired fewer people’ from ‘we hired them late’ – leadership always confuses the two.
Customer Profitability Ranker
Act as a profitability analyst. Data: [Customer, Revenue, COGS, Support Tickets, Service Hours]. Support cost per ticket $[X]; service hour cost $[Y]. Pivot plan: 1) fully-loaded margin by customer (revenue minus direct and allocated service costs), 2) rank and isolate the bottom 10%, 3) the scatter logic (revenue vs margin) to find big-but-unprofitable accounts. Then the action menu for a loss-making strategic account: reprice, reduce service, or exit – with the analysis each choice needs.
CAC Payback Analyzer
Act as a growth finance analyst. Data: [Customer, Acquisition Month, CAC, Monthly Revenue, Gross Margin %]. Pivot plan: 1) CAC payback months by acquisition cohort, 2) the trend – is payback improving or worsening, and which channel drives it, 3) the filter isolating customers who churned before payback (wasted CAC). Include the payback formula with gross margin and the benchmark table for [BUSINESS MODEL]. End with the one chart that tells the story.
Budget Variance Drill-Down
Act as a budget analyst. Data: [Department, Account, Month, Budget, Actual]. The overall variance is $[X] unfavorable and nobody knows why. Pivot sequence: 1) variance by department (find the worst three), 2) within the worst department, variance by account, 3) within the worst account, month-by-month to find when it broke. For each level give the exact pivot setup and the question it answers. Then the write-up template for the management report: variance, driver, one-time vs recurring, owner.
Marketing Spend Efficiency
Act as a marketing finance analyst. Data: [Campaign, Channel, Spend, Leads, Opportunities, Closed Revenue]. Pivot plan: 1) cost per lead and per opportunity by channel, 2) pipeline and revenue ROI by campaign (closed revenue divided by spend), 3) the cohort view: spend month versus revenue realized over the next two quarters (lag matters). Flag the two attribution traps that make bad channels look good, and give me the one-page summary format for the CMO.
Charts & Graphs
Trend Chart Spec
Act as a data-visualization specialist for finance. I need a monthly trend chart of [METRIC, e.g. revenue] for the last 12 months, with [BUDGET/ACTUAL/PRIOR YEAR] comparison. Specify: the chart type and why (line vs bar vs combo), exactly which series go on which axis, how to handle the scale (zero baseline or not, and why), the 2 annotations to add (what happened in the spike/dip months), and the title that states the takeaway, not just the topic. Also the 1 design choice that most commonly misleads readers of this chart type, so I avoid it.
Waterfall Bridge Builder
Act as an FP&A analyst building a budget-to-actual bridge. Budget EBITDA: $[X], Actual: $[Y]. Drivers: [LIST EACH WITH +/- AMOUNT, e.g. volume +$80k, price +$40k, labor -$60k]. Give me the waterfall construction plan for Excel/Sheets: the data table layout (including the invisible base series trick), the order of the bars (largest drivers first or chronological – pick and justify), how to color favorable vs unfavorable, and the 2-sentence narrative that walks a reader across the bridge. Include what to do when there are more than 7 drivers.
13-Week Cash Chart Pack
Act as a treasurer designing a weekly cash dashboard. I have a 13-week forecast: [INFLOWS, OUTFLOWS, ENDING BALANCE per week]. Specify a 3-chart pack: chart 1 (weekly ending balance vs minimum liquidity target – the survival chart), chart 2 (inflows vs outflows bars – the timing chart), chart 3 (cumulative variance vs last week’s forecast – the accuracy chart). For each: chart type, series, the threshold line to draw, and the one number the CFO should read first. Designed for a Monday morning treasury meeting.
CFO Dashboard Planner
Act as a finance transformation consultant. The CFO wants a one-page monthly dashboard for [COMPANY TYPE]. Recommend exactly 6 visuals: the metric, the chart type, and the comparison shown (vs budget, vs prior year, trend) for each – covering profitability, liquidity, efficiency, and risk. Then the layout: what goes top-left (the first thing eyes hit) through bottom-right, and why. Finally, the 2 metrics that should NEVER be on a CFO dashboard and what to show instead. Practical, opinionated, no generic advice.
Variance Chart Pack
Act as a management reporting analyst. I need board-ready variance visuals for [PERIOD]: revenue, gross profit, opex, and EBITDA – each with actual vs budget. Specify the chart approach: grouped bars with variance callouts vs small multiples (pick one and justify), how to label variances (absolute, percent, or both – and when each), the color logic (including colorblind-safe choices), and the annotation rule (which variances get a text explanation and which do not). The pack must be readable when printed in black and white.
Debt Maturity Visualizer
Act as a treasurer presenting the debt profile. Debt stack: [LIST EACH FACILITY WITH BALANCE, RATE, MATURITY, e.g. Term Loan A $5M 6.2% due 2028]. Specify the visual: a maturity tower (bars by year due) with the weighted-average rate annotated, plus a small table of covenants alongside. Then the 3 talking points for the board: refinancing risk concentration, the all-in cost trend, and headroom. Include how to show the undrawn revolver so it reads as liquidity, not debt.
Budget Burn Tracker
Act as a department finance partner. Annual budget: $[X] for [DEPARTMENT]; we are [X] months into the year with $[SPENT] spent and $[COMMITTED] in open POs. Design the burn visual: actual + committed vs straight-line budget, the projected year-end position at current run rate, and the RAG (red/amber/green) rule with exact thresholds. Then the conversation guide: what to say if we are amber (the 3 questions to ask the budget owner) and the 2 levers to pull if we go red.
Chart Title & Annotation Writer
Act as an executive-communications coach for finance. I have these charts for the board pack: [LIST EACH WITH ITS DATA POINT, e.g. revenue bar chart showing +14%]. Rewrite each chart title so it states the conclusion, not the topic (bad: ‘Revenue’; good: ‘Revenue grew 14% on new logos’). Then write one annotation per chart – the single sentence a director needs if they read nothing else. Rules: numbers in every title, no jargon, no ‘as you can see’. Give me before/after for each.
Burn and Runway Chart
Act as a startup finance lead. Monthly data: [Cash In, Cash Out, Ending Cash] for [N] months actual plus [N] months forecast. Design the visual: bars for in/out, a line for ending cash, the zero-cash date marked, and current runway in months as the headline number. Specify how to show the forecast portion distinctly (dashed line, shading), the two scenarios to overlay (hiring plan vs freeze), and the annotation for the fundraise-timing implication. Built for a board that thinks in runway.
Scenario Comparison Chart
Act as an FP&A analyst. Three scenarios for [NEXT YEAR]: base revenue $[X], upside $[Y], downside $[Z], with EBITDA for each. Design the comparison visual: pick the chart type that shows all three without clutter (grouped bars, tornado, or fan chart – justify your pick), show the key assumptions driving the spread, and include probability weighting if we show an expected value. Then the two-sentence narrative: what has to go right for upside, and what breaks in downside.
Customer Concentration Pareto
Act as a revenue analyst. Data: [Customer, Annual Revenue] for the top [N] customers. Design the Pareto visual: bars per customer in descending order plus the cumulative percentage line, the 80/20 marker, and a callout on the top three. Specify axis choices that keep small customers visible, and the two risk statements to place underneath (quantify what happens if the top customer leaves). Built to make concentration risk impossible to ignore.
Pipeline Coverage Visual
Act as a sales finance analyst. Data: [Stage, Amount, Probability]; quarterly target $[X]. Design the visual: weighted pipeline versus target with the coverage ratio as the headline, pipeline by stage, and the aging overlay (deals stuck 90+ days flagged). Specify the coverage benchmark for [SALES MODEL] and the two questions the chart must force: is there enough pipeline, and is it real.
Working Capital Trend
Act as a controller. Monthly data: [AR, Inventory, AP] for 12 months; revenue $[X]. Design the working capital visual: the cash conversion cycle trend (DSO + DIO – DPO) as the hero line with the three components beneath it. Specify how to annualize the ratios, which benchmark to show, and the annotation rule (which swings get explained). Then the one action each component suggests when it deteriorates.
Gross Margin Bridge
Act as a product finance analyst. Gross margin moved from [X]% to [Y]%. Drivers: [price, mix, input costs, freight, other – with amounts]. Design the margin bridge: a waterfall from old margin to new, drivers ordered by size, mix effect separated from rate effect. Specify the data table behind it and the two-sentence narrative. Include the grouping rule for when there are 10+ small drivers.
Cohort Retention Chart
Act as a SaaS finance analyst. Data: [Cohort Month, Starting Customers, Active at M1/M3/M6/M12]. Design the retention visual: a cohort heatmap table (green to red) plus the average retention curve. Specify the normalization (percent of cohort start), how to handle partial cohorts, and the two insights to call out (best and worst cohort, with why). Built for the board discussion on net revenue retention.
Headcount Cost Waterfall
Act as an FP&A analyst. Headcount cost moved from $[X] to $[Y]. Drivers: [new hires, departures, raises, benefits inflation, contractors]. Design the waterfall: start to end with each driver as a bar, hires and departures shown gross (never netted), and the run-rate implication annotated at the end. Specify the data cuts needed and the one question the CFO will ask that the chart must pre-answer.
Treasury & Cash Management
13-Week Cash Forecast Builder
Act as a treasurer building a 13-week cash forecast for [COMPANY TYPE, e.g. a $20M manufacturer]. Starting cash: $[X]. Give me the forecast architecture: the inflow categories (collections by customer type with timing assumptions), the outflow categories (payroll, AP, debt service, capex) with their weekly timing logic, how to derive receipts from the AR aging (not from revenue), and the 3 sensitivity cases to run (base, downside -15% collections, delayed big customer). Include the weekly review ritual that keeps it accurate.
Daily Cash Position Summary
Act as a treasury analyst writing the morning cash email. Today’s data: opening balances [ACCOUNTS WITH AMOUNTS], expected inflows $[X] (from [SOURCES]), scheduled outflows $[Y] (payroll $[A], AP $[B], debt $[C]). Draft the daily cash position summary: total available liquidity, today’s net movement, any account that needs funding or sweeping, and the action required (with owner and deadline). Format for a 30-second read on a phone – the treasurer triages this before coffee.
Liquidity Risk Memo
Act as a treasurer writing to the CFO. Facts: cash $[X], undrawn revolver $[X], minimum operating need $[X]/month, debt maturities in next 12 months $[X], largest customer is [X]% of revenue. Write a one-page liquidity risk memo: the current runway math, the 3 scenarios that break it (customer loss, covenant trip, maturity wall), the early-warning indicators to watch monthly, and the recommended actions in priority order (extend revolver, slow capex, etc.). Calm, factual, no alarmism – but no sugarcoating either.
FX Exposure Brief
Act as a treasury analyst. The company has revenue in [CURRENCIES] and costs in [CURRENCIES]; net exposure roughly $[X] per quarter. Explain our FX exposure in plain terms: where we are long and short by currency, what a 10% move in [MAIN CURRENCY] does to EBITDA (show the math), and the 3 hedging approaches available (natural hedging, forwards, options) with when each makes sense and what each costs. End with a recommendation sized to our exposure – including the case for doing nothing.
Covenant Compliance Monitor
Act as a debt compliance specialist. Facility: [NAME], covenants: [LIST EACH WITH THRESHOLD, e.g. leverage < 3.0x, fixed charge > 1.25x]. Current financials: [INPUTS]. Build the compliance check: compute each ratio showing every input and the math, state pass/fail with the headroom in both ratio points and dollars, and project next quarter under base and downside cases. Then the action list: what to do if headroom drops below [X]%, and the exact information package the bank will want at the next compliance certificate.
Corporate Investment Policy Draft
Act as a treasurer drafting an investment policy for surplus corporate cash of ~$[X]. Draft the policy sections: objectives in priority order (safety, liquidity, yield), permitted instruments (with max maturities and credit-quality floors), concentration limits per issuer and instrument type, who can approve what (authority matrix), and reporting (what the board sees quarterly). Then the 2 most common policy violations at companies our size and the control that prevents each. Board-ready tone.
Disbursement Timing Optimizer
Act as a treasury analyst optimizing payment timing. Weekly outflows: payroll $[X] on [DAYS], AP averaging $[X]/week, debt service $[X] on [DATE]. Inflows are lumpy: [DESCRIBE]. Design the disbursement calendar: which payments go on which days to smooth the weekly low point, how much buffer to keep above the minimum balance, and the rules for accelerating vs delaying AP (discount capture vs float). Quantify the benefit: interest saved or overdraft risk removed. No late payments to critical vendors – state the guardrails.
Bank Fee Benchmark Memo
Act as a treasurer preparing a bank fee negotiation. Current annual fees: $[X] broken into [ACCOUNT MAINTENANCE, WIRE, ACH, LOCKBOX, ETC.]. Balances held: $[X] average. Draft the negotiation memo: the fee-per-service comparison to ask the bank for, the 3 asks ranked by value (fee waivers, earnings credit rate increase, service bundling), the leverage we hold (balances, growth, competing bids), and the walk-away alternative. Include the exact email to the relationship manager requesting the review meeting.
Intercompany Funding Memo
Act as a treasury manager. [SUBSIDIARY] needs $[X] for [PURPOSE]; funding options are an intercompany loan or a capital contribution. Compare the two: the documentation each requires (loan agreement terms vs board resolutions), the tax and transfer-pricing implications to flag with advisors, the FX considerations if cross-border, and the repayment mechanics. Recommend one with reasoning, then list the 4 documents to execute before the cash moves. Note where I must involve tax/legal rather than deciding alone.
Cash Sweep Structure Memo
Act as a treasurer designing a cash concentration structure. Entities: [LIST WITH COUNTRIES AND CURRENCIES]; daily balances in the range of [RANGE]. Compare physical sweeping versus notional pooling: how each works, the tax and regulatory constraints per country (flag where counsel is required), target-balance mechanics, and the bank implementation steps. Recommend one with the quantified benefit (interest saved or yield earned). Include the three questions the bank’s implementation team will ask first.
TMS Selection Brief
Act as a treasury consultant. Current state: [spreadsheets, N bank portals, X entities]. Requirements: [cash positioning, payments, forecasting, bank connectivity]. Draft the TMS selection brief: must-have versus nice-to-have features, five vendor categories to shortlist for a company our size, the scoring matrix (functionality, integration, cost, support), and the three demo scenarios that reveal real capability rather than slideware. Include the total-cost-of-ownership items vendors hide.
Payment Fraud Prevention Checklist
Act as a treasury risk specialist. Our payments: [ACH, wires, checks] totaling $[X]/month; team of [N]. Build the fraud prevention checklist: controls per payment type (dual approval thresholds, callback verification for new vendors, positive pay), the five red flags of business email compromise with the response for each, and the incident response steps if a fraudulent wire goes out (first 24 hours, hour by hour). Include the annual training outline for the AP team.
Revolver Draw Decision Memo
Act as a treasurer. Facts: cash $[X], forecast minimum $[Y] in [WEEKS], revolver capacity $[X] at [RATE], upcoming [PAYROLL / DEBT / AP SPIKE]. Write the draw decision memo: the liquidity math showing the shortfall, how much to draw and when (with the cost of carrying it), the alternatives considered (delay capex, accelerate collections – and why each is insufficient), and the repayment plan tied to specific expected inflows. One page, decision-ready for the CFO.
Payment Processing Cost Review
Act as a treasury analyst. We process $[X]/year in card payments at a [BLENDED RATE]% blended rate, plus [ACH/wire volumes]. Analyze: the effective rate by card type (debit vs credit vs rewards – the spread matters), the three fee categories to challenge (interchange is fixed; assessment and processor markup are negotiable), and the RFP question list for processors. Quantify the savings from [SPECIFIC LEVER, e.g. PIN-less debit routing]. Add the surcharging legality note for [STATE].
Dividend Distribution Memo
Act as a controller. The board wants to distribute $[X] to [owners/shareholders]. Analyze: 1) legal availability (retained earnings and solvency tests under [STATE] law – flag counsel review), 2) cash availability (post-distribution liquidity versus minimum target), 3) tax characterization (ordinary income vs return of capital – involve the tax advisor), 4) loan covenant restrictions (check the distributions basket). Write the memo with a clear go / go-with-conditions / no-go recommendation, plus board resolution language if approved.
Bank Account Rationalization Plan
Act as a treasury analyst. We hold [N] accounts across [M] banks: [LIST WITH PURPOSE AND BALANCE]. Build the rationalization plan: the analysis (cost per account, purpose, activity level), a keep/close/consolidate recommendation per account with reasoning, the closure sequence (which first, what breaks if closed in the wrong order), and the stakeholder sign-offs needed. Quantify fees saved, balances freed, and controls simplified. Include the dormant-account escheatment check before closing anything.
Escrow and Earnout Tracker
Act as a treasurer tracking deal consideration. Deal: [ACQUISITION/SALE]; escrow $[X] releasing on [DATES/CONDITIONS]; earnout up to $[X] tied to [METRICS]. Build the tracking memo: the release calendar with conditions and owners, the accounting treatment of each piece (flag the liability-versus-equity classification for technical review), the monthly mark-to-market process for the earnout, and the three disputes that most commonly arise at release. Include the notification template for the escrow agent.
Google Docs Pro Kit
Draft an Engagement Letter
Draft a Google Docs CPA engagement letter for [SERVICE, e.g. monthly bookkeeping and tax preparation] for client [CLIENT NAME]. Include: scope of services (exactly what is and is not included), client responsibilities (records, timeliness), fee structure $[X] [monthly/fixed/hourly] and billing terms, term and termination (30 days notice), limitation of liability, and e-signature blocks for both parties. Professional firm tone. Add bracketed notes where I must customize, and a footer line stating it is a template requiring attorney review before use.
Draft a Management Representation Letter
Draft a Google Docs management representation letter for the [YEAR] audit of [COMPANY]. Include the standard representations: financial statement responsibility, completeness of information, subsequent events, related parties, contingencies, going concern, and fraud. Format with numbered paragraphs and signature lines for CEO and CFO dated as of the audit report date. Formal audit tone. Add a bracketed cover note listing the 3 representations most often customized per engagement.
Write an Audit Findings Memo
Draft a Google Docs memo documenting an audit finding. Finding: [DESCRIBE, e.g. 4 of 25 disbursements lacked second approval]. Structure: background, criteria (what the control requires), condition (what we found, with the sample results table), cause, effect (quantified exposure), and recommendation (specific, owned, dated). Write it in the factual, non-accusatory tone auditors use – findings describe conditions, not people. Include a management-response section left blank for the client.
Create a Month-End Close Checklist Doc
Create a Google Docs month-end close checklist for a [COMPANY TYPE, e.g. 2-entity services firm]. Organize as a table: Task | Owner | Due (Day 1-5) | Evidence of completion. Cover: bank/credit recs, AR/AP subledgers, revenue cut-off, payroll accrual, prepaids/fixed assets, intercompany, flux review, and reporting pack. Add a status column with checkbox-style markers and a notes column for issues carried forward. Designed to be reused monthly – the owner just duplicates it each close.
Draft a Debt Covenant Compliance Certificate
Draft a Google Docs debt covenant compliance certificate for [LENDER], period ending [DATE]. Include: borrower and facility identification, the covenant table (covenant, required threshold, actual result, compliant Y/N) with [BRACKETED] inputs, the officer certification paragraph, and signature/date lines. Formal bank-document tone. Add a bracketed preparer note: attach the supporting calculation schedule and retain with the credit file.
Build a Cash Forecast Template Doc
Build a Google Docs 13-week cash forecast template. Structure: instructions tab-equivalent at top (how to update weekly, in 5 steps), then the forecast table (Week | Beginning Cash | Receipts by source | Disbursements by category | Ending Cash | vs Target), then an assumptions log (each timing assumption with owner), then a variance section comparing to last week’s forecast. Add bracketed guidance on deriving receipts from AR aging rather than revenue. Clean, print-ready formatting.
Draft a Client Tax-Law Update Email
Draft a Google Docs client email explaining [TAX LAW CHANGE, e.g. the new BOI reporting rules]. Structure: what changed (2 sentences, plain English), who it affects (be specific), what the client must do and by when (numbered actions with deadlines), what happens if they ignore it, and what we need from them (document request list). Reassuring but clear tone – no panic, no jargon. End with a single call to action. Under 300 words.
Create an Internal Controls Narrative
Create a Google Docs internal controls narrative for the [PROCESS, e.g. procure-to-pay] cycle at [COMPANY]. Document: the process flow in numbered steps, the control owner at each step, the control activity (preventive or detective), how the control is evidenced, and the frequency. Then a gap table: step | risk if control fails | current state | recommendation. Written for an auditor to walk through – precise enough to test against. Include a bracketed note to attach the flowchart separately.
Draft the Audit PBC List
Draft a Google Docs audit PBC (provided-by-client) list for the [YEAR] audit of [COMPANY]. Organize by area (cash, AR, inventory, fixed assets, AP, debt, equity, revenue) as a table: Item # | Document requested | Prepared by | Due date | Status. Include the ten items auditors always ask for first, the format they want each in (trial balance, aging, rollforward), and a bracketed note on file-naming conventions. Designed so the audit starts on time – the controller just fills in owners and dates.
Draft the Revenue Recognition Memo (ASC 606)
Draft a Google Docs ASC 606 memo for [CONTRACT TYPE, e.g. annual SaaS contracts with implementation]. Walk the five steps: identify the contract, identify performance obligations, determine transaction price (including variable consideration), allocate, recognize. Include a bracketed worked example with a $[X] contract value, the journal entries at inception and monthly, and the disclosure checklist. Flag the two judgments auditors challenge most on this contract type and how to support each.
Draft the Lease Abstract Summary
Draft a Google Docs lease abstract summary for the [N] leases at [COMPANY]. Table format: Lease | Counterparty | Term | Payments | Renewal options | Key clauses (escalation, termination). Then the ASC 842 section: classification conclusion per lease with reasoning, the discount rate used and why, and the ROU asset and liability tie-out. Include a bracketed renewal-decision calendar for leases expiring within 12 months. Built for both the auditors and the CFO.
Draft the Board Consent Resolution
Draft a Google Docs unanimous written consent of the board of [COMPANY] to [ACTION, e.g. open a bank account or approve a credit facility]. Include: recitals (background facts), resolved clauses (exactly what is authorized, with dollar limits and authorized signers), and signature lines for all [N] directors with dates. Formal corporate tone. Add bracketed notes marking where counsel must review, and the instruction to file the executed consent with the corporate records.
Draft the Wire Approval Policy
Draft a Google Docs wire transfer approval policy for [COMPANY]. Sections: approval thresholds (who approves what dollar amount; dual approval above $[X]), new-vendor verification (callback to a known number – never trust the number in the email), the vendor banking-change workflow, segregation of duties (who may initiate vs approve vs release), and the fraud response protocol. Include the annual attestation sign-off. Written to be enforced daily by AP, not filed away.
Build the Year-End Tax Organizer
Build a Google Docs year-end tax organizer for [ENTITY TYPE] for tax year [YEAR]. Sections as checklists with [BRACKETED] inputs: income documents, deductions, payroll and estimated tax payments, fixed asset additions, owner transactions, and the five questions that always come up (home office, vehicle, related parties). Include the document request list with formats, the deadline calendar (federal and [STATE]), and a bracketed note on what changed in tax law this year. Designed to get the CPA a clean package in January.
Draft the Expense Reimbursement Policy
Draft a Google Docs employee expense reimbursement policy for [COMPANY, N employees]. Cover: what is reimbursable (per-diem or actuals rules for travel; meals capped at $[X]), the receipt threshold ($[X] and above), submission deadline ([X] days) and the approval chain, non-reimbursable items (listed plainly), and the monthly close cut-off. Include the one-page quick-reference version for new hires. Firm but fair tone – enforceable without killing morale.
Draft the New Vendor Setup Form
Draft a Google Docs new vendor setup packet for [COMPANY]. Include: the vendor information form (legal name, address, tax ID field marked [DO NOT EMAIL – SECURE UPLOAD ONLY], payment details), required attachments (W-9/W-8, banking letter), the approval workflow (requester, AP, controller sign-offs), and the fraud-prevention step (independent phone verification of banking details). Add bracketed instructions for the secure intake process. State plainly: nothing in this packet travels by regular email.
Draft the Month-End Close Summary Report
Draft a Google Docs month-end close summary report for [COMPANY], [MONTH YEAR]. Include: an executive summary in 3 sentences covering results vs budget, key variances over [THRESHOLD] with one-line explanations drawn from [BRIEF NOTES], open close items with owners and due dates from [OPEN ITEMS LIST], and a next-month focus section. Format with H1 and H2 headings, a results table, and a sign-off block for the controller. Professional tone with no jargon the CEO will not understand. Add bracketed notes wherever I must insert company-specific figures before sending.