JPH05334326A - Fixed assets return operation processing system - Google Patents

Abstract

PURPOSE:To prepare documents to be reported while proportionally distributed to the unspecified large number of return places as to fixed assets tax. CONSTITUTION:A data base DB to which asset information, return places, and their proportional distribution rate are inputted, asset by asset, from an input device 1 is prepared. A detail information registration processing part 3 prepared a detailed file F1 of all assets and a detailed file F2 wherein the amount of money is proportionally divided by using the data base DB. A money amount totalization processing part 4, on the other hand, prepares a money amount totalization file F3 classified by the kinds of all the assets and a money amount totalization file F4 by the kinds of the assets wherein all the assets are proportionally divided by the return places by using the data base DB. An all asset depreciation report D3 is prepared from the money amount totalization file F3 and file F1 for details, and a depreciation asset report D4 classified by the return places is prepared from the money amount totalization file F4 and file F2 for details.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a fixed asset filing business processing method, and more particularly to a fixed asset filing business processing method including assets that need to be divided and declared in unspecified large numbers of filing locations.

[0002]

2. Description of the Related Art Conventionally, in the fixed asset declaration business processing method, if each asset belongs to one declaration place, it is possible to process the statement by type and the depreciable asset declaration document to be submitted, Even if the ground is complicated, it doesn't matter. However, when it is necessary to apportion the reported amount of one asset to multiple reporting locations, the apportioning process is performed manually. In other words, the depreciable assets declaration, which is a document for the total amount, is posted after totaling the amounts after apportionment according to the reporting place, and the statement by type, which is a document showing the details, is also the item after apportioning according to the reporting place. Is to be posted.

[0003]

In the above-mentioned conventional fixed asset filing business processing method, when there are assets that must be reported to an unspecified number of filing sites, the fixed amount filing process is submitted from the apportioning process of the filing amount. There is a problem in that it takes a lot of time to process because it is necessary to manually create the documents for use.

[0004]

[Means for Solving the Problems] In the fixed asset filing business processing method of the present invention, in the fixed asset filing business processing method including the assets to be divided and filed in a large number of unspecified places, the contents of the asset for each asset are A database that registers the information shown and the tax return and the percentage of each tax return in the entire asset, and for each asset read from this database, calculates the taxable amount for the entire asset and calculates this along with the asset content. The calculated taxable amount is stored in the first detailed file, and the taxable amount and the acquisition price according to the declared place of the entire asset are proportionally divided according to the above-mentioned ratio, and the divided amounts together with the asset content. And a detailed information registration processing means for storing in the second detailed file, and an increase amount and a decrease amount of the asset according to a predetermined asset type for each asset read from the database. The accumulated amount is stored in the first monetary amount aggregation file, the increase amount and the decrease amount of the asset of one asset according to the declaration place are proportionally divided according to the ratio, and accumulated according to the type of the asset Amount totalization processing means for storing the total amount of money for all assets, and an amount totalization report output for all assets for creating a depreciable asset report for all assets of a format defined by the first detailed file and the first amount of totalization file And a means for outputting the amount-of-department-by-declaration form report output means for creating a declarative property by region and a depreciable asset report of a format defined by the second detailed file and the third amount collection file.

[0005]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram of an embodiment of the present invention.
The embodiment shown in FIG. 1 has an input device 1, a fixed asset information registration unit 2, a detailed information registration processing unit 3, an amount totalization processing unit 4, a total asset detailed form output unit 5, a report-specific detailed form output unit 6, and a total asset use. Amount summary form output unit 7, amount summary form output unit for each declared place 8, database DB, detail files F1 and F2, amount summary files F3 and F4, statement D by type for all assets
1, a description D2 by type of declared land, a depreciable asset declaration D3 for all assets, and a depreciable asset declaration D4 by declared place.

In the above structure, first, data is registered in the database DB from the input device 1 via the fixed asset information registration section 2. FIG. 2 is a diagram showing a screen layout displayed on the input device 1 for data registration. Information of one asset is input on one screen and managed by the asset number 21. Declaration code 22 and 23
The codes of the first declaration place and the second declaration place where the asset is declared are entered in. In the apportioning ratio 24, the percentage of the entire first asset to be declared at the time of making a declaration is entered as a percentage. There is no default for percentage. Here, the method of setting the reporting place codes 22 and 23 and the proportional division ratio 24 will be described with respect to three concrete examples. As a first example, one asset is a ratio of 2 to 3 between the reporting place “A” and the reporting place “B”. When making a declaration in “1”, “A” and “B” are assigned to the declared code 22 and 23, respectively, and the proration rate 24
Enter 40, which is the ratio of the reporting location "A". As a second example, in the case where one asset is all declared to the declaration place “A”, the code “A” is entered in the declaration place code 22 and not entered in the declaration place code 22. Enter 100 for the proration rate. As a third example, if one asset is not subject to the declaration, nothing is entered in all of the declared place codes 22 and 23 and the proration rate 24. In the data thus input from the input device 1, the fixed asset information registration unit 2 stores all detailed information in the database DB in asset number units.

