JP2019061406A - Classification data preparation device, classification data creation method and classification data creation program - Google Patents

Abstract

To provide a classification data preparation device, a classification data creation method, and a classification data creation program capable of creating classification data including an amount of deposit and withdrawal for each shop by allocating a virtual account to each shop.SOLUTION: The classification data creation method of this embodiment comprises: (1)acquiring a settlement account code corresponding to a virtual account number included in deposit and withdrawal detail data including the virtual account number and a deposit and withdrawal money amount regarding the virtual account by referring to the virtual account number and a settlement account master including the settlement account code corresponding to the virtual account number, and further acquiring a shop code tied up with the acquired settlement account code by referring to a deposit and withdrawal tie-up master including the settlement account code and a shop code; (2) generating classification original data including a deposit and withdrawal money amount included in the deposit and withdrawal detail data and the acquired shop code; and (3) generating classification data including the deposit and withdrawal money amount and the shop code included in the classification original data.SELECTED DRAWING: Figure 3

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 money collecting system and method capable of quickly collecting sales proceeds from each sales shop to a predetermined account of the business in a company having a plurality of sales offices ( See, for example, paragraph 0004 of Patent Document 1).

Japanese Patent Application Publication No. 2004-030270

  In order to manage such sales accrual and journal accrual, in the case of a business type that has many stores, it is common to perform a headquarter settlement. For this reason, it was difficult to identify the expenses generated for each store.

  The present invention has been made in view of the above problems, and by allocating a virtual account to each store, a journalization data creation device capable of creating journal data including a deposit amount for each store, a journal entry It aims at providing a data creation method and a journal data creation program.

  In order to solve the problems described above and achieve the object, the journal data generation device according to the present invention is a journal data generation device including a control unit and a storage unit, and the storage unit includes an account number of a virtual account. Settlement account master including a virtual account number for identifying the account number, deposit and withdrawal amount for the virtual account, a settlement account code including the virtual account number and a settlement account code corresponding to the virtual account number, and the settlement A deposit / withdrawal data linkage master including an account code and a store code for identifying a store having the virtual account is stored, and the control unit refers to the settlement account master to make the deposit / deposit The settlement account code corresponding to the virtual account number included in the gold statement data is acquired, and further, the acquired settlement account code and string are referenced with reference to the deposit / withdrawal data linkage master. In addition, the store code acquisition means for acquiring the shop code, the journal entry data preparation for generating the journal entry data including the deposit and withdrawal amount included in the deposit and withdrawal statement data, and the shop code acquired by the shop code acquisition means It is characterized by comprising: means, and journal data creation means for creating journal data including the deposit and withdrawal amount included in the journal source data and the store code.

  Further, in the journal data generating device according to the present invention, the storage unit further stores a cost item master including an item name for the input and output amount and a cost item code corresponding to the item name. The gold specification data further includes a character representing the content of the deposit and withdrawal amount, the deposit and withdrawal data linking master further includes the expense item code and a linking character corresponding to the character, and the store code acquisition means Acquiring the settlement account code corresponding to the virtual account number included in the deposit and withdrawal statement data with reference to the settlement account master, and further referring to the deposit and withdrawal data connection master; The shop code and the cost item code associated with the acquired settlement account code and the associated character corresponding to the character included in the deposit and withdrawal details data are acquired, and the journal entry data creation means Creates journal entry data including the deposit and withdrawal amount included in the deposit and withdrawal details data, the store code acquired by the store code acquisition means, and the expense item code, and the journal data creation unit includes the expense item master The item name associated with the cost item code included in the journal entry source data is acquired with reference to the item name, and the journal data including the acquired item name, the amount of money contained in the journal entry source data, and the shop code is created To be characterized.

  Further, in the journal data generation device according to the present invention, the deposit and withdrawal data linking master further includes a destination code for identifying a business partner of the store, and the store code acquisition means includes the settlement account master. The payment account code corresponding to the virtual account number included in the deposit and withdrawal statement data is acquired by reference, and the acquired payment account code and the acquired payment account code with reference to the deposit and withdrawal data connection master. The store code associated with the linked character corresponding to the character included in the deposit and withdrawal specification data, the expense item code, and the destination code are acquired, and the journal data creation means is configured to receive the deposit and withdrawal specification data Creating the journal entry data including the deposit and withdrawal amount included in the store code, the store code acquired by the store code acquisition means, the expense item code, and the destination code; The data creating means acquires the item name associated with the item code included in the journal data with reference to the item master, and obtains the name of the acquired item and the amount of money included in the data of the journal, the item amount And creating journal data including a store code and the destination code.

  Further, the journal data generation method according to the present invention is a journal data generation method executed by an information processing apparatus including a control unit and a storage unit, wherein the storage unit identifies an account number of a virtual account. A settlement account master including a virtual account number and deposit and withdrawal amount data for the virtual account, a settlement account master including the virtual account number and a settlement account code corresponding to the virtual account number, the settlement account code and the virtual A deposit / detachment data linkage master including a store code for identifying a store having an account, and the deposit / withdrawal statement with reference to the settlement account master, which is executed by the control unit The settlement account code corresponding to the virtual account number included in the data is acquired, and further, it is linked with the acquired settlement account code with reference to the deposit / withdrawal data linkage master. Step of acquiring the store code, step of preparing the journal data including the source code including the deposit and withdrawal amount included in the deposit and withdrawal statement 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 amount and the store code included in the journal source data.

  Further, the journal data generation program according to the present invention is a journal data generation program to be executed by an information processing apparatus including a control unit and a storage unit, and the storage unit identifies an account number of a virtual account. Settlement account master including the virtual account number and the deposit amount for the virtual account, the settlement account master including the virtual account number and the settlement account code corresponding to the virtual account number, the settlement account code, and the settlement account code A deposit / withdrawal data linkage master including a store code for identifying a store having a virtual account is stored, and the deposit / detachment data is stored with reference to the settlement account master to be executed by the control unit. Acquiring the settlement account code corresponding to the virtual account number included in the gold statement data, and further acquiring the settlement account code with reference to the deposit / withdrawal data linkage master Create a journal source data including a store code acquisition step of acquiring the store code linked to a settlement account code, the deposit and withdrawal amount included in the deposit and withdrawal statement 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 amount and the store code included in the journal source data.

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

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

  Hereinafter, an embodiment of a journal data creation device, a journal data creation method, and a journal data creation program according to the present invention will be described in detail based on the drawings. The present invention is not limited by the present embodiment.

