JP2018072956A - Purchase amount burden determination program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a program which allows a company to bear meal charges of employees in a way which does not cause any tax problem.SOLUTION: A processing circuit 33 performs processing of determining whether a first maximum company-borne amount B is equal to or less than a second maximum company-borne amount C, and determines the first maximum company-borne amount B as a company-borne amount D when the determination is positive while determining the second maximum company-borne amount C as the company-borne amount D when the determination is negative.SELECTED DRAWING: Figure 6

Description

  The present invention relates to a program used when a company pays a lunch fee for an employee.

  In recent years, there has been a demand for companies to pay part of their meals.

In such cases, the amount allowed for corporate expenses is limited for tax purposes and is difficult to manage.
This hinders companies from paying their employees' meals.

  The present invention has been made in view of such circumstances, and an object of the present invention is to provide a program that allows a company to pay an employee's meal cost in a manner that is free from tax problems.

  In order to achieve the above-described object, the purchase amount burden determination program of the present invention determines, for each employee, the product / service identification data for identifying the product / service purchased by the employee at the store and the purchase price. A first step of acquiring purchase history data indicating the purchase price data shown and the purchase date data showing the purchase date and time, and the total of the purchase prices within a predetermined period for each employee A second step of calculating an amount; a third step of calculating a first maximum corporate burden amount which is a predetermined ratio of the total amount; and the first maximum corporate burden amount is a second corporate burden. When the maximum amount is less than the maximum amount, the first maximum amount paid by the company is set as the amount borne by the company. The amount of the company negative A fourth step of performing a process of determining the amount to execute a fifth step of performing a process of determining the amount obtained by subtracting the corporate burden amount from the total as employee contribution amount to the computer.

  Preferably, the computer is caused to execute a sixth step of storing the employee burden amount in a format that can be acquired by the salary calculation program.

  Preferably, on the basis of the purchase date and time, the seventh step of determining whether the meal is lunch or overtime, and the first to fifth steps are executed for the purchase made as lunch, and the overtime meal is determined. For purchase, the computer is caused to execute a process for determining the amount to be paid by the company.

  Preferably, an employee program that operates on the employee's terminal device, the purchase amount burden determination program according to claim 1 or 2 that operates on a company administrator's terminal device, and the store terminal And a store program that operates on the apparatus.

  Preferably, the employee program is installed with the employee-paid amount and the company-paid amount for the employee received in response to the execution of the company management program. A step of displaying on the screen of the terminal device.

  Preferably, the store program includes store usage period, company identification information, employee identification information, and purchased product / service identification information based on the purchase history information received in response to the execution of the company management program. The method includes a step of displaying a screen of the input field or selection field and displaying a purchase history corresponding to the keyword input or selected in the input field or selection field.

  Preferably, the purchase amount burden determination program displays a screen of an input column or a selection column for a store use period, store identification information, employee identification information, and purchased product / service identification information based on the purchase history information. And a step of displaying a purchase history corresponding to the keyword input or selected in the input field or selection field.

  In addition, the other purchase amount burden determination program of the present invention includes, for each employee, product / service identification data for identifying the product / service purchased by the employee at the store, purchase price data indicating the purchase price, The first step of acquiring purchase history data indicating the purchase date and time indicating the purchase date and time, and calculating the total amount of the purchase price within a predetermined period for each employee If the first enterprise-burden maximum amount, which is a predetermined ratio of the step 2 and the total amount, is less than or equal to the second enterprise-burden maximum amount, the first company-burden maximum amount is displayed as the company-burden amount. A third step of performing a process of displaying the second maximum corporate burden amount as the maximum corporate burden amount when the first maximum corporate burden amount exceeds the second maximum corporate burden amount; From the forehead Serial to be executed and a fourth step of performing a process of displaying the amount obtained by subtracting the corporate burden amount of money as the employee contribution amount of money on your computer.

  ADVANTAGE OF THE INVENTION According to this invention, the program which enables the company side to pay the meal cost of an employee by the method without a tax problem can be provided.

