JP7431712B2 - Income and expenditure management device, income and expenditure management method, and income and expenditure management program - Google Patents

Description

The present invention relates to an income and expenditure management device, an income and expenditure management method, and an income and expenditure management program.

For example, in the temporary staffing industry, there is a task of calculating monthly income and expenditure for each project. For example, there is Patent Document 1 as a system for managing monthly income and expenditure in the temporary staffing industry.

JP 2018-139053 Publication

However, in Patent Document 1, when managing both staff salaries and sales, the burden on the person in charge is reduced by calculating the sales amount for the next month and calculating the sales amount according to the salary deadline. , there is no mention of shortening the period until monthly income and expenditure amounts can be confirmed.

The present invention has been made in view of the above, and when managing both staff salaries and sales, it is possible to calculate the sales amount for the next month and calculate the sales amount according to the salary deadline. The present invention aims to provide an income and expenditure management device, an income and expenditure management method, and an income and expenditure management program that can reduce the burden on a person in charge and shorten the period until monthly income and expenditure amounts can be confirmed.

In order to solve the above-mentioned problems and achieve the objects, the present invention provides an income and expenditure management device that includes a control section and manages salaries and sales of staff in the temporary staffing industry, the control section controlling the payroll deadline. The present invention is characterized by having a sales recording means for recording provisional sales for a period within the payroll closing period but outside the sales closing period for the current month when the sales closing period is different.

Further, according to one aspect of the present invention, in the case of a person with a monthly salary, the sales recording means calculates the provisional sales amount as follows: provisional sales amount = monthly salary amount x number of working days in the next month / number of working days in the next month. Good too.

Further, according to one aspect of the present invention, in the case of an hourly wage worker, the sales recording means may calculate the provisional sales amount by multiplying the hourly wage amount by the next month's working hours.

According to one aspect of the present invention, the sales recording means may process the previous month's provisional sales amount as a red slip.

Moreover, in order to solve the above-mentioned problems and achieve the purpose, the present invention provides an income and expenditure management method executed by an information processing device including a control unit, the method including: If the closing period for sales is different from the closing period for sales, the present invention is characterized by including a sales recording process of recording provisional sales for the period within the closing period for payroll but outside the closing period for sales for the current month.

Further, in order to solve the above-mentioned problems and achieve the objects, the present invention provides an income and expenditure management program executed by an information processing device including a control section, in which the control section manages salary cut-off period and sales. The present invention is characterized in that it is an income and expenditure management program for executing a sales recording process of recording provisional sales for the period within the payroll closing period and outside the sales closing period for the current month when the closing periods are different.

According to the present invention, when managing both staff salaries and sales, the burden on the person in charge can be reduced by calculating the sales amount for the next month and calculating the sales amount according to the salary deadline. This has the effect of shortening the period until monthly income and expenditure amounts can be confirmed.

FIG. 1 is a diagram showing a processing image of this embodiment. FIG. 2 is a block diagram showing an example of the configuration of the income and expenditure management device in this embodiment. FIG. 3 is a diagram for explaining a specific example of processing of the control unit of the income and expenditure management device in this embodiment. FIG. 4 is a diagram for explaining a specific example of processing of the control unit of the income and expenditure management device in this embodiment. FIG. 5 is a diagram for explaining a specific example of processing of the control unit of the income and expenditure management device in this embodiment. FIG. 6 is a diagram for explaining a specific example of processing of the control unit of the income and expenditure management device in this embodiment. FIG. 7 is a diagram for explaining a specific example of processing of the control unit of the income and expenditure management device in this embodiment.

DESCRIPTION OF THE PREFERRED EMBODIMENTS Below, embodiments of an income and expenditure management device, an income and expenditure management method, and an income and expenditure management program according to the present invention will be described in detail based on the drawings. Note that the present invention is not limited to this embodiment.

