Invoice processing device, invoice processing method, and invoice processing program

Abstract

To reduce workload of an operator when issuing invoices after introduction of the invoice system.SOLUTION: Provided is a bill processing device comprising construction input means and bill issuing means. The construction input means creates billing data including a billing number, a billing year / month, and a billing destination (client); and collection schedule data including a collection schedule data creation section to specify a collection schedule identifier for identifying each line item, a billing number, and construction advance payment or construction-related property income, and a billing year / month, a sales recording date, a billing destination that is landlord or tenant, an item that is a billed item or cost item, a billed amount, a construction number, a construction detail identifier, and an advance payment destination. The bill issuing means issues a bill based on the collection schedule data by the billing number and billing destination unit, in that case, issues an advance payment statement when data on the advance payment destination is set in the collection schedule data creation section, and issues a qualified invoice when the advance payment destination is not set up.SELECTED DRAWING: Figure 1

Description

[Technical Field]

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

[0002] The invoice system will be introduced on October 1, 2023. When a company issues an invoice to a business partner, it will issue a "qualified invoice" if it is claiming expenses that correspond to the company's sales, but when it claims expenses that it has paid in advance on behalf of a business partner, it must issue an "advance payment settlement statement." For example, Patent Document 1 is an example of a system for issuing qualified invoices under the invoice system. [Prior art documents] [Patent documents]

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

[0004] However, the above Patent Document 1 does not state anything about reducing the workload of operators when issuing invoices by automatically determining whether to output a qualified invoice or an advance payment settlement statement based on the difference between the billing amount and the cost amount in the construction data after the invoice system is introduced.

[0005] The present invention has been made in consideration of the above, and aims to provide an invoice processing device, an invoice processing method, and an invoice processing program that can reduce the workload of operators when issuing invoices by automatically determining whether to output a qualified invoice or an advance payment settlement statement based on the difference between the billing amount and the cost amount in the construction data after the introduction of the invoice system. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides an invoice processing device that includes a control unit and that allows a management company to issue invoices to landlords and / or tenants of real estate properties. The control unit is configured to be able to access a first master that associates and registers cost items or billing items with invoice subject categories including sales or advance payments, and in response to an operator's operation on a construction input screen, the first master registers construction header data including construction number, date of occurrence, property, room number, landlord billing items, and tenant billing items, construction detail identifiers that identify each detail, construction number, construction item, and construction header data including construction header data, construction detail identifiers that identify each detail, construction item, construction detail identifier ... construction detail data including the landlord's billing amount, the tenant's billing amount, the construction company, cost items, and construction cost amount; billing data including the billing number, billing year and month, and billing recipient; collection schedule data including a collection schedule identifier for identifying each detail, the billing number, a collection schedule data creation category specifying construction advances or construction real estate income, the billing year and month, the sales recording date, the billing recipient being the landlord or tenant, items that are billing items or cost items, the billing amount, the construction number, the construction detail identifier, and the advance payment business partner; and issuing an invoice based on the collection schedule data for each of the billing numbers and billing recipients. and an invoice issuing means for issuing an advance settlement statement if the data of an advance payment customer is set in the collection schedule data creation section, and for issuing a qualified invoice if the advance payment customer is not set. The construction input means, for the collection schedule data, (1) creates details of "construction advances" and "construction real estate income" in the collection schedule data creation section if the landlord billing amount + tenant billing amount > construction cost amount, and creates details of "construction advances" in the collection schedule data creation section if the landlord billing amount + tenant billing amount ≦ construction cost amount, and (2) the above items and the above amounts are entered in the collection schedule data. If the data creation category is "construction advances", set the cost items and construction costs of the construction detail data, and if the recovery schedule data creation category is "construction real estate income", set the billing items and "billing amount - cost amount" of the construction header data, (3) in the details grouped by the billing destination and construction detail identifier of the recovery schedule data, if the recovery schedule data creation category is "construction real estate income", obtain the item of that detail, or if not, obtain the item of the detail of the recovery schedule data creation category "construction advances", and obtain the invoice subject category from the first master using the obtained item as a key,When the acquired invoice subject category is "advance payment," the construction company in the construction details data is set as the advancing customer.

[0007] Furthermore, according to one aspect of the present invention, when the landlord's billing amount + tenant's billing amount > construction cost amount, if both the landlord and tenant have contributions, the construction input means may apportion the construction cost amount and the landlord's billing amount + tenant's billing amount - construction cost amount based on the proportion of the contributions.

[0008] According to one aspect of the present invention, the control unit is configured to be able to access a second master in which the management company's invoice registration number is registered, and when issuing a qualified invoice, the invoice issuing means may obtain the management company's invoice registration number from the second master and print the management company and invoice registration number on the sender's address.

[0009] According to another aspect of the present invention, the control unit is configured to be able to access a third master that registers business partners, including construction companies, in association with invoice registration numbers, and when issuing an advance payment settlement statement, the invoice issuing means may obtain the invoice registration number from the third master using the advance payment business partner in the collection schedule data as a key, and print out the advance payment business partner and the obtained invoice registration number.

[0010] Furthermore, in order to solve the above-mentioned problems and achieve the object, the present invention provides an invoice processing method in which an information processing device equipped with a control unit is used by a management company to issue invoices to landlords and / or tenants of real estate properties, wherein the control unit is configured to be able to access a first master in which cost items or billing items are associated with invoice subject categories including sales or advance payments, and the control unit executes a construction input screen in response to an operator's operation to input construction data including construction number, date of occurrence, property, room number, landlord billing items, and tenant billing items, a construction input process for creating construction detail data including a construction detail identifier for identifying each detail, a construction number, a construction item, a landlord's billing amount, a tenant's billing amount, a construction company, a cost item, and a construction cost amount; billing data including a billing number, a billing year and month, and a billing recipient; a collection schedule identifier for identifying each detail, a billing number, a collection schedule data creation category specifying construction advances or construction real estate income, a billing year and month, a sales recording date, a billing recipient that is the landlord or tenant, an item that is a billing item or a cost item, a billing amount, a construction number, a construction detail identifier, and a billing recipient; and an invoice issuing step of issuing an invoice based on the collection schedule data, and at that time, if data on an advance payment customer is set in the collection schedule data creation section, issuing an advance payment settlement statement, and if an advance payment customer is not set, issuing a qualified invoice. In the construction input step, for the collection schedule data, (1) if the landlord billing amount + tenant billing amount > construction cost amount, details of "construction advance payment" and "construction real estate income" are created in the collection schedule data creation section, and if the landlord billing amount + tenant billing amount ≦ construction cost amount, details of "construction advance payment" are created. (2) When the collection schedule data creation category is "construction advances", the cost items and construction costs of the construction detail data are set for the above items and amounts, and when the collection schedule data creation category is "construction real estate income", the billing items and "billing amount - cost amount" of the construction header data are set, (3) in the details grouped by the billing destination and construction detail identifier of the collection schedule data, if the collection schedule data creation category is "construction real estate income", the items of that detail are obtained, and if not, the items of the detail of the collection schedule data creation category "construction advances" are obtained, and using the obtained items as a key,The method is characterized in that an invoice subject category is acquired from the first master, and if the acquired invoice subject category is "advance payment," the construction company of the construction detail data is set as the advancing customer.

