Bank Reconciliation Analyst

Bank Reconciliation Analyst performs routine checks, treatments, and follow-ups across 20 concise tasks designed for clarity. These show who’s affected, what the main action is, and a quick safety reminder. Each one shows where we found it, and comes with an AI prompt you can copy and use straight away.

20evidenced tasks
20ready prompts
8tools of the trade
13-2031.00O*NET-SOC code
Open Bank Reconciliation Analyst in the interactive atlas →

What it pays

Government survey numbers — not estimates, not ads.

In India, Professionals earn about ₹38,298 a month on average — around ₹4.6 lakh a year (government PLFS survey via ILOSTAT, occupation-family figure).
Think you get this job?Six quick questions on how it really works — with a hint and the reason behind every answer.
Test yourself →

The work, task by task

These are the real jobs-to-be-done, not a wish list. Each task shows where we found it, and the prompt underneath is written for that exact task.

Keeping the record6

Prepare budget reports

+
Prepare the monthly departmental budget report for Finance showing actuals, committed spend, and variance to…
Prepare the monthly departmental budget report for Finance showing actuals, committed spend, and variance to budget for March, validate figures against the bank reconciliation file, add brief commentary for any variances over 5%, and circulate to Sarah in FP&A by close of business Thursday.
The tools that do the workMicrosoft ExcelESCOjob descriptionsWikipedia

Prepare budget reports and forecasts

+
Build the quarterly budget and forecast pack combining year-to-date actuals, updated revenue assumptions and…
Build the quarterly budget and forecast pack combining year-to-date actuals, updated revenue assumptions and headcount changes, run scenario sensitivity for best and worst cases, check totals against the bank statement, and deliver the pack to Tom in Planning and Lisa in Finance two working days before the board review.
The tools that do the workAdaptive PlanningMicrosoft Exceljob descriptionsO*NET

Perform cost-benefit analyses of projects

+
Run a cost-benefit analysis for the three IT projects, pull capital and operating cost lines for each,…
Run a cost-benefit analysis for the three IT projects, pull capital and operating cost lines for each, calculate NPV and payback using the approved discount rate, include sensitivity for 10% higher costs and 10% lower benefits, and send the evaluation with recommendation to Mark the PM and Anna in Investment Committee by Friday noon.
The tools that do the workMicrosoft Exceljob descriptionsO*NET

Forecast future financial needs

+
Produce the 12‑month cashflow forecast showing expected receipts, payroll, and supplier payments, flag months…
Produce the 12‑month cashflow forecast showing expected receipts, payroll, and supplier payments, flag months where closing cash falls below the minimum buffer, reconcile forecast inflows with cleared bank items, and send the forecast and action points to CFO Rachel and Treasury by Tuesday morning.
The tools that do the workMicrosoft Exceljob descriptionsWikipedia

Ensure adherence to approved budgets

+
Run a monthly compliance check against approved budgets: list all cost centres with spend exceeding budget by…
Run a monthly compliance check against approved budgets: list all cost centres with spend exceeding budget by department, attach transaction examples from the reconciliation, note policy breaches, and forward the report with remediation steps to Budget Owner Karen and Compliance by end of week.
The tools that do the workSAPO*NETWikipedia
N

Evaluate achievement of budget objectives

+
Evaluate last quarter's budget objectives by comparing actual performance to targets, score each objective as…
Evaluate last quarter's budget objectives by comparing actual performance to targets, score each objective as met, partially met or missed with supporting evidence from the bank reconciliations, summarise root causes for misses, and email the evaluation to Head of Finance Miguel and the budget holders on Monday.
The tools that do the workMicrosoft ExcelESCOWikipedia
The daily work14

Match appropriations for specific programs with appropriations for broader programs, including items for emergency funds.

+
Match line‑item appropriations for the Youth Employment Initiative and Emergency Relief Fund to their parent…
Match line‑item appropriations for the Youth Employment Initiative and Emergency Relief Fund to their parent program codes, flag any items that span multiple programs, and produce a reconciled schedule showing totals by parent program and emergency versus non‑emergency by Friday noon.
The tools that do the workMicrosoft ExcelO*NET

Seek new ways to improve efficiency and increase profits.

+
Review last six months of clearing times and processing steps, propose three low‑risk workflow changes that…
Review last six months of clearing times and processing steps, propose three low‑risk workflow changes that cut average reconciliation time by 20% and estimate annual cost savings for the bank by next quarter.
The tools that do the workMicrosoft Power BIMicrosoft ExcelO*NET

Analyze proposals and new project plans

+
Assess the budget, cashflow assumptions and risk matrix for the new branch setup and the merchant portal…
Assess the budget, cashflow assumptions and risk matrix for the new branch setup and the merchant portal upgrade, compare projected spend against available appropriations, and return a one‑page recommendation on which proposals fit current funding.
The tools that do the workMicrosoft ExcelStructured query language SQLjob descriptions

Approve funding requests and make recommendations

