Payments table overview
The Payments table offers a lot of information in a condensed amount of space.
Columns 1 -5 are imported from the marketplace.
- Paid On - The date the payment is posted
- Marketplace
- Remittance ID - Note: Not all marketplaces have remittance id's. Ex: Gametime
- Invoice ID
- Payment Amt
Columns 6 -8 are imported from the POS
- POS Invoice No.
- POS Amt - This can be a different value than what's in Payment Amt, which comes from the marketplace
- Trx Date - The date of the original invoice transaction
Columns 9 - 10 help to categorize the transactions.
- Type
- Payment - Payments are associated directly with the sale of the tickets.
- Credit Payment - Payments made from applying credits that your POS currently holds from the cancellations of other events.
- Adjustment - Adjustments can be either positive or negative.
- Fee - Fees refer to marketplace fees.
- Rounding Adjustment - To correct for certain marketplaces that have rounding differences since they calculate beyond two decimal places.
- Status
- Completed - The POS invoice has been successfully updated.
- Pending - The adjustment still requires processing. Adjustments can be cancellations, penalties, or both.
- Not Found - This status still requires processing. The invoice could not be found in the POS. The user must type in the proper POS Invoice No., and Apply Payments.
- Voided - This is a final status whereby TicketUtils has already voided the status in their POS. At this point, we can not update the transaction anymore.
- Skipped - This status means that the invoice was already marked paid when we went to pay it. This status is considered Completed and will not show up under Needs Attention.