[0011] In order to solve the above-mentioned problems and achieve the object, the present invention provides an invoice processing program for a management company to issue invoices to landlords and / or tenants of real estate properties, to be executed by an information processing device having a control unit, wherein the control unit is configured to be able to access a first master in which cost items or billing items are associated with invoice subject categories including sales or advance payments, and the control unit generates construction header data including construction number, occurrence date, property, room number, landlord billing items, and tenant billing items in response to an operator's operation on a construction input screen. a construction input process for creating construction detail data including a construction detail identifier for identifying each detail, a construction number, a construction item, a landlord's billing amount, a tenant's billing amount, a construction company, a cost item, and a construction cost amount; billing data including a billing number, a billing year and month, and a billing destination; a collection schedule identifier for identifying each detail, a billing number, a collection schedule data creation category specifying construction advances or construction real estate income, a billing year and month, a sales recording date, a billing destination that is the landlord or tenant, an item that is a billing item or a cost item, a billing amount, a construction number, a construction detail identifier, and a billing destination; and an invoice issuing step of issuing an invoice based on the collection schedule data, and at that time, if data on an advance payment customer is set in the collection schedule data creation section, issuing an advance payment settlement statement, and if an advance payment customer is not set, issuing a qualified invoice. In the construction input step, for the collection schedule data, (1) if the landlord's billing amount + tenant's billing amount > construction cost amount, details of "construction advance payment" and "construction real estate income" in the collection schedule data creation section are created, and if the landlord's billing amount + tenant's billing amount ≦ construction cost amount, If the amount is "construction advances," create a breakdown of "construction advances," (2) for the above items and amounts, if the collection schedule data creation category is "construction advances," set the cost items and construction costs of the construction detail data, and if the collection schedule data creation category is "construction real estate income," set the billing items and "billing amount - cost amount" of the construction header data, (3) in the details grouped by the billing destination and construction detail identifier of the collection schedule data, if the collection schedule data creation category is "construction real estate income," obtain the item of that detail, or if not, obtain the item of the detail of the collection schedule data creation category "construction advances,"The acquired item is used as a key to acquire an invoice item category from the first master, and if the acquired invoice item category is "advance payment", the construction company of the construction detail data is set as the advancing customer. [Effects of the Invention]

[0012] According to the present invention, after the introduction of the invoice system, it is possible to automatically determine whether to output a qualified invoice or an advance payment settlement statement based on the difference between the billing amount and the cost amount in the construction data, thereby reducing the workload of operators when issuing invoices. [Brief explanation of the drawings]

[0013] [Figure 1] FIG. 1 is a diagram showing an example of the configuration of a bill processing device according to this embodiment. [Figure 2] FIG. 2 is a diagram illustrating an example of the configuration of the control master. [Figure 3] FIG. 3 is a diagram illustrating an example of the configuration of the property master. [Figure 4] FIG. 4 is a diagram illustrating an example of the configuration of the room master. [Figure 5] FIG. 5 is a diagram illustrating an example of the configuration of the supplier master. [Figure 6] FIG. 6 is a diagram illustrating an example of the configuration of the management contract master. [Figure 7] FIG. 7 is a diagram showing an example of the configuration of the management contract room-specific master. [Figure 8] FIG. 8 is a diagram illustrating an example of the configuration of the contract master. [Figure 9] FIG. 9 is a diagram illustrating an example of the configuration of the construction item master. [Figure 10] FIG. 10 is a diagram illustrating an example of the configuration of the rent item master. [Figure 11] FIG. 11 is a diagram showing an example of the configuration of the journalization pattern master. [Figure 12] FIG. 12 is a flow diagram showing an outline of the overall processing of the control unit of the invoice processing device according to this embodiment. [Figure 13]FIG. 13 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. [Figure 14] FIG. 14 is a diagram for explaining a specific example of the processing of the control unit of the invoice processing device according to this embodiment. [Figure 15] FIG. 15 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. [Figure 16] FIG. 16 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. [Figure 17] FIG. 17 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. [Figure 18] FIG. 18 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. [Figure 19] FIG. 19 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. [Figure 20] FIG. 20 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. [Figure 21] FIG. 21 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. [Figure 22] FIG. 22 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. [Figure 23] FIG. 23 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. [Figure 24] FIG. 24 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. DETAILED DESCRIPTION OF THE INVENTION

[0014] Hereinafter, embodiments of a bill processing device, a bill processing method, and a bill processing 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] The invoice system will be introduced from October 1, 2023. When companies issue invoices to their business partners to claim expenses that correspond to their own sales, they will issue "qualified invoices," but when claiming expenses that they have paid in advance on behalf of their business partners, they will have to issue "advance payment settlement slips."

[0016] For example, in the rental housing management industry, when a management company bills the landlord or customer for the cost of repairs or restoration work on a residence, they may bill the amount billed by the contractor as is, or they may bill the amount billed by the contractor plus the management company's income, but this varies depending on the type of work and the case.

[0017] Furthermore, depending on the outcome of negotiations between the management company and its business partners (landlords, customers, or construction companies), what was initially a bill from the management company (for which the management company has income) may ultimately become a bill for advance payments (for which the management company has no income), or vice versa. In this way, the details of the construction fee bill may change from moment to moment depending on negotiations with business partners.

[0018] It is difficult for the system operator of the management company to input data into the system while being aware of whether the invoice is a company invoice or an advance payment invoice. Even after the invoice system is implemented, it is desirable to be able to issue invoices that meet the requirements of the invoice system while still performing the same input process as before the invoice system was implemented.

[0019] Therefore, in this embodiment, after the invoice system is launched, the operator of the management company's system will carry out the same input processing as before the invoice system was launched, without having to worry about whether the invoice is an in-house invoice or an advance invoice, and when issuing an invoice, the system will automatically determine whether it is a "qualified invoice" or an "advance payment settlement statement," and switch between outputting the "qualified invoice" and the "advance payment settlement statement," thereby making it possible to issue an appropriate invoice.

[0020] Specifically, the invoice processing device of this embodiment is equipped with a function that determines the difference between the invoice amount and the cost amount of the construction data, and outputs a "qualified invoice" if the invoice amount > cost amount (when the management company generates income), and outputs a "payment advance settlement statement" if the invoice amount <= cost amount (when the management company does not generate income).

[0021] The invoice processing device of this embodiment can be applied to a wide range of industries, such as rental management and construction.

[0022] [2. Configuration] An example of the configuration of the invoice processing device according to this embodiment will be described with reference to FIG. The invoice processing device according to this embodiment can be suitably used, for example, in real estate management companies (including PM companies), etc. Fig. 1 is a block diagram showing an example of the configuration of an invoice processing device 100 according to this embodiment.

[0023] The invoice processing device 100 is a commercially available desktop personal computer. Note that the invoice processing 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.

[0024] The invoice processing 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 processing device 100 is connected to each other so that they can communicate with each other via any communication path.

[0025] The communication interface unit 104 communicatively connects the invoice processing 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 the function of communicating data with other devices via the communication line. Here, the network 300 has the function of connecting the invoice processing 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).

[0026] 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."

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

[0028] The memory unit 106 stores, for example, a control master 106a, a property master 106b, a room master 106c, a business partner master 106d, a management contract master 106e, a management contract room master 106f, a contract master 106g, a construction item master 106h, a rent item master 106i, an accounting pattern master 106j, construction header data, construction detail data, billing data, scheduled collection data, etc.

