FedEx / UPS Shipping Analysis Reports

Accessorial Charge Summary
This report summarizes all accessorial charges by Invoice Number.

Accessorial Charge Summary
This is a summary of all accessorial charges by Plan Number. For example, an extra charge like a destination charge or fee for handling hazardous materials may apply to certain shipments. Also referred to as value-added service charges, you can add them to your shipping selection as needed. Value-added services are location-dependent.

Account Summary
Summary of total transaction, billed weight, charges and percentage spent for each account number.

Address Correction Listing
This report provides detailed information about shipments that received an address correction. The original (“wrong”) address and the corrected address are provided for each shipment. The wrong address is in red.

Adjustment Detail
This report provides in depth detail of all adjustments that show on your invoice. Whether the adjustment is a negative or positive, credit or debit. Full visibility for each is demonstrated. The functionality of Crystal Reports allows you to drill down on each adjustment type individually for a better look.

Adjustment Summary
This report provides a snapshot of all adjustments appearing on a particular invoice number.

Charge Category Code Summary
This report lists all the Charge Category Detail Codes within each Charge Category Code. It can be used to ascertain accessorial charges applied to a shipment or a charge refunded for a shipment due to either Voids, GSR (Guaranteed Service Refunds), Residential Adjustments, chargebacks, etc.

Charge Code Detail
This report is a detailed breakdown of Charge Category Detail Code fields by invoice number. It lists all the charges that were applied to a shipment or adjustment of charges that were erroneously applied or credited to the shipment. Charge Category Detail Codes are all the charges applied to a shipment.

Charge Code Summary
This report summarizes Charge Category Detail Code by account number.

Charge Code Summary
This report summarizes Charge Category Detail Code by invoice number.

Charge-back Listing
This report provides information about packages that were shipped by you, but were intended to be billed to the receiver or a third party. The payer refused charges or an invalid or suspended account number was given; UPS has rebilled your account number.

Charge-back Summary
This report provides information about packages that were shipped by you, but were intended to be billed to the receiver or a third party. The payer refused charges or an invalid or suspended account number was given; UPS has rebilled your account number.

Distribution by Shipment Type
Shows the percentage and number of packages shipped to different states by service types and gives average package cost of service type used and total packages shipped using that service type for a given invoice number and invoice week as a subtotal.

Service Failure Refund Listing
This report provides a detailed listing of all Guaranteed Service Refunds that appear on that week’s UPS plan number.

Late Shipment Credit Listing
Listing of packages for which a Guaranteed Service Refund was issued.

Hundredweight Summary
This is a summary of all Hundredweight shipments, the lead tracking number and charges associated.

Inbound/Outbound Shipment Summary
This report provides a summary of all inbound and outbound freight by service used, it includes total package counts, weights and charges for each category.

Shipment Insurance Details
Lists Insured packages, their values and the charges for carrier insurance. UPS automatically protects each domestic package and international shipment against loss or damage up to a value of US $100 without a declaration of value. Shippers may declare a value for amounts in excess of US $100 by showing a value in excess of $100 in the declared value field of the UPS source document, or the UPS shipping system used, and paying an additional charge. If the Charge Description Code field has “EVS” code then Basis Value field will show declared value and Net Amount field will show Insurance charge.

Carrier Invoice Summary
This report is a summary of invoices in a given timeframe or date range. This will include the discount percentages from the published rates as well.

Invoice Summary by UPS Plan Number
This report outlines a complete summary of the entire UPS plan number, which includes all accounts contained within that plan number. The breakdown summary of charges is also categorized by prepaid, third party and collect shipments and charges. This report also includes carrier incentive discounts from published rates.

Consignee/Receiver Summary by Weight/Cost
This report provides insight into the top consignees shipped to; it includes consignee names, shipment total weights, total costs and packages shipped.

Reference Number Listing
This report provides detailed information about each shipment, where the “reference one” and “reference two” fields are utilized. Shipments for each reference number are displayed separately. When you send a shipment, you can assign a reference that will make it easier to coordinate with your or your customer’s billing or filing system. The reference can be a purchase order number, a customer’s job number, a Bill of Lading number, or a group of words that identifies the shipment.

Reference “One” Listing
This report allows you to view all detail by the criteria entered in the “reference one” field by the shipper.

Reference “Two” Listing
This report allows you to view all detail by the criteria entered in the “reference two” field by the shipper.

Reference Summary
Summary of Reference Number listing.

Residential and Commercial Adjustments
In the US, an additional charge is made for deliveries to residential addresses. This report provides information concerning shipments with incorrect residential/commercial information. Charges are shown for residential shipments that were shipped as commercial, and credits are shown for commercial shipments that were shipped as residential.

Returns Service Detail
This report shows the shipment that was returned from recipient back to shipper. Reasons can include order inaccuracy, customer dissatisfaction, diagnostics and repair, damage, or return of goods into inventory.

Service Statistics – Account Number
This report provides information about your packages summarized by UPS Service Types by each account number.

Service Statistics – Invoice Number
This report provides information about your packages summarized by UPS Service Types by every invoice number.

Accessorial Charge Details
This report is the detail listing of the Top 5 Accessorial charges applied by invoice number and invoice week.

Undeliverable Return Listing
This report shows shipments that were returned to shipper. Reasons can include RECEIVER DID NOT WANT, CUSTOMER UNAVAILABLE TO SIGN FOR PACKAGE, INCORRECT POSTAL CODE, APARTMENT NUMBER REQUIRED FOR DELIVERY, etc.

Dimensional Weight Adjustment Listing
This report provides detailed information about packages that received a dimensional correction. The original weight and the billed weight are provided for each package.

Dimensional Weight Adjustment Summary
This report provides summary information about packages that received a dimensional correction. The original weight and the billed weight are provided for each package.

Distribution by Service Type
This report gives you the ability to see how your shipments are distributed across UPS zones and also provides visibility into which UPS services you use to each zone.

Distribution by Service Type / Weight
This report gives you the ability to see how your shipments are distributed across UPS zones and also gives you visibility into which UPS services you use to each zone by weight break. This report gives a summary by invoice number and account number.

Distribution by Service Type / Weight by Week
This report gives you the ability to see how your shipments are distributed across UPS zones also gives you visibility into which UPS services you use to each zone by weight break. This report gives a summary by invoice week.