JP2002007948A - Automatic journalizing system for account software - Google Patents

Abstract

PROBLEM TO BE SOLVED: To further improve a currently commercially available account software because a knowledge concerning the principle of journalization by double- entry bookkeeping in account is basically still required for the rationalization of accounting work by the software, so that the software cannot be sufficiently managed in general. SOLUTION: The file of a journalization master is read by use of the function of the account software on a personal computer, prescribed items caused by a transaction, which include date, assigned company code, prescribed journalization code and amount of money, are entered in a document type means having entry selective columns for entering the prescribed items in Arabic numerals. The prescribed items entered in the document type means are converted into a prescribed primary digital file, the primary digital file is converted into a second digital file corresponding to the account software in reference to the journalization master, and the secondary digital file is read in the account software to form an accounting journalization data.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an automatic journalizing system for accounting software, and more particularly, to an automatic journaling system for accounting software that can automatically journal externally provided transaction data when using accounting software. It relates to a journal entry system.

[0002]

2. Description of the Related Art Conventionally, a voucher used in a business transaction has been posted on a ledger and managed by a professional accountant in accordance with a predetermined accounting procedure. In recent years, however, various kinds of accounting software have become commercially available, and accounting affairs have been streamlined and made simpler and faster.

[0003]

However, these accounting softwares also basically require knowledge of the principle of journal entry by double entry bookkeeping in accounting, and generally cannot be fully used. Improvements were awaited.

[0004] Under the circumstances described above, the present invention is a general business operator that records the results of daily transactions in a simple manner, while the accounting software of a personal computer owned by an accounting expert automatically records the results. It is an object of the present invention to provide an automatic journalizing system for accounting software in which accounting software automatically reads and creates accounting journal data by creating the accounting journal data in a form that can be received.

[0005]

In order to achieve the above object, an automatic journalizing system for accounting software according to the present invention uses a function of accounting software on a personal computer to import a journal master file. Fill out the prescribed items with Arabic numerals in the form format having entry selection fields for entering the prescribed items generated in the transaction including the company code, the prescribed journal code and the amount, respectively, which are assigned the date and the date. The predetermined items entered in the means are converted into a predetermined primary digital file, and the primary digital file is referred to the journal master to correspond to the accounting software.
The gist of the present invention is to convert the next digital file, take the secondary digital file into the accounting software, and create accounting journal data.

Preferably, the slip means includes a handwritten slip form.

Further, in order to achieve the object of the present invention, the automatic accounting software for accounting software according to the present invention fetches a journal master file using a function of the accounting software on a personal computer, as a means for each. Fill out the prescribed items in digital form using Arabic numerals in a digital file voucher format having an entry selection field to enter the prescribed items generated in the transaction including the date, the assigned company code, the prescribed journal code and the amount. To generate a primary digital file, convert the primary digital file into a secondary digital file corresponding to the accounting software with reference to the journal master, and import the secondary digital file into the accounting software to create accounting journal data The point is to do.

[0008] The slip form means includes a digital file stored in an area established for each user on a WWW server, the primary digital file includes a CSV file, and the journal master includes an automatic journal code master and a department code. It is desirable to include a master file, a subject code master file, and a supplementary subject master file.

[0009]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of an automatic journalizing system for accounting software according to the present invention will be described below with reference to the drawings.

In FIG. 1, reference numeral 1 denotes a means for transmitting predetermined items described in a slip from a client to an accounting processing center, 11 denotes mail, 12 denotes a fax, 13 denotes a personal computer, and 14 denotes a mobile phone. Reference numeral 2 denotes a commercially available accounting software typified by accounting software PCA (registered trademark) / OBC, etc. possessed by the accounting processing data side.
(Registered trademark), Linux, etc.

Then, after operating the accounting software 2 and selecting a company to be processed from the client information stored therein, a "master registration confirmation" function is used as shown in FIGS. 2 and 3. The journal masters, ie, “company basic information list”, “account item list”, “auxiliary item list”, and “automatic journal list” are stored in a file format under a data conversion processing program, ie, in the C drive of the personal computer 13. Into the henkan folder in the Wr_hand folder.

FIG. 4 shows WINDOWS showing the status of journal masters imported under the data conversion processing program.
It is a screen of. The automatic journal code list among the journal masters imported into the henkan folder in the screen is shown in Fig. 5.
As shown in the table, journal patterns are set for each code such as 0101 (cash sales) and 0102 (account sales).

Further, the company basic information list has the contents as shown in the screen of FIG. 6 and includes a method of calculating a consumption tax and a method of fraction processing. In addition, the contents of the account item list include codes and names for each item as shown in the screen of FIG. Then, as shown in the screen of FIG. 8, the categories of the consumption tax are listed.

Next, FIG. 9 shows a slip format (OCR easy slip) used by the client in the present invention.
The central part and the right side thereof are the entry fields for the client, which are formed of a date entry field, a company code entry field, a journal code entry field, and an amount entry field, respectively. On the left is a reference column for the journal code, which is composed of a list of journal codes and cash deposit application for each of credit and debit accounts.