[0029] FIG. 2 is a diagram showing an example of the configuration of the control master 106a. FIG. 3 is a diagram showing an example of the configuration of the property master 106b. FIG. 4 is a diagram showing an example of the configuration of the room master 106c. FIG. 5 is a diagram showing an example of the configuration of the business partner master 106d. FIG. 6 is a diagram showing an example of the configuration of the management outsourcing contract master 106e. FIG. 7 is a diagram showing an example of the configuration of the management outsourcing contract room master 106f. FIG. 8 is a diagram showing an example of the configuration of the contract master 106g. FIG. 9 is a diagram showing an example of the configuration of the construction item master 106h. FIG. 10 is a diagram showing an example of the configuration of the rent item master 106i. FIG. 11 is a diagram showing an example of the configuration of the accounting pattern master 106j.

[0030] The control master (second master) 106a is a master that manages information about the management company (our company), and can be configured as a table that associates and registers the company name and invoice registration number, as shown in Figure 2. In the example shown in the figure, the first line contains the company name "OBIC Management Company" and the invoice registration number "T111."

[0031] The property master 106b is a master for managing building information, and can be configured as a table in which property codes and property names are registered in association with each other, as shown in Figure 3. The property master 106b is referenced when converting property codes and property names. In the example shown in the figure, the first line contains the property code "B0001" and the property name "ABC Mansion."

[0032] The room master 106c is a master that manages the rooms of a property, and can be configured as a table in which property codes and room numbers are associated and registered, as shown in Fig. 4. In the example shown in the same figure, the first line contains the property code "B0001" and the room number "101."

[0033] The customer master (third master) 106d is a master that manages billing and payment destinations, and can be configured with a table or the like that associates and registers customer codes, customer names, customer types, and invoice registration numbers, as shown in Figure 5. The customer master (third master) 106d is referenced when converting customer codes and customer names, and the invoice registration number is referenced using the customer as a key. In the example shown in the figure, the first line contains customer code "Y0001", customer name "Housekeeper Taro", customer type "Housekeeper", and invoice registration number " "; the second line contains customer code "K0001", customer name "Loaner Hanako", customer type "Loaner", and invoice registration number " ", the third line has customer code "G0001", customer name "Kyobashi Construction", customer type "Contractor", invoice registration number "T222", the fourth line has customer code "G0002", customer name "XX Construction Company", customer type "Contractor", invoice registration number "T444", the fifth line has customer code "G0003", customer name "△△ Construction", customer type "Contractor", invoice registration number "T333", the sixth line has customer code "G0004", customer name "□□ Construction", customer type "Contractor", invoice registration number " ".

[0034] The management contract master 106e is a master for managing management contracts with landlords, and can be configured as a table that associates and registers management contract numbers, property codes, and landlord codes, as shown in Figure 6. In the example shown in the figure, the first line contains the management contract number "000000012," the property code "B0001," and the landlord code "Y0001."

[0035] The management contract room master 106f is a master that manages rooms linked to a management contract, and can be configured as a table that associates and registers the management contract number, property code, room number, start of validity period, and end of validity period, as shown in Figure 7. In the example shown in the same figure, the first line contains the management contract number "000000012", property code "B0001", room number "101", start of validity period "2020 / 1 / 1", and end of validity period " ".

[0036] The contract master 106g is a master for managing rental contracts with tenants, and can be configured as a table that associates and registers contract numbers, contractor codes, property codes, room numbers, and initial contract dates, as shown in Figure 8. In the example shown in the figure, the first line contains the contract number "0000000001," contractor code "K0001," property code "B0001," room number "101," and initial contract date "2021 / 4 / 1."

[0037] The work item master 106h is a master that manages the work items in the work details, and can be configured with a table that associates and registers work item codes and work item names, as shown in Figure 9. The work item master 106h is referenced when converting work item codes and work item names. In the example shown in the figure, the first line has the work item code "KK001" and the work item name "wallpaper replacement," the second line has the work item code "KK002" and the work item name "tatami replacement," the third line has the work item code "KK003" and the work item name "toilet water leak repair," the fourth line has the work item code "KK004" and the work item name "balcony repair," and the fifth line has the work item code "KK005" and the work item name "parts replacement."

[0038] The rent item master 106i is a master that manages billing items and cost items, and can be configured as a table that associates and registers rent item codes (item codes for billing items and cost items) and rent item names (names of billing items and cost items), as shown in Figure 10. The rent item master 106i is referenced when converting rent item codes (item codes for billing items and cost items) and rent item names (names of billing items and cost items). In the example shown in the figure, the first line has the rent item code "TK0011" and the rent item name "repair costs," the second line has the rent item code "TK0012" and the rent item name "repair costs payment," and the third line has the rent item code "TK0013" and the rent item name "repair costs payment (sales)."

[0039] The journal entry pattern master (first master) 106j is a master that manages invoice subject classifications for each rent item code, and as shown in Figure 11, can be configured as a table that registers rent item codes (item codes for billing items and cost items) in association with invoice subject classifications. The journal entry pattern master (first master) 106j references invoice subject classifications using rent item codes (item codes for billing items and cost items) as keys. In the example shown in the figure, the first line has rent item code "TK0011" and invoice subject classification "1: Sales", the second line has rent item code "TK0012" and invoice subject classification "3: Advance", and the third line has rent item code "TK0013" and invoice subject classification "1: Sales".

[0040] The construction header data may include a construction number, a construction date, a property code, a room number, a management contract number, a contract number, a landlord billing item, and a tenant billing item (see FIG. 14(A)).

[0041] The construction detail data may include a construction detail Guid (construction detail identifier) ​​for identifying each detail, a construction number, a construction item code, a construction item name, a landlord billing amount, a tenant billing amount, a construction contractor code, a cost item, and a construction cost amount (see Figure 14(B)).

[0042] The billing data may include the billing number, billing year and month, contract number, billing destination, and management outsourcing contract number (see FIG. 14(C)).

[0043] The collection schedule data may include each detail as a collection schedule Guid (collection schedule identifier), billing number, collection schedule data creation category, billing year and month, sales recording date, billing destination, item code, billing amount, construction number, construction detail Guid, and advance payment customer code (see Figure 14 (D)).

[0044] In the above, a master is prepared to convert between codes and corresponding names, but either or both of the codes and names can be used, and a master to convert between codes and corresponding names is not necessarily required. Hereinafter, XX means XX code and / or XX name (for example, customer means customer code and / or customer name).

[0045] Returning to Figure 1, the control unit 102 is a CPU or the like that provides overall control of the invoice 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, required data, etc., and executes various information processing operations based on these stored programs.

[0046] The control unit 102 is configured to be able to access the control master 106a, property master 106b, room master 106c, business partner master 106d, management outsourcing contract master 106e, management outsourcing contract room master 106f, contract master 106g, construction item master 106h, rent item master 106i, accounting pattern master 106j, construction header data, construction detail data, billing data, collection schedule data, etc. stored in the memory unit 106. Note that the control master 106a, property master 106b, room master 106c, business partner master 106d, management outsourcing contract master 106e, management outsourcing contract room master 106f, contract master 106g, construction item master 106h, rent item master 106i, accounting pattern master 106j, construction header data, construction detail data, billing data, collection schedule data, etc. may be provided elsewhere (e.g., on the server 200) as long as they are accessible by the control unit 102.

