JP2020194584A - Accounting apparatus, accounting method, and accounting program - Google Patents

Abstract

To provide an accounting apparatus, an accounting method, and an accounting program which are simple and inexpensive.SOLUTION: An accounting apparatus 100 includes a web server 110, a database 120 connected to the web server 110 by a VPN, and a scraping server 130 connected to the database 120 by a VPN technique. A user accesses a URL of the web server 110 by using a web browser of a computer 140. The web server 110 identifies loaded web detail data for each transaction, and automatically classifies each transaction into a specific account title on the basis of a statement of transaction content of each transaction. At this time, the web server 110 refers to a correlation table for retaining correlations between keywords included in the statement of the transaction content and the account titles.SELECTED DRAWING: Figure 1

Description

The present invention relates to an accounting device, an accounting method and an accounting program, and more particularly to an accounting device, an accounting method and an accounting program for performing accounting by cloud computing.

It is a rule that corporate accounting is carried out in accordance with the corporate accounting principles that have been developed as a custom, and one of the principles is the principle of "accrual accounting" for the income statement (P / L). Accrual basis is the principle that income or expense must be accounted for when it occurs, regardless of the actual income and expenditure of cash. This is the opposite concept of cash basis, which recognizes income and expenses at the time of cash delivery.

Each company calculates income and expenditure for a certain period, makes a settlement to calculate profit or loss, and financial statements such as balance sheet (B / S) and income statement (P / L) prepared in the settlement. Is stipulated to be announced based on the provisions of the Company Law. In particular, in Japan, companies to which the Financial Instruments and Exchange Act are subject to strong time constraints regarding settlement of accounts, and quarterly settlement of accounts is required for listed companies, and quarterly settlement of accounts or semi-annual interim settlement of accounts even for unlisted companies. The need for settlement of accounts is similar in other countries.

In this way, if regular settlement processing is required and it is essential to prepare an income statement under the principle of accrual accounting, the settlement period will be avoided in order to avoid an excessive burden on the settlement period. Rather than looking back at the income statement, it is necessary to always process the income and expenses generated in daily work on a daily basis according to the principle of accrual accounting, which is also practical. That's how it's done.

For example, in a large company, there is an in-house system for accounting processing, and the person in charge of each department performs the work of journalizing the generated transaction into an account and registering it as journal data as a daily work. By accumulating journal data journalized in this way and creating journal data and general ledger data, it is possible to speedily create financial statements (financial statements) at each fiscal year end. Commercially available accounting software is often used to create financial statements such as balance sheets and income statements from the created general ledger data.

Ministry of Internal Affairs and Communications, 2011 Communications Usage Trend Survey (Corporate Edition), page 31

Although commercially available accounting software has the functions necessary to support such corporate accounting practices, it also has the drawback of being general-purpose software that can meet the demands of various companies.

In other words, not all companies that require accrual accounting are required to have a sense of speed in performing accrual accounting on a daily basis. When the applicant focused on small and medium-sized enterprises and sole proprietors rather than large enterprises, he found that commercial accounting software could not provide functions that fit the situation. In general, small and medium-sized enterprises and sole proprietors, including Japan, are required to settle accounts only once a year. At the time of this settlement, it is necessary to make a public announcement without delay in accordance with the provisions of the law, but at the time of annual settlement. It suffices to obtain journal data and general ledger data in line with the accrual principle, and it can be said that daily-based journal processing is unnecessary.

The present invention has been made in view of such problems, and its purpose is in line with the fact that SMEs and sole proprietors have loose timing restrictions on the principle of accrual accounting. It is an object of the present invention to provide a simple and inexpensive accounting processing device, accounting processing method and accounting processing program.

In order to achieve such an object, the first aspect of the present invention is an accounting processing device for performing accounting processing by cloud computing, comprising a web server that provides cloud computing to a user, and described above. The web server identifies the web statement data for each transaction, and keeps the correspondence between the keywords and the accounts that can be included in the description of the transaction content, based on the description of the transaction content of each transaction. It is characterized by automatically journalizing to a specific account by referring to the correspondence table and creating journal data including at least the date, transaction content, amount and account.

