Tata Ex next generation full course

TATA EX NGN

It is accounting software, which was developed by TATA Inc. of India. It is one of the popular software. It is easy to use
. Most of the business sectors, small shops, departmental stores etc are using this software.

 Open this software

            1.        Click on Start button
            2.       Go to Programs / All Programs
            3.        Go to EX Next Generation
            4.        Click on EX Next Generation
            5.        Type User name (admin)
            6.        Type Password (admin)
            7.        Set the logon date (1/4/2011)
            8.        Click on OK button

Log off the user

Click on Company menu
Click on Log Off

Setting a new company

A Company contains details of all financial transactions related to a single business. Whatever purpose you use EX NGN for, you must first set up your company. All tasks related to companies (except using the company) can be performed only by the System Administrator.

1.     Open TATA EX Software
2.     Click on Company
3.     Click on New Company
4.     Then type your new company name
5.     Click another box and type Short Name of your company
6.     Click another box and type Address of you company
7.     Click another box and type Phone number of your company
8.     Click another box and type Fax number of your company
9.     Click another box and type E-mail address of your company
10.   Click on Next button
11.   Click and Set Financial Year's Start Date
12.   Click and Set Financial Year's End Date
13.   Click and Set Stock Valuation Method as None.
14.   Click on Next button
15.   Click on Next button again
16.   Click on Finish button

Note: In TATA EX, we cannot make and save more than two companies.

How to Delete a company

You can delete the companies you've set up. When you delete a company, all the details and transactions you had entered for the company are delete.

1.     Open TATA EX software
2.     Click on Company menu
3.     Click on Delete Company
4.     Select the company you want to delete
5.     Click on OK button
6.     Click on Yes button

Note: If you want to delete a company then you must have to close opened company

Opening a company

Before you can perform tasks for a company, you must open the company. Lets say, you have access to two companies with the same User ID and Password, and you want to perform tasks for both these companies. After you've complete the tasks for one company, you need not log off and log on again for the other company. You'll just have to close the company you are working on and open the other company.

1.     Open TATA EX software
2.     Click on Company menu
3.     Click on Use Company
4.     Choose your company name
5.     Click on OK button
6.     Close company
7.     Click on Company menu
8.     Click on Close Company

Modifying a company

After you've set up a company, you can modify details such as telephone number or end date of the financial year. Before you modify the details of a company, you must open the company.

1.     Open TATA EX software
2.     Open your company which you want to modify
3.     Click on Company menu
4.     Click on Modify Company
5.     Change the information of the company
6.     Click on Next button respectively while changing information
7.     At last click on Finish button

Note: You cannot change the Short Name, Start Date of financial year

Setting new user instead of admin

A "User" represents a person who has access to your company and is authorized to perform a set of tasks.

1.     Open TATA EX software
2.     Click on Company menu
3.     Click on User Manager
4.     Then Click on New button
6.     In Details tab click on User Name box and type name
7.     Click on Full Name box and type your full name
8.     Click on Password box and type your new user password
9.     Click on Confirm Password box and again type your same user password
10.   Click on Company List tab
11.   Tick mark company to which you want to set user
12.   At Task List tick mark list which you want to set in new user
13.   At last click on OK button

Modifying a user

After you've set up a user, you may want to re-define a set of tasks or assign a different password. You can, at any time, modify the details of a user, expect the User ID.

1.     Open TATA EX software
2.     Click on Company menu
3.     Click on User Manager
4.     Select the user which you want to modify
5.     Click on Edit button
6.     Change the information of user in the appeared dialog box.
7.     At last click on OK button

Delete user

Open TATA EX software
Click on Company menu
Click on User Manager
Select the user which you want to delete
Click on Delete button
At last click on Yes button

Show / hide general toolbar
Open TATA EX software
Open your company
Click on View menu
Click on General

Show / hide setup toolbar

Open TATA EX software
Open your company
Click on View menu
Click on Setup

Show / hide folder toolbar

Open TATA EX software
Open your company
Click on View menu
Click on Folder

Show / hide status toolbar

Open TATA EX software
Open your company
Click on View menu
Click on Status

Customize toolbars

Open TATA EX software
Open your company
Then show the toolbars
Click on Edit menu
Click on Customize
Then select the toolbar name from the dialog box appeared
Do the following
o If you want to remove the tool then drag that tool inside customize dialog box
o If you want to keep the tool which is not in the toolbar then drag from customize dialog box to toolbar
At last click on Close button

Set general options

Open TATA EX software
Open your company
Click on Company menu
Click on Options
Click on General tab
Select the options that you need
o Levels displayed in the Chart of Accounts
o Display Open Dr / Cr while adding or modifying the document
o Prompt when Cash / Bank balance goes negative
o Prompt when Customer's credit exceed the limit
o Prompt when stock quantity goes negative
o Include accounts with zero balance in the Opening Trail Balance

Setting Group

To manage your accounts, you can create groups and sub-groups under the four main groups, and set up accounts under them.
Open TATA EX software
Open your company
Click on Setup menu
Click on Chart of Accounts
Select one of the main group
Click on New button
Check Group option
Click on OK button
Type the group name
At last click on OK button

