Personnel outsourcing social security accumulation fund declaration system, method and equipment

Abstract

The invention discloses a personnel outsourcing social security accumulation fund declaration system and method and electronic equipment. The system comprises a declaration form adding module used for setting a declaration area, a declaration category and a starting date of a declaration form; the declaration form setting module is used for setting a form name, a declaration type, a declaration column starting line and a filling starting line of a declaration form, importing a declaration form expected to be used, and setting a corresponding relationship between the declaration column and a storage field on the basis of a historical corresponding relationship for the declaration column which is the same as the historical declaration column; the declaration column setting module is used for setting corresponding relations between other declaration columns and the storage fields and formats of at least part of the declaration columns; the declaration form filling module is used for filling a declaration form according to the set corresponding relation and format; the declaration module is used for sending the filled declaration form to the corresponding online platform; and the receiving module is used for receiving the declaration result. According to the invention, multiple application types of social security accumulation fund declaration services of multiple regions are supported.

Description

Technical Field

[0001] The present application relates to the field of Internet platform technology, and in particular to a personnel outsourcing social security and provident fund reporting system, method and electronic equipment. Background Art

[0002] Human Resource Outsourcing (HRO) refers to a business model in which an enterprise entrusts part or all of its human resource management functions to a human resource outsourcing agency (i.e. a professional service agency). Through human resource outsourcing, an enterprise can reduce the risks and costs of human resource management, while being able to focus on core business and improve overall operational efficiency.

[0003] The declaration of social security and provident fund is a necessary process for the normal operation of every enterprise, and it is related to the practical interests of every employee. Therefore, for human resources outsourcing agencies, they may need to provide social security and provident fund declaration services for more enterprises, and these enterprises may be distributed in different regions (such as cities), that is, involving many cities and a large geographical span.

[0004] For social security and provident fund declaration business, there may be differences in the declaration columns and / or formats of declaration forms in different regions, and the declaration forms may be updated every once in a while. Therefore, for the newly added declaration forms in each region, operators are usually required to configure each declaration column in the declaration form one by one, configure the fields in the database corresponding to each declaration column one by one, and configure the format of the content filled in each declaration column one by one. This configuration method is not flexible enough and the operation is cumbersome, and it is difficult to complete the configuration quickly. Secondly, after filling out the declaration form, it is usually necessary to submit the declaration form offline to the designated directory for declaration, which is time-consuming and laborious. In addition, after the operator obtains the declaration results offline, it is usually necessary to manually organize the results and then write the declaration results back to the designated operating system, which also consumes a lot of manpower. Summary of the invention

[0005] In view of this, the embodiments of the present application provide a personnel outsourcing social security and provident fund reporting system, method and electronic device for solving at least one of the above technical problems.

[0006] In a first aspect, the embodiment of the present application provides a personnel outsourcing social security and provident fund reporting system, including:

[0007] A declaration form addition module is used to display a declaration form addition page, and in response to the user's input on the declaration form addition page, set the declaration area, declaration category and activation date of the newly added declaration form, and the declaration category includes social security or provident fund;

[0008] The declaration form setting module is used to display the declaration form setting page, and in response to the user's input on the declaration form setting page, set the form name, declaration type, declaration column starting line and fill starting line of the newly added declaration form, import the declaration form to be used, read each declaration column in the header located at the declaration column starting line of the declaration form, and query the historical correspondence between the historical declaration columns and the storage fields in the database; wherein, for any i-th declaration column in the declaration form that is the same as the historical declaration column, the correspondence between the i-th declaration column and the storage field is set based on the historical correspondence, and i is a positive integer;

[0009] A declaration column setting module, used to display a declaration column setting page, and in response to the user's input on the declaration column setting page, set the corresponding relationship between any j-th declaration column in the declaration form that is different from the historical declaration column and the storage field, and set the format of the content filled in at least part of the declaration column, where j is a positive integer;

[0010] The declaration form filling module is used to fill in the data of multiple storage fields in the database into the declaration form according to the corresponding relationship and format between each declaration column and the storage field, starting from the filling start line;

[0011] The declaration module is connected to the online social security service platform and the online provident fund service platform, and is used to send the completed declaration form to the online social security service platform or the online provident fund service platform based on the declaration category of the declaration form;

[0012] The receiving module is connected to the online social security service platform and the online provident fund service platform, and is used to receive the declaration results corresponding to the declaration form fed back by the online social security service platform or the online provident fund service platform.

[0013] According to some embodiments of the present application, optionally, the declaration form setting module is specifically used to query whether there is a first historical declaration column that is the same as the i-th declaration column under the same settings as the declaration area, declaration category and declaration type of the declaration form in the database for any i-th declaration column; if it exists, and the first historical correspondence between the first historical declaration column and the storage field is unique, then the correspondence between the i-th declaration column and the storage field is set based on the first historical correspondence;

[0014] If it does not exist or the first historical correspondence is not unique, then continue to query whether there is a second historical declaration column that is the same as the i-th declaration column under the same settings as the declaration area and declaration category of the declaration form in the database; if it exists, and the second historical correspondence between the second historical declaration column and the storage field is unique, then the correspondence between the i-th declaration column and the storage field is set based on the second historical correspondence;

[0015] If it does not exist or the second historical correspondence is not unique, continue to query the database whether there is a third historical declaration column that is the same as the i-th declaration column under the same settings as the declaration area of ​​the declaration form; if it exists, and the third historical correspondence between the third historical declaration column and the storage field is unique, then the correspondence between the i-th declaration column and the storage field is set based on the third historical correspondence.

[0016] According to some embodiments of the present application, optionally, the declaration column setting page displays declaration columns in the declaration form that are different from historical declaration columns.

[0017] According to some embodiments of the present application, optionally, the declaration column setting page displays a first option corresponding one-to-one to the information in the system and a second option for filling in fixed information; the declaration column setting module is specifically used to, when the user clicks the first option, respond to the user's storage field selection input and format setting input, select the storage field corresponding to the j-th declaration column to establish a correspondence between the j-th declaration column and the storage field, and set the date format and / or numerical format of the filled-in content of the j-th declaration column; the declaration column setting module is specifically used to, when the user clicks the second option, respond to the user's input, set the filled-in content of the j-th declaration column to leave it blank, automatically fill in the serial number, or fill in the content entered by the user.

[0018] According to some embodiments of the present application, optionally, the declaration column setting page also displays a third option that matches the system options with the declaration form options; the declaration column setting module is specifically used to select the storage field corresponding to the j-th declaration column in response to the user's storage field selection input and conversion relationship input when the user clicks on the third option, so as to establish a correspondence between the j-th declaration column and the storage field, and set a conversion relationship for the data of the storage field, wherein the conversion relationship is used to convert the data in the storage field corresponding to the j-th declaration column into translation data filled in the j-th declaration column when filling in the j-th declaration column.

[0019] According to some embodiments of the present application, optionally, the declaration form setting module is also used to set the format of the filled-in content of the i-th declaration column for any i-th declaration column in the declaration form that is the same as the historical declaration column, based on the format of the filled-in content of the historical declaration column that is the same as the i-th declaration column; the declaration column setting module is also used to modify the correspondence between the i-th declaration column in the declaration form that is the same as the historical declaration column and the storage field in response to the user's input on the declaration column setting page, and / or modify the format of the filled-in content of the i-th declaration column.

[0020] According to some embodiments of the present application, optionally, the human resources outsourcing social security and provident fund declaration system also includes: a comparison module, which is used to compare the filled-in content of each declaration column of each employee in the declaration form with the declaration result item by item, and output a comparison report; wherein the comparison report displays the company name corresponding to the declaration form, the name of the target employee, the calculated amount of the social security or provident fund declared by the target employee, the actual payment amount of the social security or provident fund declared by the target employee, and the declaration columns where there are differences in the comparison, and the target employees at least include employees where there are differences in the filled-in content of the declaration column compared with the declaration results.

[0021] According to some embodiments of the present application, optionally, the personnel outsourcing social security and provident fund declaration system also includes: a status display module, which is used to update and display the declaration status of each employee's social security or provident fund in the declaration form according to the declaration results, and the declaration status includes declaration in progress, successful declaration or failed declaration.

[0022] In a second aspect, an embodiment of the present application provides a human resources outsourcing social security and provident fund declaration method, which is applied to the human resources outsourcing social security and provident fund declaration system provided in the first aspect, including: in response to the user's input on the new page of the declaration form, setting the declaration area, declaration category and activation date of the newly added declaration form, the declaration category including social security or provident fund; in response to the user's input on the declaration form setting page, setting the form name, declaration type, declaration column starting row and fill starting row of the newly added declaration form, and importing the desired declaration form, reading each declaration column in the header of the declaration column starting row of the declaration form, and querying the historical correspondence between the historical declaration columns and the storage fields in the database; wherein, for any i-th declaration column in the declaration form that is the same as the historical declaration column Declaration column, set the correspondence between the i-th declaration column and the storage field based on the historical correspondence, i is a positive integer; in response to the user's input on the declaration column setting page, set the correspondence between any j-th declaration column in the declaration form that is different from the historical declaration column and the storage field, set the format of the fill-in content of at least part of the declaration column, j is a positive integer; starting from the filling start row, fill the data of multiple storage fields in the database into the declaration form according to the correspondence and format between each declaration column and the storage field; based on the declaration category of the declaration form, send the filled-in declaration form to the online social security service platform or the online provident fund service platform; receive the declaration result corresponding to the declaration form fed back by the online social security service platform or the online provident fund service platform.

[0023] In a third aspect, an embodiment of the present application provides an electronic device, and the electronic device is deployed with the human resources outsourcing social security and provident fund declaration system provided in the first aspect.

[0024] The personnel outsourcing social security and provident fund declaration system, method and electronic device provided in the embodiments of the present application, on the one hand, the personnel outsourcing social security and provident fund declaration system supports the configuration and declaration of differentiated declaration forms for social security and provident funds in various regions, and can meet the needs of personnel outsourcing agencies to make social security and provident fund declarations for enterprises or employees in multiple different regions; on the other hand, the personnel outsourcing social security and provident fund declaration system supports the import of declaration forms for social security or provident funds in various regions, and by querying the historical correspondence between the historical declaration columns and the storage fields in the database, for the declaration forms that are the same as the historical declaration columns, Column, setting the correspondence between the declaration column and the storage field based on the historical correspondence can reduce the workload of operators to configure the correspondence between the declaration column and the storage field one by one, reduce manual configuration errors, and improve configuration efficiency and accuracy; on the other hand, the personnel outsourcing social security and provident fund declaration system can be connected with the official or third-party online social security service platform and online provident fund service platform, support online declaration of declaration forms and online retrieval of declaration results, which can reduce the workload of manual compilation of reports, delivery of declaration forms and retrieval of declaration results, and further improve the efficiency and accuracy of social security and provident fund declarations. BRIEF DESCRIPTION OF THE DRAWINGS

[0025] In order to more clearly illustrate the technical solution of the embodiments of the present application, the following briefly introduces the drawings in the embodiments of the present application.

[0026] Figure 1 A structural diagram of a personnel outsourcing social security and provident fund reporting system provided in an embodiment of the present application.

[0027] Figure 2 The new page of the declaration form is schematically shown.

[0028] Figure 3 The declaration form settings page is schematically shown.

[0029] Figure 4 The declaration column setting page is schematically shown.

[0030] Figure 5 The schematic diagram shows the declaration column setting page when the first option is clicked.

[0031] Figure 6 The schematic diagram shows the declaration column setting page when the second option is clicked.

[0032] Figure 7 The schematic diagram shows the declaration column setting page when the third option is clicked.

[0033] Figure 8 A flowchart of a method for declaring social security and provident fund for personnel outsourcing provided in an embodiment of the present application. DETAILED DESCRIPTION

[0034] The features and exemplary embodiments of various aspects of the present application will be described in detail below. In order to make the purpose, technical solutions and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings and specific embodiments. It should be understood that the specific embodiments described herein are only intended to explain the present application, rather than to limit the present application. For those skilled in the art, the present application can be implemented without the need for some of these specific details. The following description of the embodiments is only to provide a better understanding of the present application by illustrating the examples of the present application.

[0035] It should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the statement "include..." do not exclude the presence of other identical elements in the process, method, article or device including the elements.

[0036] It should be understood that the term "and / or" used in this article is only a description of the association relationship of associated objects, indicating that there can be three relationships. For example, A and / or B can represent: A exists alone, A and B exist at the same time, and B exists alone. In addition, the character " / " in this article generally indicates that the associated objects before and after are in an "or" relationship.

