R14.01.01.01 · 任务小类

银行与科目对账

Bank & account reconciliation

Match statements to ledger entries and resolve differences in accounting software.

20 条本项目编写的提案 · 分类 v1.1 · 新增基准运行 0 次。下方验证方式与部分得分规则是设计，不是执行结果。

历史小类地址：R05.01.01.01 · 提案 ID 保留原值。

典型应用: QuickBooks · Xero · Odoo Accounting
小类 GUI 需求标签: HY · 混合

数字员工关联

本项目的小类归属，不代表员工能力实证或已导入基准覆盖。验收与价值指标均为建议，未测量 ROI。

关联岗位

财务运营 · 财务结果包括已校验供应商发票、科目对账、结账凭证、收款记录及费用审核决定。

对照全部数字员工工作流设计

任务提案 · 20

展开查看完整原文与建议检查方式；两种界面均保留提案英文原文。

R05.01.01.01-T01 Reconcile a checking account for September in QuickBooks Online

原始指令

In the QuickBooks Online sandbox company, reconcile 'Business Checking' for the statement ending 2026-09-30 using input/sept_statement.pdf (ending balance $48,213.07). Tick exactly the transactions on the statement so the difference is $0.00, and finish the reconciliation.

平台: web · 任意系统（网页）
应用: QuickBooks
交互表面: brow · 浏览器
GUI 需求 · 任务设定: G3 · 仅 GUI
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 vis · 视觉判断
工作产物: WP08 · 应用 / 系统状态
条件: licensed · 授权专业软件
提案难度: 2 / 5

建议验证方式

Grader reads the sandbox via API (read-only) and the reconciliation report: a completed reconciliation dated 2026-09-30 with ending balance equal statement; cleared set equals key (statement lines); no transactions edited. Agent has no API credentials, and the QBO API has no reconcile endpoint.

建议部分得分

20% statement date/balance; 60% cleared set exact (pro-rata); 20% finished with $0 difference.

R05.01.01.01-T02 Match fifteen bank lines to open invoices and bills in Xero

原始指令

In the Xero demo company, on the 'Business Bank Account' Reconcile tab, match the 15 statement lines dated 1–10 Oct 2026 to their existing invoices, bills or transfers (use Find & Match where Xero suggests nothing), creating nothing new. Leave other lines unreconciled.

平台: web · 任意系统（网页）
应用: Xero
交互表面: brow · 浏览器
GUI 需求 · 任务设定: G3 · 仅 GUI
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 vis · 视觉判断
工作产物: WP08 · 应用 / 系统状态
条件: licensed · 授权专业软件
提案难度: 2 / 5

建议验证方式

Xero API (read-only): the 15 statement lines are reconciled and linked to the key's invoice/bill/transfer ids; no new spend/receive money transactions; other lines unreconciled. Agent has no API credentials, and Xero's API cannot reconcile statement lines.

建议部分得分

75% lines matched correctly (pro-rata over 15); 15% nothing new created; 10% other lines untouched.

R05.01.01.01-T03 Import a CAMT statement into Odoo and reconcile forty lines

原始指令

In the Odoo Accounting sandbox, import input/oct_statement.camt.053.xml into journal 'Bank', then reconcile all 40 lines: match customer payments to invoices by reference, vendor payments to bills, and post bank fees to account 626000 via a reconciliation model 'Bank fees'.

平台: web · 任意系统（网页）
应用: Odoo Accounting
交互表面: brow · 浏览器
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 type · 文字与表单
工作产物: WP08 · 应用 / 系统状态
条件: 未声明
提案难度: 3 / 5

建议验证方式

Odoo DB: statement with 40 lines, all is_reconciled; each line's counterpart matches key (invoice/bill ids or fee account); reconciliation model 'Bank fees' exists and was used; statement ending balance equals file.

建议部分得分

15% import; 60% lines reconciled correctly (pro-rata over 40); 15% fee model; 10% balance matches.

R05.01.01.01-T04 Create bank rules that categorize recurring feed transactions

原始指令

In the QuickBooks Online sandbox, create 4 bank rules per input/rules_spec.md (e.g. descriptions containing 'AWS' → Software expense, vendor Amazon Web Services) for 'Business Checking', apply them to the 60 transactions in For Review, and add the matched ones; leave non-matching ones for review.

