JPH08287152A - Closing statistics system - Google Patents

Abstract

PURPOSE: To check consistency between plural records of closing statistic works in a commune and to prevent missummation by defining and storing plural statistical table data and the relation between plural cells in a statistical table, and reading the statistical table and the relation between the cells thereby performing a summation process and a matching process. CONSTITUTION: A storage device 10 stores table data and matching conditions and an input/output device 20 is a keyboard and a mouse for inputting the table data and the conditional expressions for matching and a display for displaying the read-out table data. A processor 30 has a storage device access control means 60 which performs control when the data are stored in the storage device 10 and read out of the storage device 10, a summation and matching process means 90 which sums up the table data and performs the matching process, and an output data editing means 100 which edits the results of the summation and matching processes and outputs the result. The processor 30 reads the statistical table and the relation between the corresponding cells out of the storage device 10 and performs the defined summation process and matching process.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a financial accounting business in a local public body, and more particularly, to a financial statement statistical business which is carried out by summing up a general account and a public business account for each accounting period.

[0002]

2. Description of the Related Art Statistical surveys on local finance are conducted every year in accordance with the provisions of the Local Autonomy Law and other laws and regulations, and are compiled as a white paper on local finance.

In order to put together a complicated paperwork of a plurality of local public bodies as a white paper, each local government is prescribed to adopt a unified settlement method. That is, in order to put together the financial situation, each local government puts together about 70 types of accounting items for the relevant fiscal period. Then, the consistency of each of the items of the financial statements with respect to the mutually overlapping parts and related parts must be confirmed.

Such financial statement statistics are described in detail in "Local Government Public Accounts Statistics Handbook" edited by the Local Finance Research Group. The state of local finance is reported at the Diet based on the "White Paper on Local Finance" issued each year.

[0005]

As described in the above-mentioned prior art, in a settlement report of settlement statistics, for example, the total value of a plurality of cells of a certain form must be the same as the value of a cell of another form. There are many conditions such as not being possible, and it takes a lot of labor to manually check and correct these,
There is also the problem that mistakes are likely to occur.

The present invention has been made in view of these problems, and it is an object of the present invention to check the consistency between a plurality of forms in the settlement statistics work in a local government and prevent mistakes in summing.

[0007]

In order to solve the above problems, the present invention uses the following means.

First, a storage device for predefining and storing a plurality of statistical table data and a relationship between a plurality of cells in the table of the statistical table, and inputting a keyboard / mouse for inputting data. A computer equipped with an apparatus, a statistical table data, an output device such as a display for displaying and outputting a match result and a sum result, a printer, and a processing device for performing a match process and a sum process between cells is prepared.

In the above processing device, the relation between the statistical table in the storage device and the corresponding cell is read out, and it is checked whether or not the relation is a defined relation, or the defined summing process is executed.

A unique table number is given to each statistical table in the storage device. Further, the data of the statistical table is controlled so that it can be accessed for each table / cell by using the table number, the row number and the column number.

The relationship between a plurality of cells includes the table number / row number / column number of the cells to be merged, the range of cells to be summed up,
A symbol (one of "equal", "greater than or equal to", "greater than", "less than or equal to", and "less than") that represents the relationship between two values and a constant are combined and expressed.

[0012]

[Function] The statistical table data to be settled is stored in advance in the storage device. At this time, by storing each statistical table as a pair with a table number, a specific statistical table can be specified using this number.

The input device acts as an input means for the user to define the relationship between the cells. The following rules are provided to define the relationship between cells. First, the coordinates of the target cell are expressed using "table number", "row number", and "column number". When comparing the values of two cells, the coordinates of the two cells and the code indicating the relationship between the cells are paired and stored as one record. Furthermore, when values of some cells are added up, a flag indicating that the records to be added up span a plurality of rows is provided as an item, and the addition process is performed by this flag.

By describing and storing the relationship between a plurality of tables and a plurality of cells in accordance with this rule, it is possible to perform the summing / matching process of the table data.

The processing device has a function of reading out the relation between the statistical table data and the cells from the storage device, summing / matching the cell values based on the defined relation, and outputting the result to the output device.

The output device serves to display the statistical table data designated by the user and the result of the summing / matching process, or to print and output the result to present to the user.

At the time of summing / matching, the input / output device and the storage device are controlled so that the processing device performs the following processing.

First, the user specifies the table or cell to be matched using the table number, row number, and column number.

When the user designates a specific table, the processing device reads out the relational expression including the designated table number in the record from the table defining the relation between cells stored in the storage device. . Next, from the read relational expressions, the table number referred to by the relational expression between cells is extracted. The table data is read from the storage device using this table number.

Next, a summing / matching process is performed based on the read relational expression between cells.

That is, first, the table data in the storage device is accessed using the table number / row number / column number of the cells to be summed, the table data stored at the coordinates is read, and the values are summed. To do. Next, the summing process is performed using the table number, row number, and column number of the cell that is the target of the matching. Finally, these two values are compared to determine whether or not a predefined code holds.

As described above, the relation between the table data and the cells is stored in advance in the storage device as the table number, the row number, and the column number, so that the relation between the cells can be triggered by the user's designation. You will be able to judge.

The code used for the determination expresses a predetermined relationship of "greater than", "greater than or equal to", "equal to", "less than or equal to" and "less than". It is possible to determine whether or not the condition defined by the user is satisfied by checking the relationship shown.

Upon receiving the determination result, the processing device presents the result to the user using the output device. As a result, it becomes possible to check the consistency between the plural books used for the settlement statistics.

[0025]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A first embodiment of the present invention is shown in FIGS.
This will be described with reference to FIGS. 4, 10 and 11.

FIG. 1 is a block diagram of the settlement statistics system.

In FIG. 1, reference numeral 10 is a storage device which stores table data and matching conditions. Reference numeral 20 denotes an input / output device, which is assumed to be a keyboard or mouse for inputting table data and conditional expressions for matching, and a display for displaying read table data. Reference numeral 30 denotes a processing device, which is a storage device access control means 60 for controlling the storage of data in the storage device and the reading of data from the storage device, and a summing device for summing up or collating table data.
It comprises a match processing means 90 and an output data editing means 100 for editing and outputting the result of the summing / match processing. Further, the storage device access control means 60 is composed of a table data reading means 70 and a relational expression reading means 80.

Reference numeral 40 denotes a temporary storage device, which is a processing device 30.
This is a device for storing intermediate data that is required during the processing performed in 1.

Reference numeral 50 denotes an output device, which is assumed to be a printer which prints out the result of the summing / matching process.

FIG. 2 shows an example of conditional expression data for a match stored in the storage device 10 of FIG. One line in the figure represents one record.

FIG. 2 is roughly divided into three areas. 11 is a butt left side from 11 to 14, a butt right side from 16 to 19, and a butt code of 15 representing a relationship between the butt left side and the butt right side.

The butt left side and the butt right side have the same data structure. That is, 11 and 16 are items for designating a table number indicating a table to be matched. 21 in FIG. 3 described later
11 and 1 because the table data is uniquely assigned with a number for identifying each
By specifying the table number in 6, only one table data can be specified.

12 and 17 are line numbers. It is specified in which row of the table specified by 11 or 16 the data to be matched. 13 and 18 are also column numbers. By specifying 12 and 13 and 17 and 18 as a pair, it is possible to indicate a specific coordinate in a certain table.

"Continuation" of 14 and 19 is a flag indicating whether or not the object of data matching extends over a plurality of lines. If the data stored here is +, "add the data in the next row", "-" subtract the data in the next row, "E" means "end", and * It means "multiply the data of the next line", and "/" means "divide by the data of the next line".

The butt code of 15 is a code for comparing the values of the results of addition on the left side of the butt and the right side of the butt. When =, "the left side of the butt and the right side of the butt are equal", and when <, the left side of the butt is Less than right side of butt ",>if" left side of butt is greater than right side of butt ", ≤ if" left side of butt is less than or equal to right side of butt ", and if ≥" left side of butt is greater than or equal to right side of butt " Means that.

3 and 4 show the table data stored in 10.

In FIG. 3, 21 and 24 are table numbers.

For example, the table data of the table number "02" indicated by 21 has vertical items of the Heisei fiscal year and the Heisei (n-1) fiscal year. A line number is given to each line to distinguish them. Here, the line number is represented by a three-digit number such as "010" and "020". Of these, the upper two digits are the number of lines and the lower one digit is the branch number of the line number. For example, a different line number is given as line number 010 from the total revenue of the Heisei year to the single year balance and line number 011 from the reserve fund to the real single year balance. This is a line number numbering method used when there are a large number of items existing in the same line.
Items to be taken on the vertical and horizontal axes of the table data are naturally decided depending on what kind of data the table represents, but in relation to the conditional expression for the match shown in FIG. , The row number and column number in the match condition expression of FIG.

