// E-commerce

Marketplace Settlement Reconciliation Auditor

Tie normalized marketplace orders, fees, refunds, reserves, settlement lines, and bank deposits to an explicit payout-period ledger.

Get it on Agensi Browse all skills $19 one-time

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

fixture-backed sample

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.

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