All Types of SUM Formulas in Excel – Complete Guide with Examples

Microsoft Excel is one of the most powerful tools for managing and analyzing data. Among all the functions available in Excel, the SUM function is the most basic and most frequently used formula.

Whether you are a student calculating marks, a shop owner managing daily sales, an accountant preparing financial reports, or an office employee handling large datasets — addition is something you perform almost every day.

However, many users believe that Excel only has one SUM formula. In reality, Excel provides multiple ways to perform addition based on different conditions and requirements.

In this complete guide, we will explore all important SUM-related formulas in Excel, along with practical examples and professional tips.

---

1. SUM Function – The Basic and Most Essential Formula

The SUM function is the simplest and most commonly used formula in Excel. It adds a range of numbers together.

Syntax:

=SUM(number1, [number2], ...)

or

=SUM(A1:A10)

Example 1: Adding a Range of Numbers

Suppose you have the following marks:

Marks
50
60
70
80
90

To calculate the total marks:

=SUM(A1:A5)

Result: 350

---

Example 2: Adding Specific Cells

If you want to add selected cells only:

=SUM(A1, A3, A5)

This will add only A1, A3, and A5.

---

2. AutoSum – Quick Addition Without Typing

Excel provides a shortcut called AutoSum (∑).

How to Use AutoSum:

1. Click on the cell where you want the result.

2. Press Alt + = on your keyboard.

3. Press Enter.

Excel automatically selects the nearby range and calculates the total.

This method is perfect for quick calculations in reports.

---

3. Manual Addition Using the Plus (+) Operator

For very small datasets, you can manually add numbers:

=A1+A2+A3

However, this method is not recommended for large datasets because it becomes difficult to manage and edit later.

---

4. SUMIF – Add Based on One Condition

When you need to add numbers based on a specific condition, use the SUMIF function.

Syntax:

=SUMIF(range, criteria, sum_range)

• range → Where the condition is checked

• criteria → The condition

• sum_range → The numbers to add

---

Example:

Product	Sales
Apple	200
Mango	150
Apple	300
Banana	100

To calculate total sales of Apple:

=SUMIF(A2:A5,"Apple",B2:B5)

Result: 500

---

Example: Greater Than Condition

To add sales greater than 150:

=SUMIF(B2:B5,">150")

---

5. SUMIFS – Add with Multiple Conditions

When you have more than one condition, use SUMIFS.

Syntax:

=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2)

---

Example:

Product	City	Sales
Apple	Delhi	200
Apple	Mumbai	300
Mango	Delhi	150
Apple	Delhi	400

To calculate total sales where Product = Apple AND City = Delhi:

=SUMIFS(C2:C5, A2:A5,"Apple", B2:B5,"Delhi")

Result: 600

---

6. SUM with Multiple Ranges

You can add multiple separate ranges in one formula:

=SUM(A1:A5, C1:C5)

This adds both ranges together.

---

7. 3D SUM – Adding Across Multiple Sheets

If you have data in multiple sheets and want to add the same cell across them:

Example: Add cell A1 from Sheet1 to Sheet3.

=SUM(Sheet1:Sheet3!A1)

This is called a 3D SUM formula and is very useful in monthly or yearly financial reports.

---

8. SUBTOTAL – Sum Filtered Data Only

When you apply filters in Excel and want to add only visible rows, use SUBTOTAL.

Syntax:

=SUBTOTAL(function_num, range)

For SUM, function number = 9.

Example:

=SUBTOTAL(9, A1:A10)

This will ignore hidden rows and calculate only visible data.

---

9. AGGREGATE – Advanced SUM Function

AGGREGATE is an advanced version of SUBTOTAL. It can ignore errors and hidden rows.

Syntax:

=AGGREGATE(function_num, options, array)

Example:

=AGGREGATE(9,6,A1:A10)

• 9 = SUM

• 6 = Ignore errors

If your data contains errors like #DIV/0!, this function will ignore them and still calculate the correct total.

---

10. SUMPRODUCT – Multiply and Add Together

SUMPRODUCT is useful when you need to multiply values and then add them.

Example:

Quantity	Price
2	100
3	150

