JP7388663B2 - Travel business support system - Google Patents

Description

The present invention relates to a travel business support system.

2. Description of the Related Art Conventionally, there are systems that support travel operations at travel agencies and the like. The system described in Patent Document 1 is one example. In Patent Document 1, a reservation card indicating travel reservation details is created and managed by the system. Furthermore, the details of travel fees (sales/purchases) related to the trip are imported into the system for each such reservation card.

Japanese Patent Application Publication No. 2002-324115

Deposits and withdrawals related to travel fees in the travel business include deposits from customers and payments to suppliers. The present inventors have developed a support system for travel agencies that can appropriately manage deposits and withdrawals where there is a difference between the deposit and withdrawal amount and the travel fee amount due to a mistake in the deposit/withdrawal procedure, etc. I noticed that it was not found in the past. For example, Patent Document 1 describes that deposits and withdrawals are determined as unreceivable or unpaid based on a reference date for settlement processing. However, there is no description of how to manage deposits and withdrawals that have already been made if there is a difference with the travel fee. If deposits and withdrawals that result in discrepancies with travel fees cannot be managed in the system, it will be necessary to manage such deposits and withdrawals in a separate ledger or a separate system, making the management work related to deposits and withdrawals extremely complicated. There is a risk.

An object of the present invention is to provide a travel business support system that can appropriately manage deposits and withdrawals that differ in amount from travel fees.

The travel business support system according to the present invention includes a travel fee data storage means for storing travel fee data indicating the contents of the travel fee, and deposit/withdrawal data indicating the contents of deposits and withdrawals made in accordance with invoices issued regarding the travel fee. Each time the deposit/withdrawal data acquisition means acquires the deposit/withdrawal data, the travel fee data storage means stores the deposit/withdrawal indicated by the acquired deposit/withdrawal data. A distribution means for distributing the stored travel fee data regardless of whether or not the total billed amount in the invoice and the deposit/withdrawal amount are different; A deposit/withdrawal status acquisition means is provided for acquiring the status of deposit/withdrawal for the travel fee based on the input/withdrawal amount and the travel fee amount.

Invoices related to travel fees include invoices issued to customers (travelers, etc.) and invoices from suppliers that charge purchase fees. Deposits and withdrawals, that is, deposits from customers and payments to suppliers, are made in accordance with such invoices. According to the present invention, the contents of the travel fee are stored, and regardless of whether there is a difference between the total billed amount on the invoice and the deposit/withdrawal, each time the deposit/withdrawal data is acquired, the deposit/withdrawal indicated by the data is It will be allocated to the travel fee. Then, the status of deposits and withdrawals for the travel fee is obtained based on the deposit and withdrawal allocated to the travel fee and the travel fee. In this way, in the present invention, deposits and withdrawals that differ from the total amount billed are also managed by being allocated to travel fees. Therefore, there is no need to manage deposits and withdrawals that differ from the total billed amount using a separate ledger or a separate system. Therefore, administrative tasks related to deposits and withdrawals are less likely to become complicated. In addition, the status of deposits and withdrawals corresponds to, for example, whether deposits and withdrawals have been completed for the travel fee, whether there is a difference in the travel fee, and if there is a difference, how large the difference is, etc. do.

Furthermore, in the present invention, when the amount of deposits and withdrawals exceeds the total amount billed, at least one of the excess amount is refunded and the amount is allocated to the travel fee data regarding another bill. It is preferable to further include means for processing excess amount. According to this, it is possible to appropriately process the excess amount of deposits and withdrawals that occur between the total billed amount and the billed amount.

Further, in the present invention, when the amount of deposits and withdrawals exceeds the total billed amount, as processing by the excess amount processing means, the entry amount indicating a negative amount corresponding to the excess amount is provided. It is preferable that when the withdrawal data is generated, the distribution means distributes the input and withdrawal data indicating the negative amount to the input and withdrawal data indicating the input and withdrawal in which the excess amount has occurred. According to this, when an excess of deposits and withdrawals occurs between the total billed amount and the total amount billed, data with appropriate content is generated and distribution is executed appropriately to match the processing of refunds, etc. related to the excess amount. Ru.

Further, in the present invention, the travel fee data includes purchase data indicating the unit price and quantity of the purchase corresponding to the content of the purchase, and the allocating means is configured to receive a request from the supplier for the purchase. In addition, if the amount of the invoice from the supplier is different from the amount of purchase indicated by the purchase data, the payment according to the content of the purchase data is allocated to the purchase data. It is preferable to adjust the unit price of the purchase and/or add the purchase data indicating new purchase. Due to exchange rate fluctuations, etc., the amount of the invoice from the supplier may differ from the purchase amount stored as travel fee data (purchase data). According to the above configuration, even in such a case, when allocating payments according to invoices, the unit price of purchases in the purchase data is adjusted, and purchase data indicating new purchases is added as necessary. be done. As a result, distribution is executed with appropriate contents.

Further, in the present invention, the travel fee data includes the contents of the 1st to nth (n: natural number of 2 or more) breakdown items that are the breakdown of the amount of the travel fee that has not been distributed by the distribution means. If the amount of the first sub-item is greater than or equal to the amount of the deposit/withdrawal, the distributing means allocates the deposit/withdrawal to the first sub-item, - The total amount of the first sub-item (k: a natural number satisfying 2≦k≦n) is less than the amount of the aforementioned deposit/withdrawal, and the total amount of the 1st to kth sub-items is greater than or equal to the amount of the aforementioned deposit/withdrawal. If there is k such that According to this, travel fees are managed on a sub-item basis, and deposits and withdrawals are divided in detail to each sub-item. Therefore, payment of deposits and withdrawals is performed accurately.

In addition, "If the amount of the first sub-item is greater than or equal to the amount of the deposit/withdrawal, the total amount of the deposit/withdrawal will be distributed to the 1st to nth sub-items." As long as the description ``is a method of distribution that results in the distribution content expressed by this description, the distribution means may execute the distribution in any manner.

1 is a block diagram showing the configuration of a travel business support system according to an embodiment of the present invention. FIG. 2 is a schematic diagram showing the configuration of the server in FIG. 1. FIG. This is a screen for inputting and displaying reservation details, etc. in the travel business support system shown in Figure 1. This is a screen that is displayed when "Claim" in FIG. 3 is selected. This is a screen that is displayed when "Deposit" in FIG. 3 is selected. 2 is a payment reconciliation screen in the system according to FIG. 1. This is a screen that is displayed when "Seller" in FIG. 3 is selected. In FIG. 5, this is the screen that is displayed when "refund/transfer request" is selected. This is an image displayed as part of the screen in FIG. 8 when the process in FIG. 8 progresses. (a) It is a diagram showing the relationship among invoices, sales data, allocation data, and deposit data in the case where there is neither unaccounted revenue nor overpayment, which is generated in the travel business support system of FIG. 1. (b) It is a diagram showing the relationship among the invoice, purchase data, allocation data, and payment data in the case where there is neither unpaid nor overpaid data, which is generated in the travel business support system of FIG. 1. FIG. 2 is a diagram showing the relationship among invoices, sales data, allocation data, and deposit data in the case of overpayment, which are generated in the travel business support system of FIG. 1; (a) It is a diagram showing the relationship among invoices, sales data, distribution data, and deposit data in the case of complete non-receipt, which is generated in the travel business support system of FIG. 1. (b) It is a diagram showing the relationship among the invoice, purchase data, distribution data, and payment data in the case of complete unpaid status, which is generated in the travel business support system of FIG. 1.

