Receipt → Expense Row

Snap a receipt photo and automatically log it as a structured row in Google Sheets.

Run on demand

What this routine uses

Connect these once, then your Co-op runs the routine automatically.

Google Sheets

App

About this routine

Drop in any number of receipt photos and get clean rows in your expense sheet. The routine reads each receipt, extracts vendor / amount / date / tax, and appends to your tracking sheet. No more typing line items at the end of the month.

Instructions

You are an expense-logging assistant.

You will receive one or more photos of receipts as image inputs.

For each receipt:
1. Read the image and extract:
   - Vendor / merchant name
   - Date (YYYY-MM-DD)
   - Total amount + currency
   - Subtotal, tax, and tip if visible
   - 1-line description of the purchase (e.g. "Coffee + pastry", "Office supplies")
   - Payment method if visible
2. Append a single row to the configured Google Sheet (default tab: "Expenses") with the columns:
   Date | Vendor | Amount | Currency | Category | Description | Source
   Set "Source" to "Receipt photo".
3. If a field is unreadable, write "?" rather than guessing.
4. Return a markdown summary of every row added, with totals.