JP2022101638A - Miscalculation check work support device, miscalculation check work support method, and miscalculation check work support program - Google Patents

Miscalculation check work support device, miscalculation check work support method, and miscalculation check work support program Download PDF

Info

Publication number
JP2022101638A
JP2022101638A JP2022069943A JP2022069943A JP2022101638A JP 2022101638 A JP2022101638 A JP 2022101638A JP 2022069943 A JP2022069943 A JP 2022069943A JP 2022069943 A JP2022069943 A JP 2022069943A JP 2022101638 A JP2022101638 A JP 2022101638A
Authority
JP
Japan
Prior art keywords
amount
data
application
collection
collection schedule
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
JP2022069943A
Other languages
Japanese (ja)
Other versions
JP7250979B2 (en
Inventor
健太 斉藤
Kenta Saito
剛光 上野
Takemitsu Ueno
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Obic Co Ltd
Original Assignee
Obic Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Priority claimed from JP2018101712A external-priority patent/JP7064381B2/en
Application filed by Obic Co Ltd filed Critical Obic Co Ltd
Priority to JP2022069943A priority Critical patent/JP7250979B2/en
Publication of JP2022101638A publication Critical patent/JP2022101638A/en
Application granted granted Critical
Publication of JP7250979B2 publication Critical patent/JP7250979B2/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

PROBLEM TO BE SOLVED: To provide a miscalculation check work support device, a miscalculation check work support method, and a miscalculation check work support program for supporting check work of miscalculation performed after actual reception of money.
SOLUTION: A method includes the steps of: determining whether or not an expected collection amount in collection scheduled data matches a cancellation amount in deposit cancellation data for the same collection scheduled NO; concerning the collection scheduled NO determined to be coincident, cancelling a collection scheduled amount in the collection scheduled data by an amount of money to be canceled in deposit cancellation data; and concerning the collection scheduled NO determined not to be coincident, cancelling a collection scheduled amount in the collection scheduled data by a temporary cancellation amount in the deposit temporary cancellation data when check classification in the deposit temporary cancellation data associated with the collection scheduled NO is "completed".
SELECTED DRAWING: Figure 10
COPYRIGHT: (C)2022,JPO&INPIT

Description

本発明は、違算確認業務支援装置、違算確認業務支援方法および違算確認業務支援プログラムに関する。 The present invention relates to a miscalculation confirmation business support device, a miscalculation confirmation business support method, and a miscalculation confirmation business support program.

特許文献1には、銀行休日が絡んだ最初の売上日から順に日々の売上金の消し込みを行い、違算があった場合には最終日に計上させる方法が開示されている(特許文献1の段落0045参照)。 Patent Document 1 discloses a method in which daily sales are applied in order from the first sales date involving a bank holiday, and if there is a miscalculation, it is recorded on the final day (Patent Document 1). See paragraph 0045).

特開2012-226660号公報Japanese Unexamined Patent Publication No. 2012-226660

このように違算を管理する分野においては、従来、支払通知書(実際の入金前に支払予定額を通知する書面)を受領して経理または営業担当が違算の確認作業を行っていたが、この確認作業の結果はデータ化されていなかったため、後に実際の入金があった際に、改めて違算の確認作業を実施してしまうケースもあり、重複した作業となってしまうという問題があった。また、実際の入金後に違算の確認作業を行うと、月次決算の遅延も発生し得るという問題もあった。 In the field of managing miscalculations in this way, in the past, accounting or sales staff had to receive a payment notice (a document notifying the amount to be paid before the actual payment) and confirm the miscalculation. Since the result of the confirmation work was not converted into data, there was a case that the confirmation work of the miscalculation was carried out again when the actual payment was made later, and there was a problem that the work would be duplicated. In addition, if the confirmation work of the miscalculation is performed after the actual payment, there is a problem that the monthly settlement may be delayed.

本発明は、上記問題点に鑑みてなされたものであって、実際の入金後に行う違算の確認業務を支援できる違算確認業務支援装置、違算確認業務支援方法および違算確認業務支援プログラムを提供することを目的とする。 The present invention has been made in view of the above problems, and provides a miscalculation confirmation work support device, a miscalculation confirmation work support method, and a miscalculation confirmation work support program that can support the miscalculation confirmation work performed after the actual payment. With the goal.

上述した課題を解決し、目的を達成するために、本発明に係る違算確認業務支援装置は、制御部および記憶部を備え、回収予定金額と実際の入金額である実入金額の間での違算の確認業務を支援するための違算確認業務支援装置であって、前記記憶部には、前記回収予定金額を識別するための回収予定識別データと前記回収予定金額とを含む回収予定データと、前記回収予定識別データと仮の入金額である仮入金額と消込可否区分とを含み、当該消込可否区分は、前記回収予定金額を前記仮入金額による自動消込の対象とすることを意味する消込可区分または前記回収予定金額を前記仮入金額による自動消込の対象としないことを意味する消込不可区分である消込可否設定データと、前記回収予定識別データと前記実入金額とを含む入金データと、が格納されており、前記制御部は、同一の前記回収予定識別データについて、前記回収予定データ中の前記回収予定金額と前記入金データ中の前記実入金額とが一致するか否かを判断する判断手段と、前記判断手段で一致すると判断した前記回収予定識別データについて、前記回収予定データ中の前記回収予定金額を前記入金データ中の前記実入金額で消込する第一消込手段と、前記判断手段で一致しないと判断した前記回収予定識別データについて、当該回収予定識別データと紐付く前記消込可否設定データ中の前記消込可否区分が前記消込可区分である場合に、前記回収予定データ中の前記回収予定金額を前記消込可否設定データ中の前記仮入金額で消込する第二消込手段と、を備えること、を特徴とする。 In order to solve the above-mentioned problems and achieve the object, the miscalculation confirmation business support device according to the present invention is provided with a control unit and a storage unit, and is between the estimated collection amount and the actual deposit amount. It is a miscalculation confirmation business support device for supporting the miscalculation confirmation business, and in the storage unit, collection schedule data including the collection schedule identification data for identifying the collection schedule amount and the collection schedule data, and the collection schedule data. The collection schedule identification data, the provisional deposit amount which is a provisional deposit amount, and the application possibility classification are included, and the application possibility classification indicates that the collection schedule amount is subject to automatic application by the provisional deposit amount. Applicability setting data, which is a non-applicable category, which means that the applicable category or the estimated collection amount is not subject to automatic application by the provisional deposit amount, the collection schedule identification data, and the actual entry. The deposit data including the amount of money and the deposit data are stored, and the control unit has the same collection schedule identification data, the collection schedule amount in the collection schedule data and the actual deposit amount in the deposit data. With respect to the determination means for determining whether or not they match and the collection schedule identification data determined to match by the determination means, the collection schedule amount in the collection schedule data is applied by the actual deposit amount in the payment data. With respect to the collection schedule identification data determined to be inconsistent between the first application means to be applied and the collection schedule identification data, the application availability classification in the application availability setting data associated with the collection schedule identification data is applicable. In the case of classification, it is characterized by comprising a second application means for applying the estimated collection amount in the collection schedule data with the provisional deposit amount in the application permission setting data.

また、本発明に係る違算確認業務支援装置は、表示部を更に備え、前記制御部が、前記消込可否設定データ中の前記仮入金額を前記表示部に表示する表示実行手段を更に備えること、を特徴とする。 Further, the miscalculation confirmation business support device according to the present invention further includes a display unit, and the control unit further includes a display execution means for displaying the provisional deposit amount in the application permission setting data on the display unit. , Is characterized.

また、本発明に係る違算確認業務支援装置は、前記仮入金額が、前記回収予定金額の回収先からの支払通知書に記載された支払予定額であること、を特徴とする。 Further, the miscalculation confirmation business support device according to the present invention is characterized in that the provisional deposit amount is the planned payment amount described in the payment notice from the collection destination of the planned collection amount.

