Pop quiz to all finance peeps: list all the critical master sheets your company uses (Need to Set up this whole process for a client)

Need to pretty much tell him every excel finance sheet he needs, then I'll build them for him!

Here are my current answers:

Critical sheets:

  1. Cash position and 13-week forecast
  2. AR summary and top 5 overdue
  3. AP summary and payment run recommendation
  4. Cash conversion cycle vs baseline vs last month
  5. Project/contract P&L
  6. Flags, actions taken this month, recommended actions

Pretty sure the top 4 is all they need?
They need AR visibility, AP visibility, cash flow!

What am I missing?

reddit.com
u/RiasGremoryIDLE — 5 days ago
▲ 24 r/CFO

What's your non‑negotiable monthly reporting sheets for PE backers/owners?

Is there literally anything else?
As a CFO what else would you need for a standard month-end pack.

For the basis of a month-end pack, non‑negotiables:

1. Flash report (KPI, cash, EBITDA)
2. TTM P&L with variances
3. Balance sheet snapshot YoY
4. 13‑week cash flow forecast
5. AR/AP aging summaries
6. Covenant calc & headroom

reddit.com
u/RiasGremoryIDLE — 5 days ago
▲ 0 r/excel

Pop quiz to all finance peeps: list all the critical master sheets your company uses (Need to Set up this whole process for a client)

Need to pretty much tell him every excel finance sheet he needs, then I'll build them for him!

Here are my current answers:

Critical sheets:

  1. Cash position and 13-week forecast
  2. AR summary and top 5 overdue
  3. AP summary and payment run recommendation
  4. Cash conversion cycle vs baseline vs last month
  5. Project/contract P&L
  6. Flags, actions taken this month, recommended actions

Pretty sure the top 4 is all they need?
They need AR visibility, AP visibility, cash flow!

What am I missing?

reddit.com
u/RiasGremoryIDLE — 6 days ago
▲ 3 r/Accountant+1 crossposts

Dext accounting software? need AP,AR & Cashflow- is anything better?

Accountant here needing AP,AR & Cashflow solution
Was going to get Dext but then saw this

https://www.reddit.com/r/Accounting/comments/1opsg95/dext_warning/

What are the main pain points it solves?
Any key issues you find with it?
Can it make AP & AR 2x fast for me?

Learning new systems is a pain for me so thought I'd reach out
The cost isn't bad for us at this point- better than us getting more indian outsourced CPAs

I saw it does the following
All-in-one data capture
E-commerce sanity
Data health for firms 

But I just need AP, AR and some cash flow insights- would it be enough?

Anything better?

reddit.com
u/RiasGremoryIDLE — 13 days ago

[GBR] how do you manage who owes you money?

For anyone running a company with more than a handful of customers - how do you actually keep track of what's owed and chase it?

Is it on you, your accountant/bookkeeper or your debt collector?
Do you have a system or is it "check the bank, panic, chase the big ones"?

Trying to understand how real businesses handle this.

reddit.com
u/RiasGremoryIDLE — 16 days ago

How do you manage who owes you money?

For anyone running a company with more than a handful of customers - how do you actually keep track of what's owed and chase it?

Is it on you, your accountant/bookkeeper or your debt collector?
Do you have a system or is it "check the bank, panic, chase the big ones"?

Trying to understand how real businesses handle this.

reddit.com
u/RiasGremoryIDLE — 16 days ago

How do you manage who owes you money?

For anyone running a company with more than a handful of customers - how do you actually keep track of what's owed and chase it?

Is it on you, your accountant/bookkeeper or your debt collector?
Do you have a system or is it "check the bank, panic, chase the big ones"?

Trying to understand how real businesses handle this.

reddit.com
u/RiasGremoryIDLE — 16 days ago

Desperately trying to speak to CFOs - please help- i will not promote

First time founder

After speaking to one CFO I realised they have 10x the insight I can find anywhere else. One convo I had on a saturday with a CFO midmeal gave me over a month worth of learning by myself.

Currently doing market validation on what finance leaders actually care about and I've hit a wall getting in front of them.

Can I pick anyone's brain for 15 minutes?
Struggling to get infront of CFOs.

I have sales navigator referall codes for 2 months if anyone wants in return?

