12/01/2011 - 01/01/2012


Use Excel DATE function to determine day, weekday & weekend.
This video tutorial also provides information to use Excel Color Option (Conditional Formatting) for Specific Text, Cell, Value or Number etc. Excel Color Option is very useful to identify cell from other cells based on cell value.

First view VIDEO TUTORIAL


Important two issues:-
1st- Day Column (as per video) Format Cell --> Number --> Custom --> put DDDD in the TEXT BOX
2nd- Weekday or Weekend Column (as per video)
where return number is given as an integer, rand from 1 (Sunday) to 7 (Saturday), by default)
formula mentioned under
=IF(OR(WEEKDAY(A5)=7,WEEKDAY(A5)=1),"WEEKEND","WEEKDAY")


Before Create LEDGER, Check Master Configuration (Account) & configure it (if require)
Press "F12" on the "Gateway of Tally" screen
Select "Accts/Inventory Info."


Allow Aliases along with Names :-
by default, it's value Yes. Keep it Yes. This option allows you to give Aliases Name of Group/Ledger etc
Allow Language Aliases along with Names:-
by default, it's NO. This option allows you to use 2nd name of Group/Ledger in different language. It's generally not needed for common use, if require-please YES it.
Allow Advances entries in Master:-
by default, it's YES. It allow you to enjoy different feature at the time of creation Group/Ledger. Keep it YES for better result.
Use addresses for Ledger Account:- by default, it's Yes. It allows you to put address for the Debtor, Creator or other Parties Address. Keep it YES for better result, otherwise NO it.
Use Contact Details:-
by default, it's NO. It allows you to put address for the Debtor, Creator or other Parties Address. Keep it YES for better result, otherwise NO it.
Add Notes for Ledger Accounts:- by default, it's NO. If you want to keep more information for ledger, keep it YES, otherwise NO.

To create LEDGER:-


(There are two default ledgers i.e. CASH A/c & Profit & Loss A/c. No need to create)
Launch Tally software --> Company (in case of multiple companies) --> Gateway of Tally --> Accounts Info. (Press Enter) --> Select Ledger & Press Enter --> Select Create & Press Enter --> follow under mentioned picture:

Name:- Put name of the account. Tally does not support duplicate name.

Alias Name:- Put alias name, if any. It's optional field.

Under:- It's very important factor because it indicate the Ledger character. Each account must be classified under an appropriate Group. Example, Machinery A/c under Fixed Assets, not under Direct Expense. Wages A/c under Direct Expense, not under Fixed Assets. (If Group is not ready, place pointer on UNDER tab & press ALT+C to create New Group)

Maintain balance Bill by Bill:- If you need Bill by Bill balance, then PRESS F11 KEY on GATEWAY of TALLY screen & select "ACCOUNTING FEATURES" & then put "Y" (YES) on BILL WISE DETAILS = YES
& NON TRADING ACCOUNT ALSO = YES


Inventory Values are affected:- Some accounts affect to the Inventory Values. If ledger account affect inventory value, so choose option suffices "Y" i.e. "YES". Otherwise keep it suffices "N" i.e. "NO"

Opening Balance & Dr/Cr:- Put opening balance of accounts. Mainly assets & liabilities have opening balance. After putting balance, choose suffices "D" i.e. "Dr Balance" or suffices "C" i.e. "Cr Balance". Normally Assets have "Dr" balance & Liabilities have "Cr" balance.

Accepts Yes/No :- Press suffices "Y" i.e. "Yes" or "N" i.e. No


To Display LEDGER:-

You can view any LEDGER account by selecting DISPLAY option.
Launch Tally software --> Company (in case of multiple companies) --> Gateway of Tally --> Accounts Info. (Press Enter) --> Select Ledger & Press Enter --> Select DISPLY & Press Enter

To Alter LEDGER:-

You can change/alter/modify any LEDGER account by selecting ALTER option.
Launch Tally software --> Company (in case of multiple companies) --> Gateway of Tally --> Accounts Info. (Press Enter) --> Select Ledger & Press Enter --> Select ALTER & Press Enter
Modify your LEDGER as per your requirement

To Alter LEDGER:-

You can delete any ledger by following way
Launch Tally software --> Company (in case of multiple company) --> Gateway of Tally --> Accounts Info. (Press Enter) --> Select Ledger & Press Enter --> Select ALTER & Press Enter
--> then press "ALT+D"

To Create Online LEDGER:-

Say you are in voucher page & you need to create a Ledger. Just move pointer to the ledger place & press "ALT+C". This way you create online ledger from the voucher page.

Contact Form

Name

Email *

Message *

Powered by Blogger.
Javascript DisablePlease Enable Javascript To See All Widget