Business support device, business support method, and business support program

Abstract

To provide a business support device or the like capable of reducing a business burden of a huge amount transaction in a financial institution.SOLUTION: A method acquires a prescribed number of digits from a slip division control master including an adjustment account title for adjusting disagreement between debit and credit and the prescribed number of digits for dividing a transaction value with a digit number, and acquires transaction data of a transaction amount larger than the prescribed number of digits with reference to the transaction data including the transaction amount. The method stores a maximum value of the prescribed number of digits as a division amount together with the transaction data in division transaction data, subtracts the maximum value from the acquired transaction amount, subtracts the maximum value from each subtraction result, performs repeating until the subtraction result is equal to or less than the maximum value, stores the maximum value as the division amount together with slip identification information, an account title, a transaction type and a store number in the division transaction data when the subtraction result is larger than the maximum value, and stores the subtraction result as the division amount together with the slip identification information, the account title, the transaction type and the store number in the division transaction data when the subtraction result is equal to or less than the maximum value to generate the division transaction data.SELECTED DRAWING: Figure 8

Description

Technical Field

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

Background Art

[0002] Patent Document 1 discloses a payment support device and the like that can facilitate the derivation of the payment amount for each person when multiple people split and pay the price.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] Here, for financial institutions, it is desired to develop a business support device that can reduce the business burden in large transactions.

[0005] The present invention has been made in view of the above problems, and an object thereof is to provide a business support device, a business support method, and a business support program capable of reducing the business burden in large transactions.

Means for Solving the Problems

[0006] In order to solve the above problems and achieve the object, a business support apparatus according to the present invention includes: a digit acquisition unit that acquires the predetermined number of digits from a first master including adjustment account items for adjusting lending discrepancies and a predetermined number of digits for dividing the transaction amount by the number of digits; a transaction data acquisition unit that refers to transaction data including voucher identification information, account items, transaction types, store numbers, and transaction amounts, and acquires transaction data of the transaction amounts greater than the acquired predetermined number of digits; a split transaction data generation unit that stores, as split amounts, the maximum value of the acquired predetermined number of digits, together with the voucher identification information, the account items, the transaction types, and the store numbers included in the acquired transaction data in split transaction data, then subtracts the maximum value from the acquired transaction amount, and then subtracts the maximum value from each subtraction result until the subtraction result is less than or equal to the maximum value. When the subtraction result is greater than the maximum value, the maximum value is used as the split amount and stored in the split transaction data together with the voucher identification information, the account items, the transaction types, and the store numbers. When the subtraction result is less than or equal to the maximum value, the subtraction result is used as the split amount and stored in the split transaction data together with the voucher identification information, the account items, the transaction types, and the store numbers to generate split transaction data.

[0007] Further, in order to solve the above problems and achieve the object, a business support apparatus according to the present invention includes: a share ratio acquisition unit that refers to a second master including a share ratio for the transaction amount and acquires account items, transaction types, the store number before sharing, and the share ratio; a split data import unit that acquires the split transaction data in which the acquired account items, transaction types, and the store number before sharing do not match, and imports the acquired split transaction data corresponding to the share transaction data; a split transaction data acquisition unit that acquires the split transaction data in which the acquired account items, transaction types, and the store number before sharing match; a share transaction data generation unit that divides the split amount included in the acquired split transaction data by the acquired share ratio, uses the division result as the share amount, and stores it in the share transaction data together with the voucher identification information and the account items to generate share transaction data.

[0008] In addition, in order to solve the above problems and achieve the object, a business support device according to the present invention allocates the accounting items included in the split transaction data of the same voucher identification information to a debit accounting item or a credit accounting item and stores them in journal data, allocates the split amount corresponding to the accounting item as a debit amount or a credit amount according to the allocation and stores it in the journal data, and further stores the voucher identification information in the journal data to generate journal data. A journal data generation unit; subtracting the total amount of the split amount corresponding to the credit accounting item from the total amount of the split amount corresponding to the debit accounting item stored in the journal data. When the subtraction result is "0", the process ends. When the subtraction result is a negative value, the first master is referred to, the adjustment accounting item corresponding to the debit accounting item is acquired, the value excluding the minus sign is used as the debit amount, and the acquired adjustment accounting item is used as the debit accounting item and stored in the journal data to adjust the journal. When the subtraction result is a positive value, the first master is referred to, the adjustment accounting item corresponding to the credit accounting item is acquired, the value is used as the credit amount, and the acquired adjustment accounting item is used as the credit accounting item and stored in the journal data to adjust the journal. It is further characterized by comprising a journal adjustment unit.

[0009] In addition, in order to solve the above-described problems and achieve the object, a business support apparatus according to the present invention classifies the accounting items included in the allocation transaction data of the same voucher identification information into debit accounting items or credit accounting items and stores them in journal data, stores the allocation amount corresponding to the accounting item as a debit amount or a credit amount in the journal data according to the classification, and further stores the voucher identification information in the journal data to generate journal data; a journal data generation unit; subtracts the total amount of the allocation amounts corresponding to the credit accounting items from the total amount of the allocation amounts corresponding to the debit accounting items stored in the journal data, and when the subtraction result is "0", the process ends, and when the subtraction result is a negative value, refers to the first master, acquires the adjustment accounting item corresponding to the debit accounting item, uses the value excluding the minus sign as the debit amount, stores the acquired adjustment accounting item as the debit accounting item in the journal data to adjust the journal, and when the subtraction result is a positive value, refers to the first master, acquires the adjustment accounting item corresponding to the credit accounting item, uses the value as the credit amount, and stores the acquired adjustment accounting item as the credit accounting item in the journal data to adjust the journal. The business support apparatus is further characterized by comprising a journal adjustment unit.

