JPH10171869A - Budget result management system and recording medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To solve the difference in a balance due to a time difference from the application of cost up to the definition of accounting results by approving the use application of a budget when a temporary balance subtracted by temporary allowance based on the use application is more than a prescribed value, and at the time of defining the application, invalidating the temporary allowance and setting up a value subtracted based on the defined value as the balance of the budget. SOLUTION: A temporary allowance means 2 calculates a balance subtracted by temporary allowance based on budget use application outputted from a client 9, and when the balance is more than the prescribed value, a judging means 3 approves the budget use application, and when a definition means 4 defines the temporary allowance, the value subtracted from the budget is set up as a balance. On the other hand, the means 2 sets up an application amount in a temporary allowance column for the budge in a budget results file 6 based on the budget use application from the client 9, calculates a balance by subtracting an actual amount and the temporary allowance from the budget, and when the temporary balance is more than the calculated prescribed value, the means 3 approves the budget use application. When the temporary allowance is defined, the means 4 adds a defined amount for returning the temporary allowance to the original amount to the actual amount and subtracts the actual amount from the budget to obtain the balance.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a budget performance management system for managing budget performance and a recording medium.

[0002]

2. Description of the Related Art Heretofore, when an employee makes an application for use of expenses in a company, he or she has made a usable application by checking the balance last month.

Further, at the time of application, a department which has a budget for the cost to be used is checked, and then the department code is input to apply for use.

[0004]

As described above, in the past, an employee had applied for the use of usable expenses by looking at the balance of the last month, so that the application was confirmed as an accounting result and the actual balance was calculated. There is a problem in that the current balance is unknown and it is possible to apply for more than the actual balance, and the application for use will be rejected at a later date when the balance is allocated, causing work rework. there were.

[0005] In addition, when an employee makes an application for use of expenses, there is a problem that the balance cannot be confirmed or the application for use cannot be made unless the department for which the budget for the expenses is owned is checked.

[0006] The present invention solves these problems,
Provisional budget allocation is performed in real time when applying for expenses, eliminating differences in balance due to the time lag between application for expenses and confirmation of accounting results.In addition, the department that owns the budget for expenses is automatically searched for balance confirmation and allocation. The purpose is to enable it easily.

[0007]

Means for solving the problem will be described with reference to FIG. In FIG. 1, a server 1
Manages the actual budget, and is composed of a provisional allocation unit 2, a determination unit 3, a determination unit 4, a search unit 5, a budget actual file 6, a department file 7, a budget source file 8, and the like. It is.

The actual budget file 6 includes a budget, a provisional amount,
And the actual amount. The department file 7 is for registering the department code of the budget by associating it from lower to higher.

The budget source file 8 is for registering department codes and expense items for managing a budget in association with department codes and expense items. Client 9 is LA
The server 1 is connected to the server 1 via N or the like to apply for a budget.