A second aspect of the present invention is characterized in that, in the first aspect, the web detail data includes a plurality of types of web detail data provided by a plurality of financial institutions, credit card companies, or settlement companies. To do.

In addition, a third aspect of the present invention is characterized in that, in the first or second aspect, the web specification data includes electronic data obtained by photographing a receipt with a camera.

Further, in the fourth aspect of the present invention, in any one of the first to third aspects, the journal data created is transmitted to a computer on which the user accesses the web server, and the web browser of the computer is used. , Displayed as a journal processing screen, the journal processing screen is characterized by having a combo box for changing an account item.

A fifth aspect of the present invention is characterized in that, in the fourth aspect, the combo box is a nested interactive combo box.

Further, a sixth aspect of the present invention is characterized in that, in the fourth or fifth aspect, the generic correspondence table is updated by utilizing the accumulation of the correction result of the account by the combo box by each user. And.

Further, the seventh aspect of the present invention is, in any one of the fourth to sixth aspects, when the user selects and modifies the automatically journalized account from the combo box, for each user. As a user rule, it is characterized in that it is stored in the storage unit of the accounting processing device.

Further, in the eighth aspect of the present invention, in the seventh aspect, the similarity between the description of the transaction content of the journal entry target and the description of the existing transaction content held in the user rule is analyzed, and the journal entry target is described. It is characterized in that the description of the transaction content of is classified into the accounts associated with the description of the existing transaction content having a high degree of similarity.

A ninth aspect of the present invention is an accounting processing method for performing accounting processing by cloud computing provided by a web server, wherein the web server identifies web detailed data for each transaction. The web server identifies each transaction by referring to a generic correspondence table that holds an association between a keyword and an account that can be included in the description of the transaction content based on the description of the transaction content of each transaction. It is characterized by including a step of automatically journalizing into the account of the above, and a step of creating journal data in which the web server includes at least the date, transaction content, amount and account.

A tenth aspect of the present invention is an accounting processing program for performing accounting processing by cloud computing provided by a web server, wherein the web server is provided with a step of identifying web detailed data for each transaction. Automatically assign each transaction to a specific account by referring to the generic correspondence table that holds the association between the keywords and accounts that can be included in the description of the transaction content, based on the description of the transaction content of each transaction. It is characterized by including a step of making a journal entry and a step of creating journal data including at least a date, a transaction content, an amount, and an account.

According to one aspect of the invention, focusing on small businesses and individual business owners, web statement data is identified for each transaction on a web server that provides cloud computing to users, and each transaction is a transaction for each transaction. The principle of accrual accounting by automatically journalizing to a specific account by referring to the correspondence table that holds the correspondence between keywords and accounts that can be included in the description of the transaction content based on the description of the content. It is an object of the present invention to provide a simple and inexpensive accounting processing device, accounting processing method and accounting processing program in line with the fact that the timing restrictions to be followed are relaxed.

It is a figure which shows the accounting processing apparatus which concerns on one Embodiment of this invention. It is a figure which shows the journal processing screen which concerns on one Embodiment of this invention. It is a figure which shows the journal processing screen at the time of the adjustment of the automatically classified account. It is a figure which shows the list of the created journal data.

Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.

(Outline of the present invention)
In light of the fact that small and medium-sized enterprises and sole proprietors have loose timing restrictions to follow the principle of developmental principle, the present invention is not a daily basis, but an ex post facto web statement data (online / web status data). ) Is analyzed and journal processing is performed to create journal data.

In terms of using web detail data, the present invention currently limits the proportion of SMEs and sole proprietors who can benefit from it. That is, for example, the utilization rate of cloud computing in Japanese companies is only 9.1% as described in Non-Patent Document 1, that is, most of the resources on the Web are not utilized. The present invention has been made with a focus on small and medium-sized enterprises and sole proprietors for the first time, and in anticipation of future improvement in the utilization rate of cloud computing, and there is great advancement there. In the United States, for example, the usage rate of cloud computing is higher than in Japan, but there is room for improvement in the efficient use of web statement data.

