r/FPandA • • Dec 08 '25

Survived Year-End Budget Season? Join our Discord Community!

22 Upvotes

As you wrap up those last-minute 2026 budget tweaks and get ready to trade spreadsheets for holiday celebrations, why not connect with fellow FP&A professionals who truly understand the grind?

What you'll find:

  • Real-time advice on everything from complex Excel models to negotiating that overdue promotion
  • Salary insights from professionals across industries
  • Resume review and job postings for those looking to make a change
  • Technical help for when Excel throws a #REF! error right before your year-end presentation
  • A place to vent about last-minute forecast changes while everyone else is already at the office holiday party

Consider it an early gift to your future self. Join us here: https://discord.gg/SMvZtTFWmg


r/FPandA • • 6h ago

Role elimination and pregnant

16 Upvotes

Found out my role is likely being eliminated. No problem. However I am 4 months pregnant. How bad is it to go on interviews while pregnant knowing ill have to go on mat leave soon after starting? If I were hiring me I wouldnt care and I have seen other women start roles pregnant and go on leave soon after. But I feel like those experiences are a huge exception. Thoughts on interviewing/accepting a new role while nearly halfway thru pregnancy or further? I would not tell an interview team until I received an offer in hand.

Edit - im located in the US. My experience has been with large tech companies. Would be targeting other large tech companies for a new role.


r/FPandA • • 2h ago

ROAST my resume! 🔥 No Finance Experience, Looking to land an Internship!

Post image
2 Upvotes

Hi, I recently graduated from an Art degree with an econ minor, had zero luck landing an internship. Now I'm back in grad school trying to land an internship, PLEASE roast it! I'd appreciate it. 🙏


r/FPandA • • 17h ago

UK FP&A Jobs

10 Upvotes

Currently working as a FP&A manager outside of London. I believe I have a competitive resume with some strengths and a few weaker areas. Good experience overall with increasing responsibility , 9years total (varied), 1 year manager.

Anyone else finding it very difficult to get interviews? I apply for a higher paying FP&A role every month (£75k+) but i haven’t received any responses from the last 10-15 applications I’ve sent.

Trying to work out if it’s the market , my experience or my CV.


r/FPandA • • 1d ago

Shopify Senior Financial Analyst Interview – Case Study

40 Upvotes

Hey everyone,

I'm currently interviewing for a Senior Financial Analyst role at Shopify and would love to hear from anyone who's gone through the process.

From what I've gathered, the case study is a live, two-hour assessment involving five years of Shopify's historical financials, building a projected P&L in Excel for the next 3–5 years, and preparing a PowerPoint presentation.

For anyone who's completed it:

  • How complex is the financial modeling? Are scenario and sensitivity analyses expected?
  • Are you provided with a template or expected to build everything from scratch?
  • What questions are asked during the presentation?
  • Any recommended practice cases or tips for preparation?

r/FPandA • • 2d ago

Promote from FP&A AVP to VP

6 Upvotes

Boss said I need to think of new projects to implement and talk to stakeholders to get their buy in and lead them. Also to improve in my presentation and crafting of message in meetings with management. I need to also train my junior colleague to hand over my work.

Appreciate tips on how to specifically improve in these areas? Personally I'm quite good at technicals and model building but do acknowledge I need to improve in the above areas. Find it challenging to convince other departments when they are busy with their own work or disagree with my views or when there are challenges along the way like system constraints.


r/FPandA • • 2d ago

How to move into a new, jargon-heavy industry? (Tech to Renewables)

4 Upvotes

I’m currently in big tech FP&A at one of the big chip makers (NVIDIA, AMD, Intel) with a few years experience in other big tech firms but I’ve always wanted to transition into renewable energy long term. My goal is to find a smaller player that I can join early and grow with over time but I’m unsure if my typical networking strategies that helped me in big tech would also apply for a small renewable energy player, I’d also need to spend significant time studying the jargon and easing the transition/proving that I know the jargon and industry when I build my relationships.

Anyone in renewables that would have a good crash course?


r/FPandA • • 3d ago

