JP7441188B2 - Business support devices, business support methods, and business support programs - Google Patents

Description

The present invention relates to a business support device, a business support method, and a business support program.

Financial institutions sometimes perform reconciliation operations that compare transaction information such as deposit balances and loan balances with journal information to check whether there are any errors in transaction information or journal information.

Patent Document 1 describes a collateral stock management system that is compatible with the stock certificate computerization system and is capable of acquiring stocks and the like as collateral and managing attribute information of collateral providers.

JP2008-269333A

However, in the past, reconciliation work was performed by checking book balances and journal entries with the human eye, so the precision and accuracy of checking for abnormalities (errors) varied depending on the knowledge level of the person in charge. was there. Furthermore, even if systems were developed, only simple comparisons were performed. In addition, in reconciliation work, there were no clear standards set for situations that would give a warning that an abnormality was on the verge of occurring, making it impossible for all parties involved to have a common understanding of the issues. In this way, there remained room for improvement in terms of accuracy, efficiency, and information sharing in reconciliation operations.

The present invention has been made in view of the above, and provides a business support device, a business support method, and a business support program that can improve accuracy and efficiency of reconciliation work and realize information sharing in reconciliation work. The purpose is to provide.

In order to solve the above-mentioned problems and achieve the purpose, a business support device according to the present invention is a business support device equipped with a control unit for supporting reconciliation business, and which has a warning classification or an error that means a warning. A master that holds the combination of error classification and threshold amount that means each account for each account, primary balance data that holds the management balance managed by a market system that is application software for each account, and application software. 1) second balance data that maintains account balances for each account, created based on journal entries managed by an accounting system; 2) Compare the absolute value of the difference between the account balance and the threshold amount for each account, and 2) If the absolute value exceeds the threshold amount, the warning classification or error classification associated with the account is compared. The present invention is characterized by comprising a collation means for executing a predetermined process that leads to information sharing among parties involved in reconciliation work on an account item basis.

Further, the business support method according to the present invention is a business support method that is executed by an information processing device including a control unit for supporting reconciliation business, wherein the information processing device is configured to perform a warning classification or a warning classification that means a warning. A master that holds a combination of error classification and threshold amount that means an error for each account, primary balance data that holds the management balance managed by a market system that is application software for each account, and an application. and second balance data that maintains account balances for each account, created based on journal entries managed by an accounting system that is software, and executed by the control unit, 1) Compare the absolute value of the difference between the total managed balance and the account balance and the threshold amount for each account, and 2) If the absolute value exceeds the threshold amount, the warning category or error associated with the account will be displayed. The present invention is characterized in that it includes a matching step in which a predetermined process that leads to information sharing between parties involved in reconciliation work is executed for each account item according to the classification.

Further, the business support program according to the present invention is a business support program to be executed by an information processing device including a control unit in order to support reconciliation business, and the information processing device has a warning classification meaning a warning. or a master that holds a combination of an error classification and a threshold amount that means an error for each account, and primary balance data that holds a management balance managed by a market system that is application software for each account; and second balance data that maintains account balances for each account, created based on journal entries managed by an accounting system that is application software, and for causing the control unit to execute; 1) Compare the absolute value of the difference between the total managed balance and the account balance and the threshold amount for each account, and 2) If the absolute value exceeds the threshold amount, a warning classification is assigned to the account. Alternatively, it is characterized by including a matching step of executing a predetermined process for each account item, which leads to information sharing among parties involved in reconciliation work, depending on the error category.

According to the present invention, it is possible to improve the accuracy and efficiency of reconciliation work and to realize information sharing in reconciliation work.

FIG. 1 is a block diagram showing an example of the configuration of a business support device 100. FIG. 2 is a diagram showing an example of the classification master 106a. FIG. 3 is a diagram showing an example of the managed balance data table 106b. FIG. 4 is a diagram showing an example of the account balance data table 106c. FIG. 5 is a flowchart relating to an example of a verification process executed by the business support device 100. FIG. 6 is a diagram showing an example of the absolute value of the difference between the total managed balance and the account item balance. FIG. 7 is a diagram showing an example in which the absolute value of the difference between the total managed balance and the account item balance is compared with the threshold amount.

Embodiments of a business support device, a business support method, and a business support program according to the present invention will be described in detail below based on the drawings. Note that the present invention is not limited to this embodiment.

[1. composition]
Here, an example of the configuration of the business support device 100 according to the present embodiment will be described with reference to FIG. 1 and the like. FIG. 1 is a block diagram showing an example of the configuration of a business support device 100.

