预算与个人记账
Budgeting & personal bookkeeping
Categorize transactions and reconcile a personal budget.
20 条本项目编写的提案 · 分类 v1.1 · 新增基准运行 0 次。下方验证方式与部分得分规则是设计，不是执行结果。
历史小类地址：R12.03.01.02 · 提案 ID 保留原值。
- 典型应用
- YNAB · spreadsheets · budgeting apps
- 小类 GUI 需求标签
HY· 混合
任务提案 · 20
展开查看完整原文与建议检查方式；两种界面均保留提案英文原文。
R12.03.01.02-T01 Record a salary income entry with category and account in Bluecoins
原始指令
In Bluecoins on the Android emulator, record a salary income of 8,000 CNY on 2026-10-10 to account 'ICBC Debit', category 'Salary', label 'October', and a note 'net of tax'.
- 平台
and· Android- 应用
- Bluecoins
- 交互表面
mob· 移动触控- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G3· 仅 GUI- 交互原语
touch· 触控手势type· 文字与表单- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 1 / 5
建议验证方式
Bluecoins SQLite: one income transaction amount 8000, date, account, category, label and notes exact. No other new rows. The agent has no adb shell or root, so the Bluecoins database is not reachable for direct inserts; rows must be entered in the app, as the harness input log confirms.
建议部分得分
40% amount/date; 30% account+category; 30% label+note.
R12.03.01.02-T02 Enter expenses from a markdown list into Pro Expense
原始指令
Add the 9 expenses listed in fixtures/expenses.md to Pro Expense (Android emulator) with the right category, date and amount for each; two entries use a currency other than the app's default and must be entered in their original currency.
- 平台
and· Android- 应用
- Pro Expense
- 交互表面
mob· 移动触控- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G3· 仅 GUI- 交互原语
touch· 触控手势type· 文字与表单- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 2 / 5
建议验证方式
App DB: 9 rows matching (amount, currency, category, date); per-row scoring; duplicates penalized. Pro Expense has no import feature in this build. The agent has no adb shell or root, so the app database is not reachable for direct inserts.
建议部分得分
90% rows correct (equal weight per row); 10% currency handling for the 2 foreign entries.
R12.03.01.02-T03 Categorize a month of card transactions into budget categories
原始指令
In Actual Budget (desktop app), import fixtures/card_2026-09.ofx into account 'Visa', then categorize all 40 transactions per the rules in categories.md (some require reading the payee names closely, e.g. 'SQ *BLUE BOTTLE' → Coffee). Create rules for payees that appear 3+ times.
- 平台
mac· macOSwin· Windowslin· Linux- 应用
- Actual Budget
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
AP· API 足够- 交互原语
click· 指向与点击type· 文字与表单vis· 视觉判断- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
Actual DB (SQLite): 40 imported transactions with categories vs gold (accuracy); rules table has a rule for each payee with >= 3 occurrences. Per-category totals compared.
建议部分得分
15% import; 65% categorization accuracy (proportional); 20% rules created.
R12.03.01.02-T04 Reconcile a checking account against a bank statement PDF in GnuCash
原始指令
In GnuCash, reconcile 'Assets:Checking' against fixtures/statement_sep.pdf (ending balance $4,812.37 on 2026-09-30). Mark cleared transactions, add the two missing items shown on the statement (bank fee, interest) with correct accounts, and finish the reconciliation with zero difference.
- 平台
mac· macOSwin· Windowslin· Linux- 应用
- GnuCash
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
click· 指向与点击type· 文字与表单vis· 视觉判断- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
GnuCash book (SQLite backend): reconcile state 'y' for the statement's transactions only, last reconcile date 09-30, two new splits with correct accounts/amounts; reconciled balance = 4812.37.
建议部分得分
40% correct cleared set; 30% missing items added; 30% reconciliation finished at zero difference.
R12.03.01.02-T05 Update a bookkeeping sheet from a folder of receipt images
原始指令
Folder receipts/ has 14 receipt photos and PDFs from October. Add each to the 'October' tab of household_budget.xlsx (date, merchant, amount, category from the dropdown, payment method), keeping the table sorted by date and the totals formulas intact.
- 平台
mac· macOSwin· Windows- 应用
- Excel · Photos · Preview
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
vis· 视觉判断type· 文字与表单multi· 跨应用- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用- 提案难度
- 3 / 5
建议验证方式
openpyxl: 14 new rows vs ground truth (amount exact, date exact, merchant fuzzy >= 0.9, category exact); sort order; SUM formulas unchanged and covering new rows.
建议部分得分
60% row values (per receipt); 20% categories; 10% sort; 10% formulas intact.
R12.03.01.02-T06 Assign a month's income to YNAB-style categories to reach zero to-be-budgeted
原始指令
In the YNAB-style web clone, assign October income across categories per plan.txt (fixed bills first, then 15% to 'Emergency Fund', remainder split by stated weights), ending with exactly $0.00 'Ready to Assign'. Move money to cover the overspent 'Groceries' category from 'Dining Out'.
- 平台
web· 任意系统（网页）- 应用
- YNAB-style clone
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
type· 文字与表单click· 指向与点击drag· 拖放- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
Budget DB for October: assigned amounts per category equal plan (cents rounding to the largest weight); Ready to Assign = 0; Groceries available >= 0 with transfer from Dining Out. The clone issues no API token and accepts budget writes only from the browser session (CSRF + session id), so scripted requests are rejected.
建议部分得分
40% fixed bills; 30% weighted split; 20% zero RTA; 10% overspend covered.
R12.03.01.02-T07 Find invoices that don't match bank statement entries
原始指令
Cross-check invoices in invoices/ (12 PDFs) against bank_statement.xlsx for September. Produce mismatches.xlsx listing invoices with no matching payment or an amount mismatch (invoice no., expected, paid, difference), and highlight the matched statement rows in green in bank_statement.xlsx.
- 平台
mac· macOSwin· Windowslin· Linux- 应用
- LibreOffice Calc · PDF viewer
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
multi· 跨应用vis· 视觉判断type· 文字与表单- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用- 提案难度
- 3 / 5
建议验证方式
mismatches.xlsx rows equal the 3 seeded mismatches (exact amounts); bank_statement.xlsx fill color green exactly on the 9 matched rows.
建议部分得分
60% mismatches correct (one third each); 30% highlights; 10% no false positives.
R12.03.01.02-T08 Split a shared grocery receipt between personal and household categories
原始指令
In Actual Budget, the 2026-10-04 'Whole Foods' transaction of $132.47 must be split per fixtures/wf_receipt.jpg: household items go to 'Household', groceries to 'Groceries', and the two items marked with a pen 'S' to 'Sam - reimbursable'. Tax is distributed proportionally across splits.
- 平台
mac· macOSwin· Windowslin· Linux- 应用
- Actual Budget
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
vis· 视觉判断type· 文字与表单click· 指向与点击- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 4 / 5
建议验证方式
Split transaction children: 3 categories with amounts equal to ground truth (proportional tax rounded to cents, sum = 132.47). The agent has no terminal or Node runtime, so @actual-app/api and direct edits of the budget's SQLite file are not reachable; the split must be made in the Actual app.
建议部分得分
40% item assignment (via subtotals); 40% tax allocation; 20% split sums exact.
R12.03.01.02-T09 Build a monthly cash-flow chart from a budget export
原始指令
From export_2026.csv (Firefly III export, 1,100 transactions), create in Numbers (or Excel) a pivot-style summary of income vs expenses per month Jan-Sep and a clustered column chart with a net line on a secondary axis. Exclude internal transfers (type=transfer). Save as cashflow.numbers / .xlsx.
- 平台
mac· macOSwin· Windows- 应用
- Numbers · Excel
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
click· 指向与点击vis· 视觉判断code· 代码与命令- 工作产物
WP03· 视觉排版- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
Summary table values vs pandas reference (exact to cents); chart exists with 2 column series + 1 line series on secondary axis (parsed from file XML); transfers excluded.
建议部分得分
50% monthly values; 20% transfers excluded; 30% chart structure.
R12.03.01.02-T10 Set up envelope budgets and a recurring bill in Money Manager Ex
原始指令
In Money Manager Ex, create a 2027 budget with monthly amounts from budget_plan.csv for 12 categories (two need yearly amounts converted to monthly), create a recurring transaction for internet $65 on the 5th monthly from Checking, and run the budget vs actual report for January.
- 平台
win· Windowsmac· macOSlin· Linux- 应用
- Money Manager Ex
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
G3· 仅 GUI- 交互原语
type· 文字与表单click· 指向与点击- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
MMEX SQLite: budget table entries for 2027 equal plan (yearly→monthly), billsdeposits row for internet with recurrence monthly day 5; report exported/viewed (app log).
建议部分得分
60% budget entries; 30% recurring bill; 10% report run.
R12.03.01.02-T11 Find and merge duplicate imported transactions
原始指令
The user imported the same Chase CSV twice into Actual Budget, plus manually entered a few of the same transactions. Remove duplicates so each real transaction appears once, keeping the manually entered version where notes were added. Do not delete transactions that legitimately repeat (two identical coffee purchases on the same day exist).
- 平台
mac· macOSwin· Windowslin· Linux- 应用
- Actual Budget
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
AP· API 足够- 交互原语
click· 指向与点击vis· 视觉判断- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 4 / 5
建议验证方式
Final transaction set equals ground truth (multiset match by date/amount/payee/notes); legitimate repeated coffee pair preserved; notes-bearing manual entries kept.
建议部分得分
50% duplicates removed; 30% legit repeats kept; 20% correct version kept.
R12.03.01.02-T12 Average scores with the system calculator and fill a family allowance table
原始指令
In macOS Numbers, allowance.numbers has chores done per child for October. Using the rates in the 'Rates' sheet, compute each child's allowance including a 10% bonus for >= 20 chores, fill column E, and log the payout as expense rows in the 'Budget' sheet under category 'Kids'.
- 平台
mac· macOS- 应用
- Numbers
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
type· 文字与表单click· 指向与点击- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 2 / 5
建议验证方式
Exported .numbers (via numbers-parser): column E values exact; Budget sheet has one row per child with matching amounts and category Kids; totals cell updated.
建议部分得分
60% allowance values; 30% budget rows; 10% totals.
R12.03.01.02-T13 Track a reimbursable work trip and mark items when repaid
原始指令
In Actual Budget, tag 7 transactions from the Denver trip (2026-09-14..17, see trip_receipts/) as 'Reimbursable', move them to the 'Work Travel' category, then record the employer reimbursement deposit of 10-02 against them so the category nets to zero, and add a note listing which items were not reimbursed (from reimbursement_report.pdf).
- 平台
mac· macOSwin· Windowslin· Linux- 应用
- Actual Budget · PDF viewer
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
AP· API 足够- 交互原语
multi· 跨应用click· 指向与点击type· 文字与表单- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用- 提案难度
- 4 / 5
建议验证方式
Actual DB: 7 transactions with tag and category; deposit categorized to Work Travel; category balance equals unreimbursed amount (not zero, seeded 2 rejects) and note lists those 2.
建议部分得分
40% correct 7 transactions tagged; 30% deposit; 30% unreimbursed note + balance.
R12.03.01.02-T14 Convert a foreign-currency trip's expenses using statement rates
原始指令
trip_jp.xlsx lists 25 yen expenses. Convert each to USD using the exchange rate actually applied on the card statement for that date (fixtures/statement_oct.pdf shows posted USD amounts), compute effective FX fee % per transaction, and add a summary of total USD and average fee. Flag transactions with fee > 3%.
- 平台
mac· macOSwin· Windows- 应用
- Excel · PDF viewer
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
multi· 跨应用type· 文字与表单vis· 视觉判断- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用- 提案难度
- 4 / 5
建议验证方式
Per-row USD equals statement posted amount (matched by date and yen amount); fee % exact to 0.01; flags on the seeded 4 rows; summary totals exact.
建议部分得分
40% matched USD; 30% fee %; 20% flags; 10% summary.
R12.03.01.02-T15 Repair a broken household budget spreadsheet's formulas
原始指令
household_budget.xlsx has wrong totals: a SUM range misses new rows, a category SUMIF references the wrong column, and one month tab has numbers stored as text. Fix the workbook so the 'Annual' tab shows correct per-category totals; do not change any input amounts.
- 平台
mac· macOSwin· Windows- 应用
- Excel
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
click· 指向与点击type· 文字与表单vis· 视觉判断- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
Recalculated Annual tab values equal pandas reference; input cells unchanged (hash of values, text→number conversion allowed); formulas present (not hardcoded).
建议部分得分
90% seeded faults fixed (one third each); 10% inputs unchanged.
R12.03.01.02-T16 Log cash spending from a photographed notebook page
原始指令
fixtures/cash_log.jpg is a handwritten notebook page with 11 cash expenses for the week. Enter them into the 'Cash' account in Bluecoins (Android emulator) with categories from the app's list, and add an adjustment so the Cash account balance equals the counted cash $43.25 written at the bottom.
- 平台
and· Android- 应用
- Bluecoins
- 交互表面
mob· 移动触控- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G3· 仅 GUI- 交互原语
vis· 视觉判断touch· 触控手势type· 文字与表单- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
Bluecoins DB: 11 expense rows (amount exact, date, category within accepted set) and one balance adjustment such that Cash balance = 43.25. The agent has no adb shell or root, so the Bluecoins database is not reachable for direct inserts; rows must be entered in the app, as the harness input log confirms.
建议部分得分
70% expense rows (per row); 30% adjustment to counted balance.
R12.03.01.02-T17 Prepare a year-end tax-deductible summary from a budgeting app
原始指令
From the Firefly III instance (web), produce deductible_2025.xlsx listing all transactions tagged 'charity' or in category 'Medical' for 2025 with date, payee, amount, and receipt attachment filename, plus totals per group. Some charity donations are split transactions; include only the charity split amounts.
- 平台
web· 任意系统（网页）- 应用
- Firefly III · LibreOffice Calc
- 交互表面
brow· 浏览器desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
nav· 平移 / 缩放 / 滚动multi· 跨应用type· 文字与表单- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用- 提案难度
- 4 / 5
建议验证方式
xlsx rows equal reference query results (split-aware), totals exact; attachment filenames match. Firefly API tokens disabled for the user, export via UI reports permitted.
建议部分得分
50% correct rows; 20% split handling; 20% totals; 10% attachments.
R12.03.01.02-T18 Reconcile a credit card in Quicken-style app and fix a mis-categorized refund
原始指令
In the Quicken-style desktop clone (Windows), reconcile the Visa account against the October statement PDF; one refund was entered as a payment, causing a $58.40 difference. Find and correct it (as refund to the original category), then finish reconciliation.
- 平台
win· Windows- 应用
- Quicken-style clone · PDF viewer
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G3· 仅 GUI- 交互原语
click· 指向与点击vis· 视觉判断type· 文字与表单- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用- 提案难度
- 4 / 5
建议验证方式
App DB: refund transaction type=credit with category matching original purchase; reconciled flag on statement transactions; difference 0; statement end balance recorded. The agent has no PowerShell or terminal and the clone exposes no API or scripting, so its DB is not reachable for direct edits; writes by other processes are flagged by the file audit log.
建议部分得分
40% refund found and corrected; 40% reconciliation complete; 20% no other edits.
R12.03.01.02-T19 Migrate a household budget from a spreadsheet into Actual Budget
原始指令
Migrate 2026 Jan-Sep from legacy_budget.xlsx (one tab per month, inconsistent category names) into Actual Budget: map categories to the 14 Actual categories per mapping notes, import transactions per account, set monthly budgeted amounts, and verify per-month category totals match the spreadsheet.
- 平台
mac· macOSwin· Windowslin· Linux- 应用
- Actual Budget · Excel
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
AP· API 足够- 交互原语
multi· 跨应用code· 代码与命令click· 指向与点击- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用long· 长流程- 提案难度
- 5 / 5
建议验证方式
Actual DB vs reference: transaction count per account, per-month per-category actual totals exact, budgeted amounts exact; unmapped categories none.
建议部分得分
40% transactions imported; 30% category mapping (totals); 30% budgeted amounts.
R12.03.01.02-T20 Close the month across bank exports, receipts and a budget app with a variance memo
原始指令
For October: import 3 bank/card exports into Actual Budget, attach and enter 6 cash receipts, reconcile each account to its statement balance, roll over category balances, and write variance.md listing categories over budget by > 10% with amounts. All balances must reconcile to statements.
- 平台
mac· macOSwin· Windowslin· Linux- 应用
- Actual Budget · Preview · text editor
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
multi· 跨应用click· 指向与点击vis· 视觉判断- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用long· 长流程- 提案难度
- 5 / 5
建议验证方式
Actual DB: all 3 accounts reconciled to statement balances; cash receipts entered (6 rows); variance.md lists exactly the seeded 4 over-budget categories with amounts ±$0.01.
建议部分得分
30% imports; 15% cash receipts; 30% reconciliations; 25% variance memo.
已有研究映射
以下沿用研究目录中的基准与小类映射，不是逐题标注、执行记录或产品背书。