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	$ -99,834.93
Settled Expenses	$ -98,512.00
Unsettled Expenses	$ -1,322.40
Balance	$ 163,883.07

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	$ -21,668.38
Settled Expenses	$ -12,865.00
Unsettled Expenses	$ -8,803.19
Balance	$ 95,627.62

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	$ -99,834.93
Settled Expenses	$ -98,512.00
Unsettled Expenses	$ -1,322.40
Balance	$ 163,883.07

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
	Totals	$ 1,322.40

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

Component code	Component name
00	No Budget Component

Budget	$ 117,296.00
Total Expenses	$ -21,668.38
Settled Expenses	$ -12,865.00
Unsettled Expenses	$ -8,803.19
Balance	$ 95,627.62

Details of Unsettled Expenses Report
Transaction Date	Description	Base Amount	Debit/Credit	Account Code	Period	Transaction Reference	Journal No.
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
	Totals	$ 8,803.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	05/06/2024

Pledge	Receipt	Arrear
-	-	-

Current Cash Available:	$1,678,194.60

Component code	Component name	Budget	Total expenses	Settled expenses	Unsettled expenses	Balance
00	No Budget Component	$ 117,296.00	$ -21,668.38	$ -12,865.00	$ -8,803.19	$ 95,627.62
	Subtotal	$ 117,296.00	$ -21,668.38	$ -12,865.00	$ -8,803.19	$ 95,627.62

Pledge	Receipt	Arrear
-	-	-

Current Cash Available:	$1,714,304.34

Component code	Component name	Budget	Total expenses	Settled expenses	Unsettled expenses	Balance
00	No Budget Component	$ 263,718.00	$ -99,834.93	$ -98,512.00	$ -1,322.40	$ 163,883.07
	Subtotal	$ 263,718.00	$ -99,834.93	$ -98,512.00	$ -1,322.40	$ 163,883.07