A travel business support system 1 according to an embodiment of the present invention will be described with reference to FIGS. 1 to 12. The travel business support system 1 is a system for managing deposits and withdrawals that have a difference in amount from travel fees. The details will be explained below.

As shown in FIG. 1, the travel business support system 1 includes a plurality of terminals 100 and a server 200. Data communication is performed between the terminal 100 and the server 200 via the Internet N. For communication between the terminal 100 and the server 200, an Internet communication protocol such as HTTP (Hyper Text Transfer Protocol) is used. Both the terminal 100 and the server 200 are constructed from hardware such as a computer and software such as program data stored in a memory device. These software can be downloaded from the Internet or distributed using various recording media. A computer includes hardware such as a CPU (Central Processing Unit), memories such as a ROM (Read-Only Memory) and a RAM (Random Access Memory), a hard disk drive, and various interfaces such as an input/output interface. In each of the terminal 100 and the server 200, hardware executes processing such as the following communication processing according to software. Browser 130, which will be described below, is one such software.

As shown in FIG. 2, the server 200 includes a storage section 210 (travel fare data storage means in the present invention), a reservation data generation section 220 (reservation information input means in the present invention), a sales data generation section 230, an input/output It has a money data generation section 240, a distribution section 250 (distribution means in the present invention), and a determination section 260 (deposit/withdrawal status acquisition means in the present invention). The storage unit 210 stores information indicating travel reservation details transmitted from the terminal 100, as well as travel fees, bills, and deposit/withdrawal details related to the reservation details. The reservation details are stored in the storage unit 210 as reservation data 420 while being organized into a reservation card unit consisting of a set of information for each trip. A reservation card is a unit of information for managing a series of operations from receiving a travel application to completing the trip, and is also called a medical record. Each reservation card includes a plurality of unit reservations that are one reservation for one supplier. A unit reservation corresponds to a person in charge of reservation operations making one reservation to a supplier. One reservation number is assigned to this unit reservation by the supplier.

The travel fee is stored in the storage unit 210 as sales data 410. Travel fees include fees charged to customers (travelers, etc.) corresponding to sales, and fees charged by suppliers corresponding to purchases. Sales data 410 includes sales data 411 and purchase data 412. Sales data 411 shows sales details consisting of a plurality of sales items. Purchase data 412 indicates a purchase detail consisting of a plurality of purchase items corresponding to a plurality of sales items. The sales items and the purchase items are items related to travel fees in units that are more detailed than unit reservations, and have a one-to-one correspondence with each other.

Deposits and withdrawals made in accordance with invoices issued regarding travel fees are stored in the storage unit 210 as deposit and withdrawal data 430. Deposits and withdrawals include deposits from customers and payments to suppliers. The deposit/withdrawal data 430 includes deposit data 431 indicating the details of the deposit and payment data 432 indicating the details of the payment. In this embodiment, "deposit" basically refers to receiving a travel fee corresponding to sales from a customer or a received fee. If the deposit amount indicated by the deposit data 431 is a positive value, it indicates a deposit from such a customer. If the deposit amount indicated by the deposit data 431 is a negative value, it indicates that a refund has been made to the customer. In this embodiment, "payment" basically refers to paying a travel fee related to purchasing to a supplier or a paid fee. If the payment amount indicated by the payment data 432 is a positive value, the payment amount is shown to such a supplier. If the payment amount indicated by the payment data 432 is a negative value, it indicates that a refund has been made by the supplier. Refund is a process of returning the excess amount when a deposit or payment is made that exceeds the invoice amount. In addition, if there is an overpayment, it is possible to make a transfer instead of a refund, as described below. The transfer according to the present embodiment is a process of allocating the excess amount of deposit to a bill of a reservation card different from the reservation card corresponding to the original bill, according to the intention of the depositor.

The distribution data 440 is data that associates the sales data 410 and the deposit/withdrawal data 430. As mentioned above, receipts correspond to sales, and payments correspond to purchases. The distribution data 440 indicates these correspondences in units of sales items or purchase items. In this embodiment, "allocation" refers to allocating part or all of the deposit to the sales details, or allocating part or all of the payment to the purchase details. In the following explanation, performing the distribution may be expressed as "distributing" or the like.

Bill data 450 is data indicating the contents of a bill issued to a customer. Each bill consists of a plurality of billing items as billing details. Each billing item corresponds to each sales item. The bill data 450 includes data indicating the billing destination, the billing amount for each billing item, and the like, as well as data indicating the association between each sales item and each billing item indicated by the sales data 411. The billed amount indicated by the bill data 450 may take a positive value or a negative value. The former corresponds to a case where a deposit is made from a customer in accordance with an invoice, and the latter corresponds to a case where a refund is made to a customer in accordance with an invoice.

The reservation data generation unit 220 receives reservation information indicating reservation details for each unit reservation from the terminal 100. Such information is input for each unit reservation through the reservation image area 320 of the screen IMI 300 in FIG. 3, as described later. The reservation data generation unit 220 generates reservation data 420 indicating information such as reservation status, PAX, flight information, and other specific reservation details transmitted from the terminal 100, and stores it in the storage unit 210. The sales data generation unit 230 receives information regarding sales and purchasing for each unit reservation from the terminal 100. Such information is input for each unit reservation through the sales information area 330 of the screen IMI 300 in FIG. 3, as described later. The sales data generation unit 230 generates sales data 410 based on this, and stores it in the storage unit 210. The deposit/withdrawal data generation unit 240 receives information indicating details of deposits and withdrawals (see FIGS. 5, 6, and 9) from the terminal 100 as described later, generates deposit/withdrawal data 430 based on this information, and stores the information. 210. The bill data generation unit 270 receives information indicating the contents of the bill from the terminal 100. Such information is input through the screen IMI20 in FIG. 4, as described below. Bill data generation section 270 generates bill data 450 indicating information transmitted from terminal 100, and stores it in storage section 210.

As will be described later, the distribution unit 250 generates distribution data 440 based on the content of distribution input through the screen IMI30 in FIG. 5, the screen IMI50 in FIG. 6, etc., and stores it in the storage unit 210. The determining unit 260 calculates an unpaid amount, which is the amount that has not been paid for each sales item, and an unpaid amount, which is the amount that has not been paid for each purchase item, based on the allocation result by the allocating unit 250. do. The details of the distribution by the distribution unit 250 and the calculation of the accrued amount and the unpaid amount by the determination unit 260 will be described later.

As other processing, the server 200 generates programs and various data written in HTML (HyperText Markup Language) that instruct the terminal 100 to perform processing based on the functions of the browser 130, and sends them to the terminal 100. . Further, the server 200 transmits data such as the storage contents of the storage unit 210 to the terminal 100 in response to a request received from the terminal 100.

As the terminal 100, a notebook or desktop personal computer, a tablet terminal, a smartphone, or the like is used. A display 110 that displays information is connected to or installed in the terminal 100. Further, a printing device 140 such as a printer that performs recording on paper media is connected to the terminal 100. Furthermore, the terminal 100 is connected to or equipped with one or more input devices 120 such as a mouse, a pointing device such as a touch pad or a touch panel display, and a keyboard. By using the input device 120, the user can select and operate various control images in a graphical user interface (GUI) image, which will be described later, and input characters in the selected control image.

