Skip to main content

Financial Reports

Accounting reports are located in the AMERP Reports menu. They have been developed with JasperSoft Studio for integration with iDempiere processes.

To access them, go to:

Performance Analysis -> AMERP Reports -> AMERP Financial Reports

Below are descriptions of the different report options available.

Chart of Accounts​

This report shows the accounting structure of your client in a tree-like format.

  • Menu: Performance Analysis -> AMERP Reports -> AMERP Financial Reports -> Chart of Accounts
  • File: AccountElements.jrxml
  • Input parameter: AD_Client_ID (the numeric ID of the client).

Analytical Ledger​

The Analytical Ledger allows you to view the accounting movements of various accounts over a specific period, including real and nominal accounts.

  • Menu: Performance Analysis -> AMERP Reports -> AMERP Financial Reports -> Analytical Ledger
  • File: AnaliticFinancialStae.jrxml
  • Columns: Account code and description, period's beginning balance, date and movement details, debits, credits, period's balance, and accumulated balance.
  • Input parameters:
    • AD_Client_ID: Client ID.
    • AD_ORG_ID: Organization ID.
    • DateIni: Start date of the period.
    • DateEnd: End date of the period.

Trial Balance​

This report provides accounting information for a specific period, showing all real and nominal accounts.

  • Menu: Performance Analysis -> AMERP Reports -> AMERP Financial Reports -> Trial Balance
  • File: TrialBalance.jrxml
  • Columns: Account code and description, period's beginning balance, debits, credits, period's balance, and accumulated balance.
  • Input parameters:
    • AD_Client_ID: Client ID.
    • AD_ORG_ID: Organization ID.
    • C_Period_ID: ID of the requested period.

Statement of Financial Position​

Previously known as the Balance Sheet, this report shows only the real accounts (Assets, Liabilities, and Equity) along with the accumulated result for the fiscal year.

  • Menu: Performance Analysis -> AMERP Reports -> AMERP Financial Reports -> Statement of Financial Position
  • File: StateFinantialBalance.jrxml
  • Columns: Account code and description, and period's balance.
  • Input parameters:
    • AD_Client_ID: Client ID.
    • AD_ORG_ID: Organization ID.
    • C_Period_ID: ID of the requested period.

Statement of Comprehensive Income​

Formerly known as the Profit and Loss Statement, this report shows the nominal accounts (Income, expenses, and others) and the accumulated result for the fiscal year.

  • Menu: Performance Analysis -> AMERP Reports -> AMERP Financial Reports -> Statement of Comprehensive Income
  • File: StateFinancialIntegralResults.jrxml
  • Columns: Account code and description, and period's balance.
  • Input parameters:
    • AD_Client_ID: Client ID.
    • AD_ORG_ID: Organization ID.
    • C_Period_ID: ID of the requested period.

Statement of Changes in Equity​

This report compares the balances of real accounts (Assets, Liabilities, and Equity) between two periods, showing the sources and uses of funds.

  • Menu: Performance Analysis -> AMERP Reports -> AMERP Financial Reports -> Statement of Changes in Equity
  • File: StateFinancialPositionChange.jrxml
  • Columns: Balance Period 1, Balance Period 2, Sources, and Uses.
  • Definitions:
    • Source: A decrease in an asset or an increase in a liability or equity.
    • Use: An increase in an asset or a decrease in a liability or equity.
  • Input parameters:
    • AD_Client_ID: Client ID.
    • AD_ORG_ID: Organization ID.
    • DateIni: Start date of the first period.
    • DateEnd: End date of the second period.