JP7353890B2 - Product sales data processing device and control program - Google Patents

Description

Embodiments of the present invention relate to a product sales data processing device and a control program for causing a computer to function as the device.

In Japan, a so-called reduced tax rate system will be introduced with regard to the tax system in which taxes are levied on the consumption of products, which will lower the tax rate on products directly related to daily life, such as beverages and foodstuffs, than on other products. . Under the reduced tax rate system, the tax rate on products eligible for the reduced tax rate is lower than the regular tax rate on products that are not eligible. Therefore, when a consumer purchases multiple products at once, there may be a mix of products to which the normal tax rate is applied and products to which the reduced tax rate is applied.

On the other hand, cash, credit cards, electronic money, gift certificates, and the like are widely known as payment methods by consumers. Further, a cash voucher issued by the store or the corporate entity that operates the store may also be one of the payment methods. Examples of this type of coupon include coupons issued in exchange for accumulated points at stores or corporate entities that have introduced a point service system in which points are awarded according to the price paid by consumers. The face value of this type of gift certificate is an amount corresponding to the accumulated points, and it can be applied to payment in the same way as a gift certificate. However, for tax purposes, this type of coupon is recorded as a promotional expense for a store or corporate entity.

When the reduced tax rate system is introduced, it is desirable to calculate the ratio of the payment amount for products subject to the normal tax rate and the ratio of the payment amount for products subject to the reduced tax rate, especially for payment methods recorded as sales promotion expenses. ing. For stores or corporate entities, there is an advantage in that tax management is facilitated by determining the proportion of the payment amount for each type of tax imposed on products, at least for payment methods recorded as sales promotion expenses.

JP2019-040442A

The problem to be solved by the embodiments of the present invention is to provide a product sales data processing device that can calculate the proportion of the payment amount for each type of tax imposed on the product, at least for a specific payment method. be.

In one embodiment, the product sales data processing device includes a summation means, an amount acquisition means, a calculation means, a calculation means, an output means , and a data acquisition means . The summing means totals the amount of goods for each tax category that classifies the type of tax imposed on the goods. The amount acquisition means acquires the amount paid for the product. The calculation means calculates the payment amount based on the ratio of the amounts summed up for each tax category by the totalization means. The calculation means calculates the tax amount for the type of tax specified in the tax classification from the payment amount calculated for each tax classification by the calculation means. The output means outputs at least one of the payment amount calculated for each tax category by the calculation means or the tax amount calculated for each tax category by the calculation means. The data acquisition means acquires the data from a storage unit that stores data that identifies whether or not the payment method is a specific payment method for determining the percentage of the payment amount for each tax category for each payment category that classifies the payment method. Obtain payment classification data for payment amount. When the data acquired by the data acquisition means is data indicating a particular payment method, the calculation means performs a calculation process and the calculation means performs a calculation process on the payment amount by the particular payment method.

FIG. 1 is a block diagram showing a main circuit configuration of a POS terminal according to an embodiment. A schematic diagram showing the data structure of a product record stored in a product file. A schematic diagram showing the data structure of a payment management table. FIG. 2 is a schematic diagram showing main data areas formed in the main memory of a POS terminal. A schematic diagram showing the data structure of a registered product table area. A schematic diagram showing the data structure of a payment details table area. 1 is a flowchart showing the main processing procedure of one transaction executed by a processor according to a control program. 1 is a flowchart showing the main processing procedure of one transaction executed by a processor according to a control program. FIG. 3 is a schematic diagram showing an example of data stored in a main data area. A schematic diagram showing an example of issuing a receipt.

DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of a product sales data processing device that can calculate the proportion of the payment amount for each type of tax imposed on a product, at least for a specific payment method, will be described below with reference to the drawings.
In addition, this embodiment exemplifies the case where a tax system is introduced in which a reduced tax rate of 8% is applied to some products such as foodstuffs, and a regular tax rate of 10% is applied to other products. do. Then, POS (Point Of Sales) terminals of stores that sell a mix of tax-exclusive products sold at prices that do not include tax and tax-inclusive products that are sold at prices that include tax are used to sell products. This is one aspect of a data processing device.

FIG. 1 is a block diagram showing the main circuit configuration of a POS terminal 10 according to this embodiment. The POS terminal 10 includes a processor 101, main memory 102, auxiliary storage device 103, clock 104, change machine interface 105, communication interface 106, keyboard 107, scanner 108, first display 109, second display 110, printer 111, and system transmission. A path 112 is provided. The system transmission line 112 includes an address bus, a data bus, a control signal line, and the like. The system transmission path 112 connects the processor 101, main memory 102, auxiliary storage device 103, clock 104, change machine interface 105, communication interface 106, keyboard 107, scanner 108, first display 109, second display 110, and printer 111. connect each other. The computer of the POS terminal 10 is configured by connecting the processor 101, main memory 102, and auxiliary storage device 103 through a system transmission path 112.

Processor 101 corresponds to the central part of the computer. The processor 101 controls each part to realize various functions of the POS terminal 10 according to an operating system or an application program. The processor 101 is, for example, a CPU (Central Processing Unit).

Main memory 102 corresponds to the main memory portion of the computer. Main memory 102 includes a nonvolatile memory area and a volatile memory area. Main memory 102 is a nonvolatile memory area that stores an operating system or application programs. The main memory 102 may store data necessary for the processor 101 to execute processing for controlling each unit in a non-volatile or volatile memory area. The main memory 102 uses a volatile memory area as a work area in which data is appropriately rewritten by the processor 101. The nonvolatile memory area is, for example, a ROM (Read Only Memory). The volatile memory area is, for example, RAM (Random Access Memory).

