Spreadsheet: 879447d1726980209-delete-all-rows-with-same-allocation-reference-sums-upto-zero-sample
Sheet: Result i want 

Account Code | Description | Accounting Period | Transaction Date | Transaction Reference | Description | Base Amount | D/C | Allocation Reference | Analysis Code | Name | Analysis Code | Name | Analysis Code | Name | Analysis Code | Name | Analysis Code | Name
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/001 | 2023-07-04 00:00:00 | PM23/338598 | 78735UEDCL MAYUGE 19UBE 547Q | 978520 | D | 60854 | 7074 | UBE 547Q | 23851 | Mabandha Asuman
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/001 | 2023-07-25 00:00:00 | PM23/339926 | 78735UEDCL MAYUGE 19UBE 547Q | 787322 | D | 60854 | 7074 | UBE 547Q | 23851 | Mabandha Asuman
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/001 | 2023-07-31 00:00:00 | FP23/593309 | 78735UEDCL MAYUGE 19UBE 547Q | -957346 | C | 60854 | 7074 | UBE 547Q | 23851 | Mabandha Asuman
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/002 | 2023-08-28 00:00:00 | PM23/342201 | 78735UEDCL MAYUGE 19UBE 547Q | 917707 | D | 60854 | 7074 | UBE 547Q | 23851 | Mabandha Asuman
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/002 | 2023-08-31 00:00:00 | FP23/594403 | 78735UEDCL MAYUGE 19UBE 547Q | -1137971 | C | 60854 | 7074 | UBE 547Q | 23851 | Mabandha Asuman
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/003 | 2023-09-19 00:00:00 | PM23/343782 | 78735UEDCL MAYUGE 19UBE 547Q | 980475 | D | 60854 | 7074 | UBE 547Q | 23851 | Mabandha Asuman
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/003 | 2023-09-30 00:00:00 | FP23/595795 | 78735UEDCL MAYUGE 19UBE 547Q | -1471252 | C | 60854 | 7074 | UBE 547Q | 23851 | Mabandha Asuman
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/004 | 2023-10-04 00:00:00 | PM23/344838 | 78735UEDCL MAYUGE 19UBE 547Q | 881065 | D | 60854 | 7074 | UBE 547Q | 23851 | Mabandha Asuman
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/004 | 2023-10-31 00:00:00 | PM23/346600 | 78735UEDCL MAYUGE 19UBE 547Q | 981151 | D | 60854 | 7074 | UBE 547Q | 23851 | Mabandha Asuman
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/004 | 2023-10-31 00:00:00 | FP23/596472 | 78735UEDCL MAYUGE 19UBE 547Q | -981151 | C | 60854 | 7074 | UBE 547Q | 23851 | Mabandha Asuman
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/005 | 2023-11-17 00:00:00 | PM23/347959 | 78735UEDCL MAYUGE 19UBE 547Q | 742470 | D | 60854 | 7074 | UBE 547Q | 23851 | Mabandha Asuman
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/005 | 2023-11-30 00:00:00 | FP23/598554 | 78735UEDCL MAYUGE 19UBE 547Q | -1402150 | C | 60854 | 7074 | UBE 547Q | 23851 | Mabandha Asuman
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/006 | 2023-12-31 00:00:00 | FP23/599646 | 78735UEDCL MAYUGE 19UBE 547Q | -321524 | C | 60854 | 7074 | UBE 547Q | 23851 | Mabandha Asuman
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/001 | 2023-07-13 00:00:00 | PM23/339202 | 146284UEDCL RUGAAGA 19 SERVICINGUBE 375P | 415000 | D | 60857 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/001 | 2023-07-31 00:00:00 | FP23/593309 | 146284UEDCL RUGAAGA 19 SERVICINGUBE 375P | -209000 | C | 60857 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/002 | 2023-08-31 00:00:00 | FP23/594403 | 146284UEDCL RUGAAGA 19 SERVICINGUBE 375P | -244000 | C | 60857 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/003 | 2023-09-20 00:00:00 | PM23/343831 | 146284UEDCL RUGAAGA SERVICINGUBE 375P | 433000 | D | 60857 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/003 | 2023-09-30 00:00:00 | FP23/595795 | 146284UEDCL RUGAAGA 19 SERVICINGUBE 375P | -189000 | C | 60857 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/004 | 2023-10-31 00:00:00 | FP23/596472 | 146284UEDCL RUGAAGA 19 SERVICINGUBE 375P | -189000 | C | 60857 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/005 | 2023-11-30 00:00:00 | FP23/598554 | 146284UEDCL RUGAAGA 19 SERVICINGUBE 375P | -264000 | C | 60857 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/006 | 2023-12-01 00:00:00 | PM23/348961 | 146284UEDCL RUGAAGA 19 SERVICINGUBE 375P | 278000 | D | 60857 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/006 | 2023-12-31 00:00:00 | FP23/599646 | 146284UEDCL RUGAAGA 19 SERVICINGUBE 375P | -325000 | C | 60857 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/001 | 2023-07-04 00:00:00 | PM23/338598 | 78726UEDCL RUGAAGA 19UBE 375P | 510463 | D | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/001 | 2023-07-13 00:00:00 | PM23/339202 | 78726UEDCL RUGAAGA 19UBE 375P | 847507 | D | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/001 | 2023-07-21 00:00:00 | PM23/339753 | 78726UEDCL RUGAAGA 19UBE 375P | 902650 | D | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/001 | 2023-07-31 00:00:00 | FP23/593309 | 78726UEDCL RUGAAGA 19UBE 375P | -2417045 | C | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/002 | 2023-08-02 00:00:00 | PM23/340538 | 78726UEDCL RUGAAGA 19UBE 375P | 707359 | D | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/002 | 2023-08-16 00:00:00 | PM23/341483 | 78726UEDCL RUGAAGA 19UBE 375P | 713447 | D | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/002 | 2023-08-23 00:00:00 | PM23/341938 | 78726UEDCL RUGAAGA 19UBE 375P | 652970 | D | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/002 | 2023-08-30 00:00:00 | PM23/342404 | 78726UEDCL RUGAAGA 19UBE 375P | 880906 | D | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/002 | 2023-08-31 00:00:00 | FP23/594403 | 78726UEDCL RUGAAGA 19UBE 375P | -2436515 | C | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/003 | 2023-09-16 00:00:00 | PM23/343650 | 78726UEDCL RUGAAGA 19UBE 375P | 753410 | D | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/003 | 2023-09-22 00:00:00 | PM23/344006 | 78726UEDCL RUGAAGA 19UBE 375P | 820829 | D | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/003 | 2023-09-30 00:00:00 | FP23/595795 | 78726UEDCL RUGAAGA 19UBE 375P | -2110557 | C | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/004 | 2023-10-04 00:00:00 | PM23/344838 | 78726UEDCL RUGAAGA 19UBE 375P | 1087236 | D | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/004 | 2023-10-19 00:00:00 | PM23/345872 | 78726UEDCL RUGAAGA 19UBE 375P | 1083666 | D | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/004 | 2023-10-31 00:00:00 | FP23/596472 | 78726UEDCL RUGAAGA 19UBE 375P | -2369572 | C | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/005 | 2023-11-02 00:00:00 | PM23/346803 | 78726UEDCL RUGAAGA 19UBE 375P | 1097306 | D | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/005 | 2023-11-13 00:00:00 | PM23/347561 | 78726UEDCL RUGAAGA 19UBE 375P | 712603 | D | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/005 | 2023-11-23 00:00:00 | PM23/348394 | 78726UEDCL RUGAAGA 19UBE 375P | 793465 | D | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/005 | 2023-11-28 00:00:00 | PM23/348609 | 78726UEDCL RUGAAGA 19UBE 375P | 786580 | D | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/005 | 2023-11-30 00:00:00 | FP23/598554 | 78726UEDCL RUGAAGA 19UBE 375P | -2687475 | C | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/006 | 2023-12-07 00:00:00 | PM23/349385 | 78726UEDCL RUGAAGA 19UBE 375P | 596030 | D | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/006 | 2023-12-15 00:00:00 | PM23/349984 | 78726UEDCL RUGAAGA 19UBE 375P | 1001293 | D | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/006 | 2023-12-22 00:00:00 | PM23/350480 | 78726UEDCL RUGAAGA 19UBE 375P | 792419 | D | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/006 | 2023-12-31 00:00:00 | FP23/599646 | 78726UEDCL RUGAAGA 19UBE 375P | -3177962 | C | 60858 | 7073 | UBE 375P | 25023 | [NAME]
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/001 | 2023-07-13 00:00:00 | PM23/339202 | 78739UEDCL [NAME] 19UBE 241Q | 130000 | D | 60860 | 7068 | UBE 241Q | 28306 | Acan Stella Otto
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/001 | 2023-07-26 00:00:00 | PM23/340031 | 78739UEDCL [NAME] 19UBE 241Q | 1000000 | D | 60860 | 7068 | UBE 241Q | 28306 | Acan Stella Otto
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/001 | 2023-07-31 00:00:00 | FP23/593309 | 78739UEDCL [NAME] 19UBE 241Q | -287200 | C | 60860 | 7068 | UBE 241Q | 28306 | Acan Stella Otto
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/002 | 2023-08-16 00:00:00 | PM23/341483 | 78739UEDCL [NAME] 19UBE 241Q | 920280 | D | 60860 | 7068 | UBE 241Q | 28306 | Acan Stella Otto
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/002 | 2023-08-30 00:00:00 | PM23/342404 | 78739UEDCL [NAME] 19UBE 241Q | 818388 | D | 60860 | 7068 | UBE 241Q | 28306 | Acan Stella Otto
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/002 | 2023-08-31 00:00:00 | FP23/594403 | 78739UEDCL [NAME] 19UBE 241Q | -1915760 | C | 60860 | 7068 | UBE 241Q | 28306 | Acan Stella Otto
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/003 | 2023-09-08 00:00:00 | PM23/343154 | 78739UEDCL [NAME] 19UBE 241Q | 604395 | D | 60860 | 7068 | UBE 241Q | 28306 | Acan Stella Otto
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/003 | 2023-09-20 00:00:00 | PM23/343831 | 78739UEDCL [NAME] 19UBE 241Q | 842580 | D | 60860 | 7068 | UBE 241Q | 28306 | Acan Stella Otto
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/003 | 2023-09-30 00:00:00 | FP23/595795 | 78739UEDCL [NAME] 19UBE 241Q | -1613378 | C | 60860 | 7068 | UBE 241Q | 28306 | Acan Stella Otto
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/004 | 2023-10-12 00:00:00 | PM23/345392 | 78739UEDCL [NAME] 19UBE 241Q | 620972 | D | 60860 | 7068 | UBE 241Q | 28306 | Acan Stella Otto
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/004 | 2023-10-13 00:00:00 | PM23/345543 | 78739UEDCL [NAME] 19UBE 241Q | 299308 | D | 60860 | 7068 | UBE 241Q | 28306 | Acan Stella Otto
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/004 | 2023-10-24 00:00:00 | PM23/346136 | 78739UEDCL [NAME] 19UBE 241Q | 764382 | D | 60860 | 7068 | UBE 241Q | 28306 | Acan Stella Otto
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/004 | 2023-10-31 00:00:00 | FP23/596472 | 78739UEDCL [NAME] 19UBE 241Q | -1818392 | C | 60860 | 7068 | UBE 241Q | 28306 | Acan Stella Otto
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/005 | 2023-11-14 00:00:00 | PM23/347628 | 78739UEDCL [NAME] 19UBE 241Q | 920061 | D | 60860 | 7068 | UBE 241Q | 28306 | Acan Stella Otto
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/005 | 2023-11-29 00:00:00 | PM23/348738 | 78739UEDCL [NAME] 19UBE 241Q | 920280 | D | 60860 | 7068 | UBE 241Q | 28306 | Acan Stella Otto
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/005 | 2023-11-30 00:00:00 | FP23/598554 | 78739UEDCL [NAME] 19UBE 241Q | -1285673 | C | 60860 | 7068 | UBE 241Q | 28306 | Acan Stella Otto
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/006 | 2023-12-22 00:00:00 | PM23/350480 | 78739UEDCL [NAME] 19UBE 241Q | 231760 | D | 60860 | 7068 | UBE 241Q | 28306 | Acan Stella Otto
311003 | Accountable advance _ [NAME] (MVs and m/cycles | 2024/006 | 2023-12-31 00:00:00 | FP23/599646 | 78739UEDCL [NAME] 19UBE 241Q | -1632040 | C | 60860 | 7068 | UBE 241Q | 28306 | Acan Stella Otto