Artwork for podcast QuickBooks Mastery for Small Business Success
Episode 44: Stop Guessing: How to Build a Business Budget in QuickBooks You’ll Actually Use
Episode 44 • 7th October 2026 • QuickBooks Mastery for Small Business Success • Erica Northrup & Lee Davis
00:00:00 00:30:05

Share Episode

Shownotes

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.

Key Takeaways

  • A business budget is a financial plan for what the business wants to accomplish.
  • Begin with historical Profit & Loss information, but do not automatically turn last year’s actual numbers into next year’s budget.
  • A useful budget reflects reasonable assumptions about revenue, pricing, costs, staffing, contracts, capacity and business changes.
  • Ask: What has to happen operationally for this number to be true?
  • Revenue and expenses should be placed in the months when they are actually expected to occur.
  • Do not automatically divide every annual budget number by twelve, especially in a seasonal business.
  • Your Chart of Accounts should support the information you actually need from the budget and Profit & Loss.
  • Budget vs. Actual turns the budgeting process into an ongoing management tool.
  • Being over budget is not automatically bad, and being under budget is not automatically good. The important question is why.
  • Investigate meaningful variances rather than simply labelling them as over or under budget.
  • Make Budget vs. Actual part of your monthly reporting process, with more frequent tracking when your business needs it.
  • Keep the original budget intact so you can see how reality differed from what you originally expected.
  • Budgeting becomes more useful each year as your assumptions, systems and review process improve.

Questions to Reflect On

  • What do you realistically expect revenue to be next year?
  • What has to happen operationally for that revenue number to become reality?
  • What costs will be required to generate that revenue?
  • Which expenses are recurring monthly, quarterly, annually or seasonally?
  • Are material costs, fuel, wages, rent, insurance or subscriptions changing?
  • Are you planning new hires, equipment purchases, expansion or new services?
  • Which months are naturally stronger or slower for your business?
  • Does your Chart of Accounts give you the information you actually need?
  • Which expenses have changed significantly during the past year?
  • If revenue increases, does your business have the capacity to deliver the additional work?
  • Which Budget-vs.-Actual differences are meaningful enough to require action?
  • Does your current performance support the hires, purchases and goals you are considering?

Chapters

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

Mentioned in This Episode

  • QuickBooks budgeting tools and Profit & Loss reports
  • Calendar-year versus fiscal-year budgeting
  • Historical financial information and zero-based budgeting
  • Revenue assumptions, pricing and capacity
  • Cost of goods sold, payroll and staffing
  • Material, fuel, wage, rent and insurance increases
  • Subscription and contract renewals
  • Seasonal revenue and expenses
  • Chart of Accounts structure, budget categories and subaccounts
  • Budget vs. Actual reports, dollar variances and percentage variances
  • Monthly, quarterly and more frequent budget reviews
  • Keeping the original budget intact
  • Using Excel as a first-draft budgeting tool
  • The free QuickBooks Clarity Scorecard
  • The upcoming QuickBooks Mastery program

Resources

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.

Listen to Episode 6

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

Visit Lee Davis & Company

Questions or support: [email protected]

Your Practical Next Step

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].

Transcripts

Erica:

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.

Links

Chapters

Video

More from YouTube