Accounting Module Functionality and Expectations
Table of Contents |
---|
1 What Accounting rules?
User must be able to select the applicable accounting rule as "none", "cash" or "accrual" at a product level.
...
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 headers
...
Question: Would 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.
2.1 Scope
For simplicity (for the first cut) have COA at organization level and run accounting reports at the branch level
- So system should associate all journal entries to branch which owns the entity that caused the entry (Ex: Loan account on which a disbursal occured)
- all user defined journal entries should also be associated with a branch
3 Journal Entries
The 'accounting cycle' image provided on page 22 of attached accounting summary document provides a good visualisation 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 mockup
3.1 Automated Journal Entries
MifosX to automatically log (log each transaction as a separate journal entry....no need of daily consolidation etc.)
...
They may only be altered with events generating from the system (Ex: a user reverts a loan disbursal etc.)
3.2 Manual Journal Entries
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
...
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
4.1 Cash based accounting Scenario:
4.1.1 COA Snippet
HEAD | Placeholder |
Assets | Cash |
Loan Portfolio | |
Income
| Interest on loans |
Income from fees | |
Income from Penalties | |
Expenses | Losses Written Off |
4.1.2 Posting Rules
Event | Debit | Credit |
Disbursal | Loan Portfolio | Cash |
Principal repayment | Cash | Loan Portfolio |
Interest repayment | Cash | Interest on loans |
Principal Write off | Losses Written Off | Loan Portfolio |
Fees payment | Cash | Income from fees |
Penalty payment | Cash | Income from Penalties |
4.2 Accrual Based accounting Scenario
Would only involve posting to three new accounts (Receivables "incomeType")
4.2.1 COA Snippet
HEAD | Placeholder |
Assets
| Cash |
Loan Portfolio | |
Receivables Interest | |
Receivables Fees | |
Receivables Penalties | |
INCOME
| Interest on loans |
Income from fees | |
Income from Penalties | |
Expenses | Losses Written Off |
4.2.2 Posting Rules
Event | Debit | Credit |
Disbursal | Loan Portfolio | Cash |
Interest Applied | Receivables Interest | Interest on loans |
Fee Applied | Receivables fee | Income from fees |
Penalty Applied | Receivables penalties | Income from Penalties |
Principal repayment | Cash | Loan Portfolio |
Interest repayment | Cash | Receivables Interest |
Principal Write off | Losses Written Off | Loan Portfolio |
Fees payment | Cash | Receivables fee |
Penalty payment | Cash | Receivables penalties |
Interest write off | Losses Written Off | Receivables Interest |
Fee write off | Losses Written Off | Receivables fee |
Penalty write off | Losses Written Off | Receivables penalties |
4.2.3 Examples
4.2.3.1 Flat Interest Type
When Interest Type is flat, prepayment does not write off any interest. The entire interest is recognized and “receivable” as soon as the loan is disbursed.
...
*Note: A Batch Id is shown in Brackets
4.2.3.1 Declining Interest Type
In the case of Declining Balance, we have loans involving interest recalculation. The interest is accrued at the date of each repayment.
...
for recognizing the same while doing a prepayment.
4.2.4 Month end and year End Closing
We should also have an option for Month end closing and year end closing at a branch level (basically a bulk “apply accrued interest” till date job for all loans of declining Interest type)
...
*This section needs to be revisited in detail
5 Closure Dates
Allow setting closure dates at branch level after which accounting transactions cannot be posted.
...