[1. overview]
In the temporary staffing industry, there is a task of calculating monthly income and expenditure for each project. In this work, it is necessary to calculate the sales amount based on the payroll deadline, not the deadline for each project.

However, in the past, customers had to manually calculate all sales amounts for each project outside the system and tally the income and expenditure. As a result, there was a problem in that it took time to confirm the income and expenditure, and the accurate amount could not be ascertained due to calculation errors.

Therefore, in this embodiment, we focus on the fact that the dispatch system manages not only the attendance for salary payments but also the attendance used for sales recording, and calculates the next month's sales based on the attendance used for sales recording. It is now possible to calculate the sales amount according to the payroll period.

According to this embodiment, the sales amount for the next month can be calculated and the sales amount can be calculated according to the payroll period, which eliminates the need for manual calculation processing by the person in charge, and it is possible to check the monthly income and expenditure amount. It is possible to shorten the period of In addition, since the journal entry slips recorded as provisional sales are automatically linked to the financial side as red slips at the next month's timing, there is no need to manually create journal entries, making it possible to reduce the burden of accounting processing.

FIG. 1 is a diagram showing a processing image of this embodiment. In FIG. 1, for example, if the deadline for payroll is from the 1st to the last day of the month and the deadline for sales is from the 21st to the 20th of the following month, the sales amount for the period from the 21st to the 31st cannot be calculated. Therefore, we automatically calculated (recorded) the amount from the 21st to the last day of the month as provisional sales, making it possible to check the monthly income and expenditure amounts at an early stage.

INDUSTRIAL APPLICATION This invention is useful in various industries, such as a temporary staffing industry, an IT industry, and a security industry, for example.

[2. composition]
The configuration of the income and expenditure management device 100 according to this embodiment will be explained using FIG. 2. FIG. 2 is a block diagram showing an example of the configuration of the income and expenditure management device 100 according to the present embodiment.

The income and expenditure management device 100 is a commercially available desktop personal computer. Note that the income and expenditure management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer. It may be an information processing device.

As shown in FIG. 1, the income and expenditure management device 100 includes a control section 102, a communication interface section 104, a storage section 106, and an input/output interface section 108. Each unit included in the income and expenditure management device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the income and expenditure management 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 income and expenditure management 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, which will 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, in addition to a monitor (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. In addition, below, 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 instructions to a CPU (Central Processing Unit) to perform various processes in cooperation with an OS (Operating System). As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc. can be used. Furthermore, the storage unit 106 includes a data file 106a.

The data file 106a is a file for storing various data such as case information (also referred to as "contract information"), work schedule data, provisional sales data, journal data, and sales reports.

The project information may include, for each project, data such as the billing deadline and salary deadline, the daily wage rate or hourly wage rate for each staff member, the applicable period, and the billing category (monthly wage earner or hourly wage earner) (see Figure 4). B), (C)).

Work schedule data is created for each project and staff, and includes the staff, working days, number of working days (for monthly wage earners) or working hours (for hourly wage earners), and classification (current month processing or next month processing). (See FIG. 4(A)).

The control unit 102 is a CPU or the like that centrally controls the income and expenditure management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs specifying various processing procedures, required data, etc., and performs various information processing based on these stored programs. Execute. The control unit 102 calculates and manages staff salaries and sales. Functionally, the control section 102 mainly includes a data registration section 102a, a sales accounting section 102b, a sales report creation section 102c, and a screen display control section 102d.

The data registration unit 102a registers case information and work schedule data in the data file 106e, for example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114.

The sales accounting unit 102b calculates and records the sales amount of the target staff based on work schedule data and case information. In this case, if the payroll closing period and the sales closing period are different, the sales accounting section 102b shows the provisional sales amount for the period within the payroll closing period but outside the sales closing period for the current month. (also referred to as “high”) is calculated and recorded.

