Parcel Reports

Accessorial Analysis Details

Details

Explains details over each aspect of an invoice, along with providing information about what kind of surcharge was enforced, the service, as well as address and dimensioning information.

Accessorial Summary

Summary

The number of times an accessorial was applied to orders in the given date range, and related charges.

Accounts with No Data

Summary

Explains what accounts have no data attached with them, a simple sheet that only shows the client, carrier, account, and invoice date.

Additional Handling

Details

Looks at any invoice in which there was an “additional handling” charge over the time period and provides basic information about the package including weight, dimensions, and the reference numbers.

Address Correction

Details

Sorted by invoice number, it details out every facet of address information including old city, receiving company, old country, old address, and its new city, state, country, and postal code.

IMPORTANT

Address Correction Audited

Details

Provides information about any account number and the old delivery address, as well as the new address that replaces it. It has information about cities, states, countries, postal codes, and service used.

Air to Ground Comparison

Details

Analyzes a tracking number and provides information about it’s air charge, air days, ground days, as well as data on the address.

Analysis Details

Details

Provides all-encompassing details regarding every order with the given carrier including details such as: ship/delivery date, tracking number, cost on invoice, service, dimensions, addresses, and more.

Annual Summary

Summary

Looks at each service, by quarter, and how much it was used in every aspect (by dollars spent, number of packages, number of pounds, and more).

Annual Summary - International Breakdown

Summary

This breaks down how many packages were shipped internationally by service over a quarter, and other details like how much money was spent on international services, and the weight of the packages.

Audit Checks

Details

Displays every case in which the audit process began an audit case, and details out the kind of audit that was performed (GSR, residential, void, address correction, etc…)

IMPORTANT

Audit Credits

Details

Explains the total credit received for each carrier and their services

IMPORTANT

Billed Invoice vs Credited Invoice

Details

Looks at the billed invoice and compares it to the credited invoice, while looking at the dollar amount for each.

UPS only

Charge Summary by Service

Summary

Summarizes the number of packages per service, and the correlating invoice amount and payment amount.

Chargeback Shipments

Summary

Client Credit Audit Summary

Summary

Shows the client’s credits for each week of the report’s time period.

Client Credit Summary

Summary

Breaks down the amount of credit credited to the customer by week.

Client Net Spend Summary

Summary

The amount of money spent per shipping service (i.e. ground, overnight, international, etc…).

Contested Report

Details

Explains any invoice and its correlated charge description that is currently being contested.

Cost Allocation by Reference

Details

Looks at the transactions for any given invoice and their reference number, and tells you the charges associated with that invoice and its actual weight vs its billed weight.

Cost Analysis Summary

Summary

Looks at the number of transactions and the average cost for each transaction, sorted by the service or charge types.

Fedex only

CPP Report

Details

Analyzes the cost per package across a variety of dimensions including by the month, or the number of packages per month, average weight of package, and the total weight of the package. In other tabs, it explains your CPP for accessorial, freight, fuel, service levels, and includes the raw data.

Declared Value

Summary

Examines the declared value of any invoice over the time period with each carrier.

Delivery Status

Details

Looks at the delivery status for every invoice, by deliver date, and tells you if it is on time or late. It also provides details about the address, weight, dimensions, and service type.

Delivery Summary

Summary

Provides summary data for every service used, including information on the total packages, charges, weight, and average weight for that service.

Dimensional Weight

Details

Covers every detail about any given item in an order in regards to the item’s weight, length, width, height, and the address.

Duplicate Charges

Details

Looks at duplicate charges by carrier, and the invoice amount for that invoice number.

Duties and Taxes

Summary

Provides a summary of what charges were incurred over the time period, the cost of each charge, and basic information about each of the charger’s invoices.

Duties and Taxes Shipment Details

Details

Sorted by invoice number, details shown are about the total charges and cost of charges, as well as about various duties and taxes.

Exception and Reason

Details

Shows any invoice that had an exception raised, and is sorted by tracking number. Also has information regarding service type, total charges, and estimated shipping date.

Fedex Charge Code Summary

Summary

Provides every charge description for FedEx services and the number of times you were charged for that specific one, as well as the total cost you spent in charges.

FedEx only

GL Code

Details

?

GL Reports

Summary

Not currently supported, shows exports and shipment cost data with customer specific general ledger (GL) codes applied to billing lines.

Requires Additional Fee

Ground Transit Days

Details

Looks at the co-signee’s state, and provides the number of times a ground transit service took one day, two days, three days, or more. Information also provided regarding the total shipment counts for each state.

GSR Response

Details

List of all shipments for which the Guaranteed Service Refund (GSR) audit was flagged, including response status.

International Export

Details

Provides information regarding every detail about any invoice that is an international expert. The details include: total charges, invoice/ship/scheduled/delivery/due dates, address, weight, dimensions, and zones.

International Import

Details

Explains invoice numbers in depth by including metrics on total charges by service, addresses, package weight and dimensions, for any international import invoice.

