📥 Import CSV Orders¶

Supported Batch-Import Platforms¶

Batch import supports the following data source platforms (✅ checked = now supported):

✅ Now Supported (auto-detection · auto-dedup · auto emoji matching)

• 🐶 JD.com — one-click CSV export via the browser extension
• 🛒 Taobao / Tmall — one-click CSV export via the browser extension
• 🎮 Steam — one-click CSV export via the browser extension
• 💬 WeChat Bills — "Download Bill" inside the WeChat app (CSV / Excel)
• 💳 Alipay — "Transaction Details" export inside the Alipay app (CSV / Excel)

⏳ Coming Soon (in the pipeline)

• 🛍️ Pinduoduo
• 🐟 Xianyu

• 📱 Douyin Mall

• JD.com / Taobao / Steam → see "Import via the Browser Extension" below

• WeChat / Alipay → no extension needed, see "Import WeChat / Alipay Bills" below
• Other platforms (Pinduoduo / Xianyu / Douyin Mall, etc.) are in the pipeline. In the meantime, use "Add Item" to enter them manually

📁 File Format Quick Reference¶

Check this section before importing to make sure the file you have is in the right format. All data sources use common standard formats (CSV text or Excel), which the system detects automatically — no manual renaming or re-encoding needed:

✅ Detection rules: the jd-, tb-, steam-, wx-, alipay-/zfb- filename prefixes, as well as each platform's unique header columns (such as WeChat's 交易单号 / transaction ID and Alipay's 交易订单号 / transaction order ID), are all recognized automatically. Just drag in the unmodified original export file and you are good to go.

Import via the Browser Extension (JD.com / Taobao / Steam)¶

🧩 Install the extension → 📤 Export CSV → 📥 Import into DailyCost Vault

1. Install the Browser Extension¶

Supported browsers: Chrome, Edge, and other Chromium-based browsers.

📥 Download the Browser Extension (zip)

1. Download and unzip the zip above to get the dailycost-exporter-extension folder, which contains manifest.json. Do not delete this folder.
2. Open your browser's extensions page and turn on Developer mode:
3. Chrome: chrome://extensions/
4. Edge: edge://extensions/
5. Click Load unpacked and select the folder you just unzipped.
6. The extension icon 🧩 should appear in the toolbar.

💡 After you finish exporting, you can remove the extension from the extensions page. This will not affect your CSV files. We recommend removing it after use.

2. Export the Order CSV¶

The three platforms follow the same basic flow:

1. Log in and open your own order page.
2. Click the extension icon 🧩 in the toolbar. The extension will detect the current platform automatically.
3. Use the suggested options. If you are unsure, the defaults are fine.
4. Click Start Export. Progress appears in the bottom-right corner, and the CSV downloads automatically when finished.

💡 Exporting JD.com orders in year-based batches reduces the chance of risk-control blocks. Files are automatically named like jd-orders-20260804-103000-complete.csv.

⚠️ Steam exports include refunds and wallet top-ups too, but you do not need to worry about them. The system filters them during import.

🔒 Mask Sensitive Data is checked by default to protect privacy.

What the exported CSV looks like¶

The extension exports comma-separated UTF-8 text that you can open in Notepad / Excel / any text editor. The three platforms have slightly different key columns, but the core info (order ID, product name, amount, time) is the same:

3. Import into DailyCost Vault¶

After you have the CSV files, you can import them in either of two ways:

• Drag and drop (recommended) — drag the CSV files into the Data Import area on the Settings page. You can drop multiple files at once.
• Select files — go to Settings → Data Import → click Select CSV Files, then hold Ctrl to select multiple files.

After import, you will see a message like Success X, Skipped X. Skipped means the order already exists or does not meet the import conditions, so the system has already deduplicated it.

Import WeChat Bills (No Extension Needed)¶

WeChat bills can be exported directly from inside the WeChat app — no browser extension required. The exported file is CSV / Excel and can be imported by dragging it into DailyCost Vault:

1. Open WeChat → Me → Services → Wallet
2. Tap "Bills" in the top-right corner
3. Tap "FAQ" in the top-right corner
4. Tap "Download Bill"
5. Choose "For Personal Reconciliation"
6. Select the transaction type and time range, then tap "Next"
7. Enter your email address and submit. WeChat will send the bill download link to that email
8. Download the bill archive (zip) from your email, unzip it to get the CSV / Excel file, then drag it into DailyCost Vault (or click "Select File" in Settings to import)

📖 For a detailed illustrated guide, see: How to Export WeChat Bills as Excel (Baidu Experience)

