KR101350299B1 - Local finance management system for managing budget execution - Google Patents

Abstract

The present invention relates to a local finance management system for budget execution management and, more specifically, to a local finance management system for budget execution management which constructs a server for providing budget execution state required for working in local finance management separately from an e-hozo sever which performs official accounting processing according to accounting procedure and data processing according to accounting classification systematically, in making a database by receiving budget compilation and budget execution related data and providing information required in managing local finance, and minimizes waste of administrative power by removing man power input required in making necessary materials for working as making e-hozo server operation smooth according to task processing. [Reference numerals] (1,AA,BB,CC,DD) Terminal; (10) Local finance management server (e-hozo); (11) Tax revenue part; (12) Budget part; (13) Accounting part; (15) Authentication unit; (20) Budget execution management server; (21) User authentication unit; (22) Basic data management part; (23) Matching management part; (24) Status management part; (25) Status DB

Description

LOCAL FINANCE MANAGEMENT SYSTEM FOR MANAGING BUDGET EXECUTION}

The present invention relates to a local financial management system for budget execution management. More specifically, the data according to the accounting classification in inputting the budgeting and budget execution related data into a database and providing information necessary for the management of local finances. Apart from the e-joining server that systemizes and performs official accounting processing in accordance with the processing and accounting procedures, a server is provided to provide the budget execution status necessary for practical management of local financial management. It is to provide a local financial management system for budget execution management that minimizes the waste of administrative power by smoothly eliminating manpower input required for the preparation of practically necessary data.

The local financial management system for managing local finance is called e-join and was established in each local government with the same interface standard.

The local financial management system aggregates the database of revenues for entering and managing revenue-related information, budgets for entering and managing budget-related information, accounting parts for entering and managing contracts and expenditures, and information received. And a database that provides information on budgetary and budgetary status.

As a result, the personnel in charge of revenue, budgeting, and accounting were each connected to input budget-related data, and the inputted data was aggregated, thereby improving work efficiency of local financial management.

However, the existing local financial management system is based on the accounting processing method that organizes and executes the budget according to the accounting classification classified into general accounting, special accounting, and fund. As it is configured to provide a budget execution status, there is a limit in practically not providing information necessary for local financial management.

In other words, the information necessary to manage local finances in practice is not only information related to the total budget of the local government, the budget of each item classified according to the accounting segment, and the balanced execution budget that should be aggregated and reported daily in practice. This is the progress of the budget execution proceeding by each department and the contract cases by the calculation base (bookkeeping name), which is a sub-system of the statistics tree, as a detailed execution matter for each department's statistics tree. This practical information is essential to facilitate financial management by detailing the budget execution status of each department and tracking the causes of poor budget execution.

However, the existing local financial management system did not provide the necessary information in practice, and the person in charge downloads the information provided by the local financial management system and edits it into necessary data for practical use in the form of a report. It took a lot of time to write such a report, which was a waste of administrative power.

On the other hand, the existing local financial management system can be reconfigured for the provision of information necessary for practical use, but not only the cost of system reconfiguration, but also hinders the smooth operation of the system causes a problem. In other words, since the local governments have a lot of people who access and handle the local financial management system, and there are many inputs by the person in charge of the local government, in order to reconfigure to generate and provide necessary information in practice, the system can handle the traffic as much as possible. Must be reconstructed.

In addition, even if the system is constructed to have a desired traffic processing capability, practically necessary information is checked at appropriate time intervals in financial management, and thus there is an inefficiency problem of increasing the processing capacity of the system more than necessary.

KR 10-0983154 B1 2010.09.13. KR 10-1152748 B1 2012.05.29.

Therefore, the object of the present invention is to provide a detailed budget execution situation for each department necessary for the financial management of the local government, but can be established without reconfiguration of the server used for the existing local financial management system and the system operation is also smooth budget management It is to provide a local financial management system for budget execution management, which facilitates business processes and ensures local financial management in accordance with the cause of each department's sluggishness and encourages budget execution.

