Administrative activity support system, administrative activity support method, and computer program

Abstract

To provide a technology that supports decision-making in administrative activities by providing analysis data.SOLUTION: An administrative activity support system that supports decision-making relating to business planning in administration comprises: a storage unit that stores policies in association with subordinate measures and stores the measures in association with subordinate projects; a reception unit that receives a set of analysis targets selected based on search conditions, and analysis conditions, where the analysis targets are at least one of the policies, the measures and the projects; and an output processing unit that generates analysis data in accordance with the analysis conditions for the analysis targets belonging to the set and outputs an analysis screen on which the analysis data are displayed.SELECTED DRAWING: Figure 4

Description

[Technical Field]

[0001] The present invention relates to an administrative activity support system, an administrative activity support method, and a computer program for performing revenue management in the government. [Background technology]

[0002] Administrative organizations, including local governments, set policy systems such as policies, measures, and administrative projects, and execute administrative projects within the budgets secured for those systems. Policies and projects are evaluated item by item every year, and review meetings are held to determine next year's budget and whether the project will continue in the following year. In this way, information on policies, measures, and projects is used to make decisions in administrative activities.

[0003] Patent Document 1 discloses technology that aims to resolve the problem of local government financial planning being conducted from a macro perspective, while budget assessments for individual administrative projects are conducted from a micro perspective, and that the two are not linked. This technology makes it possible to maintain consistency between individual plans and overall strategies by establishing rules, making the creation of revenue and expenditure plans for individual administrative projects more detailed and computerizing them, and by linking the financial planning of the local government as a whole with the management and evaluation of administrative projects, thereby enabling long-term financial estimates based on project accumulation. [Prior art documents] [Patent documents]

[0004] [Patent Document 1] Japanese Patent Application Laid-Open No. 2005-293321 Summary of the Invention [Problem to be solved by the invention]

[0005] When compiling the budget for the next fiscal year, the budget is compiled taking into account the performance of the previous fiscal year, etc., but at that time, it was not possible to tally and manage the revenue that serves as the source of funds for the budget by item, etc. Furthermore, from another perspective, it has not been easy to obtain information relating to multiple items regarding the status of administrative work, projects, etc. that are of particular interest.

[0006] In view of the above-mentioned problems, an object of the present invention is to provide a novel technology for performing revenue management. [Means for solving the problem]

[0007] [1] An administrative activity support system for revenue management, Registering the amount of general revenue and general revenue items for each of multiple general revenue sources that are revenues in a certain execution year; For each of a plurality of specific revenue sources that are revenues in a certain fiscal year, the amount of specific revenue source revenue and the specific revenue source revenue items are registered; An administrative activity support system that aggregates the general revenue amount for general revenue sources and the specific revenue amount for specific revenue sources that meet search criteria in a certain execution year and displays the respective aggregation results. [2] Accepts the specification of revenue items to be displayed, Based on the specified revenue item, a list of general revenue sources and specific revenue sources that meet the search criteria is displayed. [1] The administrative activity support system described in [1]. [3] Display a list of general and specific revenue sources that meet the search criteria alongside the aggregated results. [1] - [2] The administrative activity support system according to any one of the above. [4] Specific funds are registered at units below the business unit, while general funds are registered at the budget item system level. An administrative activity support system according to any one of [1] to [3]. [5] The general revenue items and the specific revenue items include revenue items, The general revenue amount and / or the specific revenue amount are calculated based on the revenue items. [1] - [6] An administrative activity support system according to any one of the above. [6] The general revenue amount and the general revenue items, as well as the specific revenue amount and the specific revenue items, shall be registered for each department in charge. The general revenue amount and / or the specific revenue amount are compiled based on the department in charge. [1] - [5] An administrative activity support system according to any one of the above. [7] The general revenue amount and / or the specific revenue amount are aggregated based on the budget type. [1] - [6] An administrative activity support system according to any one of the above. [8] Furthermore, the general revenue amount of the general revenue and the specific revenue amount of the specific revenue for the previous fiscal year of the execution year are totaled, and the respective total results for the previous fiscal year are displayed, and the difference between the total results for the execution year is displayed. [1] - [7] An administrative activity support system according to any one of the above. [9] General and specific revenue sources are registered in association with budget types. Based on the budget type, the revenue request amount and the revenue assessment amount are compiled for general revenue sources and / or specific revenue sources. displaying the tabulated result of the revenue demand amount, the tabulated result of the revenue assessment amount, the difference between the revenue demand amount and the revenue assessment amount, and one or more of the composition ratio or assessment rate; [1] - [8] An administrative activity support system according to any one of the above.

[10] When registering a business in administrative activities, the business is registered in association with the person in charge of the business; Register the labor costs and business utilization rate for one or more personnel, Calculating the labor costs of each person in the business based on the labor costs and the operating rate; [1] - [9] An administrative activity support system according to any one of the above.

[11] In the aggregation of the labor costs, the labor costs of the individual personnel in the business are aggregated to aggregate the labor costs related to the business.

[10] The administrative activity support system described in

[10] .

[12] When registering a business in administrative activities, the business is registered by linking it to the person in charge of the business, Once the person in charge is specified, a search is performed for the business that the person in charge was in charge of. Based on the search results, a list of businesses handled by the person in charge is displayed. [1] -

[11] The administrative activity support system according to any one of the above.

[13] Individual expenditure items are registered in association with the breakdown of financial resources, and furthermore, are registered in association with the corresponding individual expenditure items for one or more years, By comparing individual expenditure items registered in association with multiple fiscal years, we search for individual expenditure items that may not be appropriate for review due to sudden changes in general fund revenues over time. [1] -

[12] The administrative activity support system according to any one of the above.

[14] Individual expenditure accounts are registered in association with the breakdown of financial resources and, further, in association with the corresponding individual expenditure items for one or more years; By comparing individual expenditure items registered in association with multiple fiscal years, we search for individual expenditure items whose general fund revenues have not changed much over the years and for which revision may not be appropriate. [1] -

[13] The administrative activity support system according to any one of the above.

[15] For each individual expense item searched, the amount of appropriated general revenue or the amount of general and specific revenue for two or more fiscal years is displayed so that it can be compared over time.

[13] or

[14] , the administrative activity support system.

[16] A method for supporting administrative activities for conducting revenue management, comprising: The computer registers the amount of general fund revenue and the general fund revenue items for each of a plurality of general fund revenues that are revenues in a certain execution year, For each of a plurality of specific revenue sources that are revenues in a certain fiscal year, the amount of specific revenue source revenue and the specific revenue source revenue items are registered; An administrative activity support method that aggregates the general revenue amount of general revenue and the specific revenue amount of specific revenue that meet search conditions in a certain execution year, and displays each of the aggregated results.

[17] A computer program that causes the computer to execute the administrative activity support method described in

[16] .

[0008] The invention of [1] makes it possible to aggregate the amount of revenue registered for general revenue sources and specific revenue sources, thereby supporting the management of revenue in administrative activities.

[0009] The invention of [2] makes it possible to display a list of general and specific revenue sources by revenue item, thereby assisting in the management of revenue in administrative activities.

[0010] The invention of [3] not only tallying up revenue amounts but also displaying a list of financial resources included in the tally can assist in the management of revenues in administrative activities.

[0011] The invention in [4] makes it possible to register data according to the nature of specific revenue sources and general revenue sources, thereby supporting the management of revenue in administrative activities.

[0012] The invention related to [5] makes it possible to aggregate specific and general financial resources based on revenue items, thereby supporting the management of revenue in administrative activities.

[0013] The invention of [6] makes it possible to compile data for each organization responsible for the revenue, thereby supporting the management of revenue in administrative activities.

[0014] The invention in [7] makes it possible to aggregate general and specific revenue sources by budget type, thereby supporting revenue management in administrative activities.

[0015] The invention of [8] makes it possible to display the total revenue amount for the previous year and the difference, thereby assisting in the management of revenue in administrative activities.

[0016] The invention according to [9] makes it possible to use the budget preparation status to manage revenue in association with the state of budget preparation.

[0017] The invention in

[10] makes it possible to manage the personnel costs of individual staff for each business.

[0018] The invention in

[11] makes it possible to manage personnel costs for each business.

[0019] The invention of

[12] makes it possible to easily provide the history of the business that each person in charge has been in charge of.

[0020]

[13] The invention of the present invention makes it possible to search for individual expenditure items for which general revenues have changed suddenly based on the appropriated financial resources, and to search for candidates for individual expenditure items that continue to exist without any inertia.

[0021] The invention according to

[14] makes it possible to search for candidates for individual expenditure items that have continued inertially and have little change over the years in the amount of general revenue based on the appropriated financial resources.

[0022] The invention of

[15] makes it possible to search for individual expenditure items and check financial resources (revenue amounts) in units of individual expenditure items that are more detailed than projects. [Effects of the Invention]

[0023] The present invention provides a novel technique for conducting revenue management. [Brief explanation of the drawings]

