Debt disposal device, debt disposal method and debt disposal program

Abstract

To provide a debt disposal device, debt disposal method and debt disposal program capable of compatibly achieving speedy acquisition of balance for each order received by debt recording for each business office and payment aggregated for each billed invoice.SOLUTION: A debt disposal device includes: order entry recording means for registering a slip number of cost information, a recording date, a payee, a cost item, and an amount of money in a storage area for each business office when an order entry is recorded; and debt determination means for extracting the cost information from the storage area using a designated payee as a key on a debt determination screen, inputting the billed invoice number of the extracted cost information to update the cost information, creating payment schedule data obtained by aggregating the amount for every billed invoice number, and registering the data in the storage area.SELECTED DRAWING: Figure 1

Description

[Technical field]

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

[0002] For example, in the logistics industry, there are cases where each business office records payables for each order received, and the payables are settled based on the invoices sent in a consolidated form to the representative business office. For example, there is Patent Document 1 as a conventional payable processing system. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Patent Publication No. 2021-46887 Summary of the Invention [Problem to be solved by the invention]

[0004] However, Patent Document 1 does not state anything about achieving both speedy understanding of income and expenditure for each order by recording payables for each business establishment and consolidated payments (debt determination) for each invoiced item.

[0005] The present invention has been made in consideration of the above, and aims to provide an debt processing device, a debt processing method, and a debt processing program that are capable of quickly grasping the income and expenditures of each order by recording debts for each business location, and of consolidating payments for each invoiced party. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention is an debtor processing device equipped with a control unit, which is configured to be able to access a memory area that stores cost information including the invoice number of the payee, which is the invoice number of the payee, voucher number, accounting date, payee, cost item, and amount, and which is characterized by comprising: an order recording means for recording, for each business establishment, the voucher number, accounting date, payee, cost item, and amount of the cost information in the memory area when recording an order; and a debtor determination means for extracting cost information from the memory area using the specified payee as a key on a debtor determination screen, inputting the invoice number of the extracted cost information to update the cost information, and creating scheduled payment data that aggregates amounts for each invoice number and registering it in the memory area.

[0007] According to another aspect of the present invention, the debt determination means may extract cost information from the storage area using a slip number specified in addition to the payee as a key.

[0008] According to another aspect of the present invention, the debt determination means may prepare a payment request for each payee based on the payment schedule data registered in the storage area.

[0009] According to another aspect of the present invention, the debt determination means may create evidence data that complies with the Electronic Bookkeeping Act for each invoice number and register the evidence data in the storage area.

[0010] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention provides an account receivable processing method executed by an information processing device equipped with a control unit, the control unit being configured to be able to access a memory area for storing cost information including the invoice number of the payee, which is the invoice number of the payee, voucher number, accounting date, payee, cost item, and amount, and the method includes an order recording process executed by the control unit for each business establishment when recording an order, which registers the voucher number, accounting date, payee, cost item, and amount of the cost information in the memory area, and an account receivable determination process for extracting cost information from the memory area using the payee specified as a key on an account receivable determination screen, inputting the invoice number of the extracted cost information to update the cost information, and creating scheduled payment data that aggregates amounts for each invoice number and registering this in the memory area.

[0011] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention is an payable processing program to be executed by an information processing device equipped with a control unit, the control unit is configured to be able to access a memory area that stores cost information including the invoice number of the payee, which is the invoice number of the payee, voucher number, accounting date, payee, cost item, and amount, and the control unit executes an order recording process in which, for each business establishment, when recording an order, the voucher number, accounting date, payee, cost item, and amount of the cost information are registered in the memory area, and an payable determination process in which, on an payable determination screen, cost information is extracted from the memory area using the payee specified as a key, the invoice number of the extracted cost information is input to update the cost information, and payment schedule data that aggregates amounts for each invoice number is created and registered in the memory area. Effect of the Invention

[0012] According to the present invention, it is possible to simultaneously realize speedy understanding of income and expenditure for each order by recording liabilities for each business location, and to make payments consolidated for each invoiced item. [Brief description of the drawings]