Modify Group

You can rename a group or classify it under another group.
Open TATA EX software
Open your company
Click on Setup menu
Click on Chart of Accounts
Select the group name to modify
Click on Edit button
Change the information
At last click on OK button

Delete Group

You can delete a group that you no longer need. You can do this only if the accounts under the group have no opening balance or have not been transacted on. When you delete a group, all accounts under that group are automatically deleted.
Open TATA EX software
Open your company
Click on Setup menu
Click on Chart of Accounts
Select the group name
Click on Delete button
Then click on Yes button

Setting up an Account

Open TATA EX software
Open your company
Click on Setup menu
Click on Chart of Accounts
Select the group under which you want to set
Click on New button
Select Account option
Click on OK button
Enter the account details
At last click on OK button

Modify an Account

You can modify the details of the accounts you have set up. But, after performing year-end processing, you cannot modify the opening balance.
Open TATA EX software
Open your company
Click on Setup menu
Click on Chart of Accounts
Select account name which you want to modify
Click on Edit menu
Change the information
At last click on OK button

Delete an Account

You can delete an account if you don't need. But in some conditions we cannot delete account.
Open TATA EX software
Open your company
Click on Setup menu
Click on Chart of Accounts
Select account name which you want to delete
Click on Delete button
At last click on Yes button

Generating Account Ledger

After you have set up your accounts, you would like to view or print the ledger of a specific account.
Open TATA EX software
Open your company
Click on Setup menu
Click on Chart of Accounts
Select account name which you want to generate ledger
Click on Ledger button
At last click on Close button

Generating Account Balance Statement

After you have set up your accounts, you can generate the account balance statement for a specific account.
Open TATA EX software
Open your company
Click on Setup menu
Right click on that account name
Go to Account Balance
At last click on Cancel button

Setting charge

In EX NGN, a Charge includes tax, duty and discount. A Charge Type refers to tax types such as CST and SST and duty types such as Excise. A Charge Type can have several tax and duty categories such as VAT 13% or Discount 3%. These categories are called Charge Categories.
Open TATA EX software
Open your company
Click on Setup menu
Click on Charges
Click on New button to bring out New Charge dialog box
Click on Name box and type name of charge
Click on Type drop down button and select a type
Click on Rate box and type the rate
Click on Sales Column in Register drop down button and choose net amount
Click on Sales Account box and choose Sales A/c
Click on Purchase Column in Register drop down button and choose net amount
Click on Purchase Account box and choose Purchase A/c
At last click on OK button

Modify charge

You can, at any time, modify details of Charge Categories that you have set up. But, you cannot modify the Charge Type and Charge rate if the Charge details are entered in a document.
Open TATA EX software
Open your company
Click on Setup menu
Click on Charges
Select charge name which you want to modify
Click on Edit button
Change the information of charge
At last click on OK button

Delete charge

You can, at any time, delete the Charge Categories you have set up. But, you cannot delete a Charge Categories if it is entered in a document of if an item / narration that has been transacted upon is tagged to it.
Open TATA EX software
Open your company
Click on Setup menu
Click on Charges
Select the charge which you want to delete
Click on Delete button
Click on Yes button

Setting new item

Items are materials you buy from your suppliers or sell to your customers. You can set up as many items as you need to. You can specify the selling rate and buying rate for each item.
Open TATA EX software
Open your company
Click on Setup menu
Click on Items
Click on New button
Go to General tab and type the name of the item
Go to Purchase tab and set the rate as well as  unit
Select Purchase A/c at Account
Select the register column in which the net amount for a purchases transaction on the item is entered
Go to Sales tab and set the rate as well as unit
Select Sales A/c at Account
Select the register column in which the net amount for a purchases transaction on the item is entered
Click on required drop button of charge type category and select one
Put tick mark at S column for sales
Put tick mark at P column for purchases
Go to Custom Field tab and the value
At last click on OK button

Modify item

You can  modify details of items at any time.
Open TATA EX software
Open your company
Click on Setup menu
Click on Items
Highlight required item and click on Edit button
Change the information
At last Click on OK button

Delete Item

After you have set up an item, you may want to delete it. You can delete an item at any time. However, once you transact on an item, you cannot delete it.
Open TATA EX software
Open your company
Click on Setup menu
Click on Items
Select that item which you want to delete
Click on Delete button
Click on Yes button

Setting Narration

You can set up as many narrations as you want.
Open TATA EX software
Open your company
Click on Setup menu
Click on Narration
Click on New button
Enter details in the dialog box
Click OK button or Another button to save next narration

Modify Narration

After you have set up a narration you may want to modify details. You can, at a time, modify the details of a narration such as the narration description or charge category tagged to the narration.
Open TATA EX software
Open your company
Click on Setup menu
Click on Narration
Select the narration that you want to modify
Click on Edit button
Modify the details of the narration
At last click on OK button

Delete Narration

If you no longer need to record a narration for a transaction, you can delete it. You can, at any time, delete a narration. But, you cannot delete a narration if the narration has been entered in a document.
Open TATA EX software
Open your company
Click on Setup menu
Click on Narration
Select the narration that you want to delete
Click on Delete button
Click on Yes button

