JPS61224066A - Expense distribution processing system of slip input - Google Patents

Abstract

PURPOSE:To make the input operation efficient by copying slip items of item, details, etc. from a preceding slip when the input of only identification information of shops and departments of input data of each slip is detected and distributing automatically the amount of money of a representative slip to individual slips inputted hereafter. CONSTITUTION:A slip input picture display part 20 is provided for executing the processing which displays a picture for slip data input having a setting column related to identification information of shops and departments. Slip data is inputted from a slip data input part 21 in accordance with the display picture on the display part 20. If an input data check part 22 detects that only identification information of shops and department is inputted with respect to input data of each slip, slip items of itemization, details, etc. are copied from the preceding slip by a slip item copying part 23, and the amount of money of the representative slip is automatically distributed to individual slips inputted hereafter by a distributing part 24 of the amount of money. Thus, it is sufficient if an operator inputs required minimum information in the slip input, and the input operation is simplified.

Description

[Detailed Description of the Invention] [Summary] This is a business management system such as a store/department profit and loss management system that calculates profit and loss for each store and department in a medium-sized chain store, etc., and issues profit and loss statements for each store and department. hand,
A means for automatically determining and copying common items when manipulating expenses commonly required for multiple stores and/or multiple departments, and a means for allocating the expenses to each store and/or each department. The present invention discloses an expense allocation processing method for inputting slips, which simplifies the input operation of slips related to a plurality of stores, such as advertising expenses, etc. by providing the following.

[Industrial application field]

The present invention relates to a business management system for medium-sized chain stores such as supermarkets.

Particularly when inputting slips in a store/department profit and loss management system that allocates the amounts of sales, expenses, etc. entered as a company total or store total to each store and department and issues a profit and loss statement for each store and/or department. This relates to the expense allocation processing method.

[Conventional technology]

FIG. 8 shows an example of a conventional business management system, and FIG. 9 shows an example of a system to which the present invention is considered.

For example, as shown in Figure 8, conventional business management systems include a sales management system 1 that manages sales, etc., a personnel and salary system 2 that manages salaries of employees, inventory management, non-operating income and expenditure data, etc. System 3 to manage
and a financial accounting system 4 that performs accounting processing based on the output data of these systems, and the processing is performed by an electronic computer.

However, in general, such systems have multiple stores in multiple regions, such as chain stores,
In the case of an organization where each store handles multiple product groups such as food, clothing, miscellaneous goods, etc. by department, it is possible to manage the profit and loss of the company total or store total, but each store or processing center (P/C) 2 Departmental management on the headquarters side, etc. was not possible, and effective management information could not be obtained.

Therefore, the inventors of the present invention have considered a system as shown in FIG. In FIG. 9, sales management system 1,
Personnel Payroll System 2. The other systems 3 and financial accounting system 4 may be considered to be similar to the existing system shown in FIG.

10 is a journal interface file in which journal voucher data automatically journalized by the sales management system 1 etc. is stored; 11 is an update of the allocation standard when the amount entered as a company total or store total is allocated to each store department. Allocation standard value mask update file in which information is set, 12
13 is a display terminal for inputting journal entry slip data without going through the journal interface file 10;

14 is various profit and loss statements, 15 is journal entry slip for storage.

16 represents a financial interface file for passing journal data to the financial accounting system 4.

In the case of this system, the user can freely define allocation standards according to sales volume, sales floor area per person, etc. via the allocation standard value mask update file 11. In a configuration in which the profit and loss management system 12 for each store and department is not linked with the sales management system 1, etc., profit and loss management for each store and department can be performed by the two stores and departmental profit and loss management system 12 just by inputting from the display terminal 13. It is generalized so that it can be used.

[Problem that the invention seeks to solve]

By the way, 1. For example, regarding specific products such as meat, fruits and vegetables,
To run special sales only at multiple specific stores.

It is often advertised. Generally, such expenses are paid in one lump sum at the headquarters, but in order to calculate the profit and loss for each store and department in the system shown in Figure 9, it is necessary to calculate the advertising expenses, etc. for each store and department. It is necessary to calculate expenses for each store, and it is necessary to record slip data, which is the basic data for calculating the expenses, for each store, for example.