A web browser application (hereinafter referred to as "browser 130") is installed on the terminal 100. The browser 130 causes the terminal 100 to perform the following various processes based on the data sent from the server 200. For example, the terminal 100 causes the display 110 to display GUI images shown in FIGS. 3 to 7 for allowing the user to input travel reservation details, sales and purchase details, etc. through the input device 120. The terminal 100 also sends the contents input through the GUI image to the server 200, and requests the server 200 for information necessary for various processes, such as information to be displayed on the GUI image. The GUI image includes a login image (not shown). Travel business employees can start using this system by using their assigned login IDs and entering their ID and password in the login image. The login ID has authority set according to the user's responsibility.

Below, various processes using GUI images in the terminal 100 will be explained. The IMI 300 shown in FIG. 2 is a GUI image of a main screen for inputting and viewing information regarding one reservation card. The input and viewing of such information is mainly performed by the person in charge of the reservation business using the login ID assigned to the system. Note that the business supervisor or the person in charge of business other than the reservation business may input and view information using the login ID assigned to him or herself.

The IMI 300 corresponds to one reservation card selected or newly created through another GUI image (not shown) for selecting or creating a new reservation card. In such another GUI image, the IMI 300 is displayed on the display 110 by instructing the screen display of the IMI 300 by a user input using the input device 120. The IMI 300 is a card basic area (not shown) for inputting basic information and travel information (travel period, destination, etc., traveler's name, contact information, etc.) on the reservation card, and a card basic area (not shown) for inputting reservation details, etc. The main screen includes a main area 370 and a menu area 380 including a menu control image for displaying a GUI image separate from the main screen and a display field for displaying sales/purchasing information for the entire reservation card. Among these areas, the main area 370 is displayed long on the screen of the display 110 in the vertical direction (hereinafter referred to as "screen vertical direction"). In many cases, the main area 370 cannot be displayed on one screen, so the input device 120 is used to operate a scroll bar control image (not shown) displayed on the right side of the IMI 300 or to operate mouse buttons. Scroll the displayed content vertically on the screen by doing this. As a result, information and input areas in each part of the main area 370 are sequentially displayed on the screen. On the other hand, the menu area 380 does not follow the scrolling of the main area 370 and is maintained at a predetermined position on the left side of the IMI 300.

Main area 370 includes one or more travel-specific areas 350. The travel-specific area 350 is an area for each type of travel, such as arranged travel, planned travel, and commissioned travel. Arranged travel is travel that requires the traveler to make reservations for airline tickets, lodging, trains, etc. with a supplier in accordance with travel details such as desired travel destination and schedule. A planned trip is a trip in which the travel destination, schedule, etc. are set in advance, and reservations for airline tickets, accommodation, trains, etc. are also set in advance. Commissioned travel is travel related to other companies' products. Which travel area 350 for each trip is displayed in the main area 370 is determined when an instruction to display the screen of the IMI 300 is given by a user input using the input device 120 as described above. In this embodiment, the travel area 350 related to arranged trips will be explained as a main example, but the configuration of the trip area 350 related to arranged trips in the following explanation will be similar to the trip area 350 related to planned trips and commissioned trips. is also applicable.

In the main area 370, one or more travel-specific areas 350 are displayed side by side in the vertical direction of the screen. These are displayed in a scrollable manner in the vertical direction of the screen as described above. As shown in FIG. 3, each trip area 350 includes one or more arrangement input image areas 310. The arrangement input image area 310 is an area for inputting specific information such as reservation details. Each arrangement input image area 310 corresponds to each unit reservation. Services related to the contents input in the arrangement input image area 310 include overseas air, domestic air, hotels, ships, rental cars, railways, travel documents, insurance, etc. Within the travel-specific area 350, areas are divided in the vertical direction of the screen for each service, and in each area for each service, the arrangement input image area 310 related to that service is displayed continuously in the vertical direction of the screen. In the trip area 350 related to arranged trips, a control image 311 for adding the arrangement input image area 310 is displayed at the bottom of the arrangement input image area 310 related to each service. By selecting each control image 311 using the input device 120, an arrangement input image area 310 regarding the corresponding service is added at the bottom. The entire arrangement input image area 310 is displayed so as to be scrollable in the vertical direction of the screen as described above.

Each arrangement input image area 310 related to an arranged trip is an image area for inputting reservation details and the like. The arrangement input image area 310 includes a reservation image area 320 and a sales information area 330.

The reservation image area 320 is an area where the user inputs reservation details and displays the input results. The reservation image area 320 includes an arrangement basic area 321, a reservation content area 322, and a user list area 323 arranged in the vertical direction of the screen. The sales information area 330 is arranged to the right of the user list area 323. Among these, the arrangement basic area 321 contains common contents regardless of the type of service, and is used to allow the user to input information such as reservation status, PAX information, arrangement deadline, person in charge, etc., and to display the input results. Contains control images for. The reservation content area 322 includes different content for each service, and includes a control image for inputting and displaying specific information about the reservation content. Such specific information includes, for example, a PNR (Passenger Name Record) containing one reservation number (or confirmation number) assigned by the supplier in the case of airline services such as overseas air, as shown in Figure 4. Includes flight information for the reserved flight (flight number, departure date, origin, destination, departure and arrival time, seat class, number of seats, etc.), mileage card number, ticket number, etc. The reservation content area 322 includes one or more control images for inputting dates and their item names. Such items include, for example, the issuance date of airline tickets and train tickets, the start date and completion date of the accommodation period, the start date and completion date of use of ships and rental cars, and the like. In the arrangement input image area 310 related to each service, the above-mentioned date items included in the reservation content area 322 always include an item corresponding to the sales date of the trip related to that service. The "sales date" in this embodiment corresponds to the accounting recording date in the details of sales and purchases. The accounting date is determined for each type of travel (arranged travel, planned travel, etc.) and each service. In this travel business support system 1, the sales date is also set based on such accounting standards. The item name corresponding to the sales date is displayed in a manner that is visually distinguishable from other item names. In the arrangement input image area 310 of FIG. 4, for example, a date input field C1, which is a field for inputting the date of the ticket issuance deadline, its item name C2, "Ticketing deadline date", and the date of ticket issuance, which is the sales date, are input. A date input field C3 and its item name C4 "Date of Ticket Issue" are included. Among these, the item name C4 is underlined in a wavy manner, and is displayed in a manner that allows it to be visually distinguished from the item names in other columns. In addition, for example, the characters indicating the item name of the sales date may have a different color, size, or thickness from other item names, or may be underlined or enclosed. good. As shown in this example, the sales date corresponds to a date in the future at the time of information input in the reservation content area 322. The user list area 323 is an area that displays a list of service users. The users included in the user list are the travelers indicated by the PAX information input in the arrangement basic area 321 among the travelers indicated by the traveler information input in the card basic area 360.

The information input into the reserved image area 320 is transmitted from the terminal 100 to the server 200. Based on this, the reservation data generation unit 220 generates the reservation data 420 as described above. The reservation data 420 includes data indicating each piece of information input in the reservation image area 320.

The sales information area 330 includes common contents regardless of the type of service, and is a control that allows the user to input sales and purchase contents regarding one or more sales items corresponding to the reservation contents and displays the input results. Contains images. The sales details include the name, label, PAX information, sales unit price, and quantity of each sales item. The name of the sales item is input by selecting one from a preset name list using the input device 120. Other sales details are input for each sales item. The PAX information and quantity are automatically input based on the PAX information input in the basic arrangement area 321. Of these, the PAX information can be changed for each sales item. The quantity indicates the number of people corresponding to the PAX information and cannot be changed. The purchase details include purchase currency, purchase unit price, and supplier as purchase items that correspond one-to-one with sales items. Further, the sales information area 330 includes a control image C5 for inputting a date. When a date is input into the date input field C3 of the reservation content area 322, that date is automatically input into the date input field C5 of the sales information area 330. When the sales details and purchase details are input, the total amount obtained by multiplying the sales unit price by the quantity in the input sales details is displayed at the top of the sales information area 330, and the input purchase details are also displayed. The total amount obtained by multiplying the purchase unit price by the quantity is displayed.

Information input into the sales information area 330 is transmitted from the terminal 100 to the server 200. Based on this, the sales data generation unit 230 generates the sales data 410 as described above. Among the sales data 410, sales data 411 includes information on each sales item input in the sales information area 330, that is, data indicating the name, label, PAX information, sales unit price, and quantity of the sales item. . In the sales data 410, the purchase data 412 includes information on each purchase item input in the sales information area 330, that is, data indicating the purchase currency, purchase unit price, and supplier.

The menu area 380 includes a menu control area 381 that includes a plurality of control images for selecting various processes, and a total area 382 that displays the total amount of sales, etc. of the entire reservation card. The control images included in the menu control area 381 include a control image C10 for returning to the IMI 300 screen display from a state where another screen is displayed, a control image C11 for opening the sales details screen, and a control image C11 for opening the billing details screen. It includes a control image C12 and a control image C13 for opening the deposit screen. When one of the control images C11 to C13 is selected, a GUI image for displaying and inputting various information, such as a sales input screen, is displayed on the display 110, as described later. The information displayed and input in these GUI images is stored in the storage unit 210 of the server 200 in association with the reservation card information displayed in the main area 370.

When the control image C12 is selected using the input device 120 in the menu area 380, a screen IMI20 (the above billing details screen) consisting of a GUI image related to issuance of a bill is displayed on the display 110, as shown in an example in FIG. Ru. It is assumed that the invoice issuance work through the screen IMI 20 is mainly performed by a person in charge of reservation work. On the screen IMI20, using the input device 120, it is possible to input the scheduled payment date, the currency of the billed amount, etc. as the contents of the bill, as well as input a plurality of billing items (for example, billing items C21 to C21 in FIG. 5) as the billing details. It is possible to input the contents of C23). Each billing item corresponds to each sales item in the arrangement input image area 310. The contents of such billing items are automatically input according to the contents input in the arrangement input image area 310.

