JP2020004296A - Difference amount management apparatus, difference amount management method and difference amount management program - Google Patents

Abstract

To enable an operator to select a miscalculation reason, and further to create classification according to reason to mitigate a load of an accounting operation, in a case where a difference amount between a recovery schedule amount and an input amount occurs.SOLUTION: A difference amount management apparatus according to the present embodiment comprises: a master in which presence or absence of classification creation, and a debit account title and a credit account title of classification are registered for each miscalculation reason between an input money amount and a recovery schedule amount; erasure processing means that performs erasure of the input money amount and the recovery schedule amount from a business partner, that selects the miscalculation reason according to an operation of the operator when there is a difference amount, and that performs erasure when the selected miscalculation reason is a predetermined reason; and classification creation means that acquires presence or absence of the classification creation and the debit account title and the credit account title of the classification from the master using the selected miscalculation reason as a key, that does not create the classification when there is not the classification creation, and that creates the classification according to the debit account title and the credit account title of the acquired classification when there is the classification creation.SELECTED DRAWING: Figure 1

Description

  The present invention relates to a difference management device, a difference management method, and a difference management program.

  Conventionally, providers of products and services collate the amount received from the customer with the amount of receivables, and if a result of matching that the received amount matches the amount of receivables is obtained, the reconciliation processing of the amount of the relevant receivables Execute For example, there is Patent Document 1 as an apparatus for performing a clearing process.

  In the apparatus disclosed in Patent Document 1, a payment information acquisition unit 11 that acquires payment information including payment source information and a payment amount, and a non-payment information storage unit that stores non-payment information including billing destination information and a payment amount. 14, an index information storage unit 15 for storing index information in which billing destination information is associated with the payment source information, and billing destination information associated with the payment source information of the payment information by referring to the index information. And the non-payment information including the bill-to information acquired by the bill-to information acquisition unit 16 is extracted from the non-payment information stored in the non-payment information storage unit 14. A collating unit 17 for executing collation as to whether the undeposited amount of the undeposited information and the deposited amount of the deposit information correspond to each other, and an association that associates the deposited amount and the undeposited amount that have been obtained as a result of the collation. Part 18 and It is equipped with a.

  In addition, in Patent Document 1, in paragraph [0084], "the collation unit 17 may execute the collation between the above-mentioned unpaid amount and the deposited amount in consideration of the commission related to the payment. The collation unit 17 stores in advance fees related to payment (for example, “315 yen” or “525 yen”). Then, the collating unit 17 determines whether or not the difference between the unpaid amount and the deposited amount matches the commission in the collation, and if the difference coincides with the commission, the unpaid amount and the deposited amount May output a collation result indicating that they correspond to each other. As a result, the deposit amount and the unpaid amount can be appropriately linked in consideration of the commission generated at the time of deposit. It is described.

