Bill processing device, bill processing method, and bill processing program

Abstract

To reduce workload of a responsible person by issuing a bill that meets the requirements of the invoice system according to combination of a landlord's delegation / management form and a billed item.SOLUTION: Provided is a bill processing device comprising billing calculation processing means and bill output means. The billing calculation processing means creates collection schedule data including a collection schedule identifier for identifying each line item, a billing number, a billing year / month, a sales recording date, a billing item, a main body amount, a consumption tax, a property, a room number, a contract number, a management contract number, a delegation / management form, a client that is a customer, and advance payment destination. The bill output means creates, on the basis of the collection schedule data, billing work data including the collection schedule identifier, the billing item, the billing year / month, a client code, the sales recording date, the management contract number, the delegation / management form, a registered landlord FLG indicating whether or not the landlord is a qualified invoice issuer, an invoice item group, and a bill number, and issues a bill by billing number.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 from October 1, 2023. For example, in the rental housing management industry, management companies (trustees) are entrusted by owners (clients) to provide housing to contractors, so the owner should normally issue a qualified invoice to the contractor. However, if both the management company and the owner are qualified invoice issuers, the intermediary issuance exception applies, allowing them to issue a qualified invoice containing the management company's registration number on behalf of the client. 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-mentioned Patent Document 1 does not mention anything about reducing the workload of staff by issuing invoices that meet the requirements of the invoice system according to the combination of the landlord's commission type and billing items.

