Shopify Integration - Confirm Daily payout settlements when importing
Subject: Request for Integration Enhancement of Xero and Shopify based on User Feedback
Dear Product Development Team,
Following my recent discussions with the Xero support team and research around user feedback on the issues I have experienced, I’d like to encourage relaying the integration feedback received from user experiences including my own, particularly regarding the timing differences between Shopify’s daily payout settlement and when the Xero integration pulls the data to create invoices. You can review some of this feedback through the following link: Shopify Xero Integration User Feedback: https://apps.shopify.com/xero/reviews?ratings%5B%5D=1
We’ve observed a gap in understanding the timing of these processes. I suggest working closely with Shopify to determine if there is a status flag for the daily rollup/payout that confirms it as settled for payment. This would help identify the optimal time to pull data via the integration into Xero. Additionally, validation checks could be implemented to ensure order numbers in the invoice match with the daily rollup, improving accuracy.
Currently, the setting up of a mock bank account known as a 'clearing account' to post Shopify invoice transactions serves as a workaround to monitor reconciliation by confirming a zero balance when payouts are matched with bank transfers. However, it seems this workaround is needed due to the transaction settling and timing differences with the Shopify > Xero data transfer. If the team can address the timing issue, I believe the user experience will improve significantly.
I hope this information helps the team troubleshoot and enhance the integration’s usability.
Best regards, Craig Jones-Stanley