The detailed information registration processing section 3 uses the database D.
Detailed files F1 and F whose format is shown in FIG.
Create 2. FIG. 3 is a flowchart of the processing of the detailed information registration processing unit 3. Hereinafter, the processing of the detailed information registration processing unit 3 will be described with reference to FIG. The detailed information registration processing unit 3 first reads one piece of data from the database DB (step 101), and calculates the taxable amount of the entire asset (step 102). The taxable amount is calculated according to the tax law, and the items required for calculation are database D for each asset.
According to the data read from B. Next, the detailed file F
The information of each asset and the taxable amount calculated in step 102 are output to 1 (step 103). Next, from the taxable amount and the acquisition price of the entire one asset, the first declaration place code 22
The taxable amount and the acquisition price of the declared place entered in are calculated by the pro rata ratio (step 104), and the file F for details
The information of the assets and the amount of the declared place input to the first declared place code 22 calculated in step 104 are output to 2 (step 105). Next, it is checked whether the tax return code 23 is entered (step 106), and the tax return code 2 is entered.
If 3 is entered, the taxable amount and the acquisition price of the second tax return code 23 will be the first from the total amount of one asset.
Calculated by deducting from the amount of the declared place (step 10
7). The information of each asset and the amount of money for the second declared place calculated in step 107 are output to the statement file F2 (step 108). Next, one item of the next data is read from the database DB, and if the data is not over, step 102
Return to step (109, 110). Note that step 10
If there is no input in the declared place code 23 in 6, the process immediately proceeds to step 109.

[0009] Here, supplementing the description of the specification files F1 and F2, the specification file F1 is a file for outputting the specification D1 for all assets, and, like the database DB, one record for one asset and declaration. The place code is the code input as the first declared place code 22 in FIG. The file F2 for details is a file for outputting the statement D2 for each declaration place, and when there are two declaration places for one asset, each of the first declaration place code 22 and the second declaration place code 23 in FIG. Two records of the code entered in are output.

The all-materials detailed statement output unit 5 reads the information stored in the detailed file F1 record by record, and performs printing processing in accordance with the form layout of the total asset type specific statement D1. The report place-specific statement form output unit 6 sorts the information stored in the statement file F2 according to the report place code, and then prints the report form according to report place type D. FIG. 9 is a diagram showing the layout of the type-specific statements D1 and D2 for all assets and for each declared place defined by the local tax law.

The monetary amount processing unit 4 uses the database DB to generate monetary amount files F3 and F4 whose format is shown in FIG.
To create. FIG. 4 is a flowchart of the process of the amount totaling processing unit 4. Hereinafter, the process of the amount totaling processing unit 4 will be described with reference to FIG. The monetary amount processing unit 4 first
One data is read from the database DB (step 201), it is checked whether there is an increase asset or a decrease asset (step 202), and if there is a change in the asset, the increase amount or the decrease amount in the corresponding asset type column of the aggregation table. The acquisition price is added to (step 203). Further, the report place code column 71 of the tabulation table is blank because it is for the entire company. The totaling table is a table provided for processing, and as shown in an example of the configuration in FIG. 7, has an increase / decrease column for each of the types of assets defined by the tax law and a tax return code column 71. One is provided for the file F3, and one is provided for each declared place code for the amount totaling file F4. Now, next, from the acquisition price of one asset as a whole, the acquisition price for the declared place entered in the code of the first declared place code 22 is calculated by the proration rate, and the increase amount in the applicable asset type column of the aggregation table is calculated. Or, add the calculated amount on the reduction amount column. At this time, the reporting place code column 71 of the tabulation table is the first reporting place code 22.
Is the code input to (steps 204, 20
5). Next, it is checked whether the tax return code 23 has been input (step 206). If the tax return code 23 has been input, the acquisition price for the tax return input in the tax return code 23 of the acquisition price of the entire asset is It is calculated by subtracting the amount of money for the first declared place from the amount of money of the entire assets (step 207). next,
Add the calculated amount to the increase amount or decrease amount column of the corresponding asset type column of the aggregation table. The declared place column 71 of the totaling table at this time is the code entered in the second declared place code 23 (step 208). Next, one item of data is read from the database DB, and if the data is not over, the process returns to step 202 (steps 209, 21).
0). If all the data is completed, the contents of the summary table with a blank place code are the amount summary file F3.
The contents of non-blank are output to the amount totaling file F4 (step 211). In addition, when there is no change in step 202 and in step 206, the tax return code 2
If there is no input of 3, the process immediately moves to step 209. FIG. 6 is a diagram showing the structure of the amount totalizing files F3 and F4, and the items are the same as those in the totalizing table in FIG.