[0037] It is obvious to those skilled in the art that various modifications and changes can be made in the present application without departing from the spirit or scope of the present application. Therefore, the present application is intended to cover modifications and changes of the present application that fall within the scope of the corresponding claims (technical solutions for protection) and their equivalents. It should be noted that the implementation methods provided in the embodiments of the present application can be combined with each other without contradiction.

[0038] Before describing the technical solutions provided by the embodiments of the present application, in order to facilitate the understanding of the embodiments of the present application, the present application first specifically describes the problems existing in the related art:

[0039] Human Resource Outsourcing (HRO) refers to a business model in which an enterprise entrusts part or all of its human resource management functions to a human resource outsourcing agency (i.e. a professional service agency). Through human resource outsourcing, an enterprise can reduce the risks and costs of human resource management, while being able to focus on core business and improve overall operational efficiency.

[0040] The declaration of social security and provident fund is a necessary process for the normal operation of every enterprise, and it is related to the practical interests of every employee. Therefore, for human resources outsourcing agencies, they may need to provide social security and provident fund declaration services for more enterprises, and these enterprises may be distributed in different regions (such as cities), that is, involving many cities and a large geographical span.

[0041] For social security and provident fund declaration business, there may be differences in the declaration columns and / or formats of declaration forms in different regions, and the declaration forms may be updated every once in a while. Therefore, for the newly added declaration forms in each region, operators are usually required to configure each declaration column in the declaration form one by one, configure the fields in the database corresponding to each declaration column one by one, and configure the format of the content filled in each declaration column one by one. This configuration method is not flexible enough and the operation is cumbersome, and it is difficult to complete the configuration quickly. Secondly, after filling out the declaration form, it is usually necessary to submit the declaration form offline to the designated directory for declaration, which is time-consuming and laborious. In addition, after the operator obtains the declaration results offline, it is usually necessary to manually organize the results and then write the declaration results back to the designated operating system, which also consumes a lot of manpower.

[0042] In view of the above research findings of the inventor, the embodiments of the present application provide a personnel outsourcing social security and provident fund declaration system, method and electronic equipment, which can solve at least one of the above technical problems existing in the related technology.

[0043] The following first introduces the human resources outsourcing social security and provident fund reporting system provided in the embodiment of the present application.

[0044] The personnel outsourcing social security and provident fund declaration system provided in the embodiment of the present application is a comprehensive information management system designed to help enterprises and organizations handle personnel affairs related to employees, especially the declaration and payment of social insurance and housing provident funds. In terms of social security services, the system can record and manage employees' social security information, including pension insurance, medical insurance, unemployment insurance, work-related injury insurance, and maternity insurance. The system can automatically calculate the payment amount of each social insurance and generate the reports required for declaration. In terms of housing provident fund services, the system can handle the declaration and payment of housing provident funds, record changes in employees' provident fund accounts, calculate the payment ratios of individuals and units, and generate monthly or annual reports.

[0045] Figure 1A structural diagram of the personnel outsourcing social security and provident fund reporting system provided in the embodiment of the present application. Figure 1 As shown, the personnel outsourcing social security and provident fund declaration system 10 provided in the embodiment of the present application may include a declaration form adding module 101, a declaration form setting module 102, a declaration column setting module 103, a declaration form filling module 104, a declaration module 105 and a receiving module 106.

[0046] Figure 2 The following diagram shows the newly added page of the declaration form. Figure 1 and Figure 2 As shown, the declaration form addition module 101 can be used to display a declaration form addition page. In response to the user's input on the declaration form addition page, the declaration area, declaration category and activation date of the newly added declaration form can be set. Among them, the declaration category can include social security or provident fund. Considering that the social security or provident fund declaration business is prone to change with the change of policy, the activation date of the declaration form can be set, that is, the specified effective date.

[0047] In some embodiments, the social security or housing fund declaration form can be submitted directly to the government, or indirectly through a supplier (such as a bank). Therefore, the newly added page of the declaration form can also be provided with a file recipient option, and in response to the user's input on the newly added page of the declaration form, the file recipient can be selected as the government or the supplier.

[0048] In some embodiments, the newly added declaration form page may also be provided with a declaration form file name input box, and the declaration form file name may be set in response to the content input by the user in the declaration form file name input box.

[0049] Figure 3 The following diagram shows the declaration form settings page. Figure 1 and Figure 3 As shown, the declaration form setting module 102 can be used to display the declaration form setting page, and in response to the user's input on the declaration form setting page, set the form name, declaration type, declaration column starting line and fill starting line of the newly added declaration form. Among them, the declaration type can include start, exit, supplementary payment or change. The declaration category in the declaration form setting page can be set by default to the declaration category set in the declaration form new page. For example, in Figure 2 The declaration category set in the new page of the declaration form shown is social security. Figure 3 The declaration category in the declaration form setting page shown can be set to social security by default.

[0050] Taking into account that each region has its own specific declaration columns and / or format requirements for declaration forms of different declaration types, if the workload is large and the settings are prone to omissions or errors if they are configured one by one, the personnel outsourcing social security and provident fund declaration system 10 provided in the embodiment of the present application supports uploading declaration forms of different declaration types in various regions to parse and set each declaration column in the declaration form, thereby improving configuration efficiency and accuracy.

[0051] The declaration form setting module 102 can be used for the user to import the declaration form that he or she wishes to use, and read the various declaration columns in the header of the declaration column starting line of the declaration form. Specifically, the header of the declaration form can be located at the declaration column starting line of the declaration form. By setting the declaration column starting line of the declaration form, the header of the declaration column starting line of the declaration form can be read. The header of the declaration form can include multiple declaration columns (i.e., fill-in items). Taking the social security declaration form as an example, for example, the declaration form can include multiple declaration columns such as the name of the enterprise, the unified social credit code of the enterprise, the name of the employee, the gender of the employee, the ID number of the employee, the type of insurance, the base of various social security contributions and / or the amount of payment. In some embodiments, the multiple declaration columns in the declaration form can be located in different data columns, that is, the multiple declaration columns are arranged in columns, so as to meet the requirements of the social security or provident fund department. In some embodiments, if the declaration column starting line of the imported declaration form does not have a header, an error processing can be performed.

[0052] The declaration form setting module 102 can also be used to query the historical correspondence between the historical declaration columns and the storage fields in the database. For any i-th declaration column in the declaration form that is the same as the historical declaration column, the correspondence between the i-th declaration column and the storage field is set based on the historical correspondence, where i is a positive integer.