FIG. 1 is a system configuration diagram of a company food system according to an embodiment of the present invention. FIG. 2 is a functional block diagram of the company management server shown in FIG. FIG. 3 is a diagram for explaining a service flow using the company management server. FIG. 4 is a screen example of the employee terminal device. FIG. 5 is a screen example of the store terminal device. FIG. 6 is a flowchart for explaining the operation of the company management server 11 shown in FIGS. FIG. 7 is a screen example of the store terminal device. FIG. 8 is an example of a screen displayed on the display of the company management server shown in FIG. FIG. 9 is a flowchart for explaining the operation of the company management server of the company food system according to the second embodiment of the present invention.

Hereinafter, the company food system concerning the embodiment of the present invention is explained.
<First Embodiment>
FIG. 1 is a system configuration diagram of a company food system 1 according to an embodiment of the present invention.
As shown in FIG. 1, the company food system 1 includes, for example, an employee terminal device 5, a store terminal device 7, and a company management server 11, and communicates via these networks 9.

  The program executed by the employee terminal device 5, the store terminal device 7 and the company management server 11 is provided by, for example, the support company management server 13 or its administrator.

The employee terminal device 5 and the store terminal device 7 are portable terminal devices, such as a smart phone, for example.
The employee terminal device 5 has a new short-range data communication function (beacon).

FIG. 2 is a functional block diagram of the company management server 11 shown in FIG.
As illustrated in FIG. 2, the company management server 11 includes, for example, a display 23, an operation unit 25, an interface 27, a memory 29, a database 31, and a processing circuit 33.

  The display 23 displays various screens provided by the company management program PRG1 executed by the processing circuit 33.

The operation unit 25 is an operation means such as a keyboard or a mouse.
The interface 27 is used for communicating with other computers, for example.
The memory 29 temporarily stores the company management program PRG1 executed by the processing circuit 25 and data used for the processing of the processing circuit 33.

  The database 31 includes purchase history data indicating product / service identification data for identifying a product / service purchased by an employee, purchase price data indicating the purchase price, and purchase date / time data indicating the purchase date / time in association with each other. Is stored in a searchable format.

The processing circuit 33 executes the company management program PRG1 and controls the processes of the company management server 11 in an integrated manner.
The processing of the company management server 11 shown in this embodiment is described in the company management program PRG1.

  The employee terminal device 5 and the store terminal device 7 have basically the same configuration as the company management server 11 and execute an employee program PRG1 and a store program PRG2, respectively.

FIG. 3 is a diagram for explaining a service flow using the company management server 11.
Step ST1:
An employee who is subject to lunch assistance operates the employee terminal device 5 to start the employee program PRG1.
The ID and password are input on the screen of the display shown in FIG. 4A of the employee terminal device 5.

Step ST2:
The store clerk operates the store terminal device 7 to activate the store clerk program. Then, log in with your ID and password.

Step ST3:
The product ordered by the employee is selected on the screen of the store terminal device 7.

Step ST4:
At the time of accounting, an employee operates the employee terminal device 5 to display a unique QR code (registered trademark) on the screen.
At this time, the employee may present his / her employee ID card and present his / her own employee identification information to the store.

Step ST5:
The store clerk operates the store terminal device 7 to read the QR code (registered trademark) displayed by the employee in step ST4.
At this time, beacon communication may be performed between the employee terminal device 5 and the store terminal device 7.
Further, a ticket image displaying the amount is displayed on the employee terminal device 5, and the store clerk operates the ticket image with a finger or the like on the screen, so that the amount corresponding to the ticket image is transferred from the store to the company. You may be charged.

  Further, the screen shown in FIG. 5 is displayed on the display of the shop terminal device 7 in accordance with the operations of steps ST4 and ST5.

Step ST6:
From the store terminal device 7 to the support company management server 13, company identification information, employee identification information (user ID), store identification information (user ID), purchase date / time information, product identification information, Purchase history information T1 including purchase price information is transmitted.

Step ST7:
The support company management server 13 executes the support company management program in its processing circuit and generates purchase history information T2, T3, T4 based on the purchase history information T1, and the employee terminal device 5 and the store terminal respectively. It transmits to the apparatus 7 and the company management server 11.

