JP2005122262A - Household account book program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a household account book program making a computer realize a function automatically taking in data on details of a purchase name, an item, a money amount or the like. <P>SOLUTION: An electronic mail reception part 13 receives an electronic mail stored in a mail server of an ISP, and attached with electronic receipt data 16 recorded with a purchase date, the article name of a purchased commodity, the item of the purchased commodity, the money amount of the commodity, or the like. A money reception/payment management part 14 has a function recording and totaling money reception/payment data 17 comprising an item, a money amount or the like of income or expenditure which general household account book software has, additionally, acquires the electronic receipt data 16 attached to the electronic mail, and incorporates the item or the money amount recorded in the electronic receipt data 16 into the money reception/payment data 17. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to a household account book program for causing a computer to realize a function of automatically fetching data of details such as purchased product names, items, and amounts.

  In recent years, the penetration of computers into ordinary households has been remarkable, and application programs are also provided for household accounts and address books that were managed by conventional ledgers, and information management by computers is natural It is becoming.

  Such an application program has a variety of convenient functions such as a function for automatically performing work that has been conventionally performed by a person, such as calculating the total of income and expenditure for a household account book.

  However, the most basic data must be entered by humans. In particular, in the case of household accounts, the amount of purchased goods is currently entered into the computer while looking at the receipt, and there is human work, which is a cause of erroneous input of the amount. It was.

