JP6985129B2 - Credit / debt retroactive adjustment processing device, credit / debt retroactive adjustment processing method and credit / debt retroactive adjustment processing program - Google Patents

Description

The present invention relates to a credit / debt retroactive adjustment processing device, a credit / debt retroactive adjustment processing method, and a credit / debt retroactive adjustment processing program.

In Patent Document 1, it is possible to make payments for the payment month during the period when the accounting closing category is not closed even after the monthly closing processing of receivables, and it is possible to update the balance related to receivables during the payment period according to the transaction. .. In addition, if the beginning of the next month is not the closing of the accounting, the processing of the previous month can be carried over and the processing can be distributed to the next month, so that the load of the payment work at the end of the month can be reduced. Furthermore, in order to correct the misoperation of the deposit business discovered after the monthly receivable closing process and reduce the possibility that the data of the receivable system and the actual transaction status deviate from each other, the receivable clearing process is used.

Japanese Unexamined Patent Publication No. 2016-151943

However, in the above-mentioned Patent Document 1, when the billing content of the previous month is amended after the monthly closing process, it is not possible to eliminate the complexity of the billing business while grasping the monthly accounting results without delaying the monthly settlement. rice field. In particular, when making corrections after the monthly closing process, there is a risk that the process of correction will be unclear in accounting because the receivables are cleared.

The present invention has been made in view of the above, and even if the invoiced amount or payment amount is fixed after the accounting closing process and the claims and debts are renewed, it is possible to correct the invoiced amount or payment amount before the closing process. A credit / debt retroactive adjustment processing device, a credit / debt retroactive adjustment processing method, and a credit / debt retroactive adjustment processing program that can eliminate the complexity of the adjustment work while grasping the monthly accounting results without delaying the settlement work. The purpose is to provide.

In order to solve the above-mentioned problems and achieve the object, the credit / debt retroactive adjustment processing device according to the present invention is provided with a storage unit and a control unit, and retroactively states that the credit / debt is renewed after the accounting closing process. A credit / debt retroactive adjustment processing device for making adjustments, the storage unit includes an accounting data storage unit for storing accounting data, and the control unit acquires accounting data related to transactions and stores it in the accounting data storage unit. Accounting data acquisition means, accounting date determination means for determining the future relationship of accounting dates in the accounting data, and update for determining whether or not the claims and liabilities are updated after the accounting closing process and a difference is generated. A red-black processing means that corrects the amount by performing type determination means, red slip processing that cancels the original amount for the difference between the updated claims and debts, and black slip processing that records the new amount after the update. It is characterized by having.

In addition, the credit / debt retroactive adjustment processing device according to the present invention renews the credit / debt by recording sales for the order and renewing the amount of the claim to be billed, or recording the purchase and paying the order. It is characterized by being one of the renewals of the debt amount to be carried out.

Further, in the claim / debt retroactive adjustment processing apparatus according to the present invention, when the red-black processing means updates the amount of the claim after the accounting closing process and corrects the amount, the original "claim base date" is used for billing. When accounting data is managed using the "sales date" that indicates the accounting date, and the debt amount is updated and the amount is adjusted after the accounting closing process, the original "payment record date" is used for payment. It is characterized by managing accounting data using "purchase date" indicating the accounting date.

Further, in the credit / debt retroactive adjustment processing apparatus according to the present invention, when the red-black processing means manages sales data as the accounting data, if there is new sales for the order No., it is combined with the new sales No. The history category is set to "latest", the history category is set to "history red" when the red slip processing is performed, and the history category is set to "history black" when the black slip processing is performed. However, when the purchase data is managed as the accounting data, if there is a new purchase for the order No., it is combined with the new purchase No., the history classification is set to "latest", and the red slip processing is performed. The history category is set to "history red", and when the black slip processing is performed, the history category is set to "history black" and the order No. and the purchase No. are linked and managed.

