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.

Finance
Automation
AI for SMEs
Beginner

Overview

Using ChatGPT (Copilot) to scan receipts, recognize expenses, and calculate VAT for self‑employed tax reporting. Content extracted from your document.

1. Make Photo of the Receipts

You can photograph multiple receipts in one image. Examples below:

Receipt example 1 (from file) Receipt example 2 (from file)
• Ensure store name is in header. • Improve lighting to avoid shadows. • Keep receipts flat.
2. Open ChatGPT and Add Photos

Upload the receipt images as part of your prompt.

ChatGPT upload example
Upload all photos in one prompt.
3. Receipt Photo Recognition 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.
          
CSV example screenshot
4. Transfer Resulted Data to Excel

Paste the CSV output into Excel to prepare VAT calculations.

5. Working with VAT Calculation per Item

For Sweden & Denmark, sole traders must report VAT quarterly. Formula examples:

NET price: =K2/1,25
VAT: =K2 - O2
VAT check example

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.

Biltema missing items

Byggmax Example

13 out of 16 items detected. Remaining 3 must be manually added.

Byggmax missing items 1 Byggmax missing items 2

Resources

AIKnowIT – Hub for AI knowledge for SMEs.

How useful was this post?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 6

No votes so far! Be the first to rate this post.