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 that imports a spreadsheet file created using spreadsheet software, takes into account user selection of columns / rows from the imported data that can be used as accounting data, and automatically assigns account code numbers and obtains accounting data that has had accounting summary conversion processing performed. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Laid-Open No. 2008-102829 Summary of the Invention [Problem to be solved by the invention]

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

[0005] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a journal entry mapping import device, a journal entry mapping import method, and a journal entry mapping import program that can flexibly import information that is the basis for input into the system when the information is prepared in a spreadsheet file on hand in journal entry accounting work, map the spreadsheet file with journal entry items, and create journal entry data. [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 comprising 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 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 item identifiers for journal items set in the input target columns, a mapping detail acquisition means for, when the rows to be excluded and the columns to be input are selected and the journal item identifiers are set on the detail import mapping screen, 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 rows to be excluded in the spreadsheet accounting data and that corresponds to the input target columns, and a journal entry creation means for creating journal data based on the mapping detail data.

[0007] Furthermore, in the journal entry mapping import device of the present invention, the mapping detail data is further set to be linked with an invoice classification indicating whether or not invoices have been issued, and the journal entry creation means displays a journal entry detail import screen in which the mapping detail data of the invoice target can be selected, and when the mapping detail data of the invoice target is selected on the journal entry detail import screen, creates the journal entry data for the mapping detail data of the invoice target, and updates the invoice classification set in the mapping detail data of the invoice target to a mode indicating that invoices have been issued.

[0008] Furthermore, in the journal entry mapping import device of the present invention, the journal entry creation means displays the journal entry detail import screen on which the mapping detail data of the invoice target can be selected, and when the mapping detail data of the invoice target is selected on the journal entry detail import screen, displays a journal entry input screen on which the mapping detail data of the invoice 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 invoice target that reflects the supplementary item, and updates the invoice classification set in the mapping detail data of the invoice target to a mode indicating that the invoice has been issued.

[0009] In addition, in the journal entry mapping import device of the present invention, the mapping detail acquisition means further identifies a source 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 source column identifier and the journal entry item identifier in the accounting storage means.

[0010] In addition, in the journal entry mapping import device of the present invention, the mapping detail acquisition means identifies the value set in the cell immediately above the journal entry 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 entry item identifier in the accounting storage means.

[0011] In addition, in the journal entry 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 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 acquires 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.

[0012] In addition, in the journal entry mapping import device of the present invention, the mapping dictionary data is further set with a layout identifier linked thereto, 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 row 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 acquires 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.

[0013] In addition, in the journal mapping import device of the present invention, the mapping detail acquisition means is further characterized in that it registers in the accounting storage means import file data that sets the total number of mapping detail data items and the number of unissued items for each of the 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 manages the complementation process as a log and sets a processing type that indicates the processing result of the complementation process.

[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 document issuance 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, wherein the memory unit comprises accounting memory 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 that makes it 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 journal item identifiers for journal items set in the input target columns; a mapping detail acquisition step, when the rows to be excluded and the columns to be input are selected and the journal item identifiers are set on the detail import mapping screen, 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 rows to be excluded in the spreadsheet accounting data and that corresponds to the input target columns; and a journal 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, wherein the memory unit comprises accounting storage means for storing spreadsheet accounting data created using spreadsheet software, and the control unit is characterized in that it executes the following: a detail import mapping display step for displaying a detail import mapping screen that makes it 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 journal item identifiers for journal items set in the input target columns; a mapping detail acquisition step for, when the rows to be excluded and the columns to be input are selected and the journal item identifiers are set on the detail import mapping screen, 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 rows to be excluded in the spreadsheet accounting data and that corresponds to the input target columns; and a journal creation step for creating journal data based on the mapping detail data. [Effects of the Invention]

[0018] The present invention has the advantage of reducing human error by importing journal vouchers into Excel®, which previously required users to manually input and visually judge data each time. Furthermore, the present invention has the advantage of significantly reducing the amount of input work required by storing mapping data and automatically applying the settings the next time data is imported. Furthermore, the present invention has the advantage of providing a more flexible means of issuing transfer journal entries than ever before, addressing issues of labor shortages and labor-saving in accounting departments. Furthermore, while daily journal voucher registration previously required entering all required fields in a set format based on existing Excel® data, the present invention allows for automatic completion while importing data, allowing the Excel® data to be used as is. As a result, many companies can improve work efficiency, reduce input workload, and quickly record and understand values. Furthermore, the present invention has the advantage of enabling the systemization of a series of operations, including mapping settings, formatting data into an acceptance format based on the settings data, and expanding the data into journal entry entries. [Brief explanation of the drawings]

[0019] [Figure 1] FIG. 1 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 2] FIG. 2 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 3] FIG. 3 is a block diagram showing an example of the configuration of the journal entry mapping import device according to this embodiment. [Figure 4] FIG. 4 is a flowchart showing an example of processing by the journal entry mapping import device in this embodiment. [Figure 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. [Figure 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. [Figure 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. [Figure 30] FIG. 30 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 31] FIG. 31 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 32] FIG. 32 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 33] FIG. 33 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 34] FIG. 34 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 35] FIG. 35 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 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. [Figure 40] FIG. 40 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 41] FIG. 41 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 42] FIG. 42 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 43] FIG. 43 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 44] FIG. 44 is a diagram showing an example of the journal mapping import process in this embodiment. [Figure 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 INVENTION

[0020] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to this 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 journal mapping import processing in this embodiment.

[0022] In daily accounting work, the information that is the basis for input is often readily available using spreadsheet software such as Excel (registered trademark), and data is often entered manually without importing it from spreadsheet software. However, most general accounting systems do not have a seamless spreadsheet data import function that allows for integration with external systems.

[0023] Previously, (A) functions that assumed the linking of spreadsheet data with external systems required many standard system items for import, and it was extremely rare for all items to be in the documents on 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 on hand could change due to operational changes (system changes, etc.), the idea was to format the files in a predetermined format before importing them, rather than systemizing them, which was time-consuming. As a result, the system's import function could not be utilized, input was time-consuming, and even though the base figures were available, detailed confirmation was required due to human intervention.

[0024] Therefore, in this embodiment, when the data that is the basis for input is prepared on hand in spreadsheet software such as Excel (registered trademark) in daily journal entry accounting work, a mechanism is provided that allows for flexible import into the system and mapping between the spreadsheet software and journal entry items.

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

[0026] In contrast to (B), as shown in Figure 2, this embodiment (3) does not require advance mapping settings, i.e., by reading a file and displaying it on the system while determining the range to be used for input, the effort of adapting to a default format is eliminated and format changes can be flexibly accommodated. In contrast to (B), as shown in Figure 2, this embodiment (4) automatically reflects settings in subsequent imports after importing, and reuses mapping data from previous imports. This eliminates the need to reconfigure settings for recurring monthly tasks, as with conventional import functions. Even if there is a partial change in the layout, mapping can be re-determined. While common mappings such as EDI often specify the column order or appearance position of items in the imported file, and since the imported file is a business form, there is a good chance that layout changes, such as changing the column order, will occur, this embodiment, unlike EDI mappings, allows remapping even if the column order 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. Note that the journalization mapping import device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

[0029] The journal entry mapping import device 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. The units comprised in the journal entry mapping import device 100 are communicably connected via any 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 a communication line. Here, the network 300 has a function of connecting the journalization mapping import 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).

