Level up your career with Finance & Accounting!
This channel covers topics ranging from Accounting, Financial Planning & Analysis (FP&A), Excel, and more.
Each video is often times accompanied by an engaging infographic and excel sheet to help you follow along on the core concepts that we'll be covering.
These videos are the learnings from my 10+ year experience in Finance & Accounting, ranging from my experience at Big 4, to managing my own fractional CFO firm.
This is the channel I wish I had when I was just starting out...and it's now my mission to share what I've learned with you each and every week.
Thanks for watching and don't be shy to say hello in the comments!
Josh Aharonoff (Your CFO Guy)
Master your Debits & Credits š
These are the foundation of double entry accountingā¦
and are often times the first thing youāll learn in an into to accounting course.
Many people feel they are a tough concept to grasp at firstā¦
but to me, itās actually really simple once you understand the logic behind them.
Letās go through it all from top to bottom.
First..
ā”ļø What exactly are Debits & Credit?
Debits & Credits are a bit hard to explain becauseā¦well
They donāt really represent anything.
Itās just a way of communicating whether an account balance on your P&L / Balance Sheet is increasing or decreasingā¦
and they must always equal each other, or ābalanceā.
This is where the famous term āDouble Entry Accountingā came from.
ā”ļø How does Double Entry Accounting work?
Double Entry Accounting pretty much means that every financial event affects 2 or more accounts in your general ledger.
You heard that rightā¦each and every financial transaction.
And those 2 āeventsā are communicated via debits & credits
ā”ļø How can you remember when to use a Debit, and when to use a Credit?
OKā¦so this is where it can get confusing.
But itās actually really simple if you just understand this formula
ASSET = LIABILITIES + OWNERS EQUITY
This is known as the accounting equation, and means that all financial activity affects one or more of these 3 sections of your Balance Sheet.
So when using debits & creditsā¦
the way Assets go up or downā¦
is the complete OPPPOSITE for how Liabilities + Owners Equity go up or down.
And this is all you need to memorize š
Assets ā> ā¬ļø go UP with DEBITS ā¬ļø Go DOWN with CREDITS
Liabilities + Owners Equity ā> ā¬ļø Go UP with CREDITS ā¬ļø Go DOWN with DEBITS
ā”ļø What about the Profit and Loss?
The P&L is technically just a more detailed version of an account on your Balance Sheet called Retained Earnings.
Put another wayā¦your retained earnings balance is just an accumulation of your net income / loss rom your P&L.
So just like your Retained Earningsā¦your Net Income goes UP ā¬ļø with a Credit
and DOWN ā¬ļøwith a Debit.
Than means that any P&L account thatās GOOD for your net income (like Revenue)
Will go up byā¦..?
Thatās right - a CREDIT
And things that are BAD for your net income (like COGS / Expenses)
Will go up by�
Exactly! A DEBIT
===
What do you think? Was that simple enough for you to understand?
When you understand Debits & Credits, you'll not only add value to your career in accounting...
but you'll also add tremendous value in FP&A, as it's important to understand the relationship between account values going up / down on your general ledger.
Let me know what else you would add in the comments below š
11 hours ago | [YT] | 59
View 0 replies
Josh Aharonoff (Your CFO Guy)
Learn about 77 Types of Accounting š
I remember when I first graduatedā¦
I thought Accounting only meant 2 things
Tax, or Audit.
Boyā¦was I wrong.
Accounting is easily one of the most diverse and versatile fields out thereā¦
With tons areas & industries that you can specialize in.
Letās dive in to some of my favorite areas of Accounting:
1ļøā£ Cash Accounting
Cash is kingā¦right?
Well, thatās especially true if youāre performing āCashā accounting.
The idea here is pretty simple - you record all money received as incomeā¦
and all money paid as an expense.
There are some exceptions here, but thatās the gist of it
2ļøā£ Public Accounting
This is where I started my careerā¦and where many feel itās the best place to launch your career as an accountant.
The main focus here is between 2 fields: Auditing, and Tax, often times for public companies.
The most popular public accounting firms are known as āThe Big 4āā¦which are Ernst & Young, KPMG, Deloitte, and Price Waterhouse Coopers
3ļøā£ Forensic Accounting šµļø
Ever wish you became a private investigator, or a detective, instead of an accountant?
Forensic accounting may be a perfect fit.
Forensic accountants investigate financial discrepancies and fraud, often times working on legal cases to uncover any irregularities with a companies financial records.
4ļøā£ Accrual Accounting
Accrual accounting is much more popular amongst bigger companiesā¦
and IMO tells a much better story of whatās ACTUALLY happening.
Here, you treat income EARNED as revenueā¦
and expenses INCURRED as an expenseā¦
regardless of when cash was received
5ļøā£ Operational Accounting
Hereās one of my favorite fields in accountingā¦
With operational accounting, youāre handling the accounting tasks that relate to āoperatingā a company, such asā¦
ā Managing accounts payable
ā Following up on outstanding invoices
ā Processing payroll
and much more
6ļøā£ SaaS Accounting
For the most part, SaaS is just another industry, without too many nuances from any other industryā¦but it definitely has itās quirks.
For example, with SaaS accounting, thereās a lot of emphasis on deferred revenue, and when something can be recognized as revenue.
Similarly, an extra emphasis is put on calculating KPIs such as Customer Acquisition Cost, Customer Payback, and Net Dollar retention.
7ļøā£ Restaurant Accounting
Think you can easily transition to an industry like Restaurant Accounting? Be prepared for a lot of differences.
For example, instead of analyzing dozens of transactions a monthā¦
you may be analyzing thousands of transactions a DAYā¦
each with their own complexities in reconciling and reporting
===
Those are just 7 of the 77 areas of Accounting identified belowā¦
but even 77 types of accounting is an underestimation - the real number can be much much larger.
What are some other types of accounting youāve seen?
And which is your favorite?
Letās us know in the comments belowā¦Iāll go first š
1 day ago | [YT] | 97
View 0 replies
Josh Aharonoff (Your CFO Guy)
20 profit ratios that will transform how you analyze any business
The numbers never lie, but you need to know how to read them š
š© Join our newsletter and get all 20 ratios in one cheat sheet š yourcfoguy.kit.com/20-profit-ratios?utm_source=socā¦
Let me break down the most critical financial metrics you'll ever need š
ā”ļø CORE PROFITABILITY RATIOS
These ratios tell you exactly how well a business turns revenue into profit:
1ļøā£ Gross Profit Margin
The foundation of business profitability - what's left after direct costs.
When this number drops, it's often the first sign of pricing pressure or rising material costs.
2ļøā£ Operating Profit Margin
This strips away the noise and shows pure operational performance.
Want to know if a business is actually good at what it does? This ratio tells you.
3ļøā£ Net Profit Margin
The bottom line that matters. Shows exactly what you're left with after everything's paid.
4ļøā£ EBITDA Margin
Strips out accounting decisions to show true operational performance.
Critical for comparing companies with different capital structures.
ā”ļø RETURN RATIOS - THE REAL PERFORMANCE INDICATORS
5ļøā£ Return on Equity
Your shareholders' report card.
This number can make investors either jump for joy or run for the hills.
6ļøā£ Return on Assets
Shows how well a company uses its assets to generate profits.
This ratio becomes crucial when comparing asset-heavy industries.
7ļøā£ Return on Capital Employed
The heavyweight champion of performance metrics.
It's like ROE and ROA had a super-smart baby.
ā”ļø EFFICIENCY RATIOS
Now we're getting to the good stuffā¦
8ļøā£ Asset Turnover
Reveals how efficiently a company generates sales from its assets.
Higher ratios usually mean better operational efficiency.
Think of this as your business's speedometer.
The faster it spins, the more efficient you are.
9ļøā£ Inventory Turnover
Critical for retail and manufacturing - shows how quickly inventory moves.
Lower numbers might signal obsolete stock or poor purchasing decisions.
š Accounts Receivable Turnover
Measures how fast a company collects what it's owed.
This ratio directly impacts cash flow - the lifeblood of any business.
ā”ļø MARKET PERSPECTIVE RATIOS
1ļøā£1ļøā£ P/E Ratio
The market's expectation of growth packed into one number.
But remember - high P/E isn't always better. It's about whether the company can meet those expectations.
1ļøā£2ļøā£ EPS Growth
Shows the rate of earnings growth per share.
This becomes powerful when tracked over multiple quarters.
===
Three principles I always follow when using these ratios:
1. Compare within industries - ratios mean different things in different sectors
2. Look for trends - a single number means nothing without context
3. Use multiple ratios - they work together to tell the complete story
Grab it here: yourcfoguy.kit.com/20-profit-ratios?utm_source=socā¦
Which ratio do you find most valuable in your analysis?
Share your thoughts in the comments below š
4 days ago | [YT] | 140
View 1 reply
Josh Aharonoff (Your CFO Guy)
The Accounting FP&A Yin Yang āÆļø
they are 2 sides of the same coin šŖ
Accounting & FP&A each contains key responsibilitiesā¦
and together they make up your Finance & Accounting š¤
So often I see these 2 sides clash
But when they work in harmony with one another, great things happen
Hereās an overview on what Accounting does
**Accounting**
šøFinancial Reporting - āclosing outā your financial statements in your accounting software (often known as bookkeeping)
šøAP - coordinating & processing bill payments to vendor
šøInvoicing - sending invoices to customer, and coordinating collections
šøPayroll - onboarding employees, approving & processing payroll, coordinating with state tax agencies (parts of this function may be handled under HR)
šøTaxes - annual federal & state income tax filings, Delaware franchise tax, sales tax (typically not done in house at a startup)
šø Audit - coordinate audit with external auditing firm (usually done after Series B)
But thatās just one side of the coin. The other function is just as crucialā¦
**Financial Planning & Analysis (FP&A)**
š¹ Projections - adding forecasted figures for all areas of the business (revenue, cash flows, ARR)
š¹ Data analysis - analyzing data to optimize for better costing / profitability
š¹ Budget vs Actuals - comparing what you had projected vs what actually took place. (My favorite area of FP&A)
š¹ Board reporting - providing the board of directors with key summaries on whatās happeningā¦another one of my favorites
š¹ Fundraising - wowing investors, and showing them how youāll be 100xāing each month for the rest of eternity š¤
Whatās my #1 advice for Finance & Accounting professionals?
LEARN BOTH
Thereās so much you can do when you understand how to prepare data, as well as analyze & draw meaningful insights from that data
If youāre an accountant - learn how to build a 3 statement model, or how to prepare a budget vs actualsā¦or a beautiful dashboard
If youāre in FP&A - learn what debits & credits areā¦or how cash vs accrual accounting works
Iāve seen few achieve this well, unless youāre a CFO - which would be a require you to learn both
But donāt wait till youāre a CFO. Learn today
Your career depends on it
What would you add?
Let us know in the comments below š
5 days ago | [YT] | 98
View 3 replies
Josh Aharonoff (Your CFO Guy)
The Ultimate Business Dashboard Every CEO Needs š¤
7 snapshots that tell you everything happening in your business
...and for the next 48 hours you can get this dashboard for free
Every day our company shares internally a number of dashboards into close to every area of our business.
These dashboards give me QUICK insight into KEY areas of the business...after 30 seconds of consumption, I have a good pulse on everything that's happening.
If you are running a business, there's no way that you can get in the weeds with everything...you need quick snapshots to summarize what's happening.
Here is my preferred set up:
ā”ļø REVENUE & GROWTH
There are few things that are as important as sales, and growth.
This is especially true if youāre an early stage startup, where revenue & growth is what determines your ability to get more funding from investors
ā”ļø CASH FLOWS
OKā¦I said there are few things as important of sales & growthā¦
cash flows is definitely one of them.
I like to keep track of how much cash is coming in from receivablesā¦
how much cash is going out to employeesā¦
as well as to vendorsā¦
The last thing I want is to be taken by surprise with anything cash related
ā”ļø PROFIT & LOSS
Your P&L is one of the most useful reportsā¦
and is designed to tell you ONE thingā¦
how much profit (or loss) you are generating
ā”ļø HEADCOUNT
Your headcount is one of the most important things to key track ofā¦
Why?
Because itās often times the LARGEST expenseā¦
and often times the BIGGEST contributor to your success
ā”ļø PIPELINE SALES
Itās not enough to understand how much youāve done in salesā¦
itās just as important to understand what you have coming in the pipeline.
This can help you prepare resources, cash flows, and much more.
ā”ļø HIRING
Are you in the process of hiring for a new role?
Itās crucial to stay up to date on whatās happening with the job postā¦
I like to review this snapshot every morning as we have an active role (which we do - check out our hiring page at Mighty Digits!)
ā”ļø BUDGET VS ACTUALS
Budgets are a great thing - I donāt care how much backlash that comment gets.
It allows you to create a blueprint for what you think the future will look likeā¦
and then track against that blueprint, understanding whether you need to tweak your assumptions, or whether all is going according to plan.
This is by far my favorite reportā¦I canāt get enough of it.
===
Thatās my take on the metrics you should be tracking everyday, and the best way to ingest this information at a quick glance via an attractive dashboardā¦
but every CEO has their own metrics which matter more to their business / industry.
What metrics are you tracking?
Let me know by joining us in the discussion in the comments below š
6 days ago (edited) | [YT] | 49
View 1 reply
Josh Aharonoff (Your CFO Guy)
This is the CRAZIEST dashboard I've ever builtā¦
and today I'm giving it away for FREE.
š© Join The CFO Files newsletter and I'll send you this dashboard for free: yourcfoguy.kit.com/ultimate-dashboard?utm_source=sā¦
I spent 20+ hours researching, designing, and building this one.
It tells you all sorts of key information, like:
ā Revenue & Gross Margin
ā Comparison against budget
ā Comparison against prior period
ā Departmental breakdown
ā Breakdown by cost type
And all of it updates with just ONE CLICK.
Here's how I built it.
ā Step 1, Design Your Dashboard
But don't make the mistake of exporting a P&L straight from your accounting software and sending that to management or investors.
Instead, invest in DESIGN. And when I say design, I mean:
šØ a cohesive color scheme
š” a proper font
š proper alignment and placement
ā Data Structure
Here, we have 4 departments.
š„ General & Administrative
š„ Sales & Marketing
š„ Research & Development
š„ Customer Support
So each department gets its own P&L, segmented by:
1ļøā£ Section
2ļøā£ Summary Grouping
3ļøā£ Account
Then we have a data set for ACTUALS, and another for BUDGET.
That's 8 tabs total. 4 with actuals, 4 with budget.
ā Transform With Power Query
Now that the data's in place, it's time to TRANSFORM it so it's actually easy to MANIPULATE.
That means UNPIVOTING everything with Power Query.
And then we append all the actual tabs together, and all the budget tabs together.
ā Create Relationships In Power Pivot
Power Pivot is the big leagues of Excel. Honestly, I'm still learning a ton about it myselfā¦
What's amazing about Power Pivot is that you can build RELATIONSHIPS between different tables, so you can mix and match when you build your pivot tables.
From there I built a bunch of MEASURES, which work like Excel formulas, except they run on something called DAX.
ā Create Pivot Tables
Now with the data structured and the measures in place, it's time to build the pivot tables.
Honestly, this part is a breeze.
ā Link Up The Dashboards
And now for the grand finale šŖš©
With everything else in place, linking up the dashboard is easy.
===
What I love about this one is that I can click any period, YTD, or TRAILING 12 MONTHS, and the whole thing updates instantly.
Grab it here: yourcfoguy.kit.com/ultimate-dashboard?utm_source=sā¦
Have you ever used a Power Pivot? Think you could build a dashboard like this one?
1 week ago | [YT] | 10
View 4 replies
Josh Aharonoff (Your CFO Guy)
9 Ways to Forecast
There are an endless number of methods you can use when forecastingā¦
š© Join our newsletter and get instant access here š yourcfoguy.kit.com/9-ways-to-forecast
but they all really boil down to just one of these 9 methods:
1. Six-month historical average
How it works: take the last 6 months value. You can take it one step further by adding a buffer, like a 5% increase.
Why it's useful: the future often blends well with the past, especially in the first few months of projections.
2. Prior month balance
How it works: set your projection to last month's value.
Why it's useful: extra helpful when forecasting the balance sheet for accounts with minimal movement.
3. Percent of revenue
How it works: set your projection to take a percent of revenue.
Why it's useful: as revenue scales, expenses tend to scale right along with it.
4. Dollars per hire
How it works: set a dollar figure for each hire.
Why it's useful: expenses and capex often scale with each new person you bring on.
5. Fixed assumption
How it works: enter any values or schedules you already have on hand.
Why it's useful: for items like insurance or rent where you have a fixed schedule, you can plug them right into your forecast.
6. Year-over-year growth
How it works: take the value from 12 months prior and add a growth factor.
Why it's useful: for companies with seasonality, you can match the schedule from the prior year, and add a buffer if you need to.
7. Annual inputs
How it works: enter your assumptions for the entire year, then divide by 12 for monthly projections.
Why it's useful: a simple, quick way to forecast an entire year.
8. Departmental intake
How it works: sit down with each department head and build a bottoms up budget for their department.
Why it's useful: you collect valuable information you may not have had insight into, and you hold each department head accountable to results and performance.
9. Zeroed out
How it works: forecast 0 going forward.
Why it's useful: helpful when you don't expect any future values in an account, or when you project those values in another account that relates to this one.
===
So which one is the correct one to use?
Well, like most things in life, it depends.
The key is understanding the nature of each account in your general ledger, and how it scales with time, revenue, or headcount.
Most models end up using a combination of all 9 of these approaches.
These are the 9 most common ways I forecast across the 40+ companies I work with.
Grab it here: yourcfoguy.kit.com/9-ways-to-forecast
What have you seen?
Let us know by joining in on the discussion in the comments below š
1 week ago | [YT] | 9
View 0 replies
Josh Aharonoff (Your CFO Guy)
The 4 Stages of Forecasting
from BEGINNER to ADVANCED
Which stage is your business atšŖ?
Every month, I meet with founders who are looking for help around their financial model.
I rarely see a company working with a level 4 forecastā¦
and oftentimes, founders donāt realize how much more value can be unlocked with just a few tweaks.
Letās go over each stage, and what to think about as your company scales
šŖ LEVEL 1 - CREATE A REVENUE BUILD (Beginner)
This is where most founders start with a forecast.
This will oftentimes suffice for an early-stage company, as the focus here is simply on the business model and the details behind the blueprint for how the company plans to scale
The key here is to think about these 2 things:
1ļøā£ How will INPUTS result in OUTPUTS (eg: an investment in sales reps results in more sales)
2ļøā£ What are the SOURCES of your revenue (eg: existing customers vs customers in your pipeline vs new customers)
šŖ LEVEL 2 - ATTACH A PROFIT & LOSS (Beginner / Intermediate)
Your revenue build is important, but it's not the only area of your business you need to think about.
At this stage, you start to introduce other costs.
It's here where you'll also want to attach a dynamic headcount build, showcasing the details behind who is on your team, and who you will hire in the near future.
šŖ LEVEL 3 - INCLUDE A BALANCE SHEET & CASH FLOWS (Intermediate / Advanced)
Most companies report on the accrual basis, especially as they scale.
Under the accrual basis, the amounts reported on your profit & loss won't equate with your cash flows.
It's here where you'll want to implement a 3 statement model showcasing the movements in your Balance Sheet, allowing you to dynamically showcase cash.
šŖ LEVEL 4 - INCLUDE HISTORICAL DATA AND DASHBOARDS (advanced)
This stage involves you importing your existing data around your financial statements, allowing you to understand where you have been, and where you are going, all in one view.
With this data in place, you can refresh your forecast each month, allowing you to tap into limitless dashboards for any business case.
===
So...which stage are you at with your forecast?
Itās never too late to climb the rung and add more value to your company šŖ.
What else would you add?
Let us know in the comments below š
1 week ago | [YT] | 8
View 2 replies
Josh Aharonoff (Your CFO Guy)
Learn about Deferred Revenue š
One of the most IMPORTANT Balance Sheet accounts
Deferred revenue continues to be where most people struggle the most
It can be a real pain to calculate, and an even larger pain in understanding š¤
Letās do a deep dive on what it means, and how to reconcile:
ā”ļø WHAT IS DEFERRED REVENUE?
Iāve seen a lot of definitions for deferred revenueā¦but I like this one the most:
Deferred Revenue is the $$ amount of goods or services that you currently owe to your customers
That can arise whenever
⢠a contract gets signedā¦
⢠An invoice gets sentā¦
⢠Or cash gets collectedā¦
The key thing is that Deferred Revenue gets triggered when āan entityās obligation to transfer goods or services to a customer for which the entity has received consideration (or an amount of consideration is due) from the customerā.
For more information on this, see ASC 606-10-45-2 in the bottom right corner of the infographic š
ā”ļø WHERE DOES DEFERRED REVENUE SHOW UP?
Because itās something that you OWEā¦it is a liability, which shows up in your Balance Sheet (typically a current liability).
Deferred Revenue gets amortized via Revenue, which shows up in the income section of the P&L
ā”ļø WHAT ARE THE JOURNAL ENTRIES?
When receiving payment / sending an invoice:
DEBIT Cash / AR
CREDIT Deferred Revenue
When recognizing revenue from deferred revenue:
DEBIT Deferred Revenue
CREDIT Revenue
ā”ļø HOW DO YOU CALCULATE DEFERRED REVENUE?
As with all balance sheet, follow the BASE formula
Beginning
+ Additions
- Subtractions
Ending
So in this caseā¦
Beginning Deferred Revenue
+ Invoices / Cash collected
- Revenue recognized
= Ending Deferred Revenue
ā”ļø HOW DO YOU AMORTIZE DEFERRED REVENUE?
This can be a bit trickierā¦
and Iāve seen 2 methods as the most common:
āļø an even monthly split
āļø a daily split
My favorite is a daily split so I donāt have to deal with cutoff datesā¦
but keep in mind that may make revenue lumpy for months like February where there are less than 31 days.
===
Thatās my take on Deferred Revenue - but thereās a lot more to it!
What would you add?
Let us know by joining in on the comments below š
1 week ago | [YT] | 3
View 0 replies
Josh Aharonoff (Your CFO Guy)
My month-end reporting used to take me 1 to 2 hours. Now it's one button.
Three dashboards. A KPI view, a comparison against prior period and prior year, and a summary across every period.
They all update at once.
The whole build is in the video.
https://www.youtube.com/watch?v=R5O8x...
Let me tell you what the problem actually was.
I had a profit and loss that looked like everybody else's. Ugly. Boring. Nobody ever wanted to read it.
So I built the three dashboards instead.
But then August rolls around and I've got a fresh export sitting there with new accounts in it. And now I'm hunting through every dashboard, relinking things by hand.
An hour. Sometimes two. EVERY month.
Now I'll be honest with you. Power Query scared me off for years... it just looks like a developer tool.
But all you're really doing is showing Excel the steps you take anyway. Clean this up. Move that around. Drop the totals.
Then you hit refresh and it does the whole thing again for you.
Here's the part that took me longest to work out.
Your P&L is in the wrong SHAPE. Accounts running down, dates running across, numbers sitting in the middle. Easy for a HUMAN to read. Miserable for a formula to touch.
Power Query flips it so every account and every month sits on its own row. And once your data looks like that, a simple SUMIFS can pull anything you want out of it.
And then there's the part I'm proudest of...
When new accounts show up in the export, my model TELLS me. The check goes red, and Power Query hands me a list of exactly which accounts are new and still unmapped.
I map them. I hit refresh. Everything clears.
So that's my whole month-end now. Point at the new data, refresh, map anything new.
Watch me build it here: https://www.youtube.com/watch?v=R5O8x...
How long is your monthly reporting taking you right now? Be honest.
1 week ago | [YT] | 43
View 0 replies
Load more