[0010] In addition, in order to solve the above-described problems and achieve the object, a business support method according to the present invention includes a digit acquisition step in which a digit acquisition unit acquires the predetermined number of digits from a first master including adjustment account items for adjusting the discrepancy between debit and credit and a predetermined number of digits for dividing the transaction amount by the number of digits; a transaction data acquisition step in which a transaction data acquisition unit refers to transaction data including voucher identification information, account item, transaction type, store number, and transaction amount, and acquires transaction data of the transaction amount greater than the acquired predetermined number of digits; and a divided transaction data generation step in which a divided transaction data generation unit stores the voucher identification information, the account item, the transaction type, and the store number included in the acquired transaction data in the divided transaction data with the maximum value of the acquired predetermined number of digits as the divided amount, then subtracts the maximum value from the acquired transaction amount, and then subtracts the maximum value from each subtraction result and repeats until the subtraction result becomes less than or equal to the maximum value. When the subtraction result is greater than the maximum value, the maximum value is used as the divided amount and stored in the divided transaction data together with the voucher identification information, the account item, the transaction type, and the store number. When the subtraction result becomes less than or equal to the maximum value, the subtraction result is used as the divided amount and stored in the divided transaction data together with the voucher identification information, the account item, the transaction type, and the store number to generate divided transaction data.

[0011] In addition, in order to solve the above problems and achieve the object, the business support program according to the present invention causes a computer to include: a digit acquisition unit that acquires the predetermined number of digits from a first master including adjustment account items for adjusting discrepancies in lending and borrowing and a predetermined number of digits for dividing the transaction amount by the number of digits; a transaction data acquisition unit that refers to transaction data including voucher identification information, account items, transaction types, store numbers, and transaction amounts, and acquires transaction data with a transaction amount greater than the acquired predetermined number of digits; and a maximum value of the acquired predetermined number of digits is used as the divided amount, and it is stored in the divided transaction data together with the voucher identification information, the account item, the transaction type, and the store number included in the acquired transaction data. Next, the maximum value is subtracted from the acquired transaction amount, and then the maximum value is subtracted from each subtraction result, and the process is repeated until the subtraction result is less than or equal to the maximum value. If the subtraction result is greater than the maximum value, the maximum value is used as the divided amount and stored in the divided transaction data together with the voucher identification information, the account item, the transaction type, and the store number. When the subtraction result is less than or equal to the maximum value, the subtraction result is used as the divided amount and stored in the divided transaction data together with the voucher identification information, the account item, the transaction type, and the store number to generate divided transaction data.

Effect of the Invention

[0012] The present invention can reduce the business burden in large transactions.

Brief Description of the Drawings

[0013]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Mode for Carrying Out the Invention

[0014] Hereinafter, embodiments of a business support apparatus, a business support method, and a business support program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited by this embodiment.

[0015] [1. Overview] Among various transactions in financial institutions, there are large-scale transactions such as hedge transactions. In such transactions, there has been a problem that it is difficult to grasp the amount of change in borrowing and lending when buying / selling occurs on both the debit / credit sides. In addition, since such large-scale transactions cannot be handled by conventional systems, manual processing is required and the business burden is large.

[0016] The present invention focuses on the fact that when registering a journal entry, the details and voucher units to be divided are determined according to certain conditions, enabling automatic accounting. Furthermore, the present invention can automatically identify auxiliary accounts and departments from each category and accounting item for which a transaction can be identified, and perform automatic voucher splitting (allocation processing) at a fine granularity. Moreover, it is possible to automatically correct the debit / credit discrepancies of each voucher and record the journal entry. As a result, it becomes possible to record the actual transaction amount and transaction details in hedge transactions and the like, and the business burden is reduced.

[0017] [2. Configuration] 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 the business support device 100.

[0018] The business support device 100 is constructed based on a commercially available desktop personal computer. Note that the business support device 100 is not limited to being constructed based on a stationary information processing device such as a desktop personal computer, and may be constructed based on a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer.

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

[0020] The communication interface unit 104 communicably 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 communicably connecting the business support device 100 and the server 200 to 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.

[0021] An input / output interface unit 108 is connected to an input device 112 and an output device 114. 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. In the following, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

[0022] The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 records a computer program for giving commands to the CPU (Central Processing Unit) in cooperation with the OS (Operating System) to perform various processes. 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, and an optical disk can be used.

[0023] The storage unit 106 stores a slip splitting control master 106a (corresponding to the first master of the present invention), a transaction allocation master 106b (corresponding to the second master of the present invention), transaction data 106c (corresponding to the transaction data of the present invention), split transaction data 106d (corresponding to the split transaction data of the present invention), allocated transaction data 106e (corresponding to the allocated transaction data of the present invention), journal data 106f (corresponding to the journal data of the present invention), and the like. Further, the business support device 100 may have a function of maintaining (new registration, modification, or deletion) various masters stored in the storage unit 106.

[0024] FIG. 2 shows an example of the information stored in the voucher split control master 106a. The voucher split control master 106a is for managing account item information for splitting and adjusting in transactions. As shown in FIG. 2, the voucher split control master 106a stores an allowable number of digits (corresponding to a predetermined number of digits of the present invention) for arbitrarily setting an appropriate split amount in consideration of the daily deposit and withdrawal scale for each financial institution, a debit account item and a credit account item (corresponding to the adjustment account item of the present invention) for adjusting the debit and credit balance, and a ControlKey, etc.

