JP2018112988A - Journaling preparation device, journaling preparation method, and journaling preparation program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a journaling preparation device, a journaling preparation method, and a journaling preparation program capable of preparing a journaling for each order entry accuracy of each case and forecasting a future profit growth.SOLUTION: In the present embodiment, a journaling is prepared, which is described with selected slip section identification information, case information, and sales schedule amount in sales schedule data combined with an order entry accuracy corresponding to the selected slip section identification information; and cost target identification information in estimation data combined with the combined case target for each identification information and cost target for each estimation amount.SELECTED DRAWING: Figure 3

Description

  The present invention relates to a journal creation device, a journal creation method, and a journal creation program.

  Patent Document 1 discloses a management that enables automatically creating various journal entries for preparing an expected financial statement based on accounting theory from, for example, a monthly amount of expected profit / loss calculation derived from actual data and target values. A system for creating planning materials is disclosed (see paragraph 0008, etc.).

JP 2002-215865 A

  In this way, when a company or the like predicts future revenue, it will make a revenue forecast based on the sales target value or the planned sales amount. It was.

  Specifically, for example, when a plurality of cases are requested from a request source to a certain company, a method is required for predicting revenue by collecting orders according to the order accuracy (degree of confirmation of orders) of each case.

  The present invention has been made in view of the above, and provides a journal creation device, a journal creation method, and a journal creation program that can create journals according to the accuracy of order receipt for each case and estimate earnings.

  In order to solve the above-described problems and achieve the object, a journal creation device according to the present invention is a journal creation device including a control unit and a storage unit, and the storage unit includes case identification information, order accuracy and Link sales schedule data to store and store the estimated sales amount, estimate data to store and store case identification information, expense item identification information, and estimated item by cost item, order accuracy and the corresponding slip classification identification information And the control section stores the selected slip classification identification information and the matter in the sales schedule data associated with the order receipt accuracy corresponding to the selected slip classification identification information. There is a journal creation means for creating a journal in which the identification information and the planned sales amount, and the expense item identification information and the estimated amount for each expense item in the estimate data associated with the associated case identification information are created. Rukoto, characterized by.

  The journal creation method according to the present invention is a journal creation method executed by an information processing apparatus including a control unit and a storage unit. The storage unit associates item identification information, order accuracy, and planned sales amount. The sales schedule data to be stored, the estimate data to be stored by associating the case identification information, expense item identification information and the estimated amount by expense item, and the slip classification to store the order accuracy and the corresponding slip classification identification information. And the item identification information in the sales schedule data associated with the selected slip category identification information and the order receipt accuracy corresponding to the selected slip category identification information, which is stored in the master and executed by the control unit. And a journal creation step for creating a journal that describes the planned sales amount and the item identification information associated with the associated item identification information and the expense item identification information and the estimated amount by expense item associated with the estimated data. It features a.

  A journal creation program according to the present invention is a journal creation program for causing an information processing apparatus including a control unit and a storage unit to execute, and the storage unit stores item identification information, order accuracy, and planned sales amount. A slip that stores the sales schedule data to be linked and stored, the estimate data to be stored by linking the item identification information, the expense item identification information and the estimated amount by cost item, the order accuracy and the corresponding slip classification identification information The item in the sales schedule data associated with the selected slip category identification information to be executed by the control unit and the order accuracy corresponding to the selected slip category identification information is stored. Create a journal that describes the identification information and the planned sales amount, and the expense item identification information and the estimated amount for each expense item in the estimate data that is associated with the associated item identification information. It includes journal creation step that features a.

  According to the present invention, there is an effect that a journal can be created for each order receipt accuracy of each case and a profit can be predicted.

FIG. 1 is a block diagram illustrating an example of a configuration of a journal creation apparatus. FIG. 2 is a diagram illustrating an example of a processing flow according to the present embodiment. FIG. 3 is a diagram illustrating an example of item information data, estimated cost data, slip classification linking master, and provisional slip data.

  DESCRIPTION OF EMBODIMENTS Embodiments of a journal creation apparatus, a journal creation method, and a journal creation program according to the present invention will be described below in detail with reference to the drawings. In addition, this invention is not limited by this embodiment.

