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:
- 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. - Company Master Setup: The company’s Registered Office address must be configured in Company Master for report headers.
- Profit Account Mapping: For Final Accounts, the system verifies that the Profit for the Year account is properly linked in the Transaction Type Master.
- Clean Trade Notes: Final Accounts generation fails if any Debit or Credit Note exists with header records but missing line items.
- Date Constraints:
From Datecannot be earlier than the active Financial Year start date.To Datecannot 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 Datecannot be earlier thanFrom Date.
5. Source Transactions ๐
The reporting engine consolidates data from:
- Opening Balances: Starting balances established at the beginning of the fiscal year.
- Trade Invoices & Bills: Sales Invoices, Purchase Bills, and Debit/Credit Notes.
- Bank & Cash Vouchers: All operational payment and receipt transactions.
- 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.