Finance Software

Take Your Bookkeeping to the Next Level With This Free Small-Business Budget Template

By | 7 min read | Published ; Updated on

Learn how to create and use a budget for your business using our free template.

According to the U.S. Bureau of Labor Statistics, 20% of small businesses fail within their first year. And while reasons vary, their failure is often due to cash flow problems.

Don’t let your business become another statistic. To give your new small business its best chance at survival, you’ll need to learn how to take inventory of your income and costs—your cash flow—and track what you’re actually making and spending. In other words, you need a budget.

Making a useful budget for your small business doesn’t have to be complicated. All you need is a spreadsheet tool such as Microsoft Excel to create a budgeting tool of your own. Even better news? We’ve already made a free small-business budget template for you.

How to use our free small-business budget template

Rather than create a budget spreadsheet yourself, use our budget template spreadsheet to jumpstart your budget plan. We’ll show you how in four easy steps.

Step 1: Take inventory of income to determine what you can spend

You can’t create a budget without taking inventory of your income. Why not? Because your income determines how much you’re able to spend.

To find out how much you’re bringing in, you can refer to your profit and loss (P&L) statement, also known as your income statement. An income statement shows how much profit your company has made, or how much you’ve lost. It has three components:

  • Revenue: Income generated through the sale of goods and services from business operations, after deducting returns and allowances such as discounts.
  • Expenses: Cost to produce goods and services sold as well as operating expenses.
  • Profit: Cash your company makes from business operations, including gross profit, operating profit, and net profit.

Don’t have an income statement handy? No problem. We’ll cover that later on.

For this first step, we’re most interested in your revenue. Depending on your business model, you might have several sources of revenue, such as a subscription service or online classes. To get an accurate budget, make sure to include all streams of revenue in your inventory.

You’ll notice we’re using the terms revenue and income interchangeably here. That’s because revenue and total income have the same definition—the total cash inflow from your primary income-generating activity. Your income can be further broken down into two categories: operating income and non-operating income.

Operating income refers to your earnings before interest and taxes. Non-operating income includes any money you’re making from activities unrelated to your core business operations, such as interest or rent.

The bottom line? If you’re making money from it, include it in your income sources. Check out the image below for an example of what this looks like within our template:

Fields to input income information in our business budget template
Fields to input income information in our business budget template

Step 2: Subtract fixed and variable costs from your income

Once you’ve taken inventory of your income, you can subtract fixed costs. Fixed costs include annual or monthly expenses such as rent, insurance, membership fees, subscriptions, or anything else that you pay the same amount for on a recurring basis. Planned expenses are easy to predict because they’re consistent.

Variable costs, however, are a different story. These include expenses such as utilities, marketing, materials, payroll, and travel, and their cost may fluctuate from month to month. To estimate their total for your budget, you can refer to old receipts and invoices.

Note: Speaking of travel, or any other expenses incurred by individual employees, it can help to have a business expense template to distribute so that you can factor those costs into your budget. We’ve included one in our free download for you to use.

Once you’ve identified all fixed and variable costs, subtract those from your income. You now have your net income.

Step 3: Input actual income and costs

You’ve estimated what you think you might make and spend—now it’s time to track the actual dollar amounts.

Fields to input actual income and costs highlighted in our business budget template
Fields to input actual income and costs highlighted in our business budget template

Here’s where you’ll revisit our business budget template on a monthly basis to track what you’ve actually spent on each line item you entered in step 2. You’ll do this to see if what you estimated reflects the actual expenses leaving your bank account.

Why is this step so important? Because it’s like holding a mirror up to your finances. Your intentions might be good when it comes to what you should be spending, but if you aren’t going to adjust this in practice, you won’t find much use in a budget. Which brings us to our fourth and final step: Use this information to make better decisions for your small business.

Step 4: Make better financial decisions for your small business

Now that we’ve discussed how to track your income, expenses, and actual costs, you can better understand your finances—and make better financial decisions for your small business—by creating an income statement.

As we mentioned earlier, your income or profit and loss (P&L) statement shows how much profit your business has made, or how much you’ve lost. It’s useful to have on hand as you create your business budget because it serves as your baseline. See below for an example.

An illustrative example of a simplified income statement (Source)