平台: web · 任意系统（网页）
应用: QuickBooks
交互表面: brow · 浏览器
GUI 需求 · 任务设定: G3 · 仅 GUI
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 type · 文字与表单
工作产物: WP08 · 应用 / 系统状态
条件: licensed · 授权专业软件
提案难度: 3 / 5

建议验证方式

Grader Playwright reads the rules page (rules are not in the API): 4 rules with conditions/actions per spec; API read: the 38 rule-matched transactions added with correct accounts/payees; 22 remain in For Review. Agent has no API credentials, and the API lacks reconcile/rule endpoints anyway.

建议部分得分

40% four rules correct; 40% matched transactions categorized; 20% others untouched.

R05.01.01.01-T05 Reconcile a net deposit covering three invoices and a processor fee

原始指令

In the Xero demo company, a single deposit of $4,712.30 on 2026-10-06 pays invoices INV-0412, INV-0415 and INV-0419 net of a $87.70 card fee. Reconcile it in one match: select the 3 invoices and add an adjustment line coding the fee to 'Bank Fees'.

平台: web · 任意系统（网页）
应用: Xero
交互表面: brow · 浏览器
GUI 需求 · 任务设定: G3 · 仅 GUI
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 type · 文字与表单
工作产物: WP08 · 应用 / 系统状态
条件: licensed · 授权专业软件
提案难度: 3 / 5

建议验证方式

Xero API read: the statement line reconciled; 3 invoices fully paid by payments dated 2026-10-06; a bank-fee adjustment of 87.70 to Bank Fees; no other changes. Agent has no API credentials, and the API lacks reconcile/rule endpoints anyway.

建议部分得分

45% invoices paid by this deposit; 35% fee adjustment; 20% statement line reconciled once.

R05.01.01.01-T06 Reconcile a foreign-currency credit card account with FX differences

原始指令

In the Odoo sandbox (multi-currency on), reconcile the September statement of the EUR-denominated card journal 'Amex EUR' against vendor bills in USD and GBP. Use the bill amounts in their currency; the exchange difference must post automatically to the FX gain/loss accounts. 28 lines.

平台: web · 任意系统（网页）
应用: Odoo Accounting
交互表面: brow · 浏览器
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 type · 文字与表单
工作产物: WP08 · 应用 / 系统状态
条件: 未声明
提案难度: 3 / 5

建议验证方式

Odoo DB: 28 lines reconciled to key bills; exchange difference journal entries exist with amounts equal key (±0.01 EUR); no manual FX journal entries; bills marked paid.

建议部分得分

55% lines matched; 30% FX differences correct; 15% bills paid status.

R05.01.01.01-T07 Investigate a reconciliation discrepancy report in QuickBooks Desktop

原始指令

In QuickBooks Desktop (sandbox company file), the August reconciliation of 'Operating Account' no longer ties: run the Reconciliation Discrepancy report, find the 2 cleared transactions changed after reconciling, restore their original amounts per input/aug_statement.pdf, and write the 2 transaction numbers to output/discrepancy.txt.

平台: win · Windows
应用: QuickBooks
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G3 · 仅 GUI
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 nav · 平移 / 缩放 / 滚动 type · 文字与表单
工作产物: WP08 · 应用 / 系统状态
条件: licensed · 授权专业软件 hidden · 隐藏 / 过期状态
提案难度: 3 / 5

建议验证方式

Company file read via grader's SDK session: the 2 transactions restored to statement amounts; discrepancy report empty; beginning balance for September equals August statement ending; discrepancy.txt lists the right numbers. The agent VM has no QBXML/QBFC SDK access (no integrated-app authorization) or scripting host, so fixes must be made in QuickBooks.

建议部分得分

40% two transactions identified; 40% restored; 20% discrepancy cleared.

R05.01.01.01-T08 Recode misallocated reconciled transactions in Xero

原始指令

In the Xero demo company, 9 reconciled 'Spend Money' transactions in September were coded to 'General Expenses' but belong to accounts listed in input/recode.csv. Recode them (keep them reconciled), then reconcile the remaining 6 September statement lines by creating spend money transactions with the right accounts and tax rates.

平台: web · 任意系统（网页）
应用: Xero
交互表面: brow · 浏览器
GUI 需求 · 任务设定: G3 · 仅 GUI
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 type · 文字与表单
工作产物: WP08 · 应用 / 系统状态
条件: licensed · 授权专业软件
提案难度: 3 / 5

建议验证方式

