JPH04291456A - Paperless accounts system - Google Patents

Abstract

PURPOSE:To enable even an operator who knows little accounting knowledge to surely produce the slips, to read the slips at a high speed, and to instantane ously correct the wrong input data by using an electronic slip access means to read the electronic slips out of an electronic slip store means and using a master data deciding means to decide the matching properties of those slips. CONSTITUTION:For instance, a person in charge of a business department inputs the slip data from a work station 21. Thus the slip data are checked to the data registered previously in a master table 51 and the matching property of the input data is confirmed. In this input job, an electronic slip record is produced and stored in each station 21 as an electronic slip file 50. Then an electronic slip production means or an addition processing means has accesses to the electronic slips through an electronic slip access means and with use of an index of combinations of key items of electronic slips. The matching properties of electronic slips are decided based on the basic data registered in the table 51.

Description

[Detailed description of the invention]

0001

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an accounting system using electronic slips.

0002

[Prior Art] In conventional paperless accounting systems, departments such as sales departments and human resources departments that conduct business trips and entertainment enter slip data from terminals installed in each department instead of creating paper slips. There was a system for issuing electronic slips. This terminal was connected online to a computer in the computer department, and was used to manage accumulated electronic slips. Then, in the payment department, the contents of the electronic slips stored in this computer were checked and the payment stamp was verified.

0003

[Problem to be Solved by the Invention] By the way, in the process of issuing slip data from terminals in sales departments, human resources departments, etc., even if the job number or slip code is entered incorrectly,
Most of the input data was registered as is. In addition, since the created slips were checked on the screen, it was difficult to detect errors in input data. Therefore, there was a high risk of issuing incorrect electronic slips, which was a problem.

An object of the present invention is to solve the above problems and provide a paperless accounting system that can issue correct electronic slips.

[0005]

[Means for Solving the Problems] In order to solve the above problems, the paperless accounting system of the first invention includes an electronic voucher creation means for creating electronic vouchers and storing them in a distributed file system; an additional processing means for adding data to the electronic slip, a processing management means for managing the processing status of the electronic slip by the electronic slip creation means and the additional processing means, and an index that combines a plurality of key items of the electronic slip. and electronic slip access means for accessing electronic slips stored in the distributed file system.

[0006]The paperless accounting system of the second invention also includes an electronic voucher creation means for creating an electronic voucher and storing it in a distributed file system, and a process for adding data to the electronic voucher stored in the distributed file system. Additional processing means, a master table device provided in the computer system, and master data judgment for determining the consistency of electronic slips by electronic slip creation means or additional processing means based on basic data registered in the master table device. The means are provided.

[0007]

[Operation] According to the paperless accounting system of the first invention, electronic slips created by the electronic slip creating means are stored in the distributed file system. The electronic slip stored in the distributed file system undergoes data addition processing by the addition processing means. Access to the electronic slip in the electronic slip creating means or the additional processing means is performed by the electronic slip accessing means using an index that is a combination of a plurality of key items of the electronic slip.

According to the paperless accounting system of the second invention, electronic slips created by the electronic slip creating means are stored in the distributed file system. Then, the electronic slip stored in the distributed file system undergoes data addition processing by the addition processing means. The consistency of electronic slips stored in the distributed file system is determined by master data determining means based on basic data registered in the master table device.

[0009]

Embodiment (1) Structure of Embodiment A paperless accounting system which is an embodiment of the present invention will be described below with reference to FIGS. 1 to 39 of the accompanying drawings. FIG. 1 is a configuration diagram of this embodiment. The paperless accounting system 1 of this embodiment includes a network 40 and workstations 11 and 21 connected to this network 40.
, 31. Workstation 11
is installed in the computer department 10, and is equipped with a large-capacity disk device 12 that stores databases for several days. The workstation 21 is installed in the sales department 20 and is equipped with a printer device 22 for creating attached cards 24. The workstation 31 is installed in the general affairs department 30 and is equipped with an image scanner 32 for reading the slip number of the attached card 24.

The paperless accounting system 1 of this embodiment further includes an electronic slip file 50 in which electronic slip records are stored, a master table 51 in which data prepared in advance for input inspection etc. is registered, and a financial institution. A transmission data file 52 storing transaction data is provided. These file data are stored on the network 40
The specifications are such that it can be accessed from any workstation connected to the network. Specifically, how to build these file data on a specific workstation (file server) and access it indirectly by entering this file server from other workstations, or how to create a disk that can be accessed directly from other workstations. There is a method in which an area is set for each workstation and file data such as the electronic slip file 50 is distributed to the disk area of each workstation. An example of this method is using NFS (NETWORK FILE SYS) on a UNIX workstation.
TEM).

