Deposit processing device, deposit processing method, and deposit processing program

Abstract

To provide a payment processing device, a payment processing method, and a payment processing program that can reduce the workload and errors of the person in charge of payment processing by automatically categorizing the payment method when importing EB data and creating payment data. [Solution] The deposit processing device includes a deposit method conversion master 106a that registers transaction type, description, and deposit method in association with each other, and an EB data import unit 102a that acquires EB data including account date, transaction type, transaction amount, remitter, and description, and based on the EB data, refers to the master and creates deposit data including deposit method, currency unit, exchange rate, deposit amount, and deposit amount in yen acquired from the deposit method conversion master 106a, using the deposit number, deposit source, deposit date, transaction type and description of the EB data as keys.

Description

Technical Field

[0001] The present invention relates to a payment processing device, a payment processing method, and a payment processing program.

Background Art

[0002] Recently, EB (Electronic Banking) services, which are financial (e.g., banking) transaction services via a network, have become widespread. As a system for processing EB data, for example, there is Patent Document 1.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] However, even when importing EB data for payments (account transfers / fund transfers) for non-operating receivables or foreign exchange payments, payment data was created using the payment method of "transfer" in the same way as for payments for operating receivables. Since the necessary processing differs depending on the purpose of payment, after importing the EB data, it was necessary for the accounting staff to make a sorting judgment for each payment purpose of the payment data, resulting in a large workload and work mistakes.

[0005] The present invention has been made in view of the above, and an object thereof is to provide a payment processing device, a payment processing method, and a payment processing program capable of reducing the workload and work mistakes of the payment operations of the person in charge by automatically classifying the payment method when importing EB data and creating payment data.

Means for Solving the Problems

[0006] To solve the above-mentioned problems and achieve the objective, the present invention provides a deposit processing device equipped with a control unit, wherein the control unit is configured to access a master in which transaction categories, descriptions, and deposit methods are registered in association, and is equipped with EB data import means that acquires EB data including account date, transaction category, transaction amount, remitter, and description, and based on the EB data, refers to the master and creates deposit data including deposit number, deposit source, deposit date, transaction category and description of the EB data as keys, deposit method, currency unit, exchange rate, deposit amount, and deposit amount in yen obtained from the master.

[0007] Furthermore, according to one aspect of the present invention, the transaction category may include cash, bank transfer, or remittance, and the deposit method may include cash, bank transfer (in yen), foreign exchange deposit, fund transfer, or other deposit.

[0008] Furthermore, according to one aspect of the present invention, the control unit may also include a deposit processing means that modifies the currency unit, deposit amount, and exchange rate of the deposit data in response to the operator's operation on the deposit input screen, when the deposit method for the deposit data is a foreign exchange deposit.

[0009] Furthermore, according to one aspect of the present invention, the control unit further comprises billing processing means for creating billing data including billing number, scheduled collection date, currency unit, exchange rate, billing address, billing amount, and billing amount in yen, and the EB data import means, when creating the payment data, may obtain the currency unit, payment amount, and exchange rate from the billing data and set them in the payment data if the payment method of the payment data is foreign exchange payment, the scheduled collection date of the billing data matches the payment date of the payment data, the billing address of the billing data matches the payment source of the payment data, and the billing amount in yen of the billing data matches the payment amount in yen of the payment data.

[0010] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the present invention is a deposit processing method executed by an information processing device equipped with a control unit, wherein the control unit is configured to be able to access a master in which transaction categories, descriptions, and deposit methods are registered in association, and the method includes an EB data import step which is executed in the control unit to acquire EB data including account date, transaction category, transaction amount, remitter, and description, and based on the EB data, refers to the master and creates deposit data including deposit number, deposit source, deposit date, transaction category and description of the EB data as keys, and deposit method, currency unit, exchange rate, deposit amount, and deposit amount in yen obtained from the master.

[0011] Furthermore, according to one aspect of the present invention, a deposit processing program for an information processing device equipped with a control unit is provided, wherein the control unit is configured to access a master in which transaction categories, descriptions, and deposit methods are registered in association, and the program is characterized in that it causes the control unit to perform an EB data import step, which involves acquiring EB data including account date, transaction category, transaction amount, remitter, and description, and then, based on the EB data, referring to the master, and creating deposit data including deposit number, deposit source, deposit date, transaction category and description of the EB data as keys, deposit method, currency unit, exchange rate, deposit amount, and deposit amount in yen obtained from the master. [Effects of the Invention]

