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
11 comments
Write commentssuppose 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 ?
ReplyThanks..!
ReplyVery useful information you provided.
Also I tried XLTOOL Excel to Tally utility for Auto entry & fast work.
Link - http://www.xltally.in
Useful tool for Excel to Tally
ReplyDownload : https://www.rtslink.com
Excel to Tally Utility
Replyhttp://www.udimagic.com
Dear Sir,how i will enter if clearing n frwd chagres hav vat amount
ReplyDear Sir,
ReplyIn the above Green colored table additional cost calculated, How did you find out the amount ?
Could you please explain the calculation steps.
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
ReplyToday, 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
Thanks for sharing detailed information about Tally accounting software
Replyby accounting-courses-in-chandigarh/
HI
ReplyI 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.
Hi,
ReplyDid you get any reply for this?
It is a very informative and useful post thanks it is good material to read this post increases my knowledge. Import Tax NZ
Reply