Share Your Knowledge

Use & Print Corpany Logo in Tally 9.erp

noreply@blogger.com (Pijush Roy) — Fri, 17 Feb 2012 20:43:00 +0000

Tally 9.erp (release 3 & all upper version) allow to use and print COMPANY LOGO or CORPORATE LOGO in some selected documents.

Corporate Logo symbolizes any company & creates separate identity from others. Sometimes common people forget company name but remember their logo. Logo is easily identifiable for its design, color and different from others. So it's use as a BRAND for a company.

Tally 9.erp insert this grate feature to use important company document (mainly which is used for external purpose) i.e. Sales Invoice, Delivery Notes or Challan, Debit Notes, Credit Notes, Outstanding or Receivables, Reminder Letter, Pay Slip, Purchase Order

Step 1
LOGO

Logo (picture) format must be BMP or JPEG
Logo size = 96 (width) * 80 (height) pixel

Cash Credit facility-Definition,Characteristic,Purpose

noreply@blogger.com (Pijush Roy) — Mon, 13 Feb 2012 16:27:00 +0000

Definition of Cash Credit facility
There are many ways to raise finance; Cash Credit is one of the many ways of raising finance. Cash Credit makes a provision by lender (mainly bank or financial institute) for loan (also called advance, finance, credit etc) by depositing the sanctioned amount of the loan into new account from which borrower (business organization) can withdraw as per requirement within permissible amount fixed by lender for specific time or period.

