Amalgam Template - Sales-COGS-Inventory.xlsx

	B	C	D
1
2	Amalgam
3	Sales-Inventory-COGS Template
4	Through May 31, 2024
5
6		Period Starting:	5/1/2024
7		Period Ending:	5/31/2024
8
9		Checks
10		Check to BS:
11
12
13
14		Overview of File
15		- This schedule creates journal entries to capture, sales, COGS, and inventory.
16		- The scenario is one where the company generates sales through Shopify. That data is then matched
17		with static COGS data to then produce a monthly journal entry.
18		Summary of Tab Functions
19		data_UnitCOGS: The static data table that outlines the COGS for each product.
20		data_ShopifySales: A raw data pull of the sales data from Shopify.
21		load_Journals: Amalgam template to upload the journal entries into the General Ledger.
22		check_BS: A Balance Sheet Report that checks for matching between the GL and this schedule.
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100