JP 2015-207142 A

  However, Patent Document 1 describes that if the difference between the expected recovery amount and the deposit amount matches the registered fee, the application is to be cleared, but the difference due to reasons other than the fee is described. Not. Since there are various reasons for the difference, the operator can select the reason for the difference, and it is desired to reduce the burden on the accounting work by creating journals corresponding to the reason.

  The present invention has been made in view of the above, and when the difference between the expected collection amount and the deposit amount occurs, the operator can select the reason for the miscalculation, and further prepares journals according to the reason. It is an object of the present invention to provide a difference management device, a difference management method, and a difference management program capable of reducing the burden of accounting work.

  In order to solve the above-described problem and achieve the object, the present invention provides a difference management device including a control unit and a storage unit, wherein the storage unit stores a difference between a deposit amount and a scheduled recovery amount for each reason for difference. Contains the master that has created journal entries and the debit account and credit account of the journal, and applies the amount received from the customer to the expected recovery amount.If there is a difference, If the reason for the difference is selected according to the operation of the operator, and if the selected reason for the difference is a predetermined reason, an application processing means for performing the application, and whether or not to create a journal from the master using the selected reason for the error as a key. And, if the journal entry has no debit account and credit account, the journal is not created if no journal entry is created.If the journal entry is created, the journal is created according to the acquired journal debit account and credit account. Journal creation method to be created , Characterized by comprising a.

  Also, according to a preferred aspect of the present invention, the predetermined reason may include a difference in quantity, a transfer fee, and miscellaneous collection / damage.

  Further, according to a preferred aspect of the present invention, if the reason for the difference is a difference in quantity, a transfer fee, and a miscellaneous receipt / miscellaneous loss, a journal is created, and the reason for the difference is a difference in quantity, a transfer fee, and a miscellaneous charge. In cases other than income / loss, it may be set that no journal is created.

  In order to solve the above-mentioned problems and achieve the object, the present invention relates to a difference management method executed by an information processing apparatus including a control unit and a storage unit, wherein the storage unit includes For each reason for the difference between the transaction and the expected recovery amount, a master registering whether journals are created and the debit account and credit account of the journals is stored, and the amount received from the business partner executed by the control unit. And the expected amount to be collected, and if there is a difference, the reason for the difference is selected according to the operation of the operator. And, using the selected reason for the difference as a key, obtains the presence / absence of journal creation and the debit account and credit account of the journal from the master.If no journal creation is made, no journal is created, and journal creation is performed. If so, debit insight of the acquired journal A journal creation step of creating a journal according to subjects and credit accounts, may be include.

  Further, in order to solve the above-described problem and achieve the object, the present invention is a difference management program to be executed by an information processing apparatus including a control unit and a storage unit, and the storage unit includes For each reason for the difference between the amount and the scheduled recovery amount, a master registering whether or not to create a journal and registering the debit account and credit account of the journal is stored. A clearing process step of performing a clearing with a scheduled amount, selecting a reason for the difference according to the operation of the operator if there is a difference, and clearing the selected reason for the difference if the selected reason is a predetermined reason, Using the selected reason for the difference as a key, obtain the presence / absence of journal creation from the master and the debit account and credit account of the journal, and do not create a journal if there is no journal creation, and if there is a journal creation, , Acquired journals Characterized in that it is a deposit processing program for executing, a journal creation step of creating a journal according to debit accounts and credit accounts.

  According to the present invention, when a difference between the scheduled collection amount and the deposit amount occurs, the operator can select the reason for the difference, and create journals corresponding to the selected reason for the difference to reduce the burden on the accounting business. The effect of being able to reduce is produced.

FIG. 1 is a block diagram illustrating an example of a configuration of a difference management device according to the present embodiment. FIG. 2 is a diagram illustrating a configuration example of the miscalculation reason master. FIG. 3 is a diagram for explaining an example of the overall processing of the difference management device according to the present embodiment. FIG. 4 is a flowchart for explaining the detailed journal creation processing. FIG. 5 is a diagram showing sample data. FIG. 6 is a diagram showing sample data. FIG. 7 is a diagram showing a display example (screen transition example) of the payment application screen.

  Hereinafter, embodiments of a difference management device, a difference management method, and a difference management program according to the present invention will be described in detail with reference to the drawings. The present invention is not limited by the embodiment.

