The master experience has been enhanced such that you can configure statutory details and get started with the transactions within no time.
The enhancements in masters and the steps to configure masters is as explained below:
If you have enabled within three statutory modules, then you can configure the statutory information in the ledger creation/ alteration screens.
If you have enabled more than three statutory modules, then enable the option Set/ Alter Statutory Details. You can configure details for each statutory module in the Statutory Details screen.
You can enter party's tax registration details, module-wise.
This will ensure a clutter free experience when creating/ altering masters.
It is now possible to create a tax ledger under current assets or current liabilities, and the ledger can now exhibit the properties of a ledger grouped under duties and taxes.
To modify the ledger behaviour
Click F12: Configure from the ledger creation/ alteration screen.
Enable Allow creation of tax ledger under other groups.
Press Ctrl+A.
Enable Behave as Duties and Ledgers.
Select the Type of Duty/ Tax.
Select the required tax information, depending on the type of duty selected.
Similarly, you can create a party ledger under loans and liabilities.
The change in behaviour will reflect for tax calculation, but doesn't have an effect on the reports.
You can now appropriate the ledger to the cost of the item from the ledger master screen, instead of the group.
To appropriate a ledger
Select the required Duty/ Tax Type in the field Include in Assessable Calculation for.
Select the Method of Calculation.
You can configure tax based on MRP from the ledger master.
To enable MRP based tax calculation
Set the option Enable Tax based on MRP to Yes.
Enter the MRP rate in the VAT/ Excise details screen.
For any voucher type, you can now define default accounting entries. This will populate information for the specified ledger, every time a transaction is recorded using this voucher type.
To set default accounting entries
Set Enable Default Accounting Entries to Yes in the required voucher type creation/ alteration screen.
Enable the option Set/ Alter Default Accounting Entries.
Select the Ledger, required and define the percentage of allocation.
Press Ctrl+A.
For any voucher type, now you can define default accounting entries. This will populate the ledgers by default, every time a transaction is recorded using this voucher type.
The process of Data Migration from Release 4.9x and lower versions to Release 5.0 is inherently handled in Tally.ERP 9. The process ensures complete financial data integrity to the last decimal with corresponding hierarchy.
Post migration, Tally.ERP 9 will identify the master and vouchers with gap in information and marks them as uncertain transactions. These records will not participate in forms and annexures. However, the necessary statutory details for these can be configured from a single screen without having to go to each master and transaction.
This section explains configuring statutory settings in migrated data records to enable participation in forms and annexures. Further, the flexibility and intuitive intelligence provided by Tally.ERP 9 5.0 to maintain statutory records is also explained.
The configuration is demonstrated using a VAT return form as an example (the same applies to other statutory reports). All the records marked as uncertain will be listed in Summary of Exceptions screen that can be viewed by drilling down from Uncertain Transactions in the VAT returns report.
Masters or transactions with gaps in information appear under one of the heads in Summary of Exceptions screen. Provide the required information, and resolve the exceptions. For instructions on resolving the exceptions, click here.
The new approach helps customers to have a clean Chart of Accounts (CoA) based on their business need, and not have sales/purchases ledgers that are based on tax rates.
With Tally.ERP 9 Rel 5.0 you can have a common sales/purchase account, and common tax ledger for VAT, as the tax rates can be defined anywhere starting from company master to stock item directly. You can now use a single sales ledger for all sales transactions, and not use multiple sales ledgers in transactions recorded for items with different tax rates.
This new flexibility can be used in data migrated from lower versions also. The process involves following steps:
a. Creating masters to support single sales ledger mode
b. Taking steps to maintain single sales ledger
c. Recording transactions with single sales ledger
If you are migrating data from lower releases, and want to use a single sales ledger in all sales transactions (or purchase transactions), the following are the changes that are required in your masters:
Configure tax details in stock group/stock item master. At voucher level, tax details will be captured from stock group/item, and not from sales ledger. To know how to create a stock group/item, click here.
Creating Stock Group/Item with VAT details
To define VAT rates at the stock item level
1 Go to Gateway of Tally > Inventory Info. > Stock Groups > Alter.
2 Select the required Stock Group.
3 Enable Set/ Alter VAT Details.
4 In the VAT Details screen, enter the VAT Rate and select the Tax Type.
5 Press Enter.
6 Press Enter to save.
To define VAT rates at the stock item level
7 Go to Gateway of Tally > Inventory Info. > Stock Items> Alter.
8 Select the required Stock Item.
9 Select Applicable in the field VAT Applicable.
10 Enable Set/ Alter VAT details.
11 In the VAT Details screen, enter the VAT Rate and select the Tax Type.
12 Press Enter.
13 Press Enter to save.
Configure tax details in VAT duty ledger. For instructions to create a VAT duty ledger with tax details, click here.
Defining Tax Rate at Tax Ledger Master
To create a ledger
1 Go to Gateway of Tally > Accounts Info. > Ledgers > Create.
2 Enter the Name of the ledger.
3 Select Duties & Taxes from Under field.
4 Select VAT in Type of Duty/Tax field.
5 Set Use for Purchase Tax to No.
6 Enter the VAT rate in Percentage of Calculation. The rate entered here will be used for calculating VAT in the invoice.
7 Press Enter to save.
Create a sales ledger to be used as common sales ledger, without tax details. For instructions to create a ledger, click here.
Creating Sales Ledgers without Tax details
To create as sales ledger
1 Go to Gateway of Tally > Accounts Info. > Ledgers > Create.
2 Enter the Name of the sales ledger.
3 Select Sales Accounts in the Under field.
4 Set Inventory values are affected to Yes.
5 Select Type of Ledger as Not Applicable.
6 Set Is VAT/CST Applicable to Applicable.
7 Disable Set/Alter VAT Details.
8 Press Enter to save.
Map an existing ledger to be used as single sales ledger. For instructions on mapping, click here.
Map a ledger to be used as single sales ledger
To mark sales ledgers as applicable for VAT/CST
1 Select Unable to determine tax details of the stock group/stock item(s) in the Summary of Exceptions screen.
2 Press Enter to drill down.
3 Click F6: Ledger button to display ledgers.
4 Select a sales ledger and press Ctrl+Enter to open the Ledger Alteration (Secondary) screen.
5 Select the option Applicable in the Is VAT/CST Applicable field.
6 Press Enter to save.
This ledger is enabled for VAT/CST but tax details are not defined allowing you to use the ledger in sales transactions of goods taxable at any rate.
After switching to using single sales ledger, the sales balance from multiple ledgers used till date has to be transferred such that accurate sales figures including sales values are reported before switching:
Transfer values from existing sales ledger to one single sales ledger. For instructions on transferring the value, click here. All values from existing sales ledger will move to single (common) sales ledger after transfer.
Create journal for transferring sales values
To create journal voucher for transfer
1 Go to Gateway of Tally > Accounting Vouchers > F7: Journal.
2 Select the existing sales ledgers one by one and enter the closing balance of the ledger in the Debit column.
3 Select the newly created common sales ledger, the Credit value is automatically displayed (sum of all the debit values in the voucher)
4 Press Enter to save.
Discontinue other sales ledgers such that the same do not display in statutory reports. For instructions on discontinuing ledgers not used, click here.
Discontinue Other Sales ledgers in migrated data
To mark sales ledgers as not applicable
1 Select Unable to determine tax details of the stock group/stock item(s) in the Summary of Exceptions screen.
2 Press Enter to drill down.
3 Click F6: Ledger button to display ledgers.
4 Select a sales ledger and press Ctrl+Enter to open the Ledger Alteration (Secondary) screen.
5 Select the option Not Applicable in the Is VAT/CST Applicable field.
6 Press Enter to save.
7 Follow the same steps for other sales ledgers.
While recording sales invoice using single sales ledger, the following should be ensured:
The Nature of Transaction is selected manually.
The items selected have tax details configured.
VAT duty ledger is selected to calculate tax.
Select party location at voucher lever, if not recorded in party master.
Click here for instructions on creating sales invoice.
Creating Local Sales Invoice
If the company is trading in multiple items attracting single VAT rate, the VAT rate defined in Stock Item Creation screen can be considered for calculation.
To create a local sales invoice for taxable goods with multiple VAT rates
1 Go to Gateway of Tally > Accounting Vouchers > F8: Sales.
2 Enter sales invoice number in Ref field.
3 Select Party's A/c Name from the List of Ledger Accounts.
4 Select the common sales ledger grouped under Sales Accounts in which the option Is VAT/CST Applicable is enabled, and Set/Alter VAT Details is disabled.
5 Select Sales Taxable as the Nature of Transaction.
6 Select the required stock items whose tax rates are defined either at the stock item level or group level. Enter the required Quantity and Rate for each.
Below the stock item, the selected classification will appear along VAT rate and assessable value on which the tax is calculated.
Note: The stock item is not configured for tax inclusion and MRP
7 Select the common VAT ledger grouped under Duties & Taxes which has its options specified as follows:
8 Use for Purchase Tax is disabled.
9 Percentage of Calculation is set as zero.
10 Press Enter to save.
Note: The tax for each item is calculated based on rate specified in the stock item master by selecting On Quantity in the Calculation Type.
11 Set Provide VAT Details to Yes/No as per requirement. If this option is enabled, enter the required details.
12 Press Enter to save.
You can continue to use multiple sales ledgers that are already created. In such a case the exceptions in each ledger have to be resolved before using them. For instructions on resolving exceptions, click here.
Next:
'Configuring Statutory Details in Masters' has been shared with