Tuesday, August 7, 2012

Printing Reminder Letters to a group of ledgers in Tally.ERP 9


How do I print Reminder letters for a Group of Ledgers?

§       From the Gateway of Tally, go to Multi-Account Printing > Outstanding Statements > Ledgers > Group of Accounts
§       Select the Group for which reminder letters are required, e.g. Sundry Debtors.



§       Against the option to Print? Select No
§       The report by default is a Bill-wise details report that lists the outstanding bills for each ledger in the group.
§       Tab down to the option Print Reminder Letter. Set it to Yes.
§       Set the Age periods. (Eg. 0 to 30, 30 to 60, 60 and Above). Save the settings.
§       Type the name of the Designation of Signing Authority in the field provided.
§     Set the option Confirm to Print  as either Yes or No.

Content of a Reminder Letter

Tally.ERP 9 has pre-defined content for its reminder letters. However, you can change the content as required.

§       From the Gateway of Tally, Go to F12:Configuration > Printing > Reminder Letters
§       The Reminder Letter Configuration window opens



§       Modify the contents in the First and Second Paragraphs
§       Press the Enter button to save the information and exit from the window.

A Print out of the Reminder Letter is displayed as shown below:


Schedule-VI Profit & Loss A/c @ Tally.ERP9

How to generate Schedule-VI Profit & Loss A/c using Auditors' Edition of Tally.ERP 9?


Using Auditors' Edition of Tally.ERP 9, the Schedule-VI Balance Sheet can be generated on click of a button.
To generate the Schedule-VI Profit & Loss A/c,
Go to Gateway of Tally > Audit & Compliance > Financial Statements > Profit & Loss A/c
  • Press Ctrl+F3 to load the Previous Years company to generate the Schedule-VI Profit & Loss A/c with two years data
   
The default Tally.ERP 9 Groups are mapped to the Schedule VI groups by default as per the pre-defined rules and this can be changed if required.
  • Press Alt+P to print the Schedule-VI Profit & Loss A/c
  • Specify the printing details as shown below:
   
    Press Enter to print the Profit & Loss A/c
The printed Schedule-VI Profit & Loss A/c appears as shown below:


    

The Auditor can make the necessary changes before printing the Profit & Loss A/c statement by moving the Ledgers/Groups to the respective Income or Expense Group.

Generate Schedule-VI Balance Sheet @ Tally.ERP9

How to Generate Schedule-VI Balance Sheet using Auditors' Edition of Tally.ERP 9?


Using Auditors' Edition of Tally.ERP 9, the Schedule-VI Balance Sheet can be generated on click of a button.
To generate the Schedule-VI Balance Sheet,
Go to Gateway of Tally > Audit & Compliance > Financial Statements > Balance Sheet
  • Press Ctrl+F3 to load the Previous Years company to generate the Schedule-VI Balance Sheet with two years data
  

The default Tally.ERP 9 Groups are mapped to the Schedule VI groups by default as per the pre-defined rules and this can be changed if required.
  • Press Alt+P to print the Schedule VI Balance Sheet
  • Specify the printing details as shown below:
  
    Press Enter to print the Balance Sheet
The printed Schedule-VI Balance Sheet appears as shown below:

   
The Auditor can make the necessary changes before printing the Balance sheet by moving the Ledgers/Groups to the respective Schedule VI groups.

Reducing closing stock quantity and value in Tally.ERP 9

Reducing Closing Stock Quantity and Value in Tally.ERP 9



the quantity and the valuof closing stock in Tally.ERP 9?
Solution
Tally.ERP 9 facilitates the reduction of the value as well as the quantity of closing stock.
Illustration:
On 6th August, 2011, ABC Company made a physical verification of its stock and found that the closing balance of Item A was 290 nos.,but the same as per books was 300 nos. ABC Company wants to reduce the closing balance of Item A accordingly.
Their Stock Summary appears as shown:

Follow the given steps to reduce the quantity of closing stock:
To reduce the quantity of closing balance,
Go to Gateway of Tally > Inventory Vouchers > Physical Stock Journal
·         Select the stock item for which the closing balance needs to be reduced (here, Item A).
·         Enter the actual quantity in the Quantity field (here, 290 nos.).
·         Press Enter to accept.

The completed Physical Stock Journal appears as shown:

Go to Gateway of Tally > Stock Summary.

The closing balance quantity of the selected stock item appears reduced, as seen here:
  
