JP2000123075A - Construction ledger preparation system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To easily prepare a construction ledger by unnecessitating the special knowledge or complicated transfer voucher processing of financial accounts by providing an arithmetic part for arithmetically generating the displayable construction ledger for displaying the construction name, payment amount, reception amount and differential reception amount of a prescribed construction, and providing the arithmetic part with a demand input function and a construction ledger preparing function. SOLUTION: This system is provided with an arithmetic part 2 for arithmetically preparing the displayable construction ledger for displaying the construction name, payment amount, reception amount and differential reception amount of the prescribed construction based on data inputted from an input device 1 and a display 3 for displaying the construction ledger. This arithmetic part 2 is provided with the demand input function for inputting the data of a demand and the construction ledger preparing function for preparing the construction ledger by automatically calculating items to be inputted to the construction ledger based on the data of the demand to the construction of prescribed date. Besides, the arithmetic part 2 automatically retrieves the construction name from a construction master 13 based on a construction code, inputs and displays it in the construction ledger.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a work ledger creation system for creating a work ledger for the construction industry or the like.

[0002]

2. Description of the Related Art Generally, the basis of the construction industry is the outsourcing industry, and managing payments to subcontractors (constructors) is an important factor in accounting. That is, in the construction industry, it is necessary to simultaneously perform sales and production management, and a construction period is required. Therefore, the construction ledger for the target year and month in the prescribed year (at least the construction name, payment amount, deposit amount, It is necessary to prepare a table showing the difference of payment.

[0003] However, a device for performing the current financial accounting process (a device in which application software operating on the OS is generally installed in a computer in which a predetermined OS is installed) is used for financial accounting, inventory, purchase, and the like.
A plurality of processes such as man-hour management are performed simultaneously, the data is unified, and a construction ledger or the like can be created on condition that each data is input.

[0004] For this reason, specialized knowledge of financial accounting and the above-mentioned apparatus (software) and complicated transfer slip processing are required, and work is complicated in a situation where payment work is prioritized (that is, when creating a work ledger). There is a drawback that the work ledger cannot be easily created with the above-mentioned device (software).

[0005]

A construction ledger creating apparatus according to the present invention for solving the above-mentioned problems has at least a construction name, a payment amount, and a deposit amount for a predetermined construction based on data input by an input device 1. , Calculation unit 2 for calculating and creating a construction ledger capable of displaying a deposit difference display
And a display 3 for displaying the construction ledger,
The calculator 2 automatically calculates the above-mentioned items to be input to the work ledger based on the bill data for the work of the predetermined year and month in the predetermined fiscal year by inputting the bill data. The first feature is that a construction ledger creation function for creating a construction ledger is provided.

Secondly, a construction master 13 in which a combination of a construction name and a construction code uniquely corresponding to each construction name is described is provided in association with the operation function side, and the operation unit 2 operates based on the construction code based on the construction code. 13 is characterized in that the construction name is automatically searched and input and displayed in the construction ledger.

Third, the bill input function is characterized in that the construction name corresponding to the bill data is inputted with reference to the construction code.

Fourthly, a customer master 11 in which a combination of a customer name and a customer code uniquely corresponding to each customer name is described is provided in association with the operation unit 2 side, and the operation unit 2 is configured based on the customer code. It is characterized in that the customer name is automatically retrieved from the customer master 11 and displayed in the construction ledger.

Fifth, the operation unit 2 is provided with a deposit input function for inputting a deposit amount from a contractor of the construction in accordance with the construction code.

Sixth, the operation unit 2 is characterized by automatically inputting a deposit amount into a construction ledger from a deposit input function with reference to a construction code.

[0011]

DESCRIPTION OF THE PREFERRED EMBODIMENTS The construction ledger creation system of the present invention will be described below in detail with reference to the drawings. As shown in FIG. 1, the construction ledger creation system includes an input interface 1 such as a keyboard and a mouse for inputting data to the construction ledger creation system, and calculates data required for the construction ledger according to the input from the input interface 1. And an operation unit 2 that creates a work ledger table in a tabular form that can be displayed on the display, and displays the data generated by the calculation in the work ledger table to create a work ledger. And a display 3 for displaying the construction ledger.

In this embodiment, the construction ledger creation system is constituted by a computer (personal computer).
The calculation unit 2 is realized by software operating on a predetermined OS.

Next, the operation of the arithmetic section 2 will be described in detail. The calculation unit 2 has a bill input function for accumulating bill data from a construction contractor (subcontractor) input by the input interface 1 for each bill, and a billing amount from a customer (construction ordering contractor). A deposit input function for accumulating each time, and a work ledger creation function for creating a work ledger in a table format as described above (data for displaying the work ledger on a display) based on the bill data accumulated by the bill input function. And are provided.

On the operation unit 2 side, the customer master 11, which is a correspondence table between the customer name of each customer who ordered the construction and the code No (customer code) which is a number (character) string composed of numerals or alphabets, etc. Code No. which is a number (character) string consisting of the name of the trader and a number or alphabet
(Contractor code), a contractor master 14, a correspondence table with a code number (construction code), which is a string of numbers (characters) composed of numbers or alphabets, and a financial name. A financial subject master, which is a correspondence table between a subject and a code No (financial code) which is a string of numbers (characters) composed of numbers or alphabets, is created and stored in advance as an electronic database so that contents can be added. In each master, code N
o is unique.

The bill input function generates a bill form 6 in a tabular form that can be displayed on the display as shown in FIG. 2, and includes an input interface 1 (keyboard, mouse, etc.) in the bill form 6. It is configured so that the data of the bill from the contractor can be input. Specifically, as shown in FIG.
By inputting the processing date (payment date) and the contractor (billing source, that is, payee) from the keyboard, the entered processing date and the contractor are used as a reference (head). Generated, and in this invoice table 6, the construction name, financial subject,
The payment amount, consumption tax, and total payment amount are input.

The operator name, the construction name, and the financial subject can be input by inputting a supplier code, a construction code, or a financial code from the input interface 1 so that the arithmetic unit 2 can execute the contractor master 14, the construction master 13, or the financial master. , And automatically displays a trader name, a construction name, or a financial item corresponding to the trader code, the construction code, or the financial code.

At this time, in the case of a trader name, a construction name, or a financial subject that is not listed in the trader master 14, the construction master 13, or the financial master, the contents are added to any of the masters, and the trader name, the work name , Financial subjects are automatically displayed, but by inputting the trader name, construction name, and financial subject independently, this trader name, construction name, and financial subject are automatically registered in each master. May be configured.

On the other hand, the payment amount is calculated, for example, from the invoice from the contractor by calculating, for example, quantity × unit price and the payment amount, and the calculation result is directly inputted manually from the keyboard into the payment amount column (cell) of the invoice table. The invoice input function automatically calculates the consumption tax from the payment amount as the payment amount x the consumption tax rate (5%) by inputting the payment amount, and calculates the consumption tax in the consumption tax column (cell). Automatically input (display) the calculation result (consumption tax amount), and furthermore, add the total payment amount to the payment amount +
It is configured to automatically calculate (calculate) the consumption tax and automatically input (display) the calculation result (total payment amount) in the total payment column (cell).

Then, the sum of the payment amount, the consumption tax, and the total payment amount of all the work corresponding to the head is automatically calculated and displayed in each total column (cell). , Advance payment, bill), the cash payment amount is calculated as follows: cash payment amount = total payment total−
(Safety meeting + advance money + bill) is automatically calculated, and the calculation result is automatically input in the cash payment column (cell).

