How to Automatically Sync & Import the Settlements Report to Google Sheets (The Hopted Way)

Using an Amazon to Google Sheets integration like Hopted, you set up the connection once, and your data flows automatically.

Step 1.

Install the Hopted browser extension and sign in using your Google Account.

Step 2.

Securely connect your Amazon Seller Central to Google Sheets using Hopted's integration wizard.

Step 3.

In Google Sheets, from the list of available Amazon Seller Central reports, select "Financial transactions" for a specific date range. This can be as recent as the "Last 24 hours" or a custom range going as far back as 5 months. For this example, we'll select "Include records for the last 30 days".

Step 4.

Select columns that you need: Settlement ID, Transaction Type, Amount, ASIN, SKU, and other fields.

Step 5.

Set your schedule. Choose how often you want to export and refresh your Amazon settlement data—every hour, every day, or less frequent.

Step 6.

Save your data pipeline. This will export your financial transactions from Seller Central into spreadsheets instead of dealing with CSVs. The settlements data in your spreadsheets will be up to data forever.

What is the Amazon Settlements Report?

Financial transactions shows you the truth. This is the general ledger for your entire Amazon business—a line-item log of every dollar in and every cent out. Think of this as your Amazon bank statement. It's the single source of truth for every financial event tied to your account. This includes:

• Sales: Order transactions.

• Refunds: Refund transactions.

• Amazon Fees: FBA Fees (like fulfillment, storage, removal), Subscription Fees, Selling Fees.

• Ad Costs: Advertising fee transactions.

• Shipping: Shipping charges and credits.

• Reimbursements: FBA Inventory Reimbursement and other adjustments.

• Payouts: Disbursement transactions (the actual money sent to your bank).

This is the only report that lets you tie all your costs directly to your sales to find your true, net profit.

This makes it the single source of truth for answering questions like:

• How many units did we sell of x family of SKUs last month vs. last month last year? 

• How have our FBA fees evolved over time for this given SKU or group of SKUs? 

• Are we being charged the right referral fee (for categories with different referral fees)? 

• How many units are being returned per unit sold for a given set of products? 

• How much did we pay in FBA fees, commissions, storage, refund admin this period vs last? 

• What exact transactions make up my latest deposit and why is it different from sales? 

• Are refunds/chargebacks increasing and which SKUs/orders drive them? 

• What’s our accrued revenue/fees mid-cycle (before the settlement closes)?

  
  

How to Analyze & Track Your Amazon Settlements in Spreadsheets

Now that you have a live feed, you can move from data entry to data analysis. This is the real power of analyzing your Amazon Seller Central data in spreadsheets and building your Amazon excel-like template.

Here are 4 Amazon spreadsheet template ideas you can build immediately:

Template 1: The "True P&L" Dashboard

This is the ultimate Amazon inventory management spreadsheet template (for finance)

How to build it: On a new "Dashboard" tab, use SUMIF formulas pointing to your raw data sheet.

• Cell A1 (Revenue): =SUMIF(Data!E:E, "Order", Data!F:F) (Assuming E is Transaction Type, F is Amount)

• Cell A2 (FBA Fees): =SUMIF(Data!E:E, "FBA Fee", Data!F:F)

• Cell A3 (Ad Fees): =SUMIF(Data!E:E, "Ad Fee", Data!F:F)

• Cell A4 (Net Profit): =A1 + A2 + A3 (Fees will be negative, so adding them is correct)

• What it shows you: A simple, live-updating view of your actual net profit.

Template 2: The "Fee Analyzer" Pivot Table

Find out where your money is really going.

How to build it: Create a Pivot Table from your raw data.

• Rows: Transaction Type (or Fee Type).

• Values: SUM of Amount.

• What it shows you: An itemized breakdown of every single fee. You'll be able to see if "FBA Fulfillment Fees" make up 20% of your revenue or if "Storage Fees" doubled last month.

Template 3: The "Settlement Reconciliation" spreadsheet template

This is how you reconcile your Amazon settlement report.

How to build it: Use a simple "Filter" on your raw data.

