Power BI Consultant Pijush Roy

Withdraw PF and EPS Online Step by Step guide

noreply@blogger.com (Pijush Roy) — Sun, 22 Dec 2019 19:24:00 +0000

Hello Friends,
This is your admin Pijush and today I would like to explain the process to withdraw your Provident Fund (EPF) and Pension Fund (EPS). Before starting online application process, some steps we need to follow. Please follow under mentioned step carefully.

STEP 1

CHECK SERVICE DETAILS & DATE OF LEAVING

To access UAN members portal:- CLICK HERE
Insert your UAN number and Password, Insert Captcha code and login your user portal
Select VIEW menu and select SERVICE HISTORY. As below image check DOE (Date of Leaving/Date of End).

STEP 2

BEFORE WITHDRAW, TRANSFER OLD PF/PENSION FUND INTO CURRENT COMPANY

In below SNAP, I have only one company. If you have multiple company, first you need to transfer fund into latest company i.e. FUND associated with OLD company, need to transfer into last company you worked.

If you did not transfer money into last company you worked, you only can withdraw balance for last company you worked.

STEP 3

CHECK YOUR KYC, COMPLETED OR NOT

Go to menu MANAGE and select KYC option.

As below image, you will find that your KYC is completed or not

Please view, How you can complete your KYC

STEP 4

PREPARE YOUR FORM 15G or 15H

Before you applying for withdraw fund, you need to prepare Form 15G or 15H and submit SCAN PDF copy when you applying. Both forms used to save TDS on Interest Income
Form 15H is for senior citizen, that means if account holder age equal or more than 60 years, you need to fill up 15H. Otherwise all other person need to fill 15G.

Please find : Process to fillup 15G and 15H
15G and 15H TDS on Interest Income - Details, Eligibility, Exemption Limit, Schedule

STEP 4

YOU WILL GET OTP IN MOBILE NUMBER WHICH NUMBER LINKED WITH YOUR AADHAAR CARD

After submitting online application, you will get OTP in your mobile number which is linked to your AADHAAR number. So make sure that your mobile is ready in your hand.

STEP 5

SCAN YOUR CHEQUE

Applicator require to scan cheque and create JPG file. Here you not require to sign and write any word on cheque line "CANCELLED". Use same account cheque which account linked in your KYC.
View Example

STEP 6

APPLY FOR WITHDRAW PROVIDENT & PENSION FUND

My Code here, The Quick Brown Fox Jump Over the lazy dog. The quick brown fox jump over the lazy dog. The quick brown fox jump over the lazy dog

FICO-4 Create Business Area in SAP FICO

noreply@blogger.com (Pijush Roy) — Thu, 06 Jun 2019 20:00:00 +0000

Hello Friends, today we will discuss the scope of Business Area and how to create Business Area. Business area define for geographical location of business operation and maintain business area for different PRODUCT line. Business Area helps to generate series wise GRN Engine report and segment wise if require in future. Existing user name and password shared with my team.

For practice purpose, we will create business area for geographical area. Please follow below mentioned area.

Login in SAP Environment
SAP -> Enterprise Structure > Defination > Financial Accounting or use T-Code OX03

Click on New Entries

Insert Values

Click Save

Insert value, write down the Transport Request Number and Password. Click SAVE

FICO-2 Transport Request number not automatically generated after save in SAP

noreply@blogger.com (Pijush Roy) — Wed, 05 Jun 2019 21:21:00 +0000

Hello Friends, today we will discuss about scope of Transport request number and how to generate this number after each configuration or changes has been made in SAP application.

What is Transport Request number?
When we make any configuration and save this, SAP automatically RECORD task process and generate one Transport request number. This number is very important to transfer configuration from TEST Server to GO LIVE Server.

Example of Transport Request number as below. This request number automatically generated number, if user want to generate own number, click on OWN REQUEST.

If SAP Application not generate Transport number automatically for old CONTRACT, We need to inform management and provide possible way to overcome the problem.

Request number contains three different part, for example, in above image, the number is D10K900025
D10 - First 3 digit identifying SAP System ID
K - is fixed kayword
900025 - Random number starting from 900001 followed by System ID and K

IF AFTER SAVE CONFIGURATION, TRANSPORT REQUEST NUMBER POPUP WINDOW NOT APPEARING

It is common that after save any configuration, POPUP will appear with Transport Request number. User need to save the request number for future use. If the popup window not appearing, please follow below steps

After login, type SE01 in tcode and press enter

Please check yellow highlighted flag on or not. User need to turn on the flag.

Then type SCC4 t-code and press enter