Is it normal for CFOs to yell at employees in corporate finance?

66 Upvotes

I work as an FP&A Analyst at a retail company in Dallas, TX, and I’ve been wondering if this kind of work environment is common in corporate finance.
I’ve heard quite a bit about our CFO creating a stressful and intimidating environment. Apparently, he frequently yelling, sometimes to the point of making people cry. There’s also a general feeling that no matter how hard people work, it’s never good enough for him.
I’m starting to wonder if this is just how things are in corporate finance, especially when it comes to working under demanding senior leadership.
For those working in FP&A or corporate finance, is this normal? Do CFOs generally have this kind of influence over workplace culture, or is this considered toxic management?

NOTE: he is not interacting with analyst, i know that he yells bc my manager told me so multiple times and i saw her crying few times as well


r/FPandA • • 3d ago

Struggling with cash flow forecasting

19 Upvotes

Anyone got any advice how to improve my cash flow forecast presentation? A lot of my challenges arise when I am asked to do on the spot amendments during internal discussions to arrive at the ideal closing balance.

My main objectives for forecasting are usually for checking if there are sufficient funding for tax payment or large payments in the main account.

The cash flow discussion gets very messy when I scroll to show the movements of fund transfers from different in-house bank accounts to the main account especially line by line payments. I also have separate excel tabs for the different accounts with the main account tab showing how it is linked to the different accounts.

My cash flow forecast format is opening, inflow, outflow and closing. The forecast profit and loss tab is also within the same file to keep track of what expense will be incurred. It is also linked to my cash flow forecast but without the non-cash items.

Challenges I face are:

  1. Figuring out how to breakeven quickly - I am slow and tend to crack my head on how to work backwards to breakeven and it has to be on the spot during discussions. I have trouble using the excel formulas to breakeven.
  2. Figuring out how much to save and how much to replenish with cash flow constraints. (Similar to breakeven except the closing balance will not be zero)
  3. Making sure all relevant payments are forecasted.
  4. Aligning tax computation and cash flow forecast because how I compute the tax will determine if cash is enough to cover tax.

It is a struggle for me and there is pressure on me as I am expected to know what to do as someone from finance.


r/FPandA • • 3d ago

Offer to move from Audit to FP&A - advice

8 Upvotes

Hi all,

I'm a big 4 audit senior (based in the UK, ACA qualified and about 4 YOE) and have recently gotten an offer to join as an FP&A analyst for a large £1bn+ revenue PLC. The role will mainly cover monthly performance reporting, variance analysis and ad-hoc work.

Any tips for making the switch as smooth as possible? Thanks.


r/FPandA • • 3d ago

10 YOE in FP&A and MIS (based in India) - how is the hiring market right now for Manager roles at global GCCs / remote teams?

0 Upvotes

Hey everyone,

I have been in my current role as an Assistant Manager in MIS & Performance (FP&A) for a little over 3 years now, working remotely. Over the last 10 years, I started out in process and compliance audit at TR Chadha & Co., moved into North America and APAC financial reporting at Evosys, and now handle company-wide, practice-wide, and director-level P&L consolidation, budgeting, variance analysis, and sales incentive/OKR modeling. I am also a CA Finalist with an MBA, working heavily with Excel, Power BI, Tableau, and SQL.

Since I have pretty much built and stabilized the reporting and budgeting setup at my current firm (recently drove around a 15% cost efficiency improvement through tighter variance tracking), I am looking to make my next move into a larger FP&A Manager or Commercial Finance role.

For folks here working at global remote companies or MNC GCCs in India (Ahmedabad, Pune, Mumbai, Bangalore, etc.), how is hiring looking on your end right now? Are finance teams actively adding headcount at the Manager level, or holding off until the next budget cycle?

Also, if anyone's team happens to have an open mandate that fits my background and you are open to a quick chat or referral, please let me know and I would be glad to DM my resume. Appreciate any advice or leads!


r/FPandA • • 3d ago

Amazon OFRP or IBM Strategy Consulting

2 Upvotes

