No prior VBA knowledge is required. The macros module starts from recording basics. You will learn enough to automate repetitive tasks without being a programmer.

VLOOKUP finds a single matching value in a table. Power Query is for importing, cleaning and transforming large datasets from multiple sources — it is far more powerful for data preparation.

Dynamic Array functions (FILTER, SORT, UNIQUE, SEQUENCE) are available in Excel 365 and Excel 2021. Older versions use legacy array formulas with Ctrl+Shift+Enter.

Extremely useful. CAs use advanced Excel for financial modelling, audit data analysis, reconciliations, MIS dashboards and handling large data exports from Tally or Zoho Books.

Move to our Financial Modeling Basics and Dashboard Creation courses — they apply advanced Excel skills directly to finance and business reporting scenarios.

No prior accounting or finance knowledge is required. This course starts from absolute basics and builds up systematically. A basic understanding of arithmetic is all you need.

Cash basis records income when cash is received and expenses when cash is paid. Accrual basis records income when earned and expenses when incurred, regardless of cash movement. Accrual basis is mandatory for most businesses in India.

Start with Zoho Books Basics or Tally Prime Basics — both are practical applications of the accounting concepts taught in this course. Knowing the theory first makes the software much easier to understand.

A Journal is the book of original entry where transactions are first recorded in chronological order. A Ledger is the book of secondary entry where transactions are classified by account (e.g., all Sales entries in the Sales ledger).

Yes. Even though accounting software handles debits and credits automatically, understanding the golden rules helps you catch errors, understand reports and set up your chart of accounts correctly.

Rule 11UA prescribes the valuation method for unquoted equity shares under the Income Tax Act. It applies when shares are issued to investors above fair market value (Angel Tax provision) or transferred. A registered valuer's report is required.

For IBBI-compliant valuation reports (mandatory for insolvency, M&A and regulated transactions), the valuer must be a Registered Valuer (RV) under IBBI. Our founder CA Karan Shah holds IBBI registration as a Registered Valuer.

Valuations are required for: fundraising (determining share issuance price), M&A (transaction pricing), ESOP grants (Rule 11UA), FEMA compliance (FDI/ODI), NCLT petitions, corporate restructuring and IBC insolvency proceedings.

Enterprise Value (EV) is the total value of the business including debt and excluding cash. Equity Value = Enterprise Value - Net Debt. When valuing for an equity investor, you always need the equity value, not just EV.

DCF is theoretically sound but highly sensitive to assumptions — small changes in WACC or growth rate significantly change the output. That is why valuers triangulate using multiple methods (DCF + CCA + Asset-based) and exercise professional judgment.

A business plan is a narrative document explaining the business model, market and strategy. CMA data is a structured financial document in a specific RBI-prescribed format that banks use to assess creditworthiness and set loan limits.

Banks typically require projections for 3-5 years for term loans and 1-2 years of projections for working capital facilities, along with 2-3 years of audited historical financials.

The Tandon Committee prescribed three methods for calculating working capital finance. Method II (most commonly used) permits bank finance up to 75% of the net working capital gap (Current Assets minus current liabilities other than bank finance).

Most banks require some operating history. However, government-backed schemes like CGTMSE or SIDBI loans, and MUDRA loans, may be available for new businesses. Projection-based CMA data is accepted for these schemes.

CMA data is typically prepared by a CA or a financial consultant with banking and credit knowledge. Banks often reject self-prepared CMA data that does not meet their internal standards. Our Corporate Finance team prepares CMA data regularly.

With all documents in order, a Pvt Ltd company can be incorporated in 10-15 working days through the MCA portal. Our team at KC Shah & Associates can complete the process end-to-end.

There is no minimum paid-up capital requirement for a Pvt Ltd company in India. You can start with ₹1. The authorised capital determines your registration and stamp duty fees.

A Director manages the company's day-to-day affairs and is appointed by shareholders. A Shareholder (Member) owns equity in the company. In small companies, the same person is often both.