[0012] According to the present invention, when importing EB data and creating payment data, the payment method is automatically sorted, which has the effect of reducing the workload and errors of the person in charge of payment processing. [Brief explanation of the drawing]

[0013] [Figure 1] Figure 1 is a block diagram showing an example of the configuration of a deposit processing device according to this embodiment. [Figure 2] Figure 2 shows an example of the configuration of the payment method conversion master. [Figure 3]FIG. 3 is a diagram showing a configuration example of a deposit method master. [Figure 4] FIG. 4 is a diagram for explaining a specific example of the processing of the control unit of the deposit processing apparatus. [Figure 5] FIG. 5 is a diagram for explaining a specific example of the processing of the control unit of the deposit processing apparatus. [Figure 6] FIG. 6 is a diagram for explaining a specific example of the processing of the control unit of the deposit processing apparatus. [Figure 7] FIG. 7 is a diagram for explaining a specific example of the processing of the control unit of the deposit processing apparatus. [Figure 8] FIG. 8 is a diagram for explaining a specific example of the processing of the control unit of the deposit processing apparatus. [Figure 9] FIG. 9 is a diagram for explaining a specific example of the processing of the control unit of the deposit processing apparatus. [Figure 10] FIG. 10 is a diagram for explaining a specific example of the processing of the control unit of the deposit processing apparatus. [Figure 11] FIG. 11 is a diagram for explaining a specific example of the processing of the control unit of the deposit processing apparatus. [Figure 12] FIG. 12 is a diagram for explaining a specific example of the processing of the control unit of the deposit processing apparatus. [Figure 13] FIG. 13 is a diagram for explaining a specific example of the processing of the control unit of the deposit processing apparatus. [Embodiments for Carrying Out the Invention]

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

[0015] <00,00092> [1. Overview] , The overview of the present invention will be described in the order of [1-1. Problems / Background] and [1-2. Solution].

[0016] [1-1. Problems / Background] Traditionally, when importing EB data, even when importing EB data for non-operating receivables (account transfers / fund transfers) or foreign exchange deposits, the deposit data was created using the same "bank transfer" method as for operating receivables. As a result, after importing EB data, the accounting department had to decide how to categorize the deposit data according to its purpose, which resulted in a heavy workload and increased the likelihood of errors.

[0017] (Foreign exchange deposit) Companies that do not have foreign currency accounts receive payments from customers in foreign currency, which are then converted to yen by the bank and deposited into their yen account. Ideally, foreign currency settlements should be reconciled in the foreign currency, and exchange rate gains and losses should be calculated and recorded in the journal. However, since it is treated as a yen deposit, the deposit data is also registered in yen. In order to reconcile in foreign currency, it is necessary to import the deposit data and then change the yen deposit data to the foreign currency.

[0018] (Bank transfer / fund transfer) This is not used for reconciliation with trade receivables (payments for invoices issued from subsidiary ledgers). This is payment data that occurs through a transfer from a deposit at XX Bank to a deposit at YY Bank. In the case of such payments, after importing the payment data, instead of reconciling it with an invoice, a process called "payment transfer input" is performed, which links the journal entries from the subsidiary ledger to the financial accounting system: (1) Journal entry generated from the payment data: Cash / Deposits at YY Bank / Temporary receipts (deposits at YY Bank increase), and (2) Journal entry generated from the transfer data: Temporary receipts / Cash / Deposits at XX Bank (deposits at XX Bank decrease). At the same time, the status of the payment in the subsidiary ledger changes from unreconciled to reconciled.

[0019] Thus, the accounting processing after receiving a payment and the journal entries required will vary depending on the nature of the payment.

[0020] [1-2. Solution] Therefore, in this invention, by maintaining a master record that links the transaction category and description fields of EB data with the payment method (bank transfer, foreign exchange transfer, fund transfer, etc.), it enables automatic sorting of payment methods when EB data is imported, thereby reducing the workload and errors of the person in charge of payment operations.

[0021] The different deposit methods allow for the following operations: • It will be possible to create lists categorized by the purpose of payment in the payment statement, and to refer to payment data categorized by the purpose of payment. Previously, the type of deposit data was determined by visual inspection, but now it is possible to determine the purpose of the deposit based on the deposit details and perform the necessary processing (correction of deposit entry or deposit transfer entry) for each deposit method.

