← Back to Apps

📦 UPS Bill Parser & Archive

Select a bill from the sidebar to view details

📋 Complete Archive Table

Date	PDF	Excel	Total	Shipments	Status
No bills yet

📤 Upload New Bill

Weekly workflow: Upload PDF → Process → Review Excel

📁 Drag & drop or click to select UPS PDF Filename format: M_D_YY_$amount.pdf

📋 Weekly Workflow

Upload UPS PDF bill (format: M_D_YY_$amount.pdf)
Process → Click "Process" button to extract data
Verify → Check that Excel shows $0.00 Difference
Download → Save organized 5-tab spreadsheet

💬 Training & Notes

Document parser behavior, edge cases, and improvements

📚 Parser Reference

Total-line-based approach: Searches backward from "Total" lines to find metadata
PO Range: 123,000 - 130,000
Order Range: 320,000 - 350,000
Target: $0.00 difference between parsed total and invoice total
Output: 5-tab Excel with formatted headers and formulas