Etsy 1099-K Annual Total 2026: How to Check It With a Sales CSV?

A 1099-K total, a sales report total, and the money that reaches a bank account can represent different reporting views. Comparing them as though they were identical can make a correct report look wrong—or hide a genuine export or calculation error.

Keep the question narrow: does the applicable annual 1099-K total correspond to the Gross column in the matching Etsy Payments Sales CSV for the same reporting year? Etsy’s guidance describes checking the form against that sales data, not against a bank statement or an unrelated order export. See Etsy’s explanation of how it calculates a 1099-K total.

These are the common causes to investigate before escalating:

• Different reporting bases: Bank deposits show funds transferred, while a platform sales report and a tax form may use different fields and calculations. Payment-account activity can include items that affect the amount available for deposit. Check Etsy’s Payment account field explanations before using a payout as a proxy for sales.
• The wrong CSV: An order export is useful for reviewing order details. It is not automatically the right source for checking the 1099-K amount. Etsy separates sold-transaction spreadsheet downloads from its explanation of revenue fields in Shop Stats.
• A mismatched period or shop scope: The form year, export period, and shop data included in a workbook must refer to the same scope. Combining files without recording their date ranges can leave a gap or include the same records twice.
• An import or formatting issue: A CSV can open with the wrong delimiter, columns can shift, or a value can be interpreted as text. Editing before checking the import can make it harder to tell whether the problem came from the source file or the spreadsheet.

Use the Etsy Payments Sales CSV for the matching year and check its Gross column. Use the Etsy Orders CSV when you need to review order-level details, not as a replacement for the sales CSV in this reconciliation.

Etsy’s 1099-K guidance identifies the relevant sales data for checking the form total. The practical implication is simple: confirm the export type before you add anything. A file labelled “orders” may contain useful amounts, but that does not make its Order Total the figure to compare directly with the form.

Why the Etsy Orders CSV Order Total can differ

An Orders CSV and a Payments Sales CSV organize information for different purposes. One helps you inspect orders; the other provides the sales data Etsy points to for this form check. The names may sound interchangeable when you are trying to complete a quick year-end review, but they are not interchangeable evidence.

Etsy also describes revenue in Shop Stats separately from its 1099-K calculation. That distinction is a reason to avoid substituting a number from a dashboard or order export simply because it appears to describe sales. For the form comparison, start with Etsy’s 1099-K form guidance and follow the relevant sales CSV instructions.

If you already summed Order Total, keep that workbook as an order review if it is useful. Do not silently relabel the result as the 1099-K reconciliation. Export the correct sales file, then record which source and field you used.

Open the Etsy account area that provides payment or sales records and locate the spreadsheet download for sold transactions. Etsy’s CSV download instructions explain the platform’s download process. Interface wording can change, so verify the current instructions if a menu name differs.

Before downloading, note the year shown on the form you are checking. Select the corresponding period in the export controls, and make sure the shop and date range match the records you intend to reconcile. If the platform offers monthly exports rather than one annual file, save each original separately and record the period covered by each file.

Use a clear filename that preserves the source and scope, such as etsy-sales-[year]-[period].csv. Replace the bracketed parts with the actual year and selected period. Do not overwrite the original export after opening it in a spreadsheet; use a working copy for calculations.

Open the downloaded file and locate the column labelled Gross. Check the header row before selecting data. Do not assume that a column in the same relative position will always have the same meaning if the export layout has changed.

The working question is whether the total of the Gross values in the relevant file or files matches the amount Etsy identifies for the applicable 1099-K. Etsy explains the relationship between its form amount and sales data in its calculation guidance. Keep the source CSV and a separate calculation sheet so another person can trace the result back to the export.

If you export multiple periods, first confirm that the periods collectively cover the intended year without overlap. Add only the relevant Gross values from each verified file. Do not combine an annual export with monthly exports covering some of the same records.

If Numbers displays a preview when you open a text file, use it to inspect the column structure before proceeding. Apple’s Numbers guide to importing text files covers the import controls. Check the delimiter and text handling in the preview, then confirm that the headers and values appear in separate, correctly labelled columns.

Do not start calculating if a row of data appears under the wrong heading or several fields appear joined in one column. Adjust the import settings first, then review the preview again. Preserve the untouched source file so you can compare it with the imported worksheet if the result looks unusual.

