Matching Payouts to the Bank Statement
This lesson is part of the course
In this lesson
You look up what the bank actually received for each payout with XLOOKUP, calculate the difference, give every payout a status (Matched, Check or Missing) and measure the days the money was in transit.
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