/r/FPandA

Photograph via //r/FPandA

A place to discuss all things about Financial Planning and Analysis (FP&A).


Welcome to: r/FPandA

A place to discuss all things about Financial Planning and Analysis (FP&A).


Discord Link: https://discord.gg/qHm4H6DhXV


Rules:

1) No low effort posts.

Share ideas and insights or ask thoughtful questions. Please refrain from posting generic news items.

2) Keep discussions civil, informative and polite.

Off topic comments, attacks or insults will not be tolerated. We recognize that this forum will generate differences of opinion, or misunderstandings of facts, and therefore arguments are expected. However, personal attacks, insults, trolling, or accounts dedicated to getting under the skin of others is not allowed, and will be banned.

3) Strictly no (self-)promotion or solicitation threads.

Violating this rule results in an automatic permanent ban. Do not post your YouTube, twitter, discord, app, tool, blog, referral code, event, survey, etc. We generally expect that people who come here are not using the forum to build a brand, generate clicks, or shill. Posts that are strictly self-interested or intended to "build awareness" are not acceptable.

4) Original Sourcing: articles posted must be from the original source on a best efforts basis.

This we expect you to post the original article. If anyone is writing an article based on a FP&A/Business news release/white paper post the actual paper and not journalism surrounding it.

Provide the link to the source article or paper.

This rule will be more strictly enforced based on how clickbaity an article is.

5) Ethics

While no advice or credentials of those giving advice have been verified or endorsed, any blatant violations of ethical rules are not tolerated.

6) No Spam

Repeatedly spamming the sub will lead to an permanent ban.


Recommneded Subs


