JP2009104565A - Accounting database creation system for elctronic money - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To solve the problem that use histories and transaction data in bank accounts, of electronic money or the like are insufficient as accounting information because being allowed to be disclosed only on networks or dedicated terminals and an existing account-fixed system is insufficiently compatible with a financial accounting-management system used by a user. <P>SOLUTION: An accounting database creation system includes: a means for allowing the user of use histories and transaction data in bank accounts, of electronic money or the like to download and preserve use histories and transaction data from a preserver of the use histories and transaction data, within a server or his or her computer; a means for preserving extracted history information extracted from a dedicated terminal or the like; a means for converting the preserved data into a journal format of double-entry bookkeeping; a means for adding lacking titles to complete journal by using an arbitrarily created account title list; and a means for outputting completed data in a form selected by the user. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

    The present invention processes the usage history of electronic money stored by an electronic money issuing company and the transaction data of a deposit account stored by a bank into a form required by each user according to the principle of double-entry bookkeeping, It is related with the creation system of a general-purpose accounting database which enables the automatic taking in to etc.

  Usage history of electronic money and bank account transaction data are disclosed on a network such as a dedicated terminal or Internet banking.

  A detailed database exists so that the usage history of electronic money or the like is used for commercial statistics or the like.

There is a system that automatically and automatically sets account items at the time when electronic money is consumed and generates journal entries for double-entry bookkeeping (Patent Document 1)
Japanese Patent Laid-Open No. 10-63753

  In the form of disclosure of usage history of electronic money etc. and transaction data of bank account, there is no disclosure of the actual transaction amount, although there is a description of the date and customer in the dedicated terminal and network service of the user, and from the balance after the transaction As accounting information in generating accounting data using double-entry bookkeeping, such as calculating the actual transaction amount by adding or subtracting the balance after the transaction, or disclosing only the date and actual transaction amount, and not disclosing the business partner or transaction purpose Lack of reportability.

  In addition, the disclosure of the usage history of electronic money and the transaction data of the bank account has a limit on the number of history displays when accessing from a dedicated terminal or network on the user side. The database accumulated for commercial statistics is not disclosed to general consumers as users here.

  In addition, disclosure of usage history of electronic money, etc. and bank account transaction data is provided in a unique format by the disclosure information provider, and it is complicated to download to spreadsheet software and financial accounting software. There is no sex.

  In addition, since the existing journal generation system also includes an electronic payment system in the system, it lacks versatility and the determination of account items is automatic and fixed. It was difficult to link to the accounting system and the business management system.

  (1) The present invention for solving the above-described problems is that a user (hereinafter referred to as a user) of a usage history of electronic money and bank account transaction data (hereinafter referred to as a user) uses a dedicated area in a server on a computer network or each usage. Download and save electronic money usage history and bank account transaction data (hereinafter referred to as history information) from the custodian of electronic money usage history and bank account transaction data (hereinafter referred to as custodian). Means for similarly installing and storing history information extracted from a dedicated terminal and network, means for converting the stored data into a fixed format, and means for converting the stored data into a journal entry format for double entry bookkeeping And the item that is missing in the journal entry data for double entry bookkeeping using the account list arbitrarily created for this converted data And means for adding a finished, which is a general-purpose accounting database creation system comprising: means for outputting the journal data of the completed double-entry bookkeeping to form the user selects, the.

  (2) Further, the present invention includes means for verifying the identity by using member information and a password when the user downloads history information stored by the custodian.

  (3) Further, the present invention creates an original account database in order to use the account system used in the financial accounting system and other management systems used by the user in this system. Including means for using

  (4) Further, in the history information managed by the custodian, when there are two or more transaction elements in one transaction, the present invention divides the data into two or more data when determining the account item, Includes means to create journal entries for double entry bookkeeping.

  (5) In addition, the present invention includes means for the user to arbitrarily set additional information such as value added tax information in the journal entry data for double entry bookkeeping.

  (6) Further, the present invention includes means for arbitrarily setting the data output form by the user.

      (7) In addition, the present invention is a general-purpose database for pasting journal entry data, etc. for double-entry bookkeeping into transfer slips / books / sheets / spreadsheet software. Users can arbitrarily select output items, output data arrays and data attributes. And means for outputting in the form of each data to be outputted.

  (8) Further, the present invention includes means for storing the original history information downloaded initially and the processing history information which is a process until the history information is processed into journal data.

  (1) In the present invention, journal data is created using history items stored by the custodian using the account items that the user normally uses, and output in an output form that the user considers optimal is possible. Therefore, it is possible to flexibly cope with taking in journal data into an existing financial accounting system used by a user, transfer slips, a user's own management system, and the like.

  (2) In the present invention, since the account item to be used can be arbitrarily set, the account item system can be easily changed when the accounting policy is changed.

  (3) In the present invention, the user can arbitrarily set the format of the data to be output. Therefore, the output data format can be easily updated when the financial accounting system or the management system is updated or newly introduced (including transfer).・ It can correspond to the system after renewal.

  (4) Further, in the present invention, by displaying the processing / change history from the history information stored by the custodian who is the original form to the accounting information created by the user, the interested parties who use the accounting information can Validity can be proved.

  FIG. 1 is a schematic diagram of the system, FIG. 2 is a flowchart of processing performed by the system, FIG. 3 is a communication chart of the system and a user, FIGS. 4 to 7 and FIGS. Up to 13 are examples of the screen on the personal computer of this system. FIG. 8 is an example of conversion when the system downloads data downloaded from the custodian into the database, and FIG. 9 is an example of generating a composite journal.

  First, the user makes a contract for consenting to transfer the history information to the system based on the member registration with the custodian ((1) in FIG. 1). After the history information transfer agreement has been completed, the history information for which personal authentication is confirmed between the user and the custodian using the member ID, password, etc. is downloaded from the custodian database (FIG. 1 2) and FIG. 4). At this time, it is possible to specify a period of history information to be downloaded (FIG. 5) and check so as not to overlap with the next or previous download history information.

  If there is history information acquired by a user from a dedicated terminal or network, it is installed and stored in the system as in the case of acquisition by authentication (FIG. 4).

  When the user downloads the history information from the custodian, the downloaded history information is automatically stored as raw history information in the server or the user's personal computer without being processed. As a result, the basis for the original form of history information is secured for interested parties and tax authorities.

  When the user downloads the history information from the custodian, it is converted into a fixed format in this system regardless of the form of the custodian's history information (FIG. 8). At this time, on the format, items with data are linked, and blanks are set for items with no corresponding data. If there is no description of the amount, it is automatically calculated from the difference and applied. As a result, the user who has finished setting account items can always start generating journals from the same format regardless of the form of the history information of the custodian.

  The user freely sets the account item database in order to use the account item used by the user in this system (FIGS. 6 and 7). At this time, the account item is set according to the financial accounting system and the management system used by the user to prepare for later output. An account database that is generally used in the initial settings is prepared, but the account database is edited in accordance with the financial accounting system and management system to be posted after the data is completed, or the book organization already determined. I can do it. At this time, subject codes, auxiliary codes, and additional information that are predetermined in the system used by the user can also be set.

  The user who has finished setting the account item moves to the journal data processing screen (FIGS. 6 and 9-1, 2). Here, the deficiency information such as the account item and additional information set by the user is added to the format automatically generated in FIG. 8 to complete the journal data. 9-2 is an example of added information. At this time, since the account item such as electronic money is automatically set as a credit when used (decrease) and as a debit when replenished (increased), the user inputs only the opposite item. Further, in the case of a composite transaction in which a plurality of uses are included in one transaction, one transaction history can be divided and two or more journals can be created (FIG. 10).

  When the user inputs the shortage information and finalizes the completed data, the screen shifts to a screen (FIGS. 6 and 11-1, 2) for selecting the output format of the completed accounting / journal data. At this time, a cash book such as cash book is automatically generated as a basic database. It has a function as an accounting book by enabling the output of the accounting book.

  In the output format selection (Fig. 11-1), select general-purpose data that can be pasted to general transfer slips, cashbooks such as electronic money, and spreadsheet software, and data output in a format specified by the user. I can do it.

  With the transfer slip format, users who have not digitized their accounting books can use this system to save time for drafting by hand.

  The output in the cash register format satisfies the listability as the original form and the function as the accounting book. It can also be used as balance confirmation data.

  Output in general-purpose data format can be pasted into commercially available spreadsheet software and generates a general-purpose database that is assumed to be used in the management system used by users. Basically, it is output in a journal format.

  The output in the specified output format can be completed on the system, the network, and the user's personal computer from use of electronic money to book entry. This output form is for conversion into a CSV data array required by the financial accounting system or management system used by the user, and the user can freely set the array and data attributes (FIG. 12). In this case, data output in CSV format or text format can be selected, and the array and data format can be changed each time.

  When all the processes are completed, the processed journal data is saved (FIG. 13), and the process ends.

  At the end, the operation history from the download of the history information of the custodian to the generation of the journal is stored, so that the credibility of the accounting information as viewed from the tax authority and the third party is ensured.