For example, in billing item C21 in FIG. 4, "domestic airline ticket" is displayed in the "print item" column according to the content input in the domestic air arrangement input image area 310. “1” is displayed in the “PAX” column, and “Taxation” is displayed in the “Tax category”. Note that for sales items that are not subject to tax, either "exempt from tax," "non-tax," or "exempt from tax" is displayed. In the example of FIG. 4, "No tax" is displayed. 10% is displayed in the "tax rate" column. “1,000” is displayed in the “unit price” column. “1” is displayed in the “Quantity” column. The default values displayed in the “unit price” and “quantity” correspond to the “unit price” and “quantity” of each sales item input in the arrangement input image area 310. The "amount" column displays the amount obtained by multiplying the "unit price" by the "quantity." In the "tax included" column, an amount "90" is displayed that corresponds to the "tax rate", "unit price", and "quantity". In the "Billed Amount" field, "1,000" is displayed in accordance with the "Amount". The "unbilled amount" column displays an amount "1,000" for which no invoice has been issued in the past. Note that if an invoice has been issued in the past, the amount obtained by subtracting the amount for which the invoice was issued will be displayed from the "Amount" column.

Among the above fields, the input contents can be changed using the input device 120 in each of the fields of "Print Item", "Tax Rate", "Unit Price", and "Billed Amount". However, the numerical value of the "billed amount" can be changed within a range that does not exceed the value input in the arrangement input image area 310. In addition, if the "unit price" is multiplied by the "quantity" and the total amount for all billing items matches the total "billing amount", the amount exceeds the value input in the arrangement input image area 310. It is possible to input Further, the "tax rate" can be selected from preset values. Input can be made to the "Summary" column using the input device 120 if necessary.

Similarly, billing items C22 are displayed according to the contents input in the hotel arrangement input image area 310, and the description of the contents of each item can be changed as necessary. Further, billing items C23 are displayed according to the contents input in the railway arrangement input image area 310, and the description of the contents of each item can be changed as necessary.

The control image C26 placed at the beginning of each billing item selectively takes an unchecked state and a checked state, and the state is switched by selection using the input device 120. When at least one of these control images is in a checked state, when the control image C24 is selected using the input device 120, the contents inputted on the screen IMI20 are transmitted from the terminal 100 to the server 200. be done. Based on this, as described above, the bill data generation unit 270 generates bill data 450 indicating a bill that includes the contents of the checked bill items as bill details. The bill data 450 includes data indicating the unit price, quantity, tax rate, etc. for each billing item, and data indicating which sales item each billing item corresponds to. Further, the bill is printed by the printing device 140 connected to the terminal 100. The invoice issued in this way is handed over or shipped to the customer by, for example, a person in charge of reservations. On the other hand, when the control image C25 is selected, the issuance of the bill through the screen IMI20 is canceled.

When the control image C13 is clicked using the input device 120 in the menu area 380 of FIG. 3, a screen IMI30 (the above-mentioned deposit screen) consisting of GUI images related to deposits and their redemption, an example of which is shown in FIG. 5, is displayed on the display 110. Ru. There are various ways of depositing money from customers, such as when a person in charge of reservations directly receives cash from the customer at a counter, or by credit card payment, or by transferring money to a bank account. Among these, when the person in charge of the reservation business accepts the payment at the counter, the deposit from the customer is input through the screen IMI30. As described below, the deposit can be written off by inputting the details of the deposit into each input field of the screen IMI 30 using the input device 120 and allocating it to the billed amount of the bill.

The screen IMI30 includes an area 30a for inputting the details of the deposit, and an area 30b showing the distribution status of the deposit to the bill. The area 30a includes a control image C37 that selectively takes a scheduled state and a confirmed state. By default, the control image C37 takes a scheduled state (the state shown in FIG. 5). In this state, input of deposit details and distribution operations are performed as follows. When the input device 120 is used to select "confirm" in the control image C37 after inputting the details of the deposit and performing the distribution operation, the control image C37 takes on the confirmed state and the input contents of the deposit are displayed. and the distribution operation is confirmed.

The area 30a includes a control image for inputting the deposit amount, slip number, deposit date, information of the person in charge who accepted the deposit, etc. For example, the date of payment is entered in the input field C31 for "deposit date". The deposited amount is entered in the "deposited amount" input field C32. The area 30b includes display columns for characters, numbers, etc. indicating the distribution status. For example, the display field C33 of "unallocated amount" displays the amount of money that has not been completely allocated out of the amounts in the input field C32. A control image C38 of a "refund/transfer request" button is arranged to the right of the display field C33. The control image C38 can be selected using the input device 120 when the amount in the display field C33 is not 0 yen (when an unallocated amount has occurred). When the control image C38 is selected, a later-described screen IMI60 related to refund/transfer processing is displayed.