[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 achieve 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, etc. The storage unit 106 stores computer programs that work in conjunction with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as RAM (Random Access Memory) or ROM (Read Only Memory), 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. 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 from the spreadsheet accounting data and for performing reverse lookup of master data from the name, journal data, mapping dictionary data that serves as source data for automating tasks 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 yet been issued, mapping header data for managing data for hiding unused journal items from a screen that displays details to be issued, mapping detail auxiliary data for managing, as a log, supplementary tasks such as referencing master data from the contents of spreadsheet accounting data such as Excel®, 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 items. The code master 106b also includes a business establishment master in which business establishment codes and names are set, a slip classification master in which slip classifications 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 codes and names, credit general account codes and names, debit / credit, and general account codes and names are set, a sub-account master in which debit sub-account codes and names, credit sub-account codes and names, and debit / credit sub-account codes and names are set, a sub-account master in which debit sub-detail account ... It may include a subsidiary breakdown account master with the subsidiary breakdown account code and name, and the debit / credit subsidiary breakdown account code and name set, a customer master with the debit customer code and name, the credit customer code and name, and the debit / credit customer code and name set, an 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, an initial display setting master with the user ID and business establishment code set, and an account code with the account code, revision date, account name, tax category, and tax inclusive category set.

[0035] The control unit 102 is a CPU or the like that performs overall control of the journalization 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, required data, etc., and executes various information processing based on these stored programs. Functionally, the control unit 102 includes a detail import mapping display unit 102a, a mapping detail acquisition unit 102b, and a journalization 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 users 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 journal item identifiers for the journal items set in the input columns.

[0037] The mapping detail acquisition unit 102b acquires mapping detail data of the spreadsheet accounting data. Here, when exclusion target rows and input target columns are selected and journal item identifiers (e.g., journal item names, etc.) are set on the detail import mapping screen, the mapping detail acquisition unit 102b may acquire mapping detail data in which journal items and journal item identifiers are set based on target data that does not correspond to exclusion target rows of the spreadsheet accounting data and corresponds to input target columns. Furthermore, the mapping detail data may be set in association with a voucher classification indicating whether or not a voucher has been issued. Furthermore, the mapping detail acquisition unit 102b may identify a source column identifier, which is an identifier indicating the journal item set in the input target column, and register mapping dictionary data set in association with the source column identifier and the journal item identifier in the accounting database 106a. The mapping detail acquisition unit 102b may also identify, as a source column identifier, a value set in a cell immediately above a journal entry set in a cell of an exclusion target row and an input target column, and register mapping dictionary data set in association with the source column identifier and the journal entry item identifier in the accounting database 106a. The mapping detail acquisition unit 102b may also identify an input target column set in the spreadsheet accounting data based on the mapping dictionary data, identify an exclusion target row from a cell in which the lowest journal entry item of the source column identifier set in the input target column is set, and acquire mapping detail data in which a journal entry item and a journal entry item identifier are set based on target data that does not correspond to an exclusion target row and corresponds to an input target column. The mapping dictionary data may also be set in association with 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 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 imported 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 journal items are set in the mapping detail data, and mapping detail auxiliary data that manages the complementation process as a log and sets the processing type that indicates the processing result of the complementation process.

[0038] The journal entry preparation unit 102c creates journal data. Here, the journal entry preparation unit 102c may create the journal data based on the detailed mapping data. Furthermore, the journal entry preparation unit 102c may display a journal entry detail import screen that allows selection of detailed mapping data of the invoicing target, and when detailed mapping data of the invoicing target is selected on the journal entry detail import screen, create journal data for the detailed mapping data of the invoicing target, and update the invoicing category set in the detailed mapping data of the invoicing target to indicate that invoicing has been completed. Furthermore, the journal entry preparation unit 102c may display a journal entry detail import screen that allows selection of detailed mapping data of the invoicing target, and when detailed mapping data of the invoicing target is selected on the journal entry detail import screen, display a journal entry input screen that allows the detailed mapping data of the invoicing target to be supplemented, and when supplemental items are set on the journal entry input screen, create journal data for the detailed mapping data of the invoicing target that reflects the supplemental items, and update the invoicing category set in the detailed mapping data of the invoicing target to indicate that invoicing has been completed. Furthermore, the journal entry creation unit 102c may display a journal entry detail import screen that allows the selection of unusable mapping detail data, and when unusable mapping detail data is selected on the journal entry detail import screen, may control the exclusion of the mapping detail data from the selection display of voucher targets on the journal entry detail import screen. Furthermore, the journal entry creation unit 102c may create journal entry data that is set by linking journal entry 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] An example of the journal entry mapping import process in this embodiment will now 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 Figure 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 same format as the spreadsheet accounting data is set in the mapping dictionary data (step SA-1: Yes), it moves the process to step SA-2.