[0022] (Control of yen conversion processing when foreign currency deposits are made) As mentioned above, when a deposit is made as a "foreign exchange deposit," it is registered as yen in the deposit data. Since the customer is making a transfer in foreign currency, they change the deposit amount from yen to foreign currency during the deposit entry process. At this time, it is necessary to use the actual yen amount received as the correct amount.

[0023] Conventionally, when the amount is corrected to a foreign currency, the amount converted to yen is registered as data, which could ultimately lead to a discrepancy between the bank deposit balance and the deposit balance in the financial accounting. In this invention, the deposit method is controlled so that only foreign currency deposits are not converted to yen, thereby preventing the above discrepancy.

[0024] (Function Overview) (1) When importing EB data, the system maps the deposit method based on the combination of transaction type and description in the deposit and withdrawal details and then imports the data. (2) Deposit method: If the deposit is made via foreign currency deposit, the yen amount will be calculated independently when the foreign currency amount is corrected in the deposit entry.

[0025] The payment processing device of the present invention can be suitably used in the international logistics industry and other fields when managing accounts receivable (especially when handling large amounts of payment data and payment reserves).

[0026] [2. Structure] The configuration of the deposit processing device 100 according to this embodiment will be described with reference to Figure 1. Figure 1 is a block diagram showing an example of the configuration of the deposit processing device 100 according to this embodiment.

[0027] The deposit processing device 100 is a commercially available desktop personal computer. However, the deposit processing device 100 is not limited to stationary information processing devices such as desktop personal computers, but may also be portable information processing devices such as commercially available notebook personal computers, PDAs (Personal Digital Assistants), smartphones, or tablet personal computers.

[0028] As shown in Figure 1, the deposit processing device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the deposit processing device 100 is connected to communicate via any communication path.

[0029] The communication interface unit 104 connects the deposit processing device 100 to the network 300 via communication devices such as routers and wired or wireless communication lines such as dedicated lines. The communication interface unit 104 has the function of communicating data with other devices via communication lines. Here, the network 300 has the function of connecting the deposit processing device 100 and the bank's system 400 so that they can communicate with each other, and is, for example, the internet or a LAN (Local Area Network). The bank's system 400 provides EB services (EB website).

[0030] The input / output interface unit 108 is connected to an input device 112 and an output device 114. The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, mouse, microphone, or a monitor that works in conjunction with a mouse to provide pointing device functionality. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 as the keyboard 112 or mouse 112. Furthermore, the act of a user operating the input device 112 on the screen of the output device (monitor) 114 may be referred to as "user operation via UI".

[0031] The memory unit 106 stores various databases, tables, and files. The memory unit 106 also stores computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. As the memory unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

[0032] The storage unit 106 stores the payment method conversion master (master) 106a, payment method master 106b, EB data, payment data (payment header data, payment detail data), payment detail table, billing data (billing header data, billing detail data), etc. Figure 2 shows an example of the configuration of the payment method conversion master 106a. Figure 3 shows an example of the configuration of the payment method master 106b.

[0033] The payment method conversion master 106a is used to determine the payment method based on the transaction type and description of the EB data. As shown in Figure 2, it can consist of a table or the like that associates and registers the EB transaction type (EB transaction type CD and / or EB transaction type name), EB description, and payment method (payment method CD and / or payment method name).

[0034] As shown in Figure 3, the payment method master 106b can be composed of tables that associate and register payment method code, payment method name, account code, and account name.

[0035] EB data may include account date, transaction type, transaction amount, remitter name, and description.

[0036] Deposit data consists of deposit header data and deposit detail data. The deposit header data may include deposit number, deposit date, currency unit, EX.Rate (exchange rate), deposit amount, and deposit amount in yen. The deposit detail data may include deposit number, line, deposit source, deposit method, deposit amount, and deposit amount in yen.

[0037] Invoice data consists of invoice header data and invoice detail data. The invoice header data may include invoice number, due date, currency unit, EX.Rate, invoice amount, and invoice amount in yen. The invoice detail data may include invoice number, line, recipient, invoice amount, and invoice amount in yen.

[0038] The control unit 102 is a CPU or similar component that comprehensively controls the deposit processing device 100. The control unit 102 has internal memory for storing control programs such as the OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs.

[0039] The control unit 102 is configured to access the payment method conversion master 106a, payment method master 106b, EB data, payment data (payment header data, payment detail data), payment detail table, billing data (billing header data, billing detail data), etc., which are stored in the storage unit 106. Note that the payment method conversion master 106a, payment method master 106b, EB data, payment data (payment header data, payment detail data), payment detail table, billing data (billing header data, billing detail data), etc. may be located in another location (for example, on the server 200), as long as the control unit 102 can access them.

