AI and MCP

Turn receipt text into a clean expense table with AI

Prompts for pasting receipt text and getting date, merchant, items, GST line and total in columns, with a check that line items add up to the total.

Editorial illustration for Turn receipt text into a clean expense table with AI

To turn receipt text into an expense table with AI, paste the typed or OCR text of the receipt and ask for columns of date, merchant, item, quantity, rate and amount, plus the tax lines and the total, then ask it to add the items and tax and compare with the printed total. The check is the point. Scanned text often has misread digits, and a quiet error in a table is worse than no table.

A sample receipt

Here is a hypothetical grocery bill as text: Sharma General Store, 12/11/2026, Bill 0457. Atta 5kg, 1 at 285.00, 285.00. Toor dal 1kg, 1 at 160.00, 160.00. Sunflower oil 1L, 2 at 140.00, 280.00. Soap, 3 at 38.00, 114.00. Subtotal 839.00. CGST 12.50. SGST 12.50. Total 864.00.

The extraction prompt

Prompt: "Below is the text of a shop receipt in India. Put it into a table with the columns Date, Merchant, Item, Quantity, Rate and Amount. List tax lines such as CGST and SGST as separate rows and add a final row for the printed total. Copy numbers exactly as printed. Do not correct anything silently."

Say which language the receipt uses if it is not English, and ask the assistant to keep the item names as printed and add an English gloss in a separate column. That keeps the original searchable.

ItemQuantityRate (₹)Amount (₹)
Atta 5kg1285.00285.00
Toor dal 1kg1160.00160.00
Sunflower oil 1L2140.00280.00
Soap338.00114.00

Does the bill add up?

Prompt: "Add up the item amounts, then add the tax rows, and compare with the printed total. Check each row: quantity multiplied by rate should equal amount. Report any row that does not match and the size of the difference."

Here the items give 285 + 160 + 280 + 114, which is ₹839, matching the subtotal. Adding CGST and SGST of ₹25 in all gives ₹864, matching the total. When something fails to match, the assistant should say, for example, that rate times quantity is ₹120 and the printed amount is ₹126.

Also check that the GST lines are what the receipt printed, not what the assistant thinks they should be. A tax line you cannot trace back to the paper is a red flag, and rates can differ by item.

What if the receipt has no clear structure?

Many receipts from small vendors are loose lines. Ask: "Do your best with this messy text, but mark any field you had to guess as GUESS and keep the original line next to it." Then correct the marked fields by looking at the paper.

Handwritten bills are harder still. If you type one out yourself, type exactly what you see, including crossed-out amounts, and say so in the prompt so the assistant does not tidy them away.

Can I do a batch?

Yes, paste several receipts separated by a line saying NEXT. Ask for one table with a Receipt number column and a per-receipt check. Keep the batch small, around five, so a mistake is easy to trace.

Keep the paper trail

  • Keep the original photo or paper receipt; a table is a summary, not proof.
  • File receipts by month and note the bill number in your table.
  • For goods with warranties, note the date and seller in the item row.

SpendixAI keeps receipts with their transactions, so the photo and the entry stay together. GST figures in reports are estimates, so check them against the invoice and with your CA.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports