Invoice processing device, invoice processing method and invoice processing program
Patent Information
- Application Number
- JP2023141731
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2023-08-31
- Publication Date
- 2025-03-13
- Estimated Expiration
- 2043-08-31
AI Technical Summary
【0012】 本発明によれば、管理会社において、請求書を発行するオペレータが、オーナーの登録日を意識しなくてもインボイス制度に対応した請求書の発行が可能となるという効果を奏する。
Smart Images

Figure 2025035002000001_ABST
Abstract
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] For example, in the real estate industry, there are contract types such as company ownership, subleasing, and entrusted management depending on the ownership form of the property. In the qualified invoice storage method of the invoice system that will be introduced from October 1, 2023, if a qualified invoice issuing business is registered as a business after the start date of the system (October 1, 2023), it will not be able to issue a qualified invoice for transactions that are made after the start date of the system but before the date of registration. For example, Patent Document 1 is a conventional system for dealing with the invoice system. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] JP 2023-38949 A Summary of the Invention [Problem to be solved by the invention]
[0004] However, the above-mentioned Patent Document 1 does not state anything about enabling an operator at a management company who issues invoices to issue invoices that comply with the invoice system without being aware of the owner's registration date.
[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 enable an operator at a management company who issues invoices to issue invoices that comply with the invoice system without being aware of the owner's registration date. [Means for solving the problem]
[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides an invoice processing device that includes a control unit and allows a management company to issue invoices on behalf of an owner, the control unit being configured to be able to access a memory area that stores a customer master that associates and registers customer, registration number of qualified invoice issuer, and registration date, and an ownership ratio master that associates and registers property, ownership ratio code, customer including owner, and ownership ratio, invoice registration means that inputs invoice detail data including invoice destination, management item, property, ownership ratio code, relevant month, base amount, consumption tax, amount including tax, and invoice identification code that specifies invoice unit, and registers it in the memory area; and a billing confirmation means for referring to the business partner master and, in the case where there is a mixture of details for the relevant month before the registration date of a business partner in the equity ratio master linked to an equity ratio code, and details for the relevant month after the registration date, updating and confirming the details to a billing identification code other than the same billing identification code, and an invoice issuing means for issuing an invoice for each billing identification code based on the confirmed billing detail data, and in doing so, obtaining the registration number and registration date of the business partner in the equity ratio master linked to the equity ratio code by referring to the business partner master, and printing the registration number of the business partner if the registration date is less than or equal to the relevant month, and not printing the registration number of the business partner if the registration date is greater than the relevant month.
[0007] In addition, according to one aspect of the present invention, when the invoice confirmation means confirms the invoice for the invoice detail data registered in the memory area, if there are multiple business partners in the equity ratio master linked to the equity ratio code for the invoice detail data, the invoice confirmation means may divide the details for each business partner, create invoice detail apportionment data in which the amount is apportioned according to the equity ratio of the business partner in the equity ratio master, and register the data in the memory area.
[0008] In addition, according to one aspect of the present invention, the billing confirmation means may further refer to the customer master for the billing detail allocation data, and if there is a detail with the same billing identification code for the corresponding month prior to the registration date of the customer in the ownership ratio master linked to the ownership ratio code, update that detail to a billing identification code other than the same billing identification code.
[0009] Furthermore, according to one aspect of the present invention, when issuing an invoice, the invoice issuing means may issue an invoice based on invoice detail allocation data if invoice detail allocation data is available, and may otherwise issue an invoice based on invoice detail data.
[0010] In addition, 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 being configured to be able to access a memory area storing a customer master in which customer, registration number of qualified invoice issuer, and registration date are associated and registered, and an ownership ratio master in which customer including property, ownership ratio code, owner, and ownership ratio are associated and registered, the control unit executing an invoice registration process for inputting invoice detail data including invoice destination, management item, property, ownership ratio code, relevant month, base amount, consumption tax, tax-inclusive amount, and invoice identification code defining invoice unit, and registering the invoice detail data in the memory area; The method includes a billing confirmation step of, at the time of confirmation, referring to the business partner master, and if there is a mixture of details for the relevant month before the registration date of the business partner in the equity ratio master linked to the equity ratio code, and details for the relevant month after the registration date, with the same billing identification code, updating the details to a billing identification code other than the same billing identification code and confirming them, and an invoice issuing step of issuing an invoice for each billing identification code based on the confirmed billing detail data, and at that time, referring to the business partner master, obtaining the registration number and registration date of the business partner in the equity ratio master linked to the equity ratio code, and printing the registration number of the business partner if the registration date is less than or equal to the relevant month, and printing the registration number of the business partner if the registration date is greater than the relevant month.
[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 being configured to be able to access a memory area storing a customer master in which customer, registration number of qualified invoice issuer, and registration date are associated and registered, and an ownership ratio master in which property, ownership ratio code, customer including owner, and ownership ratio are associated and registered, the control unit including a billing registration step of inputting billing detail data including billing destination, management item, property, ownership ratio code, applicable month, base amount, consumption tax, amount including tax, and a billing identification code that specifies the invoice unit, and registering the input data in the memory area; and an invoice confirmation process for updating and confirming a billing identification code different from the same billing identification code for the details, in the case where the same billing identification code is used, between a detail for a month before the registration date of a business partner in the equity ratio master linked to an equity ratio code and a detail for a month after the registration date, by referring to the business partner master, and in the case where the same billing identification code is used, between a detail for a month before the registration date of the business partner in the equity ratio master linked to an equity ratio code and a detail for a month after the registration date, the details are updated and confirmed with a billing identification code different from the same billing identification code, and an invoice is issued by billing identification code unit based on the confirmed billing detail data, in which the business partner master is referred to and the registration date of the business partner in the equity ratio master linked to the equity ratio code is obtained, and if the registration date is less than or equal to the relevant month, the registration number of the business partner is printed, and if the registration date is greater than the relevant month, the registration number of the business partner is not printed. Effect of the Invention
[0012] According to the present invention, an operator at a management company who issues invoices can issue invoices in accordance with the invoice system without being aware of the owner's registration date. [Brief description of the drawings]
[0013] [Figure 1] FIG. 1 is a diagram for explaining qualified invoices. [Diagram 2] Figure 2 shows a transaction diagram for the special intermediary provision. [Diagram 3]FIG. 3 is a diagram showing an example of the configuration of the invoice processing device according to the present embodiment. [Figure 4] FIG. 4 is a diagram showing the relationship between the billing detail data, the ownership ratio master, and the customer master. [Diagram 5] FIG. 5 is a diagram showing the relationship between the billing detail data, the billing detail apportionment data, and the ownership ratio master. [Figure 6] FIG. 6 is a diagram illustrating an example of the configuration of the supplier master. [Figure 7] FIG. 7 is a diagram illustrating an example of the configuration of the management item master. [Figure 8] FIG. 8 is a diagram illustrating an example of the configuration of the property master. [Figure 9] FIG. 9 is a diagram illustrating an example of the configuration of the ownership ratio master. [Figure 10] FIG. 10 is a flow diagram showing an example of the overall processing of the invoice processing device according to this embodiment. [Figure 11] FIG. 11 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 12] FIG. 12 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 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. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0014] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of a bill processing device, a bill processing method, and a bill processing program according to the present invention will be described in detail below with reference to the accompanying drawings. Note that the present invention is not limited to the embodiment.
[0015] [1. Overview] The outline of the present invention will be described with reference to Figs. 1 and 2. For example, in the real estate industry, there are contract forms such as company ownership, subleasing, and management entrustment depending on the ownership form of the property. In the qualified invoice storage method of the invoice system introduced on October 1, 2023, if a qualified invoice issuing business operator registers as a business operator after the start date of the system (October 1, 2023), he / she cannot issue a qualified invoice for transactions after the start date of the system but before the registration date. Therefore, for invoices that straddle the registration date, it is necessary to distinguish between transactions before and after the registration date and to state them on the invoice, etc.
[0016] Figure 1 is a diagram to explain qualified invoices. If the qualified invoice issuer registration is made after the start date of the system (October 1, 2023), qualified invoices cannot be issued for transactions made before the registration date. For example, in the case of a management contract, if the electricity charges are for October and the owner registration date is November 1, 2023, a qualified invoice that includes the October electricity charges cannot be issued, and the qualified invoice for November and the invoice for the October electricity charges must be separated.
[0017] In the case of management contract, the management company issues the invoice on behalf of the owner (proxy (issuance). Figure 2 is a transaction diagram for the special exemption for intermediary issuance. Both the trustor (owner) and the trustee (management company) must be qualified invoice issuers. The trustee (management company) can issue a qualified invoice with its name and registration number listed to the purchaser (tenant). The trustee (management company) must also issue a copy of the qualified invoice it issued to the trustor (owner) (it also has an obligation to keep it). The trustor (owner) has an obligation to keep a copy of the qualified invoice issued to it by the trustee (management company).
[0018] Management companies face the challenge of having to decide whether or not to issue qualified invoices for transactions that occurred before and after the owner's registration as a qualified invoice issuer, which creates a large workload.
[0019] Therefore, in this embodiment, it is possible for the owner to automatically issue invoices that comply with the invoice system depending on the date of registration of the owner as a qualified invoice issuing business in the entrusted management.
[0020] Specifically, in this embodiment, in order to avoid issuing transactions before and after the date of registration of the owner's qualified invoice issuer on the same invoice, the billing information before and after the registration date is automatically separated and the invoices are output separately.
[0021] In addition, in this embodiment, an invoice group code is assigned to the billing information for unregistered business owners, making it possible to issue the invoice separately from qualified invoices. When outputting invoices for multiple owners, the invoices are divided for each owner.
[0022] This embodiment is equipped with the following functions. When finalizing a bill, if transactions before and after the owner registration date are mixed in the same invoice in the billing detail data created from the contract information of the entrusted management, the invoice group code and billing identification code are updated. At this time, in the case of multiple owners, the updates are made for each owner. Invoices with different invoice group codes and billing identification codes are output separately from the billing detail data.
[0023] According to this embodiment, when issuing qualified invoices on behalf of management entrustment, the operator who issues the invoice can automatically split and issue invoices with details for the period when multiple owners were unregistered businesses, without the operator being aware of the registration of each owner's qualified invoice issuer. Also, since the operator who issues the invoice does not need to determine the registration dates of multiple owners' qualified invoice issuers, it is possible to reduce the workload and input errors.
[0024] [2. Configuration] An example of the configuration of the invoice processing device according to this embodiment will be described with reference to FIG. The invoice processing device according to this embodiment can be suitably used in, for example, real estate management companies (including PM companies), etc. Fig. 3 is a block diagram showing an example of the configuration of the invoice processing device 100 according to this embodiment.
[0025] 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.
[0026] 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.
[0027] 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).
[0028] 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."
[0029] 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.
[0030] The storage unit 106 stores, for example, a business partner master 106a, a management item master 106b, a property master 106c, an ownership ratio master 106d, billing statement data, billing statement apportionment data, etc. FIG. 4 is a diagram showing the relationship between the billing statement data, the ownership ratio master 106d, and the business partner master 106a. FIG. 5 is a diagram showing the relationship between the billing statement data, the billing statement apportionment data, and the ownership ratio master 106d. FIG. 6 is a diagram showing an example of the configuration of the business partner master 106a. FIG. 7 is a diagram showing an example of the configuration of the management item master 106b. FIG. 8 is a diagram showing an example of the configuration of the property master 106c. FIG. 9 is a diagram showing an example of the configuration of the ownership ratio master 106d.
[0031] Supplier master 106a is a master relating to supplier information, and may be configured as a table or the like in which supplier codes, supplier names, and registration numbers (qualified invoice issuer registration numbers) are associated and registered, as shown in FIG.
[0032] In the example shown in the same figure, the first line is the customer code "T00001", customer name "Tenant A", registration number "T1000000000001", and registration date "2023 / 10 / 1", the second line is the customer code "T00002", customer name "Owner B", registration number "T1000000000002", and registration date "2023 / 11 / 1", the third line is the customer code "T00003", customer name "Owner C", registration number "T1000000000003", and registration date "2023 / 12 / 1", and the fourth line is the customer code "T00009", customer name "Our company (PM Real Estate)", registration number "T1000000000009", and registration date "2023 / 10 / 1".
[0033] The management item master 106b is a master for managing management items for billing, and can be configured with a table in which management item codes and management item names are registered in association with each other, as shown in Fig. 7. The management item master 106b is referenced when converting management item codes and management item names. In the example shown in the figure, the first line has the management item code "K01" and the management item name "office rent", the second line has the management item code "K02" and the management item name "common area fee", and the third line has the management item code "K03" and the management item name "electricity fee".
[0034] The property master 106c is a master for managing property information, and can be configured with a table in which property codes and property names are registered in association with each other, as shown in Fig. 8. The property master 106c is referenced when converting property codes and property names. In the example shown in the figure, the property code is "1001" and the property name is "OB Building."
[0035] The ownership ratio master 106d is a master for managing the ownership ratio of properties, and can be configured with a table in which property codes, ownership ratio codes, constituent customer codes, and ownership ratios are associated and registered, as shown in Fig. 9. In the example shown in the figure, the first line is property code "1001", ownership ratio code "01", constituent customer code "T00002", and ownership ratio "100", the second line is property code "1001", ownership ratio code "02", constituent customer code "T00009", and ownership ratio "100", the third line is property code "1001", ownership ratio code "03", constituent customer code "T00002", and ratio "60", and the fourth line is property code "1001", ownership ratio code "03", constituent customer code "T00003", and ownership ratio "40".
[0036] The billing detail data may include a billing sequence, billing destination code, management item code, property code, ownership ratio code, applicable month, base amount, consumption tax, amount including tax, billing group code, and a billing identification code that specifies the billing unit (the unit for consolidating bills onto one sheet) (see FIG. 13).
[0037] The billing detail allocation data may include a billing sequence number, an owner code (customer code), a basic amount, a consumption tax, an amount including tax, a billing group code, and a billing identification code (see FIG. 14).
[0038] As shown in FIG. 4, the billing statement data and the ownership ratio master 106d are linked by the property code and ownership ratio code, and the ownership ratio master 106d and the customer master 106a are linked by the customer code.
[0039] As shown in FIG. 5, the billing detail data and the billing detail apportionment data are linked by the billing SEQ, and the billing detail apportionment data and the ownership ratio master 106d are linked by the customer code.
[0040] Returning to Figure 3, 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.
[0041] The control unit 102 is configured to be able to access the business partner master 106a, the management item master 106b, the property master 106c, the ownership ratio master 106d, the billing detail data, the billing detail apportionment data, etc., stored in the memory unit 106. Note that the business partner master 106a, the management item master 106b, the property master 106c, the ownership ratio master 106d, the billing detail data, the billing detail apportionment data, etc. may be provided in another location (e.g., the server 200) as long as the control unit 102 is able to access them.
[0042] The control unit 102 conceptually includes, in terms of functions, a billing registration unit 102a, a billing data determination unit 102b, an invoice issuing unit 102c, a master maintenance unit 102d, and a screen display control unit 102e.
[0043] The billing registration unit 102a inputs billing detail data including the billing sequence, billing destination, management item, property, ownership ratio code, applicable month, base amount, consumption tax, amount including tax, billing group code, and billing identification code that defines the billing unit, in response to, for example, an operator's operation on the variable billing registration screen displayed on the monitor 114, and registers the data in the memory unit 106.
[0044] The billing data confirmation unit 102b, for example, in response to an operator's operation on the billing data confirmation screen displayed on the monitor 114, checks the billing detail data registered in the memory unit 106 with reference to the supplier master 106a at the time of billing confirmation (e.g., the billing closing date), and if there is a mixture of details for the month before the registration date of the supplier in the ownership ratio master 106d linked to the ownership ratio code with the same billing identification code and details for the month after the registration date, updates the details to a billing identification code other than the same billing identification code and confirms them.
[0045] In addition, when the billing detail data registered in the memory unit 106 is finalized, if there are multiple business partners in the ownership ratio master 106d linked to the ownership ratio code for the billing detail data, the billing data finalization unit 102b may divide the details for each business partner, create billing detail apportionment data in which the amount is apportioned according to the ownership ratio of the business partner in the ownership ratio master 106d, and register the data in the memory unit 106.
[0046] In addition, the billing data determination unit 102b may further refer to the customer master 106a for the billing detail allocation data, and if there is a detail for the relevant month prior to the registration date of the customer in the ownership ratio master 106d linked to the ownership ratio code with the same billing identification code, update that detail to a billing identification code other than the same billing identification code.
[0047] The invoice issuing unit 102c issues an invoice based on the confirmed invoice detail data in accordance with, for example, an operator's operation on the invoice issuance screen displayed on the monitor 114, and at that time, refers to the supplier master 106a to obtain the supplier registration number and registration date in the ownership ratio master 106d linked to the ownership ratio code, and if the registration date is less than or equal to the relevant month, prints the supplier registration number, and if the registration date is greater than or equal to the relevant month, does not print the supplier registration number.
[0048] In addition, when issuing an invoice, the invoice issuing unit 103c may issue the invoice based on the invoice detail allocation data if the invoice detail allocation data is available, and may issue the invoice based on the invoice detail data otherwise.
[0049] The master maintenance unit 102d performs editing such as registering, updating, adding, and deleting data in the business partner master 106a, the management item master 106b, the property master 106c, and the ownership ratio master 106d in response to, for example, an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.
[0050] The screen display control unit 102e controls the display and input of various screens (eg, a master maintenance screen, a variable billing registration screen, a billing data confirmation screen, an invoice issuance screen, etc.) displayed on the monitor 114.
[0051] [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 3 to 21. Figures 10 to 21 are diagrams for explaining specific examples of the processing performed by the control unit 102 of the invoice processing device 100 in this embodiment.
[0052] [3-1. Overall processing] Fig. 10 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. Fig. 11 is a diagram showing a display example of a variable invoice registration screen. Fig. 12 is a diagram showing a display example of a invoice data registration screen.
[0053] In Fig. 10, the billing registration unit 102a executes a variable billing registration process (step S1). In the variable billing registration process, billing detail data is created. Specifically, in the variable billing registration process, the billing registration unit 102a inputs billing detail data including the billing sequence, billing destination, management item, property, ownership ratio code, applicable month, base amount, consumption tax, tax-inclusive amount, billing group code, and billing identification code that defines the billing unit, in response to, for example, an operator's operation on the variable billing registration screen displayed on the monitor 114, and registers the data in the storage unit 106. The billing detail data may be imported from an external source.
[0054] The billing data determination unit 102b executes the billing data determination process (step S2). The billing data determination process is a process for determining the unit for issuing the invoice, and when there are multiple business partners in the ownership ratio, billing detail apportionment data is created, and when an invoice is issued that spans the owner registration date, billing detail data for the period when the owner was not registered is updated.
[0055] Specifically, in the billing data confirmation process, the billing data confirmation unit 102b, for example, in response to an operator's operation on the billing data confirmation screen displayed on the monitor 114, refers to the supplier master 106a for the billing detail data registered in the memory unit 106 at the time of billing confirmation (for example, the bill closing date), and if there is a mixture of details for the month before the registration date of the supplier in the ownership ratio master 106d linked to the ownership ratio code with the same billing identification code and details for the month after the registration date, updates the details to a billing identification code other than the same billing identification code and confirms them.
[0056] In addition, when the billing detail data registered in the memory unit 106 is finalized, if there are multiple business partners in the ownership ratio master 106d linked to the ownership ratio code for the billing detail data, the billing data finalization unit 102b may divide the details for each business partner, create billing detail apportionment data in which the amount is apportioned according to the ownership ratio of the business partner in the ownership ratio master 106d, and register the data in the memory unit 106.
[0057] In addition, the billing data determination unit 102b may further refer to the customer master 106a for the billing detail allocation data, and if there is a detail for the relevant month prior to the registration date of the customer in the ownership ratio master 106d linked to the ownership ratio code with the same billing identification code, update that detail to a billing identification code other than the same billing identification code.
[0058] The invoice issuing unit 102c executes the invoice issuing process (step S3). Specifically, in the invoice issuing process, the invoice issuing unit 102c issues an invoice for each invoice identification code based on the confirmed invoice detail data in response to, for example, an operator's operation on the invoice issuing screen displayed on the monitor 114, and at that time, refers to the supplier master 106a to obtain the supplier's registration number and registration date in the ownership ratio master 106d linked to the ownership ratio code, and if the registration date is less than or equal to the relevant month, prints the supplier's registration number (qualified invoice), and if the registration date is greater than or equal to the relevant month, does not print the supplier's registration number (invoice).
[0059] In addition, when issuing an invoice, the invoice issuing unit 103c may issue the invoice based on the invoice detail allocation data if the invoice detail allocation data is available, and may issue the invoice based on the invoice detail data otherwise.
[0060] [3-2. Sample data] 13 to 21 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 21. In the following, an example will be described in which the example master configurations shown in the above-mentioned Figs. 6 to 9 are used.
[0061] (S1: Variable billing registration process) The variable billing registration process will be described with reference to Figures 13 and 14. The billing registration unit 102a inputs billing detail data including the billing sequence, billing destination, management item, property, ownership ratio code, applicable month, base amount, consumption tax, tax-inclusive amount, billing group code, and billing identification code that specifies the billing unit, in response to, for example, an operator's operation on the variable billing registration screen displayed on the monitor 114, and registers the data in the storage unit 106.
[0062] 13A is a diagram showing an example of billing detail data. The billing detail data includes the following fields: billing sequence, billing destination code, management item code, property code, ownership ratio code, applicable month, base amount, consumption tax, tax-inclusive amount, billing group code, and billing identification code.
[0063] Invoice detail data with the same invoice identification code is compiled into one invoice. The invoice identification code is automatically updated when items that summarize the invoice, such as the invoice destination code, property code, invoice group code, etc., are updated.
[0064] In the example shown in the same figure, for example, the billing identification code for lines 4 to 6 is "B001", and line 4 has the billing SEQ "103", billing destination code "T00001: Tenant A", management item code "K01: Office rent", property code "1001", ownership ratio code "01", applicable month "2023 / 11", base amount "100,000", consumption tax "10,000", amount including tax "110,000", and billing identification code "B001". The fifth line is billing sequence number "104", billing destination code "T00001: Tenant A", management item code "K02: Maintenance fee", property code "1001", ownership ratio code "01", applicable month "2023 / 11", base amount "100,000", consumption tax "10,000", tax-inclusive amount "110,000", billing identification code "B001". The sixth line is billing sequence number "105", billing destination code "T00001: Tenant A", management item code "K03: Electricity", property code "1001", ownership ratio code "01", applicable month "2023 / 10", base amount "50,000", consumption tax "5,000", tax-inclusive amount "55,000", billing identification code "B001". If the billing identification code is "B001", the electricity bill alone is a transaction from a period when Owner B was not registered.
[0065] For example, lines 13 to 15 have a billing identification code of "E001", and line 13 has the billing sequence "112", billing destination code "T00001: Tenant A", management item code "K01: Office rent", property code "1001", ownership ratio code "03", applicable month "2023 / 12", base amount "100,000", consumption tax "10,000", amount including tax "110,000", and billing identification code "E001". The 14th line is billing SEQ "113", billing destination code "T00001: Tenant A", management item code "K02: Common area fee", property code "1001", ownership ratio code "03", applicable month "2023 / 12", base amount "100,000", consumption tax "10,000", tax-inclusive amount "110,000", billing identification code "E001". The 15th line is billing SEQ "114", billing destination code "T00001: Tenant A", management item code "K03: Electricity", property code "1001", ownership ratio code "03", applicable month "2023 / 11", base amount "50,000", consumption tax "5,000", tax-inclusive amount "55,000", billing identification code "E001". If the billing identification code is "E001", all of Owner B's transactions are for the registered business period, while Owner C's transactions are for the unregistered period only for electricity bills.
[0066] FIG. 13(B) is a diagram for explaining the format of the invoice for each invoice identification code of the invoice detail data in FIG. 13(A). Invoice identification code "A001" is issued on behalf of Owner B, with all details being from the registered business period. Invoice identification code "B001" is issued on behalf of Owner B, with only the electricity bill being from the unregistered business period. Invoice identification code "C001" is issued on behalf of Owner B, with all details being from the unregistered business period. Invoice identification code "D001" is an invoice for the company, with all details being from the registered business period. Invoice identification code "E001" is issued on behalf of Owners B and C, with only Owner C's electricity bill being from the unregistered business period.
[0067] (S2: Billing data confirmation process) A specific example of the billing data confirmation process will be described with reference to Figures 14 and 15. In the billing data confirmation process, the billing detail data is updated and the billing detail apportionment data is created and updated.
[0068] (Creating billing details allocation data) When the billing detail data registered in the memory unit 106 is finalized (when the billing data is finalized, for example, on the billing closing date), if there are multiple business partners in the ownership ratio master 106d linked to the ownership ratio code for the billing detail data, the billing data finalization unit 102b divides the details for each business partner, creates billing detail allocation data in which the amount is prorated according to the ownership ratio of the business partner in the ownership ratio master 106d, and registers the data in the memory unit 106.
[0069] If there are multiple owners (multiple constituent business partners in the ownership ratio) when the invoice data is finalized, the invoice detail allocation data is created based on the invoice detail data. Specifically, if there are multiple constituent business partner codes (owner codes) in the ownership ratio master 106d linked to the ownership ratio code in the invoice detail data, the invoice detail data is divided for each constituent business partner code, and the amount is allocated according to the ownership ratio of the corresponding constituent business partner code in the ownership ratio master 106d.
[0070] FIG. 14 is a diagram showing an example of billing detail allocation data created in the case of the billing detail data of FIG. 13(A). The billing detail allocation data includes the following items: billing sequence, owner code, base amount, consumption tax, tax-inclusive amount, billing group code, and billing identification code. In the case of the billing detail data of FIG. 13(A), when the ownership ratio code is "03", there are multiple constituent customer codes (T00002, T00003) in the ownership ratio master 106d of FIG. 9, so billing detail allocation data is created. In the ownership ratio master 106d of FIG. 9, for the property code "1001" and ownership ratio code "03", the constituent customer code is "T00002", the ownership ratio is "60", the constituent customer code is "T00003", and the ratio is "40".
[0071] In the example shown in the figure, for example, for billing SEQ "112," the first line contains billing SEQ "112," owner code "T00002: Owner B," amount "60,000 (= 100,000 x 60 / (60 + 40))," consumption tax "6,000," amount including tax "66,000," and billing identification code "E001." The second line contains billing SEQ "112," owner code "T00003: Owner C," amount "40,000 (= 100,000 x 40 / (40 + 60))," consumption tax "4,000," amount including tax "44,000," and billing identification code "E001."
[0072] Also, for the billing sequence "114," the fifth line contains the billing sequence "114," owner code "T00002: Owner B," amount "30,000 (= 500,000 x 60 / (60+40))," consumption tax "3,000," amount including tax "33,000," and billing identification code "E001." The sixth line contains the billing sequence "114," owner code "T00003: Owner C," amount "20,000 (= 100,000 x 40 / (40+60))," consumption tax "2,000," amount including tax "22,000," and billing identification code "E001."
[0073] (Update the invoice group code and invoice identification code for invoice detail data and invoice detail allocation data) When billing data is finalized (e.g., on the invoice closing date), the billing data finalization unit 102b refers to the supplier master 106a for the billing detail data registered in the memory unit 106, and if there is a mixture of details for the month before the registration date of the supplier in the ownership ratio master 106d linked to the ownership ratio code with the same billing identification code and details for the month after the registration date, the billing data finalization unit 102b updates the details to a billing identification code other than the same billing identification code and finalizes them.
[0074] With reference to Fig. 15, this is a diagram for explaining a case where billing detail data is updated when billing data is finalized. Fig. 15 shows the billing detail data of Fig. 13(A) after updating. When billing data is finalized, the following billing detail data is updated.
[0075] The conditions for updating billing details data are as follows: (1) There is no billing detail allocation data (billing detail allocation data will be processed separately) (2) For the same invoice identification code (same invoice), there are multiple corresponding months that cross the registration date of the constituent business partners (owners) linked to the ownership ratio code (MIN corresponding month < registration date ≦ MAX corresponding month) (3) Details of the period when the constituent trading partner (owner) linked to the ownership ratio code was an unregistered business entity with the same invoice identification code (same invoice) (applicable month < registration date)
[0076] In the example shown in Figure 15, the details of billing identification code "B001" and management item code "K03: Electricity" for billing SEQ "105" on the 6th line meet the update conditions (of the three details for billing identification code "B001", billing SEQ "105" has Owner B's registration date "2023 / 11 / 01" > the corresponding month of management item code "K03: Electricity" "2023 / 10"), so the invoice group code is updated to "I" and the billing identification code is updated to "B002" at the same time. As a result, the details on the 4th and 5th lines and the details of billing identification code "B001" and management item code "K03: Electricity" for billing SEQ "105" on the 6th line become separate invoices.
[0077] In addition, the billing data determination unit 102b further refers to the customer master 106a for the billing detail allocation data, and if there is a detail for the corresponding month prior to the registration date of the customer in the ownership ratio master 106d linked to the ownership ratio code with the same billing identification code, the billing data determination unit 102b updates the detail to a billing identification code other than the same billing identification code.
[0078] With reference to Fig. 16, this is a diagram for explaining a case where billing detail allocation data is updated when billing data is finalized. Fig. 16 shows the billing detail allocation data after updating in Fig. 14. When billing data is finalized, the following billing detail allocation data is updated.
[0079] The conditions for updating billing details are as follows: (1) For the same invoice identification code (same invoice), there are multiple months that overlap the registration dates of constituent business partners (owners) linked to the ownership ratio code (MIN applicable month < registration date ≦ MAX applicable month) (2) Details of the period when the constituent trading partner (owner) linked to the ownership ratio code was an unregistered business entity with the same invoice identification code (same invoice) (applicable month < registration date)
[0080] In the example shown in Figure 16, the billing identification code "E001" of the billing SEQ "114" on the 6th line and the details of the management item code "K03: Electricity bill" of the owner code "T00003: Owner C" meet the update conditions (Owner C of billing SEQ "114" has Owner C's registration date "2023 / 12 / 01" > the corresponding month of the management item code "K03: Electricity bill" "2023 / 11"), so the invoice group code is updated to "I" and the billing identification code is updated to "E002" at the same time.
[0081] (S3: Invoice issuing process) A specific example of the invoice issuing process will be described with reference to Fig. 17 to Fig. 21. Fig. 17 to Fig. 21 are diagrams showing an example of issuing an invoice based on the invoice detail data in Fig. 15 and the invoice detail apportionment data in Fig. 16.
[0082] The invoice issuing unit 102c issues an invoice for each invoice identification code based on the confirmed invoice detail data in response to, for example, an operator's operation on the invoice issuance screen displayed on the monitor 114, and at that time, refers to the supplier master 106a to obtain the supplier's registration number and registration date in the ownership ratio master 106d linked to the ownership ratio code, and if the registration date is less than or equal to the relevant month, the supplier's registration number is printed (qualified invoice), and if the registration date is greater than or equal to the relevant month, the supplier's registration number is not printed (invoice). Also, when issuing an invoice, if there is invoice detail apportionment data, the invoice issuing unit 103c issues an invoice based on the invoice detail apportionment data, and otherwise issues an invoice based on the invoice detail data.
[0083] (1) Issuer of invoice When billing detail apportionment data is available, an invoice is output based on the billing detail apportionment data, and when billing detail apportionment data is not available, an invoice is issued based on the billing detail data. (2) Printing of registration number In the case of a single owner, the constituent customer code is obtained from the equity ratio master 106d using the equity ratio code of the billing detail data as a key, and the registration number and registration date are obtained from the customer master 106a using the obtained constituent customer code as a key. If the registration date is less than or equal to the relevant month, the obtained registration number is printed, and if the registration date is greater than or equal to the relevant month, the obtained registration number is not printed.
[0084] In the case of multiple owners, the registration number and registration date are obtained from the supplier master 106a using the owner code (supplier code) of the billing detail allocation data as a key, and if the registration date is less than or equal to the relevant month, the registration number is printed, and if the registration date is greater than or equal to the relevant month, the obtained registration number is not printed.
[0085] FIG. 17 shows an example of an invoice in the case of (1) billing identification code "A001", proxy issuance by Owner B (registration date 2023 / 11 / 1): all details are for registered businesses. The invoice has a header section and a detail section. The header section lists the title (invoice), destination (tenant), biller (owner or company: if the registration date is less than or equal to the relevant month, the acquired registration number is printed), and total billed amount. The detail section lists each expense item, the relevant month, the amount excluding tax, the total amount excluding tax, and the total for each tax rate (tax rate, consumption tax amount, total amount including tax). In the example shown in FIG. 17, the expense items are "office rent", "common expenses", and "electricity fee", and Owner B's registration number is printed.
[0086] Figure 18 shows an example of an invoice for (2) billing identification codes "B001" and "B002", issued on behalf of Owner B (registration date 1 November 2023): electricity charges only are unregistered business period details. Figure 18(A) shows an invoice with billing identification code "B001", with the expense items "office rent" and "common area fees", and Owner B's registration number is printed on it. Figure 18(B) shows an invoice with billing identification code "B002", with the expense item "electricity charges", and Owner B's registration number is not printed on it.
[0087] Figure 19 shows an example of an invoice for (3) billing identification code "C001", issued on behalf of Owner B (registration date 2023 / 11 / 1): all unregistered business period details. In the example shown in Figure 19, the expense items are "office rent", "common area fee", and "electricity fee", and Owner B's registration number is not printed.
[0088] Figure 20 shows an example of an invoice for (4) billing identification code "D001", invoice for the company (registration date 1 October 2023): all registered business period details. In the example shown in Figure 20, the expense items are "office rent", "common area fee", and "electricity fee", and the registration number of PM Real Estate (the company) is printed.
[0089] Figure 21 shows an example of an invoice for (4) billing identification codes "E001" and "E002", issued on behalf of Owner B (registered date 2023 / 11 / 1) and Owner C (registered date 2023 / 12 / 1): Owner C's electricity bill is the only one with details for an unregistered business. In this example, there is billing detail allocation data, so the invoice is output based on the billing detail allocation data.
[0090] Figure 21(A) shows an invoice for Owner B with billing identification code "E001", with the expense items being "office rent", "common charges", and "electricity", and Owner B's registration number is printed on it. Figure 21(B) shows an invoice for Owner C with billing identification code "E001", with the expense items being "office rent" and "common charges", and Owner C's registration number is printed on it. Figure 21(C) shows an invoice for Owner C with billing identification code "E002", with the expense item being "electricity", and Owner C's registration number is not printed on it.
[0091] As described above, according to this embodiment, there are provided a supplier master 106a which associates and registers supplier, registration number of qualified invoice issuer, and registration date, an ownership ratio master 106d which associates and registers supplier including property, ownership ratio code, and owner, and ownership ratio, a billing registration unit 102a which inputs billing detail data including billing destination, management item, property, ownership ratio code, applicable month, base price, consumption tax, tax-inclusive amount, and billing identification code that specifies the invoice unit, and registers the input data in the storage unit 106, and a billing registration unit 102b which, when billing is finalized for the billing detail data registered in the storage unit 106, refers to the supplier master 106a and registers the supplier with the same billing identification code for the applicable month prior to the registration date of the supplier in the ownership ratio master 106d linked to the ownership ratio code. The system is equipped with a billing data confirmation unit 102b which, if details exist, updates and confirms the details to a billing identification code different from the same billing identification code, and an invoice issuing unit 102c which issues an invoice by billing identification code based on the confirmed billing detail data, and at that time refers to the business partner master 106a to obtain the business partner registration number and registration date in the ownership ratio master 106d linked to the ownership ratio code, and if the registration date is less than or equal to the relevant month, prints the business partner registration number, but if the registration date is greater than the relevant month, does not print the business partner registration number.This makes it possible for the operator issuing the invoice at the management company to issue invoices that comply with the invoice system without being aware of the owner's registration date.
[0092] [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.
[0093] 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.
[0094] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.
[0095] 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.
[0096] 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.
[0097] 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.
[0098] 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.
[0099] 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.
[0100] 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.
[0101] 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.
[0102] 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.
[0103] 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.
[0104] 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.
[0105] 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]
[0106] 100 Invoice processing device 102 Control section 102a Claims Registration Department 102b Billing data confirmation section 102c Billing Department 102d Master Maintenance Department 102e Screen display control unit 104 Communication interface section 106 Storage section 106a Customer Master 106b Management item master 106c Property Master 106d Ownership ratio master 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 allows a management company to issue a bill on behalf of an owner, The control unit is A customer master record that associates customer, registration number of qualified invoice issuer, and registration date, The ownership ratio master is a database that associates and registers properties, ownership ratio codes, business partners including owners, and ownership ratios. The storage area storing the a billing registration means for inputting billing details data including a billing destination, a management item, an item, an ownership ratio code, a corresponding month, a basic amount, a consumption tax, an amount including tax, and a billing identification code that specifies a billing unit, and registering the data in the storage area; a billing determination means for, when billing is determined for the billing detail data registered in the storage area, referring to the business partner master, if there is a mixture of details for a month before the registration date of a business partner in the ownership ratio master linked to an ownership ratio code with the same billing identification code and details for a month after the registration date, updating the details to a billing identification code different from the same billing identification code and determining the details; an invoice issuing means for issuing an invoice for each invoice identification code based on the confirmed invoice detail data, and at that time, acquiring the registration number and registration date of the supplier in the ownership ratio master linked to the ownership ratio code by referencing the supplier master, and printing the registration number of the supplier if the registration date is less than or equal to the relevant month, and not printing the registration number of the supplier if the registration date is greater than or equal to the relevant month; An invoice processing device comprising:
2. The invoice processing device of claim 1, characterized in that, when the invoice detail data registered in the memory area is confirmed, if there are multiple business partners in the ownership ratio master linked to the ownership ratio code for the invoice detail data, the invoice confirmation means divides the details for each business partner, creates invoice detail apportionment data in which the amount is apportioned according to the ownership ratio of the business partner in the ownership ratio master, and registers the data in the memory area.
3. The invoice processing device as described in claim 2, characterized in that the invoice confirmation means further refers to the customer master for the invoice detail allocation data, and if there is a detail for the corresponding month prior to the registration date of the customer in the ownership ratio master linked to the ownership ratio code with the same invoice identification code, updates the detail to a different invoice identification code from the same invoice identification code.
4. The invoice processing device according to claim 2 or 3, characterized in that, when issuing an invoice, the invoice issuing means issues an invoice based on invoice detail allocation data if invoice detail allocation data is available, and otherwise issues an invoice based on invoice detail data.
5. An invoice processing method executed by an information processing device having a control unit, The control unit is A customer master record that associates customer, registration number of qualified invoice issuer, and registration date, The ownership ratio master is a database that associates and registers properties, ownership ratio codes, business partners including owners, and ownership ratios. The storage area storing the Executed in the control unit, a billing registration step of inputting billing detail data including a billing destination, a management item, an object, an ownership ratio code, a corresponding month, a basic amount, a consumption tax, an amount including tax, and a billing identification code that specifies a billing unit, and registering the input data in the storage area; a billing confirmation step of, when billing of the billing detail data registered in the storage area is confirmed, referring to the business partner master, if there is a mixture of details for a month before the registration date of the business partner in the ownership ratio master linked to the ownership ratio code with the same billing identification code and details for a month after the registration date, updating the details to a billing identification code different from the same billing identification code and confirming them; an invoice issuing process for issuing an invoice for each invoice identification code based on the confirmed invoice detail data, and at that time, acquiring the registration number and registration date of the supplier in the ownership ratio master linked to the ownership ratio code by referring to the supplier master, and if the registration date is less than or equal to the relevant month, printing the registration number of the supplier, and if the registration date is greater than or equal to the relevant month, not printing the registration number of the supplier; 13. A method for processing an invoice comprising:
6. An invoice processing program to be executed by an information processing device having a control unit, The control unit is A customer master record that associates customer, registration number of qualified invoice issuer, and registration date, The ownership ratio master is a database that associates and registers properties, ownership ratio codes, business partners including owners, and ownership ratios. The storage area storing the In the control unit, a billing registration step of inputting billing detail data including a billing destination, a management item, an object, an ownership ratio code, a corresponding month, a basic amount, a consumption tax, an amount including tax, and a billing identification code that specifies a billing unit, and registering the input data in the storage area; a billing confirmation step of, when billing of the billing detail data registered in the storage area is confirmed, referring to the business partner master, if there is a mixture of details for a month before the registration date of the business partner in the ownership ratio master linked to the ownership ratio code with the same billing identification code and details for a month after the registration date, updating the details to a billing identification code different from the same billing identification code and confirming them; an invoice issuing process for issuing an invoice for each invoice identification code based on the confirmed invoice detail data, and at that time, acquiring the registration number and registration date of the supplier in the ownership ratio master linked to the ownership ratio code by referring to the supplier master, and if the registration date is less than or equal to the relevant month, printing the registration number of the supplier, and if the registration date is greater than or equal to the relevant month, not printing the registration number of the supplier; Invoice processing program to execute.
Citation Information
Patent Citations
Voucher determination device, accounting processing device, voucher determination program, voucher determination system, and voucher determination method
JP2021072110A
Asset management system, asset management method, and asset management program
JP2023042374A
Information processor, program and method
JP2023038949A