[0024] [Figure 1] Block diagram of the system of this embodiment [Figure 2] Hardware configuration diagram of this embodiment [Figure 3] Tree structure of the policy system of this embodiment [Figure 4] Display example of financial resource registration screen of this embodiment [Figure 5] Display example of the tally result display screen of this embodiment [Figure 6] Image of the breakdown of financial resources in this embodiment DETAILED DESCRIPTION OF THE INVENTION

[0025] The following describes an administrative activity support system, an administrative activity support method, and an administrative activity support program according to an embodiment of the present invention, with reference to the accompanying drawings. Note that the embodiment shown below is an example of the present invention, and the present invention is not limited to the following embodiment, and various configurations can be adopted.

[0026] <Embodiment 1> In this embodiment, the configuration, operation, etc. of an administrative activity support system and an administrative activity support device are described. However, an administrative activity support method, a computer program, and a program recording medium on which the program is recorded, each having a similar configuration, also achieve the same effects. For example, by using a program recording medium, the program can be installed on a computer. The series of processes according to this embodiment described below are provided as a computer-executable program, and can be provided via a non-transitory computer-readable recording medium such as a CD-ROM or a flexible disk, or even via a communication line.

[0027] <Terminology> An administrative organization is an organization that manages administration, including government agencies, ministries, and public organizations such as national and local governments, and in this embodiment, a local government is used as an example. The administrative activity support system according to the present invention is used in administrative organizations to support decision-making in administrative activities.

[0028] <Outline of administrative activities> Here is an example of the flow of administrative activities in a local government. Administrative activities are carried out in succession on a fiscal year basis through stages (topics) such as the budget preparation stage, budget execution stage, and administrative evaluation stage. At the budget preparation stage, the implementation details of the policy system are planned, including deciding on the administrative projects to be implemented in the next execution year, and the budget is compiled after budget requests, assessments, internal announcements, and resolutions are made for the planned policy system. At the budget execution stage, the compiled budget is used to implement the policy system, including administrative projects. At the administrative evaluation stage, the performance of the implemented policy system is evaluated.

[0029] A policy system is a system of issues divided into three layers: policy, measures, and administrative projects. In this embodiment, measures are assumed to include multiple layers (two layers) of divisions, including measures and their subordinate measures (referred to as sub-measures), and an example is given of a case where administrative projects are managed using an issue system divided into four layers: policy, measures, sub-measures, and administrative projects, as shown in Figure 3. For example, the issue system may be divided into three or five or more layers, and administrative projects may be managed. Furthermore, policies and / or administrative projects may include divisions at two or more levels. A policy is a large set of administrative activities aimed at realizing basic guidelines for addressing specific administrative issues, and indicates the direction and objectives of urban development in the established administrative division (city, ward, town, village, etc.). A policy is a set of administrative activities based on the basic principles of a policy, with the aim of realizing a specific policy, and indicates the measures and countermeasures for realizing the policy. In addition, detailed measures are further sub-divided into the measures and countermeasures for each policy. Administrative projects are administrative tasks and projects that are individual administrative means for realizing specific policies in policies (sub-policies). Administrative projects are implemented by each bureau within an administrative division based on its budget.

[0030] <Outline of administrative activities> Here is an example of the flow of administrative activities in a local government. Administrative activities are carried out in succession on a fiscal year basis through stages (topics) such as the budget preparation stage, budget execution stage, and administrative evaluation stage. At the budget preparation stage, the implementation details of the policy system are planned, including deciding on the administrative projects to be implemented in the next execution year, and the budget is compiled after budget requests, assessments, internal announcements, and resolutions are made for the planned policy system. At the budget execution stage, the compiled budget is used to implement the policy system, including administrative projects. At the administrative evaluation stage, the performance of the implemented policy system is evaluated.

[0031] <System configuration> 1 shows a system configuration diagram of an administrative activity support system 1. The administrative activity support system 1 comprises an administrative activity support device 2, a user terminal 3, and a database DB, and each component is connected to a communication network NW. For example, the communication network NW includes a comprehensive administrative network (LGWAN: Local Government Wide Area Network), and the administrative activity support device 2 and the database DB, and the administrative activity support device 2 and the user terminal 3 are connected via the comprehensive administrative network.

[0032] The administrative activity support system 1 (administrative activity support device 2) provides a platform for operating and managing administrative activities related to administrative business. The administrative activity support device 2 includes, as functional components, a registration unit 21, a search unit 22, a counting unit 23, and a display processing unit 24.

[0033] The user terminal 3 is a terminal device used by a user belonging to an administrative organization, etc. A plurality of user terminals 3 are installed at least within the administrative organization.

[0034] In this embodiment, users include special officials (such as chiefs) within administrative organizations, users of the Finance Division and other secretariat departments, section chiefs, department heads, civil engineering departments (bureaus and sections), agriculture, forestry and fisheries departments (bureaus and sections), and users and supervisors of original bureaus and original sections (section chiefs, department heads, etc.). For example, original section users perform tasks such as creating project forms such as business plans, creating budget requests, executing budgets, and creating administrative evaluation reports. Cabinet Secretariat users perform tasks such as requesting the creation of budget requests from original department users and evaluating the budget requests. Section chiefs, department heads, and special officials perform tasks such as checking the deliverables submitted by users, selecting and prioritizing key projects based on plans, and assessing budget requests approved by Finance Department users. The Administrative Activity Support System assigns each user specific operating authority and controls the permission and restriction of specific functions according to the operating authority.

[0035] <Hardware configuration> FIG. 2(a) shows a hardware configuration diagram of the administrative activity support device 2. The administrative activity support device 2 includes, as its hardware configuration, a control unit 201, a storage unit 202, and a communication unit 203. In this embodiment, the administrative activity support device 2 can be a computer device such as a server device or a personal computer. Note that the administrative activity support device 2 may be configured by multiple computer devices, and is not limited to the configuration shown in FIG. 2(a) as long as it can realize the above-described functional components (21-24) as a whole.

[0036] The control unit 201 is configured with one or more processors such as a CPU (Central Processing Unit) or a GPU (Graphics Processing Unit), and controls the overall processing of the administrative activity support device 2 by executing an administrative activity support program, an OS (Operating System), and other applications. The storage unit 202 is a hard disk drive (HDD), a solid state drive (SSD), a flash memory, a random access memory (RAM), or the like, and stores the administrative activity support program and various data. The communication unit 203 controls communication with the communication network NW and realizes data communication with the user terminal 3 and the database DB. The control unit 201 executes the administrative activity support program, causing the computer to function as the administrative activity support device 2 and execute the administrative activity support method.

[0037] In the illustrated example, the database DB is a database server accessible via a communication network NW including LGWAN, etc., but it may also be realized using, for example, the control unit 201 and memory unit 202 that constitute the administrative activity support device 2, or it may be connected to the administrative activity support device 2 via a LAN, etc.

[0038] 2(b) shows a hardware configuration diagram of the user terminal 3. The user terminal 3 includes, as its hardware configuration, a control unit 301, a storage unit 302, a communication unit 303, an input unit 304, and an output unit 305. In this embodiment, the user terminal 3 may be a smartphone, a personal computer, a tablet terminal, or the like.

[0039] The control unit 301 is composed of one or more processors such as a CPU, and controls the overall processing of the user terminal 3 by executing an OS, other applications, etc. The storage unit 302 is composed of an HDD, SSD, flash memory, RAM, etc., and stores a browser application and various data. The communication unit 303 controls communication with the communication network and realizes data communication with at least the administrative activity support system 1. The input unit 304 is an input interface that accepts input operations by the user, and is composed of a microphone, touch panel, mouse, keyboard, etc. The output unit 305 is composed of a display that displays output, etc.

[0040] <Data structure> First, we will explain the data configuration in the administrative activity support system 1 according to this embodiment. The database DB stores an organization master, a user master, a policy / measure master, a budget item master, an administrative indicator master, and administrative business information (administrative data) for each execution year.

[0041] The organizational master stores organizational structure items that represent a tree-structured organizational structure by linking data items as master data for data items related to organizations within or outside the administrative organization. In this embodiment, the organizational master stores organization information and department information as organizational structure items. The organization information stores identification information (organization ID) of the organization and the organization name. The department information stores identification information (department ID) of the department (division, section, office, etc.) in the organization, identification information (organization ID) of the organization to which the department belongs, identification information (department ID) of the higher-level department to which the department belongs, and the department name. The department to which the user belongs, which will be described later, and the department in charge of policies, measures, and administrative projects, etc., are registered in an identifiable manner in various information based on the organizational structure items.

[0042] The user master stores user information within an organization. The user information includes the user's identification information (user ID), name, department (organizational structure item), etc. It may also be possible to define a user group, which is a collection of one or more users. For example, a user group may be defined by user group information including the user group's identification information (user group ID) and the identification information of users belonging to the user group, the group name, etc., or users having a common attribute such as an organizational structure item may be treated as a user group. Users to be included in a predefined user group may be arbitrarily selected, or may be selectable from user groups having a common attribute. A user group is specified by an arbitrarily set group name or an attribute name that represents the characteristics of the group.

