04 December, 2019

What is Inventory Stock Item, Groups and Units?


INVENTORY
The main concept of Trading activities are receipt of goods and delivery of goods. We generally call PURCHASE or SALE activities. The trading items can be RAW MATERIAL, FINISHED GOODS, SEMI FINISHED GOODS eat. For better Organization you can use the group and sub-group for classification of the trading item.

Inventory Info Menu
You can create the inventory form this menu, which contains the following options:
1.     Stock Group: Create your group here, for example, Raw Materials, Work-in-progress, Finished Goods, etc.
2.    Stock Items: Create your Stock Items  here, for example, TV. Sound System, VCD, etc.
3.    Voucher Types
4.    Unit of Measurement: Create your measurement Unit for Items, for example, LTR. MTR, PCS, BOX etc.
5.    Quit: Exit from the menu.
Before creating the Inventory info menu we should know what stock groups, stock items and units of measurement are.

What are Items, Groups and Units?


Definitions
Stock Items: Stock items the primary inventory entity, like Ledgers. Usually it means Item or Product. which can be buying, selling or issue for production purpose. Each item is required to be accounted for, and receipt or issue needs to be created. In fact, you will create a stock ledger accounted for, and Tally.ERP calls this account “stock Item”.

Stock Units: You can measure Stock Item by Units, like money is measured in Currency. For example, Liters, Meters , Kilograms, Pieces, Box, Dozen, etc. Units can be classified under the following types:
1.    Single Units: When only one Unit is used for receipt and issue of stock items. Abovementioned are all example of Single Units.
2.    Compound Units: When two different types of Units can be used for receipt and issue of the Stock item is called compound unit. For example:
First Unit    Conversion Factor     Second Unit
Dozen             12                                Pcs.
Meter             1000                            Millimeters.
 Box                30                               Pcs.

Stock Group: As per requirement of the business items can be created, but to generate a report on similar type of stock items you need the classification of stock items. This classification will help you to get stock report in an organized manner. For example, Raw Material, WIP, Finished Goods, Hardware, Software, Electrical, Electronics, etc.

Creating a Single Stock Group
Form this screen you can create a single stock group in the following manner:
Gateway of Tally.ERP – Inventory Info – Single  Stock Group – Create.
Enter the name of the Group.
Select the group under which this group will be classified.

Know this:
Alias
Enter additional name apart from primary name (if required). You can create any number of additional names.

Under
Specify whether it is a primary group or a sub-group of another group, by selecting from the list. Press Alt+C to create a parent group, if you do not have it in the list.

Can quantities of items be ADDED?
This field pertains to information measuring the units of the stock Items that you would categories under the stock Group.
The Stock Items categorised under the group should have similar units for them to be added up. You cannot add quantities in Kgs to quantities in Pcs.
Any modifications such as name, change of parent group is possible here.
Set/Alter GST Details: See GST Chapter
Modifying a Single Stock Group
Gateway of Tally.ERP – Inventory Info – Single Stock Group – Alter
Displaying a Stock Group
Gateway of Tally.ERP – Inventory Info – Single Stock Group – Display
Deleting a Single Stock Group
Gateway of Tally.ERP – Inventory Info – Single Stock Group – Alter



01 December, 2019

Pre-defined Voucher Types in Tally.ERP9


 Go to Gateway of Tally > Display > List of Accounts > Ctrl+V
                 Or
Go to Gate way of Tally > Accounts Info / Inventory Info > Voucher Types > Alter

Alter a Pre-defined Voucher Type:
Even if you do not need extra voucher types, you would normally Alter the predefined voucher types to customize them according to your needs to your needs, e.g.. to control their numbers.

  Go to Gateway of Tally > Accounts info/Inventory Info > Voucher Types > Alter



 The Voucher type creation screen is divided into three sections depending on various settings.
  • General
  • Printing
  • Voucher Class
Type of Voucher
The type of voucher should be any one of the predefined voucher types already listed. The new voucher type would inherit the properties of this predefined voucher type. It would function exactly like the predefined voucher.

Abbr (Abbreviation)
An abbreviation is required particularly for unformatted reports, which do not use compressing techniques. (Tally.ERP9 allows printing of both formatted and unformatted reports). Even if the abbreviation is not specified, Tally.ERP9 automatically sets a default name for the Voucher. In this example, Sale is the abbreviation. Though there is no restriction on the length of the abbreviation, it should preferably consist of five characters or less.

Method of Voucher Numbering
This is, perhaps, one reason for your opting for a new voucher type. There are three methods available.