[0040] Functionally, the control unit 102 comprises an EB data acquisition unit 102a, a payment processing unit 102b, a billing processing unit 102c, a master maintenance unit 102d, and a screen display control unit 102e.

[0041] The EB data acquisition unit 102a downloads and acquires EB data from the bank's system 400 via the communication interface unit 104 and the network 300, stores it in the storage unit 106, and, based on the EB data, creates deposit data by referring to the deposit method conversion master 106a and stores it in the storage unit 106.

[0042] Specifically, the EB data import unit 102a acquires EB data including account date, transaction type, transaction amount, remitter, and description. Based on this EB data, it refers to the payment method conversion master 106a and creates payment data including payment method, currency unit, exchange rate, payment amount, and payment amount in yen, using the payment number, payment source, payment date, transaction type and description from the EB data as keys.

[0043] Transaction categories may include cash, bank transfer, or remittance, and deposit methods may include cash, bank transfer (in yen), foreign exchange deposit, fund transfer, or other deposits.

[0044] If the deposit method for the deposit data is a foreign exchange deposit, the deposit processing unit 102b modifies the currency unit, deposit amount, and exchange rate of the deposit data according to the operator's operation on the deposit input screen, and updates the deposit data stored in the storage unit 106.

[0045] The billing processing unit 102c creates billing data including the billing number, scheduled collection date, currency unit, exchange rate, billing address, billing amount, and billing amount in yen, and stores it in the storage unit 106. In this case, when the EB data import unit 102a creates the payment data, if the payment method for the payment data is a foreign exchange payment, and the scheduled collection date of the billing data matches the payment date of the payment data, the billing address of the billing data matches the payment source of the payment data, and the billing amount in yen of the billing data matches the payment amount in yen of the payment data, it may obtain the currency unit, payment amount, and exchange rate from the billing data and set them in the payment data.

[0046] The master maintenance unit 102d is used to configure settings such as data input, addition, modification, and updating for the payment method conversion master 106a and payment method master 106b in response to operator operations on a master maintenance screen (not shown).

[0047] The screen display control unit 102e controls the display and acceptance of input for various screens (for example, the master maintenance screen, the payment input screen, the billing input screen, etc.) displayed on the monitor 114.

[0048] [3. Specific Examples] A specific example of the processing of the control unit 102 of the deposit processing device 100 according to this embodiment will be described with reference to Figures 1 to 16. Figures 4 to 13 are diagrams illustrating a specific example of the processing of the control unit 102 of the deposit processing device 100 according to this embodiment.

[0049] (Flowchart for sorting payment methods when importing EB data) Referring to Figure 4, the flow for sorting payment methods when importing EB data will be explained for the cases of <Payment Method: Bank Transfer>, <Payment Method: Foreign Exchange Deposit>, and <Payment Method: Account Transfer / Fund Transfer>.

[0050] Figure 4 shows the flow of sorting by deposit method when importing EB data. Figure 4(A) shows the case where the deposit method is bank transfer, Figure 4(B) shows the case where the deposit method is foreign exchange deposit, and Figure 4(C) shows the case where the deposit method is account transfer / fund transfer.

[0051] <Payment Method: Bank Transfer> Refer to Figure 4(A) to explain the payment method: bank transfer flow. (1) EB data acquisition: Download EB data (deposit and withdrawal details) from the bank's system 400 to acquire the EB data. (2) EB data import process: Import EB data, create payment data, and check the payment details sheet. (3) Deposit Input: Confirm and correct EB import data, and input new deposit information. (4) Input of deposit allocation: Perform the allocation.

[0052] <Deposit Method: Foreign Exchange Deposit> Refer to Figure 4(B) to explain the deposit method: the flow of foreign exchange deposits. (1) EB data acquisition: Download EB data (deposit and withdrawal details) from the bank's system 400 to acquire the EB data. (2) EB data import process: Import EB data, create payment data, and check the payment details report. (3) Deposit entry: Correct the amount to the foreign currency (the yen amount will remain as it was at the time of deposit). (4) Input of deposit allocation: Allocation will be made in foreign currency.

[0053] <Deposit Method: Bank Transfer / Fund Transfer> Refer to Figure 4(C) to explain the flow of deposit methods: bank transfer and fund transfer. (1) EB data acquisition: Download EB data (deposit and withdrawal details) from the bank's system 400 to acquire the EB data. (2) EB data import process: Import EB data, create payment data, and check the payment details sheet. (3) Deposit Transfer Input: Transfer the deposited data to another account.

