Manual Fee Calculation Across Sellers
Commission rates differed by category and seller tier, and were applied by hand, so the same transaction type could end up with different fees depending on who processed it.
A multi-category marketplace operator was calculating platform fees and seller commissions by hand, with no consistent record of how a payout was reached. We designed and built an MVP that calculates commissions automatically, tracks every fee and refund against a transaction, and gives sellers a clear view of what they are owed.
Running a multi-category marketplace means calculating fees that vary by category, seller tier and transaction type, then tracking refunds and reversals against those fees over time. Doing this manually in spreadsheets left the operator unable to answer a simple question with confidence: what does this seller actually owe, and why.
This platform brings transaction fee calculation, seller balances, refund handling and settlement records into one connected system, so the marketplace operator and its sellers can both see, at any moment, exactly how a payout was reached.
Commission rates differed by category and seller tier, and were applied by hand, so the same transaction type could end up with different fees depending on who processed it.
When a seller questioned a payout, staff had to reconstruct the transaction, fees and any refunds from scattered records, turning a simple question into a lengthy investigation.
Sellers had no reliable way to see what they were owed before a payout arrived, which made the platform feel unpredictable and undermined confidence in the fee structure.
A commission and settlement engine centered on giving both the marketplace operator and sellers a consistent, traceable view of every fee and payout.
Every transaction has its platform fee and seller commission calculated automatically the moment it settles, removing manual guesswork from the process.
Fee rules can be defined per category and seller tier, so pricing reflects real business terms instead of a single flat rate applied everywhere.
Sellers can see their current balance and what is driving it at any time, instead of waiting for a payout to find out what they earned.
When an order is refunded, the related commission is reversed automatically, keeping seller balances accurate without manual correction.
Each payout cycle produces a settlement record summarizing what was paid and why, giving both sides a clear reference for that period.
Every transaction can be inspected down to its individual fee components, so a seller's question about a specific order can be answered directly.
We mapped how commissions were currently calculated across categories and seller tiers, to understand the rules the system needed to encode.
We scoped the smallest engine that could calculate a commission, apply a refund reversal and produce a settlement record end to end.
We designed balances, fee breakdowns and settlement views around a single principle: every number should be traceable back to its source.
The engineering team built the fee engine and settlement workflows and verified them against realistic transaction, refund and payout scenarios.
The MVP was validated against real transaction flows, creating a foundation to learn from actual commission and payout activity before expanding scope.
A commission system only earns trust when every figure can be explained. Build the smallest engine that calculates correctly and shows its work, then let real transactions tell you what to add next.
Commission and fee logic is defined as configurable rules rather than hard-coded values, so category and tier pricing can evolve without rebuilding the system.
Once a fee or payout is recorded, its ledger entry is never altered in place, keeping the settlement history reliable for audits and disputes.
Finance staff, marketplace admins and sellers each see the balances and records relevant to their role, keeping sensitive figures appropriately scoped.
Manual adjustments, reversals and corrections are all logged with their reason, so the story behind any balance change can be reviewed later.
× Commissions calculated by hand per transaction
× Inconsistent fee application across sellers
× No clear trail behind a payout figure
× Refunds corrected manually and inconsistently
× Sellers unable to see balances before payout
✓ Automatic commission calculation per transaction
✓ Consistent category and tier-based fee rules
✓ Transaction-level fee breakdown on demand
✓ Automatic refund and commission reversal
✓ Real-time seller payout balance visibility
Calculate once. Explain it always. Pay with confidence.
The goal was never to make fee rules more complicated, but to make them consistent and visible. By turning manual commission math into an automatic, traceable process, the MVP gives the marketplace operator and its sellers a shared, dependable view of every payout.
“A marketplace keeps sellers only as long as they trust the payout. Build the engine that can show its work on every fee before you build anything else.
”
Bring us your marketplace or fintech idea, no matter how early. MVPHUB can help you validate the core fee and settlement workflow and turn it into a professionally verified, market-testable MVP.
AI-accelerated. Expert-verified. Focused on the payout trust your first release needs to earn.