fineract-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sangamesh n <>
Subject Re: [Mifos-developer] Trial balance request
Date Mon, 17 Sep 2018 06:11:53 GMT
Hello Brahiman,

Below is the logic for trail balance - Opening and Closing report. Using
this logic you need write SQL query and design it using Pentaho report.Hope
this might help you.

*1. Opening Balance Calculation*
        Based On the Account Types (Asset,Liability,Equity,Income,Expense).
        For Asset and Expense Opening Balance calculation (Debit - Credit)
and other
        account type (credit - Debit).

*2.Closing Balance*

   -        Day Closing Balance - (Opening Balance + running balance)
   -        Running Sum = cumulative_sum (it is generated in SQL)
   -        Calculating Closing Balance

                         Asset and Expense
                         [(Opening balance) + (debit Total) - (Credit
                         other Accounts
                         [(Opening balance) - (debit Total) - (Credit


On Fri, Sep 14, 2018 at 6:09 PM brahiman yogo <> wrote:

> Hello, I would like to do a trial balance with for each GL account there
> is the opening balance, movements (debit / credit) and closing balance.
> Does somebody have an idea?
> Mifos-developer mailing list
> Unsubscribe or change settings at:

View raw message