Finance & Office / PROJECT NOTES
Invoice Ledger Pipeline
Extracts invoices from multiple folders into a consistent ledger and an ordered, readable PDF.
PDFOCRExcelPython
01 / THE INTENT
Reduce retyping and keep the path back from spreadsheet rows to source invoices.
02 / THE FLOW
How it works
- 01Read invoices
- 02Extract identifiers and amounts
- 03Validate and sort
- 04Export Excel and PDF
03 / THE WORK
What exists
01
Batch processing across folders
02
Four-column ledger and amount checks
03
Merged PDF with source tracking
04 / CURRENT POSITION
Where the project stands
Document outputs exist for several batches; only the workflow is presented publicly.
AI-assisted English translation of the Chinese project record.