JP2011186860A - Sales data processing apparatus and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To automatically journalize, with a sales data processing apparatus, a transaction by account withdrawal not via a sales data processing apparatus. <P>SOLUTION: In the sales data processing apparatus 1, a storage part 14 stores a PUL setting file 141 storing a transaction item including a transaction by account withdrawal and a journalization code for identifying journalization pattern information of the transaction item in association with PUL number, and a journalization pattern information file 142 storing journalization pattern information for each transaction item and withdrawal information in a case in which the transaction item is a transaction by account withdrawal in association with the journalization code. A CPU 10 searches a record having withdrawal information with a withdrawal date before a current date from the journalization pattern information file 142, and forms, when the corresponding withdrawal information is searched, allocation journalization data in which a withdrawal amount is journalized based on the journalization pattern corresponding to the searched withdrawal information. <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention relates to a sales data processing apparatus and a program.

  2. Description of the Related Art Conventionally, sales data processing devices such as ECR (Electronic Cash Register) for registering sales of products are known. In the sales data processing apparatus, a product can be input by a simple operation using a barcode or a touch panel (see, for example, Patent Document 1).

  In addition, in retail stores and restaurants, where retail cash transactions are central, many cash transactions such as purchases, expenses, and transfers are frequently made via sales data processing devices in addition to sales. . Therefore, a sales data processing apparatus has also been proposed that can perform a journal entry of a cash transaction performed via the sales data processing apparatus with a simple operation.

JP 09-245253 A

  By the way, it is important for the store manager to accurately grasp the profit (revenue) of the store. It is necessary to calculate the profit of the store by taking into account transactions withdrawing accounts that do not pass through the sales data processing device in addition to cash transactions performed through the sales data processing device.

  However, the conventional sales data processing apparatus does not manage any transaction other than the sales data processing apparatus, and there is a problem that it is difficult for the store manager to grasp an accurate profit.

  Further, in the tax examination of the National Tax Agency, it is required that the actual cash balance (amount of money) of the sales data processing device and the book balance of the cash register are the same. However, for small businesses with a focus on cash transactions such as restaurant management, it is difficult to make entries in various books such as cash accounts after closing every day because of long working hours. is the current situation. Therefore, there is a problem that it is very difficult to perfectly match the actual balance with the balance on the book.

  It is an object of the present invention to enable a sales data processing apparatus to automatically journal a transaction based on account withdrawal without going through a sales data processing apparatus.

In order to solve the above-mentioned problem, the sales data processing device of the invention described in claim 1
A transaction information storage unit that stores a transaction item including a transaction by direct debit and a journal code for specifying the journal pattern information of the transaction item in association with an identification number;
The journal pattern information of the transaction item is stored in association with the journal code, and when the transaction item is a transaction by the account withdrawal, the journal pattern information is further converted into withdrawal information including a withdrawal date and a withdrawal amount. Journal pattern information storage unit that stores the associated information,
An accounting journal data storage unit for storing accounting journal data;
When the withdrawal date is searched from the journal pattern information storage unit and the corresponding withdrawal information is retrieved, the withdrawal date is retrieved based on the journal pattern information corresponding to the retrieved withdrawal information. A control unit that creates the accounting journal data journalizing the withdrawal amount and stores it in the accounting journal data storage unit;
Is provided.

The invention according to claim 2 is the invention according to claim 1,
The transaction by the account withdrawal includes a transaction withdrawn from the account at a fixed amount every month.

The invention according to claim 3 is the invention according to claim 1 or 2,
Transactions withdrawn from the account include transactions withdrawn from the account on a designated date due to monthly billing.

The invention according to claim 4 is the invention according to any one of claims 1 to 3,
An input unit is provided for changing the withdrawal date and the withdrawal amount stored in the journal pattern information storage unit.

The invention according to claim 5 is the invention according to any one of claims 1 to 4,
With an output section,
After creating the booked journal data, the control unit creates an account withdrawal journal slip indicating the contents of the created booked journal data and causes the output unit to output it.

The invention according to claim 6 is the invention according to any one of claims 1 to 5,
The input unit can input an identification number of a transaction item to be journalized, a transaction amount, and a transaction classification,
When the identification number and transaction classification of the transaction item to be journalized are input by the input unit, the control unit acquires a journal code corresponding to the input identification number from the transaction information storage unit, The journal pattern information associated with the journal code is read from the journal pattern information storage unit, and the input transaction amount is journaled based on the transaction classification input by the input unit and the read journal pattern information. The recorded journal data is created and stored in the recorded journal data storage unit, and at the time of settlement, the recorded journal data including the transaction by the account withdrawal, stored in the recorded journal data storage unit, Calculate the accumulated profit for the current month and output it by the output unit.

The invention according to claim 7 is the invention according to any one of claims 1 to 6,
The input unit is configured to be able to input the amount of money stored in the sales data processing device,
The control unit determines whether there is an excess or deficiency in the amount of money input by the input unit and the value indicating the cash balance calculated based on the recorded journal data created today at the time of settlement. When there is an excess or deficiency, the accounting journal data in which the excess or deficiency amount is recorded as a cash excess or deficiency item is created and stored in the accounting journal data storage unit.

The program of the invention described in claim 8 is:
A computer used in a sales data processing device
A transaction information storage unit for storing a transaction item including a transaction by direct debit and a journal code for specifying the journal pattern information of the transaction item in association with an identification number;
The journal pattern information of the transaction item is stored in association with the journal code, and when the transaction item is a transaction by the account withdrawal, the journal pattern information is further converted into withdrawal information including a withdrawal date and a withdrawal amount. Journal pattern information storage unit for storing in association with each other,
Account journal data storage unit for storing account journal data,
When the withdrawal date is searched from the journal pattern information storage unit and the corresponding withdrawal information is retrieved, the withdrawal date is retrieved based on the journal pattern information corresponding to the retrieved withdrawal information. A control unit that creates the accounting journal data journalizing the withdrawal amount and stores it in the accounting journal data storage unit,
To function as.

  According to the present invention, a transaction by direct debit without going through a sales data processing device can be automatically journalized by the sales data processing device.

It is a figure which shows the example of whole structure of the sales data processing system in embodiment of this invention. It is a block diagram which shows the functional structure of the sales data processing apparatus of FIG. It is a figure which shows an example of the input part of FIG. FIG. 3 is a diagram illustrating a data storage example of the PLU setting file of FIG. 2. It is a figure which shows the example of data storage of the journal pattern information file of FIG. It is a figure which shows the example of data storage of the accounting journal data file of FIG. It is a block diagram which shows the functional structure of the server apparatus of FIG. It is a figure which shows the example of data storage of the authentication setting file of FIG. It is a flowchart which shows the process at the time of downloading the journal pattern information file from a server apparatus in the sales data processing apparatus of FIG. It is a flowchart which shows the journalizing process performed in CPU of FIG. It is a flowchart which shows the withdrawal journalizing process performed in CPU of FIG. It is a figure which shows an example of the receipt output by the operation procedure of an operator until the withdrawal journal entry process of FIG. 11 is complete | finished, and a withdrawal journal entry process. It is a flowchart which shows the deposit journal process performed in CPU of FIG. It is a figure which shows an example of the receipt output by the operation procedure of an operator until the payment journal entry process of FIG. 13 is complete | finished, and a payment journal entry process. It is a flowchart which shows the sales management process performed in CPU of FIG. It is a flowchart which shows the sales journal process (pattern 2) performed in CPU of FIG. It is a figure which shows an example of the receipt output by the operation procedure of an operator until the sales journal process (pattern 2) of FIG. 16 is complete | finished, and a sales journal process (pattern 2). It is a flowchart which shows the sales journal process (pattern 3) performed in CPU of FIG. It is a figure which shows an example of the receipt output by the operation procedure of an operator until the sales journal process (pattern 3) of FIG. 18 is complete | finished, and a sales journal process (pattern 3). It is a flowchart which shows the sales journal process (pattern 1) performed in CPU of FIG. It is a figure which shows an example of the receipt output by the operation procedure of an operator until the sales journal process (pattern 1) of FIG. 20 is complete | finished, and a sales journal process (pattern 1). It is a flowchart which shows the sales journal process (pattern 4) performed in CPU of FIG. It is a figure which shows an example of the receipt output by the operation procedure of an operator until the sales journal process (pattern 4) of FIG. 22 is complete | finished, and a sales journal process (pattern 4). It is a flowchart which shows the adjustment process performed in CPU of FIG. It is a figure which shows an example of the account withdrawal automatic journal entry (for fixed amount withdrawal) issued by the adjustment process of FIG. FIG. 25 is a diagram illustrating an example of an account withdrawal automatic journal entry (for withdrawal by billing) issued in the settlement process of FIG. 24. It is a flowchart which shows the total process at the time of the adjustment performed in CPU of FIG. It is a figure which shows an example of the total file memorize | stored in the memory | storage part of FIG. It is a figure which shows an example of the journal overwriting of the cash excess and deficiency issued by the adjustment process of FIG. It is a figure which shows an example of today's business report issued by the adjustment process of FIG. It is a flowchart which shows the process at the time of uploading accounting journal data to a server apparatus in the sales data processing apparatus of FIG.

  Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings. The present invention is not limited to the illustrated example.

(Configuration of sales data processing system 100)
FIG. 1 is a diagram showing an overall configuration of a sales data processing system 100 according to the present embodiment. As shown in FIG. 1, the sales data processing system 100 is configured by connecting a sales data processing device 1 and a server device 2 via a communication network N so that data can be transmitted and received. The communication network N is an information communication network constructed using a dedicated line, an existing public line, the Internet, or the like. The number of sales data processing apparatuses 1 is not particularly limited. In this embodiment, the sales data processing apparatus includes an ECR (Electronic Cash Register) and the like.

(Configuration of sales data processing apparatus 1)
The sales data processing apparatus 1 is provided in a store, and performs registration processing, journalizing processing, checkout processing, and the like of merchandise purchased based on an operator's operation.

  FIG. 2 is a block diagram showing a functional configuration of the sales data processing apparatus 1. As shown in FIG. 2, the sales data processing apparatus 1 includes a CPU (Central Processing Unit) 10, an input unit 11, a display unit 12, a RAM (Random Access Memory) 13, a storage unit 14, a communication unit 15, a printing unit 16, A drawer 17, a time measuring unit 18, and the like are provided, and each unit is connected via a bus 19.

  The CPU 10 serving as a control unit reads a system program stored in the storage unit 14, develops it in the work area of the RAM 13, and controls each unit according to the system program. Further, the CPU 10 reads out the processing program 145 stored in the storage unit 14 and develops it in the work area, and executes various processes including a journalizing process and a settlement process described later.

  As shown in FIG. 3, the input unit 11 includes a numeric keypad 111, a department key 112, a flat PLU key 113, a deposit key 114, a withdrawal key 115, a credit key 116, a ticket key 117, a cash deposit key 118, a subtotal key 119, A registration confirmation key 120, a money amount key 121, a multiplication key 122, a connection key 123, a cash balance declaration key 125, a customer number key 126, a temporary closing key 127, a slip number key 128 and the like are provided.

