JP2017168087A - Expense journalizing automatic generation device, expense journalizing automatic generation method, and expense journalizing automatic generation program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an expense journalizing generation device, an expense journalizing generation method and an expense journalizing generation program which enables management judgment in an early stage since a profit estimate after sales settlement can be calculated in an early stage by master-registering expected expense calculation contents such as house rent to be claimed, on the basis of an actual sales amount.SOLUTION: A sales amount for each section is acquired, and on the basis of the acquired sales amount and expense calculation contents, journalizing data on an estimated expense for each section is generated.SELECTED DRAWING: Figure 2

Description

  The present invention relates to an expense journal automatic creation apparatus, an expense journal automatic creation method, and an expense journal automatic creation program.

  Patent Document 1 describes a management plan document creation system for creating a management plan document by a computer, which is composed of sales, cost and overhead costs for the current fiscal year based on the input target amount based on actual data. Create a monthly forecast income statement based on operating profit, create forecast slip data from the created monthly forecast income statement using the slip creation code table and journal slip condition table, Create slip data for factors affecting the current fiscal year (for example, balance of accounts payable and trade accounts receivable) from the balances, etc., create necessary forms such as expected financial statements from the created slip data, and make non-operating / extraordinary gains / losses A system for creating business plan materials for creating a slip is disclosed.

JP 2002-215865 A

  In the above Patent Document 1, by preparing consistent management information based on management policy in advance, the future prediction of corporate management is theoretically planned and formulated with management figures, and the prediction is actually managed. In terms of funding, it is possible to analyze the current situation and take measures by grasping the monthly funding situation in advance, discovering and dealing with management problems at an early stage, and comparing forecasts with actual results. This information will be reflected in the next plan. However, if an attempt is made to use an amount that is actually determined for the sales amount, the determination of expenses is delayed, and the calculation of profits is also delayed, so there is a problem that management judgment cannot be made early.

  The present invention has been made in view of the above-mentioned problems, and is based on the actual sales amount, and by registering the expected cost calculation contents such as rent to be claimed as a master, the profit after the sales are determined It is an object of the present invention to provide an expense journal automatic creation device, an expense journal automatic creation method, and an expense journal automatic creation program that enable an approximate value to be calculated early and enable early management judgment.

  In order to solve the above-described problems and achieve the object, an expense journal automatic creation device according to the present invention is an expense journal automatic creation device including a storage unit and a control unit, and the storage unit is provided for each department. Expense calculation content storage means for storing a departmental expense master in which expense calculation details of expenses in the relevant department are registered, which is charged based on the sales amount of the department, and the control unit calculates the sales amount for each department. A sales acquisition means for acquiring, and journal generation means for generating journal data relating to the estimated expenses for each department based on the sales amount acquired by the sales acquisition means and the contents of the expense calculation. And

  In the expense journal automatic creation device according to the present invention, the journal creation means further calculates the estimated profit for each department based on the sales amount acquired by the sales acquisition means and the estimated expense for each department. It is characterized by calculating.

  Further, in the expense journal automatic creating apparatus according to the present invention, the storage unit stores department expense item storage means for storing a department expense item master set as to which item is used for journalizing the estimated expense, The journal creation means further creates journal data relating to the approximate cost for each department according to the course set in the departmental expense course master.

  Further, the expense journal automatic creating method according to the present invention is an expense journal automatic creating method for causing an expense journal automatic creating apparatus including a storage unit and a control unit to execute, and the storage unit stores sales for each department. Expense calculation content storage means for storing the expense master data for each department in which the expense calculation contents of calculation in the relevant department are registered based on the amount of money, and the sales amount for each department to be executed by the control unit A sales acquisition step of acquiring, and a journal generation step of generating journal data relating to the approximate expenses for each department based on the sales amount acquired in the sales acquisition step and the contents of the expense calculation. And

  An expense journal automatic creation program according to the present invention is an expense journal automatic creation program for causing an expense journal automatic creation apparatus including a storage unit and a control unit to execute, and the storage unit stores sales for each department. Expense calculation content storage means for storing a divisional expense master in which the expense calculation content of calculation in the relevant department is registered, which is charged based on the amount, and the control unit acquires the sales amount for each department And a journal creation step of creating journal data relating to the estimated expenses for each department based on the sales amount acquired in the sales acquisition step and the details of the expense calculation. To do.

  According to the present invention, based on the actual sales amount, by registering the expected cost calculation contents such as rent to be charged as a master, it is possible to calculate the profit approximate value after the sales are determined at an early stage. This has the effect of making management decisions possible.

