JP2017174130A - Accounting data preparation device, accounting data preparation method, and accounting data preparation program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an accounting data preparation device which enables creation of accounting data having a layout with a sense of unity without spending significant time and effort.SOLUTION: According to the present invention, when a data collection of first accounting data belonging to a plurality of account titles is used to create second accounting data of a certain table type for layout on a spread sheet having a plurality of cells arranged in row and column directions, a first master and a second master are referenced and character strings corresponding to the first accounting data in a collection belonging to an account title determined according to a selected table type are disposed in a certain cell determined based on the first master and a cell which is in a relative position determined based on the second master. In this manner, second accounting data is created in which the character strings corresponding to the first accounting data in the collection are disposed in multiple cells.SELECTED DRAWING: Figure 2

Description

  The present invention relates to an accounting data creation device, an accounting data creation method, and an accounting data creation program.

  Patent Document 1 describes a computer system including a business process control terminal that performs data processing of corporate financial accounting management business software (see claim 1). The computer system described in Patent Document 1 is configured such that data management items and item arrangement (layout) can be set in advance using a default setting display screen (see FIG. 2). S21 to S23). By using the computer system described in Patent Document 1, registration data can be input in the set items and order during business processing (see S25).

JP 2002-083258 A

  Here, in the technique described in Patent Document 1, the item arrangement setting is performed by receiving a drag with the mouse by the user via the item arrangement setting display screen prepared for that purpose (paragraph [0024]. ]reference). Therefore, in the technique described in Patent Document 1, setting is performed only on a setting screen that can accept dragging with a mouse, that is, only within a range of a layout (form) in which items can be arranged. There is no freedom of change.

  By the way, in management accounting in a company, an accounting person must create management data created on a spreadsheet in spreadsheet software (for example, Excel (registered trademark) of Microsoft Corporation) using existing accounting data. There are many. However, since such management materials are created manually, there is a problem that it is not always possible to create equivalent management materials with the same layout in the following month. In addition, for large corporations with multiple affiliated companies, it is extremely difficult to ensure the same appearance as that of other companies even if the accounting staff of each affiliated company intends to create management documents for its own company with a predetermined layout. For this reason, there is a problem that a sense of incongruity such as lack of unity occurs when comparing a plurality of management materials collected from affiliated companies. These problems are that the format created by hand does not incorporate the know-how and work of the accountant, or the format of the original accountant can be used by other accountants. This is because the know-how and work cannot be grasped. In particular, the accounting data has a wide variety of subjects, and the number of data such as daily and monthly is enormous, so the above problem becomes more prominent.

  Based on the above, it is required that accounting data such as accounting materials can be automatically created from existing accounting data with a unified layout, using a highly flexible spreadsheet, regardless of the form. ing. And if such a thing is realizable, it will also be anticipated that the effort of preparation of the accounting data for management accounting or tax accounting can be reduced significantly.

  Accordingly, an object of the present invention is to provide an accounting data creation device, an accounting data creation method, and an accounting data creation program capable of creating accounting data having a unified layout without taking much time and effort. .

  In order to solve the above-described problems and achieve the object, the accounting data creation apparatus according to the present invention uses a data group of the first accounting data of a plurality of subjects, and a plurality of cells are arranged in a row direction and a column direction. An accounting data creation device having a control unit for creating second accounting data of a predetermined table type to be arranged on a spreadsheet, wherein the control unit is configured to store predetermined cells in the spreadsheet. A first master associating cell specifying information relating to a row and a column, subject information relating to a subject of first accounting data selected from the data group, and table type information relating to the type of the table type, and the table Type information, relative position information for defining the relative position from the predetermined cell by the number of cells in at least one of the row direction and the column direction, and the previous By referring to the second master that associates the first accounting data of the group belonging to the subject corresponding to the subject information with each other, the first accounting of the group belonging to the subject determined according to the selected table type It is characterized by comprising arrangement means for arranging a character string corresponding to data in the predetermined cell and the cell at the relative position.

  Further, the accounting data creation device according to the present invention is the accounting data creation device described above, wherein the spreadsheet is one spreadsheet in an electronic file including a plurality of spreadsheets, and The arrangement means further specifies layout information relating to the relative position corresponding to the first accounting data of the group in the second master and the one spreadsheet among the plurality of spreadsheets. A character string corresponding to the first accounting data of the group is arranged in a spreadsheet specified by the sheet specifying information by referring to a third master that associates the sheet specifying information with each other. And

  Furthermore, the accounting data creation device according to the present invention is the accounting data creation device described above, wherein the control unit is identified by the first accounting data of the first group, the sheet identification information, and the sheet identification information. The sheet name is set to the spreadsheet in which the first group of first accounting data is to be arranged by referring to the fourth master that associates the sheet name information relating to the sheet name to be set in the spreadsheet to be arranged. A sheet name setting unit is further included.

  Furthermore, the accounting data creation device according to the present invention is the accounting data creation device described above, wherein the control unit is identified by the first accounting data of the first group, the sheet identification information, and the sheet identification information. Including the spreadsheet in which the first accounting data of the group is arranged by referring to the fifth master that associates the file name information relating to the file name to be set in the file including the spreadsheet to be set with each other It further includes file name setting means for setting a file name to the file to be executed.

  In addition, the accounting data creation method according to the present invention uses a data group of first accounting data of a plurality of subjects, which is executed in an accounting data creation device provided with a control unit, so that a plurality of cells are in a row direction and a column direction An accounting data creation method for creating second accounting data of a predetermined table type to be arranged on a spreadsheet arranged in a spreadsheet, wherein the predetermined data in the spreadsheet is executed in the control unit A first master that associates cell specification information relating to rows and columns, subject information relating to subjects of first accounting data selected from the data group, and table type information relating to the type of the table type, and the table type Information, relative position for defining relative position from the predetermined cell by the number of cells in at least one of the row direction and the column direction A group belonging to a subject determined according to the selected table type by referring to the second master that associates the first accounting data belonging to the subject corresponding to the information and the subject corresponding to the subject information A character string corresponding to the first accounting data is arranged in the predetermined cell and the cell at the relative position.

  Moreover, the accounting data creation program according to the present invention uses a data group of first accounting data of a plurality of subjects to be executed in an accounting data creation apparatus provided with a control unit, and a plurality of cells are arranged in a row direction and a column. An accounting data creation program for creating second accounting data of a predetermined table type to be arranged on a spreadsheet arranged in a direction, the predetermined data in the spreadsheet being executed by the control unit Cell master information relating to cell rows and columns, subject information relating to subjects of first accounting data selected from the data group, and a first master associating table type information relating to the types of the table types, Table type information, relative position from the predetermined cell, the number of cells in at least one of the row direction and the column direction According to the selected table type by referring to the relative position information for prescribing and the second master that associates the group of first accounting data belonging to the subject corresponding to the subject information with each other The method includes an arrangement step of arranging character strings corresponding to a group of first accounting data belonging to a fixed subject in the predetermined cell and the cell at the relative position.

  According to the present invention, there is an effect that it is possible to create accounting data having a uniform layout without taking much time and effort.

