Zakat Calculation Spreadsheet Printed on 08/29/2025

Zakat Calculator
(Capture Values only in Green Cells. Kindly refer to the Important Note at the end of this sheet before you update this sheet) www.ampindia.org

1 ZAKAT ON GOLD (2.5%) Weight in Grams Price/Gm Estimated Value Zakat Payable
1a. 24 Carat Gold/Jewelry 20.00 8,750.00 175000.00 4375.0
1b. 22 Carat Gold/Jewelery 55.00 8,020.00 441100.00 11027.5
1c. 18 Carat Gold/Jewelry 0.00 0.0
1d. Other Gold Valuables. (Pls. insert the Current Estimated Value) 0.0

2 ZAKAT ON PRECIOUS STONES (2.5%) (Refer Important Notes at the end of this sheet for details of this category ) Estimated Value Zakat Payable

2a. Calculate the Net Market Value of Precious stones like Diamonds, Rubies, etc. and add them to the Estimated Value Column 0.00
(Please consult an Aalim)

3 ZAKAT ON SILVER (2.5%) Weight in Grams Price/Gm Estimated Value Zakat Payable

3a. Include Household Silver Utensils, Artefacts, and Jewelery. For Utensils, usually the 0.00
silver is 90% pure so take 90% of the total weight 0.00

4 ZAKAT ON CASH IN HAND/BANK (2.5%) Actual Value Zakat Payable

4a. Cash in Hand 0.00
4b. Cash in Savings Accounts 0.00
4c. Cash in Current Accounts 0.00
4d. Cash held in Fixed Deposits 0.00

5 ZAKAT ON INVESTMENT IN SHARES/BONDS/ MUTUAL FUNDS/ADVANCES/SECURITY DEPOSITS, ETC. (2.5%) Actual Value Zakat Payable
5a. Loans Receivable from Friends and Relatives / Security Deposits / Advances 0.00
5b. Investment in Govt Bonds, PSU Bonds, Corporate Bonds 0.00
5c. Insurance Premiums paid including bonus up to date 0.00
5d. Value of Shares/Bonds/Mutual Funds. Take the market value on Zakat Due Date 0.00

Page 1 of 5
 Zakat Calculation Spreadsheet Printed on 08/29/2025

5e. Government Security Deposits, ADRs, etc 0.00

5f. Investment in Private Chits, Funds, etc 0.00
5g. Postal Savings/Deposits 0.00
5h Other Sources of Wealth 290081.00 7252.03

6 ZAKAT ON LAND PROPERTY (2.5%) Estimate Value Zakat Payable

6a. Property held as an Investment / Business (Estimate the current Market Value) 0.00
6b Plots of land held for sale (Market value on Zakat Due Date) 0.00

7 ZAKAT ON BUSINESS (2.5%) (STOCK-IN-TRADE) Actual Value Zakat Payable

7a. Value of Saleable Stock -
7b. Value of Damaged/Dead Stock -
7c. Amount Receivable from Credit Sales -
7d. LESS: Amount Payable to Suppliers (Credit taken from suppliers for stocking goods) -
7e. LESS: Bad Debts -
Total Value of Stock ( 7a+7b+7C-7d-7e) 0.00 0.00

8 ZAKAT ON SHARE IN PARTNERSHIP FIRMS (2.5%) Actual Value Zakat Payable

8a. Capital, Reserves and Surplus as per last balance Sheet (your share) -
8b. Your Loan to the Firm as on Zakat Due Date -
8c. LESS: Withdrawals made by you during the current year -

8d. Accumulated Profit from the date of Balance Sheet to this Date (Estimate the Profit Value as it is difficult to get exact figures -
in the middle of Accounting Year)
NET TOTAL WORTH CALCULATED 0.00 0.00

9 ZAKAT ON AGRICULTURAL PRODUCE (10%, 7.5%, 5%) Value of Produce Zakat Payable
9a. Produce Dependent on Rain Water - @ 10% of product (crop) in Value or Kind 0.00
9b.
0.00
Produce totally dependent on Artificial Irrigation like Canal, Tank, Borewell, etc. @ 5% of Produce (crop) in Value or in Kind
9c.
0.00
Produce dependent Partially on Rain Water and Partially on Artificial Irrigation @ 7.5% of the produce Value or in Kind

Page 2 of 5
 Zakat Calculation Spreadsheet Printed on 08/29/2025

10 ZAKAT ON ANIMALS (Sheeps,Goats, Cows, Buffaloes & Camels) Total Value Zakat Payable
Sheep, lamb, goat (40-120: 1 animal, 121-200: 2 animals, 201-300: 3 animals)
Cows & Buffaloes (30-39: 1 calf of 1 year, 40-59: 1 animal of min. 2 years, 60-69: 2 calves of 1 year)

11 DEDUCTIONS - You need to deduct your liabilities - Usage of the loan should have been on Zakatable Wealth only. Total Value Zakat Payable
11a. Loans taken from Friends / Relatives
11b. Loans Taken from Banks / Institutions (Loan taken for residential property only) 1300000.00
11c. Zakat paid in advance during the year
TOTAL DEDUCTIONS 1300000.00 -32500.00

