Mifos User Documentation Portal
  • Overview and Background
    • History and Background
    • Mifos Vision, Mission & Values
    • Who Mifos is For
    • How Mifos is Used
    • The Mifos Stack
      • Overview
    • Mifos v/s Fineract
    • Community app v/s Webapps
  • General Contributing Guidelines
    • Upstream Development Approach
      • Contribution Process
      • The Apache Way
    • Contributors Guide
    • Contribution Guidelines: Android Project
    • Contribution Guidelines: Web Project
  • Getting Started
    • Getting started with Git & Github
    • Postman integration with Gitbook for testing
    • Testing framework-Web
    • Testing framework-Android
    • Mifos CI/CD tools and instructions
  • External 3rd Apps
    • Pentaho Reporting Plugin
    • Payment Hub
  • MifosX
    • Overview
    • User Manual
      • How to Use This Manual
      • For All Users
        • General Navigation
          • Sign In Page
          • Welcome Page
          • Dashboard Page
          • List Page
          • Menu Page
          • Form Page
          • Clients-Groups-Centers Navigation
          • Navigation Tool
          • Global Search
          • Loan Product and Accounting with Mifos
        • Reports
          • Standard Reports Shipped in Mifos X
          • Standard Reports Field Descriptions
          • Custom Reports
            • Creating Simple Pentaho Report and Embedding it to Mifos X
          • XBRL Reporting
      • For Administrators (Mifos X Platform)
        • Initial System Set Up
        • Administration
          • Users
          • Organization
            • Manage Offices
            • Currency Configuration
            • Manage Holidays
            • Manage Funds
            • Manage Employees
            • Bulk Loan Reassignment
            • Standing Instructions History
            • Teller / Cashier Management
            • Fund Mapping
            • Working Days
            • Password preferences
            • Payment type
            • Loan Provisioning Criteria
            • SMS Campaigns
            • Message Gateway Configuration
            • Daily Teller Cash Management
            • Entity Data Table Checks
          • System
            • Manage Data Tables
            • Audit Trails
            • Manage Codes
            • Manage Reports
            • Manage Roles and Permissions
            • Manage Scheduler Jobs
            • Configure Maker-Checker Tasks
            • Global Configuration
            • Manage Hooks
              • Steps for creating sms bridge
            • Account Number Preferences
            • Entity To Entity Mapping
              • External Services
          • Products
            • Loan Products
              • Loan Product Fields
                • Accounting Loan Product Fields
                • Configuring and Disbursing of Top-Up Loan
                • Declining Balance Interest Calculation
                • Enabling Floating Rate
                • Enabling Variable Installments
                • Flat interest calculation
                • Loan Product Fields—Additional Fields for Loans with Variable Terms based on Loan Cycle
                • Recalculate Interest
                • Tranche Loan Fields
              • Setting up Minimum Days between Disbursal and First Repayment
              • Product Mix
            • Charges
            • Floating Rate
            • Savings Products
              • Saving Product Fields
                • Accounting Saving Product Fields
            • Fixed Deposit Products
              • Fixed Deposit Product Fields
                • Accounting Fixed and Recurring Deposit Product Fields
              • Interest rate chart with amount range
            • Recurring Deposit
              • Recurring Deposit Product Fields
            • Interest Calculations for Deposit Products
            • Overdraft Product
            • Share products
              • Dividends
            • Manage Tax configuration
          • Templates
          • mifos dropdown
        • Clients, Groups and Centers
          • Manage Clients
            • Client Life Cycle Statuses
            • Client Relationship Management
          • Manage Groups
          • Manage Centers
        • Accounting
          • Chart of Accounts - General Ledger Setup
            • Default COA sql script
          • Accounts linked to Financial Activities
          • Migrate opening balances (Office-wise)
          • Accounting Rules
          • Provisioning Entries
          • Print General Ledger Listing
          • How To Enter GL Opening Balance
        • Configure Notifications
      • For Operational Users (Mifos X Web App)
        • Accounting operations
          • Add Journal Entries
          • Searching Accounting Transactions
          • Frequent Postings
          • Advanced Accounting Rules
          • Closing Entries
          • Accruals
        • Accounts and Transactions
          • Cash Transaction Processing
          • Deposit Accounts
            • Mifos X Saving Accounts
              • How to Activate a Saving Account
              • How to Add a Charge to a Saving Account
              • How to Approve a Saving Account Application
              • How to Calculate Interest for a Saving Account
              • How to Close a Saving Account
              • How to Create a Saving Account Application
                • Saving Account Fields
              • How to create overdraft account (Draft)
              • How to Delete a Saving Account Application
              • How to Make a Deposit to a Saving Account
              • How to Make a Withdrawal from a Saving Account
              • How to Modify a Saving Account Application
              • How to Post Interest to a Saving Account
              • How to Reject a Saving Account Application
              • How to Transfer funds from a Saving Account
              • How to Withdraw a Saving Account Application
            • Standing Instructions
              • How to Set up a Standing Instruction
                • Standing Instruction Form Fields
            • Term Deposit Accounts (Fixed Deposit / Recurring Deposit)
              • How to Activate a Term Deposit Account
              • How to Add a Charge to a Term Deposit Account
              • How to Approve a Term Deposit Account Application
              • How to Calculate Interest for a Term Deposit Account
              • How to Create a Term Deposit Account Application
                • Term Deposit Account Fields
              • How to Delete a Term Deposit Account Application
              • How to Make a Deposit to a Recurring Term Deposit Account
              • How to Modify a Term Deposit Account Application
              • How to Post Interest to a Term Deposit Account
              • How to Reject a Term Deposit Account Application
              • How to Withdraw a Term Deposit Account Application
            • Creating Recurring Deposit Account:
          • Loan Accounts
            • How to Create a Loan Account Application
              • Loan Account Fields
            • How to Make Repayments on a Client Loan Account
            • Track Loan Performance History
            • How to Approve a Loan Account Application
            • How to Add a Charge to a Loan Account
            • How to Modify a Loan Account Application
            • How to Assign a Loan Officer
            • How to Reject a Loan Account Application
            • How to Withdraw a Loan Account Application
            • How to Delete a Loan Account Application
            • How to Add Collateral to a Loan Account
            • How to Add/Remove/Modify a Guarantor to a Loan Account
            • How to Manage Loan Account Disbursement
            • How to Make Repayments on a Group Loan Account
            • Using collection sheet or other payment types for making payments
            • How to Waive Interest for a Loan Account
            • How to Write-off a Loan Account
            • How to Close a Loan Account as Rescheduled
            • How to Close a Loan Account
            • Making Prepay of the loan
            • How to Prepay a Loan Account
            • How To Create Group Loan Account
            • How to Process Bulk JLG Loan Application
            • How to generate - Loan transactions report
            • How to reschedule loan
            • How to provide floating rates
            • How to provide variable installments
            • How to create new loan - Interest Recalculation
            • Tranche loan process
            • Loan with term vary based on loan cycle
            • How to Place Guarantee Funds On-Hold?
          • Overdraft account
          • Saving Accounts
            • How To Create Group Saving Account
          • Share Accounts
        • Checker Inbox & Tasks
      • Side Bar - Features
        • Checker inbox and tasks
        • Collection sheet
        • Help.
        • Individual collection sheet
        • Keyboard short-cuts
        • Navigation
      • Others - mifos dropdown
        • Help
        • Profile
        • Settings
          • Date format
          • Language
        • Signout
      • Data Import Tool
        • Getting started with - Data Import Tool
        • Installing Data Import Tool
      • Glossary of Terms
      • Index
      • Reporting Documentation
      • Mobile Money Tool
    • User Space
      • New Feature Request Content
      • Recommended System Requirement
      • MifosX Overview
      • Installation guide
        • Upgrading Mifosx
        • Install MifosX on Windows
        • Install MifosX on Linux
        • Install MifosX on AWS
      • Release Notes
        • Release 1 and Features List
        • Release 2 and Features List
      • User Manual
        • How to Use This Manual
        • For All Users
          • General Navigation
            • Sign In Page
        • For Administrators
          • Initial System Set Up
        • For Operationals
      • Roadmap
      • Frequently Asked Questions (FAQs)
      • Demo Server Details
    • Developer Space
      • Setting Up Dev Environment
        • Setting up Frontend - community-app
      • Setting up MifosX from latest builds
      • Contributors Guide
      • Customising MifosX
      • Additional features
        • Data import tool
        • SMS campaigns
        • Pentaho reports
      • How Mifosx works
      • Adding a new tenant to MifosX instance
      • Using REST client for testing
      • API documentation
      • Scaling MifosX
      • Upgrading MifosX
      • Troubleshooting guide
  • Core Banking & Embedded Finance
    • Core Banking
      • Overview
    • Embedded Finance
      • Overview
  • Application Framework
    • Payment Hub EE
  • Main Platforms
    • Fineract 1.x
      • Apache Fineract
      • Apache Fineract Client
    • Fineract CN
      • Overview
      • User Manual
  • Staff UI Platforms
    • Fineract 1.x
      • Community-App
      • Web-App
      • Web Self-Service App
        • Online Banking App 2.0 User Manual
          • Developer Environment Setup for Online Banking App 2.0
      • Mobile Field Officer Applications
        • Android Client
          • User Manual
    • Fineract CN
      • Digital Bank User Interface
      • Mobile Field Officer Applications
        • Fineract CN Mobile
  • Customer UI Platforms
    • Fineract 1.x
      • Mobile Banking
        • Mifos Mobile
      • Mobile Wallets
      • Online Banking
    • Fineract CN
      • Mobile Banking
        • Fineract CN Mobile
        • Mifos Mobile CN
      • Mobile Wallets
      • Online Banking
  • Ancillary Tools
    • Fineract 1.x
      • Message Gateway
      • Mifos Passcode
      • PPI Vision
      • DevOps Tooling
      • Fineract Android SDK
      • MifosX Admin
      • Mifos ChatBot
      • Data Import Tool
    • Fineract CN
      • Fineract CN Containers
      • Fineract CN Terraform
  • Payment and Process Orchestration
    • Fineract 1.x
      • Payment Hub
      • Fineract Pentaho
    • Fineract CN
      • Staff Interfaces
        • Digital Bank UI
      • Customer Interfaces
        • Fineract CN Mobile
        • Mifos Mobile CN
        • Fineract CN Mobile
      • Ancillary Tools
        • Fineract CN Terraform
        • Fineract CN Containers
    • Payment Hub EE
