Get ready for 2021. Save $35 with code BYE2020

How to integrate the Ecommerce Module

Instructions on how to integrate the Ecommerce Module with the Standard Financial Model.

The Ecommerce Module extends the Standard Financial Model to model 25 individual SKUs or products (extendable to many more) by utilizing the existing default revenue model and acquisition forecasts of the Standard Model.

What is a module?

All modules are built so that they can create a revenue and cost of sales forecast on their own, but can be combined with the Standard Financial Model for consolidated financial statements and full financial reporting. The modules can be purchased pre-integrated with the Standard or purchased individually and integrated at any time; integration is as simple as copying the sheets of the module into your Standard Model, and then switching a dropdown selection on the Get Started sheet.

Here’s how modules work ›

Here’s how to integrate the module

The integration process is fairly simple and should take less than a couple minutes.

  1. Open up the Standard Model and the module in Excel. 1
  2. On the module, select each of the sheets to copy from the Module to the Standard Model by clicking on the first sheet to select it, then using Control + Click (Excel) or Command + Click (Mac) to select the additional sheets to move. You’ll want to select the Get Started sheet, Products, Inventory, and Export. After you’ve selected multiple sheets, “Group” appears in the title bar at the top of the worksheet. 2
  3. Right click on one of the selected sheets and select Move or Copy from the selection. then check the “Create a Copy” checkbox, and select what sheets to put it next to in the model (it doesn’t matter for the model to work, I usually put them after the Get Started sheet or before the Costs sheet), then click Ok. 3
  4. On Get Started - Financial Model, on D131 you’ll want to change the dropdown selection to “Export”. This tells the model to pull relevant numbers from the Export sheet from the module, and this makes all the linkages between the module and the Standard Financial Model work. 4
  5. Next you’ll want to setup the conversion funnel used in the module. The module can used for one or both of the conversion steps in the Standard Financial Model. On Get Started - Ecommerce Module, at the top you’ll be able to select the metrics used to denote the number of monthly orders (or whatever you are calling this metric) you’ve calculated in the Standard Model, and then on the same sheet you’ll want to assign each product you enter to the conversion step you want to use the module for.
  6. The last step is to make sure the starting dates of the module aligns with the Standard Model. Edit the start date for the Ecommerce Module on Get Started - Ecommerce sheet, and make it the same you are using on Get Started - Financial Model.

The Ecommerce Module does not replace the existing Revenue Model sheet, but it does change how some numbers are used. When you are using the module, the Average Revenue and Average Cost of Sales per Order (or whatever term you are using) will not be used, as the model will pull the average revenue and cost of sales from the Ecommerce Module’s Product sheet, based on the mix of products, prices, cost of sales, and average product-per-order rates you’ve used in there. You can thus ignore the Average Revenue and Average Cost of Sales inputs on the Get Started - Revenue Model sheet.

The integration functionality is highly technical, but I’ve worked to make the process as easy as possible so that anyone can safely upgrade their model without requiring extensive editing. Questions, ask anytime ›

Interested in building your own module?

Learn more about how modules, Bring Your Own Model and Modelhooks work, and contact me if you have any questions.

  1. Google Sheets does not offer this capability, so you will need to use Excel to move a Module into the Standard Model, or purchase them pre-integrated. 

  2. Office Support on selecting multiple sheets. 

  3. It’s important to select all the sheets and copy them together as a group, as that will keep the formulas working between the sheets. 

  4. You’ll need the Standard Model v3.27 and above for the integration to work automatically. Either upgrade to a newer version of the Standard, or manually link the Export sheet into the Modelhooks sheet.