Journal entry mapping import device, journal entry mapping import method, and journal entry mapping import program

Abstract

To provide a journal entry mapping import device, a journal entry mapping import method, and a journal entry mapping import program that can, in journal entry accounting work, when information to be a base of input is prepared on hand in the form of a spreadsheet file, create journal entry data by flexibly importing the information into a system and mapping the spreadsheet file with journal entry items.SOLUTION: A device: displays a detail import mapping screen in which rows to be excluded and columns to be entered from among rows and columns set in spreadsheet accounting data are selectable, and journal entry item identifiers for journal entry items set in the columns to be entered are settable; when the rows to be excluded and the columns to be entered are selected and the journal entry item identifiers are set, acquires mapping detail data with the journal entry item identifiers based on target data that does not correspond to the rows to be excluded in the spreadsheet accounting data and that corresponds to the columns to be entered; and creates journal entry data.SELECTED DRAWING: Figure 3

Description

[Technical field]

[0001] The present invention relates to a journal entry mapping import device, a journal entry mapping import method, and a journal entry mapping import program. [Background technology]

[0002] Patent Document 1 discloses a configuration for importing a spreadsheet file created using spreadsheet software, and obtaining accounting data that has had account code automatically assigned and accounting summary conversion processing performed, taking into account user selection of columns / rows from the imported data that can be used as accounting data. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2008-102829 A Summary of the Invention [Problem to be solved by the invention]

[0004] However, the invention described in the above Patent Document 1 has a problem in that it is not possible to complete the creation of journal data from a spreadsheet file created using the imported spreadsheet software.

[0005] The present invention has been made in consideration of the above problems, and has an object to provide a journal entry mapping import device, a journal entry mapping import method, and a journal entry mapping import program that, when the information on which input is based is prepared in a spreadsheet file at hand, can flexibly import the spreadsheet file into the system and map the journal entry items to create journal entry data in the journal entry accounting process. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the journal entry mapping import device of the present invention is a journal entry mapping import device having a memory unit and a control unit, wherein the memory unit comprises an accounting memory means for storing spreadsheet accounting data created using spreadsheet software, and the control unit comprises a detail import mapping display means for displaying a detail import mapping screen in which it is possible to select rows to be excluded and columns to be input from among the rows and columns set in the spreadsheet accounting data, and to set a journal entry item identifier for the journal entry item set in the input target column, a mapping detail acquisition means for acquiring mapping detail data in which the journal entry items and the journal entry item identifiers are set based on target data that does not correspond to the excluded rows of the spreadsheet accounting data and that corresponds to the input target column when the rows to be excluded and the input target columns are selected and the journal entry item identifiers are set on the detail import mapping screen, and a journal entry creation means for creating journal data based on the mapping detail data.

[0007] In addition, in the journal entry mapping import device of the present invention, the mapping detail data is further set in association with an invoicing category indicating whether or not invoicing has been performed, and the journal entry creation means displays a journal entry detail import screen in which the mapping detail data of the invoicing target can be selected, and when the mapping detail data of the invoicing target is selected on the journal entry detail import screen, creates the journal entry data for the mapping detail data of the invoicing target, and updates and sets the invoicing category set in the mapping detail data of the invoicing target to a category indicating that invoicing has been performed.

[0008] In addition, in the journal entry mapping import device of the present invention, the journal entry creation means displays the journal entry detail import screen in which the mapping detail data of the invoicing target can be selected, and when the mapping detail data of the invoicing target is selected on the journal entry detail import screen, displays a journal entry input screen in which the mapping detail data of the invoicing target can be supplemented, and when a supplementary item is set on the journal entry input screen, creates the journal entry data for the mapping detail data of the invoicing target that reflects the supplementary item, and updates and sets the invoicing classification set in the mapping detail data of the invoicing target to a mode indicating that invoicing has been completed.

[0009] In addition, in the journal entry mapping import device of the present invention, the mapping detail acquisition means further identifies an original column identifier which is an identifier indicating the journal entry item set in the input target column, and registers mapping dictionary data set by linking the original column identifier and the journal entry item identifier in the accounting storage means.

[0010] In addition, in the journal mapping import device of the present invention, the mapping detail acquisition means identifies the value set in the cell immediately above the journal item set in the cell of the row to be excluded and the column to be input as the original column identifier, and registers the mapping dictionary data set in association with the original column identifier and the journal item identifier in the accounting storage means.

[0011] In addition, in the journal mapping import device of the present invention, the mapping detail acquisition means is further characterized in that it identifies the input target column set in the spreadsheet accounting data based on the mapping dictionary data, identifies the excluded row from a cell in which the journal item at the bottom of the original column identifier set in the input target column is set, and acquires the mapping detail data in which the journal item and the journal item identifier are set based on the target data that does not correspond to the excluded row and corresponds to the input target column.

[0012] In addition, in the journal mapping import device of the present invention, the mapping dictionary data is further set in association with a layout identifier, and the mapping detail acquisition means is further characterized in that, when the layout identifier is set on the detail import mapping screen, it identifies the input target column set in the spreadsheet accounting data based on the mapping dictionary data in which the layout identifier is set, identifies the excluded target row from the cell in which the journal item at the bottom of the original column identifier set in the input target column is set, and acquires the mapping detail data in which the journal item and the journal item identifier are set based on the target data that does not correspond to the excluded row and corresponds to the input target column.

[0013] In addition, in the journal mapping import device of the present invention, the mapping detail acquisition means further registers in the accounting storage means import file data setting the total number and the number of unissued items of the mapping detail data for each of the spreadsheet accounting data, mapping header data setting whether or not the journal entry items are set in the mapping detail data, and mapping detail auxiliary data for managing the complementation process as a log, in which a processing type indicating the processing result of the complementation process is set.

[0014] In addition, in the journal entry mapping import device of the present invention, the journal entry creation means further displays the journal entry detail import screen in which the mapping detail data that is to be disabled can be selected, and when the mapping detail data that is to be disabled is selected on the journal entry detail import screen, controls the journal entry detail import screen to exclude the mapping detail data from the selection display of the invoicing target.

