Bookkeeping for Online Sellers: Payout Reconciliation, Fees, Refunds, Chargebacks, Reserves & Clearing Accounts
Match every payout to the orders behind it: gross sales, fees, refunds, chargebacks, held reserves and currency differences, posted cleanly through a clearing account, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you keep the books of a fictional online tea shop. You turn an order report into expected payouts with SUMIFS, match every payout to the bank statement with XLOOKUP and flag differences with ABS and a tolerance. You split fees by type and month, follow full and partial refunds into the payouts they hit, measure chargeback win rates and costs and post a lost dispute as journal entries. You calculate a rolling reserve balance with SUMIFS on dates and EOMONTH, run every line through a payout clearing account until it returns to zero, and finish with a month-end reconciliation summary and a chart.
Lessons
- From Gross Sales to Expected Payout Pro
- Matching Payouts to the Bank Statement Pro
- Fee Analysis: Fee Types, Monthly Fee Rates and the Effective Rate per Order Pro
- Refunds & Partial Refunds Across Payouts Pro
- Chargebacks: Disputed Amounts, Dispute Fees, Win Rate and Reversal Entries Pro
- Rolling Reserves: Held Amounts, Release Dates and the Reserve Balance Pro
- The Payout Clearing Account: Post Every Line, End at Zero Pro
- Month-End Reconciliation Summary Pro