Pages

Wednesday, April 27, 2016

Purchase Import Voucher Entry in Tally ERP 9

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:

  1. 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 ?

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

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

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

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

    ReplyDelete
  5. 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.

    ReplyDelete
  6. 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

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

    ReplyDelete
  8. 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.

    ReplyDelete
    Replies
    1. Hi,

      Did you get any reply for this?

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

    ReplyDelete