Log Shopify Payments Payouts to Google Sheets Weekly
Reconciling Shopify Payments deposits against your bank means copying payouts out of the admin. This workflow does it every week: it pulls the week's payouts with their gross, fees and net amounts and adds them to a Google Sheet for your bookkeeper.
How it works
3 steps to keep a running payout log ready for bookkeeping
Every Monday morning
Every Monday morning
Get last week's payouts from Shopify Payments
Get last week's payouts from Shopify Payments
Add each payout as a row in Google Sheets
Add each payout as a row in Google Sheets
Ready to keep a running payout log ready for bookkeeping
Get setup in 3 minutes.
FAQs
Will payouts be added twice?
No. Each run only pulls payouts from the previous 7 days.
Can I backfill older payouts?
Run it once by hand with a wider date range to fill in history.
Does it work with QuickBooks or Xero?
This writes to Sheets. You can add a QuickBooks or Xero step to record each payout as a deposit.
Personalize this template
Customize this workflow even further:
You're in good company
"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."
"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."
"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"
keep a running payout log ready for bookkeeping
3 min setup • Fully supported if you need help