In order to achieve the above object, the present invention is to be assigned to each department is organized according to the budgeting system of the department name / policy business / unit business / detail business / statistics / production base established by the local government to log in In the local financial management system for budget execution management that inputs the budget, the accounting manager logs in, inputs the execution of contracts and expenses according to the budget, and provides the budget execution status to the logged-in terminal. An authentication unit 15 for registering the user information for logging in to perform authentication of the terminal of the person in charge, and a budget part 12 for inputting the organized budget; An accounting part 13 for inputting budget execution matters; Local financial management consisting of; DB (14) to provide a database of the budget part of the budget part and the budget execution matters of the accounting part and classify according to the accounting classification and provide the current status of budget execution for each department up to the statistics tree to the logged-in terminal Server 10; And a user authentication unit 21 receiving session information of the terminal logged into the local financial management server 10 from the local financial management server 10 and granting access authority by Single Sign On (SSO); A basic data management unit 22 for requesting the DB 14 of the local finance management server 10 to receive the budgeting and budget execution matters at predetermined times; A matching management unit 23 for extracting a budget for determining the execution performance of the department and generating matching data by mutually matching the budgeting and budget execution matters for the calculation basis of the extracted budget; Budget items, budgets, carryover budgets, and balanced execution budgets, which are budget items, are classified into upper classification systems, and each department is classified into lower classification systems. A status management unit 24 for generating budget execution status data for querying the budget execution status of each department for each item of the upper classification system and the budget execution status of the calculation basis for each department; Matching DB 25 for providing the budget execution status data to the terminal authenticated by the user authentication unit 21; It is characterized in that it comprises a; budget execution management server 20 configured to include a.

The budget execution status data for the balanced execution budget includes the average execution target amount and the target achievement rate, and compares the previous day and the day for the cause acting amount and the execution amount, and the execution rate collected by daily and monthly progress and statistics. It is characterized in that the data provided by the chart.

The local financial management server 10 grants only read access to the data of the DB 14 when the budget execution management server 20 is connected, but the budget execution management server 20 among the data stored in the DB 14. In order to read and access only the necessary data in the view list, and monitors the server load status to store and manage the load when the budget execution management server 20 is connected, the administrator can query, the budget execution management server 20 is characterized by managing the IP address of the logged-in terminal, the residence time of the logon state and the history of the page view.

The present invention configured as described above is classified according to the accounting and accounting processing and the local financial management server that provides the aggregated budget execution matters up to the statistical tree according to the accounting classification, and the budget execution status practically necessary for the management of local finances By dualizing with the budget execution management server provided, it provides the status of budget execution practically and smoothly the operation of the local financial management server so that it does not interfere with the daily work due to the budget execution management.

In addition, the present invention includes the execution status of each department for the budget execution, the current budget, the carryover budget, and the balanced execution budget, and the detailed progress by the calculation base (book name) can be seen at a glance. Also, the report required for financial management can be prepared, minimizing administrative waste and improving work efficiency, and it is easy to grasp the current status of each department and extract the cause of poor budget execution and identify the cause. It also provides an environment that can be promptly encouraged to ensure local government financial management.

1 is a block diagram of a local financial management system for budget execution management according to an embodiment of the present invention.
2 is a connection main screen of the budget execution management server 20;
3 is a screen when selecting 'budget execution' in the main screen of FIG.
4 is a screen when selecting 'the budget execution' in the main screen of FIG.
5 is a screen when selecting the 'carry forward business execution' in the main screen of FIG.
6 is a screen when 'balance execution' is selected in the main screen of FIG.
FIG. 7 is an initial screen when the 'balance execution status of each department' is selected on the 'balance execution' screen of FIG.
FIG. 8 is a screen when the department name “strategic planning room” is selected in the department hierarchy diagram displayed on the “balanced execution status of each department” screen of FIG. 6.
9 is a screen when selecting the 'balance execution status (all day)' in the 'balance execution' screen of FIG.
FIG. 10 is a screen when selecting 'detail execution status by detailed project' after selecting 'department execution status' on the main screen of FIG.
FIG. 11 is a screen when a 'book execution status' is selected after selecting 'department execution status' on the main screen of FIG.
12 is a screen when the department name 'strategic planning room' is selected on the screen of FIG.

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, preferred embodiments of the present invention will be described with reference to the accompanying drawings. It should be noted that, in the drawings, the same reference numerals are used to denote the same or similar components in other drawings. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS In the following description of the present invention, detailed description of known functions and configurations incorporated herein will be omitted when it may make the subject matter of the present invention rather unclear.

First, main terms will be explained.

The budget is a plan that considers revenues and expenditures in advance and is organized to carry out the project. The budget is organized to be assigned to each department using the department name / policy project / unit project / detail project / statistics / calculation basis as budgeting system.

Enforcement means contracting and spending in accordance with the organized budget. The causative act is the amount determined to be spent in accordance with the contract or the law, and the execution amount is the amount spent after the contract is completed after the contract is concluded.

The budget balance is the sum of the budget and carryover budget.

