JP6778952B2 - Purchase amount burden determination program - Google Patents

Description

The present invention relates to a program used when a company bears lunch charges for employees.

In recent years, there has been a demand for companies to bear part of the meal costs of employees.

In such cases, the amount of money that can be recognized as a corporate expense for tax purposes is limited, and it is difficult to manage it.
This hinders companies from paying for 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 enables a company to pay for meals of an employee in a tax-free manner.

In order to achieve the above-mentioned object, the purchase amount burden determination program of the present invention provides, for each employee, the product / service identification data that identifies the product / service that the employee purchased at the store, and the purchase price thereof. The first step of acquiring the purchase history data indicating the purchase date and time data indicating the purchase date and time in association with the purchase price data shown, and the total of the purchase prices within a predetermined period for each employee. The second step of calculating the amount, the third step of calculating the first corporate burden maximum amount which is a predetermined ratio of the total amount, and the first corporate burden maximum amount are the second corporate burden. If it is less than or equal to the maximum amount, the first maximum amount borne by the company is set as the maximum amount borne by the company, and if the maximum amount borne by the first company exceeds the maximum amount borne by the second company, the maximum amount borne by the second company is used. The computer executes a fourth step of determining the amount of money as the company-paid amount and a fifth process of determining the total amount minus the company-paid amount as the employee-paid amount. Let me.

Preferably, the computer is made to perform a sixth step of storing the employee's contribution amount in a format that can be acquired by the payroll program.

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

Preferably, the employee program that operates on the terminal device of the employee, the purchase amount burden determination program according to claim 1 or 2 that operates on the terminal device of the company manager, and the terminal of the store. It has a store program that operates on the device.

Preferably, the employee program installs the employee burden amount and the company burden amount for the employee received in response to the execution of the company management program. It has a step of displaying on the screen of the terminal device.

Preferably, the store program includes the 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. It has a step of displaying a screen in an input field or a selection field and displaying a purchase history corresponding to a keyword input or selected in the input field or the selection field.

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

In addition, the other purchase amount burden determination program of the present invention includes, for each employee, product / service identification data that identifies the product / service that the employee purchased at the store, and purchase price data that indicates the purchase price. , The first step of acquiring the purchase history data indicating the purchase date and time in association with the purchase date and time data indicating the purchase date and time, and the first step of calculating the total amount of the purchase price within a predetermined period for each employee. If the first company-paid maximum amount, which is a predetermined ratio of the second process and the total amount, is less than or equal to the second company-paid maximum amount, the first company-paid maximum amount is displayed as the company-paid amount. When the maximum amount borne by the first company exceeds the maximum amount borne by the second company, the third step of displaying the maximum amount borne by the second company as the amount borne by the company and the total The computer is made to execute the fourth step of displaying the amount obtained by subtracting the company-paid amount from the amount as the employee-paid amount.

According to the present invention, it is possible to provide a program that enables a company to pay for meals of an employee in a tax-free manner.

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 corporate management server shown in FIG. FIG. 3 is a diagram for explaining the flow of services using the corporate 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 corporate management server 11 shown in FIGS. 1 and 2. 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 corporate management server shown in FIG. FIG. 9 is a flowchart for explaining the operation of the corporate management server of the corporate food system of the second embodiment of the present invention.

Hereinafter, the company food system according to the embodiment of the present invention will be described.
<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 has, 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, for example, portable terminal devices such as smartphones.
The employee terminal device 5 is provided with a new short-range data communication function (beacon).

FIG. 2 is a functional block diagram of the corporate management server 11 shown in FIG.
As shown 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 and a mouse.
The interface 27 is used, for example, to communicate with another computer.
The memory 29 temporarily stores data used for processing of the company management program PRG1 and the processing circuit 33 executed by the processing circuit 25.

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

The processing circuit 33 executes the company management program PRG1 to comprehensively control the processing of the company management server 11.
The processing of the corporate management server 11 shown in the present embodiment is described in the corporate management program PRG1.

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

FIG. 3 is a diagram for explaining a service flow using the company management server 11.
Step ST1:
The employee who is the target of receiving the lunch fee subsidy operates the employee terminal device 5 to activate the employee program PRG1.
Enter the ID and password 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, enter your ID and password to log in.

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

Step ST4:
At the time of accounting, the employee operates the employee terminal device 5 to display a QR code (registered trademark) unique to the employee on the screen.
At this time, the employee may present the employee ID or the like and present the employee identification information unique to the employee 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.
In addition, a ticket image displaying the amount of money 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 of money corresponding to the ticket image is transferred from the store to the company. You may be charged.

Further, in response to the operations of steps ST4 and ST5, the screen shown in FIG. 5 is displayed on the display of the store terminal device 7.

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 and time information, product identification information related to product purchase in steps ST4 and ST5, The purchase history information T1 including the purchase price information is transmitted.

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