Powered by GitBook
On this page
  • Creating an Advanced Accounting Rule
  • Applying an Advanced Accounting Rule

Was this helpful?

  1. MifosX
  2. User Manual
  3. For Operational Users (Mifos X Web App)
  4. Accounting operations

Advanced Accounting Rules

PreviousFrequent PostingsNextClosing Entries

Last updated 5 years ago

Was this helpful?

The Advanced Accounting Rule is a powerful feature that allows you to post to multiple general ledger accounts for a single product. Examples include mapping to multiple fund sources based on payment type, or mapping fees or penalties to specific income accounts.

Creating an Advanced Accounting Rule requires two steps:

Step 1: Configure Payment Types, Fees, and Penalties.

Step 2: Map Payment Type to fund sources and map Fees and Penalties to income sources.

Creating an Advanced Accounting Rule

You can create the following Advanced Accounting Rules for Loan Products:

Advanced Accounting Rules based on Payment Type to automatically debit accounts based on payment type—for example, m-pesa payments are automatically debited from the m-pesa account and check payments are automatically debited from a different account.

Advanced Accounting Rules based on Fees to automatically credit a specified Income Account based on the Fee—for example, processing fees are automatically credited to the Fees and Charges account.

Advanced Accounting Rules based on Penalties to automatically credit a specified Income Account based on the Penalty—for example, late fees are automatically credited to the Penalties account.

