JP2000099596A - Automatic title of accounts registering device by format preparation of financial statements - Google Patents

Abstract

PROBLEM TO BE SOLVED: To register title of accounts while grasping the present register state of the title of accounts and also to exclude the necessary item of a system. SOLUTION: An automatic title of accounts registering device is characterized by providing a format storage device 14 storing the formats of financial statements, a display part 13 displaying the financial statements stored in the format storage device 14, a cursor position designating means 11b designating a cursor position in the financial statements which are displayed in the display part 13, an obtaining means 11 displaying a code number and the title of accounts inputted at positions designated by the cursor position designating means and obtaining various kinds of data based on the positions and a means storing various kinds of data obtained by the obtaining means in accordance with the code number and the title of accounts in a master storage device 14.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a device for automatically registering accounts by creating a financial statement format for automatically registering an account master file while creating a financial statement format.

[0002]

2. Description of the Related Art In computer accounting, accounts are coded (items are displayed by numbers) and journalized.
General ledgers, trial balances, and financial statements (balance sheet, income statement, etc.) can be classified and created.

[0003] Then, in order to code the account,
An account master file that stores various information using a code number as a key is provided. Further, an input screen as shown in FIG. 5 is prepared as a means for inputting data including the code number.

[0004] In other words, registration in the account master file is performed on one screen for one account from a screen display layout dedicated to account registration as shown in FIG.

[0005] Specifically, account code "0001"
, The input is made in the order of the account name “cash”, the loan / debit category “1”, the calculation category “1”, and the “financial statement code”. When the input of one account is completed, the input account is deleted from the screen to prepare for registration of the next account.

When an account already registered in the account master file is to be corrected, the account name is displayed on the sub-screen display section 1a when the account code is input, and the corresponding account name is displayed. Select an account.
Then, the selected account item is called from the account item master file, and the account item name and the following items are displayed on the screen for correction.

[0007]

However, in the conventional method, in addition to the code number and the name of the account, the lending category, calculation category, financial statement code, etc. are system-related items as described above. Of course, if you do not have the knowledge of the system, you cannot register the account.

[0008] Further, as shown in FIG. 5, even if the account is registered on the display of one account and one screen, the extent to which the account is registered and the already registered account is correctly registered in the target position on the financial statements. Since it cannot be determined that the financial statements are not executed, there is a problem that a lot of time is spent for registering the account.

SUMMARY OF THE INVENTION The present invention has been made in view of the above points, and an object of the present invention is to register an account while grasping the current registration status of the account. An object of the present invention is to provide a device for automatically registering accounts by creating a financial statement format that can be eliminated.

[0010]

According to a first aspect of the present invention, there is provided an apparatus for automatically registering an account by preparing a financial statement format, comprising: a format storing means for storing a format of the financial statement; and a financial statement stored in the format storing means. , A cursor position designating means for designating a cursor position in the financial statements displayed on the display means, and a code number and an account entered at the position designated by the cursor position designating means. Acquiring means for acquiring various data based on the position, and means for storing the various data acquired by the acquiring means in a master storage device in accordance with the code number and the account. .

According to the first aspect of the present invention, there is provided an automatic account registering apparatus for preparing a financial statement format according to the format of a balance sheet or a profit and loss statement stored in a format storage means such as a financial statement format storage device. The layout is displayed on the display means, and the position of the account item required for the financial statements can be specified in the cursor position specifying means such as a keyboard.

In this way, when the code number and the account are input, the code number and the account are displayed at the position specified by the display means, and various information is obtained based on the position. .

The input code number and the account item are stored together in a master storage device such as an account master storage device.

[0014]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to the drawings. FIG. 1 is a diagram showing a system configuration of a computer system in which various information such as account item information and financial statement format information are stored in an account item master file or a financial statement format file using code numbers as keys.

In FIG. 1, reference numeral 11 denotes a control unit composed of, for example, a microcomputer and peripheral circuits.
The control unit 11 includes a register 11a for storing a record and a register 11b as a cursor position designating unit for storing a cursor display position. ing.

An input unit 12 such as a keyboard is connected to the control unit 11. In this input unit 12,
A move function key 12a for designating a display position of a financial statement format, an insert function key 12b for newly adding, and a delete function key 12 for deleting.
c, a decision function key 12d for confirming the input, a cancel function key 12e for canceling the processing, and an end function key 12f for terminating the work.

The control unit 11 further includes a display unit 13 for performing various displays, an account master storage device 14 for storing account information used by customers, and a financial statement format storage for storing format information of financial statements. Device 15 is connected. The account item master storage device 14 and the financial statement format storage device 15 constitute storage means for storing a master file such as an account item using a code number as a key.

The financial statement format storage device 15 has a form section 15a, a record arrangement number 15b, a section name 15c displayed in the first column of FIG. 2, and an account code 15d displayed in the second column of FIG. The account item name 15e displayed in the third column of FIG. 2 is stored.

The control section 11 is provided with a display section 13.

Next, the operation of the embodiment of the present invention configured as described above will be described with reference to the flowcharts of FIGS.

