JP7223097B2 - Journal data creation device, journal data creation method and journal data creation program - Google Patents

Description

The present invention relates to a journal data creation device, a journal data creation method, and a journal data creation program.

Patent Document 1 discloses a sales proceeds collection system and method that enables a company with multiple sales offices to quickly collect the sales proceeds from each sales office to a predetermined account of the company ( See paragraph 0004 of Patent Document 1, etc.).

Japanese Patent Application Laid-Open No. 2004-030270

When performing such management of recording sales and management of journal entries, in a business format that develops multiple stores, head office batch settlement is often performed. For this reason, it was difficult to specify the expenses incurred for each store.

SUMMARY OF THE INVENTION The present invention has been made in view of the above problems. An object is to provide a data creation method and a journal data creation program.

In order to solve the above-described problems and achieve the object, a journal data creation device according to the present invention is a journal data creation device comprising a control unit and a storage unit, wherein the storage unit stores an account number of a virtual account a settlement account master containing a settlement account code corresponding to said virtual account number and said virtual account number; a deposit/withdrawal data linking master containing an account code and a store code for identifying the store having the virtual account; Acquire the settlement account code corresponding to the virtual account number included in the payment details data, and acquire the store code linked to the acquired settlement account code by referring to the deposit/withdrawal data linkage master. a store code acquisition means for creating journal source data including the deposit/withdrawal amount contained in the deposit/withdrawal detail data and the store code acquired by the store code acquisition means; and the journal source and journal data creation means for creating journal data including the deposit/withdrawal amount and the store code included in the data.

In the journal data creation device according to the present invention, the storage unit further stores an expense item master including an item name of the deposit/withdrawal amount and an expense item code corresponding to the item name. The payment statement data further includes characters representing the content of the deposit/withdrawal amount, the deposit/withdrawal data linking master further includes the expense item code and the linking characters corresponding to the characters, and the store code acquisition means , referring to the settlement account master, acquiring the settlement account code corresponding to the virtual account number included in the deposit/withdrawal detail data; Acquiring the store code and the expense item code linked to the linked characters corresponding to the characters included in the acquired settlement account code and the deposit/withdrawal detail data, creating journal source data including the deposit/withdrawal amount included in the detail data and the store code and the expense item code acquired by the store code acquiring means, and the journal data creating means refers to the expense item master, Acquiring the item name linked to the expense item code included in the journal source data, and creating journal data including the acquired item name, the deposit/withdrawal amount included in the journal source data, and the store code. do.

Further, in the journal data creation device according to the present invention, the deposit/withdrawal data linking master further includes a pre-code for identifying a business partner of the store, and the store code acquisition means stores the settlement account master. reference to acquire the settlement account code corresponding to the virtual account number included in the deposit/withdrawal detail data; The store code, the expense item code, and the destination code associated with the linked characters corresponding to the characters included in the deposit/withdrawal detail data are acquired, and the journal source data creation means generates the deposit/withdrawal detail data. and the store code, the expense item code and the destination code acquired by the store code acquisition means, and the journal data creation means refers to the expense item master , acquire the item name linked to the expense item code included in the journal source data, and create journal data including the acquired item name, deposit/withdrawal amount, store code, and destination code included in the journal source data characterized by:

Further, a journal data creation method according to the present invention is a journal data creation method executed by an information processing apparatus comprising a control unit and a storage unit, wherein the storage unit stores an account number for identifying a virtual account deposit/withdrawal detail data including a virtual account number and a deposit/withdrawal amount for the virtual account; a settlement account master including a settlement account code corresponding to the virtual account number and the virtual account number; and the settlement account code and the virtual account a deposit/withdrawal data linkage master including a store code for identifying a store having an account; A store that acquires the settlement account code corresponding to the virtual account number included in the data, and acquires the store code linked to the acquired settlement account code by referring to the deposit/withdrawal data linking master. a code acquisition step; a journal source data creation step of creating journal source data including the deposit and withdrawal amount included in the deposit and withdrawal detail data and the store code acquired in the store code acquisition step; and a journal data creation step of creating journal data including the included deposit/withdrawal amount and the store code.

