JP2025007344A - Journal entry mapping import device, journal entry mapping import method, and journal entry mapping import program - Google Patents

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

The present invention relates to a journal entry mapping import device, a journal entry mapping import method, and a journal entry mapping import program.

Patent Document 1 discloses a configuration that imports a spreadsheet file created using spreadsheet software, and acquires accounting data that has been automatically assigned account code numbers and has had accounting abstracts converted, taking into account user selection of columns/rows that can be used as accounting data from the imported data.

JP 2008-102829 A

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

The present invention has been made in consideration of the above 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 on which input is based into the system and map the spreadsheet file with the journal entry items to create journal entry data when the information is prepared in a spreadsheet file at hand in journal entry accounting work.

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 storage unit and a control unit, the storage unit having an accounting storage means for storing spreadsheet accounting data created using spreadsheet software, the control unit having 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 item and the journal entry item identifier 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 rows to be excluded and the input target column are selected and the journal entry item identifier is set on the detail import mapping screen, and a journal entry creation means for creating journal entry data based on the mapping detail data.

In addition, in the journal entry mapping import device of the present invention, the mapping detail data is further set to be linked with an invoicing category indicating whether 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 the invoicing category set in the mapping detail data of the invoicing target to a mode indicating invoicing has been performed.

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 on 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 on 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 the invoicing classification set in the mapping detail data of the invoicing target to a mode indicating that invoicing has been completed.

In addition, in the journal entry mapping import device of the present invention, the mapping details 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.

In addition, in the journal mapping import device of the present invention, the mapping details 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.

In the journal mapping import device of the present invention, the mapping detail acquisition means further 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 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.

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, the mapping dictionary data in which the layout identifier is set is used to identify the input target column set in the spreadsheet accounting data, 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 acquired based on the target data that does not correspond to the excluded row and corresponds to the input target column.

In the journal mapping import device according to the present invention, the mapping detail acquisition means further 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.

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 on which the mapping detail data to be disabled can be selected, and when the mapping detail data 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.

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

The journal mapping import method according to the present invention is a journal mapping import method to be executed by a journal mapping import device having a storage unit and a control unit, the storage unit having an accounting storage means for storing spreadsheet accounting data created using spreadsheet software, and the method includes a detail import mapping display step executed by the control unit for displaying a detail import mapping screen in which excluded rows and input columns among the rows and columns set in the spreadsheet accounting data can be selected and the journal item identifier of the journal item set in the input target column can be set; a mapping detail acquisition step for 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 rows of the spreadsheet accounting data and corresponds to the input target column when the excluded rows and input target columns are selected and the journal item identifier is set on the detail import mapping screen; and a journal entry creation step for creating journal data based on the mapping detail data.

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 storage unit and a control unit, the storage unit having an accounting storage means for storing spreadsheet accounting data created using spreadsheet software, and the control unit 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 item and the journal item identifier 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 excluded rows and input target columns are selected on the detail import mapping screen, and the journal item identifier is set on the target data that does not correspond to the excluded rows of the spreadsheet accounting data and corresponds to the input target column, and a journal entry creation step of creating journal data based on the mapping detail data.

According to the present invention, the journal vouchers that the user had to manually input and visually check each time can be imported into Excel (registered trademark) at hand, which reduces human error. In addition, according to the present invention, the mapping data can be stored and the settings can be automatically used for the next import, which significantly reduces the input work. In addition, according to the present invention, a more flexible means of issuing transfer journal entries can be provided to address the issues of labor shortages and labor saving in the accounting department. In addition, in the daily journal voucher registration work, it was necessary to input all the required items according to a set format based on existing Excel (registered trademark) data, but according to the present invention, since it can be imported while automatically completing, the Excel (registered trademark) data can be used as it is, which results in the effect of improving work efficiency, reducing the input load, and enabling early recording and understanding of numerical values in many companies. In addition, according to the present invention, it is possible to systematize a series of operations including mapping settings, formatting into an acceptance format based on the setting data, and development into journal entry input.

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

An embodiment of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to this embodiment.