The business support device 100 is a device for supporting reconciliation business in, for example, a financial institution, and is constructed based on a commercially available desktop personal computer. Note that the business support device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable type such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer. It may be an information processing device.

The business support device 100 includes a control section 102, a communication interface section 104, a storage section 106, and an input/output interface section 108. Each part included in the business support device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicatively connects the business support device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the business support device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that the data stored in the storage unit 106 may be stored in the server 200, for example.

An input device 112 and an output device 114 are connected to the input/output interface unit 108 . As the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. Note that in the following description, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving instructions to a CPU (Central Processing Unit) to perform various processes in cooperation with an OS (Operating System). As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc. can be used.

The storage unit 106 stores, for example, a classification master 106a, a management balance data table 106b, an account balance data table 106c, and the like.

FIG. 2 is a diagram showing an example of the classification master 106a. The classification master 106a corresponds to the master of the present invention. The classification master 106a includes account identification information (for example, account code) that identifies the accounts to be compared, and classification identification information (for example, 0: 1: Warning target, 2: Error target, etc.), which is neither a warning target nor an error target), and a threshold amount.

FIG. 3 is a diagram showing an example of the managed balance data table 106b. The managed balance data table 106b corresponds to the first balance data of the present invention. The management balance data table 106b includes foreign currency identification information for identifying foreign currency units (for example, foreign currency abbreviation), account identification information, customer identification information (for example, customer code and name of customer), and transaction identification. It includes information (for example, transaction number, etc.), a managed balance in foreign currency, and a managed balance in yen. The managed balance is managed by, for example, a market system (application software) installed in, for example, a financial institution that has installed the business support device 100. The managed balance may be obtained, for example, by linking transaction balance files from market systems. The managed balance includes, for example, the balance of funds (e.g. book value balance or principal), the balance of domestic bonds (e.g. book value or market capitalization (commitment)), the balance of foreign bonds (e.g. face value (delivery), book value). It may be an amount, market capitalization (commitment)), or collateral balance (for example, the balance of pledged collateral or the balance of collateral received). The managed balance data table 106b includes, for example, data type classification (e.g., "0": daily, "1": monthly), reference date (e.g., reference date included in transaction data managed by a market system). etc.), and coordination classifications (eg, "3020": funds, "3030": domestic bonds, "3040": foreign bonds, "3050": collateral balance), etc.

FIG. 4 is a diagram showing an example of the account balance data table 106c. The account balance data table 106c corresponds to the second balance data of the present invention. The account balance data table 106c includes foreign currency identification information, account identification information, customer identification information, account balances expressed in foreign currency, and account balances expressed in yen. The account balance data table 106c is created based on journal entries managed by an accounting system (application software) installed in, for example, a financial institution that has the business support device 100 installed.

Returning to FIG. 1, the control unit 102 is a CPU or the like that centrally controls the business support device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs specifying various processing procedures, required data, etc., and performs various information processing based on these stored programs. Execute.

The control unit 102 includes a collation unit 102a, which functionally and conceptually corresponds to the collation means of the present invention.

The matching unit 102a 1) compares the absolute value of the difference between the total managed balance and the account item balance and the threshold amount for each account item, and 2) if the absolute value exceeds the threshold amount, the account item A predetermined process that leads to information sharing among the parties involved in reconciliation work is executed for each account item according to the warning classification or error classification associated with the reconciliation work.

For example, the matching unit 102a records 1) that the comparison result was "normal" if the absolute value was less than or equal to the threshold amount, and 2) that the absolute value exceeded the threshold amount. 3) If a warning category was set in a case, a record (log) indicating that the comparison result was a "warning" was left, and 3) an error category was set in a case where the absolute value exceeded the threshold amount. In this case, a record (log) indicating that the comparison result is an "error" is recorded, and a notification process such as an e-mail notification is immediately executed to the relevant parties. This allows those involved to understand the results of the matching process by voluntarily checking the records (for example, at the start of work). In particular, when an error occurs, the person concerned can immediately grasp the result of the collation process from the notification information to that effect. It should be noted that, for example, if the OS is Windows (registered trademark), recording or checking the record may be achieved by using a function called an event viewer.

A specific example of the processing executed by each processing unit constituting the control unit 102 will be described in detail below.

[2. Specific example of processing]
Here, a specific example of the collation process executed by the business support device 100 will be described with reference to FIG. 5 and the like. FIG. 5 is a flowchart relating to an example of a verification process executed by the business support device 100. In this explanation, any one of the classification masters 106a1 to 106a4 shown in FIG. 7, the management balance data table 106b shown in FIG. 3, and the account balance data table 106c shown in FIG. 106 is assumed.

