ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
General Submission Information
2
Note that we are only accepting scans for BOGO's,Special Events and direct billing this year (where NLCM does billbacks we do scans)
3
The only tabs that need to be filled out are the Monthly, and Promotional Allowance Tabs, other tabs are informational (Tabs in Green need to be filled out)
4
If submitting for direct billing (not through a distributor) only scans are accepted
5
To Convert $ Amounts to % Percentages: ($ Amount / $ Case Cost) x 100 ---> ($6.53 / $21.73 ) x 100 = 30.05%
6
To Convert Unit Scan $ Amounts to % Percentages: Unit Scan $ Amount (Vendor Pack) ---> $1.09 (6) = $6.54
(Case Scan $ Amount / $ Case Cost) x 100 ---> ($6.54 / $21.73) x 100 = 30.09%
7
Promotional Allowance Tab
8
Column DO NOT DELETE any tabs/columns even if no promotions are running, and DO NOT INSERT any columns
Reference the Example Tab for extra help
9
General This is a protected sheet, only the area that need to be filled out are unlocked for editing
10
CPromotional OfferingsChoose option from dropdown menu, funding/fee and requirements will auto-populate
11
H NotesIf brand requests specific items to be featured/pictured in the Ad, fee's/minimum discount lowered/waived, etc
12
E-FPayment Method Enter an "X" in the column that matches your preferred payment method
13
KBroker/Billing
Info		These are required fields (contract won't be accepted without),put direct billing info if the brand wants to be billed direct otherwise name the distributor in the bill to
14
Monthly Tab
15
ColumnOnly Fill out Monthly tabs where you have promos running, all columns shaded/filled in green DO NOT FILL OUT,
Reference the Example Tab for extra help
16
General This is a protected sheet, only the area that need to be filled out are unlocked for editing, if % value is submitted for non-applicable situation it will be converted and processed as a scan
17
BDistributor Item #Distributor Item # (if item does not have a vendor item # please input 0)
18
CUPC
Code		Input UPC with no check digit, unless it's an international UPC this should result in an 11 digit code (this column has data validation restrictions, DO NOT input hyphens (-)
or spaces ( ) in the UPC)
19
DPackInput Vendor Pack (how many of the item come in one case)
20
ESizeInput Size of the product (ex. 5 Oz, 12 Ct, 1 Ea, etc)
21
F Product DescriptionInput Product Description
22
G OIInput OI% (Off invoice %)
23
H Retailer MCBInput MCB% (Manufacturer Chargeback %)
24
I Distributor MCB Input MCB% (Manufacturer Chargeback %)
25
JScan UnitInput SD% (Scandown %)
26
KSRPInput SRP (Suggested Retail Price)
27
LPromo
Start Date		Do not fill out, this will auto-populate, exception: if submitting for applicable situations (mailers, EDLP's, exclusive events) select "Choose Month" first then "Choose Date Cycle" option and fill in requested dates in the notes (note that we run our promos starting Wednesdays and ending Tuesdays)
*(Cells are locked and will not allow you to edit, fill out the Promotional Allowance Tab)
28
M Promo
End Date		Do not fill out, this will auto-populate, exception: if submitting for applicable situations (mailers, EDLP's, exclusive events) select "Choose Month" first then "Choose Date Cycle" option and fill in requested dates in the notes (note that we run our promos starting Wednesdays and ending Tuesdays)
*(Cells are locked and will not allow you to edit, fill out the Promotional Allowance Tab)
29
L-M, Row 2Choose Date Cycle & MonthChoose month from dropdown menu then choose date cycle, the choices are the 4-5 week options are full Month, Month A/Month B are the 2 week cycle options that match our Ad flyer run dates
* To Check Date Cycle Information Refer to the 2025 Marketing Calendar Tab
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