[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 mapping import process in this embodiment.

When it comes to daily accounting work, the information on which data is input is often prepared in spreadsheet software such as Excel (registered trademark), and data is often entered manually without importing it from a spreadsheet software. However, most general accounting systems do not have a seamless spreadsheet software data import function that allows for linkage with external systems.

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 there was an issue of how to supplement values that were not in the documents. Also, previously, (B) manually created management documents were output from the linked system, and although the format of the documents on 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. 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.

Therefore, in this embodiment, when the data on which input is based is prepared in a spreadsheet software such as Excel (registered trademark) during daily accounting work, a mechanism is provided that allows the data to be flexibly imported into the system and the spreadsheet software to be mapped to accounting items.

As shown in FIG. 1, 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 this embodiment, (2) even if the system master code is unknown, it can be used, 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 read in as filled in as much as possible.

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 allowing for 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 the mapping data from the past import 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 by making it possible to re-determine the mapping even if there is a partial change in the layout, mapping such as EDI is often specified by the column order or appearance position of the items in the import file, and since the import file is a business document, there is a good chance that layout changes such as changing the column order will occur. However, unlike mapping such as EDI, remapping is possible even if the column order is changed by specifying the name in the format.

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.

As shown in FIG. 3, the journal mapping import device 100 is a commercially available desktop personal computer. Note that the journal 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, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

The journal entry mapping import device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input/output interface unit 108. Each unit included in the journal entry mapping import device 100 is connected to each other so as to be able to communicate with each other via any communication path.

The communication interface unit 104 communicatively connects the journal 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 journal 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).

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 works with a mouse to provide 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.

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs that work with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a 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.

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 the input target column, mapping detail data for managing data that was not excluded in the spreadsheet accounting data and also performing reverse lookup of the master 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, mapping header data for managing data for hiding unused journal items from the screen that is displayed when a screen for selecting details to be issued is displayed, mapping detail auxiliary data for managing supplementary work such as referring to the master from the contents of spreadsheet accounting data such as Excel (registered trademark) as a log, and mapping layout data.

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 the business establishment code and name are set, a document category master in which the document category and name are set, a department master in which the debit department code and name, the credit department code and name, and the debit/credit department code and name are set, an account master in which the debit general account code and name, the credit general account code and name, the debit/credit, and the general account code and name are set, a sub-account master in which the debit sub-account code and name, the credit sub-account code and name, and the debit/credit sub-account code and name are set, a sub-account master in which the debit sub-details ... sub-details code and name are set, a sub-account master in which the debit sub-details code and name, the credit sub-details code and name, and the debit sub-details code and name are set, and a sub-account master in which the debit sub-details code and name are set. It may include an auxiliary breakdown item master in which auxiliary breakdown item codes and names, and debit/credit auxiliary breakdown item codes and names are set, a customer master in which debit customer code and name, credit customer code and name, and debit/credit customer code and name are set, an analysis code master in which debit analysis code and name, credit analysis code and name, and debit/credit analysis code and name are set, an initial display setting master in which a user ID and business establishment code are set, and an item code in which an account code, revision date, account name, tax category, and tax-inclusive category are set.

The control unit 102 is a CPU or the like that provides 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, required data, etc., and executes various information processing based on these stored programs. In terms of function and concept, the control unit 102 includes a detail import mapping display unit 102a, a mapping detail acquisition unit 102b, and a journal creation unit 102c.

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.

The mapping detail acquisition unit 102b acquires mapping detail data of the spreadsheet accounting data. Here, when the selection of the excluded 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 row of the spreadsheet accounting data and corresponds to the input target column. In addition, the mapping detail data may be set by linking with the invoice classification indicating the presence or absence of invoice. In addition, the mapping detail acquisition unit 102b may identify 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 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 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 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 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 excluded row and corresponds to the input target column. In addition, the mapping detail acquisition unit 102b may register in the accounting database 106a the import file data in which the total number and the number of unissued items of mapping detail data for each spreadsheet accounting data are set, the mapping header data in which the presence or absence of a journal entry item is set in the mapping detail data, and the mapping detail auxiliary data in which the processing type indicating the processing result of the complement processing is set and which manages the complement processing as a log.

The journal entry creation unit 102c creates 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 that allows the selection of mapping detail data of the invoicing target, and when 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. The journal entry creation unit 102c may also display a journal entry detail import screen that allows the selection of mapping detail data of the invoicing target, and when mapping detail data of the invoicing target is selected on the journal entry detail import screen, display a journal entry input screen that allows the invoicing target mapping detail data to be supplemented, and when a supplementary item is set on the journal entry input screen, create journal entry data for the invoicing target mapping detail data that reflects the supplementary item, and update the invoicing classification set in the invoicing target mapping detail data to a mode indicating invoicing has been completed. The journal entry creation unit 102c may also display a journal entry detail import screen that allows the selection of mapping detail data of the invoicing target, and when mapping detail data of the invoicing target is selected on the journal entry detail import screen, control the invoicing target mapping detail data to be excluded from the selection display on the journal entry detail import screen. The journal entry creation unit 102c may also 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.

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