Super sorry if this isn't the right place to ask - genuinely not sure where else to go and out of warm intros.

reddit.com
u/RiasGremoryIDLE — 16 days ago

Desperately trying to speak to CFOs - please help- i will not promote

First time founder

After speaking to one CFO I realised they have 10x the insight I can find anywhere else. One convo I had on a saturday with a CFO midmeal gave me over a month worth of learning by myself.

Currently doing market validation on what finance leaders actually care about and I've hit a wall getting in front of them.

Can I pick anyone's brain for 15 minutes?
Struggling to get infront of CFOs.

I have sales navigator referall codes for 2 months if anyone wants in return?

Super sorry if this isn't the right place to ask - genuinely not sure where else to go and out of warm intros.

reddit.com
u/RiasGremoryIDLE — 16 days ago

Desperately trying to speak to CFOs - please help- i will not promote

First time founder

After speaking to one CFO I realised they have 10x the insight I can find anywhere else. One convo I had on a saturday with a CFO midmeal gave me over a month worth of learning by myself.

Currently doing market validation on what finance leaders actually care about and I've hit a wall getting in front of them.

Can I pick anyone's brain for 15 minutes?
Struggling to get infront of CFOs.

I have sales navigator referall codes for 2 months if anyone wants in return?

Super sorry if this isn't the right place to ask - genuinely not sure where else to go and out of warm intros.

reddit.com
u/RiasGremoryIDLE — 16 days ago
▲ 2 r/SaaS

Desperately trying to speak to CFOs - please help- i will not promote

First time founder

After speaking to one CFO I realised they have 10x the insight I can find anywhere else. One convo I had on a saturday with a CFO midmeal gave me over a month worth of learning by myself.

Currently doing market validation on what finance leaders actually care about and I've hit a wall getting in front of them.

Can I pick anyone's brain for 15 minutes?
Struggling to get infront of CFOs.

I have sales navigator referall codes for 2 months if anyone wants in return?

Super sorry if this isn't the right place to ask - genuinely not sure where else to go and out of warm intros.

reddit.com
u/RiasGremoryIDLE — 16 days ago

CFOs- what do your clients actually care about?

To anyone working in finance - what do your clients/companies actually care about most?

Been speaking to a few CFOs and they all said the same thing. Cash is king. AR, AP, cash collection, working capital. Everything else comes second.

Revenue recognition, board packs, management accounts - important but not the thing anyone's losing sleep over.

For anyone working in strategic finance postitions at any level - is that what you see too?

Or does it depend on the company, the sector, the stage? Genuinely curious what the day-to-day reality looks like across different roles.

reddit.com
u/RiasGremoryIDLE — 16 days ago
▲ 9 r/CFO

Speaking to CFOs - am I right to say you only really care about one thing?

Been speaking to 5 fractional CFOs and they all said the same thing.

Cash is king.

AR, AP, cash collection, working capital. Everything else is secondary.

Revenue recognition, management accounts, board packs - important obviously but not the thing keeping anyone up at night.

Am I wrong? What else actually matters to you when you join a firm?
Is there anything of importane that would come close to cash flow in order of significance?

reddit.com
u/RiasGremoryIDLE — 16 days ago