[1. Overview]
Conventionally, providers of products and services collate the amount received from the customer with the amount of receivables, and if a result of matching that the received amount matches the amount of receivables is obtained, the reconciliation processing of the amount of the relevant receivables Execute The difference between the receivable amount and the deposit amount is, for example, when there are many customers and there are many sales details, and when it is necessary to check the unit price conversion such as weight, volume, quantity, etc. for both the company and the customer (for example, non-ferrous metal (Industry, chemical industry), which often occur when there is a recognition error, and the processing of the difference increases the load on the accounting business. Conventionally, there are many cases where the system is operated by EXCEL or the like, and the site manager and the accounting manager input data twice.

  Therefore, in the present embodiment, in order to reduce the accounting work for the difference processing, the payment schedule information, the payment result information and the difference management for managing the difference are managed to realize the unified management of the payment schedule and the result. I do. More specifically, when there is a difference between the scheduled payment of receivables and the actual amount of payment, select the reason for the difference (foreign money, unit price difference, transfer fee, miscellaneous / miscellaneous income) for each difference item, Create accounting entries (miscellaneous loss / miscellaneous income, transfer fee) according to the reason for the miscalculation. Further, an approval function may be implemented, and after selecting the reason for the difference, approval (sales manager, accounting department) may be performed, and after approval, an accounting entry may be generated.

[2. Constitution]
The configuration of difference management apparatus 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram illustrating an example of a configuration of a difference management device 100 according to the present embodiment.

  The difference management device 100 is a commercially available desktop personal computer. Note that the difference management apparatus 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, but may be a portable personal computer such as a notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, or a tablet personal computer. It may be an information processing device.

  As shown in FIG. 1, the difference management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the difference management apparatus 100 is communicably connected via an arbitrary communication path.

  The communication interface unit 104 communicably connects the difference management device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of communicably connecting the difference management device 100, the server 200, and a terminal device (not shown), and is, for example, the Internet, a LAN (Local Area Network), or the like. Note that data stored in the storage unit 106 described later may be stored in the server.

  An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that realizes a pointing device function in cooperation with a mouse can be used. In the following, the output device 114 may be described as a monitor 114 and the input device 112 may be described as a keyboard 112 or a mouse 112. In addition, displaying a user's operation on the screen of the output device (monitor) 114 and operating the input device 112 may be referred to as “user operation via a UI”.

  The storage unit 106 stores various databases, tables, files, and the like. In the storage unit 106, a computer program for performing various processes by giving instructions to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) and a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk can be used.

  The storage unit 106 stores a miscalculation reason master 106a, a sales data file 106b, a billing data file 106c, a deposit data file 106d, a deposit application data file 106e, a journal file 106f, and the like. FIG. 2 is a diagram illustrating a configuration example of the miscalculation reason master 106a.

  The miscalculation reason master 106a is to be referred to when creating a journal regarding the difference between the deposit amount and the scheduled recovery amount. As shown in FIG. 2, the miscalculation reason master 106a is configured by a table or the like in which data of a miscalculation reason code, a miscalculation reason name, whether to create a miscalculation journal, a debit account of a journal, and a credit account of a journal are registered in association with each other. be able to.

  The difference reason code "1" has the name of the difference reason "next month account", the presence or absence of creation of a difference journal "none", the debit account item "none", and the credit account item "none". Since the difference will be credited after the next month, there is no need for a differential journal.

  The difference reason code “2” includes the name of the difference reason “unit price difference”, the presence / absence of creation of the difference journal “none”, the debit account item “none”, and the credit account item “none”. This is a misperception of the selling price. Since it is necessary to pursue accounting according to the conditions of contracts, etc., there is no need for extra accounting entries.

  The miscalculation reason code “3” includes the name of the miscalculation reason “quantity difference”, the presence / absence of creation of a misregistration journal “Yes”, the debit account item “miscellaneous loss”, and the credit account item “miscellaneous income”. This is a difference due to an error in the actual weight, volume, or the like. Closed as miscellaneous income / loss on accounting.

  The miscalculation reason code “4” includes the name of the miscalculation reason “transfer fee”, the presence / absence of creation of an unbalanced journal entry “Yes”, the debit account “transfer fee”, and the credit account item “transfer fee”. This is deducted from the transfer fee and accounted for as a justification for the transfer and closed. This is because there is practically no case where accounts receivable> payment.

  The miscalculation reason code "5" includes the name of the miscalculation reason "miscellaneous loss / miscellaneous income", the presence / absence of creation of an unaccounted journal entry "Yes", the debit account item "miscellaneous loss", and the credit account item "miscellaneous income". Other minor errors are closed as miscellaneous income / loss in accounting.

  The sales data file 106b is a file for storing sales data (collection scheduled data). The sales data may include data of a sales number, a sales day, a sales number, a sales unit price, a sales amount, a consumption tax amount, a scheduled recovery amount, a product name, a billing address, whether or not the application has been completed, and an application amount. (See FIG. 5A).

  The billing data file 106c is a file for storing billing data. The billing data may include billing number, billing date, previous billing amount, deposit amount, carryover amount, sales amount, consumption tax amount, current billing amount, scheduled collection date, and billing destination data (FIG. 5 (C) )reference).

  The deposit data file 106d is a file for storing the deposit data. The deposit data may include a deposit number, a deposit date, a denomination, a deposit amount, a funding source, and data of a billing destination (see FIG. 5D).

  The deposit application data file 106e is a file for storing deposit application data. The payment application data may include data of a payment application number, an application line number, a payment number, a payment date, a payment application amount, a sales number, a difference reason, and a difference amount (FIG. 6F). reference).

  The journal file 106f is a file for storing journal data.

  The control unit 102 is a CPU or the like that controls the difference management device 100 as a whole. The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various types of information processing based on the stored programs. Execute. The control unit 102 conceptually includes a sales accounting processing unit 102a, a billing processing unit 102b, a payment processing unit 102c, an application processing unit 102d, a journal creation unit 102e, and a master maintenance unit 102f.

  When there is sales, the sales accounting processing unit 102a creates sales data (scheduled collection data) and stores it in the sales data file 106b.

  The billing processing unit 102b creates billing data and stores it in the billing data file 106c. The billing processing unit 102b may output (issue) a bill based on the billing data.

  When there is a payment from a business partner, the payment processing unit 102c creates payment data and stores it in the payment data file 106d.

  The clearing processing unit 102d clears the expected recovery amount of the sales data and the paid amount of the payment data. When there is a difference, the clearing processing unit 102d selects the reason for the difference according to the operation of the operator, and performs the clearing when the selected reason for the difference is a predetermined reason. The predetermined reason may include, for example, a difference in quantity, a transfer fee, and miscellaneous collection / damage.

  The journal creation unit 102e uses the selected reason for difference as a key, refers to the difference reason master 106a, acquires the presence or absence of creation of a journal, and obtains a debit account and a credit account of the journal. If no journal is created, the journal creation unit 102e deletes the journal. If no journal is created and journal creation is performed, the journal is created according to the debit account and credit account of the acquired journal.

  The master maintenance unit 102f displays a master maintenance screen (not shown) on the monitor 114 in accordance with an instruction of the operator, and inputs / changes data of the difference reason master 106a in accordance with an operation of the operator on the master maintenance screen.・ Perform editing such as addition.