The auxiliary storage device 103 corresponds to the auxiliary storage portion of the computer. For example, the auxiliary storage device 103 may be an EEPROM (Electric Erasable Programmable Read-Only Memory), an HDD (Hard Disk Drive), or an SSD (Solid State Drive). The auxiliary storage device 103 stores data used by the processor 101 in performing various processes, data created by processing by the processor 101, and the like. The auxiliary storage device 103 may also store the above application program.

The application programs stored in the main memory 102 or the auxiliary storage device 103 include control programs written regarding information processing executed by the POS terminal 10. The method of installing the control program into the main memory 102 or the auxiliary storage device 103 is not particularly limited. The control program can be recorded on a removable recording medium or distributed by communication via a network and installed in the main memory 102 or the auxiliary storage device 103. The recording medium may be in any form as long as it can store the program and is readable by the device, such as a CD-ROM or a memory card.

The clock 104 functions as a time information source for the POS terminal 10. The processor 101 measures the current date and time based on time information measured by the clock 104.

The change machine interface 105 performs data communication with an automatic change machine. The change machine interface 105 receives data on the amount inserted, data on the number of coins stored, etc. from the automatic change machine. The change machine interface 105 transmits change data to an automatic change machine.

The communication interface 106 performs data communication with the store server 20 connected via a network such as a wired LAN (Local Area Network) or a wireless LAN. The store server 20 includes a product file 21 and a payment management table 22. The product file 21 and the payment management table 22 may be formed in a storage device built into the store server 20, or may be formed in a storage device connected to the outside of the store server 20.

The product file 21 stores product records 21R (see FIG. 2). The product record 21R is created for each product. The main data structure of the product record 21R is shown in the schematic diagram of FIG. As shown in FIG. 2, the product record 21R includes data on items such as a product code, product name, unit price, tax classification, and attributes.

The product code is a unique code set for each product to identify each product. Usually, each product is attached with a barcode symbol that is a barcode of a product code, or a two-dimensional code symbol that is a two-dimensional code. Alternatively, an RFID (Radio Frequency Identification) tag storing a product code may be attached. The POS terminal 10 can register product sales data by reading the data of the barcode symbol, two-dimensional code symbol, or RFID tag with a reading device.

The product name and unit price are the name of the product identified by the product code and the price per item. Hereinafter, the product identified by the product code will be referred to as the product.

The tax classification is a value that classifies the type of tax imposed on the product. The types of taxes include 8% exclusive tax, 10% exclusive tax, 8% inclusive tax, and 10% inclusive tax. 8% excluding tax is a classification of tax-excluded products to which a reduced tax rate of 8% is applied, and in this embodiment, the tax classification is set to "1". 10% non-tax is a classification of non-tax products to which the normal tax rate of 10% is applied, and in this embodiment, the tax classification is "2". 8% tax included is a category of tax-inclusive products to which a reduced tax rate of 8% is applied, and in this embodiment, the tax category is "3". 10% tax included is a category of tax-inclusive products to which the normal tax rate of 10% is applied, and in this embodiment, the tax category is "4".

The attribute is information that identifies whether or not the product is subject to the reduced tax rate system. In the case of this embodiment, beverages or foods are subject to the reduced tax rate system. Therefore, the attributes of a beverage or food item are information indicating that the item is subject to the reduced tax rate system. Other product attributes are information indicating that the product is not subject to the reduced tax rate system.

As shown in FIG. 3, the payment management table 22 is a data table that stores information on payment names and specific flags for each payment category that classifies payment methods. In this embodiment, six types of payment methods are illustrated: cash, credit card, electronic money, gift certificate, first shopping ticket, and second shopping ticket. Then, the payment classification for cash is "1", the payment classification for credit card is "2", the payment classification for electronic money is "3", the payment classification for gift certificate is "4", and the payment classification for the first shopping ticket is "". 5”, and the payment classification for the second shopping ticket is “6”. Incidentally, the first shopping ticket is a cash ticket whose face value is an amount corresponding to accumulated points. The second shopping ticket is a cash voucher for a certain amount of money issued to a good customer by a store or a corporate entity that operates the store. Note that the definitions of the first shopping ticket and the second shopping ticket are not limited to these. Under tax law, any gift certificate can be used as long as it is recorded as a promotional expense by the store or corporate entity that issued the certificate.

The payment name is a name representing the payment method classified by the corresponding payment category.
The specific flag is 1-bit data for identifying whether the payment method classified by the corresponding payment category is a specific payment method for calculating the proportion of the payment amount for each tax category. Among the six types of payment methods illustrated, it is desirable to calculate the proportion of the payment amount by tax category for cash vouchers that are recorded as sales promotion expenses, such as the first shopping ticket or the second shopping ticket. That is, the first shopping ticket or the second shopping ticket corresponds to a specific payment method. In this embodiment, a specific flag indicating a specific payment method is set to "1", and a specific flag indicating a payment method other than the specific payment method is set to "0".

Returning to the explanation of FIG.
The keyboard 107 is a dedicated input device that is provided with various function keys such as a multiplication key, a subtotal key, and a closing key in addition to a number key for entering numerical values such as points and amounts. The keyboard 107 may be a general-purpose keyboard with functions necessary for the POS terminal 10 assigned to arbitrary keys. Closing keys are provided for each payment method. That is, the first closing key corresponds to cash, the second closing key corresponds to credit card, the third closing key corresponds to electronic money, the fourth closing key corresponds to gift certificate, and the fifth closing key corresponds to first shopping ticket. A closing key and a sixth closing key corresponding to the second shopping ticket are arranged on the keyboard 107.