To calculate total revenue:

=SUMPRODUCT(A2:A3,B2:B3)

Calculation:
(2×100) + (3×150) = 200 + 450 = 650

This formula is widely used in business calculations.

---

11. SUM with Date Conditions

You can also sum data between specific dates.

Example:

=SUMIFS(B2:B10, A2:A10, ">=01-01-2025", A2:A10, "<=31-01-2025")

This calculates total sales for January 2025.

---

Real-Life Uses of SUM Formulas

Excel SUM formulas are widely used in:

• Daily sales reports

• Student result sheets

• Monthly expense tracking

• Salary calculation

• Inventory management

• Business profit analysis

If you master these formulas, you can handle most real-world Excel tasks efficiently.

---

Difference Between SUM and SUMIF

SUM	SUMIF
Simple addition	Addition with condition
No criteria required	Requires criteria
Basic usage	Advanced filtering

---

Professional Tips for Using SUM in Excel

✔ Always double-check your selected range
✔ Use SUMIFS instead of multiple SUMIF formulas
✔ Use SUBTOTAL when filters are applied
✔ Use AGGREGATE when your data contains errors
✔ Avoid manual addition for large datasets
✔ Use SUMPRODUCT for business calculations

---

Common Mistakes to Avoid

1. Selecting incorrect ranges

2. Forgetting quotation marks in criteria

3. Mixing up SUMIF and SUMIFS syntax

4. Using manual addition for large reports

5. Not locking cell references when copying formulas

---

Conclusion

The SUM function in Excel is more than just a basic addition tool. From simple totals to advanced conditional calculations, Excel provides powerful formulas like SUMIF, SUMIFS, SUBTOTAL, AGGREGATE, and SUMPRODUCT to handle different scenarios.

If you only know =SUM(), that’s a great start. But once you learn conditional and advanced SUM formulas, you move from being a beginner to becoming an advanced Excel user.

Mastering these formulas will not only improve your productivity but also increase your professional value in any job that requires data handling.

Excel में SUM Formula के सभी प्रकार – Complete Guide with Examples (Hindi)

Excel में काम करने वाले हर व्यक्ति के लिए “SUM” सबसे ज़रूरी और सबसे ज़्यादा इस्तेमाल होने वाला फ़ॉर्मूला है। चाहे आप छात्र हों, अकाउंटेंट हों, दुकान चलाते हों या ऑफिस में डेटा एंट्री करते हों — जोड़ (Addition) करना हर जगह ज़रूरी होता है।

लेकिन क्या आप जानते हैं कि Excel में सिर्फ =SUM() ही नहीं, बल्कि जोड़ करने के कई अलग-अलग तरीके होते हैं? इस लेख में हम Excel के सभी महत्वपूर्ण SUM फॉर्मूला को विस्तार से उदाहरण सहित समझेंगे।

---

1. SUM Function – Basic और सबसे ज़रूरी फ़ॉर्मूला

क्या है SUM Function?

SUM Excel का सबसे बेसिक और सबसे ज़्यादा इस्तेमाल होने वाला फ़ॉर्मूला है, जो किसी रेंज (Range) के सभी नंबरों को जोड़ देता है।

Syntax:

=SUM(number1, [number2], ...)

या

=SUM(A1:A10)

उदाहरण 1:

मान लीजिए आपके पास ये डेटा है:

A (Marks)
50
60
70
80
90

अगर आपको A1 से A5 तक के सभी नंबर जोड़ने हैं, तो फ़ॉर्मूला होगा:

=SUM(A1:A5)

Result = 350

उदाहरण 2: अलग-अलग सेल जोड़ना

=SUM(A1, A3, A5)

यह सिर्फ A1, A3 और A5 को जोड़ेगा।

---

2. AutoSum – बिना टाइप किए जोड़

Excel में एक खास फीचर होता है — AutoSum (∑)।

कैसे इस्तेमाल करें?

1. जिस सेल में रिज़ल्ट चाहिए, वहाँ क्लिक करें

2. Keyboard से Alt + = दबाएँ

3. Enter दबाएँ

Excel अपने आप ऊपर या बाईं ओर की रेंज चुन लेता है।

