Overview
This report provides aggregated summary level general ledger account information, based on the information of the dates when JV where posted and depending on user defined selection criteria.
Navigation
General Ledger ► Reports ► Account Analysis Detail Summary Report
Account Analysis Detail Summary Report Filter Fields
Field | Description |
---|---|
Fiscal Year | This parameter is mandatory and shows the current fiscal year by default. The user have the option to select another fiscal year. |
Period | User enters the Fiscal Period From and To range (for example, Period From: Period 1, Period To: Period 2). This parameter is mandatory and it shows by default the current fiscal period, for Period From and Period To. |
Journal Voucher Date From | Select From date from the date picker |
Journal Voucher Date To | Select To date from the date picker |
Group By | The items that the user is available to group the data on are the same options listed above. |
Group By: Sub Ledger (Vendor, Bank Account Customer) | Sub Ledger code, select from Journal Voucher Item. |
Group By: Period | This group is by default true. |
Comment | Optional parameter |
Display In Domestic Currency | Option to display amounts in Domestic, Foreign, or Both currencies. If Domestic currency is selected, only the amounts in Domestic currency are displayed. If Foreign currency is selected, only the amounts in Foreign currency are displayed. If Both currencies are displayed, the amounts in both currencies are displayed. |
Include Opening Balance | Parameter to indicate if the opening balance for the first period of the date range selected is included in the report or not. Default is Yes: the opening balance for the first period (is based on the range of dates) is included. If set to No, the opening balance line is not shown in the report. |
Suppress Balance | Parameter Suppress Balance, Default is No: The balance should be shown. if YES: The balance is not shown. |
Overview
Trial balance report allow users to check the correct posting of the accounts. Ensuring transactions are in balance.
Navigation
General Ledger ► Reports ► Trial Balance Report
Trial Balance Report screen Fields
Fields | Description |
Fiscal Year | Display a List of Fiscal Years in the system. Mandatory Parameter. |
Fiscal Period | Display a List of Fiscal Period in the system. Mandatory Parameter. |
Show Opening Balances | If this flag is false, then system will not take into account opening balances of the Fiscal Year when showing amount of report. |
Currency | Currency for the report. |
Multi-Fund Concept | Users can select more than one fund as filter. If no elements are selected, system will take them all. |
Group By Fund | If checked indicates that the report will be grouped by fund. |
Concept | Display a List of Concepts belonging to OBJECT Code Segment. Mandatory Parameter. |
Comment | Optional parameter. |
Хавсралт | Хэмжээ |
---|---|
Trial bal rep nav.JPG | size suffix |
Trial balance report.JPG | size suffix |
Overview
This report displays accounts belonging to a specific Concept in the OBJECT Segment with its respective accumulated balance, actual, summary and total, allowing to the user to check the correct posting of the accounts.
Navigation
General Ledger ► Reports ► Trial Balance Detail Report
Trial Balance Detail Report Screen Fields
Fields | Description |
Fiscal Year | Display a List of Fiscal Years in the system. Mandatory Parameter. |
Fiscal Period | Display a List of Fiscal Periods in the system. Mandatory Parameter. |
Currency | Currency for the report. |
Multi-Fund Concept | Users can select more than one fund as filter. If no elements are selected, system will take them all. |
Group By Fund | Filter the report Group by fund. |
Concept | Display a List of Concepts belonging to OBJECT Code Segment. Mandatory Parameter. |
Comment | A comment may be added to the report output via this field. |
Хавсралт | Хэмжээ |
---|---|
TBD report nav.JPG | size suffix |
TBD report.JPG | size suffix |
Overview
This reports allows users to analyse the entire financial position of the government or an institution, up to a certain fiscal period.
Navigation
General Ledger ► Reports ► Balance Sheet Report
Balance Sheet Report screen Fields
Fields | Description |
Fiscal Year | User types Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
Fiscal Period | User Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. |
Multi-Fund Concept | User can select more than one fund as filter. If no elements are selected, system will take them all. This should appear only when multi fund parameter is true, when such parameter is false, then this group doesn´t apply. System will insert a page break between funds. |
Group By Fund | Filter the report by Group by fund. |
Concept | conepts of CoA segment marked as object code. |
Comment | A comment may be added to the report output via this field. |
Хавсралт | Хэмжээ |
---|---|
Balance sheet report.JPG | size suffix |
Balance sheet report navigation.JPG | size suffix |
Overview
This report prints out a detailed listing of all journal vouchers that match the specified selection criteria.
Navigation
General Ledger ► Reports ► Journal Voucher Details Report
Journal Voucher Details Report Screen Fields
Fields | Description |
Fiscal Year | User types Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
Fiscal Period | User Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. |
Include Coding Block Description | Concatenation of the description of the individual elements in the coding block. |
Voucher | Id of the journal Voucher. |
Posting Status | Filter option for status of the transactions in the system. Options are Saved and Temp Saved. |
Temp Number | Allow users to select a specific temp # or a range of temp # to view in the report. |
Voucher Source | Indicates the report will be grouped by Voucher source. |
Voucher Date | Default current system date |
Batch | Allow users to select a specific batch or a range of batches to view in the report. |
Voucher Status | Filter the report by Voucher Status. Following values are available. |
Voucher Type | Filter the report by Voucher Type. Following values are available. |
Sub-Ledger Type | Filter the report by sub-ledger type. Following values are available. 'Customer' 'Vendor' |
Comment | A comment may be added to the report output via this field. |
Хавсралт | Хэмжээ |
---|---|
Journal voucher details report navigation.JPG | size suffix |
Journal Voucher Details Report.jpg | size suffix |
Overview
The purpose of the "Account Analysis Report - Detail" report is to display the Journal Voucher data.
Users able to group the Journal Voucher data for a number of criteria, displaying sub-totals if required. The grouping options are based on the different groups of the GL code.
In addition, the report offers the ability to group the data by Period, providing a higher level grouping.
Finally, users able to sort the data on up to four criteria, allowing complete flexibility over the output.
Navigation
General Ledger ► Reports ► Account Analysis Detail Report
Account Analysis Detail Report Screen Fields
Fields | Description |
Fiscal Year | User types Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
Fiscal Period From | User Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. |
Fiscal Period To | User Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. |
Journal Voucher Date From | Journal Voucher From date. |
Journal Voucher Date To | Journal Voucher To date. |
Sub-Ledger Type | Allows to select Sub-Ledger Type from dropdown list. |
Obligation | Obligation that linked to Journal Voucher. |
Origin | Optional parameter. Possible values are: "Manual", "Expense Voucher", "Payment", "Void Cheque", "Invoice", "Receipt Voucher". "Debit Note", "Credit Note", "Goods Receipt Note", "Goods Return Note", "Goods Receipt Accrual Reversal", "Payroll", "Assets", "Inventory", "Bank Deposit", "Fiscal Period Closure", "Other", or "All". |
Journal Voucher Classification | Optional Parameter to select a specific JV Classification. |
Journal Voucher | Optional parameters. To filter the data of one particular Journal Voucher |
Accounting Office | Accounting Office filter one particular Institution. |
Reconciled Indicator | To indicate if the current transaction is reconciled with a matching transaction in the Bank Statement. |
Display cheque/deposit information | Information related to Display check/ deposit information. |
Currency | Only display if Foreign Amount has a value |
Display In Domestic Currency | Allow the user to select currency using this parameter |
Cheque Series | Will be updated when a payment is approved. |
Hierarchy Rollups UACS Elements | Indicates that there will be a hierarchical element restriction and Coding block restriction used to filter. |
Cheque Number | Filter the information in case a value is entered. |
Cheque Date | Filter the information in case a value is entered. |
Overview
The purpose of the Detail General Ledger Report is to display the Journal Vouchers within the system grouped by object and by fund when applicable.
Navigation
General Ledger ► Reports ► Detail General Ledger Report
Detail General Ledger Report Screen Fields
Fields | Description |
Fiscal Year | The Financial Year report for a specific year. |
Include Coding Block Description | A coding block description corresponding to all the elements descriptions. |
Group By | If checked indicates that the report will be grouped by Fund. |
Multi-Fund Concept | Users can select more than one fund as filter. If no elements are selected, system will take them all. |
Fiscal Period From | Beginning limit for the period covered in the report. |
Fiscal Period To | End limit for the period covered in the report. |
Hierarchy Rollups UACS Elements | Indicates that there will be a hierarchical element restriction and Coding block restriction used to filter. |
Comment | A comment may be added to the report output via this field. |
Overview
The Income statement - Budget Comparison Inquiry displays the Budget, actual Year-To-Date and variance, per Revenue, Cost of Sales, Expenditures, and Net Income/Loss elements, of the selected Object concept.
The variance is calculated and displayed as an amount and also a percentage.The figures displayed are based on the year to date revenue and expenses as at the current reporting period or active period.
Navigation
General Ledger ► Reports ► Budget Comparison Inquiry Report
Budget Comparison Inquiry Report screen Fields
Fields | Description |
Fiscal Year | User types Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
Fiscal Period | User Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. |
Budget Control Type | Filter criteria to filter the report by Budget Control Type. |
Currency | Currency for the report. |
Hierarchy Rollups UACS Elements | The Hierarchical Elements Restriction that may be selected as filter criteria for the report. The Coding Block restriction that may be selected as filter criteria for the report. |
Overview
The purpose of this report is to present a full detail of the Journal Voucher, including detailed information from JV including, Status , voucher source, item details, description JV, description item, workflow information and others.
Navigation
General Ledger ► Reports ► Journal Voucher Report
Journal Voucher Report Screen Fields
Fields | Navigation |
Fiscal Year | User types Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
Fiscal Period From | Beginning limit for the period covered in the report. |
Fiscal Period To | End limit for the period covered in the report. |
Voucher Id | Optional Parameter. Id of the journal voucher. |
Posting Status | Optonal Parameter. This field shows voucher is either saved or temp saved. |
Temp Number | Allow users to select a specific temp # or a range of temp # to view in the report. |
Origin | Selects the origin from dropdown list |
Voucher Date | Default current system date |
Batch Number | Allow users to select a specific batch or a range of batches to view in the report. |
Voucher Status | Filter the report by Voucher Status. Following values are available. Approval Requested Approved Cancelled Created Rejected Template |
Voucher Type | Filter the report by Voucher Type. Following values are available. 'Regular' 'Currency Gain & Loss' 'Retained Earnings' Default is 'Regular' |
Sub-Ledger Type | Filter the report by Sub-Ledger Type. Default is 'Not Applicable' |
Overview
The income statement report provides a timely portrayal or your organization's financial status at a specified period of time.
Navigation
General Ledger ► Reports ► Income Statement Report
Income Statement Report Screen Fields
Fields | Description |
Fiscal Year | User types Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
Fiscal Period From | Starting date of the Fiscal Period range to be selected for generating the report. |
Fiscal Period To | Last date of the Fiscal Period range to be selected for generating the report. |
Concept | Display a List of Concepts belonging to OBJECT Code Segment. Mandatory Parameter. |
Multi-Fund Concept | Different multi fund concepts related to organization level from the COA segment can be selected. |
Comments | A comment may be added to the report output via this field. |
Overview
The report shows list of all Current Assets and Current Liabilities G/L accounts that are having foreign currency (in the Currency attribute in the General Ledger entity) along with their currency and closing balance for the current period.
The report calculate the gain or loss for each G/L account by applying the current market Exchange Rate for each currency on the Domestic book balance of the account and compare it with the Domestic calculated balance. The gains and loss amount listed in the report.
The market exchange rate will be latest rate value of each currency.
Navigation
General Ledger ► Reports ► Currency Exchange Gain and Loss Report
Currency Exchange Gain And Loss Report
Fields | Description |
Fiscal Year | User types Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
Fiscal Period | Current Fiscal Period to be selected for generating the report. |
Sub Ledger Type | Sub Ledger type Bank Account, Vendor, Customer can be selected as the filter criteria for the report. |
Currency | Currency for the report. |
Multi-Fund Concept | User can select more than one fund as filter. If no elements are selected, system will take them all. |
Group by Fund | If checked indicates that the report will be grouped by Fund. |
Group By Object Code | Indicates the output result is grouped by Object Code segment. |
Include Sub Ledger Code | Users can select it to include the Sub Ledger code to display. |
Comment | Comments for this report. Optional Parameter. |
Hierarchy Rollups UACS Elements | Indicates that there will be a hierarchical element restriction and Coding block restriction used to filter. |
Overview
This report displays the financial status of an Institution, displaying the Current assets, non-current assets, liabilities and equities, allowing to users to know the financial situation up to a specific Fiscal Period.
Navigation
General Ledger ► Reports ► Inadeh Reports ► Balance Sheet Report
Balance Sheet Report screen fields:
Fields | Description |
Fiscal Year | User types Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
Fiscal Period | User Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. |
Institution | Id of the Institution. Optional parameter. |
Comment | A comment may be added to the report output via this field. |
Overview
Summarised report on holding account transactions is generated through this report.
Navigation
General Ledger ► Reports ► Laos Reports ► Summary Of Holding Account Transactions Report
Summary Of Holding Account Transactions Report screen Fields
Field | Description |
Fiscal Year | Fiscal Year for which the revenue report is generated, is selected from drop down box. |
From Date | Initial Date of revenue that is taken into consideration for report generation purpose, is selected from calendar button. |
To Date | End Date of revenue that is taken into consideration for report generation purpose, is selected from calendar button. |
Currency | Currency of revenue is selected from drop down box. |
Comment | Comment on the report on revenue, is entered in this field. |
Element | Organisational Element is selected from the lookup button. |
Overview
Summarised report on Revenue by classfification is generated through this report.
Navigation
General Ledger ► Reports ► Laos Reports ► Summary Of Revenue By Classification Report
Summary Of Revenue By Classification Report screen Fields
Field | Description |
Fiscal Year | Fiscal Year for which the revenue report is generated, is selected from drop down box. |
From Date | Initial Date of revenue that is taken into consideration for report generation purpose, is selected from calendar button. |
To Date | End Date of revenue that is taken into consideration for report generation purpose, is selected from calendar button. |
Treasury Office | Institution of Treasury Office to which the revenue relates, is selected from lookup button. |
Currency | Currency of revenue is selected from drop down box. |
Revenue Classification | Classification on which the revenue falls is seelcted in this field. |
Comment | Comment on the report on revenue, is entered in this field. |
Coding Block Filter Type | Filter Type applied on the revenue report is selected from drop down box. Possible filters are: Coding Block, Coding Block Expression Filter, Hierarchical Coding Block Elements. |
Segment | Segment is selected from drop down box. Possible values are: Fund, Fund Source, Organisation, Program and Object. |
Concept | Concept get automatically selected depending on the value selected for the Segment. |
Overview
Summarised report on Revenue by revenue type is generated through this report.
Navigation
General Ledger ► Reports ► Laos Reports ► Summary Of Revenue By Revenue Type Report
Summary Of Revenue By Revenue Type Report screen Fields
Field | Description |
Fiscal Year | Fiscal Year for which the revenue report is generated, is selected from drop down box. |
From Date | Initial Date of revenue that is taken into consideration for report generation purpose, is selected from calendar button. |
To Date | End Date of revenue that is taken into consideration for report generation purpose, is selected from calendar button. |
Currency | Currency of revenue is selected from drop down box. |
Transaction Analysis | Basis of transaction analysis is selected from drop down box. |
Comment | Comment on the report on revenue, is entered in this field. |
Objective:
This report displays accounts belonging to a specific Concept in the OBJECT Segment with its respective accumulated balance, actual, summary and total, allowing to the user to check the correct posting of the accounts.
Navigation:
Trial Balance For Laos Report screen Fields:
Fields | Description |
Fiscal Year | The Financial Year report for a specific year. |
Fiscal Period | The period covered in the report. |
Organization Type Element | Filter report by Organization type Element. |
Multi-Fund Concept | Users can select more than one fund as filter. If no elements are selected, system will take them all. |
Group By Fund | If checked indicates that the report will be grouped by fund. |
Concept | Filter report by Concept. |
Trial Balance Report Type | Filter report by Trial Balance Report Type. Two options are available. 1.For the month. 2.Upto the month. |
Comment | A comment may be added to the report output via this field. |
Хавсралт | Хэмжээ |
---|---|
Trial Balance For Laos Report Nav.JPG | size suffix |
Trial Balance For Laos Report.JPG | size suffix |
Objective:
The purpose of this report is to present a full detail of the Journal Voucher, including detailed information from JV including, Status , voucher source, item details, description JV, description item, workflow information and others.
Navigation:
Journal Voucher Listing Report screen Fields:
Fields | Description |
Fiscal Year | The Financial Year report for a specific year. |
Posting Status | Optional Parameter. This field shows voucher is either saved or temp saved. |
Voucher Source | Filter the report by Voucher Source. |
Journal Voucher From Date | Filter report by Date from Journal Voucher included in this report. |
Journal Voucher To Date | Filter report by Date upto Journal Voucher included in this report. |
Batch Number | Allow users to select a specific batch or a range of batches to view in the report. |
Voucher Status | Filter the report by Voucher Status. Following values are available. Approval Requested Approved Cancelled Created Rejected Template |
Transaction Analysis | Filter report by Journal Voucher Transaction Analysis. |
Approved From Date | Filter report by the date(starting) from approval of the Journal Voucher. |
Approved To Date | Filter report by the date (end) upto approval of the Journal Voucher. |
Хавсралт | Хэмжээ |
---|---|
Journal Voucher Listing Report Nav.JPG | size suffix |
Journal Voucher Listing Report.jpg | size suffix |
Objective:
In Lao - Treasury bank account is always mapped to Institution and is also always mapped to 3 Coding Block through offset code, offset code for bank in transit revenue, offset code for bank transit payments. So, Multiple Treasury bank accounts can be mapped to an Institution. A Daily report is hence required to find the bank balances either by institution or by Treasury Bank Account.
Navigation:
Daily Bank Account By Currency Report screen fields:
Fields | Description |
Fiscal Year | The Financial Year report for a specific year. |
Start Date | Beginning limit for the period covered in the report. |
End Date | End limit for the period covered in the report. |
Instittution | Filter the report by Institution. |
Currency | Currency for the report. |
Treasury Bank Account | Filter the report by Treasury Bank Account. |
Multi-Fund Concept | Users can select more than one fund as filter. If no elements are selected, system will take them all. |
Comment | A comment may be added to the report output via this field. |
Хавсралт | Хэмжээ |
---|---|
Daily bank account by currency report.jpg | size suffix |
Daily bank account by currency report Nav.jpg | size suffix |
Objective:
In Lao, Treasury works like bank with a no. of depositors and loan accounts. Account Statement like bank statement is required for such accounts - Currency wise.
Navigation:
Current Account Statement Report screen fields:
Fields | Description |
Fiscal Year | The Financial Year report for a specific year. |
Start date | Beginning limit for the period covered in the report. |
End Date | End limit for the period covered in the report. |
Currency | Currency for the report. |
Vendor | Filter the report by vendor. |
Comments | A comment may be added to the report output via this field. |
Hierarchy Rollups Coa Elements | Indicates that there will be a hierarchical element restriction and Coding block restriction used to filter. |
Хавсралт | Хэмжээ |
---|---|
Current Account Statement Report Nav.jpg | size suffix |
Current Account Statement Report.jpg | size suffix |
Objective:
Navigation:
Profit And Loss Statement Report screen Fields:
Fields | Description |
Fiscal Year | The Financial Year report for a specific year. |
Fiscal Period | The period covered in the report. |
Multi fund Concept | Users can select more than one fund as filter. If no elements are selected, system will take them all. |
Group By fund | If checked indicates that the report will be grouped by fund. |
Concept | Filter report by Concept. |
Comment | A comment may be added to the report output via this field. |
Хавсралт | Хэмжээ |
---|---|
Profit And Loss Statement Report.JPG | size suffix |
Profit And Loss Statement Report Nav.JPG | size suffix |
Objective:
Navigation:
Financial Statement Of National Treasury Report screen Fields:
Fields | Description |
Fiscal Year | The Financial Year report for a specific year. |
Fiscal Period | The period covered in the report. |
Multi-Fund Concept | Users can select more than one fund as filter. If no elements are selected, system will take them all. |
Group By Fund | If checked indicates that the report will be grouped by fund. |
Concept | Filter the report by Concept. |
Comment | A comment may be added to the report output via this field. |
Objective:
Navigation:
Summary Of Revenue By Budget Nomenclature Report screen Fields:
Fields | Description |
Fiscal Year | The Financial Year report for a specific year. |
Account Balancing Type | |
Journal Voucher Dates | |
Comment | A comment may be added to the report output via this field. |
Hierarchy Rollups Coa Elements | Indicates that there will be a hierarchical element restriction and Coding block restriction used to filter. |
Objective:
Navigation:
Daily Or Monthly Account Balancing Report screen Fields:
Fields | Description |
Fiscal Year | The Financial Year report for a specific year. |
Account Balancing Type | Filter the report by Account Balancing Type. Daily or Monthly. |
Start days | Beginning limit for the period covered in the report. |
End Days | End limit for the period covered in the report. |
Currency | Currency for the report. |
Sub Ledger Type | Filter the report by Sub ledger type. |
Comments | A comment may be added to the report output via this field. |
Hierarchy Rollups Coa Elements | Indicates that there will be a hierarchical element restriction and Coding block restriction used to filter. |
Objective:
Navigation:
Holding Account Details Report screen Fields:
Fields | Description |
Fiscal Year | The Financial Year report for a specific year. |
Start Date | Beginning limit for the period covered in the report. |
End Date | End limit for the period covered in the report. |
GL Account Code | Filter The Report by GL Account Code. |
Currency | Currency for the report. |
Comment | A comment may be added to the report output via this field. |
Objective:
The purpose of the Detail General Ledger Report is to display the Journal Vouchers within the system grouped by object and by fund when applicable.
Navigation:
General Ledger Account Details Report screen Fields:
Fields | Description |
Fiscal Year | The Financial Year report for a specific year. |
Group By Fund | If checked indicates that the report will be grouped by Fund. |
Account Balancing Type | Filter the report by account balancing type. |
Start Days | The Financial Year report for a specific year. |
End Days | End limit for the period covered in the report. |
Currency | Currency for the report. |
Sub Ledger Type | Filter The report by Sub Ledger Type. Following Options are available. |
Multi Fund Concept | Users can select more than one fund as filter. If no elements are selected, system will take them all. |
Comment | A comment may be added to the report output via this field. |
Hierarchy Rollups Coa Elements | Indicates that there will be a hierarchical element restriction and Coding block restriction used to filter. |
Objective:
Navigation:
Expenditure by Payment Type Report screen Fields:
Fields | Description |
Fiscal Year | The Financial Year report for a specific year. |
Start Date | Beginning limit for the period covered in the report. |
End Date | End limit for the period covered in the report. |
Currency | Currency for the report. |
Comment | A comment may be added to the report output via this field. |
Hierarchy Rollups Coa Elements | Indicates that there will be a hierarchical element restriction and Coding block restriction used to filter. |