The budget is the budget for the current year, and is divided into general accounting, special accounting, and fund according to the accounting classification, and divided into main budget, supplementary budget, and pre-establishment budget according to budgeting time. Different statistics or inter-unit / detailed projects are managed by reassignment, budget change, transfer or conversion. On the other hand, according to the accounting classification, the budget is classified into general accounting and special accounting, and the budget is distinguished from the fund, but it is explained that the budget is divided into general accounting, special accounting and funding according to the local government's financial structure.

Carry-over budget is a budget carried over to the fiscal year that has not been paid for in the previous year and is classified as carryover, carryover, and continuing expenses.

The balanced execution budget is the budget designated for balanced execution according to government policy. Balanced execution is a policy that revitalizes the economy contracted by the funds supplied to the private market early and used by the budget earlier than the planned execution schedule among the budgets formulated according to the business plan established in the year. In the budgeting system, the budget is specified based on the statistics unit budget.

The basis of calculation is a subclassification system of statistics trees in budget formation, and is used as a practical bookkeeping name. In other words, the bookkeeping name is used as the basis for calculating the budget for statistics in sub-projects, and local governments use it as the basis for accounting (eg, contracts and expenses).

1 is a block diagram of a local financial management system for budget execution management according to an embodiment of the present invention, a local financial management server for managing a budget by accessing a person in charge of budget-related tasks using the terminal 1 ( 10) and the budget execution management server 20 for providing information on the budget execution status to the person in charge through the terminal, the person in charge of budget-related tasks using a single sign-on (SSO) of the person in charge (SSO) Single Sign On) to log in to the local financial management server 10 and the budget execution management server 20, respectively. Accordingly, the person in charge inputs data to be input in relation to his / her work during the revenue, budget and accounting by accessing the local financial management server 10 and inquiring the budget execution status to the budget execution management server 20. By accessing and inquiring, by logging in to the local financial management server 10 can be connected to the budget execution management server 20 without a separate login procedure by a single sign-on (SSO: Single Sign On).

The accounting work of local governments is largely divided into revenue, budget and accounting, and the scope of using the local financial management system is divided into requestor for approval and processor for approval according to the duties and positions of each employee. The person in charge of related tasks is classified as a revenue officer in charge of revenue budgeting, a budget manager in charge of budgeting in relation to the expenditure budget, and an accountant in charge of accounting (contracts and expenses) according to the budget. do.

Accordingly, the local finance management server 10 is connected to the revenue officer when logging in, the revenue part 11 arranged to perform the work on the revenue, the budget manager is connected to when the log-in to perform the task of budgeting DB having budget part 12 arranged to perform and accounting part 13 arranged to perform accounting work at the time of accountant's login, and storing data input according to the work performed in each part 14 and an authentication unit 15 for authenticating a user for login of the person in charge.

The local financial management server 10 is a server of a local financial management system (e-hojo) that is established and actually operated in a local government of the Republic of Korea, and the present invention provides a budget execution situation related to budget formation and budget execution. Since it is characterized by the configuration for providing to the person in charge, the description of the revenue part 11 will be omitted, and only the remaining components will be described.

The authentication unit 15 stores user information for the login of the person in charge, and authenticates the terminal 1 of the person in charge who attempts to log in according to the user information to log on and perform a task. Here, the user information includes not only the ID / password but also the name and department name of the person in charge, so that the user can be connected to a part related to the department among the revenue part 11, the budget part 12, and the accounting part 13 to view the corresponding work. .

The budget part 12 is a part that allows the budget manager to be connected when the user logs in to manage the budget formation. The budget of department name / policy business / unit business / detail business / statistics / calculation basis established by the local government It is configured to enter data related to the budget organized according to the programming system. Here, the input budget is to be assigned and executed according to the budget amount allocated to each department belonging to the local government, it also includes the assigned department name. In addition, the budget part 12 enables the inquiry and verification of the input budget according to the budgeting system of department name / policy project / unit project / detail project / statistics / output basis.

The accounting part 13 is a part which allows the accounting person to be connected at the time of login to manage the execution of the contract and the expenditure. The accounting part 13 is the execution of the contract and the expenditure according to the budgeting input by the budget part 12. It is configured to enter relevant data. In addition, the accounting part 13 makes it possible to inquire and confirm the data related to the entered execution.

The DB 14 is a database of the revenue-related information input through the revenue part 11, the budget arrangement input through the budget part 12 and the execution matters input through the accounting part 13 to be databased. do.

In addition, the DB 14 stores individual data for individual business processing of the local financial management server 10, and provides data suitable for data of each part such as the budget part 12 and the accounting part 13. In other words, the DB 14 stores and provides separate data for each business person to process for financial activities.

