Invoice issuing device, invoice issuing method, and invoice issuing program

Abstract

To provide a bill issuance device, a bill issuance method and a bill issuance program that provide load reduction and accuracy of billing work associated with the invoice institutions.SOLUTION: A bill issuance device comprises: a management item master in which management items and invoice subject classifications including sales or substitutive payment are associatively registered; and bill issuance means that refers to the management item master in issuing a bill, and issues the bill including substitutive payment details for management items of substitutive payment and billing details for other management items if the object billing includes the substitutive payment of invoice subject classifications and the other management items.SELECTED DRAWING: Figure 1

Description

[Technical Field]

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

[0002] For example, in the real estate management industry, management companies not only issue invoices to tenants for monthly rent etc., but also to owners. The content of the invoices varies depending on the type of property management, but in the case of outsourced management, the main items of the invoice include management fees, which are the company's sales, and advance payments to contractors. The invoice system to be introduced on October 1, 2023, will have different requirements for invoice content than before. Previously, systems to comply with the invoice system include, for example, Patent Document 1. [Prior art documents] [Patent documents]

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

[0004] However, the above-mentioned Patent Document 1 does not state anything about reducing the burden of billing operations and improving accuracy associated with the invoice system.

[0005] The present invention has been made in consideration of the above, and aims to provide an invoice issuing device, an invoice issuing method, and an invoice issuing program that can reduce the burden of billing operations associated with the invoice system and achieve accuracy. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides an invoice issuing device equipped with a control unit and used by an issuer to issue invoices, wherein the control unit is configured to be able to access a management item master in which management items are registered in association with invoice subject categories including sales or advance payments, and when issuing an invoice, the control unit refers to the management item master, and if there are advance payments for the invoice subject category and other management items for the target invoice, the device is equipped with an invoice issuing means for issuing an invoice including advance payment details for the advance payment management item and invoice details for the other management items.

[0007] According to another aspect of the present invention, the control unit is further configured to be able to access a business partner master registering business partners and registration numbers in association with each other, an issuer master registering issuers and registration numbers in association with each other, billing statement data including a billing payment category, a billing payment sequence number, a billing destination code, a management item code, a property code, an invoice issue date, a scheduled payment date, the relevant month, the main amount, consumption tax, the amount including tax, a tax category code, and an invoice number, and to link the billing statement data with payment statement data, and to access advance payment statement data including a billing payment category, a billing payment sequence number, an advance payment billing statement data, and advance payment statement data including an advance payment billing statement data, an advance payment billing statement code, a management item code, a property code, a payment date, the relevant month, the main amount, consumption tax, the amount including tax, a tax category code, and a payment number, and the invoice issuing means extracts the billing statement data based on the specified output conditions, and outputs the "billing payment category" of the extracted billing statement data to the payment statement data. and "Bill Payment SEQ" as keys to extract advance payment detail data, and using the "Advance Payment Bill Payment Category" and "Advance Payment Bill Payment SEQ" of the advance payment detail data as keys to extract payment detail data, and for the extracted advance payment detail data, the management item master is referenced to obtain the invoice subject category for each management item of the same invoice number, and if there is an advance payment for the invoice subject category and sales, an invoice may be issued that includes an advance payment detail created based on the extracted advance payment detail data and that lists the destination, issuer, issuer registration number obtained from the issuer master, sales item, applicable month, invoice amount, total invoice amount, tax rate, total consumption tax, and total amount including tax, and an advance payment settlement statement that is an advance payment detail created based on the extracted payment detail data and that lists the destination, issuer, payee, payee registration number obtained from the business partner master, expense item to be advanced, applicable month, amount, tax rate, consumption tax, and amount including tax.

[0008] According to one aspect of the present invention, the invoice may include an invoice copy created based on the extracted detailed invoice data, which contains the recipient, issuer, total invoice amount, all expenses, the relevant month, invoice amount, total invoice amount, tax rate, total consumption tax, and total amount including tax, and an advance payment detail created based on the extracted detailed invoice data, which contains the recipient, issuer, expenses to be advanced, the relevant month, amount, total amount, tax rate, total consumption tax, and total amount including tax.