[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 staff by issuing invoices that meet the requirements of the invoice system according to the combination of the landlord's commission type and billing items. [Means for solving the problem]

[0006] In order to solve the above problems and achieve the object, the present invention provides an invoice processing device equipped with a control unit, for a management company registered with a qualified invoice issuing business to issue an invoice for a landlord to a customer, the control unit storing a first master in which a landlord, a registration number, and a registration date are associated and registered; a second master in which a commission type, a billing item, and invoice subject categories including sales, deposit, and advance are associated and registered; management commission contract data including a management commission contract number, a landlord, a property, a commission type, and a remittance date; contract data including a contract number, a property, a room number, a contractor, a customer, and a contract date; and a contract number, an invoice date, a management contract data including a contract number, a property, a room number, a contractor, a customer, and a contract date. a billing calculation processing means configured to be able to access monthly contract rent data including billing items, main amount, and consumption tax amount, and contract customer data including a contract number, billing classification, and customer, and for a target year and month, creates collection schedule data including a collection schedule identifier for identifying each detail, billing number, billing year and month, sales posting date, billing items, main amount, consumption tax, property, room number, contract number, management contract number, commission type, customer business partner, and advance business partner based on the management contract data, the contract data, the monthly contract rent data, and the contract customer data; and an invoice output means for generating billing work data including a collection schedule identifier, billing item, billing year and month, customer code, sales posting date, management outsourcing contract number, outsourcing form, landlord registered business FLG indicating whether the landlord is a qualified invoice issuing business, invoice subject group, and invoice number based on the generated billing work data and the collection schedule data, and issuing invoices by billing number based on the generated billing work data and the collection schedule data. For the landlord registered business FLG of the billing work data, the management outsourcing contract number is used as a key to obtain the landlord of the management outsourcing contract data, and the acquired landlord is used as a key to obtain a registration date from the first master. If the acquired registration date is less than or equal to the sales posting date of the collection schedule data, the invoice output means determines that the landlord is a qualified invoice issuing business and sets the landlord registered business FLG to "landlord is a qualified invoice issuing business", otherwise sets the landlord registered business FLG to "landlord is not a qualified invoice issuing business", and for the invoice subject group of the billing work data, the invoice subject classification is obtained from the second master using the incoming billing item and outsourcing form of the collection schedule data as keys, and if the landlord is a qualified invoice issuing business,If the acquired invoice subject category is sales, purchases or deposits, a group of sales, purchases and deposits is set, and if the landlord is not a qualified invoice issuing business, the invoice subject category is set as is, and the invoice output means issues the invoice together and prints the management company's registration number when the invoice subject category is sales and deposits if the landlord is a qualified invoice issuing business and the intermediary issuance special exemption applies, and issues an invoice for each invoice subject category when the landlord is not a qualified invoice issuing business and the intermediary issuance special exemption applies.

[0007] In addition, according to one embodiment of the present invention, the control unit is configured to be able to access a third master in which management companies are registered in association with registration numbers, and the invoice output means may obtain the registration number of the management company from the third master.

[0008] According to another aspect of the present invention, the entrustment form may include a loan guarantee or a collection property.

[0009] According to another aspect of the present invention, the billing items may include rent, common area charges, or parking fees.

[0010] In order to solve the above-mentioned problems and achieve the object, the present invention provides an invoice processing method executed by an information processing device having a control unit, the control unit storing a first master in which a landlord, a registration number, and a registration date are associated and registered; a second master in which an invoice subject classification including an entrustment type, a billing item, sales, deposit, and advance is associated and registered; management entrustment contract data including a management entrustment contract number, a landlord, a property, an entrustment type, and a remittance date; contract data including a contract number, a property, a room number, a contractor, a customer, and a contract date; and contract rent monthly data including a contract number, a billing item, a main amount, and a consumption tax amount. and a contract customer data including a contract number, a billing classification, and a customer, and a billing calculation processing step executed by the control unit is to create, for a target year and month, collection schedule data including a collection schedule identifier for identifying each detail, a billing number, a billing year and month, a sales posting date, a billing item, a main amount, consumption tax, a property, a room number, a contract number, a management contract number, a consignment form, a customer business partner, and an advance payment business partner, based on the collection schedule data. and an invoice output process for creating billing work data including a collection schedule identifier, billing item, billing year and month, customer code, sales posting date, management outsourcing contract number, outsourcing form, landlord registered business FLG indicating whether the landlord is a qualified invoice issuing business, invoice subject group, and invoice number, and issuing invoices by billing number based on the created billing work data and the collection schedule data. In the invoice output process, for the landlord registered business FLG of the billing work data, the management outsourcing contract number is used as a key to obtain the landlord of the management outsourcing contract data, and the registration date is obtained from the first master using the obtained landlord as a key. If the obtained registration date is less than or equal to the sales posting date of the collection schedule data, the landlord is determined to be a qualified invoice issuing business, and the landlord registered business FLG is set to "landlord is a qualified invoice issuing business", otherwise the landlord registered business FLG is set to "landlord is not a qualified invoice issuing business", and for the invoice subject group of the billing work data, the invoice subject category is obtained from the second master using the incoming billing item and outsourcing form of the collection schedule data as keys, and if the landlord is a qualified invoice issuing business,If the acquired invoice subject category is sales, purchases or deposits, a group of sales, purchases and deposits is set, and if the landlord is not a qualified invoice issuer, the invoice subject category is set as is. Regarding the invoice, if the landlord is a qualified invoice issuer and the intermediary issuance special exemption applies, if the invoice subject category is sales and deposits, an invoice is issued together and the management company's registration number is printed on it, and if the landlord is not a qualified invoice issuer and the intermediary issuance special exemption does not apply, an invoice is issued for each invoice subject category.

[0011] In order to solve the above-mentioned problems and achieve the object, the present invention provides an invoice processing program to be executed by an information processing device having a control unit, the control unit creating a first master in which a landlord, a registration number, and a registration date are associated and registered, a second master in which a consignment type, a billing item, and an invoice subject classification including sales, deposit, and advance are associated and registered, management consignment contract data including a management consignment contract number, a landlord, a property, a consignment type, and a remittance date, contract data including a contract number, a property, a room number, a contractor, a customer, and a contract date, and contract rent monthly amount including a contract number, a billing item, a base amount, and a consumption tax amount. and contract customer data including a contract number, a billing classification, and a customer, and the control unit is configured to be able to access the management outsourcing contract data, the contract data, the contract rent monthly data, and the contract customer data for a target year and month, and a billing calculation processing step of creating collection schedule data including a collection schedule identifier for identifying each detail, a billing number, a billing year and month, a sales posting date, a billing item, a base amount, consumption tax, a property, a room number, a contract number, a management outsourcing contract number, an outsourcing form, a customer business partner, and an advance business partner, based on the collection schedule data; and an invoice output process for creating invoice work data including invoice items, invoice year and month, customer code, sales posting date, management outsourcing contract number, outsourcing form, landlord registered business FLG indicating whether the landlord is a qualified invoice issuing business, invoice subject group, and invoice number, and issuing invoices by invoice number based on the created invoice work data and the collection schedule data. In the invoice output process, for the landlord registered business FLG of the invoice work data, the management outsourcing contract number is used as a key to obtain the landlord of the management outsourcing contract data, and the registration date of the first master is used as a key to obtain the obtained landlord. If the registration date obtained is less than or equal to the sales posting date of the collection schedule data, the landlord is determined to be a qualified invoice issuing business, and the landlord registered business FLG is set to "landlord is a qualified invoice issuing business", otherwise the landlord registered business FLG is set to "landlord is not a qualified invoice issuing business", and for the invoice subject group of the invoice work data, the invoice subject classification is obtained from the second master using the incoming invoice items and outsourcing form of the collection schedule data as keys, and if the landlord is a qualified invoice issuing business,If the acquired invoice subject category is sales, purchases or deposits, a group of sales, purchases and deposits is set, and if the landlord is not a qualified invoice issuer, the invoice subject category is set as is. Regarding the invoice, if the landlord is a qualified invoice issuer and the intermediary issuance special exemption applies, if the invoice subject category is sales and deposits, an invoice is issued together and the management company's registration number is printed on it, and if the landlord is not a qualified invoice issuer and the intermediary issuance special exemption does not apply, an invoice is issued for each invoice subject category. Effect of the Invention

[0012] According to the present invention, by issuing invoices that meet the requirements of the invoice system according to the combination of the landlord's commission type and billing items, it is possible to reduce the workload of the person in charge. [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 item 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 showing an example of the configuration of the journal entry pattern master. [Figure 6] FIG. 6 illustrates an example of the configuration of the control master. [Figure 7] FIG. 7 is a diagram illustrating an example of the configuration of the client landlord master. [Figure 8] FIG. 8 is a diagram showing an example of the configuration of management contract data. [Figure 9] FIG. 9 is a diagram illustrating an example of the structure of the contract data. [Figure 10] FIG. 10 is a diagram showing an example of the configuration of monthly contract rent data. [Figure 11]FIG. 11 is a diagram showing an example of the structure of contract customer data. [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. [Diagram 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. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0014] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An invoice processing device, an invoice issuing method, and an invoice issuing 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 present embodiment.

[0015] [1. Overview] The invoice system will be introduced from October 1, 2023. For example, in the rental housing management industry, management companies (trustees) are entrusted by owners (clients) to provide housing to contractors, so the owner should normally issue a qualified invoice to the contractor. However, if both the management company and the owner are qualified invoice issuers, the special provisions for intermediary issuance will apply, allowing them to issue a qualified invoice containing the management company's registration number on behalf of the client.

[0016] If the owner is not a qualified invoice issuing business, the management company's sales and the owner's deposit must be invoiced separately. In the rental housing management industry, the characteristics of the billing items change depending on the type of management outsourcing contract between the management company and the owner, making it complicated to manage what accounts are included in the deposit and withdrawal management items.

[0017] For example, even for the same billing item, "rent," the characteristics (cash and deposit management items) change depending on the form of consignment with the owner, and may be sales from the management company or a deposit from the owner. Also, even for the same property, the form of consignment may change when the owner changes. It is necessary to determine whether the special exemption for intermediary is applicable based on the combination of "owner, consignment form, and billing item characteristics," which creates an issue of a heavy workload for the person in charge.

[0018] Therefore, in this embodiment, the workload of the person in charge is reduced by issuing invoices that meet the requirements of the invoice system according to the combination of the landlord's entrustment type and billing items.

[0019] Specifically, the invoice processing device of this embodiment controls the issued qualified invoices according to the consignment type and the billing item classification. Also, since accounting entries for rental housing management are similar to the requirements for invoices, as the account items change depending on the combination of consignment type and billing item, the master that controls the accounting entries has an invoice classification. Each combination of consignment type and billing item has a classification of "sales," "deposit," or "advance" (cash and withdrawal management item), and whether the intermediary issuance special exemption is applicable is determined depending on whether the owner is a qualified invoice issuing business. If applicable, the "sales" and "deposit" items are issued as a single invoice, and if not, it is now possible to issue the "sales" and "deposit" items as separate invoices. This function can be used even if the owner changes and the consignment type changes.

[0020] The information processing device of this embodiment is widely applicable in industries such as the rental management industry.

[0021] [2. Configuration] An example of the configuration of the bill creation 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.

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

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

[0024] 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).

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