FIG. 1 is a block diagram showing an example of the configuration of an accounting data creation system including an accounting data creation device according to the first embodiment of the present invention. FIG. 2 is a flowchart showing a processing procedure according to the accounting data creation method executed in accounting data creation apparatus 100 in FIG. FIG. 3 is a diagram used for explaining information that can be acquired from the output format setting master 106a in step S203 of FIG. 2 when the table type is determined. FIG. 3A is acquired. An example of subject information and cell identification information is shown, and FIG. 3B shows an output example according to the information acquired from FIG. FIG. 4 is a diagram used to explain information that can be acquired from the in-sheet setting master 106b in step S203 of FIG. 2 when the table type is determined. FIG. 4A is acquired. An example of the relative position information is shown, and FIG. 4B shows an output example according to the information acquired from FIG. FIG. 5 is a diagram used for explaining the accounting data arranged in step S207 of FIG. 2 when a spreadsheet is specified in step S205 of FIG. 2, and FIG. FIG. 5B, FIG. 5C, and FIG. 5D are acquired from FIG. 5A, showing an example of the sheet specifying information acquired from the spreadsheet software setting master 106c in step S205. An output example according to the information is shown. FIG. 6 is a diagram illustrating another example of FIG. 5, and FIGS. 6A, 6 </ b> B, 6 </ b> C, and 6 </ b> D are illustrated in FIGS. 5A and 5B, respectively. An example different from the examples shown in FIG. 5B, FIG. 5C, and FIG. FIG. 7 is a flowchart showing a processing procedure according to a subroutine of the master editing process in step S210 of FIG. FIG. 8 is a diagram showing an example of an output format setting master maintenance screen displayed in step S213 of FIG. FIG. 9 is a diagram for explaining items that can be registered via the output format setting master maintenance screen as shown in FIG. 8. FIG. 9A shows a header part, and FIG. 9B shows a detail part. Indicates. FIG. 10 is a diagram showing an example of the in-sheet setting master maintenance screen displayed in step S214 of FIG. FIG. 11 is a diagram for explaining items that can be registered through the in-sheet setting master maintenance screen as shown in FIG. 10. FIG. 11A shows a header part, and FIG. 11B shows a detail part. Indicates. 12A and 12B are diagrams used to explain different layouts. FIG. 12A shows a first example of the layout, FIG. 12B shows a second example of the layout, and FIG. c) shows the third example. FIG. 13 is a diagram showing an example of a spreadsheet software setting master maintenance screen displayed in step S215 of FIG. FIG. 14 is a diagram for explaining items that can be registered via the spreadsheet software setting master maintenance screen as shown in FIG. 13. FIG. 14 (a) shows the header part, and FIG. 14 (b) shows the details. Indicates the part. FIG. 15 is a diagram showing an example of a layout list screen when a plurality of layouts are registered as a result of setting for various masters in steps S213 to S215 of FIG. FIG. 16 is a diagram showing an example of a spreadsheet template used in the processing of FIG. 7, FIG. 16 (a) shows the template selected in step S212, and FIG. 16 (b) shows FIG. The case where the layout of accounting data A, B, C, etc. is set with respect to the template of a) is typically shown. FIG. 17 is a diagram showing a setting example of the master set for the template shown in FIG. 16B. FIG. 17A shows a setting example of the output format setting master 106a, and FIG. b) shows a setting example of the in-sheet setting master 106b. FIG. 18 is a diagram showing a setting example of the spreadsheet software setting master 106c set for the template shown in FIG. FIG. 19 is a diagram illustrating an example in which the accounting data is arranged with respect to the template of FIG.

  A mode for carrying out the present invention will be described in detail with reference to the drawings. In addition, this invention is not limited by this embodiment.