The flat PLU key 113 is composed of a plurality of keys associated with PLU numbers. The PLU number is an identification number assigned to identify a product or transaction item (cash sales, credit, gift certificate sales, etc.). Each flat PLU key 113 displays the name of a product or the name of a transaction item corresponding to the PLU number, as shown in FIG. For example, since the PLU number 145 is a number for identifying the transaction item “cash sales”, the characters “cash sales” are displayed on the flat PLU key 113 corresponding to the PLU number 145. When one of the flat PLU keys 113 is pressed, the PLU number corresponding to the flat PLU key 113 is input. In FIG. 3, PLU numbers 001 to 099 are expressed as 1 to 99 in the flat PLU key 113.
A deposit key 114, a withdrawal key 115, a credit key 116, a ticket key 117, and a cash deposit key 118 are keys for inputting a transaction classification (withdrawal, deposit, credit, gift certificate, cash).
The subtotal key 119 is a key for inputting an instruction for calculating the total of the registered sales amounts after the registration of the product is completed. The registration confirmation key 120 is a key for inputting an instruction to shift to the next process.
The amount key 121 is a key for inputting that the numerical value input with the numeric keypad 111 is an amount.
The multiplication key 122 is a key for inputting a quantity.
The connection key 123 is a key for inputting a connection instruction to the server device 2.
The cash amount declaration key 125 is a key for instructing execution of the cash balance processing. Declaring the balance is to register the total amount of money in the drawer 17 in the sales data processing apparatus 1 as an account.
The customer number key 126 is a key for inputting that the numerical value input with the numeric keypad 111 is the number of customers.
The temporary closing key 127 is a key for inputting an instruction to temporarily close the transaction.
The slip number key 128 is a key for inputting that the numerical value input by the ten key 111 is a slip number.

  The input unit 11 also includes a mode switch 124. The mode switch 124 is a switch for switching the operation mode of the sales data processing apparatus 1 to any one of a registration mode, an inspection mode, a checkout mode, a setting mode, an OFF mode, and a return mode. The registration mode is a mode for registering sales data of purchased commodities. The return mode is a mode for performing return processing. The payment mode is a mode in which the daily sales data is settled after the store is closed.

  Furthermore, the input unit 11 includes a barcode reader, a barcode scanner, or the like that reads a barcode provided on a product.

  The display unit 12 includes an LCD (Liquid Crystal Display), an organic EL (Electro-Luminescence) display, or the like. Various screens are displayed on the display unit 12 in accordance with instructions of display signals input from the CPU 10.

  The RAM 13 has a work area for temporarily storing system programs and processing programs 145 read from the storage unit 14 by the CPU 10, input data, output data, parameters, and the like.

The storage unit 14 is configured by a semiconductor nonvolatile memory or the like. The storage unit 14 stores a system program executed by the CPU 10, a processing program 145, data necessary for executing these programs, and the like. The processing program 145 is used to execute various processes including a journalizing process (see FIG. 10), a download process (see FIG. 9), a settlement process (see FIG. 23), and an upload process (see FIG. 30), which will be described later. A program is included.
These programs are stored in the storage unit 14 in the form of computer-readable program codes. The CPU 10 sequentially executes operations according to the program code.

  The storage unit 14 includes a PLU setting file 141 (transaction information storage unit), a journal pattern information file 142 (journal pattern information storage unit), a recorded journal data file 143 (recorded journal data storage unit), and a slip sequential number storage file 144. Is remembered. In other words, the storage unit 14 functions as a transaction information storage unit, a journal pattern information storage unit, and a recorded journal data storage unit.

FIG. 4 is a diagram illustrating an example of data storage in the PLU setting file 141. As shown in FIG. 4, the PLU setting file 141 includes “PLU number”, “name” (product name or transaction item name), “journal code”, “unit price”, “taxing method”, “product number PLU”, and the like. Items are provided. That is, in the PLU setting file 141, in association with the “PLU number”, setting information relating to the product identified by the PLU number, or journal code for specifying the journal pattern information of the transaction item identified by the PLU number, etc. Is stored. That is, the PLU number is an identification number assigned to identify a product or a transaction item. The transaction item includes a transaction through the sales data processing apparatus 1 and a transaction by account withdrawal.
In the present embodiment, in the PLU setting file 141, setting information relating to the product identified by the PLU number (identification number), journalizing code specifying the journal pattern information relating to the transaction item identified by the PLU number (identification number), and the like The feature is that is stored.

In FIG. 4, each of PLU numbers 001 to 144 stores setting information related to the product identified by the PLU number in association with each other. For example, setting information (“unit price”, “taxing method”, “department link”, etc.) for “menu A” is stored in association with PLU number 001. In addition, each of the PLU numbers 145 and later stores journal codes for specifying the journal pattern information of the transaction item identified by the PLU number. For example, in the PLU number 145, “journal code” for specifying the journal pattern information of “cash sales” is stored in association with each other. In addition, in the PLU number 209, “journal code” for specifying the journal pattern information of “karaoke lease fee” withdrawn from the deposit account every month is stored in association with each other.
In this embodiment, since it is assumed that the sales data processing device 1 is installed in a restaurant, coffee shop, or other restaurant store, the menus A to J stored in the “name” of the PLU setting file 141 are It represents the name of a dish or drink in a restaurant.

The data structure of the PLU setting file 141 is an extended data structure in which an item “Journal code” is added to the conventional PLU setting file. With this data structure, the journal code for specifying the journal pattern information corresponding to the transaction item specified by the input of the PLU number is acquired, and the journal pattern information of the specified transaction item is acquired from the journal pattern information file 142. It is possible to do.
“Product No. PLU” stores “Yes” indicating that it is a product No. PLU or “No” indicating that it is not a product No. PLU. The product number PLU indicates that the unit price is input directly from the keyboard instead of referring to the “unit price” in the PLU setting file 141 when inputting the unit price.

FIG. 5 is a diagram illustrating a data storage example of the journal pattern information file 142. The journal pattern information file 142 is a file that stores journal pattern information for each transaction item.
When a transaction is carried out, it is necessary to create journal entry data shown in FIG. 6 for the transaction by performing a journal process. Among the items of the accounting journal data, there are items uniquely determined for each transaction item. For example, the contents of journal items such as debit item name, credit item name, tax classification, and consumption tax are uniquely determined. Therefore, in the journal pattern information file 142, journal items uniquely determined for each transaction item are stored as journal pattern information.

As shown in FIG. 5, the journal pattern information file 142 includes “journal code”, “transaction item name”, “journal category”, “slip category”,... “Debit item code”, “debit item name”. , "Debit sub item", "Debit tax category", "Credit item code", "Credit item name", "Credit sub item", "Credit tax category", "Description", "Consumption tax" Is provided. That is, the journal pattern information file 142 stores the journal pattern information of each transaction item in association with the “journal code” for specifying the journal pattern information.
The journal pattern information file 142 further includes withdrawal information items such as “current month draft”, “withdrawal category”, “processing date”, “tax included amount”, and “consumption tax”. Here, “Journal classification” = “5: Checkout” indicates that the transaction item of the record is a transaction by direct debit (a transaction that requires journal entry at the time of checkout). In association with the pattern information, withdrawal information such as “current month draft”, “withdrawal category”, “processing date”, “tax included amount”, “consumption tax”, and the like is stored. “Withdrawal category” is a category that indicates whether or not it is a straight-line withdrawal, “Processing date” is the date that indicates the withdrawal date (designated date), and “Tax included amount” is the withdrawal amount (tax included amount) The “consumption tax” indicates the consumption tax of the withdrawal amount. Transactions by direct debit include transactions that are debited from a deposit account at a fixed date on a specified date every month, transactions that are deducted from a deposit account on a specified date by monthly billing, and the like.
The journal items included in the journal pattern information are determined by the journal items used in the accounting process or the like in the server device 2 as an accounting system.

  FIG. 6 is a diagram illustrating a data storage example of the booked journal data file 143. The book journal data file 143 is a file in which book journal data created by journal processing described later is stored. As shown in FIG. 6, the recorded journal data file 143 includes “ECR code”, “slip serial number”, “slip date”, “slip time”, “slip number”, “journal category”, “withdrawal category”. , "Debit item code", "Debit item name", "Debit sub item", "Debit tax category", "Debit tax included amount", "Debit consumption tax", "Credit item code", "Credit item name", " "Credit Auxiliary Item", "Credit Tax Classification", "Credit Tax Amount", "Credit Consumption Tax", "Description", "Consumption Tax Existence", "Register Personnel", "Number of Visitors", "Purchase Points", etc. An item is provided, and recording journal data for one transaction is stored as one record. The ECR code is an identification code for identifying the individual sales data processing apparatus 1.

  The slip sequential number storage file 144 is a file in which an ECR code, slip sequential number, and slip number are stored.

  In addition, the storage unit 14 stores a balance sheet file 146 and a total file 147. The cash amount file 146 is a file for storing the cash amount calculated in the cash amount reporting process described later. The aggregation file 147 is a file used for aggregating the accounting journal data by the aggregation items of sales, purchase, expense, and transfer in the aggregation process at the time of settlement described later (see FIG. 27).

  Further, the storage unit 14 stores authentication data (ECR code and opening password) for communication connection with the server device 2.

  The communication unit 15 includes a modem, a router, a network card, and the like. The communication unit 15 performs data transmission / reception with an external device such as the server device 2 connected via the communication network N.

  The printing unit 16 as an output unit is, for example, a thermal printer (thermal printer), and has receipt and journal roll papers (thermal paper). According to an instruction signal input from the CPU 10, Print out the amount and sales data.

  The drawer 17 is a drawer that stores cash such as coins and banknotes. The drawer 17 is opened by the instruction of the CPU 10.

  The timer unit 18 incorporates a timer circuit such as an RTC (Real Time Clock), and measures the current time and the current date and outputs them to the CPU 10.

(Configuration of server device 2)
The server device 2 receives the recorded journal data from the sales data processing device 1, and performs accounting processing, management analysis, and the like based on the received recorded journal data.
FIG. 7 is a block diagram illustrating a functional configuration of the server device 2. As shown in FIG. 7, the server device 2 includes a CPU 20, an input unit 21, a display unit 22, a RAM 23, a storage unit 24, a communication unit 25, and the like, and each unit is connected via a bus 26. Hereinafter, a characteristic configuration of the server device 2 will be described.

The storage unit 24 is configured by an HDD (Hard Disc Drive) or the like. The storage unit 24 stores a system program executed by the CPU 20, a processing program 244, data necessary for executing these programs, and the like. The processing program 244 includes a program for executing various processes including a server apparatus side process (see FIG. 9) for a download process, which will be described later, and a server apparatus side process (see FIG. 30) for an upload process.
These programs are stored in the storage unit 24 in the form of computer-readable program codes. The CPU 20 sequentially executes operations according to the program code.

  In addition, the storage unit 24 stores an authentication setting file 241, a journal pattern information master DB (Data Base) 242, and a book journal DB 243.

  FIG. 8 is a diagram illustrating a data storage example of the authentication setting file 241. As shown in FIG. 8, the authentication setting file 241 includes items such as “ECR code” and “opening password”, and stores authentication data for performing terminal authentication of the sales data processing apparatus 1. .

  The journal pattern information master DB 242 stores master data of the journal pattern information file 142 of the sales data processing apparatus 1.

  The accounting journal DB 243 stores the accounting journal data transmitted from the sales data processing apparatus 1.