[0043] The policy and program master stores policy system items related to policies and programs in a policy system with a tree structure formed by linking data items as master data for data items related to policies and programs. The policy system has a tree structure as shown in FIG. 3. In this embodiment, the policy and program master stores policy information and program information as policy system item information. The policy information / program information includes identification information of the policy / program (policy ID / program ID), policy number / program number, policy name / program name, responsible department (department, section, office, etc.), policy purpose / program purpose, and policy summary / program summary. Furthermore, the program information includes identification information of the corresponding main policy (policy ID).

[0044] The subject master stores master data for data items that indicate the budget subject system, financial statement subject system, and public accounting subject system, including budget subject system items that represent the tree-structured budget subject system by linking data items together, and financial statement subject system items that represent the financial statement subject system. In this embodiment, the budget item master stores budget item information as a budget item system item. The budget item information includes budget item identification information (budget item ID), identification information (budget item ID) of the higher-level budget item to which the budget item belongs, budget item type (either subitem, section, or subsection), and budget item name. The financial statement subject master stores expenditure breakdown purpose information and budget property information as financial statement subject system items. Expenditure breakdown purpose indicates the purpose of expenditure linked to an administrative project, and is used for financial statement statistics in the financial statement topic. Expenditure breakdown purpose information includes identification information of the expenditure breakdown purpose (expenditure breakdown purpose ID), identification information of the higher-level expenditure breakdown purpose to which the expenditure breakdown purpose belongs (expenditure breakdown purpose ID), identification information of the corresponding budget subject (section, item, or item) (budget subject ID), type of expenditure breakdown purpose (in this embodiment, there are three types: major classification, medium classification, and minor classification), and expenditure breakdown purpose name. The budget property indicates the property of the budget set under a section or subsection, and the budget property information includes identification information of the budget property (budget property ID), identification information of the budget item (section or subsection) to which the budget property belongs (budget item ID), or identification information of the higher-level budget property (budget property ID), the type of budget property (in this embodiment, there are four types: major classification, medium classification, minor classification, and detailed classification), and the budget property name.

[0045] The administrative indicator master stores administrative indicator system items that represent a tree-structured administrative indicator system by linking data items as master data for data items that represent the administrative indicator system. Administrative indicators include performance indicators and progress indicators. In this embodiment, the administrative indicator master stores performance indicator information as administrative indicator system items. Performance indicators are further classified into higher-level performance indicators such as KGIs (Key Goal Indicators), which are higher-level indicators, and lower-level performance indicators such as KPIs (Key Performance Indicators), which are lower-level indicators. Performance indicators are linked by identification information or the like that allows corresponding performance indicators to be mutually referenced. In this embodiment, target values ​​are set for the performance indicators as indicators that can be quantified. For example, higher-level performance indicators are set as final target values ​​such as KGIs, and lower-level performance indicators are set as intermediate targets toward achieving the final goal such as KPIs. The performance indicator information includes the identification information of the performance indicator (performance indicator ID), the identification information of the higher-level performance indicator (performance indicator ID), the identification information of the policy, measure, sub-measure, or administrative project to which the performance indicator system item is linked, the evaluation item indicating the content of the performance indicator, the target value of the evaluation item for each execution year (index value: "forecast" for administrative indicators), and the deadline for achieving the administrative indicator. Additionally, in topics such as budget preparation, progress indicator information is stored linked to each task and project. Progress indicators are step-by-step tasks that indicate multiple indicators to be achieved during the execution period set for each task and project, in order to achieve the lower-level performance indicators associated with the task and project. Progress indicator information includes identification information for the progress indicator (progress indicator ID), identification information for the higher-level performance indicator (performance indicator ID), identification information for the task and project for which the progress indicator is set, the execution year, evaluation items indicating the content of the progress indicator, the order of the progress indicators, and the deadline for achieving the progress indicators.

[0046] The evaluation of administrative indicators can be reflected in the evaluation results of the corresponding policy system items. In addition, the performance of lower-level administrative indicators set for administrative projects, etc. can be reflected in the performance of higher-level administrative indicators for policies, etc.

[0047] The performance information indicates the results for each administrative indicator, and is registered for each administrative indicator during the budget execution stage or after the budget execution stage. In this embodiment, the performance information includes performance performance information that indicates the performance results, which are the results of the performance indicators, and progress performance information that indicates the progress results, which are the results of the progress indicators. The performance values ​​included in the performance performance information (the "actual" administrative indicators) are values ​​that can be compared with index values ​​such as KGI and KPI (the "forecast" administrative indicators). Progress performance information includes an achievement / failure flag (the "actual" administrative indicator) indicating the performance of the evaluation item, as well as the achievement date. For example, by aggregating one or more progress indicators set for a certain task or project and their performance (achieved / failed), it is possible to determine the achievement rate of the progress indicators for that task or project in a certain implementation year (e.g., number of achieved progress indicators / (number of achieved progress indicators + number of unachieved progress indicators)). In this case, a weight is set for each progress indicator for each task or project, and the achievement status can be aggregated based on the progress indicator weight and the performance, or the deadline set for each progress indicator can be used as the weight. Note that the "actual" information entered during the implementation period (such as performance information related to administrative indicators and expenditure and income information, described below) is considered to be implementation performance.

[0048] For each task and project, breakdown items are set, which are elements that can be decomposed and are included within the task and project. The breakdown items include items related to budget amounts that are associated with at least sub-items (budget item system items). In this embodiment, one or more sub-projects are linked as breakdown items to each task and project, and each sub-project is associated with a sub-item (budget item system item), and breakdown items that indicate the purpose and destination of budget expenditures, accumulation items that indicate the budget amount, etc., and financial resource breakdowns that indicate the source of funds are linked. One or more accumulation items and one or more financial resource breakdowns are linked to breakdown items that indicate the destination of expenditures. Sub-items (budget item system items) are further linked to breakdown items that indicate the destination of expenditures, and the accumulation items and financial resource breakdowns include items related to the budget for the initial budget and supplementary budget. In the present invention, a breakdown item indicating an expenditure destination, which is uniquely linked to at least three items, namely, a budget item, a settlement item, and a financial resource breakdown, is called an individual expense item. In this embodiment, an individual expense item is linked to a sub-item as a budget item, a budget property as a settlement item, and a general financial resource and / or a specific financial resource as a financial resource breakdown.

[0049] Furthermore, individual tasks, projects, or subprojects are linked to organizational system items, higher-level policy system items, budget item system items, and administrative indicator system items. In this embodiment, a data structure is adopted in which tasks, projects, and budget item system items related to subsections are linked to one or more organizational system items, one or more higher-level policy system items, one or more administrative indicator system items, and budget item system items related to subsections are linked to subprojects. Furthermore, in any topic, labels indicating their contents may be assigned to individual tasks, projects, subprojects, or individual expense items. In this embodiment, a label indicating that a task, project, or subproject is a priority project is assigned to a task, project, or individual expense item, and a label indicating that a project is a mandatory expense or a label indicating an increase or decrease in the budget amount for an ongoing project, etc. is assigned to an individual expense item.

[0050] The business and project information is administrative data as policy system items related to individual business and projects, and is registered for each execution year. In this embodiment, the business and project information includes basic information related to the business and project (basic business information), administrative indicator information, budget information, financial resource information, and expenditure and income information related to the business and project. Basic information on business operations (basic business information) is information on the contents of business operations, and includes basic information (i.e., business operation information) identification information (business operation ID), related administrative data, business operation name, main policies and measures to which the business operation belongs (policy system item), business start year, execution (planned) year, budget category (e.g., initial budget, supplementary budget number, carryover, current total), topic, budget amount of business operation, revenue amount of business operation, budget name, affiliated department / agency (organization system item), responsible department (organization system item), accounting category, business operation status (e.g., "new", "expansion", "reduction", "suspended", "abolished"), budget compilation status (e.g., "request", "adjustment", "assessment", "preliminary notice / resolution"), item (budget item), major classification, medium classification, minor classification of expenditure breakdown purpose (settlement item item), expense classification, budget amount of business operation, etc., as well as optional items such as business operation purpose, business operation summary, It includes various information related to the project, such as the legal basis, related plans and notifications, the current situation and issues, the (planned) year of project completion, remarks, priority issues (administrative indicator system items), etc. Attachments such as PR materials and forms may also be linked to the administrative project information.

[0051] Budget information includes, for example, budget amounts (expenditures) for each topic (e.g., "budget preparation > request," "budget preparation > assessment," "budget preparation > preliminary announcement and resolution"), individual expense item names, and subdivisions of expense items (budget item system items), as well as major, medium, minor, and detailed classifications of budget characteristics (settlement item system items). Budget amounts include the requested amount, which is the budget amount estimated at the "request" stage of budget preparation, the assessed amount, which is the budget amount adjusted as necessary from the requested amount at the "assessment" stage, the preliminary announcement amount, which is the budget amount that has been "preliminarily announced," and in this embodiment, each piece of business and project information is configured to be able to hold the budget amounts for each stage for each individual expense item it has.

