Skip to content
FMX EPOS
Download
Help Centre home

Use reports, cash records and the audit log

Open Back Office → Reports with an active administrator account. The tabs are Sales & VAT, Item Sales, Category Sales, X/Z Reports, Restaurant, Cash, Tips, Refunds & Voids and Audit Log. Reports group orders, payments, refunds, tips and manual card or membership money by business day, which ends at the store’s Cut-off Time (under Sales Settings → Order Rules), and open on the current business day or month. The Audit Log uses London calendar dates.

  1. Choose the From and To dates.
  2. Under Include in Report, select All Sales, Till Orders or Online Orders, then tick or clear individual order types or platforms if needed.
  3. Under Other Income, include Manual Card and Membership only when that money belongs in this view.
  4. Select Run Report.
  5. Select Export CSV if you need a spreadsheet copy.

Illustration, not a screenshot. The real screen can differ with the theme or version.

Sales Overview shows the store’s own sales, from the till and the website: Gross Sales, Refunds, Net Sales and VAT Included. Payments & Adjustments follows with Cash, Card, website Online payments, Discounts and, when included, Membership Fees. VAT by Rate lists the store’s completed sales by the VAT rate stored on each order, then Store Orders breaks them down by order type and website, and Daily Summary by business date.

When the selection includes any platform, Just Eat and Uber Eats orders follow in their own Platform Orders section: Gross Sales, Refunds, Net Sales, Platform Discounts (included in those sales), VAT Included, Platform Tips & Fees, Platform Collected and Platform Cancelled After Payment, then a row for each platform under Online Platforms and their own Platform VAT by Rate table. Export CSV lists the platform figures after the store’s.

  • Payments include money held on orders not yet settled; sales count only settled orders.
  • The Cash and Card payment figures include money taken at the till for platform orders, although platform sales are not in Sales Overview.
  • Tips are not in sales or refunds.
  • Platform Collected is money the platform owes the store, not cash or card taken at the till. Platform tips and fees are not added to sales.
  • A platform order cancelled after payment stays in sales unless a separate financial event changes it.
  • The platform Refunds figure stays at £0.00. Giving back money the till took for a platform order is recorded as a payment return. On a paid platform order it returns everything the till took, each payment the way it was taken, the order becomes unpaid again, and its sale leaves the platform sales of the business day it was settled: the day it was accepted for an order paid on the platform, or the day it was paid for a Pay at Handover order. An order imported as history keeps the day it was placed. The money shows under Payment returns on the Cash and Card cards.
  • Membership fees are other income, outside Gross Sales and VAT Included. Their VAT is listed by rate in a separate Membership Fees table.
  • While the store is not VAT registered, VAT figures are hidden unless the period still holds VAT.
  1. Open Reports → Item Sales, or Reports → Category Sales to see the same figures by reporting category.
  2. Choose the From and To dates and the Source, then select View Report. Source is All, Store (till and website orders) or Platforms (Just Eat and Uber Eats orders); it starts on All.
  3. Select Export CSV if you need a spreadsheet copy. It follows the source you chose.

Illustration, not a screenshot. The real screen can differ with the theme or version.

Each row shows Quantity Sold, Sales, Refunds and Net Sales, with a total at the bottom. With All, platform orders are included. Sales use the item names and prices saved on the order, after discounts and with any delivery fee shared across the items. Bag fees, service charges and tips are left out. Refunds count on the day they were given. Quantity Sold is counted before refunds, and a weighed or open-price item counts once.

A meal deal is one row, counted in meals, with its items’ value. A second table, Sold in Meal Deals, lists the items inside those meals at their share of the meal price. They are already counted in their meal deals, so that table is not added to the total. A meal’s items all count under the meal deal’s reporting category. X and Z reports count each of a meal’s items as an item of its own, so their item count can be higher than Item Sales.

Each item counts under the reporting category it had when it was sold, so the Category Sales totals match Item Sales. A product’s reporting category is set in Menus → Products; an item without one appears as Uncategorised. Changing a product’s category later does not move past sales.

X and Z reports are run on the till, from Cash & Card → Cash; see Cash movements and daily reports. You cannot run a new report from the Back Office. The X/Z Reports tab lists the saved reports, 50 per page, with each report’s period, orders, net sales, VAT and cash change. Refresh reloads the list.

A report is marked Needs Recalculation when transactions for its period were recorded after it was run, for example work a till saved while it was offline and sent later, or bills uploaded from the Emergency Terminal after a database outage. To bring them in:

  1. Open Reports → X/Z Reports.
  2. Find the report marked Needs Recalculation. Select View if you want to check it first.
  3. Select Recalculate, then Recalculate again in the confirmation. The report keeps its number and period.

Illustration, not a screenshot. The real screen can differ with the theme or version.

The other actions on each row:

  • View opens the report in a window with the same sections as the printout, and its own Print button: the store’s sales with discounts by type and service charge, net sales by order type, takings, a PLATFORMS section with the platform orders’ sales, refunds, Platform Discounts (included), Platform Collected, Platform Tips (less tips given back) and Platform Fees, each platform’s own figures, membership fees, cash movements and the over or short amount from the last cash count, CONTROLS, sales by cashier and by hour, then VAT for the store’s sales and PLATFORM VAT for the platform orders. SALES BY CASHIER credits each order to the cashier who made it fully paid, who may not be the person who started it.
  • Print sends another copy to this terminal’s receipt printer. If it says no receipt printer is selected, choose one under Local Settings → Printers, or redirect the job from Printing → Print Queue.
  • Undo X removes that snapshot; the current period does not change. Its number is not used again: the next X report takes a new one.
  • Undo Z reopens the period so that it includes everything recorded since. Only the latest Z can be undone (the button is greyed out on older ones), so undo any newer Z reports first.

