Understanding Your Transaction Report
Your Transactions Export contains a wide range of data points about each transaction processed through Facilipay. This article explains what each column represents so you can make the most of the information.
Before You Begin
- You must have already exported a transactions report from the Facilipay Business Portal.
- Open the file in Microsoft Excel or Google Sheets to view the columns.
Column-by-Column Reference
A) ID – The internal system ID used to identify the account associated with the transaction.
B) Date_Add – The date the account was first associated with your business.
C) Date_Edit – The most recent association date or related timestamp depending on your setup.
D) Transaction Type – The category of transaction recorded — for example, purchase, refund, earn, redeem, or adjustment.
E) Loyalty Type – The type of loyalty activity that took place (e.g. points earned, points redeemed, reward issued).
F) Business ID – The internal ID of the business where the transaction occurred.
G) Branch ID – The internal ID of the specific branch (location) tied to the transaction.
H) Group ID – Identifies the business group or organisation a branch or business belongs to (if applicable).
I) Employee ID – The internal ID of the employee associated with the transaction.
J) POS Employee – The employee recorded by the POS system at the time of the transaction (may differ from internal employee ID).
K) Customer ID – The internal ID used to identify the customer who completed the transaction.
L) Refunded – Indicates whether the transaction has been refunded.
M) Voided – Shows whether the transaction was voided in the POS system.
N) Terminal ID – Identifies the terminal or till where the transaction was processed.
O) Smartpoints – The number of points awarded or adjusted during the transaction.
P) Customer Amount – The amount the customer spent in that transaction (usually before loyalty is applied).
Q) Unique Identifier – A system-generated unique value used to track or reference the transaction across systems.
R) Order ID – The POS order number associated with the transaction.
S) Reward Given – Indicates whether a reward was triggered or issued as part of the transaction.
T) User ID – The internal ID of the user profile (the account holder).
U) User First Name – First name of the account holder.
V) User Last Name – Last name of the account holder.
W) Nickname – Any nickname the customer has set on their account.
X) Phone Number – Phone number registered to the customer.
Y) Card Internal ID – The system ID for the loyalty card.
Z) Account ID – The ID of the customer's account within your loyalty platform.
AA) Employee ID – A second employee ID field, may appear if the data source records multiple employee references.
AB) Employee User ID – The user profile ID associated with the employee in your system.
AC) Employee ID – Another employee identifier used for reporting.
AD) Employee First Name – First name of the employee linked to the transaction.
AE) Employee Last Name – Last name of the employee linked to the transaction.
AF) Business Branch ID – Another branch identifier used when multiple systems feed into the same report.
AG) Business Branch Name – The name of the branch where the transaction occurred.
AH) Merchant ID – The merchant's ID within the platform.
AI) Merchant Name – The name of the merchant associated with the transaction.
AJ) Merchant Business Loyalty ID – Unique identifier linking the merchant to its loyalty programme configuration.
Tips & Best Practices
Filter by ID columns: Internal IDs are very useful for cross-referencing transactions across reports.
Use friendly columns for analysis: Columns like Customer Amount, Transaction Type, and Branch Name are most useful for high-level reporting.
Need help? If you're unsure how a column maps to your business operations, contact support@facilipay.io.