November 11, 2020 en_US Learn how to use a small business budget template to plan your company finances. Read about using your budget to make informed business decisions. https://quickbooks.intuit.com/cas/dam/IMAGE/A9HKA2u81/Business-budget-hero.jpg https://quickbooks.intuit.com/r/accounting-finance/small-business-budget-template/ How to create a small business budget: Guide + template

How to create a small business budget: Guide + template

By Ken Boyd November 11, 2020

Running your own business presents unique opportunities for you to be your own boss, bring your entrepreneurial vision to life, and direct your financial future. But to avoid being among the 20% of small businesses that fail within their first year, you’ll want to work behind the scenes.

Creating a business budget is an excellent first step for any new business owner. By taking a closer look at your assets, expenses, and financial goals, you can craft a better plan for the future of your booming business. And ideally, you can reap some of the monetary benefits.

Let’s take a closer look at how to create a business budget and discuss the benefits of budgeting. You might even find some helpful business budget resources. With the right tools and processes, you can use business budgeting to your advantage.

What is a business budget?

Business budget definition pull-quote.

A business budget is an outline of an organization’s revenue, expenses, and profit over a period of time—generally, monthly, quarterly, or annually. A good business budget assigns a purpose to every dollar your business earns. For instance, some money might go toward bills or business growth. Others will help fund daily operational expenses and take-home pay for yourself and your staff.

A solid business budget serves as a road map for spending and earning. It creates a lens into your organization’s financial future and facilitates better decisions all around. Ready to get your business idea off the ground? You’ll need to consider startup costs. Wondering if you can or should purchase new equipment this year? Refer to your business budget.

Maybe you’re looking for ways to cut down on expenses. Your business budget can present a view of your financial health, including where you’re spending money and where you might benefit from cutting back. With better foresight, you can cultivate better business performance and improve earnings from the last quarter or the last year.

39% of small businesses have an annual business budget.

Benefits of budgeting for your business

The benefits of budgeting may be obvious to some. But a recent study suggests that not all business owners are completely convinced, especially those who may have just started a new business. The survey revealed that nearly 61% of small business owners didn’t create a budget for the 2018 fiscal year. And only 26% of organizations with 1-10 employees formulated a business budget. Many financial and business experts would classify this as a misstep.

“A business budget is a financial road map to success, a vision of where you want to take your business for the upcoming 12 months,” the FDIC says. What’s more, research has suggested that business budgets offer the following benefits:

  • They give business owners more freedom to run their organizations with confidence.
  • They allow business owners to identify cash flow and spending problems.
  • They empower business owners to have a greater sense of control and insight when dealing with financial challenges.
  • They help business owners and decision-makers predict cash flow and identify trends.
  • They demonstrate positive money management to lenders and investors.
  • They give you the chance to identify and rectify problem areas quickly.

Bottom line: Consider a detailed budget as one of your key business needs.

What’s included in a business budget?

A business budget takes into account an organization’s total revenue and expenses to reveal net profit (or loss). The FDIC says the best business budgets comprise the “nuts and bolts” everyday revenue and expenses like:

  • Average order amount
  • Number of product orders per month
  • Billable hours
  • Average payroll costs
  • Material expenses
  • Rent, mortgage, and utilities

When building a business budget, business owners should bear in mind that output depends on input. Make sure you’re collecting accurate data points whenever you’re dealing with your business’s finances. A simple mathematical error or expense can lead to confusion or, worse, uninformed financial decisions.

How to create a business budget

Now you know what a business budget is, why they’re important, and the essential components of a good budget. So let’s take a look at the steps you need to take to create one.

1. Calculate all forms of income

Whether you’re optimizing your personal spending or building a business budget, your first step should be aggregating all of your forms of income. Your net income determines how much you can afford to spend. And it indicates your take-home pay and whether your business performance is growing or stagnating.

To find out how much money your business is bringing in, refer to your profit and loss statements. Depending on your business model, you may have several income sources, so be sure to include any revenue streams in this section.

2. Subtract your fixed expenses

Once you’ve added all of your business’s income together, you can subtract your fixed costs. Fixed costs are expenses that remain consistent throughout the year. Whether you pay bills monthly, weekly, or annually, you can expect to spend a set amount of dollars on each expense. These costs are easy to predict, so they’re easy to work into your budget. The one-off expenses, or variable costs? Not so much—more on that in a minute.

