Understanding the End of Day Report

Report Overview

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 that these transactions are completed before continuing.

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 Sales – 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 Sales – Includes all account top-ups completed via the sales screen, competition entries, and points credit sales. This excludes loyalty credits and account transfers.
• VAT – The VAT displayed in this section represents the total VAT charged across all transactions, including product sales, voucher sales, and account top-ups. For some businesses, there may be a requirement for VAT to be paid upfront on voucher purchases or account top ups.  When these are later redeemed for VAT-applicable products, a VAT adjustment line will appear in the report.  This adjustment ensures that the correct amount of VAT owed is reflected, avoiding any duplication or overstatement of VAT liability.

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 for sales only. For any manual cash movements please also refer to the cash adjustment section for cash in/out.
• 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.
• 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. 

Note: Xeft fees are automatically deducted prior to the transfer of funds to the retailer's bank account. A detailed summary of the total fees deducted is available in the Xeft Transactions Report.

• 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.
• 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.  Trade-in overpayments occur when the value of the trade-in exceeds the sales value. All such overpayments, including any resulting cash payouts, are allocated to the default company.

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

Cash Adjustment

This section records all manual cash entries or withdrawals from the till drawer. 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. Products purchased with points do not appear in this section of the report.

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. A refund of points purchases will see the points sales decrease.

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.

Xeft Fees:

Due to the timings of money being received into the bank, it is not likely that the funds will be deposited into the bank the same day, therefore Xeft fees are not included in the End of Day Report.  It is advised to reconcile Xeft payments using the Xeft Reports found in the End of Day section.