Accounts Receivable Management Device, Accounts Receivable Management Method, and Accounts Receivable Management Program

The sales claim management apparatus addresses the complexity of managing accounts receivable by creating separate journal entries for different settlement and collection methods, enhancing financial reporting and processing efficiency.

JP7701398B2Active Publication Date: 2025-07-01OBIC CO LTD
View PDF 3 Cites 0 Cited by

Patent Information

Application Number
JP2023052275
Authority / Receiving Office
JP · JP
Patent Type
Patents
Current Assignee / Owner
Filing Date
2023-03-28
Publication Date
2025-07-01
Estimated Expiration
2043-03-28

AI Technical Summary

Technical Problem

Existing accounts receivable management systems struggle to create separate journal entries for different settlement and collection methods, complicating financial reporting when total sales amounts and billed amounts differ.

Method used

A sales claim management apparatus with a storage unit and control unit that associates currency types with settlement and collection methods, allowing for the creation of separate journal entries based on sales data, including transfer and sales journal entries, and managing cash surpluses or deficits.

Benefits of technology

Enables efficient management of accounts receivable by settlement and collection methods, simplifying financial accounting and improving processing efficiency, especially in multi-store enterprises.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 0007701398000001
    Figure 0007701398000001
  • Figure 0007701398000002
    Figure 0007701398000002
  • Figure 0007701398000003
    Figure 0007701398000003
Patent Text Reader

Abstract

To provide a sales credit management device, a sales credit management method, and a sales credit management program capable of creating sales itemization by an adjustment method, a recovery method at confirmation of a daily report when no difference exists between a total amount and a claimed amount for individual sales at a shop.SOLUTION: Sales data is acquired setting a sales amount in slip units for a shop on a sales day, a total sales amount for the shop on the sales date is calculated on the basis of sales data after finish of business for the shop, a claimed amount by denomination for the shop on the sales date and shop sales daily report data setting a total amount of claimed amount is acquired, and transfer itemization data is created for the claimed amount by denomination for the shop on the sales date with a debit account title as a transfer destination account title on the basis of the denomination master and the shop sales daily report data when there is no difference between the sales amount and the total amount.SELECTED DRAWING: Figure 1
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to an accounts receivable management device, an accounts receivable management method, and an accounts receivable management program.

Background Art

[0002] Patent Document 1 discloses a configuration in which individual electronic sales data electronically settled by credit cards, debit cards, electronic money, etc. at a store is journalized in chronological order, and the total electronic sales data for each card or other operator is aggregated.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] However, in the invention described in Patent Document 1 above, when a company operating a store records sales, there are multiple settlement methods and collection methods depending on the invoice, so the accounts receivable management has become complicated. However, there has been a problem that journal entries cannot be created separately for each settlement method and collection method when the daily report is finalized.

[0005] The present invention has been made in view of the above problems, and an object of the present invention is to provide an accounts receivable management device, an accounts receivable management method, and an accounts receivable management program that can create sales journal entries separately for each settlement method and collection method when the daily report is finalized when there is no difference between the aggregated amount and the billed amount of individual sales at the store.

Means for Solving the Problems

[0006] In order to solve the above-described problems and achieve the object, a sales claim management apparatus according to the present invention is a sales claim management apparatus including a storage unit and a control unit, wherein the storage unit includes a currency type master in which a currency type indicating a settlement method or a collection method, a creditor, and a transfer destination account item are associated and set, and the control unit includes a sales acquisition unit that acquires sales data in which the sales amount per slip of a store on the sales date is set, and after the business of the store ends, based on the sales data, calculates the total sales amount of the store on the sales date, and acquires store sales daily report data in which the claim amount by currency type of the store on the sales date and the total amount of the claim amount are set, and when there is no difference between the total sales amount and the total amount, based on the currency type master and the store sales daily report data, a journal entry creation unit that creates transfer journal entry data of the claim amount by currency type of the store on the sales date, where the debit account item is the transfer destination account item.

[0007] Further, in the sales claim management apparatus according to the present invention, the store sales daily report acquisition unit further acquires settlement transfer data in which the store, the sales date, the currency type, the claim amount, the creditor, and the transfer destination account item are associated and set, based on the currency type master and the store sales daily report data, and when there is no difference between the total sales amount and the total amount, the journal entry creation unit creates transfer journal entry data of the claim amount by currency type of the store on the sales date, where the debit account item is the transfer destination account item, based on the settlement transfer data.

