← All projects
Finance & Office / PROJECT NOTES

Invoice Ledger Pipeline

Extracts invoices from multiple folders into a consistent ledger and an ordered, readable PDF.

DeliveredFirst located record · 2026-07Archive checked · 2026-10-26
PDFOCRExcelPython
01 / THE INTENT

Reduce retyping and keep the path back from spreadsheet rows to source invoices.

02 / THE FLOW

How it works

  1. 01Read invoices
  2. 02Extract identifiers and amounts
  3. 03Validate and sort
  4. 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.