Once you complete steps 1 and 2 above to calculate your net income, you’ll have all the information you need to create an income statement. If your net income is positive, congratulations! Your business is profitable.

You’re losing money if your net income is negative, but don’t panic. Knowing is half the battle, and by facing your financial situation, you’re already on the road to better budgeting practices.

Capterra tools and tips

If numbers aren’t your forte, or if working with a Google Sheet rather than Excel is more your speed, we’ve got you covered. Here are some resources that can provide some extra help with budgeting:

  • Budgeting software can help you allocate, manage, and track annual budgets. It makes it easy to analyze financial data and predict expenses, and it eliminates errors associated with manual data entry and spreadsheet-based budgeting.
  • Bookkeeper softwarehelps small and midsize business owners keep track of their financial data.
  • Google Sheets is a useful and accessible tool to keep track of your budget, and it’s easy to convert our template. Just go to your Google drive, select “New,” and select “File upload.” From there, you can upload our Excel spreadsheet and continue working in a Google Sheet instead.

Help us help you with your business budget

You’re one step closer to having a better handle on your business’s finances with these four steps.

Four steps to use our free downloadable business budget template

While the steps we covered are a good place to start, they’re meant to serve as a foundation for your budget. Once you’re comfortable, you can factor in a safety net, or go through your costs to weed out nonessentials. Accounting software can help you manage transactions and provide a real-time analysis of your financial status, including cash flow and expense management.

If you’re ready to get your business’s finances in order, download our free template.


Looking for Budgeting software? Check out Capterra's list of the best Budgeting software solutions.

About the Author

Lauren Spiller

Lauren Spiller

Lauren Spiller is a Senior Content Writer at Capterra, covering customer management, customer service, and customer experience with a focus on customer acquisition through SEO. She has an MA in Rhetoric and Composition from Texas State University and has presented her work at the European Writing Centers Association, Canadian Writing Centres Association, and the International Writing Centers Association conferences. She is currently developing content for a workshop series on SEO writing. She loves to cook and spend time outdoors around Austin, Texas.

Related Reading

Comments

Comment by Andrew Conrad on

Hi Teresa, Carl, and Sunil! I checked the sheet and it seems to be working properly for me. In the Overview tab, there is a Year-to-Date summary which is meant to add the months together, but below that there is the Month summary which should show the totals for that individual month. Am I still misunderstanding the issue?

Avatar

Comment by Teresa Maybay on

First of all, I love how the sheets are setup. Very clean and easy to read.
HOWEVER, there are still issues on the Overview Sheet-just like Sunil and Carl Woz reported in January 2017 and February 2019.

Will you be correcting these soon? I would love to keep using these, but I downloaded the document to keep from having to figure the calculations myself.
Thanks!

Comment by Andrew Conrad on

Hi Estefania! Sorry about that, we had previously linked to the wrong location. If you try downloading again you should get an Excel copy that you can edit and use as much as you like.

Comment by Estefania Torres on

I am trying to edit sections of this sheet but there are sections of the template that are password-protected. Can you please supply this password so I can customize the sheet?

Comment by Carl Woz on

As Sunil said above, the last sheet adds all the month values when you select months in the drop down menu. Does anyone have the proper Excel formula to make this function work? Thank you!

Comment by Sunil on

Very useful Template, In summary Sheet, the month is showing added value. Example if I choose second month, then the month sheet should show only the second month values. but in the sheet it showing two months added value. Hope you will rectify the error.

Pingback by How to Create a Monthly Budget Spreadsheet Template for Your Small Business on

[…] Downloadable small business budget template from Capterra […]

Pingback by 5 Freebies that Every Empirelista Needs to Thrive in 2016! - EMPIRE LIFE on

[…] dreams come true — so the next, but most important, freebie on this list is Capterra’s Free Small Business Budge Template. With this deep dive into your finances, you’ll be able to see the state of your business from […]

Comment on this article:

Comment Guidelines:
All comments are moderated before publication and must meet our guidelines. Comments must be substantive, professional, and avoid self promotion. Moderators use discretion when approving comments.

For example, comments may not:
• Contain personal information like phone numbers or email addresses
• Be self-promotional or link to other websites
• Contain hateful or disparaging language
• Use fake names or spam content
Your privacy is important to us. Check out our Privacy Policy.