[1. Overview]
In the IT (Information Technology) industry, the temporary staffing industry, and the like, the conventional sales system can only recognize revenue based on the actual results of the sales results of the projects.

  Here, for example, a company that outsources a received order by a business consignment contract such as SES (System Engineering Service) has requested to create sales schedule data at the time of inquiry / estimation.

  Therefore, in the present embodiment, for example, by creating journal data as a provisional slip based on the inquiry / estimation information related to each case, it is possible to predict the landing of profit / loss on the income statement.

  Further, in the present embodiment, for example, when creating the provisional slip, the order accuracy is assigned to the inquiry / estimation information related to each case, thereby creating journal data for each order accuracy. It was possible to make a landing prediction. Hereinafter, a specific configuration and operation will be described.

[2. Constitution]
The configuration of the journal creation apparatus 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram illustrating an example of the configuration of the journal creation apparatus 100.

  The journal creation apparatus 100 is a commercially available desktop personal computer. The journal creation apparatus 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, but is a portable type such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer. An information processing apparatus may be used.

  As shown in FIG. 1, the journal creation apparatus 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the journal creation device 100 is connected to be communicable via an arbitrary communication path.

  The communication interface unit 104 communicatively connects the journal creation device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the journal creation device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data stored in the storage unit 106 to be described later may be stored in the server 200.

  An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker (including a home television), a speaker, and a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that realizes a pointing device function in cooperation with the mouse can be used. In the following description, the output device 114 may be described as a monitor 114 as a display unit, and the input device 112 may be described as a keyboard 112 or a mouse 112.

  The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving various instructions to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) and a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk can be used.

  The storage unit 106 includes item information data 106a serving as sales schedule data, estimated cost data 106b serving as estimated data, a slip classification linking master 106c serving as a slip classification master, and provisional slip data 106d. Among these, the provisional slip data 106d is data created by the journal creation unit 102a, and therefore may or may not be included in the storage unit 106.

  Hereinafter, each item included in the case information data 106a, the estimated cost data 106b, and the slip classification linking master 106c will be described with reference to FIG. 3, but the description in parentheses after each item is a specific example of each item. FIG. 3 shows a specific example of this. For example, when the planned sales amount (order amount) is described, it means that the order amount is given as a specific example of the planned sales amount.

  In the following description, it is assumed that a company that has received an order from Project A to Project D outsources Project A to another company.

  The case information data 106a stores, for example, information related to the order received from the request source. Specifically, as shown in FIG. 3, the case information data 106a stores case identification information (case name), order receipt accuracy (accuracy), and planned sales amount (order amount) in association with each other. In addition to these items, the item information data 106a may include items such as inquiry / order category information, order month, and sales month as shown in FIG.

  The order accuracy is the degree of confirmation of an order, and the higher the order accuracy, the closer the order is to a confirmed state. In FIG. 3, the order accuracy is higher in the order of accuracy A, accuracy B, and accuracy C. The order accuracy is not limited to an expression with a rank of accuracy A to C, and may be an expression with a specific numerical value such as a percentage. The planned sales amount is the planned sales amount for the case. The inquiry / order receiving category information is a category indicating whether the matter is in the inquiring stage or in the stage where the order has been received. The order month and the sales month are a month when the order is received and a month when sales are recorded for the case, respectively.

  The estimated cost data 106b stores, for example, an estimate of the cost required to process a case ordered from a request source. Specifically, as shown in FIG. 3, the estimated cost data 106 b stores case identification information (case name), expense item identification information (expense item), and estimated amount (amount) for each expense item in association with each other. In addition to these items, the estimated cost data 106b may include items such as a recording month as shown in FIG.

  The expense item identification information is a type of each expense related to the case, and includes, for example, an outsourcing expense, an expense, etc., as shown in FIG. The estimated amount for each expense item is an estimated amount for each of the expense item identification information. The recording month is a month in which an expense is recorded for the expense item identification information.

  As shown in FIG. 3, the slip category linking master 106c stores the order accuracy (accuracy) and the corresponding slip category identification information in association with each other. In addition to these items, the slip category linking master 106c may include an item of category information for inquiries / orders as shown in FIG. As shown in FIG. 3, the slip category identification information is at least one of a slip category and a slip category name.

  The control unit 102 is a CPU that controls the journal creation apparatus 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, and necessary data, and performs various information processing based on these stored programs. Run.

  The control unit 102 functionally conceptually (1) selected item classification identification information, and item identification information and planned sales amount in the sales schedule data associated with the order accuracy corresponding to the selected item classification identification information. A journal creation unit 102a as a journal creation unit that creates a journal in which the item identification information and the cost item identification information in the estimate data and the estimated amount according to the cost item are associated, and (2) journal replacement Part 102b. Among these, the journal replacement unit 102b is an optional component, but is preferably included in the control unit 102. The details of the processing executed by each unit are described in [3. Specific Example of Processing] will be described in detail.

