This article lists the terms you may find in the Reconciliation section of your End of Day report.
Terms Used in Reconciliation
This is a list of terms found in the new reports. Most of these terms will only show up in the report if the selected date range has items that apply to these terms.
As a precursor, please note that the term 'Deposit' in the reconciliation isn't used to clarify a 'Deposit' as in our version one documents use of deposit. Previously the term was reserved for the deposit feature for menu items in Lavu.
Those types of deposits are considered 'Marked as Deposit', and should appear within the Actual Take In Area. In this case 'Deposit' becomes synonymous with the term Payment.
For (Gift Card), the title displayed depends on what label is applied to the Gift Card payment type. To view more on the gift card payment type please view the following document: Section 5.2: Payment Methods
Payment Mismatch:
The total collected for the payment or refund on an order do not equal the cost of the items on the order. This could be either positive or negative amount(over/under paid).
Example: An order was opened, the payments either result in an over/under payment and the order was forced closed.
Deposits Redeemed:
This term will appear should an order be opened on a previous day with a payment applied and closed on the current date.
For Example: a party has called in and booked an event. They prepay on that date, location leaves the order open until the day of the event is over and closes it out.
Previously Refunded Deposits:
This term will appear should an order with a refund be opened on a previous date and closed at a later date.
Example: An order was opened yesterday and a refund was applied to the payment. However, the order wasn't closed until today.
(Gift Card) Issued For Deposit:
A Gift Card was Issued prior to the date range specified, on an order that was closed within the date range specified.
Example: An order was opened yesterday and a Gift Card was Issued, but the order wasn't closed until today.
(Gift Card) Reload For Deposit:
A Gift Card was Reloaded prior to the date range specified, on an order that was closed within the date range specified.
Example: An order was opened yesterday and a Gift Card was Reloaded, but the order wasn't closed until today.
Payments From The Future:
A payment was made after the date range specified, for an order that was closed within the date range specified.
Example: An order was closed on a previous day and the next date it was reopened and a payment was applied.
Refunds On Payments In The Future:
A Refund was made after the date range specified, for an order that was closed within the date range specified.
Example: An order was closed on a previous day and the next date it was reopened and a payment/refund was applied.
(Gift Card) Issued From The Future:
A Gift Card was Issued after the date range specified, for an order that was closed within the date range specified.
Example: An order was closed on a previous date and at a later date, it was reopened where a Gift Card was Issued.
(Gift Card) Reloaded From The Future:
A Gift Card was Reloaded after the date range specified, for an order that was closed within the date range specified.
Example: An order was closed on a previous date and it was reopened at a later date where a Gift Card was Reloaded.
Deposits Not Yet Redeemed:
A Payment was applied within the date range specified to an order that was opened within the date range specified. However, the order is still open.
Example: An order was opened, a Payment was applied, and the order has yet to be closed.
Refunds on Deposits Not Yet Redeemed:
A Refund was applied within the date range specified to an order that was opened within the date range specified. However, the order is still open.
Example: An order was opened, a Refund was made, and the order has yet to be closed.
(Gift Card) Issued Not Yet Redeemed:
A Gift Card was Issued within the date range specified to an order that was opened within the date range specified. However, the order is still open.
Example: An order was opened, a Gift Card was Issued, and the order has yet to be closed.
(Gift Card) Reloaded Not Yet Redeemed:
A Gift Card was Reloaded within the date range specified to an order that was opened within the date range specified. However, the order is still open.
Example: An order was opened, a Gift Card was Reloaded, and the order has yet to be closed.
Payments On Voided Orders:
An order was voided within the date range specified with a Payment, which is still active, within the date range specified.
Example: An order is processed normally and is then voided without the Payments being voided (likely a backend void).
Refunds On Voided Orders:
An order was voided within the date range specified with a Refund, which is still active, within the date range specified.
Example: An order is processed normally and then it is voided without the Refund being voided (likely a backend void).
(Gift Card) Issued From Voided Orders:
An order was voided within the date range specified with a Gift Card being Issued, which is still active, within the date range specified.
Example: An order is processed normally and then it is voided without the Gift Card Issue being voided (likely a backend void).
(Gift Card) Reloaded From Voided Orders:
An order was voided within the date range specified with a Gift Card being Reloaded, which is still active, within the date range specified.
Example: An order is processed normally and then it is voided without the Gift Card Reload being voided (likely a backend void).
Payments For Past Orders:
A Payment was made within the date range specified on an order that was closed before the date range specified.
Example: An order was closed yesterday, it was reopened today, and a Payment was made to it.
Refunds On Payments For Past Orders:
A Refund was made within the date range specified on an order that was closed before the date range specified.
Example: An order was closed yesterday, it was reopened today, and a Refund was applied to the order.
(Gift Card) Issued For Past Orders:
A Gift Card was Issued within the date range specified on an order that was closed before the date range specified.
Example: An order was closed yesterday, it was reopened today, and a Gift Card was Issued to the order.
(Gift Card) Reloaded For Past Orders:
A Gift Card was Reloaded within the date range specified on an order that was closed before the date range specified.
Example: An order was closed yesterday, it was reopened today, and a Gift Card was Reloaded on it.
Deposits Collected Redeemed In Future:
A Payment was made within the date range specified to an order that was closed after the date range specified.
Example: An order was opened today, a Payment was applied, and the order was closed at a later date.
Refunds Deposits Collected Redeemed In Future:
A refund was made within the date range specified to an order that was closed after the date range specified.
Example: An order was opened today, a Refund was made, but the order was closed at a later date.
(Gift Card) Issued Redeemed In Future:
A Gift Card was Issued within the date range specified to an order that was closed after the date range specified.
Example: An order was opened today, a Gift Card was Issued, and the order was closed at a later date.
(Gift Card) Reloaded Redeemed In Future:
A Gift Card was Reloaded within the date range specified to an order that was closed after the date range specified.
Example: An order was opened today, a Gift Card was Reloaded, and the order was closed at a later date.
FAQ for Report Definitions:
1. What is a Payment mismatch exactly and how would we have a difference of 0.01 cent for this?
Payment mismatch means that the amount paid on an order stub, was not the same as the total collected in payments. If there is a payment mismatch listed on the End of Day Report, it will also list the order id associated with that mismatch. To view more information on the order, click on this order id to see a summary of the check. Most payment mismatches are due to orders that have been closed without a payment or only paid for the partial amount of the ticket.
2. What exactly is a Deposit not yet redeemed amount?
This is a negative amount and so it means that we had more money in than we sold. Deposit Not yet redeemed refers to payments that were received today, but are attributed to an order that has not yet been closed. Ideally, these would show up as an open order on the day it was received. However it could be a payment on an order that was opened any day prior, but the payment was made today. In this case, since the order wasn't opened on the range considered, it won't show up in the open orders section.
3. Where to find open orders on the new reports?
Open orders are listed at the bottom left hand side of the End of day report.