JPH0689298A - Composite processing system for financial data and taxational data - Google Patents

Abstract

PURPOSE:To input both financial data and taxational data at one time through the use of a data input means at the time of the generation of the financial data by coordinating a title code and an income tax classification code with each other. CONSTITUTION:An integrated dile 3 generated from payment data (a) is made the input, and for data having the title code of an annual expenditure file 8, the amount of payment of the integrated file 3 is made capable of being paid out by adding it to the amount of payment of the annual expenditure file 8, and financial processing 6 is executed by subtracting the amount of payment from a payable amount of money. Besides, at that time, a written order for payment 9 showing a payment slip number, the date of payment, the title code, the amount of payment, and creditor information is issued. Besides, the 'account statement of an income tax collected amount' 12 is generated from the data stored in the integrated file 3. Further, the amount of year-end adjustment is calculated from the deduction data of a creditor file 4, and a taxation information file 10 classified by an individual is generated, and at that time, a withholding tax collection slip 11 on which a prescribed total amount after the year-end adjustment, the amount of deduction, the amount of an income tax are displayed is tabulated.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a composite processing method of financial data and tax data, and is taken by a special tax collector who has an obligation to withhold income tax in the act of paying salaries and remuneration in financial accounting. The present invention relates to a composite processing method of financial data and tax data in financial processing and tax processing.

[0002]

2. Description of the Related Art When paying salaries, remuneration, etc. to a creditor, a special collection duty person withholds the income tax equivalent to the total payment amount and actually pays the amount after tax. In addition, by paying the income tax portion to the tax office in a lump sum every month, the special collection obligee becomes a creditor (taxpayer) and pays the tax.

In the conventional method, as shown in FIG. 4, in the financial processing and the tax processing, data is individually input and the processing is individually performed. The details of the individual processing will be described below.

Regarding financial data processing, in the expenditure processing of financial accounting, the payment date, the subject (use / purpose), the total amount of payment, and the amount of withholding tax are input to the creditor by the data input means 13 by the payment act, and Through the process 6, the payment order document 9 is issued by referring to the creditor file 4 and the code name file 5.

At this time, the total payable amount is subtracted from the payable amount 83 held in the expenditure file 8 to update the payable amount in the subject. In addition, the withholding tax amount is transferred from the expenditure data to the annual revenue / expenditure data, and the withholding tax amount is aggregated at a later date and paid to the tax office as the withholding amount of the income tax. Therefore, the creditor (the person who received the payment of salary etc.) will be paid with the withholding tax.

[0006] Regarding the processing of tax data, the special collection duty person pays the payment order document 9 paid by each department on a monthly basis.
The withholding tax amount is input by the data input means 14 based on the above, and the individual tax information file 10 is created.

[0007] The tax amount of the individual tax information file 10 is aggregated by the tax process 7 and it is checked whether or not the withholding tax amount of the annual revenue / expenditure data transferred from the annual expenditure data matches, and the withholding tax amount is paid to the tax office. I do.
In addition, as the annual processing (December), from tax processing 7, all the creditors of the special collection obligee are referred to for withholding tax (aggregated by each creditor), and paid from each department in one year. Amount and income tax amount are classified as income tax (use / purpose)
Separately, the aggregated income tax collection amount statement 12 is created. In addition, year-end adjustment processing is performed according to the contents of various deductions, the annual total income tax amount is determined, and the withholding slip 11 for each creditor is created.

[0008]

In the above-mentioned conventional individual processing of financial data and tax data, the data relating to income tax differs in the necessary time of data, incidental information, and processing unit. The income tax data entered in the process is used only in the financial process, and in the tax process, the income tax data is added to the tax classification data and separately input to perform the aggregate name matching process. In particular, since the subject code of financial data and the income tax classification code of tax data always show the use / purpose regardless of the code system, there is a problem that double input is unavoidable. It was

