Categories
Tally ERP 9 Free Course Uncategorized

How to Make Multi-Columnar Reporting in Tally ERP 9

In Tally.ERP 9, you can compare information using multi-columnar reports. You can view /compare information for multiple periods (year, month, quarter or any specified period), multiplecurrencies and so on for the same company or compare information for two or more companies inthe same screen without toggling between different periods / companies. This flexibility and easein comparison of information will help you to do meaningful analysis and bring out any exceptionsimmediately.
To view a Multi-Columnar Report

  • Select any report (e.g. Balance Sheet)
  • Select (Alt + N) Auto Column
  • Select any option (company, year, month, quarter etc) and press Enter


Tally.ERP 9 now displays comparisons based on the option selected.


You can also select a date range, by pressing Alt+C (New Column) andspecifying the period and then compare data of companies

Categories
Tally ERP 9 Free Course Uncategorized

How to Handle Multi-Currency in Tally ERP 9

Many Organizations have transactions in more than one currency. Such transactions have to be
recorded either in the base (home) currency or in the foreign currency. If the transactions are
recorded in home currency, the rate at which the foreign currency is exchanged should be recorded as well.

Tally.ERP 9 allows you create and transact in multiple currencies. Tally.ERP 9 uses the term base currency for the currency in which your account books are kept. Foreign Exchange is used interchangeably with foreign currency. The base currency is specified while creating the company.

Tally.ERP 9 makes it easy to manage multiple currencies, automatic calculations of exchange
rates, automatic conversion of any currency used to record a transaction to the currency of the
account, etc. You can generate an invoice for your foreign customers in their currency and also
receive payments in the same or different currency. The impact of gain or loss in Forex is reflected immediately. You can also view and print Reports and Ledger Accounts in the currency of the transaction that has been entered or base currency.

To use Multi-currency feature,

Step 1 : Enable Multi-Currency Feature
Go to Gateway of Tally > F11: Features > F1: Accounting Features

  • 􀂇 Set Allow Multi Currency to Yes
Step 2 : Create Multi-Currency
Go to Gateway of Tally > Accounts Info. > Currencies > Create
  • 􀂇 Enter the Currency Symbol and other details
Step 3 : Define Rate of Exchange
Go to Gateway of Tally > Accounts Info > Currencies > Rate of Exchange.
  • 􀂇 Specify the Date for Rate of Exchange and other details (Standard, Selling and Buying).


You can now enter transactions in the currency of your choice.

To view report in Multi-Currencies,

  • Select any report (i.e., Balance Sheet, Profit and Loss A/c, Trial Balance or any other report)
  • 􀂇 Select Alt + C (New Column)
  • 􀂇 Select the required currency (in which you want to view the report)
  • 􀂇 Specify the Rate of Exchange for the selected currency and press Enter


Categories
Tally ERP 9 Free Course

How to Make Scenario in Tally ERP 9

Scenario Management is the management tool provided in Tally.ERP 9 with the help of which you
can create multiple scenarios for the purpose of forecasting or to view provisional reports. This
can be done by selectively including certain types of vouchers, which will in no way affect the
regular books. The vouchers that are used in scenario management are
 

 

  1. Optional Vouchers
  2. Memorandum Vouchers
  3. Reversing Journals
To configure for Scenarios,
 
Go to Gateway of Tally > F11: Features > F1: Accounting Features
 
  • 􀂇 Set Use Reversing Journals and Optional Vouchers to Yes
 
 
To create a Scenario:
 
Go to Gateway of Tally > Accounts Info. > Scenarios > Create

 

  • Specify the name of the scenario
􀂇 Set parameter Include Actuals to Yes/No (as required)

  • 􀂇 Set parameters relating to Exclude forex gains/loss and Exclude inventory tracking to
Yes/No (as required)

  • 􀂇 Specify the voucher types to be included/excluded (Use Exclude option only for those
Voucher Types that have been included previously).
To view Scenarios,

  • 􀂇 Select any report (Balance Sheet, Profit and Loss A/c, Cost Centre and so on)

  • 􀂇 Select Alt + C (New Column)

  • 􀂇 Select the scenario

  • 􀂇 Set parameter Show Variance to Yes/No
Reversing Journals and Optional vouchers are both non-accounting vouchers and hence will not

affect your books of accounts in any manner. The reversing Journal is a separate Voucher Type.
This voucher is effective only when called for in reports as a part of the scenario management. In

