Sample deliverable

Reconciliation Automation Pilot, on a synthetic company

What the pilot delivers, shown on a synthetic company's operating bank account and its general ledger cash account: September 2025 and October 2025, 530 bank lines, 4 written matching rules, and every item either matched or explained.

Both months tie to the cent, and the rules found two errors the manual reconciliation kept

The company is made up for this sample, and three items were placed in its October records on purpose: a deposit posted with two digits transposed, a vendor check posted twice, and a customer check returned unpaid. The company's own manual reconciliation, computed separately the way a clerk ticks the bank statement, agreed in September 2025. In October 2025 it booked the returned check from the statement, carried $180.00 forward as an unreconciled difference, and listed check CK40287 as outstanding a second time, where it would stay until someone asked why it never cleared. The rules name both errors and the correction for each.

MeasureSeptember 2025October 2025
Bank lines246284
Bank lines matched by a rule244 (99.2%)280 (98.6%)
Ledger entries469491
Ledger entries matched by a rule423 (90.2%)455 (92.7%)
Timing items, no action4634
Items for a person to decide36
Unreconciled difference, manual workpaper$0.00$180.00
Unreconciled difference, after the rules$0.00$0.00

Ledger entries match at a lower rate than bank lines because one bank line can carry many entries (a vendor batch, a card settlement) and because checks written near month end are still outstanding. The synthetic exports are cleaner than most real ones: every deposit carries a slip number and most credits a trace number. Exports with missing references or deposits of several checks match at lower rates, which is what the first week of a pilot measures.

The rules, as agreed before any code

A pilot starts with rules in writing. They run in this order, and every match records the rule that made it.

  1. R1. Reference and amount

    A bank line and a ledger entry with the same check number, deposit slip number or ACH trace and the same amount match, if the bank date is on or after the ledger date. If several ledger entries qualify, the earliest unmatched one is taken.

    Matches: 213 in September 2025 and 245 in October 2025, covering 245 ledger entries in October.

  2. R2. Vendor batch

    A bank debit described as an ACH vendor batch matches the ledger payments carrying the same batch number, when their sum equals the bank amount to the cent.

    Matches: 4 in September 2025 and 5 in October 2025, covering 38 ledger entries in October.

  3. R3. Card settlement, net of fees

    A card settlement deposit matches the ledger's card receipts with the same settlement reference (the sale date), when the deposit equals the receipts less the contracted 2.9% fee, within one cent per receipt. The fee goes to the review queue as a proposed entry.

    Matches: 22 in September 2025 and 23 in October 2025, covering 165 ledger entries in October.

  4. R4. Amount and date

    A bank line without a usable reference matches a ledger entry with the same amount dated no more than 4 calendar days apart, if exactly one such ledger entry exists and no other open bank line has the same amount.

    Matches: 5 in September 2025 and 7 in October 2025, covering 7 ledger entries in October.

Bank to book, both months

Amounts in parentheses reduce the balance. Each reconciling item on the book side is a single line, so the corrections can be posted from it.

September 2025, as of 2025-09-30
Balance per bank statement$465,069.49
Deposits in transit$53,222.98
Outstanding checks($63,232.28)
Adjusted bank balance$455,060.19
Balance per general ledger$456,830.18
Card processor fees deducted from settlements($1,906.42)
Bank service fee($190.79)
Interest earned$327.22
Adjusted book balance$455,060.19
October 2025, as of 2025-10-31
Balance per bank statement$452,441.79
Deposits in transit$31,252.64
Outstanding checks($25,718.79)
Adjusted bank balance$457,975.64
Balance per general ledger$459,179.81
Card processor fees deducted from settlements($1,888.82)
Deposit DEP677123 posted with two digits transposed$180.00
Bank service fee($225.62)
Interest earned$337.13
Customer check returned unpaid (DEP776775)($1,250.52)
Check CK40287 posted twice$1,643.66
Adjusted book balance$457,975.64

What a person decides in October 2025

The pilot posts nothing. It lists what needs a decision, with the evidence and a proposed action. The card processor fees, $1,888.82 across 23 settlements, are proposed as one entry.

DateSideReferenceItemEffect on bookReasonProposed action
2025-10-23BothDEP677123Deposit: ledger 5,242.96, bank 5,422.96$180.00Amount differs between ledger and bankCorrect the posting from 5,242.96 to 5,422.96.
2025-10-31BanknoneAccount analysis fee($225.62)Bank fee not bookedPost the fee to bank charges.
2025-10-31BanknoneInterest credit$337.13Interest not bookedPost the interest to interest income.
2025-10-20BankDEP776775Returned customer check($1,250.52)Returned customer checkReverse the receipt and reopen the invoice; contact the customer.
2025-10-10LedgerCK40287Check, Vendor 050$1,643.66Check posted twiceReverse the second posting.
2025-10-31Bank23 settlementsCard processor fees($1,888.82)Fees deducted from settlementsPost one entry to merchant fees.

Timing items at 2025-10-31

