Extract fields from a batch of invoice PDFs
Every invoice's key fields captured into your template, with iffy ones flagged
Here's a batch of invoice PDFs: [links to the PDFs or the folder]. Open each one and extract into my template sheet [sheet link]: vendor name, invoice number, invoice date, due date, line-item total, tax, grand total, currency, and payment terms. One row per invoice, formatted to match the template's existing columns exactly — dates as YYYY-MM-DD, amounts as plain numbers. Accuracy beats speed: if a field is unreadable, missing, or ambiguous (like two dates that could each be the due date), enter REVIEW with a short note rather than guessing. Cross-check that line items plus tax equal the grand total, and flag any mismatches. When done, give me the tally: processed, clean, flagged for review.