[3. Specific example of processing]
Hereinafter, a specific example of processing according to the present embodiment will be described with reference to FIGS. 2 and 3. FIG. 2 is a diagram illustrating an example of a processing flow according to the present embodiment. FIG. 3 is a diagram illustrating an example of item information data, estimated cost data, slip classification linking master, and provisional slip data.

  The outline of this embodiment will be described with reference to FIG. First, as shown in FIG. 2, by performing estimate management, order management, and sales management, case information data 106a and estimated cost data 106b for each department, month, and accuracy are created. In addition, a plurality of provisional slip categories (slip category identification information) is created, and a slip category linking master 106c is created that is linked to the accuracy grade. Then, by selecting the temporary slip category (slip category identification information) in the slip category linking master 106c, a report of each accuracy grade, that is, an expected profit / loss statement of accuracy A, accuracy B, accuracy C is created. be able to. Details of this embodiment will be described below with reference to FIG.

(Journal creation process)
The journal creation unit 102a creates a journal in which the selected slip classification identification information is described. Specifically, in FIG. 3, it is assumed that the slip classification “21” is selected as the slip classification identification information. In this case, as shown in the provisional slip data 106d in FIG. 3, the journal creation unit 102a creates five slips in which “21” is written in the slip classification item. Note that the selected slip category identification information may be a slip category name instead of a slip category.

  Further, the journal creation unit 102a uses the item identification information and the planned sales amount in the item information data 106a associated with the order receipt accuracy (accuracy A) corresponding to the selected item classification identification information (the item classification “21”). A journal in which “Matter A” and “1,000,000” are written is created as shown in the slip of slip number 00000005 of the provisional slip data 106d in FIG. Specifically, in the slip of slip number 00000005 in FIG. 3, “Matter A” is described in the slip summary item, and “1,000,000” is described in the debit amount and credit amount items.

  Then, the journal entry creating unit 102a uses the “subcontract costs” and “200,” in the recording month September as the expense item identification information and the estimated amount by expense item in the estimated cost data 106b associated with the associated item identification information (case A). "000", "Expenses" and "30,000" in September, "Outsourcing costs" and "200,000" in October, and "Expenses" and "30,000" in October The journal entries are created as shown in the slips with slip numbers 00000001 to 00000004 in the provisional slip data 106d in FIG. Specifically, for example, in the slip of the slip number 00000001 corresponding to the subcontracting cost in September recorded in the estimated cost data 106b, “subcontracting cost” is described in the item of the debit account item, and the debit amount and the credit amount "200,000" is described in the item.

  In this way, the journal creation unit 102a can create a journal for the order accuracy A. Note that there are the following points of concern regarding this embodiment.

  First, in the present embodiment, a case has been described where journal entries relating to order receipt accuracy A are created. However, journal entries relating to order receipt accuracy B and order receipt accuracy C are not shown, but can be created in the same manner.

  Next, the order in which the journal creation unit 102a creates each item included in the provisional slip data 106d is the slip classification identification information, the case identification information, the planned sales amount, the expense item identification information, and the expense item described in the present embodiment. It is not limited to the order of other estimated amounts.

  The journal created by the journal creation unit 102a is not limited to the slip format in which the debit account item and the credit account item are described, as shown in the provisional slip data 106d in FIG. 3, for example, as shown in FIG. It may be in the form of an income statement.

(Journal replacement processing)
When the slip classification identification information is selected in the next operation, the journal replacement unit 102b deletes the existing provisional slip data 106d after saving it in the history table, and replaces it with the latest provisional slip data 106d every time the operation is performed. Thereby, the operator can always refer to the journal created from the latest sales schedule and the latest estimated amount.

  As described above, according to the journal creation apparatus 100 according to the present embodiment, it is possible to create a journal for each order accuracy for each case and to make a profit forecast.