[0008] Further, in the sales claim management apparatus according to the present invention, the storage unit further includes a transaction classification-based account item master in which transaction account items are set according to transaction classifications, the sales acquisition unit acquires the sales data in which the store, the slip, the sales date, the sales amount, and the transaction classification are associated and set, and the journal entry creation unit further creates sales journal entry data of the sales amount per slip of the store on the sales date, where the credit account item is the transaction account item, based on the transaction classification-based account item master and the sales data.

[0009] Further, in the sales receivables management device according to the present invention, the journal creation means further creates transaction journal data of the store on the sales date based on the transfer journal data and the sales journal data.

[0010] Further, in the sales receivables management device according to the present invention, when there is a difference between the total sales amount and the total amount, the store sales date report acquisition means performs display control to set the cash surplus or deficit of the store on the sales date. When the surplus or deficit amount of the cash surplus or deficit is set, store sales date report data in which the claim amount by currency type, the surplus or deficit amount of the cash surplus or deficit, and the total amount of the store on the sales date are set based on the sales data is acquired.

[0011] Further, in the sales receivables management device according to the present invention, the store sales date report acquisition means further acquires settlement transfer data in which the store, the sales date, the currency type, the claim amount, the payee, and the transfer destination account item are associated and set based on the currency type master and the store sales date report data, and settlement transfer data in which the store, the sales date, the currency type, the surplus or deficit amount, the payee, and the transfer destination account item are associated and set. The journal creation means further creates transfer journal data of the claim amount by currency type of the store on the sales date, in which the debit account item is the transfer destination account item, and transfer journal data of the surplus or deficit amount of the store on the sales date, in which the debit account item is the transfer destination account item, based on the settlement transfer data.

[0012] Further, in the sales receivables management device according to the present invention, when the currency type set in the store sales date report data is a collection agency and there is an incoming payment from the payee who is the collection agency, the journal creation means creates collection agency journal data of the incoming payment amount from the payee, in which the credit account item is the transfer destination account item.

[0013] In the accounts receivable management device according to the present invention, when the currency type set in the journal entry creation means is a receipt from a commercial facility and there is a receipt from the commercial facility, the journal entry data for the amount received from the commercial facility, where the credit account is the transfer destination account, is created.

[0014] In the accounts receivable management device according to the present invention, the sales journal entry data is characterized in that the debit account is a temporary account, and the transfer journal entry data is characterized in that the credit account is the temporary account.

[0015] The accounts receivable management method according to the present invention is an accounts receivable management method for causing an accounts receivable management device including a storage unit and a control unit to execute. The storage unit includes a currency type master in which a currency type indicating a settlement method or a collection method, a claimant, and a transfer destination account are associated and set. An accounts receivable acquisition step of acquiring sales data in which the sales amount per slip of a store on the sales date is set, which is executed in the control unit; after the business of the store ends, based on the sales data, the total sales amount of the store on the sales date is calculated, and store sales daily report data in which the claim amount by currency type of the store on the sales date and the total amount of the claim amount are set is acquired; and when there is no difference between the total sales amount and the total amount, based on the currency type master and the store sales daily report data, a journal entry creation step of creating transfer journal entry data for the claim amount by currency type of the store on the sales date, where the debit account is the transfer destination account.

[0016] Moreover, the accounts receivable management program according to the present invention is an accounts receivable management program for causing an accounts receivable management device including a storage unit and a control unit to execute. The storage unit includes a currency type master in which a currency type indicating a settlement method or a collection method, a creditor, and a transfer destination account item are associated and set. In the control unit, a sales acquisition step of acquiring sales data in which the sales amount per slip of a store on the sales date is set, and after the store closes its business, based on the sales data, calculating the total sales amount of the store on the sales date, and acquiring store sales daily report data in which the claim amount by currency type of the store on the sales date and the total amount of the claim amount are set, a store sales daily report acquisition step, and when there is no difference between the total sales amount and the total amount, a journal entry creation step of creating journal entry data for transferring the claim amount by currency type of the store on the sales date, where the debit account item is the transfer destination account item, based on the currency type master and the store sales daily report data, are executed.

Effects of the Invention

