Spreadsheet: 819125d1677233105-formula-to-separate-multicurrency-file-to-its-respective-currencies-purchases-ledger-aug-22
Sheet: Sheet1

 | PPT Centre Pvt Ltd |  |  |  |  | 24/02/2023  11:09  Page: 1
 |  |  |  |  | Prepared by:  BICC MATOPO BC
 | Purchases Journal for period | 01/08/2022  to  31/08/2022 |  |  |  |  |  | ZWL |  |  |  |  |  |  |  | USD
Supplier | Document | Date | Order | Exclusive | Tax | Inclusive
OKM001 | [NAME] : GN100001 | 04/08/2022 | 048 | ZWL6,043.68 | ZWL876.33 | ZWL6,920.01 |  |  | Document | Date | Order | Exclusive | Tax | Inclusive |  |  | Document | Date | Order | Exclusive | Tax | Inclusive
OKM001 | [NAME] : GN100002 | 04/08/2022 | 048 | ZWL3,021.84 | ZWL438.17 | ZWL3,460.01 |  | OKM001 | [NAME] : GN100001 | 04/08/2022 | 048 | 6043.68 | 876.33 | 6920.01 |  | ANG002 | [NAME] : GN100003 | 04/08/2022 | 042 | 37.04 |  | 37.04
ANG002 | [NAME] : GN100003 | 04/08/2022 | 042 | USD37.04 |  | USD37.04 |  | OKM001 | [NAME] : GN100002 | 04/08/2022 | 048 | 3021.84 | 438.17 | 3460.01 |  | ANG002 | [NAME] : GN100004 | 04/08/2022 | 042 | 107.48 | 4.7 | 112.18
ANG002 | [NAME] : GN100004 | 04/08/2022 | 042 | USD107.48 | USD4.70 | USD112.18 |  | DEL001 | [NAME] : GN100006 | 05/08/2022 |  | 42451.32 | 3404.07 | 45855.39 |  | PAP002 | [NAME] : GN100005 | 04/08/2022 |  | 72.4 | 10.5 | 82.9
PAP002 | [NAME] : GN100005 | 04/08/2022 |  | USD72.40 | USD10.50 | USD82.90 |  | PAP001 | [NAME] : GN100009 | 05/08/2022 | PO100003 | 49741.29 | 7212.49 | 56953.78 |  | SCR002 | [NAME] : GN100011 | 05/08/2022 | PO100007 | 43.7 | 6.34 | 50.04
DEL001 | [NAME] : GN100006 | 05/08/2022 |  | ZWL42,451.32 | ZWL3,404.07 | ZWL45,855.39 |  | PLA001 | [NAME] : GN100010 | 05/08/2022 |  | 797134.1 | 115584.43 | 912718.53 |  | ANG002 | [NAME] : GN100012 | 05/08/2022 | PO100005 | 800 |  | 800
MAF003 | [NAME] : GN100007 | 05/08/2022 |  | ZAR1,781.60 | ZAR258.33 | ZAR2,039.93 |  | BIB001 | [NAME] GN100013 | 11/08/2022 | PO100009 | 125764.2 | 18235.81 | 144000.01 |  | ELL002 | [NAME] : GN100014 | [NAME] |  | 1920 |  | 1920
PAP001 | [NAME] : GN100009 | 05/08/2022 | PO100003 | ZWL49,741.29 | ZWL7,212.49 | ZWL56,953.78 |  | HAM001 | [NAME] : GN100015 | 16/08/2022 | 001 | 200000 |  | 200000 |  | HAM002 | [NAME] : GN100017 | 16/08/2022 | 001 | 29 |  | 29
PLA001 | [NAME] : GN100010 | 05/08/2022 |  | [NAME] | ZWL115,584.43 | ZWL912,718.53 |  | PAP001 | [NAME] : GN100025 | 19/08/2022 | 005 | 66478.5 | 9639.38 | 76117.88 |  | BER002 | [NAME] : GN100018 | 16/08/2022 |  | 506.85 | 73.51 | 580.36
SCR002 | [NAME] : GN100011 | 05/08/2022 | PO100007 | USD43.70 | USD6.34 | USD50.04 |  | STA001 | [NAME] : GN100057 | [NAME] |  | 10480.34 | 1519.65 | 11999.99 |  | PAP002 | [NAME] : GN100019 | 18/08/2022 |  | 304.53 | 44.18 | 348.71
ANG002 | [NAME] : GN100012 | 05/08/2022 | PO100005 | USD800.00 |  | USD800.00 |  | COS001 | [NAME] : GN100064 | [NAME] |  | 13765.85 | 1996.05 | 15761.9 |  | WBI002 | [NAME] : GN100020 | 19/08/2022 |  | 149.11 | 21.62 | 170.73
BIB001 | [NAME] GN100013 | 11/08/2022 | PO100009 | ZWL125,764.20 | ZWL18,235.81 | ZWL144,000.01 |  | STA001 | [NAME] : GN100068 | 27/08/2022 |  | 15720.51 | 2279.47 | 17999.98 |  | BAP002 | [NAME] : GN100021 | 19/08/2022 | 1805 | 276 |  | 276
ELL002 | [NAME] : GN100014 | [NAME] |  | USD1,920.00 |  | USD1,920.00 |  | MBC001 | [NAME] : GN100079 | 30/08/2022 |  | 116084.82 | 15499.61 | 131584.43 |  | 23L002 | [NAME] : GN100022 | 19/08/2022 |  | 64 |  | 64
HAM001 | [NAME] : GN100015 | 16/08/2022 | 001 | ZWL200,000.00 |  | ZWL200,000.00 |  | MBH001 | [NAME] : GN100084 | 31/08/2022 |  | 8288.78 |  | 8288.78 |  | CHI002 | [NAME] : GN100023 | 19/08/2022 |  | 71.8 |  | 71.8
HAM003 | [NAME] : GN100016 | 16/08/2022 | 001 | ZAR2,040.00 |  | ZAR2,040.00 |  | OKM001 | [NAME] : GN100085 | 31/08/2022 |  | 62515.92 | 9064.8 | 71580.72 |  | MUI002 | [NAME] : GN100024 | 19/08/2022 |  | 70 |  | 70
HAM002 | [NAME] : GN100017 | 16/08/2022 | 001 | USD29.00 |  | USD29.00 |  |  |  |  |  |  |  |  |  | PAP002 | [NAME] : GN100026 | 19/08/2022 |  | 355.44 | 51.53 | 406.97
BER002 | [NAME] : GN100018 | 16/08/2022 |  | USD506.85 | USD73.51 | USD580.36 |  |  |  |  |  |  |  |  |  | EBS002 | [NAME] : GN100027 | 19/08/2022 |  | 20 |  | 20
PAP002 | [NAME] : GN100019 | 18/08/2022 |  | USD304.53 | USD44.18 | [NAME] |  |  |  |  |  |  |  |  |  | CHI002 | [NAME] : GN100028 | 19/08/2022 |  | 125.15 |  | 125.15
WBI002 | [NAME] : GN100020 | 19/08/2022 |  | USD149.11 | USD21.62 | USD170.73 |  |  |  |  |  |  |  |  |  | PLA002 | [NAME] : GN100029 | 19/08/2022 |  | 30 |  | 30
BAP002 | [NAME] : GN100021 | 19/08/2022 | 1805 | USD276.00 |  | USD276.00 |  |  |  |  |  |  |  |  |  | CHI002 | [NAME] : GN100030 | 19/08/2022 |  | 58 |  | 58
23L002 | [NAME] : GN100022 | 19/08/2022 |  | USD64.00 |  | USD64.00 |  |  |  |  |  |  |  |  |  | BER002 | [NAME] : GN100031 | 19/08/2022 |  | 373.11 |  | 373.11
CHI002 | [NAME] : GN100023 | 19/08/2022 |  | USD71.80 |  | USD71.80 |  |  |  |  |  |  |  |  |  | CHA002 | [NAME] : GN100032 | 19/08/2022 |  | 54.92 |  | 54.92
MUI002 | [NAME] : GN100024 | 19/08/2022 |  | USD70.00 |  | USD70.00 |  |  |  |  |  |  |  |  |  | CHI002 | [NAME] : GN100033 | 19/08/2022 |  | 240 |  | 240
PAP001 | [NAME] : GN100025 | 19/08/2022 | 005 | ZWL66,478.50 | [NAME] | ZWL76,117.88 |  |  |  |  |  |  |  |  |  | SOO002 | [NAME] : GN100034 | 19/08/2022 | PO100024 | 37.57 | 5.45 | 43.02
PAP002 | [NAME] : GN100026 | 19/08/2022 |  | USD355.44 | USD51.53 | USD406.97 |  |  |  |  |  |  |  |  |  | COS002 | [NAME] : GN100035 | 19/08/2022 |  | 100.36 | 14.55 | 114.91
EBS002 | [NAME] : GN100027 | 19/08/2022 |  | USD20.00 |  | USD20.00 |  |  |  |  |  |  |  |  |  | CHE002 | [NAME] : GN100036 | 19/08/2022 |  | 45 |  | 45
CHI002 | [NAME] : GN100028 | 19/08/2022 |  | USD125.15 |  | USD125.15 |  |  |  |  |  |  |  |  |  | GCC002 | [NAME] : GN100039 | 23/08/2022 |  | 71.28 | 10.34 | 81.62
PLA002 | [NAME] : GN100029 | 19/08/2022 |  | USD30.00 |  | USD30.00 |  |  |  |  |  |  |  |  |  | MLA002 | [NAME] : GN100040 | 23/08/2022 |  | 64 |  | 64
CHI002 | [NAME] : GN100030 | 19/08/2022 |  | USD58.00 |  | USD58.00 |  |  |  |  |  |  |  |  |  | JEW002 | [NAME] : GN100041 | 23/08/2022 |  | 14 |  | 14
BER002 | [NAME] : GN100031 | 19/08/2022 |  | USD373.11 |  | USD373.11 |  |  |  |  |  |  |  |  |  | GLY002 | [NAME] : GN100042 | 23/08/2022 |  | 157.2 | 22.79 | 179.99
CHA002 | [NAME] : GN100032 | 19/08/2022 |  | USD54.92 |  | USD54.92 |  |  |  |  |  |  |  |  |  | ELL002 | [NAME] : GN100043 | 23/08/2022 |  | 64 |  | 64
CHI002 | [NAME] : GN100033 | 19/08/2022 |  | USD240.00 |  | USD240.00 |  |  |  |  |  |  |  |  |  | ANG002 | [NAME] : GN100044 | 23/08/2022 |  | 237.3 | 34.41 | 271.71
SOO002 | [NAME] : GN100034 | 19/08/2022 | PO100024 | USD37.57 | USD5.45 | USD43.02 |  |  |  |  |  |  |  |  |  | ANG002 | [NAME] : GN100045 | 23/08/2022 |  | 1209.6 | 77.29 | 1286.89
COS002 | [NAME] : GN100035 | 19/08/2022 |  | USD100.36 | USD14.55 | USD114.91 |  |  |  |  |  |  |  |  |  | FOR002 | [NAME] : GN100047 | 23/08/2022 |  | 1217.9 | 127.59 | 1345.49
CHE002 | [NAME] : GN100036 | 19/08/2022 |  | USD45.00 |  | USD45.00 |  |  |  |  |  |  |  |  |  | ZIM002 | [NAME] : GN100048 | 23/08/2022 |  | 24 |  | 24
TRY003 | [NAME] : GN100037 | 19/08/2022 |  | ZAR600.00 |  | ZAR600.00 |  |  |  |  |  |  |  |  |  | ZIM002 | [NAME] : GN100049 | 23/08/2022 |  | 40 |  | 40
COS003 | [NAME] : GN100038 | 19/08/2022 |  | [NAME] | ZAR193.35 | ZAR1,526.83 |  |  |  |  |  |  |  |  |  | DGP002 | [NAME] : GN100050 | 23/08/2022 |  | 396.29 | 57.47 | 453.76
GCC002 | [NAME] : GN100039 | 23/08/2022 |  | USD71.28 | USD10.34 | USD81.62 |  |  |  |  |  |  |  |  |  | PIN002 | [NAME] : GN100051 | 23/08/2022 |  | 279.84 | 40.58 | 320.42
MLA002 | [NAME] : GN100040 | 23/08/2022 |  | USD64.00 |  | USD64.00 |  |  |  |  |  |  |  |  |  | ELE002 | [NAME] : GN100052 | 23/08/2022 |  | 126.64 | 18.36 | 145
JEW002 | [NAME] : GN100041 | 23/08/2022 |  | USD14.00 |  | USD14.00 |  |  |  |  |  |  |  |  |  | ELE002 | [NAME] : GN100053 | 23/08/2022 |  | 32.28 | 4.68 | 36.96
GLY002 | [NAME] : GN100042 | 23/08/2022 |  | USD157.20 | USD22.79 | USD179.99 |  |  |  |  |  |  |  |  |  | PAP002 | [NAME] : GN100054 | 23/08/2022 |  | 191.4 | 27.75 | 219.15
ELL002 | [NAME] : GN100043 | 23/08/2022 |  | USD64.00 |  | USD64.00 |  |  |  |  |  |  |  |  |  | ANG002 | [NAME] : GN100055 | 24/08/2022 |  | 57.6 | 8.35 | 65.95
ANG002 | [NAME] : GN100044 | 23/08/2022 |  | USD237.30 | USD34.41 | USD271.71 |  |  |  |  |  |  |  |  |  | BAK002 | [NAME] : GN100056 | 24/08/2022 |  | 1730 |  | 1730
ANG002 | [NAME] : GN100045 | 23/08/2022 |  | USD1,209.60 | USD77.29 | USD1,286.89 |  |  |  |  |  |  |  |  |  | PAP002 | [NAME] : GN100058 | [NAME] |  | 35.1 | 5.1 | 40.2
PAY003 | [NAME] : GN100046 | 23/08/2022 |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  |  | FOR002 | [NAME] GN100059 | [NAME] |  | 136.04 | 19.44 | 155.48
FOR002 | [NAME] : GN100047 | 23/08/2022 |  | USD1,217.90 | USD127.59 | USD1,345.49 |  |  |  |  |  |  |  |  |  | ANG002 | [NAME] : GN100060 | [NAME] |  | 356.9 | 13.35 | 370.25
ZIM002 | [NAME] : GN100048 | 23/08/2022 |  | USD24.00 |  | USD24.00 |  |  |  |  |  |  |  |  |  | PIN002 | [NAME] : GN100061 | [NAME] |  | 38.16 | 5.53 | 43.69
ZIM002 | [NAME] : GN100049 | 23/08/2022 |  | USD40.00 |  | USD40.00 |  |  |  |  |  |  |  |  |  | COS002 | [NAME] : GN100062 | [NAME] |  | 25.35 | 3.68 | 29.03
DGP002 | [NAME] : GN100050 | 23/08/2022 |  | USD396.29 | USD57.47 | USD453.76 |  |  |  |  |  |  |  |  |  | ANG002 | [NAME] : GN100063 | [NAME] |  | 60.48 | 8.77 | 69.25
PIN002 | [NAME] : GN100051 | 23/08/2022 |  | USD279.84 | USD40.58 | USD320.42 |  |  |  |  |  |  |  |  |  | FOR002 | [NAME] : GN100065 | [NAME] |  | 19.05 | 2.76 | 21.81
ELE002 | [NAME] : GN100052 | 23/08/2022 |  | USD126.64 | USD18.36 | USD145.00 |  |  |  |  |  |  |  |  |  | DGP002 | [NAME] : GN100066 | 27/08/2022 |  | 74.86 | 10.86 | 85.72
ELE002 | [NAME] : GN100053 | 23/08/2022 |  | USD32.28 | USD4.68 | USD36.96 |  |  |  |  |  |  |  |  |  | ACO002 | [NAME] : GN100067 | 27/08/2022 |  | 115.2 | 16.71 | 131.91
PAP002 | [NAME] : GN100054 | 23/08/2022 |  | USD191.40 | USD27.75 | USD219.15 |  |  |  |  |  |  |  |  |  | GCC002 | [NAME] : GN100069 | 27/08/2022 |  | 129.6 | 18.79 | 148.39
ANG002 | [NAME] : GN100055 | 24/08/2022 |  | USD57.60 | USD8.35 | USD65.95 |  |  |  |  |  |  |  |  |  | NRE002 | [NAME] : GN100070 | 29/08/2022 |  | 50.95 | 0.08 | 51.03
BAK002 | [NAME] : GN100056 | 24/08/2022 |  | USD1,730.00 |  | USD1,730.00 |  |  |  |  |  |  |  |  |  | COO002 | [NAME] : GN100071 | 30/08/2022 |  | 242.2 |  | 242.2
STA001 | [NAME] : GN100057 | [NAME] |  | ZWL10,480.34 | ZWL1,519.65 | ZWL11,999.99 |  |  |  |  |  |  |  |  |  | BAR002 | [NAME] : GN100072 | 30/08/2022 |  | 98.03 | 14.22 | 112.25
PAP002 | [NAME] : GN100058 | [NAME] |  | USD35.10 | USD5.10 | USD40.20 |  |  |  |  |  |  |  |  |  | STAN00 | [NAME] : GN100073 | 30/08/2022 |  | 62.88 | 9.12 | 72
FOR002 | [NAME] GN100059 | [NAME] |  | USD136.04 | USD19.44 | USD155.48 |  |  |  |  |  |  |  |  |  | WCH002 | [NAME] : GN100074 | 30/08/2022 |  | 71 |  | 71
ANG002 | [NAME] : GN100060 | [NAME] |  | USD356.90 | USD13.35 | USD370.25 |  |  |  |  |  |  |  |  |  | PIN002 | [NAME] : GN100075 | 30/08/2022 |  | 101.76 | 14.76 | 116.52
PIN002 | [NAME] : GN100061 | [NAME] |  | USD38.16 | USD5.53 | USD43.69 |  |  |  |  |  |  |  |  |  | TSI002 | [NAME] : GN100077 | 30/08/2022 |  | 14 |  | 14
COS002 | [NAME] : GN100062 | [NAME] |  | USD25.35 | USD3.68 | USD29.03 |  |  |  |  |  |  |  |  |  | BIB002 | [NAME] : GN100078 | 30/08/2022 |  | 807.7 | 117.15 | 924.85
ANG002 | [NAME] : GN100063 | [NAME] |  | USD60.48 | USD8.77 | USD69.25 |  |  |  |  |  |  |  |  |  | COS002 | [NAME] : GN100080 | 31/08/2022 |  | 17.03 | 2.47 | 19.5
COS001 | [NAME] : GN100064 | [NAME] |  | ZWL13,765.85 | ZWL1,996.05 | ZWL15,761.90 |  |  |  |  |  |  |  |  |  | CHI002 | [NAME] : GN100081 | 31/08/2022 |  | 25.6 |  | 25.6
FOR002 | [NAME] : GN100065 | [NAME] |  | USD19.05 | USD2.76 | USD21.81 |  |  |  |  |  |  |  |  |  | CHI002 | [NAME] GN100082 | 31/08/2022 |  | 45 |  | 45
DGP002 | [NAME] : GN100066 | 27/08/2022 |  | USD74.86 | USD10.86 | USD85.72 |  |  |  |  |  |  |  |  |  | JEW002 | [NAME] : GN100083 | 31/08/2022 |  | 440 |  | 440
ACO002 | [NAME] : GN100067 | 27/08/2022 |  | USD115.20 | USD16.71 | USD131.91 |  |  |  |  |  |  |  |  |  | BEE002 | [NAME] : GN100086 | 31/08/2022  POA30005 |  | 192 | 27.84 | 219.84
STA001 | [NAME] : GN100068 | 27/08/2022 |  | ZWL15,720.51 | ZWL2,279.47 | ZWL17,999.98 |  |  |  |  |  |  |  |  |  | DAI002 | [NAME] : GN100087 | 31/08/2022  POA30001 |  | 180 |  | 180
GCC002 | [NAME] : GN100069 | 27/08/2022 |  | USD129.60 | USD18.79 | USD148.39 |  |  |  |  |  |  |  |  |  | DUB002 | [NAME] : GN100088 | 31/08/2022  POA30003 |  | 250 |  | 250
NRE002 | [NAME] : GN100070 | 29/08/2022 |  | USD50.95 | USD0.08 | USD51.03 |  |  |  |  |  |  |  |  |  | PAP002 | [NAME] : GN100090 | 31/08/2022 |  | 1747.56 | 253.39 | 2000.95
COO002 | [NAME] : GN100071 | 30/08/2022 |  | USD242.20 |  | USD242.20 |  |  |  |  |  |  |  |  |  | ANG002 | Return & Debit : PC100001 | 24/08/2022  PN100044 |  | -288 | -15.66 | -303.66
BAR002 | [NAME] : GN100072 | 30/08/2022 |  | USD98.03 | USD14.22 | USD112.25 |  |  |  |  |  |  |  |  |  | WCH002 | Return & Debit : PC100002 | 30/08/2022  PN100073 |  | -38 |  | -38
STAN00 | [NAME] : GN100073 | 30/08/2022 |  | USD62.88 | USD9.12 | USD72.00 |  |  |  |  |  |  |  |  |  | TSI002 | Return & Debit : PC100004 | 30/08/2022  PN100076 |  | -7 |  | -7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BIB002 | Return & Debit : PC100005 | 31/08/2022  PN100077 |  | -506.46 | -73.46 | -579.92
Matopo Book Centre Pvt Ltd |  |  |  |  | 24/02/2023  11:09  Page: 2
 |  |  |  |  | Prepared by:  BICC MATOPO BC
