Cash Denomination Calculator
Calculate total cash value instantly by entering the count of each note and coin.
Cash Denomination Calculator
Count your notes and coins, get the exact total in numbers and words, and download a free Excel template or Word format for bank deposits, cash register closing and daily cash books.
Free Download: Excel Template and Word Format
Ready-made cash denomination sheet, no signup needed. Works offline on PC and mobile.
A cash denomination calculator works out the exact value of the currency notes and coins you hold, without any manual multiplication and addition. You enter how many notes or coins you have of each value, such as 500, 200, 100, 50, 20, 10, 5, 2 and 1 rupee, and the tool gives you a note-wise breakup, the grand total and the amount in words. It is useful for shopkeepers, cashiers, bank customers, accountants and anyone who counts cash regularly. If you only need the files, you can jump to the free Excel and Word downloads at the top of this page.
Most bank pay-in slips ask for the number of notes of each denomination together with the total amount. Businesses such as retail stores, petrol pumps, restaurants and small traders also prepare a currency-wise count at the end of every shift. Doing this by hand takes time and a single wrong entry can make the day's cash book fail to tally. This page explains the formula behind the calculation, shows worked examples, and gives you a free Excel sheet and a Word format in case you prefer working offline or keeping a printed record.
- Line total = Denomination value × Number of pieces
- Grand total = Sum of all line totals
- Rs 500 notes: 1 lakh = 200 notes, 10,000 = 20 notes
- 53 notes of Rs 500 = ₹26,500
- Expected cash = Opening cash + Cash received − Cash paid out − Cash deposited in bank
- Need the files? Download the free Excel template and Word format
Free downloads · What it is · How to use it · Formula and examples · Indian denominations · Quick reference table · Amount in words · Excel formulas · Excel template · Word format · On a PC · Bank deposit · Daily cash closing · FAQ
What Is a Cash Denomination Calculator?
The word "denomination" simply means the face value of a note or coin. A cash denomination calculator takes the count of each denomination, multiplies it by its value and adds every line to give the total cash in hand. It then converts that total into words, which is exactly what bank deposit forms and cash certificates ask for.
This is an Indian cash denomination calculator in the sense that it is built around rupee notes and coins and around the lakh and crore numbering system used in India. A plain calculator needs you to type every multiplication and keep a running total in your head. A denomination counter is organised like a currency count sheet instead: one row for each note or coin, a count in one column, the amount in the next column, and the total at the bottom. That structure is what keeps mistakes low.
How to Use the Calculator
- Sort your notes and coins by value, keeping each denomination in its own pile.
- Count the pieces in each pile and enter that number against the matching denomination.
- Let the tool multiply each count by its value and show the line total.
- Check the grand total and the amount written in words.
- Copy or write down the breakup for your deposit slip, cash register or accounts entry.
How the Calculation Works: Formula and Examples
Whether you use a paper register, a spreadsheet or an online tool, the calculation is the same simple multiplication and addition. There is no interest, percentage or compounding involved.
Grand Total = Sum of all Line Totals
Total Pieces = Sum of all Number of Pieces
Example 1: A shopkeeper's day-end count
A shopkeeper counts the cash drawer and finds 4 notes of 500, 10 notes of 100, 15 notes of 50, 20 notes of 10 and 8 coins of 5.
| Denomination | Pieces | Calculation | Line Total |
|---|---|---|---|
| 500 | 4 | 500 × 4 | ₹2,000 |
| 100 | 10 | 100 × 10 | ₹1,000 |
| 50 | 15 | 50 × 15 | ₹750 |
| 10 | 20 | 10 × 20 | ₹200 |
| 5 | 8 | 5 × 8 | ₹40 |
| Grand Total | 57 | ₹3,990 |
In words, the total reads "Three Thousand Nine Hundred Ninety Rupees Only", which is the wording a bank teller or accounts team expects on a form.
Example 2: A larger bank deposit
A business wants to deposit cash made up of 200 notes of 500, 50 notes of 200, 100 notes of 100, 80 notes of 50, 60 notes of 20, 22 notes of 10 and 2 coins of 5.
| Denomination | Pieces | Calculation | Line Total |
|---|---|---|---|
| 500 | 200 | 500 × 200 | ₹1,00,000 |
| 200 | 50 | 200 × 50 | ₹10,000 |
| 100 | 100 | 100 × 100 | ₹10,000 |
| 50 | 80 | 50 × 80 | ₹4,000 |
| 20 | 60 | 20 × 60 | ₹1,200 |
| 10 | 22 | 10 × 22 | ₹220 |
| 5 | 2 | 5 × 2 | ₹10 |
| Grand Total | 514 | ₹1,25,430 |
The deposit is 514 pieces in total and the amount in words is "One Lakh Twenty Five Thousand Four Hundred Thirty Rupees Only". Seeing the count per denomination also makes it easy to bundle the notes for the bank.
Working backwards: breaking an amount into notes
Sometimes you know the amount and need the notes, for example when you withdraw cash or prepare salary packets. Start with the largest denomination, take as many notes as fit, and carry the remainder down to the next denomination. This greedy method gives the smallest number of notes.
48,760 ÷ 500 = 97 notes (₹48,500), remainder ₹260
260 ÷ 200 = 1 note, remainder ₹60
60 ÷ 50 = 1 note, remainder ₹10
10 ÷ 10 = 1 note, remainder ₹0
| Denomination | Notes Needed | Amount |
|---|---|---|
| 500 | 97 | ₹48,500 |
| 200 | 1 | ₹200 |
| 50 | 1 | ₹50 |
| 10 | 1 | ₹10 |
| Total | 100 | ₹48,760 |
If you need a specific mix, for example no Rs 200 notes or only 100s and 500s, adjust the order or the list of denominations in the same way.
Indian Currency Denominations
These are the notes and coins used in everyday cash handling in India. A reliable denomination calculator should cover every value so nothing is left out of the count.
| Denomination | Type | Colour (Mahatma Gandhi New Series notes) |
|---|---|---|
| ₹2000 | Note | Magenta (see note below) |
| ₹500 | Note | Stone grey |
| ₹200 | Note | Bright yellow |
| ₹100 | Note | Lavender |
| ₹50 | Note | Fluorescent blue |
| ₹20 | Note | Greenish yellow |
| ₹10 | Note | Chocolate brown |
| ₹10, ₹5, ₹2, ₹1 | Coins | Not applicable |
A good tool lists the denominations from highest to lowest, which matches how people usually sort and stack cash before counting.
Quick Reference: Value of Notes
People often search for answers such as "53 notes of 500 how many rupees" or "48 notes of 200 how many rupees". This table gives the value of the most common note counts. To find any other number, multiply the number of notes by the face value.
| Number of Notes | Rs 500 Notes | Rs 200 Notes | Rs 100 Notes | Rs 50 Notes |
|---|---|---|---|---|
| 1 | ₹500 | ₹200 | ₹100 | ₹50 |
| 2 | ₹1,000 | ₹400 | ₹200 | ₹100 |
| 3 | ₹1,500 | ₹600 | ₹300 | ₹150 |
| 4 | ₹2,000 | ₹800 | ₹400 | ₹200 |
| 5 | ₹2,500 | ₹1,000 | ₹500 | ₹250 |
| 6 | ₹3,000 | ₹1,200 | ₹600 | ₹300 |
| 8 | ₹4,000 | ₹1,600 | ₹800 | ₹400 |
| 10 | ₹5,000 | ₹2,000 | ₹1,000 | ₹500 |
| 15 | ₹7,500 | ₹3,000 | ₹1,500 | ₹750 |
| 20 | ₹10,000 | ₹4,000 | ₹2,000 | ₹1,000 |
| 25 | ₹12,500 | ₹5,000 | ₹2,500 | ₹1,250 |
| 30 | ₹15,000 | ₹6,000 | ₹3,000 | ₹1,500 |
| 34 | ₹17,000 | ₹6,800 | ₹3,400 | ₹1,700 |
| 40 | ₹20,000 | ₹8,000 | ₹4,000 | ₹2,000 |
| 48 | ₹24,000 | ₹9,600 | ₹4,800 | ₹2,400 |
| 50 | ₹25,000 | ₹10,000 | ₹5,000 | ₹2,500 |
| 53 | ₹26,500 | ₹10,600 | ₹5,300 | ₹2,650 |
| 55 | ₹27,500 | ₹11,000 | ₹5,500 | ₹2,750 |
| 60 | ₹30,000 | ₹12,000 | ₹6,000 | ₹3,000 |
| 75 | ₹37,500 | ₹15,000 | ₹7,500 | ₹3,750 |
| 80 | ₹40,000 | ₹16,000 | ₹8,000 | ₹4,000 |
| 88 | ₹44,000 | ₹17,600 | ₹8,800 | ₹4,400 |
| 90 | ₹45,000 | ₹18,000 | ₹9,000 | ₹4,500 |
| 95 | ₹47,500 | ₹19,000 | ₹9,500 | ₹4,750 |
| 100 | ₹50,000 | ₹20,000 | ₹10,000 | ₹5,000 |
| 120 | ₹60,000 | ₹24,000 | ₹12,000 | ₹6,000 |
| 150 | ₹75,000 | ₹30,000 | ₹15,000 | ₹7,500 |
| 200 | ₹1,00,000 | ₹40,000 | ₹20,000 | ₹10,000 |
How many notes make a given amount?
| Amount | Rs 500 Notes | Rs 200 Notes | Rs 100 Notes |
|---|---|---|---|
| ₹5,000 | 10 | 25 | 50 |
| ₹10,000 | 20 | 50 | 100 |
| ₹25,000 | 50 | 125 | 250 |
| ₹50,000 | 100 | 250 | 500 |
| ₹1,00,000 | 200 | 500 | 1,000 |
| ₹2,00,000 | 400 | 1,000 | 2,000 |
| ₹5,00,000 | 1,000 | 2,500 | 5,000 |
For example, ₹1,00,000 (one lakh) is 200 notes of 500, 500 notes of 200 or 1,000 notes of 100.
Amount in Words: The Indian Numbering System
Bank forms and cash certificates need the total in words as well as in figures. In India amounts are written with the lakh and crore system instead of the million and billion system, and the commas are placed differently: the first group has three digits and every group after that has two.
| Indian Style | Name | International Style |
|---|---|---|
| 1,000 | One Thousand | 1,000 |
| 10,000 | Ten Thousand | 10,000 |
| 1,00,000 | One Lakh | 100,000 |
| 10,00,000 | Ten Lakh | 1,000,000 |
| 1,00,00,000 | One Crore | 10,000,000 |
Here is how common totals are written in words:
| Amount | In Words |
|---|---|
| ₹3,990 | Three Thousand Nine Hundred Ninety Rupees Only |
| ₹26,500 | Twenty Six Thousand Five Hundred Rupees Only |
| ₹48,760 | Forty Eight Thousand Seven Hundred Sixty Rupees Only |
| ₹1,25,430 | One Lakh Twenty Five Thousand Four Hundred Thirty Rupees Only |
| ₹10,00,000 | Ten Lakh Rupees Only |
Always end the amount in words with "Only" so that nothing can be added afterwards. If the figure and the words on a document differ, banks usually treat the words as the correct amount, so check both before you sign.
Cash Denomination Calculator in Excel: Formulas and Layout
Many accountants and small business owners keep a cash denomination calculator Excel sheet because it also serves as a record. You can build one in a few minutes, or download the ready-made template from the top of this page. To build it yourself, put the denominations in column A, the number of pieces in column B and the amount in column C, with the first data row as row 2.
| Cell | What it holds | Formula or value |
|---|---|---|
| A2 to A12 | Denominations | 2000, 500, 200, 100, 50, 20, 10, 10, 5, 2, 1 |
| B2 to B12 | Number of notes or coins | You type these in |
| C2 | Line amount (copy down to C12) | =A2*B2 |
| C13 | Grand total | =SUM(C2:C12) |
| B13 | Total number of pieces | =SUM(B2:B12) |
| Any cell | Total in a single formula | =SUMPRODUCT(A2:A12,B2:B12) |
More useful formulas for a denomination sheet
| Purpose | Formula |
|---|---|
| Difference between counted cash (C13) and cash book balance (E2) | =C13-E2 |
| Status label from the difference in D2 | =IF(D2=0,"Tallied",IF(D2>0,"Excess","Short")) |
| Number of ₹500 notes in the amount in G1 | =INT(G1/500) |
| Number of ₹200 notes in the remainder | =INT(MOD(G1,500)/200) |
| Number of ₹100 notes in the remainder | =INT(MOD(MOD(G1,500),200)/100) |
| Show amounts with lakh and crore commas (custom number format) | [>=10000000]##\,##\,##\,##0;[>=100000]##\,##\,##0;##,##0 |
To use the lakh format, select the amount cells, press Ctrl+1, choose Custom and paste the format code. A total of 125430 then displays as 1,25,430. Excel has no built-in function that writes an amount in words in the Indian system. You either need a macro or a long formula, which is one reason many people use the online calculator for the words and Excel for the record.
Cash Denomination Calculator Excel Free Download
If you want a ready-made sheet instead of building one, download our free cash denomination calculator Excel template. It has the formulas above already in place and works offline on any PC with Microsoft Excel, LibreOffice or Google Sheets.
What is inside the template:
- Cash Count sheet: one row for every note and coin, automatic line amounts, total pieces, grand total, and a check against your cash book that shows Tallied, Short or Excess.
- Daily Register sheet: a month-long grid for daily counts with a daily total and a monthly total.
- Lakh and crore formatting: amounts are shown the Indian way, for example 1,25,430.
- How to use sheet: short instructions and the assumptions used.
The yellow cells are the ones you edit. Example values are filled in, so clear them before you start your own count. For the amount in words, use the online calculator on this page.
Cash Denomination Format in Word
Some offices want a printed, signed statement instead of a spreadsheet, for example for a petty cash certificate, an audit file or a cash handover between two staff members. A cash denomination format in Word is simple: a header with the date and the name, a table of denominations, and space for the amount in words and signatures.
This is the layout used in the downloadable format. You can also copy it into any Word document.
| Sr. | Denomination (₹) | No. of Notes / Coins | Amount (₹) |
|---|---|---|---|
| 1 | 2000 | ||
| 2 | 500 | ||
| 3 | 200 | ||
| 4 | 100 | ||
| 5 | 50 | ||
| 6 | 20 | ||
| 7 | 10 (note) | ||
| 8 | Coins (10, 5, 2, 1) | ||
| Total |
Below the table add: "Amount in words: ______ Rupees Only", the names of the person who counted and the person who verified the cash, and a signature and date line.
Adding totals inside Word
Word can add a column for you. Click in the total cell, open the Layout tab, choose Formula and enter =SUM(ABOVE). Word does not recalculate automatically, so select the cell and press F9 after you change any number. For anything with many rows, the Excel template is easier to maintain, and you can paste the finished table into Word when you need a printed copy.
Online Calculator, Excel Sheet or Word Format: Which One to Use?
| Feature | Online Calculator | Excel Sheet | Word Format |
|---|---|---|---|
| Setup needed | None, ready instantly | Download or build once | Download or build once |
| Amount in words | Built in | Needs a macro or long formula | Write by hand |
| Works on mobile | Yes | Needs a spreadsheet app | Needs a Word app |
| Keeps a record | Copy the result and save it | Yes, one sheet per day or month | Yes, as a signed printout |
| Risk of broken formulas | None, logic is fixed | Possible if a cell is edited | Totals must be refreshed with F9 |
| Best for | Quick counting at the counter | Daily and monthly records | Certificates and audit files |
A common routine is to count with the online tool, note the result in the Excel register, and print the Word format when a signature is needed.
Using the Calculator on a PC, Laptop or Phone
You do not need to install software to use a cash denomination calculator for PC. It runs in the browser on Windows, macOS and Linux, and on a phone or tablet in the same way. A few habits make it faster on a computer:
- Press Tab to move from one denomination field to the next, so you can count and type without touching the mouse.
- If your keyboard has a number pad, use it for fast entry.
- Bookmark this page, or use your browser's option to create a desktop shortcut, so it opens in one click at the counter.
- Press Ctrl+P and choose "Save as PDF" if you need a printed or saved copy of the result.
- For a fully offline setup, keep the Excel template on the same PC.
How to Fill a Bank Deposit Slip Using a Denomination Breakup
A pay-in slip usually has a table of denominations at the back or on the side. Counting first and writing from the calculator's breakup makes the slip quick to fill.
- Count each denomination and note the pieces in your calculator or sheet.
- Write the number of notes and the amount against each denomination on the slip.
- Write the coins together, or denomination-wise if the slip has separate lines for them.
- Add the totals and make sure the slip total matches the calculator total.
- Write the amount in words, ending with "Only".
- Arrange the notes in the same order as the slip, facing the same way, with damaged notes kept separate.
Daily Cash Closing and Reconciliation
Counting cash is only half the job. The other half is checking it against what the books say you should have. At the end of the day, work out the expected closing cash and compare it with the physical count.
Difference = Counted Cash − Expected Cash
Expected cash = 12,500 + 48,300 − 9,750 − 30,000 = ₹21,050
The shopkeeper then counts the drawer using the denomination calculator:
| Denomination | Pieces | Line Total |
|---|---|---|
| 500 | 30 | ₹15,000 |
| 100 | 50 | ₹5,000 |
| 50 | 18 | ₹900 |
| 20 | 4 | ₹80 |
| 10 | 2 | ₹20 |
| Counted Cash | 104 | ₹21,000 |
Difference = 21,000 − 21,050 = −₹50. The drawer is short by ₹50. A positive difference would mean excess cash. When the difference is small, first recount the high-value notes, then check whether an expense or a payment was left out of the book. Keep the daily denomination sheet with the cash book, because it shows exactly what was counted.
If you pay workers or staff in cash, the denomination breakup also tells you how many notes of each value you need from the bank to make exact salary packets. For government employees, you can work out allowances with our DA Calculator, and for daily wage or attendance records our Attendance Calculator gives you the working percentage.
Who Uses a Denomination Calculator?
| User | Typical use |
|---|---|
| Retail stores and shopkeepers | Closing the register at the end of the day |
| Bank staff and cash officers | Preparing denomination-wise deposit slips |
| Petrol pumps and fuel stations | Reconciling shift-wise cash collection |
| Event organisers | Counting collections at weddings, fairs and donation drives |
| Accountants and auditors | Verifying petty cash and cash-in-hand entries |
| Schools and institutions | Counting fee collections before deposit |
| Households | Counting savings, gift money or emergency cash |
Why Denomination-Wise Counting Matters
Banks ask for a denomination-wise breakup for two main reasons. First, it lets them verify that the cash handed over matches the declared amount without recounting every note. Second, it gives an audit trail of how many high-value and low-value notes were part of a transaction, which helps in internal reconciliation and record keeping.
For a business, an accurate breakup also prevents disputes. If a cashier's count and the bank's count differ, a documented, calculator-generated summary makes it much easier to find where the mismatch happened: a miscount, a mixed note, or a wrong entry.
Common Mistakes While Counting Cash
| Mistake | How to avoid it |
|---|---|
| Mixing torn or damaged notes with clean notes | Keep a separate pile and count it separately |
| Forgetting coins in the final summary | Count coins last and add them to the sheet before totalling |
| Entering a count against the wrong denomination | Read the denomination label twice before typing |
| Not rechecking before a bank deposit | Recount the bundles and compare with the calculator total |
| Relying on memory | Save or write down the breakup immediately |
| Counting notes of different denominations in one stack | Sort first, then count |
| Not checking notes for authenticity | Check the security features of high-value notes as described by the RBI |
Faster counting habits
- Face all notes the same way and keep the same orientation in every bundle.
- Count in groups of ten and place a marker, then build up to bundles of 100.
- Count the same pile twice, preferably by two different people for large amounts.
- Record the count immediately instead of remembering it for later.
More Free CalcShala Calculators
- Attendance Calculator: attendance percentage, 75% eligibility and monthly average attendance
- Experience Calculator: total work experience in years, months and days
- DA Calculator: dearness allowance and arrears for government employees
- Negative Marking Calculator: exam scores with 1/3, 1/4 or custom negative marking
- SGPA Calculator and SRM CGPA Calculator: grade points and CGPA
- NUST Aggregate Calculator: merit aggregate for NUST admissions
Browse every tool on the CalcShala homepage.
Frequently Asked Questions
What is a cash denomination calculator used for?
It works out the total value of cash by multiplying the number of notes and coins of each denomination by its face value and adding the results. It is commonly used for bank deposits, cash register closing and petty cash checks.
Is there a free Excel download for a cash denomination sheet?
Yes. You can download the free Excel template from the top of this page. It has automatic line amounts, a grand total, a cash book check and a monthly register, and it works offline on a PC.
How do I make a cash denomination format in Word?
Insert a table with four columns (serial number, denomination, number of notes or coins, amount) and one row for each denomination plus a total row. Add the date, name, amount in words and signature lines. You can also download the ready format from the top of this page.
Can I use this as a cash denomination calculator for PC?
Yes. It runs in any modern browser on Windows, macOS or Linux, so nothing needs to be installed. For offline use on a PC, the Excel template does the same job.
What is the difference between an Excel sheet and the online tool?
Both use the same formula of count multiplied by value and added up. The online tool needs no setup, works on any device and gives the amount in words, while an Excel sheet is better for keeping daily and monthly records.
How many notes of 500 make one lakh rupees?
200 notes. One lakh is ₹1,00,000, and 1,00,000 ÷ 500 = 200.
53 notes of 500 are how many rupees?
53 × 500 = ₹26,500. The same method works for any count: multiply the number of notes by the face value. See the quick reference table above for common counts.
How do I write the denomination on a bank slip?
Write the number of notes and the amount against each denomination in the table on the slip, add the coins, write the total in figures and in words, and make sure both match the cash you are handing over.
Can I use it for currencies other than Indian rupees?
The multiplication and addition work for any currency. The amount in words is built around the Indian lakh and crore numbering system.
Does the calculator store my cash data?
The calculation runs in your browser, so the numbers you enter stay on your device and are not saved on a server.
Are ₹2000 notes still counted?
The RBI announced the withdrawal of ₹2000 notes from circulation in May 2023, but they remain legal tender. The calculator keeps a row for them so old stock can be counted. Check the RBI website for the latest position.
Why do banks ask for a denomination-wise breakup?
It lets the bank verify the cash against a declared count quickly and keeps a clear record of how many notes of each value were deposited, which reduces mismatches and disputes.
What should I do if my counted cash does not match the cash book?
Recount the high-value notes first, then check for a missing expense, a payment not entered or a deposit recorded twice. Use the difference formula in the daily closing section to see whether you are short or in excess.
Conclusion
Counting cash by hand is slow and leaves room for error, especially with a mix of high and low value notes and coins. A cash denomination calculator turns it into a few seconds of data entry and gives you an accurate total, a clean line-by-line breakup and the amount in words. Use the online calculator at the counter, the Excel template for your daily and monthly records, and the Word format when you need a signed printout.
Get the free Excel template and Word format
Banking and tax rules mentioned on this page can change, and practices differ between branches. Always confirm the current requirements with your bank or the RBI. Last updated: October 2026.