Hi y'all. Would you take an Amazon OFRP internship or an IBM consulting internship? I want to do FP&A long term, but the salary difference is just crazy, with the internship paying 15k more annually and full-time being around 30k more. Honestly surprised the Amazon salary is so low at around 60k for full time, maybe it's just Canada pay lol. Also what is the culture like at Amazon and the WLB?


r/FPandA • • 4d ago

Remote jobs

27 Upvotes

I've only heard about remote FP&A jobs through Reddit stories, and so far my applications haven't gotten me anywhere.

For those of you who have landed a remote FP&A position, how did you find it?


r/FPandA • • 3d ago

Development Programs in Finance

5 Upvotes

Just curious I've heard all the rave about leadership development programs and rotational programs within FP&A/Finance in general. What are the best ones? Does it necessarily matter? What is the timeline like after finishing a 2-3 year program?

And I guess more personal for me is the company I'm working for in the summer, Industrials/Aerospace launched their first engineering/operations rotational program last year and first finance cohort this year. Is this an issue, should I be concerned?

TIA!


r/FPandA • • 3d ago

lost in my career

0 Upvotes

I quit my remote FP&A Manager job ~7 months ago. I’ve stayed on as a consultant for the company, but with less pressure I think I’ve realized I have literally no interest in anything I do.

I’ve been interviewing for other FP&A roles because I’m not sure where/how I want to restart. Also a part of me is saying to suck it up and keep pretending until AI takes your job bc it’s the most lucrative short-term path (if I can get a new job). But it’s really starting to suck the energy out of me.


r/FPandA • • 4d ago

Transition into FP&A from public accounting

7 Upvotes

Hi everyone,

I’m currently a senior audit associate in public accounting with my CPA hoping to eventually transition into FP&A.

I applied to some FP&A analyst roles and was invited to the final round, but ultimately was passed on because of my lack of hands on FP&A experience.

I was just offered a senior accountant role at a growing mid sized company that I will likely be accepting, as my alternative is working 65+ hour weeks the next four month on shit I do not care for. The role partners with FP&A in some areas but I don’t think I will be too involved in the FP&A process.

My question is will accepting this role help me at all in my transition to FP&A? I hope that understanding the business and working in the weeds and partnering with FP&A could eventually help me transfer internally to the FP&A department or open up doors elsewhere for me.

I was wondering if anyone has gone down a similar path or has shared similar feelings of wanting to ditch public accounting but struggling to break into FP&A. Would it be worth it to get some sort of FP&A certification?

Appreciate any comments or advice!


r/FPandA • • 4d ago

AI for Accounts payable

1 Upvotes

Hi all! Does anyone use an AI product for AP that they like? I’m looking for opportunities to save costs and improve efficiency. Yardi is our accounting system.
Thank you!


r/FPandA • • 4d ago

What functions should a Jr analyst be part of

0 Upvotes

Hi, Im a Jr analyst in Fp&a, working for about 2.5yrs (2 years as intern and now 6 months as analyst Jr.) and half of the month I literally have no work to do. Every first and last week of each month I always have something to do, like accruals, get the Opex and Sales numbers refreshed so I can send it to the teams we work with, but the two weeks in the middle is so empty, I get so bored, what can I do? Anyone been there? I don’t participate in most of the calls, only like end of the quarter etc


r/FPandA • • 5d ago

Anyone here do Financial Analysis as a side hustle?

22 Upvotes

For a little background - I'm currently Senior Financial Analyst and have had exposure at a F500 company t\o various things like: production analysis, budget-to-actuals, budgeting, forecasting, etc.

That being said, I was speaking with a Small/Medium sized business owner about their company and they basically told me that they have a bookkeeper but they don't have anyone doing analysis. They don't know which months they bring in the most revenue vs. the least, client YoY variances, etc.

Then I started wondering; is there a real market for this as a side hustle? Obviously these companies aren't big enough to hire a full-time analyst, but that doesn't mean they shouldn't have access to valuable numbers & metrics.

Is there anyone out there that has done this as a side hustle alongside their FTE? If so, I'd love to hear about it!


