ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ
1
2
Before using, create a copy of this document by clicking "File", then "Make a copy"
3
4
To use this template:
5
1. Visit http://www.ups.com/billingcenter
6
2. Under "Billing Center Quick Links", click on "Invoices"
7
3. Click on an invoice number to access the invoice summary
8
4. On the "Invoice Summary" page, click on "View / Download Invoice Data"
9
5. From the modal, select the "UPS Billing Data (.csv format, 250 data elements)" option and click on Submit.
10
7. On this Google Sheet, open the "Data Import" tab
11
8. Click "File", then "Import", and select the CSV file you downloaded in step 5.
12
9. IMPORTANT: Before clicking "Upload Data", be sure to select "Replace Current Sheet" as the import location.
13
14
If you have any questions, comments, or issues with the document, just send a note to marketing@shiphero.com and we'll give you a hand!
15
16
17
18
19
20
21
22
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