JP2020107208A - Return adjustment device, return adjustment method, and return adjustment program - Google Patents

Abstract

To provide a return adjustment device capable of reducing the labor and mistakes of a person in charge in accounting processing when a contract is canceled midway after recording prepayment.SOLUTION: A return adjustment device 100 includes a storage unit 106 configured to store billing data including data on property information, transaction destination information, contract number, accounting date, payment erasure date, billing amount, and presence of sales journal creation, a billing data creation/updating unit 102a configured to create billing data and register it in the storage unit, refund data creation means 102b for reading, from the storage unit 106, when registering a return adjustment due to cancellation of a contract, data that has been cleared for payment without creation of a sales journal as a return target, out of target billing data, and creating refund data that has already been created as a sales journal, while making the billing amount as negative data, and the billing data creation/updating unit 102a configured to update, after the return adjustment registration, target billing data sales journal not created to sales journal created.SELECTED DRAWING: Figure 1

Description

The present invention relates to a return settlement device, a return settlement method, and a return settlement program.

For example, in the case of a contract in which one year's rent, insurance premiums, etc. are received in a lump sum, the advance payment is recorded in a lump sum and then sales are recorded in monthly installments. As a prior art relating to the recording of advance payment, there is Patent Document 1, for example. In the device of Patent Document 1, the unearned revenue (or down payment) is recorded when new correspondence data is stored for the sales data and the deposit data, and each month when the sales amount data is apportioned arrives. , Apportioned sales amount is recorded as sales, and the advance payment income (or advance payment) is reduced each time.

JP, 2011-159260, A

However, Patent Document 1 does not describe anything about the accounting process in the case where the contract is canceled midway after the advance payment is collectively recorded.

The present invention has been made in view of the above, and in the accounting process when the contract is canceled midway after the advance payment is recorded, a return settlement device and a return device capable of reducing the trouble and mistake of the person in charge. The purpose is to provide a settlement method and a return settlement program.

In order to solve the above-mentioned problems and achieve an object, a return settlement device including a storage unit and a control unit, wherein the storage unit includes property information, supplier information, contract number, accounting date, and payment cancellation. The billing data including the date of incorporation, the billing amount, and the data of whether or not the sales journal is created is stored, and the control unit creates a billing data and registers it in the storage unit, and a contract cancellation. In the case of registering the refund settlement associated with, out of the target billing data from the storage unit, the data that has not been created for the sales journal and has been cleared for payment is read as the refund target, and the billing amount is made negative data, It comprises a refund data creating means for creating refund data for which a sales journal has been created, and a billing data updating means for updating the sales journal created for the target billing data after registration of return settlement to the sales journal created It is characterized by

Further, according to a preferred aspect of the present invention, it may further include a journal creating means for creating a journal based on the billing data or the refund data.

In order to solve the above-mentioned problems and to achieve the object, the present invention is a return settlement method executed by an information processing device including a storage unit and a control unit, wherein the storage unit stores property information. , Billing data including supplier information, contract number, accounting date, payment application date, billing amount, and sales journal creation presence/absence data are stored, and the billing data to be executed by the control unit is created. In the billing data creation step of registering in the storage unit with the above, and in the case of registering a refund due to cancellation of a contract, among the billing data to be targeted from the storage unit, data for which a sales journal has not been created and payment has been cleared. Refund data creation process that reads out as a refund target, sets the billing amount as negative data, and creates refund data with sales journal created, and does not create a sales journal for the target billing data after registering the refund settlement And a billing data updating step for updating the sales journal to the created sales journal.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is a return settlement program to be executed by an information processing apparatus including a storage unit and a control unit, wherein the storage unit has:
Billing data including property information, supplier information, contract number, accounting date, deposit application date, billing amount, and sales journal creation data is stored, and the billing data to be executed by the control unit is stored. In the billing data creation process of creating and registering in the storage unit, and in the case of registering a refund due to cancellation of a contract, of the target billing data from the storage unit, the sales journal has not been created and the payment has been cleared. Refund data creation process that reads out the data of as a refund target, sets the billing amount as negative data, and creates refund data that the sales journal has already been created, and after registering the return payment, the sales journal of the targeted billing data It is a return settlement program for executing a billing data updating step of updating no preparation to sales journal preparation completed.

According to the present invention, it is possible to reduce the trouble and mistake of the person in charge in the accounting process when the contract is canceled halfway after the advance payment is recorded.

FIG. 1 is a block diagram showing an example of the configuration of the return settlement device according to the present embodiment. FIG. 2 is a diagram showing a configuration example of the management item master. FIG. 3 is a flow chart for explaining the overall processing flow of the control unit of the return settlement device according to the present embodiment. FIG. 4 is a diagram showing sample data for explaining a specific example of the process of the control unit of the return settlement device according to the present embodiment. FIG. 5 is a diagram showing a display example of the return settlement registration screen.