Examples of fixed expenses include:

  • Commercial rent or mortgage
  • Operational utilities
  • Loan payments
  • Insurance bills
  • Employee salaries

Once you’ve tallied up your fixed expenses, you can subtract that number from the total income you calculated in step one.

3. Subtract your variable expenses

In addition to your fixed costs, you might anticipate monthly operating expenses that may not always be the same amount. These variable expenses may be harder to predict, but you can refer to old receipts and invoices to estimate them.

Examples of variable expenses include:

  • Material costs
  • Commissions
  • Billable staff wages (i.e., freelancers, outsourced work)

After identifying your variable expenses and estimating how much they cost each month, subtract the amount from your income.

4. Prepare for emergency and one-time expenses

Life is full of unexpected circumstances. As a business owner, you’re likely familiar with unexpected expenses. New equipment, hiring expenses, and unplanned events can add up, so it’s wise to plan ahead as much as you can.

You can’t predict when you’ll need to pay for an emergency expense or how much it might cost. But you can set aside some cash to lessen the burden.

5. Create a profit and loss statement

You’ve accounted for your income and fixed, variable, and emergency expenses. Now you can better understand your business finances by creating a profit and loss (P&L) statement. A P&L statement is a high-level overview that shows whether your organization is profitable or in the red.

When you add up all of your income then subtract your total expenses, you should have a positive or negative number. A positive number indicates that you’re in the black and, therefore, making money. A negative number indicates that you’re burning a hole in your pocket.

Your P&L statement serves as a baseline for creating your business budget. You can access your profit and loss statement, track trends, monitor invoices, and more from your QuickBooks account.

Keep in mind, your profit and loss statement may not always show you the results you want. But with better business budgeting and forward-thinking, you can set yourself up for a brighter and more profitable future.

6. Draft your business budget

After reviewing your P&L statement, you’ll have a better idea of where you’re spending your money—and if you’re spending responsibly. With this data in mind, you’re ready to draft your business budget for the next year, quarter, or month. Most businesses opt for quarterly budgets.

A basic budget outlines your expenditures and designates limits for each over a given period. This outline can help you determine whether you’re earning and spending within your abilities. With QuickBooks, you can glean insight into spending patterns and assess where your business stands financially.

Specialized small business budgets

Every small business has a niche, workflow, and financial goals. So it’s important to remember that there’s no one-size-fits-all approach to business budgeting. As you learn how to build a business budget and experiment with the strategies you’ve learned, consider the following:

  • Seasonality may affect customer buying behaviors, depending on your business type. Consider these fluctuations in profit and expenses as you plan your budget.
  • If you run an e-commerce business, beware of hidden costs like shipping fees, website upgrades, and point-of-sale expenses.
  • Budgeting for a startup can be especially challenging because they’re typically much more limited on data and performance history. But accurate accounting software and conservative estimates can help you improve your business budget year after year.
  • If you run a service-based business, you’re working with more estimates than a product-focused business. Keep an eye on trends to make sure your budget has plenty of wiggle room.

Best practices for business budgeting

A great business budget creates a clear connection between your day-to-day operations and financial resources. It can help you navigate tough business decisions and even help you identify areas for growth. But an effective budget doesn’t happen overnight. As you create and reflect on your business budget, keep these small business budget best practices in mind.

  • One change in expenses or income trickle down to your budget. Hiring a new employee doesn’t just mean you’re adding another salary. It can also translate to changes in payroll taxes, benefits, and other expenses. Anytime you adjust your business budget, consider other associated costs.
  • Make sure that you’re budgeting for all expense categories, including fixed, variable, and one-off expenses. Anticipating these costs can help you balance your business budget and plan ahead. Track your business expenses effortlessly and accurately using QuickBooks.
  • View your business budget as a living document. Financial circumstances change, and the unexpected happens. Your business should always be prepared to weather the storm. Review your financial statements regularly, reconsider your costs and spending, and refine your business budget as necessary.
  • Set goals but avoid wishful thinking. Use your bookkeeping records to determine what might transpire over the next month, quarter, or year. But ultimately, it’s a better idea to be conservative with your budget than expect the best-case scenario.
  • Look out for ways to cut costs and create growth. As a business owner, it’s up to you to position your business for greatness. Break down your finances into areas of success and improvement. Spotting opportunities to improve your business finances can make your organization more profitable and sustainable in the long run.

