Debtor analysis statement
This query is : Resolved
01 November 2011
Please provide me a debtor ageing analysis for the period upto june and upto Sept
01 November 2011
see by this link in tally
http://www.tallysolutions.com/website/CHM/TallyERP9/05_REPORTS/Management_Information_System_(MIS)_Reports/02_Display_Receivables/Ageing_Analysis_Report.htm
http://www.tallysolutions.com/website/CHM/TallyERP9/05_REPORTS/Management_Information_System_(MIS)_Reports/02_Display_Receivables/Ageing_Analysis_Report.htm
01 November 2011
formula for excel is
=LOOKUP(TODAY()-C7,{0,31,61,91;"0-30","31-60","61-90","90-120"})&" days"
=LOOKUP(TODAY()-C7,{0,31,61,91;"0-30","31-60","61-90","90-120"})&" days"
01 November 2011
Download file from this link
https://www.caclubindia.com/share_files/agewise-sundry-debtors-in-excel-24299.asp
https://www.caclubindia.com/share_files/agewise-sundry-debtors-in-excel-24299.asp
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Is this income indian or foreign income?
- REGARDING GST ON COMMERICIAL PROPERTY
- 15ca /15cb whose income tax login? remitter or nri seller's login?
- GST on export of services and Input Credit
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- TDS U/S. 194NF
- ITC temporary reversal and reclaim
- Regarding Documentation & Compliances for Opening of Unit of Pvt Ltd.
- Applicable TDS rate for sale of property in Nov 2024
- Can we claim ITC of Feb-2024 in the month of November-2024 which was not claimed by oversight
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
- Regarding einvoice taken on nil rated sales
- Strategical investment in Public listed company
Trending Online Classes
CAclubindia
