Bill processing device, bill processing method, and bill 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 an invoice processing device, an invoice processing method, and an invoice 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 must issue a "qualified invoice" for the cost of the company's sales, but when it issues an invoice for the cost of the business partner that it paid in advance, it must issue an "advance payment settlement slip." 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] JP 2022-179153 A 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 an operator when issuing an invoice 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 allows a management company to issue an invoice to a landlord and / or a tenant of a real estate property, the control unit being 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 in response to an operator's operation on a construction input screen, construction header data including a construction number, an occurrence date, the property, the room number, the landlord's billing items, and the tenant's billing items, construction detail identifiers for identifying each detail, construction number, construction item, a construction input means for creating collection schedule data including 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, a collection schedule identifier for identifying each detail, the billing number, a collection schedule data creation category specifying the construction advance or construction real estate income, the billing 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 billing amount, the construction number, the construction detail identifier, and a billing recipient; and a bill 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 when data on an advance payment customer is set in the collection schedule data creation section, and for issuing a qualified invoice when no advance payment customer is set. The construction input means, for the collection schedule data, (1) creates details of "construction advance payment" and "construction real estate income" in the collection schedule data creation section when the landlord billing amount + tenant billing amount > construction cost amount, and creates details of "construction advance payment" in the collection schedule data creation section when the landlord billing amount + tenant billing amount ≦ construction cost amount, and (2) the above items and the above amounts are added to the collection schedule data. If the data creation category is "construction advances", set the cost item and construction cost of the construction detail data, and if the recovery schedule data creation category is "construction real estate income", set the billing item 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 of the construction details data is set as the advancing customer.

[0007] In addition, according to one aspect of the present invention, when 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 may be apportioned proportionately based on the ratio of their contributions.

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

[0009] According to another aspect of the present invention, the control unit 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, and when the invoice issuing means issues an advance payment settlement statement, it may obtain the invoice registration number from the third master using the advance payment business partner of the collection schedule data as a key, and print out the advance payment business partner and the obtained invoice registration number.

[0010] In addition, 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 issues an invoice to a landlord and / or tenant of a real estate property by a management company, the control unit being 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 is configured to access a first master in which construction header data including construction number, date of occurrence, property, room number, landlord billing items, and tenant billing items are registered in response to an operator's operation on a construction input screen executed by the control unit, 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 construction input process for creating collection schedule data including a collection schedule identifier for identifying each detail, a billing number, a collection schedule data creation category specifying a construction advance or construction real estate income, a billing year and month, a sales recording date, a billing recipient that is a 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, an advance payment settlement statement is issued, and if an advance payment customer is not set, a qualified invoice is issued. 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) 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) for 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 items of that detail, or if not, obtain the items of the detail of the collection schedule data creation category "construction advances", and use the obtained items as a key,The method is characterized in that an invoice subject category is acquired from the first master, and when the acquired invoice subject category is "advance payment", the construction business operator of the construction details 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 an invoice to a landlord and / or a tenant of a real estate property, the program being executed by an information processing device having a control unit, the control unit being 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 being configured to access a first master in which construction header data including construction number, date of occurrence, property, room number, landlord billing items, and tenant billing items are registered 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 construction input process for creating collection schedule data including 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 which is a landlord or tenant, an item which 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 slip, 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" in the collection schedule data creation section are created, and if the landlord billing amount + tenant billing amount <= construction cost amount, In the case of the amount, a detail of "construction advances" is created; (2) for the above item and amount, if the collection schedule data creation category is "construction advances", the cost item and construction cost of the construction detail data are set; if the collection schedule data creation category is "construction real estate income", the billing item 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; if not, the item of the detail of the collection schedule data creation category "construction advances" is obtained;The method is characterized in that an invoice subject category is obtained from the first master using the obtained item as a key, and when the obtained invoice subject category is "advance payment", the construction business operator of the construction details data is set as the advancing customer. Effect 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 description of the drawings]