Further, in the case of a monthly salary employee, the sales accounting section 102b may calculate the provisional sales amount as follows: provisional sales amount=monthly salary×number of working days in the next month/number of working days in the next month. Furthermore, in the case of a salaried employee, the sales accounting section 102b may calculate the provisional sales amount by multiplying the hourly wage by the next month's working hours. Further, the sales accounting section 102b may process the previous month's provisional sales amount as a red slip. Further, the sales accounting unit 102b may create a journal entry based on the calculation result of the sales amount.

The sales report creation unit 102c may create and output a sales report based on the calculation result of the sales amount in the sales total section 102b.

The screen display control unit 102d controls the display and input of various screens (for example, a case information input screen, a work schedule data input screen, etc.) displayed on the monitor 114.

[3. Concrete example]
A specific example of the processing of the income and expenditure management device 100 in this embodiment will be described with reference to FIGS. 2 to 7. 3 to 7 are diagrams for explaining specific examples of processing of the control unit 102 of the income and expenditure management device 100 in this embodiment.

(Calculation formula for provisional sales (accrued sales for the current month))
The sales accounting unit 102b calculates provisional sales (also referred to as "current month's accrued sales") for periods that are within the payroll closing period and outside the sales closing period. Specifically, using the project and staff as keys, the billing classification (monthly wage or hourly wage) and unit price (monthly wage unit price or hourly wage unit price) are obtained from the case information (see Figure 4 (C)), and the work schedule data (Figure 4 (C)) is obtained. 4(A)), obtain the number of working days or working hours for the next month's processing, and calculate the provisional sales amount based on the obtained unit price and number of working days or working hours.

1. Monthly wage earners For monthly wage earners, the calculation is calculated by monthly wage unit x number of working days in the next month/number of working days in the next month. For example, if the monthly unit price is "300,000", the number of working days in the next month is "8", and the number of working days in the next month is "21", the provisional sales amount is 300,000 x 8/21 = 114,286 (yen). (rounded to the nearest whole number).

2. Hourly wage earners For hourly wage earners, the calculation is calculated using the unit hourly rate x monthly working hours (for example, 8 (working hours per day) x number of working days in the following month). For example, if the unit hourly wage is "2,000" and the number of working days in the next month is "8", the amount will be 2,000 x 8 x 8 = 128,000 (rounded to the nearest yen).

In the case of completely fixed wages, in the case of standard fixed wages, and in the case of formal labor (monthly wage), the same calculation as for monthly wage earners is performed. In the case of variable labor (hourly wage), the same calculation as for hourly wage workers is performed.

(Flow of provisional sales calculation)
4 and 5 show the flow of provisional sales calculation. FIG. 4 shows the case where the billing category is for monthly wage earners, and FIG. 5 shows the case when the billing category is for hourly wage earners. The sales accounting unit 102b executes the billing deferral process and calculates provisional sales data for the current month for the period within the payroll closing period and outside the sales closing period, based on the work schedule data and case information. Further, the sales accounting unit 102b executes a journal entry coordination process to create a journal entry based on the calculated provisional sales data and the like.

(1. In case of monthly salary)
An example where the billing category is "monthly wage earner" will be described with reference to FIG. 4. Here, we will explain the balance for July as an example. The "payroll deadline" is "the end of the month," and the sales deadline (billing deadline) is "the 20th."

FIG. 4A shows an example of work schedule data for staff member "1000" of case "A100". FIGS. 4B and 4C show examples of case information. FIG. 4(D) shows an example of calculated provisional sales data.

In the matter information shown in Figure 4(B), the matter is "A100", the billing deadline is "20", and the salary deadline is "31", so from the work schedule data shown in Figure 4(A), the salary deadline is Obtain the attendance that corresponds to the provisional sales amount outside the sales deadline (7/21 to 7/31) within the period (7/1 to 7/31).

The second line of the matter information shown in Figure 4(C) includes the matter "A100", the staff "1000", the monthly salary unit price "200,000", the applicable period "7/1-9/30", and the billing category "Monthly salary person". ” Therefore, the provisional sales amount is calculated as monthly salary unit price (200,000) x number of working days in the next month (7 days) / number of working days in the next month (21 days) = 6667. Then, provisional sales data as shown in FIG. 4(D) is generated. Provisional sales for the previous month (June) will be processed as red slips.