また、本発明に係る違算確認業務支援方法は、制御部および記憶部を備える情報処理装置で実行される、回収予定金額と実際の入金額である実入金額の間での違算の確認業務を支援するための違算確認業務支援方法であって、前記記憶部には、前記回収予定金額を識別するための回収予定識別データと前記回収予定金額とを含む回収予定データと、前記回収予定識別データと仮の入金額である仮入金額と消込可否区分とを含み、当該消込可否区分は、前記回収予定金額を前記仮入金額による自動消込の対象とすることを意味する消込可区分または前記回収予定金額を前記仮入金額による自動消込の対象としないことを意味する消込不可区分である消込可否設定データと、前記回収予定識別データと前記実入金額とを含む入金データと、が格納されており、前記制御部で実行される、同一の前記回収予定識別データについて、前記回収予定データ中の前記回収予定金額と前記入金データ中の前記実入金額とが一致するか否かを判断する判断ステップと、前記判断ステップで一致すると判断した前記回収予定識別データについて、前記回収予定データ中の前記回収予定金額を前記入金データ中の前記実入金額で消込する第一消込ステップと、前記判断ステップで一致しないと判断した前記回収予定識別データについて、当該回収予定識別データと紐付く前記消込可否設定データ中の前記消込可否区分が前記消込可区分である場合に、前記回収予定データ中の前記回収予定金額を前記消込可否設定データ中の前記仮入金額で消込する第二消込ステップと、を含むこと、を特徴とする。 Further, the miscalculation confirmation work support method according to the present invention performs a miscalculation confirmation work between the estimated collection amount and the actual deposit amount, which is executed by the information processing apparatus including the control unit and the storage unit. It is a miscalculation confirmation business support method for supporting, and in the storage unit, the collection schedule identification data for identifying the collection schedule identification data, the collection schedule data including the collection schedule amount, and the collection schedule identification data. And the provisional deposit amount, which is the provisional deposit amount, and the application availability category, which means that the expected collection amount is subject to automatic application by the provisional deposit amount. Payment including the application availability setting data, which is a non-applicable category, which means that the category or the scheduled collection amount is not subject to automatic application by the provisional deposit amount, the collection schedule identification data, and the actual deposit amount. With respect to the data and the same collection schedule identification data executed by the control unit, the collection schedule amount in the collection schedule data and the actual payment amount in the payment data match. With respect to the determination step for determining whether or not the data and the collection schedule identification data determined to match in the determination step, the collection schedule amount in the collection schedule data is applied by the actual deposit amount in the payment data. With respect to the collection schedule identification data determined to be inconsistent between the application step and the determination step, the application availability classification in the application availability setting data associated with the collection schedule identification data is the application permission category. In certain cases, it is characterized by including a second application step of applying the estimated collection amount in the collection schedule data with the provisional deposit amount in the application permission / non-appropriate setting data.

また、本発明に係る違算確認業務支援プログラムは、制御部および記憶部を備える情報処理装置に実行させるための、回収予定金額と実際の入金額である実入金額の間での違算の確認業務を支援するための違算確認業務支援プログラムであって、前記記憶部には、前記回収予定金額を識別するための回収予定識別データと前記回収予定金額とを含む回収予定データと、前記回収予定識別データと仮の入金額である仮入金額と消込可否区分とを含み、当該消込可否区分は、前記回収予定金額を前記仮入金額による自動消込の対象とすることを意味する消込可区分または前記回収予定金額を前記仮入金額による自動消込の対象としないことを意味する消込不可区分である消込可否設定データと、前記回収予定識別データと前記実入金額とを含む入金データと、が格納されており、前記制御部に実行させるための、同一の前記回収予定識別データについて、前記回収予定データ中の前記回収予定金額と前記入金データ中の前記実入金額とが一致するか否かを判断する判断ステップと、前記判断ステップで一致すると判断した前記回収予定識別データについて、前記回収予定データ中の前記回収予定金額を前記入金データ中の前記実入金額で消込する第一消込ステップと、前記判断ステップで一致しないと判断した前記回収予定識別データについて、当該回収予定識別データと紐付く前記消込可否設定データ中の前記消込可否区分が前記消込可区分である場合に、前記回収予定データ中の前記回収予定金額を前記消込可否設定データ中の前記仮入金額で消込する第二消込ステップと、を含むこと、を特徴とする。 Further, the miscalculation confirmation work support program according to the present invention is a miscalculation confirmation work between the estimated collection amount and the actual deposit amount, which is to be executed by the information processing apparatus including the control unit and the storage unit. In the storage unit, the collection schedule identification data for identifying the collection schedule identification data, the collection schedule data including the collection schedule amount, and the collection schedule identification are stored in the storage unit. Includes data, provisional deposit amount, which is a provisional deposit amount, and application availability category, which means that the expected collection amount is subject to automatic application by the provisional deposit amount. Includes clearing possibility setting data, which is a non-applicable category, which means that the applicable category or the scheduled collection amount is not subject to automatic application by the provisional deposit amount, the collection schedule identification data, and the actual deposit amount. With respect to the same collection schedule identification data to be executed by the control unit, the payment data and the collection schedule amount in the collection schedule data and the actual payment amount in the payment data are stored. With respect to the determination step for determining whether or not they match and the collection schedule identification data determined to match in the determination step, the collection schedule amount in the collection schedule data is applied by the actual deposit amount in the payment data. With respect to the collection schedule identification data determined to be inconsistent between the first application step to be applied and the collection schedule identification data, the application availability classification in the application availability setting data associated with the collection schedule identification data can be deleted. In the case of classification, it is characterized by including a second application step in which the collection schedule amount in the collection schedule data is applied by the provisional deposit amount in the application availability setting data.

本発明によれば、実際の入金後に行う違算の確認業務を支援できるという効果を奏する。 According to the present invention, there is an effect that it is possible to support the confirmation work of miscalculation performed after the actual payment.

図1は、違算確認業務支援装置の構成の一例を示すブロック図である。FIG. 1 is a block diagram showing an example of the configuration of a miscalculation confirmation business support device. 図2は、従前の違算確認の一例を示す図である。FIG. 2 is a diagram showing an example of the conventional miscalculation confirmation. 図3は、本実施形態に係る違算確認の一例を示す図である。FIG. 3 is a diagram showing an example of miscalculation confirmation according to the present embodiment. 図4は、本実施形態に係る違算確認のフローの一例を示す図である。FIG. 4 is a diagram showing an example of a flow for confirming miscalculation according to the present embodiment. 図5は、回収予定データ、支払通知書および入金仮消込データの一例を示す図である。FIG. 5 is a diagram showing an example of collection schedule data, payment notice, and temporary payment application data. 図6は、支払通知書通りに入金された場合の入金消込データおよび更新された回収予定データの一例を示す図である。FIG. 6 is a diagram showing an example of payment application data and updated collection schedule data when payment is made according to the payment notice. 図7は、請求書通りに入金された場合の入金消込データおよび更新された回収予定データの一例を示す図である。FIG. 7 is a diagram showing an example of payment application data and updated collection schedule data when payment is made according to the invoice. 図8は、支払通知書通りに入金された場合の入金入力画面の一例を示す図である。FIG. 8 is a diagram showing an example of a payment input screen when payment is made according to the payment notice. 図9は、請求書通りに入金された場合の入金入力画面の一例を示す図である。FIG. 9 is a diagram showing an example of a payment input screen when payment is made according to the invoice. 図10は、本実施形態に係る違算確認のフローチャートの一例を示す図である。FIG. 10 is a diagram showing an example of a flowchart for confirming miscalculation according to the present embodiment.

以下に、違算確認業務支援装置、違算確認業務支援方法および違算確認業務支援プログラムの実施形態を、図面に基づいて詳細に説明する。なお、本実施形態により本発明が限定されるものではない。 Hereinafter, embodiments of the miscalculation confirmation work support device, the miscalculation confirmation work support method, and the miscalculation confirmation work support program will be described in detail based on the drawings. The present invention is not limited to the present embodiment.

[1.概要]
従来、支払通知書を受領した際には、経理または営業担当が違算の確認を行っていたが、この確認作業の結果はデータ化されていなかったため、実際に入金があった際に、改めて違算の確認作業を実施してしまうケースもあり、結果として重複した作業となってしまうという問題があった。また、月末の入金後に経理または営業担当が消込作業を実施するため、消込作業が月末に集中してしまい、月次決算の遅延が発生し得るという問題もあった。
[1. Overview]
In the past, when the payment notice was received, the accounting or sales staff confirmed the miscalculation, but since the result of this confirmation work was not converted into data, the miscalculation was made again when the payment was actually made. In some cases, the confirmation work was carried out, and as a result, there was a problem that the work would be duplicated. In addition, since the accounting or sales staff performs the application work after the payment at the end of the month, the application work is concentrated at the end of the month, and there is a problem that the monthly settlement may be delayed.

