Payment History

Transaction History Management

It is configured to show a summary of statistical information such as the number of transactions occurred, total revenue, number of refunds, refund amounts, and to check detailed information of each transaction through a detailed transaction history list.

Main Items and Features:

1. Transaction Statistics:

• Period Selection (2024.10.06 - 2025.04.04): Indicates the period for which current statistics and transaction history are being queried. You can check data for other periods by changing the date range.
• Total Transactions: Indicates the total number of transactions that occurred during the period.
• Total Revenue: Indicates the total revenue amount that occurred during the period. (All currencies are displayed in $.)
• Refund Count: Indicates the total number of refunds that occurred during the period. Currently displayed as "0" cases.
• Refund Amount: Indicates the total refund amount that occurred during the period. Currently displayed as "0". The currency unit will be the same as total revenue.

2. Monthly Revenue Trend:

• Shows monthly revenue changes during the period in graph format.
• Monthly revenue changes during the selected period: This is a description of the graph. It shows monthly revenue changes during the selected period.
• Hide Chart: A button to hide the graph. A "Show Chart" button will appear to view it again.
• The horizontal axis represents months, and the vertical axis represents revenue amounts. You can visually check each month's revenue through the height of the bar graph. Currently, February appears to have the highest revenue.

3. Transaction List:

• Shows detailed history of all occurred transactions in table format.
• Search:
  • [Search Input Field]: A field where you can search transaction history by transaction ID, user ID, product name, etc. Enter a search term and click the "Search" button to display only transaction history containing that search term.
• Export to Excel: A button to export currently queried transaction history to an Excel file. Useful when analyzing or storing data externally.
• Filter:
  • All Apps [Dropdown]: A dropdown menu that allows filtering to view only transaction history of specific apps or services. Currently set to "All Apps", showing transaction history of all apps.
  • Period Filter (2024.10.06 - 2025.04.04): The current query period is displayed once more, and when clicked, a calendar or options to select other periods are expected to appear.
  • Quick Period Selection (7 Days, 30 Days, 90 Days, 180 Days): Buttons to quickly query transaction history for the last 7, 30, 90, and 180 days.
• Table Headers: Columns representing information of each transaction history.
  • Status: Indicates transaction status. Currently all transactions are in "Completed" status. Other statuses could include "Pending", "Failed", "Refunded", etc.
  • ID: The unique identifier (Transaction ID) of each transaction.
  • User: The user ID who performed the transaction.
  • Game: The name of the game or service where the transaction occurred. Currently displayed as "크리티컬 호히".
  • Product: The name of the purchased product. Currently displayed as "500루비".
  • Currency: The currency unit used. Currently displayed as "KRW" (Korean Won).
  • Amount: The transaction amount. Currently displayed as "1,500".
  • Exchange Rate: Currency exchange rate information (for foreign currency transactions).
  • Converted Amount: The amount converted to the base currency. Currently displayed as "$ 1.05" or "$ 1.035", etc.
  • Payment Method: Payment method information. Currently displayed as "신용카드 & 간편결제".
  • Time: The date and time when the transaction occurred.
  • Actions: Action buttons that can be performed for each transaction are located here. Currently, an eye-shaped icon is displayed on the right side of each transaction list, and clicking it is expected to show detailed information of that transaction.

Transaction History Management Methods:

• Period-based Query: Query transaction history for desired periods using period selection at the top or quick period selection buttons.
• Search: Enter keywords such as transaction ID, user ID, product name in the search field to find specific transaction history.
• Filtering: Use the "All Apps" dropdown menu to check only transaction history of specific apps.
• Detailed Information Check: Click the eye-shaped icon in the "Actions" column of the transaction list to check detailed information of each transaction (payment details, user information, etc.).
• Data Export: Click the "Export to Excel" button to save currently queried transaction history as an Excel file.

Precautions:

• Personal information such as transaction IDs and user IDs should be managed safely.
• Important actions such as refund processing should be performed carefully.