The scanner 108 is an example of a reading device that reads code symbols such as barcodes and two-dimensional codes. The scanner 108 may be of a type that reads code symbols by scanning with laser light, or may be of a type that reads code symbols from an image captured by an imaging device. The keyboard 107 and scanner 108 function as input devices for the POS terminal 10.

The first display 109 displays information to a store clerk who is an operator. The second display 110 displays information to consumers who are customers. As this type of display device, for example, a liquid crystal display, an organic EL (Electroluminescence) display, etc. can be used. At least one of the first display 109 and the second display 110 may be a touch panel. The first display 109 and the second display 110 function as display devices of the POS terminal 10.

The printer 111 issues a receipt by printing various character strings or images on receipt paper. As this type of printer 111, for example, a thermal printer or a dot impact printer can be used. The printer 111 functions as a printing device for the POS terminal 10.

FIG. 4 is a schematic diagram showing main data areas formed in the main memory 102. The data area includes a registered product table area 31, a tax classification table area 32, a total amount including tax area 33, a payment details table area 34, and a total payment amount area 35. Each data area is secured in a volatile memory area.

The registered product table area 31 is an area for describing detailed data of products sold as one transaction. As shown in FIG. 5, the registered product table area 31 includes an area for describing product data including a product code, product name, unit price, tax classification, and attributes in association with a series of registration numbers, and an area for describing product data including a product code, product name, unit price, tax classification, and attributes, and a sales number P( P1, P2, P3,...) and an area for writing the sales amount Q (Q1, Q2, Q3,...). Additionally, the registered product table area 31 includes an area for writing the total score P0 that is the sum of the sales numbers P of products sold as one transaction, and an area for writing the total amount Q0 that is the sum of the sales amount Q of the same product. and has.

The tax classification table area 32 is an area for tabulating the sales amount Q of products sold in one transaction by tax classification of tax imposed on the products. The tax classification table area 32 describes total amounts A1, A2, A3, A4 and tax amounts B1, B2, B, B3, B4 for each tax classification "1", "2", "3", "4". It has an area for

The tax-inclusive total amount area 33 is an area for describing the tax-inclusive total amount C of products sold as one transaction. The total amount including tax C is calculated by adding up the total amount Q0 of products sold in one transaction and the amount of tax imposed on tax-excluded products among the products.

The payment details table area 34 is an area for describing payment data for one transaction. As shown in FIG. 6, the payment details table area 34 includes payment amounts E1 to E6 for each payment classification from "1" to "6", amounts G11 to G41 for each tax classification from "1" to "4", and Describe G21-G42, G13-G43, G14-G44, G15-G45, G16-G46, and tax amount H11-H41, H21-H42, H13-H43, H14-H44, H15-H45, H16-H46 It has an area for

In the total payment amount area 35, if there is one type of payment method for one transaction, the payment amount is described as the total payment amount D, and if there are two or more payment methods, the total amount of each payment amount is described. This is an area described as the total payment amount D.

7 and 8 are flowcharts showing the main processing steps of one transaction executed by the processor 101 according to the control program. Hereinafter, the main operations of the POS terminal 10 will be explained using each figure. Note that the content of the operation described below is an example. The processing procedure is not particularly limited as long as similar results can be obtained.

Prior to starting product registration for one transaction, the processor 101 performs initialization as ACT1. By this initialization, the registered product table area 31, tax category table area 32, total amount including tax area 33, payment details table area 34, and total amount paid area 35 are cleared.

When the initialization is completed, the processor 101 waits for the product code of the product to be sold as one transaction to be input in ACT2. Then, when the product code is input via the input device of the keyboard 107 or the scanner 108, the processor 101 determines YES in ACT2 and proceeds to ACT3. The processor 101 obtains product data of the product identified by the product code as ACT3. That is, the processor 101 makes an inquiry to the store server 20 regarding product data. Based on this inquiry, the store server 20 searches the product file 21. Then, the product data described in the product record 21R including the product code is transmitted to the POS terminal 10 that is the inquiry source. In this way, the processor 101 can acquire product data. The product data includes a product code, product name, unit price, tax classification, attributes, etc.

The processor 101 that has acquired the product data generates product sales data based on the product data as ACT4. That is, the processor 101 calculates the sales amount Q by multiplying the unit price included in the product data by the number of sales items P. The number of sales items P is set to the multiplier when the multiplier is input using the ten keys and the multiplication key of the keyboard 107 immediately before the product code is input, and is set to "1" when the multiplier is not input. Then, the processor 101 adds the number of sales P and the sales amount Q to the product code, product name, unit price, tax category, and attributes of the product data to generate product sales data.

After generating the product sales data, the processor 101 registers the product sales data in the registered product table area 31 as ACT5. At this time, the processor 101 registers the product sales data in descending order of registration number.

After completing the registration of the product sales data, the processor 101 obtains the tax category m and the sales amount Q from the product sales data in ACT6. Then, in ACT7, the processor 101 adds the sales amount Q to the total amount Am corresponding to the tax category m in the tax category table area 32.