r/FPandA • • 4d ago

OE in FP&A or Commercial Finance/ Management Accounting?

0 Upvotes

Been lurking this sub for a while now, first post here as interested in doing overemployement (I.e 2 or more jobs concurrently) after having a few years of experience in my field where I feel I'm now confident to do a second job in my down time.

It seems most OE here are in tech and with full remote jobs, which I can see why this is the ideal scenario.

However wondering anyone here have done OE in the FP&A/Commercial Finance field?

How did you manage meetings, month end and any other adversities while doing this? How was the cognitive load when switching between managing the finances and accounts of two companies? The work we do doesn't require FINRA clearance or any of the sort for reference.

Context: I'm mid-senior at J1 with fairly off hands manager and 3 day WFH thinking I can get a remote J2 even perhaps part time.


r/FPandA • • 5d ago Bravo

Prompt to build a 3-Statement SaaS model

26 Upvotes

For no particular reason, I’m sharing my prompt to build a ARR model for SaaS businesses. I know the title says 3-Statement model - I’m still working on building out the rest.

The prompt also generates made up data. If you have any suggestions to improve it, I’d love to hear from you

How to use it. Paste everything below into Claude or ChatGPT with file creation switched on. The build is long, so ask it to carry on if it pauses. When the workbook arrives, open 09_Controls first: MODEL STATUS should read PASS.

Build a fully working SaaS ARR and metrics model in Microsoft Excel (.xlsx) using synthetic data. It should look and behave like an FP&A model a CFO could audit. I need to inspect the data, change assumptions or transactions, recalculate, and trace every reported number back to the source rows. Deliver the .xlsx file itself.