[0017] According to the present invention, it is possible to manage accounts receivable by settlement method / collection method at the store, and it is possible to manage accounts receivable in financial accounting in a form that conforms to the actual situation. Further, according to the present invention, it is possible to improve the efficiency of accounts receivable management for multiple currency types in the retail industry and to manage cash according to the store form, so that it is possible to contribute to the improvement of the efficiency of accounts receivable management of multi-store expansion enterprises. Further, according to the present invention, by performing up to journal entry creation, it is possible to contribute to the improvement of the efficiency of accounting processing. Further, according to the present invention, it is possible to generate store daily POS sales data (header / detail), transfer data in daily report input, and journal entry data. Further, according to the present invention, in the retail industry, it is possible to eliminate the complexity of accounts receivable collection operations for multiple settlements.

Brief Description of the Drawings

[0018]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Figure 13

Figure 14

Figure 15

Embodiments for Carrying Out the Invention

[0019] Embodiments of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited by these embodiments.

[0020] [1. Summary] First, the summary of the present invention will be described.

[0021] Conventionally, in companies engaged in store operations, there have been various settlement methods when recording sales, and they have been chased to handle them. Also, conventionally, the methods of managing the incoming payments from stores have diversified. There have been various cases, not only when store employees receive payments, but also when payments are received from commercial facilities that lease the stores, and when entrusting collection agencies.

[0022] Therefore, in the present embodiment, not only a mechanism for recording sales at stores and realizing accounts receivable management by settlement method, but also a mechanism that can perform accounts receivable management according to the incoming payment method from stores is provided.

[0023] That is, in the present embodiment, by performing accounts receivable management according to the settlement method at stores, the accounts receivable for each settlement method can be managed. Also, in the present embodiment, when a cash surplus or deficit occurs at a store, it can be recorded, and the accounts receivable can be increased or decreased, so that the cash surplus or deficit can be recorded, and the input value can be linked with the store cash management. Also, in the present embodiment, since the incoming payment management of the actual store can be performed, the accounts receivable management corresponding to the incoming payments from collection agencies and the accounts receivable management corresponding to the incoming payments from commercial facilities can be performed.

[0024] [2. Configuration] An example of the configuration of the sales accounts receivable management device 100 according to the present embodiment will be described with reference to FIGS. 1 to 5. FIG. 1 is a block diagram showing an example of the configuration of the sales accounts receivable management device 100 in the present embodiment.

[0025] As shown in FIG. 1, the accounts receivable management device 100 is a commercially available desktop personal computer. Note that the accounts receivable management device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer.

[0026] The accounts receivable management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the accounts receivable management device 100 is communicably connected via an arbitrary communication path.

[0027] The communication interface unit 104 communicably connects the accounts receivable management device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of communicably connecting the accounts receivable management device 100 and the server 200 to each other, and is, for example, the Internet or a LAN (Local Area Network).

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

[0029] The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 records a computer program for giving instructions to the CPU (Central Processing Unit) to perform various processes in cooperation with the OS (Operating System). As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc. can be used. The storage unit 106 includes a store master 106a, a denomination master 106b, a store-by-denomination master 106c, a transaction-category-by-accounting-item master 106d, and a transaction database 106e.

[0030] The store master 106a is a master for setting stores. Here, the store master 106a may be set with the store, the creditor's account for sales, and the payee associated therewith.

[0031] Here, referring to FIG. 2, an example of the store master 106a in the present embodiment will be described. FIG. 2 is a diagram showing an example of the store master 106a in the present embodiment.

[0032] As shown in FIG. 2, in the store master 106a in the present embodiment, store data is registered. Since the creditor's account is not determined in the store for the creditor's account, a provisional receipt is set. Here, in the present embodiment, when the payee is not set in the denomination master 106b, the payee may be set from the store master 106a.

[0033] Returning to FIG. 1, the denomination master 106b is a master for setting denominations indicating the settlement method or the collection method. Here, the denomination master 106b may be set with the denomination indicating the settlement method or the collection method, the payee, and the transfer destination accounting item associated therewith.

[0034] Here, referring to FIG. 3, an example of the currency type master 106b in the present embodiment will be described. FIG. 3 is a diagram showing an example of the currency type master 106b in the present embodiment.