[0025] FIG. 3 shows an example of the information stored in the transaction allocation master 106b. The transaction allocation master 106b is for managing the allocation information of transactions. As shown in FIG. 3, the transaction allocation master 106b stores account items, transaction types, the store number before allocation, the store number after allocation, an allocation rate, etc.

[0026] FIG. 4 shows an example of the information stored in the transaction data 106c. The transaction data 106c is for managing the information of transactions. As shown in FIG. 4, the transaction data 106c stores a deposit / withdrawal classification, an account type, an account item, a transaction type, voucher identification information (e.g., voucher number, etc.), a row, a starting date, a store number, a yen amount (corresponding to the transaction amount of the present invention), and a voucher split Flg, etc.

[0027] FIG. 5 shows an example of the information stored in the split transaction data 106d. The split transaction data 106d is for managing the information of the split transactions. As shown in FIG. 5, the split transaction data 106d stores a deposit / withdrawal classification, an account type, an account item, a transaction type, voucher identification information, a row, a starting date, a store number, a yen amount (corresponding to the split amount of the present invention), and a voucher split Flg, etc.

[0028] FIG. 6 shows an example of information stored in the apportionment transaction data 106e. The apportionment transaction data 106e is for managing information on apportioned transactions. As shown in FIG. 6, the apportionment transaction data 106e stores the deposit / withdrawal classification, account type, account item, transaction type, voucher identification information, row, start date, store number, yen amount (corresponding to the apportioned amount of the present invention), voucher split Flg, and the like.

[0029] FIG. 7 shows an example of information stored in the journal entry data 106f. The journal entry data 106f is for managing journal entries. As shown in FIG. 7, the journal entry data 106f stores voucher identification information, posting date, debit account item, debit department, debit amount, row, credit account item, credit department, and debit amount, and the like.

[0030] Returning to FIG. 1, the control unit 102 is a CPU or the like that comprehensively controls the business support device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs defining various processing procedures, and required data, and executes various information processes based on these stored programs.

[0031] Functionally conceptually, the control unit 102 includes a split transaction data creation unit 102a (including the digit number acquisition unit, transaction data acquisition unit, and split transaction data generation unit of the present invention), an apportionment transaction data creation unit 102b (including the apportionment rate acquisition unit, split data import unit, split transaction data acquisition unit, and apportionment transaction data generation unit of the present invention), and a journal entry data creation unit 102c (including the journal entry data generation unit and journal entry adjustment unit of the present invention).

[0032] The split transaction data creation unit 102a executes the following processes (11) to (19) to generate the split transaction data 106d. (11) Import data related to the transaction (not shown) into the transaction data 106c and set 0 in the voucher split Flg. (12) Refer to the voucher split control master 106a to obtain the allowable digit number. (13) Refer to the transaction data 106c, and obtain from the transaction data 106c the data for which the amount split flag is "0" and the number of digits of the yen amount is greater than the allowable number of digits obtained from the voucher split control master 106a. (14) From the maximum value of the allowable number of digits obtained from the voucher split control master 106a, set the number of digits corresponding to the minimum unit input on the split setting screen (not shown) to 0 from the end. (15) Store the value in (14) in the yen amount of the split transaction data 106d. Store the debit / credit classification, account type, account item, transaction type, voucher number, start date, and store number of the data obtained in (13) in the split transaction data 106d. Further, add the line number "1", and store it in the split transaction data 106d with the voucher split Flg set to "1".

[0033] (16) Subtract the value in (14) from the yen amount of the data obtained in (13). If the subtraction result is less than or equal to the value in (14), store the subtraction result in the yen amount of the split transaction data 106d. Store the debit / credit classification, account type, account item, transaction type, voucher number, start date, and store number of the data obtained in (13) in the split transaction data 106d. Further, for the line number, add it by counting up from the maximum value of the line numbers with the same voucher number, and store it in the split transaction data 106d with the voucher split Flg set to "1". (17) Subtract the value in (14) from the yen amount of the data obtained in (13). If the subtraction result is greater than (14), store the value in (14) in the yen amount of the split transaction data 106d. Store the debit / credit classification, account type, account item, transaction type, voucher number, start date, and store number of the data obtained in (13) in the split transaction data 106d. Further, for the line number, add it by counting up from the maximum value of the line numbers with the same voucher number, and store it in the split transaction data 106d with the voucher split Flg set to "1".

[0034] (18) Subtract the value in (14) from the subtraction result in (17). If the subtraction result is less than or equal to (14), perform the process in (16). Subtract the value of (14) from the subtraction result of (19) and (17). If the subtraction result is greater than (14), store the value of (14) in the currency amount of the split transaction data 106d. Store the debit / credit classification, account type, account item, transaction type, voucher number, start date, and store number of the data obtained in (13) in the split transaction data 106d. Further, add the line number by counting up from the maximum value of the line numbers with the same voucher number, and store it in the split transaction data 106d with the voucher split Flg set to "1". Note that subtract the value of (14) from the subtraction result and repeat the process of (19) until the value becomes (14) or less. When the value becomes (14) or less, perform the process of (16).