FIG. 1 is a diagram showing an example of an accounting information system using an expense journal automatic creation apparatus. FIG. 2 is a block diagram showing an example of the configuration of the automatic expense journal creation apparatus. FIG. 3 is a flowchart showing an example of processing of the expense journal automatic creating apparatus according to this embodiment. FIG. 4 is a diagram illustrating an example of a monthly settlement provisional journal creation screen. FIG. 5 is a diagram showing an example of a table layout of the departmental expense master and departmental expense item master. FIG. 6 is a diagram illustrating an example of rent calculation. FIG. 7 is a diagram illustrating an example of a processing image of the monthly settlement provisional journal creation processing.

  Embodiments of the present invention will be described in detail with reference to the drawings. In addition, this invention is not limited by this embodiment.

[1. Overview]
The outline of the present invention will be described with reference to FIG. FIG. 1 is a diagram showing an example of an accounting information system using an expense journal automatic creation apparatus.

  Conventionally, when expenses that are billed based on sales information are reported later, it is difficult to account for approximate expense journals even if an approximate charge amount (expense amount for the company) can be assumed Met. For this reason, it was not possible to grasp the rough estimate of profit (particularly, profit calculation by department (store)), and management decisions could not be made until the monthly settlement was finalized.

  On the other hand, in the present embodiment, expense calculation contents such as rent charged based on the sales amount can be master-registered, and an accounting journal can be automatically created based on the sales information and the registered master information. . As a result, in this embodiment, it becomes possible to immediately record the journal of expenses, and finally calculate the estimated profits after the sales are confirmed, so that the profits can be grasped at an early stage, thereby making it possible to speed up the management judgment.

For example, in the present embodiment, as a countermeasure against the monthly or annual settlement work early proposal,
(1) As a mechanism to link the pre-confirmation data of the host system as a provisional slip (purchase / inventory, etc.), even before the confirmation, the journal data is linked to financial accounting as a provisional slip, and after the amount is confirmed, Journal entries may be linked as this slip. Further, in the present embodiment, (2) as provisional creation of expense data such as store rent, provisional expense data may be automatically created without waiting for the arrival of “invoice / calculation” from a shopping center or the like. Good. Further, in this embodiment, (3) as a monthly settlement document creation in the rough estimate with this slip + provisional slip, it is possible to grasp the profit and loss by store based on the approximate numerical value in the provisional slip without waiting for the final data It may be.

  Specifically, as shown in FIG. 1, sales data is sent from various systems to the accounting information system, and the sales data itself is linked on the 1st to 10th days after the moon dawns. For example, when a shopping center roadside store is notified about invoices and / or calculations as a source of expenses around the middle of the following month, until then, until those documents arrive Could not finalize monthly settlement.

  Therefore, as shown in FIG. 1, in the present embodiment, based on sales data (monthly indeterminate data: for preliminary reports) linked early, based on preliminary sales by a program that calculates provisional expense data. Expenses (approximate expenses) are automatically calculated, provisional journal entries are made, and monthly settlement materials (breaking news) can be calculated. Therefore, early management decisions can be made in about seven days on the first business day of the month. Note that the final confirmed amount will be after a formal invoice and / or financial statement is notified as usual.

