UPS: Create and Print an End of Day Report
UPS OnLine Tools system no longer requires this procedure.
This procedure is no longer necessary if you are using the UPS OnLine Tools system.
If your driver wants you to provide an End of Day form, or your UPS rep wants to review your PLD file, just let them know that ShipWorks is a Certified UPS Partner and sends this information directly to UPS using their API.
Our integration with UPS generates a UPS label with a package and bow-tie icon at the bottom right of the label. This indicates to drivers that the packages are pre-paid and pre-scanned. When packages are processed using the OnLine Tools system, an “End of Day” report is not required and UPS drivers do not need to scan each package. At most, all you would need to give them is a total package count that they would enter into their PDA. If your driver insists on scanning each package, provide him/her with an End of Day report.
Figure 1.1: The bow-tie indicates that your package was pre-scanned into the UPS OnLine Tools system.
-
From the Manage tab, click Filters New Filter.
-
Enter a name for the filter, e.g. "UPS End of Day" and then click "Next."
-
Indicate "For any shipment in the order..." and then click the “Add Condition” green plus sign icon after “If All of the following conditions are met…” .
-
Click Order Total and change it to For any Shipment using the dropdown menu provided.
-
Set the provider condition for the filter.
Under the line "For any shipment in the order...", leave “If All of the following conditions are met…” and click the “Add Condition” icon
.
Leave the default "ProviderEquals" as is, and select UPS from the drop-down menu.
-
Set the Processed Status condition.
Again, under the line "For any shipment in the order...", click the “Add Condition” icon
Change the second condition by clicking Provider and selecting Processed Status from the dropdown menu.
Select Processed from the dropdown menu.
-
Set a branch for the next conditions (ship date and processed dates).
Under the line "For any shipment in the order...", click the “Branching” icon.
Leave And as is.
Change "If All..." to "If Any of the following conditions are met."
-
Set the ship date today condition:
- Click the Add conditions" icon
- Change Provider to Ship Date, then click Equals and select Is Today from the drop-down menu.
-
Repeat as in step 8 to set up the Processed Date today condition:
- Click the Add conditions" icon .
- Change Provider to Processed Date.
- Click Equals and select Is Today from the drop-down menu.
Your filter setup should now look like this:
-
Click "Next" to save your changes.
-
(OPTIONAL) :Adjust any grid columns according to your own business practices.
-
Click "Finish" and "Close".
Once you've finished setting up your UPS End of Day filter, you'll print this report for your records.
Templates format your data in an easy-to-read way, either in an email to customers, invoices, packing slips, or reports. If you navigate to Manage Templates, you can see all of the default templates ShipWorks has available. The template used in the end of day report is the “Shipping Profit and Loss” template.
-
Select all orders (Ctrl + A) in your End of Day filter.
-
Right-click on your orders and select Print Reports Financials Shipping Profit and Loss.
-
Select your printer (from the drop-down menu) and click “Print”.
Your "Shipping Profit and Loss" report will now print. The total number of orders is shown at the top of the page.
You can export data from your "UPS End of Day" report to Microsoft Excel by following the directions below.
-
Highlight your “End of Day” filter and select all of the orders located in it (Ctrl + A).
-
Go to Output Save Reports Financials Shipping Profit and Loss.
-
On the “Save As…” screen, name your file and save in an HTML format. This means that your file should end in .html (like example.html).
-
Open Microsoft Excel and open the "Shipping Profit and Loss" HTML file in Excel.
Your "Shipping Profit and Loss" report should now appear in Microsoft Excel.
Still Need Help?
Please feel free to reach out to one of our awesome Technical Support Representatives in St. Louis. We are happy to help.
Have a comment to share about this article? We'd love to hear from you. You must be logged in to your Support Portal account to leave a comment.
Comments
1 comment
Note that this won't show any orders shipped UPS via Best Rate. To show those you have to change Provider to UPS -> Service. Set condition to Is In List and select all to choose All Values. That will give you a filter that shows all packages shipped via UPS including ones with the "Best Rate" carrier.