Accounting Flow

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