[0047] The control unit 102 conceptually includes a master maintenance unit 102a, a construction input unit 102b, an invoice issuing unit 102c, and a screen display control unit 102d.

[0048] The master maintenance unit 102a, for example, in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114, performs editing such as registering, updating, adding, and deleting data for the control master 106a, property master 106b, room master 106c, business partner master 106d, management outsourcing contract master 106e, management outsourcing contract room master 106f, contract master 106g, construction item master 106h, rent item master 106i, and accounting pattern master 106j.

[0049] The construction input unit 102b, for example, in response to an operator's operation on the construction input screen (see FIG. 13) displayed on the monitor 114, creates construction header data including the construction number, date of occurrence, property, room number, landlord's billing item, and tenant's billing item; construction detail data including a construction detail identifier identifying each detail, the construction number, construction item, landlord's billing amount, tenant's billing amount, contractor, cost item, and construction cost amount; billing data including the billing number, billing year and month, and billing destination; collection schedule data including a collection schedule identifier identifying each detail, the billing number, the collection schedule data creation category specifying the construction advance or construction real estate income, the billing year and month, the sales recording date, the billing destination which is the landlord or tenant, the item which is the billing item or cost item, the billing amount, the construction number, construction detail identifier, and advance payment destination, and registers the collection schedule data in the memory unit 106.

[0050] The construction input unit 102b, for the collection schedule data, (1) if the landlord billing amount + tenant billing amount > construction cost amount, creates details of "construction advances" and "construction real estate income" of the collection schedule data creation category, and if the landlord billing amount + tenant billing amount ≦ construction cost amount, creates details of "construction advances", (2) for the "item" and "billing amount", if the collection schedule data creation category is "construction advances", set the cost item and construction cost of the construction detail data, and if the collection schedule data creation category is "construction real estate income", set the "item" and "billing amount" of the construction header data Set the invoice item and "invoice amount - cost amount", (3) in the details grouped by the billing destination and construction detail identifier of the data to be collected, if the collection data creation category is "construction real estate income", obtain the item of that detail, or if not, obtain the item of the detail with the collection data creation category "construction advance", and use the obtained item as a key to obtain the invoice subject category from the accounting pattern master (first master) 106j, and if the obtained invoice subject category is "advance", set the construction company of the construction detail data as the advance customer.

[0051] Furthermore, when the landlord's billing amount + tenant's billing amount > construction cost amount, if both the landlord and tenant have contributions, the construction input unit 102b will apportion the construction cost amount and the amount of the landlord's billing amount + tenant's billing amount - construction cost amount based on the proportion of their contributions; and even when the landlord's billing amount + tenant's billing amount ≦ construction cost amount, if both the landlord and tenant have contributions, the construction cost amount may be apportioned based on the proportion of their contributions.

[0052] The invoice issuing unit 102c issues an invoice based on the collection schedule data by invoice number and invoice recipient, and at that time, if the data of the advance payment customer is set in the collection schedule data creation category, an advance payment settlement statement is issued, and if the advance payment customer is not set, an eligible invoice is issued.

[0053] When issuing a qualified invoice, the invoice issuing unit 102c may obtain the management company's invoice registration number from the control master (second master) 106a and print the management company and invoice registration number on the sender's address.

[0054] When issuing an advance payment settlement statement, the invoice issuing unit 102c may obtain the invoice registration number from the customer master (third master) 106d using the advance payment customer in the collection schedule data as a key, and print the advance payment customer and the obtained invoice registration number.

[0055] The screen display control unit 102d controls the display of various screens (for example, a master maintenance screen, a construction input screen, etc.) displayed on the monitor 114 and the input therefor.

[0056] [3. Specific Examples] Specific examples of processing by the control unit 102 of the invoice processing device 100 in this embodiment will be described with reference to Figures 1 to 24. Figures 12 to 24 are diagrams for explaining specific examples of processing by the control unit 102 of the invoice processing device 100 in this embodiment. The following explanation will be given using the master data examples in Figures 2 to 11.

[0057] [3-1. Overall processing] Figure 12 is a diagram showing a flow for explaining an outline of the overall processing by the control unit 102 of the invoice processing device 100 in this embodiment. With reference to Figure 12, an outline of the overall processing by the control unit 102 of the invoice processing device 100 in this embodiment will be described.

[0058] In FIG. 12, the construction input unit 102b executes construction input processing (step S1). Specifically, in the construction input processing, the construction input unit 102b creates construction header data including the construction number, date of occurrence, property, room number, landlord's billing item, and tenant's billing item, construction detail data including a construction detail identifier identifying each detail, the construction number, construction item, landlord's billing amount, tenant's billing amount, contractor, cost item, and construction cost amount, billing data including the billing number, billing year and month, and billing recipient, collection schedule data including a collection schedule identifier identifying each detail, the billing number, the collection schedule data creation category specifying the construction advance or construction real estate income, the billing year and month, the sales recording date, the billing recipient which is the landlord or tenant, the item which is the billing item or cost item, the billing amount, the construction number, construction detail identifier, and advance payment customer, and registers the created collection schedule data in the memory unit 106.

[0059] The construction input unit 102b, for the collection schedule data, (1) if the landlord billing amount + tenant billing amount > construction cost amount, creates details of "construction advances" and "construction real estate income" of the collection schedule data creation category, and if the landlord billing amount + tenant billing amount ≦ construction cost amount, creates details of "construction advances", (2) for the "item" and "billing amount", if the collection schedule data creation category is "construction advances", set the cost item and construction cost of the construction detail data, and if the collection schedule data creation category is "construction real estate income", set the "item" and "billing amount" of the construction header data Set the invoice item and "invoice amount - cost amount", (3) in the details grouped by the billing destination and construction detail identifier of the data to be collected, if the collection data creation category is "construction real estate income", obtain the item of that detail, or if not, obtain the item of the detail with the collection data creation category "construction advance", and use the obtained item as a key to obtain the invoice subject category from the accounting pattern master (first master) 106j, and if the obtained invoice subject category is "advance", set the construction company of the construction detail data as the advance customer.

[0060] Furthermore, when the landlord's billing amount + tenant's billing amount > construction cost amount, if both the landlord and tenant have contributions, the construction input unit 102b will apportion the construction cost amount and the amount of the landlord's billing amount + tenant's billing amount - construction cost amount based on the proportion of their contributions; and even when the landlord's billing amount + tenant's billing amount ≦ construction cost amount, if both the landlord and tenant have contributions, the construction cost amount may be apportioned based on the proportion of their contributions.

[0061] The invoice issuing unit 102c executes the invoice issuing process (step S2). Specifically, in the invoice issuing process, the invoice issuing unit 102c issues an invoice based on the collection schedule data for each invoice number and invoice recipient, and at that time, if the data of the advance payment customer is set in the collection schedule data creation category, an advance payment settlement statement is issued, and if the advance payment customer is not set, an eligible invoice is issued.

[0062] When issuing a qualified invoice, the invoice issuing unit 102c may obtain the management company's invoice registration number from the control master (second master) 106a and print the management company and invoice registration number on the sender's address.

[0063] When issuing an advance payment settlement statement, the invoice issuing unit 102c may obtain the invoice registration number from the customer master (third master) 106d using the advance payment customer in the collection schedule data as a key, and print the advance payment customer and the obtained invoice registration number.

