Facturas a hoja de cálculo

=== FILE: inv-2026-0412.txt ===
INVOICE No. A-0412
Supplier: Nordlicht Print GmbH
Date: 2026-03-04
Business cards, 500 pcs ........ 84.00 EUR
Flyers A5, 1000 pcs ............ 126.50 EUR
Net: 210.50 EUR
VAT 21%: 44.21 EUR
Total due: 254.71 EUR

=== FILE: inv-2026-0413.txt ===
INVOICE No. 7781
Supplier: Brisa Cloud Hosting SL
Date: 2026-03-09
Hosting plan, March ............ 39.00 EUR
Extra storage 100 GB ........... 12.00 EUR
Net: 51.00 EUR
VAT 21%: 10.71 EUR
Total due: 61.71 EUR

=== FILE: scan-0417.txt (scan transcript) ===
RECHNUNG / INVOICE No. KV-220
Supplier: Kaffeeverein Tal e.V.
Date: 2026-03-12
Coffee beans 5 kg .............. 74.50 EUR
Filter papers .................. 9.90 EUR
Net: 84.40 EUR
VAT 10%: 8.44 EUR
Total due: 92.84 EUR

=== FILE: inv-2026-0420.txt ===
INVOICE No. 3090
Supplier: Lumen Studio Photography
Date: 2026-03-15
Product photo session .......... 320.00 EUR
Retouching, 8 images ........... 96.00 EUR
Net: 416.00 EUR
VAT 21%: 87.36 EUR
Total due: 513.36 EUR

=== FILE: scan-0422.txt (scan transcript) ===
INVOICE No. 0057
Supplier: Pinar Office Supplies
Date: 2026-03-18
Paper A4, 10 reams ............. 38.00 EUR
Toner cartridge ................ 64.00 EUR
Net: 102.00 EUR
VAT 21%: [unreadable]
Total due: 123.42 EUR

=== FILE: inv-2026-0425.txt ===
INVOICE No. B-118
Supplier: Brisa Cloud Hosting SL
Date: 2026-03-24
Domain renewal ................. 14.00 EUR
SSL certificate ................ 22.00 EUR
Net: 36.00 EUR
VAT 21%: 7.56 EUR
Total due: 45.00 EUR

file,invoice_no,supplier,date,net_eur,vat_eur,total_eur,status,note
inv-2026-0412.txt,A-0412,Nordlicht Print GmbH,2026-03-04,210.50,44.21,254.71,OK,
inv-2026-0413.txt,7781,Brisa Cloud Hosting SL,2026-03-09,51.00,10.71,61.71,OK,
scan-0417.txt,KV-220,Kaffeeverein Tal e.V.,2026-03-12,84.40,8.44,92.84,OK,
inv-2026-0420.txt,3090,Lumen Studio Photography,2026-03-15,416.00,87.36,513.36,CHECK,net+VAT = 503.36 but total says 513.36
scan-0422.txt,0057,Pinar Office Supplies,2026-03-18,102.00,,123.42,CHECK,VAT amount missing/unreadable - not guessed
inv-2026-0425.txt,B-118,Brisa Cloud Hosting SL,2026-03-24,36.00,7.56,45.00,CHECK,net+VAT = 43.56 but total says 45.00
TOTAL,,,,899.90,158.28,1091.04,3/6 OK,VAT total excludes the missing amount

---
name: invoice-to-sheet
description: Turns a folder of invoice text files or scan transcripts into one clean CSV with a totals check per invoice and overall. Use when you have several invoices as text and want one sheet, with mismatched or missing amounts flagged instead of guessed.
---
# Invoices to Sheet
Many invoice files in, one checked CSV out. Every row says whether its numbers add up.

## When to use
- You have 3 or more invoices as .txt, .md or OCR/scan transcripts and need one table.
- You want to know which invoices have wrong or unreadable amounts before booking them.

## Inputs
- A folder (or one file with several invoices). Ask for the path if it is missing.
- Optional: currency (default: the one printed on the invoices) and the column order.
- If a file is a PDF or image with no text, say it needs a text transcript first. Do not guess its contents.

## Steps
1. List every file in the folder. Never open files outside it.
2. For each invoice extract: file name, invoice number, supplier, date (ISO format), line items, net, VAT, total.
3. Copy numbers exactly as printed. Use a script (Python Decimal) for all arithmetic; do not add in your head.
4. Check each invoice: line items sum = net, and net + VAT = total. Any difference is a mismatch.
5. If a field is missing or marked unreadable, leave the cell empty and set status CHECK. Do not compute it from other fields.
6. Set status OK only when every check passes. Put the reason in the note column, with both numbers.
7. Add a TOTAL row (sum of net, sum of the VAT values that exist, sum of totals, count of OK invoices).
8. Save the CSV and print a 3-line summary: invoices read, invoices OK, invoices to review.

## Output
New file `invoices-checked.csv` next to the input folder. Columns:
`file,invoice_no,supplier,date,net_eur,vat_eur,total_eur,status,note`
- Two decimals, dot separator, no thousands separator, one row per invoice, then one TOTAL row.
- Status is `OK` or `CHECK`. The note explains every CHECK, for example `net+VAT = 503.36 but total says 513.36`.

## Rules
- Never invent a missing amount, date or supplier. Leave it empty and flag it.
- Never "fix" a total to make it match. Report both numbers.
- Write results to a new file, never overwrite the invoices or an earlier CSV.
- The check covers arithmetic only. Tax treatment and bookkeeping are for an accountant; this skill does not advise on them.
- Keep all data local; do not send invoice content anywhere.