[0013] [Figure 1]FIG. 1 is a block diagram showing an example of the configuration of a debt processing device according to this embodiment. [Diagram 2] FIG. 2 is a diagram showing a process flow for explaining the overall process flow of the control unit of the debt processing device according to the present embodiment. [Diagram 3] FIG. 3 is a diagram for explaining a specific example of the process of the control unit of the debt processing device according to the present embodiment. [Figure 4] FIG. 4 is a diagram for explaining a specific example of the process of the control unit of the debt processing device according to the present embodiment. [Diagram 5] FIG. 5 is a diagram for explaining a specific example of the process of the control unit of the debt processing device according to the present embodiment. [Figure 6] FIG. 6 is a diagram for explaining a specific example of the process of the control unit of the debt processing device according to the present embodiment. [Figure 7] FIG. 7 is a diagram for explaining a specific example of the process of the control unit of the debt processing device according to the present embodiment. [Figure 8] FIG. 8 is a diagram for explaining a specific example of the process of the control unit of the debt processing device according to the present embodiment. [Figure 9] FIG. 9 is a diagram for explaining a specific example of the process of the control unit of the debt processing device according to the present embodiment. [Figure 10] FIG. 10 is a diagram for explaining a specific example of the process of the control unit of the debt processing device according to the present embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0014] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, an embodiment of a debt processing device, a debt processing method, and a debt processing program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the embodiment.

[0015] [1. Overview] For example, in the logistics industry, orders are generally accepted based on the contract at the time of the transaction, and orders are recorded based on the receivables and payables information at the time of the transaction. Therefore, since it is possible to roughly estimate the receivables and payables for each project at the time of recording the order, receivables and payables are often recorded including the plan when recording the order. Also, in order to quickly grasp the income and expenditure for each project, it is necessary to record receivables and payables when recording the order.

[0016] On the other hand, invoices, which are the final information of recorded payables, are often sent to the main office in bulk at various times, such as at the end of the month or each time. Also, in order to reduce overseas remittance fees, it is common for invoices to be sent in a consolidated form for a certain period of time, rather than for each order. Additionally, in order to efficiently settle and pay payables, it is preferred to send invoices in bulk for each payee. For this reason, there are requirements to quickly grasp the income and expenditures of order orders and requirements to efficiently settle and pay payables using invoices in bulk.

[0017] However, in a business flow where payables are recorded for each order received at each office and then determined based on the invoices sent in a consolidated form to the central office, there is an issue that the granularity of the recorded payables and the invoiced amounts differs, making it difficult to correctly select the linkage of each data. One of the reasons for this is that the consolidation unit of the invoiced amounts sent differs depending on the payee.

[0018] Therefore, in this invention, the granularity of information is adjusted by a function that consolidates the payables (multiple cost information) recorded for each order at each business location by invoice recipient unit. This solves the above problem while also enabling a speedy grasp of income and expenditure for each order by recording payables for each business location, and making lump-sum payments for each invoice recipient unit. In addition, by separating the details for which payment is processed from the details for which management is performed by invoice unit, it is possible to make the work of checking by the person in charge easier.

[0019] Furthermore, in the present invention, when attaching evidential documents in compliance with the Electronic Bookkeeping Act, the aggregation unit and the evidential document attachment unit match, making it possible to easily confirm and control the attachment.

[0020] The debtor processing device of the present invention can be widely used in all industries where cost accounting is performed on a task-by-task basis and the granularity does not match that of invoices, and can be suitably used in the logistics industry, for example.

[0021] [2. Configuration] An example of the configuration of the debt processing device 100 according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of the debt processing device 100.

[0022] The debt processing device 100 is a commercially available desktop personal computer, a workstation, or the like.

[0023] The debt 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 unit included in the debt processing device 100 is communicatively connected via an arbitrary communication path.

[0024] The communication interface unit 104 connects the debt processing device 100 to the network 300 so that the debt processing device 100 can communicate with the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the debt processing device 100 to the server 200 and the terminals 400... so that the debt processing device 100 can communicate with the server 200 and the terminals 400..., and is, for example, the Internet or a LAN (Local Area Network). Note that data such as various masters described later may be stored in the server 200, for example. The terminals 400... are, for example, terminals of each business office (for example, the Yokohama branch sales department and the Osaka branch sales department) or the main business office (for example, the Tokyo head office accounting department), and are configured to be able to communicate data with the debt processing device 100 via the network 300.

[0025] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0026] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage 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 as the storage unit 106.

[0027] The storage unit (storage area) 106 stores, for example, a cost information data table 106a, a payment schedule data table 106b, a voucher image data table 106c, a voucher information data table 106d, and the like.

