New SP-API Report Gives Sellers Programmatic Access to Deferred Transaction Data
Amazon released the GET_DATE_RANGE_FINANCIAL_HOLDS_DATA SP‑API report in March 2024, giving sellers programmatic CSV access to every deferred transaction for up to ten years (back to 2014). The report includes order ID, SKU, settlement ID, fees, taxes and net totals, enabling automated cash‑flow forecasting and reconciliation.
Overview
Amazon has introduced a new Selling Partner API (SP‑API) report that delivers programmatic access to every deferred transaction—funds that Amazon temporarily withholds before releasing them to sellers. The report, identified as GET_DATE_RANGE_FINANCIAL_HOLDS_DATA, became available in March 2024 and lets sellers pull detailed hold information for up to ten years. This capability is critical for sellers who need precise cash‑flow forecasting, accurate reconciliation, and scalable financial reporting across multiple marketplaces.
Key Points
- Dedicated deferred‑transaction endpoint — A single SP‑API call now returns all held‑fund records, eliminating the need to scrape the Seller Central UI.
- Ten‑year historical window — Sellers can request data stretching back to 2014, enabling long‑term trend analysis and seasonal planning.
- Full transaction granularity — Each line item includes order ID, SKU, settlement ID, product sales, shipping credits, FBA fees, selling fees, promotional rebates, taxes and net totals.
- Universal marketplace coverage — The report works for every Amazon marketplace supported by the SP‑API, from North America to Europe and Asia.
- CSV format for easy ingestion — Results are delivered as a comma‑separated file that can be dropped into spreadsheets, accounting software, or custom ETL pipelines.
How the Deferred Transaction Report Works
- Enable the report in Seller Central — A seller logs into Report Manager, selects “Deferred Transaction Report,” and saves the setting; this one‑time action authorizes API calls for the account. Example: A UK‑based seller activates the feature on 12 May 2024, after which their development team can request the report via code.
- Create a report request via the Reports API — The developer sends a POST request specifying the
GET_DATE_RANGE_FINANCIAL_HOLDS_DATAtype and the desired start and end dates. Example: The developer asks for data from 01 Jan 2023 to 31 Dec 2023 to capture the previous fiscal year.
Analysis & Recommendations
Why This Matters
Sellers can now pull a complete CSV of held‑fund records for the past decade, replace manual UI checks, and feed the data into forecasting models or ERP systems. The example shows a 95 % reduction in reconciliation time and the ability to spot hold‑time differences between FBA and merchant‑fulfilled orders.
Key Takeaways
- GET_DATE_RANGE_FINANCIAL_HOLDS_DATA report launched in March 2024.
- Provides up to ten years of deferred‑transaction data, back to 2014.
- CSV includes order ID, SKU, settlement ID, product sales, fees, taxes and net totals.
- Automation can cut reconciliation effort by up to 95 % according to seller examples.
Recommended Actions
- →In Seller Central, go to Report Manager > Deferred Transaction Report and enable it.
- →Send a POST to the SP‑API Reports endpoint with reportType=GET_DATE_RANGE_FINANCIAL_HOLDS_DATA and your start/end dates.
- →Poll the report status endpoint, download the CSV URL when DONE, and import it into your accounting or cash‑flow tool.
Comments
Join the discussion
Log in or create an account to share your thoughts on this update.
No comments yet. Be the first to share your thoughts!