Tally 9 Tutorials : How to Copy Paste Entries from One company to Another

While maintaining accounts in tally we create more than one companies and put entries both companies accordingly. The most common reason for maintaining two companies is that one company has actual accounts as it happens and the another account is what we want to show for our returns etc. Another reason is when we have group company as well as single companies also. What ever is the reason for two companies we can reduce work load if there is a facility of copy paste of entries from one company to another just like what we have in MS Word or MS Excel etc.
Although simple cut and paste facility is not available in tally but this activity can be performed by few simple steps. Lets view it.

Tally has a feature of exporting data from any screen. Where ever you can see the export button just Alt+E can perform the trick. Lets assume we want to shift all sales entries for Dec 2006 from Company A to Company B. Take following steps :-

Select the entries
Select the entries you want to shift from Company A. You can do it but going to Display -> Daybook. Now filter the entries according to date by pressing Alt +F2 and giving period 1/12/2006 to 31/12/2007. Now you would get all entries for Dec month. Now filter according to sales vouchers by selecting voucher type as sales. Now all entries of sales voucher type for Dec 2006 would get selected.

Export the entries
At this moment select the Alt+E button and you would be prompted to select the file and the format of export. Select format as xml and remember the file name you have given by default it would be DayBook.xml. Press Y to accept the screen.
Export the masters/Ledgers
Next step is to export the ledgers masters. Masters which are presented in company A should be there in Company B also. For this select the multiple ledgers which are involved in dec sales transactions or all sundry debtors.
Go to Accounts Info --> Ledgers --> AlTer in multiple Ledgers --> Sundry Debtors. You would see all your Sundry Debtors.
Press F3 and select Company B. Accept the screen by pressing Ctrl+A. Your all sundry Debtors of Company A are in Company B.

Import entries

Select Company B go to Import of Data --> Vouchers and put the file name in the space provided. Accept the screen and all your sales entries are in company B.
So isn't it like copy paste?

Check the entries if all are transfered?. If not then there must be an error in shifting the masters. If tally doesn't find any ledger in target company then it halts the transfer of vouchers.

Related Reading : Exporting data : A quick preview , Data migration FAQ's

Shailendra Yadav

The Post is written with an aim to help Tally software users. You can consider subscribing all my post related to Tally by putting your email id in the box below and joining my email list. If you find the contents interesting then don't forget to share it with your friends.
You can also get professional help like Implementation of Tally in your business or Web Support on tally by asking a Quote.

Enter your email address:

Delivered by FeedBurner

