JP2021179940A - Business support device and business support method - Google Patents

Abstract

To appropriately reduce the time and labor of business related to accommodation tax and improve the efficiency and accuracy of the business.SOLUTION: A business support device 100 includes: a storage device 101 that retains sales data which a sales agent or site controller manages with respect to an accommodation facility obtained in advance from the sales agent or site controller used by the accommodation facility; and an arithmetic device 104 that calculates an accommodation tax amount by multiplying an accommodation charge shown by the sales data about the accommodation facility by a tax rate, acquires accommodation tax declaration data from a terminal of the accommodation facility, collates an accommodation tax amount shown in the declaration data with the calculated accommodation tax amount, determines discrepancy between the accommodation tax amount derived from the declaration data and the accommodation tax amount derived from the sales data, and when the discrepancy exceeds a standard, notifies the terminal or the like of the accommodation facility of an alert.SELECTED DRAWING: Figure 1

Description

The present invention relates to a business support device and a business support method, and specifically, relates to a technique for appropriately suppressing the labor of business related to accommodation tax and improving the efficiency and accuracy of the business.

At accommodation facilities such as hotels and inns, accommodation tax is basically collected from the users. Accommodation tax is a so-called non-statutory purpose tax, and is levied on accommodation charges at a fixed tax rate, which can be a source of revenue for tourism promotion in the area.

As a technique for handling taxation processing associated with the use of accommodation facilities, for example, even if the billing content includes both accommodation users and users for purposes other than accommodation, the same usage subject is applied. By doing so, the usage amount entered for each usage item is memorized for the purpose of reducing the number of items of the usage item of the invoice transaction of the room master, and the total of the usage amount, the consumption tax and the special local consumption tax. In the front accounting machine that calculates the amount of money and prints and issues the invoice, a user number storage means for storing the number of users input for each user subject is provided and stored in the user number storage means when the invoice is issued. A front accounting machine (see Patent Document 1), which is characterized by providing a user number data output means for outputting the number of users to the printing means, has been proposed.

In addition, the purpose is to register the format of the charge settlement form issued for group users in advance, and to make it possible to calculate the taxable amount of various usage charges and special local consumption tax according to the registered format thereafter. In the charge settlement system at the accommodation facility that issues the charge settlement report for group users, the charge settlement form issued to the group users is as follows: a group-wide charge settlement report and a room-based charge settlement report. , Register in advance whether to use the charge settlement form for each individual, and at the time of charge settlement, calculate the taxable amount of various taxes including special local consumption tax according to the number of users in the format of the registered charge settlement form and use it. A fee settlement system (see Patent Document 2) in an accommodation facility, which is characterized by issuing a fee settlement report in the registration format in which the fee and the calculated taxable amount are described, has also been proposed.

Japanese Unexamined Patent Publication No. 5-334562 Japanese Unexamined Patent Publication No. 2000-90178

In addition to selling guest rooms on their own website, each accommodation facility outsources sales to so-called OTA to expand sales opportunities widely. The accommodation facility is expected to efficiently sell its own guest room inventory through various sales channels.

Further, as described above, when selling guest rooms through various sales channels, there are many cases where a site controller that collectively manages each sales channel used is used for each accommodation facility. By using such a site controller, troubles such as double booking between OTAs can be avoided, and various data such as guest room inventory, charges, and reservations can be centrally managed.

In this way, accommodation facilities use various systems to streamline the sales and management of guest rooms, but due to the characteristics of the business, the efficiency of the business related to accommodation tax has not been appropriately improved. In other words, depending on the attributes of the guest rooms to be sold, the time of sale, the contents of the package, or the actual usage pattern (eg, whether or not the accompanying child uses a bed, etc.), the accommodation fee and meal fee are likely to change into various patterns. There is an existence.

In such a case, it was necessary for the person in charge to check the accommodation charges and meal charges of each user, and to manually register the accommodation tax and perform cash register operations. In the busy season when many users are busy, the burden on the person in charge becomes an issue just to process the work, which may lead to a decrease in overall work efficiency.

In addition, the above-mentioned situation may lead to mistakes by the person in charge, or in some cases, it may lead to tax calculation or registration that does not reflect the actual situation due to the time and effort involved. If this happens, it may result in inaccurate declarations and the consequent loss of trust in the industry as a whole.