[0053] Specifically, the database may store historical correspondences between multiple historical declaration columns and multiple storage fields. The historical declaration columns are declaration columns that have been configured before in the personnel outsourcing social security and provident fund declaration system and the database, such as declaration columns in the previously configured historical declaration form. The storage fields are fields stored in the database, such as enterprise name, enterprise unified social credit code, employee name, employee gender, employee ID number, insurance type, various social security payment bases and / or payment amounts, etc. For two versions of declaration forms in the same region, the same declaration category and the same declaration type, even if there are differences between the new version of the declaration form and the old version of the declaration form, most of the declaration columns in the two versions of the declaration form may be consistent. Therefore, for any i-th declaration column in the declaration form that is the same as the historical declaration column, the correspondence between the i-th declaration column and the storage field can be set based on the historical correspondence between the historical declaration column and the storage field that is the same as the i-th declaration column, so as to realize the automatic configuration of the correspondence between the i-th declaration column and the storage field, thereby improving the configuration efficiency and accuracy.

[0054] The declaration column setting module 103 can be used to display the declaration column setting page, and in response to the user's input on the declaration column setting page, set the correspondence between any j-th declaration column in the declaration form that is different from the historical declaration column and the storage field, and set the format of the filling content of at least part of the declaration column, where j is a positive integer.

[0055] Specifically, for any j-th declaration column in the declaration form that is different from the historical declaration column, the corresponding relationship between the j-th declaration column and the storage field can be set on the declaration column setting page in response to the user's input on the declaration column setting page. In addition, on the declaration column setting page, the format of the content filled in some or all declaration columns in the declaration form can also be set in response to the user's input on the declaration column setting page. For example, in some examples, the date format and / or numerical format of the content filled in the declaration column can be set. For example, the date format can be October 10, 2024, October 2024, 2024.10.10, 2024-10-10 or 2024 / 10 / 10, etc. The numerical format can include the number of decimal places to be retained, whether to display the percentage sign, whether the mantissa of the value is retained to the corner, yuan or ten yuan, etc.

[0056] The declaration form filling module 104 can be used to fill in the data of multiple storage fields in the database into the declaration form according to the corresponding relationship and format between each declaration column and the storage field, starting from filling the start row.

[0057] Specifically, after setting the correspondence between each declaration column and the storage field in the declaration form, the declaration form filling module 104 can be used to retrieve the data of the storage fields corresponding to each declaration column in the declaration form from the database, and convert the format of the retrieved data according to the setting format of the filling content of each declaration column; then starting from the filling start row, according to the correspondence between each declaration column and the storage field, the data that meets the format requirements is filled in each declaration column of the declaration form in turn to complete the filling of the declaration form.

[0058] The declaration module 105 can be connected to the online social security service platform and the online provident fund service platform, and is used to send the filled-in declaration form to the online social security service platform or the online provident fund service platform based on the declaration category of the declaration form.

[0059] Among them, the online social security service platform and the online provident fund service platform can be an officially designated online social security service platform and an online provident fund service platform, or can also be an online social security service platform and an online provident fund service platform provided by a third party (i.e., a supplier, such as a bank). The personnel outsourcing social security and provident fund reporting system 10 provided in the embodiment of the present application can be connected to the online social security service platform and the online provident fund service platform, and based on the reporting category of the reporting form, i.e., social security or provident fund, the filled-in reporting form can be sent to the online social security service platform or the online provident fund service platform to realize the online reporting of the reporting form.

[0060] In addition, the receiving module 106 can be connected to the online social security service platform and the online provident fund service platform, and can be used to receive the declaration results corresponding to the declaration form fed back by the online social security service platform or the online provident fund service platform, so as to realize the online retrieval of the declaration results.

[0061] The embodiment of the present application provides a personnel outsourcing social security and provident fund declaration system. On the one hand, the personnel outsourcing social security and provident fund declaration system supports the configuration and declaration of differentiated declaration forms for social security and provident funds in various regions, and can meet the needs of personnel outsourcing agencies to make social security and provident fund declarations for enterprises or employees in multiple different regions; on the other hand, the personnel outsourcing social security and provident fund declaration system supports the import of declaration forms for social security or provident funds in various regions, and by querying the historical correspondence between historical declaration columns and storage fields in the database, for declaration columns in the declaration form that are the same as historical declaration columns, the system can be used to generate a new declaration form for each region. By setting the correspondence between the declaration columns and the storage fields based on the historical correspondence, the workload of operators in configuring the correspondence between the declaration columns and the storage fields one by one can be reduced, manual configuration errors can be reduced, and configuration efficiency and accuracy can be improved; on the other hand, the personnel outsourcing social security and provident fund declaration system can be connected to the official or third-party online social security service platform and online provident fund service platform, support online declaration of declaration forms and online retrieval of declaration results, which can reduce the workload of manual compilation of reports, delivery of declaration forms and retrieval of declaration results, and further improve the efficiency and accuracy of social security and provident fund declarations.

[0062] According to some embodiments of the present application, in order to reduce the risk of importing an incorrect declaration form, the user may be prompted or required to name the declaration form file name according to preset naming requirements, such as requiring the declaration form file name to contain at least information such as the declaration area, declaration category, and declaration type. For example, the declaration form file name may be "XX City Social Security Increase Membership Declaration Form".

[0063] Accordingly, the declaration form setting module 102 can also be used to extract the declaration area, declaration category and declaration type from the declaration form file name of the imported declaration form after the declaration form is imported, and compare the extracted declaration area, declaration category and declaration type with the declaration area, declaration category and declaration type set by the system one by one, so as to realize automatic verification of the declaration area, declaration category and declaration type of the imported declaration form, so as to reduce the risk of importing an incorrect declaration form. In some examples, if the declaration area, declaration category and declaration type of the imported declaration form are consistent with the declaration area, declaration category and declaration type set by the system, the verification is correct, and the subsequent step of querying the historical correspondence between the historical declaration column and the storage field in the database is executed. Otherwise, the verification fails, and the user can be prompted that the imported declaration form is wrong.

[0064] According to some embodiments of the present application, optionally, the declaration form setting module 102 can realize automatic configuration of the correspondence between the i-th declaration column and the storage field by executing the following steps.

[0065] Specifically, the declaration form setting module 102 can be used to query the database for any i-th declaration column to see whether there is a first historical declaration column that is the same as the i-th declaration column under the same settings as the declaration area, declaration category and declaration type of the application form; if there is a first historical declaration column, and the first historical correspondence between the first historical declaration column and the storage field is unique, then the correspondence between the i-th declaration column and the storage field is set based on the first historical correspondence.