It is an operation schematic diagram of this system. Although it is a network diagram that connects the server of the issuing company and the user's computer, for simplicity, only two users are described. It is a flowchart of the process which this system performs taking the historical information of the present electronic money issuing company as an example. It is a communication chart between a user and this system. It is an illustration of the screen display of the authentication system when history information is downloaded from the custodian server in this system. It is an example of the screen which sets the period of the historical information which a user requires. It is an example of the entrance screen which selects a function, such as processing of the downloaded history information. It is an example of the screen which a user sets an account item. It is an example of the procedure which converts the history information of a custodian into a fixed format which this system performs. The usage amount type, balance type, and bank type roughly classify the current data format of the custodian. It is an illustration of a screen display immediately before a user processes history information in this system. It is an illustration of the result of the user processing FIG. The italic letters are the parts that have been additionally processed. It is an example of split book entry when a plurality of transactions / uses are included in one transaction. It is an example of the screen which selects an output format. It is an example of the screen which designates the output period of the data of the format selected in FIG. It is an example of the screen which sets the output form which a user specifies uniquely. It is an example of an end screen.

Claims (7)

  The usage history of electronic money, etc. and the bank account transaction data (hereinafter referred to as “user”) in the dedicated area in the server on the computer network or in each user's computer Similar to the means to download and store the usage history of electronic money and bank account transaction data (hereinafter referred to as history information) from the transaction data custodian (hereinafter referred to as custodian) and the history information extracted from the dedicated terminal and network Means for installing and storing the data, means for converting the stored data into a fixed format, means for converting the stored data into a journal entry format for double entry bookkeeping, and an account list arbitrarily created for the converted data To complete and add the missing items to the journal entry data of double-entry bookkeeping, and completed double-entry book Accounting database creation system comprising: means for outputting the journal data to a format that the user selects, the.   3. The accounting database creation system according to claim 2, comprising means for verifying the identity based on member information and a password when the user downloads history information stored by the custodian.   In claim 1, in order to use the account system used in the financial accounting system and other management systems used by the user in this system, the means for creating and using the original account database Including accounting database creation system.   In the history information managed by the custodian in claim 1, when there are two or more transaction elements in one transaction, it is divided into two or more data at the time of determining the account item, so-called compound journal double entry book entry An accounting database creation system that includes means for creating data.   5. The accounting database creation system according to claim 1, 3 and 4, further comprising means for the user to arbitrarily set additional information such as value added tax information in the journal entry data for double entry bookkeeping.   Claims 1 and 6, general-purpose database for pasting journal entry data, etc. for double-entry bookkeeping to transfer slips / books / spreadsheets / users arbitrarily selecting output items, output data arrays and data attributes An accounting database creation system including means for outputting each form of output data.   6. The means for storing the original history information downloaded initially, the original history information extracted from the dedicated terminal initially, and the processing history information as a process until the history information is processed into journal data according to claim 1, 4 and 5. Including accounting database creation system.

Images