[0028] The cost information data table (payables apportioning data table) 106a is a table for storing cost information (see FIG. 3). The cost information may include the following items: voucher number (number), line number, accounting date, payee, cost item, amount, invoiced number (number), payables confirmation number (number), payables confirmation line number, and invoiced management number (number). Of the cost information, the voucher number, line number, accounting date, payee, cost item, and amount are registered in the order apportioning process. Also, of the cost information, the invoiced number, payables confirmation number, payables confirmation line number, and invoiced management number are registered in the payables confirmation process.

[0029] The scheduled payment data table (debt settlement data table) 106b is a table for storing scheduled payment data (see FIG. 7). The scheduled payment data may include a debt settlement number, a line number, a scheduled payment date, an amount, and an invoice number.

[0030] The evidence image data table 106c is a table for storing evidence image data of evidence data (attached file), and the evidence image data may include electronic evidence Guid and data (see FIG. 9A).

[0031] The supporting information data table 106d is a table for storing supporting information for supporting data (attachments), and the supporting information may include the electronic supporting information Guid, file name, document name, transaction date, amount, business partner, receipt date, size, invoiced number, and invoiced management number (see Figure 9(B)).

[0032] The control unit 102 is a CPU or the like that performs overall control of the debt processing device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs.

[0033] The control unit 102 is configured to be able to access the cost information data table 106a, the payment schedule data table 106b, the voucher image data table 106c, the voucher information data table 106d, etc., stored in the storage unit 106. Note that the cost information data table 106a, the payment schedule data table 106b, the voucher image data table 106c, the voucher information data table 106d, etc. may be provided in another location (for example, the server 200) as long as the control unit 102 is able to access them.

[0034] The control unit 102 conceptually includes, in terms of functions, an order entry unit 102a, a debt determination unit 102b, an inquiry unit 102c, and a screen display control unit 102d.

[0035] The order entry unit 102a, for example, provides an order entry screen (not shown) in response to access from the terminal 400 of each business location, and inputs the cost information voucher number, line number, entry date, payee, cost item, and amount in response to operations performed by the operator of the terminal 400 of each business location on the order entry screen, and registers them in the cost information data table 106a in the memory unit 106.

[0036] The debt determination unit 102b, for example, provides a debt determination screen (see FIG. 4) in response to access from the representative establishment terminal 400, and extracts cost information from the cost information data table 106a using the designated payee as a key in response to operations on the debt determination screen by the operator of the representative establishment terminal 400, inputs the invoice number of the extracted cost information to update the cost information, creates payment schedule data that aggregates amounts for each invoice number, and registers this in the payment schedule data table 106b. In this case, the debt determination unit 102b may extract cost information from the cost information data table 106a using the designated voucher number in addition to the payee as a key.

[0037] The debt determination unit 102b may create and output (display and / or print) a payment request form for each payee based on the payment schedule data registered in the cost information data table 106a.

[0038] The debt determination unit 102b may create evidence data (attached file) that complies with the Electronic Bookkeeping Act for each invoice-received-number unit, and store the evidence image data table 106c and the evidence information data table 106d.

[0039] The inquiry unit 102c provides a voucher attachment inquiry screen (see Figure 10) in response to access from the terminal 400 of the representative business office or each business office, for example, and displays the search results (for example, debt confirmation number, line number, invoiced management number, invoiced number, accounting date, payee, total invoiced amount, number of electronic transaction attachments, number of scanner-saved attachments, etc.) based on the specified search conditions (for example, invoiced number, etc.) in response to operations by the operator of the terminal 400 of the representative business office or each business office on the voucher attachment inquiry screen, by referring to the payment schedule data table 106b, cost information data table 106a, voucher image data table 106c, and voucher information data table 106d.

[0040] The screen display control unit 102d controls the display of various screens (eg, order entry screen, debt determination screen, attached file list screen, attached file detail screen, voucher attachment inquiry screen, etc.) displayed on the monitor 114 and the acceptance of inputs.

[0041] [3. Specific Examples] A specific example of the processing by the control unit 102 of the debt processing device 100 in this embodiment will be described with reference to Fig. 1 to Fig. 10. Fig. 2 to Fig. 10 are diagrams for explaining a specific example of the processing by the control unit 102 of the debt processing device 100 in this embodiment.