FIG. 1 shows an accounting processing device according to an embodiment of the present invention. The accounting processing device 100 includes a web server 110 that provides cloud computing to users, a database 120 that is connected to the web server 110 by a virtual private network (VPN) technology, and a scraping server 130 that is connected to the database 120 by a VPN technology. And.

The user accesses the URL of the web server 110 by using the web browser of the computer 140 such as a PC, a smartphone, or a tablet. The web server 110 identifies the imported web detail data for each transaction, and automatically journals each transaction into a specific account based on the description of the transaction content of each transaction. It is possible to make journal entries such as income when the amount is positive and expenditure when the amount is negative. At this time, the web server 110 refers to a correspondence table that holds a correspondence between a keyword and an account that can be included in the description of the transaction content. The created journal data includes at least dates, transaction details, amounts, and accounts, for example, and the accumulation of such journal data becomes journal data.

The correspondence table and journal data may be stored in the web server 110, or may be stored in the database 120.

The web server 110 transmits an HTML program including the created journal data to the computer 140, which is displayed as a journal processing screen by the web browser of the computer 140 and presented to the user. Each function of the present invention can be implemented by Ruby and MySQL, and a part of it can be implemented by Javascript® in HTML (for example, the combo box of FIG. 3 described later). That is, the web server 110 operates as a means for executing each function by executing a program written in a language such as Ruby, and may be a single server or may be composed of a plurality of servers. ..

FIG. 2 shows a journal processing screen according to an embodiment of the present invention. The imported web statement data is identified for each transaction, and for each transaction, the date column 201 (“2012/11/30”), the amount column 202 (“-3,885”), and the summary column 203 indicating the transaction details (“EMOBILE”) -Minato-ku, Tokyo "), account column 204 ("communication cost "), description tag column 205, etc. that provides a separate division from the account are displayed.

The user can upload a file in a format such as CVS by himself / herself for importing the web detail data, but in one embodiment of the present invention, a web detail data acquisition unit automatically acquired from the Internet is further provided. be able to. Specifically, a scraping server 130 connected to the database 120 by VPN technology is arranged, a user registers, the account number and password stored in the web server 110 or the database 120 are read, and a financial institution is subjected to web scraping. Various web detailed data can be obtained from 151, a credit card company 152, a settlement company (eg, electronic money Suica (registered trademark)) (not shown), and the like. The acquired web detail data is stored in the web server 110 or the database 120, and is read out during the journal processing.

Further, instead of web scraping, the web detail data may be acquired by taking a receipt or the like with a camera and transmitting it to the web server 110. At this time, if it is implemented as an application for mobile terminals such as smartphones and tablets, when a receipt or the like is read into the application, it can be automatically incorporated into the user's account. In addition, electronic data such as receipts may be received by e-mail. In this case, if the receiving address includes the account associated with the user's account, the electronic data such as receipts will be analyzed. It can also be imported as web detail data. Examples of electronic data include PDF and image files. Further, instead of being received by the web server 110, the mail server (not shown) may receive and analyze the data, and the obtained web detail data may be transmitted to the web server 110. In addition to the receipt, it is also possible to record the occurrence of debt by taking a picture of the invoice with a camera and sending it to the web server 110. For example, when you receive an invoice, you can digitize it by camera photography and OCR, journalize it as a liability, and register it as a reminder of what you actually have to pay, and actually pay. When the payment is made, it is possible to manage which payment schedule was paid by matching the bank statement and the payment schedule. There is also a need to easily apply such payment schedules (accounts payable, accounts payable, etc.) and to respond to accrual accounting, and capturing images of receipts is also a useful function. In addition, such image capture of receipts, invoices, etc. makes it possible to link image data to each journal and facilitate voucher management.

In many cases, a plurality of types of web statement data provided by a plurality of financial institutions, credit card companies, settlement companies, etc. may be imported into the web server 110 and displayed on the transaction processing screen 200 for each type. As shown in FIG. 2, they may be displayed in chronological order.