At this time, the payment details can be manually inputted. For example, as shown in FIG. 4, by inputting a processing month (payment month to each contractor), each contractor in the input processing month can be input. The total payment amount is automatically displayed, and the payment details table 7 for manually inputting and setting the payment details with respect to the total payment amount is formed as a database by the relational (linkage) on the operation unit 2 side. 7 may be reflected on the bill table 6 side. The safety dues are expenses for workers' accident prevention, etc., and the amount to be collected is entered.

Next, the deposit input function will be described. The deposit input function is a function for managing a deposit state from a customer (a contractor of the construction) in units of construction and generates a payment table 8 in a tabular form which can be displayed on the display as shown in FIG. In the table 8, the input interface 1 can be used to input payment data from a customer. Specifically, by inputting the processing date (payment date) from the keyboard, a payment table 8 based on the input processing date as a reference (head) is generated. It is configured so that a deposit category, a deposit amount, a consumption tax, and a total deposit amount are input.

At this time, the construction name is input in the same manner as described above, so that the calculation unit 2 searches for the construction master and automatically displays the construction name corresponding to the construction code. The deposit classification is such that the name of the deposit category such as transfer, bill, cash, etc. and the code No. (payment code) which is a number (character) string composed of numbers or alphabets are uniquely stored and stored. The name is automatically displayed in the payment table 8.

