Match sales-channel payouts to orders
Each payout is broken into orders, fees and refunds, so deposits match sales and gaps get explained.
Finance · Ecommerce · On a schedule · Updated
Works with
- Slack
- QuickBooks
- Xero
- Airtable
- Microsoft 365
Slack
QuickBooks
Xero
Airtable
Microsoft 365How do you match sales-channel payouts to orders?
To match sales-channel payouts to orders, set a scheduled Loop in Maito. It splits each payout from Shopify or Amazon into orders, fees and refunds, compares it with the deposit in your books, and posts any gap in Slack with the likely reason. You get one reconciled view per payout.
How it's done today
Bank deposits are treated as sales, and the differences build up unseen.
What Maito does
- Pull payouts and the orders behind them
- Subtract fees and refunds
- Find timing gaps and unmatched orders
- Prepare entries for review
Example
Loop run: Monday 8:00 AM · Weekly payout check
Payout of $11,942.16 deposited Oct 19, covering Oct 12 to 16. Gross sales: $12,880.00 (214 orders) Fees: minus $402.54 Refunds: minus $535.30 (9) Net: $11,942.16. This matches the deposit. Two orders have no payout yet: 10466 ($142.00) and 10470 ($86.50), both placed Oct 16 after the cutoff, so they'll arrive in next week's payout. Catch: refund fees. Eight of the nine refunds also lost their original fees, $31.20 in all, which aren't returned. That's normal, but it's why net is lower. Source: ecommerce payout report and accounting software. Attached: payout-oct-19.xlsx.
@Maito prepare the entry for the books.
One entry is prepared for your review: sales $12,880.00, fees $402.54, refunds $535.30, bank $11,942.16. I haven't posted it.
Maito (8:00 AM):
Payout of $11,942.16 deposited Oct 19, covering Oct 12 to 16.
Gross sales: $12,880.00 (214 orders)
Fees: minus $402.54
Refunds: minus $535.30 (9)
Net: $11,942.16. This matches the deposit.
Two orders have no payout yet: 10466 ($142.00) and 10470 ($86.50), both placed Oct 16 after the cutoff, so they'll arrive in next week's payout.
Catch: refund fees. Eight of the nine refunds also lost their original fees, $31.20 in all, which aren't returned. That's normal, but it's why net is lower. Source: ecommerce payout report and accounting software. Attached: payout-oct-19.xlsx.
Omar (8:14 AM):
prepare the entry for the books.
Maito (8:17 AM):
One entry is prepared for your review: sales $12,880.00, fees $402.54, refunds $535.30, bank $11,942.16. I haven't posted it.
How to set it up
- Ask your agent
“Every Monday at 8, reconcile last week's payouts with orders, fees and refunds from our store, post the differences in #finance and prepare the books entries for review.”
- Connect ecommerce platform
- Shopify
- Amazon Selling Partner
- Connect accounting software
- QuickBooks
- Xero
- Connect spreadsheet
- Airtable
- Microsoft 365
Not connected yet? Your agent sends you a link to sign in.
What it won't do
It can only explain a gap using what the channel and the books record. Unrecorded adjustments stay as open questions.
Questions
Shopify or Amazon Selling Partner, QuickBooks or Xero, and a spreadsheet in Airtable or Microsoft 365.
No. It reports the match and the gaps. A person approves any entry.
On the schedule you set, such as after each payout or weekly.