Further, in the credit / debt retroactive adjustment processing apparatus according to the present invention, when the red-black processing means manages sales data as the accounting data, if there is new sales for the order No., it is combined with the new sales No. If the processing category is set to "new" and the sales amount is canceled before the accounting closing process, the processing category is set to "delete", and if the sales amount before the closing process is canceled after the accounting closing process, the processing category is set to "closed". If the sales amount after correction is recorded for the canceled order No., the processing category is set to "after adjustment after closing", and the difference in sales amount is set as the corrected amount for red-black processing, and the accounting data is used. When managing the purchase data, if there is a new purchase for the order No., it will be combined with the new purchase No. to set the processing category to "new" and cancel the purchase amount before the accounting closing process. If the processing category is set to "Delete" and the purchase amount before closing is canceled after the accounting closing process, the processing category is set to "Before correction after closing" and the purchased amount after correction for the canceled order No. The feature is that the processing category is set to "after adjustment" and the difference in the purchase amount is set to the corrected amount for red and black processing.

Further, the credit / debt retroactive adjustment processing method according to the present invention is executed by a credit / debt retroactive adjustment processing device that includes a storage unit and a control unit and retroactively corrects when there is an update of credit / debt after accounting closing processing. The storage unit includes an accounting data storage unit that stores accounting data, and acquires accounting data related to transactions executed by the control unit and stores the accounting data in the accounting data storage unit. The accounting data acquisition step to be stored, the accounting date determination step for determining the future relationship of the accounting date in the accounting data, and whether or not the claims and liabilities are updated after the accounting closing process and a difference is generated are determined. Red-black processing step to correct the amount by performing the update type determination step, the red slip processing that cancels the original amount for the difference between the updated claims and debts, and the black slip processing that records the new amount after the update. And, including.

Further, the credit / debt retroactive adjustment processing program according to the present invention is executed by a credit / debt retroactive adjustment processing device which has a storage unit and a control unit and retroactively corrects the renewal of the credit / debt after the accounting closing process. The storage unit includes an accounting data storage unit that stores accounting data, and acquires accounting data related to transactions to be executed by the control unit and stores the accounting data. The accounting data acquisition step to be stored in the department, the accounting date determination step to determine the future relationship of the accounting date in the accounting data, and whether or not the claims and liabilities are updated after the accounting closing process and a difference is generated. Judgment update type Judgment step, red slip processing to cancel the original amount for the difference between the updated claims and debts, and black slip processing to record the new amount after the update are performed to correct the amount. It is characterized by including a processing step.

According to the present invention, even if the billing amount and the payment amount are fixed and the claims and debts are renewed after the accounting closing process, the billing amount and the payment amount before the closing process can be corrected without delaying the settlement operation. , It has the effect of eliminating the complexity of correction work while grasping the monthly accounting results.

FIG. 1 is a block diagram showing an example of the configuration of the credit / debt retroactive adjustment processing device according to the present embodiment. FIG. 2 is a flowchart showing an example of the processing flow of the credit / debt retroactive adjustment processing apparatus according to the present embodiment. FIG. 3 is a diagram showing an example of data handling and update control for realizing retroactive adjustment processing of claims and debts. FIG. 4 is a diagram showing an example of data transition when retroactive correction processing is performed using sample data. FIG. 5 is a diagram showing an example of an invoice issued in the case of FIG. FIG. 6 is a diagram showing an example of sales data subject to September billing in FIG. FIG. 7 is a diagram showing an example of the accounts receivable management table for September 2016. FIG. 8 is a diagram showing an example of a sales performance table for September 2016. FIG. 9 is a diagram showing an example of sales data for September 2016. FIG. 10 is a diagram showing an example of the accounts receivable management table for October 2016. FIG. 11 is a diagram showing an example of a sales performance table for October 2016. FIG. 12 is a diagram showing an example of sales data for October 2016. FIG. 13 is a diagram showing an example of an additional notation example in the processing category of the sales history data of FIG. FIG. 14 is a diagram showing an example of the relationship between the sales history data of FIG. 4 and the sales record table of FIG.

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

[1. Overview]
In the conventional transportation industry and service industry, if the timing of fixing the billing amount with the billing destination is later than the timing of the monthly settlement of accounts within the company, the monthly settlement is prioritized, so billing It was necessary to manually manage the invoice using spreadsheet software (for example, Excel (trademark registration)).

Therefore, in the credit / debt retroactive adjustment processing device according to the present embodiment, the recognition of the date standard is considered separately from the viewpoint of the monthly settlement of accounts in the company and the viewpoint of determining the billing amount between the billing destination. Even after the monthly closing process, it is possible to correct the billing details of the previous month. That is, the credit / debt retroactive adjustment processing device of the present embodiment has a mechanism for automatically generating the sales amount of the accounting difference as a red-black slip in the next month when the content of the monthly settlement and the content of the billing amount are different. It was built. As a result, it has become possible to eliminate the complexity of billing operations while grasping the monthly accounting results without delaying the monthly settlement of accounts.