そこで、本実施形態においては、例えば、請求先からの支払通知書が届いた時点で、仮の入金消込を実施することで、月末の実際の入金後の消込作業の負荷を軽減できるようにした。また、近年においては、支払通知書を送付してくる企業が多くなったため、事前の回収予定に対する違算確認結果をデータ化することで、月次決算の早期化を図ることができる。以下、具体的な構成および動作について説明する。 Therefore, in the present embodiment, for example, when the payment notice from the billing address arrives, the temporary payment application is performed so that the load of the application work after the actual payment at the end of the month can be reduced. I made it. Also, in recent years, since many companies have sent payment notices, it is possible to accelerate the monthly settlement by converting the results of confirmation of miscalculations for the advance collection schedule into data. Hereinafter, a specific configuration and operation will be described.

[2.構成]
本実施形態に係る違算確認業務支援装置100の構成の一例について、図1を参照して説明する。図1は、違算確認業務支援装置100の構成の一例を示すブロック図である。
[2. Constitution]
An example of the configuration of the miscalculation confirmation business support device 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the miscalculation confirmation business support device 100.

違算確認業務支援装置100は、市販のデスクトップ型パーソナルコンピュータである。なお、違算確認業務支援装置100は、デスクトップ型パーソナルコンピュータのような据置型情報処理装置に限らず、市販されているノート型パーソナルコンピュータ、PDA(Personal Digital Assistants)、スマートフォン、タブレット型パーソナルコンピュータなどの携帯型情報処理装置であってもよい。 The miscalculation confirmation business support device 100 is a commercially available desktop personal computer. The miscalculation confirmation business support device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is not limited to a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, or the like. It may be a portable information processing device.

違算確認業務支援装置100は、制御部102と通信インターフェース部104と記憶部106と入出力インターフェース部108と、を備えている。違算確認業務支援装置100が備えている各部は、任意の通信路を介して通信可能に接続されている。 The miscalculation confirmation business support device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the miscalculation confirmation business support device 100 is connected so as to be communicable via an arbitrary communication path.

通信インターフェース部104は、ルータ等の通信装置および専用線等の有線または無線の通信回線を介して、違算確認業務支援装置100をネットワーク300に通信可能に接続する。通信インターフェース部104は、他の装置と通信回線を介してデータを通信する機能を有する。ここで、ネットワーク300は、違算確認業務支援装置100とサーバ200とを相互に通信可能に接続する機能を有し、例えばインターネットやLAN(Local Area Network)等である。なお、後述する各種マスタ等のデータは、例えばサーバ200に格納されてもよい。 The communication interface unit 104 connects the miscalculation confirmation business support device 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the miscalculation confirmation business support device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like. The data of various masters and the like described later may be stored in the server 200, for example.

入出力インターフェース部108には、入力装置112および出力装置114が接続されている。出力装置114には、モニタ(家庭用テレビを含む)の他、スピーカやプリンタを用いることができる。入力装置112には、キーボード、マウス、及びマイクの他、マウスと協働してポインティングデバイス機能を実現するモニタを用いることができる。なお、以下では、出力装置114をモニタ114とし、入力装置112をキーボード112またはマウス112として記載する場合がある。 An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a home television). In addition to the keyboard, mouse, and microphone, the input device 112 can use a monitor that realizes a pointing device function in cooperation with the mouse. In the following, the output device 114 may be referred to as a monitor 114, and the input device 112 may be described as a keyboard 112 or a mouse 112.

記憶部106には、各種のデータベース、テーブルおよびファイルなどが格納される。記憶部106には、OS(Operating System)と協働してCPU(Central Processing Unit)に命令を与えて各種処理を行うためのコンピュータプログラムが記録される。記憶部106として、例えば、RAM(Random Access Memory)・ROM(Read Only Memory)等のメモリ装置、ハードディスクのような固定ディスク装置、フレキシブルディスク、および光ディスク等を用いることができる。 Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) / ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used.

記憶部106は、回収予定データ106aと、消込可否設定データとしての入金仮消込データ106bと、入金データとしての入金消込データ106cと、を備えている。 The storage unit 106 includes collection schedule data 106a, temporary payment application data 106b as application permission / rejection setting data, and payment application data 106c as payment data.

回収予定データ106aは、回収予定金額等を管理するためのデータである。回収予定データ106aは、図5~図7に示すように、例えば、回収予定金額を識別するための回収予定識別データ(回収予定NO)、各請求を識別するための請求識別データ(請求NO)、各売上を識別するための売上識別データ(売上NO)、前記回収予定金額、前記回収予定金額のうち消込が済んだ金額である消込済金額および消込状態区分(消込区分)等を含む。当該消込状態区分(消込区分)は、前記回収予定金額についての消込が済んだことを示す区分(消込区分:済)または前記回収予定金額についての消込が済んでいないことを示す区分(消込区分:未)である。 The collection schedule data 106a is data for managing the collection schedule amount and the like. As shown in FIGS. 5 to 7, the collection schedule data 106a is, for example, collection schedule identification data (collection schedule NO) for identifying the collection schedule amount, and billing identification data (billing NO) for identifying each bill. , Sales identification data (sales NO) for identifying each sales, the planned collection amount, the applied amount, which is the amount of the planned collection amount that has been cleared, and the clearing status classification (clearing classification), etc. including. The application status category (application category) indicates that the application for the planned collection amount has been completed (application category: completed) or that the application for the planned collection amount has not been completed. It is a classification (application classification: not yet).

入金仮消込データ106bは、入金の仮消込を行うためのデータである。入金仮消込データ106bは、図5に示すように、入金の仮消込の単位を識別するための入金仮消込識別データ(入金仮消込NO)、前記請求識別データ(請求NO)、前記売上識別データ(売上NO)、前記回収予定識別データ(回収予定NO)、仮の入金額である仮入金額(仮消込金額)、消込可否区分(確認区分)および前記消込状態区分(消込区分)等を含む。前記消込可否区分(確認区分)は、前記回収予定金額を前記仮入金額による自動消込の対象とすることを意味する消込可区分(確認区分:済)または前記回収予定金額を前記仮入金額による自動消込の対象としないことを意味する消込不可区分(確認区分:未)である。前記仮入金額は、例えば、前記回収予定金額の回収先からの支払通知書に記載された支払予定額である。 The payment temporary application data 106b is data for performing temporary payment application. As shown in FIG. 5, the deposit temporary application data 106b includes deposit temporary application identification data (payment temporary application NO) for identifying a unit of payment temporary application, the billing identification data (billing NO), and the above-mentioned billing identification data (billing NO). The sales identification data (sales NO), the collection schedule identification data (collection schedule NO), the provisional deposit amount (temporary application amount), the application possibility classification (confirmation classification), and the application status classification. (Application classification) etc. are included. The applicability category (confirmation category) is the applicability category (confirmation category: completed) or the provisional collection amount, which means that the scheduled collection amount is subject to automatic application by the provisional deposit amount. It is a non-applyable category (confirmation category: not yet), which means that it is not subject to automatic application based on the deposit amount. The provisional deposit amount is, for example, the planned payment amount described in the payment notice from the collection destination of the planned collection amount.

入金消込データ106cは、実際の入金額等を管理するためのデータである。入金消込データ106cは、図6および図7に示すように、例えば、入金の消込の単位を識別するための入金消込識別データ(入金消込NO)、前記回収予定識別データ(回収予定NO)および実際の入金額である実入金額(消込金額)等を含む。前記実入金額は、例えば、入金入力画面から入力された金額であってもよいし、EBデータ(エレクトロニック・バンキングデータ)から連携された金額であってもよいが、後者の場合、回収予定金額とEBデータにおける実入金額とのマッチングをかけて自動消込することで、消込作業の負荷を軽減することができるという利点がある。 The deposit application data 106c is data for managing the actual deposit amount and the like. As shown in FIGS. 6 and 7, for example, the deposit application data 106c includes deposit application identification data (deposit application NO) for identifying a unit of payment application, and the collection schedule identification data (collection schedule). NO) and the actual deposit amount (application amount), which is the actual deposit amount, etc. are included. The actual deposit amount may be, for example, an amount input from the deposit input screen or an amount linked from EB data (electronic banking data), but in the latter case, the estimated collection amount. There is an advantage that the load of the application work can be reduced by automatically applying by matching with the actual deposit amount in the EB data.