(Operation of Sales Data Processing System 100)
Next, the operation of the sales data processing system 100 will be described.
First, the process of downloading the journal pattern information file 142 from the server apparatus 2 in the sales data processing apparatus 1 will be described.

  FIG. 9 is a flowchart showing processing when the journal data pattern file 142 is downloaded from the server device 2 in the sales data processing device 1. The process shown in FIG. 9 is started when the sales data processing apparatus 1 is activated or when the connection key 123 is pressed. The processing on the sales data processing device 1 side is executed in cooperation with the CPU 10 of the sales data processing device 1 and the processing program 145 stored in the storage unit 14. The processing on the server device 2 side is executed in cooperation with the CPU 20 of the server device 2 and the processing program 244 stored in the storage unit 24.

  First, in the sales data processing device 1, a communication connection request to the server device 2 is made by the communication unit 15 (step T1). In the server device 2, a communication connection request from the sales data processing device 1 is received by the communication unit 25 (step T2).

  Next, in the sales data processing device 1, the authentication data stored in the storage unit 14 is read (step T3), and the read authentication data is transmitted to the server device 2 by the communication unit 15 (step S3). T4).

  In the server device 2, when authentication data is received by the communication unit 25 (step T5), the received authentication data is collated with the authentication data stored in the authentication setting file 241 (step S5). T6). Then, authentication response data is created based on the collation result (step T7). As a result of the collation, if there is a record in the authentication setting file 241 in which the received authentication data matches the ECR code and the opening password, authentication response data indicating that communication connection is possible is created. If there is no record in the authentication setting file 241 that matches the received authentication data with the ECR code and the opening password, authentication response data indicating that communication connection is impossible is created. The created authentication response data is transmitted to the sales data processing device 1 of the connection request source by the communication unit 25 (step T8). The received authentication data, verification result, created authentication response data, and the like are held in the RAM 23.

  In the sales data processing device 1, when the authentication response data is received by the communication unit 15 (step T9), it is determined whether or not communication connection with the server device 2 is possible based on the received authentication response data. Is done. If it is determined that communication connection with the server device 2 is impossible (step T10; connection is impossible), error processing is performed (step T18), and communication with the server device 2 is disconnected by the communication unit 15 (step T18). T19), the download processing on the sales data processing apparatus 1 side ends. On the other hand, when it is determined that communication connection with the server device 2 is possible (step T10; connection is possible), a transmission request for the journal pattern information file 142 is transmitted to the server device 2 by the communication unit 15 (step T11). .

  In the server device 2, when it is determined that the communication connection of the sales data processing device 1 is possible as a result of the collation in step T 6 (step T 12; connectable), the journal pattern information file 142 from the sales data processing device 1. Is received by the communication unit 25 (step T13). When the transmission request for the journal pattern information file 142 is accepted, the journal pattern information file 142 corresponding to the sales data processing apparatus 1 as the transmission source is read from the journal pattern information master DB 242 based on the authentication data received in step T5. (Step T14). The read journal pattern information file 142 is transmitted to the sales data processing device 1 by the communication unit 25 (step T15), and the processing on the server device 2 side proceeds to step T20.

  As a result of the collation in step T6, when it is determined that the communication connection of the sales data processing device 1 is impossible (step T12; connection is impossible), the processing on the server device 2 side proceeds to step T20.

  In step T20, communication with the sales data processing apparatus 1 is disconnected by the communication unit 25 (step T20). And the information hold | maintained at RAM23 is deleted (step T21), and the process by the server apparatus 2 side is complete | finished.

  In the sales data processing device 1, when the journal pattern information file 142 is received from the server device 2 by the communication unit 15 (step T16), the received journal pattern information file 142 is stored in the storage unit 14 (step S16). T17). Then, communication with the server device 2 is disconnected by the communication unit 15 (step T19), and the download processing on the sales data processing device 1 side ends.

  The journal pattern information file 142 is downloaded to the sales data processing apparatus 1 and stored in the storage unit 14 by the processing of FIG.

Next, the operation of the sales data processing apparatus 1 will be described.
FIG. 10 is a flowchart showing the journalizing process executed in the sales data processing apparatus 1. The journalizing process is executed in cooperation with the CPU 10 and the processing program 145 stored in the storage unit 14 when the mode switch 124 is set to the registration mode or the return mode.

  First, it is determined whether or not the mode switch 124 is set to the registration mode (step S1). If it is determined that the mode switch 124 is set to the registration mode (step S1; YES), it is determined whether or not a numerical value has been input by pressing the numeric key 111 (step S2). If it is determined that a numeric value has been input by pressing the numeric keypad 111 (step S2; YES), the input numeric value is displayed on the display unit 12 (step S3), and the process proceeds to step S4. If it is determined that the numeric key 111 has not been pressed and no numerical value has been input (step S2; NO), the process proceeds to step S4.

In step S4, it is determined whether a PLU number is input from the input unit 11 (step S4). If it is determined that no PLU number is input from the input unit 11 (step S4; NO), the process proceeds to step S12. If it is determined that the PLU number is input from the input unit 11 (step S4; YES), the PLU setting file 141 is referred to, and the “name” corresponding to the input PLU number is displayed on the display unit 12. When the unit price is associated with the PLU number, the product score (quantity) and the total amount are added and displayed on the display unit 12 (step S5).
The PLU number can be input by designating the PLU number with the flat PLU key 113, inputting the PLU number with the numeric keypad 111, reading the barcode displayed on the product with a barcode scanner, or the like. When registering a purchased product, a PLU number corresponding to the product is input. When making a change in a withdrawal or deposit journal or an account withdrawal transaction amount, the PLU number corresponding to the journal entry or transaction item to be changed is input.

  Next, the PLU setting file 141 is referred to and it is determined whether or not the input PLU number is a product number PLU (step S6). That is, it is determined whether or not “product number PLU” corresponding to the input PLU number is “yes” in the PLU setting file 141. When it is determined that the input PLU number is the product number PLU (step S6; YES), the input of the amount by pressing the numeric key 111 and the amount key 121 is waited. When the amount is input, the input amount is changed. It is displayed on the display unit 12 (step S7). Then, the process proceeds to step S8. If it is determined that it is not a product number PLU (step S6; NO), the process proceeds to step S8.

  In step S8, it is determined whether or not the withdrawal key 115 is pressed. If it is determined that the withdrawal key 115 is pressed (step S8; YES), the withdrawal journaling process is executed (step S9). .

  FIG. 11 is a flowchart showing the withdrawal journal processing executed in step S9 of FIG. The withdrawal journal process is executed in cooperation with the CPU 10 and the processing program 145 stored in the storage unit 14. In the withdrawal journal process, in addition to the withdrawal journal, it is possible to change the “processing date” and “tax included amount” of the record “journal classification” = “5: settlement” in the journal pattern information file 142. .

  First, the pressing of the registration confirmation key 120 is waited (step S101). When the registration confirmation key 120 is pressed (step S101; YES), the PLU setting file 141 is referred to, and the “journal code” corresponding to the PLU number input in step S4 of FIG. 10 is acquired (step S102). .

  Next, a record in which the acquired journal code matches the “journal code” is retrieved from the journal pattern information file 142, and the retrieved record is read into the RAM 13 (step S103).

  Next, the content of “consumption tax presence / absence” in the record read in step S103 is checked (step S104). When the content of the “consumption tax presence / absence” of the read record includes the consumption tax (step S104; present), the amount input in step S7 of FIG. 10 and the “debit tax classification” of the read record ”And“ credit tax classification ”, the consumption tax of each of the debit and the credit is calculated (step S105). Then, the process proceeds to step S106. On the other hand, when the content of “consumption tax presence / absence” in the record read in step S103 is no consumption tax (step S104; no), the process proceeds to step S106.

  In step S106, it is determined whether or not “journal category” = “5: settlement” of the record read in step S103 (step S106). When it is determined that “journal classification” = “5: settlement” is not satisfied (step S106; NO), the steps of FIG. 10 are added to the items of “debit tax included amount” and “credit tax included amount” of the record read to the RAM 13. The amount entered in S7 is substituted. Further, the calculated consumption tax is assigned to the items of “debit consumption tax” and “credit consumption tax” (step S107).

  Next, the ECR code, the slip serial number, and the slip number are acquired from the slip sequence number storage file 144 and stored in the RAM 13 (step S108). Further, the current date and time are acquired from the time measuring unit 18 and stored in the RAM 13 (step S109). Then, a new record is added to the booked journal data file 143, and booked journal data is created based on the journal pattern information record read to the RAM 13 (step S110). Specifically, each record data item added to the recorded journal data file 143 corresponds to the journal pattern information record read in step S103 (including the amount substituted in step S107 and the consumption tax). The item data and the data acquired in steps S108 to S109 are written and stored.

  When the writing of data to the booked journal data file 143 is completed, a receipt is printed by the printing unit 16 based on the record (recorded journal data) added to the booked journal data file 143 (step S111). Then, the slip serial number and the slip number in the slip serial number storage file 144 are incremented by 1 (step S112), and the withdrawal journalizing process is completed.

  On the other hand, if it is determined in step S106 that the “journal classification” of the record read out in step S103 is “5: settlement” (step S106; YES), the “journal code”, “transaction item” of the record is determined. ”And“ processing date ”are displayed on the display unit 12, and correction input (change) of the processing date by key operation of the input unit 11 is accepted (step S113). After the correction date of the processing date is input by the input unit 11, the cash deposit key 118 is waited to be pressed, and when the cash deposit key 118 is pressed (step S 114; YES), the “transaction item” of the record, the corrected processing date Then, the withdrawal amount and the calculated consumption tax are displayed on the display unit 12 (step S115). Here, the corrected withdrawal amount is the amount input in step S7 of FIG. The calculated consumption tax is the consumption tax calculated in step S105.

  Next, when the cash deposit key 118 is pressed down and the cash deposit key 118 is pressed (step S116; YES), the “process date” of the record read out in step S103 of the journal pattern information file 142 is set. The corrected processing date inputted in S113 is substituted (rewritten), the corrected withdrawal amount is substituted for “tax included amount”, and the consumption tax calculated in step S105 is substituted for “consumption tax” ( Step S117), the withdrawal journalizing process is completed.

  FIG. 12 is a diagram showing an example of an operation procedure of the operator and a receipt output by the withdrawal journal processing until the withdrawal journal processing is completed. FIG. 12 shows the operation procedure and receipt of the operator when the noodles are purchased from OO food and the price of 31500 yen is withdrawn from the sales data processing apparatus 1 by cash payment. As shown in FIG. 12, the operator first presses the flat PLU key 113 corresponding to the transaction item to be journalized (purchase (noodle / xxx food)) and inputs the PLU number 150 (step in FIG. 10). S4). Next, a withdrawal amount of 31,500 yen is input and the amount key 121 is pressed (step S7 in FIG. 10). Next, the withdrawal key 115 is pressed to input the transaction category “withdrawal” (step S8 in FIG. 10). Then, the registration confirmation key 120 is pressed (step S101 in FIG. 11). Then, the processing from step S102 onward in FIG. 11 is executed, the withdrawal journal is automatically performed, and the receipt shown in FIG. 12 is issued (step S111 in FIG. 11).

  As described above, in the sales data processing apparatus 1, in addition to the operations similar to the conventional general product registration, that is, the operator inputs the PLU number, the transaction amount, and the transaction classification, the registration is performed. By simply depressing the confirmation key 120, the withdrawal journal processing for the withdrawal transaction performed in the sales data processing apparatus 1 is automatically executed.