The provisional sales data shown in Figure 4 (D) is for case number “A100” and staff “1000”, for the accounting month “2020/7”, the amount is “6,667”, and for the accounting month “2020/6”, the amount is “6,667”, and for the accounting month “2020/6” , the amount is "-5,500". Then, a journal entry is created based on the data shown in FIG. 4(E).

(2. For hourly wage earners)
An example where the billing category is "hourly wage worker" will be explained with reference to FIG. 5. Here, we will explain the balance for July as an example. The "payroll deadline" is "the end of the month," and the sales deadline (billing deadline) is "the 20th."

FIG. 5A shows an example of work schedule data for staff member "1000" of case "A100". FIGS. 5B and 5C show examples of case information. FIG. 5(D) shows an example of calculated provisional sales data.

In the matter information shown in Figure 5(B), the matter is "A100", the billing deadline is "20", and the salary deadline is "31", so from the work schedule data shown in Figure 5(A), the salary deadline is Obtain the attendance (63 hours) that corresponds to the provisional sales amount outside the sales deadline (7/21 to 7/31) within the period (7/1 to 7/31).

The second line of the matter information shown in Figure 5(C) includes the matter "A100", the staff "1000", the hourly rate "9,000", the applicable period "7/1 to 9/30", and the billing category "hourly wage employee". ” Therefore, the provisional sales amount is calculated as hourly wage unit price (9,000) x next month's working hours (63 hours) = 5670. Then, provisional sales data as shown in FIG. 5(D) is generated. Provisional sales for the previous month (June) will be processed as red slips.

The provisional sales data shown in Figure 5 (D) is for case number “A100” and staff “1000”, for the accounting month “2020/7”, the amount is “5,670”, and for the accounting month “2020/6”, the amount is “5,670”, and for the accounting month “2020/6” , the amount is "-4,500". Then, a journal entry is created based on the data shown in FIG. 5(E).

(Monthly sales report)
The sales report creation unit 102c may create and output a sales report based on the sales amount calculated by the sales total section 102b. FIG. 6 shows a display example of a search screen for creating a sales report, and FIG. 7 shows an example of output to the sales report. On the search screen shown in FIG. 6, it is possible to specify the year and month, base unit, aggregation unit (by individual or customer), and industry category. You may also create and output a sales report in accordance with the above.

As explained above, according to this embodiment, when the payroll closing period and the sales closing period are different, provisional sales are calculated for the current month within the payroll closing period but outside the sales closing period. Since it is equipped with a sales accounting section 102b for recording, when managing both staff salaries and sales, the person in charge can calculate the sales amount for the next month and calculate the sales amount according to the payroll deadline. This will reduce the burden on customers and shorten the period until monthly income and expenditure amounts can be confirmed.

[4. Other embodiments]
In addition to the embodiments described above, 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 performed automatically can be performed manually, or the processes described as being performed manually can be performed manually. All or part of the process can also be performed automatically using known methods.

In addition, unless otherwise specified, information including processing procedures, control procedures, specific names, parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings are included. It can be changed arbitrarily.

Further, regarding the income and expenditure management device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions of the income and expenditure management device 100, especially each processing function performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be realized as hardware using wired logic. Note that the program is recorded on a non-temporary computer-readable recording medium that includes programmed instructions for causing an information processing device to execute the processing described in this embodiment, and can be used for income and expenditure management as necessary. Mechanically read by device 100. That is, a storage unit such as a ROM or an HDD (Hard Disk Drive) stores a computer program that cooperates with an OS to give instructions to a CPU and perform various processes. 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 income and expenditure management device 100 via an arbitrary network, and it is also possible to download all or part of it as necessary. be.

