How to retrieve the Payout Bank Reference value from the Shopify Payments Payout

GraphQL Admin API Troubleshooting
1

I’m looking to retrieve the Bank Reference field, visible in the UI of the Payouts details page in admin. I am able to pull various payout data utilising the query relating to payouts in the documentation, but am unable to identify where the Bank Reference field is accessible (if it is at all) -

2

Hey Conor,

It doesn’t look like this field is exposed to the API - what would be your use case for accessing this field? I can at least connect with the product team to see if support could be added?

3

Thank for coming back to me, we’d like to send the value in the bank reference to the associated customer deposits within the erp NetSuite to help with bank and accountancy reconciliation.

4

Hi again Conor,

Appreciate you sharing the use-case, I’ve reached out to the payments product team and will let you know what I hear back.

5

Hi again Conor,

The product team have said they’re exploring adding support for this - it possibly will be in the next API version but cannot confirm that for 100%.

Hope this helps!

1 Like
6

I’d also vote to have this data exposed. Shopify changed its payout process - now for some reason you guys are doing split payouts every business day, and doing payouts on weekends/holidays. I need the Bank wire ID so I can run my reports with our corporate finance team.

7

Hi Conor,

It looks like the Bank Reference field is not currently available through the Shopify API, which is preventing you from retrieving it for Shopify integration with NetSuite. This is definitely an issue for automating bank and accountancy reconciliation.

Since Shopify’s product team is considering adding support for this field in a future API version, it might be worth following up with them for updates. In the meantime, you could explore potential workarounds, such as manual data extraction or using a custom integration to scrape the field from the UI.