Yes. A foreign national can be a shareholder and director in an Indian Pvt Ltd company. For FDI (Foreign Direct Investment), additional FEMA compliance and FC-GPR filing is required — our FEMA service covers this.

After incorporation: open a current bank account, apply for PAN and TAN, register for GST (if applicable), appoint an auditor within 30 days, file AOC-4 and MGT-7 annually and hold board meetings. Our ROC compliance service covers all of these.

No. This course teaches you to build fully interactive dashboards using Pivot Tables, slicers, named ranges and chart tricks — no VBA required.

Excel dashboards can pull data from Zoho Books exports, Tally reports, bank statements, CRM exports or any CSV file. Power Query (covered in our Advanced Excel course) is the best way to connect and refresh these sources.

For simple, shareable dashboards that anyone can open, Excel is often better — no software installation needed, works offline and is universally understood. Power BI is more powerful for large-scale, real-time data.

Yes. You can export the dashboard as a PDF for read-only sharing, or share via Microsoft 365/OneDrive so others can view it in the browser without installing Excel.

Use a maximum of 3 colours: one primary (your brand colour), one accent for highlights, and neutral greys for backgrounds and borders. Avoid rainbow charts — they reduce clarity.

You can use Microsoft Excel (paid, part of Microsoft 365) or the free web version at office.com. Google Sheets is also free and covers most beginner concepts taught in this course.

Absolutely. Excel is the most widely used tool in accounting and finance. This beginner course gives you the foundation for MIS reporting, GST working, TDS calculations and financial analysis.

Progress to our "XLOOKUP / VLOOKUP / HLOOKUP" course, then "Pivot Table Training", then "MIS Reporting in Excel" — that path covers what most finance professionals need day-to-day.

This course uses Excel 2019 / Microsoft 365. All formulas and features shown are available in Excel 2016 and later. Some newer functions like XLOOKUP require Excel 2019+.

Excel proficiency significantly improves your employability as an accountant. Combined with knowledge of Zoho Books or Tally, it makes you a strong candidate for accounting roles at SMEs.

Yes. A basic understanding of P&L, Balance Sheet and Cash Flow is essential. Complete our Basics of Accounting and MIS Reporting in Excel courses before starting this one.

You need proficiency in formulas, named ranges, IF/SUMIF, basic charts and understanding of cell references. Complete our Excel for Beginners and Advanced Excel courses first.

An MIS report shows historical performance. A financial model is forward-looking — it projects future P&L, cash flows and balance sheet based on business assumptions and scenarios.

Investment bankers, VCs, CFOs, startup founders (for fundraising), CAs (for valuation and CMA data), and management consultants. Any role involving business planning or investment decisions benefits from modeling skills.

This course gives you the foundation. For IBBI-compliant valuation reports, you need additional knowledge of valuation standards and methodologies covered in our Business Valuation Basics course.

Early-stage valuations are largely negotiated based on team quality, market size, traction and comparables. Common methods include Berkus Method, Scorecard Method and market comparables. Our Business Valuation Basics course and valuation service covers this.

Equity funding means giving investors a share of ownership in exchange for capital — no repayment obligation. Debt funding is a loan that must be repaid with interest, regardless of business performance.

A pitch deck, financial model/projections, cap table, company incorporation documents, IP assignments, key contracts, audited financials (if available) and a data room with all company documents.

Anti-dilution protection adjusts an investor's conversion price downward if future shares are issued at a lower valuation (a down-round). Broad-based weighted average anti-dilution is the most founder-friendly form.

It is not required for private fundraising. However, DPIIT recognition gives you Section 80-IAC tax benefits, exemption from Angel Tax (Section 56(2)(viib)), and access to government schemes — all of which make your startup more attractive to investors.

Most services attract 18% GST. Some services like healthcare and education are exempt, restaurants charge 5%, and financial services have specific rates. Always check the GST rate schedule for specific items.

