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]

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

<colgroup><col><col span="2"><col span="4"><col span="2"><col><col><col><col span="2"></colgroup><tbody>
</tbody>