[0015] In addition, in the journal entry mapping import device of the present invention, the memory unit further includes a code master in which the code of the journal entry item is set, and the journal entry creation means creates the journal entry data in which the journal entry item, the code and the amount are linked and set based on the mapping detail data and the code master.

[0016] In addition, the journal mapping import method of the present invention is a journal mapping import method to be executed by a journal mapping import device having a memory unit and a control unit, the memory unit having an accounting storage means for storing spreadsheet accounting data created using spreadsheet software, and is characterized in that it includes a detail import mapping display step executed by the control unit, which displays a detail import mapping screen in which it is possible to select rows to be excluded and columns to be input from among the rows and columns set in the spreadsheet accounting data, and in which it is possible to set a journal item identifier for the journal item set in the input target column, a mapping detail acquisition step, when the rows to be excluded and the input target column are selected on the detail import mapping screen, and the journal item identifier is set, which does not correspond to the rows to be excluded in the spreadsheet accounting data and corresponds to the input target column, acquires mapping detail data in which the journal items and the journal item identifiers are set, and a journal entry creation step, which creates journal data based on the mapping detail data.

[0017] In addition, the journal mapping import program of the present invention is a journal mapping import program to be executed by a journal mapping import device having a memory unit and a control unit, the memory unit having an accounting memory means for storing spreadsheet accounting data created using spreadsheet software, and the control unit is characterized in that it executes a detail import mapping display step of displaying a detail import mapping screen in which it is possible to select rows to be excluded and columns to be input from among the rows and columns set in the spreadsheet accounting data, and to set a journal item identifier for the journal item set in the input target column, a mapping detail acquisition step of acquiring mapping detail data in which the journal items and the journal item identifiers are set based on target data that does not correspond to the excluded rows of the spreadsheet accounting data and corresponds to the input target column when the selection of the rows to be excluded and the input target column and the setting of the journal item identifier are made on the detail import mapping screen, and a journal entry creation step of creating journal data based on the mapping detail data. Effect of the Invention

[0018] According to the present invention, it is possible to suppress human error by importing journal vouchers that have been registered by the user through visual judgment and manual input each time into Excel (registered trademark) at hand. In addition, according to the present invention, it is possible to significantly reduce the input work by storing mapping data and automatically using the settings for the next and subsequent imports. In addition, according to the present invention, it is possible to provide a more flexible means for issuing transfer journal entries than before, in response to the issues of labor shortage and labor saving in the accounting department. In addition, in the daily journal voucher registration work, it was necessary to input all required items according to a fixed format based on existing Excel (registered trademark) data, but according to the present invention, since it can be imported while automatically completing, it is possible to use Excel (registered trademark) data as it is, and as a result, it is possible to improve work efficiency, reduce input load, and quickly record and grasp numerical values ​​in many companies. In addition, according to the present invention, it is possible to systematize a series of operations including mapping settings, shaping into an acceptance format based on the setting data, and development into journal entry input. [Brief description of the drawings]

[0019] [Figure 1] FIG. 1 is a diagram showing an example of the journal mapping import process in this embodiment. [Diagram 2] FIG. 2 is a diagram showing an example of the journal mapping import process in this embodiment. [Diagram 3] FIG. 3 is a block diagram showing an example of the configuration of the journal entry mapping import device in this embodiment. [Figure 4] FIG. 4 is a flowchart showing an example of the processing of the journal entry mapping import device in this embodiment. [Diagram 5] FIG. 5 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 6] FIG. 6 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 7]FIG. 7 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 8] FIG. 8 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 9] FIG. 9 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 10] FIG. 10 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 11] FIG. 11 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 12] FIG. 12 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 13] FIG. 13 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 14] FIG. 14 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 15] FIG. 15 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 16] FIG. 16 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 17] FIG. 17 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 18] FIG. 18 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 19] FIG. 19 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 20] FIG. 20 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 21] FIG. 21 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 22] FIG. 22 is a diagram showing an example of the journal mapping import process in this embodiment. [Diagram 23]FIG. 23 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 24] FIG. 24 is a diagram showing an example of the journal mapping import process in this embodiment. [Diagram 25] FIG. 25 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 26] FIG. 26 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 27] FIG. 27 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 28] FIG. 28 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 29] FIG. 29 is a diagram showing an example of the journal mapping import process in this embodiment. [Diagram 30] FIG. 30 is a diagram showing an example of the journal mapping import process in this embodiment. [Diagram 31] FIG. 31 is a diagram showing an example of the journal mapping import process in this embodiment. [Diagram 32] FIG. 32 is a diagram showing an example of the journal mapping import process in this embodiment. [Diagram 33] FIG. 33 is a diagram showing an example of the journal mapping import process in this embodiment. [Diagram 34] FIG. 34 is a diagram showing an example of the journal mapping import process in this embodiment. [Diagram 35] FIG. 35 is a diagram showing an example of the journal mapping import process in this embodiment. [Diagram 36] FIG. 36 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 37] FIG. 37 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 38] FIG. 38 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 39]FIG. 39 is a diagram showing an example of the journal mapping import process in this embodiment. [Diagram 40] FIG. 40 is a diagram showing an example of the journal mapping import process in this embodiment. [Diagram 41] FIG. 41 is a diagram showing an example of the journal mapping import process in this embodiment. [Diagram 42] FIG. 42 is a diagram showing an example of the journal mapping import process in this embodiment. [Diagram 43] FIG. 43 is a diagram showing an example of the journal mapping import process in this embodiment. [Diagram 44] FIG. 44 is a diagram showing an example of the journal mapping import process in this embodiment. [Diagram 45] FIG. 45 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 46] FIG. 46 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 47] FIG. 47 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 48] FIG. 48 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 49] FIG. 49 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 50] FIG. 50 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 51] FIG. 51 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 52] FIG. 52 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 53] FIG. 53 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 54] FIG. 54 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 55]FIG. 55 is a diagram showing an example of the journal mapping import process in this embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0020] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to the embodiment.

