JP2003178174A - Method for profit and loss management by project and accounting system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To coordinate a plurality of projects with inputted pieces of classification information in an accounting system and improve management accuracy of profit and loss per project. <P>SOLUTION: In a transaction causing profit or costs, an employee causing the transaction always exists. A correspondence relationship (including allocation ratios) between the employee and a project to which the employee belongs is stored as employee-project correspondence master information 42. During classification inputs from terminals 45-47, when a number of the employee causing the transaction is inputted, a superordinate project code and its allocation reference are determined by the master information 42, a classification information file 43 and per project account title balance files 44 are automatically updated, and profit and loss can be calculated per each project. But since there are cases where a transaction does not confirm to project correspondence relationship information managed by the master information, the project correspondence relationship can be changed during the classification inputs. <P>COPYRIGHT: (C)2003,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an accounting system and relates to a method and system for managing profit and loss by project.

[0002]

2. Description of the Related Art In an accounting system, in addition to the function of creating a balance sheet and income statement for the entire company, it is usually the function of managing profit and loss by department (function of creating income statement by department) and profit and loss management function by project ( In many cases, it has a profit and loss statement creation function for each project. The profit and loss management function by project is a project from the start to the end of the project regardless of the normal financial accounting organization (company-business-department) and is not affected by the carry-over of accounting periods. This is a function to manage the profit and loss for each project by capturing the amount of money by each / account item. In order to understand the profit and loss for each project, when inputting the journal of the transaction (sales and expenses) of the profit and loss account, as shown in FIG. I try to enter the code by linking it. Normally, one project code is entered in correspondence with one transaction (journal entry). As a result of inputting as shown in FIG. 2, profit and loss for each project can be managed as shown in FIG.

[0003]

In the case of the above prior art,
The following two problems occur. (1) When a plurality of projects correspond to one transaction (journal entry), it is not possible to link and input a plurality of project codes. Therefore, the person in charge of journal entry selects one representative project, associates the project code with it, and inputs it. As a result, there arises a problem that the accuracy of managing profit and loss by project becomes rough. (2) Although there is a mechanism to enter the corresponding project code when entering the journal,
It is just a management accounting system inside the company (accounting system that uses accounting information for business management inside the company), and it is not always necessary to input the corresponding project code. Therefore, the journal entry staff often neglects to enter the project code. If the input of the project code is neglected, it is impossible to carry out highly accurate profit and loss management for each project. From the above problems (1) and (2), it is necessary to solve the following two problems with respect to the conventional project-based profit / loss management method. (A) An input method when one transaction (journal) corresponds to a plurality of projects. (B) An input method for preventing the journal entry staff from neglecting the input of the project code as much as possible. An object of the present invention is to provide a project-based profit and loss management method and accounting system that solve the above problems.

[0004]

In order to solve the above problems, the present invention provides an input device, an output device, a processing device, and
Employee-project-based profit and loss management method in an accounting system having a storage device that stores a project correspondence master file, journal information file, and project-specific account balance file, and the input device responds to the journal information entered by the user The information is displayed on the display screen, and the project information of the employee number is acquired from the employee-project correspondence master stored in the storage device via the processing device according to the input of the employee number of the user, and the acquired project information Is displayed on the display screen, and the confirmation button is pressed in the display state in which the acquired project information is displayed, or the check column of the acquired project information display screen is checked, and the allocation ratio of the project information is displayed. The confirmation button is pressed in the display state where is corrected and displayed,
Alternatively, when the confirmation button is pressed in the display state in which the project non-correspondence button on the display screen of the acquired project information is pressed, or on the display screen in any of the above display states when the confirmation button is pressed The displayed data is transferred to the processing device. Further, the processing device updates the journal information file and the project-specific account balance file stored in the storage device based on the data transferred from the input device. Further, there is an accounting system having an input terminal device, an output terminal device, a processing device, an employee-project correspondence master, a journal information file, and a storage device storing an account balance file for each project, and the input terminal device is Means for displaying the journal information on the display screen in response to the user's entry of the journal information, and project information of the employee number in the storage device via the processing device in response to the entry of the employee number of the user. Stored employee-means for obtaining from the project correspondence master, the obtained project information, confirmation button, no project correspondence button, means for displaying a check box on the display screen for the obtained project information correspondence, and When the confirmation button is pressed in the display state where the acquired project information is displayed,
Or, the check button on the display screen of the acquired project information is checked and the confirmation button is pressed in the display state in which the allocation ratio of the project information is corrected or displayed, or there is no project correspondence on the display screen of the acquired project information. When the confirmation button is pressed in the display state in which the button is pressed, there is provided means for transferring the data displayed on the display screen in any one of the display states when the confirmation button is pressed to the processing device. I am trying.

[0005]

BEST MODE FOR CARRYING OUT THE INVENTION An embodiment of the present invention will be described below with reference to the drawings. The drawings to be described in the embodiment are FIGS. 1, 4, 5, 6, 6, 7, 8, 9, and 10. FIG. 2 and FIG. 3 are drawings for explaining the conventional technique and are excluded from the explanatory views of the present embodiment.

FIG. 4 shows an overall system configuration diagram of the accounting system. The processing unit 41 represents a server-side processing unit of the accounting system. The storage unit 42 stores correspondence information between employees and projects (see FIG. 5). The storage unit 43 stores journal information (see FIG. 6). The storage unit 44 stores account item balance information for each project (see FIG. 7). Journal entry terminal 4
Reference numerals 5, 46 and 47 denote processing units arranged in the field department for inputting transactions generated in the field department as journal information. The project-by-project income statement output terminal 48 is a processing unit that is disposed in the management department and outputs the project-by-project income statement created based on the journal information input in the field department. It should be noted that the description of creating the income statement by project is omitted because it is not directly related to the present invention. Server of processing unit 41 and journal input terminals 45, 46, 4
7 and the client of the output terminal 48 are connected by a communication path 49. The journal entry information of daily transactions and the project information of employees related to the journal entry information are stored in the journal entry terminal 45,
46, 47, is sent to the processing unit 41 on the server side via the communication path 49, and the processing unit 41 causes the storage unit 43.
The journal information file stored in and the account account balance file for each project stored in the storage unit 44 are updated.
When the journal entry information is entered at the journal entry terminals 45, 46, 47, the project information corresponding to the journal entry information is also entered. At this time, the project information is acquired from the storage unit 42.

FIG. 5 shows a table structure of the storage unit 42 "employee-project correspondence master" in FIG. The correspondence relationship between employees and projects and the project dependency ratio are retained as allocation ratios.

FIG. 1 shows the processing flow of this embodiment.
Hereinafter, the flow of processing will be described with reference to FIGS. 8, 9, and 10. The user inputs the slip number, slip date, and journal information on the journal input screen (see FIG. 8) displayed on the display unit of one of the journal input terminals 45, 46, 47 (process 11). ). The user specifies the employee who has caused the transaction (journalization) in process 11, and inputs the employee number on the journal entry screen (process 12). The journal entry terminal retrieves the project code, project name, and allocation ratio corresponding to the entered employee number from the "employee-project correspondence master" and displays them on the journal entry screen (process 13). At this time, if there is data corresponding to the employee number, the project information corresponding to the employee number is displayed on the journal entry screen of FIG. 8, and if there is no data corresponding to the employee number, No project information is displayed on the journal entry screen of item 8. It is determined whether or not the project information (project code, project name, allocation ratio) displayed by the process 13 is OK (process 14). If YES, the process proceeds to process 17.

