Divided revenue recording device, divided revenue recording method, and divided revenue recording program
Patent Information
- Application Number
- JP2022044110
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2022-03-18
- Publication Date
- 2025-02-27
- Estimated Expiration
- 2042-03-18
AI Technical Summary
【0018】 本発明によれば、割賦管理ソリューションにおいて契約単位で全取引状態を管理する取引履歴データが存在するため、その取引状態を参照することで、どのような取引状態の債権においても自動で収益残高の計算を可能とするという効果を奏する。また、本発明によれば、複数の手数料の収益計上情報を1つのテーブルに管理することにより、そのテーブルから自動仕訳を出力する共通ロジックを開発することにより、複数手数料を管理しても全て仕訳パターンの設定のみで自動仕訳出力を可能とするという効果を奏する。また、本発明によれば、役務期間中の月次決算の精度向上につなげることができるという効果を奏する。また、本発明によれば、割賦事業·クレジット事業の各種取引に対応した手数料収益の契約単位での管理をすることができるという効果を奏する。また、本発明によれば、契約の状態等に従った月末締処理による月末繰延利益データの生成を軸に、会計連携処理をすることができるという効果を奏する。
Smart Images

Figure 0007637086000001 
Figure 0007637086000002 
Figure 0007637086000003
Abstract
Description
[Technical field]
[0001] The present invention relates to a divided revenue recording device, a divided revenue recording method, and a divided revenue recording program. [Background technology]
[0002] Patent document 1 discloses a configuration in which end-of-period recorded revenue data including the planned revenue amount on the scheduled repayment date as a deferred revenue amount is created based on scheduled repayment data that sets the planned revenue amount for installment payment receivables, and when the scheduled repayment date arrives, revenue recording journal data is created based on the end-of-period recorded revenue data. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] JP 2020-144696 A Summary of the Invention [Problem to be solved by the invention]
[0004] However, the invention described in Patent Document 1 above had a problem in that in the installment and credit businesses, the monthly revenue recognition of various fees from affiliated stores or customers other than add-on fees could not be captured while taking into account transactions specific to the installment business.
[0005] The present invention has been made in consideration of the above problems, and aims to provide an installment revenue recording device, an installment revenue recording method, and an installment revenue recording program that can record monthly revenue in the form of fees from affiliated stores or fees from customers in an installment business in an equal amount according to the contract period of each contract. [Means for solving the problem]
[0006] In order to solve the above-mentioned problems and achieve the object, the installment revenue recording device of the present invention is a installment revenue recording device equipped with a memory unit and a control unit, wherein the memory unit comprises an account credit memory means for storing end-of-month account credit data set in association with a total customer fee amount and / or a total fee borne by an affiliated store, a first repayment date, and a final repayment date; a transaction history memory means for storing end-of-month transaction history data set in association with a transaction order, a full repayment category, and a customer fee balance or a fee borne by an affiliated store balance; and an accounting pattern master set in association with a fee category, the full repayment category, a credit account item, a debit account item, and an amount type; and the control unit comprises a deferral means for acquiring end-of-month deferred profit data set in association with the fee category, the amount of the amount type, the current month's deferred profit balance, and the full repayment category at the end of the month based on the end-of-month account credit data and the end-of-month transaction history data; and an accounting entry creation means for creating monthly closing accounting data based on the accounting pattern master and the end-of-month deferred profit data.
[0007] In addition, in the split revenue accounting device of the present invention, the journal entry creation means creates the monthly closing journal data based on the journal entry pattern master and the month-end deferred profit data when the amount of the amount type set in the month-end deferred profit data is not 0 yen.
[0008] In addition, in the installment revenue accounting device of the present invention, the deferral means obtains the end-of-month deferred profit data set in association with the fee category, the current month's recorded amount which is the amount of the amount type, the current month's deferred profit balance, and the repayment category at the end of the month, when the repayment category is in progress or normally repaid, based on the end-of-month account loan data and the end-of-month transaction history data.
[0009] In addition, in the split revenue accounting device of the present invention, the journal entry creation means creates the monthly closing journal data that sets the debit and credit account items linked to the amount type of the current month's recorded amount set in the journal entry pattern master, and the current month's recorded amount set in the month-end deferred profit data.
[0010] In addition, in the installment revenue accounting device of the present invention, the deferral means is characterized in that, when the repayment classification is early repayment at the end of the month, based on the end-of-month account loan data and the end-of-month transaction history data in which an early repayment reversal fee is further set, it acquires the fee classification, the current month's recorded amount which is the amount of the amount type, the current month's reversal fee amount which is the early repayment reversal fee, the current month's deferred profit balance, and the end-of-month deferred profit data which is set in association with the repayment classification.
[0011] In addition, in the split revenue accounting device of the present invention, the journal entry creation means creates the monthly closing journal data in which the debit and credit account items linked to the amount type of the current month's accounting amount set in the journal entry pattern master, and the current month's accounting amount set in the month-end deferred profit data, and the monthly closing journal data in which the debit and credit account items linked to the amount type of the current month's return fee set in the journal entry pattern master, and the amount of the current month's return fee set in the month-end deferred profit data are created.
[0012] In addition, in the split revenue recording device of the present invention, the amount recorded for the current month is the amount obtained by subtracting the amount of the current month's refund fee from the customer fee balance or the affiliated store fee balance set in the end-of-month transaction history data of the previous month.
[0013] In addition, in the installment revenue accounting device of the present invention, the deferral means obtains the end-of-month deferred profit data set in association with the fee category, the amount of already recorded cancellation which is the amount of the amount type, the current month's deferred profit balance, and the payment category when the payment category at the end of the month is cancellation, bad debt, or settlement, based on the end-of-month account credit data and the end-of-month transaction history data.
[0014] In addition, in the split revenue accounting device of the present invention, the journal entry creation means creates the monthly closing journal data that sets the debit and credit account items linked to the amount type of the already recorded cancellation set in the journal entry pattern master, and the amount of the already recorded cancellation set in the month-end deferred profit data.
[0015] In addition, in the installment revenue recording device of the present invention, the amount of the already recorded cancellation is the amount obtained by subtracting the current month's deferred profit balance from the customer fee balance or the affiliated store fee balance set in the end-of-month transaction history data of the previous month.
[0016] In addition, the installment revenue accounting method of the present invention is a method for accounting for installment revenue to be executed by a installment revenue accounting device having a memory unit and a control unit, the memory unit comprising an account credit memory means for storing end-of-month account credit data set in association with a total customer fee amount and / or a total fee borne by an affiliated store, a first repayment date, and a final repayment date; a transaction history memory means for storing end-of-month transaction history data set in association with a transaction order, a full repayment category, and a customer fee balance or a fee borne by an affiliated store, and an accounting pattern master set in association with a fee category, the full repayment category, a credit account item, a debit account item, and an amount type; and the control unit is characterized by including a deferral step for acquiring end-of-month deferred profit data set in association with the fee category, the amount of the amount type, the current month's deferred profit balance, and the full repayment category at the end of the month based on the end-of-month account credit data and the end-of-month transaction history data; and a journal entry creation step for creating monthly closing journal entry data based on the journal entry pattern master and the end-of-month deferred profit data.
[0017] In addition, the installment revenue accounting program of the present invention is a installment revenue accounting program to be executed by a installment revenue accounting device having a memory unit and a control unit, the memory unit comprises an account credit memory means for storing end-of-month account credit data set in association with a total customer fee amount and / or a total fee borne by an affiliated store, a first repayment date, and a final repayment date, a transaction history memory means for storing end-of-month transaction history data set in association with a transaction order, a full repayment category, and a customer fee balance or a fee borne by an affiliated store, and an accounting pattern master set in association with a fee category, the full repayment category, a credit account item, a debit account item, and an amount type, and the control unit executes a deferral step of acquiring end-of-month deferred profit data set in association with the fee category, the amount of the amount type, the current month's deferred profit balance, and the full repayment category at the end of the month based on the end-of-month account credit data and the end-of-month transaction history data, and a journal entry creation step of creating monthly closing journal entry data based on the journal entry pattern master and the end-of-month deferred profit data. Effect of the Invention
[0018] According to the present invention, since there is transaction history data that manages all transaction states on a contract basis in the installment management solution, by referring to the transaction state, it is possible to automatically calculate the revenue balance for any transaction state of the receivable. In addition, according to the present invention, by managing revenue recording information for multiple fees in one table, a common logic for automatically outputting journal entries from the table is developed, and it is possible to automatically output journal entries by simply setting a journal entry pattern even if multiple fees are managed. In addition, according to the present invention, it is possible to improve the accuracy of monthly settlement during the service period. In addition, according to the present invention, it is possible to manage fee revenues corresponding to various transactions in the installment business and credit business on a contract basis. In addition, according to the present invention, it is possible to perform accounting linkage processing centered on the generation of month-end deferred profit data by month-end closing processing according to the contract status, etc. [Brief description of the drawings]
[0019] [Figure 1] FIG. 1 is a diagram showing an example of an outline of calculation in this embodiment. [Diagram 2] FIG. 2 is a diagram showing an example of an outline of calculation in this embodiment. [Diagram 3] FIG. 3 is a diagram showing an example of the split profit recording process in this embodiment. [Figure 4] FIG. 4 is a diagram showing an example of journal data in this embodiment. [Diagram 5] FIG. 5 is a diagram showing an example of journal data in this embodiment. [Figure 6] FIG. 6 is a block diagram showing an example of the configuration of the divided profits recording device in this embodiment. [Figure 7] FIG. 7 is a diagram showing an example of the journalizing pattern master in this embodiment. [Figure 8] FIG. 8 is a diagram showing an example of update contents of the month-end deferred profit data in this embodiment. [Figure 9] FIG. 9 is a flowchart showing an example of the process of the split profits recording device in this embodiment. [Figure 10] FIG. 10 is a diagram showing an example of the split profit recording process in this embodiment. [Figure 11] FIG. 11 is a diagram showing an example of the split profit recording process in this embodiment. [Figure 12] FIG. 12 is a diagram showing an example of the split profit recording process in this embodiment. [Figure 13] FIG. 13 is a diagram showing an example of the split profit recording process in this embodiment. [Figure 14] FIG. 14 is a diagram showing an example of the split profit recording process in this embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0020] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to the embodiment.
[0021] [1. Overview] First, an overview of the present invention will be described with reference to Fig. 1 to Fig. 5. Fig. 1 and Fig. 2 are diagrams showing an example of a calculation outline in this embodiment. Fig. 3 is a diagram showing an example of a divisional income recording process in this embodiment. Fig. 4 and Fig. 5 are diagrams showing an example of journal entry data in this embodiment.
[0022] Previously, in the installment business, gross amounts were often manually entered outside the system, making it difficult to manage the monthly revenue posting amount by contract and the deferred profit balance. There were transactions that required the cancellation of revenue posting due to cancellations or bad debts, etc., and it took time and manpower to calculate the revenue posting amount. It was necessary to post revenue, post deferred profit balance or cancel revenue due to cancellations, etc., as well as to perform journal entries under various debit and credit accounts, but closing processing was time-consuming due to manual journal entry entries, and manual errors occurred.
[0023] Therefore, in this embodiment, as a presetting, a journal entry pattern master is prepared as a reference master for automatically creating journal data from a calculation result according to a pre-set journal entry pattern, and as an add-on implementation of a calculation function to the end-of-month closing process, a function is added to calculate the commission amount and the deferred profit balance, etc., and calculate the end-of-month deferred profit data, and as an add-on implementation of an automatic journal entry function to the accounting linkage data creation process, a function is added to create an automatic journal entry from the end-of-month deferred profit data by referring to the journal entry pattern master. Here, as shown in FIG. 1, in the calculation process of the customer fee implemented in the end-of-month closing process in this embodiment, the customer fee is recorded as a deferred customer fee in full at the time of execution of the advance payment, and the amount calculated by these calculation formulas is recorded as profit every month. Also, as shown in FIG. 2, in the calculation process of the member store's fee to be paid implemented in the end-of-month closing process in this embodiment, the member store's fee to be paid is recorded as a deferred member store's fee to be paid at the time of execution of the advance payment, and the amount calculated by these calculation formulas is recorded as profit every month.
[0024] As a result, in this embodiment, it is possible to manage revenue recognition and deferred profit balances by contract, and it is possible to automatically process transactions such as cancellations, early payment, settlements, and bad debt processing that are unique to the installment business. It is also possible to automatically create accounting data from calculation results using accounting patterns that have been set up in advance.
[0025] For example, as shown in FIG. 3, in this embodiment, as transaction processing during each month, the transaction history data and account credit data are updated, and as end-of-month closing processing, the transaction history data and account credit data within the closing month are determined from the transaction date, the saved data at the end of the month (end-of-month transaction history data and end-of-month account credit data) is updated, the end-of-month transaction history data and end-of-month account credit data saved at the end of the month are referenced, the end-of-month deferred profit data at the end of the month is updated, and as accounting linkage data creation processing, journal entry data is automatically created.
[0026] As shown in Fig. 4, in this embodiment, revenue from customer fees is recorded for each contract, and journal data is automatically created. Also, as shown in Fig. 5, in this embodiment, revenue from affiliated store fees is recorded for each contract, and journal data is automatically created. Note that in the case of affiliated store fees, the fees are received from the affiliated store at the time of execution, so revenue is recorded from the month of execution of the advance payment.
[0027] [2. Configuration] An example of the configuration of the divided revenue accounting device 100 according to this embodiment will be described with reference to Figures 6 to 8. Figure 6 is a block diagram showing an example of the configuration of the divided revenue accounting device 100 according to this embodiment.
[0028] As shown in Fig. 6, the divided revenue recording device 100 is a commercially available desktop personal computer. The divided revenue recording device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.
[0029] The divided revenue recording 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 divided revenue recording device 100 are connected to each other so as to be able to communicate with each other via any communication path.
[0030] The communication interface unit 104 communicatively connects the divided revenue recording 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 the communication line. Here, the network 300 has a function of connecting the divided revenue recording device 100 and the server 200 to each other so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).
[0031] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a touch panel), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.
[0032] The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 records computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106. The storage unit 106 includes an account loan database 106a, a transaction history database 106b, and an accounting pattern master 106c.
[0033] The account credit database 106a stores account credit data related to customer fees and / or affiliated store fees. Here, the account credit database 106a may store end-of-month account credit data set in association with the total customer fees and / or total affiliated store fees, the first repayment date, and the final repayment date.
[0034] The transaction history database 106b stores transaction history data of customer fees and / or affiliated store fees. Here, the transaction history database 106b may store end-of-month transaction history data that is linked to transaction order, full payment classification, and customer fee balance or affiliated store fee balance.
[0035] The accounting pattern master 106c is a master in which the debit account items and the credit account items are linked together. Here, the accounting pattern master 106c may be set in which the fee category, the full payment category, the debit account items, the debit account items, and the amount type are linked together.
[0036] Here, an example of the journal entry pattern master 106c in this embodiment will be described with reference to Fig. 7. Fig. 7 is a diagram showing an example of the journal entry pattern master 106c in this embodiment.
[0037] As shown in FIG. 7, in this embodiment, a journalization pattern master 106c is set in advance and serves as the journalization setting for this function.
[0038] Returning to Fig. 6, the control unit 102 is a CPU or the like that comprehensively controls the split revenue recording device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs. The control unit 102 conceptually includes a deferral unit 102a and a journal entry creation unit 102b.
[0039] The deferral unit 102a obtains end-of-month deferred profit data that is set by linking the fee category, the amount of the amount type, the deferred profit balance for the current month, and the full-payment category at the end of the month. Here, the deferral unit 102a may obtain end-of-month deferred profit data that is set by linking the target year and month, the claim type, the fee category, the amount of the amount type, the deferred profit balance for the current month, and the full-payment category at the end of the month based on the end-of-month account loan data and the end-of-month transaction history data. In addition, the deferral unit 102a may obtain end-of-month deferred profit data that is set by linking the target year and month, the claim type, the fee category, the amount of the amount type, the deferred profit balance for the current month, and the full-payment category at the end of the month based on the end-of-month account loan data and the end-of-month transaction history data when the full-payment category is in transaction or normal full-payment at the end of the month. In addition, the deferral unit 102a may obtain end-of-month deferred profit data set by linking the current month's recorded amount, which is the amount of the target year and month, claim type, fee category, and amount type, the amount of the current month's repayment fee, which is the early repayment repayment fee, the current month's deferred profit balance, and the full-payment category, when the full-payment category is cancellation, bad debt, or settlement, based on the end-of-month account loan data and the end-of-month transaction history data, when the full-payment category is early repayment at the end of the month.In addition, the deferral unit 102a may obtain end-of-month deferred profit data set by linking the target year and month, claim type, fee category, and amount type, the amount of the already recorded cancellation, which is the amount of the target year and month, claim type, fee category, and amount type, the current month's deferred profit balance, and the full-payment category, when the full-payment category is cancellation, bad debt, or settlement, based on the end-of-month account loan data and the end-of-month transaction history data.
[0040] Here, an example of the update contents of the month-end deferred profit data in this embodiment will be described with reference to Fig. 8. Fig. 8 is a diagram showing an example of the update contents of the month-end deferred profit data in this embodiment.
[0041] As shown in Fig. 8, in this embodiment, the amount type and / or the current month's deferred profit balance is updated according to the full payment classification. Note that in this embodiment, only the current month's deferred profit balance is set for the first month of advance payment execution.
[0042] Returning to FIG. 6, the journal entry preparation unit 102b prepares the journal entry data. Here, the journal entry preparation unit 102b may prepare monthly closing journal entry data based on the journal entry pattern master 106c and the end-of-month deferred profit data. Furthermore, the journal entry preparation unit 102b may prepare monthly closing journal entry data based on the journal entry pattern master 106c and the end-of-month deferred profit data when the amount of the amount type set in the end-of-month deferred profit data is not 0 yen. Furthermore, the journal entry preparation unit 102b may prepare monthly closing journal entry data that sets the debit and credit account items linked to the amount type of the current month's recorded amount set in the journal entry pattern master 106c and the current month's recorded amount set in the end-of-month deferred profit data. The journal entry preparation unit 102b may also prepare monthly closing journal data in which the debit and credit account items linked to the amount type of the current month's recorded amount set in the journal entry pattern master 106c, the current month's recorded amount set in the end-of-month deferred profit data, and the debit and credit account items linked to the amount type of the current month's return fee set in the journal entry pattern master 106c, and the amount of the current month's return fee set in the end-of-month deferred profit data are set. Here, the current month's recorded amount may be the amount obtained by subtracting the amount of the current month's return fee from the customer fee balance or the affiliated store fee balance set in the end-of-month transaction history data of the previous month. The journal entry preparation unit 102b may also prepare monthly closing journal data in which the debit and credit account items linked to the amount type of the already recorded cancellation set in the journal entry pattern master 106c, and the amount of the already recorded cancellation set in the end-of-month deferred profit data are set. Here, the amount of the already recorded cancellation may be the amount obtained by subtracting the deferred profit balance for the current month from the customer fee balance or the affiliated store fee balance set in the transaction history data at the end of the previous month.
[0043] [3. Specific Examples] A specific example of this embodiment will be described with reference to FIGS.
[0044] [Divided revenue recognition processing] An example of the divided profits accounting process in this embodiment will now be described with reference to Fig. 9. Fig. 9 is a flow chart showing an example of the process of the divided profits accounting device 100 in this embodiment.
[0045] As shown in FIG. 9, the deferral unit 102a determines whether the end of the month has arrived (step SA-1).
[0046] If the deferral unit 102a determines that the end of the month has not yet arrived (step SA-1: No), the deferral unit 102a waits for a predetermined time and then shifts the process to step SA-1.
[0047] On the other hand, if the deferral unit 102a determines that the end of the month has arrived (step SA-1: Yes), it shifts the process to step SA-2.
[0048] Then, the deferral unit 102a acquires end-of-month deferred profit data that is set by linking the target year and month, claim type, fee category, amount by amount type, current month's deferred profit balance, and full repayment category based on the end-of-month account loan data stored in the account loan database 106a and the end-of-month transaction history data stored in the transaction history database 106b (step SA-2).
[0049] Then, the journal entry preparing unit 102b judges whether the amount of the amount type set in the month-end deferred profit data is 0 yen (step SA-3).
[0050] Then, when the journal entry preparing unit 102b determines that the amount of the amount type set in the month-end deferred profit data is 0 yen (step SA-3: Yes), it shifts the process to step SA-1.
[0051] On the other hand, if the journal entry preparation unit 102b determines that the amount of the amount type set in the month-end deferred profit data is not 0 yen (step SA-3: No), it shifts the process to step SA-4.
[0052] Then, the journal entry preparation unit 102b prepares monthly closing journal data based on the journal entry pattern master 106c and the end-of-month deferred profit data (step SA-4).
[0053] Then, the deferral unit 102a judges whether or not there is a current month deferred profit balance set in the end-of-month deferred profit data (step SA-5).
[0054] If the deferral unit 102a determines that there is a current month deferred profit balance set in the end-of-month deferred profit data (step SA-5: Yes), it shifts the process to step SA-1.
[0055] On the other hand, if the deferral unit 102a determines that there is no current month deferred profit balance set in the end-of-month deferred profit data (step SA-5: No), the process ends.
[0056] Here, an example of the split profit recording process in this embodiment will be described with reference to Figures 10 to 14. Figures 10 to 14 are diagrams showing an example of the split profit recording process in this embodiment.
[0057] 10, at the end of the month in which the customer fees are paid on advance in this embodiment, as the end-of-month closing process, the first repayment month has not yet arrived, so there is no amount recorded for the month (note that in the case of merchant fees, calculations are made from the month in which the advance is made), and since the paid-off classification is "100: in progress", it is processed as an in-transaction receivable.And, as shown in FIG 10, at the end of the month in which the customer fees are paid on advance in this embodiment, as the accounting linkage data creation process, all items set in the amount column ID of the journal entry pattern master 106c are 0 yen, so no journal entry is made.
[0058] Then, as shown in Fig. 11, at the end of the month after the first repayment month of the customer fee in this embodiment, the amount to be recorded for that month is calculated as the end-of-month closing process (the calculation outline in this embodiment shown in Fig. 1 is referenced as the calculation formula), and since the full repayment classification is "100: in transaction", it is processed as an in-transaction receivable. Then, as shown in Fig. 11, at the end of the month after the first repayment month of the customer fee in this embodiment, an automatic journal entry is created as the accounting linkage data creation process if the receivable type matches, the fee classification matches, the full repayment classification is between the full repayment classification start and the full repayment classification end, and the amount is not 0 yen.
[0059] As shown in Fig. 12, at the end of the month for the final payment of customer fees in this embodiment, the previous month's deferred balance is recorded in full as a month-end closing process, and since the full payment classification is "101: Normal full payment," it is treated as a paid-up debt. As shown in Fig. 12, at the end of the month for the final payment of customer fees in this embodiment, an automatic journal entry is created as an accounting linkage data creation process.
[0060] As shown in Fig. 13, at the end of the month when customer fees are paid off early in this embodiment (early payment in August in Fig. 13), the refund fee is obtained from the transaction history data at the end of the month as a month-end closing process, and the refund fee is taken into account in the calculation (current month's recorded amount = previous month's deferred profit balance - current month's refund fee). Then, as shown in Fig. 13, at the end of the month when customer fees are paid off early in this embodiment, an automatic journal entry is created as an accounting linkage data creation process.
[0061] Also, as shown in FIG. 14, at the end of the month when the customer fee is cancelled, written off, or settled (August cancellation in FIG. 14), in this embodiment, if the revenue recording amount exceeds the fee amount actually collected from the customer, the cancellation amount of the recorded revenue is calculated as the end-of-month closing process. That is, as shown in FIG. 14, in this embodiment, in July 2021, only 2,400 yen was actually received from the customer, but 4,000 yen was recorded as profit too much, so the unrecorded amount is cancelled, and 4,000-2,400=1,600 yen is set as the cancellation amount. And, as shown in FIG. 14, at the end of the month when the August cancellation is made in this embodiment, an automatic journal entry is created as the accounting linkage data creation process.
[0062] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to goals 8 and 9 of the SDGs.
[0063] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.
[0064] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.
[0065] 5. Other embodiments The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.
[0066] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.
[0067] In addition, the processing procedures, control procedures, specific names, registered data for each process, information including parameters such as search conditions, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.
[0068] Moreover, with regard to the divided profit recording device 100, the components shown in the figures are merely functional concepts, and the device does not necessarily have to be physically configured as shown in the figures.
[0069] For example, the processing functions of the divided revenue recording device 100, particularly the processing functions performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the divided revenue recording device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form a control unit.
[0070] In addition, this computer program may be stored in an application program server connected to the split revenue recording device 100 via any network, and it is also possible to download all or a part of it as needed.
[0071] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.
[0072] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a configuration that is distributed as a plurality of modules or libraries, and a program that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in this embodiment, as well as the installation procedure after reading, may use well-known configurations and procedures.
[0073] The various databases etc. stored in the memory unit 106 are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files etc. used for various processes and providing websites.
[0074] The split revenue recording device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The split revenue recording device 100 may be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.
[0075] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]
[0076] The present invention is useful in the financial industry, such as the installment business and the credit business. [Explanation of symbols]
[0077] 100 Split Revenue Recording Device 102 Control section 102a Deferral Section 102b Journal entry preparation department 104 Communication interface section 106 Storage section 106a Account Loan Database 106b Transaction History Database 106c Journal entry pattern master 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network
Claims
1. A divided profit recording device including a memory unit and a control unit, The storage unit is an account credit storage means for storing end-of-month account credit data set by linking the total customer fee amount and / or the total fee amount borne by the affiliated store, the first repayment date, and the final repayment date; a transaction history storage means for storing end-of-month transaction history data that is linked to a transaction order, a payment completion classification, and a customer fee balance or a member store fee balance; An accounting pattern master that links and sets the fee category, the full payment category, the credit account item, the debit account item, and the amount type; an update setting storage means for storing update setting data of the amount of each amount type set in the end-of-month deferred profit data and the current month's deferred profit balance according to the payment completion classification; Equipped with The control unit is a deferral means for determining, at the end of the month, the fee category according to the customer fee balance or the affiliated store fee balance set in the end-of-month transaction history data based on the end-of-month account credit data and the end-of-month transaction history data, setting equal amounts for the period from the first repayment month to the final repayment month of the customer fee balance or the affiliated store fee balance as amounts for the amount types in accordance with the update setting data, setting a current month's deferred profit balance according to the customer fee balance or the affiliated store fee balance for the current month, and acquiring the end-of-month deferred profit data for the current month set by linking the fee category, the amount of the amount type, the current month's deferred profit balance, and the full repayment category; A journal entry creating means for creating monthly closing journal entry data based on the journal entry pattern master and the end-of-month deferred profit data; A split revenue recording device comprising:
2. The journal entry creation means includes: The split revenue accounting device described in claim 1, characterized in that if the amount of the amount type set in the month-end deferred profit data is not 0 yen based on the accounting pattern master and the month-end deferred profit data, the monthly closing accounting data is created.
3. The deferral means comprises:
2. The split revenue recording device according to claim 1, further comprising: a fee category according to the customer fee balance or the affiliated store fee balance set in the end-of-month transaction history data when the repayment classification at the end of the month is in progress or normally paid off based on the end-of-month account loan data and the end-of-month transaction history data; a fee category according to the customer fee balance or the affiliated store fee balance set in the end-of-month transaction history data according to the update setting data, an equal amount according to the period from the first repayment month to the final repayment month of the customer fee balance or the affiliated store fee balance, and a current month's deferred profit balance according to the customer fee balance or the affiliated store fee balance for the current month; and a fee category according to the fee category, an amount according to the amount of the amount type according to the current month's recorded amount, which is the amount of the amount type, the current month's deferred profit balance, and a month-end deferred profit data for the current month set in association with the fee category, the amount of the amount type, the current month's deferred profit balance, and the repayment classification.
4. The journal entry creation means includes: The split revenue accounting device described in claim 3, characterized in that the monthly closing accounting data is created by setting the debit and credit account items linked to the amount type of the current month's recorded amount set in the accounting pattern master, and the current month's recorded amount set in the month-end deferred profit data.
5. The deferral means comprises: and, based on the end-of-month account loan data and the end-of-month transaction history data in which an early repayment reversal fee is further set, if the repayment classification at the end of the month is early repayment, the fee classification is identified according to the customer fee balance or the affiliated store fee balance set in the end-of-month transaction history data, an amount of the amount type is set from the early repayment reversal fee in accordance with the update setting data, the current month's deferred profit balance is set according to the customer fee balance or the affiliated store fee balance for the current month, and the fee classification, the current month's recorded amount which is the amount of the amount type, and the amount of the current month's reversal fee which is the early repayment reversal fee, the current month's deferred profit balance, and the end-of-month deferred profit data for the current month which is set in association with the early repayment classification.
6. The journal entry creation means includes: The split revenue accounting device of claim 5, characterized in that it creates monthly closing accounting data in which the debit and credit account items linked to the amount type of the current month's recorded amount set in the accounting pattern master, and the current month's recorded amount set in the end-of-month deferred profit data, and the monthly closing accounting data in which the debit and credit account items linked to the amount type of the current month's return fee set in the accounting pattern master, and the amount of the current month's return fee set in the end-of-month deferred profit data.
7. The amount recorded for the current month is: The split revenue recording device according to claim 5 or 6, characterized in that the amount is the customer fee balance or the affiliated store fee balance set in the end-of-month transaction history data of the previous month minus the amount of the current month's refund fee.
8. The deferral means comprises: The split revenue recording device of claim 1 further comprises: based on the end-of-month account credit data and the end-of-month transaction history data, if the full repayment classification at the end of the month is cancellation, bad debt, or settlement, the fee classification is identified according to the customer fee balance or the affiliated store fee balance set in the end-of-month transaction history data, an amount of the amount type is set from the customer fee balance or the affiliated store fee balance in accordance with the update setting data, the current month's deferred profit balance is set according to the customer fee balance or the affiliated store fee balance for the current month, and the end-of-month deferred profit data for the current month is set in association with the fee classification, the amount of the amount type that is already recorded as a cancellation, the current month's deferred profit balance, and the full repayment classification.
9. The journal entry creation means includes: The split revenue accounting device as described in claim 8, characterized in that the monthly closing accounting data is created by setting the debit and credit account items linked to the amount type of the already recorded cancellation set in the accounting pattern master, and the amount of the already recorded cancellation set in the month-end deferred profit data.
10. The amount of the previously recorded cancellation is as follows: The split revenue recording device according to claim 8 or 9, characterized in that the amount is the customer fee balance or the affiliated store fee balance set in the end-of-month transaction history data of the previous month minus the current month's deferred profit balance.
11. A split revenue recording method to be executed by a split revenue recording device having a memory unit and a control unit, The storage unit is an account credit storage means for storing end-of-month account credit data set by linking the total customer fee amount and / or the total fee amount borne by the affiliated store, the first repayment date, and the final repayment date; a transaction history storage means for storing end-of-month transaction history data that is linked to a transaction order, a payment completion classification, and a customer fee balance or a member store fee balance; An accounting pattern master that links and sets the fee category, the full payment category, the credit account item, the debit account item, and the amount type; an update setting storage means for storing update setting data of the amount of each amount type set in the end-of-month deferred profit data and the current month's deferred profit balance according to the payment completion classification; Equipped with The control unit executes a deferral step of identifying the fee category according to the customer fee balance or the merchant fee balance set in the month-end transaction history data based on the month-end account credit data and the month-end transaction history data at the end of the month, setting equal amounts of the customer fee balance or the merchant fee balance according to the period from the first repayment month to the final repayment month as the amounts of the amount types in accordance with the update setting data, setting a current month's deferred profit balance according to the customer fee balance or the merchant fee balance for the current month, and acquiring the month-end deferred profit data for the current month set by linking the fee category, the amount of the amount type, the current month's deferred profit balance, and the full repayment category; A journal entry creation step of creating monthly closing journal entry data based on the journal entry pattern master and the month-end deferred profit data; A method for recording split revenue, comprising:
12. A divided income recording program for causing a divided income recording device having a memory unit and a control unit to execute the divided income recording program, The storage unit is an account credit storage means for storing end-of-month account credit data set by linking the total customer fee amount and / or the total fee amount borne by the affiliated store, the first repayment date, and the final repayment date; a transaction history storage means for storing end-of-month transaction history data that is linked to a transaction order, a payment completion classification, and a customer fee balance or a member store fee balance; An accounting pattern master that links and sets the fee category, the full payment category, the credit account item, the debit account item, and the amount type; an update setting storage means for storing update setting data of the amount of each amount type set in the end-of-month deferred profit data and the current month's deferred profit balance according to the payment completion classification; Equipped with In the control unit, a deferral step of identifying the fee category according to the customer fee balance or the merchant fee balance set in the month-end transaction history data based on the month-end account credit data and the month-end transaction history data at the end of the month, setting equal amounts of the customer fee balance or the merchant fee balance according to the period from the first repayment month to the final repayment month as the amounts of the amount types in accordance with the update setting data, setting a current month's deferred profit balance according to the customer fee balance or the merchant fee balance for the current month, and acquiring the month-end deferred profit data for the current month set by linking the fee category, the amount of the amount type, the current month's deferred profit balance, and the full repayment category; A journal entry creation step of creating monthly closing journal entry data based on the journal entry pattern master and the month-end deferred profit data; A split revenue recording program to implement the above.
Citation Information
Patent Citations
Borrowing data creation device and borrowing data creation program
JP2004272304A
Accounting processing device, accounting processing method, and accounting processing program
JP2020046868A
Profit journalization device, profit journalization method, and profit journalization program
JP2020144696A