Sales Forecast (Income per week Vs Expenses & Other Cost Per Week REPORT)

[calejobe]

Hello,


I have tried to put together a report that provides information in regard of our organization income vs expenses & other costs. As you can see I started my excel sheet where I have entered some of my invoices and allocate those amount on specifics weeks. What I want to get, is a report that provides the following information:


1- Quarterly report of Paid Invoices, allocated across each week (Total income per week) / This information will be manually fed into the excel sheet, but it should be a formula that allocates the amount to a specific the day.


2- Quarterly report of Pending Invoices, allocated across each week (Total income per week) / This information will be feed into the excel sheet, but it should be a formula that allocates the amount to a specific the day.

I will appreciate any feedback that you can provide.


Thank you,


Carlos B.

 

[oldbrewer]

[TABLE="width: 1029"]
<colgroup><col><col span="2"><col span="4"><col span="2"><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]invoice[/TD]
[TD]date due[/TD]
[TD]date paid[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv1[/TD]
[TD="align: right"]07/03/2019[/TD]
[TD="align: right"]06/03/2019[/TD]
[TD="align: right"]127[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv2[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]12/03/2019[/TD]
[TD="align: right"]135[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv3[/TD]
[TD="align: right"]09/03/2019[/TD]
[TD][/TD]
[TD="align: right"]143[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv4[/TD]
[TD="align: right"]10/03/2019[/TD]
[TD][/TD]
[TD="align: right"]151[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv5[/TD]
[TD="align: right"]11/03/2019[/TD]
[TD="align: right"]11/03/2019[/TD]
[TD="align: right"]159[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv6[/TD]
[TD="align: right"]12/03/2019[/TD]
[TD="align: right"]12/03/2019[/TD]
[TD="align: right"]167[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv7[/TD]
[TD="align: right"]13/03/2019[/TD]
[TD][/TD]
[TD="align: right"]175[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv8[/TD]
[TD="align: right"]14/03/2019[/TD]
[TD][/TD]
[TD="align: right"]183[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv9[/TD]
[TD="align: right"]15/03/2019[/TD]
[TD="align: right"]15/03/2019[/TD]
[TD="align: right"]191[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv10[/TD]
[TD="align: right"]16/03/2019[/TD]
[TD][/TD]
[TD="align: right"]199[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv11[/TD]
[TD="align: right"]17/03/2019[/TD]
[TD][/TD]
[TD="align: right"]207[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv12[/TD]
[TD="align: right"]18/03/2019[/TD]
[TD][/TD]
[TD="align: right"]215[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]invoices due[/TD]
[TD]invoices paid[/TD]
[TD]invoices outstanding[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv13[/TD]
[TD="align: right"]19/03/2019[/TD]
[TD][/TD]
[TD="align: right"]223[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv14[/TD]
[TD="align: right"]20/03/2019[/TD]
[TD="align: right"]20/03/2019[/TD]
[TD="align: right"]231[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/03/2019[/TD]
[TD="align: right"]13/03/2019[/TD]
[TD="align: right"]1057[/TD]
[TD="align: right"]588[/TD]
[TD="align: right"]469[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv15[/TD]
[TD="align: right"]21/03/2019[/TD]
[TD][/TD]
[TD="align: right"]239[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]14/03/2019[/TD]
[TD="align: right"]20/03/2019[/TD]
[TD="align: right"]1449[/TD]
[TD="align: right"]422[/TD]
[TD="align: right"]1027[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv16[/TD]
[TD="align: right"]22/03/2019[/TD]
[TD="align: right"]22/03/2019[/TD]
[TD="align: right"]247[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]21/03/2019[/TD]
[TD="align: right"]27/03/2019[/TD]
[TD="align: right"]1275[/TD]
[TD="align: right"]518[/TD]
[TD="align: right"]757[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv17[/TD]
[TD="align: right"]23/03/2019[/TD]
[TD][/TD]
[TD="align: right"]255[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]28/03/2019[/TD]
[TD="align: right"]03/04/2019[/TD]
[TD="align: right"]566[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]566[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv18[/TD]
[TD="align: right"]24/03/2019[/TD]
[TD][/TD]
[TD="align: right"]263[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/04/2019[/TD]
[TD="align: right"]10/04/2019[/TD]
[TD="align: right"]598[/TD]
[TD="align: right"]303[/TD]
[TD="align: right"]295[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv19[/TD]
[TD="align: right"]25/03/2019[/TD]
[TD="align: right"]25/03/2019[/TD]
[TD="align: right"]271[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]11/04/2019[/TD]
[TD="align: right"]17/04/2019[/TD]
[TD="align: right"]311[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]311[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv20[/TD]
[TD="align: right"]29/03/2019[/TD]
[TD][/TD]
[TD="align: right"]279[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]18/04/2019[/TD]
[TD="align: right"]24/04/2019[/TD]
[TD="align: right"]646[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]646[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv21[/TD]
[TD="align: right"]02/04/2019[/TD]
[TD][/TD]
[TD="align: right"]287[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]25/04/2019[/TD]
[TD="align: right"]01/05/2019[/TD]
[TD="align: right"]678[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]678[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv22[/TD]
[TD="align: right"]06/04/2019[/TD]
[TD][/TD]
[TD="align: right"]295[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/05/2019[/TD]
[TD="align: right"]08/05/2019[/TD]
[TD="align: right"]710[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]710[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv23[/TD]
[TD="align: right"]10/04/2019[/TD]
[TD="align: right"]10/04/2019[/TD]
[TD="align: right"]303[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]09/05/2019[/TD]
[TD="align: right"]15/05/2019[/TD]
[TD="align: right"]367[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]367[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv24[/TD]
[TD="align: right"]14/04/2019[/TD]
[TD][/TD]
[TD="align: right"]311[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]16/05/2019[/TD]
[TD="align: right"]22/05/2019[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv25[/TD]
[TD="align: right"]18/04/2019[/TD]
[TD][/TD]
[TD="align: right"]319[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]23/05/2019[/TD]
[TD="align: right"]29/05/2019[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv26[/TD]
[TD="align: right"]22/04/2019[/TD]
[TD][/TD]
[TD="align: right"]327[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]30/05/2019[/TD]
[TD="align: right"]05/06/2019[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv27[/TD]
[TD="align: right"]26/04/2019[/TD]
[TD][/TD]
[TD="align: right"]335[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv28[/TD]
[TD="align: right"]30/04/2019[/TD]
[TD][/TD]
[TD="align: right"]343[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv29[/TD]
[TD="align: right"]04/05/2019[/TD]
[TD][/TD]
[TD="align: right"]351[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv30[/TD]
[TD="align: right"]08/05/2019[/TD]
[TD][/TD]
[TD="align: right"]359[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]inv31[/TD]
[TD="align: right"]12/05/2019[/TD]
[TD][/TD]
[TD="align: right"]367[/TD]
[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]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]is this anywhere near what you want ?[/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]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]