[0009] According to another aspect of the present invention, the issuer may include a real estate management company.

[0010] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention provides an invoice issuance method executed by an information processing device equipped with a control unit, wherein the control unit is configured to be able to access a management item master in which management items are registered in association with invoice subject categories including sales or advance payments, and the control unit is characterized in that when issuing an invoice, the control unit refers to the management item master, and if there are advance payments for the invoice subject category and other management items for the target invoice, the control unit includes an invoice issuance means which issues an invoice including advance payment details for the advance payment management item and invoice details for the other management items.

[0011] In addition, in order to solve the above-mentioned problems and achieve the objectives, the present invention provides an invoice issuance program to be executed by an information processing device equipped with a control unit, and an invoice issuance method to be executed by an information processing device equipped with a control unit, wherein the control unit is configured to be able to access a management item master in which management items are registered in association with invoice subject categories including sales or advance payments, and the control unit, when issuing an invoice, refers to the management item master, and if there are advance payments for the invoice subject category and other management items for the target invoice, the invoice issuance program executes an invoice issuance process to issue an invoice including advance payment details for the advance payment management item and invoice details for the other management items. [Effects of the Invention]

[0012] The present invention has the effect of reducing the burden of billing operations associated with the invoice system and achieving accuracy. [Brief explanation of the drawings]

[0013] [Figure 1] FIG. 1 is a diagram showing an example of the configuration of a bill issuing device according to this embodiment. [Figure 2] FIG. 2 is a diagram illustrating an example of the property master. [Figure 3] FIG. 3 is a diagram illustrating an example of the supplier master. [Figure 4] FIG. 4 is a diagram illustrating an example of the sender master. [Figure 5] FIG. 5 is a diagram illustrating an example of the management item master. [Figure 6] FIG. 6 is a flow diagram showing an example of the overall processing of the invoice issuing device according to this embodiment. [Figure 7] FIG. 7 is a diagram for explaining a specific example of the processing of the control unit of the invoice issuing device according to this embodiment. [Figure 8] FIG. 8 is a diagram for explaining a specific example of the processing of the control unit of the invoice issuing device according to this embodiment. [Figure 9] FIG. 9 is a diagram for explaining a specific example of the processing of the control unit of the invoice issuing device according to this embodiment. [Figure 10] FIG. 10 is a diagram for explaining a specific example of the processing of the control unit of the invoice issuing device according to this embodiment. DETAILED DESCRIPTION OF THE INVENTION

[0014] Hereinafter, embodiments of a bill issuing device, a bill issuing method, and a bill issuing program according to the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to these embodiments.

[0015] [1. Overview] For example, in the real estate management business, management companies not only issue monthly invoices to tenants for rent, but also to owners. The content of the invoices varies depending on the type of property management, but in the case of outsourced management, the main items of the invoice include management fees, which are the company's revenue, and advance payments to the company.

[0016] In the past, in most cases, sales accounts and advance accounts were listed together on a single invoice and issued. However, with the introduction of the invoice system on October 1, 2023, advance payments and other accounts must be clearly distinguished and clearly stated on the invoice, and advance payment settlement statements must be prepared for advance payments. Property management companies (for example, property management companies) check the contents of invoices every month, and if advance payment and other accounts are mixed, they must manually prepare separate statements and advance payment settlement statements that distinguish between them, raising concerns about the workload and operational errors that accompany operational revisions.

[0017] Therefore, in this embodiment, when an invoice contains a mixture of advance payment items and other items, the invoice is automatically separated into advance payment items and other items, and an invoice (including details) that meets the requirements of the invoice system can be issued, thereby reducing the burden of billing operations associated with the invoice system and achieving accuracy.

[0018] The present invention can be widely applied to industries that handle billing operations for invoices that include a mixture of advance items and other items, such as real estate management companies (including PM companies) in the real estate industry.

[0019] [2. Configuration] An example of the configuration of the bill issuing device according to this embodiment will be described with reference to FIG. The invoice issuing device according to this embodiment can be suitably used, for example, in a real estate management company, etc. Fig. 1 is a block diagram showing an example of the configuration of an invoice issuing device 100 according to this embodiment.