[0064] [3-2. Sample data] 13 to 24 are diagrams showing sample data for explaining a specific example of the processing by the control unit 102 of the invoice processing device 100 in this embodiment. A specific example of the processing by the control unit 102 of the invoice processing device 100 in this embodiment will be described with reference to FIGS. 13 to 24. Below, an example will be described in which the master configuration examples shown in FIGS. 2 to 11 are used.

[0065] (S1: Construction input processing) 13 to 16, a specific example of construction work input processing will be described. The construction input unit 102b, for example, in response to an operator's operation on the construction work input screen (see FIG. 13) displayed on the monitor 114, creates construction header data including the construction number, date of occurrence, property, room number, landlord's billing item, and tenant's billing item; construction detail data including a construction detail identifier identifying each detail, the construction number, construction item, landlord's billing amount, tenant's billing amount, contractor, cost item, and construction cost amount; billing data including the billing number, billing year and month, and billing destination; collection schedule data including a collection schedule identifier identifying each detail, the billing number, the collection schedule data creation category specifying the construction advance or construction real estate income, the billing year and month, the sales posting date, the billing destination which is the landlord or tenant, the item which is the billing item or cost item, the billing amount, the construction number, construction detail identifier, and advance payment destination; and registers the created collection schedule data in the storage unit 106.

[0066] At that time, the construction input unit 102b, for the collection schedule data, (1) if the landlord billing amount + tenant billing amount > construction cost amount, creates details of "construction advances" and "construction real estate income" of the collection schedule data creation category, and if the landlord billing amount + tenant billing amount ≦ construction cost amount, creates details of "construction advances", (2) for the "item" and "billing amount", if the collection schedule data creation category is "construction advances", set the cost item and construction cost of the construction detail data, and if the collection schedule data creation category is "construction real estate income", set the construction header data (3) in the details grouped by the billing destination and construction detail identifier of the data to be collected, if the collection schedule data creation category is "construction real estate income", obtain the item of that detail, or if not, obtain the item of the detail with the collection schedule data creation category "construction advance", and using the obtained item as a key, obtain the invoice subject category from the accounting pattern master (first master) 106j, and if the obtained invoice subject category is "advance", set the construction company of the construction detail data as the advance customer.

[0067] Furthermore, when the landlord's billing amount + tenant's billing amount > construction cost amount, if both the landlord and tenant have contributions, the construction input unit 102b will apportion the construction cost amount and the amount of the landlord's billing amount + tenant's billing amount - construction cost amount based on the proportion of their contributions; and even when the landlord's billing amount + tenant's billing amount ≦ construction cost amount, if both the landlord and tenant have contributions, the construction cost amount may be apportioned based on the proportion of their contributions.

[0068] FIG. 13 is a diagram showing an example of the display of a construction input screen 400. This figure shows an example of inputting construction number "KZ001." The construction input screen 400 includes a header area 401 for inputting the construction number, property, room number, management contract number, contract number, landlord, tenant, date of occurrence, billing year and month, sales posting date, landlord billing items, tenant billing items, etc.; a construction details area 402 for inputting construction details (construction item name, billing amount (landlord), billing amount (tenant), contractor, construction cost, cost items); and a register button (not shown). When the management contract number is input in the header area 401, the landlord and tenant are automatically input (automatically displayed) from the management contract master 106e using the input management contract number as a key.

[0069] When the operator enters data in the header area 401 and the construction details area 402 and presses a registration button (not shown), the construction input unit 102b creates construction header data, construction details data, billing data, and scheduled collection data according to the input contents in the header area 401 and the construction details area 402, and registers them in the memory unit 106.

[0070] In the example shown in the same figure, the header area 401 contains the following input: construction number "KZ001: temporary construction", property "B0001: ABC Mansion", room number "101", management contract number "000000012", contract number "0000000001", landlord "Y0001: landlord Taro", tenant "K0001: tenant Hanako", occurrence date "2023 / 10 / 1", billing year and month "2023 / 10", sales posting date "2023 / 10 / 30", landlord billing item "TK0011: repair costs", and tenant billing item "TK0011: repair costs".

[0071] In the construction details area 402, the first line shows the construction item name "KK001: Wallpaper replacement", the invoice amount (landlord) "150,000", the invoice amount (tenant) "50,000", the contractor "G0001: Kyobashi Construction Co., Ltd.", the construction cost "200,000", the cost item "TK0012: Repair cost payment", and the second line shows the construction item name "KK002: Tatami replacement", the invoice amount (landlord) "100,000", the invoice amount (tenant) ) "30,000", contractor "G0001: Kyobashi Construction", construction cost "100,000", cost item "TK0012: Repair cost payment", and on the third line, the construction item name is "KK003: Toilet water leak construction", invoice amount (landlord) "0", invoice amount (tenant) "80,000", contractor "G0002: XX construction company", construction cost "70,000", cost item "TK0012: Repair cost payment".

[0072] If the billing amount is "billing amount (landlord) + billing amount (tenant)," comparing the billing amount with the cost amount will enable you to determine whether the management company has income. If the billing amount is less than or equal to the cost amount, the management company has no income, and if the billing amount is greater than the cost amount, the management company has income.

[0073] In the example construction details in the figure, the first line has no management company income because the billed amount of "200,000" = the cost amount of "200,000." The second line has a management company income because the billed amount of "130,000" > the cost amount of "100,000." The third line has a management company income because the billed amount of "80,000" > the cost amount of "70,000."

[0074] When the registration button is pressed for the input contents on the screen shown in the figure, construction header data, construction detail data, billing data, and scheduled collection data as shown in Figure 14 are created and registered in the storage unit 106. The "construction number" is assigned when the construction input is registered. The "construction detail Guid" is assigned to each detail on the construction input screen, and is also used to associate the construction detail data with the scheduled collection data.

[0075] Figure 14(A) is a diagram showing an example of construction header data. The construction header data includes the construction number, construction date, property code, room number, management contract number, contract number, landlord billing items, and tenant billing items. In the example shown in the figure, the first line contains the construction number "KZ001," construction date 2023 / 10 / 1, property code "B0001," room number "101," management contract number "000000012," contract number "0000000001," landlord billing items "TK0011," and tenant billing items "TK0011."

[0076] Figure 14(B) is a diagram showing an example of construction detail data. The construction detail data includes the following fields: construction detail Guid (construction detail identifier) ​​for identifying the details, construction number, item code, construction item name, landlord billing amount, tenant billing amount, contractor code, cost item, and construction cost amount. In the example shown in the figure, the first line contains construction detail Guid "1," construction number "KZ001," item code "KK001," construction item name "wallpaper replacement," landlord billing amount "150,000," tenant billing amount "50,000," contractor code "G0001, Kyobashi Construction," cost item "TK0012," and construction cost amount "200,000."

[0077] Figure 14(C) is a diagram showing an example of billing data. The billing data has fields for billing number, billing year and month, contract number, billing recipient, and management contract number. In the example shown in the figure, the first line has billing number "SE0001," billing year and month "2023 / 10," contract number "NULL," billing recipient "landlord," and management contract number "000000012," while the second line has billing number "SE0002," billing year and month "2023 / 10," contract number "0000000001," billing recipient "tenant," and management contract number "000000012."

