Information processing device, information processing method, and information processing program

The information processing device automates the conversion and generation of accounting data from invoices, addressing the inefficiencies and errors in processing diverse billing formats, thereby reducing operator workload and enhancing processing efficiency.

JP7591003B2Active Publication Date: 2024-11-27OBIC CO LTD
View PDF 4 Cites 0 Cited by

Patent Information

Application Number
JP2022055195
Authority / Receiving Office
JP · JP
Patent Type
Patents
Current Assignee / Owner
Filing Date
2022-03-30
Publication Date
2024-11-27
Estimated Expiration
2042-03-30

AI Technical Summary

Technical Problem

Business operators face significant workload in processing large volumes of invoices and receipts, even when they are received as digital data, due to the need for manual analysis and input of varying formats from different providers, leading to inefficiencies and potential errors.

Method used

An information processing device and method that automatically acquires, converts, and generates accounting data from invoices by identifying capture positions in the layout of billing data, allowing for the conversion of billing details into item data and generation of expense and journal data, reducing the need for manual intervention.

Benefits of technology

This approach significantly reduces the workload of business operators by automating the data processing of invoices, minimizing errors, and ensuring efficient handling of diverse billing formats from different providers.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 0007591003000001
    Figure 0007591003000001
  • Figure 0007591003000002
    Figure 0007591003000002
  • Figure 0007591003000003
    Figure 0007591003000003
Patent Text Reader

Abstract

To reduce a workload of a business operator required for data processing.SOLUTION: An acquisition unit acquires acquisition target data from an acquisition position set based on a layout of file data, and a conversion unit converts acquisition target data acquired as breakdown of the acquired acquisition target data into classification data indicating a predetermined classification. A data generation unit generates information processing data for predetermined information processing, the data including the classification data. As an example, the acquisition unit acquires at least the acquisition target data as breakdown and billing amount data indicating a billing amount from each acquisition position set based on the layout of billing data indicating the billing amount which is the file data. The conversion unit converts the acquisition target data acquired as breakdown into subject data indicating an accounting classification, and the data generation unit generates cost data for accounting processing including the subject data and the billing amount data as information processing data.SELECTED DRAWING: Figure 10
Need to check novelty before this filing date? Find Prior Art

Description

[Technical field]

[0001] The present invention relates to an information processing device, an information processing method, and an information processing program. [Background technology]

[0002] Nowadays, processing a large number of invoices sent from business partners places a heavy burden on business operators. Patent Document 1 (JP Patent Publication No. 2022-045315) discloses a data processing device that aims to reduce the burden of sorting multiple invoice data.

[0003] In this data processing device, the data acquisition unit reads multiple invoices, and the classification unit classifies each read invoice into catalog data of a "catalog" equivalent to a cover page on which the recipient's name, date, etc. are written, and detail data indicating a "detail" on which the invoice amount, etc. are written. The identification unit identifies the issuer of the catalog and the issuer of the detail. The generation unit then aggregates the catalog data and detail data classified by the classification unit for each issuer identified by the identification unit to generate multiple invoice data. The generated invoice data is output by the output unit. This reduces the burden of the task of classifying multiple invoice data. [Prior art documents] [Patent documents]

[0004] [Patent Document 1] Patent Publication No. 2022-045315 Summary of the Invention [Problem to be solved by the invention]

[0005] In recent years, various information such as invoices and receipts is often digitized and transmitted. However, even when receiving invoices, receipts, etc. as data, the work of the business operator is required according to the number of data received. Therefore, the work burden of the business operator is not much different from the time when invoices, receipts, etc. were sent by mail.

[0006] The present invention has been made in consideration of the above-mentioned problems, and has an object to provide an information processing device, an information processing method, and an information processing program that can reduce the workload of an operator required for data processing. [Means for solving the problem]

[0007] In order to solve the above problems and achieve the object, an information processing device according to the present invention includes an acquisition unit that acquires import target data from an import position set based on a layout of file data, a conversion unit that converts import target data acquired as a breakdown of the acquired import target data into classification data indicating a predetermined classification, and a data generation unit that generates information processing data for predetermined information processing, including the classification data. The acquisition unit acquires at least the import target data of the details and the billing amount data indicating the billing amount from each import position set based on the layout of the billing data indicating the billing amount, which is file data, the conversion unit converts the import target data acquired as the details into item data indicating accounting classification, and the data generation unit generates, as information processing data, expense data for accounting processing including the item data and the billing amount data, and generates journal data for accounting based on the expense data. .