[0035] As shown in FIG. 3, in the currency type master 106b in the present embodiment, the currency types to be handled and the method of collecting cash are registered, the cash surplus or deficit is also set, and the claim destination associated with the settlement method is also set. Here, in the present embodiment, when there is no setting of the claim destination, the claim destination of the store master 106a may be set in the data.

[0036] Returning to FIG. 1, the store-specific currency type master 106c is a master that sets the currency types that can be handled for each store.

[0037] Here, referring to FIG. 4, an example of the store-specific currency type master 106c in the present embodiment will be described. FIG. 4 is a diagram showing an example of the store-specific currency type master 106c in the present embodiment.

[0038] As shown in FIG. 4, in the store-specific currency type master 106c in the present embodiment, the currency types that can be handled are set for each store.

[0039] Returning to FIG. 1, the transaction-category-specific accounting item master 106d is a master that sets the transaction accounting items by transaction category.

[0040] Here, referring to FIG. 5, an example of the transaction-category-specific accounting item master 106d in the present embodiment will be described. FIG. 5 is a diagram showing an example of the transaction-category-specific accounting item master 106d in the present embodiment.

[0041] As shown in FIG. 5, in the transaction-category-specific accounting item master 106d in the present embodiment, the accounting items are set for each transaction category (note that when it is desired to separate the accounting items for sales and returns, etc., it is set in the transaction-category-specific accounting item master 106d, but in the present embodiment, it is set not to separate returns).

[0042] Returning to FIG. 1, the transaction database 106e stores transaction data at the store. The transaction data may be sales data, daily store sales report data, journal data, settlement transfer data, or the like.

[0043] The control unit 102 is a CPU or the like that comprehensively controls the accounts receivable management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs defining various processing procedures, and required data, and executes various information processes based on these stored programs. Functionally conceptually, the control unit 102 includes a sales acquisition unit 102a, a daily store sales report acquisition unit 102b, and a journal creation unit 102c.

[0044] The sales acquisition unit 102a acquires the sales data of the store. Here, the sales acquisition unit 102a may acquire sales data in which the sales amount per voucher of the store on the sales date is set. Further, the sales acquisition unit 102a may acquire sales data in which the store, voucher, sales date, sales amount, and transaction classification are associated and set.

[0045] The store sales report acquisition unit 102b acquires the store sales report data of the store on the sales date. Here, after the store's business hours end, the store sales report acquisition unit 102b calculates the total sales amount of the store on the sales date based on the sales data, and may acquire the store sales report data in which the billed amount by currency type of the store on the sales date and the total amount of the billed amount are set. Also, the store sales report acquisition unit 102b may acquire the settlement transfer data in which the store, sales date, currency type, billed amount, billing destination, and transfer destination account item are associated and set based on the currency type master 106b and the store sales report data. Further, when there is a difference between the total sales amount and the total amount, the store sales report acquisition unit 102b performs display control to set the cash surplus or deficit of the store on the sales date, and when the surplus or deficit amount of the cash surplus or deficit is set, based on the sales data, the store sales report data in which the billed amount by currency type of the store on the sales date, the surplus or deficit amount of the cash surplus or deficit, and the total amount are set may be acquired. Also, the store sales report acquisition unit 102b may acquire the settlement transfer data in which the store, sales date, currency type, billed amount, billing destination, and transfer destination account item are associated and set based on the currency type master 106b and the store sales report data, and the settlement transfer data in which the store, sales date, currency type, surplus or deficit amount, billing destination, and transfer destination account item are associated and set.