(2) Outline of processing in this embodiment Next, an outline of processing in this embodiment will be explained. First, a person in charge of the sales department inputs slip data from the workstation 21. In this input work, a check is performed against the data registered in advance in the master table 51, and the consistency of the input data is confirmed. This input creates an electronic slip record, and this record is stored in the electronic slip file 5.
0 on each workstation. The manager of the sales department checks the electronic slip records that need to be approved on the workstation 21, and inputs approval for the electronic slip records that can be approved. Next, in the accounting department,
The electronic slip record that has been approved by the supervisor is confirmed on the workstation 31, and the final payment for the slip is made. By the way, for a slip that requires a receipt for payment, an attached card 24 is printed out from the printer device 22, and the receipt is pasted on the top of this card. If an attached card 24 that requires a handwritten signature from the department manager is created, the document number is read with the image scanner 32, and the electronic document record is checked to input the payment. The electronic slip records stored in each workstation as the electronic slip file 50 are registered in the database 12 of the computer department 10 by batch processing, for example, once a day. Further, from among the electronic slip records that have been completed up to the payment process, those electronic slip records that require transfer to the account of the financial institution 60, etc. are copied and stored as the transmission data file 52. This transmission data file 52
is sent to the financial institution 60 and transferred to an account or the like.

(3) Details of the processing of the embodiment [0012] The present embodiment will be explained in detail below.

(3.1) Electronic slip record (3.1.1
) Structure of electronic slip record The record structure of the electronic slip record used in this embodiment will be explained with reference to FIG. The electronic slip record is composed of a KEY item, a slip issuing department information item, a slip history information item, and an application information item. Further, the application information items include a slip common information item and a journal information item. The KEY item is a keyword item for document search, and is an electronic document data management NO. , accounting date, slip issuer job number, etc. are stored. The invoice issuing department information item includes the office code,
Stores the department code, job number of the person in charge of issuing slips, etc. Slip history information items include payment location classification, payment route count,
History information counts etc. are stored. Slip common information items are information items that accompany the slip, and are attached to the attached card O/
P classification, accounting date, transfer no. etc. are stored. Journal information items are information items that accompany journalized credit/debit subject units, and include credit/debit classifications, summaries, and subject codes.

(3.1.2) Electronic slip record access processing Next, the electronic slip record access processing will be explained. Electronic voucher records created by input processing are
Database 12 of computer department 10 through batch processing
Until it is registered in , it is stored in each workstation as an electronic slip file 50. From this electronic slip file 50, electronic slip records are frequently accessed for approval and payment processing. Therefore, in this embodiment, in order to improve the speed of this access process, a super descriptor, which is a search index, is used to manage all electronic slip records stored in each workstation as an electronic slip file 50. There is. A conceptual diagram of management using super descriptors is shown in FIG. In this example, five superdescriptors (KZ,
KY, KX, KW, KV). When a new electronic slip record is created, corresponding search data is added to the superdescriptor. This additional processing is performed in real time, and sorting processing is also performed at the same time. Each search data of the super descriptor includes a hard index of electronic slip records. Therefore, by referring to this index, electronic slip records can be quickly searched from the super descriptor.

The structure of such a superdescriptor is shown in FIGS. 4 to 8. These structural diagrams are simple, so
The index of the electronic slip record mentioned above is omitted. FIG. 4 is a conceptual diagram showing the structure of superdescriptor KZ. Super descriptor KZ is a search index for record registration. This search index is used for all data additions, data updates, and data deletions to electronic slip records. Figure 5 shows super descriptor K
FIG. 2 is a conceptual diagram showing the structure of Y. The super descriptor KY is an index for searching target data when inputting approval/payment (no attached card). Persons in charge of approval and payment processing can search for target data by slip ID. Further, approval/payment input is possible only when the screen input person's job number is registered on the payment route table. To update search data after approval/payment input,
A superdescriptor KZ is used. FIG. 6 is a conceptual diagram showing the structure of superdescriptor KX. The super descriptor KX is a search index used when searching for general account information by account item. Search for the applicable data in the account summary, search for the next electronic slip record, add or subtract the amount for the applicable item from the settler's slip, and display the amount. FIG. 7 is a conceptual diagram showing the structure of superdescriptor KW. Super descriptor KW is
This is an index for searching issued electronic slip records. This search index, instead of keeping copies of slips in each department,
This is an index for searching for slips issued by your department. If you do not know the electronic slip management number, use this search index to search. FIG. 8 is a conceptual diagram showing the structure of superdescriptor KV. The super descriptor KV is an index for searching unprocessed registered data. It is mainly used in the accounting department and product department. FIG. 9 shows a list of actual processes in which the super descriptors described above are used. From Figure 9, super descriptor KZ is used for all search processing when issuing a slip, and for approval/settlement processing and search data output processing,
It can be seen that other superdescriptors are used.

