JP2005275917A - Pay report creating system and storage medium - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a pay report data creating system capable of performing the error processing of pay data supplied from each taxpayer of special tax collection, and storing the pay data in a movable magnetic storage medium by collectively converting the pay data into the data of a format specified by local authority. <P>SOLUTION: This pay report creating system comprises an error checking means for checking the error in the pay data of previous year and outputting the error information, a communicating means for editing the error information by every employer receiving the supply and transmitting the same, a storing means for storing the pay data free from error, and a submission data creating means for converting the pay data into a designated form and creating the pay submission data. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a system for preparing a salary payment report to be reported to each local government from each employer who is a special collection duty person.

  The employer who employs the employee collects the prefectural tax and the municipal inhabitant tax from the salary paid to the employee (special collection), and the collected tax amount is the municipality where the employee resides. It is required by local tax law to make payments directly.

  Therefore, the employer, who is the duty of special collection, sends a salary payment report for the previous year to each municipal office of the tax-paying area, and each municipal office determines the annual tax amount based on the sent salary payment report. The monthly amount is calculated, a special collection tax notice is prepared, and the special collection tax notice is sent to each employer who received the salary payment report.

  Although it has been accepted in the past to use salary payment reports to send salary compensation data to the municipal office of the tax-paying area using magnetic tape (MT), there are limited establishments that have MT devices. For this reason, most offices used a method in which salary payment reports were printed on paper, sorted by tax payment area, and then sent to each municipal office. On the other hand, each municipality manually inputs a salary payment report printed on paper into a computer, calculates a predetermined tax amount, and prints it on a special collection tax amount notification form in each municipality-designated form. Then, the special collection tax amount notice printed out and the salary payment report sent from each office are visually matched to check whether there is an input error or the like.

  For this reason, each municipality requires a great deal of labor and time for manual input and visual matching, and there is much room for mistakes due to manual intervention. In addition, although the items to be included in the salary payment report are determined, the format differs depending on the establishment, so it is necessary to correlate items and adjust the number of digits at the time of input. There is a risk of mistakes.

  Therefore, if the approval of each municipality may have been received since 2001, the salary compensation data of the “National Tax Office Unified Style” can be submitted on a flexible disk. Reduction of labor and time required is expected.

In addition, a processing center is set up between multiple special collection obligations and multiple municipalities, and tax payment related work between them is communicated through the processing center. After the processing center receives and reorganizes the individual tax amount data, there is a large-scale mechanism to send it to the related special collection obligations and municipalities by communication line, magnetic tape, or flexible disk (see Patent Document 1) .
Japanese Patent No. 2769742

  However, since resident tax is carried out in relation to tax payments in units of municipalities, it is considered difficult to cover all municipalities even if a disclosed processing center is established.

  In addition, the data stored in the flexible disk submitted by each special collection person does not necessarily match the specified format data specified by the municipality. Work to convert is necessary.

  In addition, some data stored in the flexible disk is incapable of being subjected to batch conversion processing due to inconsistencies in the number of digits and the data format. For this reason, it is necessary to perform correction instructions for the found errors and confirmation of the corrected portions each time.

  In view of the above circumstances, the present invention performs error processing of salary compensation data supplied from each special collection duty person, and converts salary compensation data into data in a format specified by the municipality, and is a movable magnetic storage. It is an object of the present invention to provide a salary report data creation system that can be stored in a medium and a storage medium that stores a program used in the system.

The salary report generation system of the present invention that achieves the above object performs an error check of salary compensation data related to the salary for the previous year of each employee supplied by a predetermined employer, and outputs error information Means,
Communication means for editing the error information output from the error check means for each employer who has received supply of the salary compensation data, and transmitting the information to the corresponding employer information device;
Storage means for storing the salary compensation data determined to have no error by the error check by the error check means;
The salary reward data stored in the storage means is converted into a format designated by the predetermined local government, and submitted data creation means for creating salary reward submission data is provided.