Similarly, in the table number 02, there are horizontal items such as "row number", "total revenue", "total expenditure", "revenue deduction", etc., but all column numbers except the item "row number". One is given to each item. In other words, the column of "total revenue" is column number 01, the column of "total revenue" is 02,
The column of “reserve fund” is 07.

Next, in the table data of the table number "29" indicated by 24, the data for each row from the row number 010 is distinguished and stored. Also, in the row direction, "Financial Adjustment Fund",
One column number is given to each of the sub-items of “reduction fund”, “other special purpose fund”, and “total”.

The relationship between FIGS. 2 and 3 will now be described. The butt left side "table number 02, row number 01, column number 09" designated in the first record of FIG. 2 is stored in 23 of FIG. The collected data is converted to the right side "Table number 29, line number 03,
The column number 01 ”indicates the data stored in 25 of FIG.

FIG. 4 shows the table data of the table number "32" indicated by 41. 42 is "table number 32, line number 0
1, column number 05 ”. Similarly, 43 is "table number 32, row number 130, column number 05", 44 is "table number 3"
2, row number 190, column number 05 ".

The butt right side designated by the second to fourth records in FIG. 2 is the row number 01 and the column number 0 of the table number 32.
A value obtained by adding the data of row number 13 and column number 05 to the data of 5 and further subtracting the data of row number 19 and column number 05 is shown. This is the result of adding 43 data to the data stored in 42 of FIG. 4 and subtracting 44 data therefrom.

FIG. 10 shows a processing flow when the matching processing is performed using the conditional expression data for the matching shown in FIG. 2 and the table data shown in FIGS. 3 and 4. This processing is executed by the summing / matching processing means 100 in the processing device 30 of FIG.

First, in step 101, designation of a table number for a match is accepted from the user. For example, the table number "0
2 ”is designated, in the next step 102,
The conditional expression data that is included in the record is searched with 02 as "table number". In this case, the search target is the conditional expression data shown in FIG. As a result, the first record and the second to fourth records in FIG. 2 can be extracted. As described above, in step 102, the connection between records is detected when the conditional expression for matching is extracted. That is, if there is no data in the "continuation" columns on the left side of the butt and the right side of the butt, 1
Read only records as search results. However, like the second record, either the left side of the butt or the right side of the butt
When there is data in the "Continue" column, a plurality of vertically continuous records are regarded as one block until the "Continue" column becomes "E". As a result, from the second record to the fourth record, three records are recorded. 2 indicates a single matching condition.A group of this record is called a record group, that is, as the record group including the table number 02, the first record is the first record in FIG. Is from the second record to the fourth record.

Next, in step 103, the table number contained in the record group read in step 102 is saved in the temporary storage device of FIG. In this case, the table numbers 29 and 32 are stored.

Then, in step 103, the table data is read. The objects to be read are the table numbers 29 and 32 and all the data 02 designated by the user.

Next, in step 104, step 1
Step 1 until there is no record group searched in 02
Repeat from 05 to 107. Here, the record group is taken out in the order of reading. In addition to this, for example, the priority order of the match may be defined in the data of the match condition expression of FIG. 2 and the record group may be extracted in this order.

In step 105, the butt left side is summed.

The process of summing the left side of the butt is performed according to the process flow of FIG.

In step 1101, variables x, z,
Initialize w. In step 1102, the array f (x)
Is initialized.

At step 1103, for each of the match record groups read at step 102, until there are no match records or f (x) becomes'E ', steps 1104 to 1115 are executed. Repeat the process.

For example, in the above example, in step 1104, the table number 02 is set to S (1). Step 11
At 05, the line number 01 is set to L (1). Step 1
At 106, the column number 09 is set in C (1). In step 1107, the corresponding coordinate value is referenced from the table data read in step 103 using S (1), L (1), and C (1), and that value is substituted into w. In the above example, FIG.
23 data are substituted into w.

In step 1108, the processes in steps 1109 to 1113 are distributed according to the value of f (x). Since f (1) is currently “Δ”, step 1109 is executed. That is, the value of w is substituted for z.

Then, in step 1114, "continuation" is read. Since “continuation” on the left side of the match in the first record group is “Δ”, “Δ” is substituted for f (1). Next, in step 1115, x is incremented by 1.

