What does the reconciliation report contain?

 

Reconciliation Report

The reconciliation reports allow users to check the differences between the total sales reported at the delivery network and the successful orders placed on the POS, including refunds, POS failed orders, and all delivery network adjustments.

We have automatized the delivery network reconciliation, and on each delivery network payout the transactions will be injected on the POS and the transaction can be monitored on the back-office at the Order Monitor tab.

Back-office

You can access it in the Order Monitor tab of Maegan back-office: https://backoffice.maegan.co/

1. Select the brand, e.g. "Thai Express [EM]", or a specific location
   
   
   
   
2. The reconciliation card shows some useful information to help the franchisees identify transactions:
   
   
   1. 1. Reconciliation icon with the order number – the number can be traced in the POS
      2. Delivery Network name and type of transaction (debit or credit)
      3. Transaction date
      4. Transaction order number- from the delivery networks reports along with the delivery network payout date
      5. Tacit Order ID
      6. Type of transaction – debit (negative transactions) or credit (positive transactions)
      7. Transaction value (it will only appear on the Order Monitor as a positive transaction - either if is a credit or debit)

To verify the details of the transactions, you can access the Operations tab of Maegan, then select the Delivery Network:

1. Select the brand, e.g. "Thai Express [EM]", or a specific location
2. Once the list loads - select the button "Reconciliation"

The general overview will present by payout date all the transactions by each Delivery Network platform.

The data are reported in weekly portions, grouped by payout dates. 

The data can be presented as

• “Uncombined”  - all data available within the set period of time

• “Aggregated” - summarized by the payout dates

To change the view, click on the dropdown list as shown in the image below:

In the “Uncombined” view, for each line detailed info per transaction is available. 

In the general view we have the following columns available:

• Delivery Network: platform, for which the report is generated; can be filtered by platform, or display all integrated platforms.

• Store: Store ID and name

• Delivery Sales Total: total sales reported from the delivery network.

• POS Sale: a total of successful sales processed on the POS.

• Reconciliation amount: delivery network payout amount after all service charges and fees are applied.

• Payout Amount: total payout to restaurant from delivery network after delivery network fees

• Payout Date: date of the transaction - it matches with the delivery network's payout dates.  

• POS Transaction: the amount injected in the POS for reconciliation

• Credit (positive value): the delivery network charges more than the order processed by the POS and needs to be paid back to the restaurant.

• Debit (negative value): the delivery network charges less than the order processed by the POS and needs to receive the value from the restaurant.

• Actions: redirects to the detailed report with all the transactions within that payout transaction

Viewing details per report line

In the detailed mode, each order is specified, including: 

• UberEats Order ID: order ID from the delivery platform

• POS Order ID: order ID on the POS

• UberEats Sales: sale amount reported by the delivery platform

• POS Sales: sale amount captured on the POS

• POS Fail: amount for orders, which did not go through to the POS due to POS failures

• Reconciliation Amount: the difference between the delivery platform and POS sale amounts for a specific order

  • positive - the amount outstanding from the delivery platform 

  • negative - the amount owed to the delivery platform

• Reconciliation status: identification of the mismatched amount