translated title
translated summary under 160 chars
translated article in markdown format
We must not include JSON or code blocks. Just plain text with those headings.
We need to translate title, summary, and the article content (including HTML tags? The original article includes HTML tags like
,
,
- , etc. We should translate the content while preserving markdown format. The instruction says "translated article in markdown format". So we need to convert HTML to markdown? Or keep HTML? Probably translate the text inside tags, keep tags as is? The original article is HTML, but they want markdown format output. So we should translate the content and present it in markdown (using # headings, etc). We'll convert HTML headings to markdown headings, lists to markdown, etc.
- Export regularly – Schedule a monthly reminder to download transaction histories from every exchange you use. Most platforms offer a “Trade History” or “Account Statement” export in CSV or Excel format.
- Standardize file names – Use a convention like
ExchangeName_YYYY-MM.csv. This makes sorting and later scripting far easier. - Store in a single folder – Keep all raw exports in a dedicated directory (e.g.,
~/crypto_tax/raw/). Back it up to a cloud drive or external SSD to avoid loss. - 定期导出 – 设置每月提醒,下载您使用的每个交易所的交易历史。大多数平台提供 CSV 或 Excel 格式的“交易历史”或“账户对账单”导出。
- 标准化文件名 – 采用类似
ExchangeName_YYYY-MM.csv的命名约定。这样排序和后续脚本编写会容易得多。 - 存储在单一文件夹 – 将所有原始导出放在专用目录中(例如
~/crypto_tax/raw/),并备份到云盘或外部 SSD,以防丢失。 - Map columns – Write a simple lookup table (in a spreadsheet or a short Python script) that tells the script where each exchange’s columns belong. Example: Binance’s “Realized PNL” maps to “Profit/Loss” while Coinbase’s “Subtotal” maps to “Amount (Quote)”.
- Convert timestamps – Ensure all dates are in UTC ISO‑8601 format (
YYYY-MM-DDTHH:MM:SSZ). This eliminates timezone confusion when aggregating across platforms. - Handle fees – Some exchanges list fees separately; others embed them in the trade amount. Decide on a consistent rule (e.g., always subtract fees from the proceeds) and apply it uniformly.
- 映射列 – 编写一个简单的查找表(在电子表格或短 Python 脚本中),告诉脚本每个交易所的列对应到哪里。例如,Binance 的 “Realized PNL” 映射到 “Profit/Loss”,而 Coinbase 的 “Subtotal” 映射到 “Amount (Quote)”。
- 转换时间戳 – 确保所有日期均为 UTC ISO‑8601 格式(
YYYY-MM-DDTHH:MM:SSZ),以避免跨平台聚合时的时区混淆。 - 处理手续费 – 某些交易所单独列出手续费,而另一些则将手续费嵌入交易金额。决定一致的规则(例如, всегда 从所得中扣除手续费),并统一应用。
- Identify duplicates – If you move assets between exchanges, the same transaction may appear as a withdrawal on one platform and a deposit on another. Use a hash of (date, amount, asset, exchange pair) to flag potential duplicates. Review flagged rows manually before removing them.
- Check balances – After cleaning, calculate the net balance for each asset across all exchanges and compare it to the sum of your wallet holdings. Discrepancies often point to missing deposits, withdrawals, or staking rewards that need to be added manually.
- 识别重复 – 在交易所之间转移资产时,同一笔交易可能在一个平台显示为提现,在另一个平台显示为存款。使用 (日期, 金额, 资产, 交易对) 的哈希值来标记潜在重复。在删除之前,请人工检查被标记的行。
- 核对余额 – 清理后,计算所有交易所中每种资产的净余额,并与您钱包持有的总和进行比较。差异通常指向缺失的存款、取款或质押奖励,需要手动添加。
- Import the master CSV into your chosen tool.
- Select the appropriate accounting method (FIFO, Specific Identification, or HIFO) based on your jurisdiction’s rules.
- Run the calculation – The software will produce capital gains, losses, and income reports.
- Export the final reports – Typically you’ll receive a Form 8949‑compatible CSV, a summary of short‑term vs. long‑term gains, and an income statement for staking, lending, or airdrop rewards.
- 导入主 CSV 到您选择的工具中。
- 选择合适的会计方法(FIFO、特定识别或 HIFO),根据您所在司法管辖区的规则。
- 运行计算 – 软件将生成资本收益、损失和收入报告。
- 导出最终报告 – 通常您会得到符合 Form 8949 的 CSV、短期 vs 长期收益汇总,以及质押、借贷或空投奖励的收入表。
- Monthly reconciliation – Treat the export‑normalize‑verify cycle as a monthly bookkeeping task. Consistency prevents year‑end scrambles.
- Archive source files – Keep the raw exchange exports for at least seven years (or as required by your local tax authority).
- Stay updated on rule changes – Tax agencies frequently issue new guidance on crypto. Subscribe to newsletters from reputable tax firms or follow official channels (e.g., IRS Virtual Currencies FAQ) to adjust your mapping rules promptly.
- 每月对账 – 将导出‑标准化‑验证循环视为每月的记账任务。保持一致性可避免年末手忙脚乱。
- 归档源文件 – 至少保存七年(或根据当地税务机关要求)的原始交易所导出文件。
- 及时了解规则变动 – 税务机关经常发布新的加密货币指南。订阅 reputable 税务
We need to keep code snippets like ExchangeName_YYYY-MM.csv etc. Should translate surrounding text but keep code as is.
We must ensure summary under 160 Chinese characters.
Let's craft translation.
Title: "管理多个交易所账户并合并税务报告"
Summary: Under 160 characters. Something like: "学习实用步骤,简化多交易所加密资产管理,生成准确统一的税务报告。" Count characters: Let's count: 学(1)习2 实3用4 步5骤6 ,7 简8化9 多10交11易12所13加14密15资16产17管18理19 ,20 生21成22 准23确24统25一26的27税28务29报30告31。 That's 31 characters, well under 160.
Now content: We'll convert to markdown.
We'll start with ## 为什么管理多个交易所账户很重要
Then paragraphs.
We need to translate all text, preserve code snippets and maybe keep tags? In markdown we can use backticks for inline code. So replace ExchangeName_YYYY-MM.csv with ExchangeName_YYYY-MM.csv. Similarly for other code.
We'll also convert tables to markdown.
Let's do step by step.
First, translate headings:
Why Managing Multiple Exchange Accounts Matters
=> ## 为什么管理多个交易所账户很重要
Step‑by‑Step Workflow for Consolidation
=> ## 合并的逐步工作流程
1. Centralize Data Collection
=> ### 1. 集中数据收集
2. Normalize the Data
=> ### 2. 标准化数据
3. De‑duplicate and Verify
=> ### 3. 去重并验证
4. Generate Unified Tax Reports
=> ### 4. 生成统一税务报告
5. Maintain Ongoing Compliance
=> ### 5. 持续保持合规
Tools and Tips to Simplify the Process
=> ## 工具和技巧,简化流程
Practical Tips
=> ### 实际技巧
Common Pitfalls and How to Avoid Them
=> ## 常见陷阱及避免方法
Final Thoughts
=> ## 最后思考
Now translate paragraphs.
We'll need to convert lists to markdown.
We'll also need to translate table headings.
Let's do it.
First paragraph after first heading:
Original:
Cryptocurrency traders often spread their activity across several exchanges to capture better liquidity, lower fees, or access unique tokens. While diversification can improve trading outcomes, it also creates a tangled web of transaction data. Each platform exports CSV files with different column headings, date formats, and fee structures. Without a systematic approach, you risk missing trades, misclassifying gains, or filing inaccurate tax returns—potentially triggering audits or penalties.
Translate: 加密货币交易者常常将活动分散到多个交易所,以获取更好的流动性、降低费用或获取独特代币。虽然多样化可以改善交易结果,但也会产生交易数据的错综复杂网络。每个平台导出的 CSV 文件具有不同的列标题、日期格式和费用结构。如果没有系统的方法,您可能会遗漏交易、错误分类收益或提交不准确的税务申报——这可能导致审计或处罚。
Now the list under 1. Centralize Data Collection:
Original list items:
Translate each:
Now section 2. Normalize the Data.
Paragraph:
Different exchanges label the same information in varied ways. Create a master template with these columns:
Translate: 不同交易所对相同信息的标签各不相同。创建一个主模板,包含以下列:
Then table: we need markdown table.
Original table headings: Date (UTC), Exchange, Pair, Type (Buy/Sell/Transfer/Fee), Amount (Base), Amount (Quote), Price (Quote), Fee Amount, Fee Currency, Notes.
Translate headings: 日期 (UTC), 交易所, 交易对, 类型 (买入/卖出/转账/手续费), 基础币种数量, 计价币种数量, 价格 (计价币种), 手续费数量, 手续费币种, 备注.
We keep the empty row as placeholder.
Then bullet list:
Translate:
Now section 3. De‑duplicate and Verify.
Paragraph:
Translate:
Section 4. Generate Unified Tax Reports.
Paragraph:
Most tax‑calculation software (e.g., CoinTracker, Koinly, TokenTax) accepts a standardized CSV. If you prefer a DIY approach:
Translate: 大多数税务计算软件(如 CoinTracker、Koinly、TokenTax)接受标准化 CSV。如果您更倾向于 DIY 方法:
Then ordered list:
Translate:
Section 5. Maintain Ongoing Compliance.
Paragraph:
Translate: