The StitchCrew Guide to Finances: Forecasting Without the Crystal Ball

A business can feel pretty straightforward when you look at one number at a time. Revenue is one thing. Costs are another. Margin feels like its own separate conversation. Forecasting is where those numbers stop living in separate lanes and start interacting with each other. That is when you get a clearer picture of how money may actually move through the business, what the business needs in order to work, and where things may start getting tighter or more expansive than they first looked.

What Forecasting Is Really Helping You See

Forecasting gives you a way to lay the business out on paper and see what the numbers are asking it to do. That matters because a lot of our assumptions and goals sound fine on their own but once those numbers all have to work together month after month, the story can change pretty quickly.

That's what forecasting helps surface. It helps you see whether the business is bringing in enough to carry itself and what needs to happen for the numbers to hold up over time. How much needs to come in each month? How much room do you have if costs climb? What starts to feel tight if revenue shows up later than expected? These are the kinds of questions a forecast helps bring into focus before they start showing up in real life.

So, let’s think about forecasting as a worksheet that we'll modify a million times as we learn more about the business. That's part of the job. The process itself is incredibly cathartic, as it forces you to track down answers, tighten up loose assumptions, and see more clearly where the model is working and where it needs help. For now, what matters most is seeing how those values affect the bigger picture. And all of that gets plugged into the document that will soon rule your life. The Income Statement.

WTF is an Income Statement

At its core, an income statement is just a way to see whether the business is making money or lighting money on fire. It shows what came in, what went out, and what was left at the end. That’s it.

Now, of course, finance people love to make this sound much fancier than it needs to be. But the basic job of an income statement is pretty straightforward and once you start forecasting, you need somewhere for all of those numbers to go. If we strip away all the finance jargon, the income statement is really just walking us through a few steps.

• We start with Revenue which is the money coming into the business from sales

  
  

• Next we subtract the COGS or the direct cost of delivering what you sold

  
  

• What we have left is the Gross Profit  which tells you how much money is left before the rest of your business expenses show up.

  
  

• Now we subtract our Operating Expenses which are all the other costs in running our business. Think payroll, marketing, rent, software, admin, and all the other bills hanging around in the background.

  
  

• At the very end we're left with our Net Income. This is the number that tells you whether the business is actually leaving anything behind and if the business is actually working.

  
  

So if you want the super simple version, it really comes down to Money In - Money Out = Profit or Loss. What makes the income statement useful is that it shows where the pressure is actually coming from. And that's exactly what we need for forecasting. Because once we start plugging our assumptions into an income statement month by month, the business starts to show up a lot more clearly.

What Forecasting Is Really Helping You See

Forecasting gives you a way to lay the business out on paper and see what the numbers are asking it to do. That matters because a lot of our assumptions and goals sound fine on their own but once those numbers all have to work together month after month, the story can change pretty quickly.

That's what forecasting helps surface. It helps you see whether the business is bringing in enough to carry itself and what needs to happen for the numbers to hold up over time. How much needs to come in each month? How much room do you have if costs climb? What starts to feel tight if revenue shows up later than expected? These are the kinds of questions a forecast helps bring into focus before they start showing up in real life.

So, let’s think about forecasting as a worksheet that we'll modify a million times as we learn more about the business. That's part of the job. The process itself is incredibly cathartic, as it forces you to track down answers, tighten up loose assumptions, and see more clearly where the model is working and where it needs help. For now, what matters most is seeing how those values affect the bigger picture. And all of that gets plugged into the document that will soon rule your life. The Income Statement.

WTF is an Income Statement

At its core, an income statement is just a way to see whether the business is making money or lighting money on fire. It shows what came in, what went out, and what was left at the end. That’s it.

Now, of course, finance people love to make this sound much fancier than it needs to be. But the basic job of an income statement is pretty straightforward and once you start forecasting, you need somewhere for all of those numbers to go. If we strip away all the finance jargon, the income statement is really just walking us through a few steps.

• We start with Revenue which is the money coming into the business from sales

  
  

• Next we subtract the COGS or the direct cost of delivering what you sold

  
  

• What we have left is the Gross Profit  which tells you how much money is left before the rest of your business expenses show up.

  
  

• Now we subtract our Operating Expenses which are all the other costs in running our business. Think payroll, marketing, rent, software, admin, and all the other bills hanging around in the background.

  
  