[0008] In order to solve the above-mentioned problems and achieve the object, an information processing method according to the present invention includes an acquisition step in which an acquisition unit acquires import target data from an import position set based on a layout of file data, a conversion step in which a conversion unit converts import target data acquired as a breakdown of the acquired import target data into classification data indicating a predetermined classification, and a data generation step in which a data generation unit generates information processing data for predetermined information processing including the classification data. In the acquisition step, the acquisition unit acquires at least the import target data of the details and the billing amount data indicating the billing amount from each import position set based on the layout of the billing data indicating the billing amount, which is file data; in the conversion step, the conversion unit converts the import target data acquired as the details into item data indicating accounting classification; and in the data generation step, the data generation unit generates, as information processing data, expense data for accounting processing including the item data and the billing amount data, and generates journal data for accounting based on the expense data. .

[0009] In order to solve the above-mentioned problems and achieve the object, an information processing program according to the present invention includes an acquisition unit that acquires import target data from an import position set based on a layout of file data, a conversion unit that converts import target data acquired as a breakdown of the acquired import target data into classification data indicating a predetermined classification, and a data generation unit that generates information processing data for predetermined information processing, including the classification data. The acquisition unit acquires at least the data to be imported of the details and the billing amount data indicating the billing amount from each import position set based on the layout of the billing data indicating the billing amount, which is file data, the conversion unit converts the data to be imported acquired as the details into item data indicating accounting classification, and the data generation unit generates, as information processing data, expense data for accounting processing including the item data and the billing amount data, and generates journal data for accounting based on the expense data. . Effect of the Invention

[0010] The present invention can reduce the workload of operators required for data processing. [Brief description of the drawings]

[0011] [Figure 1] FIG. 1 is a block diagram showing a hardware configuration of a billing processing device according to an embodiment. [Diagram 2] FIG. 2 is a diagram illustrating an example of a line master. [Diagram 3] FIG. 3 is a diagram illustrating an example of the account subject master. [Figure 4] FIG. 4 is a diagram illustrating an example of the billing details master. [Diagram 5] FIG. 5 is a diagram illustrating an example of the billing ID master. [Figure 6] FIG. 6 is a diagram illustrating an example of the date master. [Figure 7] FIG. 7 is a diagram illustrating an example of the billing amount master. [Figure 8] FIG. 8 is a diagram illustrating an example of the subject conversion master. [Figure 9] FIG. 9 is a diagram showing an outline of data processing in the billing processing device according to the embodiment. [Figure 10] FIG. 10 is a flowchart showing the flow of data processing operations of the billing processing device according to the embodiment. [Figure 11] FIG. 11 is a diagram showing an example of billing data transmitted from carrier A, which is one of the telephone communication companies, and an example of billing data transmitted from carrier B, which is another telephone communication company. [Figure 12] FIG. 12 is a diagram illustrating an example of the expense data generated by the billing processing device according to the embodiment. [Figure 13] FIG. 13 is a diagram illustrating an example of journal data generated based on expense data by the billing processing device according to the embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0012] A billing processing device according to an embodiment of the present invention will be described in detail below with reference to the drawings. The billing processing device according to this embodiment is a terminal device of a call center contractor, and is a terminal device that processes billing data sent from a telephone communication company (carrier company) for each line (telephone number) used at the call center. However, the present invention is not limited to such an embodiment.

[0013] (overview) Call center contractors receive invoices from carrier companies for each line (telephone number) used at the call center. Invoices from carrier companies are broken down into separate details for each type of usage, with different expense items for each type. In addition, the format (layout) differs for each carrier company. This means that business operators are required to analyze the contents of the invoice data for each carrier company and manually enter the data into the payment request input screen, which creates an excessive workload for business operators at the end of the month.

[0014] In the billing processing device of the embodiment, data is automatically acquired by specifying the import position on the layout, such as "column" or "row," based on the layout of billing data, which differs for each carrier company. This makes it possible to import desired data such as item, payment category, cost category, etc. for each telephone number. In addition, of the acquired data, item data indicating the contents of the billing is converted into item data for accounting, and expense data for accounting processing is generated. Furthermore, based on this expense data, journal entry data for accounting purposes is also generated. This significantly reduces the burden on business operators in processing billing data.

[0015] Furthermore, when the billing data needs to be corrected due to a contract with a carrier company, if the billing data from the carrier company is directly corrected, the original data will be corrected, and if an error occurs in correcting the original data, the error will be carried over to subsequent processing. For this reason, the billing processing device of the embodiment does not correct the original billing data, but corrects the expense data generated from the billing data. This makes it possible to prevent the inconvenience of an error that occurs when correcting the original billing data being carried over to subsequent processing.