[0035] The split transaction data creation unit 102b executes the following processes (31) to (36) to generate split transaction data 106e. (31) Refer to the split transaction data 106d and check for the existence of data that matches the account item, transaction type, and pre-allocation store number included in the transaction allocation master 106b. If there is, perform the following process (32). If not, do not perform the process. (32) Refer to the transaction allocation master 106b and obtain the account item, transaction type, pre-allocation store number, post-allocation store number, and allocation rate. (33) Obtain data from the split transaction data 106d that does not match the account item, transaction type, and pre-allocation store number obtained in (31), and import the obtained data into the split transaction data 106e corresponding to it. (34) Obtain data from the split transaction data 106d that matches the account item, transaction type, and pre-allocation store number obtained in (31).

[0036] For each same voucher number of the data obtained in (35) and (34), allocate according to the allocation ratio obtained in (32) in ascending order of line numbers, and store the allocation result in the yen amount of the allocated transaction data 106e. To the line number, add a value counted up from the maximum value of the line numbers of the same voucher number (if there is no line number, use "1"), and store the store number after allocation obtained in (32) in the store number. Note that for the debit / credit classification, account type, accounting item, transaction type, voucher number, start date, and voucher split flag of the allocated transaction data 106e, store the values of the data obtained in (34). (36) Perform the process in (35) for each piece of data obtained in (34). As a result, the allocated transaction data 106e is generated.

[0037] The journal entry data creation unit 102c executes the following processes (41) to (45) to generate journal entry data 106f. (41) Based on the generated split transaction data 106d or the generated allocated transaction data 106e, obtain the data with the same voucher number, and allocate it to the debit accounting item or the credit accounting item for each accounting item according to the general journal entry rules and store it in the journal entry data. Further, for the yen amount associated with the accounting item, store it in the debit amount or the credit amount of the journal entry data 106f according to the allocation of the accounting item. Note that the voucher number of the journal entry data 106f stores the voucher number of the corresponding record in the split transaction data 106d or the allocated transaction data 106e. Also, store the start date of the corresponding record in the split transaction data 106d or the allocated transaction data 106e in the posting date of the journal entry data 106f. Furthermore, store the store number of the record in the split transaction data 106d or the allocated transaction data 106e corresponding to the record of the journal entry data 106f in the debit department of the journal entry data 106f.

[0038] (42) Subtract the total credit amount from the total debit amount of the journal entry data 106f with the same voucher number generated in (41). (43) If the subtraction result in (42) is "0", end the process. When the subtraction result of (44) and (42) is a negative amount, refer to the voucher split control master 106a to obtain a debit account for adjustment. Store the obtained debit account for adjustment in the debit account of the journal data, and store the value obtained by removing the negative sign of the subtraction result in the debit amount. Note that the same voucher number as other records is stored in the voucher number of the journal data. The store number of the record of the transaction data 106c including the voucher number and the debit account (not the account for adjustment) is stored in the debit department. Also, the starting date of the record of the transaction data 106c including the voucher number and the debit account (not the account for adjustment) is stored in the posting date of the journal data.

[0039] When the subtraction result of (45) and (42) is a positive amount, refer to the voucher split control master 106a to obtain a credit account for adjustment. Store the obtained credit account for adjustment in the credit account of the journal data, and store the value of the subtraction result in the credit amount. Note that the same voucher number as other records is stored in the voucher number of the journal data. Also, the starting date of the record of the transaction data 106c including the voucher number and the debit account (not the account for adjustment) is stored in the posting date of the journal data.

[0040] [3. Specific Examples of Processing] (Voucher Split and Automatic Adjustment of Debit and Credit Balances) First, the split transaction data creation unit 102a takes in data related to the transaction, sets the voucher split flag "0", and generates the transaction data 106c shown in FIG. 8.

[0041] (Voucher Split) Next, the split transaction data creation unit 102a refers to the voucher split control master 106a in FIG. 8 and obtains the allowable digit number "13".

[0042] Next, the split transaction data creation unit 102a refers to the transaction data 106c in FIG. 8 and acquires the data of the voucher number "CBJ0001" which has an amount split flag of "0" and is larger than the allowable digit number "13". Hereinafter, the records of the deposit / withdrawal classification "deposit" in the transaction data 106c shown in FIG. 8 will be described, but the same processing will be performed on the records of the deposit / withdrawal classification "withdrawal".

[0043] Next, the split transaction data creation unit 102a sets the number of digits "4" corresponding to the minimum unit "thousand" input on the split setting screen (not shown) to "9,999,999,990,000 yen" with 0 at the end from the maximum value "9,999,999,999,999 yen" of the allowable digit number "13" acquired from the voucher split control master 106a. Considering the rounding process during consumption tax decomposition, the last 4 digits are set to 0. The number of digits at the end can be arbitrarily set on the split setting screen.

[0044] Next, the split transaction data creation unit 102a stores "9,999,999,990,000 yen" in the yen amount of the split transaction data 106d. The split transaction data creation unit 102a stores it together with the deposit / withdrawal classification "deposit", account type "bank", account item "ordinary deposit", transaction type "other", voucher number "CBJ0001", start date "2023 / 10 / 31", and store number "A" of the data acquired in the transaction data 106c in FIG. 8. Furthermore, a line number "1" is added and stored in the split transaction data 106d with the voucher split Flg set to "1" (see FIG. 8).