Purchases Journal for period |  | 01/08/2022  to  31/08/2022
Supplier | Document | Date | Order | Exclusive | Tax | Inclusive
WCH002 | [NAME] : GN100074 | 30/08/2022 |  | USD71.00 |  | USD71.00
PIN002 | [NAME] : GN100075 | 30/08/2022 |  | USD101.76 | USD14.76 | USD116.52
PAY003 | [NAME] : GN100076 | 30/08/2022 |  | ZAR8,400.00 |  | ZAR8,400.00
TSI002 | [NAME] : GN100077 | 30/08/2022 |  | USD14.00 |  | USD14.00
BIB002 | [NAME] : GN100078 | 30/08/2022 |  | USD807.70 | USD117.15 | USD924.85
MBC001 | [NAME] : GN100079 | 30/08/2022 |  | ZWL116,084.82 | ZWL15,499.61 | ZWL131,584.43
COS002 | [NAME] : GN100080 | 31/08/2022 |  | USD17.03 | USD2.47 | USD19.50
CHI002 | [NAME] : GN100081 | 31/08/2022 |  | USD25.60 |  | USD25.60
CHI002 | [NAME] GN100082 | 31/08/2022 |  | USD45.00 |  | USD45.00
JEW002 | [NAME] : GN100083 | 31/08/2022 |  | USD440.00 |  | USD440.00
MBH001 | [NAME] : GN100084 | 31/08/2022 |  | [NAME] |  | [NAME]
OKM001 | [NAME] : GN100085 | 31/08/2022 |  | ZWL62,515.92 | ZWL9,064.80 | ZWL71,580.72
BEE002 | [NAME] : GN100086 | 31/08/2022  POA30005 |  | USD192.00 | USD27.84 | USD219.84
DAI002 | [NAME] : GN100087 | 31/08/2022  POA30001 |  | USD180.00 |  | USD180.00
DUB002 | [NAME] : GN100088 | 31/08/2022  POA30003 |  | USD250.00 |  | USD250.00
PAW003 | [NAME] : GN100089 | 31/08/2022  PO100064 |  | ZAR15,360.00 |  | ZAR15,360.00
PAP002 | [NAME] : GN100090 | 31/08/2022 |  | USD1,747.56 | USD253.39 | USD2,000.95
ANG002 | Return & Debit : PC100001 | 24/08/2022  PN100044 |  | USD-288.00 | USD-15.66 | USD-303.66
WCH002 | Return & Debit : PC100002 | 30/08/2022  PN100073 |  | USD-38.00 |  | USD-38.00
PAY003 | Return & Debit : PC100003 | 30/08/2022  PN100075 |  | ZAR-6,000.00 |  | ZAR-6,000.00
TSI002 | Return & Debit : PC100004 | 30/08/2022  PN100076 |  | USD-7.00 |  | USD-7.00
BIB002 | Return & Debit : PC100005 | 31/08/2022  PN100077 |  | USD-506.46 | USD-73.46 | USD-579.92
------------------------------- End of Report -------------------------------