Your e-commerce Profit & Loss, reconciled to the cent
ProfitLens pulls Shopify orders, Triple Whale ad spend, your supplier's actual per-order costs and the full ledgers of PayPal, Oceanpayment and WorldFirst into one P&L: revenue, COGS, fees, refunds, chargebacks, reserves, payouts and net profit by day, week, month or any date range. This page is the demo we built for a client brief; everything on it works.
The demo runs on a simulated store (120 days, ~9,000 orders) so you can click everything safely. Each connector has a live mode: paste your API keys and the same screens run on your real accounts. Demo data resets every night.
What is in the box
P&L dashboard
Net revenue, net profit, margins, ad spend, blended ROAS/MER, CPA, AOV, profit per order, with period-over-period deltas and a full P&L statement. Day, week, month, custom range. CSV export.
Order-level profitability
Every Shopify order matched to the supplier's actual product cost, shipping, fulfilment fee and packaging plus the exact processor fee and any refund or chargeback. Estimates until the supplier ships, then actuals.
Payment provider tracking
PayPal, Oceanpayment, WorldFirst: captures, processing and FX fees, refunds, disputes and chargebacks with fees, rolling reserves held and released, payouts and settlements, pending balances.
Automated sync + reconciliation
Every source syncs every 5 minutes on its own cursor. Rows upsert on provider + external id so nothing is counted twice. Seven automated checks: order ↔ capture, amounts, orphans, duplicates, refunds, payout sums, cost coverage.
Security
AES-256-GCM credential vault keyed from a server-only secret, scrypt passwords, HttpOnly SameSite sessions, brute-force limits, CSRF header, strict CSP, admin/viewer roles, full audit log, TLS via Caddy.
Add-ons optional
- Anomaly alerts (ROAS, margin, refund and chargeback rate) by email/Slack
- Daily P&L digest
- Break-even ROAS and max CPA per product from real fees
- Product profit leaderboard and cash-flow forecast of reserves and payouts
Integrations
Fixed price, complete delivery
all-inclusive: development, all six integrations, testing, security, deployment and revisions to spec
to a fully functional dashboard on your own accounts, with daily progress builds
online for questions, changes and reviews during the build
Recurring third-party cost: hosting only, about $15–25/month on a small cloud VM (or your own server). No per-seat or per-order fees.