Spreadsheet: 823465d1679973430-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 | Debit | Credit
 | Payments
 | 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 | 1655/6 |  | 55678.68
 | 2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 15 |  | 850
 | 2023-01-18 00:00:00 | EOL/RTGS | 1655/7 |  | 45638.12
 | 2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 16 |  | 850
 | 2023-01-18 00:00:00 | EOL/RTGS | 1655/8 |  | 73400
 | 2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 17 |  | 850
 | 2023-01-18 00:00:00 | EOL/RTGS | 1655/9 |  | 30080
 | 2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 18 |  | 850
 | 2023-01-18 00:00:00 | EOL/RTGS | 1655/10 |  | 39856
 | 2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 19 |  | 850
 | 2023-01-18 00:00:00 | EOL/RTGS | 1655/11 |  | 29480
 | 2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 20 |  | 850
 | 2023-01-18 00:00:00 | EOL/RTGS | 1655/12 |  | 64037.92
 | 2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 21 |  | 850
 | 2023-01-18 00:00:00 | EOL/RTGS | 1655/13 |  | 30080
 | 2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 22 |  | 850
 | 2023-01-18 00:00:00 | EOL/RTGS | 1655/14 |  | 30080
 | 2023-01-18 00:00:00 | pricingOnlineTranParticulars.scr | 1657 |  | 22600
 | 2023-01-18 00:00:00 | EOL/RTGS | 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 -Rervsal |  | 24470
 | 2023-01-23 00:00:00 | POS PURCHASE        [NAME] 2     BULAWA 29009871 [PHONE] 08H25 3037 000000 | 16658 |  | 24470
 | 2023-01-23 00:00:00 | POS PURCHASE        FAZAK AFRICA           HARARE M3100488 [PHONE] 07H59 3037 000000 | No voucher |  | 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 | IMTT | No voucher |  | 32000
 | 2023-01-30 00:00:00 | SWIFT COMMISSION FOR Payment :[PHONE] | 86 |  | 850
 | 2023-01-30 00:00:00 | IMTT | No voucher |  | 30080
 | 2023-01-30 00:00:00 | SWIFT COMMISSION FOR Payment :[PHONE] | 87 |  | 850
 | 2023-01-30 00:00:00 | IMTT | No voucher |  | 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 | No voucher |  | 36000
 | 2023-01-31 00:00:00 | POS PURCHASE        NICELE PVT LTD         Bulawa 89014265 [PHONE] 16H27 3037 000000 | No voucher |  | 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
 | Receipts
 | 2023-01-11 00:00:00 | 000002188 RIVERSIDE STIMULATIO VPLUS10012321201 0000021880006420068 | SP1 | 210000
 | 2023-01-12 00:00:00 | 000002188 RIVERSIDE STIMULATIO VPLUS11012321213 0000021880006421268 | SP2 | 473100
 | 2023-01-14 00:00:00 | 000002188 RIVERSIDE STIMULATIO VPLUS13012321223 0000021880006423709 | SP3 | 182000
 | 2023-01-16 00:00:00 | [PHONE] FT230167WHWM 1/SANDRA NDLOVU | 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 DAVSON TSHUMA | 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/SAMANTHA T MAPUTI | 15166 | 150000
 | 2023-01-27 00:00:00 | 000002188 RIVERSIDE STIMULATIO VPLUS26012321212 0000021880006437525 | SP6 | 150000
 | 2023-01-30 00:00:00 | 000002188 RIVERSIDE STIMULATIO VPLUS30012307113 0000021880006438786 | SP4 | 442200
 | 2023-01-31 00:00:00 | 000002188 RIVERSIDE STIMULATIO VPLUS30012321214 0000021880006441584 | SP5 | 377200
 | Total