Reports Update

We are now delighted to offer you fantastic, new improvements to the End of Day and Cashing Up reports.  

Our teams have worked closely with both retailers and management accountants to agree new content and layout.  As a result, we’re confident the new reports will give you everything you need, and more.

Even though the new reports are more detailed, (your accountants will love them!), they’re easy to understand and use.  At the end of the End of Day report, you’ll also see a new page which offers definitions for the new sections and terms – see below.

To give you time to get used to the NEW reports, you’ll have access to the versions and the original reports for around three months. After that time, access to the older ones will disappear.  

To locate the NEW Cashing Up and End of Day reports, just click on Reports. 

Your Guide to the New End of Day Report

Sales Summary

This section includes all transactions where payment is due. Data is categorised by company and provides a VAT summary for the following:

•   Product Sales – Refers to products created or downloaded from Xcodes that have been assigned to a subgroup. The gross amount includes both sales and refunds.

•   Voucher Purchases – Includes the total value of all vouchers sold or returned, as configured through the Vouchers settings in Xpos. This figure does not include products assigned to the “Vouchers” subgroup. It must be configured as a voucher to be included here.

•   Account Credits – Includes all account top-ups completed via the sales screen, competition entries, and points credit sales. This excludes loyalty credits and account transfers.

Payments Overview

This section outlines all payment types received for sales, grouped into Bankable and Non-Bankable categories.

Bankable Payments

These are funds that can be deposited into a bank account.

•   Cash – Includes all cash payments received and cash refunds issued.

•   Credit Card – Total of all credit card transactions and associated refunds. Xeft is listed as a separate payment type and is excluded from these totals a

•   Debit Card – Includes all debit card payments and refunds. Xeft is listed as a separate payment type and is excluded from these totals.

•   Cheque – Total of cheque payments received. Refunds cannot be issued via cheque.

•   BACS – All BACS payments received, including refunds.

•   Xeft – Total of completed Xeft payments and associated refunds. Incomplete transactions are not included.

•   Third-Party (Bankable) – Includes bankable payments and refunds received through third-party methods configured in Xpos.

Non-Bankable Payments

Payments where funds have already been received and cannot be deposited into a bank account:

  • Account Debit – Total of sales paid via account debit. Any refunds credited back to an account are ‎deducted from this total.
  • Voucher Redemptions – Total value of vouchers redeemed. Vouchers cannot be selected as a refund method.
  • Third-Party (Non-Bankable) – Total of non-bankable third-party payments and refunds, as set up in Xpos.
  • Trade-Ins – Value of all trade-ins processed. Refunds cannot be issued for trade-ins.

Note: The total sales value should always reconcile with the total payments recorded.

Incomplete Sales

An incomplete sale occurs when a payment has been successfully processed through Xeft, but the corresponding transaction has not been finalised in Xpos. The Gross Amount refers to the amount processed via Xeft and may differ from the total basket value. These transactions must be completed to be included in sales reports. We recommend these transactions are completed before continuing.

Cash In/Out

This section records all manual cash entries or withdrawals from the till drawer, categorised by reason. If there’s a discrepancy in the payments section, this area should reconcile those differences. The total from this section is either added to or subtracted from the total cash amount in payments.

Product Sales Analysis

Provides a company-level breakdown of product sales, categorised first by subgroup, then by VAT rate.

Credit Sales Analysis

Detailed breakdown of transactions related to account and voucher activities:

•   Competition Entries – Total value of all competition entries created through Xpos. Refunds cannot be processed for these; however, funds can be withdrawn via an account refund, shown as an account withdrawal.

•   Points Credits – Total value of points sold and credited to customer accounts, including any associated refunds.

•   Account Credits – Sum of all account top-ups credited to customer accounts.

•   Voucher Purchases – Total value of vouchers sold (excluding products assigned to the vouchers subgroup).

•   Refund to Account – Total value of refunds credited back to customer accounts.

•   Account Withdrawals – Total funds withdrawn from customer accounts.

Points Analysis

Summarises the number of points purchased and redeemed. This section is visible only if points accounts are configured in Xpos.

Note: Points withdrawals cannot be processed in Xpos. Refunds on products paid for with points will decrease point redemptions and increase available point balances.

Loyalty, Discounts, and Returns

Breakdown of loyalty-related activities and discounts, organized by company:

  • Loyalty Earned – Total value of loyalty points earned and credited to customer accounts.
  • Loyalty Discount – Loyalty points used as payment are treated as a discount to ensure correct VAT is applied.
  • Discounts – Total value of all discounts applied to products or baskets, including price break discounts.
  • Returns – Total value of refunded products (via sale reversal or within sales transactions). Does not  ‎ ‎ ‎include account credit refunds.

Till Activity

Provides key transaction metrics:

•   Baskets – Number of completed transactions and their gross sales value.

•   Discounted Sales – Count of sales involving discounts and total value of discounts given.

•   Products Returned – Quantity and value of returned products.

•   Products Sold – Total number and gross value of products sold. Products sold excludes: Points, account credits, competition entries, Service products, vouchers.

•   Laid Away Sales – Number of layaway sales and total basket value.

•   Voided Transactions – Quantity and value of cancelled sales.