[0016] In addition, the identification number (ID) of the billing data may differ depending on the carrier company, such as in some cases using a "telephone number" or in other cases using a specific identification number. In either case, the billing processing device of the embodiment is capable of importing the desired data described above.

[0017] (Hardware configuration) Fig. 1 is a block diagram showing a hardware configuration of a billing processing device 1 according to an embodiment. The billing processing device 1 shown in Fig. 1 includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5. An input device 6 and an output device 7 are connected to the input / output interface unit 5. The output device 7 may be a display unit such as a monitor device (including a home television). The input device 6 may be a keyboard device, a mouse device, a microphone device, or a monitor device that cooperates with a mouse device to realize a pointing device function.

[0018] The communications interface unit 4 is connected to one or more carrier terminal devices 20 of carrier companies and one or more accounting terminal devices 30 via a network 8, which may be a wide area network such as the Internet or a private network such as a LAN (Local Area Network). The communications interface unit 4 receives billing data transmitted from each carrier terminal device 20. The communications interface unit 4 also transmits journal entry data generated based on expense data to the accounting terminal device 30. The accounting terminal device 30 performs accounting processing of this journal entry data based on an accounting system 40, which is software. The accounting system 40 may be provided on the billing processing device 1 side, as indicated by the dotted line block in FIG. 1.

[0019] A storage device such as a ROM (Read Only Memory), a RAM (Random Access Memory), a HDD (Hard Disk Drive), or an SSD (Solid State Drive) can be used as the storage unit 2. The storage unit 2 is provided with a line master 11, an account item master 12, a billing breakdown master 13, a billing ID master 14, a date master 15, a billing amount master 16, and an item conversion master 17, each of which is a storage area.

[0020] FIG. 2 is a diagram showing an example of the line master 11. As shown in FIG. 2, the line master 11 stores a carrier code, a carrier name, a line ID, a billing ID, a payment category, and a payment category name. The carrier code is a code assigned to each carrier company. The carrier name is the company name of each carrier company. FIG. 2 shows an example in which a carrier code of "90" is assigned to carrier company A, a carrier code of "91" is assigned to company B, and a carrier code of "92" is assigned to company C.

[0021] As the line ID and billing ID, the contracted telephone number or a specific identification number assigned by the carrier company is stored. The example in Fig. 2 is an example in which a telephone number such as "090-1111-1111" is stored as the line ID and billing ID of company A. Also, the example in Fig. 2 is an example in which a telephone number such as "090-1111-3333" is stored as the line ID of company B, and a specific identification number such as "B000001" is stored as the billing ID.

[0022] The payment category is the category of the fee system, and the payment category name is the name of this fee system. In the example of Figure 2, payment category "1" indicates a "flat rate" fee system, and payment category "2" indicates a "pay-as-you-go" fee system.

[0023] Fig. 3 is a diagram showing an example of the account subject master 12. As shown in Fig. 3, the account subject master 12 stores account codes, account names, etc. In the example of Fig. 3, the account subject code "K001" indicates "XX communication fee", the account subject code "K002" indicates "XX communication fee", and the account subject code "K003" indicates "consumption tax".

[0024] Fig. 4 is a diagram showing an example of the billing breakdown master 13. The billing breakdown master 13 stores a first billing breakdown master 13a in which a column (an example of a first import position) for acquiring billing breakdown data in normal times is stored, and a second billing breakdown master 13b in which a column (an example of a second import position) different from the above-mentioned normal columns for acquiring billing breakdown data in irregular times is stored. Fig. 4(a) shows an example of the first billing breakdown master 13a, and Fig. 4(b) shows an example of the second billing breakdown master 13b.

[0025] 4, the billing breakdown master 13 stores a column number (column No.) that specifies the "column" of data to be acquired from the billing data of the carrier company in association with the carrier code and carrier name. The billing breakdown master 13 also stores the billing breakdown code and billing breakdown name indicated by the data of the column number.

[0026] The example of the first billing breakdown master 13a used in normal times shown in Fig. 4(a) indicates that the "fifth column (column No. 5)" is specified as the column from which data is acquired for the billing data of Company A. Also, it indicates that the data in this fifth column includes "line usage fee (basic fee)" with billing breakdown code "101", "dial call fee" with billing breakdown code "102", "universal service fee" with billing breakdown code "103", "equivalent amount of consumption tax" with billing breakdown code "104", and "SMS communication fee" with billing breakdown code "105".

