Back to Details

amz-1099k-reconciliation

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

1099-K Reconciliation

1099-K对账

Amazon's 1099-K reports gross sales, including refunds and before fees. Most sellers look at their bank deposits, see a much smaller number, and either overpay tax or underreport. This skill reconciles the two and produces the worksheet that maps to Schedule C lines.
Amazon的1099-K表单报告总销售额，其中包含退款且未扣除各项费用。大多数卖家查看银行存款时会发现金额远低于总销售额，进而要么多缴税款，要么少报收入。本技能可对两者进行对账，并生成对应Schedule C条目的工作表。

When to use this

使用场景

  • Year-end tax prep and the 1099-K does not match the deposits.
  • Working with a CPA who needs the breakdown.
  • A first 1099-K and the seller is confused by the gross number.
  • Quarterly estimated taxes and the seller wants to know the real revenue.
  • 年终税务准备时，1099-K与存款金额不符。
  • 与CPA合作，对方需要明细数据。
  • 首次收到1099-K，卖家对总销售额数字感到困惑。
  • 季度预估税申报，卖家想了解实际营收。

The framework. The Gross-to-Net Bridge

框架：总销售额至净销售额的对账桥梁

The 1099-K shows one number: gross sales. The bank shows another: net deposits. The bridge between them is:
Gross sales (1099-K Box 1)
  minus  Refunds and returns           → Schedule C: Returns and allowances
  minus  Amazon selling fees (referral + FBA + storage) → Schedule C: Commissions/fees
  minus  Advertising spend             → Schedule C: Advertising
  minus  Other deductions (reimbursements net, removals, etc.)
  =      Net cash to bank
Each line on the bridge maps to a different Schedule C field. The gross number stays on the return. the deductions appear on their own lines.
1099-K显示一个数字：总销售额。银行显示另一个数字：净存款金额。两者之间的对账桥梁如下：
Gross sales (1099-K Box 1)
  minus  Refunds and returns           → Schedule C: Returns and allowances
  minus  Amazon selling fees (referral + FBA + storage) → Schedule C: Commissions/fees
  minus  Advertising spend             → Schedule C: Advertising
  minus  Other deductions (reimbursements net, removals, etc.)
  =      Net cash to bank
桥梁中的每一行对应Schedule C的不同字段。总销售额需在报税表中如实填报，各项扣除额则单独列示。

Step by step

操作步骤

  1. Collect inputs. The 1099-K (Box 1 total), Amazon's Payments Date Range summary for the same year, refund total, and ad spend total. If the seller exports the year-end summary report, it contains most of these.
  2. Build the bridge. Each line from gross to net, with the dollar value.
  3. Reconcile. Total bridge should match the bank deposits to within a small timing variance. Investigate any large gap.
  4. Map to Schedule C. Per-line Schedule C field name, ready to hand to a CPA.
  5. Flag the common surprises. Sales tax collected and remitted by Amazon usually passes through but is shown gross. Some categories or marketplaces have different treatments. Note them.
  6. Quarterly extension. For estimated tax planning, run the same bridge on the trailing quarter.
  7. Run the quality check, then deliver.
  1. 收集输入信息：1099-K（Box 1总额）、对应年度的Amazon付款日期范围汇总表、退款总额以及广告支出总额。如果卖家导出年终汇总报告，其中已包含大部分所需数据。
  2. 构建对账桥梁：列出从总销售额到净销售额的每一项及对应金额。
  3. 对账验证：桥梁计算出的总额应与银行存款金额基本一致，允许存在微小的时间差异。若差异较大，需进行调查。
  4. 对应至Schedule C：为每一行标注对应的Schedule C字段名称，方便提交给CPA。
  5. 标记常见特殊情况：Amazon代收代缴的销售税通常会计入总销售额，但不属于卖家收入。部分品类或市场有不同处理方式，需予以标注。
  6. 季度扩展应用：针对预估税规划，可对过去一个季度的数据执行相同的对账流程。
  7. 进行质量检查，然后交付结果。

Output format

输出格式

undefined
undefined

1099-K Reconciliation. [year]

1099-K对账. [年份]

1099-K Box 1 gross: [$]
1099-K Box 1总销售额: [$]

Gross-to-net bridge

总销售额至净销售额对账桥梁

