JP7186088B2 - Return settlement device, return settlement method, and return settlement program - Google Patents

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 a year's rent and insurance premiums are paid in a lump sum, after recording advance receipts in a lump sum, sales are recorded in monthly installments. For example, Japanese Patent Application Laid-Open No. 2002-300000 discloses a prior art related to accounting for advance receipts. In the apparatus of Patent Document 1, when new corresponding data is stored for sales data and payment data, advance income (or advance payment) is recorded, and sales amount data is proportionally divided each month. , the proportionally divided sales amount is recorded as sales, and the advance receipt income (or advance receipt) is reduced each time.

Japanese Unexamined Patent Application Publication No. 2011-159260

However, Japanese Patent Application Laid-Open No. 2002-200002 does not describe anything about the accounting process when the contract is canceled in the middle after all advance payments are recorded.

The present invention has been made in view of the above. The purpose is to provide a settlement method and a return settlement program.

In order to solve the above-mentioned problems and achieve the purpose, a return settlement device equipped with a storage unit and a control unit, wherein the storage unit stores property information, business partner information, contract number, accounting date, payment transaction billing data including billing date, billing amount, and data on whether or not to create a sales journal; When registering the return settlement associated with , among the target billing data from the storage unit, data that has not been created with sales journals and has been reconciled for payment is read out as a return target, and the billed amount is set as negative data, refund data creation means for creating refund data indicating that sales journal has been created; and billing data update means for updating non-sales journal creation of the target billing data to sales journal created after registration of refund settlement. characterized by

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

Further, in order to solve the above-described problems and achieve the object, the present invention provides a return settlement method executed by an information processing apparatus having a storage unit and a control unit, wherein the storage unit stores property information , customer information, contract number, recording date, payment reconciliation date, billing amount, and billing data including data on whether sales journals are created or not are stored. billing data creation step to be registered in the storage unit in accordance with the above; is read out as a refund target, the invoiced amount is set as negative data, and refund data is created as if the sales journal has already been created. and a billing data update step for updating the sales journal to completed.

Further, in order to solve the above-described problems and achieve the object, the present invention provides a return settlement program to be executed by an information processing apparatus having a storage unit and a control unit, wherein the storage unit includes:
Billing data including property information, business partner information, contract number, recording date, payment reconciliation date, billing amount, and data on whether or not sales journals are created are stored, and the billing data executed by the control unit is Billing data creation step of creating and registering in the storage unit, and in the case of registering refund settlement due to contract cancellation, among the billing data to be processed from the storage unit, sales journals are not created and payment has been reconciled a refund data creation step of reading out the data as a refund target, making the invoiced amount negative data, and creating refund data indicating that the sales journal has already been created; and a billing data update step of updating non-created to sales journal created.

Advantageous Effects of Invention According to the present invention, there is an effect that it is possible to reduce the trouble and mistakes of the person in charge in the accounting processing when the contract is canceled in the middle after recording the advance received.

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

An embodiment of the present invention will be described in detail based on the drawings. In addition, this invention is not limited by this embodiment.

[1. Overview]
In the case of a contract in which one year's rent and insurance premiums are paid in a lump sum, after recording the advance receipt in a lump sum, sales are recorded in monthly installments. In the conventional system, if lump-sum payment (advance payment) processing was performed for rent billing for one year, the corresponding billing data could not be manipulated. Therefore, if the contract is canceled in the middle, it will not be possible to stop recording monthly installment sales, and it will be troublesome to check the accounting books and manually calculate and enter the payment information for the refund information. or mistakes occurred.

More specifically, in the conventional system, advance receipts are recorded by associating payment reconciliation data with billing data. When the billing data recording date arrives, a transfer journal entry is generated that transfers from the advance receipt account to the sales account. However, billing data once reconciled cannot be deleted, and if cancellation is decided before sales are recorded, the following procedures (1) and (2) must be taken. (1) Create a bill with a negative amount for the relevant billing data so that it is not recorded as sales. (2) Calculate and enter the refund amount separately on the payment registration screen in order to process the refund.

Therefore, in the present embodiment, when cancellation occurs during the contract, a refund is made to the contractor during the contract, but the recording of scheduled sales is stopped while the refund is made from the advance received that has been recorded.

Specifically, in this embodiment, the system automatically calculates the billing amount that has been recorded as an advance receipt and has not been recorded as sales, generates refund data from that amount, and simultaneously suspends sales of the corresponding sales data. As a result, it is possible to reduce the labor and mistakes of the person in charge of the accounting process when the contract is canceled in the middle after recording the advance received.

[2. Constitution]
An example of the configuration of the return settlement apparatus according to this embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of a return settlement device.

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

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

The communication interface unit 104 communicably 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 another device via a communication line. Here, the network 300 has a function of connecting the return settlement apparatus 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 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that realizes a pointing device function in cooperation with a mouse. Note that, hereinafter, the output device 114 may be referred to as the monitor 114 or the screen 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112. FIG.

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

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. Billing data may include property, business partner CD, contract number, recording date, payment reconciliation date, management item CD, amount, consumption tax amount, whether or not journal entries have been created, and whether or not refunds are applicable ( See FIG. 4(A)).

The refund data may include data on property, business partner CD, contract number, settlement statement issue date, settlement date, management item CD, amount, consumption tax amount, and whether or not journal entries have been created (Fig. 4 (B) reference).

The management item master 106b is a master defining transaction items that are absolutely necessary when inputting various billing/payments. With this management item master 106b, items when creating accounting journals are determined, and the names of forms to be printed when issuing invoices are determined. As shown in FIG. 2, the control item master 106b can be composed of a table or the like in which the data of the control item CD, sales item, and pre-accepted item are associated and registered. 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 receipt item is "advance receipt".

The control unit 102 is a CPU or the like that comprehensively controls the return settlement apparatus 100 . 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 information processing based on these stored programs. Run. The control unit 102 functionally and conceptually includes a billing data creation/update unit 102a, a refund data creation unit 102b, a journal 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. In addition, the billing data creating/updating unit 102a updates the non-creation of the sales journal of the subject billing data to the created sales journal after the refund settlement registration.

The refund data creating unit 102b, for example, in response to the operation of the operator on the refund settlement registration screen, when registering the refund settlement due to the cancellation of the contract, creates a sales journal among the target billing data from the data file 106a. The data for which there is no payment and whose payment has been reconciled is read out as a refund target, and the charged amount is set as negative data, and refund data indicating that the sales journal entry has been created is created.

The journal creation 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, for example, controls the display and input acceptance of various screens (eg, refund settlement registration screen, billing data input screen, master tamaintenance screen, etc.) displayed on the monitor 114. FIG.

For example, the master maintenance unit 102e edits the management item master 106b by inputting, adding, changing, or updating data in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114. (setting).

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

The overall processing flow of the control unit 102 of the return settlement apparatus 100 according to the present embodiment will be described with reference to FIGS. 1 and 3. FIG. In FIG. 3, 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 it in the data file 106a (step S1).

The refund data creating unit 102b, for example, in response to the operation of the operator on the refund settlement registration screen, when registering the refund settlement due to the cancellation of the contract, creates a sales journal among the target billing data from the data file 106a. The data for which there is no payment and whose payment has been reconciled is read out as a refund target, and the billed amount is set as negative data, and refund data indicating that the sales journal has been created is created and registered in the data file 106a (step S2).

After registering the refund settlement, the billing data creating/updating unit 102a updates the non-creation of the sales journal of the target billing data to the created sales journal (step S3).

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

Here, the rent for one year from October 2018 to September 2019 was paid in a lump sum on September 26, 2018, but there was a cancellation on December 15, 2018, and the rent for December 2018 Explain the case of refunding from the rent.

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

In FIG. 5, on the return settlement registration screen 400, the customer code and the destination code to be refunded are entered. In the example shown on the screen 400, a supplier code "10000020" and a destination code "1" are entered. When the "Return" button is pressed, billing data is read from the data file 106a using the supplier code as a key, and displayed on the screen 401 for specifying the return object. On the screen 401, if you specify the billing number (contract number) of the lump sum payment, items that can be checked for refund are displayed in the billing data that can be refunded (details without sales journal creation and payment has been applied). and press "F10 display". When "F10 display" is pressed, the screen returns to the refund settlement registration screen, and the payment amount is displayed as shown in screen 402. 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 so that sales are not recorded (step S3 in FIG. 3).

In FIG. 4(A), among the billing data, the refund of the return settlement registration for which the sales journal has not been recorded and the payment has been applied is subject to refund. In the example of billing data shown in FIG. The date is “2018/9/30”, the control item CD is “101010”, the amount is “¥100,000”, the consumption tax amount is “¥8,000”, and the journal entry has been created “◯”. The second line is the property "1001 Kyobashi Building", the customer's CD "10000020", the contract number "0000000000369-00", the recording date "2018/11/30", the payment reconciliation date "2018/9/30", and the management Item CD "101010", amount "¥100,000", consumption tax amount "¥8,000", and journal entry completed "O".

The third line is the property "1001 Kyobashi Building", the customer's CD "10000020", the contract number "0000000000369-00", the recording date "2018/12/31", the payment reconciliation date "2018/9/30", the management The item CD is "101010", the amount is "¥100,000", and the consumption tax amount is "¥8,000". The fourth line is the property "1001 Kyobashi Building", the customer's CD "10000020", the contract number "0000000000369-00", the recording date "2019/1/31", the payment reconciliation date "2018/9/30", the management The item CD is "101010", the amount is "¥100,000", and the consumption tax amount is "¥8,000".

In FIG. 4(B), in the refund settlement registration, the details called up as refund data are called up with the corresponding claim as negative data. By being called as negative data in the sales journal entry state, the journal entry creation unit 102c can create a journal entry for the advance receipt/current account.