The above-mentioned basic budget execution status refers to the execution status of department budgets classified according to the accounting classification (for example, accounting classified into general accounting, special accounting, fund, etc.), and to the statistical tree. The total execution status and the balanced execution budget execution status by department and statistics are classified according to accounting classification.In this way, the accounting is classified according to the accounting nature and purpose of the local government. Because. In addition, it is merely a sum of the execution amount input for each item classified according to the accounting classification in the item of budgeting, and does not greatly affect the processing speed of the local financial management server 10.

In detail, the local financial management server 10 is a server for aggregating and databaseting the input data by inputting data related to revenue, budget, and accounting for each department. Automated data collection for real-time processing and comprehensive judgment of financial status can greatly improve work efficiency, transparency, accountability and risk management.

The local financial management server 10 for this purpose is to determine the processing capacity of the server in building in the local government, the higher the processing capacity of the server is better, but the server construction cost increases, so related to revenue, budget and accounting In order to input and manage data, it is possible to handle traffic generated by each department's access, and to provide the basic budget execution state as described above.

However, the budget execution status to be grasped practically for the financial management of local governments is allocated to each department without accounting division as well as the above-mentioned basic budget execution status aggregated by statistics and departments according to accounting classification. Budget execution status by department, budget tracking status of each department which aggregated the calculation base, which is a sub-categorization system of statistics, by each department, budget budget / current The status of budget execution by department divided by budget / carryover budget, the balanced execution budget to be reported by reporting daily (or occasional) progress, and the current progress of the calculation base assigned to the department, and assigned to the department In real time, such as the budget of self-executed budget.

In addition, in order to grasp the status of budget execution by department, it is necessary in practice to extract and aggregate only budget items for evaluating the performance of departments.

Accordingly, a person in charge of a budget-related task should download the data on the basic budget execution status provided by the local financial management server 10 and aggregate the data into practically necessary data to prepare a report, which is required to prepare such a report. It is estimated that the average time is about 1 hour, and such an aggregate work must be done every day, and even though the local financial management server 10 is established for work efficiency, the amount of work for grasping the budget execution status is not greatly reduced.

The budget execution status to be grasped in the above-mentioned practical case is to extract the budget that can judge the execution performance of the department among all the budgets allocated to each department and executed (the total budget which can be classified according to the accounting classification but not classified). It is necessary to grasp the execution status and to understand the execution status in detail at the basis of the calculation. As a result, the cause of sluggishness can be identified.

However, since the local financial management server 10 divides the progress of each department according to the accounting classification and aggregates and provides only the statistics tree, it could not provide a budget execution status to be grasped in practice. In addition, the budget (for example, department expenses) that is self-executed within the department is not expensed by the accounting department. In the end, it became difficult to figure out the actual execution budget of the department.

In order to obtain the status of budget execution necessary for this practice, the budget for extracting the department's execution performance is extracted, and the budgeting based on the calculation basis of the extracted budget is matched with the budget execution, and collected according to the budget amount, the corresponding budget, the carryover budget, and the balanced execution budget. In addition, it is difficult for the server to handle the traffic in real time, and it is difficult for the server to handle the traffic in real time, and the revenue part (11) and the budget part. Problems that interfere with the processing of the work through the 12 and the accounting part 13 may occur.

The solution of this problem is achieved by the budget execution management server 20.

The budget execution management server 20 is a server providing a budget execution status practically necessary without affecting the processing speed of the local financial management server 10, the user authentication unit 21, the basic data management unit 22 ), A matching management unit 23, a current state management unit 24, and a current state DB 25.

The user authentication unit 21 is a component for granting access authority by single sign-on (SSO), and a person who logs in to the local financial management server 10 executes the budget without a separate login procedure. Allows the user to log in to the management server 20. To this end, the user authentication unit 21 receives the login session information of the terminal logged into the local financial management server 10, extracts user information and creates a session, thereby logging in to the local financial management server 10. One terminal is maintained in the same authentication state to allow access. Single sign on (SSO) is a well-known technique and it is obvious that various modifications are possible. The user authentication unit 21, even if the local financial management server 10 and the budget execution management server 20 in accordance with the present invention to be connected to both servers with a single login, providing the effect of logging in to a single site do.

The basic data management unit 22 receives and requests the budget information input through the budget part 12 and the execution matters input through the accounting part 13 from the local financial management server 10 at predetermined times. It is stored in the matching DB 25 and if there is previously stored data is updated.