Further, a journal data creation program according to the present invention is a journal data creation program to be executed by an information processing device having a control unit and a storage unit, wherein the storage unit stores an account number of a virtual account a settlement account master containing a settlement account code corresponding to said virtual account number and a settlement account code corresponding to said virtual account number and said virtual account number; and a deposit/withdrawal data linking master containing a store code for identifying the store having the virtual account, and referring to the settlement account master for causing the control unit to execute the deposit/withdrawal data. Acquire the settlement account code corresponding to the virtual account number included in the payment details data, and acquire the store code linked to the acquired settlement account code by referring to the deposit/withdrawal data linkage master. a store code acquisition step for creating journal source data including the deposit/withdrawal amount contained in the deposit/withdrawal detail data and the store code acquired in the store code acquisition step; and a journal data creation step of creating journal data including the deposit/withdrawal amount and the store code included in the data.

According to the present invention, by allocating a virtual account to each store, it is possible to create journal data including the amount of deposits and withdrawals for each store.

FIG. 1 is a block diagram showing an example of the configuration of a journal data creation device. FIG. 2 is a diagram showing an example of a processing flow according to this embodiment. FIG. 3 is a diagram showing an example of the contents of each master and each data according to this embodiment.

EMBODIMENT OF THE INVENTION Below, embodiment of the journalizing data preparation apparatus which concerns on this invention, the journalizing data preparation method, and the journalizing data preparation program is described in detail based on drawing. It should be noted that the present invention is not limited by this embodiment.

[1. overview]
In a business format that develops multiple stores, it is often the case that the head office collectively settles accounts. For this reason, conventionally, it has been difficult to identify expenses incurred for each store.

Therefore, in this embodiment, for example, by assigning a virtual account (virtual account) to each store in a multi-store business format, the expenses for each store are specified while debiting utility bills etc. from the head office account. I made it possible to record journal entries.

An outline of processing according to the present embodiment will be described with reference to FIG. First, electronic banking data (EB data) corresponding to the deposit/withdrawal detail data 106a is loaded into the system, as shown in "Account Withdrawal Data Capture" in FIG. Next, as shown in the "direct debit data linking process" in FIG. 2, the settlement account master 106b, the expense item master 106c, the supplier master 106d, the store master 106e, and the received money data are processed for the fetched EB data. Post-master linked direct debit data 106g, which is data linked (combined) with the linked master 106f, is created. Finally, as shown in "journal data linkage processing" in FIG. 2, journal data 106h is created based on the created master-linked direct debit data 106g, and the created journal data 106h is sent to accounting. be done. Specific configurations and operations will be described below.

[2. composition]
An example of the configuration of the journalizing data creation device 100 according to this embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the journal data creation device 100. As shown in FIG.

The journal data creation device 100 is a commercially available desktop personal computer. In addition, the journalizing data creation device 100 is not limited to a stationary information processing device such as a desktop personal computer, but can be a portable personal computer such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), a smart phone, a tablet personal computer, etc. type information processing device.

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

The communication interface unit 104 communicably connects the journalizing data creation device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the journalizing data creation device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Data such as various masters described later may be stored in the server 200, for example.

An input device 112 and an output device 114 are connected to the input/output interface section 108 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that realizes a pointing device function in cooperation with a mouse. Note that, hereinafter, the output device 114 may be referred to as the monitor 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 stores a computer program for performing various processes by giving commands to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

The storage unit 106 stores, for example, deposit/withdrawal detailed data 106a, settlement account master 106b, expense item master 106c, supplier master 106d, store master 106e, deposit/withdrawal data linking master 106f, and journal source data. account debit data 106g after master linking, and journal data 106h.

In the following description, it is assumed that a virtual account is assigned to stores A, B, and C, which correspond to stores in a multi-store business model, as follows. That is, XX bank_YY branch_A store account (virtual account number: 8000001) is assigned to A store, and XX bank_YY branch_B store account (virtual account number: 8000002) is assigned to B store. is assigned, and XX bank_YY branch_C store account (virtual account number: 8000003) is assigned to C store. Note that the actual account corresponding to the three virtual accounts is only one account of XX bank_YY branch. For this reason, even if expenses are withdrawn from only one account of the actual XX bank_YY branch, if the three virtual account numbers can be known, each store (A store, B store, and C point) ), it is possible to grasp the amount of expenses incurred.

