◆ Accounting

What an FP&A analyst
really does.

21 tasks, each one witnessed by the sources that watched the job — and behind every one, a prompt you can use tonight.

21evidenced tasks
8systems it runs on
See the 21 tasks ↓Open in the atlasThe full career map →
This is what one task looks like here
Forecast future financial needs
Build a three-year cash and headcount forecast from the latest actuals…2 sources agree

The shape of the day

tap a movement to see its tasks

Which one is you, right now?

Pick the moment · no score, no sign-up
Which moment is you right now?
Whichever you pick, the task behind it opens below.

The work, task by task

21 tasks
Hands on the work19
Forecast future financial needs+
Build a three-year cash and headcount forecast from the latest actuals and hiring plans, stress-test revenue and cost drivers for downside scenarios, and flag months where external funding or temporary cost cuts will be needed.
jdwiki2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Ensure adherence to approved budgets+
Compare current spend to the approved annual budget by department, identify recurring overspends and the managers responsible, and prepare a short remediation plan with controls to keep cumulative variance under 2 percent.
onetwiki2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
N Evaluate achievement of budget objectives+
Assess whether this quarter’s results meet the budget objectives by calculating realized versus target KPIs, ranking shortfalls by business unit impact, and recommending corrective actions to recover the full-year plan.
escowiki2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Prepare budget reports+
Prepare the Q3 departmental budget report with actuals-to-budget variance for Marketing, Sales and Operations, highlight any line items exceeding 10 percent variance, and circulate the report with slides to the leadership team by Tuesday morning.
escojdwiki3 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Prepare budget reports and forecasts+
Produce a rolling 12‑month forecast and updated budget for the product roadmap, incorporating revised sales assumptions from the commercial team, show the headcount and CAPEX impact, and deliver a model and summary to Finance and the CEO by next Wednesday.
jdonet2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Perform cost-benefit analyses of projects+
Run cost‑benefit analyses for the proposed warehouse automation and the marketing automation pilot, include NPV, payback and sensitivity to 10 percent volume change, produce a recommendation memo, and send both analyses to the project sponsors by Friday.
jdonet2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Match appropriations for specific programs with appropriations for broader programs, including items for emergency funds.+
Match the project-level appropriations listed in the May spend schedule to the corresponding program-level lines in the quarter master ledger, including any emergency fund lines, and flag any amounts that do not roll up cleanly for reconciliation by Tuesday.
onet
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Analyze proposals and new project plans+
Review the capital and OPEX sections of the three new project proposals on my desk, test their revenue and cost assumptions against last year’s project benchmarks, then produce a one-page risk-adjusted ROI and break-even summary for Monday’s project review.
jd
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Grow the practice1
Watch and assess1

What the work runs on

named inside the evidenced tasks
13 tasksMicrosoft Excelmodels multi-year financials, scenarios and sensitivity analysis for forecastsOpen its task library →
5 tasksAdaptive Planningcentralised budget control, departmental comparisons and remediation planning
4 tasksMicrosoft Wordformats the recommendation and rationale for circulation to managementOpen its task library →
3 tasksMicrosoft Power BIvisualises KPI attainment and ranks unit-level impacts to support corrective recommendations
3 tasksMicrosoft PowerPointcreates the slide pack summarising key variances and recommendations for leadership
2 tasksSAPprovides the authoritative budget balances and payment schedules to verify funding availability
1 taskStructured query language SQLpulls source ledger lines for cross-checking when needed
1 taskMicrosoft SharePointto locate current policy documents and share the draft with Legal and HR for review
Browse every evidenced software task →

The same task, four heights

this page is height one
ExecuteDo today's task, with fewer mistakesyou are here → ImproveMake it easy for the next person to acceptin the atlas → DecideWork out the right move when it is unclearin the atlas → BecomeLearn the pattern so it stops coming backin the atlas →

Can AI actually do this job?

the honest answer

It can

