Report
= It is Very important part of Tally Application. If We want to create the Report of Manual Accounting, we must need to do by us which causes, many wrong and takes a long time to create the report . But in case of Computerizing Accounting Report will be generated Automatically.
In Report; we can see BAlance Sheet, Profit and Loss Alc, Stock Summary, Ration Analysis, Trial Balance, Day Book, Account Book, Statement of Account, Statement of Inventory, Cash / Funds Flow and So many things. Therefore It is very important but easy option Provided by Tally.
Day Book with Date Range
= Day Book helps us to Display all the list of Voucher of each DAy. If you want to Display the voucher of the particular Date range then follow the below steps:-
Steps:-
Select “Display” menu from the “Gateway of Tally”
Then, Select “Day Book” menu and Press Enter
Press Alt + F2 and Enter range of Date which you want to see.
(Now, you can see the list of your related voucher)
Cash / Bank Books
= This Helps us to view the Cash (Cash in Hand) and Bank (Bank Account) of your Business of each months. If you want to view the current Status of your cash or Bank Balance the Follow following steps:-
Steps:-
From GAteway of Tally, Select to the Display menu
Then Select “Account Books”
Now, Select “Cash / BAnk Books”
[Now, you can see the current status of cash and Bank.]
Note:= If you want to display the details of these titles then Press “Alt + F1”
Specific Ledger Report:
= This menu helps us to display all the transactions about the particulars ledgers and also to display the opening balance and closing balance of the ledgers . If you really want to view these details, then follow the following steps :-
Steps:-
From GAteway of Tally, Select to the Display menu
Now Select and Press Enter to the “Account Books”
Now, Select and Press Enter on “Ledger”
[Now, you will see the List of Ledger, Which you have created in your company.
Select the Ledger, which you want to see.
Note:- Generally, Here we can’t see the Narration . If you want to Display the narration, then Press F12 on the same screen and then make “yes” on “Show Narration” Option.
Group Summary
= This menu helps us to display the summary of all Ledger Group with their total amount. Suppose, If we Select the “Current Assets” then its display the total amount of its entire ledgers. To Display the Group Summary Follow the Following Steps:-
Steps:-
From GAteway of Tally, Select to the Display menu
Now Select and Press Enter to the “Account Books”
Now, Select and Press Enter on “Group Summary”
[Now, you will see the List of Group]
Select and Press Enter to the Group, which you want to see the report.
Group Voucher
= This menu helps us to display the summary of all voucher Group on the basis of Particulars Ledger. Suppose, If we select the “Current Assets” then it display the vouchers which are related with this Group. If we want to see this features, then follow the following Steps:-
Steps:-
From GAteway of Tally, Select to the Display menu
Now Select and Press Enter to the “Account Books”
Now, Select and Press Enter on “Group Voucher”
[Now, you will see the List of Group]
Select and Press Enter to the Group, which you want to see the report.
Sales Register
= This menu is design by TAlly to view all the details of Sales which may be on Cash or on Credit. From where, we can also Display the Details of Sales of each months.
Steps:-
From GAteway of Tally, Select to the Display menu
Now Select and Press Enter to the “Account Books”
Now, Select and Press Enter on “Sales Register”
[Now, Select the month and press Enter from the window, which you want to Display.]
Purchase Register
= This menu is design by TAlly to view all the details of Purchase which may be on Cash or on Credit. From where, we can also Display the Details of Purchase of each months.
Steps:-
From GAteway of Tally, Select to the Display menu
Now Select and Press Enter to the “Account Books”
Now, Select and Press Enter on “Purchase Register”
[Now, Select the month and press Enter from the window, which you want to Display.]
Cash Flow
= Cash flow helps us to Display the Status of Cash (Source of Receipt and Payment ). It means that Cash is used to Display the Details of total Receipt and Payment of the Cash .
To Display the Details of Cash Flows, We can Follow the following steps.
Steps 🎉
Go to the Gateway of Tally
Select and Press Enter to Display
Select and Press Enter to Cash/Funds Flow
Select and Press Enter to Cash Flow
{Now, Select the month From the Window, which You want to Display}
Note: Press “Alt + F1” to Display the Report in Details.
Funds Flow
= Funds Flow helps us to Create the Report of Total Cash From where We’ve Received and Into.
To Display the Details of Funds Flows, We can Follow the following steps.
Steps 🎉
Go to the Gateway of Tally
Select and Press Enter to Display
Select and Press Enter to Cash/Funds Flow
Select and Press Enter to Funds Flow
{Now, Select the month From the Window, which You want to Display}
Note: Press “Alt + F1” to Display the Report in Details.
List of Account
= This Menu is Design by Tally to Display all Groups, Sub-Group and Ledgers upto Current Data. Without this You can also Modify/Delete the Group or Ledger From here.
If You want to Display the List of Accounts, We can Follow the following steps.
Steps 🎉
Go to the Gateway of Tally
Select and Press Enter to Display
Select and Press Enter to List of Account
{Use the Displayed Window,How much you can use.}
Trial Balance
= Trial Balance helps us to Display the Closing Balance of Account Group/Ledger. It is also Known as next level Report of Ledger.
If you want to Display the Trial Balance, then Follow the Following Steps:
Steps 🎉`
Go to the Gateway of Tally
Select and Press Enter to Display
Select and Press Enter to Trial Balance
{Now, You can see the Report of all Primary Groups.}
Note: Press the Following keys to view the Trial Balance in Different Mode.
“Alt + F1” to Display in Details.
F2:- To Display the Report of Particular Date.
Final Accounts
= To Display the Final Account Report, Press F12: Configuration. Then Select “General” and Set yes at “Use Seperate menu for Final Account.” Then You will get a Final Account menu which contains “Balance Sheet” and “Profit and Loss Account”.
Now We will Discuss about these Two most Important
Reports.
Balance Sheet ➖
Balance Sheet is the Final Financial Statement that reveals (Displays) the Status of Company as on the Date of Report. Assets Side lists What the Company own (Archives) and Liabilities Side Lists what is owes (Pays or Repays). All Real and Personal Accounts appear in the Balance Sheet.
To Display the Balance Sheet in Details, Set the Following Configuration by Clicking F12 Configuration.
photo
Sources And Application of Funds
= To get the Balance Sheet Showing sources of Funds and Application of Funds Set “yes” at “Show Vertical Balance Sheet” at Configuration Option.
Loss as Negative Profit in Balance Sheet
= To show Profit and Loss in Liabilities Side only (Loss as Negative Profit) in Balance Sheet, Set “yes” at “profit or Loss, Both as Liability” at Balance Sheet Configuration Screen.
Balance Sheet with Percentage Figures
= To Show Percentage Figures in Balance Sheet, Set “yes” at “Show Percentage” at Balance Sheet Configuration Screen.
Balance Sheet Showing Working Capital
= To get the Balance Sheet Showing Working Capital, Set “yes” at “Showing Working Capital Figures” at Balance Sheet Configuration Screen.
Profit and Loss Alc ➖
=Profit and Loss Alc Display the figures of all Nominal Accounts and the Net Profit/Loss. Sales, Closing Stock,Direct and InDirect Income Head Appear in the Income Side. Opening Stock Purchase, Direct and InDirect Expenses appear in the Expenditure Side. Excess of Income Over Expenditure is Show as Net profit, Deficit is Shown as Net loss.
To Display the “Profit and Loss Alc” follow the Following Steps:-
Steps 🎉
Go to the Gateway of Tally
Final Account
Profit and Loss Alc
Note: Press “Alt + F1” to Display the Report in Details.
Profit and Loss Configuration
= At Profit and Loss Alc, Press F12:- To get Profit and Loss Alc Configuration Screen.
Photo
Profit and Loss Alc in Vertical Format
= To Show Profit and Loss Alc in Vertical Format (Trading Account and Income Statement), Set “yes” at “Show Vertical Profit and Loss” at Configuration Screen.
Profit and Loss Alc with Percentage Figure
= To get Profit and Loss Alc with Percentage Figures,Set “yes” at “Show Percentage” on Configuration Screen.
Profit and Loss Alc with Gross
= To Show Profit and Loss Alc with Gross Profit, Set “yes” at “Show Gross Profit” on Configuration Screen.
Profit and Loss Alc as Income and Expenses Statement
= To get Income and Expenses Statement instead of Profit and Loss Alc, Press F11: Feature Button and Set “Yes” at “Income and Expenses Statement instead of Profit and Loss Alc”.
Forex Details
= It is used to Display the Ledger in there Difference Currency Symbol. It means that it helps us to Display the Report in which Currency that the transactions have done. Like Irs, Yuvan, American Dollar, Euro Dollar, Pound Sterling etc.
To Display The Ledger in Forex Details
Steps 🎉
Go to the Gateway of Tally
Display Menu
Account Book
Ledger [Now, You can see the List of Ledger.]
Select Any one Ledger and Press Enter.
Press F12: Configuration, Then Set “Yes” at “Show Forex Transactions” and Show “Forex Details”.
Then Save it by Pressing “Ctrl + A” .
Budget
= Budget is used to maintain and Control Income and Expenditure of our Company. Every Businessman has their own Goals and Objectives. Budget helps us to meet our Goals and Objectives. Actually, Budget can be used on Ledger or Group, which helps us to Control the Expenditure or Income of the Company.
In Tally, There are two types of Budget. They are as Follow:-
On Closing Balance
= In this Budget, Tally Display the Report of actuall Transaction on the Basis of Closing Balance.It means, Its effect in the “Balance Sheet ''.
On Net Transactions
= In this Budget, Tally Display the Report of actuall Transaction on the Basis of Net Transactions. It means, Its effect in the “Profit and Loss Alc''.
To make the Budget enabled, Press F11; and Set “Yes” at “Maintain Budgets and Controls” and Save it.
Steps For Creating Budgets 🎉
Go to the Gateway of Tally
Accounts Info photo
Create
[Now, you Can see Following Dialogue Boxes. ]
Enter the Budgets Name and Type of Budget,
Amount, and Save It .
Displaying the Budgets Report
Steps 🎉
Go to the Gateway of Tally
Display
Account Books
Group Summary
[Now, we can see the List of Groups.]
Then Select the Group and Budget Ledger From the list.
Now, Press Alt + B (Budget Variance) to Display the List of Budget and Select the Budget From the List to Display Report of The Budget.
Photo
Photo
Cost Center and Cost Category
= Cost Center is used to analyze Ledger Figures, Means Sub-Ledger. Actually the Cost Center is used to Create the Report of Income and Expenditure of each Title (Ledger). Suppose, you’ve 5 Sales Man in your Company. And you want to keep the Record of each SalesMan about their sales Report of each Day. Cost Category is the Collection of the Cost Center. It means, it is a Group of Cost Center. In our Company, There are many types of Cost Center. And this Cost Category helps us to keep them at a Department, Which is called Cost Categories.
Examples:
More Examples:-
Computer Purchased of Rs.55000/- Micro Office Automation for the Account Department to Computer Operator Mr.Shrestha.
Here, Mr.Shrestha is Cost “Centre” and
Account Department is”Cost Categories”
Salary Paid to Staff Rs.15000/- For the Finance Department to Mt.Mallik.
Here, Finance Department is ”Cost Categories” and Mr.Mallik is Cost “Centre”
Goods Sold by Rajesh Salesman Rs.2000/-
Here, Salesman is ”Cost Categories” and
Rajesh is Cost “Centre”
To Enable Cost Center and Cost Category
Steps 🎉
1.Press or Click on F11: Features.
2.Set “Yes” at “Maintain Cost Centre” For Cost Centre and Set “Yes” at “More than ONE Cost Category” For Cost Category.
[Now, It is Activated in Your Account Info. Menu]
To Create Cost Category:
Steps 🎉
1.Account Info ⇛ Cost Categories ⇛ Create
2.Set the Following Things in the Following Title.
Photo
Name: (Type Category Name. Like, Salesman)
Allocate Revenue Item: (Set YES, If this Category is Related with Purchase, Sales, Receipt and Payment which affects the Profit and Loss Alc. Like Salesman. Because it also affects the Profit and Loss Alc.)
Allocate Non Revenue Item: (Set YES, If it is Related to Assets and Liabilities which can affect the Balance Sheet.)
To Create Cost Centre
Steps 🎉
1.Account Info ⇛ Cost Centre ⇛ Create
2.Set the Following Things in the Following Title.
Category:- (Select the Category Name From here)
Name:- (Give the Centre Name. Like, Rohan)
Under:- (Select the Group From Here.)
Examples:-
Motor Bike Purchase of Rs. 250000 on Credit From Yamaha ShowRoom Mr.Rajesh of Finance Department.
Goods Purchase of Rs. 150000 on Credit from Rahul Traders by Procurement Department As Follows:-
Mr. Pradip Rs.25000
Mr. Rahul Rs.35000
Mr. Rakesh Rs.50000
Mr. Roshan Rs.40000
Goods Sold of Rs.36000 by Salesman in Different Location as Follows:-
Salesman Location
Mr.Ajay Rs.19000 Biratnagar Rs.20000
Mr.Rajkumar Rs.11000 Dharan Rs.16000
Mr.Sanjay Rs.6000
Salary Paid to staff of Rs.75000 as Follows:-
Sales Man:-
Mr.Ajay Rs.25000
Mr.Rajkumar Rs.35000
Mr.Sanjay Rs.50000