In addition, for example, when an invoice for debiting the gas fee for the last month from XX gas (withdrawal date 15th, amount of 10500 yen), the operator responds to the invoice by performing the following operations. The “processing date” and “tax-included amount” for the XX gas charge withdrawal transaction in the journal pattern information file 142 can be changed.
First, the flat PLU key 113 corresponding to the transaction item (xx gas charge) is pressed to input the PLU number 268 (step S4 in FIG. 10). Next, the requested amount of 10500 yen is input and the amount key 121 is pressed (step S7 in FIG. 10). Next, the withdrawal key 115 is pressed (step S8 in FIG. 10). Then, the registration confirmation key 120 is pressed (step S101 in FIG. 11). Further, since the withdrawal date is 15th, 15 is input (step S113 in FIG. 11), the cash deposit key 118 is pressed (step S114 in FIG. 11), and the display on the display unit 12 is confirmed to confirm the cash deposit key. 118 is pressed (step S116 in FIG. 11). Then, the “processing date” of the record “transaction item” = “XX gas fee” in the journal pattern information file 142 can be changed to 15, “tax included amount” to 10500, and “consumption tax” to 500. .
The journal pattern information of transaction items withdrawn at a fixed amount every month can be corrected by the same procedure as described above.

  Returning to FIG. 10, if it is determined in step S8 that the withdrawal key 115 is not pressed (step S8; NO), and if it is determined that the deposit key 114 is pressed (step S10; YES), the deposit journaling process is executed. (Step S11).

  FIG. 13 is a flowchart showing the deposit journalizing process executed in step S11 of FIG. The deposit journalizing process is executed in cooperation with the CPU 10 and the processing program 145 stored in the storage unit 14.

  First, when the registration confirmation key 120 is pressed and the registration confirmation key 120 is pressed (step S201; YES), the PLU setting file 141 is referred to and corresponds to the PLU number input in step S4 of FIG. “Journal code” is acquired (step S202).

  Next, a record in which the acquired journal code matches the “journal code” is retrieved from the journal pattern information file 142, and the retrieved record is read into the RAM 13 (step S203).

  Next, it is determined whether or not the “journal classification” of the record read in step S203 is purchase or expense, and if it is determined that it is purchase or expense (step S204; YES), reverse journal processing Is performed (step S205). Specifically, items related to debit (debit item code, debit item name, debit sub item, debit tax classification) and credit-related items (credit item code, credit item name, credit) in the record read out in step S203. The data of sub-accounts and credit tax classifications is exchanged. Then, the process proceeds to step S206. On the other hand, if it is determined that the “slip classification” of the read record is not purchase or expense (step S204; NO), the process proceeds to step S206.

  In step S206, the content of “consumption tax presence / absence” in the record read in step S203 is checked (step S206). When the content of “consumption tax presence / absence” of the read record has a consumption tax (step S206; yes), the amount input in step S7 of FIG. 10 and the “debit tax classification” of the read record ”And“ credit tax classification ”, the consumption tax of each of the debit and the credit is calculated (step S207). Then, the process proceeds to step S208. On the other hand, when the content of “consumption tax presence / absence” in the record read in step S203 is no consumption tax (step S206; no), the process proceeds to step S208.

  In step S208, the amount input in step S7 in FIG. 10 is substituted into the items of “debit tax included amount” and “credit included amount” in the record read to the RAM 13. Further, the calculated consumption tax is assigned to the items of “debit consumption tax” and “credit consumption tax”, respectively (step S208).

  Next, the ECR code, the slip serial number, and the slip number are acquired from the slip sequence number storage file 144 and stored in the RAM 13 (step S209). Further, the current date and time are acquired from the time measuring unit 18 and stored in the RAM 13 (step S210). Then, a new record is added to the accounting journal data file 143, and accounting journal data is created based on the journal pattern information record read to the RAM 13 (step S211). Specifically, each record data item added to the recorded journal data file 143 corresponds to the journal pattern information record read in step S203 (including the amount substituted in step S208 and the consumption tax). The item data and the data acquired in steps S209 to S210 are written and stored.

  When the writing of data to the booked journal data file 143 is completed, a receipt is printed by the printing unit 16 based on the record (recorded journal data) added to the booked journal data file 143 (step S212). Then, the slip serial number and the slip number in the slip serial number storage file 144 are incremented by 1 (step S213), and the deposit journalizing process is completed.

  FIG. 14 is a diagram showing an example of an operator's operation procedure up to the end of the deposit journal processing and a receipt output by the deposit journal processing. FIG. 14 shows an operator's operation procedure and receipt when depositing cash 100,000 yen that has been withdrawn from the bank XX into the cash register. As shown in FIG. 14, the operator first presses the flat PLU key 113 corresponding to the transaction item to be journalized (cash deposit XX bank) and presses the PLU number 157 (step S4 in FIG. 10). Next, a deposit amount of 100,000 yen is input and the amount key 121 is pressed (step S7 in FIG. 10). Next, the deposit key is pressed to input the transaction category “deposit” (step S10 in FIG. 10). Then, the registration confirmation key 120 is pressed (step S201 in FIG. 13). If it does so, the process after step S202 of FIG. 13 will be performed, the journalizing of payment will be performed automatically, and the receipt shown in FIG. 14 will be issued (step S212 of FIG. 13).

  As described above, in the sales data processing apparatus 1, in addition to the operations similar to the conventional general product registration, that is, the operator inputs the PLU number, the transaction amount, and the transaction classification, the registration is performed. Just by depressing the confirmation key 120, the payment journal processing for the payment transaction performed in the sales data processing apparatus 1 is automatically executed.

  Returning to FIG. 10, if it is determined in step S10 that the deposit key 114 has not been pressed (step S10; NO), it is determined whether or not the slip number key 128 has been pressed (step S12). If it is determined that the slip number key 128 is pressed (step S12; YES), sales management processing is executed (step S13).

  FIG. 15 is a flowchart showing the sales management process executed in step S13 of FIG. The sales management process is executed in cooperation with the CPU 10 and the processing program 145 stored in the storage unit 14.

  First, the numerical value input in step S2 of FIG. 10 is registered in the RAM 13 as a slip number (step S701). The slip number here is a number for identifying a table, for example, a table number of a restaurant, and is different from the slip number of the recorded journal data.

  Next, it is determined whether or not a numerical value has been input by pressing the numeric key 111 (step S702). If it is determined that a numerical value has been input by pressing the numeric key 111 (step S702; YES), the input numerical value is displayed on the display unit 12 (step S703), and the process proceeds to step S704. If it is determined that the numeric key 111 has not been pressed and no numerical value has been input (step S702; NO), the process proceeds to step S704.

  In step S704, it is determined whether a PLU number is input from the input unit 11 (step S704). If it is determined that the PLU number is not input from the input unit 11 (step S704; NO), the process proceeds to step S708. If it is determined that the PLU number has been input from the input unit 11 (step S704; YES), the PLU setting file 141 is referred to and the “name” corresponding to the input PLU number is displayed on the display unit 12. If the unit price is associated with the PLU number, the product score (quantity) and the total amount are added and displayed on the display unit 12 (step S705).

  Next, the PLU setting file 141 is referred to, and it is determined whether or not the input PLU number is a product number PLU (step S706). That is, it is determined whether or not “product number PLU” corresponding to the input PLU number is “yes” in the PLU setting file 141. When it is determined that the input PLU number is the product number PLU (step S706; YES), the input of the amount by pressing the numeric key 111 and the amount key 121 is waited. When the amount is input, the input amount is changed. It is displayed on the display unit 12 (step S707). Then, the process proceeds to step S708. If it is determined that the input PLU number is not a product number PLU (step S706; NO), the process proceeds to step S708.

  In step S708, it is determined whether or not the customer number key 126 has been pressed (step S708). If it is determined that the number-of-customers key 126 has been pressed (step S708; YES), the numerical value input data input in step S703 is registered in the RAM 13 as the number of visitors, and “number of customers” + is input to the display unit 12. "Numeric value" is displayed (step S709), and the process proceeds to step S710. If it is determined that the number of customers key 126 has not been pressed (step S708; NO), the process proceeds to step S710.

  In step S710, it is determined whether or not the temporary fastening key 127 has been pressed (step S710). If it is determined that the temporary closing key 127 has not been pressed (step S710; NO), the process returns to step S702, and the processes of steps S702 to S709 are repeatedly executed.

  If it is determined that the temporary closing key 127 has been pressed (step S710; YES), the total sales amount and the consumption tax of the products registered in steps S702 to S707 are calculated and displayed on the display unit 12 and also stored in the RAM 13. The slip number, registered product name, amount (unit price), total sales amount, consumption tax, transaction item, number of customers, and the like are printed on the receipt by the printing unit 16 (step S711).

  Next, the journal code 1001 record is retrieved from the journal pattern information file 142, and the retrieved record is read into the RAM 13 (step S712). In addition, although the temporary fastening in the case of cash payment is demonstrated here for the simplification of description, it is good also as a structure which can be temporarily tightened also in the payment with a credit card or a gift certificate.

  Next, the total sales amount calculated in step S711 is substituted for “debit tax included amount” and “credit including tax amount” of the record read to the RAM 13 in step S712. Further, the consumption tax calculated in step S711 is assigned to the items of “debit consumption tax” and “credit consumption tax” (step S713).

  Next, the ECR code, the slip serial number, and the slip number are acquired from the slip sequence number storage file 144 and stored in the RAM 13 (step S714). Further, the current date and time are acquired from the time measuring unit 18 and stored in the RAM 13 (step S715). Then, a new record is added to the accounting journal data file 143, and accounting journal data is created based on the journal pattern information record read to the RAM 13 (step S716). Specifically, the journal pattern information record read out in step S712 (including the amount substituted in step S713 and the consumption tax) corresponds to each data item of the record added to the recorded journal data file 143. The item data and the data acquired in steps S714 to S715 are written and stored.

  When the writing of the data to the recorded journal data file 143 is completed, the slip serial number and the slip number in the slip serial number storage file 144 are incremented by 1 (step S717), and the sales management process is ended.

  Returning to FIG. 10, if it is determined in step S12 that the slip number key 128 has not been pressed (step S12; NO), it is determined whether or not the cash amount declaration key 125 has been pressed (step S14). If it is determined that the cash amount declaration key 125 has been pressed (step S14; YES), the cash balance reporting process is executed (step S15). The pay-in-ahead reporting process is a process that is always executed in accordance with the operation of the operator after the store is closed and before the daily sales are settled. In the cash amount declaration process, the operator registers the number (number) of money from the 10,000 yen bill to 1 yen coin in the drawer 17 and the total amount of the gift certificate in accordance with the guidance of the display unit 12, This is a process of calculating the total amount of money stored in the drawer 17 (the amount of money reported). The calculated amount of money reported is stored in the money amount file 146 in association with the current date.

  Returning to FIG. 10, if it is determined in step S14 that the cash amount declaration key 125 is not pressed (step S14; NO), it is determined whether or not the subtotal key 119 is pressed (step S16). If it is determined that the subtotal key 119 has not been pressed (step S16; NO), the process returns to step S2 to register the next product. If it is determined that the subtotal key 119 has been pressed (step S16; YES), the process proceeds to step S17.

  In step S17, it is determined whether or not the credit key 116 has been pressed. If it is determined that the credit key 116 is pressed (step S17; YES), sales journal processing (pattern 2) is executed (step S18).

  FIG. 16 is a flowchart showing the sales journal processing (pattern 2) executed in step S18 of FIG. The sales journal processing (pattern 2) is executed in cooperation with the CPU 10 and the processing program 145 stored in the storage unit 14.

  First, it is determined whether or not a PLU number has been input by the input unit 11 (step S301). If it is determined that the PLU number has been input by the input unit 11 (step S301; YES), the PLU setting file 141 is referred to, and the journal code corresponding to the input PLU number is acquired (step S302). Next, pressing of the registration confirmation key 120 from the input unit 11 is waited. When the registration confirmation key 120 is pressed (step S303), the process proceeds to step S306.

  On the other hand, if it is determined by the input unit 11 that the PLU number has not been input (step S301; NO), it is determined whether or not the registration confirmation key 120 has been pressed, and it is determined that the registration confirmation key 120 has been pressed. (Step S304; YES), the journal code 1002 is acquired (Step S305), and the process proceeds to Step S306. If there is only one credit company with which the sales data processing apparatus 1 is contracted, there is only one transaction item related to credit sales, so the journal entry code is fixed (fixed to 1002 in this embodiment). Therefore, it is not necessary to input the PLU number.

  In step S306, the total sales amount and consumption tax of the products registered in steps S2 to S16 in FIG. 10 are calculated, and the registered product name, amount (unit price), total sales amount, consumption tax, transaction item, etc. The receipt is printed by the printing unit 16 (step S306).

  Next, a record in which the journal code acquired in step S302 or S304 matches the “journal code” is retrieved from the journal pattern information file 142, and the retrieved record is read into the RAM 13 (step S307).

  Next, the total sales amount calculated in step S306 is substituted for “debit tax included amount” and “credit included amount” in the record read to the RAM 13 in step S307. Further, the consumption tax calculated in step S306 is assigned to the items of “debit consumption tax” and “credit consumption tax” (step S308).

  Next, the ECR code, the slip serial number, and the slip number are acquired from the slip sequence number storage file 144 and stored in the RAM 13 (step S309). Further, the current date and time are acquired from the time measuring unit 18 and stored in the RAM 13 (step S310). Then, a new record is added to the accounting journal data file 143, and accounting journal data is created based on the journal pattern information record read to the RAM 13 (step S311). Specifically, each record data item added to the recorded journal data file 143 corresponds to the journal pattern information record read in step S307 (including the amount substituted in step S308 and the consumption tax). The item data and the data acquired in steps S309 to S310 are written and stored.

  When the writing of the data to the recorded journal data file 143 is completed, the slip serial number and the slip number in the slip serial number storage file 144 are incremented by 1 (step S312), and the sales journal processing (pattern 2) is finished.

  FIG. 17 is a diagram illustrating an example of an operation procedure of the operator until the sales journalizing process (pattern 2) is finished and a receipt output by the sales journalizing process (pattern 2). FIG. 17 shows a case where the price for the order of menu B (700 yen) and menu H (500 yen) is paid by credit (X credit sales). First, the operator presses the flat PLU key 113 or the like corresponding to the ordered product (menu B, menu H) and inputs PLU numbers 002 and 008 (step S4 in FIG. 10). Next, the subtotal key 119 indicating that the product registration is completed is pressed (step S16 in FIG. 10). Next, the credit key 116 is pressed to input the transaction category “credit” (step S17 in FIG. 10). If there are contracts with several credit companies, the PLU number 146 is entered by pressing the flat PLU key 113 corresponding to the transaction item (credit (X credit sales)) (step S301 in FIG. 16), The registration confirmation key 120 is pressed (step S303 in FIG. 16). If there is a transaction with one credit company, the registration confirmation key is pressed (step S304 in FIG. 16). Then, the process after step S306 in FIG. 16 is executed, and the credit sales journalizing process for menu B and menu H is automatically performed. In addition, a receipt shown in FIG. 17 is issued (step S306 in FIG. 16).

  As described above, in the sales data processing apparatus 1, the operator performs the same operations as in conventional general merchandise registration, that is, the input of the PLU number corresponding to the purchased merchandise, the input of the transaction amount, and the input of the transaction classification. In addition to the above operations, the sales journal processing (pattern 2) for sales by credit registered in the sales data processing apparatus 1 is automatically performed by simply pressing the PLU number corresponding to the transaction item and the registration confirmation key 120. Executed.

  Returning to FIG. 10, if it is determined in step S17 that the credit key 116 is not pressed (step S17; NO), it is determined whether or not the ticket key 117 is pressed (step S19). If it is determined that the ticket key 117 is pressed (step S19; YES), sales journal processing (pattern 3) is executed (step S20).

  FIG. 18 is a flowchart showing the sales journal processing (pattern 3) executed in step S20 of FIG. The sales journal processing (pattern 3) is executed in cooperation with the CPU 10 and the processing program 145 stored in the storage unit 14.

  First, the input of the PLU number from the input unit 11 is waited, and if it is determined that the PLU number has been input (step S401; YES), the PLU setting file 141 is referred to and the journal code corresponding to the input PLU number is entered. Is acquired (step S402). Next, the input of the gift certificate amount from the input unit 11 is waited. When the gift certificate amount is input (step S403; YES), the registration confirmation key 120 is pressed (step S404). When the registration confirmation key 120 is pressed (step S404; YES), the process proceeds to step S405.

  In step S405, the total sales amount and consumption tax of the products registered in steps S2 to S16 in FIG. 10 are calculated, and the registered product name, amount (unit price), total sales amount, consumption tax, transaction item, etc. The receipt is printed by the printing unit 16 (step S405).

  Next, a record in which the journal code acquired in step S402 matches the “journal code” is retrieved from the journal pattern information file 142, and the retrieved record is read into the RAM 13 (step S406).

  Next, the total sales amount calculated in step 405 is substituted into “debit tax included amount” and “credit including tax amount” of the record read to the RAM 13 in step S406. Further, the consumption tax calculated in step S405 is assigned to the items of “debit consumption tax” and “credit consumption tax” (step S407).

  Next, the total sales amount is compared with the gift certificate amount input in step S403, and if it is determined that the total sales amount is smaller than the gift certificate amount (step S408; YES), the debit is the gift certificate and the credit is cash 2 (Registry) is created, and data including the amount of tax-included debit and credit as the difference between the total sales amount and the gift certificate amount is created (step S409). Specifically, “debit item name” is “gift certificate”, “debit item code” is 103 (item code indicating gift certificate), “credit item name” is “cash 2 (register)”, “credit item code” ”Is 101 (subject code indicating cash), and“ debit tax-included amount ”and“ credit tax-included amount ”are created as the above difference amounts. Then, the process proceeds to step S411.

  On the other hand, if it is determined in step S408 that the total sales amount is equal to or greater than the gift certificate amount (step S408; NO), a record of cash sales (journal code 1001) stored in the journal pattern information file 142 is stored in the RAM 13. The difference amount between the gift certificate amount and the total sales amount is substituted for “debit tax included amount” and “credit including tax amount” (step S410). Then, the process proceeds to step S411.

  In step S411, the ECR code, the slip serial number, and the slip number are acquired from the slip sequential number storage file 144 and stored in the RAM 13 (step S411). Further, the current date and time are acquired from the time measuring unit 18 and stored in the RAM 13 (step S412). Then, two new records are added to the accounting journal data file 143, and accounting journal data is created and stored based on the journal pattern information record read in step S406 (step S413). Specifically, for each data item on the first line of the added record, the corresponding item of the journal pattern information record (including the amount substituted in step S407 and the consumption tax) read in step S406. The data and the data acquired in steps S411 to S412 are written and stored. In addition, the data of the corresponding item of the data created in step S409 or S410 and the data acquired in steps S411 to S412 are written and stored in each data item on the second line of the added record (step S411). S413).

  When the writing of data to the booked journal data file 143 is completed, the slip serial number and the slip number in the slip serial number storage file 144 are incremented by 1 (step S414), and the sales journal processing (pattern 3) is finished.

  FIG. 19 is a diagram illustrating an example of an operation procedure of the operator until the sales journalizing process (pattern 3) is completed and a receipt output by the sales journalizing process (pattern 3). FIG. 19 shows the operation procedure and receipt of the operator when the price for the order of menu A (600 yen) is paid by the gift certificate. As shown in FIG. 19, the operator first inputs the PLU number 001 by pressing the flat PLU key 113 corresponding to the ordered product (menu A) (step S4 in FIG. 10). Next, the subtotal key 119 indicating that the product registration is completed is pressed (step S16 in FIG. 10). Next, the ticket key 117 for inputting the transaction category “gift certificate” is pressed (step S19 in FIG. 10). Next, the PLU number is input by pressing the flat PLU key 113 corresponding to the transaction item (gift certificate sales) (step S401 in FIG. 18). Then, the gift certificate amount is input (step S403 in FIG. 18), and the registration confirmation key is pressed (step S404 in FIG. 18). Then, the process after step S405 in FIG. 18 is executed, and the journalizing about the sales of menu A paid by the gift certificate is performed, and the receipt shown in FIG. 19 is issued (step S405 in FIG. 18).

  As described above, in the sales data processing apparatus 1, the operator performs the same operations as conventional general merchandise registration, that is, the operation for inputting the PLU number of the purchased merchandise, the transaction amount, and the transaction classification. In addition, the sales journal processing (pattern 3) for the gift certificate registered in the sales data processing device 1 is automatically performed by simply pressing the PLU number, gift certificate amount and registration confirmation key 120 corresponding to the transaction item. Is executed automatically.

  Returning to FIG. 10, in step S19, it is determined that the ticket key 117 is not pressed (step S19; NO), and it is determined whether the deposit amount is input and the cash deposit key 118 is pressed by the input unit 11. (Step S21). If it is determined by the input unit 11 that the deposit amount has not been input and the cash deposit key 118 has not been pressed (step S21; NO), the process returns to step S17. If it is determined that the deposit amount is input and the cash deposit key 118 is pressed by the input unit 11 (step S21; YES), the total sales amount and the consumption tax of the products registered in steps S2 to S16 are calculated and displayed. Displayed on the unit 12. The registered product name, amount (unit price), total sales amount, consumption tax, transaction classification, and the like are printed on the receipt by the printing unit 16 (step S22). Then, sales journal processing (pattern 1) is executed (step S23).

  FIG. 20 is a flowchart showing the sales journal processing (pattern 1) executed in step S23 of FIG. The sales journal processing (pattern 1) is executed in cooperation with the CPU 10 and the processing program 145 stored in the storage unit 14.

  First, a record whose “journal code” matches 1001 is retrieved from the journal pattern information file 142, and the retrieved record is read into the RAM 13 (step S501). Here, in this embodiment, since the journal pattern information when the cash deposit key 118 is pressed is uniquely determined by the record of cash sales (journal code 1001), the record of cash sales is not required even if the PLU number is not pressed. Is read out. Note that the PLU number (0145 in this case) may be pressed.

  Next, the total sales amount calculated in step S22 of FIG. 10 is substituted into “debit tax included amount” and “credit included tax amount” of the record read to the RAM 13 in step S501. Further, the consumption tax calculated in step S22 of FIG. 10 is assigned to the items of “debit consumption tax” and “credit consumption tax” (step S502).

  Next, the ECR code, the slip serial number, and the slip number are acquired from the slip sequence number storage file 144 and stored in the RAM 13 (step S503). Further, the current date and time are acquired from the time measuring unit 18 and stored in the RAM 13 (step S504). Then, a new record is added to the booked journal data file 143, and booked journal data is created based on the journal pattern information record read to the RAM 13 (step S505). Specifically, in each data item of the record added to the recorded journal data file 143, the data of the corresponding item of the journal pattern information record (including the substituted amount and the consumption tax) read in step S501. Or, the data acquired in steps S503 to S504 is written and stored.

  When the writing of data to the booked journal data file 143 is completed, the slip serial number and the slip number in the slip serial number storage file 144 are incremented by 1 (step S506), and the sales journal processing (pattern 1) is finished.

  FIG. 21 is a diagram showing an example of an operation procedure of the operator until the sales journalizing process (pattern 1) is completed and a receipt output by the sales journalizing process (pattern 1). FIG. 21 illustrates an operator's operation procedure and receipt when an order for menu B (700 yen) and menu H (500 yen) is paid in cash. As shown in FIG. 21, the operator first presses the PLU numbers 002 and 008 corresponding to the names of the ordered products (menu B and menu H) (step S4 in FIG. 10). Next, the subtotal key 119 indicating that the product registration is completed is pressed (step S16 in FIG. 10). Next, the deposit amount is input and the cash deposit key 118 is pressed (step S21 in FIG. 10). Then, the receipt shown in FIG. 21 is issued (step S22 in FIG. 10), and the sales journal processing (pattern 1) in FIG. 20 is automatically executed.

  Returning to FIG. 10, if it is determined in step S1 that the mode switch 124 is not set to the registration mode (step S1; NO), it is determined whether or not the mode switch 124 is set to the return mode (step S1; NO). Step S24). If it is determined that the mode switch 124 is set to the return mode (step S24; YES), the process proceeds to step S25.

  In step S25, it is determined whether or not a numerical value has been input by pressing the numeric key 111 (step S25). If it is determined that a numerical value has been input by pressing the numeric keypad 111 (step S25; YES), the input numerical value is displayed on the display unit 12 (step S26), and the process proceeds to step S27. If it is determined that the numeric key 111 is not pressed and no numerical value is input (step S25; NO), the process proceeds to step S27.

  In step S27, it is determined whether or not a PLU number is input from the input unit 11 (step S27). The PLU number input here is the PLU number corresponding to the product to be refunded. If it is determined that the PLU number is not input from the input unit 11 (step S27; NO), the process proceeds to step S31. If it is determined that the PLU number is input from the input unit 11 (step S27; YES), the PLU setting file 141 is referred to, and the “name” corresponding to the input PLU number is displayed on the display unit 12. When the unit price is associated with the PLU number, the product score (quantity) and the total amount of returned goods are added and displayed on the display unit 12 (step S28).

  Next, the PLU setting file 141 is referred to and it is determined whether or not the input PLU number is a product number PLU (step S29). That is, it is determined whether or not “product number PLU” corresponding to the input PLU number is “yes”. If it is determined that the input PLU number is the product number PLU (step S29; YES), the input of the amount by pressing the numeric key 111 and the amount key 121 is waited. When the amount is input, the input amount is displayed on the display unit 12, and the total amount is added and displayed on the display unit 12 (step S30), and the process proceeds to step S31. If it is determined that it is not a product number PLU (step S29; NO), the process proceeds to step S31.

  In step S31, it is determined whether or not the subtotal key 119 for instructing the end of registration of the product to be refunded is pressed, and if it is determined that the subtotal key 119 has not been pressed (step S31; NO). The process returns to step S25. If it is determined that the subtotal key 119 has been pressed (step S31; YES), it is determined whether or not the cash deposit key 118 has been pressed. If it is determined that it has been pressed (step S32; YES), sales journal processing ( Pattern 4) is executed (step S33).

  FIG. 22 is a flowchart showing the sales journal processing (pattern 4) executed in step S33 of FIG. The sales journal processing (pattern 4) is executed in cooperation with the CPU 10 and the processing program 145 stored in the storage unit 14.

  First, a record whose “journal code” matches 1001 is retrieved from the journal pattern information file 142, and the retrieved record is read into the RAM 13 (step S601). Here, in the present embodiment, since the journal pattern information used for the return process is uniquely determined by the record of cash sales (journal code 1001), the record of cash sales is read without pressing the PLU number. Note that the PLU number (0145 in this case) may be pressed.

  Next, the reverse journal processing is performed, and the items related to the debit (debit item code, debit item name, debit sub item, debit tax category) and the credit related items (credit item code, credit) of the record read in step S601. The subject name, credit auxiliary subject, credit tax classification) are exchanged, and “return” is added to “summary” (step S602).

  Next, the total amount of returned goods and the consumption tax of the product registered in steps S25 to S31 in FIG. 10 are calculated (step S603).

  Next, the total refund amount is assigned to the items of “debit including tax” and “credit including tax” in the RAM 13. Further, the consumption tax calculated in step S603 is assigned to the items of “debit consumption tax” and “credit consumption tax” (step S604).

  Next, the ECR code, the slip serial number, and the slip number are acquired from the slip sequence number storage file 144 and stored in the RAM 13 (step S605). Further, the current date and time are acquired from the time measuring unit 18 and stored in the RAM 13 (step S606). Then, a new record is added to the accounting journal data file 143, and accounting journal data is created based on the journal pattern information record read to the RAM 13 (step S607). Specifically, the data of the item corresponding to the record of the journal pattern information (including the substituted amount and the consumption tax) read in step S601 is added to each data item of the record added to the booked journal data file 143. Alternatively, the data acquired in steps S605 to S606 is written and stored.

  When the writing of the data to the booked journal data file 143 is completed, a receipt is printed by the printing unit 16 based on the record (recorded journal data) added to the booked journal data file 143 (step S608). Then, the slip serial number and the slip number in the slip serial number storage file 144 are incremented by 1 (step S609), and the sales journalizing process (pattern 4) is completed.

  FIG. 23 is a diagram illustrating an example of an operation procedure of the operator until the sales journalizing process (pattern 4) ends and a receipt output by the sales journalizing process (pattern 4). FIG. 23 illustrates the operation procedure and receipt of the operator when the order for menu B (700 yen) and menu H (500 yen) is canceled and refunded. First, the operator sets the mode switch 124 to the return mode, and presses the PLU numbers 002 and 008 corresponding to the return target products (menu B and menu H) (step S27 in FIG. 10). Next, the subtotal key 119 indicating that the product registration is completed is pressed (step S31 in FIG. 10). Next, the cash deposit key 118 is pressed (step S32 in FIG. 10). Then, the sales journal processing (pattern 4) in FIG. 22 is automatically executed, and the receipt shown in FIG. 23 is issued (step S608 in FIG. 22).

  As described above, in the sales data processing apparatus 1, the operator performs the same operations as in the conventional general refund operation, that is, the transition to the return mode, the input of the PLU number to be returned, and the input of the transaction classification. The journal for the refund made by the sales data processing apparatus 1 is automatically executed simply by performing the process.

  Returning to FIG. 10, if it is determined in step S24 that the mode switch 124 is not set to the return mode (step S24; NO), the process returns to step S1.