Therefore, an object of the present invention is to provide a technique for appropriately suppressing the labor of business related to accommodation tax and improving the efficiency and accuracy of the business.

The business support device of the present invention for solving the above problems retains sales data managed by the sales agent or the site controller regarding the accommodation facility, which is obtained in advance from the sales agent or the site controller used by the accommodation facility. Processing to calculate the accommodation tax amount by multiplying the accommodation fee indicated by the sales data related to the accommodation facility and the accommodation facility by a predetermined tax rate, and to acquire the accommodation tax declaration data at the accommodation facility from the terminal of the accommodation facility. Then, the accommodation tax amount indicated by the declared data is collated with the calculated accommodation tax amount, and the deviation between the accommodation tax amount derived from the declared data and the accommodation tax amount derived from the sales data is determined, and the deviation is predetermined. When the standard is exceeded, the accommodation facility terminal or a predetermined notification destination terminal is characterized by including a computing device that executes a process of notifying a predetermined alert.

Further, in the business support device of the present invention, the arithmetic unit acquires the sales data related to the accommodation facility from the sales agent or the system of the site controller, and executes a process of storing the sales data in the storage device. There may be.

Further, in the business support device of the present invention, the arithmetic device determines the sales ratio between the direct sales by the accommodation facility and the agency sales by the sales agent in the area where the accommodation facility is located. , Estimate based on the average of accommodation facilities of the same type and class, calculate the total accommodation fee at the accommodation facility based on the sales data and the estimated sales ratio, and multiply the total accommodation fee by the tax rate to determine the accommodation tax amount. May be calculated.

Further, in the business support device of the present invention, the arithmetic unit is treated as sales data by multiplying the reservation data of the accommodation facility indicated by the sales data obtained in advance from the site controller by a predetermined cancellation rate. It may be a thing.

Further, in the business support method of the present invention, the information processing apparatus obtains in advance from a sales agent or a site controller used by the accommodation facility, and the sales agent or the site controller manages the sales data regarding the accommodation facility. The process of calculating the accommodation tax amount by multiplying the accommodation fee indicated by the sales data regarding the accommodation facility by a predetermined tax rate, and acquiring the accommodation tax declaration data at the accommodation facility from the terminal of the accommodation facility. The process of collating the accommodation tax amount indicated by the declared data with the calculated accommodation tax amount and determining the deviation between the accommodation tax amount derived from the declared data and the accommodation tax amount derived from the sales data, and the deviation is the predetermined standard. If the amount exceeds the limit, a process of notifying a predetermined alert to the terminal of the accommodation facility or the terminal of the predetermined notification destination is executed.

Further, in the business support method of the present invention, the information processing device acquires the sales data related to the accommodation facility from the sales agent or the system of the site controller, and executes a process of storing the sales data in the storage device. May be good.

Further, in the business support method of the present invention, the information processing apparatus determines the sales ratio between the direct sales by the accommodation facility and the agency sales by the sales agent in the area where the accommodation facility is located. Estimate based on the average of accommodation facilities of the same type and class, calculate the total accommodation fee at the accommodation facility based on the sales data and the estimated sales ratio, and multiply the total accommodation fee by the tax rate. The tax amount may be calculated.

Further, in the business support method of the present invention, the information processing apparatus multiplies the reservation data of the accommodation facility indicated by the sales data obtained in advance from the site controller by a predetermined cancellation rate to obtain sales data. You may handle it.

According to the present invention, it is possible to appropriately suppress the labor of business related to accommodation tax and improve the efficiency and accuracy of the business.

It is a network configuration diagram including the business support apparatus of this embodiment. It is a figure which shows the hardware configuration example of the business support apparatus in this embodiment. It is a figure which shows the hardware configuration example of the net agent server in this embodiment. It is a figure which shows the hardware configuration example of the accommodation facility terminal in this embodiment. It is a figure which shows the hardware configuration example of the site controller server in this embodiment. It is a figure which shows the data structure example of the sales data DB of this embodiment. It is a figure which shows the data structure example of the declaration data DB of this embodiment. It is a figure which shows the data structure example of the sales ratio DB of this embodiment. It is a figure which shows the flow example of the business support method in this embodiment. It is a figure which shows the screen example in this embodiment.