Since the left side of the butt of the first record group ends here, the end condition of step 1103 is satisfied, and the summing process of the left side of the butt ends.

Next, at step 106, the right side of the butt is summed.

This summing process is also performed according to the process flow of FIG.

As a result, the data stored in the coordinates of table number 29, row number 03, and column number 01 becomes the value on the butt right side. This is the table data of 25 in FIG.

In step 107, steps 105 and 1
The table data read in 06 is compared according to the 15 code. The comparison result is output to 40 temporary storage devices.

Next, regarding the second match record group,
The steps 105, 106 and 107 are processed in this order.

In step 105, the butt left side is summed.
The coordinate data of the table number 02, the row number 01, and the column number 03 (the table data 22 in FIG. 2) becomes the value on the left side of the butt.

In step 106, the butt left side is summed.
According to the flow of FIG. 11, the coordinate data of the table number 32, the row number 01, and the column number 05 (the table data of 42 of FIG. 4) is coordinate data of the row number 13 and the column number 05 (4 of FIG. 4).
3 is added, and the value obtained by subtracting the coordinate data of row number 19 and column number 05 (table data of 44 in FIG. 4) is substituted.

In step 107, steps 105 and 10
The values of the butt left side and the butt right side added in 6 are compared. The comparison result is output to 40 temporary storage devices.

Here, since there is no match record group and the end condition of step 104 is satisfied, step 108 is executed.
Then, output the result of the match. As a method of outputting the result, for example, only the result of the match may be separately edited and output, or the target coordinates of the match of the table data in FIGS. 3 and 4 may be highlighted.

Next, a second embodiment of the present invention will be described with reference to FIGS. 1, 5, 6, 6, 7, 8, 9, 11 and 12.

FIG. 5 shows another example of a conditional expression for a match stored in the storage device 10.

The data shown in FIG. 5 is roughly divided into four areas. That is, the abutting left side of 501 to 504, the abutting code of 505, the abutting right side of 506 to 511, 512 to 5
17 is a butt conditional expression.

501 to 511 are included in the area of the match condition expression.
Prerequisites for the relationship shown in are established.
That is, the value indicated by the coordinate data of the table data designated by 512 to 514 and the value indicated by "continuation" of 515 (designation of the range to be added, which has the same function as 14 in FIG. 2) and 517
The relationship to be satisfied by the two constant values indicated by is stored in the butt code of 516.

On the right side of the match, coordinate data of the table data to be matched from 506 to 508, a continuation flag at 509 if the target of the match spans multiple lines, and a constant number instead of the table data as the target of the match. In this case, the constant is stored in 511.

On the left side of the match, coordinate data of table data to be a match target is stored using 501 to 503, and a continuation flag is stored in 504 when the target of the match spans a plurality of lines.

In the butt code of 505, the relationship to be satisfied by the two table data designated by the butt right side and the butt left side is coded and stored.

FIG. 6, FIG. 7, FIG. 8 and FIG. 9 show the table data referred to by the conditional expression for the match of FIG.

Reference numeral 61 in FIG. 6 is a table number, which indicates that this table is data of table number 07. 62 can be represented by the coordinates of table number 07, row number 25, and column number 02.

On the right side of the first record in FIG. 5, "the data of the coordinate of row number 25 and column number 02 of table number 07 is 1
Or more ”is described.

Next, FIG. 7 shows the data of table number 01. 71 is a table number. Data 72 to 77 are continuous data in the column direction of the column number 03 of the row numbers 02 to 07.

In the butt conditional expression from the 1st record to the 6th record of FIG. 5, the condition "if the total of the data of the coordinates of the row number 02 of the table number 01 to the column number 03 of 07" is 1 or more is described. ing.

FIG. 8 shows the data of Table No. 15.
800 is a table number.

This table is long in the vertical direction, the row numbers are all 01, and each row data is distinguished by the branch number of the row number and the column number. For example, 801 can be represented by coordinates of row number 01, branch number 0, and column number 01. Also 802
Is a row number 01, a branch number 4, a column number 30, and 803 is also a column number 31, 804 is a column number 32, and 805 is a column number 3.
3, 806 is column number 34, 806 is column number 35, 807
Is column number 36, 808 is column number 37, 809 is row number 0
1, branch number 5, column number 38, 810 can be expressed as row number 01, branch number 5, column number 39, respectively.