Whose job is fixing revenue ops - should I go fractional CFO,CRO or CEO? Or just someone external (which we don't want)

Hey guys, senior manager here for a company. Needing urgent end-to-end revenue services ( so posting invoices to putting it on the board pack)

Is this a CFO, CRO or CEO job? Sort of lost- (I have never reached out for help outside my own company)
Or is there another solution out there?

Context-
Struggling with revenue operations. Takes 2-3 days, manual and a pain.

Things like board packs, project accounting and revenue analysis. Pretty much done every month end so we know how much money we are getting.

Operating across US, UK & MENA.

Is overhauling this a CFO or CEO job? It comes from a lack of skills & the engineers not talking to finance as they have a "we will just find out" mentality.

How did you fix this - did you hire, buy a tool, or bring in a consultant? And roughly what did it cost you?

2 accountants & 1 FC rn

Any ideas the cost to fix this, who to talk to etc?

reddit.com
u/RiasGremoryIDLE — 22 days ago

Whose job is fixing revenue ops - should I go fractional CFO,CRO or CEO? Or just someone external (which we don't want)

Hey guys, senior manager here for a company. Needing urgent end-to-end revenue services ( so posting invoices to putting it on the board pack)

Is this a CFO, CRO or CEO job? Sort of lost- (I have never reached out for help outside my own company)
Or is there another solution out there?

Context-
Struggling with revenue operations. Takes 2-3 days, manual and a pain.

Things like board packs, project accounting and revenue analysis. Pretty much done every month end so we know how much money we are getting.

Operating across US, UK & MENA.

Is overhauling this a CFO or CEO job? It comes from a lack of skills & the engineers not talking to finance as they have a "we will just find out" mentality.

How did you fix this - did you hire, buy a tool, or bring in a consultant? And roughly what did it cost you?

2 accountants & 1 FC rn

Any ideas the cost to fix this, who to talk to etc?

reddit.com
u/RiasGremoryIDLE — 22 days ago

Whose job is fixing revenue ops - should I go fractional CFO,CRO or CEO? Or just someone external (which we don't want)

Hey guys, senior manager here for a company. Needing urgent end-to-end revenue services ( so posting invoices to putting it on the board pack)

Is this a CFO, CRO or CEO job? Sort of lost- (I have never reached out for help outside my own company)
Or is there another solution out there?

Context-
Struggling with revenue operations. Takes 2-3 days, manual and a pain.

Things like board packs, project accounting and revenue analysis. Pretty much done every month end so we know how much money we are getting.

Operating across US, UK & MENA.

Is overhauling this a CFO or CEO job? It comes from a lack of skills & the engineers not talking to finance as they have a "we will just find out" mentality.

How did you fix this - did you hire, buy a tool, or bring in a consultant? And roughly what did it cost you?

2 accountants & 1 FC rn

Any ideas the cost to fix this, who to talk to etc?

reddit.com
u/RiasGremoryIDLE — 22 days ago
▲ 5 r/ChiefsOfStaff+5 crossposts

To go fractional CEO or fractional CFO

Hey guys, senior manager here for a company.
Sort of lost- (I have never reached out to help outside my own company)

Struggling with Revenue operations.
Takes 2-3 days, manual and a pain.

Things like board packs, project accounting and revenue analysis.
Pretty much needs to be done every month end so we know how much money wew are getting

Operating in US,UK & MENA operations.

Is overhauling this a CFO or CEO job?
It comes from a lack of skills & the engineers not talking to finance as they have a "we will just find out" mentality.

Anything we can do for free?

2 accountants & 1 FC rn

reddit.com
u/RiasGremoryIDLE — 22 days ago
▲ 3 r/CFO

What is too small for a CFO- Quality vs Cost

We run a company requiring automation/speeding up of month end: Revenue budgets, cash flow, project accounting across 3 jurisdictions & 3 business entities.

Is a fractional CFO too big to do this?
Its more of understanding project heavy PE businesses and monitoring where the income will come in and implementing a way to (not automate) but make it more efficient.

We are not the biggest fans of AI or system overhauls but are open to it!

Anyone got experience how to make 2 accountants handle all of this?
Is it normal to take 2-3 days a month doing this?

reddit.com
u/RiasGremoryIDLE — 23 days ago

We never get revenue budgets/forecasts or rev recs done on time- normal or not?

Small UK company, 1 accountant.

Revenue recognition plus the monthly budget/forecast takes a minimum of about 2-3 days every month ( have to do data collection, accruals, and make into something readable)

Is this normal for a team our size, how long does it take a normal bookkeeper?

How do you get it done on time?

reddit.com
u/RiasGremoryIDLE — 24 days ago

Accountant says it'll take 3-4 days a month to get contracts, revenue and forecasts in place...

But how though?

Is there an easier solution?

Small UK company, one accountant.

Every month the revenue recognition plus the budget/forecast takes them a minimum of 2-3 days once you get data (excel sheets, our contracts, invoices etc) together, and then making it into some dashboard.

It always takes a while and seems they are struggling tbh.

How do you guys get your forecasts? Do you even need them? - is 2-3 days just what this takes, or have you got it down?

What works for you guys?

reddit.com
u/RiasGremoryIDLE — 24 days ago