R14.01.01.01 · TASK CLASS

Bank & account reconciliation

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

20 project-authored proposals · taxonomy v1.1 · 0 new benchmark runs. Verifiers and partial-credit rules below are designs, not executed results.

Previous class address: R05.01.01.01 · Original proposal IDs are retained.

Typical applications: QuickBooks · Xero · Odoo Accounting
Class GUI-need label: HY · Hybrid

Digital-employee context

Project class assignments, not demonstrated employee capability or imported benchmark coverage. Acceptance criteria and value metrics are proposals; no ROI has been measured.

Related roles

Finance operations · Finance outcomes include validated supplier invoices, reconciled accounts, close entries, collections and expense decisions.

Compare all digital-employee workflow designs

Task proposals · 20

Expand to inspect the complete original wording and proposed checks. Original proposal text remains English in both interfaces.

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

Original instruction

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.

Platforms: web · Any OS (web)
Applications: QuickBooks
Interfaces: brow · Browser
GUI need · task setting: G3 · GUI-only
GUI need · ordinary access: G2 · GUI-essential
Interaction primitives: click · Point & click vis · Visual judgment
Work product: WP08 · App/system state
Conditions: licensed · Licensed pro app
Proposed difficulty: 2 / 5

Proposed verifier

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.

Proposed partial credit

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

Original instruction

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.

Platforms: web · Any OS (web)
Applications: Xero
Interfaces: brow · Browser
GUI need · task setting: G3 · GUI-only
GUI need · ordinary access: G2 · GUI-essential
Interaction primitives: click · Point & click vis · Visual judgment
Work product: WP08 · App/system state
Conditions: licensed · Licensed pro app
Proposed difficulty: 2 / 5

Proposed verifier

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.

Proposed partial credit

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

Original instruction

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'.

Platforms: web · Any OS (web)
Applications: Odoo Accounting
Interfaces: brow · Browser
GUI need · task setting: HY · Hybrid
GUI need · ordinary access: G2 · GUI-essential
Interaction primitives: click · Point & click type · Text & forms
Work product: WP08 · App/system state
Conditions: None declared
Proposed difficulty: 3 / 5

Proposed verifier

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.

Proposed partial credit

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

Original instruction

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.

Platforms: web · Any OS (web)
Applications: QuickBooks
Interfaces: brow · Browser
GUI need · task setting: G3 · GUI-only
GUI need · ordinary access: G2 · GUI-essential
Interaction primitives: click · Point & click type · Text & forms
Work product: WP08 · App/system state
Conditions: licensed · Licensed pro app
Proposed difficulty: 3 / 5

Proposed verifier

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.

Proposed partial credit

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

Original instruction

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'.

Platforms: web · Any OS (web)
Applications: Xero
Interfaces: brow · Browser
GUI need · task setting: G3 · GUI-only
GUI need · ordinary access: G2 · GUI-essential
Interaction primitives: click · Point & click type · Text & forms
Work product: WP08 · App/system state
Conditions: licensed · Licensed pro app
Proposed difficulty: 3 / 5

Proposed verifier

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.

Proposed partial credit

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

Original instruction

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.

Platforms: web · Any OS (web)
Applications: Odoo Accounting
Interfaces: brow · Browser
GUI need · task setting: HY · Hybrid
GUI need · ordinary access: G2 · GUI-essential
Interaction primitives: click · Point & click type · Text & forms
Work product: WP08 · App/system state
Conditions: None declared
Proposed difficulty: 3 / 5

Proposed verifier

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.

Proposed partial credit

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

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

Original instruction

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.

Platforms: win · Windows
Applications: QuickBooks
Interfaces: desk · Desktop GUI
GUI need · task setting: G3 · GUI-only
GUI need · ordinary access: G2 · GUI-essential
Interaction primitives: click · Point & click nav · Pan/zoom/scroll type · Text & forms
Work product: WP08 · App/system state
Conditions: licensed · Licensed pro app hidden · Hidden/stale state
Proposed difficulty: 3 / 5

Proposed verifier

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.

Proposed partial credit

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

R05.01.01.01-T08 Recode misallocated reconciled transactions in Xero

Original instruction

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.

Platforms: web · Any OS (web)
Applications: Xero
Interfaces: brow · Browser
GUI need · task setting: G3 · GUI-only
GUI need · ordinary access: G2 · GUI-essential
Interaction primitives: click · Point & click type · Text & forms
Work product: WP08 · App/system state
Conditions: licensed · Licensed pro app
Proposed difficulty: 3 / 5

Proposed verifier

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.

Proposed partial credit

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

Original instruction

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.

Platforms: web · Any OS (web) mac · macOS win · Windows
Applications: Odoo Accounting · Excel
Interfaces: brow · Browser desk · Desktop GUI
GUI need · task setting: HY · Hybrid
GUI need · ordinary access: G2 · GUI-essential
Interaction primitives: click · Point & click multi · Cross-app type · Text & forms
Work product: WP08 · App/system state
Conditions: multiapp · Multi-app
Proposed difficulty: 3 / 5

Proposed verifier

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.

Proposed partial credit

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

Original instruction

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.

Platforms: web · Any OS (web)
Applications: QuickBooks
Interfaces: brow · Browser
GUI need · task setting: G3 · GUI-only
GUI need · ordinary access: G2 · GUI-essential
Interaction primitives: click · Point & click vis · Visual judgment nav · Pan/zoom/scroll
Work product: WP08 · App/system state
Conditions: licensed · Licensed pro app risk · Irreversible/risky
Proposed difficulty: 4 / 5

