Fee Analysis: Fee Types, Monthly Fee Rates and the Effective Rate per Order
This lesson is part of the course
In this lesson
You split a fee log into a month × fee-type grid with two-criteria SUMIFS, total the fees per month, turn them into a fee rate on gross sales and work out the effective fee rate of a single small order.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- From Gross Sales to Expected Payout Locked
- Matching Payouts to the Bank Statement Locked
- Fee Analysis: Fee Types, Monthly Fee Rates and the Effective Rate per Order Locked
- Refunds & Partial Refunds Across Payouts Locked
- Chargebacks: Disputed Amounts, Dispute Fees, Win Rate and Reversal Entries Locked
- Rolling Reserves: Held Amounts, Release Dates and the Reserve Balance Locked
- The Payout Clearing Account: Post Every Line, End at Zero Locked
- Month-End Reconciliation Summary Locked