[0021] [1. Overview] First, an overview of the present invention will be described with reference to Figures 1 and 2. Figures 1 and 2 are diagrams showing an example of a journal entry mapping import process in this embodiment.

[0022] In daily accounting operations, the information on which data is input can often be prepared using spreadsheet software such as Excel (registered trademark), and data is often entered manually without importing it from a spreadsheet. However, most general accounting systems do not have a seamless spreadsheet data import function that allows for linkage with external systems.

[0023] Previously, (A) functions that assumed the linking of spreadsheet data with external systems required many system standard items for import, and it was extremely rare for all items to be in the documents at hand, so how to supplement values ​​that were not in the documents was an issue. Also, previously, (B) manually created management documents were output from the linked system, and although the format of the documents at hand may change due to operational changes (system changes, etc.), the idea was to format the files in a set format before importing them, rather than systemizing them, which was time-consuming, and as a result, the import function of the system could not be utilized, input was time-consuming, and even though there were base numbers, detailed confirmation was required due to human intervention.

[0024] Therefore, in this embodiment, in daily journal entry work, when the data on which input is based is prepared on hand in spreadsheet software such as Excel (registered trademark), a mechanism is provided for flexibly importing the data into the system and mapping the spreadsheet software with the journal entry items.

[0025] Here, as shown in Fig. 1, in contrast to (A), in this embodiment, (1) only some of the items can be used, that is, the system can be read even if not all items are available, so that values ​​that are not in the documents can be completed using the system master. Also, as shown in Fig. 1, in contrast to (A), in this embodiment, (2) the system can be used even if the master code is not known, that is, the master code in the system can be completed by the name, etc., so that the difference in codes between systems can be absorbed and even manually created management documents can be read in as filled in as much as possible.

[0026] As shown in Fig. 2, in this embodiment, (3) no prior mapping setting is required, that is, the range to be used for input can be determined while reading the file and displaying it on the system, eliminating the trouble of matching it to a default format and enabling flexible response to format changes. As shown in Fig. 2, in this embodiment, (4) when importing is performed, the settings are automatically reflected in the next import and thereafter, and mapping data from past imports is reused, eliminating the need to reset the settings for repetitive tasks such as monthly regular tasks after importing once, as with the conventional import function, and enabling re-determination of mapping even if there is a partial change in the layout. In common mapping of EDI, etc., the order of columns and the appearance positions of items in the import file are often specified, and since the import file is a business document, there is a good chance that layout changes such as changes in the order of columns will occur. However, unlike mapping of EDI, etc., remapping is possible even if the order of columns is changed by specifying the names in the format.

[0027] [2. Configuration] An example of the configuration of the journal entry mapping import device 100 according to this embodiment will be described with reference to Fig. 3. Fig. 3 is a block diagram showing an example of the configuration of the journal entry mapping import device 100 according to this embodiment.

[0028] 3, the journalization mapping import device 100 is a commercially available desktop personal computer. The journalization mapping import device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0029] The journal entry mapping import device 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 journal entry mapping import device 100 is communicatively connected via an arbitrary communication path.

[0030] The communication interface unit 104 communicably connects the journalization mapping import 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 the communication line. Here, the network 300 has a function of connecting the journalization mapping import device 100 and the server 200 to each other so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

[0031] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a touch panel), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0032] The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs for cooperating with an operating system (OS) to give instructions to a central processing unit (CPU) to perform various processes. The storage unit 106 may be, for example, a memory device such as a random access memory (RAM) or a read only memory (ROM), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The storage unit 106 includes an accounting database 106a and a code master 106b.

[0033] The accounting database 106a stores accounting data. Here, the accounting database 106a may store spreadsheet accounting data created using spreadsheet software. The accounting database 106a may also include target data corresponding to input target columns, mapping detail data for managing data that was not excluded in the spreadsheet accounting data and also performing reverse lookup of master data from the name, journal data, mapping dictionary data that is the source data for automatically performing work when data is imported in a similar format, import file data for managing the total number of imported details and the number of details that have not been issued, a screen for selecting details to be issued is displayed, but mapping header data for managing data for hiding unused journal items from the screen, mapping detail auxiliary data for managing supplementary work such as referring to master data from the contents of spreadsheet accounting data such as Excel (registered trademark) as a log, and mapping layout data.

[0034] The code master 106b is a master in which various codes are set. Here, the code master 106b may be set with codes for journal entry items. The code master 106b also includes a business establishment master in which business establishment codes and names are set, a document category master in which document categories and names are set, a department master in which debit department codes and names, credit department codes and names, and debit / credit department codes and names are set, an account master in which debit general account code and name, credit general account code and name, debit / credit, and total account code and name are set, a sub-sub ... It may include auxiliary breakdown account master with the auxiliary breakdown account code and name, and the debit / credit auxiliary breakdown account code and name set, customer master with the debit customer partner code and name, the credit customer partner code and name, and the debit / credit customer partner code and name set, analysis code master with the debit analysis code and name, the credit analysis code and name, and the debit / credit analysis code and name set, initial display setting master with the user ID and business establishment code set, and account code with the account code, revision date, account name, tax category, and tax included category set.

[0035] The control unit 102 is a CPU or the like that performs overall control of the journal mapping import device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs. The control unit 102 conceptually includes a detail import mapping display unit 102a, a mapping detail acquisition unit 102b, and a journal creation unit 102c.

[0036] The detail import mapping display unit 102a displays a detail import mapping screen for spreadsheet accounting data. Here, the detail import mapping display unit 102a may display a detail import mapping screen that allows the selection of rows to be excluded and columns to be input from among the rows and columns set in the spreadsheet accounting data, and allows the setting of journal entry item identifiers for the journal entry items set in the input columns.

