ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Columns A - P: YOU enter your info HEREColumns Q-Z: These are Formulas, YOU DO NOT ENTER ANYTHING
2
Order DateCustomer NameCDS or INVENTORYCATEGORY: REORDER, PARTY SALES, FACIAL SALES, ON-THE-G0, ETC… Account(Checking, Pro Pay, Square, etc) CDS SHIPPING COST Paid to MKCDS Orders $ on PAID Section 2 samples from MKDeposit Amount(the 'cash' in hand that went into the bank. Or venmo, or propay…. Etc...) Discount/Giveaway Retail AmountSales Tax RATE Charged to customerShipping Cost (Pirate Ship, Stamps.com, Pittney Bows)Amount charged customer for ShippingPro Pay FeesPay Pal FeesSquare FeesVenmo Fees Retail Value of Sales Sales Tax collectedUnrecoevered Sales Tax TOTAL Unrecovered Sales Tax for different counties Unrecovered Sales Tax for Discounts and Giveaways Inventory(50% Reorder) PCP(5%) Sales Aids (Section 2)(5%) TOTAL of PCP and SECTION 2 PROFIT
3
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
4
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
5
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
6
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
7
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
8
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
9
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
10
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
11
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
12
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
13
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
14
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
15
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
16
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
17
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
18
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
19
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
20
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
21
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
22
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
23
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
24
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
25
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
26
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
27
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
28
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
29
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
30
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
31
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
32
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
33
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
34
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
35
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
36
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
37
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
38
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
39
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
40
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
41
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
42
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
43
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
44
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
45
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
46
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
47
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
48
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
49
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
50
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
51
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
52
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
53
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
54
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
55
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
56
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
57
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
58
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
59
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
60
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
61
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
62
Totals $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
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