where it genuinely helps
  • Explain the theory behind the work
  • Draft, tidy and structure your writing
  • Rehearse a hard conversation before you have it
  • Build a study plan that fits your gaps

It cannot

where it stops, completely
  • Be in the room where an FP&A analyst actually works
  • Carry the responsibility when the call is wrong — that weight stays yours
  • Notice what no one wrote down: the hesitation, the thing left unsaid
  • Live with the outcome

Where the evidence lives

open any of it yourself
O*NETThe US Department of Labor's own record of this job6 of these tasks ESCOThe European skills and occupations register6 of these tasks Job descriptionsReal postings, in the wild9 of these tasks WikipediaHow the world describes this work7 of these tasks

Close to this work

12 nearby
AccountingFinancial Reporting Analyst26 evidenced tasks AccountingInvestment Analyst25 evidenced tasks AccountingAccountant23 evidenced tasks AccountingChartered Accountant23 evidenced tasks AccountingAuditor23 evidenced tasks AccountingGst Practitioner23 evidenced tasks AccountingBookkeeper23 evidenced tasks AccountingCorporate Accountant23 evidenced tasks

Questions people actually ask

You spend most mornings pulling numbers from systems like SAP or SQL databases, then cleaning them in Microsoft Excel. Expect regular tasks: updating forecasts in Adaptive Planning, checking actuals against budgets, and preparing budget reports and slides in PowerPoint.

Afternoons often mean meetings: reviewing spend with department heads, advising management on funding requests, or running cost-benefit analyses for a new project. Weekly work includes monitoring spending activity, matching appropriations, and updating forecasts for the next month or quarter.

The most-used tools are Microsoft Excel for modeling, Adaptive Planning for rolling forecasts, and SAP or SQL for the raw financial transactions. Power BI or Excel power tools are common for dashboards, and PowerPoint or Word for presenting budget reports.

SharePoint is often where you store models, reports, and versioned documents. Learn Excel well (pivot tables, INDEX/MATCH, VBA optional) and basic SQL to pull data; Adaptive Planning skills are a big plus.

AI can speed up repetitive tasks: summarizing long budget reports, drafting narrative commentary for forecasts, or suggesting formula fixes in Excel. Use it to draft first versions of cost-benefit write-ups or to generate visuals ideas for PowerPoint.

Do not trust AI to validate numbers. Always pull data from SAP/SQL and confirm calculations in your model. Keep confidential data out of public AI tools and document any AI-assisted changes for audit trails.

Salaries vary by location and company size. In the U.S., entry-level FP&A analysts often start around $60,000 to $75,000 base; mid-level roles commonly range $80,000 to $110,000; senior analysts can be $120,000+. Public-sector pay is often lower but includes pensions or benefits.

Bonuses and total compensation depend on company performance and individual targets tied to budgetary goals. Use websites like Glassdoor or your national statistics office for exact local ranges.

Start with Excel: learn pivot tables, VLOOKUP/INDEX-MATCH, and basic macros. Then learn SQL basics to extract data and a budgeting tool like Adaptive Planning through tutorials or free trials. Practice by building simple monthly forecast models and variance reports.

Study budgetary principles, cost-benefit analysis, and how to express strategic plans in measurable terms. Volunteer to help with a budget at school or a local nonprofit to get hands-on experience.

Accounting records what already happened: trial balances, SAP entries, and month-end reconciliations. FP&A analyzes those numbers to forecast future needs, compare actuals to budgets, and advise management on funding decisions.

FP&A uses tools like Adaptive Planning for forecasts and Power BI for analysis, and focuses on planning, scenario analysis, and strategy—rather than producing audited financial statements.

Translating numbers into clear action. That means turning raw data from SQL/SAP and models in Excel into short, specific recommendations for management—approve this funding, cut that expense, or delay a project.

Combine technical skills (Excel, Adaptive Planning, Power BI) with concise communication: a one-slide summary in PowerPoint that states the decision, the number, and the timeframe. That clarity drives decisions and shows real impact.