Invoice Summary

Summary

Inspects the details of every invoice by carrier and displays information regarding the invoice number, gross charges, discount, quantity, and the bill weights.

Invoice Summary by Account

Summary

Looks at each account with each carrier and provides details about the gross charges, discount, discount %, net amount, packages, and the billed weight.

Late Payment Charges

Details

Gives a few columns that explain the account number, invoice number, invoice cost, and the late payment fee associated with that invoice.

Late PLD Uploads (Denials) Report

Details

UPS only

Late with Exception and Reason

Details

Looks at any tracking number that ended up being late, and provides the reason it was late as well as the charges associated. Other basic delivery data points also included like ship date, estimated days, scheduled date, and the delivery date.

Lost and Damaged Packages

Summary

Explains basic information regarding any invoice that contained lost or damaged goods such as: address information, declared value, total charges, and damage messages/notes.

Manifest and Non Manifest PU Record Number Summary

Summary

Report showing weight and shipping costs by pickup number (PU).

UPS only

Multiple Shipments to Same Consignee

Details

Provides details about any invoice that had multiple shipments to the consignee, and includes information like the service used, the weight, date, and address.

Net Spend Weekly Summary

Summary

Summarizes the weekly dollars spent for each carrier.

On Time Performance - Total Lates by Service

Summary

Analyzes the number of packages and their on time performance, sorted by carrier and their service. Also gives a simple column dedicated to the late % of the service.

On Time Performance by Service

Summary

Looks at the services for each company, and provides details about the total packages shipped with them, the total money spent, on time percentage, and late shipping information.

Oversize Packages

Details

Details out every metric about any oversize package order including metrics like weight, dimensions, the surcharges accrued, invoice amount, and more.

IMPORTANT

Package Detail

Details

Provides all details about any given package for an account, including metrics like address, zone, package type, number of packages, weight and dimensions, surcharges, and more.

Individual Reports Available for FedEx, DHL, and UPS

Package Type by Summary

Summary

Sorted by state, provides information about what kind of service type was used (two day, three day, ground, express, etc.), and the total number of packages by state.

Payment

Summary

Includes basic payment information for each account number like the number of packages or transactions, the gross charges, and credits involved.

Payment Number Invoice Details

Details

Showcases the invoice amount and payable account for each invoice for the carriers.

Payment Number Transactions

Details

Shows the number of transactions by client, and other payment details like status, amount paid, running balance, tax balance, and more.

Recovery and Transaction

Details

Shows the total credits for each carrier over the year, and in other tabs shows the shipment counts for each carrier and refund data by carrier.

IMPORTANT

Recovery and Transactions - Transaction Count

Summary

Shows the number of transactions, and the charge for each transaction.

Residential Vs. Commercial

Details

Provides two separate tabs to go over details regarding surcharges to your commercial or residential orders, along with address, company, and dimension information.

Returned Packages

Details

Sorted by account number, it details out address information, dates, status, and total charges for any transaction that resulted in a returned package.

Saturday Pickup and Delivery

Summary

Explains various metrics about what service was used, status, and net amounts for Saturday pickup and delivery orders.

IMPORTANT

Service Level Analysis

Details

Provides extensive details about anything cost-related with Fedex including freight charges, discounts, total charges, and average package weight and dimension information.

Shipment Details

Details

Explains shipments at every level, including details on total charges, transportation charges, taxes, dates, addresses, box sizing, carriers, and more.

Spend by Service

Summary

Explains simply how much money you spent, by month, on each service during the generated report’s time period.

Spend Summary

Summary

Summary showing total shipment amounts via each carrier and service, and table showing breakdown of Accessorial charges.

IMPORTANT

Summary by State

Summary

Provides details, filtered by state, about the average number of days in transit to get there, the cost per shipment, the average zone, the total number of shipments, average weight, and the total money spent on shipping to that state.

Surcharge Summary

Summary

Provides a clear list of the kinds of surcharge received over the year, covers surcharges and their total charges such as: oversize, Saturday delivery, fuel, address correction, residential, and more.

Third Party Shipments

Details

Provides information about invoice number, the third party service, dates, address, dimensions, and weight.

Transaction by Credit Summary

Summary

Breaks down the credit amount based on the billing type (prepaid, consignee, inbound collect, inbound 3rd party, outbound 3rd party or collect).

Transit Days from Each Location

Summary

This looks at different accounts and their services, and how many transit days it normally takes for a delivery to happen. Also provides a shipment count for each of those locations.

Transportation Packages Summary

Summary

Analyzes the number of packages and the zone for each package by the kind of service used or the service charge that was charged.

Void

Summary

Summarizes different metrics for any order that ended up being void, like invoice amount, total charges, address, and date information.

Weight Distribution by Service

Summary

Provides details about the weight of packages for any given service used.

Zone Density

Summary

Looks at how the total number of times any service shipped in different zones (zones 2-8).