JP2001052059A - Medium recorded with accounting support program for dental clinic - Google Patents

Abstract

PROBLEM TO BE SOLVED: To efficiently perform accountant's business in a dental clinic. SOLUTION: Plural work sheets W1,... are alternatively switched and are displayed on a display device of a computer. The work sheet W1 is provided with a treatment charge input table 1 where the charge for treatment is inputted by classifications of medical security, a reception money amount input table 2 where the amount of reception money is inputted by items, a payment money amount input table 3 where the amount of payment money is inputted by items, and a balance display table 4 where a balance is displayed. Income and expenditure in the unit of one day are recorded in these tables, and they are provided for one year on the work sheet W1 with the same constitution. The amounts of money inputted to amount columns 6, 8, and 10 are automatically summed up, and sum totals are displayed in sum total columns 7, 9, and 11 of tables 1, 2, and 3. The amount of money in the sum total column 7 in the treatment charge input table 1 is reflected on the amounts of reception money classified by security classifications in the amount column 8. Results calculation based on sum totals in tables are displayed in balance columns of the balance display table 4. Amounts of money are entered in a ledger table, monthly and yearly total tables, and a expenditure statistic table on the basis of the amounts of sum total in respective tables.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a medium recording a computer program for automatically summarizing daily, monthly or yearly income and expenditure based on one-day accounting work of a dental clinic. Things.

[0002]

2. Description of the Related Art Conventionally, accounting work at a dental clinic is performed by manually writing the names and treatment costs of treated patients individually in a book. If this work is to be automated to perform the work automatically, a dedicated computer must be set up in both hardware and software, which would be expensive for a privately run dental clinic and would be impractical. . However, in recent years, computers have been remarkably popularized with an improvement in processing capacity and a reduction in price, and obstacles to the introduction of hardware have been solved. Nevertheless, in this field, software is lagging behind, there is no program suitable for the actual accounting office, and there is a strong demand for more efficient accounting work using computers.

[0003]

SUMMARY OF THE INVENTION Accordingly, the present invention provides a dental clinic which can easily carry out accounting work using an inexpensive computer, thereby improving the efficiency of office work and facilitating data storage management. It is an object to provide a medium in which a support program is recorded.

[0004]

According to a first aspect of the present invention, a computer system having a display device and an input device is used to provide a national health insurance, a social insurance, a family of a social insurer, Enter the names of multiple treatment patients and the amount of treatment costs for each type of insurance such as insurance treatment, calculate the total amount for each day type of insurance from each amount entered, and calculate the total amount totaled for each insurance Reflect and input the income and expenditure amount of each subject, calculate the total amount and the balance amount from the input income and expenditure amount, and calculate the income, expenditure and the total amount and balance amount on a daily basis. A medium on which an accounting support program for a dental clinic was recorded was configured so as to be divided and repeatedly displayed for one year continuously on a screen of a display device. In the second invention, the display unit is made to repeatedly display the ledger element on a daily basis for one year by reflecting the total amount by insurance, the income and expenditure amount for each subject, and the balance amount. did. In the third invention, the total monthly amount for each insurance is calculated based on the total amount of medical treatment for each insurance, and the total monthly treatment amount is calculated from the total monthly amount for each insurance. The total amount of medical treatment for the whole year is calculated from the total amount, and the total amount of medical treatment for the whole year is calculated from the total amount of monthly treatment.
In the fourth invention, the total expenditure by month is calculated from the expenditure amount of each subject, and the total expenditure by year is calculated from the total expenditure by month. The total amount of monthly expenditure is calculated from the amount of money, and the total amount of annual expenditure throughout the year is calculated from the total amount of monthly expenditure, and is displayed on the display device.

[0005]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention will be described with reference to the drawings. The computer program according to the present invention is executed using a general-purpose computer system including a main body, an input device, a display device, and a print output device incorporating the computer program. A plurality of display screens are alternately displayed on the screen of the display device. For example, FIGS.
As shown in the figure, a plurality of virtual worksheets W1, W2
.. are displayed in an overlapping manner, and each worksheet W1, W2,.
The worksheet to be displayed is switched by selecting the tab with a support means such as a mouse pointer.