Setting Custom Field

You can define up to ten custom fields for accounts and items. When you set up a custom field, you need to assign a name to the field and select a field type – Date, Amount, Number or Text.
Open TATA EX software
Open your company
Click on Setup menu
Go to Custom Field
o If you want to create an Account Custom Field, click on Accounts
o If you want to create an Item Custom Field, click on Items
Click on New button
Enter the details in the field
At last click on OK button

Modify Custom Field

You can, at any time, modify details of custom fields. However, you cannot modify details of a custom field if you have defined a value for the field for an account or item similarly if used the field in a document layout.
Open TATA EX software
Open your company
Click on Setup menu
Go to Custom Field
o If you want to modify an Account Custom Field, click on Accounts
o If you want to modify an Item Custom Field, click on Items
Select the custom field that you want to modify
Click on Edit button
Modify details of the field
At last click on OK button

Delete Custom Field

You can delete custom field you no longer need. However, you cannot delete a custom field if you have defined a value for the field for an account or item or if used the field in a document layout.
Open TATA EX software
Open your company
Click on Setup menu
Go to Custom Field
o If you want to delete an Account Custom Field, click on Accounts
o If you want to modify an Item Custom Field, click on Item
Select the custom field that you want to delete
Click on Delete button
Click on Yes button

Setting General options

Open TATA EX software
Open your company
Click on Company menu
Click on Options
Choose the General tab
Select the option as you require
o Levels displayed in the Chart of Accounts
o Display Open Dr / Cr while adding or modifying the document
o Prompt when Cash / Bank balance goes negative
o Prompt Customer's credit exceeds the limit
o Prompt when stock quantity goes negative
o Include accounts with zero balance in the Opening Trail Balance

Types of Document in TATA EX

Receipt
Purchase
Sales
Purchase Return
Sales Return
Payment
Deposit
Withdrawals
Transfers
Journal

Receipt Document entry

This Document form is used to make the entry of cash or cheque received from others. There are four types of Receipt document according to TATA EX and they are:
Multiple Bank Receipt (MBR)
Multiple Cash Receipt (MCR)
Single Bank Receipt (SBR)
Single Cash Receipt (SCR)
In this course we will study about Single Bank Receipt and Single Cash Receipt only
Open TATA EX software
Open your company
Click on Activities menu
Click on Enter Documents
Double click on Receipts text
Select one of the document category (Single Bank Receipt / Single Cash Receipt)
Click on New button
Enter the details in the form appeared
At last click on Save button

Question

1. Commenced business with cash Rs. 5,00,000 and with City Bank deposit Rs. 15,00,000.

(REMAINING QUESTION ARE AT ANOTHER PAGE FOR NEXT TIME)

Purchase Document entry
This Document form is used to make the entry of goods purchased on cash / cheque or credit from others. There are five types of Purchase document according to TATA EX and they are:
Purchase (PUR)
Purchase Local Cash / Cheque (PLC)
Purchase Local Credit (PLR)
Purchase Outside Cash / Cheque (POC)
Purchase Outside Credit (POR)
In this course we will study about Purchase Local Cash / Cheque and Purchase Local Credit only.
Open TATA EX software
Open your company
Click on Activities menu
Click on Enter Documents
Double click on Purchase text
Select one of the document category (Purchase Local Cash / Cheque or Purchase Local Credit)
Click on New button
Enter the details in the form appear
At last click on Save button

Questions

1. Purchase from Bishwo & Company
§ 200 Transistor Radios @ Rs. 800 per pcs
§ 100 Record Players @ Rs. 200 per pcs
§ 500 Casette Players @ Rs. 1,000 per pcs
2. Purchase from Tik & Top
§ 100 Peacock Casettes @ Rs. 90 per pcs
§ 50 Blank Casettes @ Rs. 60 per pcs
3. Purchase from Nepal Music Stores
§ 200 Nepali Folk Songs Casettes @ Rs. 40 each
§ 100 Nepali Film Songs Casettes @ Rs. 45 each
§ 50 Nepali Pop Songs Casettes @ Rs. 50 each
4. Purchase on cash
§ 50 Silk Shirts @ Rs. 400
§ 50 Trousers @ Rs. 800
5. Bought of Saroj enterprises
§ 20 Over Coats @ Rs. 900
§ 30 Ladies Coats @ Rs. 1,000
6. Purchase from Suraj & paid by cheque
§ 10 Jeans Trousers @ Rs. 500 each
§ 20 Jeans Jackets @ Rs. 800 each
§ 30 Jeans Shirts @ Rs. 300 each
7. Purchase on credit from Bhuvan
§ 200 tins of Ghee @ Rs. 700
§ 200 tins of Oil @ Rs. 300
[Less 5% Trade Discount]
8. Purchase on credit from Shiva
§ 15 bags of Sugar @ Rs. 100
§ 15 bags of Wheat @ Rs. 40
9. Bought from Rajesh
§ 10 tins of Ghee @ Rs. 900
§ 20 tins of Oil @ Rs. 500
[Less 10% Trade Discount]
10. Given items are purchase from Krishna Stores
§ 600 bottles of Vatika Shampoo @ Rs. 200
§ 450 bottles of Pantene Shampoo @ Rs. 250
11. Purchase list of items from Syangja Stores
§ 175 packs of Nabico Biscuit @ Rs. 7.25
§ 150 packs of Bon Bon Buscuit @ Rs. 8.75
§ 200 packs of Tasty Buscuit @ Rs. 7.5
12. Receive goods from Adhikhola Stores
§ 225 packs of Ayo Nun @ Rs. 7.5
§ 300 packs of BMC Meat Masala @ Rs. 10
§ 250 packs of Laxmi Besar @ Rs. 3.25
§ 175 packs of Laxmi Dhulo Khursani @ Rs. 8.5
13. Listed items are purchase from Khowaish Books Stores
§ 100 pieces of Computer Science @ Rs. 250
§ 135 pieces of Finance @ Rs. 285
§ 150 pieces of Marketing @ Rs. 275
14. Purchase items from Kuwar Showroom
§ 50 pieces of Monitors @ Rs. 8,000
§ 35 pieces of Mouses @ Rs. 250
§ 70 pieces of Keyboards @ Rs. 300
§ 16 pieces of Processors @ Rs. 5,000
15. Items received from Sharada Traders
§ 270 bottles Coca Cola @ Rs. 18.5
§ 200 bottles Fanta @ Rs. 17.8
§ 170 bottles Sprite @ Rs. 18.25