In addition, the storage medium of the present invention that achieves the above object is a salary remuneration data relating to the salary for the previous year of each employee who is supplied from a predetermined employer to a predetermined municipality as a tax obligation. An error check procedure that lets you perform error checks on and extract errors,
A procedure for editing the error extracted by the error check procedure for each employer who has received the salary compensation data and transmitting it to the information device of the corresponding employer.
In the error check procedure, a procedure for storing the salary reward data from which no error is extracted in a storage unit;
A program for converting the salary reward data stored in the storage unit into a format designated by the predetermined local government and creating salary reward submission data to be submitted to the predetermined local government is stored. It is characterized by that.

  As described above, since the result of the error check performed by the error check means is transmitted as error information to the information equipment at the office using the communication means, the office side reliably performs error correction based on the error information. , Error-free salary compensation data can be supplied. Since the salary compensation data without error is converted into a format designated by the local government, accurate salary compensation submission data can be submitted to the local government.

  According to the salary report creation system and storage medium of the present invention, error information is notified by communication means, and the establishment side reliably performs error correction based on the error information and supplies salary compensation data without error. It is possible to submit accurate salary compensation submission data to the local government.

  In the following, an embodiment of a salary report creating system of the present invention and a storage medium storing a program used in the system will be described.

  FIG. 1 is a schematic configuration diagram showing an embodiment of a salary report creating system of the present invention.

  In FIG. 1, the salary report creation system of the present embodiment is a consignment contract with a related municipality 200 or an employer who employs an employee and corresponds to a special collection obligation (hereinafter referred to as “business establishment”). Based on the consignment contract of the company, the salary compensation data 10 paid to each employee in the previous year is supplied from the related establishments, the error of the salary compensation data 10 received is checked, and each employee is obligated to pay tax It is a system for converting salary compensation submission data 60 to be submitted to the local municipality, storing the salary compensation submission data 60 after the format conversion in a magnetic storage medium, and printing salary compensation data on a predetermined form. .

  This system includes a host computer 1 installed in a data center, and the host computer 1 is connected to a business office 100 via a network 110.

  The host computer (hereinafter referred to as “server”) 1 includes a communication unit 30 that transmits and receives data via the network 110 with a computer (hereinafter referred to as “PC”) 120 of the office, and the network 110. Error checking means 20 for checking the error of the salary compensation data 10 sent in this manner, and a sorted pay data storage section for storing the salary compensation data 10 determined to have no error by the error checking means 20 (storage of the present invention) 25) and the submission data creation for converting the salary compensation data stored in the classified pay data storage unit 25 into the format specified by the municipality and creating the salary compensation submission data to be submitted to the municipality Flexible date storing salary reward submission data created by means 40 and submission data creation means 40 The pay disk data stored in the flexible disk drive 50 and the sorted pay data storage unit 25 are converted into a predetermined format, and the pay data in the form of a form to be submitted to the municipality is created and connected. And a confirmation form printing unit 45 to be printed by the printer.

  In addition, the error check means 20 includes an error database 21 in which a check condition for performing error processing on each data item of the salary compensation data 10 and a message for notifying the office of each error, an error check result, When an error is detected, an error log 22 for outputting error information including a message for notifying the office of the error is received. When unsorted salary compensation data 10 is received, the salary compensation data 10 is related. There is a municipality sorting means 23 for sorting by municipality.

  In addition, the classified pay data storage unit 25 is an identification number table (correspondence table of the present invention) in which an identification number such as a resident number set for each resident in a related municipality is recorded in correspondence with the name and address of each resident. 26), when storing salary compensation data, the identification number corresponding to the employee's name and address recorded with the salary compensation data with reference to the identification number table is stored. It can be read and given to each salary reward data.

  When the identification number is attached in this way, it is convenient when reading and converting the salary reward data stored in the sorted pay data storage unit 25, or when downloading to the attached flexible disk, It is also convenient for tax-related paperwork after it has been submitted to the relevant municipalities.

  Further, the submission data creation means 40 has a format conversion database 41 in which the contents of the conversion processing to be performed on each data item of salary reward data are recorded, and the confirmation form printing means 45 has each data item of salary reward data. A form format database 46 in which a print format is recorded.

  Here, the salary report data creation system of the present embodiment is configured to receive the supply of the salary compensation data 10 from the office 100 via the office 100 and the network 110 by the communication means 30 online. It is not necessary to be online. For example, it can be configured to receive supply of a flexible disk storing salary compensation data by mail or courier, or both can be used together.

  Further, the salary compensation data 10 supplied from the business operator 100 may be classified only for employees who have a predetermined municipality entrusted by the data center as tax obligations. Therefore, it may be in an unsorted state.

  FIG. 2 is a diagram showing an example of a protocol between the communication means and the office PC in the salary report creating system of the present embodiment.

  In FIG. 2, the establishment-side PC 120 accesses the data center-side server 1 (communication means 30) via the network 110 such as the Internet (S1). When the server 1 (communication means 30) on the data center side receives an access request from the office-side PC 120 (S21), it prompts the office-side PC 120 to input a password, membership number, etc. If so, the service reception screen data of this system is transmitted to the office PC 120 (S22).

  Since the service reception screen is displayed on the office PC 120 (S2), based on the information displayed on the screen, the name of the office, the name of the target city, etc. are input, or the service to be provided is selected. (S3).

  For example, to receive an error check service for salary compensation data, an error check service is selected from a pull-down menu.

  The office PC 120 displays a “salary compensation data error check service” menu as shown in FIG. Therefore, in accordance with the displayed message, the file name in which the salary compensation data is stored is input to the dialog box 121, and the “start” button 122 is clicked to transfer the file to the server 1 on the data center side (S3). .

  Here, in this embodiment, the salary compensation data stored in the database of the office computer is directly transferred via the network. However, when the error check service is selected from the pull-down menu. Alternatively, for example, a flexible disk may be selected, and a flexible disk storing salary compensation data may be inserted into the drive each time and transferred to the server 1 on the data center side.

  The server 1 on the data center side receives the salary compensation data (S23), and temporarily stores the received salary compensation data in the buffer memory. Then, the data error check means 20 sequentially reads the salary compensation data stored from the buffer memory and performs error check (S24).

  At this time, the data error check means 20 can store the received salary reward data in the sorted pay data storage unit 25 when the error check service is not selected in the office PC 120.

  The error check is performed with reference to the error database 21. When an error is found as a result of the error check, error information including a message for notifying the office of the error and the error is displayed in the error log 22. Sent.

  The communication means 30 receives the error information from the error log 22, edits the received error information, and transfers the edited error information data to the office PC 120 (S25).

  The office PC 120 receives the transferred error information (S5) and displays it on the PC screen (S6).

  On the PC screen, “salary reward data check result” as shown in FIG. 3B is displayed.

  On the business office side, the displayed “salary reward data check result” is confirmed by printing or the like, and by clicking the “OK” button 123, the line connection with the data center server 1 is released (S7). The data center side releases the line connection of the server 1 in response to the release of the line connection on the office side (S26).

  On the office side, the salary compensation data can be corrected based on the confirmed “salary compensation data check result”, and the corrected salary compensation data can be attached to the error check service again. On the data center side, when there is no error in the salary compensation data sent from the office by the error check again, the salary compensation data is stored in the sorted pay data storage unit 25. Thereafter, the submission data creation means 40 converts the format of the salary compensation data stored in the sorted pay data storage unit 25 to create salary compensation submission data, and stores the salary compensation submission data in the flexible disk. The confirmation form printing means 45 converts the salary compensation data stored in the sorted pay data storage unit 25 into a predetermined format, creates a form-form salary payment report to be submitted to the municipality, and prints it on the printer. Let In the municipality, it is possible to confirm whether the contents of the data after the batch conversion match the salary payment report created based on the data before the conversion.

  Here, the error check means 20 in the present embodiment stores the salary reward data in the sorted pay data storage unit 25 only when there is no error in the salary reward data sent from the office. Although it is configured, it is not necessary to limit to this, and whether or not there is an error is determined individually, and salary reward data without error is stored in the sorted pay data storage unit 25, and the salary reward data in which an error has occurred For, a difference may be input later.

  FIG. 4 is a diagram illustrating an example of a table stored in the error database.

  In the table, data is recorded in a machine-readable format when the error check means reads and performs error check processing, but here, it is described in an easily understandable expression format for convenience of explanation.

  In the table shown in FIG. 4, “data item number” and “data item name” of salary compensation data, “inspection condition” when performing error check, and when the inspection condition is violated on the office side PC are displayed. "Error message" is recorded.

  For example, as for items relating to the entire record of the table, “data item number” is “0”, “data item name” is “whole record”, “inspection condition” is “number of items 84”, “error message” is “item” Number ≠ 84 ”. “Data item number 1” is “data item name” is “type of payment record”, “inspection condition” is whether “item value is 315”, and “error message” is “Item value ≠ 315”. Furthermore, “data item number 2” has “data item name” “reference number 1” and four “inspection conditions”. One is “consisting of blank characters and numbers”, and “error message” is “item value includes other than numbers and spaces”. The second is whether or not “item length ≦ 10”, and “error message” is “item value> 10”. Three is whether or not “item value ≦ 999999999999”, and “error message” is “item value> 999999999999”. Four is whether or not “item value ≧ 0”, and “error message” is “item value <0”.

  FIG. 5 is a diagram illustrating an example of a table stored in the format conversion database.

  In the table shown in FIG. 5, “local government”, “data item number”, “data item name”, which are tax obligations for converting salary compensation data format, and “conversion processing” for converting salary compensation data. Is recorded.

  For example, when “locality” is “Fujitsu City”, “data item number” “0” is “data item name” is “whole record”, and one “conversion process” is “item position = 0” “2” is “item length = 1500”, indicating that format conversion is performed with the converted record length being 1500 bytes. “Data item number” “1” is “data item name” is “kind of payment record, etc.”, “conversion processing” is one “item position = 24”, two is “item” Length = 10 ”and three are“ right justified ”, and format conversion is performed in which the item value is set to the right justified with a 10-byte length at the 24th byte position from the beginning (0th byte) of the converted record. It is shown that.

  FIG. 6 is a diagram showing an example of a table stored in the form format database.

  The table shown in FIG. 6 includes “local government”, “data item number”, “data item name”, and “print information” for printing salary remuneration data, which are tax obligations for printing salary compensation data. It is recorded.

  For example, when “locality” is “Fujitsu City”, “data item number” “0”, “data item name” is “whole record”, and “printing information” is “form overlay = OVL-FJ2”. And the overlay is specified when printing the form. “Data item number” “1” is “data item name” is “type of payment record”, “print information” is “print position = 2 rows and 2 columns”, and “payment” This indicates that the item value of “type of record” is printed from the second row and second column on the form.

