(Finally!) A cost of goods sold formula Excel template tailor-made for SaaS
The complexities of a SaaS business model can make deciding what costs should be included in your costs of goods sold (COGS) a challenge. Our template is tailor-made for B2B SaaS businesses to help you figure out when (and when not to) categorize an expense as COGS.


A flexible template built with your business in mind
Most of the cost of goods sold spreadsheet templates you find today are generic and offer little real guidance for SaaS businesses on how to determine what expenses they should and shouldn’t include in their COGS.
We built our template with the complexities of a SaaS business model in mind. Recognizing that no two SaaS companies are alike, we’ve also designed it to be highly flexible. You can easily customize it to fit your current COGS expenses and use the framework it provides to evaluate other expenses where the appropriate categorization is less obvious.
Here’s what you’ll find inside:
- Common components of COGS for SaaS businesses
- A template to enter your COGS actuals and forecasts
- An income statement (P&L) with COGS calculated for you
Reliably forecast your gross margin with a more accurate accounting of your COGS
Get your free downloadMore related content

SaaS financial model template in Google Sheets
Download this SaaS financial model template in Google Sheets to quickly forecast your company’s future performance with a connected, driver based model that factors in the core components that impact your business.

SaaS metrics based planning: A template for top-down revenue planning
Use this proven approach to modeling revenue with just five key SaaS metrics and the Rule of 40. Download this template to quickly create targets for your GTM teams, shorten the planning cycle and drive greater efficiency in your business.
Level up your financial planning & analysis with Drivetrain!
Schedule a Demo