[0026] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, optical disks, etc. can be used as the storage unit 106.

[0027] The storage unit 106 stores, for example, an item master 106a, a property master 106b, a room master 106c, an accounting pattern master (second master) 106d, a control master 106e, a client landlord master (first master) 106f, a work table 106g, management contract data, management contract room data, contract data, monthly contract rent data, contract customer data, collection schedule data, invoice number history data, and the like. FIG. 2 is a diagram showing an example of the configuration of the item 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 accounting pattern master 106d. FIG. 6 is a diagram showing an example of the configuration of the control master 106e. FIG. 7 is a diagram showing an example of the configuration of the client landlord master 106f. FIG. 8 is a diagram showing an example of the configuration of the management contract data. FIG. 9 is a diagram showing an example of the configuration of the contract data. FIG. 10 is a diagram showing an example of the monthly contract rent data. FIG. 11 is a diagram showing an example of the structure of contract customer data.

[0028] The item master 106a can be configured as a table in which the item code of the billing item, its item name, and rent category are registered in association with each other, as shown in Fig. 2. In the example shown in the figure, the first line has the item code "1010", the item name "Rent", and the rent category "51: Rent".

[0029] The property master 106b 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. In the example shown in the figure, the first line is "XX property", property code "A0000000001", and property name "XX property".

[0030] The room master 106c can be configured as a table in which property codes, room numbers, and deposit account codes are registered in association with each other, as shown in Fig. 4. In the example shown in the figure, the first line contains the property code "A0000000001", the room number "101", and the deposit account code "10".

[0031] As shown in Fig. 5, the journal entry pattern master 106d can be configured as a table in which the consignment type code, the item code of the billing item, the income general account item, the payment general account item, and the invoice item category (input / output management item) are registered in association with each other. In the example shown in the figure, the first line is the consignment type code "1", the item code "1010", the income general account item "5400: rental income", the payment general account item "7503: rent paid", and the invoice item category "1: sales and purchases". The second line is the consignment type code "1", the item code "1210", the income general account item "3551: rent received", the payment general account item " ", and the invoice item category "2: deposit". The sixth line is the consignment type code "4", the item code "2002", the income general account item "1200: accounts receivable", the payment general account item " ", and the invoice item category "3: advance payment".

[0032] The control master 106e can be configured with a table or the like in which the company name, registration number, and invoice start category of the management company are associated and registered, as shown in Fig. 6. In the example shown in the figure, the first line has the company name "□□ Company", the registration number "T123400000000", and the invoice start category "Yes".

[0033] The business partner landlord master 106f can be configured as a table in which business partner (landlord) codes, business partner names, registration numbers, and registration dates are associated and registered, as shown in Fig. 7. In the example shown in the figure, the first line is business partner code "0000000001", business partner name "○○○○", registration number "T0000000000001", and registration date "2023 / 10 / 1", and the second line is business partner code "0000000002" and business partner name "△△△△".

[0034] The work table 106g is used as a work area for generating work data (intermediate data), and for example, billing work data (also called "billing work") is generated by the bill output processing unit 102d.

[0035] The management contract data may include a management contract number, a landlord code, a property code, a contract type code, and a remittance date, as shown in Fig. 8. In the example shown in the figure, the first line has a management contract number "00000001234", a landlord code "0000000001", a property code "A0000000001", a contract type code "1: Lease guarantee", and a remittance date "10", and the second line has a management contract number "00000001255", a landlord code "0000000002", a property code "B0000000001", a contract type code "4: Collection property", and a remittance date "15".

[0036] The management contract room-specific data may include the management contract number, property code, room number, contract type code, validity period start, and validity period end (see FIG. 21).

[0037] The contract data may include a contract number, a property code, a room number, a contractor, a resident, and a contract date, as shown in Fig. 9. In the example shown in the figure, the first line is a contract number "100000000001", a property code "A0000000001", a room number "101", a contractor "001: Yamada Taro", a resident "001: Yamada Taro", and a contract date "2023 / 1 / 5", and the second line is a contract number "200000000001", a property code "B0000000001", a room number "201", a contractor "002: Sato Hanako", a resident "002: Sato Hanako", and a contract date "2023 / 2 / 15".

[0038] The monthly contract rent data may include the contract number, the item code of the invoice, the amount of the invoice, and the consumption tax amount, as shown in Figure 10. In the example shown in the figure, the first line contains the contract number "100000000001", the item code "1010", the amount of the invoice "10000", and the consumption tax amount "1000".

[0039] The contract customer data may include the contract number, billing category, customer code, payment method code, and document delivery destination code, as shown in Figure 11. In the example shown in the figure, the first line has the contract number "100000000001", billing category "0: Contractor", customer code "001: Yamada Taro", payment method code "0: Bank transfer", and document delivery destination code "0".

[0040] The collection schedule data may include a collection schedule Guid (collection schedule identifier) ​​that identifies each item, invoice number, billing year and month, sales recording date, invoice item code, base amount, consumption tax, property code, room number, contract number, management outsourcing contract number, outsourcing type code, customer code, billing customer category, and advance payment customer code (see Figure 14).

[0041] 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, "property" means property code and / or property name).

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

[0043] The control unit 102 is configured to be able to access the item master 106a, property master 106b, room master 106c, accounting pattern master 106d, control master 106e, client landlord master 106f, management contract data, management contract data by room, contract data, contract rent monthly data, contract customer data, collection schedule data, invoice number history data, etc. stored in the memory unit 106. Note that the item master 106a, property master 106b, room master 106c, accounting pattern master 106d, control master 106e, client landlord master 106f, management contract data, management contract data by room, contract data, contract customer data, contract rent monthly data, collection schedule data, invoice number history data, etc. may be provided in another location (for example, server 200) as long as the control unit 102 is able to access them.