[0027] 4(a), an example of the first billing detail master 13a used during normal times indicates that the sixth column (column No. 6) is specified as the column from which data is acquired for the billing data of Company B. The data in the sixth column includes "flat-rate communication fee (flat-rate data plan)" with billing detail code "106", "indoor wiring usage fee" with billing detail code "107", and "lump sum basic fee discount" with billing detail code "108".

[0028] In contrast, the example of the second billing breakdown master 13b used in irregular cases shown in Fig. 4(b) indicates that the seventh column (column No. 7) is specified as the column from which data is acquired for the billing data of Company A. The data in the seventh column acquired in irregular cases includes "line usage fee (basic fee)" with billing breakdown code "101", "dial call fee" with billing breakdown code "102", "universal service fee" with billing breakdown code "103", "equivalent amount of consumption tax" with billing breakdown code "104", and "SMS communication fee" with billing breakdown code "105".

[0029] Fig. 5 is a diagram showing an example of the billing ID master 14. In this billing ID master 14, a column number indicating the column in which the billing ID is recorded is stored in association with the carrier code and carrier name. In the example of Fig. 5, it is shown that the billing IDs of both companies A and B are recorded in the "first column".

[0030] Fig. 6 is a diagram showing an example of the date master 15. In this date master 15, a column number indicating the column in which the billing date is recorded is stored in association with the carrier code and carrier name. In the example of Fig. 6, it is shown that the billing date is recorded in the "third column" for both Company A and Company B.

[0031] Fig. 7 is a diagram showing an example of the billing amount master 16. In this billing amount master 16, a column number indicating the column in which the billing amount is recorded is stored in association with the carrier code and carrier name. In the example of Fig. 7, it is shown that the billing date is recorded in the "fourth column" for both Company A and Company B.

[0032] 8 is a diagram showing an example of the item conversion master 17 for converting billing detail data into item codes of account items. This item conversion master 17 stores item codes and item names corresponding to billing detail codes and billing detail names obtained from a specified column of the billing data of each carrier company as described above.

[0033] Specifically, the example in FIG. 8 shows that the "Line usage fee (basic fee)" of Company A, whose billing breakdown code is "101", is converted to account data with an account code of "K001" and an account name of "XX communication fee". The example in FIG. 8 also shows that the "Tayal call fee" of Company A, whose billing breakdown code is "102", the "Universal service fee" of Company A, whose billing breakdown code is "103", and the "SMS communication fee" of Company A, whose billing breakdown code is "105", are each converted to account data with an account code of "K002" and an account name of "XX communication fee". The example in FIG. 8 also shows that the "Amount equivalent to consumption tax" of Company A, whose billing breakdown code is "104", is converted to account data with an account code of "K003" and an account name of "consumption tax".

[0034] In addition, the example in Figure 8 shows that B Company's "Flat Rate Communication Charges (Flat Rate Data Plan)" with billing breakdown code "106", "Indoor Wiring Usage Charges" with billing breakdown code "107", and "Lump Sum Basic Fee Discount" with billing breakdown code "108" are each converted into item data with the item code "K001" and the item name "XX Communication Expenses".

[0035] (Functional configuration of billing processing device) Next, the control unit 3 executes the billing processing program stored in the storage unit 2, and thereby functions as an acquisition unit 21, a conversion unit 22, a data generation unit 23, a change processing unit 24, a display control unit 25, and a master selection processing unit 26.

[0036] The acquisition unit 21 acquires "column" data that is designated in advance based on the layout of the billing data. Note that, in the following, the billing processing device 1 of the embodiment will be described as acquiring "column" data that is designated in advance from the billing data, but it may also acquire data of a designated desired import position, such as acquiring "row" data that is designated in advance. In either case, the same effect as described below can be obtained.

[0037] The conversion unit 22 converts billing breakdown data indicating billing details, among the data acquired from the billing data, into item data indicating account items. The data generation unit 24 generates expense data (=cost data) indicating communication costs of the call center, based on the data acquired from the billing data and the item data generated by the conversion process. When a change operation (modification operation) is performed on the expense data by the business operator, the change processing unit 24 changes the value of the expense data in response to this change operation.

[0038] The display control unit 25 displays the generated expense data, etc., via the output device 7, which is an example of a display unit. The business operator performs a change operation of the expense data, if necessary, based on the displayed expense data. As described above, the billing breakdown master 13 stores the first billing breakdown master 13a, which stores columns for acquiring billing breakdown data in normal times, and the second billing breakdown master 13b, which stores columns different from the above-mentioned normal columns as columns for acquiring billing breakdown data in irregular times. The master selection processing unit 26 selects the first billing breakdown master 13a or the second billing breakdown master 13b as the billing breakdown master 13 to be used for acquiring the billing breakdown data, in response to the selection operation of the business operator. The acquisition unit 21 acquires the billing breakdown data from the billing data of the carrier company using the selected billing breakdown master 13.