Next, the operation will be described. The provisional allocation means 2 in the server 1 calculates a balance obtained by provisional allocation and subtraction of the corresponding budget based on the application for using the budget from the client 9, and the determination means 3 determines that the calculated balance is equal to or more than a predetermined value (for example, (0 or positive), the application for use of the budget is accepted, and the value obtained by subtracting the determined value from the budget when the determination means 4 determines the provisional allocation is used as the balance.

Further, the provisional allocation means 2 in the server 1 sets the amount of the use application in the provisional allocation column for the corresponding budget in the budget actual file 6 based on the application for use of the budget from the client 9. And a balance obtained by subtracting the actual amount and the provisional reserve amount from the budget, and the determining means 3 approves the application for using the budget when the calculated value is equal to or more than the calculated predetermined value (for example, the balance is 0 or positive). When the allocation is determined, the provisional allocation is restored, the determined amount is added to the actual amount, and the value obtained by subtracting the actual amount from the budget is used as the balance.

At this time, when the search means 5 does not find the budget by searching for the budget using an arbitrary department code of the corresponding entry in the budget actual file 6 as a key, it searches for other related department codes of the entry. To search for a budget.

The search means 5 searches the budget source file 8 when the department code and the cost item are input, retrieves the department code and the cost item for managing the corresponding budget, and uses the department code and the cost item as a key to obtain the actual budget. The corresponding budget is searched from the file 6.

Further, a program having the temporary allocation means 2, the judgment means 3, the determination means 4, or the search means 5 is stored in a storage medium. Therefore, provisional budget allocation is performed in real time at the time of cost application, eliminating the difference in balance due to the time lag from cost application to accounting confirmation, and also automatically checking the department that owns the budget for expenses to check the balance and allocate. It can be easily realized.

[0015]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, embodiments and operations of the present invention will be described sequentially in detail with reference to FIGS. Here, a program read from a recording medium (not shown) or a hard disk device as an external storage device, or a program transferred from an external storage device of the center via a line is loaded into a main storage such as a server or a client. It starts up and performs various processes described below.

FIG. 2 is a flowchart (part 1) for explaining the operation of the present invention. This is a flowchart describing the operation of the configuration of FIG. 1 in detail. FIG. 2A shows a flowchart of the temporary allocation.

In FIG. 2A, S1 inputs application information (organization code, cost item, amount). this is,
A department code (organization code), cost item, application amount, and the like are input as budget application information on a screen shown in FIG. At this time, since the employee code is entered at the time of login, the organization code (XX section) to which the employee belongs is obtained based on the employee code, and the organization code is automatically displayed on the screen. I have.

In step S2, a budget performance file is acquired. This is the information (for example, year,
Period, department code, expense item) as a key, and fetch the corresponding entry from the budget actual file.

In S3, it is determined whether or not acquisition is possible. this is,
In S2, it is determined whether the corresponding entry has been obtained. YE
In the case of S, the process proceeds to S4. If NO, the process ends as an error.

At S4, the balance = budget amount− (allocated amount + actual amount) is obtained. This is the budget actual file acquired in S2, for example, the budget amount in the corresponding entry of FIG.
(Provisioned amount + actual amount) = calculated as balance.

In step S5, it is determined whether or not balance-application amount ≧ 0.
It is determined whether the current balance−the applied amount obtained in S4 is 0 or more. In the case of YES, the process proceeds to S6.
In the case of NO, the process ends because the balance is smaller than the application amount and provisional allocation cannot be made.

In S6, since it has been determined that the provisional allocation amount can be allocated from the budget in YES in S5, the input application information is determined. In S7, the allocation amount = the allocation amount + the application amount is obtained. Since it is determined that the allocation is possible by YES in S5, the application amount is added to the allocation amount in the temporary allocation amount column in the budget result file in FIG. 4 and written back, and the current application amount is added to the temporary allocation amount. I do.

In step S8, the actual budget file is updated. By the above S1 to S8, when the amount of the use application is smaller than the balance of the budget result file 6 of FIG. 4 based on the application of the budget from the user, it is added to the provisional provision amount and the provisional provision is performed. Becomes

FIG. 2B shows a flowchart for updating the results. In FIG. 2B, S11 acquires the result confirmation information (organization code, cost item, application amount, and fixed amount). Here, the determined amount is the same as that of FIG.
The temporary allocation amount determined in the flowchart of (1) above is a finalized amount that is OK after being checked by accounting, and may be larger or smaller than the temporary allocation amount.

In step S12, a budget performance file is obtained.
This acquires the contents of the entry corresponding to the information (organization code, cost item) acquired in S11 as a key. S1
No. 3 determines whether or not acquisition is possible. If YES, S1
Proceed to 4. If NO, the process ends as an error.

At S14, the allocation amount = the allocation amount−the application amount the actual amount = the actual amount + the fixed amount is calculated. The former allowance = allowance-application amount
The column of the provisional allocation amount in FIG. 4 is returned to the state where the original temporary allocation is not performed. For the latter, the actual amount = the actual amount + the fixed amount, the final amount is added to the actual amount in the actual amount column in FIG. 4, and the added result is written in the actual amount column to be updated.

A step S15 updates the budget achievement file.
By the above S11 to S15, allocation (temporary allocation) is performed in the column of the temporary allocation amount in the budget actual result file 6 of FIG.
When the provisional allocation is determined and the finalized amount is determined, the column of the temporary allocation amount is returned to the value before the temporary allocation, and the finalized amount is added to the actual amount to update the actual actual amount.

According to FIGS. 2A and 2B, the provisional allocation in the budget actual file 6 in FIG. 4 is added based on the budget application information, and the provisional allocation is determined. In this case, the provisional allowance column is returned to the original state, and the actual amount is updated by adding the final amount to the balance (budget amount-
(Temporary allocation + actual amount)) is accurately calculated and displayed in real time, and when the temporary allocation is determined, the temporary allocation can be restored and the actual amount can be updated.

FIG. 3 shows an example of a screen according to the present invention. Here, the underlined portion shown below is input.・ Fiscal year: Fiscal 1996 : Second half・ Department code: 1220 Item name: Pencil・ Cost item: 441・ Application amount: ¥ 10,000 "Received within budget" ・ Application amount: ¥ 40,000 "Over budget Here, the budget actual file 6 of FIG. 4 is searched using the year, period, department code (automatically searched from the employee code at the time of login and displayed), cost item, and item name as keys, and as described above. According to the procedure shown in FIG. 2 (a), if the application amount is equal to or smaller than the balance, a message "accepted within the budget" is displayed, and if larger, the message "over budget" is displayed. Is displayed.

FIG. 4 shows an example of a budget actual result file according to the present invention. Here, the following items shown in the figure are set in the budget achievement file 6.・ Fiscal year: ・ Period: ・ Department code: ・ Cost items: ・ Budget: ・ Actuals; ・ Temporary reserves; ・ Others The temporary reserves are calculated at the time of the employee's application to use the budget. If it is within the range of (results), register. Then, when the temporary allocation is determined, the column of the temporary allocation amount is returned to the original, and the determined amount is added to the column of the actual amount. As a result, an almost accurate balance (budget-(actual amount +
Temporary provision amount)) can be calculated.