The deposit/withdrawal detail data 106a is EB data output from the bank system. The deposit/withdrawal detail data 106a includes, as shown in FIG. Includes payment classification, deposit/withdrawal amount (amount) for the virtual account, characters (summary) representing the content of the deposit/withdrawal amount, and the like. As deposit and payment categories, for example, there are deposit categories that indicate deposits to virtual accounts and withdrawal categories that indicate withdrawals from virtual accounts. In accordance with this, an example of a case where the amount is the withdrawal amount is shown. If the receipt/payment classification is designated as "withdrawal", for example, the receipt data included in the deposit/withdrawal detail data 106a can be excluded to create the journal data 106h. In the following explanation, it is assumed that the deposit/payment classification is the payment classification and the amount is the withdrawal amount.

The settlement account master 106b is a master for linking account information (virtual accounts) and account items. As shown in FIG. 3, the settlement account master 106b contains, for example, a settlement account code (settlement account code) corresponding to a virtual account, a settlement account name, a bank code, a bank name, a branch code, a branch name, a virtual account number (account number), general account code, general account name, sub-account code, sub-account name, sub-description item code and sub-description item name, etc.

The expense item master 106c is a master for linking expense item codes and expense item accounts. As shown in FIG. 3, the expense item master 106c contains, for example, an item name (general account item name), a general account item code, an expense item code (expense item code) corresponding to the item name, an expense item name, etc. including.

The supplier master 106d is a master for storing supplier information (○○ electricity and XX waterworks bureaus from which the amounts in the deposit/withdrawal detail data 106a are withdrawn). Supplier information is set as supplier information in journal data 106h. The supplier master 106d, as shown in FIG. 3, includes, for example, a supplier code (supplier code) for identifying a business partner of the store, a supplier name, and the like.

The store master 106e is a master for storing store information (A store, B store, and C store where the amount in the deposit/withdrawal detail data 106a is withdrawn). Store information is set as department information in journal data 106h. As shown in FIG. 3, the store master 106e includes, for example, a store code (store code) for identifying the store having the virtual account, a store name, and the like.

The deposit/withdrawal data linking master 106f is a master for linking the settlement account master 106b, expense item master 106c, supplier master 106d, and store master 106e based on the deposit/withdrawal data 106a. The deposit/withdrawal data linkage master 106f, as shown in FIG. , including the destination code (supplier code) and store code. The linking character is a character that can be linked with the character representing the content of the deposit/withdrawal amount by a fuzzy search. For example, for three descriptions of "Denkiryo", "Denkidai" and "Denkidaikin", if you set the string "Denki", which is a character string common to the three descriptions, you can link the description and the You can associate letters.

The master-linked direct debit data 106g is data that combines the information included in the deposit/withdrawal detailed data 106a and the information included in the deposit/withdrawal data linkage master 106f, and can be said to be the original data of the journal data 106h. As shown in FIG. 3, the post-master-linked direct debit data 106g includes, for example, recording date, bank code, bank name, branch code, branch name, virtual account number (account number), receipt/payment category, deposit/withdrawal amount (amount ), characters (summary) representing the contents of deposits and withdrawals, settlement account code, expense item code, vendor code (vendor code), store code, etc.

The journal data 106h is journal data generated (created) from the post-master linked direct debit data 106g. In the journal data 106h, expenses (debit main amount and debit consumption tax) are managed by department (by debit department code) and by business partner (by debit business partner code), and virtual accounts are aggregated into real accounts. there is Journal data 106h includes, as shown in FIG. debit department code), destination code (debit customer code), credit item code, credit item name, credit sub-item code, credit sub-item name, credit sub-description item code and credit sub-debt item name, etc.

The control unit 102 is a CPU or the like that controls the journal data creation device 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Execute.

