01/01/2012 - 02/01/2012



Bill by bill feature is generally applied on the party ledger, transactions (transaction generally related to cash or credit purchase & sale). Party ledger means Debtors Ledger & Creditors Ledger. Customer or Debtors are who purchase goods or services in credit. Suppliers or creditors are who supply goods & services in credit.

To activate Bill by Bill feature
Gateway of Tally -- press F11 -- Accounting Features
Maintain Bill wise Details =Yes
for Non-Trading A/cs also = Yes

Effect of Bill by Bill feature on Ledger Creation/Alter
Gateway of Tally -- Accounts Info -- Ledger -- Create (in alter already create ledger, select Alter)
Create ledger account (view previous post to learn ledger creation)
Yes the option "MAINTAIN BILL BY BILL"


When you insert any opening balance of debtors/creditors/parties ledger, tally opens Bill by Bill details screen
Here you may put bill by bill data.
Date: - Tally takes closing date of previous year by default because it's opening balance of this year which comes from previous years ending balance. User may change date as per requirement.
Due Dates or Credit Days: - Tally takes closing date of previous year by default. You can change as per requirement. Due dates means, credit allow period.
Name:- Bill name or no.
Adjustment of Non-Billed Amount: - If any non-billed amount are there, these is adjusted this "On Account" balance

Effect of Bill by Bill feature on Voucher Entry/Transaction
Please visit articles on voucher entry/transaction for more details
http://www.pijushroy.com/2011/08/tally-9erp-menu.html

Cost Allocation feature of Tally helps to allocate cost as per Cost Center & Cost Category.

Define & use of COST CATEGORIES:-
User can create different COST CATEGORIES for allocation of costs. Under each cost categories, user can create multiple COST CENTER.
Example:- If you want to allocate costs based on BRANCHES & DEPARTMENT wise, you should create BRANCH & DEPARTMENT COST CATEGORIES.

So Cost Category :- BRANCH, DEPARTMENT


Define & use of COST CENTRE:-
User can create different COST CENTRES for allocation of costs under the COST CATEGORIES.

You can create 2 types of COST CENTRES i.e. PRIMARY COST CENTRE & COST CENTRE under PRIMARY COST CENTRE.

Example:-
If you want to allocate costs based on BRANCHES & DEPARTMENT wise, you should create BRANCH & DEPARTMENT COST CATEGORIES.
You have four(4) branches i.e. A, B, C, D
& four(4) department i.e. ACCOUNT, SALE, EXPORT, ADVERTISEMENT
ADVERTISEMENT department has four(4) zone i.e. NORTH, SOUTH, EAST & WEST

So Cost Category :- BRANCH, DEPARTMENT
Cost Centre (primary):-
A, B, C, D under BRANCH CATEGORY & ACCOUNT, SALE, EXPORT, ADVERTISEMENT under ADVERTISEMENT CATEGORY
Cost Centre (under primary cost centre, here under ADVERTISEMENT COST CENTRE):- NORTH, SOUTH, EAST & WEST


COST CATEGORIES
First Activate Cost Categories & Cost Centres Features in Tally9.ERP
Open Tally Software -- press F11 on Gateway of Tally -- put YES on two under mentioned option
Maintain Cost Centres = YES
More than One Payroll/Cost Category = YES


Create Cost Categories (Branch & Department) in Tally
Tally -- Gateway of Tally -- Accounts Info -- Cost Categories -- Create
Same way to create DEPARTMENT CATEGORY

Display Cost Categories (Branch & Department) in Tally
Tally -- Gateway of Tally -- Accounts Info -- Cost Categories -- Display
1 Pre Defined Item listed i.e. Primary Cost Category

Alter Cost Categories (Branch & Department) in Tally
Tally -- Gateway of Tally -- Accounts Info -- Cost Categories -- Alter

Delete Cost Categories (Branch & Department) in Tally
Tally -- Gateway of Tally -- Accounts Info -- Cost Categories -- Alter -- Press Alt+D & Accept to Delete

Create, Display, Alter Multiple Cost Categories (Branch & Department) in Tally
same way mentioned above, only choose Multiple Cost Categories Option
view screen shot



COST CENTRES
Create Cost Centre (A, B, C, D under Branch & ACCOUNT, SALE, EXPORT, ADVERTISEMENT under Department) in Tally
Tally -- Gateway of Tally -- Accounts Info -- Cost Centres -- Create
choose category=Branch from right side bar
& category=Department from right side bar
Keep under=Primary
this way create all A, B, C, D under Branch & ACCOUNT, SALE, EXPORT, ADVERTISEMENT under Department


Now create Sub-Cost Centre (North, East, West, South under Advertisement Cost Centre) in Tally
Tally -- Gateway of Tally -- Accounts Info -- Cost Centres -- Create
choose category=Department from right side bar
keep under=ADVERTISEMENT
this way create North, East, West, South under Advertisement Cost Centre