First, the matching unit 102a compares the absolute value of the difference between the total managed balance and the account item balance and the threshold amount for each account item (step S1).

In this explanation, first, based on the records stored in the management balance data table 106b shown in FIG. 3 and the records stored in the account balance data table 106c shown in FIG. Calculate the absolute value of the difference between the total managed balance and the account balance for "Gender)" in both foreign currency and yen amounts. As shown in FIG. 6, the calculated absolute values are the foreign currency difference "0" and the yen difference "9,862". FIG. 6 is a diagram showing an example of the absolute value of the difference between the total managed balance and the account item balance. Next, the calculated absolute value is compared with the threshold amount stored in the classification master 106a stored in advance in the storage unit 106 (see FIG. 7).

Example 1 shown in FIG. 7 is a comparative example in which the classification master 106a stored in advance in the storage unit 106 is the classification master 106a1. Example 2 shown in FIG. 7 is a comparative example in which the classification master 106a stored in advance in the storage unit 106 is the classification master 106a2. Example 3 shown in FIG. 7 is a comparative example in which the classification master 106a stored in the storage unit 106 in advance is the classification master 106a3. Example 4 shown in FIG. 7 is a comparative example in which the classification master 106a stored in advance in the storage unit 106 is the classification master 106a4.

Next, if the comparison result in step S1 is that the absolute value exceeds the threshold amount, the matching unit 102a determines the relationship of reconciliation work according to the warning classification or error classification linked to the account item. A predetermined process that leads to information sharing between parties is executed for each account item (step S2).

In the case of Examples 1 and 3 shown in FIG. 7, the yen difference "9,862" does not exceed the amount range "10,000" stored in the classification master 106a1 (106a3), so the matching unit 102a Since the comparison result of "normal" is left as a record (for example, by using an event viewer, etc.), the person concerned can check the specified monitoring screen (for example, provided by the event viewer) at any time (for example, when arriving at work). You can check the results with

In the case of Example 2 shown in FIG. 7, the yen difference "9,862" exceeds the amount range "1,000" stored in the classification master 106a2, so the verification unit 102a means "warning". A comparison result of "warning" is recorded according to the analysis category "1" (for example, by using an event viewer, etc.), so related parties can check the specified monitoring screen at any time (for example, when arriving at work). You can check the results (for example, as provided in Event Viewer). Then, for example, related departments can conduct a follow-up investigation to see if there is any concern that an abnormality may occur in the warning content.

In the case of Example 4 shown in FIG. 7, the yen difference amount "9,862" exceeds the amount range "1,000" stored in the classification master 106a4, so the verification unit 102a means "error". The comparison result of "error" is left as a record according to the analysis category "2" (for example, a record is left using an event viewer, etc.), and furthermore, the collation unit 102a immediately notifies related parties of the occurrence of an error by, for example, e-mail etc. Therefore, interested parties can immediately know the results. Then, for example, the related departments can check whether there is any abnormality in the data linkage processing, and if an abnormality is found, the system department can take necessary measures.

As a result of the above processing, the management balance managed by the market system and the account balance created based on the journal entries managed by the accounting system are compared for each account, and the absolute value is determined by the predetermined value. If the threshold amount is exceeded, a predetermined process that will lead to information sharing between parties involved in the reconciliation process is executed, so it is possible to improve the accuracy and efficiency of the reconciliation process and realize information sharing in the reconciliation process. can.

Further, according to the present embodiment, it is possible to automatically determine whether the book balance is in an appropriate state by classifying types such as abnormalities and warnings. Furthermore, according to the present embodiment, it is possible to check whether there are any excesses or deficiencies in the journal entries themselves or whether there is any data of concern, using a mechanism for linking journal entry data between an upstream market system and an accounting system in, for example, a financial institution. can. Further, according to the present embodiment, checkpoints for accounting balances, which tend to be tacit knowledge and require business knowledge, can be made explicit knowledge that can be shared by the organization.

[3. Contribution to the Sustainable Development Goals (SDGs) led by the United Nations]
This embodiment can contribute to improving business efficiency and promoting appropriate business decisions of companies, and thus can contribute to Goals 8 and 9 of the SDGs.

Furthermore, this embodiment can contribute to reducing waste loss and promoting paperless and electronic systems, making it possible to contribute to Goals 12, 13, and 15 of the SDGs.

Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

[4. Other embodiments]
In addition to the embodiments described above, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all of the processes described as being performed manually can be performed manually. Alternatively, some of the steps can be performed automatically using known methods.

