Amazon Payout Import: Summary-Level Sales & Fees

Use the Amazon Payout Import to bring Amazon sales and fees into Versa on a summary basis, after Amazon issues a payout. This importer turns a single Amazon payout CSV into one Versa invoice with many invoice items, offsetting Amazon fees and taxes so the invoice total matches Amazon’s settlement total.

If you need detail-level, near real-time orders, shipments, and fee breakdowns per order, use the Versa Amazon integration instead.

When to use this import

• You receive a periodic Amazon payout and want to record summarized revenue, taxes, shipping, and fees in Versa.
• You don’t require per-order operational syncing (use our Amazon integration for that).

Before you begin

• Permissions: You need access to Imports & Exports in Versa and to Payments / Statements in Amazon Seller Central.
• Files: Download the payout/settlement CSV from Seller Central (steps below).
• Products: Ensure every Amazon sku exists in Versa as a Product with matching Part Number. The import aborts entirely if any SKU cannot be matched.

Export the payout CSV from Amazon Seller Central

UI labels vary slightly by region; the path below is representative.

1. Sign in to Amazon Seller Central.
2. Go to Reports → Payments (sometimes Payments appears as its own top-level menu).
3. Open All Statements (or Statements / Settlement list).
4. Find the statement (payout) you want to import. Click Download and choose the CSV/Flat File option (often labeled Flat File V2 (CSV)).
5. Save the CSV file to your computer without editing column headers or formats.

Where to find the import in Versa

1. In Versa, go to Imports & Exports.
2. Select Amazon Payout Import.

Settings used by the importer

The first time you run the import, you’ll be asked to confirm a few choices. Versa remembers them for next time.

• Amazon Customer (required): Choose which Versa Customer the invoice should use. Versa saves this choice in Settings and reuses it on future imports.
• Expense Account for Fees (required): Choose the general expense account to book Item-level fees and other non-item transactions (recommended: an account like Amazon Fees).

On the first successful import, Versa will automatically create:

• Tax: Amazon Collected Tax (used when Amazon acts as marketplace facilitator).
• Service Product: Amazon Shipping (under your default “Sold Services” product category), used when shipping charges require their own invoice line.

How the import works

One invoice per payout

• The import creates one Versa invoice for the entire CSV.
• Invoice date is set to the CSV’s settlement end date.
• Validation: The final Versa invoice total must equal the CSV’s total-amount on the first row. If they don’t match, the import fails with a clear error.

Matching products (SKU → Part Number)

• For each itemized sale line, Versa uses the CSV sku to find a matching Product by Part Number.
• If any SKU cannot be found, the import aborts and reports the first missing SKU.

Sales lines and quantities

• quantity-purchased becomes the invoice item quantity.
• Principal (amount-description) is the line total for the item. Unit price is computed as principal ÷ quantity-purchased.
• Each sold item typically has up to three amount-descriptions: Principal, Tax, and Shipping.

Handling Amazon deductions on item lines

Amazon lists various deductions that reduce the amounts you receive. Versa applies them as follows:

• MarketplaceFacilitatorTax-Principal:
  • Treated as tax collected/remitted by Amazon. It reduces the taxable amount for the item.
  • Versa deducts this from the item’s tax (amount-type: ItemPrice / tax portion). If the resulting tax is non-zero, Versa applies Amazon Collected Tax to the item for the remainder; if it nets to zero, no tax line is applied.
• FBAPerUnitFulfillmentFee, Commission, and other ItemFees:
  • These are treated as fees that reduce proceeds.
  • Item-level Shipping fees (where amount-type = ItemFees and amount-description = Shipping) are first deducted against the item’s Shipping (amount-type: ItemPrice, amount-description Shipping).
  • If a shipping deduction leaves a non-zero remainder, Versa adds a separate negative invoice item using the Amazon Shipping service.
  • All other ItemFees are posted as additional negative invoice items using your chosen Amazon Fees expense account.
• ItemWithheldTax:
  • Deducts from the item’s tax portion (the ItemPrice tax amount).
  • If the tax balance is non-zero after deduction, Versa applies the remainder as tax via Amazon Collected Tax. If it nets to zero, no tax is applied.

Other transactions (no order-item-code)

Lines at the bottom of the payout file with a blank order-item-code represent non-item transactions such as inbound transportation fees, storage fees, disposal fees, and inventory reimbursements.

• For each such line, Versa creates an additional negative invoice item for the amount, with the line description taken from amount-description.
• These post to your chosen Amazon Fees expense account.

Step-by-step: Import the payout CSV into Versa

1. Go to Imports & Exports → Amazon Payout Import.
2. Click Upload and choose your Amazon payout CSV (unmodified).
3. Select the Amazon Customer that should own the invoice (Versa remembers this selection).
4. Select the Expense Account to use for item fees and other non-item transactions (e.g., Amazon Fees).
5. Click Import.
6. Review the summary. If successful, Versa creates:
   • One invoice dated the payout’s settlement end date.
   • Invoice items for each SKU sold (principal, tax, shipping) with applicable fee offsets and tax logic.
   • Additional negative lines for fees and other transactions without order-item-code.

Validation & error handling

• Invoice total must match Amazon total-amount (first row): If mismatched, the import fails and no data is created. Review your CSV for edits or missing lines.
• Missing SKU: If a sku cannot be matched to a Versa Product (by Part Number), the import aborts with an error naming the first missing SKU.
• Unexpected columns or formats: Re-download the CSV from Seller Central and try again without editing.

Field mapping (reference)

FAQs

Does this replace the detailed Amazon integration?

No. This import is designed for after-the-fact, summary-level accounting tied to each payout. For per-order syncing, shipments, inventory updates, and granular analytics, use the Versa Amazon integration.

What if my payout includes SKUs not yet set up in Versa?

The import aborts to prevent partial data. Create the missing Products (with matching Part Number = Amazon sku) and re-run.

How are marketplace facilitator taxes handled?

They reduce the tax owed on the item. Versa uses a firm-level tax called Amazon Collected Tax to represent any remaining tax that Amazon has collected/remitted. If deductions net tax to zero which will generally be the case when amazon collect and remit sales taxes, no tax amount is applied.

Where do fees post?

Item-level fees (e.g., Commission, FBAPerUnitFulfillmentFee) post as negative invoice items to your selected Amazon Fees expense account. Item-level shipping deductions first offset the shipping amount; any remainder becomes a negative line using the Amazon Shipping service.

Troubleshooting

• Total mismatch: Confirm you used the correct settlement CSV and that it wasn’t edited (no deleted rows/columns). Re-download and try again.
• Missing SKU: Create the Product in Versa with Part Number equal to the Amazon sku and re-run.
• Tax looks off: Review MarketplaceFacilitatorTax-Principal and ItemWithheldTax lines in your CSV; these reduce applied tax at the item level by design.

Need help?

Attach your payout CSV and any error messages to your ticket and our team will assist. If you’d prefer automated, detail-level syncing going forward, ask us about enabling the Versa Amazon integration.