CERTIFICATE IN TALLY PRIME + GST + EXCEL ( C-104 )

INTRODUCTION TO TALLY

BOOKS OF ACCOUNTS

JOURNAL ENTRIES:-

Difference Between Tally Erp 9.0 And Tally Prime

Journal book

Cash Purchase

ACCOUNTING  TERMINOLOGIES

Cash book

Cash sales 

Capital, Assests ,Liabilities

Journal ledger book

Purchase Return

Proprietor, Partner, Drawing

Sales return

Creditors, Debtors,

CLASSIFICATION OF ACCOUNTS

Credit Purchase , Sales

Purchase , Sale, P.R, S.R

Personal account

Expense & Income

Trade And Cash Discount

Real account

Discount Entry

Diff. Bet Revenue ,Income

Nominal account

Trade discount

Cash discount

Exp. Direct And Indirect Exp.

Tax & Sales Tax

Stock , O.S , C.S

GOLDEN RULES OF ACCOUNTING

GST Entry

Net / Gross , Profit /Loss

Rule 1  Personal account

Bank Entry

Trade, Loan, Goods ,Financial Year

Rule 2 real account

Bad Debtors

Royalty, Investment, Audit Fees, Depreciation Bank   OD

Rule 3 nominal account

Fixed Assets

Bad Debts And Recovers

Loss By Fire , donation

Donation , Charity, Cost Price

Mixed Entry

Adjustment enteries

Profit & Loss

PRACTICAL PART 1

 SHORT CUT  KEY:-

PRACTICAL PART 2 :-

How to Create Company   

Select Company

F 11 Company Features

How to set company features

Shut Company

Integrate account & Inventory

How to open and shut company

Data Change

Enable Invoicing

Masters creation

Change Period

Batch Wise Details

Create ledger

Interest Calculation

Stock Group

COMPANY INFO 

Debit notes and Credit Notes

Unit  of Measure

Create Group Company

Reversing Journals

Stock Item

Alter

 Actual and Billed Quantity

Stock summary

Security Control

Mailing Details

Use of alter

Change Tally Vault

Bill- wise Details

Delete voucher

Against reference

 VOUCHER ENTRIES

Backup in tally erp 9.0

Advance

F9 purchase voucher

Restore in tally erp 9.0

On account

F8 sales voucher

Print key in tally

New reference

 Practice project

Copy key in tally

Separate Discount

F5 payment voucher

Paste key in tally

Track Additional Costs

F6  receipt voucher

All important key for tally prime

Multiple Price Levels

Practice project

Tracking Numbers

F7 journal voucher

PURCHASE ORDER MANAGEMENT

ALL VOUCHERS ENTRY :-

SALES ORDER MANAGEMENT

ALL VOUCHERS ENTRY :-

Practice project

Purchase order voucher

Sales order voucher

F4 contra voucher

Receipt note voucher

Delivery note voucher

Bank project

Rejection out voucher

Rejection in voucher

Fixed entry with gst

Purchase voucher

Sales voucher

Debit note voucher

Credit note voucher

Payment voucher

Receipt note voucher

PRACTICAL PART 3

 TDS TAX 

 TCS TAX 

BASIC THEORY OF  GST TAX 

Enable Tax deducted at Source

Set alter TDS details (Practical )

Enable Tax deducted at Source

Theory GST

Set alter TDS details (Practical )

Theory CGST

M.S EXCEL -2010

CGST,  SGST, IGST ENTRY IN TALLY

Theory SGST

Books Sheets Cell Zoom Level, Auto fill ,Add Subtract Multiply Divide Average Max Min Count

M.S EXCEL -2010

Theory IGST

Bold Italic Underline

Wrap Text

Enable GST

Set/Alter GST Details

Top Align, Middle Align, Bottom Align, Align Text Left, Center, Align Text Right

Merge &Center

Same State

(CGST AND SGST)

Bottom Border, Fill Color ,Font Color

Number Format, Accounting Number Format, Percent Style Comma Style,

Other State

IGST TAX)

Decrease Indent ,Increase Indent

Increase  Decimal, Decrease Decimal

5%, 12%, 14% , 28%

Orientation

Conditional Formatting

M.S EXCEL -2010

Left-To-Right Text Direction-(Left-To-Right),(Right-To-Left),Context

Format As Table-New Table Style

Page Layout

Set Print Area

Cells Style-New Cells Style, Merge Cell Style

Margins

Gridlines

Insert-Insert Cell, Insert Sheets Rows, Insert Sheet Columns ,Insert Sheet

Orientation

Freeze Panes

Delete Cells ,Delete Sheets Rows, Delete Sheet Columns ,Delete Sheet

Size

Columns  Width

Sort &Filter

Row Height

Find And Select