[0015] The client enters the date of the transaction, the date assigned, the assigned company code, and the amount of each transaction in a predetermined column with handwritten Arabic numerals and refers to the corresponding journal code in the reference column. It is also laid out to be filled in with Arabic numerals by hand.

For example, in FIG. 9, a client whose assigned company code is 12-3456 is assigned on March 1, 2000.
When cash sales of 10 yen per day occur, each item is entered in the corresponding column as shown. Then, the automatic journal code 0101 of cash sales printed in the reference column is entered in the journal coat column.

Then, the client transmits the information described in the slip form to the accounting office by mail or fax. When sent by mail or fax, the accounting information received by the accounting center is an optical reader (OC
After the digital information is converted by R), digital processing described later is performed.

The procedure of the automatic journalizing system of the present invention configured as described above will be described with reference to the flowchart of FIG. 10. First, in step S1, the journal master, that is, the "automatic journal code master" , "Departmental code master", "Subject code master", and "Auxiliary subject master" are taken into the henkan folder of the Wr_hand folder of the C drive by the data conversion processing program stored in the arithmetic unit of the personal computer.

On the other hand, the client sends the information described in the slip form (OCR easy slip) shown in FIG.
CR) Convert to digital data code with software and convert to primary CS
Create a V file. (Step S2)

Then, in the accounting processing center, as shown in FIG. 4, the data is stored in the henkan folder of the C drive based on the automatic journal code fixedly assigned to the slip by the conversion program of the accounting software in the arithmetic unit of the personal computer. Search the automatic journal list. Then, from the matched automatic journal codes, the department code (loan), the subject name (loan),
Acquire the supplementary subject name (loan) and tax category (loan) summary.

The acquired subject name is obtained from the account subject list.
For the names of the supplementary subjects, the corresponding codes are individually obtained from the supplementary subject list. And the acquired department code, subject code,
Set the sub-item code, tax category and appropriateness in the corresponding items of the journal data. In this case, the amount is the amount entered in the slip form. The consumption tax is calculated by a customization program, and is calculated and set by a data conversion processing program with reference to the company basic information list, account list, and tax classification list.

The result is stored on the hard disk in the form of a secondary CSV file. (Step S4) Further,
The secondary CSV file is imported by using the function of accounting software. (Step S5) The accounting software outputs accounting journal data from the personal computer. (Step S
6)

Next, another embodiment of the automatic journalizing system of the present invention is shown in FIG. In this embodiment, each step is substantially common to the embodiment of FIG. That is, steps S21, S23, S24, S25, and S26 are exactly the same as steps S1, S2, S3, S4, S5, and S6 in FIG. 10, but in step S22, the slip format is sent by fax software instead of mail, and OCR processing is performed. The data is converted into a digital data code to generate a primary CSV file.

Further, in both the embodiments shown in FIGS. 10 and 11, the screens when the OCR recognition and the conversion into the digital data codes are performed in steps S4 and S24 are shown in FIG. Typed by code. At this time, although not shown, a mistake in the total amount of money and a mistake in the date are automatically checked.

Then, in step S2 or step 22, the digital data code is generated in a primary CSV file as shown in FIG. In the primary CSV file, “00001” is a slip number, “12-3456” is a company code, “20000301” is a date, “0101” is a journal code, and “10” is a monetary amount. The numbers described in the slip form are arranged in a predetermined order. I have.

Then, in step S4 or S24,
Referring to the journal master group in which the primary CSV file has been imported by the data conversion processing program, a secondary CSV file as shown in FIG.
Generate the next CSV file. The secondary CSV file generated in this way is imported to the accounting software by clicking the button of accepting journal data on the accounting software screen of FIG. 15 in steps S5 and S25, and is entered into the accounting software and the journal format of the screen shown in FIG. Create a file for Thereafter, the accounting journal data is printed in steps S6 and S26.

Next, another embodiment will be described with reference to FIGS. 17, 18 and 19. FIG. FIG. 17 shows a state in which a digital file stored in an area established for each user, that is, for each client on the WWW server is displayed on the screen of the client PC.

In this embodiment, the client inputs only the date, journal code and amount, and the client can be specified by linking the mail address to the company code of the personal computer of the accounting center. ing. The input information has already been converted into digital data, so there is no need for conversion.

As shown in FIG. 18, steps S31 and S3
Steps S3, S34, S35, and S36 are exactly the same as steps S1, S3, S4, S5, and S6 in the embodiment shown in FIG. 10, and the step S32 is not slightly OCR-converted as in step S2. Only differences.

In the embodiment shown in FIG.
The only difference from the embodiment of FIG. 18 is that the reduced form for the i-mode is uploaded to the WW server.

[0031]

As described above, the automatic journalizing system for accounting software according to the present invention creates a primary digital file by filling in specified items including journal codes in Arabic numerals only in a designated voucher format. The next digital file was imported using the accounting software function on a personal computer, a secondary digital file corresponding to the accounting software was created in the journal entry master, and the accounting software imported to create accounting journal entry data. This eliminates the need for traditional slip processing and makes it possible for anyone who is unfamiliar with accounting to create materials that can be read by accounting software.

