Spreadsheet: 819122d1677231749-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
Supplier | Document | Date | Order | Exclusive | Tax | Inclusive
OKM001 | [NAME] : GN100001 | 04/08/2022 | 048 | ZWL6,043.68 | ZWL876.33 | ZWL6,920.01
OKM001 | [NAME] : GN100002 | 04/08/2022 | 048 | ZWL3,021.84 | ZWL438.17 | ZWL3,460.01
ANG002 | [NAME] : GN100003 | 04/08/2022 | 042 | USD37.04 |  | USD37.04
ANG002 | [NAME] : GN100004 | 04/08/2022 | 042 | USD107.48 | USD4.70 | USD112.18
PAP002 | [NAME] : GN100005 | 04/08/2022 |  | USD72.40 | USD10.50 | USD82.90
DEL001 | [NAME] : GN100006 | 05/08/2022 |  | ZWL42,451.32 | ZWL3,404.07 | ZWL45,855.39
MAF003 | [NAME] : GN100007 | 05/08/2022 |  | ZAR1,781.60 | ZAR258.33 | ZAR2,039.93
PAP001 | [NAME] : GN100009 | 05/08/2022 | PO100003 | ZWL49,741.29 | ZWL7,212.49 | ZWL56,953.78
PLA001 | [NAME] : GN100010 | 05/08/2022 |  | [NAME] | ZWL115,584.43 | ZWL912,718.53
SCR002 | [NAME] : GN100011 | 05/08/2022 | PO100007 | USD43.70 | USD6.34 | USD50.04
ANG002 | [NAME] : GN100012 | 05/08/2022 | PO100005 | USD800.00 |  | USD800.00
BIB001 | [NAME] GN100013 | 11/08/2022 | PO100009 | ZWL125,764.20 | ZWL18,235.81 | ZWL144,000.01
ELL002 | [NAME] : GN100014 | [NAME] |  | USD1,920.00 |  | USD1,920.00
HAM001 | [NAME] : GN100015 | 16/08/2022 | 001 | ZWL200,000.00 |  | ZWL200,000.00
HAM003 | [NAME] : GN100016 | 16/08/2022 | 001 | ZAR2,040.00 |  | ZAR2,040.00
HAM002 | [NAME] : GN100017 | 16/08/2022 | 001 | USD29.00 |  | USD29.00
BER002 | [NAME] : GN100018 | 16/08/2022 |  | USD506.85 | USD73.51 | USD580.36
PAP002 | [NAME] : GN100019 | 18/08/2022 |  | USD304.53 | USD44.18 | [NAME]
WBI002 | [NAME] : GN100020 | 19/08/2022 |  | USD149.11 | USD21.62 | USD170.73
BAP002 | [NAME] : GN100021 | 19/08/2022 | 1805 | USD276.00 |  | USD276.00
23L002 | [NAME] : GN100022 | 19/08/2022 |  | USD64.00 |  | USD64.00
CHI002 | [NAME] : GN100023 | 19/08/2022 |  | USD71.80 |  | USD71.80
MUI002 | [NAME] : GN100024 | 19/08/2022 |  | USD70.00 |  | USD70.00
PAP001 | [NAME] : GN100025 | 19/08/2022 | 005 | ZWL66,478.50 | [NAME] | ZWL76,117.88
PAP002 | [NAME] : GN100026 | 19/08/2022 |  | USD355.44 | USD51.53 | USD406.97
EBS002 | [NAME] : GN100027 | 19/08/2022 |  | USD20.00 |  | USD20.00
CHI002 | [NAME] : GN100028 | 19/08/2022 |  | USD125.15 |  | USD125.15
PLA002 | [NAME] : GN100029 | 19/08/2022 |  | USD30.00 |  | USD30.00
CHI002 | [NAME] : GN100030 | 19/08/2022 |  | USD58.00 |  | USD58.00
BER002 | [NAME] : GN100031 | 19/08/2022 |  | USD373.11 |  | USD373.11
CHA002 | [NAME] : GN100032 | 19/08/2022 |  | USD54.92 |  | USD54.92
CHI002 | [NAME] : GN100033 | 19/08/2022 |  | USD240.00 |  | USD240.00
SOO002 | [NAME] : GN100034 | 19/08/2022 | PO100024 | USD37.57 | USD5.45 | USD43.02
COS002 | [NAME] : GN100035 | 19/08/2022 |  | USD100.36 | USD14.55 | USD114.91
CHE002 | [NAME] : GN100036 | 19/08/2022 |  | USD45.00 |  | USD45.00
TRY003 | [NAME] : GN100037 | 19/08/2022 |  | ZAR600.00 |  | ZAR600.00
COS003 | [NAME] : GN100038 | 19/08/2022 |  | [NAME] | ZAR193.35 | ZAR1,526.83
GCC002 | [NAME] : GN100039 | 23/08/2022 |  | USD71.28 | USD10.34 | USD81.62
MLA002 | [NAME] : GN100040 | 23/08/2022 |  | USD64.00 |  | USD64.00
JEW002 | [NAME] : GN100041 | 23/08/2022 |  | USD14.00 |  | USD14.00
GLY002 | [NAME] : GN100042 | 23/08/2022 |  | USD157.20 | USD22.79 | USD179.99
ELL002 | [NAME] : GN100043 | 23/08/2022 |  | USD64.00 |  | USD64.00
ANG002 | [NAME] : GN100044 | 23/08/2022 |  | USD237.30 | USD34.41 | USD271.71
ANG002 | [NAME] : GN100045 | 23/08/2022 |  | USD1,209.60 | USD77.29 | USD1,286.89
PAY003 | [NAME] : GN100046 | 23/08/2022 |  | [NAME] |  | [NAME]
FOR002 | [NAME] : GN100047 | 23/08/2022 |  | USD1,217.90 | USD127.59 | USD1,345.49
ZIM002 | [NAME] : GN100048 | 23/08/2022 |  | USD24.00 |  | USD24.00
ZIM002 | [NAME] : GN100049 | 23/08/2022 |  | USD40.00 |  | USD40.00
DGP002 | [NAME] : GN100050 | 23/08/2022 |  | USD396.29 | USD57.47 | USD453.76
PIN002 | [NAME] : GN100051 | 23/08/2022 |  | USD279.84 | USD40.58 | USD320.42
ELE002 | [NAME] : GN100052 | 23/08/2022 |  | USD126.64 | USD18.36 | USD145.00
ELE002 | [NAME] : GN100053 | 23/08/2022 |  | USD32.28 | USD4.68 | USD36.96
PAP002 | [NAME] : GN100054 | 23/08/2022 |  | USD191.40 | USD27.75 | USD219.15
ANG002 | [NAME] : GN100055 | 24/08/2022 |  | USD57.60 | USD8.35 | USD65.95
BAK002 | [NAME] : GN100056 | 24/08/2022 |  | USD1,730.00 |  | USD1,730.00
STA001 | [NAME] : GN100057 | [NAME] |  | ZWL10,480.34 | ZWL1,519.65 | ZWL11,999.99
PAP002 | [NAME] : GN100058 | [NAME] |  | USD35.10 | USD5.10 | USD40.20
FOR002 | [NAME] GN100059 | [NAME] |  | USD136.04 | USD19.44 | USD155.48
ANG002 | [NAME] : GN100060 | [NAME] |  | USD356.90 | USD13.35 | USD370.25
PIN002 | [NAME] : GN100061 | [NAME] |  | USD38.16 | USD5.53 | USD43.69
COS002 | [NAME] : GN100062 | [NAME] |  | USD25.35 | USD3.68 | USD29.03
ANG002 | [NAME] : GN100063 | [NAME] |  | USD60.48 | USD8.77 | USD69.25
COS001 | [NAME] : GN100064 | [NAME] |  | ZWL13,765.85 | ZWL1,996.05 | ZWL15,761.90
FOR002 | [NAME] : GN100065 | [NAME] |  | USD19.05 | USD2.76 | USD21.81
DGP002 | [NAME] : GN100066 | 27/08/2022 |  | USD74.86 | USD10.86 | USD85.72
ACO002 | [NAME] : GN100067 | 27/08/2022 |  | USD115.20 | USD16.71 | USD131.91
STA001 | [NAME] : GN100068 | 27/08/2022 |  | ZWL15,720.51 | ZWL2,279.47 | ZWL17,999.98
GCC002 | [NAME] : GN100069 | 27/08/2022 |  | USD129.60 | USD18.79 | USD148.39
NRE002 | [NAME] : GN100070 | 29/08/2022 |  | USD50.95 | USD0.08 | USD51.03
COO002 | [NAME] : GN100071 | 30/08/2022 |  | USD242.20 |  | USD242.20
BAR002 | [NAME] : GN100072 | 30/08/2022 |  | USD98.03 | USD14.22 | USD112.25
STAN00 | [NAME] : GN100073 | 30/08/2022 |  | USD62.88 | USD9.12 | USD72.00
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 -------------------------------