Pick Amount, Payment Method, and Points from a Merpay Screenshot
Merpay has no individual transaction export, not even a limited CSV. The confirmation screen lives inside the Mercari app, mixing payment details, order info, and seller data in a single Japanese-language view. Each screenshot takes under 10 seconds to extract into a clean spreadsheet row.
5-10s per screenshot · Up to 99% accuracy on printed text
Four Fields Every Merpay Confirmation Carries
A Merpay payment screen inside the Mercari app carries four data points worth tracking, none of which are available in any built-in export. With Custom Column Extraction, you name the fields you need and the AI locates each value by reading Japanese labels, not pixel positions.
The bold Yen figure on the Merpay confirmation screen, labelled with the Japanese term for usage amount. Includes the currency symbol and the exact transaction value.
Merpay balance, credit card, or smart pay, the AI reads the exact funding source selected for this transaction.
The Mercari order number or the Merpay transaction reference, the stable identifier for matching payments to specific items or disputes.
Awarded per transaction and shown on the confirmation screen, invisible in any export, only accessible via screenshot.
A Payment Screen with No Export Button
Merpay processes millions of transactions across Japan largest flea market. But for the individual user tracking their own spending, the app provides no way to export a single transaction details. The confirmation screen is a screenshot-or-lose-it interface, and it mixes Mercari order data with Merpay payment information in one view.
No Export, Not Even a Limited One
Unlike PayPay, which at least has a CSV export however flawed, Merpay has no individual user transaction export at all. Mercari users on forums consistently confirm that the app has no print or export function. The only way to preserve transaction records is to screenshot the screen before navigating away.
Japanese Labels Mixed with Digits
Merpay confirmation screen uses Japanese labels including usage amount, payment method, order number, payment ID, and points. Standard OCR tools trained on Latin characters lose accuracy on kanji, kana, and digit combinations. A tool that reads semantically handles both writing systems because it identifies fields by their label meaning, not by character shape.
Mercari Order Context Overlay
The Merpay payment screen is not a standalone payment app. It is a view inside the Mercari app. The same screen shows the item name, seller info, shipping status, and payment details together. A generic screenshot-to-text tool extracts everything as a wall of mixed text, but the user only needs the payment-specific fields among the order context.
The Only Way to Capture Points Per Transaction
Merpay awards points on each transaction, displayed as a badge on the confirmation screen. Since no export exists, these points are invisible to any tracking system. Define a Points column and the AI reads the label and its value, the only way to capture this data per transaction.
Semantic Reading Handles Japanese Labels
The AI identifies each field by the meaning of its Japanese label, not by character-level OCR. The label for usage amount means the amount being charged, the AI looks for the Yen figure next to this label. The label for payment method means the payment method, the AI reads the value beside it. This approach works regardless of whether the Mercari app updates its layout, because the labels stay the same.
Extract Payment Fields from the Mercari Order Context
The AI distinguishes payment-specific fields (amount, payment method, transaction ID) from the surrounding Mercari order context (item name, seller info, shipping status). Define four columns, Amount (Yen), Payment Method, Transaction ID, Points, and the AI returns only what you asked for, ignoring the rest of the screen.
From a Merpay Confirmation to a Spreadsheet Row
If you are tracking Merpay transactions for Mercari sales reconciliation, tax record-keeping, or personal expense tracking, here is what happens when you drop a screenshot into the tool.
Upload the Merpay Screenshot
Upload a Merpay payment confirmation screenshot from the Mercari app, the payment confirmation screen after purchase, the transaction history list, or the individual order detail page. The screen includes the Mercari item name, seller info, and shipping status alongside the Merpay payment details. The AI reads the entire screen but only extracts the fields you define.
Name the Columns
Define your column headers: Amount (Yen), Payment Method, Transaction ID, Points. The AI interprets each column name semantically. It knows that Amount means the Yen figure next to the label for usage amount, and Payment Method means the funding source shown beside the label for payment method. Add an Inferred Column like Category (options: Mercari Purchase / In-Store / Online) and the AI classifies each transaction based on the merchant context visible in the screenshot.
Export the Row
The output lands as one spreadsheet row per screenshot. The Yen amount, the payment method, the Mercari order or Merpay transaction ID, and the points earned. Export to Excel, CSV, or push directly into Google Sheets via the add-on. One screenshot, one row, no gaps.
When Merpay Screenshot Extraction Works Best, and When to Be Cautious
When It Works Best
Direct device screenshots from the Mercari app. Full-resolution screenshots of the payment confirmation screen, the transaction detail page, or the Merpay payment history give the most reliable results.
Batch processing with other Japanese payment apps. The same column set extracts from Merpay, PayPay, and LINE Pay screenshots in one batch, ideal for users who use multiple payment methods.
Mercari sales reconciliation. Processing multiple purchase confirmations alongside Merpay payment screenshots gives you a single view of what you bought and how you paid.
When to Be Cautious
Compressed or forwarded screenshots. Sharing a Merpay screenshot through LINE or messaging apps compresses the image. The AI still outperforms OCR, but forwarded copies are worth spot-checking for critical fields.
Architecture boundary: screenshot only, not data feed. This tool works with screenshots of the Merpay screen. It cannot access the Merpay transaction database or pull data directly from the Mercari app backend. It complements the app, not replaces it.
Partial screenshots that crop the label area. If the screenshot cuts off the Japanese label for amount or payment method, the AI may not have enough context to identify the field. Capture the full confirmation screen.
Frequently Asked Questions
Can I extract the points earned from a Merpay screenshot when there is no export at all?
Yes. Merpay awards points per transaction, shown as a Points badge on the payment confirmation screen. Since Merpay has no individual user transaction export, screenshot extraction is the only way to capture points earned per transaction. Define a Points column and the AI reads the Japanese label and its value from the screen. This is the single most valuable field that screenshot extraction recovers that is otherwise completely invisible to any tracking system.
Does the extraction work on Merpay screenshots with Japanese labels?
Yes. The AI reads Japanese kanji, kana, and digits together as a single semantic unit. It identifies the Amount field label, the Payment Method label, and the Order Number label by understanding what each label means, not by matching pixel patterns. This is where traditional OCR trained primarily on Latin characters would struggle. The AI handles mixed-script content naturally because it reads field relationships, not individual character shapes.
Can I batch Merpay screenshots with PayPay and LINE Pay in the same export?
Yes. Define one set of column names, and the AI processes Merpay, PayPay, LINE Pay, Venmo, and PayPal screenshots in a single batch. Each screenshot becomes one row, regardless of which app generated it. Add a Source column to tag which app produced each row. See the payment screenshots overview for the full cross-app capability.
Can I distinguish between Merpay balance, credit card, and smart pay in the extracted Payment Method field?
Yes. The Merpay confirmation screen shows the exact funding source, and the AI reads this value into the Payment Method column. Merpay balance (balance), credit card (card), and smart pay (smart pay) are each displayed as distinct labels on the screen. This is especially useful for tracking which payment method you use across different merchants, since Merpay allows you to switch between them per transaction and the app does not provide a consolidated payment method report.
What if I need to extract data from a Merpay transaction that also involves a Mercari order?
The Merpay payment screen inside the Mercari app shows the order context item name, seller info, shipping status alongside the payment details. The AI extracts only the fields you define, so if you name Amount, Payment Method, Transaction ID, and Points as your columns, it ignores the Mercari order details. If you want to capture the order context too, add a column like Item Name or Seller and the AI will include those fields alongside the payment data.
See all payment screenshot types supported by this tool, from Venmo and PayPal to PayPay and LINE Pay: payment screenshots overview
Another Japanese mobile payment app with a different confirmation screen structure: PayPay screenshot extraction
LINE Pay, another popular Japanese payment platform with different field layouts: LINE Pay screenshot extraction