[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Mifos-developer] Trial balance request

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 <bragolight@xxxxxxxxx> 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
> mifos-developer@xxxxxxxxxxxxxxxxxxxxx
> Unsubscribe or change settings at:
> https://lists.sourceforge.net/lists/listinfo/mifos-developer