In this embodiment, the highest search efficiency is achieved by adjusting the number of superdescriptors and the structure of each superdescriptor. Therefore, the number of super descriptors should be 4 or less,
Alternatively, even if there are six or more superdescriptors, or even if the structure of each superdescriptor is changed, the search efficiency will be lower than it is now.

(3.1.3) Management of electronic slip records Next, management of electronic slip records will be explained. Management of electronic slip records in this embodiment is performed using status information provided in a desired area of each electronic slip record. Details of this status information are shown in FIG. The status information is composed of four categories of data. Among these, the stage column records the status of the electronic slip record as to which stage the processing has been completed. Further, in the rejection classification column, it is recorded whether the slip has been approved or rejected. FIG. 11 shows how this status information changes depending on the processing at each stage. As an example, to explain the change in status information during the approval process, the status information of an electronic slip record that has not yet been approved is "3100".
It shows. If you enter approval (approval) here,
The status information changes to "4100". Further, in the case of a rejection input, the status information changes to "2900". Furthermore, it was discovered that there was an error in the input of the approval.
When you input the approval cancellation, the status information will be “4100”.
” to “2900”. On the other hand, if it is found that there is an error in the rejection input and you input the rejection cancellation, the status information changes from "2900" to "4100".
”. Status information changes similarly in processing at other stages. This status information allows the processing level of each electronic slip record to be grasped. Furthermore, since the master table 51 holds processing route information that describes the processing route of each electronic slip record, each electronic slip record can be comprehensively managed by using the status information and this processing route information.

(3.2) Input Processing Next, the input processing will be explained using FIGS. 12 to 24. FIG. 12 is a conceptual diagram showing an overview of input processing. first,
When the workstation 21 is powered on, the top screen 101 is first displayed. On this top screen 101, operator information can be input and a procedure input screen can be selected. The information to be input as handler information includes office code, department number, employee number, etc. By inputting operator information at this stage, it is possible to reduce the number of times the master is referenced for each input screen. Further, the office code can be automatically set by determining which office the workstation 21 is installed in. The procedure input screen includes a slip creation screen, approval screen, inquiry screen, etc., and allows selective input using a menu format. Here, when the slip creation screen is selected, a procedure input screen 102 for creating a slip is displayed. On the procedure input screen 102, a required slip can be selected from a menu of slips classified according to transaction details. This selection process determines the type of slip to be created. Once the type of slip is determined, an item input screen 103 corresponding to the type of slip is displayed. Then, according to the instructions on this item input screen 103, data is input into the necessary items as slip data.

As specific examples of the item input screen 103, examples of domestic business trip application input are shown in FIGS. 13 to 16, and examples of domestic business trip settlement input are shown in FIGS. 17 to 24.

First, an example of inputting a domestic business trip application will be explained. First, the processing category, department number, employee number, application date, and business trip date are each input (see FIG. 13). If you enter a value other than 1, 3, or 4 for the processing category, an error will occur. Further, the department number and employee number are compared with the data registered in the master table 51 described above, and the following input process can be continued only when the department number and employee number are correct. Next, input is made as to whether or not accommodation fees will be charged and whether or not coupon tickets will be used (see FIG. 14). Regarding billing for accommodation charges, in most cases, 1 (accommodation that can be billed) is input, so 1 is displayed in advance. Therefore, the input of item 1 can be omitted, and it is only necessary to input item 2 (accommodation that cannot be billed). There are two types of coupons that can be claimed here: those for airplanes and those for Shinkansen. If the user inputs on this screen that he/she will use a coupon ticket, a screen for further inputting detailed data is displayed (see FIG. 15). In this example, there are two input fields, and two types of coupons can be requested at the same time. Input items include the type of vehicle for which the coupon is used, the usage form of the coupon, and the name of the business destination for which the coupon is used. Next, input the approximate amount of transportation expenses other than the coupon ticket and whether or not advance payment is required (see FIG. 16). The approximate amount of transportation expenses must be entered in units of 1,000 yen. In the advance payment column, enter 1 if no advance payment is required, or enter blank if an advance payment is required. Any other input will result in an error. The advance payment here refers to daily allowance, accommodation expenses, and approximate transportation expenses. After entering all input items, enter "E". By making this input, the domestic business trip application input process is completed.