Xero API: the 9 transactions' line accounts equal CSV and still reconciled; 6 new spend money transactions reconciled to the right lines with accounts/tax equal key; no unreconciled September lines remain. Agent has no API credentials, and the API lacks reconcile/rule endpoints anyway.

建议部分得分

50% recodes; 40% six new transactions; 10% September fully reconciled.

R05.01.01.01-T09 Reconcile card-processor payouts to gross sales and fees in Odoo

原始指令

In the Odoo sandbox, the bank shows 12 Stripe-style payouts (net). Using input/payout_report.csv (gross charges, refunds, fees per payout), reconcile each payout against the clearing account 'Stripe Clearing' so customer invoices are paid gross and fees post to 'Payment Processing Fees'. Clearing balance must end at zero.

平台: web · 任意系统（网页） mac · macOS win · Windows
应用: Odoo Accounting · Excel
交互表面: brow · 浏览器 desk · 桌面 GUI
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 multi · 跨应用 type · 文字与表单
工作产物: WP08 · 应用 / 系统状态
条件: multiapp · 多应用
提案难度: 3 / 5

建议验证方式

Odoo DB: 12 bank lines reconciled; clearing account balance 0.00 after the period; fees and refunds posted with amounts equal payout report totals; invoices in payouts marked paid.

建议部分得分

40% payouts reconciled; 25% fees posted; 15% refunds; 20% clearing at zero.

R05.01.01.01-T10 Undo a wrong reconciliation and redo two months correctly in QBO

原始指令

In the QuickBooks Online sandbox (accountant user), the August reconciliation of 'Savings' was finished with a $312.40 adjustment. Undo the August and September reconciliations, then reconcile August and September again against input/savings_aug.pdf and input/savings_sep.pdf with no adjustments.

平台: web · 任意系统（网页）
应用: QuickBooks
交互表面: brow · 浏览器
GUI 需求 · 任务设定: G3 · 仅 GUI
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 vis · 视觉判断 nav · 平移 / 缩放 / 滚动
工作产物: WP08 · 应用 / 系统状态
条件: licensed · 授权专业软件 risk · 高风险 / 不可逆
提案难度: 4 / 5

建议验证方式

Reconciliation history: August and September completed with $0 difference and no reconciliation-discrepancy adjustment entry; the old adjustment journal deleted/voided; cleared sets equal statements. Undo is accountant-only and irreversible, so run only on the sandbox. Agent has no API credentials, and the API lacks reconcile/rule endpoints anyway.

建议部分得分

20% undo done correctly; 35% August redone; 35% September redone; 10% adjustment removed.

R05.01.01.01-T11 Reconcile three accounts with transfers matched on both sides

原始指令

In the Xero demo company, reconcile October 1–15 for 'Business Bank', 'Savings' and 'Credit Card'. Five transfers between them appear on both statements: reconcile each as a single Xero transfer matched on both accounts, not as separate spend/receive transactions.

平台: web · 任意系统（网页）
应用: Xero
交互表面: brow · 浏览器
GUI 需求 · 任务设定: G3 · 仅 GUI
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 vis · 视觉判断
工作产物: WP08 · 应用 / 系统状态
条件: licensed · 授权专业软件
提案难度: 3 / 5

建议验证方式

Xero API: all statement lines in range reconciled for the 3 accounts; 5 bank transfers each linked to both statement lines; no spend/receive money transactions representing transfers. Agent has no API credentials, and the API lacks reconcile/rule endpoints anyway.

建议部分得分

45% transfers matched both sides; 40% other lines reconciled; 15% no duplicate transactions.

R05.01.01.01-T12 Clear partial payments and small write-offs with a reconciliation model

原始指令

In the Odoo sandbox, 80 bank lines include partial payments and underpayments of up to $1.00. Create a reconciliation model that writes off differences ≤ $1.00 to 'Cash Discount Loss', then reconcile all 80: partial payments leave invoices partially paid, small differences are written off.

平台: web · 任意系统（网页）
应用: Odoo Accounting
交互表面: brow · 浏览器
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 type · 文字与表单
工作产物: WP08 · 应用 / 系统状态
条件: long · 长流程
提案难度: 4 / 5

建议验证方式

Odoo DB: model with amount tolerance 1.00 to the right account; 80 lines reconciled; invoice residuals equal key (partials); write-off moves only where |diff| ≤ 1.00 and amounts exact.