Next, inspect the Gross column’s displayed values. If amounts appear left-aligned as text, show unexpected symbols, or look inconsistent with the original file, check the import and cell format before using a total. Apple’s Numbers guide to currency and number formats explains how number presentation is controlled. Formatting can affect how a value appears, so verify the underlying imported entries rather than relying only on a visual total.

For a reviewable workbook, keep the original data on one sheet and create a separate calculation sheet with the source filename, date range, selected field, and total. Avoid editing imported source values to make them appear to match the form.

Once the correct column and period are confirmed, calculate the Gross total for the file or verified set of files. Record the calculation method in plain language—for example, “sum of Gross values from the Etsy Payments Sales CSV for the selected reporting year.” If more than one export was used, list each filename and period separately.

This record helps distinguish a calculation problem from a source-selection problem. It also gives a finance collaborator enough context to repeat the check without guessing which CSV, year, or field was used.

If currency conversion is relevant to the records being reviewed, do not assume that a displayed amount in another currency should equal a bank deposit. Etsy explains its currency conversion fees. Keep the exported values and the platform’s stated calculation basis intact, and ask Etsy or a tax professional if the form comparison remains unclear.

A bank statement answers what was deposited into the account. It does not, on its own, identify the Gross values in the platform’s sales export or explain how Etsy arrived at the form amount. Payment-account activity, fees, adjustments, and transfer timing can all make a deposit comparison answer a different question from the 1099-K check. Use Etsy’s Payment account guide to understand the records you are comparing.

That does not mean every mismatch is harmless or that a form is necessarily correct. It means the deposit total is not enough evidence to decide either way. Compare like with like first: the applicable form, matching sales CSV, correct period, and Gross field. Keep bank records as supporting evidence for payout reconciliation, not as a replacement for the platform’s identified sales data.

If the CSV import looks wrong, stop before editing values or forcing a total to match. Recheck the import preview and preserve the original file so the source remains available for review.

• [ ] The form year and the selected CSV period refer to the same reporting year.
• [ ] The file is an Etsy Payments Sales CSV, not an Etsy Orders CSV.
• [ ] The calculation uses the Gross column identified in Etsy’s guidance.
• [ ] Each included export has a recorded filename and date range.
• [ ] Combined files do not omit a period or repeat the same period.
• [ ] Numbers shows the expected headers and values in separate columns.
• [ ] The Gross values are interpreted as numbers, not merely displayed as text.
• [ ] The original CSV remains unchanged beside the calculation workbook.
• [ ] The workbook records the source, scope, field, and summing method.
• [ ] The bank deposit total has not been used as a substitute for the sales CSV total.

If the selected year, export type, date range, and Gross calculation all check out but the form still does not match, pause before changing the workbook or deciding that the form is wrong. Save the original sales CSV, the 1099-K, the Numbers file, and a brief note describing the period and field used.

Then ask Etsy to clarify the platform records or the calculation relevant to the form. If the remaining question concerns tax treatment, filing duties, or what the form means for a particular business, take the records to a qualified tax professional. The IRS also provides general guidance on what to do with Form 1099-K; it does not turn a spreadsheet comparison into a personalized tax determination.

Keep the escalation focused. Include the exact source file, the Gross calculation, the form year, and the unresolved difference. Do not send unnecessary customer or account data, and remove personal or order details from any screenshot used for internal documentation.

A one-person shop that reviews exports occasionally may be better served by a local Mac, or by keeping the task within its existing bookkeeping workflow. A team that needs several people to use the same macOS spreadsheet environment may find that a shared, managed Mac makes file handling and handoffs easier—but access controls and secure handling still need to be set by the business.

The current approach can become awkward when staff have different spreadsheet environments, when working copies are scattered across devices, or when a handoff does not preserve the original export and calculation notes. Those are document-control problems, not reasons to change Etsy’s reporting basis. Renting a Mac from NUKCLOUD can provide a macOS environment for CSV review without buying another Mac, but it does not validate a 1099-K or replace tax advice. Sellers who want to compare available options can review NUKCLOUD’s US Mac locations and its Mac service overview.

For a temporary reconciliation or a team review that specifically needs Numbers on macOS, a remote Mac can be a more convenient workspace than passing files among incompatible setups. For continuous, long-term work, a purchased Mac may be more suitable; if the workflow does not require macOS, an existing local computer may be enough. In every case, retain the original Etsy export, document the Gross calculation, and let Etsy or a tax professional resolve questions about the form itself.