Here need to select client. My client is 800, so I am highlight this client

Then click on Display/Change pencil icon (in image)

Please check the highlighted flag and turn this ON. Save the configuration.

Convert Complex Matrix format data into Simple Table by UnPivot option - Part 2

noreply@blogger.com (Pijush Roy) — Sat, 25 May 2019 20:27:00 +0000

In last session, we discuss the process to convert Matrix Table Data into Simple Excel Table. For details, please find the link :- Convert Matrix Date in Simple table data

Today we will convert Matrix format data as follows

Please insert one blank row in top. Users need to create Unique field data for First Two Heading Rows as follows

Copy the Entire worksheet and paste it another sheet as TEXT
Place the PRODUCT NAME in A1 cell
Remove 2 and 3 number rows

Press CTRL+T

Select POWER QUERY FROM TABLE

Select the first column and choose UNPIVOT OTHER COLUMNS

Now need to Split B column data

Therefore our requirement is solved and we will process the data in excel.

Click on Closed and Apply

Excel Power Query will copy and paste data in new excel sheet.

Please find the video

Convert Matrix Pivot Table Date to Simple Data Table in Excel - Part 1

noreply@blogger.com (Pijush Roy) — Mon, 20 May 2019 20:57:00 +0000

If users copying data from PivotTable ot get data in matrix format, users unable to use PivotTable in MATRIX format data. Today, I want to share process How to Convert Matrix data in simple excel file.

First view the sample data in matrix format. If we need to create simple table, we need to follow copy paste manually and it is time consuming task. In excel, we can easily conver matrix data in simple table.

STEP -1
Please follow the sample data which I created

Step -2

Keep mouse pointer in any cell and press CTRL + T

Output as per below image

Step - 3
Please select POWER QUERY
After Excel 2010 version, Power Query are available in 2010, 2013, 2016 with Office 365. To download POWER QUERY, please visit the link :- https://www.microsoft.com/en-in/download/details.aspx?id=39379

Step - 4
Select POWER QUERY
Then select From Table as below image

Step-5
In POWER QUERY, data shows as follow

Step - 6
Selete the First Column "PRODUCT NAME"
Go to TRANSFORM menu
Choose option "UNPIVOT OTHER COLUMN" as follows

OUTPUT will be

You are finish to create simple data table from Matrix/PivotTable.

Tomorrow I will share PART - 2 on CONVERT COMPLEX MATRIX DATA INTO SIMPLE DATA TABLE IN EXCEL

SQL Tutorial 1 - How to Create Table by copying Existing Table in SQL

noreply@blogger.com (Pijush Roy) — Sat, 18 May 2019 17:54:00 +0000

Hello Friends, today I am going to share SQL syntax to create Table by copying data from existing table. Some times it require to create new table for data according to data nature.

Say, you have CUSTOMER table which contains data for MALE, FEMALE and CHILD category. Now you require to create three (3) new table as named CUSTOMER_MALE, CUSTOMER_FEMALE and CUSTOMER_CHILD

My existing table name is DEMO_CUTOMERS and I will create new Customer table

TASK 1

CREATE NEW TABLE WITH ALL DATA FROM EXISTING TABLE

Connect to Oracle Express Edition 11g Database and using my schema name PIJUSH

See my existing Table by using SQL comment SELECT * FROM DEMO_CUSTOMERS

Query which I used for copying data from one table to new table
CREATE TABLE NEWCUSTOMERTABLE AS
SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME
FROM DEMO_CUSTOMERS

Run the query

Query create new table names as NEWCUSTOMERTABLE

Now view the data in new table, run query SELECT * FROM NEWCUSTOMERTABLE
Result is

TASK 2

CREATE NEW TABLE WITH SPECIFIC DATA FROM EXISTING TABLE

Create second table where customer name is WILLIAM

Query which I used

CREATE TABLE NEWCUSTOMERTABLE_2 AS

SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME

FROM DEMO_CUSTOMERS WHERE CUST_FIRST_NAME = 'William'

Run query

See the result

You will notice that, in case of first query, all customer data copy from old table and paste in new table. But for second query, only specific data as mentioned in condition "WHERE CUST_FIRST_NAME = 'William' inserted into new table.

How to Connect and Unlock user in Oracle Database 11g Express edition

noreply@blogger.com (Pijush Roy) — Fri, 17 May 2019 21:41:00 +0000

When users click on SESSION, oracle application ask for session ID and password. The default user HR session are locked.

Click on ALL PROGRAM
Find the Oracle Database 11g Express Edition
Click ob Run SQL Command Line

