Split Company Data
Splitting Company Data after finalization of accounts.
Introduction
Tally’s flexible period-less accounting permits the entry of data for any number of years. This feature has tremendous benefits. The presence of voluminous old data creates unnecessary load on the system.
Splitting a financial year enables you to retain most of the benefits while overcoming this system overhead.
When you split the data, two things happen:-
1. New companies are created for the respective split periods.
2. The entire data is retained in the original company.
How to Split Company Data :
I. For Tally.ERP 9 Release 2.1 and Lower Releases (including Tally 9)
Pre-split activities
Before you split the data, ensure that:
- All adjustment forex gains/losses have been fully adjusted using Journal entries. Verify that the item “Unadjusted Forex Gains/Loss” does not appear in the balance sheet
- There are no pending purchase bills/sales bills. Check the profit and loss account and inventory statements for pending purchase/sales bills. You may account them to the respective party accounts or to the respective “bills pending” accounts.
- Ensure that all the Bank Vouchers are reconciled from Bank Reconciliation statement.
- Ensure that a Backup of the data has been taken
Procedure to Split the Financial Years
- Go to Gateway of Tally, Select Alt+F3: Cmp Info.
- Select Split Company Data.
- Select the Company whose data is to be split.
- Tally recommends the split from date based on the existing data. It is recommended that the Split Point is set as the beginning of the latest financial year, though Tally permits any date as the split point.
- Splits occur in sets of two periods. Hence, start with the latest. For example, you need to split a company’s four years data (1-4-2008 to 31-03-2012) into four separate “companies”, each with a particular financial year. Select the beginning of the latest financial year first (1-04-2011).
- On confirming the periods, two new companies will be created – one with data from 1-4-2008 to 31-03-2011, i.e., for three years, and the other for the period 1-4-2011 to 31-03-2012.
The historical data, for one or more financial years, will be preserved as a single company, and the current financial year, will be preserved as another company. Normally there is no reason or benefit to split the earlier years again into separate companies. If you wish to do so, repeat the steps mentioned above for the earlier period (1-4-2008 to 31-03-2009, 1-4-2009 to 31-03-2010 & 1-4-2010 to 31-3-2011).
All the companies are full companies in their own right. Data can be entered, displayed and altered. Please print the key financial reports (Trial Balance, Balance Sheet, Profit & Loss, and Stock Summary etc.) for each company for the relevant periods and compare them for accuracy.
Once you are satisfied that you have a successful split, it is advisable to take a backup of the original company and permanently delete its data from the hard-disk. This will prevent any accidental entry of fresh data into the old database.
To delete a company, press Alt+F3 at the Gateway of Tally, select a company to Alter it, and at the point where you can modify the Company Information, press Alt+D.
You will also need to alter the names of the two freshly created companies as per your requirement.
II. For Tally.ERP 9 Release 3.0 and Above
Pre-split activities
Before you split the data, ensure that:
- Verify Company Data Utility: Verify Company Data is a built-in utility which detects the possible error that occurs on data verification and provides the respective reason for the error detected. Further, it prompts the user to rectify the listed error with possible solution so that the same errors do not reoccur in future. The user has a choice to resolve these errors manually or by using the helper available.
- All adjustment forex gains/losses have been fully adjusted using Journal entries. Verify that the item “Unadjusted Forex Gains/Loss” does not appear in the balance sheet
- There are no pending purchase bills/sales bills. Check the profit and loss account and inventory statements for pending purchase/sales bills. You may account them to the respective party accounts or to the respective “bills pending” accounts.
- Ensure that a Backup of the data has been taken
Verify Company Data
To start the data verification process before splitting the data:
- Go to Gateway of Tally > F3: Cmp Info. > Split Company Data > Verify Company Data
- Select the required company
- Press enter to view the Possible Errors screen.
The Possible Errors screen is displayed as shown
Possible Error screen display the Errors, Reason for the Error
Procedure to Split the Financial Years
- Go to Gateway of Tally, Select Alt+F3: Cmp Info.
- Select Split Company Data.
- Select the Company whose data is to be split.
- Tally recommends the split-off date based on the existing data. It is recommended that the Split Point is set as the beginning of the latest financial year, though Tally permits any date as the split point.
- Splits occur in sets of two periods. Hence, start with the latest. For example, you need to split a company’s four years data (1-4-2009 to 31-03-2012) into four separate “companies”, each with a particular financial year. Select the beginning of the latest financial year first (1-04-2011).
- On confirming the periods, two new companies will be created – one with data from 1-4-2008 to 31-03-2011, i.e., for three years, and the other for the period 1-4-2011 to 31-03-2012.
The Split Company Data screen displays as shown:
The historical data, for one or more financial years, will be preserved as a single company, and the current financial year, will be preserved as another company. Normally there is no reason or benefit to split the earlier years again into separate companies. If you wish to do so, repeat the steps mentioned above for the earlier period (1-4-2008 to 31-03-2009, 1-4-2009 to 31-3-2010 & 1-4-2010 to 31-03-2011).
All the companies are full companies in their own right. Data can be entered, displayed and altered. Please print the key financial reports (Trial Balance, Balance Sheet, Profit & Loss, and Stock Summary etc.) for each company for the relevant periods and compare them for accuracy.
Once you are satisfied that you have a successful split, it is advisable to take a backup of the original company and permanently delete its data from the hard-disk. This will prevent any accidental entry of fresh data into the old database.
To delete a company, press Alt+F3 at the Gateway of Tally, select a company to Alter it, and at the point where you can modify the Company Information, press Alt+D.
You will also need to alter the names of the two freshly created companies as per your requirement.
ajay kumar mishra Said,
June 20, 2011 @ 2:51 am
sir,
i ajay kumar mishra student of tally soluations lucknow.have a problem in tally spliting in stock item showing doubled. my contact number is09935381063
sumit negi Said,
July 2, 2011 @ 4:43 am
dear sir .
i m a tally opreter in ssa . i have one problem in tally how can new data create to tally ERP-( software .plz i request u slove my problem .
thanks
sumit negi (9760120965)
HEMANT AGARWAL Said,
July 6, 2011 @ 4:50 am
sir/madam
while splitting a company data, an error “ladger does not found” occurs.
how to tackle this problem.
please solve the problem as soon as possible.
its urgent.
regards
hemant agarwal
HEMANT AGARWAL Said,
July 6, 2011 @ 4:51 am
sir/madam
while splitting a company data, an error “ladger does not found” occurs.
how to tackle this problem.
please solve the problem as soon as possible.
its urgent.
regards
hemant agarwal
Haresh Sheth Said,
September 8, 2011 @ 7:18 am
Sir/Madam
I can’t spilt the company data there is show a error in screen write that “Could not resolve “Unit” Name for Company. Formal Name was ‘N’, and Symbol ‘Nos’.” Please give me suggestion in this matter.
Dush Said,
September 23, 2011 @ 9:33 pm
Sir/Ma’m
I have tally 6.2 i am trying to split my company data, it goes through first phase and then strucks at second phase and then the screen goes to ALT+F3 screen. i mean comes out .. and nothing happens.. Splitting is not working . Please advise.
Thanks
Adam William Said,
October 13, 2011 @ 7:46 am
i need help. my tally.erp9 release 3.2, i need to split company data but when i go to Gateway of Tally, Select Alt+F3 view Cmp Info, the Select Split Company Data command is not appiering. pls any body help using my email address.
thank you in advance,
Adam. +255787644006
Tally Academy Said,
October 17, 2011 @ 6:14 am
Dear Adam William,
When you load your company log in as admin not as user.
Admin only have rights to split the company.
You are not getting option becasue you log in as user in that company.
Try with admint you will get option of “Spilt Company”
Best Wishesh
Admin
prasanna Said,
December 28, 2011 @ 8:24 am
Hi
When I tried to split the company data I am getting an error
“deductee type ‘association of persons’ does not exist”
kindly help
Tally Academy Said,
December 28, 2011 @ 11:27 pm
Dear Prasanna,
Check your tally.spl file where you will get error in details,
go to that ledger and alter and select the deductee type nad tehn split the company
Regards,
Admin
Nitin Said,
December 30, 2011 @ 1:14 am
When i tried to select a company an error occurs saying : could not resolve the currency name…..please help in this matter
Tally Academy Said,
January 8, 2012 @ 11:11 pm
Dear Nitin,
If you hae license version…
Please reinstall your software it will solve your problme
Best wishes
Admin
fayyazaa walker Said,
January 14, 2012 @ 2:44 am
once we split data in tally how we reverse due to wrong date select
Prithvi S Said,
February 3, 2012 @ 2:27 am
Hi,
I am trying to split the company, while splitting i am getting memory violation error,
Please help me on this,
Thanks,
Prithvi S
Tally Academy Said,
February 3, 2012 @ 11:58 pm
Dear Prithvi,
Take a backup first,
Open your company
Press Ctrl + Alt + R (rewrite your compnay)
then you try for split the company
Best wishesh
Admin
Pruthviraj Said,
February 21, 2012 @ 11:52 pm
Dear Sir / Madam,
How can I manage voucher “Unadjusted Forex Gains/Loss”
Pls explain me in details.
waiting for your reply
Thanks
Tally Academy Said,
February 23, 2012 @ 11:48 pm
Dear Pruthviraj,
You have to create a ledger Forex Gain/Loss (under indirect income/expenses : depend upon profit or loss)
Then create a voucher class in journal and activate use in Forex Gain or loss : Yes
and then pass the journal entry in journal voucher with forex gain or loss class
Best wishes,
Admin
Tally Academy Said,
February 24, 2012 @ 2:01 am
Dear Walker,
You dont have to reverse it
When you split the company original company will remain the same an additional two companies will be created, so delete the others and split the company again with proper date
Best Wishes
Admin
dhanapaul Said,
February 29, 2012 @ 2:28 am
Dear Sir,
I want split my company data, when i split the data below error message coming , how to split it please advice me.
Regards,
S.Dhanapaul
dhanapaul Said,
February 29, 2012 @ 2:29 am
Dear Sir,
I want split my company data, when i split the data below error message coming , how to split it please advice me.
Error Message:” deductee type Association of person does not exit”
Regards,
S.Dhanapaul
Tally Academy Said,
February 29, 2012 @ 6:21 am
Dear Dhanpaul,
Uninstall your license and install it again.
Best Wishes
Admin
pitchappa Said,
February 29, 2012 @ 9:47 pm
I have found error while split the company data in tally 9 erp.there was no option after press alt+f3
Tally Academy Said,
March 12, 2012 @ 10:48 pm
Dear Ptichappa,
Log in as admin user while opening company in Tally.
Best Wishesh
Admin
Bijith Said,
March 21, 2012 @ 2:53 am
Sir, am using tally 7.2, i want to split the data, i tried to split the data ( alt+f3) but when it showing splitting the data for few minutes and after that i ddnt see the company in splitted form. Can you please help me from this issue its very urgent.
Regards
BIjith
Vinay Said,
March 28, 2012 @ 10:17 pm
Dear Sir,
I am trying to split the company in tally erp9, but i am not able to get the option of Split company in tally.
Tally Academy Said,
March 29, 2012 @ 7:10 am
Dear Vinay,
Please log in as admin user, you will get option Split Company
Best Wishes
Admin
Biplab Sarkar Said,
April 2, 2012 @ 7:14 am
Respected sir,
I have a problem, the problem is, when I want to splite the company data these message appear “deductee type ‘Association of person does not exits’ ” and spliting process are stoped. Please help me about thise problem.
khamarudheen Said,
April 3, 2012 @ 10:45 am
sir please help me
while splitting my company data, i got an error message “item ‘a’ does not exist”
there for i can’t complete splitting
Abhimanyu Said,
April 16, 2012 @ 5:47 am
plz help me split my data
when i try splitting the company it displays an error “multi currency not active for the company ” and if i activate the multi currency(whch is not required thn also it diasplays an error “currency rs already exist”
urgent
Abhimanyu Said,
April 16, 2012 @ 5:49 am
plz help me split my data in tally 7.2
when i try splitting the company it displays an error “multi currency not active for the company ” and if i activate the multi currency(whch is not required) thn also it diasplays an error “currency rs already exist”
urgent
Anil Said,
April 19, 2012 @ 11:36 pm
After splitting the company data for April 2010 to March 2012 into two
Company A April 2010 to March 2011
Company B April 2011 to March 2012
Now the Company A does not show any entries for Profit & Loss Account or Purchases and Sales account.
Please help us solve this problem.
Tally Academy Said,
April 23, 2012 @ 2:28 am
Dear Anil,
Afer spliting of the company data
In Main Company : you will get data from 01/04/2010 to 31/03/2012,
In Company A : you will get data from 01/04/2010 to 31/03/2011,
In Company B : you will get data from 01/04/2011 to 31/03/2012,
Please check your current period or statistcs (GOT>Display>Statement of Accounts> Stastics).
Best Wishes
Admin
Brinda Said,
May 1, 2012 @ 2:37 am
After splitting data in tally, when I checked my BRS was not tallying. Before splitting it was tallying. what could have gone wrong? could you please help me?
shailesh Said,
May 12, 2012 @ 4:39 am
dear sir we have split our tally erp 9 ver 3.0 data from earlier tally version but after reloading our data our all the bank reconcillation is deleted.
please suggest we can do the split lower version.
Idris Said,
May 12, 2012 @ 8:46 am
After spliting the data in Tally ERP 9 we need to reverse the split as the balances brought into the new period is worng and cannot be adjusted .Kindly give us the procedure to reverse a data split without losing the data already entered in the new period
Tally Academy Said,
May 17, 2012 @ 12:55 am
Dear Khamarudheen,
Please check your Tally.spl file where you will get detail error, try to rectify the same and then go for split the company
Best Wishes
Admin
Tushar Said,
May 23, 2012 @ 2:33 am
Hi,
I am trying to split the data in to two different years. But getting error “The Cost Center ‘ ’ does not belongs to the Category ‘Common’!”
Please help
Sujit Said,
May 25, 2012 @ 1:00 am
Tally.spl file not found in tally Erp folder
kindly help us
the same error association of Person Does not exist
on split of data
Muneesh Sharma Said,
June 13, 2012 @ 4:03 am
i need help. my tally.erp9 release 3.2, i need to split company data but when i go to Gateway of Tally, Select Alt+F3 view Cmp Info, the Select Split Company Data command is not appiering. pls any body help using my email address.
R Ravi Said,
June 21, 2012 @ 3:58 am
Dear Sir,
We are using Tally ERP 9 3.3 Version (Multi User)
While spliting the date before completion getting error saying that No Accounting Information.
Please suggest how to solve.
VISHAL Said,
July 7, 2012 @ 2:55 am
DEAR SIR/ MADAM
I HAVE PROBLEM AFTER SPLITING THE COMPANYS DATA FROM PARTICULAR PERIOD . IS IT NECESSARY TO TRANSFER OPENING BALANCE OF ALL THE ACCOUNTS TO NEWLY CREATED (SPLIT) COMPANY. IF IT IS NECESSARY PLEASE TELL ME HOW TO DO THAT…PLEASE
Viji Said,
August 3, 2012 @ 4:37 am
Sir,
I am working in a college i dont want our college’s old student ledgers in my financial year company. Pls give guidlines sir
Mukundan Said,
August 15, 2012 @ 10:05 pm
Sir,
I have tried to split the company data in Tally erp 9 but it showing the error ” Internal Error. Contact tally solutions. Software exception c0000005 (Memory Access Violation).
Kindly help on this error to split the company data.
regards,
Mukundan.
sivakumar Said,
August 26, 2012 @ 12:28 am
dear sir,
1.
I have tried to split the company data in Tally erp 9 but it showing the error incorrect due date for bill ‘dec/jv/01. i have tried also verify and against bill correct but again error comming kindly help on this error.
2. crm data (siebel) excell to tally 9 import but it showing the error Tax Classification ‘Output VAT @ 14′ does not exist kindly help on this error
Varinder Said,
August 27, 2012 @ 4:04 am
I want to split my data stored in a company from 01/04/2004 to 2/08/2012
i want one company from 01/04/2004 to 31/03/2011 & second from 01/04/2011 to 02/08/2012
but while splitting Error Message comes as follows
INTERNAL ERROR. CONTACT TALLY SOLUTIONS.
SOFTWARE EXCEPTION c0000005
(MEMORY ACCESS VIOLATION)
kINDLY SUGGEST THE SOLUTION
DHANU SARANYA S Said,
August 30, 2012 @ 4:34 am
dear sir/ madem
how to take backup on tally.erp9
tamizhselvan Said,
August 31, 2012 @ 4:18 am
“deductee type ‘association of persons’ does not exist”
tamizhselvan Said,
August 31, 2012 @ 4:19 am
Dear Sir,
Please kindly re sold my problems
“deductee type ‘association of persons’ does not exist”
tamizh
vandana Said,
September 4, 2012 @ 3:40 am
when i split the company its started splitting but after 40% or 50% of splitting error found that NO VOUCHER
ENTERIES
vinod Said,
September 4, 2012 @ 6:25 am
Dear Sir,
I want split my company data, when i split the data below error message coming , how to split it please advice me.
Error Message:”Artificial juridical person does not exit”
Regards,
vinod
TSRM Said,
September 9, 2012 @ 11:45 pm
Dear Sir,
Here in tally gate way, Split company data was not appearing and alter company is also not appearing. Please help
Santosh Said,
October 12, 2012 @ 6:26 am
Dear Sir,
I want split my company data, when i split the data below error message coming , how to split it please advice me.
Error Message:”Artificial juridical person does not exit”
Regards,
Santosh
Resham Said,
October 13, 2012 @ 12:00 am
Dear Sir
While splitting the tally data, errors are there. The option”Verify the split up data” are not coming.Pls guide
Waiting for your reply
Diva Said,
October 30, 2012 @ 2:33 am
while spliting the tally 7.2 data, errors are there .” quit tally. force quit by company name” are come error message please guide waiting for your replay sir
g.sumathi, Said,
December 8, 2012 @ 5:16 am
while spliting the company i found the error currency (new) does not exists, Pls help me sir, G. Sumathi
Tally Academy Said,
December 23, 2012 @ 11:56 pm
Dear G.Sumathi
Update your Tally Release
Take a back up of your data,
Rewrite your company once by Pressing Ctrl + ALt + R
Now to split the company
Best Wishes
Admin
Akram sekanjako Said,
January 2, 2013 @ 12:04 pm
I’m splitting a company in Tally 7.2 but it brings an error ‘orderdate’.what should i do to rectify this problem?
Tally Academy Said,
January 10, 2013 @ 10:19 pm
Dear Akram
Please check your Tallyspl.log file where you will come to know exact error.
Correct that error by opening that particular entry and then try to split again
Best Wishes
Admin
abhijeet Said,
January 16, 2013 @ 1:39 am
Sir, when i try to split my company for two financial years into two separate financial years, i get the error message showing ” No Accounting Information”
Please Help
Reagards,
abhijeet
N.Nagaraj Said,
January 28, 2013 @ 12:48 am
While splitting company data error c000005 memory access violations error is showing kindlly help me to rectify this error.
Ritesh Sharma Said,
February 15, 2013 @ 10:36 pm
Dear Sir
How to Balance carried forward for next year in per ladger account after spliting tally,
kindly give me solution right now.
bindu Said,
February 21, 2013 @ 11:33 pm
Sir,
iam bindu i merged data in tally successfully but new company has created as group of company now i should wentry the data in both group as well as company
please help me
rita rajput Said,
February 22, 2013 @ 4:55 am
Respected sir/ mam
sir mene tally course kiya hoa he or me apke yaha practice karna chahti ho. me abhi job karti ho. me as a practice karna chahti ho.
rita rajput
m.no- 9910887873
ABHISHEK GARG Said,
March 1, 2013 @ 6:34 am
Dear Sir
While splitting the tally data, errors are there. The option”Verify the split up data” are not coming.Pls guide
Waiting for your reply
please, sir give me solution. I also see the your solution relating from this problem But i Cannot Understand.
Please help me.
Sivasankari Said,
April 5, 2013 @ 1:52 am
Dear Sir,
While Splitting Company Data, errors are there. Internal Error : Contact Tally Solutions. Software Exception c000005(Memory Access Violation).
Please sir give me solution.
Sivasankari Said,
April 5, 2013 @ 2:26 am
I want to split my data stored in a company
but while splitting Error Message comes as follows
INTERNAL ERROR. CONTACT TALLY SOLUTIONS.
SOFTWARE EXCEPTION c0000005
(MEMORY ACCESS VIOLATION)
kINDLY SUGGEST THE SOLUTION
jigar Said,
April 6, 2013 @ 1:39 am
Tally.spl file not found in tally Erp folder
kindly help us
the same error association of Person Does not exist
on split of data
shankar gadge Said,
April 6, 2013 @ 5:55 pm
when i spilt company error occur ‘internal error contact tally solution software exception c0000005 memory acess violation kindly suggest solution
khamarudheen Said,
April 6, 2013 @ 9:20 pm
sir please help me
while splitting my company data, i got an error message “item ‘a’ does not exist”
there for i can’t complete splitting
Dhananjay Kumar Said,
April 7, 2013 @ 12:01 am
Dear Sir,
i have a problem in starting a new financial year when m splitting my company then show error currency symbol not found so please help me
Rachna Said,
April 9, 2013 @ 9:58 pm
Hi
Sir when i try to split my company then it shows an error that “cost category doesn’t belong to the primary cost category”
pl advice me what me what to do
Kishor Patil Said,
April 11, 2013 @ 6:27 am
while splitting company I am getting the error message ” cost category does not exists”
please help me in this matter to resolve it. the .spl file shows ‘marketing department’ while opened with notepad
Aparna sarkar Said,
April 12, 2013 @ 4:40 am
Sir,
I have tried to split the company data in Tally erp 9 but it showing the error ” Internal Error. Contact tally solutions. Software exception c0000005 (Memory Access Violation) back up of your data take
Company rewrited by Pressing Ctrl + ALt + R
Now to split the company same error
Kindly help on this error to split the company data.
Company 2012-2013 April2013 entries also made
regards,
Aparna sarkar Said,
April 12, 2013 @ 4:41 am
Sir,
I error ” Internal Error. Contact tally solutions. Software exception c0000005 (Memory Access Violation) rewrited by Pressing Ctrl + ALt + R
Now to split the company same error
Kindly help on this error to split the company data.
Company 2012-2013 April2013 entries also made
regards,
Tally Academy Said,
April 16, 2013 @ 11:24 pm
Dear Aparna
Take a back up of your data first then copy the company data in your local machine.
Now re-write your company once with Ctrl + Alt + R
Try this in only licensed version only
Best Wishes
Admin
G S RAJPUT Said,
April 20, 2013 @ 6:01 am
DEAR SIR
WE HAVE SPLIT COMPANY LAST YEAR 2012-2013 TO NEW FY 2013-2014 BUT DATA NOT SHOW FROM 1 APR 2012 TO TILL NOW.
PLEASE SUGGEST TO ME HOW TO SEE THIS TYPE DATA.
THANKS
9917435543
Tally Academy Said,
April 22, 2013 @ 11:32 pm
Dear G S Rajput
When you split the company additional two companies will created.
Then you can use how you want
eg. if you split from 1/4/2012
two additional companies will create 1. before 01/04/2012 and 2. from 01/04/2012
Best Wishes
Tally Academy
Chhotu Lal Said,
April 24, 2013 @ 2:33 am
Good afternoon Sir/Mam,
I want split company without OPENING BALANCE my means I dont want to show Opening Balance for Previous year in splited compnay. How it can be Possible…………. Please tell me.
Thanks
+91 90013-80315
Chhotu Lal Prajapat Said,
April 24, 2013 @ 7:47 pm
Good Morning Sir,
SIr I want to split compant data without opening balance it means when split company in splited company opening balance of main company should not be displayed. How it can be possible.
Thanks
Tally Academy Said,
April 25, 2013 @ 11:31 pm
Dear Chhotu Lal Prajapat,
When you Split the company from that date it take closing balance as a opening e.g if you split company from 01/04/2013 it will take balance of 31/03/2013 as opening balance
If you dont want opening balance
Go to Gate way of Tally > Accounts Info > Ledgers > Alter > right side on Button Bar “Zero Opening Balances” Click on it
and Save it
Best Wishes
Admin
jigna Said,
May 7, 2013 @ 3:51 am
Dear sir/ madam
i have a problem in starting a new financial year when m splitting my company then show error currency symbol not found so please help me. contact no. 9723553410