***overall structure***
Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. FIG. 1 is a network configuration diagram including the business support device 100 of the present embodiment. The business support device 100 shown in FIG. 1 is a computer device that appropriately suppresses the labor of business related to accommodation tax and improves the efficiency and accuracy of the business.

More specifically, the business support device 100 can be assumed to be, for example, a server device operated by a predetermined business operator affiliated with various accommodation facilities or various public institutions such as local governments, but is not limited thereto. For example, it may be a device operated by an accommodation facility operator, an OTA operator, or a site controller operator.

On the other hand, the target for which the business support device 100 of the present embodiment outputs and presents the information as the processing result is the accommodation company (terminal, that is, the accommodation facility) contracted or registered to enjoy the service provision by the business support device 100. The terminal 200), or the system of the above-mentioned public institution specified in advance as the notification destination of the information, or the terminal of the operator of the OTA or the site controller. Of course, the present invention is not limited to this, and it is possible to assume terminals and systems of various other businesses as information output targets.

Further, the business support device 100 is communicably connected to the OTA net agent server 300 and the site controller server 400 being used by the accommodation facility in order to obtain sales data generated for the users of each accommodation facility. ..

Therefore, the business support device 100 communicates with the accommodation facility terminal 200 provided by each accommodation company, the OTA net agent server 300, the site controller site controller server 400, the local government system 500, and the like via an appropriate network 10 such as the Internet. It is connected as possible.

In addition, the above-mentioned accommodation company contracts with multiple OTAs, that is, net agents, in order to sell the guest rooms of the accommodation facility (including the sales concept of the accommodation plan), and for these net agents, the guest rooms of the accommodation facility. It is assumed that the sale is outsourced. However, it does not exclude the form in which the lodging company sells guest rooms on its own site.

Further, it is assumed that the lodging company has a contract with the site controller in order to centrally and collectively manage the reservation management functions and the like provided by each of the above-mentioned OTA et al. Net Agent Servers 300.

On the other hand, each business operator that operates the net agent server 300 is a business operator that provides services such as attracting customers, selling guest rooms, and sending customers to the accommodation facilities of the contracted party through the sales site opened on the net. It becomes. This business operator observes the guest room sales record, that is, sales data, for each accommodation facility that is a customer of the service, for example, at regular time intervals, and manages this in the sales data DB 325 (described later).

Such a net agent server 300 receives a reservation request for an accommodation facility (or its packaged product, etc.) from a terminal of a user who is a guest room sales destination, and executes reservation processing and inventory management processing associated with the accommodation facility. In addition, it manages information such as the above-mentioned payment amount, nationality of the person who made the reservation, travel type (eg, attributes and number of accompanying persons such as family or solo travel), cancellation status, cancellation time, etc. regarding the subject of the reservation request. ing.

In addition, each business operator that operates the above-mentioned site controller server 400 provides the accommodation facility of the contracted party with the management functions of the above-mentioned net agent server 300 of each OTA under the contract with the accommodation facility in an integrated manner. Become a business operator. This business operator acquires guest room sales results, that is, sales data at each OTA from the net agent server 300, for example, at regular intervals for each accommodation facility that is a customer of the service, and manages this in the sales data DB 425 (described later). doing.

Further, the business support device 100 of the present embodiment can be used as information on sales performance of each accommodation company's guest room product (that is, accommodation facility) on the WEB site of NetAgent contracted by many accommodation companies. Information such as guest room category, plan content, sales time, sales amount (posted amount on the WEB site of the net agent), various attributes of the user, etc. is acquired from the net agent server 300 at regular intervals.

Similarly, the business support device 100 has management information from the site controller server 400 to the net agent server 300 centrally managed by the site controller server 400, that is, sales performance of guest room products (that is, accommodation facilities) of each accommodation company. As information, information such as the guest room category, plan contents, sales time, sales amount (posted amount on the WEB site of NetAgent), various attributes of the user, etc. is acquired at regular intervals.

Further, the business support device 100 verifies the appropriateness of the accommodation tax declaration data obtained from the accommodation facility terminal 200 by the business support method of the present invention, and notifies the accommodation facility terminal 200 of the result, while such verification. Based on the instruction of the accommodation company who is the operator of the accommodation facility (received from the accommodation facility terminal 200), the declaration data optimized (on the accommodation facility side) is transmitted to the local government system 500 and the declaration process is executed. It is possible to do.