The deposit amount from the customer and the consumption tax are input manually or automatically from the keyboard into the deposit amount and consumption tax fields (cells) of the deposit table 8, and the deposit input function is provided. The total deposit is calculated automatically from the received amount and the consumption tax amount as the received amount + the consumption tax, and the calculation result is automatically input (displayed) in the total received amount column (cell).

Next, the construction ledger creation function will be described.
The construction ledger creation function generates a construction ledger table 9 in a tabular form that can be displayed on the display as shown in FIG. 6, and also imports data from the billing table 6 or the like according to an instruction from the input interface 1 and directly performs the operation. Alternatively, it is processed and input and displayed in the construction ledger table 9.

That is, the work ledger creation function is to input a target year and a target year and month for which a work ledger is to be created from the input interface 1, and the work ledger table in a table format based on the target year and the target year and month (head). 9 in the construction ledger table 9, the name of the construction, the name of the orderer, the person in charge, the completion month, the construction contract money, the total payment amount, the total deposit amount, the receivable, the difference
A construction ledger is created by automatically inputting the expense rate from the data of the bill input function and each master.

As shown in FIG. 7, first, when an optional (necessary) target year and year and month to be output as a construction ledger are input, a plurality of invoice tables 6 and payment tables 8 created as described above are obtained. And search and select the invoice table 6 and the payment table 8 up to the target date in the target year, and sort (aggregate) the selected invoice table 6 and the payment table 8 based on each construction code, In the case of the invoice table 6, the total amount of payment is totaled in the case of the invoice table 6, and in the case of the payment table 8, the total amount of payment is totaled. Import).

Then, the construction master is searched from the construction code, and the construction name, completion month, and construction contract money are obtained as data, and the respective data are entered in the construction ledger table in the columns of construction name, completion month, construction contract money (cell). And input display (import). At this time, the customer master is retrieved from the customer code described in the construction master, the customer name is obtained, the customer name is imported into the orderer name column (cell) of the construction ledger table 9, and the construction master An employee master, which will be described later, is searched from the business operator code to obtain an employee name, and the employee name is imported into the column (cell) of the person in charge of the construction ledger.

Thereafter, the receivable is automatically calculated as the construction contract minus the total deposit, the result of the calculation is displayed in the column (cell) of the receivable, and the difference in deposit is automatically calculated as the construction contract minus the total payment. Calculate and display in the deposit balance column (cell), and further calculate the expense ratio ((deposit difference / construction contract)) × 100
Is automatically calculated and input and displayed in the expense ratio column (cell). As a result, a construction ledger for the target year and month in the designated predetermined target year is created.

The structure of each of the above masters will be described below. As shown in FIGS. 8 to 11, each master has a tabular form that can be displayed on the display. The customer master 11 has a customer code,
Customer name, address, telephone number, closing date, employee code (employee code of the employee in charge of the customer), remarks, etc. can be entered. As described above, other master and construction ledgers start from the customer code and employee code. Table 9, invoice table 6, and payment table 8 are relational. The employee master 12 can input an employee code, an employee name, an address, a telephone number, etc. for one employee. 6 、 Receivable Table 8 is relational.

Further, the construction master 13 has a construction code, a construction name, a year, a completion month, a construction contract money,
It is possible to input a contract consumption tax, an execution budget, a construction period, a person in charge of construction, a total area, a customer code, a business operator code, a custom construction code, and the like. The salesperson code and the construction staff code are relational with the employee code of the employee master 12. The contractor master 14 can input a contractor code, a contractor name, an address, a telephone number, a closing date, an employee code (an employee code of an employee in charge of the contractor), remarks, etc. for one contractor, as described above. The other master and construction ledger tables 9, invoice tables 6, and payment tables 8 are relational starting from the trader customer code and the employee code.

