SKU Quantity Summary Automation

I have a stack of 65 supplier invoices sitting in PDF format, each listing multiple SKUs and quantities. I need those PDFs processed so that, for every unique SKU, I can see the running total quantity across all invoices. The final result should land in a clean, flat Excel / CSV file ready for upload into my inventory system. Besides the SKU and its consolidated quantity, please include the related invoice date so I can quickly trace back any discrepancies later. No other fields are required. However you choose to handle the PDFs—whether with Python, pandas, OCR, or dedicated PDF-parsing libraries—accuracy is critical. I should be able to open one spreadsheet, filter by SKU, and instantly know how many units are on hand according to supplier paperwork.

Project ID: 40201751