At the bottom of the area 30b, bills issued within the same reservation card are displayed as a list. The display field C34 of each bill displays the "billed amount," "accrued amount," "allocated amount," etc. before the amount in the "unallocated amount" display field C33 is written off. The display field C34 includes a "distribution" control image C35 and a "cancellation" control image C36. When the control image C35 corresponding to any bill is selected using the input device 120, information indicating the selected bill is transmitted to the server 200. The allocation unit 250 of the server 200 allocates the unallocated amount displayed in the display field C33 to the invoice based on the information transmitted from the terminal 100. For example, if the billed amount of the invoice is greater than or equal to the unallocated amount, the entire unallocated amount is allocated to the invoice. On the other hand, if the invoiced amount of the invoice is less than the unallocated amount, the unallocated amount equivalent to the invoiced amount is allocated to the invoice. Specifically, the distribution is performed on sales items corresponding to each billing item included in the invoice. Details of such allocation will be described later. According to the content of the allocation, the amount in the display column C33 and the unpaid amount and the allocated amount in the display column C34 are updated. When a list of multiple invoices is displayed in the area 30b, by performing the above distribution across multiple invoices, the deposit exceeding the total amount charged for one invoice can be distributed. I can do it. This function corresponds to the function of the excess amount processing means in the present invention. When the control image C36 is selected using the input device 120, the distribution is canceled and the amount display in the display columns C33 and C34 is returned to the state before the distribution.

After the details of the deposit are input and the distribution operation is performed as described above, when the control image C37 is selected, the details of the deposit and distribution are determined as described above. Note that it is possible to finalize the details of the deposit and distribution in a state where the total amount of the distributed amount is less than the deposited amount in the input field C32. In this case, the unallocated amount of the input deposit will remain. The confirmed deposit and distribution details are transmitted from the terminal 100 to the server 200. Based on this, as described above, the deposit/withdrawal data generation section 240 generates the deposit/withdrawal data 430, and the distribution section 250 generates distribution data 440 indicating the details of the distribution.

The reconciliation of payments for purchases is mainly performed by the person in charge of accounting based on invoices from suppliers or by manually inputting payment information. The screen IMI50 shown in FIG. 6 is used when executing based on an invoice from a supplier. After importing the data file of the invoice from the supplier into the travel business support system 1 through another GUI image (not shown), the screen IMI 50 inputs any item in the details of the supplier's invoice using an input device. The selection based on user input using 120 is displayed on display 110 . The server 200 calculates the payment for the invoice from the purchase items indicated by the purchase data 412 stored in the storage unit 210 based on the supplier information, invoice amount, etc. indicated by the imported invoice data. Search for purchase items that are candidates for reconciliation. The purchase items to be searched correspond to those input in the sales information area 330 of the arrangement input image area 310. Furthermore, the search range covers multiple purchase items across multiple reservation cards. Based on the search results, the screen IMI50 displays purchase items C51 to C53 (only some of which are exemplified) that are candidates for elimination. Each of the purchase items C51 to C53 includes the corresponding reservation card number, corresponding service, corresponding sales item name, scheduled payment date, correction (check box), adjustment amount, its breakdown, and a display field for the unpaid amount. I'm here. Among these, in the adjustment amount and its breakdown, if the correction checkbox is not checked, the total purchase amount and its breakdown for each purchase item that is a candidate for reconciliation will be displayed as is, as shown in Figure 6. Ru. The case where the correction checkbox is checked will be described later. The unpaid amount indicates the unpaid amount with respect to the adjustment amount calculated by the determination unit 260. Control images C54 to C56 for inputting the amount to be distributed are arranged to the right of the display field for the unpaid amount. In the control images C54 to C56, the amount corresponding to the unpaid amount is entered by default. These contents can be changed using the input device 120. A display field C57 is arranged above the control images C54 to C56 to display an amount corresponding to the total amount of allocation indicated by these input contents. When the "allocation execution" control image C54 placed at the top of the screen IMI50 is selected using the input device 120, each purchase item is selected according to the allocation amount input in the control images C54 to C56. In contrast, payment allocation is performed. If the allocation amount input in the control images C54 to C56 matches the total purchase amount for each purchase item (as shown in Figure 6), the allocation amount will be transferred without checking the correction checkbox. The portion is done. On the other hand, if the allocated amount does not match the total purchase amount due to fluctuations in currency rates, etc., if the correction checkbox is checked, the purchase details will be automatically adjusted by the travel business support system 1. be done. Payment is then distributed to the adjusted total purchase amount. For example, assume that the original purchase details for a certain purchase item are a unit price of 101 yen and a quantity of 2 (that is, a total of 202 yen), and the allocation amount is input as 205 yen. In this case, if the correction checkbox is checked, the unit price will be added by 1 yen to 102 yen as an adjustment to the purchase details, and one purchase item with a unit price of 1 yen and quantity of 1 will be added. Ru. As a result, (original unit price 101 yen + added unit price 1 yen) * quantity 2 + added purchase item 1 yen = 205 yen. In other words, the purchase details are adjusted to match the allocated amount. Note that the above-mentioned addition of purchase items is executed only when the purchase contents do not match the allocated amount only by adjusting the unit price. Then, an allocation amount of 205 yen is applied to the adjusted purchase contents (total of 205 yen). The details of the allocation for such payments and purchases, as well as the adjustments to the purchase contents, are transmitted from the terminal 100 to the server 200. Based on this, as described above, the deposit/withdrawal data generation section 240 generates the deposit/withdrawal data 430 (payment data 432), and the distribution section 250 generates distribution data 440 indicating the details of the distribution.

When inputting payment information manually, the accounting person inputs the payment amount, the purchase to be allocated, the amount to be allocated, etc. through a GUI image (not shown) that is different from the screen IMI50. The entered payment and allocation details are transmitted from the terminal 100 to the server 200. Based on this, as described above, the deposit/withdrawal data generation section 240 generates the deposit/withdrawal data 430 (payment data 432), and the distribution section 250 generates distribution data 440 indicating the details of the distribution.