Display Cost Centres
Tally -- Gateway of Tally -- Accounts Info -- Cost Centres -- Display
1 Pre Defined Item listed i.e. Primary Cost Category

Alter Cost Centres
Tally -- Gateway of Tally -- Accounts Info -- Cost Centres -- Alter

Delete Cost Centres
Tally -- Gateway of Tally -- Accounts Info -- Cost Centres -- Alter -- Press Alt+D & Accept to Delete


VIEW REPORT (cost categories & cost centres wise)
Gateway of Tally -- Display -- Statements of Accounts -- Cost Centres --
Category Summary (after passing vourcher / entry)
or
Cost Centres Break Up (after passing vourcher / entry)


Effect of Cost Centres in Ledger creation or alter Ledger to effect Cost Centres


Effect of Cost Centres in Voucher Entry
please visit voucher entry post/article for details

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.


What is Tally Group?
Tally Group are mainly used to classification of Ledger Account. The main function of the Tally Group is to classified Tally Ledger / Ledger Character / define Tally Ledger. There are 28 predefined GROUP available or ready to use in Tally9 or Tally9.ERP version, out of 28 predefined group 15 are Primary Group & 13 are Sub-Gruop. You can't delete Primary Group, can modify/renamed Primary Group but it's not suggested. Your can create more Primary or SubGroup according to requirement.

15 Primary Group

(PreDefined)

13 Sub Group (Predefined)

Sub Group Name

Under Primary Group

Branch / Division

Bank Account

Current Assets

Capital Account

Bank OD A/c or Bank OCC A/c

Loans Liability

Current Assets

Cash in hand

Current Assets

Current Liabilities

Deposite (Assets)

Current Assets

Direct Expenses

Duties & Taxes

Current Liabilities

Direct Income

Loans & Advances (Assets)

Current Assets

Fixed Assets

Provisions

Current Liabilities

Indirect Expenses

Reserve & Surplus

Capital Account

Indirect Income

Secured Loans

Loan (Liability)

Investment

Stock in Hand

Current Assets

Loan (Liability)

Sundry Creditor

Current Liabilities

Misc Expenses (Assets)

Sundry Debtor

Current Assets

Purchase Account

Un Secured Loan

Loans (Liability)

Sales Account



Suspense Account





To View Group or predefined Group in Tally
Gateway of Tally -- Account Info -- Groups -- Display

Predefined Group are
Press B
Bank Account
Bank OCC A/c
Bank OD A/c (overdraft)
Branch / Division
Press C
Capital A/c
Cash in Hand
Current Assets
Current Liabilities
Press D
Deposit (Asset)
Direct Expenses
Direct Income
Duties & Tax
Press E
Expenses (Direct)
Expenses (In Direct)
Press F
Fixed Asstes
Press I
Income (Direct)
Income (In Direct)
Investment
Press L
Loan & Advances (Asstes)
Load (Liabilities)
Press M
Misc Exp (assets)
Press P
Provision
Purchase A/c
Press R
Reserve & Surplus
Retained Earning
Press S
Sales A/c
Secured Loan
Stock in Hand
Sundry Creditor
Sundry Debtor
Suspense A/c
Press U
Un Secured Loan

To Create Group in Tally
Gateway of Tally -- Account Info. -- Groups -- Create

you can create two types of Group. First one is PRIMARY GROUP (which hold other secondary or sub-group) & second is SUB-GROUP.

To Create Primary Group in Tally
Gateway of Tally -- Account Info. -- Groups -- Create
keep under PRIMARY


To Create Sub Group in Tally
Gateway of Tally -- Account Info. -- Groups -- Create
keep under PRIMARY GROUP NAME


To Alter Group in Tally
Gateway of Tally -- Account Info -- Groups -- Alter -- Select Group (modification/delete of Primary Group not suggested) -- Enter -- then Alter Group

To Delete Group in Tally
Gateway of Tally -- Account Info -- Groups -- Alter -- Select Group (alteration of Primary group not suggested) -- Enter -- Press Alt+D -- Yes / Y to accept delete group


Create and remove Drop Down Menu List in Excel 2003, 2007, 2010 by using Date Validation option under the Date Menu.

Create Drop Down List or Data Validation
First create a option list in the plain Excel Sheet

Select C2 cell, Select DATA menu & select VALIDATION option

Select SETTINGS, select LIST under ALLOW

click on SOURCE Tab & select OPTION RANGE previously created i.e. here cell A1 to A5,


Click on OK






Remove Drop Down List or Data Validation

select C2 cell, click on DATE Menu, click on VALIDATION OPTION
Validation Box open, then click on CLEAR ALL
Drop Down List or Data Validation is removed