The local government system 500 accepts such accommodation tax filing processing. The local government system 500 is an existing system for each local government to receive and process tax returns such as accommodation tax, although details of its hardware configuration and the like are not shown.

Further, the accommodation facility terminal 200 is a terminal operated by an accommodation company that operates the accommodation facility. The accommodation facility terminal 200 is a terminal that receives information on the content of the accommodation tax declaration from the business support device 100 and outputs the information to a display or the like. Specifically, a general information processing terminal capable of network communication such as a PC, a smartphone, or a tablet terminal is assumed.

*** Hardware configuration of each device ***
The hardware configuration of the business support device 100 of this embodiment is as shown in FIG. The business support device 100 includes at least a storage device 101, a memory 103, an arithmetic unit 104, and a communication device 105.

Of these, the storage device 101 is composed of an appropriate non-volatile storage element such as an SSD (Solid State Drive) or a hard disk drive. Further, the memory 103 is composed of a volatile storage element such as a RAM.

Further, the arithmetic unit 104 is a CPU that executes the program 102 held in the storage device 101 by reading it into the memory 103, etc., to perform integrated control of the apparatus itself, and to perform various determinations, arithmetic operations, and control processes.

Further, the communication device 105 is a network interface card that connects to an appropriate network 10 such as the Internet and is responsible for communication processing with other devices such as an accommodation facility terminal 200, a net agent server 300, a site controller server 400, and a local government system 500. Can be assumed.

In addition to the above configuration, the business support device 100 also includes an input device such as a keyboard and a mouse that accepts key input and voice input from the user, and an output device such as a display that displays processing data in the arithmetic device 104. May be.

The storage device 101 includes at least the filing business program 111 in the program 102 for implementing the functions required as the business support device of the present embodiment. This filing business program 111 will be described later. On the other hand, the filing business program 111 is a program in which the business support device 100 executes the accommodation tax filing process in accordance with the instructions of the accommodation company, which is the operator of the accommodation facility. However, this filing business program 111 is not essential.

Further, in addition to the above-mentioned program 102, the storage device 101 stores at least the sales data DB 125, the declaration data DB 126, and the sales ratio DB 127. Details of these sales data DB 125, declaration data DB 126, and sales ratio DB 127 will be described later.

On the other hand, as shown in FIG. 3, the net agent server 300 of the present embodiment includes at least a storage device 301, a memory 303, an arithmetic unit 304, and a communication device 305. Of these, the storage device 301 is composed of an appropriate non-volatile storage element such as an SSD (Solid State Drive) or a hard disk drive. Further, the memory 303 is composed of a volatile storage element such as a RAM.

Further, the arithmetic unit 304 is a CPU that executes the program 302 held in the storage device 301 by reading it into the memory 303, etc., to perform integrated control of the apparatus itself, and to perform various determinations, arithmetic operations, and control processes.

Further, the communication device 305 can be assumed to be a network interface card that is connected to an appropriate network 10 such as the Internet and is responsible for communication processing with other devices such as an accommodation facility terminal 200, a business support device 100, and a site controller server 400.

In addition to the above configuration, the net agent server 300 also includes an input device such as a keyboard and a mouse that accepts key input and voice input from the user, and an output device such as a display that displays processing data in the arithmetic unit 304. May be.

The storage device 301 stores at least the sales data DB 325 in addition to the program 302 for implementing the function required as the net agent server of the present embodiment. However, the details of the sales data DB 325 will be described later.

Further, as illustrated in FIG. 4, the accommodation facility terminal 200 of the present embodiment includes at least a storage device 401, a memory 403, an arithmetic unit 404, an input device 405, an output device 406, and a communication device 407.

Of these, the storage device 401 is composed of an appropriate non-volatile storage element such as an SSD (Solid State Drive) or a hard disk drive. Further, the memory 403 is composed of a volatile storage element such as a RAM.

Further, the arithmetic unit 404 is a CPU that executes the program 402 held in the storage device 401 by reading it into the memory 403, performs overall control of the apparatus itself, and performs various determinations, calculations, and control processes.

Further, the input device 405 is a device such as a keyboard, a mouse, and a microphone that accepts key input and voice input from a person in charge of an accommodation facility as a user. Further, the output device 406 is a device such as a display or a speaker that displays the processing data in the arithmetic unit 404.

