Pricing

$250.00 / 1,000 report processeds

Try for free

Go to Apify Store

Amazon Settlement Report Normalizer (Flat File V2)

Try for free

Turn an Amazon Flat File V2 settlement report into a clean reconciled ledger: per-fee-type and per-SKU summaries, per-order rollups, and an explicit deposit reconciliation check. Paste-only input. Aggregation only - not P&L or accounting advice.

Pricing

$250.00 / 1,000 report processeds

Rating

0.0

(0)

Developer

Tom

Actor stats

Bookmarked

Total users

Monthly active users

5 days ago

Last modified

Categories

E-commerce

Business

Automation

Security

You can access the Amazon Settlement Report Normalizer (Flat File V2) programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in API & Integrations in Apify Console.

Python

JavaScript

CLI

OpenAPI

HTTP

MCP

1from apify_client import ApifyClient
2
3# Initialize the ApifyClient with your Apify API token
4# Replace '<YOUR_API_TOKEN>' with your token.
5client = ApifyClient("<YOUR_API_TOKEN>")
6
7# Prepare the Actor input
8run_input = { "report_text": """settlement-id\tsettlement-start-date\tsettlement-end-date\tdeposit-date\ttotal-amount\tcurrency\ttransaction-type\torder-id\tmerchant-order-id\tadjustment-id\tshipment-id\tmarketplace-name\tamount-type\tamount-description\tamount\tfulfillment-id\tposted-date\tposted-date-time\torder-item-code\tmerchant-order-item-id\tmerchant-adjustment-item-id\tsku\tquantity-purchased\tpromotion-id
91000000001\t2026-10-01\t2026-10-15\t2026-10-17\t8.59\tUSD\tOrder\t111-0000001-0000001\t\t\t\tAmazon.com\tItemPrice\tPrincipal\t25.00\tAFN\t2026-10-02\t\t\t\t\tWIDGET-1\t1\t
101000000001\t\t\t\t8.59\tUSD\tOrder\t111-0000001-0000001\t\t\t\tAmazon.com\tItemPrice\tTax\t2.00\tAFN\t2026-10-02\t\t\t\t\tWIDGET-1\t\t
111000000001\t\t\t\t8.59\tUSD\tOrder\t111-0000001-0000001\t\t\t\tAmazon.com\tItemFees\tCommission\t-4.05\tAFN\t2026-10-02\t\t\t\t\tWIDGET-1\t\t
121000000001\t\t\t\t8.59\tUSD\tOrder\t111-0000001-0000001\t\t\t\tAmazon.com\tItemFees\tFBAPerUnitFulfillmentFee\t-5.50\tAFN\t2026-10-02\t\t\t\t\tWIDGET-1\t\t
131000000001\t\t\t\t8.59\tUSD\tOrder\t111-0000001-0000001\t\t\t\tAmazon.com\tPromotion\tShippingDiscount\t-1.50\tAFN\t2026-10-02\t\t\t\t\tWIDGET-1\t\t
141000000001\t\t\t\t8.59\tUSD\tRefund\t111-0000002-0000002\t\t\t\tAmazon.com\tItemPrice\tPrincipal\t-18.00\tAFN\t2026-10-05\t\t\t\t\tWIDGET-2\t-1\t
151000000001\t\t\t\t8.59\tUSD\tRefund\t111-0000002-0000002\t\t\t\tAmazon.com\tItemRelatedFees\tRefundCommission\t2.94\tAFN\t2026-10-05\t\t\t\t\tWIDGET-2\t\t
161000000001\t\t\t\t8.59\tUSD\tadjustment\t\t\t\t\tAmazon.com\tAdjustment\tWAREHOUSE_DAMAGED\t4.50\tAFN\t2026-10-08\t\t\t\t\tWIDGET-1\t\t
171000000001\t\t\t\t8.59\tUSD\tFBA Inventory Reimbursement\t\t\t\t\tAmazon.com\tFBA Inventory Reimbursement\tReimbursement\t6.20\tAFN\t2026-10-09\t\t\t\t\tWIDGET-3\t\t
181000000001\t\t\t\t8.59\tUSD\tMysteryCharge\t\t\t\t\tAmazon.com\tOther\tOTHER\t-3.00\t\t2026-10-10\t\t\t\t\t\t\t
191000000002\t2026-10-16\t2026-10-31\t2026-11-02\t\tUSD\tServiceFee\t\t\t\t\tAmazon.com\tSubscription\tSubscription Fee\t-39.99\t\t2026-10-16\t\t\t\t\t\t\t
201000000002\t\t\t\t\tUSD\tOrder\t111-0000003-0000003\t\t\t\tAmazon.com\tItemPrice\tPrincipal\t12.49\tAFN\t2026-10-20\t\t\t\t\tGADGET-9\t1\t
21""" }
22
23# Run the Actor and wait for it to finish
24run = client.actor("tomwang/amazon-settlement-normalizer").call(run_input=run_input)
25
26# Fetch and print Actor results from the run's dataset (if there are any)
27print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
28for item in client.dataset(run.default_dataset_id).iterate_items():
29    print(item)
30
31# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