Purchase Return Document entry

This Document form is used to make the entry of goods return to the Supplier. There is only one types of Purchase Return document according to TATA EX and they are:
Purchase Return (ROP)
Open TATA EX software
Open your company
Click on Activities menu
Click on Enter Documents
Double click on Purchase Return text
Select the document category (Purchase Return)
Click on New button
Enter the details in the form appear
At last click on Save button

Questions

1. Purchase Return to Bishwo & Company.
§ 20 Record Players @ Rs. 200 per pcs
2. Purchase return outward Tik & Top
§ 30 Peacock Casettes @ Rs. 90 per pcs
§ 10 Blank Casettes @ Rs. 60
3. Return to Saroj Enterprises
§ 5 Ladies Coats @ Rs. 1,000
4. Goods return to Bhuvan
§ 50 tins of ghee @ Rs. 700 per tin
5. Return outward to Rajesh
§ 8 tins of Oil @ Rs. 500 each
6. Goods return to Krishna Stores
§ 70 bottles of Vatika Shampoo @ Rs. 200 each
§ 25 bottles of Pantene Shampoo @ Rs. 200 each
7. Goods return to Khowaish Books Stores
§ 50 pieces of Computer Science @ Rs. 250
§ 70 pieces of Finance @ Rs. 285
§ 25 pieces of Marketing @ Rs. 275
8. Goods return back to Kuwar Showroom
§ 10 pieces of Mouses @ Rs. 250
§ 22 pieces of Keyboard @ Rs. 300
§ 13 pieces of Processor @ Rs. 5,000
9. Return back to Sharada Trade Stores
§ 100 bottles Coca Cola @ Rs. 18.5
§ 80 bottles of Fanta @ Rs. 17.8
§ 40 bottles of Sprite @ Rs. 18.25
10. Return back to Shiva
§ 3 bags of Sugar @ Rs. 100
§ 5 bags of Wheat @ Rs. 40

Sales Document entry

This Document form is used to make the entry of goods sales on cash / cheque or credit to others. There are four types of Sales document according to TATA EX and they are:
Sales Local Cash / Cheque (SLC)
Sales Local Credit (SLR)
Sales Outside Cash / Cheque (SOC)
Sales Outside Credit (SOR)
In this course we will study about Sales Local Cash / Cheque and Sales Local Credit only.
Open TATA EX software
Open your company
Click on Activities menu
Click on Enter Documents
Double click on Sales text
Select one of the document category (Sales Local Cash / Cheque or Sales Local Credit)
Click on New button
Enter the details in the form appear
At last click on Save button

Questions

1. Sold goods on cash
§ 32 Silk Shirts @ Rs. 500
§ 12 Over Coats @ Rs. 1,050
2. Sold goods to John Electronics
§ 20 Record Players @ Rs. 2,450
§ 10 Blank Casettes @ Rs. 75
3. Goods sold to Kanji Stores
§ 8 tins of Ghee @ Rs. 825
§ 10 tins of Oil @ Rs. 380
4. Sold goods to Third Pole Fancy
§ 2 Jeans Jackets @ Rs. 1,000 each
§ 15 Ladies Coats @ Rs. 1,225 each
§ 10 Silk Shirts @ Rs. 495 each
5. Sold to Kuran Music Stores
§ 180 Casette Players @ Rs. 1,200 each
§ 20 Peacock Casettes @ Rs. 125 each
§ 35 Nepali Folk Songs Casettes @ Rs. 75 each
6. Sold to Red Star Stores
§ 7 bags of Sugar @ Rs. 115
§ 50 bottles of Pantene Shampoo @ Rs. 285 each
7. Goods sold to Windows Computer Institute
§ 2 pieces of Monitors @ Rs. 9,525
§ 5 pieces of Keyboard @ Rs. 355
§ 3 pieces of Processor @ Rs. 6,000
8. Goods sold to Nishan Stores
§ 25 packs of BMC Meat Masala @ Rs. 15
§ 35 packs of Laxmi Dhulo Khursani @ Rs. 12
§ 75 packs of Bon Bon Biscuit @ Rs. 10
9. Sold goods to Newton Books Stores
§ 40 pieces of Finance @ Rs. 310
§ 45 pieces of Marketing @ Rs. 300
10. Sold goods to Bandana Resturant
§ 60 bottles of Coca Cola @ Rs. 20
§ 80 bottles of Sprite @ Rs. 20