Further, the communication device 407 can be assumed to be a network interface card that is connected to an appropriate network 10 such as the Internet and is responsible for communication processing with other devices such as the business support device 100, the net agent server 300, and the site controller server 400.

Further, in addition to the above-mentioned program 502, the storage device 501 stores at least the declaration data 225 regarding the accommodation tax. However, the details of this declaration data 225 will be described later.

Further, as shown in FIG. 5, the site controller server 400 of the present embodiment includes at least a storage device 401, a memory 403, an arithmetic unit 404, and a communication device 407.

Of these, the storage device 401 is composed of an appropriate non-volatile storage element such as an SSD (Solid State Drive) or a hard disk drive. Further, the memory 403 is composed of a volatile storage element such as a RAM.

Further, the arithmetic unit 404 is a CPU that executes the program 402 held in the storage device 401 by reading it into the memory 403, performs overall control of the apparatus itself, and performs various determinations, calculations, and control processes.

Further, the communication device 405 can be assumed to be a network interface card that is connected to an appropriate network 10 such as the Internet and is responsible for communication processing with other devices such as the business support device 100, the accommodation facility terminal 200, and the net agent server 300.

In addition to the above configuration, the site controller server 400 includes an input device such as a keyboard and a mouse that accepts key input and voice input from the user, and an output device such as a display that displays processing data in the arithmetic unit 404. May be.

*** Data structure example ***
Subsequently, the database used by the business support device 100 of the present embodiment will be described. FIG. 6 shows an example of the sales data DB 125 in this embodiment.

The sales data DB 125 is a database in which the guest room sales history of each accommodation facility sold by each channel, that is, the net agent server 300, is acquired and accumulated from each net agent server 300 and the site controller server 400.

The data structure is, for example, using the facility ID that uniquely identifies the accommodation facility as a key, the location area, type, channel (OTA identification information) of the accommodation facility, the date and time of sale, the number of nights, and the selling price. , Users, meals, bedding usage, and a collection of records associated with data such as the amount subject to accommodation tax.

In addition, the value in the above-mentioned meal column shall include the presence or absence of meals set in the guest room sales plan indicated by the sales record and the price thereof. If the value is "-", it means that the plan has not been set.

In addition, the value in the user column shall include information on the users who purchased the guest room sales plan indicated by the sales record and the total number thereof. In addition, the value in the bedding usage column shall include information on whether or not each user has used bedding.

The sales data DB 325 held by the net agent server 300 and the sales data DB 425 held by the site controller server 400 are the identification information of the net agent server 300 and the site controller server 400 among the records included in the above-mentioned sales data DB 125. It is a database consisting only of those to which is given.

Further, FIG. 7 shows an example of the declaration data DB 126 in the present embodiment. The declaration data DB 126 in the present embodiment is a database obtained by acquiring and accumulating the declaration data when each accommodation facility declares the accommodation tax from the accommodation facility terminal 200 of the accommodation facility.

The data structure is a collection of records associated with data such as a facility ID that uniquely identifies each accommodation facility, a taxpayer ID of the accommodation facility, a period covered by the declaration, a payment destination of the accommodation tax, and the declared amount. .. On the other hand, the declaration data 225 held by the accommodation facility terminal 200 is assigned the facility ID of the accommodation facility among the records included in the above-mentioned declaration data DB 126.

Subsequently, FIG. 8 shows an example of the sales ratio DB 127 in the present embodiment. The sales ratio DB 127 in the present embodiment is a database that records the ratio of the sales of the guest room sales made through the net agent server 300 to the total sales of the guest room sales in each accommodation facility as the sales ratio for each target period. be.

The data structure is a collection of records associated with data such as the location area, the target period, and the above-mentioned sales ratio, using the type of accommodation facility as a key. The information on this sales ratio is the information disclosed by the accommodation facility and the net agent server 300 regarding the accommodation facility whose direct sales of the accommodation facility and the sales via the net agent server 300 are known, and the target period. The average value is calculated by totaling for each facility type, location area, and target period.

In this embodiment, as illustrated in FIG. 8, it is assumed that the aggregated statistical values are managed by the sales ratio DB 127 for each attribute such as the type and class of the accommodation facility, and also for each target period, but each accommodation facility is individual. It is also possible to adopt a form that manages the sales ratio of. In that case, the above-mentioned aggregation and calculation of the average value will be performed separately.