[0037] The mapping detail acquisition unit 102b acquires mapping detail data of the spreadsheet accounting data. Here, when the selection of the excluded target row and the input target column and the setting of the journal item identifier (for example, the journal item name, etc.) are made on the detail import mapping screen, the mapping detail acquisition unit 102b may acquire mapping detail data in which the journal item and the journal item identifier are set based on the target data that does not correspond to the excluded target row of the spreadsheet accounting data and corresponds to the input target column. In addition, the mapping detail data may be set in association with the invoice classification indicating the presence or absence of invoice. In addition, the mapping detail acquisition unit 102b may specify the original column identifier, which is an identifier indicating the journal item set in the input target column, and register the mapping dictionary data set in association with the original column identifier and the journal item identifier in the accounting database 106a. The mapping details acquisition unit 102b may also specify a value set in a cell immediately above a journal item set in a cell of an excluded row and an input target column as an original column identifier, and register mapping dictionary data set by linking the original column identifier and the journal item identifier in the accounting database 106a. The mapping details acquisition unit 102b may also specify an input target column set in the spreadsheet accounting data based on the mapping dictionary data, specify an excluded row from a cell in which a journal item at the bottom of the original column identifier set in the input target column is set, and acquire mapping details data in which a journal item and a journal item identifier are set based on target data that does not correspond to an excluded row and corresponds to an input target column. The mapping dictionary data may also be set by linking a layout identifier. In addition, when a layout identifier is set on the detail import mapping screen, the mapping detail acquisition unit 102b may identify the input target column set in the spreadsheet accounting data based on the mapping dictionary data in which the layout identifier is set, identify the row to be excluded from the cell in which the journal entry item at the bottom of the original column identifier set in the input target column is set, and acquire mapping detail data in which the journal entry item and the journal entry item identifier are set based on the target data that does not correspond to the row to be excluded and that corresponds to the input target column.In addition, the mapping detail acquisition unit 102b may register in the accounting database 106a import file data that sets the total number of mapping detail data items and the number of unissued items for each spreadsheet accounting data, mapping header data that sets whether or not a journal entry item is set in the mapping detail data, and mapping detail auxiliary data that manages the complementation process as a log and sets a processing type that indicates the processing result of the complementation process.

[0038] The journal entry creation unit 102c creates the journal entry data. Here, the journal entry creation unit 102c may create the journal entry data based on the mapping detail data. In addition, the journal entry creation unit 102c may display a journal entry detail import screen in which the mapping detail data of the invoicing target is selectable, and when the mapping detail data of the invoicing target is selected on the journal entry detail import screen, create journal entry data for the mapping detail data of the invoicing target, and update the invoicing classification set in the mapping detail data of the invoicing target to a mode indicating invoicing has been completed. In addition, the journal entry creation unit 102c may display a journal entry detail import screen in which the mapping detail data of the invoicing target is selectable, and when the mapping detail data of the invoicing target is selected on the journal entry detail import screen, display a journal entry input screen in which the mapping detail data of the invoicing target can be supplemented, and when a supplementary item is set on the journal entry input screen, create journal entry data for the mapping detail data of the invoicing target reflecting the supplementary item, and update the invoicing classification set in the mapping detail data of the invoicing target to a mode indicating invoicing has been completed. The journal entry preparation unit 102c may also display a journal entry detail import screen that allows selection of unusable mapping detail data, and when unusable mapping detail data is selected on the journal entry detail import screen, control is performed to exclude the mapping detail data from the selection display of the invoice target on the journal entry detail import screen. The journal entry preparation unit 102c may also create journal entry data that is set by linking journal items, codes, and amounts based on the mapping detail data and the code master 106b.

[0039] [3. Specific Examples] A specific example of this embodiment will be described with reference to FIGS.

[0040] [Journal Mapping Import Process] Here, an example of the journal entry mapping import process in this embodiment will be described with reference to Fig. 4. Fig. 4 is a flowchart showing an example of the process of the journal entry mapping import device 100 in this embodiment.

[0041] As shown in FIG. 4, when a user uploads spreadsheet accounting data via the input device 112 on the journal entry detail import screen displayed on the output device 114, the detail import mapping display unit 102a determines whether the same format as the spreadsheet accounting data is set in the mapping dictionary data stored in the accounting database 106a (step SA-1).

[0042] If the detail import mapping display unit 102a determines that the mapping dictionary data has the same format as the spreadsheet accounting data (step SA-1: Yes), it moves the process to step SA-2.

[0043] Then, the mapping details acquisition unit 102b identifies the input target columns set in the spreadsheet accounting data based on the mapping dictionary data stored in the accounting database 106a, identifies the rows to be excluded from the cells in which the journal entry items at the bottom of the original column identifiers set in the input target columns are set, and acquires mapping details data that does not correspond to the rows to be excluded and that is set by linking the journal entry items, journal entry item identifiers, and document issue classifications based on the target data that corresponds to the input target columns (step SA-2), and then transitions to step SA-6.

[0044] On the other hand, if the detail import mapping display unit 102a determines that the same format as the spreadsheet accounting data is not set in the mapping dictionary data (step SA-1: No), it moves the process to step SA-3.

[0045] Then, the detail import mapping display unit 102a displays on the output device 114 a detail import mapping screen that enables selection of rows to be excluded and columns to be input from among the rows and columns set in the spreadsheet accounting data, and enables setting of journal entry item identifiers of the journal entry items set in the input target columns (step SA-3).

[0046] Then, when the user selects the rows to be excluded and the columns to be input, and sets the journal item identifier on the detail import mapping screen via the input device 112, the mapping detail acquisition unit 102b identifies the original column identifier, which is an identifier indicating the journal item set in the input target column, and registers the mapping dictionary data set in association with the original column identifier and the journal item identifier in the accounting database 106a (step SA-4).

[0047] Then, the mapping detail acquisition unit 102b acquires mapping detail data that does not correspond to the excluded rows of the spreadsheet accounting data and that is set by linking the journal entry items, journal entry item identifiers, and document issue classifications based on the target data that corresponds to the input target columns (step SA-5).

[0048] Then, the journal entry creation unit 102c displays on the output device 114 a journal entry detail import screen on which the mapping detail data of the invoice target can be selected, and when the user selects the mapping detail data of the invoice target on the journal entry detail import screen via the input device 112, creates journal entry data for the mapping detail data of the invoice target, updates the invoice classification set in the mapping detail data of the invoice target to a mode indicating invoice has been issued (step SA-6), and terminates the processing.