The operation of the corporate management server 11 will be described below.
FIG. 6 is a flowchart for explaining the operation of the corporate management server 11 shown in FIGS. 1 and 2.
Step ST11:
The company management server 11 has, for each employee from the support company management server 13 via the interface 27, product identification data that identifies the product purchased by the employee, purchase price data indicating the purchase price, and the purchase thereof. The purchase history data T1 showing the date and time in association with the purchase date and time data is input.

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

Step ST13:
The processing circuit 33 calculates the first company-paid maximum amount B, which 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 equal to or less than the second maximum corporate burden amount C, and in the case of an affirmative determination, the process proceeds to step ST15 to determine a negative determination. In the case, the process proceeds to step ST16. The second maximum amount C paid by the company is the upper limit of the lunch fee that the company can bear under the tax law.

Step ST15:
The processing circuit 33 performs a process of 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 maximum company-paid amount C as the company-paid amount D.

Step ST17:
The processing circuit 33 performs a process of 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.
In addition, the stored data can be linked with an external system (accounting system, payroll system, etc.) in the form of CSV format output or API linkage.

For example, as shown in FIG. 4B, one page displays the purchase history for one month on the display of the employee terminal device 5. Press the previous month to display the history of the previous month. The amount borne by the employee and the amount borne by the company shall be half of the total amount. The maximum amount borne 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, one page displays the purchase history for one month. Press the previous month to display the history of the previous month.

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

Further, as shown in FIG. 7C, the transition occurs when the search is clicked on the screen of FIG. 7A. Register the company name on the screen. The company ID is automatically numbered 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, one page displays the purchase history for one month. Press the previous month to display the history of the previous month.

As shown in FIG. 8B, the transition occurs 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, the transition occurs when the setting is clicked on the screen of FIG. 8A. Register user. The user ID is automatically assigned by the system.

As explained above, according to the company meal system 1, the company can set the lunch fee of the employee within the range of less than half of the purchase price of lunch for one month and not exceeding the second maximum amount C paid by the company. You can easily calculate when you bear. Therefore, the company can bear the lunch fee of the employee as long as there is no tax problem.

<Second Embodiment>
FIG. 9 is a flowchart for explaining the operation of the corporate management server 11 of the corporate food system of the second embodiment of the present invention.
In FIG. 9, the steps with 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 are steps ST12 and ST22 that are conditional branching in step ST21.

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 and time is a predetermined lunch time or overtime time based on the purchase date and time data in the purchase history data T1, and determines that the purchase time is overtime. Step ST22, and if it is determined that it is lunch time, the process proceeds to step ST12.

Step ST22:
The processing circuit 33 determines the purchase price 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 food system of the second embodiment, it is possible to simplify the process in which the lunch fee is borne by the company under certain conditions and the overtime fee is borne by the company.

The present invention is not limited to the embodiments described above.
That is, one of ordinary skill in the art may make various changes, combinations, sub-combinations, and alternatives with respect to the components of the above-described embodiments within the technical scope of the present invention or the equivalent thereof.

In the above-described embodiment, the case where the present invention is applied to the company food system is illustrated, but in addition, the use of the sports gym may be applied to the purchase of products and the like.

This embodiment can be applied to, for example, a company food system.

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 unit 27 ... Interface 29 ... Memory 31 ... Database 33 ... Processing circuit

Claims (5)

For each employee, at least the product / service identification data that identifies 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. The first step of acquiring the purchase history data shown in
The second step of determining all or only a part of the purchase price calculated based on the purchase history data as the company's burden.
It is provided with a third step of determining whether it is lunch or overtime meal based on the purchase date and time.
The second step is executed for the purchase determined to be lunch by the third step.
A purchase amount burden determination program that causes a computer to execute a process for determining the purchase amount determined to be overtime meal. The purchase amount burden according to claim 1, further comprising a process of determining the amount obtained by subtracting the company burden amount from the total purchase price calculated based on the purchase history data as the employee burden amount. Decision program. The second step is
A process of calculating the total amount of the purchase price within a predetermined period for each employee, and
The process of calculating the first maximum amount borne by the company, which is a predetermined ratio of the total amount, and
When the first maximum amount borne by the company is equal to or less than the maximum amount borne by the second company, the maximum amount borne by the first company is defined as the maximum amount borne by the company, and the maximum amount borne by the first company is the second maximum amount borne by the company. If more than the maximum amount of corporate burden, characterized in that it comprises a and a step of performing processing for determining the second corporate burden maximum amount as the corporate burden,
The purchase amount burden determination program according to claim 2. The purchase amount burden determination program according to claim 2 or 3, further comprising a fourth step of storing the employee burden amount in a format that can be acquired by the salary calculation program. An employee program that runs on the employee's terminal device,

The purchase amount burden determination program according to claim 1 to 4, which operates on the terminal device of the company manager.
A store program that operates on the terminal device of the store,
Program with.

Images