阅读说明：本技术 一种基于大数据的社团经费管理系统 (Community expense management system based on big data ) 是由 霍辰 梅良才 于 2021-09-22 设计创作，主要内容包括：本发明公开了一种基于大数据的社团经费管理系统,涉及资源管理技术领域,通过设置固定资产管理单元和资金管理单元分别对社团的固定资产和资金分别进行管理,从而使得社团的资产管理更加方便和透明化,从而避免了传统人工管理时的混乱和不清晰；信用评级模块根据社团的历史申请情况以及社团在使用固定资产的过程中是否对固定资产产生了损坏,再结合社团在申请资产过程中是否按照申请时间对固定资产进行提取和归还,从而对每个社团进行信用评级,而社团的信用评级能够直接影响社团所能够申请的资金的额度,从而能够使得社团在领取固定资产后,对固定资产进行更加规范和良好的使用,增强社团在使用固定资产过程中的责任心,避免固定资产无故损坏。(The invention discloses a community expense management system based on big data, which relates to the technical field of resource management.A fixed asset management unit and a fund management unit are arranged to respectively manage fixed assets and funds of a community, so that the asset management of the community is more convenient and transparent, and the confusion and the unclear property in the traditional manual management are avoided; the credit rating module is used for carrying out credit rating on each community according to the historical application condition of the community and whether the community damages the fixed assets in the process of using the fixed assets, and then the credit rating module is used for carrying out credit rating on each community by combining with whether the community extracts and returns the fixed assets according to the application time in the process of applying for the assets, so that the credit rating of the community can directly influence the amount of funds which can be applied by the community, the community can use the fixed assets more normatively and well after receiving the fixed assets, the responsibility of the community in the process of using the fixed assets is enhanced, and the fixed assets are prevented from being damaged without accident.)

1. A community expense management system based on big data comprises a management center and a database, and is characterized in that the management center is respectively in communication connection with a financial management module, an asset application module, an audit module and a credit rating module;

the database is used for establishing a community information sub-base;

the financial management module comprises a fixed asset management unit and a fund management unit, and is used for respectively managing fixed assets and cash;

the asset application module is used for carrying out asset application by a community;

the auditing module is used for auditing the asset application;

and the credit rating module is used for carrying out credit rating on the communities.

2. The big-data-based community expense management system of claim 1, wherein the establishment of the community information sub-base comprises: building a community information sub-base, and creating a plurality of community information subsets in the community information sub-base; respectively importing basic information of registered communities into each community information subset; the basic information of the community comprises the name of the community, the scale of the community, the establishment duration of the community and the basic information of a main responsible person of the community; the basic information of the main principal of the community comprises name, age, grade, gender and mobile phone number of real-name authentication; and respectively generating an index sequence for each community information subset, and binding the index sequence with the community information subsets.

3. The method of claim 1The big data-based community expense management system is characterized in that the cash management process of the fund management unit specifically comprises the following steps: respectively setting a fund income catalogue and a fund expenditure catalogue, and respectively uploading the fund income statement and the fund expenditure statement into the fund income catalogue and the fund expenditure catalogue; capturing each income sub-item within the income statement of funds and tagging each income sub-item as i, i ═ 1, 2, … … n, n being an integer, and tagging the amount of each income sub-item as SJ_i(ii) a Obtaining each expenditure sub-item in the fund expenditure detail, marking each expenditure sub-item as j, j is 1, 2, … … m is an integer, and marking the amount of each expenditure sub-item as ZJ_j。

4. The big data-based community expense management system of claim 1, wherein the fixed asset management unit manages the fixed assets by: setting a fixed asset name list, and uploading basic information of the fixed asset to the fixed asset name list; the basic information of the fixed assets includes name, quantity and value; independently coding each fixed asset, and binding the independent codes with the fixed assets; setting the use state of the fixed asset according to the use condition of the fixed asset; the usage status of the fixed asset includes in-use, idle, and retirement.

5. The big data-based community expense management system of claim 4, wherein the process of applying for assets by a community comprises: inputting an asset application name list, wherein the asset application name list comprises fixed asset application items and fund application items; acquiring the name, the number SS and the use duration of the fixed asset application item; acquiring the application amount of a fund application item, and marking the application amount as SQ; selecting basic information and applicant information of a community, wherein the applicant information is at least one of main responsible persons of the corresponding community, then sending verification information to a mobile phone number bound by an applicant by a system, and submitting an asset application after the applicant inputs a verification code into the system.