[0013] [Figure 1] FIG. 1 is a diagram showing an example of the configuration of an invoice processing device according to the present embodiment. [Diagram 2] FIG. 2 is a diagram illustrating an example of the configuration of the control master. [Diagram 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. [Diagram 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 work 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 journal entry 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 the processing of the control unit of the invoice processing device according to the present 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 the present embodiment. [Figure 15] FIG. 15 is a diagram for explaining a specific example of the processing of the control unit of the invoice processing device according to the present embodiment. [Figure 16] FIG. 16 is a diagram for explaining a specific example of the processing of the control unit of the invoice processing device according to the present embodiment. [Figure 17] FIG. 17 is a diagram for explaining a specific example of the processing of the control unit of the invoice processing device according to the present embodiment. [Figure 18] FIG. 18 is a diagram for explaining a specific example of the processing of the control unit of the invoice processing device according to the present embodiment. [Figure 19] FIG. 19 is a diagram for explaining a specific example of the processing of the control unit of the invoice processing device according to the present embodiment. [Figure 20] FIG. 20 is a diagram for explaining a specific example of the processing of the control unit of the invoice processing device according to the present embodiment. [Figure 21] FIG. 21 is a diagram for explaining a specific example of the processing of the control unit of the invoice processing device according to the present embodiment. [Figure 22] FIG. 22 is a diagram for explaining a specific example of the processing of the control unit of the invoice processing device according to the present embodiment. [Figure 23] FIG. 23 is a diagram for explaining a specific example of the processing of the control unit of the invoice processing device according to the present embodiment. [Figure 24] FIG. 24 is a diagram for explaining a specific example of the processing of the control unit of the invoice processing device according to the present embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

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

[0015] [1. Overview] The invoice system will be introduced from October 1, 2023. When a company issues an invoice to a business partner, it will issue a "qualified invoice" when claiming for expenses that correspond to the company's sales, but when claiming for expenses paid in advance on behalf of a business partner, it must issue an "advance payment settlement slip."

[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] In addition, depending on the results of negotiations between the management company and its business partners (landlords, customers, or construction companies), what was initially a bill from the management company (which has income) may ultimately become an advance payment (which the management company has no income from), or vice versa. In this way, the content of the construction fee bill may change from moment to moment depending on negotiations with business partners.

[0018] It is difficult for the operator of the management company's system to input information into the system while being aware of whether the invoice is a self-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 processing 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 performs input processing in the same way 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 automatically determines whether it is a "qualified invoice" or an "advance payment settlement statement," and switches between outputting the "qualified invoice" and the "advance payment settlement statement," making it possible to issue an appropriate invoice.

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

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

[0022] [2. Configuration] An example of the configuration of an 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 be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a 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 as to be able to communicate with each other via any communication path.

[0025] The communication interface unit 104 communicatively connects the invoice processing device 100 to a network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a 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 realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112. 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 for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, optical disks, etc. can be used as the storage unit 106.

[0028] The memory unit 106 stores, for example, a control master 106a, a property master 106b, a room master 106c, a client master 106d, a management outsourcing contract master 106e, a management outsourcing contract room-specific 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, and collection schedule data.

[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-specific 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 on the management company (our company), and can be configured as a table in which the company name and invoice registration number are registered in association with each other, as shown in Fig. 2. In the example shown in the figure, the first line shows 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 Fig. 3. The property master 106b is referenced when converting property codes and property names. In the example shown in the figure, the first line has the property code "B0001" and the property name "ABC Mansion."

[0032] The room master 106c is a master for managing rooms in 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 figure, the first line contains the property code "B0001" and the room number "101".

[0033] Supplier master (third master) 106d is a master for managing billing and payment destinations, and can be configured with a table or the like in which supplier codes, supplier names, supplier types, and invoice registration numbers are registered in association with each other, as shown in FIG. 5. Supplier master (third master) 106d is referenced when converting supplier codes and supplier names, and invoice registration numbers are referenced using the supplier as a key. In the example shown in the figure, the first line has supplier code "Y0001", supplier name "Homeowner Taro", supplier type "Homeowner", and invoice registration number " ", and the second line has supplier code "K0001", supplier name "Lesser Hanako", supplier type "Lesser", and invoice registration number " ", the third line has supplier code "G0001", supplier name "Kyobashi Construction", supplier type "Contractor", and invoice registration number "T222", the fourth line has supplier code "G0002", supplier name "XX Construction Company", supplier type "Contractor", and invoice registration number "T444", the fifth line has supplier code "G0003", supplier name "△△ Construction", supplier type "Contractor", and invoice registration number "T333", and the sixth line has supplier code "G0004", supplier name "□□ Construction", supplier type "Contractor", and 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 in which management contract numbers, property codes, and landlord codes are registered in association with each other, as shown in Fig. 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 or the like that associates and registers the management contract number, property code, room number, validity period start, and validity period end, as shown in Fig. 7. In the example shown in the figure, the first line is the management contract number "000000012", property code "B0001", room number "101", validity period start "2020 / 1 / 1", and validity period end " ".

[0036] The contract master 106g is a master for managing rental contracts with tenants, and can be configured as a table in which the contract number, contractor code, property code, room number, and initial contract date are associated and registered, as shown in Fig. 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 of the work details, and can be configured with a table in which work item codes and work item names are associated and registered, as shown in FIG. 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 is the work item code "KK001" and the work item name "wallpaper replacement", the second line is the work item code "KK002" and the work item name "tatami replacement", the third line is the work item code "KK003" and the work item name "toilet water leak work", the fourth line is the work item code "KK004" and the work item name "balcony repair", and the fifth line is 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 composed of a table in which rent item codes (item codes for billing items and cost items) and rent item names (billing item names and cost item names) are registered in association with each other, 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 (billing item names and cost item names). 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 classification for each rent item code, and can be configured as a table or the like that registers rent item codes (item codes for billing items and cost items) in association with invoice subject classifications, as shown in FIG. 11. 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 date of occurrence, 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 FIG. 14(B)).

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

[0043] The collection schedule data may include for each detail a collection schedule Guid (collection schedule identifier), invoice number, collection schedule data creation category, invoice year and month, sales recording date, invoice destination, item code, invoice 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 the code and the name corresponding to the code, but either or both of the code and the name can be used, and a master to convert between the code and the name corresponding to the code is not necessarily required. Hereinafter, XX means XX code and / or XX name (for example, supplier means supplier code and / or supplier 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 types of information processing 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 in another location (for example, server 200) as long as the control unit 102 is able to access them.

[0047] The control unit 102 conceptually includes, in terms of functions, 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 in the control master 106a, the property master 106b, the room master 106c, the business partner master 106d, the management outsourcing contract master 106e, the management outsourcing contract room-specific master 106f, the contract master 106g, the construction item master 106h, the rent item master 106i, and the accounting pattern master 106j.

[0049] 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 destination, and 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 the "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 the "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. The billing item and "billing amount - cost amount" are set, (3) in the details grouped by the billing destination of the data to be collected and the construction detail identifier, if the data to be collected creation category is "construction real estate income", the item of that detail is obtained, or if not, the item of the detail with the data to be collected creation category "construction advances" is obtained, and using the obtained item as a key, the invoice subject category is obtained from the accounting pattern master (first master) 106j, and if the obtained invoice subject category is "advance payment", the construction contractor of the construction detail data data is set as the advance payment customer.

[0051] In addition, when landlord's billing amount + tenant's billing amount > construction cost amount, if both the landlord and tenant have contributions, the construction input unit 102b prorates the construction cost amount and the landlord's billing amount + tenant's billing amount - construction cost amount based on the ratio of their contributions.Also, even when 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 prorated based on the ratio 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 section, an advance payment settlement statement is issued, and if the advance payment customer is not set, a qualified invoice is issued.

[0053] When issuing a qualified 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 name of the management company and the invoice registration number on the sender.

[0054] When issuing an advance payment settlement statement, the invoice issuing unit 102c may obtain an invoice registration number from the supplier master (third master) 106d using the advance payment supplier in the collection schedule data as a key, and print out the advance payment supplier 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. In the following explanation, the master data examples in Figures 2 to 11 will be used for explanation.

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

[0058] In FIG. 12, the construction input unit 102b executes construction input processing (step S1). Specifically, in the construction input process, 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 destination, and 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.

[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 the "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 the "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. The billing item and "billing amount - cost amount" are set, (3) in the details grouped by the billing destination of the data to be collected and the construction detail identifier, if the data to be collected creation category is "construction real estate income", the item of that detail is obtained, or if not, the item of the detail with the data to be collected creation category "construction advances" is obtained, and using the obtained item as a key, the invoice subject category is obtained from the accounting pattern master (first master) 106j, and if the obtained invoice subject category is "advance payment", the construction contractor of the construction detail data data is set as the advance payment customer.

[0060] In addition, when landlord's billing amount + tenant's billing amount > construction cost amount, if both the landlord and tenant have contributions, the construction input unit 102b prorates the construction cost amount and the landlord's billing amount + tenant's billing amount - construction cost amount based on the ratio of their contributions.Also, even when 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 prorated based on the ratio 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 section, 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 invoice registration number of the management company from the control master (second master) 106a and print the name of the management company and the invoice registration number on the sender.

[0063] When issuing an advance payment settlement statement, the invoice issuing unit 102c may obtain an invoice registration number from the supplier master (third master) 106d using the advance payment supplier in the collection schedule data as a key, and print out the advance payment supplier 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 explained with reference to Figs. 13 to 24. In the following, an example will be described in which the example master configurations shown in the above-mentioned Figs. 2 to 11 are used.

[0065] (S1: Construction input processing) A specific example of the construction input process will be described with reference to Fig. 13 to Fig. 16. The construction input unit 102b creates construction header data including construction number, date of occurrence, property, room number, landlord billing item, and tenant billing item, construction detail data including construction detail identifier for identifying each detail, construction number, construction item, landlord billing amount, tenant billing amount, construction company, cost item, and construction cost amount, billing data including billing number, billing year and month, and billing destination, collection schedule data including collection schedule identifier for identifying each detail, billing number, collection schedule data creation category specifying construction advance or construction real estate income, billing year and month, sales posting date, billing destination which is the landlord or tenant, billing item or cost item, billing amount, construction number, construction detail identifier, and advance payment destination, and registers the 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 the "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 the "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 data to be collected is created in the category of "construction real estate income", the item of that detail is obtained; if not, the item of the detail with the data to be collected in the category of "construction advances" is obtained; using the obtained item as a key, the invoice subject category is obtained from the accounting pattern master (first master) 106j; and if the obtained invoice subject category is "advance", the construction contractor of the construction detail data is set as the advance payment customer.

[0067] In addition, when landlord's billing amount + tenant's billing amount > construction cost amount, if both the landlord and tenant have contributions, the construction input unit 102b prorates the construction cost amount and the landlord's billing amount + tenant's billing amount - construction cost amount based on the ratio of their contributions.Also, even when 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 prorated based on the ratio of their contributions.

[0068] FIG. 13 is a diagram showing a display example of the construction input screen 400. In the figure, an input example of the construction number "KZ001" is shown. The construction input screen 400 has a header area 401 for inputting the construction number, property, room number, management contract number, contract number, landlord, tenant, occurrence date, billing year and month, sales posting date, landlord billing item, tenant billing item, etc., a construction details area 402 for inputting the construction details (construction item name, billing amount (landlord), billing amount (tenant), construction company, construction cost, cost item), and a registration button (not shown). In addition, in the header area 401, when the management contract number is input, the landlord and tenant are automatically input (automatically displayed) read 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 work details area 402 and presses a registration button (not shown), the work input unit 102b creates work header data, work details data, billing data, and collection schedule data according to the input contents in the header area 401 and the work 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 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 recognition 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 billing amount (homeowner) "150,000", the billing amount (tenant) "50,000", the contractor "G0001: Kyobashi Construction", the construction cost "200,000", and the cost item "TK0012: Repair cost payment". The second line shows the construction item name "KK002: Tatami replacement", the billing amount (homeowner) "100,000", the billing amount (tenant) "50,000", the contractor "G0001: Kyobashi Construction", the construction cost "200,000", and the cost item "TK0012: Repair cost payment". ) "30,000", contractor "G0001: Kyobashi Construction", construction cost "100,000", cost item "TK0012: Payment of repair costs", and on the third line, the construction item name is "KK003: Toilet leak repair", invoice amount (landlord) "0", invoice amount (tenant) "80,000", contractor "G0002: XX construction company", construction cost "70,000", cost item "TK0012: Payment of repair costs".

[0072] If the billing amount is "billing amount (landlord) + billing amount (tenant)", by comparing the billing amount with the cost amount, it is possible to determine whether the management company has income or not. 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 of construction details in the figure, the first line has no management company income because the billed amount "200,000" = cost amount "200,000." The second line has a management company income because the billed amount "130,000" > cost amount "100,000." The third line has a management company income because the billed amount "80,000" > cost amount "70,000."

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

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

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

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

[0078] FIG. 14(D) is a diagram showing an example of collection schedule data. The collection schedule data includes items such as collection schedule Guid (collection schedule identifier), billing number, collection schedule data creation category, billing year and month, sales posting date, billing destination, item code, amount, construction number, construction details Guid, and advance payment customer code. In the example shown in the figure, the first line includes collection schedule Guid "1", billing number "SE0001", collection schedule data creation category "15: construction advance payment", billing year and month "2023 / 10", sales posting date "2023 / 10 / 30", billing destination "homeowner", item code "TK0012", amount "150,000", construction number "KZ001", construction details Guid "1", and advance payment customer code "G0001: Kyobashi Construction Company".

[0079] 15 is a diagram showing another example of the display 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 has a billing amount of "90,000" = cost amount of "90,000", so there is no management company income. The second line has a billing amount of "3,000" = cost amount of "3,000", so there is no management company income.

[0080] When the registration button is pressed for the contents entered on the screen shown in the figure, construction header data, construction details data, and collection schedule data as shown in FIG.

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

[0082] Billing data is assigned a billing number in units of "billing month and year, contract number, billing destination, and management outsourcing contract number" when a bill for that combination occurs for the first time. If a billing number has already been created, a new one will not be created. For construction number KZ002 in Figure 15, a billing number has already been created (see Figure 14 (C)), so billing data will not 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 billing amount and tenant billing amount in the construction detail data is compared with the construction cost amount, and if "landlord billing amount + tenant billing amount > construction cost amount," it means that there is management company income, so the part where the landlord billing amount + tenant billing amount = construction cost amount is the advance, and the part where the landlord billing amount + tenant billing amount exceeds the construction cost amount is the management company income, 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 "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] In addition, if both the landlord and tenant have a share of the cost, the cost amount will be apportioned based on the share of the cost, and a breakdown of the data to be collected under "15: Construction Advances" will be created, and for the remaining income, a breakdown of the data to be collected under "16: Construction Real Estate Income" will be created.

[0086] The data for construction details Guid "2" in the above construction details 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 collection schedule data creation categories "15: Construction advance payment" and "16: Construction real estate income" are created. When the construction cost amount "100,000" is apportioned in the ratio of landlord's share: tenant's share (10:3), the construction cost amount for the landlord is "77,000" and the construction cost amount for the tenant is "23,000". The remaining amount of each bill, "30,000", becomes "16: Construction real estate income", and when apportioned in the ratio of landlord's share: tenant's share (10:3), the landlord's bill amount is "23,000" and the tenant's bill amount is "7,000".

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

[0088] For details grouped by billing destination of the data to be collected and construction detail Guid, if there is data to be collected "16: Construction real estate income", obtain the item code of that detail, or if not, obtain the item code of the detail of data to be collected creation category "15: Construction advances". Using the obtained item code as a key, 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 from 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 destination: Landlord, Construction Detail Guid: 1" in the collection schedule data in Figure 14 (D), since the collection schedule data creation category "16: Construction real estate income" does not exist, the item code "TK0012" for the collection schedule data creation category "15: Construction advances" is obtained, and since the invoice subject category of the accounting pattern master 106j linked to the obtained item code "TK0012" is "3: Advances", the construction contractor code "G0001" for the construction detail data's construction detail Guid "1" is obtained and set as the advance payment customer code.

[0090] In the case of the data (Collection Schedule Guid: 3, 4) for "Billing destination: 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 income" exists, the item code "TK0011" for the collection schedule data creation category "16: Construction real estate income" 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: 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 income" 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 accounting pattern master 106j linked to the obtained item code "TK0013" is "1: Sales", no advance payment customer code is set.

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

[0093] (S2: Invoice issuing process) A specific example of an 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 was output for each invoice destination (landlord, tenant).

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

[0096] Figure 18(A) shows an example of an invoice for a tenant, and Figure 18(B) shows an example of the original collection schedule data. The example of the invoice for a tenant includes the invoice recipient "Tenant Hanako-sama," the sender's management company "OBIC Management Company," and invoice details (items, notes, amount).

[0097] (Invoices after the invoice system was introduced) With reference to Figs. 19 to 24, the issuance of an invoice after the invoice system is started (S3: invoice issuance process in this embodiment) will be described. 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 section, an advance payment settlement statement is issued, and 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. 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 of 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 invoice details are printed is the scheduled collection data. In the case of scheduled collection data generated from construction input, it is aggregated and printed by 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 printed on the sender 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. 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 the advance payment customer information.

[0100] 19 to 21 are diagrams showing examples of invoices for homeowners. FIG. 19(A) shows an example of a qualified invoice for a homeowner with invoice number "SE0001" and collection schedule Guids 3, 4, and 11, and FIG. 19(B) shows an example of the original collection schedule data. The example of a qualified invoice for a homeowner shown in FIG. 19(A) lists the invoice recipient "Homeowner Taro," the sender's management company "OBIC Management Company, Registration Number: T111," and invoice details (item "repair costs," note "re-upholstering tatami mats," amount "100,000," item "repair costs," note "parts replacement," amount "3,000").

[0101] Figure 20(A) shows an example of an advance payment statement 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 statement 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's advance payment statement 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 the landlord's advance payment statement shown in Figure 21(A) includes the invoice recipient "Landlord Taro", the sender's management company "OBIC Management Company", 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 tenant qualified invoice 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 tenant qualified invoice shown in Figure 22(A) lists the invoice recipient "Tenant Hanako", the sender's management company "OBIC Management Company, Registration Number: T111", and invoice details (item "repair costs", note "re-upholstering tatami mats", amount "30,000", item "repair costs", note "toilet 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) lists 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 advance payment business partner "Kyobashi Construction, registration number: T222".

[0105] Figure 24(A) shows an example of a tenant advance payment statement 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 statement shown in Figure 24(A) includes the invoice recipient "Tenant Hanako", the sender's management company "OBIC Management Company", 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 accounting pattern master (first master) 106j is a master that associates and registers cost items or billing items with invoice subject categories including sales or advance payment, and in response to an operator's operation on the construction input screen, construction header data including construction number, date of occurrence, property, room number, landlord billing item, and tenant billing item, construction detail data including construction detail identifiers for identifying each detail, construction number, construction item, landlord billing amount, tenant billing amount, construction company, cost item, and construction cost amount, and billing data including 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, a billing number, a collection schedule data creation category that specifies construction advances or construction real estate income, the billing year and month, the sales recording date, a billing party that is a landlord or tenant, an item that is a billing item or a cost item, the billing amount, a construction number, a construction detail identifier, and an advance payment customer; and a billing number and a billing party that issues an invoice based on the collection schedule data, and if data on the advance payment customer is set in the collection schedule data creation category, an advance payment settlement slip is issued, and if the advance payment customer is not set, an appropriate and an invoice issuing unit 102c that issues an invoice for the construction work. 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 invoice amount + tenant invoice amount > construction cost amount, and creates details of the "construction advances" if the landlord invoice amount + tenant invoice amount ≦ construction cost amount, and (2) sets the items and amounts in the construction detail data when the collection schedule data creation category is "construction advances", and sets the invoice items and construction costs in the construction header data when the collection schedule data creation category is "construction real estate income". (3) in the details grouped by the billing destination and construction detail identifier of the data to be collected, if the data to be collected is classified as "construction real estate income", the item of that detail is obtained. If not, the item of the data to be collected with the data to be collected category "construction advance" is obtained. Using the obtained item as a key, the invoice subject category is obtained from the accounting pattern master (first master) 106j. If the obtained invoice subject category is "advance payment", the construction business operator of the construction detail data data is set as the advance payment customer. Therefore, after the invoice system is introduced,By automatically determining whether to output a qualified invoice or an advance payment settlement slip 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 goals 8 and 9 of the SDGs.

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

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

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

[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] In addition, the processing procedures, control procedures, specific names, registered data for each process, information including parameters such as search conditions, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

[0113] Furthermore, with regard to the bill processing device 100, the components shown in the figures are merely functional concepts, and the bill processing device 100 does 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 realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium that contains 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 necessary. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for cooperating with the OS to give instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and cooperates with the CPU to form the control unit.

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

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

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

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

[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 the information processing device to which any peripheral device is connected. The invoice processing device 100 may be realized by installing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

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

[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 section 106 Storage section 106a Control Master 106b Property Master 106c Room Master 106d Customer Master 106e Management Contract Master 106f Management contract room master 106g Contract Master 106h Construction item master 106i Rent Item Master 106j Journal Entry Pattern Master 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. A billing device for issuing a bill to a landlord and / or a tenant of a real estate property by a management company, the billing device comprising: The control unit is The system 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 payment, a construction input means for creating construction header data including construction number, date of occurrence, property, room number, landlord's billing item, and tenant's billing item in response to an operator's operation on a construction input screen, construction detail data including a construction detail identifier for identifying each detail, 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, and collection schedule data including a collection schedule identifier for identifying each detail, the billing number, the collection schedule data creation category specifying 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, construction number, construction detail identifier, and advance payment destination; an invoice issuing means for issuing an invoice based on the collection schedule data for each of the invoice numbers and invoice recipients, and at that time, when data on an advance payment customer is set in the collection schedule data creation section, issuing an advance payment settlement statement, and when 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 billing amount + tenant's billing amount > construction cost amount, create details of "construction advance payment" and "construction real estate income" in the recovery schedule data creation category, and if the landlord's billing amount + tenant's billing amount ≦ construction cost amount, create details of "construction advance payment", (2) When the collection schedule data creation category is "construction advance payment", the cost item and construction cost of the construction detail data are set, and when the collection schedule data creation category is "construction real estate income", the billing item and "billing amount - cost amount" of the construction header data are set. (3) An invoice processing device characterized in that, in the details grouped by the billing destination and construction detail identifier of the data to be collected, if the data to be collected is classified as "construction real estate income", an item of that detail is obtained, and if not, an item of the detail with the data to be collected as classified as "construction advances" is obtained, and using the obtained item as a key, an invoice subject category is obtained from the first master, 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 proportionately based on the ratio of their contributions.

3. The control unit is The system is configured to be able to access a second master in which the invoice registration number of the management company is registered, 3. An invoice processing device as claimed 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 the invoice registration number on the sender.

4. The control unit is The system is configured to be able to access a third master in which business partners, including construction companies, are associated with invoice registration numbers and registered, 3. The invoice processing device according to claim 1, wherein, 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 an invoice to a landlord and / or a tenant of a real estate property, comprising: The control unit is The system 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 payment, Executed in the control unit, a construction input process for creating construction header data including construction number, date of occurrence, property, room number, landlord's billing item, and tenant's billing item in response to an operator's operation on the construction input screen, construction detail data including a construction detail identifier identifying each detail, 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, billing number, collection schedule data creation category specifying construction advance or construction real estate income, billing year and month, sales recording date, billing destination which is the landlord or tenant, billing item or cost item, billing amount, construction number, construction detail identifier, and advance payment destination; an invoice issuing step for issuing an invoice based on the collection schedule data by the 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, an advance payment settlement statement is issued, and if the advance payment customer is not set, a qualified invoice is issued; Including, In the construction input step, the collection schedule data is (1) If the landlord's billing amount + tenant's billing amount > construction cost amount, create details of "construction advance payment" and "construction real estate income" in the recovery schedule data creation category, and if the landlord's billing amount + tenant's billing amount ≦ construction cost amount, create details of "construction advance payment", (2) When the collection schedule data creation category is "construction advance payment", the cost item and construction cost of the construction detail data are set, and when the collection schedule data creation category is "construction real estate income", the billing item and "billing amount - cost amount" of the construction header data are set. (3) In a detail grouped by the billing destination and construction detail identifier of the data to be collected, if the data to be collected is classified as "construction real estate income", an item of that detail is obtained, and if not, an item of the detail with the data to be collected as classified as "construction advances" is obtained, and an 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 contractor of the construction detail data is set as the advance payment customer.

6. An invoice processing program for a management company to issue an invoice to a landlord and / or a tenant of a real estate property, the invoice processing program being executed by an information processing device having a control unit, The control unit is The system 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 payment, In the control unit, a construction input process for creating construction header data including construction number, date of occurrence, property, room number, landlord's billing item, and tenant's billing item in response to an operator's operation on the construction input screen, construction detail data including a construction detail identifier identifying each detail, 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, billing number, collection schedule data creation category specifying construction advance or construction real estate income, billing year and month, sales recording date, billing destination which is the landlord or tenant, billing item or cost item, billing amount, construction number, construction detail identifier, and advance payment destination; an invoice issuing step for issuing an invoice based on the collection schedule data by the 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, an advance payment settlement statement is issued, and if the advance payment customer is not set, a qualified invoice is issued; An invoice processing program for executing In the construction input step, the collection schedule data is (1) If the landlord's billing amount + tenant's billing amount > construction cost amount, create details of "construction advance payment" and "construction real estate income" in the recovery schedule data creation category, and if the landlord's billing amount + tenant's billing amount ≦ construction cost amount, create details of "construction advance payment", (2) When the collection schedule data creation category is "construction advance payment", the cost item and construction cost of the construction detail data are set, and when the collection schedule data creation category is "construction real estate income", the billing item and "billing amount - cost amount" of the construction header data are set. (3) An invoice processing program characterized by: (a) obtaining an item of a detail for which the collection schedule data creation category is "construction real estate income" in the details grouped by the billing destination and construction detail identifier of the collection schedule data; and (b) obtaining an item of a detail for which the collection schedule data creation category is "construction advances" if the item is not included; obtaining an invoice subject category from the first master using the obtained item as a key; and (c) setting the construction contractor of the construction detail data as the advance customer if the obtained invoice subject category is "advance payment."

Images