A set of .md text documents with ready-to-use markdown tables and formulas for copying into Google Sheets or Excel (.md files, not PDF; tables are inserted manually or via import).

WB & Ozon Order & Profit Tracker: Formulas, Dashboard, What-If Scenarios

Name: WB & Ozon Order & Profit Tracker: Formulas, Dashboard, What-If Scenarios
Brand: Fizoni
Price: 29 USD
Availability: InStock

Version 1.0.0 Updated: 2026-10-03 Quality: 78/100

A ready-to-use linked spreadsheet for Google Sheets/Excel: an order log with automatic calculation of commissions, logistics, cost of goods, taxes, and margins, plus a dashboard with charts and a "what if" scenarios block.

📁 What is inside (ZIP, 8 files)

01_README__________________________.md
02________________________.md
03_________________________________.md
04____________________.md
05__________________.md
06_____________________________.md
07________________________XLSX____________.md
README.md

Problem

Wildberries and Ozon sellers manually consolidate revenue, commissions, logistics, cost of goods, and taxes across scattered files. As a result, margins are calculated inaccurately, formula errors go unnoticed, and pricing and assortment decisions are made without a real picture of profit.

Solution

Linked spreadsheet system: product, expense, and tax rate reference tables, an order log with ready-made formulas for each column, a dashboard with calculations by marketplace, product, and period, a "what if" scenario block, and built-in input error protection. All data is pulled via VLOOKUP/INDEX+MATCH, so changes in the reference tables automatically recalculate the log and dashboard.

More details

This isn't just a collection of formulas or a text guide — it's a complete spreadsheet system for tracking orders and profit on Wildberries and Ozon. The package includes sheet structures, ready-made formulas for every column (VLOOKUP/INDEX+MATCH), product and expense reference tables, tax and commission rates, an order log with duplicate and input-error checks, a dashboard with revenue/profit/margin calculations by marketplace, product, and period, plus a "what if" scenario block for recalculating profit when price, commission, logistics, cost, or tax changes. The problem this system solves is manual financial reconciliation. When orders, commissions, logistics, and costs live in different files and different heads, margin gets calculated "by eye," and a single wrong cell breaks the whole picture. Here, everything is connected: change the cost or commission rate in the reference table — and the log and dashboard recalculate automatically. Built-in protection against common mistakes includes data validation for marketplace and SKU, highlighting of negative margin, warnings for unfilled fields, and protection of formula cells. The guide covers setup in both Google Sheets and Excel, with an implementation checklist and a breakdown of common errors. The dashboard is built on pivot formulas and ready-made chart structures: daily and weekly dynamics, top-10 products, share of logistics and commissions in revenue, marketplace comparison. "What if" scenarios let you quickly calculate break-even point, target margin, and the impact of changes on profit — without rebuilding anything.

Features

Order log with ready-made formulas: revenue, commission, logistics, cost of goods, tax, margin, profit
Product, expense, and tax rate reference tables with VLOOKUP/INDEX+MATCH lookup
Duplicate order and data entry error checks (data validation, conditional formatting)
Dashboard: revenue, profit, and margin by marketplace, product, and period
Ready-made chart structures: daily/weekly dynamics, top-10 products, logistics and commission share
What-if scenario block: price, commission, logistics, cost, and tax changes
Break-even point and target margin calculation
Formula cell protection, negative margin highlighting, and warnings for empty fields
Google Sheets and Excel setup guide with an implementation checklist and common mistakes
Copy-ready template: all sheets with formulas in text form and filled-in examples

What you get

01_README_and_implementation_guide.md — a step-by-step guide to importing into Google Sheets/Excel, setting up reference tables, validating formulas, and preventing errors, plus an implementation checklist and common mistakes
02_Reference_tables_and_settings.md — markdown tables for the 'Settings', 'Product_catalog', 'Expense_catalog', and 'Tax_rates' sheets with fields for SKU, cost, dimensions, category, WB/Ozon commission rate, logistics tariff, tax rate (USN/self-employed/OSNO), and lookup formulas
03_Order_log_and_financial_calculations.md — the main order tracking table with formulas for each column and duplicate and input error checks
04_Dashboard_and_analytics.md — pivot tables and formulas for the dashboard, ready-made chart structures
05_What_if_scenarios.md — a 'what if' scenario block with formulas for break-even point, target margin, and profit impact
06_Error_protection_and_validation.md — conditional formatting rules, data validation, protection of formula cells, negative margin highlighting, warnings for empty fields, and instructions for Google Sheets and Excel
07_Copy_template_XLSX_compatible.md — markdown tables of all sheets with formulas in text form and fill-in examples

Installation guide

1) Open 01_README_and_implementation_guide.md and go through the checklist. 2) Create a new spreadsheet in Google Sheets or Excel. 3) Transfer the sheets from 02_Reference_guides_and_settings.md: "Settings," "Product_catalog," "Expense_catalog," "Tax_rates," and fill in your data. 4) Copy the order log structure from 03_Order_log_and_financial_calculations.md and paste the formulas into the columns. 5) Set up the dashboard according to 04_Dashboard_and_analytics.md and add charts. 6) If needed, use 05_What_if_scenarios.md to model different options. 7) Apply the rules from 06_Error_protection_and_validation.md. 8) For a quick start, use 07_Copy-ready_template_XLSX_compatible.md.

Requirements

A Google account (for Google Sheets) or Microsoft Excel installed. Basic skills with spreadsheets and formulas (VLOOKUP/INDEX+MATCH). Product data: SKU, cost, dimensions, category, WB/Ozon commission rates, logistics tariffs, and tax rate.

Options and pricing

Choose the level that suits you:

Basic — $17 · Основной набор файлов продукта.
Standard — $29 · Полный набор + инструкция по внедрению.
Extended — $46 · Всё из Стандарта + расширенные материалы и обновления.

Frequently asked questions

What is included?

In what format will I receive the files?

After payment you get a secure link and a ZIP archive with all materials. The link is shown on the order page and available via the Telegram bot.

How long is the download link valid?

The link is active for 24 hours, up to 5 downloads.

Do I need special skills?

The product is designed for entrepreneurs and specialists. A step-by-step guide is included; no programming skills required.

Can I get a refund?

For refunds, contact support: [email protected].