No products in the cart.
Lợi Nhuận & Dòng Tiền Bán Online – Theo Dõi Đơn Hàng & Tài Chính | Excel Template
39 $ From 25 $
All-in-one Excel template for e-commerce sellers to track profit, inventory, cashflow, and marketing ROI across 5 sales channels — fully automated with formulas, no VBA or macros needed. Just enter data, the system does the rest.
Sold: 4 items
share:
Selling online but don't know exactly how much profit or loss per order?
E-Com Profit & Cashflow Navigator is a complete e-commerce financial management system on Excel — helping you track revenue, profit, inventory and actual cashflow across 5 sales channels: TikTok Shop, Amazon, Shopify, Facebook & Offline.
15-SHEET AUTOMATED LINKED SYSTEM
| Sheet | Chức năng |
|---|---|
| DASHBOARD | 6 main KPIs + charts + filter by channel & product |
| SALES_JOURNAL | Sales journal — auto-calculates platform fees, COGS, gross profit |
| INVENTORY_IN | Stock-in — track suppliers, unit purchase price |
| INVENTORY | Inventory — auto-deducts on sale, low stock alerts |
| MARKETING | Ad spend — CPC, CPO, campaign performance |
| PNL_DAILY | Daily P&L — revenue, costs, auto net profit/loss |
| PNL_MONTHLY | 6-month P&L report — standard Income Statement |
| PRODUCT_ANALYSIS | Top 10 product analysis — ranking, margin %, contribution |
| CASHFLOW | Actual cashflow — inflows/outflows, cumulative balance |
| SKU_MASTER | Product catalog — SKU codes, COGS, selling price, margin |
| BOM | Bill of Materials — 2-level Combo & Bundle, auto-deducts components |
| EXPENSES_DB | Fixed costs — warehouse rent, salaries, software, packaging |
| SETTINGS | System settings — platform fee %, shipping fees, report year |
| GUIDE | Detailed user guide — color codes, workflow, FAQ |
| COVER | Cover page + quick navigation table of contents |
KEY FEATURES
- 5 sales channels — TikTok Shop, Amazon, Shopify, Facebook, Offline — each channel auto-calculates platform & payment fees
- 2-Level BOM (Combo & Bundle) — Sell 1 Bundle, system auto-deducts each individual SKU inside (e.g.: Bundle Go Out = Combo Outfit + Bag + Hat)
- Automated Daily & Monthly P&L — Profit/loss updates in real-time, no manual reports needed
- Interactive Dashboard — 6 KPI cards (Revenue, Orders, Gross Profit, Margin, ROI Ads, Fund Balance) + charts + Channel & Product filters
- Automated Inventory Management — Stock-in, stock-out, returns, ending balance — alerts when inventory is low
- Cashflow Tracking — Actual cash inflows/outflows, separated from P&L (accrual vs cash basis)
- Marketing ROI tracking — CPC, CPO, ROAS auto-calculated per ad channel
- Save 80% of your time compared to manual Excel — just enter data, the system calculates everything
WHO IS THIS FOR?
- Online sellers on multiple e-commerce platforms
- Small/medium shops wanting exact profit/loss per order, per product
- Sellers wanting to track ad performance & actual cashflow
- Anyone wanting a financial management system without needing professional accounting software
TECHNICAL SPECIFICATIONS
- Format: Excel (.xlsx) — no VBA/Macro
- Compatible with: Excel 365, Excel 2021+ (requires XLOOKUP & Dynamic Arrays)
- Currency: VND (Vietnamese version) / USD (English version)
- Language: English
- Quantity: 15 sheets, supports up to 1,000 data rows/sheet
- Version: v1.1 (02/2026)
- Include: Detailed user guide (GUIDE sheet) + sample data
Note: This is a management support tool, NOT a replacement for professional accounting software. Please verify data before making important financial decisions.
Related products
- SaleSelect options This product has multiple variants. The options may be chosen on the product page
- SaleQuản Lý Nhà Trọ Trọn Bộ – Hợp Đồng, Thu Tiền & Điện Nước | Excel Template Original price was: 32 $.20 $Current price is: 20 $.
- SaleSelect options This product has multiple variants. The options may be chosen on the product page
A Digital Asset Ecosystem and Work Operating System for Individuals & Teams
SUPPORT
Copyright © 2026 BEUP Learning Solutions
MST: 3301755602
Reviews
There are no reviews yet.