यह तरीका तेज़ काम के लिए बहुत उपयोगी है।

---

3. Manual Addition – Direct + से जोड़ना

छोटे डेटा के लिए आप सीधे + का इस्तेमाल कर सकते हैं।

=A1+A2+A3

लेकिन ध्यान रखें: बड़े डेटा के लिए यह तरीका सही नहीं है।

---

4. SUMIF – एक शर्त के आधार पर जोड़

जब आपको किसी खास कंडीशन के आधार पर जोड़ करना हो, तब SUMIF का उपयोग किया जाता है।

Syntax:

=SUMIF(range, criteria, sum_range)

• range = जहाँ कंडीशन चेक होगी

• criteria = क्या शर्त है

• sum_range = कौन सा डेटा जोड़ना है

उदाहरण:

Product	Sales
Apple	200
Mango	150
Apple	300
Banana	100

अगर सिर्फ Apple की Sales जोड़नी है:

=SUMIF(A2:A5,"Apple",B2:B5)

Result = 500

Example 2: Greater Than Condition

अगर 150 से ज्यादा Sales जोड़नी है:

=SUMIF(B2:B5,">150")

---

5. SUMIFS – Multiple Conditions के साथ जोड़

जब एक से ज्यादा शर्त हो, तब SUMIFS का इस्तेमाल होता है।

Syntax:

=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2)

उदाहरण:

Product	City	Sales
Apple	Delhi	200
Apple	Mumbai	300
Mango	Delhi	150
Apple	Delhi	400

अगर Apple + Delhi की Sales जोड़नी है:

=SUMIFS(C2:C5, A2:A5,"Apple", B2:B5,"Delhi")

Result = 600

---

6. SUM with Multiple Ranges

अगर आपको दो अलग-अलग रेंज जोड़नी हैं:

=SUM(A1:A5, C1:C5)

यह दोनों रेंज का टोटल देगा।

---

7. 3D SUM – Multiple Sheets का जोड़

अगर आपके पास तीन शीट हैं:

Sheet1
Sheet2
Sheet3

और आपको तीनों शीट के A1 सेल जोड़ने हैं:

=SUM(Sheet1:Sheet3!A1)

यह Sheet1 से Sheet3 तक सभी शीट के A1 सेल जोड़ देगा।

यह तरीका अकाउंटिंग और मासिक रिपोर्ट में बहुत काम आता है।

---

8. SUBTOTAL – Filtered Data का जोड़

जब आप Filter लगाते हैं और सिर्फ दिखाई देने वाले डेटा का जोड़ चाहते हैं, तब SUBTOTAL काम आता है।

Syntax:

=SUBTOTAL(function_num, range)

SUM के लिए function_num = 9

उदाहरण:

=SUBTOTAL(9, A1:A10)

अगर कुछ रो hidden हैं, तो यह सिर्फ visible डेटा जोड़ेगा।

---

9. AGGREGATE – Advanced SUM Function

यह SUBTOTAL का advanced version है।

Syntax:

=AGGREGATE(function_num, options, array)

SUM के लिए:

=AGGREGATE(9,6,A1:A10)

• 9 = SUM

• 6 = Errors ignore करेगा

अगर आपके डेटा में #DIV/0! जैसी errors हैं, तो यह उन्हें ignore करके सही जोड़ देगा।

---

10. SUMPRODUCT – Multiply + Sum एक साथ

अगर आपको multiplication के बाद जोड़ करना है:

उदाहरण:

Qty	Price
2	100
3	150

Total Amount निकालने के लिए:

=SUMPRODUCT(A2:A3,B2:B3)

Calculation:
(2×100) + (3×150) = 200 + 450 = 650

यह बिज़नेस में बहुत उपयोगी फ़ॉर्मूला है।

---

11. Conditional SUM with Dates

अगर आपको किसी खास महीने का डेटा जोड़ना है:

=SUMIFS(B2:B10, A2:A10, ">=01-01-2025", A2:A10, "<=31-01-2025")

यह जनवरी 2025 का टोटल देगा।

---

Excel SUM Formula – Real Life Use Cases

✔ दुकान की Daily Sales जोड़ना

✔ Student Marks का Total निकालना

✔ Monthly Expense Report बनाना

✔ Employee Salary Total निकालना

✔ Stock Inventory Value निकालना

---

SUM और SUMIF में अंतर

SUM	SUMIF
Simple जोड़	शर्त के साथ जोड़
Condition नहीं	Condition जरूरी
Basic Use	Advanced Use

---

Professional Tips

✔ हमेशा Range सही चुनें
✔ Error आने पर AGGREGATE इस्तेमाल करें
✔ Filter लगे हो तो SUBTOTAL इस्तेमाल करें
✔ Multiple condition के लिए SUMIFS ही सही है
✔ Large data के लिए Manual + Method ना करें

---

Conclusion

Excel में SUM सिर्फ एक साधारण जोड़ नहीं है, बल्कि यह डेटा एनालिसिस का सबसे बुनियादी और शक्तिशाली टूल है।

अगर आप सिर्फ =SUM() जानते हैं तो भी ठीक है, लेकिन अगर आप SUMIF, SUMIFS, SUBTOTAL, AGGREGATE, SUMPRODUCT जैसे फ़ॉर्मूला सीख लेते हैं तो आप एक Advanced Excel User बन सकते हैं।

Excel सीखने की शुरुआत हमेशा SUM से होती है — और Mastery भी यहीं से शुरू होती है।

read more →

 

ADVANCED EXCEL – COMPLETE PROFESSIONAL GUIDE (ENGLISH VERSION)

1. Introduction

In the modern digital economy, data has become the backbone of every organization. Businesses rely heavily on accurate data to make strategic decisions, forecast growth, manage finances, and analyze performance. Microsoft Excel remains one of the most powerful and widely used tools for handling business data.

However, in 2026, basic Excel skills are no longer sufficient. Companies now expect professionals to possess Advanced Excel skills that go beyond simple calculations and formatting. Advanced Excel allows professionals to analyze large datasets, automate repetitive tasks, and create intelligent dashboards for better decision-making.

As industries move toward automation and data intelligence, Advanced Excel has become one of the most demanded professional skills globally.

---

2. What is Advanced Excel?

Advanced Excel refers to the use of complex formulas, automation tools, and advanced data analysis features within Microsoft Excel.

Basic Excel includes:

I. Simple arithmetic calculations
II. Basic formatting
III. Creating simple charts
IV. Data entry

Advanced Excel includes:

I. VLOOKUP and XLOOKUP
II. INDEX and MATCH
III. Pivot Tables and Pivot Charts
IV. Conditional Formatting
V. Data Validation
VI. Dashboard Creation
VII. Power Query
VIII. Power Pivot
IX. VBA Macros
X. What-If Analysis

The primary goal of Advanced Excel is to convert raw data into meaningful insights.

---

3. Why Advanced Excel is Trending in 2026

The demand for Advanced Excel has significantly increased due to the following reasons:

I. Rise of data-driven organizations
II. Expansion of startups and digital businesses
III. Increasing need for automation
IV. Remote working and online reporting systems
V. Growth of Business Intelligence and Analytics
VI. Integration with Artificial Intelligence tools

Organizations prefer professionals who can automate reports and minimize human error.

---

4. Core Features of Advanced Excel

I. Pivot Tables

Pivot Tables summarize large datasets quickly and efficiently. They are essential for analyzing sales, financial records, inventory, and employee performance.

II. Lookup Functions

VLOOKUP and XLOOKUP help match data between multiple sheets and tables. These are crucial in finance, HR, and inventory departments.

III. INDEX and MATCH

This combination provides more flexibility and accuracy compared to VLOOKUP.

IV. Conditional Formatting

It highlights important data visually.

I. Low performance in red
II. High profit in green
III. Overdue payments highlighted automatically

V. Data Validation

Ensures accurate data entry.

I. Drop-down lists
II. Number limits
III. Date restrictions

VI. Dashboard Creation

Dashboards visually represent key business metrics.

I. KPI tracking
II. Trend analysis
III. Graphical comparisons
IV. Monthly performance reports