[Journal Mapping Import Process]
Here, an example of a 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 a process of the journal entry mapping import device 100 in this embodiment.

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).

Then, 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 transitions the process to step SA-2.

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 rows to be excluded 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.

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

Then, the detail import mapping display unit 102a displays on the output device 114 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 (step SA-3).

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).

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

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 mapping detail data of the invoice target is selected by the user on the journal entry detail import screen via the input device 112, it 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 state indicating invoice has been issued (step SA-6), and ends the process.

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

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

As shown in FIG. 7, in this embodiment, the specified file is uploaded when the user presses the upload button. Here, in this embodiment, input is required only if a specific sheet is to be used; if no input is made, the first sheet is uploaded.

In this embodiment, the uploaded Excel (registered trademark) is displayed on the system as shown in FIG. 8, and as shown in FIG. 9, 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. Here, as shown in FIG. 10, in this embodiment, merged cells are treated as if they were not merged, and the text in the merged cells is treated as being in the leftmost cell.

In the mapping destination determination process in this embodiment, as shown in FIG. 11, the items used for journalization are selected column by column, and when the bold framed "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 "With" set in the mapping header data.

In this embodiment, as shown in FIG. 15, clicking the triangle on each button on the mapping destination selection screen expands the selection options, and when one of the expanded details is selected, the journal entry item names are set from the left in the thick frame as shown in FIG. 16, with "Occurrence Date," "Debit General Account Name," "Detail Summary," and "Debit Amount." Here, in this embodiment, when an item with a debit/credit prefix is selected, the process is the same as if "Debit General Account Name"/"Credit General Account Name" were selected in terms of name. For example, when transferring 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.

As shown in FIG. 17, in this embodiment, once the items to be used for journal entry have been set, it is necessary to determine the range of data to be actually used next. Therefore, if "there are possible title rows from here to here" or "there are rows that will not be used as data" in Excel (registered trademark), the user is prompted to select an exclusion column on the detail import mapping screen to prevent unnecessary rows from being read. Here, as shown in FIG. 17, in this embodiment, if the row one row above the start row to be used as target data for journal entry 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, reducing the workload.

In this embodiment, as shown in FIG. 18, the mapping destination determined by pressing the confirm button on the screen is confirmed, 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 data will not be influenced by other people, or a pattern of managing data on a document name-by-document name basis may be prepared, assuming that multiple users will use the same settings. Also, as shown in FIG. 19, as a method of 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 the task of determining the mapping destination if a column matching the original column name exists in Excel (registered trademark) in the next or subsequent imports.

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 the file identifier, which is a unique identifier assigned to each uploaded file, and the total number and the number of pending votes are the number of all data items below the excluded column.

In this embodiment, the mapping destination is confirmed by pressing the Confirm button on the screen 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 when selecting the mapping destination.

In this embodiment, the mapping destination is confirmed by pressing the Confirm button on the screen 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-looking up, no distinction is made between "full-half-width, uppercase, lowercase, hiragana, and katakana", and only "voiced consonants and semi-voiced consonants" are distinguished. Also, as shown in FIG. 22, in the mapping detail auxiliary data in this embodiment, SEQ is a number that is assigned consecutively by row number, the original column number is the column number in Excel (registered trademark) where the cell value is stored, the original row number is the row number in Excel (registered trademark) where the cell value is stored, the journal entry item code manages which item the original column/original row is assigned to, and the processing type is a classification value that indicates the processing result of reverse lookup of master data, 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 reverse lookup of master data, and when the processing type is warning, it indicates a case where 0 items or two or more items were obtained as a result of reverse lookup of master data, and the cell value is displayed as it is on the slip creation screen, and is manually specified on the creation screen.

As shown in FIG. 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 without SEQ the key items will overlap).

In this embodiment, the mapping destination is confirmed by pressing the Confirm button on the screen 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.

In this embodiment, after the mapping destination is determined as shown in FIG. 18, the loaded data can be confirmed 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 mapping/not mapping). Here, in this embodiment, items without mapping are controlled so that they are not displayed in the list on the screen, as they do not affect the import.

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.

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 "Debit General Account Name", a pop-up message appears near the triangle mark that is the same 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."

In this embodiment, as shown in FIG. 28, in order to meet the need to issue vouchers for each date of occurrence 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 area surrounded by a thick 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 the initial values for the tax category and tax inclusive category, and the amount is broken down into taxes based on the initial values and displayed on the voucher registration screen.