Next, an example of inputting payment for a domestic business trip will be explained. First, the processing category, department number, and employee number are each input (see FIG. 17). By this input, the data of the scheduled settlement date, prepayment amount, and prepayment application date of the principal's unpaid overpayment slip are displayed (see FIG. 18). The data displayed here is the data that was input during the domestic business trip application input process and the electronic slip record was registered. From this display, select and enter the number of the application slip you wish to settle. The maximum number of items that can be displayed here is two. Furthermore, since up to eight unpaid slips can be registered, the number of application slips that can be selected is from 1 to 8. Select 9 if you want to settle a bill that you have not applied for. Next, enter the purpose of payment and the date of payment (see Figure 19). For the purpose of payment, enter whether it is payment after a business trip or payment due to cancellation of a business trip. In addition, since the scheduled business trip schedule is automatically displayed, if the business trip schedule changes, the schedule can be changed. Here, if the departure date, return date, and settlement date are not arranged in chronological order, it is detected as an error. Furthermore, the departure date, departure station, return date, and return station are entered as operation performance data, and a number within 6 digits is entered as the reimbursement transportation fee (see FIG. 20). After all items have been entered in this manner, the execution key is pressed (see FIG. 21). With this key input, the final check of the input contents of each item is performed on the master table 51.
This is done using data registered in . If there are no problems with this check, a new screen will be displayed (Figure 22
reference). First, input is made as to whether or not there are any remaining coupons (see FIG. 23). If you enter 2 (there are tickets left over) here, a list of the ticket numbers that have actually been handed out will be displayed. From this list, enter the number of the remaining coupon. Also, since the dates of the business trip excluding the return date are displayed, the accommodation category and holiday category are input as the accommodation record. Any input to these categories other than 1 to 3 will result in an error. Additionally, enter whether or not lunch at the business trip will be covered by the company. If you are eating at a company cafeteria on a business trip, enter 1 (not provided by the company). When all the above input operations are completed, the number of days of daily allowance, daily allowance amount, accommodation fee, settlement expense amount, advance payment amount, and settlement amount are displayed (see FIG. 24). If you have confirmed that these amounts are correct, enter "E". With this input, the domestic business trip payment input process ends.

By the way, this input processing has three functions: an input monitoring function, an automatic setting function, and an account item setting function. First, the input monitoring function is a function that monitors whether all items have been input. This input monitoring function has an input comparison function and an input promotion function. The input comparison function is a function for checking uninputted items by comparing the inputted items and the required inputted items. To realize this function, required input item data to be compared is required, and in order to obtain this required input item data, for example, a slip type item table in which required input item data is stored is used. In addition, the input prompt function is
This is a function that prompts users to input items that have not yet been entered. Specifically, for example, it is a function that causes unentered items to blink or sounds a buzzer to encourage input. Next, the automatic setting function refers to a function that automatically sets slip data for some items. This automatic setting function has a business office code setting function and an analogy setting function. The office code setting function determines the office that started the process from the unique number that started the process on the workstation 21 to create an electronic slip record, and automatically sets the corresponding office code. It is a function. Further, the analogy setting function is a function that automatically sets data of some uninput items by analogy with data of already input items. There are two ways to implement this function: one is to use an analogy table that corresponds to the input data, and the other is to calculate the input data to obtain data for uninput items. Furthermore, the account item setting function refers to a function that sets one item of account item based on a specific event that occurs. A specific event may be a single event or a combination of multiple events. With this account setting function, account items such as travel expenses, consumables expenses, book expenses, etc. are set in the electronic slip record. A specific example of this account item setting function will be described later.

Through such input processing, the slip data input from the workstation 21 is inspected to see if it is correct data. This inspection process includes
It has four functions: an input possibility check function, an item attribute check function, an item range check function, and an inter-item comparison check function. First, the input possibility check function is a function that compares input data with input possibility determination data registered in the master table 51.
This is a function that checks whether the data can be input. Next, the item attribute checking function is a function of comparing input data with attribute data that can be taken for each item registered in the master table 51 to check whether the input data matches the attribute of the item. The item attribute refers to characteristic information for each item, such as, for example, "Item A is an error for anything other than numbers." Furthermore, what is the item range check function?
This function compares the input data with the possible range data for each item registered in the master table 51 to check whether the data matches the possible range for that item. The item range refers to permissible value information for each item, such as, for example, "Anything other than 1, 2, or 3 is an error for item A." In addition, the inter-item comparison check function checks whether the relationship between the items of the input data is correct or incorrect by comparing the input data with the correlation data between the items registered in the master table 51. Refers to function. The relationship between items refers to a certain relationship between items, such as, for example, "If item A is 1, it is correct if item B is 3 or 4." Data on the correlation between items registered in this master table 51 is stored in the slip type.
Efforts are being made to improve access efficiency.