[0066] The uniqueness of the first historical correspondence between the first historical declaration column and the storage field can be understood as the first historical declaration column only corresponds to one storage field in the database. For example, the first historical declaration column only corresponds to storage field a. The uniqueness of the second historical correspondence in the following text is similar to the uniqueness of the third historical correspondence, which will not be repeated here.

[0067] The declaration form setting module 102 can also be used to continue to query the database whether there is a second historical declaration column that is the same as the i-th declaration column under the same settings as the declaration area and declaration category of the application form if the first historical declaration column does not exist or the first historical correspondence is not unique; if there is a second historical declaration column and the second historical correspondence between the second historical declaration column and the storage field is unique, then the correspondence between the i-th declaration column and the storage field is set based on the second historical correspondence.

[0068] The declaration form setting module 102 can also be used to continue to query whether there is a third historical declaration column that is the same as the i-th declaration column under the same setting as the declaration area of ​​the application form in the database if there is no second historical declaration column or the second historical correspondence is not unique; if there is a third historical declaration column, and the third historical correspondence between the third historical declaration column and the storage field is unique, then the correspondence between the i-th declaration column and the storage field is set based on the third historical correspondence. If the third historical declaration column still does not exist or the third historical correspondence is not unique, then the correspondence between the i-th declaration column and the storage field is set based on the declaration column setting module 103. That is, if the third historical declaration column still does not exist or the third historical correspondence is not unique, then on the declaration column setting page, in response to the user's input on the declaration column setting page, the correspondence between the i-th declaration column and the storage field is set.

[0069] In this way, by setting three levels or priorities to query the historical declaration columns that are the same as the i-th declaration column, it is beneficial to improve the accuracy of configuring the corresponding relationship between the i-th declaration column and the storage field.

[0070] According to some embodiments of the present application, the declaration column setting page can optionally display declaration columns in the declaration form that are different from the historical declaration columns, that is, declaration columns that have not been configured with corresponding relationships. In this way, it is convenient for users to intuitively view the declaration columns that have not been configured with corresponding relationships, and then configure the corresponding relationships of these declaration columns, which is conducive to shortening the configuration time and improving the configuration accuracy.

[0071] According to some embodiments of the present application, the declaration column setting page can optionally also display the declaration columns in the declaration form that are the same as the historical declaration columns, that is, the declaration columns that have been automatically configured with corresponding relationships, and the declaration columns that have not been configured with corresponding relationships and the declaration columns that have been automatically configured with corresponding relationships can be distinguished by different marks. In this way, it is convenient for users to know which declaration columns have been configured with corresponding relationships and which declaration columns have not been configured with corresponding relationships.

[0072] Figure 4 The following diagram shows the page for setting the declaration column. Figure 4 As shown, according to some embodiments of the present application, optionally, the declaration column setting page can display a first option corresponding one-to-one to the information in the system and a second option for filling in fixed information.

[0073] Figure 5 The following diagram schematically shows the declaration column setting page when clicking the first option. Figure 1 and Figure 5 As shown, the declaration column setting module 103 can be specifically used to select the storage field corresponding to the jth declaration column in response to the user's storage field selection input and format setting input when the user clicks the first option, so as to establish a corresponding relationship between the jth declaration column and the storage field, and set the date format and / or value format of the content filled in the jth declaration column. One-to-one correspondence with system information means taking the value of the storage field corresponding to the jth declaration column in the specific table under the specified database, and then directly filling the value into the filling area corresponding to the jth declaration column.

[0074] Specifically, when the user clicks the first option "One-to-one correspondence with information in the system", in response to the user's storage field selection input, the storage field corresponding to the jth declaration column can be selected. In some embodiments, considering that there are many storage fields in the database, the multiple storage fields in the database can be divided into multiple categories, and each category can include at least one storage field. Figure 5As shown, in some examples, multiple storage fields in the database can be divided into five categories, such as "employee information", "housing provident fund information", "contract information", "address information" and "regional collection information". When a user clicks on a category, he can view multiple storage fields under the category, and then select one of the storage fields as the storage field corresponding to the jth declaration column. In this way, it is convenient for users to quickly find the storage field they want to configure from many storage fields, shortening the configuration time.

[0075] like Figure 5 As shown, in response to the user's format setting input, the date format and / or value format of the content filled in the j-th declaration column can be set. For example, the date format can be October 10, 2024, October 2024, 2024.10.10, 2024-10-10 or 2024 / 10 / 10, etc. The value format can include the number of decimal places, whether to display the percentage sign, whether the mantissa of the value is retained to the cent, yuan or ten yuan, etc.

[0076] Figure 6 The following diagram schematically shows the declaration column setting page when clicking the second option. Figure 1 and Figure 6 As shown, the declaration column setting module 103 can be specifically used to set the content of the j-th declaration column to be left blank, automatically fill in the serial number, or fill in the content entered by the user in response to the user's input when the user clicks the second option. Leaving it blank means that nothing is filled in the j-th declaration column. When the user expects to fill in certain content in the j-th declaration column, for example, he can click the "Other" option, and then enter the content he wants to display in the input box of the declaration column setting page. When filling in the declaration form later, the j-th declaration column can be filled in based on the content entered by the user.

[0077] like Figure 4 As shown, according to some embodiments of the present application, optionally, the declaration column setting page can also display a third option that matches the (HRO) system option with the declaration form option.

[0078] Figure 7 The following diagram schematically shows the declaration column setting page when clicking the third option. Figure 1 and Figure 7 As shown, the declaration column setting module 103 can be specifically used to select the storage field corresponding to the j-th declaration column in response to the user's storage field selection input and conversion relationship input when the user clicks the third option, so as to establish a corresponding relationship between the j-th declaration column and the storage field, and set the conversion relationship of the data in the storage field. The conversion relationship is used to convert the data in the storage field corresponding to the j-th declaration column into translation data filled in the j-th declaration column when filling in the j-th declaration column.

[0079] Specifically, when the user clicks the third option of "Matching HRO system options with declaration form options", in response to the user's storage field selection input, the storage field corresponding to the j-th declaration column can be selected to establish a corresponding relationship between the j-th declaration column and the storage field. Similar to when the first option is clicked, in some examples, for example, multiple storage fields in the database can be divided into five categories, such as "employee information", "provident fund information", "contract information", "address information" and "regional collection information". When the user clicks on a category, the user can view multiple storage fields under the category, and then select one of the storage fields as the storage field corresponding to the j-th declaration column. In this way, it is convenient for the user to quickly find the storage field that the user expects to configure from a large number of storage fields, thereby shortening the configuration time.