[0049] Here, an example of a process for issuing a document from a new file in this embodiment will be described with reference to Fig. 5 to Fig. 33. Fig. 5 to Fig. 33 are diagrams showing an example of a journal mapping import process in this embodiment.

[0050] In this embodiment, the Excel (registered trademark) to be imported is prepared as shown in Fig. 5, and the prepared Excel (registered trademark) is read into the system by the user selecting "issue from file" on the journal entry input screen as shown in Fig. 6, and the user initially selects "issue from new file" as the initiation method on the journal entry detail import screen, and then selects a file to be uploaded using the file specification button or drag-and-drop. Here, in this embodiment, if the prepared Excel (registered trademark) has merged cells, when the text in the merged cells is displayed by the system, it is displayed in the top left cell of the merged cells.

[0051] 7, in this embodiment, the designated file is uploaded when the user presses the upload button. Here, in this embodiment, input is required only when a specific sheet is to be used, and if no input is made, the first sheet is uploaded.

[0052] In this embodiment, the uploaded Excel (registered trademark) is displayed on the system as shown in Fig. 8, and alphabets are added to each column on the system screen to make it easier to understand the correspondence between the system screen and the Excel (registered trademark) columns as shown in Fig. 9. Here, in this embodiment, as shown in Fig. 10, it is assumed that there was no merging of the merged cells, and the text in the merged cells is processed as being in the leftmost cell.

[0053] In the mapping destination determination process in this embodiment, the items used for journalization are selected column by column as shown in Fig. 11, and when the part with a bold frame marked "Not set" is clicked as shown in Fig. 12, the mapping destination selection screen is launched as shown in Fig. 13, and by clicking the occurrence date button, it is confirmed as shown in Fig. 14. Here, as shown in Fig. 13, in this embodiment, the contents that can be selected as the mapping destination are system fixed items, and may match the "~" of "~Yes" set in the mapping header data.

[0054] In this embodiment, as shown in Fig. 15, when the triangle on each button of the mapping destination selection screen is clicked, the selection target is expanded, and when one of the expanded details is selected, the journal entry item names "Occurrence Date", "Debit General Account Name", "Detail Summary", and "Debit Amount" are set from the left of the thick frame as shown in Fig. 16. Here, in this embodiment, when an item with a debit / credit prefix is ​​selected, the processing is the same as when "Debit General Account Name" / "Credit General Account Name" is selected in terms of name, and for example, when transferring from Department A to Department B, if the general account items are the same on the debit and credit sides, a debit / credit prefix option is provided to accommodate such journal entries.

[0055] Then, in this embodiment, when the items to be used for journalization have been set, it is necessary to determine the range of data to be actually used next, so if "from here to here may be title rows" or "there are rows that will not be used as data" in Excel (registered trademark), the exclusion column is selected on the detail import mapping screen so that unnecessary rows are not read. Here, as shown in FIG. 17, in this embodiment, when the row one row above the start row used as the target data for journalization is checked, the rows above the checked row are checked for exclusion, i.e., checking one location checks all the rows at the top, reducing the workload.

[0056] In this embodiment, as shown in FIG. 18, the mapping destination determined by pressing the confirm button on the screen is determined, and as shown in FIG. 19, mapping dictionary data is created. As shown in FIG. 19, in this embodiment, since different people will import Excel (registered trademark), data may be managed on a user-by-user basis, assuming that the data will not be influenced by other people, or a pattern may be prepared in which data is managed on a document name-by-document name basis, assuming that multiple users will use the same settings. Also, as shown in FIG. 19, as a method for identifying the original column name in this embodiment, "the item in the lowest row that has a value for each column among the excluded rows" is adopted as the original item of the column, and since a format in which the value above indicates the description and the value below indicates the title of the item is common, this method is adopted because it can be widely used. Also, in this embodiment, the file name and sheet name are used to identify which Excel (registered trademark) the data was imported from. Also, in this embodiment, the journal item code is used to automatically execute an operation to determine the mapping destination if a column matching the original column name exists in Excel (registered trademark) in the next or subsequent imports.

[0057] In this embodiment, the mapping destination determined by pressing the Confirm button on the screen is confirmed as shown in Fig. 18, and import file data is created as shown in Fig. 20. Here, as shown in Fig. 20, in the import file data in this embodiment, the key item is a file identifier, which is a unique identifier assigned to each uploaded file, and the total number of cases and the number of unissued cases are the number of all data below the excluded column.

[0058] In this embodiment, the mapping destination determined by pressing the Confirm button on the screen is confirmed as shown in Fig. 18, and mapping header data is created as shown in Fig. 21. Here, as shown in Fig. 21, in the mapping header data in this embodiment, the key item is the file identifier, "Yes" corresponds to a column where mapping has been performed and the title is not unspecified, and "Yes" becomes true for each mapping item of the column, matching the system fixed item displayed in the mapping destination selection.

[0059] In this embodiment, the mapping destination determined by pressing the Confirm button on the screen is confirmed as shown in Fig. 18, and mapping detail auxiliary data is created as shown in Fig. 22. Here, as shown in Fig. 22, in the mapping detail auxiliary data in this embodiment, the key items are the file identifier, data row number, and SEQ, and based on the cell value of the auxiliary data, a partial match with the master is referenced, and if there is one match, the master code is registered in the code value of each journal entry item column of the mapping detail data, and when reverse lookup, no distinction is made between "full-half-width, uppercase, lowercase, hiragana, katakana", and only "voiced consonants, semi-voiced consonants" are distinguished. As shown in Fig. 22, in the mapping detail auxiliary data in this embodiment, SEQ is a number that is assigned consecutively in row number units, the original column number is the column number in Excel (registered trademark) in which the cell value is stored, the original row number is the row number in Excel (registered trademark) in which the cell value is stored, the journal entry item code manages which item the original column and original row are assigned to, and the processing type is a classification value that indicates the processing result of the master reverse lookup, etc., and there are two types: normal and warning. Here, in this embodiment, when the processing type is normal, it indicates a case where one item can be identified as a result of the master reverse lookup, and when the processing type is warning, it indicates a case where 0 items or 2 or more items are obtained as a result of the master reverse lookup, and the cell value is displayed as it is on the slip entry screen, and is manually specified on the entry screen.

