We use cookies to provide visitors with the best possible experience on our website. These include analytics and targeting cookies, which may also be used in our marketing efforts.
This website stores data such as cookies to enable essential site functionality, as well as marketing, personalization and analytics. By remaining on this website, you indicate your consent.

(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 easily with a more accurate accounting of your COGS

An intuitive, easy-to-use template you’ll enjoy working with
No formulas needed. Just plug in your actuals to get results
A granular yet uncomplicated view of your financial performance

Reliably forecast your gross margin with a more accurate accounting of your COGS

Level up your SaaS financial modeling with Drivetrain!

Schedule a Demo