26. ASB Store Inventory Roll-Forward_Reconciliation, 12-23v CURRENT.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Sweetwater Union High School District
2	Associated Student Body
3	Inventory Roll-forward/Reconciliation Schedule
4
5		Site:	ANY SCHOOL - ASB
6		Period:	As of 12/31/2023
7
8
9		Description	Beginning Inv No. 7/01/2023	Unit Cost (Incl. Tax & Shipping)	Beginning Inv Value	ADD: Purchases	LESS: Sold	New Unit Cost (Incl Tax & Shipping)	Ending Inv No.	Ending Inv Value	Comp Qty	Student Awards Qty	Damaged Inventory Discarded	Adj Book Qty	Adjusted Ending Inv Value 12/31/2023	Physical Inv Count	Physical Inv Value	Variance	Variance Value
10	1	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
11	2	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
12	3	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
13	4	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
14	5	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
15	6	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
16	7	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
17	8	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
18	9	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
19	10	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
20	11	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
21	12	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
22	13	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
23	14	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
24	15	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
25	16	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
26	17	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
27	18	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
28	19	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
29	20	0	-	$ -	$ -	-	-	$ -	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
30
31		Totals	-	-	$ -	-	-	-	-	$ -	-	-	-	-	$ -	-	$ -	-	$ -
32
33																Variance	#DIV/0!	Reasonable to be within ± 10%.
34	Note 1: Beginning inventory should agree to the prior period ending inventory.
35	Note 2: Purchases should be supported by invoices. Accounting throughout the year for this:
36		Acct Name	Acct #	Debit	Credit
37		C.O.G.S. Store	5108	$
38		Main Checking	1100		$
39	Note 3: Sold items must be supported by cash receipts. Accounting throughout the year for this:
40		Acct Name	Acct #	Debit	Credit
41		Main Checking	1100	$
42		Store Sales Income	4124		$
43
44	Note 4: The adjustment based on the above roll-forward/recon and phyiscal count is as follows. Can be an increase OR decrease:
45		Increase:
46		Acct Name	Acct #	Debit	Credit
47		Inventory	1400	$		Calculate: Cells Q31 - E31 = AJE amount
48		C.O.G.S. Store	5108		$
49
50		Decrease:
51		Acct Name	Acct #	Debit	Credit
52		C.O.G.S. Store	5108	$		Calculate: Cells E31 - Q31 = AJE amount
53		Inventory	1400		$
54
55	Note 5: Adjusting journal entries for changes due to comp items, student awards, and/or damaged goods is as follows:
56		Acct Name	Acct #	Debit	Credit
57		Complimentary Items Expense	6317.3	$ -		Debit is linked to table below
58		Student Awards Expense	6500	$ -		Debit is linked to table below
59		Damaged Items Expense	6333	$ -		Debit is linked to table below
60		C.O.G.S. Store	5108		$ -	Credit is sum of debits
61
62		The tables/schedules below will need to manually be updated based on the inventory/roll-forward schedule above.
63		COMPLIMENTARY ITEMS
64		Description	Cost	Qty	Total	GL Account
65					$ -	6317.3
66					$ -
67					$ -
68					$ -
69					$ -
70					$ -
71
72				-	$ -	COLUMN K
73			Check	-	s/b zero
74		STUDENT AWARDS
75		Description	Cost	Qty	Total	GL Account
76					$ -	6500
77					$ -
78					$ -
79					$ -
80					$ -
81					$ -
82
83				-	$ -	COLUMN L
84			Check	-	s/b zero
85		DAMAGED ITEMS
86		Description	Cost	Qty	Total	GL Account
87					$ -	6333
88					$ -
89					$ -
90					$ -
91					$ -
92					$ -
93
94				-	$ -	COLUMN M
95			Check	-	s/b zero
96
97
98
99
100