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
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
.png)
How to copy and paste data from Excel(i am not referinf to Exporting)
ReplyDeleteYou have to make special TDL Program to export from EXCEL or MSWord or any other software.
ReplyDeletedear sir,
ReplyDeleteI 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
for tally release 5.0 and above. ... you can set inclusive price in 12 menu option to yes.
DeleteFor other version you have to make a voucher class in sales voucher.
hai
ReplyDeletehow can i change the color to black and white of tally 7.2
binu
How to Merge Company A and Company B in Caompany C in tally
ReplyDeleteI 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?
ReplyDeleteHow can I print sales voucher of 4 inchesX4 inches?
ReplyDeleteIs t possible to change font size while printing?
ReplyDeleteno
DeleteWhat is the right etiquette for book keeping? should data be kept for one year & make new company every finacial year?
ReplyDeletewe 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.
DeleteSir,
ReplyDeleteI 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
Sir,
ReplyDeleteI 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
how can change font in tally can you prowide tally tutorial tally
ReplyDeleteand how can do entry of vat
1. hey every body am work with tally 7.2
ReplyDeletealso 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
is there any way to move out stock without passing sales entry?
ReplyDeleteThe 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.
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....
ReplyDeletepls reply as soon as possible...
waitting for your helpful support.
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
ReplyDeletehi 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
ReplyDeletei 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
ReplyDeletePrashantha , this would not help you . you need to break the password
ReplyDeleteSir,
ReplyDeleteI 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
sir,
ReplyDeletei have copied the tally from computer to CD, now how can I copy from CD to other computer. Kindly give me the answer.
Hello sir, I want know how to adjust advance receipts to next sales.
ReplyDeleteex: 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...
pls tell me in Exporting the masters/Ledgers ther is step Go to Accounts Info --> Ledgers --> AlTer in multiple Ledgers --> Sundry Debtors
ReplyDeleteafter that we have to press f3 but there is no option of selecting company highlighted.
plss tell me?
i am working in salalah (oman) somebody need help then contact me, i will help to study tally my tel 92500849
ReplyDeleteTo Learn Computerised Accounting, Tally, Peachtree, Quick Books And MS Office.. With in A short period , Please Call: +971 507491392.
ReplyDeleteDubai- UAE.
when I try to open the our one of creditor ledger it show message that internal error software exception c0000005 (memory acess violation).
ReplyDeletekindly give the solution about it.
thanks,
sir good evening
ReplyDeletehow can i change voucher from one com to another com
Good Evening sir,
ReplyDeleteI 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....
NIRAJ CHOUDHARY
ReplyDeleteSIR,
I WANT TO KNOW THAT HOW TO COPY MASTER LEDGER OR VOUCHER FROM ONE COMPUTER TO ANOTHER COMPUTOR
sir i wanted to know how to merge two companies totally in tally erp 9.0..
ReplyDeleteis it possible or not ??
give me brief detail pleaes.. u email me @ gharwaalibaabu@gmail.com
import all masters, voucher types, units, ect (you can check in statistics) to destination company. then import the daybook. you have done.
Deletesir,
ReplyDeleteI want multiple choice questions with answer about Tally ERP.9. on all topics of This course.
Tally Integration , Training & Customization Contact me @ tallylink@gmail.com
ReplyDeleteHi
ReplyDeleteI 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.
Wow! Great post! The content is very rich, and I really like it.
ReplyDeleteI 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 ca.cs.phg@gmail.com
ReplyDeleteAs 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??
ReplyDeleteis this possible to maintain two company but stock will merge ? please help me ID:kapilkewlani80@gmail.com
ReplyDeletehow to splite data form last year to current year
ReplyDelete