Further, in FIG. 2, it is shown that journal data is created and stored by the user confirming the displayed contents and pressing the "register" button for each transaction. However, "registration" is shown. The journal data automatically created by the web server 110 by referring to the generic correspondence table may be stored as it is without the need to press the button, and only necessary corrections may be made on the transaction processing screen 200.

FIG. 3 shows a journal processing screen at the time of correction of automatically classified accounts. When the account field 204 is clicked, the journal processing screen 200 displays a combo box 301 such as a pull-down menu showing other options. By attaching help 302 to each option, it is possible to easily select an appropriate account without knowledge of accounting. If the combo box 301 is a nested interactive one, as shown, that is, the lower choices are shown according to the user's choice, the user can be intuitively navigated to the appropriate account. You can dress it up.

The modified result is saved in the web server 110 or the database 120 as a user rule for each user, and from the next time, the modified account can be displayed for the transaction content. The user rules for each user are well known in the technical field of accounting software, but if there is a correspondence table (generic correspondence table) independent of each user, it can be used immediately after creating an account without knowledge of accounting. It is possible to make journal entries, and the hurdle to start using it is overwhelmingly low. Since it is not possible to have a generic table that provides complete journals for all users, some corrections are required by each user, but at this time there is a combo box such as a pull-down menu with help. , You can easily select the appropriate account. Utilizing this accumulation of choices in combination with a correspondence table that is independent of each user not only makes it easier for users to start using it, but also provides high accuracy and realizes a user experience that did not exist in the past. To.

As for the description tag field 205, it is possible to automatically assign and display the description tag by referring to the generic correspondence table in the same way as the account, and in that case, the pull-down menu or the like as in the account field 204. You can display the combo box of and save / use the correction result.

As will be described later, enormous labor is required to prepare the generic correspondence table in advance, and due to this, the accounts and the like are automatically calculated by referring to the correspondence table prepared in advance as in the present invention. There was no technology to assign to the target. Accumulation of correction results by each user is useful information for updating the generic correspondence table to improve accuracy, and can be obtained because it is a cloud technology rather than a stand-alone application.

For example, when a user modifies an assignment, if a record of what kind of keyword is included in the description of the transaction content is assigned to what kind of account, for example, 5 or more users are the same. When the conditions such as assigning the description including the keyword to the same account are satisfied, the association between the keyword and the account can be added to the correspondence table. Further, a highly accurate update can be considered on condition that a predetermined number or more of users assign a description in which the same two keywords co-occur to the same account. More generally, the keywords included in the transaction description can be extracted by morphological analysis, and by recording which keyword is often registered as which account (or the probability is high). , You can find the relevance between keywords and accounts. For example, this association can also be defined by the amount of information, Bayesian probabilities, and the like.

The journal data created as described above can be displayed in a list on the web browser of the computer 140 as shown in FIG.

(Details of journal processing)
Even if you try to perform post-journal processing automatically using the web server 110, in reality, you need a correspondence table that associates the description of transaction details with the account, but to create it, It involves the accumulation and verification work of a huge amount of data. Considering the use in a large company, it can be seen that it is no longer possible in principle to create such a correspondence table. In large companies, transactions between companies are complicated, and many of the deposit and withdrawal destinations should be classified into different accounts for the same business partner. Therefore, it is impossible to automatically identify the account item from the description of the transaction details of the deposit / withdrawal details. Only by focusing on SMEs and sole proprietors who are not involved in inter-company transactions, it is possible to categorize the association between transaction details and accounts and create a correspondence table, and also focus on SMEs and sole proprietors. By doing so, the corresponding table can be commonly used as a generic corresponding table independent of each user. At the same time, by focusing on SMEs and sole proprietors, the number of frequently used accounts is limited and hierarchical organization becomes easier, and users using the interactive combo box as shown in Fig. 3 Graphical display is possible.

That said, even if the details of the transactions described in the web statement provided by banks, credit card companies, settlement companies, etc. are the same, there is considerable variation in the notation of each company, and the corresponding table The applicant also found that it was not easy to prepare. Therefore, in one embodiment of the present invention, by applying the amendment rule for correcting the notational fluctuation described in the summary column 203 indicating the transaction content, it is possible to remove substantially overlapping associations from the corresponding table.

