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.
| Measure | September 2025 | October 2025 |
|---|---|---|
| Bank lines | 246 | 284 |
| Bank lines matched by a rule | 244 (99.2%) | 280 (98.6%) |
| Ledger entries | 469 | 491 |
| Ledger entries matched by a rule | 423 (90.2%) | 455 (92.7%) |
| Timing items, no action | 46 | 34 |
| Items for a person to decide | 3 | 6 |
| 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.
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.
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.
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.
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.
| 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 |
| 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.
| Date | Side | Reference | Item | Effect on book | Reason | Proposed action |
|---|---|---|---|---|---|---|
| 2025-10-23 | Both | DEP677123 | Deposit: ledger 5,242.96, bank 5,422.96 | $180.00 | Amount differs between ledger and bank | Correct the posting from 5,242.96 to 5,422.96. |
| 2025-10-31 | Bank | none | Account analysis fee | ($225.62) | Bank fee not booked | Post the fee to bank charges. |
| 2025-10-31 | Bank | none | Interest credit | $337.13 | Interest not booked | Post the interest to interest income. |
| 2025-10-20 | Bank | DEP776775 | Returned customer check | ($1,250.52) | Returned customer check | Reverse the receipt and reopen the invoice; contact the customer. |
| 2025-10-10 | Ledger | CK40287 | Check, Vendor 050 | $1,643.66 | Check posted twice | Reverse the second posting. |
| 2025-10-31 | Bank | 23 settlements | Card processor fees | ($1,888.82) | Fees deducted from settlements | Post 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
| Date | Reference | Item | Amount | Reason |
|---|---|---|---|---|
| 2025-10-16 | CK40296 | Check, Vendor 090 | ($1,470.34) | Outstanding check |
| 2025-10-17 | CK40301 | Check, Vendor 089 | ($373.55) | Outstanding check |
| 2025-10-20 | CK40302 | Check, Vendor 066 | ($2,683.89) | Outstanding check |
| 2025-10-22 | CK40305 | Check, Vendor 002 | ($8,441.47) | Outstanding check |
| 2025-10-23 | CK40306 | Check, Vendor 033 | ($2,710.36) | Outstanding check |
| 2025-10-24 | CK40307 | Check, Vendor 085 | ($2,252.18) | Outstanding check |
| 2025-10-27 | CK40308 | Check, Vendor 066 | ($742.61) | Outstanding check |
| 2025-10-28 | CK40309 | Check, Vendor 044 | ($2,765.17) | Outstanding check |
| 2025-10-29 | CK40310 | Check, Vendor 007 | ($373.75) | Outstanding check |
| 2025-10-30 | CS20251030 | Card receipt, Card sales | $464.38 | Deposit in transit |
| 2025-10-30 | CS20251030 | Card receipt, Card sales | $182.84 | Deposit in transit |
| 2025-10-30 | CS20251030 | Card receipt, Card sales | $152.61 | Deposit in transit |
| 2025-10-30 | CS20251030 | Card receipt, Card sales | $212.62 | Deposit in transit |
| 2025-10-30 | CS20251030 | Card receipt, Card sales | $550.55 | Deposit in transit |
| 2025-10-30 | CK40311 | Check, Vendor 059 | ($788.90) | Outstanding check |
| 2025-10-31 | DEP943737 | Receipt, Customer 078 | $1,433.29 | Deposit in transit |
| 2025-10-31 | T7100300 | Receipt, Customer 065 | $1,964.60 | Deposit in transit |
| 2025-10-31 | DEP781329 | Receipt, Customer 122 | $4,008.17 | Deposit in transit |
| 2025-10-31 | DEP370468 | Receipt, Customer 172 | $11,483.45 | Deposit in transit |
| 2025-10-31 | DEP762039 | Receipt, Customer 014 | $1,247.30 | Deposit in transit |
| 2025-10-31 | DEP495460 | Receipt, Customer 080 | $1,695.15 | Deposit in transit |
| 2025-10-31 | T7100301 | Receipt, Customer 042 | $4,006.84 | Deposit in transit |
| 2025-10-31 | DEP779196 | Receipt, Customer 159 | $394.16 | Deposit in transit |
| 2025-10-31 | CS20251031 | Card receipt, Card sales | $214.75 | Deposit in transit |
| 2025-10-31 | CS20251031 | Card receipt, Card sales | $170.41 | Deposit in transit |
| 2025-10-31 | CS20251031 | Card receipt, Card sales | $537.38 | Deposit in transit |
| 2025-10-31 | CS20251031 | Card receipt, Card sales | $377.55 | Deposit in transit |
| 2025-10-31 | CS20251031 | Card receipt, Card sales | $173.04 | Deposit in transit |
| 2025-10-31 | CS20251031 | Card receipt, Card sales | $389.19 | Deposit in transit |
| 2025-10-31 | CS20251031 | Card receipt, Card sales | $368.68 | Deposit in transit |
| 2025-10-31 | CS20251031 | Card receipt, Card sales | $767.67 | Deposit in transit |
| 2025-10-31 | CS20251031 | Card receipt, Card sales | $235.41 | Deposit in transit |
| 2025-10-31 | CS20251031 | Card receipt, Card sales | $222.60 | Deposit in transit |
| 2025-10-31 | CK40312 | Check, 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.
| Rule | Bank line | Ledger entries | Reference | Amount |
|---|---|---|---|---|
| R1 | BK00207 | GL00358 | CK40246 | ($2,637.20) |
| R1 | BK00256 | GL00446 | CK40254 | ($622.77) |
| R1 | BK00351 | GL00605 | DEP103932 | $2,607.26 |
| R2 | BK00385 | GL00654, GL00655, GL00656 and 2 more | B1002 | ($15,155.16) |
| R2 | BK00446 | GL00753, GL00754, GL00755 and 3 more | B1009 | ($81,724.21) |
| R2 | BK00512 | GL00856, GL00857, GL00858 and 4 more | B1016 | ($22,234.72) |
| R3 | BK00347 | GL00592, GL00593, GL00594 and 7 more | CS20250929 | $3,054.89 |
| R3 | BK00361 | GL00615, GL00616, GL00617 and 1 more | CS20250930 | $2,581.49 |
| R3 | BK00371 | GL00628, GL00629, GL00630 and 6 more | CS20251001 | $3,884.41 |
| R4 | BK00421 | GL00712 | none | $23,804.42 |
| R4 | BK00422 | GL00713 | none | $13,218.26 |
| R4 | BK00480 | GL00807 | none | $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.