[0044] The control unit 102 conceptually comprises, functionally, a master maintenance unit 102a, a data registration / change unit 102b, a billing calculation processing unit 102c, a bill output processing unit 102d, and a screen display control unit 102e.

[0045] The master maintenance unit 102a performs editing such as registering, updating, adding, and deleting data in the item master 106a, the property master 106b, the room master 106c, the accounting pattern master 106d, the control master 106e, and the client landlord master 106f, in response to, for example, an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.

[0046] The data registration / change unit 102b inputs management contract data, management contract data by room, contract data, monthly contract rent data, and contract customer data in response to, for example, an operator's operation on an input screen displayed on the monitor 114, and registers the data in the memory unit 106, or changes the management contract data, management contract data by room, contract data, and monthly contract rent data registered in the memory unit 106.

[0047] The billing calculation processing unit 102c creates collection schedule data including a collection schedule identifier for identifying each detail, billing number, billing year and month, sales posting date, billing item, main amount, consumption tax, property, room number, contract number, management contract number, commission type, customer (business partner), and advance payment business partner, based on the management contract data, contract data, monthly contract rent data, and contract customer data for the target year and month and property specified by the operator on the billing calculation screen displayed on the monitor 114, and registers the data in the memory unit 106.

[0048] The entrustment form may include a rental guarantee or a collection property. The billing items may include rent, common area charges, or parking fees.

[0049] The invoice output processing unit 102d generates billing work data in the work table 106g based on the collection schedule data, including a collection schedule identifier, management item, billing year and month, customer code, sales recording date, management outsourcing contract number, outsourcing form, landlord registered business FLG indicating whether the landlord is a qualified invoice issuing business, invoice subject group, and invoice number, and issues invoices by invoice number based on the generated billing work data and the collection schedule data.

[0050] The invoice output processing unit 102d, for the landlord registered business FLG of the billing work data, acquires the landlord of the management contract data using the management contract number as a key, acquires the registration date of the client landlord master (first master) 106f using the acquired landlord as a key, and if the acquired landlord's registration date is equal to or less than the sales posting date of the collection schedule data, determines that the landlord is a qualified invoice issuer and sets the landlord registered business FLG to "landlord is a qualified invoice issuer", otherwise sets the landlord registered business FLG to "landlord is not a qualified invoice issuer", and for the invoice item group of the billing work data, Using the form of consignment as a key, the invoice subject category is obtained from the accounting pattern master (second master) 106d, and if the landlord is a qualified invoice issuer, a group of sales, purchases, and deposits is set for sales, purchases, and deposits, and if the landlord is not a qualified invoice issuer, the invoice subject category is set as is, and with regard to the invoice, if the landlord is a qualified invoice issuer and the intermediary issuance special exemption applies, if the invoice subject category is sales and deposits, an invoice is issued together and the management company's registration number is printed on it, and if the landlord is not a qualified invoice issuer and the intermediary issuance special exemption applies, an invoice is issued for each invoice subject category.

[0051] The invoice output processing unit 102d may obtain the registration number of the management company from the control master 106e (third master).

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

[0053] [3. Specific Examples] Specific examples of the processing performed by the control unit 102 of the invoice processing device 100 in this embodiment will be described with reference to Figures 1 to 23. Figures 12 to 23 are diagrams for explaining specific examples of the processing performed by the control unit 102 of the invoice processing device 100 in this embodiment.

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

[0055] 12, the master maintenance unit 102a executes a master maintenance process (step S1). Specifically, in the master maintenance process, the master maintenance unit 102a sets data of the journalization pattern master 106d in response to, for example, an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.

[0056] The billing calculation processing unit 102c executes the billing calculation process (step S2). In the billing calculation process, the billing calculation processing unit 102c creates collection schedule data including a collection schedule identifier for identifying each detail, billing number, billing year and month, sales posting date, billing item, main amount, consumption tax, property, room number, contract number, management contract number, consignment form, customer business partner, and advance payment business partner, based on the management contract data, contract data, contract rent monthly data, and contract customer data stored in the storage unit 106 for the target year and month and property specified by the operator's operation on the billing calculation screen displayed on the monitor 114, and registers the data in the storage unit 106. The consignment form may include a rental guarantee or a property for which money is collected. The billing items may include rent, common area charges, or parking fees.

[0057] The invoice output processing unit 102d executes the invoice output process (step S3). Specifically, the invoice output processing unit 102d generates invoice work data including a collection schedule identifier, billing item, billing year and month, customer code, sales posting date, management outsourcing contract number, outsourcing form, landlord registered business FLG indicating whether the landlord is a qualified invoice issuing business, invoice subject group, and invoice number based on the collection schedule data in the work table 106g, and issues invoices by billing number based on the generated invoice work data and the collection schedule data.

[0058] In addition, for the landlord registered business FLG of the billing work data, the invoice output processing unit 102d acquires the landlord of the management contract data using the management contract number as a key, acquires the registration date of the client landlord master (first master) 106f using the acquired landlord as a key, and if the registration date of the acquired landlord is equal to or less than the sales posting date of the collection schedule data, determines that the landlord is a qualified invoice issuer and sets the landlord registered business FLG to "landlord is a qualified invoice issuer", otherwise sets the landlord registered business FLG to "landlord is not a qualified invoice issuer", and for the invoice subject group of the billing work data, acquires the invoice of the collection schedule data. Using the item and the consignment type as a key, the invoice subject category is obtained from the accounting pattern master (second master) 106d, and if the landlord is a qualified invoice issuing business, the sales, purchases, or deposits are set as a group of sales, purchases, and deposits, and if the landlord is not a qualified invoice issuing business, the invoice subject category is set as is, and for the invoice, if the landlord is a qualified invoice issuing business and the intermediary issuance special provision applies, if the invoice subject category is sales and deposits, the invoice is issued together and the management company's registration number is printed, and if the landlord is not a qualified invoice issuing business and the intermediary issuance special provision does not apply, the invoice is issued for each invoice subject category. The invoice output processing unit 102d may obtain the management company's registration number from the control master 106e (third master).