[0080] by Figure 7 For example, when the user clicks on the "employee information" category, he can view the storage fields of the document type under this category, and can continue to select any one of the eight storage fields such as "resident identity card", "Chinese passport", "foreign passport" etc. under the storage field of this document type as the storage field corresponding to the j-th declaration column.

[0081] Considering that the naming (or form) of the data in the storage field in the database may be inconsistent with the naming required by the declaration column, such as for the declaration column of "gender", it is required to fill in male or female, while the data of the storage field of "gender" in the database is male or female. Therefore, the declaration column setting page can support the user to input the conversion relationship between the content filled in the declaration column and the data of the storage field in the database. In response to the user's input of the conversion relationship, the conversion relationship between the content filled in the declaration column and the data of the storage field in the database can be set. For example, in the input box of the declaration form option on the declaration column setting page, enter "convert male to male, convert female to female". In this way, when filling in the jth declaration column, the data of the storage field corresponding to the jth declaration column can be converted into translation data, such as "convert male to male, convert female to female", and then fill in the translation data into the filling area corresponding to the jth declaration column.

[0082] According to some embodiments of the present application, optionally, the declaration form setting module 102 can also be used to set the format of the content filled in the i-th declaration column for any i-th declaration column that is the same as the historical declaration column in the declaration form, based on the format of the content filled in the historical declaration column that is the same as the i-th declaration column. The format includes but is not limited to the date format and / or value format described above.

[0083] In this way, for the declaration columns in the declaration form that are the same as the historical declaration columns, the format of the content filled in the declaration columns can be automatically configured, reducing the workload of operators to configure the format of the content filled in the declaration columns one by one, reducing manual configuration errors, and further improving configuration efficiency and accuracy.

[0084] According to some embodiments of the present application, optionally, the declaration column setting module 103 can also be used to modify the correspondence between the i-th declaration column and the storage field in the declaration form that is the same as the historical declaration column in response to the user's input on the declaration column setting page, and / or modify the format of the filled-in content of the i-th declaration column.

[0085] In this way, when the correspondence between some of the same declaration columns in the new version of the declaration form and the old version of the declaration form and / or the expected filling format changes, based on the user's input on the declaration column setting page, the correspondence between the declaration columns and storage fields in the new version of the declaration form that are the same as the historical declaration columns can be modified, and / or the format of the filling content of the declaration columns can be modified to meet the requirements for changes in the correspondence and / or format.

[0086] According to some embodiments of the present application, optionally, the personnel outsourcing social security and provident fund declaration system 10 provided in the embodiments of the present application may also include a comparison module, which can be used to compare the filled-in contents of each declaration column of each employee in the declaration form with the declaration results item by item, and output a comparison report.

[0087] The comparison report may display the company name corresponding to the declaration form, the name of the target employee, the calculated amount of social insurance or provident fund declared by the target employee, the actual amount of social insurance or provident fund paid by the target employee, and the declaration columns with differences in the comparison. The target employees may at least include the employees whose filled-in contents in the declaration columns differ from the declaration results.

[0088] In this way, after obtaining the declaration results, the declaration results will be imported into the system and compared with the declaration form item by item to generate a comparison report. The difference data between the two can be monitored and used as a basis for subsequent data processing. This can greatly reduce the work of manual compilation of reports and comparison of data, and improve work efficiency and accuracy.

[0089] According to some embodiments of the present application, optionally, the personnel outsourcing social security and provident fund declaration system 10 provided in the embodiments of the present application may also include a status display module, which may be used to update and display the declaration status of the social security or provident fund of each employee in the declaration form according to the declaration results. The declaration status may at least include declaring in progress, successful declaration or failed declaration.

[0090] Specifically, the declaration result can show whether the social security or provident fund declaration of each employee of the declaring enterprise is successful. For any employee, if the declaration result shows that the social security or provident fund declaration of the employee is successful, the declaration status of the social security or provident fund of the employee can be updated and displayed in the system as successful. If the declaration result shows that the social security or provident fund declaration of the employee fails, the declaration status of the social security or provident fund of the employee can be updated and displayed in the system as failed.

[0091] According to some embodiments of the present application, optionally, the personnel outsourcing social security and provident fund declaration system 10 provided in the embodiments of the present application can support the declaration of multiple declaration forms in the same time period, such as the declaration forms of multiple different enterprises at the same time.

[0092] Specifically, the personnel outsourcing social security and provident fund declaration system 10 can support the operator to simultaneously select multiple declaration tasks (start, supplementary payment, change, exit) of various declaration types under the social security and provident fund categories, click to confirm to generate the declaration file, and the personnel outsourcing social security and provident fund declaration system 10 can find the matching declaration form ID according to 1) the current valid declaration form, 2) the region corresponding to the declaration task = the region of the declaration form 3) the task type corresponding to the declaration task = the declaration type involved in the declaration form, and fill in each declaration form according to the correspondence and format between each declaration column and the storage field set in each declaration form.

[0093] Considering that the personnel outsourcing social security and provident fund declaration system 10 may submit multiple declaration forms in the same time period, and may also receive multiple declaration results in the same time period. Therefore, the declaration batch, enterprise unified social credit code, declaration type, employee name and / or employee ID number and other information of the declaration results can be matched with the declaration batch, enterprise unified social credit code, declaration type, employee name and / or employee ID number and other information of the declaration form to find the declaration result corresponding to each declaration form.

[0094] According to some embodiments of the present application, each declaration form may optionally include one or more worksheets. For example, a declaration form may include a recruitment filing worksheet and a social security increase worksheet. For another example, a declaration form may include an increase report worksheet, a change report worksheet, and a supplement report worksheet. Each worksheet may be configured and filled in based on the configuration and filling method of the above-mentioned declaration form, and the present application does not limit this.

[0095] According to some embodiments of the present application, optionally, when a declaration form includes multiple worksheets, the multiple worksheets can be merged into an Excel file according to a preset arrangement order, and the file ID can be returned to the business end for download on the page, thereby facilitating user viewing.

[0096] According to some embodiments of the present application, optionally, the declaration form adding module 101, the declaration form setting module 102, the declaration column setting module 103 and the declaration form filling module 104 can also be used to cancel the declaration form operation on the data of the generated declaration form in response to the user's cancellation operation during the configuration process or filling process of the declaration form. After setting to a new declaration template, regenerate the declaration form.

