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
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.
|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|
|Cost of Goods Sold||$12,000||$13,243||+$1,243|
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.
You can also check out this simple Startup Cost Calculator from CardConnect. It lays out some of the most common expenses that you might not have thought of. From there, you can customize a rough budget for your own industry.
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.
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.
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.
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.
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.
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.