Recommend FP&A Resources

  • American Institute of CPAs

  • CFA Institute

  • Management Accounting (CMA)

  • Healthcare Financial Management Association (HFMA)


  • Educational Resources

    /r/FPandA

    39,022 Subscribers

    2

    Booking EBITDA Adjustments

    Anyone have any recommendations for recording EBITDA adjustments?

    Currently we are managing with .csv files and PowerQuery to append our master record and plugging summary numbers in the main FS package. It works but is not a great solution long term.

    Has anyone had any luck recording adjustments to the GL or some other solution and how did you continue reporting on an unadjusted and adjusted basis?

    1 Comment
    2024/12/04
    13:13 UTC

    1

    How do I start learning SQL

    I want to learn the absolute basics, just enough to give me a boost when applying for internships. I have absolutely no clue where to start

    2 Comments
    2024/12/04
    11:54 UTC

    4

    Finance Data Analyst vs PwC Deals

    Hi all, I am starting my career. My goal is to become finance leader at MNC/CFO one day. I received 2 offers, what would be the best path (note: it's in Europe):

    1. Amazon - Finance Data Analyst
    • Job: I would be more like a support to FP&A team by creating data pipelines and dashboards (using SQL/ETL, Power BI, Excel, Power Query)
    1. BIG4 - PwC Deal Advisory
    • Job: I would work on M&A due dilligences, company valuations (DCF, multiples)

    What would be better for my career goal? ▪️ From my POV, Big4 position is more interesting to me because it is more finance role, while at Amazon more data analysis/BI. However 2 things:

    1. Salary: positions are in different countries, but at the end of the month, after covering all costs of living, I would be left with 1500eur if I go with Amazon, while 500eur if I go to big4
    2. Growth opportunities: not sure, I really hope I will be able to transfer internally at Amazon after 1 year to real FP&A with my data analysis skills.

    In case I go to big4, after max 2 years I would try to go to Amazon fp&a, but not sure about my chances then. Also then I would have experience for M&A/Corp development which could be useful maybe in my further career.

    My background: ▪️ 10mos of full time Deal Advisory analyst at EY TAS (M&A, Valuations) ▪️ 6mos of fp&a internship at Amazon ▪️Holding Master in finance

    3 Comments
    2024/12/04
    11:33 UTC

    1

    Reconsidering FP&A career path

    Hi everyone. I joined a 150 person startup almost 6 months ago and haven't really liked the job and considering next steps, and would love any guidance.

    Our finance team is currently my manager (head of finance), controller (along with an outsourced accounting team) and me as the FP&A person. I'm in charge of our consolidated corporate model, reporting/managing opex budgets for all our departments (15 departments) on a monthly basis, monthly financial reporting, quarterly board decks, supporting fundraising, etc. Our entire team is fairly new (we all joined this year), although I'm the most recent hire.

    I've done a number of different finance roles previously. I started in investing banking, been an investor at PE firm, an investor at a VC firm and then also corporate finance & strategy at a high-growth tech company (couple to few thousand). At my prior tech company, I didn't like how I spent so much time on consolidating and reporting, so decided to go to a smaller company where I thought I would be able to work on more interesting problems and have a more strategic role. However, that hasn't really been the case at my current company.

    In my current role, there's been a lot of focus on forecasting and making sure we hit our numbers, and a lot of emphasis on cost given cash is pretty tight. So I spend a lot of time on forecasting / updating our corporate model and also on reporting/reviewing opex for each department on a monthly basis. I've been working on automating opex reporting, but imagine there's still going to be a fair amount of work since expenses are often misclassified and need to be reviewed, etc. For modeling, I don't find it intellectually stimulating since it's just consolidating inputs from people. Overall, I find my role very boring and hard to stay engaged, even though I like the product/industry I'm in.

    I wish my role was more strategic and impactful, since I feel like I'm often just producing reports that people may or may not care about, or just continuously adjusting our model even though it'll be wrong anyway since we're a startup and things are constantly changing. Even though I work with every department across the company on opex/budget, I'm not working with a specific team day in and day out, and often feel like I'm just doing my own thing. I wish my role had more deep business partnership, and where I am adding value. I also miss having a team, and feel like it's been a pretty lonely role.

    I've really only enjoyed one project I've worked on where I made the business case for a new product and helped set pricing / cost guard rails. I wish I could work on more projects like this, but there doesn't seem to be as many of these projects. I've also talked to my manager about this", but nothing has really changed. And even if I had more strategic projects, not sure I would even have time to work on them, and we're not going to hire another FP&A person on the team for a while.

    I'm feeling a bit stuck about next steps and considering moving to a BU finance role at a larger company, or potentially a more strategy focused role like strategy & operations/bizops. However, have stayed away from bizops roles since I think these are often project based, so you're not often not build subject matter expertise, as you do in a finance role. Would love any guidance and thought from anyone who has been in a similar position!

    5 Comments
    2024/12/04
    03:22 UTC

    27

    FP&A Exit Opps

    Searched through some of the discussion on here but wanted to get people’s current thoughts on FP&A exit opps. Currently 4 YOE, all in comp ~$120k, sr analyst, supporting rev, BU and corporate FP&A at public SaaS. Generally like my job and good at it but it’s painstakingly boring.

    Anyone with experience exiting to IR or ERP/EPM implementation? Not sure what that experience or comp looks like. Thanks for the input!

    16 Comments
    2024/12/04
    00:23 UTC

    2

    Getting back into finance

    Hello I am 24 years old and have a finance degree. I worked in finance for 2 years and did not enjoy the companies I worked for and left them. I’ve been out of it for a year now and thinking of giving it another chance, but don’t know what I should be looking for. Also what should I be doing to get better at working in the finance field, so I actually know what I’m doing. Any suggestions or tips would really help me out!

    9 Comments
    2024/12/03
    23:15 UTC

    8

    Best career path to FP&A?

    Hi everyone,

    I'm a 23M living in NYC, I work as a Junior Financial controller consultant at a CFO as a service company making $75k fixed with around $15k-$20k bonus. I've been at the company for just over 1.5 years and the more I grow within my role and the more I want to be more FP&A and less accounting.

    I do a lot of bookkeeping and accounting work such as reconciling transactions and bank accounts, month end entries, updating AP and AR balances. I also update and analyze financial statements, which usually are consolidated with multiple entities (I work with both GAAP and IFRS entities). I've been doing more Business Plans and Cashflow forecasts lately which seem to be more interesting.

    I haven't really felt happy with this role as

    - the work is quite repetitive with monthly closings

    - the company size is quite small (less than 10 people all around the country)

    - I feel a bit alone in my role, (I am the youngest with the 2nd youngest being 30+)

    - we don't have a proper office in the city so most of our work is remote (I love the flexibility this job offers but I get bored working by myself)

    A new recruit just joined our company and she's a CPA, she's tried to convince me to get my certification as well but I would need to work for this company for another 2 years to fulfill the work requirements, get a master's degree (probably master of accounting), and pass all 4 exams.

    While I do think it would be possible for me to do all those things, it definitely would require a lot of work and time. I am hesitant to go through this path as I'm wondering if it would really be worth it for me or if I could progress without becoming a CPA.

    I guess what I'm wondering is:

    - How many years of experience would I need to go to a more in-house FP&A?

    - Should I stay in my current role and focus on getting my CPA?

    - I'm also wondering how my total compensation compares to others my age/in similar positions. Am I underpaid for this role (in NYC specifically)?

    Willing to answer any questions for more details, thank you!

    6 Comments
    2024/12/03
    18:56 UTC

    1

    Any Advice or Resources for Learning WinTeam as a Financial Analyst?

    Hi everyone,

    I’m about to start a role as a financial analyst at a company that uses WinTeam ERP software. While I’m familiar with general financial analysis, I don’t have experience with this specific tool and want to get a head start.

    If anyone has worked with WinTeam in a similar role or knows of good resources (training videos, guides, forums, etc.), I’d really appreciate any recommendations!

    Thanks in advance for your help!

    0 Comments
    2024/12/03
    18:34 UTC

    6

    What is the most common version nomenclature used in planning/forecasting?

    What has everyone seen as the most common naming conventions when memorializing forecast versions? Does "Plan" just allude to an annual exercise, or does it have more differentiators to monthly forecasts? I have historically used "QX Outlook" to reflect a quarterly formal forecast. In other companies I have seen more specific labels like 4+8, 9+3 forecasts.

    Curious what others have seen is most intuitive, user-friendly labels.

    15 Comments
    2024/12/03
    17:00 UTC

    0

    Pay

    Hi

    I’m currently working in accounts payable and I have 2 years experience. I come from commerce background (B.com) and also I’m about to complete my US CMA.

    So I’m planning to switch my job to FP&A as it interests me a lot. I just wanna know how much does they pay in the market approximately for my profile specifically on the details I mentioned above.

    I know it all depends on the skill and other stuff, but just to know what’s the current market compensation in India!

    9 Comments
    2024/12/03
    09:33 UTC

    27

    Salaries

    I already know the answer to this, but heck I’ll ask it anyway. I’m in a probably not uncommon position as a mom who left the workforce for 6-7 years and came back and I’m underpaid on base, but good bonus/ stock plan. Been at the same company for 7 years, what keeps me is WFH. Can you use the knowledge of everyone’s salary in the company to negotiate a raise? I know the answer, just thought it would be interesting to discuss.

    40 Comments
    2024/12/03
    02:48 UTC

    1

    Where to find model tests?

    I’m going be hiring for a senior analyst soon and I want to have an Excel or some other sort of screening test to gauge their level of expertise (asking for 2-3 years experience, ideally coming out of banking), but I don’t really want spend the time to make one myself. Are there any resources online where I can grab an example test and then modify it with made up data applicable for my company? I’m looking for something that’s medium complexity.

    7 Comments
    2024/12/03
    00:45 UTC

    12

    Looking for a job, I’ve applied for 50+ no interviews

    15 Comments
    2024/12/02
    22:23 UTC

    9

    Those that accepted relocation packages, any surprises/regrets?

    Title.

    I am being offered a relocation package from remote to hybrid and have some concerns of the following:

    • Hybrid could lead to fulltime RTO.
    • Clawback provisions could keep me financially tied up with the company.
    • Feeling indebted to company/boss for my housing situation and that power dynamic.
    • Could result in higher expectation to maintain high-performance.

    Anything else?

    37 Comments
    2024/12/02
    22:03 UTC

    7

    Budget Season Blues? Join Our FP&A Discord Community!

    As you wrap up those year-end forecasts and start dreaming about goals and hitting those 2025 targets, why not connect with fellow FP&A professionals who get it?

    What you'll find:

    • Real-time advice on everything from complex Excel models to negotiating that overdue promotion
    • Salary insights from professionals across industries
    • Technical help for when Excel #REF! right before your budget presentation
    • A place to vent about last-minute forecast changes while everyone else is planning their holiday parties

    Plus, you'll meet finance professionals who understand why you're still staring at variance analyses at 9pm and won't judge you for getting excited about your three statement models tying out or XLOOKUP > INDEX MATCH MATCH.

    Join us here: https://discord.gg/SMvZtTFWmg

    1 Comment
    2024/12/02
    21:28 UTC

    5

    What the hell is book and burn

    Please see title. Disclaimer: I’m a college student doing an internship and I could never get a straight answer on this. Thank you in advance!!

    5 Comments
    2024/12/02
    21:06 UTC

    1

    FP&A in a Non-Profit?

    Hello,

    I'm a CPA with previous Big 4 experience, and am currently doing a MA in Public Policy. I wanted to transition into the international development sector, and was aiming for FP&A jobs in development agencies. I was introduced to the Director of Finance in a non-profit development agency, and am having a chat with her. They are hiring for FP&A positions and the level of experience they want is exactly what I have, so I'm planning to ask her about the position.

    However, I have a concern - when I was introduced to this Director, I was introduced as "having interests in both development project implementation and finance". These are two separate positions.

    My question is, what would be your concern about me if you were trying to hire? Will she think I'm not committed to finance and will jump to the business side as soon as as I get a chance, since I was already introduced as "having interests in both"? Also, I was working for the private sector, which is different from non-profit. What other concerns might she have, and what can I do or say during the chat to alleviate any concerns she might have?

    Thank you for your thoughts.

    5 Comments
    2024/12/02
    20:38 UTC

    0

    Where does one go to apply to financial management positions?

    Hello I’m a career changer starting my journey into the world of finance, my goal is to get a job as a financial manager, us news says there’s 120,000 projected jobs and salary’s around 150,000. My thing is where are the jobs I can’t find them? I want to start this career path but my goal is to get those substational salary’s of 150,000 plus, willing to do the work get the experience and get the MBA however that’s what I’m working towards and I can’t find them on the market.

    36 Comments
    2024/12/02
    19:37 UTC

    13

    How’s your Monday going? I’ve inadvertently embarrassed myself with a recruiter and a desired future company

    I recently reached out to several different recruiters I know work with a particular company I’d like to work with. This employer has various divisions based on different sites.

    With each recruiter I had an exploratory conversation and they had said they could reach out to the employer on my behalf (This is potentially where I mucked up) but to different divisions where they had contacts.

    Those conversations were early November and last week and I had heard nothing back from either.

    Today I received a slightly upset toned email from one of the recruiters saying a contact had had my details sent over several times already. The email implied this was a nuisance!

    I’m relatively inexperienced working with recruiters, and can’t help but feel a) I mucked up by not being up front re being in touch with several recruiters and b) disclosing that another recruiter had offered to reach out to other division on my behalf. It turns out that they had reached out to several individuals across multiple divisions, but hadn’t told me they were doing this (despite their good / money making intentions).

    So now I feel horrible embarrassment and that I’ve annoyed a potential(ly not any more) future employer and ruined a relationship with at least one of these recruiters.

    So how’s your Monday going?

    15 Comments
    2024/12/02
    19:10 UTC

    5

    Startup FP&A

    Have a relative who has started their own law firm in the past year or so. Was curious on what sort of insights an FP&A person provides in the start-up space. Anyone have any ideas?

    Right now want to look into some expense ratios and try to see if there’s any over spending that can be cut back, and run an analysis of a pretty important business partnership vs. going another route - which will be mostly me plugging assumptions. I’m in a completely different industry and relatively new (this is just a side project to help them out) so was looking for any advice or insights through the perspective of anyone else on here.

    7 Comments
    2024/12/02
    14:18 UTC

    2

    Seeking insights and opportunities in FP&A

    Hi everyone,

    I’m an international student in the US, currently pursuing a Master’s in Finance and Analytics, with graduation expected in mid-December. I have three years of experience as a Financial Analyst at Wells Fargo and am aspiring to transition into FP&A. I’m eager to learn more about the field and explore any paid/unpaid opportunities to gain practical experience. I’d greatly appreciate any insights or advice.

    Looking forward to hearing from you

    3 Comments
    2024/12/02
    09:20 UTC

    7

    Resume - size of business

    I work for a listed company. I am finance lead of its two verticals in one geography. If i write the size of business along with vertical names would i be breaking the confidentiality as my resume would be circulated with peer companies and they would know the size of our business? Or is it common practice and everyone (business ppl, Ops folks and finance) mentions it.

    4 Comments
    2024/12/02
    04:21 UTC

    3

    Getting Operations Buy-in

    Looking to grab some advice. Currently a SFA at $250mm top line business. My role has straddled financial reporting and analysis - with most of my tenure in role focused on reporting.

    Company operates nationally across Canada - more than 30 operating locations. Our business has never historically had any commentary from our branches on monthly results / variances / etc..

    We recently transitioned to a live data pond and can reflect real time sales / margin / opex for branch level P&L. How can I get buy in from operations to start hearing their comments (proactively) without having to hunt down branch managers for commentary on sales misses / opex misses?

    3 Comments
    2024/12/01
    22:30 UTC

    16

    Stability vs Salary/Career Advancement

    Hi all, I am facing a bit of a professional dilemma and wanted to seek out some of your input. I will be cross posting to other finance career pages as well to collect perspectives. Throw away account for obvious reasons.

    I have a very comfortable job with incredible stability and security. Pay is decent for my area (low COL), the industry is fairly niche and my experience even more so. Sitting at 110 base, 18% discretionary bonus bringing me up to 130 TC. I am tied in directly to one of our business units and am a finance business partner to both sales and operations.

    I may have an opportunity to go to a Seattle based Mag-7 company for a corporate FP&A role. The role pays 190 TC, 130 base and 60 RSUs. The COL in Seattle is much higher than my current area, so it is not a clear 60k raise, but it is still an income improvement.

    A co-worker put it nicely when he mentioned to look at where each job leads as next steps. My current job is a career job; I can coast this for 30 years and move up slowly to director and then eventually senior leadership. But I imagine a few years of Corp FAANG FP&A would open doors also that may lead as high or higher?

    Any feedback from others who have been in a similar position would be amazing. If more info is needed to clarify on anything ask away.

    14 Comments
    2024/12/01
    20:40 UTC

    13

    What does a good balance sheet reporting package look like?

    First role I've been in where I have responsibility for the full balance sheet...here's what I have so far:

    • 13 month Rolling Balance Sheet

    • Aged AR/AP/Received not vouchered

    • Aged Accrued Expenses

    • Inventory Analysis with turns by product category

    • CIP Detail with ITD spend versus budget

    We are a large distributor, inventory is the biggest number, fixed customer base, point in time revenue.

    6 Comments
    2024/12/01
    18:35 UTC

    1

    How often are there business re-orgs at your employers on average?

    Title.

    Been at company for ~3 years and there's been a re-org for largest business each year so far. This isn't just shifting one exec for another but a always been more of a larger shift (changing how the regions are looked at historically, how the responsibilities shift, etc.)

    Company came to be through a series of mergers in mid 2010s. PE saddled company with debt and took it public and exited. Debt maturity in a few years. Company was in red last year, should be profitable this year (just barely).

    On finance side, there's not much of a change from these re-orgs. Some slight changes in who covers what but nothing major for most part. (only one FTE had a change in direct manager), VP/CFO has been around since at least 2019.

    View Poll

    0 Comments
    2024/12/01
    18:18 UTC

    95

    P&A vs. Accounting: How are they different?

    26 Comments
    2024/12/01
    13:57 UTC

    6

    Social media presence in Fp&A

    I’m trying to break into a financial analyst role, currently I’m finishing school and I work with a local public access tv show with a show about finance, teaching people about personal finance. Someone has came to me with a proposal to advertise a Christian clothing brand. Which I would support on the show and on social media. If my employer saw this, would this be the type of thing to prevent me from getting a job? I know employers want us to have neutral social media presences. Should I decline the offer.

    19 Comments
    2024/11/30
    19:29 UTC

    18

    What next after Head of Finance role?

    My background is audit -> fp&a analyst -> head of finance now at this start up, responsible for all areas of finance (control and planning) and have one member of qualified staff (ACA/CPA) and two bookkeepers below me.

    I’ll probably be here for the next year honing my data skills in terms of the 3 statement modelling and boosting my data manipulation pieces. But what’s the ideal next role. It’s been a pretty intense start and been here for 3 months. I know I could get a more cushty job once I switch back to a larger gig but mainly came here for the exposure and chance to learn first.

    It’s not really big enough to have financial analysts or a separate fp&a department (£5m turnover or so…) TIA

    19 Comments
    2024/11/30
    18:35 UTC

    Back To Top