建议部分得分

20% model; 50% lines reconciled correctly; 15% partial residuals; 15% write-offs.

R05.01.01.01-T13 Build a bank reconciliation workpaper that ties to the QBO report

原始指令

Export the September 'Business Checking' register and reconciliation report from the QuickBooks Online sandbox, then complete input/bank_rec_workpaper.xlsx: book balance, outstanding checks, deposits in transit, bank errors, adjusted balances that tie, with each item referenced to transaction numbers.

平台: web · 任意系统（网页） mac · macOS win · Windows
应用: QuickBooks · Excel
交互表面: brow · 浏览器 desk · 桌面 GUI
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: multi · 跨应用 type · 文字与表单 click · 指向与点击
工作产物: WP02 · 记录 / 表格
条件: multiapp · 多应用 licensed · 授权专业软件
提案难度: 4 / 5

建议验证方式

Workpaper: outstanding checks and deposits in transit sets equal key (by transaction no.); adjusted bank = adjusted book to the cent; balances equal QBO report; formulas (not constants) for totals.

建议部分得分

15% exports; 30% outstanding checks; 25% deposits in transit; 30% tie-out with formulas.

R05.01.01.01-T14 Clean up a year of unreconciled Xero bank lines including duplicates

原始指令

In the Xero demo company, 'Business Bank' has 230 unreconciled lines from Nov 2025–Oct 2026, including a duplicated March import. Delete the 41 duplicate statement lines, then reconcile the rest by matching existing transactions, creating spend/receive money per input/coding_guide.md, and recording transfers.

平台: web · 任意系统（网页）
应用: Xero
交互表面: brow · 浏览器
GUI 需求 · 任务设定: G3 · 仅 GUI
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 vis · 视觉判断 nav · 平移 / 缩放 / 滚动
工作产物: WP08 · 应用 / 系统状态
条件: licensed · 授权专业软件 long · 长流程 risk · 高风险 / 不可逆
提案难度: 5 / 5

建议验证方式

Xero API: 0 unreconciled lines; the 41 deleted lines are exactly the duplicates (no genuine lines deleted); created transactions coded per guide (account accuracy ≥95%); Xero statement balance equals bank balance. Agent has no API credentials, and the API lacks reconcile/rule endpoints anyway.

建议部分得分

25% duplicates removed exactly; 35% matches; 25% new transactions coded; 15% balances agree.

R05.01.01.01-T15 Repair overlapping statement imports and reconcile 150 lines in Odoo

原始指令

In the Odoo sandbox, journal 'Bank 2' had three statements imported with overlapping dates and a wrong opening balance, so balances don't chain. Remove overlapping lines, fix statement start/end balances to input/bank2_statements/, and reconcile all 150 remaining lines.

平台: web · 任意系统（网页）
应用: Odoo Accounting
交互表面: brow · 浏览器
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 type · 文字与表单 nav · 平移 / 缩放 / 滚动
工作产物: WP08 · 应用 / 系统状态
条件: long · 长流程 hidden · 隐藏 / 过期状态
提案难度: 5 / 5

建议验证方式

Odoo DB: statement balances chain (each start = previous end) and equal the PDFs; no duplicated lines (by date/amount/ref); 150 lines reconciled to key counterparts; journal balance equals bank.

建议部分得分

25% overlaps removed; 20% balances fixed; 45% lines reconciled; 10% journal ties.

R05.01.01.01-T16 Trace and fix a $1,247.50 reconciliation difference in QBO

原始指令

In the QuickBooks Online sandbox, the October reconciliation of 'Merchant Account' is off by $1,247.50. Find the causes (a duplicated deposit and an unrecorded bank fee are seeded among 140 transactions), fix them in the books, finish the reconciliation at $0.00, and write the causes with transaction ids in output/causes.txt.

平台: web · 任意系统（网页）
应用: QuickBooks
交互表面: brow · 浏览器
GUI 需求 · 任务设定: G3 · 仅 GUI
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 nav · 平移 / 缩放 / 滚动 vis · 视觉判断
工作产物: WP12 · 答案 / 决策
条件: licensed · 授权专业软件 hidden · 隐藏 / 过期状态
提案难度: 5 / 5

建议验证方式

API read: duplicate deposit deleted/voided, bank fee recorded with correct account/amount; reconciliation completed with $0 difference; causes.txt names both seeded transactions (ids) and amounts. Agent has no API credentials, and the API lacks reconcile/rule endpoints anyway.