The control unit 102 functionally conceptually (1) refers to the settlement account master, acquires the settlement account code corresponding to the virtual account number included in the deposit/withdrawal detail data, (2) a store code acquisition unit 102a as store code acquisition means for acquiring the store code associated with the acquired settlement account code by referring to the payment data linking master; (3) a journal source data creation unit 102b as journal source data creation means for creating journal source data including the deposit/withdrawal amount and the store code acquired by the store code acquisition unit; and (3) included in the journal source data and a journal data creating unit 102c as journal data creating means for creating journal data including the deposit/withdrawal amount and the store code.

The store code acquisition unit 102a refers to the settlement account master 106b, acquires the settlement account code corresponding to the virtual account number included in the deposit/withdrawal detail data 106a, and further refers to the deposit/withdrawal data linkage master 106f. , to acquire the store code associated with the acquired settlement account code.

The store code acquisition unit 102a can acquire the expense item code in addition to the store code as follows. That is, the store code acquisition unit 102a refers to the settlement account master 106b, acquires the settlement account code corresponding to the virtual account number included in the deposit/withdrawal detail data 106a, and further refers to the deposit/withdrawal data linkage master 106f. By doing so, it is possible to acquire the store code and the expense item code linked to the linking character corresponding to the character representing the content of the deposit/withdrawal amount contained in the acquired settlement account code and deposit/withdrawal detail data 106a.

The store code acquisition unit 102a can acquire the destination code in addition to the store code and the expense item code in the following manner. That is, the store code acquisition unit 102a refers to the settlement account master 106b, acquires the settlement account code corresponding to the virtual account number included in the deposit/withdrawal detail data 106a, and further refers to the deposit/withdrawal data linkage master 106f. Then, it is possible to obtain the store code, expense item code, and destination code associated with the associated character corresponding to the character representing the content of the deposit/withdrawal amount contained in the above-obtained settlement account code and deposit/withdrawal detail data 106a.

The journalizing source data creating unit 102b creates journalizing source data (direct debit data after master linkage 106g) including the deposit/withdrawal amount included in the deposit/withdrawal detail data 106a and the store code acquired by the store code acquisition unit 102a.

The journalizing source data creation unit 102b may include the expense item code in the journalizing source data (post-master linked direct debit data 106g) in addition to the deposit/withdrawal amount and the store code as follows. That is, the journal source data creation unit 102b generates the journal source data (post-master linked direct debit data 106g) including the deposit/withdrawal amount included in the deposit/withdrawal detail data 106a and the store code and expense item code acquired by the store code acquisition unit 102a. can be created.

The journalizing source data creation unit 102b may include the previous code in the journalizing source data (master-linked direct debit data 106g) in addition to the deposit/withdrawal amount, store code, and expense item code, as follows. That is, the journal source data creation unit 102b generates the journal source data (account debit data after master linkage 106g) can be created.

The journal data creation unit 102c creates journal data 106h including the deposit/withdrawal amount and the store code included in the journal source data (master-linked direct debit data 106g).

The journal data creation unit 102c may include the item name in the journal data 106h in addition to the deposit/withdrawal amount and the store code as follows. That is, the journal data creation unit 102c refers to the expense item master 106c, acquires the item name associated with the expense item code included in the journal source data (master-linked direct debit data 106g), and acquires the item name and It is possible to create journal data 106h including the deposit/withdrawal amount and store code included in the journal source data (post-master-linked direct debit data 106g).

The journal data creation unit 102c may include the previous code in the journal data 106h in addition to the deposit/withdrawal amount, store code, and item name, as follows. That is, the journal data creation unit 102c refers to the expense item master 106c, acquires the item name associated with the expense item code included in the journal source data (master-linked direct debit data 106g), and acquires the item name and It is possible to create journal data 106h that includes the deposit/withdrawal amount, store code, and pre-code that are included in the journal source data (master-linked direct debit data 106g).

[3. Specific example of processing]
A specific example of the processing according to this embodiment will be described in detail below with reference to FIG. In this item, the case of creating the journal data 106h for the A store out of the A store, B store, and C store corresponding to each store in a multi-store business format will be specifically described. It is assumed that the contents of each master and each data are as shown in FIG.