Further, in order to manage the income tax data in duplicate, it is necessary to input the data twice, to reserve a file area in duplicate, and to contradict / mismatch the income tax data between the financial processing and the tax processing. There is a problem in that there is a possibility that various situations occur.

[0010]

A composite processing method of financial data and tax data of the present invention is a financial data and tax data in a computer system. A method to enter the number, an integrated file that stores the item code of financial data and the tax classification code of tax data in association with each slip, and the information of the person who has the right to receive payment or the person who has the obligation to pay income tax Creditor file, code name file that stores the code and the name corresponding to the code required for financial or tax processing, and the data necessary for financial processing are the integrated file, the creditor file, and the code name. Financial data management means that edits the file and provides it for financial processing, and the integrated file Is calculated for each creditor to obtain the amount of payment or withholding amount for each individual income tax code, and the deduction data held in the creditor file is combined to calculate the year-end adjustment amount and create an individual tax information file It is equipped with a tax data management means for providing tax processing.

[0011]

Embodiments of the present invention will now be described with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of a composite processing system of financial data and tax data of the present invention.

As shown in FIG. 1, the composite processing method of financial data and tax data of the present embodiment has a data input means 1 for controlling the input of payment data a and a data management for managing the input data. Means 2, an integrated file 3 for storing the input data, a creditor file 4 for storing the information of the person who has the right to receive payment or the person who has the obligation to pay the income tax, and the data of finance and tax Code name file 5 that stores codes for classification, tax processing 7 that calculates documents such as documents to be submitted to the tax office, tax amount, year-end adjustment, etc., account to be sent to spending slips and creditors It is composed of a financial process 6 for outputting a transfer notification.

The payment data a is generated when paying a salary / reward to a staff member or a person who has provided a service employed by the local government. This payment data a includes a unique payment slip number 31 for each data item as shown in the configuration diagram of the data items of the integrated file in FIG. 5, and a payment date 32 for payment.
And the financial data 33 which is the financial accounting budget subject code 3
31. The payment amount 332, the income tax classification code 341 which is the tax data 34, and the withholding tax amount 342 are stored in the financial data 33 and the tax data 34 of the integrated file 3 by using the data input means 1 which can be input at the same time.

Further, the information (name 43, address 44, kana name 42, date of birth 45, bank account number) of the creditor who receives the payment as shown in the configuration diagram of the data items of the creditor file of FIG. 6 is also included. It is necessary to input them at the same time, but since these information are quoted from the creditor file 4 using the creditor number 41 as a key, only the creditor number 35 is stored as creditor data and the data of the integrated file 3 is created. . Similarly, the subject name, bank name, and income tax classification name are also required, but this is code type 5 from code name file 5.
1. Name 53 or abbreviation 54 with the code 52 as a key
It is not necessary to have a name as data in the integrated file 3 to refer to.

FIG. 2 is a system flow chart for executing the financial processing 6 in the composite processing system shown in FIG. With the integrated file 3 generated from the payment data a as an input,
The payment amount 332 of the integrated file 3 for the data having the subject code 81 of the expenditure file 8 as shown in the structure diagram of the data items of the expenditure file of FIG. 8 which is similar to the subject code 331 stored in the financial data 33. , Expenditure file 8
The payout amount 82 is added to the payable amount 82, and the payable amount 82 is subtracted from the payable amount 83 to perform the financial processing 6. The payout amount 82 of the expenditure file 8 stores the total amount paid up to the present, and the payable amount 83 stores the amount that can be used for future payment.

At this time, a payment order form 9 is issued which displays the payment slip number, payment date, subject code, payment amount, and creditor information (creditor number, name, address).

FIG. 3 is a system flow chart when the tax processing 7 is carried out in the complex processing system of FIG. As a procedure for withholding tax, the special tax collector must attach the “income tax withholding statement” 12 to the nearest tax office by the 10th day of the month following the month in which the taxable income is paid to the creditor. You have to pay a considerable amount. Therefore, from the data stored in integrated file 3, payment date 3
Data for which 2 is the previous month is extracted, and income tax classification code 34
The “income tax collection amount calculation statement” 12 is created by aggregating by one.