Next, the settlement process executed in the sales data processing apparatus 1 after closing the store for one day will be described.
FIG. 24 is a flowchart showing the settlement process. The settlement process is executed in cooperation with the CPU 10 and the processing program 145 stored in the storage unit 14 when the mode switch 124 is set to the settlement mode and the registration confirmation key 120 is pressed.

  First, the current date is acquired from the time measuring unit 18 and stored in the RAM 13 (step S801).

  Next, the first record is read from the journal pattern information file 142 to the RAM 13 (step S802). Next, it is determined whether or not “journal classification” = “5; settlement” of the read record (step S803). If it is determined that the “journal classification” of the read record is not “5; settlement” (step S803; NO), the process proceeds to step S812.

  On the other hand, if it is determined that “journal classification” = “5; settlement” of the record read in step S802 (step S803; YES), “current month draft” and “processing date” of the read record are determined. Is acquired (step S804). If the acquired “current month draft” is not “not yet” or the current date is not “processing date” (step S805; NO, step S806; NO), the process proceeds to step S812.

  If the “current month draft” acquired in step S804 is “not yet” and the current date acquired in step S801 ≧ the processing date (step S805; YES, step S806; YES), read in step S802. Data of each item of “tax included amount”, “consumption tax”, “debit item code”, “debit item name”, “credit item code”, “credit item name”, “explanation” of the recorded record is acquired, It is stored in the RAM 13 (step S807). Further, the current date and time are acquired from the time measuring unit 18 and stored in the RAM 13, and the ECR code, the slip serial number, and the slip number are acquired from the slip sequential number storage file 144 and stored in the RAM 13 (step S 808). . Then, a new record is added to the booked journal data file 143, and booked journal data is created based on the journal pattern information record read in step S802 (step S809). Specifically, the data of the corresponding item in the record of the journal pattern information read in step S802 and the data acquired in step S808 are written in each data item of the record added to the booked journal data file 143. And memorized.

  When the writing of the data to the recorded journal data file 143 is completed, an “account withdrawal automatic journal record” is created based on the data stored in the RAM 13 in steps S807 and S808, and printed out by the printing unit 16 (step S807). S810). Then, “Done” is stored in “Draft this month” of the record read in Step S802, and the slip serial number and slip number of the slip sequential number storage file 144 are incremented by 1 (Step S811), Control goes to step S812.