[0078] 14(D) is a diagram showing an example of collection schedule data. The collection schedule data has the following fields: collection schedule Guid (collection schedule identifier), invoice number, collection schedule data creation category, invoice year and month, sales posting date, invoice destination, item code, amount, construction number, construction detail Guid, and advance payment customer code. In the example shown in the figure, the first line contains collection schedule Guid "1," invoice number "SE0001," collection schedule data creation category "15: Construction advance," invoice year and month "2023 / 10," sales posting date "2023 / 10 / 30," invoice destination "landlord," item code "TK0012," amount "150,000," construction number "KZ001," construction detail Guid "1," and advance payment customer code "G0001: Kyobashi Construction."

[0079] FIG. 15 is a diagram showing another example of the construction input screen 400. This figure shows an example of inputting construction number "KZ002." In the example of construction details in this figure, the first line shows that the billing amount "90,000" = the cost amount "90,000," so there is no management company income. The second line shows that the billing amount "3,000" = the cost amount "3,000," so there is no management company income.

[0080] In the case of the input contents on the screen shown in the figure, when the registration button is pressed, construction header data, construction details data, and collection schedule data as shown in FIG.

[0081] A method for creating billing data and collection schedule data through construction input processing will be described. The data from which an invoice is created are billing data and collection schedule data. The description will be made with reference to the data in Figs. 14 to 16 above.

[0082] Billing data is assigned a billing number when the first billing for that combination occurs, in units of "billing year / month, contract number, billing destination, and management outsourcing contract number." If a billing number has already been created, a new number will not be created. For construction number KZ002 in Figure 15, a billing number has already been created (see Figure 14(C)), so no billing data will be created.

[0083] The collection schedule data creation category for the collection schedule data is set to "15: Construction advances" or "16: Construction real estate income." The sum of the landlord's billing amount and tenant's billing amount in the construction detail data is compared with the construction cost amount, and if "landlord's billing amount + tenant's billing amount > construction cost amount," it means that there is income from the management company, so the part where landlord's billing amount + tenant's billing amount = construction cost amount is considered to be advances, and the part where landlord's billing amount + tenant's billing amount exceeds the construction cost amount is considered to be income for the management company, and details of the collection schedule data for "15: Construction advances" and "16: Construction real estate income" are created. In all other cases, only details for "15: Construction advances" are created.

[0084] For the "Billing item code" and "Billing amount" of the planned collection data, if the planned collection data creation category is "15: Construction advances", set the "Cost item code" and "Cost amount" of the construction detail data. If the planned collection data creation category is "16: Construction real estate income", set the billing item code of the construction header data and the "Billing amount - Cost amount" of the construction detail data. There are items for the landlord and the customer, and the source of acquisition is determined by the billing destination.

[0085] If both the landlord and tenant have a share of the cost, the cost amount is apportioned based on the share of the cost, and a breakdown of the planned collection data for "15: Construction advances" is created, and the remaining income is used to create a breakdown of the planned collection data for "16: Construction real estate income."

[0086] The data for Construction Detail Guid "2" in the above construction detail data is: landlord's share "100,000" + tenant's share "30,000" > construction cost amount "100,000", so there is income from the management company, and the collection schedule data creation categories "15: Construction Advances" and "16: Construction Real Estate Revenue" are created. When the construction cost amount "100,000" is apportioned in the ratio of landlord's share: tenant's share (10:3), the landlord's share of the construction cost amount is "77,000" and the tenant's share of the construction cost amount is "23,000". The remaining amount of each invoice, "30,000", becomes "16: Construction Real Estate Revenue", and when apportioned in the ratio of landlord's share: tenant's share (10:3), the landlord's invoice amount is "23,000" and the tenant's invoice amount is "7,000".

[0087] If it is determined that the item is an advance payment item, the contractor code of the construction details data is set as the advance payment customer code of the collection schedule data. The determination of whether it is an advance payment item is made as follows.

[0088] In the details grouped by the billing destination of the scheduled collection data and the construction detail Guid, if there is scheduled collection data "16: Construction real estate income", obtain the item code of that detail; if not, obtain the item code of the detail for the scheduled collection data creation category "15: Construction advances". Use the obtained item code as a key to obtain the invoice subject category from the journal entry pattern master 106j. If the invoice subject category is "3: Advance", set the construction contractor code of the construction detail data as the advance payment customer code, and if the invoice subject category is not "3: Advance", do not set the advance payment customer code.

[0089] In the case of the data (Collection Schedule Guid: 1) for "Billing Address: Landlord, Construction Details Guid: 1" in the collection schedule data in Figure 14 (D), since there is no collection schedule data creation category "16: Construction Real Estate Revenue", the item code "TK0012" for the collection schedule data creation category "15: Construction Advance" is obtained, and since the invoice subject category of the accounting pattern master 106j linked to the obtained item code "TK0012" is "3: Advance", the construction contractor code "G0001" for the construction details Guid "1" in the construction details data is obtained and set as the advance payment customer code.

[0090] In the case of the data (Collection Schedule Guid: 3, 4) for "Billing Address: Landlord, Construction Details Guid: 2" in the collection schedule data in Figure 14 (D), since the collection schedule data creation category "16: Construction Real Estate Revenue" exists, the item code "TK0011" for the collection schedule data creation category "16: Construction Real Estate Revenue" is obtained, and since the invoice subject category of the accounting pattern master 106j linked to the obtained item code "TK0011" is "1: Sales", no advance payment customer code is set.

[0091] In the case of the data (Collection Schedule Guid: 11) for "Billing Address: Landlord, Construction Details Guid: 5" in the collection schedule data in Figure 16 (C), since the collection schedule data creation category "16: Construction Real Estate Revenue" does not exist, the item code "TK0013" for the collection schedule data creation category "15: Construction Advances" is obtained, and since the invoice subject category of the journal entry pattern master 106j linked to the obtained item code "TK0013" is "1: Sales", the advance payment customer code is not set.

[0092] In this way, whether or not an item is an advance payment is determined based on the invoice item classification, so it is possible to recognize it as "sales" even if the collection schedule data creation classification "16: Construction real estate income" does not exist.

[0093] (S2: Invoice issuance process) A specific example of the invoice issuing process will be described with reference to Figures 17 to 24. First, a conventional invoice will be described.

[0094] (Traditional invoice) 17 and 18 are diagrams showing examples of conventional invoices. Conventionally, one invoice is output for each invoice recipient (landlord, tenant).

[0095] Figure 17(A) shows an example of an invoice for a landlord, and Figure 17(B) shows an example of the original collection schedule data. The example invoice for a landlord includes the invoice recipient "Landlord Taro," the sender's management company "Obic Management Company," and invoice details (items, notes, amount).

[0096] Figure 18(A) shows an example of a tenant invoice, and Figure 18(B) shows an example of the original collection schedule data. The example tenant invoice includes the billing address "Tenant Hanako," the sending management company "OBIC Management Company," and billing details (items, notes, amount).

[0097] (Invoices after the invoice system was introduced) 19 to 24, the issuance of invoices after the invoice system is implemented (S3: invoice issuance process in this embodiment) will be described. The invoice issuing unit 102c issues invoices based on the collection schedule data by invoice number and invoice recipient unit. At this time, if the data of the advance payment customer is set in the collection schedule data creation category, an advance payment settlement statement is issued. If the advance payment customer is not set, an eligible invoice is issued. When issuing an eligible invoice, the invoice issuing unit 102c may obtain the invoice registration number of the management company from the control master (second master) 106a and print the management company and the invoice registration number on the sender side. When issuing an advance payment settlement statement, the invoice issuing unit 102c may obtain the invoice registration number from the customer master (third master) 106d using the advance payment customer in the collection schedule data as a key, and print the advance payment customer and the obtained invoice registration number.