Example: - say, ABC Ltd needs ` 1,15,000 for payment to supplier of raw materials. Bank permits `1,00,000 per day as cash credit limit for this period. In this situation ABC Ltd can withdraw only `1,00,000. Interest also calculated on ` 1,00,000 on daily basic, not on ` 1,15,000.

Configuration of Tally F11 Accounting Features

noreply@blogger.com (Pijush Roy) — Sun, 12 Feb 2012 19:56:00 +0000

Configuration of the "Accounting Features" under "Tally F11 - Company Features".

Open Tally software - Gateway of Tally

Master Articles List on MS Excel Application

noreply@blogger.com (Pijush Roy) — Mon, 06 Feb 2012 10:41:00 +0000

Basic Excel Knowledge

Differences between Excel 2007 and Excel 2003
http://www.pijushroy.com/2011/06/differnce-between-excel-2007-to-excel.html
Important Keyboard Shortcut Key for Microsoft Excel
http://www.pijushroy.com/2011/07/excel-shortcut-key-keyboard-shortcut.html
Lines Break & Wrap Text in One Excel Cell
http://www.pijushroy.com/2011/07/wrap-text-line-break-in-microsoft-excel.html
Excel Date, Weekday and Weekend Function
http://www.pijushroy.com/2011/12/excel-date-weekday-and-weekend-function.html
Create and Remove Drop Down Menu List or Data Validation in Excel 2007, 2010, 2003 etc
http://www.pijushroy.com/2012/01/create-remove-drop-down-list-in-excel.html

Use of IF or Logical Function

Excel Salary Calculator or Salary Pay Slip Calculation (IF Function)
http://www.pijushroy.com/2011/08/salary-calculator-excel-salary-slip.html

Use of Excel Financial Function

Excel Financial Function to calculate Present Value (PV)
http://www.pijushroy.com/2012/01/excel-financial-function-to-calculate.html
Excel Financial Function to calculate No of Installment (NPER)
http://www.pijushroy.com/2012/01/excel-financial-function-to-calculate_01.html
Excel Financial Function to calculate Rate of Interest
http://www.pijushroy.com/2012/01/excel-financial-function-to-calculate_7826.html
Excel Financial Function to calculate Future Value (FV)
http://www.pijushroy.com/2012/01/excel-financial-function-to-calculate_1478.html
Excel Financial Function to calculate Installment Amount (PMT)
http://www.pijushroy.com/2012/01/excel-financial-function-to-calculate_4673.html
Excel SYD Finance Function to calculate Depreciation under Written Down Value Method and SLN Finance Function to calculate Depreciation under Straight Line Method
http://www.pijushroy.com/2012/01/excel-financial-function-to-calculate_03.html

Excel, Financial & Cost Accounting

Batch/Jobs Costing Calculation in Excel
http://www.pijushroy.com/2011/07/batch-costingcalculation-in-excel-job.html

Excel Statistical Function

Use of Excel Minimum And Maximum Function
http://www.pijushroy.com/2011/08/use-excel-minimum-maximum-formula-or.html

Master Articles List on Investment

noreply@blogger.com (Pijush Roy) — Fri, 03 Feb 2012 06:23:00 +0000

Investment

Rates of Interest of NSC (National Savings Certificate)
http://www.pijushroy.com/2011/10/rates-of-interest-of-nsc-national.html

NSC Calculator | Calculate Interest-Maturity Value
http://www.pijushroy.com/2011/10/nsc-calculator-calculate-interest.html

Master Articles List on Banking

noreply@blogger.com (Pijush Roy) — Thu, 02 Feb 2012 16:46:00 +0000

Loan, Credit, Advance, Finance

Cash Credit facility - Definition, Characteristic, Purpose
http://www.pijushroy.com/2012/02/cash-credit-facility.html

What is Tax Deduction at Sources (TDS)?

noreply@blogger.com (Pijush Roy) — Thu, 02 Feb 2012 11:47:00 +0000

What is Tax Deduction at Sources (TDS) or Definition of TDS:-

Tax on income of previous year is usually made on the assessment year. To avoid tax evasion, the Income Tax Act has made provision to collect tax by way of Tax Deduction at Source (TDS) and Tax Collection at Source (TCS).

Tax deducted at source is one of the modes of collecting Income-tax from the assessee in India. TDS is an indirect method of collecting tax from the tax payer/deductor by the income tax department through tax payer. TDS is pre-paid payment of tax in previous year in which incomes receive/accrued. The tax so deducted from the income of the payee is deemed to be payment of Income-tax by the recipient at the time of his assessment. Such amount of tax i.e. TDS will be deducted from Tax Liability at the time of assessment in the assessment year. TDS is final tax payable, when payee fill return, the payee pays the balance if under TDS payment in the previous year or asks for refund if over TDS payment in the previous year. Income & payment of tax both occur in the previous year. Payee is liable to pay tax on income in previous year on previous year income. Under the scheme of TDS, person (payer) is responsible for making payment of income are liable to deduct tax at source at a specified rate from the income (if such income cover under TDS provision issue by Income Tax Act) as per relevant provision of the act and balance income is either to be credited in the account of payee or is handed over. The amount so deducted is to be deposited to the Central Governments’ treasury (either deposited to bank through Challan-281 or make a book transfer without use of challan) within the stipulated time in the name of payee.

For example: -

When any employee is received salary from employer, employer is liable to deduct tax at source before payment (if employee income for this previous year is taxable).

Articles List on IFRS

noreply@blogger.com (Pijush Roy) — Wed, 01 Feb 2012 20:17:00 +0000

UPDATE SOON

Articles List on Indian Income Tax

noreply@blogger.com (Pijush Roy) — Wed, 01 Feb 2012 17:26:00 +0000

Tax Deduction at Sources (TDS)

What is Tax Deduction at Sources (TDS)?
http://www.pijushroy.com/2012/02/what-is-tax-deduction-at-sources-tds.html

Articles List on Indian Accounting Standard (IAS)

noreply@blogger.com (Pijush Roy) — Wed, 01 Feb 2012 17:25:00 +0000

UPDATE SOON
-
-
-
-
-
-

Articles List on Corporate Accounting

noreply@blogger.com (Pijush Roy) — Wed, 01 Feb 2012 17:24:00 +0000

UPDATE SOON
-
-
-

Articles List on Financial Accounting

noreply@blogger.com (Pijush Roy) — Wed, 01 Feb 2012 17:22:00 +0000

UPDATE SOON
-
-
-
-
-
-

Maintain Accounts Bill by Bill in Tally, Ledger & Voucher Effect

noreply@blogger.com (Pijush Roy) — Sun, 15 Jan 2012 18:16:00 +0000

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, Cost Centre & Cost Categories in Tally

noreply@blogger.com (Pijush Roy) — Sat, 14 Jan 2012 18:01:00 +0000

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

Create,Display,Alter,Delete of Group in Tally

noreply@blogger.com (Pijush Roy) — Thu, 12 Jan 2012 18:46:00 +0000

15 Primary Group (PreDefined)	13 Sub Group (Predefined)
15 Primary 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 & Remove Drop Down List in Excel

noreply@blogger.com (Pijush Roy) — Thu, 05 Jan 2012 17:20:00 +0000

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

Excel Financial Function to calculate two types Depreciation

noreply@blogger.com (Pijush Roy) — Tue, 03 Jan 2012 12:05:00 +0000

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)

Excel Financial Function to calculate Installment Amount (PMT)

noreply@blogger.com (Pijush Roy) — Sun, 01 Jan 2012 13:34:00 +0000

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

Excel Financial Function to calculate Future Value (FV)

noreply@blogger.com (Pijush Roy) — Sun, 01 Jan 2012 13:30:00 +0000

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

Excel Financial Function to calculate Rate of Interest

noreply@blogger.com (Pijush Roy) — Sun, 01 Jan 2012 13:25:00 +0000

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

Excel Financial Function to calculate No of Installment (NPER)

noreply@blogger.com (Pijush Roy) — Sun, 01 Jan 2012 13:08:00 +0000

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

Excel Financial Function to calculate Present Value (PV)

noreply@blogger.com (Pijush Roy) — Sun, 01 Jan 2012 12:44:00 +0000

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

Excel Date, Weekday and Weekend Function

noreply@blogger.com (Pijush Roy) — Thu, 29 Dec 2011 23:24:00 +0000

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")

Ms Excel Age Calculator - Download

noreply@blogger.com (Pijush Roy) — Wed, 21 Dec 2011 20:58:00 +0000

Download Ms Excel free Age Calculator file & calculate age within few second. You need to insert only DATE OF BIRTH. Excel formulas automatically calculate age as Years, Month & Day format.

Download Excel Age Calculator

Create, Display & Alter Ledger in Tally9.ERP

noreply@blogger.com (Pijush Roy) — Tue, 20 Dec 2011 16:16:00 +0000

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.