[0043] Then, the mapping detail 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 detail data that does not correspond to the excluded rows and that is set by linking the journal entry items, journal entry item identifiers, and document issuing classifications based on the target data that corresponds to the input target columns (step SA-2), and then proceeds 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 allows the user 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 the journal entry item identifiers of the journal entry items set in the input column (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 by linking 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 issuing 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 that allows the selection of mapping detail data for the invoice target, and when the user selects mapping detail data for the invoice target on the journal entry detail import screen via the input device 112, creates journal entry data for the mapping detail data for the invoice target, updates the invoice classification set in the mapping detail data for the invoice target to a mode indicating that invoice has been issued (step SA-6), and terminates the processing.

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

[0050] In this embodiment, the Excel® to be imported is prepared as shown in Figure 5, and the prepared Excel® is read into the system by the user selecting "Create from file" on the journal entry input screen as shown in Figure 6, and the user initially selects "Create from new file" as the initiation method on the journal entry detail import screen, and then selects the file to be uploaded using the file specification button or by dragging and dropping. Here, in this embodiment, if the prepared Excel® has merged cells, when the system displays the text in the merged cells, it is displayed in the top left cell of the merged cells.

[0051] 7, in this embodiment, the specified 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; if no input is made, the first sheet is uploaded.

[0052] In this embodiment, the uploaded Excel® 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® columns as shown in Fig. 9. Here, in this embodiment, merged cells are treated as if they were not merged, and the text in the merged cells is treated as if it were in the leftmost cell, as shown in Fig. 10.

[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, clicking the triangle on each button on the mapping destination selection screen expands the options, and when one of the expanded details is selected, the journal entry item names are set, starting from the left in the bold frame, as shown in Fig. 16. Here, in this embodiment, when an item with a debit / credit prefix is ​​selected, the process is the same as selecting "Debit General Account Name" / "Credit General Account Name" in terms of name. For example, when transferring money from Department A to Department B, if the general account items are the same on the debit and credit sides, debit / credit prefix options are provided to accommodate such journal entries.

[0055] Then, in this embodiment, once the items to be used for journalization have been set, it is necessary to determine the range of data to actually be used next, so if Excel (registered trademark) determines that "from here to here may be title rows" or that "there are rows that will not be used as data," an exclusion column can be selected on the detail import mapping screen to prevent unnecessary rows from being read in. Here, as shown in Figure 17, in this embodiment, if the row just above the starting row to be used as target data for journalization is checked, the rows above the checked row are checked for exclusion; in other words, checking one box checks all the rows at the top, thereby reducing the workload.

[0056] In this embodiment, the mapping destination is confirmed by pressing the Confirm button on the screen, as shown in FIG. 18, and mapping dictionary data is created, as shown in FIG. 19. As shown in FIG. 19, in this embodiment, since different people import data into Excel (registered trademark), data may be managed by user to prevent interference from other users. Alternatively, a pattern of managing data by document name may be provided, assuming that multiple users will use the same settings. Also, as shown in FIG. 19, the method of identifying the source column name in this embodiment is to use the "item in the lowest row of the excluded rows that has a value for each column" as the source item for that column. Since a format in which values ​​above indicate a description and values ​​below indicate the item title is common, this method is adopted because it can be widely used. In this embodiment, the file name and sheet name are used to identify which Excel (registered trademark) the data was imported from. In this embodiment, the journal item code is used to automatically determine the mapping destination if a column matching the source column name exists in Excel (registered trademark) during 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 imported file data is created as shown in Fig. 20. Here, as shown in Fig. 20, in the imported 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 cases 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 for which mapping has been performed and the title is not unspecified, and "Yes" becomes true for each mapping item of the column, which matches 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 values ​​of the auxiliary data, a partial match with the master is referenced, and if there is one match, the master code is registered as the code value of each journal item column in the mapping detail data, and when reverse-looking up, no distinction is made between "full / half-width characters, uppercase characters, lowercase characters, hiragana, and katakana," and only "voiced consonants and semi-voiced consonants" are distinguished. 22, in the mapping detail auxiliary data of this embodiment, SEQ is a number assigned consecutively by row number, the original column number is the column number in Excel® where the cell value is stored, the original row number is the row number in Excel® where the cell value is stored, the journal 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 a master reverse lookup or the like, 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 was identified as a result of the master reverse lookup, and when the processing type is warning, it indicates a case where zero or more items were retrieved as a result of the master reverse lookup, and the cell value is displayed as is on the slip creation screen, and is manually specified on the creation screen.

[0060] Here, as shown in Figure 23, in this embodiment, if there are two journal entry items in the first row 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 SEQ:1, and the reverse lookup result of the debit department name is numbered SEQ:2, so that in mapping detail auxiliary data, etc., even if there are multiple master reverse lookups within one row of data, the keys do not overlap (in other words, since the data row number is 1, key items will overlap if there is no 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 that is found in the mapping header, the value of each column in the corresponding data row is set as the mapping destination item value.

[0062] 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 part controls whether to display or hide the screen using the mapping header data, and those items in the mapping header data that are set to True are displayed (= linked with whether or not mapping is present). 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 Figure 26, in this embodiment, when the screen shown in Figure 25 is switched from the call data tab of STEP 2 to the read log tab, 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 checking the call data will be displayed as shown in the lower diagram of Figure 27, and when the cursor is placed on the triangle mark of "Debit Total Account Name", a pop-up message will appear near the triangle mark, with the same value as the "Processing Content" of the corresponding cell where the processing type on the log confirmation screen shown in the upper diagram of Figure 27 is "1: Warning": "No master containing the specified name was found."

[0065] In this embodiment, as shown in Fig. 28, in order to accommodate the need to issue vouchers for each occurrence date for Excel (registered trademark) containing monthly data, the unit of issuing vouchers can be set by the user, and when the user checks the left end of the area surrounded by a bold frame on the journal entry detail import screen, the 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 used as initial values ​​for the tax category and tax inclusive category, and the amount is broken down into taxes based on these initial values ​​and displayed on the voucher registration screen.

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

[0067] In this embodiment, when the user presses the registration button as shown in Fig. 31, these data are registered at the time registration is completed as shown in Fig. 32. Here, as shown in Fig. 32, in this embodiment, the number of unissued vouchers set in the import file data is subtracted by the number of checked items 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 Figure 33, in this embodiment, when registration is completed on the voucher registration screen (voucher issuing screen), the screen automatically returns to the original journal entry details import screen, and details marked as "voucher issued" cannot be checked.

[0069] An example of a process for issuing a voucher from a file that was 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 would be best if all details could be issued in one go, but since it is possible that the user may close the screen in the middle of issuing a voucher and leave their desk, in this embodiment, a journal entry input screen is displayed on which the "issue from file" button can be selected, as shown in Figure 34. Then, in this embodiment, as shown in Figure 34, 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 user can select "issue from a file previously loaded" as the issuing method.

[0071] In this embodiment, when the user selects "Create a document from a previously loaded file" on the journal entry details 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 are selected and the "Call" button is pressed, as shown in Figure 37, the mapping detail data is read based on the file identifier of the selected details, as shown in Figure 38, and the process resumes with the mapping detail data that was previously submitted displayed, as shown in Figure 37.

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

[0074] In this embodiment, as shown in Figure 41, the user manually completes the journal entry they want to create on the journal entry registration screen, and as shown in Figure 42, the voucher registration is completed, and as shown in Figure 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® data files with the same format but different data contents on a monthly basis. In this embodiment, as shown in FIG. 44, there is an Excel® cash book for June 2022 shown in FIG. 9 and an Excel® cash book for July 2022 with the same format. As shown in FIG. 45, when a user selects the Excel® cash book for July 2022 on the journal entry details import screen and presses the "Upload" button, as shown in FIG. 46, upon completion of the upload, the details import mapping screen is launched with all mapping operations performed initially based on the mapping dictionary data completed. Here, as shown in FIG. 46, in this embodiment, with regard to automatic column setting, after the Excel® data is displayed on the screen, if there is an Excel® cell value that matches the source column name in the mapping dictionary data, the journal entry item is set.

[0077] As shown in FIG. 47, the column identification method in this embodiment involves: (1) starting from the top left corner of the screen, (2) checking whether a value is entered in (1), (3) moving to the cell one cell to the right if no value is entered, and if no cell exists to the right, moving to the left end of the next row and repeating (2), (4) comparing the original column name with the mapping dictionary data to check for matching data, (5) performing the same process as (3) if no matching data exists, and (6) setting a journal entry corresponding to the matching original column name in the screen column and performing the same process as (3) (note that if a screen column has already been set, it is overwritten). Furthermore, in this embodiment, the automatic setting for checking excluded rows is automatically checked down to the bottom of the reverse-converted mapping column, thereby minimizing the burden on users who rarely perform mappings after the second time. Furthermore, in this embodiment, the file name and sheet name are reference information for users to see which file and which sheet were imported, and are not used to identify the mapping. In this embodiment, the process of issuing journal entries after mapping is complete is the same as when issuing entries from a new file. In this embodiment, when a partial layout change occurs, only the mappings that can be determined (only those that can be reversed using the previous column identification methods (1) to (6) are displayed) are restored, and the user can map only the changes, thereby reducing the amount of work required. Even if the title row or column position changes, the same item names can be restored. If item names are changed, added, or deleted, only the changes can be manually addressed. In this embodiment, if an excluded row is mistakenly excluded, including data rows, the mapping destination can be corrected through master maintenance of the mapping dictionary. In this embodiment, if the format has changed so much that it cannot be restored, or if a new mapping is desired, the data can be deleted from master maintenance of the mapping dictionary data, allowing the journal entry detail import screen to be launched without the imported mapping.

[0078] An example of upload processing when 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 journal entry mapping import processing 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 name, not by user. Also, as shown in Fig. 49, in this embodiment, a layout may be registered in the layout master by the user entering a layout code and 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 this embodiment when there are unnecessary data rows will be described with reference to Figures 50 to 55. Figures 50 to 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, lines 6 and 19 are data that only list the remaining amount, so there are cases where you do not want to use them for issuing journal entries, but 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 Figure 54, when a user selects data that is not to be submitted 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 Figure 55, the selected data is set as unusable in the mapping detail data and is no longer counted in the number of unsubmitted entries 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 the achievement of SDGs Goals 8 and 9.

[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, which can contribute to the achievement of Goal 16 of the SDGs.

[0086] 5. Other Embodiments The present invention may be implemented 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] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can 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 functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0090] For example, all or any part of the processing functions of the journalization mapping import device 100, particularly the processing functions performed by the control unit 102, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory, computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the journalization mapping import device 100 as needed. That is, a computer program for providing 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 RAM and cooperates with the CPU to form the control unit.

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

[0092] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "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] Furthermore, a "program" is a data processing method written in any language or description method, and does not matter whether it is in the form of source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure 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, can use well-known configurations and procedures.

[0094] The various databases 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 used for various processes and providing websites.

[0095] The journalization 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 journalization mapping import device 100 may also be realized by installing software (including programs or data) 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 configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Industrial Applicability]

[0097] The present invention is useful in various industries where manual entry of journal entries from data created using spreadsheet software at hand 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 unit 106 Storage section 106a Accounting Database 106b Code Master 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

1. A journal entry mapping import device comprising a storage unit and a control unit, The storage unit accounting storage means for storing spreadsheet accounting data created using spreadsheet software; Equipped with The control unit 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 column; a mapping detail acquisition means for 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 exclusion target rows of the spreadsheet accounting data and that corresponds to the input target columns, when the exclusion target rows and the input target columns are selected and the journal item identifiers are set on the detail import mapping screen; a journal entry creation 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 Furthermore, a document issuing classification indicating whether or not a document has been issued is linked and set. The journal entry creation means The journal mapping import device of claim 1, characterized in that a journal entry detail import screen is displayed in which the mapping detail data of the invoice target can be selected, and when the mapping detail data of the invoice target is selected on the journal entry detail import screen, the journal entry data for the mapping detail data of the invoice target is created, and the invoice classification set in the mapping detail data of the invoice target is updated to indicate that invoice has been issued.

3. The journal entry creation means 3. The journal mapping import device according to claim 2, further comprising: a journal entry detail import screen that allows selection of mapping detail data of the invoicing target; 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; when a supplemental 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 supplemental 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 The journal mapping import device of claim 1 further identifies the value set in the cell of the lowest row containing a value among the cells of the excluded rows of each input target column as the original column identifier, and registers mapping dictionary data linked to the original column identifier and the journal item identifier in the accounting storage means.

5. The mapping detail acquisition means The journal mapping import device of claim 4 further comprises: identifying the input target column set in the spreadsheet accounting data based on the mapping dictionary data; identifying the rows to be excluded by sequentially referencing cells starting from the cell in which the journal entry item at the bottom of the cell in which 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 rows to be excluded and that corresponds to the input target column.

6. The mapping dictionary data includes: Furthermore, a layout identifier is linked and set, The mapping detail acquisition means Furthermore, 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, and the excluded row is identified by referring to the cells in order starting from the cell in which the journal entry item at the bottom of the cell in which 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.

7. The mapping detail acquisition means The journal mapping import device of claim 3 further registers in the accounting storage means import file data that sets the total number of mapping detail data and the number of unissued items 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 manages the supplementation process as a log and sets a processing type that indicates the processing result of the supplementation process.

8. The journal entry creation means The journal entry mapping import device of claim 2 further displays the journal entry detail import screen, which allows the user to select mapping detail data that will not be issued from among the mapping detail data whose issuing classification is not issued, and when the mapping detail data is selected on the journal entry detail import screen, controls the exclusion of the mapping detail data selected on the journal entry detail import screen from the selection display of the issuing target.

9. The storage unit a code master in which the code of the journal entry item is set; Further provided with The journal entry creation means The journal mapping import device according to claim 1, characterized in that 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.

10. 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 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 item identifiers of journal items set in the input columns; 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 exclusion target rows of the spreadsheet accounting data and that corresponds to the input target columns, when the exclusion target rows and the input target columns are selected and the journal item identifiers are 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:

11. 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 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 item identifiers of journal items set in the input columns; 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 exclusion target rows of the spreadsheet accounting data and that corresponds to the input target columns, when the exclusion target rows and the input target columns are selected and the journal item identifiers are set on the detail import mapping screen; a journal entry creation step of creating journal entry data based on the mapping detail data; Journal Entry Mapping Import Program to run.

Images