Embodiments of the present invention will be described in detail with reference to the drawings. The present invention is not limited to this embodiment.

[1. Overview]
In the case of a contract that deposits rent and insurance premiums for one year in a lump sum, after recording the advance payment in a lump sum, the sales will be recorded in monthly installments. In the conventional system, when the lump sum payment (prepayment) process is performed for the rent request for one year, the corresponding claim data cannot be operated. Therefore, if the contract is canceled in the middle of the contract, it will not be possible to stop the monthly split sales recording, and it will be troublesome to check the accounting book for the refund information and manually enter the payment. There were mistakes.

More specifically, in the conventional system, advance payment is recorded by associating the deposit application data with the billing data. When the billing date of the billing data arrives, a transfer journal for transferring from the down payment item to the sales item is generated. However, billing data that has been once cleared cannot be deleted, and if cancellation is decided before sales are recorded, it is necessary to follow the steps (1) and (2) below. (1) Create a negative amount of billing for the corresponding billing data so that sales are not recorded. (2) In order to perform refund processing, the refund amount is calculated and entered separately on the payment registration screen.

Therefore, in the present embodiment, when the contract is canceled during the contract, the contractor is refunded during the contract, but the planned sales receipt is stopped while the scheduled advance payment is refunded.

Specifically, in the present embodiment, the system automatically calculates the billing amount that has been booked in advance and has not been recorded for sales, generates refund data from the amount, and suspends sales of the corresponding sales data at the same time. This makes it possible to reduce the trouble and mistakes of the person in charge in the accounting process when the contract is canceled midway after the advance payment is recorded.

[2. Constitution]
An example of the configuration of the return settlement device 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 return settlement device.

The return payment device 100 is, for example, a commercially available desktop personal computer. The return settlement device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable type such as a commercially available notebook type personal computer, PDA (Personal Digital Assistants), smartphone, tablet type personal computer. It may be an information processing device.

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

The communication interface unit 104 communicatively connects the return settlement device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the return settlement device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

An input device 112 and an output device 114 are connected to the input/output interface unit 108. As the output device 114, a monitor (including a home-use television), a speaker, and a printer can be used. As the input device 112, a keyboard, a mouse, a microphone, and a monitor that realizes a pointing device function in cooperation with the mouse can be used. In the following, the output device 114 may be described as the monitor 114 or the screen 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

The storage unit 106 stores a computer program for giving instructions to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes. 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.

The storage unit 106 also stores a data file 106a, a management item master 106b, and the like. FIG. 2 is a diagram showing a configuration example of the management item master 106b.

The data file 106a is for storing various data such as billing data and refund data. The billing data may include data on property, supplier CD, contract number, accounting date, deposit application date, management item CD, amount, consumption tax amount, whether or not a journal has been created, and whether or not to be refunded ( See FIG. 4(A).

Refund data may include data on property, supplier CD, contract number, settlement statement issue date, settlement date, management item CD, amount, consumption tax amount, and whether or not a journal has been created (FIG. 4(B)). reference).

The management item master 106b is a master that defines transaction items that are indispensable for various billing/payment input. The management item master 106b determines the subject when the accounting journal is created, and the form print name when the invoice is issued. As shown in FIG. 2, the management item master 106b can be composed of a table or the like in which data of management items CD, sales items, and unaccepted items are registered in association with each other. In the example of the management item master 106b shown in FIG. 2, the management item CD is "101010", the sales item is "rent income", and the advance item is "advance payment".

The control unit 102 is a CPU or the like that totally controls the return settlement 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, and required data, and performs various information processing based on these stored programs. Execute. Conceptually, the control unit 102 includes a billing data creation/update unit 102a, a refund data creation unit 102b, a journal entry creation unit 102c, a screen display control unit 102d, and a master maintenance unit 102e.

The billing data creating/updating unit 102a creates billing data according to, for example, an operator's operation on a billing data creation screen (not shown), and registers the billing data in the data file 106a. Further, the billing data creating/updating unit 102a, after the return settlement registration, updates the target billing data with no sales journal created to sales journal created.

The refund data creation unit 102b creates, for example, sales journal creation of target billing data from the data file 106a when registering a refund payment associated with cancellation of a contract in accordance with an operator's operation on the refund payment registration screen. Data that is not present and has already been applied for payment is read out as a return target, the invoice amount is set as negative data, and the refund data that the sales journal has been created is created.

The journal creating unit 102c creates a sales journal according to the setting of the management item master 106b based on the billing data and the refund data.

The screen display control unit 102d controls display/input acceptance of various screens displayed on the monitor 114 (for example, return payment registration screen, billing data input screen, master maintenance screen, etc.).

The master maintenance unit 102e edits, for example, data input/addition/change/update with respect to the management item master 106b in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114. (Set).

[3. Specific example of processing]
A specific example of the process of the control unit 102 of the return settlement device 100 according to the present embodiment will be described with reference to FIGS. 1 to 5. FIG. 3 is a flow chart for explaining the overall processing flow of the control unit 102 of the return settlement device 100 according to the present embodiment.

The overall processing flow of the control unit 102 of the return settlement device 100 in the present embodiment will be described with reference to FIGS. 1 and 3. In FIG. 3, the billing data creating/updating unit 102a creates billing data in accordance with, for example, an operator's operation on a billing data creation screen (not shown) and registers it in the data file 106a (step S1).

The refund data creation unit 102b creates, for example, sales journal creation of target billing data from the data file 106a when registering a refund payment associated with cancellation of a contract in accordance with an operator's operation on the refund payment registration screen. Data that is not present and has already been applied for payment is read out as a return target, the charged amount is set as negative data, and the refund data that the sales journal is created is created and registered in the data file 106a (step S2).

After the return settlement registration, the billing data creation/updating unit 102a updates the target billing data with no sales journal created to sales journal created (step S3).

FIG. 4 is a diagram showing sample data for explaining a specific example of the processing of the control unit 102 of the return settlement device 100 in the present embodiment. In FIG. 4, (A) is an image of the remittance target billing data, (B) is an image of the refund data created by the refund settlement registration, and (C) is an image of the billing data updated by the refund settlement registration. FIG. FIG. 5 is a diagram for explaining a display example of a return settlement registration screen.

Here, the one-year rent for October 2018 to September 2019 was paid in 2018/09/26 in a lump sum, but it was canceled on 2018/12/15 and the amount for December 2018 Explain the case of refund from rent.

The refund data is created and the billing data is updated according to the operator's operation on the return settlement registration screen shown in FIG.

In FIG. 5, on the return settlement registration screen 400, the supplier code and the delivery address code to be refunded are input. In the example shown on the screen 400, the supplier code “10000020” and the recipient code “1” are entered. When the "return" button is pressed, the billing data of the data file 106a is read using the supplier code as a key and displayed on the return target specifying screen 401. On the screen 401, if you specify a billing number (contract number) that received a lump sum payment, items that can be returned will be displayed in the refundable billing data (details that have not been created for sales journals and payments have been cleared). And press "Display F10". When "Display F10" is pressed, the screen for return settlement registration is returned to, and the payment amount is displayed as shown in screen 402, and when "F10 registration" is pressed, refund data is created (step S2 in FIG. 3), The billing data, which is the corresponding original data, is updated to a state in which sales are not recorded (step S3 in FIG. 3).

In FIG. 4(A), the billing data is subject to refund in the refund settlement registration in which the sales journal has not been recorded and the payment has been cleared. In the example of the billing data shown in FIG. 4, the first line is the property “1001 Kyobashi Building”, the customer's CD “10000020”, the contract number “000000000036969-00”, the accounting date “2018/10/31”, and the payment application The date is “2018/9/30”, the management item CD is “101010”, the amount is “¥100,000”, the consumption tax is “¥8,000”, and the journal has been created “◯”. The second line is the property “1001 Kyobashi Building”, customer CD “10000020”, contract number “0000000000369-00”, accounting date “2018/11/30”, payment application date “2018/9/30”, management The item CD is “101010”, the amount is “¥100,000”, the consumption tax is “¥8,000”, and the journal has been created “◯”.

The third line is the property “1001 Kyobashi Building”, customer CD “10000020”, contract number “000000000036969-00”, accounting date “2018/12/31”, deposit application date “2018/9/30”, management The item CD is “101010”, the amount is “¥100,000”, and the consumption tax amount is “¥8,000”. The 4th line is the property “1001 Kyobashi Building”, customer CD “10000020”, contract number “000000000036969-00”, accounting date “2019/1/31”, deposit application date “2018/9/30”, management The item CD is “101010”, the amount is “¥100,000”, and the consumption tax amount is “¥8,000”.

In FIG. 4B, the details called as the refund data in the return payment registration are called with the corresponding bill as negative data. The journal entry creation unit 102c can create a journal entry for a down payment/checking account by being called as negative data in the sales journal accounted state.

In the example of the refund data shown in FIG. 4B, the 1st to 10th rows are the property “1001 Kyobashi Building”, the customer's CD “10000020”, the contract number “000000000036969-00”, and the settlement statement issuance date “2018/12/”. 15”, settlement date “2018/12/30”, management item CD “101010”, amount “¥−100,000”, consumption tax amount “¥−8,000”, and journal created “○”. ..

In FIG. 4C, after the return settlement registration is completed, the invoicing data of the caller is updated as the sales journal has been recorded, and the sales are not recorded. In the example of the billing data shown in FIG. 4C, the presence or absence of the sales journal creation on the 3rd to 10th lines is updated from "not created" to "created".