Sales Return Document entry

This Document form is used to make the entry of goods sold return from customers. There is only one type of Sales Return document according to TATA EX and they are:
Sales Return (ROS)
Open TATA EX software
Open your company
Click on Activities menu
Click on Enter Documents
Double click on Sales Return text
Select the document category (Sales Return)
Click on New button
Enter the details in the form appear
At last click on Save button

Questions

1. Goods return inward from John electronics
§ 10 Record Players @ Rs. 2,750
§ 2 Blank Casettes @ Rs. 75
2. Return in from Third Pole Fancy
§ 4 Ladies Coats @ Rs. 1,225
§ 1 Silk Shirts @ Rs. 495
3. Goods return back by Kuran Music Stores
§ 30 Casette Players @ Rs. 1,200
§ 5 Nepali Folk Songs Casettes @ Rs. 75
4. Goods return by Red Star Stores
§ 2 bottles of Pantene Shampoo @ Rs. 235
5. Nishan Stores Return back
§ 8 packs of Bon Bon Biscuit @ Rs. 10
§ 3 packs of BMC Meat Masala @ Rs. 15
6. Newton Book Stores return us
§ 11 pcs of Marketing @ Rs. 300
7. Bandana Resturant return back goods to us
§ 9 bottles of Coca Cola @ Rs. 20 each
§ 7 bottles of Sprite @ Rs. 20 each

REMAINING QUESTIONS OF RECEIPT

Receipt cash from John Electronics Rs. 2,810
Receipt cash Rs. 10,000 from Kanij Stores
Receive cheque from Third Pole Fancy Rs. 19,930
Receive cheque from Kuran Music Stores Rs. 1,50,000 from bank and balance by cash
Cash receive from Red Star Stores Rs. 14,605
Receive from Windows Computer Institute Rs. 35,825
Cash receipt from Nishan Stores Rs. 1,420

Payment Document entry

This Document form is used to make the entry of cash or cheque paid to others. There are four types of Receipt document according to TATA EX and they are:
Multiple Bank Payment (MBP)
Multiple Cash Payment (MCP)
Single Bank Payment (SBP)
Single Cash Payment (SCP)
In this course we will study about Single Bank Payment and Single Cash Payment only
Open TATA EX software
Open your company
Click on Activities menu
Click on Enter Documents
Double click on Payments text
Select one of the document category (Single Bank Payment / Single Cash Payment)
Click on New button
Enter the details in the form appeared
At last click on Save button

Questions

1. Cash paid to Bishwo & Company Rs. 60,000
2. Cash paid to Tik & Top Rs. 8,700
3. Cheque paid to Nepal Music Stores Rs. 15,000
4. Rs. 20,000 paid by cash to Saroj Enterprises and balance by cheque 10,000
5. Paid to Bhuvan Rs. 50,000 by issuing cheque
6. Cash paid to Shiva Rs. 1,600
7. Cash paid to Rajesh Rs. 13,000 & received discount Rs. 100
8. Cheque paid to Krishna Stores Rs. 90,000
9. Syangja Stores Rs. 4081.25 paid

Deposit Document entry

This Document form is used to make the entry of cash deposit into bank only. There is only one type of Deposit document according to TATA EX and they are:
Cash Deposit (DEP)
Open TATA EX software
Open your company
Click on Activities menu
Click on Enter Documents
Double click on Deposits text
Select the document category (Cash Deposit)
Click on New button
Enter the details in the form appeared
At last click on Save button

Withdrawals Document entry

This Document form is used to make the entry of cash withdrawn form bank only. There is only one type of Withdrawals document according to TATA EX and they are:
Cash Withdrawal (WTD)
Open TATA EX software
Open your company
Click on Activities menu
Click on Enter Documents
Double click on Deposit text
Select the document category (Cash Deposit)
Click on New button
Enter the details in the form appeared
At last click on Save button

Transfers Document entry

This Document form is used to make the entry of cash transfer or bank transfer. There are two types of Transfer document according to TATA EX and they are:
Bank Transfer (BT)
Cash Transfer (CT)
Open TATA EX software
Open your company
Click on Activities menu
Click on Enter Documents
Double click on Transfers text
Select the document category (Bank Transfer / Cash Transfer)
Click on New button
Enter the details in the form appeared
At last click on Save button