Download a free small business budget template for Excel

Use our free Excel template to develop a budget for your business. The budget template uses an example budget from an imagined business, “Widget Inc.,” to help guide you through the process of creating a business budget.

Download Microsoft Excel business budget template

How to use the Excel budget template

1. Enter prior year information

Input the year-end balance sheet and income statement into your Excel template.

Equity is the difference between assets and liabilities. Equity is the true value of your business. The $10,000 net income in the income statement increases equity in the year-end balance sheet.

2. Forecast future sales and costs

Next, we’ll make some assumptions for the upcoming year. In this example, Widget Inc.’s budget accounts for changes in sales, cost of sales, employee payroll costs, and other expenses.

Some accounting transactions, however, are unusual and cannot be included in a budget. For example, Widget Inc. had a $5,000 loss on the sale of equipment in the prior year.

Widget Inc.’s primary business is manufacturing and selling widgets, and the sale of equipment is not part of its annual budget. Accountants refer to these transactions as non-operating income and losses because day-to-day business operations don’t generate them.

3. Create a budget income statement

Widget Inc. produces a budget income statement using the assumptions in step 2. Note that the Widget Inc. budget has a line item for gain or loss on sale, other revenue. While the company may have an actual transaction in the category, this line has a zero budget.

4. Create a budgeted balance sheet using assumptions

The budgeted balance sheet includes assumptions that address each of the line items in the report. The budget provides percentage increases or decreases from the prior year, and two categories have no change.

5. Create a budgeted cash roll-forward for January

A cash roll-forward report lists your beginning cash balance, expected cash inflow and outflows, and your ending balance in cash for each month of the year.

The balance sheet and the income statement are financial statements, but the cash roll-forward is an informal, internal report. The statement of cash flows generates as part of your financial statements, but a cash roll-forward is more useful for budgeting purposes.

Business owners should create cash roll-forwards last because they need a cash projection for each month. Step 5 presents the cash roll-forward for January. You’ll see that the beginning of January cash balance ($10,000) is the year-end cash balance in the prior year balance sheet.

The majority of cash collections are from sales, and the bulk of cash payments are for inventory. When a business sells inventory, the dollar amount transfers to the cost of sales, which is the largest expense in the budget. So it makes sense that the biggest cash outflow is for inventory.

Widget Inc. assumes that cash received for sales and the cash paid for inventory evenly distribute over 12 months. In reality, the payments will be uneven, but the cash inflows and outflows can be difficult to predict by month.

The budget also includes miscellaneous receivables collected in cash and other cash payments, such as payroll costs.

6. Budgeted cash roll-forward for February, other months

The beginning cash balance for February ($10,500) is the ending cash balance for January, and this connection applies to each month of the year. The February cash budget uses some of the same assumptions for sales and inventory purchases. The ending cash balance for February is also the March beginning cash balance.

Widget Inc. continues this same cash roll-forward process until the company has a cash budget for each month.

Business budgeting with QuickBooks

Building a business budget can feel like an overwhelming process. But it’s an essential one if you want to have an edge on the competition, maintain financial stability, and move your business forward.

QuickBooks features tools like automated cash flow forecasting, a business debit card integrated with your accounting software, and budget envelopes, making it easy to manage your business finances. Explore our product features to learn more.

This content is for information purposes only and should not be considered legal, accounting or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Intuit Inc. does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Intuit Inc. does not warrant that the material contained herein will continue to be accurate nor that it is completely free of errors when published. Readers should verify statements before relying on them.

We provide third-party links as a convenience and for informational purposes only. Intuit does not endorse or approve these products and services, or the opinions of these corporations or organizations or individuals. Intuit accepts no responsibility for the accuracy, legality, or content on these sites.

Rate This Article

This article currently has 11 ratings with an average of 2.0 stars

Ken Boyd is a co-founder of AccountingEd.com and owns St. Louis Test Preparation (AccountingAccidentally.com). He provides blogs, videos, and speaking services on accounting and finance. Ken is the author of four Dummies books, including "Cost Accounting for Dummies." Read more