Project

General

Profile

Download (9.1 KB)

Feature #762 ยป bank_unreconciled_2025-05-06T14_47_15.xlsx

Exceptions - ken ken, 05/06/2025 02:47 PM

Sheet1

transaction_date transaction_details money_out money_in ledger_balance bank_reference_number transaction_type cashbook-amount cashbook-amount_in_local_currency cashbook-transaction_type cashbook-document_no cashbook-date cashbook-meta_data cashbook-description
2024-01-10T00:00:00 Returned EFT KEMRI BANK 0.0 85444.3 7.9011472033e8 FT24275PT270 credits
2024-01-10T00:00:00 Tax Amount Due -55.7 0.0 7.9282771313e8 1104158574-20240930 debits
2024-03-10T00:00:00 BillPay P051092793H Kenya Medical Research Institute 2020240003514010 KRA COLLECTIONS ACCOUNT -9.7544644e7 0.0 6.8991832333e8 FT2427766G5Q debits
2024-03-10T00:00:00 Direct Credits PV2425009236 EFT OUTWARD CLEARING ACCOUNT -438310.3 0.0 6.8628165648e8 FT2427759TYL debits
2024-03-10T00:00:00 Transfer KEMRI W242500139 999999 0.0 70000.0 6.8901658823e8 FT24277TS8DZ credits
2024-04-10T00:00:00 Transfer 00065 IBANK BULK PAYMENTS -5.233969765e7 0.0 6.3355559058e8 FT242781RH73 debits
2024-07-10T00:00:00 Transfer KEMRI W242500083 999999 0.0 67200.0 6.2749413188e8 FT24281Q6D17 credits
2024-07-10T00:00:00 Transfer KEMRI W242500084 999999 0.0 18900.0 6.2774903188e8 FT24281TPDY3 credits
2024-07-10T00:00:00 Transfer KEMRI W242500085 999999 0.0 18900.0 6.2742693188e8 FT24281BXWF1 credits
2024-07-10T00:00:00 Transfer KEMRI W242500086 999999 0.0 50400.0 6.2740803188e8 FT24281PBJQ5 credits
2024-07-10T00:00:00 Transfer KEMRI W242500087 999999 0.0 33600.0 6.2735763188e8 FT24281K3KG0 credits
2024-07-10T00:00:00 Transfer KEMRI W242500088 999999 0.0 236000.0 6.2773013188e8 FT24281M65C7 credits
2024-08-10T00:00:00 Direct Credits PV242500939 EFT OUTWARD CLEARING ACCOUNT -11499.4 0.0 6.2548688843e8 FT24282FBCZF debits
2024-08-10T00:00:00 Salary Payment K.N.HRECURRENT GENERAL AC BANK 0.0 439496.1 6.2518332078e8 FT242825LS79 credits
2024-09-10T00:00:00 Inward SWIFT Pa LIVERPOOL SCHOO LIVERPOOL, PEMBROKE PLACE, LIVERPOOL SCHOOL TROPICAL MEDICINE 0.0 3.05407987e7 6.6886474128e8 FT242784QHSB credits
2024-09-10T00:00:00 Outward SWIFT P PV242500873 SUB AWARD FUNDS FW044000037 NATIONWIDE CHILDRENS HOSPITAL -3073727.8 0.0 6.3832394258e8 FT2428352BK7 debits
2024-10-14T00:00:00 Returned EFT KEMRI BANK 0.0 58131.0 7.0234585133e8 FT24288R9MFJ credits
2024-10-16T00:00:00 Inward SWIFT Pa UCSF DRAFTS AND OAKLAND 1111 FRANKLIN STREET 9TH FLOOR UCSF DRAFTS AND WIRES 0.0 5154292.45 1.2889790839e9 FT24290QN36W credits
2024-10-16T00:00:00 Payment of Interest 0.0 3.4e7 1.24547851043e9 MM24107X9B75;5 credits
2024-10-17T00:00:00 Inward SWIFT Pa ELIZABETH ANNE KE/KISUMU/ KE/KISUMU/ ELIZABETH ANNE BUKUSI/ 0.0 351233.0 1.29474390805e9 FT24291B73TP credits
2024-10-19T00:00:00 Transfer PV242501010 KENYA MEDICAL RESEARCH INSTITUTE -520076.0 0.0 1.29399499505e9 FT24293PFNHC debits
2024-10-22T00:00:00 Credit re FX Sale NONE 0.0 1638584.48 1.29733167623e9 FX2429656994 credits
2024-10-22T00:00:00 Direct Credits PRA HEALTH SCIENCES KENYA LTD BANK 0.0 57076.1 1.29179226875e9 FT24296BMFX4 credits
2024-10-22T00:00:00 Transfer W242500365 HERZEL TIFFANY WANDERA -8000.0 0.0 1.29173530765e9 FT24296LDBSS debits
2024-10-23T00:00:00 Returned EFT KEMRI BANK 0.0 55692.0 1.29745601933e9 FT242974H85K credits
2024-10-23T00:00:00 Returned EFT KEMRI BANK 0.0 68651.1 1.29740032733e9 FT24297NZ0LW credits
2024-10-24T00:00:00 Inward SWIFT Pa HEALTH RESEARCH KE/Not provided/ KE/Not provided/ HEALTH RESEARCH OPERATIONS KENYA LI 0.0 1622578.7 1.33996562262e9 FT24298CPBG0 credits
2024-10-24T00:00:00 Inward SWIFT Pa HJF MEDICAL RES US/WILMINGTON/ US/WILMINGTON/ NOTPROVIDED1 0.0 2.195704745e7 1.32100851538e9 FT2429845G07 credits
2024-10-24T00:00:00 Inward SWIFT Pa STONEX FINANCIA GB/OTHER/ GB/OTHER/ STONEX FINANCIAL LTD/ 0.0 2.35540433e7 1.37433493292e9 FT24298VKD06 credits
2024-10-25T00:00:00 Credit re FX Sale NONE 0.0 4507357.0 1.40187412493e9 FX2429909350 credits
2024-10-25T00:00:00 Inward SWIFT Pa PPD INVESTIGATO 19901 DOVER 108 LAKELAND AVE, KENT PPD INVESTIGATOR SERVICES, LLC 0.0 32675.4 1.39736748793e9 FT24299CFWFD credits
2024-10-25T00:00:00 Inward SWIFT Pa SCHOOL OF MEDIC SEATTLE WA 98195 US 4300 ROOSEVELT WAY NE BOX 354965 SCHOOL OF MEDICINE 0.0 1369504.5 1.40324362943e9 FT24299GCFQK credits
2024-10-25T00:00:00 Inward SWIFT Pa UCSF DRAFTS AND OAKLAND 1111 FRANKLIN STREET 9TH FLOOR UCSF DRAFTS AND WIRES 0.0 1060380.0 1.47810999997e9 FT24299T2RSX credits
2024-10-25T00:00:00 Outward SWIFT P SI242500131 KEMRI SW-NBKEKENX DIRECTOR CGHR -3500000.0 0.0 1.46256703922e9 FT242998BH9R debits
2024-10-25T00:00:00 Pesalink Incomi 20241025132410g9 I and M Bank 927736138 KCB BANK 0.0 207975.06 1.39733481253e9 FT242999S779 credits
2024-10-25T00:00:00 Transfer W242500414 ONYANGO KEVIN OKOTH -580366.0 0.0 1.46067330722e9 FT24299YQ7JR debits
2024-10-28T00:00:00 Inward SWIFT Pa PPD GLOBAL LTD CB216GQ CAMBRIDGE GRANTA PARK, GREAT ABINGTON PPD GLOBAL LTD 0.0 4707376.9 1.41131274538e9 FT243028BSX7 credits
2024-10-29T00:00:00 Outward SWIFT P PV242501018 3 Students stipend SW-CBETETAA SENAIT TADESSE BEKELE -3136615.0 0.0 1.39196375823e9 FT243037T6Z0 debits
2024-10-29T00:00:00 Outward SWIFT P PV242501028 Refundoffunderroneouslywired SC105 SW-BOFAUS3N UNIVERSITY OF WASHINGTON -1.036179465e7 0.0 1.39510267323e9 FT243039KKK9 debits
2024-10-30T00:00:00 Inward SWIFT Pa KENYA MEDICAL R KE/Kisumu/ KE/Kisumu/ KENYA MEDICAL RESEARCH INSTITUTE/ 0.0 1.60431096e7 1.40800686783e9 FT24304MZJFD credits
2024-10-30T00:00:00 Inward SWIFT Pa LIVERPOOL SCHOO /PURP/OTHR///ROC/FT24304ZRV3B///URI KE/NAIROBI/ LIVERPOOL SCHOOL OF TROPICAL MED ( 0.0 1.03376425e7 1.41351084578e9 FT24304W4Z7S credits
2024-10-30T00:00:00 Inward SWIFT Pa LVCT HEALTH/ /PURP/CORT///ROC/FT24302CGVLG///URI KE/NAIROBI/ LVCT HEALTH/ 0.0 9021012.75 1.42253185853e9 FT24303Y5K5C credits
2024-10-30T00:00:00 Inward SWIFT Pa UNIVERSITY OF L LIVERPOOL 765 BROWNLOW HILL UNIVERSITY OF LIVERPOOL 0.0 2098000.45 1.40317320328e9 FT2430360GG2 credits
2024-10-31T00:00:00 Direct Credits PV242501156 EFT OUTWARD CLEARING ACCOUNT -90008.1 0.0 1.41770866968e9 FT24305LTDD7 debits
2024-10-31T00:00:00 Direct Credits PV242501196 EFT OUTWARD CLEARING ACCOUNT -52521.5 0.0 1.41718074818e9 FT24305WZSBV debits
2024-10-31T00:00:00 Transfer 81305 IBANK BULK PAYMENTS -1.3717578455e8 0.0 1.27742142898e9 FT24305JP3SK debits
2024-10-31T00:00:00 Transfer KEMRI Reversed 1134464983 999999 0.0 85776.6 1.27741612558e9 FT24305LDJ9B credits
2024-10-31T00:00:00 Transfer KEMRI Reversed 1297888162 999999 0.0 85776.6 1.27750190218e9 FT24305X6V99 credits
2024-10-31T00:00:00 Transfer PV242501169 KENYA MEDICAL RESEARCH INSTITUTE -2500000.0 0.0 1.41783617778e9 FT24305733ZY debits
2024-11-10T00:00:00 Inward SWIFT Pa PPD GLOBAL LTD CB216GQ CAMBRIDGE GRANTA PARK, GREAT ABINGTON PPD GLOBAL LTD 0.0 2.21490718e7 7.0512332673e8 FT24284G3VG4 credits
    (1-1/1)