[0046] The journal entry creation unit 102c creates journal entry data. Here, when there is no difference between the total sales amount and the total amount, the journal entry creation unit 102c may create transfer journal entry data for the billed amount by currency type of the store on the sales date, where the debit account is the transfer destination account, based on the currency master 106b and the store sales daily report data. Also, when there is no difference between the total sales amount and the total amount, the journal entry creation unit 102c may create transfer journal entry data for the billed amount by currency type of the store on the sales date, where the debit account is the transfer destination account, based on the settlement transfer data. Further, the journal entry creation unit 102c may create sales journal entry data for the sales amount in terms of slip units of the store on the sales date, where the credit account is the transaction account, based on the transaction category-specific account master 106d and the sales data. Additionally, the journal entry creation unit 102c may create transaction journal entry data for the store on the sales date based on the transfer journal entry data and the sales journal entry data. Also, the journal entry creation unit 102c may create transfer journal entry data for the billed amount by currency type of the store on the sales date, where the debit account is the transfer destination account, and transfer journal entry data for the excess or deficiency amount of the store on the sales date, where the debit account is the transfer destination account, based on the settlement transfer data. Moreover, when the currency set in the store sales daily report data is a collection agency and there is an incoming payment from the billing destination that is a collection agency, the journal entry creation unit 102c may create collection agency journal entry data for the incoming payment amount from the billing destination, where the credit account is the transfer destination account. Also, when the currency set in the store sales daily report data is an incoming payment from a commercial facility and there is an incoming payment from the commercial facility, the journal entry creation unit 102c may create commercial facility journal entry data for the incoming payment amount from the commercial facility, where the credit account is the transfer destination account. Further, the debit account of the sales journal entry data may be a temporary account. Also, the credit account of the transfer journal entry data may be a temporary account.

[0047] [3. Specific Example] A specific example of this embodiment will be described with reference to FIGS. 6 to 15.

[0048] [Accounts Receivable Management Process] Here, referring to FIG. 6, an example of the sales claim management process in the present embodiment will be described. FIG. 6 is a flowchart showing an example of the process of the sales claim management apparatus 100 in the present embodiment.

[0049] As shown in FIG. 6, the sales acquisition unit 102a acquires sales data in which a store, a slip, a sales date, a sales amount, and a transaction category are associated and set (step SA-1).

[0050] Then, the journal creation unit 102c creates journal data for the sales amount of each store slip on the sales date, where the debit account is a temporary account and the credit account is a transaction account, based on the transaction-category-specific account master 106d and the sales data (step SA-2).

[0051] Then, after the store's business hours, the store sales daily report acquisition unit 102b calculates the total sales amount of the store on the sales date based on the sales data, and acquires store sales daily report data in which the claim amount by currency type and the total amount of the claim amount are set for the store on the sales date (step SA-3).

[0052] Then, the store sales daily report acquisition unit 102b determines whether there is a difference between the total sales amount and the total amount (step SA-4).

[0053] Then, when the store sales daily report acquisition unit 102b determines that there is no difference between the total sales amount and the total amount (step SA-4: No), the process proceeds to step SA-5.

[0054] Then, the store sales daily report acquisition unit 102b acquires settlement transfer data in which a store, a sales date, a currency type, a claim amount, a payee, and a transfer destination account are associated and set based on the currency master 106b and the store sales daily report data (step SA-5).

[0055] Then, based on the transfer settlement data, the journal entry creation unit 102c creates transfer journal entry data for the billed amounts by currency type of the store on the sales date, where the debit account is the transfer destination account and the credit account is the temporary account (step SA-6), and transfers the process to step SA-9.

[0056] On the other hand, when the store sales date report acquisition unit 102b determines that there is a difference between the total sales amount and the total amount (step SA-4: Yes), it transfers the process to step SA-7.

[0057] Then, the store sales date report acquisition unit 102b acquires settlement transfer data in which the store, sales date, currency type, billed amount, billing destination, and transfer destination account are associated and set based on the currency master 106b and the store sales date report data, and settlement transfer data in which the store, sales date, currency type, excess / deficiency amount, billing destination, and transfer destination account are associated and set (step SA-7).

[0058] Then, based on the settlement transfer data, the journal entry creation unit 102c creates transfer journal entry data for the billed amounts by currency type of the store on the sales date, where the debit account is the transfer destination account and the credit account is the temporary account, and transfer journal entry data for the excess / deficiency amounts of the store on the sales date, where the debit account is the transfer destination account and the credit account is the temporary account (step SA-8), and transfers the process to step SA-9.

[0059] Then, based on the transfer journal entry data and the sales journal entry data, the journal entry creation unit 102c creates transaction journal entry data for the store on the sales date (step SA-9) and ends the process.

[0060] Here, with reference to FIGS. 7 to 9, an example (pattern 1) of the accounts receivable management process in the present embodiment will be described. FIGS. 7 to 9 are diagrams showing an example of the accounts receivable management process in the present embodiment.