*** Flow example ***
Hereinafter, the actual procedure of the business support method in this embodiment will be described with reference to the figure. Various operations corresponding to the business support methods described below are realized by a program read by the business support device 100 into a memory or the like and executed. The program is composed of codes for performing various operations described below.

FIG. 9 is a diagram showing a flow example of the business support method in the present embodiment. In this case, the business support device 100 acquires sales data related to a predetermined or each accommodation facility from the net agent server 300 or the site controller server 400, and stores the sales data in the sales data DB 125 of the storage device 101 (s10).

When acquiring the above-mentioned sales data, the business support device 100 sends and acquires a request to the net agent server 300 and the site controller server 400 via the API and the like disclosed therein, as well as the net agent. It is also possible to envision a form in which the server 300 or the site controller server 400 receives the data that automatically delivers the relevant information on a regular basis.

Alternatively, it is possible to envision a form in which an upload operation of a file such as a spreadsheet in which the relevant information is described is accepted from the net agent server 300, the site controller server 400, or the accommodation facility terminal 200.

Further, the business support device 100 acquires the accommodation tax declaration data at the accommodation facility from the predetermined accommodation facility terminal 200 and stores the data in the declaration data DB 126 of the storage device 101 (s11).

The acquisition of this declaration data is in the form of transmitting and acquiring a request via the API or the like disclosed by the accommodation facility reservation management system or the like, and the accommodation facility terminal 200 automatically distributes the relevant information on a regular basis. A form of receiving things can also be assumed.

Alternatively, it can be assumed that the accommodation facility terminal 200 accepts an upload operation of a file such as a spreadsheet in which the relevant information is described.

Subsequently, the business support device 100 extracts a record relating to a predetermined period from the sales data DB 125 of the storage device 101 with respect to the accommodation facility for which the declaration data was obtained in s11, and specifies the value of the accommodation fee from the record (s12).

In this case, the business support device 100 extracts each value of the selling price, the meal, the user, and the usage form from the corresponding record, and if there is no meal value and the total number of users is 1, the selling price is the accommodation. Identify as a charge. In addition, if there is a meal value, the amount obtained by subtracting the meal value from the selling price is specified as the accommodation charge. Of course, in addition to these specific patterns, the accommodation fee may be specified according to various conditions such as when the companion includes an infant and no bedding is used.

Subsequently, the business support device 100 calculates the accommodation tax amount by multiplying the accommodation charge specified in s12 by a predetermined tax rate (s13). The application form and value of this tax rate are stipulated for each municipality in the area where the accommodation facility is located. Therefore, it is assumed that the business support device 100 holds the information of the calculation rule of the accommodation tax for each local government in the storage device 101 so that it can be used in advance.

Further, the business support device 100 collates the declaration data obtained from the accommodation facility terminal 200 in s11 with the accommodation tax amount calculated in s13 described above, and processes the s11, that is, the accommodation tax amount derived from the declaration data, that is, the processing of s13. The deviation from the accommodation tax amount derived from the sales data is determined (s14).

Specifically, the business support device 100 calculates the difference between the accommodation tax amount derived from the declaration data and the accommodation tax amount derived from the sales data, and calculates, for example, a deviation of 50,000 yen.

Further, the business support device 100 determines whether the deviation determined in s14 exceeds a predetermined standard (s15). As a result of this determination, when the deviation is less than or equal to the standard (s15: No), the business support device 100 sets the above-mentioned declaration data in the declaration business program 111 in response to the instruction from the accommodation facility terminal 400, and the local government The declaration process to the system 500 is executed (s17).

On the other hand, when the deviation exceeds the standard as a result of the above determination (s15: Yes), the business support device 100 refers to the above-mentioned accommodation facility terminal 200 (or a predetermined notification destination terminal, for example, a local government system 500). For example, since there is a large discrepancy between the content of the declaration and the actual sales situation, an alert including a message recommending correction of the content of the declaration is sent (s16).

On the other hand, the accommodation facility terminal 200 that has received the above alert displays this on the output device 206 (screen 1000 in FIG. 10) and causes the person in charge of the accommodation facility to view it. This person in charge understands that there was an error in the content of the accommodation tax declaration, and will correct it so that the content corresponds to the actual situation. The accommodation facility terminal 400 retransmits the corrected declaration data to the business support device 100. The business support device 100 re-executes the above-mentioned processing after s11 in response to the reception of the corrected declaration data.

