Main Menu>Master Data management> Accounts> Tax Master
Create a Tax Head for each Tax accounts and link the Tax head with Ledger Account to which the Tax amount would be posted.
Fields in the Tax Master are as follows:
Tax Name
|
Select the Tax Head Name (e.g VAT)
|
Included in Rate
|
Set Yes, if the Tax is included in the price. In that case, tax would be automatically computed internally and posted to the ledger. For example if Output Vat 10% is included in price, for a sale value of Rs.100 including VAT, the VT would be computed as 100/11 = 9.09 & Sale Value would be calculated as Rs.90.91 and accordingly the values would be posted to the respective ledger accounts.
Set No if the Tax is to be separately charged.
|
Calculation Method
|
Tax can be charged both on actual item rate or discounted item rate. Set "Quantity * Rate" to charge tax on actual rate, set "Default" to charge tax on discounted rate.
Default
|
Sub Total = Rate, Item Discount = Rate * Disc %, Tax Total = (Sub Total – Item Discount) * Tax %.
Sub Total = Rate – Tax Total, Item Discount = Rate * Disc %, Tax Total = (Sub Total – Item Discount) * Tax %.
|
Quantity * Rate
|
Sub Total = Rate, Item Discount = Rate * Disc%, Tax Total = Rate * Tax%.
Sub Total = Rate - Tax, Item Discount = Subtotal * Disc%, Tax Total = Rate - (Rate*100/110.30).
|
|
Next, enter the Tax name and breakup of the Tax. For example, if Service Tax is 12.36% and it has 3 components for accounting, Service Tax 12%, Education Surcharge @ 2% on Service Tax & Higher Education tax @ 1% on service Tax, the total service Tax would be 12.36% (12% + 2% of12% + 1% of 12%).
In that case, you will enter following names & rates under Service Tax head
•Service Tax - 12.00% •Education Cess - 00.24% •Higher Education Cess - 00.12% •Total- 12.36%
EXAMPLE:
Tax Name
|
Service Tax 12.36%
|
Included in Rate
|
Select YES if the Tax is included in Item Rate (no tax will be further added but the tax amount will be back computed and posted to the Tax Ledger). Set No if the Item Rate is exclusive of Tax (Tax will be added extra and posted to the ledger account)
|
Component Tax Ledgers:
Srl
|
Account
|
Tax %
|
1.
|
Service Tax 12% (Ledger / Account Head under Duties & Tax Group) – Select account from list of account or press CTRL + N and create new.
|
12.00%
|
2.
|
Surcharge 10% on Service Tax (Ledger / Account Head under Duties & Tax Group) – Select account from list of account or press CTRL + N and create new.
|
00.12%
|
3.
|
Education Cess 20% on Service Tax (Ledger / Account Head under Duties & Tax Group) – Select account from list of account or press CTRL + N and create new.
|
00.24%
|
In the above example, 3 different ledger heads are defined and tax 12.36 will be split and posted in respective 3 different ledger accounts. To post to a single ledger instead of 3 ledgers, set as follows:
Srl
|
Account
|
Tax %
|
1.
|
Service Tax 12.36 % (Ledger / Account Head under Duties & Tax Group) – Select account from list of account or press CTRL + N and create new.
|
12.36%
|
|
Buttons in the Tax Master are as follows:
|
Tax Master Display Screen is as follows:
|
In Sale Touch POS and Scan Pos need a process to remove service charge in a single click
In restaurants, service charge is not mandatory, and owners can apply the service charge in the bill, customers can refuse to pay, so removing service charge is a tedious job. With a Single Click, Customers can remove Service Charge in the bill.
In Tax Master (MAT) - add an option
Equivalent Tax Without Service Charge = List of tax master
In Sale Scan, Pos and Touch Pos - added a button "Remove SC" in the order screen.
It will be used to change the default tax applied in the bill with the tax mapped against Equivalent Tax Without Service Charge in tax master.
Need calculation method on quantity in Tax Master
Scenario:
In GST, on some products like Tobacco, there is cess or additional cess charged on quantity, for example Rs.2647 per thousand on Cigarette with filter etc.
Solution:
In Tax Master (MAT) : We have added one more calculation method "On Quantity" in Type List. On this type tax will be calculated on item quantity instead of item amount.
Enhancement in Tax Master for Selecting Sale Ledger in Accounting Entry Based on Applied Tax.
Scenario:
As per GST, there are 2 types of tax rates for any product in garments i.e. 5% GST for up to Rs.1000/- garment & 12% GST for above Rs.1000/- garment. Till now, in the accounting entry, the sale ledger is picked by system based on
●Sale Ledger defined in Product Master
●Sale Ledger define in Sale Option
But there is no provision for item that is taxed @5% or 12% as per the slab, goes to Sale A/c "Sale GST @5%" or "Sale GST @12%" respectively. In Current Scenario, when we are exporting all data (Sale & Purchase) to TALLY , it is not reflecting in GST report properly as required.
Solution:
Added a section Account Mapping with following fields in Tax Master
●Sale Ledger : List of Ledgers under sale account group
●Sale Return Ledger : List of Ledgers under sale account group
●Purchase Ledger : List of Ledgers under Purchase account group
●Purchase Return Ledger : List of Ledgers under Purchase account group
Added an option in Voucher Option of Sale, Sale Return, Purchase, and Purchase Return
●Select Default A/c From = Product / Tax
○Product: Account ledger will be selected as per mapping in product master. and if it is None, then it will take ledger from voucher option.
○Tax: Account ledger will be selected as per mapping in Tax master. If is is none then it will pick ledger from voucher option.
Guidelines to implement Indian GST in RanceLab
Added 5 more line items in the Tax Type List. Based on these types you can define different type of tax in GST
●CGST (Central Goods and Service Tax)
●SGST (State Goods and Service Tax)
●IGST (Integrated Goods and Service Tax)
●UGST (Union Territory Goods and Service Tax)
●CESS On GST – For Additional Cess on GST