[1. Overview]
In the case of a business format with many stores, it is often necessary to make a headquarter settlement. For this reason, conventionally, it has been difficult to identify the expenses generated for each store.

  Therefore, in the present embodiment, for example, by allocating a virtual account (virtual account) to each store in a multi-store business format, the expenses for each store are specified while deducting the utility expenses etc. from the headquarters account. It enabled it to be able to make a journal entry.

  The outline of the process according to the present embodiment will be described with reference to FIG. First, electronic banking data (EB data) corresponding to the deposit / withdrawal statement data 106a is taken into the system as shown in "Account Debit Data Capture" in FIG. Next, as shown in “Account withdrawal data linking process” of FIG. 2, the settlement EB master, the cost item master 106c, the vendor master 106d, the store master 106e, and the acquired gold data for the taken EB data. Master linked post-correspondence debit data 106g, which is data linking (joining) the linking master 106f, is created. Finally, as shown in “Journal data linkage processing” of FIG. 2, journal data 106h is created based on the master post-correspondence account deduction data 106g created, and the journal data 106h created is transmitted to the accounting Be done. The specific configuration and operation will be described below.

[2. Constitution]
An example of the configuration of the journal data generation device 100 according to the present 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. The journal data generation apparatus 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, but may be a portable personal computer such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), a smartphone, or a tablet personal computer. It may be a type information processing apparatus.

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

  The communication interface unit 104 communicably connects the journal 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 communicably connecting the journal data creation device 100 and the server 200, and is, for example, the Internet, a local area network (LAN), or the like. Note that data of various masters and the like 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 unit 108. For the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. The input device 112 can be a keyboard, a mouse, a microphone, and a monitor that implements a pointing device function in cooperation with the mouse. Hereinafter, the output device 114 may be described as the monitor 114, and the input device 112 may be described 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 giving instructions to a central processing unit (CPU) in cooperation with an operating system (OS) to perform various processes. As the storage unit 106, for example, a memory device such as a random access memory (RAM) or a read only memory (ROM), a fixed disk device such as a hard disk, a flexible disk, an optical disk or the like can be used.

  The storage unit 106, for example, as deposit and withdrawal statement data 106a, settlement account master 106b, expense item master 106c, supplier master 106d, store master 106e, deposit and withdrawal data linkage master 106f, and journal data Of the master deduction direct debit data 106g and journal data 106h.

  In the following, description will be given on the assumption that virtual accounts are assigned as follows to each of the A store, B store and C store that correspond to each store in a multi-store business format. That is, XX bank _ YY branch _ A shop account (virtual account number: 8000001) is assigned to A shop, and XX bank _ YY branch _ B shop account (virtual account number: 8000002) for B shop Is assigned, and for the C store, the XX bank _ YY branch _ C store account (virtual account number: 8000003) is assigned. In addition, the existing account corresponding to the said three virtual accounts is only one account of XX bank_YY branch. For this reason, if withdrawal of expenses etc. can be made while knowing the three virtual account numbers while making a deduction from only one existing XX Bank _ YY branch account, each store (each store A, store B and store C) You can figure out how much cost you incurred.

  The deposit and withdrawal details data 106a is EB data output from the banking system. As shown in FIG. 3, the deposit / withdrawal details data 106a includes, for example, account date, bank code, bank name, branch code, branch name, virtual account number (account number) for identifying account number of virtual account, deposit It includes payment classification, deposit and withdrawal amount (amount of money) for the virtual account, and characters (summary) indicating the contents of the deposit and withdrawal amount. There are, for example, a deposit category which means payment to a virtual account, or a withdrawal category which means withdrawal from a virtual account, etc., as payment deposit categories, but in FIG. In this case, the example shows the case where the amount is a withdrawal amount. When the deposit and withdrawal category is designated as “withdrawal”, for example, the deposit data included in the deposit and withdrawal statement data 106 a can be excluded to create the journal data 106 h. In the following description, the explanation will be made assuming that the payment category is the withdrawal category and the amount is the withdrawal amount.

  The settlement account master 106 b is a master for linking account information (virtual account) and accounts. The settlement account master 106b, as shown in FIG. 3, for example, settlement account code (settlement account code) corresponding to a virtual account, settlement account name, bank code, bank name, branch code, branch name, virtual account number (account Number), general account item code, general account item name, supplementary item code, supplementary item name, supplementary breakdown item code, supplementary breakdown item name etc. are included.

  The expense item master 106 c is a master for associating the expense item code with the expense item account. As shown in FIG. 3, the expense item master 106c includes, for example, an item name (total account item name), an account item code, an item code corresponding to the item name (expense item code), and an item name etc. including.

  The supplier master 106d is a master for storing supplier information (the ○ electricity and × water department which is the side for debiting the amount in the deposit and withdrawal details data 106a). The supplier information is set as supplier information in the journal data 106h. The vendor master 106 d includes, for example, a destination code (vendor code) for identifying a business partner of a store and a vendor name, as shown in FIG. 3.

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

  The deposit / withdrawal data linkage master 106f is a master for associating the settlement account master 106b, the expense item master 106c, the supplier master 106d, and the store master 106e based on the deposit / withdrawal data 106a. As shown in FIG. 3, for example, as shown in FIG. 3, the deposit / withdrawal data linking master 106f is a linked letter (linked letter) corresponding to a character (summary) representing the contents of the payment amount, the payment amount , Destination code (vendor code) and store code etc. The linking character is a character that can be linked in a fuzzy search with a character representing the content of the deposit and withdrawal amount. For example, if the linking character “Denki”, which is a character string common to the three abstracts, is set for the three abstracts “Denki Ry」 ”,“ Denki DAI ”and“ Denki DAIKIN ”, the abstracts and the strings are linked. It can be associated with letters.

  The master withdrawal linked debit data 106g is data obtained by combining the information included in the deposit and withdrawal details data 106a and the information included in the deposit and withdrawal data linkage master 106f, and can be said to be the original data of the journal data 106h. As shown in FIG. 3, for example, as shown in FIG. 3, the post-master linked account withdrawal data 106g includes an account date, a bank code, a bank name, a branch code, a branch name, a virtual account number (account number), a payment category, a deposit amount (amount ), Characters (summary) indicating contents of deposit and withdrawal amount, settlement account code, expense item code, destination code (vendor code), store code and the like.

  The journal data 106 h is data of journals generated (created) from the master withdrawal linked account withdrawal data 106 g. In the journal data 106h, the expenses (the debit amount and the debit consumption tax) are managed by division (by debit division code) and by suppliers (by debit supplier code), and the virtual account is aggregated into the real account There is. The journal data 106h, as shown in FIG. 3, for example, journal number, line number, debit item code, item name (debit item name), deposit amount (total amount of debit main amount and debit consumption tax), store code Debit department code), destination code (debit customer code), credit subject code, credit subject name, credit assistance subject code, credit assistance subject name, credit assistance breakdown subject code, credit assistance breakdown subject name etc.

  The control unit 102 is a CPU or the like that centrally controls the journalization data creation device 100. The control unit 102 has an internal memory for storing control programs such as the OS, programs defining various processing procedures, required data, etc., and performs various information processing based on the stored programs. Run.

  The control unit 102 functionally and (1) refers to the settlement account master to obtain the settlement account code corresponding to the virtual account number included in the deposit and withdrawal statement data, and further, the settlement account code Store code acquisition unit 102a as store code acquisition means for acquiring the shop code associated with the acquired settlement account code with reference to the withdrawal data linkage master, (2) included in the deposit / withdrawal statement data A journal entry source data creation unit 102b as journal entry source data creation means for creating journal entry source data including the received / dispense amount to be stored and the store code acquired by the store code acquisition means; (3) included in the journal entry source data And a journal data creation unit 102c as journal data creation means for creating journal data including the deposit and withdrawal amount and the store code.

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

  The shop code acquisition unit 102a can acquire a cost code in addition to the shop code as follows. That is, the store code acquisition unit 102a refers to the settlement account master 106b to acquire a settlement account code corresponding to the virtual account number included in the deposit and withdrawal statement data 106a, and further refers to the deposit and withdrawal data connection master 106f. Then, it is possible to acquire a shop code and a cost item code that are associated with the linked characters corresponding to the characters representing the contents of the payment amount included in the acquired payment account code and deposit / withdrawal statement data 106a.

  The shop code acquisition unit 102a can acquire the destination code in addition to the shop code and the expense item code as follows. That is, the store code acquisition unit 102a refers to the settlement account master 106b to acquire a settlement account code corresponding to the virtual account number included in the deposit and withdrawal statement data 106a, and further refers to the deposit and withdrawal data connection master 106f. Then, it is possible to acquire a shop code, a cost code, and a destination code associated with the linked characters corresponding to the characters representing the contents of the deposit and withdrawal amount included in the acquired payment account code and deposit and withdrawal statement data 106a.

  The journal entry data creation unit 102b creates journal entry data (master withdrawal credit withdrawal data 106g) including the deposit and withdrawal amount included in the deposit and withdrawal statement data 106a and the store code acquired by the store code acquisition unit 102a.

  The journal entry data creation unit 102b may include a cost item code in the journal entry data (the account withdrawal data after master tying data 106g) in addition to the deposit and withdrawal amount and the store code as follows. That is, the journal entry source data creation unit 102b includes journal entry source data (master withdrawal credit withdrawal data 106g) including the deposit and withdrawal amount included in the deposit and withdrawal statement data 106a and the store code and cost item code acquired by the store code acquisition unit 102a. Can be created.

  The journal entry source data creation unit 102b may include the destination code in the journal entry source data (master withdrawal credit withdrawal data 106g) in addition to the deposit and withdrawal amount, the store code, and the expense item code as follows. In other words, the journal entry source data creation unit 102b includes journal entry source data (master withdrawal account withdrawal data) including the deposit and withdrawal amount included in the deposit and withdrawal statement data 106a, the store code acquired by the store code acquisition unit 102a, cost item code and destination code 106g) can be created.

  The journalization data creation unit 102c creates journalization data 106h including the deposit and withdrawal amount and the store code included in the journal entry source data (master withdrawal linked account withdrawal data 106g).

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

  The journal data creation unit 102c may also include a destination code in the journal data 106h in addition to the deposit and withdrawal amount, the store code, and the subject name as follows. That is, the journalization data creation unit 102c refers to the expense item master 106c, acquires the item name associated with the expense item code included in the journalizing source data (master debit debit debit data 106g), and obtains the acquired item name and It is possible to create journal data 106h including the deposit / withdrawal amount included in the journal entry source data (master withdrawal linked account withdrawal data 106g), a store code, and a destination code.

