Online Software Educational Training - IT Tutorials - Online Education Training for Computer Software


Home

TALLY TUTORIAL

Financial Analysis Reports

In Volume 1, you learnt how to display and print a statement.  During different exercises too, you have displayed information.  You already know how to display and print!  Remember, Tally's display philosophy is - first summaries then details.

Apart from the three critical financial statements and the Stock Summary, that are directly on the Gateway of Tally, all other reports, books and statements are accessible from the Display menu.  Therefore, if you need to see something, go to Display!.  Of course, senior managers who are advanced users go everywhere from the Balance Sheet.  How?

Tally Walk-through for some display operations

Tally's information is presented in summarised form.  You then either explode it on the same screen or drill down to further details.  You also use the different display options on the button bar to analyse the information.

Explosion and Drill down

For details you can either:-

  1. Simply bring the cursor on the line and press Enter, or
  2. Select Detailed in the button bar, which will explode all lines into the next level of detail, or
  3. Bring the cursor to the desired line and press <Shift>+<Enter>.  The same pressed again will revert the line to condensed state.
  4. Try all the methods on the Balance Sheet.

Temporary removal of lines from display screens

You can remove from the display lines not required for the current view.  Hence, you can remove the group 'Current Assets' from the display of the Balance Sheet.  You can also remove ledger heads from ledger level reports, e.g., Group Summary display of Indirect Expenses.

  1. Bring the cursor on the line and press <Alt>+<R>.
  2. To show the removed line again, press <Alt>+<S>.

You will now learn how to display different financial reports.  You will actually display some of them.  Repeat them as you read them.

Display Balance Sheet

  • Return to Gateway of Tally.
  • Select Balance Sheet.  It comes up for the date of last current dated entry. Your current date is 1-3-99 and the last date of entry is also 1-3-99.  If the current date is not 1-3-99, change date to it.

Balance Sheet as on 1.3-99

  • Select Detailed.  Does it explode?

  • Select Condensed.  To return to the same display.

  • Place the cursor on Current Assets.

  • Press <Alt>+<R>.  Does it disappear?

  • Press <Alt>+<S>.

  • Use <ALT>+<C-> or select New Column in the Button Bar.

New column parameters

  1. Enter June against the To: field.  Press Enter.

  2. Select the base currency for Currency.

  3. Select Default for Stock Value.

  4. Select Actuals for Budget Value.

  5. You should get a double column Balance Sheet as the one below.  It shows you the state of affairs as on two separate dates, viz., as on 30 June 98 and on date.

Two Columnar Balance Sheet

  1. Bring the cursor to any amount in the column 30-6-98.

  2. Select Del Column in the button bar.

  3. Experiment with other options, currency and budgets.

  4. Experiment with other buttons.

  • Return to Gateway of Tally.

  • Select Balance Sheet again.

  • Bring your cursor on Profit & Loss A/c

  • Press Enter.  Where has it taken you?

  • Press Escape.  Do you return to the Balance Sheet?

  • Experiment with drill down by selecting Current Assets.

  • Go down to the Cash Book and note the steps.

  • Can you go right down to the voucher?

Profit & Loss Account

You have already seen the Profit & Loss Account from the Balance Sheet.  However you can also see it straight from the Gateway of Tally.

Select Profit & Loss Account at the Gateway of Tally.

Now experiment with all the buttons in the button bar.

Cash Flow

Cash flow is the movement of money in and out of your business.  The cash flow report displays the monthly 'inflow' , 'Outflow' and 'Nettt Flow' of cash.

To select Cash Flow:

Go to Gateway of Tally -> Display -> Cash/Funds Flow -> Cash Flow

The default cash flow shows a monthly analysis of the cash movement in the company.  Press Enter on any month and you get the Cash Flow Summary i.e., the details of Inflow, outflow and the Nett Flow of that particular month.

  1. Bring your cursor to May and press <Enter>.

  2. Select detailed.

  3. Press F2 to change the period to May 98 to July 98.

  4. Select Auto Column

  5. Select Monthly.  You have monthly Cash Flow for the Quarter!

Funds Flow

This report gives the Working Capital analysis of the company. it gives the details of the movement of funds in the company - the source of funds and their application.

(Working Capital = Current Assets - Current Liabilities.)

To select Funds Flow: 

 Go to Gateway of Tally -> Display -> Cash/Funds Flow -> Funds Flow

The default funds flow shows monthly change in the working capital i.e., the increase or decrease in the opening balance.  Press Enter on any month and you will get the Funds Flow Summary i.e., the details of source and application of funds according to groups.  This screen also gives the calculation of Opening Working Capital, Closing Working Capital and Nett Increase in Working Capital. 

Previous---- ? Next---- ?