Type CONNECT and execute the query

Enter username like system
Enter password - password of the database which you input at the time of database installing
After password press enter
Connected

UNLOCK USER
Run SQL query "ALTER USER HR ACCOUNT UNLOCK"
Press Enter

CHANGE USER PASSWORD

Enter in Oracle Database.

Thanks

Create New Company Code by Coping Existing Company Code in SAP FICO

noreply@blogger.com (Pijush Roy) — Fri, 17 May 2019 20:10:00 +0000

In my last articles, I shared notes regarding HOW TO CREATE GROUP COMPANY. In this lesson, I am going to show how to create NEW COMPANY in SAP.

As SAP mythology, users need to maintain financial statement and legal compliance at Company Code level. Therefore as per legal entity, users need to DEFINE COMPANY CODE. Also Company Code used to define company as per continent or region. For example AUDI INDIA LTD, AUDI UK LTD OR AUDI USA LTD.

We will copy from SAP Default company and create our new company. After creation, we will modify necessary change as per our company profile. We will copy from existing company because it will help us to copy SAP default table from existing company to new company.

Before creating the New Company Code, please create Group Company for Consolidated Financial Report, please visit How to Create Group Company in SAP

Therefore, the Company Code creation process divided in two step
STEP -1. Copy from Existing Company
STEP -2. Edit company profile data after copy from exsting company

STEP -1

COPY COMPANY CODE FROM EXISTING COMPANY

After logged in, run comment SPRO in t-code bar

Follow the navigation path as below image or run T-Code OX02

Select Copy, Delete, Check company code and Double click this option

Click on Copy icon
After compiling the table, this window will open

Insert From Company Code, for India I am selecting 4300 Company Code
New 4 Digit Alpha Numeric Number insert in TO COMPANY CODE field, I am inserting R111 i.e. my new company code will be R111
Click continue

We will create our own G/L master. So please select NO

Please select NO if you would not allocate different currency

Click on Continue by cliek tick icon

Application shows warning message. Read the message and click on Continue.

We will create our own Number Ranges for posting, please ignore this step and select NO

Now create our won TRANSPORT REQUEST number. Please save the number in one place. When we are going to transfer configuration from TESTING SAP CLIENT to LIVE SAP CLIENT, we need to use the TRANSPORT REQUEST NUMBER.

Company Code 4300 tables copied to R111 successfully.

STEP -2

EDIT COMPANY CODE DETAILS

After complete Step 1, click on BACK button

Double click on EDIT COMPANY CODE DATA

Click on Position and search the company R111

Double click on company name and edit the data as require
Click on Save

SAP FI Tutorial 1 - Define Company or Group Company in SAP FI

noreply@blogger.com (Pijush Roy) — Tue, 14 May 2019 19:17:00 +0000

Hello Friends, Today we will discuss the meaning of "Define Company" and process to create Company.

Meaning of Company

Company is the group of Company in which we will create our consolidated financial statement. The word "Group of Companies" means in one Company we will assign multiple Company i.e. Company Code. COMPANY is the equivalent to legal entity. Therefore, COMPANY is the parent of the all COMPANY CODE.

For example,
ABC Industries Ltd - is the Parent or Group Company. The group company having three different legal entity like below:-

ABC India Ltd - is the child organization or told as COMPANY CODE
ABC UK Ltd - is the child organization or told as COMPANY CODE
ABC Canada Ltd - is the child organization or told as COMPANY CODE

Process to create COMPANY in SAP

After logged in in SAP. Type SPRO in comment bar and press entry
Expand the ENTERPRISE STRUCTURE and select DEFINE COMPANY option. Please follow below SNAP. Users can also search form by type \nOX15 in comment boss and press enter.

Below page will open

If you need to know any field (like language) specification or details shows in image, please add your comment.

Insert available data
Fill necessary fields and SAVE
After save, click New for generate TRANSPORT REQUEST NUMBER

Insert short description and click on SAVE
Copy the TRANSPORT REQUEST NUMBER in excel file.
Click on CONTINUE icon

Fill black cell with Above/Below cell data - PivotTable Data Analyst

noreply@blogger.com (Pijush Roy) — Fri, 10 May 2019 20:24:00 +0000

Sometimes my management ask to create PivotTable and share PivotTable data in a excel workbook. When I copy data from Pivot Table and paste the data into different excel sheet, I faced problem due to blank cell. Therefore me and my management team can't use filter option.

So today I will share tips to fill blank cell with above or below cell data. Also users can fill the blank cell data with fixed value with simple replace option.

Please follow the data which is copied from PivotTable