25A and 25B are diagrams illustrating an example of “account withdrawal automatic journal entry” printed out by the printing unit 16 in step S810. FIG. 25A is an “account withdrawal automatic journal entry” for a transaction withdrawn from a deposit account at a fixed amount every month. FIG. 25B is an “account withdrawal automatic journal entry” for a transaction withdrawn from a deposit account on a specified date by monthly billing.
“Account withdrawal automatic journal entry” shown in FIG. 25A and FIG. 25B is issued when the journal entry transaction registered in advance in the journal pattern information file 142 is automatically journalized in step S809. This is an account withdrawal journal slip in which a journal result (contents of created journal journal data) is described. As shown in FIG. 25A and FIG. 25B, “Account withdrawal automatic journal entry” includes the date and time of automatic journal entry, slip number, transaction name (summary), withdrawal amount, debit information (debit item code, debit) (Course name, debit tax included), credit information (credit item code, credit subject name, credit tax included), etc. are described.

  In this way, for account withdrawal transactions that do not go through the sales data processing device 1, journaling is automatically performed on the withdrawal date, and "account withdrawal automatic journal entry" as an account withdrawal journal is printed out. Convenience is improved because there is no need to make a draft for the account withdrawal transaction manually on the withdrawal date. In addition, it is possible to calculate a profit taking account withdrawal into account at the time of settlement.

  In step S812, the next record in the journal pattern information file 142 is read (step S812). Next, it is determined whether or not the next record is a file end (step S813). If it is determined that the next record is not a file end (step S813; NO), the process returns to step S803, and the processes of steps S803 to S813 are executed until the file end is reached. If it is determined that the next record is a file end (step S813; YES), the process proceeds to step S814.