Step 1: Configure Payment Type, Fees, and Penalties

To configure Advanced Accounting Rules based on Payment Type:

To create an Advanced Accounting Rule based on Payment Type, you configure the Payment Types drop-down list in the Manage Codes section of Admin System tools. In the following example, m-pesa payments are automatically debited from the m-pesa account.

To configure an Advanced Accounting Rule based on Payment Type, do the following:

  1. On the Mifos toolbar, click Admin, and then click System to open the System menu.

2. On the System menu, click Manage Codes to open the Manage Codes dialog.

3. In Code Name list, select Payment Type.

4. In the Payment Type dialog, click +Add Code Values

5. In the Code value text box, enter a name for your payment type and then click +Add.

NOTE: To edit the code value, click the Edit Code Value button. To delete the code value, click the Delete Code Value button.

To configure Advanced Accounting Rules based on Fees:

To create an Advanced Accounting Rule based on Fees, you define a loan charge in the Charges section of the Admin Products tools. In the following example, processing fees are automatically credited to the Fees and Charges account.

To map Fees to specific Income Accounts, do the following:

  1. On the Mifos toolbar, click Admin, and then click Products to open the Products menu.

2. On the Products menu, click Charges.

3. In the Charges dialog, click the Create Charge button.

4. In the Charges applies to drop-down list, select a product.