Further, the special collection duty person carries out the year-end adjustment process in order to match the tax amount withheld for one year (January 1st to December 31st) with the legal annual tax amount. For that purpose, first, using the creditor number 35 of the integrated file 3 as a key,
Annual payment amount 332 per creditor 332
Withholding tax amount 342 is collected for each income tax classification code 341 and stored in income amount 1021, 1023 and withholding amount 1022, 1024 of the amount table by income tax classification code 102 corresponding to creditor number 101, respectively. In addition, the deduction data 46 (dependent relative 461, special disability 462, social insurance 463) of the creditor file 4 is used to adjust the year-end adjustment amount of 10
3 is calculated, and an individual tax information file 10 as shown in the configuration diagram of the data items of the individual tax information file of FIG. 9 is created. At this time, the withholding slip 11 showing the total income, deduction amount, and income tax amount after year-end adjustment is tabulated.

As described above, the payment data is the subject code 33.
1 and income tax classification code 341 are associated and payment amount 332
By the data input means 1 for inputting the withholding tax amount 342, the financial data 33 and the tax affairs data 34 are combined in the integrated file 3 as integrated data, and the financial data 3
By having the data management means 2 that can manage 3 and the tax data 34 together, the data once input is used in the financial process 6 and the tax process 7.

[0021]

As described above, in the composite processing method of the financial data and the tax data of the present invention, the item code and the income tax classification code are associated with each other. It is now possible to enter both and tax data at once. Also, because we decided to have financial data and tax data in a form that can be centrally managed as integrated data, it is not necessary to have common information shared between financial data and tax data, and data maintenance can be done with financial data and tax data. Can be done more easily than when they exist separately.

[Brief description of drawings]

FIG. 1 is a block diagram showing an embodiment of a composite processing system of financial data and tax data of the present invention.

FIG. 2 is a flowchart showing an example of an operation of financial data processing in the composite processing method of financial data and financial data according to the present embodiment.

FIG. 3 is a flowchart showing an example of an operation of financial data processing in the composite processing method of financial data and tax affairs data of the present embodiment.

FIG. 4 is a block diagram showing conventional financial data processing and tax affairs data processing.

FIG. 5 is a configuration diagram of data items of an integrated file in the composite processing method of financial data and financial data according to the present embodiment.

FIG. 6 is a configuration diagram of data items of a creditor file in the composite processing method of financial data and financial data according to the present embodiment.

FIG. 7 is a configuration diagram of data items of a code name file in the composite processing method of financial data and financial data according to the present embodiment.

FIG. 8 is a configuration diagram of data items of an expenditure file in a composite processing method of financial data and financial data according to the present embodiment.

FIG. 9 is a configuration diagram of data items of an individual tax information file in the composite processing method of financial data and financial data according to the present embodiment.

[Explanation of symbols]

 1 Data input means 2 Data management means 3 Integrated file 4 Creditor file 5 Code name file 6 Financial processing 7 Tax processing 8 Expenditure file 9 Payment order 10 Individual tax information file 11 Withholding slip 12 Income tax collection calculation

Claims (1)

[Claims] [Claim 1] In financial and tax processing in a computer system, means for inputting financial data and tax data that are the contents of integrated data, and the management number of the target creditor, and the item code and tax affairs of financial data for each slip An integrated file that stores the income tax classification code of the data in association with it, a creditor file that stores information of the person who is entitled to receive payment or the person who is required to pay income tax, and the code required for financial or tax processing And a code name file that stores the name corresponding to the code,
Financial data management means for editing data necessary for financial processing from the integrated file, the creditor file and the code name file and providing the financial processing, and income tax for each individual by accumulating the integrated file for each creditor. A tax data management means is provided for obtaining tax payments and withholding amounts for each code, adding the deduction data held in the creditor file to calculate the year-end adjustment amount, and creating a personal tax information file for tax processing. A composite processing method for financial data and tax data.