...

User must be able to select the applicable accounting rule as "none",   "cash" or "accrual" at a product level.

The user is expected at the time of product definition to select the “type” of accounting for the product and select his appropriate General Ledger (GL) “Detail account” for the placeholders MifosX Mifos X accounting module provides

Page 10 of attached accounting summary document gives useful basic distinction between cash and accrual accounting.

2         The COA

Continue having the same design with five main account "Types":

• Assets
• Liabilities
• Income
• Expenditure
• Equity

...

Allow adding new accounts of any one of these types from the UI.

New accounts can be either "header" or "detail" accounts to make things simpler for a user. "Header" accounts would be used purely for grouping together

related accounts etc, an . An organization would not log journal entries against the same (Journal entry screens would not list "Header" accounts).

Question: Would you be interested in hearing what COA nirantara and GK accountants use (or any other MFI in community). ? On document pages 23, 24 is content about the 'classification of transactions' through chart of accounts and a sample chart of accounts for MFIs. How does nirantara and gk COA differ and why would be good to know.

...

• So system should associate all journal entries to branch which owns the entity that caused the entry (ExExample: Loan account on which a disbursal occuredoccurred)
• all All user defined journal entries should also be associated with a branch

...

The 'accounting cycle' image provided on page 22 of attached accounting summary document provides a good visualisation visualization of steps involved from 'economic activity step (transaction)' to closing books for a given cycle period (weekly/monthly/quarterly/yearly)

...

The Journal entries view would look similar to the below mockupmock up

3.1        Automated Journal Entries

MifosX Mifos X to automatically log (log each transaction as a separate journal entry....no need of daily consolidation etc.)

• Disbursals
• Repayments
• Rescheduling
• Write-Off
• Adjustments

These journal entries should not have permissions to be altered from the accounting UI (like manually created journal entries which can be reversed etc.)

They should link back to the entity that generated them (the loan Transaction transaction etc. so that a user can analyse the same).

They may only be altered with events generating from the system (ExExample: a user reverts a loan disbursal etc.)

...

For a manual entry, allow "m" debit and "n" credit entries for a "Journal Entry entered by a user" as long as the sums of all debits and credits match.

Allow journal entry reversal (system automatically logs reversal entries of corresponding debits and credits).

This means each journal entry batch must have a batch Id (so all individual entries under it can be identified for easy reversal).

4         Accounting rules for Loans

4.1        Cash based accounting Scenario:

4.1.1        COA Snippet

...

4.1.2        Posting Rules

...

4.2        Accrual Based accounting Scenario

Would only involve posting to three new accounts (Receivables "incomeTypeIncome Type") .

4.2.1        COA Snippet

...

4.2.2        Posting Rules

4.2.3        Examples

4.2.3.1        Flat Interest Type

...

The entire interest (for complete duration of the loan) is recognized immediately after disbursal.

There are quite a few conflicting views on if this special treatment is required. However, leaving it in here for now till we get feedback from a few accountants.

The sample loan shown here follows a monthly repayment cycle.

*Note: A Batch Id is shown in Brackets

4.2.3.1        Declining Interest Type

...

The system needs to have a job for posting the same

Note: If any interest is accrued till date while doing a prepayment, the application should automatically log a system generated journal entry

...

This is must for regulatory requirements. We should have the option to of turning the same “on” and “off” from the user interface

*This section needs to be revisited in detail

5       Accounting rules for Savings

...

5.1        COA Snippet

...

5.2        Posting Rules

6         Closure Dates

Allow setting closure dates at branch level after which accounting transactions cannot be posted.

...

• Real account: Debit what comes in and credit what goes out.
• Personal account: Debit who receives and Credit who gives.
• Nominal account: Debit all expenses & losses and Credit all incomes & and gains

...

7.1   Balance Sheet

A balance sheet summarizes an organization or individual's assets, equity and liabilities at a specific point in time. 

...

7.2  Income Statement (P & L statement)

Is Income Statement is a company's financial statement that indicates how the revenue (money received from the sale of products and services before expenses are taken out) is transformed into the net income (the result after all revenues and expenses have been accounted for, also known as Net Profit ).
It displays the revenues recognized for a specific period, and the cost and expenses charged against these revenues.

Formula: Net Income = Total Income – Total Expenses

...

7.2.1 Sample Query

Below query if is for Income, the query for expenses would be similar (save for calculation of balance, refer verbiage in section 6)

...

Table stores the “Chart of Accounts” for an organization.

8.2         Modifications to Loan Product (“m_product_loan”)

Table stores the “Chart of Accounts” for an organization.

8.3         Mapping Loan product to Chart of accounts  (acc_product_coa_mapping)

The table maps the GL codes used by a particular loan/saving product. 

8.4          Journal Entries (acc_journal_entry)

Table stores all journal entries generated in the system (either created automatically by the system and or those created manually).

8.5          Branch accounts closure (acc_closure)

Table stores details of all branches and dates for which all Journal entries have been closed.

...

Appendix

Appendix 1 - Links to material on previous mifos accounting

...