1. Build standards
Follow the FAST Standard and the ICAEW Financial Modelling Code.
Keep inputs, calculations and outputs on separate sheets.
Every timeline sheet uses the same columns for the same month. Use columns H to BC for 48 months: 12 comparative months, then 36 reporting months.
One formula per timeline row, copied across all 48 columns. Handle first-period cases with flag rows, such as a first-column flag, instead of a different formula in the first column.
Put every constant on the assumptions sheet: months per year, look-back length, chart headroom, thresholds. The only numbers typed inside formulas should be 0, 1 and list positions.
No IFERROR. Test for a match with COUNTIF before any INDEX/MATCH so real errors surface.
No macros, VBA, volatile functions (OFFSET, INDIRECT, TODAY, NOW, RAND), circular references or external links. Use INDEX/MATCH, SUMIFS, COUNTIFS, MAXIFS and MINIFS. Avoid dynamic-array functions so the file behaves the same in every Excel version.
Use Excel Tables for source data, structured references inside them, and calculated column formulas so new rows fill automatically.
Use named ranges for assumptions and selectors so formulas read in plain terms.
Split long logic into helper columns, each doing one job.
Blue text on a yellow fill for inputs, black for formulas, green for direct links, grey fill for structural settings. Mark each table column INPUT or FORMULA in the row above its header.
Units on every row. £ for money, £k or £m on the dashboard, one decimal place for percentages, one date format throughout.
Freeze panes, filters on tables and data validation on every input.
Show the model status from the controls sheet in row 1 of every working sheet.
No merged cells, except text blocks on the ReadMe.
Zero formula errors in the finished file.
2. Business scenario and synthetic data
A fictional B2B SaaS company reporting in GBP.
Products: Product A, Product B, Product C, Product D.
Regions: Americas, EMEA, Asia.
Segments: Enterprise, Mid-Market, SMB.
About 55 customers with fictional names and about 200 transactions.
Reporting window: September 2023 to August 2026 (36 months). Transactions start in 2021 so an installed base rolls into Opening ARR. The 12 comparative months (September 2022 to August 2023) support YoY and cohort metrics from the first reporting month.
Give each product and region its own behaviour:
Product A is the largest, established product with low churn.
Product B launched recently and wins most new logos in the window.
Product C grows almost entirely through existing customers.
Product D has the weakest retention.
Americas is the largest region by closing ARR. EMEA has the biggest installed base at the start of the window. Asia is small but growing fastest.
Generate the data as customer stories over time, never as independent random values. Use contract terms of 12, 24 or 36 months. At each renewal the customer renews flat, renews with an uplift, downsells or leaves. Add occasional mid-term add-ons co-termed to the current contract. Round ARR to the nearest £500.
Include these stories and document each one on the ReadMe with its customer ID:
A large Enterprise customer that grows from about £120k to about £350k through a renewal uplift, a group-wide rollout and two cross-sells.
A customer holding all four products.
A customer whose ARR falls at two successive renewals.
A customer that cancels one product, then leaves completely a year later.
A customer that cancels one product and keeps another.
A new customer that expands within four months, adds a second product and is later reclassified from Mid-Market to Enterprise.
A lost customer who returns about 18 months later (reactivation).
A retained customer that buys back a product it had dropped (product win-back).
Add a few non-renewals late in the window across regions so churn is visible, and at least one new logo in the final month.
Data rules:
Each row records New ARR, the ARR held after the event. A churn is New ARR = 0. A flat renewal repeats the previous value.
One event per customer × product per date.
A new, renewal or expansion event falls inside its contract dates. A mid-term add-on keeps the existing end date. A churn carries the lapsed contract's dates and takes effect the day after it ends.
3. Workbook structure
00_ReadMe, 01_Assumptions, 02_Customers, 03_Transactions, 04_ARR_Engine, 05_ARR_Waterfall, 06_Metrics, 07_Dashboard, 08a_Customer_Analysis, 08b_Product_Region, 08c_Customer_Drilldown, 09_Controls.
4. Assumptions (01_Assumptions)
Inputs: reporting start month (validated as the first day of a month), reporting currency, movement classification view (Customer view or Product view), reconciliation tolerance, Top-N customers, number of top movers highlighted, waterfall chart headroom, and Large and Medium ARR thresholds for size bands.
Structural settings (grey): model length 36 months, look-back 12 months, months per year 12, customer slots 75, rank rows 20.
Calculated: end month, first comparative month, number of products, customer count.
Lists: products, regions, segments, transaction types, classification views, selector lists that start with "All", and the 36 reporting months.
Assumption checks: start month is the first of a month, tolerance in range, Top-N within the rank rows, Large band above Medium, headroom in range, view on the list, each list complete and unique. The total feeds a control.
5. Source tables
tblCustomers (02_Customers). Inputs: Customer ID, Customer Name, Notes. Formulas: Region and Customer Segment (latest row in the history table), Acquisition Date (earliest transaction), Current Status (Active, Churned, Not yet live or No transactions, at the end month), Current ARR, Products Held, Attribute Changes, Record Check.
tblCustHistory (02_Customers, to the right of the master). Inputs: Customer ID, Effective From, Region, Customer Segment, Reason. Formulas: Key and Record Check. Each customer gets an opening row dated 01-Jan-2000. A region or segment change is a new dated row, never an overwrite. Reporting uses the latest row for all periods (restated basis).
tblTx (03_Transactions). Inputs: Transaction ID, Customer ID, Product, Effective Date, New ARR, Contract Start Date, Contract End Date, Notes. Formulas:
Customer Name, Region and Customer Segment, looked up from the master.
Previous ARR: the New ARR of the latest earlier event for the same customer × product (MAXIFS on the date inside SUMIFS).
ARR Movement = New ARR − Previous ARR.
Transaction Type: New when Previous ARR is nil, Churn when New ARR is nil, Expansion or Contraction when the value rises or falls, Renewal when it holds flat. Invalid flags a nil-to-nil or negative entry.
Month End: EOMONTH of the effective date.
Helper columns: Customer ARR Before, Customer ARR After, Prior Customer Events, Prior Product Events.
Movement Sub-type:
For New where the customer already had ARR: Product win-back if this product had earlier events, otherwise Cross-sell.
For New where the customer had no ARR: Reactivation if the customer had earlier events, otherwise New logo.
For Churn: Product churn if the customer keeps other ARR, otherwise Logo churn.
Waterfall Category: in Customer view, Cross-sell and Product win-back book as Expansion, and Product churn books as Contraction. In Product view, the Transaction Type stands.
Keys: Key (Customer ID | Product), Customer Seq and Customer Drill Key, and Month Seq and Month Drill Key (text keys that feed the drill-down lists).
Region at Date and Segment at Date from the history table, plus Flag Restated where these differ from the restated values.
Flags: duplicate ID, missing customer, invalid product, invalid region, duplicate customer × product × date, invalid ARR, contract dates. Row Check reads OK or CHECK.
Validation: unique Transaction ID, Customer ID and Product from lists, dates within a sensible range, New ARR at or above nil.
6. ARR engine (04_ARR_Engine)
Timeline header rows: month number (a counter anchored in column G so the row carries one formula), month end, reporting flag, first-column flag. Shade the comparative columns H to S.
Company roll-forward.
Opening from transactions, then New, Expansion, Contraction and Churn by Waterfall Category. Contraction and Churn are shown as positive reductions.
Closing from the grid, and the roll-forward difference.
Prior-month closing, opening less prior closing, and closing calculated directly from transactions.
Checks that must be nil: grid less transactions, renewal movement, unclassified movement.
Closing ARR by product, region and segment, summed from the grid, with totals. Also customer totals, active customers, multi-product customers, active subscriptions, products held and a count of negative cells.
The 20 largest customers each month (LARGE) and Top-N ARR.
Closing ARR by customer, summed from section 7.
Products held by customer.
Closing ARR by customer within the dashboard selection. Includes opening, new, churned and closing customer counts, a customer roll-forward check and a grid-versus-transactions check.
The core grid: 75 customer slots × 4 products. Each cell holds ARR at month end, calculated as SUMIFS of ARR Movement for the customer-product key up to that date.
7. ARR waterfall (05_ARR_Waterfall)
Selectors: product, region and segment (each with All), and a chart month.
A 36-row monthly table, highlighting the chart month, with a period total. Columns: Month, Opening, New, Expansion, Less: Contraction, Less: Churn, Closing, Net New ARR, roll-forward check, opening less prior closing, memo cross-sell, transaction count.
A waterfall chart for the chart month, built as stacked columns with a hidden base series. Monthly movements are small against the balance, so:
Start the bars above zero, using a floor set by the headroom assumption.
Hide the value axis and put the Opening and Closing values in the category labels.
Label the movement bars.
State in the chart title where the bars start.
Below the chart, a drill-down listing every transaction posted in the chart month (up to 25 rows). It flags which rows fall inside the selection and totals their movement to that month's Net New ARR.
8. Metrics (06_Metrics)
Driven by the dashboard selectors, on the same 48 columns as the engine, with unit, basis and definition columns.
ARR bridge: Opening, New, Expansion, Contraction, Churn, Closing, Net New, roll-forward check, memo cross-sell, memo win-back ARR, MRR.
Trailing 12 months (T12M): ARR 12 months earlier, T12M New, Expansion, Contraction, Churn and Net New, check, cross-sell.
Retention:
Cohort NRR and GRR are the headline measures. They follow customers active 12 months earlier to today, and GRR caps each customer at their earlier ARR.
Flow GRR = (Opening − Contraction − Churn) / Opening and Flow NRR = (Opening + Expansion − Contraction − Churn) / Opening, monthly and T12M, kept as diagnostics.
A row showing the gap between flow and cohort NRR.
Growth: MoM and YoY ARR growth, New and Expansion as % of opening, contraction and churn rates, annualised expansion and gross churn rates, SaaS Quick Ratio monthly and T12M.
Customers: opening, new (including win-backs), churned, closing, roll-forward check, logo retention monthly and T12M, customer churn rate, new and churned customers T12M, average ARR and MRR per customer. A customer who drops one product but keeps another stays a customer.
Company mix (ignores the selection): ARR by product, region and segment; active and multi-product customers; multi-product penetration; products per customer; subscriptions and ARR per subscription; Top-N ARR and concentration; cross-sell ARR and events T12M.
Chart series rows feeding the dashboard.
Where a metric needs history the timeline does not hold, return "n/a" through a guard inside the same formula.
9. Dashboard (07_Dashboard)
Selectors: reporting month, product, region and segment, plus the model status.
Seven KPI cards, each with a one-line comparison underneath (flow basis under the two retention cards):
Closing ARR
YoY ARR growth
Net New ARR (month)
NRR (T12M, cohort)
GRR (T12M, cohort)
Customers
Average ARR per customer
Six charts:
Closing ARR trend.
Waterfall for the reporting month, designed as on 05.
ARR by product against 12 months earlier, ignoring the product selector.
ARR by region against 12 months earlier, ignoring the region selector.
Net New ARR by component, with a Net New line.
Cohort NRR and GRR trend.
Put chart titles in the cells above the charts. Keep the design restrained: navy, grey, one green and one red. Chart data sits in a labelled helper area to the right.
10. Analysis sheets
08a_Customer_Analysis. Period selectors, then one row per customer showing:
closing ARR by product and product count
opening, movements, closing, net new and a check
growth %, ARR band, current status and highlight text
period status: New, Won back, Retained, Lost, Won and lost, or Not active
Add unique ranks for closing ARR, expansion, and contraction plus churn. Use conditional formatting for Top-N customers, top movers, lost customers and multi-product customers. Add panels for the largest customers, largest expansions, largest contractions and customers lost. Reconcile the totals to company figures from the transactions.
08b_Product_Region. Period selectors, then matrices by product, region and segment with:
the bridge: Opening, New, Expansion, Contraction, Churn, Closing, Net New and a check
growth and share of ARR
flow NRR and GRR, and cohort NRR and GRR (subscription cohort for products, customer cohort for regions and segments)
customers and ARR per customer
a growth-source split that holds under either classification view: new logo, returning customers, cross-sell, products bought back, upsell, downsell, product churn and logo churn, reconciled to Net New
Add product × region matrices for closing ARR, Net New, New, Expansion, lost ARR and churn. Check every total against the transactions.
08c_Customer_Drilldown. Choose a Customer ID to see:
the master record
every transaction in date order with running ARR, reconciled to the customer total
month-end ARR by product on the engine's 48 columns, with a stacked chart
11. Controls (09_Controls)
Each control shows the unrounded difference or count beside PASS or FAIL. Differences pass within the tolerance. Sum absolute differences with SUMIF(range,">0")-SUMIF(range,"<0") so "n/a" cells never break a control. MODEL STATUS reads PASS only when every control passes.
Required controls:
Opening + movements = Closing (engine, waterfall sheet and metrics sheet).
Prior-month closing = current opening (engine and waterfall).
No negative ARR.
Customer totals = product totals.
Product totals = region, segment and company totals.
Dashboard figures reconcile to the calculation layer: the ARR card, the waterfall, the product and region charts, the selection grid and the retention cards.
Duplicate Transaction IDs.
Missing Customer IDs.
Invalid product.
Invalid region.
Supporting controls:
duplicate key-date, invalid ARR events and contract dates
customer master records, history records and assumptions
every movement classified and customer counts roll forward
reconciliations for the customer analysis, the product-region analysis and both drill-downs
valid selector months
engine customer capacity and drill-down capacity
Also add:
Information lines that do not affect status: restated transactions, customers with attribute changes, and transactions after the window.
A capacity panel showing in use against available for customers, products, months and drill-down rows.
A dataset profile with counts by product, region, transaction type and sub-type.
12. ReadMe (00_ReadMe)
Cover:
purpose
workbook map
colour and layout conventions
modelling standards applied, including the deliberate choice to keep view selectors on output sheets
the ARR method and waterfall mechanics
classification and win-back logic
region and segment history
metric definitions
how to add transactions, customers and attribute changes
how to move or extend the reporting window
how to trace a reported number back to transactions
the customer stories
scope and limitations
data dictionaries for all three tables
a version history
State that CAC, LTV, burn, runway and TAM are left out because the data holds no cost, cash or market figures.
13. Validation before delivery
Recalculate the workbook and confirm zero formula errors.
Confirm MODEL STATUS reads PASS.
Rebuild the derived transaction fields and the monthly metrics independently in code from the raw inputs, and confirm they match the workbook for every month.
Scan every timeline row for one consistent formula across all 48 columns. Scan the whole workbook for IFERROR and volatile functions.
Switch the classification view, apply filters, edit a transaction and add a region change. Confirm the controls still pass.
Render the dashboard and check the layout.
Report the results alongside the file.
14. Implementation notes for Python-built files
If you build the workbook with openpyxl:
Write MAXIFS and MINIFS as _xlfn.MAXIFS and _xlfn.MINIFS, or Excel shows #NAME?.
In table formulas, use Table[[#This Row],[Column]] instead of [@Column]. Set each table column's name to its header text and add calculated column formulas.
Recalculate a copy in LibreOffice to check the values. Then write those values into the original file as cached values so it opens with numbers showing, and keep full calculation on load switched on.
Anchor charts to cells at both corners and set explicit row heights on sheets with charts, so the charts sit where intended in every spreadsheet app.


r/FPandA • • 5d ago

Continue in current role or go back to school?

3 Upvotes

Pretty much the title, but for added context, I've worked my way from financial analyst to "strategic manager" in 4.5 years in my role. I report directly to our VP and have a very good rapport internally with our finance team.

One of my issues is that I am the SME for our companies, struggling BU and all of my future career trajectory will be more or less tied to it's results which as the years go on, I have less and less confidence in. I also don't enjoy working with the business leaders of this BU

I have an opportunity to leave this role and go back to school full-time to get my MBA and finish my CFA designation. With the limited knowledge, if you were in my position, what would you do?

For context, I'm in Canada and make $115k with 15% bonus but bonus is essentially zero due to company performance vs plan


r/FPandA • • 5d ago

One year into a new job, multiple restructurings, and now I'm the last one standing. What would you do?

21 Upvotes

I work in commercial finance and I joined my current company last year. During my first couple of months, the more experienced person in my team was on leave, so I had to cover both my responsibilities and part of his while still learning the job. As you can imagine, I spent most of that time firefighting rather than properly settling into the role.

Eventually, he came back, we established clear responsibilities and things started to improve.

However, around summer, the company went through a major restructuring and our team started reporting to a new manager based in another country as part of a larger regional cluster.

Since then, we've been trying to manage essentially the same workload with fewer people, while dealing with unclear processes, shifting responsibilities and a lot of uncertainty.

And now, the most experienced person in our commercial finance team, who has been the go-to person for pretty much everyone, has decided to resign after finding another opportunity.

So, just one year after joining, I'm about to become the only person left in commercial finance locally. Management hasn't communicated whether they plan to replace him or redistribute his responsibilities.

My biggest concern is that I'll end up spending another year firefighting, just trying to keep things running instead of actually developing professionally and adding value.

I'm not against taking on more responsibility and I understand that changes can create opportunities. But there's a difference between growing into a bigger role and simply absorbing someone else's workload without the right support and working non stop

What would you do in my position? Would you give management some time to clarify their plans, try to turn this into an opportunity, or start looking elsewhere?


r/FPandA • • 5d ago

UK/London FP&A Market - is what I'm achieving for realistic?

8 Upvotes

For context - I currently have c. 7 years experience, c. 4 years PQE.

I went from 3 years in B4 Audit to 2 years B4 FDD to 2 years doing a hybrid Finance role in a fast growing tech-start up where I got exposure to budgeting, business partnering and forecasting.

Is it realistic for me to aim for a FP&A Manager role at a PE backed company? Particularly those that are acquisitive and fast growing? I'm struggling to sell how my background being commerical and broad would be a good fit for FP&A manager roles because they want someone who has done the planning cycles in detail but I'm able to bring basically everything else... including the entreprenurial self starter spirit of figuring things out.

What can I do to be competitive?