Professional dashboards improve management decision-making.

---

5. Role of Automation in Advanced Excel

Automation increases efficiency and reduces workload.

I. Automatic monthly sales reports
II. Salary sheet generation
III. Attendance management
IV. Expense tracking

VBA Macros are widely used for automating repetitive tasks.

Automation reduces human errors and improves productivity.

---

6. Advanced Excel and Business Intelligence

Excel is increasingly used as a Business Intelligence tool.

I. Power Query for importing data
II. Power Pivot for data modeling
III. Interactive dashboards
IV. Trend forecasting
V. Financial analysis

Excel bridges the gap between raw data and strategic planning.

---

7. Career Opportunities After Learning Advanced Excel

Advanced Excel opens multiple career paths:

I. Data Analyst
II. MIS Executive
III. Financial Analyst
IV. Business Analyst
V. Accounts Executive
VI. Reporting Specialist
VII. Operations Analyst
VIII. HR Analyst

Professionals with strong Excel skills often receive faster promotions and better salary packages.

---

8. Important Formulas to Master

I. IF Function
II. VLOOKUP
III. XLOOKUP
IV. INDEX + MATCH
V. SUMIF and COUNTIF
VI. CONCAT
VII. LEFT, RIGHT, MID
VIII. PMT
IX. IFERROR
X. TEXT Function

Mastering these formulas enhances analytical capabilities.

---

9. Benefits of Learning Advanced Excel

I. Higher salary potential
II. Increased job security
III. Better productivity
IV. Promotion opportunities
V. Freelancing possibilities
VI. Strong professional reputation

Advanced Excel professionals are valuable assets to organizations.

---

10. How to Learn Advanced Excel

I. Practice daily
II. Work on real datasets
III. Build dashboards
IV. Learn shortcut keys
V. Study automation techniques
VI. Complete real-world projects

Consistency and hands-on practice are key to mastery.

---

11. Future Scope of Advanced Excel

Despite technological advancements, Excel remains relevant.

I. Corporate sector
II. Banking and finance
III. E-commerce
IV. Manufacturing
V. Healthcare
VI. Education
VII. Government sector

Data management will continue to require Excel expertise.

---

12. Conclusion

Advanced Excel is one of the most essential professional skills in 2026. It enhances career growth, improves decision-making capabilities, and increases earning potential.

Professionals who master Advanced Excel gain a competitive advantage in the job market.

---

ADVANCED EXCEL – संपूर्ण प्रोफेशनल गाइड (HINDI VERSION)

1. परिचय

आज के डिजिटल युग में Data किसी भी संगठन की रीढ़ बन चुका है। हर कंपनी अपने निर्णय Data Analysis के आधार पर लेती है। Microsoft Excel लंबे समय से Business Data Management का सबसे लोकप्रिय Tool रहा है।

लेकिन 2026 में केवल Basic Excel जानना पर्याप्त नहीं है। कंपनियाँ ऐसे Professionals चाहती हैं जो Advanced Excel में कुशल हों और बड़े Data को Analyze कर सकें।

---

2. Advanced Excel क्या है?

Advanced Excel, Microsoft Excel का उन्नत स्तर है जिसमें Complex Formulas, Automation Tools और Data Analysis Techniques का उपयोग किया जाता है।

Basic Excel में शामिल है:

I. सामान्य गणना
II. साधारण Formatting
III. Basic Chart
IV. Data Entry

Advanced Excel में शामिल है:

I. VLOOKUP और XLOOKUP
II. INDEX और MATCH
III. Pivot Table
IV. Conditional Formatting
V. Data Validation
VI. Dashboard Creation
VII. Power Query
VIII. Power Pivot
IX. VBA Macros
X. What-If Analysis

इसका मुख्य उद्देश्य Raw Data को Useful Information में बदलना है।

---

3. 2026 में Advanced Excel क्यों Trending है?

I. Data Driven कंपनियों की वृद्धि
II. Startup और Online Business का विस्तार
III. Automation की बढ़ती मांग
IV. Work From Home Reporting
V. Business Intelligence का विकास
VI. AI Integration

कंपनियाँ Automated और Accurate Reporting चाहती हैं।