6. The big-data-based community expense management system of claim 5, wherein the process of auditing the assets comprises: generating a retrieval sequence according to the name of the fixed asset application item, and retrieving the number and the use state of the corresponding fixed assets in the fixed asset management unit through the retrieval sequence; acquiring the number of the fixed assets with idle use states, and marking the number as XS; and when XS is larger than or equal to SS, the fixed asset applies for passing and obtains the actual payment amount JQ.

7. The big data-based community expense management system of claim 6, wherein the process of credit rating the community comprises: acquiring historical asset application times a of a community, acquiring the times a1 of fixed assets which are overdue and not extracted and the times a2 of fixed assets which are overdue and not returned, and marking the times of fixed assets which are damaged as a 3; acquiring actual use cost SF of a community; and obtaining a community credit rating coefficient XX according to the parameters.

8. The big-data-based community expense management system of claim 5, wherein the usage duration is a duration between a scheduled extraction time and a scheduled return time.

Technical Field

The invention belongs to the technical field of resource management, and particularly relates to a community expense management system based on big data.

Background

Students are the subjects of schools, and social activities are one of the important activities of students in schools. The important part of the student group is the organization of the society and the association of groups (union of groups students, hereinafter referred to as the association of groups for short), the development of the related functions can assist the group committee workers to carry out work more efficiently, the centralized management of the activity affairs of groups can also agglomerate various cultural interests, and the after-class life of students is enriched;

when a community carries out a series of activities, funds or equipment are often applied for, the management of the existing community assets is often counted and distributed manually, on one hand, the asset management mode can make the asset management unclear and disordered, and meanwhile, the resource distribution among various communities is unreasonable, and how to improve the management efficiency and the rationality of the resource distribution is a problem which needs to be solved.

Disclosure of Invention

The invention aims to provide a community expense management system based on big data.

The purpose of the invention can be realized by the following technical scheme: a community expense management system based on big data comprises a management center and a database, wherein the management center is respectively in communication connection with a financial management module, an asset application module, an audit module and a credit rating module;

the database is used for establishing a community information sub-base;

the financial management module comprises a fixed asset management unit and a fund management unit, and is used for respectively managing fixed assets and cash;

the asset application module is used for carrying out asset application by a community;

the auditing module is used for auditing the asset application;

and the credit rating module is used for carrying out credit rating on the communities.

Further, the establishment process of the community information sub-base comprises the following steps: building a community information sub-base, and creating a plurality of community information subsets in the community information sub-base; respectively importing basic information of registered communities into each community information subset; the basic information of the community comprises the name of the community, the scale of the community, the establishment duration of the community and the basic information of a main responsible person of the community; the basic information of the main principal of the community comprises name, age, grade, gender and mobile phone number of real-name authentication; and respectively generating an index sequence for each community information subset, and binding the index sequence with the community information subsets.

Further, the cash management process of the fund management unit specifically includes: respectively setting a fund income catalogue and a fund expenditure catalogue, and respectively uploading the fund income statement and the fund expenditure statement into the fund income catalogue and the fund expenditure catalogue; capturing each income sub-item within the income statement of funds and tagging each income sub-item as i, i ═ 1, 2, … … n, n being an integer, and tagging the amount of each income sub-item as SJ_i(ii) a Obtaining each expenditure sub-item in the fund expenditure detail, marking each expenditure sub-item as j, j is 1, 2, … … m is an integer, and marking the amount of each expenditure sub-item as ZJ_j。

Further, the fixed asset management unit manages the fixed asset by the fixed asset management unit, and the fixed asset management unit comprises: setting a fixed asset name list, and uploading basic information of the fixed asset to the fixed asset name list; the basic information of the fixed assets includes name, quantity and value; independently coding each fixed asset, and binding the independent codes with the fixed assets; setting the use state of the fixed asset according to the use condition of the fixed asset; the usage status of the fixed asset includes in-use, idle, and retirement.