Yes. Voluntary GST registration is allowed even below the threshold. It can be beneficial if you have B2B clients who need to claim ITC, or if you export services.

Businesses with annual turnover above ₹5 crore must generate e-invoices through the IRP (Invoice Registration Portal) for B2B and export invoices. The system generates an IRN and QR code that must appear on the invoice.

GSTR-1 contains detailed invoice-wise data of all outward supplies. GSTR-3B is a summary return showing consolidated tax liability and ITC. You must file GSTR-1 before GSTR-3B each month.

The composition scheme lets small businesses (turnover up to ₹1.5 crore for goods, ₹50 lakh for services) pay a flat GST rate (1-5%) instead of regular GST. Simpler compliance but you cannot collect GST from customers or claim ITC.

Yes. Tally Prime supports direct GST filing integration. You can generate the GSTR-1 JSON file from Tally and upload it to the GST portal, or use Tally's direct filing option.

GSTR-1 reports all outward sales invoices in detail. GSTR-3B is a summary return that reports net tax liability, ITC claimed and tax paid. GSTR-1 must be filed before GSTR-3B.

Tally has a specific Reverse Charge configuration. When you enable RCM on a ledger, Tally automatically records the GST payable by the recipient instead of the supplier.

You need to create a credit note to reverse the incorrect invoice and raise a fresh invoice with the correct rate. Tally makes this straightforward through the Credit Note voucher.

No. GST applies only to GST-registered goods and services. Exempt supplies, non-taxable items (like petrol) and certain agricultural goods are outside GST. This course covers which transactions are taxable.

Technically yes, but the MCA portal requires DSCs, legal documents (MOA/AOA) and compliance with company law. Mistakes can delay registration or create compliance issues. Using a CA like KC Shah & Associates saves time and ensures accuracy.

Government fees depend on authorised share capital — approximately ₹2,000—₹15,000 for stamp duty and filing fees for typical startup share capital levels. Professional fees are additional.

Authorised capital is the maximum share capital the company can issue (determines filing fees). Paid-up capital is the actual capital invested by shareholders. You can start with ₹1 paid-up capital.

Yes, you need a registered office address in India. This can be your home address initially. Proof of address (electricity bill) and a No Objection Certificate from the property owner are required.

That is perfectly fine. Multiple directors can share the same address for their personal address (as used in the DIN application). The registered office address is the company's address, which is separate.

Filing is not mandatory if income is below the basic exemption limit. However, it is advisable to file a Nil return — it serves as proof of income, helps get loans and visas, and enables carry forward of losses.

Gross Total Income is the sum of all income heads before Chapter VI-A deductions. Total Income is Gross Total Income minus allowable deductions (80C, 80D, etc.) — this is what tax is calculated on.

You can file a belated return up to 31st December of the assessment year with a late filing fee (₹1,000 if income is below ₹5 lakh, ₹5,000 otherwise). Interest under Section 234A also applies.

Salaried individuals and pensioners can switch between regimes every year. Self-employed individuals and those with business income can switch only once and cannot revert (except if they opt out of the new regime permanently).

Under the New Regime, if taxable income is = ₹12 lakh, the full income tax is rebated (up to ₹60,000). Under the Old Regime, if taxable income is = ₹5 lakh, tax up to ₹12,500 is rebated.

You should be comfortable with basic Excel (formulas, formatting, SUMIF) and have a basic understanding of accounting concepts. Complete our Excel for Beginners and Basics of Accounting courses first.

Most SMEs and even large companies still use Excel for MIS because of its flexibility. Even when using Zoho Books or Tally, the final MIS pack is often assembled and presented in Excel.

A P&L is a standard financial statement. An MIS report is a management-focused summary that may include the P&L plus KPIs, variance analysis, commentary and charts — designed for business decisions.

Yes. The templates built in this course are designed for real-world Indian SME use with INR formatting, GST-aware revenue lines and standard Indian financial reporting structure.

