Issue payout transfers to bank

I need to issue today's payout transfers to our company bank account for the week ending Friday. Pull the settled balance for our main account, confirm the net amount after refunds and fees, then create transfers to US Bank, routing to account ending 4321. Send the transfer batch for approval to Maya in finance and only submit if the net total matches the statement within $5.

Before I hit send on these payout transfers, make it obvious how much cash will land in the bank and why it differs from gross sales. Put the settled total, total fees, chargeback/reserve holds, and refunds at the top. Highlight any negative adjustments larger than $100 and flag payments that are pending longer than seven days so Maya can approve quickly.

We just reconciled and the settled balance is $8,400 when I expected $12,000. I worked with product and there were eight refunds and two chargebacks this week but I can't find a clear listing that totals the delta. What's the most likely cause, which specific reports or transaction views should I pull to prove it, and what is the fastest way to get Maya to accept a smaller payout today?

Every month we underestimate outbound payouts because fees, refunds and reserve holds are recorded in different places, and Maya loses trust when totals shift late. Which two habits should I change to stop the last-minute recon panic: one to catch these deltas earlier in the week, and one to present a reconciled number Maya will sign off on without delay?