[0059] [3-2. Sample data] 13 to 23 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 23. In the following, an example will be described in which the examples of the master and data configurations shown in the above-mentioned Figs. 2 to 11 are used.

[0060] (S2: Billing calculation processing) A specific example of the billing calculation process will be described with reference to Figs. 13 and 14. The billing calculation processing unit 102c creates collection schedule data including a collection schedule identifier for identifying each detail, a billing number, a billing year and month, a sales posting date, billing items, a main amount, a consumption tax, an item, a room number, a contract number, a management contract number, a form of consignment, a business partner who is a customer, and a business partner who pays on behalf of another business partner, based on the management contract data, contract data, contract rent monthly data, and contract customer data stored in the storage unit 106 for a target year and month and property specified by an operator's operation on a billing calculation screen displayed on the monitor 114, and registers the data in the storage unit 106. The form of consignment may include a rental guarantee or a property for which money is collected. The billing items may include rent, common area charges, or parking fees.

[0061] In the billing calculation process, monthly (each month) collection schedule data is created based on the contract information (management contract data, contract data, monthly contract rent data, contract customer data, etc. in FIGS. 8 to 11).

[0062] 13 is a diagram showing a display example of a billing calculation processing screen 400. The billing calculation processing screen 400 is provided with fields for specifying the billing year and month and property extraction conditions, and an execute button (not shown). When the operator specifies the billing year and month and property extraction conditions and presses the execute button (not shown), the billing calculation processing unit 102c creates collection schedule data in accordance with the specified extraction conditions, referring to the contract information (management contract data, contract data, monthly contract rent data, and contract customer data).

[0063] In the example shown in the figure, when the billing date "2023 / 10" and property "A0000000001-B0000000001" are specified, collection schedule data such as that shown in FIG. 14 is created.

[0064] Fig. 14 is a diagram showing an example of collection schedule data. As shown in Fig. 14, the collection schedule data includes the following items: collection schedule Guid (collection schedule identifier) ​​for identifying each item, billing number, billing year and month, sales posting date, item code of management item, base amount, consumption tax, property code, room number, contract number, management outsourcing contract number, outsourcing form code, landlord's business partner code, billing business partner category, and advance payment business partner code. For example, the advance payment business partner code can be set in a separate process after the billing calculation.

[0065] In the example shown in the figure, the first line contains the collection schedule Guid "1", invoice number "SE0001", invoice year and month "2023 / 10", sales posting date "2023 / 10 / 30", item code "1010", base amount "10000", consumption tax "1000", property code "A0000000001", room number "101", contract number "100000000001", management contract number "00000001234", outsourcing type code "1: Lease guarantee", landlord customer code "001: Yamada Taro", and invoice customer category "0: Contractor".

[0066] (S3: Invoice output processing) A specific example of the invoice output process will be described with reference to Figures 15 to 20. The invoice output processing unit 102d uses the work table 106g to generate invoice work data based on the collection schedule data, including a collection schedule identifier, invoice item, invoice date, customer code, sales posting date, management outsourcing contract number, outsourcing form, landlord registered business FLG indicating whether the landlord is a qualified invoice issuing business, invoice item group, and invoice number, and issues invoices by invoice number based on the generated invoice work data and the collection schedule data.

[0067] The invoice output processing unit 102d, for the landlord registered business FLG of the billing work data, acquires the landlord of the management contract data using the management contract number as a key, acquires the registration date of the client landlord master (first master) 106f using the acquired landlord as a key, and if the acquired landlord's registration date is equal to or less than the sales posting date of the collection schedule data, determines that the landlord is a qualified invoice issuer and sets the landlord registered business FLG to "landlord is a qualified invoice issuer", otherwise sets the landlord registered business FLG to "landlord is not a qualified invoice issuer", and for the invoice item group of the billing work data, Using the form of consignment as a key, the invoice subject category is obtained from the accounting pattern master (second master) 106d, and if the landlord is a qualified invoice issuing business, the sales, purchases, or deposits are set as a group of sales, purchases, and deposits, and if the landlord is not a qualified invoice issuing business, the invoice subject category is set as is, and for the invoice, if the landlord is a qualified invoice issuing business and the intermediary issuance special treatment is applied, if the invoice subject category is sales and deposits, the invoice is issued together and the management company registration number is printed, and if the landlord is not a qualified invoice issuing business and the intermediary issuance special treatment is not applied, the invoice is issued for each invoice subject category. The invoice output processing unit 102d may obtain the management company registration number from the control master 106e (third master).

[0068] In the invoice output process, it is possible to determine whether the intermediary delivery special provisions apply and to issue an appropriate invoice by referring to the invoice subject classification in the accounting pattern master 106d.

[0069] Process 1: For each item of data to be collected, determine whether it is an intermediary delivery exception and the invoice subject classification. Expand the invoice work data linked to the target data to be collected in the work table 106g and manage the status.

[0070] 15 is a diagram showing an example of invoice work data. The invoice work data includes the following items: collection schedule Guid (collection schedule identifier), invoice item code, billing month and year, customer business partner code, sales posting date, management outsourcing contract number, outsourcing form code, landlord registration business FLG, invoice subject group, deposit account code, document delivery destination code, deposit method code, bill occurrence category, advance payment business partner code, and invoice number.

[0071] In the example shown in the figure, the first line contains the collection schedule Guid "1", item code "1010", billing year and month "2023 / 10", customer code "001: Yamada Taro", sales posting date "2023 / 10 / 30", management contract number "00000001234", outsourcing type code "1: Lease guarantee", landlord registered business FLG "1: Landlord is a qualified invoice issuer", invoice subject group "1 (sales, purchases, deposits)", deposit account code "10", document delivery destination code "0", deposit method code "0: Bank transfer", billing occurrence category "2: Monthly", advance payment customer code " ", and invoice number " ".

[0072] The "Landlord Registered Business Establishment FLG" and "Invoice Subject Group" in the billing work data shall be updated simultaneously using the logic (1) and (2) below.