In the above example, the mode in which the processing is executed on the premise that the actual data of the guest room sales for each accommodation facility is comprehensively obtained from the net agent server 300 and the site controller server 400 has been described. However, such actual data is not all sales data, and for direct sales at accommodation facilities and sales based on reservations received by telephone or fax through a real travel agency, NetAgent Server 300 or Site Controller Server 400 , And it is difficult for the business support device 100 to obtain information.

Therefore, regarding the guest room sales of the accommodation facility, the business support device 100 determines the sales ratio between the direct sales by the accommodation facility (including the sales via a real travel agency; the same applies hereinafter) and the agency sales by the net agent server 300. , Estimated based on the sales ratio DB127. For example, among the values of the average sales ratio of the same type of accommodation facility in the area where the accommodation facility is located, the value of the target period is read from the sales ratio DB127 and estimated as the sales ratio in the accommodation facility.

Further, the business support device 100 divides the aggregated value of the sales price indicated by the sales data obtained from the net agent server 300 and the site controller server 400 for the accommodation facility in the corresponding period by the value of the sales ratio estimated above. , Estimate the total sales amount.

In this case, the business support device 100 calculates the total accommodation fee from the total sales amount, and multiplies the total accommodation fee by the tax rate of the accommodation tax to calculate the accommodation tax amount. When calculating the total amount of accommodation charges from the total sales amount, the ratio of the accommodation charges to the sales price indicated by the sales data obtained from the net agent server 300 and the site controller server 400 is applied to the total sales amount. It is possible to envision a form in which the total amount of accommodation charges is calculated.

Alternatively, the business support device 100 may include a deep learning engine in the program 102 to obtain a ratio of the accommodation fee to the above-mentioned selling price. In that case, the deep learning engine will use attributes (at least one of) such as type, location area, sales time, selling price, meal, user, and usage pattern of each accommodation facility, and accommodation among the selling prices at the accommodation facility. It is assumed that the correlation with the ratio of the price is learned based on the sales data obtained for each accommodation facility so far, and the learning model is generated. Therefore, when the attribute of the target accommodation facility is input to the learning model when calculating the total amount of the accommodation fee, the ratio of the accommodation fee to the selling price shown by the sales data related to the accommodation facility can be specified. The business support device 100 applies the ratio specified here to the above-mentioned total sales amount to calculate the total accommodation fee.

When the sales data obtained from the site controller is used when executing the above method, the reservation data indicated by the sales data is multiplied by a predetermined cancellation rate and then treated as sales data.

For the specified accommodation facility, if the provision of sales data to the business support system 100 by direct connection via the site controller or directly from OTA via API etc. is interrupted for a certain period of time, or the frequency of provision during the specified period is all. If the rate drops by a certain percentage or more from the period average, the business support system 100 determines that the accommodation facility is potentially sold by other means such as telephone or FAX, and the accommodation facility terminal 200 or the local government of the accommodation facility. An alert may be delivered to a predetermined notification target such as the system 500.

In this case, the business support system 100 goes through the net agent server 300 or the site controller server 400 as shown by the past sales data obtained for the accommodation facility or other accommodation facilities whose attributes match / similar to the accommodation facility. Regarding the ratio of room sales to room sales by the above-mentioned "other means", for example, the average value over the entire period learned by the above-mentioned deep learning engine, or the average value for each period such as week, month, and season. It is preferable that a plurality of patterns are held in advance.

When the business support system 100 selects the ratio corresponding to the accommodation facility from the ratios of each period when delivering the above-mentioned alert, the ratio indicates the existence of room sales by "other means" (that is,). (If room sales by other means are not zero), it is estimated that room sales by "other means" are occurring during the period when the above-mentioned sales data provision is interrupted / infrequent, and the above-mentioned alert is delivered. I will do it.

By taking such measures, the business support system 100 cannot obtain sales data from the net agent server 300 or the site controller server 400 (the business support system 100 is the net agent server 300, the site controller server 400, the API, or the like. Even if there is no connection and only the manual declaration data of the person in charge can be obtained from the accommodation facility terminal 200), it is possible to prevent the person in charge of the accommodation facility from forgetting to input the data and omitting the declaration in advance.