In addition, unless otherwise specified, information including processing procedures, control procedures, specific names, parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings are included. It can be changed arbitrarily.

Further, regarding the business support device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions provided in the business support device 100, especially each processing function performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. Note that the program is recorded on a non-temporary computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processing described in this embodiment. Machine read to 100. That is, a storage unit such as a ROM or an HDD (Hard Disk Drive) stores a computer program that cooperates with an OS to give instructions to a CPU and perform various processes. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

Further, this computer program may be stored in an application program server connected to the business support device 100 via an arbitrary network, and it is also possible to download all or part of it as necessary. be.

Further, a program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, this "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPR. OM (registration) Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVDs (Digital Versatile Discs), Blu-ray (registered trademark) Discs, etc. shall include any “portable physical medium”.

Further, a "program" is a data processing method written in any language or writing method, and does not matter in the form of source code or binary code. Note that a "program" is not necessarily limited to a unitary structure, but may be distributed as multiple modules or libraries, or may work together with separate programs such as an OS to achieve its functions. Including things. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, and the installation procedure after reading.

The various databases stored in the storage unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and are used for various processing and website provision. Stores programs, tables, databases, web page files, etc.

Further, the business support device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. Further, the business support device 100 may be implemented by installing software (including programs, data, etc.) that causes the device to implement the processing described in this embodiment.

Furthermore, the specific form of dispersion and integration of devices is not limited to what is shown in the diagram, and all or part of them can be functionally or physically divided into arbitrary units according to various additions or functional loads. It can be configured in a distributed/integrated manner. That is, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively.

INDUSTRIAL APPLICABILITY The present invention is useful as an SOX audit in various industries, particularly financial institutions, such as listed companies and financial industries, where it is necessary to incorporate data consistency confirmation into the business flow during system coordination.

100 Business support device 102 Control unit
102a Collation unit 104 Communication interface unit 106 Storage unit
106a Classification master
106b Management balance data table
106c Account balance data table 108 Input/output interface section 112 Input device 114 Output device 200 Server 300 Network

Claims (3)

A business support device comprising a control unit for supporting reconciliation business,
A master that maintains a combination of a warning class that means a warning or an error class that means an error and a threshold amount for each account;
First balance data that maintains management balances for each account item managed by a market system that is application software;
Second balance data that maintains account balances for each account, created based on journal entries managed by an accounting system that is application software;
is accessible to
The control unit includes:
1) Compare the absolute value of the difference between the total managed balance and the account balance and the threshold amount for each account, and 2) If the absolute value exceeds the threshold amount , link it to the account and classify it as a warning. is set, a record corresponding to the comparison result is left, and if the absolute value exceeds the threshold amount and an error classification is set by linking it to the account, a record corresponding to the comparison result is left. To provide verification means to immediately send notifications to the parties involved in the reconciliation work while leaving the
A business support device featuring: A business support method executed by an information processing device including a control unit for supporting reconciliation business, the method comprising:
The information processing device includes:
A master that maintains a combination of a warning class that means a warning or an error class that means an error and a threshold amount for each account;
First balance data that maintains management balances for each account item managed by a market system that is application software;
Second balance data that maintains account balances for each account, created based on journal entries managed by an accounting system that is application software;
is accessible to
executed by the control unit,
1) Compare the absolute value of the difference between the total managed balance and the account balance and the threshold amount for each account, and 2) If the absolute value exceeds the threshold amount , link it to the account and classify it as a warning. is set, a record corresponding to the comparison result is left, and if the absolute value exceeds the threshold amount and an error classification is set by linking it to the account, a record corresponding to the comparison result is left. including a verification step for immediately sending the notification process to the parties involved in the reconciliation work ;
A business support method characterized by: A business support program to be executed by an information processing device including a control unit to support reconciliation business,
The information processing device includes:
A master that maintains a combination of a warning class that means a warning or an error class that means an error and a threshold amount for each account;
First balance data that maintains management balances for each account item managed by a market system that is application software;
Second balance data that maintains account balances for each account, created based on journal entries managed by an accounting system that is application software;
is accessible to
for the control unit to execute,
1) Compare the absolute value of the difference between the total managed balance and the account balance and the threshold amount for each account, and 2) If the absolute value exceeds the threshold amount , link it to the account and classify it as a warning. is set, a record corresponding to the comparison result is left, and if the absolute value exceeds the threshold amount and an error classification is set by linking it to the account, a record corresponding to the comparison result is left. including a verification step for immediately sending the notification process to the parties involved in the reconciliation work ;
A business support program featuring:

Images