(Tally Start Up Options)

▪ To create a New Company from GOT- Alt+F3 - Create a Company

▪ To Open a Company From GOT- F1 (Select Company(S))
▪ To close a Company From GOT – Alt+F1 ( Shut Company)
▪ To delete a Company From GOT- Alt+F3 – Alter – Select Company and
Press Alt+ D (Delete)
▪ To Change current Period - From GOT- Alt+F2 (Current Period)
▪ To Change current Voucher Date From GOT- F2 (Voucher Date)
▪ F11( Features)
o F1(Accounting features)
o F2 (Inventory features)
o F3 (Statutory & Taxation)
▪ F12 ( Configuration)
▪ To Create Ledgers From GOT – Accounts Info – Ledgers – Create
▪ To Create a Ledger or Stock Instantly Alt+ C (Online Creation)
▪ To Modify Ledger from the same screen Ctrl+Enter (Modification)

(Cost Category and Cost Center)

▪ To enable the options from GOT-F11-F1
Under the head of Cost Center Profit Management
Maintain Cost Center – YES
Maintain more the one Payroll Cost Category -- YES
Ctrl+ A (Save)
▪ To Create Cost Center & Cost Category
From GOT-Accounts Info.—Cost Category – Create
Cost Center -- Create
▪ To Allocate percentages for different cost center
From GOT—F11—F1
Under the head of Cost Center Profit Management
Use Pre-defined Cost allocation during entry – YES
Give the class Name (Ex: ABC)
Select the Category :
Select the all the cost center and provide all the percentages
Press 3 times Ctrl+A(Save)
 Inventory Management
➢ To Enable the options
GOT- F11(Features) – F2(Inventory features)
Under the head Storage & Classification
Maintain multiple Godown/ Location –YES
Maintain Stock Categories --- YES
Ctrl +A (Save)

➢ To create a Stock Item

GOT - Inventory Info
Stock Group
Stock Category
Stock Item
Unit of Measure
Godowns
➢ To check reports GOT – Stock Summary
To Check Godown wise Stock
GOT – Display - Statement of Inventory –
Godown - Select any Godown
 GST
1) For enabling the GST ----press F11 – F3
Enable GST –yes
Set/alter GST details --- yes
State: Telangana
Registration type: Regular
GSTIN/UIN: 36ASDFG4587K1Z5
Applicable form: 01/07/2017
Set/alter GST rate details: No
Enable GST classifications: Yes
Provide LUT/Bond details: No
--- Press Ctrl+A, 2 times for saving.
2) Create the ledgers
a. Purchase ledger
Purchase under purchase accounts
Under statutory information
Is GST applicable – Applicable
Set/alter GST details ---No
Type of supply --- Goods
b. Sales ledger
Sales under Sales accounts
Under statutory information
Is GST applicable – Applicable
Set/alter GST details ---No
Type of supply --- Goods
c. Mr. Creditor
Mr. Creditor under Sundry Creditors
Under Tax registration details
Set/alter GST details --- yes
Registration type: Regular
GSTIN/UIN: 36BCDRT7415G1Z8
Party type: Not applicable
d. Mr. Debtor
Mr. Debtor under Sundry Debtors
Under Tax registration details
Set/alter GST details --- yes
Registration type: Regular
GSTIN/UIN: 36BCDRT7415G1Z8
Party type: Not applicable
e. SGST
SGST under Duties & Taxes
Type of duty/tax: GST
Tax type: State Tax
f. CGST
CGST under Duties & Taxes
Type of duty/tax: GST
Tax type: Central Tax

g. IGST
IGST under Duties & Taxes
 Type of duty/tax: GST