[2. Constitution]
An example of the configuration of the automatic expense journal creation apparatus 100 in this embodiment will be described with reference to FIG. FIG. 2 is a block diagram illustrating an example of the configuration of the expense journal automatic creating apparatus 100.

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

  The expense journal automatic creating apparatus 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the expense journal automatic creating apparatus 100 are communicably connected via an arbitrary communication path.

  The communication interface unit 104 communicatively connects the expense journal automatic 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 expense journal automatic creating apparatus 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).

  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 a departmental expense master 106a, a departmental expense subject master 106b, and a journal data file 106c.

  The departmental expense master 106a is a departmental expense master that is charged on the basis of the sales amount for each department and in which the expense calculation contents of the expense in the department are registered. Here, the departmental expense master 106a stores a department code, a rent calculation method, a rent amount, an auxiliary subject code, a sales guarantee amount, a rent ratio, a subject amount, a subject category, a credit item number, and / or a company number, etc. You may do it. The department may be a store or a floor.

  The departmental expense item master 106b is a departmental expense item master set as to which item is used for journalizing the estimated expense. Here, the departmental expense item master 106b includes key items, general account item codes, auxiliary item codes, auxiliary breakdown item codes, business partner codes, tax categories, tax-included categories, analysis codes, fund codes, project codes, and analysis customization codes. , Summary, and / or company number may be stored.

  The journal data file 106c stores journal data. Here, the journal data may include journal detail data.

  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 the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

  The control unit 102 is a CPU or the like that comprehensively controls the expense journal automatic creating apparatus 100. 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 includes a sales acquisition unit 102a and a journal creation unit 102b in terms of functional concept.

  The sales acquisition unit 102a acquires the sales amount for each department.

  The journal creation unit 102b creates journal data related to the approximate cost for each department based on the sales amount and expense calculation content acquired by the sales acquisition unit 102a. Here, the journal creation unit 102b may further calculate an approximate profit for each department based on the sales amount acquired by the sales acquisition unit 102a and the approximate cost for each department. Further, the journal creation unit 102b may create journal data relating to the estimated expenses for each department according to the course set in the departmental expense course master 106b. Further, the journal creation unit 102b may store approximate cost data, approximate journal data, and / or approximate profit data of approximate profit in the journal data file 106c.

[3. Concrete example]
A specific example of this embodiment will be described with reference to FIGS.