FIG. 8 shows the screen of the display unit of one of the journal input terminals 45, 46, 47 shown in FIG. 4 when the project information displayed on the journal input screen in step 13 is OK. Here is an example. The slip number is input to the input area 81, the slip date is input to the input area 82, and the journal information is input to the input area 83. The employee number of the employee who generated the transaction of the journal information is entered in the input area 84. The project information (project code, project name, allocation ratio) corresponding to the employee number is taken out from the storage unit 42 "employee-project correspondence master" in FIG.
To display.

If the result at step 14 is NO, the process goes to step 15 or 16. In process 15, if it is necessary to change the project information (project code, project name, allocation ratio) displayed in the screen example of FIG. 8, the “check column” assigned to each project code is checked. And the allocation ratio is corrected. Revised,
Proceed to processing 17. An example of the screen in this case is shown in FIG. When the project information displayed in the display area 91 needs to be changed, the check box 92 is checked, and then the value of the allocation ratio 93 is corrected to the allocation ratio to be changed. In this example, the check boxes 92 of the project codes PJ001 and PJ002 are checked, and the allocation ratio 93 is corrected to 50%.

In process 16, if the project information (project code, project name, allocation ratio) displayed in the screen example of FIG. 8 is not desired to be linked to the journal information, the "no project support" button is pressed. , The displayed project information is deleted. After deletion, process 17
Proceed to. An example of the screen in this case is shown in FIG. When it is not desired to associate (link) the project information displayed in the display area 101 with the journal information, the “no project correspondence” button 102 is pressed to delete the project information in the display area 101.