[0054] (Mapping of payment methods using the payment method conversion master) Referring to Figure 5, the mapping of payment methods using the payment method conversion master 106a will be explained.

[0055] Figure 5(A) shows an example of the configuration of the deposit method conversion master 106a. The deposit method conversion master 106a has fields for EB transaction type CD, EB transaction type name, EB description, deposit method CD, and deposit method name. EB transaction type and EB description are used as primary keys. If there is no agreement with the remitter, the EB description will be blank, so the EB description is set to blank. In the example shown in the figure, the first row is EB transaction code "10", EB transaction code name "Cash", EB description " ", deposit method code "01", deposit method name "Cash", the second row is EB transaction code "11", EB transaction code name "Bank Transfer", EB description " ", deposit method code "02", deposit method name "Bank Transfer (Yen)", the third row is EB transaction code "14", EB transaction code name "Transfer", EB description "399 Foreign Exchange Deposit", deposit method code "03", deposit method name "Foreign Exchange Deposit", the fourth row is EB transaction code "14", EB transaction code name "Transfer", EB description "Cash Deposit", deposit method code "04", deposit method name "Fund Transfer", the fifth row is EB transaction code "14", EB transaction code name "Transfer", EB description " The payment method is listed as "CD 05" and the payment method name as "Other Payment".

[0056] Figure 5(B) shows an example of the configuration of the deposit method master 106b. The deposit method master 106b has the fields for deposit method CD, deposit method name, account code CD, and account name. In the example shown in the figure, the first row has deposit method CD "01", deposit method name "Cash", account code "XXXX", and account name "Cash", and the second row has deposit method CD "02", deposit method name "Bank Transfer (Yen)", account code "YYYY", and account name "Current Account".

[0057] When importing EB data, the EB data import unit 102a refers to the deposit method conversion master 106a based on the combination of transaction type and description content of the EB data (deposit and withdrawal details) and maps the deposit method for import. There are two types of determinations for the deposit method mapping.

[0058] (1) When the EB transaction category and EB description match The payment method code (CD) from the payment method conversion master 106a is obtained using the EB transaction category and EB description from the EB data as keys.

[0059] (2) If there is no match in (1), the decision will be made based solely on the EB transaction type. The EB transaction type in the EB data is used as the key to retrieve the payment method code from the payment method conversion master 106a. For this purpose, the EB description: blank in the payment method conversion master 106a is used as a wildcard for identification.

[0060] (Control of payment method conversion) The control of deposit method conversion will be explained with reference to Figures 6 and 7. First, EB data (deposit and withdrawal details (Zengin)) is imported. The EB data import unit 102a imports the EB data, and based on the EB data, refers to the deposit method conversion master 106a to create deposit header data and deposit detail data. Based on the deposit header data and deposit detail data, a deposit detail table is created and registered in the storage unit 106. The "deposit category" of the deposit detail data is set by obtaining the deposit method CD from the deposit method conversion master 106a, using the "transaction category" and "description details" of the EB data as keys.

[0061] Figures 6(A) to 6(C) show examples of EB data. EB data includes the following fields: account date, transaction type, transaction amount, remitter name, and description.

[0062] In the example of EB data (1) shown in Figure 6(A), the account date is "2024 / 7 / 11", transaction type is "14", transaction amount is "1,000", remitter name is "ABC BUTSURYU", and description is "399 GAITAME SOUKIN".

[0063] In the example of EB data (2) shown in Figure 6(B), the account date is "2024 / 7 / 11", transaction type is "14", transaction amount is "2,000", remitter name is "PQR Butsuryu", and description is "Shikinido".

[0064] In the example of EB data (3) shown in Figure 6(C), the account date is "2024 / 7 / 11", transaction type is "14", transaction amount is "3,000", remitter name is "XYZ Butsuryu", and description is " ".

[0065] Figure 7(A) shows an example of deposit header data. The deposit header data includes the fields for deposit number, deposit date, currency unit, EX.Rate, deposit amount, and deposit amount in yen. In the example shown in the diagram, the first row contains the deposit number "N001", deposit date "2024 / 7 / 11", currency unit "JPY", EX.Rate "1.00", deposit amount "1,000", and deposit amount in yen "1,000". The second row contains the deposit number "N002", deposit date "2024 / 7 / 11", currency unit "JPY", EX.Rate "1.00", deposit amount "2,000", and deposit amount in yen "2,000". The third row contains the deposit number "N003", deposit date "2024 / 7 / 11", currency unit "JPY", EX.Rate "1.00", deposit amount "3,000", and deposit amount in yen "3,000".

