Credit/Debit Note complete data in PIVOT in Excel


Quick Summary
This Excel file provides a comprehensive breakdown of credit and debit note data, organised into a user-friendly Pivot Table. It includes essential details such as supplier information, tax rates, taxable values, note types, dates, and tax amounts (IGST, CGST, SGST, Cess). This resource is perfect for accountants, bookkeepers, and businesses needing to efficiently analyse and report on financial credit and debit adjustments.

File details
XLSX 18 KB 0 downloads GST
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


CCI Pro


Popular Files


Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
12 November 2026
Auditor

Oz Taxation

Vijayawada

Graduate (Any)

View Details