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

Kindly asking for excel formula to produce a cash book using information in the transactions workbook.
Desired solution
Date | Description | Reference | Amount
2023-01-02 00:00:00 | SBPOS Commission VPLUS02012307071 0000021880006407751 | 1 | 11752
2023-01-04 00:00:00 | POS PURCHASE        POWERTEL COMMUNICATIONSBULAWA 89004023 [PHONE] 10H58 3037 000000 | 1647 | 15000
2023-01-04 00:00:00 | IMTT | 2 | 300
2023-01-04 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 3 | 150
2023-01-11 00:00:00 | POS PURCHASE        Zimcopies              Harare AT020002 [PHONE] 14H17 3037 000000 | 1652 | 130200
2023-01-11 00:00:00 | IMTT | 4 | 2604
2023-01-11 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 5 | 432
2023-01-11 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 6 | 870
2023-01-16 00:00:00 | POS PURCHASE        [NAME]    Bulawa 29000071 [PHONE] 11H27 3037 000000 | 1654 | 662607.01
2023-01-16 00:00:00 | IMTT | 7 | 13252.14
2023-01-16 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 8 | 6626.07
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 9 | 850
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/1 | 44518.4
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 10 | 850
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/2 | 48780.8
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 11 | 850
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/3 | 44518.4
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 12 | 850
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/4 | 50684.8
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 13 | 850
2023-01-18 00:00:00 | EOL/RTGS | 1655/5 | 51250.75
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 14 | 850
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/6 | 55678.68
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 15 | 850
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/7 | 45638.12
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 16 | 850
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/8 | 73400
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 17 | 850
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/9 | 30080
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 18 | 850
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/10 | 39856
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 19 | 850
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/11 | 29480
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 20 | 850
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/12 | 64037.92
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 21 | 850
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/13 | 30080
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 22 | 850
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1655/14 | 30080
2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 1657 | 22600
2023-01-18 00:00:00 | EOL/RTGS RIVERSIDE SALARY [PHONE] | 1656 | 8250
2023-01-18 00:00:00 | IMTT | 23 | 617
2023-01-18 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 24 | 100
2023-01-18 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 25 | 226
2023-01-19 00:00:00 | POS PURCHASE        HERITAGE BOOKSHOP      BULAWA 77408710 [PHONE] 10H36 3037 011096 | 1664 | 81121
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
2023-01-19 00:00:00 | IMTT | 26 | 1622.42
2023-01-23 00:00:00 | POS PURCHASE        FAZAK AFRICA WOODLANDS2BULAWA NEDX0720 [PHONE] 08H31 3037 000000 | 15164 | 24470
2023-01-23 00:00:00 | POS PURCHASE        [NAME] 2     BULAWA 29009871 [PHONE] 08H25 3037 000000 | 1665B | 24470
2023-01-23 00:00:00 | POS PURCHASE        FAZAK AFRICA           HARARE M3100488 [PHONE] 07H59 3037 000000 | 1665 | 15000
2023-01-23 00:00:00 | POS PURCHASE        ECONET BRADFIELD       Bulawa 89010316 [PHONE] 11H10 3037 000000 | 1667 | 25043.53
2023-01-23 00:00:00 | POS PURCHASE        FAZAK AFRICA WOODLANDS6BULAWA NEDX0724 [PHONE] 15H13 3037 000000 | 1673 | 85800
2023-01-23 00:00:00 | IMTT | 27 | 3006.27
2023-01-23 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 28 | 150
2023-01-23 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 29 | 244.7
2023-01-23 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 30 | 858
2023-01-23 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 31 | 250.44
2023-01-24 00:00:00 | FEE POS PUR TELONE   BULAWA 19/1/2023 | 32 | 100.75
2023-01-24 00:00:00 | FEE POS PUR HERITAGE BOOKSHOP      BULAWA 19/1/202 | 33 | 202.8
2023-01-27 00:00:00 | POS PURCHASE        TELONE                 BULAWA 77401178 [PHONE] 12H13 3037 001741 | 1681 | 43150.59
2023-01-27 00:00:00 | IMTT | 84 | 863.01
2023-01-30 00:00:00 | SWIFT COMMISSION FOR Payment :[PHONE] | 85 | 850
2023-01-30 00:00:00 | SWIFT COMMISSION FOR Payment :[PHONE] | 1676B | 32000
2023-01-30 00:00:00 | SWIFT COMMISSION FOR Payment :[PHONE] | 86 | 850
2023-01-30 00:00:00 | SWIFT COMMISSION FOR Payment :[PHONE] | 1676Bi | 30080
2023-01-30 00:00:00 | SWIFT COMMISSION FOR Payment :[PHONE] | 87 | 850
2023-01-30 00:00:00 | SWIFT COMMISSION FOR Payment :[PHONE] | 1687 | 57432
2023-01-30 00:00:00 | IMTT | 88 | 2390.24
2023-01-31 00:00:00 | MONTHLY MANAGEMENT FEE | 89 | 15600
2023-01-31 00:00:00 | POS PURCHASE        NICELE PVT LTD         Bulawa 89014265 [PHONE] 16H27 3037 000000 | 1690 | 36000
2023-01-31 00:00:00 | POS PURCHASE        NICELE PVT LTD         Bulawa 89014265 [PHONE] 16H27 3037 000000 | 1690B | 36000
2023-01-31 00:00:00 | IMTT | 90 | 1440
2023-01-31 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 91 | 360
2023-01-31 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 92 | 360
2023-01-31 00:00:00 | DEBIT CARD MNGMNT FEE | 93 | 2340
Total |  |  | 2088776.84
Receipts
2023-01-11 00:00:00 | 000002188 RIVERSIDE STIMULATIO VPLUS10012321201 0000021880006420068 | SP1 | 210000
2023-01-12 00:00:00 | 000002188  VPLUS11012321213 0000021880006421268 | SP2 | 473100
2023-01-14 00:00:00 | 000002188  VPLUS11012321213 0000021880006421268 | SP3 | 182000
2023-01-16 00:00:00 | [PHONE] FT230167WHWM 1/ | 15160 | 71500
2023-01-19 00:00:00 | ZIPIT 874520 ESGHTERMOYO ZIPIT 874520 644FBTC230181019 | 15162 | 44518.4
2023-01-20 00:00:00 | [PHONE] 2301910704460001 | 15163 | 50000
2023-01-23 00:00:00 | POS REV OF PURCHASE FAZAK AFRICA WOODLANDS2BULAWA NEDX0720 [PHONE] 08H31 3037 000000 | 15164 | 24470
2023-01-23 00:00:00 | [PHONE] [PHONE] BISHOPSTONE ESTATES PVT LTD | 151165 | 337000
2023-01-25 00:00:00 | [PHONE] FT230240YPJN 1/ | 15166 | 150000
2023-01-27 00:00:00 | 000002188 RIVERSIDE STIMULATIO VPLUS26012321212 0000021880006437525 | SP6 | 150000
2023-01-30 00:00:00 | SWIFT COMMISSION FOR Payment :[PHONE] | SP4 | 442200
2023-01-31 00:00:00 | 000002188 RIVERSIDE STIMULATIO VPLUS30012321214 0000021880006441584 | SP5 | 377200
Total |  |  | 2511988.4