Further, the process of the community applying for the assets comprises the following steps: inputting an asset application name list, wherein the asset application name list comprises fixed asset application items and fund application items; acquiring the name, the number SS and the use duration of the fixed asset application item; acquiring the application amount of a fund application item, and marking the application amount as SQ; selecting basic information and applicant information of a community, wherein the applicant information is at least one of main responsible persons of the corresponding community, then sending verification information to a mobile phone number bound by an applicant by a system, and submitting an asset application after the applicant inputs a verification code into the system.

Further, the process of auditing the assets includes: generating a retrieval sequence according to the name of the fixed asset application item, and retrieving the number and the use state of the corresponding fixed assets in the fixed asset management unit through the retrieval sequence; acquiring the number of the fixed assets with idle use states, and marking the number as XS; and when XS is larger than or equal to SS, the fixed asset applies for passing and obtains the actual payment amount JQ.

Further, the process of credit rating the community includes: acquiring historical asset application times a of a community, acquiring the times a1 of fixed assets which are overdue and not extracted and the times a2 of fixed assets which are overdue and not returned, and marking the times of fixed assets which are damaged as a 3; acquiring actual use cost SF of a community; and obtaining a community credit rating coefficient XX according to the parameters.

Further, the usage duration is a duration between the scheduled extraction time and the scheduled return time.

The invention has the beneficial effects that: the fixed asset management unit and the fund management unit are arranged to respectively manage the fixed assets and the funds of the community, so that the asset management of the community is more convenient and transparent, and the confusion and the unclear effect in the traditional manual management are avoided; meanwhile, a credit rating module is arranged, according to the historical application condition of the community and whether the community damages the fixed assets in the process of using the fixed assets, the credit rating module is combined with whether the community extracts and returns the fixed assets according to the application time in the process of applying for the assets, so that credit rating is carried out on each community, the credit rating of the community can directly influence the amount of funds which the community can apply for, the community can use the fixed assets more regularly and well after receiving the fixed assets, the responsibility of the community in the process of using the fixed assets is enhanced, and the fixed assets are prevented from being damaged without accident.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.

FIG. 1 is a schematic block diagram of a community expense management system based on big data.

Detailed Description

As shown in FIG. 1, a big data-based community expense management system comprises a management center, a database, a financial management module, an asset application module, an auditing module and a credit rating module; the connection mode among the modules is communication connection;

the database is used for establishing a community information sub-base; the establishment process of the community information subbase comprises the following steps:

step X1: building a community information sub-base, and creating a plurality of community information subsets in the community information sub-base;

step X2: respectively importing basic information of registered communities into each community information subset; the basic information of the community comprises the name of the community, the scale of the community, the establishment duration of the community and the basic information of a main responsible person of the community; the basic information of the main principal of the community comprises name, age, grade, gender and mobile phone number of real-name authentication;

step X3: and respectively generating an index sequence for each community information subset, and binding the index sequence with the community information subsets.

The financial management module comprises a fixed asset management unit and a fund management unit, wherein the fixed asset management unit is used for managing fixed assets, and the fund management unit is used for managing cash;

the fixed asset management process of the fixed asset management unit comprises the following steps:

step G1: setting a fixed asset name list, and uploading basic information of the fixed asset to the fixed asset name list; the basic information of the fixed assets includes name, quantity and value;

step G2: independently coding each fixed asset, and binding the independent codes with the fixed assets;

step G3: setting the use state of the fixed asset according to the use condition of the fixed asset; the usage status of the fixed asset includes in-use, idle, and retirement.

The cash management process of the fund management unit specifically comprises the following steps:

step Z1: respectively setting a fund income catalogue and a fund expenditure catalogue, and respectively uploading the fund income statement and the fund expenditure statement into the fund income catalogue and the fund expenditure catalogue;

step Z2: capturing each income sub-item within the income statement of funds and tagging each income sub-item as i, i ═ 1, 2, … … n, n being an integer, and tagging the amount of each income sub-item as SJ_i；

Step Z3: obtaining each expenditure sub-item in the fund expenditure detail, marking each expenditure sub-item as j, j is 1, 2, … … m is an integer, and marking the amount of each expenditure sub-item as ZJ_j。

The asset application module is used for a community to apply for assets, and the specific application process comprises the following steps:

step S1: inputting an asset application name list, wherein the asset application name list comprises fixed asset application items and fund application items;

