Marketplace Sync ● Multi Platform ● Auto Report
Shopee TikTok Shop

Revenue up, but
profit leaking?

Built specifically for online sellers: analyze profit per SKU, marketplace fee details, and margin per SKU. Analyze and make strategic decisions in 5 minutes, starting now.

Drag & Drop → Your Financial Report & Business Insights Ready in 10 Seconds.
Shopee Data Input
Upload your report file, Profit & Loss is generated automatically
Jun 2026
Drag your Excel file here
Export .xlsx from Shopee Seller Center
Processing Excel data...
Creating Shopee Financial Report - May 2026
Profit-Loss-Shopee-Jun.xlsx
1,2 MB · Excel
Shopee Profit & Loss
Shopee SHOP Profit & Loss Statement (Cash Basis)
Jun 2026
Sales-to-Margin FlowJun 2026
Rp 1.19B
GMV
Rp 774M
NMV
Rp 245M
Margin
Marketplace Cost Structure% to GMV
Service Fee-4.70%
Administration Fee (11% VAT)-3.51%
Order Processing Fee-0.69%
AMS Commission Fee-0.09%
Value% to GMV% to NMV
1Shopee Gross Sales (GMV)Rp 1.193.596.985100.00%
Product Discounts-Rp 417.758.945-35.00%
–Refunds to Buyers-Rp 2.063.242-0.17%
–Shopee Product Discount (add-back)Rp 6.885.1210.58%
–Seller-Funded Vouchers-Rp 3.760.379-0.32%
2Shopee Net Sales (NMV)Rp 773.774.79864.83%100.00%
Total Shipping Cost-Rp 110.100-0.01%-0.01%
Marketplace Admin & Service Fees-Rp 108.219.078-9.07%-13.99%
–AMS Commission Fee (Affiliate)-Rp 1.041.558-0.09%-0.13%
–Administration Fee (incl. 11% VAT)-Rp 41.915.933-3.51%-5.42%
–Service Fee-Rp 56.143.198-4.70%-7.26%
–Order Processing Fee-Rp 8.247.042-0.69%-1.07%
–Transaction Fee-Rp 871.347-0.07%-0.11%
3Shopee Margin Before COGS (Total Released)Rp 665.445.62055.75%86.00%
Shopee COGS-Rp 238.719.397-20.00%-30.85%
Shopee Ads Cost-Rp 179.039.548-15.00%-23.14%
Adjustments / CompensationRp 1.970.3840.17%
Other Costs (Marketing Cost)-Rp 5.000.000-0.42%-0.65%
4Shopee Net MarginRp 244.657.05920.50%31.62%
Product Discounts
35.00%
Product COGS
20.00%
Total Marketplace Fee
9.08%
Total Marketing Cost
15.51%
Net Margin
20.50%
Net Margin
20.5%
Total Marketplace Fee
-9.1%
Total Marketing Cost
-15.5%
Product Discounts
-35.0%
Product Analysis
Performance & margin per product, Jun 2026
Jun 2026
Highest RevenueTop 5
Serum Glow Vit-CRp 242.8M
Sunscreen Aqua SPF 50+Rp 161.3M
Niacinamide Bright 10%Rp 121.4M
Retinol Night SerumRp 92.4M
Hydra Toner CalmRp 88.7M
Largest MarginTop 5
Serum Glow Vit-CRp 78.1M
Sunscreen Aqua SPF 50+Rp 47.4M
Niacinamide Bright 10%Rp 33.5M
Retinol Night SerumRp 30.9M
Hydra Toner CalmRp 26.1M
Product Details
SKUPRODUCT NAMEVARIANTORDERSQTYREVENUEMARGINMARGIN %
GV30Serum Glow Vit-C 30mlGlow Boost1.6421.710Rp 242.8MRp 78.1M32.2%Detailed Analysis
SS50Sunscreen Aqua SPF 50+40ml1.2051.260Rp 161.3MRp 47.4M29.4%Detailed Analysis
NB10Niacinamide Bright 10%20ml9801.020Rp 121.4MRp 33.5M27.6%Detailed Analysis
RN15Retinol Night Serum 15ml0.5%540560Rp 92.4MRp 30.9M33.4%Detailed Analysis
HT100Hydra Toner Calm 100mlFragrance Free870905Rp 88.7MRp 26.1M29.4%Detailed Analysis
CM50Ceramide Moist Cream 50gRich712740Rp 71.0MRp 19.2M27.0%Detailed Analysis
CG35Cushion Glow SPF 3502 Natural415430Rp 58.5MRp 12.8M21.9%Detailed Analysis
LT01Lip Tint Velvet Matte01 Rosewood905980Rp 41.1M-Rp 4.5M-11.0%Detailed Analysis
MW200Micellar Cleansing Water 200mlRefill560580Rp 33.7MRp 6.4M19.0%Detailed Analysis
AS15Acne Spot Gel 15mlOriginal488505Rp 22.2M-Rp 2.9M-13.0%Detailed Analysis
My BalanceAll time ▾
Total balance
$74,503.00
⬆ Total earned last time +$14,503.00
⚡ Total bonus +$700.00
My IncomeJuly 2025
Total income
$101,333.00
▾Min -2.4% APR ⚡Earned +$458.00
Salary
$28.3K
Business
$38.5K
Invest.
$34.4K
$26,830.00
Total expense
Min 7.4% APR ⚡Earned +Rp 800.000
050100
July 2025Goal of 75% ⚡

