13 Steps to Become the MacGyver of Small Business Budgeting

By January 5, 2017 January 25th, 2017 Tips to Improve Performance

Last Updated on January 25, 2017 by Dave Schoenbeck

Budgeting is not a sexy topic for many people. Yet it determines the livelihood of any business. In other words, you must understand the art of small business budgeting if you want your venture to be a successful one.small business budgeting

As the year is about to end, I recommend that you start tallying this year’s financial results and projecting what you expect to happen when the new year arrives. This is an extremely important task that if done well, will bring great clarity and helps you craft effective strategies.

Here are the fundamental steps to establish your small business budget:

13 Steps to Small Business Budgeting

1. Export your QuickBooks year-to-date profit and loss statement to Excel.
This is a fairly simple step in small business budgeting. Your Excel worksheet will give you the modeling tool to project and decide if your business will be profitable enough to pay yourself what you’re worth.

2. Make a list of all your assumptions for the upcoming year.
Though time-consuming, this step is critical to your small business budgeting process. Ask yourself questions like:

● What is your expected sales increase and gross margin increase?
● What significant initiatives do you need to achieve in next year?
● Are you planning any new products or services?
● Is your rent going up?
● What is your forecast for health insurance?
● Do you need to hire new staff?
● What is your wage increase expectation?
● How will you spend your marketing dollars?
● What equipment or technology do you need to buy?
● How much does your inventory need to grow?
● What is the inflation rate for expenses?

Write an assumption for each line on your chart of accounts.

3. Dig further into your sales and gross margin history.
Sales and margin projections are much more complex and need further analysis. Break down your projections to make it simpler:

● Who were your customers this year and what was your customer retention rate like?
● What’s the worth of your average sale?
● What new customers are you going after?
● How will you decrease your cost of goods sold or increase your margin?

Overall, these essential small business budgeting questions should help you determine what needs to change in order for you to drive profits.

4. Create at least one strategy for each assumption that will ensure you attain your goal.
Wishing something to be true doesn’t make it happen. Detailing assumptions without a thorough plan for execution isn’t good enough. Therefore, you need at least one strategy to hit each of the numbers you’ve set out in your small business budget.

5. Calculate your average month for each line of the profit and loss statement.
Initially, I find it helps to think in monthly numbers. When it comes to small business budgeting, keep things as simple as you can so you don’t start to feel overwhelmed.

6. Annualize the average for each line if you don’t have a full year.
Even if you don’t have a full year of data to work with, you can still make projections for next year. Find the average of the months you do have, then multiply that amount by 12.

7. Review your assumptions list and project your new average month.
If you have a budgetary goal set for each month and a strategy for how to attain those goals, you can develop a lower risk estimate for average months next year. Many of my clients work with a best case, mid case, and worst case estimates.

8. Add a column for each month in your budget worksheet and input the averages across.
If an average doesn’t look accurate, load up the months with more realistic estimates. For instance, rent is easy because it should be the same each month. But if you anticipate needing to buy computer equipment, the expense should be added to the month in which you expect it to occur.

This can be hard to predict sometimes, but it’s better to budget for things before they happen than to be surprised by things you’re unprepared for.

9. Include a comment and strategy column in your worksheet for each of your assumptions.
It’s a good idea to give yourself a place to keep notes. If you don’t jot down some details, you may forget how you came up with the projections when looking back later.

10. Thoroughly review your work.
It’s important to take a good look at everything you’ve done before deeming it “complete.” Did you include everything? Did your profit projection meet your expectations? If not, you need to go back to your assumptions and estimations. Think carefully about everything that needs to change.

11. Load the new budget into QuickBooks.
When your monthly budget totals are in your software, your monthly financial review will show a comparison of what you budgeted versus what you’re actually spending. Any variance between the two should push you to take action and identify the reasoning for the difference.

12. Hire a professional business coach to help achieve your plans, goals, budgets, and strategies.
Seeking professional help is a good idea when you need fresh perspectives on small business budgeting, and useful tips on how to better operate your business.

13. Enjoy success!
If you don’t invest the time to make a plan, you can’t measure your true success. Laying out guidelines is the best way to set yourself up for a great year.

Small business budgeting can be a lengthy, even daunting process. However, its importance is undeniable.

If you’re looking for additional help with small business budgeting for the new year, I offer a free one-hour coaching session. Just fill out the contact form and I’ll be in touch.

Dave Schoenbeck
Follow Dave