In the example of the refund data shown in FIG. 4(B), lines 1 to 10 are property "1001 Kyobashi Building", client CD "10000020", contract number "0000000000369-00", settlement statement issue date "2018/12/ 15”, settlement date “2018/12/30”, control item CD “101010”, amount “¥-100,000”, consumption tax amount “¥-8,000”, and journal entry created “〇” .

In FIG. 4C, after the return settlement registration is completed, the billing data of the caller is updated to indicate that the sales journal entry has been recorded, and the sales are not recorded. In the example of billing data shown in FIG. 4(C), the presence/absence of sales journal creation in lines 3 to 10 is updated from "not created" to "completed".

As described above, according to the present embodiment, a storage for storing billing data including property information, customer information, contract number, recording date, payment reconciliation date, billing amount, and data on whether or not sales journals are created a billing data creating/updating unit 102a that creates billing data and registers it in the storage unit 106; a refund data creation unit 102b that reads out data for which no journal entry has been created and for which payment has been applied as a refund target, sets the invoiced amount as negative data, and creates refund data indicating that the sales journal entry has already been created; After registering the refund settlement, the creating/updating unit 102a updates the non-creation of the sales journal for the target billing data to the created sales journal. In the accounting process, it is possible to reduce the labor and mistakes of the person in charge.

[4. Other embodiments]
The present invention may be implemented in various different embodiments other than the embodiments described above 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 can be manually performed, or the processes described as being performed manually can be performed manually. All or part of this can also be done automatically by known methods.

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

Also, with respect to the return settlement apparatus 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 by the return settlement device 100, particularly each processing function performed by the control unit 102, is realized by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processing described in the present embodiment, and if necessary, the return settlement device 100 mechanically read. That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

In addition, this computer program may be stored in an application program server connected to the return settlement apparatus 100 via any network, and it is possible to download all or part of it as necessary. be.

Also, the program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (registered (trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Disc (registered trademark) such as Blu- shall include any "portable physical medium".

A "program" is a data processing method written in any language or writing method, regardless of the format such as source code or binary code. In addition, the "program" is not necessarily limited to a single configuration, 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 in each device shown in the embodiments, the installation procedure after reading, and the like.

The various databases and the like stored in the storage unit 106 are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and are used for various processes and website provision. programs, tables, databases, and files for web pages.

The return settlement apparatus 100 may be configured as an information processing apparatus such as a known personal computer or workstation, or may be configured as the information processing apparatus to which any peripheral device is connected. Also, the return settlement apparatus 100 may be implemented by installing software (including programs, data, etc.) that causes the apparatus to implement the processing described in the present embodiment.

Furthermore, the specific forms of distribution and integration of devices are not limited to those shown in the figures, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

100 return settlement device 102 control unit 102a billing data creation/update unit 102b refund data creation unit 102c journal 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 Unit 112 Input device 114 Output device 200 Server 300 Network

Claims (4)

A return settlement device comprising a storage unit and a control unit,
The storage unit contains
Billing data including property information, business partner information, contract number, recording date, payment reconciliation date, billing amount, and data on whether or not sales journals are created are stored.
The control unit
billing data creating means for creating the billing data and registering it in the storage unit;
In the case of registering refund settlement due to cancellation of a contract, out of the billing data to be processed, data for which no sales journal entry has been created and payment has been reconciled is read out as a subject to be returned, and the billing amount is treated as negative data. In addition, a refund data creation means for creating refund data indicating that the sales journal has already been created;
billing data updating means for updating non-creation of sales journals of the subject billing data to sales journals created after return settlement registration;
A return settlement device characterized by comprising: 2. The refund settlement apparatus according to claim 1, further comprising journal creation means for creating a journal based on said billing data or said refund data. A refund settlement method executed by an information processing device having a storage unit and a control unit,
The storage unit contains
Billing data including property information, business partner information, contract number, recording date, payment reconciliation date, billing amount, and data on whether or not sales journals are created are stored.
Executed in the control unit,
a billing data creation step of creating the billing data and registering it in the storage unit;
In the case of registering refund settlement due to cancellation of a contract, out of the billing data to be processed, data for which no sales journal entry has been created and payment has been reconciled is read out as a subject to be returned, and the billing amount is treated as negative data. In addition, a refund data creation step of creating refund data indicating that the sales journal has already been created;
a billing data update step of updating non-created sales journals of the subject billing data to sales journals created after the return settlement registration;
A return settlement method characterized by including A return settlement program to be executed by an information processing device having a storage unit and a control unit,
The storage unit contains
Billing data including property information, business partner information, contract number, recording date, payment reconciliation date, billing amount, and data on whether or not sales journals are created are stored.
In the control unit,
a billing data creation step of creating the billing data and registering it in the storage unit;
In the case of registering refund settlement due to cancellation of a contract, out of the billing data to be processed, data for which no sales journal entry has been created and payment has been reconciled is read out as a subject to be returned, and the billing amount is treated as negative data. In addition, a refund data creation step of creating refund data indicating that the sales journal has already been created;
a billing data update step of updating non-created sales journals of the subject billing data to sales journals created after the return settlement registration;
Return settlement program for executing.

Images