[0039] (Overview of billing data processing operation of billing processing device) Next, Fig. 9 shows an overview of the processing operation of billing data from each company in the billing processing device 1 of the embodiment having such a configuration. As shown in Fig. 9, when the billing processing device 1 of the embodiment acquires billing data from the carrier terminal device 20 of each carrier company such as Company A to Company C, in step S1, it acquires billing detail data (billing detail code and billing detail name) of a specified column from the billing data based on various masters 11 to 16 such as the billing detail master 13 described above. Then, based on the item conversion master 17, it converts this billing detail data into item data indicating an account item.

[0040] Next, in step S2, the billing processing device 1 generates expense data including the item data generated by the conversion. Then, in step S3, based on the expense data, it generates journal entry data for accounting purposes and transmits it to the accounting system 40 of the accounting terminal device 30 for accounting processing.

[0041] (Details of billing data processing operation of billing processing device) Next, the billing data processing operation in the billing processing device 1 of this embodiment will be described in detail with reference to the flowchart in Fig. 10. The control unit 3 of the billing processing device 1 executes each process of the flowchart in Fig. 10 based on the billing processing program stored in the storage unit 2. First, in step S11, the acquisition unit 21 acquires billing data received from the carrier terminal device 20 of each carrier company.

[0042] FIG. 11 shows an example of this billing data. Of these, FIG. 11(a) is an example of the billing data of Company A, and FIG. 11(b) is an example of the billing data of Company B. Company A's billing data shown in FIG. 11(a) is composed of a billing ID, last basic fee, current basic fee, billing amount, billing breakdown code, backup, last meter reading date, and current meter reading date. In the case of Company A, the billing ID is a telephone number such as "090-1111-1111". Also, the billing breakdown code is recorded in the "5th column".

[0043] In contrast, the billing data of Company B shown in Figure 11(b) includes a billing ID, last basic fee, current basic fee, billing amount, reserve, billing detail code, last meter reading date, and current meter reading date. In the case of Company B, the billing ID is a specific identification number such as "B000001". Also, the billing detail code is recorded in the "sixth column".

[0044] Next, in step S12, the acquisition unit 21 determines whether or not there is a change designation operation for the billing breakdown master 13. That is, as described above, the billing breakdown master 13 stores the first billing breakdown master 13a in which columns for acquiring billing breakdown data in normal times are stored, and the second billing breakdown master 13b in which columns different from the above-mentioned normal times are stored in which billing breakdown data is acquired in irregular times.

[0045] Normally (or by default), the master selection processing unit 26 selects the first billing detail master 13a. When the first billing detail master 13a is selected by the master selection processing unit 26, the acquisition unit 21 determines that no change designation operation has been performed (step S12: No), and the process proceeds to step S13.

[0046] In step S13, the acquisition unit 21 refers to the first billing breakdown master 13a shown in FIG. 4(a) and detects the "column" in which the billing breakdown code of each company is recorded. In the example of FIG. 4(a), the "column" in which the billing breakdown code of the billing data of Company A is recorded is the "5th column", and the "column" in which the billing breakdown code of Company B is recorded is the "6th column". Therefore, the acquisition unit 21 acquires billing breakdown codes such as "101" and "102" by acquiring data in the 5th column from the billing data of Company A illustrated in FIG. 11(a). Also, the acquisition unit 21 acquires billing breakdown codes such as "107" and "108" by acquiring data in the 6th column from the billing data of Company B illustrated in FIG. 11(a).

[0047] In step S13, the acquisition unit 21 detects columns in which the billing IDs of each company are recorded by referring to the billing ID master 14 shown in Fig. 5. Based on the detection result, the acquisition unit 21 acquires a billing ID with a telephone number such as "090-1111-1111" from the first column of the billing data of company A shown in Fig. 11(a). The acquisition unit 21 also acquires a billing ID with a specific billing number such as "B000001" from the first column of the billing data of company B shown in Fig. 11(b).

[0048] In step S13, the acquisition unit 21 detects the columns in which the billing dates of each company are recorded by referring to the date master 15 shown in Fig. 6. Based on the detection result, the acquisition unit 21 acquires a billing date such as "February 1, 2021" from the third column of the billing data of Company A shown in Fig. 11(a). The acquisition unit 21 also acquires a billing date such as "February 1, 2021" from the third column of the billing data of Company B shown in Fig. 11(b).