[0042] [3-1. Processing flow (operational flow)] Fig. 2 is a diagram for explaining the overall processing flow (operation flow) of the control unit 102 of the debt processing device 100 in this embodiment. The overall processing flow (operation flow) of the control unit 102 of the debt processing device 100 in this embodiment will be described with reference to Fig. 2.

[0043] Here, we will explain as an example the case where each business office (Yokohama Branch Sales Department, Osaka Branch Sales Department) receives orders from customers and records them during the month (6 / 1, 6 / 10, 6 / 15, 6 / 20), and the main business office (Tokyo Head Office Accounting Department) consolidates invoices and consolidates payables on the closing date (6 / 30).

[0044] The order entry unit 102a executes the order entry process (job) (step S1). Specifically, in the order entry process, the order entry unit 102a provides an order entry screen (not shown) in response to an access from the terminal 400 of each business establishment, and inputs the slip number, line number, entry date, payee, cost item, and amount of the cost information in response to an operation of the operator of the terminal 400 of each business establishment on the order entry screen, and registers the input data in the cost information data table 106a of the storage unit 106.

[0045] In this example, (1)-1: The Yokohama Branch Sales Department and the Osaka Branch Sales Department receive orders and register cost information.

[0046] (1)-2: The Yokohama Branch Sales Department and the Osaka Branch Sales Department send (by email, fax, mail, etc.) the purchase order to the payee (A Shipping, B Warehouse). (1)-3: After the payee (A Shipping, B Warehouse) has completed the work, they send (by email, fax, mail, etc.) a work report to the Yokohama Branch Sales Department and the Osaka Branch Sales Department (the orderee), who then receive the work report. (2)-1: The payee (A Shipping, B Warehouse) sends (by email, fax, mail, etc.) an invoice to the main business office (Tokyo Head Office Accounting Department).

[0047] Here, an operational issue is that the unit of invoices to be compiled varies depending on the payee. For example, Shipping A sends out invoices by consolidating all invoices for the current month onto one page. Warehouse B also sends out invoices by consolidating the customs fees and other items separately for the current month's invoices.

[0048] The debt determination unit 102b executes the debt determination process (job) (step S2). In the debt determination process, multiple cost information items are aggregated by invoice number to determine the debt. Specifically, the debt determination unit 102b provides a debt determination screen (see FIG. 4) in response to an access from the terminal 400 of the representative establishment, and extracts cost information from the cost information data table 106a using the designated payee as a key in response to an operation by the operator of the terminal 400 of the representative establishment on the debt determination screen, inputs the invoice number of the extracted cost information to update the cost information, creates payment schedule data that aggregates the amount for each invoice number, and registers the data in the payment schedule data table 106b. In this case, the debt determination unit 102b may extract cost information from the cost information data table 106a using the designated voucher number as a key in addition to the payee. The debt determination unit 102b may create evidence data (attached file) that complies with the Electronic Bookkeeping Act for each invoice number, and store the evidence image data table 106c and the evidence information data table 106d. The debt determination unit 102b may create and output a payment request form for each payee based on the payment schedule data registered in the cost information data table 106a. Payments to payees are made based on this payment requester.

[0049] In addition, the inquiry unit 102c executes an inquiry process and provides a voucher attachment inquiry screen (see Figure 10) in response to access from the terminal 400 of the representative business office or each business office, and based on the specified search conditions (e.g., invoiced number, etc.) in response to operations by the operator of the terminal 400 of the representative business office or each business office on the voucher attachment inquiry screen, references the payment schedule data table 106b, cost information data table 106a, voucher image data table 106c, and voucher information data table 106d, and displays the search results (e.g., debt confirmation number, line number, invoiced management number, invoiced number, accounting date, payee, invoiced total amount, number of electronic transaction attachments, number of scanner-saved attachments, etc.).

[0050] [3-2. Sample data] 3 to 10 are diagrams showing sample data for explaining a specific example of the processing by the control unit 102 of the debt processing device 100 in this embodiment. A specific example of the processing by the control unit 102 of the debt processing device 100 in this embodiment will be explained with reference to Figs. 3 to 10.

[0051] (S1: Order entry processing) A specific example of the order entry process will be described with reference to Fig. 3. The order entry unit 102a provides an order entry screen (not shown) in response to access from the terminal 400 of each business establishment, for example, and inputs the slip number, line number, entry date, payee, cost item, and amount of the cost information in response to operations on the order entry screen by the operator of the terminal 400 of each business establishment, and registers them in the cost information data table 106a of the storage unit 106.

