Download Excel Pivot Table: Credit/Debit Notes Data

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 1 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 Srinivas Chilagani · Posted 12 February 2020 · Other files by Srinivas Chilagani · Report

Comments