[2. composition]
An example of the configuration of the credit / debt retroactive adjustment processing 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 credit / debt retroactive adjustment processing device according to the present embodiment.

The credit / debt retroactive adjustment processing device 100 is a commercially available desktop personal computer. The credit / debt retroactive adjustment processing device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is not limited to a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, and the like. It may be a portable information processing apparatus of.

The credit / debt retroactive adjustment processing device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the credit / debt retroactive adjustment processing device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the credit / debt retroactive correction processing device 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the credit / debt retroactive adjustment processing device 100 and the server 200 so as to be communicable with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like.

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) / ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used. Here, the storage unit 106 includes an accounting data storage unit 106a and the like.

The accounting data storage unit 106a stores accounting data related to transactions. The accounting data includes information about the accounting date and the accounting amount, and the sales data for recording the sales and issuing the invoice when the shipment is made for the order input, or the arrival for the order input. There is purchase data for recording purchases and creating withdrawal slips.

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

The control unit 102 is a CPU or the like that comprehensively controls the credit / debt retroactive adjustment processing device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run. Here, the control unit 102 functionally conceptually includes an accounting data acquisition unit 102a as an accounting data acquisition means, an accounting date determination unit 102b as an accounting date determination means, and an update type determination unit 102c as an update type determination means. , A red-black processing unit 102d or the like as a red-black processing means is provided.

The accounting data acquisition unit 102a acquires accounting data related to a transaction and stores it in the accounting data storage unit 106a. For example, a series of transaction actions such as shipping to order input, recording sales and issuing an invoice, or recording purchase and creating a withdrawal slip when an order is received. Is performed, accounting data is generated, and the accounting data is sequentially acquired and stored in the accounting data storage unit 106a.

The fiscal year / month determination unit 102b determines the relationship between the fiscal year and the month in the accounting data. The accounting date includes, for example, order data, sales data, order data, purchase data, or an accounting system, and the future relationship is determined. For example, with respect to the timing of monthly settlement, sales are recorded in the current accounting year, negative sales due to correction of existing sales data within the current accounting year, sales due to adjustment of existing sales data before the previous accounting year, Alternatively, it is determined to cancel the sales recorded in the previous accounting year.

The renewal type determination unit 102c determines whether or not the receivables and payables have been renewed after the accounting closing process and a difference has occurred in the accounting amount. In other words, if debts and credits are recorded before the accounting closing process and the debt and credit data is updated within the current fiscal year, the same amount of negative debt and credit data may be recorded, but after the accounting closing process. If the receivables and payables before the previous accounting year are renewed and there is a difference, it is necessary to make corrections using the red and black slips. Therefore, in the present embodiment, the receivables and payables are updated by the renewal type determination unit 102c after the accounting closing process based on the relationship between the accounting date and the accounting data determined by the accounting date determination unit 102b, and the accounting amount. It is determined whether or not there is a difference in the amount.

The red-black processing unit 102d corrects the amount by performing red slip processing for canceling the original amount with respect to the difference between the updated claims and debts and black slip processing for recording the new amount after the update. In other words, if there is a renewal of receivables and payables after the accounting closing process, first perform the red slip processing to cancel the original amount, and then perform the black slip processing to record the new amount after the renewal. Since the revision history remains, it is possible to verify the revision process even if the claims and debts are updated after the closing process.

[3. Concrete example]
A specific example of the processing of the credit / debt retroactive adjustment processing device 100 according to the present embodiment will be specifically described with reference to FIGS. 2 to 14. FIG. 2 is a flowchart showing an example of the processing flow of the credit / debt retroactive adjustment processing apparatus according to the present embodiment. FIG. 3 is a diagram showing an example of data handling and update control for realizing retroactive adjustment processing of claims and debts. FIG. 4 is a diagram showing an example of data transition when retroactive correction processing is performed using sample data. FIG. 5 is a diagram showing an example of an invoice issued in the case of FIG. FIG. 6 is a diagram showing an example of sales data subject to September billing in FIG. FIG. 7 is a diagram showing an example of the accounts receivable management table for September 2016. FIG. 8 is a diagram showing an example of a sales performance table for September 2016. FIG. 9 is a diagram showing an example of sales data for September 2016. FIG. 10 is a diagram showing an example of the accounts receivable management table for October 2016. FIG. 11 is a diagram showing an example of a sales performance table for October 2016. FIG. 12 is a diagram showing an example of sales data for October 2016. FIG. 13 is a diagram showing an example of an additional notation example in the processing category of the sales history data of FIG. FIG. 14 is a diagram showing an example of the relationship between the sales history data of FIG. 4 and the sales record table of FIG.

