Project Budget Balance

Back to dashboard Download Excel

Project Name	ADMIN A05:Education Grant - ADMIN A05:Education Grant

Component code	Component name
00	No Budget Component

Budget	$ 263,718.00
Total Expenses	$ -108,178.33
Settled Expenses	$ -98,512.00
Unsettled Expenses	$ -9,665.80
Balance	$ 155,539.67

Details of Settled Expenses Report
Transaction Date	Description	Base Amount	Debit/Credit	Account Code	Period	Transaction Reference	Journal No.
05/31/2023	Jun Johnson/9-12'2023/UBC	$ 5,954.53	D	A05	2023/005	DR2023-00229	31585
05/31/2023	Akari Johnson/8-12'2023	$ 3,965.01	D	A05	2023/005	DR2023-00229	31585
05/31/2023	Ryo Johnson/8-12'2023	$ 3,965.01	D	A05	2023/005	DR2023-00229	31585
06/30/2023	Education Grant/Kevin Breulmann/8-12'23	$ 4,040.65	D	A05	2023/006	DR2023-00256	31633
06/30/2023	Edu.Grant/Ken Johnson/1-4'2023	$ 6,126.28	D	A05	2023/006	DR2023-00266	31636
06/30/2023	Ryo Johnson/Add.2022 School shoes claim	$ 96.57	D	A05	2023/006	DR2023-00266	31636
06/30/2023	Cancel DR2023-00229/Akari Johnson/8-12'23	$ -3,965.01	C	A05	2023/006	DR2023-00266	31636
06/30/2023	Edu.Grant/Akari Johnson/8-12'2023	$ 9,218.99	D	A05	2023/006	DR2023-00266	31636
06/30/2023	Cancel DR2023-00229/Ryo Johnson/8-12'23	$ -3,965.01	C	A05	2023/006	DR2023-00266	31636
06/30/2023	Edu.Grant/Ryo Johnson/8-12'2023	$ 9,218.99	D	A05	2023/006	DR2023-00266	31636
06/30/2023	Kenji Breulmann/Stl.Education Grant 1-6'2023	$ 5,222.75	D	A05	2023/006	DR2023-00246	31674
09/19/2023	Breulmann/EGR Trvl/Ticket 8-9'23/Leon	$ 2,495.81	D	A05	2023/009	OT2023-00764	31829
10/31/2023	Kevin Breulmann/Edu Grant Travel 2023	$ 2,139.39	D	A05	2023/010	OT2023-00905	31935
12/31/2023	DR2024-00174/Rose Masupa/Stl.Education Grant/1-62023	$ 7,229.06	D	A05	2023/012	OT2024-00321	32369
12/31/2023	DR2024-00164/Education Grant/Kenji Breulmann/10-12'23	$ 1,479.26	D	A05	2023/012	OT2024-00321	32369
12/31/2023	DR2024-00144/Stl.Education Grant/LeonBreulmann/1-9'2023	$ 4,459.07	D	A05	2023/012	OT2024-00321	32369
12/31/2023	DR2024-00144/Adv.Edu.Grant/Leon Breulmann/10-12'2023	$ 1,476.55	D	A05	2023/012	OT2024-00321	32369
12/31/2023	Edu.Grant/Jun Johnson/1-6'2023	$ 13,412.95	D	A05	2023/012	OT2024-00340	32386
12/31/2023	Edu.Grant/Akari Johnson/1-6'2023	$ 12,054.20	D	A05	2023/012	OT2024-00340	32386
12/31/2023	Edu.Grant/Ryo Johnson/1-6'2023	$ 12,563.03	D	A05	2023/012	OT2024-00340	32386
12/31/2023	Edu.Grant Travel 9-12'2023/Jun Johnson	$ 1,024.45	D	A05	2023/012	OT2024-00340	32386
12/31/2023	DR2024-00340/EGR/Ken Johnson/add.lumpsum board '22	$ 300.00	D	A05	2023/012	OT2024-00391	32413
	Totals	$ 98,512.53

Project Name	ADMIN A05:Education Grant - ADMIN A05:Education Grant

Component code	Component name
00	No Budget Component

Budget	$ 117,296.00
Total Expenses	$ -6,825.00
Settled Expenses	$ -12,865.00
Unsettled Expenses	$ 6,040.19
Balance	$ 110,471.00