[0020] The invoice issuing device 100 is a commercially available desktop personal computer. Note that the invoice issuing device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

[0021] The invoice issuing device 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. Each unit of the invoice issuing device 100 is connected to each other so that they can communicate with each other via any communication path.

[0022] The communication interface unit 104 communicably connects the invoice issuing device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the invoice issuing device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

[0023] 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 achieve a pointing device function. Note that, hereinafter, 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. Displaying information on the monitor 114 and the user operating the input device 112 may be referred to as a "user operation via a UI."

[0024] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with an OS (Operating System) to issue commands to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc.

[0025] The storage unit 106 stores, for example, an object master 106a, a supplier master 106b, a sender master 106c, a management item master 106d, billing detail data, advance payment detail data, payment detail data, etc. Fig. 2 is a diagram showing an example of the configuration of the object master 106a. Fig. 3 is a diagram showing an example of the configuration of the supplier master 106b. Fig. 4 is a diagram showing an example of the configuration of the sender master 106c. Fig. 5 is a diagram showing an example of the configuration of the management item master 106d.

[0026] The property master 106a is a master for property information, and can be configured as a table in which property codes and property names are associated and registered, as shown in Figure 2. In the example shown in the figure, the property code is "BK01" and the property name is "XX Building." The property master 106a is referenced when converting property codes and property names.

[0027] The customer master 106b is a master for customer information, and can be configured as a table that associates and registers customer codes, customer names, and registration numbers (taxable business registration numbers), as shown in Figure 3. The customer master 106b is referenced by the invoice issuing unit 102c when entering the customer (payee) registration number on the advance payment settlement statement. In the example shown in the figure, the first line contains the customer code "OW001," the customer name "Owner A," and the registration number "T1000000000001," the second line contains the customer code "GY001," the customer name "Contractor A," and the registration number "T1000000000003," and the third line contains the customer code "GY002," the customer name "Contractor B," and the registration number "T1000000000004."

[0028] The sender (issuer) master 106c is a master relating to sender (issuer) information, and as shown in Figure 4, can be configured as a table or the like in which sender (issuer) code, sender (issuer) name, and registration number are associated and registered. The sender master 106c is referenced by the invoice issuing unit 102c when entering the sender's registration number in the invoice details. In the example shown in the figure, the sender code is "H01," the sender name is "PM Real Estate," and the registration number is "T1000000000002."

[0029] The management item master 106d is a master for managing management items for billing, and can be configured as a table in which management item codes, management item names for billing, and invoice subject categories (e.g., 0: sales, 1: advances) are associated and registered, as shown in Fig. 5. In the example shown in Fig. 5, the first line has the management item code "K01," the management item name "management fee income (PM fee)," and the invoice subject category "0: sales," the second line has the management item code "K02," the management item name "brokerage commission income (LM fee)," and the invoice subject category "0: sales," the third line has the management item code "K03," the management item name "construction supervision fee income (CM fee)," and the invoice subject category "0: sales," and the fourth line has the management item code "K04," the management item name "advance payments," and the invoice subject category "1: advances."

[0030] The billing details data may include billing payment category, billing payment SEQ, billing destination code, management item code, property code, billing issue date, expected payment date, applicable month, base amount, consumption tax, amount including tax, tax category code, and billing number (see Figure 9(A)).

[0031] The advance payment details data (advance payment information management table) is used to link the billing details data with the payment details data, and may include the billing payment category, billing payment SEQ, advance payment billing payment category, and advance payment billing payment SEQ (see Figure 9(B)).

[0032] The payment details data (details of advance payment) may include the advance payment claim payment category, advance payment claim payment SEQ, payee code, management item code, property code, payment date, applicable month, base amount, consumption tax, amount including tax, tax category code, and payment number (see Figure 9(C)).

[0033] Returning to Figure 1, the control unit 102 is a CPU or the like that performs overall control of the invoice issuing device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing operations based on these stored programs.