Tax type: Integrated Tax
3) Create Stock items. If already stock items are available, then set the GST
rates
4) Set the GST rates
GOT --- Display --- Statutory Reports --- GST --- GST rate setup
Select the stock group/items for set the GST rates
Press Alt+S for set the GST rates
HSN/SAC details:-
Description: about product
HSN/SAC: 26568798 (8 digit product code)
Tax details:-
Taxability: Taxable
Tax type:-
Integrated tax: 18%
Cess: 0%
Ctrl+A for save.
5) Now entry purchase or sales voucher
Alt+P for print and check the invoice whether GST details displayed or not.
6) Check the reports for GST
GOT – Display – Statutory Reports – GST – GSTR-1 → for sales reports
--GSTR-2 →for purchase reports
 (Purchase/ Sales Order Process)

➢ To enable the options from GOT – F11- F2

Under the head Order processing
Purchase order processing- Yes
Sales order processing – Yes
➢ Under the head Invoicing :
Allow Invoicing – Yes
Record Purchases in Invoice format – Yes
Use debit/Credit notes – Yes
Use Invoice mode for credit notes – Yes
Use Invoice mode for credit notes – Yes
Separate discount column in invoices – Yes
➢ Under Other features:
Use tracking Numbers (delivery/receipt notes) – Yes
Use rejection inward/ outward notes - Yes
 Purchase order process
Pur/Ord/101

Purchase order

Receipt Note Pur/ch/101

Pur/101

Purchase Payment
New Number
Pur/dn/101

Debit Note
Purchase

Rejection Out
 Sales order process

Sales order Sal/Ord/101

Delivery Note Sal/ch/101

Sal/101

Sales
Receipt

New Number
Sal/cn/101

Credit Note Sales

Rejection In
 BOM(Bill of Material)

For the estimation of cost of the product

STEPS:
1) Create a Finished Product and all the raw materials in stock items
2) Making all the raw materials into the finished product i.e.
From GOT—Inventory Info---Stock items---Alter---Select finished product
Make BOM option—“YES”( F12-Last Option Bill of Materials-YES)
Give BOM Name and provide the unit of manufacture.
Provide the required quantity for all the raw materials.
3 times ctrl+A>>>”Save”
3) Purchase all the raw materials (Calculate VAT if given)
4) Creating a voucher type From GOT----Accounts Info----Voucher Types----
Create
Name: Manufacturing Journal
Type of Voucher : Stock Journal
Use as a manufacturing journal: “YES”
>>>>”Save”
5) To select Manufacturing Journal from GOT—Inventory Vouchers—Press
Alt+F7--
Select Manufacturing journal…

TDS(TAX DEDUCTED AT SOURCE)

Enabling the options : From GOT ---F11—F3
Enable TDS –YES
Set Alter TDS Details----Yes
➢ To check different TDS Nature of Payments,
From GOT—Display---Statutory Info---TDS Nature Of payments.
➢ To check the exemption limit as per Deductee Type:
From GOT---Display---Statutory Info---Deductee Type—Individual
Resident.
1) Rent
Under: Indirect Exp a/c
TDS :YES
Nature of Payment: Rent of land Building or furniture.
If nature of payment is not available means, for Create press Alt+C.
Nature of nature of payment: Rent, Building and Furniture
Section Code: 194I
Rate: 10%
Exemption Limit: 180000.
2) Landlord
Under: Sundry Creditors a/c
TDS :YES
Deductee Type : Individual/Resident
PAN:
3) TDS on Rent
Under: Duties & Taxes a/c
Type of Duty : TDS
Nature of Payment: Rent of land Building or furniture
Adjustment entry (Journal)
Dr Rent a/c.......... Dr XXXX
Cr. Landlord a/c XXXX
Cr. TDS on Rent a/c XXXX

1. Payment
Dr. Landlord a/c…….Dr XXXX
Cr.Bank/Cash a/c XXXX

2. Payment
Dr. TDS on Rent a/c…….Dr XXXX
Cr.Bank/Cash a/c XXXX

Point of Sale (Billing Terms)

Creating a voucher type, i.e.

GOT-Accounts Info - Voucher Types - Create
Name: Point of Sale
Type Voucher: Sales
Under Printing:
Print after saving voucher –Yes
Use for POS Invoicing – Yes
Print Message 1: Thank you Visit Again
Print Message 2: *****THE END*******
Default Print Title: Invoice
Set/alter Declaration: Yes
Terms & Conditions: (To Type in the Next Line Press –Ctrl+Enter)
1.
2.
3.
Ctrl+A(Save)
▪ Create Some Opening Stock Items and Save.