[0066] Figure 7(B) shows an example of deposit detail data. The deposit detail data includes the following fields: deposit number, line, deposit source, deposit method, deposit amount, and deposit amount in yen. In the example shown in the figure, the first line is: deposit number "N001", line "1", deposit source "SEI001:ABC Logistics", deposit method "03:Foreign Exchange Deposit", deposit amount "1,000", and deposit amount in yen "1,000". The "Deposit Method" is set by obtaining "03:Foreign Exchange Deposit" from the deposit method conversion master 106a, using the transaction category "14" and description content "399 Foreign Exchange Deposit" from EB data (1) as keys.

[0067] The second line contains the following information: deposit number "N002", line "1", deposit source "SEI002:PQR Logistics", deposit method "04: Fund Transfer", deposit amount "2,000", and deposit amount in yen "2,000". The "Deposit Method" is set by obtaining "04: Fund Transfer" from the deposit method conversion master 106a, using the transaction category "14" and description "Fund Transfer" from EB data (2) as keys.

[0068] The third line contains the following information: deposit number "N003", line "1", deposit source "SEI003:XYZ Logistics", deposit method "05:Other deposit", deposit amount "3,000", and deposit amount in yen "3,000". The "Deposit Method" is set by obtaining "05:Other deposit" from the deposit method conversion master 106a, using the transaction category "14" and description content " " from EB data (3) as keys.

[0069] Figure 7(C) shows an example of a deposit statement. The deposit statement includes the following fields: deposit number, line, deposit source, deposit date, deposit method, currency, EX.Rate, and deposit amount. The operator checks the deposit method listed on the deposit statement and determines the necessary subsequent processing.

[0070] (Control of yen conversion when foreign currency deposits are made) Refer to Figures 8 to 11 to explain the control of yen conversion when receiving foreign exchange deposits. First, import EB data (deposit and withdrawal details (Zengin)). Figure 8 shows an example of EB data (4). In the example of EB data (4) shown in Figure 8, the account date is "2024 / 7 / 11", transaction type is "14", transaction amount is "3,202", remitter name is "ABC BUTSURYU", and description is "399 GAITAME SOUKIN".

[0071] The EB data import unit 102a creates payment data and payment detail data based on the EB data by referring to the payment method conversion master 106a, and creates a payment detail table based on the payment header data and payment detail data, and registers it in the storage unit 106.

[0072] Figure 9(A) shows an example of deposit header data. In the example shown in the figure, the first row contains the deposit number "N004", deposit date "2024 / 7 / 11", currency unit "JPY", EX.Rate "1.00", deposit amount "3,202", and deposit amount in yen "3,202".

[0073] Figure 9(B) shows an example of deposit details data. In the example shown in the figure, the first row contains the deposit number "N004", row "1", deposit source "SEI001:ABC Logistics", deposit method "03:Foreign Exchange Deposit", deposit amount "3,202", and deposit amount in yen "3,202". The "Deposit Method" is set by obtaining "03:Foreign Exchange Deposit" from the deposit method conversion master 106a using the transaction category "14" and description content "399 Foreign Exchange Deposit" from EB data (4) as keys.

[0074] Figure 9(C) shows an example of a deposit statement. The operator checks the deposit method listed on the deposit statement and determines the necessary subsequent processing. In this example, since the deposit method is foreign exchange deposit, it is necessary to change the currency, deposit amount, and EX.Rate by entering the deposit information. If you do not have a foreign currency account, the foreign currency amount and EX.Rate will not be stored in the EB data, so the EX.Rate as of the deposit date must be checked using the financial institution's service (such as BizStation).

[0075] If the deposit method for the deposit data is a foreign exchange deposit, the deposit processing unit 102b modifies the currency unit, deposit amount, and exchange rate of the deposit data according to the operator's operation on the deposit input screen, and updates the deposit data stored in the storage unit 106.

[0076] Figure 10(A) shows an example of the deposit input screen display (before modification), and Figure 10(B) shows an example of the deposit input screen display (after modification to foreign currency).

[0077] As shown in Figure 10(A), the deposit input screen includes fields for deposit number, deposit date, currency unit, deposit amount, The system includes a header section for specifying the EX.Rate, detail sections for specifying the deposit source, deposit method, and deposit amount, and a registration button (not shown). When the operator specifies (modifies) the data in the header and detail sections and presses the registration button (not shown), the deposit data is registered (modified / updated) according to the input on the screen.

