Accounting Imports and Full Clearance of Imported Goods

In practice, depending on the requirement goods imported are cleared from bonded warehouse in Full or partially by paying the customs duty.

Example: ABC Company imported 50,000 kgs Cold Rolled coils @ 150 per Kg from JK Manufacturers (Malaysia) and received invoice on 25-4-2009.

Let us consider the below calculation for entering the imports in Tally.ERP 9

Note:

* Customs Duty, Education Cess on Customs duty and Secondary Education Cess on Customs duty are not passed on, they will be apportioned to the item cost.

* CVD, Education Cess on CVD, Secondary Education Cess on CVD and Additional Duty on Imports are pass on duties.

1. Create the Stock item

Go to Gateway of Tally > Inventory Info. > Stock item > Create

1. Enter the name of the Stock Item e.g. Cold Rolled Coil in the Name field.

2. Select the Group Name e.g. Primary in the Under field.

3. Select the unit of measurement e.g. Kg of the stock item in the Units field (Use Alt +C to create Unit of Measurement).

4. In Tariff Classification field select the applicable tariff classification e.g. Coils from the List of Tariff Classifications.

5. Enable Set/Alter Excise Details to Yes to view Excise Details sub screen.

6. In the Excise Details Screen

7. Excise Unit Name: By default Tally.ERP 9 displays ABC Company as Excise Unit Name.

• Reporting UOM: By default the unit of Measurement selected under Units will be considered as UOM for all the reports.

• Set/Alter Duty Details: Set this field to Yes to view the Excise Duty Details screen.

• In Excise Duty Details screen select the Valuation Type & specify the duties applicable

7. Press Enter to accept the stock item creation.

2. Create the Supplier Ledger

Go to Gateway of Tally > Accounts Info. > Ledger

1. Enter the Name of the Supplier in the Name field e.g JK Manufacturers.

2. Select Sundry Creditors as the group name in the Under field.

3. Set Maintain Balances Bill by Bill to Yes and enter the Default Credit Period if any.

4. Set Inventory Values are affected to No

5. In the Mailing Details enter the supplier contact details.

6. Enable Set/Alter Excise Details to Yes to display the Excise Details screen.

7. In Excise Details screen enter the details as shown below

8. Press Enter to accept and save

Note: For exporter Excise Registration details are not required. Specify only the Default Nature of Purchase.

3 Record the Transaction in Purchase Voucher

Go to Gateway of Tally > Accounting Vouchers > F9: Purchase

1. Select the Excise - Purchase as the Voucher Type from the list of types.

2. Select Alt + I: Item Invoice if it is in Acct Invoice mode

3. Press F2 and enter the date as 25-4-2009

4. Enter the Supplier Invoice No.  as JK/8652 and Date as  25-4-2009

5. By Default Tally.ERP 9 displays the Excise Unit as ABC Company as defined during voucher type creation.

6. Select the Party’s A/c Name from the list of Ledger Accounts e.g. JK Manufacturers

7. In Party Details screen, in Manufacturer /Importer Details section specify your company details with excise details, since you can declare as Self Importer which is equivalent to Manufacturer.

Note:You can create a ledger in your company name with excise details so that you can select the ledger to avoid repeated entry of details.

To select Party Ledger press Alt + M keys or click on M: Manual button to view the party list for selection.

8. Nature of Purchase will be defaulted to Importer as defined in the party ledger

9. In Purchase Ledger field select Purchase - Imports from the List of Ledger Accounts. VAT/Tax Class will be defaulted to Import

10. In Name of Item field select Cold Rolled Coils

11. In Stock Item Allocation screen

12. In Tracking Number field select the option Not Applicable if all the goods imported are cleared at once.

13. Select the Godown and specify Quantity as 50,000 and Rate as 150. Amount will be calculated and displayed.

12. In Excise Details screen

8. In RG 23D Entry No field enter the RG 23D entry number of this purchase in your books

9. Supplier Invoice Number will be captured form the Supplier Invoice No. field if entered. Other wise enter the supplier Invoice number

10. By default the voucher date is displayed as the Supplier Invoice Date

11. PLA/ RG 23D Entry no. is not required in case of goods imported.

12. In Assessable Value field specify Rs.97,50,000 (Purchase Cost + Customs Duty). Assessable value to be calculated and manually.

13. Calculate Special AED of CVD amount (on Purchase Cost + CVD Duties + Customs Duties ) and specify manually. Enter Rs. 4,34,075.

Note: Tally.ERP9 will not auto calculate the Special AED of CVD amount. You have to enter manually

13. Enter the bill details in Bill-wise Details

The completed purchase voucher is displayed as shown

14. Press enter to accept.

On booking the purchase entry for imports based on the invoice received and on full clearance of goods stock details will be displayed in Stock summary

Go to Gateway of Tally > Stock Summary