5. In the Create Charge dialog, do the following:

a. In the Name textbox, enter a name for the Fee.

b. In the Currency drop-down list, select a currency.

c. In the Charge time type drop-down list, select a charge time type.

d. In the Charge calculation drop-down list, select a method for calculating the fee.

e. In the Charge payment by drop-down list, select a method for payment.

f. In the Amount textbox, enter the amount of the fee.

g. Select the Active check box, and then click the Submit button.

To configure Advanced Accounting Rules based on Penalties:

To create an Advanced Accounting Rule based on Penalties, you define a loan penalty in the Charges section of the Admin Products tools. In the following example, late fees are automatically credited to the Penalties account.

To map Penalties to specific Income Accounts, do the following:

  1. On the Mifos toolbar, click Admin, and then click Products to open the Products menu.

2. On the Products menu, click Charges.

3. In the Charges dialog, click the Create Charge button.

4. In the Charges applies to drop-down list, select a product.

5. In the Create Charge dialog, do the following:

a. In the Name textbox, enter a name for the penalty.

b. In the Currency drop-down list, select a currency.

c. In the Charge time type drop-down list, select a charge time type.

d. In the Charge calculation drop-down list, select a method for calculating the penalty.

e. In the Charge payment by drop-down list, select a method for payment.

f. Select the Add Fee Frequency check box.

g. In the Charge Frequency drop-down list, select the frequency (days, weeks, months, or years) to charge the penalty.

h. In the Frequency Interval textbox, type a number for the frequency interval.

i. In the Amount textbox, type the amount of the penalty.

j. Select the Active check box.

k. Select the Is Penalty check box, and then click the Submit button.

Step 2: Map Payment Type to fund sources, and map Fees and Penalties to income sources.

After you have configured your Payment Terms, Fees, and Penalties, you are ready to create your Advanced Accounting Rule.

To create an Advanced Accounting Rule based on Payment Type, Fees, or Penalties, do the following:

  1. On the Mifos toolbar, click Admin, and then click Products to open the Products menu.

2. On the Products menu, click Loan Products.

3. In Loan Products list, select the Loan Product to which you want to add an advanced accounting rule.

4. Click Edit.

5. Scroll to the bottom of the Loan Product dialog. Under Accounting, if None is selected, select one of the other options to expand the Accounting section.

6. At the bottom of the Accounting section, click show to expand Advanced Accounting Rules.

Under the expanded Advanced Accounting Rules, you can add Payment Type, Fees, or Penalties Advanced Accounting Rules:

a. To add a Payment Type Advanced Accounting Rule: Under Configure Fund Sources for Payment Channels click the Add button and then select a Payment Type and a Fund Source from the drop-down lists. Tip: To add Payment Types to the Payment Type drop-down list, see Advanced Accounting Rules based on Payment Type in Creating an Advanced Account Rule above.

b. To add a Fees Advanced Accounting Rule: Under Map Fees to Income Accounts, click the Add button and then select a Fee and an Income Account from the drop-down lists. Tip: To add Fees to the Fee drop-down list, see Advanced Accounting Rules based on Fees in Creating an Advanced Account Rule above.

c. To add a Penalties Advanced Accounting Rule: Under Map Penalties to Specific Income Accounts, click the Add button and then select a Penalty and an Income Account from the drop-down lists. Tip: To add Penalties to the Fee drop-down list, see Advanced Accounting Rules based on Penalties in Creating an Advanced Account Rule above.

Tip: To add another Payment Type, Fees, or Penalties Advanced Accounting Rule, click the Add button. To delete a Payment Type, Fees, or Penalties Advanced Accounting Rule, click the x button.

8. Click the Submit button. Your Advanced Accounting Rule for your Loan Product appears under Accounting at the bottom of the dialog.

Applying an Advanced Accounting Rule

Walk through normal transactions that reflect the advanced accounting rule being applied (that is. a transaction of a certain payment type being applied to a different general ledger account)

For each action, provide a short description, add the steps involved, include any relevant screenshots:

  1. Insert your steps.

  2. You can also copy and paste or drag and drop images into your instructions.

Field name (attribute)

Description

Example

Validations (if applicable)

Related articles

Page:

Page:

Page:

Page:

Page:

Closing Entries
Advanced Accounting Rules
Searching Accounting Transactions
Add Journal Entries
Accounting Rules