Тёмный

How to Create a Business Budget from Scratch in Excel 

Clara CFO Group
Подписаться 82 тыс.
Просмотров 13 тыс.
50% 1

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

Опубликовано:

 

30 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 24   
@GeovannysMusicProd
@GeovannysMusicProd Месяц назад
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!
@safeershahid9150
@safeershahid9150 2 месяца назад
Thank you for making this tutorial. This tutorial is exceptional please provide excel files so we practice along with the tutorial as well.
@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 5 месяцев назад
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.
@Tuckeratwork
@Tuckeratwork 2 месяца назад
This was a great video!! Gained a lot of knowledge on how to predict and estimate revenue and expenses.
@user-mx4sx4or9p
@user-mx4sx4or9p 4 месяца назад
Incredible that this info is free. Thank you!!!
@ClaraCFO
@ClaraCFO 4 месяца назад
Glad it was helpful!
@user-sv4kk2ew7p
@user-sv4kk2ew7p 8 месяцев назад
I got certified QBO Proadvisor 😍🥰 Thanks to all of your content 😋
@ClaraCFO
@ClaraCFO 8 месяцев назад
congratulations!
@princesserica718
@princesserica718 Месяц назад
Awesome! Very helpful. thank you!
@ClaraCFO
@ClaraCFO 27 дней назад
Glad it was helpful!
@SandyH-xe7ms
@SandyH-xe7ms 3 месяца назад
Thank you!
@marinamanan6070
@marinamanan6070 Месяц назад
This was helpful...😃
@user-th4fw8uc6y
@user-th4fw8uc6y Месяц назад
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 6 месяцев назад
Awesome , please I need the excel file
@sallygalbudgeting
@sallygalbudgeting 3 месяца назад
Why are the merchant fees so much more in the projected year?
@ClaraCFO
@ClaraCFO 3 месяца назад
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 3 месяца назад
@@ClaraCFO okay that’s what I thought too! Wasn’t sure if I missed something…thanks for clarifying!
@amnewt1640
@amnewt1640 4 месяца назад
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 4 месяца назад
Oh gosh never mind. I needed to enable editing.
@ClaraCFO
@ClaraCFO 4 месяца назад
Happens all the time!
@user-it2qh2ff8d
@user-it2qh2ff8d 4 месяца назад
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
Просмотров 5 тыс.
Ummmm We "HAIR" You!
00:59
Просмотров 13 млн
Excel Tutorial for Beginners
16:17
Просмотров 1,6 млн
Owners Distributions for Taxes
11:57
Просмотров 1,7 тыс.
Are Owner's Draws Taxable? Common Questions Answered!
16:14