Report Period & Configuration
Set Dates Quickly
- F2 — period (e.g., 01-Apr-2025 to 31-Mar-2026).
- F6 — Monthly or Quarterly view.
- Alt + F1 — Detail/Condensed toggle.
Comparison & Previous Year
- Enable Comparative in report configurations.
- Add Previous Period column (e.g., FY 2024–25 vs 2025–26).
Balance Sheet Position
How to View
- Display → Financial Statements → Balance Sheet.
- Choose Schedule/Sub-group detail level as needed.
- Drill down into any figure to see group/ledger/voucher level.
What to Check
- Balance Sheet tallies (Assets = Liabilities + Capital).
- Capital reconciliation with current year profit from P&L.
- Unadjusted duties & taxes and bank reconciliation differences.
| Area | Typical Issues | Fix |
|---|---|---|
| Bank Accounts | Unreconciled items | Run Bank Reconciliation and post charges/interest |
| Duties & Taxes | Old GST balances | Pass adjustment/RCM entries; verify GSTR-3B |
| Loans & Advances | Wrong grouping | Move ledgers to correct groups |
Profit & Loss Account Performance
How to View
- Display → Financial Statements → Profit & Loss A/c.
- Switch to Vertical or Horizontal format (as preferred).
- Use F6 to see monthly/quarterly trends.
What to Check
- Sales vs Purchases (gross margin), freight inward/outward classification.
- Indirect expenses (rent, salaries, bank charges) under correct groups.
- Non-operating items and one-offs separated for clarity.
| KPI | How to Read | Where to Fix |
|---|---|---|
| Gross Profit % | (Sales − COGS) / Sales | Stock items, purchase/sales classification |
| Operating Margin | (GP − Indirect Exp.) / Sales | Expense ledgers grouping, accruals |
| Other Income % | Other income / Sales | Ensure “Indirect Incomes” grouping |
Trial Balance Control
How to View
- Display → Financial Statements → Trial Balance.
- Choose Group-wise or Ledger-wise view.
- Enable Opening and Net Change columns.
What to Check
- TB must tally (Dr = Cr).
- Large suspense/round-off balances indicate posting issues.
- Old opening balances require migration entries.
| Filter | Use Case | Benefit |
|---|---|---|
| Only Ledgers with Opening Balance | Year-begin review | Find carry-forward mismatches |
| Only Ledgers with Transactions | Monthly close | Focus on active accounts |
| Variance (This FY vs Last FY) | Audit checks | Highlights abnormal movements |
Drill-Down, Print & Export
- Drill down any figure to see Group → Ledger → Voucher levels.
- Press Alt + P to Print/Email (choose vertical/horizontal, show schedules, notes).
- Press Alt + E to Export (PDF/Excel/JSON); set filename & path.
- Add your logo and address in company features to brand reports.
Lock periods after finalization to prevent accidental edits: use Security Control & user roles.
Troubleshooting (Common Errors & Fixes)
| Issue | Cause | Quick Fix |
|---|---|---|
| Balance Sheet doesn’t tally | Unposted/duplicated entries; wrong grouping | Run Trial Balance; fix duplicates; correct ledger groups |
| P&L looks inflated | Capital/loans posted to income; inventory not used | Reclassify ledgers; use stock items for COGS |
| GST ledgers appearing in assets | Wrong ledger type/group | Use Duties & Taxes with type = GST (Input/Output) |
| Mismatched opening balances | Carry-forward not updated | Pass opening JV on books begin date; verify against last FY |
| Report blank for period | Wrong date range | Press F2 and set correct period |
Best Practices
- Finalize Bank Reconciliation and GST before generating final reports.
- Use bill-wise tracking for debtors/creditors to keep receivables/payables accurate.
- Maintain separate Round Off ledger to avoid small variances in P&L/BS.
- Run Variance and Exception reports monthly for early issue detection.
- Back up data and keep a close checklist for month-end/quarter-end.