Further, 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, this "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPR. OM (registration) Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVDs (Digital Versatile Discs), Blu-ray (registered trademark) Discs, etc. shall include any “portable physical medium”. Therefore, a recording medium storing a program for executing the processing or processing method as described in this specification also constitutes the present invention.

Further, a "program" is a data processing method written in any language or writing method, and does not matter in the form of source code or binary code. Note that a "program" is not necessarily limited to a unitary structure, but may be distributed as multiple modules or libraries, or may work together with separate programs such as an OS to achieve its functions. Including things. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, and the installation procedure after reading.

Various databases and the like stored in the storage unit 106 are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and various databases used for various processing and website provision. Stores programs, tables, databases, web page files, etc.

Further, the income and expenditure management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. Moreover, the income and expenditure management device 100 may be realized by installing software (including programs, data, etc.) that causes the device to realize the processing described in this embodiment.

Furthermore, the specific form of dispersion and integration of devices is not limited to what is shown in the diagram, and all or part of them can be functionally or physically divided into arbitrary units according to various additions or functional loads. It can be configured in a distributed/integrated manner. That is, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively.

100 Income and expenditure management device 102 Control unit 102a Data registration unit 102b Sales total upper part 102c Sales report creation unit 102d Screen display control unit 104 Communication interface unit 106 Storage unit 106a Data file 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 network

Claims (4)

An income and expenditure management device that includes a storage unit and a control unit and manages staff salaries and sales,
In the storage unit,
Contains project information including the project, billing deadline, and payroll deadline.
The control unit includes:
For the current month of the target project, if the salary cut-off period calculated from the salary cut-off date of the above-mentioned case information and the sales cut-off period calculated from the billing cut-off date of the above-mentioned case information are different, within the payroll cut-off period, We have a sales recording method that records sales during the closing period that will be sales for the next month as provisional sales.
The sales recording means are:
In the case of monthly wage earners, the provisional sales amount is calculated as provisional sales amount = monthly salary amount x number of working days in the next month / number of working days in the next month.
In the case of an hourly wage worker, the income and expenditure management device is characterized in that the provisional sales amount is calculated by the hourly wage amount x next month's working hours . 2. The income and expenditure management device according to claim 1 , wherein the sales recording means processes the previous month's provisional sales amount as a red slip. An income and expenditure management method executed by an information processing device including a storage unit and a control unit, the method comprising:
In the storage unit,
Contains project information including the project, billing deadline, and payroll deadline.
executed in the control unit,
For the current month of the target project, if the salary cut-off period calculated from the salary cut-off date of the above-mentioned case information and the sales cut-off period calculated from the billing cut-off date of the above-mentioned case information are different, within the payroll cut-off period, This includes a sales recording process in which sales during the closing period that will be sales for the next month are recorded as provisional sales.
In the sales recording process,
In the case of monthly wage earners, the provisional sales amount is calculated as provisional sales amount = monthly salary amount x number of working days in the next month / number of working days in the next month.
For hourly wage earners, this income and expenditure management method is characterized by calculating the provisional sales amount by multiplying the hourly wage by the next month's working hours . An income and expenditure management program to be executed by an information processing device including a storage unit and a control unit,
In the storage unit,
Contains project information including the project, billing deadline, and payroll deadline.
In the control section,
For the current month of the target project, if the salary cut-off period calculated from the salary cut-off date of the above-mentioned case information and the sales cut-off period calculated from the billing cut-off date of the above-mentioned case information are different, within the payroll cut-off period, This is an income and expenditure management program that executes the sales recording process in which sales during the closing period that will be sales for the next month are recorded as provisional sales.
In the sales recording process,
In the case of monthly wage earners, the provisional sales amount is calculated as provisional sales amount = monthly salary amount x number of working days in the next month / number of working days in the next month.
For hourly wage earners, this income and expenditure management program calculates the provisional sales amount by multiplying the hourly wage amount by the next month's working hours .

Images