Wednesday, April 27, 2016

Purchase Import Voucher Entry in Tally ERP 9

·   11

Query

How do I record a Purchase Import entry where Item value includes additional expenses however bill amount does not include the additional expense incurred in procuring the items?

Answer

In a case of Purchase Import, items are purchased from foreign in another currency such as US Dollar and local expenses are incurred in order to bring the item to production unit.

So, actual Purchase invoice which supplier has provided will be in another currency and Local expenses paid or payable will be in Base currency.

In this scenario, Supplier bill amount should not include Local expenses paid or payable amount but Item value should include Local expenses also in order to show the actual cost of an Item.

Example:
Expenses incurred for bringing the material:

Custom Duty                                                  –  Rs.1,500.00
Clearing and forwarding charges                        -  Rs.2,000.00
Freight Charges                                               -  Rs.1,000.00

Amount payable to Foreign Supplier is $3250.00 and above expenses to be included in Item cost by appropriating the value.
Below are the Steps to implement the same in Tally.

Master Creation
Note: In Group Master, Option “Method to Allocate when used in Purchase Invoice”. This option is provided for appropriating the cost to the Item value in purchase invoice.
Purchase Invoice Creation in Invoice Mode

Rate of Exchange 1$ = Rs.50

Entering the Import Purchase Invoice
Entering the Additional cost Details incurred.
Enter the expense payable to transfer the Expenses. Expenses Entry mainly used to appropriate the expenses value.
Save the Purchase Entry.

Now check the Stock summary.
Custom duty Paid Entry

            Custom Duty Payable a/c                                         Dr.    ---  1500
                        To Cash                                                        Cr.          1500


Clearing and Forwarding Journal Entry

            Clearing and Forwarding Charges Payable a/c           Dr.       2000   
                        To Freight Forwarders a/c                               Cr.                   2000


Local Freight Paid Entry


            Freight Charges – Import Payable a/c                         Dr.       1000
                        To Cash                                                           Cr.                   1000

Subscribe to this Blog via Email :

11 comments

Write comments
Shameer
AUTHOR
February 7, 2017 at 6:12 AM delete

suppose i have 100 items in my stock and i am entering purchase for only 10 items. In that case, how can i show the cost of items of the purchase made in a single screen ?

Reply
avatar
NITU
AUTHOR
October 8, 2017 at 12:20 AM delete

Thanks..!
Very useful information you provided.
Also I tried XLTOOL Excel to Tally utility for Auto entry & fast work.
Link - http://www.xltally.in

Reply
avatar
November 20, 2017 at 8:13 AM delete

Useful tool for Excel to Tally
Download : https://www.rtslink.com

Reply
avatar
November 20, 2017 at 8:20 AM delete

Excel to Tally Utility
http://www.udimagic.com

Reply
avatar
Unknown
AUTHOR
February 1, 2018 at 8:11 AM delete

Dear Sir,how i will enter if clearing n frwd chagres hav vat amount

Reply
avatar
Unknown
AUTHOR
February 3, 2018 at 4:23 AM delete

Dear Sir,
In the above Green colored table additional cost calculated, How did you find out the amount ?
Could you please explain the calculation steps.

Reply
avatar
Abhi Dogra
AUTHOR
February 23, 2018 at 5:55 AM delete

Thanks for sharing this knowledgeable content. I like this because it help me alot. Please update more content so that it can help me alot in further studies. As it help in my business

Today, almost every Indian business preferred Tally accounting software for their Business. Tally is one of the best accounting software for business. Tally training in Chandigarh offer a service that help you to enhance your career and boost your skills. Enterprise Resource Planning (ERP) introduce a integration and industrialization of a company’s core business in order to help it focus on performance and simplified success. Tally ERP9 is the latest ERP that offers various features for business management and that increase business performance.

Tally Training in Chandigarh

Reply
avatar
Ashish
AUTHOR
April 12, 2018 at 2:46 AM delete

Thanks for sharing detailed information about Tally accounting software
by accounting-courses-in-chandigarh/

Reply
avatar
Anonymous
AUTHOR
April 23, 2018 at 8:28 AM delete

HI
I IMPORT PURCHASE 3 ITEMS FROM INDIA TO DUBAI.
THEN I HAVE AN AGENT WHO TAKES CARE OF CUSTOMS DUTY AND LOCAL TRANSPORTATION & HANDLING.
PART OF HANDLING HAS VAT, CUSTOMS DUTY DOES NOT AND AGENTS FEE IS ALSO NOT VATABLE. TRANSPORT ALSO DOES NOT SHOW VAT.
PLEASE CAN YOU SHOW ME HOW TO POST THIS.

Reply
avatar
Anonymous
AUTHOR
October 13, 2018 at 7:47 AM delete

Hi,

Did you get any reply for this?

Reply
avatar
September 26, 2020 at 1:17 PM delete

It is a very informative and useful post thanks it is good material to read this post increases my knowledge. Import Tax NZ

Reply
avatar