In process 17, the "confirm" button displayed in FIGS. 8, 9 and 10 is pressed. In process 18, either the information displayed on the screen in process 13, the information displayed on the screen in process 14, or the information displayed on the screen in process 15 is transferred to the processing unit 41. That is, the information displayed on the screen by the process 13 is the slip number, the slip date, the journal information, the employee number, and the project information, and the information displayed on the screen by the process 14 is the slip number, the slip date, the journal information, The project information in which the employee number and the allocation ratio have been corrected, and the information displayed on the screen in the process 15 is the slip number, slip date, journal information,
This is the employee number. In processing 19, the processing unit 41 on the server side
However, the journal information file update process and the project-specific account balance file update process are performed based on the transferred information.

FIG. 6 shows a table structure of the storage unit 43 "journalization information file" of FIG. Transaction journal information and corresponding project information (project code and allocation ratio)
Hold. In FIG. 6, the information is updated by the information displayed on the journal entry screen of FIG. 8, and the updated part is the part related to the slip number 00011. The data from the slip number to the amount is the basic data in the accounting system,
The data from the project code 1 to the allocation ratio is data related to project information. In addition, when updated by the information displayed on the journal entry screen of FIG. 9,
PJ00 with project code 1 of slip number 00011
The allocation ratios of 1 and PJ002 of project code 2 are both 50%. If the information displayed on the journal entry screen of FIG. 10 is updated, the slip number 0001
The data from the project code 1 of 1 to the allocation ratio will not be registered.

FIG. 7 shows the table structure of the storage section 44 "project-specific account item balance file" of FIG. Hold balance by project code and account. The balance is calculated by multiplying the amount in the journal information by the allocation ratio for each project and adding it to the balance. Note that, in FIG. 7, the information is updated by the information displayed on the journal entry screen of FIG. 8, and the updated portion is a portion related to domestic travel expenses. The table has items of project code, project name, account, and balance. Further, when the information is updated by the information displayed on the journal entry screen of FIG. 9, the domestic travel expenses of the project code PJ001 and the project code PJ00
The balance of domestic travel expenses for 2 is 25,000. Further, when the information is updated by the information displayed on the journal entry screen of FIG. 10, the data from the project code 1 to the balance regarding domestic travel expenses will not be registered.

[0015]

As described above, according to the present invention, even when a plurality of projects correspond to one transaction (journal entry), the projects can be associated with each other.
The accuracy of profit and loss management by project is improved. Moreover, by inputting the employee number and automatically displaying the project information, the input of the project information can be simplified. In addition, it is possible to prevent omission of input of project information.

[Brief description of drawings]

FIG. 1 is a flowchart showing a flow of processing of an embodiment.

FIG. 2 is a diagram showing an example of correspondence between transaction journal information and a project in the related art.

FIG. 3 is an example of a profit and loss statement for each project in the related art.

FIG. 4 is a configuration diagram of a system according to an embodiment.

FIG. 5 is a diagram showing a data structure of an employee-project correspondence master according to the embodiment.

FIG. 6 is a diagram showing a data structure of a journal information file of the embodiment.

FIG. 7 is a diagram showing a data structure of a project-specific account item balance file according to the embodiment.

FIG. 8 is a diagram showing a screen example in the case of project information “OK” on a journal entry screen.