To reduce the value of the closing balance,
If, in the same case, ABC Company were to find that the quantity of stock as per books and quantity as per physical verification were the same, but the value of the stock had to be reduced, the following should be done to effect the same:
Go to Gateway of Tally > Inventory Vouchers > click on F10Rej Out or press Alt + F10 for the Rejections Out Voucher.
  • Select any party’s ledger or even Cash ledger under Ledger Account and give the appropriate stock item under Name of Item (here, Item A).
  • Enter only the amount to be reduced and press Enter to accept.
  
Go to Stock Summary (Gateway of Tally > Stock Summary)
The closing balance value of Item A is reduced as shown:
  
Note: Before making an entry in the Rejections Out Voucher to reduce the value of the closing balance, ensure that the option Allow Zero valued entries in F11: Features > F2: Inventory Features

How to Print ALL the Ledgers in Alphabetical Order in Tally.ERP 9? @ Tally.ERP9

How to Print ALL the Ledgers in Alphabetical Order in Tally.ERP 9?


To print the ledgers in alphabetical order:

Go to Gateway of Tally > Multi Account Printing > Account Books > Ledger > All Accounts

·         Set Alphabetical Print Range to Yes
o    From (Blank for beginning): Type the beginning Alphabetical range in the field provided.
o    To (Blank for End): Type the ending Alphabetical range in the field provided.

Note: This option allows you to print the ledgers based on the alphabetical order, namely 0 to 9 and A to Z.

  
·         Accept to print.
Note:
·         This option is also available for Cash/Bank Book groups, Group of AccountsInventory Books - All Items and Group of Items.
·         This option will skip in case you have set Yes to Allow Selection of Groups/Ledgers while printing All Ledgers.

Is it possible to show the additional cost of purchase separately in Tally.ERP9? @ Tally.ERP9

Is it possible to show the Additional Cost of Purchase separately in Tally.ERP9?


es, it is possible. To show the additional cost of purchase separately assume as, ‘Transportation Charges’ .This amount of additional cost must get included to the cost of item. To get the result, kindly follow the steps mentioned below:

Create an item called ‘Item – 123’ :


Raise the purchase invoice:

  

Now check the report in the stock summary.

  

It will show the closing balance as Rs.10,000/-

Check the report of stock items, from the Gateway of Tally à Display à Inventory Booksà Movement Analysis à Stock Item Analysis à select the related Item.


    

Pay the ‘Transportation Charges’ . It must increase the cost of item.

Create the ‘Transportation Charges’ ledger under Indirect Expenses and set  the option 'Inventory Values are affected’ to 'Yes' .

  

Now raise the journal entry in the Journal Voucher:

Below you can see the screen of  ‘Transportation Charges’ entry.

  


Once you select the ledger  called ‘Transportation charges’ you will get the ‘Item allocation’ screen. Select the item and enter the amount.

Note: Do not mention the quantity and rate.


  

Now check the stock summary and movement analysis:
Go to Gateway of Tally à Stock Summary à select the Item à Stock Item Monthly Summary

  

Go to Gateway of Tally à Display à Inventory Book à Movement Analysis à Stock Item Analysis à select the Item from the List of Items à Item Movement Analysis à Item Voucher Analysis.

Here you can see that the additional expenses of Transportation Charges  being included in the additional cost also.

  

I would like the interest to be calculated in Tally at specified rates for a range of periods as follows: @ TallyERP9


I would like the Interest to be Calculated in Tally at specified Rates for a range of periods as follows:

 0  to  30 days   - No interest
31 to  45 days   - @ 15%
46 to above      - @ 20%

Please suggest how the same can be implemented in Tally.ERP 9

Solution

Follow the  steps  mentioned below to calculate the following:

1. Enable the bill-wise details in F11 feature F1 Accounting Features

 
2. Specify the Interest parameters in the party ledger as shown below:

  


3. Sales Entry: While passing the sales entry, say on 1st of April 2009 for Rs.1,00,000/-, specify the period under Interest Parameters after the bill-wise details of a party are entered, as follows:

Bill-wise Details:

Credit Days – 30 days (wef 1.-4-2009)

Interest Parameters

Rate: 15 %, from Due Date of Invoice/Ref Date:  1-May-2009  To 16-May-2009 (period of 15 days, for 31 to 45 days)
Rate: 20 %, from Due Date of Invoice/Ref Date: 16-May-2009  To  (for 46 days onwards) 


  
4. Accept the sale entry after specifying the interest details.

5. The Interest Calculation report will display the details as shown below:

Go to Gateway of Tally > Display > Statement of Account > Interest Calculation > Ledger > select the party

  

CLICK HERE.... TO KNOW MORE

How to specify "Batch wise details? @ Tally.ERP9


How to specify "Batch-wise Details?


·  Go to Gateway of Tally --> F11:Feature (F2:Inventory Feature) --> Set Maintain Batch-wise Details = "Yes" -->  Save.


  