[3. Specific example of processing]
Hereinafter, a specific example of the process according to the present embodiment will be described in detail with reference to FIG. In this item, the case of creating the journal data 106h for the A store among the A store, B store and C store corresponding to each store in the multi-store business format will be specifically described. 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, and the settlement account code corresponding to the virtual account number (virtual account number of store A: 8000001) included in the deposit / withdrawal statement data 106a. ("100" in the settlement account master 106b) is acquired. At this time, as shown in FIG. 3, the store code acquisition unit 102a refers to the settlement account master 106b, and the total corresponding to the virtual account number (virtual account number of A store: 8000001) included in the deposit / withdrawal data 106a. Account code ("1000" in settlement account master 106b), general account name ("normal deposit" in settlement account master 106b), supplementary item code ("0009" in settlement account master 106b), supplementary item name (settlement account) You may acquire "XX bank" in the master 106b, an auxiliary breakdown item code ("00100001" in the settlement account master 106b), and an auxiliary breakdown item name ("YY branch" in the settlement account master 106b).

  Further, as shown in FIG. 3, the store code acquiring unit 102a refers to the deposit / withdrawal data linkage master 106f, and the contents of the deposit and withdrawal amount included in the acquired payment account code (100) and the deposit / withdrawal specification data 106a. Store code ("T100" in the deposit / withdrawal data linkage master 106f) associated with the associated character ("Denki" in the deposit / withdrawal data linkage master 106f) corresponding to the character representing the The expense item code ("H100" in the deposit / withdrawal data connection master 106f) and the destination code ("S100" in the deposit / withdrawal data connection master 106f) are acquired.