[0024] Through the above inspection process, it has been found that the inputted slip data is correct data, so a slip management number is set in the created electronic slip record. The slip control number is an abbreviated code (slip I
D/month) is used, but the corresponding official code (office/month/day/slip ID) is set on the electronic slip record. This numbering process is also equipped with the latest number generation function. The latest number generation function is a function that generates the latest slip management number in response to a request from the workstation 21, and is realized using the latest number data registered in the master table 51. The latest number data registered in this master table 51 is stored by type of slip or month of occurrence of the slip, thereby improving access efficiency and facilitating number identification for users.

(3.3) Approval/Payment Processing Next, approval/payment processing will be explained using FIGS. 25 to 28. Figure 25
is a flowchart showing the flow of approval/payment processing. As explained in the input process, when a person in charge of the sales department creates an electronic slip record using the workstation 21, this electronic slip record is added to the electronic slip file 50 as an unprocessed slip (step 201). The manager of the sales department displays a list of unprocessed slips on the workstation 21 once a day in order to approve the unprocessed slips issued by his own department that he can approve. This list is created by selecting electronic slip records whose status information indicates the level before approval processing from among the electronic slip records registered in the electronic slip file 50. Then, from this list, the user extracts the electronic slip record that he/she must approve, and further operates the workstation 21 to display detailed information of the extracted electronic slip record on the screen. What is displayed as detailed information is information such as summary, content, subject, amount, and handler. If it is determined that this electronic slip record can be approved, the department manager inputs approval (step 202). Furthermore, if the electronic slip record contains incomplete information and cannot be approved, the status information is returned to a level that prompts the person in charge who issued the slip to make corrections. If the electronic slip record is not approved, the person in charge corrects the incomplete description (step 203). In this way, the status information of the electronic slip record whose contents have been corrected is changed to a level that allows payment by the accounting department or the general affairs department by the approval input from the department manager. The person in charge of the accounting department or the general affairs department, like the manager of the sales department, can send a list of unprocessed documents to the workstation 31.
to display detailed information on unprocessed slips. If it is determined that the payment can be made based on this display, the person in charge of the accounting department or the prime minister's department inputs the payment and changes the status information to a level that can be processed in the daily batch. Among these unprocessed slips, for those slips that can be settled, payment input is performed (steps 204 and 205). Here, if there is a problem with the electronic slip record and payment cannot be made, the status information is returned to a level that prompts the person in charge who issued the slip to input deletion. The person in charge deletes this electronic slip record using the following procedure (step 206). By using a function that displays a list of the current status of the invoices that they have issued, the person in charge can know that the invoices that they have issued have reached the level of rejected payment. Next, the details are displayed on the screen by using the function to search the electronic slip record to view the details. The electronic slip record search function allows searches using the slip number, slip creator employee number, slip type, etc. as search keys. As a result, the person in charge will know which application has been rejected for payment, and will activate the input function for that application and perform deletion processing. In the process, after confirming the contents again, the person in charge enters his or her personal password to confirm that he or she is the person in charge in the master table 51, and then writes a flag indicating deletion in a specific area of the electronic slip record and the date of deletion. Write. At this level, the electronic slip record is not actually deleted yet, but is treated as deleted by setting a flag. After deleting the electronic slip record in this way,
The workstation 21 is used to reissue the electronic slip record in which the problem has been corrected.

Examples of specific screens for approval processing are shown in FIGS. 26 to 28. First, the processing category, department number, and approver job number are input (see FIG. 26). If you enter a value other than 1 to 3 for the processing category, an error will occur. The department number and approver job number are compared with the data registered in the master table 51, and if the department number and employee number are correct, a list of data necessary for approval is displayed (Figure 27
reference). Select a slip for approval processing from this list and enter the number of that slip. Detailed data of the electronic slip record selected by this input is displayed (see FIG. 28). The detailed data is data such as summary, contents, and account items registered in the electronic slip record. Refer to these detailed data and enter whether or not to approve. After the approval processing for that slip is completed, input whether or not to continue the approval processing for another slip. If you enter "E" here and then enter your password, the approval process will be completed.