Details of Settled Expenses Report
Transaction Date	Description	Base Amount	Debit/Credit	Account Code	Period	Transaction Reference	Journal No.
03/07/2024	Leon Breulmann/EGR Trvl/Ticket 24Mar.-15Apr. 2024	$ 1,846.91	D	A05	2024/003	DR2024-00146	32308
03/07/2024	Kevin Breulmann/EGR Trvl/Ticket 24Feb.-5May 2024	$ 2,671.70	D	A05	2024/003	DR2024-00146	32308
04/19/2024	Edu.Grant/Jun Johnson/1-31 Jan. 2024 (final)	$ 1,862.46	D	A05	2024/004	DR2024-00237	32426
04/19/2024	Edu.Grant/Akari Johnson/1-31 Jan. 2024 (final)	$ 3,165.50	D	A05	2024/004	DR2024-00237	32426
04/19/2024	Edu.Grant/Ryo Johnson/1-31 Jan. 2024 (final)	$ 3,318.62	D	A05	2024/004	DR2024-00237	32426
	Totals	$ 12,865.19

Project Name	ADMIN A05:Education Grant - ADMIN A05:Education Grant

Component code	Component name
00	No Budget Component

Budget	$ 263,718.00
Total Expenses	$ -108,178.33
Settled Expenses	$ -98,512.00
Unsettled Expenses	$ -9,665.80
Balance	$ 155,539.67

Details of Unsettled Expenses Report
Transaction Date	Description	Base Amount	Debit/Credit	Account Code	Period	Transaction Reference	Journal No.
06/30/2023	Advance/Kevin Breulmann/1-7'2024	$ 1,322.40	D	160	2023/006	DR2023-00256	31633
06/30/2023	Education Grant/Adv.LeonBreulmann/1-7'23	$ 4,045.82	D	160	2023/006	DR2023-00260	31635
06/30/2023	Edu.Grant Advance/Akari Johnson/Jan.2024	$ 2,148.79	D	160	2023/006	DR2023-00266	31636
06/30/2023	Edu.Grant Advance/Ryo Johnson/Jan.2024	$ 2,148.79	D	160	2023/006	DR2023-00266	31636
	Totals	$ 9,665.80

Project Name	ADMIN A05:Education Grant - ADMIN A05:Education Grant

Component code	Component name
00	No Budget Component

Budget	$ 117,296.00
Total Expenses	$ -6,825.00
Settled Expenses	$ -12,865.00
Unsettled Expenses	$ 6,040.19
Balance	$ 110,471.00

Details of Unsettled Expenses Report
Transaction Date	Description	Base Amount	Debit/Credit	Account Code	Period	Transaction Reference	Journal No.
03/07/2024	Rcv.DR2023-00260/Leon Breulmann/1-7'2023	$ -4,045.82	C	160	2024/003	DR2024-00144	32291
03/07/2024	Adv.Edu.Grant/Kenji Breulmann/1-9'2024	$ 4,397.55	D	160	2024/003	DR2024-00144	32291
03/13/2024	Advance/Kenji Breulmann/1-9'2024	$ 4,405.64	D	160	2024/003	DR2024-00164	32298
03/15/2024	Rcv.DR2022-00358/Rose Masupa/Education Grant/2022-2023	$ -6,500.00	C	160	2024/003	DR2024-00174	32299
04/19/2024	Rcv.DR2023-00266/Akari Johnson/Jan. 2024	$ -2,148.78	C	160	2024/004	DR2024-00237	32426
04/19/2024	Rcv.DR2023-00266/Ryo Johnson/Jan. 2024	$ -2,148.78	C	160	2024/004	DR2024-00237	32426
	Totals	$ -6,040.19

SUN system ID	ADMA05
SUN system name	ADMIN A05:Education Grant
Project name	ADMIN A05:Education Grant - ADMIN A05:Education Grant
SUN data's last update	08/05/2024

Pledge	Receipt	Arrear
-	-	-

Current Cash Available:	$1,866,955.42

Component code	Component name	Budget	Total expenses	Settled expenses	Unsettled expenses	Balance
00	No Budget Component	$ 117,296.00	$ -6,825.00	$ -12,865.00	$ 6,040.19	$ 110,471.00
	Subtotal	$ 117,296.00	$ -6,825.00	$ -12,865.00	$ 6,040.19	$ 110,471.00

Pledge	Receipt	Arrear
-	-	-

Current Cash Available:	$1,713,706.66

Component code	Component name	Budget	Total expenses	Settled expenses	Unsettled expenses	Balance
00	No Budget Component	$ 263,718.00	$ -108,178.33	$ -98,512.00	$ -9,665.80	$ 155,539.67
	Subtotal	$ 263,718.00	$ -108,178.33	$ -98,512.00	$ -9,665.80	$ 155,539.67