Credit/Debit Note complete data in PIVOT in Excel

Author
View profile
Last updated: 12 February 2020
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
Download XLSX 18 KB Like
Submitted by · Posted 12 February 2020 · Other files by Srinivas Chilagani · Report
Comments

Recent Files in GST

View more →
PDF

FAQs in relation to Recommendations of the 57th GST Council Meeting

14 October 2026 Download
PDF

FAQs on Reforms related to Litigation Management

13 October 2026 Download
PDF

FAQs on refund of ITC accumulated on account of inward supply of input services and capital goods

13 October 2026 Download
PDF

FAQs on Simplified Registration Schemes for ECO Sellers

10 October 2026 Download
PDF

FAQs On Cancellation of GST Registration

10 October 2026 Download
PDF

FAQs On Amendment in GST Registration

10 October 2026 Download

Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Pro Member Dhananjay PatilDhananjay PatilPro Member Rupesh SoniRupesh SoniPro Member Amit BhatkarAmit BhatkarPro Member CA. MOHIT SHARMACA. MOHIT SHARMAPro Member giriswargiriswar
Subscribe to Pro
Join an elite circle of professionals


Popular Files


  1. RBI Bulletin: October 2026
  2. RBI issues guidelines on the implementation of Leverage Ratio 2017 Standard
  3. ICAI Students' Journal - Nov 2026
  4. RTPs for CA Foundation Jan 2027 Exams
  5. RTPs for CA Intermediate Jan 2027 Exams

Latest Job Openings

View all
Company
19 October 2026
Accountant

Jari Saree Center

New Delhi

Others

View Details
Company
ARTICLESHIP 23 October 2026
Articled Trainee

J Y & CO

Hyderabad

CA Inter

View Details
Company
14 October 2026
GST & TDS ASSISTANT

AGGARWAL SANJAY & ASSOCIATES

New Delhi

B.Com

View Details
Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 07 October 2026
Article Assistant

Malhotra Rajesh & Associates

New Delhi

B.Com

View Details
Company
13 October 2026
Accountant

Zerdi & Co. Chartered Accountants

Pune

B.Com

View Details
Company
ARTICLESHIP 20 October 2026
CA ARTICLE

AMKN & CO

Noida

CA Inter

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details