◆ Accounting

What a treasury 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
Produce a rolling three-year cash and liquidity forecast from historic…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+
Produce a rolling three-year cash and liquidity forecast from historic receipts and payments, flag months with shortfalls over 10 percent, show assumptions for receivables timing and debt maturities, and email the forecast to Head of Treasury by Wednesday.
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 month-to-date spend against approved budget lines, identify variances over 5 percent with root causes and policy breaches, prepare a one-page exception note and send it to Finance Director and Budget Owner by close of business tomorrow.
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 year-to-date performance against annual budget by department, score each objective as on-track, at-risk or off-track with supporting KPIs, assemble a two-slide summary for the CFO and present it at Friday’s budget review meeting.
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+
Compile the monthly treasury budget report showing cash position, short-term investments, and debt service versus plan, explain any variances over 5 percent, and deliver the report to the treasury manager by close of business Wednesday.
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+
Build a rolling 12-month cash forecast incorporating AR timing changes and the planned drawdown on the line of credit, model a base and stressed scenario, and send the forecasts with assumptions to the head of treasury and the CFO by next Tuesday.
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 three proposed projects using present value of costs and benefits over five years, rank by net present value and payback period, and submit the ranked recommendation and working schedules to the investment committee on 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 line-item appropriations for the Rural Health Initiative, Emergency Response Reserve, and Central Services into their parent program codes, flag any emergency entries lacking authorization memos, and produce a reconciled schedule that balances to the monthly ledger by Thursday close.
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+
Assess the capital and operating cost assumptions in the Oak Street project proposal, test three downside scenarios against current cash forecasts, note policy compliance issues, and summarise whether the project meets our return thresholds and funding windows for the monthly investment committee.
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 Excelflexible for line-by-line budget comparisons, variance analysis and preparing exception notesOpen its task library →
6 tasksSAPstores appropriation ledgers and lets you extract and validate budgetary balances for reconciliation
5 tasksMicrosoft Power BIvisualises departmental performance and KPIs to evaluate budget objective achievement
4 tasksAdaptive Planningbuilt for multi-period budgeting and rolling forecasts used by treasury teams
3 tasksMicrosoft Worddrafts the decision memo with rationale and recommended schedulesOpen its task library →
2 tasksStructured query language SQLpull project cost and revenue line-level details from the financial database if needed
1 taskMicrosoft PowerPointpackages the briefing slides and stress-test visuals for executive and board presentation
1 taskMicrosoft SharePointpublish the revised master budget template and guidance for Budget Owners to access and collaborate
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 a treasury 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
M · R6 of R7This job sits on budgeting — real theory, real diagnosis, but reality still holds the grading pen.

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 UK NOS PPLMRPT 11Manage a budgetnational standard

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’ll split time between forecasting, monitoring cash flows, and reviewing funding requests. Morning might be running cash forecasts in Adaptive Planning or Excel and checking bank balances or short-term investments.

Afternoons go to meetings with project managers, approving or recommending funding, and producing budget reports in Power BI or Word. Expect regular ad-hoc analysis: cost-benefit checks, matching appropriations to programs, and updating the ERP (SAP) with decisions.

Start with Excel: advanced formulas, pivot tables, and VBA macros handle most treasury tasks. Most teams use Excel daily for forecasts, cost detail, and quick reconciliation.

Then learn Adaptive Planning for rolling forecasts, SAP or another ERP for actuals and approvals, and SQL for querying transaction data. Power BI or PowerPoint are needed to present findings; SharePoint to store reports.

Use AI to draft routine language (email, report narratives) and to speed repetitive calculations, but always check numbers yourself against source systems like SAP or ERP exports. Never let AI replace the reconciliation step.

Automate data pulls with SQL queries and scheduled reports into Power BI or Excel, then document every automated step in SharePoint. Keep approval controls in the ERP and avoid sending raw payment instructions generated by AI.

Forecasting cash needs, matching appropriations, and budget adherence are rule-heavy: you use formulas, thresholds, and policy limits. For example, you might keep a minimum cash buffer of X days of payroll or follow legislative rules when drafting budget items.

Cost-benefit analyses and measuring strategic plans require numeric targets—ROI, NPV, or savings—and you must show the calculations in Excel and the supporting transactions from SAP or SQL queries.

A Treasury Analyst focuses on cash, funding, and liquidity—forecasting future cash needs, approving funding, and monitoring spending. You work with bank relationships and short-term investments rather than month-end closes.

Financial Analysts often do long-term planning and performance analysis across products. Accountants handle ledgers, reconciliations, and compliance. You’ll still use similar tools (Excel, ERP) but apply them to cash and budgeting flows.

A bachelor’s in finance, accounting, or economics helps. Learn Excel to an advanced level, basic SQL, and get hands-on with Adaptive Planning or any ERP like SAP. Short online courses on cash management and budgeting are useful.

Volunteer for roles that touch budgets or treasuries—intern with finance, help produce budget reports, or assist in cost-benefit analyses. Build a portfolio: three clean Excel models and one SQL query tied to actual data.

Tell stories that show accurate forecasting and decision impact. Employers want to see you made a forecast, tracked results, and corrected course—give numbers (forecast vs. actual) and describe tools used (Excel model, Adaptive Planning, SAP).

Bring an example file or screenshots: a cash-forecast sheet, a cost-benefit analysis with assumptions, and the Power BI slide you used to communicate results. Concrete numbers and systems prove you can do the job.

km/h RPM

How far can AI take you?

one question
Be honest — how far can a language model take you on budgeting?
There is a real answer, and it is not the flattering one.