[0045] Next, the split transaction data creation unit 102a subtracts "9,999,999,990,000 yen" from the obtained yen amount of "21,000,000,000,000 yen" to calculate "11,000,000,010,000 yen". Since the calculated "11,000,000,010,000 yen" is greater than "9,999,999,990,000 yen", the split transaction data creation unit 102a stores "9,999,999,990,000 yen" in the yen amount item of the split transaction data 106d. The split transaction data creation unit 102a stores the deposit / withdrawal classification "deposit", account type "bank", account subject "ordinary deposit", transaction type "other", voucher number "CBJ0001", start date "2023 / 10 / 31", and store number "A" of the data obtained from the transaction data 106c in Fig. 8 in the split transaction data 106d. Furthermore, the split transaction data creation unit 102a adds "2", which is counted up from the maximum value "1" of the line number, to the line number, and stores it in the split transaction data 106d with the voucher split Flg set to "1" (see Fig. 8).

[0046] Next, the split transaction data creation unit 102a subtracts "9,999,999,990,000 yen" from the calculated "11,000,000,010,000 yen" to calculate "1,000,000,020,000 yen". Since the calculated "1,000,000,020,000 yen" is less than or equal to "9,999,999,990,000 yen", the split transaction data creation unit 102a stores "1,000,000,020,000 yen" in the yen amount item of the split transaction data 106d. The split transaction data creation unit 102a stores the deposit / withdrawal classification "deposit", account type "bank", account subject "ordinary deposit", transaction type "other", voucher number "CBJ0001", start date "2023 / 10 / 31", and store number "A" of the data obtained from the transaction data 106c in Fig. 8 in the split transaction data 106d. Furthermore, the split transaction data creation unit 102a adds "3", which is counted up from the maximum value "2" of the line number, to the line number, and stores it in the split transaction data 106d with the voucher split Flg set to "1" (see Fig. 8).

[0047] Through the above processing, the split transaction data creation unit 102a generates the data of the split transaction data 106d corresponding to the record including the deposit / withdrawal classification "Deposit" and the voucher number "CBJ0001" of the transaction data 106c shown in FIG. 8.

[0048] (Automatic adjustment of debit and credit balance) Based on the generated split transaction data 106d shown in FIG. 8, the journal entry data creation unit 102c acquires the data with the same voucher number "CBJ0001", and distributes it to the debit account "Securities" and the credit account "Regular Deposit" for each accounting item according to the journal entry rules, and stores it in the journal entry data 106f (see FIG. 9). Further, the journal entry data creation unit 102c also stores the yen amount associated with the accounting item in the debit amount or credit amount of the journal entry data 106f according to the distribution of the accounting item (see FIG. 9).

[0049] The journal entry data creation unit 102c stores the voucher number "CBJ0001" of the split transaction data 106d shown in FIG. 8 in the voucher number of the journal entry data 106f. Also, the journal entry data creation unit 102c stores the starting date "2023 / 10 / 31" of the split transaction data 106d shown in FIG. 8 in the posting date of the journal entry data 106f.

[0050] The journal entry data creation unit 102c stores the store number "A" corresponding to the accounting item "Securities" associated with the voucher number "CBJ0001" of the split transaction data 106d shown in FIG. 8 in the debit department of the journal entry data 106f.

[0051] The journal entry data creation unit 102c calculates the total amount (20,000,000,000,000 yen) of the debit amounts (9,999,999,990,000 yen + 9,999,999,990,000 yen + 20,000 yen) associated with the debit accounting item "Securities" shown in FIG. 9.

[0052] The journal entry data creation unit 102c calculates the total amount (21,000,000,000,000 yen) of the credit amounts (9,999,999,990,000 yen + 9,999,999,990,000 yen + 1,000,000,020,000 yen) associated with the credit account item "ordinary deposit" shown in FIG. 9.

[0053] The journal entry data creation unit 102c subtracts the total credit amount (21,000,000,000,000 yen) from the total debit amount (20,000,000,000,000 yen) to calculate "-1,000,000,000,000 yen". Since the journal entry data creation unit 102c has a negative amount, it refers to the voucher split control master 106a and obtains the debit account item "trust account debit".

[0054] The journal entry data creation unit 102c stores the obtained "trust account debit" in the debit account item, stores "1,000,000,000,000 yen" which is the positive value of the calculated "-1,000,000,000,000 yen" in the debit amount, and performs automatic correction so that the debit and credit balance is achieved. Also, the journal entry data creation unit 102c stores "CBJ0001" in the voucher number of the record of the debit account item "trust account debit" and the debit amount "1,000,000,000,000 yen" in the journal entry data 106f shown in FIG. 9 (see FIG. 9).

[0055] The journal entry data creation unit 102c refers to the transaction data 106c shown in FIG. 8 and stores the store number "A" of the record including the voucher number "CBJ0001" and the debit account item "securities" in the debit department of this record. Further, the journal entry data creation unit 102c refers to the transaction data 106c shown in FIG. 8 and stores the start date "2023 / 10 / 31" of the record including the voucher number "CBJ0001" and the debit account item "securities" in the posting date of this record (see FIG. 9).

[0056] (Voucher Split, Proportional Split, and Automatic Adjustment of Debit and Credit Balance) First, based on the voucher split control master 106a shown in FIG. 10 and the transaction data 106c shown in FIG. 10, the split transaction data creation unit 102a performs the above (voucher split) process to generate the split transaction data 106d shown in FIG. 11.

[0057] (Pro rata split) Referring to the split transaction data 106d shown in FIG. 11, since there is data in the transaction pro rata master 106b shown in FIG. 11 that matches the accounting item "securities", transaction type "retail", and pre-pro rata store number "A", the pro rata transaction data creation unit 102b performs the following process.