[Expense journal automatic creation process]
Here, with reference to FIG. 3, an example of the expense journal automatic creation process in the present embodiment will be described. FIG. 3 is a flowchart showing an example of processing of the expense journal automatic creating apparatus 100 in the present embodiment.

  As shown in FIG. 3, the sales acquisition unit 102a acquires the sales amount for each store (step SA-1).

  The journal creation unit 102b then stores the store based on the sales amount acquired by the sales acquisition unit 102a, the expense calculation content registered in the departmental expense master 106a, and the course set in the departmental expense subject master 106b. Journal data on the estimated expenses for each store is created, the estimated profit for each store is calculated based on the sales amount acquired by the sales acquisition unit 102a and the estimated expenses for each store, and the estimated profit data of the journal data and estimated profit is The journal data file 106c is stored (step SA-2), and the process is terminated.

  Here, with reference to FIG. 4, an example of a provisional journal creation screen for monthly settlement in the present embodiment will be described. FIG. 4 is a diagram illustrating an example of a monthly settlement provisional journal creation screen.

  As shown in FIG. 4, in the screen for creating a provisional (estimated) journal for monthly settlement in the present embodiment, an average value of expenses, etc. required every month is calculated from data of the latest 12 months of the reference date, (Approximate) data can be created. In addition, in the monthly closing provisional journal creation screen shown in FIG. 4, after inputting the conditions for the reference date and the target department according to the registered contents of the departmental expense master 106a of FIG. By pressing, provisional (estimated) journal data can be recorded on the accounting information system in the present embodiment. Here, on the provisional journal creation screen for monthly settlement shown in FIG. 4, the base date (data creation date), slip classification (provisional slip classification), occurrence date, target period (note that the initial value is the closest to the base date) December is preset), the department (journal creation target department (store)), and the subject can be specified. In addition, in the monthly settlement provisional journal creation screen shown in FIG. 4, journal data having the contents registered in the departmental expense master 106a can be created. In addition, in the provisional journal creation screen for monthly settlement shown in Fig. 4, at the time of execution, it is mandatory to specify the slip category, the date of occurrence and the target period, and if necessary, the department, item and slip category are extracted for the target slip. It can be carried out. Further, on the monthly settlement provisional journal creation screen shown in FIG. 4, the created provisional (approximate) journal can be received by the journal external acceptance data acceptance process.

  An example of the departmental expense master 106a and the departmental expense item master 106b in the present embodiment will be described with reference to FIG. FIG. 5 is a diagram illustrating an example of a table layout of the departmental expense master 106a and the departmental expense item master 106b.

  The expense journal automatic creating apparatus 100 according to the present embodiment performs calculation based on sales information (such as journal entry details of sales) and master information in which expense calculation contents such as rent charged based on the sales amount are registered in advance. And provisional slips can be created automatically. Here, as shown in FIG. 5, No. of the departmental expense master 106a used in the present embodiment. 14 to 23, “Course Amount 1 to 10” is the No. of the departmental expense subject master 106b. As described in “Key Item” in FIG. 1, “Assuming that 1 to 10 are used”, both masters are linked on the system. For example, the No. of the departmental expense master 106a on the left side. If the number of “10,000 yen” is entered in 14 item amounts 1, an amount of “10,000 yen” is recorded, and to which account item it is used, “ By acquiring the general account item code of the general account item whose key item “1” is “1”, the account item is specified. In this way, the expense item master 106b for each department is used to tentatively account for the expense and to determine in which item it should be dropped.

  Further, as shown in FIG. 5, the No. of the departmental expense master 106a used in the present embodiment. 24 to 33, “Category Category 1 to 10” is the same as “Course Amount 1 to 10”, and the No. of the departmental expense subject master 106b. It is associated with 1 “key item” on the system. For this reason, for example, the No. of the departmental expense master 106a on the left side. When a value is set for 24 item categories 1, the account item is the account item set as “key item = 1” in the departmental expense item master 106b. The credit item in the journal is determined by the “credit item number” in the departmental expense master 106a. For example, when “11” is set here, the No. of the departmental expense item master 106b is set. The subject is determined by referring to the row of 34 “key item = 11”.

  Here, with respect to the “rent calculation method” registered in the departmental expense master 106a in FIG. 5, in the case of method 2 (XX method) that calculates based on sales, the rent is calculated according to the amount of sales. According to the rule of the guaranteed sales amount, the rent is determined by the guaranteed sales amount × the rent ratio (for example, 8%) even if the sales do not reach that amount. Specifically, in method 2 (XX method), the sales amount “1220: Accounts receivable (retail)” is acquired and “sales compensation amount 2” and “rent ratio 2.3” are entered. No, even if “sales> sales compensation amount 1 rent = sales x rent ratio 1” or “sales ≦ sales compensation amount 1 rent = sales compensation amount 1 × rent ratio 1” Good. Further, regarding the “rent calculation method” registered in the departmental expense master 106a in FIG. 5, in method 3 (ΔΔΔ method), the sales amount is “1220: Accounts receivable (retail) +1230: Accounts receivable (credit)”. The amount can be acquired and all items can be entered. If “sales compensation amount 1 <sales ≦ sales compensation amount 2, rent = (sales compensation amount 1 × rent ratio 1) + ((sales−sales compensation amount 1) × Rent ratio 2) "," Sales compensation amount 2 <If sales, rent = (sales compensation amount 1 x rent proportion 1) + ((sales compensation amount 2-sales compensation amount 1) x rent proportion 2) + ((sales -Sales compensation amount 2) x rent ratio 3) "or" other than that, rent = sales x rent ratio 1 ". In this embodiment, when a value larger than 0 is registered in other subject fixed 1 to 10, journals may be recorded with a fixed amount for the subject subject, and other subjects average 1 to 10 is larger than 0. If the value is registered, the average amount within the month specified on the range specification screen for the subject course may be counted.

  Here, in this embodiment, basic information for automatically calculating expenses for each department (by store) can be registered in the department-specific expense master 106a, and up to 10 subjects other than rent can be registered. It may be possible. In the present embodiment, courses may be managed by the internal master (department expense course master 106b). In the present embodiment, the revision month function and the screen registration function are not required, and if input / output is performed in EXCEL (registered trademark), it is possible to flexibly deal with a logic change or the like. Therefore, data in EXCEL (registered trademark) Maintenance may be performed by input.

  An example of rent calculation in the present embodiment will be described with reference to FIG. FIG. 6 is a diagram illustrating an example of rent calculation.

  The case of the XX Osaka store on the left side of FIG. 6 shows a case where the sales did not reach the sales guarantee amount. As a result, the rent amount is “sales guarantee amount 1 (7,557,500) × rent Ratio (8%) = Rent (604,600) ”. In the case of XX Tokyo store shown on the right side of Fig. 6, there are two stages of sales guarantee, and the rent calculation method is divided into three types according to the comparison result between the sales price and the sales guarantee. Is shown. In this way, a calculation method is adopted in which the rent is determined depending on the amount of sales.

  In addition, an example of monthly settlement provisional journal creation processing in the present embodiment will be described with reference to FIG. FIG. 7 is a diagram illustrating an example of a processing image of the monthly settlement provisional journal creation processing.

  As shown in Fig. 7, when creating a provisional journal for monthly settlement, the master table layout for registering basic information for automatically calculating expenses for each department (for each store) is roughly divided into departmental expenses. There are two types: a master 106a and a departmental expense item master 106b. The departmental expense master 106a is a master for registering expense information for each department (for each store), and the departmental expense item master 106b is a master for registering items used in this processing. Here, in the departmental expense master 106a, which rent calculation method is adopted for each department (by store) may be registered in advance. Further, the departmental expense subject master 106b can register information such as IDs, subjects, and the like for the subjects used so that it is determined what auxiliary subjects are used for journalizing.

  In the development part on the left side of FIG. 7, provisional journal data for monthly settlement is created based on the departmental expense master 106a, departmental expense item master 106b, and sales information, and the provisional journal data is created on the right side of FIG. Journal detail data is created by importing in the standard part.

  Then, the monthly settlement provisional journal creation program described in the development part on the left side of FIG. 7 is associated with the departmental expense master 106a and the departmental expense item master 106b. Here, as shown in FIG. 7, two departments (stores) A and B are registered in the departmental expense master 106a, and the “rent system” (1 or 2) is assigned to each department (store). ) Is set. In addition, if there is a “rent amount”, it is possible to record a journal as a fixed amount by registering it. Furthermore, the ID numbers described in “sales guarantee” and “credit” are ID numbers 11 of the table (lower table in the development part of FIG. 7) linked to the departmental expense item master 106b: current account, ID Number 12: Since it is registered like a savings account, the credit item when it is actually entered is in the form of a checking account and savings account. When these buttons are entered and the execution button is pressed, journal entries for debit and credit expenses are recorded as shown in the standard part table (standard part in FIG. 7).

  As described above, in this embodiment, the rent has been described as an example of the expense, but it is not necessarily limited to this, and even if the expense is a repair expense, a lease fee, etc., the estimated profit value after the sales are determined in the same manner. Can be calculated early. However, in the case of rent, although it is a certain amount every month, repair costs and lease fees may fluctuate depending on the month, but if they are arranged side by side, it can be recorded in an average form to some extent . In this way, when calculating expenses other than rent, for example, in the table layout of the departmental expense master 106a in FIG. 5, registration of a fixed amount that records a certain amount every month (for example, 10,000 yen) is recorded. When performing, in this embodiment, you may use "subject amount 1-10". In addition, in the present embodiment, “subject divisions 1 to 10” may be used in the case where a monthly average amount is calculated such that the amount charged for expenses generated every month is averaged from the actual results. In addition, as an actual period when taking an average and calculating, for example, as shown in FIG. 4, the average value is calculated from the data of the latest 12 months of the target year and month, and temporary data is created. Without being limited thereto, the average value may be calculated with the latest fixed period as the actual period. Further, the No. of the departmental expense master 106a in FIG. A “credit item number” for setting a credit item associated with the expense item master can be registered in 34. This “credit subject number” corresponds to, for example, ID numbers “11” and “12” described in the ID number and credit in the development part table of FIG.

