A How-To Guide for Creating a Small Business Budget

By Amanda Smith on July 13, 2018

It’s no exaggeration when people say “every penny counts.” Just ask the guy who cashed in $5,000 in literal pennies. If you’re not planning (and tracking) where your dollars and cents end up each month, you’re missing valuable opportunities for cutting costs and putting money where it will have the biggest impact.

Creating a budget is the only way to see if you’re spending money the way you *think *you are. Not sure where to start? We’re here to help, with (hopefully) the only guide you’ll ever need for creating a budget for your business.

What is a business budget?

A budget is a detailed plan that outlines where you’ll spend your money monthly or annually.

You give every dollar a “job”, based on what you think is the best use of your business funds, and then go back and compare your plan with reality to see how you did.

A budget will help you:

  • Forecast what money you expect to earn

  • Plan where to spend that revenue

  • See the difference between your plan and reality

Cartoon illustration of an income statement

Do Your Own Bookkeeping with an Excel Income Statement Template

Enter your transactions into this Excel template, and voila! You get a ready-made Income Statement. Perfect for entrepreneurs who aren't ready for full-fledged accounting software.

What makes a good budget?

The best budgets are simple and flexible. If circumstances change (as they do), your budget can flex to give you a clear picture of where you stand at all times.

Every good budget should include seven components:

1. Your estimated revenue

This is the amount you expect to make from the sale of goods or services. It’s the cash you bring in the door regardless of what you spent to get there. This is the first line on your budget. It can be based on last year’s numbers, or based on industry averages if you’re a startup.

2. Your fixed costs

These are all your regular, consistent costs that don’t change according to how much you make—things like rent, insurance, utilities, bank fees, accounting and legal services, and equipment leasing.

3. Your variable costs

These change according to production or sales volume, and are closely related to “costs of goods sold”, i.e. anything related to the production or purchase of the product your business sells. This might include raw materials, inventory, production costs, packaging, or shipping. Other variable costs can include sales commission, credit card fees, and travel. A clear budget plan outlines what you expect to spend on all these costs.

The cost of salaries can fall under both fixed and variable costs. For example, your core in-house team is usually associated with fixed costs, whereas production or manufacturing teams—anything related to production of goods—are treated as variable costs. Make sure you file your different salary costs in the correct area of your budget.

4. Your one-off costs

One-off costs fall outside the usual work your business does. These are startup costs like moving offices, equipment, furniture, and software, as well as other costs related to launch and research.

5. Your cash flow

This is all the money travelling into and out of a business. You have positive cash flow if there is more money coming into your business than going out, over a set period of time. This is most easily calculated by subtracting the amount of money available at the beginning of a set period of time and at the end.

Since cash flow is the oxygen of every business, make sure you monitor this weekly, or at least monthly. You could be raking it in, but not have enough money on hand to pay your suppliers.

6. Your profit

Profit is what you take home after all your expenses are deducted from your revenue. Growing profits mean a growing business. Here you’ll plan out how much profit you plan to make, based on your projected revenue, expenses, and cost of goods sold. If the difference between revenue and expenses (aka “profit margins”) aren’t where you’d like them to be, you need to rethink your cost of goods sold, and consider raising prices.

Or if you think you can’t squeeze any more profit margin out of your business, consider boosting the Advertising and Promotions line in your budget to increase total sales.

7. A budget calculator

This is a helpful tool to see exactly where you stand when it comes to your business budget planning. It might sound obvious, but getting all the numbers in your budget in one easy-to-read summary is really helpful.

In your spreadsheet, create a summary page with a row for each of the budget categories above. This is the framework of your basic budget. Then next to each category, list the total amount you’ve budgeted. Create another column to the right—when the time period ends, use it to list the actual amounts spent in each category. This gives you a snapshot of your budget that’s easy to find without diving into layers of crowded spreadsheets.

See the sample below.

Income Budget Actual Under/Over
Sales - Product 1 $25,000 $22,000 -$3,000
Sales - Product 2 $34,000 $36,000 +$2,000
Revenue - Coaching $9,000 $8,900 $-100
Revenue - Sublease $13,000 $13,000 $0
Total $81,000 $79,900 -$1,100
Expenses Budget Actual Under/Over
Cost of Goods Sold $12,000 $13,243 +$1,243
Rent $36,000 $36,000 $0
Wages $15,423 $15,200 $-223
Office Move $3,000 $3,300 -$300
Total $66,423 $67,743 $+720
Profit Budget Actual Under/Over
Total $14,577 $12,157 $2,420

Pro tip: link the totals on the summary page to the original sums in your other budget tabs. That way when you update any figures, your budget summary gets updated at the same time. The result: your very own budget calculator.

Cartoon illustration of an income statement

Do Your Own Bookkeeping with an Excel Income Statement Template

Enter your transactions into this Excel template, and voila! You get a ready-made Income Statement. Perfect for entrepreneurs who aren't ready for full-fledged accounting software.

Budgets for different types of business

While every good budget has the same framework, you’ll need to think about the unique budgeting quirks of your industry and business type.