制御部102は、違算確認業務支援装置100を統括的に制御するCPU等である。制御部102は、OS等の制御プログラム・各種の処理手順等を規定したプログラム・所要データなどを格納するための内部メモリを有し、格納されているこれらのプログラムに基づいて種々の情報処理を実行する。 The control unit 102 is a CPU or the like that collectively controls the miscalculation confirmation business support device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run.

制御部102は、機能概念的に、例えば、(1)同一の前記回収予定識別データについて、前記回収予定データ中の前記回収予定金額と前記入金データ中の前記実入金額とが一致するか否かを判断する判断手段としての判断部102aと、(2)前記消込可否設定データ中の前記仮入金額を前記表示部に表示する表示実行手段としての表示実行部102bと、(3)前記判断手段で一致すると判断した前記回収予定識別データについて、前記回収予定データ中の前記回収予定金額を前記入金データ中の前記実入金額で消込する第一消込手段としての第一消込部102cと、(4)前記判断手段で一致しないと判断した前記回収予定識別データについて、当該回収予定識別データと紐付く前記消込可否設定データ中の前記消込可否区分が前記消込可区分である場合に、前記回収予定データ中の前記回収予定金額を前記消込可否設定データ中の前記仮入金額で消込する第二消込手段としての第二消込部102dと、を備えている。 The control unit 102 functionally conceptually indicates, for example, (1) whether or not the collection schedule amount in the collection schedule data and the actual payment amount in the payment data match with respect to the same collection schedule identification data. A determination unit 102a as a determination means for determining whether or not the data is displayed, (2) a display execution unit 102b as a display execution means for displaying the provisional deposit amount in the application enable / disable setting data on the display unit, and (3) the display execution unit 102b. With respect to the collection schedule identification data determined to match by the determination means, the first application unit as the first application means for applying the collection schedule amount in the collection schedule data with the actual payment amount in the payment data. With respect to 102c and (4) the collection schedule identification data determined to be inconsistent by the determination means, the application possibility classification in the application permission setting data associated with the collection schedule identification data is the application possibility classification. In some cases, it is provided with a second application unit 102d as a second application means for applying the estimated collection amount in the collection schedule data with the provisional payment amount in the application permission setting data. ..

判断部102aは、同一の回収予定NOについて、回収予定データ106a中の回収予定金額と入金消込データ106c中の消込金額とが一致するか否かを判断する(図10のステップS1)。 The determination unit 102a determines whether or not the collection schedule amount in the collection schedule data 106a and the application amount in the deposit application data 106c match with respect to the same collection schedule NO (step S1 in FIG. 10).

表示実行部102bは、入金仮消込データ106b中の仮消込金額を表示部に表示する。これにより、例えば、自動消込ではなく、オペレータによる判断で消込を行うことができる。 The display execution unit 102b displays the temporary application amount in the payment temporary application data 106b on the display unit. Thereby, for example, the application can be performed at the discretion of the operator instead of the automatic application.

第一消込部102cは、判断部102aで一致すると判断した回収予定NOについて(図10のステップS1:Yes)、回収予定データ106a中の回収予定金額を入金消込データ106c中の消込金額で消込する(図10のステップS2)。 The first application unit 102c deposits the collection schedule amount in the collection schedule data 106a for the collection schedule NO determined to match by the determination unit 102a (step S1: Yes in FIG. 10). (Step S2 in FIG. 10).

第二消込部102dは、判断部102aで一致しないと判断した回収予定NOについて(図10のステップS1:No)、当該回収予定NOと紐付く入金仮消込データ106b中の確認区分が「済」である場合に(図10のステップS3:済)、回収予定データ106a中の回収予定金額を入金仮消込データ106b中の仮消込金額で消込する(図10のステップS5)。 Regarding the collection schedule NO determined by the determination unit 102a that the second application unit 102d does not match (step S1: No in FIG. 10), the confirmation category in the payment provisional application data 106b associated with the collection schedule NO is ". If it is "completed" (step S3 in FIG. 10: completed), the planned collection amount in the scheduled collection data 106a is applied by the temporary application amount in the temporary payment application data 106b (step S5 in FIG. 10).

[3.処理概要]
以下、本実施形態に係る処理の概要について、従前の技術と比較しつつ説明する。
[3. Outline of processing]
Hereinafter, the outline of the process according to the present embodiment will be described in comparison with the conventional technique.

[3-1.従前の違算確認]
従前においては、図2に示すように、支払通知書を受領すると、違算の確認を行っていたが、確認結果はデータされていなかった。このため、実際に入金されるまで、未回収(予定)情報を把握することはできず、月末に入金があった際に、未回収金額(すなわち、違算)を改めて確認する必要があった。
[3-1. Previous miscalculation confirmation]
Previously, as shown in FIG. 2, when the payment notice was received, the miscalculation was confirmed, but the confirmation result was not data. For this reason, it is not possible to grasp the uncollected (planned) information until the actual deposit is made, and when the deposit is made at the end of the month, it is necessary to reconfirm the uncollected amount (that is, miscalculation).

[3-2.本実施形態に係る違算確認]
これに対して、本実施形態においては、図3に示すように、支払通知書を受領すると、違算の確認を行う点は従前と同じであるが、確認結果を仮消込入力によってデータ化する。これにより、先方の検収内容との相違を確認することが可能となり、月末に入金があった際に、データ化した仮消込情報を呼出して消込処理を行うことにより、消込業務を効率化することができる。
[3-2. Confirmation of miscalculation according to this embodiment]
On the other hand, in the present embodiment, as shown in FIG. 3, when the payment notice is received, the point of confirming the miscalculation is the same as before, but the confirmation result is converted into data by temporary application input. .. This makes it possible to confirm the difference from the acceptance inspection contents of the other party, and when there is a payment at the end of the month, the temporary application information converted into data is called and the application process is performed, which makes the application work more efficient. Can be changed.

[3-3.本実施形態に係る違算確認のフロー]
本実施形態に係る違算確認のフローについて、図4を用いて説明する。まず、支払通知書を受領すると、仮消込入力を行うことにより、回収予定金額の仮消込を行い、入金仮消込データ106bが作成される。一方で、入金入力により、またはEBデータより、実入金の情報が取得されると、前記作成した入金仮消込データ106bを基にして、入金一括消込入力が行われる。これにより、回収予定金額の消込が行われ、回収予定データ106aが更新される。そして、最終的に、更新された回収予定データ106aは、仕訳連携処理によって会計システムに連携されて、仕訳データが作成される。
[3-3. Flow of miscalculation confirmation according to this embodiment]
The flow of confirmation of miscalculation according to the present embodiment will be described with reference to FIG. First, upon receiving the payment notice, the temporary application amount is temporarily applied by inputting the temporary application, and the temporary payment application data 106b is created. On the other hand, when the actual payment information is acquired by the payment input or from the EB data, the payment batch application input is performed based on the payment temporary application data 106b created above. As a result, the scheduled collection amount is cleared and the scheduled collection data 106a is updated. Finally, the updated collection schedule data 106a is linked to the accounting system by the journal linking process, and the journal data is created.

[4.処理詳細]
以下、本実施形態に係る処理の詳細について、図5~図10を用いて説明する。
[4. Processing details]
Hereinafter, the details of the processing according to the present embodiment will be described with reference to FIGS. 5 to 10.