Proposed verifier

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.

Proposed partial credit

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

Original instruction

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.

Platforms: web · Any OS (web)
Applications: Xero
Interfaces: brow · Browser
GUI need · task setting: G3 · GUI-only
GUI need · ordinary access: G2 · GUI-essential
Interaction primitives: click · Point & click vis · Visual judgment
Work product: WP08 · App/system state
Conditions: licensed · Licensed pro app
Proposed difficulty: 3 / 5

Proposed verifier

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.

Proposed partial credit

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

Original instruction

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.

Platforms: web · Any OS (web)
Applications: Odoo Accounting
Interfaces: brow · Browser
GUI need · task setting: HY · Hybrid
GUI need · ordinary access: G2 · GUI-essential
Interaction primitives: click · Point & click type · Text & forms
Work product: WP08 · App/system state
Conditions: long · Long-horizon
Proposed difficulty: 4 / 5

Proposed verifier

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.

Proposed partial credit

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

Original instruction

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.

Platforms: web · Any OS (web) mac · macOS win · Windows
Applications: QuickBooks · Excel
Interfaces: brow · Browser desk · Desktop GUI
GUI need · task setting: HY · Hybrid
GUI need · ordinary access: G2 · GUI-essential
Interaction primitives: multi · Cross-app type · Text & forms click · Point & click
Work product: WP02 · Records/table
Conditions: multiapp · Multi-app licensed · Licensed pro app
Proposed difficulty: 4 / 5

Proposed verifier

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.

Proposed partial credit

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

Original instruction

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.

Platforms: web · Any OS (web)
Applications: Xero
Interfaces: brow · Browser
GUI need · task setting: G3 · GUI-only
GUI need · ordinary access: G2 · GUI-essential
Interaction primitives: click · Point & click vis · Visual judgment nav · Pan/zoom/scroll
Work product: WP08 · App/system state
Conditions: licensed · Licensed pro app long · Long-horizon risk · Irreversible/risky
Proposed difficulty: 5 / 5

Proposed verifier

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.

Proposed partial credit

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

Original instruction

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.

Platforms: web · Any OS (web)
Applications: Odoo Accounting
Interfaces: brow · Browser
GUI need · task setting: HY · Hybrid
GUI need · ordinary access: G2 · GUI-essential
Interaction primitives: click · Point & click type · Text & forms nav · Pan/zoom/scroll
Work product: WP08 · App/system state
Conditions: long · Long-horizon hidden · Hidden/stale state
Proposed difficulty: 5 / 5

Proposed verifier

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.

Proposed partial credit

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

Original instruction

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.

Platforms: web · Any OS (web)
Applications: QuickBooks
Interfaces: brow · Browser
GUI need · task setting: G3 · GUI-only
GUI need · ordinary access: G2 · GUI-essential
Interaction primitives: click · Point & click nav · Pan/zoom/scroll vis · Visual judgment
Work product: WP12 · Answer/decision
Conditions: licensed · Licensed pro app hidden · Hidden/stale state
Proposed difficulty: 5 / 5

Proposed verifier

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.

Proposed partial credit

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

Original instruction

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.

Platforms: mac · macOS win · Windows lin · Linux
Applications: pandas · openpyxl
Interfaces: term · Terminal
GUI need · task setting: CL · CLI-sufficient
GUI need · ordinary access: CL · CLI-sufficient
Interaction primitives: code · Code & commands
Work product: WP02 · Records/table
Conditions: None declared
Proposed difficulty: 2 / 5

Proposed verifier

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

Proposed partial credit

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

Original instruction

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.

Platforms: web · Any OS (web)
Applications: Odoo Accounting · browsers
Interfaces: brow · Browser
GUI need · task setting: HY · Hybrid
GUI need · ordinary access: G2 · GUI-essential
Interaction primitives: click · Point & click nav · Pan/zoom/scroll multi · Cross-app
Work product: WP08 · App/system state
Conditions: multiapp · Multi-app hidden · Hidden/stale state
Proposed difficulty: 4 / 5

Proposed verifier

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.

Proposed partial credit

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

Original instruction

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.

Platforms: ios · iOS/iPadOS
Applications: Xero
Interfaces: mob · Mobile touch
GUI need · task setting: G3 · GUI-only
GUI need · ordinary access: G3 · GUI-only
Interaction primitives: touch · Touch gestures vis · Visual judgment
Work product: WP08 · App/system state
Conditions: licensed · Licensed pro app
Proposed difficulty: 3 / 5

Proposed verifier

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.

Proposed partial credit

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

Original instruction

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.

Platforms: web · Any OS (web) mac · macOS win · Windows
Applications: QuickBooks · Excel
Interfaces: brow · Browser desk · Desktop GUI
GUI need · task setting: HY · Hybrid
GUI need · ordinary access: G2 · GUI-essential
Interaction primitives: click · Point & click type · Text & forms multi · Cross-app
Work product: WP08 · App/system state
Conditions: licensed · Licensed pro app multiapp · Multi-app
Proposed difficulty: 4 / 5

Proposed verifier

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.

Proposed partial credit

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

Mapped research references

No benchmark reference is assigned to this class in the current mapping.

In this workflow family

R14.01.01.02 Journal entries & period close