Client Paid $4,200 in Duplicate Expense Reimbursements First Year 🔥
Growing company. 450 expense receipts monthly. Manual processing by accounting team. Duplicate submissions happening. Policy enforcement inconsistent. Approval routing chaotic. Built automated expense tracker with duplicate detection and policy validation. THE CLIENT'S SITUATION: Finance team handling receipts via email inbox. Each receipt requiring manual extraction of merchant, date, amount. Entry into spreadsheet. Policy checking against limits. Approval routing determination. 15 minutes per receipt average. Critical problem: No duplicate detection system. Same receipt submitted multiple times gets processed multiple times. Discovery happens during monthly reconciliation. Requesting refunds from employees creates awkward situations. Year one audit revealed 37 duplicate reimbursements totaling $4,200. Same expense paid twice, sometimes three times. No systematic prevention. Policy compliance suffering. Meal expense limit: $50. One clerk approves $75 receipt. Different clerk flags identical amount as violation. Employees receiving inconsistent messages about company policy. THE AUTOMATION WORKFLOW: 13-node system using Gmail monitoring, PDF Vector document extraction, duplicate detection, policy validation, approval routing, Google Sheets database, Slack notifications, and accounting email summaries. Gmail trigger watches for "Receipt" or "Expense" emails. Downloads PDF attachments automatically. PDF Vector extracts complete receipt data - merchant, date, line items, subtotal, tax, total. Duplicate detection fingerprints each receipt. Merchant plus date plus total creates unique ID. Checks against historical database. Prevents reprocessing. Policy validation assigns categories based on merchant. Meals $50 limit, lodging $200, transportation $100, office $500, other $100. Compliance checked automatically. Approval routing based on expense amount regardless of category. Under $100 auto-approved with Slack notification only. $100-$500 routes to Tier 1 manager approval request. $500-$1,000 routes to Tier 2 senior manager. Over $1,000 requires executive approval. Appropriate person notified via Slack automatically.