Here, since the data stored in the DB 14 of the local financial management server 10 is the data updated through the budget part 12 and the accounting part 13, by accessing the budget execution management server 20 Do not change. To this end, even if the local financial management server 10 requests the information transmission from the basic data management unit 22, by granting only read access to the data of the DB 14, the management server 10 DB 14 To ensure its integrity.

In addition, since all the information stored in the DB 14 of the local financial management server 10 has a problem of speed degradation, the local financial management server 10 is budget execution management among the data stored in the DB (14) Only necessary data items are set in advance in the server 20 to be generated as a view list and read-accessed. This can be achieved by optimizing the structured query language (SQL), which is a query language for the database.

On the other hand, if a request for budgeting and execution is received and delivered at a very short time, the local financial management server 10 may reduce its inherent processing capacity, which may interfere with the work through the budget part 12 and the accounting part 13. As such, the preset time may be determined in advance of the time point at which the budget execution status needs to be determined by referring to the financial management work flow of the local government. Even so, since there is a possibility that the processing speed of the local financial management server 10 may be lowered, the local financial management server 10 monitors the server load situation and monitors the load when the budget execution management server 20 is connected. Store and manage so that the server administrator can inquire. Accordingly, by adjusting the predetermined time can be used as the basis material so as not to lower the processing speed of the local financial management server (10).

The matching management unit 23 extracts a budget for grasping the execution performance of the department from the data stored by the basic data management unit 22, and the matching data obtained by mutually matching the budget formation and the budget execution for the calculation basis of the extracted budget. Create That is, matching data of each calculation basis for generating execution status for each calculation basis, which is the lowest unit of the budgeting system, is generated. The matching data at this time includes the budget amount, the cause acting amount, the execution amount, the execution balance, the execution rate, and the department name, the calculation basis name (bookkeeping name), and the department name / policy business / unit business / It is the basic data to generate the following budget execution status data, including the name of the sub-project / statistics, whether it was selected as balanced execution, and the division name in the accounting segment.

The status management unit 24 generates the budget execution status data for collecting and aggregating the matching data for each calculation basis according to the classification system to query the budget execution status.

The classification system uses the budget items such as budget, current budget, carryover budget, and balanced execution budget as the upper classification system and each department as the lower classification system.

The budget execution status data is the data that collects the budget that is the target of budget execution management even though the accounting classification is different, and it is the data that collects the budget amount, the cause acting amount, the execution amount, the execution balance and the execution rate according to the classification system according to the classification system. Therefore, it includes the budget execution status of the budget allocated to each division of the lower classification by the upper classification according to the classification system, and also includes the budget execution status for each calculation basis allocated to each division.

According to an embodiment of the present invention, the budget execution status data for the balanced execution budget in the higher classification system includes a target achievement rate indicating a ratio of the balance execution target amount and the balance execution target amount to the execution amount, which is the amount selected as the target amount of the balance execution. In addition, the amount of cause and execution amount includes data comparing the previous day and the day, including the data of the previous day and the day, and also includes data for providing daily and monthly progress charts. In addition, the budget execution status data for the balanced execution budget also includes data for providing a chart of execution rates collected by statistics. That is, in practice, since the balance execution should be grasped every day, in the embodiment of the present invention, the balance execution status can be intuitively and accurately recognized.

An inquiry screen of the budget execution status data will be described with reference to FIGS. 2 to 12.

The status DB 25 stores data by the basic data manager 22, the matching manager 23, and the status manager 24 to finally store the budget execution status data, and to the user authentication unit 21. The budget execution status data is provided to an authenticated terminal.

On the other hand, according to an embodiment of the present invention, the budget execution management server 20 is not provided by the local financial management server 10 or provide the necessary information in practice at a glance quickly and accurately the status of budget execution of each department and As it is to understand in detail, we understand server utilization. That is, the budget execution management server 20 manages the IP address of the logged-in terminal 1, the residence time of the logged-on state, and the history of the page view, so as to determine which department uses a lot. The utilization utilized in this way may be used as data for deriving improvements of the budget execution management server 20.

Hereinafter, referring to FIGS. 2 to 12 illustrating a screen configuration provided to the terminal 1 when the terminal 1 of the person in charge is connected to the budget execution management server 20.

2 is a main screen displayed on the screen of the person in charge terminal 1 when the budget execution management server 20 is connected.

