Amazon Settlement Reconciliation Skill

Reconcile Amazon Seller Central settlement reports to your bank payouts, offline. One command reads the Flat File V2 settlement reports (.txt), proves the rows add up to Amazon's total-amount, groups everything into accounts, and writes a balanced journal entry per payout, profit per SKU, a breakdown per order, gap and duplicate checks, and bank matching.

Python 3.9+, standard library only. Includes a Claude Code skill (skills/amazon-settlement-reconciliation/SKILL.md) and plugin manifest.

./demo.sh                      # runs on the example store
./run_tests.sh                 # 14 tests
python3 -m amzsettle reconcile ~/Downloads/*.txt --bank bank.csv --out recon/

Get the files from Seller Central > Reports > Payments > All Statements > Download Flat File V2 (one per settlement period, per marketplace). Amazon removes the old Flat File and XML settlement reports on Nov 11, 2026; if you pass one, the tool tells you to download V2 instead.

The default maps amount-type|amount-description (exact match first, then amount-type|*) to accounts such as Sales, Amazon referral fees, FBA fulfillment fees, FBA storage fees, Advertising, Amazon reserve, Sales tax collected and Marketplace facilitator tax. Refund principal stays in Sales (net sales); refunds are still shown separately per SKU. To use your own account names:

python3 -m amzsettle mapping > mapping.json   # edit the right-hand side
python3 -m amzsettle reconcile *.txt --mapping mapping.json --out recon/

examples/mapping.json is the default mapping.

• Not accounting or tax advice. The default mapping is a starting point; have your accountant confirm it, especially tax lines.
• Flat File V2 settlement reports only (not Date Range reports or the Transaction View CSV). One currency per settlement; it does not convert currencies.
• Reads files you download; it does not connect to Amazon or your accounting software. journal.csv is for import or manual entry.

examples/us-store/ has two fictional consecutive settlements (orders, a refund with refund commission, a promotion, FBA fees, subscription and storage fees, advertising, a reserve held and released, an inventory reimbursement) and a bank CSV. examples/make_examples.py regenerates them.