Updated: Dec 23, 2019
“How’s business? Booming!” You may like the sound of that, but by only focusing on an ever-increasing number of sales you won’t have a full picture of your company. Estimating the revenue and expenses of your small business over a specific future period of time is a crucial step not only to maintain a sustainable operation, but also to be better prepared for the inevitable seasonal highs and lows.
Let’s imagine that your annual sales for this year were $100,000, up from $75,000 on the previous year. A 33.33% increase in annual sales sounds great but you need to gather more details behind those numbers.
Here is an example:
|Gross Revenue||$75,000||Gross Revenue||$100,000|
|Total Expenses||$33,750||Total Expenses||$55,000|
|Net Profit||$41,250||Net Profit||$45,000|
When accounting for the total expenses behind those sales, the impressive 33.33% increase in gross revenue is watered down to just a 9.09% increase in net profit before applicable taxes. One potential culprit behind this lower than expected profit margin could be an inefficient management of resources. In 2016, your total expenses were 55% of total sales, up from 45% in 2015.
From this simple scenario, you can draw several useful business management questions:
This is why it’s important to have a business budget. It allows you to review your performance in a very objective manner, highlights business decisions that require your attention, and forces you to start thinking about the future of your business.
Now, let’s focus on how to create a budget, what are key items to include, and what are best practices.
Here are some key considerations when putting together the annual business budget for your operation.
Set Up an Easy-to-Access Spreadsheet
Since you’re going to access, update, and review your business budget many times throughout the year, you need to keep your spreadsheet accessible. This is an actionable document that you should refer to when negotiating terms with suppliers, discussing terms with your advertisers and evaluating options for small business financing.
Choose the option that makes most sense for your way of doing business but try to make it accessible on-the-go. Some options are storing an MS Excel file on your tablet, maintaining a Google Sheet on your Google Drive, or sharing a spreadsheet file on your company’s Dropbox account.
Break Down the Year Into Months
A budget is the expected future financial performance for a business. While annual totals are useful benchmarks to keep track of your performance, you’ll have more direct control over the month that you’re currently working on.
Compare Budgeted Against Actual Amounts
For every month, you’ll budget an amount that you’ll compare against the actual performance for that month. Big differences will raise red flags (or provide pleasant surprises!), empower you to act in a timely manner, and allow you to plan ahead for the rest of the year.
Keep Track of Operating Expenses
There are many reasons why it’s important to separate business and personal finances. Proper budgeting forces you to reconcile your business income and expenses on a monthly basis, which is particularly useful when you do your own bookkeeping. Another benefit of keeping track of operating expenses regularly is that you’ll have an easier time when you’re preparing for your tax return.
Putting It All Together
We have put together a ready-for-use template on Excel here. Feel free to use this sample spreadsheet and adjust it to the unique needs of your small business. Using this business budget template, you should be able to answer all of the questions from our sample scenario and any other ones that you can come up with. For example, you’ll be able to track the trajectory of your business and determine whether or not you’re ready to hire your first employees.
Above all, having a budget allows you to keep better control of the lifeblood of any small business: monthly cash flow.
Starting line 32 from our business budget template, you’ll find a tool to calculate your cash flow on a monthly basis. This portion of the template helps you determining if you need to apply for a line of credit or to tap into an existing one. Here’s how to use it:
Comparing your actual revenues and expenses against those budgeted ones helps you foresee any potential cash shortfalls. Keeping a business budget is good habit that will pay off during the small business loan application process with any financial institution. To evaluate the creditworthiness of your business, a potential lender very often requests financial statements, including balance sheets and cash flow statements. By getting into the habit of creating and maintaining a budget, you’ll be able to back up your claims and projections with historical data and put your business in a more positive light in the eyes of a potential lender.