[0052] The financial resource information indicates one or more financial resources for each budget amount, including, for example, the name of the financial resource, the amount of revenue appropriated to the budget information, and revenue subdivisions (budget item system items). In this embodiment, the financial resource categories registered are general and specific, and either general or specific financial resources are appropriated to the budget. For example, like the budget amount, the revenue amount is linked to each topic, and can hold, for example, the revenue request amount, which is the amount of revenue estimated in the "request" stage of budget preparation; the revenue assessment amount, which is the amount of revenue adjusted as necessary from the revenue request amount in the "assessment" stage; and the revenue forecast amount, which is the amount of revenue forecasted. In this embodiment, financial resource information is registered in association with the budget information to which the financial resource will be appropriated. If the budget information can reference the budget category to which the financial resource will be appropriated, it does not need to include information about the budget category to which the financial resource will be appropriated. Furthermore, in this embodiment, financial resource information is registered in association with the budget information regarding the budget to which the financial resource will be appropriated. Furthermore, the financial resource information is stored in association with the business operation information relating to the business for which the financial resource is to be spent via the budget information.

[0053] In this embodiment, policy information, program information, and task and project information are registered for each implementation year, and policies and programs implemented over several years, and related tasks and projects in different implementation years that are continued or integrated, etc., are associated with each other. Tasks and projects are further subdivided into a four-level tree structure (tasks > subprojects > individual expenditure items > estimated items) based on their breakdown items, and these breakdown items are also registered for each implementation year. Tasks and projects are structured to include one or more subprojects, and subprojects include one or more individual expenditure items. Task and project information includes basic task information, which is a data item in the task and project layer that represents the content of the task and project; subproject information, which is a data item in the subproject layer that represents the content of the subproject; and individual expenditure item layer data items that represent the content of the individual expenditure items. Individual expenditure items are breakdown items of task and project (subprojects in this embodiment) that indicate the purpose and destination of budget expenditures, and are associated with subsections (budget account system items) and budget amounts by budget type (estimation items). Preferably, the budget amount is also associated with the corresponding revenue amount (breakdown of financial resources). One or more accumulation items are included in individual expense items, and are registered using accumulation item information that indicates the budget amount of the business or higher-level item by accumulating them. The breakdown of financial resources is included as 0 or 1 for each individual expense item, and is registered using breakdown information that indicates the revenue amount of the business or higher-level item.

[0054] The sub-project information includes various information related to the sub-project, such as the identification information of the sub-project (sub-project ID), the identification information of the related administrative information (administrative project ID), the name of the sub-project, an overview of the sub-project, the status of the sub-project (e.g., "new," "expansion," "reduction," "suspended," "cancelled"), and the budget amount of the sub-project.

[0055] Individual expense items indicate expense items required for administrative activities related to the corresponding sub-project, and individual expense item information includes identification information for the individual expense item (individual expense item ID), identification information for the related sub-project (sub-project ID), individual expense item name, budget amount for the individual expense item, individual expense item group label, individual expense item summary, subsections (budget item system item), and properties (budget properties: closing item system item). An accumulation item is a specific individual expense item included in an individual expense item, and accumulation item information includes identification information of the accumulation item (accumulation item ID), identification information of the related individual expense item (individual expense item ID), accumulation item name, budget amount for each topic, planned execution quarter, accumulation item overview, and accumulation basis (formula, etc.). The funding breakdown indicates the funding source for each individual expenditure item, and the funding information includes the identification information of the funding source (funding source ID), the identification information of the related individual expenditure item (individual expenditure item ID), the name of the funding source, the amount of revenue for each topic, the funding allocation rate, the funding classification (general funding, specific funding), item item subsections (budget subject system items), responsible organization / department (organization system items), the basis for allocation, and the reason for allocation.

[0056] In this embodiment, specific revenue sources are registered in association with the business information and / or individual expenditure items of the business to which they are to be spent, since the business and use to which they are to be spent are specified. In addition, general revenue sources are registered in association with the responsible organization and / or department by a person in the responsible organization and / or department, by the person in the responsible organization and / or department, by the person in the responsible organization and / or department.

[0057] In this embodiment, the administrative business is subdivided into a four-level tree structure, and the budget amount for an administrative business is given by the total budget amount of the sub-businesses under the administrative business, the budget amount for a sub-business is given by the total budget amount of the individual expense items under the sub-business, and the budget amount for an individual expense item is given by the total budget amount of the accumulated items under the individual expense items. In other words, when registering administrative business information, the registration unit 21 registers the budget amount for the accumulated items, thereby also registering the budget amounts for the individual expense items, sub-businesses, and administrative business. The same applies to revenue amounts.

[0058] The expenditure and income information is information related to expenditures and / or incomes that is registered as needed for budget execution during the execution period. The expenditure and income information includes identification information for expenditures and incomes (expense and income ID), identification numbers for itemized items of the budget to be executed, names of expenditure and income items, expenditure and income amounts, and sub-items (budget item system items). In this embodiment, individual expenditure items are linked to the expenditure and income information as the budget to be executed, but it is also possible to link estimated items.

[0059] In this embodiment, an example is described in which individual expense items are linked to a budget item system (sub-items) and a settlement item system. Furthermore, the item system may also link individual expense item sub-items to public accounting items, which are public accounting items, on a one-to-one basis. Public accounting items are multi-entry items used in accounting for organizations that provide public services, such as national and local governments, such as financial documents like the general account balance sheet, general account administrative cost statement, net asset change plan, and general account cash flow statement. These items are stored in a database in a systematic manner at one or more levels. Local public accounting refers to a government accounting system established as a unified standard by local governments, which aims to enhance administrative financial transparency, fulfill accountability to residents, and promote financial efficiency and rationalization. The system complements the current cash-basis, single-entry budget and settlement system used by local governments. In the process of tabulation described below, the tabulation unit 23 may search for revenues and / or expenditures that meet the search criteria using these accounting items as the axis, and tabulate the revenue and / or expenditure amounts. Individual expense items linked to public accounting items are used to create financial documents such as balance sheets.

[0060] <Registration Department 21> The registration unit 21 accepts input of administrative data such as organizational information, department information, user information, policy information, measure information, task and project information, budget item information, performance indicator information, and progress indicator information via the user terminal 3, and stores the data in the database DB. The registration unit 21 also accepts registration of financial resource information related to general revenues and specific revenues input via the user terminal 3 and stores the information in the database DB. For example, the registration unit 21 may accept organizational information, department information, user information, policy information, measure information, and budget item information in advance and store them in the database DB, and then accept task and project information during the budget compilation stage and store it in the database DB. During revenue registration, the registration unit 21 accepts financial resource information, including the revenue amount, for general revenues or specific revenues and stores it in the database DB. At this time, the registration unit 21 accepts the financial resource information, along with the designation of the budget or task and project to which the financial resource will be allocated, and registers the budget information in association with the financial resource information. Furthermore, at the execution stage, the registration unit 21 accepts the registration of progress information and expenditure and income information, and at the administrative evaluation or settlement stage, it accepts the registration of outcome information, etc. In this embodiment, the registration unit 21 associates budget items with settlement items and registers them at the budget preparation stage. In this embodiment, general funds are appropriated for individual expenditure items that are not linked to specific funds, so a funding breakdown with a funding source classification of general funds is associated and registered. Furthermore, when public accounting items are linked to individual expenditure items, the public accounting items are also linked and the individual expenditure items are registered at the budget preparation stage.

[0061] <Search section 22> The search unit 22 searches for financial resources (general financial resources and specific financial resources) that meet the search criteria from the data stored in the database DB based on the search criteria received for each axis from the user terminal 3. The search unit 22 then transfers the set of financial resources found through the search to the aggregation unit 23 and the display processing unit 24 as the search results. In this embodiment, the search unit 22 searches for financial resources that meet the criteria based on the breakdown of financial resources linked to individual expense items. In this embodiment, the search unit 22 also searches for the same financial resources from the previous year that are registered in association with the financial resource being searched for (for example, if the search target is the prefectural inhabitant tax per capita current year taxable portion for individual for fiscal year 2024, the search unit 22 also searches for financial resources from the previous year that meet search criteria other than the fiscal year, including the general financial resources and specific financial resources). In order to obtain the financial resources from the previous year of the search target, the search unit 22 may also search for financial resources (general financial resources and specific financial resources) from the year prior to the execution year being searched for that meet search criteria other than the fiscal year. At this time, when the search unit 22 receives search conditions that the fiscal year is 2024 and the tax department is in charge, it may search for financial resources (general financial resources, specific financial resources) for fiscal year 2024 and that are the responsibility of the tax department, and may also search for financial resources for the previous fiscal year (2023) that meet search conditions other than the fiscal year (the person in charge is the tax department). The search unit 22 may also accept registration of search conditions and store the accepted search conditions in the database DB. At this time, the search unit 22 may perform a search based on search conditions previously registered by a user. The search unit 22 may also search for relevant administrative projects based on the search conditions. At this time, the search unit 22 may search for and extract financial resources linked to budgets that meet conditions based on conditions related to expenditures such as budgets.

[0062] <Counting Section 23> The tallying unit 23 tally the general revenue amount and the specific revenue amount for the revenue sources that match the search criteria retrieved based on the search results by the search unit 22. In this embodiment, the tallying unit 23 further calculates the tallying result (total amount) of the total revenue amount including the general revenue amount and the specific revenue amount.

