Multi-Channel Reconciliation

How it works

Two logs, one comparison: what each channel says it paid you, and what your bank says it actually received.

1. Inputs: Variance threshold and anomaly threshold that drive reconciliation status
2. Channels: Your channel master: type, processor, expected fee %, and payout cycle
3. Sales Log: Per channel and period: gross sales, returns, fees, shipping, and tax, rolling up to an expected payout
4. Bank Log: Actual deposits: date, channel, period, and amount
5. Reconciliation: Per channel and period: expected payout versus actual deposits, variance, status, and an audit trail
6. Channel Recon: Pick a channel for six months of variance and a fee-rate stability check
7. Dashboard: The portfolio view: total gross, total deposits, total variance, anomaly count, and top issues to investigate

Steps to use it

1. Set variance and anomaly thresholds on Inputs
2. Confirm your channel master on Channels: expected fee %, payout cycle, currency
3. Paste each channel’s monthly gross sales, returns, fees, shipping, and tax into Sales Log
4. Paste actual deposits into Bank Log: date, channel, period, amount
5. Review Reconciliation for variance and status by channel and month
6. Use Channel Recon for a deep dive on any channel, then Dashboard for the portfolio view

Status logic is built in: RECONCILED within 0.5% variance, CHECK between 0.5% and 2%, and ANOMALY beyond 2%, worth investigating immediately. Common causes include held payouts, chargebacks posted a month late, refund timing, currency drift, and mid-month fee changes.