[0052] FIG. 3 shows an example of data in the cost information data table (payables apportionment data table) 106a that stores cost information. As shown in FIG. 3, the cost information includes the following items: voucher number, line number, apportionment date, payee, cost item, amount, invoiced number, payables confirmed number, payables confirmed line number, and invoiced management number. The invoiced number, payables confirmed number, payables confirmed line number, and invoiced management number are "NULL" at the stage of order apportionment processing, and data is registered in the payables confirmation processing. In this example, the Yokohama branch sales department registers voucher number: TYGN2306001 on 2023 / 06 / 01. The Osaka branch sales department registers voucher number: TYGN2306002 on 2023 / 06 / 10. The Yokohama branch sales department registers voucher number: TYGN2306003 on 2023 / 06 / 15. The Osaka Branch Sales Department will register invoice number TYGN2306004 on 2023 / 06 / 20.

[0053] In the example shown in the figure, the fifth line has the slip number "TYGN2306003", line number "1", accounting date "2023 / 06 / 15", payee "2: Warehouse B", cost item "100: Customs clearance application fee", and amount "10,000". The sixth line has the slip number "TYGN2306003", line number "2", accounting date "2023 / 06 / 15", payee "2: Warehouse B", cost item "101: Animal quarantine application fee", and amount "20,000". The seventh line has the slip number "TYGN2306003", line number "3", accounting date "2023 / 06 / 15", payee "2: Warehouse B", cost item "102: Plant quarantine application fee", and amount "40,000".

[0054] (S2: Debt determination process) A specific example of the debt determination process will be described with reference to Figures 4 to 9. The debt determination unit 102b, for example, provides a debt determination screen (see Figure 4) in response to access from the representative establishment terminal 400, extracts cost information from the cost information data table 106a using the designated payee and voucher number as keys in response to operations on the debt determination screen by the operator of the representative establishment terminal 400, inputs the invoice number of the extracted cost information to update the cost information, creates payment schedule data that aggregates amounts for each invoice number, and registers this in the payment schedule data table 106b.

[0055] 4 is a diagram showing a display example of the debt settlement screen 500. On the debt settlement screen, the user selects an object from the cost details based on the invoice he has on hand that will be sent by the payee, and performs debt settlement registration. The debt settlement screen 500 includes an extraction condition setting area (not shown) for specifying extraction conditions such as the payee (required), voucher number From-To (optional), an execution button (not shown) for executing extraction, an invoice unit summary details area (invoice number, amount, attachment), a cost details area for extracting and displaying cost information that meets the extraction conditions from the cost information data table 106a, and a "Register F10" button, etc.

[0056] In this example, target data is extracted using the extraction conditions "Payment destination: 2: Warehouse B", "Invoice No. From: TYGN2306003", and "Invoice No. To: TYGN2306004".

[0057] The selection of the payable settlement target will be explained with reference to Figure 5. Payee: With the invoice (invoice from the payee) received from Warehouse B at hand, enter the invoice number of the cost details and consolidate the target amount by invoice number. It is possible to settle payables by payee, regardless of the unit in which the invoice was sent.

[0058] The operator inputs the invoiced amount on hand into the invoiced amount field of the cost detail line that matches the invoiced amount on hand in the cost details area on the debt settlement target selection screen 500. The debt settlement unit 102b aggregates the amounts by invoiced amount in the cost details, and displays them for each invoiced amount in the invoice unit aggregated details area.

[0059] In the example shown in the figure, in the cost details area, the invoiced numbers "BBSQ2306001" and "BBSQ2306002" of the invoiced items from Warehouse B are entered into the corresponding details. As a result, the amounts are aggregated for the invoiced numbers "BBSQ2306001" and "BBSQ2306002" in the cost details, and are displayed for each invoiced number in the invoice unit aggregated details area. Specifically, the invoiced number "BBSQ2306001", the amount "126,000 (=20,000+40,000+22,000+44,000)" and the invoiced number "BBSQ2306002", the amount "21,000 (=10,000+11,000)" are displayed.

[0060] The process of attaching a voucher for each invoice will be described with reference to Fig. 6. The debt determination unit 102b creates voucher data (attached file) for each invoice No. in response to an operator's operation on the debt determination screen 500, and stores the voucher image data table 106c and the voucher information data table 106d.