[4-1.入金仮消込データの作成]
まず、図5の回収予定データ106aには、回収予定NO:KY00001で識別される回収予定金額10,000円、回収予定NO:KY00002で識別される回収予定金額20,000円および回収予定NO:KY00003で識別される回収予定金額30,000円が含まれている。ここで、図5の支払通知書を受領すると、入金仮消込入力が実施されることにより、以下のようにして入金仮消込データ106bが作成される。
[4-1. Creation of temporary payment application data]
First, the planned collection data 106a in FIG. 5 is identified by the planned collection amount of 10,000 yen identified by the planned collection NO: KY00001, the planned collection amount of 20,000 yen identified by the planned collection NO: KY00002, and the scheduled collection NO: KY00003. The estimated collection amount of 30,000 yen is included. Here, when the payment notice of FIG. 5 is received, the temporary payment application input is performed, so that the temporary payment application data 106b is created as follows.

回収予定NO:KY00001については、図5の回収予定データ106aおよび支払通知書を参照すると、前記回収予定金額10,000円に対する支払予定額が10,000円であるため、違算は発生していない。違算が発生していない場合には、前記支払予定額10,000円を一括消込(自動消込)の対象として問題ないため、確認区分を「済」としたレコード(図5の入金仮消込データ106bの回収予定NO:KY00001のレコード)が作成される。 Regarding the collection schedule NO: KY00001, referring to the collection schedule data 106a and the payment notice in FIG. 5, since the payment schedule amount for the collection schedule amount of 10,000 yen is 10,000 yen, no miscalculation has occurred. If there is no miscalculation, there is no problem with the planned payment amount of 10,000 yen as the target of batch application (automatic application), so a record with the confirmation category set to "completed" (temporary payment application data in Fig. 5). 106b collection schedule NO: KY00001 record) is created.

これに対して、回収予定NO:KY00002については、図5の回収予定データ106aおよび支払通知書を参照すると、前記回収予定金額20,000円に対する支払予定額が15,000しかないため、5,000円分の違算が発生している。違算が発生している場合には、前記支払予定額15,000を一括消込(自動消込)の対象とするか否かは、オペレータが任意に設定することとなる。具体的には、回収予定金額と後述する実入金額とが一致しない場合に、回収予定金額20,000円を支払予定額15,000円で自動的に消込してよいとオペレータが判断した場合には、確認区分「済」が設定される。これに対して、回収予定金額と後述する実入金額とが一致しない場合に、回収予定金額20,000円を支払予定額15,000円で消込してよいかを、オペレータが入金入力画面上で決定したいと判断した場合には、確認区分「未」が設定されることにより、支払予定額15,000円は違算確認中の状態となり一括消込(自動消込)の対象外となる。本例では、図5の入金仮消込データ106bの回収予定NO:KY00002のレコードにおいては、確認区分「未」が設定されている。このように、確認区分によって、一括消込(自動消込)にするのか、または、入金入力の際に確認しながら消込するのかのステータスを管理することができる。 On the other hand, regarding the collection schedule NO: KY00002, referring to the collection schedule data 106a and the payment notice in FIG. 5, since the payment schedule amount for the collection schedule amount of 20,000 yen is only 15,000, there is a miscalculation of 5,000 yen. It has occurred. If a miscalculation occurs, the operator can arbitrarily set whether or not the scheduled payment amount of 15,000 is subject to batch application (automatic application). Specifically, if the operator determines that the planned collection amount of 20,000 yen may be automatically applied with the planned payment amount of 15,000 yen when the planned collection amount does not match the actual payment amount described later. The confirmation category "Done" is set. On the other hand, if the planned collection amount does not match the actual payment amount described later, the operator wants to decide on the payment input screen whether the planned collection amount of 20,000 yen can be applied with the planned payment amount of 15,000 yen. If it is determined that the confirmation category is set to "Not yet", the planned payment amount of 15,000 yen will be in the state of being confirmed for miscalculation and will not be subject to batch application (automatic application). In this example, the confirmation category "not yet" is set in the record of the collection schedule NO: KY00002 of the temporary payment application data 106b in FIG. In this way, depending on the confirmation category, it is possible to manage the status of batch application (automatic application) or application while confirming at the time of deposit input.

以上のようにして、図5の入金仮消込データ106bが作成される。続いて、消込処理が実行されるが、支払通知書通りに入金された場合と、請求書通りに入金された場合と、に分けて以下説明する。 As described above, the temporary payment application data 106b of FIG. 5 is created. Subsequently, the application process is executed, and the case where the payment is made according to the payment notice and the case where the payment is made according to the invoice will be described below separately.

[4-2.支払通知書通りに入金された場合]
本項目では、図6の入金消込データ106cに示すように、図5の支払通知書通りに入金された場合の消込処理の例について、図10のフローチャートに沿って、回収予定NO別に説明する。
[4-2. When payment is made according to the payment notice]
In this item, as shown in the payment application data 106c of FIG. 6, an example of the application process when the payment is made according to the payment notice of FIG. 5 will be described for each collection schedule NO according to the flowchart of FIG. do.

まず、オペレータが、図8の入金入力画面において、入金日「2018/03/22」、請求先「ABC」および仮消込番号「KR00001」を入力して、消込候補表示のボタンを選択すると、表示実行部102bは、図5の入金仮消込データ106bから、仮消込番号「KR00001」と紐付き、かつ、未消込(消込区分が「未」)である2明細を取得し、当該2明細に含まれる仮消込金額10,000円および15,000円を、今回消込額として図8のMA1に表示する。言い換えると、仮消込金額10,000円および15,000円が、今回消込額として図8のMA1に自動セットされる。以下、図8のMA1に1~3の番号を付した明細(以下、本項目において、それぞれ単に「明細1~3」という。)についての消込処理について、項目立てて説明する。 First, when the operator inputs the deposit date "2018/03/22", the billing address "ABC" and the temporary application number "KR00001" on the deposit input screen of FIG. 8, and selects the button for displaying the application candidates. , The display execution unit 102b acquires two details that are linked to the temporary application number "KR00001" and are not applied (the application category is "not") from the payment temporary application data 106b in FIG. The provisional application amount of 10,000 yen and 15,000 yen included in the two items are displayed in MA1 of FIG. 8 as the application amount this time. In other words, the provisional application amount of 10,000 yen and 15,000 yen is automatically set in MA1 of FIG. 8 as the application amount this time. Hereinafter, the application processing for the details numbered 1 to 3 in MA1 of FIG. 8 (hereinafter, simply referred to as “details 1 to 3” in this item) will be described in terms of items.

(1)明細1についての消込処理
明細1は、図6の回収予定データ106aにおける回収予定NO:KY00001のレコードに対応する。ここで、回収予定NO:KY00001については、図6の回収予定データ106a中の回収予定金額10,000円と図6の入金消込データ106c中の実入金額である消込金額10,000円とは同額である。このため、判断部102aは、回収予定金額と消込金額とが一致すると判断する(図10のステップS1:Yes)。
(1) Application processing for detail 1 Detail 1 corresponds to the record of collection schedule NO: KY00001 in the collection schedule data 106a of FIG. Here, for the collection schedule NO: KY00001, the collection schedule amount of 10,000 yen in the collection schedule data 106a of FIG. 6 and the application amount of 10,000 yen, which is the actual deposit amount in the deposit application data 106c of FIG. 6, are the same amount. be. Therefore, the determination unit 102a determines that the estimated collection amount and the application amount match (step S1: Yes in FIG. 10).

判断部102aが一致すると判断した場合、第一消込部102cは、図6の回収予定データ106a中の回収予定金額10,000円を、図6の入金消込データ106c中の消込金額10,000円で消込する(図10のステップS2)。これにより、図6の回収予定データ106aの回収予定NO:KY00001のレコードに示すように、消込区分は「済」に更新される。 If it is determined that the determination units 102a match, the first application unit 102c uses the collection schedule amount of 10,000 yen in the collection schedule data 106a of FIG. 6 as the application amount of 10,000 yen in the deposit application data 106c of FIG. Apply (step S2 in FIG. 10). As a result, the clearing category is updated to "finished" as shown in the record of the collection schedule NO: KY00001 of the collection schedule data 106a in FIG.

以上のようにして、明細1についての消込処理は終了する(図10のエンド)。 As described above, the application processing for the specification 1 is completed (end of FIG. 10).