Join 1,000+ businesses who rely on Lacak

Marketplace margins getting thinner? The only ones who survive are those willing to understand and evaluate the numbers.

With our smart tracker tools, you get a 360° report in just 5 minutes, no team needed, cost-efficient, everything done fast. Time for you to take action, not burn all your time on evaluation.

Marketplace Fees
15–25%

of GMV goes to marketplace admin & service fees on every transaction.

Discount Deductions
25–30%

GMV cut by product discounts & promos before the funds are actually paid out.

Affiliate Fee & Marketing Cost
35–40%

affiliate & endorsement commissions deducted on every sale made through creators.

Net Margin
5–25%

net margin left after marketplace fees, discounts & affiliate fees.

Net Income This Month ▾
Rp 57.180.000 +15% ↑
Jan 2026 : Rp 57.180.000
JanFebMarAprMayJun

Finance features that
keep your sales under control

Built specifically for SMEs selling online on Indonesian marketplaces. From margin calculations to automated financial reports, everything's done in seconds.

Product Margin CalculatorTikTok Shop ▾
Check for a healthy margin before launching / changing prices
Selling PriceRp 65.000
COGSRp 17.000
Marketplace Fee UPDATED18.5%
Affiliate / Marketing25.0%
Net Margin
Rp 19.725 · 30.3%
HEALTHY MARGIN ✓
Sales Overview···
70.8% Sales Growth
Number of Sales
2,343+15%
Total Revenue
Rp 30.9M45%
Product Income OverviewThis Month ▾
Analyze each product's margin: which ones drive most of the profit, which ones lose money
Revenue (GMV)
100%
Rp 1.19B
›
After Discounts
79.2%
−20.8% discounts
›
Marketing ROI
4,6×
−10.8% ad spend
›
Net Profit
30.1%
Rp 359M
ProductRevenueDiscountsMkt ROINet Profit
Serum Glow Vit-CRp 420M−22%5×33%
Sunscreen SPF 50Rp 318M−18%4×30%
Acne Spot GelRp 256M−28%3×24%
Hydra TonerRp 199M−19%5×32%
Lip Tint MatteRp 88M−34%1×−11%
Marketplace Fees
Always auto-updated
LIVE
Shopee Admin Fee
incl. 11% VAT
12,0%
↑ +1,5%
└Service Fee+5%
└Extra Voucher Fee+4%
└Free Shipping Fee+3%
TikTok Shop Commission
per completed order
8,0%
↑ +2,0%
Affiliate / AMS
creator commission
up to 10%
fixed
Synced directly from each marketplace's T&C, no need to check manually & recalculate in Excel.
Last updated: today, 09:24 WIB
HOW IT WORKS

How does Lacak work?

From data upload to business strategy, everything is automated, in minutes.

Upload Data
Auto Generate
Report
AI Insights
Business
Strategy Plan

What sellers say about Lacak

Real stories from sellers who trust Lacak to manage their finances smarter, faster, and more efficiently.

★★★★★

"I used to be so confused: revenue went up, but my wallet didn't, haha. Turns out I didn't realize that shipping products to Affiliates came with a sizeable shipping deduction, plus my COGS was huge, since the products are expensive too (electronics)."

Dewi Anggraini
Finance Lead, Electronics Brand
★★★★★

"We sell on five platforms. Lacak gives us one correct number for revenue and payouts. Every month, the tool pays for itself."

Rizky Pratama
Founder, Toko Sehat
★★★★★

"The automated reports are super neat, we can send them straight to investors. Onboarding took less than half a day, too."

Putri Maharani
COO, Lini Fashion

Frequently asked questions

Still unsure? Here are a few things that might be on your mind before you start.

Who is Lacak for?+

It fits every business selling online on marketplaces, from micro and small businesses to brands that are scaling up. As long as you sell on Shopee or TikTok Shop, you can use Lacak right away.

Why use Lacak?+

Because you no longer have to deal with the hassle. Just upload your report, wait about 10 seconds, and your financial data is done, complete with margins and insights per product.

I already have a finance team. Is it still a good fit?+

It's actually a great fit as a control tool to check your team's work. Selling on marketplaces is very dynamic, and costs like marketplace fees can change every week. Lacak helps make sure the numbers from your finance team are always accurate and up to date.

Is my data safe?+

Yes. Lacak doesn't store your report data on our servers. All calculations run instantly on the spot, so your sensitive business data stays in your own hands.

Do I need to be good at Excel or accounting?+

No. Lacak is built so anyone can instantly understand their business's financial condition, without needing to know Excel formulas or confusing accounting terms.

Can I try it before paying?+

Yes. You can start for free, no credit card needed. Try it first, see for yourself how your financial reports get done in seconds, then decide whether to continue.

Let's make finance
simple & easier.

Join the businesses automating their marketplace finance with Lacak. No spreadsheets, no late nights.

Start Lacak Finance