·  Go to Gateway of Tally --> Inventory Info --> Stock Items --> Create/Alter -->  Activate Maintain Batch-wise Details = "Yes" -->  Save



  
This will allow you to specify the batch wise details for the stock item while entering the Opening Balances and the transactions
  • Pass Purchase entry
  • From Gateway of Tally > Accounting Voucher > Press F9:Purchase, While passing the Purchase entry In Item Allocation screen Give the Batch number as Engine Number.
  

  

  • Check the Stock summary in detailed mode.

  

  • Pass a Sales entry
  • From Gateway of Tally > Accounting Voucher > Press F8:Sales then pass the Entry By tracking the Batch number.



How to avoid the quantity details against each item in the List of Stock items pop-up screen while selecting the item during invoice entry.


How to Avoid the Quantity Details against each item in the List of Stock items Pop-Up Screen while Selecting the Item during Invoice Entry.

Go to Gateway of Tally > F12: Configuration Menu > General and Set Yes to Use Common Table for Stock Items


Tally.ERP 9 allows you to select the required details from List of Stock Items based on the full or partial search keywords like Item name etc. In this case it will display only the list ofstock items without quantity details.

Monday, August 6, 2012

TOP 5 QUESTIONS BASE @ Tally.ERP9


Query-1
Do I need to go to Gateway of Tally to Load the previous Year Company for Comparison?
Answer-1
No, to compare the Company data in Statutory Audit tool, you can open the Previous Year Company either from the Statutory Audit Dashboard or from Schedule VI Balance Sheet Dashboard by pressing Ctrl+F3 and selecting the required company.


Query-2
 We had changed the current period to 1-4-2009 to 31-3-2010 but it continues to display 1-4-2008 to 31-3-2009 as the current period in Gateway of Tally. What should I do?

Answer-2
 It is essential to change the period to the next financial year before recording the transactions. On recording a transaction for the period 1/4/2009 – 31/3/2010, Tally.ERP 9 will automatically change the period to current financial year beginning from 1/4/2009 to 31/3/2010. On loading the company next time Tally.ERP 9 will display the current financial year.

You can also shut the company and select the same company again. While selecting the company, the financial years of the company are displayed in the List of Companies

In case multiple companies are loaded and the previous company contains a different financial year, it is suggested to follow the steps shown below and disable the load companies on startup.

  • Go to Gateway of Tally > F12: Configure > Data Configuration.
  • In the Data Configuration screen and set Load Companies on Startup to Yes
  • In the Companies to preload on startup select the required company from the List of Companies displayed. 
Query-3
Can we see the age wise details of outstanding bills? How?
Yes, please follow the steps mentioned below:

Answer-3
  1. From Gateway of Tally > Display > Statement of Accounts > Outstanding > Select Receivable/ Payable / Ledger/ Group
  2. Click on Age Wise (F6) button
  3. Set by Bill date or by Due date ageing
  4. Specify the age period
  5. Save.
Query-4
How to generate a Purchase Order ?
Answer-4
From Gateway of Tally ERP 9--> Press F11:Features (F2:Inventory Feature)--> Set  the parameters "Allow Purchase Order Processing" to Yes
Gateway of Tally --> Inventory Vouchers  --> Click  "Purc. Order" option available on the button bar or press Alt + F4.
OR
Gateway of Tally --> Accounting Vouchers  --> Alt + F4.

Query-5

Can we account  for zero ('0') values during invoicing?


Answer-5
Yes, Tally.ERP 9 allows you to enter zero values while invoicing.

To enter zero values in invoices, follow these steps.
  • Gateway of Tally --> F11Features --> F1/F2 : Accouting/Inventory Features
  • Set the parameter Allow Zero valued entries  to Yes.







Interest Calculation ? from the Billing / Transaction Date


Interest Calculation ? from the Billing / Transaction Date:

Can we calculate the interest from the Billing/Transaction Date?

Yes, you can. 

Consider the transaction of Manchester Computers.

  

The Outstanding Report mentioned above displays the bill voucher date as March 1 and the due date as March 25.

Set the interest parameter as shown below:

  

The interest is calculated from the invoice date, i.e. March 1, till the report date.

To view the report:

Go to Gateway of Tally > Statements of Accounts > Interest Calculations  > Ledger > Manchester Computers

  

Friday, August 3, 2012

Q-Base-VAT : Creating Purchase Voucher without Inventory under VAT' Tally.ERP 9

Creating Purchase Voucher without Inventory under VAT '@ Tally.ERP 9