[Processing flow]
The accounting data acquisition unit 102a of the credit / debt retroactive adjustment processing device 100 according to the present embodiment, for example, ships when there is an order input, records sales, issues an invoice, and receives an order. If there is, accounting data is generated based on a series of transaction activities in which purchases are recorded and a withdrawal slip is created. Therefore, the accounting data is acquired and stored in the accounting data storage unit 106a (step S1).

Subsequently, the accounting date determination unit 102b determines the relationship between the accounting year and month of each accounting data stored in the accounting data storage unit 106a, and records the recorded sales data and purchase data within the current fiscal year. It is determined whether to make corrections or cancellations or to make corrections or cancellations as data of the previous fiscal year and month after the closing process (step S2).

Then, when the renewal type determination unit 102c records the receivables and payables before the closing process in accounting and renews the receivables and payables after the closing process in the current fiscal year, there is a difference in the accounting amount. (Yes in step S3), red-black processing is performed in the next stage. In addition, if there is no renewal of receivables and payables after the accounting closing process, or if there is no difference in the accounting amount even if the receivables and payables are renewed (No in step S3), the red-black process is not performed.

When the red-black processing unit 102d determines that the receivables and payables are renewed after the closing process by the renewal type determination unit 102c and there is a difference in the accounting amount, the red-black processing unit 102d sets the original amount for the renewed receivables and debts difference. The red voucher processing to be canceled is performed, and then the black voucher processing to record the new amount after the update is performed (step S4). In this way, even if the debts and credits before the previous fiscal year are renewed after the accounting closing process, the adjustment is automatically performed by red and black processing, so the adjustment history remains and it is possible to verify the adjustment process. Will be.

[Data handling and update control for retroactive adjustment of receivables and payables]
If the timing of fixing the billing amount with the billing destination is later than the timing of the monthly settlement of accounts in the company, the monthly settlement is prioritized in the past, so the invoice is handed using spreadsheet software etc. It was managed by work. On the other hand, in this embodiment, by considering the recognition of the date standard separately from the viewpoint of internal settlement and the viewpoint of determining the billing amount with the billing destination, the previous month even after the monthly closing process. It is possible to modify the billing details. Specifically, we have built a mechanism to automatically generate the difference in sales amount caused by accounting as a red-black slip in the next month. As a result, it is possible to eliminate the complexity of billing operations while grasping the monthly accounting results without delaying the monthly settlement of accounts. Such a mechanism can be applied to all industries and businesses, but in the present embodiment, a company engaged in freight vehicle transportation will be described as an example.

In the example of FIG. 3, when the freight carrier receives an order from the shipper, the sales data is corrected while carrying out a series of transaction activities for issuing an invoice after shipping by vehicle and recording sales. Whether to modify the sales data within the same fiscal year or to modify the sales data before the previous fiscal year after the closing process is determined by determining the future-to-post relationship of the fiscal year.

The processing category shown in FIG. 3 is divided into "at the time of recording sales" for recording sales and "at the time of deleting sales" for deleting sales, and each "category" 0 for "at the time of recording sales" and "at the time of deleting sales". Regarding the "category name" of ~ 3, sales recording is not completed only for orders "0: incomplete", sales recording is completed "1: completed", and the accounting content is changed "2: recorded change" , Delete the recorded contents It is divided into "3: Deleted recorded". The "processing" in each category includes "black" for recording sales and "red" for canceling sales recording. "Accounting date judgment" compares the accounting date of order data and sales data with the system accounting date for closing, and determines whether the revision is within the current fiscal year or before the previous fiscal year. do. The "update type" determines what kind of update process is to be performed based on the "fiscal year / month determination". If the "update type" is "black", it means that sales are recorded for the current fiscal year, and if it is "red", it means negative sales due to the correction of the sales data within the current fiscal year, and "history black". "" Is the sales due to the correction of the sales data before the previous accounting year, and "History red" is the cancellation of the sales recorded in the previous accounting year. "Update target" includes "sales data", "sales history", "vehicle sales", "vehicle history", "collection schedule", "balance T (total)", "order data", "transportation data", etc. "Add", "Update", and "Delete" are performed for each update target.