In the match condition of the seventh record in FIG. 5, the condition "if the coordinate data of table number 15, row number 01 and column number 35 is 1 or more" is described. Similarly, on the left side of the butt, "Table number 15, line number 0
1, the data of the coordinate of the column number 35 is smaller than the data of the right side of the butt ".

FIG. 9 shows the data of Table No. 13. 91 is a table number. 92 and 93 are line numbers 1 respectively
3, the table data stored at the coordinates of column number 01 and the table data stored at the coordinates of row number 19 and column number 01 are shown.

On the right side of the 7th record and the 8th record in FIG. 5, "the total of the data of the coordinates of table number 13, row number 13 and column number 01 and the data of table number 13, row number 19 and column number 01" is displayed. Is expressed as part of the match condition.

FIG. 12 shows a processing flow when the matching process is performed using the conditional expression data for the matching shown in FIG. 5 and the table data shown in FIGS. 6, 7, 8 and 9. This processing is performed by the summing / matching processing means 100 in the processing device 30 of FIG.
Executed in.

At step 1201, the designation of the table number to be matched is received from the user.

In step 1202, a match record having the match table number in "table number" is searched from the match condition data. The search target in this case is the data in FIG. If 07 is designated as the table number, the first to sixth records are read as one record group.

At step 1203, the table data is read. In the above example, the table data of table numbers 07 and 01 are read.

In step 1204, steps 1205 to 1206 are repeated until there is no match record group. In step 1205, the butt conditional expressions are added. First, the summing process from 512 to 515 in FIG.
This is performed according to the flow described in FIG. Next Step 12
In 06, the result of the summing process is compared with the constant stored in 517, and it is checked whether or not there is a relation of the butt code stored in 516.

If it is satisfied, the processes 1209 and 1210 are performed. If it does not hold, step 1211 executes the summing process of 506 to 509 on the right side of the butt, as shown in FIG.
It is performed according to the processing flow described in. Next, step 12
In 08, if a match code is stored in 510, the result of the addition processing in step 1211,
The constants stored in 511 are compared, and it is checked whether the butt code stored in 510 holds.
The result of the comparison is stored in 40 temporary storage devices.

If the match code is not stored in 510, steps 1209 and 1210 are executed. First,
In step 1209, 501 to 50 on the left side of the butt
The summing process of No. 4 is performed according to the process flow shown in FIG. Next in step 1210, step 1207
The value of the butt right side obtained in step S1 and the value of the butt left side obtained in step 1209 are checked against the relationship between the butt codes stored in 505. The comparison result is stored in 40 temporary storage devices.

The processing up to this point is repeated until there is no match record group. Finally, in step 1212, the result is output from the 50 output devices.

[0091]

As described above, the conditions for summing / matching occurring between a plurality of cells of a plurality of forms generated in a settlement report of settlement statistics are described in another table, and are described in this table. By performing the consistency check between multiple forms and the summing process according to the conditions, it is possible to prevent human error that has occurred so far and reduce the labor required for manual correction. Will be able to.

[Brief description of drawings]

FIG. 1 is a block diagram of a settlement statistics system.

FIG. 2 is an example of conditional expression data for a match stored in a storage device 10.

FIG. 3 is an example of table data stored in a storage device 10.

FIG. 4 is an example of table data stored in a storage device 10.

5 is an example of conditional expression data for a match stored in the storage device 10. FIG.

6 is an example of table data stored in the storage device 10. FIG.

7 is an example of table data stored in the storage device 10. FIG.

8 is an example of table data stored in the storage device 10. FIG.

9 is an example of table data stored in the storage device 10. FIG.

FIG. 10 shows an example of a processing flow when performing a butt processing.

FIG. 11 shows a processing flow in the case of performing summing processing.

FIG. 12 shows an example of a processing flow when performing a match process.

[Explanation of symbols]

10 ... Storage device, 20 ... Input / output device, 30 ... Processing device, 40 ... Temporary storage device, 50 ... Output device, 60 ... Storage device access control means, 70 ... Table data reading means,
80 ... Relational expression reading means, 90 ... Summing / matching processing means, 100 ... Output data editing means

Claims (1)

[Claims] 1. In a financial accounting system in a local government, a storage device, an input device, and an output device for predefining and storing a plurality of statistical table data and a relationship between a plurality of cells in the table of the statistical table. A processing device for performing a matching process or a summing process between cells, in which the statistical table in the storage device and the relationship between the corresponding cells are read,
A settlement statistics system characterized by performing defined summation processing and reconciliation processing.