Turn Shopify order exports into auditable vendor statements.

Upload a Shopify Orders CSV, vendor payout rules, and optional manual adjustments. The alpha calculates vendor balances, flags ambiguous refunds and missing rules, then creates a lockable payout batch with a SHA-256 manifest.

Alpha limitation: Shopify's standard order CSV exposes the order's total refunded amount, but not always the exact refunded line-item allocation. Single-vendor refunds can be handled automatically. Multi-vendor refunded orders are proportionally estimated and always flagged for review. A production app would use Shopify's Refund API for exact allocation.

1. Input files

Shopify Orders CSVExpected columns include Name, Paid at, Lineitem quantity, Lineitem price, Lineitem discount, Vendor, Refunded Amount and Currency.

Vendor rules CSVColumns: Vendor, Payout Rate %, optional Payment Fee Share %, Notes.

Manual adjustments CSV (optional)Columns: Vendor, Amount, Reason. Positive adds to payout; negative subtracts.

2. Batch settings

Period start

Period end

Default currency

Global payment fee %

Refund allocation

Batch label

The alpha is read-only and never edits Shopify. All processing happens in this browser. Closing the page clears uploaded data unless you export the batch manifest.

Orders0

Vendors0

Gross line sales$0

Final payout$0

Review flags0

Batch review

Vendor	Gross	Discounts	Refund allocation	Fee share	Store commission	Adjustments	Final payout	Status

Vendor statements

Review issues

Severity	Order	Vendor	Issue	Suggested action

Tester feedback export

This section records only interaction counts and your answers below. It does not include uploaded order rows, customer emails, SKUs, vendor names, prices, or payout amounts. Nothing is sent automatically; you choose whether to copy or download the summary.

Your role

Number of vendors / consignors

Current payout method

Would you run a second payout period?

Statement clarity

Monthly value, if exact refunds were supported

What was the biggest problem or missing feature?