M&N Business Intelligence
vw_Rule37_ITC_Reversal_Report TurboData Web Portal
Contact Us
📧 support@turbodatatool.com
📧 support@mndatasolutions.com
📱 +91-8802466356
GSTR Rule37 ITC Reversal Report
vw_Rule37_ITC_Reversal_Report
Download Excel Ask Notebook LLM Youtube Channel Website WhatsApp Back
Vendor_Creditor_Name Invoice_Bill_Number Invoice_Date Age_of_Bill_in_Days Total_Invoice_Value Pending_Payable_Amount Total_ITC_Availed Rule_37_Risk_Category Proportionate_ITC_Reversal_Liability
0 Purchase 1a/purchase 2019-01-01 2680 152,814.00 152,814.00 43,241.00 Breached 180 Days 43,241.00
1 Purchase 1a supplier 2019-01-01 2680 5,678.00 5,678.00 0.00 Breached 180 Days 0.00
2 Purchase 1b purchase 2019-01-01 2680 229,369.00 229,369.00 15,000.00 Breached 180 Days 15,000.00
3 Purchase 01a_supplier 2019-01-01 2680 16,660.00 16,660.00 0.00 Breached 180 Days 0.00
4 Purchase 01a 2019-01-01 2680 3,510.00 4,000.00 0.00 Breached 180 Days 0.00
5 SUNDRY CREDITOR 01A_PURCHASE 2019-02-01 2649 12,000.00 12,000.00 0.00 Breached 180 Days 0.00
6 Sales_ledger 10_insert 2022-08-01 1372 10,000.00 40,000.00 0.00 Breached 180 Days 0.00
7 Sales_ledger 10_insert 2022-08-01 1372 10,000.00 40,000.00 0.00 Breached 180 Days 0.00
8 Sales_ledger 10_insert 2022-08-01 1372 10,000.00 40,000.00 0.00 Breached 180 Days 0.00
9 Purchase 0 2019-01-01 2680 3,026.00 3,026.00 0.00 Breached 180 Days 0.00
10 Purchase 1a/purchase 2019-01-01 2680 152,814.00 152,814.00 43,241.00 Breached 180 Days 43,241.00
11 Purchase 1a supplier 2019-01-01 2680 5,678.00 5,678.00 0.00 Breached 180 Days 0.00
12 Purchase 1b purchase 2019-01-01 2680 229,369.00 229,369.00 15,000.00 Breached 180 Days 15,000.00
13 Purchase 01a_supplier 2019-01-01 2680 16,660.00 16,660.00 0.00 Breached 180 Days 0.00
14 Purchase 01a 2019-01-01 2680 3,510.00 4,000.00 0.00 Breached 180 Days 0.00
15 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
16 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
17 Purchase 0 2019-01-01 2680 267.00 3,026.00 0.00 Breached 180 Days 0.00
18 Purchase 9 2019-05-02 2559 0.00 204.00 0.00 Breached 180 Days 0.00
19 Purchase 0 2019-01-01 2680 5,445.00 3,026.00 0.00 Breached 180 Days 0.00
20 SUNDRY CREDITOR 01A_PURCHASE 2019-02-01 2649 12,000.00 48,000.00 0.00 Breached 180 Days 0.00
21 Purchase 0 2019-01-01 2680 68,600.00 3,026.00 0.00 Breached 180 Days 0.00
22 SUNDRY CREDITOR 01A_PURCHASE 2019-02-01 2649 12,000.00 48,000.00 0.00 Breached 180 Days 0.00
23 Purchase 0 2019-01-01 2680 68,600.00 3,026.00 0.00 Breached 180 Days 0.00
24 SUNDRY CREDITOR 01A_PURCHASE 2019-02-01 2649 12,000.00 48,000.00 0.00 Breached 180 Days 0.00
25 Purchase 0 2019-01-01 2680 68,600.00 3,026.00 0.00 Breached 180 Days 0.00
26 SUNDRY CREDITOR 01A_PURCHASE 2019-02-01 2649 12,000.00 48,000.00 0.00 Breached 180 Days 0.00
27 Purchase 0 2019-01-01 2680 68,600.00 3,026.00 0.00 Breached 180 Days 0.00
28 Purchase 0 2019-01-01 2680 45.00 3,026.00 0.00 Breached 180 Days 0.00
29 Purchase 0 2019-01-01 2680 45.00 3,026.00 0.00 Breached 180 Days 0.00
30 Purchase 0 2019-01-01 2680 45.00 3,026.00 0.00 Breached 180 Days 0.00
31 Purchase 0 2019-01-01 2680 45.00 3,026.00 0.00 Breached 180 Days 0.00
32 Purchase 0 2019-01-01 2680 11,800.00 3,026.00 0.00 Breached 180 Days 0.00
33 Purchase 0 2019-01-01 2680 16,350.00 3,026.00 0.00 Breached 180 Days 0.00
34 Purchase 0 2019-01-01 2680 100,000.00 3,026.00 0.00 Breached 180 Days 0.00
35 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
36 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
37 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
38 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
39 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
40 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
41 Purchase 9 2019-05-02 2559 204.00 204.00 0.00 Breached 180 Days 0.00
42 SUNDRY CREDITOR 1a 2019-05-02 2559 5,488.00 5,488.00 0.00 Breached 180 Days 0.00
43 Purchase 0 2019-01-01 2680 90,000.00 3,026.00 0.00 Breached 180 Days 0.00
44 Purchase 0 2019-01-01 2680 9,543.00 3,026.00 0.00 Breached 180 Days 0.00
45 Purchase 0 2019-01-01 2680 204.00 3,026.00 0.00 Breached 180 Days 0.00
46 Purchase 0 2019-01-01 2680 3,450,000.00 3,026.00 0.00 Breached 180 Days 0.00
47 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
48 Purchase 0 2019-01-01 2680 44,388,000.00 3,026.00 0.00 Breached 180 Days 0.00
49 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
50 Purchase 0 2019-01-01 2680 36,288.00 3,026.00 0.00 Breached 180 Days 0.00
51 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
52 Purchase 0 2019-01-01 2680 2,268.00 3,026.00 0.00 Breached 180 Days 0.00
53 Purchase 0 2019-01-01 2680 3,402.00 3,026.00 0.00 Breached 180 Days 0.00
54 Purchase 0 2019-01-01 2680 1,344.42 3,026.00 0.00 Breached 180 Days 0.00
55 Purchase 0 2019-01-01 2680 624.00 3,026.00 0.00 Breached 180 Days 0.00
56 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
57 Purchase 0 2019-01-01 2680 1,180.00 3,026.00 0.00 Breached 180 Days 0.00
58 Purchase 0 2019-01-01 2680 1,701.00 3,026.00 0.00 Breached 180 Days 0.00
59 101 Innovations 2 2023-07-10 1029 0.00 7,317.00 0.00 Breached 180 Days 0.00
60 Sales 2 2023-07-10 1029 0.00 40,650.00 0.00 Breached 180 Days 0.00
61 101 Innovations 2 2023-07-10 1029 0.00 7,317.00 0.00 Breached 180 Days 0.00
62 Sales 2 2023-07-10 1029 0.00 40,650.00 0.00 Breached 180 Days 0.00
63 101 Innovations 2 2023-07-10 1029 0.00 7,317.00 0.00 Breached 180 Days 0.00
64 Sales 2 2023-07-10 1029 0.00 40,650.00 0.00 Breached 180 Days 0.00
65 101 Innovations 2 2023-07-10 1029 0.00 7,317.00 0.00 Breached 180 Days 0.00
66 Sales 2 2023-07-10 1029 0.00 40,650.00 0.00 Breached 180 Days 0.00
67 Purchase 09 2019-05-02 2559 204.00 204.00 0.00 Breached 180 Days 0.00
68 SUNDRY CREDITOR 1a 2019-05-02 2559 5,488.00 5,488.00 0.00 Breached 180 Days 0.00
69 Purchase 01a 2019-01-01 2680 490.00 4,000.00 0.00 Breached 180 Days 0.00
70 Sales_ledger 10_insert 2022-08-01 1372 10,000.00 40,000.00 0.00 Breached 180 Days 0.00
71 Purchase 0 2019-01-01 2680 7,884.00 3,026.00 0.00 Breached 180 Days 0.00
72 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
73 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
74 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
75 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
76 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
77 Purchase 01a 2019-01-01 2680 490.00 4,000.00 0.00 Breached 180 Days 0.00
78 Purchase 0 2019-01-01 2680 900.00 3,026.00 0.00 Breached 180 Days 0.00
79 Purchase 0 2019-01-01 2680 616.40 3,026.00 0.00 Breached 180 Days 0.00
80 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
81 Purchase 0 2019-01-01 2680 -10,000.00 3,026.00 0.00 Breached 180 Days 0.00
82 Sales_ledger 10_insert 2022-08-01 1372 10,000.00 70,000.00 0.00 Breached 180 Days 0.00
83 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
84 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
85 Purchase 0 2019-01-01 2680 -10,000.00 3,026.00 0.00 Breached 180 Days 0.00
86 Sales_ledger 10_insert 2022-08-01 1372 10,000.00 70,000.00 0.00 Breached 180 Days 0.00
87 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
88 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
89 Purchase 0 2019-01-01 2680 -10,000.00 3,026.00 0.00 Breached 180 Days 0.00
90 Sales_ledger 10_insert 2022-08-01 1372 10,000.00 70,000.00 0.00 Breached 180 Days 0.00
91 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
92 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
93 Purchase 0 2019-01-01 2680 -10,000.00 3,026.00 0.00 Breached 180 Days 0.00
94 Sales_ledger 10_insert 2022-08-01 1372 10,000.00 70,000.00 0.00 Breached 180 Days 0.00
95 Aadinath Electrical eaf 2023-04-01 1129 4,795.35 4,795.35 228.35 Breached 180 Days 228.35
96 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
97 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
98 Purchase 0 2019-01-01 2680 -10,000.00 3,026.00 0.00 Breached 180 Days 0.00
99 Sales_ledger 10_insert 2022-08-01 1372 10,000.00 70,000.00 0.00 Breached 180 Days 0.00
100 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
101 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
102 Purchase 0 2019-01-01 2680 -10,000.00 3,026.00 0.00 Breached 180 Days 0.00
103 Sales_ledger 10_insert 2022-08-01 1372 10,000.00 70,000.00 0.00 Breached 180 Days 0.00
104 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
105 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
106 Purchase 0 2019-01-01 2680 -10,000.00 3,026.00 0.00 Breached 180 Days 0.00
107 Sales_ledger 10_insert 2022-08-01 1372 10,000.00 70,000.00 0.00 Breached 180 Days 0.00
108 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
109 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
110 Purchase 0 2019-01-01 2680 0.00 3,026.00 0.00 Breached 180 Days 0.00
111 Purchase 0 2019-01-01 2680 890.00 3,026.00 0.00 Breached 180 Days 0.00
112 FIRST LEDGER NAME OUS 2024-07-31 642 986.00 986.00 -1,117.00 Breached 180 Days -1,117.00
Tip: Use Ctrl+F to search within the table. Scroll horizontally for wide reports.