Title: Excel Rest API payouts data
Last modified: June 19, 2026

---

# Excel Rest API payouts data

 *  Resolved [vladvalentine](https://wordpress.org/support/users/vladvalentine/)
 * (@vladvalentine)
 * [1 day, 23 hours ago](https://wordpress.org/support/topic/excel-rest-api-payouts-data/)
 * I’ve been able to pull data from [https://website.com/wp-json/wc/v3/orders](https://website.com/wp-json/wc/v3/orders)
   via power query to get all the order transactions, but I get a 500 error trying
   to get the payout data from /wp-json/wc/v3/payments/deposits/transactions
 * I need a single report that provides the full transaction list like a bank account
   does for the accountant and auditors. Needs to show everything from the orders
   table already extracted, but also needs the payout/payin transactions as well.
   If there is a report built in, that would be better, but it looks like analytics
   is all segregated.
 * I am fine to manage the data once extracted, so I’m only looking for help to 
   get the table with the payouts list if possible. Thanks

Viewing 1 replies (of 1 total)

 *  Plugin Support [Frank Remmy (woo-hc)](https://wordpress.org/support/users/frankremmy/)
 * (@frankremmy)
 * [1 day, 22 hours ago](https://wordpress.org/support/topic/excel-rest-api-payouts-data/#post-18943241)
 * Hi [@vladvalentine](https://wordpress.org/support/users/vladvalentine/),
 * The 500 error on `/wp-json/wc/v3/payments/deposits/transactions` makes sense.
   That specific endpoint doesn’t actually exist in WooPayments, which is why it’s
   failing. The deposits-related routes that are available are `/wc/v3/payments/
   deposits` (list of deposits) and `/wc/v3/payments/deposits/{deposit_id}` for 
   individual deposit details. Those may get you closer to the payout data you need.
 * Since these are WooPayments-specific endpoints rather than WooCommerce core REST
   API routes, this thread is better handled in the WooPayments support forum where
   the team has direct visibility into those APIs: [https://wordpress.org/support/plugin/woocommerce-payments/](https://wordpress.org/support/plugin/woocommerce-payments/)
 * I’d be closing this one so when you repost there, it’d help to mention exactly
   what data fields you need in your report (e.g. payout date, amount, fee, net)
   so the team can point you to the right endpoint and parameters.

Viewing 1 replies (of 1 total)

You must be [logged in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fexcel-rest-api-payouts-data%2F%3Foutput_format%3Dmd&locale=en_US)
to reply to this topic.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [Excel](https://wordpress.org/support/topic-tag/excel/)

 * 1 reply
 * 2 participants
 * Last reply from: [Frank Remmy (woo-hc)](https://wordpress.org/support/users/frankremmy/)
 * Last activity: [1 day, 22 hours ago](https://wordpress.org/support/topic/excel-rest-api-payouts-data/#post-18943241)
 * Status: resolved