Thereafter, the processor 101 checks whether the next product code has been input in ACT8. If the product code has not been input, the processor 101 determines NO in ACT8, and proceeds to ACT9. The processor 101 checks whether the subtotal key has been input in ACT9. If the subtotal key has not been input, the processor 101 determines NO in ACT9 and returns to ACT8. Here, the processor 101 waits for a product code to be input or a subtotal key to be input in ACT8 or ACT9.

When a product code is input in the standby state of ACT8 or ACT9, the processor 101 determines YES in ACT8 and returns to ACT3. Thereafter, the processor 101 executes the processes of ACT3 to ACT7 in the same manner as described above. The processor 101 then returns to the standby state in ACT8 or ACT9.

If the subtotal key is input in the standby state of ACT8 or ACT9, the processor 101 determines YES in ACT9 and proceeds to ACT10. As ACT10, the processor 101 calculates the tax amounts B1 to B4 in the tax category table area 32 using the following equations (1) to (4). Note that numbers below the decimal point are rounded off.

B1=A1*0.08…(1)
B2=A2*0.1…(2)
B3=A3-(A3/1.08)...(3)
B4=A4-(A4/1.1)...(4)
After calculating the tax amounts B1 to B4, the processor 101 calculates the total tax-included amount C as ACT11 using the following equation (5).

C=Q0+B1+B2...(5)
After calculating the total amount C including tax, the processor 101 displays the total amount C including tax on the first display 109 and the second display 110.

Thereafter, the processor 101 checks whether a product code has been input in ACT13. If the product code has not been input, the processor 101 determines NO in ACT13, and proceeds to ACT14. The processor 101 checks whether payment data has been input in ACT14. If payment data has not been input, the processor 101 determines NO in ACT14 and returns to ACT13. Here, the processor 101 waits for a product code to be input or payment data to be input in ACT13 or ACT14.

When a product code is input in the standby state of ACT13 or ACT14, the processor 101 determines YES in ACT13 and returns to ACT3. Thereafter, the processor 101 executes the processes of ACT3 to ACT7 in the same manner as described above. The processor 101 then returns to the standby state in ACT8 or ACT9.

In the standby state of ACT13 or ACT14, when any closing key is operated and payment data including the payment method and payment amount is input, the processor 101 determines YES in ACT14 and proceeds to ACT21 in FIG. move on. The processor 101 obtains the payment category n and the payment amount En corresponding to the payment method as ACT21. Then, the processor 101 writes the payment amount En in the payment amount area corresponding to the payment category n in the payment details table area 34 as ACT22. Further, the processor 101 adds the payment amount En to the payment total amount area 35 in ACT 23 to calculate the payment total amount D.

In ACT 24, the processor 101 checks whether the total payment amount D is equal to or greater than the tax-included total amount C. If the total payment amount D is less than the tax-included total amount C, the payment has not been completed. The processor 101 determines NO in ACT24, and proceeds to ACT25. The processor 101 displays the remaining amount obtained by subtracting the total payment amount D from the total amount C including tax on the first display 109 and the second display 110. The processor 101 then waits for payment data to be input as ACT26.

When the payment data is input, the processor 101 determines YES in ACT26 and returns to ACT21. The processor 101 then executes the processes ACT21 to ACT24 in the same manner as described above.

When the total payment amount D becomes equal to or greater than the tax-included total amount C, the payment is completed. The processor 101 determines YES in ACT24, and proceeds to ACT27. The processor 101 resets the counter r to "0" as ACT27. The counter r is formed in a volatile area of the main memory 102, for example. Next, the processor 101 increments the counter r by "1" in ACT28. Then, the processor 101 checks whether the counter r exceeds the maximum value R in ACT29. The maximum value R is the number of types of payment methods. In this embodiment, the maximum value R is "6".

If the counter r does not exceed the maximum value R, the processor 101 determines NO in ACT29 and proceeds to ACT30. In ACT 30, the processor 101 searches the payment details table area 34 to check whether the payment amount Er whose payment classification is the value of the counter r is greater than "0". When the payment amount Er is "0", there is no payment using the payment method identified by the payment classification r. The processor 101 determines NO in ACT30, and returns to ACT28. The processor 101 further increments the counter r by "1". The processor 101 then checks whether the counter r has exceeded the maximum value R.

On the other hand, if the payment amount Er is larger than "0", there is a payment using the payment method identified by the payment classification r. The processor 101 determines YES in ACT30, and proceeds to ACT31. The processor 101 obtains the specific flag Fr for the payment category r in ACT31. That is, the processor 101 inquires of the store server 20 about the specific flag Fr for the payment category r. In response to this inquiry, the store server 20 searches the payment management table 22, reads out the specific flag Fr for the payment category r, and sends it to the POS terminal 10 that is the source of the inquiry. In this way, the processor 101 obtains the specific flag Fr.

The processor 101 that has acquired the specific flag Fr checks whether the specific flag Fr is "1" in ACT32. If the specific flag Fr is not "1", the payment method for the payment category r is not a specific payment method that calculates the proportion of the payment amount for each tax category. The processor 101 determines NO in ACT32, and returns to ACT28.

On the other hand, when the specific flag Fr is "1", the payment method for the payment category r is a specific payment method that calculates the proportion of the payment amount for each tax category. The processor 101 determines YES in ACT32, and proceeds to ACT33. As ACT 33, the processor 101 calculates the ratio of the payment amount according to the payment category r for each tax category "1" to "4", that is, the amounts G1r to G4r using the following equations (6) to (9). Note that numbers below the decimal point are rounded off.