case of Reversing Journals, you can specify the date till which it is applicable.
To enter a Reversal Journal,
Go to Gateway of Tally > Accounting Vouchers > F10: Rev Jrnl.
Complete the transaction and specify a date till which it is applicable
To select an optional voucher,
􀂇 Go to Gateway of Tally > Accounting Vouchers >
􀂇 Press Ctrl + L: Optional to mark the chosen voucher as optional
This voucher is used when you have to enter a transaction but have incomplete information or the

transaction is not yet completed. It can be regularized at any time, by going into the alteration
mode and clicking on Regular (Ctrl+L) option.
Categories
Tally ERP 9 Free Course

How to Make Ratio Analysis in Tally ERP 9

Ratio Analysis is an indicator on the operating performance of your business and provides information
on critical ratios in a single report. You can analyze the ratios and the business performance
using this information, viz., operating cost percentage, return on working capital and so on,
to aid critical decisions making. Not only does the internal management find the information
useful, but also external agencies like banks, financial institutions etc.
 
To View Ratio Analysis Report,
 
Go to Gateway of Tally > Ratio Analysis
 
Categories
Tally ERP 9 Free Course

How to Make Cost Centers / Profit Centers with multiple Cost Categories in Tally ERP

In Tally.ERP 9 you can allocate transactions (especially those which are revenue in nature) to particular
Cost Centres, which will help you in extracting reports for that Cost Centre (Profit Centre).
Cost Centers could generally be a Unit / Division / Department / Function / Activity etc in the
organization or even Sales Executives, to which transactions (generally transactions which are
revenue in nature) are allocated.
 
You can also compare one cost centre with the other. Hence cost centers will provide the management
with information regarding their performance. With cost categories enabled, parallel allocation
of the same expense is possible between different cost centres.
 
To view Cost Centre Break-Up
 
Go to Gateway of Tally > Display > Statements of Accounts > Cost Centres > Cost Centre

 

Break-Up
 
 
 

Cost Category

In many cases, you would like to allocate a transaction to more than one cost centres. Especially,
if you want to track revenue either based on location and person or brand and type of product,
Tally.ERP 9 provides you a facility called Cost Categories. This facility enables you to allocate
costs to parallel sets of cost centres i.e., the same amount can be allocated to more than one cost

 

centre.
 
For example., Create two categories, one by the name of Administration and another by the
name Accounts under Primary Cost Category. Create Employees or persons under the
respective cost categories and enter a payment transaction for a ledger account for which cost

 

centres are applicable.
 
􀂇 Select the relevant Cost Category and Cost Centre during Voucher Entry
 
To view Cost Category summary,
 
Go to Gateway of Tally > Display > Statements of Accounts > Cost Centres > Category
Summary
 
 
Categories
Tally ERP 9 Free Course

How to Budgeting and Control in Tally ERP 9

Businesses need to control their expenses based on income levels and monitor variances.
Budgets in Tally.ERP 9 helps you compare the actual financial performance versus budgeted
figures and obtain variance reports. You can define multiple budgets (e.g. Optimistic Budget,
Realistic Budget) or even create budgets for different periods. The budget values can be defined
for each Group as well as for all Ledgers.
 
To configure for budgets,
 

 

  • Go to Gateway of Tally > F11: Features > F1: Accounting Features
  •  
  • ‡ Set parameter Maintain Budgets and Controls to Yes
  •  
  • To create budgets, 
  •  
  • Go to Gateway of Tally > Accounts Info. > Budgets > Create 
  •  
  • ‡ Specify a name for the budget 
  •  
  • ‡ Specify a date range for the budget
  •  
  • ‡ Set Yes to Groups / Ledgers and assign budget to selected groups/ledgers 

 

 
 
 
To view budget reports,
 
  • ‡ Select any report (Balance Sheet, Profit and Loss A/c, Trial Balance)
  •  
  • ‡ Select Alt + C (New Column) 
  •  
  • Specify details for period, Currency and Method of Stock Valuation. (Default or as per
    requirement)
  •  
  • ‡ Select the created budget name for Types of Value to show 
  •  
  • ‡ Set Show Variance to No 
 
 
Categories
Tally ERP 9 Free Course

How to Check Payment performance of Debtors in Tally ERP 9