[4. Other Embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

  For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be performed manually, or all of the processes described as being performed manually are all performed. Alternatively, a part can be automatically performed by a known method.

  In addition, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in the present specification and drawings, unless otherwise specified. Can be changed arbitrarily.

  Further, regarding the journal creation apparatus 100, each illustrated component is functionally conceptual and does not necessarily need to be physically configured as illustrated.

  For example, the processing functions provided in the journal creation device 100, particularly the processing functions performed by the control unit 102, are realized entirely or arbitrarily by a CPU and a program interpreted and executed by the CPU. It may also be realized as hardware by wired logic. Note that the program is recorded on a non-transitory computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the processing described in the present embodiment. 100 mechanically read. In other words, in a storage unit such as a ROM or a HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

  The computer program may be stored in an application program server connected to the journal creation apparatus 100 via an arbitrary network, and may be downloaded in whole or in part as necessary. is there.

  In addition, a program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the “recording medium” refers to a memory card, USB (Universal Serial Bus) memory, SD (Secure Digital) card, flexible disk, magneto-optical disk, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (registration). Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk, etc.), DVD (Digital Digital, Trademark) Any “portable physical media It is intended to include. Therefore, a recording medium storing a program for executing the processing or processing method described in this specification also constitutes the present invention.

  The “program” is a data processing method described in an arbitrary language or description method, and may be in any form such as source code or binary code. Note that the “program” is not necessarily limited to a single configuration, and functions are achieved in cooperation with a separate configuration such as a plurality of modules and libraries or a separate program represented by the OS. Including things. In addition, a well-known structure and procedure can be used about the specific structure and reading procedure for reading a recording medium in each apparatus shown to embodiment, the installation procedure after reading, etc.

  Various databases and the like stored in the storage unit 106 are storage devices such as a memory device such as a RAM and a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk. Programs, tables, databases, web page files, and the like.

  The journal creation apparatus 100 may be configured as an information processing apparatus such as a known personal computer or workstation, or may be configured as the information processing apparatus connected to an arbitrary peripheral device. Further, the journal creation device 100 may be realized by installing software (including a program or data) that realizes the processing described in the present embodiment in the device.

  Furthermore, the specific form of distribution / integration of the devices is not limited to that shown in the figure, and all or a part of them may be functionally or physically in arbitrary units according to various additions or according to functional loads. It can be configured to be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and may be selectively implemented.

  The present invention is particularly useful in the IT industry, the temporary staffing industry, and the like.

100 Journal creation device
102 Control unit
102a Journal creation section
102b Journal entry replacement part
104 Communication interface
106 Storage unit
106a Item information data
106b Estimated cost data
106c Document classification pegging master
106d provisional slip data
108 Input / output interface
112 Input device
114 Output device 200 Server 300 Network

Claims (3)

A journal creation device including a control unit and a storage unit,
In the storage unit,
Sales schedule data that stores the project identification information, the order accuracy, and the planned sales amount,
Estimate data to be stored by associating the case identification information, expense item identification information and the estimated amount by expense item,
A slip classification master that stores and stores the order accuracy and the corresponding slip classification identification information;
Is stored,
The controller is
The selected slip class identification information,
Matter identification information and planned sales amount in the planned sales data associated with the order accuracy corresponding to the selected slip classification identification information,
Expense item identification information in the estimate data associated with the matter identification information to be associated and the estimated amount by expense item,
A journal creation means for creating a journal with
Journal creation device characterized by A journal creation method executed by an information processing apparatus including a control unit and a storage unit,
In the storage unit,
Sales schedule data that stores the project identification information, the order accuracy, and the planned sales amount,
Estimate data to be stored by associating the case identification information, expense item identification information and the estimated amount by expense item,
A slip classification master that stores and stores the order accuracy and the corresponding slip classification identification information;
Is stored,
Executed by the control unit,
The selected slip class identification information,
Matter identification information and planned sales amount in the planned sales data associated with the order accuracy corresponding to the selected slip classification identification information,
Expense item identification information in the estimate data associated with the matter identification information to be associated and the estimated amount by expense item,
Including a journal creation step that creates a journal with
A journal creation method characterized by A journal creation program for causing an information processing apparatus including a control unit and a storage unit to execute,
In the storage unit,
Sales schedule data that stores the project identification information, the order accuracy, and the planned sales amount,
Estimate data to be stored by associating the case identification information, expense item identification information and the estimated amount by expense item,
A slip classification master that stores and stores the order accuracy and the corresponding slip classification identification information;
Is stored,
For causing the control unit to execute,
The selected slip class identification information,
Matter identification information and planned sales amount in the planned sales data associated with the order accuracy corresponding to the selected slip classification identification information,
Expense item identification information in the estimate data associated with the matter identification information to be associated and the estimated amount by expense item,
Including a journal creation step that creates a journal with
A journal creation program characterized by

Images