Accounts Receivable Aging help Fifo Credit Basis

iamfarhanmahmood

New Member
Joined
Mar 20, 2016
Messages
16
Hellow,

I am preparing accounts receivable aging.

Its working to extract. Records according to due days but i need formula which less the amounts according to fifo basis.

I means if some amount amount i post in credit enerty it nuteralize oldest category rest other remaining same.

Need help.

Regards
Farhan
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

iamfarhanmahmood

New Member
Joined
Mar 20, 2016
Messages
16
Need Help Accounts Receivable Aging

Hellow,

Need help in Regards of Preparing Accounts Receivable Aging need help for credit entery nuteralized oldest category means Fifo bais.

Eg i have array.

A Column Have Party name
B Column Have Invoice Date
C Column Have Invoice Number
D Column Have Debit Amount
E Column have Credit Amount
F Column have Due Days Calculated (Today Date-invoice Date)

I have Sum amounts using sumifs criteria 01-15 Days Due 16-30Days Due 31-60 Days Due i need help when That when i post any amount in column E which have credit enteries it nuteralize 31-60 Days category then 16-30 Days Category then 01- 15 Days Category and so on...

Waiting urgent positive help.

Regards Farhan
 

mtariqraheem

New Member
Joined
Jun 11, 2016
Messages
2
Re: Need Help Accounts Receivable Aging

I advise you to use IF function for making against each transaction.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,481
Messages
5,601,918
Members
414,482
Latest member
morkar

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