Originally posted by :Nitesh |
" |
Dear Subramanya,
Befor splitting the data what check and balances need to be done. Eg. one chek is whether all knocking off has been properly done. What is the other cheks and balances before splitting the data?
|
" |
Pre split activities:
Before you split data ensure that:
1. All adjustment forex gains/losses have been fully adjusted by Journal entries. Verify that the item "Unadjusted Forex Gains/Loss" does not appear in the balance sheet
2. There are no purchase bills/sales bills to come. Check the profit and loss account and inventory statements for purchase/sales bills pending. You may account them to the respective party accounts or to respective “bills pending” account.
3. Accept all Tally audit vouchers goto Gateway of TallyàDisplayàStatement of Accounts à Tally Audit à vouchers à F7 (Accept One) or Alt + F7 (Accept All) vouchers.
4. Ensure that a backup of the data exists.
Procedure to Split the Financial Years
1. At the Gateway of Tally, Select [ALT]+F3: Cmp Info
2. Select Split Company Data.
3. Select the Company whose data is to be split.
4. Tally recommends the split-off date based on the data existing. 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.
5. Splits occur in sets of two periods. Hence, start with the latest. For example assuming that three years data – from 1-1-2001 to 31-12-2004 for a company and you want them split into three separate 'companies' each with a financial year. First, select the beginning of the latest financial year (1-1-2003, that is what Tally would prompt you to do).
6. On confirming the activity, two new companies will be created – one with data from 1-1-2001 to 31-12-2002, i.e., two years, and the other for 1-1-2003 to 31-12-2004.
7. Typically, this is all you need to do. Your historical data, whether of 1 or more financial years, will be preserved as one company, and your current financial year, as another. There is, normally, no reason or benefit to split the prior years again into separate years. However, if you wish to do so, repeat the above steps for the prior period company (1-1-2001 to 31-12-2002).
All the companies are full companies in their own right. Data can be entered, displayed and altered. Please display or print the key financial reports (Trial Balance, Balance Sheet, Profit & Loss, Stock Summary etc.) from each of the companies for the relevant periods and compare them for accuracy.
Once you are satisfied that you have a successful split, it is advisable to backup the original company onto diskettes and permanently delete its data from your hard-disk. This will ensure that you do not accidentally use it to enter fresh data.
I think this much is enough....
subramanya