[3. Specific example of processing]
With reference to FIGS. 1 to 7, a specific example of the processing of the difference management device 100 according to the present embodiment will be described. First, with reference to FIG. 3 and FIG. 4, an outline of the entire processing of the difference management apparatus 100 according to the present embodiment will be described. FIG. 3 is a flowchart for explaining an example of the overall processing of difference management apparatus 100 in the present embodiment. FIG. 4 is a flowchart for explaining the detailed journal creation processing. 5 and 6 are diagrams showing sample data. FIG. 7 is a diagram showing a display example (screen transition example) of the payment application screen.

  In FIG. 3, the sales accounting processing unit 102a executes a sales accounting process (step S1). In the sales accounting process, when there is sales, sales data (collection schedule data) is created and stored in the sales data file 106b.

  The billing processing unit 102b performs a billing process (Step S2). In the billing process, billing data is created and stored in the billing data file 106c, and a bill based on the billing data is output (issued).

  The deposit processing unit 102c executes a deposit process (step S3). In the payment processing, when payment is received from a business partner, payment data is created and stored in the payment data file 106d.

  The application processing unit 102d executes a payment application processing (step S4). In the payment application process, for example, a payment application screen (see FIG. 7) is displayed on the monitor 114, and the payment application data is created in accordance with an operation of the operator on the payment application screen, and the sales data is displayed. Apply the expected collection amount and the deposit amount of the deposit data. In addition, in the payment application process, if there is a difference, the reason for the difference is selected according to the operation of the operator on the payment application screen, and if the selected reason is a predetermined reason, the application is cleared. Do. The predetermined reason may include, for example, a difference in quantity, a transfer fee, and miscellaneous collection / damage.

  The journal creation unit 102e executes a journal creation process (step S5). In the journal creation process, using the selected reason for the difference as a key, referring to the difference reason master 106a, obtains the presence / absence of journal creation and obtains the debit account and credit account of the journal, and creates the journal if no journal creation is performed. If there is journal creation, the journal is created according to the debit account and credit account of the acquired journal.

  Next, a detailed process of the journal creation process will be described with reference to FIG. The rules for creating uncounted journals are as follows. The unscheduled journal is determined according to whether or not the unscheduled journal is created set in the unsuccessful reason master 106a according to the reason for the unsettled journal. The position of the receivables depends on the sign of the extra amount (plus or minus). For the receivable counter account, refer to “debit account” and “credit account” set according to the reason for the difference in the difference reason master 106a.

  In FIG. 4, first, the target payment application data is referred to (step S11). If the difference amount (difference) of the payment application data is not “0”, the subsequent processing is performed.

  With reference to the difference reason master 106a (step S12), using the difference reason code of the payment application data as a key, the presence / absence of creation of a difference journal and the debit account and credit account of the journal are acquired.

  Then, it is determined whether or not there is an unbalanced journal entry (step S13). If there is no extra journal entry, no extra journal entry is created (step S17). If there is a difference journal creation, the sign of the difference amount is determined (step S14), and if it is positive, a difference journal is created with the receivable difference amount (absolute value) / credit account item difference amount (absolute value) ( Step S15). In the case of a negative value, an unscheduled journal is created with the difference amount (absolute value) / receivable and the unsuccessful amount (absolute value) of the debit account (step S16).

  With reference to FIGS. 5 to 7, a specific data example of the processing of the difference management device 100 will be described. Hereinafter, the reconciliation and journal creation for the two sales shown in FIGS. 5A and 5B will be described.

