Invoice processing device, invoice processing method, and invoice processing program
The invoice processing device addresses the challenge of complex invoicing in rental housing management by using a control unit to manage landlord registration and billing items, reducing staff workload through accurate invoicing based on entrustment type and billing items, and optionally including the management company's registration number.
Patent Information
- Application Number
- JP2023158398
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2023-09-22
- Publication Date
- 2025-08-20
- Estimated Expiration
- 2043-09-22
AI Technical Summary
Existing systems do not effectively reduce the workload of staff by issuing invoices that meet the requirements of the invoice system according to the combination of the landlord's entrustment type and billing items, particularly in rental housing management where the characteristics of billing items change based on the type of management contract and the owner's qualification as a qualified invoice issuer.
An invoice processing device and method that includes a control unit to manage and issue invoices based on a first master associating landlord registration details, a second master for entrustment type and billing items, and a billing calculation process to determine whether the landlord is a qualified issuer, allowing for combined or separate invoicing based on the entrustment type and billing items, and optionally including the management company's registration number.
This solution reduces the workload of staff by ensuring invoices are issued correctly according to the landlord's entrustment type and billing items, simplifying cash flow management in rental housing management by determining the need for combined or separate invoicing based on the owner's qualification and billing characteristics.
Smart Images

Figure 0007726961000001 
Figure 0007726961000002 
Figure 0007726961000003
Abstract
Description
[Technical Field]
[0001] The present invention relates to a bill processing device, a bill processing method, and a bill processing program. [Background technology]
[0002] The invoice system will be introduced from October 1, 2023. For example, in the rental housing management industry, management companies (trustees) are entrusted by owners (clients) to provide housing to contract holders, so the owners are normally required to issue qualified invoices to contract holders. However, if both the management company and the owner are qualified invoice issuers, a special exception for intermediary issuance will apply, allowing them to issue qualified invoices on behalf of the client, bearing the management company's registration number. For example, Patent Document 1 is an example of a system for issuing qualified invoices under the invoice system. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] Japanese Patent Publication No. 2022-179153 Summary of the Invention [Problem to be solved by the invention]
[0004] However, the above-mentioned Patent Document 1 does not state anything about reducing the workload of the person in charge by issuing invoices that meet the requirements of the invoice system according to the combination of the landlord's entrustment 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 entrustment type and billing items. [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 equipped with a control unit, for a management company registered with a qualified invoice issuing business to issue a landlord's invoice to a customer, the control unit comprising: a first master in which the landlord, registration number, and registration date are associated and registered; a second master in which the entrustment type and invoice subject classification including billing items, 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; and a second master in which the management entrustment contract data including the contract number, invoice date, and invoice subject classification including the contract number, property, room number, contractor, customer, and 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 contract number, billing classification, and customer, and for a target year and month, based on the management outsourcing contract data, the contract data, the monthly contract rent data, and the contract customer data, creates collection schedule data including a collection schedule identifier for identifying each item, billing number, billing year and month, sales posting date, billing items, main amount, consumption tax, property, room number, contract number, management outsourcing contract number, outsourcing type, customer business partner, and advance payment business partner; and an invoice output means for generating invoice work data including a collection schedule identifier, invoice item, 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 based on the generated invoice work data and the collection schedule data, and issuing invoices for each invoice number based on the generated invoice work data and the collection schedule data, wherein the invoice output means, for the landlord registered business FLG of the billing work data, uses the management outsourcing contract number as a key to obtain the landlord of the management outsourcing contract data, and uses the obtained landlord as a key to obtain the registration date from the first master, and if the obtained registration date is less than or equal to the sales posting date of the collection schedule data, 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, uses the incoming invoice item and outsourcing form of the collection schedule data as keys to obtain an invoice subject classification from the second master, and if the landlord is a qualified invoice issuing business,If the acquired invoice subject classification 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 classification is set as is, and the invoice output means issues a combined invoice and prints the management company's registration number if the invoice subject classification is sales and deposits, and if the landlord is not a qualified invoice issuing business and the intermediary issuance special exemption applies, issues an invoice for each invoice subject classification.
[0007] According to one aspect of the present invention, the control unit may be 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 management company's registration number from the third master.
[0008] According to another aspect of the present invention, the entrustment form may include a loan guarantee or a collection item.
[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, wherein the control unit stores a first master in which landlord, registration number, and registration date are associated and registered; a second master in which consignment type, billing items, invoice subject classification including sales, deposit, and advance payment are associated and registered; management consignment contract data including management consignment contract number, landlord, property, consignment type, and remittance date; contract data including contract number, property, room number, contractor, customer, and contract date; and contract rent monthly data including contract number, billing items, main amount, and consumption tax amount. and contract customer data including the contract number, billing classification, and customer, and a billing calculation processing step executed by the control unit to create 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 type, customer business partner, and advance payment business partner for a target year and month based on the management consignment contract data, the contract data, the contract monthly rent data, and the contract customer data; and 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 for each billing number based on the created billing work data and the collection schedule data, wherein 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, and if the obtained registration date is less than or equal to the sales posting date of the collection schedule data, it is determined that the landlord is 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 classification is obtained from the second master using the incoming invoice 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 classification is sales, purchases, or deposits, a group of sales, purchases, and deposits is set; if the landlord is not a qualified invoice issuing business, the invoice subject classification 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 classification is sales and deposits, a combined invoice is issued and the management company's registration number is printed; 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 classification.
[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 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 outsourcing type, an invoice item, and an invoice subject classification including sales, deposits, and advance payments are associated and registered; management outsourcing contract data including a management outsourcing contract number, a landlord, a property, an outsourcing 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, an invoice item, a base amount, and a consumption tax amount. and contract customer data including the contract number, billing classification, and 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 the target year and month, and the control unit is configured to have access to the management outsourcing contract data, the contract data, the contract rent monthly data, and the contract customer data for the target year and month, and to create 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 outsourcing contract number, outsourcing type, customer business partner, and advance payment business partner, and to create a collection schedule data including a collection schedule identifier, 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 for each 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 acquired 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"; 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 classification is sales, purchases, or deposits, a group of sales, purchases, and deposits is set; if the landlord is not a qualified invoice issuing business, the invoice subject classification 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 classification is sales and deposits, a combined invoice is issued and the management company's registration number is printed; 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 classification. [Effects of the Invention]
[0012] According to the present invention, by issuing an invoice that meets the requirements of the invoice system according to the combination of the landlord's entrustment type and billing items, it is possible to reduce the workload of the person in charge. [Brief explanation of the drawings]
[0013] [Figure 1] FIG. 1 is a diagram showing an example of the configuration of a bill processing device according to this embodiment. [Figure 2] FIG. 2 is a diagram illustrating an example of the configuration of the item master. [Figure 3] FIG. 3 is a diagram illustrating an example of the configuration of the property master. [Figure 4] FIG. 4 is a diagram illustrating an example of the configuration of the room master. [Figure 5] FIG. 5 is a diagram showing an example of the configuration of the journalization pattern master. [Figure 6] FIG. 6 is a diagram illustrating 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 contract data. [Figure 10] FIG. 10 is a diagram showing an example of the structure 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 processing by the control unit of the invoice processing device according to this embodiment. [Figure 14] FIG. 14 is a diagram for explaining a specific example of the processing of the control unit of the invoice processing device according to this embodiment. [Figure 15] FIG. 15 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. [Figure 16] FIG. 16 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. [Figure 17] FIG. 17 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. [Figure 18] FIG. 18 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. [Figure 19] FIG. 19 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. [Figure 20] FIG. 20 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. [Figure 21] FIG. 21 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. [Figure 22] FIG. 22 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. [Figure 23] FIG. 23 is a diagram for explaining a specific example of processing by the control unit of the invoice processing device according to this embodiment. DETAILED DESCRIPTION OF THE INVENTION
[0014] Hereinafter, embodiments of an invoice processing device, an invoice issuing method, and an invoice issuing program according to the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to these embodiments.
[0015] [1. Overview] 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 tenants, so the owner should normally issue a qualified invoice to the tenant. However, if both the management company and the owner are qualified invoice issuers, a special exemption for intermediaries will apply, allowing them to issue a qualified invoice on behalf of the client, bearing the management company's registration number.
[0016] If the owner is not a qualified invoice issuer, they must issue separate invoices for the management company's sales and the owner's deposit. In the rental housing management industry, the characteristics of billing items change depending on the type of management contract between the management company and the owner, making it complicated to manage what accounts are used for cash flow management.
[0017] For example, even for the same billing item, "rent," the characteristics (cash and deposit management items) can change depending on the type of consignment with the owner, such as being sales to the management company or being a deposit from the owner. Also, even for the same property, the type of consignment can change when the owner changes. It is necessary to determine whether the intermediary issuance exemption is possible based on the combination of "owner, consignment type, and billing item characteristics," which creates a heavy workload for the person in charge.
[0018] Therefore, in this embodiment, the workload of the person in charge is reduced by issuing an invoice that meets 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 based on the type of consignment and the classification of the invoice items. Also, because 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 invoice item, the master that controls the accounting entries has an invoice classification. Each combination of consignment type and invoice item has a classification of "sales," "deposit," or "advance" (cash receipt and payment management item), and whether the intermediary issuance special exemption is determined based on whether the owner is a qualified invoice issuing business. If applicable, the "sales" and "deposit" items are issued on a single invoice, and if not applicable, the "sales" and "deposit" items can be issued on 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 rental management.
[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 also be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or 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 that they can communicate with each other via any communication path.
[0024] The communication interface unit 104 communicatively connects the invoice processing device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has the function of communicating data with other devices via the communication line. Here, the network 300 has the function of connecting the invoice processing device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).
[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 achieve a pointing device function. Note that, hereinafter, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112. Displaying information on the monitor 114 and the user operating the input device 112 may be referred to as a "user operation via a UI."
[0026] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with an OS (Operating System) to issue commands to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc.
[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 configuration 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 that associates and registers the item code of the billing item, its item name, and rent category, as shown in Figure 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 Figure 5, the journal entry pattern master 106d can be configured as a table that associates and registers the consignment type code, billing item code, income general account item, payment general account item, and invoice item classification (input / output management item). In the example shown in the figure, the first line has the consignment type code "1," item code "1010," income general account item "5400: Rent Receipt," payment general account item "7503: Rent Payment," and invoice item classification "1: Sales / Purchases." The second line has the consignment type code "1," item code "1210," income general account item "3551: Rent Received," payment general account item " ," and invoice item classification "2: Deposit." The sixth line has the consignment type code "4," item code "2002," income general account item "1200: Accounts Receivable," payment general account item " ," and invoice item classification "3: Advance Payment."
[0032] The control master 106e can be configured as a table that associates and registers the company name, registration number, and invoice start category of the management company, as shown in Figure 6. In the example shown in the figure, the first line contains the company name "XX Company", the registration number "T123400000000", and the invoice start category "Yes".
[0033] The business partner landlord master 106f can be configured as a table that associates and registers business partner (landlord) codes, business partner names, registration numbers, and registration dates, as shown in Figure 7. In the example shown in the figure, the first line has business partner code "0000000001," business partner name "○○○○," registration number "T0000000000001," and registration date "2023 / 10 / 1," while the second line has 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 created by the bill output processing unit 102d.
[0035] The management contract data may include the management contract number, landlord code, property code, contract type code, and remittance date, as shown in Figure 8. In the example shown in the figure, the first line has the management contract number "00000001234," landlord code "0000000001," property code "A0000000001," contract type code "1: Lease guarantee," and remittance date "10," while the second line has the management contract number "00000001255," landlord code "0000000002," property code "B0000000001," contract type code "4: Property for collection," and remittance date "15."
[0036] The management contract room-specific data may include the management contract number, property code, room number, contract type code, start of validity period, and end of validity period (see FIG. 21).
[0037] The contract data may include a contract number, a property code, a room number, a contractor, a tenant, and a contract date, as shown in Fig. 9. In the example shown in Fig. 9, the first line contains the contract number "100000000001," the property code "A0000000001," the room number "101," the contractor "001: Yamada Taro," the tenant "001: Yamada Taro," and the contract date "2023 / 1 / 5," and the second line contains the contract number "200000000001," the property code "B0000000001," the room number "201," the contractor "002: Sato Hanako," the tenant "002: Sato Hanako," and the contract date "2023 / 2 / 15."
[0038] The monthly contract rent data may include the contract number, billing item code, the actual amount, and consumption tax, 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 actual amount "10000," and the consumption tax amount "1000."
[0039] The contract customer data may include a contract number, billing category, customer code, payment method code, and document delivery address code, as shown in Figure 11. In the example shown in the figure, the first line contains the contract number "100000000001," the billing category "0: Contractor," the customer code "001: Yamada Taro," the payment method code "0: Bank transfer," and the document delivery address code "0."
[0040] The collection schedule data may include a collection schedule Guid (collection schedule identifier) that identifies each item, the billing number, the billing year and month, the sales recording date, the billing item code, the main amount, consumption tax, the property code, the room number, the contract number, the management contract number, the outsourcing type code, the customer code, the billing customer classification, and the advance payment customer code (see Figure 14).
[0041] In the above, a master is prepared to convert between a code and its corresponding name, but either or both of the code and the name can be used, and a master to convert between a code and its corresponding name is not necessarily required. Hereinafter, "XX" means the XX code and / or the XX name (for example, "property" means the property code and / or the 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 information processing operations 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, monthly contract rent 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, monthly contract rent data, collection schedule data, invoice number history data, etc. may be provided elsewhere (for example, in the server 200) as long as they are accessible by the control unit 102.
[0044] The control unit 102 conceptually includes 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 for the item master 106a, property master 106b, room master 106c, accounting pattern master 106d, control master 106e, and client landlord master 106f, for example, in response to 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 item, billing number, billing year and month, sales posting date, billing item, main amount, consumption tax, property, room number, contract number, management contract number, outsourcing type, customer business partner, and advance payment business partner, based on the management contract data, contract data, contract monthly 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, for example, and registers this data in the memory unit 106.
[0048] The type of consignment may include a lease 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 scheduled collection data, including the scheduled collection identifier, management item, billing year and month, customer code, sales accounting date, management outsourcing contract number, outsourcing type, 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 scheduled collection data.
[0050] For the landlord registered business FLG of the billing work data, the bill 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 bill issuing business and sets the landlord registered business FLG to "landlord is a qualified bill issuing business", otherwise sets the landlord registered business FLG to "landlord is not a qualified bill issuing business", and for the invoice subject group of the billing work data, acquires the invoice subject of the collection schedule data Using the type 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, 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 with regard to invoices, 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, 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 applies, an invoice is issued for each invoice subject category.
[0051] The invoice output processing unit 102d may obtain the management company's registration number 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 inputs thereto.
[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] Figure 12 is a diagram showing a flow for explaining an outline of the overall processing by the control unit 102 of the invoice processing device 100 in this embodiment. With reference to Figure 12, an outline of the overall processing by the control unit 102 of the invoice processing device 100 in this embodiment will be described.
[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 accordance with, 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 and registers in the memory unit 106, for example, collection schedule data for the target year and month and property specified by the operator on the billing calculation screen displayed on the monitor 114, based on the management contract data, contract data, monthly contract rent data, and contract customer data stored in the memory unit 106. The collection schedule data includes a collection schedule identifier for identifying each item, a billing number, the billing year and month, the sales posting date, the billing item, the base amount, consumption tax, the property, the room number, the contract number, the management contract number, the contract type, the customer business partner, and the advance payment business partner. The contract type may include a lease guarantee or a property for which payment 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 in the work table 106g based on the collection schedule data, including the collection schedule identifier, invoice 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 item group, and invoice number, and issues invoices by invoice number based on the generated invoice work data and collection schedule data.
[0058] Furthermore, for the landlord registered business FLG of the billing work data, the bill 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 bill issuing business and sets the landlord registered business FLG to "landlord is a qualified bill issuing business", otherwise sets the landlord registered business FLG to "landlord is not a qualified bill issuing business", and for the invoice subject group of the billing work data, acquires the registration date of the collection schedule data Using the item and consignment type as keys, the invoice subject classification is obtained from the accounting pattern master (second master) 106d. If the landlord is a qualified invoice issuer, the sales, purchases, or deposits are set as a group of sales, purchases, and deposits. If the landlord is not a qualified invoice issuer, the invoice subject classification is set as is. Regarding invoices, if the landlord is a qualified invoice issuer and the intermediary issuance special exception applies, if the invoice subject classification is sales and deposits, the invoice is issued as a combined invoice and the management company's registration number is printed on it. If the landlord is not a qualified invoice issuer and the intermediary issuance special exception does not apply, the invoice is issued for each invoice subject classification. The invoice output processing unit 102d may also 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 described with reference to FIGS. 13 to 23. Below, an example will be described in which the master and data configuration examples shown in 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 Figures 13 and 14. For example, the billing calculation processing unit 102c creates collection schedule data for a target year / month and property specified by an operator on the billing calculation screen displayed on the monitor 114, based on the management contract data, contract data, monthly contract rent data, and contract customer data stored in the storage unit 106. The collection schedule data includes a collection schedule identifier for identifying each item, a billing number, a billing year / month, a sales posting date, billing items, a base price, consumption tax, property, room number, contract number, management contract number, contract type, client business partner, and advance payment business partner, and registers the data in the storage unit 106. The contract type may include a lease guarantee or a property for which payment 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 an example of the display of the billing calculation processing screen 400. The billing calculation processing screen 400 has 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 references the contract information (management outsourcing contract data, contract data, monthly contract rent data, and contract customer data) in accordance with the specified extraction conditions and creates collection schedule data.
[0063] In the example shown in the figure, when the billing year and month "2023 / 10" and properties "A0000000001 to B0000000001" are specified, collection schedule data such as that shown in FIG. 14 is created.
[0064] Figure 14 is a diagram showing an example of collection schedule data. As shown in Figure 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, management item code, base amount, consumption tax, property code, room number, contract number, management contract number, outsourcing code, landlord customer code, billing customer classification, and advance payment customer code. For example, the advance payment customer 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 scheduled collection 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 classification "0: Contractor".
[0066] (S3: Invoice output process) 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 the collection schedule identifier, invoice 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 item group, and invoice number, and issues invoices by invoice number based on the generated invoice work data and collection schedule data.
[0067] For the landlord registered business FLG of the billing work data, the bill 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 bill issuing business and sets the landlord registered business FLG to "landlord is a qualified bill issuing business", otherwise sets the landlord registered business FLG to "landlord is not a qualified bill issuing business", and for the invoice subject group of the billing work data, acquires the invoice subject of the collection schedule data Using the type of consignment as a key, the invoice subject classification is obtained from the accounting pattern master (second master) 106d, and if the landlord is a qualified invoice issuer, the sales, purchases, or deposits are set as a group of sales, purchases, and deposits.If the landlord is not a qualified invoice issuer, the invoice subject classification is set as is.As for invoices, if the landlord is a qualified invoice issuer and the intermediary issuance special exception applies, if the invoice subject classification is sales and deposits, an invoice is issued together and the management company's registration number is printed on it.If the landlord is not a qualified invoice issuer and the intermediary issuance special exception does not apply, an invoice is issued for each invoice subject classification.The invoice output processing unit 102d may also obtain the management company's registration number from the control master 106e (third master).
[0068] In the invoice output process, it is possible to determine whether the special exemption for intermediary delivery applies, and issue an appropriate invoice by referring to the invoice subject classification in the accounting pattern master 106d.
[0069] Process 1: Determine whether or not the invoice subject classification is an intermediary delivery exception for each item of collection schedule data. Expand the invoice work data linked to the target collection schedule data 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 has the following fields: collection schedule Guid (collection schedule identifier), invoice item code, billing year and month, customer business partner code, sales posting date, management outsourcing contract number, outsourcing type 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", contract type code "1: Lease guarantee", landlord registration business FLG "1: Landlord is a qualified invoice issuing business", 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 are updated simultaneously using the logic (1) and (2) below.
[0073] (1) Determine whether or not the special intermediary delivery exception applies based on each collection plan data. Figure 16 is a diagram to explain how to determine whether an owner is a qualified bill 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 special exemption for intermediary issuance is applied.
[0075] As a result of the above, the special intermediary issuance exemption applies to collection scheduled Guids 1, 2, and 3, and the special intermediary issuance exemption does not apply to collection scheduled Guids 4, 5, 6, and 7 (see Figure 17 (A)). In the invoice work data, the Landlord Registration 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, if the owner is a qualified invoice issuer, it becomes possible to issue invoices divided into 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 divided into invoice subject categories [1: Sales / Purchases], [2: Deposits] and [3: Advance].
[0077] (2) Determine the invoice category for each collection data item. If the special exemption for intermediary delivery applies, the amount held by the owner 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 journal entry pattern master 106d.
[0078] Using the item code and consignment type code of the collection schedule data as keys (see Figure 17(A)), the invoice subject classification is obtained from the accounting pattern master 106d (see Figure 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 and 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, the invoice subject classification is set as is in the invoice subject group (see Figure 17(B)). The invoice subject group is used as the unit for issuing invoices.
[0081] Process 2: Issue an invoice. Figures 18 and 19 are diagrams for explaining the issuance of an invoice. When the intermediary issuance special exception is applied, invoice subject categories 1 (sales / purchases) and 2 (deposits) are printed together on the invoice, and when the intermediary issuance special exception is not applied, an invoice is issued for each invoice subject category. In this way, by registering invoice subject categories in the journal entry 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 address 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 commission type code.
[0083] Invoice numbers are assigned in the invoice work data, and invoices are issued for each invoice number based on the invoice work and collection schedule 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, collection schedule Guid, and issue date. In the example shown in the figure, the first line has the invoice number "0001," the collection schedule Guid "1," and the issue date "2023 / 10 / 20."
[0084] In the case of invoice number "0001," the owner is a qualified invoice issuer, so the intermediary issuance 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 intermediary issuance special exemption applies. The intermediary issuance special exemption applies, but because the invoice subject classification is "advance payment," a different invoice from invoice number "0001" will be issued.
[0086] In the case of invoice number "0003," the owner is not a qualified invoice issuer, so the special exemption for intermediary issuance does not apply. An invoice with only the deposit and withdrawal management item in the invoice subject category "Deposit" will be printed, and the management company's registration number will not be printed.
[0087] In the case of invoice number "0004," the owner is not a qualified invoice issuer, so the special exemption for intermediary issuance does not apply. An invoice with only the cash management item in the invoice subject category "Sales" is printed, and the management company's registration number is printed.
[0088] In the case of 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 cash flow management item with the invoice subject classification of "Advance" is printed, and the registration number of the advance recipient is printed.
[0089] (Invoice output when changing management contract) The output of an invoice when a management contract is changed will be described with reference to Figures 20 to 23. Here, the explanation will be given using data different from that described above, and it is assumed that the data in Figure 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 expected collection data created based on these data by executing the same billing calculation process (billing year and month: October 2023) S2 as above.
[0091] Assume 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] The invoice calculation process creates scheduled collection data based on the changed data. 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 starting from the relevant month and year in the monthly contract rent data and the billing calculation process for November, create the collection schedule data for the billing month and year of November and the relevant month of December (billing month and year + calculated number of months for the relevant month). The management contract number is obtained using 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 for the November collection schedule data, "00000002222", and set the obtained management contract number in the collection schedule data.
[0094] An invoice is issued by referring to the journal entry pattern master 106d shown in Figure 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 in 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 consignment types and invoice subject categories including billing items, sales, deposits, and advances are associated and registered; management consignment contract data including management consignment contract number, landlord, property, consignment type, and remittance date; contract data including contract number, property, room number, contractor, customer, and contract date; monthly contract rent data including contract number, billing items, main amount, and consumption tax amount; and contract customer data including contract number, billing category, and customer. and a billing calculation processing unit 102c that creates 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 consignment contract number, consignment type, customer business partner, and advance payment business partner based on the collection schedule data, the management consignment contract data, the contract data, the monthly contract rent data, and the contract customer data. and an invoice output processing unit 102d that generates billing work data including a landlord registered business FLG indicating whether the landlord is a registered business operator, an invoice subject group, and an invoice number, and issues invoices for each invoice number based on the generated billing work data and the collection schedule data. The invoice output processing unit 102d, for the landlord registered business FLG of the billing work data, uses the management entrustment contract number as a key to acquire the landlord of the management entrustment contract data, uses the acquired landlord as a key to acquire the registration date of the client landlord master 106f, and calculates whether the acquired registration date is equal to or less than the sales posting date of the collection schedule data. If so, 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 classification is obtained from the journal pattern master 106d using the invoice item and consignment form of the collection schedule data as keys, and if the landlord is a qualified invoice issuing business, and the obtained invoice subject classification 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 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, 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. This makes it possible to reduce the workload of the person in charge by issuing invoices that meet the requirements of the invoice system according to the combination of the landlord's commission type and invoice items.
[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 the achievement of SDGs Goals 8 and 9.
[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, which can contribute to the achievement of Goal 16 of the SDGs.
[0099] 5. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.
[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] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed as desired unless otherwise specified.
[0102] Furthermore, with regard to the bill processing device 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.
[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 implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the invoice processing device 100 as needed. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to issue instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to form the control unit.
[0104] This computer program may also be stored in an application program server connected to the invoice processing device 100 via any network, and all or part of it may be downloaded as needed.
[0105] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.
[0106] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.
[0107] The various databases stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.
[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 an information processing device connected to any peripheral device. The invoice processing device 100 may also be realized by installing software (including programs, data, etc.) that causes the device to perform the processing described in this embodiment.
[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 configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Explanation of symbols]
[0110] 100 Invoice processing device 102 Control section 102a Master Maintenance Department 102b Data Registration and Change Section 102c Billing calculation processing unit 102d Invoice output processing unit 102e Screen display control unit 104 Communication interface unit 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 Device 114 Output Device 200 servers 300 Network
Claims
1. A billing device that includes a control unit and allows a management company that is registered with a qualified billing company to issue a landlord's bill to a customer, The control unit a first master in which the landlord, the registration number, and the registration date are associated and registered; A second master in which the consignment type and the invoice subject classification including billing items, sales, deposits, and advance payments are associated and 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; It is configured to be accessible to a billing calculation processing means for creating collection schedule data for a target year and month based on the management consignment contract data, the contract data, the monthly contract rent data, and the contract customer data, including a collection schedule identifier for identifying each item, a billing number, a billing year and month, a sales posting date, billing items, a main amount, consumption tax, a property, a room number, a contract number, a management consignment contract number, a consignment form, a customer business partner, and an advance payment business partner; an invoice output means for generating invoice work data based on the collection schedule data, including a collection schedule identifier, invoice item, 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 item group, and invoice number, and issuing invoices by invoice number based on the generated invoice work data and the collection schedule data; Equipped with The bill output means 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 bill issuing business, and the landlord registered business FLG is set to "landlord is a qualified bill issuing business", otherwise the landlord registered business FLG is set to "landlord is not a qualified bill issuing business", For the invoice subject group of the billing work data, the invoice subject classification is obtained from the second master using the invoice item and 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 classification is sales, purchases, or deposits, a group of sales, purchases, or deposits is set, and if the landlord is not a qualified invoice issuing business, the invoice subject classification is set as is, With regard to the invoice, if the landlord is a qualified invoice issuing business and the intermediary issuance special exemption applies, if the invoice subject categories are sales and deposits, the invoice will be issued in bulk and the management company's registration number will be printed on it, and if the landlord is not a qualified invoice issuing business and the intermediary issuance special exemption does not apply, the invoice processing device will issue an invoice for each invoice subject category.
2. The control unit The third master is configured to be accessible and registered in association with the management company and the registration number, 2. The invoice processing device according to claim 1, wherein said invoice output means acquires the registration number of the 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 bill processing device according to claim 1, wherein the bill 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 a first master in which the landlord, the registration number, and the registration date are associated and registered; A second master in which the consignment type and the invoice subject classification including billing items, sales, deposits, and advance payments are associated and 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; It is configured to be accessible to Executed in the control unit: a billing calculation process for creating collection schedule data for the target year and month based on the management contract data, the contract data, the monthly contract rent data, and the contract customer 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 type, customer business partner, and advance payment business partner; an invoice output process for creating invoice work data based on the collection schedule data, including a collection schedule identifier, invoice item, 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 item group, and invoice number, and issuing invoices by invoice number based on the created invoice work data and the collection schedule data; Including, In the bill 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 bill issuing business, and the landlord registered business FLG is set to "landlord is a qualified bill issuing business", otherwise the landlord registered business FLG is set to "landlord is not a qualified bill issuing business", For the invoice subject group of the billing work data, the invoice subject classification is obtained from the second master using the invoice item and 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 classification is sales, purchases, or deposits, a group of sales, purchases, or deposits is set, and if the landlord is not a qualified invoice issuing business, the invoice subject classification is set as is, Regarding the invoice, if the landlord is a qualified invoice issuing business and the intermediary issuance special exemption applies, and 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, an invoice is issued for each invoice subject category.
6. An invoice processing program to be executed by an information processing device having a control unit, The control unit The control unit a first master in which the landlord, the registration number, and the registration date are associated and registered; A second master in which the consignment type and the invoice subject classification including billing items, sales, deposits, and advance payments are associated and 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; It is configured to be accessible to In the control unit, a billing calculation process for creating collection schedule data for the target year and month based on the management contract data, the contract data, the monthly contract rent data, and the contract customer 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 type, customer business partner, and advance payment business partner; an invoice output process for creating invoice work data based on the collection schedule data, including a collection schedule identifier, invoice item, 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 item group, and invoice number, and issuing invoices by invoice number based on the created invoice work data and the collection schedule data; an invoice processing program for executing In the bill 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 bill issuing business, and the landlord registered business FLG is set to "landlord is a qualified bill issuing business", otherwise the landlord registered business FLG is set to "landlord is not a qualified bill issuing business", For the invoice subject group of the billing work data, the invoice subject classification is obtained from the second master using the invoice item and 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 classification is sales, purchases, or deposits, a group of sales, purchases, or deposits is set, and if the landlord is not a qualified invoice issuing business, the invoice subject classification is set as is, With regard to the invoice, if the landlord is a qualified invoice issuing business and the intermediary issuance special exemption applies, and if the invoice subject categories are sales and deposits, the invoice is issued in bulk 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, the invoice processing program is characterized by issuing an invoice for each invoice subject category.
Citation Information
Patent Citations
Voucher determination device, accounting processing device, voucher determination program, voucher determination system, and voucher determination method
JP2021071991A
Program, information processing device and method
JP2022179153A