[Example of data transition by operation sample]
The credit / debt retroactive adjustment processing device 100 according to the present embodiment performs data processing as shown in FIG. 4 based on an operation sample based on the following stories (a) to (f). The timing charts of stories (a) to (f) are executed in the order of (a), (b), and (c) in the frame of 2016/9 in the upper right of FIG. 4, and in the frame of 2016/10. In (d), (e), and (f) in this order. The story (d) shows the timing of the monthly update in September.

(A) 2016/09/25
On the 31st, the shipper recorded sales (2016/09/25 ¥ 100,000 Order No .: J5001).
(B) 2016/09/27
Order No .: J5001 is revised to (¥ 120,000) and recorded as sales.
(C) 2016/09/28
Sales of (2016/09/28 ¥ 150,000 Order No .: J5201) were recorded by the same shipper.
(D) 2016/10/05
Execute "Monthly closing process" (2016/September). * The deadline for credit management is here.
(E) 2016/10/07
Revised sales recorded on 2016/09/25 to (¥ 80,000). → Correction after monthly closing (f) 2016/10/10
Create an invoice for the above shipper.

First, the sales data as of September 25, 2016 is, as shown on the left side of the upper part of FIG. 4, in the story (a), the sales No. is "1001", the sales date is "2016/09/25", and the sales amount is. "¥ 100,000", accounting date is "2016/9", order number is "J5001", history classification is "latest", billing base date is "2016/09/25", sales date is "2016 /" It is 9 ". This sales date is just for operating account management.

As shown on the right side of the upper part of FIG. 4, the collection schedule data for this sales data is the story (a), the sales No. is "1001", the recording date is "2016/09/25", and the sales amount is "¥ 100,". 000 ”, the scheduled collection date is“ 2016/11/10 ”, the billing reference date is“ 2016/09/25 ”, and the collection is“ not yet ”. A state in which collection is “not yet” is a state in which sales have been recorded but have not yet been deposited.

Next, the sales data on the left side in the middle of FIG. 4 shows the sales amount "¥ 1001" recorded in the sales No. "1001" in the story (b) in which the sales amount of the same order No. "J5001" is corrected to "¥ 120,000". Since it was revised within the same month as "100,000", it was replaced with the latest sales No. "2201", and its history category is "History Black". However, at the stage of story (b), the history classification should be "latest" because sales are newly recorded. However, in the sales No. "2301" and "2302" of the story (e) described later, the sales amount "¥ 120,000" of the sales No. "2201" is changed to "¥ 80,000" in the sales No. "2302" after the monthly closing. Since it is necessary to correspond to the "history red" of the history category of the sales No. "2301" that cancels the sales No. "2201", the history category of the sales No. "2201" is "latest". It becomes "History Black". Therefore, as shown on the left side of the middle part of FIG. 4, the credit / debt retroactive adjustment processing device 100 according to the present embodiment has sales of “2016/09/25” in the sales Nos. “2301” and “2302”. On the other hand, since the fiscal year and month after the monthly closing process is "2016/10", the retroactive adjustment process is performed by the red-black process. At that time, the red-black processing unit 102d automatically creates "Δ ¥ 40,000" which is the difference data of the sales No. "2301". In this way, when the sales amount is adjusted after the monthly closing process, the sales date is replaced with the 1st of the following month (here, "2016/10/1"), so that the billing process cannot be performed. , Billing is managed using the "billing record date". However, the sales date on the order data remains the same as the initial "2016/10/1" and is replaced at the time of performing the sales recording process.

Regarding the story (c) of the sales data on the left side of the middle of FIG. 4, the new order No. "J5201" from the same shipper, the sales amount is "¥ 150,000", and the sales date is "2016/09 /". Sales are recorded in "28", the sales No. is "2253", and the history category is "latest".