[0049] In step S13, the acquisition unit 21 detects the columns in which the billing amounts of each company are recorded by referring to the billing amount master 16 shown in Fig. 7. Based on the detection result, the acquisition unit 21 acquires billing amounts such as "1000 yen", "200 yen", etc. from the fourth column of the billing data of company A shown in Fig. 11(a). The acquisition unit 21 also acquires billing amounts such as "1000 yen", "200 yen", etc. from the fourth column of the billing data of company B shown in Fig. 11(b).

[0050] On the other hand, for example, when the layout of the billing data is changed, the business operator selects the second billing details master 13b shown in FIG. 4(b), for example, which corresponds to the changed layout. The second billing details master 13b shown in FIG. 4(b) is an example in which the layout of the billing data of Company A has changed, and the column for acquiring billing details data (billing details code and billing details name) has changed from the "fifth column (see FIG. 4(a))" to the "seventh column (see FIG. 4(b))." When the billing details master 13b is selected, the acquisition unit 21 determines that a change designation operation has been performed (step S12: Yes), and the process proceeds to step S18.

[0051] In step S18, the acquisition unit 21 refers to the second billing breakdown master 13b shown in FIG. 4(b) and detects the "column" in which the billing breakdown code of each company is recorded. In the example of FIG. 4(a), the "column" in which the billing breakdown code of Company A's billing data is recorded has been changed to the "seventh column." Therefore, the acquisition unit 21 acquires the data in the seventh column of Company A's billing data to acquire billing breakdown codes such as "101" and "102." This makes it possible to acquire desired data such as billing breakdown codes in response to changes in the layout of Company A's billing data.

[0052] When the layout of the billing data is changed, for example, the column number of the "fifth column" shown in Fig. 4(a) may be changed to the "seventh column." However, as in this embodiment, by preparing a billing details master 13b for handling layout changes in advance and switching the billing details master 13 to be used when a layout change occurs, it is possible to safely and easily handle the layout change without rewriting the column numbers of the billing details master 13.

[0053] In step S18, the acquisition unit 21 detects columns in which the billing IDs of each company are recorded by referring to the billing ID master 14 shown in Fig. 5. Based on the detection result, the acquisition unit 21 acquires a billing ID with a telephone number such as "090-1111-1111" from the first column of the billing data of company A shown in Fig. 11(a). The acquisition unit 21 also acquires a billing ID with a specific billing number such as "B000001" from the first column of the billing data of company B shown in Fig. 11(b).

[0054] In step S18, the acquisition unit 21 detects the columns in which the billing dates of each company are recorded by referring to the date master 15 shown in Fig. 6. Based on the detection result, the acquisition unit 21 acquires a billing date such as "February 1, 2021" from the third column of the billing data of Company A shown in Fig. 11(a). The acquisition unit 21 also acquires a billing date such as "February 1, 2021" from the third column of the billing data of Company B shown in Fig. 11(b).

[0055] In step S18, the acquisition unit 21 detects the columns in which the billing amounts of each company are recorded by referring to the billing amount master 16 shown in Fig. 7. Based on the detection result, the acquisition unit 21 acquires billing amounts such as "1000 yen", "200 yen", etc. from the fourth column of the billing data of company A shown in Fig. 11(a). The acquisition unit 21 also acquires billing amounts such as "1000 yen", "200 yen", etc. from the fourth column of the billing data of company B shown in Fig. 11(b).

[0056] Next, in step S14, the conversion unit 22 converts the billing detail data (billing detail code and billing detail name) acquired in step S13 or step S18 into the subject code of the account subject based on the subject conversion master 17 shown in FIG. 8.

[0057] Specifically, the conversion unit 22 converts the "line usage fee (basic fee)" of company A, whose billing breakdown code is "101", into item data whose account code is "K001" and whose account name is "XX communication fee" by referring to the account conversion master 17. The conversion unit 22 also converts the "Tayal call fee" of company A, whose billing breakdown code is "102", the "universal service fee" of company A, whose billing breakdown code is "103", and the "SMS communication fee" of company A, whose billing breakdown code is "105", into item data whose account code is "K002" and whose account name is "XX communication fee". The conversion unit 22 also converts the "amount equivalent to consumption tax" of company A, whose billing breakdown code is "104", into item data whose account code is "K003" and whose account name is "consumption tax".

[0058] In addition, the conversion unit 22 converts B company's "Flat rate communication fee (flat rate data plan)" with billing breakdown code "106", "Indoor wiring usage fee" with billing breakdown code "107", and "Lump sum basic fee discount" with billing breakdown code "108" into item data with item code "K001" and item name "XX communication fee".

