Appearance
Alipay Bill Import Guide
📋 Overview
This guide shows you how to export bills from Alipay and import them into Expense Tracker: Koala (“Koala”).
📱 Part 1: Export bills in Alipay
Step 1: Open the Bills page
- Open Alipay
- Tap Me
- Tap Bills
📝 Note: Entry points may vary by Alipay version. If you can’t find it, try searching “账单” in Alipay.
Step 2: Start export
- On the Bills page, tap ... (top-right)
- Select Transaction statement / Bill export (wording may differ)
- Choose Personal reconciliation and tap Apply
Step 3: Select export options
- Choose transaction type: All / Income / Expense
- Choose the time range (e.g. last month / last 3 months)
- Choose delivery method: Alipay / Email
💡 Tips:
- Export up to 3 months at a time to avoid very large files.
- For longer history, export multiple files.
- If you choose email, Alipay sends the file as an attachment (make sure your email is configured).
Step 4: Save the file to your device
- If delivered via email:
- Open your mailbox and find the message from Alipay
- Download the attachment (CSV)
- Save it locally (so the file picker can access it)
- If “Save to Files” is available:
- Save it to your Downloads folder
- Remember the location
📝 Where the file usually goes:
- iOS: Files app → Downloads
- Android: Downloads folder or Alipay folder
📱 Part 2: Import into Expense Tracker: Koala
Step 1: Open the import page
- Open Expense Tracker: Koala
- Tap Settings
- Find Bill Import
- Enter the bill import page
Step 2: Choose the import source
- Tap Import source
- Select Alipay
⚠️ Important: You must choose Alipay, otherwise the file cannot be parsed correctly.
Step 3: Pick the file
- Tap File path
- Select the CSV file exported from Alipay
- Confirm the file name is shown
Step 4: Link a ledger
- Tap Linked ledger
- Choose the target ledger
💡 Tip: If you only have one ledger, Koala links it automatically.
Step 5: Parse, preview, and import
- Tap Parse (top-right)
- Review records on the preview page
- Edit categories/accounts/notes if needed
- Tap Import
📋 Alipay CSV columns (reference)
Alipay’s CSV export typically contains:
| Column name (as exported) | Meaning | Example |
|---|---|---|
| 交易时间 | Transaction time | 2024-01-01 12:00:00 |
| 交易分类 | Category label | 餐饮美食/日用百货 |
| 交易对方 | Counterparty | 张三 / Merchant name |
| 对方账号 | Counterparty account | xxx@163.com |
| 商品说明 | Item description | Lunch / Shopping |
| 收/支 | Income / Expense | 收入 / 支出 |
| 金额 | Amount | 100.00 |
| 收/付款方式 | Payment method/account | 余额宝 |
| 交易状态 | Status | 交易成功 / 已退款 |
| 交易订单号 | Transaction order no. | 20240101... |
| 商家订单号 | Merchant order no. | 1234567890 |
| 备注 | Note | 备注内容 |
📝 Note: Column names may vary slightly by Alipay version, but the meaning is the same.
⚠️ Notes
1. File requirements
- Encoding: UTF-8 is recommended (Alipay exports may be UTF-8 or GBK)
- Format: CSV only (
.csv) - Size: recommended under 10MB per file
2. Field mapping (how Koala imports)
Koala maps Alipay columns to Koala fields automatically:
- Transaction time (row[0]) → bill date (date only,
yyyy-MM-dd) - Category (row[1]) → category (parent and child set to the same name)
- Counterparty / account / item / status / order numbers → appended into the bill note (combined)
- Income/expense (row[5]) → bill type (income/expense)
- Amount (row[6]) → bill amount
- Payment method (row[7]) → account (matched by name; created if missing)
- Note (row[11]) → bill note (used as the original note; “/” or empty is ignored, then Koala appends extra lines)
3. Category and account matching
- Automatic matching may not be perfect; review and adjust in the preview page.
- If an account does not exist, Koala may create it automatically.
4. Duplicate and refund handling
- If a record is detected as a duplicate (based on transaction identifiers), Koala may skip it.
- Refund-related records are usually marked as “已退款/退款成功”; review them in the preview page.
5. Avoid manual edits to the export file
Do not modify the exported file (especially headers/columns). Renaming headers, deleting columns, or adding columns may cause parsing to fail.
🔧 FAQ
Q1: I can’t find “Bill export”.
Possible reasons:
- Your Alipay version is too old
- The entry point is different
Try:
- Tap ... on the Bills page
- Look for Bills under Me
- Search “账单导出” in Alipay
Q2: I didn’t receive the email.
Check:
- Whether an email address is linked in Alipay
- Whether the email address is correct
- Spam/junk folder
- Try “Save to Files” (if available)
Q3: Parsing failed.
Check:
- File format is CSV
- Import source is set to Alipay
- File is not corrupted
- Encoding is correct (UTF-8 or GBK)
Q4: Categories look wrong after import.
This can happen because Alipay’s category labels may not match Koala’s categories exactly. Review and adjust categories in the preview page, or batch-edit after import.
Q5: Can I import images?
Not supported.
Q6: How much history can I import?
There is no strict limit, but it’s recommended to:
- Import up to 3 months per file
- Split large ranges into multiple files
- Keep the app in the foreground during import
Q7: Why is only CSV supported?
Alipay currently exports bills in CSV. If Excel export becomes available, the guide will be updated.
💡 Tips
- Import regularly (e.g. monthly) to keep data up to date
- Review categories after import for better statistics
- Create common accounts ahead of time to avoid messy auto-created names
- Consider backing up your data before importing
- Review refund records after import
Last updated: May 2026