[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 expense journal automatic creating apparatus 100, each illustrated component is functionally conceptual and does not necessarily need to be physically configured as illustrated.

  For example, all or some of the processing functions provided in the automatic expense journal creation apparatus 100, particularly the processing functions performed by the control unit 102, are realized by the CPU and a program interpreted and executed by the CPU. Alternatively, it may be realized as hardware by wired logic. Note that the program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing the information processing apparatus to execute the processing described in this embodiment. It is mechanically read by the creation device 100. 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.

  Further, this computer program may be stored in an application program server connected to the expense journal automatic creating apparatus 100 via an arbitrary network, and may be downloaded in whole or in part as necessary. Is possible.

  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), DVD (Digital Digital, Trademark) Any “portable physical media It is intended to include.

  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 means 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.

  Further, the expense journal automatic creating 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 to which an arbitrary peripheral device is connected. Further, the expense journal automatic creating apparatus 100 may be realized by installing software (including a program or data) for realizing the processing described in the present embodiment in the apparatus.

  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 case where, even when expenses charged based on sales information are followed, expenses are journalized immediately, profits are roughly calculated, and management is judged at an early stage.

DESCRIPTION OF SYMBOLS 100 Expense journal automatic creation apparatus 102 Control part 102a Sales acquisition part 102b Journal creation part 104 Communication interface part 106 Memory | storage part 106a Expense master according to department 106b Expense subject master according to department 106c Journal data file 108 Input / output interface part 112 Input device 114 Output device 200 server 300 network