What the WeChat bill looks like¶

After unzipping the email archive, you get a .csv or .xlsx file (openable in Excel / spreadsheet apps). Filenames look like:

微信支付账单流水文件(20250101-20260101)_20260804233920.xlsx

The first dozen or so lines are metadata (WeChat nickname, time range, income/expense statistics, etc.). The real header and data rows come after the metadata, with these columns:

WeChat Bill Import Rules: Kept vs Filtered¶

The system automatically distinguishes data during import, so you always know what is kept and what is filtered out:

✅ Kept (imported)

• Only "Expense" records are imported (Income/Expense column = 支出 / Expense)
• Status whitelist: 支付成功 (Payment Successful) / 已支付 (Paid) / 交易成功 (Transaction Successful) / 完成 (Completed) / 已转账 (Transferred) / 对方已收钱 (Received) / empty
• No transaction-type filtering: transfers, red packets, QR-code payments, group collections, and family-card payments are kept too, so you see your full daily spending (product name falls back to the counterparty when empty)
• Amount is taken as an absolute value; payment method + remark are merged into the model/style field; records are deduplicated by transaction ID

❌ Filtered (skipped)

• Income / not-expense records
• Refund or abnormal statuses: 已全额退款 (Fully Refunded), 已退款(¥X) (Refunded ¥X), 对方已退还 (Counterparty Refunded), etc.
• Records with an empty transaction ID, amount ≤ 0, or duplicates of existing records

Import Alipay Bills (No Extension Needed)¶

Alipay transaction details can be exported directly from inside the Alipay app — no browser extension required. The exported file is CSV / Excel and can be imported by dragging it into DailyCost Vault:

1. Open the Alipay app → My → Settings (top-right) → Bills (or tap Bills on the home screen)
2. On the Bills page, tap "···" → "Get Transaction Statement" (some versions label it under "Transaction Records")
3. Choose "For Personal Reconciliation", then select the time range to export
4. Make sure to tick all info columns: in the export options, tick "Show Counterparty Info" and "Show Product Description Info" (plus any other available options) — only then will the exported file include the "Counterparty" and "Product Description" columns, so product names and store names import in full
5. Enter your email address and submit. Alipay sends the transaction file to that email (some versions allow downloading directly in the app)
6. Download the file from your email and drag it into DailyCost Vault (or click "Select File" in Settings to import)

📖 For a detailed illustrated guide, see: How to Export Alipay Transaction Bills (Zhihu)

What the Alipay bill looks like¶

Alipay exports a .csv or .xlsx file whose filename usually contains "交易明细", or starts with the alipay- / zfb- prefix. The file has about twenty lines of metadata and a dashed separator line at the top; the real header and data rows come after the separator, with columns such as:

⚠️ Alipay CSV files are often GBK-encoded (they look fine in Windows but garbled if opened as UTF-8). DailyCost Vault detects the encoding automatically and imports them correctly — no manual conversion needed.

Alipay Bill Import Rules: Kept vs Filtered¶

✅ Kept (imported)

• Only "Expense" orders are imported (Income/Expense column = 支出 / Expense)
• Status whitelist: 交易成功 (Transaction Successful) / 支付成功 (Payment Successful) / empty
• Product name is taken from the product description, falling back through counterparty → transaction category → counterparty account when empty; store name falls back through counterparty → counterparty account → transaction category
• Amount is taken as an absolute value; payment method + remark are merged into the model/style field; records are deduplicated by transaction order ID

❌ Filtered (skipped)

• Income / not-expense / refund records (refunds, transfers, withdrawals, Yu'e Bao earnings, etc.)
• Abnormal statuses: 退款成功 (Refund Successful), 交易关闭 (Transaction Closed), 解冻 (Unfrozen), etc.
• Records with an empty transaction order ID, amount ≤ 0, or duplicates of existing records

💡 Always tick all info columns. Alipay export lets you tick/un-tick columns. If you drop columns like "Product Description" or "Counterparty", the import still works, but product/store names degrade to the transaction category / counterparty account (less readable). Ticking them all gives the most complete product and store names.

What the System Does Automatically¶

• ✅ Detects the platform (JD.com / Taobao / Steam / WeChat / Alipay)
• ✅ Imports only completed orders and skips pending or cancelled ones
• ✅ Matches the right emoji icon for each item
• ✅ Extracts JD.com product detail links
• ✅ Expands multi-item orders into separate cards
• ✅ Deduplicates by platform plus order ID

Security Notice¶

Next Steps¶

After importing, go to 📋 Manage Assets to learn how to view, filter, and edit your items.