How can I effectively reconcile payouts in Quickbooks?

2 0 0

Taking suggestions on finding/creating a report that combines the information in the Summary Report with the information in each payout report. Given that refunds are sometimes deducted from a payout for sales reported in an earlier payout, I am having trouble creating the correct journal entry to offset every payout that is deposited.

Also taking suggestions on a way to have shopify process payouts at the END of every day and not split payouts in the middle of a day so that orders on taking place on the same day may be in different payouts.

THANK YOU