G1r=Er*(A1/C)...(6)
G2r=Er*(A2/C)...(7)
G3r=Er*(A3/C)...(8)
G4r=Er*(A4/C)...(9)
When the processor 101 finishes calculating the amounts G1r to G4r for each tax category "1" to "4", the processor 101 transfers the amounts G1r to G4r to the tax category "1" corresponding to the payment category r in the payment detail table area 34 as ACT34. ” to “4” in each amount area.

Next, in ACT 35, the processor 101 calculates the tax amounts H1r to H4r for each tax category "1" to "4" for the payment category r using the following equations (10) to (13). Note that numbers below the decimal point are rounded off.

H1r=G1r*0.08…(10)
H2r=G2r*0.1...(11)
H3r=G3r-(G3r/1.08)...(12)
H4r=G4r-(G4r/1.1)...(13)
After calculating the tax amounts H1r to H4r for each tax category “1” to “4”, the processor 101 stores the tax amounts H1r to H4r in the tax category “1” corresponding to the payment category r in the payment detail table area 34 as ACT 36. ” to “4” in each tax amount area.

After completing the processing in ACT36, the processor 101 returns to ACT28. The processor 101 further increments the counter r by "1". The processor 101 then checks whether the counter r has exceeded the maximum value R. If the counter r does not exceed the maximum value R, the processor 101 executes the processes in ACT30 to ACT36 in the same manner as described above.

If the counter r exceeds the maximum value R, the processor 101 makes a YE determination in ACT29, and proceeds to ACT37. Processor 101 creates transaction data as ACT37. The transaction data is composed of data described in a registered product table area 31, a tax classification table area 32, a total amount including tax area 33, a payment details table area 34, and a total payment amount area 35, respectively. In addition to the above-mentioned data, the transaction data includes the current date and time (transaction date and time) kept by the clock 104, a series of transaction numbers (receipt numbers), and a unique cash register number set for the POS terminal 10. including. Transaction data may also include other data.

The processor 101 creates receipt data based on the transaction data as ACT38. Then, the processor 101 outputs the receipt data to the printer 111 as ACT 39, and controls the printer 111 to print the receipt. Further, the processor 101 controls the communication interface 106 to transmit transaction data to the store server 20 as ACT 40. Under this control, transaction data is transmitted to the store server 20 via the network.

With this, the processor 101 ends the processing of one transaction. The processor 101 then returns to ACT1 and waits for product registration for the next transaction.

Here, the processor 101, which is the main body of the computer, constitutes a processing means by executing the processes of ACT2 to ACT5 in FIG. 7 according to the control program. That is, the processor 101 registers sales data of products to be sold as transactions, that is, item data such as product code, product name, unit price, tax category, attributes, number of sales items, sales amount, etc., in the registered product table area 31.

Further, the processor 101 constitutes a summation means by executing the processes of ACT6 and ACT7 in FIG. That is, the processor 101 uses the tax category table area 32 to total the amount Q of the product for each tax category m that classifies the type of tax imposed on the product.

Further, the processor 101 constitutes an amount acquisition means by executing the processes of ACT28 and AC30 in FIG. That is, the processor 101 uses the payment details table area 34 to obtain the payment amount Er for the product for each payment category r.

Further, the processor 101 constitutes a data acquisition means by executing the processes of ACT31 and AC32 in FIG. That is, the processor 101 obtains the specific flag Fr for the payment amount Er from the payment management table 22, which is a storage unit. The specific flag Fr is data that identifies whether or not the payment method is a specific payment method that calculates the proportion of the payment amount for each tax category.

Furthermore, the processor 101 constitutes a calculation means by executing the processes of ACT33 and ACT34 in FIG. That is, the processor 101 uses the tax classification table area 32 to calculate the payment amount Er by proportionally dividing the total amount A1 to A4 for each tax classification. The processor 101 then stores the payment amounts G1r to G4r calculated for each tax category in the payment details table area 34.

Further, the processor 101 constitutes a calculation means by executing the processes of ACT35 and ACT36 in FIG. That is, the processor 101 calculates the tax amounts H1r to H4r for the type of tax specified in the tax category from the payment amounts G1r to G4r calculated for each tax category. The processor 101 then stores the tax amounts H1r to H4r calculated for each tax category in the payment details table area 34.

Furthermore, the processor 101 constitutes an output means by executing the process of ACT39 in FIG. That is, the processor 101 outputs receipt data to the printer 111. The printer 111 constitutes issuing means. That is, the printer 111 receives the receipt data and issues a receipt on which data of one transaction is recorded. The payment amounts G1r to G4r and the tax amounts H1r to H4r are output on the receipt.

Further, the communication interface 106 constitutes a communication means that performs data communication with the store server 20 that collects data of one transaction. Then, the processor 101 configures a second output means by processing ACT36 and ACT40 in FIG. That is, the processor 101 includes the payment amounts G1r to G4r and the tax amounts H1r to H4r in the data of one transaction, and transmits the data to the store server 20.

FIG. 9 is an example of data written in the tax category table area 32, tax-included total amount area 33, payment details table area 34, and payment total amount area 35 in one transaction. In other words, Figure 9 shows an 8% non-tax product with a tax category of "1" and a price of 1,000 yen, a 10% non-tax product with a tax category of "2" and a price of 2,000 yen, and a product with a tax category of "3". An example of a transaction with a consumer who purchased a total of four items, one each of a product with a price of 3,000 yen with 8% tax included and a product with tax category "4" and a price of 4,000 yen with 10% tax included is illustrated. Then, the consumer pays 5,000 yen with the first shopping ticket whose payment classification is "5" and pays 6,000 yen with cash whose payment classification is "1". Here, it is assumed that cash with a payment classification of "1" is not a specific payment method, but the first shopping ticket with a payment classification of "5" is a specific payment method.