(S1) Sales Accounting Processing In the example of the sales data (scheduled collection data) shown in FIG. 5A, the sales number “UR000001”, the sales date “2018/2/1”, the number of sales “2.12 g”, and the sales unit price “$ 100”, sales amount “$ 212”, consumption tax “$ 17”, scheduled recovery amount “$ 229”, product name “SV958”, billing destination “A Industry”, whether or not application is completed “uncompleted” And the amount of application “$ 0”. In this case, the journal is such that the debit is receivable “$ 229”, the credit is sales “$ 212”, and the consumption tax is “$ 17”.

  In the example of the sales data shown in FIG. 5B, the sales number “UR000002”, the sales date “2018/2/28”, the sales number “5.34 g”, the sales unit price “$ 100”, and the sales amount “$ 534” , Consumption tax “$ 43”, scheduled recovery amount “$ 577”, product name “SV950”, billing destination “A industry”, completion of application “uncompleted”, and application amount “$ 0”. I have. In this case, the journal is such that the debit is receivable “$ 577”, the credit is sales “$ 534”, and the consumption tax is “$ 43”.

(S2) Billing Process In the example of billing data shown in FIG. 5C, the billing number “SQ000002”, the billing date “2018/2/28”, the previous billing amount “$ 1,000”, and the deposit amount “$ 1, 000 ", carry-over amount" $ 1,000 ", sales amount" $ 746 ", consumption tax amount" $ 60 ", current billing amount" $ 806 ", scheduled recovery amount" $ 806 ", and billing destination" A Industry ". Has become.