Undoing a report does not delete orders, payments or cash counts, and prints nothing.

Choose the dates and, if needed, an Area (or All Areas) and, in Opened By, the employee who opened the tables (or All Employees). Then select Run Report. The report shows Covers (the final guest count), Table Turns (completed tables), Average Dining Time, Spend per Cover, Spend per Table, Service Charge and Tips.

  1. Choose the From and To dates and select Run Report.
  2. Read Cash Payments, Cash Tips, Total Received, Cash Refunds, Paid In, Paid Out, Net Cash Change and Expected Cash at Period End.
  3. To look into a difference, search Cash Transactions by type, order, staff member or reason, then select Search.

Illustration, not a screenshot. The real screen can differ with the theme or version.

Cash Payments includes cash taken for membership fees and money held on orders not yet settled, and Cash Refunds includes membership fee refunds in cash. Cash Payment Returns appears when cash was given back from an unpaid order. If there is no earlier cash count, Expected Cash at Period End says “No cash baseline; selected period only”. Platform Collected and Platform Cancelled After Payment (platform orders cancelled after they were paid) are shown for reference only; that money is not in the drawer.

  1. Open Reports → Tips.
  2. Choose the From and To dates. To see one person’s tips, choose them under Staff; otherwise leave All Staff.
  3. Select Run Report.
  4. Read Received, Refunded and Net Tips, then Tips by Staff for each person’s figures.

The Tip Records list shows each tip’s Date, Order, Recorded By, Method and Tip, 50 at a time; select Load More to see more. A refunded tip appears as a separate row marked Refund, and the original row stays as it was.

A tip refund is shared between the staff who took the order’s tips before that refund, in proportion to what each tip still holds after the order’s earlier tip refunds; a tip already given back in full takes no share. Each share counts against the person who took the tip, not the person who made the refund, and tips taken after the refund do not change it. When you filter by one person, a shared refund row shows their part, for example “£1.00 of £3.00”. Staff also lists people whose tips were refunded in the period, so you can choose someone who has since left.

  1. Open Reports → Refunds & Voids.
  2. Choose the From and To dates and select View Report.
  3. Select Export CSV if you need a spreadsheet copy.

Illustration, not a screenshot. The real screen can differ with the theme or version.

The report lists completed order refunds and payment returns, unlinked card refunds, membership fee refunds, cancelled items that had already been sent to the kitchen, comps, manual item and order discounts, price changes and delivery fee changes. Each row shows the time and type, the order or table, the cashier and any approving manager, the item and quantity, the method, or the value before and after a change, the amount and the reason. A refund’s amount is the money given back; a change’s amount is what it took off the bill. Rows are flagged Cross-tender when money went back by a different method, and Unlinked / Manual Card for every card refund: the till’s card refunds are made on the card terminal as manual refunds, not as reversals of the original card payment, and the flag also marks card refunds not linked to an order and refunds recorded by hand. Voids, comps and price changes do not refund any money.

Every manual change is listed, even one that was later undone. Once an order is paid, the price change that set an item’s final price shows what the item lost from its price before its first change, and its Change ends with that starting price, for example “£8.00 → £6.00 (from £10.00)” with £4.00. Earlier changes to the same item, and changes to an item that was removed or set back to its price, are marked Not in effect. An item split into single items, or moved onto another table’s bill by merging the tables, keeps its earlier changes: each part counts, and the change shows their amounts together. Changes on an order that is not paid yet are marked Not settled. Export CSV has an Effect column with In effect, Not in effect or Not settled.

A comp is an item or order that staff make free by hand: a 100% Item Discount or Order Discount, a price changed to £0.00, or Comp on a table item already sent to the kitchen. Where comps show up:

  • Refunds & Voids lists each comp with the type Comp, the value before and after, the value given away and any approving manager.
  • Discounts on Sales & VAT includes every comp made with a 100% discount.
  • A price changed to £0.00 is not a discount; the item counts as a £0.00 sale.
  • The Audit Log records every manager approval, comps included, with the manager who gave it.

X and Z reports show comps in two places. Comps under DISCOUNTS BY TYPE is the value of 100% item and order discounts. Comps at £0 under CONTROLS counts the items whose final price was changed to £0.00 and the value they took off; those are not in Price Changes. Price Changes counts, once an order is paid, each item whose final price was changed by hand, for what the item lost from its price before its first change (a negative amount when it was made dearer). It counts in the period in which the order is paid, whenever the change was made. An item removed or set back to its price counts nothing, an order cancelled before payment counts none, and delivery fee changes never count. For how staff apply a comp at the till, see Take an order.

  1. Open Reports → Audit Log.
  2. Choose the From and To dates (London calendar dates). The tab opens on the last seven days.
  3. In Search, enter an action, entity or identifier, then select Search.
  4. Select View in the Details column to see what was recorded, and Hide to close it.

Illustration, not a screenshot. The real screen can differ with the theme or version.

The audit log cannot be edited. It records business and administrator actions, including running and undoing reports, receipt reprints, configuration changes, manager approvals and payment review decisions. It is a record only: nothing can be reversed from it.

  • Check that the date range covers the business days you meant, given the Cut-off Time.
  • Check the selected order types, platforms and other income.
  • Look for a Needs Recalculation marker on an X/Z report.
  • Check Orders → Payment Review for unknown card results or Local Writes Needing Review.
  • Check Reports → Audit Log for a correction, undo or settings change.
  • In Diagnostics, check the Database and Continuity cards. Sort out an unresolved payment or sync problem first; running a new report does not fix it.