xlsx

Credit/Debit Note complete data in PIVOT in Excel

  Download   Preview

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
Srinivas Chilagani

on 12 February 2020

Other files by the user
869 times
18 KB

Download Other files in GST category


Share Report
Comments

CAclubindia's WhatsApp Groups Link


Trending Downloads

pdf
Income Tax Act 2025
On : 22 August 2025
Download
pdf
Taxation Laws Amendment Act 2025
On : 22 August 2025
Download
pdf
Procedure to Strike-Off LLP in India and Formats
On : 19 August 2025
Download
pptx
Avoidance/PUFE Forensics under IBC
On : 19 August 2025
Download

view more



CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Trending Online Classes

view all classess

Follow us
OR add as source on Google news

Popular Files


  1. ICAI Releases Practical Guide to GST Disputes
  2. DPR Format in Excel
  3. Block Credit under GST
  4. IND AS - A Deep Dive
  5. Income Tax Act 2025
  6. Taxation Laws Amendment Act 2025
  7. Procedure to Strike-Off LLP in India and Formats
  8. Avoidance/PUFE Forensics under IBC