As shown in FIG. 1, a first worksheet W
Reference numeral 1 denotes a treatment cost input table 1 provided for each type of medical insurance applied to a treated patient, a receipt amount input table 2 for inputting a receipt amount, and an expenditure amount input table for entering a disbursement amount. 3 and a balance display table 4 for displaying the balance of the previous day and the balance of the day. In these tables, the balance of each day is recorded, and the same configuration is sequentially and repeatedly arranged below the screen of the worksheet W1 to form a basic input book for one year.

[0007] The treatment cost input table 1 is provided to be classified into four types: treatment for national health insurance, treatment for social insurance, treatment for family members of a socially insured person, and treatment for free medical care to which insurance treatment is not applied. In the treatment cost input table 1, a name column 5 for inputting a plurality of treatment patient names in a vertical direction, and a money amount column 6 for inputting treatment costs to be charged to each treatment patient, respectively.
And a total column 7 which is set in advance so that when the amounts are input in the amount column 6, the amounts are automatically totaled, and displays the total amount for each type of insurance.

In the income amount input table 2, an amount column 8 for inputting the income amount for each of a plurality of income items arranged in the vertical direction is set in advance so that the income amounts entered therein are summed up. There is provided a total column 9 for displaying the total amount. In the amount of income for each insurance in the amount of money column 8, the amount of money in the total column 7 in the treatment cost input table 1 is automatically reflected and displayed. Note that one of the bank refunds in the amount column 8 reflects the total expenditure amount in the amount input table 3 described later.

In the expenditure amount input table 3, an amount column 10 for inputting the amount of expenditure for each of a plurality of expenditure items arranged in the vertical direction is set in advance so that the total amount of expenditures entered therein is summed up. There is provided a total column 11 for displaying the total amount.

In the balance display table 4, the balance column 12
And the current day balance column 13 are displayed in two rows above and below. In the previous day balance column 12, the balance amount of the current day balance column 13 on the previous day is reflected and displayed, but for January 1, the amount is input. The balance in the day is set in advance to calculate the balance by adding the amount in the total column 9 of the income amount input table 2 to the balance amount of the previous day and subtracting the amount in the total column 11 of the expenditure amount input table 3 to the balance amount of the previous day. This amount is displayed.

As shown in FIG. 2, a second worksheet W
2, a one-day unit ledger table 14 is sequentially and repeatedly arranged at the bottom of the screen to constitute a one-year ledger. In the ledger table 14, an amount column 15 in which income and expenditure amounts are reflected and displayed from the income amount input table 2 and the expenditure amount input table 3 for each of a plurality of subjects arranged in the vertical direction,
16 is provided. At the bottom of the column next to the expenditure amount column 16, there is provided a balance display column 17 in which the balance amount of the current day balance column 13 of the balance display table 4 is displayed.

As shown in FIG. 3, a third worksheet W
3 includes a monthly / annual total table 18 in which treatment costs for each type of insurance are tabulated for each month. The monthly total / annual total table 18 has an amount column 19 for displaying a total of treatment costs for each type of insurance for each month. The money amount column 19 is set in advance so that the insurance amount of the insurance type in the money amount column 8 in the income amount input table 2 is added up throughout the month. Amount column 1
The column next to 9 is set in advance so that the total amount of treatment costs for each type of insurance for each month is added, and a total column 20 for displaying this amount is provided. The lower row of the price column 19 is provided with a total column 21 which is set in advance so that the total amount of the treatment cost for each type of insurance throughout the year is calculated, and the total amount is displayed. In the lower row of the total column 20, there is provided a total column 22 in which the total column 20 is preset so as to be totaled throughout the year, and the total amount is displayed.

As shown in FIG. 4, a fourth worksheet W
4 includes an expenditure statistics table 23 in which expenditure amounts by subject are tabulated for each month. In the expenditure statistics table 23,
It has an amount column 24 for displaying the total amount for each subject for each month. The money amount column 24 is set in advance so that the expenditure amounts in the amount column 10 in the expenditure amount input table 3 are added up throughout the month. The column next to the amount column 24 is set in advance to calculate the total for each subject for the year, and has a total column 25 for displaying the total amount. In addition, the amount column 24
Is set in advance so as to calculate the total of the monthly expenditures, and a total column 26 in which the total is displayed is provided. In the lower row of the total column 25, there is provided a total column 27 in which the total amounts of the total column 26 are set in advance so as to be totaled throughout the year, and the total amount is displayed.

