Alian, Just to add to what Keith had sent, I have prepared xl, which can be used for generating CoA script. Please refer attached xl file
On Wed, Sep 18, 2013 at 11:20 PM, Nayan Ambali <[email protected]>wrote: > Thanks Keith, > > I did not had MIfosX setup in my local, I was trying to get it from demo. > > Thanks > Nayan Ambali > > > On Wed, Sep 18, 2013 at 11:15 PM, Keith Woodlock <[email protected] > > wrote: > >> Heres one i use that i passed on to Yanna for her XBRL work. Not saying >> its correct though or anything. >> >> >> truncate `acc_gl_account`; >> INSERT INTO `acc_gl_account` >> >> (`id`,`name`,`parent_id`,`gl_code`,`disabled`,`manual_journal_entries_allowed`,`account_usage`, >> `classification_enum`,`description`) VALUES >> (1,'Petty Cash Balances',NULL,'11100',0,1,2,1,NULL), >> (2,'Cash in Valut 1',NULL,'11101',0,1,1,1,NULL), >> (3,'Bank Balances',NULL,'11200',0,1,2,1,NULL), >> (4,'Centenary Opening Account',NULL,'11201',0,1,1,1,NULL), >> (5,'Centenary Expense Account',NULL,'11202',0,1,1,1,NULL), >> (6,'Centenary USD Account',NULL,'11203',0,1,1,1,NULL), >> (7,'Loans and Advances',NULL,'13100',0,1,2,1,NULL), >> (8,'Loans to Clients',NULL,'13101',0,1,1,1,NULL), >> (9,'Outstanding Interest',NULL,'13102',0,1,1,1,NULL), >> (10,'Outstanding Late Payment Interest',NULL,'13103',0,1,1,1,NULL), >> (11,'Outstanding Bank Fees to be collected',NULL,'13104',0,1,1,1,NULL), >> (12,'WriteOff Accounts',NULL,'13200',0,1,2,1,NULL), >> (13,'Write-offs (use for funds coming in)',NULL,'13201',0,1,1,1,NULL), >> (14,'Write-offs outstanding principal',NULL,'13202',0,1,1,1,NULL), >> (15,'Write-offs outstanding interest',NULL,'13203',0,1,1,1,NULL), >> (16,'Write-offs collected bank fees',NULL,'13204',0,1,1,1,NULL), >> (17,'Write-offs hardware/furniture',NULL,'13205',0,1,1,1,NULL), >> (18,'Fixed Assets',NULL,'14100',0,1,2,1,NULL), >> (19,'Office Equipment',NULL,'14101',0,1,1,1,NULL), >> (20,'Suspense Items (unidentified deposits)',NULL,'15000',0,1,2,1,NULL), >> (21,'Assets',NULL,'10000',0,1,2,1,NULL), >> (22,'Liabilities',NULL,'20000',0,1,2,2,NULL), >> (23,'Shares Account',NULL,'26100',0,1,2,2,NULL), >> (24,'Shares Captial',NULL,'26101',0,1,1,2,NULL), >> (25,'Donated Equity',NULL,'26300',0,1,2,2,NULL), >> (26,'Donated Equity Ameropa Foundation',NULL,'26301',0,1,1,2,NULL), >> (27,'Donated Equity e.h',NULL,'26302',0,1,1,2,NULL), >> (28,'Overpaid Amounts',NULL,'27000',0,1,2,2,NULL), >> (29,'Loss Provision',NULL,'28000',0,1,2,2,NULL), >> (30,'Provision Outstanding Principal',NULL,'28001',0,1,1,2,NULL), >> (31,'Provision Oustanding >> Interest',NULL,'28002',0,1,1,2,NULL),(32,'Income',NULL,'30000',0,1,2,4,NULL), >> (33,'Interest Income from Loans',NULL,'31100',0,1,2,4,NULL), >> (34,'Interest on Loans',NULL,'31101',0,1,1,4,NULL), >> (35,'Late Payment Interest',NULL,'31102',0,1,1,4,NULL), >> (36,'Income from Micro credit & Lending >> Activities',NULL,'31300',0,1,2,4,NULL), >> (37,'Collected Bank Fees Receivable',NULL,'6201',0,1,1,4,NULL), >> (38,'Deposits from Loans Write Off',NULL,'31400',0,1,2,4,NULL), >> (39,'Expenditure',NULL,'40000',0,1,2,5,NULL), >> (40,'Office Expenditure Account',NULL,'42100',0,1,2,5,NULL), >> (41,'Water Charges',NULL,'42102',0,1,1,5,NULL), >> (42,'Electricity Charges',NULL,'42103',0,1,1,5,NULL), >> (43,'Printing and Stationary',NULL,'42105',0,1,1,5,NULL), >> (44,'Office Rent',NULL,'42107',0,1,1,5,NULL), >> (45,'Marketing Expense',NULL,'42109',0,1,1,5,NULL), >> (46,'Office utilities',NULL,'42112',0,1,1,5,'(supplies, toiletries, >> kitchen)'), >> (47,'Furniture',NULL,'42113',0,1,1,5,NULL), >> (48,'CEDA Meeting Expense',NULL,'42114',0,1,1,5,NULL), >> (49,'Employee Personal Expsense Account',NULL,'42200',0,1,2,5,NULL), >> (50,'Salary Alice',NULL,'42201',0,1,1,5,NULL), >> (51,'Salary Irene',NULL,'42202',0,1,1,5,NULL), >> (52,'Salary Richard',NULL,'42203',0,1,1,5,NULL), >> (53,'Salary Loan Officer TBA',NULL,'42204',0,1,1,5,NULL), >> (54,'Medical Insurance Alice & Family',NULL,'42205',0,1,1,5,NULL), >> (55,'Medical Insurance Irene',NULL,'42206',0,1,1,5,NULL), >> (56,'Medical Insurance Richard',NULL,'42207',0,1,1,5,NULL), >> (57,'Medical Insurance Loan Officer TBA',NULL,'42208',0,1,1,5,NULL), >> (58,'PAYE all employees',NULL,'42209',0,1,1,5,NULL), >> (59,'NSSF all employees',NULL,'42210',0,1,1,5,NULL), >> (60,'Lunch Allowances all employees',NULL,'42211',0,1,1,5,NULL), >> (61,'IT software and maintenance',NULL,'42300',0,1,2,5,NULL), >> (62,'Mifos maintenance contract 12 months',NULL,'42301',0,1,1,5,NULL), >> (63,'VPS Contract 12 months',NULL,'42302',0,1,1,5,NULL), >> (64,'Bulk SMS Service',NULL,'42303',0,1,1,5,NULL), >> (65,'Support Accounting Software',NULL,'42304',0,1,1,5,NULL), >> (66,'Mifos Instance Setup',NULL,'42305',0,1,1,5,NULL), >> (67,'Misc support expense',NULL,'42306',0,1,1,5,NULL), >> (68,'Warid Mobile Line',NULL,'42307',0,1,1,5,NULL), >> (69,'Landline',NULL,'42308',0,1,1,5,NULL), >> (70,'Modem Alice',NULL,'42309',0,1,1,5,NULL), >> (71,'Modem Irene',NULL,'42310',0,1,1,5,NULL), >> (72,'Modem Richard',NULL,'42311',0,1,1,5,NULL), >> (73,'Repairs',NULL,'42312',0,1,1,5,NULL), >> (74,'Airtime Expenses',NULL,'42400',0,1,2,5,NULL), >> (75,'Airtime Alice',NULL,'42401',0,1,1,5,NULL), >> (76,'Airtime Richard',NULL,'42402',0,1,1,5,NULL), >> (77,'Airtime Loan Office TBA',NULL,'42403',0,1,1,5,NULL), >> (78,'Special Airtime Alice',NULL,'42404',0,1,1,5,NULL), >> (79,'Transportation',NULL,'42500',0,1,2,5,NULL), >> (80,'Flat monthly transportation cost',NULL,'42501',0,1,1,5,NULL), >> (81,'Faciliation cost for Richard',NULL,'42502',0,1,1,5,NULL), >> (82,'Faciliation cost for Loan Officer TBA',NULL,'42503',0,1,1,5,NULL), >> (83,'Consultancy Expenses',NULL,'42600',0,1,2,5,NULL), >> (84,'Audit Fees',NULL,'42601',0,1,1,5,NULL), >> (85,'Legal Fees',NULL,'42602',0,1,1,5,NULL), >> (86,'Miscellaneous Expenses Account',NULL,'42700',0,1,2,5,NULL), >> (87,'MFI License',NULL,'42703',0,1,1,5,NULL), >> (88,'Sundy Expenses',NULL,'42704',0,1,1,5,NULL), >> (89,'Bank Fees',NULL,'42800',0,1,2,5,NULL), >> (90,'Bank Charges Operating Account',NULL,'42801',0,1,1,5,NULL), >> (91,'Bank Charges Expense Account',NULL,'42802',0,1,1,5,NULL), >> (92,'E.H Account',NULL,'42900',0,1,2,5,NULL), >> (93,'Airtime',NULL,'42901',0,1,1,5,NULL), >> (94,'Modem',NULL,'42902',0,1,1,5,NULL), >> (95,'Meals',NULL,'42903',0,1,1,5,NULL), >> (96,'Transportation',NULL,'42904',0,1,1,5,NULL), >> (97,'Miscellaneous',NULL,'42905',0,1,1,5,NULL); >> >> >> On Wed, Sep 18, 2013 at 6:14 PM, Edward Cable <[email protected]> wrote: >> >>> Alain, >>> >>> Per our conversations to have a chart of accounts to import into Mifos >>> X, to save some of the initial upfront data entry, >>> >>> Nayan said he could export one via SQL script and then it can be >>> modified and imported it back in. >>> >>> Nayan will share details of this on this thread - might not be a full >>> chart of accounts but it will be a starting point. >>> >>> Thanks Nayan for all your help! >>> >>> Ed >>> >>> -- >>> *Ed Cable* >>> Mifos Community Manager >>> Director of Community Programs, The Community for Open Source >>> Microfinance >>> [email protected] | Skype: edcable | Mobile: 484.477.8649 >>> >>> *Collectively Creating a World of 3 Billion Maries | *http://openmf.org >>> <http://on.fb.me/cosm-openmf> >>> * * <http://www.twitter.com/mifos> >>> >>> >>> ------------------------------------------------------------------------------ >>> LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! >>> 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, >>> SharePoint >>> 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack >>> includes >>> Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. >>> >>> http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk >>> _______________________________________________ >>> Mifos-users mailing list >>> [email protected] >>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>> >>> >> >> >> -- >> regards, >> Keith Woodlock >> >> "Mifos X" Project Lead Developer/Architect, >> Dublin, Ireland. >> Skype: keith.woodlock >> IRC: keithw_ire >> >> >> ------------------------------------------------------------------------------ >> LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! >> 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, >> SharePoint >> 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack >> includes >> Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. >> >> http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk >> _______________________________________________ >> Mifos-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/mifos-users >> >> > > > -- > Regards > Nayan G. A. > 9901154134 > -- Regards Nayan G. A. 9901154134
CoA script builder.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
------------------------------------------------------------------------------ LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
_______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