---

4. Advanced Excel के मुख्य Features

I. Pivot Table

बड़े Data को Summary में बदलने का Powerful Tool है।

II. Lookup Functions

दो Tables के Data को मिलाने में सहायक।

III. INDEX + MATCH

Flexible और Advanced Searching Method।

IV. Conditional Formatting

I. कम Performance को Highlight
II. अधिक Profit को Green
III. Overdue Payment Alert

V. Data Validation

I. Drop Down List
II. Number Restriction
III. Date Control

VI. Dashboard

I. KPI Tracking
II. Graphical Report
III. Trend Analysis
IV. Performance Monitoring

---

5. Automation की भूमिका

I. Monthly Sales Report Automatic
II. Salary Sheet Generation
III. Attendance Management
IV. Expense Tracking

VBA Macros से Repetitive Work Automatic हो जाता है।

---

6. Career Opportunities

I. Data Analyst
II. MIS Executive
III. Financial Analyst
IV. Accounts Executive
V. Business Analyst
VI. HR Analyst
VII. Reporting Specialist

Advanced Excel Career Growth में महत्वपूर्ण भूमिका निभाता है।

---

7. महत्वपूर्ण Formulas

I. IF Function
II. VLOOKUP
III. XLOOKUP
IV. INDEX + MATCH
V. SUMIF
VI. COUNTIF
VII. PMT
VIII. IFERROR
IX. TEXT

---

8. Advanced Excel सीखने के फायदे

I. High Salary
II. Promotion
III. Job Security
IV. Freelancing Opportunity
V. Professional Growth
VI. Efficiency Improvement

---

9. Future Scope

I. Banking
II. Corporate Sector
III. Manufacturing
IV. E-commerce
V. Healthcare
VI. Education
VII. Government

Excel की Demand भविष्य में भी बनी रहेगी।

Tally Prime Ledger Groups Complete Guide (Hindi & English)

---

10. निष्कर्ष

Advanced Excel 2026 की सबसे जरूरी Professional Skill है। यदि आप Career Growth, High Salary और Stable Future चाहते हैं तो Advanced Excel अवश्य सीखें।

1. Advanced Excel Complete Course 2026 | Excel for Beginners to Pro

2. Advanced Excel Full Tutorial in Hindi | Excel Dashboard, Formulas & Pivot Table

3. Learn Advanced Excel Step by Step | Excel Course for Students & Job

4. Advanced Excel Training 2026 | Pivot Table, VLOOKUP, Dashboard

5. Excel Advance Course in Hindi | Data Analysis & Automation

6. Advanced Excel for Beginners | Complete Excel Guide

7. Master Advanced Excel in 7 Days | Practical Excel Course

8. Advanced Excel Skills for Job | Excel Interview Preparation

9. Excel Advanced Level Training | Formula, Charts, Dashboard

10. Advanced Excel with Practical Examples | Full Course Hindi

read more →

Tally Prime Ledger Groups Complete Guide (Hindi & English)

Hindi: Tally Prime एक आधुनिक Accounting Software है जिसका उपयोग व्यापारिक लेन-देन को रिकॉर्ड करने और Financial Reports बनाने के लिए किया जाता है। 

  English: Tally Prime is a modern accounting software used to record business transactions and generate financial reports.

About Company Creation in Tally Prime

Hindi: Tally Prime में Company बनाने के लिए Gateway of Tally में जाकर Create Company विकल्प चुनें, सभी विवरण भरें और Ctrl + A दबाकर Save करें। 

  English: To create a company in Tally Prime, go to Gateway of Tally, select Create Company, fill in the required details, and press Ctrl + A to save.

Importance of Ledger Groups

Hindi: Ledger Groups अकाउंट्स को व्यवस्थित करने में मदद करते हैं जिससे Balance Sheet और Profit & Loss Report सही बनती है। 

  English: Ledger Groups help organize accounts properly, ensuring accurate Balance Sheet and Profit & Loss reports.

Focus Keywords

I. Tally Prime in Hindi II. Ledger Groups in Tally III. Tally Company Creation IV. Tally Accounting Course V. Tally Prime Notes PDF

