{"token":"77ee4bb2-7ec6-419b-8368-9a3db3b5d247","title":"Weekly Cash Flow \u0026 Liquidity Monitoring","dashboard_str":"{\"items\":[{\"id\":\"3\",\"type\":\"block_filter\",\"startCol\":1,\"rowIndex\":0,\"w\":12,\"loading\":false,\"adaptiveHeight\":false,\"content\":[{\"name\":\"Week\",\"field\":\"Date\",\"type\":\"date\",\"description\":\"Week start date\",\"format\":\"YYYY-MM-DD\"},{\"name\":\"Opening Balance Range\",\"field\":\"Opening Balance\",\"type\":\"number\",\"description\":\"Filter by starting cash balance\"},{\"name\":\"Closing Balance Range\",\"field\":\"Closing Balance\",\"type\":\"number\",\"description\":\"Filter by ending cash balance\"},{\"name\":\"Net Cash Flow Range\",\"field\":\"Net Cash Flow\",\"type\":\"number\",\"description\":\"Filter by weekly net cash flow\"},{\"name\":\"Loan Disbursement Range\",\"field\":\"Loan Disbursements\",\"type\":\"number\",\"description\":\"Filter by loan disbursement volume\"},{\"name\":\"Loan Repayment Range\",\"field\":\"Loan Repayments\",\"type\":\"number\",\"description\":\"Filter by loan repayment volume\"}],\"someTypeIndex\":1},{\"id\":\"6dd6y8zfa0\",\"type\":\"block_core_metrics\",\"w\":2,\"startCol\":1,\"rowIndex\":1,\"adaptiveHeight\":false,\"title\":\"Core Metrics\",\"content\":{\"results\":[{\"name\":\"Net Cash Flow\",\"value\":4415842.12,\"field_name\":\"\\\"Net Cash Flow\\\"\",\"alias\":\"Net Cash Flow\"}],\"block_id\":\"block_127573\"},\"loading\":false},{\"id\":\"316ki1g1av\",\"type\":\"block_core_metrics\",\"startCol\":3,\"w\":2,\"rowIndex\":1,\"loading\":false,\"adaptiveHeight\":false,\"title\":\"Core Metrics\",\"content\":{\"results\":[{\"name\":\"Total Cash Inflows\",\"value\":122158456,\"field_name\":\"Cash Inflows\",\"alias\":\"Total Cash Inflows\"}],\"block_id\":\"block_122470\"}},{\"id\":\"uy1e0924tn\",\"type\":\"block_core_metrics\",\"startCol\":5,\"w\":2,\"rowIndex\":1,\"loading\":false,\"adaptiveHeight\":false,\"title\":\"Core Metrics\",\"content\":{\"results\":[{\"name\":\"Total Cash Outflows\",\"value\":108888622,\"field_name\":\"\\\"Cash Outflows\\\"\",\"alias\":\"Total Cash Outflows\"}],\"block_id\":\"block_115008\"}},{\"id\":\"v88za2zcyv\",\"type\":\"block_core_metrics\",\"startCol\":7,\"w\":2,\"rowIndex\":1,\"loading\":false,\"adaptiveHeight\":false,\"title\":\"Core Metrics\",\"content\":{\"results\":[{\"name\":\"Average Closing Balance\",\"value\":17204923.93,\"field_name\":\"Closing Balance\",\"alias\":\"Average Closing Balance\"}],\"block_id\":\"block_122112\"}},{\"id\":\"o6jfyhzdjp\",\"type\":\"block_core_metrics\",\"startCol\":9,\"w\":2,\"rowIndex\":1,\"loading\":false,\"adaptiveHeight\":false,\"title\":\"Core Metrics\",\"content\":{\"results\":[{\"name\":\"Loan Utilization Ratio\",\"value\":\"47.66%\",\"field_name\":\"Loan Utilization Ratio\",\"alias\":\"Loan Utilization Ratio\"}],\"block_id\":\"block_162135\"}},{\"id\":\"xe2dqw9qax\",\"type\":\"block_core_metrics\",\"startCol\":11,\"w\":2,\"rowIndex\":1,\"adaptiveHeight\":false,\"title\":\"Core Metrics\",\"content\":{\"results\":[{\"name\":\"Fee Income Margin\",\"value\":\"170.00%\",\"field_name\":\"Fee Income Margin\",\"alias\":\"Fee Income Margin\"}],\"block_id\":\"block_178611\"},\"loading\":false},{\"id\":\"hyl88exmmr\",\"type\":\"block_chart\",\"w\":4,\"startCol\":1,\"rowIndex\":2,\"adaptiveHeight\":false,\"content\":{\"block_id\":\"block_138266\",\"chart\":\"{\\\"legend\\\":{\\\"data\\\":[\\\"Closing Balance\\\"],\\\"top\\\":\\\"bottom\\\"},\\\"series\\\":[{\\\"data\\\":[6170831,7236956,7200772,8038325,9100069,8911794,9337989,10481375,11037249,9956232,11134205,11640794,12561933,13422243,13757421,13985197,14667615,15861518,16323072,15364579,15746880,15649938,15826340,16758502,16541972,16672977,16807565,17537778,16985738,17313501,17729836,17736485,17338650,17093098,16011686,16254996,15636919,15742433,15132045,15328732,15351926,14922228,15449642,16795855,17361645,16597674,17278440,16884680,16216108,17245856,17384062,18519022,19131355,18361885,17889725,19154947,20469694,20007755,19403149,19586153,20271754,19809123,19077008,18307048,18117478,17149746,17219790,17736273,18118424,18468466,19616199,19584990,19355997,19058163,19232816,19471471,19752377,20325949,20266081,20503437,20567911,20647452,21265217,20707178,20981474,21740621,23101680,23042053,22719106,22520200,22140973,21966231,22114008,22007391,22208902,21090490,20238234,20016893,19963171,19962577],\\\"name\\\":\\\"Closing Balance\\\",\\\"type\\\":\\\"line\\\"}],\\\"title\\\":{\\\"text\\\":\\\"\\\"},\\\"tooltip\\\":{\\\"trigger\\\":\\\"axis\\\"},\\\"xAxis\\\":{\\\"data\\\":[\\\"2025-05-12 00:00:00 +0000 UTC\\\",\\\"2025-05-19 00:00:00 +0000 UTC\\\",\\\"2025-05-26 00:00:00 +0000 UTC\\\",\\\"2025-06-02 00:00:00 +0000 UTC\\\",\\\"2025-06-09 00:00:00 +0000 UTC\\\",\\\"2025-06-16 00:00:00 +0000 UTC\\\",\\\"2025-06-23 00:00:00 +0000 UTC\\\",\\\"2025-06-30 00:00:00 +0000 UTC\\\",\\\"2025-07-07 00:00:00 +0000 UTC\\\",\\\"2025-07-14 00:00:00 +0000 UTC\\\",\\\"2025-07-21 00:00:00 +0000 UTC\\\",\\\"2025-07-28 00:00:00 +0000 UTC\\\",\\\"2025-08-04 00:00:00 +0000 UTC\\\",\\\"2025-08-11 00:00:00 +0000 UTC\\\",\\\"2025-08-18 00:00:00 +0000 UTC\\\",\\\"2025-08-25 00:00:00 +0000 UTC\\\",\\\"2025-09-01 00:00:00 +0000 UTC\\\",\\\"2025-09-08 00:00:00 +0000 UTC\\\",\\\"2025-09-15 00:00:00 +0000 UTC\\\",\\\"2025-09-22 00:00:00 +0000 UTC\\\",\\\"2025-09-29 00:00:00 +0000 UTC\\\",\\\"2025-10-06 00:00:00 +0000 UTC\\\",\\\"2025-10-13 00:00:00 +0000 UTC\\\",\\\"2025-10-20 00:00:00 +0000 UTC\\\",\\\"2025-10-27 00:00:00 +0000 UTC\\\",\\\"2025-11-03 00:00:00 +0000 UTC\\\",\\\"2025-11-10 00:00:00 +0000 UTC\\\",\\\"2025-11-17 00:00:00 +0000 UTC\\\",\\\"2025-11-24 00:00:00 +0000 UTC\\\",\\\"2025-12-01 00:00:00 +0000 UTC\\\",\\\"2025-12-08 00:00:00 +0000 UTC\\\",\\\"2025-12-15 00:00:00 +0000 UTC\\\",\\\"2025-12-22 00:00:00 +0000 UTC\\\",\\\"2025-12-29 00:00:00 +0000 UTC\\\",\\\"2026-01-05 00:00:00 +0000 UTC\\\",\\\"2026-01-12 00:00:00 +0000 UTC\\\",\\\"2026-01-19 00:00:00 +0000 UTC\\\",\\\"2026-01-26 00:00:00 +0000 UTC\\\",\\\"2026-02-02 00:00:00 +0000 UTC\\\",\\\"2026-02-09 00:00:00 +0000 UTC\\\",\\\"2026-02-16 00:00:00 +0000 UTC\\\",\\\"2026-02-23 00:00:00 +0000 UTC\\\",\\\"2026-03-02 00:00:00 +0000 UTC\\\",\\\"2026-03-09 00:00:00 +0000 UTC\\\",\\\"2026-03-16 00:00:00 +0000 UTC\\\",\\\"2026-03-23 00:00:00 +0000 UTC\\\",\\\"2026-03-30 00:00:00 +0000 UTC\\\",\\\"2026-04-06 00:00:00 +0000 UTC\\\",\\\"2026-04-13 00:00:00 +0000 UTC\\\",\\\"2026-04-20 00:00:00 +0000 UTC\\\",\\\"2026-04-27 00:00:00 +0000 UTC\\\",\\\"2026-05-04 00:00:00 +0000 UTC\\\",\\\"2026-05-11 00:00:00 +0000 UTC\\\",\\\"2026-05-18 00:00:00 +0000 UTC\\\",\\\"2026-05-25 00:00:00 +0000 UTC\\\",\\\"2026-06-01 00:00:00 +0000 UTC\\\",\\\"2026-06-08 00:00:00 +0000 UTC\\\",\\\"2026-06-15 00:00:00 +0000 UTC\\\",\\\"2026-06-22 00:00:00 +0000 UTC\\\",\\\"2026-06-29 00:00:00 +0000 UTC\\\",\\\"2026-07-06 00:00:00 +0000 UTC\\\",\\\"2026-07-13 00:00:00 +0000 UTC\\\",\\\"2026-07-20 00:00:00 +0000 UTC\\\",\\\"2026-07-27 00:00:00 +0000 UTC\\\",\\\"2026-08-03 00:00:00 +0000 UTC\\\",\\\"2026-08-10 00:00:00 +0000 UTC\\\",\\\"2026-08-17 00:00:00 +0000 UTC\\\",\\\"2026-08-24 00:00:00 +0000 UTC\\\",\\\"2026-08-31 00:00:00 +0000 UTC\\\",\\\"2026-09-07 00:00:00 +0000 UTC\\\",\\\"2026-09-14 00:00:00 +0000 UTC\\\",\\\"2026-09-21 00:00:00 +0000 UTC\\\",\\\"2026-09-28 00:00:00 +0000 UTC\\\",\\\"2026-10-05 00:00:00 +0000 UTC\\\",\\\"2026-10-12 00:00:00 +0000 UTC\\\",\\\"2026-10-19 00:00:00 +0000 UTC\\\",\\\"2026-10-26 00:00:00 +0000 UTC\\\",\\\"2026-11-02 00:00:00 +0000 UTC\\\",\\\"2026-11-09 00:00:00 +0000 UTC\\\",\\\"2026-11-16 00:00:00 +0000 UTC\\\",\\\"2026-11-23 00:00:00 +0000 UTC\\\",\\\"2026-11-30 00:00:00 +0000 UTC\\\",\\\"2026-12-07 00:00:00 +0000 UTC\\\",\\\"2026-12-14 00:00:00 +0000 UTC\\\",\\\"2026-12-21 00:00:00 +0000 UTC\\\",\\\"2026-12-28 00:00:00 +0000 UTC\\\",\\\"2027-01-04 00:00:00 +0000 UTC\\\",\\\"2027-01-11 00:00:00 +0000 UTC\\\",\\\"2027-01-18 00:00:00 +0000 UTC\\\",\\\"2027-01-25 00:00:00 +0000 UTC\\\",\\\"2027-02-01 00:00:00 +0000 UTC\\\",\\\"2027-02-08 00:00:00 +0000 UTC\\\",\\\"2027-02-15 00:00:00 +0000 UTC\\\",\\\"2027-02-22 00:00:00 +0000 UTC\\\",\\\"2027-03-01 00:00:00 +0000 UTC\\\",\\\"2027-03-08 00:00:00 +0000 UTC\\\",\\\"2027-03-15 00:00:00 +0000 UTC\\\",\\\"2027-03-22 00:00:00 +0000 UTC\\\",\\\"2027-03-29 00:00:00 +0000 UTC\\\",\\\"2027-04-05 00:00:00 +0000 UTC\\\"],\\\"type\\\":\\\"category\\\"},\\\"yAxis\\\":{\\\"type\\\":\\\"value\\\"}}\",\"title\":\"Closing Balance Trend (Liquidity Monitoring)\"},\"loading\":false,\"changeCol\":0},{\"id\":\"13\",\"type\":\"block_chart\",\"content\":{\"block_id\":\"block_3104\",\"chart\":\"{\\\"legend\\\":{\\\"data\\\":[\\\"Loan Disbursements\\\",\\\"Loan Repayments\\\"],\\\"top\\\":\\\"bottom\\\"},\\\"series\\\":[{\\\"data\\\":[871155,844167,337337,391335,791723,728178,405041,659773,402283,321958,529365,918315,848143,689492,549457,865987,470936,898361,456508,804365,638974,223247,254886,435796,547449,349503,265725,329981,765894,439629,977089,924839,515139,471836,807086,375203,241090,987201,527069,621909,700186,356730,439931,268148,451995,772843,408261,396769,764685,463160,779879,331932,310268,399041,414176,584681,727035,528947,755839,456840,761353,423165,687879,982038,420884,667281,459178,932180,287498,384779,686232,673254,617113,848531,660337,964469,371829,823587,565838,721430,478167,976997,991743,652366,284654,519030,878843,306530,264820,521879,303355,458795,854811,473538,531236,931912,541097,735822,553531,224300],\\\"name\\\":\\\"Loan Disbursements\\\",\\\"type\\\":\\\"bar\\\"},{\\\"data\\\":[498951,582315,526896,270151,622525,795914,335340,259556,558923,683556,798663,451648,423109,368126,697707,403618,200015,260687,565515,521369,225766,601269,712332,450804,778776,797972,351664,641234,269176,781347,877270,592296,302906,438249,378576,414712,283767,286330,838519,857611,525713,501279,272096,255878,314899,529989,676981,565192,287848,729304,552690,424329,666588,736146,284633,751661,606551,334064,364020,368969,718550,537261,604589,767075,649046,810890,892139,386584,452918,438998,180535,272409,885716,348286,214044,350235,692335,835440,869064,198984,605808,163986,279312,174538,289182,308338,474767,193585,853550,630754,162666,434806,639570,773094,765270,561357,175939,802664,277948,171959],\\\"name\\\":\\\"Loan Repayments\\\",\\\"type\\\":\\\"bar\\\"}],\\\"title\\\":{\\\"text\\\":\\\"\\\"},\\\"tooltip\\\":{\\\"trigger\\\":\\\"axis\\\"},\\\"xAxis\\\":{\\\"data\\\":[\\\"2025-05-19\\\",\\\"2025-06-16\\\",\\\"2025-07-14\\\",\\\"2025-08-11\\\",\\\"2026-03-16\\\",\\\"2026-04-27\\\",\\\"2026-07-06\\\",\\\"2026-10-19\\\",\\\"2026-12-14\\\",\\\"2025-05-12\\\",\\\"2025-09-01\\\",\\\"2025-09-29\\\",\\\"2026-02-09\\\",\\\"2026-05-11\\\",\\\"2026-06-01\\\",\\\"2026-06-08\\\",\\\"2026-06-15\\\",\\\"2026-07-13\\\",\\\"2026-09-14\\\",\\\"2026-09-28\\\",\\\"2026-12-07\\\",\\\"2027-03-15\\\",\\\"2025-07-07\\\",\\\"2025-11-10\\\",\\\"2025-12-01\\\",\\\"2026-01-19\\\",\\\"2026-02-23\\\",\\\"2026-03-02\\\",\\\"2026-05-04\\\",\\\"2026-06-29\\\",\\\"2026-08-10\\\",\\\"2026-10-12\\\",\\\"2026-11-16\\\",\\\"2026-11-30\\\",\\\"2027-04-05\\\",\\\"2025-08-04\\\",\\\"2025-08-25\\\",\\\"2025-09-15\\\",\\\"2025-10-06\\\",\\\"2025-12-08\\\",\\\"2025-12-29\\\",\\\"2026-01-05\\\",\\\"2026-06-22\\\",\\\"2026-08-03\\\",\\\"2026-08-24\\\",\\\"2026-09-07\\\",\\\"2026-10-26\\\",\\\"2026-12-21\\\",\\\"2027-02-01\\\",\\\"2027-02-22\\\",\\\"2027-03-01\\\",\\\"2025-05-26\\\",\\\"2025-06-23\\\",\\\"2025-10-20\\\",\\\"2025-11-17\\\",\\\"2026-01-12\\\",\\\"2026-02-02\\\",\\\"2026-03-30\\\",\\\"2026-04-06\\\",\\\"2026-05-18\\\",\\\"2026-12-28\\\",\\\"2027-01-04\\\",\\\"2027-01-25\\\",\\\"2027-02-08\\\",\\\"2027-03-08\\\",\\\"2027-03-29\\\",\\\"2025-06-09\\\",\\\"2025-06-30\\\",\\\"2025-07-28\\\",\\\"2025-11-24\\\",\\\"2025-12-22\\\",\\\"2026-05-25\\\",\\\"2026-07-27\\\",\\\"2026-08-17\\\",\\\"2026-10-05\\\",\\\"2026-11-02\\\",\\\"2026-11-23\\\",\\\"2027-01-11\\\",\\\"2025-06-02\\\",\\\"2025-07-21\\\",\\\"2025-08-18\\\",\\\"2025-10-13\\\",\\\"2025-10-27\\\",\\\"2026-02-16\\\",\\\"2026-03-09\\\",\\\"2026-03-23\\\",\\\"2026-08-31\\\",\\\"2026-09-21\\\",\\\"2025-09-08\\\",\\\"2025-09-22\\\",\\\"2025-11-03\\\",\\\"2025-12-15\\\",\\\"2026-01-26\\\",\\\"2026-04-13\\\",\\\"2026-04-20\\\",\\\"2026-07-20\\\",\\\"2026-11-09\\\",\\\"2027-01-18\\\",\\\"2027-02-15\\\",\\\"2027-03-22\\\"],\\\"type\\\":\\\"category\\\"},\\\"yAxis\\\":{\\\"type\\\":\\\"value\\\"}}\",\"title\":\"Loan Disbursements vs Repayments by Week\"},\"startCol\":5,\"rowIndex\":2,\"w\":8,\"loading\":false,\"someTypeIndex\":4,\"adaptiveHeight\":false},{\"id\":\"5\",\"type\":\"block_chart\",\"startCol\":1,\"rowIndex\":3,\"w\":4,\"loading\":false,\"adaptiveHeight\":false,\"content\":{\"block_id\":\"block_3101\",\"chart\":\"{\\\"legend\\\":{\\\"data\\\":[\\\"Net Cash Flow\\\"],\\\"top\\\":\\\"bottom\\\"},\\\"series\\\":[{\\\"data\\\":[-175641.34,691224.75,52694.31,1131246.91,1475690.58,-454055.97,761652.52,575663.42,995122.12,-904959.63,648728.65,654686.98,941279.54,728516.39,440334,248403.14,951803.65,1764604.74,-253773.27,-851507.37,-96534.18,203201.62,-634938.99,1247327.82,-931759.03,-14123.13,129699.85,589801.56,-516022.38,540700.22,637269.8,-19607.04,-921923.84,-421620.11,-953539.16,412785.93,-178240.1,-127811.25,-740991.52,-230460.98,-454591.42,-349382.27,821526.15,1345391.71,399469.93,-994825.06,486932.65,-794046.06,-380985.37,1243907.21,199894.28,620933.72,283281.38,-872038.23,-884885.17,1400029.83,853776.11,-751500.8,-782064.89,522504.44,618330.42,-1103896.96,-1109557.38,-500096.36,-199772.53,-1082067.67,-435635.93,363305.75,-36740.95,105139.78,1237541.07,-142108.14,-518684.14,-744557.23,-155529.42,-165470.45,545867.28,-42781.66,-434510.91,15380.31,367919.42,30397.42,192837.66,-410250.34,425003.37,712223.25,1464236.22,-53502.42,-263195.09,-278322.35,-855659.98,-398649.3,-143177.31,145666.73,-27255.52,-894820.64,-476494.34,-288506.08,84636.51,-439657.32],\\\"name\\\":\\\"Net Cash Flow\\\",\\\"type\\\":\\\"line\\\"}],\\\"title\\\":{\\\"text\\\":\\\"\\\"},\\\"tooltip\\\":{\\\"trigger\\\":\\\"axis\\\"},\\\"xAxis\\\":{\\\"data\\\":[\\\"2025-05-12\\\",\\\"2025-05-19\\\",\\\"2025-05-26\\\",\\\"2025-06-02\\\",\\\"2025-06-09\\\",\\\"2025-06-16\\\",\\\"2025-06-23\\\",\\\"2025-06-30\\\",\\\"2025-07-07\\\",\\\"2025-07-14\\\",\\\"2025-07-21\\\",\\\"2025-07-28\\\",\\\"2025-08-04\\\",\\\"2025-08-11\\\",\\\"2025-08-18\\\",\\\"2025-08-25\\\",\\\"2025-09-01\\\",\\\"2025-09-08\\\",\\\"2025-09-15\\\",\\\"2025-09-22\\\",\\\"2025-09-29\\\",\\\"2025-10-06\\\",\\\"2025-10-13\\\",\\\"2025-10-20\\\",\\\"2025-10-27\\\",\\\"2025-11-03\\\",\\\"2025-11-10\\\",\\\"2025-11-17\\\",\\\"2025-11-24\\\",\\\"2025-12-01\\\",\\\"2025-12-08\\\",\\\"2025-12-15\\\",\\\"2025-12-22\\\",\\\"2025-12-29\\\",\\\"2026-01-05\\\",\\\"2026-01-12\\\",\\\"2026-01-19\\\",\\\"2026-01-26\\\",\\\"2026-02-02\\\",\\\"2026-02-09\\\",\\\"2026-02-16\\\",\\\"2026-02-23\\\",\\\"2026-03-02\\\",\\\"2026-03-09\\\",\\\"2026-03-16\\\",\\\"2026-03-23\\\",\\\"2026-03-30\\\",\\\"2026-04-06\\\",\\\"2026-04-13\\\",\\\"2026-04-20\\\",\\\"2026-04-27\\\",\\\"2026-05-04\\\",\\\"2026-05-11\\\",\\\"2026-05-18\\\",\\\"2026-05-25\\\",\\\"2026-06-01\\\",\\\"2026-06-08\\\",\\\"2026-06-15\\\",\\\"2026-06-22\\\",\\\"2026-06-29\\\",\\\"2026-07-06\\\",\\\"2026-07-13\\\",\\\"2026-07-20\\\",\\\"2026-07-27\\\",\\\"2026-08-03\\\",\\\"2026-08-10\\\",\\\"2026-08-17\\\",\\\"2026-08-24\\\",\\\"2026-08-31\\\",\\\"2026-09-07\\\",\\\"2026-09-14\\\",\\\"2026-09-21\\\",\\\"2026-09-28\\\",\\\"2026-10-05\\\",\\\"2026-10-12\\\",\\\"2026-10-19\\\",\\\"2026-10-26\\\",\\\"2026-11-02\\\",\\\"2026-11-09\\\",\\\"2026-11-16\\\",\\\"2026-11-23\\\",\\\"2026-11-30\\\",\\\"2026-12-07\\\",\\\"2026-12-14\\\",\\\"2026-12-21\\\",\\\"2026-12-28\\\",\\\"2027-01-04\\\",\\\"2027-01-11\\\",\\\"2027-01-18\\\",\\\"2027-01-25\\\",\\\"2027-02-01\\\",\\\"2027-02-08\\\",\\\"2027-02-15\\\",\\\"2027-02-22\\\",\\\"2027-03-01\\\",\\\"2027-03-08\\\",\\\"2027-03-15\\\",\\\"2027-03-22\\\",\\\"2027-03-29\\\",\\\"2027-04-05\\\"],\\\"type\\\":\\\"category\\\"},\\\"yAxis\\\":{\\\"type\\\":\\\"value\\\"}}\",\"title\":\"Net Cash Flow Trend by Week\"},\"someTypeIndex\":1,\"changeCol\":0},{\"id\":\"7\",\"type\":\"block_table\",\"startCol\":5,\"rowIndex\":3,\"w\":8,\"loading\":false,\"adaptiveHeight\":false,\"content\":{\"block_id\":\"block_54120\",\"data\":[[\"Week\",\"Opening_Balance\",\"Cash_Inflows\",\"Cash_Outflows\",\"Net_Cash_Flow\",\"Closing_Balance\",\"Loan_Disbursements\",\"Loan_Repayments\",\"Fees_And_Charges\",\"Interest_Earned\"],[\"2025-05-12\",6692743,610268,1132180,-175641.34,6170831,321958,683556,18545,3217.66],[\"2025-05-19\",6170831,1603462,537337,691224.75,7236956,871155,498951,5663,2966.75],[\"2025-05-26\",7236956,1499890,1536074,52694.31,7200772,331932,424329,6998,3479.31],[\"2025-06-02\",7200772,1412756,575203,1131246.91,8038325,565838,869064,12994,3461.91],[\"2025-06-09\",8038325,1739911,678167,1475690.58,9100069,459178,892139,22879,3864.58],[\"2025-06-16\",9100069,541090,729365,-454055.97,8911794,844167,582315,8304,4375.03],[\"2025-06-23\",8911794,1613396,1187201,761652.52,9337989,310268,666588,25147,4284.52],[\"2025-06-30\",9337989,1870455,727069,575663.42,10481375,932180,386584,26616,4489.42],[\"2025-07-07\",10481375,1747617,1191743,995122.12,11037249,254886,712332,23237,5039.12],[\"2025-07-14\",11037249,603355,1684372,-904959.63,9956232,337337,526896,18808,5306.37],[\"2025-07-21\",9956232,1762752,584779,648728.65,11134205,721430,198984,11585,4786.65],[\"2025-07-28\",11134205,1896025,1389436,654686.98,11640794,287498,452918,22675,5352.98],[\"2025-08-04\",11640794,1807371,886232,941279.54,12561933,375203,414712,24965,5596.54],[\"2025-08-11\",12561933,1417040,556730,728516.39,13422243,391335,270151,16649,6039.39],[\"2025-08-18\",13422243,1933257,1598079,440334,13757421,478167,605808,28938,6453],[\"2025-08-25\",13757421,1154811,927035,248403.14,13985197,241090,283767,28664,6614.14],[\"2025-09-01\",13985197,1148143,465725,951803.65,14667615,529365,798663,6636,6723.65],[\"2025-09-08\",14667615,1678557,484654,1764604.74,15861518,264820,853550,25080,7051.74],[\"2025-09-15\",15861518,1453277,991723,-253773.27,16323072,987201,286330,22082,7625.73],[\"2025-09-22\",16323072,819030,1777523,-851507.37,15364579,521879,630754,9737,7847.63]],\"title\":\"Weekly Cash Flow Summary\"},\"someTypeIndex\":1,\"changeCol\":0},{\"id\":\"6\",\"type\":\"block_chart\",\"startCol\":1,\"rowIndex\":4,\"w\":4,\"loading\":false,\"adaptiveHeight\":false,\"content\":{\"block_id\":\"block_3102\",\"chart\":\"{\\\"legend\\\":{\\\"data\\\":[\\\"Cash Inflows\\\",\\\"Cash Outflows\\\"],\\\"top\\\":\\\"bottom\\\"},\\\"series\\\":[{\\\"data\\\":[1603462,541090,603355,1417040,1572876,802918,1924289,1374371,609556,1678557,819030,1819512,1303591,702283,1016588,1478732,989570,1713475,887261,999046,618451,1747617,1788205,1406606,771836,1282038,1507293,1668727,1579111,639182,1733916,1499238,543585,1762859,1412756,1762752,1933257,1065894,849457,987879,1769460,1033556,1397421,622409,1499890,1613396,1805416,1198361,1863715,1061353,1822905,932315,980754,1701482,1836825,1185440,627948,665838,539353,1807371,1154811,1453277,831236,1072843,960337,708261,1128776,701664,1539577,1667752,1654454,700235,637848,521959,1515602,610268,1148143,1055839,1546797,1148663,1677888,1849380,788998,851279,1766702,1269598,1460061,561087,1739911,1870455,1896025,1148531,606530,513986,524538,684064,1272838,1746862,879989,908923],\\\"name\\\":\\\"Cash Inflows\\\",\\\"type\\\":\\\"bar\\\"},{\\\"data\\\":[537337,729365,1684372,556730,1007086,664712,1238688,1135716,1167595,484654,1777523,1688507,1296942,596769,1685160,448984,1721685,1773343,1210208,851269,839792,1191743,1653617,1078843,1389913,1711736,979879,533767,1396107,1606914,1559263,1261882,464044,1763453,575203,584779,1598079,889492,1065987,964685,423247,1797527,1015270,653618,1536074,1187201,873254,468148,1620405,1671741,1142139,1326075,1750224,942335,475766,1384346,802690,1784250,593075,886232,927035,991723,928178,656508,1205889,1789673,1733382,891234,1023094,1317710,1373548,425939,1017075,628576,1314091,1132180,465725,673538,1350110,536330,412666,534633,1250937,1313910,618969,1498591,842296,1413343,678167,727069,1389436,1700571,1004365,986146,1294498,614020,1570672,1173290,815515,968550],\\\"name\\\":\\\"Cash Outflows\\\",\\\"type\\\":\\\"bar\\\"}],\\\"title\\\":{\\\"text\\\":\\\"\\\"},\\\"tooltip\\\":{\\\"trigger\\\":\\\"axis\\\"},\\\"xAxis\\\":{\\\"data\\\":[\\\"2025-05-19\\\",\\\"2025-06-16\\\",\\\"2025-07-14\\\",\\\"2025-08-11\\\",\\\"2026-03-16\\\",\\\"2026-04-27\\\",\\\"2026-07-06\\\",\\\"2026-10-19\\\",\\\"2026-12-14\\\",\\\"2025-09-08\\\",\\\"2025-09-22\\\",\\\"2025-11-03\\\",\\\"2025-12-15\\\",\\\"2026-01-26\\\",\\\"2026-04-13\\\",\\\"2026-04-20\\\",\\\"2026-07-20\\\",\\\"2026-11-09\\\",\\\"2027-01-18\\\",\\\"2027-02-15\\\",\\\"2027-03-22\\\",\\\"2025-07-07\\\",\\\"2025-11-10\\\",\\\"2025-12-01\\\",\\\"2026-01-19\\\",\\\"2026-02-23\\\",\\\"2026-03-02\\\",\\\"2026-05-04\\\",\\\"2026-06-29\\\",\\\"2026-08-10\\\",\\\"2026-10-12\\\",\\\"2026-11-16\\\",\\\"2026-11-30\\\",\\\"2027-04-05\\\",\\\"2025-06-02\\\",\\\"2025-07-21\\\",\\\"2025-08-18\\\",\\\"2025-10-13\\\",\\\"2025-10-27\\\",\\\"2026-02-16\\\",\\\"2026-03-09\\\",\\\"2026-03-23\\\",\\\"2026-08-31\\\",\\\"2026-09-21\\\",\\\"2025-05-26\\\",\\\"2025-06-23\\\",\\\"2025-10-20\\\",\\\"2025-11-17\\\",\\\"2026-01-12\\\",\\\"2026-02-02\\\",\\\"2026-03-30\\\",\\\"2026-04-06\\\",\\\"2026-05-18\\\",\\\"2026-12-28\\\",\\\"2027-01-04\\\",\\\"2027-01-25\\\",\\\"2027-02-08\\\",\\\"2027-03-08\\\",\\\"2027-03-29\\\",\\\"2025-08-04\\\",\\\"2025-08-25\\\",\\\"2025-09-15\\\",\\\"2025-10-06\\\",\\\"2025-12-08\\\",\\\"2025-12-29\\\",\\\"2026-01-05\\\",\\\"2026-06-22\\\",\\\"2026-08-03\\\",\\\"2026-08-24\\\",\\\"2026-09-07\\\",\\\"2026-10-26\\\",\\\"2026-12-21\\\",\\\"2027-02-01\\\",\\\"2027-02-22\\\",\\\"2027-03-01\\\",\\\"2025-05-12\\\",\\\"2025-09-01\\\",\\\"2025-09-29\\\",\\\"2026-02-09\\\",\\\"2026-05-11\\\",\\\"2026-06-01\\\",\\\"2026-06-08\\\",\\\"2026-06-15\\\",\\\"2026-07-13\\\",\\\"2026-09-14\\\",\\\"2026-09-28\\\",\\\"2026-12-07\\\",\\\"2027-03-15\\\",\\\"2025-06-09\\\",\\\"2025-06-30\\\",\\\"2025-07-28\\\",\\\"2025-11-24\\\",\\\"2025-12-22\\\",\\\"2026-05-25\\\",\\\"2026-07-27\\\",\\\"2026-08-17\\\",\\\"2026-10-05\\\",\\\"2026-11-02\\\",\\\"2026-11-23\\\",\\\"2027-01-11\\\"],\\\"type\\\":\\\"category\\\"},\\\"yAxis\\\":{\\\"type\\\":\\\"value\\\"}}\",\"title\":\"Cash Inflows vs Outflows by Week\"},\"someTypeIndex\":2},{\"id\":\"lfae8vpn8c\",\"type\":\"block_table\",\"startCol\":5,\"w\":8,\"rowIndex\":4,\"adaptiveHeight\":false,\"content\":{\"block_id\":\"block_144347\",\"data\":[[\"Date\",\"Cash Inflows\",\"Cash Outflows\"],[\"2025-05-12T00:00:00Z\",610268,1132180],[\"2025-05-19T00:00:00Z\",1603462,537337],[\"2025-05-26T00:00:00Z\",1499890,1536074],[\"2025-06-02T00:00:00Z\",1412756,575203],[\"2025-06-09T00:00:00Z\",1739911,678167],[\"2025-06-16T00:00:00Z\",541090,729365],[\"2025-06-23T00:00:00Z\",1613396,1187201],[\"2025-06-30T00:00:00Z\",1870455,727069],[\"2025-07-07T00:00:00Z\",1747617,1191743],[\"2025-07-14T00:00:00Z\",603355,1684372],[\"2025-07-21T00:00:00Z\",1762752,584779],[\"2025-07-28T00:00:00Z\",1896025,1389436],[\"2025-08-04T00:00:00Z\",1807371,886232],[\"2025-08-11T00:00:00Z\",1417040,556730],[\"2025-08-18T00:00:00Z\",1933257,1598079],[\"2025-08-25T00:00:00Z\",1154811,927035],[\"2025-09-01T00:00:00Z\",1148143,465725],[\"2025-09-08T00:00:00Z\",1678557,484654],[\"2025-09-15T00:00:00Z\",1453277,991723],[\"2025-09-22T00:00:00Z\",819030,1777523]],\"title\":\"Weekly Breakdown of Cash Inflows and Outflows\"},\"loading\":false}],\"rowHeights\":[194,148,367,504,431],\"cols\":12,\"gap\":12,\"theme\":\"neonDark\",\"title\":\"Weekly Cash Flow \u0026 Liquidity Monitoring\",\"totalFilters\":[{\"name\":\"Week\",\"field\":\"Date\",\"type\":\"date\",\"description\":\"Week start date\",\"format\":\"YYYY-MM-DD\"},{\"name\":\"Opening Balance Range\",\"field\":\"Opening Balance\",\"type\":\"number\",\"description\":\"Filter by starting cash balance\"},{\"name\":\"Closing Balance Range\",\"field\":\"Closing Balance\",\"type\":\"number\",\"description\":\"Filter by ending cash balance\"},{\"name\":\"Net Cash Flow Range\",\"field\":\"Net Cash Flow\",\"type\":\"number\",\"description\":\"Filter by weekly net cash flow\"},{\"name\":\"Loan Disbursement Range\",\"field\":\"Loan Disbursements\",\"type\":\"number\",\"description\":\"Filter by loan disbursement volume\"},{\"name\":\"Loan Repayment Range\",\"field\":\"Loan Repayments\",\"type\":\"number\",\"description\":\"Filter by loan repayment volume\"}],\"viewInfos\":[{\"id\":10978,\"hashId\":\"0eb64563ace8aa02adf960bf1e3a4aae\",\"file_name\":\"Weekly Cash Flow Analysis.xlsx\",\"file_url\":\"https://excelmatic.nyc3.cdn.digitaloceanspaces.com/dashboard/weekly-cash-flow-analysis.xlsx\"}],\"query\":\"Monitor key business metrics in real time, respond quickly to anomalies, and make operations management more precise and efficient.\",\"usedFilter\":[]}","updated_at":1765521433}