[0060] Here, as shown in Figure 23, in this embodiment, if there are two journal entry items in the first line that are looked up in reverse from the master (debit general account name and debit department name), the reverse lookup result of the debit general account name is numbered as SEQ:1, and the reverse lookup result of the debit department name is numbered as SEQ:2, so that in the mapping detail auxiliary data, etc., even if there are multiple master reverse lookups within one line of data, the keys do not overlap (in other words, the data line number is 1, so key items will be duplicated without SEQ).

[0061] In this embodiment, the mapping destination determined by pressing the Confirm button on the screen is confirmed as shown in Fig. 18, and mapping detail data is created as shown in Fig. 24. Here, as shown in Fig. 24, in the mapping detail data in this embodiment, the key items are the file identifier and the data row number, and for each item in the mapping header, the value of each column in the corresponding data row is set as the mapping destination item value.

[0062] Then, in this embodiment, after the mapping destination is determined as shown in Fig. 18, the loaded data can be checked in a list as shown in Fig. 25, and the mapping detail data is displayed as is as the data displayed in the list. Here, as shown in Fig. 25, the bold framed portion controls the display / hide of the screen using the mapping header data, and those items in the mapping header data that are set to True are displayed (=linked with / without mapping). Here, in this embodiment, items without mapping are controlled so as not to be displayed in the list on the screen, as they do not affect the import.

[0063] As shown in FIG. 26, in this embodiment, when the STEP 2 call data tab is switched to the read log tab on the screen shown in FIG. 25, the mapping results can be confirmed, and the mapping detail auxiliary data is displayed as is as the data to be displayed in the list.

[0064] Here, in this embodiment, if mapping fails, a screen for confirming the call data is displayed as shown in the lower figure of Figure 27, and when the cursor is placed on the triangle mark of the "Debit total account name," a pop-up message is displayed near the triangle mark that is the same value as the "Processing content" of the corresponding cell whose processing type is "1: Warning" on the log confirmation screen shown in the upper figure of Figure 27: "No master containing the specified name was found."

[0065] In this embodiment, as shown in Fig. 28, in order to meet the need to issue vouchers for each occurrence date for Excel (registered trademark) that has monthly data, the unit of issuing vouchers can be set by the user, and when the user checks the left end of the part surrounded by a thick frame on the journal entry detail import screen, a journal entry input screen (voucher registration screen) is called up as shown in Fig. 29. Here, as shown in Fig. 29, in this embodiment, the tax category and tax inclusive category registered in the subject master are adopted as the initial values ​​for the tax category and tax inclusive category, and the amount is decomposed into tax based on the initial value and displayed on the voucher registration screen.

[0066] As shown in FIG. 30, in this embodiment, the journal entry that the user wants to create is manually completed; that is, for journal entry items with mapping settings, such as debits and detail summaries, the system automatically determines and generates or automatically completes the master, and for journal entry items without mapping settings, such as credits, the user manually completes them.

[0067] In this embodiment, when the user presses the register button as shown in Fig. 31, these data are registered at the timing when registration is completed as shown in Fig. 32. Here, as shown in Fig. 32, in this embodiment, the number of unissued items set in the import file data is subtracted by the number of items checked on the journal entry detail import screen shown in Fig. 28. Also, as shown in Fig. 32, in this embodiment, for details checked on the journal entry detail import screen shown in Fig. 28, the voucher classification set in the mapping detail data is updated from "0: unissued" to "1: issued", and the voucher number set in the mapping detail data is updated from blank to the voucher number assigned on the voucher screen.

[0068] As shown in FIG. 33, in this embodiment, when registration is completed on the voucher registration screen (issuing screen), the screen automatically returns to the original journal entry details import screen, and the details marked as "issued" cannot be checked.

[0069] An example of a process for issuing a document from a file previously read in this embodiment will be described with reference to Fig. 34 to Fig. 43. Fig. 34 to Fig. 43 are diagrams showing an example of a journal mapping import process in this embodiment.

[0070] It is best to issue all the details in one go, but since it is possible that the user may close the screen in the middle of issuing a voucher and leave the desk, in this embodiment, a journal entry input screen is displayed on which the "issue from file" button can be selected, as shown in Fig. 34. Then, in this embodiment, when the user selects the "issue from file" button on the journal entry input screen, a journal entry detail import screen is displayed on which the "issue from a previously loaded file" can be selected as the issuing method, as shown in Fig. 34.

[0071] In this embodiment, when the user selects "Create document from previously loaded file" on the journal entry detail import screen as shown in FIG. 34, specifies the upload date and time as shown in FIG. 35, and presses the display button, the imported file data is extracted and displayed for the user's own user data and the period of the specified upload date and time as shown in FIG. 36.

[0072] Then, in this embodiment, when the details to be called up are selected as shown in FIG. 37 and the "Call" button is pressed, the mapping detail data is read based on the file identifier of the selected details as shown in FIG. 38, and the process resumes with the mapping detail data that was previously issued displayed as shown in FIG. 37.

[0073] In this embodiment, as shown in FIG. 39, since the data was uploaded last time and only a portion of the invoice has been issued, the details that have not yet been issued are displayed for selection, and when the user selects the details that they wish to invoice, the journal entry registration screen (journal entry input screen) is called up, as shown in FIG. 40.

[0074] In this embodiment, as shown in FIG. 41, the user manually completes the journal entry they wish to create on the journal entry registration screen, and as shown in FIG. 42, the voucher registration is completed, and as shown in FIG. 43, the journal entry data, import file data, and mapping detail data are updated.