(S3) Deposit Process In the example of the deposit data shown in FIG. 5D, the deposit number “NY000001”, the deposit date “2018/3/31”, the denomination “cash”, the deposit amount “$ 805”, and the consumption resources The amount is “$ 805” and the billing destination is “A Industry”. In this case, the journal is debited by cash “$ 805” and credited by provisional deposit “$ 805”.

  FIG. 5E shows an example of a supplier payment statement. For the purchase number “SH000001”, the purchase date “2018/2/21”, the purchase number “2.10 g”, and the purchase unit price “ $ 100, purchase price "$ 210", and consumption tax amount "$ 17". For the purchase number “SH000002”, the purchase date “2018/2/28”, the purchase number “5.35 g”, the purchase unit price “$ 100”, the purchase price “$ 535”, and the consumption tax amount “$” 43 ".

  The sales number “UR000001” of the sales data has the sales number “2.12 g” and the sales amount “$ 212”, whereas the purchase number “SH000001” of the supplier payment details has the purchase number “ 2.10 g "and the purchase price" $ 210 ". The sales number “UR000002” in the sales data is “5.34 g” in sales number and “$ 534” in sales amount, whereas the purchase number “SH000002” in the supplier payment details is The number is “5.35 g” and the purchase price is “$ 535”. This causes an error (error) when, for example, a difference occurs in the measurement result of the quantity (weight) with the supplier.

(S4) Deposit application processing (discount processing)
The following application is performed with the application amount “$ 805” of the payment number “NY000001”. If the reason for the miscalculation is clear (predetermined reasons: for example, a difference in quantity, transfer fee, miscellaneous income / miscellaneous loss), complete the clearing after registering the reason for the miscalculation and the amount of miscalculation.

  Here, the procedure for registering the reason for the difference and the amount of the difference and completing the application will be described with reference to the payment application screen of FIG. FIG. 7 is a diagram showing a display example (screen transition example) of the payment application screen. FIG. 7A shows an initial state display, FIG. 7B shows a case where a clearing target is designated by an operator operation, and FIG. 7C shows a case where a difference reason is registered by an operator operation.

  In the example of the payment application screen 400 shown in FIG. 7A, a header area 401 and an application details area 402 are displayed. In the header area 401, items such as a deposit number, a billing destination, a deposit amount, and an application fund amount are displayed. In the application details area 402, items such as an application box for specifying a line to be applied this time, a sales number, a product name, a scheduled collection amount, an application amount this time, a difference reason, a difference amount, and a total are displayed. Is done.

  In the header area 401, when the operator inputs the deposit number, the data of the billing destination, the deposit amount, and the applied funding amount of the corresponding deposit data are read out from the deposit data file 106d and displayed using the deposit number as a key.

  In the application details area 402, data of the sales number, product name, and expected collection amount of the sales data of the same billing destination and application completion status = “not completed” are read from the sales data file 106b and displayed. This time, “0” is displayed for the application amount, the reason for the difference is blank, and the application amount is automatically calculated and displayed as “the expected recovery amount of the sales data−the application amount”. Only the line for which the application box is checked can specify the application amount and the difference amount this time.

  In the example shown in FIG. 7A, the deposit number "NY000001" is input by the operator, and the billing destination "A industry" of the deposit data shown in FIG. “$ 805” and the amount of application fund “$ 805” are read and displayed.

  In the application details area 402, the sales data shown in FIGS. 5A and 5B of the same billing destination “A industry” and the application completion status = “not completed” are shown in the first and second lines. The sales number “UR000001”, the product name “SV958”, the expected collection amount “$ 229”, the sales number “UR000002”, the product name “SV950”, and the expected collection amount “$ 577” are read out and displayed, and , And "577" are displayed as the remaining balance.

  In FIG. 7 (B), when the operator checks the application box and designates an application target, the application amount is set to the remaining application amount, and the entire application amount is set. In the case of “applying amount> applying resource amount this time, it is not possible to register application information.

  In the example shown in FIG. 7B, the operator checks the check boxes in the first and second lines, sets the remaining application amount “$ 229” and “$ 577” to the current application amount, and deletes the entire amount. Is included. In addition, it is possible to input the reason for the difference and the amount of the difference. Since the amount of application “$ 806” this time> the amount of application source “$ 805”, application information cannot be registered as it is.

  In FIG. 7C, the operator inputs the reason for the difference and the amount of the difference for each line. When the user enters the error code, the error reason is read out from the error reason master 106a and displayed using the error code as a key. When the total value of the miscalculated amount is subtracted from the original application amount and the current application amount> application amount amount is resolved, the payment application data can be registered.

  In the example shown in FIG. 7C, the operator inputs, for example, the difference code “005” and the difference amount “$ −2” on the first line. The reason for miscalculation “miscellaneous damage / collection” corresponding to the difference code “005” is displayed. Further, for example, in the second line, the operator inputs the difference code “003” and the difference amount “$ 1”. The reason for the difference “quantity difference” corresponding to the difference code “003” is displayed. The applied funding amount is $ 805- (total of the miscalculated amounts $ -1 (=-$ 2 + $ 1)) = $ 806, and the status of "applied amount> applied resource amount this time is resolved, and the payment application data is You can register. When a registration button (not shown) is pressed, payment application data as shown in FIG. 6 (F) is created.

  It should be noted that an approval function may be implemented so that, for example, when the data of the screen shown in FIG. 7C is approved by the superior, the payment application data can be registered.

  In the example of the payment application data shown in FIG. 6F, the first line is a payment application number “NK000001”, an application line number “1”, a payment number “UR000001”, and a payment date “2018/3/31”. , The deposit application amount “$ 227”, the sales number “UR000001”, the reason for the miscalculation “005: miscellaneous collection / damage”, and the miscalculated amount “$ -2”.

  The second line is a deposit application number “NK000002”, an application line number “2”, a deposit number “UR000001”, a deposit date “2018/3/31”, a deposit application amount “$ 578”, and a sales number “UR000002”. , The reason for the difference “003: difference in quantity”, and the amount of the difference “$ 1”.

  When the payment application data is created (registered), the application source of the payment data is updated to “$ 806” as shown in FIG. In addition, in the payment application data linked with the sales number, the summary of the payment application amount-the difference amount is set to the application amount of the scheduled recovery amount, and the application is applied when the set application amount matches the planned recovery amount Complete. As shown in FIG. 7 (G), “$ 229” and “$ 577” are set to the application amounts of the first and second lines of the sales data, respectively, and the presence or absence of application completion is set to “completed”. Be updated.

