Please enable JavaScript.
Coggle requires JavaScript to display documents.
Finance Module - ( Financial note management,Financial report template…
Finance Module - ( Financial note management,Financial report template,Financial statement generator)
Financial Statement Generator
Listing (Grid Columns)
Report Type – Display
Report Template – Display
Period Start Date – Display
Period End Date – Display
Segment 01 – Display
Segment 02 – Display
Segment 03 – Display
Segment 04 – Display
Segment 05 – Display
Create / Generate
Required Fields
Report Type – Mandatory – Dropdown (References: P&L, Balance Sheet, Cash Flow, Trial Balance)
Report Template – Mandatory – Dropdown (from Template Design)
File Format – Mandatory – Dropdown (PDF / Excel)
Period Start Date – Mandatory – Calendar (DD-MMM-YYYY)
Period End Date – Mandatory – Calendar (DD-MMM-YYYY)
Optional Fields
Segment 01 – Optional – Dropdown
Segment 02 – Optional – Dropdown
Segment 03 – Optional – Dropdown
Segment 04 – Optional – Dropdown
Segment 05 – Optional – Dropdown
Actions
Select inputs → Click "Generate Report"
Validations
Period End Date ≥ Period Start Date
All mandatory fields present before enabling Generate
Export honors File Format (PDF or Excel)
Graceful handling of empty result sets (show “No data for selected period/filters”)
Report Templates
Balance Sheet – Columns / Values
Current Month YTD – From General Ledger (GL)
Previous Month YTD – From GL
Previous Year Current Month YTD – From GL (prior-year balances)
Previous Year Balance – From GL (prior-year balances)
Note: Client-specific additional fields may be configured
Trial Balance – Columns / Values
Opening Balance As at YYYY (Debit/Credit) – From Opening Balance Management
Current Month Transactions (Debit/Credit) – From GL (current month)
Last Year/Month Transactions (Debit/Credit) – From GL (prior-year period)
Current Balance As at YYYY (Debit/Credit) – Opening + Current (Dr – Cr)
Note: Client-specific additional fields may be configured
Profit & Loss – Columns / Values
Current Month Actual – From GL
Current Month Budget – From GL / Financial Budget
Current Month Variance – Budget – Actual
% – (Variance / Current Month Actual) × 100
Previous Month Actual – From GL
Current Year Actual (Cumulative) – From GL
Current Year Budget – From GL / Financial Budget
Current Year Variance – Budget (YTD) – Actual (YTD)
Last Year Month – From GL / Financial Statements (prior-year)
Last Year Cumulative – From GL / Financial Statements (prior-year)
Note: Client-specific additional fields may be configured
Common Rules (Generator)
Value/Date integrity checks
Mandatory fields gate the Generate button
Performance: Async generation with progress/notification recommended
Errors: Friendly message, re-try option
Financial Report Template Management
Listing & Actions
Columns (Display)
Template ID
Template Name
Report Type
Report File
Status
Toolbar / Controls
Advanced Search
Clone Template
Add New
Advanced Search
Optional Filters
Template ID – Optional – Text
Template Name – Optional – Text
Status – Optional – Toggle/Dropdown
Actions
Open Advanced Search → Apply filters → Search
Validations
Empty-results handling (“No templates found”)
Create Template
Required Fields
Template ID – Mandatory – Text (Unique)
Template Name – Mandatory – Text (≤ 200 chars; Unique)
Report Type – Mandatory – Dropdown (Balance Sheet / Income Statement / Cash Flow)
Report File – Mandatory – Text (JSON/Jasper file name)-
Status – Mandatory – Toggle (Active/Inactive)
Auto Fields (when Status toggled to Inactive)
Inactivated By – Auto – Username
Inactivated Date – Auto – DateTime
Line Items (Template Body)
Line No – Value (default ascending; allow descending as user preference)
Description – Text
Line Type – Dropdown (Heading / Account Map / Total / Blank Line)
Status – Toggle
Actions
Click "Add New" → Fill header → Add line items → "Submit" to create template
Validations
Template Name uniqueness
Line No uniqueness within the template
Character limits respected (Name ≤ 200)
Save/Submit success messages
DB failure: “User update unsuccessful. If action fails continuously, please contact Administrator”
Paginated/scrollable line items for large templates
Add Line Item – Variants
Heading
Required Fields
Line No – Mandatory – Value (Unique)
Description – Mandatory – Text (appears on extraction)
Line Type – Mandatory – Fixed: Heading
Status – Mandatory – Toggle
Formatting (Mutually-Exclusive where specified)
Bold – Optional – Toggle
Italic – Optional – Toggle
Underline – Optional – Toggle (exclusive with Double Underline)
Double Underline – Optional – Toggle (exclusive with Underline)
Auto Fields on Inactivate
Inactivated By – Auto
Inactivated Date – Auto
Actions
Save / Cancel
Account Map
Required Fields
Line No – Mandatory – Value (Unique)
Description – Mandatory – Text
Line Type – Mandatory – Fixed: Account Map
Optional Fields
Note – Optional – Dropdown (from Financial Notes Management)
Account – Optional – Dropdown (from COA))
Account Range – Optional – Dropdown (start/end from GL periods)
Account Selection – Optional – Multi-select (Accounts)
Status – Optional – Toggle
Auto Fields on Inactivate
Inactivated By – Auto
Inactivated Date – Auto
Actions
Save / Cancel
Validations
Range start must be lower than end (sequence check)
Radio defaults null where applicable
Total
Required Fields
Line No – Mandatory – Value (Unique)
Description – Mandatory – Text
Line Type – Mandatory – Fixed: Total
Optional Fields
Status – Optional – Toggle
Formatting – Optional – Bold / Italic / Underline / Double Underline (Underline XOR Double Underline)
Line No Range – Optional – Dropdown (start/end from Template line numbers)
Line No Selection – Optional – Multi-select (specific line nos)
Auto Fields on Inactivate
Inactivated By – Auto
Inactivated Date – Auto
Actions
Save / Cancel
Validations
Range start < Range end
Radio/format defaults null where applicable
Blank Line
Required Fields
Line No – Mandatory – Value (Unique)
Line Type – Mandatory – Fixed: Blank Line
Optional Fields
Description – Optional – Text
Status – Optional – Toggle
Auto Fields on Inactivate
Inactivated By – Auto
Inactivated Date – Auto
Actions
Save / Cancel
Manage / Edit Line Item
Actions
Select line → "Manage" → Edit → Save
Validations
Same as creation + ensure uniqueness and sequence rules preserved
Clone Template
Required Fields
New Template ID – Mandatory – Text (Unique)
New Template Name – Mandatory – Text
Old Template ID – Mandatory – Dropdown (existing templates)
Actions
Fill fields → Click "Clone Template" → Navigate to creation screen with cloned lines → Edit → Save/Submit
Validations
New Template ID/Name must be unique
Active account codes loaded from original template context where relevant
Common Rules (Templates)
Text input max length = 50 unless specified (Template Name = 200)
Value fields max length = 20; numeric only
Friendly success toasts on Save/Submit
Error messages for limits, duplicates, DB failures
Financial Notes Management
Listing & Controls
Columns (Display)
Note Code
Note Description
DR/CR
Status
Manage
Toolbar
Advanced Search
Add New
Clone a Note
Advanced Search
Optional Filters
Note Code – Optional – Text
Note Description – Optional – Text
Status – Optional – Toggle/Dropdown
Actions
Open Advanced Search → Apply filters → Search
Add New Note
Required Fields
Note Code – Mandatory – Text (Unique)
Note Description – Mandatory – Text (≤ 300 chars)
DR/CR Type – Mandatory – Dropdown (from References)
Status – Mandatory – Radio/Toggle (Active/Inactive)
Optional / Auto Fields
Inactive Effect Date – Optional – Calendar (DD-MMM-YYYY)
Inactivated Date – Auto – Date (when status disabled)
Inactivated By – Auto – Username (when status disabled)
Add Account Code (sub-entries)
Required Fields
Account Code – Mandatory – Dropdown (Chart of Accounts)
Auto Fields
Description – Auto – from selected Account Code
Type (DR/CR) – Auto – from selected Account Code
Optional Fields
Status – Optional – Toggle
Actions
Click "Add New" (Account) → Select Account → Save
Actions
Fill mandatory fields → Add at least one Account Code → Save
Validations
Require at least one Account Code:
“Please select an account code and try again”
Note Code uniqueness
Description length ≤ 300
Standard errors:
“Please fill all the required fields and try again”
“User update unsuccessful. If action fails continuously, please contact Administrator”
“The maximum character limit has been exceeded” (Limit Block)
Manage Existing Note
Actions
Select Note → Click "Manage" → Edit fields → Save
Clone a Note
Actions
Click "Clone a Note" → Load existing data → Edit → Save
Notes
Active account codes should be loaded from existing note when cloning
Common Rules (Notes)
Status shown as chips in listings
Mandatory fields gate the Save button
Graceful handling of duplicates & limits