For example, if "ANA" is listed in the transaction details column, it can be classified as "travel expense". In the actual web statement, the notation of "ANA" is not unified, and there are various notational fluctuations such as "ANA" and "ANA", so all of these are supported in the corresponding table. One method is to keep the attachment, but in one embodiment of the present invention, as described above, the correction rule is applied and the generic correspondence table itself is associated with, for example, "ANA" and "travel expense". Try to keep only.

The correction rule is that for the keywords held in the corresponding table, there are fluctuations in the alphabet, kana, or kanji notation, the presence or absence of bullets ("・"), or hyphens ("-"), minus. ("-") Or, it can be a rule to correct the notation fluctuation of the hyphen code. For example, if "ANA", "ANA", etc. exist in the description of the summary column 203, apply the correction rule, convert all of them to "ANA", and then refer to the corresponding table. can do. By doing so, it is sufficient to associate the alphabetical keyword "ANA" with the account item "travel expenses and transportation expenses" in the correspondence table.

In addition to the cases where the amendment rules can be set regularly in this way, the amendment rules can be individually extended or amended by looking at the description of the actual transaction details appearing in various web statements.

The correction rule may be stored in the database 120 and read by the accounting processing device 110, or may be stored in the memory of the accounting processing device 110.

In one embodiment of the present invention, the applicant has also found that there is a group of keywords in which the accounts journalized by industry are different. By applying the industry rules that associate keywords and industries with accounts, it is possible to achieve higher accuracy that cannot be dealt with by the generic correspondence table for all industries.

For example, when the supermarket name is described in the summary column 203, there is a high possibility that the purchase of consumables is made when an IT company makes a purchase, but when a restaurant makes a purchase, that is, the restaurant is a user. If it is, there is a high possibility of purchase.

(Keyword priority)
As mentioned above, the generic correspondence table holds the correspondence between the keywords that can be included in the description of the transaction content and the account, but if one transaction content contains multiple keywords, it is classified. Errors can increase.

For example, consider the transaction content of "Morozoff JR Osaka Mitsukoshi Isetan store". In this case, if you refer to the corresponding table in the "JR" part, it will be classified as "travel expenses" as an account, but the most likely thing is that you purchased a gift at "Morozoff". It is a situation and is a transaction that should be classified as "entertainment expenses". In other words, if it is possible to determine which of the multiple keywords is dominant in the accurate analysis of the transaction, the corresponding table should hold "Morozoff JR Osaka Mitsukoshi Isetan". It can be removed from and the number of keywords can be reduced. In order to analyze more web details with a small number of keywords and perform journal processing with high accuracy, it is possible to improve the accuracy by assigning priorities to the keywords.

For example, keywords can be prioritized as follows: The numbers indicate the priority.
1 item (item),
2 Business partner (partner),
3 Business category (biz_category),
4 Group name (corp_group),
5 Commercial facility name (building)

The numbers in parentheses are examples of keys for implementing priority rules. A business category is a word reminiscent of a business domain, such as "oil", "lunch box", and "stationery". The group name is a group name of a group company such as JR, Virgin, or GE. Commercial facility names are, for example, "Roppongi Hills", "Nordstrom" and the like.

Applicants have found that applying such priority rules clearly improves the accuracy of automatic journal entry for accounts. Even if you do not assign priorities up to the fifth, assigning priorities to items and business partners is effective.

Returning to the above example, in one embodiment of the present invention, "Morozoff", "JR", and "Isetan Mitsukoshi" are registered in the generic table, respectively, and "Morozoff" is a partner keyword that can be roughly inferred from transactions. , "JR" is registered as a diversified corporate group, and "Mitsukoshi Isetan" is registered as a commercial facility name. In the above example, referring to the corresponding table, these three keywords are partially matched, but among them, "Morozoff", which is considered to have the highest explanatory power, defines the account, and "Entertainment expenses" It is automatically displayed as a candidate.

When a plurality of keywords having the same priority are matched, keywords that partially match with a long number of characters can be matched in a higher order. For example, the accuracy of the description of the transaction content that partially matches the two keywords "ANA" and "Panasonic" cannot be improved unless the longer "Panasonic" is adopted.