[0097] Based on the personnel outsourcing social security and provident fund declaration system 10 provided in the above embodiment, the present application also provides a personnel outsourcing social security and provident fund declaration method. The personnel outsourcing social security and provident fund declaration method can be applied to the personnel outsourcing social security and provident fund declaration system 10 provided in the above embodiment, or can be executed based on the personnel outsourcing social security and provident fund declaration system 10.

[0098] Figure 8 A flow chart of the social security and provident fund declaration method for personnel outsourcing provided in the embodiment of the present application. Figure 8 As shown, the human resources outsourcing social security and provident fund declaration method provided in the embodiment of the present application may include the following steps:

[0099] S801: In response to the user's input on the new declaration form page, the declaration area, declaration category and activation date of the newly added declaration form are set, and the declaration category includes social security or provident fund;

[0100] S802: In response to the user's input on the declaration form setting page, the form name, declaration type, declaration column start row and fill start row of the newly added declaration form are set, and the application form to be used is imported, and each declaration column in the header of the declaration column start row of the declaration form is read, and the historical correspondence between the historical declaration columns and the storage fields in the database is queried; wherein, for any i-th declaration column in the declaration form that is the same as the historical declaration column, the correspondence between the i-th declaration column and the storage field is set based on the historical correspondence, and i is a positive integer;

[0101] S803: In response to the user's input on the declaration column setting page, a corresponding relationship between any j-th declaration column different from the historical declaration column in the declaration form and the storage field is set, and a format for filling in at least part of the declaration column is set, where j is a positive integer;

[0102] S804: Starting from the filling start row, the data of multiple storage fields in the database are filled into the declaration form according to the corresponding relationship and format between each declaration column and the storage field;

[0103] S805: Based on the declaration category of the declaration form, the completed declaration form is sent to the online social security service platform or the online provident fund service platform;

[0104] S806: Receive the declaration result corresponding to the declaration form fed back by the online social security service platform or the online provident fund service platform.

[0105] The specific process of each step has been described in detail above and will not be repeated here.

[0106] The human resources outsourcing social security and provident fund declaration method provided in the embodiment of the present application can, on the one hand, support the configuration and declaration of differentiated declaration forms for social security and provident funds in various regions, and can meet the needs of human resources outsourcing agencies to make social security and provident fund declarations for enterprises or employees in multiple different regions; on the other hand, it can support the import of social security or provident fund declaration forms for various regions, and by querying the historical correspondence between historical declaration columns and storage fields in the database, for declaration columns in the declaration form that are the same as historical declaration columns, the correspondence between the declaration columns and the storage fields is set based on the historical correspondence, which can reduce the workload of operators to configure the correspondence between the declaration columns and the storage fields one by one, reduce manual configuration errors, and improve configuration efficiency and accuracy; on the other hand, it can be connected with official or third-party online social security service platforms and online provident fund service platforms, support online declaration of declaration forms and online retrieval of declaration results, which can reduce the workload of manual compilation of reports, delivery of declaration forms and retrieval of declaration results, and further improve the efficiency and accuracy of social security and provident fund declarations.

[0107] Figure 8 Each step in the method shown has the functions of realizing each module / unit in the personnel outsourcing social security and provident fund declaration system provided in the above embodiment, and can achieve its corresponding technical effects. For the sake of concise description, it will not be repeated here.

[0108] Based on the personnel outsourcing social security and provident fund declaration system 10 provided in the above embodiment, the present application also provides an electronic device, which is deployed with the personnel outsourcing social security and provident fund declaration system 10.

[0109] The electronic devices include but are not limited to smart phones, tablet computers, laptops, desktop computers, smart TVs, various wearable devices, augmented reality (AR) devices, virtual reality (VR) devices, etc.

[0110] In combination with the method in the above embodiments, an embodiment of the present application also provides a computer-readable storage medium, on which computer program instructions are stored. When the computer program instructions are executed by a processor, the process or function of any method in the above embodiments is implemented.

[0111] In addition, an embodiment of the present application further provides a computer program product, on which computer program instructions are stored. When the computer program instructions are executed by a processor, the process or function of any one of the methods in the above embodiments is implemented.

[0112] The above exemplarily describes the flowcharts and / or block diagrams of the methods, devices, systems and computer program products of the embodiments of the present application, and describes the relevant various aspects. It should be understood that each box or combination thereof in the flowchart and / or block diagram can be implemented by computer program instructions, or by dedicated hardware that performs a specified function or action, or by a combination of dedicated hardware and computer instructions. For example, these computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer or other programmable data processing device to form a machine that enables these instructions executed by such a processor to enable the implementation of the functions / actions specified in each box or combination thereof in the flowchart and / or block diagram. Such a processor can be a general-purpose processor, a special-purpose processor, a special application processor or a field programmable logic circuit.

[0113] The functional blocks shown in the structured block diagram of the embodiment of the present application can be implemented as hardware, software, firmware or a combination thereof. When implemented in hardware, it can be, for example, an electronic circuit, an application-specific integrated circuit (ASIC), appropriate firmware, a plug-in, a function card, etc.; when implemented in software, it is a program or code segment used to perform the required task. The program or code segment can be stored in a memory, or transmitted on a transmission medium or a communication link via a data signal carried in a carrier. The code segment can be downloaded via a computer network such as the Internet, an intranet, etc.

[0114] It should be noted that the present application is not limited to the specific configurations and processes described above or shown in the figures. The above is only a specific implementation mode of the present application. Those skilled in the art can clearly understand that for the convenience and brevity of description, the specific working process of the described system, device, module or unit can refer to the corresponding process in the method embodiment without further description. It should be understood that the scope of protection of the present application is not limited to this. Any technician familiar with the technical field can think of various equivalent modifications or substitutions within the technical scope disclosed in the present application, and these modifications or substitutions should be included in the scope of protection of the present application.

Claims

