Payment Gateway
- 28 Jun 2023
- 3 Minutes to read
- Print
- DarkLight
- PDF
Payment Gateway
- Updated on 28 Jun 2023
- 3 Minutes to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
The Payment Gateway report is the only WineDirect report designed to reconcile order transactions with your payment gateway/merchant provider. The Payment Gateway report is also the only WineDirect report focused on the payment dates & times for orders. Also, this report does not include cash or check transactions. An alternative is the Payment Type Summary report generated by a Completed Status.
Positive order transactions will appear in black with positive numbers. Refunds will appear in red with negative numbers. So an order may appear twice in the report: once for the original positive transaction and once for the refunded/voided negative transaction.
Because this report is the only report focused on payment dates & times, your date range parameters will not match up with words other than reports such as the Order Detail, Sales Summary By Product or the Orders By Ship/Pickup Date reports. All other words, look at the order date, not the payment date, so orders that took payment in a month other than the month they were placed will not match between reports.
Running The Report
1. Go to Reports > Financial > Payment Gateway.
2. Adjust the dates, or click Manage Filters and Manage Reports Columns to customize your report.
3. Click Export to queue your report for download. It will be emailed to you when ready. You can also Save As or click Actions > Schedule to schedule your report to generate regularly.
Here are the definitions of what will populate your Payment Gateway report:
| Website | The website the purchase originated from. |
|---|---|
| Type | What type of order it is. (website, club orders, admin panel) |
| Payment Date | The date the payment was made. (MM/DD/YY) |
| Payment Time | The time the order was placed. (12:00 am/12:00 pm) |
| Payment Status | Status of the payment. (Refunded, Captured, Purchased) |
| Amount | The amount of the order. |
| Transaction Type | Transaction type is chosen in Corporate Batch. |
| Transaction ID | The payment gateway assigns the transaction number. (merchant account) |
| Card Type | The type of card used for the transaction. (Visa/MasterCard/AmericanExpress/Discovery) |
| Card Number | The number of the card used for the transaction. (XXXX XXXX XXXX 5454) This is encrypted; only the last four digits will be visible. |
| Expiry Month | The month that the card expires. (MM) |
| Expiry Year | The year that the card expires. (YYYY) |
| Order Number | The number assigned to an order by the admin panel. |
| Alt Order Number | The order number for an order passed into WineDirect from another system (RMS, Amazon, etc.). This will only populate for orders passed to WineDirect through web services and cannot be manually added to an order. |
| Submitted Date | The date that the order was placed. |
| Submitted Time | The timestamp of when the order was placed. |
| Completed Date | The date that the order was finalized. |
| Completed Time | The timestamp of when the order was finalized. |
| Bill Name | Full name of the customer that is being billed. |
| Bill First Name | First name of the customer that is being billed. |
| Bill Last Name | Last name of the customer that is being billed. |
| Bill Address | Address of the customer that is being billed. |
| Bill City | A city that the customer being billed lives in. (XX) Ex: California - CA |
| Bill State | State that the customer being billed lives in. (XX) Ex: California - CA |
| Bill Zip | Zip code/Postal of the customer that is being billed. |
| Bill Phone | Phone number of the customer that is being billed. |
| Bill Email | Email address of the customer that is being billed. |
| Ship First Name | First name of the customer that the order is being shipped to. |
| Ship Last Name | Last name of the customer that the order is being shipped to. |
| Ship Address | Address of the customer that the order is being shipped. |
| Ship City | A city that the customer lives in that the order is being shipped to. |
| Ship State | State that the customer lives where the order is being shipped to. (XX) Ex: California - CA |
| Ship Zip | Zip code/Postal of the customer that the order is being shipped to. |
| Ship Phone | Phone number of the customer to whom the order is being shipped. |
| Ship Email | Email address of the customer that the order is being shipped. |
| Subtotal | Subtotal of the order, before taxes and shipping/handling. |
| Deposit | If there is a bottle deposit on the product(s) *(Canadian customers only) |
| Shipping | The total amount of shipping. |
| Handling | The total amount of handling. |
| Taxes | The total amount of tax. |
| Total | Total of sale including tax, shipping/handling. |
| Tip | Amount of tips paid on order. |
| Total After Tip | Total sale, including tax, shipping/handling, and tips. |
| Sales Associate | If there is a sales associate assigned to the order. |
| Sales Attributes | Sales attribute applied to this order. (Only applicable if Admin Panel or iPad POS order) |
| Club | The Club, the customer, belongs to. |
| Club Shipment | If there is a Club Shipment name for this purchase. |
| Corporate Batch # | The corporate batch number for this purchase. |
| Source | If you are using source codes to tag orders. |
| Last Modified Date | The date of the previous time modifications was made to order. |
Was this article helpful?
