Business support device, business support method, and business support program
The business support device automates the updating of employee tax payment information by managing municipal and government-designated city masters, addressing the labor-intensive and error-prone manual process of handling municipal changes.
Patent Information
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- OBIC CO LTD
- Filing Date
- 2024-12-20
- Publication Date
- 2026-07-02
Smart Images

Figure 2026110109000001_ABST
Abstract
Description
Technical Field
[0006] , , , ,
[0001] The present invention relates to a business support device, a business support method, and a business support program.
Background Art
[0002] In principle, in the salary business, in order for a company to prepare a final report on the annual salary payment for each employee, it is necessary for each employee to submit a salary payment report to the municipality where they live every January. The municipality determines the employee's resident tax for the coming year based on this salary payment report, and from the following year, the company pays the resident tax to the municipality on behalf of the employee. Conventionally, as a tax payment system, for example, there is Patent Document 1.
Prior Art Documents
Patent Documents
[0003]
Patent Document 1
Summary of the Invention
Problems to be Solved by the Invention
[0004] However, when a municipality is merged or abolished, each time, depending on the change of employee information and the place of residence, it is necessary to change the above-mentioned submission / deposit destination information. Conventionally, since the person in charge has changed it manually, there is a problem that the work load is large and work mistakes occur.
[0005] The present invention has been made in view of the above, and an object thereof is to provide a business support device, a business support method, and a business support program capable of reducing the work load and work mistakes when updating information related to employee tax payment when a municipality is merged or abolished.
Means for Solving the Problems
[0006] To solve the above-mentioned problems and achieve the objective, the present invention provides a business support device equipped with a control unit, wherein the control unit is configured to access employee information including the employee, pay date, the city / ward / town / village where the employee resides, the city / ward / town / village to which the payroll report is submitted if the city / ward / town / village where the employee resides is a government-designated city, and the city / ward / town / village to which the resident tax is paid if the city / ward / town / village where the employee resides is a government-designated city and is a special collection handling area; a city / ward / town / village master registered in association with the revision date, city / ward / town / village, submission city / ward / town / village, and payment city / ward / town / village; and a government-designated city master registered in association with the city / ward / town / village, government-designated city, and payment city / ward / town / village, and is equipped with a master maintenance means that updates the city / ward / town / village master and the government-designated city master in response to operator operations when municipalities are merged or abolished, and updates the employee information in bulk based on the updated city / ward / town / village master and government-designated city master.
[0007] Furthermore, according to one aspect of the present invention, when a merger or abolition of a municipality occurs, the master maintenance means updates the revision date and municipality of the municipal master on the municipal master screen in response to the operator's operation, (2) if the merged or abolished municipality is a government-designated city, updates the government-designated city master on the government-designated city master in response to the operator's operation, the merged or abolished municipality and the government-designated city, or the government-designated city and the municipality to which payment is made, and (3) based on the updated government-designated city master, for the municipality in the updated municipal master, the municipality to which payment is made is a government-designated city, or (4) In the municipal master maintenance screen, the system may update the municipalities to which submissions are made and the municipalities to which payments are made, and in the municipal master maintenance screen, it may launch the merger information screen for the details of the merged municipalities, enter the municipalities before and after the change in the merger information screen, and based on the input in the merger information screen, update the municipality for the target employee in the employee information, using the current pay year and municipality as the key, and (5) further, based on the updated municipal master, update the municipality to which submissions are made, or the municipalities to which submissions are made and the municipalities to which payments are made, using the current pay year and municipality as the key.
[0008] Furthermore, according to one aspect of the present invention, the master maintenance means may, in the employee information, refer to the municipal master and update the municipality to which the employee submits and the municipality to which the employee pays, using the current pay year and month and municipality as keys.
[0009] Furthermore, according to one aspect of the present invention, the special collection and handling area may be Yokohama City.
[0010] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the present invention provides a business support method executed by an information processing device equipped with a control unit, wherein the control unit includes employee information including the employee, pay date, the city / ward / town / village where the employee resides, the city / ward / town / village to which the payroll report is submitted if the city / ward / town / village where the employee resides is a government-designated city, and the city / ward / town / village to which resident tax is paid if the city / ward / town / village where the employee resides is a government-designated city and is a special collection handling area, as well as the revision date, city / ward / town / village, and submission city / ward The system is configured to allow access to a municipal master database that registers towns and villages and the municipalities to which payments are received, and a designated city master database that registers municipalities, designated cities, and the municipalities to which payments are received. The system includes a master maintenance process that, when municipalities are merged or consolidated, updates the municipal master database and the designated city master database in response to operator operations, and updates the employee information in bulk based on the updated municipal master database and designated city master database.
[0011] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the present invention provides a business support program to be executed by an information processing device equipped with a control unit, wherein the control unit includes employee information including the items of employee, pay date, city / ward / town / village where the employee resides, the city / ward / town / village to which the pay report is submitted if the city / ward / town / village where the employee resides is a government-designated city, and the city / ward / town / village to which resident tax is paid if the city / ward / town / village where the employee resides is a government-designated city and is a special collection handling area, as well as the revision date, city / ward / town / village, and submission destination city / ward / town / village. The system is configured to provide access to a municipal master database in which payment recipient municipalities are registered in association with each municipality, and a designated city master database in which municipalities, designated cities, and payment recipient municipalities are registered in association with each municipality. The control unit is configured to run a business support program that, in the event of mergers or consolidations of municipalities, updates the municipal master database and the designated city master database in response to operator operations, and then updates the employee information in bulk based on the updated municipal master database and designated city master database. [Effects of the Invention]
[0012] According to the present invention, when municipalities are merged or consolidated, it is possible to reduce the workload and errors that occur when updating information on employees' tax payments. [Brief explanation of the drawing]
[0013] [Figure 1] Figure 1 is a block diagram showing an example of the configuration of a business support device according to this embodiment. [Figure 2] Figure 2 is a data relationship diagram for municipal master data, designated city master data, and employee information. [Figure 3A] Figure 3A is a diagram illustrating the relationship between the municipal code, the municipal code to which the document is submitted, and the municipal code to which payment is made. [Figure 3B] Figure 3B shows the sheet titled "List of Special Collection Handling Districts in Yokohama City." [Figure 4] Figure 4 is a diagram showing the relationships between codes. [Figure 5] Figure 5 is a diagram illustrating a specific example of the processing of the master maintenance section of the business support device according to this embodiment. [Figure 6] Figure 6 is a diagram illustrating a specific example of the processing of the master maintenance section of the business support device according to this embodiment. [Figure 7] Figure 7 is a diagram illustrating a specific example of the processing performed by the master maintenance unit of the business support device according to this embodiment. [Figure 8] Figure 8 is a diagram illustrating a specific example of the processing performed by the master maintenance unit of the business support device according to this embodiment. [Figure 9] Figure 9 is a diagram illustrating a specific example of the processing of the master maintenance section of the business support device according to this embodiment. [Figure 10] Figure 10 is a diagram illustrating a specific example of the processing of the master maintenance section of the business support device according to this embodiment. [Figure 11] Figure 11 is a diagram illustrating a specific example of the processing of the master maintenance section of the business support device according to this embodiment. [Figure 12]FIG. 12 is a diagram for explaining a specific example of the processing of the master maintenance unit of the business support apparatus according to the present embodiment. [Figure 13] FIG. 13 is a diagram for explaining a specific example of the processing of the master maintenance unit of the business support apparatus according to the present embodiment. [Figure 14] FIG. 14 is a diagram for explaining a specific example of the processing of the master maintenance unit of the business support apparatus according to the present embodiment. [Figure 15] FIG. 15 is a diagram for explaining a specific example of the processing of the master maintenance unit of the business support apparatus according to the present embodiment. [Figure 16] FIG. 16 is a diagram for explaining a specific example of the processing of the master maintenance unit of the business support apparatus according to the present embodiment. [Embodiment for Carrying Out the Invention]
[0014] Embodiments of the present invention will be described in detail based on the drawings. Note that the present invention is not limited to the present embodiment.
[0015] [1. Overview] The overview of the present invention will be described in the order of [1-1. Background and Problems] and [1-2. Solution].
[0016] [1-1. Background and Problems] In principle, in the salary business, in order for a company to prepare a final report on the annual salary payment for each employee, each employee is required to submit a salary payment report to the municipality where they live every January. Based on this salary payment report, the municipality determines the inhabitant tax for the employee for the following year, and from the following year, the company pays the inhabitant tax to the municipality on behalf of the employee.
[0017] In addition, only for employees living in ordinance-designated cities, it is necessary to submit a salary payment report or pay the inhabitant tax in an ordinance-designated city other than the administrative district where they live. In addition, residents of Yokohama City, which is an ordinance-designated city, are further required to pay the inhabitant tax to the administrative district corresponding to the location of the special levy obligor (company, etc.), and the payment destination is different from the administrative district where they live.
[0018] In this case, it becomes necessary to manage specific employees separately based on the city / ward of residence, the designated city to which they submit their salary payment reports, and the administrative district to which they pay their resident tax. Therefore, when a new employee joins the company, it is necessary to register the submission and payment destinations with the city / ward of residence, and re-registration will be required if municipalities are merged or consolidated.
[0019] However, whenever municipalities are merged or consolidated, it becomes necessary to change employee information and, depending on their place of residence, the aforementioned submission / payment destination information. Traditionally, this has been done manually by staff, resulting in a heavy workload and a high risk of errors.
[0020] [1-2. Solution] In this invention, the mergers and consolidations of municipalities are managed in a master database and reflected in the tax information of employee information. This reduces the workload and errors such as omissions when updating employee tax payment information in the event of municipal mergers or consolidations.
[0021] The business support device of the present invention has the following functions. (1) A function to manage separately the administrative district of the employee's address and the administrative district to which payments are made. (2) A function to link and manage the master data of government-designated cities and the master data of municipalities.
[0022] [2. Structure] Referring to Figure 1, an example of the configuration of the business support device according to this embodiment will be described. Figure 1 is a block diagram showing an example of the configuration of the business support device 100 according to this embodiment.
[0023] The business support device 100 may be, for example, a workstation or a personal computer. The business support device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the business support device 100 is connected to communicate via any communication path.
[0024] The communication interface unit 104 connects the business support device 100 to the network 300 via communication devices such as routers and wired or wireless communication lines such as dedicated lines, enabling communication between the two devices. The communication interface unit 104 also has the function of communicating data with other devices via communication lines. Here, the network 300 has the function of connecting the business support 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).
[0025] The input / output interface unit 108 is connected to an input device 112 and an output device 114. The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, mouse, microphone, or a monitor that works in conjunction with the mouse to provide pointing device functionality. Note that in the following, the output device 114 may be referred to as the monitor 114.
[0026] The storage unit 106 stores various databases, tables, and files. The memory unit 106 stores computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. The memory unit 106 can 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.
[0027] Furthermore, the memory unit 106 stores municipal master data 106a, government-designated city master data 106b, conversion master data (not shown), employee information, etc. Figure 2 is a data relationship diagram of municipal master data 106a, government-designated city master data 106b, and employee information. Figure 3A is a diagram explaining the relationship between municipal code, submission destination municipal code, and payment destination municipal code. Figure 3B is a diagram showing the "Yokohama City Special Collection Collection Handling District List" sheet. Figure 4 is a diagram showing the code relationship.
[0028] Employee information may include, as shown in Figure 2, employee (employee code and / or employee name), pay month and year, city / ward (city / ward code and / or city / ward name), destination city / ward (destination city / ward code and / or destination city / ward name), and destination city / ward (destination city / ward code and / or destination city / ward name).
[0029] The municipal code, the municipal code to which the document is submitted, and the municipal code to which payment is made are explained with reference to Figures 3A, 3B, and 4.
[0030] The "municipal code" is a code that all employees are required to register, and is linked to the address in which an employee resides. All municipalities in the 47 prefectures are registered.
[0031] The "Submission Destination Municipality Code" is for employees residing in one of the 20 designated cities. This code is linked to the designated city where the employee resides, and employees should register the designated city that best represents their place of residence from the list of designated cities. The "Submission Destination Municipality Code" is used as the destination for the salary payment reports submitted to the municipality.
[0032] The 20 cities designated as "government-ordinance designated cities" are Osaka, Nagoya, Yokohama, Kobe, Kitakyushu, Sapporo, Kawasaki, Fukuoka, Hiroshima, Sendai, Chiba, Saitama, Shizuoka, Sakai, Niigata, Hamamatsu, Okayama, Kumamoto, Sagamihara, and Kyoto.
[0033] The "Payment Destination Municipality Code" is for employees residing in Yokohama City and is a code linked to the employee's address and the company's location. The special collection handling district is registered from the "Yokohama City Special Collection Handling District List (Public Information) https: / / www.city.yokohama.lg.jp / kurashi / koseki-zei-hoken / zeikin / y-shizei / kojin-shiminzei-kenminzei / kojin-shiminzei-shosai / kyuuhou.files / 0007_20210108.pdf" sheet. The "Payment Destination Municipality Code" is used to determine the destination of resident tax payments to the municipality.
[0034] Employee information is referenced when determining where to submit payroll reports and where to pay resident taxes. The control unit 102 refers to the employee information stored in the storage unit 106 to determine where to submit the employee's payroll reports and where to pay resident taxes.
[0035] As shown in Figure 2, the municipal master 106a can consist of tables that register and associate the revision date, municipality (municipal code and / or municipality name), postal code, address, destination municipality (submission destination municipality code and / or destination municipality name), and payment destination municipality (payment destination municipality code and / or payment destination municipality name).
[0036] As shown in Figure 2, the government-designated city master 106b can consist of tables that register and associate municipalities (municipal code and / or municipal name), government-designated cities (government-designated city code and / or government-designated city name), and municipalities to which payments are made (municipal code and / or municipality name to which payments are made).
[0037] The reason for retaining two items in employee information—the submission destination city / ward code and the payment destination city / ward code—is that changes in city / ward codes, mergers and acquisitions of designated cities, or employee relocations are anticipated. Therefore, the employee information table is structured to retain these items in a yearly management format based on the pay period.
[0038] The conversion master can consist of a table or similar document that associates municipal codes or designated city codes with municipal names or designated city names. The conversion master is referenced by the control unit 102 when converting these codes and names. For example, when a code / name is specified on the display screen, the corresponding name / code is automatically displayed.
[0039] Returning to Figure 1, the control unit 102 is a CPU or similar component that comprehensively controls the business support device 100. The control unit 102 has internal memory for storing control programs such as the OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs.
[0040] The control unit 102 is configured to access the municipal master 106a, government-designated city master 106b, conversion master (not shown), employee information, etc., which are stored in the storage unit 106. The municipal master 106a, government-designated city master 106b, conversion master (not shown), employee information, etc. may be stored in another location (for example, server 200), as long as the control unit 102 can access them.
[0041] Functionally, the control unit 102 comprises a master maintenance unit 102a, an employee information registration unit 102b, and a screen display control unit 102c.
[0042] The master maintenance unit 102a performs editing operations on the municipal master 106a, such as registering, adding, changing, or deleting data, in response to operator operations on the municipal master maintenance screen. The municipal master maintenance screen displays data from the municipal master 106a stored in the storage unit 106, allowing the user to check the registration status of the data in the municipal master 106a.
[0043] The master maintenance unit 102a performs editing such as registering, adding, changing, and deleting data in the designated city master 106b in response to operator operations on the designated city master maintenance screen, for example. The designated city master maintenance screen reads and displays the data of the designated city master 106b stored in the memory unit 106, allowing the registration status of the data in the designated city master 106b to be confirmed.
[0044] When municipalities are merged or consolidated, the Master Maintenance Unit 102a updates the municipal master 106a and the designated city master 106b in response to operator operations, and then updates employee information in bulk based on the updated municipal master 106a and designated city master 106b.
[0045] Specifically, when a municipality is merged or consolidated, the master maintenance unit 102a updates the revision date, municipality, postal code, and address of the municipal master 106a in response to the operator's operation on the municipal master maintenance screen; (2) if the merged or consolidated municipality is a designated city, it updates the merged or consolidated municipality and its designated city, or the designated city and the municipality to which payment is made, in the designated city master screen in response to the operator's operation; and (3) based on the updated designated city master, it updates the municipality in the updated municipal master 106a that is a designated city. (4) Update the municipality to which the submission and payment destinations are designated cities, on the municipality master maintenance screen, launch the merger information screen for the details of the merged municipality, enter the changed and changed municipalities on the merger information screen, and based on the input on the merger information screen, update the municipality for the target employee in the employee information, using the current pay year and municipality as the key, (5) Furthermore, based on the updated municipality master 106a, update the municipality to which the submission and payment destinations are for the target employee in the employee information, using the current pay year and municipality as the key.
[0046] Furthermore, the Master Maintenance Unit 102a, for new employees in the employee information, refers to the municipal master 106a and updates the municipalities to which the information is submitted and to which it is paid, using the current pay year and municipality as keys.
[0047] The employee information registration unit 102b registers employee information such as employee code, pay year and month, and city / ward / town / village on the employee information registration screen displayed on the monitor 114, for example. The city / ward / town / village, submission destination city / ward / town / village, and payment destination city / ward / town / village of the employee information are updated in bulk by the master maintenance unit 102a. On the employee information registration screen, the employee information data stored in the memory unit 106 is read and displayed, allowing the registration status of the employee information data to be confirmed.
[0048] The screen display control unit 102c controls the display of various screens shown on the monitor 114 (for example, the municipal master maintenance screen, the government-designated city master maintenance screen, the merger and consolidation information screen, and the employee information registration screen) and the acceptance of input on the screen.
[0049] [3. Specific examples] Referring to Figures 1 to 16, a specific example of the processing of the master maintenance unit 102a of the business support device 100 in this embodiment will be described. Below, two patterns will be described as examples of cases in which the municipality codes to which employee information is submitted and the municipality codes to which payments are made: [3-1. Batch updating of municipality codes to which new employees are submitted and the municipality codes to which payments are made] and [3-2. Changes due to mergers and consolidations of municipalities].
[0050] [3-1. Batch updating of the municipality codes for submissions and payments for new employees] Refer to Figures 5 to 7 to explain how to update the submission destination city / ward / town / village codes and payment destination city / ward / town / village codes for new employees all at once. The update of the submission destination city / ward / town / village codes and payment destination city / ward / town / village codes for new employees is performed using the following procedure. (1) Check the registration status of new employees in the employee information. (2) The employee information will be updated to reflect the submission destination municipality code and the payment destination municipality code, using the municipality code as the key.
[0051] (1) Check the registration status of new employees. In the following example, employees A through G are new recruits. Figure 5 shows an example of the employee information data registration status. At the time of joining the company, as shown in Figure 5, only the employee's salary year and month and the city / ward code of their place of residence are registered in the employee information.
[0052] (2) Refer to the municipal master 106a for employee information and use the municipal code as the key to collectively update the submission destination municipal code and payment destination municipal code.
[0053] Figure 6 shows an example of the display of the municipal master maintenance screen. The municipal master maintenance screen displays data read from the municipal master 106a stored in the memory unit 106. As shown in Figure 6, the municipal master maintenance screen includes an area for specifying the revision year and month, an area for specifying the municipal code, municipal name, postal code, address, submission destination municipal code, payment destination municipal code, etc., a "Reflect to Employee Information" button for reflecting the contents of the municipal master 106a to employee information, a "To Consolidation Information" button for displaying the consolidation information screen, a "To Designated City" button for launching the designated city master maintenance screen, and an "Register" button (not shown) for registering / updating data in the municipal master 106a according to the input content on the screen.
[0054] In Yokohama City, the recipient of resident tax payments is determined by the location of the special withholding agent (company, etc.). In this example, assuming the location is in Shinagawa Ward, Tokyo, the designated city code is set to 141046 (Naka Ward).
[0055] When the "Reflect to Employee Information" button is pressed, the system references the municipal master 106a and updates the municipal code to which employee information is submitted and the municipal code to which payment is made, using the current payroll year and month (2024 / 4) and municipal code as keys. Figure 7(A) shows the registration status of the data in the municipal master 106a. Figure 7(B) shows the registration status of the employee information after the update.
[0056] In this example, the municipal master 106a is referenced, and in the employee information, for D, E, F, and G, the municipal codes "231011", "2331029", "141011", and "141020" are used as keys to reflect (set) the submission destination municipal code "231002", submission destination municipal code "231002", submission destination municipal code "141030", and payment destination municipal code "141046", submission destination municipal code "141030", and payment destination municipal code "141046".
[0057] In this way, it becomes possible to update the submission destination city / ward / town / village code and payment destination city / ward / town / village code for each employee in bulk, preventing maintenance errors.
[0058] [3-2. Changes due to the merger or consolidation of municipalities] Refer to Figures 8 to 16 to explain the changes resulting from the merger and consolidation of municipalities. The changes resulting from the merger and consolidation of municipalities will be carried out in the following procedure. (1) Check the designated city master 106b / municipal master 106a and employee information before the merger or consolidation. (2) Register the municipal master 106a after the merger or consolidation has taken place. (3) Register the Master 106b of the government-designated cities after the mergers and consolidations have taken place. (4) Change the municipality codes in employee information from the codes before the merger to the codes after the merger. (5) The employee information will be updated in one go, reflecting the municipality code for submission and the municipality code for payment from the municipality code.
[0059] The above procedure is explained in detail below.
[0060] (1) Check the municipal master data 106a / designated city master data 106b and employee information before the merger or consolidation. Figure 8(A) shows the registration status of the municipal master data 106a. Figure 8(B) shows the registration status of the designated city master data 106b. Figure 8(C) shows the registration status of employee information.
[0061] (2) Update the municipal master 106a after the merger or consolidation has taken place. Figure 9(A) shows the municipal master data maintenance screen before the update. Figure 9(B) shows the municipal master data maintenance screen after the update.
[0062] (2)-1. In the municipal master maintenance screen shown in Figure 9(A), if the entries "Chikusa Ward: 231011" and "Meito Ward: 231029" (both with thick borders) are merged into "Shin-Chikusa Ward: 23101X", an update registration must be performed on the municipal master maintenance screen.
[0063] As shown in Figure 9(B), a new revision date "2024 / 4" is added, the rows for "Chikusa-ku:231011" and "Meito-ku:231029" are deleted, and the row for "Shin-Chikusa-ku:23101X" is added.
[0064] Figure 10 shows the registration status of the updated municipal master 106a. In the new revision month of "2024 / 4", the rows for "Chikusa Ward" and "Meito Ward" have been deleted, so no data exists for them.
[0065] (3) Register the designated city master 106b after the merger or consolidation has taken place. If "Chikusa Ward" and "Meito Ward" are merged into "New Chikusa Ward," update the registration on the government-designated city master maintenance screen.
[0066] Figure 11(A) shows an example of the display of the municipal master maintenance screen (similar to Figure 9(B)). On the municipal master maintenance screen, press (execute) the "Go to Designated City" button to launch the designated city master maintenance screen as shown in Figure 11(B).
[0067] Figure 11(B) shows an example of the display of the government-designated city master maintenance screen. The government-designated city master maintenance screen displays data from the government-designated city master 106b stored in the memory unit 106. As shown in Figure 11(B), the government-designated city master maintenance screen includes an area for specifying the revision year and month, an area for specifying the municipal code, municipal name, government-designated city code, government-designated city name, payment destination municipal code, payment destination municipal name, etc., an "Execute" button for updating the municipal master 106a, and an "Register" button (not shown) for registering / updating data corresponding to the input content on the screen to the government-designated city master 106b.
[0068] As shown in Figure 12(A), in the government-designated city master maintenance screen, delete the rows for "Chikusa-ku" and "Meito-ku," and add a row for "Shin-Chikusa" (municipal code "23101X," municipal name "Shin-Chikusa-ku," government-designated city code "231002," government-designated city name "Nagoya City"). In the case of Yokohama City, the payment destination municipal code and payment destination municipal name should also be added.
[0069] Figure 12(B) shows the registration status of the updated Designated City Master 106b. When the "Execute" button is pressed on the Designated City Master Maintenance screen shown in Figure 12(A), the Municipal Master 106a is updated based on the updated Designated City Master 106b, and the submission destination municipality code "231002" for the added "Shin-Chikusa" is added. As mentioned above, the submission destination municipality code is the Designated City code. Figure 12(C) shows the registration status of the updated Municipal Master 106a. Data does not exist for "Chikusa-ku" and "Meito-ku" because the rows have been deleted. If the merger is in Yokohama City, Kanagawa Prefecture, the payment destination municipality code can also be registered for the added municipality.
[0070] (4) Change the employee information in bulk from the municipal code before the merger to the municipal code after the merger.
[0071] (4)-1. Change the municipality codes from the pre-merger / consolidation period to the post-merger / consolidation period in bulk. Figure 13(A) shows an example of the display of the municipality master maintenance screen. On the municipality master maintenance screen, select the details for municipality code "23101X" and press (execute) the "To Merger / Consolidation Information" button. When you press (execute) the "To Merger / Consolidation Information" button, the merger / consolidation information screen will be displayed.
[0072] Figure 13(B) shows an example of the display of the merger information screen. The merger information screen is used to generate merger information consisting of the changed municipal code and municipal name, and the municipal code and municipal name before the change. The merger information screen has an area to display the items for the changed municipal code and municipal name, and the municipal code and municipal name before the change, and an "Execute" button to reflect the changes in employee information. The changed municipal code and municipal name are those selected on the municipal master maintenance screen. The operator enters the municipal code and municipal name before the change. In this example, Chikusa-ku and Meito-ku are entered as the municipal codes before the change (enter the wards that were merged into Shin-Chikusa-ku).
[0073] When the "Execute" button is pressed, employee information will be updated according to the input on the merger / consolidation information screen. Specifically, employee information will be updated using the current pay year / month (2024 / 4) and municipal code as keys.
[0074] Figure 14(A) shows the registration status of employee information before the update. Figure 14(B) shows the registration status of employee information after the update. The merger information is referenced, and in the employee information, for Mr. D and Mr. E, the municipal codes "23101X" and "23101X" are reflected (set) using the municipal codes "231011" and "2331029" as keys, respectively.
[0075] In this way, the municipal code of the employee is overwritten with the municipal code of the new municipality after the merger or consolidation. Also, at this point, the municipality code to which documents are submitted and the municipality code to which payments are made are updated to blank. This eliminates the need to manually correct employee information each time a municipality is merged or consolidated.
[0076] (5) Refer to the municipal master 106a for employee information and update the submission destination municipal code and payment destination municipal code in one go based on the municipal code.
[0077] Figure 15 shows an example of the display of the municipal master maintenance screen (similar to Figure 13(A)). On the municipal master maintenance screen in Figure 15, press (execute) the "Reflect in Employee Information" button to update employee information by referring to the municipal master 106a. The current pay year and month (2024 / 4) and municipal code are used as keys.
[0078] Figure 16(A) shows the registration status of data in the municipal master 106a. Figure 16(B) shows the registration status of employee information after the update. The municipal master 106a is referenced, and in the employee information, for Mr. D and Mr. E, the municipal codes "23101X" and "23101X" are used as keys, and the destination municipal codes "231002" and "231002" are reflected (set).
[0079] If the recipient municipality code is registered under the municipality code "23101X", the recipient municipality code will also be updated. It is possible to update the recipient municipality code and payment municipality code in bulk, rather than registering them individually for each employee, thus preventing errors such as maintenance omissions.
[0080] As explained above, according to this embodiment, employee information including the employee, pay date, the city / ward / town / village where the employee resides, the city / ward / town / village to which the payroll report is submitted if the city / ward / town / village where the employee resides is a government-designated city, and the city / ward / town / village to which the resident tax is paid if the city / ward / town / village where the employee resides is a government-designated city and is a special collection handling area, is registered in association with the city / ward / town / village master 106a, and the city / ward / town / village, government-designated city, and city / ward / town / village The system includes a master data maintenance unit 102a that updates the municipal master data 106a and the designated city master data 106b in response to operator operations when municipal mergers or consolidations occur, and then updates the employee information in bulk based on the updated municipal master data 106a and the designated city master data 106b. This reduces the workload and potential errors associated with updating employee tax payment information when municipal mergers or consolidations occur.
[0081] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving operational efficiency and promoting appropriate management decisions by companies, thereby contributing to SDGs Goals 8 and 9.
[0082] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.
[0083] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.
[0084] [5. Other Embodiments] In addition to the embodiments described above, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.
[0085] 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 by known methods.
[0086] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.
[0087] Furthermore, with respect to the business support device 100, each component shown in the diagram is a functional concept and does not necessarily need to be physically configured as shown.
[0088] For example, the processing functions of the business support device 100, particularly those performed by the control unit 102, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for the information processing device to execute the processing described in this embodiment, and is mechanically read by the business support device 100 as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) stores a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing tasks. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.
[0089] Furthermore, this computer program may be stored on an application program server connected to the business support device 100 via any network, and it is possible to download all or part of it as needed.
[0090] Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.
[0091] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.
[0092] The various databases stored in the memory unit 106 include 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 website provision.
[0093] Furthermore, the business support device 100 may be configured as a known personal computer or workstation or other information processing device, or as an information processing device to which any peripheral devices are connected. Alternatively, the business support device 100 may be implemented by installing software (including programs or data, etc.) that enables the processing described in this embodiment on the device.
[0094] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Explanation of Symbols]
[0095] 100 Business support equipment 102 Control Unit 102a Master Maintenance Department 102b Employee Information Registration Department 102c Screen display control unit 104 Communication Interface Section 106 Storage section 106a Municipal Master 106b Designated City Master 108 Input / Output Interface Section 112 Input device 114 Output device 200 servers 300 Networks
Claims
1. A business support device equipped with a control unit, The control unit, Employee information including the employee name, pay date, city / ward / town / village where the employee resides, the city / ward / town / village to which the pay report is submitted if the city / ward / town / village where the employee resides is a government-designated city, and the city / ward / town / village to which resident tax is paid if the city / ward / town / village where the employee resides is a government-designated city and is also a special collection area, The municipal master data, which is registered by associating the revision date, municipality, municipality to which the document is submitted, and municipality to which payment is made, A master database of designated cities that associates municipalities, designated cities, and the municipalities to which payments are received, It is configured to be accessible, When municipalities are merged or consolidated, the municipal master data and the designated city master data are updated according to the operator's actions. A business support device characterized by having a master maintenance means for updating employee information in bulk based on the above.
2. The aforementioned master maintenance means, when municipalities are merged or consolidated, (1) On the municipal master maintenance screen, the revision date and municipality of the municipal master will be updated according to the operator's actions. (2) If the municipality that has been merged or consolidated is a government-designated city, the government-designated city master screen will update the merged or consolidated municipality and its government-designated city, or the government-designated city and the municipality to which payment is made, in accordance with the operator's operation. (3) Based on the updated government-designated city master data, update the government-designated city as the submitting municipality, or the government-designated city as both the submitting municipality and the payment recipient municipality, for the municipalities in the updated municipal master data. (4) On the municipal master maintenance screen, launch the merger information screen for the details of the merged municipalities, enter the new and old municipalities on the merger information screen, and based on the input on the merger information screen, update the municipality for the target employee in the employee information, using the current pay year and month and municipality as keys. (5) The business support device according to claim 1, further characterized in that, based on the updated municipal master data, it updates the municipality to which the employee information is submitted, or the municipality to which it is submitted and the municipality to which it is paid, using the current pay year and municipality as the key.
3. The business support device according to claim 1 or 2, characterized in that the master maintenance means, in the employee information, for new employees, refers to the municipal master and updates the municipality to which the information is submitted and the municipality to which it is paid, using the current pay year and month and municipality as keys.
4. The business support device according to claim 1 or 2, characterized in that the aforementioned special collection handling area is Yokohama City.
5. A business support method performed by an information processing device equipped with a control unit, The control unit, Employee information including the employee name, pay date, city / ward / town / village where the employee resides, the city / ward / town / village to which the pay report is submitted if the city / ward / town / village where the employee resides is a government-designated city, and the city / ward / town / village to which resident tax is paid if the city / ward / town / village where the employee resides is a government-designated city and is also a special collection area, The municipal master data, which is registered by associating the revision date, municipality, municipality to which the document is submitted, and municipality to which payment is made, A master database of designated cities that associates municipalities, designated cities, and the municipalities to which payments are received, It is configured to be accessible, The control unit is executed as follows: When municipalities are merged or consolidated, the municipal master data and the designated city master data are updated according to the operator's actions. A business support method characterized by including a master maintenance process for updating employee information in bulk based on the above.
6. A business support program to be executed by an information processing device equipped with a control unit, The control unit, Employee information including the employee name, pay date, city / ward / town / village where the employee resides, the city / ward / town / village to which the pay report is submitted if the city / ward / town / village where the employee resides is a government-designated city, and the city / ward / town / village to which resident tax is paid if the city / ward / town / village where the employee resides is a government-designated city and is also a special collection area, The municipal master data, which is registered by associating the revision date, municipality, municipality to which the document is submitted, and municipality to which payment is made, A master database of designated cities that associates municipalities, designated cities, and the municipalities to which payments are received, It is configured to be accessible, The control unit, When municipalities are merged or consolidated, the municipal master data and the designated city master data are updated according to the operator's actions. A business support program for executing a master maintenance process that updates employee information in bulk, based on the above.