[0078] When a deposit number is specified in the header section, the deposit data stored in the memory unit 106 is read using the specified deposit number as the key and displayed in the header section and the details section. In this example, the header section displays the deposit number "N004", the deposit date "2024 / 7 / 11", the currency unit "JPY", the deposit amount "3,202", and the EX.Rate "1.00", while the details section displays the deposit source "SEI001 ABC Logistics", the deposit method "03 Foreign Exchange Deposit", and the deposit amount "3,202".

[0079] Since the deposit method is foreign exchange deposit, the currency, deposit amount, and EX.Rate need to be changed. In this example, as shown in Figure 10(B), the currency unit is changed to "USD", the deposit amount to "20.01", and the EX.Rate to "160.00". When the registration button (not shown) is pressed, the deposit header data and deposit detail data are updated as shown in Figures 11(A) and (B). When the deposit amount in yen is recalculated, 160 × 20.01 = 3201.6 is rounded down to "3,201". In bank transfers, decimal places are generally rounded down.

[0080] (Automated control of yen conversion processing when foreign currency deposits are made) Referring to Figures 12 and 13, the following shows the flow for automatically registering (setting) the "currency unit, EX.Rate, and deposit amount" that were manually changed, based on the billing data, for the above-mentioned (control of yen conversion processing when foreign exchange deposits). Before importing EB data, register the receivable in the billing input.

[0081] The billing processing unit 102c creates billing data including the billing number, scheduled collection date, currency unit, exchange rate, billing recipient, billing amount, and billing amount in yen, and stores it in the storage unit 106.

[0082] Figure 12(A) shows an example of invoice header data. The invoice header data includes fields for invoice number, due date, currency unit, EX.Rate, invoice amount, and invoice amount in yen. In the example shown in the figure, the invoice number is "S001", due date is "2024 / 7 / 12", currency unit is "USD", EX.Rate is "150.00", invoice amount is "40", and invoice amount in yen is "6,000".

[0083] Figure 12(B) shows an example of invoice detail data. The invoice detail data includes the fields for invoice number, line, recipient, invoice amount, and invoice amount in yen. In the example shown in the figure, the invoice number is "S001", line is "1", recipient is "SEI001 ABC Logistics", invoice amount is "40", and invoice amount in yen is "6,000".

[0084] When creating deposit data, if the deposit method for the deposit data is a foreign exchange deposit, the EB data import unit 102a retrieves the currency unit, deposit amount, and exchange rate from the billing data and sets them in the deposit data if the scheduled collection date of the billing data matches the deposit date of the deposit data, the billing recipient of the billing data matches the deposit source of the deposit data, and the billing amount in yen of the billing data matches the deposit amount in yen of the deposit data.

[0085] Import EB data (deposit and withdrawal details (Zengin)). Figure 13(A) shows an example of EB data (5). In the example of EB data (5) shown in Figure 13(A), the account date is "2024 / 7 / 12", transaction type is "14", transaction amount is "6,000", remitter name is "ABC BUTSURYU", and description is "399 GAITAME SOUKIN".

[0086] When importing the above EB data, the currency unit, EX.Rate, and deposit amount will be retrieved from the billing data if the following acquisition conditions (1) to (4) are met.

[0087] (1) The deposit method to be converted from EB data must be "Foreign Exchange Deposit". (2) The scheduled collection date for the billing data and the payment date for the payment data must match. (3) The billing address in the billing details data and the payment source in the payment details data must match. (4) The billing amount in yen in the billing details data and the payment amount in yen in the payment details data must match.

[0088] In this example, since the acquisition requirements (1) to (4) above are met, deposit header data and deposit detail data are created and registered in the storage unit 106 based on the EB data and the currency unit, EX.Rate, and deposit amount obtained from the billing data, as shown in Figures 13(B) and (C).

[0089] As described above, according to this embodiment, a payment method conversion master 106a is registered by associating transaction type, description, and payment method, and an EB data import unit 102a is provided that acquires EB data including account date, transaction type, transaction amount, remitter, and description, and based on the EB data, refers to the master and creates payment data including payment method, currency unit, exchange rate, payment amount, and payment amount in yen obtained from the payment method conversion master 106a, using the payment number, payment source, payment date, transaction type and description of the EB data as keys. Therefore, when importing EB data and creating payment data, the payment method is automatically sorted, which reduces the workload and errors of the person in charge of payment operations.