In step S814, an aggregation process at the time of settlement is executed (step S814).
FIG. 26 is a flowchart showing the totaling process at the time of payment executed in step S814. The totaling process at the time of payment is executed in cooperation with the CPU 10 and the processing program 145 stored in the storage unit 14.

  First, the top one record is read from the recorded journal data file 143 to the RAM 13 (step S901).

  Next, it is determined whether or not the “slip date” of the record read in step S901 is the current month (step S902). If it is determined that the “slip date” is not the current month (step S902; NO), the process proceeds to step S913. If it is determined that the “slip date” is the current month (step S902; YES), the “journal category”, “withdrawal category”, “debit item name”, and “debit tax included” in the record read in step S901. , “Credit subject name”, “Credit tax included amount”, and “Number of visitors” are acquired and stored in the RAM 13 (step S903). Further, the data of the summary file 147 (see FIG. 27) is read from the storage unit 14 (step S904).

  FIG. 27 is a diagram illustrating an example of data storage in the summary file 147. As shown in FIG. 27, the total file 147 includes “sales” by cash, accounts receivable, and gift certificate total items, “purchase” by cash, accounts payable by total items, and “expenses” by cash. In addition, there are areas for summing today's total and the current month's cumulative total for cash transfer, bank deposit, and employer loan items for “transfer” by tabulation items for fixed and direct debits. Note that the “today's total” data of each tabulation item is in a cleared state at the time of reading (see step S822 in FIG. 24).

  Next, it is determined whether or not “journal classification” = “1; sales” of the record read in step S901, and if it is determined that “journal classification” = “1; sales” (step S905). ; YES), each of the column for the total of the current day and the current month of the total item (cash, receivable, or gift certificate) corresponding to the “debit item name” of the read record in the “sales” category of the total file 147 In addition, the “debit tax included amount” of the read record is added and totaled. Further, the “number of visitors” of the record is added to the total number of customers in the total file 147 (step S906). Then, the process proceeds to step S913.

  If it is determined that “journal classification” = “1; sales” of the record read in step S901 (step S905; NO), “journal classification” = “2; purchase” of the read record. If it is determined that “Journal classification” = “2; Purchase” (step S907; YES), the “purchase” classification of the aggregation file 147 is read out as described above. The total amount of items (cash or accounts payable) corresponding to the “credit item name” of the record is added to the today's total and current month's total fields, and the “credit including tax” of the read record is added and totaled (step S908). . Then, the process proceeds to step S913.

  If it is determined that “journal classification” = “2; purchase” of the record read in step S901 (step S907; NO), “journal classification” = “3; expense” of the read record. If it is determined that “Journal classification” = “3; Expense” (step S909; YES), the “credit item name” of the read record is cash 2 (registry). In this case, the “credit amount including tax” of the read record is added and totaled in the columns of “summary item = cash today total” and “current total” in the “expense” category of the total file 147. When “withdrawal category” = “fixed amount” of the read record, the “credit amount including tax” of the read record is added and totaled in the columns of total item = total deduction today and total for the current month respectively. Is done. If the “Credit item name” in the read record is not cash 2 (cash register) and “withdrawal category” = “fixed amount” (that is, withdrawing by invoice), the summation item = account withdrawal The “credit amount including tax” of the read record is added and totaled in each of the today total and current month total columns (step S910). Then, the process proceeds to step S913.

  If it is determined that “journal classification” = “3; expense” of the record read in step S901 (step S908; NO), “journal classification” = “4; transfer” of the read record, It is determined whether “slip date” = current date and the debit or credit subject name is “cash 2 (register)” (step S911). If it is determined that “journal classification” = “4; transfer”, “slip date” = current date of the read record and the debit or credit item name is not “cash 2 (register)” (step) S911; NO), the process proceeds to step S913.

On the other hand, when it is determined that “journal classification” = “4; transfer”, “slip date” = current date of the read record, and the debit or credit item name is “cash 2 (register)” (Step S911; YES) According to the subject name of the counterpart subject in the read record, the “tax-included amount” of the counterpart subject is the cash of cash, bank deposit, business owner loan of the “transfer” category of the summary file 147 Addition or subtraction processing is performed on any of the total items (step S912).
Specifically, when the counterparty is borrowed by the employer, the “tax-included amount” of the counterparty is added to the total and the current day of the total items of the borrower. When the counterpart item is an employer loan, the “tax-included amount” of the counterpart item is subtracted from the total of the loan items of the employer today and the cumulative total on the day. If the counterpart account is a deposit account (debit), the “tax-included amount” of the counterpart subject is subtracted from the total today and the total of the current day of the bank deposit total items. If the opponent's subject is a deposit account (credit), the “tax-included amount” of the opponent subject is added to the total for the cashier deposit total today and the current day total. Then, the process proceeds to step S913.

  In step S913, the next record in the account journal data file 143 is read (step S913), and it is determined whether or not the next record is a file end (step S914). If it is determined that the next record is not a file end (step S914; NO), the process returns to step S902, and the processes of steps S903 to S913 are executed. If it is determined that the next record is a file end (step S914; YES), the aggregation process at the time of settlement ends, and the process proceeds to step S815 in FIG.

In step S815 of FIG. 24, based on the value of each total item of the total file 147 created by the total process at the time of settlement, the following items (1) to (6) today's total and current month total are calculated by the following formula. Is calculated (step S815).
(1) Total sales = Cash + Accounts receivable + Gift certificates (2) Unit price per customer = Total sales / Number of customers (3) Total purchase = Cash + Accounts payable (4) Total expense = Cash + Regular debit + Account debit (5) Coarse Interest = Sales total-Purchase total-Expense total (6) Gross margin = Gross profit / Sales total x 100%