Seasonal businesses

If your business has a busy season and a slow season, budgeting is doubly important.

Because your business isn’t consistent each month, a budget gives you a good view of past and present data to predict future cash flow. Forecasting in this way helps you spot annual trends, see how much money you need to get you through the slow months, and look for opportunities to cut costs to offset the low season. Use your slow season to plan for the next year, negotiate with vendors, and build customer loyalty through engagement.

Don’t assume the same thing will happen every year though. Just like any budget, forecasting is a process that evolves. Start with what you know, and if you don’t know something—like what kind of unexpected costs might pop up next quarter—just give your best guess. Better to set aside money for an emergency that doesn’t happen than to be blindsided.

Ecommerce businesses

The main budgeting factor for ecommerce is shipping. Shipping costs (and potential import duties) can have a huge impact.

Do you have space in your budget to cover shipping to customers? If not, do you have an alternative strategy that’s in line with your budget—like flat rate shipping or real-time shipping quotes for customers? Packaging can affect shipping rates, so factor that into your cost of goods sold too. While you’re at it, consider any international warehousing costs and duties.

You’ll also want to create the best online shopping experience for your customers, so factor a good web hosting service, web design, product photography, advertising, blogging, and social media into your budget.

Inventory businesses

If you need to stock up on inventory to meet demand, factor this into your cost of goods sold. Use last year’s sales or industry benchmarks to take a best guess at the amount of inventory you need. A little research up front will help ensure you’re getting the best prices from your vendors and shipping the right amount to satisfy need, mitigate shipping costs, and fit within your budget.

The volume of inventory might have an effect on your pricing. For example, if you order more inventory, your cost per unit will be lower, but your overall spend will be higher. You need to ensure this is factored into your budget and pricing, and that the volume ordered isn’t greater than actual product demand.

You may also need to include the cost of storage solutions or disposal of leftover stock.

Custom order businesses

When creating custom ordered goods, factor in labour time and cost of operations and materials. These vary from order to order so create an average estimate.

Startups

Budgeting is tricky for startups—you rarely have an existing model to work from. Do your due diligence by researching industry benchmarks for salaries, rent and marketing costs. Ask your network what you can expect to pay for professional fees, benefits, and equipment. Set aside a portion of your budget for advisors—accountants, lawyers, that kind of thing. A few thousand dollars up front could save you thousands more in legal fees and avoid inefficiencies later on.

There’s obviously a lot more that could be said about creating a budget for a startup. This guide from The Balance is a great start.

Services businesses

If you don’t have a physical product, focus on projected sales and revenue, and salaries and consultant costs. Figures in these industries—whether accounting, legal services, creative, or insurance—are much more of an estimate, which means budgets need flexibility. These figures are reliant on the number of individuals needed to provide the service, the cost of their time, and fluctuating customer demand.

Small business budgeting templates

A business budget template can be as simple as a table or as complex as a multi-page spreadsheet. Just make sure you’re creating something that you’ll actually use.

Create your budget yearly—a 12-month budget is standard fare—with quarterly or monthly updates and check-ins to ensure you’re on track.

Here are some of our favourite templates for you to plug into and get rolling.

  • The Balance has a clear table template that lists every budget item, the budgeted amount, the actual amount, and the difference between the two. Use this one if you’re looking to keep it simple and straightforward.

  • Capterra has both monthly and annual breakdowns in their Excel download. It’s simple but thorough, and fairly foolproof.

  • Google Sheets has plenty of budget templates hiding right under your nose. They’re easy to use and they translate your figures into clear tables and charts on a concise, visual summary page.

  • Smartsheet has multiple resources for small businesses, including 12-month budget spreadsheets, department budget templates, projection templates, project-by-project templates, and startup templates. These templates are ideal if you’re looking for a little more detail.

  • Scott’s Marketplace is a blog for small businesses. Their budget template comes with step-by-step instructions that make it dead simple for anyone.

  • Vertex42 focuses on Excel spreadsheets, and offers templates for both product-based and service-based businesses, as well as a business startup costs template for anyone launching a new business.

Budgeting + bookkeeping = a match made in heaven

Making a budget is kind of like dreaming: it’s mostly pretend. But when you can start pulling on accurate historical financials to plan the upcoming year, and when you can check your budget against real numbers, that’s when budgets start to become useful.

The only way to get accurate financial data is through consistent bookkeeping.

Don’t have a consistent bookkeeping process down pat? Check out our free guide, Bookkeeping Basics for Entrepreneurs. We’ll walk you through everything you need to know to get going yourself, for free.


This post is to be used for informational purposes only and does not constitute legal, business, or tax advice. Each person should consult his or her own attorney, business advisor, or tax advisor with respect to matters referenced in this post. Bench assumes no liability for actions taken in reliance upon the information contained herein.

Friends don’t let friends do their own bookkeeping. Share this article.

Want a free month of bookkeeping?

Sign up for a trial of Bench. We’ll do one month of your bookkeeping and prepare a set of financial statements for you to keep. No pressure, no credit card required.

Decorative patterns