However, according to the conventional method, for example, when accounting for advertising expenses for holding a special sale on fresh produce at five stores, it was necessary to issue the slip data for each of the five stores. Therefore, each slip item such as subjects and breakdowns has to be manually rewritten many times.

There is a problem in that the input operation is extremely complicated and errors in inputting the debit amount or credit amount are likely to occur.

As a method to make this input easier, 3. For example, it is possible to register a combination of specific stores using a pattern code, and then enter that pattern code when inputting a slip to issue a slip for multiple stores. I can think of it. but,
In general, the combination of stores is.

Since it is temporary, each combination of stores must be registered in the mask, which poses a problem in that the registration process becomes complicated.

[Means for solving problems]

The present invention aims to solve the above-mentioned problems and provides a means for easily inputting slips related to expenses commonly incurred in each store or department, such as a supermarket, for example. Therefore, the expense allocation processing method for inputting slips according to the present invention is 1.
For example, it is configured as shown in FIG.

In FIG. 1, a slip input screen display section 20 is shown.

It executes a process of displaying a screen for inputting slip data, which has a setting column regarding at least store identification information and/or department identification information.

The slip data input section 21 inputs slip data on the display screen of the slip input screen display section 20.

The input data checking unit 22 checks whether or not the input data of each slip is only the identification information of the store and/or the department. The slip item copying section 23 is activated by the determination result of the input data checking section 22, and when the input data of the slip is only the identification information of the store and/or the department, the slip item copying section 23 copies the previous input data for other slip items. Executes the process of copying something.

The amount allocating unit 24, for the case where the input data of the slip is only the identification information of the store and/or the department,
It executes a process of allocating the amount related to the slip inputted before the input data to each store and/or each department.

[Effect]

In the case of the present invention, the input data checking section 22.

When it is detected that only the identification information of one store and/or department is input for the input data of each slip, the slip item copying unit 23 copies the slip items such as account and breakdown from the previous slip, and allocates the amount. The unit 24 automatically allocates the amount of the two representative slips to each of the slips input thereafter. Therefore, when inputting a slip, the operator only needs to input the minimum necessary information, which simplifies the input operation and enables high-speed input.

〔Example〕

FIG. 2 is a block diagram related to an embodiment of the present invention, FIGS. 3 and 4 are examples of output forms of the system related to the present invention, and FIG. FIG. 6 is an explanatory diagram of processing in an embodiment of the present invention, and FIG. 7 shows an example of a system equipment configuration to which the present invention is applied.

FIG. 2 shows a detailed block diagram of the parts particularly related to the store/department profit and loss management system 12 shown in FIG. 9. In FIG. 2, numerals 10, 11, 13 to 16 correspond to those shown in FIG.

The journal data input unit 30 executes a process of inputting journal slip data from the display terminal 13.

The input journal voucher data is stored in a journal voucher input monitor file 32 and a journal voucher accumulation file 33. The file set up section 31 stores these files 3.
2.33 initial setup and reorganization.

The data stored in the journal entry slip input monitor file 32 is output as a journal entry slip input monitor list 35 by the monitor list issuing unit 34.

The journal acceptance list issuing unit 36 generates the journal voucher cumulative file 3.
The total debit and total credit are calculated for the journal data stored in 3, and a journal acceptance list 37 is output that allows checking for input errors.

The journal data in the journal interface file 10 and the journal slip accumulation file 33 created by the sales management system are edited on two separate days by the journal data daily editing processing unit 38, and the edited journal results are used as the second post-edit journal entry. 1 file 40° is stored in the post-edit journal entry second file 42 and financial interface file 16. The financial interface file 16 is a file in which data passed to the financial accounting system 4 shown in FIG. 8 is stored, and the financial accounting system 4 uses this financial interface file 16 to create a company-wide trial balance.

Output balance sheets, income statements, etc.

The journal entry slip issuing unit 43 prints out the journal entry slip 15 to be saved as accounting evidence based on the data stored in the nine-edited journal entry second file 42.

The allocation standard value mask update file 11 stores data for updating the allocation standard value for allocating the input amount for the total of nine companies or the total for each store to each department. That is, rule data for allocating amounts and information on allocation of expenses such as personnel expenses are stored. The allocation reference value update processing unit 39 executes a process of updating the allocation reference value master 41 based on the contents of the allocation reference value mask update file 11.