(Store code acquisition processing)
As shown in FIG. 3, the store code acquisition unit 102a refers to the settlement account master 106b to obtain a settlement account code corresponding to the virtual account number (store A's virtual account number: 8000001) included in the deposit/withdrawal detail data 106a. ("100" in the settlement account master 106b). At this time, the store code acquisition unit 102a refers to the settlement account master 106b, as shown in FIG. Account item code ("1000" in settlement account master 106b), general account name ("ordinary deposit" in settlement account master 106b), sub-account code ("0009" in settlement account master 106b), sub-account name (settlement account "XX Bank" in the master 106b), sub-description code ("00100001" in the settlement account master 106b), and sub-description item name ("YY branch" in the settlement account master 106b).

The store code acquisition unit 102a further refers to the deposit/withdrawal data linking master 106f as shown in FIG. (summary about store A: denkiryo) corresponding to the linked character ("Denki" in the deposit/withdrawal data linking master 106f) and the linked store code ("T100" in the deposit/withdrawal data linking master 106f) , the expense item code ("H100" in the deposit/withdrawal data linking master 106f) and the previous code ("S100" in the deposit/withdrawal data linking master 106f) are acquired.

(Journal source data creation process)
The journal source data creation unit 102b obtains the deposit/withdrawal amount (withdrawal amount at store A: 10,800 yen) and the store code included in the deposit/withdrawal detail data 106a, as shown in the account debit data 106g after master linkage in FIG. Create master linked direct debit data 106g including store code (T100), expense item code (H100) and previous code (S100) acquired in section 102a. The journal source data creation unit 102b further includes the account date (2017/4/1), bank code (0009), bank code (0009), and Bank name (XX bank), branch code (230), branch name (YY branch), virtual account number (8000001), deposit/payment category (withdrawal), summary (denkiryo), and settlement acquired by the store code acquisition unit 102a The account code (100) may be included in the post-master linked direct debit data 106g.

In other words, the journal source data creation unit 102b can create the direct debit data 106g after master linkage by combining the deposit/withdrawal detailed data 106a and the deposit/withdrawal data linkage master 106f.

(Journal data creation process)
As shown in FIG. 3, the journal data creation unit 102c refers to the expense item master 106c and creates an item name (general account in the expense item master 106c Acquire the subject name “Electricity Bill”). At this time, the journal data creation unit 102c refers to the expense item master 106c, as shown in FIG. The general account item code "2000" in the master 106c) may be obtained.

Further, as shown in the journal data 106h of FIG. 3, the journal data creation unit 102c includes the acquired item name (the debit item name "electricity bill" in the journal data 106h) and the direct debit data after master linking 106g. Deposit/withdrawal amount (total of debit main amount "10,000 yen" and debit consumption tax "800 yen" in journal data 106h "10,800 yen"), store code (debit department code "T100" in journal data 106h), and Create journal data 106h including the destination code (debit customer code "S100" in journal data 106h). The journal data creation unit 102c further acquires the journal number (S0000000001), the line number (1), and the general account item code (credit in the journal data 106h) acquired by the store code acquisition unit 102a, as shown in the journal data 106h of FIG. account code "1000"), general account name (credit account name "ordinary deposit" in journal data 106h), sub-account code (credit sub-account code "0009" in journal data 106h), sub-account name ( Credit subsidiary item name "XX Bank"), subsidiary item code (credit subsidiary item code "00100001" in journal data 106h) and subsidiary item name ("YY branch" in journal data 106h) are included in journal data 106h. may

As described above, the journal data 106h (the data in the row of the journal number S0000000001 in FIG. 3) for the A store can be created. The journal data 106h for store B (the data in the row of journal number S0000000002 in FIG. 3) and the journal data 106h for store C (the data in the row of journal number S0000000003 and the data in the row of journal number S0000000004 in FIG. 3) ) can also be prepared in a similar manner.

The amount withdrawn from the virtual account at store A is 10,800 yen, the amount withdrawn from the virtual account at store B is 21,600 yen, and the amount withdrawn from the virtual account at store C is 76,000 yen. 000 yen (32,400 yen + 43,200 yen) is aggregated, and the total amount of 108,000 yen becomes the actual withdrawal amount from the actual account of the XX bank_YY branch.

