This Excel file provides a detailed consolidation of credit and debit notes, broken down by supplier and counterparty. It includes essential information such as GSTIN, note details, tax breakdowns (IGST, CGST, SGST, Cess), and consolidation summaries for both credit and debit notes. This report is invaluable for accountants, finance professionals, and businesses needing to track and manage their credit and debit note transactions efficiently.
This excel file gives you the Credit/Debit Notes Consolidation with tax rate wise and Party wise report. 1.Download your 2A 2.Copy the Entire CDNR sheet paste into DUMP sheet(Do it month). 3.Copy the entire DUMP sheet paste into CDNR sheet of this file. See the Result. It also gives the previous FY data also. If you want particular FY data remove the lines from DUMP sheet before past into CDNR sheet. Thank you. Please give your valueble advices, if any #xlsx