Hereinafter, the operation of the company management server 11 will be described.
FIG. 6 is a flowchart for explaining the operation of the company management server 11 shown in FIGS.
Step ST11:
For each employee from the support company management server 13 via the interface 27, the company management server 11 is a product identification data for identifying a product purchased by the employee, purchase price data indicating the purchase price, and the purchase. The purchase history data T1 indicating the purchase date and time data indicating the date and time is input.

Step ST12:
The processing circuit 33 shown in FIG. 2 calculates, for each employee, a total purchase price A within a predetermined period (for example, a monthly salary period to be calculated).

Step ST13:
The processing circuit 33 calculates a first company-paid maximum amount B that is half (a predetermined ratio) of the total amount A calculated in step ST12.

Step ST14:
The processing circuit 33 performs a process of determining whether or not the first maximum corporate burden amount B is less than or equal to the second maximum corporate burden amount C. If the determination is affirmative, the process proceeds to step ST15, where a negative determination is made. In this case, the process proceeds to step ST16. The second maximum company-paid amount C is the upper limit of the lunch fee that the company can pay under the tax law.

Step ST15:
The processing circuit 33 performs processing for determining the first company-paid maximum amount B as the company-paid amount D.

Step ST16:
The processing circuit 33 performs a process of determining the second company-paid maximum amount C as the company-paid amount D.

Step ST17:
The processing circuit 33 performs processing for subtracting the company burden amount D from the total amount A and determining the result as the employee burden amount X.

Step ST18:
The processing circuit 33 stores the employee burden amount X in the database 31 in a searchable format.
The stored data can be linked to an external system (accounting system, payroll system, etc.) in the form of CSV output or API linkage.

  For example, as shown in FIG. 4B, the purchase history for one month is displayed on one page on the display of the employee terminal device 5. Pressing the previous month displays the previous month's history. The employee-paid amount and the company-paid amount are each half of the total amount. The maximum amount paid by the company is 3500 yen.

  As an example of the employee burden amount and the company burden amount, when the total amount is 8000 yen, the employee burden amount is 4500 yen and the company burden amount is 3500 yen.

FIG. 7 is an example of a screen displayed on the display of the store terminal device 7 shown in FIG.
As shown in FIG. 7A, the purchase history for one month is displayed on one page. Pressing the previous month displays the previous month's history.

  Also, as shown in FIG. 7B, transition is made when a search is clicked on the screen of FIG. 7A. Check the search conditions and enter the required information. Execute with the search button.

  Also, as shown in FIG. 7C, transition is made when a search is clicked on the screen of FIG. 7A. Register the company name on the screen. The company ID is automatically assigned by the system. Register the product. The product ID is automatically numbered.

FIG. 8 is an example of a screen displayed on the display of the company management server 11 shown in FIG.
As shown in FIG. 8A, the purchase history for one month is displayed on one page. Pressing the previous month displays the previous month's history.

  As shown in FIG. 8B, transition is made when the search is clicked in FIG. 8A. Check the search conditions and enter the required information. Execute with the search button.

  As shown in FIG. 8C, transition is made when setting is clicked on the screen of FIG. 8A. Register users. The user ID is automatically assigned by the system.

  As described above, according to the company meal system 1, the employee's lunch fee is reduced to less than half of the monthly purchase amount of the month and the second company-paid maximum amount C is not exceeded. Can be easily calculated. As a result, companies can pay for employee lunch as long as there are no tax problems.

Second Embodiment
FIG. 9 is a flowchart for explaining the operation of the company management server 11 of the company food system according to the second embodiment of the present invention.
9, steps denoted by the same reference numerals as those in FIG. 6 are the same as those described in the first embodiment.
That is, in the second embodiment, there is step ST21 between step ST11 and step ST12 shown in FIG. 6, and there is a conditional branching at step ST21 and steps ST12 and ST22.

Hereinafter, steps ST21 and ST22 will be described.
Step ST21:
When the processing circuit 33 of the company management server 11 specifies whether the purchase date / time is a predetermined lunch time or overtime based on the purchase date / time data in the purchase history data T1, and determines that it is overtime In step ST22, if it is determined that it is lunch time, the process proceeds to step ST12.

