Credit/Debit Note complete data in PIVOT in Excel
Srinivas Chilagani
Author
Quick Summary
File details
File description
Steps to PIVOT table type report:
1.Copy the CDNR from A7 cell to data end and past it at A3 cell in DATA sheet of downloaded excel format (Do it month-wise)
2. Fill with 0(Zero) in empty cells in DATA sheet by FIND & REPLACE (CTRL+F) with option
3. Delete INVOICE TOTAL lines rows & 0 filled rows by using filters
4. Go to SUMMARY SHEET, select OPTIONS menu, click on REFRESH button
5. see the report #xlsx
Comments
Recent Files in GST
View more →Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
Popular Files
- GST RET-1 Return: Monthly and Quarterly Filing Formats
- CA Final Financial Reporting (FR) Paper New Course Nov 2026
- RBI Releases India's Balance of Payments Data for Sept 2026
- RBI Announces TCCFM to Review Money, Forex and Government Securities Markets
- Monthly Economic Review - Oct 2026
- RBI Draft Guidelines on Priority Sector Lending: Consolidation of Instructions
- MoSPI Releases October 2026 CPI Data
- PAN CR-01: PAN Card Correction Form
- Revision of Rate of Aadhaar PVC Card Service
- PAN CR-02: PAN Card Correction Form
CAclubindia
