The Ecommerce is 3 financial statements template based on industry standards for ecommerce companies. It is ideal if you sell physical products online, through your own website or third party platforms.
What it includes
- P&L, with supporting tables for Revenues and Expenses.
The Revenue table includes a generic list of products, with calculation based on quantity sold and price.
- Balance Sheet, with supporting tables for Assets, Liabilities, and Equity.
In Assets, this template has an additional supporting table for Inventory. It includes calculation based on previous inventory, units purchased, units sold, and cost.
- Cash Flow, automatically calculated based on your P&L and Balance Sheet.
How to use it
After selecting this template, your first step should be to take a few minutes to look at the supporting tables for Revenues, Expenses, Assets, Liabilities and Equity.
The template is completely customizable, so you can change field names, add new line items, and even change formulas to fit it to your financial plan. For example, on the Revenue table, change the field names to your product names and add any additional ones you might have.
Once you make the modifications and upload your data, you will have your three financial statements ready to go.
Ready to try it out?