# Default COA sql script

insert into acc\_gl\_account values (1,'Deposit Accounts Portfolio',NULL,'.',10100,'0','1' ,'2',2,NULL,NULL); 

insert into acc\_gl\_account values (2,'Overpayment Liability',NULL,'.',10200,'0','1' ,'1',2,NULL,NULL); 

insert into acc\_gl\_account values (3,'Interest Payable',NULL,'.',10300,'0','1' ,'2',2,NULL,NULL); 

insert into acc\_gl\_account values (4,'Pass-Through Collections',NULL,'.',10400,'0','1' ,'2',2,NULL,NULL); 

insert into acc\_gl\_account values (5,'External Credits and Borrowings',NULL,'.',10500,'0','1' ,'2',2,NULL,NULL); 

insert into acc\_gl\_account values (6,'Accrued Expenses and Provisions',NULL,'.',10600,'0','1' ,'2',2,NULL,NULL); 

insert into acc\_gl\_account values (7,'Other Liabilities',NULL,'.',10700,'0','1' ,'2',2,NULL,NULL); 

insert into acc\_gl\_account values (8,'Fixed Assets',NULL,'.',20100,'0','1' ,'2',1,NULL,NULL); 

insert into acc\_gl\_account values (9,'Investments',NULL,'.',20200,'0','1' ,'2',1,NULL,NULL); 

insert into acc\_gl\_account values (10,'Cash',NULL,'.',20300,'0','1' ,'2',1,NULL,NULL); 

insert into acc\_gl\_account values (11,'Bank Accounts',NULL,'.',20400,'0','1' ,'2',1,NULL,NULL); 

insert into acc\_gl\_account values (12,'Lending Portfolio',NULL,'.',20500,'0','1' ,'2',1,NULL,NULL); 

insert into acc\_gl\_account values (13,'Interest and Fees Receivable',NULL,'.',20600,'0','1' ,'2',1,NULL,NULL); 

insert into acc\_gl\_account values (14,'Advance Payments',NULL,'.',20700,'0','1' ,'2',1,NULL,NULL); 

insert into acc\_gl\_account values (15,'Reserves for Possible Losses',NULL,'.',20800,'0','1' ,'2',1,NULL,NULL); 

insert into acc\_gl\_account values (16,'Accrued Income',NULL,'.',20900,'0','1' ,'2',1,NULL,NULL); 

insert into acc\_gl\_account values (17,'Suspense Account',NULL,'.',9999,'0','1' ,'1',1,NULL,NULL); insert into acc\_gl\_account values (18,'Portfolio Earnings',NULL,'.',30100,'0','1' ,'2',4,NULL,NULL); 

insert into acc\_gl\_account values (19,'Non Portfolio Income',NULL,'.',30200,'0','1' ,'2',4,NULL,NULL); 

insert into acc\_gl\_account values (20,'Portfolio Expenses',NULL,'.',40100,'0','1' ,'2',5,NULL,NULL); 

insert into acc\_gl\_account values (21,'General And Administrative Expenses',NULL,'.',40200,'0','1' ,'2',5,NULL,NULL); 

insert into acc\_gl\_account values (22,'Sundry Expenses',NULL,'.',40800,'0','1' ,'2',5,NULL,NULL); 

insert into acc\_gl\_account values (23,'Repairs and Maintenance',NULL,'.',40900,'0','1' ,'2',5,NULL,NULL); 

insert into acc\_gl\_account values (24,'Depreciation and Amortization',NULL,'.',41000,'0','1' ,'2',5,NULL,NULL); 

insert into acc\_gl\_account values (25,'Equity and Share Capital',NULL,'.',50100,'0','1' ,'2',3,NULL,NULL); 

insert into acc\_gl\_account values (26,'Opening Balances Contra Account',NULL,'.',9099,'0','1' ,'2',3,NULL,NULL); 

insert into acc\_gl\_account values (27,'Voluntary Savings',1,'.1.',10101,0,1,2,2,NULL,NULL); 

insert into acc\_gl\_account values (28,'Mandatory Savings',1,'.1.',10102,0,1,2,2,NULL,NULL); 