[0061] When the attachment "···" button for the target invoiced number is pressed and selected in the invoiced unit aggregated details area on the debt determination screen 500 shown in Figure 6 (A), a file name is created for the attachment file of the supporting document for the selected invoiced number, and the attachment list screen 600 shown in Figure 6 (B) is displayed. Since supporting documents are attached to details aggregated by invoiced number, one supporting document is attached for each invoice.

[0062] The attachment list screen 600 includes the created file name, a details "..." button, and file type items. In the example shown in the figure, the attachment "..." button for invoice number "BBSQ2306001" is pressed in the invoice unit summary details area of ​​the debt determination screen 500, a file name is created for the voucher attachment for invoice number "BBSQ2306001", and the attachment list screen 600 displays the file name "Invoice_B Warehouse_BBSQ2306001.xlsx" and type "Electronic Transaction".

[0063] When the "..." button for details of the target file name is pressed on the attachment list screen 600, an attachment details screen 700 is displayed, which is a screen for inputting detailed information about the attachment of the voucher. The attachment details screen 700 displays the following items: image of the attachment, file type, and attribute information (document name, transaction year and month, date of receipt or sending, amount, client name, invoice number, reason for delay), and the operator can set the file type and attribute information. In the example shown in the figure, the "..." button for details of the file name "Invoice_B Warehouse_BBSQ2306001.xlsx" is pressed on the attachment list screen 600, and the attachment details screen 700 for the file name "Invoice_B Warehouse_BBSQ2306001.xlsx" is displayed.

[0064] When "F10 Register" is pressed on the debt confirmation screen 500, the payment schedule data table 106b, cost information data table 106a, evidence image data table 106c, and evidence information data table 106d are updated according to the input on the screens (debt confirmation screen 500, attachment list screen 600, attachment detail screen 700).

[0065] Figure 7 shows an example of data in the scheduled payment data table (debt fixed data table) to be updated. Scheduled payment data has fields for fixed debt number, line number, scheduled payment date, amount, and invoice number. The "fixed debt number" is automatically numbered for each payee. The scheduled payment date is the closing date.

[0066] In the example shown in the same figure, the first line has the debt confirmation number "TYSS2306002", row number "1", scheduled payment date "2023 / 06 / 30", amount "126,000", and invoice number "BBSQ2306001".The second line has the debt confirmation number "TYSS2306002", row number "2", scheduled payment date "2023 / 06 / 30", amount "21,000", and invoice number "BBSQ2306002".

[0067] The debt determination unit 102b creates a payment request for each debt determination number (payee). In the example shown in the figure, the payment request has invoice number: BBSQ2306002, payee: Warehouse B, and total amount: 147,000 yen.

[0068] 8 is a diagram showing an example of data to be updated in the cost information data table (debt apportionment data table) 106a. The "Invoiced No.", "Debt Confirmed No.", "Debt Confirmed Line No.", and "Invoiced Management No." of the target record in the cost information data table (debt apportionment data table) 106a are updated. The "Debt Confirmed No." and "Debt Confirmed Line No." are join keys with the payment schedule data table 106b. The "Invoiced Management No." is the join key with the supporting information data table 106d.

[0069] "Invoiced Management No." is automatically assigned for each invoiced number. Since the invoiced number is manually entered, it cannot be used as a join key. Therefore, the automatically assigned "Invoiced Management No." is used as the join key.

[0070] In the example shown in the figure, the "Invoiced No.," "Debt Confirmation No.," "Debt Confirmation Line No.," and "Invoiced Management No." have been updated for the document numbers "TYGN2306003" and "TYGN2306004," and the invoiced management no. "TKHI23060001" has been automatically assigned for the invoiced no. "BBSQ2306001," and the invoiced management no. "TKHI23060002" has been automatically assigned for the invoiced no. "BBSQ2306002."

[0071] Figure 9 shows example data of the updated evidence image data table 106c and evidence information data table 106d, where Figure 9(A) shows an example of the updated evidence image data table 106c and Figure 9(B) shows an example of the updated evidence information data table 106d.

[0072] 9(A), the evidence image data table 106c has the items of electronic evidence Guid and data. In the example shown in the figure, the first row has electronic evidence Guid "GuidA" and data "Invoice_B warehouse_BBSQ2306001.xlsx binary data", and the second row has electronic evidence Guid "GuidB" and data "Invoice_B warehouse_BBSQ2306002.xlsx binary data".