Also, at the store side, information on the purchased product is recorded on the checkout card, and at home, the purchased product information recorded on the checkout card is read using a card reader, and the household account book creation process is automatically performed. However, this is a complicated task of recording information on the checkout card at the store side, and there is a human work, which may cause incorrect input of the amount of money. It was.
JP 2001-84293 A

  The problem to be solved is the intervention of human work in data management, and a household account book program that allows a computer to realize a function for automatically fetching data of details such as purchased product names, items, and amounts sent via a network The purpose is to provide.

  In order to achieve the above object, the present invention is a household account book program executed on a computer for managing the amount of money related to income and expenditure as deposit / withdrawal data, which is input from a cash register at the time of product purchase. Receiving means for receiving, via a communication network, electronic receipt data recorded by the management server that manages the settlement data, at least the purchase date and time, the name of the purchased product, the item of the purchased product, and the price of the product. The purchase date and time, the product name, the item, and the amount of money are acquired from the electronic receipt data received by the receiving unit, and function as a deposit / withdrawal management unit that records in the deposit / withdrawal data.

  According to the present invention, since detailed data such as purchased product names, items, and amounts are automatically taken in, it is possible to reduce input work, and to accurately calculate the household account book without causing erroneous input. be able to.

  An embodiment of the present invention will be described with reference to FIGS. FIG. 1 shows the configuration of the entire system.

  The store-side system in the present embodiment is composed of a management server 1 and a plurality of cash registers 2, which are connected to each other by a network 3 such as a LAN, and the management server 1 is connected to the Internet 5.

  The cash register 2 includes a card reader that reads a card in which information identifying the customer such as a point card or a membership card is recorded, and the name of the product purchased by the customer after the accounting process such as deposits and withdrawals normally performed at a store. The payment data 15 including information such as the number of purchases and the amount of money is transmitted to the management server 1 via the network 3.

  The management server 1 includes an e-mail transmission unit 11 and stores customer management data 12 in an auxiliary storage device (not shown). As shown in FIG. 2, the customer management data 12 is a data table comprising items of customer number, customer name, e-mail address, electronic receipt flag, address, and telephone number. An e-mail address that is a transmission destination of the e-mail to which the receipt data 16 is added and a flag value indicating whether or not to transmit the e-mail are recorded. If the item value of the electronic receipt flag is “1”, it indicates that the customer wants to send an electronic receipt, and if the item value of the electronic receipt flag is “0”, the customer Indicates that you do not want to send.

  The e-mail transmission unit 11 generates electronic receipt data 16 based on the settlement data 15 and the customer management data 12, and uses the e-mail address recorded in the customer management data 12 as a transmission destination. It has a function of transmitting an e-mail to which is added. Note that the format of the e-mail is in accordance with the rules of MIME (Multipurpose Internet Mail Extensions), and the transmission of the e-mail is performed in accordance with the rules of SMTP (Simple Mail Transfer Protocol).

  A PC terminal 4 is connected to the Internet 5 at the home of a customer who performs shopping at the store. The PC terminal 4 is a computer that includes a display device such as a display, an input device such as a keyboard and a mouse, and a network adapter that can be connected to the Internet. Each function of the e-mail receiving unit 13 and the deposit / withdrawal management unit 14 Are stored in a storage device (not shown) and executed by a user's instruction to cause the computer to realize the functions shown below.

  The e-mail receiving unit 13 has a function of receiving e-mails stored in an ISP (Internet Service Provider) mail server (not shown). The reception of this e-mail is performed in accordance with POP3 (Post Office Protocol version 3) rules.

  The deposit / withdrawal management unit 14 has a function of recording and collecting the deposit / withdrawal data 17 composed of items and amounts of income and expenses of general household account book software, as well as electronic receipt data added to the e-mail. 16 is obtained, and the expense item, item, and amount recorded in the electronic receipt data 16 are incorporated into the deposit / withdrawal data 17.

  Next, a series of processing will be described based on the sequence diagram of FIG.

  First, a customer makes some shopping at a store and pays at a cash register. At that time, the store clerk asks the customer to present a card on which the customer number is recorded, such as a point card or a membership card. read. The cash register 2 acquires the customer number read by the card reader and records it in the storage device (step S01).

  Subsequently, the store clerk and the customer perform normal checkout processing. When the clerk inputs the item, quantity, and price of the product purchased by the user and the checkout process using cash or credit card is completed (step S02), the cash register 2 stores the customer number, date, checkout time, Management of settlement data 15 consisting of product name, product item, number of purchases, amount, subtotal, foreign tax, total amount, cash register 2 cash register for which settlement processing was performed, and manager number indicating the clerk who performed the settlement processing It transmits to the server 1 (step S03). If the card in which the customer number is recorded is not presented and the customer number cannot be acquired, the cash register 2 does not transmit the settlement data 15 and performs normal settlement processing.

  When receiving the settlement data 15 from the cash register 2 (step S04), the e-mail transmission unit 11 of the management server 1 acquires the customer number from the settlement data 15 and refers to the customer management data 12 based on the customer number. Then, the item value and the electronic mail address of the electronic receipt flag of the record in which the customer number is recorded are acquired. The e-mail transmission unit 11 determines whether or not the user desires to send an electronic receipt based on the item value of the electronic receipt flag (step S05). When the item value of the receipt flag is “1”, the electronic receipt data 16 is generated, and an electronic mail with the electronic receipt data 16 added is generated and transmitted using the previously acquired electronic mail address as a destination (step S06). ).

  FIG. 4 shows an example of the electronic receipt data 16 that is generated. From the top of FIG. 4, the store name, store phone number, home page address, date of purchase, and settlement time are recorded, followed by the product name of the purchased product, the item of the product, the number of purchases, and the amount of money, separated by commas. Subsequently, the subtotal, the foreign tax, and the total amount are recorded, and the cash register 2 cash register No. in which the settlement process was performed lastly, and the person in charge No. indicating the clerk who performed the settlement process are recorded.

  The electronic receipt data 16 may be added to the electronic mail as an attached file, or may be inserted in a text format in the body of the electronic mail.

  On the other hand, at the user's home, the e-mail receiving unit 13 of the PC terminal 4 receives the e-mail stored in the ISP mail server based on the user's instruction (step S07). The figure shows an example in which the received electronic mail is displayed on the display device. In the example of FIG. 5, the electronic receipt data 16 is added to the electronic mail as an attached file “electronic receipt.dat” (part (A) in FIG. 5).

  Further, the deposit / withdrawal management unit 14 of the PC terminal 4 acquires the electronic receipt data 16 from the received e-mail based on the subject and the file name of the attached file (step S08), and the date and the purchased product from the electronic receipt data 16 Product name, product item, purchased quantity, amount, subtotal, foreign tax, and total amount are extracted and recorded in the deposit / withdrawal data 17 (step S09). FIG. 6 shows an example in which deposit / withdrawal data 17 in which the product name, the item of the product, the number of items purchased, the price, etc., extracted from the electronic receipt data 16 are recorded on the display device. In the example of FIG. 6, it can be seen that the product name such as rye salmon sand purchased on September 5, 2003 is recorded in the item of content, and the purchase amount at that time is recorded in the item of expenditure. The total amount may be the total amount acquired from the electronic receipt data, or may be calculated using a totaling function provided in the deposit / withdrawal management unit.

  Further, when the electronic receipt data 16 is inserted into the body of the e-mail, the deposit / withdrawal management unit 14 uses a specific character string, for example, “**********” shown in FIG. The electronic receipt data 16 is acquired based on a simple character string, and the product name of the product, the item of the product, the number of purchases, the price, etc. are recorded in the deposit / withdrawal data 17.

  In this way, the electronic receipt data 16 in which the details of the purchased item are recorded from the store side is attached to the e-mail and transmitted, and the electronic receipt data 16 is automatically captured by the PC terminal 4 and recorded in the deposit / withdrawal data 17. .

  If the PC terminal 4 is always connected to the Internet 5, in step S07, the e-mail receiving unit 13 periodically accesses the ISP mail server to send an e-mail having a specific subject, such as “Subject”. Only the e-mail with “: electronic receipt” may be automatically selected and received. Further, the process of acquiring the electronic receipt data 16 from the e-mail in step S08 and the process of recording the amount and the like in step S09 in the deposit / withdrawal data 17 are automatically performed so that the user is not conscious. In both cases, since the deposit / withdrawal data 17 is updated, the convenience is improved.

  In the present embodiment, a computer is shown as the PC terminal 4, but the present invention is not limited to this, and may be a mobile phone, a PDA, a telephone, or the like.

It is a block diagram of the whole system. It is a figure which shows customer management data. It is a sequence diagram which shows the flow of a series of processes. It is a figure which shows the example of electronic receipt data. It is a figure which shows the example which displayed the received electronic mail on the display apparatus. It is a figure which shows the example which displayed deposit / withdrawal data on the display apparatus.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Management server 2 Cash register 3 Network 4 PC terminal 5 Internet 11 E-mail transmission part 12 Customer management data 13 E-mail reception part 14 Deposit / withdrawal management part 15 Checkout data 16 Electronic receipt data 17 Deposit / withdrawal data

Claims (1)

A household account book program executed on a computer that manages the amount of money related to income and expenditure as deposit / withdrawal data,
Electronic receipt data in which at least the purchase date and time, the name of the purchased product, the item of the purchased product, and the price of the product are recorded by the management server that manages the settlement data input from the cash register when the product is purchased from the computer Receiving means for receiving via a communication network;
Deposit / withdrawal management means for acquiring the purchase date and time, the product name, the item, and the amount from the electronic receipt data received by the receiving means, and recording the deposit / withdrawal data;
Household account book program characterized by functioning.

Images