+
Review the three pending funding requests for April, verify policy compliance and liquidity impact, approve…
Review the three pending funding requests for April, verify policy compliance and liquidity impact, approve or recommend changes with clear conditions and an implementation timetable for Finance and Treasury.
The tools that do the workSAPMicrosoft Wordjob descriptions

Advise management on financial decisions

+
Prepare a concise briefing for the CFO outlining the cashflow scenarios, tax and compliance implications, and…
Prepare a concise briefing for the CFO outlining the cashflow scenarios, tax and compliance implications, and recommended funding mix for the next quarter to inform the board decision next Wednesday.
The tools that do the workMicrosoft ExcelMicrosoft PowerPointjob descriptions

Draft budget-related legislation (government)

+
Draft clear statutory language for a budget amendment that creates a contingency line for disaster relief,…
Draft clear statutory language for a budget amendment that creates a contingency line for disaster relief, show the fiscal impact over three years and include definitions and reporting requirements for audit compliance.
The tools that do the workMicrosoft WordMicrosoft Exceljob descriptions

Use enterprise resource planning (ERP) software

+
Reconcile the month-end bank ledger to the cashbook for April, investigate any unmatched entries over $250,…
Reconcile the month-end bank ledger to the cashbook for April, investigate any unmatched entries over $250, document root causes with transaction IDs, and prepare a one-page exception report for Treasury by Tuesday morning.
The tools that do the workSAPMicrosoft Exceljob descriptions

Analyze resource quantities including time and environmental impacts

+
Compile resource usage for the operations team for Q1, quantify staff hours, fuel and waste volumes, estimate…
Compile resource usage for the operations team for Q1, quantify staff hours, fuel and waste volumes, estimate associated emissions, and produce a summary sheet showing time and environmental impact per project by next Friday.
The tools that do the workMicrosoft ExcelWikipedia

Detail costs and expenses for services or projects

+
Break down March professional services invoices by project and cost category, allocate shared expenses,…
Break down March professional services invoices by project and cost category, allocate shared expenses, compute total landed cost per project, and send a validated cost schedule to Project Accounting before COB Wednesday.
The tools that do the workMicrosoft ExcelSAPWikipedia

Express strategic plans in measurable terms

+
Translate the department’s annual objectives into quarterly KPIs with numeric targets, set baseline values…
Translate the department’s annual objectives into quarterly KPIs with numeric targets, set baseline values from last year’s results, and deliver a KPI dashboard draft for Finance review on Friday.
The tools that do the workAdaptive PlanningMicrosoft Power BIWikipedia

Monitor the spending activities of public and private institutions and companies

+
Monitor monthly spending across business units, flag any variances greater than 10 percent versus budget,…
Monitor monthly spending across business units, flag any variances greater than 10 percent versus budget, attach transaction examples and policy citations, and circulate a variance memo to the CFO and heads of unit by Monday.
The tools that do the workMicrosoft Power BISAPESCO

Budgetary principles

+
Prepare the annual departmental budget worksheet, apply salary and inflation assumptions, reconcile totals to…
Prepare the annual departmental budget worksheet, apply salary and inflation assumptions, reconcile totals to the corporate budget template, and submit the completed file to Financial Planning by Thursday noon.
The tools that do the workMicrosoft ExcelAdaptive PlanningESCOsee the evidence ↗

Analyse financial performance of a company

+
Produce a monthly financial performance analysis for the company using the posted ledger and bank…
Produce a monthly financial performance analysis for the company using the posted ledger and bank reconciliation: reconcile variances to budget and prior month, explain material drivers over 5% or $50,000, forecast next quarter cash impact, and save a one-page summary for the CFO by Wednesday.
The tools that do the workMicrosoft ExcelMicrosoft Power BIESCOsee the evidence ↗

Company policies

+
Update and audit the company payment policy document: compare current procedures to recent reconciliations,…
Update and audit the company payment policy document: compare current procedures to recent reconciliations, mark non-compliant controls, recommend three changes to reduce reconciliation errors, circulate the redlined policy to Finance and Compliance for review by next Friday.
The tools that do the workMicrosoft WordMicrosoft OutlookESCOsee the evidence ↗

Says who?

These are the pages we read to build this. Open any of them and check us.

Activities this job lives in

The human activities behind the tasks — each with its honest AI ceiling.

The logs, files & records this job keeps

Shared with other careers — the same record means something different in each.

Related careers

Same family of work — each with its own tasks and prompts.

The LLOS Work Atlas is the world's largest evidenced task library — a map of human work, with a ready prompt behind every task. 1,774 careers · every task named by the sources that witnessed it — O*NET, ESCO, real job descriptions, Wikipedia — and the deepest tasks by several at once. And it is honest about limits: where AI cannot help, the map says so.

The rest of the map

Same library, five ways in.

Copyright © LLOS.ai · 2026 — original pedagogy, voice, and design — all rights reserved.
Built on public evidence: O*NET®, ESCO, Wikipedia, U.S. Bureau of Labor Statistics, ILOSTAT. All sources & licenses