The total asset amount report output unit 7 and the amount-of-declaration amount report output unit 8 for all assets are depreciated for all assets from the amount aggregate file F3, the detail file F1, and the amount aggregate file F4 and the detail file F2, respectively. The asset declaration form D3 and the depreciable asset declaration form D4 for each declared place are output. FIG. 8 is a diagram showing the format of a tax return for depreciable property tax stipulated by the local tax law, and shows only the portion processed by computer.
The one acquired in the previous year in the figure (a), and each item in the lower row are the sum of the amounts in the file F1 or F2 for details, which decreased in the previous year (b) and acquired in the previous year. The thing (c) is the amount tabulation file F3 or F
4 are the amount of increase and the amount of decrease, respectively. The depreciable asset declaration D3 for all assets is one, but the depreciable asset declaration D4 for each declared place is two in this embodiment, but corresponds to the number of declared places.

[0013]

As described above, according to the present invention, for an asset having a plurality of property tax return points, when the fixed asset information is registered, the return point code for each asset and the proportional distribution rate corresponding to each return point are registered. By registering and, and creating a file in which the amount of money is apportioned according to the filing location, the submission documents for each filing location are created, so there is an effect that it is possible to reduce the fixed asset tax aggregation work for each filing location.

[Brief description of drawings]

FIG. 1 is a configuration diagram of an embodiment of the present invention.

FIG. 2 is a diagram showing a screen layout displayed on the input device of FIG.

FIG. 3 is a flowchart of processing of a detailed information registration processing unit in FIG.

FIG. 4 is a flowchart of an amount totalization processing unit in FIG.

5 is a format diagram of the detailed file of FIG. 1. FIG.

FIG. 6 is a format diagram of the amount totaling file of FIG.

FIG. 7 is a diagram showing a configuration of an aggregation table used in the processing of the flowchart of FIG.

FIG. 8 is a diagram showing the layout of the depreciation report for all assets and the depreciation report for each place of declaration in FIG. 1.

FIG. 9 is a diagram showing a layout of a type-specific statement for all assets and a type-specific statement for each declared place in FIG. 1;

[Explanation of symbols]

 1 Input device 2 Fixed asset information registration unit 3 Detail information registration processing unit 4 Amount aggregation processing unit 5 Detail report output unit for all assets 6 Detail report output unit for each report place 7 Amount summary report output unit for all assets 8 Amount for each report place Total form output part 21 Asset number 22,23 Declaration place code 24 Proportional ratio DB database F1, F2 Detail file F3, F4 Amount summary file D1 All asset type statement D2 Declaration place type statement D3 All assets Depreciable Asset Declaration D4 Depreciable Asset Declaration by Location

Claims (1)

[Claims] [Claim 1] In a fixed asset filing business processing method that includes assets to be divided and declared in an unspecified number of filing locations, information indicating the contents of assets for each asset, filing location, and filing each of the entire assets For each asset read from this database, the database in which the percentage of land is registered is calculated, and the taxable amount for the entire asset is calculated, and the calculated taxable amount is stored in the first detailed file together with the asset content. Detailed information registration processing means for apportioning the taxable amount and the acquisition price for each declared place of the total assets according to the ratio, and storing the apportioned respective amounts in the second specification file together with the asset contents, and the database. The accumulated amount of increase and decrease of the asset is accumulated according to the type of asset determined in advance for each asset read from and stored in the first monetary aggregation file. Amount totalizing processing means for apportioning the amount of increase and the amount of decrease of assets for each declared place according to the ratio, accumulating according to the type of the assets, and storing the accumulated amount in a second amount totalizing file; A monetary amount totalization report output means for all assets that creates a depreciable asset declaration for all assets in a format determined from the detailed file and the first monetary totalization file, the second detailed file and the third monetary totalization file A method for processing fixed asset declaration business, comprising: means for outputting a report of amount of money for each declared location for creating a depreciable asset declaration for each declared location in the format defined by