expense-optimizer

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

Expense Optimizer

支出优化器（Expense Optimizer）

Overview

概述

Analyze your transaction history to identify recurring expenses, unused subscriptions, duplicate services, and optimization opportunities. Surfaces actionable savings by detecting charges you may have forgotten about or services you could downgrade.

分析您的交易记录，识别经常性支出、未使用的订阅服务、重复服务以及优化机会。通过检测您可能遗忘的收费项目或可降级的服务，提供可落地的省钱方案。

Wilson Tools Used

使用的Wilson工具

```
transaction_search
```
— detect recurring charges by pattern and frequency
```
anomaly_detect
```
— flag subscriptions with price increases or irregular charges
```
spending_summary
```
— identify highest-spend recurring categories

```
transaction_search
```
— 根据模式和频率检测经常性收费
```
anomaly_detect
```
— 标记出现价格上涨或异常收费的订阅服务
```
spending_summary
```
— 识别支出最高的经常性类别

Workflow

工作流程

Use
```
transaction_search
```
to find all transactions from the last 6 months.
Identify recurring charges by grouping transactions with similar descriptions and regular intervals (weekly, monthly, annual).
Build a recurring expense inventory:
Service Monthly Cost Frequency Last Charged Category
Use
```
anomaly_detect
```
to flag:
- Subscriptions with recent price increases
- Charges that stopped (possible cancellation or card expiry)
- Services charged but not seen in a while (potential unused subscriptions)
Classify each recurring expense into optimization categories (see table below).
Present findings with estimated annual savings for each recommendation.
Summarize total potential savings.

使用
```
transaction_search
```
查找过去6个月的所有交易记录。
通过将描述相似、间隔规律（每周、每月、每年）的交易分组，识别经常性收费。
构建经常性支出清单：
服务月均费用收费频率最后收费日期类别
使用
```
anomaly_detect
```
标记以下情况：
- 近期出现价格上涨的订阅服务
- 已停止的收费项目（可能已取消或银行卡过期）
- 已收费但许久未使用的服务（潜在的未使用订阅）
将每项经常性支出归类到对应的优化类别（见下表）。
呈现分析结果，并给出每项建议的预计年度节省金额。
汇总潜在的总节省金额。

Optimization Categories

优化类别

Category	Description	Examples
Cancel	Services you likely don't use	Gym memberships with no related spending nearby, streaming services you haven't watched
Downgrade	Premium tiers you could reduce	Phone plan with unused data, cloud storage over 50% empty
Negotiate	Services with competitive alternatives	Internet, insurance, cell phone
Consolidate	Overlapping services	Multiple streaming, multiple cloud storage, multiple music services
Switch	Cheaper alternatives exist	Bank fees (switch to no-fee), high-interest debt (refinance)
Keep	Good value, actively used	No action needed

类别	说明	示例
取消	您可能未使用的服务	附近无相关消费的健身房会员、未观看过的流媒体服务
降级	可降低档次的高级套餐	有未使用流量的电话套餐、使用率不足50%的云存储
协商	存在竞品替代的服务	互联网、保险、手机服务
合并	重叠的服务	多个流媒体服务、多个云存储、多个音乐服务
更换	存在更便宜替代方案的服务	银行手续费（更换为免手续费账户）、高息债务（refinance）
保留	性价比高且经常使用的服务	无需采取任何行动

Without Wilson

不使用Wilson的情况

To find recurring expenses manually:

手动查找经常性支出的方法：

Step-by-Step in a Spreadsheet

电子表格分步操作

Export 6 months of transactions from your bank as CSV.
Sort by Description alphabetically to group similar charges.
Identify recurring charges:
- Filter for common subscription amounts: $4.99, $9.99, $12.99, $14.99, $15.99, $19.99
- Search for keywords:
```
SUBSCRIPTION
```
  ,
```
RECURRING
```
  ,
```
MONTHLY
```
  ,
```
ANNUAL
```
  ,
```
RENEWAL
```
- Look for identical amounts from the same vendor appearing monthly
Build your subscription inventory in a new sheet:
```
=SUMIFS(Amount, Description, "*NETFLIX*", Date, ">="&TODAY()-180) / 6
```
This gives the average monthly cost for Netflix over the last 6 months.

Detect price increases: Compare the most recent charge to the oldest charge for each vendor:

Current:  =INDEX(Amount, MATCH(1, (Description="*NETFLIX*")*(Date=MAX(IF(Description="*NETFLIX*",Date))), 0))
Original: =INDEX(Amount, MATCH(1, (Description="*NETFLIX*")*(Date=MIN(IF(Description="*NETFLIX*",Date))), 0))

Calculate annual cost:
```
=MonthlyCost * 12
```
Sum potential savings: Add up the annual cost of services you'd cancel, downgrade, or switch.

导出6个月交易记录：从银行导出CSV格式的过去6个月交易记录。
按描述排序：按字母顺序对交易描述排序，将相似收费分组。
识别经常性收费：
- 筛选常见的订阅金额：$4.99、$9.99、$12.99、$14.99、$15.99、$19.99
- 搜索关键词：
```
SUBSCRIPTION
```
  、
```
RECURRING
```
  、
```
MONTHLY
```
  、
```
ANNUAL
```
  、
```
RENEWAL
```
- 查找同一商家每月出现的相同金额收费
在新工作表中构建订阅清单：
```
=SUMIFS(Amount, Description, "*NETFLIX*", Date, ">="&TODAY()-180) / 6
```
此公式可计算过去6个月Netflix的平均月费用。

检测价格上涨：比较每个商家的最新收费与最早收费：

Current:  =INDEX(Amount, MATCH(1, (Description="*NETFLIX*")*(Date=MAX(IF(Description="*NETFLIX*",Date))), 0))
Original: =INDEX(Amount, MATCH(1, (Description="*NETFLIX*")*(Date=MIN(IF(Description="*NETFLIX*",Date))), 0))

计算年度费用：
```
=MonthlyCost * 12
```
汇总潜在节省金额：将您计划取消、降级或更换的服务的年度费用相加。

Free Tools

免费工具

Rocket Money (formerly Truebill): Automatically detects and helps cancel subscriptions
Trim: Negotiates bills on your behalf (takes a percentage of savings)
Bobby (iOS app): Manual subscription tracker with renewal reminders

Rocket Money（原Truebill）：自动检测并帮助取消订阅服务
Trim：代表您协商账单（收取节省金额的一定比例作为费用）
Bobby（iOS应用）：手动订阅追踪工具，提供续费提醒

Important Notes

重要说明

Recurring detection works best with 3+ months of transaction history. With less data, some annual charges may be missed.
Annual charges (e.g., Amazon Prime, domain renewals) only appear once — Wilson looks back 12 months for these if data is available.
Some services use different billing descriptors than their brand name (e.g., "GOOGLE *YouTube" for YouTube Premium). Wilson groups these by learning common aliases.
This skill identifies candidates for optimization but does not cancel or modify any services on your behalf.

经常性支出检测在拥有3个月以上交易记录时效果最佳。数据不足时，可能会遗漏部分年度收费项目。
年度收费（如Amazon Prime、域名续费）仅出现一次——如果有可用数据，Wilson会回溯过去12个月的记录来查找这些项目。
部分服务的账单描述与其品牌名称不同（例如YouTube Premium显示为"GOOGLE *YouTube"）。Wilson通过学习常见别名来对这些服务进行分组。
此技能仅识别可优化的候选项目，不会代表您取消或修改任何服务。