FIG. 9 is a diagram showing a screen example in the case of project information “change” on the journal entry screen.

FIG. 10 is a diagram showing a screen example in the case of project information “no correspondence” on the journal entry screen.

[Explanation of symbols]

41 Server side processing unit 42 Storage "Employee-Project Master" 43 Storage "Journal Information File" 44 Storage section “Project account balance file” 45 Client-side journal entry terminal 46 Client-side journal entry terminal 47 Client side journal entry terminal 48 Client side output terminal 49 network lines 81 slip number input area 82 Voucher date input area 83 Journal entry information input area 84 Employee number input area 85 Project information display area 86 Confirm button 91 Project information display area 92 Check box 93 Allocation ratio correction area 94 Confirm button 101 Project information display area 102 No project support button 103 Confirm button

   ─────────────────────────────────────────────────── ─── Continued front page    (72) Inventor Masahiro Tachibana             890 Kashimada, Sachi-ku, Kawasaki City, Kanagawa Stock             Hitachi, Ltd. Business Solutions             Within the department (72) Inventor Takahiro Okuda             890 Kashimada, Sachi-ku, Kawasaki City, Kanagawa Stock             Hitachi Industrial Systems Division (72) Inventor Akihiko Utsuki             890 Kashimada, Sachi-ku, Kawasaki City, Kanagawa Stock             Hitachi Industrial Systems Division

Claims (4)

[Claims] 1. An input device, an output device, a processing device,
An employee-project profit / loss management method in an accounting system having a storage device storing a project correspondence master, a journal information file, and a project-specific account balance file, wherein the input device responds to input of journal information by a user. The journal information is displayed on the display screen, and the project information of the employee number is acquired from the employee-project correspondence master stored in the storage device via the processing device according to the input of the employee number of the user, The acquired project information is displayed on the display screen, and the confirmation button is pressed in the display state in which the acquired project information is displayed, or the check column of the acquired project information display screen is checked and the project information is displayed. Confirmation button is pressed in the display state where the allocation ratio of Or, when the confirmation button is pressed in the display state where the project non-correspondence button on the display screen of the acquired project information is pressed, or on the display screen in any of the above display states when the confirmation button is pressed The profit-and-loss management method for each project, characterized in that the data displayed on the screen is transferred to the processing device. 2. The project-based profit and loss management method according to claim 1, wherein the processing device stores a journal information file and a project-specific account item balance file stored in the storage device based on the data transferred from the input device. A profit and loss management method for each project characterized by updating. 3. An accounting system having an input terminal device, an output terminal device, a processing device, an employee-project correspondence master, a storage device storing a journal information file and a project account balance file. The terminal device displays the journal information on the display screen in response to the user's entry of the journal information and the project information of the employee number in response to the user's employee number input via the processing device. Employees stored in the storage device
The means for acquiring from the project correspondence master, the acquired project information, a confirmation button, a project non-correspondence button, a means for displaying a check box for the acquired project information correspondence on the display screen, and the acquired project information are The confirmation button is pressed in the displayed display state, or the confirmation button is pressed in the display state in which the check column of the display screen of the acquired project information is checked and the allocation ratio of the project information is corrected and displayed, or When the confirmation button is pressed in the display state in which the project non-correspondence button on the display screen of the acquired project information is pressed, it is displayed on the display screen in any of the above display states when the confirmation button is pressed. A means for transferring the stored data to the processing device. Accounting system according to claim. 4. A procedure of displaying the entered user's journal information on a display screen, a procedure of reading out project information corresponding to the entered user's employee number from a storage device, and the read out project information. , Confirm button,
No project correspondence button, the procedure to display the check box on the display screen corresponding to the read project information, and the confirmation button is pressed in the display state where the read project information is displayed or the display of the read project information In the display state where the check box on the screen is checked and the allocation ratio of the project information is corrected and displayed, or the confirmation button is pressed, or when the project non-correspondence button on the acquired project information display screen is pressed A program for causing a computer to execute a procedure of, when the confirmation button is pressed, transferring the data displayed on the display screen in any one of the display states when the confirmation button is pressed to the processing device.