FAQ (Frequently Asked Questions)

1. Tally Prime क्या है? / What is Tally Prime?

Hindi: Tally Prime एक अकाउंटिंग सॉफ्टवेयर है जिसका उपयोग व्यापारिक हिसाब-किताब रखने के लिए किया जाता है। English: Tally Prime is an accounting software used to maintain business financial records.

2. Ledger क्या होता है? / What is a Ledger?

Hindi: Ledger एक अकाउंट होता है जिसमें किसी व्यक्ति या खर्च की एंट्री दर्ज की जाती है। 

  English: A ledger is an account where transactions related to a person, expense, or income are recorded.

3. Sundry Debtors क्या होते हैं? / Who are Sundry Debtors?

Hindi: वे ग्राहक जिनसे हमें पैसे लेने होते हैं। 

  English: Customers from whom the business has to receive money.

4. Sundry Creditors क्या होते हैं? / Who are Sundry Creditors?

Hindi: वे सप्लायर जिन्हें हमें भुगतान करना होता है। 

  English: Suppliers to whom the business has to make payment.

Conclusion

Hindi: यदि आप Tally Prime में Ledger Groups और Company Creation सही तरीके से समझ लेते हैं तो Accounting आसान हो जाती है।

  English: Once you understand ledger groups and company creation in Tally Prime, accounting becomes much easier and more accurate.

 

What is DCA and DCAA Course?

Tally Prime Ledger Groups Complete Guide

---

1. Bank Accounts

इस Group में सभी सामान्य बैंक खातों को शामिल किया जाता है (Loan Account को छोड़कर)।

उदाहरण:

I. IDBI Bank A/c
II. HDFC Bank A/c
III. Bank of India A/c
IV. IDFC Bank A/c

---

2. Bank OCC A/c

Open Cash Credit (OCC) Loan Accounts इस Group में रखे जाते हैं।

उदाहरण:

I. IDBI Bank Loan A/c
II. HDFC Bank Loan A/c
III. Bank of India Loan A/c
IV. IDFC Bank Loan A/c

---

3. Bank OD A/c

Overdraft खातों को इस Group में शामिल किया जाता है।

उदाहरण:

I. IDBI Bank OD A/c
II. HDFC Bank OD A/c
III. Bank of India OD A/c
IV. IDFC Bank OD A/c

---

4. Branch / Divisions

कंपनी की विभिन्न शाखाओं से संबंधित खातों को इस Group में रखा जाता है। इसका Nature Asset होता है।

उदाहरण:

I. XYZ Textiles Burhanpur A/c
II. XYZ Textiles Indore A/c
III. XYZ Textiles Bhopal A/c
IV. XYZ Textiles Surat A/c

---

5. Capital Account

कंपनी के मालिक या पार्टनर के खातों को इस Group में शामिल किया जाता है।

उदाहरण:

I. Ram A/c
II. Partner Capital A/c

---

6. Cash-in-Hand

Cash और Petty Cash से संबंधित खाते इस Group में आते हैं।

उदाहरण:

I. Cash A/c
II. Petty Cash A/c

---

7. Current Assets

ऐसी संपत्तियाँ जिन्हें आसानी से Cash में बदला जा सकता है।

उदाहरण:

I. Prepaid Maintenance Expense
II. Prepaid Rent
III. Mutual Fund
IV. CGST Credit
V. SGST Credit
VI. IGST Credit
VII. Prepaid Insurance Charges

---

8. Current Liabilities

कम अवधि में भुगतान किए जाने वाले दायित्व।

उदाहरण:

I. Bill Payable
II. CGST Payable
III. SGST Payable
IV. IGST Payable

---

9. Deposits (Asset)

Security या Fixed Deposits इस Group में आते हैं।

उदाहरण:

I. Security Deposit
II. Office Rent Deposit
III. Electricity Deposit

---

10. Direct Expenses

उत्पादन या खरीद से सीधे जुड़े खर्च।

उदाहरण:

I. Freight Expenses
II. Wages
III. Hammali Charges
IV. Transport Expenses
V. Weaving Charges

---

11. Direct Incomes

