Pull invoice details into a table you can actually import

Opening this in Claude or ChatGPT sends the prompt with its {{PLACEHOLDERS}} still in it. Replace them with your own details before you send, or copy the prompt and fill them in first.

Extract the following fields from each invoice below: {{FIELDS}}

<invoices>
{{INVOICES}}
</invoices>

Output a table, one row per invoice, with those fields as columns in the order listed.

Rules:
- Copy values exactly as printed. Do not reformat dates, do not convert currencies, do not strip leading zeros from invoice numbers.
- If a field is missing or you cannot read it with confidence, write NOT_FOUND. Never infer a value from the others. An inferred total is worse than a blank one, because nobody checks it.
- If the same invoice appears twice, keep one row and add a DUPLICATE column.
- After the table, list any invoice where a total does not equal the sum of its lines, with both numbers. Do not correct it; flag it.

Then state how many invoices you processed and how many cells came out NOT_FOUND, so the person checking knows how much to check.

End of prompt: Pull invoice details into a table you can actually import