VTE Master Trial Balance 2 June

🏛️ Return to Master Trial Balance Console

🏢 Target Entity Hub:

📊 Matrix Summary ⚖️ 3-Year Compare 📂 Account Drill Log

Format: Hide Cents |

🏁 Category Opening Balance (OB) R 0.00

🔄 Net Transactional Movement R -138,025.21

🏆 Mapped Closing Position R -138,025.21

Receivables Control | Year : Mar 2024 Fin year

Net Movement Contribution ↻

R -138,025.21

📊 1. Summary Grouped By Account Link (Click table headers to sort | Click any blue code button to isolate granular rows below)

General Ledger Account Code ↕	Transaction Count ↕	Aggregated Balance ↕
8000/00/000/00 000 →	2 items	-405,748.47
APE001 →	6 items	0.00
BAN001 →	6 items	0.00
CAT002 →	1 items	-7,000.00
COC001 →	18 items	396,463.47
DEP002 →	10 items	0.00
DEP005 →	8 items	0.00
DEP010 →	8 items	0.00
DEP022 →	8 items	0.00
DEP027 →	8 items	0.00
DEP056 →	8 items	0.00
DUJ001 →	3 items	0.00
FOU002 →	2 items	0.00
GEN001 →	2 items	0.00
KHU001 →	4 items	0.00
KNO001 →	4 items	0.00
LIV001 →	4 items	0.00
MYS001 →	24 items	60.10
NUS001 →	2 items	0.00
PUR001 →	24 items	-121,800.31
SRM001 →	2 items	0.00
UNI006 →	2 items	0.00
UNP001 →	2 items	0.00

📜 2. Granular Transaction Audit Trail