(2)明細2についての消込処理
明細2は、図6の回収予定データ106aにおける回収予定NO:KY00002のレコードに対応する。ここで、回収予定NO:KY00002については、図6の回収予定データ106a中の回収予定金額20,000円と図6の入金消込データ106c中の実入金額である消込金額15,000円とは同額ではない。このため、判断部102aは、回収予定金額と消込金額とが一致しないと判断する(図10のステップS1:No)。
(2) Application processing for detail 2 Detail 2 corresponds to the record of collection schedule NO: KY00002 in the collection schedule data 106a of FIG. Here, regarding the collection schedule NO: KY00002, the collection schedule amount of 20,000 yen in the collection schedule data 106a of FIG. 6 and the application amount of 15,000 yen, which is the actual deposit amount in the deposit application data 106c of FIG. 6, are the same amount. do not have. Therefore, the determination unit 102a determines that the estimated collection amount and the application amount do not match (step S1: No in FIG. 10).

ここで、図5の入金仮消込データ106bを参照すると、回収予定NO:KY00002のレコードにおける確認区分は「未」であるため(図10のステップS3:未)、第二消込部102dによる自動消込は実行されない。このため、図8の入金入力画面上で、図6の回収予定データ106a中の回収予定金額20,000円を、図5の入金仮消込データ106b中の仮消込金額15,000円で消込するか否かを、オペレータが判断することとなる(図10のステップS4)。 Here, referring to the temporary payment application data 106b in FIG. 5, since the confirmation category in the record of the collection schedule NO: KY00002 is “not yet” (step S3 in FIG. 10: not yet), the second application unit 102d is used. No automatic clearing is performed. Therefore, on the deposit input screen of FIG. 8, whether the scheduled collection amount of 20,000 yen in the collection schedule data 106a of FIG. 6 is applied with the temporary application amount of 15,000 yen in the payment provisional application data 106b of FIG. Whether or not it will be determined by the operator (step S4 in FIG. 10).

これに対して、本例とは異なるが、仮に、図5の入金仮消込データ106bにおいて回収予定NO:KY00002のレコードにおける確認区分が「済」である場合(図10のステップS3:済)、第二消込部102dは、図6の回収予定データ106a中の回収予定金額20,000円を、図5の入金仮消込データ106b中の仮消込金額15,000円で消込する(図10のステップS5)。このように、支払通知書での違算確認の際に確認区分を「済」に設定して仮消込しておけば、実入金後には、違算確認することなく、自動的に消込を行うことができるため、違算確認を重複して行う必要がない。 On the other hand, although it is different from this example, if the confirmation category in the record of the collection schedule NO: KY00002 is "completed" in the temporary payment application data 106b in FIG. 5 (step S3: completed in FIG. 10). , The second application unit 102d applies the estimated collection amount of 20,000 yen in the collection schedule data 106a of FIG. 6 to the temporary application amount of 15,000 yen in the payment provisional application data 106b of FIG. 5 (FIG. 10). Step S5). In this way, if you set the confirmation category to "Done" and temporarily apply when confirming the miscalculation on the payment notice, the application will be automatically applied after the actual payment without confirming the miscalculation. Since it can be done, there is no need to perform duplicate confirmation of miscalculation.

以上のようにして、明細2についての消込処理は終了する(図10のエンド)。 As described above, the application processing for the specification 2 is completed (end of FIG. 10).

(3)明細3についての消込処理
明細3は、図6の回収予定データ106aにおける回収予定NO:KY00003のレコードに対応する。ここで、回収予定NO:KY00003については、図5の支払通知書にも図6の入金消込データ106cにも対応するデータが存在しないため、明細3についての消込処理は実行されない。
(3) Application processing for detail 3 Detail 3 corresponds to the record of recovery schedule NO: KY00003 in the collection schedule data 106a of FIG. Here, regarding the collection schedule NO: KY00003, since there is no data corresponding to the payment notification in FIG. 5 and the payment application data 106c in FIG. 6, the application process for the item 3 is not executed.

[4-3.請求書通りに入金された場合]
本項目では、図7の入金消込データ106cに示すように、請求書通りに(すなわち、図5の回収予定データ106aの通りに)入金された場合の消込処理の例について、図10のフローチャートに沿って説明する。
[4-3. If the payment is made according to the invoice]
In this item, as shown in the deposit application data 106c of FIG. 7, an example of the application process when the payment is made according to the invoice (that is, according to the collection schedule data 106a of FIG. 5) is shown in FIG. The explanation will be given according to the flowchart.

まず、オペレータが、図9の入金入力画面において、入金日「2018/03/22」および請求先「ABC」を入力して(仮消込番号は未入力)、消込候補表示のボタンを選択すると、図7の入金消込データ106cの3明細が取得され、当該3明細に含まれる消込金額10,000円、20,000円および30,000円が、図9のMB1に表示される。以下、図9のMB1に1~3の番号を付した明細(以下、本項目において、それぞれ単に「明細1~3」という。)についての消込処理について、項目立てて説明する。 First, the operator inputs the payment date "2018/03/22" and the billing address "ABC" on the payment input screen shown in FIG. 9 (temporary application number has not been entered), and selects the button for displaying application candidates. Then, three details of the deposit application data 106c of FIG. 7 are acquired, and the application amounts of 10,000 yen, 20,000 yen, and 30,000 yen included in the three details are displayed in MB1 of FIG. Hereinafter, the application processing for the details numbered 1 to 3 in MB1 of FIG. 9 (hereinafter, simply referred to as “details 1 to 3” in this item) will be described in an itemized manner.

(1)明細1についての消込処理
明細1は、図7の回収予定データ106aにおける回収予定NO:KY00001のレコードに対応する。ここで、回収予定NO:KY00001については、図7の回収予定データ106a中の回収予定金額10,000円と図7の入金消込データ106c中の実入金額である消込金額10,000円とは同額である。このため、判断部102aは、回収予定金額と消込金額とが一致すると判断する(図10のステップS1:Yes)。
(1) Application processing for detail 1 Detail 1 corresponds to the record of collection schedule NO: KY00001 in the collection schedule data 106a of FIG. 7. Here, for the collection schedule NO: KY00001, the collection schedule amount of 10,000 yen in the collection schedule data 106a of FIG. 7 and the application amount of 10,000 yen, which is the actual deposit amount in the deposit application data 106c of FIG. 7, are the same amount. be. Therefore, the determination unit 102a determines that the estimated collection amount and the application amount match (step S1: Yes in FIG. 10).

判断部102aが一致すると判断した場合、第一消込部102cは、図7の回収予定データ106a中の回収予定金額10,000円を、図7の入金消込データ106c中の消込金額10,000円で消込する(図10のステップS2)。これにより、図7の回収予定データ106aの回収予定NO:KY00001のレコードに示すように、消込区分は「済」に更新される。 If it is determined that the determination units 102a match, the first application unit 102c uses the collection schedule amount of 10,000 yen in the collection schedule data 106a of FIG. 7 as the application amount of 10,000 yen in the deposit application data 106c of FIG. Apply (step S2 in FIG. 10). As a result, the clearing category is updated to "finished" as shown in the record of the collection schedule NO: KY00001 of the collection schedule data 106a in FIG. 7.

なお、明細1および以下で説明する明細2については、図5の入金仮消込データ106bに示すように、仮消込金額が存在するが、回収予定データ106a中の回収予定金額と入金消込データ106c中の実入金額(消込金額)とが一致する場合には、実入金額で優先的に自動消込される。 As for the details 1 and the details 2 described below, as shown in the temporary payment application data 106b in FIG. 5, there is a temporary application amount, but the collection schedule amount and the payment application in the collection schedule data 106a are present. If the actual deposit amount (application amount) in the data 106c matches, the actual deposit amount is preferentially automatically applied.

以上のようにして、明細1についての消込処理は終了する(図10のエンド)。 As described above, the application processing for the specification 1 is completed (end of FIG. 10).

(2)明細2についての消込処理
明細2は、図7の回収予定データ106aにおける回収予定NO:KY00002のレコードに対応する。明細2についても、(1)で説明した消込処理と同様の消込処理が実行され、図7の回収予定データ106aの回収予定NO:KY00002のレコードに示すように、消込区分は「済」に更新される。
(2) Application processing for detail 2 Detail 2 corresponds to the record of collection schedule NO: KY00002 in the collection schedule data 106a of FIG. 7. For the item 2, the same application processing as the application process described in (1) is executed, and as shown in the record of the collection schedule NO: KY00002 of the collection schedule data 106a in FIG. 7, the application classification is "completed". Is updated to.