[0059] Next, in step S15, the data generation unit 23 generates expense data including the converted item data, as exemplified in Fig. 12. Specifically, the data generation unit 23 generates expense data to include the billing item data before the conversion (billing item code and billing item name) and the item data generated by the conversion (item code and item name), as shown in Fig. 12. The data generation unit 23 also generates this expense data including the carrier code, carrier name, billing ID, and billing amount.

[0060] Next, the generated expense data can be changed (modified). When changing the expense data, the business operator specifies the display of the expense data via the input device 6. When this display is specified, the display control unit 25 displays the expense data via the output device 7. When the expense data is displayed, the business operator specifies a change to the expense data via the input device 6. This makes it possible to change the expense data, and the business operator changes a desired portion of the expense data to a desired value via the input device 6.

[0061] In step S16, the change processing unit 24 monitors whether or not such a change operation to the cost data has been performed. If no change operation to the cost data has been performed (step S16: No), the process proceeds to step S17. On the other hand, if a change operation to the cost data has been detected (step S16: Yes), the change processing unit 24 proceeds to step S19 and modifies the cost data in accordance with the change operation by the business operator.

[0062] When billing data needs to be corrected due to a contract with a carrier company, etc., if the billing data from the carrier company is directly corrected, the original data will be corrected, and if an error occurs in correcting the original data, the error will be carried over to subsequent processing. However, in the billing processing device 1 of the embodiment, corrections are made not to the original billing data, but to the expense data generated from the billing data. This makes it possible to prevent the inconvenience of a mistake made when correcting the original billing data being carried over to subsequent processing.

[0063] Next, in step S17, the data generation unit 23 generates journal entry data for accounting purposes as shown in Fig. 13 based on the expense data, and ends the processing of the flowchart in Fig. 10. The journal entry data shown in Fig. 13 is an example in which the debit side is XX communication expenses of 4400 yen and XX communication expenses of 400 yen, and the credit side is an amount payable of 4800 yen.

[0064] The generated journal data is sent to the accounting terminal device 30 and processed by the accounting system 40 at a timing specified by the business operator, or is stored in the storage unit 2 and processed by the accounting system 40. In this way, the billing processing device 1 of the embodiment can automatically generate expense data and journal data, thereby significantly reducing the workload of the business operator.

[0065] (Effects of the embodiment) As is clear from the above description, the billing processing device 1 of the embodiment automatically acquires data by specifying the import position on the layout, such as "column" or "row," based on the layout of billing data that differs for each carrier company. This makes it possible to import desired data such as item, payment category, cost category, etc. for each telephone number. In addition, of the acquired data, the breakdown data indicating the billing content is converted into item data of account items to generate expense data for accounting processing. Furthermore, based on this expense data, journal entry data for accounting is also generated. This makes it possible to significantly reduce the burden on business operators in processing billing data.

[0066] Furthermore, if the billing data needs to be corrected due to a contract with a carrier company, correcting the billing data from the carrier company directly would result in correcting the original data, which would cause the mistake to be carried over to subsequent processing if a mistake occurs in correcting the original data. However, in the billing processing device 1 of the embodiment, corrections are made not to the original billing data, but to the expense data generated from the billing data. This makes it possible to prevent a mistake made when correcting the original billing data from being carried over to subsequent processing.

[0067] In addition, the system can acquire desired data items in both cases where a "telephone number" is used as the identification number (ID) of the billing data and where a specific identification number (billing ID) is used. This makes it possible to provide a billing processing device 1 that is easy to use for business operators, etc.

[0068] [Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, and can therefore contribute to Goals 8 and 9 of the SDGs.

[0069] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of Goals 12, 13, and 15 of the SDGs.

[0070] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

[0071] [Other embodiments] The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0072] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

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

[0074] Furthermore, with regard to the billing processing device 1, the components shown in the figures are merely conceptual functional components, and the billing processing device 1 does not necessarily have to be physically configured as shown in the figures.

[0075] For example, the processing functions of the billing processing device 1, particularly the control unit 3 and each processing function performed by the control unit 3, may be realized in whole or in part by a CPU (Central Processing Unit) and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the billing processing device 1 as necessary. 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 HDD. This computer program is executed by being loaded into a RAM, and constitutes the control unit 3 in cooperation with the CPU.

[0076] In addition, the billing processing program of this billing processing device 1 may be stored in another server device connected to the billing processing device 1 via any network, and it is also possible to download all or part of it as needed.

[0077] In addition, the billing processing 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 any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical Disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.

[0078] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that achieves its function by working with a separate program, such as an OS. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading a recording medium in the billing processing device 1 shown in the embodiment, as well as the installation procedure after reading.

