Ballast reports where your Shopify money settled and flags every stream that will never appear in a Shopify payout — right inside Microsoft 365 Copilot. Deterministic, read‑only, and it exports any view to Excel.
Works from an order export you upload — no app, no store connection, and it stores no customer data.
Everything you need to know where your Shopify money went — in one Copilot agent.
Shopify's payout report structurally excludes third-party processors. Ballast names every gateway — Afterpay, PayPal, Shop Pay Installments, GrabPay — whose money will never reach a Shopify payout.
Every order in both the buyer's currency and your home currency — taken from the order's own money bag, never an FX guess. Currencies are kept strictly separate.
Every refund set against the order it came from. You get total collected and net collected as separate lines — never a fake “net sales” that hides tax and shipping.
Tax collected and refunded by destination country, summarised for the period you ask about — filing-ready, and exportable in a click.
Several stores? Roll revenue, tax and refunds up across all of them — kept separate per home currency, never merged — or drill into one.
Any view becomes a formatted .xlsx workbook — money as real numeric cells with the correct currency format, and off-ledger rows flagged.
Settlement, revenue, currencies, tax — and one-click Excel export.
Most tools ask a language model to do the arithmetic. Ballast never does.
Revenue, currencies, tax and export — all from the order data you already have.
See where your Shopify money settled, what will never reach a payout, and export any view to Excel — right inside Copilot.
Upload your orders