It is a schematic block diagram which shows embodiment of the salary report preparation system of this invention. It is a figure which shows an example of the protocol between the communication means and PC of an office in the salary report preparation system of this embodiment. It is a figure which shows an example of the menu displayed on the office side PC. It is a figure which shows an example of the table stored in the error database. It is a figure which shows an example of the table stored in the format conversion database. It is a figure which shows an example of the table stored in the form format database.

Explanation of symbols

1 Host computer (server)
10 Salary Reward Data 20 Error Checking Means 21 Error Database 22 Error Log 23 Municipality Sorting Means 25 Sorted Salary Data Storage Unit 26 Correspondence Table 30 Communication Means 40 Submitted Data Creation Means 41 Format Conversion Database 45 Confirmation Form Printing Means 46 Form Form Database 50 Flexible disk drive 60 Salary fee submission data 100 Office 110 Network 120 Office PC
121 Dialog box 122 “Start” button 123 “OK” button 200 Related municipalities

Claims (8)

An error check means for performing error check on salary compensation data related to the salary for the previous year of each employee supplied by a predetermined employer and outputting error information;
Communication means for editing the error information output from the error check means for each employer who has received supply of the salary compensation data and transmitting the information to the corresponding employer information device,
Storage means for storing the salary compensation data determined to have no error by the error check by the error check means;
A salary report creation system comprising: submission data creation means for converting the salary compensation data stored in the storage means into a format designated by the predetermined local government and creating salary compensation submission data .   The error check means extracts the salary compensation data of each employee having a predetermined local government as a tax obligation from the salary compensation data, and performs the error check on the extracted salary compensation data. The salary report creating system according to claim 1.   3. The salary report generating system according to claim 1, wherein the submission data generating means transfers the generated salary reward data to a removable magnetic storage medium in response to an operation by a predetermined operator. .   The communication means displays predetermined information on a display screen of the information device when receiving access from the information device of the predetermined employer via a network, and receives the salary compensation data from the information device. 2. The salary report generating system according to claim 1, wherein the received salary reward data is sent to the error check means.   2. The salary according to claim 1, wherein the error checking means stores the salary reward data in the storage means when there is no error in the salary reward data supplied from the predetermined employer. Reporting system.   The storage means includes a correspondence table in which an identification number set for each inhabitant by the predetermined local government is recorded in association with an attribute including the name of each inhabitant, and the correspondence table is stored in each salary reward data to be stored. 2. The salary report generating system according to claim 1, wherein a corresponding identification number recorded in the field is assigned. An error check procedure for causing a computer to perform error checking on salary compensation data relating to the salary for the previous year of each employee who is supplied by a predetermined employer and whose tax obligation is the specified municipality; ,
A procedure for editing the error extracted by the error check procedure for each employer who has been supplied with the salary compensation data and sending it to the information device of the corresponding employer.
In the error check procedure, a procedure for storing the salary reward data from which no error is extracted in a storage unit;
A program for converting the salary reward data stored in the storage unit into a format designated by the predetermined local government and creating salary reward submission data to be submitted to the predetermined local government is stored. A storage medium characterized by that. In the error check procedure, the salary compensation data of each employee having a predetermined local government as a tax obligation is extracted from the salary compensation data, and the error check is performed on the extracted salary compensation data. The storage medium according to claim 7.

Images