When you log in to your dashboard, you can go to Operations > End of Service. You will then be able to click on ‘Find payment discrepancies’ and obtain the payments that have not been notified to the POS.
By clicking on the details, you will have access to each transaction that has not been notified to the POS.
Before downloading the file:
Open your POS report (digital or printed)
Verify the dates
Verify the number of payments by tender
Verify the totals
How to read the file:
The file is in CSV format. Import it into your preferred spreadsheet software (Excel, Numbers, Spreadsheet, etc.).
Each row represents a payment.
Start by filtering for problematic statuses (column "reconciliation status"), excluding reconciled and reconciled with the amount only.
Key column descriptions:
"sales amount without tips": Payment amount without tips.
"reconciliation status": Status calculated by the sunday algorithm, indicating a potential discrepancy.
"pos payment method id": Technical ID of the payment method on the POS side (if known by the POS).
"pos payment mean": Label of the payment method according to the POS (if known by the POS).
"pos bill id": Technical ID of the bill on the POS side (if known by the POS).
A bill can also be settled by multiple payments."sunday payment origin" : Type of sunday product associated with the payment. For example PDQ, OP (Order & Pay) or PAT (Pay at Table).
"PDQ fast payment": Was the sunday PDQ payment made using the Fast Payment method?
"sunday bill id": Technical ID of the bill on the sunday side (if known by sunday).
A bill can be settled by multiple payments."sunday payment id": Technical ID of the payment on the sunday side.
Status details:
reconciled: The payment is recognized by both sunday and the POS. The amount and the bill are identical.
reconciled with the amount only: The payment is recognized by both sunday and the POS, but only the amount matches. The bill ID may be missing or incorrect. Example: A "fast payment" via PDQ/Handheld, manually entered into the POS (and possibly not linked to a specific bill).
non reconciled: payment in pos unknown to sunday: The payment is recognized only by sunday. The POS has no record of it, or the amount doesn't match.
non reconciled: sunday payment unknown to pos: The payment is recognized only by the POS. It's not a sunday payment, or the amount doesn't match.
Potential Sources of Discrepancies:
sunday payment not recognized by the POS:
sunday may have captured a payment, but it might not have been notified to the POS. This can happen if the network connection failed or if it was a "Fast Payment" payment through the sunday terminal (PDQ/Handheld).
In the reconciliation file, the status will be:non reconciled: sunday payment unknown to pos.sunday payment attributed to the wrong payment method in the POS:
The payment is recognized by both systems but attributed to the wrong payment method (for example, "Cash" instead of "sunday").
This can happen if a POS user (server, manager) manually assigns the wrong payment method, either during the registration process or afterward.Example: A "fast payment" through the terminal (takeaway, no table) might cause the table to be closed under "Cash".
There could also be an issue with the initial configuration of payment method mappings between sunday and the POS during setup.sunday payment with the wrong amount in the POS:
This may happen when a sunday payment is manually entered (e.g., a takeway without table associated on the sunday terminal) with the wrong amount.
This scenario is rare, as tables generally cannot be closed without the correct total amount. It would require two consecutive errors that cancel each other out for this to occur.Payment recognized by the POS but not by sunday:
In the reconciliation file, the status will be:
non reconciled: payment in pos unknown to sunday.This can happen when a POS user accepts a payment outside of sunday and records it under the "sunday" payment method.
Example: A server collects cash from a table but closes the table using "sunday" as the payment method.
Example 1
Start by filtering for problematic statuses (column "reconciliation status"), excluding
reconciledandreconciled with the amount only.There is only one problematic line: a payment with the status
non reconciled: sunday payment unknown to pos, recognized only by sunday. It is likely a "fast payment" that was not recorded in the POS.To fix this, simply record it manually if your POS allows it.
Example 2
Start by filtering for problematic statuses (column "reconciliation status"), excluding
reconciledandreconciled with the amount only.Compare the totals of payments known only to sunday with those known only to the POS:
6 + 4.50 = 10.50 for
non reconciled: sunday payment unknown to pos10.50 for
non reconciled: payment in pos unknown to sunday
From this, we can deduce that a bill in the POS was settled with two sunday payments but was manually recorded in the POS as a single payment, creating an extra transaction on the sunday side.
To correct this, you can delete the payment in the POS and recreate two separate payments matching the amounts of the sunday payments.
Additional Notes
Regarding tips:
This feature does not yet account for tips, only sales.
Regarding refunds:
Refunds are not yet considered in this version.
About the Sunday terminal:
To minimize discrepancies, reduce the use of "Fast payments" as much as possible. In cases of "fast payments", remember to manually close the table using the correct payment method associated with the Sunday terminal.
A message on the terminal will remind you to register the payment for up to 2 hours.
Compatibility with POS systems:
Not all POS systems are compatible. An error will be displayed upon download if there’s an incompatibility issue.
POS | Status |
CarréPOS | Available |
Cashpad | Available |
Clover | Not Available |
Comtrex | Available |
Ikentoo/Lightspeed | Available |
L'addition | Available |
NCR Aloha (via Omnivore) | Available |
PI Electronique | Not Available |
Positouch | Available |
Res3700 (via Omnivore) | Available |
SIMPHONY (via Omnivore | Available |
Tevalis | Available |
Toast | Available |
Trivec | Available |
Zelty | Available |
Zonal | Not tested |
Other articles :