JP5253462B2 - Receipt data collection device for each store and its program - Google Patents

Receipt data collection device for each store and its program Download PDF

Info

Publication number
JP5253462B2
JP5253462B2 JP2010171513A JP2010171513A JP5253462B2 JP 5253462 B2 JP5253462 B2 JP 5253462B2 JP 2010171513 A JP2010171513 A JP 2010171513A JP 2010171513 A JP2010171513 A JP 2010171513A JP 5253462 B2 JP5253462 B2 JP 5253462B2
Authority
JP
Japan
Prior art keywords
receipt
store
information
data
item
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
JP2010171513A
Other languages
Japanese (ja)
Other versions
JP2012032979A (en
Inventor
一成 野崎
泰広 梅村
Original Assignee
株式会社富士通マーケティング
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 株式会社富士通マーケティング filed Critical 株式会社富士通マーケティング
Priority to JP2010171513A priority Critical patent/JP5253462B2/en
Publication of JP2012032979A publication Critical patent/JP2012032979A/en
Application granted granted Critical
Publication of JP5253462B2 publication Critical patent/JP5253462B2/en
Application status is Active legal-status Critical
Anticipated expiration legal-status Critical

Links

Images

Description

  The present invention relates to a store-specific receipt data collection device that collects and manages sales of a plurality of stores such as a shopping center, and a program thereof.

  The tenant management department that manages the stores of tenants (such as companies that operate stores) that open stores in shopping centers, shopping malls, etc. collects the daily sales of each store and collects cash sales, credit card sales, coupon sales, etc. A breakdown of sales is being created. As a method of creating the sales breakdown, for example, a business person in the tenant management department generally inputs a sales breakdown manually by looking at a payment receipt or a daily sales report provided from each store. In some cases, a dedicated data input terminal is installed in each tenant's store and the person in charge at each store inputs the sales breakdown.

  In Patent Document 1, coded information such as QR code (registered trademark) is added to print information, and a PC (Personal Computer) or the like is used by performing reading, processing, and printing by a multifunction device capable of reading / printing. Multifunction machine that provides a means for eliminating the troublesomeness and inaccuracy of data input, and can obtain a desired processing result simply by placing a plurality of originals on a platen. Has been proposed.

JP 2007-81650 A

  The tenant management department of the company (organization) that operates the shopping center, etc. when entering the breakdown of sales by looking at the payment receipts (hereinafter referred to as receipts) and daily sales reports provided by each store such as the shopping center as described above The person in charge of business spends a considerable amount of time for the input work and the check work after the input. Also, it takes a considerable amount of time to check whether or not the sales breakdown entered is correct, and to check and correct the input data such as receipts, daily sales reports, and credit gifts. Therefore, the current situation is that the business person in charge of the tenant management department spends most of the daily work on the management work such as these work.

  It is best if sales data can be automatically collected online from the terminals of each store, but in large-scale shopping malls, etc., there may be a large number of stores of 100 or more. Since the types of devices are different, it is actually very difficult to modify these information devices so that they can handle data collection in a unified manner.

  FIG. 17 shows an example of actual analysis of daily processing work in the tenant management department. FIG. 17 shows the contents, work time (minutes), and the ratio to the total work time for each work item. The “daily report” shown in FIG. 17 is a daily receipt provided by each store, a daily sales table, and the like.

  FIG. 18 shows a daily sales report spelling 200 as an example of “daily report”. As for the daily sales report spelling 200, for example, tenant management departments hand the paper in a unified format to each store in advance. As shown in FIG. 18, the person in charge at each store describes the store code, the store name, etc. in the entry field 201 of the daily sales report spelling 200, and affixes a receipt 202 printed from a cash register provided in the store. In addition, since the cash register model is different for each store, the arrangement and names of the breakdowns of the receipt 202 are different, and the printing formats are various.

  19 and 20 show examples of settlement items by the tenant management department and examples of settlement receipts (hereinafter referred to as receipts) by each tenant (or store).

  In a tenant management department such as a developer, data necessary as daily sales summary data of each tenant store is, for example, a checkout item as shown in FIG. On the other hand, the receipt printed from each cash register at each store is a receipt 210 as shown in FIG. 19B, a receipt 220 as shown in FIG. The number of receipt items, the contents of receipt items, the printing position, and the format differ from store to store, as shown in FIG.

  From these various receipts 210, 220,..., The tenant management department has a numerical value corresponding to the “cash sales” adjustment item required for aggregation, a numerical value corresponding to the “payment sales” adjustment item, and so on. The numerical values of the first to eleventh settlement items are selected and input manually to the receipt data collection device managed by the tenant management department. This work is a work that must be performed every day, and is a heavy work load.

  Since the operations described above are involved, as shown in the example of FIG. 17, in the work of the tenant management department, 300 minutes (53%) of the total 571 minutes of daily work hours are as described above. The daily report check work (item No. 5) of “daily report” is occupied, and if the daily report correction work (items No. 3 to 6) is included from the preparation of the daily report bag, it is 350 minutes (61%). Including the subsequent sales correction / input (item No. 7) and gift certificate correction / input (item No. 8), the total amount reaches 420 minutes (74%).

  The above-mentioned problem is proportional to the number of stores, especially the item No. described above. 3-No. 8 and no. The workload of 17 will further increase.

  Further, in the technique of Patent Document 1, in order to read the QR code in which the receipt information is recorded and obtain the receipt information, the QR code is printed in which all the contents are recorded in the receipt and the daily sales report provided from each tenant's store. Is required. Since each tenant is an independent company, in order to print QR codes on receipts and sales daily reports, it is necessary to modify the system installed in-house, and burden each company on system modification, equipment replacement, etc. Will be asked.

  In addition, even when a QR code is printed on a receipt or the like, if it cannot be read due to printing smudges or unclear printing, manual correction and input work are required. Furthermore, it is necessary to check the read receipt information and the actually printed receipt contents.

  On the other hand, there is a method of installing a data entry terminal at each tenant's store and letting the person in charge of each store enter the breakdown of sales. In this case, however, each tenant places a great burden in terms of personnel and labor costs. .

  In view of the above points, the present invention collects sales data from each tenant's store accurately and efficiently without drastically changing the current system such as information devices at each store, thereby increasing the speed and efficiency of sales management operations. It aims to make it easier.

In order to solve the above-mentioned problems, the present invention is a receipt data collecting device for each store that collects receipt data printed in a different format for each store, and at least a receipt sandwiching sheet formed of a transparent sheet on the reading side Means for reading the image information of the receipt sandwiched between the sheets and the store identification code displayed on the receipt sandwiching sheet by an image input device, and printing the receipt corresponding to the store identification code for each store Store information including layout information and item names printed on receipts, and as the store information , correspondence information between basic items extracted in common from receipt data of each store and receipt items for each store and the shop information storage means but for storing items corresponding information set, the identification code of the read store Identifying the store information in the store information storage means, and analyzing the image information of the read receipt based on the print layout information of the receipt corresponding to the store identification code and the item name printed on the receipt A means for recognizing the character or number data printed corresponding to the item name, a receipt data storage means for storing the receipt data of the recognition result for each store, and a receipt of the recognition result for each store. It comprises a form data processing means for generating form data by extracting, from the data, numerical information of unified basic items common to each store using item correspondence information of the corresponding store .

As a result, receipt items created in various different formats for each store can be automatically read, and sales counting can be performed efficiently and in a short time. In addition, basic data required by the data management department can be collected in a unified manner from the receipt data of each store having different receipt items.

  In the present invention, the store information storage means may store at least one receipt between one receipt holding sheet or one receipt holding sheet as the store information. Further storing receipt type information indicating whether or not a plurality of receipts are sandwiched, and the means for recognizing the character or numerical data printed on the receipt according to the receipt type information obtained from the store information It is characterized by recognizing.

  As a result, even if the number of receipts to be counted for each store is different, it is possible to register in advance as store information which store is what type of receipt, so it is possible to handle various types of receipts. it can. In particular, even in a store where the receipt is longer than the receipt holding sheet, the receipt item information can be read without any trouble by dividing the receipt at a predetermined position and holding the receipt side by side on the receipt holding sheet.

The effects of the present invention are as follows.
(1) Since various types of receipts at each store are sandwiched between receipt sandwiching sheets, the receipt sandwiching sheets are read by a reader, and sales information is automatically read using them. Labor saving and speeding up of input work can be achieved.
(2) The type of receipt to be read is based on the store information in which the issuing store is specified by the store identification code displayed on the receipt sandwiching sheet and registered and set for each store in advance. Information such as what item name the receipt has and the number of receipts can be used for image analysis, and the accuracy of reading can be improved including character recognition.
(3) Further, basic data required by the data management department can be uniformly collected from the receipt data of each store having different receipt items, and stored in a sales database or the like.

It is a figure which shows the apparatus structural example of embodiment of this invention. It is a figure explaining the sheet | seat for receipt clamping. It is a figure explaining the sheet | seat for receipt clamping. It is a figure explaining a receipt type. It is a figure explaining a receipt type. It is a figure explaining a store information table. It is a figure which shows the example of receipt layout information. It is a figure which shows the example of receipt item information. It is a process flowchart of the receipt data collection apparatus according to store which concerns on embodiment of this invention. It is a figure explaining the range which reads the image data of a receipt. It is a figure which shows the example of the result of having cut out the image data of a receipt in the line unit and the character unit. It is a figure which shows the example of the receipt item by which data normalization was carried out. It is a figure which shows the example of the receipt data of the result of having read the receipt. It is a figure which shows the example of the correspondence of a settlement item and a receipt item. It is a figure which shows the example of the correspondence of a settlement item and a receipt item. It is a figure which shows the example of sales DB. It is a figure which shows the example of business analysis of a tenant management business. It is a figure which shows an example of a sales daily report. It is a figure explaining the subject of a conventional method. It is a figure explaining the subject of a conventional method.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. In the following, an example of an apparatus for totalizing store sales will be described. However, the present invention is not limited to sales totalization, and totals actual data printed on purchase total data or other slips. Can be applied as well.

  FIG. 1 shows an apparatus configuration example for explaining the outline of the present invention. In FIG. 1, reference numeral 1 is composed of a CPU and a storage device such as a hard disk and a memory, etc., and a receipt data collecting device for each store for executing processing relating to sales totalization, and 20 is an identification code 21 (FIG. 2) associated with each store. Is a receipt holding sheet for holding the receipt 22 (shown in FIG. 2) of each store.

  When the receipt holding sheet 20 collected from the store is input to the receipt data collecting apparatus 1 for each store, the input receipt holding sheet 20 is processed as image data. The receipt data collecting apparatus 1 for each store reads the receipt data of the receipt 22 of the store and the corresponding numerical value from the image data, and calculates the sales breakdown data of the settlement item with the unified name from the read receipt data. Generate and save. This checkout item is basic item information determined in advance to be stored in the sales DB (database) 114.

  In addition, the receipt 22 is printed with the result of totaling the sales of the store for one day for each tenant store, for example, with a cash register provided for each store. Further, these receipts 22 are shown as an example related to sales aggregation, and may be related to purchase aggregation and other form processing in addition to sales aggregation.

  First, the receipt clamping sheet 20 will be described with reference to FIGS. 2 and 3. FIG. 2 is a diagram showing a configuration of one embodiment of the receipt clamping sheet 20. 2A is a top view of the receipt sandwiching sheet 20 as viewed from the transparent film 231 side, and FIG. 2B is a receipt sandwiching sheet 20 in which the receipt 22 is sandwiched by the transparent sheet 23. FIG. It is a perspective view explaining the previous state.

  As shown in FIG. 2A, for example, the receipt holding sheet 20 holds a receipt 22 of each store on a transparent sheet 23 with a mount. In the upper right corner of the transparent sheet 23, an identification code 21 (two-dimensional code such as a QR code) corresponding to the store is marked by printing or sticking.

  As shown in FIG. 2B, the transparent sheet 23 is, for example, a transparent film (sheet) 231 and a mount 232 connected (adhesive or the like) at one end 233, and in a state before the receipt 22 is sandwiched, 23 is in a half-opened state. The receipt 22 is placed on the mount 232 of the transparent sheet 23 in the semi-opened state, and the receipt 22 is sandwiched by, for example, bonding the transparent film 231 having a sticky surface with adhesive and the mount 232. The above-described identification code 21 is marked by printing, sticking, or the like within a range positioned at the upper right corner of the mount 232, for example.

  FIG. 3 shows the configuration of another embodiment of the receipt clamping sheet 20. The transparent sheet 23 used for the receipt sandwiching sheet 20 shown in FIG. 3 has a sheet 234 and a transparent film 235 connected to each other at a side end 236 and a lower end 237, and is in a semi-open state like a case-shaped holder. is there. Further, a partition 238 (broken line in FIG. 3) is provided at the center, and each of the two receipts 22 can be sandwiched by the transparent sheet 23 on one side and the other side with the partition 238 as a boundary. ing. In this example, the sheet 234 and the transparent film 235 are bonded along the broken line for a part of the partition 238 indicated by the broken line.

  Various methods can be used for each store as a method of holding the receipt 22 on the receipt holding sheet 20. The clamping method corresponding to the type of receipt 22 is called a receipt type. Since the length and number of receipts 22 are different for each store, a receipt type is predetermined for each store. 4 and 5 show examples of receipt types.

  For example, the receipt type of the receipt sandwiching sheet 20A shown in FIG. 4A is a type in which one receipt 22A is sandwiched between one receipt sandwiching sheet 20A. This is called receipt type 1. A receipt 22A is held at a predetermined position on the receipt holding sheet 20A of the store corresponding to the identification code 21A. Here, the predetermined position is a range of positions that are registered in advance in the store-specific receipt data collecting apparatus 1 in order to determine where the receipt 22 is located on the transparent sheet 23 (23A) and do not have a practical effect. It means being inside. The range of the position that does not affect the practical use may be a range that does not significantly affect the OCR processing of the image data.

  The receipt type shown in FIG. 5 (A) is a type used when the receipt 22B is too long to fit in the receipt holding sheet 20B. This is called receipt type 2.

  For example, when the length of the receipt 22B in the store corresponding to the identification code 21B is longer than the vertical length of the receipt sandwiching sheet 20B, the receipt 22B is received at the store 22B1 at an appropriate predetermined position. Cut into receipt 22B2. These receipt 22B1 and receipt 22B2 are arranged on the receipt clamping sheet 20B. This receipt clamping sheet 20B is a receipt clamping sheet 20 of the type shown in FIG.

  The receipt type shown in FIG. 5B is a second example of a type used when the receipt 22B is too long to fit in the receipt holding sheet 20B. This is called receipt type 3. In this type, two receipts 22B1 and 22B2 obtained by cutting the receipt 22B are arranged on the receipt holding sheets 20C and 20D, respectively, and are read twice.

  In addition, for receipt types 2 and 3, an example has been described in which receipts 22B1 and 22B2 obtained by cutting one receipt 22B are read, but this receipt type is also used when a plurality of receipts are issued from the beginning by a store. 2, 3 can be used.

  Information such as the receipt type as described above and receipt items included in the receipt 22 is registered and stored in advance in the store information storage unit 112 for each store. These store information will be described in detail later.

  Next, the structure of the store-specific receipt data collection apparatus 1 for inputting the receipt holding sheet 20 will be described. The store-specific receipt data collecting apparatus 1 includes a reader 10, an image data reading unit 11, a store information specifying unit 12, a receipt data determining unit 13, and a form data processing unit 14. Furthermore, the store-specific receipt data collection device 1 includes storage means such as an image data storage unit 111, a store information storage unit 112, a receipt data storage unit 113, and a sales DB storage unit 114. The functions of these units, which will be described in detail later, are realized by hardware such as a CPU and memory and a software program.

  The reader 10 of the store-specific receipt data collection device 1 is an optical image reading device such as a scanner, for example, and the image data reading unit 11 inputs the image data of the receipt sandwiching sheet 20 read by the reader 10, Saved in the image data storage unit 111. The image data is stored in the image data storage unit 111 as a bitmap format file, for example.

  In this example, the reader 10 is described as being configured in the store-specific receipt data collection device 1, but the store-specific receipt data collection device 1 may not include the reader 10. When the reader 10 is not provided, the image data reading unit 11 of the store-specific receipt data collecting apparatus 1 is configured to input image data via an external reader or the like.

  The store information specifying unit 12 reads the image data stored in the image data storage unit 111, first extracts the identification code 21 from the read image data, and stores the decoding result of the identification code 21 (this is called the recognition code). In addition, the store that issued the receipt 22 is specified from the store information stored in the store information storage unit 112.

  FIG. 6 shows a configuration example of the store information table 1120 stored in the store information storage unit 112. In the store information table 1120, for example, as shown in FIG. 6, for each store, “recognition code” obtained from the identification code 21, “store code” for identifying the store, “store name”, “receipt layout information”, Store information such as “receipt item information” and “item correspondence information” is registered and stored.

  Here, the “recognition code” is a data obtained by decoding the identification code 21 such as a QR code, for example, and is uniquely associated with each store. The “store code” is a number for identifying a store in the tenant, and the “store name” is the name of the store, the store name of the tenant, and the like.

  In the example of FIG. 6, the store information table 1120 stores a store code “1111”, a store name “XX store No. 1 store”, and the like as store information of the store corresponding to the decrypted recognition code “A1A1A1A1”. Other recognition codes “B2B2B2B2” and the like are stored in the same manner. The “recognition code” may be a “store code”.

  An example of the receipt layout information 1121 is shown in FIG. In this example, the receipt layout information 1121 includes the above-described receipt type information, the printing start position of the reading range of the receipt 22 in the receipt holding sheet 20, and information indicating the reading range of the receipt 22 such as the number of lines to be read ( The number of lines to be recognized by the receipt 22) is set.

  Since the number of receipts 22 to be read may be different for each store, a plurality of print start positions in the receipt layout information 1121 may be set depending on the receipt type. The receipt layout information 1121 may be stored as a table separately from the store information table 1120.

  The receipt item information 1122 is information indicating the name of the sales breakdown item of the receipt 22 for each store, the type of numerical value corresponding to the name, and the like. Here, for example, in the receipt 210 as shown in FIG. 19B, the sales breakdown items are items shown in each row such as “daily sales amount”, “registration sales amount”, and so on.

  An example of the receipt item information 1122 is shown in FIG. The receipt item information 1122 includes “line number”, “MAX digit number”, “character number of character item”, “number of numeric items in one line”, “numeric type # 1” for each line of the reading range in the receipt 22. , # 2..., Etc. are set in advance and stored.

  For example, if the character printed on the first line of the receipt 22 is a character string 1301 as shown in FIG. 8, the line number of the receipt item information 1122 is set to 1, and the MAX digit number is 1 The maximum number of characters (number of digits) that can be printed on the line is set to 24, and the number of characters in the character item is set to 3 because the character item is “total sales”. Further, 2 is set as the number of numeric items in one line, and information such as whether or not a unit is attached to each numeric item is set as each numeric type # 1, # 2. In this example, since the unit of “point” is attached to the first numerical value, 2 is set to the numerical value type # 1. The receipt item information 1122 may also be stored as a table different from the store information table 1120.

  Details of the item correspondence information 1123 in the store information table 1120 will be described later using the examples of FIGS. 14 and 15.

  The receipt data discrimination unit 13 receives store information and image data from the store information identification unit 12 and converts the image data into OCR (Optical Character Recognition) data. That is, the receipt data determination unit 13 extracts a character portion from the image data of the receipt 22 and restores it as text data (OCR data). The receipt data discriminating unit 13 normalizes the text data of the recognition result into a predetermined format.

  The form data processing unit 14 uses the receipt data normalized by the receipt data determination unit 13 and the store information to perform a process of replacing the receipt item (sales breakdown) of the receipt of each store with a unified checkout item. . The form data processing unit 14 stores the settlement item data processed for each store (and each sales date) in the sales DB 114 which is a database prepared in advance.

  FIG. 9 is a processing flowchart of the store-specific receipt data collecting apparatus 1 according to the embodiment of the present invention. The processing executed by the store-specific receipt data collecting apparatus 1 will be specifically described with reference to FIG.

  When the receipt holding sheet 20 is input to the reader 10 of the store-specific receipt data collecting apparatus 1, this processing is started. In the following description, it is assumed that the receipt sandwiching sheet 20A shown in FIG.

  The image data reading unit 11 reads the image of the receipt clamping sheet 20A scanned by the reader 10, and stores the image data in the image data storage unit 111 (step S1).

  Next, the store information specifying unit 12 extracts the identification code 21 from the image data of the receipt holding sheet 20 </ b> A stored in the image data storage unit 111, and stores it in the store information storage unit 112 based on the extracted identification code 21. The store information table 1120 (FIG. 6) is referred to, and the store code is specified (step S2). Next, the store information specifying unit 12 reads store information such as receipt layout information 1121, receipt item information 1122 associated with the specified store code (step S3).

  The receipt data determination unit 13 determines the position and range to be read as the image data of the receipt 22A using the receipt layout information 1121 and the receipt item information 1122 of the store information read by the store information specifying unit 12 (step S4).

  For example, FIG. 10 shows an example of the reading position and range of the receipt 22A. Actually, the receipt 22A shown in FIG. 10 is sandwiched between the receipt sandwiching sheets 20A. Therefore, the print start positions # 1 and # 2 include the image position of the receipt portion in the image data of the entire receipt sandwiching sheet 20A. And determined.

  The print start positions # 1, # 2, MAX digits, and the number of lines PL to be read shown in FIG. 10 are information obtained from the receipt layout information 1121 shown in FIG. Specifically, the receipt range 221A of the receipt 22A shown in FIG. 10 is the receipt type of the receipt 22A when the receipt layout information 1121 of the store specified by the store information specifying unit 12 is information as shown in FIG. “1”, print start position # 1 is “100 mm”, print start position # 2 is “10 mm”, and the number of lines to be read is “27”. As determined. As a result, the range necessary for the receipt item of the receipt 22A held by the receipt holding sheet 20A is narrowed down, and unnecessary items, characters, symbols, and the like can be removed.

  Next, the receipt data determination unit 13 reads image data for performing OCR processing from the image data for the read range of the determined receipt 22A (step S5). Next, the processing of step S7 and step S8 is repeated until the processing of the last line of the receipt 22 is completed (step S6).

  First, the receipt data discriminating unit 13 performs processing for cutting out image data line by line from the image data of the receipt 22A based on the receipt item information 1122 as shown in FIG. 8 (step S7). Furthermore, character recognition is performed by cutting out image data in character units from the cut out line-by-line image data (step S8).

  FIG. 11 shows an example of a result 130 obtained by recognizing and recognizing the image data of the receipt 22A in units of lines and characters.

  When the processing up to the last line is completed, the receipt data determination unit 13 performs data normalization on the item name and the numerical value obtained from the information cut out and recognized in line units and character units (step S9).

  FIG. 12 shows an example of the receipt item 131 with data normalized. The receipt item 131 shown in FIG. 12 shows an example in which the receipt item recognition result 130 shown in FIG. 11 is normalized. For example, processing such as left justification for item names and removal of “,” for numerical values, etc. Has been done. For example, for “148,467” in the first line, the numerical value is normalized to “148467”, and the item name “Internal tax” in the third line is “Internal tax”. Extra text characters such as "" and "" are removed.

  After data normalization, the receipt data determination unit 13 classifies the normalized data into receipt item names and numerical values, generates receipt data 1130 as shown in FIG. 13, and generates the generated receipt data 1130. And the store code are stored in the receipt data storage unit 113 (step S10).

  Subsequently, the form data processing unit 14 uses the receipt data 1130 and the item correspondence information 1123 for each store set in the store information table 1120 to determine each checkout item required by the tenant management department. Is calculated and written to the sales DB 114 for each store (step S11).

  FIG. 14 and FIG. 15 show examples of correspondence between receipt items for each store and settlement items by the tenant management department. 14 and 15, the receipt data is shown in the form of actual receipts 210 and 220. In FIG. 14 and FIG. 15, the item correspondence information 1123 for each store set in the store information table 1120 is shown as a correspondence table between the adjustment items and the receipt items.

  In this example, the sales summary data actually required by the tenant management department for tenant sales management is No. No. 001 from cash sales of 001. 11 checkout items up to 011 customers. However, these checkout items are not printed as they are in a one-to-one relationship as the items of the receipts 210 and 220 of each store. Therefore, processing for calculating each of the eleven settlement items from the receipt item of each store is performed using the item correspondence information 1123 for each store.

  In the case of the receipt 210 in FIG. 14, the amount obtained by adding the value of the “thank you card” of the seventh item to the “cash amount on daily report” of the 19th item is equivalent to “cash sales” of the first settlement item. This is shown in the item correspondence information 1123. Therefore, in the case of the receipt 210 store, the form data processing unit 14 sets 122,793 yen (cash amount on daily report) + 2,500 yen (thank you card) = 125,293 yen to the first cash item “cash Value of “sales”.

  On the other hand, in the case of the receipt 220 in FIG. 15, the item correspondence information 1123 indicates that the amount of “cash sales” of the 14th item corresponds to “cash sales” of the first settlement item as it is. Accordingly, the form data processing unit 14 sets 139,639 yen (cash sales) as the value of the “cash sales” of the first settlement item as it is in the case of the store of the receipt 220. Similarly, other settlement items are calculated according to item correspondence information 1123 which is a correspondence table between settlement items and receipt items, and the calculated settlement items are stored in the sales DB 114.

  FIG. 16 shows an example of the sales DB 114. In the sales DB 114, for each store code, “sales date”, checkout item No. 001 “Cash Sales”, No. 002 “Kake-sales”, No. A numerical value corresponding to a settlement item relating to sales such as 003 “credit sales”,.

  As described above, in the sales DB 114, the receipt items of the receipt 22 in a completely different format (sheet format) for each store are unified, and the receipt items, names, and numerical values that cannot be unified by the receipts output by the stores of each tenant. Can be collected automatically without manual input as sales data based on unified checkout items. As a result, the person in charge of the tenant management department can automatically count the sales for each store, so that the store sales management business can be performed efficiently and speedily.

  Further, since there is no need to change a receipt output device such as a cash register provided in each store, unnecessary expenses for the tenant can be suppressed.

  The processing performed by the store-specific receipt collection apparatus described above can be realized by a computer and a software program, and the program can be recorded on a computer-readable recording medium or provided through a network.

DESCRIPTION OF SYMBOLS 1 Receipt data collection apparatus according to store 10 Reader 11 Image data reading part 12 Store information specific | specification part 13 Receipt data discrimination | determination part 14 Form data processing part 20 Receipt clamping sheet 111 Image data storage part 112 Store information storage part 113 Receipt data storage part 114 Sales DB (Database)

Claims (3)

  1. A store-specific receipt data collection device that collects receipt data printed in different formats for each store,
    Means for reading, with an image input device, image information of a receipt held by a receipt holding sheet formed of a transparent sheet at least on the reading side, and a store identification code displayed on the receipt holding sheet;
    Store information including the print layout information of the receipt corresponding to the store identification code and the item name printed on the receipt is stored for each store, and the store information is further shared from the receipt data of each store. Store information storage means for storing item correspondence information in which correspondence information between basic items to be extracted and receipt items for each store is set ;
    The store information in the store information storage means is specified from the read store identification code, and the read information is based on the print layout information of the receipt corresponding to the store identification code and the item name printed on the receipt. Means for recognizing the character or number data printed corresponding to the item name by analyzing the image information of the receipt;
    Receipt data storage means for storing the receipt data of the recognition result for each store ;
    Form data processing means for creating form data by extracting, from the receipt data of the recognition results for each store, numerical information of unified basic items common to each store using item corresponding information of the corresponding store The receipt data collection apparatus classified by store characterized by the above-mentioned.
  2. In the receipt data collecting apparatus according to store according to claim 1,
    The store information storage means determines, as the store information, whether at least one receipt is sandwiched between one receipt sandwiching sheet or a plurality of receipts are sandwiched between one receipt sandwiching sheet. Store the receipt type information shown
    The said receipt means recognizes the character or number data printed on the said receipt according to the receipt type information obtained from the said store information. The receipt data collection apparatus classified by store characterized by the above-mentioned.
  3. A store-specific receipt data collection program for collecting receipt data printed in different formats for each store,
    Computer
    Means for reading, with an image input device, image information of a receipt held by a receipt holding sheet formed of a transparent sheet at least on the reading side, and a store identification code displayed on the receipt holding sheet;
    Store information including the print layout information of the receipt corresponding to the store identification code and the item name printed on the receipt is stored for each store, and the store information is further shared from the receipt data of each store. Store information storage means for storing item correspondence information in which correspondence information between basic items to be extracted and receipt items for each store is set ;
    The store information in the store information storage means is specified from the read store identification code, and the read information is based on the print layout information of the receipt corresponding to the store identification code and the item name printed on the receipt. Means for recognizing the character or numerical data printed corresponding to the item name by analyzing the image information of the receipt;
    Receipt data storage means for storing the receipt data of the recognition result for each store ;
    As the form data processing means for creating form data by extracting the numerical information of the unified basic items common to each store from the receipt data of the recognition result for each store using the item correspondence information of the corresponding store ,
    Receipt data collection program by store to make it function.
JP2010171513A 2010-07-30 2010-07-30 Receipt data collection device for each store and its program Active JP5253462B2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
JP2010171513A JP5253462B2 (en) 2010-07-30 2010-07-30 Receipt data collection device for each store and its program

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
JP2010171513A JP5253462B2 (en) 2010-07-30 2010-07-30 Receipt data collection device for each store and its program
CN 201110033395 CN102346843B (en) 2010-07-30 2011-01-31 Data collecting apparatus based on store receipt

Publications (2)

Publication Number Publication Date
JP2012032979A JP2012032979A (en) 2012-02-16
JP5253462B2 true JP5253462B2 (en) 2013-07-31

Family

ID=45545506

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2010171513A Active JP5253462B2 (en) 2010-07-30 2010-07-30 Receipt data collection device for each store and its program

Country Status (2)

Country Link
JP (1) JP5253462B2 (en)
CN (1) CN102346843B (en)

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP6424438B2 (en) * 2014-02-24 2018-11-21 セイコーエプソン株式会社 POS system and data processing apparatus
KR101798990B1 (en) * 2014-10-02 2017-11-20 에스케이플래닛 주식회사 User equipment, control method thereof and computer readable medium having computer program recorded therefor
US10339516B2 (en) 2015-01-09 2019-07-02 Seiko Epson Corporation Information processing device, information processing system, and control method of an information processing device
JP6443057B2 (en) * 2015-01-09 2018-12-26 セイコーエプソン株式会社 Control device and control method of control device
TWI660312B (en) * 2017-07-26 2019-05-21 鯨動智能科技股份有限公司 Automatic intellgent accounting system
CN109460725B (en) * 2018-10-29 2019-10-01 苏州派维斯信息科技有限公司 Receipt consumption details content mergence and extracting method, equipment and storage medium

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1205496A (en) * 1997-07-16 1999-01-20 戚铭俊 Laser holographic position value numeral mark
JP2002024760A (en) * 2000-06-30 2002-01-25 Toshiba Corp Character reading method, character reader, and carrier sheet
US7305129B2 (en) * 2003-01-29 2007-12-04 Microsoft Corporation Methods and apparatus for populating electronic forms from scanned documents
JP4193637B2 (en) * 2003-08-19 2008-12-10 富士通株式会社 Product data registration device and product data registration method
JP2005092635A (en) * 2003-09-18 2005-04-07 Ricoh Co Ltd Receipt information collection and processing system
JP2008234586A (en) * 2007-03-23 2008-10-02 Nomura Research Institute Ltd Consumption information acquiring terminal, consumption information acquiring server and household account book management device

Also Published As

Publication number Publication date
CN102346843A (en) 2012-02-08
JP2012032979A (en) 2012-02-16
CN102346843B (en) 2015-04-01

Similar Documents

Publication Publication Date Title
EP0209907B1 (en) Computer system for plural types of independent management and method for operating a general purpose computer management system
US8167196B2 (en) Expanded mass data sets for electronic check processing
US8628116B2 (en) Transparent deposit carrier having a plurality of pockets
US8879846B2 (en) Systems, methods and computer program products for processing financial documents
CN1282937C (en) Medium processor and medium processing method
US6625313B1 (en) Business form handling method and system for carrying out the same
EP1271378A2 (en) Administration process and system for manufacturing and selling products
US20050065893A1 (en) System and Method for Commingled Remittance Payment Processing
US20050165651A1 (en) Point of sale business transaction data gathering using portable memory device
US9165391B2 (en) Receipts scanner and financial organizer
US20150110362A1 (en) Systems, methods and computer program products for determining document validity
US20020016764A1 (en) Internet expense account
US5433483A (en) Consumer-initiated, automatic classified expenditure bank check system
US10134023B2 (en) System and method for division and management of expenses
US20060226980A1 (en) Systems and methods for capturing workflow information
EP1676247A1 (en) Method and apparatus for processing checks
US8418920B2 (en) Systems methods and computer program products for encoding and decoding transaction data
US20050018896A1 (en) System and method for verifying legibility of an image of a check
KR101686481B1 (en) A tax refund system
CA2131667A1 (en) System for automatic compilation of customer information database from bank check data
US9117247B2 (en) Systems methods and computer program products for encoding and decoding tax return data
JPH07244702A (en) Check processor
US20030183685A1 (en) Coding, tracking and reporting negotiable items and related non-negotiable documents
WO1993014476A1 (en) A method for making and collecting donations
JP2014206960A (en) Book creation system, method and program and printed voucher

Legal Events

Date Code Title Description
A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20121206

A871 Explanation of circumstances concerning accelerated examination

Free format text: JAPANESE INTERMEDIATE CODE: A871

Effective date: 20121220

A975 Report on accelerated examination

Free format text: JAPANESE INTERMEDIATE CODE: A971005

Effective date: 20130128

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20130205

A521 Written amendment

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20130314

TRDD Decision of grant or rejection written
A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20130416

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20130416

R150 Certificate of patent or registration of utility model

Free format text: JAPANESE INTERMEDIATE CODE: R150

FPAY Renewal fee payment (event date is renewal date of database)

Free format text: PAYMENT UNTIL: 20160426

Year of fee payment: 3

S531 Written request for registration of change of domicile

Free format text: JAPANESE INTERMEDIATE CODE: R313531

R350 Written notification of registration of transfer

Free format text: JAPANESE INTERMEDIATE CODE: R350

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250