Next Day Complete Refund Using "Re-open closed check" and Void

Use Case Description

  • A guest check is paid in full by credit card using a terminal, on day 0 (Monday 08/05/2024) at 8:00 a.m. EST

    • Check Total: 45.00

    • Tip Total: 5.00

    • Payment Total: 50.00

  • A void of the original 50.00 tender is done on day 1 (Tuesday 08/06/2024) at 2:00 p.m. EST.

    • Check Total: 45.00

    • Tip Total: 5.00

    • Original Payment Total: 50.00

    • Void: 50.00

    • New Payment Total: 0.00

Export or BI API Results

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

    Table 10-20 Payment Transaction Details 

    Payment ID

    Payment Detail ID

    Business Date

    Adjustment Business Date

    Transaction Date and Time

    PSP Reference

    Check Number

    Guest Check Line Item ID

    Payment Type

    Tip Amount

    Transaction Amount

    123450

    123456780

    08/05/2024

    08/05/2024

    08/05/2024 8:00AM

    AB88000000CD000001

    1234

    1234567890

    PAY

    5.00

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

    Table 10-21 Payment Settlement Details

    Payment ID

    Payment Detail ID

    PSP Reference

    Business Date

    Settlement Date

    Journal Type

    Card Present Fee

    Card Present Rate

    Settlement Amount

    123450

    123456780

    AB88000000CD000001

    08/05/2024

    08/06/2024

    SETTLED

    0.15

    1.00

    50.00
     

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

    Table 10-22 Payment Settlement Details

    Payment ID

    Payment Detail ID

    PSP Reference

    Business Date

    Settlement Date

    Journal Type

    Card Present Fee

    Card Present Rate

    Settlement Amount

    123450

    123456781

    AB88000000CD000001

    08/05/2024

    08/07/2024

    REFUNDED

    0.15

    1.00

    -50.00

    Table 10-23 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

    SETTLED

    48.85

    EF99000000XY000001

    EF99000000XY000001

    1.15

    Table 10-24 Payment Payout Summary

    Payout PSP Reference

    Batch Payout Date

    Batch Payout Date and Time

    Batch Payout Currency

    Batch Payout Amount

    Withheld Amount

    EF99000000XY000001

    08/08/2024

    08/08/2024 9:30AM EST

    USD

    1000.00

    0.00

  • Results when collected on Friday 08/09/2024.

    Table 10-25 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

    123456781

    AB88000000CD000001

    08/05/2024

    REFUNDED

    -48.85

    EF99000000XY000002

    <null>

    0.00

    Table 10-26 Payment Payout Summary 

    Payout PSP Reference

    Batch Payout Date

    Batch Payout Date and Time

    Batch Payout Currency

    Batch Payout Amount

    EF99000000XY000002

    08/09/2024

    08/09/2024 9:30AM EST

    USD

    1000.00

  • Results when collected on Saturday 08/10/2024.

    Table 10-27 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

    123456781

    AB88000000CD000001

    08/05/2024

    REFUNDED

    -51.15

    EF99000000XY000002

    EF99000000XY000003

    1.15

    Note:

    This export row with Payment Detail ID 123456781 is an update to yesterday's export row. It now includes the 1.15 fee for the refund transaction. The payment amount is a new total.

    Downstream systems should update the -48.85 payout amount with the new updated payout amount of -51.15 (instead of keeping both rows which would incorrectly sum to a payout total of -98.85).

    Table 10-28 Payment Payout Summary

    Payout PSP Reference

    Batch Payout Date

    Batch Payout Date and Time

    Batch Payout Currency

    Batch Payout Amount

    EF99000000XY000003

    08/10/2024

    08/10/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: 50.00

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

  • Payment Tracking Report run on Tuesday 08/06/2024 at 2:05 p.m. for business date 08/05/2024.

    • Tender Amount: 0.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: 0.00

    • Settled Amount: 50.00

    • Variance Settled to Tender: 50.00

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

    • Expected Payout: 48.85

    • Payout Amount: empty

    • Variance Payout to Expected: empty

  • Payment Tracking Report run on Thursday 08/08/2024 at 8:05 a.m. for business date 08/05/2024.

    • Tender Amount: 0.00

    • Settled Amount: 0.00

    • Variance Settled to Tender: 0.00

    • Fee Amount: 2.30 (= 2 x applicable variable rate + fixed fee = 2% of 50.00 + 0.15)

    • Expected Payout: -2.30

    • Payout Amount: 48.85

    • Variance Payout to Expected: -51.15

  • Payment Tracking Report run on Friday 08/09/2024 at 8:05 a.m. for business date 08/05/2024.

    • Tender Amount: 0.00

    • Settled Amount: 0.00

    • Variance Settled to Tender: 0.00

    • Fee Amount: 2.30 (= 2 x applicable variable rate + fixed fee = 2% of 50.00 + 0.15)

    • Expected Payout: -2.30

    • Payout Amount: -2.30

    • Variance Payout to Expected: 0.00