(3.4) Approval/Payment Processing Requiring a Receipt Next, the approval/payment processing requiring a receipt is shown in FIGS. 29 to 35. FIG. 29 is a conceptual diagram of approval/payment processing that requires a receipt. A receipt 23 is issued when a person in charge of the sales department uses a taxi or provides entertainment. The person in charge uses the workstation 21 to create an electronic slip record in order to settle expenses incurred for entertainment and the like. Based on the type of slip, the system determines that it is necessary to attach a receipt to this electronic slip record, and the attached card 24 is automatically printed out from the printer device 22. This attached card 24 has a pasting section 25 for pasting a receipt, a slip number section 26 in which the slip number of the electronic slip record is written, and a signature entry section 27 that is a field for entering a signature for approval and payment. , and a detailed slip data section (not shown). Additionally, information on the approval route is read out from the approval/settlement table stored in the master table 51, and the attached card 24 is loaded with information on the approval route.
4 can also be printed. The person in charge should refer to this attached card 2.
4, the receipt 23 is pasted on the pasting section 25 of the attached card 24, a signature of the department manager's approval is written on the signature entry section 27 of the attached card 24, and the card is transferred to the payment department. In the payment department, the slip number section 26 of the attached card 24 to be paid is read using a hand scanner 32. Then, payment processing is performed for the electronic slip record corresponding to the read slip number. The payment process itself is the same as the payment process without a receipt described above. Electronic voucher records settled in this way are
Electronic slip file 5 as a settled electronic slip record
Registered as 0.

[0028] Here, specific examples of screens for the slip creation process accompanied by the output of the attached card 24 are shown in FIGS. 30 to 35. First, the processing category, department number, input person's job number, advance person's job number, deposit/disbursement category, cash settlement date, and deposit/withdrawal destination are respectively input (see FIG. 30). If you enter a value other than 1 or 3 for the processing category, an error will occur. In addition, the deposit and withdrawal classification is 1 (deposit).
or 2 (withdrawal). The input substitute job number is compared with the personnel data registered in the master table 51, and if it is not registered in the personnel data, an error occurs. Next, a list of abstract codes is displayed, and the corresponding code number is input from this list (see FIG. 31). In this case, if you enter a code that is not displayed, an error will occur. However, if the corresponding abstract is not in the master table 51, 999 is input, and then the abstract is input. Similarly, a list of content codes is also displayed, from which the number of the corresponding code is input (see FIG. 32). In this case as well, if you enter a code that is not displayed, an error will occur. However, if the corresponding content sentence is not in the master table 51, 999 is input, followed by the content sentence. After these inputs, the account code and journal entries are automatically set by the account setting function described above and displayed on the workstation 21. Specifically, the following processing is performed. First, if the summary content input in the preprocessing is not 999, the subject master in the master table 51 is referred to, and the journal entries registered in the subject master are automatically set and displayed on the workstation 21. In addition, if the summary content entered in preprocessing is 999, you can directly input the account code, and if the entered account code is registered in the account master, the journal entry will be automatically set and the work displayed on station 21. next,
Enter a number within 8 digits as the payment amount (see Figure 33). The maximum amount that can be claimed is 99,999,999 yen. Then, input the expense plan number and consumption tax classification (see FIG. 34), and if the above inputs are correct, input "E" to end the process (see FIG. 35). Here, if there is a plurality of settlement data for the same deposit/withdrawal destination, or if you wish to perform different accounting processes, you can input "C" and repeat the process. The number of times this can be repeated is up to three times. And when the process is finished,
The attached card 24 is automatically output from the printer device 22.

(3.5) Accounting Process Next, the accounting process will be explained using FIG. 36. Electronic slip records created using the workstation 21 are stored in each workstation as an electronic slip file 50 until batch processing, even if the status information is at a level that allows daily batch processing. These electronic slip records are normally stored in the database 12 of the computer department 10 by batch transfer processing once a day, but electronic slip records that require accounting processing are copied and processed separately. In other words, among the electronic slip records that have been settled, documents that require accounting processing such as business trip application/settlement, advance payment application/settlement, and cash settlement are extracted and copied by the CPU before being batch transferred. It is. The electronic slip record thus copied is stored as a transmission data file 52, and serves as data for the accounting process performed by the financial institution 60. This extraction/copying process is completed, for example, once a day in the evening, and data for that day is transferred to the financial institution 60 via the line 53. The financial institution 60 performs processing based on the data of the transferred electronic slip record. For example, in the case of payment of business trip expenses, the financial institution 60 transfers the slip from the corporate account 61 to the personal account 62 of the employee who issued the slip.
Travel expenses and business allowances will be transferred and withdrawn. The results of this processing are sent back to the transmission data file 52 over line 54. The data in the transmission data file 52 and the processing results can be checked using the workstations 55 installed in each department. If the transfer process to the personal account 52 is successfully performed, the transferred cash can be withdrawn from a general ATM machine 63 (financial automation device) installed in or around the company.