建议部分得分

35% causes identified; 35% books fixed; 20% reconciliation completed; 10% causes file.

R05.01.01.01-T17 Control pair of T13: compute the reconciliation workpaper from CSV exports

原始指令

Control pair of T13. Given the QBO register and statement already exported as input/register_sep.csv and input/statement_sep.csv, compute outstanding checks, deposits in transit and adjusted balances with pandas from the terminal and write output/bank_rec_cli.xlsx in the workpaper layout.

平台: mac · macOS win · Windows lin · Linux
应用: pandas · openpyxl
交互表面: term · 终端
GUI 需求 · 任务设定: CL · CLI 足够
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: code · 代码与命令
工作产物: WP02 · 记录 / 表格
条件: 未声明
提案难度: 2 / 5

建议验证方式

Same item sets and tie-out as T13; isolates the analysis from the GUI export/reconcile steps.

建议部分得分

35% outstanding checks; 30% deposits in transit; 35% tie-out.

R05.01.01.01-T18 Download OFX from a bank portal, import to Odoo and reconcile

原始指令

From the sandbox bank portal (test login), download the October 1–15 OFX for account 'Ops 2291', import it into Odoo journal 'Ops Bank' without duplicating lines already imported up to Oct 7, and reconcile the new lines against open invoices and bills.

平台: web · 任意系统（网页）
应用: Odoo Accounting · browsers
交互表面: brow · 浏览器
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 nav · 平移 / 缩放 / 滚动 multi · 跨应用
工作产物: WP08 · 应用 / 系统状态
条件: multiapp · 多应用 hidden · 隐藏 / 过期状态
提案难度: 4 / 5

建议验证方式

Odoo DB: lines for Oct 8–15 present once (no duplicates of Oct 1–7, matched by FITID); all new lines reconciled to key counterparts; statement ending balance equals OFX ledger balance.

建议部分得分

20% correct OFX download; 30% import without duplicates; 40% reconciliation; 10% balance.

R05.01.01.01-T19 Reconcile suggested matches by swiping in the Xero mobile app

原始指令

On iPhone with the Xero app (demo company), reconcile the 10 'Business Bank' lines that have suggested matches by confirming correct suggestions, and for the 2 lines with wrong suggestions leave them unreconciled and add a comment 'check – wrong match' instead.

平台: ios · iOS/iPadOS
应用: Xero
交互表面: mob · 移动触控
GUI 需求 · 任务设定: G3 · 仅 GUI
GUI 需求 · 普通权限: G3 · 仅 GUI
交互原语: touch · 触控手势 vis · 视觉判断
工作产物: WP08 · 应用 / 系统状态
条件: licensed · 授权专业软件
提案难度: 3 / 5

建议验证方式

Xero API read: the 8 correct suggestions reconciled to the suggested transactions; the 2 bad-suggestion lines unreconciled; comments not exposed by API are checked via grader Playwright on the web UI. Agent has no Xero API credentials, so matches are confirmed only in the app.

建议部分得分

60% correct suggestions confirmed (pro-rata over 8); 25% wrong ones left unreconciled; 15% comments.

R05.01.01.01-T20 Reconcile a loan account by splitting payments into principal and interest

原始指令

In the QuickBooks Online sandbox, monthly loan payments for 'Equipment Loan' were all posted to the liability. Using input/amortization.xlsx, correct each of the 9 payments in 2026 to split principal and interest (to 'Interest Expense'), then reconcile the loan account to the lender statement input/loan_stmt_sep.pdf.

平台: web · 任意系统（网页） mac · macOS win · Windows
应用: QuickBooks · Excel
交互表面: brow · 浏览器 desk · 桌面 GUI
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 type · 文字与表单 multi · 跨应用
工作产物: WP08 · 应用 / 系统状态
条件: licensed · 授权专业软件 multiapp · 多应用
提案难度: 4 / 5

建议验证方式

API read: 9 payments with principal/interest splits equal amortization schedule (to the cent); loan balance at 2026-09-30 equals lender statement; reconciliation completed with $0 difference.

建议部分得分

55% payments split correctly (≈6.1% each); 25% balance matches lender; 20% reconciliation completed.

已有研究映射

当前映射未给此小类指定基准参考。

同工作流族的小类

R14.01.01.02 凭证与期末结账