SALES RETURN ACCOUNTING FLOW
Invoice Generation Commercial
100000 311001 311001 311001 261993 261993 262410
Tata Motors Limited Sales Dom-Manufactur Sales Dom-Manufactur Sales Dom-Manufactur ED Collection A/C ED Collection A/C VAT Payable
DEBIT CREDIT DEBIT CREDIT CREDIT CREDIT CREDIT
668.48 (437.20) 7.00 (80.00) (82.00) (2.00) (74.28)
Excise Document for sales
261993 ED Collection A/C 262461 E Duty Payable-DTA 262462 E.Ces-ED payable DTA
DEBIT CREDIT CREDIT
84.00 (82.00) (2.00)
Deduction in the payment Advice
Un-resolved Customer Deductions 100000 Tata Motors Limited
DEBIT CREDIT
668.48 (668.48)
Receipt of Sales return at TF from Customer
311001 311001 311001 261993 261993 262410
CREDIT DEBIT CREDIT DEBIT DEBIT DEBIT CREDIT
437.20 (7.00) 80.00 82.00 2.00 74.28 (668.48)
After the quality oks the rejection
254707 Excise Duty-RG23A 254708 Education Cess-RG23A 261993 Cenvat Clearing A/C
DEBIT DEBIT CREDIT
82.00 2.00 (84.00)
Sales Dom-Manufactur Sales Dom-Manufactur Sales Dom-Manufactur Cenvat Clearing A/C Cenvat Clearing A/C VAT Payable Un-resolved Customer Deductions
Any difference in the ED on the customer return invoice 412901 Price Difference - FG Materials 452024 Excise Duty Expenses Account Un-resolved Customer Deductions
DEBIT DEBIT CREDIT
difference difference difference
TRANSACTION DETAILS
GLCode
Description
Amt.
MOVEMENT PORPOSED TYPE ACCOUNTS
Sale of Manufactured items to Domestic Customer (Sales Contract No. (Sales Order No. OEMs 153) Create Outbound Delivery Delv Doc OEMs 80000170 for 20 QTY. Picking up the quantity and Post Goods Issue
VL01N 251301 Inventory-FG -561.2 412002 COGS-FG Domestic 561.2 (Billing Doc. 91100026, A/C Doc. 4900000090)
Invoice Generation Commercial
100000 Tata Motors Limited 311001 Sales Dom-Manufactur 311001 Sales Dom-Manufactur 311001 Sales Dom-Manufactur 261993 ED Collection A/C 261993 ED Collection A/C 262410 VAT Payable (A/C Doc. 911000026)
Excise Document for sales
261993 ED Collection A/C 262461 E Duty Payable-DTA 262462 E.Ces-ED payable DTA (A/C doc. 10000011)
84 -82 -2
Cancellation of Excise Invoice
261993 ED Collection A/C 262461 E Duty Payable-DTA 262462 E.Ces-ED payable DTA (A/C doc. 10000014)
-84 82 2
100000 Tata Motors Limited 311001 Sales Dom-Manufactur 311001 Sales Dom-Manufactur 311001 Sales Dom-Manufactur 311001 Sales Dom-Manufactur 261993 ED Collection A/C 262410 VAT Payable (A/C doc. No. 911000027)
143.49 109.301.75 20.0020 20.0015.94-
100000 Tata Motors Limited 311001 Sales Dom-Manufactur 311001 Sales Dom-Manufactur 311001 Sales Dom-Manufactur 261993 ED Collection A/C 261993 ED Collection A/C 262410 VAT Payable (A/C doc. No. 911000028) What about Excise Entry
-1,668.95 1,093.00 -17.49 200 204 4 185.44
Sales Return
Change of Storage location of returned inventory s
Sales to KH Logistics Creation of Sales Order No. 157 Delv Doc. 80000178 Billing Doc 912000015
251301 Inventory-FG 412002 COGS-FG Domestic
VL02N
668.48 VF01 -437.2 Basic 7 Discount 1.6% only on basic -80 Amortization -82 ED after taking into consideration of all the three Rs -2 -74.28 VAT calculated on amortization ### amount also
561.2 -561.2
Excise Invoice 1300000010
Sale of goods from KH to Ford
100010 Ford Espana SA 312001 Sales Exports-Manfr
3.88 -3.88
Order Type ZDOR
nt 1.6% only on basic
Remarks Multiple Payment terms for single Customer sales In Sales Order fields to be updated only 2, posting date and Quantity Sales return Segregation of Duties to create Sos. Credit note for warranty Discount Dispatch Advice to be prepared Sale of scrap Physical Document for Dispatch Advice required to facilitate physical Sale picking of Fixed up the Assets goods Foreign Exchange gain / loss excise sales tax freight Invoice cif/fob customer returns - scrap or salvage Supplementory Invoice for rate difference
r taking into consideration of all the three Rs. 510.2/-
Manufacturing Domestic Sales Manufacturing Export Sales Trading Exports Engineering Services Deemed Exports - with VAT EOU Sales Sale of Fixed Assets Tooling Sales Stock Transfer
Invoice reversed but document flow is not proper i.e. documents are not linked
What is this entry not able to understand
How to update invoice reference at the time of Sales Return Goods sent 20 QTY. but at the time of return System is accepting 50 QTY. Excise Duty on return should be captured as per customer invoice
453
The Original no. of the dispatch document to KH should appear in the sales order when it is created at KH
ACCOUNTING ENTRIES FOR STOCK TRANSFER FROM EOU TO DTA IT WILL BE TREATED AS SALE - PURCHASE TRANSACTION A SALE TO DTA (IN THE BOOKS OF EOU - 1203) 1 Post Goods Issue 412001 Cost of Goods Sold - Raw Material 251001 Inventory - RM
DR CR
2 Commercial Invoice
New New
DTA 2 Plant (Customer) 412001 Cost of Goods Sold - Raw Material 261993 ED Collection A/C 261995 Customs Collection A/C 261993 ED Collection A/C 261995 Customs Collection A/C
DR CR CR CR CR CR
CVD+AD BCD CVD CESS CUST CESS
DR DR DR DR CR
CVD+AD BCD CVD CESS CUST CESS BCD+CVD+AD+CVD Cess+Cust Ce
251101 Inventory - Raw Material 261902 GR/IR Clearing
DR CR
Cost+Customs+Cust Cess Cost+Customs+Cust Cess
254707 Excise Duty-RG23A 254708 Education Cess-RG23A 261992 CVD Clearing A/C
DR DR CR
CVD+AD CVD Cess CVD+CVD Cess+AD
261902 GR/IR Clearing 261992 CVD Clearing EOU Plant (Vendor)
DR DR CR
Cost+Customs+Cust Cess CVD+CVD Cess+AD
3 Excise Invoice
New New
261993 ED Collection A/C 261995 Customs Collection A/C 261993 ED Collection A/C 261995 Customs Collection A/C 262466 Customs Duty Payable EOU
B PURCHASE FROM EOU (IN THE BOOKS OF DTA 2 - 1202) 1 MIGO (GR)
2 Part II
3 MIRO (IV)
D+AD+CVD Cess+Cust Cess
toms+Cust Cess toms+Cust Cess
toms+Cust Cess
MODULE
PARTICULARS
SD
VOLUMES GIVEN TO PP FOR MRP
PP
MRP GENERATION
MM
GENERATION OF PO
MM
CREATION OF GR
ACCOUNT CODE
251105 261902 254707 254708 261991
FI
INVOICE VERIFICATION BY FINANCE
QA
QUALITY INSPECTION OF GR
QA
REJECTION BY QUALITY - PRIMARY
MM
GOODS SENT BACK TO VENDOR AGAINST PRIMARY REJECTION
MM
ISSUE OF MATERIAL TO PRODUCTION
251101 261902
ACCOUNTING ENTRY
DEBIT
CREDIT
TRANSACTION CODE
CREDIT
MIGO / MB51 MIGO / MB51
CREDIT
MB51 / FB03 MB51 / FB03 MB51 / FB03
NO ACCOUNTING ENTRY NO ACCOUNTING ENTRY NO ACCOUNTING ENTRY Inventory-Traded Gds GR/IR Clrng-Domestic
DEBIT
Excise Duty-RG23A Education Cess-RG23A Cenvat Clearing A/C
DEBIT DEBIT
MIRO
NO ACCOUNTING ENTRY Inventory-Rw Mat-Dom GR/IR Clrng-Domestic
CREDIT DEBIT
MB51 / FB03 MB51 / FB03
MOVEMENT TYPE
101 101 101 101 101
321 122 122
TRANSACTION DETAILS
MOVEMENT TYPE
Sending of Goods to Subcontractor (under 57 F(4))
No Accounting Document.
Goods Received from Subcontractor
Inventory-WIP GR/IR Clrng-Domestic Inventory-Rw Mat-Dom
5,177.50 (3,670.00) (1,507.50)
Change in stck-Masop Sub Contractor Chrgs Cons-Mat-SubContract
(5,177.50) 3,670.00 1,507.50
Invoice Verification of Subcontract Bill
NEW COAT PVT LTD GR/IR Clrng-Domestic VAT Recvble A/C
(4,128.75) 3,670.00 458.75
Reversal of excise duty under 57F4 after lapse of 180 days.
Excise Duty-RG23A Education Cess-RG23A 57F4 Clearing A/C
(241.20) (4.82) 246.02
Receipt of material after 180 days without processing
Excise Duty-RG23A Education Cess-RG23A 57F4 Clearing A/C
120.60 2.41 (123.01)
542 542 542
PORPOSED ACCOUNTS Separate Stores Location Should be configered. All the other locations are to be blocked for this transaction. Delivery note no can be duplicated. MIRO can be made only for one such challan and mannual
Service tax to be configured in vendor master
Requirements to be maintained in Master Data of Vendor Chapter ID Material Chapter ID Combination Material Assessable Value Vendor Excise Details Excise Tax Rate Entry will be passed only if reversal of excise duty is made after 180 days.
TRANSACTION DETAILS Sending of Goods to Subcontractor (with excise duty)
E Duty Payable-DTA ED Collection A/C E.Ces-ED payable DTA ED Collection A/C
(96.00) 96.00 (2.00) 2.00
(Being 100 MTR uncoated conduit sent to subcontractor 100000087) VENDOR A/C 98.00 MASOP ED COLLECTION (98.00) (Being recovery of excise duty from subcontractor) Goods Received from Subcontractor
Inventory-WIP GR/IR Clrng-Domestic Inventory-WIP
576.63 (128.00) (448.63)
Change in stck-Masop (576.63) Sub Contractor Chrgs 128.00 Cons-Mat-SubContract 448.63 (Being 80 MTR uncoated conduit received from subcontractor 55000000092) Invoice Verification of Subcontract Bill
SONALI PLASTIC INDUSTRIES (255.63) GR/IR Clrng-Domestic 128.00 Cenvat Clearing A/C 97.28 Cenvat Clearing A/C 1.95 VAT Recvble A/C 28.40 (Being Invoice Verification done for material received from subcontractor 510000030)
Rejection due to subcontractor processing after receipt
Inventory-WIP (464.63) GR/IR Clrng-Domestic 16.00 Change in stck-Masop 464.63 Sub Contractor Chrgs (16.00) Inventory-WIP 448.63 Cons-Mat-SubContract (448.63) (Being 10 MTR coated conduit rejected at TF 55000000093)
Inventory-WIP (64.11) Scrap Cost Account 64.11 (Being 10 mtrs of coated conduit scrapped Doc no. 490000076)
MOVEMENT TYPE
PORPOSED ACCOUNTS
MASOP ED COLLECTION
ntractor 100000087) Proposed Entry
Calculation of Excise Duty should be automated Base Value Field should be the correct assessable value
ubcontractor 55000000092) TDS on the transaction is not getting calculated
ived from subcontractor 510000030) 922 922 922 922 922 922
551 551
o. 490000076) 5.58
100
8.78
100
movement type movement description 101 GR goods receipt 102 GR for PO reversal 103 GR into blocked stck 104 GR to blocked rev. 105 GR from blocked stck 106 GR from blocked rev. 121 GR subseq. adjustm. 122 RE return to vendor 123 RE rtrn vendor rev. 124 GR rtrn blocked stck 125 GR rtn blkd stck rev 131 Goods receipt 132 Goods receipt reversal 141 GR G subseq. adjustm 142 GR G subseq. adjustm 161 GR returns 162 GR rtrns reversal 201 GI for cost center 202 RE for cost center 221 GI for project 222 RE for project 231 GI for sales order 232 RE for sales order 241 GI for asset 242 RE for asset 251 GI for sales 252 RE for sales 261 GI for order 262 RE for order 281 GI for network 282 RE for network 291 GI all acc. assigmts 292 RE all acct assigmts 301 TF trfr plnt to plnt 302 TR trfr plnt to plnt 303 TF rem.fm stor.to pl 304 TR rem.fm stor.to pl 305 TF pl.in stor.in pl. 306 TR pl.in stor.in pl. 309 TF tfr ps.mat.to mat 310 TR tfr ps.mat.to mat 311 TF trfr within plant 312 TR transfer in plant 313 TF rem.fm str.toSLoc 314 TR rem.fm str.toSLoc 315 TF pl.in str.in SLoc 316 TR pl.in stor.inSLoc 317 Create struct. mat. 318 RE create struc. mat
control 1 1 1 1
1 1
1 1
1 1
1 1
1 1
1 1 1 1
319 Split structured mat 320 RE split struct.mat. 321 TF quality to unrest 322 TR quality to unr. 323 TF quality in plant 324 TR quality in plant 325 TF blocked in plant 326 TR blocked in plant 331 GI to sampling QI 332 RE to sampling QI 333 GI to sampling unre. 334 RE to sampling unre. 335 GI to sampl. blocked 336 RE to sampling blkd 340 Batch revaluation 341 TF unrestr.to restr. 342 TF rstricted to unr. 343 TF blocked to unre. 344 TR blocked to unre. 349 TF blocked to QI 350 TR blocked to QI 351 TF to stck in trans. 352 TR to stck in trans. 411 TF SLoc to SLoc 412 TR SLoc to SLoc 413 TF SLoc to sls order 414 TR SLoc to sls order 415 TF SLoc to project 416 TR SLoc to proj. 441 TP unrstr.to tiedEmp 442 TP tiedEmp.to unrstr 451 GI returns 452 RE returns reversal 453 TP returns to own 454 TP own to returns 455 TF st. trfr returns 456 TR st. trfr returns 457 TP Returns to own QI 458 TP Own QI to returns 459 TP Ret. to own blckd 460 TP Own blckd to ret. 501 Receipt w/o PO 502 RE receipt w/o PO 503 Receipt to QI 504 RE receipt to QI 505 Receipt to blocked 506 RE receipt to blockd 511 Delivery w/o charge 512 RE deliv. w/o charge 521 Receipt w/o order 522 RE receipt w/o prOrd 523 Rcpt QI w/o prOrder
1 1
1 1
524 RE quality w/o prOrd 525 Rcpt blkd w/o pr.ord 526 RE blocked w/o PrOrd 531 Receipt by-product 532 RE by-product 541 GI whse to subc.stck 542 RE subctrStck toWhse 543 GI issue sls ord.st. 544 GI receipt sls or.st 545 Rcpt SC by-product 546 GI issue SC by-prod. 551 GI scrapping 552 RE scrapping 553 GI scrapping QI 554 RE scrapping QI 555 GI scrapping blocked 556 RE scrapping blocked 557 GI adjust. transit 558 GI adjust. transit 561 Init.entry of stBal. 562 RE in.entry stk bals 563 Init. entrStBals: QI 564 RE ent.st.bals: QI 565 In.ent.stBals: blckd 566 RE ent.stBals: blckd 571 Receipt assembly 572 RE receipt assembly 573 Rcpt QI assembly 574 RE rcpt QI assembly 575 Rcpt blckd assmbly 576 RE rcpt blkd assmbly 581 Rcpt by-prod network 582 RE by-prod. network 601 GD goods issue:delvy 602 RE goods deliv. rev. 603 TF rem.fm stor.to pl 604 TR rem.fm stor.to pl 605 TF pl.in stor.in pl. 606 TR pl.in stor.in pl. 621 GI ret.pack.:lending 622 GI ret.pack:ret.del. 623 GI iss:cust.ret.pack 624 GI rcpt:cust.re.pack 631 GI consgmt: lending 632 GI consgmt:ret.delvy 633 GI iss: cust.consgmt 634 GI rcpt:cust.consgmt 635 TF consgmt lending 636 TR consgmt ret. del. 641 TF to stck in trans. 642 TR to stck in trans. 643 TF to cross company
1 1
1 1
1
1 1
1 1
1 1
6A1 6A2 6A3 6A4 6A5 6A6 6A7 6A8 6B1 6B2 6B3 6B4 6B5 6B6 6B7 6B8 6K5 6K6 6W5 6W6
644 TR to cross company 645 TF cross company 646 TR cross company 647 TF to stck in trans. 648 TR to stck in trans. 651 GD ret.del. returns 652 GD ret.del. retn rev 653 GD returns unrestr. 654 GD returns unr. rev. 655 GD returns QI 656 GD returns QI rev. 657 GD returns blocked 658 GD returns blk. rev. 661 GI returns to vendor 662 RE ret. to vdr revrs 671 TR to stck in trans. 672 TF to stck in trans. 673 TF to cross company 674 TR to cross company 675 TR cross company 676 TF cross company 677 TR to stck in trans. 678 TF to stck in trans. TF GI1 TR GI1 TF CC GI1 TR CC GI1 TF CC GI1 TR CC GI1 TF GI1 TR GI1 TF GI2 TR GI2 TF CC GI2 TR CC GI2 TF CC GI2 TR CC GI2 TF GI2 TR GI2 TF GI2 consi TR GI2 consi TF GI1 consi TR GI1 consi 701 GR phys.inv.: whse 702 GI phys.inv.: whse 703 GR phys.inv: QI 704 GI phys.inv: QI 707 GR phys.inv.:blocked 708 GI phys.inv.:blocked 711 GI InvDiff.:whouse 712 GR InvDiff.:wrhouse 713 GI InvDiff: QI
1
1 1 1 1
714 GR InvDiff: QI 715 GI InvDiff.:returns 716 GR InvDiff.:returns 717 GI InvDiff.: blocked 718 GR InvDiff.: blocked 721 SlsVal.rec.n.afftMgs 722 SlsVal.iss.n.afftMgs 731 SlsVal.rec. afftgMgs 732 SlsVal.iss. afftgMgs 841 842 843 844 922 RE return to vendor 923 RE rtrn vendor rev. 941 GI whse to subc.stck 942 RE subctrStck toWhse 951 GI scrapping Ven Acc 952 RE scrapping Ven Acc 961 Scrap Stock Increase 962 Scrap Stock Decrease
1 1 1 1
TRANSACTION DETAILS Scrapping of FG before transfer to BSR
Inventory-FG Scrap Cost Account
(140.30) 140.30
(Being 5 units of scrapped Doc no. 490000072) Dismantelling of stock in Blocked stock
Inventory-FG Cost Of Prodn-FG Inventory-Rw Mat-Dom Consump-Raw Mat Dom Inventory-Rw Mat-Dom Consump-Raw Mat Dom Inventory-Rw Mat-Dom Consump-Raw Mat Dom Inventory-Rw Mat-Dom Consump-Raw Mat Dom Inventory-Rw Mat-Dom Consump-Raw Mat Dom Inventory-Rw Mat-Dom Consump-Raw Mat Dom Inventory-Rw Mat-Dom Consump-Raw Mat Dom Inventory-Rw Mat-Dom Consump-Raw Mat Dom Inventory-Rw Mat-Dom Consump-Raw Mat Dom Inventory-Rw Mat-Dom Consump-Raw Mat Dom Inventory-Rw Mat-Dom Consump-Raw Mat Dom
(1,262.70) 1,262.70 213.30 (213.30) 108.90 (108.90) 108.90 (108.90) 530.10 (530.10) 24.49 (24.49) 25.20 (25.20) 28.80 (28.80) 50.40 (50.40) 85.50 (85.50) 41.40 (41.40) 13.50 (13.50)
MOVEMENT TYPE 553 553
Transaction Details
GL Code
Accounting Entries
Creation of PO with Exchange Rate Rs. 44.17/EURO
No accounting Entries
Creation of Inbound Delivery (document No. 1000000326 for 2000 QTY.)
No accounting Entries
Amt.
Payment of Advance Custom Duty
F90033 FREIGHT SYSTEMS - DUTY ADVANCE (3824.55) 261994 Customs Clearing A/C 1301.35 261992 CVD Clearing A/C 1873.95 261992 CVD Clearing A/C 547.51 261994 Customs Clearing A/C 64.26 261992 CVD Clearing A/C 37.48 (Payment of Advance Custom Duty thru Doc. No. 5100000035)
Payment of Custom Duty
F90033 FREIGHT SYSTEMS - DUTY ADVANCE 253201 TF-HDFC-BD A/C Pmnt (Payment of Excise Duty thru Doc. No. 2000000015)
3824.55 (3824.55)
Goods receipt at Factory 1500 Qty.
251101 Inventory-Rw Mat-Dom 261902 GR/IR Clrng-Domestic 261904 Freight Clrng CG-Dom 261904 Freight Clrng CG-Dom 261994 Customs Clearing A/C 261994 Customs Clearing A/C 261994 Customs Clearing A/C (Receipt of Material at factory thru doc no. 5000000105) Mat Doc. 1000000327
8310.75 (6128.59) (325.54) (22.79) (976.01) (809.62) (48.20)
Part II entry
254714 ED - Additional 254707 Excise Duty-RG23A 254708 Education Cess-RG23A 261992 CVD Clearing A/C (Availment of Cenvat Credit thru Doc. No. 1000000097)
410.63 1,405.46 28.11 -1,844.20
Goods receipt at Factory balance 500 Qty.
251101 Inventory-Rw Mat-Dom 261902 GR/IR Clrng-Domestic 261904 Freight Clrng CG-Dom 261904 Freight Clrng CG-Dom 261994 Customs Clearing A/C 261994 Customs Clearing A/C 261994 Customs Clearing A/C (Receipt of Material at factory thru doc no. 5000000106) Mat Doc. 1000000328
2,770.24 (2042.86) (108.51) (7.60) (325.34) (269.87) (16.06)
Part II entry
254714 ED - Additional 254707 Excise Duty-RG23A 254708 Education Cess-RG23A 261992 CVD Clearing A/C (Availment of Cenvat Credit thru Doc. No. 1000000098)
136.88 468.49 9.37 (614.74)
Payment of Advance Custom Duty
F90033 FREIGHT SYSTEMS - DUTY ADVANCE 261994 Customs Clearing A/C 261992 CVD Clearing A/C 261992 CVD Clearing A/C 261994 Customs Clearing A/C 261992 CVD Clearing A/C 261994 Customs Clearing A/C 261992 CVD Clearing A/C
(2678.55) 263.33 379.19 110.79 13.00 7.58 86.06 123.93
261992 CVD Clearing A/C 36.21 261994 Customs Clearing A/C 4.25 261992 CVD Clearing A/C 2.48 261994 Customs Clearing A/C 367.20 261992 CVD Clearing A/C 528.77 261992 CVD Clearing A/C 154.49 261994 Customs Clearing A/C 18.13 261992 CVD Clearing A/C 10.58 261994 Customs Clearing A/C 194.82 261992 CVD Clearing A/C 280.54 261992 CVD Clearing A/C 81.97 261994 Customs Clearing A/C 9.62 261992 CVD Clearing A/C 5.61 (Booking for Payment of Advance Custom Duty thru Doc. No. 5100000038) Payment of Custom Duty
F90033 FREIGHT SYSTEMS - DUTY ADVANCE 253201 TF-HDFC-BD A/C Pmnt (Payment of Custom Duty thru Doc. No. 2000000016)
Goods receipt at Factory
251101 Inventory-Rw Mat-Dom 261902 GR/IR Clrng-Domestic 261904 Freight Clrng CG-Dom 261994 Customs Clearing A/C 261994 Customs Clearing A/C 251101 Inventory-Rw Mat-Dom 261902 GR/IR Clrng-Domestic 261904 Freight Clrng CG-Dom 261994 Customs Clearing A/C 261994 Customs Clearing A/C 251101 Inventory-Rw Mat-Dom 261902 GR/IR Clrng-Domestic 261904 Freight Clrng CG-Dom 261994 Customs Clearing A/C 261994 Customs Clearing A/C 251101 Inventory-Rw Mat-Dom 261902 GR/IR Clrng-Domestic 261904 Freight Clrng CG-Dom 261994 Customs Clearing A/C 261994 Customs Clearing A/C (Goods receipt thru doc. No. 5000000108)
Part II Entry
254714 ED - Additional 254707 Excise Duty-RG23A 254708 Education Cess-RG23A 261992 CVD Clearing A/C 254714 ED - Additional 254707 Excise Duty-RG23A 254708 Education Cess-RG23A 261992 CVD Clearing A/C 254714 ED - Additional 254707 Excise Duty-RG23A 254708 Education Cess-RG23A 261992 CVD Clearing A/C 254714 ED - Additional 254707 Excise Duty-RG23A 254708 Education Cess-RG23A 261992 CVD Clearing A/C (Availment of Cenvat Credit thru Doc. No. 1000000100)
2,678.55 2,678.55-
1648.25 (1358.23) (13.69) (263.33) (13.00) 538.64 (443.91) (4.42) (86.06) (4.25) 2298.33 (1894.01) (18.99) (367.20) (18.13) 1219.47 (1004.87) (10.16) (194.82) (9.62)
110.79 379.19 7.58 -497.56 36.21 123.93 2.48 -162.62 154.49 528.77 10.58 -693.84 81.97 280.54 5.61 -368.12
44.17 Movement Type/ T Code
Remarks PO No. 1101600003
103
MIRO
f110
105/MIGO
j1iex
105/MIGO
j1iex
Used for identification of Goods in transit MIGO should not be performed without payment of duty. Document gets blocked for payment due to 'R' Invoice Verification Chech T- Code MRBR to know the reason for blocked invoices Scenario for payment of RD to be checked Scenario for payment of SVB to be checked
How to issue DD in favour of Custom Dept.
Only Capture the invoice No Part II entry
oc. No. 5100000038)
MIGO
Transaction Details
GL Code
Accounting Entries
Creation of PO for Capital Assets with separate Material No. for each asset (PO No. 1101670004)
No Accounting entries
Inbound Delivery
No Accounting entries
Advance Payment of Custom Duty
Amt.
Movement Type/ T Code
103
F90033 FREIGHT SYSTEMS - DUTY ADVANCE -2,002,619.11 MIRO 229100 119100000002 0000 681,417.21 229100 119100000002 0000 981,240.78 229100 119100000002 0000 286,690.64 229100 119100000002 0000 33,645.66 229100 119100000002 0000 19,624.82 (Payment of Advance Custom Duty thru Doc. No. 5100000040 Mat Doc. 5105600240)
Receipt of material at factory
At the time of Import Capital & non stock item (capital goods consumables) Movement type 101 should use instead of Mov type 103 & 104
F90033 FREIGHT SYSTEMS - DUTY ADVANCE -1,886,739.01 MIGO 261994 Customs Clearing A/C 641,987.50 261992 CVD Clearing A/C 924,462.00 462231 261992 CVD Clearing A/C 270,101.50 261994 Customs Clearing A/C 31,698.77 261992 CVD Clearing A/C 18,489.24 9244.62 (MIGO Entry - Fin doc. 5100000044 & internal invoice no 510560244 )
Part II Entry
229100 119100000001 0000 261902 GR/IR Clrng-Domestic 261994 Customs Clearing A/C 261994 Customs Clearing A/C (Doc No. 5000000120)
5,809,586.27 -5,135,900.00 -641,987.50 -31,698.77
254711 Ex Duty-RG23C-Deffrd 254714 ED - Additional 254709 Excise Duty-RG23C 254710 Education Cess-RG23C 261992 CVD Clearing A/C (Doc. No. (100000109)
471,475.62 270,101.50 462,231.00 9,244.62 -1,213,052.74
Remarks Decision to be taken by the business whether separate material no. is required for each Asset or not USD BCD All these entries should be transferred to Custom Clearing A/C and CVD Clearing A/C accordingly.
040 Mat Doc. 5105600240)
942,951.24 471475.62
5135900
CVD Cess CVD Cess Cus AD
INR 116756 5720680.69 14594.5 715085.09
21016.08 1029722.52 420.32 20594.45 720.62 35308.04 6140.3 300855.63
115600
Transaction Details
GL Code
Accounting Entries
Amt.
Movement Type/ T Code
Creation of Purchase Order No. 1101500003 Party Name M90010 Majestic Auto Ltd. Goods receipt at Factory Mat Doc. 1000000352
Invoice Verification
229200 119200000001 0000 423,404.80 MIGO 261902 GR/IR Clrng-Domestic 423,404.80(Being GRN made thru Doc No. 5000000119) MIRO
Remarks
Indirect Material
Transaction Details Payment of Advance Custom Duty
GL Code
Accounting Entries
F90033 FREIGHT SYSTEMS - DUTY ADVANCE
Amt.
Movement Type/ T Code
(4882.85)
261994 Customs Clearing A/C
1661.45
261992 CVD Clearing A/C
2392.49
261992 CVD Clearing A/C
699.02
261994 Customs Clearing A/C
82.04
261992 CVD Clearing A/C
47.85
(Payment of Advance Custom Duty thru Doc. No. 5100000041 Mat Doc. 5105600241) Good Receipt (MM Doc1000000347)
251103 Inventory-Spares Dom
12,715.64
261902 GR/IR Clrng-Domestic
-9,338.00
261904 Freight Clrng CG-Dom
-1,167.25
261904 Freight Clrng CG-Dom
-466.9
261994 Customs Clearing A/C
-1,661.45
261994 Customs Clearing A/C
-82.04
(Goods receipt at factory thru Doc. No. 5000000114) Part II entry
254711 Ex Duty-RG23C-Deffrd 254714 ED - Additional 254709 Excise Duty-RG23C 254710 Education Cess-RG23C 261992 CVD Clearing A/C
1,220.17 699.02 1,196.25 23.93 -3,139.37
(Duty Availed thru Doc no. 100000107) Reversal of MIGO (thru MIGO)
251103 Inventory-Spares Dom
-12,715.64
261902 GR/IR Clrng-Domestic
9,338.00
261904 Freight Clrng CG-Dom
1,167.25
261904 Freight Clrng CG-Dom
466.9
261994 Customs Clearing A/C
1,661.45
261994 Customs Clearing A/C
82.04
(Reversal of MIGO thru Doc no. 5000000117) Reversal of Part II Entry (T code j1iex)
254711 Ex Duty-RG23C-Deffrd 254714 ED - Additional 254709 Excise Duty-RG23C 254710 Education Cess-RG23C 261992 CVD Clearing A/C
-1,220.18 -699.02 -1,196.25 -23.93 3,139.38
(Duty reversed thru Doc. No. 10000108) MIGo again (Mat Doc 10000000351)
251103 Inventory-Spares Dom
12,715.64
261902 GR/IR Clrng-Domestic
-9,338.00
261904 Freight Clrng CG-Dom
-1,167.25
261904 Freight Clrng CG-Dom
-466.9
261994 Customs Clearing A/C
-1,661.45
261994 Customs Clearing A/C
-82.04
(MIGO performed again thru Doc. No. 5000000118)
Create Reservation (500 & 200 Qtys.)
Material reserved for some Cost Center
mb21 MIGO goods -6,338.63 issue
Goods issued against reservation (Mat. Doc. 4000000507)
251103 Inventory-Spares Dom
A/C Doc. 4900000085
411103 Consump-Spares Dom
6,338.63
251103 Inventory-Spares Dom
-2,535.45
411103 Consump-Spares Dom
2,535.45
Invoice Verification ( Internal Invoice No 5105600242)
F90005 FASTEN GROUP IMP.& EXP. CO. LT 261902 GR/IR Clrng-Domestic
-9,338.00 9,338.00
(Invoice booked thru Doc. No. 5100000042) Invoice Verification for Freight (Internal Invoice No 5105600243)
F90033
FREIGHT SYSTEMS - DUTY ADVANCE
-1,634.15
261904 Freight Clrng CG-Dom
1,167.25
261904 Freight Clrng CG-Dom
466.9
(Invoice booked for Freight thru Doc. No. 5100000043)
6340 2536
Remarks
Cancellation into 2 parts, mat. Doc thru MIGO transaction and Part II Entry thru j1iex.
available in mmbe
TDS to be deducted and Service tax to be considered
SERVICE Transaction Details
GL Code
Accounting Entries
Movement Type/ T Amt. Code
Remarks
Scrap Accounting Transaction Details
GL Code
Accounting Entries
Debit/Credit
Movement Type/ T Code
Generation of RM scrap at the time of production confirmation
411108 251101
Scrap Cost Account Inventories - Domestic Raw Material
Debit Credit
551 551
Generation of WIP scrap at the time of production confirmation
411108 251201
Scrap Cost Account Inventories - Work In Progress
Debit Credit
551 551
Generation of scrap out of obsolete inventory
411108 251101
Scrap Cost Account Inventories - Domestic Raw Material
Debit Credit
551 551
Surrender of Excise on Obsolete inventory
452024 254707 254708
Excise Duty Expenses Account Excise Duty - RG 23A Education Cess - RG 23A
Debit Credit Credit
251106 251401
Inventories - Scrap Scrap Inventory Built-up
Debit Credit
251401 251106
Scrap Inventory Built-up Inventories - Scrap
Debit Credit
325001 261993 261993 262321 262371
Customer Sale of Scrap ED Collection A/C ( Duty) ED Collection A/C ( Cess) TCS Payable - Scrap Sale Education Cess - TCS on Scrap Sale
Debit Credit Credit Credit Credit Credit
261993 262461 262462
ED Collection A/C E Duty Payable-DTA E.Ces-ED payable DTA
Debit Credit Credit
Generation of Stock of Scrap New Account Post goods issue of scrap in SD
Scrap Invoice Generation - Commercial
Excise Document for sales
961 961
TRANSACTION DETAILS Case No. 1 Invoice and Delivery Challan for 100 Qty. but actual receipt 90 Qty. All the GR will be made on received quantity and the Cenvat will be availed on received qyt. Purchase department will take care of any disputes with the vendor for the cenvat on shortage alongwith the basic value. (In this case with 90 Qty.) Case No. 2 Invoice and Delivery Challan for 100 Qty.,received 100 Qty. but 10 Qty. rejected by Quality Goods Received
Inventory-RM Domestic GR/IR Clrng-Domestic
1078 -1078
Excise Duty-RG23A 172.48 Education Cess-RG23A 3.45 Cenvat Clearing A/C -175.93 (Being 100 units challan qty and 100 units received qty Doc no. 1000000296) Quality Inspection
GR/IR Clrng-Domestic Inventory-RM Domestic (Being 10 units rejected qty Doc no. 1000000296)
107.8 -107.8
Invoice Verification PACOLINE INDUSTRIES 1,269.60 GR/IR Clrng-Domestic (970.20) Cenvat Clearing A/C (155.23) Cenvat Clearing A/C (3.11) VAT Recvble A/C (141.07) (Being 90 units accepted qty invoice is passed Doc no. __________________) Goods rejected sent back to vendor
E Duty Payable-DTA
-17
ED Collection A/C 17 (Being 10 units OF rejected qty sent to vendor Doc no. 100000084 against excise invoice) Case No. 3 Out of the 90 Qty. issued to production, 10 get rejected at Shop Floor Rejection identified at Shop and material moved to blocked stock at Line Rejection debited to vendor
No accounting Entry
Qty. 10 units
Inventory-Rw Mat-Dom (53.90) GR/IR Clrng-Domestic 53.90 (Being 5 units OF rejected at shop floor debited to vendor Doc no. 100000302) PACOLINE INDUSTRIES 70.53 GR/IR Clrng-Domestic (53.90) Cenvat Clearing A/C (8.62) Cenvat Clearing A/C (0.17) VAT Recvble A/C (7.84) (Being debit note for 5 units of material rejected at shop floor generated for vendor Doc no. 100000302)
Excise Invoice for Line Rejection
E Duty Payable-DTA (9.00) ED Collection A/C 9.00 (Being 5 units of rejected qty sent to vendor Doc no. 100000085 against excise invoice)
Scrapping the goods at shop floor
Inventory-Rw Mat-Dom Scrap Cost Account
-53.9 53.9
(Being 5 units scrapped Doc no. 490000070)
Excise Invoice for Line Scrap
E Duty Payable-DTA ED Collection A/C
-9 9
(Being excise invoice of 5 units scrapped Doc no. 100000086)
MOVEMENT TYPE
pt 90 Qty.
partment will take care of any disputes with
y. rejected by Quality 101 101 101 101 101
o. 1000000296) 122 122
MIRO No MIRO without inspection MIRO MIRO MIRO MIRO
_____________)
How the balance will be crossed with CENVAT Clearing account
0084 against excise invoice)
Shop Floor 344
922 922
c no. 100000302)
r generated for vendor Doc no. 100000302) New Accounts to be given by finance
85 against excise invoice)
555 555