First, processing for displaying the format of financial statements on the display unit 13 will be described. First, when a format (balance sheet / income statement) is selected on the screen, the processing of the flowcharts in FIGS. 3 and 4 is started. The flowcharts in FIGS. 3 and 4 assume that the balance sheet processing mode is selected.

First, a corresponding record whose form section 15a is in the balance sheet section = 1 is read from the financial statement format storage device 15 into the register 11b of the control section 11 (step S).
1).

Next, the arrangement number 15 of the retrieved record
The display position is determined based on b (step 2).

In the judgment in step S2, if the arrangement number 15b of the record is "1", the classification name 15c, for example, "current assets" is displayed in the first column of the display unit 13 as shown in FIG. .

In the determination in step S2,
When the arrangement number 15b of the record is “2”, the account code 15d, for example, “0001” is displayed in the second column of the display unit 13 as shown in FIG.

Further, in the determination in step S2, when the arrangement number 15b of the record is "3", the account name 15e, for example, "cash" is displayed in the third column of the display unit 13 as shown in FIG. Is done.

Further, if there is an account code 15d, the master key 14a of the account master storage device 14
And the account code 15d is searched for a match, and the corresponding record is stored in the control unit 11 from the account master storage device 15.
Is performed (step S6), and the opening balance 14b is displayed in the fourth column of the display unit 13 as shown in FIG. 2 (step S7).

Then, it is determined whether the search processing of the financial statement format storage device 15 has been completed (step S8).

The determination in step S8 is based on the determination that the form section 15a from the financial statement form storage device 15 has the balance sheet section = 1.
Is determined based on whether or not all the corresponding records have been read.

If the determination in step S8 is "NO", the process returns to step S1 and the processes in steps S1 to S7 are repeated.

Then, when all the relevant records of the balance sheet classification = 1 are read out from the financial statement format storage device 15, "YES" is determined in the step S8, and the function key 12a in the step S9 is determined.
~ 12f reception processing is performed.

Next, the processing for storing in the account master storage device 14 and the financial statement format storage device 15 will be described.

First, an input of data or an input of the function keys 12a to 12f is received from the input section 12, and a process is performed (step S9).

Then, the process of determining the function key whose input has been accepted in step S9 is performed (step S10).

If it is determined in step S10 that the move function key 12a has been pressed, a process of moving the display cursor key up, down, left, and right is performed (step S11).

Thereafter, the process returns to step S9.

If it is determined in step S10 that the insertion function key 12b has been pressed, it is determined whether the position of the display cursor is in the first or second row (step S12).

Here, the insertion function key 12b is valid when the display cursor position is in the first and second columns, and is invalid when the display cursor position is in the third and fourth columns.
This is because, as shown in FIG. 2, insertion is permitted only for the section name in the first column and the account item in the second column.

Then, "YE" is determined in step S12.
S, that is, when it is determined that the display cursor position is in the first and second columns, the lower line is shifted down by one line from the line at the current display cursor position, and the current position is changed. Is set to a blank line and displayed again on the display unit 13 (step S13).

Then, the line number of the lower line is incremented from the line at the current cursor display position of the register 11b of the control unit 11 (step S14). Thereafter, the process returns to step S9.

If it is determined in step S10 that the confirmation function key 12d has been pressed, it is determined in what row the display cursor position is (step S15).

If it is determined in step S15 that the position of the display cursor is in the first column, a process of displaying the input section name at the position of the display cursor on the display unit 13 is performed (step S16). ).

Then, the section name of the display force-sol position indicated by the register 11b of the control section 11 is written (step S17).

Thereafter, the flow returns to step S9.

If it is determined in step S15 that the position of the display cursor is in the second column, it is determined whether there is an account at the position of the display cursor indicated by the register 11b of the control unit 11. Is performed (step S18).

If it is determined in step S18 that "exists", the process returns to step S9.

Then, in the judgment of step S18,
If it is determined that the account code does not exist, the entered account code is displayed at the display cursor position of the display unit 13, and the match search process between the master key 14a of the account master storage device 14 and the entered account code is performed. Is performed (step S19).

When the determination in step S19 is "NO", that is, when the master key 14a of the account master storage device 14 and the input account code are determined to be "matched", for example, "already registered". Such a duplicate error display is displayed on the display unit 13 (step S21).

Thereafter, the process returns to the step S9.

By the way, in the determination of step S20, "YE
S ", that is, when it is determined that the master key 14a of the account master storage device 14 and the input account code are" mismatch ", the account code is displayed on the display unit 13 (step S22).

Then, using the input account code as a master key, various types of information (such as a loan category and a calculation category) are acquired from the position of the display cursor and are stored in the account master storage device 14 including the various types of information (step). S2
3).

Further, the account code is written at the display cursor position indicated by the register 11b of the control section 11 (step S24).

Thereafter, the process returns to the step S9.

If it is determined in step S15 that the display cursor position is in the third column, the account code of the line number of the display cursor position indicated by the register 11b of the control unit 11 exists. It is determined whether or not to perform (step S25).

If it is determined in step S25 that "there is not present", the process returns to step 9 without performing any processing.