[1. First Embodiment]
Hereinafter, a first embodiment of the present invention will be described.

[1-1. Constitution]
FIG. 1 is a block diagram showing an example of a configuration of an accounting data creation system including an accounting data creation device according to the present embodiment.

  An accounting data creation system 1000 shown in FIG. 1 includes an accounting data creation device 100 as an information processing device, a server 200, and a network 300 that connects the accounting data creation device 100 and the server 200 so that they can communicate with each other. .

  The accounting data creation device 100 is a commercially available desktop personal computer, and uses spreadsheet software (for example, Excel (registered trademark) of Microsoft Corporation) from the first accounting data group (for example, existing accounting data) of a plurality of subjects. )) On the sheet (spreadsheet in which cells are arranged in the row direction and the column direction). The information processing apparatus is for creating second accounting data (for example, accounting material data) of a predetermined table type. The accounting data creation apparatus 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, but is a portable type such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer. It may be a type information processing apparatus.

  The accounting data creation apparatus 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the accounting data creation device 100 is connected to be communicable via an arbitrary communication path.

  The communication interface unit 104 communicatively connects the accounting data creation device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the accounting data creation device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Therefore, the communication interface unit 104 is configured to be able to accept input information from an information processing apparatus not shown in FIG. 1 via the network 300 or the network 300 and the server 200. At the same time, it is configured to be able to output predetermined information to a predetermined information processing apparatus.

  The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program (including the program of the present invention) for giving various instructions to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) and a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk can be used. The storage unit 106 stores various masters (database or table) used for executing the information management program of the present invention so as to be able to be written / read out. Various masters will be described later.

  An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker (including a home television), a speaker, and a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that realizes a pointing device function in cooperation with the mouse can be used.

  The control unit 102 is a CPU or the like that comprehensively controls the accounting data creation apparatus 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, and necessary data, and performs various information processing based on these stored programs. Run.

  Further, the configuration of the storage unit 106 and the configuration of the control unit 102 will be described in detail with reference to FIG.

  As shown in FIG. 1, the storage unit 106 includes an output format setting master 106a (first master), an in-sheet setting master 106b (second master), and a spreadsheet software setting master 106c (third master). Master).

  In general, the output format setting master 106a is a master for setting a cell that is a starting point (reference) when one or more pieces of accounting data are arranged on a spreadsheet. In this output format setting master 106a, cell specification information for specifying a predetermined cell on the spreadsheet and item information of the first accounting data are associated with each other for each type of table type of accounting data to be created. Table is stored. Here, the cell specifying information refers to information related to the row and column of a predetermined cell in the spreadsheet. In the present embodiment, the cell that is the starting point when the accounting data of a specific table type is arranged on the spreadsheet. Corresponds to information for identification. The item information of the first accounting data is selected from the group of existing first accounting data when the accounting data of a specific table type is arranged on the spreadsheet in the output formatting master 106a. Corresponds to information for specifying the subject of accounting data to be used.

  The in-sheet setting master 106b is generally a master for setting a layout (without defining a starting point cell) when two or more accounting data are arranged on a spreadsheet. . In the in-sheet setting master 106b, relative position information for defining a relative position based on a predetermined cell corresponding to the cell specifying information of the output format setting master 106a for each type of table type of accounting data to be created. And a table in which a group of first accounting data belonging to a course corresponding to the course information of the output format setting master 106a is associated with each other. In the present embodiment, the relative position information is information (layout information) for defining a relative position from a predetermined cell as a reference by the number of cells in at least one of the row direction and the column direction of the spreadsheet. ) Is used.

  The spreadsheet software setting master 106c is generally a master for designating a specific spreadsheet of spreadsheet software (one spreadsheet in an electronic file including a plurality of spreadsheets). The spreadsheet software setting master 106c stores a table in which the layout information of the in-sheet setting master 106b and sheet specifying information for specifying one spreadsheet are associated with each other. In the present embodiment, the table stored in the spreadsheet software setting master 106c includes a sheet name (sheet name information) to be set in a spreadsheet corresponding to the sheet specifying information and an electronic including the spreadsheet. A file name (file name information) to be set to the file is also associated (therefore, in this embodiment, the spreadsheet software setting master 106c is the fourth master for setting the sheet name and the second for setting the file name. 5 also functions as a master).

  As shown in FIG. 1, the control unit 102 includes a plurality of modules. Specifically, the control unit 102 includes an arrangement unit 102a, a sheet name setting unit 102b, and a file name setting unit 102c.

  The arrangement unit 102a refers to the output format setting master 106a and the in-sheet setting master 106b described above, and thereby selects a character string corresponding to a group of first accounting data belonging to a subject determined according to the selected table type. , A module for arranging in a predetermined cell and a cell at a relative position. Therefore, this module functions as an arrangement means. In the present embodiment, the arrangement unit 102a arranges character strings corresponding to a group of first accounting data in a spreadsheet specified by the sheet specifying information by referring to the spreadsheet software setting master 106c. It is also a module to do.

  The sheet name setting unit 102b is a module for setting a sheet name to a spreadsheet in which a group of first accounting data is to be arranged by referring to the spreadsheet software setting master 106c. Therefore, this module functions as sheet name setting means. The file name setting unit 102c is a module for setting a file name to a file including a spreadsheet in which a group of first accounting data is to be arranged by referring to the spreadsheet software setting master 106c. . Therefore, this module functions as a file name setting unit.