MS Excel 2010, 2007, 2003 provides SYD Financial Function to calculate DEPRECIATION under Diminishing Balance Method or Written Down Value Method.

Function :- SYD (cost, salvage, life, per)
Cost :- asset or investment initial cost
Salvage :- value of asset or investment after useful life
Life :- Expected useful life of asset
Per :- for first year 1, second year 2 as so

Path
2007 :- Formula -- Financial -- SYD
2003:- Insert Menu -- Function -- Financial -- SYD -- ok

Question:-
Cost of purchase asset = $5,00,000.00 (in D4 cell)
Useful life = 15 Years (in D5 cell)
Salvage Value after 15 years= $1000.00 (in D6 cell)
Per = for 1st year = 1, 2nd year = 2...........

1 col - Year
put 1 in A8 cell & 2 in A9 cell. Then Drag it for 15 years i.e. A23 cell

2 col - Amotized Cost: Formula
B9 cell =D4
B10 cell =D9 and Drag formula of B10 cell for 15 years i.e. B23 cell

4 col - Slavage
D9 cell =B9-C9 and Drag it for 15 years i.e. D23 cell

3 col - Depreciation
C9 cell (dep 1st years)
Formula Menu (Excel 2007) -- Financial -- select SYD --

View Picture

Cost :- asset or investment initial cost
= select cost cell & press F4 for $$ sign
Salvage :- value of asset or investment after useful life
= select salvage cell & press F4 for $$ sign
Life :- Expected useful life of asset
= select life cell & press F4 for $$ sign
Per :- put 1 because 1st year Depreciation is calculated
Then press Ok
Resulted formula =SYD($D$4,$D$6,$D$5,1)

Drag C9 cell formula to C29 cell & change per value i.e. 1st year 1, 2nd year 2
i.e.
1st year formula =SYD($D$4,$D$6,$D$5,1)
2nd year formula =SYD($D$4,$D$6,$D$5,1)



MS Excel 2010, 2007, 2003 provides SLN Financial Function to calculate DEPRECIATION under Straight Line Method

Function :- SYD (cost, salvage, life, per)
Cost :- asset or investment initial cost
Salvage :- value of asset or investment after useful life
Life :- Expected useful life of asset

Path
2007 :- Formula -- Financial -- SLN
2003:- Insert Menu -- Function -- Financial -- SLN -- ok

Question:-
Cost of purchase asset = $5,00,000.00
Useful life = 15 Years
Salvage Value after 15 years= $1000.00




Follow the Upper Written Down Value Method. Everything are same, only select SLN option instead of SYD option and no PER value .

So formula format is =SLN($D$29,$D$31,$D$30) instead of =SYD($D$4,$D$6,$D$5,1)


MS Excel Financial Function is very helpful to calculate No of Installment (NPER), Present Value (PV) of any future cash flows, Future Value (FV), Amount per Installment given or receive (PMT), Net Present Value (NPV) of any project, Rate of Interest etc.
These types of financial measurement is very important for managerial decision making process, finance decision making process, accounts department and more.

First Installment Amount (PMT) is calculating. Example is mentioned under:-

Say, Mr X, retired employee, gets pension $10,000. Present value $1,036,246.19 Get pension for 20 years. Rate of Interest:- 10% pa. Calculate PMT

Answer:-
VIEW PICTURE AND SOLUTION (click on picture to view full size)
or VIEW UNDER MENTIONED VIDEO TUTORIAL


Pension Amount = ?
Rate of Interest = 10% Per Year
No of Installment = 240 20 years & 12 months each
Present Value = $1,036,246.19

PMT(Monthly Pay) = ($10,000.00) (calculated)

In 2003 Excel:- Insert Menu -- Function -- Select Financial -- Select PMT -- Ok -- PV:- ($1,036,246.19), NPER:- 240, Rate:- 10%/12, FV:- $15,187,376.74

In 2007 Excel:- Formula Menu --> Financial --> PMT -->
PV:- ($1,036,246.19), NPER:- 240, Rate:- 10%/12, FV:- $15,187,376.74
NEGATIVE PMT VALUE CALCULATE



MS Excel Financial Function is very helpful to calculate No of Installment (NPER), Present Value (PV) of any future cash flows, Future Value (FV), Amount per Installment given or receive (PMT), Net Present Value (NPV) of any project, Rate of Interest etc.
These types of financial measurement is very important for managerial decision making process, finance decision making process, accounts department and more.

First Future Value (FV) is calculating. Example is mentioned under:-

Say, Mr X, retired employee, gets pension $10,000. Present value $1,036,246.19
Get pension for 20 years. Rate of Interest:- 10% pa. Calculate Future Value

Answer:-
VIEW PICTURE AND SOLUTION (click on picture to view full size)
or VIEW UNDER MENTIONED VIDEO TUTORIAL