[0061] As shown in FIG. 7, in the present embodiment, at the time of customer service in the store, sales data is registered in units of one transaction (one slip unit). Note that the sales data registration in the present embodiment may be sales input to the system or data import from a POS (Point Of Sales). And, as shown in FIG. 7, in the present embodiment, from the store set in the sales data, the creditor's account item of the store master 106a is set as the debit account item, the transaction type classification account item master 106d is referred to from the transaction type set in the sales data, and the credit account item is specified.

[0062] And, as shown in FIG. 8, in the present embodiment, at the time of closing the store, registration by settlement method is input to the daily sales report based on journal data, etc., and the settlement method other than cash is transferred to the specified account based on the registered data, the sales amount is totaled from the data of the specified store and sales date from the sales data, and the total amount is displayed as the total sales amount. Here, in the present embodiment, all currency types may be manually input, and all currency types registered in the store-specific currency type master 106c as the currency types that can be handled in the store may be initially displayed with a claim amount of 0 yen. Note that in the present embodiment, each time the claim amount is input, the difference between the total sales amount and the total of the specified transfer amount may be displayed. Also, in the present embodiment, when the difference is other than 0, it is set as not registrable as an error. Also, in the present embodiment, as shown in FIG. 8, at the time of finalizing the daily sales report, a transfer journal is created based on the screen data and each master. Here, in the present embodiment, the transfer destination account item is derived from the account item associated with the currency type set in the currency type master 106b, the claim destination is derived from the currency type set in the currency type master 106b, and if it cannot be derived, it is set from the store master 106a, and the settlement transfer source account item may be set from the creditor's account item associated with the store set in the store master 106a. Thus, in the present embodiment, transfer journal data is created from the settlement transfer data.

[0063] Then, as shown in FIG. 9, in this embodiment, the journal entries regarding the transactions of the day that occurred at the store are finally created, and for future creditor management, the balance management is carried out for the creditor's items. And, as shown in FIG. 9, in this embodiment, when there is a transfer of sales amount from the store staff, the journal entry is registered and the balance of the store cash is reduced.

[0064] Also, with reference to FIGS. 10 and 11, an example (pattern 2) of the accounts receivable management process in this embodiment will be described. FIGS. 10 and 11 are diagrams showing an example of the accounts receivable management process in this embodiment.

[0065] As shown in FIG. 10, in this embodiment, when sales data is registered, originally, a daily report of a total of 800,000 yen should be recorded, but since it does not match the cash in the store, it is registered in the "Cash over / short" column of the currency type column. And, as shown in FIG. 11, in this embodiment, journal entries are created from the sales data and the settlement transfer data. Here, in this embodiment, also in the journal entry data of miscellaneous losses, the debit account and the credit account are derived from the store master 106a or the currency type master 106b in the same way as other currency types.

[0066] Also, with reference to FIGS. 12 and 13, an example (pattern 3: collection agency) of the accounts receivable management process in this embodiment will be described. FIGS. 12 and 13 are diagrams showing an example of the accounts receivable management process in this embodiment.

[0067] As shown in FIG. 12, in this embodiment, when sales data is registered, in the store sales daily report, the amount deposited with the collection agency on that day is registered in the collection agency column. And, as shown in FIG. 13, in this embodiment, journal entries are created from the sales data and the settlement transfer data and are managed as accounts receivable from the collection agency. And, as shown in FIG. 13, in this embodiment, when there is a transfer from the collection agency, the journal entry is registered and the balance of the accounts receivable is reduced.

[0068] Also, with reference to FIGS. 14 and 15, an example of the sales claim management process (Pattern 4: Payment from commercial facilities) in the present embodiment will be described. FIGS. 14 and 15 are diagrams showing an example of the sales claim management process in the present embodiment.

[0069] As shown in FIG. 14, in the present embodiment, when sales data is registered, for stores where there is payment from commercial facilities, all card payments and IC payments, etc. are transferred to the commercial facilities, and finally the amount reported as sales is transferred from the commercial facilities. Therefore, the sales become accounts receivable to the commercial facilities, and the billing destination is derived from the store master 106a. Then, as shown in FIG. 15, in the present embodiment, journal entries are created from the sales data and the settlement transfer data, and are managed as accounts receivable to the billing destination set in the store master 106a. And, as shown in FIG. 15, in the present embodiment, when there is a transfer from the commercial facility at a later date, a journal entry is registered and the balance of the accounts receivable is reduced.

