Best fit
A marketplace payout can hit the bank while fees, refunds, reserves, timing differences, and missing orders keep the controller from explaining the net deposit.
// E-commerce
Marketplace Settlement Reconciliation Auditor
Tie normalized marketplace orders, fees, refunds, reserves, settlement lines, and bank deposits to an explicit payout-period ledger.
What problem does Marketplace Settlement Reconciliation Auditor solve?
A marketplace payout can hit the bank while fees, refunds, reserves, timing differences, and missing orders keep the controller from explaining the net deposit.
Use it to
- Tie a marketplace payout to normalized order data
- Catch unexpected fee rates and duplicate fees
- Surface refunds missing from the settlement
- Verify settlement batches against bank deposits
What it returns
- Per-order settlement ledger with variance
- Fee-policy and payout findings CSV
- JSON accounting-review gate
- Controller review memo
A representative input and result
input A $100 order has two $8 platform fees, no sale line, and the bank batch still claims a $96.70 deposit under a 3% plus $0.30 fee policy.
result Gate: BLOCK. Duplicate fee, fee-rate variance, order-net mismatch, and bank-deposit mismatch require controller review.
Access and approval boundaries
- Read access to user-supplied local JSON and CSV evidence files.
- Write access only to the selected local audit output directory.
- No browser, network, credential, account, or environment-variable access is required.
Known limitations
- Version 1 requires documented normalized exports and does not ingest every marketplace format directly.
- The tool does not create journal entries or determine tax treatment.
- Timing differences may be legitimate and still require a controller to resolve them.
// choose with context
Is Marketplace Settlement Reconciliation Auditor the right skill?
It returns
Per-order settlement ledger with variance. Fee-policy and payout findings CSV.
Do not use it as
Version 1 requires documented normalized exports and does not ingest every marketplace format directly.
Compatibility, access, version, and licence
- Reads or accesses
- Declared local scope: orders.csv, settlements.csv, fee-policy.csv, bank.csv.
- Compatibility
- Documented normalized JSON and CSV input schemas. Python 3 on Windows, macOS, or Linux. Local files only; no account integration is required.
- Version
- 1.0.0
- Licence
- Review the package licence and seller terms at the linked destination.
Questions
Does it connect to Amazon or Shopify?
No. Version 1 works from normalized local exports.
Does it post to accounting software?
No. It stops at a reviewable ledger.
How are fees checked?
Each fee line is compared with the supplied percentage and fixed-amount policy.
Can it reconcile refunds?
Yes. Order refund values are checked for corresponding settlement lines.
Is this accounting advice?
No. A qualified accounting owner reviews the result.
What does reconciled mean?
The supplied lines tie to expected order nets and bank deposits within one cent.
Marketplace Settlement Reconciliation Auditor keeps proof and approval boundaries visible.
The listing includes the tested package, realistic samples, declared permissions, and known limitations.
Get Marketplace Settlement Reconciliation Auditor on Agensi