(Journal data creation process)
The journal entry data creation unit 102b acquires the deposit and withdrawal amount (dispense of store A: 10,800 yen) and the store code, which are included in the deposit and withdrawal statement data 106a, as shown in the master withdrawal linked account withdrawal data 106g in FIG. The master withdrawal linked direct debit data 106g including the shop code (T100), the expense item code (H100) and the destination code (S100) acquired by the unit 102a are created. The journal entry data creation unit 102b further includes an accounting date (2017/4/1), a bank code (0009), and the like included in the deposit / withdrawal statement data 106a, as shown in the master withdrawal linked debit data 106g in FIG. Bank name (XX bank), branch code (230), branch name (YY branch), virtual account number (8000001), payment classification (withdrawal), payment (payment), and payment acquired by store code acquisition unit 102a The account code (100) may be included in the master linked direct debit data 106g.

  In other words, the journal entry source data creation unit 102b can create the post-master linked account withdrawal data 106g by combining the deposit and withdrawal details data 106a and the deposit and withdrawal data linking master 106f.

(Journal data creation process)
The journalization data creation unit 102c refers to the expense item master 106c as shown in FIG. 3, and refers to the item name (total account in the expense item master 106c) associated with the expense item code (H100) included in the master withdrawal linked debit data 106g. Acquire the subject name "Electricity charges"). At this time, as shown in FIG. 3, the journal data creation unit 102 c refers to the expense item master 106 c, as shown in FIG. 3, the general account item code (expense item code) associated with the expense item code (H 100) included in the master withdrawal linked debit data 106 g. The general account code “2000” in the master 106 c may be acquired.

  The journal data creation unit 102c further includes, as shown in the journal data 106h of FIG. 3, the acquired item name (the debit item name "electricity bill" in the journal data 106h) and the master withdrawal linked account withdrawal data 106g. Deposit amount (total of "10,800 yen" of debit main amount "10,000 yen" and debit consumption tax "800 yen" in journal data 106h), store code (debit section code "T100" in journal data 106h) and Journal data 106h including the destination code (debit customer code "S100" in journal data 106h) is created. Further, as shown in the journal data 106h of FIG. 3, the journal data creation unit 102c indicates the journal number (S0000000001), the line number (1), the general account code (accredited in the journal data 106h) acquired by the store code acquiring unit 102a. Subject code "1000"), general account subject name (credit subject name "general deposit" in journal data 106h), supplementary subject code (credit supplementary subject code in journal data 106h "0009"), supplementary subject name (in journal data 106h) Include in the journalizing data 106h the name of the credit assistance subject "XX Bank"), the assistance breakdown item code (credit assistance breakdown item code "00100001" in the journal data 106h) and the assistance breakdown item name ("YY branch" in the journal data 106h). May be

  As described above, it is possible to create the journal data 106h (data of the line of the journal number S0000000001 in FIG. 3) for the A store. The journal data 106h for the B store (data in the line of the journal number S0000000002 in FIG. 3) and the journal data 106h for the store C (data in the line with the journal number S0000000003 in FIG. 3 and the data in the line with the journal number S0000000004 ) Can also be created by the same method.

  Then, 10,800 yen paid out from the virtual account for Store A, 21,600 yen paid out from the virtual account for Store B and 76 paid out from the virtual account for Store C, 000 yen (32,400 yen + 43,200 yen) is consolidated, and the total amount 108,000 yen is the actual withdrawal amount from the real account of the Bank XX_YY branch.

