Sunday, September 24, 2023

tally notes reports budjets and cost center part 7

 



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:-


  1. Select “Display” menu from the “Gateway of Tally”

  2. Then, Select “Day Book” menu  and Press Enter

  3. 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:-     


  1.  From GAteway of Tally, Select to the Display menu       

  2. Then Select “Account Books”

  3. 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:-


  1.  From GAteway of Tally, Select to the Display menu       

  2. Now Select and Press Enter to the  “Account Books”

  3. Now, Select and Press Enter on “Ledger”

[Now, you will see the List of Ledger, Which you have created in your company.

  1.  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:-


  1. From GAteway of Tally, Select to the Display menu       

  2. Now Select and Press Enter to the  “Account Books”

  3. Now, Select and Press Enter on “Group Summary”

[Now, you will see the List of Group]

  1. 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:-


  1. From GAteway of Tally, Select to the Display menu       

  2. Now Select and Press Enter to the  “Account Books”

  3. Now, Select and Press Enter on “Group Voucher”

[Now, you will see the List of Group]

  1. 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:-


  1. From GAteway of Tally, Select to the Display menu       

  2. Now Select and Press Enter to the  “Account Books”

  3. 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:-


  1. From GAteway of Tally, Select to the Display menu       

  2. Now Select and Press Enter to the  “Account Books”

  3. 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.       


  1. 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.


  1. 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:-


  1. 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 ''. 


  1. 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 🎉


  1. Go to the Gateway of Tally

  2. Display 

  3. Account Books

  4. Group Summary

[Now, we can see the List of Groups.]

  1. Then Select the Group and Budget Ledger From the list. 

  2.  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:



Cost Center 

Cost

Category 

Cost Center

Cost Categoy

1.Rakesh 

Sales- Man

1.Rakhi 


2.Mukesh 

2.Deepika

Sales- Girl

3.Deepak


3.Mallika 

4.Mallik 


4.Raju


5.Rahul


5.Manisha


       

  

More Examples:-


  1. 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” 


  1. 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”


  1. 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:-


  1. Motor Bike Purchase of Rs. 250000 on Credit From Yamaha ShowRoom Mr.Rajesh of Finance Department.

  2. 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 


  1. 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


  1. Salary Paid to staff of Rs.75000 as Follows:-

  

   Sales Man:-


Mr.Ajay Rs.25000

Mr.Rajkumar Rs.35000

Mr.Sanjay Rs.50000










































  


Friday, September 22, 2023

Microsoft Access Exam point of view computer Operator Notes

   MICROSOFT OFFICE  ACCESS …… ?



A database System consists of software that operates database, providing storage , access and security backup and other facilities. Microsoft Access is powerful programme to create and manage and your database. It has many built in features to assists you in contrasting and viewing your information.


  1. How to Start MS Access ?

  1. Click on Start menu 

  2. Click on Programme 

  3. Select Microsoft office 

  4. Click on it. 

Or,

  1. Click on start menu 

  2. Click on Run (Run box will appear)

  3. Type “msaccess”

  4. Click on Ok or Press Enter key 


2. How to create a database ?

  1. CLick on Blank Database 

  2. Type the Name of the DataBase 

  3. Click on Create 


 3. How to create a table by using a design view?

  1. Click on create tab 

  2. Select Table Design

  3. Type Field Name into field box and choose the despite data type  

Eg. 

Field Name Data Type 

Name Text 

Address`         Text 

Fee Currency


  1. Click on Save


4. How to Modify the Table ?

  1. Click on Home Tab

  2. Click on View (∆)

  3. Click on Design View 

  4. Now Modify the Table 


5. How to set Lookup wizard ? 


➡  Lookup

Step1:  Open the Table that contains the field that you you want to define as a Lookup field. Make sure that you’re viewing the table in the Design view. To do this, click on View in the Home Tab of the Access ribbon and select Design View . (Click and image for a larger view)


Step2:  Select Lookup Wizard from the drop down box in the Data Type column next to the field that you want to define as a lookup field. 


Step3:  When the Lookup Wizard appears, first choose if you plan to look up the values for this field in a table or query or if you plan to manually type in the values you wish to use .


Click Next to continue  


Step4:  From here, we branch off into two paths depending which method is chosen in  Step3 - TAble/Query  or Manual Entry. 


Manual Entry 

If you choose to manually enter the information, the next portion the Lookup Wizard will Provide a blank table where you can enter the information.




Choose the Number of columns that the table should contain, and then type or paste the information into the table. When done,  Click Next to continue  and skip ahead to Step 5 below.


6. Data Type in Access



Forms:- Forms are on the screen arrangement that is used to insert and view the records in the tables. Forms are attractive so we used to enter the records.



  1.  How to create form in the design view ? 

  1. Click on create tab

  2. Click on more from () sign

  3. Select on Design view 

  4. Choose the desired table

  5. Click on next three time 

  6. Click on finish 

  7. Click on save 


  1.  How to modify the forms ?

  1.  Select the form

  2. Under Home Tab

  3. Click on view 

  4. Click on Design View 

  5. Modify the desired option

  6. Click on Save 


  1. How to insert new records in the  form ? 

  1. Open the forms 

  2. Click on records

  3. Click on data entry.


  1.  How to set Background Picture on the forms ?

  1. Click on forms 

  2. Click on Home TAb

  3. Click on view drop down arrow

  4. Click on design view 

  5. Right click on the mouse button on the blank area of the forms 

  6. Click on Properties 

  7. Choose the “FORM” option From the section type drop down list box 

  8. Look where is the picture 

  9. Click on it 

  10. Choose the desire Picture 

  11. Click on insert

  12. Save it 


  1. How to save database Password ?

  1. Click on database tool 

  2. Click on Encrypt with password 

  3. Type the password

  4. Click on Ok


2. How to unset database password ?

  1. Close the access program and reopen 

  2. Click on office Button 

  3. Select Database file 

  4. Click on Exclusive 

  5. Click on database tool 

  6. Click on Decrypt with password 

  7. Type the old password 

  8. Click on Ok




Thank you 




COMPUTER OPERATOR HELPFUL NOTES HTML NOTES

  HTML   HTML stand for Hyper Text Mark up Language. It is the language used for creating webpage. To write   the HTML codes we can use ...