(S5) Journal Creation Processing When a journal is created based on the payment application data shown in FIG. 7A, the first line is as shown in FIG. 6H, and the second line is as shown in FIG. 6I. Become. FIG. 6 (J) shows an example of these aggregated journals.

  The first line is the reason for the miscalculation “005: miscellaneous income and damage” and the amount of the miscalculation “$ −2”. As shown in FIG. 6 (H), the debit account is miscellaneous loss “$ 2” and the creditor is accounts receivable “$ 2”, because the presence / absence of the creation of unbalanced journal is “Yes” and the debit account item is “Miscellaneous loss”. .

  The second line is the reason for the difference "003: difference in quantity" and the difference amount "$ 1", so the reason for the difference "003: difference in quantity" in the difference reason master 106a shown in FIG. , And the credit account item “miscellaneous”, as shown in FIG. 6 (I), the debit becomes receivable “$ 1”, and the credit becomes miscellaneous revenue “$ 1”.

  As described above, according to the present embodiment, for each reason for the difference between the deposit amount and the scheduled recovery amount, whether or not to create a journal and a debit account master 106a in which the debit account and the credit account of the journal are registered are included. The amount of money received from the supplier and the amount to be collected are cleared, and if there is a difference, the reason for the difference is selected according to the operation of the operator. Using the reconciliation processing unit 102d for performing the reconciliation and the selected reason for the recalculation as a key, the presence / absence of creation of a journal and the debit account and the credit account of the corresponding journal are acquired from the reconciliation reason master 106a. Is not created, and there is journal creation, a journal creation unit 102e that creates journals in accordance with the debit account and credit account of the acquired journal is provided, so the difference between the expected recovery amount and the deposit amount is provided. But in the event of a miscalculation reason can be selected by the operator, it is possible to reduce the burden of accounting operations and create up to journal in accordance with the mishandled reason that you selected.

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

  For example, of the processes described in the embodiment, all or a part of the processes described as being performed automatically may be manually performed, or the processes described as being performed manually may be performed. All or part can be performed automatically by a known method.

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

  Also, regarding the difference management device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

  For example, all or any part of the processing functions provided in the difference management apparatus 100, particularly the processing functions performed by the control unit 102, are realized by the CPU and a program interpreted and executed by the CPU. Or may be realized as hardware by wired logic. The program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment. 100 is read mechanically. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM, and forms a control unit in cooperation with the CPU.

  Further, this computer program may be stored in an application program server connected to the difference management apparatus 100 via an arbitrary network, and it is also possible to download all or part of the computer program as needed. is there.

  Further, the program for executing the processing described in the present embodiment may be stored in a non-transitory 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 (registered). Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical Disc, Digital (Digital and Digital), DVD (Digital, Digital and Digital, etc.) Any "portable physical media It is intended to include.

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

  Various databases and the like stored in the storage unit 106 are storage devices such as a memory device such as a RAM and a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk. Programs, tables, databases, web page files, and the like.

  Further, the difference management device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as an information processing device to which an arbitrary peripheral device is connected. Further, the difference management device 100 may be realized by mounting software (including a program or data) for realizing the processing described in the present embodiment on the device.

  Furthermore, the specific form of the distribution / integration of the apparatus is not limited to the illustrated one, and all or a part of the apparatus may be functionally or physically separated in arbitrary units according to various additions or the like or according to the functional load. It can be configured to be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