Referring to FIG. 2, the main menu 100 includes a 'budget execution' which provides the execution status of the budget amount, 'the execution of the budget' that provides the execution status of the budget, and 'the provision of the execution status of the carryover budget'. It includes the menu of carryover project, 'balance execution', which provides the execution status of the balanced execution budget, and 'execution status by department', which provides the total execution status of each department. Graph (101) showing the target amount, the current execution amount and execution rate of the balanced execution budget, and displaying the execution rate at the same time (102), the total amount of the carryover budget, the cause acting amount and the execution amount, and the carryover of the carryover budget. Also outputs a graph (103) showing the aggregated interest rate and the continuing cost, and a graph (104) showing the total amount of the budgeted amount, the cause acting amount, and the execution amount, which is the sum of the budget and the carryover budget. Allowing the total budget into the budget item acid present value, the art budget, budget execution and balance the budget in February recognizable at a glance.

Here, the balanced execution budget outputs the execution rate as a graph because the execution rate is the main concern for the person in charge.

FIG. 3 is an initial screen when the budget budget execution is selected in the main screen of FIG. 2.

Referring to FIG. 3, the execution status of the budget balance, which is the sum of the budget and the carry-over budget, is output to the department's budget execution status table 203, and a message 201 indicating that the reserve and SOE special accounts have been excluded. It can be seen that the amount printed in the execution status table 203 for each department includes the relevant budget (general accounting, special accounting, fund) and the carryover budget (specified, accident, continuing expenses), except for reserve and SOE special accounts. To be. The budget execution status by department is the budget amount, expenditure status (caused act amount, execution amount, balance) and execution rate by department. In addition, a brief description of the composition of the budget balance and a statement indicating that the execution rate calculation method is based on the amount of execution and the amount of execution are based on the execution amount. 204) is also output.

Here, according to the message 201 and the guidance 204, it can be seen that the budget amount to be the budget execution management target to determine the budget execution performance of the department to calculate the budget amount by department.

Previously, since the graph 104 outputting the execution status of the budget amount in the main screen shown in FIG. 2 includes the reserve cost and the SOE special accounting, in FIG. 3, the budget execution status of the budget amount for each department excluding the reserve cost and the SOE special accounting is shown. The total amount (budget amount), the cause acting amount, and the execution amount which are aggregated are shown by the graph 202.

Meanwhile, referring to FIG. 3, 'general accounting + special accounting', which provides the execution status of the budget combined with general accounting and special accounting, 'owner's own business execution rate', which provides the execution status by separating only local businesses' own projects. In addition, there is also a menu (200) of 'budget balance ratio', which provides the subsidiary project progress rate, which provides the execution current by separating only the subsidiary project, and the detailed composition ratio of the budget amount. You can show the current status in detail. Of course, the menu 200 also includes a menu of 'general execution rate' which is a menu showing the screen of FIG.

FIG. 4 is a screen when the corresponding budget execution is selected in the main screen of FIG. 2.

Referring to FIG. 4, a table 302 outputs the budget execution status (budget amount, cause acting amount, execution amount, execution balance, execution rate) of the corresponding budget (general accounting, special accounting, fund) by department, in this table. It also outputs a message (301) indicating that the amount is the amount excluding the reserve and SOE special accounts, and the total (budget amount), the total amount of the relevant budget, the cause acting and the execution amount, except for the reserve and SOE special accounts. The activity amount and the execution amount are output to the graph 302. Here too, the guidance 304 for the structure of the budget and the execution rate calculation method is output.

In addition, the menu 300 for showing the detailed budget for each department by the constituent items of the budget is also output, the menu 300 at this time 'general accounting + special accounting', which provides the general account and special accounting execution status, 'Fund execution rate' providing the execution status of the fund, 'own project execution rate' providing the execution status of the own project, 'subsidiary project execution rate' providing the execution status of the auxiliary project, and 'expenditure providing the composition ratio of the budget' 'Current Composition Ratio' menu. Of course, the menu 300 also includes a menu of 'general execution rate', which is a menu showing the screen of FIG.

FIG. 5 is a screen when 'carry forward business execution' is selected from the main screen of FIG. 2.

Referring to FIG. 5, the budget execution status (budget amount, cause acting amount, execution amount, execution balance, execution rate) of each department of the carryover budget is output to the table 402, and the amount output to the table 402 indicates the special account of the SOE. A message 403 indicating that the amount is excluded is also output. Then, the total amount (budget amount), the cause acting amount, and the execution amount of the sum of the budget execution statuses of the carry forward budgets of each department excluding the SOE special accounting are output as a graph 401.

Referring to FIG. 5, a menu 400 of 'total execution rate', 'expected carry forward execution rate', 'accident carry forward budget execution rate', and 'continued non carry forward budget execution rate' is selected. If you select the remaining menus, you can see the budget execution status by department for explicit carryover, accident carryover, and continuous carryover according to the menu.