[0034] The control unit 102 is configured to be able to access the property master 106a, business partner master 106b, sender master 106c, management item master 106d, billing detail data, advance payment detail data, payment detail data, etc. stored in the storage unit 106. Note that the property master 106a, business partner master 106b, sender master 106c, management item master 106d, billing detail data, advance payment detail data, payment detail data, etc. may be stored in another location (for example, server 200) as long as the control unit 102 is able to access them.

[0035] The control unit 102 conceptually includes a master maintenance unit 102a, a billing processing unit 102b, a bill issuing unit 102c, and a screen display control unit 102d.

[0036] The master maintenance unit 102a performs settings such as inputting, adding, changing, and updating data for the property master 106a, the customer master 106b, the sender master 106c, and the management item master 106d, in response to, for example, an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.

[0037] The billing processing unit 102b inputs billing detail data, advance payment detail data, payment detail data, etc., in response to, for example, an operator's operation on a registration screen (not shown) displayed on the monitor 114, and registers the data in the memory unit 106.

[0038] When issuing an invoice, the invoice issuing unit 102c refers to the management item master 106d, and if the invoice in question has both advance payment and other management items in the invoice subject category, it issues (displays and / or prints) an invoice including advance payment details for the advance payment management item and invoice details for the other management items.

[0039] Specifically, the invoice issuing unit 102c extracts detailed invoice data from the storage unit 106 based on specified output conditions in response to, for example, an operator's operation on the invoice issuance screen displayed on the monitor 114, extracts detailed advance payment data from the storage unit 106 using the "invoice payment category" and "invoice payment SEQ" of the extracted detailed invoice data as keys, extracts detailed advance payment data from the storage unit 106 using the "invoice payment category" and "invoice payment SEQ" of the detailed advance payment data as keys, and then, for the extracted detailed invoice data, refers to the management item master 106d for each management item of the same invoice number, and then calculates the invoice category. The item category is obtained, and if there is a sale, an invoice is issued that includes an invoice detail created based on the extracted invoice detail data, which includes the destination, issuer, issuer registration number obtained from the sender master 106c, sales expense item, applicable month, invoice amount, total invoice amount, tax rate, total consumption tax, and total amount including tax, and an advance payment settlement statement, which is an advance payment detail created based on the extracted payment detail data, which includes the destination, issuer, payee, payee registration number obtained from the business partner master 106b, expense item to be advanced, applicable month, amount, tax rate, consumption tax, and amount including tax.

[0040] The invoice may also include an invoice copy created based on the extracted detailed invoice data, which contains the recipient, issuer, total invoice amount, all expenses, the month in question, the invoice amount, the total invoice amount, the tax rate, the total consumption tax, and the total amount including tax, and an advance payment statement created based on the extracted detailed invoice data, which contains the recipient, issuer, expenses to be paid in advance, the month in question, the amount, the total amount, the tax rate, the total consumption tax, and the total amount including tax. The issuer may include a real estate management company.

[0041] The screen display control unit 102d controls the display of various screens (for example, billing screen, various data registration screen, master maintenance screen, etc.) displayed on the monitor 114 and the inputs thereto.

[0042] [3. Specific Examples] A specific example of the processing performed by the control unit 102 of the bill issuing device 100 in this embodiment will be described with reference to FIGS.

[0043] (3-1. Overall processing) FIG. 6 is a flowchart for explaining an outline of the overall processing of the control unit 102 of the invoice issuing device 100 in this embodiment.

[0044] An overview of the overall processing of the control unit 102 of the invoice issuing device 100 in this embodiment will be described with reference to Figure 6. In Figure 6, the master maintenance unit 102a executes management item master maintenance processing (step S1). Specifically, in the management item master maintenance processing, the master maintenance unit 102a performs initial data settings for the management item master 106d in response to, for example, an operator's operation on a management item master maintenance screen (not shown) displayed on the monitor 114.