[0063] In this embodiment, the tabulation unit 23 performs tabulation based on various tabulation axes. The tabulation axis is the axis used for tabulation; for example, when the national treasury expenditure category is used as the axis, the amount of revenue is tabulated for each national treasury expenditure category. The national treasury expenditure category is a category related to subsidies and the like paid by the national government to local governments, and in this embodiment, includes categories such as national treasury subsidies, national treasury contributions, and national treasury commissions. Furthermore, the tabulation axes in this embodiment include revenue item, responsible organization / department, and budget type (current total, initial, etc.). The tabulation unit 23 tabulates the amount of revenue based on the tabulation axis, such as by revenue item, by public accounting item, by responsible department, or by budget type.

[0064] The tallying unit 23 also tally the general revenue amount and the specific revenue amount for the previous fiscal year, which satisfy search conditions other than fiscal year, based on the search results for the fiscal year previous to the fiscal year being searched by the search unit 22. At this time, the tallying unit 23 further calculates the difference between the tallying result for the fiscal year being searched and the tallying result for the fiscal year previous to the fiscal year being searched. The tallying unit 23 may also calculate the rate of increase / decrease from the previous fiscal year in the initial and current total revenue amounts.

[0065] <Display processing unit 24> The display processing unit 24 displays various screens, such as a tabulation result display screen, based on the collection of financial resources that satisfy the search conditions retrieved by the search unit 22 and the tabulation results by the tabulation unit 23. The display processing unit 24 also performs display processing of a registration screen for accepting registration of financial resource information for general financial resources and specific financial resources.

[0066] <Screen display example> An example of a screen display that is processed by the display processing unit 24 and displayed on the user terminal 3 will be described below with reference to FIGS.

[0067] Figure 4 explains the registration screen for information on financial resources such as revenue amounts appropriated to a budget. The registration screen shown in Figure 4 is a financial resource registration screen for registering general financial resources, but a similar screen display may also be displayed for specific financial resources, and financial resource information such as specific financial resource revenue amounts may be registered. In addition, the financial resource information to be registered may be registered in association with budget information on the appropriated budget.

[0068] 4(a) is a screen display example of the financial resource registration screen W1, which is a screen for registering financial resource information. The financial resource registration screen W1 shown in FIG. 4(a) is a screen for accepting the registration of general financial resources, which is displayed on the user terminal 3 after being processed for display by the display processing unit 24.

[0069] The financial resource registration screen W1 in this embodiment is a screen that can accept the registration of financial resource information, such as financial resource name, execution year, budget type (current budget / initial budget), revenue item (sub-item section (budget item system item)), responsible department (affiliated department / bureau / agency, responsible section / office), and revenue request amount, which is the amount of revenue estimated at the "request" stage as the amount of revenue to be allocated to the budget information. The financial resource registration screen W1 in this embodiment is configured to allow the name of the financial resource to be registered to be selected in a pull-down format from financial resource names registered in advance in the database DB, but it may also be configured to accept the registration of financial resource names by inputting them by the user. The registration unit 21 accepts the registration of financial resource information entered via the financial resource registration screen W1 displayed on the user terminal 3 and stores it in the database DB. One or more individual expense items are linked to the financial resource registered here.

[0070] The financial resources registration screen W1 shown in Figure 4(a) is a screen display for registering general financial resources. General financial resources are financial resources for which the use has not been determined, so registration is accepted on a screen such as that shown in Figure 4, but specific financial resources are financial resources for which the use has been determined, so in addition to the items shown on the financial resources registration screen W1 shown in Figure 4, detailed information is also accepted for registration. In this embodiment, the registration unit 21 accepts detailed information such as individual expense items, reasons for responsibility, and grounds for allocation in addition to the items on the financial resources registration screen W1 shown in Figure 4, via a summary field displayed on the screen for accepting registration of specific financial resources.

[0071] The registration unit 21 also accepts registration of the type of budget (budget type) to which the revenue is allocated in the budget type field via the financial resource registration screen W1. When specific financial resources and general financial resources are registered via a screen with a similar configuration as shown in Figure 5, the financial resource registration screen W1 may also accept registration of financial resource classification (general financial resources, specific financial resources).

[0072] The screen shown in Figure 4(a) is a screen for accepting the registration of revenue up to the "request" stage. The revenue edit / detail screen W2 shown in Figure 4(b) is a screen that can accept the registration of not only the revenue at the "request" stage (requested revenue amount), but also the revenue assessment amount, which is the revenue amount adjusted as necessary from the requested revenue amount at the "assessment" stage, and the "informal" revenue amount, which is the "informal" revenue amount. The revenue edit / detail screen W2 can accept changes to the registered revenue.

[0073] FIG. 5 is an example of a screen display of a tally result display screen W3 for displaying the tally results and financial resource information that meets the search criteria. The tally result display screen W3 includes a search criteria input section W31, a tally result display section W32, and an income list display section W33. In this embodiment, the display processing section 24 performs display processing based on data stored in the database DB, such as financial resource information related to financial resources that meet the search criteria searched by the search section 22, and displays the tally result display screen W3 as shown in FIG. 5. The search criteria input section W31 may be configured to allow conditions for each item to be selected by pull-down selection, or may be configured to allow conditions to be selected from a cascading list in which selecting a category allows the selection of conditions at lower levels. Keywords may also be entered and used as search criteria.

[0074] The search unit 22 searches the database DB for financial resource information that matches the search criteria entered in the search criteria input unit W31, and tallies the revenue amounts of the extracted financial resources. The display processing unit 24 displays the tallied results on the tallied result display unit W32 based on the financial resource information that matches the search criteria extracted by the search unit 22 and the tallied results, and displays information on financial resources that match the search criteria on the revenue list display unit W33.

[0075] The search condition input section W31 is a screen display for entering search conditions. The financial resources that match the search conditions to be aggregated are specified by searching data items using search conditions such as the execution year, budget type (initial, current total), budget preparation stage (request / assessment / preliminary announcement / decision), accounting classification (general account, special account, general account and special account (total)), or any keyword. Although not shown in FIG. 5, other search conditions may include the department responsible for the breakdown of financial resources (organizational system item), revenue item (item item subsection (budget item system item)), etc. Furthermore, the aggregation unit 23 may use some or all of the search conditions entered in the search condition input section W31 as aggregation axes for aggregation.

[0076] The tally result display unit W32 is a screen display that displays the tally results of the revenue amounts of financial resources that meet the search criteria extracted by the search unit 22. In this embodiment, for financial resources that meet the search criteria extracted by the search unit 22, it displays the total amount, which is the sum of the tally results of the specific financial resources and the general financial resources, the tally results of the revenue amounts of the specific financial resources, and the tally results of the revenue amounts of the general financial resources. In this embodiment, the search unit 22 also searches for financial resources from the year prior to the year being searched, and the tally unit 23 tally the revenue amounts. At this time, the tally unit 23 tallys the revenue amounts for each budget type (in this embodiment, initial and current totals). The display processing unit 24 displays the tally results of the initial revenue amounts for the previous year and the current total revenue amounts for the previous year for each budget type (initial and current totals) for financial resources that meet the search criteria for the previous year. The tabulation result display unit W32 shown in FIG. 5 further displays, for each budget type, the difference between the tabulation result of the revenue amount for the searched fiscal year and the tabulation result of the revenue amount for the previous fiscal year. The tabulation unit 23 calculates the difference between the tabulation result of the revenue amount for the searched fiscal year and the tabulation result of the revenue amount for the previous fiscal year for each budget type of the budget to which it is allocated, for each of the designated revenue, general revenue, and total amount (total of designated revenue and general revenue). Furthermore, if the tabulation unit 23 calculates the rate of increase / decrease of the initial and current total revenue amounts from the previous fiscal year, the display processing unit 24 may display the tabulation result display screen W3 that displays the rate of increase / decrease instead of the difference.

[0077] 5 shows an example of the display of the tally results when the initial budget is selected as the budget type, and displays the tally results of the revenue amounts for the previous fiscal year along with the amount of earmarked revenue and the amount of general revenue, but the items that are tallyed along with the amount of general revenue and the amount of earmarked revenue differ depending on the selected budget type. In this embodiment, when the supplementary budget is selected as the budget type, the tally results of the amount of earmarked revenue and the amount of general revenue before the supplementary budget, and the amount of earmarked revenue and the amount of general revenue after the supplementary budget are displayed in the fields that display the initial and current revenue amounts for the previous fiscal year.

[0078] The revenue list display unit W33 is a list that displays information about financial resources that meet the search criteria retrieved by the search unit 22. The revenue list display unit W33 displays the results of the total revenue amounts for the financial resources that meet the search criteria in the total result display unit W32. In this embodiment, the revenue list display unit W33 displays in list form the execution year, accounting category (general account, special account, total amount (total) of general account and special account), budget type (initial, current total), financial resource category (general revenue, specific revenue), financial resource name, revenue item, responsible department, revenue amount, and specific financial resource amount for the financial resources that meet the search criteria (general revenue, specific revenue). The display processing unit 24 displays the revenue list display unit W33 as shown in FIG. 5 based on the set of financial resources retrieved by the search unit 22 and the financial resource information related to the retrieved financial resources. Furthermore, in this embodiment, the financial resources displayed in the revenue list display unit W33 differ for each user depending on the organization and / or department to which the user belongs. In this embodiment, specific financial resources are displayed to users who belong to the organization and / or department in charge of or related to the allocated project and to users of the organization and / or department for which the allocated project is set to be public. General financial resources are displayed to users who belong to the organization and / or department related to or in charge of the financial resource and to users for whom the financial resource is set to be public. Furthermore, information on any financial resource is displayed to users who belong to an organization that is a privileged organization for the project, such as the finance department.