The store/department allocation processing unit 45 allocates income and expenses to each store and department based on the journal data in the second edited journal first file 40 and the allocation standard value in the allocation standard value master 41. Execute the processing to charge. This allocation amount data is managed for each of the nine stores on each date and in the smallest unit for each department. Therefore, from this data, we can calculate monthly totals for each of the three stores, power meters for each department, etc. This allows you to obtain the data you need at any time. This data is 2
It is stored in the store-by-department allocation file 47.

Further, the common personnel expense file 46 stores expense data of common personnel expenses for nine head office employees and the like.

The store/department breakdown side aggregation unit 48 stores the common personnel expenses file 4.
61 Store/department distribution file 47. Allocation standard value master 4
From 1 to 1, the data is aggregated by store, department, and breakdown. This total result is a total of 50 totals for each store and department.
is stored in The total mask set amplifier section 49 performs initial setup of the total master 50.

The form control file 51 contains nine stores 2 of subjects to be output on each form.
This is a file in which data specifying the form format regarding departments and their arrangement is stored, and the budget master 52 for each department for two stores is for nine stores.

This is a file that stores budget data within a predetermined period by department and breakdown. These files 51.
52 is set up in advance by a user or the like.

The various profit and loss statement issuing department 53 has a total master 50 for each department and 9 stores. Allocation standard value master 41. Form control file 5
19 Various profit and loss statements 14 etc. are issued and output based on the data of the budget mask 52 for each store and department. For example, these output reports are as follows: ■ Profit and loss statement by store/department ■ Profit and loss statement by department/store ■ Profit and loss statement by store ■ Profit and loss statement by department ■ Profit and loss statement by P/C department ■ P/C profit and loss statement ■ Expense statements by head office department ■ Operating expense statements by store, etc. Furthermore, these forms can be output in various forms as necessary, such as a January total from the beginning of the first term, a quarterly cumulative total, and a half-year cumulative total in January units.

Figure 3 shows an example of the output report for the June total of the profit and loss statement for one store/department.For store A, data such as sales, gross profit, gross profit margin, total expenses, etc. , Fisheries, etc. are output by sector. Two illustrations are omitted from this form.

For example, break-even point information, profit information per person, profit information per unit area of sales floor, inventory-related information, etc. are also output.

This report provides information about which departments in store A have good profit margins and which departments have room for improvement.

Similarly, Figure 4 shows an example of the output report for the monthly income statement for each department and store, and data such as sales, gross profit, gross profit margin, total expenses, etc. for the delicatessen department are shown. A
Stores such as Store B, Store B, Store 0, etc. are output together with the total for all stores and the average for all stores. This form provides business management information regarding which branches should be handled.

The present invention mainly relates to the journal data input section 30 in FIG. The slip inputted through the processing of the slip input screen display section 20 and the slip data input section 21 shown in FIG. Slip item copy section 23. Processed by the amount allocation unit 24, for example, the second
It is stored in the journal entry slip accumulation file 33 shown in the figure.

The slip input screen display unit 20 displays an input screen, for example, as shown in FIG. 5(A) on the display terminal 13 shown in FIG. In this example, on this input screen, with slip number 1 as the representative slip, the item r 84126j
, breakdown r 00002'', store code ``02'' which is store identification information, and department code ``07'' which is identification information of 9 departments.
and rloo as the debit amount.

00" is entered.

For slip numbers No. 2 to N005, the store codes are r03J and r06J, respectively.

Only riot and rill are input. In the next slip number, No. 6, data other than the 5th store code is also manually processed, so the common expenses entered in the 1st representative slip number N001 should be allocated to slip numbers up to No. 5. It is determined that

In slip number No. 2 to slip number No. 5.

For the item data whose input is omitted, that of slip number N001 is copied.

Therefore, the data input as shown in Figure 5 (A) is
The journal entry data will be edited as shown in FIG. 5(B).

In this example, only nine store codes are input.

Although an example of allocating amounts is shown, it is also possible to configure such that input of only one department code is allocated to each department within the same store. Similarly, it is also possible to allocate amounts to two stores and departments using a combination of store code and department code.

The following is the processing of parts related to the present invention.

This will be explained according to FIG.

