AR Forcasting

[Jpats2007]

Hello,
I am trying to create a 13 week AR Frocast, Does anyone have a template of a MACRO that I can use. I am looking to extract the sum of the invoices using the invoice date plus 55days. attached is a sample of the date that I am working with. I would like to have it by company and by week total.

9/22/2014				09/21/14-09/27/14	09/28/14-10/04/14	10/05/14-10/11/14	10/12/14-10/18/14
Company X	9/4/2014	0874634-IN	138.12
Company Y	7/30/2014	0873475-IN	0.72
Company Y	8/12/2014	0873699-IN	97.20
Company Y	8/19/2014	0873992-IN	66.96
Company Y	9/16/2014	0875030-IN	472.32
Company Z	8/28/2014	0874138-IN	1,827.18
Company Z	9/2/2014	0874325-IN	966.41
Company Z	9/3/2014	0874335-IN	223.25
Company Z	9/9/2014	0874443-IN	310.30
Company Z	9/9/2014	0874455-IN	381.34
Company AA	9/10/2014	0874446-IN	806.98
Company AA	9/10/2014	0874452-IN	369.84

<tbody>
</tbody>

 

[mohan.pandey87]

Show us the output.

 

[Jpats2007]

This is my first time, what is the output?

 

[mohan.pandey87]

What exactly you want or how you want to see the data?

 

[Jpats2007]

I basically want to predict how much mony is going to come in each week based on the average pay date being 55 days after the invoice date. I would like to see it by company. I can use this to caculate the total of all the companies per week. The layout is not concrete as I was asked to develope it from scratch.