Although the best mode for carrying out the present invention has been specifically described above, the present invention is not limited to this, and various modifications can be made without departing from the gist thereof.
According to such an embodiment, it is possible to appropriately suppress the labor of the work related to the accommodation tax and improve the efficiency and accuracy of the work.

10 Network 100 Business support device 101 Storage device 102 Program 103 Memory 104 Arithmetic device 105 Communication device 111 Declaration business program 125 Sales data DB
126 Declaration data DB
127 Sales ratio DB
200 Accommodation facility terminal 201 Storage device 202 Program 203 Memory 204 Arithmetic device 205 Input device 206 Output device 207 Communication device 225 Declaration data 300 Net agent server 301 Storage device 302 Program 303 Memory 304 Arithmetic device 305 Communication device 325 Sales data DB
400 Site controller Server 401 Storage device 402 Program 403 Memory 404 Arithmetic device 405 Communication device 425 Sales data DB
500 municipal system

Claims (8)

A storage device that holds sales data managed by the sales agent or the site controller regarding the accommodation facility, which is obtained in advance from the sales agent or the site controller used by the accommodation facility.
The process of calculating the accommodation tax amount by multiplying the accommodation fee indicated by the sales data regarding the accommodation facility by a predetermined tax rate, and acquiring the accommodation tax declaration data at the accommodation facility from the terminal of the accommodation facility, and the declaration data. The process of collating the accommodation tax amount indicated by the above with the calculated accommodation tax amount and determining the deviation between the accommodation tax amount derived from the declared data and the accommodation tax amount derived from the sales data, and when the deviation exceeds the predetermined standard. An arithmetic device that executes a process of notifying a predetermined alert to the terminal of the accommodation facility or the terminal of the predetermined notification destination.
A business support device characterized by including. The arithmetic unit is
A process of acquiring the sales data regarding the accommodation facility from the sales agent or the system of the site controller and storing the data in the storage device is executed.
The business support device according to claim 1. The arithmetic unit is
Regarding the room sales of the accommodation facility, the sales ratio of the direct sales by the accommodation facility and the agency sales by the sales agent is estimated based on the average of the accommodation facilities of the same type and the same class in the area where the accommodation facility is located. Based on the sales data and the estimated sales ratio, the total amount of accommodation charges at the accommodation facility is calculated, and the total amount of accommodation charges is multiplied by the tax rate to calculate the accommodation tax amount.
The business support device according to claim 1 or 2, characterized in that. The arithmetic unit is
It is treated as sales data by multiplying the reservation data of the accommodation facility indicated by the sales data obtained in advance from the site controller by a predetermined cancellation rate.
The business support device according to any one of claims 1 to 3. Information processing equipment
Holds the sales data that the sales agent or the site controller manages about the accommodation facility, which is obtained in advance from the sales agent or the site controller used by the accommodation facility.
The process of calculating the accommodation tax amount by multiplying the accommodation fee indicated by the sales data regarding the accommodation facility by a predetermined tax rate, and acquiring the accommodation tax declaration data at the accommodation facility from the terminal of the accommodation facility, and the declaration data. The process of collating the accommodation tax amount indicated by the above with the calculated accommodation tax amount and determining the deviation between the accommodation tax amount derived from the declared data and the accommodation tax amount derived from the sales data, and when the deviation exceeds the predetermined standard. Processing to notify a predetermined alert to the terminal of the accommodation facility or the terminal of the predetermined notification destination, and
A business support method characterized by executing. The information processing device
A process of acquiring the sales data regarding the accommodation facility from the sales agent or the system of the site controller and storing the data in the storage device is executed.
The business support method according to claim 5, wherein the method is characterized by the above. The information processing device
Regarding the room sales of the accommodation facility, the sales ratio of the direct sales by the accommodation facility and the agency sales by the sales agent is estimated based on the average of the accommodation facilities of the same type and the same class in the area where the accommodation facility is located. Based on the sales data and the estimated sales ratio, the total amount of accommodation charges at the accommodation facility is calculated, and the total amount of accommodation charges is multiplied by the tax rate to calculate the accommodation tax amount.
The business support method according to claim 5 or 6, characterized in that. The information processing device
By multiplying the reservation data of the accommodation facility indicated by the sales data obtained in advance from the site controller by a predetermined cancellation rate, the data is treated as sales data.
The business support method according to any one of claims 5 to 7, characterized in that.

Images