How-To Guides

How to Track Marketplace Payouts: Import Etsy Statements and Match Deposits

Etsy wires you $494.29. That number is not your revenue — it is your sales minus commission, ads, shipping labels and refunds. Import the monthly statement, and Synceipt matches every payout to its bank deposit and shows the gross sales and fees your tax return needs.

· Updated 12 min read
Laptop showing Synceipt's Payouts tab with a $494.29 marketplace payout broken into $610.00 gross sales minus platform fees, advertising and shipping labels, matched to a business checking deposit, beside a printed monthly marketplace statement
A marketplace payout in Synceipt: the gross sales and every fee behind the deposit, matched to the bank transaction it landed as.

If you sell on a marketplace, you are not paid per sale. The platform collects your orders, subtracts its commission, your ad spend, the shipping labels you bought, any refunds you issued and sometimes sales tax it remits for you — and then sends one net amount to your bank on its own schedule.

That single number is the one your bank feed shows. It is also the number many bookkeeping tools quietly file as your revenue, and doing so is wrong twice over: it understates what you actually sold, and it hides every fee you could have deducted.

A $494.29 Etsy deposit might be $610 of sales, less $58 in commission, $34 in ads and $24 in shipping labels. Recorded as $494.29 of revenue, sales are understated by $116 and $116 of deductible expense is missing. Your profit comes out the same — but the 1099-K Etsy sends the IRS reports the gross, and your records should be able to explain it.

Where payouts live

On the web, choose Revenue in the left sidebar and switch to the Payouts tab. In the mobile app, choose More → Revenue and switch to Payouts — the Import button is at the top. The Revenue section keeps both kinds of incoming money side by side:

  • Invoices — what you have billed customers and they have not yet paid. Money you are owed.
  • Payouts — what a marketplace has already sent, or told you it is sending. Not owed to you, just not arrived yet.

The two totals are shown separately and never added together. Outstanding invoices are a receivable; a payout in transit is not, and one combined figure would misstate both.

The fast way: import your Etsy statement

Etsy's monthly statement is the most complete record of what happened to your money: every sale, fee, refund, ad charge and deposit, line by line. Synceipt reads that file directly. Etsy is the first marketplace the importer supports; for other platforms, see Recording a payout by hand below.

  1. 1

    Add your shop once

    Choose Import statement, then Add a shop (or Manage, once you have one). Pick the marketplace and type the shop's name. If you run more than one Etsy shop, add each one — and mark the one you import most often as the default, so it is pre-selected.

  2. 2

    Generate the CSV in Etsy

    In Etsy, go to Shop Manager → Finances → Monthly statements, pick a month and choose Generate CSV. Save the file somewhere you can find it.

  3. 3

    Choose the shop, then the file

    In the import window, answer Which shop? first, then drag the CSV in or click to choose it. Statements are CSV only, up to 20 MB each.

  4. 4

    Check the three totals

    Synceipt shows Activity in this statement, Paid out to your bank, and Still held by Etsy at period end. Choose Import another to add the next month.

Why Synceipt asks which shop before reading the file

Nothing inside an Etsy statement says which shop it belongs to. Two shops export files for the same month, in the same currency, with identical columns. Synceipt files each statement under the shop you pick, so one shop's September can never overwrite another's, and two shops paid the same amount on the same day are never mistaken for one payout.

"Still held by Etsy" is not an error

Etsy pays out on a schedule, so some of a month's sales are usually still sitting in your Etsy account on the last day of the month. That leftover — accountants call it a clearing balance — is what Still held by Etsy at period end shows. It is expected, and it moves into next month's deposits.

Re-importing is safe

Uploading a month you have already imported for the same shop replaces it rather than adding a second copy, and the import window lists the months already on file for the shop you picked. That is also how you correct an import: fix or re-download the file and upload it again. A row Synceipt cannot read — a malformed line, or a file with no currency — is refused with a message that says which row, rather than imported as a zero.

Matching each payout to its deposit

Each deposit in the statement becomes its own payout record, marked In transit until a bank credit is linked to it. When a matching credit arrives in your bank feed, Synceipt suggests it and you confirm. If it suggests nothing — or the wrong one — open the payout and choose Find the deposit to pick from the ranked candidates yourself. Unlink is always there if you change your mind.

  • In transit — the platform says the money is coming; no deposit is linked yet. If the expected arrival date passes, the payout is flagged as not seen yet.
  • Deposited — a bank credit is linked, and the money is in your account.

Three rules keep matches honest:

  • The deposit cannot come before the payout. The search window runs forward from the payout date only.
  • The currencies must be the same. Synceipt does not convert, so a EUR payout will not match a USD deposit.
  • Several payouts may share one deposit; one payout may not span two. Their total simply cannot exceed the credit.

Once linked, the deposit and the payout point at each other, so "what is this deposit?" has an answer from either side.

The tax-ready summary: your gross sales and fees

This is the part your tax return needs. The Tax-ready summary on the Payouts page turns your imported statements into one set of figures per shop and currency:

LineWhat it is
Gross receiptsYour sales before anything was taken out — the basis Etsy's 1099-K reports
Less refundsMoney you returned to buyers
Less sales tax collectedTax Etsy collected from buyers and remitted for you. It passes through; it was never your income
Net revenueWhat your sales were really worth to you
Platform fees, Payment processing, Shipping labels, AdvertisingYour marketplace costs, each on its own line
Total deductionsThose costs added up
AdjustmentsAnything Etsy recorded that is none of the above, kept with its sign
Net profitNet revenue less deductions, plus adjustments
Still held by the platformThe clearing balance at the end of the period
What the tax-ready summary shows for each shop