[0073] As shown in Fig. 9(B), the evidence information data table 106d has the following items: electronic evidence Guid, file name, document name, transaction date, amount, client, receipt date, size, invoiced number, and invoiced management number. In the example shown in the figure, the first row contains the electronic evidence Guid "GuidA", the file name "invoice_B warehouse_BBSQ2306001.xlsx", the document name "invoice", the transaction date "2023 / 06 / 15", the amount "126,000", the client "2:B warehouse", the receipt date "2023 / 06 / 30", the size "A4", the invoiced number "BBSQ2306001", and the invoiced management number "TKHI23060001". The second line contains the electronic evidence Guid "GuidB", file name "Invoice_B Warehouse_BBSQ2306002.xlsx", document name "Invoice", transaction date "2023 / 06 / 15", amount "21,000", business partner "2:B Warehouse", receipt date "2023 / 06 / 30", size "A4", invoice recipient number "BBSQ2306002", and invoice recipient management number "TKHI23060002".

[0074] (Inquiry processing) A specific example of the inquiry process will be described with reference to Fig. 10. The inquiry unit 102c provides a voucher attachment inquiry screen in response to access from the terminal 400 of the representative business establishment or each business establishment, and displays the search results (for example, debt confirmation number, line number, invoiced management number, invoiced number, accounting date, payee, invoiced total amount, electronic transaction attachment number, scanner-saved attachment number, etc.) by referring to the payment schedule data table 106b, cost information data table 106a, voucher image data table 106c, and voucher information data table 106d based on the specified search conditions (for example, invoiced number, etc.) in response to the operation of the operator of the terminal 400 of the representative business establishment or each business establishment on the voucher attachment inquiry screen.

[0075] On the evidence attachment inquiry screen, it is possible to check whether the attached invoice and the payment schedule data (debt confirmation data) are correctly linked. Figure 10 (A) is a diagram showing a display example of the evidence attachment inquiry screen 800. On the evidence attachment inquiry screen 800, it is possible to switch between the search condition screen (not shown) and the search result screen with a button.

[0076] The search condition screen has the following search conditions: "Payable settlement number, invoice management number, invoice number, accounting date, payee, total invoice amount" (From To can be specified, all extraction items are optional).

[0077] When the search conditions are specified and an execute button (not shown) is pressed, the inquiry unit 102c refers to the payment schedule data table 106b, cost information data table 106a, voucher image data table 106c, and voucher information data table 106d based on the extraction conditions, and displays the search results on the search result screen by invoiced management No. The search results include items such as debt confirmation No., line number, invoiced management No., invoiced No., accounting date, payee, invoiced total amount, number of electronic transaction attachments, and number of scanner-saved attachments.

[0078] For example, if you specify the search criteria as "Invoice No. From:BBSQ2306001 Invoice No. To:BBSQ2306002", the search results will be as shown in Figure 10 (A), with the following results in the first line: Payable settlement No. "TYSS2306002", line number "1", invoice management No. "TKHI23060001", invoice No. "BBSQ2306001", posting date "2023 / 06 / 15", payee "2:B Warehouse", invoice total amount "126,000", electronic transaction The number of attachments with withdrawals is "1", the number of attachments saved on the scanner is "0", and on the second line, the payable settlement number is "TYSS2306002", the line number is "2", the invoice management number is "TKHI23060002", the invoice number is "BBSQ2306002", the accounting date is "2023 / 06 / 15", the payee is "2:B Warehouse", the total amount of invoices is "21,000", the number of electronic transaction attachments is "1", and the number of attachments saved on the scanner is "0".

[0079] When the target details are selected from the search results and the "F2 Confirm Attachments" button is pressed, an attachment list screen 600 of the supporting document attachments attached to the details is displayed, as shown in Fig. 10(B). When the details "..." button is pressed on the attachment list screen 600, an attachment details screen 700 is displayed, as shown in Fig. 10(C).

[0080] In the example shown in the same figure, in the search results of Figure 10 (A), the detail "Debt Confirmation No.: TYSS2306002 Line No.: 1" is selected, the "F2 Confirm Attachments" button is pressed, the attachment list screen 600 for "Invoiced No.: BBSQ2306001" is displayed, and the details "···" button is pressed, and the attachment details screen 700 for "Invoiced No.: BBSQ2306001" is displayed.

