Invoice Backup Data

ShipCalm provides robust invoice backup data. This article will help you to make sense of it.

ShipCalm provides a single backup data file with every invoice that shows a breakdown of every charge that ties directly to ShipCalm's Pricing.

The backup provided is a CSV document attached to every invoice you receive. If you didn't receive a backup data file with your invoice please email accounting@shipcalm.com

Tying backup data to invoice amount

The easiest way to confirm that the backup data aligns to the invoice that you received, you can simply SUM() the column of Charged Amount. This is the amount that ShipCalm charged for that specific line and as such all charges on the invoice are represented in the document.

Pivot on Invoice Line Group

To provide a more granular invoice breakdown our invoices are broken up into a handful of different groupings that include:

Fulfillment
Receiving
Storage
Packaging
Parcel

These groupings are also identified in the Invoice Line Group column. This means that you can create a pivot table of the backup data where the Invoice Line Group is represented as each distinct row, and a SUM() of the Charged Amount is the value.

Definition of columns in data file

If you open the backup data file you will see a series of columns. The table below is meant to be a reference guide for these columns.

General Details	The columns in this section of the backup file contain some general information about the invoice and customer that this backup file is for.
LOB Id	ShipCalm's Internal ID for you as our customer in our ShipCalm WMS platform.
Customer Id	ShipCalm's Internal ID for you as our customer in our billing system.
Invoice Number	The invoice number this charge applies to

Charge Details	The columns in this section of the backup file contain all of the details around a specific charge including what is being billed and the amount that is being billed.
Invoice Line Group	This is the grouping that corresponds to the invoice you received. You can see more details on using this grouping by reviewing the "Pivot on Invoice Line Group" section above.
Invoice Line Code	This is the ShipCalm billing system product code for the specific charges. Each charge outlined on the ShipCalm Pricing article will be reflected here with a unique code.
Description	This is the description of the specific charge type. These descriptions have additional details outlined on the ShipCalm Pricing knowledge base article.
Warehouse	The ShipCalm facility where this charge was incurred.
Base Price	ShipCalm's list price corresponds to the list price associated with that activity at the time that the service was rendered.
Discount Rate	If there are any negotiated discounts on your account for a given item that discount rate will be displayed here.
Discount Price	The final rate that you were charged after discounts have been applied.
Quantity	The quantity of times this particular charge is being applied.
Charged Amount	The final amount that was charged on the invoice for this activity. This is a multiplication of Discount Price * Quantity

Reference Fields	The columns in this section of the backup file contain all of the reference fields if those reference fields apply to a specific charge. Many of these reference fields will be blank on many of the charges that you receive.
Order No	This is the ShipCalm internal Order ID for a transaction
Customer Order No	While sometimes blank, this is the order number that your customer sees on their order. This is typically the order number created by Shopify, Amazon, or whatever sales channel platform took the transaction.
Warehouse Service Type	Warehouse service type that was used to process the fulfillment of a given order. The warehouse service type has a direct impact on the type of charge that was applied to a given fulfillment.
SKU	If there is a SKU for this transaction
Ordered Qty	The quantity of units ordered
Shipped Qty	The quantity of units shipped which should be in alignment with the quantity ordered.
Qty Per Inner	This is a snapshot of the "Quantity Per Inner Pack" field from the Items table in ShipCalm's platform for the SKU above at the time the invoice was generated. This is used to calculate price breaks for inner packs and will be valuable for debugging if you are not getting the price breaks you expect.
Qty Per Case	This is a snapshot of the "Quantity Per Case" field from the Items table in ShipCalm's platform for the SKU above at the time the invoice was generated. This is used to calculate price breaks for inner packs and will be valuable for debugging if you are not getting the price breaks you expect.
Qty Per Pallet	This is a snapshot of the "Quantity Per Pallet" field from the Items table in ShipCalm's platform for the SKU above at the time the invoice was generated. This is used to calculate price breaks for Unaltered Pallets and will be valuable for debugging if you are not getting the price breaks you expect.
ShipCalm Dim Weight	Our calculation of dimensional weight for for this item which is used for Oversized pricing calculations.
ShipCalm Packaging SKU	We have a robust catalog of packaging SKUs that we sell to our customers to fulfill their orders. You can learn more about our packaging prices by reading our Packaging Policies knowledge base article.
Carrier Service	The specific carrier service used to fulfill this shipment that is being charged.
Tracking No	The carrier tracking number associated with the charge.
PO No	PO No associated with an inbound receiving event. This can be found in the ASN table in ShipCalm's platform.
Job Id	The ID that is associated with a specific assembly/kitting job that was run. This can be found in the Jobs table in ShipCalm's platform.
Job Recipe Id	The ID that is associated with a job recipe that defines the instructions for running a specific assembly/kitting job. This can be found in the Job Recipe table in ShipCalm's platform.