Step ST22:
The processing circuit 33 determines the purchase amount of the purchase as the company-paid amount D and stores it in the database 31 in a searchable format.

  As described above, according to the company meal system of the second embodiment, it is possible to simplify the process of setting the lunch fee as a corporate burden under a certain condition and all overtime charges as the corporate burden.

The present invention is not limited to the embodiment described above.
That is, those skilled in the art may make various modifications, combinations, subcombinations, and alternatives regarding the components of the above-described embodiments within the technical scope of the present invention or an equivalent scope thereof.

  In the above-described embodiment, the case where the present invention is applied to a company food system has been exemplified. However, the use of a gym may be applied to purchase of goods.

  This embodiment is applicable to a company food system or the like, for example.

DESCRIPTION OF SYMBOLS 1 ... Company food system 5 ... Employee terminal device 7 ... Store terminal device 11 ... Company management server 13 ... Support company management server 23 ... Display 25 ... Operation part 27 ... Interface 29 ... Memory 31 ... Database 33 ... Processing circuit

Claims (8)

For each employee, the product / service identification data for identifying the product / service purchased by the employee at the store, the purchase price data indicating the purchase price, and the purchase date / time data indicating the purchase date / time are associated with each other. A first step of obtaining purchase history data shown;
A second step of calculating, for each employee, a total amount of the purchase price within a predetermined period;
A third step of calculating a first enterprise-paid maximum amount that is a predetermined ratio of the total amount;
When the first maximum corporate burden amount is less than or equal to the second maximum corporate burden amount, the first maximum corporate burden amount is set as the corporate burden amount, and the first maximum corporate burden amount is the second enterprise burden amount. A fourth step of performing a process of determining the second company-paid maximum amount as the company-paid amount when the maximum burden is exceeded;
A purchase amount burden determination program for causing a computer to execute a fifth step of performing a process of determining the amount obtained by subtracting the company burden amount from the total amount as an employee burden amount. The purchase amount burden determination program according to claim 1, wherein the computer executes the sixth step of storing the employee burden amount in a format that can be acquired by a salary calculation program. A seventh step of determining whether lunch or overtime based on the purchase date and time;
Execute the first to fifth steps for the purchase that is said to be lunch,
The purchase price burden determining program according to claim 1 or 2, wherein said computer is caused to execute processing for determining said purchase burden determined as overtime meal as said company burden. An employee program operating on the employee terminal device;
The purchase amount burden determining program according to claim 1 or 2 that operates on a terminal device of a company manager;
A store program that operates on the terminal device of the store;
A program with The employee program includes the employee-paid amount of the employee received in response to the execution of the company management program and the company-paid amount of the terminal device on which the employee program is installed. The program according to claim 4, further comprising a step of displaying on a screen. The store program is based on the purchase history information received in response to the execution of the company management program, and is a store usage period, company identification information, employee identification information and purchased product / service identification information input fields or selections. The program according to claim 4, further comprising a step of displaying a screen of the field and displaying a purchase history corresponding to the keyword input or selected in the input field or the selection field. Based on the purchase history information, the purchase amount burden determination program displays an input field or a selection field for a store use period, store identification information, employee identification information, and purchased product / service identification information, and the input field Or the program of Claim 4 which has the process of displaying the purchase history applicable to the keyword input or selected into the selection column. For each employee, the product / service identification data for identifying the product / service purchased by the employee at the store, the purchase price data indicating the purchase price, and the purchase date / time data indicating the purchase date / time are associated with each other. A first step of obtaining purchase history data shown;
A second step of calculating, for each employee, a total amount of the purchase price within a predetermined period;
When the first maximum corporate burden amount, which is a predetermined ratio of the total amount, is equal to or less than the second maximum corporate burden amount, the first maximum corporate burden amount is displayed as the first corporate burden amount, and the first A third step of performing a process of displaying the second maximum corporate burden amount as the maximum corporate burden amount when the maximum maximum corporate burden amount exceeds the second maximum corporate burden amount;
A purchase amount burden determination program for causing a computer to execute a fourth step of performing a process of displaying the amount obtained by subtracting the company burden amount from the total amount as an employee burden amount.

Images