Transaction Date ↕	AccountLink	Contra Account Description	Account Code	Reference Identifier	System Audit Ref	Person Booked ↕	Transaction Description Memo	Line Item Amount ↕
2023-04-08	9	COCT PEP	COC001	SSDEP20230408	33660.0010	ERP System	COCT VEN	-3,320,000.00
2023-04-11	9	COCT PEP	COC001	INV002536	33559.0003	ERP System	Sales Order	3,320,000.00
2023-04-26	9	My School Card	MYS001	INV002547	33807.0001	ERP System	Sales Order	187.15
2023-04-26	9	Department of Social Development Western Cape	DEP002	INV002548	33808.0001	ERP System	Sales Order	713,803.00
2023-04-26	9	My School Card	MYS001	DEP20230426	33804.0008	ERP System	My School Card	-187.15
2023-04-26	9	Pure Madi	PUR001	DEP20230428	33804.0010	ERP System	Receipt Thank You	-199,504.46
2023-04-26	9	Department of Social Development Western Cape	DEP002	DEP20230426	33804.0007	ERP System	Receipt Thank You	-713,803.00
2023-04-30	9	Pure Madi	PUR001	CRN000128	33810.0001	ERP System	Credit Note	-14,000.00
2023-04-30	9	Pure Madi	PUR001	INV002549	33809.0001	ERP System	Sales Order	88,968.22
2023-05-08	9	Livelihood	LIV001	INV002551	34002.0002	ERP System	Sales Order	1,892,100.00
2023-05-08	9	Department of Social Development GP VEP	DEP056	INV002550	34002.0001	ERP System	Sales Order	358,745.01
2023-05-08	9	Livelihood	LIV001	DEP20230508	33992.0003	ERP System	Receipt Thank You	-1,892,100.00
2023-05-08	9	Department of Social Development GP VEP	DEP056	DEP20230508	33992.0002	ERP System	Receipt Thank You	-358,745.01
2023-05-26	9	Department of Social Development Hammanskraal	DEP005	INV002552	34002.0003	ERP System	Sales Order	312,133.20
2023-05-26	9	Department of Social Development Johannesburg	DEP027	INV002553	34002.0004	ERP System	Sales Order	321,857.01
2023-05-26	9	COCT PEP	COC001	INV002563	34259.0003	ERP System	Sales Order	3,320,000.00
2023-05-26	9	Department of Social Development Hammanskraal	DEP005	DEP20230526	33992.0014	ERP System	Receipt Thank You	-312,133.20
2023-05-26	9	Department of Social Development Johannesburg	DEP027	DEP20230526	33992.0015	ERP System	Receipt Thank You	-321,857.01
2023-05-26	9	COCT PEP	COC001	SSDEP20230524	33967.0063	ERP System	COCT VEN	-3,320,000.00
2023-05-30	9	My School Card	MYS001	INV002554	34002.0005	ERP System	Sales Order	164.94
2023-05-30	9	My School Card	MYS001	DEP20230530	33992.0016	ERP System	My School Card	-164.94
2023-05-30	9	COCT PEP	COC001	PEPDEP20230530	33882.0004	ERP System	COCT PEP 3rd Tranche	-3,320,000.00
2023-05-30	9	COCT PEP	COC001	PEPDEP20230530	34112.0001	ERP System	COCT PEP 3rd Tranche	3,320,000.00
2023-05-31	9	Pure Madi	PUR001	INV002555	34042.0001	ERP System	Sales Order	74,217.33
2023-06-02	9	Department of Social Development Krugersdorp	DEP010	INV002558	34225.0001	ERP System	Sales Order	382,000.00
2023-06-02	9	Department of Social Development Krugersdorp	DEP010	DEP20230602	34197.0001	ERP System	Receipt Thank You	-382,000.00
2023-06-09	9	Pure Madi	PUR001	DEP20230609	34197.0006	ERP System	Receipt Thank You	-74,968.22
2023-06-12	9	Department of Social Development Witbank	DEP022	INV002565	34361.0001	ERP System	Sales Order	481,231.00
2023-06-12	9	Department of Social Development Witbank	DEP022	MPDEP20230612	34195.0002	ERP System	BAST36 MP: SOCIA001173138	-481,231.00
2023-06-17	9	COCT PEP	COC001	PEPDEP20220617	34510.0001	ERP System	Souper Troopers Refund	96,463.49
2023-06-28	9	My School Card	MYS001	INV002559	34225.0002	ERP System	Sales Order	380.25
2023-06-28	9	My School Card	MYS001	DEP20230628	34197.0015	ERP System	My School Card	-380.25
2023-06-29	9	COCT PEP	COC001	CRN000201	34101.0001	ERP System	Credit Note	-64,282.00
2023-06-29	9	COCT PEP	COC001	INV002557	34102.0001	ERP System	Sales Order	64,282.00
2023-06-30	9	COCT PEP	COC001	INV002564	34259.0004	ERP System	Sales Order	2,266,791.80
2023-06-30	9	Pure Madi	PUR001	INV002560	34240.0001	ERP System	Sales Order	74,365.48
2023-06-30	9	COCT PEP	COC001	SSDEP20230630	34193.0082	ERP System	COCT VEN	-2,266,791.80
2023-07-04	9	UN Pepfar – Shine Tembisa	UNP001	DEP20230704	34497.0001	ERP System	Tamara Hoefer	-5,767.00
2023-07-04	9	UN Pepfar – Shine Tembisa	UNP001	DEP20230704	34506.0001	ERP System	Tamara Hoefer	5,767.00
2023-07-05	9	Department of Social Development Western Cape	DEP002	INV002568	34502.0001	ERP System	Sales Order	237,934.00
2023-07-05	9	Department of Social Development Johannesburg	DEP027	INV002570	34504.0001	ERP System	Sales Order	321,857.01
2023-07-05	9	Department of Social Development Western Cape	DEP002	DEP20230705	34497.0003	ERP System	Receipt Thank You	-237,934.00
2023-07-05	9	Department of Social Development Johannesburg	DEP027	DEP20230705	34497.0005	ERP System	Receipt Thank You	-321,857.01
2023-07-10	9	United Oddice on Drugs and Crime	UNI006	INV002572	34505.0002	ERP System	Sales Order	200,000.00
2023-07-10	9	United Oddice on Drugs and Crime	UNI006	DEP20230710	34497.0006	ERP System	Receipt Thank You	-200,000.00
2023-07-12	9	Department of Social Development Hammanskraal	DEP005	INV002571	34505.0001	ERP System	Sales Order	312,133.20
2023-07-12	9	Department of Social Development Hammanskraal	DEP005	DEP20230712	34497.0007	ERP System	Receipt Thank You	-312,133.20
2023-07-19	9	Department of Social Development Western Cape	DEP002	INV002569	34503.0001	ERP System	Sales Order	492,150.00
2023-07-19	9	Department of Social Development Western Cape	DEP002	DEP20230719	34497.0009	ERP System	Receipt Thank You	-492,150.00
2023-07-21	9	Pure Madi	PUR001	DEP20230721	34497.0012	ERP System	Receipt Thank You	-74,217.33
2023-07-27	9	My School Card	MYS001	INV002573	34505.0003	ERP System	Sales Order	346.36
2023-07-27	9	My School Card	MYS001	DEP20230727	34497.0014	ERP System	My School Card	-346.36
2023-07-28	9	Bankseta	BAN001	INV002576	34788.0001	ERP System	Sales Order	195,999.99
2023-07-28	9	Bankseta	BAN001	DEP20230728	34497.0015	ERP System	Receipt Thank You	-195,999.99
2023-07-31	9	Department of Social Development Witbank	DEP022	INV002566	34361.0002	ERP System	Sales Order	481,231.00
2023-07-31	9	Pure Madi	PUR001	INV002567	34459.0001	ERP System	Sales Order	87,638.89
2023-07-31	9	Department of Social Development Witbank	DEP022	MPDEP20230731	34360.0002	ERP System	BAST36 MP: SOCIA001174274	-481,231.00
2023-08-03	9	Department of Social Development GP VEP	DEP056	INV002582	34903.0002	ERP System	Sales Order	358,745.01
2023-08-03	9	Department of Social Development GP VEP	DEP056	DEP20230803	34873.0001	ERP System	Receipt Thank You	-358,745.01
2023-08-08	9	Department of Social Development Krugersdorp	DEP010	INV002581	34903.0001	ERP System	Sales Order	338,626.00
2023-08-08	9	Department of Social Development Krugersdorp	DEP010	DEP20230808	34873.0002	ERP System	Receipt Thank You	-338,626.00
2023-08-21	9	Foundation Philanthropique Next	FOU002	INV002586	34965.0002	ERP System	Sales Order	2,068,979.00
2023-08-21	9	Foundation Philanthropique Next	FOU002	SSDEP20230821	34576.0042	ERP System	Receipt Thank You	-2,068,979.00
2023-08-26	9	Nussbaum Foundation	NUS001	INV002585	34965.0001	ERP System	Sales Order	400,000.00
2023-08-26	9	Nussbaum Foundation	NUS001	SSDEP20230826	34576.0052	ERP System	Receipt Thank You	-400,000.00
2023-08-29	9	My School Card	MYS001	INV002580	34901.0001	ERP System	Sales Order	264.02
2023-08-29	9	My School Card	MYS001	DEP20230829	34873.0012	ERP System	My School Card	-264.02
2023-08-31	9	Pure Madi	PUR001	INV002578	34829.0001	ERP System	Sales Order	108,392.99
2023-09-11	9	Pure Madi	PUR001	DEP20230911	35174.0005	ERP System	Receipt Thank You	-161,479.37
2023-09-12	9	The Sibanye Rustenburg Mine Community Development	SRM001	INV002574	34656.0001	ERP System	Sales Order	1,294,494.00
2023-09-13	9	ApexHi Charitable Trust	APE001	CRN000241	34960.0001	ERP System	Credit Note	-100,000.00
2023-09-13	9	ApexHi Charitable Trust	APE001	CRN000245	35436.0001	ERP System	Credit Note	-100,000.00
2023-09-13	9	ApexHi Charitable Trust	APE001	INV002583	34958.0001	ERP System	Sales Order	100,000.00
2023-09-13	9	ApexHi Charitable Trust	APE001	INV002584	34962.0001	ERP System	Sales Order	100,000.00
2023-09-13	9	ApexHi Charitable Trust	APE001	INV002592	35437.0001	ERP System	Sales Order	100,000.00
2023-09-13	9	ApexHi Charitable Trust	APE001	SSDEP20230907	34961.0028	ERP System	Receipt Thank You	-100,000.00
2023-09-28	9	My School Card	MYS001	INV002579	34900.0001	ERP System	Sales Order	296.34
2023-09-28	9	My School Card	MYS001	DEP20230928	35174.0007	ERP System	My School Card	-296.34
2023-09-30	9	Pure Madi	PUR001	INV002588	35082.0001	ERP System	Sales Order	64,588.96
2023-10-01	9	COCT PEP	COC001	INV002587	35069.0001	ERP System	Sales Order	300,000.01
2023-10-05	9	Department of Social Development Western Cape	DEP002	INV002602	35675.0001	ERP System	Sales Order	721,942.00
2023-10-05	9	Department of Social Development Western Cape	DEP002	DEP20231005	35292.0002	ERP System	Receipt Thank You	-721,942.00
2023-10-06	9	COCT PEP	COC001	INV002596	35521.0001	ERP System	Sales Order	4,516,839.86
2023-10-06	9	COCT PEP	COC001	SSDEP20231006	35376.0022	ERP System	COCT VEN	-4,516,839.86
2023-10-10	9	Department of Social Development Hammanskraal	DEP005	INV002599	35672.0001	ERP System	Sales Order	312,133.20
2023-10-10	9	Department of Social Development GP VEP	DEP056	INV002601	35673.0002	ERP System	Sales Order	358,745.01
2023-10-10	9	Department of Social Development Krugersdorp	DEP010	INV002600	35673.0001	ERP System	Sales Order	360,313.00
2023-10-10	9	Department of Social Development Hammanskraal	DEP005	DEP20231010	35292.0007	ERP System	Receipt Thank You	-312,133.20
2023-10-10	9	Department of Social Development GP VEP	DEP056	DEP20231009	35292.0004	ERP System	Receipt Thank You	-358,745.01
2023-10-10	9	Department of Social Development Krugersdorp	DEP010	DEP20231010	35292.0006	ERP System	Receipt Thank You	-360,313.00
2023-10-11	9	Department of Social Development Johannesburg	DEP027	INV002598	35670.0001	ERP System	Sales Order	321,857.01
2023-10-11	9	Department of Social Development Johannesburg	DEP027	DEP20231011	35292.0008	ERP System	Receipt Thank You	-321,857.01
2023-10-13	9	Pure Madi	PUR001	DEP20231011	35292.0009	ERP System	Receipt Thank You	-108,511.78
2023-10-18	9	Department of Social Development Witbank	DEP022	INV002589	35224.0001	ERP System	Sales Order	481,231.00
2023-10-18	9	Department of Social Development Witbank	DEP022	MPDEP20231018	35222.0012	ERP System	Receipt Thank You	-481,231.00
2023-10-19	9	Khulisa UK	KHU001	INV002607	35776.0005	ERP System	Sales Order	24,287.90
2023-10-19	9	Livelihood	LIV001	INV002606	35776.0004	ERP System	Sales Order	810,900.00
2023-10-19	9	Khulisa UK	KHU001	DEP20231019	35292.0013	ERP System	Khulisa UK	-24,287.90
2023-10-19	9	Livelihood	LIV001	DEP20231019	35292.0012	ERP System	Receipt Thank You	-810,900.00
2023-10-26	9	My School Card	MYS001	INV002603	35776.0001	ERP System	Sales Order	209.37
2023-10-26	9	My School Card	MYS001	DEP20231026	35292.0017	ERP System	My School Card	-209.37
2023-10-27	9	Duja Consulting – First job	DUJ001	INV002608	35776.0006	ERP System	Sales Order	73,643.52
2023-10-27	9	The Sibanye Rustenburg Mine Community Development	SRM001	DEP20231027	35292.0021	ERP System	Receipt Thank You	-1,294,494.00
2023-10-27	9	Duja Consulting – First job	DUJ001	DEP20231027	35292.0019	ERP System	Receipt Thank You	-600.00
2023-10-27	9	Duja Consulting – First job	DUJ001	DEP20231027	35292.0020	ERP System	Receipt Thank You	-73,043.52
2023-10-30	9	Bankseta	BAN001	DEP20231030	35292.0022	ERP System	Receipt Thank You	-69.68
2023-10-30	9	Bankseta	BAN001	DEP20231030	35777.0001	ERP System	Receipt Thank You	69.68
2023-10-31	9	Pure Madi	PUR001	INV002591	35389.0001	ERP System	Sales Order	56,301.71
2023-11-21	9	COCT PEP	COC001	INV002597	35521.0002	ERP System	Sales Order	4,516,839.86
2023-11-21	9	COCT PEP	COC001	DEP20231121	35390.0058	ERP System	COCT VEN 1002296422 – PEP	-4,516,839.86
2023-11-29	9	My School Card	MYS001	INV002604	35776.0002	ERP System	Sales Order	304.67
2023-11-29	9	My School Card	MYS001	DEP20231129	35712.0006	ERP System	My School Card	-304.67
2023-11-30	9	Pure Madi	PUR001	INV002593	35462.0001	ERP System	Sales Order	57,972.64
2023-12-07	9	Knowledge Pele	KNO001	INV002609	35778.0001	ERP System	Sales Order	365,000.00
2023-12-07	9	Knowledge Pele	KNO001	DEP20231207	35760.0004	ERP System	Rceipt Thank You	-365,000.00
2023-12-12	9	Pure Madi	PUR001	INV002595	35473.0001	ERP System	Sales Order	71,240.24
2023-12-20	9	Pure Madi	PUR001	DEP20231214	35760.0012	ERP System	Rceipt Thank You	-251,984.76
2023-12-27	9	My School Card	MYS001	INV002605	35776.0003	ERP System	Sales Order	206.61
2023-12-27	9	My School Card	MYS001	DEP20231214	35760.0013	ERP System	My School Card	-206.61
2023-12-31	9	Pure Madi	PUR001	CRN000246	35466.0001	ERP System	Credit Note	-64,236.00
2023-12-31	9	Pure Madi	PUR001	INV002618	35928.0001	ERP System	Sales Order	21,001.24
2023-12-31	9	Pure Madi	PUR001	INV002594	35463.0001	ERP System	Sales Order	64,236.00
2024-01-04	9	Department of Social Development Western Cape	DEP002	INV002611	35869.0001	ERP System	Sales Order	721,942.00
2024-01-04	9	Department of Social Development Western Cape	DEP002	DEP20240104	35868.0001	ERP System	Receipt Thank You	-721,942.00
2024-01-12	9	Department of Social Development Hammanskraal	DEP005	INV002612	35869.0002	ERP System	Sales Order	312,133.20
2024-01-12	9	Department of Social Development Johannesburg	DEP027	INV002615	35869.0005	ERP System	Sales Order	321,857.01
2024-01-12	9	Department of Social Development GP VEP	DEP056	INV002614	35869.0004	ERP System	Sales Order	358,745.01
2024-01-12	9	Department of Social Development Krugersdorp	DEP010	INV002613	35869.0003	ERP System	Sales Order	360,313.00
2024-01-12	9	Department of Social Development Hammanskraal	DEP005	DEP20240112	35868.0004	ERP System	Receipt Thank You	-312,133.20
2024-01-12	9	Department of Social Development Johannesburg	DEP027	DEP20240112	35868.0007	ERP System	Receipt Thank You	-321,857.01
2024-01-12	9	Department of Social Development GP VEP	DEP056	DEP20240112	35868.0006	ERP System	Receipt Thank You	-358,745.01
2024-01-12	9	Department of Social Development Krugersdorp	DEP010	DEP20240112	35868.0005	ERP System	Receipt Thank You	-360,313.00
2024-01-25	9	Knowledge Pele	KNO001	INV002616	35869.0006	ERP System	Sales Order	312,000.00
2024-01-25	9	Knowledge Pele	KNO001	DEP20240125	35868.0012	ERP System	Receipt Thank You	-312,000.00
2024-01-29	9	My School Card	MYS001	INV002617	35869.0007	ERP System	Sales Order	283.70
2024-01-29	9	My School Card	MYS001	DEP20240129	35868.0022	ERP System	My School Card	-283.70
2024-01-31	9	Department of Social Development Witbank	DEP022	INV002610	35852.0001	ERP System	Sales Order	481,231.00
2024-01-31	9	Pure Madi	PUR001	INV002619	35930.0001	ERP System	Sales Order	94,689.10
2024-01-31	9	Department of Social Development Witbank	DEP022	MPDEP20240131	35842.0002	ERP System	Receipt Thank You	-481,231.00
2024-02-16	9	Khulisa UK	KHU001	INV002623	36394.0003	ERP System	Sales Order	34,493.08
2024-02-16	9	Khulisa UK	KHU001	DEP20240216	36162.0008	ERP System	Teletransmission Inward Khulisa	-34,493.08
2024-02-21	9	COCT PEP	COC001	INV002635	36697.0001	ERP System	Sales Order	4,516,839.86
2024-02-21	9	COCT PEP	COC001	SSDEP20240221	36699.0002	ERP System	COCT VEN 1002296422	-4,516,839.89
2024-02-22	9	Genesis Steel (Pty) Ltd	GEN001	INV002621	36394.0001	ERP System	Sales Order	20,000.00
2024-02-22	9	Genesis Steel (Pty) Ltd	GEN001	DEP20240222	36162.0010	ERP System	Genesis Strrl (Pty) Ltd	-20,000.00
2024-02-23	9	Bankseta	BAN001	INV002627	36572.0001	ERP System	Sales Order	123,166.67
2024-02-23	9	Bankseta	BAN001	DEP20240223	36162.0012	ERP System	BAN-INV1012	-123,166.67
2024-02-27	9	My School Card	MYS001	INV002622	36394.0002	ERP System	Sales Order	460.78
2024-02-27	9	My School Card	MYS001	DEP20240227	36162.0015	ERP System	My School Card	-400.68
2024-02-29	9	Pure Madi	PUR001	INV002620	36167.0001	ERP System	Sales Order	119,572.75
2024-03-01	9	Pure Madi	PUR001	EFT20240301	36279.0002	ERP System	Alumni Associa	-115,569.00
2024-03-22	9	Catholic Commission for Justice & Peace Malawi	CAT002	EFT20240322	36279.0004	ERP System	Central Methodist MI	-7,000.00
2024-03-26	9	My School Card	MYS001	INV002624	36394.0004	ERP System	Sales Order	360.95
2024-03-26	9	My School Card	MYS001	EFT20240326	36279.0006	ERP System	Myschool	-360.95
2024-03-28	9	Pure Madi	PUR001	EFT20240328	36279.0009	ERP System	Alumni Associa	-119,305.87
2024-03-31	9	—	8000/00/000/00 000	JB030 Year End Bad Debtes	36695.0001	ERP System	Year End 2024 Bad Debts	-412,748.47
2024-03-31	9	—	8000/00/000/00 000	JB030 Year End Adjustment Donatiions Rec	36693.0001	ERP System	2024 Year End Adjustments Donations Rec	7,000.00
2024-03-31	9	Pure Madi	PUR001	INV002625	36470.0001	ERP System	Sales Order	78,790.93
Net Movement Ledger Total Balance								-138,025.21

VTE Master Trial Balance 2 June

🏢 Target Entity Hub:

Receivables Control | Year : Mar 2024 Fin year

📊 1. Summary Grouped By Account Link (Click table headers to sort | Click any blue code button to isolate granular rows below)

📜 2. Granular Transaction Audit Trail

📦 viverge_filter_state ⟳ Refresh

📦 viverge_filter_state