Upload invoices via form and extract, validate, dedupe, and log to ledger

### Upload a batch of invoices, keep the new ones, answer the person who uploaded them This is a small but complete intake: read the PDFs, check the fields, skip what is already in the ledger, store the rest in an n8n Data table, and return a summary. No AI model, no API key, no credential. ### What it does - *Invoice Upload Form* takes one or many PDFs in one submission. - *Set Ledger Options* holds the three settings you are most likely to change. - *Create Ledger Table If Missing* creates the Invoice Ledger table once; on later runs the existing table is reused, so no data is lost. - *Read Existing Ledger Rows* loads what is already stored (empty on the first run). - *Split Uploaded Files* turns one upload with five PDFs into five invoices; the PDFs are read from the form node, because the table nodes in between return rows, not files. - *Extract Text From PDF* reads the text layer. A scan or a photo has none — that is reported, never silently dropped. - *Parse And Classify* finds supplier, invoice number, dates, currency, net, VAT and total, then labels each file: new, duplicate (same supplier + number, same content, or the same invoice twice in this upload) or needs review (a missing field, totals that do not add up, or a possible duplicate). - *Has New Invoices?* splits the batch: only new rows reach the table. - *Add New Rows To Ledger* writes those rows with an explicit column mapping. - *Write Summary* counts what happened and compares the number stored with the number that looked new — a silent write failure shows up in the answer instead of passing. - *Show The Summary* is the form's last page: n8n ends the form there and shows that summary instead of a bare 'submitted' screen. ### Setup (5 steps, one minute) 1. Click Test workflow so n8n shows the form URL. 2. Open that URL and upload one or more PDF invoices. 3. Read the summary the form shows on its last page. 4. When you are happy, Activate the workflow and share the production form URL. 5. Want a different table or column set? Edit *Create Ledger Table If Missing* and the matching *Add New Rows To Ledger* mapping (the table name is Invoice Ledger). ### How to customize - dateOrder (auto, dmy, mdy), defaultCurrency and nearDuplicateWindowDays live in *Set Ledger Options*. - nearDuplicateWindowDays is how close two invoices from the same supplier with the same amount must be before the second o