Download Files uploaded by Srinivas Chilagani

18 KB

Credit/Debit Note complete data in PIVOT in Excel

Credit/Debit Note complete data in PIVOT in Excel

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. De...

Posted on 12 February 2020 (Downloads: 840) GST

60 KB

Credit/Debit note consolidation & party wise report in Excel

This excel file gives you the Credit/Debit Notes Consolidation with tax rate wise and Party wise report. 1.Download your 2A 2.Copy the Entire CDNR sheet paste into DUMP sheet(Do it month). 3.Copy the entire DUMP sheet paste into CDNR sheet of this file. S...

Posted on 27 January 2020 (Downloads: 907) GST