In the computer in which the dental clinic accounting support program is installed, the first worksheet W1 is displayed on the display device, and the input operation is performed by the input device.
The name and the amount of money are entered in the treatment cost input table 1 according to the type of insurance for the treated patient. When the amount is input, the total amount for each type of insurance is displayed in the total column 7 and also displayed in the amount column 8 of the corresponding item in the income amount input table 2. In addition, in the income fields 8 and 10 of predetermined items in the income amount input table 2 and the expenditure amount input table 3, income,
When the expenditure amount is entered, the total column 9, 11 of each table
Automatically displays the total amount, and the balance table 4
Displays the balance.

The amounts entered or tabulated in the income input table 2 and the expenditure input table 3 are the second
Amount column 15 of the ledger table 14 of the worksheet W2,
16 and displayed. In the treatment cost input table 1, the income amount input table 2, the expenditure amount input table 3, the balance table 4, and the ledger table 14, the daily treatment amount is recorded in one table. Then, the total amount of treatment expenses for each type of insurance for the month and year is displayed in the third worksheet W3, and the total amount of expenditure for each month and year is displayed in the fourth worksheet W4. It should be noted that the third and fourth worksheets W3 and W4 may be graphed as necessary and visually checked.

[0016]

As described above, according to the present invention, accounting work at a dental clinic can be easily performed using a low-cost general-purpose computer. This has the effect of increasing the efficiency of accounting work and simplifying the storage and management of data.

[Brief description of the drawings]

FIG. 1 is a plan view of a first worksheet of a dental clinic accounting support program according to the present invention.

FIG. 2 is a plan view of a second worksheet.

FIG. 3 is a plan view of a third worksheet.

FIG. 4 is a plan view of a fourth worksheet.

[Explanation of symbols]

 1 Treatment Cost Input Table 2 Income Amount Input Table 3 Expenditure Amount Input Table 4 Balance Display Table 5 Name Column 6,8,10,15,16,19,24 Amount Column 7,9,11,20,21,25,26 Total column 12 Previous day balance column 13 Current day balance column 14 Ledger table 17 Balance display column 18 Monthly / annual total table 22 Total column 23 Expenditure statistics table 27 Total column W1, W2, W3, W4 Worksheet

Claims (4)

[Claims] Claims: 1. Using a computer system having a display device and an input device, the names and treatments of a plurality of treatment patients for each applicable insurance type such as national health insurance, social insurance, family of socially insured persons, and non-insurance treatment. The treatment cost input function that accepts the input of the amount of expenses, the insurance totalization function that calculates the total amount for each type of insurance on a daily basis from each input amount, and the total amount by this insurance totalization function An income and expenditure input function that receives input of income and expenditure amounts for each subject and an income and expenditure aggregation function that calculates each total amount from the income and expenditure amounts input by this income and expenditure input function And the balance of the previous day is entered reflecting the balance amount of the previous day. A function of summarizing the balance to be issued, and dividing the income, expenditure, the sum of these, and the amount of each balance on a daily basis, and repeatedly displaying this on a display screen continuously for one year. A medium that records a clinic accounting support program. 2. A ledger element creation function for inputting a ledger element by reflecting the total amount by insurance by the insurance aggregation function, the income and expenditure for each subject, and the balance amount by the balance aggregation function is executed. 2. The recording medium according to claim 1, wherein the ledger element is divided for each day, and the ledger element is repeatedly displayed for one year continuously on a display screen. 3. A function for calculating a total monthly amount for each insurance based on the total amount for each insurance by the total amount for each insurance by the total function for each insurance; and a total treatment cost for each month based on the total monthly amount for each insurance. Monthly medical expenses totaling function to calculate the amount of money, Annual medical expenses totaling by annual insurance function to calculate the total amount of annual medical expenses by year from the total monthly amount of the insurance, and from the total monthly medical expenses The accounting support program for a dental clinic according to claim 1, wherein an annual treatment cost totaling function for calculating a total amount of annual treatment costs throughout the year is executed, and monthly and annual treatment costs are totaled. The recorded media. 4. A monthly subject expenditure calculation function for calculating a monthly subject total expenditure amount from the subject amount by the income and expenditure amount input function, and an annual subject throughout the year from the monthly subject total expenditure amount. Annual expenditure calculation function to calculate the total expenditure amount by year; monthly expenditure calculation function to calculate the total monthly expenditure amount from the total expenditure amount by month subject; and annual expenditure through the year The medium for recording a dental clinic accounting support program according to claim 1, wherein an annual total expenditure calculating function for calculating a total amount is executed, and each amount is displayed on a display device.