TAX PAYOUT RECONCILIATION
TAX PAYOUT RECONCILIATION EXCEL WORKBOOK why your payout never matches your sales
Fees, refunds, chargebacks, reserves and timing all sit between a sale and a deposit, which is why the two numbers never agree. This workbook walks that gap one line at a time.
Four sheets, no macros. Works in Excel, Google Sheets and Numbers.
WHAT’S INSIDE
From your sales report to your bank statement
The bridge
Start with what customers actually paid, take off fees, refunds, chargebacks, reserves and timing, and see what should have landed in the bank. Whatever is left is the only thing worth chasing, and there is a checklist for that too.
A journal that balances
The same period written as double entry, with a balance check that proves the numbers hang together. This is the sheet to send your accountant, and the one that stops an unexplained difference quietly disappearing into sales.
A payout log
Twenty-four payouts logged individually, with the mismatched ones counted and the largest difference flagged. Find the single payout that broke the month instead of re-checking all of them.