(effect)
As described above, according to the journal data generating device 100 according to the present embodiment, it is possible to create journal data including the deposit and withdrawal amount for each store by allocating a virtual account to each store. Thereby, for example, the expense generated for each store can be easily identified. In the example of the journal data 106h of FIG. 3, since the debit section code associated with the debit main amount "10,000 yen" which is the cost is "T100", the store where the cost is generated is the debit section code " It can be understood that it is "A store" corresponding to T100 ".

  Further, according to the journal data creation device 100 according to the present embodiment, for example, not only the information indicating which store each expense is generated at which store, but also the item name of each deposit and the business partner of the store are simultaneously specified. be able to. In the example of the journal data 106h of FIG. 3, the subject name associated with the debit main amount “10,000 yen”, which is the expense, is the debit subject name “electricity charge”, so the subject name is “electricity charge”. It can be understood that Also, since the business partner associated with the debit main amount “10,000 yen”, which is an expense, is the debit business partner code “S100”, the business partner corresponds to the debit business partner code “S100”. It can be understood that it is electricity.

  Then, according to the journalizing data creation device 100 according to the present embodiment, for example, by using a virtual account, an occurrence department is identified, an occurrence subject is identified based on a summary item, and a journal is automatically counted. it can. In addition, payment processing does not occur because of direct debit, and it is sufficient to record only the journal withdrawals from the deposit account.

