View payout reconciliation reports

Bring up the payout reconciliation report for June and reconcile it to our QuickBooks bank deposits. Export the report grouped by payout ID, include fees and refunds lines, then match each payout to the bank deposit for June 5, 12, 19 and 26. Highlight any payout IDs where the bank deposit differs by more than $10 and send those exceptions to Hannah in accounting.

Before I send reconciliation to accounting, surface the problems that will eat their time. Put exceptions up front: payouts that don't match bank deposits, missing fee lines, and refunds that hit later. Give a one-line suggested cause for each exception and the minimum evidence accounting will need to clear it so Hannah can accept the file without a long back-and-forth.

I ran reconciliation for June and found seven payouts where the bank deposit numbers are off. Accounting suspects we omitted fee lines, but I don't know if the discrepancies are timing issues or true errors. What's the most likely split between timing and omissions, which three checks will quickly prove which is which, and what wording gets Hannah to pause escalation while I dig in?

We constantly generate payout reconciliation exceptions that force Hannah to stop closing the month. Where are we losing accuracy or time: is it inconsistent export formats, missing fee mapping, or delayed refund lifecycles? Recommend one immediate process change and one small automation that would eliminate the majority of our monthly exceptions within two cycles.