JP2019145060A - Virtual currency management system - Google Patents

Abstract

To enable managing a transaction of virtual currency centrally, and to enable an appropriate balance calculation, tax return, asset status, etc. to be managed when a virtual currency user deals with transactions through multiple exchanges and wallets and multiple kinds virtual currency .SOLUTION: The system includes a virtual currency transaction conversion processing means for calculating a statutory currency translation amount by which a market database is referenced and a virtual currency quantity is translated to the statutory currency if transaction kinds of the transaction history data are virtual currency transactions, calculating a profit and loss amount if the transaction type falls under the category of sale, and storing it in a centralized transaction history database; an article and service purchase transaction conversion processing means for browsing the transaction database to obtain the statutory currency translation amount for the virtual currency quantity, and calculating the profit and loss, and storing it in the centralized transaction history database; and a virtual currency remittance and receiving means for rewriting the transaction type and save it in a centralized transaction history database if the transaction type is one of the receipt, withdrawal, remittance or receipt of the virtual currency.SELECTED DRAWING: Figure 6

Description

  The present invention relates to a virtual currency management system capable of centrally managing transactions relating to virtual currency and further supporting accounting processing of transactions relating to virtual currency.

  In recent years, virtual currencies such as bit coins have attracted attention as payment means for purchasing goods and services, remittance means between individuals, or investment targets. In response to this, in April 2017, the “Act on Funds Settlement” and the “Act on the Prevention of Revenue Transfer by Crime” were revised, and the definition of virtual currency and rules for virtual currency exchanges were stipulated. It was done. Furthermore, according to the National Tax Agency, profits generated by selling or using virtual currency such as Bitcoin are classified as miscellaneous income in principle and are subject to income tax. Also, in March 2018, the Corporate Accounting Standards Committee announced “the immediate treatment of accounting for virtual currency under the Fund Settlement Act”, and from the fiscal year beginning on or after April 2018, virtual currency transactions will begin. It is required to be valued as an accounting transaction and disclosed in the balance sheet and income statement.

  Here, virtual currency can be used for consideration of goods and services among unspecified number of people through the Internet, and there is no public issuer or administrator such as a central bank, It can be understood that it can be exchanged for legal currency. The virtual currency is often referred to as “cryptocurrency currency” overseas, but in this specification, it is collectively referred to as “virtual currency”. Currently, Bitcoin is a representative virtual currency, but there are many types of virtual currency other than Bitcoin. Typical examples include Ethereum, Lightcoin, Ripple, Monercoin, etc. Many virtual currency exchanges also handle a plurality of virtual currencies.

  By the way, it is considered that users of virtual currency usually use a plurality of exchanges and wallets including overseas and handle a plurality of types of virtual currencies. On the other hand, since there is no central manager for virtual currency, there is no unified trading market, and trading rules, exchange rates with legal currencies, and commissions are left to each exchange. . As for the transaction history of virtual currency, it is possible to obtain transaction data from each exchange or wallet operator, but the data format and format of the transaction data are not unified. Therefore, when trying to calculate the balance, acquisition cost, balance, etc. of virtual currency in order to understand tax returns and asset status, we face the following problems.

・ An accurate balance calculation system (sufficient for filing tax returns) on one exchange is not provided.
・ If remittance is made between multiple exchanges and wallets, the subsequent balance calculation becomes very difficult.
・ When virtual currency settlement is performed, the price (amount in legal currency) cannot be grasped.
・ Foreign exchange conversion is not easy when using an overseas exchange.
・ Unable to centrally manage the virtual currency / token balance of multiple exchanges.
・ An accounting data creation tool that handles virtual currency transactions does not yet exist.

  Due to the various problems described above, the more accurate the balance, acquisition cost, and balance calculation for virtual currency, the more complicated and difficult it is to calculate and manage, and the time and effort for final return and accounting are enormous. turn into.

  The applicant tried to investigate the prior art related to a system for solving the above-described problems. For example, as a result of performing a search using “virtual currency” and “management” as keywords, patent literature relating to the following virtual currency management program has been found. However, Patent Literature 1 intends to solve the problem relating to virtual currency mining. Yes, Patent Document 2 relates to a method for increasing the degree of guarantee of authenticity of virtual currency transaction information, and all of them aim to manage virtual currency transactions via a plurality of exchanges. It is not a thing. In the range investigated by the applicant, no prior art for solving the above problems could be found.