[0058] The pro rata transaction data creation unit 102b refers to the transaction pro rata master 106b shown in FIG. 11 and obtains the accounting item, transaction type, pre-pro rata store number, post-pro rata store number, and pro rata rate.

[0059] The pro rata transaction data creation unit 102b obtains records from the split transaction data 106d shown in FIG. 11 that do not match the accounting item "securities", transaction type "retail", and pre-pro rata store number "A" obtained from the transaction pro rata master 106b shown in FIG. 11, and stores them in the corresponding items of the pro rata transaction data 106e. In this case, the records where the accounting item in the split transaction data 106d shown in FIG. 11 is "ordinary deposit" correspond.

[0060] The pro rata transaction data creation unit 102b obtains records from the split transaction data 106d shown in FIG. 11 that match the accounting item "securities", transaction type "retail", and pre-pro rata store number "A" obtained from the transaction pro rata master 106b shown in FIG. 11. Hereinafter, among the obtained records of the split transaction data 106d in FIG. 11, the record with the minimum line number "1" (debit / credit classification "debit", accounting type "bank", accounting item "securities", transaction type "retail", voucher number "CBJ0001", start date "2023 / 10 / 31", store number "A", yen amount "9,999,999,990,000 yen", and voucher split Flg "1") will be used as an example for explanation.

[0061] The proportional transaction data creation unit 102b apportions the yen amount "9,999,999,990,000 yen" of the split transaction data 106d shown in FIG. 11 according to the apportionment rates "70" and "30" obtained from the transaction apportionment master 106b shown in FIG. 11, and calculates "6,999,999,993,000 yen" and "2,999,999,997,000 yen".

[0062] The proportional transaction data creation unit 102b stores the apportionment results "6,999,999,993,000 yen" and "2,999,999,997,000 yen" in the yen amount of the proportional transaction data 106e. The proportional transaction data creation unit 102b stores the values obtained from the split transaction data 106d in FIG. 11 in the debit / credit classification "debit", account type "bank", account item "securities", transaction type "retail", voucher number "CBJ0001", start date "2023 / 10 / 31", and voucher split Flg "1" of the proportional transaction data 106e for each record of the yen amount.

[0063] In the record of the apportionment result "6,999,999,993,000 yen" of the proportional transaction data 106e in FIG. 11, the proportional transaction data creation unit 102b stores the post-apportionment store number "A" associated with the apportionment rate "70" of the transaction apportionment master 106b in FIG. 11 as the store number. Furthermore, since there is no line number in the record of the apportionment result "6,999,999,993,000 yen" of the proportional transaction data 106e in FIG. 11, the proportional transaction data creation unit 102b stores the line number "1".

[0064] In the record of the apportionment result "2,999,999,997,000" of the proportional transaction data 106e in FIG. 11, the proportional transaction data creation unit 102b stores the post-apportionment store number "B" associated with the apportionment rate "30" of the transaction apportionment master 106b in FIG. 11 as the store number. Furthermore, in the record of the apportionment result "2,999,999,997,000" of the proportional transaction data 106e in FIG. 11, the proportional transaction data creation unit 102b stores the line number "2" obtained by counting up from the maximum value "1" of the line numbers of the same voucher number "CBJ0001".

[0065] Subsequently, the apportionment transaction data creation unit 102b performs the same process for the record with line number "2" among the data including the account item "securities", transaction type "retail", and pre-apportionment store number "A" of the apportionment transaction master 106b shown in FIG. 11 in the split transaction data 106d shown in FIG. 11, and then performs the same process for the record with line number "3".

[0066] As a result of this process, the apportionment transaction data creation unit 102b generates the apportionment transaction data 106e shown in FIG. 11.

[0067] (Automatic adjustment of debit and credit balance) Based on the generated apportionment transaction data 106e shown in FIG. 11, the journal entry data creation unit 102c retrieves the data with the same journal entry number "CBJ0001", and distributes and stores it in the journal entry data 106f according to the journal entry rules for each account item to the debit account item "securities" and the credit account item "general deposit" (see FIG. 12). Further, the journal entry data creation unit 102c also stores the yen amount associated with the account item in the debit amount or credit amount of the journal entry data 106f according to the distribution of the account item (see FIG. 12).

[0068] The journal entry data creation unit 102c stores the journal entry number "CBJ0001" of the apportionment transaction data 106e shown in FIG. 11 in each record of the journal entry data 106f. Also, the journal entry data creation unit 102c stores the starting date "2023 / 10 / 31" of the apportionment transaction data 106e shown in FIG. 11 in each record of the journal entry date of the journal entry data 106f.

[0069] The journal entry data creation unit 102c stores the store number of the record with the line number of the apportionment transaction data 106e shown in FIG. 11 corresponding to the line number of the journal entry data 106f in the debit department of the journal entry data 106f. For example, the journal entry data creation unit 102c stores the store number "A" of the record with line number "1" of the apportionment transaction data 106e shown in FIG. 11 corresponding to the line number "1" of the journal entry data 106f in the debit department of the journal entry data 106f.

[0070] Furthermore, the journal entry data creation unit 102c calculates the total amount (20,000,000,000,000 yen) of the debit amounts (6,999,999,993,000 yen + 2,999,999,997,000 yen + 6,999,999,993,000 yen + 2,999,999,997,000 yen + 14,000 yen + 6,000 yen) associated with the voucher number "CBJ0001" and the debit account "securities" shown in FIG. 12.