Since the slip format means is a manual slip format, anyone can prepare materials.

On the other hand, since the slip format means is a digital file, conversion by OCR is unnecessary and there is an advantage that no extra equipment is required.

Also, since the slip format means includes a digital file stored in an area established for each user on a WWW server, it is possible to create materials using an Internet browser on a personal computer. There is an advantage that data can be created even in the i-mode.

The primary digital file is a CSV file.
Because it includes files, you can take advantage of its excellent processing power.

Further, the journal master includes an automatic journal code master, a department code master file, an item code master file, and an auxiliary item master file, so that the journalizing operation can be efficiently performed.

[Brief description of the drawings]

FIG. 1 is a system configuration diagram showing an outline of an automatic journalizing system of the present invention.

FIG. 2 is an explanatory diagram showing a menu screen of accounting software started to take out a journal master.

FIG. 3 is an explanatory diagram showing a state in which a window for taking in a henkan folder is opened by pressing a button of a master registration confirmation list from the menu screen of FIG. 2;

FIG. 4 is an explanatory diagram illustrating a tree structure of journal master files imported under a data conversion processing program;

FIG. 5 is an explanatory diagram showing a screen of the contents of an automatic journal master list file among the journal master files imported under the data conversion program.

FIG. 6 is an explanatory diagram showing a screen of the contents of a basic information list file of a company in the same journal master file.

FIG. 7 is an explanatory diagram showing a screen of the contents of an account list file among journal entry master files taken in under the data conversion program.

FIG. 8 is an explanatory diagram showing a screen of the contents of a file in which a category of consumption tax calculation is listed.

FIG. 9 is an explanatory diagram showing a slip format (OCR easy slip) used by the client in the present invention.

FIG. 10 is a flowchart showing a procedure from OCR processing of the slip format to preparation of a journal.

FIG. 11 is a flowchart showing a procedure from OCR processing of the slip form via FAX to creation of accounting journal data.

12 is an explanatory diagram showing a screen in a state where the handwritten slip format shown in FIG. 9 is recognized by OCR and converted into character data.

FIG. 13 shows an example of the form 1 generated after the OCR conversion of the slip form.
FIG. 9 is an explanatory diagram showing a screen of a next CSV file.

FIG. 14 shows a table generated by matching the primary CSV file with each journal master file using a data conversion program.
FIG. 9 is an explanatory diagram showing a screen of a next CSV file.

FIG. 15 is an explanatory diagram showing a screen in a state where a secondary CSV file has been fetched using the function of the accounting software.

FIG. 16 is an explanatory diagram showing a screen in which a secondary CSV file is developed into an accounting journal format by accounting software.

FIG. 17 is an explanatory diagram showing a screen of a slip format saved in the form of a digital file in an area established on a WWW server.

FIG. 18 is a flowchart showing a procedure of the present invention when inputting the form shown in FIG. 17 on a Web screen.

FIG. 19 shows a Web screen reduced for i-mode on FIG.
6 is a flowchart showing a procedure of the present invention when inputting in a slip form.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Transmission means 11 Mail 12 Fax 13 Personal computer 14 Mobile phone 2 Accounting software

 ──────────────────────────────────────────────────続 き Continued on the front page (72) Inventor Yukio Makino 1-1-5-303 Kasumi, Narashino City, Chiba Prefecture (72) Inventor Keno Okamiya 4-9-15 Sugamo, Toshima-ku, Tokyo

Claims (6)

[Claims] 1. A journal entry file is fetched on a personal computer using a function of a specific commercial accounting software, and a predetermined date generated in a transaction including a company code, a predetermined journal code, and an amount assigned to the date and date, respectively. The prescribed items are written in Arabic numerals on a slip format means having an entry selection field for filling in the items, and the predetermined items written in the slip format means are converted into a predetermined primary digital file, and the primary digital file is converted. A secondary digital file corresponding to the accounting software with reference to the journal master, and the secondary digital file is taken into the accounting software to create accounting journal data. 2. The automatic journalizing system for accounting software according to claim 1, wherein said slip format means includes a handwritten slip type slip format. 3. Import the journal master file using the accounting software function on a personal computer, and fill in the specified items generated in the transaction including the date, the assigned company code, the specified journal code and the amount. Filling out the predetermined items in digital form in Arabic numerals in a digital file slip format means having an entry selection column to generate a primary digital file, and referencing the journal master to the primary digital file for the accounting software An automatic journaling system for accounting software, which converts a corresponding secondary digital file, takes the secondary digital file into the accounting software, and creates accounting journal data. 4. The automatic journalizing system for accounting software according to claim 3, wherein said slip format means includes a digital file stored in an area established for each user on a WWW server. 5. The primary digital file is a CSV file
4. A file including a file.
Automatic journalizing system for accounting software described in. 6. The accounting software according to claim 1, wherein the journal master includes an automatic journal code master, a department code master file, an item code master file, and an auxiliary item master file. Journal system.