• At the very end we're left with our Net Income. This is the number that tells you whether the business is actually leaving anything behind and if the business is actually working.

  
  

So if you want the super simple version, it really comes down to Money In - Money Out = Profit or Loss. What makes the income statement useful is that it shows where the pressure is actually coming from. And that's exactly what we need for forecasting. Because once we start plugging our assumptions into an income statement month by month, the business starts to show up a lot more clearly.

When the Math Stops Minding Its Business

The formal term for this is a Pro Forma Income Statement, which is really just a forward-looking income statement. In plain English, it means we’re laying out what we think the business may look like based on what we know right now. We can tell ourselves all kinds of nice stories about how things are going, but the income statement is where the numbers either support that story or start pushing back.

At this point, it helps to actually look at the Income Statement Template we’re working with.

Trying to create one income statement to rule them all is damn near impossible, so we created a version that works for as many business owners as possible but can still be adjusted to fit your needs. Here’s the quick tour of what each tab is doing behind the scenes.

• Overview. This is the main dashboard. It shows how everything from the other tabs plays out once it all comes together. In other words, this is where you get the big picture and see one very important result: whether the business made money or lost money in the form of Net Operating Income.

  
  

• Revenue. This is where all income gets recorded, whether that is product sales, service revenue, consulting income, partner income, or anything else coming into the business. The only "costs" that usually show up here are things directly tied back to revenue, like returns or chargebacks.

  
  

• Cost of Goods Sold (COGS). This tab is for the direct costs tied to delivering what you sell. Keeping these costs separate makes it easier to see how much each sale is really leaving behind and where you may be able to improve your margins without getting distracted by the rest of the business.

  
  

• Marketing. If your business has a meaningful marketing spend, this tab helps you isolate it. That gives you a better view of how much you are spending to drive growth and how that spend is stacking up against the revenue coming in.

  
  

• Staffing. This is where payroll-related costs live, including employee pay, contractor costs, payroll taxes, and things like healthcare expenses. Basically, if it relates to people getting paid, it probably belongs here.

  
  

• Miscellaneous Expenses. This is the catch-all tab for everything else that does not neatly fit into payroll, marketing, or direct COGS. Think office expenses, SaaS subscriptions, meals, services, and all the other charges that somehow find their way into the business each month.

  
  

• Assumptions. This is where the forecast starts getting built. The assumptions tab is where you project what the business might do throughout the year based on what you know right now. Then, as projected months turn into real ones, those estimates get replaced with actual numbers.

It’s also completely fine to add tabs, remove tabs, or modify this template as needed. The only thing to keep an eye on is that every tab still maps back to the Overview tab correctly. If you add a new category somewhere, just make sure the math still rolls up the way it should.

Now that we’ve got the lay of the land, the next step is using the template in a way that actually helps. The easiest way to think about it is that the forecast gets built in layers.

We start with the Assumptions tab because that is where a lot of the early heavy lifting happens. Those values help shape what the rest of the income statement may look like, especially when it comes to Revenue, COGS, and Marketing. On their own, those assumption values are just a worksheet. But once we start using them to populate the rest of the statement, the forecast starts taking shape.

From there, we move into the parts of the business that are a little less dynamic but still very real. That usually means filling in things like Staffing and Miscellaneous Expenses, the costs that may not move dramatically with every sale, but still need to be accounted for month by month. Once those pieces are in place, you can start pressure testing the business a little. You can see what happens if sales come in lighter than expected, if payroll grows faster than planned, or if expenses stack up in ways that looked harmless on their own.

Right now, the job is to make informed estimates in each category and use them to build the forecast. Later, as the months start filling in with real activity, those estimates can give way to actual numbers.

What You’re Really Looking For

Forecasting isn’t a one-time thing. You should be updating it constantly as you get more and more data about how your business is performing. The more the business changes, the more helpful it is to keep the forecast updated so you can see how those shifts affect the bigger picture. A change in one part of the business rarely stays contained there. A hiring decision affects expenses. A marketing slowdown affects revenue. A change in pricing affects margin. The more clearly those relationships are visible, the easier it becomes to make decisions with the full picture in mind. At this point, the real value of the forecast is that it gives you something to compare against as the months start moving. Because eventually, the work stops being just about what you think will happen and starts becoming about what actually did and projected numbers begin giving way to real ones.