These figures come from your imported statements, not your bank transactions — and Synceipt does not post them into your reports. Your reports, and the Schedule C worksheet in Tax summary, still count the Etsy deposits at their net amount. Both are true views of the same money: net profit agrees either way. Give your tax professional the summary's gross receipts and deductions; that is what your return is prepared from.

If a month is missing in the middle of the period you are looking at, the summary says so instead of quietly reporting a smaller year. Import the missing statement and the warning goes away.

The Payouts page also shows sales, fees and deposits per marketplace for the year, with a line saying which figures come from imported statements and how many payouts are not covered by either a statement or a breakdown you entered.

Why imported payouts have no breakdown

An Etsy statement does not say which sales and fees went into which deposit — and Synceipt will not guess by spreading the month's fees across the deposits. So an imported payout carries only its deposit amount, and the month's full detail lives in the tax-ready summary instead. Nothing is lost; it is simply kept where it can be stated exactly.

Recording a payout by hand (Amazon, eBay and others)

For a platform the importer does not read yet, choose Add payout and enter the platform, the shop, the payout date, the expected arrival date and the net amount. Etsy, Amazon, eBay, Walmart Marketplace, Apple, Google Play, Shopify, Stripe and PayPal are offered by name, and any other platform can be typed in. The payout then matches its deposit exactly as an imported one does.

To record the gross sales and fees behind a hand-entered payout, open it, choose Add breakdown and enter the lines from your platform statement:

Adds to the depositSubtracts from it
Gross salesPlatform fees
Shipping collectedProcessing fees
Reserve releasedAdvertising
Shipping labels
Tax withheld
Refunds
Reserve held
Breakdown line types, and which direction each moves the deposit

Adjustment is the one line that may go either way. The direction is fixed for every other type, so you enter amounts and Synceipt handles the signs. If your lines do not add up to the deposit, Synceipt shows both figures and the difference instead of adjusting one to match — a mismatch usually means a line is missing.

Then choose Record revenue & fees. Synceipt writes the lines onto the linked bank deposit as splits, so your reports count the gross sales as revenue and each fee as an expense. If you had already split that deposit by hand, Synceipt asks before replacing your work.

Synceipt never estimates your fees. It knows a typical commission rate for each platform and uses it only to help find a fee-reduced deposit — a matching hint is not an accounting figure. A payout with no breakdown says plainly that only the deposit amount is known.

When a payout record is wrong

Choose Not a payout on any record that is not one, or that was recorded twice. It is hidden rather than deleted, any linked deposit is released, and you can restore it from the Dismissed filter. A payout you entered by hand can also be deleted. One from an imported statement can only be dismissed: re-importing that statement would bring a deleted one straight back, so the way to correct an import is to upload the corrected file.

What you need

Payouts, statement import and the tax-ready summary are part of Synceipt's business features, available on the Pro and Pro Plus plans — the same plans as invoicing. Importing a statement is read by Synceipt's own parser, not by AI, so it does not use any of your monthly AI allowance.

Selling somewhere the importer does not read yet? The shops window has a Request it link that tells us which platform you want next.

Is a marketplace payout income?

The money arriving is, but the deposit is net of fees. Recording the deposit as revenue understates your sales and hides your deductible costs. Your gross sales are the revenue; commission, ads, shipping labels and refunds are expenses. Import the statement, or add a breakdown, to keep the two apart.

Which marketplaces can I import statements from?

Etsy monthly statements (CSV) today. For Amazon, eBay, Shopify and any other platform, record payouts with Add payout and add the breakdown from that platform's statement. Use Request it in the shops window to ask for your platform.

Why does the summary say Etsy is still holding money?

Because Etsy pays out on a schedule, the end of a month usually falls between two deposits. Still held by the platform is the money from that month Etsy had not sent yet. It is expected, not a mismatch, and it arrives in a later deposit.

I sell in two Etsy shops. Will their statements get mixed up?

No. Add both shops, and pick the right one each time you import. Each statement is filed under its shop, the summary shows each shop separately, and a month imported for one shop never replaces the other's.

Why has my payout not matched a deposit that is clearly in my account?

Check the date and the currency. The match window runs forward from the payout date, so a credit dated before the payout is not considered, and the currencies must be equal. If both look right, use Find the deposit to link it yourself.

Will my reports show the gross sales from the statement?

Not from an import. Your reports and the Schedule C worksheet count the Etsy deposits at net, and the tax-ready summary on the Payouts page shows the gross figures. Net profit is the same in both. For a hand-entered payout, Record revenue & fees does put the gross sales and fees into your reports.

What is the difference between the Invoices and Payouts tabs?

An invoice is money a customer owes you because you billed them. A payout is money a platform sends you from sales it collected for you. Only invoices are a receivable, which is why the two totals are kept separate.

Stop filing net deposits as revenue

Import your Etsy statement, match every payout to its bank deposit, and give your tax professional the gross sales and fees behind them.

Ready to automate your finances?

Connect your email and bank account. Synceipt matches receipts automatically.

Get started free