EXCEL
Employer
[no-member:pro]Viktor[/no-member:pro]Viktor
Project parameters
Type of cooperationOne-time project
SectionTexts and translation
Prepaymentprepayment is possible
Payment methodsBank transfer, Electronic money
Acceptance of requestsclosed
Project description
Good day.
We are a construction company that repairs apartments.
This is the nature of the task:
It is necessary to make expenses for several objects in the table , in the column of expenses it is necessary to indicate the object , purpose of payment , date , legal person, actual expense, notes , expense for the client (mainly 25-30% more than the actual expense , this is the profit of the enterprise ) as well as a column in the percentage of the difference of fact and expense for the client .
Column advance and full payment if the advance is marked in red if full payment is yellow. Then you need to make the remainder of the plait in this column with the date of final payment (or offer your own option of registration of this column).
It is also desirable to see the table of advanced and non-closed payments next to you.
The second sheet should consist of a table of the arrival of funds by objects, date,
Name of the object, appointment of the parish (it is necessary to make a gradation "completion, construction, project")
The 3rd page is the costs of domestic companies:
Date, purpose (ZP, administrative, advertising, rent, development, printing (with the ability to choose from the list, as well as edit the list) , to whom issued
Debts.
Page 4: The store
Date, order, customer amount, amount of actual value, difference
5th sheet profit
A few tables:
Planned expenditure
Planned income
Income per month
Total income
Also income by types from sheet 1 and 4 (construction, equipment, store, projects)
I would like to have the opportunity to create a chart and summary statement on different types of costs / expenses / profits.
Also, a list of objects is necessary, so that when entered, it automatically appears in all sheets.
The stage of the object, the deadlines under the contract.
An example of the design that I like
We are a construction company that repairs apartments.
This is the nature of the task:
It is necessary to make expenses for several objects in the table , in the column of expenses it is necessary to indicate the object , purpose of payment , date , legal person, actual expense, notes , expense for the client (mainly 25-30% more than the actual expense , this is the profit of the enterprise ) as well as a column in the percentage of the difference of fact and expense for the client .
Column advance and full payment if the advance is marked in red if full payment is yellow. Then you need to make the remainder of the plait in this column with the date of final payment (or offer your own option of registration of this column).
It is also desirable to see the table of advanced and non-closed payments next to you.
The second sheet should consist of a table of the arrival of funds by objects, date,
Name of the object, appointment of the parish (it is necessary to make a gradation "completion, construction, project")
The 3rd page is the costs of domestic companies:
Date, purpose (ZP, administrative, advertising, rent, development, printing (with the ability to choose from the list, as well as edit the list) , to whom issued
Debts.
Page 4: The store
Date, order, customer amount, amount of actual value, difference
5th sheet profit
A few tables:
Planned expenditure
Planned income
Income per month
Total income
Also income by types from sheet 1 and 4 (construction, equipment, store, projects)
I would like to have the opportunity to create a chart and summary statement on different types of costs / expenses / profits.
Also, a list of objects is necessary, so that when entered, it automatically appears in all sheets.
The stage of the object, the deadlines under the contract.
An example of the design that I like
