Taylor Tax Daily Reconciliation Engine
Custom on-demand browser extension architected and engineered for an accounting company (Taylor Tax & Co.) to automate daily multi-account banking reconciliation within QuickBooks Online across 184+ client corporations, eliminating over 70% of manual bookkeeping hours daily.
1. Operational Bottleneck: 184+ Daily Bank Feeds
Developed as a bespoke, on-demand Chrome extension for an accounting firm (Taylor Tax & Co.) managing bookkeeping across ~184 active client corporations, each holding multiple accounts (checking, operating, payroll, and credit lines). Every morning, bookkeepers spent 4–6 hours manually logging into QuickBooks, clicking through transaction registers, categorizing repetitive line items, and cross-referencing balances against bank statements.
Zero Tolerance for Hallucinations in Tax Filings
While the market rushed to put LLMs on financial data, the team explicitly architected this system using deterministic rule-based state machines. In financial audits, a 95% AI accuracy rate means 5% audited errors—a catastrophe in IRS compliance. The engine requires 100% mathematical certainty or it safely flags the item for manual human sign-off.
2. Technical Engineering Challenges
- Dual QuickBooks DOM Architectures: Intuit serves two distinct QuickBooks UI versions depending on client tier (legacy tables vs modern React/iframe portals). The extension implements an adaptive mutation observer that detects the active DOM flavor and mounts resilient query selectors.
- Two-Phase Reconciliation Pipeline: Phase 1 auto-approves verified deterministic rules (payrolls, vendor ACH, recurring subscriptions). Phase 2 executes statement balance checks between beginning and ending statement periods.
- Webhook Audit Summaries: Upon job completion, an automated webhook payload is dispatched reporting exact transaction volume processed, accounts reconciled, and an itemized queue of flagged edge cases requiring human eyes.
3. Measurable Business Outcome
Reduced daily manual bookkeeping time by over 70%, freeing senior tax accountants to focus on advisory services while providing an immutable audit trail.