[0081] The operator can check whether the linking is correct by comparing the detailed information on the search result screen with the attachment file information on the attachment file details screen 700. In the example shown in the figure, it can be confirmed that the linking is correct.

[0082] As described above, according to this embodiment, there is provided an order recording unit 102a which, for each business establishment, registers the cost information (such as the invoice number, recording date, payee, cost item, and amount) in a cost information data table 106a when recording an order, and a debt determination unit 102b which, using the payee specified as a key on the debt determination screen, extracts cost information from the memory area, inputs the invoice number of the extracted cost information to update the cost information, and creates payment schedule data that aggregates amounts for each invoice number and registers this in the payment schedule data table 106b. This makes it possible to quickly grasp the income and expenditure for each order by recording debts for each business establishment, and to make payments aggregated for each invoiced person.

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

[0084] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

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

[0086] 5. Other embodiments The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0087] 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 using known methods.

[0088] In addition, 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 drawings may be changed as desired unless otherwise specified.

[0089] Moreover, with regard to the debt processing device 100, the components shown in the drawings are merely functional concepts, and the device does not necessarily have to be physically configured as shown in the drawings.

[0090] For example, the processing functions of the debt processing device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the debt processing device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form a control unit.

[0091] In addition, this computer program may be stored in an application program server connected to the debt processing device 100 via any network, and it is also possible to download all or a part of it as necessary.

[0092] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.

[0093] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.

[0094] The various databases etc. stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files etc. used for various processes and providing websites.

[0095] The debt processing device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. The debt processing device 100 may be realized by installing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

[0096] Furthermore, the specific form of 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 any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Explanation of symbols]

[0097] 100 Debt Processing Machine 102 Control section 102a Order Accounting Department 102b Debt Settlement Department 102c Enquiry Section 102d Screen display control unit 104 Communication interface section 106 Storage section 106a Cost information data table 106b Payment schedule data table 106c Evidence image data table 106d Evidence information data table 108 Input / Output Interface Section 112 Input Devices 114 Output Device 300 Network 400 terminals

Claims

1. A debt processing device having a control unit, The control unit is Invoice number of the payee, document number, accounting date, payee, cost item, amount The method is configured to be able to access a storage area that stores cost information including an order entry means for registering, for each business establishment, a slip number, an entry date, a payee, a cost item, and an amount of cost information in the storage area when an order is entered; a debt determination means for extracting cost information from the storage area using a designated payee as a key on the debt determination screen, inputting the invoice number of the extracted cost information to update the cost information, and creating payment schedule data that aggregates amounts for each invoice number, and registering the data in the storage area; A debt processing device comprising:

2. 2. The debt processing apparatus according to claim 1, wherein said debt determination means extracts cost information from said memory area using a slip number designated in addition to said payee as a key.

3. 2. The debt processing apparatus according to claim 1, wherein said debt determination means prepares a payment request form for each payee based on the payment schedule data registered in said storage area.

4. 4. The debt processing device according to claim 1, wherein said debt determination means creates evidence data conforming to the Electronic Bookkeeping Act for each invoice number and registers the evidence data in said memory area.

5. A debt processing method executed by an information processing device having a control unit, The control unit is Invoice number of the payee, document number, accounting date, payee, cost item, amount The method is configured to be able to access a storage area that stores cost information including Executed in the control unit, an order entry step of registering, for each business establishment, a slip number, an entry date, a payee, a cost item, and an amount of cost information in the storage area when an order is entered; an obligation determination step of extracting cost information from the storage area using a designated payee as a key on the obligation determination screen, inputting the invoice number of the extracted cost information to update the cost information, and creating payment schedule data that aggregates amounts for each invoice number, and registering this data in the storage area; A debt processing method comprising:

6. A debt processing program to be executed by an information processing device having a control unit, The control unit is Invoice number of the payee, document number, accounting date, payee, cost item, amount The method is configured to be able to access a storage area that stores cost information including In the control unit, an order entry step of registering, for each business establishment, a slip number, an entry date, a payee, a cost item, and an amount of cost information in the storage area when an order is entered; an obligation determination step of extracting cost information from the storage area using a designated payee as a key on the obligation determination screen, inputting the invoice number of the extracted cost information to update the cost information, and creating payment schedule data that aggregates amounts for each invoice number, and registering this data in the storage area; A debt processing program to carry out the above.

Images