the best solution for this problem please

[ahmed2]

https://ufile.io/ds0xh

please how to treat this tables

 

[Joe4]

Welcome to the Board!

I don't see a question here. If you want to post links to files/images, that is fine (though many of us cannot see those, as those sites are blocked by our security teams).
However, we ask that you still post your question here. Please just don't post a link and say "take a look here". Describe your question in detail here.

 

[ahmed2]

thanks for your reply
i will describe my question bu pics

 

[Joe4]

Please be sure to describe your question here, in this thread, and not in pictures that you link to.
It is fine to use linked pictures as examples (though many of us cannot see them), but the question she be posted clearly directly in this thread.

 

[ahmed2]

ok i will try first sheet ( cash sales )

vacant lands	example for cash sales
Customer Customer	Total space ( M )	Price for one meter (EGP)	Total price	Name of location	Date of sale
a	200	100	20000	stars	2018/01/01
b	300	100	30000	stars	2018/01/15
c	1000	200	200000	moon	2018/02/03
d	600	300	180000	dream land	2018/02/03
e	150	300	45000	dream land	2018/07/20
etc…
Total	2250		475000

<colgroup><col span="6"></colgroup><tbody>
</tbody>

vacant lands	example for cash sales
Customer Customer	Total space ( M )	Price for one meter (EGP)	Total price	Name of location	Date of sale
a	200	100	20000	stars	2018/01/01
b	300	100	30000	stars	2018/01/15
c	1000	200	200000	moon	2018/02/03
d	600	300	180000	dream land	2018/02/03
e	150	300	45000	dream land	2018/07/20
etc…
Total	2250		475000

<colgroup><col style="mso-width-source:userset;mso-width-alt:4672; width:110pt" width="146" span="6"> </colgroup><tbody>
</tbody>

second sheet

installment sales						explain
Total space ( M )	Price for one meter (EGP)	Total Amount	Cash payment Amount Received	Amount Outstanding	Payment Terms	Payment Date or Due date	due Payment Amout	Name of location	Date of sale
200	100	20000	5000	15000	36	explain : every month from date of sale or every two month or three or Payments not equal	35*400 1*1000	stars	2018/01/01
300	100	30000	6000	24000	24	2018/02/15	24*1000	stars	2018/01/15
1000	200	200000	100000	100000	4	2018/06/03	4*25000	moon	2018/02/03
600	300	180000	60000	120000	12	2018/03/03	12*10000	dream land	2018/02/03
150	300	45000	6000	39000	60	2018/08/20	60*650	dream land	2018/07/20
450	200	90000	50000	40000	12	2018/09/22	8*2000 2*6500 1*11000	moon	2018/07/22
2700		565000	227000	338000

<colgroup><col span="6"><col><col span="3"></colgroup><tbody>
</tbody>

third sheet

Sales returns
Customer Customer	Total space ( M )	Price for one meter (EGP)	Total price	Total amount returns	Discount	Name of location	Date of sale	Date of returns	Notes
a	200	100	20000	16000	4000	stars	2018/01/01	2018/07/01	cash sales ( returns discount 25% )
b	300	100	30000	30000	0	stars	2018/01/15	2018/07/20	cash sales (no discount )
cc	1000	200	200000	135000	15000	moon	2018/02/03	2018/07/23	Cash payment ( 100000 ) + ( paid two payements 2*25000) ( returns discount 10% )
total			250000	181000	19000

<colgroup><col span="8"><col><col></colgroup><tbody>
</tbody>

final sheet

payments of sales
Customer Customer	Total space ( M )	Price for one meter (EGP)	Amount Outstanding	Name of location	Date of sale	Payments	Notes
dd	600	300	120000	dream land	2018/02/03	120000	payments all installement in 2018/07/23 ( 12*10000 )
in this case customer paid all payements another example customer got discount when he paid more than one installement in this case invoice sales will be change like price of meter and total of cash that will be effect on installements sales sheet how can i treatment that and in case of reutrns that will effect on cash or installement sales how can i treatment Especially if returns happened in another year
how I can organize this and how I can make reminder for customers who late payments
how can I treatment all sheets to do best and easy work for accounts or calculation customer or spaces or location in excel

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

sorry if i cant show it clearly it first time post here and thanks for your help

 

[ahmed2]

in this case customer paid all payements another example customer got discount when he paid more than one installement in this case invoice sales will be change like price of meter and total of cash that will be effect on installements sales sheet how can i treatment that and in case of reutrns that will effect on cash or installement sales how can i treatment Especially if returns happened in another year
how I can organize this and how I can make reminder for customers who late payments
please I cant found any help! how can I treatment all sheets to do best and easy work for accounts or calculation customer or spaces or location in excel this ways are difficult for calculation any thing and how I can Summarize all data and when customer return his sales is that deleted from this tables but it will effect net come

<colgroup><col span="6"><col span="3"></colgroup><tbody>
</tbody>

 

[Joe4]

Perhaps someone will be willing and able to help.
But to me, this seems like a complex problem that might require Consulting help.
If you are interested in that, see: https://www.mrexcel.com/consulting-services/