Turn a batch of receipt and invoice photos into one clean expense spreadsheet

I've attached 23 photos of receipts and invoices. Read all of them in this one pass and return one consistent table — not a separate summary per photo with its own formatting.

CATEGORIES
Assign each line item to the closest match from this fixed list: Travel, Meals, Software, Office supplies, Other. Never invent a new category, even if a receipt doesn't fit neatly — pick the closest one and note the mismatch in a comments field instead.

CURRENCY
All receipts should be in INR; flag any that appear to be in a different currency rather than converting them yourself.

REQUIRED COLUMNS
date, vendor, category, amount, tax amount if shown, payment method if shown

INSTRUCTIONS
1. One row per receipt (or one row per line item if a single receipt/invoice covers clearly separate expense categories — say which approach you used and be consistent about it across the whole batch).
2. If a photo is blurry, cropped, or a specific field (date, total, vendor name) isn't legible, leave that cell blank and add a note rather than guessing a plausible-looking value — a guessed total that's wrong is worse than an honest blank someone can fill in by checking the physical receipt.
3. If a receipt appears to be a duplicate of another one in the batch (same vendor, same amount, same date), flag it as a possible duplicate rather than silently including it twice or silently dropping one.
4. Meals over ₹1,500 per receipt need a manager note per company policy — flag these, don't reject or adjust them yourself.
5. If a single photo actually shows two separate receipts (someone photographed a stack, or two receipts side by side), split them into two rows rather than merging their totals into one, and note that a split happened so it can be double-checked against the physical receipts.
6. If a vendor name is abbreviated, uses a franchise-location suffix, or is printed differently across receipts from what is clearly the same underlying business (e.g., a store number appended to the name), normalize it to one consistent name across the batch so a later pivot by vendor doesn't fragment into near-duplicate rows for what is really one vendor.
7. Note the language the receipt is printed in if it's not the expected one, since a receipt from a business trip abroad may need different tax handling than a routine domestic one.
8. If a receipt shows a tip or service charge as a separate line from the base amount, keep them as separate values rather than folding the tip into the base total, since some reimbursement policies cap tips independently of the meal amount itself.

OUTPUT FORMAT
A single table with the required columns above, ready to paste into a spreadsheet, followed by a short list of anything flagged: illegible fields, currency mismatches, split receipts, vendor-name normalizations made, and possible duplicates.