基于 Beancount 复式记账规范的多平台账单去重工具，支持支付宝、微信、银行卡账单的去重与格式转换。
Beancount 是一个优秀的纯文本复式记账系统。本项目是一个独立的第三方工具，用于将中国主流支付平台（支付宝、微信支付）和银行账单转换为 Beancount 格式，并智能去重。
- 三级哈希指纹去重：L1(精确) / L2(宽松) / L3(模糊) 匹配策略
- 多格式支持：CSV、XLSX、PDF 自动转换
- 智能账户分类：基于 Beancount 最佳实践的自动分类
- 平台优先级：支付宝 > 微信 > 银行（信息完整度优先）
- 特殊场景识别：内部转账、跨天凌晨交易、连续相同金额交易保护
# 1. Clone the repository
# Replace <YOUR_GITHUB_USERNAME> with your GitHub username
git clone https://github.com/<YOUR_GITHUB_USERNAME>/FinancialBeancount.git
cd FinancialBeancount
# 2. Install dependencies (optional, for XLSX/PDF support)
pip install -r requirements.txt
# 3. Place your statement files in input/ folder
cp /path/to/your/statements/* input/
# 4. Run the pipeline
python example_usage.py
# 5. Check the output
# output/output.beancount - Deduplicated transactions
# output/duplicate_report.beancount - Duplicate transaction reportFinancialBeancount/
├── beancount_dedup/ # Main package
│ ├── models.py # Data models
│ ├── fingerprinter.py # Three-level fingerprint hashing
│ ├── deduplicator.py # Deduplication engine
│ ├── account_classifier.py # Intelligent account classification
│ ├── converters/ # Format converters (PDF/XLSX→CSV)
│ ├── parsers/ # Platform-specific parsers
│ └── exporters/ # Beancount format exporter
├── test_data/ # Sample anonymized data
├── input/ # User statements (not in git)
├── output/ # Generated output (not in git)
└── example_usage.py # Usage example
from beancount_dedup import DeduplicationEngine
from beancount_dedup.parsers.alipay_parser import AlipayParser
from beancount_dedup.exporters.beancount import BeancountExporter
# Parse statements
alipay_txs = AlipayParser().parse("alipay_202401.csv").transactions
# Deduplicate
engine = DeduplicationEngine()
engine.add_transactions(alipay_txs)
unique_txs = engine.get_unique_transactions()
# Export to Beancount format
exporter = BeancountExporter()
exporter.export(unique_txs, output_path="output.beancount")# Process all files in input/ folder
python example_usage.pyThis project uses Beancount best practices for account hierarchy:
Assets:Current:Digital:Alipay # Alipay wallet
Assets:Current:Digital:WeChat # WeChat wallet
Assets:Current:Bank:CMB # China Merchants Bank
Expenses:Food:Restaurant # Restaurants
Expenses:Food:Delivery # Food delivery
Expenses:Transport:Private # Taxi/Didi
Expenses:Shopping:Online # Online shopping (JD/Taobao)
Expenses:Entertainment:Subscription # Subscriptions (Netflix, etc.)
| Platform | Format | Status |
|---|---|---|
| Alipay / 支付宝 | CSV | ✅ Fully supported |
| WeChat Pay / 微信支付 | CSV | ✅ Fully supported |
| Bank Cards / 银行卡 | CSV | ✅ Generic format |
| Excel (XLSX/XLS) | → CSV | ✅ Auto-conversion |
| → CSV | pdfplumber |
# Unit tests
python test_dedup.py
# E2E tests
python test_e2e_pipeline.py
# Test with sample data
cp test_data/*.csv input/
python example_usage.py| Level | Time Window | Description |
|---|---|---|
| L1 | 2 minutes | Exact match: date + amount + normalized counterparty |
| L2 | 2 minutes | Loose match: date + amount (ignore name variations) |
| L3 | 1 day | Fuzzy match:跨天/手续费 scenarios (marked for review) |
- All processing is local - No data is sent to external servers
- input/ and output/ folders are excluded from git - Your financial data never leaves your machine
- Sample test data is anonymized - No real personal information in the repository
Contributions are welcome! Please feel free to submit a Pull Request.
- Fork the repository
- Create your feature branch (
git checkout -b feature/AmazingFeature) - Commit your changes (
git commit -m 'Add some AmazingFeature') - Push to the branch (
git push origin feature/AmazingFeature) - Open a Pull Request
- Beancount by Martin Blais - The excellent plain text double-entry accounting system that inspired this project
- Beancount Documentation - Comprehensive documentation and best practices
- All contributors to the Beancount ecosystem
This project is licensed under the MIT License - see the LICENSE file for details.
This is an independent third-party tool and is NOT officially affiliated with, endorsed by, or connected to:
- Alipay (支付宝) or Ant Group (蚂蚁集团)
- WeChat Pay (微信支付) or Tencent (腾讯)
- Any financial institutions mentioned
This tool is provided for educational and personal finance management purposes. The authors are not responsible for any financial decisions made based on the output of this software.