insert into acc\_gl\_account values (29,'Term Deposits',1,'.1.',10103,0,1,2,2,NULL,NULL); 

insert into acc\_gl\_account values (30,'Recurring Deposits',1,'.1.',10104,0,1,1,2,NULL,NULL); 

insert into acc\_gl\_account values (31,'Furniture and Fixtures',8,'.8.',20101,0,1,1,1,NULL,NULL); 

insert into acc\_gl\_account values (32,'Cash In Hand',10,'.10.',20301,0,1,1,1,NULL,NULL); 

insert into acc\_gl\_account values (33,'Petty Cash',10,'.10.',20302,0,1,1,1,NULL,NULL); 

insert into acc\_gl\_account values (34,'Loans to Customers',12,'.12.',20501,0,1,1,1,NULL,NULL); 

insert into acc\_gl\_account values (35,'Current Account Overdrafts',12,'.12.',20502,0,1,1,1,NULL,NULL); 

insert into acc\_gl\_account values (36,'Fees and Charges',18,'.18.',30101,0,1,1,4,NULL,NULL); 

insert into acc\_gl\_account values (37,'Penalties',18,'.18.',30102,0,1,1,4,NULL,NULL); 

insert into acc\_gl\_account values (38,'Interest Received from Borrowers',18,'.18.',30103,0,1,1,4,NULL,NULL); 

insert into acc\_gl\_account values (39,'Insurance Charges',18,'.18.',30104,0,1,1,4,NULL,NULL); 

insert into acc\_gl\_account values (40,'Other Operating Income',18,'.18.',30105,0,1,1,4,NULL,NULL); 

insert into acc\_gl\_account values (41,'Losses Written Off',20,'.20.',40101,0,1,1,5,NULL,NULL); 

insert into acc\_gl\_account values (42,'Interest Paid To Depositors',20,'.20.',40102,0,1,1,5,NULL,NULL); 

insert into acc\_gl\_account values (43,'Loan Collection Expenses',20,'.20.',40103,0,1,1,5,NULL,NULL); 

insert into acc\_gl\_account values (44,'Salaries and Wages',21,'.21.',40300,0,1,1,5,NULL,NULL); 

insert into acc\_gl\_account values (45,'Professional Expenses',21,'.21.',40400,0,1,1,5,NULL,NULL); 

insert into acc\_gl\_account values (46,'Travel and Conveyance Expenses',21,'.21.',40500,0,1,1,5,NULL,NULL); 

insert into acc\_gl\_account values (47,'Training Expenses',21,'.21.',40600,0,1,1,5,NULL,NULL); 

insert into acc\_gl\_account values (48,'Office Expenses',21,'.21.',40700,0,1,2,5,NULL,NULL); 

insert into acc\_gl\_account values (49,'Printing and Stationery',48,'.21.48.',40701,0,1,1,5,NULL,NULL); 

insert into acc\_gl\_account values (50,'Telephone Charges',48,'.21.48.',40702,0,1,1,5,NULL,NULL); 

insert into acc\_gl\_account values (51,'Electricity Charges',48,'.21.48.',40703,0,1,1,5,NULL,NULL); 

insert into acc\_gl\_account values (52,'Rent Paid',48,'.21.48.',40704,0,1,1,5,NULL,NULL); insert into acc\_gl\_account values (53,'Internet Charges',48,'.21.48.',40705,0,1,1,5,NULL,NULL); 

insert into acc\_gl\_account values (54,'Recovery Repayments',18,'.18.',30110,0,1,1,4,NULL,NULL); 

insert into acc\_gl\_account values (55,'Interest Receivable',NULL,'.',20601,'0','1' ,'1',1,NULL,NULL); 

insert into acc\_gl\_account values (56,'Fees Receivable',NULL,'.',20602,'0','1' ,'1',1,NULL,NULL); 

insert into acc\_gl\_account values (57,'Penalties Receivable',NULL,'.',20603,'0','1' ,'1',1,NULL,NULL);


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.mifos.org/mifosx/user-manual/for-administrators-mifos-x-platform/accounting/chart-of-accounts-general-ledger-setup/default-coa-sql-script.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.