Refunds and returns: [-$] Schedule C line: Returns and allowances Amazon selling fees: [-$] Schedule C line: Commissions and fees Advertising: [-$] Schedule C line: Advertising Other deductions: [-$] Schedule C line: Other expenses Net to bank: [$]
Bank deposits reported: [$] Variance: [$]
退款及退货: [-$] Schedule C条目: 退货与减免额 Amazon销售费用: [-$] Schedule C条目: 佣金与费用 广告支出: [-$] Schedule C条目: 广告费用 其他扣除项: [-$] Schedule C条目: 其他费用 银行到账净额: [$]
报告的银行存款金额: [$] 差异: [$]

Notes for CPA

给CPA的备注

[sales tax pass-through, marketplace facilitator status, etc.]
undefined
[销售税代收代缴、市场服务商状态等]
undefined

Worked example

示例

1099-K Box 1: 1,200,000 USD. Bank deposits for the year: 480,000. The seller thought he made 480k. The bridge: refunds 90k, Amazon fees (referral plus FBA plus storage) 360k, advertising 180k, removal and storage adjustments 12k, leaves about 558k. Bank shows 480k. About 30k of the variance is timing (December sales paid in January). A gap of roughly 14 percent like this one warrants investigation. retained reserves, uncategorized fees, or a chargeback wave can each open a real gap behind the timing bucket. The Schedule C return reports the 1,200,000 gross and the deductions on their own lines, not a flat 480k of revenue. Under-reporting the 1,200,000 is the mistake the IRS catches.
1099-K Box 1：1,200,000美元。年度银行存款金额：480,000美元。卖家原本认为自己营收48万美元。对账桥梁显示：退款9万美元，Amazon费用（推荐费+FBA费+仓储费）36万美元，广告支出18万美元，移除及仓储调整1.2万美元，最终得出约55.8万美元。银行显示48万美元。其中约3万美元差异来自时间差异（12月销售额于1月到账）。如此约14%的差异值得深入调查，留存准备金、未分类费用或退款潮都可能是时间差异之外的真实原因。
Schedule C报税表需填报120万美元的总销售额，并单独列示各项扣除额，而非直接填报48万美元的营收。少报120万美元的总销售额是IRS会查处的错误。

Quality check

质量检查

  • Every line on the bridge is sourced from Amazon's own reports, not estimated.
  • Each line is mapped to a specific Schedule C field.
  • The reconciliation explains any variance against bank deposits.
  • Marketplace facilitator and sales tax pass-through are noted, not ignored.
  • 对账桥梁中的每一项数据均来自Amazon官方报告，而非估算。
  • 每一项均对应至特定的Schedule C字段。
  • 对账结果需解释与银行存款金额的任何差异。
  • 需标注市场服务商状态及销售税代收代缴情况，不可忽略。

Common mistakes

常见错误

  • Reporting net only. Showing 480k of revenue when the 1099-K to the IRS says 1.2M. instant red flag for an audit.
  • Missing the fee deduction. Paying tax on the gross because the deductions were never separated out.
  • Confusing timing variance with an error. December sales paid in January cause a small gap. it is timing, not a bookkeeping error.
  • Treating sales tax as income. Amazon often collects and remits the tax. it is not the seller's income, but it shows up in the gross.
This skill is general guidance, not tax advice. work with a CPA for your specific situation.
  • 仅申报净销售额：当1099-K向IRS申报120万美元时，卖家却只申报48万美元营收，这会立即引发审计预警。
  • 遗漏费用扣除：未分离各项扣除额，导致按总销售额缴税。
  • 将时间差异视为错误：12月销售额于1月到账会导致微小差异，这属于时间差异，而非记账错误。
  • 将销售税视为收入：Amazon通常会代收代缴销售税，这部分不属于卖家收入，但会被计入总销售额。
本技能仅提供通用指导，不构成税务建议。请结合自身具体情况咨询CPA。

Built by Jay GPT Pro

由Jay GPT Pro开发

Part of Amazon Pro Skills. Production-grade skills for serious Amazon sellers. Free and open. Built by Jay Margaliot.
I share a new AI play for Amazon sellers every week, free, in my WhatsApp group. Join here: https://chat.whatsapp.com/ILX65p1yWcaIG3c9WGHpTY
属于Amazon Pro Skills系列。为专业Amazon卖家打造的生产级技能。免费开源。由Jay Margaliot开发。
我每周会在WhatsApp群组中分享一个面向Amazon卖家的新AI玩法，免费开放。 加入链接：https://chat.whatsapp.com/ILX65p1yWcaIG3c9WGHpTY