To generate Sales Voucher

GOT- Accounting Voucher - Press F8 – Select Point of Sale.

Party : Not applicable

 Sales Ledger: Sales(Sales Account)
Name of Item Qty Rate Amount
1.
2.
3.
Cash : Cash Cash Tendered: Amount given Balance: Default
and Save and Print

For Multiple price levels

GOT – F11- F2
Use Separate Discount Column- Yes
Use Multiple Price levels – Yes
Save

Price List
Enable The price list Features, press F11—F2.
Under Sales Management.
Use multiple price levels: Yes
Give the price level name: Diwali Offer
GOT—Inventory Info—price list – Stock group name: all items
Price level: Diwali Offer
Applicable from: 01-10-2017
After that select stock item-- give the quantity, rate and discount.
Press Ctrl+A for save.
For Sales press F8—select party name, sales ledger and Price level.
Select stocks items and enter the quantity, system will automatically take the rate
and discount.
 Budget and Control
Enable the features press F11—F1
Under Budgets and scenario management
Maintain budgets and controls—Yes
GOT – Accounts Info—Budgets – Create – budget Name: Budget 2017-18
Period of budget: from 01-04-2017 to 31-03-2017
Set/alter budgets of: select specific Ledgers and give
amount.
Now go to Balance sheet. Press Ctrl+C, from 01-04-2017 to 31-03-2017
Method stock valuation: Default
Type of value to show: budget 2017-18.
Show the variance: Yes
GOT—Display—Trail Balance – Press Alt+B. See the Budget variance.

Security Control: (Encrypting your Company Data)

From existing Company

GOT---Alt+F3---- Alter--- Security Control-YES
Administrator: ICAI
Password : ICAI
Use Tally Audit Features: Yes
Disallow in educational mode : No
Ctrl+A (Save)
Reload Company--Yes
User Name: ICAI
Password : ICAI

To Create Different User Nam & Passwords:

GOT--- Alt+F3----Security Control –Yes
Users & Passwords :
Data Entry : aman, Password: aman
Owner : ram, Password : ram
Save
Restrictions :
Select Data Entry( Enter)
Allow: Accounts masters and accounting vouchers
 PAYROLL PROCESSING

To Enable payroll options: From GOT—F11—F1 (Accounting features)

Maintain payroll—YES.
Press F3 (Statutory & Taxation)
Enable Payroll Statutory-YES,
Set Alter payroll statutory--YES
From GOT – go to Payroll Info.
Units: Create—Days, Hours, Minutes Separately, Ctrl+ A (Save/Accept)
Attendance Production Types: Create Present (Leave with pay), absent
(Without pay), Sick leave (With pay), Overtime (Production--HRS).
Employee group—Create --- Accounts (save)
Employee—Create—Give the name and all the details of an Employee.
Pay Heads---Create—
1) Basic—Under: Earnings for employee, Income type: Fixed, Indirect
Expense, Affect Net salary—YES, Name to appear in Pay slip –Basic, Use
for Gratuity—YES, Set Alter Income tax details:- YES, Component: Basic
salary, Tax calculations basis—Projected value, Calculation type: Flat rate,
Calculation period: months, Normal rounding, Limit-2 (save)
2) Dearness Allowance , Under: Earnings for employee, Income type: Fixed,
Indirect Expense, Affect Net salary—YES, Name to appear in Pay slip –DA,
Use for Gratuity—YES, Set Alter Income tax details:- YES, Component:
Dearness allowance, Tax calculations basis—Projected value, Calculation
type: as computed value, Compute: Specified formula, Select Basic, End of
the list, Slab type, Percentage, Value basis – 20%.
3) House Rent Allowance , Under: Earnings for employee, Income type: Fixed,
Indirect Expense, Affect Net salary—YES, Name to appear in Pay slip –
HRA, Use for Gratuity—NO, Set Alter Income tax details:- YES,
Component: House Rent allowance, Tax calculations basis—Projected
value, Calculation type: as computed value, Compute: Specified formula,
Select Basic, Add pay head, Select Dearness allowance, End of the list, Slab
type, Percentage, Value basis – 25%.
4) Travelling Allowance , Under: Earnings for employee, Income type:
Variable, Indirect Expense, Affect Net salary—YES, Name to appear in Pay
slip –TA, Use for Gratuity—NO, Set Alter Income tax details:- YES,
Component: Transport allowance, Tax calculations basis—Projected value,
Calculation type: as computed value, Flat Rate, Months.
5) Provident Fund , Under: Employee Statutory Deductions, Statutory Pay
Type: PF account NO., Under: Current Liabilities, Affect Net salary—YES,
Name to appear in Pay slip –PF, Calculation type: as computed value,
 Compute: Specified formula, Select Basic, Add Pay head, Select Dearness