Automatic
This method is flexible. If Automatic method is selected, then Tally.ERP9 numbers the vouchers automatically.

Automatic (Manual Override)
Select Automatic (Manual Override) if you want to auto-number the vouchers and manually override the auto-numbering, if required. For example, if the voucher number is 10, you can manually override the voucher number as required, say 21. The next voucher number will be 22.
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.

Manual
This method allows you to number the voucher manually. It dose not check for the sequence of the numbers and permits you to specify anything that you whis in the voucher number field. However, you may choose to prevent entry of duplicate numbers. If you would like to do so, the set Prevent Duplicates to Yes.

1. Prevention of Duplicates is possible if you enable the option at the time of creation. You may enable it later (by alteration) only if there are no transactions of this voucher type.
2. If you face difficulty duo to existing transactions, just create another voucher type for preventing duplicates of subsequent numbers.


Multi User Auto Voucher Numbering 
The Multi-User Auto Voucher Numbering feature in Tally.ERP9 works effectively in multi user environment where multiple users are working on the company data and recording vouchers.
Multi-User auto voucher numbering helps.

Where multiple users are attempting to pass a sales voucher simultaneously, the process may be hindered due to the voucher number allocation.

When a specific voucher number is used by one of user the other user will have to re-accept the voucher so that the next available voucher number is allotted to his voucher.

To ensure that the vouchers are numbered sequentially.

To ensure that the bill-wise details do not have to re-entered manually as it will get updated with the new voucher number on acceptance of voucher entry.

Let us consider three users: Mr. Mohan , Mr. Shyam. All the three users are typing to record a sales voucher. The voucher on each of their system is numbered as 25. Mr. Mohan saves the voucher fist and his voucher  will be saved as 25. But when Ram and Shyam attempt to save the voucher, the error mesage "Voucher Number 25 Already used! New number will be xx!" appears.

In order to eliminate this error message and avoid the re-acceptance of the voucher, Tally.ERP9 provides the option of Multi-User Auto Voucher Numbering.

Note: This will disable numbering of such vouchers. If you select this method,no further information is required.

Use Advance Configuration
If the Method of Voucher Numbering is set to Automatic, then an additional field to set the advanced configuration for the Voucher type is displayed. Setting this field to Yes, Voucher Type Creation (Secondary) screen is displayed.

30 November, 2019

A further discussion on these options is necessary.

A further discussion on these options is necessary.
Use EFFECTIVE dates for vouchers?
Select Yes if you want to enter effective dates for vouchers. You would opt for this if you have instances where a transaction under consideration for overdue/ ageing analysis is recorded currently but will come into effect form another date. If the effective dates is entered,the overdue/ageing will be considered form the effective date and not from voucher date.

Make Optional as Default
Setting this option to Yes, will set your Voucher to Optional Voucher by default. Refer to Optional Vouchers for further details.
Note: For Memorandum and Reversing Journal voucher the option Make Optional as Default will not be shown.

 Use common narration?
Select Yes to give a common narration for the entire voucher. Tally.ERP9 vouchers can have multiple entries. Hence, you may wish to give a common narration for all the entries of the voucher. Select No, you do not want a common narration.
Example of common narration  in a voucher: 

Narrations for each entry 
Select Yes, if you want to give a separation narration for each entry of a voucher. This would be applicable for a multiple entry voucher where you went separate details for each entry. Select No if you do not want a separate narration for each entry.

Note: To get the Narration for each entry raise the  sales in As Voucher and for Payment or Receipt vouchers, sel Use Single Entry mode for Pymt/ Rcpt/Contra to in F12:Configurations.

For Delivery Not. Receipt Not, Sales order, Purchase order, Physical Stock, Stock Journal, Rejection In and Rejection Out, the option Narration for each is deactivated. 

Print after saving voucher?
Select Yes to print every voucher after entering it, else select No. This is suitable for an online environment were you use Tally.Erp9 printed vouchers as the formal voucher. Remember, that the transaction is already recorded and posted and should you wish to make corrections to the printed voucher, you must alter the Tally.ERP9 voucher online and print it again.

Note: If we select Receipt as Type of Voucher the option Print Formal Receipt saving will be displayed. Depending on the Type of Voucher you have selectd to create or alter, different printing features appear in this field.
 

GSTR1, GSTR2A, GSTR3B details Complete discuss

GSTR1, GSTR2A, GSTR3B details Complete discuss
GSTR1

Sales

Goods @18% 220000/-
CGST @9% 19800/-
SGST @9% 19800/-
---------------------------
Total = 259600/-
---------------------------