Goods Sale से संबंधित आय।

उदाहरण:

I. Freight Charges Income
II. Transport Charges Income
III. Service Income

---

12. Duties & Taxes

सभी प्रकार के टैक्स से संबंधित खाते।

उदाहरण:

I. Input CGST
II. Input SGST
III. Output CGST
IV. Output SGST
V. TDS Payable
VI. Service Tax Payable

---

13. Expenses (Direct)

उत्पादन से संबंधित प्रत्यक्ष खर्च।

उदाहरण:

I. Freight of Production
II. Carriage Expenses
III. Power Expenses

---

14. Expenses (Indirect)

अप्रत्यक्ष खर्च जो उत्पादन से सीधे जुड़े नहीं होते।

उदाहरण:

I. Salary
II. Audit Fees
III. Telephone Charges
IV. Bank Charges
V. Depreciation
VI. Legal Charges

---

15. Fixed Assets

व्यवसाय की स्थायी संपत्तियाँ।

उदाहरण:

I. Land
II. Computer
III. Printer
IV. Bike
V. Laptop

---

16. Income (Direct)

Goods Sale से संबंधित आय।

उदाहरण:

I. Freight Charges Income
II. Transport Charges Income

---

17. Income (Indirect)

Goods Sale से संबंधित न होने वाली आय।

उदाहरण:

I. Interest Received
II. Discount Received

---

18. Indirect Expenses

अप्रत्यक्ष खर्च।

उदाहरण:

I. Fuel Expenses
II. Professional Charges
III. Postage & Courier Expenses
IV. Penalty

---

19. Indirect Incomes

अप्रत्यक्ष आय।

उदाहरण:

I. Interest Income
II. Discount Income

---

20. Investments

लंबी अवधि के निवेश।

उदाहरण:

I. Investment in Shares
II. Mutual Fund
III. Long Term Investment

---

21. Loans & Advances (Asset)

दूसरों को दिया गया Loan या Advance।

उदाहरण:

I. Loan to Friends
II. Advance to Supplier

---

22. Loans (Liability)

दूसरों से लिया गया Loan।

उदाहरण:

I. Loan from Outside Party
II. Loan from Relative

---

23. Provisions

भविष्य में भुगतान किए जाने वाले दायित्व।

उदाहरण:

I. Audit Fees Payable
II. TDS Payable

---

24. Purchase Accounts

Goods Purchase और Purchase Return के खाते।

उदाहरण:

I. Purchase Local
II. Purchase Interstate
III. Purchase Return
IV. Purchase Nil Rated

---

25. Reserves & Surplus

आरक्षित निधि और अधिशेष से संबंधित खाते।

उदाहरण:

I. General Reserve
II. Capital Reserve

---

26. Sales Accounts

Goods Sale और Sales Return के खाते।

उदाहरण:

I. Sales Local
II. Sales Interstate
III. Sales Return
IV. Sale to Consumer

---

27. Secured Loans

Security के बदले लिया गया Loan।

उदाहरण:

I. Gold Loan
II. Car Finance Loan
III. Bajaj Finance Loan

---

28. Stock-in-Hand

Stock से संबंधित खाते।

उदाहरण:

I. Opening Stock
II. Closing Stock

---

29. Sundry Creditors

जिनसे उधार माल खरीदा जाता है।

उदाहरण:

I. ABC Traders
II. XYZ Suppliers

---

30. Sundry Debtors

जिन्हें उधार माल बेचा जाता है।

उदाहरण:

I. Ram Traders
II. Shyam Enterprises

---

31. Suspense A/c

अज्ञात Payment या Receipt के लिए।

उदाहरण:

I. Party Suspense A/c

---

32. Unsecured Loans

Friends या Relatives से लिया गया Loan।

उदाहरण:

I. Loan from Friend
II. Loan from Relative

---

निष्कर्ष

Tally Prime में Ledger बनाते समय उसका सही Group चुनना अत्यंत आवश्यक है।
सही Group चयन से Balance Sheet, Profit & Loss Report और सभी Financial Reports सही बनती हैं।

Tally Me Kya Sikhaya Jata Hai

read more →