Example :
On 1-6-09, Universal Traders purchased from Sujan Ltd., Bangalore, Surya Lamps 20 nos at Rs. 300 each & Philips lamps 30 nos at Rs. 500 each. (Input VAT - 840.)


Enter the details of the transaction in voucher mode (without Inventory) Go to Gateway of Tally > Accounting Vouchers > F9: Purchase.
1. Date1-6-2009.
2. Credit Sujan Ltd.Rs. 21840 (Purchase + VAT amount).
3. In the bill-wise details give the new reference as S/01.
4. Debit Purchase @ 4%. Select End of List in the Inventory Allocation screen as you will not be entering any inventory details. A sub screen asks for VAT/Tax Class. Select Purchase @
4%Total amount of Purchases is Rs. 21000.
5. Select the Input VAT Ledger and in the sub screen that appears, select Input VAT @ 4% in VAT/Tax Class. Enter the total cost Rs. 21000, in Assessable Value and press Enter to return to the voucher.
6.Tally.ERP 9 displays the Input VAT amount as Rs. 840 (4% of Rs. 21000) by default. You can also choose to enter this amount


7. Type the narration and press or Enter to accept the screen






Creating Master Ledgers affected by VAT'@ Tally.ERP 9

Creating Master Ledgers affected by VAT'@ Tally.ERP 9
Creating Purchase Ledger
Go to Gateway oTally > Accounts Info. > Ledger > Create.

Ledger
Under
Inventory val- ues are affected
Used in VAT Returns
VAT/Tax Class
Purchase @ 4%
Purchase
Accounts
Yes
Yes
Purchases @ 4%


                    Select the VAT/Tax class as Purchases @ 4% as shown below:



 Retain the other fields as default and accept the screen.

Practice Exercise
Create the following purchase ledger

Ledger
Under
Inventoryvalues are affected
Used inVAT Returns
VAT/Tax Class
Purchase @ 12.5%
Purchase
Accounts
Yes
Yes
Purchases @ 12.5%

Creating Sales Ledger

Create the following Sales Ledgers

Ledger Name
Under
Inventory values are affected
VAT/Tax Class
Used in VAT Returns
Sales @ 4%
Sales Account
Yes
Sales @ 4%
Yes
Sales @ 12.5%
Sales Account
Yes
Sales @ 12.5%
Yes


Creating Input/Output VAT Ledger

Go to Gateway of Tally > Accounts Info. > Ledger.
‡       Create the ledger Input VAT @ 4% under Duties and Taxes.
‡       Select Input VAT @ 4% from the drop down list of VAT classification
The ledger Input VAT @ 4% appears as shown below :



The Percentage of Calculation field displays the VAT rate that you have selected in the VAT/Tax Class field and the Method of Calculation displays On VAT Rate if you have selected VAT under Type of Duty/Tax.

                    After entering the details as displayed in the above ledger creation screen, press Ctrl+A to accept the screen.

Practice Exercise
Create the following ledgers:

1. Input VAT @ 12.5%
‡        Name: Input Vat @ 12.5%
‡        Under: Duties & Taxes
‡        Type of Duty/Tax: VAT
‡        VAT/Tax Class: Input VAT @ 12.5%
‡        Percentage of Calculation: 12.5%
‡        Method of Calculation: On VAT Rate
‡        Inventory values are affected: No


2. Output VAT @ 4%
‡        Name: Output Vat @ 4%
‡        Under: Duties & Taxes
‡        Type of Duty/Tax: VAT
‡        VAT/Tax Class: Output VAT @ 4%
‡        Percentage of Calculation: 4%
‡        Method of Calculation: On VAT Rate
‡        Inventory values are affected: No


3. Output VAT @ 12.5%
‡        Name: Output Vat @ 12.5%
‡        Under: Duties & Taxes
‡        Type of Duty/Tax: VAT
‡        VAT/Tax Class: Output VAT @ 12.5%
‡        Percentage of Calculation: 12.5%
‡        Method of Calculation: On VAT Rate
                   Inventory values are affected: No
Creating Party Ledger

Create the following party ledgers:

Ledger
Under
Maintain balances bill-by-bill
Sujan Ltd.
Sundry Creditors
Yes
Chahak Traders
Sundry Debtors
Yes
Somi Telicomm
Sundry Debtors
Yes


Creating Stock Items

Create a stock item Surya Lamps as shown below :

Press or Enter to accept the screen

Practice Exercise
Create the following Stock Items under the stock group Bulbs with units of measure as Nos.:

‡        Philips Lamps with a VAT rate of 4%.
‡        GE Lamps with a VAT rate of 12.5%.
                    Bajaj Lamps with a VAT rate of 4%.