In this case, since the payment amount E1 for cash with the payment category "1" is 6000 yen, YES is determined in ACT30 of FIG. 8, and the process proceeds to ACT31. However, since the specific flag F1 acquired from the store server 20 in ACT31 is "0" and the determination is NO in ACT32, the processes in ACT33 to ACT36 are not executed.

In addition, for credit cards with payment class "2", electronic money with payment class "3", gift certificates with payment class "4", and second shopping vouchers with payment class "6", payment amounts E2, E3, E4, Since E6 is 0 yen, the determination in ACT30 is NO. Therefore, the processes in ACT31 to ACT36 are not executed.

On the other hand, for the first shopping ticket with payment classification "5", the payment amount E5 is 5000 yen, so the determination is YES in ACT30, and the process proceeds to ACT31. Then, in ACT31, the specific flag F5 acquired from the store server 20 is "1", and in ACT32, it is determined as YES, so the processes in ACT33 to ACT36 are executed. That is, the amounts G15, G25, G35, and G45 for each tax category "1" to "4" are calculated by the following formulas (6a) to (9a).

G15=5,000*(1,000/10,280)=486...(6a)
G25=5,000*(2,000/10,280)=973...(7a)
G35=5,000*(3,000/10,280)=1,459...(8a)
G45=5,000*(4,000/10,280)=1,946...(9a)
The calculated amounts G15, G25, G35, and G45 are written in the payment details table area 34.

Furthermore, the tax amounts H15, H25, H35, and H45 for each tax category "1" to "4" are calculated using the following formulas (10a) to (13a).

H15=486*0.08=39...(10a)
H25=973*0.1=97...(11a)
H35=1,459-(1,459/1.08)=108...(12a)
H45=1,946-(1,946/1.1)=177...(13a)
The calculated tax amounts H15, H25, H35, and H45 are written in the payment details table area 34.

Thus, through the processing in ACT38 and ACT39, a receipt 40 with the printed content shown in FIG. 10 is issued. Furthermore, transaction data including the content printed on the receipt 40 is transmitted to the store server 20 through the processing in ACT37 and ACT40.

As described in detail above, in this embodiment, the store server 20 is provided with a payment management table 22 that stores information on payment names and specific flags for each payment category that classifies payment methods. For payment methods that are recorded as promotional expenses, the specific flag should be set to " It is set to 1". By doing so, the POS terminal 10 calculates the proportion of the payment amount for each type of tax imposed on the product for the payment method for which the specific flag is set to "1", and further calculates the tax amount for that payment amount. , output to display on the receipt or output to the store server 20.

Therefore, according to the present embodiment, data necessary for tax management can be easily acquired in a store where products to which the normal tax rate is applied and products to which the reduced tax rate is applied coexist, or a corporate entity that operates the store. be able to. As a result, tax management becomes easier at a store or business entity, and the burden required to prepare materials for reporting to a tax office, for example, can be reduced.

Further, according to the present embodiment, depending on the setting of the specific flag, it is possible to determine whether or not to calculate the proportion of the payment amount for each type of tax imposed on the product for each payment classification. Therefore, there is an advantage that changes in the target payment category can be easily handled.

Further, according to the present embodiment, it is possible to display and output the proportion of the payment amount calculated for each type of tax imposed on the product and the tax amount relative to the payment amount on the receipt. Therefore, the consumer who receives the receipt can easily know the proportion of each tax category and the tax amount to the payment amount.

Further, according to the present embodiment, it is possible to transmit and output to the store server 20 the proportion of the payment amount calculated for each type of tax imposed on the product and the tax amount for the payment amount. Therefore, the store server 20 can easily obtain the total amount of data necessary for tax management by aggregating the data received from the POS terminal 10.

Above, we have described an embodiment of a product sales data processing device that can calculate the proportion of the payment amount for each type of tax imposed on a product, at least for a specific payment method, but this embodiment is not limited to this. isn't it.

For example, in the embodiment described above, the payment management table 22 is provided in the store server 20. In another embodiment, the POS terminal 10 may include the payment management table 22.

Further, in the embodiment, the payment method for determining the proportion of the payment amount for each tax category can be identified by the specific flag, and when the specific flag is "1" in ACT32 of FIG. The process of ACT36 was executed. Regarding this point, if the processor 101 determines YES in ACT30, it skips the processing in ACT31 and ACT32 and executes the processing in ACT33 to ACT36. The processor 101 then refers to the specific flag before creating transaction data in ACT37. Then, the processor 101 selects the amounts G1r to G4r and the tax amounts H1r to H4r of the payment category r whose specific flag is set to "1" from the payment details table area 34, includes them in the transaction data, and displays and outputs them on the receipt. You may.

It goes without saying that the payment management table 22 can be omitted when determining the proportion of the payment amount for each tax category for all payment methods.

In the above embodiment, the case where the output means simultaneously outputs the payment amount calculated for each tax category by the calculation means and the tax amount calculated for each tax category by the calculation means is exemplified. In this regard, only either the payment amount or the tax amount may be output. Further, the output method may be either display output on a receipt or transmission output to the store server 20.
The receipt is not limited to a paper receipt, but may be an electronic receipt. That is, the output means may be means for outputting receipt data to a server that creates electronic receipts.

