Spreadsheet: 823459d1679971146-excel-formula-to-produce-cash-book-cash-book
Sheet: Transactions

Date | Description | Reference | Debit | Credit | Balance
2023-01-02 00:00:00 | SBPOS Commission VPLUS02012307071 0000021880006407751 | 1 | 11752 | 0 | 707168.23
2023-01-04 00:00:00 | POS PURCHASE        POWERTEL COMMUNICATIONSBULAWA 89004023 [PHONE] 10H58 3037 000000 | 1647 | 15000 | 0 | 692168.23
2023-01-04 00:00:00 | IMTT | 2 | 300 | 0 | 691868.23
2023-01-04 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 3 | 150 | 0 | 691718.23
2023-01-11 00:00:00 | 000002188 RIVERSIDE STIMULATIO VPLUS10012321201 0000021880006420068 | SP1 | 0 | 210000 | 901718.23
2023-01-11 00:00:00 | POS PURCHASE        Zimcopies              Harare AT020002 [PHONE] 14H17 3037 000000 | 1652 | 130200 | 0 | 771518.23
2023-01-11 00:00:00 | IMTT | 4 | 2604 | 0 | 768914.23
2023-01-11 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 5 | 432 | 0 | 768482.23
2023-01-11 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 6 | 870 | 0 | 767612.23
2023-01-12 00:00:00 | 000002188  VPLUS11012321213 0000021880006421268 | SP2 | 0 | 473100 | 1240712.23
2023-01-14 00:00:00 | 000002188  VPLUS11012321213 0000021880006421268 | SP3 | 0 | 182000 | 1422712.23
2023-01-16 00:00:00 | POS PURCHASE        [NAME]    Bulawa 29000071 [PHONE] 11H27 3037 000000 | 1654 | 662607.01 | 0 | 760105.22
2023-01-16 00:00:00 | [PHONE] FT230167WHWM 1/ | 15160 | 0 | 71500 | 831605.22
2023-01-16 00:00:00 | IMTT | 7 | 13252.14 | 0 | 818353.08
2023-01-16 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 8 | 6626.07 | 0 | 811727.01
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 9 | 850 | 0 | 810877.01
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/1 | 44518.4 | 0 | 766358.61
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 10 | 850 | 0 | 765508.61
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/2 | 48780.8 | 0 | 716727.81
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 11 | 850 | 0 | 715877.81
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/3 | 44518.4 | 0 | 671359.41
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 12 | 850 | 0 | 670509.41
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/4 | 50684.8 | 0 | 619824.61
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 13 | 850 | 0 | 618974.61
2023-01-18 00:00:00 | EOL/RTGS | 1655/5 | 51250.75 | 0 | 567723.86
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 14 | 850 | 0 | 566873.86
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/6 | 55678.68 | 0 | 511195.18
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 15 | 850 | 0 | 510345.18
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/7 | 45638.12 | 0 | 464707.06
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 16 | 850 | 0 | 463857.06
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/8 | 73400 | 0 | 390457.06
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 17 | 850 | 0 | 389607.06
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/9 | 30080 | 0 | 359527.06
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 18 | 850 | 0 | 358677.06
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/10 | 39856 | 0 | 318821.06
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 19 | 850 | 0 | 317971.06
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/11 | 29480 | 0 | 288491.06
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 20 | 850 | 0 | 287641.06
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/12 | 64037.92 | 0 | 223603.14
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 21 | 850 | 0 | 222753.14
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/13 | 30080 | 0 | 192673.14
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 22 | 850 | 0 | 191823.14
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/14 | 30080 | 0 | 161743.14
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 1657 | 22600 | 0 | 139143.14
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1656 | 8250 | 0 | 130893.14
2023-01-18 00:00:00 | IMTT | 23 | 617 | 0 | 174794.54
2023-01-18 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 24 | 100 | 0 | 174694.54
2023-01-18 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 25 | 226 | 0 | 174468.54
2023-01-19 00:00:00 | ZIPIT 874520 ESGHTERMOYO ZIPIT 874520 644FBTC230181019 | 15162 | 0 | 44518.4 | 175411.54
2023-01-19 00:00:00 | POS PURCHASE        HERITAGE BOOKSHOP      BULAWA 77408710 [PHONE] 10H36 3037 011096 | 1664 | 81121 | 0 | 93347.54
2023-01-19 00:00:00 | POS PURCHASE        TELONE                 BULAWA 77401181 [PHONE] 11H01 3037 011622 | 1658 | 26302
2023-01-19 00:00:00 | POS PURCHASE        TELONE                 BULAWA 77401181 [PHONE] 11H01 3037 011622 | 1659 | 13999 | 0 | 53046.54
2023-01-19 00:00:00 | IMTT | 26 | 1622.42 | 0 | 51424.12
2023-01-20 00:00:00 | [PHONE] 2301910704460001 | 15163 | 0 | 50000 | 101424.12
2023-01-23 00:00:00 | POS PURCHASE        FAZAK AFRICA WOODLANDS2BULAWA NEDX0720 [PHONE] 08H31 3037 000000 | 15164 | 24470 | 0 | 76954.12
2023-01-23 00:00:00 | POS REV OF PURCHASE FAZAK AFRICA WOODLANDS2BULAWA NEDX0720 [PHONE] 08H31 3037 000000 | 15164 | 0 | 24470 | 101424.12
2023-01-23 00:00:00 | POS PURCHASE        [NAME] 2     BULAWA 29009871 [PHONE] 08H25 3037 000000 | 1665B | 24470 | 0 | 76954.12
2023-01-23 00:00:00 | POS PURCHASE        FAZAK AFRICA           HARARE M3100488 [PHONE] 07H59 3037 000000 | 1665 | 15000 | 0 | 61954.12
2023-01-23 00:00:00 | POS PURCHASE        ECONET BRADFIELD       Bulawa 89010316 [PHONE] 11H10 3037 000000 | 1667 | 25043.53 | 0 | 36910.59
2023-01-23 00:00:00 | [PHONE] [PHONE] BISHOPSTONE ESTATES PVT LTD | 151165 | 0 | 337000 | 373910.59
2023-01-23 00:00:00 | POS PURCHASE        FAZAK AFRICA WOODLANDS6BULAWA NEDX0724 [PHONE] 15H13 3037 000000 | 1673 | 85800 | 0 | 288110.59
2023-01-23 00:00:00 | IMTT | 27 | 3006.27 | 0 | 284800.77
2023-01-23 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 28 | 150 | 0 | 284650.77
2023-01-23 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 29 | 244.7 | 0 | 284406.07
2023-01-23 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 30 | 858 | 0 | 283548.07
2023-01-23 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 31 | 250.44 | 0 | 283297.63
2023-01-24 00:00:00 | FEE POS PUR TELONE   BULAWA 19/1/2023 | 32 | 100.75 | 0 | 288009.84
2023-01-24 00:00:00 | FEE POS PUR HERITAGE BOOKSHOP      BULAWA 19/1/202 | 33 | 202.8 | 0 | 287807.04
2023-01-25 00:00:00 | [PHONE] FT230240YPJN 1/ | 15166 | 0 | 150000 | 433297.63
2023-01-27 00:00:00 | 000002188 RIVERSIDE STIMULATIO VPLUS26012321212 0000021880006437525 | SP6 | 0 | 150000 | 583297.63
2023-01-27 00:00:00 | POS PURCHASE        TELONE                 BULAWA 77401178 [PHONE] 12H13 3037 001741 | 1681 | 43150.59 | 0 | 540147.04
2023-01-27 00:00:00 | IMTT | 84 | 863.01 | 0 | 539284.03
2023-01-30 00:00:00 | SWIFT COMMISSION FOR Payment :[PHONE] | 85 | 850 | 0 | 538434.03
2023-01-30 00:00:00 | SWIFT COMMISSION FOR Payment :[PHONE] | 1676B | 32000 | 0 | 506434.03
2023-01-30 00:00:00 | SWIFT COMMISSION FOR Payment :[PHONE] | 86 | 850 | 0 | 505584.03
2023-01-30 00:00:00 | SWIFT COMMISSION FOR Payment :[PHONE] | 1676Bi | 30080 | 0 | 475504.03
2023-01-30 00:00:00 | SWIFT COMMISSION FOR Payment :[PHONE] | 87 | 850 | 0 | 474654.03
2023-01-30 00:00:00 | SWIFT COMMISSION FOR Payment :[PHONE] | 1687 | 57432 | 0 | 417222.03
2023-01-30 00:00:00 | SWIFT COMMISSION FOR Payment :[PHONE] | SP4 | 0 | 442200 | 859422.03
2023-01-30 00:00:00 | IMTT | 88 | 2390.24 | 0 | 1234231.79
2023-01-31 00:00:00 | 000002188 RIVERSIDE STIMULATIO VPLUS30012321214 0000021880006441584 | SP5 | 0 | 377200 | 1236622.03
2023-01-31 00:00:00 | MONTHLY MANAGEMENT FEE | 89 | 15600 | 0 | 1218631.79
2023-01-31 00:00:00 | POS PURCHASE        NICELE PVT LTD         Bulawa 89014265 [PHONE] 16H27 3037 000000 | 1690 | 36000 | 0 | 1182631.79
2023-01-31 00:00:00 | POS PURCHASE        NICELE PVT LTD         Bulawa 89014265 [PHONE] 16H27 3037 000000 | 1690B | 36000 | 0 | 1146631.79
2023-01-31 00:00:00 | IMTT | 90 | 1440 | 0 | 1433746.79
2023-01-31 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 91 | 360 | 0 | 1433386.79
2023-01-31 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 92 | 360 | 0 | 1433026.79
2023-01-31 00:00:00 | DEBIT CARD MNGMNT FEE | 93 | 2340 | 0 | 1430686.79