- Old Reports
- Sales
- Payment Report
Payment Report
This page documents an older/sunset version of our reporting tools - for documentation on the latest version click here.
The Payment Report is the only Vin65 report designed to be used to reconcile order transactions with your payment gateway/merchant provider. The Payment Report is also the only Vin65 report focused on the payment dates & times for orders. Also, this report does not include cash or check transactions. An alternative to this is the Sales by Tender Type Report when generated by a Completed Status.
Positive order transactions will appear in black with positive numbers. Refunds will appear in 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 reports other reports such as the Sales Detail, Sales By SKU, or the Sales By Date reports. All other reports are looking 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.
Reports export in .CSV format.
Here are the definitions of what will populate in your Payment report:
| Website | The website the purchase originated from. |
|---|---|
| Type | What type of order it is. (website, club order, admin panel) |
| Payment Date | The date the payment was made. (MM/DD/YYYY) |
| Payment Time | The time the order was placed. (12:00am/12:00pm) |
| Payment Status | Status of the payment. (Refunded, Captured, Purchased) |
| Amount | The amount of the order. |
| Transaction Type | Transaction type chosen in Corporate Batch. |
| Transaction ID | The transaction number assigned by the payment gateway. (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 4 numbers 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 Vin65 from another system (RMS, Amazon, etc). This will only populate for orders passed to Vin65 through webservices 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 | 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 to. |
| Ship City | City that the customer lives in that the order is being shipped to. |
| Ship State | State that the customer lives in 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 that the order is being shipped to. |
| Ship Email | Email address of the customer that the order is being shipped to. |
| Subtotal | Subtotal of the order, before taxes and shipping/handling. |
| Deposit | If there is a bottle deposit on product(s) *(Canadian customers only) |
| Shipping | Total amount of shipping. |
| Handling | Total amount of handling. |
| Taxes | Total amount of tax. |
| Total | Total of sale including tax, shipping/handling. |
| Tip | Amount of tips paid on the order. |
| Total After Tip | Total of 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 last time modifications were made to an order. |