Incidentally, the amount of tax may be calculated using the payment method declared by the store or the corporate entity that operates the store to the National Tax Agency or the Tax Office, which is a subordinate organization thereof. Therefore, the tax amount calculation method for each payment category may be the following method.
For example, there is a method of calculating the tax amount for each payment category that is recorded as sales promotion expenses by calculating the tax amount for each tax category for payment categories that are not recorded as sales promotion expenses, and subtracting that tax amount from the tax amount for each tax category. .

To explain using the example in Figure 9, since the payment amount E1 of payment category "1" which is not recorded as sales promotion expenses is 6000 yen, the following formulas (6b) to (9b) are used to calculate tax categories "1" to "4". The respective amounts G11, G21, G31, and G41 are calculated.

G11=6,000*(1,000/10,280)=584...(6b)
G21=6,000*(2,000/10,280)=1,167...(7b)
G31=6,000*(3,000/10,280)=1,751...(8b)
G41=6,000*(4,000/10,280)=2,335...(9b)
Next, the tax amounts H11, H21, H31, and H41 for each of the tax categories "1" to "4" for the payment amount E1 of the payment category "1" are calculated using the following formulas (10b) to (13b).

H11=584*0.08=47...(10b)
H21=1,167*0.1=117...(11b)
H31=1,751-(1,751/1.08)=130...(12b)
H41=2,335-(2,335/1.1)=212...(13b)
According to the following formulas (14b) to (17b), from the tax amount for each tax category "1" to "4" stored in the tax category table area 32, the tax amount H11, H21, H31 of the corresponding tax category, By subtracting H41, the respective tax amounts H15, H252, H35, and H45 of payment category "5", which are recorded as sales promotion expenses, are indirectly calculated.

H15=80-47=33…(14b)
H25=200-117=83...(15b)
H35=222-130=92...(16b)
H45=364-212=152...(17b)
Furthermore, if there are multiple payments to be recorded as sales promotion expenses in multiple payment categories, the payment category with the largest payment amount is intentionally not used to reduce errors. That is, the tax amount for each tax category is calculated for payment categories with small payment amounts, and the tax amount for each tax category is further calculated for payment categories that are not recorded as sales promotion expenses. Then, by subtracting these tax amounts from the tax amount of each tax category, there is a method of calculating each tax amount of the payment category with the largest payment amount.

In the example of Figure 9, it is assumed that the payment amount E1 of payment category "1" which is not recorded as sales promotion expenses is 2000 yen, and the payment amount E6 of another payment category "6" which is recorded as sales promotion expenses is 4000 yen. Then, since the payment category with the smallest payment amount is "6", the amounts G16, G26, G36, and G46 for each tax category "1" to "4" are calculated using formulas (6c) to (9c) below. .

G16=4,000*(1,000/10,280)=389...(6b)
G26=4,000*(2,000/10,280)=778...(7b)
G36=4,000*(3,000/10,280)=1,167...(8b)
G46=4,000*(4,000/10,280)=1,556...(9b)
Next, the tax amounts H16, H26, H36, and H46 for each of the tax categories "1" to "4" are calculated for the payment amount E6 of the payment category "6" using equations (10c) to (13c) below.

H16=389*0.08=31...(10c)
H26=778*0.1=78...(11c)
H36=1,167-(1,167/1.08)=86...(12b)
H46=1,556-(1,556/1.1)=141...(13b)
Further, the amounts G11, G21, G31, and G46 for each of the tax categories "1" to "4" are calculated with respect to the payment amount E1 of the payment category "1" using the following formulas (6d) to (9d).

G11=2,000*(1,000/10,280)=195...(6d)
G21=2,000*(2,000/10,280)=389...(7d)
G31=2,000*(3,000/10,280)=584...(8d)
G41=2,000*(4,000/10,280)=778...(9d)
Next, the tax amounts H11, H21, H31, and H41 for each of the tax categories "1" to "4" are calculated for the payment amount E1 of the payment category "1" using the following formulas (10d) to (13d).

H11=195*0.08=16...(10d)
H21=389*0.1=39...(11d)
H31=584-(584/1.08)=43...(12d)
H41=778-(778/1.1)=71...(13d)
According to the following formulas (14d) to (17d), from the tax amount for each tax category "1" to "4" stored in the tax category table area 32, the tax amount H16, H26, H36 of the corresponding tax category, By subtracting H46 and the tax amounts H11, H21, H31, and H41, respectively, the tax amounts H15, H252, H35, and H45 of payment category "5", which are recorded as sales promotion expenses, are indirectly calculated.

H15=80-31-16=33...(14)
H25=200-78-39 =83...(15)
H35=222-86-43=93...(16)
H45=364-141-71=152...(17)
Incidentally, although the tax amounts for each payment category calculated as described above are not printed on the receipt except for some, they are output on the journal.

In the embodiment described above, the case where the payment amount for each payment category is input by key is exemplified. The method of inputting the payment amount is not limited to key input. For example, data on the payment amount may be input by reading a barcode printed on a discount coupon, cash coupon, etc. with a scanner. Further, when using electronic discount coupons or cash coupons held in a customer's mobile terminal, the mobile terminal and the POS terminal may perform wireless communication to obtain the payment category or amount.

