Google Sheets Budget Template for Small Business

A budget is the difference between running a business and hoping one works out. And you do not need pricey software to build one. Google Sheets is free, it lives in your browser, and it is powerful enough to plan income, track spending, and flag trouble before it drains your account. This guide answers one question directly: how do I build a business budget in Google Sheets? You will get a ready-to-copy template route plus a from-scratch build so you understand every cell.

The fastest start: use Google's built-in template

Before you build anything, know that Google ships a free budget template inside Sheets. It is the quickest path from zero to a working budget.

Open sheets.google.com.
Click Template gallery in the upper-right corner.
Scroll to the Personal section and choose Monthly Budget (or Annual Budget for a 12-month view).

Google's Monthly Budget template opens with two tabs, a Summary sheet and a Transactions sheet, and pre-populated categories for income and expenses. You log each expense on the Transactions sheet, and it automatically rolls up into the Summary. Setup takes under five minutes and costs nothing. Third-party libraries like Tiller and Smartsheet also offer free business-focused templates you copy with File → Make a Copy.

The catch: templates are personal-finance oriented. For a real business budget you usually want revenue by source, cost of goods, and a running cash position. That is where building your own pays off.

How do I build a business budget in Google Sheets from scratch?

Here is the full method. It takes about 20 minutes and gives you a spreadsheet you actually understand.

Step 1: Set up the structure

Create a new blank sheet and add three tabs along the bottom:

Setup - your list of income and expense categories.
Budget - planned vs. actual by month.
Summary - the dashboard that tells you if you are profitable.

Keeping categories on their own tab means you change them in one place, and every formula updates.

Step 2: List your income and expense categories

On the Setup tab, create two columns. Under Income, list every revenue stream: product sales, services, retainers, wholesale, whatever applies to you. Under Expenses, split into two groups that matter enormously for a business:

Fixed costs - rent, software subscriptions, insurance, loan payments. These stay roughly the same each month.
Variable costs - inventory, shipping, ad spend, contractor hours, payment processing fees. These move with sales volume.

Separating fixed from variable is the single most useful thing a budget does. It tells you your break-even point, and it shows which costs you can cut fast if revenue dips.

Step 3: Build the monthly budget grid

On the Budget tab, put categories down column A. Across the top, create paired columns for each month: Jan Planned, Jan Actual, Feb Planned, Feb Actual, and so on. Enter your best estimate in each Planned column. You fill Actual as real numbers come in.

Step 4: Add the formulas that do the work

This is where a spreadsheet beats a paper budget. A few functions carry the whole model:

Total income: =SUM(B2:B8) sums a range of income cells.
Total expenses: =SUM(B10:B25) sums your expense rows.
Net profit: =B9-B26 subtracts total expenses from total income. A negative result is your monthly loss, in plain sight.
Variance: =C2-B2 compares Actual against Planned so you can see where you overspent.
Category totals across the year: =SUMIF(Setup!A:A, "Fixed", Budget!B:B) groups spending by type using a label from your Setup tab.

Format the money cells as currency (Format → Number → Currency), and use conditional formatting to turn any negative net-profit cell red. Now overspending is impossible to miss.

Step 5: Build a summary you check weekly

On the Summary tab, pull the headline numbers with references like =Budget!B9 for total income and =Budget!B26 for total expenses. Add a cash-on-hand row so you always see runway. Insert a simple chart (Insert → Chart) plotting planned vs. actual by month. That one visual is what turns a budget from a chore into a decision tool.

Formatting tips that keep the budget accurate

A budget only helps if the numbers stay clean. A few habits:

Freeze the header row (View → Freeze → 1 row) so labels stay visible as you scroll.
Use data validation for category cells so entries stay consistent and your SUMIF formulas do not miss rows because of a typo.
Protect formula cells (Data → Protect sheets and ranges) if anyone else edits the file.
Duplicate the tab each year rather than overwriting, so you keep a clean history to compare against.

How a budget connects to the rest of your finances

Your budget is one piece of a small business's financial picture, and it feeds the others. The Actual numbers you log here are the raw material for a profit and loss statement, which formalizes income and expenses over a period. Track the timing of money in and out and you are doing cash-flow analysis, the discipline that keeps you from being profitable on paper but broke in the bank.

If you sell physical products, pair this with an inventory spreadsheet template so your variable costs reflect real stock levels rather than guesses. And once your budget shows a stable surplus, that is your green light to reinvest, whether that means acting on a new business idea or applying for a small business loan with real numbers to back the request. If you have not built the business yet, a budget is also one of the first artifacts you create when you start a business properly.

When to graduate from a spreadsheet

Google Sheets is ideal for solo operators and early-stage businesses. You will want to move to dedicated accounting software when you are reconciling dozens of transactions a week, running payroll, or need bank feeds and tax reports. Until then, a well-built sheet costs nothing and teaches you more about your own numbers than any automated tool. Many founders keep a budget spreadsheet running alongside their accounting software for exactly that reason: it forces you to look.

Conclusion

Building a business budget in Google Sheets comes down to five moves: define your categories, split fixed from variable costs, lay out planned vs. actual by month, add a handful of SUM, SUMIF, and subtraction formulas, and check a summary dashboard every week. Start with Google's built-in template if you want speed, or build your own if you want control and understanding, which is usually the better trade.

Ready to take control of your numbers? Open a blank Google Sheet, copy the structure above, and give yourself an hour. A budget you actually maintain is worth more than the fanciest software you ignore.

Sources: