How to enter Cash/Bank A/c in Journal?

Many of the Tally users wish to use Cash A/c in Journals. But the list of Ledgers may not show Cash or Bank A/c in Journal vouchers. The solution is simple.

In Journal voucher screen, press F12 ->Set Allow Cash A/c in Journals option to YES. You will see all the Ledgers appear in the list.

Export to Excel(.xlsx) from Tally.ERP9

Tally.ERP9 provides an option to export its document or report to the formats like ASCII, ,XML,HTML Excel, PDF, JPEG etc. From MS Office 2007 onwards, the excel file default extension becomes .xlsx whereas Tally.ERP9 generates exported file as .xls. Many users use the default settings while exporting to excel and the excel file gets opened with a warning dialog box with a message of incompatible format. One option is to click on YES button. The alternate solution to edit the filename extension from .xls to .xlsx on Export settings form. 

This is required only for MS Office 2007 or later

This editing can be done as follows: 
  1. A conformation dialog box appears when you click on Export button
  2. Make sure the format select is EXCEL
  3. Press BACKSPACE and change the file extension from .xls to .xlsx
  4. Open Exported File option must be YES
  5. Accept the settings (CTRL + A)
  6. Click on YES or press Y
The file will get opened without any warning

How to use Fixed Assets/Expense ledgers in tally?

Many of the Tally users wish to use Fixed Asset and Expense ledgers in Purchase related Vouchers. But the list of Ledgers will show only Purchase ledgers. 
There is a simple and quick solution.
In Purchase voucher screen, press F12 ->Set Allow Expenses/Fixed Assets for Accounting Allocations option to YES. You will see all the Fixed Assets and Expense Ledgers appear in the list.

Manual Voucher Numbering in Tally.ERP 9

Enable Manual Numbering in Tally.ERP9

By default, Tally.ERP9 vouchers have Automatic Voucher numbering. It's useful when you don't have to post backdated vouchers. Automatic Voucher Numbering in Tally.ERP9 rearranges the numbers according to the voucher date, when you post backdated vouchers. If you have filed a printed copy of the voucher, there will be mismatch after backdated entry. You will find a different voucher in the system with the same number as in the file.

Best way to avoid this issue is to set the numbering as Manual when you start using the Tally.

If you start tally for the first time

Gateway of Tally->Accounts Info->Vouchertype->Alter-> [Select the vouchertype]-> Set the Method of Voucher Numbering to Mnaual->Set Prevent Duplicates to Yes

If you are an existing Tally user

Changing the numbering method to Manual for the vouchertypes having vouchers does have an issue It will blank the voucher numbers for the all the vouchers. So best method id to create a new vouchertype.
 
Gateway of Tally->Accounts Info->Vouchertype->Create-> Give any suitable name-> Select Type of Voucher-> Set the Method of Voucher Numbering to Mnaual->Set Prevent Duplicates to Yes


The number field will show blank whenever you create a new voucher. There is a shortcut key to get the last voucher number, CTRL+R.

ترجمة الصفحة Translate