[0073] (1) Determine whether or not the special exemption for intermediaries applies based on each collection schedule data. Figure 16 is a diagram for explaining how to determine whether an owner is an eligible invoice issuing business, where Figure 16(A) shows the main parts of the collection schedule data, (B) shows the main parts of the management contract data, and Figure 16(C) shows the main parts of the client landlord master 106f.

[0074] Using the management contract number of the scheduled collection data as a key (see Figure 16(A)), the landlord code of the management contract data is obtained (see Figure 16(B)). Using the obtained landlord code as a key, the registration date of the landlord's registration number in the client landlord master 106f is obtained. If the registration date is less than or equal to the sales posting date of the scheduled collection data, the landlord is determined to be a qualified invoice issuing business (see Figure 16(C)). Furthermore, if the invoice start classification of the management company is "yes" in the control master (third master) 106e, the management company is also a qualified invoice issuing business, so the management company and the owner are determined to be qualified invoice issuing businesses and the intermediary issuance special provisions are applied.

[0075] As a result of the above, the special exemption for intermediary issuance applies to Guids 1, 2, and 3 to be collected, and the special exemption for intermediary issuance does not apply to Guids 4, 5, 6, and 7 to be collected (see Figure 17 (A)). In the invoice work data, the Landlord Registered Business FLG column, which is the landlord registration flag indicating whether the landlord is a qualified invoice issuing business, is updated. Specifically, if the landlord is a qualified invoice issuing business, it is updated to "1: Landlord is a qualified invoice registering business", and if the landlord is not a qualified invoice issuing business, it is updated to "0: Landlord is not a qualified invoice registering business".

[0076] By knowing whether the owner is a qualified invoice issuer or not, if the owner is a qualified invoice issuer, it becomes possible to decide whether to issue invoices separately for the invoice subject categories [1: Sales / Purchases, 2: Deposits] and [3: Advance], and if the owner is not a qualified invoice issuer, it becomes possible to decide whether to issue invoices separately for the invoice subject categories [1: Sales / Purchases], [2: Deposits], and [3: Advance].

[0077] (2) Determine the invoice category for each piece of data to be collected. If the special exemption for intermediary delivery applies, the owner's deposit can be issued under the management company's registration number. Figure 17 is a diagram for explaining how to determine the "invoice subject group" of the billing work, with Figure 17(A) showing the main part of the collection schedule data and Figure 17(B) showing the main part of the accounting pattern master 106d.

[0078] Using the item code and consignment type code of the collection schedule data as keys (see FIG. 17(A)), the invoice subject classification is obtained from the accounting pattern master 106d (see FIG. 17(B)), and the "invoice subject group" of the invoice work data is set.

[0079] For details of qualified invoice issuers, if the invoice subject classification is "1: Sales / Purchases" or "2: Deposits", set the invoice subject group to "1 (Sales, Purchases, Deposits)", and if the invoice subject classification is "3: Advance", set the invoice subject group to "3: Advance".

[0080] For details of items that are not qualified invoice issuers, set the invoice subject category as is in the invoice subject group (see Figure 17 (B)). The invoice subject group is used as the unit of invoice issuance.

[0081] Process 2: Issue an invoice. Figures 18 and 19 are diagrams for explaining the issuance of an invoice. When the intermediary issuance special provision is applied, invoice subject categories 1 (sales / purchase) and 2 (deposit) are printed together on the invoice, and when the intermediary issuance special provision is not applied, an invoice is issued for each invoice subject category. In this way, by registering the invoice subject category in the accounting pattern master 106d, appropriate invoices can be issued.

[0082] Invoice units (invoice numbers) are grouped by billing year and month, customer code, account code, document delivery destination code, payment due date, payment method code, landlord registration business flag, billing occurrence category, invoice subject category, advance payment customer business flag, advance payment customer code, property code, room number, management contract number, remittance date, and entrustment type code.

[0083] Invoice numbers are assigned in the invoice work data, and invoices are issued on an invoice number basis based on the invoice work and scheduled collection data. Figure 18 shows invoice work data with assigned invoice numbers. Figure 19 shows an example of invoice number history data created when assigning invoice numbers. As shown in Figure 19, the invoice number history data may include the invoice number, scheduled collection Guid, and issue date. In the example shown in the figure, the first line has the invoice number "0001", the scheduled collection Guid "1", and the issue date "2023 / 10 / 20".

[0084] In the case of the invoice number "0001", the owner is a qualified invoice issuer, so the intermediary issuance special exemption applies. The deposit and withdrawal management items for the invoice subject categories "Sales" and "Deposits" are printed on the same invoice, and the management company's registration number is printed.

[0085] In the case of invoice number "0002," the owner is a qualified invoice issuing business, so the special exemption for intermediary delivery applies. The special exemption for intermediary delivery applies, but since the invoice subject classification is "advance payment," an invoice different from the invoice number "0001" is issued.

[0086] In the case of the invoice number "0003", the owner is not a qualified invoice issuer, so the special exemption for intermediary is not applied. An invoice with only the deposit and withdrawal management item in the invoice subject category "Deposit" is printed, and the management company's registration number is not printed.

[0087] In the case of the invoice number "0004", the owner is not a qualified invoice issuer, so the special exemption for intermediary is not applied. An invoice with only the cash flow management item in the invoice subject category "Sales" is printed, and the management company's registration number is printed.

[0088] In the case of the invoice number "0005", the owner is not a qualified invoice issuer, so the special exemption for intermediary issuance does not apply. An invoice for the deposit and withdrawal management item with the invoice subject classification of "advance payment" is printed, and the registration number of the advance payment recipient is printed.

[0089] (Invoice output when changing management contract) With reference to Fig. 20 to Fig. 23, the output of an invoice when the management contract is changed will be described. Here, the explanation will be given using data different from that described above, and it is assumed that the data in Fig. 20 has already been prepared. The data registration / change unit 102b changes data such as the management contract data.

[0090] Figure 20(A) shows an example of management contract data, Figure 20(B) shows an example of management contract room-specific data, Figure 20(C) shows an example of monthly contract rent data, and Figure 20(D) shows an example of collection schedule data created based on this data by executing a billing calculation process (billing year and month: October 2023) S2 similar to that described above.

