Skip to main content

How Finaloop’s Amazon Integration Works

See how Finaloop Accounting records your Amazon orders, fees, deferred funds and payouts on cash or accrual basis, so you can reconcile your books with Amazon Seller Central.

Written by Emily Burrows

About

Applies to: Finaloop Accounting, Margins

Finaloop Accounting automatically syncs your Amazon Seller Central activity and records every stage of an Amazon order, from order placed to payout, so your books stay accurate and reconciled.

In Margins: your Amazon orders, sales, fees and refunds sync into your dashboards, and you can follow every order on the Orders page. Margins doesn't keep books, so deferred transactions, accrual and cash treatment, reconciliation and P&L line items apply to Finaloop Accounting only.

What syncs includes orders, sales, fees, refunds, inventory activity, deferred transactions (funds Amazon is holding before releasing them to you), payouts and undeposited funds balances (money Amazon has collected for you that hasn't reached your bank yet).

Amazon orders often go through multiple stages before funds are paid out, including fulfillment, deferred payment holds, payment releases, and payouts. Finaloop tracks each stage separately so your books stay accurate and fully reconciled.

Starting January 1, 2026 (or from your books start date, if you joined Finaloop later), Finaloop's Amazon integration supports Amazon's deferred transaction timing (Amazon's Delivery Date Reserve policy, known as DD+7) for accrual-based accounting. If you joined Finaloop before 2026, you may notice adjustments in monthly Amazon revenue compared to before the update.

Your data is secure. Finaloop connects through each app's official integration and protects your data with bank-level encryption. It only uses the connection to sync the data your books and reports need.


1. What Finaloop syncs from Amazon

Finaloop syncs operational and financial data directly from Amazon's Selling Partner API.

This includes:

  • Orders

  • Fulfillment activity

  • Sales

  • Fees

  • Refunds

  • Reimbursements

  • Cost of goods sold (COGS)

  • Ad payments made through your seller account

  • Deferred and released transactions

  • Payouts

  • Inventory movements

Finaloop combines Amazon operational activity with Amazon financial data to provide a complete accounting and reconciliation workflow.

This allows you to:

  • Track Amazon orders, payouts, and COGS as they sync

  • Reconcile Amazon balances against your books

  • Understand deferred and released balances

  • View detailed fee and reimbursement activity

  • Track inventory and fulfillment movements

  • Drill into individual orders and transactions


2. Amazon order timeline

Amazon orders go through several operational and financial stages before funds are transferred to your bank account.

Here's the typical lifecycle:

Stage

What happens

1. Order placed

Customer places an order

2. Payment deferred

Amazon processes payment but temporarily holds the funds under its Delivery Date Reserve policy (DD+7)

3. Order fulfilled

Seller ships the order

4. Payment released

Amazon releases the funds to your available Amazon balance

5. Payout

Amazon disburses funds to your bank account

Two things to keep in mind:

  • Customers may pay when placing the order, but Amazon may still defer the funds before releasing them.

  • "Payment released" means the funds are released to your Amazon balance, not yet transferred to your bank account.


3. Deferred transactions in Finaloop

A deferred transaction is a transaction where Amazon temporarily holds the funds before releasing them to you.

This can happen under:

  1. Amazon's Delivery Date Reserve policy (DD+7). Under Amazon's Delivery date reserve policy, funds are reserved for a set period after the shipment is delivered. Typically, this reserve period is 7 days after delivery (DD+7). For example, payment for an order delivered on January 6 will become available for payout on January 14.

  2. Invoiced orders, which are transactions awaiting payment by the buyer. Amazon waits for the customer to pay their invoice before releasing the funds.

Amazon calls these deferred transactions.

Finaloop separately tracks:

  • Deferred balances

  • Released balances

  • Payout activity

  • Bank reconciliation activity

This gives you clear visibility into:

  • Amazon reserve balances (funds on hold)

  • Released transactions

  • Payout timing

  • Reconciliation workflows

Starting January 1, 2026 (or from your books start date, if you joined Finaloop later), Finaloop supports Amazon deferred transaction timing for accrual-based accounting, so revenue is recognized based on fulfillment timing instead of payment release timing.

If you used Finaloop's earlier Amazon integration, deferred transactions weren't reflected in your books, because Amazon's older API structure mainly reported released transactions. As a result, you may notice timing differences in monthly Amazon revenue beginning in the month Amazon moved your account to its Delivery Date Reserve policy, or in January 2026 if that happened before 2026.

To see how Amazon deferred transactions worked before, why some timing differences may appear in your books, and what changed in the updated integration, read Amazon deferred transactions: what changed for your books.


4. How Amazon activity impacts your books

The way Amazon orders flow into your books depends on whether your books are set to cash basis or accrual basis accounting. To check which one you use, see Does Finaloop use accrual or cash basis accounting?

Accrual basis accounting

For accrual-based users:

  • When the order is placed, Finaloop records Deferred revenue and Accounts receivable, with no impact on your P&L

  • Revenue and COGS are recognized when the order is fulfilled

  • Deferred balances are tracked separately as Undeposited funds on hold until Amazon releases the funds

  • Released balances are tracked separately as Undeposited funds until Amazon disburses the funds

This improves:

  • Revenue timing

  • Month-end reporting

  • Year-end reporting

  • Deferred balance visibility

  • Reconciliation with Amazon's reports


Cash basis accounting

For cash basis users:

  • Revenue is recognized when Amazon releases the funds. This means revenue timing follows when funds become available rather than when the order is fulfilled.

  • Deferred transactions held by Amazon are treated as restricted cash, and therefore not recognized until released.

  • COGS is recognized based on your COGS tracking method. Learn more in How to choose your COGS tracking method in Finaloop.

Note: On cash basis, sales follow the timing of the payment release, but COGS follows the timing of fulfillment.

In short: on accrual basis, Amazon revenue lands in the month the order is fulfilled; on cash basis, it lands in the month Amazon releases the funds. Here's what happens at each stage:

Stage

Cash basis

Accrual basis

1. Order placed

Order appears on the Orders page. No impact on your P&L or Balance Sheet.

Order appears on the Orders page. Deferred revenue and Accounts receivable are recorded. No P&L impact.

2. Payment deferred

Order marked as paid on the Orders page. Treated as restricted cash, so no impact on your books until released.

Order marked as paid on the Orders page. Accounts receivable is reduced and Undeposited funds on hold are recorded. No P&L impact.

3. Order fulfilled

Order marked as fulfilled on the Orders page. COGS recognized. No impact on revenue, since Amazon hasn't released the funds yet.

Order marked as fulfilled on the Orders page. Deferred revenue is reduced and revenue is recorded. Fees and COGS recognized.

4. Payment released

Revenue, fees, and Undeposited funds are recorded.

Undeposited funds on hold are reduced and Undeposited funds are recorded instead.

5. Payout

Payout is reconciled against the bank deposit. Undeposited funds are reduced and your bank's cash balance increases.

Payout is reconciled against the bank deposit. Undeposited funds are reduced and your bank's cash balance increases.


5. Amazon orders on the Orders page

Amazon orders are included on the Orders page alongside your other marketplaces, like TikTok Shop. Go to Customers → Orders and click the Marketplaces tab. In Margins, click Orders in the sidebar, then the Marketplaces tab. If you don't also sell on Shopify, the page opens straight on your marketplace orders.

Here you can:

  • Track payment status, transaction status (Deferred or Released for Amazon), and fulfillment status

  • Search by order number

  • Filter by Source and by placed date, and use Filters to narrow by store, product, net order amount, payment, fulfillment or settlement status, and payment, release or fulfillment dates

  • Click any order to see its details and follow the order timeline from placement through payout

Screenshot of the Marketplaces tab on the Orders page, listing Amazon orders with their status tags.

① Marketplaces tab, ② Search by Order # and Filters, ③ Status column.

You can also easily track the payment and fulfillment timeline in each order. Click an order to open it: the Timeline card lists Order placed, Payment deferred, Item fulfilled and Payment released, each with its date.

Screenshot of an Amazon order's Timeline card: Order placed, Payment deferred, Item fulfilled and Payment released, with dates.

6. Amazon reconciliation in Finaloop

How Finaloop reconciles Amazon data

  • Finaloop syncs sales, discounts, refunds, fees, ad spend, and payout activity automatically from Amazon.

  • Posts transactions to the correct accounts based on ecommerce best practices.

  • Reconciles Amazon balances and payouts against your books and bank activity.

  • Validates your books against Amazon as your source of truth.

Amazon reports don't always align directly with accounting reports. The main differences are typically caused by:

  • Time zone differences: Finaloop records transactions and presents your reports in UTC, while Amazon North America generally presents reports in PST.

  • Currency conversion adjustments: Finaloop presents your books in USD. We translate every non-USD transaction to its USD value based on the spot rate at the time of the transaction.

  • Accounting differences: Depending on whether your books are set to cash or accrual basis accounting, Finaloop may apply timing adjustments so transactions are recognized according to accounting principles.

This helps keep your P&L, Balance Sheet, and Orders accurate, reconciled, and up to date.


Comparing Amazon Seller Central with Finaloop

Amazon Seller Central reports are operational reports and don't always reflect accounting-based reporting structures.

To help bridge this gap, Finaloop provides a dedicated Amazon Reconciliation Report that:

  • Compares Amazon product sales directly against product sales recorded in your books

  • Breaks down timing, currency, and accounting adjustments

  • Removes the need for manual spreadsheets

The report explains the key differences between Amazon reports and Finaloop, including:

  • Time zone differences (Amazon reports in PST while Finaloop reports in UTC)

  • Currency conversion adjustments

  • Timing differences between deferred and released transactions

  • Cash basis vs accrual basis timing differences

  • Adjustments for pending and shipped orders


The Amazon Reconciliation Report

The Amazon Reconciliation Report starts from the product sales number in your Finaloop Profit & Loss and explains the adjustments needed to reconcile it against Amazon's Sales Dashboard and Amazon's Payment Report.

This helps you fully understand how Amazon operational activity flows into your books based on your accounting method.

You can open the report from:

  • Report center → Reconciliation reports → Amazon Reconciliation Report, or

  • Your P&L, by clicking Where do these numbers come from? next to an Amazon Sales account, then Show me. The link shows for United States stores, for periods after the updated Amazon integration started.

To generate it, choose your Amazon store and date range, then click Generate. The report shows two cards, Reconciliation to Amazon Sales Dashboard and Reconciliation to Amazon Payment Report. Each card starts at Finaloop Profit & Loss, lists the Reconciliation adjustments, and ends at the Amazon figure, with a green check mark when the totals match.

Screenshot of the Amazon Reconciliation Report cards, reconciling Finaloop Profit & Loss sales to the Amazon Sales dashboard and Payment Report.

① Reconciliation adjustments, ② View breakdown.

A few things to know about the report:

  • It covers product sales only.

  • It's available for Amazon stores in the United States and Canada.

  • The latest end date you can choose is 2 days ago, so all Amazon data has fully synced, and you can look back up to 2 years.

Click the View breakdown icon next to an adjustment to open the exact orders behind it on the Orders page, in a new tab. This lets you:

  • Understand which orders are causing the difference

  • Review payment and fulfillment timing

  • Trace operational activity directly to your books


Reconciliation against the Amazon Sales Dashboard

Amazon's Sales Dashboard reports sales based on the order placement date in PST.

Depending on your accounting method, Finaloop applies adjustments to reconcile these operational metrics with your accounting records.

If your books are on accrual basis:

  • Finaloop recognizes revenue based on the fulfillment date in UTC

  • Amazon's Sales Dashboard reports sales based on the order placement date in PST

Because of these timing differences, the following adjustments may appear:

  • Timezone adjustment (PST → UTC): Sales that fall within Amazon's selected report period in PST but outside the selected period in Finaloop due to UTC reporting.

  • Pending orders: Orders placed during the selected period that aren't fulfilled yet as of the report date.

  • Orders placed during the selected period and fulfilled after it: Orders Amazon includes in the Sales Dashboard based on order placement date, but Finaloop recognizes in a later period based on fulfillment.

  • Orders placed before the selected period and fulfilled during it: Orders Amazon included in a previous operational period, but Finaloop recognizes in the current accounting period based on fulfillment.

  • Reconciliation in progress: Temporary adjustments that may appear for partially canceled or partially shipped orders, which Amazon doesn't include in its Sales Dashboard. These resolve automatically as orders are completed.

If your books are on cash basis:

  • Finaloop recognizes revenue when Amazon releases the funds

  • Amazon's Sales Dashboard reports sales based on the order placement date

The following adjustments may appear:

  • Timezone adjustment (PST → UTC): Differences caused by PST vs UTC reporting.

  • Pending orders: Orders placed during the selected period that haven't been paid yet.

  • Orders placed before the selected period but paid during it: Orders Amazon included in a previous period, but Finaloop recognizes in the current period.

  • Deferred transactions: Orders paid by the customer where Amazon hadn't released the funds yet.

  • Reconciliation in progress: Temporary differences from partially canceled or partially shipped orders. These resolve automatically as orders are completed.


Reconciliation against the Amazon Payment Report

Amazon's Payment Report reflects Amazon deferred transaction timing in PST.

To find the Payment Report, in Amazon Seller Central go to Reports → Payment Reports and select the same date range you used in the Amazon Reconciliation Report. Add up Product Sales (non-FBA) and FBA Product Sales: that total is the Amazon figure the Reconciliation to Amazon Payment Report card ends at. To see the same steps in Finaloop, click the View data source icon (an eye) on that card.

If your books are on accrual basis:

  • Finaloop recognizes revenue based on fulfillment timing

  • Amazon's Payment Report reflects Amazon deferred transaction timing, which is generally aligned with Amazon fulfillment timing

Because of this, reconciliation against the Payment Report for accrual basis users typically only includes:

  • Timezone adjustment (PST → UTC): Differences caused by PST vs UTC reporting.

If your books are on cash basis:

  • Finaloop recognizes revenue when Amazon releases the funds

  • Amazon's Payment Report reflects Amazon deferred transaction timing

The following adjustments may appear:

  • Timezone adjustment (PST → UTC): Differences caused by PST vs UTC reporting.

  • Deferred transactions: Orders where Amazon hadn't released the funds yet during the selected period.


7. Amazon line items in Finaloop

Finaloop breaks down Amazon activity into detailed transaction categories so you can clearly understand where your Amazon revenue and costs are coming from. For example, Amazon's product sales go to Sales, shipping credits to Shipping income, selling fees to Selling fees, and advertising costs to Paid online ads.

The table lists the most common mappings, not every Amazon transaction type. Because Finaloop records some Amazon lines in more specific accounts, and applies timing, time zone and currency adjustments, the amount on an individual line can differ from the same line in your Amazon reports. Your net Amazon activity in the P&L still reconciles with Amazon.

Amazon summary report lines

Finaloop account names

Product sales (non-FBA), FBA product sales

Sales

Shipping credits

Shipping income

Gift wrap credits

Gift wrap

Promotional rebates

Discounts & promotions

Product sale refunds (non-FBA), FBA product sale refunds, Shipping credit refunds, Gift wrap credit refunds, Promotional rebate refunds, A-to-Z Guarantee claims, Chargebacks, SAFE-T reimbursement

Refunds & returns

Amazon Shipping Reimbursement Adjustments

Fulfillment services reimbursement

FBA liquidation proceeds, FBA Liquidations proceeds adjustments

Inventory liquidation proceeds

FBA selling fees, Selling fee refunds, Other transaction fees, Other transaction fee refunds, Seller fulfilled selling fees

Selling fees

FBA inventory and inbound services fees

Treated as incidental COGS by default, but can be treated as Inventory, depending on your inventory settings

FBA inventory credit

Fulfillment services reimbursement, Inventory reimbursement

FBA transaction fees, FBA transaction fee refunds

Fulfillment services fees, Pick & pack fees, External stores fulfillment fees

Shipping label purchases, Carrier shipping label adjustments, Amazon Shipping Charge Adjustments

Shipping out to customers

Shipping label refunds

Return shipping cost

Refund administration fees, Liquidations fees, Receivables Deductions

Service fees

Cost of Advertising, Refund for Advertiser

Paid online ads

Service fees

Service fees, Warehouse fees, Inventory disposal fees, Fixed marketing fees, Other promotions

Adjustments

Service fees, Cashback & rewards

Each transaction in your account can be traced back to its related order, so you can easily understand where everything came from.

Ledger activity is also separated by country and store.


8. Amazon inventory

Finaloop syncs Amazon inventory activity directly from Amazon Seller Central.

This includes support for:

  • FBA inventory and restocks

  • Fulfillment activity

  • Shipping-in costs

  • Inventory adjustments

  • Reimbursements

  • Lost inventory

  • Damaged inventory

  • Disposal activity

  • Reserved inventory balances

Inventory movements are tracked operationally and reflected in your books based on your accounting settings and inventory configuration.


9. What changed for Finaloop users who joined before January 2026

If you used Finaloop's earlier Amazon integration and use accrual accounting, you may notice some timing differences starting in January 2026.

Previously:

  • Amazon revenue was mainly recognized when transactions were released by Amazon

Now:

  • Accrual-based users recognize revenue based on fulfillment timing

This better reflects when the sale actually occurred and improves alignment with accrual accounting principles.

The updated integration also introduces:

  • Full order-level visibility

  • Deferred transaction support

  • Better payout and reserve tracking

  • More detailed Amazon fee breakdowns

  • Improved multi-marketplace support

  • Unified marketplace order tracking on the Orders page

As part of this transition:

  • Historical periods before January 1, 2026 remain unchanged

  • Deferred balances are automatically handled by the Finaloop team

  • Some monthly Amazon revenue may shift between periods due to the updated timing logic

How the January 2026 migration works

Previously, transactions that were deferred in December 2025 and released in January 2026 were recorded as sales in January 2026, when they were released.

Now, these deferred sales from December 2025 are reclassified as a Prior year adjustment in your January 2026 books, and your Accounts receivable, Deferred revenue, and Undeposited funds accounts are automatically updated and reconciled.

From February 2026 onward, sales include the current month's sales (including deferred transactions) and don't include released transactions that were deferred from the previous month. This way, the timing of all transactions matches the timing of order fulfillment.

For example:

  • December 2025: $10K was deferred and released in January 2026.

  • January 2026: $90K of sales were generated and released the same month, and $5K was deferred to February 2026. In total, $100K was released in January ($90K of January 2026 sales + $10K released from December 2025).

Old Amazon integration

New Amazon integration

January 2026 sales: $100K (only released transactions). The deferred $5K would have been recorded in February, when released.

Prior year adjustment: $10K. January sales: $95K ($90K of January 2026 sales generated and released + $5K deferred to February 2026).

This keeps the timing of your transactions fully in line with fulfillment, per accrual basis rules.


FAQs

What are deferred transactions?

Deferred transactions are transactions where Amazon temporarily holds funds before releasing them to your available seller balance. To learn more, read Amazon deferred transactions: what changed for your books.


What is the Prior year adjustment in my January 2026 P&L?

The Prior year adjustment in your January 2026 books relates to Amazon deferred transactions from December 2025 that Amazon released in January 2026.

With Amazon's previous API structure, sales were generally recorded when Amazon released the funds. As a result, some December 2025 sales would previously have appeared as January 2026 revenue.

With Amazon's updated deferred transaction reporting, accrual-based Amazon sales are now recognized based on fulfillment timing instead. Since your 2025 books are already locked, these deferred December 2025 transactions are reclassified as a Prior year adjustment rather than recorded as January 2026 sales.

This ensures:

  • Your historical books remain unchanged

  • Revenue timing aligns more closely with accrual accounting principles

  • Deferred transactions move cleanly into the updated integration

From February 2026 onward, this normalizes automatically, and Amazon revenue is recognized in the period the order was fulfilled rather than when Amazon releases the related funds.


How are Amazon fees recorded?

Amazon fees are broken down into detailed categories, including:

  • Selling fees

  • FBA fees

  • Multichannel fulfillment fees

  • Shipping-in

  • Pick & pack fees

  • Warehouse fees

  • Disposal costs

  • Service fees

  • Ad spend

  • Other promotions


Does Finaloop support multiple Amazon marketplaces?

Yes. Finaloop supports multiple Amazon marketplaces and separates reporting by marketplace, country, and store.


How often does Amazon data sync?

Amazon orders sync every 5 minutes and transactions sync every few hours automatically, giving you the most up-to-date data available.


Does Finaloop support Amazon inventory tracking?

Yes. Finaloop supports Amazon inventory activity, including FBA inventory movements and related operational adjustments.


Related articles


Need help?

As always, if you have any questions at all, feel free to contact us at [email protected].

Did this answer your question?