To reconcile your payouts with your transactions you will need to view your Reconciliation Report which can be generated from LOKE Office.
This article will take you through the following
Related articles
- Payout dates from Stripe
- How to schedule or download a report?
- Transactions: Reconciliation
- Reconciling Payments with LOKE
What report should I use?
LOKE offers three reconciliation reports, all built from the same underlying data, but grouping each differently:
| Report | Rows | Transactions dated by |
|---|---|---|
| Reconciliation | One row per location for the whole date range | The day the order was placed |
| Reconciliation by Fulfillment | One row per location for the whole date range | The day the order was fulfilled (picked up, delivered, or completed) |
| Reconciliation by Day | One row per location, per day | The day the order was placed |
Reconciliation gives you a single total for a period, useful for a payout summary.
Reconciliation by Fulfillment uses the same columns as the standard report but counts orders against when they were fulfilled rather than placed. This only makes a difference for orders placed in advance of pickup or delivery.
Reconciliation by Day is the same data as the standard Reconciliation report, just broken into daily rows instead of one total for the period. Totals still add up to match. Use it to reconcile day by day against your POS or bank statements. This is useful if you get daily payouts from Stripe.
A quick note on totals: because Reconciliation and Reconciliation by Fulfillment can count the same order on different days, totals for the same date range may differ slightly between the two, particularly for orders placed near the start or end of your date range. This is expected, not an error.
Date Range for Report Generation
The date range that the report needs to be generated for needs to correlate with the Payout Schedule. This will vary from country to country.
UK - A Payout on Monday for transactions billed on the Thursday through to Wednesday of the previous week (Payout Schedule)
AU - A Payout on Monday for transactions billed on the Friday through to Thursday of the previous week (Payout Schedule).
For further information please see - Payout dates from Stripe and Reconciling Payments with LOKE
If your payout schedule is Thursday through to Wednesday, then ensure that you schedule it early on Thursday before you open up for trade on the Thursday and after closing on the Wednesday.
How do I read the Reconciliation Report?
| Location | Store location. |
| Total Payment | Total value of transactions (from menu, in app and counting credits/discounts). |
| Total Payment + Tips | Total Payment (as above) plus tips. |
| Total Credit/Discount | Credit can refer to credit gifted, credit purchased with points or credit purchased in advance. Discount refers to the lists set up in LOKE Office, e.g. the testing list has a 100% discount. |
| Total Fees | Merchant and LOKE inclusive. |
| Total Payout | Amount you will receive in your bank account. Total Payment + Tips - Credit/discount. |
| Tips | Total tips. |