POS Reports

From POS using a manager code go to functions then Reports

Select Property or The Coffee Club RVC Report

Select the Date Range

Gift Card Issue (GC ISSUE) can be found the very bottom of the report under Service Chg.

This is what you will receive an invoice from finance based on the sum of the Entire Trading week.

Gift Card Issues

To reconcile the purchase of Gift Cards, use the Bank Due section of POS report.

This will give a breakdown of payment type when a Gift Card is purchased i.e. Cash or EFTPOS

If you are using the Daily Sales envelope you will need to add the “Gift Card Issue” amount, as outlined above, to Total Revenue. This can then be use with Tender Types to reconcile total payments breakdown of

Gift Card Redemptions

• From POS using a manager code go to Reports

• Select RVC report or Property Financial Report

• Scroll down to the Bank Due section

Redemptions of Gift Cards will Display as GIFT CARD REDEEM.

Reporting & Analytics Report

Login into Reporting & Analytics

https://mdkl-omra.oracleindustry.com

Select My Reports along the top

Expand Card Activity

Select Program Activity

Select Edit Parameters to adjust the date (Default is most recent)

Use the existing quick select i.e. Yesterday, Last etc or use Advanced

Select the date on the Calendar to Select multiple ranges hold down Ctrl and click

To select Full Week, click on the week number

Multiple weeks / Months can be selected by holding down Ctrl and clicking

Click apply followed by Run.

Gift Cards will display as PHYSICAL_GIFT_CARD or DIGITAL_GIFT_CARD

Old Wallet Accounts as LEGACY WALLET REEDEM

• To look at specific details of the Gift Card please click on the Underline PHYSICAL_GIFT_CARD

• This will then provide a summary by Store for any store you have access to.

• Select the Underline Store Name twice to see details per day.

This will display the following.

• Redeems as Negative. Under Redeem Column

• Issues as Positive under Issues Column.

Accounts Invoices & Credits

Invoices

Gift Card Purchase

You will receive an invoice for every Issue that occurs within a full week. Monday to Sunday

The invoice will show you the following;

• W/E Date its is from in the Description field.

• Total Number of Gift Cards sold Physical & Digital (QTY)

• Unit Price can be ignored as not relevant as its just Amount / QTY

• Amount is the Total in Gross Sales which

Accounts Invoices & Credits

Credit Notes

Gift Card Redemptions

You will receive an credit invoice for every Redemptions that occurs within a full week. Monday to Sunday

The invoice will show you the following.

• W/E Date its is from in the Description field.

• Total Number of Gift Cards sold Physical & Digital (QTY)

• Unit Price can be ignored as not relevant as its just Amount / QTY

• Amount is the Total in Gross Sales which

FAQs

Answers

Can I change a card once I have loaded it if I made a mistake?

Yes.  Only if you have not proceeded to final payment if you have yet to pay you can use the SEND button and then reopen and VOID the gift card.

Open

If you have tendered it off, you need to redeem the amount of a new transaction and use this to pay the new card.  (Dispose of Card)

Ensure you use decimal points

Can I void a redeemed Gift Card?

No.  All gift card payments are final.

What’s the maximum that can be loaded on a gift card?

$100

Can I redeem multiple gift cards on an order?

Yes, multiple gift cards can be used

Can I use a Gift card to buy a Gift card

Yes, A Gift card is classified as a tender and can be used to buy other Gift Cards.

Can a Gift card be reloaded?

No, a gift card cannot be reloaded in our configuration.