32 responses:

  1. Anonymous5:46 PM

    How to copy and paste data from Excel(i am not referinf to Exporting)

    ReplyDelete
  2. You have to make special TDL Program to export from EXCEL or MSWord or any other software.

    ReplyDelete
  3. Anonymous8:00 AM

    dear sir,

    I am Tally trianer in singapore, So iave to ask lot of questions for developing tally in Singapore.

    My question is How to Invoice the sales inclusive of GST and also show the details of GST in the invoice .
    Eg. When we take a print of Invoice It must show as
    Total Value Inclusive of GSt = 100

    Gst inclusive 5% (5)
    Value of the Product (95)

    How to show sir, can u explain to me . My email is onlinebinu@hotmail.com

    regards Binu

    ReplyDelete
  4. hai

    how can i change the color to black and white of tally 7.2

    binu

    ReplyDelete
  5. Anonymous5:47 PM

    How to Merge Company A and Company B in Caompany C in tally

    ReplyDelete
  6. I want to establish server for tally accounts. I have subscription of www.freeservers.com , what should be the URL to type in, & what should be the valid TCP?

    ReplyDelete
  7. How can I print sales voucher of 4 inchesX4 inches?

    ReplyDelete
  8. Is t possible to change font size while printing?

    ReplyDelete
  9. What is the right etiquette for book keeping? should data be kept for one year & make new company every finacial year?

    ReplyDelete
  10. Sir,
    I am an Acccountant in a company,Dubai.I know some basics in Tally.But now i would like to learn more about tally.9.Can you send me a free Tally tutorila or website links to get that.Please send to my following e-mail ID.
    sidheeqpku@yahoo.co.in.

    Expecting a reply.
    Sidheeq

    ReplyDelete
  11. Sir,
    I am an Acccountant in a company,Dubai.I know some basics in Tally.But now i would like to learn more about tally.9.Can you send me a free Tally tutorila or website links to get that.Please send to my following e-mail ID.
    sidheeqpku@yahoo.co.in.

    Expecting a reply.
    Sidheeq

    ReplyDelete
  12. how can change font in tally can you prowide tally tutorial tally
    and how can do entry of vat

    ReplyDelete
  13. 1. hey every body am work with tally 7.2
    also I installed new version tally 9.0. but I dont know how to tranfer the data 7.2 to 9.
    kindly tell me the solution to the same waiting for helful reply thank u bye my mail ID mahesh965@gmail.com

    ReplyDelete
  14. Anonymous3:39 PM

    is there any way to move out stock without passing sales entry?

    The same should effect cost of sale.

    I am passing sale through journal entry giving effect to cash/bank a/c debit to sales a/c credit.

    ReplyDelete
  15. i want to know how to file tax returen of taxes like T.D.S , T.C.S like.... and i also want to know what is the diferance between challan and forms and Annaxtures....
    pls reply as soon as possible...
    waitting for your helpful support.

    ReplyDelete
  16. I have two companies. say co. A and co. B. I want to transfer all my voucher entries with the ledgers and stock entries from company A to B, along with the acoount balance and stock balance. How do i do that

    ReplyDelete
  17. Anonymous12:43 AM

    hi this raj from india i have data from old ver of tally its locked/protected by password and i have 4got D PW so how Do i Open the data or copy the data to new ver thats v.9

    ReplyDelete
  18. i have data from old ver of tally its locked/protected by password and i have 4got D PW so how Do i Open the data or copy the data to new ver thats v.9

    ReplyDelete
  19. Prashantha , this would not help you . you need to break the password

    ReplyDelete
  20. Sir,
    I am an Acccountant in a company.I don't know basics in Tally.But now i would like to learn about tally.9. Can you send me a free Tally tutorila or website links to get that.Please send to my following e-mail ID.
    aakabapu@gmail.com

    Expecting a reply.
    Sandeep

    ReplyDelete
  21. sir,
    i have copied the tally from computer to CD, now how can I copy from CD to other computer. Kindly give me the answer.

    ReplyDelete
  22. Hello sir, I want know how to adjust advance receipts to next sales.
    ex: when i am receive cash from xyz on 1-4-2009 and i am ales goods on 5-4-2009 now i want adjust advance receipts to aganiest sales how i can do.... pls explan me.. waiting for u r replay...

    ReplyDelete
  23. pls tell me in Exporting the masters/Ledgers ther is step Go to Accounts Info --> Ledgers --> AlTer in multiple Ledgers --> Sundry Debtors
    after that we have to press f3 but there is no option of selecting company highlighted.
    plss tell me?

    ReplyDelete
  24. i am working in salalah (oman) somebody need help then contact me, i will help to study tally my tel 92500849

    ReplyDelete
  25. Anonymous1:43 PM

    To Learn Computerised Accounting, Tally, Peachtree, Quick Books And MS Office.. With in A short period , Please Call: +971 507491392.
    Dubai- UAE.

    ReplyDelete
  26. Anonymous12:23 PM

    when I try to open the our one of creditor ledger it show message that internal error software exception c0000005 (memory acess violation).
    kindly give the solution about it.
    thanks,

    ReplyDelete
  27. sir good evening
    how can i change voucher from one com to another com

    ReplyDelete
  28. Good Evening sir,
    I want to know that How will I creation pay slip please help me very soon....
    I shall be highly oblight to you
    thank you with regards....

    ReplyDelete
  29. NIRAJ CHOUDHARY
    SIR,
    I WANT TO KNOW THAT HOW TO COPY MASTER LEDGER OR VOUCHER FROM ONE COMPUTER TO ANOTHER COMPUTOR

    ReplyDelete
  30. Anonymous1:30 PM

    sir i wanted to know how to merge two companies totally in tally erp 9.0..
    is it possible or not ??
    give me brief detail pleaes.. u email me @ gharwaalibaabu@gmail.com

    ReplyDelete
  31. sir,
    I want multiple choice questions with answer about Tally ERP.9. on all topics of This course.

    ReplyDelete
  32. Tally Integration , Training & Customization Contact me @ tallylink@gmail.com

    ReplyDelete

 

Copyright @ 2013 ApniTally.

Designed by Templateiy &Site Developed abd Maintained By Cybertec Solutions