If it is determined in step S25 that the account exists, the input account name is displayed at the position of the display cursor on the display unit 13 (step S2).
6).

Then, a search is made for a match between the master key of the account master storage unit 14 and the account code of the line number at the display cursor position of the register 13b of the control unit 13, and
A process of reading the corresponding record into the register 11a of the control unit 11 is performed (Step S27).

Then, a process of writing the input account name into the register 11a is performed (step S2).
8).

Further, a process of storing the register 11a in the account master storage device 14 is performed (step S29).

Further, a process of writing the input account name at the display cursor position of the register 11b of the control section 11 is performed (step S30).

Thereafter, the process returns to step S9.

If it is determined in step S15 that the display cursor position is in the fourth column, it is determined whether the account code of the line number of the display cursor position in the register 11b of the control unit 11 exists. It is determined (step S31).

If it is determined in step S 31 that “there is not present”, the process returns to step 9.

On the other hand, if it is determined in step S31 that "existing" exists, processing for displaying the input beginning balance at the position of the display cursor on the display unit 13 is performed (step S32).

Further, a match search process is performed between the master key of the account master storage unit 14 and the account code of the line number at the display cursor position of the register 13b of the control unit 13, and
A process of reading the corresponding record into the register 13a of the control unit 13 is performed (Step S33).

Further, the input beginning balance is registered in the register 1.
The process of writing to 1a is performed (step S34).

Further, the beginning balance written in the register 11a is stored in the account master storage device 14 (step S35).

Thereafter, the flow returns to step S9.

Returning to the flowchart of FIG.
If it is determined in step S10 that the delete function key 12c has been pressed, it is determined whether the position of the display cursor is in the first or second row (step S36).

Here, the delete function key 12c is valid when the display cursor position is in the first and second columns, and is invalid when the display cursor position is in the third and fourth columns.
This is because, as shown in FIG. 2, deletion is permitted only for the section name in the first column and the account item in the second column.

In the determination in step S36, "YE
If it is determined to be "S", a deletion confirmation display such as "Delete the current item." Is displayed on the display unit 13 (step S37).

Then, it is determined whether the enter key has been pressed (step S38). If "YES" is determined in the determination in step S38, the display is re-displayed on the display unit 13 by being shifted upward by one line from the line next to the display cursor position (step S39).

Further, the line number is decremented from the line following the display cursor position of the register 11b of the control section 11 (step S40). Thereafter, the process returns to step S7.

If the determination in step S38 is "NO", it is determined whether the withdrawal key has been pressed (step S41).

If the determination in step S41 is "NO", the process returns to step S37.

On the other hand, "YES" in the determination in step S41.
Is determined, that is, when it is determined that the cancel key is pressed, the process returns to step S9, and the process of accepting the function key is performed.

If it is determined in step S10 that the end function key has been pressed,
The register 11b of the control unit 11 is stored in the financial statement format storage device 1.
5 and the operation is terminated (step S42).

In the above embodiment, the balance sheet among the financial statements has been described. However, the present invention can be similarly applied to a profit and loss statement.

[0079]

According to the first aspect of the present invention, the layout according to the format of the balance sheet and the income statement stored in the format storage means such as the financial statement format storage device is displayed on the display means. By inputting a code number and an account, for example, a cursor position specifying means such as a keyboard can be used to specify in which position an account item required for financial statements is to be written. Since the code number and the account item are displayed on the screen, various information is obtained based on the position, and the input code number and the account item are combined and stored in a storage device such as an account master storage device. You can freely create the format that suits the customer by creating the financial statement format, and at the same time, automatically register it in the account master file such as the account master storage device. It is possible to provide an automatic account registering apparatus by creating a financial statement format that can register an account while grasping the registration status of the account, and can eliminate essential items of the system. is there.

[Brief description of the drawings]

FIG. 1 is a system configuration diagram of an account automatic registration device by creating a financial statement format according to an embodiment of the present invention.

FIG. 2 is an exemplary view showing a display state of format creation of financial statements according to the embodiment;

FIG. 3 is a flowchart for explaining the operation of the embodiment.

FIG. 4 is a flowchart for explaining the operation of the embodiment.

FIG. 5 is a diagram showing a display state of registration of a conventional account.

[Explanation of symbols]

 11: control unit, 11a, 11b: register, 12: input unit, 12a: move function key, 12b: insert function key, 12c: delete function key, 12d: finalize function key, 12e: cancel function key, 12f: end function Keys, 13 ... Display unit, 14 ... Account item master storage device. 14a: Master key, 14b: Beginning balance, 15: Financial statement form storage device, 15a: Form classification, 15b: Arrangement number, 15c: Classification name, 15d: Account code, 15e: Account name.

Claims (1)

[Claims] 1. A format storage means for storing a format of financial statements, a display means for displaying financial statements stored in the format storage means, and a cursor position is designated in the financial statements displayed on the display means. A cursor position designating means; a code number and an account entered at a position designated by the cursor position designating means; an acquiring means for acquiring various data based on the position; Means for automatically storing various data acquired by the acquisition means in a master storage device.