Ecommerce business spreadsheet: run your business from one Excel file

Run your online shop in Excel: orders by channel, platform fees, stock, returns, HMRC reporting and consumer law checks. £15 one-off, no subscription.

£15 one-off · No subscription · Excel workbook.

Starting a online shop business? Use our free startup-cost guide and calculator →

Online Shop and E-commerce Management System cover

Online Shop and E-commerce Management System dashboard preview

Look inside

Real screenshots from the Online Shop and E-commerce Management System workbook.

Online Shop and E-commerce Management System operations worksheet screenshot
Operations — Real operating records and monthly performance in the workbook.
Online Shop and E-commerce Management System checks worksheet screenshot
Checks — Daily and recurring checks, with completion status and follow-up.
Online Shop and E-commerce Management System compliance worksheet screenshot
Compliance — Renewals, registrations and important compliance dates.
Online Shop and E-commerce Management System risk assessments worksheet screenshot
Risk Assessments — Industry risks, controls and review tracking.
Online Shop and E-commerce Management System stock take worksheet screenshot
Stock Take — Stock, supplies or equipment information relevant to the business.
Online Shop and E-commerce Management System rota worksheet screenshot
Rota — People, bookings or capacity planning for the working week.
Online Shop and E-commerce Management System cash flow worksheet screenshot
Cash Flow — Income, costs and cash position in one workbook.
Online Shop and E-commerce Management System debtors worksheet screenshot
Debtors — Customer balances, due dates and payment follow-up.

The Online Shop and E-commerce Management System is an all-in-one ecommerce business spreadsheet for online shops. Log every job or sale, chase unpaid invoices, run your stock take, plan the rota, keep on top of daily checks, certificates and risk assessments, and see your profit on a live dashboard. It costs £15 once, with no subscription and no app, so you keep your own data in a file you already know how to use.

Why online sellers choose a spreadsheet over an app

Built for online shops

Money and admin, done for you

Dashboard

A one-page dashboard with income, costs, net profit, margin, unpaid and overdue invoices, industry key figures, reminders, cash position, a compliance score (checks up to date, certificates in date, high risks, items to reorder) and month-by-month charts.

Works for you, wherever you are

What you get

Read the full guide: How to start an online shop in the UK · How much online sellers earn · The KPIs to track

Need a business plan too? Get the Online Shop Business Plan Template – £10 · Or get everything: Full Business Pack – £20 (save £5) · Forecasting growth? E-Commerce / DTC Financial Model

The KPIs to track

How much can you earn?

How to start this business

FAQ

Is this a one-off payment? Yes. It costs £15 once. There is no subscription, no app to install and no monthly fee. You keep the Excel file and all of your data.

Does it work in Excel for Mac, Excel online and Microsoft 365? Yes. It works in Excel 2016 or later on Windows and Mac, and in Excel for the web. Save it to OneDrive or SharePoint and your team can edit it at the same time.

Can I use it outside the UK? Yes. Choose from 25 countries and the currency symbol updates everywhere. Labels, lists and results switch between English, Spanish, French, German and Portuguese.

Does it calculate VAT? Yes. Set your VAT, GST or sales tax rate and it works out tax on every sale, plus a quarterly summary of tax charged, tax reclaimable and net tax to pay. Always check figures with your accountant before filing.

What checks and records are included? 12 ready-made checks such as orders dispatched within the promised time and stock levels synced across all channels, a compliance register with renewal reminders, 7 pre-filled risk assessments, a weekly rota and a stock take. You can edit or add your own.

Is there example data? Yes. Example rows show how everything works and fill the dashboard. They are marked 'Example' so you can delete them before you start.

Related business tools

Browse all Business Management Systems