Spreadsheet: 744819d1629465548-trial-balance-using-pivot-table-trial-balance-zwl
Sheet: Sheet2

Kindly asking for help I want to construct a Trial Balance using Pivot table. Please not that we use multi- currency: ZWL, US$ and Rand. Trial balances should be for ZWL, US$ and Rand.
Or any other formula besides VBA.
Transactions
?? | Code | Invoice / Order | Payment Method | Date | Name | Receipt | ZWL | RAND | US$ | Details | Account | Financial Category | Type | Terms | Dr/(Cr) | Group
 |  | 2000 | Opening Balance | 2021-01-01 00:00:00 | Opening Balance | 0 | 550487.77 | 0 | 0 | Opening Balance |  | Land and Buildings |  | 0
 |  | 2001 | Opening Balance | 2021-01-01 00:00:00 | Opening Balance | 0 | 2045.5 |  | 0 | Opening Balance |  | Furniture & Fittings |  | 0
 |  | 2002 | Opening Balance | 2021-01-01 00:00:00 | Opening Balance | 0 | 23400 | 0 | 0 | Opening Balance |  | Cash |  | 0
 |  | 2003 | Opening Balance | 2021-01-01 00:00:00 | Opening Balance | 0 | 1200 | 0 |  | Opening Balance |  | Inventory |  | 0
 |  | 2004 | Opening Balance | 2021-01-01 00:00:00 | Opening Balance | 0 | 528718.77 | 0 |  | Opening Balance |  | Accounts Payable |  | 0
 |  | 2005 | Opening Balance | 2021-01-01 00:00:00 | Opening Balance | 0 | 26607 | 0 |  | Opening Balance |  | Loan |  | 0
 |  | 2006 | Opening Balance | 2021-01-01 00:00:00 | Opening Balance | 0 | 4000 | 0 |  | Opening Balance |  | Share Capital |  | 0
 |  | 2007 | Opening Balance | 2021-01-01 00:00:00 | Opening Balance | 0 | 17807.5 | 0 |  | Opening Balance |  | [NAME] |  | 0
1CT 011 | 1CT 012 | 2008 | Bank | 2021-01-01 00:00:00 | AWAN | 40 | 5000 | 0 |  | Chemicals |  | Purchases |  | 0
1CT 011 | 1CT 012 | 2009 | Bank | 2021-01-01 00:00:00 | [NAME] | 41 | 1400 | 0 |  | Bread |  | Sales |  | 0
1CT 011 | 1CT 012 | 2010 | Bank | 2021-01-01 00:00:00 | BERTHA | 42 | 800 | 0 | 0 | Sugar |  | Purchases Returns |  | 0
1CT 011 | 1CT 012 | 2011 | Bank | 2021-01-01 00:00:00 | BLESSING | 43 | 1000 | 0 | 0 | Salaries |  | Accruals - Salaries |  | 0
1CT 011 | 1CT 012 | 2012 | Bank | 2021-01-01 00:00:00 | BONGAKELE | 44 | 230 |  | 0 | [NAME] |  | Advertising & Marketing |  | 0
1CT 011 | 1CT 012 | 2013 | Bank | 2021-01-01 00:00:00 | BRADLEY | 45 | 500 |  | 0 | Bread |  | [NAME] |  | 0
1CT 011 | 1CT 012 | 2014 | Bank | 2021-01-01 00:00:00 | BUHLEBENKOSI | 46 | 30 |  | 0 | Bread |  | Bank Charges |  | 0
1CT 011 | 1CT 012 | 2015 | Bank | 2021-01-01 00:00:00 | BULISANI | 47 | 70 |  | 0 | Factory |  | Electricity |  | 0
1CT 011 | 1CT 012 | 2016 | Bank | 2021-01-01 00:00:00 | CADWELL | 48 | 100 |  | 0 | Old people's home |  | Donations |  | 0
1CT 011 | 1CT 012 | 2017 | Bank | 2021-01-01 00:00:00 | CARISSA | 49 | 300 |  | 0 | Vehicles |  | Fuel & Oils |  | 0
1CT 011 | 1CT 012 | 2018 | Bank | 2021-01-01 00:00:00 | CARLTON | 50 | 240 | 0 | 0 | Vehicles |  | Insurance & Licence |  | 0
1CT 011 | 1CT 012 | 2019 | Bank | 2021-01-01 00:00:00 | CAROL | 51 | 1500 | 0 | 0 | Sugar |  | Sales |  | 0
1CT 011 | 1CT 012 | 2020 | Bank | 2021-01-01 00:00:00 | CELESTINA | 52 | 301 | 0 | 0 | Office |  | Printing & Stationery |  | 0
1CT 011 | 1CT 012 | 2021 | Bank | 2021-01-01 00:00:00 | CHANAN | 53 | 600 | 0 |  | Rates |  | Prepaid Expenses |  | 0
1CT 011 | 1CT 012 | 2022 | Bank | 2021-01-01 00:00:00 | CHIEDZA | 54 | 3000 | 0 |  | Bread |  | Purchases |  | 0
1CT 011 | 1CT 012 | 2023 | Bank | 2021-01-01 00:00:00 | CHLOE M. | 55 | 120 | 0 |  | [NAME] |  | Advertising & Marketing |  | 0
1CT 011 | 1CT 012 | 2024 | Bank | 2021-01-01 00:00:00 | CLIFFORD | 56 | 40 | 0 |  | Bread |  | Bank Charges |  | 0
1CT 011 | 1CT 012 | 2025 | Bank | 2021-01-01 00:00:00 | CLINT | 57 | 1000 | 0 |  | Sales |  | Cash |  | 0
1CT 011 | 1CT 012 | 2026 | Bank | 2021-01-01 00:00:00 | BLESSING | 58 | 79 | 0 |  | Vehicles |  | Fuel & Oils |  | 0
 |  |  |  | 2021-01-31 00:00:00 | carried forward |  |  |  |  | Current RE | 301 | [NAME]