[1-2. Processing action]
Next, processing executed in the accounting data creation system 1000 shown in FIG. 1 will be described.

  FIG. 2 is a flowchart showing a processing procedure according to the accounting data creation method executed in accounting data creation apparatus 100 in FIG. Most of the processing shown in FIG. 2 is executed by the control unit 102 of the accounting data creation apparatus 100.

  First, in step S201, first, the output format setting master 106a is read to display a list of table types and wait for the user to determine the table type. At this time, information other than the table type information stored in the output format setting master 106a may be displayed. Here, the “table type” means a format or template of accounting data created by arranging accounting data on a spreadsheet. The name of the table type can be arbitrarily set by the user. If only the list of the table type is displayed, it may be read from the in-sheet setting master 106b instead of reading out the output format setting master 106a. The output format setting master 106a and the in-sheet setting master 106b A list stored separately may be read out.

  If it is determined that the table type has been determined (Yes in step S202), in step S203, by referring to the output format setting master 106a from the determined table type information, the corresponding subject Information and cell specifying information (that is, information on the position of a predetermined cell) are acquired, and relative position information is acquired by referring to the in-sheet setting master 106b.

  For example, when “1 profit” is selected as the table type, as shown in FIG. 3A, information on the item codes of ordinary profit and net profit is acquired as the item information from the output format setting master 106a. At the same time, information about the output row and the output column is acquired for each acquired subject information as the cell specifying information. Here, “output row” and “output column” mean the positions on the spreadsheet of cells for arranging character strings corresponding to the accounting data. FIG. 3B shows an example in which character strings corresponding to the accounting data are arranged based on the information acquired from the output format setting master 106a shown in FIG. Note that the “character string corresponding to the accounting data” generally refers to the numerical value of the accounting data belonging to the accounting item (or a combination of the numerical value and the unit used for the numerical value). In the example shown in (), for convenience of explanation, a subject code and a subject name are arranged (the numerical values may not be arranged in the subsequent drawings as well).

  Similarly, when “1 profit” is selected as the table type, as shown in FIG. 4A, information on the shift row and shift column is acquired as relative position information from the in-sheet setting master 106b. . Here, “shifted row” and “shifted column” define the relative position from a predetermined cell specified by the cell specifying information by the number of cells in the row direction and column direction of the spreadsheet, respectively. Means information for.

  Furthermore, from the in-sheet setting master 106b shown in FIG. 4 (a), information on the target period (for example, distinction of accounting period such as current period, previous period, and latter period), information on actual / budget distinction, Layout information is acquired. Here, the “layout information” is, for example, a layout number and a layout name arbitrarily set in the layout, or a combination thereof, and this information is also used when referring to the spreadsheet software setting master 106c. As can be seen from FIG. 4A, the in-sheet setting master 106b is configured so that a plurality of pieces of information can be acquired collectively by combining the target period and the actual / budget distinction. In FIG. 4B, based on the information acquired from the in-sheet setting master 106b shown in FIG. 4A, the subjects corresponding to the subject information acquired from the output format setting master 106a shown in FIG. An example in which a character string corresponding to the accounting data to which it belongs is shown. As can be seen from FIG. 4B, by setting a shift column, it is possible to arrange character strings corresponding to a plurality of accounting data so as to be comparable. In this way, by setting a shifted row or a shifted column, a layout in which character strings corresponding to a plurality of accounting data are to be arranged is determined. For this reason, the same layout information (“1 prediction comparison” in the example shown in FIG. 4A) is set for the layout thus determined.

  Returning to FIG. 2, in step S204, it is determined whether there is sheet specifying information by referring to the spreadsheet software setting master 106c from the layout information (layout number) acquired in step S203. Here, “sheet specification information” means one spreadsheet when there are multiple spreadsheets in a single electronic file of spreadsheet software or when multiple spreadsheets can be created. This information is used to identify If there is sheet specifying information (Yes in step S204), the sheet specifying information is acquired (step S205), and the process proceeds to step S207.

  For example, when “1 prediction comparison” is acquired as the layout information, in the example shown in FIG. 5A, information regarding three different sheet names is acquired as the sheet specifying information from the spreadsheet software setting master 106c. Is done. In the present embodiment, it is specified that different sheets should be used due to different sheet names. 5 (b), FIG. 5 (c), and FIG. 5 (d) are respectively based on the three sheet specifying information (sheet name) acquired from the spreadsheet software setting master 106c shown in FIG. 5 (a). An example in which character strings corresponding to the accounting data belonging to the course corresponding to the course information corresponding to the course information acquired from the output format setting master 106a shown in FIG. As can be seen by comparing FIG. 5B, FIG. 5C, and FIG. 5D, even if a plurality of sheets are used, only the arranged character strings are different, and the layout or template is not changed. As it is. 6 (a), FIG. 6 (b), FIG. 6 (c), and FIG. 6 (d) are respectively shown in FIG. 5 (a), FIG. 5 (b), FIG. 5 (c), and FIG. An example different from the example shown in (d) is shown.

  In step S205, when one or more sheet specifying information is acquired from the spreadsheet software setting master 106c, file name information is also acquired from the spreadsheet software setting master 106c. As can be seen from the examples shown in FIGS. 5A and 6A, when a plurality of sheets are used, a common file name is set in the spreadsheet software setting master 106c. Information can be acquired.

  On the other hand, if the result of determination in step S204 is that there is no sheet specifying information or if acquisition fails (No in step S204), a default sheet (for example, the first spreadsheet) is selected (step S206). The process proceeds to step S207.

  In the subsequent step S207, the existing group of accounting data belonging to the subject specified based on the selected table type information is read, and the corresponding character strings are set to three masters (output format setting master 106a, in-sheet setting). When the sheet name information and the file name information are acquired according to the information acquired from the master 106b and the spreadsheet software setting master 106c), and the sheet name information and the file name information are acquired, the corresponding sheet name and file name Set. As a result, second accounting data (for example, management material) is created. Then, this process is completed.

  On the other hand, if the table type is not determined in step S202, a master editing process described later is performed (step S210), and then the process of step S202 (or the process of step S201) is performed in order to prompt the determination of the table type. If the table type is determined, the process of steps S203 to S207 described above is performed to complete this process.

  As described above in detail, according to the processing of FIG. 2, when the table type is selected (Yes in step S202), the output format setting master 106a and the in-sheet setting master are based on the information of the table type. From 106b, the subject identification information of the accounting data to be used and the specific information and relative position information of a predetermined cell for arranging the character string corresponding to the accounting data to be used are acquired (step S203). The corresponding character string is arranged on the spreadsheet (step S207). Thereby, a user (for example, a person in charge of accounting) can create accounting data (for example, accounting material) of a target layout without taking much time and effort by simply specifying a table type. Further, even if another user designates the same table type, accounting data having an equivalent layout can be created. As described above, according to the present embodiment, when accounting data is created, know-how and work by the user do not enter, so that a uniform layout can be realized.

  Further, according to the processing of FIG. 2, when the sheet specifying information is acquired with reference to the spreadsheet software setting master 106c (step S205), the accounting data is arranged in the corresponding spreadsheet according to the information (step S205). Step S207). This saves the user from having to select a spreadsheet, and also avoids tasks such as selecting spreadsheets and copying accounting data to other spreadsheets. It is also possible to prevent layout disturbance that may occur.

  Further, according to the processing of FIG. 2, since the sheet name information and file name information are acquired from the spreadsheet software setting master 106c and the corresponding sheet name and file name are set, the user can specify the sheet name and file name. It is possible to save the trouble of changing.

  Next, a method for setting various masters used in the processing of FIG. 2 will be described. Since the process related to the setting can be executed at an arbitrary timing and is apparent from the description of the process related to the master edit process in step S210 of FIG. 2, the master edit process will be described below.

  FIG. 7 is a flowchart showing a processing procedure according to a subroutine of the master editing process in step S210 of FIG. Most of this processing is also executed by the control unit 102 of the accounting data creation apparatus 100.

  In FIG. 7, first, in step S211, the process waits for an input to edit the master (new creation, modification, deletion). If there is no input to edit the master (No in step S211). Returning to step S202 of FIG. 2, the display state of the table type list is maintained. If an input to the effect of master editing has been made (Yes in step S211), it waits for selection of a spreadsheet template (step S211). A template refers to a spreadsheet in an electronic file of spreadsheet software used by the user, may be a blank spreadsheet, or a spread in which a calculation formula that can be processed by spreadsheet software is embedded in a predetermined cell. It may be a sheet. Calculation formulas that can be processed by spreadsheet software are not limited to the four arithmetic operations, but also include formulas for tabulation and graphing. Instead of waiting for template selection, a default spreadsheet may be presented.

  Then, various masters (output format setting master 106a, in-sheet setting master 106b, spreadsheet software setting master 106c) are set using the selected spreadsheet template (steps S213, S214, and S215). Note that the master setting order is arbitrary, and editing (maintenance) such as new creation or change of existing settings is performed for various masters.

  The setting of the output format setting master 106a (step S213) is performed using an output format setting master maintenance screen as shown in FIG. Via this maintenance screen, the table type information and the subject information of the accounting data to be used are registered, and the output row and output column of a predetermined cell are registered as the cell specifying information. Other optional setting items may also be registered. 9A and 9B show items that can be registered via the output format setting master maintenance screen as shown in FIG.

  The in-sheet setting master 106b is set (step S214) using an in-sheet setting master maintenance screen as shown in FIG. Via this maintenance screen, the table type information and the accounting data to be used are registered, and the shift row and the shift column are registered as the relative position information. Other optional setting items may also be registered. FIG. 11A and FIG. 11B show items that can be registered via the in-sheet setting master maintenance screen as shown in FIG.

  Here, when setting the output format setting master 106a and the in-sheet setting master 106b, by specifying the same table type as the table type information, settings common to both masters can be performed. And the starting point for arranging the layout is determined. The layout determined in this way can be registered in various masters as layout information (layout number). FIG. 12A, FIG. 12B, and FIG. 12C show examples of different layouts.

  The spreadsheet software setting master 106c is set (step S215) using a spreadsheet software setting master maintenance screen as shown in FIG. Via the maintenance screen, the above-described layout information is registered, and the spreadsheet to which the accounting data is to be arranged is designated as the sheet specifying information. When specifying a plurality of spreadsheets, it is necessary to specify an electronic file as a template. By registering the same layout information as the layout information registered in the in-sheet setting master 106b as the layout information, the layout of the in-sheet setting master 106b can be applied to a plurality of spreadsheets. Also, other optional setting items may be registered. 14A and 14B show items that can be registered via the spreadsheet software setting master maintenance screen as shown in FIG.

  FIG. 15 shows an example of a layout list screen when a plurality of layouts are registered as a result of setting for various masters in steps S213 to S215. As shown in FIG. 15, it is preferable that the unit of numerical values (yen, thousand, ten thousand) corresponding to the accounting data can be set, and this setting is also in the spreadsheet software setting master maintenance screen as shown in FIG. This can be done using the output unit item.

  Subsequently, in step S216, a sheet name is assigned to the layout-set spreadsheet (template spreadsheet) specified by the table type information, layout information, and sheet specifying information set and registered in steps S213 to S215. Set. In step S217, a file name or a part of the file name (for example, a prefix) is set for the electronic file including the spreadsheet for which the sheet name is set in step S216. In the present embodiment, the sheet name setting at step S216 and the file name setting at step S217 can be performed via a spreadsheet software setting master maintenance screen as shown in FIG. Note that the processing of step S216 and step S217 need not be performed.

  When setting registration is completed as described above, new registration or update of the master is performed in response to pressing of the registration button on the maintenance screen of various masters (step S218), and this processing is completed. Subsequently, when creating accounting data, the processing returns to the processing of FIG.

  As described above in detail, according to the processing of FIG. 7, by editing various masters (steps S213 to S215), in particular, the shift row and the shift column are designated by the number of cells as the relative position information. By simply going on (see FIG. 10), it is possible to set and register a layout for arranging character strings corresponding to the accounting data. Therefore, since there is no need to select and set each cell of the spreadsheet software, the user's effort can be greatly reduced. Since the registered master can be handled by other information processing apparatuses, it is possible to create accounting data with a sense of unity.

  Next, a specific example of the master editing process in FIG. 7 will be described. FIG. 16A is an example of a spreadsheet template selected in step S212. In this way, cells that do not place accounting data may be pre-inputted with necessary character strings, may be provided with necessary ruled lines, may be embedded with the above-described calculation formula, Furthermore, the font may be set. FIG. 16B is a diagram schematically showing a case where the layout of accounting data A, B, and C is set for the template of FIG. The cells in the hatched area in FIG. 16B correspond to cells that can be input and set by the master editing process described with reference to FIG.

  Examples of master settings set for the template shown in FIG. 16B are shown in FIGS. 17A, 17B, and 18. FIG. Specifically, FIG. 17A shows a setting example of the output format setting master 106a, FIG. 17B shows a setting example of the in-sheet setting master 106b, and FIG. 18 shows a spreadsheet software setting master. A setting example of 106c is shown. FIG. 19 shows an example in which the accounting data is arranged on the template of FIG. 16B according to one layout information of the plurality of layout information shown in FIG. As can be seen from FIG. 19, the character strings corresponding to the registered accounting data are stored in each cell of the template as shown in FIG. 17 (b). Management analysis can be performed.

