Summarize sales, refunds, and discounts to accurately reconcile financial data. Adjust the time frame and time zone, sort columns, and view country or store details to gain insights.
Adjusting the Query
You can adjust the From, To, and Timezones fields to query for a particular time frame.
- Adjust the From date (All data after this date)
- Adjust the To date (All data before this date)
- Adjust the Timezone offset (Default is UTC time)
- Select
Sorting Columns
All columns are sortable by clicking on the column header. There are three sort states.
- Default: No sort applied
- Descending: Column Header Text is Blue and Arrow is pointed down
- Ascending: Column Header Text is Blue and Arrow is pointed up
Viewing Country Details
Select VIEW DETAILS on any row of data to get a detailed breakdown of a particular country.
Viewing All Countries and Regions
By default, the report shows results for the country or region that you're currently using in Point of Sale CMS. To view all of your countries to compare, select the "Include all countries" checkbox and generate a report..
Download
Based on selected filter conditions, you can also download a CSV file from the top right corner. This provides a CSV extract. This file will have all columns and one row per store per day..
Field Definitions
For a comprehensive list of updated sales terminology and definitions, see the glossary.
Reconciliation Report Known Issues and Restrictions
Understand the limitations of Reconciliation Reports in Point of Sale CMS.
- Queries are limited to a 5-week span.
- BORIS return transactions are tracked in the TLog and Electric Journal Reports. However, they aren't part of the reconciliation report.