[0079] At this time, the display processing unit 24 may display the revenue list display unit W33 by changing the number of items to be displayed and the display order of the financial resources that satisfy the search criteria extracted by the search unit 22 based on the settings such as the number of items to be displayed and the display order set by the user. Also, when the download button is pressed, the administrative activity support device 2 may output the list of financial resources that satisfy the search criteria to be displayed in the revenue list display unit W33 in the form of CSV (comma separated values) or the like based on the search results by the search unit 22.

[0080] <Budget request and assessment comparison> The tabulation result display screen W3 shown in Figure 5 is the screen that appears when "Budget / Increase / Decrease Comparison" is selected, but when "Budget Request / Assessment Comparison" is pressed and selected, the Budget Request / Assessment Comparison screen is displayed. At this time, the tabulation unit 23 tabulates the specific revenue request amount and the general revenue request amount, and the specific revenue assessment amount and the general revenue assessment amount, and calculates the difference between the request amount (specific revenue request amount and general revenue request amount) and the assessment amount (specific revenue assessment amount and general revenue assessment amount) for each of the specific revenue and the general revenue. Based on the aggregation results by the aggregation unit 23, the display processing unit 24 displays the aggregation results of the requested amounts (requested amounts for designated revenues and requested amounts for general revenues), the aggregation results of the assessed amounts (assessed amounts for designated revenues and assessed amounts for general revenues), and the differences between the requested amounts and assessed amounts (the difference between the requested amounts for designated revenues and assessed amounts for designated revenues, and the difference between the requested amounts for general revenues and assessed amounts for general revenues) for each of the designated revenues and general revenues. The aggregation unit 23 may also calculate an assessment ratio (assessed amount / requested amount). At this time, the display processing unit 24 may display the assessment ratio as well as the difference.

[0081] The search unit 22 may search for relevant tasks and projects based on the search criteria. Tasks and projects that continue inertly are often funded only by general revenue. Therefore, the search unit 22 may search for tasks and projects using the search criteria that only general revenue is funded. In this case, the display processing unit 24 may display a list showing tasks and projects funded only by general revenue based on the search results.

[0082] <Embodiment 2> In the following, in the second embodiment, an example of registering personnel expenses and managing them in association with a person in charge will be described. In this case, personnel expense information, including salary amounts, is registered in association with user information and used for personnel expense-related processing, such as the aggregation of personnel expenses for a business. Note that the same components as in the first embodiment are assigned the same reference numerals and their description will be omitted. In this embodiment, user information about one or more users who are in charge of a business or other project as personnel is registered in association with business information or information related to its breakdown items using identification information related to the person in charge, such as a user ID. In addition, one or more pieces of user information may also be registered in association with breakdown items at a level below the business level, such as minor projects and individual expense items, and the processing described below related to the person in charge, such as calculating personnel expenses and creating a history of the work handled by the person in charge, may be performed.

[0083] In addition, the person in charge in the second embodiment is the person in charge who actually executes the business. , the person in charge who is registered in association with the calculation item under the individual expense item, and the registration of the individual expense item The person in charge of managing the data, etc., who is registered in association with individual expense items. In this embodiment, in the calculation of personnel costs to be described later, The information is used for processing, and the work history of the person in charge includes user information related to the person in charge. The processing is carried out using the user information related to the common person in charge, but the processing described below is carried out using the user information related to the common person in charge. may be performed.

[0084] <Calculating labor costs> In the example described below, a person in charge is registered for an administrative project and the personnel costs of the person in charge of carrying out the administrative project (the person in charge of carrying out the project) are calculated; however, the person in charge may be registered and linked to any level of the policy system, such as policy, measure, or minor measure, and personnel costs may be calculated as described below.

[0085] In this embodiment, users who use the system are registered as the person in charge of a business when the business is registered. User information is used as information about the person in charge of the business. In this embodiment, the user information stored in the user master includes information about the personnel costs of each user (personnel cost information), including the user's salary, employee allowances, etc., and the operating rate of the business for which the user is responsible.

[0086] When registering an individual expense item called "labor costs," the registration unit 21 accepts the registration of labor costs for individual staff members as an accumulation item. When registering an accumulation item (e.g., "Labor Costs for Staff Member A") under the individual expense item ("Labor Costs"), the registration unit 21 accepts the designation of the user to be registered as the staff member, the operating rate, and the operating period (in months in this embodiment), and registers them in association with the user information about the staff member. In this embodiment, labor cost information about the staff member designated using identification information such as a user ID is used to perform the labor cost processing described below. At this time, a list of users selectable as the staff member, such as staff members associated with the administrative business or users belonging to the organization / department responsible for the administrative business, may be displayed, and the staff member may be selected from the list. The registration unit 21 may also accept the labor costs of each staff member along with the operating rate, and register them in association with the user information about the staff member. The utilization rate is information regarding the utilization rate of the tasks and business operations for which a user is responsible. For example, if User A works 8 days for task AA and 12 days for task BB out of 20 working days in a month, User A's utilization rate would be 40% (0.4) for task AA and 60% (0.6) for task BB. In this embodiment, labor cost information, such as monthly salary and allowances, is registered as the costs associated with the user's employment in January, but annual costs may also be registered as labor cost information. Furthermore, labor cost information, utilization period, and utilization rate are registered in association with user information and / or task and business information. If they are usable for the labor cost calculation process described below, they may be registered as user information or as information related to the task and business operations, such as individual expense items and task and business information. In addition, in this embodiment, annual labor costs are calculated using the operating rate, which is the operating rate for one month, and the operating period, which is the number of months of operation.However, if the operating rate for the period being calculated is used as the operating rate, such as when calculating annual labor costs using the operating rate of a person in charge for one year, labor costs may be calculated without using the operating period.

[0087] When registering a task or business, the registration unit 21 registers the received task or business information by linking it with information about the organization and / or department in charge of the task or business (organization information, department information) and user information about the person in charge of the task or business. Furthermore, in this embodiment, when registering a person in charge of a task or business, if the person in charge is in charge of multiple tasks or businesses, the registration unit 21 may accept the operating percentage of the task or business for each user and register this as user information. When registering a user in charge of a task or business, upon accepting the registration of the person in charge, the registration unit 21 determines the tasks or businesses that the user is in charge of, and if the user to be registered as the person in charge is not in charge of any tasks or businesses in that fiscal year, the registration unit 21 may register 100% or 100% as the operating percentage.

[0088] In this embodiment, the registration unit 21 registers the labor costs for the task as an individual expense item based on the user information of the person in charge of the task. In this embodiment, the registration unit 21 calculates the labor costs for each person in charge of the task based on the labor cost information of the person in charge of the task (user), and registers the labor costs as an accumulated item under the individual expense item. For example, if the utilization rate for the task is 50%, half of the salary is set as the individual labor cost for that user. When multiple people are associated with the task, the registration unit 21 may calculate and aggregate the labor costs for each person in charge based on the labor cost information, and register the labor costs for the task as an individual expense item. The display processing unit 24 displays the labor costs of the person in charge (executor) of the task based on information regarding the breakdown items, such as the individual expense items, registered for the labor costs. At this time, the display processing unit 24 may display the results of the personnel expenses for each business, as well as information about the users in charge of the business and a list showing the personnel expenses for each individual user. At this time, the display processing unit 24 may perform the personnel expenses calculation for each business, or may perform the calculation for each detailed item such as for each sub-business, or for each policy system item such as a measure.

[0089] Below, we will explain an example where user A is in charge of two administrative tasks: task AA and task BB, with the operating ratios registered indicating that user A is responsible for task AA 40% and task BB 60%. In this case, if labor cost information is registered stating that employing user A would cost 300,000 yen per month in salary, etc., the monthly labor cost for user A in task AA would be 120,000 yen, and the monthly labor cost for user A in task BB would be 180,000 yen. In this way, the aggregation unit 23 calculates labor costs for the tasks based on the information of the users registered as responsible personnel for the tasks. Furthermore, labor costs over a specified period may be calculated, such as by multiplying by the operating period to calculate the annual labor cost for each task for user A.

[0090] In this embodiment, when the tabulation unit 23 receives the designation of a project to be tabulated, it calculates the labor costs for the specified administrative project for each employee based on the labor cost information and operating ratio of the employee associated with the specified project, and calculates the tabulated labor costs for the specified administrative project by aggregating the labor costs of each employee associated with the specified administrative project. The tabulation unit 23 may also perform tabulation based on an axis other than administrative projects, for example, by sub-project or by policy system item such as policy unit. The tabulation unit 23 may also perform tabulation of labor costs by employee affiliation, such as by employee affiliation for a specific administrative project.

