Episode 44: Stop Guessing: How to Build a Business Budget in QuickBooks You’ll Actually Use
Can your business afford to hire, buy equipment or expand next year? A useful budget helps you answer those questions with a plan you can actually use.
In this episode of QuickBooks Mastery for Small Business Success, Erica Northrup and Lee Davis explain how to build a realistic business budget in QuickBooks—and how to use it throughout the year.
Drawing on a real client budgeting project, they discuss where to begin, how to use historical Profit & Loss information, why seasonal businesses should not automatically divide annual numbers by twelve, and how your Chart of Accounts affects the usefulness of your budget.
They also explore Budget vs. Actual: how to understand the story behind a variance, decide which differences need attention, and use your numbers to guide business decisions.
Planning for 2027? Download the free 2027 Business Budget Planning Worksheet in the Resources section to document your assumptions, draft your monthly budget and review your results.
00:00 QuickBooks Mastery Podcast Introduction
00:55 Episode 44: Stop Guessing — Build a Business Budget You’ll Actually Use
02:31 Does a Small Business Really Need a Formal Budget?
03:57 A Budget Is More Than a Spending Limit
05:22 Where to Start Building a Budget in QuickBooks
06:45 Why Last Year’s Numbers Are Only a Starting Point
09:07 Why You Shouldn’t Divide Your Annual Budget by 12
10:23 When Your Budget and Chart of Accounts Don’t Match
12:39 Building a Realistic Budget Instead of a Wish List
14:33 What Has to Happen for This Number to Be True?
15:06 The Real Value: QuickBooks Budget vs. Actual
16:46 Understanding the Story Behind a Budget Variance
17:44 Why Being Over Budget Isn’t Always Bad
18:28 How Often Should You Review Budget vs. Actual?
19:53 Should You Change the Budget Midyear?
21:09 The Questions to Ask During Every Budget Review
22:59 Turning QuickBooks Into a Decision-Making Tool
23:42 Your Practical First Step: Build the Budget
24:41 Focus on the Expenses That Actually Matter
25:21 Your Budgeting Homework for This Week
26:19 QuickBooks Clarity Scorecard
26:34 QuickBooks Mastery Program and Waitlist
26:56 Lee’s Final Advice on Budgeting
27:29 Episode Wrap-Up
27:45 Podcast Outro
Free 2027 Business Budget Planning Worksheet
Work through the planning questions from this episode, document your assumptions, build a twelve-month business budget and review your Budget vs. Actual results. The editable Excel workbook includes annual calculations, a monthly Revenue and Net Profit chart, and space to explain meaningful variances and decide what action is needed.
Download the free 2027 Business Budget Planning Worksheet (Excel)
Episode 6: How to Create a Budget in QuickBooks
Revisit our original budgeting episode for the foundations of creating and using a budget inside QuickBooks. Then use Episode 44 to go deeper into assumptions, seasonality and managing against the plan.
Free QuickBooks Clarity Scorecard
If you are not confident that the numbers already sitting in QuickBooks are accurate enough to build a budget from, begin with the free QuickBooks Clarity Scorecard.
Get the free QuickBooks Clarity Scorecard
QuickBooks Mastery Program Waitlist
Join the waitlist for our complete QuickBooks Mastery program and be the first to know when enrolment opens.
Join the QuickBooks Mastery waitlist
More Episodes and Support
Listen to QuickBooks Mastery for Small Business Success
Questions or support: [email protected]
Run your current year-to-date Profit & Loss and compare it with the same period from last year. Go back another year if it would help reveal longer-term trends.
Look specifically at revenue, cost of goods sold, gross profit, net profit, payroll and your largest operating expenses. Then ask what you reasonably expect to change next year.
Use the 2027 Business Budget Planning Worksheet to document your assumptions and build the first draft of your budget. Spread the numbers across the months when you realistically expect them to occur, then enter the plan into QuickBooks.
Make Budget vs. Actual part of your regular reporting process. When the results differ from the plan, ask why—and use the answer to decide what needs to happen next.
Subscribe to QuickBooks Mastery for Small Business Success, share this episode with another business owner planning for next year, and send your questions to [email protected].
Welcome to QuickBooks Mastery for Small Business Success.
Erica:I'm Erica Northrup.
Lee:And I'm Lee Davis.
Erica:I handle the tech, and he handles the numbers, and together
Erica:as a father-daughter team, we bring decades of experience helping small
Erica:to medium-sized businesses thrive.
Lee:We know that as a business owner, your time is best spent mastering
Lee:your craft and growing your business, not getting lost in QuickBooks.
Lee:Managing finances can be confusing, and you don't have hours to waste
Lee:sorting through spreadsheets or fixing bookkeeping mistakes.
Lee:That's where we come in, helping you streamline QuickBooks so you
Lee:can focus on building your business.
Erica:Each week, we break it all down into simple, actionable steps
Erica:so you can focus on growing your business, not fixing your books.
Lee:Let's embark on this journey together.
Erica:Mastery for Small Business Success.
Erica:I'm Erica Northrup, and I'm here with my papa, Lee Davis, the one, the only.
Erica:And I am so grateful that we are on this journey, that we are doing this,
Erica:that we are showing up every week for you, our listeners, and I'm so grateful
Erica:you have joined us on this journey.
Erica:So this is episode 44, Stop Guessing, How to Build a Business Budget in
Erica:QuickBooks You'll Actually Use.
Erica:Papa, we're getting towards the end of the year, which is a little freaky.
Erica:I mean, it just feels like it was the start of 2026, and here we
Erica:are, almost at the end of 2026.
Erica:Just so crazy.
Erica:Which means a lot of business owners are going to start thinking about next year.
Erica:What do we want to earn?
Erica:What are we going to spend?
Erica:Can we hire somebody?
Erica:Can we buy equipment?
Erica:Can we increase payroll?
Erica:Can we actually afford the plans we're making?
Erica:And I think a lot of small business owners answer those questions mostly
Erica:from instinct, but QuickBooks has a tool sitting right inside it that can help you
Erica:answer them with actual numbers, a budget.
Erica:And you've been working with a client recently on setting up and actually using
Erica:their budget inside of QuickBooks, so I thought this was the perfect time to talk
Erica:about it, with all that we're doing to help people actually plan for next year.
Erica:So let's start there, Papa, because I think when people hear budget,
Erica:they sometimes think of a giant corporation with a finance department.
Erica:Let's answer that question, Papa, for our listener.
Erica:Does a small business really need a formal budget?
Lee:You talked about the client that we are basing this podcast on because
Lee:when you go back to look at what they actually needed, they had an opportunity
Lee:to start their budget from square one.
Lee:So they really wanted a good budget.
Lee:It wasn't gonna be just an exercise.
Lee:It was gonna be a way for them to utilize the QuickBooks budgeting process and make
Lee:it useful for their board on the budget.
Lee:So I think as we talk about the budget, and you said about the benefits that
Lee:a, a budget can make and can be used for a business- It's tremendous because
Lee:lots of times boards or companies will use the budgeting form, the budgeting
Lee:report, as part of their monthly report.
Lee:So I think it is critical.
Lee:It is critical when you start and look at the budget and start estimating
Lee:your revenue, cost of goods sold, payroll, operating expenses, and
Lee:you think about major purchases-
Erica:Yeah
Erica:… Lee: and ultimately profit.
Erica:If you create a target, it forces you to think ahead.
Erica:Oh, absolutely.
Erica:You really think twice about, "Do I actually need to do that?"
Erica:Or, "Do I actually need to make that decision that's gonna cost me more money?"
Erica:Or whatever the case may be.
Lee:And really, Erica, a budget isn't just about limiting spending.
Lee:I think a budget can be part of the company culture-
Erica:Yeah
Erica:… Lee: where- Absolutely … you start saying, "Okay, so what does
Erica:the business want to accomplish?"
Erica:Yeah.
Lee:Both organizationally and then financially.
Lee:So a budget also helps you monitor your revenue and expenses through the year.
Erica:Yeah, absolutely.
Erica:You know, and that's an important distinction, Papa, because when most of
Erica:us hear the word budget, we think, "Here's everything I can't spend money on."
Erica:But for a business, you're really saying, "Here's where we think the
Erica:business is going, and here's what needs to happen financially to get there."
Erica:That's really what you're saying, isn't it, Papa?
Lee:Exactly.
Lee:And QuickBooks has several tools that can help you project your income and expenses.
Lee:You can certainly print out your profit and loss reports for the current
Lee:and past year, and you're able to analyze those costs and your revenue,
Lee:because there are some costs that seem to increase on a yearly basis.
Lee:And your revenue tracking might help you to say, "Okay, yeah, I think
Lee:the 5% or 7% increase in my revenues or based on contracts or whatever,"
Lee:gives you a good picture about what your budget might look like.
Erica:Absolutely.
Erica:Okay, so I'm a business owner.
Erica:I've never created a real budget in QuickBooks.
Erica:Papa, where do I start?
Lee:So QuickBooks has a budgeting tool built into it, and if you go into
Lee:the gear icon, that's where you start.
Lee:You click on that gear icon, and it will take you into the tools, the
Lee:company tools, and that's where you can actually begin with budgeting.
Lee:Mm-hmm.
Lee:And you can budget either based on a calendar year or a fiscal year, however
Lee:you normally- run your financials would be the way you set up your budget.
Lee:There's some questions you might ask.
Lee:What do you realistically expect your revenue to be?
Lee:What costs will be required to generate that revenue?
Lee:What recurring expenses do you know are coming?
Lee:Are these expenses that only happen during certain months?
Lee:Are you planning on any new hires or purchases or expansion?
Lee:Look at your profit and loss report, and if you like to make some changes
Lee:in your account structure, this is a good time to add an account
Lee:before you start on the budget.
Lee:Then QuickBooks becomes the place where you organize these assumptions.
Lee:It's many ways like a giant Excel sheet, really.
Lee:If that's really what it is, and QuickBooks has just turned
Lee:it into a budget process.
Erica:That makes a lot of sense.
Erica:Okay, so QuickBooks can use previous information when you're building a budget.
Erica:Should somebody simply take last year's numbers and use
Erica:those as the new budget, Papa?
Lee:No, not automatically.
Lee:Last year's are actual numbers, and they're an excellent starting point,
Lee:but a budget should reflect what you believe is going to happen next year.
Lee:So in some ways, I believe in zero-based budgeting-
Lee:Mm-hmm … meaning you start new.
Lee:If you want to work in Excel, like some of my clients do, on their first draft
Lee:of their budget just to see what it looks like, you can drop your profit
Lee:and loss statement into Excel, and you can play with it that way, especially if
Lee:you're considering some major changes.
Lee:The questions you wanna ask yourself again, I think, is
Lee:revenue expected to grow?
Lee:Have prices changed?
Lee:Are material costs changing?
Lee:I was just talking with one of our landscapers today, and gas has gone
Lee:up 100%- Mm … over last year.
Erica:Oh, man.
Erica:Yeah, crazy.
Lee:So it's doubled if not.
Lee:So a tank of gas that cost initially 140 is now costing 260.
Lee:His question was, "Okay, h- how does that affect what we need to budget?"
Lee:Think about pricing.
Lee:Do we need a fuel surcharge?
Lee:And these are real questions that you can look at when you're
Lee:seeing spikes in your expenses.
Lee:Are material costs changing?
Lee:For example, he also talked about salt.
Lee:Yeah.
Lee:Salt's gone up significant in price.
Lee:What do we do about that?
Lee:We have some fixed contracts.
Lee:Are wages going up?
Lee:Has rent increased?
Lee:Are insurance premiums changing?
Lee:Are there subscriptions in, or contracts that are renewing?
Lee:Are you hiring?
Lee:Are you gonna need to look at maybe increasing what you're paying your staff?
Lee:Are you eliminating something?
Lee:In other words, looking at your costs, are you gonna look at something
Lee:you need to make a reduction in?
Lee:And are you adding a new product or service?
Lee:A useful budget is based on reasonable assumptions, not
Lee:simply copying your history.
Erica:Absolutely.
Erica:Okay, so there's a difference between this is what happened last year and
Erica:this is what we believe is going to happen next year, isn't there, Papa?
Lee:Exactly.
Lee:That's really the purpose of budgeting.
Erica:Absolutely.
Erica:Okay, so there's something interesting in the recording you made while you were
Erica:actually entering a client's budget.
Erica:QuickBooks can take an annual amount and spread it evenly across 12 months,
Erica:which is extremely convenient, but that isn't always the way a business
Erica:actually operates, is it, Papa?
Lee:Yeah, that's true.
Lee:It does not operate that way.
Lee:Some businesses are seasonal.
Lee:Mm-hmm.
Lee:Some revenues may happen primarily in certain months.
Lee:Some expenses might occur quarterly, annually, seasonally, around an event.
Lee:During a busy production period or when a major purchase is planned.
Lee:So don't automatically divide every number by 12.
Lee:If the company expects 120,000 revenue for the year, that
Lee:doesn't mean 10,000 a month.
Lee:It could mean that's spread out.
Lee:Some cases it could be 6,000, or it could be 18, or it could be 20.
Lee:So the idea is the budget should resemble how the business actually operates.
Erica:Absolutely.
Erica:And that becomes really important later when you compare the budget to
Erica:the actual results, because otherwise you might think you're doing terribly
Erica:in February when February was always supposed to be a very slow month.
Lee:Exactly.
Erica:Yeah.
Erica:So good.
Erica:Okay.
Erica:So something else came up when you were building this client's budget.
Erica:Their budget had categories that didn't completely line up with
Erica:the accounts inside QuickBooks.
Erica:What happened, Papa?
Erica:Talk us through that.
Lee:Yeah.
Lee:This particular client- Mm … she took over a, an organization that she really
Lee:needed to get her hands around the operating expenses, and so she chose the
Lee:budgeting process to make that happen.
Lee:Mm.
Lee:And so she really attacked the profit and loss and said, "Okay, I need to know
Lee:what's in each account and what is charged to that account, and does that make sense?
Lee:And if not, then I need to move it over here, over to another
Lee:account, and make it a sub-account.
Lee:Or I need to make a whole separate account, and I need to name it
Lee:something else so that I can have a good feel when I present the numbers
Lee:each month to the board of directors."
Lee:She took the process and really ran with it, and it allowed us to go
Lee:ahead and reorganize the profit and loss according to what made sense
Lee:for the organization and for her.
Lee:So it, she wanted a budget and a report that actually worked for the way that
Lee:was appropriate for the organization.
Lee:That's why the chart of accounts matters.
Lee:Mm-hmm.
Lee:So I said, "If we're gonna make these changes, let's make
Lee:them for the new fiscal year."
Lee:Yeah.
Lee:"And don't try and get too many accounts, but make sure that, again, the profit and
Lee:loss works for how you want to use it.
Lee:And the goal is useful information."
Lee:For the end user
Erica:Yeah
Lee:And there are accounts that may need to be added or moved within the chart of
Lee:accounts to appear on the profit and loss statement under the appropriate account.
Erica:Yeah, and that's consistent with something you said
Erica:throughout this podcast, Papa.
Erica:Don't make QuickBooks more complicated than the business requires.
Erica:You have stated that so many times in so many different ways.
Erica:Most of the time it's just about simplifying, like boiling- Mm-hmm … it
Erica:down to what actually matters.
Lee:Yeah.
Lee:The chart of accounts should support the information the owner actually needs.
Erica:Yeah, absolutely.
Erica:And this may be the harder part, Papa.
Erica:Anybody can type numbers into boxes.
Erica:How do you know whether you've created a realistic budget instead of a wish list?
Erica:I mean, I've got some great big wish lists out there.
Erica:But- If you pull it down to reality, what does that really look like?
Lee:Well, I think you need to look at historical revenue and look
Lee:at your expenses, current trends.
Lee:If you've got new contracts, if you've eliminated some contracts or
Lee:you've made a decision that maybe this contract isn't profitable- Mm-hmm
Lee:then you need to have a good feel for what contracts are going into
Lee:the season, into a new budget season.
Lee:Understand what the costs of staffing are.
Lee:W- what's your pricing need to look like?
Lee:How much capacity do you have to take on new clients?
Lee:And then what are your plan changes, and what are your contingencies for price
Lee:increases or something that's seasonal?
Lee:You need to understand economic or industry changes that you
Lee:already know about, but be conservative in the budget process.
Lee:In other words, think on the high end of expense and the more
Lee:realistic low end of your income.
Lee:Mm-hmm.
Lee:And you need to ask what has happened operationally for this number to be true.
Lee:So in other words, if revenue's going from one million to 1.5,
Lee:where does the additional 500,000 come from?
Erica:Yeah, absolutely.
Lee:And you got more customers, higher prices, more volume,
Lee:new services, more staff.
Lee:You need to have a financial target in terms of how it
Lee:fits in the overall operation.
Erica:That is so true, and I think it really boils down to you
Erica:really looking at your business and thinking strategically, how can we
Erica:get to the point we wanna get to?
Erica:What is the solution for this new number that we need to obtain in
Erica:order to even sometimes just keep par with all the changes in prices and
Erica:things that are going on, for sure.
Erica:And you know, I love this question.
Erica:What has to happen for this number to be true?
Erica:Because if the answer is, "I don't know.
Erica:I just want revenue to go up 30%," that's not really a plan, is it, Papa?
Lee:That's right.
Lee:That's a wish list.
Erica:Yeah, absolutely.
Erica:I got a long one.
Erica:But, you know, and I think this might be the most important part of this
Erica:entire episode, so listen up, you guys.
Erica:A lot of businesses probably create a budget once, put it in a folder
Erica:somewhere, and never look at it again.
Erica:That's not really useful, is it, Papa?
Lee:No.
Lee:The real value begins after the budget is created, and that's where the
Lee:budget versus actual report comes in.
Erica:Yeah, absolutely.
Erica:So Papa, I would love for you to explain budget versus actual,
Erica:because you got pretty excited about this in your follow-up recording.
Erica:So break it down for us, Papa.
Lee:So QuickBooks has this great tool- And really, I don't think
Lee:people take advantage of it.
Lee:Yeah.
Lee:Because you can have a report that you can spit out monthly that says your
Lee:budget versus actual, and if you've put all your time into creating a realistic
Lee:budget, all right, just because maybe you took a weekend or maybe you took
Lee:two weeks- Yeah … and you did a lot of estimating on your budget, you really
Lee:felt like it would be a good opportunity to get down and dirty with the budgeting
Lee:process, then once you put it into the budget, you can now use it by comparing
Lee:your actuals to the budget you created.
Lee:And because you have good worksheets, you can go back and analyze, how
Lee:are we doing if you looked at it in three months or six months?
Lee:You can really look at those actual versus budgeted revenue and actual
Lee:expenses versus the budget, and you can see the dollar variance, and
Lee:you can see the percentage variance.
Lee:And then you can investigate meaningful differences because
Lee:you already have your worksheets.
Lee:Keep your worksheets when you're doing the budget process- Mm-hmm … 'cause it's
Lee:really helpful for both this year's budget and thinking about next year's budget.
Erica:Yes, absolutely.
Erica:I love how excited you get about this, Papa.
Erica:This is so good.
Erica:Okay.
Erica:So let's say we budgeted $50,000 in revenue for the
Erica:month and only did $40,000.
Erica:The useful question isn't simply we missed the budget, is it, Papa?
Lee:No, it's why.
Lee:What are the possible causes for revenue that you didn't hit the target?
Lee:It could have been fewer customers, lower sales volume, pricing.
Lee:It could be that it was delayed work.
Lee:You were actually gonna get that work, but it was delayed.
Lee:It could have been capacity.
Lee:It could have been seasonality.
Lee:It could be you lost a contract.
Lee:The same thing applies to expenses.
Lee:If payroll is 15% above budget, why?
Lee:Maybe that's bad, or maybe revenue is 30% higher and additional labor was required.
Lee:You have to understand the story behind the variance.
Erica:Absolutely.
Erica:The more powerful question, I think the most powerful question about
Erica:anything you can ask is really why.
Erica:That is so true.
Erica:Okay, so that's important, too.
Erica:Being over budget automatically sounds terrible, but it isn't
Erica:necessarily terrible, is it, Papa?
Lee:No, that's correct.
Lee:Hmm.
Lee:An expense over budget might be perfectly reasonable if it
Lee:helped create more revenue.
Lee:Hmm.
Lee:Likewise, being under budget isn't automatically good.
Lee:Maybe the marketing that should have gone out wasn't done, and
Lee:while that reduced the expense, it may have an impact on your revenue.
Lee:So it could be that revenue suffered.
Lee:The goal is you probably don't want to exceed the budget, but
Lee:you wanna understand why actual results differ from the plan.
Erica:That's so good, Papa.
Erica:Okay, so let's talk about how often we should be doing this.
Erica:So how often would you actually run budget versus actual, Papa?
Lee:Generally monthly.
Lee:You don't necessarily need to react to every variance, but you need to
Lee:look at the meaningful differences.
Lee:And then sometimes you wait a couple months, and you might look at it on a
Lee:quarterly basis before you think about maybe understanding some adjustments.
Lee:And so you might need to a- adjust operations where needed,
Lee:and you keep watching the trend.
Lee:And for some businesses or managers, more frequent internal tracking may be useful.
Lee:I was just talking with a client who was really concerned about his revenue
Lee:and needed to make some changes going into this year, and because clearly
Lee:his expenses Were higher to operate his business than he could sustain.
Lee:Mm-hmm.
Lee:So it was really important for him to start monitoring his revenue on
Lee:the budget monthly, if not weekly.
Lee:So he wanted to run his budget report on a weekly, which you can.
Lee:You can run your budget report for any- … amount of time you want.
Lee:Once it's created, you go for it.
Lee:So I think that you definitely can look at what works for various
Lee:companies and various owners.
Erica:Yeah, so good.
Erica:Okay, Papa, here's something I've always wondered.
Erica:Let's say you create the budget in December, then in
Erica:March something major happens.
Erica:Do you change the budget at that point?
Lee:I think the answer is no.
Lee:You maintain the original budget and forecasting.
Lee:If you continually rewrite it to match actual results, you lose
Lee:the ability to see what changed.
Lee:Really, the budget is, once it's created, it's not really a living document, okay?
Lee:It will live out by based on your profit and loss.
Lee:So when you're looking at your budget, you are simply making a forecast.
Lee:So think about it like that.
Lee:Budget equals original plan.
Lee:You might make some notes along the way on your worksheets that might help
Lee:you in forecasting your next budget.
Lee:Or you may write an underlying note to the board as it says, "Listen, we estimated
Lee:this, but this actually happened."
Lee:Mm-hmm.
Lee:So it's appropriate, and don't erase the history of what you originally expected.
Lee:Absolutely.
Lee:But that's a great question, Erica, 'cause some people think they,
Lee:the budget is a living document.
Lee:No, a budget is like the balance sheet.
Lee:It's at a point in time, okay?
Erica:Okay.
Erica:Yes.
Erica:So helpful, Papa.
Erica:Always so helpful.
Erica:Okay, so if somebody takes your advice and starts running a budget verse actual
Erica:report every month, what are the big questions you want them asking, Papa?
Lee:I think you wanna keep looking at this, and you wanna understand,
Lee:because sometimes it's communication.
Lee:Because when people review the budget, they have questions, right?
Lee:So you wanna anticipate those questions.
Lee:You wanna have gone over your budget versus actual before you present
Lee:it to your board and give them the overall highlights, 'cause they won't
Lee:have time, or the CEO, or whoever the end user is, they're not gonna
Lee:necessarily understand the backstory.
Lee:So you wanna have some budget notes.
Lee:So I think that's really important when you think about using the budget.
Lee:And the questions you wanna ask, are sales where we expect them to be?
Lee:Are our- Mm … gross margins where they should be?
Lee:Is payroll in line with the plan?
Lee:Which expenses are meaningful above budget?
Lee:Don't dwell on something that's $100 over the budget, okay?
Lee:Look at a number that's meaningful.
Lee:Which expenses are below budget and why?
Lee:And again, it could be the marketing plan that's delayed, and the board
Lee:may say, "Listen, get that marketing plan done, and we want that expense in
Lee:so we can meet our revenue targets."
Lee:So again, if something's changing month after month, then yeah, that's
Lee:probably important to put a note in, because you may wanna say, "Okay,
Lee:we've made some midyear adjustments based perhaps on our pricing.
Lee:Can we afford to really make that next hire or purchase?
Lee:Does our current performance support the goals we set?"
Lee:So I think those are all very good questions and good responses
Lee:to how you might use the budget.
Erica:Yeah, absolutely.
Erica:And this is where I think the bigger QuickBooks Mastery
Erica:idea comes in again, right?
Erica:QuickBooks Shouldn't simply tell you what happened.
Erica:That's valuable, but the real power is when you can use what happened to
Erica:help decide what should we do next.
Erica:A budget gives you a plan.
Erica:Your actual QuickBooks data tells you what happened, and budget versus
Erica:actual shows you the gap between the two, and that gap is where some of the
Erica:most useful business questions live.
Erica:Absolutely.
Erica:Okay, so let's give everybody something really practical to do,
Erica:Papa, 'cause you know I'm all about let's apply what- Mm-hmm … we're
Erica:learning to our actual business.
Erica:I just don't want you consuming.
Erica:I want you actually putting this stuff into practice.
Erica:If someone listening has never created a budget in QuickBooks, what would
Erica:you have them do this week, Papa?
Lee:I'd have them run their profit and loss for nine months, and
Lee:compare that to previous nine months.
Lee:And in some ways, if you want to go back and do it for three years,
Lee:and put it on an Excel spreadsheet.
Lee:Mm-hmm.
Lee:Okay, dump those numbers into an Excel spreadsheet, and it would begin to
Lee:start to look at some trends or things that you want to pay attention to.
Lee:Okay, so again, the profit and loss would be extremely helpful, and you
Lee:could look at revenue, you could look at your cost of goods sold.
Lee:You want to look at your gross profit, okay, and your net profit.
Lee:And you want to look at your major operating expenses.
Lee:I often say break down your operating expenses highest to lowest.
Lee:Don't spend time on your lower operating expenses.
Lee:That's not really where you're gonna get your biggest bang for your buck.
Lee:Look at your large expenses and see what story they tell.
Lee:Mm-hmm.
Lee:And then ask yourself what kind of changes are you expecting for next
Lee:year, and build the first version.
Lee:And you can build it in Excel.
Erica:Yep.
Lee:If, because you've dumped some work into Excel.
Lee:And then so when you move it into QuickBooks, it can give you
Lee:the first version of your budget that you can share with whoever
Lee:the, the board or the end user.
Erica:Yep.
Erica:Who are your shareholders in your business?
Erica:We all have shareholders in our business.
Erica:Even if those shareholders- True
Erica:are your family, they still need to know what's going on.
Lee:Right.
Erica:So good.
Erica:Okay, you guys, our listeners, our beloved listeners.
Erica:So your homework this week is pretty simple.
Erica:Don't wait until the end of next year to find out whether the year
Erica:went the way you wanted it to go.
Erica:Decide what you want the numbers to look like before the year begins.
Erica:Build the plan, put it into QuickBooks, then come back every month and
Erica:compare the plan with reality.
Erica:Use this report as part of your standard reporting each month.
Erica:And when they're different, don't just say, "We're over budget.
Erica:Oh, well."
Erica:Ask why, because the answer is where the actual business decisions live.
Erica:So good.
Erica:And if you're listening to this and thinking, "I don't even completely
Erica:trust the numbers already sitting in my QuickBooks, never mind trying
Erica:to build a budget from them," this is where you need to start.
Erica:If you're new around here, you may not have heard me talk about this,
Erica:but if you have and you haven't done this, what are you waiting for?
Erica:Start with our free QuickBooks Clarity Scorecard.
Erica:It will help you figure out where your QuickBooks currently stands
Erica:and where you may have some gaps.
Erica:I'll link it in our show notes, and you can also find it at leedavisoncompany.com.
Erica:And we're continuing to build QuickBooks Mastery, our complete program designed
Erica:to help business owners understand their numbers, build better QuickBooks
Erica:systems, and actually use QuickBooks to make better business decisions.
Erica:You can join the wait list on our website at leedavisoncompany.com,
Erica:and you'll be the first to know when it opens.
Erica:So Papa, one last question.
Erica:If you could convince a business owner to change one thing about the way they think
Erica:about budgeting, what would it be, Papa?
Lee:I'd say don't consider it a waste of time.
Lee:Make it valuable.
Lee:Use it as a tool and sharpen it.
Lee:And then because a budgeting process can be something you do year over
Lee:year and you get better at it.
Erica:Yeah.
Lee:So like anything- I love that … put some time into it.
Lee:It will reward you in the end.
Erica:Yeah, just start.
Erica:It doesn't have to be perfect.
Erica:Right.
Erica:Just start.
Erica:That's what it comes down to.
Erica:Yeah.
Erica:So good.
Erica:Okay, you guys, thank you so much for listening to QuickBooks
Erica:Mastery for small business success.
Erica:Make sure you're subscribed so you don't miss next week's episode,
Erica:and we'll see you next time.
Erica:Bye for now.
Erica:Thanks for tuning in to QuickBooks Mastery for small business success.
Lee:If you enjoyed this episode, hit subscribe and stay connected
Lee:with us at leedavisoncompany.com.
Erica:We know QuickBooks can be overwhelming, so we've put
Erica:together a free resource to help you get started right away.
Erica:Grab your copy at leedavisoncompany.com,
Erica:and when you do, you'll also get access to our VIP email list where
Erica:we share exclusive QuickBooks tips, business strategies, and support.
Lee:And we'd love to hear from you.
Lee:If you have a QuickBooks question or a business challenge, send it our
Lee:way at [email protected].
Lee:We might feature it in a future episode.
Erica:We're here to help you simplify QuickBooks and grow
Erica:your business one step at a time.
Erica:See you next time.