Credit/Debit note consolidation & party wise report in Excel

Last updated: 27 January 2020

Save Share

Quick Summary

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.

File details

XLSX 60 KB 0 downloads GST

File description

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

Download XLSX 60 KB Like

Submitted by Srinivas Chilagani · Posted 27 January 2020 · Other files by Srinivas Chilagani · Report

Comments