GSTR2A

Purchase

Goods @18% 200000/-
CGST @9% 18000/-
SGST @9% 18000/-
---------------------------
Total = 236000/-
---------------------------


GSTR3B

Particulars                   Taxable Value           CGST          SGST
Outward Supplies           220000/-                   19800/-        19800/-
Outward Supplies           200000/-                   18000/-        18000/-

Tax Liabilities - Eligible ITC = Payable amount
CGST          19800/-         -    18000/-       =    2800/-
SGST          19800/-         -    18000/-       =    2800/- 

                  Eligible ITC - Tax Liabilities = ITC
CGST9%      36000        -     27000          = 9000
SGST 9%     36000        -     27000          = 9000
Tax Value    (400000)     -    (300000)

Eligible ITC IGST 18% 36000/- (200000 Purchase)
Tax Liabilities IGST 18% 9000/- (50000 Sales)
                        CGST 9% 15300/- (170000 Sales)
                        SGST 9% 15300/- 

IGST ITC 36000/- - T.L. IGST 9000 = 27000/- IGST ITC
IGST ITC 27000/- - T.L. IGST 15300 = 11700/- IGST ITC
IGST ITC 11700/- - T.L. IGST 15300 = 3600/- IGST ITC

Payable Tax Amount = 3600/- SGST 

26 November, 2019

Modification of Company in Tally ERP9



Modification of Company 

You can Modify your Company at any time, and for any information given Creating the Company.

Go to Gateway of Tally

1. Select F3: Cmp Info. (ALT+F3) form the button bar
2. Select Alter and press Enter

Deletion of Company 

To delete a company, you have to load the Company first.

1. Select F3: Cmp Info. (ALT+F3) from the Gateway of Tally to proceed to the Company Information menu.

2. select Alter and press Enter.

3.Select the Company to be deleted. the Company Alteration screen is displayed.

4.Use Alt +D to delete. Tally.ERP9 will prompt for a confirmation on deleting the company.

5. Press enter to delete the company.

Note: Deletion of a company is irreversible. The company is permanently deleted from the system.

Shut (Close) a Company

You can shut a Company in Two ways-either using the button F1: Shut Cmp (Alt+F1) from Gateway of Tally.ERP9 OR by pressing Enter on shut Company option from  Company Information Menu (Alt+F3). 

11 February, 2019

Classify the Accounts Group

Tally Practical Notes

Capital Account:- This records the Capital and Reserves of the company. The ledgers that belong to Capital Accounts are share Capital, Partner's Capital A/c, Proprietor's Capital Account and so on.

Reserves and Surplus [Retained Earnings]:- This contains ledgers like Capital Reserve, General Reserve, Reserve for Depreciation and so on.

Current Assets:- Current Assets record the assets that do not belong either to Bank Accounts or to Cash-in-Hand sub groups.

Bank Accounts:- Current Account, Savings Account, Short term deposit accounts and so on.

Cash in Hand:- Tally ERP 9 automatically creates Cash a/c in this group. You can open more than one cash account, if necessary.

Deposit (Asset):- Deposits contain Fixed Deposits, Security Deposits or any deposit made by the company (Not received by the company, which is a liability).

Loans & Advances (Asset):-This records all loans given by the company and advances of a non-trading nature (example: advance against salaries) or even for purchase of Fixed Assets. We do not recommend you to open advances to Suppliers' account under this group. For further details, please refer to the section on Common Errors.

Stock-in-Hand:- This group contains accounts like Raw Materials, Work-in-Progress and Finished Goods. The balance control depends on whether you have selected Integrated Account-cum-Inventory option while creating the company. (refer to Company creation section for more details) Let us consider these options:

Integrated Accounts-cum-Inventory:- This option has a significant effect on the Balance Sheet and Profit & Loss Account. If set to Yes, it brings the stock/inventory balance figures from the inventory records and provides a drill down to the Stock registers from the Balance Sheet.

          you are not allowed to directly change the closing balance of an account under this group. You are allowed to pass transactions in Inventory records and the account balances are automatically reflected in the Balance Sheet as Closing Stock.

Non-integrated Accounts-cum-Inventory:- If integrated Account-cum-inventory option is set to No, it ignores the inventory book figures and picks up manually entered entered closing stock balances from the ledger account created. This provides the facility to maintain accounts separately and inventory separately.
         You are not allowed to pass transactions if your accounts that come under this Group. It allows you to hold opening and closing balances only. Since no vouchers can be passed for these accounts, they are the only accounts for which the closing balances can be directly altered (by an authorised user only).