1. A personnel outsourcing social security and provident fund reporting system, characterized in that: include: A declaration form addition module is used to display a declaration form addition page, and in response to the user's input on the declaration form addition page, set the declaration area, declaration category and activation date of the newly added declaration form, and the declaration category includes social security or provident fund; The declaration form setting module is used to display the declaration form setting page, and in response to the user's input on the declaration form setting page, set the form name, declaration type, declaration column starting line and fill starting line of the newly added declaration form, import the declaration form to be used, read each declaration column in the header located at the declaration column starting line of the declaration form, and query the historical correspondence between the historical declaration columns and the storage fields in the database; wherein, for any i-th declaration column in the declaration form that is the same as the historical declaration column, the correspondence between the i-th declaration column and the storage field is set based on the historical correspondence, and i is a positive integer; A declaration column setting module, used to display a declaration column setting page, and in response to the user's input on the declaration column setting page, set the corresponding relationship between any j-th declaration column in the declaration form that is different from the historical declaration column and the storage field, and set the format of the content filled in at least part of the declaration column, where j is a positive integer; The declaration form filling module is used to fill in the data of multiple storage fields in the database into the declaration form according to the corresponding relationship and format between each declaration column and the storage field, starting from the filling start line; The declaration module is connected to the online social security service platform and the online provident fund service platform, and is used to send the completed declaration form to the online social security service platform or the online provident fund service platform based on the declaration category of the declaration form; The receiving module is connected to the online social security service platform and the online provident fund service platform, and is used to receive the declaration results corresponding to the declaration form fed back by the online social security service platform or the online provident fund service platform.

2. The personnel outsourcing social security and provident fund reporting system according to claim 1 is characterized in that: The declaration form setting module is specifically used to query the database for any i-th declaration column to see whether there is a first historical declaration column that is the same as the i-th declaration column under the same settings as the declaration area, declaration category and declaration type of the declaration form; if so, and the first historical correspondence between the first historical declaration column and the storage field is unique, then the correspondence between the i-th declaration column and the storage field is set based on the first historical correspondence; If it does not exist or the first historical correspondence is not unique, then continue to query whether there is a second historical declaration column that is the same as the i-th declaration column under the same settings as the declaration area and declaration category of the declaration form in the database; if it exists, and the second historical correspondence between the second historical declaration column and the storage field is unique, then the correspondence between the i-th declaration column and the storage field is set based on the second historical correspondence; If it does not exist or the second historical correspondence is not unique, continue to query the database whether there is a third historical declaration column that is the same as the i-th declaration column under the same settings as the declaration area of ​​the declaration form; if it exists, and the third historical correspondence between the third historical declaration column and the storage field is unique, then the correspondence between the i-th declaration column and the storage field is set based on the third historical correspondence.

3. The personnel outsourcing social security and provident fund reporting system according to claim 1 is characterized in that: The declaration column setting page displays the declaration columns in the declaration form that are different from the historical declaration columns.

4. The personnel outsourcing social security and provident fund reporting system according to claim 1 is characterized in that: The declaration column setting page displays a first option that corresponds to the information in the system one by one and a second option that fills in fixed information; The declaration column setting module is specifically used for selecting the storage field corresponding to the jth declaration column in response to the user's storage field selection input and format setting input when the user clicks the first option, so as to establish a corresponding relationship between the jth declaration column and the storage field, and set the date format and / or value format of the content filled in the jth declaration column; The declaration column setting module is specifically used to set the filling content of the jth declaration column to leave it blank, automatically fill in the serial number, or fill in the content entered by the user in response to the user's input when the user clicks the second option.

5. The personnel outsourcing social security and provident fund reporting system according to claim 4 is characterized in that: The declaration column settings page also displays a third option that matches the system options with the declaration form options; The declaration column setting module is specifically used to select the storage field corresponding to the j-th declaration column in response to the user's storage field selection input and conversion relationship input when the user clicks the third option, so as to establish a corresponding relationship between the j-th declaration column and the storage field, and set the conversion relationship of the data in the storage field. The conversion relationship is used to convert the data in the storage field corresponding to the j-th declaration column into translation data filled in the j-th declaration column when filling in the j-th declaration column.

6. The personnel outsourcing social security and provident fund reporting system according to claim 1 is characterized in that: The declaration form setting module is also used to set the format of the content filled in the i-th declaration column for any i-th declaration column in the declaration form that is the same as the historical declaration column, based on the format of the content filled in the historical declaration column that is the same as the i-th declaration column; The declaration column setting module is also used to respond to the user's input on the declaration column setting page, modify the correspondence between the i-th declaration column and the storage field in the declaration form that is the same as the historical declaration column, and / or modify the format of the content filled in the i-th declaration column.

7. The personnel outsourcing social security and provident fund reporting system according to claim 1 is characterized in that: Also includes: The comparison module is used to compare the content of each declaration column of each employee in the declaration form with the declaration result item by item and output a comparison report; Among them, the comparison report shows the company name corresponding to the declaration form, the name of the target employee, the calculated amount of social insurance or provident fund declared by the target employee, the actual payment amount of social insurance or provident fund declared by the target employee, and the declaration columns where there are differences in the comparison. The target employees at least include the employees whose filled-in contents in the declaration columns are different from the declaration results.

8. The personnel outsourcing social security and provident fund reporting system according to claim 1 is characterized in that: Also includes: The status display module is used to update and display the declaration status of each employee's social security or provident fund in the declaration form according to the declaration results. The declaration status includes declaration in progress, declaration successful or declaration failed.

9. A method for declaring social security and provident fund for personnel outsourcing, characterized in that: A personnel outsourcing social security and provident fund declaration system as claimed in any one of claims 1 to 8, comprising: In response to the user's input on the new declaration form page, the declaration area, declaration category and activation date of the newly added declaration form are set, and the declaration category includes social insurance or provident fund; In response to the user's input on the declaration form setting page, the form name, declaration type, declaration column starting row and fill starting row of the newly added declaration form are set, and the declaration form to be used is imported, and each declaration column in the header of the declaration column starting row of the declaration form is read, and the historical correspondence between the historical declaration columns and the storage fields in the database is queried; wherein, for any i-th declaration column in the declaration form that is the same as the historical declaration column, the correspondence between the i-th declaration column and the storage field is set based on the historical correspondence, and i is a positive integer; In response to the user's input on the declaration column setting page, the corresponding relationship between any j-th declaration column in the declaration form that is different from the historical declaration column and the storage field is set, and the format of the filling content of at least part of the declaration column is set, where j is a positive integer; Starting from the filling start row, fill the data of multiple storage fields in the database into the declaration form according to the corresponding relationship and format between each declaration column and storage field; Based on the declaration category of the declaration form, send the completed declaration form to the online social security service platform or the online provident fund service platform; Receive the declaration results corresponding to the declaration form fed back by the online social security service platform or the online provident fund service platform.

10. An electronic device, characterized in that: The electronic device is deployed with the personnel outsourcing social security and provident fund declaration system as described in any one of claims 1 to 8.

Images