Marketplace Settlements

Import, reconcile, and post settlement reports from Amazon, eBay, and Shopify.

When you sell through online marketplaces like Amazon, eBay, or Shopify, those platforms collect payment from your customers and pay you in periodic settlements — minus their fees and commissions. The Settlements page lets you import these settlement reports, reconcile them against your Helium orders, and post the accounting entries.

Banking

Overview

The page shows:

Summary cards — Total settlement count, total fees charged by marketplaces, and net settlement amounts
Fee true-up summary — A comparison of estimated fees versus actual fees (optional)
Settlement list — A filterable table of all imported settlements

Importing a settlement

Click Import Settlement

Click the Import Settlement button at the top of the page.

Select the channel

Choose which marketplace this settlement is from: Amazon, eBay, or Shopify.

Set the period

Enter the Period Start and Period End dates covered by the settlement.

Paste the CSV data

Copy the settlement data from the marketplace's report and paste it into the CSV Data field. The expected columns are:

orderNumber — The marketplace order reference
description — A description of the line item
amount — The settlement amount (positive for sales, negative for fees)
type — The line type (e.g. sale, refund, fee, adjustment)

Import

Click Import. Helium parses the data and creates a settlement record.

Settlement list

Each settlement shows:

Column	Description
Channel	Which marketplace (Amazon, eBay, or Shopify)
Period	The date range covered
Orders	Number of order lines in the settlement
Matched	How many lines have been matched to Helium orders (shown as X/Y)
Currency	The settlement currency
Gross	Total gross sales amount
Fees	Total marketplace fees deducted
Net	Net settlement amount (gross minus fees)
Status	Current status of the settlement

Filtering

Channel filter — Show settlements for a specific marketplace
Status filter — Show settlements at a specific stage

Settlement statuses

Status	Meaning
Imported	The settlement has been imported but not yet reconciled
Reconciled	All order lines have been matched to Helium orders
Partially Reconciled	Some lines matched, some unmatched
Posted	The accounting journal entries have been created
Disputed	There are discrepancies that need investigation

Reconciling a settlement

Click the Reconcile button on an imported settlement. Helium automatically attempts to match each settlement line to a corresponding Helium order using the marketplace order reference.

After reconciliation, you can expand the settlement row to see the detail:

Column	Description
Order Ref	The marketplace order reference
Settlement amount	What the marketplace paid for this order
Helium amount	What Helium recorded for this order
Difference	Any discrepancy between the two amounts
Status	Matched, unmatched, or discrepancy

At the bottom of the expanded view, summary badges show the count of matched, unmatched, and discrepancy lines.

Posting settlement journals

Once a settlement is reconciled, click the Post button to create the accounting journal entries. This records:

The marketplace sales revenue
The marketplace fees as expenses
The net settlement as a receivable (until the bank payment arrives and is reconciled)

Fee true-up

Click the Fee True-Up button at the top of the page to compare your estimated marketplace fees against the actual fees from settlement reports. This helps identify discrepancies in fee calculations and ensure your cost reporting is accurate.

The true-up shows:

Estimated Fees — What Helium calculated based on your fee rules
Actual Fees — What the marketplace actually charged
Variance — The difference, highlighting any unexpected charges

Regular imports

Import settlements as soon as they are available from your marketplace. This keeps your accounting up to date and makes bank reconciliation much easier when the settlement payment arrives.