[0075] An example of a process for issuing a document from a file of the same format in this embodiment will be described with reference to Fig. 9 and Fig. 44 to Fig. 47. Fig. 44 to Fig. 47 are diagrams showing an example of a journal mapping import process in this embodiment.

[0076] There is a business process that imports Excel (registered trademark) data with the same format but different data contents on a monthly basis. In this embodiment, as shown in FIG. 44, there is an Excel (registered trademark) cash book for June 2022 shown in FIG. 9 and an Excel (registered trademark) cash book for July 2022 in the same format. As shown in FIG. 45, when the user selects the Excel (registered trademark) cash book for July 2022 on the journal entry detail import screen and presses the "upload" button, as shown in FIG. 46, the detail import mapping screen is launched with all mapping operations performed the first time completed based on the mapping dictionary data at the time of upload completion. Here, as shown in FIG. 46, in this embodiment, for automatic column setting, after the Excel (registered trademark) data is displayed on the screen, if there is an Excel (registered trademark) cell value that matches the original column name of the mapping dictionary data, the journal entry item is set.

[0077] Here, as shown in FIG. 47, the method of identifying columns in this embodiment is as follows: (1) start from the top left corner of the screen, (2) check whether a value is entered in (1), (3) if no value is entered, move to the cell one cell to the right, and if there is no cell to the right, move to the left end of the next row and perform the process of (2) again, (4) if a value is entered, compare with the original column name of the mapping dictionary data to check whether there is matching data, (5) if there is no matching data with the mapping dictionary data, perform the same process as (3), and (6) if there is matching data with the mapping dictionary data, set the journal entry corresponding to the matching original column name in the column of the screen, and perform the same process as (3) (note that if the column of the screen has been set before, it is overwritten). In addition, in this embodiment, the automatic setting of the check of the excluded row is automatically checked up to the bottom end of the mapping column that has been reversely converted, so that the operation is performed so as not to burden users who have almost no mapping from the second time onwards. In addition, in this embodiment, the file name and sheet name are reference information for people to see which sheet of which file was imported, and are not used to identify the mapping. In this embodiment, the journal entry is issued after the mapping is completed in the same manner as in the invoicing process from a new file. In this embodiment, when a part of the layout is changed, only the mapping that can be determined (only those that can be reversely converted by the previous column identification method (1) to (6) are displayed) is restored, and the user can save labor by mapping only the changed points. Even if the position of the title row or column changes, it is possible to restore it if the item name is the same, and when an item name change, addition, or deletion occurs, it is possible to manually complete only the part that has occurred. In this embodiment, if the excluded row is mistakenly excluded and the data row is also excluded, it is possible to correct the mapping destination from the master maintenance of the mapping dictionary. In this embodiment, if the format has changed to the extent that it cannot be restored, or if you want to remap it, you can have the data deleted from the master maintenance of the mapping dictionary data, and the journal entry detail import screen can be started without the mapping at the time of import.

[0078] An example of an upload process in the case where a mapping dictionary in this embodiment is shared among users will be described with reference to Fig. 48 and Fig. 49. Fig. 48 and Fig. 49 are diagrams showing an example of a journal entry mapping import process in this embodiment.

[0079] As shown in Fig. 48, in this embodiment, when a layout code is specified by the user on the journal entry detail import screen, the mapping dictionary data is read in units of document names, not by user. Also, as shown in Fig. 49, in this embodiment, a layout may be registered in the layout master by the user inputting a layout code and a layout name on the detail import mapping screen. Here, as shown in Fig. 49, in this embodiment, when a layout is specified on the detail import mapping screen, the layout code and name may be locked.

[0080] An example of import processing in the case where there is an unnecessary data row in this embodiment will be described with reference to Fig. 50 to Fig. 55. Fig. 50 to Fig. 55 are diagrams showing an example of journal mapping import processing in this embodiment.

[0081] In this embodiment, in the Excel (registered trademark) file shown in Figure 50, since the 6th and 19th lines are data that only show the remaining amount, there are cases where you do not want to use them for issuing a journal entry. However, as shown in Figure 51, a detail import mapping screen is displayed that sets the list of imported data after the file is imported, and when the user selects a line to be excluded on the detail import mapping screen, as shown in Figure 52, the journal entry detail import screen is displayed, and as shown in Figure 53, the imported file data and mapping detail data are obtained.

[0082] In this embodiment, as shown in FIG. 54, when a user selects data that is not to be issued as a journal entry on the journal entry detail import screen and presses the "Change to Unusable" button, the row that has become unusable is locked and cannot be selected, and as shown in FIG. 55, the selected data is set as unusable in the mapping detail data and is no longer counted in the number of unissued items set in the import file data.

[0083] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to goals 8 and 9 of the SDGs.

[0084] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0085] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

[0086] 5. Other embodiments The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0087] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0088] In addition, the processing procedures, control procedures, specific names, registered data for each process, information including parameters such as search conditions, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

[0089] Furthermore, with regard to the journal entry mapping import device 100, the components shown in the figures are merely functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0090] For example, the processing functions of the journalization mapping import device 100, particularly the processing functions performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processing described in this embodiment, and is mechanically read by the journalization mapping import device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form a control unit.

[0091] In addition, this computer program may be stored in an application program server connected to the journalization mapping import device 100 via any network, and it is also possible to download all or part of it as needed.

[0092] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.

[0093] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a configuration that is distributed as a plurality of modules or libraries, and a program that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in this embodiment, as well as the installation procedure after reading, may use well-known configurations and procedures.

[0094] The various databases etc. stored in the memory unit 106 are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files etc. used for various processes and providing websites.

[0095] The journal mapping import device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. The journal mapping import device 100 may be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

[0096] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]

[0097] The present invention is useful in various industries in which manual entry of journal entries from data created using local spreadsheet software is frequently performed. [Explanation of symbols]