Deposits in transit and outstanding checks need no action. They are listed so that next month's run can confirm each one clears.

34 timing items, October 2025
DateReferenceItemAmountReason
2025-10-16CK40296Check, Vendor 090($1,470.34)Outstanding check
2025-10-17CK40301Check, Vendor 089($373.55)Outstanding check
2025-10-20CK40302Check, Vendor 066($2,683.89)Outstanding check
2025-10-22CK40305Check, Vendor 002($8,441.47)Outstanding check
2025-10-23CK40306Check, Vendor 033($2,710.36)Outstanding check
2025-10-24CK40307Check, Vendor 085($2,252.18)Outstanding check
2025-10-27CK40308Check, Vendor 066($742.61)Outstanding check
2025-10-28CK40309Check, Vendor 044($2,765.17)Outstanding check
2025-10-29CK40310Check, Vendor 007($373.75)Outstanding check
2025-10-30CS20251030Card receipt, Card sales$464.38Deposit in transit
2025-10-30CS20251030Card receipt, Card sales$182.84Deposit in transit
2025-10-30CS20251030Card receipt, Card sales$152.61Deposit in transit
2025-10-30CS20251030Card receipt, Card sales$212.62Deposit in transit
2025-10-30CS20251030Card receipt, Card sales$550.55Deposit in transit
2025-10-30CK40311Check, Vendor 059($788.90)Outstanding check
2025-10-31DEP943737Receipt, Customer 078$1,433.29Deposit in transit
2025-10-31T7100300Receipt, Customer 065$1,964.60Deposit in transit
2025-10-31DEP781329Receipt, Customer 122$4,008.17Deposit in transit
2025-10-31DEP370468Receipt, Customer 172$11,483.45Deposit in transit
2025-10-31DEP762039Receipt, Customer 014$1,247.30Deposit in transit
2025-10-31DEP495460Receipt, Customer 080$1,695.15Deposit in transit
2025-10-31T7100301Receipt, Customer 042$4,006.84Deposit in transit
2025-10-31DEP779196Receipt, Customer 159$394.16Deposit in transit
2025-10-31CS20251031Card receipt, Card sales$214.75Deposit in transit
2025-10-31CS20251031Card receipt, Card sales$170.41Deposit in transit
2025-10-31CS20251031Card receipt, Card sales$537.38Deposit in transit
2025-10-31CS20251031Card receipt, Card sales$377.55Deposit in transit
2025-10-31CS20251031Card receipt, Card sales$173.04Deposit in transit
2025-10-31CS20251031Card receipt, Card sales$389.19Deposit in transit
2025-10-31CS20251031Card receipt, Card sales$368.68Deposit in transit
2025-10-31CS20251031Card receipt, Card sales$767.67Deposit in transit
2025-10-31CS20251031Card receipt, Card sales$235.41Deposit in transit
2025-10-31CS20251031Card receipt, Card sales$222.60Deposit in transit
2025-10-31CK40312Check, Vendor 049($3,116.57)Outstanding check

Every match records its rule

The first matches of each rule in the October 2025 log. The full log lists every match with the bank lines and ledger entries it joined.

RuleBank lineLedger entriesReferenceAmount
R1BK00207GL00358CK40246($2,637.20)
R1BK00256GL00446CK40254($622.77)
R1BK00351GL00605DEP103932$2,607.26
R2BK00385GL00654, GL00655, GL00656 and 2 moreB1002($15,155.16)
R2BK00446GL00753, GL00754, GL00755 and 3 moreB1009($81,724.21)
R2BK00512GL00856, GL00857, GL00858 and 4 moreB1016($22,234.72)
R3BK00347GL00592, GL00593, GL00594 and 7 moreCS20250929$3,054.89
R3BK00361GL00615, GL00616, GL00617 and 1 moreCS20250930$2,581.49
R3BK00371GL00628, GL00629, GL00630 and 6 moreCS20251001$3,884.41
R4BK00421GL00712none$23,804.42
R4BK00422GL00713none$13,218.26
R4BK00480GL00807none$21,590.26

What this sample is and is not

  • It is a sample, not client work. The company is synthetic: 754 bank lines and 1,254 ledger entries from August to mid-November 2025, generated from a fixed seed. No real company or person is described.
  • Three items were placed on purpose: a customer check returned unpaid, a deposit posted with two digits transposed, and a vendor check posted twice. The run stops if the rules do not find all three.
  • The manual workpaper is computed by separate code, the way such workpapers are usually kept: checks ticked off by number, deposits by slip or trace number, wires by amount, fees, interest and returned items booked from the bank statement, card fees from the processor's statement, and the remainder carried forward.
  • Every bank line and ledger entry ends matched or classified; the run stops on an item it cannot classify and on a reconciliation statement that does not tie to the cent. Figures generated on 2026-11-15.
  • A client pilot runs the same way on your own exports, with the rules agreed with your team, and is compared with your own reconciliation for the same two months.

The same pilot, on your accounts.

$9,500 fixed, three weeks. Tell us which reconciliation takes the most time today.