JP, 2006-218633, A JP 2017-207860 A

  The present invention can manage virtual currency transactions centrally when virtual currency users conduct transactions through multiple exchanges and wallets including overseas, or when dealing with multiple types of virtual currencies, The purpose is to provide a system capable of supporting accounting processing, making it possible to calculate appropriate income and expenditures for tax transactions, tax returns, and grasp asset status.

  The present invention is a virtual currency management system for centrally managing virtual currency transactions for trading a plurality of types of virtual currencies via a plurality of exchanges or wallets for solving the above-mentioned problem, For each wallet, a market database that accumulates relevant figures including the mid-term price or closing price as the exchange rate from virtual currency to legal currency in relation to the date and virtual currency type, and the purchase transaction of goods and services in the wallet Stores all settlement histories, including settlement amounts in legal currency, in order to centrally manage transaction databases that accumulate in relation to the date and user transaction history data obtained from each exchange or wallet Virtual transaction database and transaction history data obtained from each exchange or wallet for each exchange or wallet. Transaction history data format conversion processing means for rearranging in order of transaction date and time for each currency type, and converting to data in a unified storage format including each data item of transaction date / time, transaction type / virtual currency type / transaction virtual currency quantity, When it is determined that the transaction type of the formatted transaction history data generated by the transaction history data format conversion processing means is a transaction between virtual currencies, the market database is referred to and an appropriate mid-term or closing price for the transaction date is included. Calculate the legal currency conversion amount by converting the virtual currency quantity into legal currency by the numerical value, and if the transaction type corresponds to sale, calculate by multiplying the virtual currency transaction quantity by the unit price at the time of acquisition of the virtual currency Calculate the difference between the amount of money and the amount converted on the transaction date as profit and loss, and convert the formatted transaction history data into the legal currency conversion amount and profit or loss. In addition, the transaction type of the inter-virtual currency transaction conversion processing means stored in the centralized transaction history database and the formatted transaction history data generated by the transaction history data format conversion processing means is the purchase of goods / services in virtual currency. If it is determined, the transaction database is consulted to obtain the settlement amount of the transaction as the legal currency conversion amount of the virtual currency quantity required for settlement, and the virtual currency quantity required for settlement is referred to the market database for the immediately preceding virtual currency quantity. Convert the legal transaction currency to the legal currency using an appropriate number including the median or closing price on the date of purchase of the currency, calculate the difference from the legal currency conversion amount on the transaction date as profit and loss, and convert the formatted transaction history data to the legal currency Goods / service purchase transaction conversion processing means for storing the amount and profit / loss together with the centralized transaction history database; When the transaction type of the formatted transaction history data generated by the transaction history data format conversion processing means is any of deposit, withdrawal, remittance and receipt of virtual currency, the transaction date and virtual of all formatted transaction history data If there is a remittance / receipt that matches the currency quantity and the transaction time is considered to be the same, the formatted transaction history data is stored in the centralized transaction history database without calculating the profit and loss amount, and the transaction time is considered the same If it does not correspond to remittance / receipt, remittance is rewritten as unknown payment, and the transaction type is rewritten and stored in the centralized transaction history database. Virtual currency remittance / reception processing means.

  With such a configuration, when virtual currency users conduct transactions through multiple exchanges and wallets including overseas, or handle multiple types of virtual currencies, centralized transaction of virtual currencies Can manage.

  The virtual currency management system according to the present invention further extracts corresponding transaction history data from the centralized transaction history database according to the input balance calculation conditions including the period, virtual currency type, and transaction type, and the profit / loss of each transaction history data A virtual currency transaction balance calculating means for totaling the amount can be provided. In addition, by providing a currency exchange database that accumulates the official exchange rate of legal currency and other currencies in relation to the date of the month, the aggregated profit / loss amount can be determined by referring to the currency exchange database. A conversion amount can be obtained.

  The virtual currency management system according to the present invention further extracts corresponding transaction history data from the centralized transaction history database according to the input balance aggregation conditions including the period, the virtual currency type, and the transaction type. Virtual currency balance aggregation processing means may be further provided which aggregates the currency quantity by converting it into legal currency using an appropriate numerical value including the announced mid-term price or closing price on the date designated with reference to the market database. In addition, the currency specified by referring to the currency exchange database from the aggregated virtual currency balance by further providing a currency exchange database that stores the official exchange rate of legal currency and other currencies in relation to the date The conversion amount can be obtained.

  The virtual currency management system according to the present invention further includes a centralized transaction history database in accordance with input accounting processing settings including accounting period and transaction unit / item setting / currency notation of journal data / format format of journal data. The corresponding transaction history data is extracted from, and the virtual currency quantity of each transaction history data is converted into legal currency using the appropriate values including the announced mid-term or closing price on the specified date with reference to the market database and aggregated. If necessary, virtual currency accounting processing means for obtaining a conversion amount in the designated currency notation by referring to the exchange database and converting it into the set format of the journal data can be provided.

  In addition, the virtual currency management system according to the present invention extracts corresponding transaction history data from the centralized transaction history database according to the input accounting period, and totals and calculates the virtual currency balance quantity and acquisition cost for each virtual currency at the end of the period. The corresponding transaction history data is extracted from the centralized transaction history database in accordance with the virtual currency end-of-period accounting processing means or the input accounting period to be converted into the format of the journal data set, and for each virtual currency at the end of the period. The virtual currency balance quantity and the acquisition cost are aggregated and calculated, and the virtual currency balance quantity is converted into legal currency by referring to the market database using appropriate figures including the announced mid-term or closing price at the end of the period, and the acquisition before market value evaluation Calculate the period-end valuation profit / loss based on the difference from the cost and convert it to a journal data format. The 貨期 end accounting means may further include.

  According to the present invention, when a virtual currency user conducts transactions through a plurality of exchanges and wallets including overseas, or handles a plurality of types of virtual currencies, the transaction of the virtual currency is centrally managed. It is possible to calculate an appropriate balance of payments for virtual currency transactions, to grasp profits and losses for tax reporting, to understand asset status, etc., and to provide a system that can incorporate virtual currency transactions into accounting processing. .