Virtual CFOs typically use Zoho Books (or Tally) for accounting data, Excel for MIS assembly and presentation, and tools like Zoho Analytics or Power BI for dashboards. This course covers the Excel layer.

Yes, once you configure the PF and ESI pay heads with the correct rates and link them to employees, Tally automatically calculates deductions when you process the payroll voucher.

Tally Prime generates the salary TDS data but Form 16 (Part A with TDS certificate) must be generated from the TRACES portal using TDS return data. Module 5 explains the complete process.

You can set the joining date in the employee master and Tally will pro-rate the salary for the number of days worked in that month automatically.

Yes, Tally Prime handles payroll for any number of employees. There is no employee limit in the software — performance depends on your hardware.

For cloud-based companies using Zoho Books, Zoho Payroll is better integrated. For businesses already on Tally with on-premise data, Tally payroll is the natural fit. Our Zoho Payroll Basics course covers the alternative.

No. Basic Excel knowledge (data entry, formatting, simple formulas) is sufficient. This course starts from creating a simple Pivot Table and builds up progressively.

Yes. Pivot Tables are ideal for analysing datasets with thousands of rows. They process data very quickly without needing complex formulas.

CAs and accountants use Pivot Tables to summarise ledger data, analyse GST sales by category, track vendor-wise expenses, and create monthly P&L summaries from raw transaction data.

A regular table displays raw data. A Pivot Table summarises that data dynamically — you can drag and drop fields to change the view instantly without writing any formulas.

Move on to the "Dashboard Creation in Excel" course to learn how to combine Pivot Tables with slicers and charts into interactive business dashboards.

Tally Prime is the successor to Tally ERP 9. It has a redesigned interface, improved navigation, a new "Go To" feature, better report viewing and enhanced GST filing capabilities. The core accounting logic is the same.

Tally Prime offers a free Education Mode that disables saving and printing but lets you practice all features. Download it from the Tally website to follow along with this course.

Yes. Tally has an enormous installed base in India — especially among manufacturing, trading and CA firms. Many employers still require Tally knowledge, making it a valuable skill.

A Receipt voucher records money coming IN to your business (from customers). A Payment voucher records money going OUT (to vendors, employees, expenses).

Take the "GST in Tally" and "TDS in Tally" courses to handle statutory compliance, and the "Payroll in Tally" course if you manage employee salaries.

Individuals are generally not required to deduct TDS unless they are subject to tax audit under Section 44AB, or make payments that attract TDS under Section 194IB (rent above ₹50,000/month), 194M or 194S.

TDS is deducted by the payer on behalf of the recipient and deposited to the government. Advance tax is paid by the taxpayer directly in four installments during the year based on estimated income.

Interest of 1.5% per month is levied for late deposit. Additionally, a penalty under Section 271C can be imposed equal to the TDS amount not deposited.

Form 16 is issued by employers to salaried employees for TDS on salary (Section 192). Form 16A is issued by companies and individuals for TDS deducted on non-salary payments like interest, professional fees and contract payments.

When filing your ITR, enter the TDS details from your Form 16/16A and 26AS. The TDS credit is automatically adjusted against your income tax liability and any excess is refunded.

For individual/HUF contractors: 1%. For other entities (company, firm): 2%. No TDS if the single payment is below ₹30,000 or aggregate in the year is below ₹1,00,000.

TDS under 194J applies when payment to a professional exceeds ₹30,000 per year. The rate is 10% (2% for technical services from FY 2020-21).

If a vendor provides a certificate under Section 197 from the IT department, you must deduct TDS at the lower rate specified in the certificate instead of the standard rate.

Yes. Tally Prime generates the TDS payment challan (ITNS 281) in the correct format for deposit at the bank or NSDL portal. This is covered in Module 4.

Interest at 1% per month for non-deduction and 1.5% per month for non-deposit. Additionally, the expense may be disallowed in your income tax filing under Section 40a(ia).