[0045] The invoice issuing unit 102c executes the invoice issuing process (step S2). Specifically, in the invoice issuing process, the invoice issuing unit 102c, for example, monthly, refers to the management item master 106d for the target invoice in accordance with the output conditions specified in response to an operator's operation on the invoice issuance screen displayed on the monitor 114, and issues (displays and / or prints) an invoice including advance payment details for the advance management item and billing details for the other management items, if there are advance payment and other management items in the invoice subject classification.

[0046] The invoice issuing unit 102c extracts billing detail data based on the specified output conditions in response to, for example, an operator's operation on the invoice issuing screen displayed on the monitor 114, extracts advance payment detail data using the "invoice payment category" and "invoice payment SEQ" of the extracted billing detail data as keys, extracts payment detail data using the "advance payment invoice payment category" and "advance payment invoice payment SEQ" of the advance payment detail data as keys, and for the extracted billing detail data, references the management item master 106d for each management item of the same invoice number to obtain the invoice subject category, and sets the invoice subject category as "advance payment" If sales exist, an invoice is automatically issued, which includes an invoice detail created based on the extracted invoice detail data and which lists the destination, issuer, issuer registration number obtained from the sender master 106c, sales expense item, applicable month, invoice amount, total invoice amount, tax rate, total consumption tax, and total amount including tax, an advance payment settlement statement which is an advance payment detail created based on the extracted payment detail data and which lists the destination, issuer, payee, payee registration number obtained from the business partner master 106b, expense item to be advanced, applicable month, amount, tax rate, consumption tax, and amount including tax, a copy of the invoice, and an advance payment detail.

[0047] (3-2. Sample data) 7 to 10 are diagrams showing sample data for explaining a specific example of the processing by the control unit 102 of the invoice issuing device 100 in this embodiment. A specific example of the processing by the control unit 102 of the invoice issuing device 100 in this embodiment will be explained with reference to FIGS. 7 to 10. Below, an example will be described in which the master configuration examples shown in FIGS. 2 to 5 are used.

[0048] (S1: Management item master maintenance processing) A specific example of the management item master maintenance process will be described with reference to Fig. 7. The master maintenance unit 102a performs initial data settings for the management item master 106d in response to, for example, an operator's operation on a management item master maintenance screen (not shown) displayed on the monitor 114.

[0049] Figure 7 is a diagram showing an example of the display of the control item master maintenance screen. The control item master maintenance screen has fields for specifying the control item code, control item name, and invoice subject category, as well as a register button and a close button. When the control item code, control item name, and invoice subject category are specified for each control item and the register button is pressed, the input contents are registered in the control item master 106d. For example, data such as that shown in Figure 5 is registered in the control item master 106d.

[0050] (S2: Invoice issuance process) A specific example of the invoice issuance process will be described with reference to Figures 8 to 10. The invoice issuance unit 102c extracts detailed invoice data from the storage unit 106 based on specified output conditions in response to, for example, an operator's operation on the invoice issuance screen displayed on the monitor 114, extracts detailed advance payment data from the storage unit 106 using the "invoice payment category" and "invoice payment SEQ" of the extracted detailed invoice data as keys, and extracts detailed payment data from the storage unit 106 using the "invoice payment category" and "invoice payment SEQ" of the detailed advance payment data as keys. The invoice issuing unit 102c obtains the invoice subject classification for each management item of the same invoice number for the extracted invoice detail data by referring to the management item master 106d, and if there is an advance payment for the invoice subject classification and a sale, automatically issues an invoice including an invoice detail created based on the extracted invoice detail data and including the issuer's registration number, sales expense item, applicable month, invoice amount, total invoice amount, tax rate, total consumption tax, and total amount including tax, the invoice detail, an advance payment settlement statement which is an advance payment detail created based on the extracted payment detail data and including the payee's registration number, advance payment item, applicable month, amount, tax rate, consumption tax, and amount including tax, the invoice detail, a copy of the invoice, and an advance payment detail.

[0051] FIG. 8 is a diagram showing an example of the invoice issuance screen. The invoice issuance screen has an output condition specification area for specifying output conditions such as the invoice issuance date, invoice code, property code, expected payment date, and invoice number, as well as a print button and a close button. When the output conditions are specified and the print button is pressed, the following process is executed according to the output conditions, and the invoice is printed out. Here, an example is explained in which the invoice issuance date "2023 / 11 / 01-2023 / 11 / 30" and invoice code "OW001: Owner A" are specified as output conditions.

