WPEngine Deposit Bot

Overview

Reads JPMorgan wire and ACH remittance PDFs, extracts the sender, invoice number(s), and matching customer account, and produces the deposit application table the finance team used to build by hand — every day, for every incoming payment.

How it works

A deterministic rules engine, not an LLM — Groq is used only to explain a result in plain language, never to decide a match. Every non-exact resolution is flagged "needs review" with the specific reason, rather than silently guessing. Matches cross-reference 12 months of historical bank deposits, with a Tesorio open-invoices export as a fallback signal.

Highlights

• Multi-account payment splitting: when a wire's invoices belong to different customer accounts, it splits into one row per account rather than crediting the whole wire to one — deliberately leaving the dollar amount blank when invoice balances don't cleanly sum to the credited total (FX or timing noise), instead of guessing a split.
• Built to survive format drift: JPMorgan and Tesorio have each silently changed their export formats more than once. Every fix is regression-tested against all previously known-good files before shipping, so a fix for a new format can't quietly break an old one.