[0098] Invoices are output for each billing recipient, based on the billing number of the billing data. The data from which the details of the invoice are printed is the scheduled collection data. In the case of scheduled collection data generated from construction input, it is aggregated and printed using the construction detail Guid. The item name is obtained by obtaining the billing item code from the construction header data using the construction number of the construction detail data linked to the construction detail Guid of the scheduled collection data as a key, and then obtaining and printing the rent item name from the rent item master 106i using the obtained billing item code as a key.

[0099] Invoice items without an advance payment customer code are output in the format of a qualified invoice, and invoice items with an advance payment customer code are output in the format of an advance payment settlement slip for each advance payment customer (construction contractor). In the case of a qualified invoice, the management company's invoice registration number to be printed on the sender side is obtained from the control master 106a. In the case of an advance payment settlement slip, the management company's invoice registration number is not printed on the sender side. Using the advance payment customer code of the collection schedule data as a key, the customer name and invoice registration number are obtained from the customer master 106d, and the construction contractor's customer name and invoice registration number are printed as advance payment customer information.

[0100] Figures 19 to 21 are diagrams showing examples of invoices for landlords. Figure 19(A) shows an example of a qualified invoice for a landlord with invoice number "SE0001" and collection schedule Guids 3, 4, and 11, and Figure 19(B) shows an example of the original collection schedule data. The example of a qualified invoice for a landlord shown in Figure 19(A) includes the invoice recipient "Landlord Taro," the sender's management company "Obic Management Company, Registration Number: T111," and invoice details (item "repair costs," note "tatami mat replacement," amount "100,000," item "repair costs," note "parts replacement," amount "3,000").

[0101] Figure 20(A) shows an example of an advance payment settlement slip for a landlord with invoice number "SE0001" and collection schedule Guid 1, and Figure 20(B) shows an example of the original collection schedule data. The example of an advance payment settlement slip for a landlord shown in Figure 20(A) includes the invoice recipient "Landlord Taro," the sender's management company "OBIC Management Company," invoice details (item "repair costs," note "wallpaper replacement," amount "150,000"), and the advance payment business partner "Kyobashi Construction, registration number: T222."

[0102] Figure 21(A) shows an example of a landlord advance payment settlement form with invoice number "SE0001" and collection schedule Guid 9, and Figure 21(B) shows an example of the original collection schedule data. The example of a landlord advance payment settlement form shown in Figure 21(A) includes the invoice recipient "Landlord Taro," the sender's management company "OBIC Management Company," the invoice details (item "repair costs," remarks "balcony repair," amount "70,000"), and the advance payment business partner "△△ Construction Company, registration number: T333."

[0103] Figures 22 to 24 are diagrams showing examples of invoices for tenants. Figure 22(A) shows an example of a qualified invoice for a tenant with invoice number "SE0002" and collection schedule Guids 5, 6, 7, and 8, and Figure 22(B) shows an example of the original collection schedule data. The example of a qualified invoice for a tenant shown in Figure 22(A) includes the invoice recipient "Tenant Hanako," the sender's management company "OBIC Management Company, Registration Number: T111," and invoice details (item "repair costs," note "tatami mat replacement," amount "30,000," item "repair costs," note "toilet water leak repair work," amount "80,000").

[0104] Figure 23(A) shows an example of a tenant advance payment settlement slip for invoice number "SE0002" and collection schedule Guid 2, and Figure 23(B) shows an example of the original collection schedule data. The example tenant advance payment settlement slip shown in Figure 23(A) includes the invoice recipient "Tenant Hanako," the sender's management company "OBIC Management Company," invoice details (item "repair costs," note "wallpaper replacement," amount "50,000"), and the advance payment business partner "Kyobashi Construction, registration number: T222."

[0105] Figure 24(A) shows an example of a tenant advance payment settlement form with invoice number "SE0002" and collection schedule Guid 10, and Figure 24(B) shows an example of the original collection schedule data. The example tenant advance payment settlement form shown in Figure 24(A) includes the invoice recipient "Tenant Hanako," the sender's management company "OBIC Management Company," the invoice details (item "repair costs," remarks "balcony repair," amount "20,000"), and the advance payment business partner "△△ Construction Company, registration number: T333."

[0106] As described above, in this embodiment, the journal entry pattern master (first master) 106j is a master that associates and registers cost items or billing items with invoice subject classifications including sales or advance payments, and in response to an operator's operation on the construction input screen, construction header data including the construction number, occurrence date, property, room number, landlord billing item, and tenant billing item, construction detail data including a construction detail identifier that identifies each detail, construction number, construction item, landlord billing amount, tenant billing amount, construction company, cost item, and construction cost amount, and billing data including the billing number, billing year and month, and billing destination. a construction input unit 102b that creates collection schedule data including a collection schedule identifier for identifying each detail, an invoice number, a collection schedule data creation category that specifies construction advances or construction real estate income, the invoice year and month, the sales recording date, a billing recipient that is the landlord or tenant, an item that is a billing item or a cost item, the invoice amount, the construction number, the construction detail identifier, and the advance payment customer; and an invoice based on the collection schedule data in units of the invoice number and the billing recipient, and at that time, if the advance payment customer data is set in the collection schedule data creation category, an advance payment settlement statement is issued, and if the advance payment customer is not set, an appropriate and an invoice issuing unit 102c that issues invoices for the construction project. The construction input unit 102b, for the collection schedule data, (1) creates details of the collection schedule data creation category "construction advances" and "construction real estate income" if the landlord billing amount + tenant billing amount > construction cost amount, and creates details of the "construction advances" if the landlord billing amount + tenant billing amount ≦ construction cost amount, and (2) for the items and amounts, if the collection schedule data creation category is "construction advances", it sets the cost items and construction costs of the construction detail data, and if the collection schedule data creation category is "construction real estate income", it sets the invoice items and construction costs of the construction header data. (3) In the details grouped by the billing destination and construction detail identifier of the collection schedule data, if the collection schedule data creation category is "construction real estate income", the item of that detail is acquired, and if not, the item of the detail of the collection schedule data creation category "construction advance payment" is acquired, and the acquired item is used as a key to acquire the invoice subject category from the journal pattern master (first master) 106j, and if the acquired invoice subject category is "advance payment", the construction company of the construction detail data data is set as the advance payment customer. Therefore, after the introduction of the invoice system,By automatically determining whether to output a qualified invoice or an advance payment settlement statement based on the difference between the billing amount and the cost amount in the construction data, it is possible to reduce the workload of operators when issuing invoices.

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

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

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

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

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

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

[0113] Furthermore, with regard to the bill processing 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.

[0114] For example, all or any part of the processing functions of the invoice processing device 100, particularly the processing functions performed by the control unit, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented 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 processing device 100 as needed. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to issue instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to form the control unit.

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

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

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

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

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

[0120] 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]

[0121] 100 Invoice processing device 102 Control section 102a Master Maintenance Department 102b Construction input section 102c Billing Department 102d Screen display control unit 104 Communication interface unit 106 Storage section 106a Control Master 106b Property Master 106c Room Master 106d Customer Master 106e Management contract master 106f Management contract master by room 106g Contract Master 106h Construction item master 106i Rent Item Master 106j Journal Entry Pattern Master 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