First, by the process P1 shown in FIG. 6, a slip input screen as shown in FIG. 5(A) is displayed. Then, in process P2, slip data is entered on this manual screen using a keyboard or the like. Please note that the input of the slip data is 1, for example 1.
It is possible to input daily information continuously, and if it does not fit on one screen, it is possible to continue inputting by scrolling or switching the screen. After inputting the slip data, the process moves to process P3.

In process P3, from the beginning of the input slip data.

Sequentially, one piece of slip data is extracted. In this example, 1
It is assumed that one line of data on the screen corresponds to one piece of slip data. Note that the same applies to the case where it spans multiple lines. If the slip data cannot be retrieved due to the end of the data, the process is terminated based on the determination in process P4. If there is data, it is determined in process P5 whether or not the next line is for inputting only the store code. If it is normal slip data, the previously retrieved slip data is stored in the journal entry slip related file in process P6, and control is returned to process P3.

If it is detected in the judgment in process P5 that only the store code has been input in the primary line, the process moves to process P7 and the previous slip data is copied to the part of the primary line in which no input has been made. Then, in process P8, the number of stores is counted up to determine the amount to be allocated. Next, process P9
This further increments the line pointer for accessing the next slip data.

It is determined by the processing PIO whether or not the ninth row is for inputting only the store code. If only the store code is entered, process P7
Otherwise, process P9 is repeated.

If there is an input other than the store code, the process moves to process P11, and according to the process pH, the amount of the previously input representative slip is divided by the number of stores to calculate the expense allocation amount for each of the nine stores. and,
In process P12, the allocated amount is entered in the previous series of slips, and the expenses are allocated to each store. After storing the several slip data in the journal entry slip related file by processing P13.

Control is returned to process P4 until the data is completed.

Repeat the process in the same way.

The same applies to the case where it is not a store code but a department code or a combination of a store code and a department code.

The hardware configuration for realizing the above processing may be a general-purpose computer system as shown in FIG. 7, for example. In the figure, 100 is a central processing unit (CPU), 101 is a main memory (MEM), 102 to 104 are channel devices,
105 and 106 are magnetic disk devices in which various files are provided, 107 is a keyboard, and 108 is a Japanese language display.

Reference numeral 109 represents a Japanese printer for outputting various forms.

For example, if a sales management system is
In a system that collects data from a terminal (nt of 5ales terminal), an online communication device is required, but if you look at the parts related to the present invention, the communication device etc. may not be necessary.

〔Effect of the invention〕

As explained above, according to the present invention, it is possible to easily and quickly input slips related to expenses common to each store or each department. Also.

Since the allocation amount can be determined automatically, input errors can be reduced.

[Brief explanation of the drawing]

FIG. 1 is a basic configuration diagram of the present invention, FIG. 2 is a block diagram related to an embodiment of the present invention, FIGS. 3 and 4 are examples of output forms of the system related to the present invention, and FIG. FIG. 3 is a diagram for explaining an input example according to the invention. FIG. 6 is a processing explanatory diagram of one embodiment of the present invention, FIG. 7 is an example of system equipment configuration to which the present invention is applied, FIG. 8 is an example of a conventional business management system, and FIG. 9 is an example of a system to which the present invention is applied. An example of the system considered is shown. In the figure, 20 represents a slip input screen display section, 21 a slip data input section, 22 an input data check section, 23 a slip item copy section, and 24 an amount allocation section. Patent Applicant: Fujitsu Ltd. Representative Patent Attorney Hiroshi Mori 1) (1 other person) $ 1 Ward

Claims (1)

[Claims] A business management system using a computer system in an organization that has multiple stores and handles products from multiple departments in each store, which relates to at least store identification information and/or department identification information. A slip input screen display section (20) that displays a screen for inputting slip data having setting fields, and a slip data input section (21) that inputs slip data under the display screen of the slip input screen display section (20). ), an input data check unit (22) that determines whether or not the input data of each slip is only the identification information of the store and/or the department; a slip item copying unit (23) that copies previous input data for other slip items when the input data is only the department identification information; and a slip item copying section (23) that copies the previous input data for other slip items; The present invention is characterized by comprising an amount allocating unit (24) that executes a process of allocating an amount related to a slip inputted before the input data of the item to each store and/or each department. Expense allocation processing method for inputting vouchers.