TOTAL ZAKAT PAYABLE ==> -9845.47

IMPORTANT NOTE: Please read below summary for more details.

Zakat Due Date
As a first step towards ascertaining zakat liability, please determine your Zakat Due Date. It can be 1st Raman, 21st Ramzan, 1st Moharrum or any other convenient
date of lunar calendar. Once fixed, it remains same year after year. Every year zakat become due on your zakatable wealth on the Zakat Due Date.

Zakat on Gold and Silver

Zakat on gold should be calculated at 2.5% of the market value as Zakat Due Date. Zakat is to be paid on silver in pure form or jewellery, utensils, decorative items
and all household items including crockery, cutlery made of silver at 2.5% of the prevailing market rates.

Zakat on Cash and Bank Balances

Zakat should be paid at 2.5% on all cash balance and bank balances in your savings bank account, current a/c or FD account on Zakat Due Date.
Zakat on Loans and Advances Given to Friends and Relatives

Zakat is payable by you on loans you have given to your friends and relatives. If the your loan/advance is doubtful or bad, you may not calculate it as your wealth.
You can add it to your wealth on receipt of this loan/advance.

Page 3 of 5
 Zakat Calculation Spreadsheet Printed on 08/29/2025

Zakat is payable on Govt Bonds, Public Sector Bonds, Pvt Sector Bonds, Insurance policies, voluntary contribution to Provident Fund, Gratuity amount received, PF
Settlement, Commutation of pension received.

Zakat on Landed Property

Zakat is not payable on personal residential house even if you have more than one and meant for residential purpose only. However Zakat is payable on the rental
income itself after deducting the maintenance and other expenses.

If your intention of holding properties is to sell at a future date, or as an investment, then Zakat is payable on the Market Value of the property. Also, if your
intention of holding properties changes in the current year, i.e. from self use to business then you need to pay Zakat on that Property Value.

Zakat on Business:
If you are a businessman, trader, merchant or industrialist, please undertake valuation of all your inventory - raw materials, finsihed goods on Zakat Due Date. The
stock of raw materials must be valued at its landed cost price and stock of finished goods should be valued at market sales price. If you have any bills receivable
(sales given on credit) then you need to add the same towards calculations.
Deduct the amounts due to your suppliers and deduct the loans on stock on the date of calculation. Dead Stock should be calculated on scrap value or its saleable
value. Damaged stock should also be valued at its scrap value.

There is no Zakat on factory buildings, plant & machinery, equipment, furniture and fixtures used in the business. However, zakat is applicable on products
produced in the factory (i.e. finished goods value).

Zakat on Partnership Firms.

Zakat can be paid either by the firm or separately by each partner. If the firm is not paying, and the partner wants to calculate his share, he should take the amount
standing to his capital and loan account as per the last balance sheet. Add his estimated share of profit till Zakat Due Date.
This can only be estimated as it is difficult to calculate the exact profit or loss between an accounting year.

Page 4 of 5
 Zakat Calculation Spreadsheet Printed on 08/29/2025

Zakat on Agricultural Product

Zakat is payable on all agricultural produce including fruits, commercially grown flowers, vegetables and all types of grains at the harvest time itself. The passing of
One year does not apply for agrultural produce. If there are two or more crops on the same land per year, then Zakat has to be paid as many times on the crop,
irrespective of the time.
The formula for Zakat calculation on agriculture is as follows:
On crops dependent purely on rain water it will be 10% of produce, On crops not irrigated through rain water but use Canal Water, Tank Water, Borewell and Open
wells, the Zakat is 5% of the produce. For Crops dependent partly on Rain Water and partly on other water, the Zakat applicable would be 7.5% of produce.

Zakat on Animals
Zakat is payable on all grazing animals, like goats, sheep, camel, cows and buffaloes.

Liabilities Deductions

If you have taken any loans from any person or institution, and if you have not already deducted the same from any of the above sections, then you can deduct your
payables over here. Please be truthful, as Zakat is a sure way of protecting ones wealth if Zakat has been paid on it regularly and fully.

Loans taken only for Zakatable-Wealth should be deducted. Cars, Houses, etc are not Zakatable wealth. So any loan taken for these purposes are not to be deducted

For any further clarifications or more details on Zakat calculations, kindly contact your local Imam / Mufti

Let’s
Let’s Empower
Empower Lives
Lives Through
Through Zakat…Make
Zakat…Make Zakat
Zakat Taker
Taker to
to Zakat
Zakat Giver.
Giver. Donate
Donate to
to AMP
AMP Zakat
Zakat Fund.
Fund.
For
For details
details on
on AMP
AMP Zakat
Zakat Fund,
Fund, pls
pls visit
visit www.ampindia.org/AMP_Zakat_Fund
www.ampindia.org/AMP_Zakat_Fund OR
OR mail
mail to
to zakat@ampindia.org
zakat@ampindia.org
For
For donating
donating your
your Zakat
Zakat to
to AMP,
AMP, kindly
kindly visit
visit www.tinyurl.com/ampzakat
www.tinyurl.com/ampzakat

Page 5 of 5