Tally.ERP 9 tracks the payment performance of all debtors and generates report containing information
in respect of average time taken by the debtors to pay back their debts. The payment performance
of debtors is calculated in two ways.
 
Using Receivables formula: Tally.ERP 9 calculates the payment performance of your
debtors using the following formula,
 
  • Payment performance by formula: (closing balance / total sales) * nos of days
  •  
  • ‡Or calculates the performance of the debtors using the actual bill cleared date.
  •  
  • To view Receivables turnover
  •  
  • Go to Gateway of Tally > Ratio Analysis
  •  
  • Select Recv. Turnover in days (payment performance of Debtors)
  •  
  • Press Alt+F1 for detailed view 

 

 
Categories
Tally ERP 9 Free Course

How to Check Fund Flows Statement in Tally ERP 9

A Fund Flow statement reflects the movement in sources and application of funds which impacts
the business’s working capital and cash position. It includes operational funds, increase and
decrease in inventories, creditors/debtors. This statement reveals the sources of the Funds and
their applications. Tally ERP 9 tracks automatically all transactions entered and readily provides a
Funds Flow Statement.
 
To view Fund Flow Statement
 
Go to Gateway of Tally > Display > Cash / Funds Flow > Funds Flow
 
Select any month
 
Now Press Enter
 
 
 
Categories
Tally ERP 9 Free Course

Why is Tally the best for basic Financial Management ?

Tally.ERP 9 provides you the capability to generate various financial statements and Management
Information system reports, thereby facilitating better management, effective control and wellinformed
decisions. Following are the some of salient features, which makes Tally.ERP 9 best for
basic financial management.

 

  • Fund Flows
  • Receivables Turnover (Payment performance of debtors)
    ‡ 
  • Branch Accounting
    ‡ 
  • Flexible Period Accounting
    ‡ 
  • Budgeting and Control
    ‡ 
  • Cost centers / Profit centers with multiple Cost Categories
    ‡ 
  • Ratio Analysis
    ‡ 
  • Scenario Management
Categories
Tally ERP 9 Free Course

How to Voucher and Cheque Print in Tally ERP 9

Tally.ERP 9 provides you with a facility to print all types of vouchers. You can print a voucher on
save or you can print it later. It is also possible to print formal receipts and cheques. The real
benefit for a user is that you issue cheques to parties only after accounting the payment transactionsTo activate Cheque printing, 


Go to Gateway of Tally > F11: Features > F1: Accounting Features 


Set Enable Cheque Printing to Yes
‡ 



Enable Set/Alter Cheque Printing Configuration to Yes


Enter the Company Name on the Cheque (if cheque is not preprinted with Company
Name)
‡ 



Enter the Bank Name (as created in the Ledgers)

Enter the Cheque Dimensions

 





Tally.ERP 9 allows you the flexibility to specify the payee’s name other than the ledger account
under which the payment is accounted. Once the voucher is saved, Tally.ERP 9 prompts you to
print the cheque.











Categories
Tally ERP 9 Free Course

How to Make Bank Reconciliation in Tally ERP 9

Tally.ERP 9 provides you the facility to reconcile the transactions of your Bank Book with the Bank
Statement and instantly displays the Balance at Bank and as per the Bank Book, this facility significantly
helps in planning your payouts. The reconciliation of bank transaction using the
reconcile feature is very simple and easy to use, by simply entering the date of debit / credit of a
particular transaction in the Bank.
To view Bank Reconciliation Statement:
Go to Gateway of Tally  >  Display  >  Account Books  >  Cash/Bank Book
‡ 
Select the required Bank Account and press Enter on the required month (or F2 and
specify the required period from which you want to reconcile your bank accounts)
‡
 
Press F5: Reconcile
‡ Enter the date of clearing (date on which the transaction is being debited / credited) from
the Bank Statement.
 
 
After reconciliation, you may also toggle to other reports, by pressing the relevant buttons from
the Button Bar.
 
You may also specify the effective date of reconciliation in the Bank
Ledger Master to predefine the date of reconciliation for transaction starting
from where you want to reconcile.
 
 
 
 
 
 
 
 
Categories
Tally ERP 9 Free Course

Tally ERP 9 All Shortcut Keys*

 

Learn Here Tally ERP 9 All Shortcut Keys

 

There are many type of shortcuts in Tally, below given all shortcuts are very useful to minimize your time to work, using shortcuts keys makes your work faster and easier. so checkout, as all shortcuts are given here under:-