(3.6) Batch Processing Next, batch processing will be explained using the flowchart shown in FIG. The electronic slip record created as the electronic slip file 50 using the workstation 21 is
Even if the status information is at a level that can be processed in daily batch after being approved by the supervisor and settled by the accounting department, it is stored in each workstation as an electronic slip file 50 until batch processing (
Steps 301, 302). Among these electronic slip records, the CPU extracts settled electronic slip records or electronic slip records that should be deleted for reissue (step 303). This extraction is performed, for example, once a day. Electronic slip records not extracted in this extraction process are reorganized within the electronic slip file 50 (step 304). Also, it is checked whether there is an electronic slip record to be deleted among the extracted electronic slip records (step 305), and if there is an electronic slip record to be deleted, the electronic slip record is deleted from the electronic slip file 50. It is extracted, stored for one month, and then deleted (step 307). The remaining electronic slip records are transferred to the database 12 of the computer department 10 by batch processing, and the database 12 is updated (step 3).
06). The updating process of the database 12 performed in step 306 will be explained using FIG. 38. As shown in FIG. 38, in this embodiment, a database for four days is stored. Therefore, the database up to four days ago can be restored. Multiple member files are stored in the database for one day, and each member file is a collection of data classified by purpose, such as aggregation by department or aggregation by subject code. therefore,
Duplicate data may be stored depending on the member file. By selecting an optimal member file from this group of member files, necessary data can be accessed.

(3.7) Processing using master table Next, processing using master table 51 will be described. FIG. 39 is a configuration diagram of the master table 51. The master table 51 contains subject masters, department masters,
It consists of dozens of types of master files, including summary master files. These master files can be increased or decreased as necessary. To explain some of these master files, first, the subject master has attributes,
It manages basic information such as names and consumption tax check classifications, as well as output management of general accounts, financial statements, etc. The department master also manages payment locations, quasi-accounting units, confirmation of document generation, etc. Furthermore, the summary master is configured and managed so that the journal entry on the slip can be automatically entered by the inputter simply by selecting and inputting his or her department code and the details of the event that occurred from among the options. These master files are
For example, in input processing, it is used for processing to determine whether input data is correct, processing to display a list of input data, processing to automatically set input data, etc. A department master, a personnel master, etc. are used in the process of determining whether input data is correct, and the data registered in these master files is used for determination. Further, in the process of displaying a list of input data, a summary master, a ticket, a coupon table, etc. are used, and the data registered in these master files is displayed as a list. Further, in the process of automatically setting input data, an accounting date table, a consumption tax rate table, etc. are used, and the input data is automatically set based on the data registered in these master files. In particular, the consumption tax rate table shows the correct consumption tax category (3% or 6%) for each event.
%) and the amount including tax will be automatically set. Further, the security table is used, for example, to check who is qualified for confidential processing.

[0032]

According to the paperless accounting system of the present invention, electronic slips stored in the electronic slip storage device are read out using electronic slip access means. Also,
The consistency of the electronic slips stored in the electronic slip storage device is determined by the master data determining means.

[0033] Therefore, electronic slips can be read out at high speed. Furthermore, since the consistency of input data is determined when entering electronic slip creation/addition processing, even if incorrect data is entered, it can be corrected on the spot.

[Brief explanation of the drawing]

FIG. 1 is a configuration diagram of a paperless accounting system according to an embodiment.

FIG. 2 is a conceptual diagram showing the record structure of an electronic slip record.

FIG. 3 is a conceptual diagram of slip management using super descriptors.

FIG. 4 is a conceptual diagram showing the structure of a superdescriptor.

FIG. 5 is a conceptual diagram showing the structure of a superdescriptor.

FIG. 6 is a conceptual diagram showing the structure of a superdescriptor.

FIG. 7 is a conceptual diagram showing the structure of a superdescriptor.

FIG. 8 is a conceptual diagram showing the structure of a superdescriptor.

FIG. 9 is a conceptual diagram showing the configuration of a super descriptor in a processing mode.

FIG. 10 is a conceptual diagram showing the contents of status information.

FIG. 11 is a conceptual diagram showing management based on status information.

FIG. 12 is a conceptual diagram showing input processing in this embodiment.

FIG. 13 is a conceptual diagram showing an example of a screen during input processing in this embodiment.

FIG. 14 is a conceptual diagram showing an example of a screen during input processing in this embodiment.

FIG. 15 is a conceptual diagram showing an example of a screen during input processing in this embodiment.

FIG. 16 is a conceptual diagram showing an example of a screen in input processing of this embodiment.

FIG. 17 is a conceptual diagram showing an example of a screen during input processing in this embodiment.

FIG. 18 is a conceptual diagram showing an example of a screen in input processing of this embodiment.

FIG. 19 is a conceptual diagram showing an example of a screen in input processing of this embodiment.