[0091] <Work history of the person in charge> The following describes processing related to displaying the history of work handled by a person in charge. In this embodiment, the processing described below uses user information related to the person in charge (manager) who manages data, such as managing individual expense items, to perform the processing described below. However, processing may also be performed using user information related to the person in charge of execution and / or user information related to the manager. Furthermore, in this embodiment, user information related to the manager is registered in association with business information by another user who is the user's head, but it may also be registered in association with business by the user himself or another user, such as a user in the general affairs department or finance department. In this embodiment, a manager is set for each business, but a person in charge may also be set for one or more levels of policy system items excluding or including business, and registered in association with them. Furthermore, multiple managers may be set for each policy system item.

[0092] The search unit 22 searches for tasks and projects linked to the user information of the specified staff member to create a history of tasks and projects handled by a specific staff member. The display processing unit 24 displays a list of tasks and projects handled by the user based on the search results by the search unit 22. The display processing unit 24 may display information for each task or project, such as promotional materials prepared by the staff member, the contractor selected by the staff member, and the budget amount negotiated by the staff member, based on the task and project information extracted by the search. In this case, the display processing unit 24 may display a screen showing the performance of the task and project based on information on the performance of the task and project (e.g., progress performance information, outcome performance information, etc.). The list of policy system items or individual expense items handled by the user, displayed by the display processing unit 24, is displayed in order of the year of responsibility, allowing confirmation of the name of the policy system item or individual expense item (in this embodiment, the name of the task and project), an overview of the policy system item or individual expense item, and the organization and / or department to which the user currently belongs. However, filtering, sorting, etc. may be performed by year, responsible organization, and / or department. Furthermore, when displaying multiple levels, the display processing unit 24 may divide the levels into policy system levels and display the implementation year, item name, summary, etc. of policy system items or individual expense items.

[0093] Furthermore, in this embodiment, in addition to the administrative business information, information on the breakdown items under the administrative business (sub-business information, individual expense item information, and accumulated item information) also includes information on the person in charge, such as identification information (user ID) of the user linked as the person in charge. The search unit 22 may also search for items more detailed than administrative business, such as sub-business information and individual expense item information linked to the user as the person in charge, and the display processing unit 24 may perform display processing of information on the history of administrative work (sub-businesses, individual expense items, etc.) that the user was in charge of based on the search results.

[0094] <Embodiment 3> Below, in the third embodiment, an example of searching and aggregating individual expense items will be described. Note that components similar to those in the first embodiment are assigned the same reference numerals and will not be described again. Furthermore, in this embodiment, processing including searching for individual expense items is performed using data (individual expense item information, etc.) of corresponding individual expense items that have continued over multiple years and are stored in association with each other. Here, the data related to corresponding individual expense items over multiple years refers to information about expenses that have the same higher-level item (policy, measure, administrative project, subproject, etc.) and have continued for one or multiple years, such as multiple individual expense items related to similar items (expenses) for the same project, but with different budget compilation statuses and / or execution years (for example, travel expenses in the FY2023 initial budget (unofficial announcement), travel expenses in the FY2023 June supplementary budget (unofficial announcement), and travel expenses in the FY2024 initial budget (request) for subproject AA under administrative project A). Information about multiple corresponding individual expense items (individual expense item information) is stored in the database DB by directly associating it using identification information such as the individual expense item ID, or indirectly associating it via a higher-level breakdown item (administrative business, minor business).

[0095] In addition, in this embodiment, one breakdown of funding sources relating to the funding sources to be allocated is registered for each individual expense item, and in the processing described below, search and other processing is performed by referring to the breakdown of funding sources registered in association with this individual expense item.

[0096] In this embodiment, the administrative activity support system 1 performs the processing described below, including searching for individual expense items, using corresponding individual expense item information for multiple years that is directly associated and stored based on the individual expense item's identification information (e.g., individual expense item ID). However, the processing described below may also be performed using corresponding individual expense item information for multiple years that is indirectly associated and stored through associated and stored corresponding projects (administrative projects or minor projects) for multiple years. In this case, the administrative activity support system 1 performs the processing described below, including searching, using data related to individual expense items that have continued for one or multiple years and are associated based on any information contained in the individual expense item information, such as individual expense items with the same individual expense item name under the corresponding administrative project or individual expense items with the same budget category. In this embodiment, the search focuses on general funds allocated to individual expense items. In the example shown below, a search is performed by comparing changes in individual expense items across different years and budget preparation statuses based on individual expense item information with different execution years and the same budget preparation status.

[0097] The search unit 22 searches for individual expenditure items based on the funding source breakdown associated with each individual expenditure item. The majority of administrative budgets in Japan are ongoing expenses. However, conventional technologies can only identify appropriated funding sources at the project level, as shown in Figure 6(a), making it difficult to identify expenses that continue uninterruptedly. In this embodiment, the search unit 22 searches for individual expenditure items related to individual expenses of an administrative project (Project A) as shown in Figure 6(b) based on the funding source breakdown associated with individual expenditure items, which are more detailed than projects, and can extract candidates for ongoing uninterrupted expenses. The image shown in Figure 6(b) is a graph color-coded based on the funding source classification of the funds allocated to each individual expenditure item a to g (Expense A to Expense G) under Project A shown in Figure 6(a). While the funding source appears to be fine from a project perspective, checking the expenses at the expense level, as shown in Figure 6(b), may reveal that the expenses are ongoing uninterruptedly.

[0098] In this embodiment, the search unit 22 uses as a search condition a condition related to the change over time in the amount of revenue linked to an individual expense item, and searches for individual expense items that may not have been appropriately reviewed, such as individual expense items (e.g., G expenses) for which the change over time in the budget amount or revenue amount (the total amount of general revenue and specific revenue) of the individual expense item is small and the amount of revenue (particularly the amount of general revenue) linked to the individual expense item has not changed since the previous year, or individual expense items (e.g., B expenses) for which the proportion of general revenue allocated due to the cessation of specific revenue expenditures has increased sharply and the decrease in specific revenues has been made up with general revenues, and for which the change in the total amount of revenue (the total amount of general revenue and specific revenue) is small, thereby extracting candidates for individual expense items that are likely to continue by inertia. This function may be used to determine whether the requested budget is appropriate before the budget request is made, or may be used for post-budget analysis.

[0099] In this embodiment, the search unit 22 searches for candidates for expenses that have been spent relentlessly, such as individual expense items that have been spent continuously and may not have been appropriately reviewed because their change over time is small, or individual expense items such as expenses for which the general revenue amount has changed rapidly over time or expenses for which the specific revenue amount has decreased and a large amount of general revenue has become necessary, by comparing the appropriated financial resources over time based on the associated individual expense item information for expenses that have continued for multiple years. In this embodiment, the search unit 22 searches for expenses (individual expense items) for which the budget amount or the total of the general revenue amount and the specific revenue amount has continued to be the same amount (the change is within a threshold), and the appropriated revenue amount (general revenue amount and specific revenue amount) has changed little over time (no change over time or the change is within a predetermined range), or the appropriated general revenue amount has changed rapidly over time (the change is above a threshold). The search unit 22 may also use search criteria such as the execution year, budget preparation status, responsible organization (department), etc. In a search for individual expenditure items based on financial resources, the difference used to compare individual expenditure items is the difference in the revenue amount for a specific ongoing individual expenditure item over multiple years. In this embodiment, the difference is the difference between the revenue amount appropriated for the target individual expenditure item in the target year and the n-year prior year (five years prior in this embodiment), but it may also be the difference in the revenue amount for the target year and the previous year. The search unit 22 may also compare the changes in the target individual expenditure item over multiple years with the previous year, and search for individual expenditure items for which the change in the amount of allocated general revenue from the previous year is within a threshold for all of the target years. Alternatively, the search unit 22 may search for individual expenditure items for which the change over multiple years is within or above a threshold, for example, for a five-year period in which the change from five years prior is within a threshold. For the purpose of the search, the search unit 22 may calculate in advance the amount of change in the amount of revenue over time for each individual expense item to be searched for. In this case, the threshold value may be either a percentage or an amount.The search unit 22 searches for individual expense items for which the change over time in the appropriated general financial resources is equal to or greater than a threshold (individual expense items for which the general financial resources allocated are rapidly increasing) or for individual expense items for which the change over time in the appropriated general financial resources is equal to or less than a threshold (individual expense items for which the change over time in the individual expense items allocated is small). In addition, the search unit 22 may search for individual expense items for which the change over time in the amount of revenue is equal to or greater than a threshold in order to detect individual expense items that may not have been appropriately reviewed.

[0100] The search unit 22 searches for individual expense items whose change in revenue is greater than or equal to a threshold value or less than a threshold value based on the search criteria. For example, when the search criteria is that the change in revenue from any of the revenue categories (general revenue or designated revenue) from the previous fiscal year is within a threshold value, the search unit 22 refers to the revenue information linked to the individual expense items and extracts individual expense items that meet the search criteria, such as extracting individual expense item A for fiscal year 2023 for which the change in general revenue appropriated from fiscal year 2018, five years ago, is within a threshold value. At this time, the search unit 22 may perform a search by comparing changes in only general revenue or designated revenue, or may perform a search by comparing changes in the total of general revenue and designated revenue.