Next, the amount of money to be reported is read from the cash amount file 146, and the following items (7) to (8) are calculated by the following formula (step S816).
(7) Cash surplus = Amount declared in cash-(Previous day cash register balance + Today's gross profit + Cash register deposit + Bank deposit + Employer loan)
(8) Carrying forward the next day = Amount declared

Next, it is determined whether or not the calculated cash excess / deficiency = 0, and if it is determined that cash excess / deficiency = 0 (step S817; YES), the process proceeds to step S821. If it is determined that cash excess / deficiency is not 0 (step S817; NO), if the cash excess / deficiency is a positive value (plus), the journalizing process is performed with the debit as cash and the credit as cash excess / deficiency. If the cash excess / deficiency is a negative value (minus), the journalizing process is performed with the debit as the cash excess / deficiency and the credit as the cash (step S818).
Specifically, if cash surplus or deficiency is a positive value, “Debit Item Name” is “Cash 2 (Register)”, “Debit Item Code” is the item code corresponding to Cash 2 (Register), “Debit” "Tax included amount" and "Credit tax included amount" are the amount of cash excess / deficiency, "Credit item name" is "Cash excess / deficiency", "Credit item code" is the item code corresponding to cash excess / deficiency, "Journal category" = "4 : “Transfer” and “Summary” are automatically created and stored in the RAM 13 as “cash excess / deficiency processing”. If cash deficiency is negative (minus), “debit item name” is “cash deficiency”, “debit item code” is item code corresponding to cash deficiency, “debit tax included amount” and “credit” “Tax included” is the amount of excess or shortage of cash, “Credit item name” is “Cash 2 (Register)”, “Credit item code” is the item code corresponding to Cash 2, “Journal category” = “4: Transfer”, “ The accounting journal data with “Summary” as “Cash excess / deficiency processing” is automatically created and stored in the RAM 13. In addition, the current date and time are acquired from the time measuring unit 18, and the ECR code, the slip sequential number, and the slip number are acquired from the slip sequential number storage file 144 and stored in the RAM 13. Then, a new record is added to the accounting journal data file 143, and the accounting journal data, ECR code, current date and time, slip number, and slip serial number created in the RAM 13 are written in each data item of the added record. Remembered.

  When the writing of the data to the booked journal data file 143 is completed, a “book entry for cash shortage” is created and printed out by the printing unit 16 (step S819). Then, the slip sequence number and the slip number in the slip sequence number storage file 144 are incremented by 1 (step S820), and the process proceeds to step S821.

  FIG. 28 is a diagram illustrating an example of a “book entry for cash shortage” printed out by the printing unit 16 in step S819. 28 is a report in which journal entries (contents of recorded journal data created) are issued when an automatic journal entry for cash excess / deficiency is performed. As shown in FIG. 28, the “book entry for cash excess / deficiency” includes the date and time of automatic journal entry, the slip number, the credit and debit subject names, the amount, and the like.

  As described above, in the sales data processing apparatus 1 according to the present embodiment, the amount of money actually stored in the drawer 17 of the sales data processing apparatus 1 in the daily checkout process is calculated using the above formula (7). Judgment is made on whether or not they match. If they do not match, the journal entry data in which the cash excess / deficiency amount is recorded as the cash excess / deficiency item is automatically created. The cash balance and the cash balance in the cash book can be perfectly matched, and the reliability of the book for tax examination can be greatly improved.

  In step S821, the total of today's total and total of the current month for each total item in the total file 147, the total of today's total and the current month of each item (1) to (8) calculated in steps S815 to S816. (That is, the result of today's transaction) is created and printed out by the printing unit 16 (step S821). Then, the “total of today” column of the total file 147 is cleared, and the next day's carry-forward amount calculated in step S816 is written and stored in the total item of “previous day cash balance” (step S822). Then, the settlement process ends.

FIG. 29 is a diagram illustrating an example of the “today's business report” printed out by the printing unit 16 in step S821. As shown in FIG. 29, “Today's business report” includes sales total 161, purchase total 162, expense total 163, revenue total 164, transfer total 165, cash balance 166, cash surplus 167, carry forward 168 the next day. Etc. are described.
The sales summary 161 is a summary result of summing up the total for today and the current month for each summary item of cash, credit, gift certificate, sales total, number of customers, and unit price of customers. The purchase total 162 is a total result obtained by totaling the current total and the current month total for each total item of cash, accounts payable, and total purchase. The expense total 163 is a total result obtained by summing up the total for today and the current month for each total item of cash, fixed amount withdrawal, account withdrawal, and expense total. The total income 164 is a totaling result obtained by totaling the total for today and the total for the current month for each total item of gross profit and gross margin. The transfer total 165 is a total result obtained by totaling the current day total and the current month total for each of the total items of cash register deposit, bank deposit, and business owner borrowing. The cash advance declaration 166 is a cash advance declaration amount. The cash excess / deficiency 167 is a value indicating an excess / deficiency of cash in the sales data processing apparatus 1. The next day carry-over 168 is an amount carried over to the next day.

  In the journalizing process and the checkout process shown in FIG. 10, booked journal data is created for a transaction including an account withdrawal transaction that does not go through the sales data processing apparatus 1, and based on the created booked journal data, shown in FIG. Since the “today's business report” is created, it becomes possible for the store manager to accurately grasp the profits (revenue) for the current day and the current month, taking account of account withdrawal transactions that do not go through the sales data processing device 1.

  Next, a process of uploading the account journal data created by the journal process and the settlement process in the sales data processing apparatus 1 to the server apparatus 2 will be described.

  FIG. 30 is a flowchart showing a process when uploading the journal entry data from the sales data processing apparatus 1 to the server apparatus 2. The process shown in FIG. 30 is started after the settlement process at the end of one day of the store business. The processing on the sales data processing device 1 side shown in FIG. 30 is executed in cooperation with the CPU 10 of the sales data processing device 1 and the processing program 145 stored in the storage unit 14. The processing on the server device 2 side is executed in cooperation with the CPU 20 of the server device 2 and the processing program 244 stored in the storage unit 24.

  First, in the sales data processing device 1, communication connection to the server device 2 is performed by the communication unit 15 (step U1). In the server device 2, a communication connection request from the sales data processing device 1 is received by the communication unit 25 (step U2).

  Next, in the sales data processing device 1, the authentication data stored in the storage unit 14 is read (step U3), and the read authentication data is transmitted to the server device 2 by the communication unit 15 (step S3). U4).

  In the server device 2, when authentication data is received by the communication unit 25 (step U 5), the received authentication data is collated with the authentication data stored in the authentication setting file 241 (step S 5). U6). Then, authentication response data is created based on the collation result (step U7). As a result of the collation, when a record in which the authentication data matches the ECR code and the opening password exists in the authentication setting file 241, authentication response data indicating that communication connection is possible is created. If there is no record in the authentication setting file 241 that matches the authentication data with the ECR code and the opening password, authentication response data indicating that communication connection is impossible is created. The created authentication response data is transmitted to the sales data processing device 1 of the connection request source by the communication unit 25 (step U8). The received authentication data, verification result, created authentication response data, and the like are held in the RAM 23.

  In the sales data processing apparatus 1, when the authentication response data is received by the communication unit 15 (step U9), it is determined whether communication connection is possible based on the received authentication response data. When it is determined that communication connection is possible (step U10; connection is possible), the corresponding data (for example, “slip date” is the current journal data) is acquired from the recorded journal data file 143 (step U11). The acquired journal entry data is transmitted to the server device 2 by the communication unit 15 (step U12), and the process proceeds to step U17. On the other hand, if it is determined that communication connection is impossible (step U10; connection is impossible), error processing is executed (step S16), and the process proceeds to step U17.

  In step U17, communication with server device 2 is disconnected by communication unit 15 (step U17). Then, the upload process on the sales data processing apparatus 1 side ends.

  In the server device 2, it is determined that communication connection with the sales data processing device 1 is possible (step U 13; connectable), and when the journal entry data is received by the communication unit 25 (step U 14), the received journal entry is received. The data is stored in the accounting journal DB 243 in association with the ECR code of the authentication data (step U15). And communication is cut | disconnected by the communication part 25 according to the cutting | disconnection of the communication from the sales data processing apparatus 1 (step U18). Further, the information held in the RAM 23 is deleted (step U19), and the processing on the server device 2 side ends.

  As described above, according to the sales data processing apparatus 1, the storage unit 14 associates a transaction item including a transaction by account withdrawal and a journal code for identifying the journal pattern information of the transaction item with the PLU number. And a journal pattern information file 142 that stores journal pattern information of each transaction item and the journal information when the transaction item is a transaction based on account withdrawal in association with a journal code. ing. The CPU 10 searches the journal pattern information file 142 for records having withdrawal information whose withdrawal date is earlier than the current date. When a corresponding record is retrieved, the CPU 10 determines the withdrawal amount based on the journal pattern information of the retrieved record. Create journalized journal entry data.

  Therefore, it is possible to automatically make a journal entry with the sales data processing device even for transactions by direct debit without going through the sales data processing device 1. In addition, it is possible to calculate the profit taking account of the account withdrawal and provide it to the store manager. Transactions by direct debit include transactions withdrawn from the account at a fixed monthly amount, transactions withdrawn from the account on a specified date due to monthly invoices, transactions that are withdrawn from the account at a fixed monthly amount, or invoice The sales data processing device 1 can automatically journal transactions withdrawn from the account.

  In addition, since the withdrawal date and the withdrawal amount stored in the journal pattern information file 142 can be changed by the input unit 11, even if the withdrawal date or the withdrawal amount is changed, an appropriate change according to the change is made. Journal entry processing can be performed.

  In addition, after creating the journal entry data for the transaction by account withdrawal, an “account withdrawal automatic journal record” as an account withdrawal slip is output from the output unit such as the printing unit 16 based on the created journal entry data. Therefore, it is not necessary to issue a draft manually on the withdrawal date for transactions by direct debit without going through the sales data processing device 1, and convenience is improved.

  Also, at the time of payment, the current and current month's total revenue is calculated based on the recorded journal data of transactions including account withdrawal transactions stored in the recorded journal data file 143. Since the data is output, it is possible to provide the store manager with accurate profits taking account of transactions by direct debit without going through the sales data processing device 1.

  Further, at the time of settlement, it is determined whether there is an excess or deficiency in the amount of money of the drawer 17 input by the input unit 11 and the value indicating the cash balance calculated based on the recorded journal data created today. In the case where there is an excess or deficiency, the accounting journal data in which the surplus / deficiency amount is recorded as a cash excess / deficiency item is created and stored in the accounting journal data file 143, so the amount of money actually stored in the drawer 17 That is, the cash balance can be matched with the balance totaled from the recorded journal data, that is, the balance of the cash accounting book.

In addition, the description content in the said embodiment is a suitable example of the sales data processing system 100 which concerns on this invention, and is not limited to this.
For example, the items such as the PLU setting file 141 shown in the above embodiment are merely examples, and the present invention is not limited to this.

  Further, in the above-described embodiment, it has been described that the account withdrawal automatic journal entry, the cash excess / deficiency journal entry, and today's business report are printed out by the printing unit 16, but these electronic data are output by the communication unit 15. It is good also as a structure output to the server apparatus 2. FIG.

  In addition, the detailed configuration and detailed operation of each device constituting the sales data processing system 100 can be changed as appropriate without departing from the spirit of the invention.

100 Sales data processing system
1 Sales Data Processing Device 10 CPU
11 Input section 111 Ten key 112 Department key 113 Flat PLU key 114 Deposit key 115 Withdrawal key 116 Credit key 117 Ticket key 118 Cash deposit key 119 Subtotal key 120 Registration confirmation key 121 Amount key 122 Multiplication key 123 Connection key 124 Mode switch 125 Present High declaration key 126 Number of customers key 127 Temporary closing key 128 Voucher number key 12 Display unit 13 RAM
14 storage unit 141 PLU setting file 142 journal pattern information file 143 accounting journal data file 144 slip sequential number storage file 145 program 146 inventory report file 147 total file 15 communication unit 16 printing unit 17 drawer 18 timing unit 19 bus 2 server device 20 CPU
21 Input unit 22 Display unit 23 RAM
24 Storage Unit 241 Authentication Setting File 242 Journal Pattern Information Master DB
243 Accounting Journal DB
244 Program 25 Communication unit 26 Bus

Claims (8)

A transaction information storage unit that stores a transaction item including a transaction by direct debit and a journal code for specifying the journal pattern information of the transaction item in association with an identification number;
The journal pattern information of the transaction item is stored in association with the journal code, and when the transaction item is a transaction by the account withdrawal, the journal pattern information is further converted into withdrawal information including a withdrawal date and a withdrawal amount. Journal pattern information storage unit that stores the associated information,
An accounting journal data storage unit for storing accounting journal data;
When the withdrawal date is searched from the journal pattern information storage unit and the corresponding withdrawal information is retrieved, the withdrawal date is retrieved based on the journal pattern information corresponding to the retrieved withdrawal information. A control unit that creates the accounting journal data journalizing the withdrawal amount and stores it in the accounting journal data storage unit;
A sales data processing apparatus.   The sales data processing device according to claim 1, wherein the transaction by debit includes a transaction debited from an account at a fixed amount every month.   The sales data processing device according to claim 1, wherein the transaction withdrawn from the account includes a transaction withdrawn from the account on a specified date by a monthly charge.   The sales data processing device according to any one of claims 1 to 3, further comprising an input unit for changing a withdrawal date and a withdrawal amount stored in the journal pattern information storage unit. With an output section,
5. The control unit according to claim 1, wherein after the creation of the booked journal data, the control unit creates an account withdrawal journal that indicates the content of the created booked journal data, and outputs the account withdrawal journal slip to the output unit. Sales data processing device. The input unit can input an identification number of a transaction item to be journalized, a transaction amount, and a transaction classification,
When the identification number and transaction classification of the transaction item to be journalized are input by the input unit, the control unit acquires a journal code corresponding to the input identification number from the transaction information storage unit, The journal pattern information associated with the journal code is read from the journal pattern information storage unit, and the input transaction amount is journaled based on the transaction classification input by the input unit and the read journal pattern information. The recorded journal data is created and stored in the recorded journal data storage unit, and at the time of settlement, the recorded journal data including the transaction by the account withdrawal, stored in the recorded journal data storage unit, The sales data processing device according to any one of claims 1 to 5, wherein the accumulated profit for the current month is calculated and output by the output unit. The input unit is configured to be able to input the amount of money stored in the sales data processing device,
The control unit determines whether there is an excess or deficiency in the amount of money input by the input unit and the value indicating the cash balance calculated based on the recorded journal data created today at the time of settlement. When there is an excess or deficiency, recorded journal data in which the excess or deficiency amount is recorded as a cash surplus or deficit item is created and stored in the recorded journal data storage unit. Sales data processing device. A computer used in a sales data processing device
A transaction information storage unit for storing a transaction item including a transaction by direct debit and a journal code for specifying the journal pattern information of the transaction item in association with an identification number;
The journal pattern information of the transaction item is stored in association with the journal code, and when the transaction item is a transaction by the account withdrawal, the journal pattern information is further converted into withdrawal information including a withdrawal date and a withdrawal amount. Journal pattern information storage unit for storing in association with each other,
Account journal data storage unit for storing account journal data,
When the withdrawal date is searched from the journal pattern information storage unit and the corresponding withdrawal information is retrieved, the withdrawal date is retrieved based on the journal pattern information corresponding to the retrieved withdrawal information. A control unit that creates the accounting journal data journalizing the withdrawal amount and stores it in the accounting journal data storage unit,
Program to function as.

Images