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

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

  1. 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 [email protected]

    regards Binu

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

  3. 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.
    [email protected].

    Expecting a reply.
    Sidheeq

  4. 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.
    [email protected].

    Expecting a reply.
    Sidheeq

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

  6. 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 [email protected]

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

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

  9. 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

  10. 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

  11. 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

  12. 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…

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

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

  15. 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,

  16. 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….

  17. 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 @ [email protected]

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

  19. Hi
    I need help regarding export of master
    I want to export Sundry Debtors Group and its ledgers only from Company A to B. I have 176 Groups in Company A and I want only 1 Group to export from Company A.
    How can i export only 1 Group from 176 Groups.

  20. import all masters, voucher types, units, ect (you can check in statistics) to destination company. then import the daybook. you have done.

  21. As you said above, while transffering ledgrs/masters from Company A to Company B F3 key is must be pressed after Accounts Info –> Ledgers –> AlTer in multiple Ledgers –> Sundry Debtors., But on screen F3 key is deactivated on that time. Now what to be done??

  22. for tally release 5.0 and above. … you can set inclusive price in 12 menu option to yes.
    For other version you have to make a voucher class in sales voucher.

  23. we should not make a new company. if the data is long period then we can split the data to create a new company with previous closing balances.

  24. I can't export voucher entries from one company to another though after doing everything that you suggested.. There is XLS format by default not XML.. How can I export now voucher entries?? Pleassee help me. My email-id is [email protected]

Comments are closed.