As described above, according to the present embodiment, the storage for storing the billing data including the property information, the supplier information, the contract number, the accounting date, the payment application date, the billing amount, and the sales journal creation presence/absence data. Of the target billing data from the storage unit 106 when the unit 106, the billing data creating/updating unit 102a that creates billing data and registers it in the storage unit 106, and the return settlement registration associated with the cancellation of the contract The billing data is provided with a refund data creation unit 102b that reads out the data that has not been created as a journal entry and has already been applied for payment as a return target, sets the billing amount as negative data, and creates the refund data that has already created the sales journal entry. Since the creating/updating unit 102a decides to update the sales journal created in the target billing data to the sales journal created after the return settlement registration, if the contract is canceled midway after the advance payment is recorded. It becomes possible to reduce the trouble and mistakes of the person in charge in the accounting process.

[4. Other Embodiments]
The present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims other than the above-described embodiments.

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

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

Further, regarding the return settlement device 100, the respective constituent elements shown in the drawings are functionally conceptual, and are not necessarily physically configured as shown.

For example, the processing functions of the return settlement device 100, particularly the respective processing functions performed by the control unit 102, are realized in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, the hardware may be realized by wired logic. The program is recorded in a non-transitory computer-readable recording medium that includes programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment, and the return settlement apparatus is used as necessary. Mechanically read to 100. 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 in the RAM, and constitutes a control unit in cooperation with the CPU.

Further, this computer program may be stored in an application program server connected to the return settlement device 100 via an arbitrary network, and it is possible to download all or a part of it as necessary. is there.

Further, the program for executing the processing described in this 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 disk), MO (Magneto-Optical disk), etc. It shall include any "portable physical medium".

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

Various databases and the like stored in the storage unit 106 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, and the like.

Further, the return settlement 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 any peripheral device is connected. The return payment device 100 may be realized by mounting software (including a program, data, or the like) for realizing the processing described in the present embodiment in the device.

Further, the specific form of the distribution/integration of the devices is not limited to that shown in the drawings, and all or a part of them may be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be implemented in any combination, or the embodiments may be selectively implemented.

100 Return Payment Device 102 Control Unit 102a Billing Data Creation/Update Unit 102b Refund Data Creation Unit 102c Journal Entry Creation Unit 102d Screen Display Control Unit 102e Master Maintenance Unit 104 Communication Interface Unit 106 Storage Unit 106a Data File 106b Management Item Master 108 Input/Output Interface Part 112 Input device 114 Output device 200 Server 300 Network

Claims (4)

A return and settlement device including a storage unit and a control unit,
In the storage unit,
Stores billing data including property information, business partner information, contract number, accounting date, payment application date, billing amount, and sales journal creation data,
The control unit is
Billing data creating means for creating the billing data and registering the billing data in the storage unit;
When registering a refund due to cancellation of a contract, of the target billing data from the storage unit, the data that has not been created for sales journals and has already been applied for payment is read as the refund target, and the billing amount is regarded as negative data. At the same time, a refund data creation means for creating refund data that has already been created as a sales journal,
Billing data updating means for updating the sales journal created in the target billing data after the return settlement registration to the sales journal created,
A return and settlement device characterized by being equipped with. The return settlement apparatus according to claim 1, further comprising a journal creating unit that creates a journal based on the billing data or the refund data. A return settlement method executed by an information processing device including a storage unit and a control unit,
In the storage unit,
Stores billing data including property information, business partner information, contract number, accounting date, payment application date, billing amount, and sales journal creation data,
Executed in the control unit,
A billing data creating step of creating the billing data and registering the billing data in the storage unit;
When registering a refund due to cancellation of a contract, of the target billing data from the storage unit, the data that has not been created for sales journals and has already been applied for payment is read as the refund target, and the billing amount is regarded as negative data. At the same time, a refund data creation process that creates refund data that has already been created as a sales journal,
A billing data updating step of updating, after the return settlement registration, the sales journal creation of the target billing data which has not been created to the sales journal creation completed,
A return and settlement method comprising: A return settlement program to be executed by an information processing device including a storage unit and a control unit,
In the storage unit,
Stores billing data including property information, business partner information, contract number, accounting date, payment application date, billing amount, and sales journal creation data,
In the control unit,
A billing data creating step of creating the billing data and registering the billing data in the storage unit;
When registering a refund due to cancellation of a contract, of the target billing data from the storage unit, the data that has not been created for sales journals and has already been applied for payment is read as the refund target, and the billing amount is regarded as negative data. At the same time, a refund data creation process that creates refund data that has already been created as a sales journal,
A billing data updating step of updating, after the return settlement registration, the sales journal creation of the target billing data which has not been created to the sales journal creation completed,
Return payment program to execute.

Images