The collection schedule data on the right side of the middle row of FIG. 4 is the same as the sales data on the left side of the middle row of FIG. 4 in terms of story, sales number, sales amount, and billing base date, and the sales date is set as the recording date. The scheduled collection dates for this sales data are all set to November 10, 2016, and the items for which collection is "completed" are those that have been collected by red-black processing, and "collection" is "collection". Details that are "not yet" (sales No. "2253" and "2302") are subject to payment application.

As shown in the lower part of FIG. 4, the sales history data recording the transition of the above sales data is shown in the sales No. “1001” in the story (b) even if the sales amount is corrected within the same fiscal year and month. In addition, the previously recorded sales amount is canceled and "△ ¥ 100,000" is recorded, and the revised sales amount "¥ 120,000" is recorded as shown in the sales No. "2201" in the story (b). An item called "processing category" is added to this sales history data, "10: new" when new sales are recorded, and when the sales amount recorded within the same fiscal year is deleted. "30: Delete" is set, and the case where the sales amount recorded before the previous fiscal year is canceled after the closing process is set to "24: Before adjustment", and the sales amount recorded before the previous fiscal year is corrected after the closing process. The case is distinguished as "25: after correction".

[Creating an invoice]
As explained in the transition example of the operation sample data in FIG. 4, the credit / debt retroactive adjustment processing device 100 according to the present embodiment cancels the recorded sales within the same fiscal year and month, or closes the recording date. After that, it will be possible to retroactively make adjustments to the sales in the previous fiscal year. Therefore, it is not necessary to delay the timing of monthly settlement according to the timing of finalizing the billing amount with the billing destination, and it is possible to correct the billing contents before the previous month even after the monthly closing process, and the accounting difference. Since the sales amount of the above is automatically generated as a red-black slip in the next month, the complexity of billing work can be eliminated.

The invoice issued by the accounting process of the operation sample of FIG. 4 is as shown in FIG. The original data of this invoice is the sales data for the September invoice shown in FIG. This time, the sales amount is revised after the monthly closing process in September, but the target data is controlled based on the billing reference date, including the revised content of the sales amount after the monthly closing process. Can be invoiced. This amendment after the monthly closing process has an amendment history in the same billing period, but an invoice is created using only the latest data. That is, the change data (history black, history red) after the monthly closing process is subject to the temporary closing process, but is excluded from printing.

[Example of form for credit management]
The final invoice will be as shown in Fig. 5, but the following accounts receivable management table and sales record table will be used as examples of forms for managing receivables. First, as shown in FIG. 7, the accounts receivable management table for September 2016 shows the situation of accounts receivable whose sales were recorded in September of the fiscal year and have not been deposited yet. That is, among the sales data shown in FIG. 4, the sales No. “2201” “¥ 120,000” of the story (b) recorded as sales on September 25 and the story recorded as sales on September 28 (¥ 120,000). c) Sales No. “2253” is “¥ 150,000”, which is the target current month sales data in FIG. Therefore, the total sales amount for September 2016 is "¥ 270,000", which is consistent with the sales performance table for September 2016 shown in FIG. Therefore, in the accounts receivable management table for September 2016, as shown in Fig. 7, the total sales amount for the current month is "¥ 270,000" and the consumption tax (8%) "¥ 21,600" is added. Therefore, the balance of accounts receivable for the current month will be "¥ 291,600". As described above, since the accounts receivable management table shown in FIG. 7 and the sales record table shown in FIG. 8 are controlled based on the fiscal year and month instead of the billing record date, they are synchronized with the accounting.

On the other hand, the accounts receivable management table for October 2016 shows the situation of accounts receivable whose sales were recorded in October of the fiscal year and have not been deposited yet, as shown in FIG. That is, among the sales data shown in FIG. 4, the red slip processing of the sales No. “2301” of the story (e) recorded on October 1st is “△ ¥ 120,000” and October 1st. The black slip processing of the sales No. “2302” of the story (e) recorded in the above is “¥ 80,000”, which is the target current month sales data in FIG. Therefore, the total sales amount for October 2016 is “△ ¥ 40,000”, which is consistent with the sales performance table for October 2016 shown in FIG. Therefore, as shown in Fig. 10, the accounts receivable management table for October 2016 shows that the accounts receivable balance up to the previous month was "¥ 291,600" and the sales amount for the current month was "△ ¥ 40,000". By adding the consumption tax (8%) of "△ ¥ 3,200", the balance of accounts receivable for the current month becomes "¥ 248,400". As described above, since the accounts receivable management table shown in FIG. 10 and the sales record table shown in FIG. 11 are controlled based on the fiscal year and month instead of the billing record date, they are synchronized with the accounting.