Pension Amount = ($10,000.00) Per Month (put negative value)
Rate of Interest = 10% Per Year
No of Installment = 240 20 years & 12 months each
Present Value = ($1,036,246.19)

Future Value(FV) = $15,187,376.74 (calculated)

In 2003 Excel:- Insert Menu --> Function --> Select Financial --> Select FV --> Ok -->
PMT:- ($10000.00), PV:- ($1,036,246.19), NPER:- 240, Rate:- 10%/12

In 2007 Excel:- Formula Menu --> Financial --> FV -->
PMT:- ($10000.00), PV:- ($1,036,246.19), NPER:- 240, Rate:- 10%/12
Always Put Negative PMT and PV



MS Excel Financial Function is very helpful to calculate No of Installment (NPER), Present Value (PV) of any future cash flows, Future Value (FV), Amount per Installment given or receive (PMT), Net Present Value (NPV) of any project, Rate of Interest etc.
These types of financial measurement is very important for managerial decision making process, finance decision making process, accounts department and more.

First Rate of Interest is calculating. Example is mentioned under:-

Say, Mr X, retired employee, gets pension $10,000. Present value $1,036,246.19. Get pension for 20 years. Calculate Rate of Interest


Answer:-
VIEW PICTURE AND SOLUTION (click on picture to view full size)
or VIEW UNDER MENTIONED VIDEO TUTORIAL


Pension Amount = ($10,000.00) Per Month (put negative value)
Rate of Interest = ? Per Year
No of Installment = 240 20 years & 12 months each
Present Value = $1,036,246.19

Rate of Interest = 10.00% (calculated)

In 2003 Excel:- Insert Menu -- Function -- Select Financial -- Select RATE -- Ok --
PMT:- ($10000.00), PV:- $1,036,246.19, NPER:- 240

In 2007 Excel:- Formula Menu -- Financial -- RATE --
PMT:- ($10000.00), PV:- $1,036,246.19, NPER:- 240
Always Put Negative PMT i.e. Loan or Pension Amount etc


MS Excel Financial Function is very helpful to calculate No of Installment (NPER), Present Value (PV) of any future cash flows, Future Value (FV), Amount per Installment given or receive (PMT), Net Present Value (NPV) of any project, Rate of Interest etc.
These types of financial measurement is very important for managerial decision making process, finance decision making process, accounts department and more.

Now No of Installment (NPER) is calculating. Example is mentioned under:-

Mr X, retired employee, gets pension $10,000. Present value $1,036,246.19 Rate of interest 10% p.a., CALCULATE No of Installment

Answer:-
VIEW PICTURE AND SOLUTION (click on picture to view full size)
or VIEW UNDER MENTIONED VIDEO TUTORIAL



Pension Amount = ($10,000.00) Per Month (put negative value)
Rate of Interest = 10% Per Year
No of Installment = ?
Present Value = $1,036,246.19

No of Installment = 240 (calculated)

In 2003 Excel:- Insert Menu -- Function -- Select Financial -- Select NPER -- Ok --
Rate:- 10%/12, PMT:- ($10000.00), PV:- $1,036,246.19

In 2007 Excel:- Formula Menu -- Financial -- NPER --
Rate:- 10%/12, PMT:- ($10000.00), PV:- $1,036,246.19
Always Put Negative PMT i.e. Loan or Pension Amount etc



MS Excel Financial Function is very helpful to calculate No of Installment (NPER), Present Value (PV) of any future cash flows, Future Value (FV), Amount per Installment given or receive (PMT), Net Present Value (NPV) of any project, Rate of Interest etc.
These types of financial measurement is very important for managerial decision making process, finance decision making process, accounts department and more.

First Present Value (PV) is calculating. Example is mentioned under:-

Say, Mr X, retired employee, gets pension $10,000 at the end of each month for 20 years. Rate of interest 10% p.a., CALCULATE PV (Present Value)

Answer:-
VIEW PICTURE AND SOLUTION (click on picture to view full size)
or VIEW UNDER MENTIONED VIDEO TUTORIAL


Pension Amount =($10,000.00) Per Month (put negative value)
Rate of Interest =% Per Year
No of Installment = i.e. 20 years & 12 months each year
Present Value = ?

Present Value(PV) = $7,593,688.36 (calculated)(view picture)

In 2003 Excel:- Insert Menu -- Function -- Select Financial -- Select PV -- Ok -- Rate:- 10%/12, PMT:- ($10000.00), NPER:- 204

In 2007 Excel:- Formula Menu -- Financial -- PV --
Rate:- 10%/12, PMT:- ($10000.00), NPER:- 204
Always Put Negative PMT i.e. Loan or Pension Amount etc

Contact Form

Name

Email *

Message *

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