On the contrary, it is also possible to exclude keywords with low explanatory power of transactions from matching targets. For example, if the keyword has "branch", it is not the transaction itself but the commercial facility that is the context in which the transaction was made, so by excluding it, it is included in the description of the transaction content. It is possible to leave keywords suitable for highly accurate automatic journals from a plurality of keywords. Other modifiers with high contextual descriptiveness include "inside" (at) and the like.

In many cases, place names only describe the context, and can be excluded as having low explanatory power of transactions.

(Complement of user rules)
Although user rules are useful for providing specific journals required for each user, which cannot be reached by generic tables, in reality, the description of transaction details included in the web statement data is in the case of the long tail. There is. That is, although the frequency of occurrence of the exact same transaction content more than once is not high, the description of the transaction content with such a low frequency of appearance may occupy a non-negligible ratio in the entire transaction. For example, even for the same type of transaction with the same business partner, the markings on the web statement data are not always the same. Even for the same business partner, if the financial institution of the digging source changes, the description will change, and the fact that the transferor can change the transferor's name also has an effect. In addition, some financial institutions have a unique control number for each transaction, and in such cases, the exact same description will not appear twice. Therefore, in addition to saving the result that appeared once in the past and modified by the user as the user rule of the user, the description of the new transaction content and the description of the existing transaction content held in the user rule are similar. It is possible to complement the function of the user rule by analyzing the degree and classifying it into the accounts associated with the description of the existing transaction contents with high similarity. For example, the degree of similarity can be obtained by dividing the description of new and existing transaction contents into morphological keywords by morphological analysis.

Specifically, for example, it is determined whether the description of the transaction content is retained as already mentioned in the user rule, and if it is not retained, whether the description of the similarity exceeding a certain threshold value is retained. If it is judged and none of them are retained, it is conceivable to journalize to a specific account by referring to the generic correspondence table. Clustering is effective for speeding up the calculation of similarity.

(E-commerce)
It is possible to acquire the purchase history data, purchase details data, etc. of the EC site as web details data to supplement the web details data acquired from the credit card company. When using an EC site, the specific content of the transaction may not be discernible from the web statement data obtained from a credit card company or the like. In such a case, by referring to the purchase history data or the like of the EC site, it is possible to specify what kind of transaction was made on that day with the amount of money. For example, in a generic table, the keyword "Amazon" is assigned to a virtual account, and subsequent journal entries refer to purchase history data obtained from Amazon based on dates, amounts, etc., for more detailed information on transactions. It should be done after specifying.

100 Accounting processing equipment 110 Web server 120 Database 130 Scraping server 140 Computer 151 Financial institution 152 Credit card company 200 Transaction processing screen 201 Date column 202 Amount column 203 Summary column 204 Account column 301 Combo box 302 Help

Claims (3)

It is an accounting processing device for accounting processing by cloud computing.
A web server that provides cloud computing to users, said web server
Identify web statement data for each transaction
Each transaction is automatically journalized to a specific account based on the description of the transaction content of each transaction, with reference to the association between keywords and accounts that can be included in the description of the transaction content.
An accounting device characterized in creating journal data that includes at least dates, transaction details, amounts, and accounts. It is an accounting method for performing accounting processing by cloud computing provided by a web server.
The step that the web server identifies the web statement data for each transaction,
The web server automatically assigns each transaction to a specific account based on the description of the transaction content of each transaction, referring to the association between keywords and accounts that can be included in the description of the transaction content. Steps to journal to
A method of accounting characterized in that the web server includes a step of creating journal data including at least dates, transaction details, amounts and accounts. It is an accounting processing program for performing accounting processing by cloud computing provided by a web server, and the web server is provided with an accounting processing program.
Steps to identify web statement data for each transaction,
A step of automatically journalizing each transaction to a specific account based on the description of the transaction content of each transaction, referring to the association between keywords and accounts that can be included in the description of the transaction content. ,
An accounting program for performing a method characterized by including steps to create journal data that includes at least dates, transaction details, amounts and accounts.

Images