step S2: acquiring the name, the number SS and the use duration of the fixed asset application item; acquiring the application amount of a fund application item, and marking the application amount as SQ; the service life comprises a plan extraction time and a plan return time;

step S3: selecting basic information and applicant information of a community, wherein the applicant information is at least one of main responsible persons of the corresponding community, then sending verification information to a mobile phone number bound by an applicant by a system, and submitting an asset application after the applicant inputs a verification code into the system.

The auditing module is used for auditing the asset application, and the specific process comprises the following steps:

step H1: generating a retrieval sequence according to the name of the fixed asset application item, and retrieving the number and the use state of the corresponding fixed assets in the fixed asset management unit through the retrieval sequence;

step H2: acquiring the number of the fixed assets with idle use states, and marking the number as XS;

step H3: when XS is larger than or equal to SS, the fixed asset application is passed;

step H4: obtaining an actual payment amount JQ through a formula JQ-SQ multiplied by XX; where XX is the community credit rating coefficient.

The credit rating module is used for carrying out credit rating on the communities, and the specific process comprises the following steps:

step P1: acquiring historical asset application times a of a community, acquiring the times a1 of fixed assets which are overdue and not extracted and the times a2 of fixed assets which are overdue and not returned, and marking the times of fixed assets which are damaged as a 3;

step P2: acquiring actual use cost SF of a community;

step P3: and obtaining a community credit rating coefficient XX through a formula XX ═ JC-a1 × b1-a2 × b2-a1 × b3- (SQ-SF)/SF ]/JC, wherein b1, b2 and b3 are respectively system preset deduction values, b1 is more than b2 is more than b3, and JC is a system preset initial credit score.

It should be further noted that, in the specific implementation process, when the credit rating coefficient XX of the community is lower, the credit rating coefficient XX of the community directly affects the fund application amount of the community in the subsequent asset application process, and accordingly, the community capable of timely extracting and returning the fixed assets can obtain the normal fund application amount, by setting the credit rating module, according to the historical application condition of the community and whether the community damages the fixed assets in the process of using the fixed assets, and by combining whether the community extracts and returns the fixed assets according to the application time in the process of applying for the assets, the credit rating of each community is performed, and the credit rating of the community can directly affect the fund amount that the community can apply for, so that the community can more normatively and well use the fixed assets after drawing the fixed assets, the responsibility of the community in the process of using the fixed assets is enhanced, and the fixed assets are prevented from being damaged without reason.

The working principle is as follows: establishing a community information sub-base in a database, recording basic information of a community and basic information of a main community manager, and then performing statistical management on fixed assets and funds by setting an asset management module; when a community needs to use fixed assets and funds, applying for the fixed assets and the funds through an asset application module, after the community submits a request for the assets, auditing the asset application content of the community through an auditing module so as to determine the quantity of the fixed assets and the quantity of the funds which can be provided, wherein the quantity of the funds depends on the credit rating of the community, the credit rating of the community is judged through a credit rating module, a community credit rating coefficient XX is obtained through the credit rating module, the higher the community credit rating coefficient is, the larger the fund amount which can be applied by the community is, the larger the community credit rating coefficient is influenced by the community on the use condition of the fixed assets and the fund use condition, and the reduction of the community credit rating coefficient can be caused when the community fails to extract and return the fixed assets on time or damage the fixed assets in the use process, therefore, when the community receives the fixed assets, the community can be prompted to more consciously take care of the fixed assets, and the fixed assets are prevented from being damaged without reason.

The above formulas are all calculated by removing dimensions and taking numerical values thereof, the formula is a formula which is obtained by acquiring a large amount of data and performing software simulation to obtain the closest real situation, and the preset parameters and the preset threshold value in the formula are set by the technical personnel in the field according to the actual situation or obtained by simulating a large amount of data.

In the embodiments provided by the present invention, it should be understood that the disclosed apparatus, device and method can be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the modules is only one logical functional division, and there may be other divisions when the actual implementation is performed; the modules described as separate parts may or may not be physically separate, and parts displayed as modules may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the method of the embodiment.

Finally, it should be noted that the above examples are only intended to illustrate the technical process of the present invention and not to limit the same, and although the present invention has been described in detail with reference to the preferred embodiments, it will be understood by those skilled in the art that modifications or equivalent substitutions may be made to the technical process of the present invention without departing from the spirit and scope of the technical process of the present invention.