FIG. 5 shows an example of a message according to the present invention. Here, a message in which the following information shown is set is transmitted from the client 9 to the server 1.・ Date of application: ・ Applicant: ・ Fiscal year: ・ Term: ・ Department code: ・ Item name: ・ Cost item: ・ Application amount: ・ Others FIG. 6 shows a flowchart (part 2) for explaining the operation of the present invention. . This is a flowchart of reassembly, and is a flowchart of reassembly in a state where the temporary allocation of FIG.

In FIG. 6A, in S21, the expense application is canceled or the expense application is rejected. The former “cancel the cost application” refers to the case where the user temporarily cancels the cost application in which the provisional allocation is performed in FIG. The latter "cost application is rejected"
Is a case where a user has applied for a cost, but the applied cost is larger than the balance, temporary provision cannot be made, and the cost application is rejected.

In step S22, a budget performance file is obtained.
In this case, the corresponding entry of the budget result file 6 set based on the expense application canceled or rejected in S21 is extracted.

A step S23 decides whether or not the data has been acquired. YES
In the case of, the process proceeds to S24. If NO, the process ends as an error. In S24, the allocation amount = the allocation amount−the application amount is obtained. In this case, the provisional reserve amount of the corresponding entry in the budget actual result file 6 of FIG. 4 is returned to the original state (reservation amount-calculated amount is obtained and updated to return to the original state in which the cost is not applied).

A step S25 updates the budget achievement file.
As described above, when the expense application is withdrawn or rejected due to insufficient balance, the column of the provisional reserve in the corresponding budget actual file 6 is returned to the original state, and so-called budget reassembly can be easily performed. Becomes

FIG. 7 is a flowchart (part 3) for explaining the operation of the present invention. In FIG. 7, in S31, the corresponding entry is acquired from the budget actual file using the organization code and the cost item as keys. In this case, the relevant entry is obtained from the budget actual file 6 in FIG. 4 described above using the organization code (department code) and the cost item as keys.

In S32, it is determined whether or not acquisition is possible. YES
In the case of, the process ends. In the case of NO, the process proceeds to S33. In step S33, an organization code of a higher organization is acquired from the department file using the organization code as a key. This occurs when the corresponding entry cannot be obtained even when the budget actual file 6 in FIG. 4 is searched based on the department code (organization code) to which the employee belongs based on the employee code at the time of login. ,
Using the organization code as a key, an organization code (department code) of a higher-level organization is acquired from the department file 7 of FIG.

A step S34 decides whether or not the data has been acquired. YES
In the case of, the process proceeds to S35. If NO, the process ends. In step S35, the corresponding entry is obtained from the budget actual file using the upper organization code and the cost item as keys.

A step S36 decides whether or not the data has been acquired. YES
In the case of, the process proceeds to S37. If NO, the process ends as an error. A step S37 decides whether or not it is the end. In the case of YES, the process proceeds to S38. In the case of NO, S33 and subsequent steps are repeated (further, a higher-level organization code is acquired and repeated).

In step S38, an organization code is obtained from the budget source file using the organization code and the cost item as keys. this is,
Using the organization code (department code) and the cost item as keys, the budget source file 8 shown in FIG. 8B (to be described later) is searched and a corresponding entry is obtained.

In S39, it is determined whether or not the data has been obtained in S38. In the case of YES, the process proceeds to S40. If NO, the process ends as an error. In step S40, the corresponding entry is obtained from the budget actual file using the budget source organization code and the cost item as keys. Here, the budget source organization code is the original organization code and expense item, and if the corresponding entry is not found even after searching the budget actual file 6 in FIG. 4, the budget source file 8 in FIG. , And retrieves the source organization code and cost item of the entry that matches the key with the organization code (department code) and cost item,
Using the budget source organization code and the cost item as keys, a corresponding entry in the budget actual file 6 in FIG. 4 is obtained.

In a step S41, it is determined whether or not the income has been obtained. YES
In the case of, the entry matching the organization code and the cost item of the budget source can be obtained from the budget actual file 6 in FIG. 4 and the processing is terminated (hereinafter, S4 and subsequent steps in FIG. 2A are executed. ).

