Navigate through Display → Account Books → Ledger a. Select a Ledger whose Vouchers are to merge in another Ledger b. Select Vouchers by pressing “Space Bar” which are to be merge in another Ledger c. Press Alt+F7 or “Merge Ledger” button.
We can copy and paste similar to Microsoft Excel or Microsoft Word. The only difference is we have to add “ALT” Key while copy and paste in Tally ERP 9. Select the Text which has to be pasted in Tally ERP 9. Press Ctrl + C to copy the narration/ text.
Navigate through Display → Account Books → Ledger a. Select a Ledger whose Vouchers are to merge in another Ledger b. Select Vouchers by pressing “Space Bar” which are to be merge in another Ledger c. Press Alt+F7 or “Merge Ledger” button.
What are the Shortcut Keys We can Use While Passing a Voucher Entry in Tally.ERP 9?
| Shortcut Key | Shortcut key function |
|---|
| ALT + X : - | To cancel a voucher |
| CTRL + A : - | To accept a form |
| CTRL + V : - | To toggle between invoice and voucher mode |
| ALT + I : - | Insert a Voucher |
To split the company data, Go to Gateway of Tally > F3: Cmp Info. > Split Company Data > Select Company. Once you've selected the company, enter the date in the Split From field and press Enter.
How to Copy Tally Data in Pendrive
- F1 Select Company.
- Tally Path shown at top (Suppose Tally path is C:UsersPublicTally.ERP9Data)
- Check Company Name and Number whose Data required to be copied.
- Go Manually to Path (Go to C Drive-->Users-->Public--->Tally ERP 9-->-Data)
- Copy Data Folder of Company which is required.
- Paste in Pendrive /Send to Pendrive.
- Select the option Multi Voucher Printing from Printing Menu. Select the name of Voucher Type as shown below.
- Accept Blank field for From and To.
- Click Yes to Print, then you can see the print preview for 5 vouchers as shown: Note: For multi voucher printing ensures that the method of voucher numbering is Automatic.
Restore the backup in the folder format
- Go to the location where the data was backed up.
- Press Alt+D or click the address bar. The location will be highlighted in blue.
- Press Ctrl+C to copy the path.
- Open Tally. ERP 9 and select the company.
- Press Ctrl+Alt+V to paste the location.
Export Masters
- Go to Gateway of Tally > Display > List of Accounts .
- Click E : Export .
- Press backspace to configure the export options. Select the Language . Select the Format .
- Enable Export Closing Balances as Opening , if required. The Export Report screen appears as shown below:
- Press Enter to export.
Backup Data
- Go to Gateway of Tally > F3 : Cmp Info > Backup to view the Backup Companies on Disk screen.
- Source - The folder path where your company data is stored.
- Destination - The folder path where the data backup has to be stored.
- Select the required company from the List of Companies .
There is also an option to Export data from Tally to MS Excel.
- Start Tally ERP and Open a Company.
- Start udiMagic software.
- Select the option "Excel to Tally"
- Select the option "Import data into Tally"
- Click the Browse button and select any Standard Excel template provided with udiMagic converter.
- Click the Start button.
Answer
- Yes, you can export the required ledgers to a new company.
- Load both the existing company and new company in Tally.
- Select the required company whose masters are to be exported.
- Go to Gateway of Tally > Accounts Info > Ledger > Alter.
- Select the required Ledger.
How to convert a XLS to a XML file?
- Choose the XLS file that you want to convert.
- Select XML as the the format you want to convert your XLS file to.
- Click "Convert" to convert your XLS file.
A] Tally XML Interface (Read and Write)XML (Extensible Markup Language) is the standard for information exchange with external systems. Tally. ERP 9 supports standardized message formats for Request/Response.
Solution(By Examveda Team)ERP 9, they are: Cash - This Ledger is created under the Group Cash-in-hand. You can enter the opening balance as on the date of books beginning from. You can also alter the name and even delete the Ledger.
Tally. IMP file is log (information) file where it record successful and failed transaction (import).
Migrate data from Tally 5.4, 6.3 and 7.2 to Tally.ERP 9
- Copy company data of Tally 5.4, 6.3 or 7.2 to Tally.
- Start Tally.
- Select Migrate Data in the Tally.
- Enter the company data path in the field Directory and select company in the field Name .
- Click Yes for the message prompt Rewrite? .
For voucher entry in Tally Accounting Vouchers submenu is used.
ERP 9 Series A Release 3.1 and below Go to Gateway of Tally > F11: Features > Accounting Features Set “Yes” to the Options "Enable Duplicate Purchase Voucher Entry Control ?" Page 5 5 For Tally.
Most useful short cut keys in tally erp 9
- ALT + 2 is the one of the useful shortcut key, these option is available in day book, ledger and reports like sales register, purchase register etc.
- PGUP (Page Up) is the shortcut keys for viewing previous voucher in alteration mode, you must be on a voucher entry screen to use this shortcut key.
Tally Shortcuts
| Shortcut | Description |
|---|
| CTRL + A | To accept a form – wherever you use this key combination, that screen or report gets accepted as it is. |
| Ctrl+Alt+B | Check the Company Statutory details |
| Ctrl+M | Switches to Main Area of Tally Screen |
| Ctrl+N | Switches to Calculator / ODBC Section of Tally Screen |
How do I find Duplicate entries in Tally?
- Go to the Gateway of Tally → Display → Statement of accounts → Statistics.
- After completing the voucher, the user has to select the voucher for which the duplicate entries have to be checked.
- After selecting the voucher type, it is time to press F12 and select the sorting method. Select increasing or decreasing.
Alt 2 will take you to the voucher entry screen there you don't need to accept the all entries, you can directly save the entire voucher without asking y/n by pressing Ctrl A. If you are doing totally new voucher entry before typing narration press Ctrl A, will save the entry without asking y/n.
1. Press Alt + E from the above-mentioned path (Tally Main–> Gateway of Tally–> Display Menu–> List of Accounts), for the purpose of Export of Masters. 3. Repeat step 1 and the notes as stated above for all the companies you wish to merge.
Automatic (Manual Override)Set Prevent Duplicated to Yes to avoid duplicate voucher numbers during entry. You can enable this option only if there are no transactions of this voucher type.
Any written documentation supporting the entries reported in the account books, indicating the transaction's accounting accuracy, can be referred to as a voucher. For example, a bill, invoice, receipt, salary and wages sheet, pay-in-slip counterfoil, cheque book counterfoil, or trust deed.
Tally. ERP 9 allows you to transfer materials from one Godown to another. The transfer of materials is done using the Transfer Journal Voucher.
A voucher is a document that contains details of a financial transaction and is required for recording the same into the books of accounts. The voucher entry menus options are available under Transactions in the Gateway of Tally .
To record any transaction in account books, first of all a voucher is prepared by the accountant. Therefore, we call the vouchers as the base of the accounting system. Voucher is prepared by the accountant with the help of source document. Source document means any proof relating to the business transactions.
A voucher is a certificate or document that either allows you to purchase something or proves that you paid for something. A voucher is sometimes valuable. When you can vouch for someone, you're willing to recommend them and say they're a good person.
Voucher is a 'coupon' given to a guest for a specific prepaid service (accommodation in a hotel) handheld out by a travel agency. As a form of a 'receipt' the traveler can then claim the service he paid for. This voucher is then to be presented to the hotel at the time of check in.
A Credit Voucher contains the monetary value which was paid for that Credit Voucher at the point of purchase. It has no cash redemption value and cannot be exchanged for cash. Credit Vouchers can be used as full or part payment for Tickets.
When a company buys goods on credit or cash, Purchase voucher is used to record all the Purchase transactions of the company. Go to Gateway of Tally > Accounting Vouchers.
Vouchers are of two types: source voucher and accounting voucher. Accounting Vouchers are further classified as cash and non-cash vouchers.