Questions

Cash deposited into Sangrila Bank Rs. 1,00,000
Cash deposited into Nepal Bank Rs. 50,000
Cash transfer from Sangrila Bank to Nepal Bank Rs. 10,000
Withdrawn cash for office use Rs. 20,000 from Nepal Bank
Withdrawn cash for private use Rs. 8,000 from Sangrila Bank
Withdrawn cash from Nepal Bank Rs. 50,000 for domestic use
Journal Vouchers Document entry
This Document form is used to make the entry of other remaining documents. There is only one type of Journal Vouchers document according to TATA EX and they are:
Journal Vouchers (JV)
Open TATA EX software
Open your company
Click on Activities menu
Click on Enter Documents
Double click on Journal Vouchers text
Select the document category (Journal Vouchers)
Click on New button
Enter the details in the form appeared
At last click on Save button

Questions

Furniture purchased on cash Rs. 10,000
Computer purchased on cheque Rs. 30,000
Cash discount received Rs. 500
Purchase Machinery of Rs. 15,000
Electricity charged paid Rs. 300
Rs. 1,000 has been depreciated on Machinery
Rs. 1,000 of Nishan Stores written off as bad debt.

Setting Analysis Categories Option

Open TATA EX software
Open your company
Click on Company menu
Click on Options
Choose the Analysis Categories tab, and select the options
Choose the documents
Select the Detail in
o Header
o Detail
Click on OK button

Setting Analysis Categories at the Main Level

Open TATA EX software
Open your company
Click on Setup menu
Click on Analysis Categories
Click on New Category button
In the rectangular frame the appears, type the name of the analysis category
Press ENTER key from the keyboard

Setting Analysis Categories at the Sub Level

Open TATA EX software
Open your company
Click on Setup menu
Click on Analysis Categories
Select the analysis category under which you want to create the sub-type
Click in Child Category button
In the rectangular frame that appears, type the name of the analysis category
Press ENTER key from the keyboard

Specifying values at the Main Level

Open TATA EX software
Open your company
Click on Setup menu
Click on Analysis Categories
Select the analysis category for which you want to specify a value
Click New Value
In the rectangular frame that appears, type the value
Press ENTER key from the keyboard

Modify Analysis Category or Value

Open TATA EX software
Open your company
Click on Setup menu
Click on Analysis Category
Select the category type or category value that you want to modify
Click on Edit button
When the rectangular frame appears at that time modify them
Press ENTER key from the keyboard

Delete Analysis Category or Value

Open TATA EX software
Open your company
Click on Setup menu
Click on Analysis Categories
Select the analysis category or value which you want to delete
Click on Delete button
Click on Yes button

PERFORMING ACTIVITIES Viewing Item details

Open TATA EX software
Open your company
Click on Folders menu
Click on Items
Select an Item name from left side
There are many tabs at the right side. They are as below.
1. Stock Information
2. Customer Summary
3. Supplier Summary
4. Sales
5. Purchases
6. Sales Return
7. Purchases Return

View ledger of an item

Open TATA EX software
Open your company
Open Item Folders window
Point at the item name and make a right click
Click on Stock Ledger

View customer details

Open TATA EX software
Open your company
Click on Folders menu
Click on Customer
Select a customer name from the left side
There are many tabs at the right side. They are as below.
1. Summary information
2. Fact Sheet
3. Sales
4. Receipts
5. Sales Returns
6. Open Dr / Cr
7. Monthly Summary

View supplier details

Open TATA EX software
Open your company
Click on Folders menu
Click on Supplier
Select a supplier name from the left side
There are many tabs at the right side. They are as below:
1. Summary Information
2. Fact Sheet
3. Purchases
4. Payments
5. Purchases Returns
6. Open Dr / Cr
7. Monthly Summary

Filter documents

§ Open TATA EX software
§ Open your company
§ Click on Folders menu
§ Go to Smart Finder
§ Click on Documents
§ Enter the details
o Document
o Amount
o Date
o Account
o Item
o Charge
o User Defined Fields
§ Click on Find button

Filter Items

§ Open TATA EX software
§ Open your company
§ Click on Folders menu
§ Go to Smart Finder
§ Click on Items
§ Enter the details
o Item
o Customer / Supplier
o Custom Fields
§ Click on Find button

Filter customer list

§ Open TATA EX software
§ Open your company
§ Click on Folders menu
§ Go to Smart Finder
§ Click on Customers
§ Enter the details
o Sales
o Item
o Custom Fields
§ Click on Find button

Filter supplier list

§ Open TATA EX software
§ Open your company
§ Click on Folder menu
§ Go to Smart Finder
§ Click on Suppliers
§ Enter the details
Purchases
Item
Custom Fields
§ Click on Find button

Setting Report Options

Open TATA EX software
Open your company
Click on Company menu
Click on Options
Choose Reports tab
Select the options as you require
o Horizontal Grid
o Vertical Grid
o Analysis Categoies
o Custom Field
o Header
o Selection Criteria
o Days for Dues / Payables / Ageing
Click on OK button

Generating Standard Balance Sheet