[Sales history data processing category]
In the processing category of sales history data shown in FIG. 4, the case where the sales amount recorded before the previous fiscal year is canceled after the closing process is defined as "24: before adjustment", and the sales amount recorded before the previous fiscal year is used. The case of correction after the tightening process is distinguished as "25: after correction". However, since it is unclear whether or not the correction is performed after the monthly closing process only with this description, the description of the processing category is described in FIG. 13 in order to make it clearer that the correction data is performed after the monthly closing process. It is possible to change or add as. For example, "24: before correction" is changed to "24: correction after tightening (before correction)", "25: after correction" is changed to "25: correction after tightening (after correction)", and further, monthly. A processing category of "32: Correction after closing (deletion)" may be added in order to make a correction that only deletes the recorded amount after the closing process.

[Sales history data and sales record table]
Further, as shown in FIG. 14, the red-black processing unit 102d calculates the sales record table for the previous month's adjustment amount, and the sales history data processing categories are "24: before adjustment" and "25: after adjustment". Alternatively, it can be automatically calculated by using the data of "24: correction after tightening (before correction)" and "25: correction after tightening (after correction)" changed in FIG. 13 above.

As described above, the claim / debt retroactive adjustment processing device 100 according to the present embodiment is closed even if the billing amount is fixed with the billing party after the closing process of the month in which the sales are recorded and the sales amount is updated. By automatically generating the difference from the sales amount before processing in the next month with a red and black slip, it is possible to correct the billing details retroactively before the closing process, so it is possible to capture the monthly accounting results without delaying the settlement work. At the same time, the complexity of the correction work can be eliminated.

In the above embodiment, the description has been made using an example of updating the amount of receivables for recording sales and making a claim for an order, but the description is not necessarily limited to this, and the amount of debt for recording and paying purchases for an order. Even in the case of renewal, the debt amount can be retroactively corrected by using the same logic.

Further, in the above embodiment, the description has been made using an example of the transportation industry in which a freight carrier receives an order for a package transportation contract from a shipper, instructs shipping, records sales, and issues an invoice, but the present invention is limited to this. However, the present invention can be applied to all industries and industries such as the service industry.

[4. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical ideas described in the claims.

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

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

Further, with respect to the credit / debt retroactive adjustment processing device 100, each component in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the credit / debt retroactive adjustment processing device 100, particularly each processing function performed by the control unit 102, all or any part thereof may be interpreted and executed by the CPU and the CPU. It may be realized, or it may be realized as hardware by wired logic. It should be noted that the program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the processing described in the present embodiment, and the credit / debt retroactive as necessary. It is read mechanically by the correction processing device 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into the RAM, and constitutes the control unit 102 in cooperation with the CPU.

Further, this computer program may be stored in an application program server connected to the credit / debt retroactive adjustment processing device 100 via an arbitrary network, and all or a part thereof may be downloaded as needed. Is also possible.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disc), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium and the installation procedure after reading in each device shown in the embodiment.

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, etc.

Further, the credit / debt retroactive adjustment processing device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. .. Further, the credit / debt retroactive adjustment processing device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the information processing device.

Furthermore, the specific form of distribution / integration of the device is not limited to that shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or functional additions. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

The present invention is applicable in all industries and industries, but is particularly useful in the logistics industry and the service industry in which the billing amount and the payment amount are updated after the accounting closing process.

100 Credit / debt retroactive adjustment processing device 102 Control unit 102a Accounting data acquisition unit 102b Accounting date determination unit 102c Update type determination unit 102d Red / black processing unit 104 Communication interface unit 106 Storage unit 106a Accounting data storage unit 108 Input / output interface unit 112 Input device (Keyboard, mouse)
114 Output device (monitor)
200 servers 300 networks

Claims (7)

