How can I get an annual statement of invoices and payouts for Xero reconciliation?

[DV09]

I need an annual statement of invoices and payouts so I can reconcile against our Xero balance. How can I obtain this? I thought it'd be a simple one click option but can't find anything -- not even payout info!

[Report-Pundit]

Hi DV09

Report Pundit is a powerful reporting cost-effective app built by working with thousands of Shopify merchants.

1) We provide Shopify Payouts and Paypal Payout details.

a) Shopify Payouts:- We have the option to show the payout amount for each order.  A couple of fields used by the Shopify merchants are Transaction fee, Transaction amount, Sales amount, Tax, Shipping, Payout ID, and Product details. You can reconcile the reports with Xero.

We can even break down the payout amount for each line item or by each product name and we can summarize the Payout details for each Payout ID or Payout Date.

b) Paypal Payouts:- We have the additional integration to fetch the data from Paypal API for the Shopify orders payout. Fields used by Shopify Merchants are transaction fees for each order, Available balance, Net amount of the order, and much more information.

c) Additionally we provide Amazon Pay, Klarna, and Stripe Payouts in Report Pundit. 

We have a 14-day free trial to test all the custom reports. Our live chat support team is available to create any custom report for free.

Thanks,

John

[CloudlabSam]

Hi there - our free app Report Toaster can help with this. You can get a list of orders filtered however you like, with associated gateway transaction fees for Shopify Payments and Paypal. Feel free to take a look and let me know if you have any questions. Thanks!