As shown in FIG. 3 to FIG. 5, after the budget execution status, the current budget, and the budget execution status for the carry-over budget, the department is selected and the statistics of the department are as shown in FIG. 10 or 12. Detailed budget execution status can be seen for the tree and book names.

FIG. 6 is a screen when 'balance execution' is selected on the main screen of FIG. 2.

Referring to FIG. 6, there is a menu 500 of 'balance execution status', 'balance execution status by department' and 'balance execution status (all day)'. 6 is also an initial screen and a screen showing when selecting the 'balance execution status' in the menu 500. According to this, the budget execution status of the balanced execution budget by department is shown as a table (503), and the budget, the balance execution target, the cause acting amount, and the execution amount, which are the aggregated budget execution status of the balanced execution budget of each department, are shown in the graph (501). The execution rate according to the aggregation result is shown in a separate graph 502. Here, the budget execution status of the balanced execution budget by department includes the budget amount, the cause acting amount, the execution amount, the execution balance and the execution rate, and also the achievement rate for the balanced execution goal amount determined at the time of budgeting, including the balance execution goal and the goal achievement rate. Also shows. Selecting a department in the table 503 shows detailed budget execution status up to statistics for each business as shown in FIG. 8.

FIG. 7 is an initial screen when the 'balance execution status of each department' is selected on the 'balance execution' screen of FIG.

Referring to FIG. 7, the department hierarchy diagram 504 of the local government is shown, and when the department is selected in the hierarchy diagram 504, the budget execution status for the balanced execution of the selected department can be viewed in detail.

FIG. 8 is a screen when the department name “strategic planning room” is selected in the department hierarchy 504 after selecting the “balance execution status of each department” of FIG. 7.

Referring to FIG. 8, the budget execution status is shown in detail by statistics for each project (business classified into a system of department name / policy business / unit business / detailed business) for the balanced execution of the department name 'Strategic Planning Office'. The budget execution status of balanced execution shows the budget amount, balance execution goal amount, achievement rate, causal action amount, execution amount, execution balance and execution rate by categorizing the statistics of each project in the department 'Strategic Planning Office'.

In addition, the budget, balance execution target amount, causal behavior amount, and execution amount, which are the aggregates of the budget execution status of each project, are output as a graph 507, and a separate graph 506 is calculated by calculating the balance execution execution rate of the department according to the count. Will output

9 is a screen when the 'balance execution status (all day)' is selected on the 'balance execution' screen of FIG.

Referring to FIG. 9, as shown in the screen of FIG. 6, the budget execution status of each department of balance execution is output as a table, where both the amount of cause acts on the day and the previous day are shown, and the difference between the day and the day is also shown. The table 508 also shows all the execution amount of the previous day and the difference at this time. Accordingly, the person in charge can easily know how much the amount of the cause and execution amount increased on the day compared to the previous day without any additional calculation, and the progress of the execution situation for the balanced execution budget that should be checked every day is shown in the table of FIG. 508).

FIG. 10 is a screen when 'execution status by detail project' is selected after selecting 'execution status by department' on the main screen of FIG. 2.

In fact, when selecting 'Department execution status by department', the screen showing 'Detail execution status by detailed project' and 'Book execution status' (600) and 'Detail execution status by detailed project' become initial screen and select department. Let's do it. If the department is selected, the budget execution status of the department is shown as shown in FIG. 10 is a budget execution status of the department name 'strategic planning room'.

Referring to FIG. 10, a table 602 shows the budget execution status of statistics by department (department name / policy business / unit business / detail business) of each department according to the budgeting classification system. The department's budget execution status is the budget amount, that is, the budget execution status including the current budget and the carryover budget, and also outputs a guide 603 indicating that the daily expenses delivered to the department are not included in the execution performance. The budget execution status of the department's budget is also calculated and output as a graph (601). Here, the budget execution status of the department's budget is excluding reserves and SOE special accounts.

FIG. 11 is a screen when a 'book execution status' is selected after selecting 'department execution status' on the main screen of FIG. 2.

Referring to FIG. 11, the table shows the budget status (budget number, budget amount), contract status (number of contracts, contract amount, expenditure amount) and execution rate of the budget for each bookkeeping name divided by bookkeeping name (calculation basis). Output to (604). In other words, the bookkeeping name (the basis of output) is a unit that accounts for contracts and expenditures, and it is possible to know how many cases are budgeted for each department, how many are contracted, and how much is calculated as the execution amount after completing the current expenditure. In this case, the department is switched to the screen of FIG. 12.