[0052] Billing detail data is extracted from the memory unit 106 based on the specified output conditions, and advance payment detail data is extracted using the "advance payment category" and "advance payment SEQ" of the extracted billing detail data as keys, and payment detail data is extracted using the "advance payment category" and "advance payment SEQ" of the advance payment detail data as keys.

[0053] FIG. 9(A) shows an example of billing detail data, FIG. 9(B) shows an example of advance payment detail data, and FIG. 9(C) shows an example of payment detail data.

[0054] In this example, detailed billing data such as that shown in Figure 9(A) is extracted using the invoice issue date "2023 / 11 / 01-2023 / 11 / 30" and billing destination code "OW001: Owner A" as keys. The detailed billing data has the following fields: billing payment category, billing payment sequence, billing destination code, management item code, property code, invoice issue date, expected payment date, applicable month, amount, consumption tax, amount including tax, tax category code, and invoice number.

[0055] In the example shown in the same figure, the first line contains the billing payment category "1", billing payment SEQ "10", billing destination code "OW001: Owner A", management item code "K01: Management fee income", property code "BK01", invoice issue date "2023 / 11 / 10", expected payment date "2023 / 11 / 25", applicable month "2023 / 10", base amount "500,000", consumption tax "50,000", amount including tax "550,000", tax category code "21:10%", and invoice number "100". The fourth line contains the following information: billing payment category "1", billing payment SEQ "13", billing destination code "OW001: Owner A", management item code "K04: Advance payment", property code "BK01", invoice issue date "2023 / 11 / 10", expected payment date "2023 / 11 / 25", applicable month "2023 / 10", base amount "1,000,000", consumption tax "10,000", amount including tax "1,100,000", tax category code "21:10%", invoice number "100".

[0056] Using the billing payment category "1" and billing payment sequence "13" of the billing detail data as keys, the advance payment detail data shown in Figure 9(B) is extracted. The advance payment detail data is used to link the billing detail data with the payment detail data, and includes the following fields: billing payment category, billing payment sequence, advance payment billing payment category, and advance payment billing sequence.

[0057] In the example shown in the same figure, the first line has the billing payment category "1", billing payment SEQ "13", advance payment billing payment category "2", and advance payment billing payment SEQ "21", and the second line has the billing payment category "1", billing payment SEQ "13", advance payment billing payment category "2", and advance payment billing payment SEQ "22".

[0058] Using the advance payment claim payment category "2" and advance payment claim payment sequence numbers "21" and "22" in the advance payment claim detail data as keys, payment detail data such as that shown in Figure 9(C) is extracted. The payment detail data (advance payment details) includes the advance payment claim payment category, advance payment claim payment sequence number, payee code, management item code, property code, payment date, applicable month, base amount, consumption tax, amount including tax, tax category code, and payment number.

[0059] In the example shown in the figure, the first line has the following information: advance payment claim payment category "2", advance payment claim payment SEQ "21", payee code "GY001: Contractor A", management item code "K04: Advance payment", property code "BK01", payment date "2023 / 10 / 31", applicable month "2023 / 10", base amount "500,000", consumption tax "50,000", amount including tax "550,000", tax classification code "21:10%", payment NO "210 ", the second line is: Advance payment category "2", Advance payment payment SEQ "22", payee code "GY002: Contractor B", management item code "K04: Advance payment", property code "BK01", payment date "2023 / 10 / 31", applicable month "2023 / 10", base amount "500,000", consumption tax "50,000", amount including tax "550,000", tax category code "21:10%", payment number "220".

[0060] For billing detail data, the system refers to the management item master 106d for each management item of the same invoice number, acquires the invoice subject classification, and generates judgment work data (intermediate data) including the billing payment classification, billing payment sequence, billing destination code, management item code, and invoice subject classification, as shown in Figure 10(D).Then, it determines whether the invoice subject classifications are mixed.