A screen IMI40 shown in FIG. 7 is an example of an image for displaying details of sales and purchase details. The screen IMI40 corresponds to the sales details and purchase details regarding one sales item input in any one of the arrangement input image areas 310. On the screen IMI40, after selecting the control image C11 (see FIG. 3) using the input device 120 in the menu area 380 of FIG. 3, a list of sales and purchase items in the reservation card is displayed through another GUI image (not shown). Displayed by selecting any one item corresponding to one sales item input in one arrangement input image area 310 (one unit reservation) from the list. In the example of FIG. 7, the contents of sales items for overseas railway tickets are displayed as the screen IMI40. The screen IMI40 has display columns such as sales item names, labels, tax categories, PAX information, suppliers, information on sales and purchase amounts (unit price, quantity, total amount, tax amount, etc.), and profit (sales and Contains columns such as information regarding the purchase price difference (purchase difference), invoice amount (currency and total amount), and payment amount (same as above). On the right side of the display field for information regarding the billed amount, there is a display field C40 for "Unbilled," a display field C41 for billing status, a display field C42 for "Accrued/Unpaid," a display field for "Scheduled date," and payment status. A display column C43 indicating the following is arranged. Among these, the display column C41 displays whether or not the bill has been issued through the screen IMI20 in FIG. In FIG. 7, as an example, "Billed" is displayed indicating that the bill has been issued. The display column C42 displays the amount of receivables calculated by the determination unit 260. In FIG. 7, an unaccounted amount of "0" is displayed as an example. The display column C43 displays whether or not the entire amount of sales has been cleared. In FIG. 7, "Deposited" is displayed, indicating that the entire amount of sales has been applied. On the right side of the display column for information regarding the payment amount, there are arranged a display column C44 for "accrued/unpaid," a display column for "scheduled date," and a display column C45 for indicating the payment status. Among these, the display column C44 displays the unpaid amount calculated by the determination unit 260. In FIG. 7, an unpaid amount of "2,000" is displayed as an example. The display column C45 displays whether the payment for the total amount of the purchase has been cleared. In FIG. 7, as an example, "unpaid" is displayed, indicating that the purchase has not been cleared at all (not even partially). Note that if a payment corresponding to a part of the amount of the purchase is distributed, "partial payment" is displayed.

When the control image C38 is selected on the screen IMI30 in FIG. 5, a screen IMI60 consisting of GUI images related to refunds and transfers is displayed on the display 110, as shown in an example in FIG. Note that the processing related to refund or transfer based on the input contents on this screen IMI 60 corresponds to the processing by the excess amount processing means in the present invention. Refund is a process of returning the excess amount to the customer when the payment exceeds the total amount of the invoice. Transfer is the process of allocating the excess amount of the same deposit to the bill of another reservation card. The screen IMI60 includes a control image C61 of a button for proceeding with a refund or transfer request, an area 60a that displays basic information about the refund or transfer, and an area 60b that displays the details of the unallocated deposit that is subject to the refund or transfer. , an area 60c for inputting necessary information for refund or transfer, an area 60d for displaying the details of the deposit related to the deposit to be refunded or transferred, and displaying the details of the request when the refund request is approved. 60e.

Control image C61 can be selected through input device 120. When control image C61 is selected after information related to a refund or transfer is input into the areas 60a to 60c, a request for refund or transfer is generated based on the input contents, and a state awaits approval. The area 60a includes fields for inputting a request number for identifying a refund or transfer request, a request amount that is the total amount of the refund, etc., a sales partner corresponding to the refund destination or transfer destination, information on the person in charge, and the reason for the refund or transfer. Contains. Furthermore, the area 60a includes control images C62 and C63. The control image C62 is an image for the business supervisor to approve the request contents after the request for refund or transfer is waiting for approval. Take it. These states are switched by selecting an image through the input device 120. Which state is in is displayed by switching the appearance of the image. FIG. 8 shows an unapproved state. Control image C63 is an image for inputting whether or not the accounting person has executed the process after the approval of the request by the business supervisor, and the control image C63 is an image for inputting whether or not the accounting person has executed the process after the approval of the request by the business supervisor. take. These states are switched by selecting an image through the input device 120. Which state is in is displayed by switching the appearance of the image. FIG. 8 shows an unprocessed state.

Area 60b includes a list of unallocated deposits. Although only one item is displayed in the example of FIG. 8, one or more items consisting of all candidates within the same reservation card are displayed in the list. Each item in the list consists of a column that displays the details of the deposit, such as the date and amount of the deposit, a column that displays the undistributed amount of the deposit, and a column that displays the undistributed amount of the deposit. Among these, it includes a column C64 in which the amount to be refunded or transferred is entered using the input device 120. The area 60c includes a control image C65 for selecting either refund or transfer, and input fields C66 and C67 for necessary information. The control image C65 includes a "refund" radio button and a "transfer" radio button, and these can be alternatively selected using the input device 120. When the "refund" radio button is selected, the input field C66 becomes ready for input. Transfer information (bank name, account number, account name, etc.) of the refund destination is input into the input field C66 using the input device 120. When the "Transfer" radio button is selected, the input field C67 becomes ready for input. Bill information (billing number) of the transfer destination is input into the input field C67 using the input device 120.

In the area 60d, a list of the deposits and refunds that are the same as the deposit selected in the area 60b and the same deposit source or the transfer destination input in the area C66 is displayed, among the deposits in the same reservation card.

In the default state shown in FIG. 8, no content is displayed in the area 60e. After a refund request is made by selecting the "refund" radio button and control image C61, and the request is approved by selecting control image C62, the details of the refund entered in areas 60b and 60c are sent from terminal 100. It is sent to the server 200. Based on this, the deposit/withdrawal data generation unit 240 generates deposit data 431 indicating the details of the refund. Then, the distribution unit 250 distributes the deposit indicating the content of the refund to the deposit in which the excess has occurred, and generates distribution data 440 indicating the content of the distribution (see FIG. 11). Then, in the area 60e, as an example shown in FIG. 9, refund information corresponding to the deposit data 431 generated as described above is displayed. This information includes the deposit status, deposit amount, etc. The deposit amount has a negative value corresponding to the refund amount.

After a transfer request is made by selecting the "Transfer" radio button and control image C61, when the request is approved and the process is executed by selecting control images C62 and C63, a notification to that effect is sent from the terminal 100 to the server 200. Sent. Based on this, the distribution unit 250 distributes the excess amount of the deposit to the bill of the transfer destination inputted in the area 60c, and generates distribution data 440 indicating the details of the distribution.

The structure of the sales data 410, deposit/withdrawal data 430, and distribution data 440 stored in the storage unit 210 of FIG. 2 and the details of distribution by the distribution unit 250 will be explained below with reference to FIGS. 10 to 12. do. The tables in FIGS. 10 to 12 represent the contents of sales data 410, deposit/withdrawal data 430, distribution data 440, and bill data 450. In other words, these tables show the correspondence between invoices and sales details or purchase details, and the correspondence between sales details or purchase details and deposit data or payment data associated with the distribution data 440. In the table, the date of each item indicated by sales data 411 and purchase data 412 is a sales date. Further, the date of each item indicated by the deposit data 431 is the date of deposit (for example, the date of transfer in the case of bank transfer).

In generating the distribution data 440, the distribution unit 250 distributes deposits and payments in the following manner. First, we will explain the distribution of deposits. As shown in Figure 10(a), three billing items correspond to three sales items: 1,000 yen on September 1, 2,000 yen on September 5, and 2,000 yen on September 15. Assume that a bill with a total billing amount of 5,000 yen is issued to a customer. Here, as described above, the details of the sales were entered in the sales information area 330 of FIG. 3, and the invoice was issued through the screen IMI 20 of FIG. 5. Assume that 2,000 yen was paid to this bill on July 1, as shown in FIG. 10(a), and that the payment and distribution were inputted through the screen IMI 30 as described above. In this case, the distribution unit 250 distributes the received money in order from the oldest sales date among the undistributed sales items corresponding to the distribution destination invoice. That is, the distribution unit 250 executes the following in order from the sales item on the oldest sales date to the sales item on the newest sales date. (1) If the amount receivable for a sales item is greater than or equal to the undistributed amount received, the entire amount will be allocated to that sales item. (2) If the amount of a sales item is less than the undistributed deposit, the undistributed amount of the undistributed deposit will be allocated to that sales item, and the allocated amount will be removed. Allocate the remaining amount to the next sales item. Repeat (1) and (2) above for allocation of the next sales item and subsequent items.

As a result, in the example of FIG. 10A, a deposit of 2,000 yen due on July 1st is distributed by 1,000 yen to the sales item on September 1st and the sales item on September 5th. In this way, the sales item dated 9/1 is less than the payment received on 7/1, and the total value of the sales items dated 9/1 and the sales item dated 9/5 is greater than or equal to the payment received on 7/1. For this reason, by executing the process (2) above, the entire amount of the deposit due on July 1st is distributed to the two sales items due on September 1st and September 5th. However, since the sales item dated September 5th is 2,000 yen, if 1,000 yen is allocated to this item, 1,000 yen corresponding to the unaccounted amount will be generated at this point for this sales item. . The distribution unit 250 generates distribution data 440 as shown in FIG. 10(a) in accordance with the above distribution details for each deposit. Each distribution item in the distribution data 440 indicates the association between each sales item and the deposit, the amount to be distributed, and has the same date as the date of the deposit.

Thereafter, as shown in FIG. 10(a), it is assumed that 3,000 yen is deposited in response to this bill on August 15th, and that the deposit and distribution are entered through the screen IMI 30 as described above. The distribution unit 250 distributes the deposit of 3,000 yen as described in (1) and (2) above. As a result, 1,000 yen of the 3,000 yen deposit will be allocated to the sales item dated September 5th, which had a balance of 1,000 yen, and 2,000 yen of the 3,000 yen deposit will be distributed to The yen is allocated to the sales items dated 9/15. In this way, the sales item dated 9/5 is less than the payment made on 8/15, and the total value of the sales item dated 9/5 and the sales item dated 9/15 is greater than or equal to the payment made on 8/15. For this reason, by executing the process (2) above, the entire amount of the deposit on August 15th is distributed to the two sales items of September 5th and September 15th. The distribution unit 250 generates distribution data 440 as shown in FIG. 10(a) according to the above distribution details for each deposit. Each distribution item in the distribution data 440 indicates the association between each sales item and the deposit, the amount to be distributed, and has the same date as the date of the deposit.

Note that in this embodiment, among a plurality of sales items corresponding to one invoice, unallocated sales items are arranged in order from the oldest sales date (according to the example in FIG. 10(a)). , sales items for 9/1, 9/5 and 9/15 in Figure 10(a) at the time of deposit on 7/1, and sales items for 9/5 and 9/15 at the time of deposit on 8/15. (sales items) correspond to "1st to nth (n: natural number of 2 or more) breakdown items" in the present invention. In addition, if the processing in (1) above regarding the sales item on the oldest sales date is performed by the distribution means of the present invention, "If the amount of the first sub-item is equal to or greater than the amount of the deposit/withdrawal, then the This corresponds to the process of ``allocating the deposits and withdrawals to the travel fees so that the deposits and withdrawals are distributed to the breakdown items.'' In addition, the processing from (2) onward is performed by the distribution means of the present invention such that the total amount of the 1st to k-1st (k: a natural number satisfying 2≦k≦n) breakdown items is equal to the amount of the deposit and withdrawal. If there is k such that the total amount of the 1st to kth sub-items is greater than or equal to the amount of the deposits and withdrawals, then the deposits and withdrawals are distributed to the 1st to kth sub-items. This corresponds to the process of ``distributing the deposits and withdrawals to the travel fees'' as follows.

Next, payment distribution will be explained. As shown in Figure 10(b), there are three invoices corresponding to three purchase items: 1,000 yen on September 1st, 1,500 yen on 9/5, and 1,500 yen on 9/15. Assume that a supplier issues an invoice consisting of items with a total billing amount of 4,000 yen. Here, as mentioned above, the content of the purchase is input in the sales information area 330 in FIG. 3, and the invoice is sent to the travel business support system 1 in connection with processing through the screen IMI50 in FIG. It has been taken in. As described above, a person in charge of accounting operations or the like performs distribution on this invoice through the screen IMI 50. In the example in Figure 10(b), of the 4,000 yen payment, 1,000 yen goes to the purchase item dated 9/1, 1,500 yen goes to the purchase item dated 9/5, and 1,500 yen goes to the purchase item dated 9/5. 1,500 yen is allocated to each purchase item marked 15. The distribution unit 250 generates distribution data 440 as shown in FIG. 10(b) according to the content of the distribution. Each distribution item in the distribution data 440 indicates the association between each purchase item and payment, the amount to be distributed, and has the same date as the date of payment.

Further, the determining unit 260 calculates the unaccounted amount and the unpaid amount based on the above allocation results by the allocating unit 250. Specifically, the determination unit 260 subtracts the amount of deposit allocated for each sales item from the amount of sales for that sales item, and determines the result as the amount of receivables. If the unaccounted amount is 0 yen, the determining unit 260 determines that payment has been completed for that sales item. Further, the determining unit 260 subtracts the amount of payment allocated for each purchase item from the amount of purchase for that item, and sets the result as the unpaid amount. If the unpaid amount is 0 yen, the determining unit 260 determines that the payment for that purchase item has been completed. Such a function of the determination unit 260 that acquires the deposit/withdrawal status corresponds to the function of the deposit/withdrawal status acquisition means in the present invention.

In the above example, the distribution is made when the deposit and payment match the total amount charged on the invoice, but as shown below, it is also distributed appropriately when the deposit and payment exceed the total amount charged on the invoice. Sorting is performed. FIG. 11 shows a case where the deposit exceeds the total amount of the invoice. In this example, a deposit of 2,000 yen is made on July 1st and a deposit of 5,000 yen is made on August 15th for the sales item indicated by the sales data 411 in FIG. 10(a). It is assumed that the deposit and distribution have been input through the screen IMI 30 as described above. As a result, the first deposit of 2,000 yen will be divided into 1,000 yen each for the sales items dated 9/1 and 9/5, and 1,000 yen of the second deposit of 5,000 yen will be divided into 9/1 and 9/5 sales items. 2,000 yen is allocated to the sales item with /5 and 2,000 yen is allocated to the sales item with 9/15. In other words, even though the deposit on August 15th caused an excess payment of 2,000 yen, which exceeded the total amount of the invoice, distribution to each sales item was executed. Next, it is assumed that the excess deposit of 2,000 yen is refunded through the screen IMI 60 as described above. As a result, the deposit data 431 of -2,000 yen dated 8/30 corresponding to the refund is generated by the deposit/withdrawal data generation unit 240, and the excess 2,000 yen of the deposit dated 8/15 is generated. The distribution unit 250 has generated distribution data 440 for distributing the deposit data 431 of -2,000 yen dated 8/30. By generating and distributing such data, when a deposit exceeds the total amount of the invoice, data with appropriate content is generated to match the processing of refunding the excess amount, and the distribution is executed appropriately. be done.

Furthermore, Figures 12(a) and 12(b) show a situation in which sales and purchases have not been received or paid, and travel fees are completely unreceivable and unpaid. There is. In this case, the distribution data 440 is not generated for the sales data 411 and purchase data 412 indicating the sales and purchases, and based on this, the determination unit 260 determines the complete accrued and unpaid information for each invoice. Determine if the person is in a situation where the payment is due.

According to the embodiment described above, each deposit or payment is distributed to the sales data 410 regardless of whether there is a difference between the deposit or payment and the total billed amount in the invoice. Based on the distribution data 440 and the sales data 410 that have been distributed to the sales and sales data 410, it is possible to determine whether the receipts and payments for sales and purchases have been completed, and how much is the amount receivable or unpaid. A determining unit 260 determines the status of deposits and withdrawals. In this way, receipts and payments that have a discrepancy with the total billed amount on the invoice are managed by being divided into sales and purchases. Therefore, there is no need to manage deposits and withdrawals with such differences using a separate ledger or a separate system. Therefore, management operations related to deposits and withdrawals are less likely to become complicated.

Furthermore, in this embodiment, sales and purchases are managed in units of details, that is, sales items and purchase items, and deposits and payments are distributed in detail to sales items and purchase items. Therefore, payment of deposits and withdrawals is performed accurately.

<Modified example>
Although the above is a description of the preferred embodiments of the present invention, the present invention is not limited to the above-described embodiments, and various modifications may be made within the scope described in the means for solving the problems. It is possible. Modifications of the above-described embodiment will be described below.

For example, in the embodiment described above, a bill with a positive value is issued to the customer through the screen IMI30 in FIG. However, a bill with a negative value may be issued to the customer. Such invoices are issued for various purposes, including to apply discounts. In this case, it is conceivable that a refund will be issued in accordance with the invoice. Therefore, in the screen IMI60 of FIG. 8, which consists of GUI images related to refunds and transfers, in addition to or in place of unallocated deposits, issued negative values are included as elements in the list of candidates for processing such as refunds. Items related to the bill may be displayed in the area 60b.

Further, in the above-described embodiment, the person in charge of the reservation business accepts the deposit at the counter and inputs the details of the deposit through the screen IMI 30. However, the travel business support system 1 may be configured to accept other forms of deposit. For example, when a large number of deposits are made by transfer and a data file showing a list of the deposits is received from a customer, the travel business support system 1 may be configured to import such data files and automatically distribute them to sales items. . In this case, it is preferable that the travel business support system 1 is configured to acquire which deposit corresponds to which sales item based on the information regarding the deposit indicated by the data file. For example, the bill data 450 may include account data indicating a transfer account (virtual account, etc.), and the data file may also include such account data for each deposit. Thereby, by searching for the bill indicated by the bill data 450 using the account data as a key, it is possible to specify the bill corresponding to each deposit.

Furthermore, in the embodiments described above, the travel reservation information input system according to the present invention is realized using a plurality of computers including one or more terminals 100 and servers 200. However, it may also be realized by one computer. Furthermore, one or more terminals 100 and servers 200 are connected to each other via the Internet. However, they may be connected to each other through a communication network other than the Internet, such as a LAN (Local Area Network).

Further, in the above-described embodiment, the functions of the terminal 100 are realized on a so-called browser basis using the browser 130, which is a general-purpose application. However, instead of being browser-based, it may be implemented using an application dedicated to this system.

Furthermore, in the embodiment described above, when the deposit exceeds the total amount of the bill, distribution as shown in FIG. 11 is performed. However, a similar allocation may be performed if the payment exceeds the total amount of the invoice from the supplier. For example, in this case, the following allocation may be performed. First, the distribution unit 250 distributes a portion of the payment to the purchase items corresponding to the invoice from the supplier. For the excess amount of payment, new purchase data 412 indicating the purchase amount for the excess amount is generated by the sales data generation unit 230, and payment is made for this new purchase data 412. The excess amount is distributed by the distribution section 250. In addition, if a refund is subsequently issued by the supplier and a corresponding invoice with a negative value is issued by the supplier, the negative amount will be paid in response to the refund invoice. and distribution may be input into the system. The above-mentioned processing related to the refund of the excess amount of payment corresponds to the processing by the excess amount processing means in the present invention.

1 Travel business support system 100 Terminal 110 Display 120 Input device 130 Browser 140 Printing device 200 Server 210 Storage section 220 Reservation data generation section 230 Sales data generation section 240 Deposit/withdrawal data generation section 250 Distribution section 260 Discrimination section 270 Bill data Generation unit 410 Sales data 411 Sales data 412 Purchase data 420 Reservation data 430 Deposit/withdrawal data 431 Deposit data 432 Payment data 440 Distribution data 450 Invoice data

Claims (4)

a travel fee data storage means for storing travel fee data indicating the contents of the travel fee;
Deposit/withdrawal data acquisition means for acquiring deposit/withdrawal data indicating details of deposit/withdrawal made in accordance with an invoice issued regarding the travel fee;
Every time the input/withdrawal data acquisition means acquires the input/withdrawal data, the input/withdrawal data indicated by the acquired input/withdrawal data is added to the travel fee data stored in the travel fee data storage means. Allocating means for allocating regardless of whether or not the total billed amount in the invoice is different from the amount of the deposited and withdrawn money;
a deposit/withdrawal status acquisition means for acquiring the status of deposits/withdrawals for the travel fee based on the amount of the deposit/withdrawal distributed to the travel fee by the distribution unit and the amount of the travel fee ;
The travel fee data includes purchase data indicating the unit price and quantity of purchase corresponding to the content of purchase,
The distribution means distributes a payment according to the content of an invoice from a supplier for a purchase to the purchase data, and in the distribution, the amount of the invoice from the supplier is allocated to the purchase data. If the unit price of the purchase indicated by the purchase data is different from the purchase price indicated by the purchase price, the former of adjusting the unit price of the purchase indicated by the purchase data, adding the purchase data indicating a new purchase, or both A travel business support system characterized by being executed . a travel fee data storage means for storing travel fee data indicating the contents of the travel fee;
Deposit/withdrawal data acquisition means for acquiring deposit/withdrawal data indicating details of deposit/withdrawal made in accordance with an invoice issued regarding the travel fee;
Every time the input/withdrawal data acquisition means acquires the input/withdrawal data, the input/withdrawal data indicated by the acquired input/withdrawal data is added to the travel fee data stored in the travel fee data storage means. Allocating means for allocating regardless of whether or not the total billed amount in the invoice is different from the amount of the deposited and withdrawn money;
a deposit/withdrawal status acquisition means for acquiring the status of deposits/withdrawals for the travel fee based on the amount of the deposit/withdrawal distributed to the travel fee by the distribution unit and the amount of the travel fee ;
The travel fee data indicates the contents of the 1st to nth (n: natural number of 2 or more) breakdown items that are the breakdown of the amount of the travel fee that has not been distributed by the distribution means,
The allocating means is
If the amount of the first sub-item is greater than or equal to the deposit/withdrawal amount, the deposit/withdrawal is allocated to the first sub-item, and ≦N (a natural number satisfying n), the total amount of the sub-items is less than the amount of the deposit/withdrawal, and the total amount of the 1st to k-th sub-items is greater than or equal to the amount of the deposit/withdrawal. The travel business support system is characterized in that the input and withdrawal funds are allocated to the travel fee data so that the input and withdrawal fees are allocated to the first to kth breakdown items. 3. The method according to claim 1 or 2 , further comprising an excess amount processing means for processing a refund regarding the excess amount when the amount of deposits and withdrawals exceeds the total billing amount. The travel business support system described. When the amount of deposits and withdrawals exceeds the total billing amount, the processing by the excess amount processing means generates the deposit and withdrawal data indicating a negative amount corresponding to the excess amount. In addition, the allocating means allocates the deposit/withdrawal data indicating the negative amount to the deposit/withdrawal data indicating the deposit/withdrawal in which the excess amount has occurred . Travel business support system.

Images