So glad to hear that you like it. Thanks for the note and watching the video. Please stay in touch for more such videos on my channel and don't forget to subscribe.
Plz help..How will an amount received from a customer be deducted against an invoice within this aging report..? I mean.. I am facing this problem now.. An invoice was of Rs. 96000/- and now I have received this amount from a customer. Please tell me how to treat this transaction to update this aging report..? Plz help me..
Plz help..How will an amount received from a customer be deducted against an invoice within this aging report..? I mean.. I am facing this problem now.. An invoice was of Rs. 96000/- and now I have received this amount from a customer. Please tell me how to treat this transaction to update this aging report..? Plz help me..
Plz help..How will an amount received from a customer be deducted against an invoice within this aging report..? I mean.. I am facing this problem now.. An invoice was of Rs. 96000/- and now I have received this amount from a customer. Please tell me how to treat this transaction to update this aging report..? Plz help me..
Could u plz explain me... If I'm having invoice value with date and receipt value with date... But I don't know we received some value but against which invoice don't know... So in this case how to prepare aging report in excel......... Awaiting ur quick response.... It's urgent?
Can we forecast the rollover overdue bucket for next month ? Please can you make a planning video on this topic. I am struggling for the right formulas. Thanks
Thanks for watching Nisha and sharing your valuable comments here. You can go to customise you ribbon and find out if you have these tabs. Maybe worth a try.
@@ExceltoExcelE Plz help..How will an amount received from a customer be deducted against an invoice within this aging report..? I mean.. I am facing this problem now.. An invoice was of Rs. 96000/- and now I have received this amount from a customer. Please tell me how to treat this transaction to update this aging report..? Plz help me..
Thank you, am going to use this method. I have been looking for something like this to use on my debtor's age analysis. I want to build a system that would be able to notify me of any payments that are due in 30 days from the day the loan was granted, and also show those that are overdue by 10 days from the day they were due. Additionally, I want excel to automatically increase these payments that are overdue by 10 days. Do you perhaps know how one could go about building such?
@@srodgers66 Plz help..How will an amount received from a customer be deducted against an invoice within this aging report..? I mean.. I am facing this problem now.. An invoice was of Rs. 96000/- and now I have received this amount from a customer. Please tell me how to treat this transaction to update this aging report..? Plz help me..
If I have customers invoices list with value & invoice date, customers receipt with value and date.... And some of the customers have not been adjusted with some invoices.. But we collected.. In this case how to prepare aging in excel.. Kindly suggest brother
hi could you make a video, of > how to split the day format, when there is a time, than count a days of pending ( like till the current day, today, to know how many days issue is pending and not resolved, ?) and how do you make this formula work in automatic, every-time i update the file with the new references into one consolidated file? and so that also the pivot table will be updated too? thank you :)
Plz help..How will an amount received from a customer be deducted against an invoice within this aging report..? I mean.. I am facing this problem now.. An invoice was of Rs. 96000/- and now I have received this amount from a customer. Please tell me how to treat this transaction to update this aging report..? Plz help me..
Plz help..How will an amount received from a customer be deducted against an invoice within this aging report..? I mean.. I am facing this problem now.. An invoice was of Rs. 96000/- and now I have received this amount from a customer. Please tell me how to treat this transaction to update this aging report..? Plz help me..
It was very interesting and extremely useful (at least for me)
Thank you a lot!
Very nice. The new thing i learnt from this video is group option.
Really happy that this video was useful for you. Thanks for sharing your comments, stay tuned for more such videos.
Good information
Thanks alot for the feedback, don't forget to subscribe to my channel for more such videos.
Interesting....... super information..........very much useful me
So glad to hear that you like it. Thanks for the note and watching the video. Please stay in touch for more such videos on my channel and don't forget to subscribe.
Thanks for making this video
So nice of you, thanks for sharing comments, stay tuned with my channel for more such videos.
Its a wonderful AR Report to presenting with the company 👍👍👍👍
Thanks alot for the note and watching the video. Please stay in touch for more such videos on my channel.
It's quite simple and superb :-) Easy to understand who don't have much Excel formulas knowledge. Thanks & keep it up
Thanks alot for the feedback. I am glad that you enjoyed the video.
Nice Work
Great thanks really useful.,want aging convert pivotable
PERFECT I PASSED MY PROJECT THROUGH YOUR VIDEO
Plz help..How will an amount received from a customer be deducted against an invoice within this aging report..? I mean.. I am facing this problem now.. An invoice was of Rs. 96000/- and now I have received this amount from a customer. Please tell me how to treat this transaction to update this aging report..? Plz help me..
Amazing. Explanation is just mind blowing!
Glad that you liked it, thank you for watching the video. Don't forget to subscribe the channel to instantly get more such videos.
of all the presentations, this is crisp, snappy, sleek and awesome.. Thanks for sharing
This saves time. Thanks for the videos
Thanks alot for the note Rajiv, I am glad that you could benefit from the video. Please stay in touch for more such videos on my channel.
Excellent explanation!!!
Glad it was helpful!
Very useful in ageing the query data on daily basis. Thanks
Thank you for watching the tutorial and sharing your valuable comments here. Please stay in touch for more such videos on my channel.
wonderful explanation sir
Very helpful
Glad to hear that
Thanks! Very Productive!
Thanks alot for watching the video and sharing your comments. Please stay in touch for more such videos.
It’s really so helpful I learned new things.
Now It will be so helpful for me.
Thanks alot for the feedback Anjali, I am glad that video could be useful for you. Please stay tuned with my channel for more such videos.
Thanks a ton, very clean explanations. Good work
Glad it was helpful!
Interesting! Thanks
Glad you liked it! Thanks for sharing comments, please don't forget to subscribe the channel for more such videos.
fantastic class, very helpful and informative
thank you for the feedback, I am glad that it was useful.
Useful information thanks alot
thanks for watching the video and sharing your comments.
superb very easy to understand
thanks alot for the feedback, I am glad that it helped
Wonderful, I understand each and everthing.....
Thanks alot for watching the video and sharing your comments. Please stay in touch for more such videos.
Plz help..How will an amount received from a customer be deducted against an invoice within this aging report..? I mean.. I am facing this problem now.. An invoice was of Rs. 96000/- and now I have received this amount from a customer. Please tell me how to treat this transaction to update this aging report..? Plz help me..
thank you very much for very good explanation abt invoice ageing data
This video was soo useful and interesting. Well explained 🤝🏻
Thank you!
Glad you enjoyed it! and thank you very much for your comments and feedback, please do stay in touch for more such videos. Have a nice day!
Great work Suleman
appreciate your feedback, I am happy that it was useful.
Thank a lot Sir for your beautiful method of teaching ... This session has helped me a lot with my daily requirements... Thanks a ton. Regards :)
Thank you for watching the video. I am glad that it was useful and you liked it. Please stay in touch for more such videos
Plz help..How will an amount received from a customer be deducted against an invoice within this aging report..? I mean.. I am facing this problem now.. An invoice was of Rs. 96000/- and now I have received this amount from a customer. Please tell me how to treat this transaction to update this aging report..? Plz help me..
Thank you. Very clear tutorial. Fantastic.
Superb 👍
Thanks alot for the comment
Thank you very much. It helps me alot😊
Glad to hear that, stay in touch for more such videos
Thanks......It's saving time to calculate days!!!!!
thanks for your feedback, I am glad that you enjoyed the video.
Thank you so much for this. I finally found what i was looking for.
Glad I could help!
Could u plz explain me... If I'm having invoice value with date and receipt value with date... But I don't know we received some value but against which invoice don't know...
So in this case how to prepare aging report in excel......... Awaiting ur quick response.... It's urgent?
Very interesting video 👍
Thank you! very nice explanation. good
It is nice and helped me a lot. Thanks a lot.
Many thanks for the feedback , I am glad that you found it useful.
quite a helpful video !!!
Thanks
thanks alot for the feedback. I am glad that you enjoyed the video.
THANK YOU SO MUCH!
Glad it helped! Please do not forget to subscribe the channel to see more such videos.
@@ExceltoExcelE done :)
Thank you it helps a lot
Glad it helped, stay in touch for more such videos
Thanks a lot, I should not have wasted my time trying in another way.
Glad to hear that you like it. Thanks for sharing your thoughts on the video. Please stay in touch for more such videos on my channel.
Thank u.. very useful
Glad it was useful , thanks alot for watching the video, stay in touch for more.
NICE VIDEO!!
thnx . that seems so easy
I am glad you enjoyed it, thanks for your feedback.
Awesome I really liked it
wonderful, I am glad that it was helpful. many thanks for your feedback.
Thank you very useful and good music
Glad you like it!
this was very helpful, thank you!
I am glad it was helpful, thanks alot for sharing your feedback.
Excellent sir. You are super.
Nice video
Thanks alot for watching the video and sharing your valuable comments here Rizwan.
This is extremely helpful, thank you very much.
thanks for the feedback, I am glad that it was useful.
extremely helpful!! Thank you !!!
Nice👍🏻
Can we forecast the rollover overdue bucket for next month ? Please can you make a planning video on this topic. I am struggling for the right formulas. Thanks
Great! it's useful for me. Thanks !
I am glad that it was useful, thanks for sharing your feedback.
Good One Bro, Thank You Worth Watching The Video
Glad you liked it Please dont forget to subscribe my channel for more such videos.
great...I like it...
thanks for the feedback, I am glad that it was useful.
Great to see
Thank you so much for watching the video and providing feedback. Stay tuned for more such videos on my channel 🙂
So helpful
Great! thanks alot for watching the video and sharing your comments
good sir
I am just wondering I haven’t updated my MS Office…. and I don’t think I have these tabs in Excel…but a great tutorial
Thanks for watching Nisha and sharing your valuable comments here. You can go to customise you ribbon and find out if you have these tabs. Maybe worth a try.
Thanks
Useful information.
Thank you so much :)
Thanks for your comments and watching the video. Stay in tune.
@@ExceltoExcelE Plz help..How will an amount received from a customer be deducted against an invoice within this aging report..? I mean.. I am facing this problem now.. An invoice was of Rs. 96000/- and now I have received this amount from a customer. Please tell me how to treat this transaction to update this aging report..? Plz help me..
It definitely was useful, but please could you also show how to prepare it through excel formulae?
Thanks a lot, nice video. But how to show as current amount as 0 Column.
Would u plz assit how to prepare Account receivable report?
Perfect
thanks for the feedback, stay tuned for more such stuff.
Great
Thank you for watching the video. I am glad that it was useful and you liked it. Please stay in touch for more such videos
Pls can you tell me what does it mean thirty days report
30 days means report for invoices due for 30 days. This is an aging category.
@@ExceltoExcelE thank you
Thank you, am going to use this method. I have been looking for something like this to use on my debtor's age analysis. I want to build a system that would be able to notify me of any payments that are due in 30 days from the day the loan was granted, and also show those that are overdue by 10 days from the day they were due. Additionally, I want excel to automatically increase these payments that are overdue by 10 days. Do you perhaps know how one could go about building such?
I have a question. If my year end is 31st December 2018. Is 1st to 31st December considered 0-30 days, November as 31-60 days so on, going backwards.
How to remove aging once payment of particular invoice received
well, once payment is received then it will be cleared in the system therefore will not be part of this list.
Sir pls make a video of bank reconciliation statement in excel
Noted... Thank you for watching the video. I am glad that it was useful and you liked it. Please stay in touch for more such videos
hi , i need to prepare a comparision between invoice date and recipt date
i tried it but i can't group it, whats the possible reason for that, can you help
same here. can group the dates, but not the overdue numbers.
@@srodgers66 i did it afterwards ill show you how in one link
@@srodgers66 Plz help..How will an amount received from a customer be deducted against an invoice within this aging report..? I mean.. I am facing this problem now.. An invoice was of Rs. 96000/- and now I have received this amount from a customer. Please tell me how to treat this transaction to update this aging report..? Plz help me..
thank you
what excel type do you use?
I am using office 365
If I have customers invoices list with value & invoice date, customers receipt with value and date.... And some of the customers have not been adjusted with some invoices.. But we collected.. In this case how to prepare aging in excel.. Kindly suggest brother
How to change overdue date automatically if the invoice amount is paid/cleared?
Great!
Value of debts
perfect
Thanks for the note Sunny, stay in touch for more such videos on my channel
Is it possible you can give that excel file?
What to do when the customers paid?
hi could you make a video, of > how to split the day format, when there is a time, than count a days of pending ( like till the current day, today, to know how many days issue is pending and not resolved, ?) and how do you make this formula work in automatic, every-time i update the file with the new references into one consolidated file? and so that also the pivot table will be updated too? thank you :)
Plz help..How will an amount received from a customer be deducted against an invoice within this aging report..? I mean.. I am facing this problem now.. An invoice was of Rs. 96000/- and now I have received this amount from a customer. Please tell me how to treat this transaction to update this aging report..? Plz help me..
super
Plz help..How will an amount received from a customer be deducted against an invoice within this aging report..? I mean.. I am facing this problem now.. An invoice was of Rs. 96000/- and now I have received this amount from a customer. Please tell me how to treat this transaction to update this aging report..? Plz help me..
Can you help me in making a project on OD for GB certificate
can u provide this data somewhere for practice
Provide Excel file to practice for your subscribers
2:40
Thanks
This video was soo useful and interesting. Well explained 🤝🏻
Thank you!
Thanks for the note and watching the video. Please stay in touch for more such videos on my channel.
Very helpful
Glad it helped, thanks alot for watching the video and sharing your comments.