Back to products
TEMPLATEExcelCashflow

Online Seller Income & Expense Tracker

Excel workbook for online sellers to track order-level income, expenses, platform fees, shipping, COGS, inventory, and monthly cash flow in one file.

Price
฿59
In Stock / Ready to Use
1

Subscribe to Smart Coin to get an instant 25% discount on all contracts!

Video Guide

Detailed Product Description

This online seller income and expense tracker is designed for ecommerce shops that need to understand real cash flow and real profit, not just daily sales totals. Online stores often have layered costs such as discounts, refunds, platform fees, payment fees, shipping differences, packaging, cost of goods sold, advertising, and monthly operating expenses.

What is included

  • Dashboard showing net sales, total expenses, net profit, margin, net cash, and low-stock item count
  • Order-level transaction log for gross sales, discounts, refunds, platform fees, payment fees, shipping charged, shipping cost, packaging, COGS, ads, and other expenses
  • Inventory and COGS sheet for unit cost, sold quantity, ending stock, inventory value, reorder point, and stock status
  • Monthly cash flow report for cash in, cash out, net profit, margin, units sold, shipping difference, fees, ads, and inventory value
  • Editable bookkeeping categories and sales channel dropdowns such as Shopee, Lazada, TikTok Shop, LINE OA, Facebook, Instagram, Website, and Offline
  • Built-in guide explaining where to start and how to read the dashboard

Why it matters

  • Many ecommerce sellers have healthy sales but weak cash flow because fees, shipping losses, discounts, ads, and COGS are not separated clearly
  • Order-level tracking helps reveal which orders are actually profitable after hidden costs
  • Inventory and COGS tracking helps prevent underpricing products when supplier costs change
  • Monthly cash flow summaries make it easier to plan stock purchases, ad spend, and bookkeeping handoff

Best for

Note: This workbook is a bookkeeping and profit-planning tool, not a full accounting system or tax advisory service. Always reconcile with official marketplace reports, receipts, and accounting records before making major decisions.

  • Online sellers who sell across multiple channels
  • Shops using marketplaces, social commerce, websites, or offline pickup
  • Small businesses that need a practical monthly bookkeeping file
  • Store owners who want clearer profit visibility before scaling ads or stock