allowance, End of the list, Slab type, Percentage, Value basis – 12%
6) Employee State Insurance, Under: Employee Statutory Deductions,
Statutory Pay type: Employee state Insurance, Under: Current Liabilities,
Affect Net salary—YES, Name to appear in Pay slip –ESI, , Calculation
type: as computed value, Compute: Current Earnings Total, Select Slab type,
Percentage, Value basis – 1.75%.
7) Professional Tax: Under: Employee Statutory Deductions, Statutory Pay
type: Professional Tax, Under: Duties & Taxes, Affect Net salary—YES,
Name to appear in Pay slip –PT, Calculation type: as computed value,
Compute: Current Earnings Total,
From Amount To amount Slab Value basis
0 15000 Value 0
15000 20000 Value 150
20000 ---- Value 200 Ctrl+A
(Save)
8) Gratuity, Gratuity—Gratuity days of a month-26
Number of months Eligibility days
1-60 0
61-120 15
121> 15
Under: Provisions, Income tax details-YES, Default-Gratuity, Normal
rounding, Limit-2 (save)

Salary Details: Define—Select EMP Name---Effective from: 01/04/2015,

Select Basic—25000, Select DA, HRA, TA- 2000, Select PF, ESI, PT, Gratuity
Ctrl+A (Save).

To generate Pay slip: From GOT – Payroll Vouchers—Press Alt+A(Payroll

Auto fill)—Process for: Salary, Date From 01/05/2015 To 31/05/2015, Select EMP
name, Payroll Ledger: Cash /Bank.

To check Pay slip: GOT—Display—Payroll Reports—Statement of

Payroll—Pay slip—Single Pay slip—Select EMP name.
 MS-ACCESS
Table Creation:-
Under Create Tab, click on table design enter field name and datatype
Example: Product id: Number
Product Name: Text
Date of Mfg: Date/Time.
Right click on table and click on save, give the table name.
For enter the data into table, right click on table and click on datasheet view and
the data.
 Queries

Update Query:-
We want update any field in table, we can use update query.
Under Create tab, click on Query Design select table which one we want update
and select specific field. After that click on Update Query and write the formula in
Update to place.
Example: update to amount column.
Update to: [quantity]*[Rate]
And click on Run, see the table amount column is updated or not.
MAKE TABLE :
➢ Creating the 3 tables (With a Common Field)
➢ Typing information in all the 3 tables
➢ Creating relationship between the tables.
➢ Making all the fields in a new table using Query Design
(Using MAKE TABLE)
Go to create tab –Query Design—Select all the tables and close
Select all the fields required except ID for multiple times.
Click on Make Table(Design Tab)
You are about to create all the fields in all tables (YES)- RUN & Save
➢ Calculating the fields in the table using UPDATE Query.
Go to create tab Query Design – Select new Table - close
Select only the fields which are required for calculations
Click on UPDATE( Design)
And apply the formula and RUN the Query As many times as
The No. of Columns. – SAVE – CLOSE.

TO GENERATE A FORM USING MULTIPLE TABLES

➢ Go to Create TAB Click on FORM Wizard