[0071] The journal entry data creation unit 102c calculates the total amount (21,000,000,000,000 yen) of the credit amounts (9,999,999,990,000 yen + 9,999,999,990,000 yen + 1,000,000,020,000 yen) associated with the voucher number "CBJ0001" and the credit account "ordinary deposit" shown in FIG. 12.

[0072] The journal entry data creation unit 102c subtracts the total amount of the credit amounts (21,000,000,000,000 yen) from the total amount of the debit amounts (20,000,000,000,000 yen) to calculate "-1,000,000,000,000 yen". Since the amount is negative, the journal entry data creation unit 102c refers to the voucher split control master 106a shown in FIG. 10 and obtains the debit account "trust account debit".

[0073] The journal entry data creation unit 102c stores the obtained "trust account debit" in the debit account, stores "1,000,000,000,000 yen" (excluding the minus sign of the calculated "-1,000,000,000,000 yen") in the debit amount, and performs automatic correction so that the debit and credit balance is achieved. Note that the journal entry data creation unit 102c stores "CBJ0001" in the voucher number of the record of this debit account "trust account debit" and debit amount "1,000,000,000,000 yen" in the journal entry data 106f shown in FIG. 12.

[0074] The journal data creation unit 102c refers to the transaction data 106c shown in FIG. 10 for the debit department of this record, and stores the store number "A" of the record including the voucher number "CBJ0001" and the debit account item "securities". Further, the journal data creation unit 102c refers to the transaction data 106c shown in FIG. 10 for the record's issue date, and stores the starting date "2023 / 10 / 31" of the record including the voucher number "CBJ0001" and the debit account item "securities".

[0075] The business support device 100 according to the embodiment can specify auxiliary items and departments from each category and account item for which transactions can be specified, automatically process voucher splitting (allocation splitting) with a fine granularity, and can record journal entries with automatic correction of the debit-credit balance mismatch for each voucher, and can record the actual transaction amount and transaction details in hedging transactions and the like.

[0076] [4. Contribution to the United Nations Sustainable Development Goals (SDGs)] According to this embodiment, since it can contribute to improving business efficiency and making appropriate business judgments for enterprises, it is possible to contribute to Goals 8 and 9 of the SDGs.

[0077] Also, according to this embodiment, since it can contribute to reducing waste loss and promoting paperless and digitization, it is possible to contribute to Goals 12, 13, and 15 of the SDGs.

[0078] Also, according to this embodiment, since it can contribute to strengthening control and governance, it is possible to contribute to Goal 16 of the SDGs.

[0079] [5. Other Embodiments] The present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims, in addition to the above-described embodiments.

[0080] For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be manually performed, or all or part of the processes described as being manually performed can be automatically performed by a known method.

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

[0082] Regarding the business support device 100, each illustrated component is a functional concept, and it is not necessarily physically configured as shown in the drawings.

[0083] For example, regarding the processing functions provided by the business support device 100, especially each processing function performed by the control unit, all or any part of them may be realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. Note that the program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing an information processing device to execute the processes described in this embodiment, and is mechanically read by the business support device 100 as necessary. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM, and constitutes the control unit in cooperation with the CPU.

[0084] In addition, this computer program may be stored in an application program server connected to the business support device 100 via an arbitrary network, and all or part of it can be downloaded as necessary.

[0085] Further, a program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium, or may be configured as a program product. Here, this "recording medium" includes any "portable physical medium" such as 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), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile Disk), and a Blu-ray (registered trademark) Disc, etc.

[0086] Also, the "program" is a data processing method described in any language or description method, and is not limited to forms such as source code or binary code. Note that the "program" is not necessarily limited to being configured singularly, and also includes those that are distributed as a plurality of modules or libraries, or those that achieve their functions in cooperation with separate programs typified by an OS. Regarding the specific configuration, reading procedure, and installation procedure after reading for reading the recording medium in each device shown in the embodiment, well-known configurations and procedures can be used.

[0087] The various databases and the like stored in the storage unit are storage means such as a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0088] 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 an arbitrary peripheral device is connected. Further, the business support device 100 may be realized by implementing software (including a program or data, etc.) for realizing the processing described in this embodiment in the device.

[0089] Furthermore, the specific form of the distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in arbitrary units according to various additions or according to the function load. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Industrial Applicability

[0090] The present invention is useful in various industries such as the financial industry including trust banks and the like.

Explanation of Signs

[0091] 100 Business support device 102 Control unit 102a Split transaction data creation unit 102b Allocation transaction data creation unit 102c Journal data creation unit 104 Communication interface unit 106 Storage unit 106a Voucher split control master 106b Transaction allocation master 106c Transaction data 106d Split transaction data 106e Allocation transaction data 106f Journal data 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims

1. A digit number acquisition unit that acquires the predetermined number of digits from a first master including adjustment account items for adjusting debit-credit discrepancies and a predetermined number of digits for dividing transaction amounts by the number of digits; A transaction data acquisition unit that refers to transaction data including voucher identification information, account items, transaction types, store numbers, and transaction amounts, and acquires transaction data of the transaction amounts greater than the acquired predetermined number of digits; Using the maximum value of the acquired predetermined number of digits as the split amount, it stores the voucher identification information, the account item, the transaction type, and the store number included in the acquired transaction data in the split transaction data. Next, it subtracts the maximum value from the acquired transaction amount, and then subtracts the maximum value from each subtraction result and repeats until the subtraction result is less than or equal to the maximum value. If the subtraction result is greater than the maximum value, it uses the maximum value as the split amount and stores it in the split transaction data together with the voucher identification information, the account item, the transaction type, and the store number. When the subtraction result is less than or equal to the maximum value, it uses the subtraction result as the split amount and stores it in the split transaction data together with the voucher identification information, the account item, the transaction type, and the store number to generate split transaction data. A split transaction data generation unit; A business support device comprising the above, characterized by that.