[0090] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving operational efficiency and promoting appropriate management decisions by companies, thereby contributing to SDGs Goals 8 and 9.

[0091] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.

[0092] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.

[0093] [5. 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.

[0094] 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 or part of the processes described as being performed manually can be performed automatically by known methods.

[0095] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.

[0096] Furthermore, with respect to the deposit processing device 100, each component shown in the illustration is a functional concept and does not necessarily need to be physically configured as shown.

[0097] For example, the processing functions of the deposit processing device 100, particularly those performed by the control unit 102, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for the information processing device to execute the processing described in this embodiment, and is mechanically read by the deposit processing device 100 as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) contains a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.

[0098] Furthermore, this computer program may be stored on an application program server connected to the deposit processing device 100 via any network, and it is possible to download all or part of it as needed.

[0099] Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.

[0100] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.

[0101] The various databases stored in the memory unit 106 include memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0102] Furthermore, the deposit processing device 100 may be configured as an information processing device such as a known personal computer or workstation, or as an information processing device to which any peripheral devices are connected. Alternatively, the deposit processing device 100 may be implemented by implementing software (including programs or data, etc.) that realizes the processing described in this embodiment on the device.

[0103] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Explanation of Symbols]

[0104] 100 Deposit Processing Units 102 Control Unit 102a EB data acquisition unit 102b Deposit Processing Unit 102c Billing Processing Unit 102d Master Maintenance Department 102e Screen display control unit 104 Communication Interface Section 106 Storage section 106a Payment Method Conversion Master 106b Payment Method Master 108 Input / Output Interface Section 112 Input device 114 Output device 200 servers 300 Networks 400 Banking Systems

Claims

1. A deposit processing device equipped with a control unit, The control unit, It is configured to allow access to a master file that associates transaction type, description, and payment method. A deposit processing device is characterized by having an EB data import means that acquires EB data including account date, transaction type, transaction amount, remitter, and description, and based on said EB data, refers to the master and creates deposit data including deposit number, deposit source, deposit date, transaction type and description of said EB data as keys, and includes deposit method, currency unit, exchange rate, deposit amount, and deposit amount in yen obtained from the master.

2. The aforementioned transaction categories include cash, bank transfer, or remittance. The deposit processing device according to claim 1, characterized in that the deposit method includes cash, bank transfer (in yen), foreign exchange deposit, fund transfer, or other deposit.

3. The control unit further, The deposit processing device according to claim 1 or 2, characterized in that, when the deposit method for the deposit data is a foreign exchange deposit, it is provided with a deposit processing means that modifies the currency unit, deposit amount, and exchange rate of the deposit data in accordance with the operator's operation on the deposit input screen.

4. The control unit further, The system includes a billing processing mechanism that creates billing data including the billing number, scheduled collection date, currency unit, exchange rate, billing address, billing amount, and billing amount in yen. The deposit processing device according to claim 1 or 2, wherein when the deposit method for the deposit data is a foreign exchange deposit, if the scheduled collection date of the invoice data and the deposit date of the deposit data match, the billing address of the invoice data and the deposit source of the deposit data match, and the billing amount in yen of the invoice data and the deposit amount in yen of the deposit data match, the EB data import means obtains the currency unit, deposit amount, and exchange rate from the invoice data and sets them in the deposit data.

5. A deposit processing method performed by an information processing device equipped with a control unit, The control unit, It is configured to allow access to a master file that associates transaction type, description, and payment method. The control unit is executed as follows: A deposit processing method characterized by including an EB data import step, which involves acquiring EB data including account date, transaction type, transaction amount, remitter, and description, and then, based on the EB data, referring to the master, creating deposit data including deposit number, deposit source, deposit date, transaction type and description of the EB data as keys, and deposit method, currency unit, exchange rate, deposit amount, and deposit amount in yen obtained from the master.

6. A deposit processing program to be executed by an information processing device equipped with a control unit, The control unit, It is configured to allow access to a master file that associates transaction type, description, and payment method. The control unit, A deposit processing program that causes a computer to perform an EB data import process, which involves acquiring EB data including account date, transaction type, transaction amount, remitter, and description, and then, based on the EB data, referring to the master data to create deposit data including deposit number, deposit source, deposit date, transaction type and description from the EB data as keys, deposit method, currency unit, exchange rate, deposit amount, and deposit amount in yen obtained from the master data.

Images