1. An invoice processing device including a control unit for a management company to issue invoices to landlords and / or tenants of real estate properties, The control unit The system is configured to be able to access a first master in which cost items or billing items are associated with invoice subject classifications including sales or advance payments, and the first master is registered; construction input means for creating construction header data including construction number, date of occurrence, property, room number, landlord billing item, and tenant billing item in response to an operator's operation on the construction input screen; construction detail data including construction detail identifiers for identifying each detail, construction number, construction items, landlord billing amount, tenant billing amount, contractor, cost items, and construction cost amount; billing data including billing number, billing year and month, and billing recipient; collection schedule data including collection schedule identifiers for identifying each detail, billing number, collection schedule data creation category specifying construction advance or construction real estate income, billing year and month, sales recording date, billing recipient which is the landlord or tenant, billing item or cost item, billing amount, construction number, construction detail identifier, and advance payment customer; an invoice issuing means for issuing an invoice based on the collection schedule data for each invoice number and invoice recipient, and at this time, if data on an advance payment customer is set in the collection schedule data creation category, issuing an advance payment settlement statement, and if an advance payment customer is not set, issuing a qualified invoice; Equipped with The construction input means, regarding the collection schedule data, (1) If the landlord's claim amount + tenant's claim amount > construction cost amount, create details of "construction advances" and "construction real estate income" in the collection schedule data creation category, and if the landlord's claim amount + tenant's claim amount ≦ construction cost amount, create details of "construction advances", (2) When the collection schedule data creation category is "construction advance payment," the cost items and construction costs of the construction detail data are set. When the collection schedule data creation category is "construction real estate income," the billing items and "billing amount - cost amount" of the construction header data are set. (3) In the details grouped by the billing destination and construction detail identifier of the collection schedule data, if the collection schedule data creation category is "construction real estate income", the item of that detail is obtained, and if not, the item of the detail with the collection schedule data creation category "construction advance payment" is obtained, and the invoice subject category is obtained from the first master using the obtained item as a key, and if the obtained invoice subject category is "advance payment", the construction company of the construction detail data is set as the advance payment customer.

2. The invoice processing device according to claim 1, characterized in that, when the landlord's billing amount + tenant's billing amount > construction cost amount, if both the landlord and tenant have contributions, the construction cost amount and the landlord's billing amount + tenant's billing amount - construction cost amount are apportioned based on the proportion of the contributions.

3. The control unit The system is configured to be able to access a second master in which the invoice registration number of the management company is registered, An invoice processing device as described in claim 1 or 2, characterized in that when issuing a qualified invoice, the invoice issuing means obtains the invoice registration number of the management company from the second master and prints the management company and invoice registration number on the sender's side.

4. The control unit The system is configured to be able to access a third master in which business partners, including construction companies, are registered in association with invoice registration numbers, The invoice processing device according to claim 1 or 2, characterized in that when issuing an advance payment settlement statement, the invoice issuing means obtains an invoice registration number from the third master using the advance payment customer in the collection schedule data as a key, and prints out the advance payment customer and the obtained invoice registration number.

5. An invoice processing method for a management company to issue invoices to landlords and / or tenants of real estate properties, using an information processing device equipped with a control unit, The control unit The system is configured to be able to access a first master in which cost items or billing items are associated with invoice subject classifications including sales or advance payments, and the first master is registered; Executed in the control unit: a construction input process for creating construction header data including construction number, date of occurrence, property, room number, landlord billing item, and tenant billing item in response to an operator's operation on the construction input screen; construction detail data including construction detail identifiers for identifying each detail, construction number, construction items, landlord billing amount, tenant billing amount, contractor, cost items, and construction cost amount; billing data including billing number, billing year and month, and billing recipient; collection schedule data including collection schedule identifiers for identifying each detail, billing number, collection schedule data creation category specifying construction advance or construction real estate income, billing year and month, sales recording date, billing recipient which is the landlord or tenant, billing item or cost item, billing amount, construction number, construction detail identifier, and advance payment customer; an invoice issuing step of issuing an invoice based on the collection schedule data for each invoice number and invoice recipient, and at that time, if the data of the advance payment customer is set in the collection schedule data creation section, issuing an advance payment settlement statement, and if the advance payment customer is not set, issuing a qualified invoice; Including, In the construction input step, the collection schedule data is (1) If the landlord's claim amount + tenant's claim amount > construction cost amount, create details of "construction advances" and "construction real estate income" in the collection schedule data creation category, and if the landlord's claim amount + tenant's claim amount ≦ construction cost amount, create details of "construction advances", (2) When the collection schedule data creation category is "construction advance payment," the cost items and construction costs of the construction detail data are set. When the collection schedule data creation category is "construction real estate income," the billing items and "billing amount - cost amount" of the construction header data are set. (3) In the details grouped by the billing destination and construction detail identifier of the collection schedule data, if the collection schedule data creation category is "construction real estate income", the item of that detail is obtained, and if not, the item of the detail with the collection schedule data creation category "construction advance payment" is obtained, and the invoice subject category is obtained from the first master using the obtained item as a key, and if the obtained invoice subject category is "advance payment", the construction company of the construction detail data is set as the advance payment customer.

6. An invoice processing program for a management company to issue invoices to landlords and / or tenants of real estate properties, the invoice processing program being executed by an information processing device having a control unit, The control unit The system is configured to be able to access a first master in which cost items or billing items are associated with invoice subject classifications including sales or advance payments, and the first master is registered; In the control unit, a construction input process for creating construction header data including construction number, date of occurrence, property, room number, landlord billing item, and tenant billing item in response to an operator's operation on the construction input screen; construction detail data including construction detail identifiers for identifying each detail, construction number, construction items, landlord billing amount, tenant billing amount, contractor, cost items, and construction cost amount; billing data including billing number, billing year and month, and billing recipient; collection schedule data including collection schedule identifiers for identifying each detail, billing number, collection schedule data creation category specifying construction advance or construction real estate income, billing year and month, sales recording date, billing recipient which is the landlord or tenant, billing item or cost item, billing amount, construction number, construction detail identifier, and advance payment customer; an invoice issuing step of issuing an invoice based on the collection schedule data for each invoice number and invoice recipient, and at that time, if the data of the advance payment customer is set in the collection schedule data creation section, issuing an advance payment settlement statement, and if the advance payment customer is not set, issuing a qualified invoice; An invoice processing program for executing In the construction input step, the collection schedule data is (1) If the landlord's claim amount + tenant's claim amount > construction cost amount, create details of "construction advances" and "construction real estate income" in the collection schedule data creation category, and if the landlord's claim amount + tenant's claim amount ≦ construction cost amount, create details of "construction advances", (2) When the collection schedule data creation category is "construction advance payment," the cost items and construction costs of the construction detail data are set. When the collection schedule data creation category is "construction real estate income," the billing items and "billing amount - cost amount" of the construction header data are set. (3) In the details grouped by the billing destination and construction detail identifier of the collection schedule data, if the collection schedule data creation category is "construction real estate income", the item of that detail is obtained, and if not, the item of the detail with the collection schedule data creation category "construction advance payment" is obtained, and the invoice subject category is obtained from the first master using the obtained item as a key, and if the obtained invoice subject category is "advance payment", the construction company of the construction detail data is set as the advance payment customer.

Images