Commodity sales data processor and program
The product sales data processing device addresses the challenge of handling multiple tax rates for alcoholic beverages by identifying unregistered products and calculating liquor tax exemptions, enhancing efficiency and compliance in tax-exempt sales.
Patent Information
- Application Number
- JP2024166462
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2024-09-25
- Publication Date
- 2024-12-05
- Estimated Expiration
- 2037-10-27
AI Technical Summary
Existing systems struggle to efficiently process sales data for tax exemptions on alcoholic beverages with varying tax rates, particularly in duty-free shops and manufacturing facilities, due to the complexity of handling multiple types of alcoholic beverages with different tax amounts.
A product sales data processing device and program that includes a POS terminal equipped with a detection mechanism to identify unregistered alcoholic beverages and facilitate liquor tax exemption processing, allowing for accurate calculation and display of tax exemption amounts, even for unregistered products.
Enables efficient and accurate tax exemption processing for alcoholic beverages with different tax rates, reducing employee workload and ensuring compliance with the new liquor tax exemption system, particularly in environments with fluctuating product offerings.
Smart Images

Figure 2024169678000001_ABST
Abstract
Description
[Technical field]
[0001] An embodiment of the present invention relates to a product sales data processing device and a program. [Background technology]
[0002] There is a so-called tax exemption system that exempts export goods sales outlets (duty-free shops) from the consumption tax on goods when they sell them to non-residents such as foreign tourists. Furthermore, from October 1, 2017, a system is scheduled to be implemented that exempts alcoholic beverages sold to foreign tourists visiting Japan from the liquor tax in addition to the consumption tax.
[0003] The new liquor tax exemption system applies to retailers within the liquor manufacturing facility, such as a sake brewery. Even if the liquor is sold at a retailer within the liquor manufacturing facility, the liquor tax exemption only applies to the company's own products. Furthermore, there are several types of liquor, including sparkling liquor, brewed liquor, distilled liquor, and mixed liquor, and different tax rates (amounts of liquor tax) are determined for each type.
[0004] Therefore, retailers offering liquor tax-exempt products need to process sales data appropriately according to the multiple alcoholic beverages produced in different factories and subject to different liquor tax rates that are included in the multiple products that foreign tourists visiting Japan are attempting to purchase. [Prior art documents] [Patent documents]
[0005] [Patent Document 1] JP 2016-057781 A Summary of the Invention [Problem to be solved by the invention]
[0006] The problem to be solved by the present invention is to provide a product sales data processing device and program capable of executing sales data processing related to tax exemption when multiple types of products with different tax rates are mixed. [Means for solving the problem]
[0007] According to an embodiment, the product sales data processing device has a first input means, a detection means, and a second input means. The first input means inputs a product code. The detection means detects an instruction to execute tax exemption processing for a product corresponding to the product code. When a product code of an unregistered liquor for which a liquor tax code is not registered is input by the first input means, the second input means inputs product information required for liquor tax exemption processing to calculate a liquor tax exemption amount for the unregistered liquor after detecting the instruction to execute the tax exemption processing. [Brief description of the drawings]
[0008] [Figure 1] 1 is a block diagram showing a system configuration of a checkout system provided with a product sales data processing device according to an embodiment of the present invention. [Diagram 2] 5A and 5B are diagrams showing an example of product master data stored in a server and a POS terminal in the embodiment; [Diagram 3] FIG. 4 is a diagram showing an example of liquor tax data stored in a server in the embodiment. [Figure 4] 5 is a flowchart showing an example of the operation of the POS terminal in the embodiment. [Diagram 5] 5 is a flowchart showing an example of a liquor tax calculation process in the embodiment. [Figure 6] 10 is a flowchart showing an example of a liquor tax confirmation process in the present embodiment. [Figure 7] FIG. 11 is a diagram showing an example of a confirmation screen for a tax exemption amount in the embodiment. [Figure 8] FIG. 13 is a diagram showing an example of a screen for calculating a liquor tax exemption amount in the embodiment. [Figure 9] FIG. 13 is a diagram showing an example of a screen for confirming the liquor tax exemption amount in the embodiment. [Figure 10] 11A and 11B are diagrams showing an example of a transaction receipt and purchase details when tax exemption processing is performed in this embodiment. [Figure 11]FIG. 13 is a diagram showing an example of a tax-free export goods purchase record slip printed when tax-free processing is performed in this embodiment. [Figure 12] FIG. 13 is a diagram showing an example of a pledge for purchasing export duty-free goods printed when the tax-free process is performed in this embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0009] Hereinafter, the present embodiment will be described with reference to the drawings.
[0010] FIG. 1 is a block diagram showing the system configuration of a checkout system provided with a product sales data processing device according to this embodiment.
[0011] In FIG. 1, the checkout system includes a plurality of POS terminals 10 (10-1, 10-2, ..., 10-n) and a server 12 (server 12) connected to each other so as to be able to communicate with each other via a network such as a LAN (Local Area Network) 14. The product sales data processing device of this embodiment will be described as being realized by a POS (Point Of Sales) terminal 10 used in a store that sells alcoholic beverages. The POS terminal 10 is provided with a function capable of executing product data processing corresponding to liquor tax exemption. Note that tax exemption on product sales applies not only to liquor tax but also to other taxes such as consumption tax, but the following embodiment will mainly focus on liquor tax exemption.
[0012] The product sales data processing device may be configured with one POS terminal 10 and server 12, or may be configured with a plurality of POS terminals 10 and servers 12.
[0013] The POS terminal 10 has computer functions implemented, and includes a processor (CPU (central processing unit), etc.) 11a, a ROM (read-only memory) 11b, a RAM (random-access memory) 11c, a memory unit 11d, a change machine 11e, a communication unit 11f, a scanner 11g, a touch panel 11h, a keyboard 11j, a printer 11k, a card reader / writer 11m, a display 11n, and a passport reader 11p.
[0014] The processor 11a is a circuit for controlling each part to realize various operations of the POS terminal 10 based on an operating system, middleware, and application programs stored in the ROM 11b and the RAM 11c.
[0015] The ROM 11b and the RAM 11c store various programs executed by the processor 11a, as well as data referenced by the processor 11a when performing various processes. For example, the RAM 11c stores a registered product table in which information on products to be purchased by customers is registered when a process for registering product information is executed. The RAM 11c also stores data on screens to be displayed on the touch panel 11h and the display 11n.
[0016] The programs executed by the processor 11a include a control program for executing a scanning process for inputting product information (product code, etc.) through the scanner 11g, a product registration process for generating transaction information used in payment processing according to product information registered in the registered product table, and a payment processing based on the transaction information. In addition, a program for executing a tax exemption process for tax exemption of products registered by the product registration process is included. The tax exemption process includes not only consumption tax but also liquor tax exemption process corresponding to a system for exempting sales stores within liquor manufacturing plants from liquor tax (hereinafter referred to as the new liquor tax exemption system). By executing the control program, the processor 11a causes the touch panel 11h to display a screen for processing related to the sale of products (including registration processing and payment processing).
[0017] The storage unit 11d stores data used by the processor 11a when performing various processes, or data generated by the processes of the processor 11a. The storage unit 11d stores product master data 21 (described later) used in product registration processes and the like, and liquor tax data 22 (described later) referenced in liquor tax processes, which are received from the server 12. For example, a hard disk drive (HDD) or a solid state drive (SSD) can be used as the storage unit 11d.
[0018] The change machine 11e receives inserted coins and bills, and dispenses coins and bills as change. The communication unit 11f controls communication with the server 12 and other POS terminals 10 via the LAN 14.
[0019] The scanner 11g reads product information by, for example, optical scanning and inputs a product code unique to the product. The scanner 11g may be a fixed or handheld two-dimensional code scanner, or may be a type that identifies products using image recognition technology from a photographed image of the product. Also, the scanner 11g may be of one type or of multiple types.
[0020] The touch panel 11h is a device on which an employee (cashier) performs input operations, and includes a display device and a touch sensor. The display device displays any screen, such as a GUI (Graphical User Interface) screen. For example, the display device displays a registration screen (product list screen) including a list of transaction information (product name, price, etc.) related to products registered as purchase targets and a subtotal amount, a menu including a plurality of keys corresponding to each of various functions, and an operation screen including keys for inputting commands for executing various functions. As the display device, for example, a well-known device such as a color LCD (Liquid Crystal Display) can be used. The touch sensor is placed over the display surface of the display device. The touch sensor detects the position of the operator's touch on the display surface of the display device and sends the position information to the processor 11a. As the touch sensor, a well-known device can be used.
[0021] The keyboard 11j is a device on which an employee (cashier) performs input operations, and has, for example, an arrangement of multiple keys, each of which is assigned a specific function.
[0022] Printer 11k is, for example, a thermal printer or a dot-matrix printer, and issues transaction receipts and the like on which transaction details such as product name, unit price, total amount, and information related to tax exemption including liquor tax are printed by printing various character strings, images, code patterns (barcodes, two-dimensional codes, etc.) on receipt paper.
[0023] The card reader / writer 11m reads data recorded on the card and writes data to the card. The cards include payment cards such as credit cards, debit cards, electronic money cards, and prepaid cards, as well as various cards that record information related to payment processing, such as member cards and point cards. The card reader / writer 11m may be a magnetic, contact, or non-contact device, or may include multiple types of devices.
[0024] The display 11n is a device used to provide information to customers, for example, and may be a well-known device such as a color LCD.
[0025] The passport reader 11p is a reading device for reading information recorded on a passport to confirm that the person is eligible for tax exemption when tax exemption processing is performed for a foreign tourist visiting Japan. The passport reader 11p reads character information optically or reads information from the storage medium (IC) of an electronic passport.
[0026] The server 12 includes a processor (such as a CPU) 21a, a ROM 21b, a RAM 21c, a storage unit 21d, a communication unit 21f, a keyboard 21g, a display 21h, and a communication unit 21p. The server 12 is an information processing device having the functions of a computer.
[0027] The processor 21a is a circuit for controlling each unit to realize various operations of the server 12 based on an operating system, middleware, and application programs stored in the ROM 21b and the RAM 21c.
[0028] The ROM 21b and the RAM 21c store programs such as an operating system, middleware, and application programs executed by the processor 21a, as well as data referenced by the processor 21a when performing various processes.
[0029] The programs executed by the processor 21a include a program for controlling the processes executed in the multiple POS terminals 10, and the like.
[0030] The storage unit 21d stores data used by the processor 21a when performing various processes, or data generated by the processes in the processor 21a. For example, an HDD or an SSD can be used as the storage unit 21d. The storage unit 21d stores product master data 21, liquor tax data 22, sales management data (sales data (including product name, price, time of sale, number of sales, etc.), inventory data, etc.) used in the process for selling products in the POS terminal 10.
[0031] The communication unit 21f controls communication with the POS terminal 10 and the like via the LAN 14. The keyboard 21g inputs data to the server 12 in response to operations by employees. Note that the server 12 may be provided with an input device other than the keyboard 21g (such as a touch panel or a mouse). The display 21h displays a screen according to the POS function executed by the processor 21a. The communication unit 21p controls communication with external devices such as servers (websites, etc.) via an external network such as the Internet.
[0032] FIG. 2 is a diagram showing an example of the product master data 21 stored in the server 12 and the POS terminal 10 in this embodiment. As shown in FIG. 2, the product master data 21 registers product classification, product name, price, tax-free type, etc. in association with a product code unique to the product. Product classification is information for classifying products, and is divided into major, medium, and minor categories, for example. Product classification includes data indicating the classification of alcoholic beverages. Price may be the price excluding consumption tax, the price including consumption tax, or the price excluding liquor tax. Tax-free type indicates whether the item (product) subject to tax-free is a general item or a consumable. Consumable items include alcoholic beverages. Furthermore, for alcoholic beverages included in general items, the product master data 21 registers each data of tax-free exemption flag (exemption data), liquor tax code, and volume for liquor tax exemption processing in accordance with the new liquor tax exemption system.
[0033] The tax exemption flag is data indicating that even if the liquor is subject to liquor tax exemption, it is not subject to liquor tax exemption (for example, setting the tax exemption flag to "1" indicates that it is not subject to liquor tax exemption). In other words, the new liquor tax exemption system is a system that applies to retailers within liquor manufacturing plants such as sake breweries, and liquor tax exemption is applied only to the company's own products. For this reason, even if the same type of liquor is sold at a retailer within the manufacturing plant, liquor manufactured at other manufacturing plants must be exempt from liquor tax exemption. For this reason, the tax exemption flag is set to "1" for liquor that is not subject to liquor tax exemption (liquor tax calculation). The liquor tax code is set to refer to the tax rate, etc. according to the liquor of the product from the liquor tax data 22. The volume is referred to in order to calculate the liquor tax amount for each type of liquor of the same type.
[0034] In the POS terminal 10 of this embodiment, a first processing method and a second processing method are used for the liquor tax exemption processing corresponding to the new liquor tax exemption system. The first processing method is a method in which the data of the tax exemption flag, liquor tax code, and volume of liquor (product) that is subject to liquor tax exemption is registered in advance in the product master data 21. The second processing method is a method in which the data of the tax exemption flag, liquor tax code, and volume are not registered in advance in the product master data 21, and data required for the liquor tax exemption processing corresponding to the new liquor tax exemption system is input by an employee's operation. Liquor for which the data of the tax exemption flag, liquor tax code, and volume are not registered in advance in the product master data 21 will be described as an unregistered liquor.
[0035] In the first processing method, when selling alcoholic beverages to foreign tourists visiting Japan, accounting processing corresponding to the liquor tax exemption system corresponding to the new liquor tax exemption system can be performed without increasing the workload of employees who operate the POS terminal 10. In the second processing method, even if a retailer in a liquor manufacturing facility such as a sake brewery is unable to maintain the product master data 21 due to a large variation in the types of alcoholic beverages handled or a large variety of alcoholic beverages, accounting processing corresponding to the liquor tax exemption system corresponding to the new liquor tax exemption system corresponding to individual handling is possible when selling alcoholic beverages to foreign tourists visiting Japan.
[0036] FIG. 3 is a diagram showing an example of the liquor tax data 22 stored in the server 12 in this embodiment. The liquor tax data 22 indicates liquor information used in liquor tax exemption processing, and corresponds to a unique liquor tax code for each type of liquor, and data indicating the amount of liquor tax (tax rate), the name (screen) to be used when displayed on the screen, and the name (printing) to be used when printed on a receipt are associated with each type of liquor. For example, a different tax rate (tax amount per kl) is set for each of 12 types of liquor classifications. For example, for the liquor classification "happoshu (malt ratio 25 to less than 50%)", the tax rate is set to "178,125 yen" per kl, and for "seishu", the tax rate is set to "120,000 yen" per kl.
[0037] The liquor tax data 22 refers to each data including the tax rate corresponding to the liquor based on the liquor tax code of the product code (product) set in the product master data 21.
[0038] Next, the operation of the POS terminal 10 in this embodiment will be described. 4, 5 and 6 are flowcharts showing an example of the operation of the POS terminal 10 in this embodiment.
[0039] First, product registration of a product that a customer is going to purchase is performed in the POS terminal 10. When the barcode attached to the product is scanned by the scanner 11g (Act 1), the processor 11a executes product registration processing based on the product code indicated by the barcode (Act 2).
[0040] In the product registration process, the processor 11a searches the product master data 21 previously acquired from the server 12 using the product code as a key, extracts product information for the product code (product name, product classification, tax-free type, price, etc.), and records it in the registered product table.
[0041] If multiple units of the same product are to be purchased, numerical data indicating the number (quantity) is input by operating the numeric keys on the touch panel 11h or the keyboard 11j. When the numerical data is input after the product code is input, the processor 11a records product information corresponding to the number (quantity) indicated by the numerical data in the registered product table.
[0042] The processor 11a displays purchase information (eg, product name, tax-free type, price, quantity (amount), etc.) from the product information on, for example, a touch panel 11h for employees and a display 11n for customers.
[0043] The processor 11a also determines whether the product corresponding to the product code is an unregistered alcoholic beverage. That is, the processor 11a determines that the product is an unregistered alcoholic beverage when the product classification corresponding to the product code is alcoholic beverage and at least the liquor tax code is not registered among the tax exemption flag, liquor tax code, and volume. Note that if the tax exemption flag is set to "1", the product is not subject to liquor tax exemption under the new liquor tax exemption system, so the processor 11a does not determine that the product is an unregistered alcoholic beverage.
[0044] When the product (alcoholic beverage) whose product code has been read is determined to be an unregistered alcoholic beverage (Act 3, Yes), the processor 11a stores the corresponding product (alcoholic beverage) as an unregistered alcoholic beverage in the RAM 11c, and displays the fact that the product is an unregistered alcoholic beverage together with the product name of the corresponding product on the touch panel 11h. In other words, by displaying the fact that the product is an unregistered alcoholic beverage to the employee, the employee is notified that the alcoholic beverage requires the entry of data required for the liquor tax exemption processing (second processing method) under the new liquor tax exemption system. Note that the fact that the liquor is an unregistered alcoholic beverage may be notified not only by display on the touch panel 11h, but also by a predetermined sound.
[0045] Similarly, if there are other products to be purchased, the barcodes attached to the products are scanned in sequence and product registration processing is executed. If there is a product that is determined to be an unregistered alcoholic beverage, the corresponding product name is displayed on the touch panel 11h. If there are multiple unregistered alcoholic beverages, the processor 11a may display a list of the multiple unregistered alcoholic beverages on the touch panel 11h.
[0046] Here, when it is detected that the subtotal key has been operated (Act 6, Yes), if the tax exemption process has not been executed by operating the tax exemption key (Act 20, No), the processor 11a executes a settlement process without tax exemption (Act 8). That is, the processor 11a generates transaction information for the purchase target product registered in the registered product table, and processes the settlement using cash or a settlement card (credit card, etc.) for the transaction information. When the settlement is completed, the processor 11a causes the printer 11k to print the transaction details on receipt paper, and issues a transaction receipt and purchase details.
[0047] On the other hand, when tax exemption processing is required, the employee operates the tax exemption key. When the processor 11a detects that the tax exemption key has been operated (Act 5, Yes), the processor 11a executes a tax exemption confirmation calculation to display the amount, etc., to be displayed on the tax exemption amount confirmation screen based on the product information of the product to be purchased registered in the registered product table (Act 10). The processor 11a displays the tax exemption amount confirmation screen on the touch panel 11h based on the calculation result of the tax exemption confirmation calculation (Act 11).
[0048] 7 is a diagram showing an example of a confirmation screen for the tax exemption amount in this embodiment. Hereinafter, the confirmation screen for the tax exemption amount will be described as a tax exemption confirmation pop-up D1.
[0049] The tax exemption confirmation pop-up D1 is provided with, for example, a general goods total amount display area 31, a general goods shortage amount display area 32, a consumables total amount display area 33, a consumables shortage amount display area 34, a liquor shortage amount display area 35, a tax exemption amount display area 36, and a liquor tax exemption amount display area 37. The general goods total amount display area 31 displays the total amount of general goods. The general goods shortage amount display area 32 displays the amount of general goods items up to the tax exemption completion date. The consumables total amount display area 33 displays the total amount of consumable goods. The consumables shortage amount display area 34 displays the amount of consumable goods items up to the tax exemption completion date. The liquor shortage amount display area 35 displays the price of liquor that meets the shortage amount up to the tax exemption completion date for consumables. The tax exemption amount display area 36 displays the sum of the tax exemption amounts for general goods and consumables (total tax exemption amount). The liquor tax exemption amount display area 37 displays the liquor tax exemption amount under the new liquor tax exemption system for the liquor included in the consumable item.
[0050] General goods and consumables are basically tax-free if the total amount after tax exemption is equal to or exceeds the tax-free threshold (5,000 yen). Therefore, if the total amount after tax exemption does not reach the tax-free threshold, the shortfall is displayed in the general goods shortage display area 32 and the consumable goods shortage display area 34, respectively, and the employee can inform the customer of the amount required to reach the tax-free threshold. This allows the employee to encourage the customer to purchase more products. Also, the customer can follow the advice from the employee and purchase products up to the tax-free threshold, thereby enjoying the benefits of tax exemption.
[0051] Furthermore, the tax-free confirmation pop-up D1 displays in the liquor shortage display area 35 the amount required to make up the shortfall up to the tax-free standard amount by purchasing alcohol. The liquor tax is included in the price of alcohol. Therefore, even if the total amount of consumables reaches the tax-free standard amount by purchasing additional items based on the price of alcohol, it may happen that the tax-free standard amount will not be reached once the liquor tax is exempted. For this reason, by displaying the shortfall up to the tax-free standard amount (tax-free standard amount) when purchasing alcohol in the liquor shortage display area 35, employees can reliably inform customers of the amount of alcohol required up to the tax-free standard amount.
[0052] The amounts displayed in the general goods shortage display area 32, the consumables shortage display area 34, and the alcohol shortage display area 35 do not need to be the exact amount up to the tax-free standard amount, and may be amounts up to the tax-free standard amount, for example, amounts less than 10 yen may be rounded up to the nearest 10 yen.
[0053] The tax-free amount display area 36 displays the tax-free amount calculated when at least one of the general goods and consumables reaches the tax-free standard amount. The liquor tax-free amount display area 37 displays the liquor tax-free amount calculated by the liquor tax-free processing when the application of the liquor tax-free corresponding to the new liquor tax-free system is instructed by operating the liquor tax-free button 40 described later.
[0054] Furthermore, the tax exemption confirmation popup D1 has a compulsory tax exemption button 38 corresponding to general goods, a compulsory tax exemption button 39 corresponding to consumables, and a liquor tax exemption button 40 corresponding to alcoholic beverages. The compulsory tax exemption button 38 is a button for instructing to process tax exemption for general goods regardless of whether the total amount has reached the tax exemption threshold amount. The compulsory tax exemption button 39 is a button for instructing to process tax exemption for consumables regardless of whether the total amount has reached the tax exemption threshold amount.
[0055] The forced tax exemption button 38 and the forced tax exemption button 39 are buttons for calculating the tax exemption amount for the product currently being purchased, for example. The liquor tax exemption button 40 is a button for instructing the application of liquor tax exemption corresponding to the new liquor tax exemption system and for instructing the execution of liquor tax exemption processing. The detailed processing when the liquor tax exemption button 40 is operated will be described later.
[0056] The tax exemption confirmation pop-up D1 is provided with a Confirm button 41 and a Cancel button 42. The Confirm button 41 is a button for instructing to confirm the tax exemption amount displayed in the tax exemption amount display area 36 and the liquor tax exemption amount display area 37. The Cancel button 42 is a button for instructing to cancel the application of the tax exemption.
[0057] When the total amount of the general goods displayed in the general goods total amount display area 31 does not reach the tax exemption standard amount, the processor 11a detects an input operation to the forced tax exemption button 38 (Act 12, Yes), and executes tax exemption calculation processing for the general goods currently being purchased (Act 13). The processor 11a displays the tax exemption amount calculated by the tax exemption calculation processing in the tax exemption amount display area 36. If the tax exemption amount corresponding to a consumable item is already displayed in the tax exemption amount display area 36, the processor 11a displays the total amount added to the tax exemption amount corresponding to the consumable item.
[0058] Similarly, when the processor 11a detects an input operation to the forced tax exemption button 39 (Act 12, Yes) when the total amount of the consumable products displayed in the consumable total amount display area 33 has not reached the tax exemption standard amount, the processor 11a calculates the tax exemption amount for the consumable products currently being purchased and displays it in the tax exemption amount display area 36. Similarly, when the tax exemption amount corresponding to the general goods is previously displayed in the tax exemption amount display area 36, the processor 11a displays the total amount added to the tax exemption amount corresponding to the general goods.
[0059] Next, when the processor 11a detects an input operation to the liquor tax exemption button 40 (Act 14, Yes), it determines whether or not an unregistered liquor is stored in the RAM 11c. If an unregistered liquor is stored in the currently selected product (Act 15, Yes), the processor 11a executes a liquor tax calculation process (a second processing method) for calculating the liquor tax exemption amount for the unregistered liquor (Act 16).
[0060] FIG. 5 is a flowchart showing an example of the liquor tax calculation process in this embodiment. When the processor 11a starts the liquor tax calculation process, the processor 11a causes the touch panel 11h to display a screen for calculating the liquor tax exemption amount (Act 31).
[0061] Fig. 8 is a diagram showing an example of a screen for calculating the liquor tax exemption amount in this embodiment. Hereinafter, the screen for calculating the liquor tax exemption amount will be described as the liquor tax exemption pop-up D2 (liquor tax exemption pop-up 1). In the liquor tax exemption pop-up D2, the liquor tax exemption amount can be calculated according to the designation of the liquor category of unregistered liquor, the volume of the liquor, and the quantity of the liquor input by the employee's input operation. In the liquor tax calculation process, the volumes of multiple liquor categories (liquor tax codes) of liquor (products) to be purchased are added up to calculate the liquor tax amount for each liquor tax code, and the liquor tax amounts for each liquor tax code are added up to calculate the liquor tax exemption amount (total liquor tax amount).
[0062] The liquor tax exemption pop-up D2 is provided with, for example, liquor category display areas 51-1, 51-2, 51-3, 51-4, 51-5, and 51-6 corresponding to a plurality of liquor categories. Note that only liquor category display areas 51-1 to 51-6 corresponding to six of the 12 liquor categories are displayed on one screen of the liquor tax exemption pop-up D2. Depending on the operation of the up button 56A or the down button 56B, the liquor category display areas corresponding to the remaining six liquor categories are displayed.
[0063] Each of the liquor category display areas 51-1 to 51-6 is provided with an liquor category name display area 52, a tax rate display area 53, a volume display area 54, and a liquor tax amount display area 55.
[0064] The name of the alcoholic beverage category is displayed in the alcoholic beverage category name display area 52. The alcoholic beverage categories include sparkling alcoholic beverages, happoshu (malt ratio 25 to less than 50%), happoshu (malt ratio less than 25%), other sparkling alcoholic beverages, brewed alcoholic beverages, sake, fruit liquor, distilled alcoholic beverages, whiskey, brandy, spirits, mixed alcoholic beverages, synthetic sake, sweet fruit liquor, and liqueur.
[0065] The tax rate display area 53 displays the tax rate (tax amount per 1 kl) for each liquor category recorded in the liquor tax data 22. The volume display area 54 displays the total volume of the liquors of the same liquor category to be purchased. The liquor tax amount display area 55 displays the liquor tax amount corresponding to the liquor category, calculated based on the tax rate and the combined volume displayed in the volume display area 54.
[0066] The liquor tax exemption pop-up D2 also has a total volume display area 57, a number of liquor items display area 58, and a total liquor tax amount display area 59. The total volume display area 57 displays the total of the volumes (total volume) displayed in the capacity display area 54 corresponding to all liquor categories. The number of liquor items display area 58 displays the number of liquor items (products) that are subject to liquor tax exemption. The total liquor tax amount display area 59 displays the total of the liquor tax amounts (total liquor tax amount) displayed in the liquor tax amount display area 55 corresponding to all liquor categories.
[0067] Furthermore, the liquor tax exemption pop-up D2 is provided with a numerical value input area 60 for receiving input operations, a subtraction button 61, a confirmation button 62, and a cancel button 63. At the bottom of the liquor tax exemption pop-up D2, a message display area 64 is provided for displaying messages for guiding the input operations. The numerical value input area 60 includes number buttons "00" and "0" to "9," a clear button for instructing to clear the input made by operating the number buttons, and an enter button for instructing to confirm the input made by operating the number buttons. The subtraction button 61 is a button for instructing to subtract the volume and quantity already input.
[0068] First, the processor 11a acquires liquor information from the liquor tax data 22, displays the names of liquor categories in the liquor category name display area 52 of the liquor tax exemption pop-up D2, and displays the tax amount in the tax rate display area 53 according to each liquor category. Any of the liquor category name display areas 52 corresponding to a plurality of liquor categories can be arbitrarily designated by a touch operation. The processor 11a displays a message such as "Please select a liquor category" in the message display area 64.
[0069] The employee, for example, refers to the list of unregistered alcoholic beverages displayed on touch panel 11h and confirms the alcoholic beverage category that corresponds to the unregistered alcoholic beverage. Then, the employee touches any of the alcoholic beverage category name display areas 52 that correspond to the corresponding alcoholic beverage category. In response to the touch operation on the alcoholic beverage category name display area 52, processor 11a selects the alcoholic beverage (alcoholic beverage category) that is the subject of the liquor tax calculation. Next, processor 11a displays a message in message display area 64, for example, "Please enter the volume."
[0070] The employee can input a value indicating the volume of one unit of unregistered alcoholic beverage (product) by operating the number buttons in the value input area 60, and can confirm the input by operating the Enter button. The processor 11a detects the input operation of the number buttons and the Enter key in the value input area 60, and inputs a value indicating the volume according to the input operation (Act 34). The processor 11a also displays a message in the message display area 64, such as "Please enter the quantity."
[0071] Next, the employee can input the quantity of the unregistered alcoholic beverage by operating the numeric value input area 60 in the same manner as described above. For example, if the unregistered alcoholic beverage is a sparkling type (beer) and the employee is trying to purchase a case of six bottles, the volume of one bottle is input, and then the quantity "6 bottles" is input. The processor 11a inputs a numeric value indicating the quantity of the unregistered alcoholic beverage in response to the input operation in the numeric value input area 60 (Act 35).
[0072] When a numerical value indicating the quantity is input following the volume, the processor 11a calculates the volume of the alcoholic beverage by multiplying the volume by the quantity, and displays the volume according to the input volume and the numerical value in the volume display area 54 of the liquor tax exemption pop-up D2. If a volume that has already been input is displayed, the new volume is added to the previously input volume and displayed.
[0073] In addition, the processor 11a calculates the amount of liquor tax for the liquor category subject to the liquor tax calculation, based on the tax rate, volume, and value of the liquor category subject to the liquor tax calculation (Act 36). The processor 11a displays the amount of liquor tax obtained by the calculation in the liquor tax amount display area 55. If a liquor tax amount that has already been input is displayed, the amount of liquor tax obtained by the calculation is added to the amount of liquor tax that has already been calculated and displayed.
[0074] The processor 11a also calculates the total amount of liquor tax by adding it to the amount of liquor tax for the other liquor categories, and displays the total amount of liquor tax in the total amount of liquor tax display area 59 (Act 37). The processor 11a also updates the total volume displayed in the total volume display area 57 according to the input volume, and updates the number of liquors displayed in the liquor quantity display area 58 according to the input quantity.
[0075] If there are other unregistered alcoholic beverages (Act 38, No), the processor 11a calculates the amount of liquor tax for each alcoholic beverage category based on the selection of the alcoholic beverage category and the input of the volume and quantity in the same manner as described above, and determines the total amount of liquor tax (Acts 31 to 37).
[0076] Therefore, in the liquor tax exemption pop-up D2, for unregistered liquor, the total volume is calculated for each liquor category, the amount of liquor tax for each liquor category (liquor tax code) is calculated based on the tax rate (tax amount per 1 kl) which differs for each liquor category, and the liquor tax amounts for each liquor category are added together to calculate the liquor tax exemption amount (total liquor tax amount).
[0077] In addition, when canceling the input volume and quantity, the subtraction button 61 is used. When the processor 11a detects that the subtraction button 61 has been operated, it selects an alcoholic beverage category, inputs the volume and quantity, and subtracts the input volume and numerical value from the corresponding alcoholic beverage category, as well as the liquor tax amount and total liquor tax amount for the alcoholic beverage category, in the same manner as described above.
[0078] In addition, for alcoholic beverages manufactured at other factories that are not exempt from liquor tax under the new liquor tax exemption system, even if they are registered as unregistered alcoholic beverages, they can be exempt from liquor tax exemption if the liquor tax is not calculated through the liquor tax exemption pop-up D2.
[0079] When the confirmation of the liquor tax calculation is instructed by operating the Confirm button 62 (Act 38, Yes), the processor 11a records the data entered through the liquor tax exemption pop-up D2 and the calculation result in the memory unit 11d, and erases the liquor tax exemption pop-up D2 from the touch panel 11h (Act 39).
[0080] In addition, the processor 11a adds the total amount of liquor tax to the tax-free amount displayed in the tax-free amount display area 36 of the tax-free confirmation pop-up D1, displays the total amount of liquor tax in the liquor tax-free amount display area 37 (Act 40), and terminates the liquor tax calculation process.
[0081] Next, if it is determined that no unregistered alcoholic beverages are stored in the currently selected product for purchase (Act 15, No), and after the liquor tax calculation process has been executed, the processor 11a executes a liquor tax confirmation process to calculate the liquor tax based on the tax exemption flag, liquor tax code, and volume data registered in the product master data 21 (Act 17).
[0082] FIG. 6 is a flowchart showing an example of the liquor tax confirmation process in this embodiment. When the processor 11a starts the liquor tax confirmation process, for each of the liquor products (products) that are classified as liquor and whose tax exemption flag is not "1" indicating that they are not subject to liquor tax exemption, among the products registered in the registered product table by the product registration process, the processor 11a obtains the liquor tax code and volume set in the product master data 21, and the quantity (quantity) registered in the registered product table (Act 51).
[0083] In the product master data 21, the tax exemption flag is set, so that even if the same alcoholic beverage is sold at a store within the manufacturing plant, if it is manufactured at a different manufacturing plant, it can be treated as being exempt from the liquor tax exemption under the new liquor tax exemption system.
[0084] When there are multiple liquor products (products) of the same liquor category (liquor tax code) in the registered product table, processor 11a calculates the total volume for each liquor category based on the volume and quantity of one liquor product (product), in the same manner as the liquor tax calculation process, and calculates the amount of liquor tax for each liquor category based on the total volume and the liquor tax corresponding to the liquor tax code.
[0085] Furthermore, if the liquor tax calculation process has been executed previously, the processor 11a reads out the calculation results for unregistered liquors calculated in the liquor tax calculation process from the memory unit 11d, and adds them to the calculation results calculated based on the aforementioned product master data 21 and the registered product table (Act 52).
[0086] This makes it possible to find the total amount of liquor tax under the liquor tax exemption system, including liquor registered in the product master data 21 and liquor not registered (unregistered liquor).
[0087] The processor 11a displays the total amount of liquor tax, which is the sum of the liquor tax amounts for each liquor category, by adding the total amount of liquor tax to the tax-free amount displayed in the tax-free amount display area 36 of the tax-free confirmation popup D1. The processor 11a also displays the total amount of liquor tax in the liquor tax-free amount display area 37 (Act 53).
[0088] Next, the processor 11a displays a screen for confirming the amount of liquor tax and the amount of liquor tax exemption (total amount) for each liquor category on the touch panel 11h (Act 54). Hereinafter, the screen for confirming the amount of liquor tax exemption will be described as a liquor tax exemption pop-up D3 (liquor tax exemption pop-up 2).
[0089] FIG. 9 is a diagram showing an example of a screen (liquor tax exemption pop-up D3 (liquor tax exemption pop-up 2)) for confirming the liquor tax exemption amount in this embodiment.
[0090] The liquor tax exemption pop-up D3 basically has the same format as the liquor tax exemption pop-up D2 described above. However, since the liquor tax exemption pop-up D3 does not require data entry for liquor tax calculation, the numeric value input area 60, subtraction button 61, cancel button 63, and message display area 64 in the liquor tax exemption pop-up D2 are omitted.
[0091] The liquor tax exemption pop-up D3 has liquor category display areas 61-1, 61-2, 61-3, 61-4, 61-5, and 61-6 corresponding to the plurality of liquor categories. Depending on the operation of the up button 66A or the down button 66B, the liquor category display areas corresponding to the remaining six liquor categories are displayed. Each of the liquor category display areas 61-1 to 61-6 is provided with an liquor category name display area 62, a tax rate display area 63, a volume display area 64, and a liquor tax amount display area 65.
[0092] The liquor category name display area 62 displays the name of the liquor category. The tax rate display area 63 displays the tax rate for each liquor category. The volume display area 64 displays the total volume for each liquor category calculated by the above-mentioned calculation. The liquor tax amount display area 65 displays the liquor tax amount corresponding to the liquor category based on the tax rate and volume calculated by the above-mentioned calculation.
[0093] The liquor tax exemption pop-up D3 also has a total volume display area 67, a number of liquor items display area 68, and a total liquor tax amount display area 69. The total volume display area 67 displays the sum of the volumes (total volume) displayed in the capacity display areas 64 corresponding to all liquor categories. The number of liquor items display area 68 displays the number of liquor items (products) that are subject to liquor tax exemption. The total liquor tax amount display area 69 displays the sum of the liquor tax amounts (total liquor tax amount) displayed in the liquor tax amount display areas 65 corresponding to all liquor categories.
[0094] The liquor tax exemption pop-up D3 is provided with a confirmation button 62. When the confirmation button 62 is operated to instruct completion of the liquor tax confirmation (Act 55, Yes), the processor 11a erases the liquor tax exemption pop-up D3 from the touch panel 11h (Act 56), and ends the liquor tax confirmation process.
[0095] The employee can confirm the tax exemption amount and the liquor tax exemption amount based on the tax exemption confirmation pop-up D1, which reflects the results of the liquor tax confirmation process and the liquor tax calculation process executed when there is unregistered liquor. Here, the employee can execute the same process as described above (Acts 12 to 17) by operating the forced tax exemption buttons 38 and 39 again, or the liquor tax exemption button 40 (Act 18, No). When the employee completes the confirmation in the tax exemption confirmation pop-up D1, he or she can operate the confirmation button 41 to instruct the end of the tax exemption confirmation.
[0096] When the processor 11a detects an operation on the confirmation button 41 (Act 18, Yes), the processor 11a erases the tax-free confirmation pop-up D1 from the touch panel 11h (Act 19) and returns to the execution state of the product registration process. Furthermore, if there is no product registration, the employee operates the subtotal key. When the processor 11a detects that the subtotal key has been operated (Act 6, Yes), the processor 11a judges whether the tax-free process is being executed by operating the tax-free key. If the tax-free process is being executed (Act 20, Yes), the processor 11a inputs passport information that needs to be printed on the export tax-free goods purchase record slip and the export tax-free goods purchase pledge after the settlement process. When the passport presented by the foreign traveler who is about to purchase a product is set, the passport reader 11p reads the passport information (name, date of birth, type of passport, nationality, etc.) recorded on the passport. The processor 11a stores the passport information read by the passport reader 11p in the RAM 11c. The processor 11a executes the payment process including the tax exemption details confirmed in the tax exemption confirmation pop-up D1 (Act 8).
[0097] When the settlement is completed, the processor 11a causes the printer 11k to print the transaction details on receipt paper and issues a transaction receipt and purchase details. If tax exemption processing is performed, the processor 11a prints information regarding tax exemption on the transaction receipt and purchase details. In addition, the processor 11a causes the printer 11k to print an export tax-free goods purchase record slip and an export tax-free goods purchase pledge for the tax-free transaction on receipt paper and issues a receipt.
[0098] FIG. 10 is a diagram showing an example of a transaction receipt R1 and purchase details R2 when tax exemption processing is performed in this embodiment. As shown in Fig. 10, in addition to information about the purchased goods (such as name, unit price, and subtotal) R10, tax-exemption-related information R11-R18 and a total amount after tax exemption R19 are printed on the transaction receipt R1. The tax-exemption-related information R11-R18 includes the total amount of general goods subject to tax exemption R12, the total amount of consumables subject to tax exemption R13, the total amount (excluding tax) of tax-exempt items (general goods and consumables) R14, the tax exemption amount (total of tax-excluded and tax-inclusive amounts) R15, the taxable amount R16 of the SI category set as tax-exempt, the amount of liquor tax to be processed for tax exemption R17, and the fractional amount R18. In the transaction receipt R1 in this embodiment, the amount of liquor tax to be processed for tax exemption R17 is printed, so that it is possible to confirm that liquor tax has been exempted and the amount of liquor tax exemption.
[0099] As shown in FIG. 10, the purchase details R2 prints information about the purchased general goods (such as name, amount, subtotal amount) R20, the general goods tax-free total R21, information about the purchased consumable goods (such as name, amount, subtotal amount) R22, and the consumable goods tax-free total R23. The purchase details R2 also prints tax-free total R24, tax-free amount R25, and liquor tax-free amount R26 as information related to tax-free. The purchase details R2 also prints information related to the store (salesperson, person in charge, transaction number, number of items purchased) R27. In the purchase details R2 in this embodiment, not only can the tax-free total for general goods and consumable goods be confirmed, but the liquor tax-free amount R26 can also be confirmed individually.
[0100] FIG. 11 is a diagram showing an example of a tax-free export goods purchase record slip R3 printed when tax-free processing is performed in this embodiment. As shown in Fig. 11, in addition to date and time information, passport information R30, purchase details R31 (same as purchase details R2), and a notice R33 in Japanese and a language corresponding to the nationality included in the passport information are printed on the export duty-free goods purchase record slip R3. The purchase details R31 includes the liquor tax exemption amount R32. In addition, an addendum R34 for the liquor tax rate application category is printed on the export duty-free goods purchase record slip R3. In the addendum R34 for the liquor tax rate application category, the name of the liquor category (tax rate category) R35, the total volume, and the tax rate R36 are printed for the liquor category (liquor tax rate) in the liquor tax calculation corresponding to the product that is subject to liquor tax exemption. If other products with different liquor categories (liquor tax rates) are purchased, the name of the liquor category (tax rate category) R37, the total volume, and the tax rate R38 are printed for each of them.
[0101] On the export duty-free goods purchase record slip R3, the name of the liquor category (tax rate category) that is subject to liquor tax exemption R35, R37, the total volume, and the tax rate R36, R38 are printed, so it is possible to confirm which of the 12 liquor categories is subject to liquor tax exemption, and the volume and tax rate that are subject to exemption.
[0102] FIG. 12 is a diagram showing an example of the export duty-free goods purchase pledge R4 printed when the tax-free processing according to this embodiment is performed. 12, in addition to date and time information, passport information R40 (including signature area R41) and purchase details R42 (same as purchase details R2) are printed on the export duty-free goods purchase pledge R4. The purchase details R42 includes the liquor tax exemption amount R43. In addition, an addendum R45 on the liquor tax rate application category is printed on the export duty-free goods purchase pledge R4, just like the export duty-free goods purchase record slip R3.
[0103] The Export Duty-Free Goods Purchase Pledge Form R4, like the Export Duty-Free Goods Purchase Record Form R3, allows users to check which of the 12 alcoholic beverage categories are subject to liquor tax exemption, as well as the volume and tax rate of the exemption.
[0104] According to the embodiment described above, the POS terminal 10 (product sales data processing device) in this embodiment can process sales data for tax exemption of alcoholic beverages that comply with the new liquor tax exemption system. This allows stores offering liquor tax exemption to process appropriate sales data according to multiple alcoholic beverages from different manufacturers and with different liquor tax amounts included in multiple products that foreign tourists visiting Japan are trying to purchase, and can significantly reduce the burden on employees.
[0105] In addition, in this embodiment, an example of sales data processing corresponding to the new liquor tax exemption system is described, but it can also be applied to a product sales data processing device that requires sales data processing related to tax exemption when multiple types of products with different tax rates are mixed, such as the alcoholic beverages mentioned above.
[0106] Although some embodiments of the present invention have been described, these embodiments are presented as examples and are not intended to limit the scope of the invention. These novel embodiments can be implemented in various other forms, and various omissions, substitutions, and modifications can be made without departing from the spirit of the invention. These embodiments and their modifications are included in the scope and spirit of the invention, and are included in the scope of the invention and its equivalents described in the claims.
[0107] Furthermore, the processes described in the above-mentioned embodiments can be written as a program that can be executed by a computer onto a recording medium such as a magnetic disk (flexible disk, hard disk, etc.), an optical disk (CD-ROM, DVD, etc.), or a semiconductor memory, and provided to various devices. Also, it is possible to transmit the programs via a communication medium and provide them to various devices. The computer reads the program recorded on the recording medium, or receives the program via the communication medium, and executes the above-mentioned processes by having its operation controlled by the program. [Explanation of symbols]
[0108] 10...POS terminal, 11a...processor, 11b...ROM, 11c...RAM, 11d...storage unit, 11e...change machine, 11f...communication unit, 11g...scanner, 11h...touch panel, 11j...keyboard, 11k...printer, 11p...passport reader, 12...server.
Claims
1. A first input means for inputting a product code; A detection means for detecting an instruction to execute a tax exemption process for a commodity corresponding to the commodity code; a second input means for inputting product information necessary for a liquor tax exemption process for calculating a liquor tax exemption amount for the unregistered liquor after detecting an instruction to execute the tax exemption process when a product code of an unregistered liquor for which a liquor tax code is not registered is input by the first input means; A product sales data processing device having the above structure.
2. 2. The product sales data processing device according to claim 1, further comprising a first display means for displaying a confirmation screen of a tax exemption amount calculated based on the product information of the product corresponding to the product code input by the first input means when an instruction to execute the tax exemption process is detected.
3. 3. The product sales data processing device according to claim 2, wherein the confirmation screen includes a liquor tax exemption button for instructing execution of the liquor tax exemption process for the product corresponding to the product code input by the first input means.
4. 4. A product sales data processing device as described in claim 3, further comprising a second display means for displaying the liquor tax exemption amount calculated by the liquor tax exemption processing for liquor including the unregistered liquor when the execution of the liquor tax exemption processing is instructed by the liquor tax exemption button.
5. Computer, A first input means for inputting a product code; A detection means for detecting an instruction to execute a tax exemption process for a commodity corresponding to the commodity code; A program for functioning as a second input means for inputting product information necessary for liquor tax exemption processing to calculate the liquor tax exemption amount for the unregistered liquor when the product code of an unregistered liquor for which a liquor tax code is not registered is input by the first input means, after detecting an instruction to execute the tax exemption processing.
Citation Information
Patent Citations
Wine dealer POS
JP1988024489A
POS register
JP2016066353A
Tax exemption information acquisition device, tax exemption information acquisition system, tax exemption information acquisition method, and tax exemption information acquisition program
JP2016099787A
Sales information apparatus, tax calculation / journalization method, and tax calculation / journalization program
JP2016167256A
Merchandise data processor
JP2016224519A
