Withholding certificate management apparatus, withholding certificate management method, and withholding certificate management program
The withholding tax slip management device addresses the issue of forgotten tax slips for retirees by tracking employee status changes and issuing automated reminders, ensuring timely and compliant tax slip issuance.
Patent Information
- Application Number
- JP2023073168
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2023-04-27
- Publication Date
- 2024-11-08
- Estimated Expiration
- 2043-04-27
AI Technical Summary
There is a risk that payroll managers forget to issue withholding tax slips to retirees, leading to potential non-compliance and administrative inefficiencies.
A withholding tax slip management device equipped with a control unit that tracks employee status changes, calculates necessary tax adjustments, and outputs warnings for missing tax slips, ensuring timely issuance.
Prevents the omission of withholding tax slips for retirees by providing automated reminders and updates, enhancing administrative efficiency and compliance.
Smart Images

Figure 2024158185000001_ABST
Abstract
Description
[Technical Field]
[0001] The present invention relates to a tax withholding slip management device, a tax withholding slip management method, and a tax withholding slip management program. [Background technology]
[0002] Patent Document 1 discloses technology that supports tax return filing, which is an easy-to-use system for users, while still taking into consideration the accuracy of the values entered by the user. In this technology, when a taxpayer prepares a tax return themselves, and the number of dependents entered by the user differs from the information on the withholding slip, the system determines that the number of dependents has changed since the withholding slip was issued, and continues processing by regarding the entered number of dependents as the correct input value, while displaying a warning message indicating that it differs from the withholding slip. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] Japanese Patent Application Laid-Open No. 2011-204170 Summary of the Invention [Problem to be solved by the invention]
[0004] When an employee leaves the company, the payroll staff in the HR department or other department issues and hands out a withholding slip after a certain period of time has passed since the employee left. This task of issuing a withholding slip, which occurs when an employee leaves the company, is left to the payroll staff. As a result, there is a risk that the payroll staff will forget to issue a withholding slip to the employee.
[0005] The present invention has been made in consideration of the above, and aims to provide a withholding tax certificate management device, a withholding tax certificate management method, and a withholding tax certificate management program that can prevent forgetting to issue withholding tax certificates to retirees. [Means for solving the problem]
[0006] In order to solve the above-mentioned problems and achieve the object, a withholding slip management device equipped with a control unit is provided, which is capable of accessing a salary target year and month master that stores salary target years and months, salary payment month data that associates the target years and months with employee codes, bonus categories that indicate salary or bonus, and leave / retirement categories that indicate employment or retirement, and year-end adjustment data that associates the target years and months with processing categories that associate year-end adjustment processing details, tax table categories, and employee codes, and performs calculation processing for calculating the salary and bonus of a target person for the current target year and month by referring to the salary target year and month master, the salary payment month data, and the year-end adjustment data. and a determination unit that determines whether or not there is a mid-year adjustment indicating a year-end adjustment in the middle of the fiscal year in the processing category for the target month in the salary target month master that corresponds to the later result, for the employee code whose employee leave retirement category changed from employment to retirement in the target month corresponding to the current target month after January of the current year and before the current target month in the salary target month master, and if it is determined that there is no mid-year adjustment, an output control unit that outputs a warning that a withholding slip has not been issued to the employee code whose employee leave retirement category changed from employment to retirement.
[0007] Furthermore, a withholding tax slip management method according to the present invention is a withholding tax slip management method executed by a withholding tax slip management device having a control unit, wherein the withholding tax slip management device has access to a salary target year and month master that stores salary target years and months, salary payment month data that associates target years and months with employee codes, bonus categories that indicate salary or bonuses, and leave of absence / retirement categories that indicate employment or retirement, and year-end adjustment data that associates target years and months with processing categories that associate year-end adjustment processing contents, tax table categories, and employee codes, and the withholding tax slip management method executed by the control unit refers to the salary target year and month master, the salary payment month data, and the year-end adjustment data, and executes the withholding tax slip management method for the current target year and month. and an output control step for outputting a warning that a withholding slip has not been issued to the employee code whose retirement category for leave of absence has changed from employment to retirement in the target month corresponding to the current target month after January of the current year in the salary target month master, which corresponds to the result of the calculation process of the salary and bonus calculation for the employee.
[0008] The withholding tax slip management program according to the present invention is a withholding tax slip management program to be executed by a withholding tax slip management device having a control unit, the withholding tax slip management device being able to access a salary target year and month master that stores salary target years and months, salary payment month data that associates the target years and months with employee codes, bonus categories that indicate salary or bonuses, and leave of absence / retirement categories that indicate employment or retirement, and year-end adjustment data that associates the target years and months with processing categories that associate year-end adjustment processing contents, tax table categories, and employee codes, and refers to the salary target year and month master, the salary payment month data, and the year-end adjustment data to cause the control unit to execute the program, and The system is characterized by including a determination step of determining whether or not there is a mid-year adjustment indicating a year-end adjustment in the middle of the fiscal year in the processing category for the target month corresponding to the target year and month from January of the current year onwards and before the current target month in the salary target year and month master corresponding to the result of calculation processing of the target person's salary and bonus in the target year and month, where the employee code whose leave of absence retirement category changed from employment to retirement in the target year and month corresponding to the current target month exists; and an output control step of outputting a warning that a withholding tax certificate has not been issued to the employee code whose leave of absence retirement category changed from employment to retirement when it is determined that there is no mid-year adjustment. [Effects of the Invention]
[0009] According to the present invention, it is possible to prevent forgetting to issue withholding slips to retirees. [Brief explanation of the drawings]
[0010] [Figure 1] FIG. 1 is a schematic diagram showing an overview in a block diagram of an example of the configuration of a withholding tax slip management device according to an embodiment. [Figure 2] FIG. 2 is a diagram illustrating an example of a salary target year / month master table stored in the salary target year / month master of the withholding tax slip management device according to the embodiment. [Figure 3] FIG. 3 is a diagram illustrating an example of a bonus eligible year / month master table stored in the bonus eligible year / month master of the withholding tax slip management device according to the embodiment. [Figure 4] FIG. 4 is a diagram showing an example of the background of work done by a payroll manager for a former employee. [Figure 5] FIG. 5 shows an example of the work background of a former employee to the tax office and the payroll staff at his or her new employer. [Figure 6] FIG. 6 is a diagram showing another example of the background of work provided to a former employee by a payroll manager. [Figure 7] FIG. 7 is a diagram showing another example of the background of work provided to the tax office by a former employee. [Figure 8] FIG. 8 is a flowchart showing an outline of the processing executed by the withholding tax slip management device according to the embodiment. [Figure 9] FIG. 9 is a diagram illustrating an example of a salary payment month data table in the salary payment month data of the tax withholding slip management device according to the embodiment. [Figure 10] FIG. 10 is a diagram showing an example of a year-end adjustment data table in the year-end adjustment data of the tax withholding slip management device according to the embodiment. [Figure 11] FIG. 11 is a diagram illustrating an outline of a salary calculation process performed by a determination unit included in a withholding tax slip management device according to an embodiment. [Figure 12] FIG. 12 is a diagram showing an example of a warning screen that the output control unit of the withholding tax slip management device according to the embodiment displays on the monitor 114. As shown in FIG. [Figure 13] FIG. 13 is a diagram illustrating an example of a situation after updating by the updating unit included in the withholding tax slip management device according to the embodiment and an outline of the subsequent determination. [Figure 14] FIG. 14 is a diagram showing another example of the salary payment month data table in the salary payment month data of the tax withholding slip management device according to the embodiment. [Figure 15] FIG. 15 is a diagram showing another example of the year-end adjustment data table in the year-end adjustment data of the tax withholding slip management device according to the embodiment. [Figure 16] FIG. 16 is a diagram illustrating an outline of a salary calculation process performed by a determination unit included in a withholding tax slip management device according to an embodiment. [Figure 17]FIG. 17 is a diagram showing an example of a warning screen that is displayed on a monitor by an output control unit included in the withholding tax slip management device according to the embodiment. [Figure 18] FIG. 18 is a diagram illustrating an example of a situation after updating by the updating unit included in the withholding tax slip management device according to the embodiment and an outline of the subsequent determination. DETAILED DESCRIPTION OF THE INVENTION
[0011] Hereinafter, embodiments of a withholding tax slip management device, a withholding tax slip management method, and a withholding tax slip management program according to the present invention will be described in detail with reference to the accompanying drawings. Note that the present invention is not limited to these embodiments.
[0012] [1. Configuration] An example of the configuration of a withholding tax slip management device according to this embodiment will be described with reference to Fig. 1 etc. Fig. 1 is a schematic diagram showing an overview in a block diagram of an example of the configuration of a withholding tax slip management device.
[0013] 1 is a commercially available desktop personal computer. Note that the withholding tax slip management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.
[0014] The withholding tax slip management device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. Each unit included in the withholding tax slip management device 100 is connected to each other so as to be able to communicate with each other via any communication path.
[0015] The communication interface unit 104 communicatively connects the withholding tax slip management device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the withholding tax slip management device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). The data stored in the memory unit 106 may also be stored in the server 200, for example.
[0016] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that functions as a pointing device in cooperation with a mouse. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.
[0017] The memory unit 106 stores various databases, tables, files, and the like. The memory unit 106 stores computer programs that cooperate with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes. The memory unit 106 may be, for example, a memory device such as RAM (Random Access Memory) or ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The memory unit 106 stores a salary year and month master 106a, a bonus year and month master 106b, salary payment month data 106c, and year-end adjustment data 106d. Details of the salary payment month data 106c and year-end adjustment data 106d will be described later.
[0018] The payroll year and month master 106a stores the payroll year and month. FIG. 2 is a diagram showing an example of a payroll year and month master table stored in the payroll year and month master 106a. The payroll year and month master table T1 shown in FIG. 2 stores the current payroll year and month. For example, the payroll year and month master table T1 stores the current target "FALSE" in association with each of the target year and month "2023 / 02" and "2023 / 03", and stores the current target "TRUE" in association with the target year and month "2023 / 04".
[0019] The bonus target year and month master 106b stores the bonus target year and month. Figure 3 is a diagram showing an example of a bonus target year and month master table stored in the bonus target year and month master 106b. The bonus target year and month master table T2 shown in Figure 3 stores the bonus target year and month. For example, the bonus target year and month master table T2 stores the target year and month "2022 / 06", "2022 / 12", and "2023 / 03" in association with the current target "FALSE", and stores the target year and month "2023 / 06" in association with the current target "TRUE". In addition to the bonus for each specified month, bonuses also include lump sums, etc.
[0020] Returning to FIG. 1, the description of the configuration of the withholding tax slip management device 100 will be continued. The control unit 102 is a CPU or the like that comprehensively controls the withholding tax slip management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs. The control unit 102 includes a determination unit 102a, a selection unit 102b, an acquisition unit 102c, an output control unit 102d, and an update unit 102e.
[0021] The determination unit 102a performs a salary / bonus determination process to determine whether the current operation of the withholding tax slip management device 100 is a salary or a bonus. Specifically, the determination unit 102a determines whether the current operation of withholding tax slip management set by the payroll operator H1 in the withholding tax slip management device 100 via the input device 112 is a salary standard or a bonus standard. The determination unit 102a also performs a calculation process for the salary / bonus calculation for the subject selected by the selection unit 102b for the current target year / month, and determines whether an interim year-end adjustment indicating a year-end adjustment midway through the fiscal year exists in the processing category for the target year / month master 106a for the target year / month from January of the current year to the current target year / month corresponding to the result of the calculation process, for the employee CD (code) whose leave of absence / retirement category changed from employment to retirement in the target year / month corresponding to the current target year / month after January of the current year to the current target year / month. In addition, the determination unit 102a refers to the bonus target year and month master 106b, salary payment month data 106c, and year-end adjustment data 106d, and performs a calculation process to calculate the salary and bonus for the current target year and month of the selected person selected by the selection unit 102b, and after the calculation process, determines whether a new payment has been made to a retired employee CD who has a mid-year adjustment in the processing category of the year-end adjustment data 106d for January or later of the current year in the bonus target year and month master 106b corresponding to the result.
[0022] The selection unit 102b performs a target month determination process to select the current target month by referring to the payroll target month master 106a or the bonus target month master 106b. The selection unit 102b also selects a target employee according to the employee CD input via the input device 112 by the payroll manager.
[0023] The acquisition unit 102c acquires the salary payment month data 106c and the year-end tax adjustment data 106d from the storage unit 106.
[0024] When the judgment unit 102a judges that a withholding tax certificate needs to be reissued for the former employee CD, the output control unit 102d outputs a warning to the monitor 114 to the former employee CD that a withholding tax certificate needs to be reissued.
[0025] The update unit 102e performs an update process to update the data in the year-end adjustment data table T20 to indicate that a withholding slip has been issued for the employee CD, in accordance with the operation content input by the payroll manager via the input device 112.
[0026] [2. Business Background Overview] FIG. 4 is a diagram showing an example of the business background of a payroll worker providing a former employee with information about the work. FIG. 5 is a diagram showing an example of the business background of a former employee providing information about the work of a payroll worker at the tax office and at the employee's new employer. FIG. 6 is a diagram showing another example of the business background of a former employee providing information about the work of a payroll worker. FIG. 7 is a diagram showing another example of the business background of a former employee providing information about the work of a tax office.
[0027] As shown in Figures 4 and 6, when a retiree H2 (employee) retires, first, a payroll administrator H1 issues and hands over a withholding slip (Column A) or a withholding slip (Column B) listing the total amount paid up to the time of retirement. Then, as shown in Figures 5 and 7, the retiree H2 submits the withholding slip (Column A) or the withholding slip (Column B) to the tax office H3 or the payroll administrator H4 at his new employer to use for the year-end tax adjustment and tax return at his new employer.
[0028] However, in the past, there was no system in place to let payroll manager H1 know if he had forgotten to issue a withholding slip to former employee H2. Because payroll manager H1 waits some time after former employee H2 leaves the company to issue the withholding slip, he tends to forget to issue the withholding slip, but there was no system in place to let him know.
[0029] Furthermore, after resigning, when filing his / her year-end tax adjustment or tax return, former employee H2 notices that he / she has not received a withholding slip from his / her previous company (payroll personnel H1) and contacts them to request the issuance of a withholding slip. As a result, payroll personnel H1 becomes aware of the non-issuance of the withholding slip through the contact from the former employee. Furthermore, in addition to issuing withholding slips, payroll personnel H1 is also responsible for preparing notifications of loss of eligibility for social insurance and notifications of loss of eligibility for employment insurance, and a large amount of work is highly dependent on individual tasks. As such, payroll personnel H1 has a desire for technology that can prevent him / her from forgetting to issue withholding slips because of the large amount of work that is highly dependent on individual tasks.
[0030] [3. Processing of the withholding slip management device] Next, we will explain the processing executed by the withholding tax slip management device 100. Fig. 8 is a flowchart showing an outline of the processing executed by the withholding tax slip management device 100. In the following, it is assumed that in order to issue a withholding tax slip, the withholding tax slip management device 100 has tallied the total amount of payment in Column A, the total amount of payment in Column B, etc. from January of the current year to the processing execution month.
[0031] 8, first, the determination unit 102a performs a salary / bonus determination process (step S1) to determine whether the current operation of the withholding tax slip management device 100 is a salary or a bonus. Specifically, the determination unit 102a determines whether the current withholding tax slip management operation set in the withholding tax slip management device 100 by the payroll operator H1 via the input device 112 is a salary standard or a bonus standard.
[0032] Next, if the determination unit 102a determines that the current operation of the withholding tax slip management device 100 is salary (step S2: Yes), the withholding tax slip management device 100 proceeds to step S3. On the other hand, if the determination unit 102a determines that the current operation of the withholding tax slip management device 100 is not salary, that is, a bonus (step S2: No), the withholding tax slip management device 100 proceeds to step S10.
[0033] In step S3, the selection unit 102b refers to the payment target year and month master table 106a and performs a target year and month determination process to select the current target year and month. Specifically, the selection unit 102b selects the current target year and month, "2023 / 04," from the payment target year and month master table T1 (see FIG. 2).
[0034] Next, the selection unit 102b performs a target person selection process to select a target person for payroll calculation according to the employee CD (code) input by the payroll person H1 via the input device 112 (step S4).
[0035] Thereafter, the acquiring unit 102c acquires the salary payment month data 106c and the year-end tax adjustment data 106d from the storage unit 106 (step S5).
[0036] FIG. 9 is a diagram showing an example of a salary payment month data table in the salary payment month data 106c.
[0037] The salary payment month data table T10 shown in Figure 9 stores, for each target year and month, an employee CD, a bonus classification indicating salary or bonus, and a leave of absence / retirement classification indicating employment, retirement, leave of absence, etc. Specifically, the first row of the salary payment month data table T10 stores, in association with the target year and month "2023 / 03," an employee CD of "10001," a bonus classification "0: salary," and a leave of absence / retirement classification "0: employment."
[0038] Note that for employee CD "10003" in the salary payment month data table T10 in Figure 9, the leave of absence / retirement category for the target year and month "2023 / 03" is "0: Employed," but the leave of absence / retirement category for the target year and month "2023 / 04" has transitioned to "0: Retired." Therefore, payroll personnel H1 would normally be required to issue a withholding slip and hand it over to retiree H2, but the situation in this embodiment is shown in schematic form. In other words, the following explanation assumes that a withholding slip has not yet been issued for employee CD "10003."
[0039] FIG. 10 is a diagram showing an example of the year-end adjustment data table in the year-end adjustment data 106d.
[0040] The year-end adjustment data table T20 shown in Figure 10 stores the target year and month in association with the processing category indicating the type of year-end adjustment, the tax table category, and the employee CD (code). Specifically, the first row of the year-end adjustment data table T20 stores the target year and month "2022 / 12", the processing category "1: December year-end adjustment", the tax table category "1: Column A", and the employee CD "10001". Here, mid-year year-end adjustment is a year-end adjustment made in the middle of the fiscal year for retirees.
[0041] Returning to FIG. 8, the description of step S6 and subsequent steps will be continued. The determination unit 102a refers to the salary target year and month master 106a, salary payment month data 106c, and year-end adjustment data 106d, and performs a calculation process for calculating the salary and bonus for the current target year and month of the target person selected by the selection unit 102b (step S6).
[0042] Next, the determination unit 102a determines whether or not there is a mid-year adjustment indicating a year-end adjustment in the middle of the fiscal year in the processing category for the target month corresponding to the target month and year from January of the current year to the current target month in the salary target month master 106a corresponding to the result of the calculation process in step S6, where the employee CD whose retirement category for administrative leave changed from employment to retirement in the target month corresponding to the current target month exists (step S7). If the determination unit 102a determines that there is a mid-year adjustment indicating a year-end adjustment in the middle of the fiscal year in the processing category for the target month corresponding to the target month and year from January of the current year to the current target month in the salary target month master 106a corresponding to the result of the calculation process in step S7, where the employee CD whose retirement category for administrative leave changed from employment to retirement in the target month corresponding to the current target month exists (step S7: Yes), the withholding tax slip management device 100 ends this process. On the other hand, if the judgment unit 102a determines that for employee CD whose leave of absence retirement category changed from employed to retired in the target month corresponding to the current target month after January of the current year and before the current target month in the salary target month master 106a, there is no mid-year adjustment indicating a year-end adjustment in the middle of the fiscal year in the processing category for the target month after January of the current year and before the current target month in the salary target month master 106a (step S7: No), the withholding tax slip management device 100 proceeds to step S8.
[0043] FIG. 11 is a diagram that shows a schematic overview of the salary calculation process by the determination unit 102a. As shown in FIG. 11, in the case of the processing execution month "2023 / 04" and employee CD "10003," the determination unit 102a determines whether or not there is a mid-year year-end adjustment indicating a mid-year year-end adjustment corresponding to employee CD "10003," whose leave of absence / retirement category in the salary payment month data table T10 in the salary payment month data 106c has changed from "employed" to "retired," in the processing category for the target year and month corresponding to the current target year and month after January of the current year in the salary target year and month master 106a. In the case shown in FIG. 11, there is no mid-year year-end adjustment indicating a mid-year year-end adjustment corresponding to employee CD "10003" in the year-end adjustment data table T21. Therefore, the determination unit 102a determines that for employee CD "10003," there is no mid-year adjustment indicating a year-end adjustment performed midway through the fiscal year in the processing category for the target year and month corresponding to the current target year and month after January of the current year in the payroll target year and month master 106a. In this case, retiree H2 is necessarily excluded from the payroll calculation. Therefore, the determination unit 102a performs the determination process to confirm whether a withholding slip has not been issued for retiree H2 only for retiree H2 (a person not subject to calculation execution). In other words, there is no omission of a target due to the selection status of the person subject to payroll calculation. Therefore, in FIG. 11, after performing payroll calculation for employee CD "10001," the withholding slip management device 100 performs the determination process to confirm whether a withholding slip has not been issued for employee CD "10003," whose leave of absence / retirement category before the target year and month corresponding to the result has changed from "employed" to "retired."
[0044] Returning to FIG. 8, the description of step S8 and subsequent steps will be continued. The output control unit 102d outputs a warning to the monitor 114 that a tax withholding slip has not been issued for employee CD whose leave of absence / retirement category has changed from employment to retirement (step S8).
[0045] FIG. 12 is a diagram showing an example of a warning screen that the output control unit 102d causes the monitor 114 to display.
[0046] The warning screen P1 shown in Figure 12 includes a message M1 indicating that a withholding slip has not been issued for employee CD, whose retirement status has changed from "active employee" to "retired," information M2 about the employee CD for whom a withholding slip has not been issued, a details button B1 that displays detailed information about the employee CD for whom a withholding slip has not been issued, and an OK button B2 that accepts input that the message M1 has been confirmed. The information M2 about the employee CD for whom a withholding slip has not been issued includes at least the employee CD, the employee's name, and the date of retirement. After confirming the contents of message M1, the payroll administrator H1 may use the input device 112 to cause the withholding slip management device 100 to transition to a screen that allows the issuance of a withholding slip, and issue the withholding slip.
[0047] Returning to FIG. 8, the description of step S9 and subsequent steps will be continued. The update unit 102e performs an update process to update the data on the withholding slip issued corresponding to employee CD "10003" in the year-end adjustment data table T20, in accordance with the operation content input by the payroll manager H1 via the input device 112 (step S9).
[0048] FIG. 13 is a diagram showing an example of the situation after updating by the update unit 102e and an outline of the subsequent determination.
[0049] As shown in FIG. 13, the update unit 102e updates the target year and month corresponding to employee CD "10003" in the salary payment month data table T10 by associating "2023 / 04" with the processing category "3: Mid-year adjustment" and "1: Column A" with the tax table category. This prevents withholding slips from being issued to former employees. After step S9, the withholding slip management device 100 terminates this process.
[0050] Returning to FIG. 8, the description of step S10 and subsequent steps will be continued. The selection unit 102b refers to the bonus target year and month master table 106b and performs a target year and month determination process to select the current target year and month (step S10). Specifically, the selection unit 102b selects the currently target "2023 / 06" from the bonus target year and month master table T2 (see FIG. 3).
[0051] Next, the selection unit 102b performs a target selection process to select a target person for bonus calculation according to the employee CD (code) input by the payroll manager H1 via the input device 112 (step S11).
[0052] Thereafter, the determination unit 102a refers to the bonus target year and month master 106b, the salary payment month data 106c, and the year-end adjustment data 106d, and performs a calculation process for calculating the salary and bonus for the current target year and month of the selected person selected by the selection unit 102b (step S12).
[0053] Next, after the calculation process of step S12, the determination unit 102a determines whether a new payment has been made to a retired employee CD whose processing category for the year-end adjustment data 106d for January or later of the current year in the bonus eligible year and month master 106b corresponding to the calculation result has been included (step S13). If the determination unit 102a determines that a new payment has been made to a retired employee CD whose processing category for the year-end adjustment data 106d for January or later of the current year in the bonus eligible year and month master 106b has been included (step S13: Yes), the withholding tax slip management device 100 proceeds to step S14. On the other hand, if the determination unit 102a determines that a new payment has not been made to a retired employee CD whose processing category for the year-end adjustment data 106d for January or later of the current year in the bonus eligible year and month master 106b has been included (step S13: No), the withholding tax slip management device 100 terminates this process.
[0054] Here, a method for determining a bonus by the determining unit 102a will be described. Figure 14 is a diagram showing another example of the salary payment month data table in the salary payment month data 106c. Figure 15 is a diagram showing another example of the year-end adjustment data table in the year-end adjustment data 106d. Note that, in the following, the determination unit 102a determines whether or not a withholding slip needs to be reissued for an employee (retiree) whose retirement category for leave of absence is "retired" at the time of bonus calculation and who incurred a total taxable amount in the target year and month after the "mid-year annual adjustment from January of the current year onwards."
[0055] The salary payment month data table T30 shown in Figure 14 stores the employee CD (code), bonus classification, leave of absence retirement classification, and total tax amount in association with the target year and month. Specifically, the second row of the salary payment month data table T30 stores the target year and month "2023 / 05" in association with the employee CD "10005", bonus classification "0: salary", leave of absence retirement classification "3: retirement", and total tax amount "0".
[0056] 15, the year-end adjustment data table T40 stores the target year and month in association with the processing category, tax table category, employee CD (code), and total annual tax amount. Specifically, the fourth row of the year-end adjustment data table T40 stores the target year and month "2023 / 05," the processing category "3: Mid-year adjustment," the tax table category "1: Column A," the employee CD "10005," and the total annual tax amount "1,200,000." Note that in May 2023, the payroll administrator H1 registered the mid-year adjustment via the input device 112, and a withholding slip was issued to the retiree H2 for employee CD "10005."
[0057] Fig. 16 is a diagram showing a schematic overview of the salary calculation process by the determination unit 102a. As shown in Fig. 11, the withholding slip management device 100 calculates the bonus for retired employee CD "10005" according to the salary payment month "2023 / 05" of the current target year and month, and issues a withholding slip for the middle of the fiscal year. Thereafter, the determination unit 102a determines, based on the salary payment month data table T31 and the year-end adjustment data table T40, whether a reissue of the withholding slip is necessary for retired employee CD "10005" because a total taxable amount (payment) has occurred since the withholding slip was issued.
[0058] In the case of the target year and month "2023 / 05" shown in FIG. 16, the retired employee CD "10005" is stored in the salary payment month data table T31 in the salary payment month data 106c, where the leave of absence retirement category is "retirement" and the processing category is stored as "3: mid-career annual adjustment," indicating that a withholding tax certificate has been issued. However, when the current target year and month is the salary payment month "2023 / 06," the retired employee CD "10005" has incurred a total tax amount of "400,000" in the bonus category "1: bonus." Therefore, in the case shown in FIG. 16, the judgment unit 102a determines that a withholding tax certificate needs to be reissued for the retired employee CD because new payments have been made since the withholding tax certificate was issued.
[0059] Returning to FIG. 8, the description of step S14 and subsequent steps will be continued. If the judgment unit 102a determines that a withholding tax certificate needs to be reissued for the former employee CD, the output control unit 102d outputs a warning to the monitor 114 to the former employee CD that a withholding tax certificate needs to be reissued (step S14).
[0060] FIG. 17 is a diagram showing an example of a warning screen that the output control unit 102d causes the monitor 114 to display.
[0061] 17 includes a message M3 indicating that the withholding slip has not been reissued for the employee CD of the former employee, information M4 about the employee CD of the former employee who needs a withholding slip reissued, a details button B1 that displays detailed information about the employee CD of the former employee who needs a withholding slip reissued, and an OK button B2 that accepts input that the message M3 has been confirmed. After confirming the contents of message M3, the payroll administrator H1 may use the input device 112 to cause the withholding slip management device 100 to transition to a screen that allows the withholding slip to be reissued, and then reissue the withholding slip.
[0062] Returning to FIG. 8, the description of step S15 and subsequent steps will be continued. The update unit 102e deletes the data registered in the mid-career pay adjustment, and re-registers and updates the mid-career pay adjustment after reviewing the annual payment status (step S15).
[0063] FIG. 18 is a diagram showing an example of the situation after updating by the update unit 102e and an outline of the subsequent determination.
[0064] As shown in Figure 18, the update unit 102e deletes the row with the processing category "3: Mid-year adjustment", tax table category "1: Column A", and total annual taxable amount "1,200,000" for the target year and month "2023 / 05" corresponding to employee CD "10005" that is already registered in the year-end adjustment data table T41. The update unit 102e then updates the year-end tax adjustment data table T41 by associating the target year and month "2023 / 06" with the following new items for the January-May salary: processing category "3: Mid-career annual adjustment," tax table category "1: Column A," employee CD "10005," and total annual tax amount "1,200,000." The update unit 102e also updates the target year and month "2023 / 06" with the following new items for the June bonus: processing category "3: Mid-career annual adjustment," tax table category "1: Column B," employee CD "10005," and total annual tax amount "400,000." This prevents forgetting to reissue a withholding slip for retiree H2, even if he or she receives a salary such as a bonus (lump sum) after the withholding slip is issued. If no new payments are made after July, the person is excluded from the evaluation by the evaluation unit 102a.
[0065] According to the embodiment described above, the determination unit 102a performs a calculation process for salary and bonus calculations, and if it is determined that there is no mid-year adjustment indicating a year-end adjustment in the middle of the fiscal year in the processing category for the target month corresponding to the current target month and after January of the current year and before the current target month in the salary target month master 106a corresponding to the result of the calculation process, the output control unit 102d outputs a warning to employee CD whose retirement category for leave of absence has changed from employment to retirement that a withholding tax certificate has not been issued, thereby preventing forgetting to issue a withholding tax certificate to retiree H2.
[0066] Furthermore, according to the embodiment, when the judgment unit 102a determines that a new payment has been made to a former employee CD who has a mid-year adjustment in the processing category of the year-end adjustment data 106d for January or later of the current year in the bonus eligible year and month master 106b, the output control unit 102d outputs a warning to the former employee CD who has a mid-year adjustment that a withholding slip needs to be reissued, so that even if a salary such as a bonus (lump sum) is paid to the former employee H2 after the withholding slip is issued, it is possible to prevent forgetting to issue a withholding slip to the former employee H2.
[0067] Furthermore, according to the embodiment, the output control unit 102d outputs information regarding employees who have not been issued withholding tax certificates or retired employees who require a withholding tax certificate to be reissued, so that the payroll manager H1 can intuitively grasp the employee information from the content displayed on the monitor 114.
[0068] Furthermore, according to the embodiment, when the update unit 102e reissues a withholding tax certificate for a retired employee CD for whom a mid-career tax certificate exists, the most recent mid-career tax certificate corresponding to the retired employee CD for whom a mid-career tax certificate exists in the year-end adjustment data 106d is deleted, and the mid-career tax certificates for different tax table categories are re-registered to update the year-end adjustment data. Therefore, even if a salary such as a bonus (lump sum) is paid to the retired employee H2 after the withholding tax certificate is issued, it is possible to register the issuance of a withholding tax certificate to the retired employee H2.
[0069] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to the achievement of SDGs Goals 8 and 9.
[0070] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.
[0071] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.
[0072] 5. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.
[0073] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.
[0074] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed as desired unless otherwise specified.
[0075] Furthermore, with regard to the withholding slip management device 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.
[0076] For example, all or any part of the processing functions of the withholding tax slip management device 100, particularly the processing functions performed by the control unit, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory, computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the withholding tax slip management device 100 as needed. That is, a computer program for providing instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form the control unit.
[0077] In addition, this computer program may be stored in an application program server connected to the withholding tax slip management device 100 via any network, and all or part of it may be downloaded as needed.
[0078] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.
[0079] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.
[0080] The various databases stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.
[0081] The withholding tax slip management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as an information processing device connected to any peripheral device. The withholding tax slip management device 100 may also be realized by installing software (including programs, data, etc.) that causes the device to perform the processes described in this embodiment.
[0082] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Industrial Applicability]
[0083] The present invention is useful in industries where there is a high rate of employee joining and leaving, such as retail and temporary staffing. [Explanation of symbols]
[0084] 100 Withholding tax slip management device 102 Control section 102a Judgment part 102b Selection section 102c Acquisition Department 102d Output control section 102e update section 104 Communication interface unit 106 Storage section 106a Payroll Master 106b Bonus target year and month master 106c Salary payment month data 106d Year-end tax adjustment data 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network
Claims
1. A tax withholding slip management device including a control unit, A salary target date master that stores the salary target date; Salary payment month data that corresponds to the employee code, bonus category indicating salary or bonus, and leave / retirement category indicating employment or retirement for the target year and month, Year-end adjustment data that corresponds to the processing category, tax table category, and employee code that correspond to the year-end adjustment processing content for the target year and month, is accessible to The control unit is a determination unit which refers to the salary target month and year master data, the salary payment month data and the year-end adjustment data, and determines whether or not there is a mid-year adjustment indicating a year-end adjustment in the middle of a fiscal year in the processing category for the target month corresponding to the current target month and year after January of the current year and before the current target month in the salary target month and year master data corresponding to the result of the calculation processing of the salary and bonus calculation of the target person in the current target month and year, for an employee code in which the leave of absence or retirement category changed from employment to retirement in the target month corresponding to the current target month and year; an output control unit that outputs a warning to the employee code whose leave of absence or retirement category has changed from employment to retirement, when it is determined that the mid-career adjustment does not exist, that a withholding slip has not been issued; To have A tax withholding slip management device comprising:
2. 2. The tax withholding slip management device according to claim 1, Bonus target year and month master that stores the bonus target year and month, is more accessible to The determination unit is With reference to the bonus year and month master, the salary payment month data, and the year-end tax adjustment data, it is further determined whether a new payment has been made for the employee code who left the company and whose processing category includes the mid-year tax adjustment after January of the current year; The output control unit is When it is determined that a new payment has been made to the employee code of a former employee for whom the mid-career adjustment exists in the processing category, a warning is output to the employee code of the former employee for whom the mid-career adjustment exists that a reissue of a tax withholding slip is necessary; A tax withholding slip management device comprising:
3. 3. The tax withholding slip management device according to claim 2, The output control unit is Further output information about employees who have not been issued withholding slips or who have left the company and need to have their withholding slips reissued, A tax withholding slip management device comprising:
4. 4. The tax withholding slip management device according to claim 3, The control unit is Further comprising an update unit which, when a withholding slip is reissued for a retired employee code for which the mid-year tax return exists, deletes the mid-year tax return immediately preceding the retired employee code for which the mid-year tax return exists in the year-end adjustment data, and re-registers the mid-year tax return of a different tax table category to update the year-end adjustment data; A tax withholding slip management device comprising:
5. A tax withholding slip management method executed by a tax withholding slip management device having a control unit, The tax withholding slip management device includes: A salary target date master that stores the salary target date; Salary payment month data that corresponds to the employee code, bonus category indicating salary or bonus, and leave / retirement category indicating employment or retirement for the target year and month, Year-end adjustment data that corresponds to the processing category, tax table category, and employee code that correspond to the year-end adjustment processing content for the target year and month, is accessible to Executed by the control unit, a determination step of referring to the salary target month and year master, the salary payment month data and the year-end adjustment data, and determining whether or not there is a mid-year adjustment indicating a year-end adjustment in the middle of a fiscal year in the processing category for the target month corresponding to the current target month and year after January of the current year and before the current target month in the salary target month and year master corresponding to the result of the calculation processing of the salary and bonus calculation of the target person in the current target month and year, for an employee code in which the leave of absence or retirement category changed from employment to retirement in the target month corresponding to the current target month and year; an output control step of outputting a warning that a withholding slip has not been issued to an employee code whose leave of absence / retirement category has changed from employment to retirement when it is determined that the mid-career adjustment does not exist; containing, A method for managing tax withholding slips, comprising:
6. A tax withholding slip management program to be executed by a tax withholding slip management device having a control unit, The tax withholding slip management device includes: A salary target date master that stores the salary target date; Salary payment month data that corresponds to the employee code, bonus category indicating salary or bonus, and leave / retirement category indicating employment or retirement for the target year and month, Year-end adjustment data that corresponds to the processing category, tax table category, and employee code that correspond to the year-end adjustment processing content for the target year and month, is accessible to To cause the control unit to execute a determination step of referring to the salary target month and year master, the salary payment month data and the year-end adjustment data, and determining whether or not there is a mid-year adjustment indicating a year-end adjustment in the middle of a fiscal year in the processing category for the target month corresponding to the current target month and year after January of the current year and before the current target month in the salary target month and year master corresponding to the result of the calculation processing of the salary and bonus calculation of the target person in the current target month and year, for an employee code in which the leave of absence or retirement category changed from employment to retirement in the target month corresponding to the current target month and year; an output control step of outputting a warning that a withholding slip has not been issued to an employee code whose leave of absence / retirement category has changed from employment to retirement when it is determined that the mid-career adjustment does not exist; containing, A tax withholding slip management program featuring the following features.
Citation Information
Patent Citations
Salary information management system, server, method and program
JP2003091622A
Progress management system of personnel procedure, progress management method of personnel procedure, program of progress management system of personnel procedure, and record medium storing program
JP2016035667A
Information processor and program
JP2019215765A
Final tax return support system, final tax return support device, final tax return preparation method and program
JP2011204170A
