SMQAMARUDDIN
New member
pls help how we prepare aging in excel 2013
[Answered] How to prepare aging
- Thread starter SMQAMARUDDIN
- Start date
This thread is solved
SMQAMARUDDIN
New member
i am unable to prepare the aging calculation pls help.
Hello SMQAMARUDDIN,
Thanks for sharing your problem with us. I understand that you want to prepare an Ageing Report from the attached Ledger Balance report. To prepare an Ageing Report, apart from the data you provided, we require Activity/Customer Details, Invoice Days, or Due Dates and a list of the Ageing Buckets. Update the data table with these required fields.
Thanks for sharing your problem with us. I understand that you want to prepare an Ageing Report from the attached Ledger Balance report. To prepare an Ageing Report, apart from the data you provided, we require Activity/Customer Details, Invoice Days, or Due Dates and a list of the Ageing Buckets. Update the data table with these required fields.
Here is a list of a few helpful articles related to your task.
- How to Create Ledger Balance Sheet in Excel
- How to Make a Vendor Ledger Reconciliation Format in Excel
- How to Create Debtors Ageing Report in Excel Format
- How to Use IF Formula for Aging Buckets in Excel
You can use these articles to solve your problem or share the updated data table with us to get the solution to your problem.
Regards,
Seemanto Saha
ExcelDemy