Tally ERP 9, Shortcuts with “ALT” Button

Alt+2 : Duplicate Voucher
Alt+A : Add voucher/To Alter the column in columnar report
Alt+C : Create a master at a voucher screen, if it has not been already assigned a different function, as in reports like Balance Sheet.
Alt+D : Delete a voucher To delete Accounting or Inventory master which is not used by any voucher or elsewhere in the alteration mode
Alt+E : Export the report in ASCII, HTML OR XML format
Alt+I : Import statutory masters
Alt+H : Help Shortcut
Alt+I : Insert a voucher/To toggle between Item and Accounting invoice
Alt+N : To view the report in automatic columns, Multiple Columns at all reports, Trial Balance, Cash/bank books, Group Summary & Journal Reg
Alt+P : Print the report
Alt+R : Remove a line in a report
Alt+Y : Register Tally
Alt+F2 : Maintain Date for Multiple Years by changing period on Gateway of Tally/Change of Period for Setting Period
Alt+S : Bring back a line you removed using Alt+R
Alt+U : Retrieve the last line which is deleted using Alt+R
Alt+W : To view the Tally Web browser.
Alt+O : To upload the report to the website
Alt+M : Email the report
Alt+F1 : Close a Company (At All Menu Screens). View detailed Report (Report Screens). Explore a line into its details (At Almost all Screens)
Alt+F3 : Select the company info menu (At Gateway of Tally Screen). Create/alter/shut a company (At Gateway of Tally Screen)
Alt+F5 : View sales and purchase register summary on a quarterly basis
Alt+F12 : View the filters screen where the range of information can be specified
Alt+X : Cancel a voucher in Day Book/List of Vouchers
Alt+R : Recalls the last narration saved for the first ledger in the voucher, irrespective of the voucher type
Alt+D : Delete any voucher in Daere the range of information can be specified
Alt+Z : Zoom

Tally ERP 9, Shortcuts with “Function” Button

F10 : Navigate between Accounting Reports
F11 : Modify Company features specific to current company only
F12 : Master Configurations, which will affect all companies in same data directory.
F2 : Change the date
F6 : Select Receipt Voucher
F7 : Select Journal Voucher
F8 : Select Sales Voucher
F9 : Select Purchase Voucher
F4 : Contra Voucher (All voucher creation and alteration screens). View list of Groups (Reports groups summary, group voucher screen, cash/ bank summary)
F5 : Select Payment Voucher. Switch between Grouped and Ledger-wise Display

Tally ERP 9, Shortcuts with “Ctrl” Button

Ctrl+R : Repeat narration in the same voucher type irrespective of Ledger Account
Ctrl+T : Mark any voucher as Post Dated Voucher Ctrl+N : Switches to Calculator/ODBC Section of Tally Screen
Ctrl+Q : Abandon a form–wherever you use this key combination, it quits that screen without making any changes to it.
Ctrl+M : Switches to Main Area of Tally Screen
Ctrl+A : Accept a form–wherever you use this key combination, that screen or report gets accepted as it is.
Ctrl+G : Select Group
Ctrl+L : Mark a voucher as Optional or Regular
Ctrl+F9 : Select Debit Note Voucher
Ctrl+Alt+V : To paste the text from Tally (At creation and alternation screens)
Ctrl+Alt+R : Rewrite data for a Company
Ctrl+Alt+B : Check the Company Statutory details
Ctrl+Alt+C : Copy the text from Tally (At creation and alternation screens)
Ctrl+Alt+c : for copy
Ctrl+Alt+v : for paste
Shift+Enter : To view the next level of details and / or condense the next level of details

Tally ERP 9, Shortcuts in use of “Inventory Vouchers”

Alt+F4 : Purchase Order Voucher
Alt+F10 : Physical Stock
Alt+F5 : Sales Order Voucher
Alt+F7 : Stock Journal / Manufacturing Journal
Alt+F8 : Delivery Note
Alt+F9 : Receipt Note
Esc : Clear entry
Ctrl+F6 : Rejection In

Categories
Tally ERP 9 Free Course Uncategorized

Tally ERP 9 Crack (Solution of Problem No.-2) Deceptive site ahead

Some times my website doesn’t open, it shows a message :- “Deceptive Site Ahead”


Why This message is showing:-
Reason:-
1. Google chrome some times disable the website due to security reason.
2. some times our antivirus also disable to open the website thats why it shows this message on the loading of page.
so, there is no need to worry, you just follow these steps to solve this problem.

