Become a Govt. Certified GST Practitioner. Batch begins 18th Nov. Register Now!

How to import voucher entries?

Ajeet (CA) (239 Points)

21 March 2009

I want to import voucher entries & masters from one company to another company in tally. Can I do this? If yes, then how?

Reply
Follow
Share

13 Replies

Ankur Agrawal (CS, CA Final) (239 Points)
Replied 21 March 2009

simply copy the source file .....(shayd esay hi hota hai ..i m not sure)

Upgrade to CAclubindia Pro. Subscribe Now!

subramanya (Professional) (907 Points)
Replied 23 March 2009

Originally posted by :Ajeet
"	I want to import voucher entries & masters from one company to another company in tally. Can I do this? If yes, then how?	"

Hi,

Its possible through Import and Export of xml.

vijay (director) (25 Points)
Replied 27 March 2009

Originally posted by :Ajeet
"	I want to import voucher entries & masters from one company to another company in tally. Can I do this? If yes, then how?	"

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.

1 Like

mukesh (service) (26 Points)
Replied 31 March 2009

GR8 THANKS FOR SHARING

Nitesh (service) (136 Points)
Replied 05 October 2009

Thanks Mr. Vijay,

This shortcut will reduce the work burden in most of the companes and could help in reengineering the account process particularlty if u r having branch or depot accounting and where it neds to be monitored from mumbai.

Upgrade to CAclubindia Pro. Subscribe Now!

subramanya (Professional) (907 Points)
Replied 05 October 2009

Originally posted by :Nitesh
"	Thanks Mr. Vijay, This shortcut will reduce the work burden in most of the companes and could help in reengineering the account process particularlty if u r having branch or depot accounting and where it neds to be monitored from mumbai.	"

Dear Nitesh,

I think you can use One way Synchronization feature of Tally to get data of a branch account in HO.

You can refer manuals on Tally Synchronization for more details.

Subramanya

vaibhav (M.Com. CA ) (178 Points)
Replied 24 October 2009

Vijay Sir ,

Can u please let me know , the reason for different procedure , to copy data with regard to Ledgers and Vouchers.

To copy voucher Export -import is done.can we use Alt +A steps,like copy of Ledger.

Thanks

Vaibhav

Jitendra (Student) (30 Points)
Replied 28 October 2009

Originally posted by :Ajeet
"	I want to import voucher entries & masters from one company to another company in tally. Can I do this? If yes, then how?	"

Vijay Sir, Excelent idea shared by you on import voucher into tally, Thanks a lot

With Regards

Jitendra Kumar Agrawal

Avinash (Executive Accountant) (30 Points)
Replied 25 February 2011

vijay sir "import " cant work in tally 7.2 is there another way to import data in tally 7.2...

Manoj Garg (Support on Tally Excel Password Recovery etc.) (1987 Points)
Replied 25 February 2011

Dear Mr. Vijay,

Entries can only be imported into another company if masters are present. So, the first step for import is to import masters and then transaction. If all the data is not get transferred then Open the Tally folder-> open the file [Tally.imp] and check the errors.

Regards,

Manoj Garg

+91-9927199217

Upgrade to CAclubindia Pro. Subscribe Now!

Manoj Garg (Support on Tally Excel Password Recovery etc.) (1987 Points)
Replied 25 February 2011

Mr. Avinash, Import/Export is perfectly working since the feature is incorporated into Tally. It will work in any version of Tally. Regards, Manoj Garg +91-9927199217