Markdown files with tables, formulas, and instructions for importing into Google Sheets; CSV import from Wildberries/Ozon and connecting Google Apps Script

Financial Accounting & COGS for Marketplaces — Ready Google Sheets System for WB & Ozon

Name: Financial Accounting & COGS for Marketplaces — Ready Google Sheets System for WB & Ozon
Brand: Fizoni
Price: 39 USD
Availability: InStock

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

A ready-to-use Google Sheets system for Wildberries/Ozon sellers: track orders, returns, commissions, logistics, taxes, and advertising, with automatic calculation of cost of goods, SKU-level margins, break-even point, and recommended prices.

📁 What is inside (ZIP, 9 files)

01________________________.md
02________________________.md
03_________________________.md
04_______________________________.md
05___________________________.md
06_______________________________.md
07_____________________________________.md
08_________________________________.md
README.md

Problem

Sellers on Wildberries and Ozon often don't know their real profit per SKU: revenue is there, but where the money goes — commissions, logistics, storage, penalties, advertising, taxes — remains unclear. Cost of goods is calculated manually or not at all, per-SKU margins are invisible, and the break-even point is never calculated. As a result, pricing and advertising decisions are made on gut feeling, and some products sell at a loss.

Solution

A ready-made Google Sheets system connects orders, returns, commissions, logistics, taxes, and advertising into a single financial loop. Formulas automatically calculate unit cost, gross and net margin, profitability, and unit profit for each SKU. The dashboard shows sales dynamics, cost structure, and margin performance, while the "what if" block and break-even point calculation help you make pricing and ad budget decisions based on numbers, not intuition.

More details

This is not a guide or a collection of tips, but a working financial model in Google Sheets that you can implement into your business in a single evening. The system covers the full loop of unit economics for a marketplace seller: from uploading Wildberries/Ozon reports to calculating net profit per SKU and building a dashboard. All tables are linked with formulas and equipped with validations and pre-filled reference guides, so once you move it into Google Sheets, you immediately see numbers, not empty templates. The core of the system is cost and margin. A dedicated block breaks down procurement, packaging, delivery to the warehouse, taxes, and allocation of fixed costs. Formulas automatically calculate gross and net margin, profitability, and unit profit per SKU. Marketplace commissions, logistics, storage, penalties, and advertising are tracked separately and allocated by SKU, so you see real profit, not "dirty" revenue. The dashboard compiles sales dynamics, cost structure, and margin into Google Sheets charts. It also calculates the break-even point by fixed and variable costs: you see how many units and what revenue you need to break even. The "what if" block lets you change price, commission, and ad budget and instantly see the impact on profit, as well as get a recommended price for your target margin. For a quick start, demo data is included: 10–20 SKUs with filled-in orders, returns, and costs. You can study how the formulas work on examples, then replace the data with your own. The tool

Features

Order, return, and cancellation tracking with automatic calculation of revenue, units sold, return rate, and net sales for each SKU
Unit cost calculation: procurement, packaging, delivery to warehouse, taxes — with fixed cost allocation
Automatic calculation of gross and net margin, profitability, and unit profit by SKU
Tracking of marketplace commissions, logistics, storage, penalties, and ad spend with allocation by SKU
Dashboard with charts: sales dynamics, cost structure, margin by SKU
Break-even point calculation by fixed and variable costs in units and in money terms
Interactive 'what if' scenarios: price, commission, and ad budget changes with instant profit recalculation
Automatic recommended price calculation based on target margin
Reference data for SKUs, categories, tax rates, commission and logistics tariffs with validations
Demo data for 10–20 SKUs for a quick start and formula verification
Implementation guide with CSV import setup from Wildberries/Ozon and a checklist

Installation guide

1. Download all files from the package. 2. Open 01_Implementation_Guide.md and follow the steps. 3. Create a new Google Sheets spreadsheet and transfer the sheets from files 02–08, preserving the column structure and formulas. 4. Fill in the reference tables from 02_Reference_Tables_and_Settings.md: SKU, categories, tax rates, commission and logistics rates. 5. Set up CSV import from Wildberries/Ozon according to the instructions and connect the Google Apps Script scripts. 6. Upload the demo data from 08_Examples_and_Fill-in_Templates.md to verify that the formulas work. 7. Replace the demo data with your own and check the dashboard, break-even point, and "what if" scenarios.

Requirements

Google account and access to Google Sheets; access to your Wildberries and/or Ozon seller dashboard to export CSV reports; basic skills with Google Sheets formulas; to connect scripts — edit permissions on the spreadsheet (Google Apps Script is built into Google Sheets).

Options and pricing

Choose the level that suits you:

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

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].