[Mifos-issues] [JIRA] (MIFOSX-2188) Easy bulk import of Chart of Accounts

Vishwas Babu A J (JIRA)

unread,

Sep 2, 2015, 3:00:11 PM9/2/15

to mifos-...@lists.sourceforge.net

Vishwas Babu A J created an issue

Mifos X /

MIFOSX-2188

Easy bulk import of Chart of Accounts

Issue Type:	New Feature
Assignee:	Unassigned
Created:	02/Sep/15 11:59 AM
Labels:	introductory volunteer
Priority:	Minor
Reporter:	Vishwas Babu A J

Possible approaches

a) Have the COA from our existing sample data also available as a separate SQL script . The target audience for this would be new FI's who are exploring accounting for the first time (one would expect any mature organization to have a pre-defined COA)

b) Create an Excel macro with a predefined template where Organization can fill in their COA and on click of button generate COA insert script which they can then run in their server (least time consuming)

c) Update the Data import tool to also allow creating COA (most useful for specialists doing small implementations)

d) Expose a new API in accounting which allows user to Download a pre-formatted excel sheet (with details of any existing accounts) and then upload the same using another API which takes care of internally calling Mifos API's (which would internally use the Batch API framework that Markus/Rishab developed)

Going this route means a step towards integrating the current Data import tool into the core Mifos codebase (which may be a good Idea as the data import tool can realistically be used only by very small Organizations, a data migration of any significant size would most likely be done by a specialist using a DI tool)

This would be the most usable for an end user....

Add Comment

This message was sent by Atlassian JIRA (v7.0.0-OD-02-259#70102-sha1:6147844)

Dayna Harp (JIRA)

unread,

Sep 2, 2015, 3:15:09 PM9/2/15

to mifos-...@lists.sourceforge.net

Dayna Harp commented on

MIFOSX-2188

Re: Easy bulk import of Chart of Accounts

I do not recommend pursuing option A. We can provide a sample chart of accounts in with our configuration guide, but it should not be our responsibility to name their general ledger accounts. The new FI should have someone available to make accounting recommendations - as a software company, Mifos should not be recommending accounting procedure.

If an organization already has their chart of accounts in an Excel format - what is the best method of uploading (migrating) that data into a new install?

Add Comment

Vishwas Babu A J (JIRA)

unread,

Sep 2, 2015, 3:27:10 PM9/2/15

to mifos-...@lists.sourceforge.net

Vishwas Babu A J updated an issue

Mifos X /

MIFOSX-2188

Easy bulk import of Chart of Accounts

Change By:	Vishwas Babu A J

Context :

{panel:title=Mail Thread}

This request comes in time and time again - we could likely spin up a simple task for volunteer to ship with a default CoA, no?

Is there a means to upload one after the fact via XML? Does our data import tool cover any of this?

Ed
---------- Forwarded message ----------
From: xxxxxxxxxxxxx
Date: Wed, Sep 2, 2015 at 11:13 AM
Subject: Chart of Accounts for Mifos
To: sang...@confluxtechnologies.com, Ed Cable <edc...@mifos.org>
Cc: xxxxxxxxx

Hi Sangamesh and Ed,

We are in fact looking to start using the accounting piece of Mifos and I was wondering if you all have a template that you could easily load into Mifos or if we have to create each account manually?

Or is there a way for me to upload it once I have created one in excel?

{panel}

Possible approaches

a) Have the COA from our existing sample data also available as a separate SQL script . The target audience for this would be new FI's who are exploring accounting for the first time (one would expect any mature organization to have a pre-defined COA)

b) Create an Excel macro with a predefined template where Organization can fill in their COA and on click of button generate COA insert script which they can then run in their server (least time consuming)

c) Update the Data import tool to also allow creating COA (most useful for specialists doing small implementations)

d) Expose a new API in accounting which allows user to Download a pre-formatted excel sheet (with details of any existing accounts) and then upload the same using another API which takes care of internally calling Mifos API's (which would internally use the Batch API framework that Markus/Rishab developed)

Going this route means a step towards integrating the current Data import tool into the core Mifos codebase (which may be a good Idea as the data import tool can realistically be used only by very small Organizations, a data migration of any significant size would most likely be done by a specialist using a DI tool)

This would be the most usable for an end user....