The standard balance sheet is the statement of assets and liabilities of an organization for the current financial year as on a particular date.
Open TATA EX software
Open your company
Click on Reports menu
Go to Balance Sheet
Click on Standard
Click on Account tab
o Display accounts up to level: 9
o Include accounts with zero balance
Click on Date tab
o (on a specified date)
à Enter the date as on which you want the report
o (for a date range)
à Date Selection
· Week to Date
· Month to Date
· Previous Month
· Quarter to Date
· Year to Date Current
· Previous Year
· Year to Date Previous
· Custom
à From
à To
Click on OK button

Generating Standard Profit and Loss Statement

The standard profit and loss statement provides details of the income and expense accounts. It also presents the total profit or loss as on a specified date range.
Open TATA EX software
Open your company
Click on Reports menu
Go to Profit and Loss
Click on Standard
Click on Account tab
o Display Account up to level: 9
o Include accounts with zero balance
Click on Date tab
o (on specified date)
à Enter the date as on which you want the report
o (for a date range)
à Date Selection
· Week to Date
· Month to Date
· Previous Month
· Quarter to Date
· Year to Date Current
· Previous Year
· Year to Date Previous
· Custom
à From
à To
Click on OK button

Generating Standard Trial Balance

The standard trial balance is the list of account balances showing debiot and credit balances. It establishes the arithmetical accuracy of the transaction details posted to the book of accounts from the documents.
Open TATA EX software
Open your company
Click on Reports menu
Go to Trial Balance
Click on Standard
Click on Account tab
o Display accounts up to level: 9
o Include accounts with zero balance
Click on Date tab
o (on a specified date)
à Enter the date as on which you want the report
o (for a date range)
à Date Selection
· Week to Date
· Month to Date
· Previous Month
· Quarter to Date
· Year to Date Current
· Previous Year
· Year to Date Previous
· Custom
à From
à To
Click on OK button

Generating Account Balance Statement

You can generate an account balance statement to view the monthly balance of an account for the current year and the previous year.
Open TATA EX software
Open your company
Click on Reports menu
Go to Account Reports
Click on Account Balance Statement
Click on Account tab
o Select
§ Accounts by type
§ Individual Accounts
Click on OK button

Generating Group Balance Statement

You can generate a Group Balance Statement as on a particular date to examine the current balance break-up of a group.
Open TATA EX software
Open your company
Click on Reports menu
Go to Account Reports
Click on Group Balance Statement
Click on Group tab
o Generating Final Reports
à Display Accounts up to level
à Include accounts with zero balance
o Generating Other Reports
à Account by type
à Individual Accounts
Click on OK button

Generating Ledger

You can generate a Ledger to view the summarized or detailed classification of accounts.
Open TATA EX software
Open your company
Click on Reports menu
Go to Account Reports
Click on Ledger
Click on Account tab
o Select
à Accounts by type
à Individual Accounts
Click on Date tab
o (on specified date)
à Enter the date as on which you want the report.
o (for date range)
à Date Selection
· Week to Date
· Month to Date
· Previous Month
· Quarter to Date
· Year to Date Current
· Previous Year
· Year to Date Previous
· Custom
à From
à To
Click on OK button

Generating Cash / Bank Book

The Cash Book contains all transactions affecting cash accounts, and the Bank Book contains all transactions affecting bank accounts.
Open TATA EX software
Open your company
Click on Reports menu
Click on Cash / Bank Book
Click on Cash / Bank tab
o Accounts by type
o Individual Accounts
o Select accounts
Click on Date tab
o (on specified date)
à Enter the date as on which you want the report
o (for date range)
à Date Selection
· Week to Date
· Month to Date
· Previous Month
· Quarter to Date
· Year to Date Current
· Previous Year
· Year to Date Previous
· Custom
à From
à To
Click on OK button

Generating Receipts and Payments Statement

The Receipts and Payments statement provides account wise summary of all transactions for cash / bank accounts.
Open TATA EX software
Open your company
Click on Reports menu
Click on Receipts and Payments Statement
Click on Date tab
o (on specified date)
à Enter the date as on which you want the report
o (for date range)
à Date Selection
· Week to Date
· Month to Date
· Previous Month
· Quarter to Date
· Year to Date Current
· Previous Year
· Year to Date Previous
· Custom
à From
à To
Click on OK button

Generating Detailed Journal

A Journal is the book of first entry of a transaction. Daily transactions such as purchases, sales, receipts and payments are entered in the journal.
Open TATA EX software
Open your company
Click on Reports menu
Go to Journal
Click  on Detailed
Click on Date tab
o (on specified date)
à Enter the date as on which you want the report.
o (for date range)
à Date Selection
· Week to Date
· Month to Date
· Previous Month
· Quarter to Date
· Year to Date Current
· Previous Year
· Year to Date Previous
· Custom
à From
à To
Click on Document tab
o The document types
o The document series numbers
Click on Amount tab
o Between a specified range
o Equal to a specified amount
o Less than a specified amount
o Greater than a specified amount
Click on OK button

Generating Account Summary