100 Difference management device 102 Control unit 102a Sales accounting processing unit 102b Billing processing unit 102c Payment processing unit 102d Clearing processing unit 102e Journal creation unit 102f Master maintenance unit 104 Communication interface unit 106 Storage unit 106a Miscalculation reason master 106b Sales data file 106c Claim Data file 106d Deposit data file 106e Deposit application data file 106f Journal file 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (5)

A difference management device comprising a control unit and a storage unit,
In the storage unit,
For each reason for the difference between the deposit amount and the scheduled recovery amount, a master registering whether journal entries are created and the debit account and credit account of the journal is stored.
Reconcile the amount of money received from the supplier with the amount to be collected.If there is a difference, select the reason for the difference according to the operation of the operator.If the selected reason is the predetermined reason, apply Application processing means for performing
Using the selected reason for the difference as a key, obtain the presence / absence of journal creation from the master and the debit account and credit account of the journal. A journal creation means for creating a journal according to the debit account and the credit account of the acquired journal;
A balance management device, comprising:   2. The difference management apparatus according to claim 1, wherein the predetermined reasons include a difference in quantity, a transfer fee, and miscellaneous income / miscellaneous loss.   The master is set to have a journal created when the reason for the difference is a difference in quantity, a transfer fee, and miscellaneous income / miscellaneous, and set to no journal creation when the reason for the miscalculation is other than this. The difference management device according to claim 1. A difference management method executed by an information processing device including a control unit and a storage unit,
In the storage unit,
For each reason for the difference between the deposit amount and the scheduled recovery amount, the master that registers whether journals are created and the debit and credit accounts of the journals are stored,
Executed by the control unit,
Reconcile the amount of money received from the supplier with the amount to be collected.If there is a difference, select the reason for the difference according to the operation of the operator.If the selected reason is the predetermined reason, apply Clearing process step to perform
Using the selected reason for the difference as a key, obtain the presence / absence of journal creation from the master and the debit account and credit account of the journal. A journal creation step of creating a journal according to the debit account and the credit account of the acquired journal;
A difference management method characterized by including: A difference management program for causing an information processing device including a control unit and a storage unit to execute,
In the storage unit,
For each reason for the difference between the deposit amount and the scheduled recovery amount, the master that registers whether journals are created and the debit and credit accounts of the journals are stored,
In the control unit,
Reconcile the amount received from the supplier with the expected recovery amount.If there is a difference, select the reason for the difference according to the operation of the operator.If the selected reason is the predetermined reason, apply Clearing process step to perform
Using the selected reason for the difference as a key, obtain the presence / absence of journal creation from the master and the debit account and credit account of the journal. A journal creation step of creating a journal according to the debit account and the credit account of the acquired journal;
The difference management program to make it run.