<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
use Illuminate\Support\Facades\DB;

class CreateOdooGlCodesTable extends Migration
{
    public function up()
    {
        if (!Schema::hasTable('odoo_gl_codes')) {
            Schema::create('odoo_gl_codes', function (Blueprint $table) {
                $table->increments('id');
                $table->string('gl_code', 50)->unique();
                $table->string('ledger_name');
                $table->string('gl_name');
                $table->boolean('is_active')->default(true);
                $table->timestamps();
            });

            // Seed all 590 GL codes from Odoo GL code master (GL Name = ledger_name, Description = gl_name)
            $initialGlCodes = [
                ['gl_code' => '142000', 'ledger_name' => 'Accrued Interest for Loans Due', 'gl_name' => 'Accrued Interest for Loans Due'],
                ['gl_code' => '142001', 'ledger_name' => 'Accrued Interest for Loans not Due', 'gl_name' => 'Accrued Interest for Loans not Due'],
                ['gl_code' => '109000', 'ledger_name' => 'Advance Tax AY - 17-18', 'gl_name' => 'Advance Tax AY - 17-18'],
                ['gl_code' => '109001', 'ledger_name' => 'Advance Tax AY - 18-19', 'gl_name' => 'Advance Tax AY - 18-19'],
                ['gl_code' => '109002', 'ledger_name' => 'Advance Tax AY - 19-20', 'gl_name' => 'Advance Tax AY - 19-20'],
                ['gl_code' => '109003', 'ledger_name' => 'Advance Tax AY - 20-21', 'gl_name' => 'Advance Tax AY - 20-21'],
                ['gl_code' => '109004', 'ledger_name' => 'Advance Tax AY - 21-22', 'gl_name' => 'Advance Tax AY - 21-22'],
                ['gl_code' => '109005', 'ledger_name' => 'Advance Tax AY - 22-23', 'gl_name' => 'Advance Tax AY - 22-23'],
                ['gl_code' => '109006', 'ledger_name' => 'Advance Tax AY - 23-24', 'gl_name' => 'Advance Tax AY - 23-24'],
                ['gl_code' => '109007', 'ledger_name' => 'Advance Tax AY - 24-25', 'gl_name' => 'Advance Tax AY - 24-25'],
                ['gl_code' => '109008', 'ledger_name' => 'Advance Tax AY - 25-26', 'gl_name' => 'Advance Tax AY - 25-26'],
                ['gl_code' => '109009', 'ledger_name' => 'Advance Tax AY - 26-27', 'gl_name' => 'Advance Tax AY - 26-27'],
                ['gl_code' => '109010', 'ledger_name' => 'Advance Tax AY - 27-28', 'gl_name' => 'Advance Tax AY - 27-28'],
                ['gl_code' => '100000', 'ledger_name' => 'Ausfbkurla_2402234055623607_Current_Hyd - Collection_A/C', 'gl_name' => 'Ausfbkurla_2402234055623607_Current_Hyd - Collection_A/C'],
                ['gl_code' => '100001', 'ledger_name' => 'Cash In Hand - Hyderabad', 'gl_name' => 'Cash In Hand - Hyderabad'],
                ['gl_code' => '100002', 'ledger_name' => 'Fedbanjara_18430200004462_Current_Partnership - Collection - Hyd_A/C', 'gl_name' => 'Fedbanjara_18430200004462_Current_Partnership - Collection - Hyd_A/C'],
                ['gl_code' => '100003', 'ledger_name' => 'Fedbanjara_18430200004470_Current_Partnership - Collection - Hyd_A/C', 'gl_name' => 'Fedbanjara_18430200004470_Current_Partnership - Collection - Hyd_A/C'],
                ['gl_code' => '100004', 'ledger_name' => 'Fedbanjara_18430200004488_Current_Partnership - Collection - Hyd_A/C', 'gl_name' => 'Fedbanjara_18430200004488_Current_Partnership - Collection - Hyd_A/C'],
                ['gl_code' => '100005', 'ledger_name' => 'Fedbanjara_18430200004496_Current_Partnership - Collection - Hyd_A/C', 'gl_name' => 'Fedbanjara_18430200004496_Current_Partnership - Collection - Hyd_A/C'],
                ['gl_code' => '100006', 'ledger_name' => 'Fedbanjara_18430200004504_Current_Hyd - Collection_A/C', 'gl_name' => 'Fedbanjara_18430200004504_Current_Hyd - Collection_A/C'],
                ['gl_code' => '100007', 'ledger_name' => 'Fedbanjara_18430200005188_Escrow_Partnership - Disbursement - Hyd_A/C', 'gl_name' => 'Fedbanjara_18430200005188_Escrow_Partnership - Disbursement - Hyd_A/C'],
                ['gl_code' => '100008', 'ledger_name' => 'Fedbanjara_18430200005196_Escrow_Partnership - Collection - Hyd_A/C', 'gl_name' => 'Fedbanjara_18430200005196_Escrow_Partnership - Collection - Hyd_A/C'],
                ['gl_code' => '100009', 'ledger_name' => 'Fedbanjara_18435500000383_Od_Hyd - Disbursement _A/C', 'gl_name' => 'Fedbanjara_18435500000383_Od_Hyd - Disbursement _A/C'],
                ['gl_code' => '100010', 'ledger_name' => 'Hsbcsomajiguda_082653254001_Current_Hyd - Disbursement _A/C', 'gl_name' => 'Hsbcsomajiguda_082653254001_Current_Hyd - Disbursement _A/C'],
                ['gl_code' => '100011', 'ledger_name' => 'Icicibegumpet_018305002658_Current_Hyd - Collection_A/C', 'gl_name' => 'Icicibegumpet_018305002658_Current_Hyd - Collection_A/C'],
                ['gl_code' => '100012', 'ledger_name' => 'Idfcaurobindo_10269922899_Escrow_Hyd - Collection_A/C', 'gl_name' => 'Idfcaurobindo_10269922899_Escrow_Hyd - Collection_A/C'],
                ['gl_code' => '100013', 'ledger_name' => 'Idfcjubilee_10040775410_Current_Hyd - Collection_A/C', 'gl_name' => 'Idfcjubilee_10040775410_Current_Hyd - Collection_A/C'],
                ['gl_code' => '100014', 'ledger_name' => 'Idfcjubilee_10058674377_Current_Hyd - Share Application_A/C', 'gl_name' => 'Idfcjubilee_10058674377_Current_Hyd - Share Application_A/C'],
                ['gl_code' => '100015', 'ledger_name' => 'Indusbanjara_201000592715_Current_Hyd - Expenses_A/C', 'gl_name' => 'Indusbanjara_201000592715_Current_Hyd - Expenses_A/C'],
                ['gl_code' => '100016', 'ledger_name' => 'Indusbanjara_201008045547_Current_Hyd - Collection_A/C', 'gl_name' => 'Indusbanjara_201008045547_Current_Hyd - Collection_A/C'],
                ['gl_code' => '100017', 'ledger_name' => 'Indusbanjara_201029798985_Current_Partnership - Collection - Hyd_A/C', 'gl_name' => 'Indusbanjara_201029798985_Current_Partnership - Collection - Hyd_A/C'],
                ['gl_code' => '100018', 'ledger_name' => 'Indusbanjara_201029798994_Current_Partnership - Collection - Hyd_A/C', 'gl_name' => 'Indusbanjara_201029798994_Current_Partnership - Collection - Hyd_A/C'],
                ['gl_code' => '100019', 'ledger_name' => 'Indusbanjara_201032696465_Escrow_Partnership - Collection - Hyd_A/C', 'gl_name' => 'Indusbanjara_201032696465_Escrow_Partnership - Collection - Hyd_A/C'],
                ['gl_code' => '100020', 'ledger_name' => 'Indusbanjara_201032696474_Escrow_Partnership - Disbursement - Hyd_A/C', 'gl_name' => 'Indusbanjara_201032696474_Escrow_Partnership - Disbursement - Hyd_A/C'],
                ['gl_code' => '100021', 'ledger_name' => 'Indusbanjara_650014065728_Od_Hyd - Disbursement _A/C', 'gl_name' => 'Indusbanjara_650014065728_Od_Hyd - Disbursement _A/C'],
                ['gl_code' => '100022', 'ledger_name' => 'IndusInd Bank - ESCROW A/C 201001628457', 'gl_name' => 'IndusInd Bank - ESCROW A/C 201001628457'],
                ['gl_code' => '100023', 'ledger_name' => 'Indusmalviya_201029799009_Current_Partnership - Collection - Hyd_A/C', 'gl_name' => 'Indusmalviya_201029799009_Current_Partnership - Collection - Hyd_A/C'],
                ['gl_code' => '100024', 'ledger_name' => 'Yesmadhapur_018366200000332_Escrow_Hyd - Collection_A/C', 'gl_name' => 'Yesmadhapur_018366200000332_Escrow_Hyd - Collection_A/C'],
                ['gl_code' => '100025', 'ledger_name' => 'Yesmadhapur_018366200000362_Escrow_Hyd - Disbursement _A/C', 'gl_name' => 'Yesmadhapur_018366200000362_Escrow_Hyd - Disbursement _A/C'],
                ['gl_code' => '100026', 'ledger_name' => 'Yesworli_000166200003291_Escrow_Hyd - Disbursement _A/C', 'gl_name' => 'Yesworli_000166200003291_Escrow_Hyd - Disbursement _A/C'],
                ['gl_code' => '100027', 'ledger_name' => 'Yesworli_000166200003301_Escrow_Hyd - Collection_A/C', 'gl_name' => 'Yesworli_000166200003301_Escrow_Hyd - Collection_A/C'],
                ['gl_code' => '100028', 'ledger_name' => 'Yes Bank - Navadhan Disbursement A/c - 011766200000162', 'gl_name' => 'Yes Bank - Navadhan Disbursement A/c - 011766200000162'],
                ['gl_code' => '100029', 'ledger_name' => 'Yes Bank - Navadhan Collection A/c - 011766200000174', 'gl_name' => 'Yes Bank - Navadhan Collection A/c - 011766200000174'],
                ['gl_code' => '100030', 'ledger_name' => 'Cash (Forex)', 'gl_name' => 'Cash (Forex)'],
                ['gl_code' => '103000', 'ledger_name' => 'Axission_918020055996554__Collection_Mum_A/C', 'gl_name' => 'Axission_918020055996554__Collection_Mum_A/C'],
                ['gl_code' => '103001', 'ledger_name' => 'Cash In Hand - Mumbai', 'gl_name' => 'Cash In Hand - Mumbai'],
                ['gl_code' => '103002', 'ledger_name' => 'Fedfort_10990200086882__Combined_Mum_A/C', 'gl_name' => 'Fedfort_10990200086882__Combined_Mum_A/C'],
                ['gl_code' => '103003', 'ledger_name' => 'Fedfort_10990200086924_Non Operative_Combined_Mum_A/C', 'gl_name' => 'Fedfort_10990200086924_Non Operative_Combined_Mum_A/C'],
                ['gl_code' => '103004', 'ledger_name' => 'Fedfort_10990200087310__Ncd_Mum_A/C', 'gl_name' => 'Fedfort_10990200087310__Ncd_Mum_A/C'],
                ['gl_code' => '103005', 'ledger_name' => 'Hdfcfort_00602000014344__Expenses_Mum_A/C', 'gl_name' => 'Hdfcfort_00602000014344__Expenses_Mum_A/C'],
                ['gl_code' => '103006', 'ledger_name' => 'Hdfcfort_50200023081500__Ncd Expenses_Mum_A/C', 'gl_name' => 'Hdfcfort_50200023081500__Ncd Expenses_Mum_A/C'],
                ['gl_code' => '103007', 'ledger_name' => 'Icicimumbai_020905007683__Collection_Mum_A/C', 'gl_name' => 'Icicimumbai_020905007683__Collection_Mum_A/C'],
                ['gl_code' => '103008', 'ledger_name' => 'Idfcbkc_10245910063__Udhyam - Expenses_Mum_A/C', 'gl_name' => 'Idfcbkc_10245910063__Udhyam - Expenses_Mum_A/C'],
                ['gl_code' => '103009', 'ledger_name' => 'Indusopera_650014152316__Disbursement_Mum_A/C', 'gl_name' => 'Indusopera_650014152316__Disbursement_Mum_A/C'],
                ['gl_code' => '103010', 'ledger_name' => 'Iobopera_014002000004296__Collection_Mum_A/C', 'gl_name' => 'Iobopera_014002000004296__Collection_Mum_A/C'],
                ['gl_code' => '103011', 'ledger_name' => 'Sbiwagle_41541767535__Collection_Mum_A/C', 'gl_name' => 'Sbiwagle_41541767535__Collection_Mum_A/C'],
                ['gl_code' => '103012', 'ledger_name' => 'Sbiwagle_42473137241__Disbursement_Mum_A/C', 'gl_name' => 'Sbiwagle_42473137241__Disbursement_Mum_A/C'],
                ['gl_code' => '103013', 'ledger_name' => 'Sbmmumbai_20012523060588__Collection_Mum_A/C', 'gl_name' => 'Sbmmumbai_20012523060588__Collection_Mum_A/C'],
                ['gl_code' => '103014', 'ledger_name' => 'Yesworli_000181300007990__Collection_Mum_A/C', 'gl_name' => 'Yesworli_000181300007990__Collection_Mum_A/C'],
                ['gl_code' => '103015', 'ledger_name' => 'Yesworli_000181300008227__Salary_Mum_A/C', 'gl_name' => 'Yesworli_000181300008227__Salary_Mum_A/C'],
                ['gl_code' => '103016', 'ledger_name' => 'Yesworli_000181300008257__Ncd Expenses_Mum_A/C', 'gl_name' => 'Yesworli_000181300008257__Ncd Expenses_Mum_A/C'],
                ['gl_code' => '103017', 'ledger_name' => 'DSRA (DSRABCPL)', 'gl_name' => 'DSRA (DSRABCPL)'],
                ['gl_code' => '106000', 'ledger_name' => 'Cash In Hand - Gurgaon', 'gl_name' => 'Cash In Hand - Gurgaon'],
                ['gl_code' => '106001', 'ledger_name' => 'Federal Bank_10990200094621_Collection_Wcl_A/C', 'gl_name' => 'Federal Bank_10990200094621_Collection_Wcl_A/C'],
                ['gl_code' => '106002', 'ledger_name' => 'Hdfc Bank_59202090865626_Collection_Wcl_A/C', 'gl_name' => 'Hdfc Bank_59202090865626_Collection_Wcl_A/C'],
                ['gl_code' => '106003', 'ledger_name' => 'Hdfc Bank_59206265220908_Disbursement _Wcl_A/C', 'gl_name' => 'Hdfc Bank_59206265220908_Disbursement _Wcl_A/C'],
                ['gl_code' => '106004', 'ledger_name' => 'Icici Bank_768805000110_Disbursement _Wcl_A/C', 'gl_name' => 'Icici Bank_768805000110_Disbursement _Wcl_A/C'],
                ['gl_code' => '106005', 'ledger_name' => 'Icici Bank_768805000111_Collection_Wcl_A/C', 'gl_name' => 'Icici Bank_768805000111_Collection_Wcl_A/C'],
                ['gl_code' => '106006', 'ledger_name' => 'Razorpay_Collection_Wcl_A/C', 'gl_name' => 'Razorpay_Collection_Wcl_A/C'],
                ['gl_code' => '106007', 'ledger_name' => 'Razorpay_Icic_Disbursement_Wcl_A/C', 'gl_name' => 'Razorpay_Icic_Disbursement_Wcl_A/C'],
                ['gl_code' => '106008', 'ledger_name' => 'Yes Bank_000166200003291_Disbursement Escrow_Wcl_A/C', 'gl_name' => 'Yes Bank_000166200003291_Disbursement Escrow_Wcl_A/C'],
                ['gl_code' => '106009', 'ledger_name' => 'Yes Bank_000166200003301_Collection Escrow_Wcl_A/C', 'gl_name' => 'Yes Bank_000166200003301_Collection Escrow_Wcl_A/C'],
                ['gl_code' => '106010', 'ledger_name' => 'Yes Bank_000181300008237_Collection_Wcl_A/C', 'gl_name' => 'Yes Bank_000181300008237_Collection_Wcl_A/C'],
                ['gl_code' => '106011', 'ledger_name' => 'Yes Bank_000181300008247_Collection_Wcl_A/C', 'gl_name' => 'Yes Bank_000181300008247_Collection_Wcl_A/C'],
                ['gl_code' => '112000', 'ledger_name' => 'Accrued interest on Fixed Deposit -Current', 'gl_name' => 'Accrued interest on Fixed Deposit -Current'],
                ['gl_code' => '112001', 'ledger_name' => 'Alternative investment fund (AIF) -Current', 'gl_name' => 'Alternative investment fund (AIF) -Current'],
                ['gl_code' => '112002', 'ledger_name' => 'Associates -Current', 'gl_name' => 'Associates -Current'],
                ['gl_code' => '112003', 'ledger_name' => 'Commercial Paper -Current', 'gl_name' => 'Commercial Paper -Current'],
                ['gl_code' => '112004', 'ledger_name' => 'Equity shares -Current', 'gl_name' => 'Equity shares -Current'],
                ['gl_code' => '112005', 'ledger_name' => 'Fixed Deposit -Current', 'gl_name' => 'Fixed Deposit -Current'],
                ['gl_code' => '112006', 'ledger_name' => 'Mutual funds -Current', 'gl_name' => 'Mutual funds -Current'],
                ['gl_code' => '112007', 'ledger_name' => 'Non convertible debentures (NCD) -Current', 'gl_name' => 'Non convertible debentures (NCD) -Current'],
                ['gl_code' => '112008', 'ledger_name' => 'Preference shares -Current', 'gl_name' => 'Preference shares -Current'],
                ['gl_code' => '112009', 'ledger_name' => 'Share warrants -Current', 'gl_name' => 'Share warrants -Current'],
                ['gl_code' => '112010', 'ledger_name' => 'Subsidiaries - Complusorily Convertible Preference shares -Current', 'gl_name' => 'Subsidiaries - Complusorily Convertible Preference shares -Current'],
                ['gl_code' => '112011', 'ledger_name' => 'Subsidiaries - Equity -Current', 'gl_name' => 'Subsidiaries - Equity -Current'],
                ['gl_code' => '112012', 'ledger_name' => 'Venture capital funds -Current', 'gl_name' => 'Venture capital funds -Current'],
                ['gl_code' => '145000', 'ledger_name' => 'Sundry Debtors', 'gl_name' => 'Sundry Debtors'],
                ['gl_code' => '127000', 'ledger_name' => 'Deferred Tax - Asset', 'gl_name' => 'Deferred Tax - Asset'],
                ['gl_code' => '121000', 'ledger_name' => 'Accumulated Depreciation Computer Software', 'gl_name' => 'Accumulated Depreciation Computer Software'],
                ['gl_code' => '121001', 'ledger_name' => 'Accumulated Depreciation Goodwill', 'gl_name' => 'Accumulated Depreciation Goodwill'],
                ['gl_code' => '121002', 'ledger_name' => 'Computer Software', 'gl_name' => 'Computer Software'],
                ['gl_code' => '121003', 'ledger_name' => 'Goodwill', 'gl_name' => 'Goodwill'],
                ['gl_code' => '121004', 'ledger_name' => 'Intangibles under Development', 'gl_name' => 'Intangibles under Development'],
                ['gl_code' => '130000', 'ledger_name' => 'Deferred Guarantee fee - Caspian Impact - Guarantee Fee (Arthan) -3rd year', 'gl_name' => 'Deferred Guarantee fee - Caspian Impact - Guarantee Fee (Arthan) -3rd year'],
                ['gl_code' => '130001', 'ledger_name' => 'Loans and Advances', 'gl_name' => 'Loans and Advances'],
                ['gl_code' => '130002', 'ledger_name' => 'NPA - Loans', 'gl_name' => 'NPA - Loans'],
                ['gl_code' => '130003', 'ledger_name' => 'Written Off - Loans', 'gl_name' => 'Written Off - Loans'],
                ['gl_code' => '148000', 'ledger_name' => 'MAT Credit Entitlement Receivable - FY 2013-14', 'gl_name' => 'MAT Credit Entitlement Receivable - FY 2013-14'],
                ['gl_code' => '148001', 'ledger_name' => 'MAT Credit Entitlement Receivable - FY 2014-15', 'gl_name' => 'MAT Credit Entitlement Receivable - FY 2014-15'],
                ['gl_code' => '148002', 'ledger_name' => 'MAT Credit Entitlement Receivable - FY 2017-18', 'gl_name' => 'MAT Credit Entitlement Receivable - FY 2017-18'],
                ['gl_code' => '148003', 'ledger_name' => 'MAT Credit Entitlement Receivable - FY 2018-19', 'gl_name' => 'MAT Credit Entitlement Receivable - FY 2018-19'],
                ['gl_code' => '148004', 'ledger_name' => 'MAT Credit Entitlement Receivable - FY 2019-20', 'gl_name' => 'MAT Credit Entitlement Receivable - FY 2019-20'],
                ['gl_code' => '148005', 'ledger_name' => 'MAT Credit Entitlement Receivable - FY 2020-21', 'gl_name' => 'MAT Credit Entitlement Receivable - FY 2020-21'],
                ['gl_code' => '148006', 'ledger_name' => 'MAT Credit Entitlement Receivable - FY 2022-23', 'gl_name' => 'MAT Credit Entitlement Receivable - FY 2022-23'],
                ['gl_code' => '148007', 'ledger_name' => 'MAT Credit Entitlement Receivable - FY 2023-2024', 'gl_name' => 'MAT Credit Entitlement Receivable - FY 2023-2024'],
                ['gl_code' => '148008', 'ledger_name' => 'MAT Credit Entitlement Receivable - FY 2024-2025', 'gl_name' => 'MAT Credit Entitlement Receivable - FY 2024-2025'],
                ['gl_code' => '133000', 'ledger_name' => 'Accrued interest on Fixed Deposit - Non - Current', 'gl_name' => 'Accrued interest on Fixed Deposit - Non - Current'],
                ['gl_code' => '133001', 'ledger_name' => 'Alternative investment fund (AIF) -Non - Current', 'gl_name' => 'Alternative investment fund (AIF) -Non - Current'],
                ['gl_code' => '133002', 'ledger_name' => 'Associates -Non - Current', 'gl_name' => 'Associates -Non - Current'],
                ['gl_code' => '133003', 'ledger_name' => 'Commercial Paper -Non - Current', 'gl_name' => 'Commercial Paper -Non - Current'],
                ['gl_code' => '133004', 'ledger_name' => 'Equity shares -Non - Current', 'gl_name' => 'Equity shares -Non - Current'],
                ['gl_code' => '133005', 'ledger_name' => 'Fixed Deposit -Non - Current', 'gl_name' => 'Fixed Deposit -Non - Current'],
                ['gl_code' => '133006', 'ledger_name' => 'Mutual funds -Non - Current', 'gl_name' => 'Mutual funds -Non - Current'],
                ['gl_code' => '133007', 'ledger_name' => 'Non convertible debentures (NCD) -Non - Current', 'gl_name' => 'Non convertible debentures (NCD) -Non - Current'],
                ['gl_code' => '133008', 'ledger_name' => 'Preference shares -Non - Current', 'gl_name' => 'Preference shares -Non - Current'],
                ['gl_code' => '133009', 'ledger_name' => 'Share warrants -Non - Current', 'gl_name' => 'Share warrants -Non - Current'],
                ['gl_code' => '133010', 'ledger_name' => 'Subsidiaries - Complusorily Convertible Preference shares -Non - Current', 'gl_name' => 'Subsidiaries - Complusorily Convertible Preference shares -Non - Current'],
                ['gl_code' => '133011', 'ledger_name' => 'Subsidiaries - Equity -Non - Current', 'gl_name' => 'Subsidiaries - Equity -Non - Current'],
                ['gl_code' => '133012', 'ledger_name' => 'Venture capital funds -Non - Current', 'gl_name' => 'Venture capital funds -Non - Current'],
                ['gl_code' => '133013', 'ledger_name' => 'Provision for Impairment- STPL', 'gl_name' => 'Provision for Impairment- STPL'],
                ['gl_code' => '136000', 'ledger_name' => 'Amortization Expenses - GMS fee - Finreach Solutions Pvt Ltd (Arthan-3)', 'gl_name' => 'Amortization Expenses - GMS fee - Finreach Solutions Pvt Ltd (Arthan-3)'],
                ['gl_code' => '136001', 'ledger_name' => 'Amortization on Upfront Fee guarantee  (Digivriddhi Technologies Pvt Ltd (5000010300332)) - Stichting Rabo Foundation (RF Asia CII 2025 TL / PR-50140)', 'gl_name' => 'Amortization on Upfront Fee guarantee  (Digivriddhi Technologies Pvt Ltd (5000010300332)) - Stichting Rabo Foundation (RF Asia CII 2025 TL / PR-50140)'],
                ['gl_code' => '136002', 'ledger_name' => 'Amortization on Upfront Fee guarantee 029209 - Stichting Rabo Foundation (RTGI22T01841)', 'gl_name' => 'Amortization on Upfront Fee guarantee 029209 - Stichting Rabo Foundation (RTGI22T01841)'],
                ['gl_code' => '136003', 'ledger_name' => 'Amortization on Upfront Fee guarantee 50508 (Iora Ecological (loan no:500001080244)) - Stichting Rabo Foundation (RTGI25T0128)', 'gl_name' => 'Amortization on Upfront Fee guarantee 50508 (Iora Ecological (loan no:500001080244)) - Stichting Rabo Foundation (RTGI25T0128)'],
                ['gl_code' => '115000', 'ledger_name' => 'Advance to Vendors', 'gl_name' => 'Advance to Vendors'],
                ['gl_code' => '115001', 'ledger_name' => 'Prepaid Expense', 'gl_name' => 'Prepaid Expense'],
                ['gl_code' => '115002', 'ledger_name' => 'Penal Charges- Receivable - Co Lending', 'gl_name' => 'Penal Charges- Receivable - Co Lending'],
                ['gl_code' => '115003', 'ledger_name' => 'Subvention Charges receivable', 'gl_name' => 'Subvention Charges receivable'],
                ['gl_code' => '115004', 'ledger_name' => 'Penal Charges Receivable', 'gl_name' => 'Penal Charges Receivable'],
                ['gl_code' => '115005', 'ledger_name' => 'Other Default Charges Receivable', 'gl_name' => 'Other Default Charges Receivable'],
                ['gl_code' => '115006', 'ledger_name' => 'Foreclosure Charges Receivable', 'gl_name' => 'Foreclosure Charges Receivable'],
                ['gl_code' => '115007', 'ledger_name' => 'Employee Advance', 'gl_name' => 'Employee Advance'],
                ['gl_code' => '115008', 'ledger_name' => 'Other Advances - SSN IPE Advance', 'gl_name' => 'Other Advances - SSN IPE Advance'],
                ['gl_code' => '151000', 'ledger_name' => 'Loan to Staff', 'gl_name' => 'Loan to Staff'],
                ['gl_code' => '151001', 'ledger_name' => 'Other Receivables', 'gl_name' => 'Other Receivables'],
                ['gl_code' => '151002', 'ledger_name' => 'Stamp duty reimbursement Receivable', 'gl_name' => 'Stamp duty reimbursement Receivable'],
                ['gl_code' => '151003', 'ledger_name' => 'Tds Recoverable From  Mercedes Benz', 'gl_name' => 'Tds Recoverable From  Mercedes Benz'],
                ['gl_code' => '151004', 'ledger_name' => 'Tds Recoverable From Amazon', 'gl_name' => 'Tds Recoverable From Amazon'],
                ['gl_code' => '139000', 'ledger_name' => 'Gurgoan office- rent deposit', 'gl_name' => 'Gurgoan office- rent deposit'],
                ['gl_code' => '139001', 'ledger_name' => 'Rent Deposit - APIDC - Venture Capital', 'gl_name' => 'Rent Deposit - APIDC - Venture Capital'],
                ['gl_code' => '139002', 'ledger_name' => 'Security Deposit - 1203 - Lodha Supremus', 'gl_name' => 'Security Deposit - 1203 - Lodha Supremus'],
                ['gl_code' => '139003', 'ledger_name' => 'Security Deposit - 91Springboard', 'gl_name' => 'Security Deposit - 91Springboard'],
                ['gl_code' => '139004', 'ledger_name' => 'Security Deposit - Antarctica Trading Co - Peninsula office', 'gl_name' => 'Security Deposit - Antarctica Trading Co - Peninsula office'],
                ['gl_code' => '139005', 'ledger_name' => 'Security Deposit - Custodial Fee - CDSL', 'gl_name' => 'Security Deposit - Custodial Fee - CDSL'],
                ['gl_code' => '139006', 'ledger_name' => 'Security Deposit - Hanuma Marketing', 'gl_name' => 'Security Deposit - Hanuma Marketing'],
                ['gl_code' => '139007', 'ledger_name' => 'Security Deposit - Muhavra Enterprises - chaipoint', 'gl_name' => 'Security Deposit - Muhavra Enterprises - chaipoint'],
                ['gl_code' => '139008', 'ledger_name' => 'Security Deposit - Oyo Workspaces - Delhi office', 'gl_name' => 'Security Deposit - Oyo Workspaces - Delhi office'],
                ['gl_code' => '139009', 'ledger_name' => 'Security Deposit - OYO Workspaces India Pvt Ltd', 'gl_name' => 'Security Deposit - OYO Workspaces India Pvt Ltd'],
                ['gl_code' => '139010', 'ledger_name' => 'Security Deposit - Raju Enterprises', 'gl_name' => 'Security Deposit - Raju Enterprises'],
                ['gl_code' => '139011', 'ledger_name' => 'Security Deposit - VV Copiers', 'gl_name' => 'Security Deposit - VV Copiers'],
                ['gl_code' => '139012', 'ledger_name' => 'Security Deposit -AWFIS - rent deposit - Gurgaon', 'gl_name' => 'Security Deposit -AWFIS - rent deposit - Gurgaon'],
                ['gl_code' => '139013', 'ledger_name' => 'Security Deposit -Peninsula Corporate Park - Mumbai', 'gl_name' => 'Security Deposit -Peninsula Corporate Park - Mumbai'],
                ['gl_code' => '139014', 'ledger_name' => 'Security deposit: AWFIS -Rent Security Deposit', 'gl_name' => 'Security deposit: AWFIS -Rent Security Deposit'],
                ['gl_code' => '124000', 'ledger_name' => 'Accumulated Depreciation Computers and servers', 'gl_name' => 'Accumulated Depreciation Computers and servers'],
                ['gl_code' => '124001', 'ledger_name' => 'Accumulated Depreciation Furniture and fixtures', 'gl_name' => 'Accumulated Depreciation Furniture and fixtures'],
                ['gl_code' => '124002', 'ledger_name' => 'Accumulated Depreciation Leasehold Improvements', 'gl_name' => 'Accumulated Depreciation Leasehold Improvements'],
                ['gl_code' => '124003', 'ledger_name' => 'Accumulated Depreciation Office equipments', 'gl_name' => 'Accumulated Depreciation Office equipments'],
                ['gl_code' => '124004', 'ledger_name' => 'Accumulated Depreciation Vehicles', 'gl_name' => 'Accumulated Depreciation Vehicles'],
                ['gl_code' => '124005', 'ledger_name' => 'Computers and servers', 'gl_name' => 'Computers and servers'],
                ['gl_code' => '124006', 'ledger_name' => 'Furniture and fixtures', 'gl_name' => 'Furniture and fixtures'],
                ['gl_code' => '124007', 'ledger_name' => 'Leasehold Improvements', 'gl_name' => 'Leasehold Improvements'],
                ['gl_code' => '124008', 'ledger_name' => 'Office equipments', 'gl_name' => 'Office equipments'],
                ['gl_code' => '124009', 'ledger_name' => 'Vehicles', 'gl_name' => 'Vehicles'],
                ['gl_code' => '154000', 'ledger_name' => 'Income Tax Refund Receivable - AY 2025-26', 'gl_name' => 'Income Tax Refund Receivable - AY 2025-26'],
                ['gl_code' => '154001', 'ledger_name' => 'TDS Excess paid - Caspian', 'gl_name' => 'TDS Excess paid - Caspian'],
                ['gl_code' => '157000', 'ledger_name' => 'TDS Gross Receivable on Loans - FY24_25', 'gl_name' => 'TDS Gross Receivable on Loans - FY24_25'],
                ['gl_code' => '157001', 'ledger_name' => 'TDS Gross Receivable on Loans - FY25_26', 'gl_name' => 'TDS Gross Receivable on Loans - FY25_26'],
                ['gl_code' => '157002', 'ledger_name' => 'TDS Gross Receivable on Loans - FY26 _27', 'gl_name' => 'TDS Gross Receivable on Loans - FY26 _27'],
                ['gl_code' => '157004', 'ledger_name' => 'TDS on FD Net Receivable - FY26 _27', 'gl_name' => 'TDS on FD Net Receivable - FY26 _27'],
                ['gl_code' => '157005', 'ledger_name' => 'TDS on Loans Net Receivable - FY26 _27', 'gl_name' => 'TDS on Loans Net Receivable - FY26 _27'],
                ['gl_code' => '157006', 'ledger_name' => 'TDS on SMBL FY21-22', 'gl_name' => 'TDS on SMBL FY21-22'],
                ['gl_code' => '157007', 'ledger_name' => 'TDS on SMBL FY22-23', 'gl_name' => 'TDS on SMBL FY22-23'],
                ['gl_code' => '157008', 'ledger_name' => 'TDS receivable - Caspian', 'gl_name' => 'TDS receivable - Caspian'],
                ['gl_code' => '157009', 'ledger_name' => 'TDS Receivable - FY16 _17', 'gl_name' => 'TDS Receivable - FY16 _17'],
                ['gl_code' => '157010', 'ledger_name' => 'TDS Receivable - FY17 _18', 'gl_name' => 'TDS Receivable - FY17 _18'],
                ['gl_code' => '157011', 'ledger_name' => 'TDS Receivable - FY18 _19', 'gl_name' => 'TDS Receivable - FY18 _19'],
                ['gl_code' => '157012', 'ledger_name' => 'TDS Receivable - FY19 _20', 'gl_name' => 'TDS Receivable - FY19 _20'],
                ['gl_code' => '157013', 'ledger_name' => 'TDS Receivable - FY20 _21', 'gl_name' => 'TDS Receivable - FY20 _21'],
                ['gl_code' => '157014', 'ledger_name' => 'TDS Receivable - FY21 _22', 'gl_name' => 'TDS Receivable - FY21 _22'],
                ['gl_code' => '157015', 'ledger_name' => 'TDS Receivable - FY22 _23', 'gl_name' => 'TDS Receivable - FY22 _23'],
                ['gl_code' => '157016', 'ledger_name' => 'TDS Receivable - FY23 _24', 'gl_name' => 'TDS Receivable - FY23 _24'],
                ['gl_code' => '157017', 'ledger_name' => 'TDS Receivable - FY24 _25', 'gl_name' => 'TDS Receivable - FY24 _25'],
                ['gl_code' => '157018', 'ledger_name' => 'TDS Receivable - FY25 _26', 'gl_name' => 'TDS Receivable - FY25 _26'],
                ['gl_code' => '157019', 'ledger_name' => 'TDS Receivable - FY26 _27', 'gl_name' => 'TDS Receivable - FY26 _27'],
                ['gl_code' => '157020', 'ledger_name' => 'TDS Recoverable - Caspian', 'gl_name' => 'TDS Recoverable - Caspian'],
                ['gl_code' => '157021', 'ledger_name' => 'TDS Recoverable from Lendors (Borrowings)', 'gl_name' => 'TDS Recoverable from Lendors (Borrowings)'],
                ['gl_code' => '157022', 'ledger_name' => 'TDS - Recoverable - Loans', 'gl_name' => 'TDS - Recoverable - Loans'],
                ['gl_code' => '118000', 'ledger_name' => 'Untagged - Hyderabad', 'gl_name' => 'Untagged - Hyderabad'],
                ['gl_code' => '118001', 'ledger_name' => 'Untagged - Main Book', 'gl_name' => 'Untagged - Main Book'],
                ['gl_code' => '118002', 'ledger_name' => 'Untagged - Saral', 'gl_name' => 'Untagged - Saral'],
                ['gl_code' => '300000', 'ledger_name' => 'Equity Share Capital A/c', 'gl_name' => 'Equity Share Capital A/c'],
                ['gl_code' => '515000', 'ledger_name' => 'Advertisement and Business Promotion Expenses', 'gl_name' => 'Advertisement and Business Promotion Expenses'],
                ['gl_code' => '515001', 'ledger_name' => 'Car Expense', 'gl_name' => 'Car Expense'],
                ['gl_code' => '515002', 'ledger_name' => 'Claims Paid', 'gl_name' => 'Claims Paid'],
                ['gl_code' => '515003', 'ledger_name' => 'Corporate social responsibility (CSR expenses)', 'gl_name' => 'Corporate social responsibility (CSR expenses)'],
                ['gl_code' => '515004', 'ledger_name' => 'Postage and Courier', 'gl_name' => 'Postage and Courier'],
                ['gl_code' => '515005', 'ledger_name' => 'Depository Charges & Demat Charges', 'gl_name' => 'Depository Charges & Demat Charges'],
                ['gl_code' => '515006', 'ledger_name' => 'Director fees, allowances and expenses', 'gl_name' => 'Director fees, allowances and expenses'],
                ['gl_code' => '515007', 'ledger_name' => 'Director&Officer Insurance', 'gl_name' => 'Director&Officer Insurance'],
                ['gl_code' => '515008', 'ledger_name' => 'Due Diligence Fee Paid', 'gl_name' => 'Due Diligence Fee Paid'],
                ['gl_code' => '515009', 'ledger_name' => 'Electricity charges', 'gl_name' => 'Electricity charges'],
                ['gl_code' => '515010', 'ledger_name' => 'Event Exp', 'gl_name' => 'Event Exp'],
                ['gl_code' => '515011', 'ledger_name' => 'Gaurantee Fee Paid', 'gl_name' => 'Gaurantee Fee Paid'],
                ['gl_code' => '515012', 'ledger_name' => 'Hotel Exp', 'gl_name' => 'Hotel Exp'],
                ['gl_code' => '515013', 'ledger_name' => 'Interest Exp RD', 'gl_name' => 'Interest Exp RD'],
                ['gl_code' => '515014', 'ledger_name' => 'Interest on car loan', 'gl_name' => 'Interest on car loan'],
                ['gl_code' => '515015', 'ledger_name' => 'Labour Chrg', 'gl_name' => 'Labour Chrg'],
                ['gl_code' => '515016', 'ledger_name' => 'Membership and subscription charges', 'gl_name' => 'Membership and subscription charges'],
                ['gl_code' => '515017', 'ledger_name' => 'Miscellaneous expenses', 'gl_name' => 'Miscellaneous expenses'],
                ['gl_code' => '515018', 'ledger_name' => 'Office Exp-RD', 'gl_name' => 'Office Exp-RD'],
                ['gl_code' => '515019', 'ledger_name' => 'Office Exp-URD', 'gl_name' => 'Office Exp-URD'],
                ['gl_code' => '515020', 'ledger_name' => 'Office maintenance', 'gl_name' => 'Office maintenance'],
                ['gl_code' => '515021', 'ledger_name' => 'Printing and stationery', 'gl_name' => 'Printing and stationery'],
                ['gl_code' => '515022', 'ledger_name' => 'Rates and taxes', 'gl_name' => 'Rates and taxes'],
                ['gl_code' => '515023', 'ledger_name' => 'Razorpay charges', 'gl_name' => 'Razorpay charges'],
                ['gl_code' => '515024', 'ledger_name' => 'Reimbursement of Employee Expense', 'gl_name' => 'Reimbursement of Employee Expense'],
                ['gl_code' => '515025', 'ledger_name' => 'Reimbursement of Stamp Duty- Expense', 'gl_name' => 'Reimbursement of Stamp Duty- Expense'],
                ['gl_code' => '515026', 'ledger_name' => 'Repairs and maintenance', 'gl_name' => 'Repairs and maintenance'],
                ['gl_code' => '515027', 'ledger_name' => 'Share Issue Expenses', 'gl_name' => 'Share Issue Expenses'],
                ['gl_code' => '515028', 'ledger_name' => 'Stamp Duty Expense', 'gl_name' => 'Stamp Duty Expense'],
                ['gl_code' => '515029', 'ledger_name' => 'Sundry Balance W/off', 'gl_name' => 'Sundry Balance W/off'],
                ['gl_code' => '515030', 'ledger_name' => 'Travelling and conveyance expenses', 'gl_name' => 'Travelling and conveyance expenses'],
                ['gl_code' => '515031', 'ledger_name' => 'Penal Charges - Expense - Partner Share', 'gl_name' => 'Penal Charges - Expense - Partner Share'],
                ['gl_code' => '515032', 'ledger_name' => 'Security Premium Amortization', 'gl_name' => 'Security Premium Amortization'],
                ['gl_code' => '515033', 'ledger_name' => 'Rounding Off', 'gl_name' => 'Rounding Off'],
                ['gl_code' => '515034', 'ledger_name' => 'PT Expense Employer', 'gl_name' => 'PT Expense Employer'],
                ['gl_code' => '515035', 'ledger_name' => 'Guarantee Management Service fee', 'gl_name' => 'Guarantee Management Service fee'],
                ['gl_code' => '515036', 'ledger_name' => 'Amortization Expenses', 'gl_name' => 'Amortization Expenses'],
                ['gl_code' => '515037', 'ledger_name' => 'Upfront Fee guarantee', 'gl_name' => 'Upfront Fee guarantee'],
                ['gl_code' => '515038', 'ledger_name' => 'Guarantee Claim (USAID)', 'gl_name' => 'Guarantee Claim (USAID)'],
                ['gl_code' => '515039', 'ledger_name' => 'UPS AMC Charges - Boscotech', 'gl_name' => 'UPS AMC Charges - Boscotech'],
                ['gl_code' => '515040', 'ledger_name' => 'Rates and Taxes - Lease', 'gl_name' => 'Rates and Taxes - Lease'],
                ['gl_code' => '515041', 'ledger_name' => 'Books, Periodicals & News Papers', 'gl_name' => 'Books, Periodicals & News Papers'],
                ['gl_code' => '515042', 'ledger_name' => 'Service Charges', 'gl_name' => 'Service Charges'],
                ['gl_code' => '515043', 'ledger_name' => 'Depository Participant Fee', 'gl_name' => 'Depository Participant Fee'],
                ['gl_code' => '515044', 'ledger_name' => 'Interest Derecognition', 'gl_name' => 'Interest Derecognition'],
                ['gl_code' => '515045', 'ledger_name' => 'Exchange Fluctuation in Currency', 'gl_name' => 'Exchange Fluctuation in Currency'],
                ['gl_code' => '515046', 'ledger_name' => 'Business Support Services -  Cross Charges', 'gl_name' => 'Business Support Services -  Cross Charges'],
                ['gl_code' => '512000', 'ledger_name' => 'Amortisation - Computer Software', 'gl_name' => 'Amortisation - Computer Software'],
                ['gl_code' => '512001', 'ledger_name' => 'Amortisation - Goodwill', 'gl_name' => 'Amortisation - Goodwill'],
                ['gl_code' => '512002', 'ledger_name' => 'Depreciation - Computers and servers', 'gl_name' => 'Depreciation - Computers and servers'],
                ['gl_code' => '512003', 'ledger_name' => 'Depreciation - Furniture and fixtures', 'gl_name' => 'Depreciation - Furniture and fixtures'],
                ['gl_code' => '512004', 'ledger_name' => 'Depreciation - Leasehold Improvements', 'gl_name' => 'Depreciation - Leasehold Improvements'],
                ['gl_code' => '512005', 'ledger_name' => 'Depreciation - Office equipments', 'gl_name' => 'Depreciation - Office equipments'],
                ['gl_code' => '512006', 'ledger_name' => 'Depreciation - Vehicles', 'gl_name' => 'Depreciation - Vehicles'],
                ['gl_code' => '518000', 'ledger_name' => 'Stage 1 - ECL Expense - NCD', 'gl_name' => 'Stage 1 - ECL Expense - NCD'],
                ['gl_code' => '518001', 'ledger_name' => 'Stage 1 - ECL Expense - Term Loan', 'gl_name' => 'Stage 1 - ECL Expense - Term Loan'],
                ['gl_code' => '518002', 'ledger_name' => 'Stage 1 - ECL Expense - WCL', 'gl_name' => 'Stage 1 - ECL Expense - WCL'],
                ['gl_code' => '518003', 'ledger_name' => 'Stage 1 - ECL Expense Commitment - NCD', 'gl_name' => 'Stage 1 - ECL Expense Commitment - NCD'],
                ['gl_code' => '518004', 'ledger_name' => 'Stage 1 - ECL Expense Commitment - Term Loan', 'gl_name' => 'Stage 1 - ECL Expense Commitment - Term Loan'],
                ['gl_code' => '518005', 'ledger_name' => 'Stage 1 - ECL Expense Commitment - WCL', 'gl_name' => 'Stage 1 - ECL Expense Commitment - WCL'],
                ['gl_code' => '518006', 'ledger_name' => 'Stage 2 - ECL Expense - NCD', 'gl_name' => 'Stage 2 - ECL Expense - NCD'],
                ['gl_code' => '518007', 'ledger_name' => 'Stage 2 - ECL Expense - Term Loan', 'gl_name' => 'Stage 2 - ECL Expense - Term Loan'],
                ['gl_code' => '518008', 'ledger_name' => 'Stage 2 - ECL Expense - WCL', 'gl_name' => 'Stage 2 - ECL Expense - WCL'],
                ['gl_code' => '518009', 'ledger_name' => 'Stage 3 - ECL Expense - NCD', 'gl_name' => 'Stage 3 - ECL Expense - NCD'],
                ['gl_code' => '518010', 'ledger_name' => 'Stage 3 - ECL Expense - Term Loan', 'gl_name' => 'Stage 3 - ECL Expense - Term Loan'],
                ['gl_code' => '518011', 'ledger_name' => 'Stage 3 - ECL Expense - WCL', 'gl_name' => 'Stage 3 - ECL Expense - WCL'],
                ['gl_code' => '518012', 'ledger_name' => 'Write Off - Loan', 'gl_name' => 'Write Off - Loan'],
                ['gl_code' => '521000', 'ledger_name' => 'Accomodation Expenses', 'gl_name' => 'Accomodation Expenses'],
                ['gl_code' => '521001', 'ledger_name' => 'Bonus to staff', 'gl_name' => 'Bonus to staff'],
                ['gl_code' => '521002', 'ledger_name' => 'Contribution to Provident and other funds', 'gl_name' => 'Contribution to Provident and other funds'],
                ['gl_code' => '521003', 'ledger_name' => 'Employee Insurance Charges', 'gl_name' => 'Employee Insurance Charges'],
                ['gl_code' => '521004', 'ledger_name' => 'Employer Labour Welfare Fund - Expense', 'gl_name' => 'Employer Labour Welfare Fund - Expense'],
                ['gl_code' => '521005', 'ledger_name' => 'Employer NPS - Expense', 'gl_name' => 'Employer NPS - Expense'],
                ['gl_code' => '521006', 'ledger_name' => 'Gratuity expense', 'gl_name' => 'Gratuity expense'],
                ['gl_code' => '521007', 'ledger_name' => 'Leave salary', 'gl_name' => 'Leave salary'],
                ['gl_code' => '521008', 'ledger_name' => 'Managerial Remuneration', 'gl_name' => 'Managerial Remuneration'],
                ['gl_code' => '521009', 'ledger_name' => 'Mediclaim Group Insurance', 'gl_name' => 'Mediclaim Group Insurance'],
                ['gl_code' => '521010', 'ledger_name' => 'P.F.Insurance Premium -Expenses', 'gl_name' => 'P.F.Insurance Premium -Expenses'],
                ['gl_code' => '521011', 'ledger_name' => 'Pantry Exp', 'gl_name' => 'Pantry Exp'],
                ['gl_code' => '521012', 'ledger_name' => 'Provident Fund- Admin Charges Expenses', 'gl_name' => 'Provident Fund- Admin Charges Expenses'],
                ['gl_code' => '521013', 'ledger_name' => 'Provident Fund- Managerial Remuneration', 'gl_name' => 'Provident Fund- Managerial Remuneration'],
                ['gl_code' => '521014', 'ledger_name' => 'Salary & Wages', 'gl_name' => 'Salary & Wages'],
                ['gl_code' => '521015', 'ledger_name' => 'Share based payment to employees', 'gl_name' => 'Share based payment to employees'],
                ['gl_code' => '521016', 'ledger_name' => 'Staff Welfare expenses', 'gl_name' => 'Staff Welfare expenses'],
                ['gl_code' => '521017', 'ledger_name' => 'Stipend Salary', 'gl_name' => 'Stipend Salary'],
                ['gl_code' => '500000', 'ledger_name' => 'Arrangement Fees - Loans', 'gl_name' => 'Arrangement Fees - Loans'],
                ['gl_code' => '500001', 'ledger_name' => 'Commission Expense on Banks', 'gl_name' => 'Commission Expense on Banks'],
                ['gl_code' => '500002', 'ledger_name' => 'Commission Expense on ECB', 'gl_name' => 'Commission Expense on ECB'],
                ['gl_code' => '500006', 'ledger_name' => 'Commission Expense on NCD Series', 'gl_name' => 'Commission Expense on NCD Series'],
                ['gl_code' => '500003', 'ledger_name' => 'Commission Expense on Non Banks - FI\'s', 'gl_name' => 'Commission Expense on Non Banks - FI\'s'],
                ['gl_code' => '500007', 'ledger_name' => 'Commission Expense on NCD - FI\'s', 'gl_name' => 'Commission Expense on NCD - FI\'s'],
                ['gl_code' => '500004', 'ledger_name' => 'Revenue Share', 'gl_name' => 'Revenue Share'],
                ['gl_code' => '500005', 'ledger_name' => 'Revenue Share - Provision (P&L)', 'gl_name' => 'Revenue Share - Provision (P&L)'],
                ['gl_code' => '503000', 'ledger_name' => 'Fund Raising Fee - Banks', 'gl_name' => 'Fund Raising Fee - Banks'],
                ['gl_code' => '503001', 'ledger_name' => 'Fund Raising Fee - Non Banks - FI\'s', 'gl_name' => 'Fund Raising Fee - Non Banks - FI\'s'],
                ['gl_code' => '503002', 'ledger_name' => 'Fund Raising Fee- NCD', 'gl_name' => 'Fund Raising Fee- NCD'],
                ['gl_code' => '503003', 'ledger_name' => 'Stamp duty on fund Raising', 'gl_name' => 'Stamp duty on fund Raising'],
                ['gl_code' => '506000', 'ledger_name' => 'Interest Expense - Security Deposit/ DSRA', 'gl_name' => 'Interest Expense - Security Deposit/ DSRA'],
                ['gl_code' => '506004', 'ledger_name' => 'Interest Expense on Term Loan Banks', 'gl_name' => 'Interest Expense on Term Loan Banks'],
                ['gl_code' => '506001', 'ledger_name' => 'Interest Expense on ECB', 'gl_name' => 'Interest Expense on ECB'],
                ['gl_code' => '506002', 'ledger_name' => 'Interest Expense on ICD', 'gl_name' => 'Interest Expense on ICD'],
                ['gl_code' => '506005', 'ledger_name' => 'Interest Expense on NCD Series', 'gl_name' => 'Interest Expense on NCD Series'],
                ['gl_code' => '506006', 'ledger_name' => 'Interest Expense on Term Loan - FI\'s', 'gl_name' => 'Interest Expense on Term Loan - FI\'s'],
                ['gl_code' => '506007', 'ledger_name' => 'Interest Expense on NCD FI\'s', 'gl_name' => 'Interest Expense on NCD FI\'s'],
                ['gl_code' => '506003', 'ledger_name' => 'Interest Expense on OD/ CC', 'gl_name' => 'Interest Expense on OD/ CC'],
                ['gl_code' => '509000', 'ledger_name' => 'Bank Charges', 'gl_name' => 'Bank Charges'],
                ['gl_code' => '509001', 'ledger_name' => 'Exit load on Mutual Fund', 'gl_name' => 'Exit load on Mutual Fund'],
                ['gl_code' => '509002', 'ledger_name' => 'Other - Finance cost', 'gl_name' => 'Other - Finance cost'],
                ['gl_code' => '509003', 'ledger_name' => 'Service Fees', 'gl_name' => 'Service Fees'],
                ['gl_code' => '509004', 'ledger_name' => 'Stamp Duty on Mutual Fund', 'gl_name' => 'Stamp Duty on Mutual Fund'],
                ['gl_code' => '524000', 'ledger_name' => 'Impairment of Assets', 'gl_name' => 'Impairment of Assets'],
                ['gl_code' => '527000', 'ledger_name' => 'Audit Fee', 'gl_name' => 'Audit Fee'],
                ['gl_code' => '527001', 'ledger_name' => 'Legal Fee', 'gl_name' => 'Legal Fee'],
                ['gl_code' => '527002', 'ledger_name' => 'Professional fees', 'gl_name' => 'Professional fees'],
                ['gl_code' => '527003', 'ledger_name' => 'Retainer fees - Compliance', 'gl_name' => 'Retainer fees - Compliance'],
                ['gl_code' => '527004', 'ledger_name' => 'Retainer fees - Financial Service', 'gl_name' => 'Retainer fees - Financial Service'],
                ['gl_code' => '530000', 'ledger_name' => 'Rent and infrastructure services', 'gl_name' => 'Rent and infrastructure services'],
                ['gl_code' => '533000', 'ledger_name' => 'CGST Disallowed', 'gl_name' => 'CGST Disallowed'],
                ['gl_code' => '533001', 'ledger_name' => 'Current Tax', 'gl_name' => 'Current Tax'],
                ['gl_code' => '533002', 'ledger_name' => 'Deferred Tax - Expense/ (Income)', 'gl_name' => 'Deferred Tax - Expense/ (Income)'],
                ['gl_code' => '533003', 'ledger_name' => 'IGST Disallowed', 'gl_name' => 'IGST Disallowed'],
                ['gl_code' => '533004', 'ledger_name' => 'Interest on Late Payment of GST', 'gl_name' => 'Interest on Late Payment of GST'],
                ['gl_code' => '533005', 'ledger_name' => 'Interest on Late Payment on TDS', 'gl_name' => 'Interest on Late Payment on TDS'],
                ['gl_code' => '533006', 'ledger_name' => 'Penal & other GST Charges', 'gl_name' => 'Penal & other GST Charges'],
                ['gl_code' => '533007', 'ledger_name' => 'Penalty for Late Payment of TDS', 'gl_name' => 'Penalty for Late Payment of TDS'],
                ['gl_code' => '533008', 'ledger_name' => 'SGST Disallowed', 'gl_name' => 'SGST Disallowed'],
                ['gl_code' => '536000', 'ledger_name' => 'AMC - (ITOperational Cost)', 'gl_name' => 'AMC - (ITOperational Cost)'],
                ['gl_code' => '536001', 'ledger_name' => 'Computer and software expenses', 'gl_name' => 'Computer and software expenses'],
                ['gl_code' => '536002', 'ledger_name' => 'Infrastructure Cost - (ITOperational Cost)', 'gl_name' => 'Infrastructure Cost - (ITOperational Cost)'],
                ['gl_code' => '536003', 'ledger_name' => 'Internet Expenses', 'gl_name' => 'Internet Expenses'],
                ['gl_code' => '536004', 'ledger_name' => 'Printing and stationery (ITOperational Cost)', 'gl_name' => 'Printing and stationery (ITOperational Cost)'],
                ['gl_code' => '536005', 'ledger_name' => 'Professional Fess  Service - (ITOperational Cost)', 'gl_name' => 'Professional Fess  Service - (ITOperational Cost)'],
                ['gl_code' => '536006', 'ledger_name' => 'Repairs and Maintenance -  (ITOperational Cost)', 'gl_name' => 'Repairs and Maintenance -  (ITOperational Cost)'],
                ['gl_code' => '536007', 'ledger_name' => 'Telephone Charges', 'gl_name' => 'Telephone Charges'],
                ['gl_code' => '536008', 'ledger_name' => 'Retainer Fees - IT', 'gl_name' => 'Retainer Fees - IT'],
                ['gl_code' => '400000', 'ledger_name' => 'Acceptance Fee', 'gl_name' => 'Acceptance Fee'],
                ['gl_code' => '400001', 'ledger_name' => 'Back end fee', 'gl_name' => 'Back end fee'],
                ['gl_code' => '400002', 'ledger_name' => 'Documentation/ Transaction Handling Charges', 'gl_name' => 'Documentation/ Transaction Handling Charges'],
                ['gl_code' => '400003', 'ledger_name' => 'Due Diligence Fee', 'gl_name' => 'Due Diligence Fee'],
                ['gl_code' => '400004', 'ledger_name' => 'Income on Gaurantee Fee', 'gl_name' => 'Income on Gaurantee Fee'],
                ['gl_code' => '400005', 'ledger_name' => 'Miscellaneous Direct Income', 'gl_name' => 'Miscellaneous Direct Income'],
                ['gl_code' => '400006', 'ledger_name' => 'Prepayment Charges', 'gl_name' => 'Prepayment Charges'],
                ['gl_code' => '400007', 'ledger_name' => 'Processing / Upfront Fee', 'gl_name' => 'Processing / Upfront Fee'],
                ['gl_code' => '400008', 'ledger_name' => 'Renewal Fee', 'gl_name' => 'Renewal Fee'],
                ['gl_code' => '400009', 'ledger_name' => 'Stamp Duty Fee', 'gl_name' => 'Stamp Duty Fee'],
                ['gl_code' => '400010', 'ledger_name' => 'Advisory fee', 'gl_name' => 'Advisory fee'],
                ['gl_code' => '400011', 'ledger_name' => 'Foreclosure Charges', 'gl_name' => 'Foreclosure Charges'],
                ['gl_code' => '400012', 'ledger_name' => 'Guarentee Fee', 'gl_name' => 'Guarentee Fee'],
                ['gl_code' => '403000', 'ledger_name' => 'Back end coupon', 'gl_name' => 'Back end coupon'],
                ['gl_code' => '403008', 'ledger_name' => 'Broken Period Interest income', 'gl_name' => 'Broken Period Interest income'],
                ['gl_code' => '403001', 'ledger_name' => 'Call Cption Coupon', 'gl_name' => 'Call Cption Coupon'],
                ['gl_code' => '403002', 'ledger_name' => 'Interest - Accrued but not due (P&L)', 'gl_name' => 'Interest - Accrued but not due (P&L)'],
                ['gl_code' => '403003', 'ledger_name' => 'Interest Income', 'gl_name' => 'Interest Income'],
                ['gl_code' => '403004', 'ledger_name' => 'Overdue Income', 'gl_name' => 'Overdue Income'],
                ['gl_code' => '403005', 'ledger_name' => 'Penal Charges', 'gl_name' => 'Penal Charges'],
                ['gl_code' => '403009', 'ledger_name' => 'Default Coupon', 'gl_name' => 'Default Coupon'],
                ['gl_code' => '403006', 'ledger_name' => 'Subvention Income', 'gl_name' => 'Subvention Income'],
                ['gl_code' => '403007', 'ledger_name' => 'Upfront Coupon', 'gl_name' => 'Upfront Coupon'],
                ['gl_code' => '406000', 'ledger_name' => 'CP Interest', 'gl_name' => 'CP Interest'],
                ['gl_code' => '406001', 'ledger_name' => 'Fixed Deposit Interest', 'gl_name' => 'Fixed Deposit Interest'],
                ['gl_code' => '406002', 'ledger_name' => 'Interest income from AIF', 'gl_name' => 'Interest income from AIF'],
                ['gl_code' => '406003', 'ledger_name' => 'Mutual Fund Capital Gain - Realized', 'gl_name' => 'Mutual Fund Capital Gain - Realized'],
                ['gl_code' => '406004', 'ledger_name' => 'Mutual Fund Capital Gain - Unrealized', 'gl_name' => 'Mutual Fund Capital Gain - Unrealized'],
                ['gl_code' => '406005', 'ledger_name' => 'Short Term Gain on Sale of Investments', 'gl_name' => 'Short Term Gain on Sale of Investments'],
                ['gl_code' => '406006', 'ledger_name' => 'STCG income from AIF', 'gl_name' => 'STCG income from AIF'],
                ['gl_code' => '409000', 'ledger_name' => 'Interest on income tax refund', 'gl_name' => 'Interest on income tax refund'],
                ['gl_code' => '409001', 'ledger_name' => 'Profit Share from Borrower', 'gl_name' => 'Profit Share from Borrower'],
                ['gl_code' => '409002', 'ledger_name' => 'Profit/Loss on Sale of Asset', 'gl_name' => 'Profit/Loss on Sale of Asset'],
                ['gl_code' => '409003', 'ledger_name' => 'Reimbursement of Stamp Duty', 'gl_name' => 'Reimbursement of Stamp Duty'],
                ['gl_code' => '409004', 'ledger_name' => 'Rent Income', 'gl_name' => 'Rent Income'],
                ['gl_code' => '409005', 'ledger_name' => 'Shared Service Fee - Income', 'gl_name' => 'Shared Service Fee - Income'],
                ['gl_code' => '409006', 'ledger_name' => 'Write Back/ Bad Debts Recovered', 'gl_name' => 'Write Back/ Bad Debts Recovered'],
                ['gl_code' => '600000', 'ledger_name' => 'EIR Adjustment - NCD\'s', 'gl_name' => 'EIR Adjustment - NCD\'s'],
                ['gl_code' => '600001', 'ledger_name' => 'EIR Adjustment Processing Fee- TLs', 'gl_name' => 'EIR Adjustment Processing Fee- TLs'],
                ['gl_code' => '600002', 'ledger_name' => 'EIR Adjustment Processing Fee- WCL\'s', 'gl_name' => 'EIR Adjustment Processing Fee- WCL\'s'],
                ['gl_code' => '600003', 'ledger_name' => 'Loan to Employee-IND AS', 'gl_name' => 'Loan to Employee-IND AS'],
                ['gl_code' => '600004', 'ledger_name' => 'Accumulated Depreciation Right-of use assets', 'gl_name' => 'Accumulated Depreciation Right-of use assets'],
                ['gl_code' => '600005', 'ledger_name' => 'Right-of use assets', 'gl_name' => 'Right-of use assets'],
                ['gl_code' => '600006', 'ledger_name' => 'Deferred Tax Assets - IND AS', 'gl_name' => 'Deferred Tax Assets - IND AS'],
                ['gl_code' => '600007', 'ledger_name' => 'Investment  - IND AS', 'gl_name' => 'Investment  - IND AS'],
                ['gl_code' => '600008', 'ledger_name' => 'Security Deposit ROU - Antratica Trading-502', 'gl_name' => 'Security Deposit ROU - Antratica Trading-502'],
                ['gl_code' => '600009', 'ledger_name' => 'Security Deposity Blacksoil Infratech LLP-1203-ROU', 'gl_name' => 'Security Deposity Blacksoil Infratech LLP-1203-ROU'],
                ['gl_code' => '600010', 'ledger_name' => 'Security Deposity BPTP Park Gurgaon -ROU', 'gl_name' => 'Security Deposity BPTP Park Gurgaon -ROU'],
                ['gl_code' => '600011', 'ledger_name' => 'FV Impact- TL', 'gl_name' => 'FV Impact- TL'],
                ['gl_code' => '600012', 'ledger_name' => 'FV Impact-WCL', 'gl_name' => 'FV Impact-WCL'],
                ['gl_code' => '603000', 'ledger_name' => 'Depreciation - Right-of use assets', 'gl_name' => 'Depreciation - Right-of use assets'],
                ['gl_code' => '603001', 'ledger_name' => 'Interest Expense - EIR Adjustment(Lease Liablity) - 1203', 'gl_name' => 'Interest Expense - EIR Adjustment(Lease Liablity) - 1203'],
                ['gl_code' => '603002', 'ledger_name' => 'Interest Expense - EIR Adjustment(Lease Liablity) - 502', 'gl_name' => 'Interest Expense - EIR Adjustment(Lease Liablity) - 502'],
                ['gl_code' => '603003', 'ledger_name' => 'Interest Expense - EIR Adjustment(Lease Liablity) - AIPDC', 'gl_name' => 'Interest Expense - EIR Adjustment(Lease Liablity) - AIPDC'],
                ['gl_code' => '603004', 'ledger_name' => 'Interest Expense - EIR Adjustment(Lease Liablity) - BPTP Park Gurgaon', 'gl_name' => 'Interest Expense - EIR Adjustment(Lease Liablity) - BPTP Park Gurgaon'],
                ['gl_code' => '603005', 'ledger_name' => 'Interest Expense - EIR Adjustment(Lease Liablity) - Delhi', 'gl_name' => 'Interest Expense - EIR Adjustment(Lease Liablity) - Delhi'],
                ['gl_code' => '603006', 'ledger_name' => 'P&L - Finance Cost - EIR Adjustment -  NCD\'s - FI\'s', 'gl_name' => 'P&L - Finance Cost - EIR Adjustment -  NCD\'s - FI\'s'],
                ['gl_code' => '603007', 'ledger_name' => 'P&L - Finance Cost - EIR Adjustment - NCD Series', 'gl_name' => 'P&L - Finance Cost - EIR Adjustment - NCD Series'],
                ['gl_code' => '603008', 'ledger_name' => 'P&L - Finance Cost - EIR Adjustment - Secured ECBs', 'gl_name' => 'P&L - Finance Cost - EIR Adjustment - Secured ECBs'],
                ['gl_code' => '603009', 'ledger_name' => 'P&L - Finance Cost - EIR Adjustment - Term Loans- Banks', 'gl_name' => 'P&L - Finance Cost - EIR Adjustment - Term Loans- Banks'],
                ['gl_code' => '603010', 'ledger_name' => 'P&L - Finance Cost - EIR Adjustment - Term Loans- Fis', 'gl_name' => 'P&L - Finance Cost - EIR Adjustment - Term Loans- Fis'],
                ['gl_code' => '603011', 'ledger_name' => 'P&L - Finance Cost - EIR Adjustment - UnSecured ECBs', 'gl_name' => 'P&L - Finance Cost - EIR Adjustment - UnSecured ECBs'],
                ['gl_code' => '603012', 'ledger_name' => 'Lease Expense - ROU', 'gl_name' => 'Lease Expense - ROU'],
                ['gl_code' => '606000', 'ledger_name' => 'P&L - EIR Adjustment - NCD\'s', 'gl_name' => 'P&L - EIR Adjustment - NCD\'s'],
                ['gl_code' => '606001', 'ledger_name' => 'P&L - EIR Adjustment Processing Fee- TLs', 'gl_name' => 'P&L - EIR Adjustment Processing Fee- TLs'],
                ['gl_code' => '606002', 'ledger_name' => 'P&L - EIR Adjustment Processing Fee- WCL\'s', 'gl_name' => 'P&L - EIR Adjustment Processing Fee- WCL\'s'],
                ['gl_code' => '606003', 'ledger_name' => 'FVTPL - IND AS', 'gl_name' => 'FVTPL - IND AS'],
                ['gl_code' => '606004', 'ledger_name' => 'P&L - Deferred Tax Assets - IND AS', 'gl_name' => 'P&L - Deferred Tax Assets - IND AS'],
                ['gl_code' => '606005', 'ledger_name' => 'P&L - Loan to Employee - IND AS', 'gl_name' => 'P&L - Loan to Employee - IND AS'],
                ['gl_code' => '606006', 'ledger_name' => 'Unwinding of discount on security deposits- IND AS', 'gl_name' => 'Unwinding of discount on security deposits- IND AS'],
                ['gl_code' => '609000', 'ledger_name' => 'EIR Adjustment LPF for NCD\'s - FI\'s', 'gl_name' => 'EIR Adjustment LPF for NCD\'s - FI\'s'],
                ['gl_code' => '609001', 'ledger_name' => 'EIR Adjustment LPF on borrowings - Secured ECBs', 'gl_name' => 'EIR Adjustment LPF on borrowings - Secured ECBs'],
                ['gl_code' => '609002', 'ledger_name' => 'EIR Adjustment LPF on borrowings - UnSecured ECBs', 'gl_name' => 'EIR Adjustment LPF on borrowings - UnSecured ECBs'],
                ['gl_code' => '609003', 'ledger_name' => 'EIR Adjustment Processing Fee- Term Loans- Banks', 'gl_name' => 'EIR Adjustment Processing Fee- Term Loans- Banks'],
                ['gl_code' => '609004', 'ledger_name' => 'EIR Adjustment Processing Fee- Term Loans- FIs', 'gl_name' => 'EIR Adjustment Processing Fee- Term Loans- FIs'],
                ['gl_code' => '609005', 'ledger_name' => 'EIR Adjustment Upfront Commission for NCD\'s Series', 'gl_name' => 'EIR Adjustment Upfront Commission for NCD\'s Series'],
                ['gl_code' => '609006', 'ledger_name' => 'Lease liability-ROU -1203', 'gl_name' => 'Lease liability-ROU -1203'],
                ['gl_code' => '609007', 'ledger_name' => 'Lease liability-ROU -502', 'gl_name' => 'Lease liability-ROU -502'],
                ['gl_code' => '609008', 'ledger_name' => 'Lease liability-ROU -AIPDC', 'gl_name' => 'Lease liability-ROU -AIPDC'],
                ['gl_code' => '609009', 'ledger_name' => 'Lease liability-ROU -BPTP Park', 'gl_name' => 'Lease liability-ROU -BPTP Park'],
                ['gl_code' => '609010', 'ledger_name' => 'Lease liability-ROU -Delhi', 'gl_name' => 'Lease liability-ROU -Delhi'],
                ['gl_code' => '233000', 'ledger_name' => 'Borrowings - Banks - Secured', 'gl_name' => 'Borrowings - Banks - Secured'],
                ['gl_code' => '233001', 'ledger_name' => 'Borrowings - Banks - UnSecured', 'gl_name' => 'Borrowings - Banks - UnSecured'],
                ['gl_code' => '233002', 'ledger_name' => 'Borrowings - ECB - Secured', 'gl_name' => 'Borrowings - ECB - Secured'],
                ['gl_code' => '233003', 'ledger_name' => 'Borrowings - ECB - UnSecured', 'gl_name' => 'Borrowings - ECB - UnSecured'],
                ['gl_code' => '233004', 'ledger_name' => 'Borrowings - ICD', 'gl_name' => 'Borrowings - ICD'],
                ['gl_code' => '233005', 'ledger_name' => 'Borrowings - NCD - Secured', 'gl_name' => 'Borrowings - NCD - Secured'],
                ['gl_code' => '233006', 'ledger_name' => 'Borrowings - NCD - UnSecured', 'gl_name' => 'Borrowings - NCD - UnSecured'],
                ['gl_code' => '233007', 'ledger_name' => 'Borrowings - Non Banks (FI\'s)- Secured', 'gl_name' => 'Borrowings - Non Banks (FI\'s)- Secured'],
                ['gl_code' => '233008', 'ledger_name' => 'Borrowings - Non Banks (FI\'s)- UnSecured', 'gl_name' => 'Borrowings - Non Banks (FI\'s)- UnSecured'],
                ['gl_code' => '200000', 'ledger_name' => 'M01_Haryana_Branch-Trf-Bcpl Maine', 'gl_name' => 'M01_Haryana_Branch-Trf-Bcpl Maine'],
                ['gl_code' => '200001', 'ledger_name' => 'M01_Main Book_Blacksoil Capital Pvt Ltd -Haryana', 'gl_name' => 'M01_Main Book_Blacksoil Capital Pvt Ltd -Haryana'],
                ['gl_code' => '200002', 'ledger_name' => 'M02_Main Book_Saraloan Transaction From BCPL', 'gl_name' => 'M02_Main Book_Saraloan Transaction From BCPL'],
                ['gl_code' => '200003', 'ledger_name' => 'M02_Saral_Branch Trf from BCPL', 'gl_name' => 'M02_Saral_Branch Trf from BCPL'],
                ['gl_code' => '200004', 'ledger_name' => 'M03_Main Book_SME Book Tally -Branch Account', 'gl_name' => 'M03_Main Book_SME Book Tally -Branch Account'],
                ['gl_code' => '200005', 'ledger_name' => 'M03_QP_Main Book Tally -Branch Account -(1.4.18)', 'gl_name' => 'M03_QP_Main Book Tally -Branch Account -(1.4.18)'],
                ['gl_code' => '200006', 'ledger_name' => 'M04_Co Lending_Branch - Hyderabad Office', 'gl_name' => 'M04_Co Lending_Branch - Hyderabad Office'],
                ['gl_code' => '200007', 'ledger_name' => 'M04_Hyd_Co Lending Control Account', 'gl_name' => 'M04_Hyd_Co Lending Control Account'],
                ['gl_code' => '200008', 'ledger_name' => 'M05_HO - Hyd_Blacksoil Capital Hyderabad Office', 'gl_name' => 'M05_HO - Hyd_Blacksoil Capital Hyderabad Office'],
                ['gl_code' => '200009', 'ledger_name' => 'M05_Hyd_Head Office Control Account', 'gl_name' => 'M05_Hyd_Head Office Control Account'],
                ['gl_code' => '200010', 'ledger_name' => 'M06_Hyd_WCL Control Account', 'gl_name' => 'M06_Hyd_WCL Control Account'],
                ['gl_code' => '200011', 'ledger_name' => 'M06_Saral_Hyd WCL', 'gl_name' => 'M06_Saral_Hyd WCL'],
                ['gl_code' => '200012', 'ledger_name' => 'M07_HO - Hyd_BCPL Saral Control Account', 'gl_name' => 'M07_HO - Hyd_BCPL Saral Control Account'],
                ['gl_code' => '200013', 'ledger_name' => 'M07_Saral_Hyd Branch 80%', 'gl_name' => 'M07_Saral_Hyd Branch 80%'],
                ['gl_code' => '200014', 'ledger_name' => 'M08_Co Lending_Branch- Head Office', 'gl_name' => 'M08_Co Lending_Branch- Head Office'],
                ['gl_code' => '200015', 'ledger_name' => 'M08_HO - Hyd_Blacksoil Capital - Partnership Lending', 'gl_name' => 'M08_HO - Hyd_Blacksoil Capital - Partnership Lending'],
                ['gl_code' => '200016', 'ledger_name' => 'M09_Haryana_Branch-Trf-Bcpl Saraloan -Mumbai', 'gl_name' => 'M09_Haryana_Branch-Trf-Bcpl Saraloan -Mumbai'],
                ['gl_code' => '200017', 'ledger_name' => 'M09_Saral_Haryana', 'gl_name' => 'M09_Saral_Haryana'],
                ['gl_code' => '200018', 'ledger_name' => 'M10_NCD_BCPL - SME', 'gl_name' => 'M10_NCD_BCPL - SME'],
                ['gl_code' => '200019', 'ledger_name' => 'M10_QP_NCD Tally- Branch Account', 'gl_name' => 'M10_QP_NCD Tally- Branch Account'],
                ['gl_code' => '200020', 'ledger_name' => 'M11_QP_Saraloan Transaction From BCPL', 'gl_name' => 'M11_QP_Saraloan Transaction From BCPL'],
                ['gl_code' => '200021', 'ledger_name' => 'M11_Saral_SME Book Federal', 'gl_name' => 'M11_Saral_SME Book Federal'],
                ['gl_code' => '200022', 'ledger_name' => 'M12_Main Book_Blacksoil Capital Pvt Ltd SMBL', 'gl_name' => 'M12_Main Book_Blacksoil Capital Pvt Ltd SMBL'],
                ['gl_code' => '200023', 'ledger_name' => 'M12_Main Book_NCD Tally- Branch Account', 'gl_name' => 'M12_Main Book_NCD Tally- Branch Account'],
                ['gl_code' => '200024', 'ledger_name' => 'M12_NCD_BCPL - Main book', 'gl_name' => 'M12_NCD_BCPL - Main book'],
                ['gl_code' => '200025', 'ledger_name' => 'M12_QP_Blacksoil Capital Pvt Ltd SMBL', 'gl_name' => 'M12_QP_Blacksoil Capital Pvt Ltd SMBL'],
                ['gl_code' => '200026', 'ledger_name' => 'M12_Saral_SMBL', 'gl_name' => 'M12_Saral_SMBL'],
                ['gl_code' => '200027', 'ledger_name' => 'M12_Saral_SMBL 31/3/26', 'gl_name' => 'M12_Saral_SMBL 31/3/26'],
                ['gl_code' => '200028', 'ledger_name' => 'M13_Co Lending_BCPL corporate control account', 'gl_name' => 'M13_Co Lending_BCPL corporate control account'],
                ['gl_code' => '200029', 'ledger_name' => 'M13_HO - Hyd_BCPL corporate control account', 'gl_name' => 'M13_HO - Hyd_BCPL corporate control account'],
                ['gl_code' => '200030', 'ledger_name' => 'M13_Hyd_BCPL corporate control account', 'gl_name' => 'M13_Hyd_BCPL corporate control account'],
                ['gl_code' => '200031', 'ledger_name' => 'M13_Main Book_BCPL Head Office Control Account', 'gl_name' => 'M13_Main Book_BCPL Head Office Control Account'],
                ['gl_code' => '200032', 'ledger_name' => 'M13_Main Book_Hyderabad Tally -Branch Account', 'gl_name' => 'M13_Main Book_Hyderabad Tally -Branch Account'],
                ['gl_code' => '200033', 'ledger_name' => 'M13_QP_Blacksoil Capital Pvt Ltd - HYD Branch', 'gl_name' => 'M13_QP_Blacksoil Capital Pvt Ltd - HYD Branch'],
                ['gl_code' => '200034', 'ledger_name' => 'Main Book _Credit Fair- Branch A/c -Branch', 'gl_name' => 'Main Book _Credit Fair- Branch A/c -Branch'],
                ['gl_code' => '200035', 'ledger_name' => 'Hyd_BCPL_Creditfair Control A/c', 'gl_name' => 'Hyd_BCPL_Creditfair Control A/c'],
                ['gl_code' => '203000', 'ledger_name' => 'Cashback Payable', 'gl_name' => 'Cashback Payable'],
                ['gl_code' => '203001', 'ledger_name' => 'Holback Liability', 'gl_name' => 'Holback Liability'],
                ['gl_code' => '203002', 'ledger_name' => 'Subvention Liability', 'gl_name' => 'Subvention Liability'],
                ['gl_code' => '242000', 'ledger_name' => 'FLDG  Receivable/ Payable - Co Lending', 'gl_name' => 'FLDG  Receivable/ Payable - Co Lending'],
                ['gl_code' => '242001', 'ledger_name' => 'Foreclosure Charges Payable - Co Lending', 'gl_name' => 'Foreclosure Charges Payable - Co Lending'],
                ['gl_code' => '242002', 'ledger_name' => 'Foreclosure Charges Receivable - CoLending', 'gl_name' => 'Foreclosure Charges Receivable - CoLending'],
                ['gl_code' => '242003', 'ledger_name' => 'Insurance Payable - Co Lending', 'gl_name' => 'Insurance Payable - Co Lending'],
                ['gl_code' => '242004', 'ledger_name' => 'Interest Payable - Co Lending', 'gl_name' => 'Interest Payable - Co Lending'],
                ['gl_code' => '242005', 'ledger_name' => 'Loan Processing Fee Payable - Co Lending', 'gl_name' => 'Loan Processing Fee Payable - Co Lending'],
                ['gl_code' => '242006', 'ledger_name' => 'Other Advances (Daily Collections) - Co Lending', 'gl_name' => 'Other Advances (Daily Collections) - Co Lending'],
                ['gl_code' => '242008', 'ledger_name' => 'Penal Charges Payable - Co Lending', 'gl_name' => 'Penal Charges Payable - Co Lending'],
                ['gl_code' => '242009', 'ledger_name' => 'Principal Payable - Co Lending', 'gl_name' => 'Principal Payable - Co Lending'],
                ['gl_code' => '206000', 'ledger_name' => 'Admin  Liability Payable', 'gl_name' => 'Admin  Liability Payable'],
                ['gl_code' => '206001', 'ledger_name' => 'Bonus Payable', 'gl_name' => 'Bonus Payable'],
                ['gl_code' => '206002', 'ledger_name' => 'Duties & Taxes - ESIC', 'gl_name' => 'Duties & Taxes - ESIC'],
                ['gl_code' => '206003', 'ledger_name' => 'Duties & Taxes - LWF', 'gl_name' => 'Duties & Taxes - LWF'],
                ['gl_code' => '206004', 'ledger_name' => 'Duties & Taxes - PT', 'gl_name' => 'Duties & Taxes - PT'],
                ['gl_code' => '206005', 'ledger_name' => 'Employee NPS Deduction', 'gl_name' => 'Employee NPS Deduction'],
                ['gl_code' => '206006', 'ledger_name' => 'P.F. Admin Charges- Payable', 'gl_name' => 'P.F. Admin Charges- Payable'],
                ['gl_code' => '206007', 'ledger_name' => 'P.F.Contribution - Employee - 12%', 'gl_name' => 'P.F.Contribution - Employee - 12%'],
                ['gl_code' => '206008', 'ledger_name' => 'P.F.Contribution - Employer - 12%', 'gl_name' => 'P.F.Contribution - Employer - 12%'],
                ['gl_code' => '206009', 'ledger_name' => 'P.F.Insurance Perium-Payable', 'gl_name' => 'P.F.Insurance Perium-Payable'],
                ['gl_code' => '206010', 'ledger_name' => 'Provision for gratuity', 'gl_name' => 'Provision for gratuity'],
                ['gl_code' => '206011', 'ledger_name' => 'Provision for leave salary', 'gl_name' => 'Provision for leave salary'],
                ['gl_code' => '206012', 'ledger_name' => 'Provision for PSOP', 'gl_name' => 'Provision for PSOP'],
                ['gl_code' => '206013', 'ledger_name' => 'Salary Payable', 'gl_name' => 'Salary Payable'],
                ['gl_code' => '206014', 'ledger_name' => 'VPF Cont Employee', 'gl_name' => 'VPF Cont Employee'],
                ['gl_code' => '206015', 'ledger_name' => 'PT Liability Employer', 'gl_name' => 'PT Liability Employer'],
                ['gl_code' => '209000', 'ledger_name' => 'CGST @ 1.25% Receivable', 'gl_name' => 'CGST @ 1.25% Receivable'],
                ['gl_code' => '209001', 'ledger_name' => 'CGST @ 2.5% Receivable', 'gl_name' => 'CGST @ 2.5% Receivable'],
                ['gl_code' => '209002', 'ledger_name' => 'CGST @ 3% Receivable', 'gl_name' => 'CGST @ 3% Receivable'],
                ['gl_code' => '209003', 'ledger_name' => 'CGST @ 4.5% Receivable', 'gl_name' => 'CGST @ 4.5% Receivable'],
                ['gl_code' => '209004', 'ledger_name' => 'CGST @ 9% Receivable', 'gl_name' => 'CGST @ 9% Receivable'],
                ['gl_code' => '209005', 'ledger_name' => 'SGST @ 1.25% Receivable', 'gl_name' => 'SGST @ 1.25% Receivable'],
                ['gl_code' => '209006', 'ledger_name' => 'SGST @ 2.5% Receivable', 'gl_name' => 'SGST @ 2.5% Receivable'],
                ['gl_code' => '209007', 'ledger_name' => 'SGST @ 3% Receivable', 'gl_name' => 'SGST @ 3% Receivable'],
                ['gl_code' => '209008', 'ledger_name' => 'SGST @ 4.5% Receivable', 'gl_name' => 'SGST @ 4.5% Receivable'],
                ['gl_code' => '209009', 'ledger_name' => 'SGST @ 9% Receivable', 'gl_name' => 'SGST @ 9% Receivable'],
                ['gl_code' => '209010', 'ledger_name' => 'IGST @ 2.5% Receivable', 'gl_name' => 'IGST @ 2.5% Receivable'],
                ['gl_code' => '209011', 'ledger_name' => 'IGST @ 9% Receivable', 'gl_name' => 'IGST @ 9% Receivable'],
                ['gl_code' => '209012', 'ledger_name' => 'IGST @ 18% Receivable', 'gl_name' => 'IGST @ 18% Receivable'],
                ['gl_code' => '209013', 'ledger_name' => 'RCM Receivable � CGST', 'gl_name' => 'RCM Receivable � CGST'],
                ['gl_code' => '209014', 'ledger_name' => 'RCM Receivable � SGST', 'gl_name' => 'RCM Receivable � SGST'],
                ['gl_code' => '209015', 'ledger_name' => 'RCM Receivable � IGST', 'gl_name' => 'RCM Receivable � IGST'],
                ['gl_code' => '209016', 'ledger_name' => 'IGST RCM Receivable @ 18%', 'gl_name' => 'IGST RCM Receivable @ 18%'],
                ['gl_code' => '209017', 'ledger_name' => 'CGST Credit Ledger', 'gl_name' => 'CGST Credit Ledger'],
                ['gl_code' => '209018', 'ledger_name' => 'SGST Credit Ledger', 'gl_name' => 'SGST Credit Ledger'],
                ['gl_code' => '209019', 'ledger_name' => 'IGST Credit Ledger', 'gl_name' => 'IGST Credit Ledger'],
                ['gl_code' => '209020', 'ledger_name' => 'RCM CGST Electronic Credit Ledger', 'gl_name' => 'RCM CGST Electronic Credit Ledger'],
                ['gl_code' => '209021', 'ledger_name' => 'RCM SGST Electronic Credit Ledger', 'gl_name' => 'RCM SGST Electronic Credit Ledger'],
                ['gl_code' => '209022', 'ledger_name' => 'RCM IGST Electronic Credit Ledger', 'gl_name' => 'RCM IGST Electronic Credit Ledger'],
                ['gl_code' => '209023', 'ledger_name' => 'RCM Payable � CGST', 'gl_name' => 'RCM Payable � CGST'],
                ['gl_code' => '209024', 'ledger_name' => 'RCM Payable � SGST', 'gl_name' => 'RCM Payable � SGST'],
                ['gl_code' => '209025', 'ledger_name' => 'RCM Payable � IGST', 'gl_name' => 'RCM Payable � IGST'],
                ['gl_code' => '209026', 'ledger_name' => 'CGST @ 4.5% Receivable � ISD', 'gl_name' => 'CGST @ 4.5% Receivable � ISD'],
                ['gl_code' => '209027', 'ledger_name' => 'SGST @ 4.5% Receivable � ISD', 'gl_name' => 'SGST @ 4.5% Receivable � ISD'],
                ['gl_code' => '209028', 'ledger_name' => 'IGST @ 9% Receivable � ISD', 'gl_name' => 'IGST @ 9% Receivable � ISD'],
                ['gl_code' => '209029', 'ledger_name' => 'CGST Interim Account', 'gl_name' => 'CGST Interim Account'],
                ['gl_code' => '209030', 'ledger_name' => 'SGST Interim Account', 'gl_name' => 'SGST Interim Account'],
                ['gl_code' => '209031', 'ledger_name' => 'IGST Interim Account', 'gl_name' => 'IGST Interim Account'],
                ['gl_code' => '209032', 'ledger_name' => 'CGST Interim � ISD', 'gl_name' => 'CGST Interim � ISD'],
                ['gl_code' => '209033', 'ledger_name' => 'SGST Interim � ISD', 'gl_name' => 'SGST Interim � ISD'],
                ['gl_code' => '209034', 'ledger_name' => 'IGST Interim � ISD', 'gl_name' => 'IGST Interim � ISD'],
                ['gl_code' => '209035', 'ledger_name' => 'CGST Cash Ledger', 'gl_name' => 'CGST Cash Ledger'],
                ['gl_code' => '209036', 'ledger_name' => 'SGST Cash Ledger', 'gl_name' => 'SGST Cash Ledger'],
                ['gl_code' => '209037', 'ledger_name' => 'IGST Cash Ledger', 'gl_name' => 'IGST Cash Ledger'],
                ['gl_code' => '209038', 'ledger_name' => 'GST Cash Ledger (Mumbai)', 'gl_name' => 'GST Cash Ledger (Mumbai)'],
                ['gl_code' => '245001', 'ledger_name' => 'Interest Due Payable on Borrowings - Term Loan Banks', 'gl_name' => 'Interest Due Payable on Borrowings - Term Loan Banks'],
                ['gl_code' => '245000', 'ledger_name' => 'Interest Due Payable on Borrowings - ECB', 'gl_name' => 'Interest Due Payable on Borrowings - ECB'],
                ['gl_code' => '245002', 'ledger_name' => 'Interest Due Payable on Borrowings - NCD Series', 'gl_name' => 'Interest Due Payable on Borrowings - NCD Series'],
                ['gl_code' => '245003', 'ledger_name' => 'Interest Due Payable on Borrowings - Term Loan FI\'s', 'gl_name' => 'Interest Due Payable on Borrowings - Term Loan FI\'s'],
                ['gl_code' => '245004', 'ledger_name' => 'Interest Due Payable on Borrowings - NCD - FI\'s', 'gl_name' => 'Interest Due Payable on Borrowings - NCD - FI\'s'],
                ['gl_code' => '245005', 'ledger_name' => 'Interest Due Payable on Borrowings - ICD', 'gl_name' => 'Interest Due Payable on Borrowings - ICD'],
                ['gl_code' => '245006', 'ledger_name' => 'Interest Due payable on Security Deposit', 'gl_name' => 'Interest Due payable on Security Deposit'],
                ['gl_code' => '212000', 'ledger_name' => 'Interest Accrued and due - OD/CC', 'gl_name' => 'Interest Accrued and due - OD/CC'],
                ['gl_code' => '212001', 'ledger_name' => 'Interest accrued but not due - Borrowings (Banks)', 'gl_name' => 'Interest accrued but not due - Borrowings (Banks)'],
                ['gl_code' => '212002', 'ledger_name' => 'Interest accrued but not due - Borrowings (ECB)', 'gl_name' => 'Interest accrued but not due - Borrowings (ECB)'],
                ['gl_code' => '212003', 'ledger_name' => 'Interest accrued but not due - Borrowings (ICD)', 'gl_name' => 'Interest accrued but not due - Borrowings (ICD)'],
                ['gl_code' => '212004', 'ledger_name' => 'Interest accrued but not due - Borrowings (NCD Series)', 'gl_name' => 'Interest accrued but not due - Borrowings (NCD Series)'],
                ['gl_code' => '212005', 'ledger_name' => 'Interest accrued but not due - Borrowings (Term Loan - FI\'s)', 'gl_name' => 'Interest accrued but not due - Borrowings (Term Loan - FI\'s)'],
                ['gl_code' => '212006', 'ledger_name' => 'Interest accrued but not due - Borrowings (NCD - FI\'s)', 'gl_name' => 'Interest accrued but not due - Borrowings (NCD - FI\'s)'],
                ['gl_code' => '212007', 'ledger_name' => 'Interest accrued but not due - Security Deposit', 'gl_name' => 'Interest accrued but not due - Security Deposit'],
                ['gl_code' => '215000', 'ledger_name' => 'Advances received  - Loans', 'gl_name' => 'Advances received  - Loans'],
                ['gl_code' => '215001', 'ledger_name' => 'Application Money - NCD', 'gl_name' => 'Application Money - NCD'],
                ['gl_code' => '215002', 'ledger_name' => 'Deferred Tax - Liability', 'gl_name' => 'Deferred Tax - Liability'],
                ['gl_code' => '215003', 'ledger_name' => 'Stamp Duty refundable', 'gl_name' => 'Stamp Duty refundable'],
                ['gl_code' => '215004', 'ledger_name' => 'Guarantees amount payable - USAID', 'gl_name' => 'Guarantees amount payable - USAID'],
                ['gl_code' => '236001', 'ledger_name' => 'Car Loan Payable', 'gl_name' => 'Car Loan Payable'],
                ['gl_code' => '236000', 'ledger_name' => 'Provison for TDS Recovery', 'gl_name' => 'Provison for TDS Recovery'],
                ['gl_code' => '248000', 'ledger_name' => 'LPF Received in Advance', 'gl_name' => 'LPF Received in Advance'],
                ['gl_code' => '248001', 'ledger_name' => 'Meal Coupon Payable', 'gl_name' => 'Meal Coupon Payable'],
                ['gl_code' => '218000', 'ledger_name' => 'Provision for Income  Tax AY 2019-20', 'gl_name' => 'Provision for Income  Tax AY 2019-20'],
                ['gl_code' => '218001', 'ledger_name' => 'Provision for Income  Tax AY 2020-21', 'gl_name' => 'Provision for Income  Tax AY 2020-21'],
                ['gl_code' => '218002', 'ledger_name' => 'Provision for Income  Tax AY 2021-22', 'gl_name' => 'Provision for Income  Tax AY 2021-22'],
                ['gl_code' => '218003', 'ledger_name' => 'Provision for Income  Tax AY 2022-23', 'gl_name' => 'Provision for Income  Tax AY 2022-23'],
                ['gl_code' => '218004', 'ledger_name' => 'Provision for Income  Tax AY 2023-24', 'gl_name' => 'Provision for Income  Tax AY 2023-24'],
                ['gl_code' => '218005', 'ledger_name' => 'Provision for Income  Tax AY 2024-25', 'gl_name' => 'Provision for Income  Tax AY 2024-25'],
                ['gl_code' => '218006', 'ledger_name' => 'Provision for Income Tax AY 2017-18', 'gl_name' => 'Provision for Income Tax AY 2017-18'],
                ['gl_code' => '218007', 'ledger_name' => 'Provision for Income Tax AY 2018-19', 'gl_name' => 'Provision for Income Tax AY 2018-19'],
                ['gl_code' => '218008', 'ledger_name' => 'Provision For Income Tax AY 2025-26', 'gl_name' => 'Provision For Income Tax AY 2025-26'],
                ['gl_code' => '218009', 'ledger_name' => 'Provision For Income Tax AY 2026-27', 'gl_name' => 'Provision For Income Tax AY 2026-27'],
                ['gl_code' => '221000', 'ledger_name' => 'ECL on Investments - Stage 1', 'gl_name' => 'ECL on Investments - Stage 1'],
                ['gl_code' => '221001', 'ledger_name' => 'ECL on Investments - Stage 2', 'gl_name' => 'ECL on Investments - Stage 2'],
                ['gl_code' => '221002', 'ledger_name' => 'ECL on Investments - Stage 3', 'gl_name' => 'ECL on Investments - Stage 3'],
                ['gl_code' => '224000', 'ledger_name' => 'ECL on Loan Commitments', 'gl_name' => 'ECL on Loan Commitments'],
                ['gl_code' => '224001', 'ledger_name' => 'ECL on Loans Stage 1', 'gl_name' => 'ECL on Loans Stage 1'],
                ['gl_code' => '224002', 'ledger_name' => 'ECL on Loans Stage 2', 'gl_name' => 'ECL on Loans Stage 2'],
                ['gl_code' => '224003', 'ledger_name' => 'ECL on Loans Stage 3', 'gl_name' => 'ECL on Loans Stage 3'],
                ['gl_code' => '239000', 'ledger_name' => 'DSRA - Security Deposit Liability - Loan', 'gl_name' => 'DSRA - Security Deposit Liability - Loan'],
                ['gl_code' => '239001', 'ledger_name' => 'Security Deposit - Stamp Duty - Respo Financial Capital Pvt Ltd', 'gl_name' => 'Security Deposit - Stamp Duty - Respo Financial Capital Pvt Ltd'],
                ['gl_code' => '227000', 'ledger_name' => 'TDS on commission-393(1)_1006', 'gl_name' => 'TDS on commission-393(1)_1006'],
                ['gl_code' => '227001', 'ledger_name' => 'TDS on commission-advance-393(1)_1006', 'gl_name' => 'TDS on commission-advance-393(1)_1006'],
                ['gl_code' => '227002', 'ledger_name' => 'TDS on interest on securties-advance-393(1)_1019', 'gl_name' => 'TDS on interest on securties-advance-393(1)_1019'],
                ['gl_code' => '227003', 'ledger_name' => 'TDS on Non-resident_Sec 393(1)_1055', 'gl_name' => 'TDS on Non-resident_Sec 393(1)_1055'],
                ['gl_code' => '227004', 'ledger_name' => 'TDS on Salary_Sec 392_1002', 'gl_name' => 'TDS on Salary_Sec 392_1002'],
                ['gl_code' => '227005', 'ledger_name' => 'TDS Payable � Contractors_Individual/HUF_Sec 393(1)_1023', 'gl_name' => 'TDS Payable � Contractors_Individual/HUF_Sec 393(1)_1023'],
                ['gl_code' => '227006', 'ledger_name' => 'TDS Payable � Contractors_Others_Sec 393(1)_1024', 'gl_name' => 'TDS Payable � Contractors_Others_Sec 393(1)_1024'],
                ['gl_code' => '227007', 'ledger_name' => 'TDS Payable - Interest (Other than securities)_Sec 393(1)_1022', 'gl_name' => 'TDS Payable - Interest (Other than securities)_Sec 393(1)_1022'],
                ['gl_code' => '227008', 'ledger_name' => 'TDS Payable - Interest on Securities_Sec 393(1)_1019', 'gl_name' => 'TDS Payable - Interest on Securities_Sec 393(1)_1019'],
                ['gl_code' => '227009', 'ledger_name' => 'TDS Payable � Non Resident_Interest_Sec 393(2)_1040', 'gl_name' => 'TDS Payable � Non Resident_Interest_Sec 393(2)_1040'],
                ['gl_code' => '227010', 'ledger_name' => 'TDS Payable � Non Resident_Interest_Sec 393(2)_1057', 'gl_name' => 'TDS Payable � Non Resident_Interest_Sec 393(2)_1057'],
                ['gl_code' => '227011', 'ledger_name' => 'TDS Payable � Professional Fees_Sec 393(1)_1026', 'gl_name' => 'TDS Payable � Professional Fees_Sec 393(1)_1026'],
                ['gl_code' => '227012', 'ledger_name' => 'TDS Payable � Professional Fees_Sec 393(1)_1027', 'gl_name' => 'TDS Payable � Professional Fees_Sec 393(1)_1027'],
                ['gl_code' => '227013', 'ledger_name' => 'TDS Payable � Rent other than machinery_Sec 393(1)_1009', 'gl_name' => 'TDS Payable � Rent other than machinery_Sec 393(1)_1009'],
                ['gl_code' => '227014', 'ledger_name' => 'TDS on Professional Fees-advance-393(1)_1027', 'gl_name' => 'TDS on Professional Fees-advance-393(1)_1027'],
                ['gl_code' => '227015', 'ledger_name' => 'TDS on Interest on Securities-advance-393(1)_1022', 'gl_name' => 'TDS on Interest on Securities-advance-393(1)_1022'],
                ['gl_code' => '230000', 'ledger_name' => 'TDS Gross refundable on Loans - FY24_25 not refelecting in 26AS', 'gl_name' => 'TDS Gross refundable on Loans - FY24_25 not refelecting in 26AS'],
                ['gl_code' => '230001', 'ledger_name' => 'TDS refundable on Loans - FY 24_25', 'gl_name' => 'TDS refundable on Loans - FY 24_25'],
                ['gl_code' => '230002', 'ledger_name' => 'TDS refundable on Loans - FY 25_26', 'gl_name' => 'TDS refundable on Loans - FY 25_26'],
                ['gl_code' => '230003', 'ledger_name' => 'TDS refundable on Loans - FY 26_27', 'gl_name' => 'TDS refundable on Loans - FY 26_27'],
                ['gl_code' => '251000', 'ledger_name' => 'Provision for Expenses Payable', 'gl_name' => 'Provision for Expenses Payable'],
                ['gl_code' => '251001', 'ledger_name' => 'Trade Payables', 'gl_name' => 'Trade Payables'],
                ['gl_code' => '303000', 'ledger_name' => 'Other Comprehensive Income', 'gl_name' => 'Other Comprehensive Income'],
                ['gl_code' => '303001', 'ledger_name' => 'Profit & Loss - Surplus', 'gl_name' => 'Profit & Loss - Surplus'],
                ['gl_code' => '303002', 'ledger_name' => 'Retained Earning (R&S)', 'gl_name' => 'Retained Earning (R&S)'],
                ['gl_code' => '303003', 'ledger_name' => 'Securities Premium', 'gl_name' => 'Securities Premium'],
                ['gl_code' => '303004', 'ledger_name' => 'Special Reserve U/s 45 IC', 'gl_name' => 'Special Reserve U/s 45 IC'],
            ];

            $now = date('Y-m-d H:i:s');
            foreach ($initialGlCodes as &$row) {
                $row['is_active'] = 1;
                $row['created_at'] = $now;
                $row['updated_at'] = $now;
            }

            DB::table('odoo_gl_codes')->insert($initialGlCodes);
        }
    }

    public function down()
    {
        Schema::dropIfExists('odoo_gl_codes');
    }
}
