AR Forcasting

Jpats2007

New Member
Joined
Oct 1, 2014
Messages
4
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>
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Jpats2007

New Member
Joined
Oct 1, 2014
Messages
4
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,125
Messages
5,599,856
Members
414,342
Latest member
K Darrell Smith

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top