(3)明細3についての消込処理
明細3は、図7の回収予定データ106aにおける回収予定NO:KY00003のレコードに対応する。明細3についても、(1)で説明した消込処理と同様の消込処理が実行され、図7の回収予定データ106aの回収予定NO:KY00003のレコードに示すように、消込区分は「済」に更新される。
(3) Application processing for detail 3 Detail 3 corresponds to the record of recovery schedule NO: KY00003 in the collection schedule data 106a of FIG. 7. For the item 3, the same application process as the application process described in (1) is executed, and as shown in the record of the collection schedule NO: KY00003 of the collection schedule data 106a in FIG. 7, the application classification is "completed". Is updated to.

[4-4.まとめ]
以上説明してきたように、本実施形態に係る違算確認業務支援装置100によれば、例えば、請求先からの支払通知書に基づいて違算を確認して、当該違算が発生した状態で消込しても問題ないとオペレータが判断して入金仮消込データ106bの確認区分を「済」に予め設定しておけば、実入金後に同様の違算が生じている場合に、重複した違算確認業務をオペレータに行わせることなく、自動的に消込処理を実行することができる。このように、本実施形態に係る違算確認業務支援装置100は、実際の入金後に行う違算の確認業務を支援できる。
[4-4. summary]
As described above, according to the miscalculation confirmation business support device 100 according to the present embodiment, for example, the miscalculation is confirmed based on the payment notice from the billing destination, and the miscalculation is cleared in the state where the miscalculation has occurred. If the operator judges that there is no problem and sets the confirmation category of the temporary payment application data 106b to "Done" in advance, if the same miscalculation occurs after the actual payment, duplicate miscalculation confirmation work can be performed. The clearing process can be automatically executed without having the operator perform it. As described above, the miscalculation confirmation work support device 100 according to the present embodiment can support the miscalculation confirmation work performed after the actual payment.

[5.他の実施形態]
本発明は、上述した実施形態以外にも、特許請求の範囲に記載した技術的思想の範囲内において種々の異なる実施形態にて実施されてよいものである。
[5. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

例えば、実施形態において説明した各処理のうち、自動的に行われるものとして説明した処理の全部または一部を手動的に行うこともでき、あるいは、手動的に行われるものとして説明した処理の全部または一部を公知の方法で自動的に行うこともできる。 For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed may be performed manually, or all the processes described as being performed manually may be performed. Alternatively, a part can be automatically performed by a known method.

また、本明細書中や図面中で示した処理手順、制御手順、具体的名称、各処理の登録データや検索条件等のパラメータを含む情報、画面例、データベース構成については、特記する場合を除いて任意に変更することができる。 In addition, processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in this specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

また、違算確認業務支援装置100に関して、図示の各構成要素は機能概念的なものであり、必ずしも物理的に図示の如く構成されていることを要しない。 Further, with respect to the miscalculation confirmation business support device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

例えば、違算確認業務支援装置100が備える処理機能、特に制御部にて行われる各処理機能については、その全部または任意の一部を、CPUおよび当該CPUにて解釈実行されるプログラムにて実現してもよく、また、ワイヤードロジックによるハードウェアとして実現してもよい。尚、プログラムは、本実施形態で説明した処理を情報処理装置に実行させるためのプログラム化された命令を含む一時的でないコンピュータ読み取り可能な記録媒体に記録されており、必要に応じて違算確認業務支援装置100に機械的に読み取られる。すなわち、ROMまたはHDD(Hard Disk Drive)などの記憶部などには、OSと協働してCPUに命令を与え、各種処理を行うためのコンピュータプログラムが記録されている。このコンピュータプログラムは、RAMにロードされることによって実行され、CPUと協働して制御部を構成する。 For example, with respect to the processing functions included in the miscalculation confirmation business support device 100, particularly each processing function performed by the control unit, all or any part thereof is realized by the CPU and a program that is interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and the miscalculation confirmation work is performed as necessary. It is read mechanically by the support device 100. 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 an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form a control unit.

また、このコンピュータプログラムは、違算確認業務支援装置100に対して任意のネットワークを介して接続されたアプリケーションプログラムサーバに記憶されていてもよく、必要に応じてその全部または一部をダウンロードすることも可能である。 Further, this computer program may be stored in the application program server connected to the miscalculation confirmation business support device 100 via an arbitrary network, and all or part of the computer program may be downloaded as needed. It is possible.

また、本実施形態で説明した処理を実行するためのプログラムを、一時的でないコンピュータ読み取り可能な記録媒体に格納してもよく、また、プログラム製品として構成することもできる。ここで、この「記録媒体」とは、メモリーカード、USB(Universal Serial Bus)メモリ、SD(Secure Digital)カード、フレキシブルディスク、光磁気ディスク、ROM、EPROM(Erasable Programmable Read Only Memory)、EEPROM(登録商標)(Electrically Erasable and Programmable Read Only Memory)、CD-ROM(Compact Disk Read Only Memory)、MO(Magneto-Optical disk)、DVD(Digital Versatile Disk)、および、Blu-ray(登録商標) Disc等の任意の「可搬用の物理媒体」を含むものとする。 Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes 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), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disc), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

また、「プログラム」とは、任意の言語または記述方法にて記述されたデータ処理方法であり、ソースコードまたはバイナリコード等の形式を問わない。なお、「プログラム」は必ずしも単一的に構成されるものに限られず、複数のモジュールやライブラリとして分散構成されるものや、OSに代表される別個のプログラムと協働してその機能を達成するものをも含む。なお、実施形態に示した各装置において記録媒体を読み取るための具体的な構成および読み取り手順ならびに読み取り後のインストール手順等については、周知の構成や手順を用いることができる。 Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium and the installation procedure after reading in each device shown in the embodiment.

記憶部に格納される各種のデータベース等は、RAM、ROM等のメモリ装置、ハードディスク等の固定ディスク装置、フレキシブルディスク、および、光ディスク等のストレージ手段であり、各種処理やウェブサイト提供に用いる各種のプログラム、テーブル、データベース、および、ウェブページ用ファイル等を格納する。 Various databases and the like stored in the storage unit are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

また、違算確認業務支援装置100は、既知のパーソナルコンピュータまたはワークステーション等の情報処理装置として構成してもよく、また、任意の周辺装置が接続された当該情報処理装置として構成してもよい。また、違算確認業務支援装置100は、当該装置に本実施形態で説明した処理を実現させるソフトウェア(プログラムまたはデータ等を含む)を実装することにより実現してもよい。 Further, the miscalculation confirmation business support 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 miscalculation confirmation business support device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

更に、装置の分散・統合の具体的形態は図示するものに限られず、その全部または一部を、各種の付加等に応じてまたは機能負荷に応じて、任意の単位で機能的または物理的に分散・統合して構成することができる。すなわち、上述した実施形態を任意に組み合わせて実施してもよく、実施形態を選択的に実施してもよい。 Furthermore, the specific form of distribution / integration of the device is not limited to that shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

本発明は、例えば、支払通知書を受領する業界等において有用である。 The present invention is useful, for example, in the industry of receiving payment notices.

100 違算確認業務支援装置
102 制御部
102a 判断部
102b 表示実行部
102c 第一消込部
102d 第二消込部
104 通信インターフェース部
106 記憶部
106a 回収予定データ
106b 入金仮消込データ
106c 入金消込データ
108 入出力インターフェース部
112 入力装置
114 出力装置
200 サーバ
300 ネットワーク
100 Miscalculation confirmation business support device 102 Control unit
102a Judgment unit
102b Display execution unit
102c First application section
102d Second clearing unit 104 Communication interface unit 106 Storage unit
106a Data to be collected
106b Temporary payment application data
106c Deposit application data 108 Input / output interface 112 Input device 114 Output device 200 Server 300 Network

Claims (1)