[0070] [4. Contribution to the Sustainable Development Goals (SDGs) Led by the United Nations] With the present embodiment, it is possible to contribute to promoting business efficiency and appropriate business judgment of the enterprise, so it is possible to contribute to Goals 8 and 9 of the SDGs.

[0071] Also, with the present embodiment, it is possible to contribute to reducing waste loss and promoting paperless and digitization, so it is possible to contribute to Goals 12, 13, and 15 of the SDGs.

[0072] Also, with the present embodiment, it is possible to contribute to strengthening control and governance, so it is possible to contribute to Goal 16 of the SDGs.

[0073] [5. Other Embodiments] The present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims, in addition to the above-described embodiments.

[0074] For example, among the various processes described in the embodiments, all or part of the processes described as being automatically performed can be manually performed, or all or part of the processes described as being manually performed can be automatically performed by a known method.

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

[0076] Also, regarding the accounts receivable management apparatus 100, each of the illustrated components is a functional concept, and it is not necessarily physically configured as shown in the drawings.

[0077] For example, regarding the processing functions provided by the accounts receivable management apparatus 100, particularly each processing function performed by the control unit 102, all or any part of them may be realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. Note that the program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing an information processing apparatus to execute the processes described in this embodiment, and is mechanically read by the accounts receivable management apparatus 100 as necessary. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS to perform various processes is recorded. This computer program is executed by being loaded into the RAM and constitutes the control unit in cooperation with the CPU.

[0078] In addition, this computer program may be stored in an application program server connected to the accounts receivable management apparatus 100 via an arbitrary network, and all or part of it can be downloaded as necessary.

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

[0080] Also, the "program" is a data processing method described in any language or description method, and may be in the form of source code or binary code, etc. Note that the "program" is not necessarily limited to being configured as a single entity, and also includes those that are distributed as a plurality of modules or libraries, or those that achieve their functions in cooperation with another program represented by an OS. Note that for the specific configuration, reading procedure, and installation procedure after reading for reading the recording medium in each device shown in this embodiment, well-known configurations and procedures can be used.

[0081] The various databases and the like stored in the storage unit 106 are storage means such as a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0082] Further, the accounts receivable management 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 an arbitrary peripheral device is connected. Further, the accounts receivable management device 100 may be realized by installing software (including a program or data, etc.) for realizing the processes described in the present embodiment in the device.

[0083] Furthermore, the specific form of the distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in arbitrary units according to various additions or according to the function load. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Industrial Applicability

[0084] The present invention is useful in industries such as the distribution retail industry and a wide range of retail industries with multi-store deployments including the food retail industry.

Explanation of Signs

[0085] 100 Accounts receivable management device 102 Control unit 102a Sales acquisition unit 102b Store daily sales report acquisition unit 102c Journal entry creation unit 104 Communication interface unit 106 Storage unit 106a Store master 106b Currency type master 106c Store-by-currency type master 106d Accounting item master by transaction classification 106e Transaction database 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims

1. An accounts receivable management device comprising a memory unit and a control unit, wherein the memory unit comprises a currency master that associates and sets a currency indicating a settlement method or a collection method, a claimant, and a transfer destination account item; and the control unit has a sales acquisition means for acquiring sales data in which the sales amount per slip of a store on the sales date is set; after the business of the store ends, based on the sales data, calculates the total sales amount of the store on the sales date, and acquires store sales daily report data in which the claim amount by currency type of the store on the sales date and the total amount of the claim amount are set, the store sales daily report acquisition means; when there is no difference between the total sales amount and the total amount, based on the currency master and the store sales daily report data, a journal entry creation means for creating journal entry data for the claim amount by currency type of the store on the sales date, where the debit account item is the transfer destination account item; An accounts receivable management device characterized by comprising the above.

2. The store sales daily report acquisition means further acquires settlement transfer data that associates and sets the store, the sales date, the currency, the claim amount, the claimant, and the transfer destination account item based on the currency master and the store sales daily report data; the journal entry creation means when there is no difference between the total sales amount and the total amount, based on the settlement transfer data, creates journal entry data for the claim amount by currency type of the store on the sales date, where the debit account item is the transfer destination account item. The accounts receivable management device according to claim 1.

