Big News: FounderDating is joining OneVest to build the largest community for entrepreneurs. Details here
Latest Notifications
You have no recent recommendations.
Name
Title
 
MiniBio
FOLLOW
Title
 Followers
FOLLOW TOPIC

Question goes here

1,300 Followers

  • Name
    Entrepreneur
  • Name
    Entrepreneur
  • Name
    Entrepreneur
  • Name
    Entrepreneur
  • Name
    Entrepreneur
  • Name
    Entrepreneur
  • Name
    Entrepreneur
  • Name
    Entrepreneur

Looking for financial forecasting/modeling tools and CFO types

I am reading a book called "Growing Pains" and it talks about staying out in front of infrastructure needs as you grow. Unfortunately, I find myself in between systems where I have an accountant, a book keeper, quickbooks, and excel charts all trying to reconcile with bills, invoicing, accounts, etc. Does anyone know one tool that can pull it all together and report all the numbers an executive needs to see a year or more into the future without having to build 20 excel spreadsheets, pay thousands of dollars for an "enterprise solution", or hire 6 different people?. I literally had a CPA tell me yesterday "no one has ever asked me for that". Sounds like we should build it! I know these tools must already be out there. Does anyone know about them or have recommendations? I want to track contracts, invoicing, employee cost, profitability, and forecast into the future to see how different scenarios play out for infrastructure buys, strategic hires, new offices, etc. I know excel can do it but that is far too much work to maintain. Also, I'd like to chat about when its appropriate (size-wise) to bring in a CFO type or start getting consulting guidance on CFO-type support. There must be a critical mass you can anticipate for this. Thanks!!

5 Replies

Rob Gropper
0
0
Rob Gropper Entrepreneur
Director at PetHero, SPC - Member at Eastside Incubator - Principal at Tuxedo Technologies Group
Eugene, gearing up for that ourselves so i'd be interested in the feedback. quickbooks will likely be the primary data store. I suspect there is an ecosystem of add-on QB apps that can address much of this. i would have to think there are plenty of bean counters out there who have crossed this same path many times. maybe a contract CFO would be a good place to start.
Nick Amabile
0
0
Nick Amabile Entrepreneur
Data Analyst at Etsy
Hey guys.

I've worked in finance and operations for two eCommerce companies and worked in consulting as a data analyst. I've faced similar problems where data is spread across disparate systems making a high-level view of the business difficult.

Unfortunately, I don't know of specific tools that would aggregate data from accounting systems, customer databases, CRM, etc. In the past, I've built custom dashboard applications in addition to managing a collection of spreadsheets, SQL queries, and third-party reports.

In eCommerce this is maybe a little easier than in other industries since many of the tools we use have APIs to build on top of. It's also probably not cost effective to build a custom solution until you have well defined processes and metrics that you're already comfortable with.

For forecasting and modeling, I'm not aware of a better solution than Excel. The process is generally very iterative and qualitative, and Excel provides the flexibility to create models specific to the drivers of your business.

I would check outhttps://www.waveapps.com/,http://www.xero.com/,https://indinero.com/, or some competitors. It's tough to know if any of these apps would fit your needs, since it would depend heavily on your business and exactly what you were trying to accomplish.

For most small to medium sized business, the tasks of managing spreadsheets, creating dashboards and reports, and building forecast models can generally be handled by a single skilled Business Analyst. This would be someone who had both technical ability and business acumen.

I'm happy to go into more details about processes and solutions that have worked for me in the past or make more specific recommendations if you provide a little more detail about your business and your goals.

Best,

Nick


Michael Brill
0
0
Michael Brill Entrepreneur
Technology startup exec focused on AI-driven products
Hi Eugene.

You sound a bit exasperated with just the accounting part. My $0.02 is nail that so all your basic accounting functions without much manual integration and then keep your planning model separate. Maybe you have to copy/paste a few numbers every time you want to re-forecast, but generally what I've seen is that you want to loosely couple your operational from planning systems... you probably don't want to reforecast every time you have a good or bad week.

...Michael
Christopher Remus
0
0
I'm also not aware of a single system that pulls everything together, however this may be helpful to you -

http://pulseapp.com/index.html

I'm looking at giving waveapps.com a shot for managing the financials of a couple small projects that are in development. They also have a list of accountants on the site and I'm thinking that the accountants they list may be a bit more forward-thinking in using apps and systems other than Quickbooks. Despite my best efforts to find a different system, it seems like I'm not able to avoid Quickbooks, which is the direction my accountant keeps pushing me towards.

Good luck and I'd be very interested in what you learn along the way!
Bruce Eckfeldt
0
0
Bruce Eckfeldt Entrepreneur • Advisor
Entrepreneur, Inc. 500 CEO, Coach, Writer & Speaker on Organizational Performance
A friend of mine is working on this exact problem actually.

They're designing a forecasting tool that pulls Quickbooks data and lets you build a dynamic financial model on top. It's focused on decision making (so forward looking) but can track data feeds to show past performance as well. It has a scenario manager so you can run multiple scenarios - and they're building a dashboard to show graphs of past, present & projections.

They're in stealth mode at the moment but I can put you in touch with the founder if you want to speak with them.
Join FounderDating to participate in the discussion
Nothing gets posted to LinkedIn and your information will not be shared.

Just a few more details please.

DO: Start a discussion, share a resource, or ask a question related to entrepreneurship.
DON'T: Post about prohibited topics such as recruiting, cofounder wanted, check out my product
or feedback on the FD site (you can send this to us directly info@founderdating.com).
See the Community Code of Conduct for more details.

Title

Give your question or discussion topic a great title, make it catchy and succinct.

Details

Make sure what you're about to say is specific and relevant - you'll get better responses.

Topics

Tag your discussion so you get more relevant responses.

Question goes here

1,300 Followers

  • Name
    Details
  • Name
    Details
  • Name
    Details
  • Name
    Details
  • Name
    Details
  • Name
    Details
  • Name
    Details
  • Name
    Details
Know someone who should answer this question? Enter their email below
Stay current and follow these discussion topics?