➢ Select required table and fields. Click on next, next and finish.
➢ To calculate in the Form, Select the FORM, Go for Design View
Select the fields which one we want to update write the formula. Start the formula with (=
sign)
Delete Query :
• Deleting the records as per different conditions: ( <, >, <=, >=, = )
• Ex :Deleting the records of those customer details whose
Quantity is less than 100 or 150 so on.
• Firstly close the Table in which We want to delete the record.
• Go to create--- Query Design--- Select The Table(Ex: Product Details table)
Add on the field as per the Condition i.e Qty Coulmn and Click on
Delete Query---- Criteria: <150 and click on Run.
• Save the Query as Delete Query.
• Open the table (Product Details) and check whether the details
are deleted or not.
Parameter Query :
• Search the records in the table as per different Criteria :
Like*&[Enter Your Location]&*
Between[Type the Message Criteria]And
[Type the Message Criteria]
• Ex : In Customer table we want to search the record as per
o Location wise Customers
o Customer name wise
o Department wise and so
• Firstly close the table for customer table :
• Go to Create-- Query Design---- Select Customer table---Select
all the fields from the table.
• Let say we want to see the records as per Location wise, so
In the City Field --- Criteria mention as –[Enter Your Location]--,
• Save the query as parameter Query and close.
• Now Double Click on the parameter Query, it will ask to enter the
Location.
• Let us say along with location we want to search the record for a
Particular Customer, then open the parameter Query in design View
In the Customer Name field—In the criteria mention as—
[Enter Customer Name] and save the Query and Run.
Append Query:
• Merge the records from multiple tables to one Table.
• Firstly create 3 table with following fields.
o ID ( Number)
o Customer Name (Text)
o Product Sold (Text)
o Cost (Number)
• And name the 3 tables as HEAD OFFICE, BRANCH1, BRANNCH2
• Add atleast 3 records in each table with different records.
• Save all the tables and close.
• Go TO Create--- Query Design ---- Select BRANCH1 table – ADD—Close.
• Select all the fields from the table and click on APPEND Query,
Table name: Select HEAD OFFICE. Click on Ok. And click on RUN.
• Save the Query as Append 1 and close.
• Again Go to – Create--- Query Design--- Select BRANNCH2 table—ADD—
Close.
• Select all the fields from the table and Click on Append and Select HEAD
OFFICE
Click on Ok and Click on Run.
• Save the Query as APPEND 2. And close.
• Now open the HEAD OFFICE table and check all the information of BRANCH1
and
DATA 3 Should Be Added To this Table.

[ NOTE : When we create the 3 tables Spellings and Data Type Should be
same ]
Macros :
✓ Creating a macro where it displays Message to the User.
o Go to Create --- Click on Macro—Type Message Box
▪ Title : Hello
▪ Message : Welcome to the Database Management
▪ Type : Information
▪ Save as Welcome Macro and Run.
✓ Creating a Macro where Query or Table or Form Should be Opening
In Design View.
o Go to Create--- Click Macro—Type OpenQuery or Opentable
Or Openform
▪ Query Name : Select a Query form the Dropdown
▪ View : Design
▪ Save the macro as Design Query.
✓ Creating a Macro Where it Opens Student Form and Displays only A
grade Students.
o Go to Create – Click on Macro—Type Openform
▪ Form Name: Select the Student Form from the dropdown.
▪ View: Form
▪ Where Condition: = Grade= “A”
▪ Save the macro as A Grade Students.
✓ Creating a Macro Where it displays a message to USER and it closes the
Database.
o Go to Create – Click on Macro –Type Messagebox
▪ Title : Exit!!!
▪ Message : Thank You Visit again
▪ Type : Information
▪ Click on ADD NEW ACTION
▪ Type : Close database
▪ Save the macro as Exit Macro and Run
Exporting:
➢ To export a table into Excel.
➢ Select Any Table and Go to External DATA tab and Click on Excel (EXPORT Group)
➢ Click on Browse where u have to save that data and select the first 2 options and click on ok