[0079] The memory unit 2 is a storage means such as a memory device such as RAM or ROM, a fixed disk device such as a hard disk, a flexible disk, or an optical disk, and stores various programs, tables, databases, and web page files used for various processes and providing websites.

[0080] The billing processing device 1 may be configured as an information processing device such as a known personal computer device or a workstation, or may be configured as an information processing device connected to any peripheral device. The information processing device may be realized by implementing software (including programs or data, etc.) that realizes the processing described in this embodiment.

[0081] Furthermore, the specific form of distribution and integration of the devices is not limited to those shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or function additions. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]

[0082] The present invention is suitable for application to a task of processing file data with a fixed layout. [Explanation of symbols]

[0083] 1. Billing Processing Device 2 Storage section 3. Control Unit 4. Communication Interface Section 5 Input / Output Interface Section 6 Input Devices 7 Output Devices 8 Network 11 Line Master 12 Account Master 13 Billing Item Master 13a First billing detail master 13b Second billing detail master 14 Billing ID Master 15 Date Master 16 Billing amount master 17 Subject Conversion Master 20 Carrier terminal equipment 21 Acquisition Department 22 Conversion section 23 Data Generation Division 24 Change Processing Section 25 Display control section 26 Master selection processing unit 30 Accounting terminal device 40 Accounting System

Claims

1. an acquisition unit that acquires data to be imported from an import position that is set based on a layout of the file data; A conversion unit that converts the data to be imported, which is acquired as a breakdown of the acquired data to be imported, into classification data indicating a predetermined classification; a data generating unit that generates information processing data for a predetermined information processing, including the classification data; The acquisition unit acquires at least the data to be imported of the breakdown and the billing amount data indicating the billing amount from each import position set based on a layout of the billing data indicating the billing amount, which is the file data; The conversion unit converts the data to be imported acquired as a breakdown into item data indicating an accounting classification, the data generation unit generates, as the information processing data, expense data for accounting processing including the item data and the billing amount data, and generates journal entry data for accounting based on the expense data; An information processing device comprising:

2. the acquiring unit acquires, from the file data, the data to be imported of a column to be imported that is set as the import position; 2. The information processing device according to claim 1,

3. The conversion unit converts the data to be imported acquired as a breakdown into item data indicating an accounting classification; 3. The information processing device according to claim 1 or 2,

4. Further comprising a change processing unit that changes a value of the generated cost data to a value according to a change operation of a business operator.

4. The information processing device according to claim 1, wherein:

5. the acquiring unit acquires the data to be imported from a first import position set based on a layout of file data or from a second import position different from the first import position; 5. The information processing device according to claim 1, wherein:

6. an acquiring step in which an acquiring unit acquires data to be imported from an import position set based on a layout of the file data; A conversion step in which a conversion unit converts the captured data acquired as a breakdown of the captured data into classification data indicating a predetermined classification; a data generating step in which a data generating unit generates information processing data for a predetermined information processing, the information processing data including the classification data; In the acquisition step, the acquisition unit acquires at least the data to be imported of the breakdown and the billing amount data indicating the billing amount from each import position set based on a layout of the billing data indicating the billing amount, which is the file data; In the conversion step, the conversion unit converts the data to be imported acquired as a breakdown into item data indicating an accounting classification, In the data generation step, the data generation unit generates, as the information processing data, expense data for accounting processing including the item data and the billing amount data, and generates journal data for accounting based on the expense data; An information processing method comprising:

7. Computer, an acquisition unit that acquires data to be imported from an import position that is set based on the layout of the file data; A conversion unit that converts the data to be imported, which is acquired as a breakdown of the acquired data to be imported, into classification data indicating a predetermined classification; a data generating unit that generates information processing data for a predetermined information processing, the information processing data including the classification data; The acquisition unit acquires at least the data to be imported of the breakdown and the billing amount data indicating the billing amount from each import position set based on a layout of the billing data indicating the billing amount, which is the file data; The conversion unit converts the data to be imported acquired as a breakdown into item data indicating an accounting classification, the data generation unit generates, as the information processing data, expense data for accounting processing including the item data and the billing amount data, and generates journal entry data for accounting based on the expense data; An information processing program characterized by:

Citation Information

Patent Citations

  • Accounting processor, accounting system, accounting method and program

    JP2019109808A

  • Data processing device, data processing method and program

    JP2022045315A

  • Information processing device, information processing method, and program

    WO2014030266A1

  • Accounting processing device, accounting processing system, accounting processing method, and accounting processing program

    WO2019146118A1