(effect)
As described above, according to the journal data creation device 100 according to the present embodiment, it is possible to create journal data including the amount of deposits and withdrawals for each store by allocating a virtual account to each store. As a result, for example, it is possible to easily identify expenses incurred for each store. In the example of the journal data 106h in FIG. 3, since the debit department code linked to the expense debit main amount "10,000 yen" is "T100", the store where the expense was incurred has the debit department code " It can be grasped that it is "Store A" corresponding to "T100".

Further, according to the journal data creation device 100 according to the present embodiment, for example, not only the information as to which store has incurred each deposit/withdrawal amount, but also the item name of each deposit/withdrawal amount and the business partner of the store are specified at the same time. be able to. In the example of the journal data 106h in FIG. 3, the item name associated with the debit main amount "10,000 yen", which is an expense, is the debit item name "electricity bill", so the item name is "electricity bill". It can be understood that In addition, since the business partner associated with the debit main amount of "10,000 yen", which is an expense, has the debit business partner code "S100", the business partner corresponds to the debit business partner code "S100". It can be grasped as electricity.

Then, according to the journal data creation device 100 according to the present embodiment, for example, by using a virtual account, it is possible to specify the occurrence department, specify the occurrence item based on the summary item, and automatically record the journal. can. In addition, payment processing does not occur because it is direct debit, and only the journal entries for withdrawals from the deposit account need to be recorded.

[4. Other embodiments]
The present invention may be implemented in various different embodiments other than the embodiments described above within the scope of the technical idea described in the claims.

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

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

Also, with respect to the journalizing data creation device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions provided by the journal data creation device 100, especially the processing functions performed by the control unit, are implemented in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. Note that the program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing apparatus to execute the processing described in this embodiment. It is read mechanically by the device 100 . That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

In addition, this computer program may be stored in an application program server connected to the journal data creation apparatus 100 via any network, and it is possible to download all or part of it as necessary. is.