Although several other 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 changes can be made without departing from the gist of the invention. These embodiments and modifications thereof are included within the scope of the invention, and are included within the scope of the invention described in the claims and its equivalents.
Note that the claims of the present application as originally filed are appended below.
[C1]
summing means for summing up the amount of the product for each tax category that classifies the type of tax imposed on the product;
Amount acquisition means for acquiring the payment amount for the product;
Calculation means for calculating the payment amount based on the ratio of the amounts totaled for each tax category by the totalization means;
Calculation means for calculating the tax amount of the type of tax specified in the tax classification from the payment amount calculated for each tax classification by the calculation means;
Output means for outputting at least one of the payment amount calculated for each tax category by the calculation means or the tax amount calculated for each tax category by the calculation means;
A product sales data processing device comprising:
[C2]
Payment for the payment amount acquired by the amount acquisition means from a storage unit that stores data identifying whether or not the payment method is a specific payment method for determining the proportion of the payment amount for each tax category for each payment category that classifies the payment method. data acquisition means for acquiring the data of the classification;
further comprising;
If the data acquired by the data acquisition means is data indicating the specific payment method, calculation processing by the calculation means and calculation processing by the calculation means for the payment amount by the specific payment method. The product sales data processing device according to claim 1, wherein the product sales data processing device executes the following steps.
[C3]
Issuing means for issuing a receipt in which data of one transaction is recorded;
further comprising;
The output means outputs the receipt by recording at least one of the payment amount calculated for each tax category by the calculation means or the tax amount calculated for each tax category by the calculation means. The product sales data processing device according to item 1 or 2.
[C4]
A communication means for communicating data with a server that collects data on one transaction;
further comprising;
The output means includes at least one of the payment amount calculated for each tax category by the calculation means or the tax amount calculated for each tax category by the calculation means in the data of the one transaction, and The product sales data processing device according to claim 1 or 2, wherein the product sales data processing device outputs the data by transmitting it to the server via a communication means.
[C5]
The computer of the product sales data processing equipment,
a totalizing means for summing up the amount of the product for each tax category that classifies the type of tax imposed on the product; an amount obtaining means for obtaining the amount paid for the product;
calculation means for calculating the payment amount based on the ratio of the amounts totaled for each tax category by the totalization means;
Calculation means for calculating the tax amount of the type of tax specified in the tax classification from the payment amount calculated for each tax classification by the calculation means, and
Output means for outputting at least one of the payment amount calculated for each tax category by the calculation means or the tax amount calculated for each tax category by the calculation means;
control program to function as

10... POS terminal, 20... Store server, 21... Product file, 22... Payment management table, 31... Registered product table area, 32... Tax classification table area, 33... Total amount including tax area, 34... Payment details table area, 35 ...Payment total amount area, 40...Receipt, 101...Processor, 102...Main memory, 103...Auxiliary storage device, 104...Clock, 105...Change machine interface, 106...Communication interface, 107...Keyboard, 108...Scanner, 109... First display, 110...Second display, 111...Printer, 112...System transmission line.

Claims (4)

summing means for summing up the amount of the product for each tax category that classifies the type of tax imposed on the product;
Amount acquisition means for acquiring the payment amount for the product;
Calculation means for calculating the payment amount based on the ratio of the amounts totaled for each tax category by the totalization means;
Calculation means for calculating the tax amount of the type of tax specified in the tax classification from the payment amount calculated for each tax classification by the calculation means;
Output means for outputting at least one of the payment amount calculated for each tax category by the calculation means or the tax amount calculated for each tax category by the calculation means;
Equipped with
Payment for the payment amount acquired by the amount acquisition means from a storage unit that stores data identifying whether or not the payment method is a specific payment method for determining the proportion of the payment amount for each tax category for each payment category that classifies the payment method. data acquisition means for acquiring the data of the classification;
further comprising;
If the data acquired by the data acquisition means is data indicating the specific payment method, calculation processing by the calculation means and calculation processing by the calculation means for the payment amount by the specific payment method. A product sales data processing device that executes . Issuing means for issuing a receipt in which data of one transaction is recorded;
further comprising;
The output means outputs the receipt by recording at least one of the payment amount calculated for each tax category by the calculation means or the tax amount calculated for each tax category by the calculation means. Item 1. Product sales data processing device. A communication means for communicating data with a server that collects data on one transaction;
further comprising;
The output means includes at least one of the payment amount calculated for each tax category by the calculation means or the tax amount calculated for each tax category by the calculation means in the data of the one transaction, and The product sales data processing device according to claim 1, wherein the product sales data processing device outputs the data by transmitting the data to the server via communication means. The computer of the product sales data processing equipment,
summing means for summing up the amount of the product for each tax category that classifies the type of tax imposed on the product;
Amount acquisition means for acquiring the payment amount for the product;
calculation means for calculating the payment amount based on the ratio of the amounts totaled for each tax category by the totalization means;
Calculation means for calculating the tax amount of the type of tax specified in the tax classification from the payment amount calculated for each tax classification by the calculation means, and
Output means for outputting at least one of the payment amount calculated for each tax category by the calculation means or the tax amount calculated for each tax category by the calculation means;
Payment for the payment amount acquired by the amount acquisition means from a storage unit that stores data identifying whether or not the payment method is a specific payment method for determining the proportion of the payment amount for each tax category for each payment category that classifies the payment method. data acquisition means for acquiring the data of the classification;
If the data acquired by the data acquisition means is data indicating the specific payment method, calculation processing by the calculation means and calculation processing by the calculation means for the payment amount by the specific payment method. an execution means for carrying out;
control program to function as