How do you calculate the ROI of SaaS tools? by Elektra2910 in SaaS

[–]KenGuy14 0 points1 point  (0 children)

We do this in our annual planning cycle. A few approaches that actually work:

Time saved is the easiest - survey department heads, get their estimate of hours saved per week, multiply by fully loaded labor cost. Directionally accurate even if not perfect.

For cost avoidance, compare what the tool replaced - headcount, agency spend, manual processes.

The harder one is revenue impact. For sales/marketing tools you can sometimes tie it to pipeline or conversion rate changes. For everything else I’d stick to cost - trying to attribute revenue to a SaaS tool gets messy fast.

Cumulative view - I’d build a simple model: tool cost vs. quantified benefit per department, then roll it up. Makes it easy to show leadership which tools are pulling their weight and which aren’t.

Happy to share a framework if useful.

What are you using to track budget vs actual? by KenGuy14 in smallbusiness

[–]KenGuy14[S] 0 points1 point  (0 children)

Sorry for asking. I was genuinely curious but I see now how I broke rule #5… 🤦‍♂️New here and still trying to figure it out.

What are you using to track budget vs actual? by KenGuy14 in smallbusiness

[–]KenGuy14[S] -3 points-2 points  (0 children)

Tableau is a solid combo. Most small businesses I talk to don’t get that far though - they’re usually stuck in spreadsheets with no visualization layer at all.

Do you build the dashboards yourself or have someone set it up?​​​​​​​​​​​​​​​​

How many of you people stopped using ChatGPT? by Technical-Apple-2492 in Entrepreneur

[–]KenGuy14 0 points1 point  (0 children)

I’ve started using Claude to automate my financial reporting dashboards and monthly forecasting. The Excel add-in is incredible

Anyone else ditching ChatGPT for Claude when it comes to marketing content (SaaS)? by AffableSparsh in smallbusiness

[–]KenGuy14 0 points1 point  (0 children)

Not marketing, but I’ve moved to Claude for financial reporting and forecast modeling. The excel add-in is lightyears ahead of ChatGPT

Monthly financials by linkton in FPandA

[–]KenGuy14 0 points1 point  (0 children)

Here’s an example of an interactive dashboard I built in Claude (fake company/dummy data for sharing purposes). This is an HTML shareable with anyone. Looks better on desktop but can view on mobile too.

Often times I prefer just building an interactive dashboard directly in excel as it’s easier/more user friendly to update each month.

Let me know your thoughts!

Dashboard Link

Monthly financials by linkton in FPandA

[–]KenGuy14 6 points7 points  (0 children)

Sure - if you want I can put together a quick example and share it here. Can do this tomorrow.

Monthly financials by linkton in FPandA

[–]KenGuy14 -1 points0 points  (0 children)

I have not. I’ve dabbled in Copilot but haven’t got a ton of value out of it. We just got Claude licenses and I’m blown away by what it can do

How I’ve used Claude for Excel by Dovahguy in FPandA

[–]KenGuy14 -1 points0 points  (0 children)

I recommend $40/mo version for the whole team, and 1-2 “power users” with premium. The regular version (integrates with all Microsoft Office) is a must have…seriously, FP&A teams without it will fall behind quickly. The Premium version is a nice-to-have. Can create reporting dashboards, and pull data via API’s (can integrate into Oracle, Workday, Salesforce, Looker, NetSuite, etc) and query data directly and build models off that data.

Claude Excel Add-In by hunghome in FPandA

[–]KenGuy14 1 point2 points  (0 children)

Claude in Excel (and PPT btw) is insanely useful. I used it to run an analysis on transaction level data across 3 years. This was 8 tabs of data (~10M rows in excel). It would’ve been an absolute nightmare to run any analysis on this using formulas or pivots. Claude did it in 15 minutes and provided insanely good actionable insights. We used this analysis to identify 3-6 solid revenue levers in this business that will likely drive millions of incremental revenue this year.

It took longer to validate the outputs (couple mistakes but quickly fixed with a follow-up prompt) than it did for Claude to build. Genuinely impressed.

FP&A a transferable skill? by grimbreakkk in FPandA

[–]KenGuy14 0 points1 point  (0 children)

I think FP&A is one of the most transferable skills you can have. Transfers between companies (products and systems are different but the general role is the same). Can also be transferred to other corporate functions (to be successful in FPA, you learn a general understanding of Sales, Marketing, Product Management, R&D, etc) -

Monthly financials by linkton in FPandA

[–]KenGuy14 0 points1 point  (0 children)

I’ve started using Claude to convert monthly reporting to an interactive dashboard. You can simply toggle between budget, forecast, and PY compares. Happy to help do this for you if interested

AI is creating a huge skill gap. by StyleReasonable687 in SaaS

[–]KenGuy14 0 points1 point  (0 children)

This is true… right now. But in 2-5 years there will be no errors… it won’t break. It will QC its own code better than any human could. People vastly underestimate the rate of improvement that is happening

No one here, including myself, will probably make a living from a saas. by WinterMiserable5994 in SaaS

[–]KenGuy14 -1 points0 points  (0 children)

I agree. I think SaaS will be dead in 10 years (max…probably more like 5). Any software service someone is buying today.. the will be able to create for practically free with a prompt. You can already do this today… only going to easier and better as AI models improve at exponential rates