Solution:-

Setp1:- Click on “Details” bottom of page.
Step2:- Click on “Visit this unsafe site”
             
              After clicking on the above said link my webiste will open properly, now you can download Tally ERP 9 Crack Zip file from Download Link.


Categories
Tally ERP 9 Free Course Uncategorized

Tally ERP 9 Crack (Solution of Problem No.-1) Required Administrator Right

This is the mostly problem faced by people at the time of activation of Crack Tally ERP 9, There Tally ERP 9 Shows this message:- 

“The process required ‘Administrator right!’ Please login as an Administrator or an user having administrative right.”

Screen Shot of as under

Solution:-

So Friends you don’t need to worry about that. i am telling what you need to do at this time:-
Setp1:- You just exit from Tally.
Setp2:- Then Right Click on Tally Icon.
Setp3:- Then Click on Run As Administrator.
Setp4:- Now go to Activate License.
Setp5:- Then First Time Activation for your organisation.
Setp6:- Now this will not show the old message, now this will ask for Serial Number, Activation Key, and email id now enter any number in all the fields, all will be accepted.
now you can follow my video on YouTube.

     Here is Video Tutorial to Crack Tally ERP 9       



Categories
Tally ERP 9 Free Course

Tally ERP 9 Crack Tutorial for Latest Version

Hi Friends,

Tally ERP 9 is Very Costly software, so some people can’t purchase this as they can not afford so much amount, but people need this software for home practice only.

So here in this article i am giving the link of my article of Tally ERP 9 Crack, also i am providing a video link below to easily learn how to crack it easily.

1.   Tally ERP 9 Crack Article Tutorial Link.

Link:-   http://www.techguruplus.com/tally-9-software-free-full-version-download/

2.   Tally ERP 9 Crack Video Tutorial Link.

Note:- I am providing this Crack just for learning purpose for students only. 

 

Categories
Tally ERP 9 Free Course

How to Rewrite Tally ERP 9 Data and Remove the All Errors*

Sometimes Tally data got corrupted or may be data don’t work properly and shows error many time. So here is the solution to remove the error of our Tally. We just need to Rewrite the Tally data, follow these instruction to rewrite the Tally ERP 9 or any other version Tally data.

How to Re-Write Tally ERP 9 Data to Resolve the Error

Step 1:- First of all Go to Tally folder and open your Tally.

rewrite tally erp data and remove error 1

Step 2:- Now do not open any company and press three button simultaneously “CTRL+ALT+R” to rewrite the tally data.

how to re write tally data

Step 3:- Select your company name to which you want to rewrite and press enter.

rewrite tally erp data and remove error 1

Step 4:- After Pressing the Enter button you will see a confirmation message “Rewrite?” Now press “Y” for Yes of click on “Yes” by mouse.

rewrite tally erp data and remove error 1

Step 5:- Now data rewriting process will be start and take little time to complete.

After complete the process you will see the “Select Company” option, now you data is ready to work.

We hope you like this article, if you need any further help you can comment us in the comment box, we will reply your comment as soon as possible.

Categories
Tally ERP 9 Free Course

Enabling SMS in Tally ERP 9 and Adding Tally.NET User Step by Step*

Learn Here Enabling SMS in Tally ERP 9

You can add a Tally.NET user and allow SMS for this user from Security Control.

To add a Tally.NET user and allow SMS

1.    Go to Gateway of Tally > F3 : Cmp Info > Security Control > Users and Passwords.

2.    Select Tally.NET User from the list of security profiles.

3.    Enter the e-mail address in the field Name of User.

4.    Enable the option Allow SMS.

Note: For existing users, enable the option Allow SMS to authorize querying for information through SMS.

The Users for Company screen appears as shown below:

enable sms in tally erp 9

5.    Press Enter to save.

———————————————————————————–

Enabling SMS Feature in Tally.ERP 9

You can enable the SMS Feature in Tally.ERP 9 from TSS Features.

To enable the SMS feature

1.    Go to Gateway of Tally > F11: Features > TSS Features.

Note: Set the option Use security control  to Yes while creating or altering a company to enable TSS Features.

2.    Enable the option Enable SMS access.

3.    Enter a short name for the company in the field Company name for SMS. The company’s short name cannot exceed ten characters.

4.    Press Enter to save.