EXCEL

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