[0091] It is assumed that the management contract has been changed as shown in Figure 21. Figure 21(A) shows an example of the management contract data after the change, and Figure 21(B) shows an example of the management contract room-specific data after the change.

[0092] Create scheduled collection data based on the data after the change in the invoice calculation process. In this example, scheduled collection data for billing year and month: November 2023 is created. Figure 22 shows an example of the created scheduled collection data. As shown in Figure 22, data for scheduled collection Guid: 9, 10 has been created (updated).

[0093] Using the calculated number of months from the start of the relevant month and year of the monthly contract rent data and the billing calculation process for November, create planned collection data for the billing month and year November and the relevant month December (billing month and year + calculated number of months for the relevant month).The management contract number is obtained with the start of the relevant month as the base date, so reference the management contract data using the property, room, and relevant month as keys, obtain the management contract number "00000002222" of the planned collection data for November, and set the obtained management contract number in the planned collection data.

[0094] An invoice is issued by referring to the journal entry pattern master 106d shown in Fig. 23. By registering the invoice subject classification in the journal entry pattern master 106d, it is possible to issue an appropriate invoice (the invoice issuance logic is the same as that of the "invoice output process S3").

[0095] As described above, according to this embodiment, the system is configured to be able to access the client landlord master 106f in which landlords, registration numbers, and registration dates are associated and registered; the accounting pattern master 106d in which the entrustment type, billing items, invoice subject categories including sales, deposits, and advances are associated and registered; management entrustment contract data including the management entrustment contract number, landlord, property, entrustment type, and remittance date; contract data including the contract number, property, room number, contractor, customer, and contract date; monthly contract rent data including the contract number, billing items, main amount, and consumption tax amount; and contract customer data including the contract number, billing category, and customer. A billing calculation processing unit 102c creates collection schedule data including a collection schedule identifier, billing number, billing year and month, sales posting date, billing item, main amount, consumption tax, property, room number, contract number, management outsourcing contract number, outsourcing form, customer business partner, and advance business partner for identifying each detail based on the management outsourcing contract data, the contract data, the contract monthly rent data, and the contract customer data for the target year and month; and a billing calculation processing unit 102c creates collection schedule data including a collection schedule identifier, billing item, billing year and month, business partner code, sales posting date, management outsourcing contract number, outsourcing form, and landlord's qualified invoice issuance date based on the collection schedule data. and an invoice output processing unit 102d which creates billing work data including a landlord registered business FLG indicating whether the landlord is a landlord, an invoice subject group, and an invoice number, and issues an invoice for each invoice number based on the created billing work data and the collection schedule data. For the landlord registered business FLG of the billing work data, the invoice output processing unit 102d acquires the landlord of the management contract data using the management contract number as a key, acquires the registration date of the client landlord master 106f using the acquired landlord as a key, and issues an invoice if the acquired registration date is less than or equal to the sales posting date of the collection schedule data. If so, the landlord is determined to be a qualified invoice issuer and the landlord registered business FLG is set to "landlord is a qualified invoice issuer", otherwise the landlord registered business FLG is set to "landlord is not a qualified invoice issuer", and for the invoice subject group of the billing work data, the invoice subject category is obtained from the accounting pattern master 106d using the invoice item and the consignment type of the collection schedule data as keys, and if the landlord is a qualified invoice issuer, if the obtained invoice subject category is sales, purchases, or deposits, the groups of sales, purchases, and deposits are set,If the landlord is not a qualified invoice issuing business, the invoice subject category is set as is, and for the invoice, if the landlord is a qualified invoice issuing business and the intermediary issuance special exemption applies, if the invoice subject category is sales and deposits, the invoice is issued together and the management company's registration number is printed on it, and if the landlord is not a qualified invoice issuing business and the intermediary issuance special exemption does not apply, invoices are issued for each invoice subject category, so by issuing invoices that meet the requirements of the invoice system according to the combination of the landlord's commission type and billing item, it is possible to reduce the workload of the person in charge.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[0110] 100 Invoice processing device 102 Control section 102a Master Maintenance Department 102b Data Registration and Update Section 102c Billing calculation processing unit 102d Invoice output processing unit 102e Screen display control unit 104 Communication interface section 106 Storage section 106a Item Master 106b Property Master 106c Room Master 106d Journal entry pattern master 106e Control Master 106f Client Landlord Master 106g Work Table 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. A billing device that includes a control unit and is used by a management company that is registered as a qualified billing issuer to issue a landlord's bill to a customer, The control unit is A first master in which a landlord, a registration number, and a registration date are associated and registered; A second master in which the consignment type is associated with the billing item, sales, deposit, and advance payment invoice subject classification, and is registered; Management contract data including management contract number, landlord, property, type of contract, and remittance date; Contract data including contract number, property, room number, contractor, customer, and contract date; Monthly contract rent data including contract number, billing item, unit price, and consumption tax amount, Contract customer data, including contract number, billing category, and customer; is configured to be accessible to a billing calculation processing means for creating, for a target year and month, collection schedule data including a collection schedule identifier for identifying each item, a billing number, a billing year and month, a sales posting date, a billing item, a base amount, consumption tax, a property, a room number, a contract number, a management contract number, a consignment form, a customer (business partner), and an advance payment business partner, based on the management contract data, the contract data, the monthly contract rent data, and the contract customer data; an invoice output means for generating invoice work data based on the collection schedule data, the invoice work data including a collection schedule identifier, invoice item, invoice date, customer code, sales posting date, management outsourcing contract number, outsourcing form, landlord registered business FLG indicating whether the landlord is a qualified invoice issuing business, invoice item group, and invoice number, and for issuing invoices by invoice number based on the generated invoice work data and the collection schedule data; Equipped with The bill output means includes: For the landlord registered business FLG of the billing work data, the management contract number is used as a key to obtain the landlord of the management contract data, and the registration date is obtained from the first master using the obtained landlord as a key. If the obtained registration date is equal to or less than the sales posting date of the scheduled collection data, the landlord is determined to be a qualified invoice issuing business, and the landlord registered business FLG is set to "landlord is a qualified invoice issuing business", otherwise the landlord registered business FLG is set to "landlord is not a qualified invoice issuing business", For the invoice subject group of the billing work data, the invoice subject category is obtained from the second master using the invoice item and the consignment form of the collection schedule data as a key, and if the landlord is a qualified invoice issuing business, if the obtained invoice subject category is sales, purchases, or deposits, the group of sales, purchases, and deposits is set, and if the landlord is not a qualified invoice issuing business, the invoice subject category is set as it is, With regard to the invoice, if the landlord is a qualified invoice issuing business and the intermediary issuance special exemption applies, then if the invoice subject categories are sales and deposits, a combined invoice is issued and the management company's registration number is printed on it, and if the landlord is not a qualified invoice issuing business and the intermediary issuance special exemption does not apply, then an invoice is issued for each invoice subject category.

