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 accounting hub of ERPCrystal/MFG. It synthesizes transactions across all operational modulesโ€”Sales, Purchases, Payments, Receipts, and Journalsโ€”into a unified general ledger. Whether generating a detailed customer ledger statement, printing a formal balance confirmation letter, or computing an audit-ready Trial Balance, this module provides the definitive source of truth for your financial position.

โ„น๏ธ

Purpose of this Report:

  • General Ledger Auditing: Inspect line-by-line debit and credit movements for any specific asset, liability, expense, or revenue ledger.
  • Trial Balance Monitoring: Review starting opening balances, period debit/credit movements, and closing balances across all accounts.
  • Party Reconciliation: Provide customers and vendors with detailed, audit-ready statements of accounts.
  • Statutory Verification: Generate formal “Confirmation of Balance” letters for external audit requirements.

This report is essential for Chief Financial Officers, Audit Managers, and Financial Accountants.


2. Report Modes & Generated Formats ๐Ÿš€

A. Ledger (ReportType = "A")

  • Format: Downloads directly as an Excel workbook (Ledger.xlsx).
  • Ledger Types: Filter by General Ledger (GL), Customer Control (CL), or Vendor Control (VL).
  • Filtering: Run for All Accounts, by Account Group, by a specific Account, or by an individual Customer/Vendor.
  • Contextual Details: Automatically pulls voucher narrations, cheque/UTR details, and reference document numbers.

B. Final Accounts / Trial Balance (ReportType = "B")

  • Format: Downloads as an Excel workbook (TrialBalance.xlsx).
  • Performance Summary: Shows Opening Balance, Debit Total, Credit Total, and Net Closing Balance.
  • Grouping Options:
    • BSPL Grouping: Standard statutory layout aligned with Balance Sheet and Profit & Loss groups.
    • MIS Grouping: Management view organized for internal cost and performance analysis.

C. Confirmation of Balances (ReportType = "C")

  • Format: Generates a professional, printable PDF document (ConfirmationOfBalance.pdf).
  • Target Scope: Restricted strictly to Customer Control (CL) and Vendor Control (VL) accounts (General Ledger is disabled for balance confirmation).
  • Audit Use: Formally requests the party to confirm and sign off on their closing balance as of a specified date.

3. Advanced Filtering & Output Controls ๐Ÿ› ๏ธ

  • Exclude MIS JV: Option to exclude internal management journals (JvType = 'M') so statutory financial reports reflect only audited accounting adjustments.
  • Exclude Visual Match-Off JV: Excludes technical settlement JVs (JvType = 'V'), presenting a clean view of trade invoices and actual bank payments without internal pairing noise.
  • Unit & Division Filtering: Generate isolated ledger statements for a specific manufacturing plant or division, or consolidate across the entire organization.
  • Show in Dashboard: Option to pin key summary metrics directly to the executive dashboard.

4. Strict Validations and Integrity Controls โš ๏ธ

To maintain absolute accounting integrity, the reporting engine performs comprehensive pre-generation validations:

  1. Unbalanced JV Discrepancy Abort: If any Journal Voucher in the active financial year has an unbalanced Debit vs. Credit difference, report generation is completely aborted with the error: "Report aborted as following JV(s) ... has discrepancy". The listed JVs must be corrected before the Trial Balance can be generated.
  2. Company Master Setup: The company’s Registered Office address must be configured in Company Master for report headers.
  3. Profit Account Mapping: For Final Accounts, the system verifies that the Profit for the Year account is properly linked in the Transaction Type Master.
  4. Clean Trade Notes: Final Accounts generation fails if any Debit or Credit Note exists with header records but missing line items.
  5. Date Constraints:
    • From Date cannot be earlier than the active Financial Year start date.
    • To Date cannot exceed the financial year end date (unless the calendar year extension parameter is active, in which case the span cannot exceed 12 months).
    • Future dates are strictly disallowed (To Date <= Today).
    • To Date cannot be earlier than From Date.

5. Source Transactions ๐Ÿ”„

The reporting engine consolidates data from:

  1. Opening Balances: Starting balances established at the beginning of the fiscal year.
  2. Trade Invoices & Bills: Sales Invoices, Purchase Bills, and Debit/Credit Notes.
  3. Bank & Cash Vouchers: All operational payment and receipt transactions.
  4. Journal Vouchers: Adjustments, accruals, and settlements.

6. Best Practices / Tips ๐Ÿ’ก

  • Trial Balance Discrepancy Prevention: If a Trial Balance report aborts due to a JV discrepancy, immediately navigate to the Journal Register to locate and correct the unbalanced voucher.
  • Match-Off Exclusion for Statement Sharing: When sending ledger statements to clients, toggle Exclude Match-Off JV to "Yes". This eliminates confusing zero-sum internal adjustments and displays only actual invoices and payment receipts.
  • Audit Letters in Bulk: Use the Confirmation of Balances mode at fiscal year-end to produce formal PDF verification letters for all major trade debtors and creditors.