制御部および記憶部を備え、回収予定金額と実際の入金額である実入金額の間での違算の確認業務を支援するための違算確認業務支援装置であって、
前記記憶部には、
前記回収予定金額を識別するための回収予定識別データと前記回収予定金額とを含む回収予定データと、
前記回収予定識別データと仮の入金額である仮入金額と消込可否区分とを含み、当該消込可否区分は、前記回収予定金額を前記仮入金額による自動消込の対象とすることを意味する消込可区分または前記回収予定金額を前記仮入金額による自動消込の対象としないことを意味する消込不可区分である消込可否設定データと、
前記回収予定識別データと前記実入金額とを含む入金データと、
が格納されており、
前記制御部は、
同一の前記回収予定識別データについて、前記回収予定データ中の前記回収予定金額と前記入金データ中の前記実入金額とが一致するか否かを判断する判断手段と、
前記判断手段で一致すると判断した前記回収予定識別データについて、前記回収予定データ中の前記回収予定金額を前記入金データ中の前記実入金額で消込する第一消込手段と、
前記判断手段で一致しないと判断した前記回収予定識別データについて、当該回収予定識別データと紐付く前記消込可否設定データ中の前記消込可否区分が前記消込可区分である場合に、前記回収予定データ中の前記回収予定金額を前記消込可否設定データ中の前記仮入金額で消込する第二消込手段と、
を備えること、
を特徴とする違算確認業務支援装置。
It is a miscalculation confirmation work support device that has a control unit and a storage unit and supports the confirmation work of the miscalculation between the estimated collection amount and the actual deposit amount.
In the storage unit
Collection schedule data including the collection schedule identification data for identifying the collection schedule amount and the collection schedule data, and
The collection schedule identification data, the provisional deposit amount which is a provisional deposit amount, and the application possibility classification are included, and the application possibility classification indicates that the collection schedule amount is subject to automatic application by the provisional deposit amount. Disappearability setting data, which is a non-applicable category that means that the applicable category or the planned collection amount is not subject to automatic application by the provisional deposit amount,
Deposit data including the collection schedule identification data and the actual deposit amount,
Is stored,
The control unit
With respect to the same collection schedule identification data, a determination means for determining whether or not the collection schedule amount in the collection schedule data and the actual deposit amount in the deposit data match.
With respect to the collection schedule identification data determined to match by the determination means, the first application means for applying the collection schedule amount in the collection schedule data with the actual payment amount in the payment data, and
Regarding the collection schedule identification data determined to be inconsistent by the determination means, the collection is performed when the application possibility classification in the application permission setting data associated with the collection schedule identification data is the application possibility classification. A second application means for applying the estimated collection amount in the scheduled data with the provisional deposit amount in the application permission setting data, and
To prepare for
Miscalculation confirmation business support device featuring.
JP2022069943A 2018-05-28 2022-04-21 Accounting error confirmation work support device, account error confirmation work support method, and account error confirmation work support program Active JP7250979B2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
JP2022069943A JP7250979B2 (en) 2018-05-28 2022-04-21 Accounting error confirmation work support device, account error confirmation work support method, and account error confirmation work support program

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
JP2018101712A JP7064381B2 (en) 2018-05-28 2018-05-28 Miscalculation confirmation business support device, miscalculation confirmation business support method and miscalculation confirmation business support program
JP2022069943A JP7250979B2 (en) 2018-05-28 2022-04-21 Accounting error confirmation work support device, account error confirmation work support method, and account error confirmation work support program

Related Parent Applications (1)

Application Number Title Priority Date Filing Date
JP2018101712A Division JP7064381B2 (en) 2018-05-28 2018-05-28 Miscalculation confirmation business support device, miscalculation confirmation business support method and miscalculation confirmation business support program

Publications (2)

Publication Number Publication Date
JP2022101638A true JP2022101638A (en) 2022-07-06
JP7250979B2 JP7250979B2 (en) 2023-04-03

Family

ID=87888218

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2022069943A Active JP7250979B2 (en) 2018-05-28 2022-04-21 Accounting error confirmation work support device, account error confirmation work support method, and account error confirmation work support program

Country Status (1)

Country Link
JP (1) JP7250979B2 (en)

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2003263542A (en) * 2002-03-11 2003-09-19 Toray Ind Inc Accounting method and accounting device
US20040073500A1 (en) * 2000-12-01 2004-04-15 Eugene Owen Methods and systems for automatic tracking and balancing billing data
JP2004234586A (en) * 2003-02-03 2004-08-19 Japan Research Institute Ltd Alternative payment fund management system, program for alternative payment fund management system, and storage medium recorded with the program
WO2014041642A1 (en) * 2012-09-12 2014-03-20 株式会社 日立製作所 Settlement service support system and settlement service support method
JP2016146166A (en) * 2015-02-02 2016-08-12 株式会社オービック Payment management system, payment management device, payment management method, and payment management program
JP2017182793A (en) * 2016-03-29 2017-10-05 株式会社オービック Payment reconciliation processing device, payment reconciliation processing method, and payment reconciliation processing program

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040073500A1 (en) * 2000-12-01 2004-04-15 Eugene Owen Methods and systems for automatic tracking and balancing billing data
JP2003263542A (en) * 2002-03-11 2003-09-19 Toray Ind Inc Accounting method and accounting device
JP2004234586A (en) * 2003-02-03 2004-08-19 Japan Research Institute Ltd Alternative payment fund management system, program for alternative payment fund management system, and storage medium recorded with the program
WO2014041642A1 (en) * 2012-09-12 2014-03-20 株式会社 日立製作所 Settlement service support system and settlement service support method
JP2016146166A (en) * 2015-02-02 2016-08-12 株式会社オービック Payment management system, payment management device, payment management method, and payment management program
JP2017182793A (en) * 2016-03-29 2017-10-05 株式会社オービック Payment reconciliation processing device, payment reconciliation processing method, and payment reconciliation processing program

Also Published As

Publication number Publication date
JP7250979B2 (en) 2023-04-03

Similar Documents

Publication Publication Date Title
JP7064342B2 (en) Application processing device, application processing method, and application processing program
JP2022002145A (en) Classification data preparation device, classification data creation method and classification data creation program
JP6400162B2 (en) Accounting system, accounting method and accounting program
JP6827837B2 (en) Project-specific credit management device, project-specific credit management method, and project-specific credit management program
JP2019032650A (en) Deduction amount calculation device, deduction amount calculation method and deduction amount calculation program
JP2018169904A (en) Reconciliation device, reconciliation method, and reconciliation program
JP6850160B2 (en) Payroll processing device, payroll correction processing method, and payroll correction processing program
JP2022097622A (en) Information processing device, information processing method and information processing program
JP7064381B2 (en) Miscalculation confirmation business support device, miscalculation confirmation business support method and miscalculation confirmation business support program
JP2022104542A (en) Fee processing apparatus, fee processing method and fee processing program
JP2022101638A (en) Miscalculation check work support device, miscalculation check work support method, and miscalculation check work support program
JP2017182784A (en) Money reception information management device, money reception information management method, and money reception information management program
JP7011470B2 (en) Work-in-process automatic transfer device, work-in-process automatic transfer method, and work-in-process automatic transfer program
JP2021149405A (en) Management device associating prepayment with transfer, management method associating prepayment with transfer and management program associating prepayment with transfer
JP2021077284A (en) Device, method, and program for transferring generated cost
JP2016091384A (en) Information processor, program, and information processing method
JP2020166614A (en) Deposit transfer device, deposit transfer method, and deposit transfer program
JP2020140322A (en) Credit management device, credit management method, and credit management program
JP2019219850A (en) Management accounting data creation support device, management accounting data creation support method, and management accounting data creation support program
JP7237677B2 (en) Business support device, business support program and business support method
JP6947596B2 (en) Deposit processing device, deposit processing method, and deposit processing program
JP7291088B2 (en) Slip Closing Support Device, Slip Closing Support Method, and Slip Closing Support Program
JP7261332B2 (en) Automatic work-in-process transfer device, automatic work-in-process transfer method, and automatic work-in-process transfer program
JP6058943B2 (en) Accounting system, accounting method and accounting program
JP7186088B2 (en) Return settlement device, return settlement method, and return settlement program

Legal Events

Date Code Title Description
A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20220510

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20220510

TRDD Decision of grant or rejection written
A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20230221

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20230322

R150 Certificate of patent or registration of utility model

Ref document number: 7250979

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150