It is a credit / debt retroactive correction processing device that has a storage unit and a control unit and retroactively corrects when there is a renewal of credit / debt after accounting closing.
The storage unit is
Includes an accounting data storage unit that stores accounting data
The control unit
Accounting data acquisition means for acquiring accounting data related to transactions and storing it in the accounting data storage unit,
The accounting date determination means for determining the future relationship of the accounting date in the accounting data,
Renewal type determination means for determining whether or not a difference has occurred due to renewal of receivables and payables after accounting closing processing,
A red slip processing means that corrects the amount by performing red slip processing that cancels the original amount for the difference between the updated claims and debts and black slip processing that records the new amount after the update.
Being equipped with
A credit / debt retroactive adjustment processing device characterized by. The renewal of the claims and debts
Either renewal of the amount of receivables for which sales are recorded and billed for orders, or renewal of debts for which purchases are recorded and paid for orders.
The credit / debt retroactive adjustment processing device according to claim 1. The red-black processing means
When the amount of receivables is updated and the amount is adjusted after the accounting closing process, the accounting data is managed using the original "billing record date" and the "sales date" indicating the accounting date.
When the debt amount is updated and the amount is adjusted after the accounting closing process, the accounting data is managed using the original "payment record date" and the "purchase date" indicating the accounting date. matter,
2. The credit / debt retroactive adjustment processing device according to claim 2. The red-black processing means
When managing sales data as the accounting data, if there is new sales for the order No., the history classification is set to "latest" by combining with the new sales No., and when the red slip processing is performed, the history classification is "history". When the black slip processing is performed with "red", the history classification is set to "history black" and the order No. and the sales No. are linked and managed.
When managing purchase data as the accounting data, if there is a new purchase for the order No., it is combined with the new purchase No. to make the history classification "latest", and if the red slip processing is performed, the history classification Is set to "history red", and when the black slip processing is performed, the history classification is set to "history black" and the order No. and the purchase No. are linked and managed.
The credit / debt retroactive adjustment processing device according to claim 3. The red-black processing means
When managing sales data as the accounting data, if there is new sales for the order No., it is combined with the new sales No. to set the processing category to "new" and cancel the sales amount before the accounting closing process. Then, if the processing category is set to "Delete" and the sales amount before closing is canceled after the accounting closing process, the processing category is set to "Before correction after closing" and the corrected sales amount is set for the canceled order No. When it is recorded, the processing category is set to "after adjustment" and the difference in sales amount is set to the corrected amount for red and black processing.
When managing purchase data as the accounting data, if there is a new purchase for the order No., it is combined with the new purchase No. to set the processing category to "new" and purchase before the accounting closing process. If the amount is canceled, the processing category is set to "Delete", and if the purchase amount before the closing process is canceled after the accounting closing process, the processing category is set to "After closing and before correction", and the canceled order No. is corrected. When the later purchase amount is recorded, the processing category will be "after adjustment" and the difference in the purchase amount will be the adjustment amount for red and black processing.
The credit / debt retroactive adjustment processing device according to claim 4. It is a credit / debt retroactive adjustment processing method that is executed by a credit / debt retroactive adjustment processing device that has a storage unit and a control unit and retroactively corrects when there is a renewal of credit / debt after accounting closing.
The storage unit is
Includes an accounting data storage unit that stores accounting data
Executed by the control unit,
An accounting data acquisition step that acquires accounting data related to a transaction and stores it in the accounting data storage unit, and
The accounting date determination step for determining the future relationship of the accounting date in the accounting data,
An update type determination step for determining whether or not a difference has occurred due to the renewal of receivables and payables after the accounting closing process, and
A red slip processing step that corrects the amount by performing a red slip processing that cancels the original amount for the difference between the updated claims and debts and a black slip processing that records the new amount after the update.
To include,
A method for retroactive adjustment of receivables and payables. It is a credit / debt retroactive adjustment processing program that has a storage unit and a control unit, and is executed by a credit / debt retroactive adjustment processing device that retroactively corrects when there is a renewal of credit / debt after accounting closing.
The storage unit is
Includes an accounting data storage unit that stores accounting data
To be executed by the control unit
An accounting data acquisition step that acquires accounting data related to a transaction and stores it in the accounting data storage unit, and
The accounting date determination step for determining the future relationship of the accounting date in the accounting data,
An update type determination step for determining whether or not a difference has occurred due to the renewal of receivables and payables after the accounting closing process, and
A red slip processing step that corrects the amount by performing a red slip processing that cancels the original amount for the difference between the updated claims and debts and a black slip processing that records the new amount after the update.
To include,
A credit / debt retroactive adjustment processing program characterized by.

Images