[1-3. Modification of First Embodiment]
In the first embodiment described above, table type information is used as an item common to the output format setting master 106a (first master) and the in-sheet setting master 106b (second master), but other information is used. May be. Instead of this, the first master and the second master may be integrated into one master. In this case, the cell of the starting point and the layout are determined by determining the table type. In the first embodiment described above, the spreadsheet software setting master 106c (third master) also functions as a fourth master for setting sheet names and a fifth master for setting file names. Although the case has been described, one or both of the fourth master and the fifth master may be a master independent of the third master.

[2. Second Embodiment]
Next, a second embodiment of the present invention will be described. In the first embodiment described above, the relative position information (shift row and shift position) is set using the in-sheet setting master 106b. However, in this embodiment, instead of the relative position information, a predetermined cell (starting point) is set. By setting at least one direction in the row direction and the column direction from the cell) and the position of the cell at the end point, information on the region is set. Such an embodiment can also define a layout.

[3. Other Embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

  For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be performed manually, or all of the processes described as being performed manually are all performed. Alternatively, a part can be automatically performed by a known method.

  In addition, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in the present specification and drawings, unless otherwise specified. Can be changed arbitrarily.

  In addition, regarding the accounting data creation apparatus 100 and the accounting data creation system 1000, each illustrated component is functionally conceptual and does not necessarily need to be physically configured as illustrated.

  For example, the processing functions provided in the accounting data creation apparatus 100 and the accounting data creation system 1000, particularly the processing functions performed by the control unit 102, are interpreted and executed by the CPU and the CPU in whole or in part. It may be realized by a program or hardware based on wired logic. The program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment, and creates accounting data as necessary. It is mechanically read by the device 100. In other words, in a storage unit such as a ROM or a HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

  The computer program may be stored in an application program server (for example, the server 200 connected via the network 300) connected to the accounting data creation apparatus 100 via an arbitrary network. It is also possible to download all or part of it.

  In addition, a program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the “recording medium” refers to a memory card, USB (Universal Serial Bus) memory, SD (Secure Digital) card, flexible disk, magneto-optical disk, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (registration). Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Digital, Trademark) Any “portable physical media It is intended to include. Therefore, a recording medium storing a program for executing processing as described in this specification also constitutes the present invention.

  The “program” is a data processing method described in an arbitrary language or description method, and may be in any form such as source code or binary code. Note that the “program” is not necessarily limited to a single configuration, and functions are achieved in cooperation with a separate configuration such as a plurality of modules and libraries or a separate program represented by the OS. Including things. In addition, a well-known structure and procedure can be used about the specific structure and reading procedure for reading a recording medium in each apparatus shown to embodiment, the installation procedure after reading, etc.

  Various databases and the like stored in the storage unit 106 are storage means such as a memory device such as a RAM and a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk. Programs, tables, databases, web page files, and the like.

  Moreover, the accounting data creation apparatus 100 may be configured as an information processing apparatus such as a known personal computer or workstation, or may be configured as the information processing apparatus connected to an arbitrary peripheral device. The accounting data creation apparatus 100 may be realized by installing software (including a program or data) that realizes the processing described in the present embodiment in the apparatus.

  Furthermore, the specific form of distribution / integration of the devices is not limited to that shown in the figure, and all or a part of them may be functionally or physically in arbitrary units according to various additions or according to functional loads. It can be configured to be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and may be selectively implemented.

  The present invention is particularly useful when creating accounting materials using existing accounting data.