Now I need to fill the blank cell with the above cell value

STEP -1

Choose the selection area

STEP - 2

Access FIND AND SELECT

Seelct GoTo Special

STEP - 3

Select Blank

STEP - 5

Now need to select Above/Below cell

STEP - 6

Type =Cell Code like below

Press CTRL + ENTER

STEP - 7

Follow the result

If you want to fill the cell with any specified value, users need to follow the REPLACE function

STEP - 8,

Replace the blank cell with 0 value

Clink on Replace ALL

Done

11 Digit New Registration Number for CMA | CWA | ICWA Students

noreply@blogger.com (Pijush Roy) — Tue, 03 Mar 2015 10:34:00 +0000

The Institute of Cost Accountants of India (CMA) has been updated old alphanumeric (like ERS/001***) Registration Number to 11 Digit Numeric Registration Number. This conversion is applicable only for students who are pursuing courses, not for the students who are already qualified.

To check 11 Digit New Registration number, students must know and enter old alphanumeric Registration Number (like ERS/******).

To check 11 digit New Registration Number, please visit under mentioned link.
http://eicwai.org/Student_Reg/StudReg.aspx
UPDATE 01.01.2020:- This link is not working properly. Please ignore this link. The domain has been updated from ICWAI to ICMAI. If we find the same option on the website, we will update it here.

Check Our New YouTube Video - SUBSCRIBE, LIKE, and SHARE

Non-Operating Expense meaning

noreply@blogger.com (Pijush Roy) — Tue, 13 Aug 2013 18:41:00 +0000

Non-Operating expenses are those expenses which are not occurred from normal business activities. Every business has own specific business activities. Non-operating expenses are not part of company main operation. Most common non-operating expense is interest, borrowing charge, exchange difference, abnormal cost, non-recurring onetime expense etc. All expenses which are not related to his operation will be his non-operating expenses.

For example, if business main activity is making and sells of furniture, main business operation is making and selling furniture. For these activities, business needs to lend or borrow money and return back within permissible time with interest. Borrowing money is not main operation, so Interest expense is treated as a Non-Operation Expense. But for the banking or any financial institution, interest expense is operating expense because their main business operation is lending and borrowing money.

Significance of Non-operating expense calculation
Management need to eliminate the effect of non-operating expense for taking managerial or financing decision because it is not including the daily business activities. Non-operating expense is mentioned separately in the Income Statement.

Non-operating expenses List
Interest of debenture
Financial Expense or charge
Depreciation on non-operating assets
Dividend paid (on equity capital, Sweat equity capital, pref dividend)
Flotation Cost
Amortization of Amalgamation Adjustment Account
Expense on Issue of Share & Debenture
Loss of sale of Assets
Discount on Issue of share
Discount on issue of debenture
Amortization of Goodwill
Amortization of Preliminary expense
Amortization of profit and loss account debit balance
Amortization of deferred revenue expense

Operating Expense meaning and list of example

noreply@blogger.com (Pijush Roy) — Thu, 01 Aug 2013 18:51:00 +0000

Operating expenses are those expenses which are incurred in normal business activities or core business operation on daily basis but not directly associated with the production. Operating expense starts after the stage of Cost of goods Sold (COGS) and end before the non-operating expense in the Income Statement. It is cost of running a product, business or system. Operating Expenses also known as Operating Expenditure, Operation Expense, Operational Expenditure, OPEX.

Operating expense is cost of operation which turns the inventory into finished goods or throughput. Therefore it is non-manufacturing expense.

There are two common condition to consider one expense as operating expense. Conditions are First, must not part of Cost of Goods Sold (COGS) & Second, expense incurred from day to day business activities. Mainly General and Administration Expense and Selling and Distribution expense is treated as operating expense.

List of Operating Expense are
Payroll / Salary & Wages
Hire and leasing
Sales Commission
Employee benefit
Office Supplier like telephone, page
Pension
Contribution and donation
Depreciation and amortization
Travelling expense (not for private purpose)
Rent, Repair and Taxes
Accounting Expenses
Licence Fee, Attorney Fee, Legal Fee
Advertising
Utilities
Office Expense
Management Fees

Important
Operating expense is a vital part of the income statement. Management want to reduce the operation expense without hamper the normal business activities. If management can reduce operation expense without effect the quality of business operation, business will able to gain more profit. In this discussion market competition plays important roles.
Operating expense is also important to calculate the Operation Income. Operation income uses the useful toll for the investors. Operating income needed to calculate the Economic Value Added.

Operating Revenue - Meaning

noreply@blogger.com (Pijush Roy) — Fri, 26 Jul 2013 20:47:00 +0000

According to source of Revenue, it is divided into two categories i.e. Operating revenue and Non-operating revenue.

Operating Revenue:-

Operating revenue denotes the revenue which earned from normal and regular business activities of organization. Operating revenue is sales after adjusted
sales return and other discount. Other forms of income such as interest on investment or sale of assets are income but not consider in the calculation of
operation revenue. Operating revenue in balance sheet reflects only ordinary revenue generate from the regular business operation.

The concept of revenue earns from regular and normal activities are varied business to business. In case of cement industry, sales are considered as normal
& regular business activities. Interest of investment is not treated as normal or regular business activities. In case of banking or any finance
sector, interest from investment is considered as the regular business activities.

Operating Revenue = Sales (or other income from regular business activities) + other regular incomes (lease income from major activity) - Sales return -
Sales Discount.

Non-operating expenses like sales tax, excise duty will not deduct from the sales.

Operating Revenue
Sales Volume or Commission
Less Sales return
Discount

Operating revenue is excellent tool to calculate Economic value Added (EVA) and Operating Profit Margin or Operating Margin.

Difference between operating revenue and operating profit or income

Operating revenue generally denotes sales volume minus sales return and sales discount, where operating profit means operating revenue minus cost of sale.

Cost of Goods Sold (COGS) - Meaning and Calculation Format

noreply@blogger.com (Pijush Roy) — Thu, 25 Jul 2013 18:46:00 +0000

Cost of Goods Sold (COGS) refers to the cost to a business of making product or service. COGS differ from one industry to another. COGS appear on the
income statement and can be deducted from revenue to calculate a company's gross margin. The cost of goods sold includes net direct inventory cost and
labour expense, factory overhead, office and administration overhead but does not includes indirect cost related to selling and distribution overhead.

For manufacturing industry, COGS refers to buying of raw material & expense for manufacturing finished goods. For retailers, it is the cost of
obtaining or buying the products sold to customer. If the company is in a service industry, COGS is the cost of the service it offers.

In simplest method, COGS denotes value of inventory at the begging of specified period plus purchase of inventory less inventory at the ending of specified
period. For accounting theory, this for is widely used. Different technique used for First in First out (FIFO) and Last in First out (LIFO) inventory
control technique.

Therefore COGS = Opening Inventory + Purchase value of inventory – Closing Inventory.

Under cost accounting technique, COGS calculate following process

Particular	Amount	Amount
Operating stock of raw material Add Purchase of raw material Carriage charge at the time of raw material purchase Fright charge on raw material Less Closing stock of raw material Material return to the supplier Abnormal loss on raw material
RAW MATERIAL CONSUMED
Add Direct wages Direct expense Chargeable expenses
PRIME COST
FACTORY OVERHEAD Factory Overhead Indirect wages Indirect expense or material Oil Waste Power, fuel, coal, gas, electricity etc Factory rent and insurance Works stationery Depreciation on Furniture, factory building Supervisor or works manager salary Factory canteen & recreation expense Worker training and recruitment Expense of purchase department Cotton, grease Worker compensation Normal loss of material Research expense Normal idle time cost (exclude abnormal cost) Security Store supervisor expense Expense of service department Some other expenses related to factory Less sale of scrap Add Opening working progress Less closing working progress
WORKS COST / FACTORY COST
OFFICE AND ADMINISTRATION OVERHEAD Office rent Depreciation on office furniture Manager salary Office staff salary Office printing and stationery Office rent and taxes Office building insurance Office lighting and heating Advertisement Telephone & postage expenses Director fees Depreciation related to office furniture, building, equipment Sundry office expense Salaries for accounting office Repair of office assets Audit fees and legal expenses Subscription of trade association Bank expenses Subscription to newspaper, journal Salary of general manager Other expenses related to office
COST OF PRODUCTION
Add opening finish goods Less closing finish goods
COST OF GOOD SOLD / COST PRODUCTION OF GOOD SOLD

meaning, calculation and significance of Weighted Average Cost of Capital (WACC) or Overall Cost of Capital

noreply@blogger.com (Pijush Roy) — Mon, 15 Jul 2013 20:08:00 +0000

WACC denotes the Weighted Average Cost of Capital. It is also known as Overall Cost of Capital. As the name suggest, it is computed by reference to the proportion of each element of capital as weights. WACC is the expected average future cost of finance over the long run of firm.

Weighted Cost of Capital of Overall Cost of Capital represented symbolically by Ko

WACC = Sum of (Cost of each Capital Element × Proportion or percentage or weight of Capital)

The calculation of Weighted Average Cost of Capital or Overall Cost of Capital involves the following steps:-

Determine the cost of each source of capital separately i.e. Cost of Equity Capital, Cost of Debt, Cost of Preference Capital, Cost of Retained Earning, Cost of Loan, Cost of any other finance.
Determine the weight of each source of capital.
Multiplying the cost of each of the source by appropriate weights. and
Dividing the total weighted cost by total weight.

Format of calculation of WACC

Source of Capital	Proportion or %	Each Element Cost	Multiplication
Equity Capital	W1	Ke	W1 × Ke
Pref Share Capital	W2	Kp	W2 × Kp
Debt	W3	Kd	W3 × Kd
Retained Earning	W4	Ke	W4 × Ke
Total	100		Sum of above

WACC = Sum of above / 100

Therefore WACC is the average cost of the company’s finance, equity, debenture, bank loans weighted according to the total pool of capital.

In case of selection of weight, there are two main aspects relevant to the selection of appropriate weight are (1) Marginal weight and (2) Historical Weight

Marginal Weight: - marginal weight is the proportion of different source of fund additionally raised for new investments. As the proportion of different source are not equal, so weighted average marginal cost of capital is to be computed for investment decision.
Historical Weight:- Historical weight is the proportion of source of finance. Historical weight also divided into two category i.e. (1) Book Value of weight and (2) Market value of weight

Now the question arise that which system of weighting – marginal or historical is preferable.

Marginal weight is widely used because WACC and Marginal Weight both focus in the future project. The alternative to the use of marginal weight is to be use of historical weight. Again the problem is to be faced as to which weight are to be consider book value weight or market value of weight in case of historical weight. Generally market value of weight is considered because it reflects the current market value or condition. If the company or firm is not listed or not traded in the stock exchange, it is not possible to determine the market value. Hence the book value of weight is to be considered.

Importance or Significance of Weighted Average Cost of Capital (WACC) or Overall Cost of Capital:-

in case of determination of future project profitability, WACC is treated as Cut off rate
if firm earn more percentage of profit than WACC, therefore the market value of the firm will increased. Profit taken or not decision is depending on this point. A project considered valuable only if the return from it re higher than WACC.
Business unit used different source of finance and invested in the project. So individual cost of capital is not enough for project selection process. Therefore overall cost of capital is considered for project selection process.
WACC is widely used to selection project among the option available.
WACC is useful in making Economic value Added (EVA) calculation.
WACC indicate the minimum rate of return at which business unit create the investors value. If Return on Capital Employed (ROCE) is higher than WACC, business unit will create the investors value, otherwise business unit will fail to create the investors value.

Check Our New YouTube Video - SUBSCRIBE, LIKE, and SHARE

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

How you resize your logo:-

Windows XP = Go to MS Paint - File menu - Open any image - press CTRL+W - under STRETCH put value 96 in Horizontal Box & 80 in Vertical Box - OK - Save image
Windows 7 = Go to MS Paint - File menu - Open any image - press CTRL+W - choose Pixel - put value 96 in Horizontal Box & 80 in Vertical Box - Maintain Expect Ration - OK - Save image

For example, I design a demo logo. Now I install this logo in tally.

Step 2
ACTIVATE LOGO FEATURE

Gateway of Tally - press F11 - press F1 or press A or press enter on Accounting Feature - YES Enable Company Logo option

After YES logo option, a pop up window open & ask for path of your company logo. Carefully put correct logo path.

Logo is automatically printed on Challan, Debit Notes, Credit Notes, Outstanding or Receivables, Reminder Letter, Pay Slip, Purchase Order when user takes printout.

Check Our New YouTube Video - SUBSCRIBE, LIKE, and SHARE

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.

Cash credit theory based on “Pay on Demand”. Cash Credit arrangement is one type of short term loan or finance or advance raised by Bank or Financial Institute to business organization. Cash credit facilities fulfill the requirement of working capital which is needed to run daily operation in a business concern. It is similar to loan but different from conventional loan. In this system, Bank or Financial Institute maintain a Cash Credit Account for their borrower. Cash credit makes a provision for credit by transferring the sanctioned amount into Cash Credit Account from which borrower can withdraw as per their requirement. Borrower can withdraw money within sanctioned “limit” & “daily limit”. Cash Credit Account almost similar to Current Account but it’s not Current Account. In cash credit system, interest charged on amount actually withdrawn in daily basic. Borrower can’t withdraw total sanctioned amount of loan at a time.

Bank or Cash Credit provider holds Stock or Book Debt (as security) against advance sanctioned. The security or guarantee remains accessible by advance provider (normally Bank) until Cash Credit repaid in full. Depending on the security holds, Cash Credit facility is two types i.e. Pledge (where Bank or Financial Institute holds physical control of stock & book debt.) & Hypothecation (borrower holds total control of stock and submits periodical statement of stock to the lender). Cash Credit-Hypothecation system is broadly used.

Cash credit amount is pre-approved and the repayment of loan is the same whether borrower is using cash credit or not. If cash credit amount is paid off before term of loan is complete, borrower is liable to pay penalty fee based on % of loan amount.

Characteristic of Cash Credit Facilities:-

It’s one type of short period (more period than overdraft) finance or loan.
Cash Credit facility is a provision to create loan or advance or credit by lender (mainly bank or financial institute) to borrower (mainly business concern)
It’s used to fulfill working capital requirement which is needed to run trading operation in a business. Only business concern can enjoy this facility. Working Capital = Current Assets – Current Liabilities.
Business concern can enjoy Cash Credit facility against Pledge or Hypothecation of stock, book debt as a security or guarantee of the finance.
Advance is sanctioned & money transfer to Cash Credit account by Bank or Financial Institute.
Borrower can withdraw money from Cash Credit account within permissible amount fixed by Bank for specific period.
Borrower can’t withdraw total loan amount at a time.
Interest charged amount actually withdrawn in daily basic, not full loan amount. Bank can charge certain amount on portion of loan not used by business concern because bank can’t use cash credit sanctioned amount.
Bank is not funded total required working capital. Some portion of working capital is invested by the business entities himself & balance amount is supply by bank in way Cash Credit.

Purpose of Cash Credit:-
Main purpose of cash credit facility is to fulfill the requirement of working capital. Working capital is needed to run daily trading & business operation in a business concern.

Check Our New YouTube Video - SUBSCRIBE, LIKE, and SHARE

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

Press F11

Press "A" or Press Enter on "ACCOUNTING FEATURES" or press "F1"

GENERAL

Integrate Accounts and Inventory:- By default option is YES. This option is available if you select "ACCOUNTS WITH INVENTORY" while creating the company.
YES = Balance Sheet & Profit & Loss Account reflects inventory/stock figure (closing stock) automatically. NO = Balance Sheet & P & L A/c not reflect stock/inventory figure automatically. You may put closing stock figure manually.

Income/Expense Statement instead of P & L :- By default option is NO.
YES = Generate report as Income/Expense Statement in place of P & L Account. This feature commonly follows by Non-Profit Making Organization.
NO = Generate P & L Account

Allow Multi-Currency :- By default option is NO.
YES = Maintain account with different currency like Rs, USD etc. Usefull for multi-national company, export & import business, have foreign currency transection. If you choose YES, CURRENCY option show in Gateway of Tally - Account Info - Currency. In currency menu you can get option to Create, Alter, Display, Defined Rate of Exchange.
Details :-
NO = Maintain accounts in one currency like Rs

OUTSTANDING MANAGEMENT

Maintain Bill-wise Details :- By default option is YES.
YES = You can maintain "bill-wise details" & "credit period" allowed on ledger under Sundry Debtor & Sundry Creditor group.
NO = Not require to maintain bill-wise trading account
Details Click Here

( for non trading a/c also) :- By default option is NO.
YES = If you want to maintain bill wise details for non-trading account (i.e. other than Debtor & Creditor Ledger), you may set it YES. Non-trading account means which is not related to trading activities like loan, advance, ads exp etc.
NO = Non-trading account don't ask bill wise details.

Activate Interest Calculation :- By default option is NO.
YES = you can calculate interest on fixed rate on outstanding balance of ledger accounts or invoices.
NO = interest calculation not applicable

use advanced parameters :-By default option is NO.
YES = This option is used to calculate interest when rate of interest is changed time to time.
NO = interest calculation in advance parameters is not applicable.

COST PROFIT CENTRES MANAGEMENT

Maintain Payroll :- By default option is NO.
YES = maintain payroll system
NO = don't maintain payroll system
Details :-

Maintain Cost Centres :- By default option is NO.
YES = allocation of cost according to cost centres wise.
NO = don't allocation of cost
Details :- CLICK HERE

Use Cost Centres for Job Costing :- By default option is NO.
YES = have job or project work
NO = don't follow job or project work
Details :-

More than One Payroll / Cost Category :- By default option is NO.
YES = allocation of cost according to many cost categories or payroll
NO = not applicable many cost categories or payroll
Details :- CLICK HERE

Use Pre defined Cost Centres Allocation during Entry :- By default option is NO.
YES = cost allocation according to previous defined cost centres
NO = above option not applicable
Details :-

Show Opening Balance of Revenue Item in Report :- By default option is NO.
YES = show opening balance in cost centres report which are allocated to ledger under revenue item i.e. Income Group or Expense Group

NO =above condition not applicable
Details :-

INVOICING

Allow Invoicing :- By default option is YES

YES = enter inventory through invoice
NO = enter inventory through vouchers
Details :-

Enter Purchase in Invoice format :- By default option is YES
YES = create purchase vouchers in invoice format
NO = above statement not follow
Details :-

Use Debit/Credit Note :- By default option is NO
YES = to make separate debit or credit notes
NO = to make journal for adjustment entry
Details :-

Use Invoice Mode for Credit Notes :- By default option is NO
YES = to make credit notes in invoice mode
NO = N/A
Details :-

Use Invoice Mode for Debit Notes :- By default option is NO
YES = to make debit notes in invoice mode
NO = N/A
Details :-

BUDGETS & SCENARIO MANAGEMENT

Maintain Budgets and Controls :- By default option is NO
YES = create & use of different types of budgets
NO = don't use budgets
Details :-

Use Reversing Journals & Optional Vouchers :- By default option is NO
YES = to create reversing & optional journal which are not affect account books
NO = don't use reversing & optional journal
Details :-

OTHER FEATURES

Enable Chaque Printing :- By default option is NO
YES = print cheque
NO = ignore cheque prining
Details :-

Set or Alter Cheque Printing Configuration :- By default option is NO
YES = to alter cheque printing configuration
NO = don't alter cheque printing configuration
Details :-

Allow Zero Value Entries :- By default option is NO, it's commonly NO because zero values entry has no meaning.
YES = to enter zero value entry
NO = don't enter zero value entry

Maintain Multiple Mailing Details for Company & Ledger :- By default option is NO
YES = use multi address features
NO = above statement not applicable
Details :-

Set/Alter Company Mailing Address :- By default option is NO
YES = to alter company existing address
NO = don't want to change address

Enable Company Logo :- By default option is NO
YES = to insert & print company logo in Invoice, Challan, Debit/Credit Notes, Pay slip, Purchase order etc
NO = don't use company logo
Details :-

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

When any payment to any contractor, payer liable to deduct tax at source (if applicable) before payment to contactor & such amount of tax deposited to the Central Govt within prescribed time.

Everyone can’t deduct tax at source or collect tax at source. If person have valid Tax Deduction Account No (TAN), then these person is eligible to deduct tax at source or collect tax at source. TAN or Tax Deduction or Collection Account No is a 10 digit alpha numeric no which is required to obtain all person who is liable to deduct or collect tax at source. It’s mandatory to quote TAN at the time of TDS/TCS return (including e-TDS/e-TCS return), payment of TDS/TCS, issue TDS/TCS certificate to payee.

Deduction should be made at a specified rate & from the following sources of Income

Salary (section 192)
Interest on Securities (section 193)
Dividend mentioned on section 2(22)(e) (section 194)
Interest other than interest on securities (section 194A)
Winning from lottery or crossword puzzles (section 194B)
Winning from Horse race (section 194BB)
Payment to Contract or sub contract (section 194C)
Insurance commission (section 194D)
Payment to non-resident sportsmen or sports association (section 194E)
Payment out of deposite NSC (section 194EE)
Payment on account of repurchase of unit by MF or UTI (section 194F)
Commission, remuneration or prize for stocking, distributing, purchasing/selling of lottery tickets (section 194G)
Commission or brokerage (section 194H)
Rent (section 194-I)
Fees for professional, technical, royalty etc (section 194J)
Payment for acquisition of immovable property (section 194LA)
Payment of interest or any other sum of money (other than income taxable as salaries) to Non-resident assessee or Foreign company (section 195)
Long term capital gain on units referred u/s 115AB (section 196B)
Income from foreign currency bonds or shares of Indian Company U/s 115AC (section 196C)
Income from securities referred u/s 115AD(1)(a) (section 196D)

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

Check Our New YouTube Video - SUBSCRIBE, LIKE, and SHARE

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

Check Our New YouTube Video - SUBSCRIBE, LIKE, and SHARE

Create,Display,Alter,Delete of Group in Tally

noreply@blogger.com (Pijush Roy) — Thu, 12 Jan 2012 18:46: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.

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

Check Our New YouTube Video - SUBSCRIBE, LIKE, and SHARE