It is a block diagram which shows schematic structure of the system by this invention. It is a figure which shows the example of the data item of the transaction history data of an exchange or a wallet in a table format. It is a figure which shows the example of the data item of the transaction history data preserve | saved at the formatted transaction history data file 33 in a table format. It is a figure which shows the example of the data item of the transaction history data preserve | saved in the unified transaction history database 34 in a table format. It is a figure which shows the example of the data item accumulate | stored in the market database 35 in a table format. It is a flowchart which shows the process until it preserve | saves transaction history data in the unified transaction history database. It is a flowchart which shows the process of a balance calculation. It is a flowchart which shows the process of balance collection. It is a flowchart which shows the process of accounting data creation. It is a flowchart which shows the process of the accounting period-end process.

  Hereinafter, an embodiment of a virtual currency management system (hereinafter referred to as “the present system”) according to the present invention will be described with reference to the drawings.

  First, the hardware configuration of this system will be described with reference to FIG. FIG. 1 is a block diagram showing a schematic configuration of the present system. As shown in FIG. 1, the server 1 that executes the processing of this system includes a control unit 2, a storage unit 3, an input unit 5, a display unit 6, an output unit 7, and a communication interface 8. The control unit 2 is a main storage device that can be directly accessed by a CPU, MPU, CPU, or the like that controls the operation of the entire computer including input / output / recording / reading of data, and stores data and programs necessary for processing. An internal memory is provided and functions as processing means indicated by reference numerals 21 to 27 (details of these functions will be described later). The storage unit 3 is a storage device such as a semiconductor memory element, a hard disk, or an optical desk that stores programs, data, and the like for executing processing in the present system. The server 1 includes a button for inputting data, a touch panel, a voice input device, an input unit 5 including input devices such as a keyboard and a mouse, a CRT display and a liquid crystal display for displaying a data input screen, processing results, and the like. A display unit 6 such as a printer for outputting processing results and various data, and a communication interface 8 for transmitting and receiving various information to and from other servers and terminal devices via a network.

  The storage unit 3 stores a program 31 necessary for executing the processing of this system. The program 31 is loaded into the internal memory of the control unit 2 as necessary, and cooperates with the hardware of the server 1 including the CPU. The processing of this system, specifically, transaction history data format conversion processing means 21, virtual currency transaction conversion processing means 22, goods / service purchase transaction conversion processing means 23, virtual currency remittance / reception processing means 24, It functions as a virtual currency transaction balance calculation processing means 25, a virtual currency balance aggregation processing means 26, and a virtual currency accounting data processing means 27.

  In addition, the storage unit 3 stores data used for each process executed by the control unit 2 and data generated by each process, a transaction history data file 32 for each exchange / wallet, formatted transaction history data. A file 33, a centralized transaction history database 34, and an accounting data file 38, and databases for referring to data necessary for each processing, that is, a market database 35, a transaction database 36, and an exchange database 37 are provided. For the transaction history data file 32 by exchange / wallet and the formatted transaction history data file 33, the storage unit 3 includes a case where the storage area of the data file is constantly secured as the configuration of the system, This includes the case where a temporary storage area is secured as a data file generated over time.

  Next, using FIG. 2 to FIG. 10, each processing unit in the control unit 2 and the contents of data stored in the storage unit 3 will be described in more detail. 2 to 5 are diagrams showing data files and data items stored in the storage unit 3, and FIGS. 6 to 10 are diagrams showing the flow of processing in this system.

  The transaction history data file 32 by exchange / wallet shown in FIG. 1 and FIG. 6 includes a plurality of virtual currency exchanges (hereinafter referred to as “exchanges”) of users who intend to manage virtual currency using this system. This is a temporary storage of transaction history data in and wallets. Transaction history or usage history data for each exchange or wallet (hereinafter collectively referred to as “transaction history data”) is usually obtained from the website of each exchange or wallet operating company via an API or CSV file. Can do. FIG. 2 is a diagram showing, in a table format, examples of data items included in a file in which each transaction history data is downloaded when, for example, A exchange, B exchange, and C wallet are used. As shown in FIG. 2, the format of each transaction history data is not unified, but items necessary for processing in this system, for example, transaction date and time, transaction type (virtual currency purchase, sale, deposit, withdrawal, Service, goods purchase settlement, etc.), virtual currency type to be traded, and virtual currency quantity traded. There is no particular limitation on the method of importing each transaction history data into the system, and it may be received via a network or may be input from the input unit 5 and stored in the transaction history data file 32 by exchange / wallet. It only needs to be saved.

  As shown in FIG. 6, the processing of this system is performed first in order to deal with each transaction history data stored in the transaction history data file 32 by exchange / wallet in a unified manner in this system. The conversion processing means 21 (see FIG. 1) starts by converting the format into a unified format and storing it in the formatted transaction history data file 33 (S1).

  FIG. 3 shows an example of data obtained by converting the transaction history data of the A exchange shown in FIG. 2 by the transaction history data format conversion processing means 21. Normally, transaction history data acquired from each exchange is stored in order of transaction date and time. The transaction history data format conversion processing means 21 converts each transaction history data stored in the transaction history data file 32 for each exchange / wallet according to the type of virtual currency for each exchange or wallet as shown in FIG. The data items and storage formats are converted and unified so that the data of each exchange and wallet can be handled in a unified manner and stored in the formatted transaction history data file 33. In the present embodiment, the description will be continued below assuming that the format has been converted to the format shown in FIG.

  The next stage of processing of this system is to determine what kind of transaction has been performed from the contents of the data items of the transaction history data stored in the formatted transaction history data file 33, and perform the necessary conversion processing according to the transaction type. This is a flow in which profits and losses of each transaction are calculated and stored in the centralized transaction history database 34.

  As step S <b> 2 shown in FIG. 6, the control unit 2 of the server 1 determines whether or not the transaction is a transaction between virtual currencies from the data of the item “transaction type” in the transaction history data. The transaction between virtual currencies is the buying and selling of virtual currencies and includes the buying and selling of virtual currencies. For example, in FIG. 3, as the transaction type, data that is purchased or sold is a transaction between virtual currencies, in addition to transactions in which Bitcoin (BTC) and Ethereum (ETH) transactions are settled in Japanese yen. Some transactions purchase Ethereum (ETH) with Bitcoin (BTC).

  In Step S2, the control unit 2 accesses the formatted transaction history data file 33, determines the transaction type for each stored transaction history data, and determines that the transaction is a transaction between virtual currencies The virtual currency transaction conversion processing means 22 (see FIG. 1) refers to the market database 35 and converts the virtual currency quantity of the transaction into legal currency (Japanese yen in the present embodiment). FIG. 5 shows an example of items of data stored in the market database 35, which is suitable as a conversion rate including published mid prices and closing prices as virtual currency rates handled for each exchange for each date. The published numerical values are accumulated (in FIG. 5, only the published mid-value is described, but it is possible to accumulate the opening price, the closing price, etc.). Accordingly, in step S2, when it is determined that the transaction is a transaction between virtual currencies, the virtual currency quantity of the transaction is converted into Japanese yen at a predetermined exchange rate on the transaction date of the exchange. Specifically, if the exchange determines which exchange the transaction is, and the exchange publishes the cryptocurrency rate, an appropriate numerical value such as the announced median price or closing price of the transaction date. The virtual currency quantity of the transaction is converted into Japanese yen. On the other hand, if the exchange does not publish the rate, or if the exchange does not support this system, the transaction will be calculated according to an appropriate value including the pre-established median price or closing price of the specific exchange. Convert the virtual currency quantity to Japanese yen. Further, when the transaction is sold, the difference between the amount obtained by multiplying the virtual currency quantity of the transaction by the unit price at the time of acquisition of the virtual currency and the converted amount on the day is obtained. This difference is the amount of profit or loss. The unit price at the time of acquisition of the virtual currency is included in the transaction history data of the formatted transaction history data file 33 (for example, transaction history data of the exchange B in FIG. 2). If it is not included in the history data, the unit price at the time of acquisition can be obtained from the virtual currency transaction quantity at the time of acquisition and the settlement currency quantity (for example, the example of FIG. 3) in the settlement currency.

  According to the above-described procedure, the transaction date and time, transaction ID, and transaction type (purchasing, selling, depositing, withdrawing virtual currency, services and goods of data items for each transaction included in the formatted transaction history data file 33 Purchase settlement, etc.), the virtual currency type and settlement currency type to be traded, and the virtual currency quantity traded, including the exchange or wallet identification and profit / loss, are stored in the centralized transaction history database 34 (S3 ).

  In addition, in transaction history data downloaded from an exchange or the like of the corresponding exchange, for example, in the case of a settlement transaction in Japanese yen, a settlement amount may be included as transaction history data. However, the rate at the exchange of virtual currency usually changes every day. For example, when confirming the transaction amount in legal currency for final tax return, select an arbitrary rate. It is desirable to convert at a rate based on a certain standard so that it is not considered to be converted. Therefore, in this embodiment, an appropriate midway price, closing price, etc., announced by the exchange on the transaction date is appropriate. Conversion is based on the published value set as the appropriate exchange rate. In terms of conversion at a rate based on a certain standard, it is considered that a conversion method using a published median price is common, but, for example, there is also a method of always converting at an opening price or closing price rate. In the case of transactions between virtual currencies, the amount of both currencies is converted into legal currency using the market database 35, and then the profit and loss are similarly calculated.

  FIG. 4 shows an example of data stored in the unified transaction history database 34. Items stored for one transaction include the exchange (or wallet), transaction date and time, transaction ID, transaction type, currency pair (virtual currency type and settlement currency type subject to transaction), virtual currency quantity traded, Includes conversion currency (type of legal currency to be converted), legal currency conversion amount, profit and loss. The balance calculation, balance aggregation, and accounting data processing, which will be described later, can be executed by extracting necessary data from the centralized transaction history database 34.

  Next, in step S4 shown in FIG. 6, the control unit 2 of the server 1 accesses the formatted transaction history data file 33, and from the item “transaction type” in the transaction history data of each stored wallet, It is determined whether or not the transaction is a purchase of goods / services using virtual currency. When it is determined that the purchase of goods / services is in virtual currency, the goods / service purchase transaction conversion processing means 23 (see FIG. 1) refers to the transaction database 36 to determine the virtual currency quantity of the transaction in legal currency (present In the embodiment, it is converted into Japanese yen). The transaction database 36 is a database that accumulates settlement histories in each article / service purchase transaction provided by the wallet operator. When the user purchases an article / service from the wallet by referring to the transaction database 36. You can get the actual settlement amount. In addition, in the wallet, an appropriate numerical rate such as the announced median price or closing price on the day of depositing the virtual currency is obtained from the market database 35, and the currency amount of the virtual currency required for the purchase is converted into a legal currency. Find the difference from the actual payment amount. This difference is the amount of profit or loss. In this way, the transaction date / time, transaction ID, transaction type (virtual currency purchase, sale, deposit, withdrawal, services and goods purchase settlement, which are data items for each transaction included in the formatted transaction history data file 33 And the like, including the identification of the exchange or wallet, the legal currency conversion amount, and the profit and loss amount in the virtual currency type to be traded and the virtual currency quantity traded, it is stored in the centralized transaction history database 34 (S5). .

  Further, in step S6 shown in FIG. 6, the control unit 2 of the server 1 accesses the formatted transaction history data file 33, and stores the item “in the transaction history data of all the exchanges and each wallet stored in“ When the transaction date and virtual currency quantity corresponding to the deposit and withdrawal (remittance / receipt) in “Transaction type” are collated (S7), and there is remittance / receipt with the same transaction time (for example, from the account of the exchange) (Transfer of the amount to the wallet) (S8), the transaction history data is stored in the centralized transaction history database 34 as it is without calculating the profit and loss in the mutual transaction (S9). In step S8, if there is no remittance / receipt for which the transaction time is considered to be the same, the remittance (withdrawal) is written in the transaction type as an undisbursed withdrawal, stored in the centralized transaction history database 34, and received (remitted) About (acceptance), it writes in transaction type as acceptance with unknown acquisition cost, and preserve | saves it in the unified transaction history database 34 (S10).

  As described above, the transaction history data of virtual currency at all exchanges and wallets is taken into the centralized transaction history database 34 and stored. Note that the flows of steps S2 to S3, steps S4 to S5, and steps S6 to S10 shown in FIG. 6 need not be executed in the order shown in FIG. 6, and may be executed in any order.

  Next, the balance calculation procedure will be described with reference to FIG. For example, when the user selects the balance calculation menu on the menu selection screen provided by the control unit 2, the virtual currency transaction balance calculation processing means 25 (see FIG. 1) that has recognized it displays a screen for inputting conditions. This is displayed on part 6. When the user designates the balance calculation conditions including the period, the type of virtual currency, and the type of transaction from the input unit 5 (F1), the virtual currency transaction balance calculation processing means 25 accesses the centralized transaction history database 34. The corresponding transaction history data is extracted according to the specified condition (F2). As for transaction history data in the centralized transaction history database 34, data already converted in a predetermined legal currency (Japanese yen in the present embodiment) is stored, but it is assumed that the balance is calculated in another currency. Then, as the next step, the virtual currency transaction balance calculation processing means 25 displays an input screen for the presence / absence of exchange conversion and the type of currency on the display unit 6 to prompt the user to input. When the user inputs the presence / absence of exchange conversion or the type of currency from the input unit 5 and determines that exchange conversion is necessary (F3), the virtual currency transaction balance calculation processing means 25 stores the exchange database 37. Referring to, convert the profit and loss in the legal currency that has been saved to the specified currency (F4), execute the balance calculation (aggregate the profit and loss included in each transaction history data) (F5), and calculate the balance Output the result. Further, when it is determined that there is no need for currency conversion, the virtual currency transaction balance calculation processing means 25 uses the already stored legal currency conversion amount data to calculate the balance (the profit and loss included in each transaction history data). Sum up the amount) (F5), and output the balance calculation result. The exchange database 37 is a database in which the published exchange rates for each currency and legal currency are accumulated in relation to the date.

  Next, the asset status confirmation procedure for the virtual currency will be described with reference to FIG. For example, when the user selects the asset status confirmation menu on the menu selection screen provided by the control unit 2, the virtual currency balance aggregation processing means 26 (see FIG. 1) that has recognized it displays a screen for inputting conditions. This is displayed on part 6. When the user designates balance aggregation conditions including the period, virtual currency type, and transaction type from the input unit 5 (N1), the virtual currency balance aggregation processing means 26 is designated from the centralized transaction history database 34. The corresponding transaction history data is extracted according to the conditions (N2). Next, the virtual currency balance aggregation processing means 26 prompts the user to input a designated date for asset evaluation for the virtual currency for which the balance is aggregated. When the user enters the designated date, the market database 35 receives the input. And the virtual currency quantity of the extracted data is converted into a legal currency by using an appropriate numerical value such as an announcement price or closing price on the designated date (N3). Next, assuming that it is desired to check the balance in another currency, the virtual currency balance aggregation processing means 26 causes the display unit 6 to display an input screen for the presence / absence of exchange conversion and the type of currency as the next step, Prompt user input. When the user inputs the presence / absence of currency conversion or the type of currency from the input unit 5 and receives this and determines that currency conversion is necessary (N4), the virtual currency balance aggregation processing means 26 refers to the currency database 37. Then, the legal currency conversion amount already stored is converted into the designated currency (N5), balance aggregation is executed for each type of virtual currency (N6), and a virtual currency balance list is output. If it is determined that there is no need for currency conversion, the virtual currency balance aggregation processing means 26 performs balance aggregation for each type of virtual currency using the data of the legal currency conversion amount already stored ( N6), a virtual currency balance list is output.

  Next, the procedure of transaction data processing will be described with reference to FIG. For example, when the user selects the accounting data processing menu on the menu selection screen provided by the control unit 2, the virtual currency accounting data processing means 27 (see FIG. 1) that recognizes the menu selects the accounting data processing menu. A setting screen is displayed on the display unit 6. From the input section 5, the accounting period and transaction unit setting (calculated for each transaction, every day, every month, every year, etc.), account items, Setting of supplementary items, currency notation about which legal currency notation is used to create accounting journal data, specification of the format of accounting journal data provided for use in the user's accounting data system (for example, CSV file format, (A1), the virtual currency accounting data processing means 27 accesses the centralized transaction history database 34 and applies the corresponding transaction according to the specified conditions. The history data is extracted (A2), and according to the setting in step A1, the transaction history data is obtained according to the legal currency (Japanese yen in this embodiment). To run the balance calculation and tallying (A3). If it is determined from step A1 that exchange conversion is necessary (A4), the virtual currency accounting data processing means 27 is referred to the exchange database 37, and the amount in legal currency calculated and aggregated is designated. It is converted into currency (A5) and output as accounting journal data (A6). The accounting journal data is accumulated in the accounting data file 38 at that stage, and is converted into a specified accounting format according to the setting in step A1 (A7), and is formatted for use in the user accounting system. Output as journal data (A8).

  Next, the term-end processing of accounting data will be described using FIG. For example, when the user selects the period end processing menu on the menu selection screen provided by the control unit 2, the virtual currency accounting data processing means 27 recognizes it and causes the display unit 6 to display a screen for inputting conditions. When the user designates an accounting period from the input unit 5 (E1), the virtual currency accounting data processing means 27 extracts corresponding transaction history data from the centralized transaction history database 34 according to the designated period (E2). ). Next, the virtual currency accounting data processing means 27 aggregates and calculates the virtual currency quantity balance and acquisition cost of each virtual currency at the end of the accounting period from the extracted transaction history data (E3).

  Here, a confirmation screen as to whether or not the user executes the market price evaluation of the balance at the end of the virtual currency is provided from the control unit 2 (E4), and if the execution of the market price evaluation is selected, the virtual currency accounting data processing is performed. The means 27 accesses the market database 35, and converts the aggregated balance quantity of each virtual currency into a legal currency based on an appropriate numerical value such as a published middle price or closing price on the date when the market price evaluation is executed (E5). Next, the statutory currency conversion amount of each revaluated virtual currency is aggregated, and the market value valuation gain / loss at the end of the period is calculated from the difference from the acquisition cost before the market value evaluation (E6). The valuation gain / loss at the end of the period obtained in step E6 is transferred to the account data file 38 as the balance at the end of the period (E7) and is stored in the accounting data file 38, while being converted into the specified accounting format (E9). Is output as data for carry-over processing available at (E10).

  On the other hand, if the execution of the market price evaluation is not selected in step E4, the balance at the end of the period and the acquisition cost for each virtual currency calculated and calculated in step E3 are used as data for carry-forward processing (E8) and saved in the accounting data file 38. On the other hand, it is converted into the designated accounting process format (E9) and output as carry-over process data that can be used in the user's accounting system (E10).