[0061] 1: If advance payments and other items (for example, 0: sales) are mixed, separate statements for each item will be issued separately from the invoice.

[0062] Figure 10 shows an example of an invoice to be issued. Figure 10(A) shows an example of an invoice (mirror) (not an invoice). The invoice (mirror) is created based on the invoice detail data. The invoice (mirror) has a header section and a details section. The header section contains the title (invoice in the example shown in the figure), invoice number, page number, destination (Owner A in the example shown in the figure), issuer (PM Real Estate in the example shown in the figure), and total invoice amount (2,200,000 yen in the example shown in the figure). The registration number is not included. The details section contains all expense items, the relevant month, invoice amount for each expense item, total invoice amount, tax rate, total consumption tax, and total amount including tax.

[0063] Figure 10(B) is a diagram showing an example of billing details (billing details for sales, company registration number printed, invoice). Billing details are created for management items for which the invoice subject classification in the billing detail data is "0: Sales." Billing details have a header section and a detail section. The header section contains the title (in the example shown in the figure, billing details), invoice number, page count, destination (owner A), issuer, and the issuer's registration number obtained from the sender master 106c using the issuer as a key (T1000000000002 in the example shown in the figure). The detail section contains the sales expense item, the relevant month, the billing amount for each sales expense item, the total billing amount, the tax rate, the total consumption tax, and the total amount including tax.

[0064] Figure 10(C) is a diagram showing an example of advance payment details (bill details for advance payments, not invoices). Advance payment details are created for management items for which the invoice subject classification in the billing detail data is "1: Advance payment." Advance payment details have a header section and a detail section. The header section contains the title (in the example shown in the figure, advance payment details), invoice number, page number, destination, and issuer. The detail section contains the advance payment item, applicable month, billing amount, total billing amount, tax rate, total consumption tax, and total amount including tax.

[0065] FIG. 10(D) shows an example of an advance payment settlement slip (details of advance payment, supplier registration number printed, invoice). The advance payment settlement slip is created for management items in the billing detail data with an invoice subject classification of "1: Advance Payment" and management items in the payment detail data linked by the advance payment detail data. The advance payment settlement slip has a header section and a detail section. The header section lists the title (in the example shown in the figure, "Advance Payment Settlement Slip"), invoice number, page number, destination, and issuer. The detail section lists the payee (in the example shown in the figure, vendors A and B), the payee registration number (in the example shown in the figure, T1000000000003,4) obtained from the customer master 106b using the payee as a key, the expense item (advance payment), the relevant month, amount, tax rate, consumption tax, and the amount including tax.

[0066] As described above, according to this embodiment, there is provided a management item master 106d in which management items are registered in association with invoice subject categories including sales or advances, and an invoice issuing unit 102c which, when issuing an invoice, refers to the management item master, and if the invoice in question has advances in the invoice subject category and other management items, issues an invoice including advance payment details for the advance management item and invoice details for the other management items.Therefore, if an invoice contains a mixture of advance payment subjects and other subjects, the invoice can be automatically divided into advances and other subjects, and an invoice that meets the requirements of the invoice system can be issued, making it possible to reduce the burden of billing operations and achieve accuracy associated with the invoice system.

[0067] [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 the achievement of SDGs Goals 8 and 9.

[0068] 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.

[0069] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.

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

[0071] 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.

[0072] Furthermore, 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 can be changed as desired unless otherwise specified.

[0073] Furthermore, with regard to the bill issuing device 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0074] For example, all or any part of the processing functions of the invoice issuing device 100, particularly the processing functions performed by the control unit, may be realized 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 on a non-transitory computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the invoice issuing device 100 as needed. That is, a computer program for issuing 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 RAM, and cooperates with the CPU to form the control unit.

[0075] This computer program may also be stored in an application program server connected to the bill issuing device 100 via any network, and all or part of it may be downloaded as needed.

[0076] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "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.

[0077] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. 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, can use well-known configurations and procedures.

[0078] The various databases 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 used for various processes and providing websites.

[0079] The invoice issuing 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 invoice issuing device 100 may also be realized by installing software (including programs, data, etc.) that causes the device to perform the processes described in this embodiment.

