Docs
ERP Crystal
MFG
Finance
Reports
Financial Ledger & Final Accounts Report

Financial Ledger & Final Accounts Report

Financial Ledger & Final Accounts - User Guide

1. Introduction 📊🏛️

The Financial Report module is the central nervous system of ERPCrystal/MFG. It synthesizes every transaction from every module—Sales, Purchase, Payroll, and Production—into a unified accounting view. Whether you are generating a detailed Customer Ledger for a payment dispute or a full Trial Balance for statutory auditors, this module provides the definitive “Source of Truth” for your organization’s financial health.

ℹ️

Purpose of this Report:

  • General Ledger Auditing: Drill down into the specific transactions that make up any expense or asset.
  • Trial Balance Monitoring: Review the net balances of all accounts to ensure the books are in balance.
  • Party Reconciliation: Provide customers and vendors with a detailed statement of account.
  • Statutory Verification: Generate a formal “Confirmation of Balance” letter for external audit requirements.

This report is essential for Chief Financial Officers (CFOs), Audit Managers, and Staff Accountants.

2. Report Modes & Capabilities 🚀

A. The Ledger (Transaction Detail)

  • Deep Drill-Down: Categorized into General Ledger (Internal), Customer Control (A/R), and Vendor Control (A/P).
  • Automatic Account Splitting: While you enter a single “Invoice Value,” the report engine automatically splits it into Base Value, Taxes (CGST/SGST/IGST), Freight, and Discounts for precise P&L reporting.
  • Contextual Notes: Automatically pulls in internal comments, cheque details, and reference document numbers for every entry.

B. Final Accounts (Trial Balance)

  • Performance Summary: Shows the Opening Balance, Debit/Credit movements, and Closing Balance for a specified period.
  • Grouping Options:
    • BSPL Grouping: Standard accounting view (Balance Sheet & Profit/Loss).
    • MIS Grouping: Management view tailored for internal decision-making.

C. Confirmation of Balances

  • External Audit Tool: Generates a professional PDF letter for a specific party, asking them to verify and sign off on their outstanding balance as of a specific date.

3. High-Performance Features 🛠️

  • Background Queueing: If you request a report covering more than 12 months (e.g., a 3-year historical analysis), the system will automatically process it in the background. You’ll receive an email notification once it’s ready, ensuring the software remains responsive for other users.
  • MIS Exclusions: Optional filter to exclude internal “Work-in-Progress” or “Draft” Journal Vouchers from your final statutory reports.
  • Unit & Division Filtering: Perfect for conglomerates; run reports for a specific manufacturing unit or a specific business division without mixing data.

4. Understanding Data Columns 📊

  • Doc Type: Identifies the source (I=Invoice, B=Bill, V=Voucher, J=Journal).
  • Debit / Credit: Physical movement of funds.
  • Balance: Running total for the account.
  • Ref No / Date: The original document reference from the source module.
  • MIS Exclusion Flag: Indicates if the entry is purely for internal management accounting.

5. Source Transactions 🔄

The reporting engine consolidates data from:

  1. Opening Balances: The starting point for the financial year.
  2. Trade Documents: Invoices, Purchase Bills, and Debit/Credit Notes.
  3. Financial Documents: Bank/Cash Vouchers and Journal Vouchers.
  4. Masters: Charts of Accounts, Party Masters, and Unit/Division definitions.

6. Best Practices / Tips 💡

  • The “Visual Match-Off” Filter: When reconciling accounts with high transaction volumes, turn on the “Exclude Match-Off JV” filter. This removes internal “Settlement” entries and shows only the “Real” pending invoices and payments.
  • Trial Balance Hygiene: If your Trial Balance shows a discrepancy, the system will highlight the specific Journal Voucher numbers that are out of balance. Fix these first to ensure report integrity.
  • Direct Dashboard Sync: If you frequently monitor a specific cost center (e.g., “Factory Electricity”), mark it as “Show in Dashboard” to save time on future runs.
  • Multi-Year Audits: For long-duration audits (2-5 years), always use the Queueing feature. This ensures the Excel file is generated with 100% data fidelity without timing out your browser session.
Receivable / Payables (AR/AP) & Aging Report