12 is a screen when the department name 'strategic planning room' is selected on the screen of FIG.

Referring to FIG. 12, the department's budget execution status is shown in detail by division of bookkeeping names (calculation basis). The budget execution status of the department shown here is detailed project name and statistical tree name, bookkeeping name, sub-system of statistics tree, actual contract name, budget set by statistics tree, actual contracted amount for bookkeeping name, expenditure after contract Includes expenditures and the balance of the statistics. In other words, in executing the budget prepared according to the statistics tree in the bookkeeping name, it is possible to see at a glance which bookkeeping name is executed and how much is remaining in the statistics tree.

As described above, the local financial management system for budget execution management according to the present invention comprises a local financial management server 10 and a budget execution management server 20 in constructing a local financial management system for processing budget related tasks. By decentralizing and decentralizing the data, the budgeting and budget execution items are inputted according to the accounting classification and processed. The budget management server 10 provides the status of execution of each budget classified according to the accounting classification. It provides a budget execution management server 20, which is necessary for practically difficult budget execution.

In addition, the local financial management server 10 may be a simple modification that allows the interface of the budget execution management server 20 and manages traffic, and thus does not need to be substantially reconfigured.

In addition, since the budget execution management server 20 collects budgeting and execution matters without burdening the operation of the local financial management server 10, the operation of the local financial management server 10 is also smoothly maintained, By providing the collected information in detail the actual status of budget execution necessary for the financial management of local governments, as illustrated in FIGS. The amount of work can be reduced by the amount of time it takes to minimize administrative waste.

While the present invention has been particularly shown and described with reference to exemplary embodiments thereof, it is to be understood that the invention is not limited to the disclosed exemplary embodiments, . ≪ / RTI > Accordingly, such modifications are deemed to be within the scope of the present invention, and the scope of the present invention should be determined by the following claims.

1: terminal
10: local financial management server
11: revenue part 12: budget part 13: accounting part
14: DB 15: authentication unit
20: budget execution management server
21: user authentication section 22: basic data management section
23: matching management unit 24: status management unit
25: Status DB

Claims (3)

delete delete The budget allocated to each department is organized according to department name / policy project / unit project / detail project / statistics / calculation base system established by local government, and the budget allocated to each department is input through the logged-in budget manager. In the local financial management system for budget execution management that receives the execution of the contract and expenses through the logged-in accounting terminal, and provides the status of budget execution to the logged-in terminal,
An authentication unit 15 for storing the user information for logging in the budgeting terminal and the accounting terminal, and authenticating the terminal of the person in charge according to the user information, and allowing the login; a budget part 12 for inputting the organized budget; ; An accounting part 13 for inputting budget execution matters; Local financial management consisting of; DB (14) to provide a database of the budget part of the budget part and the budget execution matters of the accounting part and classify according to the accounting classification and provide the current status of budget execution for each department up to the statistics tree to the logged-in terminal Server 10; And
Receives session information of the terminal logged into the local financial management server 10 from the local financial management server 10 and permits access of the terminal logged into the local financial management server 10 by performing single authentication (SSO). A user authentication unit 21; A basic data management unit 22 for requesting the DB 14 of the local finance management server 10 to receive the budgeting and budget execution matters at predetermined times; A matching management unit 23 for extracting a budget for determining the execution performance of the department and generating matching data which is data that mutually matches the budget formation and budget execution matters for the calculation basis of the extracted budget; Budget items, budgets, carryover budgets, and balanced execution budgets, which are budget items, are classified into upper classification systems, and each department is classified into lower classification systems. A status management unit 24 for generating budget execution status data for querying the budget execution status of each department for each item of the upper classification system and the budget execution status of the calculation basis for each department; Matching DB 25 for providing the budget execution status data to the terminal authenticated by the user authentication unit 21; Budget execution management server 20 comprising a;
, ≪ / RTI &
The budget execution status data for the balanced execution budget includes the average execution target amount and the target achievement rate, and compares the previous day and the day for the cause acting amount and the execution amount, and the execution rate collected by the daily and monthly progress and statistics. Is the data that provides the chart
The local financial management server 10 grants only read access to the data of the DB 14 when the budget execution management server 20 is connected, but the budget execution management server 20 among the data stored in the DB 14. In order to read only the necessary data in the view list), and to monitor the server load status to store the load when the budget execution management server 20 is connected,
The budget execution management server 20, the local financial management system for budget execution management, characterized in that for storing the history of the IP address, the log-in time of stay and page views of the logged in terminal.

Images