Also, the program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (registered (trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Disc (registered trademark) such as Blu- shall include any "portable physical medium".

A "program" is a data processing method written in any language or writing method, regardless of the format such as source code or binary code. In addition, the "program" is not necessarily limited to a single configuration, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, the installation procedure after reading, and the like.

The various databases stored in the storage unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks. It stores programs, tables, databases, files for web pages, and so on.

Further, the journal data creation 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. Further, the journal data creation device 100 may be implemented by installing software (including programs or data) that allows the device to implement the processing described in the present embodiment.

Furthermore, the specific forms of distribution and integration of devices are not limited to those shown in the figures, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

INDUSTRIAL APPLICABILITY The present invention is useful in all industries and types of business, and is particularly useful in industries that develop multiple stores.

100 journal data creation device 102 control unit
102a store code acquisition unit
102b Journal source data creation unit
102c journal data creation unit 104 communication interface unit 106 storage unit
106a Deposit/withdrawal details data
106b Settlement account master
106c Expense item master
106d Supplier master
106e Store master
106f Deposit/withdrawal data linkage master
106g Direct withdrawal data after linking to master
106h journal data 108 input/output interface unit 112 input device 114 output device 200 server 300 network

Claims (4)

A journal data creation device comprising a control unit and a storage unit,
The storage unit contains
Deposit /withdrawal detail data including the account number of the account, the amount of deposit/withdrawal for the account , and characters representing the contents of the amount of deposit/withdrawal;
a settlement account master including the account number and a settlement account code corresponding to the account number;
an expense item master including an item name for the deposit/withdrawal amount and an expense item code corresponding to the item name;
a deposit/withdrawal data linking master including the settlement account code, linking characters corresponding to the characters, a store code for identifying a store having the account, and the expense item code;
is stored and
The control unit
The settlement account code corresponding to the account number included in the deposit/withdrawal detail data is obtained by referring to the settlement account master, and the deposit/withdrawal data linkage master is referred to. store code acquisition means for acquiring the store code and the expense item code associated with the linked characters corresponding to the characters included in the acquired settlement account code and deposit/withdrawal detail data;
journal source data creation means for creating journal source data including the deposit/withdrawal amount included in the deposit/withdrawal detail data and the store code and expense item code acquired by the store code acquisition means;
By referring to the expense item master, the item name linked to the expense item code included in the journal source data is obtained, and the acquired item name and the deposit/withdrawal amount and store code included in the journal source data are Journal data creation means for creating journal data including
to provide
A journal data creation device characterized by: The deposit/withdrawal data linking master further includes a destination code for identifying a business partner of the store,
The store code acquisition means is
By referring to the settlement account master, the settlement account code corresponding to the account number included in the deposit/withdrawal detail data is obtained, and further, by referring to the deposit/withdrawal data linkage master, the acquired Acquiring the store code, the expense item code, and the destination code linked to the linked characters corresponding to the characters included in the payment account code and the deposit/withdrawal detail data,
The journal source data creation means is
creating journal source data including the deposit/withdrawal amount contained in the deposit/withdrawal detail data and the store code, expense item code, and destination code acquired by the store code acquisition means;
The journal data creation means is
By referring to the expense item master, the item name linked to the expense item code included in the journal source data is acquired, and the acquired item name and the deposit/withdrawal amount included in the journal source data, the store code and creating journal data including the preceding code;
The journalizing data creation device according to claim 1, characterized by: A journal data creation method executed by an information processing device comprising a control unit and a storage unit,
The storage unit contains
Deposit/withdrawal detail data including the account number of the account, the amount of deposit/withdrawal for the account, and characters representing the contents of the amount of deposit/withdrawal;
a settlement account master including the account number and a settlement account code corresponding to the account number;
an expense item master including an item name for the deposit/withdrawal amount and an expense item code corresponding to the item name;
a deposit/withdrawal data linking master including the settlement account code, linking characters corresponding to the characters, a store code for identifying a store having the account, and the expense item code;
is stored and
executed by the control unit;
By referring to the settlement account master, the settlement account code corresponding to the account number included in the deposit/withdrawal detail data is obtained, and further, by referring to the deposit/withdrawal data linkage master, the acquired a store code acquisition step of acquiring the store code and the expense item code associated with the linked characters corresponding to the characters included in the payment account code and the deposit/withdrawal detail data;
a journal source data creation step of creating journal source data including the deposit/withdrawal amount included in the deposit/withdrawal detail data and the store code and expense item code acquired in the store code acquisition step;
By referring to the expense item master, the item name linked to the expense item code included in the journal source data is obtained, and the acquired item name and the deposit/withdrawal amount and store code included in the journal source data are a journal data creation step for creating journal data including
including
A journal data creation method characterized by A journal data creation program to be executed by an information processing device comprising a control unit and a storage unit,
The storage unit contains
Deposit/withdrawal detail data including the account number of the account, the amount of deposit/withdrawal for the account, and characters representing the contents of the amount of deposit/withdrawal;
a settlement account master including the account number and a settlement account code corresponding to the account number;
an expense item master including an item name for the deposit/withdrawal amount and an expense item code corresponding to the item name;
a deposit/withdrawal data linking master including the settlement account code, linking characters corresponding to the characters, a store code for identifying a store having the account, and the expense item code;
is stored and
for causing the control unit to execute
By referring to the settlement account master, the settlement account code corresponding to the account number included in the deposit/withdrawal detail data is obtained, and further, by referring to the deposit/withdrawal data linkage master, the acquired a store code acquisition step of acquiring the store code and the expense item code associated with the linked characters corresponding to the characters included in the payment account code and the deposit/withdrawal detail data;
a journal source data creation step of creating journal source data including the deposit/withdrawal amount included in the deposit/withdrawal detail data and the store code and expense item code acquired in the store code acquisition step;
By referring to the expense item master, the item name linked to the expense item code included in the journal source data is obtained, and the acquired item name and the deposit/withdrawal amount and store code included in the journal source data are a journal data creation step for creating journal data including
including
Journal data creation program characterized by.

Images