3. The memory unit further comprises a transaction account item master that sets transaction account items by transaction classification; and the sales acquisition means acquires the sales data that associates and sets the store, the slip, the sales date, the sales amount, and the transaction classification; the journal entry creation means further creates sales journal entry data for the sales amount per slip of the store on the sales date, where the credit account item is the transaction account item, based on the transaction account item master by transaction classification and the sales data. The accounts receivable management device according to claim 1.

4. The journal entry creation means further creates transaction journal entry data for the store on the sales date based on the transfer journal entry data and the sales journal entry data. The accounts receivable management device according to claim 3.

5. The store sales daily report acquisition means further, when there is a difference between the total sales amount and the total amount, perform display control to set the cash surplus / deficit of the store on the sales date, and when the surplus / deficit amount of the cash surplus / deficit is set, based on the sales data, obtain store sales daily report data in which the claim amount by currency type, the surplus / deficit amount of the cash surplus / deficit, and the total amount of the store on the sales date are set. The sales claim management device according to claim 1, characterized in that

6. The store sales daily report acquisition means further, based on the currency type master and the store sales daily report data, obtain settlement transfer data in which the store, the sales date, the currency type, the claim amount, the payee, and the transfer destination account item are associated and set, and settlement transfer data in which the store, the sales date, the currency type, the surplus / deficit amount, the payee, and the transfer destination account item are associated and set, The journal entry creation means further, based on the settlement transfer data, create transfer journal entry data for the claim amount by currency type of the store on the sales date where the debit account item is the transfer destination account item, and transfer journal entry data for the surplus / deficit amount of the store on the sales date where the debit account item is the transfer destination account item. The sales claim management device according to claim 5, characterized in that

7. The journal entry creation means further, when the currency type set in the store sales daily report data is a collection agency and there is an incoming payment from the payee who is the collection agency, create collection agency journal entry data for the incoming payment amount from the payee where the credit account item is the transfer destination account item. The sales claim management device according to claim 4, characterized in that

8. The journal entry creation means further, when the currency type set in the store sales daily report data is an incoming payment from a commercial facility and there is an incoming payment from the commercial facility, create commercial facility journal entry data for the incoming payment amount from the commercial facility where the credit account item is the transfer destination account item. The sales claim management device according to claim 4, characterized in that

9. The sales journal entry data has a debit account item as a temporary account item, The transfer journal entry data is characterized in that the credit account item is the temporary account item. The sales claim management device according to claim 3,

10. A sales claim management method for causing a sales claim management device including a storage unit and a control unit to execute, wherein the storage unit A currency master that associates and sets the currency type indicating the settlement method or collection method, the payee, and the transfer destination account item, is provided, In the control unit, A sales acquisition step of acquiring sales data in which the sales amount per slip of the store on the sales date is set; After the business of the store ends, based on the sales data, calculate the total sales amount of the store on the sales date, and obtain store sales daily report data in which the claim amount by currency type of the store on the sales date and the total amount of the claim amount are set. A store sales daily report acquisition step; When there is no difference between the total sales amount and the total amount, based on the currency master and the store sales daily report data, a journal entry creation step of creating journal entry data for the claim amount by currency type of the store on the sales date, where the debit account item is the transfer destination account item; A sales receivable management method characterized by including the above.

11. A sales receivable management program for causing a sales receivable management device including a storage unit and a control unit to execute, The storage unit A currency master that associates and sets the currency type indicating the settlement method or collection method, the payee, and the transfer destination account item, is provided, In the control unit, A sales acquisition step of acquiring sales data in which the sales amount per slip of the store on the sales date is set; After the business of the store ends, based on the sales data, calculate the total sales amount of the store on the sales date, and obtain store sales daily report data in which the claim amount by currency type of the store on the sales date and the total amount of the claim amount are set. A store sales daily report acquisition step; When there is no difference between the total sales amount and the total amount, based on the currency master and the store sales daily report data, a journal entry creation step of creating journal entry data for the claim amount by currency type of the store on the sales date, where the debit account item is the transfer destination account item; A sales receivable management program for causing the above to be executed.

Citation Information

Patent Citations

  • Proceeds remittance system and proceeds remittance method

    JP2017037608A

  • Store management system and store management method

    JP2021185445A

  • Shop fund management system, fund management method, and program

    JP2023025416A