FIG. 20 is a conceptual diagram showing an example of a screen during input processing in this embodiment.

FIG. 21 is a conceptual diagram showing an example of a screen in input processing of this embodiment.

FIG. 22 is a conceptual diagram showing an example of a screen during input processing in this embodiment.

FIG. 23 is a conceptual diagram showing an example of a screen in input processing of this embodiment.

FIG. 24 is a conceptual diagram showing an example of a screen in input processing of this embodiment.

FIG. 25 is a flow diagram showing approval/payment processing in this embodiment.

FIG. 26 is a conceptual diagram showing an example of a screen in the approval process of this embodiment.

FIG. 27 is a conceptual diagram showing an example of a screen in the approval process of this embodiment.

FIG. 28 is a conceptual diagram showing an example of a screen in the approval process of this embodiment.

FIG. 29 is a conceptual diagram showing approval/payment processing using a receipt according to the present embodiment.

FIG. 30 is a conceptual diagram showing an example of a screen in the slip creation process of this embodiment.

FIG. 31 is a conceptual diagram showing an example of a screen in the slip creation process of this embodiment.

FIG. 32 is a conceptual diagram showing an example of a screen in the slip creation process of this embodiment.

FIG. 33 is a conceptual diagram showing an example of a screen in the slip creation process of this embodiment.

FIG. 34 is a conceptual diagram showing an example of a screen in the slip creation process of this embodiment.

FIG. 35 is a conceptual diagram showing an example of a screen in the slip creation process of this embodiment.

FIG. 36 is a conceptual diagram showing the accounting process of this embodiment.

FIG. 37 is a flow diagram showing batch processing in this embodiment.

FIG. 38 is a conceptual diagram showing the configuration of a database.

FIG. 39 is a conceptual diagram showing the configuration of a master table.

[Explanation of symbols]

1…Paperless accounting system 10...Computer section 11...Workstation 12...Database 20…Sales department 21...Workstation 22...Printer device 24... Attached card 30…General affairs department 31...Workstation 32...Image scanner 40...Local area network 50...Electronic slip file 51...Master table 52...Transmission data file 60...Financial institution

Claims (10)

[Claims] Claim 1: A paperless accounting system in which an accounting information database is built on a distributed processing system connecting a plurality of computers and computer equipment, comprising an electronic voucher creation means for creating electronic vouchers and storing them in a distributed file system, and a distributed file system. additional processing means for adding data to electronic slips stored in the system; processing management means for managing the processing status of the electronic slips in the electronic slip creation means and the additional processing means; and a plurality of keys for the electronic slips. 1. A paperless accounting system comprising: an electronic voucher access means for accessing electronic vouchers stored in a distributed file system using an index that combines items. [Claim 2] The index of the electronic slip access means includes the code number, accounting year and month of the office currently processing, the electronic slip ID number and management number, and the code number of the office that will perform the next processing. 2. The paperless accounting system according to claim 1, further comprising: a department code number and a department code number. 3. The index of the electronic slip access means includes the code number of the office currently processing, the accounting year and month, the electronic slip ID number, the current status of the electronic slip, and the next processing step. 3. The paperless accounting system according to claim 1, further comprising a code number of a business establishment and a department code number. 4. The index of the electronic slip access means includes an index consisting of the accounting year and month, the subject code number, the code number of the electronic slip creation department, and the current status of the electronic slip. A paperless accounting system according to any one of claims 1 to 3. [Claim 5] The index of the electronic slip access means includes the job number of the slip originator, the slip creation date, the code number of the electronic slip creation department, the electronic slip ID number, and the subject code number. 5. The paperless accounting system according to claim 1, further comprising: a. 6. The index of the electronic slip access means includes the job number of the slip originator, the code number of the electronic slip creation department, the department code number of the billing/transfer destination, and the current status of the electronic slip and the electronic slip. 6. The paperless accounting system according to claim 1, further comprising an ID number. 7. A paperless accounting system in which an accounting information database is constructed in a distributed processing system connecting a plurality of computers and computer equipment, comprising an electronic voucher creation means for creating an electronic voucher and storing it in a distributed file system, and a distributed file system. additional processing means for adding data to electronic slips stored in the system; a master table device provided in the computer system; and the electronic slip creation means based on basic data registered in the master table device. or master data determining means for determining the consistency of electronic slips using the additional processing means. 8. The paperless accounting system according to claim 7, wherein the basic data registered in the master table includes data on occurrences. 9. The paperless accounting system according to claim 7, wherein the basic data registered in the master table includes personnel data of all employees. 10. The paperless accounting system according to claim 7, wherein the basic data registered in the master table includes password data.