As described above, when the budget entry file 6 in FIG. 4 is searched based on the department code (organization code) and the cost item searched from the employee code at the time of login of the employee, and no corresponding entry is found. 8 (a)
The department record file 6 shown in FIG. 4 is searched by using the upper organization code (department code) converted into the upper organization code (department code) and the cost item as a key. Further, when no entry is found, the budget source file 8 of FIG. 8B is searched using the organization code (department code) and the cost item as keys, and the corresponding budget source organization code (department code) and the cost item are searched. And retrieves the budget entry file 6 in FIG. 4 to obtain the corresponding entry.

FIG. 8 shows an example of a file according to the present invention. FIG.
(A) shows an example of a department file. In this case, the department codes (organization codes) are registered from the bottom to the top in association with each other as shown below (sections,
Department, supervising department, and headquarters).

Department code (organization code): Higher department code (organization code): Further higher department code (organization code): FIG. 8B shows an example of a budget source file. This is a file for finding the organization code of the budget source when the relevant entry cannot be obtained by searching the budget actual file 6 in FIG. 4 using the employee's department and expense items as keys. Here, the budget source department code and the cost item are registered so as to be searched using the department code and the cost item as keys.

[0046]

As described above, according to the present invention,
Preliminary budget allocation is performed in real time at the time of application for expenses, and it is possible to eliminate the difference in balance due to the time difference from the application of expenses to the confirmation of accounting results.Also, the department that owns the budget for expenses is automatically searched for balance confirmation and allocation Can be easily realized. As a result, (1) the difference in the balance due to the time difference from the time of input of the cost application to the confirmation of the accounting result can be reduced, and the substance of the usable balance at the time of input can be accurately grasped.

(2) If the cost application is rejected or canceled before it is settled for accounting purposes, the budget can be refunded immediately. (3) The user can check the balance and provisionally reserve the budget without paying attention to which department owns the budget for the cost to be used.

(4) It is possible to perform flexible budget performance management beyond the organizational hierarchy.

[Brief description of the drawings]

FIG. 1 is a system configuration diagram of the present invention.

FIG. 2 is a flowchart (part 1) for explaining the operation of the present invention.

FIG. 3 is a screen example of the present invention.

FIG. 4 is an example of a budget result file according to the present invention.

FIG. 5 is a message example according to the present invention.

FIG. 6 is a flowchart (part 2) for explaining the operation of the present invention.

FIG. 7 is a flowchart (part 3) for explaining the operation of the present invention.

FIG. 8 is an example of a file according to the present invention.

[Explanation of symbols]

 1: Server 2: Temporary allocation means 3: Judgment means 4: Confirmation means 5: Search means 6: Budget actual file 7: Department file 8: Budget source file 9; Client

Claims (5)

[Claims] In a budget / result management system for managing a budget and an actual result, a temporary allocation means for calculating a temporary balance obtained by temporarily allocating and subtracting a corresponding budget balance based on an application for using a budget; A determination means for approving the use of the budget when the balance is equal to or more than a predetermined value; and a value obtained by invalidating the provisional allocation when the provisional allocation is determined and subtracting the budget from the budget based on the determined value. And a determination means for setting a budget balance. 2. A budget and result management system for managing a budget and a result, wherein a budget file for managing a budget, a provisional reserve amount, and a result amount, and a corresponding budget in the budget file based on an application for using the budget. A provisional allocation means for setting the amount of the use application in the provisional allocation amount column and calculating a balance obtained by subtracting the actual amount and the temporary allocation amount from the budget; and when the calculated balance is a predetermined value or more, A determination means for approving an application for use of the budget, and a determination means for, when the provisional allocation is determined, reducing the provisional allocation amount from the provisional allocation amount in the budget file and adding the determined amount to the actual amount A budget performance management system characterized by the following. 3. A budget file for managing a budget for each department code, a department file in which department codes are stored from lower to higher levels in association with each other, and the budget is set using any department code of a corresponding entry in the budget file as a key. Means for retrieving the budget based on a related department code of the department file when a search is not found. 4. A file for registering a department code and an expense item for managing a budget in association with a department code and an expense item, and a department for searching the file when the department code and the expense item are inputted and managing the corresponding budget. 4. The budget performance management system according to claim 3, further comprising a search unit that retrieves a code and an expense item and searches for a budget using the department code and the expense item as keys. 5. Temporary allocation means for calculating a temporary balance obtained by temporarily allocating and subtracting a corresponding budget balance based on an application for budget use, and using the budget when the calculated temporary balance is equal to or more than a predetermined value. A determination means for approving the application, and a program for disabling the provisional provision when the provisional provision is determined, and for functioning as a means for determining a value obtained by subtracting the determined value from the budget based on the determined value as a budget balance. A computer-readable recording medium that has been recorded.