2. A share rate acquisition unit that refers to a second master including a share rate for the transaction amount and acquires an account item, a transaction type, a pre-allocation store number, and a share rate; A split data import unit that acquires the split transaction data in which the acquired account item, transaction type, and pre-allocation store number do not match, and imports the acquired split transaction data corresponding to the allocated transaction data; A split transaction data acquisition unit that acquires the split transaction data in which the acquired account item, transaction type, and pre-allocation store number match; The split amount included in the acquired split transaction data is allocated by the acquired share rate, and the allocation result is used as the allocated amount and stored in the allocated transaction data together with the voucher identification information and the account item to generate allocated transaction data. An allocated transaction data generation unit; The business support device according to claim 1, further comprising the above.

3. The accounting items included in the split transaction data of the same voucher identification information are classified into debit accounting items or credit accounting items and stored in the journal data. The split amount corresponding to the accounting item is stored in the journal data as a debit amount or a credit amount according to the classification, and further, the voucher identification information is stored in the journal data to generate journal data, a journal data generation unit; Subtract the total amount of the split amount corresponding to the credit accounting item from the total amount of the split amount corresponding to the debit accounting item stored in the journal data, If the subtraction result is "0", the process ends, If the subtraction result is a negative value, refer to the first master, obtain the adjustment accounting item corresponding to the debit accounting item, use the value excluding the negative sign as the debit amount, and store the obtained adjustment accounting item as the debit accounting item in the journal data to adjust the journal entry, If the subtraction result is a positive value, refer to the first master, obtain the adjustment accounting item corresponding to the credit accounting item, use the value as the credit amount, and store the obtained adjustment accounting item as the credit accounting item in the journal data to adjust the journal entry, a journal entry adjustment unit; The business support device according to claim 1, further comprising.

4. The accounting items included in the apportioned transaction data of the same voucher identification information are classified into debit accounting items or credit accounting items and stored in the journal data. The apportioned amount corresponding to the accounting item is stored in the journal data as a debit amount or a credit amount according to the classification, and further, the voucher identification information is stored in the journal data to generate journal data, a journal data generation unit; Subtract the total amount of the apportioned amount corresponding to the credit accounting item from the total amount of the apportioned amount corresponding to the debit accounting item stored in the journal data, If the subtraction result is "0", the process ends, If the subtraction result is a negative value, refer to the first master, obtain the adjustment accounting item corresponding to the debit accounting item, use the value excluding the negative sign as the debit amount, and store the obtained adjustment accounting item as the debit accounting item in the journal data to adjust the journal entry, If the subtraction result is a positive value, refer to the first master, obtain the adjustment accounting item corresponding to the credit accounting item, use the value as the credit amount, and store the obtained adjustment accounting item as the credit accounting item in the journal data to adjust the journal entry, a journal entry adjustment unit; The business support device according to claim 2, further comprising

5. a digit number acquisition step in which a digit number acquisition unit acquires the predetermined digit number from a first master including an adjustment account item for adjusting a debit / credit discrepancy and a predetermined digit number for dividing a transaction amount by the digit number; a transaction data acquisition step in which a transaction data acquisition unit refers to transaction data including voucher identification information, account item, transaction type, store number, and transaction amount, and acquires transaction data of the transaction amount greater than the acquired predetermined digit number; a divided transaction data generation step in which a divided transaction data generation unit stores, in divided transaction data, the voucher identification information, the account item, the transaction type, and the store number included in the acquired transaction data, with the maximum value of the acquired predetermined digit number as the divided amount, then subtracts the maximum value from the acquired transaction amount, and then subtracts the maximum value from each subtraction result, repeating until the subtraction result becomes less than or equal to the maximum value. When the subtraction result is greater than the maximum value, the maximum value is used as the divided amount, and is stored in the divided transaction data together with the voucher identification information, the account item, the transaction type, and the store number. When the subtraction result becomes less than or equal to the maximum value, the subtraction result is used as the divided amount, and is stored in the divided transaction data together with the voucher identification information, the account item, the transaction type, and the store number to generate divided transaction data; A business support method having the above.

6. A computer, a digit number acquisition unit that acquires the predetermined digit number from a first master including an adjustment account item for adjusting a debit / credit discrepancy and a predetermined digit number for dividing a transaction amount by the digit number; a transaction data acquisition unit that refers to transaction data including voucher identification information, account item, transaction type, store number, and transaction amount, and acquires transaction data of the transaction amount greater than the acquired predetermined digit number; Using the obtained maximum value of the specified number of digits as the split amount, store it in the split transaction data together with the voucher identification information, the account item, the transaction type, and the store number included in the obtained transaction data. Next, subtract the maximum value from the obtained transaction amount, and then subtract the maximum value from each subtraction result and repeat until the subtraction result is less than or equal to the maximum value. If the subtraction result is greater than the maximum value, use the maximum value as the split amount and store it in the split transaction data together with the voucher identification information, the account item, the transaction type, and the store number. When the subtraction result is less than or equal to the maximum value, use the subtraction result as the split amount and store it in the split transaction data together with the voucher identification information, the account item, the transaction type, and the store number to generate split transaction data, a split transaction data generation unit. A business support program that functions as such.

Images