How to Create a Business Budget from Scratch in Excel

  Рет қаралды 14,020

Clara CFO Group

Clara CFO Group

Күн бұрын

We've been asked many times to create a video showing you how to create a business budget. Well, here it is!
This video covers everything you need to know in order to create a budget based on last year's P&L. Hannah walks you through what you need to think about in order to budget for every single line-item in the budget in order for you to come up with the best possible budget for the coming year.
We will do this in Excel, but you can use any spreadsheet software you prefer.
I also mentioned Jirav for budgeting in this video. If you are curious about Jirav and want to schedule a Demo, you can do so here: claracfo.com/jirav
To learn more about CFO services, go to: claracfo.com/cfo-services/
💲 Need an accounting system? We use Quickbooks Online with clients and recommend it as the best accounting system for small businesses. Sign up to get a discounted subscription for 12 months! claracfo.com/QBO
🙋‍♀‍Got Employees? Talk to ADP! They can help you if you are a small business owner or an accountant or advisor who works with small businesses. Learn more here: claracfo.com/adprun
💸Pay vendors any way they want and get paid faster! Accept credit cards without paying merchant fees! Melio is a fantastic payments solution for every small business! claracfo.com/melio
(As an affiliate or referral partner for these companies, I may earn rewards from qualifying purchases)
Hannah Smolinski is a #CPA and the Founder of Clara CFO Group. Find out more about Clara CFO Group at claracfo.com/
Disclaimer: This video is intended for educational purposes and
should not be taken as legal or tax advice. You should consult with your financial professionals about your unique financial situation before acting on anything discussed in these videos. Clara CFO Group, LLC is providing educational content to help small business owners become more aware of certain issues and topics, but we cannot give blanket advice to a broad audience.
How to Create a Business Budget from Scratch in Excel
CODE: X50MFHSQDFFP0MSB

Пікірлер: 25
@GeovannysMusicProd
@GeovannysMusicProd 2 ай бұрын
This is pretty much what we used at one my previous firms where I worked. Super helpful - Would just need to add in the actual and difference columns, plus departments sections for our imaginary teams lol Great video overall!
@sicazy
@sicazy 4 күн бұрын
Very helpful. Thank you.
@safeershahid9150
@safeershahid9150 3 ай бұрын
Thank you for making this tutorial. This tutorial is exceptional please provide excel files so we practice along with the tutorial as well.
@user-mx4sx4or9p
@user-mx4sx4or9p 5 ай бұрын
Incredible that this info is free. Thank you!!!
@ClaraCFO
@ClaraCFO 5 ай бұрын
Glad it was helpful!
@Tuckeratwork
@Tuckeratwork 3 ай бұрын
This was a great video!! Gained a lot of knowledge on how to predict and estimate revenue and expenses.
@StephenC612
@StephenC612 8 ай бұрын
A really good overview of the budgeting process! Especially liked the suggestions for how to make estimates for various line items, and the comments about people in the organization who could/should provide input.
@ClaraCFO
@ClaraCFO 8 ай бұрын
So glad you found it helpful!
@dianaphillips3979
@dianaphillips3979 6 ай бұрын
Agreed. I have to prepare a budget from scratch for a small business. This is sooooo helpful! Ihave the information from other managers. Just have to put it together now.
@princesserica718
@princesserica718 Ай бұрын
Awesome! Very helpful. thank you!
@ClaraCFO
@ClaraCFO Ай бұрын
Glad it was helpful!
@SandyH-xe7ms
@SandyH-xe7ms 3 ай бұрын
Thank you!
@user-sv4kk2ew7p
@user-sv4kk2ew7p 9 ай бұрын
I got certified QBO Proadvisor 😍🥰 Thanks to all of your content 😋
@ClaraCFO
@ClaraCFO 8 ай бұрын
congratulations!
@marinamanan6070
@marinamanan6070 2 ай бұрын
This was helpful...😃
@user-th4fw8uc6y
@user-th4fw8uc6y 2 ай бұрын
Thank you so much for this. Is there any reason why you did not do the taxes? Also, what are the next steps for this? Do you enter real time data as the months progress? What do you do when you have money left..
@samuellaary7123
@samuellaary7123 7 ай бұрын
Awesome , please I need the excel file
@sallygalbudgeting
@sallygalbudgeting 4 ай бұрын
Why are the merchant fees so much more in the projected year?
@ClaraCFO
@ClaraCFO 4 ай бұрын
Good catch! I caught that myself AFTER I recorded the video! It was a major excel error with a missing 0 in the calculation!
@sallygalbudgeting
@sallygalbudgeting 4 ай бұрын
@@ClaraCFO okay that’s what I thought too! Wasn’t sure if I missed something…thanks for clarifying!
@amnewt1640
@amnewt1640 5 ай бұрын
Any tips for if my Statement of Activity isnt showing any numbers when exported into excel? It brings in all of the different categories but shows zeroes where all of the money should be.
@amnewt1640
@amnewt1640 5 ай бұрын
Oh gosh never mind. I needed to enable editing.
@ClaraCFO
@ClaraCFO 5 ай бұрын
Happens all the time!
@user-it2qh2ff8d
@user-it2qh2ff8d 5 ай бұрын
my company just moved into a new space and state which has much higher rent and insurance etc how should I project these ?
@VirginieCazol
@VirginieCazol Ай бұрын
Use a rolling forecast
How to Set Up a Budget in QBO - QBO Tutorial
13:24
Clara CFO Group
Рет қаралды 6 М.
Business Budgeting 101 - Learn the basics of business budgeting
15:56
Clara CFO Group
Рет қаралды 11 М.
Scary Teacher 3D Nick Troll Squid Game in Brush Teeth White or Black Challenge #shorts
00:47
Now THIS is entertainment! 🤣
00:59
America's Got Talent
Рет қаралды 37 МЛН
Cool Items! New Gadgets, Smart Appliances 🌟 By 123 GO! House
00:18
123 GO! HOUSE
Рет қаралды 17 МЛН
Дарю Самокат Скейтеру !
00:42
Vlad Samokatchik
Рет қаралды 8 МЛН
Business Budget Spreadsheet - Step by Step Instructions [for 2023]
19:57
Starting a Nonprofit: How to Create a Budget (For Beginners)
25:02
Amber Melanie Smith
Рет қаралды 47 М.
Rolling Forecast vs. Budget - Differences EXPLAINED
11:52
Clara CFO Group
Рет қаралды 9 М.
5 Powerful KPIs can REVEAL more about a business than you think!!
10:59
The Financial Controller
Рет қаралды 20 М.
Create a powerful income/expense gig work tracker spreadsheet EASILY
46:57
Ask Your Computer Guy
Рет қаралды 13 М.
The Marketing Expert: How to Get More Sales, Loyal Customers, and Bigger Promotions
1:12:28
The Knowledge Project Podcast
Рет қаралды 428 М.
Owners Distributions: What You Need to Know
13:15
Clara CFO Group
Рет қаралды 3,5 М.
How to use a Cash Flow Forecast with a Case Study Example
19:36
Clara CFO Group
Рет қаралды 5 М.
Why Every Business Needs a Budget with Dave Ramsey
58:09
EntreLeadership
Рет қаралды 39 М.
Scary Teacher 3D Nick Troll Squid Game in Brush Teeth White or Black Challenge #shorts
00:47