Claims (5)

An expense journal automatic creation device having a storage unit and a control unit,
The storage unit
Expense calculation content storage means for storing an expense master data by department in which expense calculation contents of expenses in the relevant department are registered, which are charged based on the sales amount for each department,
With
The controller is
Sales acquisition means for acquiring the sales amount for each department;
Journal creation means for creating journal data relating to estimated expenses for each department based on the sales amount acquired by the sales acquisition means and the expense calculation content;
A device for automatically creating expense journals. The journal creation means is:
2. The expense journal automatic creating apparatus according to claim 1, further comprising: calculating an approximate profit for each department based on the sales amount acquired by the sales acquisition unit and the approximate expense for each department. The storage unit
Department-specific expense item storage means for storing a department-specific expense item master that is set as to which item is used for journalizing the estimated expense,
Further comprising
The journal creation means is:
3. The expense journal automatic creating apparatus according to claim 1 or 2, wherein journal data relating to the estimated expense for each department is created according to the course set in the departmental expense course master. An expense journal automatic creation method for causing an expense journal automatic creation device having a storage unit and a control unit to execute,
The storage unit
Expense calculation content storage means for storing an expense master data for each department in which the expense calculation contents of calculation in the relevant department are registered, which is charged based on the sales amount for each department,
With
To be executed by the control unit;
A sales acquisition step of acquiring a sales amount for each department;
A journal creation step for creating journal data relating to the approximate cost for each department based on the sales amount acquired in the sales acquisition step and the expense calculation content;
A method for automatically creating expense journals, comprising: An expense journal automatic creation program for causing an expense journal automatic creation device having a storage unit and a control unit to execute,
The storage unit
Expense calculation content storage means for storing an expense master data for each department in which the expense calculation contents of calculation in the relevant department are registered, which is charged based on the sales amount for each department,
With
In the control unit,
A sales acquisition step of acquiring a sales amount for each department;
A journal creation step for creating journal data relating to the approximate cost for each department based on the sales amount acquired in the sales acquisition step and the expense calculation content;
Expense journal automatic creation program to execute.

Images