CA Reports & Financial Statements
"My accountant speaks a language I don't." This is where MGH Books translates your everyday entries into the exact statements and registers a Chartered Accountant expects — Profit & Loss, Balance Sheet, Trial Balance, Cash Flow, and 50+ statutory registers. Nothing is typed twice: every report is built live from the invoices, bills, expenses and stock you've already recorded, ready to view, print as PDF, or export to Excel for your CA.
Read this first — you don't "make" these reports
- They build themselves. You record day-to-day business; the reports compute from that data automatically — there's no manual ledger-writing.
- They follow Indian standards where it matters: the Balance Sheet uses a Schedule III layout, Cash Flow follows AS-3, and closing stock is valued on a weighted-average (WAC / AS-2) basis.
- Everything exports. Print any report to PDF, and export most to Excel/CSV to hand to your CA.
- Pick the financial year and the reports recalculate for that year.
- It prepares & exports filing-ready data (e.g. GSTR-1, TDS summaries). It does not auto-file returns on the GST/Income-Tax portal.
- Figures are only as accurate as your entries. Missing invoices/bills/opening balances will show.
- Depreciation is computed from each asset's cost, method (SLM/WDV), salvage and life. Where a manual figure isn't stored, it's an estimate.
- The Balance Sheet uses a labelled "balancing figure" for capital when opening balances aren't entered — so enter opening balances for a precise statement.
Before you start
For complete reports, make sure the underlying data exists (each links to its guide):
- Company & financial year set (name, GSTIN, signatory) — used in every header.
- Sales invoices recorded — drives revenue, output GST, debtors.
- Purchase bills & expenses — drives purchases, ITC, creditors, costs.
- Items with cost & HSN — for stock valuation and HSN summary.
- Fixed assets (optional) — for the depreciation schedule.
Step 1 — Open the Reports screen
After you log in, open the 📊 Reports section. The screen is titled "Reports & Analysis".
help-shots/ca-01-open-reports.pngStep 2 — Choose a report from the tab bar
| Tab | What you get |
|---|---|
| P&L | Profit & Loss statement for the year |
| 📊 Trial Balance | Full trial balance — 7 tabs |
| 🏦 Balance Sheet | Schedule III balance sheet + analysis |
| 💧 Cash Flow | AS-3 cash flow statement |
| 💰 Collections | Receivables & outstanding view |
| GST Compliance | GST summary & filing-ready figures |
| Day Book | Every transaction in date order |
| Year-End | Year-end closing report |
| Group | Consolidated multi-company view |
| 📋 CA Reports | Library of 50+ statutory registers |
help-shots/ca-02-tabs.pngStep 3 — The core statements
Profit & Loss Shuruat · Free
Income, direct costs, gross profit, expenses and net profit. Advanced tabs (GST Analytics, Business Intelligence, Comparative) add depth on higher plans.
help-shots/ca-03-pl.pngBalance Sheet — Schedule III
A Schedule III balance sheet with a fixed-asset schedule (gross block, depreciation, net block), debtor/creditor aging (0-30 / 31-60 / 61-90 / 90+), liquidity ratios and a health score. Sub-tabs:
| Sub-tab | Shows | Plan |
|---|---|---|
| Summary / Assets / Liabilities | The core statement | All plans |
| Working Capital · GST Position · Comparative | Deeper views | Pragati |
| Analytics & Health Score · Audit & CA | Ratios, score, audit | Samridhi |
help-shots/ca-04-balancesheet.pngCash Flow — AS-3 & Trial Balance (7 tabs)
Cash Flow follows AS-3 (operating/investing/financing); GST-impact, working-capital and audit views unlock higher up. Trial Balance lists every account's debit/credit grouped into Income, Purchases, Expenses, Assets and Equity, with a labelled balancing figure where opening balances aren't entered, across 7 tabs.
help-shots/ca-06-cashflow.pngStep 4 — The CA Reports library (50+ registers)
The 📋 CA Reports tab is a full library. Pick the Financial Year (it auto-selects the year with the most transactions), then a category — 📊 Sales · 🛒 Purchases · 📦 Inventory · 💸 Expenses · 📜 GST · 📒 Accounts — and tap any tile to open that report.
help-shots/ca-09-careports-home.png| Category | Reports included |
|---|---|
| 📊 Sales | Debtors Aging · Outstanding Receivables · Party-wise Sales · Sales Register · Item-wise Sales · Party Ledger · Bill-wise Profit · Credit Note Register · Debtor Confirmation Letter · Party-wise P&L · Salesman Commission |
| 🛒 Purchases | Creditors Aging · Outstanding Payables · Purchase Register · PO Tracking · Vendor Confirmation · Debit Note Register · E-Way Bill Register |
| 📦 Inventory | Stock Summary · Stock Aging · ABC Analysis · HSN/SAC Summary · Closing Stock Certificate (WAC/AS-2) · Cost Centre / Category |
| 💸 Expenses | Expense Register · Cash Book · Day Book · Receipts & Payments · Provisions & Accruals (AS-29) · Loan & Borrowings |
| 📜 GST | GSTR-1 Summary · TDS Summary · GSTR-9C Reconciliation · Form 168 (ex-26AS) Reconciliation · Professional Tax Register |
| 📒 Accounts | Journal Register · General Ledger · Ratio Analysis · Movement of Equity · Cash Book · Bank Book · Capital/Partner Account · Trading Account · Manufacturing Account · Profit Appropriation · Net Worth Certificate · All Parties · Related Party Transactions · Investment Register |
help-shots/ca-11-register-open.pngStep 5 — Export & print
- ⬇ Excel / CSV — downloads the data as a spreadsheet for your CA.
- 🖨 PDF / Print — opens the print dialog; choose "Save as PDF" for a clean PDF. The layout is print-optimised.
In the print dialog set margins to Default and enable Background graphics so the gold header and table shading appear.
Which plan unlocks what
| Report / feature | Available from |
|---|---|
| Profit & Loss · Stock Summary | Shuruat (Free) |
| Balance Sheet / Cash Flow / Trial Balance — core statement | All plans |
| P&L Comparative · BS Working Capital/GST/Comparative · TB Receivables/Comparative | Pragati |
| Day Book · General Ledger · Sales/Purchase Registers · Party Ledger · Stock Aging · ABC · Bill-wise Profit · Profit Appropriation · BS/TB Audit · CF GST Impact | Samridhi |
| Ratio Analysis · Provisions & Accruals · Professional Tax Register · CF Analytics/Working Capital/Audit · advanced CA pack | Unnati |
Real situations
📖 Month-end pack for the CA
Pooja opens Reports, exports the P&L, Balance Sheet and Trial Balance to Excel and emails them to her CA — no spreadsheets built by hand.
📖 Chasing the oldest dues
She opens Debtors Aging, sorts by the 90+ bucket, and prioritises those calls — the riskiest money first.
📖 A stock certificate for the bank
Her bank wants a closing-stock statement. She opens the Closing Stock Certificate (WAC/AS-2) and prints it to PDF — CA-certifiable.
Words you'll see, in plain language
| Term | What it means |
|---|---|
| Profit & Loss | Income minus expenses over a period — are you making money? |
| Balance Sheet | What you own vs owe on a given date. |
| Trial Balance | A list of all account balances; debits must equal credits. |
| Cash Flow (AS-3) | How cash moved through operating, investing and financing. |
| Schedule III | The statutory format for a company balance sheet. |
| WAC / AS-2 | Weighted-average cost basis for valuing closing stock. |
| Depreciation (SLM/WDV) | Spreading an asset's cost over its life (straight-line / written-down-value). |
| Debtor / Creditor | Someone who owes you / someone you owe. |
| Balancing figure | A labelled placeholder for capital when opening balances aren't entered. |
Troubleshooting
| What you see | Why | What to do |
|---|---|---|
| Balance Sheet shows a "balancing figure" | Opening capital/balances not entered | Enter opening balances in Settings to replace it |
| Figures look low/incomplete | Missing invoices/bills, or wrong FY selected | Check the financial year; record missing entries |
| A report or tab is locked | It needs a higher plan | See the plan table above; upgrade if needed |
| PDF has no colours/shading | Background graphics off in print dialog | Enable "Background graphics" and reprint |
| Depreciation looks approximate | No stored depreciation; it's computed | Check asset cost/method/life on the asset record |
Best practices
- Enter opening balances once so the Balance Sheet and Trial Balance are precise.
- Keep purchases/ITC current so GST and profit are right.
- Export to Excel for your CA; print to PDF for banks/records.
- Use Debtors/Creditors Aging monthly to manage cash.
FAQ
Do I have to enter anything to get these reports?
No separate entry — they're built from your invoices, bills and expenses. Enter opening balances once for the most precise statements.
Can my CA use these directly?
Yes — they follow Schedule III / AS-3 / AS-2 and export to Excel/CSV and PDF. Many CAs work straight from the Trial Balance, Balance Sheet and register library.
Why does my Balance Sheet show a "balancing figure"?
Opening capital/balances haven't been entered, so a labelled figure keeps it balanced. Enter opening balances to replace it.
Does it file my GST or income tax?
No — it prepares filing-ready data (GSTR-1, TDS, 9C, Form 168 (ex-26AS) recon) that you/your CA file on the portal.
- Sales → revenue, output GST, debtors, sales registers.
- Purchases & Expenses → purchases, ITC, creditors, expense registers.
- Items & Inventory → closing stock (WAC/AS-2), HSN, stock aging.
- Parties → aging, ledgers, confirmation letters.
- Settings → financial year, name, GSTIN, signatory on every header.
- GST & Tax → GSTR-1/TDS/Form 168 (ex-26AS) figures feed your filing — see GST & e-Invoice.
📸 Screenshot capture checklist
Capture each from the live app and drop the PNG into help-shots/ with the exact filename — it appears automatically.
| # | Screen to capture | Save as |
|---|---|---|
| CA-01 | Reports & Analysis screen | help-shots/ca-01-open-reports.png |
| CA-02 | The report tab bar | help-shots/ca-02-tabs.png |
| CA-03 | Profit & Loss statement | help-shots/ca-03-pl.png |
| CA-04 | Balance Sheet (Schedule III) + sub-tabs | help-shots/ca-04-balancesheet.png |
| CA-05 | Cash Flow (AS-3) / Trial Balance | help-shots/ca-06-cashflow.png |
| CA-06 | CA Reports tab — FY + 6 categories | help-shots/ca-09-careports-home.png |
| CA-07 | An opened register with Print/Export | help-shots/ca-11-register-open.png |
Tip: capture on a wide screen at ~1280px; blur real customer names/GSTINs before publishing.