• Action: Find the Disbursement (payout) transaction for your latest settlement. Copy its Settlement ID.

• Filter: Filter the Settlement ID column for that specific ID. Select all transactions except the Disbursement line itself.

• What it shows you: The sum of all selected transactions (sales, fees, refunds, etc.) in the bottom-right corner of Google Sheets should exactly match the Disbursement amount (but as a positive number). You are now 100% reconciled.

Teamplate 4: Refund & Chargeback Ledger template

See your losses on unsuccessful purchases.

• How to build: Filter event types (refund/chargeback/SAFE-T) → join to orders/SKUs → compute refund rate and net impact.

• Shows: Which ASINs drive losses; input for CX fixes.

Common workflows this report unlocks

• Daily accruals: post revenue/fees mid-cycle using Finances API events—no need to wait for the payout.

• Payout tie-out: reconcile settlement total → deposit and verify every component (principal, tax, fees, promos).

• Fee audit: track commission, FBA, storage, refund-admin and spot variances period-over-period.

• Refunds & chargebacks: monitor spikes; map events to orders/SKUs and quantify net impact.

• Reimbursements & SAFE-T: surface credits/adjustments that should offset losses or damages.

• Marketplace & FX split: roll up P&L by marketplace/currency, translate to base currency for books.

• Negative settlement watch: catch deficit statements, reserves, or missing deposits before cash hits.

• Tax prep (VAT/GST): separate principal vs tax lines to feed filings and returns.

• SKU/ASIN margin: compute principal – promos – fees – taxes at item level (from events) for true margin.

• Cash forecasting: project the next disbursement from intra-period events + known reserves.

• Dispute pack builder: export fee/refund lines with order refs and dates for fast case filing.

• Month-end close: generate a journal template (revenue, fees, tax, clearing) from settlement rows.

FAQ about Amazon financial transactions (settlements)

Q: How do I download the Amazon Settlement Report (Flat File V2)?
You can automatically pull in this report data using Hopted (see the guide above). This will eliminate the manual process of opening Payments/All Statements, choosing a settlement period, and downloading the Flat File V2 settlement report. 

Q: What’s the difference between the Settlement Report and the Finances API?
The Settlement Report is a statement-period file used to reconcile a deposit; the Finances API streams financial events during the period for accruals and analytics. 

Q: Which report type value should I request for V2?
Use GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2 (Reports API). 

Q: What do amount-type, amount-description, and amount mean in V2?
They classify each money component (e.g., principal, tax, FBA fee, promo) and its value—V2 condenses many legacy columns into these three. 

Q: How often does Amazon generate settlement reports / pay out?
In general ~every two weeks for most sellers, with variations (reserves, account status, region). Funds can take a few business days to reach your bank after initiation. 

Q: How long are settlement reports retained?
If not otherwise specified, generated reports are retained ~90-150 days—download and archive. 

Q: Do events ever lag or restate?
Yes—orders can take up to ~48h to appear as financial events; settlements can include adjustments from prior periods. Track changes with snapshots.

Q: How do I reconcile Amazon settlement reports?
Pull your Amazon financial data into a single spreadsheet template. Each transaction has a Settlement ID. To reconcile, filter your sheet for a specific Settlement ID. The sum of all sales, fees, refunds, and adjustments should equal the final Disbursement(payout) amount associated with that same ID.

Q: How can I track all my Amazon FBA fees in one place?
Automate your Financial Transactions report into Google Sheets. Once all the data is in one place, create a Pivot Table. Set the "Rows" to Transaction Type (or Fee Type) and the "Values" to SUM of Amount. This will give you a perfect, itemized list of every fee you are paying.

Q: How is Hopted different from other Amazon seller software?
Most Amazon tools force you into their rigid dashboards and pre-built reports. You have to change your workflow to fit their software. With Hopted is the opposite. It’s a flexible data automation layer that works directly inside your existing spreadsheets (like Google Sheets). Instead of forcing you to learn a new system, Hopted brings all your scattered Amazon data (sales, inventory, orders, etc.) right to you. You can build the fully custom reports and automations you need, not the ones a rigid tool dictates.