[0098] 100 Journal entry mapping import device 102 Control section 102a Detail import mapping display section 102b Mapping details acquisition section 102c Journal entry preparation department 104 Communication interface section 106 Storage section 106a Accounting Database 106b Code Master 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. A journal entry mapping import device including a storage unit and a control unit, The storage unit is accounting storage means for storing spreadsheet accounting data created using spreadsheet software; Equipped with The control unit is a detail import mapping display means for displaying a detail import mapping screen that allows selection of rows to be excluded and columns to be input from among the rows and columns set in the spreadsheet accounting data, and allows setting of journal entry item identifiers of journal entry items set in the input columns; a mapping detail acquisition means for acquiring mapping detail data in which the journal entry item and the journal entry item identifier are set based on target data that does not correspond to the excluded row of the spreadsheet accounting data and corresponds to the input column when the excluded row and the input column are selected and the journal entry item identifier is set on the detail import mapping screen; A journal entry creating means for creating journal entry data based on the mapping detail data; A journal entry mapping import device comprising:

2. The mapping detail data is In addition, a document issuing category indicating whether or not a document has been issued is set in association with the document. The journal entry creation means includes: The journal entry mapping import device according to claim 1, characterized in that a journal entry detail import screen is displayed in which the mapping detail data of the invoicing target can be selected, and when the mapping detail data of the invoicing target is selected on the journal entry detail import screen, the journal entry data for the mapping detail data of the invoicing target is created, and the invoicing classification set in the mapping detail data of the invoicing target is updated to indicate that invoicing has been completed.

3. The journal entry creation means includes:

3. The journal mapping import device according to claim 2, further comprising: a journal entry detail import screen that allows the mapping detail data of the invoicing target to be selected is displayed; when the mapping detail data of the invoicing target is selected on the journal entry detail import screen, a journal entry input screen that allows the mapping detail data of the invoicing target to be supplemented is displayed; when a supplementary item is set on the journal entry input screen, the journal entry data for the mapping detail data of the invoicing target that reflects the supplementary item is created; and the invoicing classification set in the mapping detail data of the invoicing target is updated to indicate that the invoicing has been completed.

4. The mapping detail acquisition means includes: The journal mapping import device of claim 1 further comprises: identifying an original column identifier, which is an identifier indicating the journal item set in the input target column; and registering mapping dictionary data set by linking the original column identifier and the journal item identifier in the accounting storage means.

5. The mapping detail acquisition means includes: The journal mapping import device of claim 4, characterized in that the value set in the cell immediately above the journal item set in the cell of the row to be excluded and the column to be input is identified as the original column identifier, and the mapping dictionary data set in association with the original column identifier and the journal item identifier is registered in the accounting storage means.

6. The mapping detail acquisition means includes: The journal mapping import device of claim 4 or 5 further comprises: identifying the input target column set in the spreadsheet accounting data based on the mapping dictionary data; identifying the excluded row from a cell in which the journal entry item at the bottom of the original column identifier set in the input target column is set; and acquiring the mapping detail data in which the journal entry item and the journal entry item identifier are set based on the target data that does not correspond to the excluded row and corresponds to the input target column.

7. The mapping dictionary data includes: Furthermore, a layout identifier is associated and set, The mapping detail acquisition means includes: The journal mapping import device according to claim 6, further comprising: when the layout identifier is set on the detail import mapping screen, the input target column set in the spreadsheet accounting data is identified based on the mapping dictionary data in which the layout identifier is set; the excluded row is identified from the cell in which the journal entry item at the bottom of the original column identifier set in the input target column is set; and the mapping detail data in which the journal entry item and the journal entry item identifier are set is obtained based on the target data that does not correspond to the excluded row and corresponds to the input target column.

8. The mapping detail acquisition means includes: The journal mapping import device according to claim 3, further comprising: import file data that sets the total number and the number of unissued items of mapping detail data for each spreadsheet accounting data; mapping header data that sets whether or not the journal entry items are set in the mapping detail data; and mapping detail auxiliary data that sets a processing type indicating the processing result of the complementation processing and manages the complementation processing as a log, and is registered in the accounting storage means.

9. The journal entry creation means includes: The journal mapping import device according to claim 2, further comprising: a journal entry detail import screen that allows the selection of the mapping detail data that is to be unusable; and when the mapping detail data that is to be unusable is selected on the journal entry detail import screen, the journal entry detail import screen controls the mapping detail data to be excluded from the selection display of the document issuance target.

10. The storage unit is A code master in which the code of the journal entry item is set; Further comprising: The journal entry creation means includes:

2. The journal mapping import device according to claim 1, wherein the journal data is created by linking the journal items, the codes and the amounts based on the mapping detail data and the code master.

11. A journal entry mapping import method to be executed by a journal entry mapping import device having a storage unit and a control unit, The storage unit is accounting storage means for storing spreadsheet accounting data created using spreadsheet software; Equipped with Executed in the control unit, a detail import mapping display step for displaying a detail import mapping screen that allows selection of rows to be excluded and columns to be input from among the rows and columns set in the spreadsheet accounting data, and allows setting of journal entry item identifiers of journal entry items set in the input columns; a mapping detail acquisition step of acquiring mapping detail data in which the journal item and the journal item identifier are set based on target data that does not correspond to the excluded row of the spreadsheet accounting data and corresponds to the input target column when the excluded row and the input target column are selected and the journal item identifier is set on the detail import mapping screen; A journal entry creation step of creating journal entry data based on the mapping detail data; A journal entry mapping import method comprising:

12. A journal entry mapping import program to be executed by a journal entry mapping import device having a storage unit and a control unit, The storage unit is accounting storage means for storing spreadsheet accounting data created using spreadsheet software; Equipped with In the control unit, a detail import mapping display step for displaying a detail import mapping screen that allows selection of rows to be excluded and columns to be input from among the rows and columns set in the spreadsheet accounting data, and allows setting of journal entry item identifiers of journal entry items set in the input columns; a mapping detail acquisition step of acquiring mapping detail data in which the journal item and the journal item identifier are set based on target data that does not correspond to the excluded row of the spreadsheet accounting data and corresponds to the input target column when the excluded row and the input target column are selected and the journal item identifier is set on the detail import mapping screen; A journal entry creation step of creating journal entry data based on the mapping detail data; The journal entry mapping import program to run.

Images