New reconciliation by shipping level report

What is the enhanced reconciliation report?

The Amazon Business reconciliation report now gives finance and procurement teams two ways to reconcile: by payment transaction with the Reconciliation report, or by shipment line item with the Reconciliation by shipment level report. Match transactions to orders and download the data in CSV to close your books quickly and accurately.

How does it work?

The Reconciliation by shipment level report provides full line-item reconciliation with 75 columns and 41 net-new fields. Access data including:

• Charges and refunds

• Charge Identifier (now shown by default)

• Line-item and shipment-level detail (ship date, shipment status, ASIN, product title, UNSPSC hierarchy)

• Full pricing breakdown (unit price, item subtotal, shipping, promotions, regulatory fees, tax rate, net total)

• Invoice and credit memo info (document issue date, statement number, invoice due date, document status)

• Shipping and recipient detail (recipient name, shipping address, delivery status, receiving status)

• Return and refund detail (refund reason, restocking fees, return shipping fees with tax)

• Product info (ASIN, title, full UNSPSC hierarchy)

• Seller info (seller name, tax registration number, e-invoice transaction status)

• Savings info (pricing savings program and discount applied)

• Organization-specific fields (GL code, cost center, department, project code, location, and up to 13 custom fields)

   

Similar to other Amazon Business Analytics reports, account administrators can customize the reconciliation report, adding and adjusting columns to include the details they need. Once customized, administrators can add a title and save their report for future use.

Where is the enhanced reconciliation report available?

The Reconciliation by shipment level report is available in the US, UK, FR, DE, IT, ES and rolling out worldwide through 2026.

To access it, visit Business Analytics, and under the Reports dropdown menu, choose from the two reconciliation reports: Reconciliation, for reconciling by payment transaction, or Reconciliation by shipment level, for line-item detail. Use whichever fits your process, or both for different workflows.

Visit the blog post to learn more.