Matching each payout to the bank
Shopify, Amazon, PayPal and Stripe each send a settlement report with every payout. The report lists orders, fees, refunds, chargebacks and adjustments for the period. Averan imports the report, posts gross sales to income, posts each fee to its own expense account, posts refunds against sales, and posts the net to a clearing account. The clearing account empties to zero when the bank deposit arrives. A balance left in clearing points to a missing deposit or a report line that needs a second look.
Worked example: one Shopify payout
A Shopify payout covers $20,000 of gross sales for the week. Payment processing fees total $620 and refunds total $1,140. The deposit in the bank is $18,240. The books show $20,000 of sales, $1,140 of refunds against sales, and $620 of processing fees, which add to $18,240 and clear the account. Booking the $18,240 as sales would have hidden $1,760 of refunds and fees. The figures are an illustration.