[4. Other embodiments]
The present invention may be practiced in various different embodiments within the scope of the technical idea described in the claims in addition to the embodiments described above.

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

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

  Further, with regard to the journal data creation device 100, each component in the drawing is functionally conceptual, and does not necessarily have to be physically configured as illustrated.

  For example, all or any part of the processing functions of the journal data generation apparatus 100, in particular each processing function performed by the control unit, are realized by a CPU and a program interpreted and executed by the CPU. May also be implemented as wired logic hardware. The program is stored in a non-temporary computer-readable recording medium that includes programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment, and development data is created as necessary. The device 100 is mechanically read. 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). The computer program is executed by being loaded into the RAM, and cooperates with the CPU to configure the control unit.

  Also, this computer program may be stored in an application program server connected to the journal data generation device 100 via any network, and all or part of the computer program may be downloaded as necessary. It is.

  Further, the program for executing the processing described in the present embodiment may be stored in a non-temporary computer readable recording medium, or may be configured as a program product. Here, the "recording medium" means a memory card, a universal serial bus (USB) memory, a secure digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an erasable programmable read only memory (EPROM), and an EEPROM (registration). Trademarks (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Blu-ray (registered trademark) Disc etc. Any "portable physical media It is intended to include.

  The “program” is a data processing method described in any language or description method, and may be in any format such as source code or binary code. Note that the “program” is not necessarily limited to one that is configured in a single way, and achieves its function in cooperation with a separate program represented by a plurality of modules or libraries or a separate program represented by the OS. Including things. In addition, as a specific configuration and reading procedure for reading the recording medium in each device shown in the embodiment, an installation procedure after reading, and the like, a known configuration and procedure can be used.

  The various databases and the like stored in the storage unit are storage devices such as RAM, memory devices such as ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, etc. Stores programs, tables, databases, files for web pages, etc.

  In addition, the journal data creation device 100 may be configured as an information processing device such as a known personal computer or a work station, 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 mounting software (including a program or data) that causes the device to realize the processing described in the present embodiment.

  Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them may be functionally or physically in any unit in accordance with various additions or according to functional load. It can be distributed and integrated. That is, the embodiments described above may be implemented in any combination, and the embodiments may be implemented selectively.

  The present invention is useful in all industries and industries, but is particularly useful in the multi-store industry.

100 Journal data creation device 102 Control unit
102a Store code acquisition department
102b Journal data creation department
102c Journal data creation unit 104 Communication interface unit 106 Storage unit
106a deposit and withdrawal statement data
106b Settlement account master
106c cost item master
106d vendor master
106e Store Master
106f Deposit and withdrawal data linking master
106g Master tied after direct debit data
106h Journal data 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (5)

A journal data creation apparatus comprising a control unit and a storage unit, wherein
The storage unit
Deposit / withdrawal statement data including a virtual account number for identifying a virtual account's account number and a deposit / withdrawal amount for the virtual account;
A settlement account master including the virtual account number and a settlement account code corresponding to the virtual account number;
A deposit / withdrawal data linkage master including the settlement account code and a store code for identifying a store having the virtual account;
Is stored,
The control unit
The settlement account code corresponding to the virtual account number included in the deposit and withdrawal statement data is acquired with reference to the settlement account master, and the acquisition is further referenced with reference to the deposit and withdrawal data connection master. Store code obtaining means for obtaining the store code associated with the payment account code,
A journalizing source data creating unit that creates journalizing source data including the deposit and withdrawal amount included in the deposit and withdrawal details data and the store code acquired by the store code acquisition unit;
Journal data creation means for creating journal data including the deposit amount and the store code included in the journal source data;
To provide
Journal data creation device characterized by. The storage unit further stores an expense item master including an item name for the deposit and withdrawal amount and an expense item code corresponding to the item name,
The deposit / withdrawal detailed data further includes a character representing the content of the deposit / withdrawal amount,
The deposit and withdrawal data linking master further includes the cost code and a linking character corresponding to the character;
The store code acquisition unit
The settlement account code corresponding to the virtual account number included in the deposit and withdrawal statement data is acquired with reference to the settlement account master, and the acquisition is further referenced with reference to the deposit and withdrawal data connection master. Acquiring the shop code and the cost item code linked to the linked settlement character corresponding to the payment account code and the character included in the deposit and withdrawal details data;
The journal entry source data creation means
The journal entry data including the deposit and withdrawal amount included in the deposit and withdrawal details data, the store code acquired by the store code acquiring means, and the expense item code is created;
The journal data creation means is
The item name associated with the item code included in the journal data is acquired with reference to the item master, and the journal includes the acquired item name, the amount of money included in the data of the journal, and the store code. Create data,
The journalized data creation device according to claim 1, characterized in that: The deposit / withdrawal data linkage master further includes a destination code for identifying a customer of the store,
The store code acquisition unit
The settlement account code corresponding to the virtual account number included in the deposit and withdrawal statement data is acquired with reference to the settlement account master, and the acquisition is further referenced with reference to the deposit and withdrawal data connection master. Acquiring the store code, the expense item code, and the destination code associated with the settlement account code and the association character corresponding to the character included in the deposit and withdrawal details data;
The journal entry source data creation means
The journal entry data including the deposit and withdrawal amount included in the deposit and withdrawal details data, the store code acquired by the store code acquisition means, the expense item code, and the destination code is created.
The journal data creation means is
The item name associated with the item code included in the journal data is acquired with reference to the item master, and the acquired item name and the amount of payment included in the data, the store code, and the destination are included in the acquired item data. Create journal data including code,
The journalized data creation device according to claim 2, characterized in that: A method of generating journal data, which is executed by an information processing apparatus including a control unit and a storage unit.
The storage unit
Deposit / withdrawal statement data including a virtual account number for identifying a virtual account's account number and a deposit / withdrawal amount for the virtual account;
A settlement account master including the virtual account number and a settlement account code corresponding to the virtual account number;
A deposit / withdrawal data linkage master including the settlement account code and a store code for identifying a store having the virtual account;
Is stored,
Executed by the controller
The settlement account code corresponding to the virtual account number included in the deposit and withdrawal statement data is acquired with reference to the settlement account master, and the acquisition is further referenced with reference to the deposit and withdrawal data connection master. A store code acquisition step of acquiring the store code linked with the cleared account code;
A journalizing source data creating step for creating journalizing source data including the deposit and withdrawal amount included in the deposit and withdrawal details data and the store code acquired in the store code acquisition step;
A journal data creation step of creating journal data including the deposit amount and the store code included in the journal source data;
Including
Journal data creation method characterized by A journal data generation program for causing an information processing apparatus including a control unit and a storage unit to execute the program.
The storage unit
Deposit / withdrawal statement data including a virtual account number for identifying a virtual account's account number and a deposit / withdrawal amount for the virtual account;
A settlement account master including the virtual account number and a settlement account code corresponding to the virtual account number;
A deposit / withdrawal data linkage master including the settlement account code and a store code for identifying a store having the virtual account;
Is stored,
For the control unit to execute
The settlement account code corresponding to the virtual account number included in the deposit and withdrawal statement data is acquired with reference to the settlement account master, and the acquisition is further referenced with reference to the deposit and withdrawal data connection master. A store code acquisition step of acquiring the store code linked with the cleared account code;
A journalizing source data creating step for creating journalizing source data including the deposit and withdrawal amount included in the deposit and withdrawal details data and the store code acquired in the store code acquisition step;
A journal data creation step of creating journal data including the deposit amount and the store code included in the journal source data;
Including
Journal data creation program characterized by.