Discussion about this post

User's avatar
Michael Beatty's avatar

First substack I've ever subscribed to, thanks for sharing! Not agent-based, just Claude + project context files, but figuring it might still count: built a VBA system that turns CTV ad revenue reports into accounting journal entries for a media company (previous job) - roughly 100K+ rows/month. It's config-driven across six modules: a dashboard for triggering runs, contra rate logic (multiple partner tiers, with CPM variants for certain distribution types), partner exclusion rules, revenue-split handling, automatic exception flagging with sane defaults, plus reconciliation and AR summary reporting. No agents, just worked through the actual finance logic module by module with Claude. Saved our little team days during the close cycle.

At my new company: Finance Manager who taught myself into an Epicor admin role, and I built a VBA matching engine that automates AR remittance reconciliation (6-pass matching: pack slip, splits, combos, exceptions) against our ERP. Validated at ~97% vs. our manual process. Extended it to auto-post cash receipts via Epicor's REST API, which required reverse-engineering the call sequence from HAR captures. Did this within a a couple weeks of starting the position. Saves our AR person hours

Sean Pfarr's avatar

I feel like this is a constant battle - verifying the outputs and, (subtly hidden in this) making sure the AI is not taking too large of bites.

Great article, super insightful!

No posts

Ready for more?