Amazon Settlement Report Normalizer (Flat File V2) API in Python

The Apify API client for Python is the official library that allows you to use Amazon Settlement Report Normalizer (Flat File V2) API in Python, providing convenience functions and automatic retries on errors.

Install the apify-client

$pip install apify-client

Other API clients include:

Amazon Settlement Report Normalizer (Flat File V2) API in JavaScript

Amazon Settlement Report Normalizer (Flat File V2) API through CLI

Amazon Settlement Report Normalizer (Flat File V2) OpenAPI definition

Amazon Settlement Report Normalizer (Flat File V2) API

Amazon ASINs Scraper

junglee/amazon-asins-scraper

Gets you product data from Amazon. Unofficial API. Scrapes and downloads product information without using the Amazon API, including reviews, prices, descriptions.

Junglee

2.3K

5.0

(11)

Amazon Keyword Scraper

crafter/amazon-keyword-scraper

This scraper scrapes products from Amazon search using keywords that you give it. It returns the price, product URL, and ASIN.

Eve Ezetta

217

1.0

(1)

Amazon Storefront Scraper

piotrv1001/amazon-storefront-scraper

Extracts all products from an Amazon seller's storefront page. Collects ASIN, title, price, rating, review count, Prime status, and Best Seller badges with deduplication. Ideal for competitive analysis, price monitoring, and marketplace research across 12 Amazon regions.

FalconScrape

132

Amazon Jobs Scraper

powerai/amazon-jobs-scraper

Scrape job listings from Amazon Jobs by providing a search URL, with automatic pagination and comprehensive job information extraction.

PowerAI

156

5.0

(6)

Amazon Products Easy Scraper

xmiso_scrapers/amazon-products-scraper

Fastest amazon products scraper yet scraping up 2k rows/minute

Miso

5.0

(7)

Amazon Price Scraper

wilico/amazon-price-scraper

Extract product data from Amazon. Scrapes prices, availability, and product details without using the Amazon API.

Wilico, Inc.

5.0

(3)

Address Normalizer

parseforge/address-normalizer

Normalizes addresses from a list or CSV file into standardized components like street, city, state, ZIP, and country. Supports custom normalization rules.

ParseForge

5.0

(1)

Free Amazon Seller Products Scraper

easyparser/amazon-seller-products

Retrieve Amazon seller product listings including ASIN, title, price, rating, Prime status, brand, categories, availability, and refinement filters by seller ID or storefront URL.

Easyparser

Amazon Product Scraper

codingfrontend/amazon-product-scraper

Scrape product listings from Amazon.in based on search term, ASINs, product URLs, or category URLs with detailed product information.

Coding Frontned

212

Amazon Reviews Scraper

reefapi/amazon-reviews-scraper

Scrape Amazon product reviews as clean JSON — review title, body, star rating, author, date, verified-purchase flag, helpful votes and variant, for any ASIN across 19 Amazon marketplaces, plus an AI 'customers say' summary of what buyers praise and complain about. No proxies, no CAPTCHAs, no login.