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 )

[TABLE="width: 876"]
<colgroup><col span="6"></colgroup><tbody>[TR]
[TD="align: left"] vacant lands[/TD]
[TD="colspan: 2, align: left"]example for cash sales[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Customer Customer[/TD]
[TD]Total space
( M )[/TD]
[TD]Price for one meter
(EGP)[/TD]
[TD]Total price[/TD]
[TD]Name of location[/TD]
[TD]Date of sale[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]200[/TD]
[TD]100[/TD]
[TD]20000[/TD]
[TD]stars[/TD]
[TD]2018/01/01[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]300[/TD]
[TD]100[/TD]
[TD]30000[/TD]
[TD]stars[/TD]
[TD]2018/01/15[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]1000[/TD]
[TD]200[/TD]
[TD]200000[/TD]
[TD]moon[/TD]
[TD]2018/02/03[/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD]600[/TD]
[TD]300[/TD]
[TD]180000[/TD]
[TD]dream land[/TD]
[TD]2018/02/03[/TD]
[/TR]
[TR]
[TD]e[/TD]
[TD]150[/TD]
[TD]300[/TD]
[TD]45000[/TD]
[TD]dream land[/TD]
[TD]2018/07/20[/TD]
[/TR]
[TR]
[TD]etc…[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]2250[/TD]
[TD][/TD]
[TD]475000[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

<colgroup><col style="mso-width-source:userset;mso-width-alt:4672; width:110pt" width="146" span="6"> </colgroup><tbody>
[TD="class: xl69, width: 146, align: left"] vacant lands[/TD]
[TD="class: xl69, width: 292, colspan: 2, align: left"]example for cash sales[/TD]
[TD="width: 146"][/TD]
[TD="width: 146"][/TD]
[TD="width: 146"][/TD]

[TD="class: xl66"]Customer Customer[/TD]
[TD="class: xl67, width: 146"]Total space
( M )[/TD]
[TD="class: xl67, width: 146"]Price for one meter
(EGP)[/TD]
[TD="class: xl66"]Total price[/TD]
[TD="class: xl67, width: 146"]Name of location[/TD]
[TD="class: xl66"]Date of sale[/TD]

[TD="class: xl66"]a[/TD]
[TD="class: xl66"]200[/TD]
[TD="class: xl66"]100[/TD]
[TD="class: xl66"]20000[/TD]
[TD="class: xl66"]stars[/TD]
[TD="class: xl68"]2018/01/01[/TD]

[TD="class: xl66"]b[/TD]
[TD="class: xl66"]300[/TD]
[TD="class: xl66"]100[/TD]
[TD="class: xl66"]30000[/TD]
[TD="class: xl66"]stars[/TD]
[TD="class: xl68"]2018/01/15[/TD]

[TD="class: xl66"]c[/TD]
[TD="class: xl66"]1000[/TD]
[TD="class: xl66"]200[/TD]
[TD="class: xl66"]200000[/TD]
[TD="class: xl66"]moon[/TD]
[TD="class: xl68"]2018/02/03[/TD]

[TD="class: xl66"]d[/TD]
[TD="class: xl66"]600[/TD]
[TD="class: xl66"]300[/TD]
[TD="class: xl66"]180000[/TD]
[TD="class: xl66"]dream land[/TD]
[TD="class: xl68"]2018/02/03[/TD]

[TD="class: xl66"]e[/TD]
[TD="class: xl66"]150[/TD]
[TD="class: xl66"]300[/TD]
[TD="class: xl66"]45000[/TD]
[TD="class: xl66"]dream land[/TD]
[TD="class: xl68"]2018/07/20[/TD]

[TD="class: xl66"]etc…[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl66"]Total[/TD]
[TD="class: xl66"]2250[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"]475000[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl68"][/TD]

</tbody>

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

third sheet

[TABLE="width: 1343"]
<colgroup><col span="8"><col><col></colgroup><tbody>[TR]
[TD="align: left"]Sales returns[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Customer Customer[/TD]
[TD]Total space
( M )[/TD]
[TD]Price for one meter
(EGP)[/TD]
[TD]Total price[/TD]
[TD]Total amount returns[/TD]
[TD]Discount[/TD]
[TD]Name of location[/TD]
[TD]Date of sale[/TD]
[TD]Date of returns[/TD]
[TD]Notes[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]200[/TD]
[TD]100[/TD]
[TD]20000[/TD]
[TD]16000[/TD]
[TD]4000[/TD]
[TD]stars[/TD]
[TD]2018/01/01[/TD]
[TD]2018/07/01[/TD]
[TD="align: left"]cash sales ( returns discount 25% )[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]300[/TD]
[TD]100[/TD]
[TD]30000[/TD]
[TD]30000[/TD]
[TD]0[/TD]
[TD]stars[/TD]
[TD]2018/01/15[/TD]
[TD]2018/07/20[/TD]
[TD="align: left"]cash sales (no discount )[/TD]
[/TR]
[TR]
[TD]cc[/TD]
[TD]1000[/TD]
[TD]200[/TD]
[TD]200000[/TD]
[TD]135000[/TD]
[TD]15000[/TD]
[TD]moon[/TD]
[TD]2018/02/03[/TD]
[TD]2018/07/23[/TD]
[TD="align: left"]Cash payment ( 100000 ) + ( paid two payements 2*25000) ( returns discount 10% )[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]total[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]250000[/TD]
[TD="align: right"]181000[/TD]
[TD="align: right"]19000[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

final sheet

[TABLE="width: 999"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="align: left"]payments of sales[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Customer Customer[/TD]
[TD]Total space
( M )[/TD]
[TD]Price for one meter
(EGP)[/TD]
[TD]Amount Outstanding[/TD]
[TD]Name of location[/TD]
[TD]Date of sale[/TD]
[TD]Payments[/TD]
[TD]Notes[/TD]
[/TR]
[TR]
[TD]dd[/TD]
[TD]600[/TD]
[TD]300[/TD]
[TD]120000[/TD]
[TD]dream land[/TD]
[TD]2018/02/03[/TD]
[TD]120000[/TD]
[TD]payments all installement in 2018/07/23
( 12*10000 )[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]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 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]how I can organize this and how I can make reminder for customers who late payments[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]how can I treatment all sheets to do best and easy work for accounts or calculation customer or spaces or location in excel[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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

 

[ahmed2]

[TABLE="width: 1092"]
<colgroup><col span="6"><col span="3"></colgroup><tbody>[TR]
[TD="colspan: 5"]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 [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="colspan: 5"]how I can organize this and how I can make reminder for customers who late payments[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="colspan: 9"]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 [/TD]
[/TR]
</tbody>[/TABLE]

 

[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/