Run an orders reconciliation report
With the order reconciliation report, you can view combined payments and orders data in one place, displayed in the same row. The report consolidates order metrics related to sales tax, shipping fees, discounts, and item fees, and payments metrics related to tips and surcharges, so you don't have to create individual reports for each of these categories and merge the data yourself. You can generate an orders reconciliation report through the Dashboard in your web browser.
- Sign in to the Dashboard where you manage your GoDaddy Payments account (use your GoDaddy username and password).
- Select Reports.
- Select Orders Reconciliation Report.
- In the Start and End fields, specify the date range for the report. Otherwise, the last 7 days of data will be loaded by default.
- Under Edit Columns, select the columns you want to have in the report.
- Select Filters, then select the appropriate tab, like Fulfillment Status, Payments Status, or Return Status, and then select checkboxes next to the filters you want to apply.
- Select Export CSV to download the report to your local computer.
Note: We recommend getting familiar with the different metrics we use in our reports to better understand the way they are presented in each report.
The orders reconciliation report gives you a unified understanding of key metrics related to your payments and orders. Here's what you can include in your order fulfillment report:
- Order Number: Reference number for an order placed by a customer
- Order Date: Date the order was placed
- Order subtotal: Sum of the prices of all the items in the order
- Item fee: Additional fees associated with the item
- Taxes total: Sum of sales tax
- Discounts: Discounts applied to the item in the order that reduce the order total
- Shipping fee: Fees you charged to ship the order
- Order total: Sum of order subtotal plus item fees, shipping, sales tax minus discounts
- Order status: Current progress of the order in the order lifecycle
- Fulfillment status: Current state of your commitment to fulfill the order
- Fulfillment date: Date of most recent fulfillment status update
- Payment status: Current state of the payment(s) associated to this order
- Payment date: Date of most recent payment status update
- Canceled date: Date of order cancellation
- Authorized amount: Amount sent to the processor for authorization
- Payment received: Amount you collected as payment for an order
- Refund amount: Total of all refunds issued for an order
- Cash tendered: Physical cash you received as payment for an order
- Change due: Physical cash you returned to the buyer as change
- Debit cash back: Cash‑back transaction where your customer receives physical cash from you and pays for it using a debit card.
- Surcharge amount: Added charge applied to credit‑card payments to cover your payment‑processing fees
- Tip: Tip paid by your customer
- Payment type: Describes the properties of your customer’s chosen payment method (credit card, debit card, Apple Pay, etc.)
- Return subtotal: Total amount of the items returned
- Return shipping amount: Shipping amounts associated with an order return
- Return discount amount: Discounts associated with an order return
- Return item fees amount: Item fee amounts associated with an order return
- Return sales tax amount: Sales tax amounts associated with an order return
- Return total amount: Sum of order return subtotal, return item fees, return shipping, return sales tax minus discounts