Sundry Debtors:- For customer accounts refer to common and possible errors in grouping of accounts section.
         Accounts like Outstanding Liabilities, Statutory Liabilities and other minor liabilities can be created directly under this group. Sub-groups under Current Liabilities are Duties and Taxes, Provisions and Sundry Creditors.

Duties and Taxes:- Duties and Taxes contain all tax accounts like VAT, CENVAT, Excise, Sales and other trade taxes and the total liability (or asset in case of advances paid) and the break-up of individual items.

Provisions:- Accounts like Provision for Taxation, Provision for Depreciation and so on are recorded under  Provisions.

Sundry Creditors:- For trade Creditors, refer to common and possible errors in grouping of accouts section.

Investments:- Group your investment accounts like Investment in Shares, Bonds, Govt. Securities, long term Bank deposit accounts and so on. This allows you to view the total investments made by the company.

Loan (Liability):- Loans that a company has borrowed, typically long-terms loans.

Bank OD Accounts [Bank OCC Accounts]:- Tally.ERP 9 provides you with distinct types of Bank Accounts,
Bank OCC A/c:- To record the company's overdraft accounts with banks. For example, Bill Discounted A/c's and Hypothecation A/c's etc.

Note: An account under Bank OCC A/c group is printed as a separate Cash Book in the traditional Cash Book format and does not from part of the Ledger.

Secured Loans:- Term loans or other long/medium term loans, which are obtained against security of some asset. does not verify the existence of the security. Typical accounts are Debentures, Term Loans, and so on.

Unsecured Loans:- Loans obtained without any security. Example: Loans form Directors/Partners or outside parties.

Suspense Account:- In modern accounting, many large corporations use a Suspense Ledger to track the money paid or recovered, the nature of which is not yet known. The most common example is money paid for Traveling Advance whose details will be known only upon submission of the Travelling Allowance bill. Some companies may prefer to open such accounts under Suspense Account.

Loans and Advances (Asset) group:- The suspense account is a Balance Sheet item. Any expense account even if it has 'suspense' inits name, it should be opened under Revenue group like Indirect Expenses and not under Suspense Account group.

Miscellaneous Expenses (Asset):- This group is typically used for legal disclosure requirements such as Schedule VI of the Indian Companies Act. It should hold incorporation and pre-operative expenses. Companies would write off a permissible portion of the account every year. A balance remains to an extent that cannot be written off in Profit & Loss Account. Tally ERP 9 does not show loss, carried forward in the Profit & Loss Account, under this group. the Profit & Loss Account balance is displayed separately in the Balance Sheet.

Branch/Divisions:- This maintains ledger accounts of all your company's branches, divisions, affiliates, sister concerns, subsidiaries and so on. Tally.ERP 9 permits Sales and Purchase transactions to take place with accounts opened here. Remember, these are their accounts in your books and not their books of accounts.
         Just treat them as any other party account. If you wish to maintain the books of a branch/division on your computer, you must open a separate company. (Tally.ERP9 allows maintenance of multiple company accounts).

Sales Account:- You can classify your sales accounts based on Tax slabs or type of sales. This also becomes a simple mechanism for preparation of Tax returns.

Examples:   
                  Domestic Sales
                  Export Sales
Now under Domestic Sales open the following ledgers:
Sales(10%)
Sales (5%)
Sales (exempt)
You can even open an account as Sales Returns under the group Domestic Sales to view your net sales after returns (or the returns may be directly passed though Journal against the specific Sales account).
Note: Do not create customer accounts under this group. For more details, refer to common and possible errors in grouping of accounts section.

Purchase Account:- This is similar to sales accounts, except for the type of transactions.

Direct Income [Income Direct]:- These are Non-trade income accounts that affect Gross Profit. All trade income accounts fall under Sales Accounts. you may also use this group for accounts like Servicing, Contract Charges that follow sales of equipment.
         For a professional services company, you may not use Sales Account group at all. Instead, open accounts like Professional Fees under this group.

Indirect Income [Income Indirect]:- These are miscellaneous non-sale income accounts. Example: Rent Received and Interest Received.

Direct Expenses [Expenses Direct]:- These are Manufacturing or direct trading expenses. These accounts determine the Gross Profit of the company.

Indirect Expenses [Expenses Indirect]:- All administrative, selling or non-direct expenses.
Profit & Loss Account is a reserved primary account in Tally.ERP9. you can use this account to pass adjustment entries through journal vouchers. For example, transfer of profit or loss account to Capital or Reserve account.