As shown in FIG. 30, in this embodiment, the journal entry that the user wants to create is manually completed; that is, journal entries with mapping settings, such as debits and detail summaries, are automatically determined and generated by the system or automatically completed by the master, and journal entries without mapping settings, such as credits, are manually completed by the user.

In this embodiment, when the user presses the registration 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 issuing 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.

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

Furthermore, an example of a process for issuing a document from a previously loaded file in this embodiment will be described with reference to Figures 34 to 43. Figures 34 to 43 are diagrams showing an example of a journal mapping import process in this embodiment.

It is best to be able to issue all details in one go, but since it is possible that the user may close the screen midway through issuing a document and leave their desk, in this embodiment, as shown in FIG. 34, a journal entry input screen is displayed on which the "Issue from file" button can be selected. And, as shown in FIG. 34, 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 issuing method "Issue from previously loaded file" can be selected.

In this embodiment, when the user selects "Issue 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.

In this embodiment, when the target detail to be called is selected and the "Call" button is pressed, as shown in FIG. 37, the mapping detail data is read based on the file identifier of the selected detail, as shown in FIG. 38, and the process is resumed with the mapping detail data that was previously issued displayed, as shown in FIG. 37.

In this embodiment, as shown in FIG. 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 FIG. 40.

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.

Furthermore, 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 Figures 9 and 44 to 47. Figures 44 to 47 are diagrams showing an example of a journal mapping import process in this embodiment.

There is a business process that imports Excel (registered trademark) 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 (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 details import screen and presses the "Upload" button, as shown in FIG. 46, when the upload is completed, the details import mapping screen is launched with all mapping operations performed the first time completed based on the mapping dictionary data. 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.

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 (1) has a value, (3) move to the cell one cell to the right if there is no value, move to the left end of the next row and perform the process of (2) again, (4) if a value is present, compare it with the original column name of the mapping dictionary data to check whether there is matching data, (5) if there is no data matching the mapping dictionary data, perform the same process as (3), (6) if there is data matching 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 a column of the screen has been set before, it is overwritten). In addition, in this embodiment, the automatic setting of the check for excluded rows is automatically checked up to the bottom of the mapping column that has been reverse-converted, so that the operation is not burdensome to users who have almost no mapping from the second time onwards. In this embodiment, the file name and sheet name are not used to specify the mapping because they are reference information for a person to see which sheet of which file was imported. In this embodiment, the journal entry is issued after the mapping is completed in the same manner as the operation for issuing a journal entry 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 using the previous column identification methods (1) to (6) are displayed) is restored, and the user can map only the changes, which saves labor. Even if the position of the title row or column changes, it is possible to restore the same item name, and when an item name is changed, added, or deleted, 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, the mapping destination can be corrected 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.

Furthermore, with reference to Figures 48 and 49, an example of an upload process in the case where a mapping dictionary in this embodiment is shared between users will be described. Figures 48 and 49 are diagrams showing an example of a journal entry mapping import process in this embodiment.

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 inputting 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.

Furthermore, an example of the import process 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 the journal mapping import process in this embodiment.

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. 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.

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 entries set in the import file data.

[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 making it possible to contribute to goals 8 and 9 of the SDGs.

In addition, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, which can contribute to the achievement of SDGs goals 12, 13, and 15.

In addition, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

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.

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 a known method.

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

In addition, with regard to the journal mapping import device 100, each component shown in the figure is a functional concept, and does not necessarily have to be physically configured as shown in the figure.

For example, the processing functions of the journal 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 on a non-transient computer-readable recording medium that contains programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the journal 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 RAM, and cooperates with the CPU to form the control unit.

This computer program may also be stored in an application program server connected to the journal mapping import device 100 via any network, and all or part of it may be downloaded as needed.

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

A "program" is a data processing method written in any language or description method, and may be in any format, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration consisting of multiple modules or libraries, and a program that works in conjunction with a separate program, such as an OS, to achieve its function. 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.

The various databases stored in the memory unit 106 are storage devices 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 website provision.

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.

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on 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.

The present invention is useful in a variety of industries where manual entry of accounting entries from data created using spreadsheet software is common.

REFERENCE SIGNS LIST 100 Journal entry mapping import device 102 Control unit 102a Details import mapping display unit 102b Mapping details acquisition unit 102c Journal entry creation unit 104 Communication interface unit 106 Storage unit 106a Accounting database 106b Code master 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (12)

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 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 columns, when the excluded rows and the input columns are selected and the journal entry item identifiers are 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: 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. 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. 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. 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. 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. 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. 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. 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. 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. 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 of 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: 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 of 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