FP&A


  • Using VBA Macros In Excel Financial Plan Model?

    I have been asked several times over the last few months as I interview for jobs where preparing financial planning models is part of the job description whether I use macros in the models I have built.  Although I know how to use macros and even know how write macros using the visual basic editor …

  • What is the best ERP software for a small to medium size business?

    To add a little detail, we're a $6 million home services small business that is going to become a medium size business by the end of this decade. We're fairly early in the research and selection process. On criteria for "best erp software," our goals are: - Easier to implement - Easier to use from…

  • Fundraising Finders Fee

    I am trying to find out what the standard finders fee might be for fund raising in the range of $1M to $5M. Can anyone tell me what current market rates for fees might be please. Thanks!

  • Employee FAQ's for Acquisition

    Does anyone have a template of FAQ's that can be used in addressing employee questions after an acquisition?  I cannot locate the list I formulated years ago. Any assistance will be of great help. Regards... Rick

  • What are good KPI's/metrics for measuring performance of the FP&A group? (Webinar Attendee Question)

    This question was asked by an attendee during the Proformative webinar “Finance Transformation: Essential Elements for Driving Success" held on February 27, 2013.  Please join the discussion and add your insights below. A video of the webinar can be viewed here: https://www.proformative.com/resou…

  • I am trying to set up process to reconcile credit cards

    I just want a system that will match receipts with credit card transactions from purchasing card. We don't have any travel reimbursements, everything is on card. Is there a way to upload credit card transactions, batch by card (employee) then send report for the employee to expense and attach credi…

  • How To Improve Travel Management & T&E Expense Process

    We are a medium sized technology company with offices across three continents.  We have about 60 regular travelers globally and USD $1.5MM annual T&E budget. Right now we are using internal resources to manage travels, i.e., looking for best fare, booking flight & hotels through two to thr…

  • What is your normal turn around time for an Employee Expense report?

    What expectations do you have at your company/firm to turn expense refunds? Currently we pay employees back through payroll so we give a deadline of 5 days before payroll to get expense reports in. However we are discussing going to a weekly ACH run for reimbursements. I'm trying to determine what …

  • What determines your rates when you're working "on a retainer" with a client?

    I've done work on retainer before, but it's time to update how I do this.  Especially since I have clients who are being asked to provide clients with retainer fees.  I'd love to learn how others determine their rates when they're working "on retainer" with a client.   Also what problems you've had…

  • Is it legal to bring on an employee for commission only?

    We are looking to bring on a sales leader for commission only. That is, if it is legal to hire someone for only sales percentage (and stock options). Is there any issue with that? CA resident, by the way.

  • Quality Of Earnings Report

    We have a PE firm asking for a "quality of earnings" report or analysis. Is their a standard form or template for this?

  • SG&A comparables as a percentage of net sales

    My company is going thru a "right-sizing" exercise and we are looking for updated benchmarks for IT, marketing, finance and HR spend as a % of net sales.  I know that this is oversimplifying but would like as many sources as possible when I present to the team. We are a US distribution company, abo…

  • What are the typical KPI used for the Treasury & Tax ?

  • Anyone willing to share intercompany loan agreement?

    In need of a simple loan agreement to cover excess funds advanced to the parent company. Terms are open ended, no repayment terms defined. I appreciate anything you are able to share.

  • Zero-Based Budgeting Case Studies

    Hi all. I am looking for good case studies or books about zero based budgeting. It has been profiled as one of the secrets of success of Jorge Paulo Lemann (Ambev beer, Burger King, now Heinz in partnership with W. Buffett) and all I find is a book from 1973 on amazon and some very superficial arti…

  • Budgeting and Forecasting

    I am looking for budgeting and forecasting guidance on how to budget an income statement, balance sheet and prepare a cash forecast. I just started my job and need to put together some numbers pretty quickly. How often do you update the cash forecast?

  • New SaaS Startup - Help determining best commission structure

    The main solution is a SaaS based solution that ideally the company wants to sell a minimum one year deal, but would accept a month to month if needed to close a deal and as they grow. A maximum deal would be three years in length. So based on that background what are your thoughts on a fair compen…

  • Why be anonymous on LinkedIn?

    For people who spend too much time on LinkedIn like myself it's always interesting to see who visit's your profile however a significant part of the visitors choose to be anonymous. Why is that and who are they?

  • Accounting For Put Warrants

    My client issued put warrants in connection with a loan agreement.   My question is 1) what the initial journal entry would be on the issue date of the warrants and 2) what the journal would be when the Holder exercises the right to require my client to purchase the warrants in the amount of the Bu…

  • CFOs Get the Darndest Expense Requests

    There was an article in the WSJ with this headline. Now that April Fools is over, I thought it may make a good question with a lot of room for levity. Sooooo, what's the most bizarre reimbursement request you've seen?

  • Do you bill travel expenses incurred before travel is taken?

    Our client requires us to travel across the country to their site about every two months. Since we bill monthly with Net 30, we sometimes have to book and pay for travel before taking the trip. The service agreement just says we will be reimbursed, there are no details, requirements, or restriction…

  • Where To Find a Honest / Eligible Finder's Fee For Fundraising

    Hello, Sorry for the Anonymous post.. I'm trying to find a Finder's Fee-based person who might help with finding investors for a Startup I'm in. If you have one you can share from your personal experience please message me via Proformative's direct messaging. Is there a publicly available list for …

  • How To Forecast Headcount & Salary

    Wanted to get your thoughts on how your company approaches budgeting and forecasting for headcount/salary planning. At our company we forecast Authorized headcount, attrition/vacancy and calculate a net headcount for each department in each month of the forecast. We have 65 departments, 980 net hea…

  • One bank account two companies (INC & LLC)

    Hi all, I'll try to explain the situation where I'm the best I can... We've two companies in the USA one is an INC and the otherone a LLC. INC is 100% owner of the LLC and for fiscal/taxes issues they work on a consolidated basis, both under the same umbrella. Now, we'll close the LLC bank account …