Sales Reconciliation

This report consists of detailed Sales and Returns information; almost every data field associated with a sale or return exists in this report. 

Date: Date the transaction occurs.
Value: USD value.
Qty: Quantity of the sale, return, or adjustment.
HQ Account Number: Headquarter Account Number linked to the Headquarter name.
Headquarter: The customer's headquarter name.
EAN: 13-digit code used to identify the product (ISBN).
Title: Title
Author: Author
List Amount: The current list price of the title in USD.
Format: – Examples:
Paperback / Softback
Hardback
Multiple Copy Pack
Spiral Bound
CD-Audio
Digital (Delivered Electronically)
Mobipocket
Digital Download
Epub
Ebook
PDF
Medium: Physical, Digital, and All.
Unit/Carton Disposition: Instructions for how to handle the unit or carton return of a product. The code values are: C - Categorized Remainder, D - Destroy and R- Restock.
Pub Date: From CoreSource, publisher defined expected date for product to be available.
Release Date: The date initial new title backorders are released to the warehouse for fulfillment.
Brand Categories: Publisher defined category set up through the client manager and maintained in TMS.
Pub Number: Publisher number at Ingram.
Pub Alpha: A code at Ingram used to link Imprints/Publishers to the publisher number.
Imprint: Imprint
Invoice / Credit Memo Number: Ingram creates POs or Credit Memos as an order is processed or returned.
Customer PO / Claim Number:The purchase order created by the customer when placing the order to Ingram or a claim number created by the customer to report discrepancies to Ingram.                          Type: Sales, Returns, and Adjustments
Adjustment Indicator: Indicator of any adjustments made to sales and returns.
Adjustment Codes:
R = Rerurn
S = Sale
B = BuyBack / Inventory conversion
N = Not an Adjustment
Class of Trade Code: The 2-character code value for the SL Cass of Trade. Examples:
CA: Catalog and Direct Response
CD: Canadian RDC
CG: Canadian Retail Internet Gold
CT: Canadian Trade
HE: Higher Education
I8: International Retail Internet Gold EU
IR: Independent Regional Distribution Center
NR: Other
RG: Retail Internet Gold
RT: Retail Trade Bookstore
WH: Wholesaler
SL Class of Trade: Examples:
Catalog and Direct Response
Canadian RDC
Canadian Retail Internet Gold
Canadian Trade
Higher Education
Library
International Other
Gift Retailer
Retail Trade Bookstore
Retail Distribution Center
Retail Internet
Retail Internet Gold
Retail Specialty Store
Retail 90
Wholesaler
Specialty Wholesaler
Territory: Examples:
National
Publisher Account
Field Sales
Gift
Canada
Retailer
Wholesaler
Trade
Library
Distributor
Independent Publishers
International
Special
Printer
Content Aggregators
Customer Discount: The discount percentage the customer receives for an item.
Bill To: An Ingram assigned Billing Account number linked to the Bill To Name and address.
Bill To Name: Bill To Name.
Bill To City: Billing location city.
Bill to ST: Billing location state.
Bill to Zip or Postal Code: Billing location zip or Postal Code.
Bill To Country: Billing location country.
Bill To Region: Billing location region.
Ship To: An Ingram assigned account number.
SL Account: An Ingram account number assigned to a customer’s shipping address. (Shipping Location).
Shipping Location: Shipping Location where product is shipped.
SL Street: Shipping Location Street name.
SL Street Line 1: Additional Shipping Location street information.
SL ST: Shipping Location State.
SL Zip or Postal Code: Shipping Location Zip or Postal Code.
SL Region: The contractual sales region assignment for international, domestic and Canada customers Shipping Location.
SL IPS Sales Region: The contractual sales region assignment for international, domestic and Canada customers.
Destination Region: This region is based on the destination country (regions are: USD, Canada, or International).
eCommerce Sale Ind: This is a Yes / No flag if the order is an eCommerce sale.
eCommerce Ind: Examples:
EPBS – External Print Book
TASC – Taschan
ECOM – remaining items not defined as EPBS or ECOM.
Direct Fulfillment: This is a Yes / No flag if the order includes or excludes Direct Fulfillment.
DF Type of Order: Direct Fulfillment Type of Order. This is from the iPage entered Direct Fulfillment order information.
DC: Distribution Centers:
CI - CHAMBERSBURG - Chambersburg, PA
DD - FT WAYNE – Ft. Wayne, IN
NV - NASHVILLE – La Vergne, TN
LL – CHAMBERSBURG RETURNS, Chambersburg, PA.

You may export to Excel or a CSV (comma separated value) file.