Use Case 07: Tax management for Self-Employment
Use Case – Tax Management for Self‑Employment
Using ChatGPT to scan receipts, extract structured CSV data, and calculate VAT efficiently.
Overview
Using ChatGPT (Copilot) to scan receipts, recognize expenses, and calculate VAT for self‑employed tax reporting. Content extracted from your document.
You can photograph multiple receipts in one image. Examples below:
Upload the receipt images as part of your prompt.
Copy & paste this prompt into ChatGPT:
You are an accounting assistant parsing receipts from construction goods stores (SE, NO, DK, FI).
DO NOT translate item names.
Output: ONE CSV block with all products:
store name, date, receipt_number, currency, item_index,
item_name, item_name_en_short, quantity, unit_price, line_total,
category, notes
Rules:
- 1 row = 1 item; item_index restarts for each receipt.
- Comma as decimal separator.
- Wrap values with commas in quotes.
- Categories: “Construction” or “Other”.
- If poor quality: summarize visible totals or note unreadable.
Paste the CSV output into Excel to prepare VAT calculations.
For Sweden & Denmark, sole traders must report VAT quarterly. Formula examples:
=K2/1,25VAT:
=K2 - O2
Optional Enhancements
Manual verification reveals about 10% missing items in some receipts.
Biltema Example
8 out of 11 items detected; missing items included: 429, -51 (discount), 189, 299.
Byggmax Example
13 out of 16 items detected. Remaining 3 must be manually added.
Resources
AIKnowIT – Hub for AI knowledge for SMEs.