[0101] In addition, in this embodiment, the search unit 22 performs a search using changes between revenues whose budget type is current totals, but it may also perform a search using changes between initial budgets, between current totals and initial budgets, or between supplementary budgets.

[0102] In this embodiment, the registration unit 21 also accepts the registration of procurement methods and suppliers when registering individual expenditure items, and the individual expenditure item information includes the procurement method and supplier. The procurement method refers to the bidding method for government-related projects, including open competitive bidding, designated competitive bidding, and discretionary contracting. If the procurement method and / or supplier (especially the supplier) are the same and the revenue amount remains the same, it is likely that orders have been placed with the same business entity in the same way and that expenses have not been reviewed. The search unit 22 searches based on conditions related to the procurement method and / or supplier in addition to search conditions related to changes in revenue amount over time, and searches for individual expenditure items that are candidates for expenses that have continued indefinitely. By using these search conditions in addition to changes in revenue amount over time, the search unit 22 can detect individual expenditure items that may not have been reviewed, such as those for which the procurement method or supplier has not changed and whose revenue amount (general revenue amount or the sum of general revenue amount and specific revenue amount) has changed little over time (within a certain range). In this embodiment, the search is performed for individual expense items that have continuously met the above conditions for a specific number of years (five years in this embodiment). In this embodiment, the search unit 22 searches for candidates for inertial expenses by searching for individual expense items related to expenses for which orders have been placed with the same supplier for n years or more and which are of a specific procurement method (for example, discretionary contract) that is highly likely to be expenses that have continued inertially.

[0103] Furthermore, the search unit 22 may search for individual expense items based on other revenue ratios, such as the ratio of general revenue or the ratio of specific revenue allocated to the individual expense item. In this case, the search unit 22 may calculate the revenue ratio based on the individual expense item information, etc., for the search. For the search, the search unit 22 may search for the ratio based on the individual expense item information about the target individual expense item and / or various information linked to the individual expense item (such as administrative business information, sub-business information, and estimated item information). In addition, in this embodiment, the search criteria related to the general revenue amount have been described. However, since a decrease in general revenue amount leads to an increase in specific revenue amount, the search unit 22 may search for individual expense items with a rapidly increased general revenue by using a rapidly decreased specific revenue amount.

[0104] Furthermore, an individual expense item may be registered with a tag indicating the nature of the individual expense item, for example, a mandatory expense tag indicating that the expense is stipulated by law. In this case, the search unit 22 may perform a search based on the tag indicating the nature of the individual expense item linked to the individual expense item, and extract individual expense items linked with a specific tag (in this embodiment, an administrative expense tag).

[0105] In this embodiment, the search unit 22 receives search conditions related to the above-mentioned items (changes in revenue over time, procurement methods and suppliers, proportions of appropriated financial resources, etc.) from the user terminal 3, and searches for individual expense items stored in the database DB based on the received search conditions. At this time, the search conditions may be set in advance for each search target using conditions related to multiple items depending on the target that the user wants to search for. For example, when receiving from the user terminal 3 a specification that individual expense items related to mandatory expenses but which may require more than the amount specified by law are to be searched for, the search unit 22 may perform a search based on search conditions according to the search target, such as searching for individual expense items linked to mandatory expense tags and whose general financial resource allocation rate is equal to or greater than a threshold, based on search conditions set in advance for each target.

[0106] The display processing unit 24 displays a list of individual expense items that meet the search criteria and may be continuing indefinitely based on the search results of the search unit 22. At this time, the display processing unit 24 may display the financial resources associated with each individual expense item for two or more years so that they can be compared over time, such as by displaying the financial resources associated with each individual expense item for each fiscal year starting five years ago. The financial resources displayed here are general and / or specific financial resources for each individual expense item, and the general and / or specific financial revenue amounts associated with a specific individual expense item are displayed. Furthermore, as shown in the example of FIG. 6(b), the display processing unit 24 may display a bar graph showing the revenue amounts for each financial resource category of the financial resources allocated to each individual expense item by color-coding the specific and general financial resources allocated to the individual expense item based on the financial resource breakdown of the individual expense item. To confirm that the expenses are indefinite, the display processing unit 24 may display the revenue amounts and / or graphs for multiple fiscal years for each individual expense item to allow for comparison of changes from year to year. When any of the individual expense items displayed in the list is designated as an individual expense item for which details are to be checked, a screen showing details of the designated individual expense item may be displayed.

[0107] Furthermore, although the above processing describes processing related to individual expense items, processing including the above-mentioned search may also be performed for any level of breakdown items related to administrative projects (administrative projects, minor projects, individual expense items, and estimated items). [Explanation of symbols]

[0108] 1. Administrative Activity Support System 2 Administrative activity support equipment 21 Registration Department 22 Search Section 23 Counting Department 24 Display processing section 3. User terminal

Claims

1. An administrative activity support system for revenue management, Registering the amount of general revenue and general revenue items for each of multiple general revenue sources that are revenues in a certain execution year; For each of a plurality of specific revenue sources that are revenues in a certain fiscal year, the amount of specific revenue source revenue and the specific revenue source revenue items are registered; An administrative activity support system that aggregates the general revenue amount for general revenue sources and the specific revenue amount for specific revenue sources that meet search criteria in a certain execution year and displays the respective aggregation results.

2. Accepts the specification of revenue items to be displayed, Based on the specified revenue item, a list of general revenue sources and specific revenue sources that meet the search criteria is displayed. The administrative activity support system according to claim 1.

3. Display a list of general and specific financial resources that meet the search criteria alongside the aggregated results. The administrative activity support system according to claim 1.

4. Specific funds are registered at units below the business unit, while general funds are registered at budget item system units. The administrative activity support system according to claim 1.

5. The general revenue items and the specific revenue items include revenue items, The general revenue amount and / or the specific revenue amount are calculated based on the revenue items. The administrative activity support system according to claim 1.

6. The general revenue amount and general revenue items, as well as the specific revenue amount and specific revenue items, shall be registered for each department in charge, The general revenue amount and / or the specific revenue amount are compiled based on the department in charge. The administrative activity support system according to claim 1.

7. The general revenue amount and / or the specific revenue amount are aggregated based on the budget type. The administrative activity support system according to claim 1.

8. Furthermore, the general revenue amount of the general revenue and the specific revenue amount of the specific revenue for the previous fiscal year of the certain execution year are totaled, and the respective total results for the previous fiscal year are displayed, and the difference between the total results for the certain execution year is displayed. The administrative activity support system according to claim 1.

9. General revenue and specific revenue are registered in association with budget types, Based on the budget type, the revenue request amount and the revenue assessment amount are compiled for general revenue sources and / or specific revenue sources, displaying the tabulated result of the revenue demand amount, the tabulated result of the revenue assessment amount, the difference between the revenue demand amount and the revenue assessment amount, and one or more of the composition ratio or assessment rate; The administrative activity support system according to claim 1.

10. When registering a business in administrative activities, the business is registered in association with the person in charge of the business, Register the labor costs and business utilization rate for one or more personnel, Calculating the labor costs of each person in the business based on the labor costs and the operating rate; The administrative activity support system according to claim 1.

11. In the aggregation of the labor costs, the labor costs of the individual personnel in the business are aggregated to aggregate the labor costs related to the business; The administrative activity support system according to claim 11.

12. When registering a business in administrative activities, the business is registered by linking it to the person in charge of the business, Once the person in charge is specified, a search is performed for the business that the person in charge was in charge of. Based on the search results, a list of businesses handled by the person in charge is displayed. The administrative activity support system according to claim 1.

13. The individual expenditure items are registered in association with the financial resource breakdown, and further registered in association with the corresponding individual expenditure items for one or more years; By comparing individual expenditure items registered in association with multiple fiscal years, we search for individual expenditure items that may not be appropriate for review due to sudden changes in general fund revenues over time. The administrative activity support system according to claim 1.

14. The individual expense accounts are registered in association with the financial resource breakdown and further in association with the corresponding individual expense items for one or more years; By comparing individual expenditure items registered in association with multiple fiscal years, we search for individual expenditure items whose general fund revenues have not changed much over the years and for which revision may not be appropriate. The administrative activity support system according to claim 1.

15. For each searched expenditure item, the amount of general revenue allocated to it, or the amount of general revenue and specific revenue, is displayed for two or more fiscal years so that it can be compared over time.

15. The administrative activity support system according to claim 13 or 14.

16. A method for supporting administrative activities for conducting revenue management, comprising: The computer registers the amount of general fund revenue and the general fund revenue items for each of a plurality of general fund revenues that are revenues in a certain execution year, For each of a plurality of specific revenue sources that are revenues in a certain fiscal year, the amount of specific revenue source revenue and the specific revenue source revenue items are registered; An administrative activity support method that aggregates the general revenue amount of general revenue and the specific revenue amount of specific revenue that meet search conditions in a certain execution year, and displays each of the aggregated results.

17. A computer program that causes a computer to execute the administrative activity support method according to claim 16.

Images