[0080] 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 configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Explanation of symbols]

[0081] 100 Bill issuing device 102 Control section 102a Master Maintenance Department 102b Claims Processing Department 102c Billing Department 102d Screen display control unit 104 Communication interface unit 106 Storage section 106a Property Master 106b Customer Master 106c Shipment origin master 106d Management item master 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

1. A bill issuing device including a control unit for an issuer to issue a bill, The control unit The system is configured to be able to access a management item master that associates management items with invoice subject classifications including sales or advance payments, An invoice issuing device characterized by having an invoice issuing means that, when issuing an invoice, refers to the management item master, and if there are advance payment and sales management items in the invoice subject classification for the target invoice, issues an invoice including advance payment details for the advance payment management item and invoice details for the sales management item.

2. The control unit further A customer master record in which customers and registration numbers are associated with each other, an issuer master in which issuers and registration numbers are associated and registered; Invoice detail data including invoice payment category, invoice payment SEQ, invoice destination code, management item code, property code, invoice issue date, expected payment date, applicable month, base amount, consumption tax, amount including tax, tax category code, invoice number; The billing statement data and the payment statement data are linked together, and the billing statement data includes a billing payment category, a billing payment sequence number, an advance payment billing payment category, and an advance payment billing payment sequence number. Payment details data including the advance payment claim payment category, advance payment claim payment SEQ, payee code, management item code, property code, payment date, applicable month, base amount, consumption tax, amount including tax, tax category code, and payment number; It is configured to be accessible to The bill issuing means Extracting billing detail data based on the specified output conditions, extracting advance payment detail data using the "bill payment category" and "bill payment SEQ" of the extracted billing detail data as keys, and extracting payment detail data using the "advance payment billing payment category" and "advance payment SEQ" of the advance payment detail data as keys, The invoice issuing device of claim 1, characterized in that for the extracted invoice detail data, the management item master is referenced to obtain the invoice subject classification for each management item of the same invoice number, and if the invoice subject classifications ``advance payment'' and ``sales'' exist, an invoice is issued that includes an invoice detail created based on the extracted invoice detail data and including the destination, issuer, issuer registration number obtained from the issuer master, sales expense item, applicable month, invoice amount, total invoice amount, tax rate, total consumption tax, and total amount including tax, and an advance payment settlement statement which is an advance payment detail created based on the extracted payment detail data and including the destination, issuer, payee, payee registration number obtained from the business partner master, advance payment expense item, applicable month, amount, tax rate, consumption tax, and amount including tax.

3. The invoice issuing device of claim 2, characterized in that the invoice includes an invoice copy created based on the extracted invoice detail data, which contains the destination, issuer, total invoice amount, all expenses, the relevant month, invoice amount, total invoice amount, tax rate, total consumption tax, and total amount including tax, and an advance detail created based on the extracted invoice detail data, which contains the destination, issuer, expenses to be advanced, the relevant month, amount, total amount, tax rate, total consumption tax, and total amount including tax.

4. 4. The invoice issuing device according to claim 1, wherein the issuer includes a real estate management company.

5. An invoice issuing method executed by an information processing device having a control unit, The control unit The system is configured to be able to access a management item master that associates management items with invoice subject classifications including sales or advance payments, Executed in the control unit: An invoice issuance method characterized by including an invoice issuance means that, when issuing an invoice, refers to the management item master, and if there are advance payment and sales management items in the invoice subject classification for the target invoice, issues an invoice including advance payment details for the advance payment management item and invoice details for the sales management item.

6. An invoice issuing program to be executed by an information processing device having a control unit, An invoice issuing method executed by an information processing device having a control unit, The control unit The system is configured to be able to access a management item master that associates management items with invoice subject classifications including sales or advance payments, In the control unit, An invoice issuance program for executing an invoice issuance process that, when issuing an invoice, refers to the management item master and, if there are advance payment and sales management items in the invoice subject classification for the target invoice, issues an invoice including advance payment details for the advance payment management item and invoice details for the sales management item.

Images