With the structure shown above, the data of the invoice from the construction contractor is input to the invoice table 6, so that the input invoice table 6 and the previously input masters 11, 12, 13,. 14 and the data in the payment table 8, a construction ledger corresponding to the target year and the target year and month indicated by the keyboard or the like is automatically created and displayed on the display. By inputting the data, the construction ledger can be automatically and easily created almost automatically, and the electronic processing of the construction ledger can be easily performed.

In other words, except for the input of each master and the payment table 8, since it is only the data of the invoice, the specialized knowledge of the accounting process and the complicated transfer slip processing become unnecessary, and the payment clerk is given priority. In this situation, a computerized work ledger (database) can be easily created by simple work (that is, input of a bill), and monthly payment management and the like can be easily performed.

In particular, in the input of the invoice table 6 and the payment table 8, the necessary information such as the trader name is displayed by inputting each code such as numerals and alphabets other than the amount of payment or payment by each master. In addition to the simple operation, input errors such as typing errors are reduced.

[0034]

According to the structure of the present invention configured as described above, the contents of the bill for the month in which the construction ledger needs to be created are input to the construction ledger creation system, and the Since the construction ledger is automatically created by the calculation unit based on the data, it is possible to easily create the construction ledger based on the invoice without special knowledge of financial accounting and complicated transfer slip processing etc. There is an effect that can be.

In particular, by arranging each master in association with the arithmetic function side, the number of input points to be manually input when inputting bill data is reduced, input errors and the like are reduced, and each work, customer and There is also an advantage that management of construction contractors and the like can be performed.

[Brief description of the drawings]

FIG. 1 is a configuration diagram of a construction ledger creation system.

FIG. 2 is a bill table displayed on a display.

FIG. 3 is an operation flowchart of a bill input function.

FIG. 4 is a payment breakdown table displayed on a display.

FIG. 5 is a payment table displayed on a display.

FIG. 6 is a construction ledger table displayed on a display.

FIG. 7 is an operation flowchart of a construction ledger creation function.

FIG. 8 is a customer master displayed on a display.

FIG. 9 is an employee master displayed on a display.

FIG. 10 is a construction master displayed on a display.

FIG. 11 is a trader master displayed on the display.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Input interface (input device) 2 Operation part 3 Display 11 Customer master 13 Construction master

Claims (6)

[Claims] An arithmetic unit for calculating and generating a construction ledger capable of displaying a construction name, a payment amount, a payment amount, and a payment difference for a predetermined construction on a display based on data input by the input device (1). 2) and a display (3) for displaying the construction ledger, wherein the arithmetic unit (2)
A bill entry function that allows the user to enter bill data, and a construction ledger that automatically calculates the above items to be entered in the construction ledger based on the bill data for the construction for a given year and month in a given year. Construction ledger creation system with ledger creation function. 2. A construction master (13) in which a combination of a construction name and a construction code uniquely corresponding to each construction name is described in association with an arithmetic function side, and an arithmetic unit (2) is configured based on the construction code. The construction ledger creation system according to claim 1, wherein the construction ledger is automatically searched for from the construction master (13) and input and displayed in the construction ledger. 3. The construction ledger creation system according to claim 2, wherein the bill input function has a structure in which a construction name corresponding to the bill data is inputted with reference to a construction code. 4. A customer master (11) in which a combination of a customer name and a customer code uniquely corresponding to each customer name is described in association with the operation unit (2), and the operation unit (2) is provided. 4. The construction ledger creation system according to claim 1, wherein the customer name is automatically retrieved from the customer master based on the customer code and displayed in the construction ledger. 5. The construction ledger creation system according to claim 2, further comprising a deposit input function for inputting a deposit amount from a contractor of the construction in accordance with the construction code on the operation section (2) side. 6. The work ledger creation system according to claim 5, wherein the arithmetic unit (2) refers to the work code and automatically inputs a deposit amount to the work ledger from a deposit input function.