DESCRIPTION OF SYMBOLS 1 Server 2 Control part 3 Memory | storage part 5 Input part 6 Display part 7 Output part 8 Communication interface 21 Transaction history data format conversion processing means 22 Inter-virtual currency transaction conversion processing means 23 Goods / service purchase transaction conversion processing means 24 Virtual currency remittance Receipt processing means 25 Virtual currency transaction balance calculation processing means 26 Virtual currency balance aggregation processing means 27 Virtual currency accounting data processing means 31 Processing program 32 Transaction history data file by exchange / wallet 33 Formatted transaction history data file 34 Centralized transaction history database 35 Market Database 36 Transaction Database 37 Exchange Database 38 Accounting Data File

Claims (8)

A virtual currency management system that unifies and manages virtual currency transactions in which multiple types of virtual currency are traded through multiple exchanges or wallets,
A market database that accumulates appropriate numerical values including exchange prices or closing prices as exchange rates from virtual currency to legal currency by exchange or wallet in relation to the date and virtual currency type, and
A transaction database that stores all payment history of goods / service purchase transactions in Wallet in relation to the date, including payment amounts in legal currency,
A centralized transaction history database that stores user transaction history data obtained from each exchange or wallet for centralized management;
Transaction history data acquired from each exchange or wallet is sorted by transaction date and time for each virtual currency type for each exchange or wallet, and each data item of transaction date / time, transaction type / virtual currency type / transaction virtual currency quantity Transaction history data format conversion processing means for converting to data in a unified storage format including
When it is determined that the transaction type of the formatted transaction history data generated by the transaction history data format conversion processing means is a transaction between virtual currencies, the market database is referred to and an appropriate mid-term or closing price for the transaction date is included. Calculate the legal currency conversion amount by converting the virtual currency quantity into legal currency by the numerical value, and if the transaction type corresponds to sale, calculate by multiplying the virtual currency transaction quantity by the unit price at the time of acquisition of the virtual currency Transaction conversion processing between virtual currencies that calculates the difference between the amount of money and the conversion amount on the transaction date as profit and loss and stores the formatted transaction history data in the centralized transaction history database together with the legal currency conversion amount and profit and loss Means,
When it is determined that the transaction type of the formatted transaction history data generated by the transaction history data format conversion processing means purchase of goods / services in virtual currency, the transaction database is referred to and the settlement amount of the transaction is required for settlement. The virtual currency quantity required for settlement is converted into legal currency by referring to the market database and converting the virtual currency quantity to legal currency using the appropriate mid-term price or closing price. Then, the difference from the legal currency conversion amount on the transaction date is calculated as profit and loss, and the formatted transaction history data is stored in the centralized transaction history database together with the legal currency conversion amount and profit and loss. Conversion processing means;
When the transaction type of the formatted transaction history data generated by the transaction history data format conversion processing means is any of deposit, withdrawal, remittance and receipt of virtual currency, the transaction date and virtual of all formatted transaction history data If there is a remittance / receipt that matches the currency quantity and the transaction time is considered to be the same, the formatted transaction history data is stored in the centralized transaction history database without calculating the profit and loss amount, and the transaction time is considered the same If it does not correspond to remittance / receipt, remittance is rewritten as unknown payment and saved in the centralized transaction history database, and received is receivable unknown acquisition cost is rewritten and saved in the centralized transaction history database And a virtual currency remittance / receipt processing means.   Virtual currency transaction balance calculation process that extracts the corresponding transaction history data from the centralized transaction history database according to the input balance calculation conditions including period, virtual currency type, and transaction type, and totals the profit / loss amount of each transaction history data The virtual currency management system according to claim 1, further comprising means.   By providing an exchange database that accumulates the official exchange rates of legal and other currencies in relation to the date of the month, the amount converted in the currency designated by referring to the exchange database from the aggregated profit / loss The virtual currency management system according to claim 2, wherein:   In accordance with the entered balance aggregation conditions including period, virtual currency type, and transaction type, the corresponding transaction history data is extracted from the centralized transaction history database, and the virtual currency quantity of each transaction history data is specified with reference to the market database The virtual currency management system according to claim 1, further comprising virtual currency balance aggregation processing means for converting into legal currency using an appropriate numerical value including an announced mid-term price or closing price on a calculated date and totaling the data.   By providing a currency exchange database that accumulates the official exchange rates of legal and other currencies in relation to the date of the month, conversion from the aggregated virtual currency balance in the currency specified by referring to the currency exchange database The virtual currency management system according to claim 4, wherein an amount can be obtained.   In accordance with the entered accounting process settings including accounting period, transaction unit, item setting, journal data currency notation, journal data format format, the corresponding transaction history data is extracted from the centralized transaction history database. The virtual currency quantity of the transaction history data is aggregated by converting it into legal currency using an appropriate number including the announced middle price or closing price on the specified date by referring to the market database, and if necessary, refer to the exchange database. 2. The virtual currency management system according to claim 1, further comprising virtual currency accounting processing means for obtaining a conversion amount in a specified currency notation and converting the converted amount into a set format of journal data.   In accordance with the entered accounting period, the corresponding transaction history data is extracted from the centralized transaction history database, the virtual currency balance quantity and acquisition cost for each virtual currency at the end of the period is totaled and calculated, and the journal data format is set The virtual currency management system according to claim 6, further comprising a virtual currency end-of-period accounting processing means for converting.   According to the entered accounting period, the corresponding transaction history data is extracted from the centralized transaction history database, the virtual currency balance quantity and acquisition cost for each virtual currency at the end of the period are aggregated and calculated, and the market database is referred to as of the end of the period The virtual currency balance quantity is converted into legal currency using an appropriate numerical value including the announced median price or closing price, and the period-end valuation profit / loss is calculated based on the difference from the acquisition cost before market value evaluation, and converted into the format of journal data. The virtual currency management system according to claim 6, further comprising currency term-end accounting processing means.

Images