The Accounts Summary provides an account wise summary of the credit and debit details for a particular document type.
Open TATA EX software
Open your company
Click on Reports menu
Go to Journal
Click on Accounts Summary
Click on Date tab
o (on specified date)
à Enter the date as on which you want the report.
o (for date range)
à Date Selection
· Week to Date
· Month to Date
· Previous Month
· Quarter to Date
· Year to Date Current
· Previous Year
· Year to Date Previous
· Custom
à From
à To
Click on Account tab
o Generating final reports
à Display Accounts up to level
à Include accounts with zero balance
o Generating other reports
à Accounts by type
à Individual accounts
Click on Document tab
o The document types
o The document series numbers
Click on OK button

Generating Items Summary

The Items Summary provides a summarized account of the item details for a particular document type. The document type for which you can generate an items summary are – Sales, Purchases, Sales Returns and Purchases Returns.
Open TATA EX software
Open your company
Click on Reports menu
Go to Journal
Click on Items Summary
Click on Date tab
o (on specified date)
à Enter the date as on which you want the report.
o (for date range)
à Date Selection
· Week to Date
· Month to Date
· Previous Month
· Quarter to Date
· Year to Date Current
· Previous Year
· Year to Date Previous
· Custom
à From
à To
Click on Document tab
o The document types
o The document series numbers
Click on OK button

Generating Narrations Summary

The Narration summary provides a summarized account of the credit and debit details for a particular narration. This report summarises only the standard narrations that you have set up.
Open TATA EX software
Open your company
Click on Reports menu
Go to Journal
Click on Narration Summary
Click on Date tab
o (on specified date)
à Enter the date as on which you want the report.
o (for date range)
à Date Selection
· Week to Date
· Month to Date
· Previous Month
· Quarter to Date
· Year to Date Current
· Previous Year
· Year to Date Previous
· Custom
à From
à To
Click on Document tab
o The document types
o The document series numbers
Click on OK button

Generating Transaction List

A Transaction List is a report on all the documents you have created in TATA EX NGN.
Open TATA EX software
Open your company
Click on Reports menu
Click on Transaction List
Click on Document tab
o The document types
o The document series numbers
Click on Account tab
o Generating Final Reports
à Display Accounts up to level
à Include accounts with zero balance
o Generating Other Reports
à Select the account type for which you want the report (Account by type)
à Select Account for which you want the report
Click on Item / Narration tab
o Items
o Custom Fields
Click on Charge tab
o Type
o Category
Click on Analysis Categories tab
o Categories
o Values
Click on Date tab
o Report as on a specified date
o Report for a date range
à Date Selection
· Week to date
· Month to date
· Previous Month
· Quarter to date
· Year to date current
· Previous year
· Year to date previous
· Custom
Click on Account tab
o Operator
o Amount
Click on OK button

Generating Dues receivable / payable statement

This Dues Receivable statement gives details of the money to be received from customers, and the Dues Payable Statement gives details of the money to be paid to suppliers.
Open TATA EX software
Open your company
Click on Reports menu
o If you want the Dues Receivable statement by customer, point to Customer Reports, and then to Dues Receivable, and click By Customer
o If you want the Dues Receivable statement by due date, point to Customers Reports, and then to Dues Receivable, and click By Due Date
o If you want the Dues Payable statement by supplier, point to Supplier Reports, and then to Dues Payable, and click By Supplier
o If you want the Dues Payable statement by due date, point to Supplier Reports, and then to Dues Payable, and click By Due Date
Select Customer / Supplier
o Accounts by type
o Individual Account
o Custom Field
Click on OK button

Generating Ageing Receivables / Payables Statement

The Ageing statement provides complete information on amounts that are due on each account.
Open TATA EX software
Open your company
Click on Reports menu
o If you want the Ageing Receivable statement by customer, point to Customer Reports, and then to Ageing Receivable, and click By Customer
o If you want the Ageing Receivable statement by due date, point to Customers Reports, and then to Ageing Receivable, and click By Due Date
o If you want the Ageing Payable statement by supplier, point to Supplier Reports, and then to Ageing Payable, and click By Supplier
o If you want the Ageing Payable statement by due date, point to Supplier Reports, and then to Ageing Payable, and click By Due Date
Select Customer / Supplier
o Accounts by type
o Individual Account
o Custom Field
Click on Date tab
o Report as on a specified date
o Report for a date range
§ Date Selection
· Week to date
· Month to date
· Previous Month
· Quarter to date
· Year to date current
· Previous year
· Year to date previous
· Custom
Click on OK button

Generating the Dues Receivables / Payables Summary

You can generate the summary of Dues Receivable / Payable.
Open TATA EX software
Open your company
Click on Reports menu
o If you want the Dues Receivable Summary, point to Customer Reports, and click on Summary of Dues Receivable
o If you want the Dues Payable Summary, point to Supplier Reports, and click Summary of Dues Payable.
Click on Customer tab
o Accounts by type
o Individual Account
Click on OK button

Generating Ageing Receivables / Payables Summary

You can generate the summary of Ageing Receivables / Payables.
Open TATA EX software
Open your company
Click on Reports menu



STOCK REPORTS
TAX REPORTS