Unreferenced Refunds

Use Case Description

  • A guest returns without the original receipt and asks for a refund.

  • The manager rings in a new check with a negative service charge and closes it to a credit card provided by the customer (this may not even be the same credit card used to make the original payment).
    • Check Total: -10.00

    • Tip Total: 0.00

    • Payment Total: -10.00

Export or BI API Results

  • Results when collected on Tuesday 08/06/2024. 

    Table 10-29 Payment Transaction Details

    Payment ID

    Payment Detail ID

    Business Date

    Adjustment Business Date

    Transaction Date and Time

    PSP Reference

    Check Number

    Guest Check Detail ID

    Payment Type

    Transaction Amount

    Tip Amount

    123450

    123456780

    08/05/2024

    08/05/2024

    08/05/2024 8:00AM

    AB88000000CD000001

    1234

    1234567890

    REFUND

    -10.00

    0.00

  • Results when collected on Wednesday 08/07/2024.

    Table 10-30 Payment Settlement Details

    Payment ID

    Payment Detail ID

    PSP Reference

    Business Date

    Settlement Date

    Journal Type

    Card Present Fee

    Card Present Rate

    Settlement Amount

    Is Referenced

    123450

    123456780

    AB88000000CD000001

    08/05/2024

    08/07/2024

    REFUNDED

    0.15

    0.20

    -10.00

    2

    QA to verify

  • Results when collected on Thursday 08/08/2024.

    Table 10-31 Payment Payout Details

    Payment ID

    Payment Detail ID

    PSP Reference

    Business Date

    Journal Type

    Payout Amount

    Transaction Payout PSP Reference

    Fee Payout PSP Reference

    Oracle Fees

    123450

    123456780

    AB88000000CD000001

    08/05/2024

    REFUNDED

    -10.35

    EF99000000XY000002

    QA to verify

    EF99000000XY000002

    QA to verify

    0.35

    QA to verify

    Table 10-32 Payment Payout Summary

    Payout PSP Reference

    Batch Payout Date

    Batch Payout Date and Time

    Batch Payout Currency

    Batch Payout Amount

    EF99000000XY000002

    08/08/2024

    08/08/2024 9:30AM EST

    USD

    1000.00

Payment Tracking Report

  • Payment Tracking Report run on Monday 08/05/2024 at 8:05 a.m. for business date 08/05/2024.
    • Tender Amount: -10.00

    • Everything else is empty or 0 (also pending amount)

  • Payment Tracking Report run on Wednesday 08/07/2024 at 2:00 p.m. for business date 08/05/2024.
    • Tender Amount: -10.00

    • Settled Amount: -10.00

    • Variance Settled to Tender: 0.00

    • Fee Amount: 0.35 (= applicable variable rate + fixed fee = 2% of 10.00 + 0.15)

    • Expected Payout: -10.35

    • Payout Amount: empty

    • Variance Payout to Expected: empty

  • Payment Tracking Report run on Thursday 08/08/2024 at 2:00 p.m. for business date 08/05/2024.
    • Tender Amount: -10.00

    • Settled Amount: -10.00

    • Variance Settled to Tender: 0.00

    • Fee Amount: 0.35 (= applicable variable rate + fixed fee = 2% of 10.00 + 0.15)

    • Expected Payout: -10.35

    • Payout Amount: -10.35

    • Variance Payout to Expected: 0.00