DESCRIPTION OF SYMBOLS 100 Accounting data creation apparatus 102 Control part 102a Arrangement part 102b Sheet name setting part 102c File name setting part 104 Communication interface part 106 Storage part 106a Output format setting master 106b In-sheet setting master 106c Spreadsheet software setting master 108 Input / output interface part 112 Input device 114 Output device 200 Server 300 Network 1000 Accounting data creation system

Claims (6)

For creating second accounting data of a predetermined table type for arranging on a spreadsheet in which a plurality of cells are arranged in a row direction and a column direction using a data group of first accounting data of a plurality of subjects An accounting data creation device having a control unit,
The controller is
Cell specification information relating to rows and columns of predetermined cells in the spreadsheet, item information relating to subjects of the first accounting data selected from the data group, and table type information relating to the type of the table type are associated with each other. 1 master,
The table type information, the relative position information for defining the relative position from the predetermined cell by the number of cells in at least one of the row direction and the column direction, and the subject corresponding to the subject information By referring to a second master that associates a group of first accounting data to which it belongs,
An arrangement means for arranging a character string corresponding to a group of first accounting data belonging to a subject determined according to the selected table type in the predetermined cell and the cell at the relative position is provided. Accounting data creation device. The spreadsheet is a spreadsheet in an electronic file containing a plurality of spreadsheets; and
The arrangement means further includes:
Layout information relating to the relative position corresponding to the first accounting data of the group in the second master, and sheet specifying information for specifying the one spreadsheet among the plurality of spreadsheets. The character string corresponding to the first accounting data of the group is arranged in a spreadsheet specified by the sheet specifying information by referring to a third master associated with each other. The accounting data creation device described. The controller is
Refer to the fourth master that associates the first accounting data of the group, the sheet specifying information, and the sheet name information related to the sheet name to be set in the spreadsheet specified by the sheet specifying information. 3. The accounting data creating apparatus according to claim 2, further comprising sheet name setting means for setting a sheet name to a spreadsheet in which the first group of first accounting data is to be arranged. The controller is
A fifth master that associates the group of first accounting data, the sheet specifying information, and file name information relating to a file name to be set in a file that includes the spreadsheet specified by the sheet specifying information. 4. The file name setting means for setting a file name to a file including a spreadsheet in which the first accounting data of the group is to be arranged is referred to by referring to FIG. Accounting data creation device. A predetermined data array arranged on a spreadsheet in which a plurality of cells are arranged in a row direction and a column direction, using a data group of first accounting data of a plurality of subjects, which is executed in an accounting data creation apparatus including a control unit An accounting data creation method for creating the second accounting data of the table type of
Executed in the control unit,
Cell specification information relating to rows and columns of predetermined cells in the spreadsheet, item information relating to subjects of the first accounting data selected from the data group, and table type information relating to the type of the table type are associated with each other. 1 master,
The table type information, the relative position information for defining the relative position from the predetermined cell by the number of cells in at least one of the row direction and the column direction, and the subject corresponding to the subject information By referring to a second master that associates a group of first accounting data to which it belongs,
Including a placement step of placing a character string corresponding to a group of first accounting data belonging to a subject determined according to the selected table type in the predetermined cell and the cell at the relative position. Accounting data creation method. Using a data group of first accounting data of a plurality of subjects to be executed in an accounting data creation device provided with a control unit, for arranging a plurality of cells on a spreadsheet arranged in a row direction and a column direction An accounting data creation program for creating second accounting data of a predetermined table type,
For executing in the control unit,
Cell specification information relating to rows and columns of predetermined cells in the spreadsheet, item information relating to subjects of the first accounting data selected from the data group, and table type information relating to the type of the table type are associated with each other. 1 master,
The table type information, the relative position information for defining the relative position from the predetermined cell by the number of cells in at least one of the row direction and the column direction, and the subject corresponding to the subject information By referring to a second master that associates a group of first accounting data to which it belongs,
Including a placement step of placing a character string corresponding to a group of first accounting data belonging to a subject determined according to the selected table type in the predetermined cell and the cell at the relative position. Accounting data creation program.