2. The control unit is The third master is configured to be accessible to the third master in which the management company and the registration number are associated and registered, 2. The invoice processing device according to claim 1, wherein said invoice output means acquires a registration number of a management company from said third master.

3. 3. The invoice processing device according to claim 1, wherein the entrustment form includes a loan guarantee or a collection item.

4. 3. The invoice processing device according to claim 1, wherein the invoice items include rent, common area charges, or parking fees.

5. An invoice processing method executed by an information processing device having a control unit, The control unit is A first master in which a landlord, a registration number, and a registration date are associated and registered; A second master in which the consignment type is associated with the billing item, sales, deposit, and advance payment invoice subject classification, and is registered; Management contract data including management contract number, landlord, property, type of contract, and remittance date; Contract data including contract number, property, room number, contractor, customer, and contract date; Monthly contract rent data including contract number, billing item, unit price, and consumption tax amount, Contract customer data, including contract number, billing category, and customer; is configured to be accessible to Executed in the control unit, a billing calculation process for creating, for a target year and month, collection schedule data including a collection schedule identifier for identifying each item, billing number, billing year and month, sales posting date, billing item, main amount, consumption tax, property, room number, contract number, management contract number, consignment form, customer business partner, and advance payment business partner, based on the management consignment contract data, the contract data, the monthly contract rent data, and the contract customer data; an invoice output process for generating invoice work data based on the collection schedule data, the invoice work data including a collection schedule identifier, invoice item, invoice date, customer code, sales posting date, management outsourcing contract number, outsourcing form, landlord registered business FLG indicating whether the landlord is a qualified invoice issuing business, invoice item group, and invoice number, and issuing invoices by invoice number based on the generated invoice work data and the collection schedule data; Including, In the invoice output step, For the landlord registered business FLG of the billing work data, the management contract number is used as a key to obtain the landlord of the management contract data, and the registration date of the first master is obtained using the obtained landlord as a key. If the obtained registration date is equal to or less than the sales posting date of the scheduled collection data, the landlord is determined to be a qualified invoice issuing business, and the landlord registered business FLG is set to "landlord is a qualified invoice issuing business", otherwise the landlord registered business FLG is set to "landlord is not a qualified invoice issuing business", For the invoice subject group of the billing work data, the invoice subject category is obtained from the second master using the invoice item and the consignment form of the collection schedule data as a key, and if the landlord is a qualified invoice issuing business, if the obtained invoice subject category is sales, purchases, or deposits, the group of sales, purchases, and deposits is set, and if the landlord is not a qualified invoice issuing business, the invoice subject category is set as it is, With regard to the invoice, if the landlord is a qualified invoice issuing business and the intermediary issuance special exemption applies, when the invoice subject categories are sales and deposits, a combined invoice is issued and the management company's registration number is printed on it, and if the landlord is not a qualified invoice issuing business and the intermediary issuance special exemption does not apply, an invoice is issued for each invoice subject category, according to this invoice processing method.

6. An invoice processing program to be executed by an information processing device having a control unit, The control unit is The control unit is A first master in which a landlord, a registration number, and a registration date are associated and registered; A second master in which the consignment type is associated with the billing item, sales, deposit, and advance payment invoice subject classification, and is registered; Management contract data including management contract number, landlord, property, type of contract, and remittance date; Contract data including contract number, property, room number, contractor, customer, and contract date; Monthly contract rent data including contract number, billing item, unit price, and consumption tax amount, Contract customer data, including contract number, billing category, and customer; is configured to be accessible to In the control unit, a billing calculation process for creating, for a target year and month, collection schedule data including a collection schedule identifier for identifying each item, billing number, billing year and month, sales posting date, billing item, main amount, consumption tax, property, room number, contract number, management contract number, consignment form, customer business partner, and advance payment business partner, based on the management consignment contract data, the contract data, the monthly contract rent data, and the contract customer data; an invoice output process for generating invoice work data based on the collection schedule data, the invoice work data including a collection schedule identifier, invoice item, invoice date, customer code, sales posting date, management outsourcing contract number, outsourcing form, landlord registered business FLG indicating whether the landlord is a qualified invoice issuing business, invoice item group, and invoice number, and issuing invoices by invoice number based on the generated invoice work data and the collection schedule data; An invoice processing program for executing In the invoice output step, For the landlord registered business FLG of the billing work data, the management contract number is used as a key to obtain the landlord of the management contract data, and the registration date is obtained from the first master using the obtained landlord as a key. If the obtained registration date is equal to or less than the sales posting date of the scheduled collection data, the landlord is determined to be a qualified invoice issuing business, and the landlord registered business FLG is set to "landlord is a qualified invoice issuing business", otherwise the landlord registered business FLG is set to "landlord is not a qualified invoice issuing business", For the invoice subject group of the billing work data, the invoice subject category is obtained from the second master using the invoice item and the consignment form of the collection schedule data as a key, and if the landlord is a qualified invoice issuing business, if the obtained invoice subject category is sales, purchases, or deposits, the group of sales, purchases, and deposits is set, and if the landlord is not a qualified invoice issuing business, the invoice subject category is set as it is, With regard to the invoice, if the landlord is a qualified invoice issuing business and the intermediary issuance special exemption applies, when the invoice subject categories are sales and deposits, an invoice is issued together and the management company's registration number is printed on it, and if the landlord is not a qualified invoice issuing business and the intermediary issuance special exemption does not apply, an invoice is issued for each invoice subject category, characterized by the above-mentioned invoice processing program.

Images